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.46.12020000.8 2013/05/10 13:58:30 spingali ship $ */
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 2452: l_cp_sll_tbl OKS_BILL_SCH.StreamLvl_tbl;

2448: WHERE line.id = p_line_id
2449: AND line.id = dtl.cle_id;
2450:
2451: l_cp_sll_out_tbl StrmLvl_Out_tbl;
2452: l_cp_sll_tbl OKS_BILL_SCH.StreamLvl_tbl;
2453: l_line_amt NUMBER;
2454: l_subline_amt NUMBER;
2455:
2456: BEGIN

Line 5129: L_bil_sch_out_tbl OKS_BILL_SCH.ItemBillSch_tbl;

5125: l_cp_rec Prod_Det_Type;
5126: l_line_rec Line_Det_Type;
5127:
5128:
5129: L_bil_sch_out_tbl OKS_BILL_SCH.ItemBillSch_tbl;
5130: l_top_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;
5131: l_sll_tbl OKS_BILL_SCH.StreamLvl_tbl;
5132: l_update_required VARCHAR2(1);
5133: l_cp_term_dt DATE;

Line 5131: l_sll_tbl OKS_BILL_SCH.StreamLvl_tbl;

5127:
5128:
5129: L_bil_sch_out_tbl OKS_BILL_SCH.ItemBillSch_tbl;
5130: l_top_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;
5131: l_sll_tbl OKS_BILL_SCH.StreamLvl_tbl;
5132: l_update_required VARCHAR2(1);
5133: l_cp_term_dt DATE;
5134: l_amount NUMBER;
5135:

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

5312:
5313: -----errorout_ad('SLL found');
5314: ---for migrated contracts without end date
5315: IF l_update_required = 'Y' THEN
5316: OKS_BILL_SCH.UPDATE_BS_ENDDATE(p_line_id => p_top_line_id,
5317: p_chr_id => NULL,
5318: x_return_status => x_return_status);
5319:
5320: IF x_return_status <> 'S' then

Line 5436: OKS_BILL_SCH.Create_Bill_Sch_Rules

5432:
5433: -----errorout_ad('line bs found');
5434:
5435: IF l_top_bs_tbl.COUNT = 0 THEN ---BS NOT CREATED FOR TOP LINE
5436: OKS_BILL_SCH.Create_Bill_Sch_Rules
5437: (
5438: p_billing_type => l_Line_Csr_Rec.billing_schedule_type,
5439: p_sll_tbl => l_sll_tbl,
5440: p_invoice_rule_id => l_line_csr_rec.inv_id,

Line 5606: l_sll_tbl OKS_BILL_SCH.StreamLvl_tbl;

5602: WHERE cle_id = p_top_line_id;
5603:
5604:
5605:
5606: l_sll_tbl OKS_BILL_SCH.StreamLvl_tbl;
5607: L_BIL_SCH_OUT_TBL OKS_BILL_SCH.ItemBillSch_tbl;
5608:
5609:
5610: l_Line_Sll_rec l_Line_Sll_Csr%ROWTYPE;

Line 5607: L_BIL_SCH_OUT_TBL OKS_BILL_SCH.ItemBillSch_tbl;

5603:
5604:
5605:
5606: l_sll_tbl OKS_BILL_SCH.StreamLvl_tbl;
5607: L_BIL_SCH_OUT_TBL OKS_BILL_SCH.ItemBillSch_tbl;
5608:
5609:
5610: l_Line_Sll_rec l_Line_Sll_Csr%ROWTYPE;
5611: l_Line_csr_Rec l_Line_Csr%Rowtype;

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

5826: RETURN;
5827: END IF;
5828:
5829: IF l_update_end_date = 'Y' THEN ---Migrated
5830: OKS_BILL_SCH.UPDATE_BS_ENDDATE(p_line_id => p_top_line_id,
5831: p_chr_id => NULL,
5832: x_return_status => x_return_status);
5833:
5834: IF x_return_status <> 'S' THEN

Line 6909: OKS_BILL_SCH.Create_Bill_Sch_Rules

6905: END IF;
6906:
6907: IF l_sll_tbl.COUNT > 0 THEN
6908:
6909: OKS_BILL_SCH.Create_Bill_Sch_Rules
6910: (p_billing_type => l_line_csr_rec.billing_schedule_type,
6911: p_sll_tbl => l_sll_tbl,
6912: p_invoice_rule_id => l_line_csr_rec.inv_id,
6913: x_bil_sch_out_tbl => l_bil_sch_out_tbl,

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

6914: x_return_status => x_return_status);
6915:
6916: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
6917: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_dates_sll.call_bs',
6918: 'oks_bill_sch.Create_Bill_Sch_Rules(x_return_status = '||x_return_status ||')');
6919: END IF;
6920:
6921: IF x_return_status <> 'S' THEN
6922: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 7168: l_sll_tbl OKS_BILL_SCH.StreamLvl_tbl;

