DBA Data[Home] [Help]

APPS.INL_INTEGRATION_GRP dependencies on INL_SHIP_HEADERS_INT

Line 128: SELECT INL_SHIP_HEADERS_INT_S.nextval, INL_INTERFACE_GROUPS_S.nextval

124: IF ((l_current_organization_id <> p_lci_table(i).organization_id OR
125: l_current_location_id <> p_lci_table(i).location_id)OR
126: l_current_shipment_header_id <> p_lci_table(i).hdr_interface_source_line_id) THEN -- Bug #9232742
127:
128: SELECT INL_SHIP_HEADERS_INT_S.nextval, INL_INTERFACE_GROUPS_S.nextval
129: INTO l_ship_header_int_id, l_group_id
130: FROM dual;
131:
132: p_lci_table(i).group_id := l_group_id; -- Bug#9279355

Line 149: p_debug_info => 'Inserting into inl_ship_headers_int' );

145:
146: INL_LOGGING_PVT.Log_Statement (
147: p_module_name => g_module_name,
148: p_procedure_name => l_api_name,
149: p_debug_info => 'Inserting into inl_ship_headers_int' );
150:
151: INSERT INTO inl_ship_headers_int(
152: ship_header_int_id, /* 01 */
153: group_id, /* 02 */

Line 151: INSERT INTO inl_ship_headers_int(

147: p_module_name => g_module_name,
148: p_procedure_name => l_api_name,
149: p_debug_info => 'Inserting into inl_ship_headers_int' );
150:
151: INSERT INTO inl_ship_headers_int(
152: ship_header_int_id, /* 01 */
153: group_id, /* 02 */
154: transaction_type, /* 03 */
155: processing_status_code, /* 04 */

Line 928: p_debug_info => 'Insert into inl_ship_headers_int table');

924: p_var_value => l_group_id);
925: INL_LOGGING_PVT.Log_Statement (
926: p_module_name => g_module_name,
927: p_procedure_name => l_proc_name,
928: p_debug_info => 'Insert into inl_ship_headers_int table');
929:
930: END IF;
931: l_lci_table(l_ind_lci).shipment_header_id := p_int_rec(i).shipment_header_id; --Bug#8971617
932: l_lci_table(l_ind_lci).header_interface_id := p_int_rec(i).header_interface_id;