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 2436: p_top_line_bs IN OUT NOCOPY oks_bill_level_elements_pvt.letv_tbl_type,

2432: p_bsll_tbl IN StreamLvl_tbl,
2433: p_Line_Rec IN Line_Det_Type,
2434: p_SubLine_rec IN Prod_Det_Type,
2435: p_invoice_rulid IN Number,
2436: p_top_line_bs IN OUT NOCOPY oks_bill_level_elements_pvt.letv_tbl_type,
2437: p_term_dt IN DATE,
2438: p_period_start IN VARCHAR2,
2439: p_period_type IN VARCHAR2,
2440: x_return_status OUT NOCOPY Varchar2

Line 2694: x_top_line_bs IN OUT NOCOPY oks_bill_level_elements_pvt.letv_tbl_type,

2690: x_next_cycle_dt OUT NOCOPY DATE,
2691: x_last_cycle_dt out NOCOPY Date,
2692: x_period_counter out NOCOPY Number,
2693: x_sch_amt IN OUT NOCOPY NUMBER,
2694: x_top_line_bs IN OUT NOCOPY oks_bill_level_elements_pvt.letv_tbl_type,
2695: x_return_status out NOCOPY Varchar2
2696: )
2697:
2698: IS

Line 2756: l_cp_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;

2752: l_next_cycle_dt DATE;
2753: l_element_end_dt DATE;
2754: l_date_start DATE;
2755: l_end_dt DATE;
2756: l_cp_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;
2757: l_index number;
2758: l_top_line_id number;
2759: l_sub_line_id number;
2760: l_line_ctr number;

Line 3096: l_dummy_top_line_bs oks_bill_level_elements_pvt.letv_tbl_type;

3092: l_uom_quantity NUMBER;
3093: l_tce_code VARCHAR2(100);
3094: l_constant_sll_amt NUMBER;
3095: l_remaining_amt NUMBER;
3096: l_dummy_top_line_bs oks_bill_level_elements_pvt.letv_tbl_type;
3097: l_billed_at_source OKC_K_HEADERS_ALL_B.BILLED_AT_SOURCE%TYPE;
3098: ------------------------------------------------------------------------
3099: -- Begin partial period computation logic
3100: -- Developer Mani Choudhary

Line 3661: OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row(

3657: IF l_lvl_ele_tbl_in(l_lvl_ele_tbl_in.LAST).date_end > p_line_rec.line_end_dt THEN
3658: l_lvl_ele_tbl_in(l_lvl_ele_tbl_in.LAST).date_end := p_line_rec.line_end_dt;
3659: END IF;
3660:
3661: OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row(
3662: p_api_version => l_api_version,
3663: p_init_msg_list => l_init_msg_list,
3664: x_return_status => x_return_status,
3665: x_msg_count => l_msg_count,

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

3668: x_letv_tbl => l_lvl_ele_tbl_out);
3669:
3670: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
3671: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.Create_Level_elements.insert',
3672: 'oks_bill_level_elements_pvt.insert_row(x_return_status = '||x_return_status
3673: ||', l_lvl_ele_tbl_out = '|| l_lvl_ele_tbl_out.count ||')');
3674: END IF;
3675:
3676: -----errorout_ad('LEVEL ELEMENT INSERT STATUS line = ' || x_return_status);

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

3676: -----errorout_ad('LEVEL ELEMENT INSERT STATUS line = ' || x_return_status);
3677:
3678:
3679: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3680: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row for line = ' || l_msg_data);
3681: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3682: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3683: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row for line = ' || l_msg_data);
3684: RAISE OKC_API.G_EXCEPTION_ERROR;

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

3679: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3680: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row for line = ' || l_msg_data);
3681: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3682: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3683: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row for line = ' || l_msg_data);
3684: RAISE OKC_API.G_EXCEPTION_ERROR;
3685: END IF;
3686: END IF;
3687:

Line 3911: OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row(

3907: END LOOP; -----loop for sll lines
3908:
3909: IF l_lvl_ele_tbl_in.COUNT > 0 THEN
3910:
3911: OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row(
3912: p_api_version => l_api_version,
3913: p_init_msg_list => l_init_msg_list,
3914: x_return_status => x_return_status,
3915: x_msg_count => l_msg_count,

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

3918: x_letv_tbl => l_lvl_ele_tbl_out);
3919:
3920: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
3921: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_hdr_level_elements.insert',
3922: 'oks_bill_level_elements_pvt.insert_row(x_return_status = '||x_return_status
3923: ||', l_lvl_ele_tbl_out = '|| l_lvl_ele_tbl_out.count ||')');
3924: END IF;
3925:
3926:

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

