DBA Data[Home] [Help]

APPS.INV_COPY_ORG_REPORT_PUB dependencies on MTL_COPY_ORG_REPORT

Line 80: FROM mtl_copy_org_report;

76: PROCEDURE purge_previous_reports_data
77: IS
78: CURSOR concurrent_req_id_cursor IS
79: SELECT DISTINCT request_id
80: FROM mtl_copy_org_report;
81:
82: phase VARCHAR2( 200 );
83: status VARCHAR2( 200 );
84: dev_phase VARCHAR2( 30 );

Line 104: mtl_copy_org_report

100: );
101:
102: IF UPPER( dev_phase ) = 'COMPLETE' THEN
103: DELETE FROM
104: mtl_copy_org_report
105: WHERE
106: request_id = request_id_rec.request_id;
107: END IF;
108:

Line 139: DELETE FROM mtl_copy_org_report

135: )
136: IS
137: BEGIN
138:
139: DELETE FROM mtl_copy_org_report
140: WHERE group_code = p_group_code;
141:
142: purge_previous_reports_data;
143: COMMIT;