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.OKS_BILL_SCH dependencies on OKS_BILL_SCH

Line 1: Package Body OKS_BILL_SCH AS

1: Package Body OKS_BILL_SCH AS
2: /* $Header: OKSBLSHB.pls 120.45 2007/12/24 11:51:51 harlaksh noship $ */
3:
4:
5: l_strm_lvl_tbl_in oks_sll_pvt.sllv_tbl_type;

Line 333: x_sll_db_tbl OUT NOCOPY OKS_BILL_SCH.StreamLvl_tbl,

329:
330: PROCEDURE Get_SLL_info(p_top_line_id IN NUMBER,
331: p_line_id IN NUMBER,
332: x_sll_tbl OUT NOCOPY StrmLvl_Out_tbl,
333: x_sll_db_tbl OUT NOCOPY OKS_BILL_SCH.StreamLvl_tbl,
334: x_return_status OUT NOCOPY VARCHAR2);
335:
336: PROCEDURE Del_line_sll_lvl(p_line_id IN NUMBER,
337: x_return_status OUT NOCOPY VARCHAR2,

Line 370: p_new_sll_tbl IN OUT NOCOPY oks_bill_sch.StreamLvl_tbl,

366: Procedure Prorate_sll_amt(
367: p_old_cp_amt IN NUMBER,
368: p_new_cp_amt IN NUMBER,
369: p_total_amt IN NUMBER,
370: p_new_sll_tbl IN OUT NOCOPY oks_bill_sch.StreamLvl_tbl,
371: p_old_sll_tbl IN OUT NOCOPY oks_bill_sch.StreamLvl_tbl,
372: x_return_status OUT NOCOPY VARCHAR2);
373:
374:

Line 371: p_old_sll_tbl IN OUT NOCOPY oks_bill_sch.StreamLvl_tbl,

367: p_old_cp_amt IN NUMBER,
368: p_new_cp_amt IN NUMBER,
369: p_total_amt IN NUMBER,
370: p_new_sll_tbl IN OUT NOCOPY oks_bill_sch.StreamLvl_tbl,
371: p_old_sll_tbl IN OUT NOCOPY oks_bill_sch.StreamLvl_tbl,
372: x_return_status OUT NOCOPY VARCHAR2);
373:
374:
375: l_currency_code Varchar2(15);

