DBA Data[Home] [Help]

APPS.OKS_BILLING_PUB dependencies on OKS_QP_PKG

Line 428: (p_detail_rec in oks_qp_pkg.input_details,

424: --Procedure to insert data into OKS_USG_QP_CALL_TBL for calling QP in bulk
425: --skuchima 05-Jan-2012 Bug 13105205 Ceredian ER
426: --------------------------------------------------------------
427: Procedure Insert_usg_qp_dtls_prc
428: (p_detail_rec in oks_qp_pkg.input_details,
429: dnz_chr_id in number,
430: currency_code IN VARCHAR2 ,
431: prorate IN VARCHAR2,
432: prv IN number,

Line 1348: /*skuchima Ceredian ER comment the call to OKS_QP_PKG and dump the data into a temp table */

1344: l_line_rec.price_list_line_id
1345: :=nvl(bsl_price_rec.locked_price_list_line_id,l_locked_price_list_line_id);
1346:
1347:
1348: /*skuchima Ceredian ER comment the call to OKS_QP_PKG and dump the data into a temp table */
1349: /*Pricing API to calculate amount */
1350: /* OKS_QP_PKG.CALC_PRICE
1351: (
1352: P_DETAIL_REC => l_line_rec,

Line 1350: /* OKS_QP_PKG.CALC_PRICE

1346:
1347:
1348: /*skuchima Ceredian ER comment the call to OKS_QP_PKG and dump the data into a temp table */
1349: /*Pricing API to calculate amount */
1350: /* OKS_QP_PKG.CALC_PRICE
1351: (
1352: P_DETAIL_REC => l_line_rec,
1353: X_PRICE_DETAILS => l_price_rec,
1354: X_MODIFIER_DETAILS => l_modifier_details,

Line 1802: l_price_break_tbl OKS_QP_PKG.G_PRICE_BREAK_TBL_TYPE;

1798:
1799: lx_return_status varchar2 (1);
1800: lx_return_status_text varchar2 (2000);
1801:
1802: l_price_break_tbl OKS_QP_PKG.G_PRICE_BREAK_TBL_TYPE;
1803:
1804:
1805: g_req_line_tbl_blk qp_preq_grp.line_tbl_type;
1806: g_req_line_detail_tbl_blk qp_preq_grp.line_detail_tbl_type;

Line 1830: x_price_details OKS_QP_PKG.Price_Details ;

1826: l_pbr_rec_in OKS_PBR_PVT.pbrv_rec_type;
1827: l_pbr_rec_out OKS_PBR_PVT.pbrv_rec_type;
1828:
1829: x_return_status VARCHAR2(1);
1830: x_price_details OKS_QP_PKG.Price_Details ;
1831: x_modifier_details QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
1832: x_price_break_details OKS_QP_PKG.G_PRICE_BREAK_TBL_TYPE;
1833: x_msg_data varchar2(1000);
1834: x_msg_count NUMBER;

Line 1832: x_price_break_details OKS_QP_PKG.G_PRICE_BREAK_TBL_TYPE;

1828:
1829: x_return_status VARCHAR2(1);
1830: x_price_details OKS_QP_PKG.Price_Details ;
1831: x_modifier_details QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
1832: x_price_break_details OKS_QP_PKG.G_PRICE_BREAK_TBL_TYPE;
1833: x_msg_data varchar2(1000);
1834: x_msg_count NUMBER;
1835:
1836: i NUMBER;

Line 1853: l_line_rec OKS_QP_PKG.INPUT_DETAILS ;

1849: l_msg_data VARCHAR2(2000);
1850: l_msg_cnt NUMBER;
1851: l_return_status VARCHAR2(1);
1852:
1853: l_line_rec OKS_QP_PKG.INPUT_DETAILS ;
1854:
1855:
1856: l_prorate VARCHAR2(10);
1857:

Line 2016: ---call oks_qp_pkg.calc_price_pre to populate input bulk table

2012: l_line_rec.bill_to_date :=bulk_qp_call_rec.bill_to_date;
2013: l_line_rec.asking_unit_price :=bulk_qp_call_rec.asking_unit_price;
2014:
2015:
2016: ---call oks_qp_pkg.calc_price_pre to populate input bulk table
2017: oks_qp_pkg.calc_price_pre
2018: (p_detail_rec => l_line_rec,
2019: l_control_rec => l_control_rec ,
2020: l_req_line_tbl => l_req_line_tbl ,

Line 2017: oks_qp_pkg.calc_price_pre

2013: l_line_rec.asking_unit_price :=bulk_qp_call_rec.asking_unit_price;
2014:
2015:
2016: ---call oks_qp_pkg.calc_price_pre to populate input bulk table
2017: oks_qp_pkg.calc_price_pre
2018: (p_detail_rec => l_line_rec,
2019: l_control_rec => l_control_rec ,
2020: l_req_line_tbl => l_req_line_tbl ,
2021: l_req_qual_tbl => l_req_qual_tbl ,

Line 4372: OKS_QP_PKG.CALC_PRICE

4368:
4369: /*Ceredian ER 13105205 */
4370: If (l_line_rec.usage_qty <>0 OR ( l_line_rec.usage_qty=0 AND nvl(FND_PROFILE.VALUE('OKS_USAGE_SKIP_QP_CALL_ZERO_QTY'),'N') = 'N')) THEN
4371: /*Pricing API to calculate amount */
4372: OKS_QP_PKG.CALC_PRICE
4373: (
4374: P_DETAIL_REC => l_line_rec,
4375: X_PRICE_DETAILS => l_price_rec,
4376: X_MODIFIER_DETAILS => l_modifier_details,