APPS.INL_SHIPMENT_PVT dependencies on INL_SHIP_HEADERS_ALL

Line 512: l_debug_info := 'Update the current INL_SHIP_HEADERS_ALL.ship_status_code to COMPLETED';

508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
509: END IF;
510: END IF;
511:
512: l_debug_info := 'Update the current INL_SHIP_HEADERS_ALL.ship_status_code to COMPLETED';
513: INL_LOGGING_PVT.Log_Statement (
514: p_module_name => g_module_name,
515: p_procedure_name => l_api_name,
516: p_debug_info => l_debug_info

Line 2203: FROM inl_ship_headers_all sh,

2199: l_inv_org_id,
2200: l_location_id,
2201: l_ship_date,
2202: l_pending_matching_flag
2203: FROM inl_ship_headers_all sh,
2204: inl_ship_types_vl shipt
2205: WHERE sh.ship_type_id = shipt.ship_type_id
2206: AND sh.ship_header_id = p_ship_header_id;
2207:

Line 2572: l_debug_info := 'Update INL_SHIP_HEADERS_ALL.ship_status_code to VALIDATED';

2568: INTO l_ship_status
2569: FROM inl_ship_headers
2570: WHERE ship_header_id = p_ship_header_id;
2571: IF l_ship_status <> 'COMPLETED' THEN
2572: l_debug_info := 'Update INL_SHIP_HEADERS_ALL.ship_status_code to VALIDATED';
2573: INL_LOGGING_PVT.Log_Statement ( p_module_name => g_module_name,
2574: p_procedure_name => l_api_name,
2575: p_debug_info => l_debug_info) ;
2576: UPDATE inl_ship_headers

Line 2583: l_debug_info := 'Update INL_SHIP_HEADERS_ALL.ship_status_code to ON HOLD';

2579: last_update_date = SYSDATE
2580: WHERE ship_header_id = p_ship_header_id;
2581: END IF;
2582: ELSE
2583: l_debug_info := 'Update INL_SHIP_HEADERS_ALL.ship_status_code to ON HOLD';
2584: INL_LOGGING_PVT.Log_Statement ( p_module_name => g_module_name,
2585: p_procedure_name => l_api_name,
2586: p_debug_info => l_debug_info) ;
2587: UPDATE inl_ship_headers