APPS.MRP_SCHEDULE_DATES_PKG dependencies on MRP_SCHEDULE_DATES

Line 1: PACKAGE BODY MRP_SCHEDULE_DATES_PKG AS

1: PACKAGE BODY MRP_SCHEDULE_DATES_PKG AS
2: /* $Header: MRSDATEB.pls 115.0 99/07/16 12:44:32 porting ship $ */
3:
4: PROCEDURE Insert_Row(
5: X_Rowid IN OUT VARCHAR2,

Line 58: FROM MRP_SCHEDULE_DATES

54: X_Attribute15 VARCHAR2 DEFAULT NULL
55: ) IS
56:
57: CURSOR C IS SELECT rowid
58: FROM MRP_SCHEDULE_DATES
59: WHERE mps_transaction_id = X_MPS_Transaction_Id
60: AND schedule_level = X_Schedule_Level
61: AND supply_demand_type = X_Supply_Demand_Type;
62:

Line 65: INSERT INTO MRP_SCHEDULE_dates(

61: AND supply_demand_type = X_Supply_Demand_Type;
62:
63: BEGIN
64:
65: INSERT INTO MRP_SCHEDULE_dates(
66: mps_transaction_id,
67: schedule_level,
68: supply_demand_type,
69: last_update_date,

Line 233: FROM MRP_SCHEDULE_DATES

229: ) IS
230:
231: CURSOR C IS
232: SELECT *
233: FROM MRP_SCHEDULE_DATES
234: WHERE rowid = X_Rowid
235: FOR UPDATE OF mps_transaction_id NOWAIT;
236:
237: Recinfo C%ROWTYPE;

Line 418: UPDATE MRP_SCHEDULE_DATES

414: ) IS
415:
416: BEGIN
417:
418: UPDATE MRP_SCHEDULE_DATES
419: SET
420: mps_transaction_id = X_MPS_Transaction_Id,
421: schedule_level = X_Schedule_Level,
422: supply_demand_type = X_Supply_Demand_Type,

Line 481: DELETE FROM MRP_SCHEDULE_DATES

477:
478: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
479:
480: BEGIN
481: DELETE FROM MRP_SCHEDULE_DATES
482: WHERE rowid = X_Rowid;
483:
484: if (SQL%NOTFOUND) then
485: RAISE NO_DATA_FOUND;

Line 493: SELECT mrp_schedule_dates_s.nextval

489:
490: PROCEDURE Get_Unique_Id(X_Unique_Id IN OUT NUMBER) IS
491:
492: CURSOR C IS
493: SELECT mrp_schedule_dates_s.nextval
494: FROM DUAL;
495:
496: BEGIN
497:

Line 512: END MRP_SCHEDULE_DATES_PKG;

508:
509: END Get_Unique_Id;
510:
511:
512: END MRP_SCHEDULE_DATES_PKG;