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 );
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:
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;