AP Payment Administrator PPR Genration

R12:AP/IBY Understanding XML Payment Templates and Formats (Doc ID 562806.1)

Find OAF Pages Personalization SQL Query

--Find OAF Pages Personalization SQL Query

SELECT
    jp.path_docid ,
    jdr_mds_internal.getdocumentname(jp.path_docid) Personalization_path,
    jp.path_name,
    Jp.Path_Owner_Docid,
    Jp.Path_Seq,
    Jp.Path_Type,
    Jp.Path_Xml_Encoding,
    Jp.Path_Xml_Version,
    Jp.Created_By,
    Jp.Creation_Date,
    Jp.Last_Updated_By,
    Jp.Last_Update_Date 
  FROM apps.jdr_paths jp
WHERE jp.path_docid IN (
        SELECT DISTINCT comp_docid
        FROM jdr_components
        WHERE
   comp_seq = 0
    AND   comp_element = 'customization'
   AND   comp_id IS NULL
    )
    AND   upper(jdr_mds_internal.getdocumentname(jp.path_docid) ) LIKE upper('%ViewExtBankAcctPG%')
    --upper('%UpdateExtBankAcctPG%')--upper('%SuppSummPG%')

Delete Workflow Business Event and Subscription API

--API To Delete the Workflow Business Events and Subscriptions

declare


cursor c_del_lines is
SELECT we.guid event_guid
     , wes.guid subscription_guid
     , wes.rule_function
  FROM wf_events we
     , wf_event_subscriptions wes
 WHERE we.NAME = 'oracle.apps.wf.notification.respond'--give your event name
   AND wes.event_filter_guid = we.guid;
 
   begin

   for i in c_del_lines loop
EXEC WF_EVENTS_PKG.DELETE_ROW(i.event_guid);

EXEC WF_EVENT_SUBSCRIPTIONS_PKG.DELETE_ROW(i.subscription_guid);

COMMIT;

end loop;


end;

Workflow Business Event and Subscription details SQL Query

/*Workflow Business Event and Subscription details SQL Query*/
SELECT we.guid event_guid,we.NAME, we.status event_status, wes.status subscription_status,
       NVL (wes.phase, 0) subscription_phase,
       wes.licensed_flag subscription_licensed_flag,
       we.licensed_flag event_licensed_flag,
       wes.guid subscription_guid,
        wes.rule_function,
       wes.on_error_code, wes.action_code, wes.customization_level,
       wes.owner_name subscription_owner_name,
       wes.owner_tag subscription_owner_tag,
       wes.source_type subscription_source_type,
       wes.rule_data subscription_rule_data, we.owner_name event_owner_name,
       we.owner_tag event_owner_tag,
       we.security_group_id event_security_group_id
FROM   wf_events we, wf_event_subscriptions wes
 WHERE 1 = 1
   AND we.NAME IN
          ('oracle.apps.wf.notification.send',
           'oracle.apps.wf.notification.respond',
           'oracle.apps.wf.notification.reassign'
          )
   AND wes.event_filter_guid = we.guid