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_LEVEL_ELEMENTS_PVT

Line 7: l_lvl_ele_tbl_in oks_bill_level_elements_pvt.letv_tbl_type;

3:
4:
5: l_strm_lvl_tbl_in oks_sll_pvt.sllv_tbl_type;
6: l_strm_lvl_tbl_out oks_sll_pvt.sllv_tbl_type;
7: l_lvl_ele_tbl_in oks_bill_level_elements_pvt.letv_tbl_type;
8: l_lvl_ele_tbl_out oks_bill_level_elements_pvt.letv_tbl_type;
9: l_fnd_lvl_in_rec oks_bill_util_pub.bill_det_inp_rec;
10: l_fnd_lvl_out_rec oks_bill_util_pub.bill_sch_rec;
11: l_api_version number := 1.0;

Line 8: l_lvl_ele_tbl_out oks_bill_level_elements_pvt.letv_tbl_type;

4:
5: l_strm_lvl_tbl_in oks_sll_pvt.sllv_tbl_type;
6: l_strm_lvl_tbl_out oks_sll_pvt.sllv_tbl_type;
7: l_lvl_ele_tbl_in oks_bill_level_elements_pvt.letv_tbl_type;
8: l_lvl_ele_tbl_out oks_bill_level_elements_pvt.letv_tbl_type;
9: l_fnd_lvl_in_rec oks_bill_util_pub.bill_det_inp_rec;
10: l_fnd_lvl_out_rec oks_bill_util_pub.bill_sch_rec;
11: l_api_version number := 1.0;
12:

Line 147: x_top_line_bs IN OUT NOCOPY oks_bill_level_elements_pvt.letv_tbl_type,

143: x_next_cycle_dt OUT NOCOPY DATE,
144: x_last_cycle_dt out NOCOPY Date,
145: x_period_counter out NOCOPY Number,
146: x_sch_amt IN OUT NOCOPY NUMBER,
147: x_top_line_bs IN OUT NOCOPY oks_bill_level_elements_pvt.letv_tbl_type,
148: x_return_status out NOCOPY Varchar2
149: );
150:
151:

Line 203: p_top_line_bs IN OUT NOCOPY oks_bill_level_elements_pvt.letv_tbl_type,

199: p_cp_sll_tbl IN StrmLvl_Out_tbl,
200: p_Line_Rec IN Line_Det_Type,
201: p_SubLine_rec IN Prod_Det_Type,
202: p_invoice_rulid IN Number,
203: p_top_line_bs IN OUT NOCOPY oks_bill_level_elements_pvt.letv_tbl_type,
204: p_term_dt IN DATE,
205: p_period_start IN VARCHAR2,
206: p_period_type IN VARCHAR2,
207: x_return_status OUT NOCOPY Varchar2

Line 222: p_top_line_bs IN OUT NOCOPY oks_bill_level_elements_pvt.letv_tbl_type,

218: p_bsll_tbl IN StreamLvl_tbl,
219: p_Line_Rec IN Line_Det_Type,
220: p_SubLine_rec IN Prod_Det_Type,
221: p_invoice_rulid IN Number,
222: p_top_line_bs IN OUT NOCOPY oks_bill_level_elements_pvt.letv_tbl_type,
223: p_term_dt IN DATE,
224: p_period_start IN VARCHAR2,
225: p_period_type IN VARCHAR2,
226: x_return_status OUT NOCOPY Varchar2

Line 287: p_top_line_bs IN OUT NOCOPY oks_bill_level_elements_pvt.letv_tbl_type,

