APPS.BOM_ROUTINGINTERFACE_PUB dependencies on DUAL

Line 84: From dual;

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:
88:

Line 678: From dual;

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
682: For l_interface_rec in l_interface_csr loop

Line 1493: From dual;

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
1497: For l_interface_rec in l_interface_csr loop

Line 2060: From dual;

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
2064: For l_interface_rec in l_interface_csr loop