APPS.OKE_DTS_INTEGRATION_PKG dependencies on MRP_SCHEDULE_DATES

Line 110: SELECT MPS_TRANSACTION_ID FROM MRP_SCHEDULE_DATES

106: l_supply_demand_type CONSTANT NUMBER := 1;
107: l_schedule_origination_type CONSTANT NUMBER := 1;
108:
109: CURSOR l_csr(p_id NUMBER) IS
110: SELECT MPS_TRANSACTION_ID FROM MRP_SCHEDULE_DATES
111: WHERE MPS_TRANSACTION_ID = l_id
112: AND SCHEDULE_LEVEL = L_Schedule_Level
113: AND SUPPLY_DEMAND_TYPE = L_Supply_Demand_Type;
114:

Line 116: SELECT mrp_schedule_dates_s.NEXTVAL FROM dual;

112: AND SCHEDULE_LEVEL = L_Schedule_Level
113: AND SUPPLY_DEMAND_TYPE = L_Supply_Demand_Type;
114:
115: CURSOR l_id_csr IS
116: SELECT mrp_schedule_dates_s.NEXTVAL FROM dual;
117:
118: BEGIN
119:
120: --

Line 128: INSERT INTO MRP_SCHEDULE_DATES(

124: FETCH l_id_csr INTO l_id;
125: CLOSE l_id_csr;
126:
127: -- Insert twice to create both original and current record
128: INSERT INTO MRP_SCHEDULE_DATES(
129: MPS_TRANSACTION_ID,
130: SCHEDULE_LEVEL,
131: SUPPLY_DEMAND_TYPE,
132: LAST_UPDATE_DATE,

Line 177: FROM mrp_schedule_dates

173: WHERE lookup_type = 'MRP_SCHEDULE_LEVEL'
174: AND lookup_code IN ( 1 , 2)
175: AND NOT EXISTS (
176: SELECT NULL
177: FROM mrp_schedule_dates
178: WHERE mps_transaction_id = L_Id
179: AND schedule_level = lu.lookup_code );
180:
181: OPEN l_csr(l_id);

Line 212: UPDATE MRP_SCHEDULE_DATES d

208: ) IS
209:
210: BEGIN
211:
212: UPDATE MRP_SCHEDULE_DATES d
213: SET
214: LAST_UPDATE_DATE = Sysdate,
215: LAST_UPDATED_BY = Fnd_Global.User_Id,
216: LAST_UPDATE_LOGIN = Fnd_Global.Login_Id,

Line 291: FROM MRP_SCHEDULE_DATES

287: PROJECT_ID,
288: TASK_ID,
289: LINE_ID,
290: END_ITEM_UNIT_NUMBER
291: FROM MRP_SCHEDULE_DATES
292: WHERE MPS_TRANSACTION_ID = P_MPS_TRANSACTION_ID
293: AND SCHEDULE_LEVEL = 2
294: AND SUPPLY_DEMAND_TYPE = 1
295: FOR UPDATE OF MPS_TRANSACTION_ID NOWAIT;

Line 422: FROM mrp_schedule_dates

418: SELECT rowid,
419: INVENTORY_ITEM_ID,
420: ORGANIZATION_ID,
421: SCHEDULE_DESIGNATOR
422: FROM mrp_schedule_dates
423: WHERE MPS_TRANSACTION_ID = l_MPS_TRANSACTION_ID
424: AND SCHEDULE_LEVEL = 2
425: AND SUPPLY_DEMAND_TYPE = 1
426: FOR UPDATE NOWAIT;

Line 499: -- SELECT NULL FROM mrp_schedule_dates

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(
499: -- SELECT NULL FROM mrp_schedule_dates
500: -- WHERE Inventory_Item_Id = L_Item_ID_Old
501: -- AND Schedule_designator = L_Designator_Old
502: -- AND Organization_Id = L_Inv_Org_ID_Old
503: -- );