DBA Data[Home] [Help]

APPS.MTL_RELATED_ITEMS_PVT dependencies on MTL_RELATED_ITEMS_CUST_REF_PKG

Line 1292: MTL_RELATED_ITEMS_CUST_REF_PKG.LOCK_ROW(

1288: ,l_Cust_Ref_Rec.RELATIONSHIP_TYPE_ID
1289: ,l_Cust_Ref_Rec.ORGANIZATION_ID) LOOP
1290:
1291: -- locking the row
1292: MTL_RELATED_ITEMS_CUST_REF_PKG.LOCK_ROW(
1293: P_PLN_INFO_ID => l_mtl_Rel_Item_Cust_Ref_rec.Pln_Info_Id
1294: ,P_INVENTORY_ITEM_ID => l_mtl_Rel_Item_Cust_Ref_rec.Inventory_Item_Id
1295: ,P_ORGANIZATION_ID => l_mtl_Rel_Item_Cust_Ref_rec.Organization_Id
1296: ,P_RELATED_ITEM_ID => l_mtl_Rel_Item_Cust_Ref_rec.Related_Item_Id

Line 1306: MTL_RELATED_ITEMS_CUST_REF_PKG.DELETE_ROW(

1302:
1303:
1304: Write_Debug('Deleting associated customer references...');
1305:
1306: MTL_RELATED_ITEMS_CUST_REF_PKG.DELETE_ROW(
1307: P_PLN_INFO_ID => l_mtl_Rel_Item_Cust_Ref_rec.Pln_Info_Id
1308: ,P_INVENTORY_ITEM_ID => l_mtl_Rel_Item_Cust_Ref_rec.Inventory_Item_Id
1309: ,P_ORGANIZATION_ID => l_mtl_Rel_Item_Cust_Ref_rec.Organization_Id
1310: ,P_RELATED_ITEM_ID => l_mtl_Rel_Item_Cust_Ref_rec.Related_Item_Id

Line 1908: MTL_RELATED_ITEMS_CUST_REF_PKG.INSERT_ROW(

1904:
1905: Write_Debug('Creating associated customer reference...');
1906:
1907: BEGIN
1908: MTL_RELATED_ITEMS_CUST_REF_PKG.INSERT_ROW(
1909: P_PLN_INFO_ID => l_Cust_Ref_Rec.Pln_Info_Id
1910: ,P_INVENTORY_ITEM_ID => l_Cust_Ref_Rec.Inventory_Item_Id
1911: ,P_ORGANIZATION_ID => l_Cust_Ref_Rec.Organization_Id
1912: ,P_RELATED_ITEM_ID => l_Cust_Ref_Rec.Related_Item_Id

Line 1948: MTL_RELATED_ITEMS_CUST_REF_PKG.UPDATE_ROW(

1944: CLOSE mtl_rel_item_cust_ref_lock_b;
1945:
1946: Write_Debug('Updating associated customer reference...');
1947:
1948: MTL_RELATED_ITEMS_CUST_REF_PKG.UPDATE_ROW(
1949: P_PLN_INFO_ID => l_Cust_Ref_Rec.Pln_Info_Id
1950: ,P_INVENTORY_ITEM_ID => l_Cust_Ref_Rec.Inventory_Item_Id
1951: ,P_ORGANIZATION_ID => l_Cust_Ref_Rec.Organization_Id
1952: ,P_RELATED_ITEM_ID => l_Cust_Ref_Rec.Related_Item_Id

Line 2008: MTL_RELATED_ITEMS_CUST_REF_PKG.DELETE_ROW(

2004: CLOSE mtl_rel_item_cust_ref_lock_b;
2005:
2006: Write_Debug('Deleting associated customer reference...');
2007: -- calling delete
2008: MTL_RELATED_ITEMS_CUST_REF_PKG.DELETE_ROW(
2009: P_PLN_INFO_ID => l_Cust_Ref_Rec.Pln_Info_Id
2010: ,P_INVENTORY_ITEM_ID => l_Cust_Ref_Rec.Inventory_Item_Id
2011: ,P_ORGANIZATION_ID => l_Cust_Ref_Rec.Organization_Id
2012: ,P_RELATED_ITEM_ID => l_Cust_Ref_Rec.Related_Item_Id