DBA Data[Home] [Help]

APPS.INL_INTERFACE_PVT dependencies on INL_SHIP_HOLDS

Line 8098: -- Function : Delete a LCM Shipment from inl_ship_holds, inl_associations, inl_matches, inl_match_amount

8094: END Validate_HdrTrxType;
8095:
8096: -- Utility name : Delete_Ship
8097: -- Type : Private
8098: -- Function : Delete a LCM Shipment from inl_ship_holds, inl_associations, inl_matches, inl_match_amount
8099: -- inl_allocations, inl_tax_lines, inl_charge_lines,
8100: -- inl_ship_lines_all, inl_ship_line_groups and inl_ship_headers_all
8101: -- If a Charge/Tax is associated with more than one Shipment, only the associations
8102: -- of the current shipment are going to be deleted

Line 8126: -- Table inl_ship_holds

8122: p_procedure_name => l_program_name) ;
8123: -- Initialize API return status to success
8124: x_return_status := L_FND_RET_STS_SUCCESS;
8125:
8126: -- Table inl_ship_holds
8127: l_debug_info := 'Delete from inl_ship_holds';
8128: INL_LOGGING_PVT.Log_Statement(
8129: p_module_name => g_module_name,
8130: p_procedure_name => l_program_name,

Line 8127: l_debug_info := 'Delete from inl_ship_holds';

8123: -- Initialize API return status to success
8124: x_return_status := L_FND_RET_STS_SUCCESS;
8125:
8126: -- Table inl_ship_holds
8127: l_debug_info := 'Delete from inl_ship_holds';
8128: INL_LOGGING_PVT.Log_Statement(
8129: p_module_name => g_module_name,
8130: p_procedure_name => l_program_name,
8131: p_debug_info => l_debug_info) ;

Line 8140: DELETE FROM inl_ship_holds

8136: p_var_name => 'p_ship_header_id',
8137: p_var_value => p_ship_header_id
8138: );
8139:
8140: DELETE FROM inl_ship_holds
8141: WHERE ship_header_id = p_ship_header_id;
8142:
8143:
8144: INL_LOGGING_PVT.Log_Variable(