APPS.INL_TCAMERGE_GRP dependencies on INL_MATCHES

Line 69: FROM INL_MATCHES

65: OR (cl.poa_party_id = p_from_id AND cl.poa_party_site_id = p_from_site_id));
66:
67: CURSOR c_matches IS
68: SELECT match_id
69: FROM INL_MATCHES
70: WHERE party_id = p_from_party_id
71: AND party_site_id = p_from_party_site_id;
72: --
73: TYPE id_tbl_type is TABLE of NUMBER INDEX BY BINARY_INTEGER;

Line 284: UPDATE inl_matches

280:
281: IF l_match_list.COUNT > 0 THEN
282: --
283: FORALL j IN l_match_list.FIRST..l_match_list.LAST
284: UPDATE inl_matches
285: SET party_id = p_to_party_id,
286: party_site_id = p_to_party_site_id,
287: request_id = fnd_global.conc_request_id,
288: program_id = fnd_global.conc_program_id,

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

291: last_updated_by = fnd_global.user_id,
292: last_update_login = fnd_global.login_id
293: WHERE match_id = l_match_list(j);
294:
295: l_debug_info := 'Updated inl_matches. Number of Rows updated is ' || sql%rowcount;
296: INL_LOGGING_PVT.Log_Statement ( p_module_name => g_module_name,
297: p_procedure_name => l_proc_name,
298: p_debug_info => l_debug_info) ;
299: END IF;