7164:
7165:
7166:
7167:
7168: l_sll_tbl OKS_BILL_SCH.StreamLvl_tbl;
7169: L_BIL_SCH_OUT_TBL OKS_BILL_SCH.ItemBillSch_tbl;
7170: l_inv_id number;
7171:
7172: l_Line_Sll_rec l_Line_Sll_Csr%ROWTYPE;

Line 7169: L_BIL_SCH_OUT_TBL OKS_BILL_SCH.ItemBillSch_tbl;

7165:
7166:
7167:
7168: l_sll_tbl OKS_BILL_SCH.StreamLvl_tbl;
7169: L_BIL_SCH_OUT_TBL OKS_BILL_SCH.ItemBillSch_tbl;
7170: l_inv_id number;
7171:
7172: l_Line_Sll_rec l_Line_Sll_Csr%ROWTYPE;
7173: l_Line_Rec l_Line_Csr%Rowtype;

Line 7289: OKS_BILL_SCH.Create_Bill_Sch_Rules

7285:
7286:
7287: IF l_sll_tbl.COUNT > 0 THEN
7288:
7289: OKS_BILL_SCH.Create_Bill_Sch_Rules
7290: (p_billing_type => l_line_rec.billing_schedule_type,
7291: p_sll_tbl => l_sll_tbl,
7292: p_invoice_rule_id => l_line_rec.inv_rule_id,
7293: x_bil_sch_out_tbl => l_bil_sch_out_tbl,

Line 8083: oks_bill_sch.Cascade_Dates_SLL

8079: x_return_status := OKC_API.G_RET_STS_SUCCESS;
8080:
8081:
8082: IF p_line_id IS NOT NULL THEN
8083: oks_bill_sch.Cascade_Dates_SLL
8084: (
8085: p_top_line_id => p_line_id,
8086: x_return_status => x_return_status,
8087: x_msg_count => l_msg_count,

Line 8095: oks_bill_sch.Cascade_Dates_SLL

8091:
8092: FOR l_top_line_rec IN l_top_line_Csr
8093: LOOP
8094:
8095: oks_bill_sch.Cascade_Dates_SLL
8096: (
8097: p_top_line_id => l_top_line_rec.id,
8098: x_return_status => x_return_status,
8099: x_msg_count => l_msg_count,

Line 8622: L_BIL_SCH_OUT_TBL OKS_BILL_SCH.ItemBillSch_tbl;

8618:
8619: l_Line_Sll_rec l_Line_Sll_Csr%ROWTYPE;
8620: l_Line_Rec l_Line_Csr%Rowtype;
8621:
8622: L_BIL_SCH_OUT_TBL OKS_BILL_SCH.ItemBillSch_tbl;
8623: l_top_line_rec Line_Det_Type;
8624: l_update_end_date VARCHAR2(1);
8625:
8626:

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

8739: RETURN;
8740: END IF;
8741:
8742: IF l_update_end_date = 'Y' THEN ---Migrated
8743: OKS_BILL_SCH.UPDATE_BS_ENDDATE(p_line_id => p_top_line_id,
8744: p_chr_id => NULL,
8745: x_return_status => x_return_status);
8746:
8747: IF x_return_status <> 'S' THEN

Line 8835: x_sll_db_tbl OUT NOCOPY OKS_BILL_SCH.StreamLvl_tbl,

8831:
8832: PROCEDURE Get_SLL_info(p_top_line_id IN NUMBER,
8833: p_line_id IN NUMBER,
8834: x_sll_tbl OUT NOCOPY StrmLvl_Out_tbl,
8835: x_sll_db_tbl OUT NOCOPY OKS_BILL_SCH.StreamLvl_tbl,
8836: x_return_status OUT NOCOPY VARCHAR2)
8837:
8838: IS
8839:

Line 8850: l_sll_tbl OKS_BILL_SCH.StreamLvl_tbl;

8846: FROM OKS_STREAM_LEVELS_B
8847: WHERE cle_id = p_line_id
8848: ORDER BY sequence_no;
8849:
8850: l_sll_tbl OKS_BILL_SCH.StreamLvl_tbl;
8851: l_index NUMBER;
8852: l_Line_Sll_rec l_Line_Sll_csr%ROWTYPE;
8853: l_update_end_date VARCHAR2(1) := 'N';
8854:

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

8895: RETURN;
8896: END IF;
8897:
8898: IF l_update_end_date = 'Y' THEN ---Migrated
8899: OKS_BILL_SCH.UPDATE_BS_ENDDATE(p_line_id => p_top_line_id,
8900: p_chr_id => NULL,
8901: x_return_status => x_return_status);
8902:
8903: IF x_return_status <> 'S' THEN

Line 9026: l_sll_db_tbl oks_bill_sch.StreamLvl_tbl;

9022: l_inv_id number;
9023: l_prev_term_dt date;
9024:
9025: l_sll_in_tbl StrmLvl_Out_tbl;
9026: l_sll_db_tbl oks_bill_sch.StreamLvl_tbl;
9027: l_top_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;
9028:
9029: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;
9030:

Line 9881: l_constant_sll_amt := OKS_BILL_SCH.Get_Unit_Price_Per_Uom

9877: THEN
9878: --new procedure for CALENDAR START and service start
9879: --30-DEC-2005 mchoudha fixed bug#4895586
9880: --Added an extra parameter termination date to this API
9881: l_constant_sll_amt := OKS_BILL_SCH.Get_Unit_Price_Per_Uom
9882: (p_SubLine_rec.cp_id,
9883: p_cp_sll_tbl(l_cp_sll_counter).uom,
9884: p_period_start,
9885: p_period_type,

Line 9892: 'after calling OKS_BILL_SCH.Get_Unit_Price_Per_Uom '

9888: p_term_dt);
9889:
9890: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9891: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Create_cp_lvl_elements',
9892: 'after calling OKS_BILL_SCH.Get_Unit_Price_Per_Uom '
9893: ||' result l_constant_sll_amt = ' || l_constant_sll_amt);
9894: END IF;
9895: IF l_constant_sll_amt IS NULL THEN
9896: x_return_status := G_RET_STS_ERROR;

Line 10567: l_sll_tbl OKS_BILL_SCH.StreamLvl_tbl;

10563:
10564:
10565: l_hdr_sll_rec l_hdr_sll_csr%ROWTYPE;
10566: l_Contract_Rec l_contract_Csr%Rowtype;
10567: l_sll_tbl OKS_BILL_SCH.StreamLvl_tbl;
10568: l_hdr_rec contract_rec_type;
10569:
10570:
10571: L_SLL_OUT_TBl StrmLvl_Out_tbl;

Line 11413: l_sll_tbl OKS_BILL_SCH.StreamLvl_tbl;

11409: x_return_status OUT NOCOPY Varchar2)
11410:
11411:
11412: IS
11413: l_sll_tbl OKS_BILL_SCH.StreamLvl_tbl;
11414: l_index NUMBER;
11415: l_sll_prorate_tbl sll_prorated_tab_type;
11416: l_bill_sch_amt NUMBER;
11417: l_next_cycle_dt DATE;

Line 11889: p_new_cp_tbl IN OKS_BILL_SCH.SUBLINE_ID_TBL,

11885:
11886: END ADJUST_REPLACE_PRODUCT_BS;
11887:
11888: Procedure ADJUST_SPLIT_BILL_SCH(p_old_cp_id IN NUMBER,
11889: p_new_cp_tbl IN OKS_BILL_SCH.SUBLINE_ID_TBL,
11890: x_return_status OUT NOCOPY VARCHAR2,
11891: x_msg_count OUT NOCOPY NUMBER,
11892: x_msg_data OUT NOCOPY VARCHAR2)
11893:

Line 11939: l_sll_db_tbl oks_bill_sch.StreamLvl_tbl;

11935: l_line_rec l_line_csr%ROWTYPE;
11936: l_line_BS_rec l_line_BS_csr%ROWTYPE;
11937: l_sll_in_tbl StrmLvl_Out_tbl;
11938: l_cp_sll_out_tbl StrmLvl_Out_tbl;
11939: l_sll_db_tbl oks_bill_sch.StreamLvl_tbl;
11940: l_top_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;
11941: l_new_sll_tbl oks_bill_sch.StreamLvl_tbl;
11942: l_cp_new_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;
11943: l_cp_old_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;

Line 11941: l_new_sll_tbl oks_bill_sch.StreamLvl_tbl;

11937: l_sll_in_tbl StrmLvl_Out_tbl;
11938: l_cp_sll_out_tbl StrmLvl_Out_tbl;
11939: l_sll_db_tbl oks_bill_sch.StreamLvl_tbl;
11940: l_top_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;
11941: l_new_sll_tbl oks_bill_sch.StreamLvl_tbl;
11942: l_cp_new_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;
11943: l_cp_old_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;
11944:
11945:

Line 12676: p_new_sll_tbl IN OUT NOCOPY oks_bill_sch.StreamLvl_tbl,

12672: Procedure Prorate_sll_amt(
12673: p_old_cp_amt IN NUMBER,
12674: p_new_cp_amt IN NUMBER,
12675: p_total_amt IN NUMBER,
12676: p_new_sll_tbl IN OUT NOCOPY oks_bill_sch.StreamLvl_tbl,
12677: p_old_sll_tbl IN OUT NOCOPY oks_bill_sch.StreamLvl_tbl,
12678: x_return_status OUT NOCOPY VARCHAR2)
12679:
12680: IS

Line 12677: p_old_sll_tbl IN OUT NOCOPY oks_bill_sch.StreamLvl_tbl,

12673: p_old_cp_amt IN NUMBER,
12674: p_new_cp_amt IN NUMBER,
12675: p_total_amt IN NUMBER,
12676: p_new_sll_tbl IN OUT NOCOPY oks_bill_sch.StreamLvl_tbl,
12677: p_old_sll_tbl IN OUT NOCOPY oks_bill_sch.StreamLvl_tbl,
12678: x_return_status OUT NOCOPY VARCHAR2)
12679:
12680: IS
12681: l_tot_amt NUMBER;

