17: UOM_CONV_SRC_TBL constant varchar2(30) := 'QPR_SR_UOM_CONVERSIONS_V';
18: procedure insert_uom_data(p_instance_id in number) is
19: request_id number;
20: sys_date date:= sysdate;
21: user_id number:= fnd_global.user_id;
22: login_id number:= fnd_global.conc_login_id;
23: prg_appl_id number:= fnd_global.prog_appl_id;
24: prg_id number:= fnd_global.conc_program_id;
25: begin
18: procedure insert_uom_data(p_instance_id in number) is
19: request_id number;
20: sys_date date:= sysdate;
21: user_id number:= fnd_global.user_id;
22: login_id number:= fnd_global.conc_login_id;
23: prg_appl_id number:= fnd_global.prog_appl_id;
24: prg_id number:= fnd_global.conc_program_id;
25: begin
26: fnd_profile.get('CONC_REQUEST_ID', request_id);
19: request_id number;
20: sys_date date:= sysdate;
21: user_id number:= fnd_global.user_id;
22: login_id number:= fnd_global.conc_login_id;
23: prg_appl_id number:= fnd_global.prog_appl_id;
24: prg_id number:= fnd_global.conc_program_id;
25: begin
26: fnd_profile.get('CONC_REQUEST_ID', request_id);
27: forall i in r_uom_data.FROM_UOM_CLASS.first..r_uom_data.FROM_UOM_CLASS.last
20: sys_date date:= sysdate;
21: user_id number:= fnd_global.user_id;
22: login_id number:= fnd_global.conc_login_id;
23: prg_appl_id number:= fnd_global.prog_appl_id;
24: prg_id number:= fnd_global.conc_program_id;
25: begin
26: fnd_profile.get('CONC_REQUEST_ID', request_id);
27: forall i in r_uom_data.FROM_UOM_CLASS.first..r_uom_data.FROM_UOM_CLASS.last
28: insert into QPR_UOM_CONVERSIONS(UOM_CONV_ID, FROM_UOM_CLASS, TO_UOM_CLASS,