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_PLN_INFO

Line 148: FROM mtl_related_items_pln_info

144: ,c_related_item_id NUMBER
145: ,c_relationship_type_id NUMBER
146: ,c_organization_id NUMBER) IS
147: SELECT *
148: FROM mtl_related_items_pln_info
149: WHERE
150: INVENTORY_ITEM_ID = c_inventory_item_id
151: AND RELATED_ITEM_ID = c_related_item_id
152: AND RELATIONSHIP_TYPE_ID = c_relationship_type_id

Line 163: FROM mtl_related_items_pln_info

159: ,c_relationship_type_id NUMBER
160: ,c_organization_id NUMBER
161: ,c_pln_info_id NUMBER) IS
162: SELECT *
163: FROM mtl_related_items_pln_info
164: WHERE
165: INVENTORY_ITEM_ID = c_inventory_item_id
166: AND RELATED_ITEM_ID = c_related_item_id
167: AND RELATIONSHIP_TYPE_ID = c_relationship_type_id

Line 171: l_mtl_Rel_Item_Pln_Info_rec MTL_RELATED_ITEMS_PLN_INFO%ROWTYPE; -- For fetching the data of above cursor

167: AND RELATIONSHIP_TYPE_ID = c_relationship_type_id
168: AND ORGANIZATION_ID = c_organization_id
169: AND PLN_INFO_ID = c_pln_info_id;
170:
171: l_mtl_Rel_Item_Pln_Info_rec MTL_RELATED_ITEMS_PLN_INFO%ROWTYPE; -- For fetching the data of above cursor
172:
173:
174: -- cursor for locking the record while updating and deleting
175: CURSOR mtl_rel_item_pln_info_lock_b

Line 192: FROM MTL_RELATED_ITEMS_PLN_INFO

188: ,END_DATE
189: ,SUBSTITUTION_SET
190: ,PARTIAL_FULFILLMENT_FLAG
191: ,ALL_CUSTOMERS_FLAG
192: FROM MTL_RELATED_ITEMS_PLN_INFO
193: WHERE
194: INVENTORY_ITEM_ID = c_inventory_item_id
195: AND RELATED_ITEM_ID = c_related_item_id
196: AND RELATIONSHIP_TYPE_ID = c_relationship_type_id

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 1372: ,P_Table_Name => 'MTL_RELATED_ITEMS_PLN_INFO'

1368: ,p_application_id => 'EGO'
1369: ,p_message_type => 'E'
1370: ,p_entity_code => G_Entity_Code
1371: ,p_entity_index => 1
1372: ,P_Table_Name => 'MTL_RELATED_ITEMS_PLN_INFO'
1373: );
1374: RAISE VALIDATION_ERROR;
1375: END IF;
1376:

Line 1414: ,p_table_name => 'MTL_RELATED_ITEMS_PLN_INFO'

1410: ,p_application_id => 'EGO'
1411: ,p_message_type => 'E'
1412: ,p_entity_code => G_Entity_Code
1413: ,p_entity_index => l_Pln_Info_Indx
1414: ,p_table_name => 'MTL_RELATED_ITEMS_PLN_INFO'
1415: );
1416: RAISE VALIDATION_ERROR;
1417: END IF;
1418:

Line 1435: ,p_table_name => 'MTL_RELATED_ITEMS_PLN_INFO'

1431: ,p_application_id => 'EGO'
1432: ,p_message_type => 'E'
1433: ,p_entity_code => G_Entity_Code
1434: ,p_entity_index => l_Pln_Info_Indx
1435: ,p_table_name => 'MTL_RELATED_ITEMS_PLN_INFO'
1436: );
1437: CLOSE mtl_pln_info_cur;
1438: RAISE VALIDATION_ERROR;
1439: END IF;

Line 1476: ,p_table_name => 'MTL_RELATED_ITEMS_PLN_INFO'

1472: ,p_application_id => 'EGO'
1473: ,p_message_type => 'E'
1474: ,p_entity_code => G_Entity_Code
1475: ,p_entity_index => l_Pln_Info_Indx
1476: ,p_table_name => 'MTL_RELATED_ITEMS_PLN_INFO'
1477: );
1478: RAISE VALIDATION_ERROR;
1479: END IF;
1480: END IF;

