APPS.INL_INTEGRATION_GRP dependencies on INL_SHIP_HEADERS

Line 101: SELECT INL_SHIP_HEADERS_INT_S.nextval

97: END IF;
98:
99: IF (l_current_shipment_header_id <> p_lci_table(i).shipment_header_id) THEN
100:
101: SELECT INL_SHIP_HEADERS_INT_S.nextval
102: INTO l_ship_header_int_id
103: FROM dual;
104:
105: SELECT INL_INTERFACE_GROUPS_S.nextval

Line 114: INSERT INTO inl_ship_headers_int(ship_header_int_id,

110: p_procedure_name => l_api_name,
111: p_var_name => 'l_ship_header_int_id',
112: p_var_value => l_ship_header_int_id);
113:
114: INSERT INTO inl_ship_headers_int(ship_header_int_id,
115: group_id,
116: transaction_type,
117: processing_status_code,
118: interface_source_code,

Line 710: p_debug_info => 'Insert into inl_ship_headers_int table'

706: );
707: INL_LOGGING_PVT.Log_Statement (
708: p_module_name => g_module_name,
709: p_procedure_name => l_proc_name,
710: p_debug_info => 'Insert into inl_ship_headers_int table'
711: );
712:
713: l_lci_table(i).shipment_header_id := Nvl(p_int_rec(i).shipment_header_id,p_int_rec(i).header_interface_id);
714: l_lci_table(i).transaction_type := 'CREATE';

Line 1791: FROM inl_ship_headers ish,

1787: isl.parent_ship_line_id,
1788: isl.ship_line_num,
1789: rtr.transaction_id,
1790: ish.adjustment_num
1791: FROM inl_ship_headers ish,
1792: inl_ship_lines isl,
1793: rcv_transactions rtr
1794: WHERE ish.ship_header_id = isl.ship_header_id
1795: AND rtr.po_line_location_id = isl.ship_line_source_id