How to find personalizations in which form

--Query 1. Simple list of form personalizations, ordered by form
SELECT form_name Form, function_name Function, description Description,
   sequence Seq, trigger_event TriggerEvent, trigger_object TriggerObject,
   condition Condition, enabled
FROM fnd_form_custom_rules
ORDER BY form_name, function_name, sequence

--- Query 2. List of ALL OA Framework-based pages with Personalizations
SELECT PATH.PATH_DOCID PERZ_DOC_ID, jdr_mds_internal.getdocumentname(PATH.PATH_DOCID) PERZ_DOC_PATH
FROM JDR_PATHS PATH
WHERE PATH.PATH_DOCID IN
   (SELECT DISTINCT COMP_DOCID FROM JDR_COMPONENTS
   WHERE COMP_SEQ = 0 AND COMP_ELEMENT = 'customization'
   AND COMP_ID IS NULL)
ORDER BY PERZ_DOC_PATH

---Query 3. List of personalizations created at the customer site
SELECT PATH.PATH_DOCID PERZ_DOC_ID,
   jdr_mds_internal.getdocumentname(PATH.PATH_DOCID) PERZ_DOC_PATH
FROM JDR_PATHS PATH
WHERE PATH.PATH_DOCID IN
   (SELECT DISTINCT COMP_DOCID FROM JDR_COMPONENTS
   WHERE COMP_SEQ = 0 AND COMP_ELEMENT = 'customization'
   AND COMP_ID IS NULL)
MINUS
SELECT PATH.PATH_DOCID PERZ_DOC_ID,
   jdr_mds_internal.getdocumentname(PATH.PATH_DOCID) PERZ_DOC_PATH
FROM JDR_PATHS PATH
WHERE PATH.PATH_DOCID IN
   (SELECT DISTINCT COMP_DOCID FROM JDR_COMPONENTS, JDR_ATTRIBUTES
   WHERE COMP_SEQ = 0 AND COMP_ELEMENT = 'customization'
   AND COMP_ID IS NULL
   AND ATT_COMP_DOCID = COMP_DOCID
   AND ATT_COMP_SEQ = 0
   AND ATT_NAME = 'developerMode'
   AND ATT_VALUE = 'true')

How to find all Form Personalization in Apps

SELECT FORM_ID, FORM_NAME,APPLICATION_NAME, FFV.USER_FORM_NAME, FFV.DESCRIPTION
FROM FND_FORM_VL FFV
    ,FND_APPLICATION_TL FAT
WHERE FFV.APPLICATION_ID=FAT.APPLICATION_ID
AND FORM_NAME IN
                (SELECT FORM_NAME --,FUNCTION_NAME, DESCRIPTION, TRIGGER_EVENT,  TRIGGER_OBJECT,CONDITION
                FROM FND_FORM_CUSTOM_RULES
                WHERE ENABLED='Y'
                GROUP BY FORM_NAME)

How to find all Form Personalization through script in Oracle APPS

SELECT FORM_ID, FORM_NAME, USER_FORM_NAME, DESCRIPTION
FROM FND_FORM_VL
WHERE FORM_NAME IN
                                     (SELECT FORM_NAME 
                                      FROM FND_FORM_CUSTOM_RULES 
                                      GROUP BY FORM_NAME)

How to Call stored procedure from Forms Personalization

Call PLSQL procedure using form Personalization

1. Personalize the form
2. Create an action of type "BuiltIn"
3. BuiltIn Type for Action should be "Execute a Procedure"

4. Argument should be as below 

='declare

   v_field_value VARCHAR2(200) ;

   begin

       plsql_package.procedurenameHere ;

  end'

or alternately

='declare
p_retcode NUMBER;
P_ERRBUF  VARCHAR2(2000);
begin
XXJG_INVOICE_PRINTING(p_retcode, p_errbuf,'''||${item.INV_SUM_FOLDER.INVOICE_ID.value}||''');
end'

Note the syntax, after =, entire declare begin end is within single quote.

Also, there is no semi colon after "end"

You can pass field values as

'''||${item.BLOCKNAME.FIELDNAME.value}||'''