APPS.MSC_DRP_UTIL dependencies on MSC_SRP_ITEM_EXCEPTIONS

Line 1306: -- lock msc_srp_item_exceptions first

1302: p_action_taken_date date;
1303:
1304: BEGIN
1305:
1306: -- lock msc_srp_item_exceptions first
1307:
1308: Select msie.plan_id,
1309: msie.organization_id,
1310: msie.sr_instance_id,

Line 1319: Msc_srp_item_exceptions msie

1315: msie.source_org_id
1316: INTO p_plan_id, p_org_id, p_inst_id, p_item_id, p_excp_type,
1317: p_supplier_id, p_supplier_site_id, p_source_org_id
1318: From msc_exception_details med,
1319: Msc_srp_item_exceptions msie
1320: Where med.plan_id = msie.plan_id
1321: And med.organization_id = msie.organization_id
1322: And med.sr_instance_id = msie.sr_instance_id
1323: And med.inventory_item_id = msie.inventory_item_id

Line 1367: Update msc_srp_item_exceptions

1363: Set action_taken = p_action_taken
1364: Where plan_id = p_plan_id
1365: AND rowid = p_rowid;
1366:
1367: Update msc_srp_item_exceptions
1368: Set action_taken_date = p_action_taken_date
1369: Where plan_id = p_plan_id
1370: And organization_id = p_org_id
1371: And sr_instance_id = p_inst_id

Line 1415: Msc_srp_item_exceptions msie

1411: msie.action_taken_date,
1412: msie.last_generated_date
1413: BULK COLLECT INTO p_excp_id, p_action_date, p_gen_date
1414: From msc_exception_details med,
1415: Msc_srp_item_exceptions msie
1416: Where med.plan_id = msie.plan_id
1417: And med.organization_id = msie.organization_id
1418: And med.sr_instance_id = msie.sr_instance_id
1419: And med.inventory_item_id = msie.inventory_item_id