APPS.INL_TCAMERGE_GRP dependencies on INL_SHIP_LINES_ALL

Line 53: FROM inl_ship_lines_all

49: AND src_type_code = 'PO';
50:
51: CURSOR c_lines IS
52: SELECT ship_line_id
53: FROM inl_ship_lines_all
54: WHERE ((poa_party_id = p_from_id AND poa_party_site_id = p_from_site_id)
55: OR (ship_from_party_id = p_from_id AND ship_from_party_site_id = p_from_site_id)
56: OR (bill_from_party_id = p_from_id AND bill_from_party_site_id = p_from_site_id))
57: AND ship_line_src_type_code = 'PO';

Line 215: UPDATE inl_ship_lines_all

211:
212: IF l_line_list.COUNT > 0 THEN
213: --
214: FORALL j IN l_line_list.FIRST..l_line_list.LAST
215: UPDATE inl_ship_lines_all
216: SET poa_party_id = decode(poa_party_id,p_from_id,p_to_id,poa_party_id),
217: poa_party_site_id = decode(poa_party_site_id,p_from_site_id,p_to_site_id,poa_party_site_id),
218: ship_from_party_id = decode(ship_from_party_id,p_from_id,p_to_id,ship_from_party_id),
219: ship_from_party_site_id = decode(ship_from_party_site_id,p_from_site_id,p_to_site_id,ship_from_party_site_id),

Line 230: l_debug_info := 'Updated inl_ship_lines_all. Number of Rows updated is ' || sql%rowcount;

226: last_updated_by = fnd_global.user_id,
227: last_update_login = fnd_global.login_id
228: WHERE ship_line_id = l_line_list(j);
229:
230: l_debug_info := 'Updated inl_ship_lines_all. Number of Rows updated is ' || sql%rowcount;
231: INL_LOGGING_PVT.Log_Statement ( p_module_name => g_module_name,
232: p_procedure_name => l_proc_name,
233: p_debug_info => l_debug_info) ;
234: END IF;