eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MTL_RELATED_ITEMS_PVT dependencies on MTL_RELATED_ITEMS_CUST_REF

Line 212: FROM mtl_related_items_cust_ref

208: ,c_related_item_id NUMBER
209: ,c_relationship_type_id NUMBER
210: ,c_organization_id NUMBER) IS
211: SELECT *
212: FROM mtl_related_items_cust_ref
213: WHERE
214: INVENTORY_ITEM_ID = c_inventory_item_id
215: AND RELATED_ITEM_ID = c_related_item_id
216: AND RELATIONSHIP_TYPE_ID = C_RELATIONSHIP_TYPE_ID

Line 229: FROM mtl_related_items_cust_ref

225: ,c_pln_info_id NUMBER
226: ,c_customer_id NUMBER
227: ,c_site_use_id NUMBER) IS
228: SELECT *
229: FROM mtl_related_items_cust_ref
230: WHERE
231: INVENTORY_ITEM_ID = c_inventory_item_id
232: AND RELATED_ITEM_ID = c_related_item_id
233: AND RELATIONSHIP_TYPE_ID = c_relationship_type_id

Line 239: l_mtl_Rel_Item_Cust_Ref_rec MTL_RELATED_ITEMS_CUST_REF%ROWTYPE; -- For fetching the data of above cursor

235: AND PLN_INFO_ID = c_pln_info_id
236: AND CUSTOMER_ID = c_customer_id
237: AND SITE_USE_ID = c_site_use_id;
238:
239: l_mtl_Rel_Item_Cust_Ref_rec MTL_RELATED_ITEMS_CUST_REF%ROWTYPE; -- For fetching the data of above cursor
240:
241: -- cursor for locking the record while updating and deleting
242: CURSOR mtl_rel_item_cust_ref_lock_b
243: (c_inventory_item_id NUMBER

Line 260: FROM MTL_RELATED_ITEMS_CUST_REF

256: ,CUSTOMER_ID
257: ,SITE_USE_ID
258: ,START_DATE
259: ,END_DATE
260: FROM MTL_RELATED_ITEMS_CUST_REF
261: WHERE
262: INVENTORY_ITEM_ID = c_inventory_item_id
263: AND RELATED_ITEM_ID = c_related_item_id
264: AND RELATIONSHIP_TYPE_ID = c_relationship_type_id

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 1710: FROM mtl_related_items_cust_ref

1706: FROM dual;
1707:
1708: -- checking if customer and site combinations already exists
1709: SELECT 'x' INTO l_cust_ref_exists
1710: FROM mtl_related_items_cust_ref
1711: WHERE Inventory_Item_Id = l_Cust_Ref_Rec.INVENTORY_ITEM_ID
1712: AND Related_Item_Id = l_Cust_Ref_Rec.RELATED_ITEM_ID
1713: AND Relationship_Type_Id = l_Cust_Ref_Rec.RELATIONSHIP_TYPE_ID
1714: AND Pln_Info_Id = l_Cust_Ref_Rec.PLN_INFO_ID

Line 1751: ,p_table_name => 'MTL_RELATED_ITEMS_CUST_REF'

1747: ,p_token_tbl => l_Token_Tbl
1748: ,p_message_type => 'E'
1749: ,p_entity_code => G_Entity_Code
1750: ,p_entity_index => l_Cust_Ref_Indx
1751: ,p_table_name => 'MTL_RELATED_ITEMS_CUST_REF'
1752: );
1753: RAISE VALIDATION_ERROR;
1754: END IF;
1755: EXCEPTION

Line 1780: ,p_table_name => 'MTL_RELATED_ITEMS_CUST_REF'

1776: ,p_application_id => 'EGO'
1777: ,p_message_type => 'E'
1778: ,p_entity_code => G_Entity_Code
1779: ,p_entity_index => l_Cust_Ref_Indx
1780: ,p_table_name => 'MTL_RELATED_ITEMS_CUST_REF'
1781: );
1782: CLOSE mtl_cust_ref_cur;
1783: RAISE VALIDATION_ERROR;
1784: END IF;