283:
284: PROCEDURE Adjust_top_BS_Amt(
285: p_Line_Rec IN Line_Det_Type,
286: p_SubLine_rec IN Prod_Det_Type,
287: p_top_line_bs IN OUT NOCOPY oks_bill_level_elements_pvt.letv_tbl_type,
288: x_return_status OUT NOCOPY VARCHAR2);
289:
290: PROCEDURE Del_sll_lvlelement(p_top_line_id IN NUMBER,
291: x_return_status OUT NOCOPY VARCHAR2,

Line 300: x_bs_tbl OUT NOCOPY oks_bill_level_elements_pvt.letv_tbl_type,

296: Procedure Adjust_interface_date(p_line_id IN NUMBER,
297: p_invoice_rule_id IN Number,
298: p_line_end_date IN DATE,
299: p_lse_id IN NUMBER,
300: x_bs_tbl OUT NOCOPY oks_bill_level_elements_pvt.letv_tbl_type,
301: x_return_status OUT NOCOPY VARCHAR2,
302: x_msg_count OUT NOCOPY NUMBER,
303: x_msg_data OUT NOCOPY VARCHAR2);
304:

Line 352: p_top_line_bs IN OUT NOCOPY oks_bill_level_elements_pvt.letv_tbl_type,

348:
349: PROCEDURE Rollup_lvl_amt(
350: p_Line_Rec IN Line_Det_Type,
351: p_SubLine_rec IN Prod_Det_Type,
352: p_top_line_bs IN OUT NOCOPY oks_bill_level_elements_pvt.letv_tbl_type,
353: x_return_status OUT NOCOPY VARCHAR2);
354:
355: PROCEDURE Adjust_cp_trx_inv_dt(
356: p_top_bs_tbl IN oks_bill_level_elements_pvt.letv_tbl_type,

Line 356: p_top_bs_tbl IN oks_bill_level_elements_pvt.letv_tbl_type,

352: p_top_line_bs IN OUT NOCOPY oks_bill_level_elements_pvt.letv_tbl_type,
353: x_return_status OUT NOCOPY VARCHAR2);
354:
355: PROCEDURE Adjust_cp_trx_inv_dt(
356: p_top_bs_tbl IN oks_bill_level_elements_pvt.letv_tbl_type,
357: p_SubLine_id IN NUMBER,
358: x_cp_line_bs OUT NOCOPY oks_bill_level_elements_pvt.letv_tbl_type,
359: x_return_status OUT NOCOPY VARCHAR2);
360:

Line 358: x_cp_line_bs OUT NOCOPY oks_bill_level_elements_pvt.letv_tbl_type,

354:
355: PROCEDURE Adjust_cp_trx_inv_dt(
356: p_top_bs_tbl IN oks_bill_level_elements_pvt.letv_tbl_type,
357: p_SubLine_id IN NUMBER,
358: x_cp_line_bs OUT NOCOPY oks_bill_level_elements_pvt.letv_tbl_type,
359: x_return_status OUT NOCOPY VARCHAR2);
360:
361: PROCEDURE Adjust_billed_lvl_element(p_new_cp_id IN NUMBER,
362: P_old_cp_bs_tbl IN OUT NOCOPY oks_bill_level_elements_pvt.letv_tbl_type,

Line 362: P_old_cp_bs_tbl IN OUT NOCOPY oks_bill_level_elements_pvt.letv_tbl_type,

358: x_cp_line_bs OUT NOCOPY oks_bill_level_elements_pvt.letv_tbl_type,
359: x_return_status OUT NOCOPY VARCHAR2);
360:
361: PROCEDURE Adjust_billed_lvl_element(p_new_cp_id IN NUMBER,
362: P_old_cp_bs_tbl IN OUT NOCOPY oks_bill_level_elements_pvt.letv_tbl_type,
363: x_new_cp_bs_tbl OUT NOCOPY oks_bill_level_elements_pvt.letv_tbl_type,
364: x_return_status OUT NOCOPY VARCHAR2);
365:
366: Procedure Prorate_sll_amt(

Line 363: x_new_cp_bs_tbl OUT NOCOPY oks_bill_level_elements_pvt.letv_tbl_type,

359: x_return_status OUT NOCOPY VARCHAR2);
360:
361: PROCEDURE Adjust_billed_lvl_element(p_new_cp_id IN NUMBER,
362: P_old_cp_bs_tbl IN OUT NOCOPY oks_bill_level_elements_pvt.letv_tbl_type,
363: x_new_cp_bs_tbl OUT NOCOPY oks_bill_level_elements_pvt.letv_tbl_type,
364: x_return_status OUT NOCOPY VARCHAR2);
365:
366: Procedure Prorate_sll_amt(
367: p_old_cp_amt IN NUMBER,

Line 1235: l_top_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;

1231:
1232: l_Line_Csr_Rec l_Line_Csr%Rowtype;
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:

Line 1851: OKS_BILL_LEVEL_ELEMENTS_PVT.update_row(

1847:
1848:
1849:
1850: IF l_top_bs_tbl.COUNT >0 THEN ---only for type 'T' and 'E' l_top_bs_tbl will be having records
1851: OKS_BILL_LEVEL_ELEMENTS_PVT.update_row(
1852: p_api_version => l_api_version,
1853: p_init_msg_list => l_init_msg_list,
1854: x_return_status => x_return_status,
1855: x_msg_count => l_msg_count,

Line 1862: 'OKS_BILL_LEVEL_ELEMENTS_PVT.update_row(x_return_status = '||x_return_status

1858: x_letv_tbl => l_lvl_ele_tbl_out);
1859:
1860: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
1861: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_bill_sch_rules.update_top_bs',
1862: 'OKS_BILL_LEVEL_ELEMENTS_PVT.update_row(x_return_status = '||x_return_status
1863: ||', tbl count = '||l_lvl_ele_tbl_out.count ||')');
1864: END IF;
1865:
1866: IF x_return_status <> 'S' THEN

Line 2419: p_top_line_bs IN OUT NOCOPY oks_bill_level_elements_pvt.letv_tbl_type,

2415: p_bsll_tbl IN StreamLvl_tbl,
2416: p_Line_Rec IN Line_Det_Type,
2417: p_SubLine_rec IN Prod_Det_Type,
2418: p_invoice_rulid IN Number,
2419: p_top_line_bs IN OUT NOCOPY oks_bill_level_elements_pvt.letv_tbl_type,
2420: p_term_dt IN DATE,
2421: p_period_start IN VARCHAR2,
2422: p_period_type IN VARCHAR2,
2423: x_return_status OUT NOCOPY Varchar2

Line 2677: x_top_line_bs IN OUT NOCOPY oks_bill_level_elements_pvt.letv_tbl_type,

2673: x_next_cycle_dt OUT NOCOPY DATE,
2674: x_last_cycle_dt out NOCOPY Date,
2675: x_period_counter out NOCOPY Number,
2676: x_sch_amt IN OUT NOCOPY NUMBER,
2677: x_top_line_bs IN OUT NOCOPY oks_bill_level_elements_pvt.letv_tbl_type,
2678: x_return_status out NOCOPY Varchar2
2679: )
2680:
2681: IS

Line 2739: l_cp_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;

2735: l_next_cycle_dt DATE;
2736: l_element_end_dt DATE;
2737: l_date_start DATE;
2738: l_end_dt DATE;
2739: l_cp_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;
2740: l_index number;
2741: l_top_line_id number;
2742: l_sub_line_id number;
2743: l_line_ctr number;

Line 3079: l_dummy_top_line_bs oks_bill_level_elements_pvt.letv_tbl_type;

3075: l_uom_quantity NUMBER;
3076: l_tce_code VARCHAR2(100);
3077: l_constant_sll_amt NUMBER;
3078: l_remaining_amt NUMBER;
3079: l_dummy_top_line_bs oks_bill_level_elements_pvt.letv_tbl_type;
3080: l_billed_at_source OKC_K_HEADERS_ALL_B.BILLED_AT_SOURCE%TYPE;
3081: ------------------------------------------------------------------------
3082: -- Begin partial period computation logic
3083: -- Developer Mani Choudhary

Line 3644: OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row(

3640: IF l_lvl_ele_tbl_in(l_lvl_ele_tbl_in.LAST).date_end > p_line_rec.line_end_dt THEN
3641: l_lvl_ele_tbl_in(l_lvl_ele_tbl_in.LAST).date_end := p_line_rec.line_end_dt;
3642: END IF;
3643:
3644: OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row(
3645: p_api_version => l_api_version,
3646: p_init_msg_list => l_init_msg_list,
3647: x_return_status => x_return_status,
3648: x_msg_count => l_msg_count,

Line 3655: 'oks_bill_level_elements_pvt.insert_row(x_return_status = '||x_return_status

3651: x_letv_tbl => l_lvl_ele_tbl_out);
3652:
3653: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
3654: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.Create_Level_elements.insert',
3655: 'oks_bill_level_elements_pvt.insert_row(x_return_status = '||x_return_status
3656: ||', l_lvl_ele_tbl_out = '|| l_lvl_ele_tbl_out.count ||')');
3657: END IF;
3658:
3659: -----errorout_ad('LEVEL ELEMENT INSERT STATUS line = ' || x_return_status);

Line 3663: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row for line = ' || l_msg_data);

3659: -----errorout_ad('LEVEL ELEMENT INSERT STATUS line = ' || x_return_status);
3660:
3661:
3662: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3663: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row for line = ' || l_msg_data);
3664: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3665: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3666: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row for line = ' || l_msg_data);
3667: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 3666: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row for line = ' || l_msg_data);

3662: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3663: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row for line = ' || l_msg_data);
3664: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3665: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3666: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row for line = ' || l_msg_data);
3667: RAISE OKC_API.G_EXCEPTION_ERROR;
3668: END IF;
3669: END IF;
3670:

Line 3894: OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row(

3890: END LOOP; -----loop for sll lines
3891:
3892: IF l_lvl_ele_tbl_in.COUNT > 0 THEN
3893:
3894: OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row(
3895: p_api_version => l_api_version,
3896: p_init_msg_list => l_init_msg_list,
3897: x_return_status => x_return_status,
3898: x_msg_count => l_msg_count,

Line 3905: 'oks_bill_level_elements_pvt.insert_row(x_return_status = '||x_return_status

3901: x_letv_tbl => l_lvl_ele_tbl_out);
3902:
3903: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
3904: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_hdr_level_elements.insert',
3905: 'oks_bill_level_elements_pvt.insert_row(x_return_status = '||x_return_status
3906: ||', l_lvl_ele_tbl_out = '|| l_lvl_ele_tbl_out.count ||')');
3907: END IF;
3908:
3909:

Line 3914: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row = ' || l__msg_data);

3910: -----errorout_ad('LEVEL ELEMENT INSERT STATUS = ' || x_return_status);
3911:
3912:
3913: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3914: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row = ' || l__msg_data);
3915: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3916: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3917: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row = ' || l_msg_data);
3918: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 3917: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row = ' || l_msg_data);

3913: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3914: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row = ' || l__msg_data);
3915: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3916: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3917: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row = ' || l_msg_data);
3918: RAISE OKC_API.G_EXCEPTION_ERROR;
3919: END IF;
3920: END IF;
3921:

Line 5113: l_top_bs_tbl oks_bill_level_elements_pvt.letv_tbl_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;
5117: l_amount NUMBER;

Line 5487: OKS_BILL_LEVEL_ELEMENTS_PVT.update_row(

5483:
5484:
5485:
5486: IF x_return_status = 'S' then
5487: OKS_BILL_LEVEL_ELEMENTS_PVT.update_row(
5488: p_api_version => l_api_version,
5489: p_init_msg_list => l_init_msg_list,
5490: x_return_status => x_return_status,
5491: x_msg_count => x_msg_count,

Line 5498: 'oks_bill_level_elements_pvt.update_row(x_return_status = '||x_return_status ||')');

5494: x_letv_tbl => l_lvl_ele_tbl_out);
5495:
5496: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
5497: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_bill_sch_cp.update_top_bs',
5498: 'oks_bill_level_elements_pvt.update_row(x_return_status = '||x_return_status ||')');
5499: END IF;
5500: else
5501:
5502: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 6810: p_top_line_bs IN OUT NOCOPY oks_bill_level_elements_pvt.letv_tbl_type,

