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.BOM_ROUTINGINTERFACE_PUB dependencies on MTL_SYSTEM_ITEMS_INTERFACE_S

Line 83: Select mtl_system_items_interface_s.nextval transaction_id

79: From bom_interface_delete_groups
80: Where upper(entity_name) = G_RtgDelEntity
81: And rownum = 1;
82: cursor l_Transaction_csr is
83: Select mtl_system_items_interface_s.nextval transaction_id
84: From dual;
85: l_api_name CONSTANT VARCHAR2(30) := 'ImportHeader';
86: Begin
87:

Line 521: transaction_id = mtl_system_items_interface_s.nextval,

517: Where rowid = l_interface_rec.rowid;
518: Else
519: Update bom_op_routings_interface
520: Set process_flag = 7,
521: transaction_id = mtl_system_items_interface_s.nextval,
522: request_id = nvl(request_id,g_RequestId),
523: program_id = nvl(program_id,g_ProgramId),
524: program_application_id = nvl(program_application_id,g_ApplicationId),
525: program_update_date = nvl(program_update_date,sysdate),

Line 677: Select mtl_system_items_interface_s.nextval transaction_id

673: From bom_interface_delete_groups
674: Where upper(entity_name) = G_OprDelEntity
675: And rownum = 1;
676: cursor l_Transaction_csr is
677: Select mtl_system_items_interface_s.nextval transaction_id
678: From dual;
679: l_api_name CONSTANT VARCHAR2(30) := 'ImportOperation';
680: Begin
681: While l_phase <= 2 loop -- two passes

Line 1361: transaction_id = mtl_system_items_interface_s.nextval,

1357: Where rowid = l_interface_rec.rowid;
1358: Else
1359: Update bom_op_sequences_interface
1360: Set process_flag = 7,
1361: transaction_id = mtl_system_items_interface_s.nextval,
1362: request_id = nvl(request_id,g_RequestId),
1363: program_id = nvl(program_id,g_ProgramId),
1364: program_application_id = nvl(program_application_id,g_ApplicationId),
1365: program_update_date = nvl(program_update_date,sysdate),

Line 1492: Select mtl_system_items_interface_s.nextval transaction_id

1488: l_msg_name VARCHAR2(80);
1489: l_msg_app VARCHAR2(3);
1490: l_ret_code NUMBER := 0;
1491: cursor l_Transaction_csr is
1492: Select mtl_system_items_interface_s.nextval transaction_id
1493: From dual;
1494: l_api_name CONSTANT VARCHAR2(30) := 'ImportResource';
1495: Begin
1496: While l_phase <= 2 loop -- two passes

Line 1943: transaction_id = mtl_system_items_interface_s.nextval,

1939: Where rowid = l_interface_rec.rowid;
1940: Else
1941: Update bom_op_resources_interface
1942: Set process_flag = 7,
1943: transaction_id = mtl_system_items_interface_s.nextval,
1944: request_id = nvl(request_id,g_RequestId),
1945: program_id = nvl(program_id,g_ProgramId),
1946: program_application_id = nvl(program_application_id,g_ApplicationId),
1947: program_update_date = nvl(program_update_date,sysdate),

Line 2059: Select mtl_system_items_interface_s.nextval transaction_id

2055: l_msg_name VARCHAR2(80);
2056: l_msg_app VARCHAR2(3);
2057: l_ret_code NUMBER := 0;
2058: cursor l_Transaction_csr is
2059: Select mtl_system_items_interface_s.nextval transaction_id
2060: From dual;
2061: l_api_name CONSTANT VARCHAR2(30) := 'ImportRevision';
2062: Begin
2063: While l_phase <= 2 loop -- two passes

Line 2363: transaction_id = mtl_system_items_interface_s.nextval,

2359: Where rowid = l_interface_rec.rowid;
2360: Else
2361: Update mtl_rtg_item_revs_interface
2362: Set process_flag = 7,
2363: transaction_id = mtl_system_items_interface_s.nextval,
2364: request_id = nvl(request_id,g_RequestId),
2365: program_id = nvl(program_id,g_ProgramId),
2366: program_application_id = nvl(program_application_id,g_ApplicationId),
2367: program_update_date = nvl(program_update_date,sysdate),