Line 562: l_unit_price := OKS_BILL_SCH.Get_Converted_price(

558: RETURN(0);
559: END IF;
560: ELSE --billed to is null = never billed cases
561: IF nvl(lin_det_rec.toplvl_uom_code,l_uom) <> P_billing_uom THEN
562: l_unit_price := OKS_BILL_SCH.Get_Converted_price(
563: p_price_uom =>P_billing_uom,
564: p_pl_uom =>nvl(lin_det_rec.toplvl_uom_code,l_uom),
565: p_period_start =>p_period_start,
566: p_period_type =>p_period_type,

Line 817: l_sll_tbl OKS_BILL_SCH.StreamLvl_tbl;

813: l_Contract_Rec l_contract_Csr%Rowtype;
814: l_sll_out_tbl StrmLvl_Out_tbl;
815: l_sll_count NUMBER;
816: l_bil_sch_out_tbl ItemBillSch_tbl;
817: l_sll_tbl OKS_BILL_SCH.StreamLvl_tbl;
818: l_line_inv_id NUMBER;
819: --
820:
821: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;

Line 1237: l_sll_tbl OKS_BILL_SCH.StreamLvl_tbl;

1233: l_SubLine_Csr_Rec l_subLine_Csr%Rowtype;
1234: l_sll_out_tbl StrmLvl_Out_tbl;
1235: l_top_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;
1236: l_line_BS_rec l_line_BS_csr%rowtype;
1237: l_sll_tbl OKS_BILL_SCH.StreamLvl_tbl;
1238:
1239:
1240: l_dnz_chr_id Number;
1241: l_sll_count NUMBER;

Line 2435: l_cp_sll_tbl OKS_BILL_SCH.StreamLvl_tbl;

2431: WHERE line.id = p_line_id
2432: AND line.id = dtl.cle_id;
2433:
2434: l_cp_sll_out_tbl StrmLvl_Out_tbl;
2435: l_cp_sll_tbl OKS_BILL_SCH.StreamLvl_tbl;
2436: l_line_amt NUMBER;
2437: l_subline_amt NUMBER;
2438:
2439: BEGIN

Line 5112: L_bil_sch_out_tbl OKS_BILL_SCH.ItemBillSch_tbl;

5108: l_cp_rec Prod_Det_Type;
5109: l_line_rec Line_Det_Type;
5110:
5111:
5112: L_bil_sch_out_tbl OKS_BILL_SCH.ItemBillSch_tbl;
5113: l_top_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;
5114: l_sll_tbl OKS_BILL_SCH.StreamLvl_tbl;
5115: l_update_required VARCHAR2(1);
5116: l_cp_term_dt DATE;

Line 5114: l_sll_tbl OKS_BILL_SCH.StreamLvl_tbl;

5110:
5111:
5112: L_bil_sch_out_tbl OKS_BILL_SCH.ItemBillSch_tbl;
5113: l_top_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;
5114: l_sll_tbl OKS_BILL_SCH.StreamLvl_tbl;
5115: l_update_required VARCHAR2(1);
5116: l_cp_term_dt DATE;
5117: l_amount NUMBER;
5118:

Line 5299: OKS_BILL_SCH.UPDATE_BS_ENDDATE(p_line_id => p_top_line_id,

5295:
5296: -----errorout_ad('SLL found');
5297: ---for migrated contracts without end date
5298: IF l_update_required = 'Y' THEN
5299: OKS_BILL_SCH.UPDATE_BS_ENDDATE(p_line_id => p_top_line_id,
5300: p_chr_id => NULL,
5301: x_return_status => x_return_status);
5302:
5303: IF x_return_status <> 'S' then

Line 5419: OKS_BILL_SCH.Create_Bill_Sch_Rules

5415:
5416: -----errorout_ad('line bs found');
5417:
5418: IF l_top_bs_tbl.COUNT = 0 THEN ---BS NOT CREATED FOR TOP LINE
5419: OKS_BILL_SCH.Create_Bill_Sch_Rules
5420: (
5421: p_billing_type => l_Line_Csr_Rec.billing_schedule_type,
5422: p_sll_tbl => l_sll_tbl,
5423: p_invoice_rule_id => l_line_csr_rec.inv_id,

Line 5589: l_sll_tbl OKS_BILL_SCH.StreamLvl_tbl;

5585: WHERE cle_id = p_top_line_id;
5586:
5587:
5588:
5589: l_sll_tbl OKS_BILL_SCH.StreamLvl_tbl;
5590: L_BIL_SCH_OUT_TBL OKS_BILL_SCH.ItemBillSch_tbl;
5591:
5592:
5593: l_Line_Sll_rec l_Line_Sll_Csr%ROWTYPE;

Line 5590: L_BIL_SCH_OUT_TBL OKS_BILL_SCH.ItemBillSch_tbl;

5586:
5587:
5588:
5589: l_sll_tbl OKS_BILL_SCH.StreamLvl_tbl;
5590: L_BIL_SCH_OUT_TBL OKS_BILL_SCH.ItemBillSch_tbl;
5591:
5592:
5593: l_Line_Sll_rec l_Line_Sll_Csr%ROWTYPE;
5594: l_Line_csr_Rec l_Line_Csr%Rowtype;

Line 5811: OKS_BILL_SCH.UPDATE_BS_ENDDATE(p_line_id => p_top_line_id,

5807: RETURN;
5808: END IF;
5809:
5810: IF l_update_end_date = 'Y' THEN ---Migrated
5811: OKS_BILL_SCH.UPDATE_BS_ENDDATE(p_line_id => p_top_line_id,
5812: p_chr_id => NULL,
5813: x_return_status => x_return_status);
5814:
5815: IF x_return_status <> 'S' THEN

Line 6697: OKS_BILL_SCH.Create_Bill_Sch_Rules

6693: END IF;
6694:
6695: IF l_sll_tbl.COUNT > 0 THEN
6696:
6697: OKS_BILL_SCH.Create_Bill_Sch_Rules
6698: (p_billing_type => l_line_csr_rec.billing_schedule_type,
6699: p_sll_tbl => l_sll_tbl,
6700: p_invoice_rule_id => l_line_csr_rec.inv_id,
6701: x_bil_sch_out_tbl => l_bil_sch_out_tbl,

Line 6706: 'oks_bill_sch.Create_Bill_Sch_Rules(x_return_status = '||x_return_status ||')');

6702: x_return_status => x_return_status);
6703:
6704: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
6705: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_dates_sll.call_bs',
6706: 'oks_bill_sch.Create_Bill_Sch_Rules(x_return_status = '||x_return_status ||')');
6707: END IF;
6708:
6709: IF x_return_status <> 'S' THEN
6710: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 6956: l_sll_tbl OKS_BILL_SCH.StreamLvl_tbl;

6952:
6953:
6954:
6955:
6956: l_sll_tbl OKS_BILL_SCH.StreamLvl_tbl;
6957: L_BIL_SCH_OUT_TBL OKS_BILL_SCH.ItemBillSch_tbl;
6958: l_inv_id number;
6959:
6960: l_Line_Sll_rec l_Line_Sll_Csr%ROWTYPE;

Line 6957: L_BIL_SCH_OUT_TBL OKS_BILL_SCH.ItemBillSch_tbl;

6953:
6954:
6955:
6956: l_sll_tbl OKS_BILL_SCH.StreamLvl_tbl;
6957: L_BIL_SCH_OUT_TBL OKS_BILL_SCH.ItemBillSch_tbl;
6958: l_inv_id number;
6959:
6960: l_Line_Sll_rec l_Line_Sll_Csr%ROWTYPE;
6961: l_Line_Rec l_Line_Csr%Rowtype;

Line 7077: OKS_BILL_SCH.Create_Bill_Sch_Rules

7073:
7074:
7075: IF l_sll_tbl.COUNT > 0 THEN
7076:
7077: OKS_BILL_SCH.Create_Bill_Sch_Rules
7078: (p_billing_type => l_line_rec.billing_schedule_type,
7079: p_sll_tbl => l_sll_tbl,
7080: p_invoice_rule_id => l_line_rec.inv_rule_id,
7081: x_bil_sch_out_tbl => l_bil_sch_out_tbl,

Line 7870: oks_bill_sch.Cascade_Dates_SLL

7866: x_return_status := OKC_API.G_RET_STS_SUCCESS;
7867:
7868:
7869: IF p_line_id IS NOT NULL THEN
7870: oks_bill_sch.Cascade_Dates_SLL
7871: (
7872: p_top_line_id => p_line_id,
7873: x_return_status => x_return_status,
7874: x_msg_count => l_msg_count,

Line 7882: oks_bill_sch.Cascade_Dates_SLL

7878:
7879: FOR l_top_line_rec IN l_top_line_Csr
7880: LOOP
7881:
7882: oks_bill_sch.Cascade_Dates_SLL
7883: (
7884: p_top_line_id => l_top_line_rec.id,
7885: x_return_status => x_return_status,
7886: x_msg_count => l_msg_count,

Line 8409: L_BIL_SCH_OUT_TBL OKS_BILL_SCH.ItemBillSch_tbl;

8405:
8406: l_Line_Sll_rec l_Line_Sll_Csr%ROWTYPE;
8407: l_Line_Rec l_Line_Csr%Rowtype;
8408:
8409: L_BIL_SCH_OUT_TBL OKS_BILL_SCH.ItemBillSch_tbl;
8410: l_top_line_rec Line_Det_Type;
8411: l_update_end_date VARCHAR2(1);
8412:
8413:

Line 8530: OKS_BILL_SCH.UPDATE_BS_ENDDATE(p_line_id => p_top_line_id,

8526: RETURN;
8527: END IF;
8528:
8529: IF l_update_end_date = 'Y' THEN ---Migrated
8530: OKS_BILL_SCH.UPDATE_BS_ENDDATE(p_line_id => p_top_line_id,
8531: p_chr_id => NULL,
8532: x_return_status => x_return_status);
8533:
8534: IF x_return_status <> 'S' THEN

Line 8622: x_sll_db_tbl OUT NOCOPY OKS_BILL_SCH.StreamLvl_tbl,

8618:
8619: PROCEDURE Get_SLL_info(p_top_line_id IN NUMBER,
8620: p_line_id IN NUMBER,
8621: x_sll_tbl OUT NOCOPY StrmLvl_Out_tbl,
8622: x_sll_db_tbl OUT NOCOPY OKS_BILL_SCH.StreamLvl_tbl,
8623: x_return_status OUT NOCOPY VARCHAR2)
8624:
8625: IS
8626:

Line 8637: l_sll_tbl OKS_BILL_SCH.StreamLvl_tbl;

8633: FROM OKS_STREAM_LEVELS_B
8634: WHERE cle_id = p_line_id
8635: ORDER BY sequence_no;
8636:
8637: l_sll_tbl OKS_BILL_SCH.StreamLvl_tbl;
8638: l_index NUMBER;
8639: l_Line_Sll_rec l_Line_Sll_csr%ROWTYPE;
8640: l_update_end_date VARCHAR2(1) := 'N';
8641:

Line 8686: OKS_BILL_SCH.UPDATE_BS_ENDDATE(p_line_id => p_top_line_id,

8682: RETURN;
8683: END IF;
8684:
8685: IF l_update_end_date = 'Y' THEN ---Migrated
8686: OKS_BILL_SCH.UPDATE_BS_ENDDATE(p_line_id => p_top_line_id,
8687: p_chr_id => NULL,
8688: x_return_status => x_return_status);
8689:
8690: IF x_return_status <> 'S' THEN

Line 8813: l_sll_db_tbl oks_bill_sch.StreamLvl_tbl;

8809: l_inv_id number;
8810: l_prev_term_dt date;
8811:
8812: l_sll_in_tbl StrmLvl_Out_tbl;
8813: l_sll_db_tbl oks_bill_sch.StreamLvl_tbl;
8814: l_top_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;
8815:
8816: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;
8817:

Line 9664: l_constant_sll_amt := OKS_BILL_SCH.Get_Unit_Price_Per_Uom

9660: THEN
9661: --new procedure for CALENDAR START and service start
9662: --30-DEC-2005 mchoudha fixed bug#4895586
9663: --Added an extra parameter termination date to this API
9664: l_constant_sll_amt := OKS_BILL_SCH.Get_Unit_Price_Per_Uom
9665: (p_SubLine_rec.cp_id,
9666: p_cp_sll_tbl(l_cp_sll_counter).uom,
9667: p_period_start,
9668: p_period_type,

Line 9675: 'after calling OKS_BILL_SCH.Get_Unit_Price_Per_Uom '

9671: p_term_dt);
9672:
9673: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9674: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Create_cp_lvl_elements',
9675: 'after calling OKS_BILL_SCH.Get_Unit_Price_Per_Uom '
9676: ||' result l_constant_sll_amt = ' || l_constant_sll_amt);
9677: END IF;
9678: IF l_constant_sll_amt IS NULL THEN
9679: x_return_status := G_RET_STS_ERROR;

Line 10324: l_sll_tbl OKS_BILL_SCH.StreamLvl_tbl;

10320:
10321:
10322: l_hdr_sll_rec l_hdr_sll_csr%ROWTYPE;
10323: l_Contract_Rec l_contract_Csr%Rowtype;
10324: l_sll_tbl OKS_BILL_SCH.StreamLvl_tbl;
10325: l_hdr_rec contract_rec_type;
10326:
10327:
10328: L_SLL_OUT_TBl StrmLvl_Out_tbl;

Line 11170: l_sll_tbl OKS_BILL_SCH.StreamLvl_tbl;

11166: x_return_status OUT NOCOPY Varchar2)
11167:
11168:
11169: IS
11170: l_sll_tbl OKS_BILL_SCH.StreamLvl_tbl;
11171: l_index NUMBER;
11172: l_sll_prorate_tbl sll_prorated_tab_type;
11173: l_bill_sch_amt NUMBER;
11174: l_next_cycle_dt DATE;

Line 11646: p_new_cp_tbl IN OKS_BILL_SCH.SUBLINE_ID_TBL,

11642:
11643: END ADJUST_REPLACE_PRODUCT_BS;
11644:
11645: Procedure ADJUST_SPLIT_BILL_SCH(p_old_cp_id IN NUMBER,
11646: p_new_cp_tbl IN OKS_BILL_SCH.SUBLINE_ID_TBL,
11647: x_return_status OUT NOCOPY VARCHAR2,
11648: x_msg_count OUT NOCOPY NUMBER,
11649: x_msg_data OUT NOCOPY VARCHAR2)
11650:

Line 11696: l_sll_db_tbl oks_bill_sch.StreamLvl_tbl;

11692: l_line_rec l_line_csr%ROWTYPE;
11693: l_line_BS_rec l_line_BS_csr%ROWTYPE;
11694: l_sll_in_tbl StrmLvl_Out_tbl;
11695: l_cp_sll_out_tbl StrmLvl_Out_tbl;
11696: l_sll_db_tbl oks_bill_sch.StreamLvl_tbl;
11697: l_top_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;
11698: l_new_sll_tbl oks_bill_sch.StreamLvl_tbl;
11699: l_cp_new_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;
11700: l_cp_old_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;

Line 11698: l_new_sll_tbl oks_bill_sch.StreamLvl_tbl;

11694: l_sll_in_tbl StrmLvl_Out_tbl;
11695: l_cp_sll_out_tbl StrmLvl_Out_tbl;
11696: l_sll_db_tbl oks_bill_sch.StreamLvl_tbl;
11697: l_top_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;
11698: l_new_sll_tbl oks_bill_sch.StreamLvl_tbl;
11699: l_cp_new_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;
11700: l_cp_old_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;
11701:
11702:

Line 12410: p_new_sll_tbl IN OUT NOCOPY oks_bill_sch.StreamLvl_tbl,

12406: Procedure Prorate_sll_amt(
12407: p_old_cp_amt IN NUMBER,
12408: p_new_cp_amt IN NUMBER,
12409: p_total_amt IN NUMBER,
12410: p_new_sll_tbl IN OUT NOCOPY oks_bill_sch.StreamLvl_tbl,
12411: p_old_sll_tbl IN OUT NOCOPY oks_bill_sch.StreamLvl_tbl,
12412: x_return_status OUT NOCOPY VARCHAR2)
12413:
12414: IS

Line 12411: p_old_sll_tbl IN OUT NOCOPY oks_bill_sch.StreamLvl_tbl,

12407: p_old_cp_amt IN NUMBER,
12408: p_new_cp_amt IN NUMBER,
12409: p_total_amt IN NUMBER,
12410: p_new_sll_tbl IN OUT NOCOPY oks_bill_sch.StreamLvl_tbl,
12411: p_old_sll_tbl IN OUT NOCOPY oks_bill_sch.StreamLvl_tbl,
12412: x_return_status OUT NOCOPY VARCHAR2)
12413:
12414: IS
12415: l_tot_amt NUMBER;

Line 12688: OKS_BILL_SCH.Cascade_Dates_SLL

12684: -- amount matches with that of the price_negotiated amount of the service line
12685:
12686: IF (nvl(l_dummy, 2) <> 1 ) THEN
12687:
12688: OKS_BILL_SCH.Cascade_Dates_SLL
12689: (
12690: p_top_line_id => p_cle_id,
12691: x_return_status => x_return_status,
12692: x_msg_count => l_msg_count,

Line 12818: END OKS_BILL_SCH;

12814:
12815:
12816:
12817:
12818: END OKS_BILL_SCH;