APPS.MTL_RELATED_ITEMS_PKG dependencies on MTL_RELATED_ITEMS

Line 1: PACKAGE BODY MTL_RELATED_ITEMS_PKG as

1: PACKAGE BODY MTL_RELATED_ITEMS_PKG as
2: /* $Header: INVISDRB.pls 120.1 2006/02/23 22:24:18 swshukla noship $ */
3:
4: PROCEDURE Insert_Row (X_Rowid IN OUT NOCOPY VARCHAR2,
5: X_Inventory_Item_Id NUMBER,

Line 52: CURSOR C IS SELECT rowid FROM MTL_RELATED_ITEMS

48: X_Last_Update_Login NUMBER,
49: X_Object_Version_Number NUMBER
50: ) IS
51:
52: CURSOR C IS SELECT rowid FROM MTL_RELATED_ITEMS
53: WHERE inventory_item_id = X_Inventory_Item_Id
54: AND organization_id = X_Organization_Id
55: AND related_item_id = X_Related_Item_Id
56: AND Relationship_Type_Id = X_Relationship_Type_Id

Line 61: INSERT INTO MTL_RELATED_ITEMS(

57: AND Reciprocal_Flag = X_Reciprocal_Flag ;
58:
59: BEGIN
60:
61: INSERT INTO MTL_RELATED_ITEMS(
62: inventory_item_id,
63: organization_id,
64: related_item_id,
65: relationship_type_id,

Line 210: FROM MTL_RELATED_ITEMS

206: ) IS
207:
208: CURSOR C IS
209: SELECT *
210: FROM MTL_RELATED_ITEMS
211: WHERE rowid = X_Rowid
212: FOR UPDATE of Inventory_Item_Id NOWAIT;
213:
214: Recinfo C%ROWTYPE;

Line 379: UPDATE MTL_RELATED_ITEMS

375:
376: ) IS
377: BEGIN
378:
379: UPDATE MTL_RELATED_ITEMS
380: SET
381: inventory_item_id = X_Inventory_Item_Id,
382: organization_id = X_Organization_Id,
383: related_item_id = X_Related_Item_Id,

Line 433: DELETE FROM MTL_RELATED_ITEMS

429: END Update_Row;
430:
431: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
432: BEGIN
433: DELETE FROM MTL_RELATED_ITEMS
434: WHERE rowid = X_Rowid;
435:
436: if (SQL%NOTFOUND) then
437: Raise NO_DATA_FOUND;

Line 443: END MTL_RELATED_ITEMS_PKG;

439:
440: END Delete_Row;
441:
442:
443: END MTL_RELATED_ITEMS_PKG;