APPS.MRP_SCHEDULE_ITEMS_PKG dependencies on MRP_SCHEDULE_ITEMS

Line 1: PACKAGE BODY MRP_SCHEDULE_ITEMS_PKG AS

1: PACKAGE BODY MRP_SCHEDULE_ITEMS_PKG AS
2: /* $Header: MRSITEMB.pls 115.1 99/07/16 12:44:51 porting ship $ */
3:
4: PROCEDURE Insert_Row(
5: X_Rowid IN OUT VARCHAR2,

Line 39: FROM MRP_SCHEDULE_ITEMS

35: X_Capacity_Model_Id NUMBER DEFAULT NULL
36: ) IS
37:
38: CURSOR C IS SELECT rowid
39: FROM MRP_SCHEDULE_ITEMS
40: WHERE inventory_item_id = X_Inventory_Item_Id
41: AND schedule_designator = X_Schedule_Designator
42: AND organization_id = X_Organization_Id;
43:

Line 46: INSERT INTO MRP_SCHEDULE_ITEMS(

42: AND organization_id = X_Organization_Id;
43:
44: BEGIN
45:
46: INSERT INTO MRP_SCHEDULE_ITEMS(
47: inventory_item_id,
48: organization_id,
49: schedule_designator,
50: last_update_date,

Line 157: FROM MRP_SCHEDULE_ITEMS

153: ) IS
154:
155: CURSOR C IS
156: SELECT *
157: FROM MRP_SCHEDULE_ITEMS
158: WHERE rowid = X_Rowid
159: FOR UPDATE of inventory_item_id NOWAIT;
160:
161: Recinfo C%ROWTYPE;

Line 278: UPDATE MRP_SCHEDULE_ITEMS

274: ) IS
275:
276: BEGIN
277:
278: UPDATE MRP_SCHEDULE_ITEMS
279: SET
280: inventory_item_id = X_Inventory_Item_Id,
281: organization_id = X_Organization_Id,
282: schedule_designator = X_Schedule_Designator,

Line 322: DELETE FROM MRP_SCHEDULE_ITEMS

318:
319: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
320:
321: BEGIN
322: DELETE FROM MRP_SCHEDULE_ITEMS
323: WHERE rowid = X_Rowid;
324:
325: if (SQL%NOTFOUND) then
326: RAISE NO_DATA_FOUND;

Line 450: FROM mrp_schedule_items

446: SELECT 1
447: INTO dummy
448: FROM dual
449: WHERE NOT EXISTS (SELECT 1
450: FROM mrp_schedule_items
451: WHERE inventory_item_id = X_inventory_item_id
452: AND schedule_designator = X_schedule_designator
453: AND organization_id = X_organization_id
454: AND ( (X_rowid IS NULL)

Line 467: END MRP_SCHEDULE_ITEMS_PKG;

463:
464: END Check_Unique;
465:
466:
467: END MRP_SCHEDULE_ITEMS_PKG;