eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QPR_TRANSFORMATION dependencies on QPR_SR_UTIL

Line 268: l_all_desc := qpr_sr_util.get_all_dsb_desc;

264: begin
265: select qpr_dimension_values_s.nextval
266: into l_next_seq from dual ;
267: if transf_header_rec.to_dim_code = 'DSB' then
268: l_all_desc := qpr_sr_util.get_all_dsb_desc;
269: l_all_value := qpr_sr_util.get_all_dsb_pk;
270: elsif transf_header_rec.to_dim_code = 'VLB' then
271: l_all_desc := qpr_sr_util.get_all_vlb_desc;
272: l_all_value := qpr_sr_util.get_all_vlb_pk;

Line 269: l_all_value := qpr_sr_util.get_all_dsb_pk;

265: select qpr_dimension_values_s.nextval
266: into l_next_seq from dual ;
267: if transf_header_rec.to_dim_code = 'DSB' then
268: l_all_desc := qpr_sr_util.get_all_dsb_desc;
269: l_all_value := qpr_sr_util.get_all_dsb_pk;
270: elsif transf_header_rec.to_dim_code = 'VLB' then
271: l_all_desc := qpr_sr_util.get_all_vlb_desc;
272: l_all_value := qpr_sr_util.get_all_vlb_pk;
273: elsif transf_header_rec.to_dim_code = 'MGB' then

Line 271: l_all_desc := qpr_sr_util.get_all_vlb_desc;

267: if transf_header_rec.to_dim_code = 'DSB' then
268: l_all_desc := qpr_sr_util.get_all_dsb_desc;
269: l_all_value := qpr_sr_util.get_all_dsb_pk;
270: elsif transf_header_rec.to_dim_code = 'VLB' then
271: l_all_desc := qpr_sr_util.get_all_vlb_desc;
272: l_all_value := qpr_sr_util.get_all_vlb_pk;
273: elsif transf_header_rec.to_dim_code = 'MGB' then
274: l_all_desc := qpr_sr_util.get_all_mgb_desc;
275: l_all_value := qpr_sr_util.get_all_mgb_pk;

Line 272: l_all_value := qpr_sr_util.get_all_vlb_pk;

268: l_all_desc := qpr_sr_util.get_all_dsb_desc;
269: l_all_value := qpr_sr_util.get_all_dsb_pk;
270: elsif transf_header_rec.to_dim_code = 'VLB' then
271: l_all_desc := qpr_sr_util.get_all_vlb_desc;
272: l_all_value := qpr_sr_util.get_all_vlb_pk;
273: elsif transf_header_rec.to_dim_code = 'MGB' then
274: l_all_desc := qpr_sr_util.get_all_mgb_desc;
275: l_all_value := qpr_sr_util.get_all_mgb_pk;
276: end if;

Line 274: l_all_desc := qpr_sr_util.get_all_mgb_desc;

270: elsif transf_header_rec.to_dim_code = 'VLB' then
271: l_all_desc := qpr_sr_util.get_all_vlb_desc;
272: l_all_value := qpr_sr_util.get_all_vlb_pk;
273: elsif transf_header_rec.to_dim_code = 'MGB' then
274: l_all_desc := qpr_sr_util.get_all_mgb_desc;
275: l_all_value := qpr_sr_util.get_all_mgb_pk;
276: end if;
277: fnd_file.put_line(fnd_file.log,
278: 'Inserting band dim with id :'||l_next_seq);

Line 275: l_all_value := qpr_sr_util.get_all_mgb_pk;

271: l_all_desc := qpr_sr_util.get_all_vlb_desc;
272: l_all_value := qpr_sr_util.get_all_vlb_pk;
273: elsif transf_header_rec.to_dim_code = 'MGB' then
274: l_all_desc := qpr_sr_util.get_all_mgb_desc;
275: l_all_value := qpr_sr_util.get_all_mgb_pk;
276: end if;
277: fnd_file.put_line(fnd_file.log,
278: 'Inserting band dim with id :'||l_next_seq);
279: INSERT INTO qpr_dimension_values(instance_id,