APPS.INL_TCAMERGE_GRP dependencies on INL_SIMULATIONS

Line 40: FROM inl_simulations

36: x_return_status OUT NOCOPY VARCHAR2 ) IS
37: --
38: CURSOR c_simulations IS
39: SELECT simulation_id
40: FROM inl_simulations
41: WHERE vendor_id = p_from_id
42: AND vendor_site_id = p_from_site_id;
43:
44: CURSOR c_line_groups IS

Line 153: UPDATE inl_simulations

149:
150: IF l_simulation_list.COUNT > 0 THEN
151: --
152: FORALL j IN l_simulation_list.FIRST..l_simulation_list.LAST
153: UPDATE inl_simulations
154: SET vendor_id = p_to_id,
155: vendor_site_id = p_to_site_id,
156: request_id = fnd_global.conc_request_id,
157: program_id = fnd_global.conc_program_id,

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

160: last_updated_by = fnd_global.user_id,
161: last_update_login = fnd_global.login_id
162: WHERE simulation_id = l_simulation_list(j);
163:
164: l_debug_info := 'Updated inl_simulations. Number of Rows updated is ' || sql%rowcount;
165: INL_LOGGING_PVT.Log_Statement ( p_module_name => g_module_name,
166: p_procedure_name => l_proc_name,
167: p_debug_info => l_debug_info) ;
168: END IF;