APPS.QPR_DEAL_ETL dependencies on QPR_DEAL_PVT

Line 22: qpr_deal_pvt.debug_ext_log(text, g_origin);

18: begin
19: fnd_file.put_line( fnd_file.log, text);
20:
21: if (g_origin = 660 or g_origin = 697) then
22: qpr_deal_pvt.debug_ext_log(text, g_origin);
23: end if;
24: end;
25:
26: procedure insert_price_adj_recs(

Line 1328: p_er_det_rec in qpr_deal_pvt.pn_aw_data_rec)

1324:
1325: procedure insert_price_int_adj_recs(p_source_ref_hdr_id in number,
1326: p_source_ref_line_id in number,
1327: p_src_id in number,
1328: p_er_det_rec in qpr_deal_pvt.pn_aw_data_rec)
1329: is
1330: cursor c_offadj(p_sm_code varchar2, p_pt_code varchar2,
1331: p_rbt_code varchar2,
1332: p_sm_oad_val number, p_pt_oad_val number,

Line 1635: l_vol_band := qpr_deal_pvt.get_volume_band(errbuf, retcode,

1631:
1632: if l_uom_conversion_odm < 0 then
1633: l_vol_band := null;
1634: else
1635: l_vol_band := qpr_deal_pvt.get_volume_band(errbuf, retcode,
1636: int_lines_rec.inventory_item_id,
1637: int_lines_rec.ordered_qty * l_uom_conversion_odm,
1638: l_transf_group_id);
1639: end if;

Line 1642: l_datamart_id := qpr_deal_pvt.assign_aw(errbuf, retcode,

1638: l_transf_group_id);
1639: end if;
1640: -- assign aw --
1641: log_debug('Findind Datamart');
1642: l_datamart_id := qpr_deal_pvt.assign_aw(errbuf, retcode,
1643: l_deal_instance,
1644: int_lines_rec.inventory_item_id,
1645: int_lines_rec.org_id,
1646: c_int_header_rec.sales_rep_id,

Line 1701: g_t_aw_det := qpr_deal_pvt.pn_aw_tbl_type();

1697: lines_rec.source_ref_line_id, lines_rec.source_id, 'INVPRICE');
1698: l_gross_rev := l_inv_price * lines_rec.ordered_qty;
1699:
1700: if l_line_ctr = 1 then
1701: g_t_aw_det := qpr_deal_pvt.pn_aw_tbl_type();
1702: end if;
1703: g_t_aw_det.extend;
1704: g_t_aw_det(l_line_ctr).PN_LINE_ID := lines_rec.SOURCE_REF_LINE_ID;
1705: g_t_aw_det(l_line_ctr).CUSTOMER_SK:= 'TRADING_PARTNER_L_' ||

Line 1745: qpr_deal_pvt.get_line_aw_details(errbuf, retcode,

1741:
1742: l_line_ctr := l_line_ctr + 1;
1743: end loop;
1744:
1745: qpr_deal_pvt.get_line_aw_details(errbuf, retcode,
1746: aw_rec.price_plan_id,
1747: l_deal_instance,
1748: g_t_aw_det);
1749:

Line 2428: l_vol_band := qpr_deal_pvt.get_volume_band(errbuf, retcode,

2424:
2425: if l_uom_conversion_odm < 0 then
2426: l_vol_band := null;
2427: else
2428: l_vol_band := qpr_deal_pvt.get_volume_band(errbuf, retcode,
2429: i_inventory_item_id,
2430: i_ordered_qty * l_uom_conversion_odm,
2431: l_transf_group_id);
2432: end if;