APPS.MSC_DRP_UTIL dependencies on MSC_EXCEPTION_DETAILS

Line 1245: from msc_exception_details med

1241: p_lt_window number) RETURN numberArr IS
1242:
1243: cursor exc_id_c is
1244: select med.exception_detail_id
1245: from msc_exception_details med
1246: where med.plan_id = p_plan_id
1247: and med.inventory_item_id = p_item_id
1248: and med.organization_id = p_org_id
1249: and med.sr_instance_id = p_inst_id

Line 1309: From msc_exception_details med,

1305: msie.supplier_site_id,
1306: msie.source_org_id
1307: INTO p_plan_id, p_org_id, p_inst_id, p_item_id, p_excp_type,
1308: p_supplier_id, p_supplier_site_id, p_source_org_id
1309: From msc_exception_details med,
1310: Msc_srp_item_exceptions msie
1311: Where med.plan_id = msie.plan_id
1312: And med.organization_id = msie.organization_id
1313: And med.sr_instance_id = msie.sr_instance_id

Line 1324: -- lock msc_exception_details

1320: and msie.exist = 1
1321: and med.rowid = p_rowid
1322: for update of msie.action_taken_date nowait;
1323:
1324: -- lock msc_exception_details
1325:
1326: Select med.exception_detail_id
1327: BULK COLLECT INTO p_excp_id
1328: From msc_exception_details med

Line 1328: From msc_exception_details med

1324: -- lock msc_exception_details
1325:
1326: Select med.exception_detail_id
1327: BULK COLLECT INTO p_excp_id
1328: From msc_exception_details med
1329: Where med.plan_id = p_plan_id
1330: And med.organization_id = p_org_id
1331: And med.sr_instance_id = p_inst_id
1332: And med.inventory_item_id = p_item_id

Line 1345: Update msc_exception_details

1341: end if;
1342:
1343: -- update all the excp within the same criteria group
1344: Forall a in 1..nvl(p_excp_id.last,0)
1345: Update msc_exception_details
1346: Set action_taken_date = p_action_taken_date,
1347: action_taken = p_action_taken
1348: Where plan_id = p_plan_id
1349: AND exception_detail_id = p_excp_id(a);

Line 1398: From msc_exception_details med,

1394: Select med.exception_detail_id,
1395: msie.action_taken_date,
1396: msie.last_generated_date
1397: BULK COLLECT INTO p_excp_id, p_action_date, p_gen_date
1398: From msc_exception_details med,
1399: Msc_srp_item_exceptions msie
1400: Where med.plan_id = msie.plan_id
1401: And med.organization_id = msie.organization_id
1402: And med.sr_instance_id = msie.sr_instance_id

Line 1413: Update msc_exception_details

1409: and msie.exist = 1
1410: and msie.plan_id = p_plan_id;
1411:
1412: Forall a in 1..nvl(p_excp_id.last,0)
1413: Update msc_exception_details
1414: Set action_taken_date = p_action_date(a),
1415: first_generated_date = p_gen_date(a),
1416: Action_taken = decode(p_action_date(a), null, 2, 1),
1417: new_exception = decode(p_gen_date(a), p_plan_date, 1, 0)