DBA Data[Home] [Help]

APPS.INL_TCAMERGE_GRP dependencies on FND_GLOBAL

Line 156: request_id = fnd_global.conc_request_id,

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,
158: program_application_id = fnd_global.prog_appl_id,
159: last_update_date = sysdate,
160: last_updated_by = fnd_global.user_id,

Line 157: program_id = fnd_global.conc_program_id,

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,
158: program_application_id = fnd_global.prog_appl_id,
159: last_update_date = sysdate,
160: last_updated_by = fnd_global.user_id,
161: last_update_login = fnd_global.login_id

Line 158: program_application_id = fnd_global.prog_appl_id,

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,
158: program_application_id = fnd_global.prog_appl_id,
159: last_update_date = sysdate,
160: last_updated_by = fnd_global.user_id,
161: last_update_login = fnd_global.login_id
162: WHERE simulation_id = l_simulation_list(j);

Line 160: last_updated_by = fnd_global.user_id,

156: request_id = fnd_global.conc_request_id,
157: program_id = fnd_global.conc_program_id,
158: program_application_id = fnd_global.prog_appl_id,
159: last_update_date = sysdate,
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;

Line 161: last_update_login = fnd_global.login_id

157: program_id = fnd_global.conc_program_id,
158: program_application_id = fnd_global.prog_appl_id,
159: last_update_date = sysdate,
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,

Line 187: request_id = fnd_global.conc_request_id,

183: FORALL j IN l_line_group_list.FIRST..l_line_group_list.LAST
184: UPDATE inl_ship_line_groups
185: SET party_id = p_to_party_id,
186: party_site_id = p_to_party_site_id,
187: request_id = fnd_global.conc_request_id,
188: program_id = fnd_global.conc_program_id,
189: program_application_id = fnd_global.prog_appl_id,
190: last_update_date = sysdate,
191: last_updated_by = fnd_global.user_id,

Line 188: program_id = fnd_global.conc_program_id,

184: UPDATE inl_ship_line_groups
185: SET party_id = p_to_party_id,
186: party_site_id = p_to_party_site_id,
187: request_id = fnd_global.conc_request_id,
188: program_id = fnd_global.conc_program_id,
189: program_application_id = fnd_global.prog_appl_id,
190: last_update_date = sysdate,
191: last_updated_by = fnd_global.user_id,
192: last_update_login = fnd_global.login_id

Line 189: program_application_id = fnd_global.prog_appl_id,

185: SET party_id = p_to_party_id,
186: party_site_id = p_to_party_site_id,
187: request_id = fnd_global.conc_request_id,
188: program_id = fnd_global.conc_program_id,
189: program_application_id = fnd_global.prog_appl_id,
190: last_update_date = sysdate,
191: last_updated_by = fnd_global.user_id,
192: last_update_login = fnd_global.login_id
193: WHERE ship_line_group_id = l_line_group_list(j);

Line 191: last_updated_by = fnd_global.user_id,

187: request_id = fnd_global.conc_request_id,
188: program_id = fnd_global.conc_program_id,
189: program_application_id = fnd_global.prog_appl_id,
190: last_update_date = sysdate,
191: last_updated_by = fnd_global.user_id,
192: last_update_login = fnd_global.login_id
193: WHERE ship_line_group_id = l_line_group_list(j);
194:
195: l_debug_info := 'Updated inl_ship_line_groups. Number of Rows updated is ' || sql%rowcount;

Line 192: last_update_login = fnd_global.login_id

188: program_id = fnd_global.conc_program_id,
189: program_application_id = fnd_global.prog_appl_id,
190: last_update_date = sysdate,
191: last_updated_by = fnd_global.user_id,
192: last_update_login = fnd_global.login_id
193: WHERE ship_line_group_id = l_line_group_list(j);
194:
195: l_debug_info := 'Updated inl_ship_line_groups. Number of Rows updated is ' || sql%rowcount;
196: INL_LOGGING_PVT.Log_Statement ( p_module_name => g_module_name,

Line 222: request_id = fnd_global.conc_request_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),
220: bill_from_party_id = decode(bill_from_party_id,p_from_id,p_to_id,bill_from_party_id),
221: bill_from_party_site_id = decode(bill_from_party_site_id,p_from_site_id,p_to_site_id,bill_from_party_site_id),
222: request_id = fnd_global.conc_request_id,
223: program_id = fnd_global.conc_program_id,
224: program_application_id = fnd_global.prog_appl_id,
225: last_update_date = sysdate,
226: last_updated_by = fnd_global.user_id,

Line 223: program_id = fnd_global.conc_program_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),
220: bill_from_party_id = decode(bill_from_party_id,p_from_id,p_to_id,bill_from_party_id),
221: bill_from_party_site_id = decode(bill_from_party_site_id,p_from_site_id,p_to_site_id,bill_from_party_site_id),
222: request_id = fnd_global.conc_request_id,
223: program_id = fnd_global.conc_program_id,
224: program_application_id = fnd_global.prog_appl_id,
225: last_update_date = sysdate,
226: last_updated_by = fnd_global.user_id,
227: last_update_login = fnd_global.login_id

Line 224: program_application_id = fnd_global.prog_appl_id,