6806:
6807: PROCEDURE Adjust_top_BS_Amt(
6808: p_Line_Rec IN Line_Det_Type,
6809: p_SubLine_rec IN Prod_Det_Type,
6810: p_top_line_bs IN OUT NOCOPY oks_bill_level_elements_pvt.letv_tbl_type,
6811: x_return_status OUT NOCOPY VARCHAR2)
6812: IS
6813:
6814: CURSOR l_cp_BS_csr(p_cp_id NUMBER) IS

Line 6822: l_cp_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;

6818: WHERE cle_id = p_cp_id
6819: ORDER by date_start;
6820:
6821: l_cp_BS_rec l_cp_BS_csr%ROWTYPE;
6822: l_cp_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;
6823: l_index number;
6824: l_top_bs_ind number;
6825: l_cp_bs_ind number;
6826:

Line 7237: l_top_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;

7233: l_bill_type_rec l_bill_type_csr%ROWTYPE;
7234:
7235:
7236:
7237: l_top_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;
7238: l_cp_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;
7239: x_letv_tbl oks_bill_level_elements_pvt.letv_tbl_type;
7240:
7241:

Line 7238: l_cp_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;

7234:
7235:
7236:
7237: l_top_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;
7238: l_cp_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;
7239: x_letv_tbl oks_bill_level_elements_pvt.letv_tbl_type;
7240:
7241:
7242: i NUMBER := 0;

