DBA Data[Home] [Help]

APPS.MTL_RELATED_ITEMS_PVT dependencies on MTL_RELATED_ITEMS_PLN_INFO_PKG

Line 1259: MTL_RELATED_ITEMS_PLN_INFO_PKG.LOCK_ROW(

1255: ,l_Rel_Item_Rec.RELATIONSHIP_TYPE_ID
1256: ,l_Rel_Item_Rec.ORGANIZATION_ID) LOOP
1257:
1258: -- locking the row
1259: MTL_RELATED_ITEMS_PLN_INFO_PKG.LOCK_ROW(
1260: P_PLN_INFO_ID => l_mtl_Rel_Item_Pln_Info_rec.Pln_Info_Id
1261: ,P_INVENTORY_ITEM_ID => l_mtl_Rel_Item_Pln_Info_rec.Inventory_Item_Id
1262: ,P_ORGANIZATION_ID => l_mtl_Rel_Item_Pln_Info_rec.Organization_Id
1263: ,P_Related_Item_Id => l_mtl_Rel_Item_Pln_Info_rec.Related_Item_Id

Line 1273: MTL_RELATED_ITEMS_PLN_INFO_PKG.DELETE_ROW(

1269: ,P_ALL_CUSTOMERS_FLAG => l_mtl_Rel_Item_Pln_Info_rec.All_Customers_Flag);
1270:
1271: Write_Debug('Deleting associated substitution set...');
1272:
1273: MTL_RELATED_ITEMS_PLN_INFO_PKG.DELETE_ROW(
1274: P_PLN_INFO_ID => l_mtl_Rel_Item_Pln_Info_rec.Pln_Info_Id
1275: ,P_INVENTORY_ITEM_ID => l_mtl_Rel_Item_Pln_Info_rec.Inventory_Item_Id
1276: ,P_ORGANIZATION_ID => l_mtl_Rel_Item_Pln_Info_rec.Organization_Id
1277: ,P_RELATED_ITEM_ID => l_mtl_Rel_Item_Pln_Info_rec.Related_Item_Id

Line 1565: MTL_RELATED_ITEMS_PLN_INFO_PKG.INSERT_ROW(

1561: IF l_Pln_Info_Rec.TRANSACTION_TYPE = 'CREATE' THEN
1562:
1563: Write_Debug('Creating associated substitution set...');
1564:
1565: MTL_RELATED_ITEMS_PLN_INFO_PKG.INSERT_ROW(
1566: P_INVENTORY_ITEM_ID => l_Pln_Info_Rec.Inventory_Item_Id
1567: ,P_ORGANIZATION_ID => l_Pln_Info_Rec.Organization_Id
1568: ,P_RELATED_ITEM_ID => l_Pln_Info_Rec.Related_Item_Id
1569: ,P_RELATIONSHIP_TYPE_ID => l_Pln_Info_Rec.Relationship_Type_Id

Line 1607: MTL_RELATED_ITEMS_PLN_INFO_PKG.UPDATE_ROW(

1603: CLOSE mtl_rel_item_pln_info_lock_b;
1604:
1605: Write_Debug('Updating associated substitution set...');
1606:
1607: MTL_RELATED_ITEMS_PLN_INFO_PKG.UPDATE_ROW(
1608: P_PLN_INFO_ID => l_Pln_Info_Rec.Pln_Info_Id
1609: ,P_INVENTORY_ITEM_ID => l_Pln_Info_Rec.Inventory_Item_Id
1610: ,P_ORGANIZATION_ID => l_Pln_Info_Rec.Organization_Id
1611: ,P_RELATED_ITEM_ID => l_Pln_Info_Rec.Related_Item_Id

Line 2103: MTL_RELATED_ITEMS_PLN_INFO_PKG.DELETE_ROW(

2099: -- calling delete
2100:
2101: Write_Debug('Deleting associated substitution set...');
2102:
2103: MTL_RELATED_ITEMS_PLN_INFO_PKG.DELETE_ROW(
2104: P_PLN_INFO_ID => l_Pln_Info_Rec.Pln_Info_Id
2105: ,P_INVENTORY_ITEM_ID => l_Pln_Info_Rec.Inventory_Item_Id
2106: ,P_ORGANIZATION_ID => l_Pln_Info_Rec.Organization_Id
2107: ,P_RELATED_ITEM_ID => l_Pln_Info_Rec.Related_Item_Id