Line 1838: ,p_table_name => 'MTL_RELATED_ITEMS_CUST_REF'

1834: ,p_application_id => 'EGO'
1835: ,p_message_type => 'E'
1836: ,p_entity_code => G_Entity_Code
1837: ,p_entity_index => l_Cust_Ref_Indx
1838: ,p_table_name => 'MTL_RELATED_ITEMS_CUST_REF'
1839: );
1840: RAISE VALIDATION_ERROR;
1841: END;
1842:

Line 1860: ,p_table_name => 'MTL_RELATED_ITEMS_CUST_REF'

1856: ,p_token_tbl => l_Token_Tbl
1857: ,p_message_type => 'E'
1858: ,p_entity_code => G_Entity_Code
1859: ,p_entity_index => l_Cust_Ref_Indx
1860: ,p_table_name => 'MTL_RELATED_ITEMS_CUST_REF'
1861: );
1862: RAISE VALIDATION_ERROR;
1863: END IF;
1864: END IF;

Line 1878: ,p_table_name => 'MTL_RELATED_ITEMS_CUST_REF'

1874: ,p_token_tbl => l_Token_Tbl
1875: ,p_message_type => 'E'
1876: ,p_entity_code => G_Entity_Code
1877: ,p_entity_index => l_Cust_Ref_Indx
1878: ,p_table_name => 'MTL_RELATED_ITEMS_CUST_REF'
1879: );
1880: RAISE VALIDATION_ERROR;
1881: END IF;
1882: END IF;

Line 1895: ,p_table_name => 'MTL_RELATED_ITEMS_CUST_REF'

1891: ,p_application_id => 'EGO'
1892: ,p_message_type => 'E'
1893: ,p_entity_code => G_Entity_Code
1894: ,p_entity_index => l_Cust_Ref_Indx
1895: ,p_table_name => 'MTL_RELATED_ITEMS_CUST_REF'
1896: );
1897: RAISE VALIDATION_ERROR;
1898: END IF;
1899: END IF;

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 1988: ,p_table_name => 'MTL_RELATED_ITEMS_CUST_REF'

1984: ,p_application_id => 'EGO'
1985: ,p_message_type => 'E'
1986: ,p_entity_code => G_Entity_Code
1987: ,p_entity_index => l_Cust_Ref_Indx
1988: ,p_table_name => 'MTL_RELATED_ITEMS_CUST_REF'
1989: );
1990: CLOSE mtl_cust_ref_cur;
1991: RAISE VALIDATION_ERROR;
1992: END IF;

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

Line 2028: ,p_table_name => 'MTL_RELATED_ITEMS_CUST_REF'

2024: ,p_application_id => 'EGO'
2025: ,p_message_type => 'E'
2026: ,p_entity_code => G_Entity_Code
2027: ,p_entity_index => l_Cust_Ref_Indx
2028: ,p_table_name => 'MTL_RELATED_ITEMS_CUST_REF'
2029: );
2030: RAISE VALIDATION_ERROR;
2031: End If; -- primary keys of cust ref are not provided
2032: END LOOP; -- cust ref loop

Line 2058: FROM mtl_related_items_cust_ref

2054: END IF;
2055:
2056: BEGIN
2057: SELECT 'x' INTO l_cust_ref_exists
2058: FROM mtl_related_items_cust_ref
2059: WHERE (INVENTORY_ITEM_ID = l_Pln_Info_Rec.INVENTORY_ITEM_ID
2060: AND RELATIONSHIP_TYPE_ID= l_Pln_Info_Rec.RELATIONSHIP_TYPE_ID
2061: AND RELATED_ITEM_ID = l_Pln_Info_Rec.RELATED_ITEM_ID
2062: AND ORGANIZATION_ID = l_Pln_Info_Rec.ORGANIZATION_ID