APPS.OKE_DELIVERABLE_ACTIONS_PKG dependencies on MRP_SCHEDULE_DATES

Line 98: DELETE FROM mrp_schedule_dates

94: FETCH c INTO l_id;
95: CLOSE c;
96:
97: IF l_id IS NOT NULL THEN
98: DELETE FROM mrp_schedule_dates
99: WHERE mps_transaction_id = l_id;
100: END IF;
101:
102: EXCEPTION

Line 121: FROM mrp_schedule_dates

117: L_Primary_Qty NUMBER;
118:
119: CURSOR c1 ( P_Transaction_ID NUMBER ) IS
120: SELECT rowid
121: FROM mrp_schedule_dates
122: WHERE mps_transaction_id = p_transaction_id
123: AND schedule_level = l_schedule_level
124: AND supply_demand_type = l_supply_demand_type;
125:

Line 160: SELECT mrp_schedule_dates_s.nextval

156:
157: BEGIN
158:
159: -- Get ID
160: SELECT mrp_schedule_dates_s.nextval
161: INTO l_id
162: FROM dual;
163:
164: IF Check_Item_Unique ( P_Action_ID ) THEN

Line 209: INSERT INTO MRP_SCHEDULE_DATES(

205: , c3info.uom_code
206: , l_to_uom
207: , c3info.quantity );
208:
209: INSERT INTO MRP_SCHEDULE_DATES(
210: MPS_TRANSACTION_ID,
211: SCHEDULE_LEVEL,
212: SUPPLY_DEMAND_TYPE,
213: LAST_UPDATE_DATE,

Line 258: FROM mrp_schedule_dates

254: WHERE lookup_type = 'MRP_SCHEDULE_LEVEL'
255: AND lookup_code in ( 1 , 2)
256: AND NOT EXISTS (
257: SELECT NULL
258: FROM mrp_schedule_dates
259: WHERE mps_transaction_id = L_Id
260: AND schedule_level = lu.lookup_code );
261:
262: OPEN c1 (l_id);

Line 316: UPDATE MRP_SCHEDULE_DATES

312: , cinfo.uom_code
313: , cinfo.primary_uom_code
314: , cinfo.quantity );
315:
316: UPDATE MRP_SCHEDULE_DATES
317: SET
318: LAST_UPDATE_DATE = Sysdate,
319: LAST_UPDATED_BY = Fnd_Global.User_Id,
320: LAST_UPDATE_LOGIN = Fnd_Global.Login_Id,

Line 366: FROM mrp_schedule_dates

362: FOR UPDATE NOWAIT;
363:
364: CURSOR c2 IS
365: SELECT schedule_quantity
366: FROM mrp_schedule_dates
367: WHERE mps_transaction_id = l_id;
368:
369: BEGIN
370: