APPS.AMS_RELATED_ITEMS_PKG dependencies on MTL_RELATED_ITEMS

Line 33: CURSOR C IS SELECT rowid FROM MTL_RELATED_ITEMS

29:
30: IS
31: X_ROWID VARCHAR2(30);
32:
33: CURSOR C IS SELECT rowid FROM MTL_RELATED_ITEMS
34: WHERE RELATED_ITEM_ID = p_RELATED_ITEM_ID
35: AND ORGANIZATION_ID = p_ORGANIZATION_ID
36: AND INVENTORY_ITEM_ID = p_INVENTORY_ITEM_ID
37: AND RELATIONSHIP_TYPE_ID = p_RELATIONSHIP_TYPE_ID;

Line 42: INSERT INTO MTL_RELATED_ITEMS(

38:
39: BEGIN
40:
41:
42: INSERT INTO MTL_RELATED_ITEMS(
43: INVENTORY_ITEM_ID,
44: ORGANIZATION_ID,
45: RELATED_ITEM_ID,
46: RELATIONSHIP_TYPE_ID,

Line 100: Update MTL_RELATED_ITEMS

96: p_PROGRAM_UPDATE_DATE DATE)
97:
98: IS
99: BEGIN
100: Update MTL_RELATED_ITEMS
101: SET
102: INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID),
103: ORGANIZATION_ID = decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, p_ORGANIZATION_ID),
104: RELATED_ITEM_ID = decode( p_RELATED_ITEM_ID, FND_API.G_MISS_NUM, RELATED_ITEM_ID, p_RELATED_ITEM_ID),

Line 143: DELETE FROM MTL_RELATED_ITEMS

139: p_PROGRAM_ID NUMBER,
140: p_PROGRAM_UPDATE_DATE DATE)
141: IS
142: BEGIN
143: DELETE FROM MTL_RELATED_ITEMS
144: WHERE RELATED_ITEM_ID = p_RELATED_ITEM_ID
145: AND INVENTORY_ITEM_ID = p_INVENTORY_ITEM_ID
146: AND ORGANIZATION_ID = p_ORGANIZATION_ID
147: AND RELATIONSHIP_TYPE_ID = p_RELATIONSHIP_TYPE_ID;

Line 173: FROM MTL_RELATED_ITEMS

169:
170: IS
171: CURSOR C IS
172: SELECT *
173: FROM MTL_RELATED_ITEMS
174: WHERE RELATED_ITEM_ID = p_RELATED_ITEM_ID
175: FOR UPDATE of RELATED_ITEM_ID NOWAIT;
176: Recinfo C%ROWTYPE;
177: BEGIN