APPS.CSP_RELATED_ITEMS_PKG dependencies on MTL_RELATED_ITEMS

Line 114: CURSOR C IS SELECT rowid FROM MTL_RELATED_ITEMS

110: X_Last_Update_Login NUMBER,
111: X_Object_Version_Number NUMBER
112: ) IS
113:
114: CURSOR C IS SELECT rowid FROM MTL_RELATED_ITEMS
115: WHERE inventory_item_id = X_Inventory_Item_Id
116: AND organization_id = X_Organization_Id
117: AND related_item_id = X_Related_Item_Id
118: AND Relationship_Type_Id = X_Relationship_Type_Id

Line 123: INSERT INTO MTL_RELATED_ITEMS(

119: AND Reciprocal_Flag = X_Reciprocal_Flag ;
120:
121: BEGIN
122:
123: INSERT INTO MTL_RELATED_ITEMS(
124: inventory_item_id,
125: organization_id,
126: related_item_id,
127: relationship_type_id,

Line 269: FROM MTL_RELATED_ITEMS

265: ) IS
266:
267: CURSOR C IS
268: SELECT *
269: FROM MTL_RELATED_ITEMS
270: WHERE rowid = X_Rowid
271: FOR UPDATE of Inventory_Item_Id NOWAIT;
272:
273: Recinfo C%ROWTYPE;

Line 436: UPDATE MTL_RELATED_ITEMS

432:
433: ) IS
434: BEGIN
435:
436: UPDATE MTL_RELATED_ITEMS
437: SET
438: inventory_item_id = X_Inventory_Item_Id,
439: organization_id = X_Organization_Id,
440: related_item_id = X_Related_Item_Id,

Line 506: from MTL_RELATED_ITEMS

502: --p_relation_type_pk4 := 8; -- supersession
503:
504: select organization_id, inventory_item_id, related_item_id , relationship_type_id
505: into p_mst_org_id_pk1, p_replaced_item_id_pk2, p_replacing_item_pk3,p_relation_type_pk4
506: from MTL_RELATED_ITEMS
507: WHERE rowid = X_Rowid;
508:
509: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
510: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

Line 522: DELETE FROM MTL_RELATED_ITEMS

518: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
519: 'deleting related item record...');
520: end if;
521:
522: DELETE FROM MTL_RELATED_ITEMS
523: WHERE organization_id = p_mst_org_id_pk1
524: and inventory_item_id = p_replaced_item_id_pk2
525: and related_item_id = p_replacing_item_pk3
526: and relationship_type_id = p_relation_type_pk4;