Please create a PL$/$SQL function that does the following:

search for job posts. The input includes a keyword, job type $($full time or part time$),$ and a state. The procedure does the following:

$1)$ It finds all job posts that are active and the job title or job description has a substring that matches the input keyword, and the job post's state and job type match the input state and job type. The procedure prints out the matching job posts' job post id$,$ associated company name, job title, description, min and max pay, city and state.

$2)$ In case there are no matching job posts, print out $\text{'}$No job posts found'.

Hint: to match a substring in the procedure, use

where column$\_$name like $\text{'}\%\text{'}||$ input$\_$keyword $||\text{'}\%\text{'}$