Line 12954: OKS_BILL_SCH.Cascade_Dates_SLL

12950: -- amount matches with that of the price_negotiated amount of the service line
12951:
12952: IF (nvl(l_dummy, 2) <> 1 ) THEN
12953:
12954: OKS_BILL_SCH.Cascade_Dates_SLL
12955: (
12956: p_top_line_id => p_cle_id,
12957: x_return_status => x_return_status,
12958: x_msg_count => l_msg_count,

Line 13311: l_constant_sll_amt := OKS_BILL_SCH.Get_Unit_Price_Per_Uom

13307: IF l_period_start is not null AND l_period_type is not null THEN
13308:
13309: /* Commented for bug 16293821
13310:
13311: l_constant_sll_amt := OKS_BILL_SCH.Get_Unit_Price_Per_Uom
13312: (Null,
13313: l_timeunit,
13314: p_period_start,
13315: p_period_type,

Line 13334: l_unit_price := OKS_BILL_SCH.Get_Converted_price(

13330: );
13331: l_source_unit_price := p_total_amount /l_dur;
13332:
13333: IF l_uom <> l_timeunit THEN
13334: l_unit_price := OKS_BILL_SCH.Get_Converted_price(
13335: p_price_uom => l_timeunit,
13336: p_pl_uom =>l_uom,
13337: p_period_start =>l_period_start,
13338: p_period_type =>l_period_type,

Line 13357: 'after calling OKS_BILL_SCH.Get_Unit_Price_Per_Uom '

13353: /*Added for bug 16293821 */
13354:
13355: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
13356: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Billed_Amount',
13357: 'after calling OKS_BILL_SCH.Get_Unit_Price_Per_Uom '
13358: ||' result l_constant_sll_amt = ' || l_constant_sll_amt);
13359: END IF;
13360: IF l_constant_sll_amt IS NULL THEN
13361: l_return_status := G_RET_STS_ERROR;

Line 13544: END OKS_BILL_SCH;

13540:
13541:
13542:
13543:
13544: END OKS_BILL_SCH;