APPS.OKE_DTS_INTEGRATION_PKG dependencies on MRP_SCHEDULE_ITEMS

Line 56: FROM mrp_schedule_items

52: WHERE Organization_ID = P_ID;
53:
54: CURSOR v IS
55: SELECT '!' INTO Dummy
56: FROM mrp_schedule_items
57: WHERE Inventory_Item_Id = p_Item_Id
58: AND Schedule_designator = p_Plan
59: AND Organization_Id = p_Inventory_Org_Id;
60: BEGIN

Line 74: MRP_SCHEDULE_ITEMS_PKG.Insert_Row(

70: IF L_Level IS NULL THEN
71: L_Level := 5;
72: END IF;
73:
74: MRP_SCHEDULE_ITEMS_PKG.Insert_Row(
75: X_Rowid => l_rowid,
76: X_Inventory_Item_Id => p_Item_Id,
77: X_Organization_Id => p_inventory_org_id,
78: X_Schedule_Designator => p_plan,

Line 486: -- delete empty mrp_schedule_items, if item, org, or plan changed

482: P_Deliverable_Id => p_deliverable_id,
483: P_ROW_ID => L_SRow_ID
484: );
485:
486: -- delete empty mrp_schedule_items, if item, org, or plan changed
487: IF L_Item_ID_Old = L_Item_ID
488: AND L_Inv_Org_ID_Old = L_Inv_Org_ID
489: AND L_Designator_Old = L_Designator
490: THEN

Line 492: -- Do not remove extra records from mrp_schedule_items

488: AND L_Inv_Org_ID_Old = L_Inv_Org_ID
489: AND L_Designator_Old = L_Designator
490: THEN
491: l_cr_item := FALSE;
492: -- Do not remove extra records from mrp_schedule_items
493: -- ELSE
494: -- DELETE mrp_schedule_items
495: -- WHERE Inventory_Item_Id = L_Item_ID_Old
496: -- AND Schedule_designator = L_Designator_Old

Line 494: -- DELETE mrp_schedule_items

490: THEN
491: l_cr_item := FALSE;
492: -- Do not remove extra records from mrp_schedule_items
493: -- ELSE
494: -- DELETE mrp_schedule_items
495: -- WHERE Inventory_Item_Id = L_Item_ID_Old
496: -- AND Schedule_designator = L_Designator_Old
497: -- AND Organization_Id = L_Inv_Org_ID_Old
498: -- AND NOT EXISTS(