APPS.CSP_RELATED_ITEMS_PKG dependencies on MTL_RELATED_ITEMS

Line 51: CURSOR C IS SELECT rowid FROM MTL_RELATED_ITEMS

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

Line 60: INSERT INTO MTL_RELATED_ITEMS(

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

Line 206: FROM MTL_RELATED_ITEMS

202: ) IS
203:
204: CURSOR C IS
205: SELECT *
206: FROM MTL_RELATED_ITEMS
207: WHERE rowid = X_Rowid
208: FOR UPDATE of Inventory_Item_Id NOWAIT;
209:
210: Recinfo C%ROWTYPE;

Line 373: UPDATE MTL_RELATED_ITEMS

369:
370: ) IS
371: BEGIN
372:
373: UPDATE MTL_RELATED_ITEMS
374: SET
375: inventory_item_id = X_Inventory_Item_Id,
376: organization_id = X_Organization_Id,
377: related_item_id = X_Related_Item_Id,

Line 425: DELETE FROM MTL_RELATED_ITEMS

421: END Update_Row;
422:
423: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
424: BEGIN
425: DELETE FROM MTL_RELATED_ITEMS
426: WHERE rowid = X_Rowid;
427:
428: if (SQL%NOTFOUND) then
429: Raise NO_DATA_FOUND;