Line 7239: x_letv_tbl oks_bill_level_elements_pvt.letv_tbl_type;

7235:
7236:
7237: l_top_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;
7238: l_cp_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;
7239: x_letv_tbl oks_bill_level_elements_pvt.letv_tbl_type;
7240:
7241:
7242: i NUMBER := 0;
7243: l_index NUMBER := 0;

Line 7339: OKS_BILL_LEVEL_ELEMENTS_PVT.update_row(

7335: l_top_bs_tbl(l_top_bs_ind).amount := nvl(l_top_bs_tbl(l_top_bs_ind).amount,0) - nvl(l_cp_bs_tbl(l_cp_bs_ind).amount,0);
7336: l_top_bs_ind := l_top_bs_ind + 1;
7337: END LOOP;
7338:
7339: OKS_BILL_LEVEL_ELEMENTS_PVT.update_row(
7340: p_api_version => l_api_version,
7341: p_init_msg_list => l_init_msg_list,
7342: x_return_status => x_return_status,
7343: x_msg_count => l_msg_count,

Line 7422: l_update_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;

7418:
7419:
7420: l_subLine_rec l_subLine_Csr%ROWTYPE;
7421: l_index NUMBER := 0;
7422: l_update_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;
7423: l_lvl_index NUMBER := 0;
7424: l_line_rec l_line_csr%ROWTYPE;
7425:
7426: l_cp_line_bs oks_bill_level_elements_pvt.letv_tbl_type;

Line 7426: l_cp_line_bs oks_bill_level_elements_pvt.letv_tbl_type;

7422: l_update_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;
7423: l_lvl_index NUMBER := 0;
7424: l_line_rec l_line_csr%ROWTYPE;
7425:
7426: l_cp_line_bs oks_bill_level_elements_pvt.letv_tbl_type;
7427: l_line_tbl_in oks_bill_level_elements_pvt.letv_tbl_type;
7428: l_top_index NUMBER := 0;
7429:
7430:

Line 7427: l_line_tbl_in oks_bill_level_elements_pvt.letv_tbl_type;

7423: l_lvl_index NUMBER := 0;
7424: l_line_rec l_line_csr%ROWTYPE;
7425:
7426: l_cp_line_bs oks_bill_level_elements_pvt.letv_tbl_type;
7427: l_line_tbl_in oks_bill_level_elements_pvt.letv_tbl_type;
7428: l_top_index NUMBER := 0;
7429:
7430:
7431: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;

Line 7604: OKS_BILL_LEVEL_ELEMENTS_PVT.update_row(

7600:
7601: -----errorout_ad('l_lvl_ele_tbl_in.COUNT = ' || l_lvl_ele_tbl_in.COUNT );
7602:
7603: IF l_lvl_ele_tbl_in.COUNT > 0 THEN
7604: OKS_BILL_LEVEL_ELEMENTS_PVT.update_row(
7605: p_api_version => l_api_version,
7606: p_init_msg_list => l_init_msg_list,
7607: x_return_status => x_return_status,
7608: x_msg_count => x_msg_count,

Line 7641: x_bs_tbl OUT NOCOPY oks_bill_level_elements_pvt.letv_tbl_type,

7637: Procedure Adjust_interface_date(p_line_id IN NUMBER,
7638: p_invoice_rule_id IN Number,
7639: p_line_end_date IN DATE,
7640: p_lse_id IN NUMBER,
7641: x_bs_tbl OUT NOCOPY oks_bill_level_elements_pvt.letv_tbl_type,
7642: x_return_status OUT NOCOPY VARCHAR2,
7643: x_msg_count OUT NOCOPY NUMBER,
7644: x_msg_data OUT NOCOPY VARCHAR2)
7645: IS

Line 7673: l_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;

7669:
7670:
7671: l_index NUMBER := 0;
7672: l_bs_index NUMBER := 0;
7673: l_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;
7674: l_sll_end_date DATE;
7675: l_interface_offset NUMBER;
7676: l_date_to_interface DATE;
7677: l_out_index NUMBER := 0;

Line 7959: l_dummy_top_line_bs oks_bill_level_elements_pvt.letv_tbl_type;

7955: l_tce_code VARCHAR2(100);
7956: L_CONSTANT_SLL_AMT NUMBER;
7957: l_remaining_amt NUMBER;
7958: L_SLL_AMT NUMBER;
7959: l_dummy_top_line_bs oks_bill_level_elements_pvt.letv_tbl_type;
7960: l_bill_type VARCHAR2(10);
7961:
7962: --
7963: l_api_version CONSTANT NUMBER := 1.0;

Line 8332: OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row(

8328: l_adjusted_amt := (l_lvl_ele_tbl_in(l_lvl_ele_tbl_in.LAST).amount) + (l_line_amt - l_bill_sch_amt);
8329: l_lvl_ele_tbl_in(l_lvl_ele_tbl_in.LAST).amount := l_adjusted_amt;
8330: END IF;
8331:
8332: OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row(
8333: p_api_version => l_api_version,
8334: p_init_msg_list => l_init_msg_list,
8335: x_return_status => x_return_status,
8336: x_msg_count => l_msg_count,

Line 8345: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row for sub line = ' || l_msg_data);

8341: -----errorout_ad('LEVEL ELEMENT INSERT STATUS FOR SUBLINE = ' || x_return_status);
8342:
8343:
8344: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
8345: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row for sub line = ' || l_msg_data);
8346: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
8347: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
8348: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row for sub line = ' || l_msg_data);
8349: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 8348: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row for sub line = ' || l_msg_data);

8344: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
8345: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row for sub line = ' || l_msg_data);
8346: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
8347: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
8348: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row for sub line = ' || l_msg_data);
8349: RAISE OKC_API.G_EXCEPTION_ERROR;
8350: END IF;
8351: END IF;
8352:

Line 8814: l_top_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;

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:
8818: -------------------------------------------------------------------------

Line 9179: OKS_BILL_LEVEL_ELEMENTS_PVT.update_row(

9175: END IF; ---END OF SUBLINE LOOP
9176:
9177:
9178: IF l_top_bs_tbl.COUNT >0 THEN ---only for type 'T' l_top_bs_tbl will be having records
9179: OKS_BILL_LEVEL_ELEMENTS_PVT.update_row(
9180: p_api_version => l_api_version,
9181: p_init_msg_list => l_init_msg_list,
9182: x_return_status => x_return_status,
9183: x_msg_count => x_msg_count,

Line 9190: 'oks_bill_level_elements_pvt.update_row(x_return_status = '||x_return_status

9186: x_letv_tbl => l_lvl_ele_tbl_out);
9187:
9188: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
9189: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.terminate_bill_sch.update_bs',
9190: 'oks_bill_level_elements_pvt.update_row(x_return_status = '||x_return_status
9191: ||', top bs count = '||l_lvl_ele_tbl_out.count ||')');
9192: END IF;
9193:
9194: IF x_return_status <> 'S' THEN

Line 9326: OKS_BILL_LEVEL_ELEMENTS_PVT.update_row(

9322: RAISE G_EXCEPTION_HALT_VALIDATION;
9323: END IF;
9324:
9325: IF l_subline_rec.billing_schedule_type IN ('E','T') AND l_top_bs_tbl.COUNT > 0 then
9326: OKS_BILL_LEVEL_ELEMENTS_PVT.update_row(
9327: p_api_version => l_api_version,
9328: p_init_msg_list => l_init_msg_list,
9329: x_return_status => x_return_status,
9330: x_msg_count => x_msg_count,

Line 9337: 'oks_bill_level_elements_pvt.update_row(x_return_status = '||x_return_status

9333: x_letv_tbl => l_lvl_ele_tbl_out);
9334:
9335: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
9336: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.terminate_bill_sch.update_bs',
9337: 'oks_bill_level_elements_pvt.update_row(x_return_status = '||x_return_status
9338: ||', top bs count = '||l_lvl_ele_tbl_out.count ||')');
9339: END IF;
9340:
9341: IF x_return_status <> 'S' THEN

Line 9381: p_top_line_bs IN OUT NOCOPY oks_bill_level_elements_pvt.letv_tbl_type,

9377: p_cp_sll_tbl IN StrmLvl_Out_tbl,
9378: p_Line_Rec IN Line_Det_Type,
9379: p_SubLine_rec IN Prod_Det_Type,
9380: p_invoice_rulid IN Number,
9381: p_top_line_bs IN OUT NOCOPY oks_bill_level_elements_pvt.letv_tbl_type,
9382: p_term_dt IN DATE,
9383: p_period_start IN VARCHAR2,
9384: p_period_type IN VARCHAR2,
9385: x_return_status OUT NOCOPY Varchar2

Line 10257: OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row(

10253: IF l_lvl_ele_tbl_in(l_lvl_ele_tbl_in.LAST).date_end > p_subline_rec.cp_end_dt THEN
10254: l_lvl_ele_tbl_in(l_lvl_ele_tbl_in.LAST).date_end := p_subline_rec.cp_end_dt;
10255: END IF;
10256:
10257: OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row(
10258: p_api_version => l_api_version,
10259: p_init_msg_list => l_init_msg_list,
10260: x_return_status => x_return_status,
10261: x_msg_count => l_msg_count,

Line 10933: p_top_line_bs IN OUT NOCOPY oks_bill_level_elements_pvt.letv_tbl_type,

10929:
10930: PROCEDURE Rollup_lvl_amt(
10931: p_Line_Rec IN Line_Det_Type,
10932: p_SubLine_rec IN Prod_Det_Type,
10933: p_top_line_bs IN OUT NOCOPY oks_bill_level_elements_pvt.letv_tbl_type,
10934: x_return_status OUT NOCOPY VARCHAR2)
10935: IS
10936:
10937: CURSOR l_cp_BS_csr(p_cp_id NUMBER) IS

Line 10945: l_cp_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;

10941: WHERE cle_id = p_cp_id
10942: ORDER by date_start;
10943:
10944: l_cp_BS_rec l_cp_BS_csr%ROWTYPE;
10945: l_cp_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;
10946: l_index number;
10947: l_top_bs_ind number;
10948: l_cp_bs_ind number;
10949:

Line 11057: p_top_bs_tbl IN oks_bill_level_elements_pvt.letv_tbl_type,

11053: END Create_Bill_Sch_Rules;
11054:
11055:
11056: PROCEDURE Adjust_cp_trx_inv_dt(
11057: p_top_bs_tbl IN oks_bill_level_elements_pvt.letv_tbl_type,
11058: p_SubLine_id IN NUMBER,
11059: x_cp_line_bs OUT NOCOPY oks_bill_level_elements_pvt.letv_tbl_type,
11060: x_return_status OUT NOCOPY VARCHAR2)
11061: IS

Line 11059: x_cp_line_bs OUT NOCOPY oks_bill_level_elements_pvt.letv_tbl_type,

11055:
11056: PROCEDURE Adjust_cp_trx_inv_dt(
11057: p_top_bs_tbl IN oks_bill_level_elements_pvt.letv_tbl_type,
11058: p_SubLine_id IN NUMBER,
11059: x_cp_line_bs OUT NOCOPY oks_bill_level_elements_pvt.letv_tbl_type,
11060: x_return_status OUT NOCOPY VARCHAR2)
11061: IS
11062:
11063: CURSOR l_cp_BS_csr IS

Line 11072: l_cp_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;

11068: AND date_completed IS NULL
11069: ORDER BY date_start;
11070:
11071: l_cp_BS_rec l_cp_BS_csr%ROWTYPE;
11072: l_cp_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;
11073: l_index number;
11074: l_top_bs_ind number;
11075: l_cp_bs_ind number;
11076:

Line 11697: l_top_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;

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;
11701:

Line 11699: l_cp_new_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;

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:
11703: l_top_line_rec Line_Det_Type;

Line 11700: l_cp_old_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;

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:
11703: l_top_line_rec Line_Det_Type;
11704: l_cp_rec Prod_Det_Type;

Line 12481: p_old_cp_bs_tbl IN OUT NOCOPY oks_bill_level_elements_pvt.letv_tbl_type,

12477: END Prorate_sll_amt;
12478:
12479:
12480: PROCEDURE Adjust_billed_lvl_element(p_new_cp_id IN NUMBER,
12481: p_old_cp_bs_tbl IN OUT NOCOPY oks_bill_level_elements_pvt.letv_tbl_type,
12482: x_new_cp_bs_tbl OUT NOCOPY oks_bill_level_elements_pvt.letv_tbl_type,
12483: x_return_status OUT NOCOPY VARCHAR2)
12484: IS
12485:

Line 12482: x_new_cp_bs_tbl OUT NOCOPY oks_bill_level_elements_pvt.letv_tbl_type,

12478:
12479:
12480: PROCEDURE Adjust_billed_lvl_element(p_new_cp_id IN NUMBER,
12481: p_old_cp_bs_tbl IN OUT NOCOPY oks_bill_level_elements_pvt.letv_tbl_type,
12482: x_new_cp_bs_tbl OUT NOCOPY oks_bill_level_elements_pvt.letv_tbl_type,
12483: x_return_status OUT NOCOPY VARCHAR2)
12484: IS
12485:
12486:

Line 12641: l_top_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;

12637: l_cp_BS_rec l_cp_BS_csr%ROWTYPE;
12638: l_bill_type_rec l_bill_type_csr%ROWTYPE;
12639:
12640:
12641: l_top_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;
12642: l_cp_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;
12643: x_letv_tbl oks_bill_level_elements_pvt.letv_tbl_type;
12644:
12645:

Line 12642: l_cp_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;

12638: l_bill_type_rec l_bill_type_csr%ROWTYPE;
12639:
12640:
12641: l_top_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;
12642: l_cp_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;
12643: x_letv_tbl oks_bill_level_elements_pvt.letv_tbl_type;
12644:
12645:
12646: i NUMBER := 0;

Line 12643: x_letv_tbl oks_bill_level_elements_pvt.letv_tbl_type;

12639:
12640:
12641: l_top_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;
12642: l_cp_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;
12643: x_letv_tbl oks_bill_level_elements_pvt.letv_tbl_type;
12644:
12645:
12646: i NUMBER := 0;
12647: l_index NUMBER := 0;

Line 12793: OKS_BILL_LEVEL_ELEMENTS_PVT.update_row(

12789: End if;
12790: l_top_bs_ind := l_top_bs_ind + 1;
12791: END LOOP;
12792:
12793: OKS_BILL_LEVEL_ELEMENTS_PVT.update_row(
12794: p_api_version => l_api_version,
12795: p_init_msg_list => l_init_msg_list,
12796: x_return_status => x_return_status,
12797: x_msg_count => l_msg_count,