14:
15: procedure insert_curr_rate_data(p_instance_id in number) is
16: request_id number;
17: sys_date date:= sysdate;
18: user_id number:= fnd_global.user_id;
19: login_id number:= fnd_global.conc_login_id;
20: prg_appl_id number:= fnd_global.prog_appl_id;
21: prg_id number:= fnd_global.conc_program_id;
22: begin
15: procedure insert_curr_rate_data(p_instance_id in number) is
16: request_id number;
17: sys_date date:= sysdate;
18: user_id number:= fnd_global.user_id;
19: login_id number:= fnd_global.conc_login_id;
20: prg_appl_id number:= fnd_global.prog_appl_id;
21: prg_id number:= fnd_global.conc_program_id;
22: begin
23: fnd_profile.get('CONC_REQUEST_ID', request_id);
16: request_id number;
17: sys_date date:= sysdate;
18: user_id number:= fnd_global.user_id;
19: login_id number:= fnd_global.conc_login_id;
20: prg_appl_id number:= fnd_global.prog_appl_id;
21: prg_id number:= fnd_global.conc_program_id;
22: begin
23: fnd_profile.get('CONC_REQUEST_ID', request_id);
24: forall i in r_curr_data.FROM_CURRENCY.first..r_curr_data.FROM_CURRENCY.last
17: sys_date date:= sysdate;
18: user_id number:= fnd_global.user_id;
19: login_id number:= fnd_global.conc_login_id;
20: prg_appl_id number:= fnd_global.prog_appl_id;
21: prg_id number:= fnd_global.conc_program_id;
22: begin
23: fnd_profile.get('CONC_REQUEST_ID', request_id);
24: forall i in r_curr_data.FROM_CURRENCY.first..r_curr_data.FROM_CURRENCY.last
25: insert into QPR_CURRENCY_RATES(CURR_CONV_ID, FROM_CURRENCY, TO_CURRENCY,