CodeAutonetics

API to compile all procedure specs in Oracle Apps R12 API: Alter package SET PAGESIZE 0 SET FEEDBACK OFF SET VERIFY OFF SPOOL temp.sql SELECT 'ALTER PACKAGE ' || a.owner || '.' || a.object_name || ' COMPILE;' FROM    all_objects a WHERE   a.object_type = 'PACKAGE' AND     a.status      = 'INVALID' AND     a.owner       = Decode(Upper('&&1'), 'ALL',a.owner, Upper('&&1')); SPOOL OFF -- Comment out following line to prevent immediate run @temp.sql SET PAGESIZE 14 SET FEEDBACK ON SET VERIFY ON

API to compile all procedures in Oracle Apps R12 API: Alter package SET PAGESIZE 0 SET FEEDBACK OFF SET VERIFY OFF SPOOL temp.sql SELECT 'ALTER PROCEDURE ' || a.owner || '.' || a.object_name || ' COMPILE;' FROM    all_objects a WHERE   a.object_type = 'PROCEDURE' AND     a.status      = 'INVALID' AND     a.owner       = Decode(Upper('&&1'), 'ALL',a.owner, Upper('&&1')); SPOOL OFF -- Comment out following line to prevent immediate run @temp.sql SET PAGESIZE 14 SET FEEDBACK ON SET VERIFY ON

API to compile all triggers in Oracle Apps R12 API: Alter package SET PAGESIZE 0 SET FEEDBACK OFF SET VERIFY OFF SPOOL temp.sql SELECT 'ALTER TRIGGER ' || a.owner || '.' || a.object_name || ' COMPILE;' FROM    all_objects a WHERE   a.object_type = 'TRIGGER' AND     a.status      = 'INVALID' AND     a.owner       = Decode(Upper('&&1'), 'ALL',a.owner, Upper('&&1')); SPOOL OFF -- Comment out following line to prevent immediate run @temp.sql SET PAGESIZE 14 SET FEEDBACK ON SET VERIFY ON

API to compile all views in Oracle Apps R12 API: Alter package SET PAGESIZE 0 SET FEEDBACK OFF SET VERIFY OFF SPOOL temp.sql SELECT 'ALTER VIEW ' || a.owner || '.' || a.object_name || ' COMPILE;' FROM    all_objects a WHERE   a.object_type = 'VIEW' AND     a.status      = 'INVALID' AND     a.owner       = Decode(Upper('&&1'), 'ALL',a.owner, Upper('&&1')); SPOOL OFF -- Comment out following line to prevent immediate run @temp.sql SET PAGESIZE 14 SET FEEDBACK ON SET VERIFY ON

API to compile all bodies in Oracle Apps R12 API: Alter package SET PAGESIZE 0 SET FEEDBACK OFF SET VERIFY OFF SPOOL temp.sql SELECT 'ALTER PACKAGE ' || a.owner || '.' || a.object_name || ' COMPILE BODY;' FROM    all_objects a WHERE   a.object_type = 'PACKAGE BODY' AND     a.status      = 'INVALID' AND     a.owner       = Decode(Upper('&&1'), 'ALL',a.owner, Upper('&&1')); SPOOL OFF -- Comment out following line to prevent immediate run @temp.sql SET PAGESIZE 14 SET FEEDBACK ON SET VERIFY ON

API to call XML report in Oracle Apps R12 API: fnd_request.add_layout DECLARE l_request_id NUMBER; l_user_id NUMBER; l_resp_id NUMBER; l_resp_appl_id NUMBER; l_call_status BOOLEAN; BEGIN SELECT fnd.user_id, fresp.responsibility_id, fresp.application_id INTO l_user_id, l_resp_id, l_resp_appl_id FROM apps.fnd_user fnd, apps.fnd_responsibility_tl fresp WHERE fnd.user_name = 'DEMOUSER' AND fresp.responsibility_name = 'BR Purchasing SME'; apps.fnd_global.apps_initialize (l_user_id, l_resp_id, l_resp_appl_id); mo_global.set_policy_context ('S', 102); l_call_status := fnd_request.add_layout ('XXCUST', 'XXBRPRPOPRINT_XML', 'en', 'US', 'PDF'); l_request_id := fnd_request.submit_request ('XXCUST', 'XXBRPRPOPRINT_XML', NULL, NULL, FALSE, 'R', --P_report_type NULL, --P_agent_name_num '114259', --P_po_num_from '114259', --P_po_num_to NULL, --P_release_num_from NULL, --P_release_num_to NULL, ...