APPS.INL_INTERFACE_PVT dependencies on INL_SHIP_HEADERS_ALL

Line 1712: FROM inl_ship_headers_all a

1708: AND p_ship_header_id IS NOT NULL
1709: THEN
1710: SELECT SHIP_STATUS_CODE
1711: INTO l_status
1712: FROM inl_ship_headers_all a
1713: WHERE a.ship_header_id = p_ship_header_id;
1714: IF l_status = 'COMPLETED' THEN
1715: l_response := FALSE;
1716: -- Add a line into inl_ship_errors

Line 2174: -- inl_ship_lines_all, inl_ship_line_groups and inl_ship_headers_all

2170: -- Utility name : Delete_Ship
2171: -- Type : Private
2172: -- Function : Delete a LCM Shipment from inl_ship_holds, inl_associations,
2173: -- inl_allocations, inl_tax_lines, inl_charge_lines,
2174: -- inl_ship_lines_all, inl_ship_line_groups and inl_ship_headers_all
2175: -- Pre-reqs : None
2176: -- Parameters :
2177: -- IN : p_ship_header_id IN NUMBER
2178: --

Line 2272: l_debug_info := 'Delete from inl_ship_headers_all';

2268: ) ;
2269: DELETE FROM inl.inl_ship_line_groups
2270: WHERE ship_header_id = p_ship_header_id;
2271:
2272: l_debug_info := 'Delete from inl_ship_headers_all';
2273: INL_LOGGING_PVT.Log_Statement(
2274: p_module_name => g_module_name,
2275: p_procedure_name => l_proc_name,
2276: p_debug_info => l_debug_info

Line 2278: DELETE FROM inl.inl_ship_headers_all WHERE ship_header_id = p_ship_header_id;

2274: p_module_name => g_module_name,
2275: p_procedure_name => l_proc_name,
2276: p_debug_info => l_debug_info
2277: ) ;
2278: DELETE FROM inl.inl_ship_headers_all WHERE ship_header_id = p_ship_header_id;
2279: -- Standard End of Procedure/Function Logging
2280: INL_LOGGING_PVT.Log_EndProc(
2281: p_module_name => g_module_name,
2282: p_procedure_name => l_proc_name

Line 2318: -- table to INL_SHIP_HEADERS_ALL

2314: END Delete_Ship;
2315: -- Utility name : Import_Headers
2316: -- Type : Private
2317: -- Function : Import Shipment Headers from Interface
2318: -- table to INL_SHIP_HEADERS_ALL
2319: --
2320: -- Pre-reqs : None
2321: -- Parameters :
2322: -- IN : p_group_id IN NUMBER

Line 2500: SELECT inl_ship_headers_all_s.NEXTVAL

2496: attribute15 = validHeaders_List(iHead) .attribute15 -- 42
2497: WHERE ship_header_id = validHeaders_List(iHead) .ship_header_id;
2498: ELSE
2499: -- Get Shipment Header's nextval
2500: SELECT inl_ship_headers_all_s.NEXTVAL
2501: INTO validHeaders_List(iHead) .ship_header_id
2502: FROM dual;
2503:
2504: INL_LOGGING_PVT.Log_Variable(