Line 1493: ,p_table_name => 'MTL_RELATED_ITEMS_PLN_INFO'

1489: ,p_application_id => 'EGO'
1490: ,p_message_type => 'E'
1491: ,p_entity_code => G_Entity_Code
1492: ,p_entity_index => l_Pln_Info_Indx
1493: ,p_table_name => 'MTL_RELATED_ITEMS_PLN_INFO'
1494: );
1495: RAISE VALIDATION_ERROR;
1496: END IF;
1497: END IF;

Line 1511: ,p_table_name => 'MTL_RELATED_ITEMS_PLN_INFO'

1507: ,p_application_id => 'EGO'
1508: ,p_message_type => 'E'
1509: ,p_entity_code => G_Entity_Code
1510: ,p_entity_index => l_Pln_Info_Indx
1511: ,p_table_name => 'MTL_RELATED_ITEMS_PLN_INFO'
1512: );
1513: RAISE VALIDATION_ERROR;
1514: END IF;
1515: END IF;

Line 1535: ,p_table_name => 'MTL_RELATED_ITEMS_PLN_INFO'

1531: ,p_application_id => 'EGO'
1532: ,p_message_type => 'E'
1533: ,p_entity_code => G_Entity_Code
1534: ,p_entity_index => l_Pln_Info_Indx
1535: ,p_table_name => 'MTL_RELATED_ITEMS_PLN_INFO'
1536: );
1537: RAISE VALIDATION_ERROR;
1538: END IF;
1539:

Line 1556: ,p_table_name => 'MTL_RELATED_ITEMS_PLN_INFO'

1552: ,p_application_id => 'EGO'
1553: ,p_message_type => 'E'
1554: ,p_entity_code => G_Entity_Code
1555: ,p_entity_index => l_Pln_Info_Indx
1556: ,p_table_name => 'MTL_RELATED_ITEMS_PLN_INFO'
1557: );
1558: RAISE VALIDATION_ERROR;
1559: END IF;
1560:

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 1677: ,P_Table_Name => 'MTL_RELATED_ITEMS_PLN_INFO'

1673: ,p_application_id => 'EGO'
1674: ,p_message_type => 'E'
1675: ,p_entity_code => G_Entity_Code
1676: ,p_entity_index => 1
1677: ,P_Table_Name => 'MTL_RELATED_ITEMS_PLN_INFO'
1678: );
1679: RAISE VALIDATION_ERROR;
1680: END IF;
1681:

Line 2051: ,p_table_name => 'MTL_RELATED_ITEMS_PLN_INFO'

2047: ,p_application_id => 'EGO'
2048: ,p_message_type => 'E'
2049: ,p_entity_code => G_Entity_Code
2050: ,p_entity_index => l_Pln_Info_Indx
2051: ,p_table_name => 'MTL_RELATED_ITEMS_PLN_INFO'
2052: );
2053: RAISE VALIDATION_ERROR;
2054: END IF;
2055:

Line 2093: ,p_table_name => 'MTL_RELATED_ITEMS_PLN_INFO'

2089: ,p_token_tbl => l_Token_Tbl
2090: ,p_message_type => 'E'
2091: ,p_entity_code => G_Entity_Code
2092: ,p_entity_index => l_Pln_Info_Indx
2093: ,p_table_name => 'MTL_RELATED_ITEMS_PLN_INFO'
2094: );
2095: RAISE VALIDATION_ERROR;
2096: END IF;
2097: EXCEPTION

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

Line 2124: ,P_TABLE_NAME => 'MTL_RELATED_ITEMS_PLN_INFO'

2120: ,p_application_id => 'EGO'
2121: ,p_message_type => 'E'
2122: ,p_entity_code => G_Entity_Code
2123: ,P_ENTITY_INDEX => 1
2124: ,P_TABLE_NAME => 'MTL_RELATED_ITEMS_PLN_INFO'
2125: );
2126: END IF; -- passing in null primary key columns
2127: END LOOP; -- looping planning info
2128: END IF; -- if planning info table is not null