220: bill_from_party_id = decode(bill_from_party_id,p_from_id,p_to_id,bill_from_party_id),
221: bill_from_party_site_id = decode(bill_from_party_site_id,p_from_site_id,p_to_site_id,bill_from_party_site_id),
222: request_id = fnd_global.conc_request_id,
223: program_id = fnd_global.conc_program_id,
224: program_application_id = fnd_global.prog_appl_id,
225: last_update_date = sysdate,
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);

Line 226: last_updated_by = fnd_global.user_id,

222: request_id = fnd_global.conc_request_id,
223: program_id = fnd_global.conc_program_id,
224: program_application_id = fnd_global.prog_appl_id,
225: last_update_date = sysdate,
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;

Line 227: last_update_login = fnd_global.login_id

223: program_id = fnd_global.conc_program_id,
224: program_application_id = fnd_global.prog_appl_id,
225: last_update_date = sysdate,
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,

Line 260: last_updated_by = fnd_global.user_id,

256: poa_party_site_id = decode(nvl(poa_party_site_id,-1),-1,null,p_from_site_id,p_to_site_id,poa_party_site_id),
257: party_id = p_to_party_id,
258: party_site_id = decode(nvl(party_site_id,-1),-1,null,p_from_party_site_id,p_to_party_site_id,party_site_id),
259: last_update_date = sysdate,
260: last_updated_by = fnd_global.user_id,
261: last_update_login = fnd_global.login_id
262: WHERE charge_line_id = l_charge_line_list(j);
263:
264: l_debug_info := 'Updated inl_charges. Number of Rows updated is ' || sql%rowcount;

Line 261: last_update_login = fnd_global.login_id

257: party_id = p_to_party_id,
258: party_site_id = decode(nvl(party_site_id,-1),-1,null,p_from_party_site_id,p_to_party_site_id,party_site_id),
259: last_update_date = sysdate,
260: last_updated_by = fnd_global.user_id,
261: last_update_login = fnd_global.login_id
262: WHERE charge_line_id = l_charge_line_list(j);
263:
264: l_debug_info := 'Updated inl_charges. Number of Rows updated is ' || sql%rowcount;
265: INL_LOGGING_PVT.Log_Statement ( p_module_name => g_module_name,

Line 287: request_id = fnd_global.conc_request_id,

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,
289: program_application_id = fnd_global.prog_appl_id,
290: last_update_date = sysdate,
291: last_updated_by = fnd_global.user_id,

Line 288: program_id = fnd_global.conc_program_id,

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,
289: program_application_id = fnd_global.prog_appl_id,
290: last_update_date = sysdate,
291: last_updated_by = fnd_global.user_id,
292: last_update_login = fnd_global.login_id

Line 289: program_application_id = fnd_global.prog_appl_id,

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,
289: program_application_id = fnd_global.prog_appl_id,
290: last_update_date = sysdate,
291: last_updated_by = fnd_global.user_id,
292: last_update_login = fnd_global.login_id
293: WHERE match_id = l_match_list(j);

Line 291: last_updated_by = fnd_global.user_id,

287: request_id = fnd_global.conc_request_id,
288: program_id = fnd_global.conc_program_id,
289: program_application_id = fnd_global.prog_appl_id,
290: last_update_date = sysdate,
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;

Line 292: last_update_login = fnd_global.login_id

288: program_id = fnd_global.conc_program_id,
289: program_application_id = fnd_global.prog_appl_id,
290: last_update_date = sysdate,
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,

Line 677: last_updated_by = fnd_global.user_id,

673: FORALL j IN l_charge_line_list.FIRST..l_charge_line_list.LAST
674: UPDATE inl_charge_lines
675: SET party_id = p_to_fk_id,
676: last_update_date = sysdate,
677: last_updated_by = fnd_global.user_id,
678: last_update_login = fnd_global.login_id
679: WHERE charge_line_id = l_charge_line_list(j);
680:
681: l_debug_info := 'Updated inl_charges. Number of Rows updated is ' || sql%rowcount;

Line 678: last_update_login = fnd_global.login_id

674: UPDATE inl_charge_lines
675: SET party_id = p_to_fk_id,
676: last_update_date = sysdate,
677: last_updated_by = fnd_global.user_id,
678: last_update_login = fnd_global.login_id
679: WHERE charge_line_id = l_charge_line_list(j);
680:
681: l_debug_info := 'Updated inl_charges. Number of Rows updated is ' || sql%rowcount;
682: INL_LOGGING_PVT.Log_Statement ( p_module_name => g_module_name,

Line 829: last_updated_by = fnd_global.user_id,

825: FORALL j IN l_charge_line_list.FIRST..l_charge_line_list.LAST
826: UPDATE inl_charge_lines
827: SET party_site_id = p_to_fk_id,
828: last_update_date = sysdate,
829: last_updated_by = fnd_global.user_id,
830: last_update_login = fnd_global.login_id
831: WHERE charge_line_id = l_charge_line_list(j);
832:
833: l_debug_info := 'Updated inl_charges. Number of Rows updated is ' || sql%rowcount;

Line 830: last_update_login = fnd_global.login_id

826: UPDATE inl_charge_lines
827: SET party_site_id = p_to_fk_id,
828: last_update_date = sysdate,
829: last_updated_by = fnd_global.user_id,
830: last_update_login = fnd_global.login_id
831: WHERE charge_line_id = l_charge_line_list(j);
832:
833: l_debug_info := 'Updated inl_charges. Number of Rows updated is ' || sql%rowcount;
834: INL_LOGGING_PVT.Log_Statement ( p_module_name => g_module_name,