3927: -----errorout_ad('LEVEL ELEMENT INSERT STATUS = ' || x_return_status);
3928:
3929:
3930: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3931: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row = ' || l__msg_data);
3932: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3933: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3934: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row = ' || l_msg_data);
3935: RAISE OKC_API.G_EXCEPTION_ERROR;

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

3930: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3931: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row = ' || l__msg_data);
3932: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3933: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3934: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row = ' || l_msg_data);
3935: RAISE OKC_API.G_EXCEPTION_ERROR;
3936: END IF;
3937: END IF;
3938:

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

Line 5504: OKS_BILL_LEVEL_ELEMENTS_PVT.update_row(

5500:
5501:
5502:
5503: IF x_return_status = 'S' then
5504: OKS_BILL_LEVEL_ELEMENTS_PVT.update_row(
5505: p_api_version => l_api_version,
5506: p_init_msg_list => l_init_msg_list,
5507: x_return_status => x_return_status,
5508: x_msg_count => x_msg_count,

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

5511: x_letv_tbl => l_lvl_ele_tbl_out);
5512:
5513: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
5514: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_bill_sch_cp.update_top_bs',
5515: 'oks_bill_level_elements_pvt.update_row(x_return_status = '||x_return_status ||')');
5516: END IF;
5517: else
5518:
5519: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 7022: p_top_line_bs IN OUT NOCOPY oks_bill_level_elements_pvt.letv_tbl_type,

7018:
7019: PROCEDURE Adjust_top_BS_Amt(
7020: p_Line_Rec IN Line_Det_Type,
7021: p_SubLine_rec IN Prod_Det_Type,
7022: p_top_line_bs IN OUT NOCOPY oks_bill_level_elements_pvt.letv_tbl_type,
7023: x_return_status OUT NOCOPY VARCHAR2)
7024: IS
7025:
7026: CURSOR l_cp_BS_csr(p_cp_id NUMBER) IS

Line 7034: l_cp_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;

7030: WHERE cle_id = p_cp_id
7031: ORDER by date_start;
7032:
7033: l_cp_BS_rec l_cp_BS_csr%ROWTYPE;
7034: l_cp_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;
7035: l_index number;
7036: l_top_bs_ind number;
7037: l_cp_bs_ind number;
7038:

Line 7449: l_top_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;

7445: l_bill_type_rec l_bill_type_csr%ROWTYPE;
7446:
7447:
7448:
7449: l_top_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;
7450: l_cp_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;
7451: x_letv_tbl oks_bill_level_elements_pvt.letv_tbl_type;
7452:
7453:

Line 7450: l_cp_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;

7446:
7447:
7448:
7449: l_top_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;
7450: l_cp_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;
7451: x_letv_tbl oks_bill_level_elements_pvt.letv_tbl_type;
7452:
7453:
7454: i NUMBER := 0;

Line 7451: x_letv_tbl oks_bill_level_elements_pvt.letv_tbl_type;

7447:
7448:
7449: l_top_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;
7450: l_cp_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;
7451: x_letv_tbl oks_bill_level_elements_pvt.letv_tbl_type;
7452:
7453:
7454: i NUMBER := 0;
7455: l_index NUMBER := 0;

