APPS.MSC_CL_COLLECTION dependencies on MRP_CL_REFRESH_SNAPSHOT

Line 148: mrp_cl_refresh_snapshot.wait_for_request(lv_req_id(j), 30, lv_out);

144:
145: END LOOP;
146:
147: FOR j IN 1..lv_req_id.COUNT LOOP
148: mrp_cl_refresh_snapshot.wait_for_request(lv_req_id(j), 30, lv_out);
149:
150: IF lv_out = 2 THEN
151: FND_MESSAGE.SET_NAME('MSC', 'MSC_ALT_TMP_TABLE_REQ_FAIL');
152: FND_MESSAGE.SET_TOKEN('REQUEST_ID', lv_req_id(j));

Line 5118: 'BEGIN MRP_CL_REFRESH_SNAPSHOT.PURGE_OBSOLETE_DATA'||lv_dblink||';END;';

5114: INTO lv_dblink
5115: FROM MSC_APPS_INSTANCES
5116: WHERE INSTANCE_ID=v_instance_id;
5117: lv_sql_stmt:=
5118: 'BEGIN MRP_CL_REFRESH_SNAPSHOT.PURGE_OBSOLETE_DATA'||lv_dblink||';END;';
5119:
5120: EXECUTE IMMEDIATE lv_sql_stmt;
5121:
5122: COMMIT;