Function or procedure example in custom.pll file for sales order

Dear,

We have a requirement for showing a pop up msg based on the sql query which is not achievable as an immediate effect by various event triggers by form personalization r12.1.3

so as an example I saw the code in pll file as below. But the function name DEM_DEMXXEOR is not existing in system. do anyone have the similar code or any other code contains function or procedure with sql query

if (event_name = 'ZOOM') then  <br/>

 if (form_name = 'DEMXXEOR' and block_name = 'ORDERS')<br/>            then<br/>            param_to_pass1 := name_in('ORDERS.order_id');<br/>            param_to_pass2 := name_in('ORDERS.customer_name');<br/>