Line 7552: OKS_BILL_LEVEL_ELEMENTS_PVT.update_row(

7548: exit when (l_top_bs_ind = l_top_bs_tbl.LAST);/*fix for bug 12395037*/
7549: l_top_bs_ind := l_top_bs_ind + 1;
7550: END LOOP;
7551:
7552: OKS_BILL_LEVEL_ELEMENTS_PVT.update_row(
7553: p_api_version => l_api_version,
7554: p_init_msg_list => l_init_msg_list,
7555: x_return_status => x_return_status,
7556: x_msg_count => l_msg_count,

Line 7635: l_update_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;

7631:
7632:
7633: l_subLine_rec l_subLine_Csr%ROWTYPE;
7634: l_index NUMBER := 0;
7635: l_update_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;
7636: l_lvl_index NUMBER := 0;
7637: l_line_rec l_line_csr%ROWTYPE;
7638:
7639: l_cp_line_bs oks_bill_level_elements_pvt.letv_tbl_type;

Line 7639: l_cp_line_bs oks_bill_level_elements_pvt.letv_tbl_type;

7635: l_update_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;
7636: l_lvl_index NUMBER := 0;
7637: l_line_rec l_line_csr%ROWTYPE;
7638:
7639: l_cp_line_bs oks_bill_level_elements_pvt.letv_tbl_type;
7640: l_line_tbl_in oks_bill_level_elements_pvt.letv_tbl_type;
7641: l_top_index NUMBER := 0;
7642:
7643:

Line 7640: l_line_tbl_in oks_bill_level_elements_pvt.letv_tbl_type;

7636: l_lvl_index NUMBER := 0;
7637: l_line_rec l_line_csr%ROWTYPE;
7638:
7639: l_cp_line_bs oks_bill_level_elements_pvt.letv_tbl_type;
7640: l_line_tbl_in oks_bill_level_elements_pvt.letv_tbl_type;
7641: l_top_index NUMBER := 0;
7642:
7643:
7644: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;

Line 7817: OKS_BILL_LEVEL_ELEMENTS_PVT.update_row(

7813:
7814: -----errorout_ad('l_lvl_ele_tbl_in.COUNT = ' || l_lvl_ele_tbl_in.COUNT );
7815:
7816: IF l_lvl_ele_tbl_in.COUNT > 0 THEN
7817: OKS_BILL_LEVEL_ELEMENTS_PVT.update_row(
7818: p_api_version => l_api_version,
7819: p_init_msg_list => l_init_msg_list,
7820: x_return_status => x_return_status,
7821: x_msg_count => x_msg_count,

Line 7854: x_bs_tbl OUT NOCOPY oks_bill_level_elements_pvt.letv_tbl_type,

7850: Procedure Adjust_interface_date(p_line_id IN NUMBER,
7851: p_invoice_rule_id IN Number,
7852: p_line_end_date IN DATE,
7853: p_lse_id IN NUMBER,
7854: x_bs_tbl OUT NOCOPY oks_bill_level_elements_pvt.letv_tbl_type,
7855: x_return_status OUT NOCOPY VARCHAR2,
7856: x_msg_count OUT NOCOPY NUMBER,
7857: x_msg_data OUT NOCOPY VARCHAR2)
7858: IS

Line 7886: l_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;

7882:
7883:
7884: l_index NUMBER := 0;
7885: l_bs_index NUMBER := 0;
7886: l_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;
7887: l_sll_end_date DATE;
7888: l_interface_offset NUMBER;
7889: l_date_to_interface DATE;
7890: l_out_index NUMBER := 0;

Line 8172: l_dummy_top_line_bs oks_bill_level_elements_pvt.letv_tbl_type;

8168: l_tce_code VARCHAR2(100);
8169: L_CONSTANT_SLL_AMT NUMBER;
8170: l_remaining_amt NUMBER;
8171: L_SLL_AMT NUMBER;
8172: l_dummy_top_line_bs oks_bill_level_elements_pvt.letv_tbl_type;
8173: l_bill_type VARCHAR2(10);
8174:
8175: --
8176: l_api_version CONSTANT NUMBER := 1.0;

Line 8545: OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row(

8541: l_adjusted_amt := (l_lvl_ele_tbl_in(l_lvl_ele_tbl_in.LAST).amount) + (l_line_amt - l_bill_sch_amt);
8542: l_lvl_ele_tbl_in(l_lvl_ele_tbl_in.LAST).amount := l_adjusted_amt;
8543: END IF;
8544:
8545: OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row(
8546: p_api_version => l_api_version,
8547: p_init_msg_list => l_init_msg_list,
8548: x_return_status => x_return_status,
8549: x_msg_count => l_msg_count,

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

8554: -----errorout_ad('LEVEL ELEMENT INSERT STATUS FOR SUBLINE = ' || x_return_status);
8555:
8556:
8557: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
8558: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row for sub line = ' || l_msg_data);
8559: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
8560: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
8561: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row for sub line = ' || l_msg_data);
8562: RAISE OKC_API.G_EXCEPTION_ERROR;

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

8557: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
8558: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row for sub line = ' || l_msg_data);
8559: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
8560: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
8561: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row for sub line = ' || l_msg_data);
8562: RAISE OKC_API.G_EXCEPTION_ERROR;
8563: END IF;
8564: END IF;
8565:

Line 9027: l_top_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;

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

Line 9392: OKS_BILL_LEVEL_ELEMENTS_PVT.update_row(

9388: END IF; ---END OF SUBLINE LOOP
9389:
9390:
9391: IF l_top_bs_tbl.COUNT >0 THEN ---only for type 'T' l_top_bs_tbl will be having records
9392: OKS_BILL_LEVEL_ELEMENTS_PVT.update_row(
9393: p_api_version => l_api_version,
9394: p_init_msg_list => l_init_msg_list,
9395: x_return_status => x_return_status,
9396: x_msg_count => x_msg_count,

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

9399: x_letv_tbl => l_lvl_ele_tbl_out);
9400:
9401: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
9402: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.terminate_bill_sch.update_bs',
9403: 'oks_bill_level_elements_pvt.update_row(x_return_status = '||x_return_status
9404: ||', top bs count = '||l_lvl_ele_tbl_out.count ||')');
9405: END IF;
9406:
9407: IF x_return_status <> 'S' THEN

Line 9539: OKS_BILL_LEVEL_ELEMENTS_PVT.update_row(

9535: RAISE G_EXCEPTION_HALT_VALIDATION;
9536: END IF;
9537:
9538: IF l_subline_rec.billing_schedule_type IN ('E','T') AND l_top_bs_tbl.COUNT > 0 then
9539: OKS_BILL_LEVEL_ELEMENTS_PVT.update_row(
9540: p_api_version => l_api_version,
9541: p_init_msg_list => l_init_msg_list,
9542: x_return_status => x_return_status,
9543: x_msg_count => x_msg_count,

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

9546: x_letv_tbl => l_lvl_ele_tbl_out);
9547:
9548: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
9549: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.terminate_bill_sch.update_bs',
9550: 'oks_bill_level_elements_pvt.update_row(x_return_status = '||x_return_status
9551: ||', top bs count = '||l_lvl_ele_tbl_out.count ||')');
9552: END IF;
9553:
9554: IF x_return_status <> 'S' THEN

Line 9594: p_top_line_bs IN OUT NOCOPY oks_bill_level_elements_pvt.letv_tbl_type,

9590: p_cp_sll_tbl IN StrmLvl_Out_tbl,
9591: p_Line_Rec IN Line_Det_Type,
9592: p_SubLine_rec IN Prod_Det_Type,
9593: p_invoice_rulid IN Number,
9594: p_top_line_bs IN OUT NOCOPY oks_bill_level_elements_pvt.letv_tbl_type,
9595: p_term_dt IN DATE,
9596: p_period_start IN VARCHAR2,
9597: p_period_type IN VARCHAR2,
9598: x_return_status OUT NOCOPY Varchar2

Line 10500: OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row(

10496: IF l_lvl_ele_tbl_in(l_lvl_ele_tbl_in.LAST).date_end > p_subline_rec.cp_end_dt THEN
10497: l_lvl_ele_tbl_in(l_lvl_ele_tbl_in.LAST).date_end := p_subline_rec.cp_end_dt;
10498: END IF;
10499:
10500: OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row(
10501: p_api_version => l_api_version,
10502: p_init_msg_list => l_init_msg_list,
10503: x_return_status => x_return_status,
10504: x_msg_count => l_msg_count,

Line 11176: p_top_line_bs IN OUT NOCOPY oks_bill_level_elements_pvt.letv_tbl_type,

11172:
11173: PROCEDURE Rollup_lvl_amt(
11174: p_Line_Rec IN Line_Det_Type,
11175: p_SubLine_rec IN Prod_Det_Type,
11176: p_top_line_bs IN OUT NOCOPY oks_bill_level_elements_pvt.letv_tbl_type,
11177: x_return_status OUT NOCOPY VARCHAR2)
11178: IS
11179:
11180: CURSOR l_cp_BS_csr(p_cp_id NUMBER) IS

Line 11188: l_cp_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;

11184: WHERE cle_id = p_cp_id
11185: ORDER by date_start;
11186:
11187: l_cp_BS_rec l_cp_BS_csr%ROWTYPE;
11188: l_cp_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;
11189: l_index number;
11190: l_top_bs_ind number;
11191: l_cp_bs_ind number;
11192:

Line 11300: p_top_bs_tbl IN oks_bill_level_elements_pvt.letv_tbl_type,

11296: END Create_Bill_Sch_Rules;
11297:
11298:
11299: PROCEDURE Adjust_cp_trx_inv_dt(
11300: p_top_bs_tbl IN oks_bill_level_elements_pvt.letv_tbl_type,
11301: p_SubLine_id IN NUMBER,
11302: x_cp_line_bs OUT NOCOPY oks_bill_level_elements_pvt.letv_tbl_type,
11303: x_return_status OUT NOCOPY VARCHAR2)
11304: IS

Line 11302: x_cp_line_bs OUT NOCOPY oks_bill_level_elements_pvt.letv_tbl_type,

11298:
11299: PROCEDURE Adjust_cp_trx_inv_dt(
11300: p_top_bs_tbl IN oks_bill_level_elements_pvt.letv_tbl_type,
11301: p_SubLine_id IN NUMBER,
11302: x_cp_line_bs OUT NOCOPY oks_bill_level_elements_pvt.letv_tbl_type,
11303: x_return_status OUT NOCOPY VARCHAR2)
11304: IS
11305:
11306: CURSOR l_cp_BS_csr IS

Line 11315: l_cp_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;

11311: AND date_completed IS NULL
11312: ORDER BY date_start;
11313:
11314: l_cp_BS_rec l_cp_BS_csr%ROWTYPE;
11315: l_cp_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;
11316: l_index number;
11317: l_top_bs_ind number;
11318: l_cp_bs_ind number;
11319:

Line 11940: l_top_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;

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

Line 11942: l_cp_new_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;

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

Line 11943: l_cp_old_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;

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:
11946: l_top_line_rec Line_Det_Type;
11947: l_cp_rec Prod_Det_Type;

Line 12747: p_old_cp_bs_tbl IN OUT NOCOPY oks_bill_level_elements_pvt.letv_tbl_type,

12743: END Prorate_sll_amt;
12744:
12745:
12746: PROCEDURE Adjust_billed_lvl_element(p_new_cp_id IN NUMBER,
12747: p_old_cp_bs_tbl IN OUT NOCOPY oks_bill_level_elements_pvt.letv_tbl_type,
12748: x_new_cp_bs_tbl OUT NOCOPY oks_bill_level_elements_pvt.letv_tbl_type,
12749: x_return_status OUT NOCOPY VARCHAR2)
12750: IS
12751:

Line 12748: x_new_cp_bs_tbl OUT NOCOPY oks_bill_level_elements_pvt.letv_tbl_type,

12744:
12745:
12746: PROCEDURE Adjust_billed_lvl_element(p_new_cp_id IN NUMBER,
12747: p_old_cp_bs_tbl IN OUT NOCOPY oks_bill_level_elements_pvt.letv_tbl_type,
12748: x_new_cp_bs_tbl OUT NOCOPY oks_bill_level_elements_pvt.letv_tbl_type,
12749: x_return_status OUT NOCOPY VARCHAR2)
12750: IS
12751:
12752:

Line 12907: l_top_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;

12903: l_cp_BS_rec l_cp_BS_csr%ROWTYPE;
12904: l_bill_type_rec l_bill_type_csr%ROWTYPE;
12905:
12906:
12907: l_top_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;
12908: l_cp_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;
12909: x_letv_tbl oks_bill_level_elements_pvt.letv_tbl_type;
12910:
12911:

Line 12908: l_cp_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;

12904: l_bill_type_rec l_bill_type_csr%ROWTYPE;
12905:
12906:
12907: l_top_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;
12908: l_cp_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;
12909: x_letv_tbl oks_bill_level_elements_pvt.letv_tbl_type;
12910:
12911:
12912: i NUMBER := 0;

Line 12909: x_letv_tbl oks_bill_level_elements_pvt.letv_tbl_type;

12905:
12906:
12907: l_top_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;
12908: l_cp_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;
12909: x_letv_tbl oks_bill_level_elements_pvt.letv_tbl_type;
12910:
12911:
12912: i NUMBER := 0;
12913: l_index NUMBER := 0;

Line 13059: OKS_BILL_LEVEL_ELEMENTS_PVT.update_row(

13055: End if;
13056: l_top_bs_ind := l_top_bs_ind + 1;
13057: END LOOP;
13058:
13059: OKS_BILL_LEVEL_ELEMENTS_PVT.update_row(
13060: p_api_version => l_api_version,
13061: p_init_msg_list => l_init_msg_list,
13062: x_return_status => x_return_status,
13063: x_msg_count => l_msg_count,