DBA Data[Home] [Help]

APPS.AP_APPROVAL_PKG dependencies on AP_TEMP_APPROVAL_GT

Line 8085: DELETE FROM ap_temp_approval_gt;

8081: ---------------------------------------------------------------------
8082: Print_Debug (l_api_name, 'Populate ap_temp_approval_temp_gt');
8083: ---------------------------------------------------------------------
8084:
8085: DELETE FROM ap_temp_approval_gt;
8086:
8087: FORALL i in g_org_holds.first..g_org_holds.last
8088: INSERT INTO ap_temp_approval_gt VALUES g_org_holds(i);
8089:

Line 8088: INSERT INTO ap_temp_approval_gt VALUES g_org_holds(i);

8084:
8085: DELETE FROM ap_temp_approval_gt;
8086:
8087: FORALL i in g_org_holds.first..g_org_holds.last
8088: INSERT INTO ap_temp_approval_gt VALUES g_org_holds(i);
8089:
8090: COMMIT;
8091:
8092: ---------------------------------------------------------------------

Line 8097: FROM ap_temp_approval_gt

8093: Print_Debug (l_api_name, 'Get the count of rows that will be printed');
8094: ---------------------------------------------------------------------
8095:
8096: SELECT count(*) into p_report_holds_count
8097: FROM ap_temp_approval_gt
8098: WHERE number_holds_placed <> 0
8099: OR number_holds_released <> 0;
8100:
8101: -- 7512258