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_UTIL_PUB

Line 9: l_fnd_lvl_in_rec oks_bill_util_pub.bill_det_inp_rec;

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:
13: --Bug Fix 5185658

Line 10: l_fnd_lvl_out_rec oks_bill_util_pub.bill_sch_rec;

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:
13: --Bug Fix 5185658
14: pkg_cascade_billing_hdr varchar2(1) := 'N';

Line 703: OKS_BILL_UTIL_PUB.Get_Seeded_Timeunit

699: l_target_tce_code VARCHAR2(30);
700: l_target_qty NUMBER;
701:
702: BEGIN
703: OKS_BILL_UTIL_PUB.Get_Seeded_Timeunit
704: (p_timeunit => p_price_uom,
705: x_return_status => l_return_status,
706: x_quantity => l_target_uom_quantity ,
707: x_timeunit => l_target_tce_code);

Line 713: OKS_BILL_UTIL_PUB.Get_Seeded_Timeunit

709: IF l_return_status <> 'S' THEN
710: RAISE G_EXCEPTION_HALT_VALIDATION;
711: END IF;
712:
713: OKS_BILL_UTIL_PUB.Get_Seeded_Timeunit
714: (p_timeunit => p_pl_uom,
715: x_return_status => l_return_status,
716: x_quantity => l_source_uom_quantity ,
717: x_timeunit => l_source_tce_code);

Line 2117: OKS_BILL_UTIL_PUB.Get_Seeded_Timeunit

2113: -- Developer Mani Choudhary
2114: -- Date 09-MAY-2005
2115: -- In case of calendar start , call the new funtion to derive the SLL end date
2116: -------------------------------------------------------------------------
2117: OKS_BILL_UTIL_PUB.Get_Seeded_Timeunit
2118: (p_timeunit => p_strm_lvl_tbl(l_tbl_count).uom_code,
2119: x_return_status => x_return_status,
2120: x_quantity => l_uom_quantity ,
2121: x_timeunit => l_tce_code);

Line 2131: l_end_date := OKS_BILL_UTIL_PUB.get_enddate_cal

2127: p_period_type is not null AND
2128: p_period_start = 'CALENDAR' AND
2129: l_tce_code not in ('DAY','HOUR','MINUTE')
2130: THEN
2131: l_end_date := OKS_BILL_UTIL_PUB.get_enddate_cal
2132: (l_start_date,
2133: p_strm_lvl_tbl(l_tbl_count).uom_code,
2134: p_strm_lvl_tbl(l_tbl_count).uom_per_period,
2135: p_strm_lvl_tbl(l_tbl_count).level_periods);

Line 3279: OKS_BILL_UTIL_PUB.get_seeded_timeunit(

3275: RETURN;
3276: END IF;
3277:
3278: IF l_bill_type = 'T' AND p_line_rec.lse_id = 46 THEN
3279: OKS_BILL_UTIL_PUB.get_seeded_timeunit(
3280: p_timeunit => p_sll_tbl(l_line_sll_counter).uom,
3281: x_return_status => x_return_status,
3282: x_quantity => l_uom_quantity ,
3283: x_timeunit => l_tce_code);

Line 3287: 'OKS_BILL_UTIL_PUB.get_seeded_timeunit(x_return_status = '||x_return_status

3283: x_timeunit => l_tce_code);
3284:
3285: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
3286: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.Create_Level_elements.seed_time',
3287: 'OKS_BILL_UTIL_PUB.get_seeded_timeunit(x_return_status = '||x_return_status
3288: ||', x_timeunit = ' || l_tce_code
3289: ||', x_quantity = '|| l_uom_quantity ||')');
3290: END IF;
3291:

Line 3322: OKS_BILL_UTIL_PUB.Get_Seeded_Timeunit

3318: RAISE G_EXCEPTION_HALT_VALIDATION;
3319: END IF;
3320: END IF; ---end of lse_id = 46
3321:
3322: OKS_BILL_UTIL_PUB.Get_Seeded_Timeunit
3323: (p_timeunit => p_sll_tbl(l_line_sll_counter).uom,
3324: x_return_status => x_return_status,
3325: x_quantity => l_uom_quantity ,
3326: x_timeunit => l_tce_code);

Line 3355: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch for line passed period :' || to_char(l_fnd_lvl_in_rec.uom_per_period));

3351: l_fnd_lvl_in_rec.uom_per_period := p_sll_tbl(l_line_sll_counter).uom_Per_Period;
3352: -----errorout_ad(' p_Line_rec.line_start_dt :' || to_char(p_line_rec.line_start_dt));
3353: -----errorout_ad(' p_Line_rec.line_end_dt :' || to_char(p_line_rec.line_end_dt));
3354: -----errorout_ad(' l_line_amt :' || l_line_amt);
3355: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch for line passed period :' || to_char(l_fnd_lvl_in_rec.uom_per_period));
3356: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch for line passed uom :' || l_fnd_lvl_in_rec.uom);
3357: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch for line passed cycle_start_date:' || to_char(l_fnd_lvl_in_rec.cycle_start_date));
3358:
3359: -------------------------------------------------------------------------

Line 3356: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch for line passed uom :' || l_fnd_lvl_in_rec.uom);

3352: -----errorout_ad(' p_Line_rec.line_start_dt :' || to_char(p_line_rec.line_start_dt));
3353: -----errorout_ad(' p_Line_rec.line_end_dt :' || to_char(p_line_rec.line_end_dt));
3354: -----errorout_ad(' l_line_amt :' || l_line_amt);
3355: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch for line passed period :' || to_char(l_fnd_lvl_in_rec.uom_per_period));
3356: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch for line passed uom :' || l_fnd_lvl_in_rec.uom);
3357: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch for line passed cycle_start_date:' || to_char(l_fnd_lvl_in_rec.cycle_start_date));
3358:
3359: -------------------------------------------------------------------------
3360: -- Begin partial period computation logic

Line 3357: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch for line passed cycle_start_date:' || to_char(l_fnd_lvl_in_rec.cycle_start_date));

3353: -----errorout_ad(' p_Line_rec.line_end_dt :' || to_char(p_line_rec.line_end_dt));
3354: -----errorout_ad(' l_line_amt :' || l_line_amt);
3355: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch for line passed period :' || to_char(l_fnd_lvl_in_rec.uom_per_period));
3356: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch for line passed uom :' || l_fnd_lvl_in_rec.uom);
3357: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch for line passed cycle_start_date:' || to_char(l_fnd_lvl_in_rec.cycle_start_date));
3358:
3359: -------------------------------------------------------------------------
3360: -- Begin partial period computation logic
3361: -- Developer Mani Choudhary

Line 3367: 'Calling oks_bill_util_pub.Get_next_bill_sch with parameters '

3363: -- Added two new parameters p_period_start and p_period_type
3364: -- Start - Modified by PMALLARA - Bug #3992530
3365: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
3366: fnd_log.string(fnd_log.level_procedure,G_MODULE_CURRENT||'.Create_Level_elements.lvl_loop',
3367: 'Calling oks_bill_util_pub.Get_next_bill_sch with parameters '
3368: ||'period start = ' || p_period_start
3369: ||', period type = ' || p_period_type);
3370: END IF;
3371:

Line 3372: OKS_BILL_UTIL_PUB.Get_next_bill_sch

3368: ||'period start = ' || p_period_start
3369: ||', period type = ' || p_period_type);
3370: END IF;
3371:
3372: OKS_BILL_UTIL_PUB.Get_next_bill_sch
3373: (p_api_version => l_api_version,
3374: x_return_status => x_return_status,
3375: x_msg_count => l_msg_count,
3376: x_msg_data => l_msg_data,

Line 3388: 'oks_bill_util_pub.Get_next_bill_sch(x_return_status = '||x_return_status

3384:
3385:
3386: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
3387: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.Create_Level_elements.lvl_loop',
3388: 'oks_bill_util_pub.Get_next_bill_sch(x_return_status = '||x_return_status
3389: ||', next date = ' || l_fnd_lvl_out_rec.next_cycle_date
3390: ||', tuom per period = ' || l_fnd_lvl_in_rec.tuom_per_period
3391: ||', cycle_start_date = '|| l_next_cycle_dt ||')');
3392: END IF;

Line 3398: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_msg_data);

3394:
3395: -----errorout_ad('LEVEL ELEMENT NEXT CYCLE DATE passed from Get_next_bill_sch = ' || TO_CHAR(l_fnd_lvl_out_rec.next_cycle_date));
3396:
3397: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3398: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_msg_data);
3399: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3400: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3401: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_msg_data);
3402: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 3401: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_msg_data);

3397: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3398: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_msg_data);
3399: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3400: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3401: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_msg_data);
3402: RAISE OKC_API.G_EXCEPTION_ERROR;
3403: END IF;
3404:
3405:

Line 3801: OKS_BILL_UTIL_PUB.Get_next_bill_sch

3797: -- Developer Mani Choudhary
3798: -- Date 09-MAY-2005
3799: -- Added two new parameters p_period_start and p_period_type
3800: -- Start - Modified by PMALLARA - Bug #3992530
3801: OKS_BILL_UTIL_PUB.Get_next_bill_sch
3802: (p_api_version => l_api_version,
3803: x_return_status => x_return_status,
3804: x_msg_count => l_msg_count,
3805: x_msg_data => l_msg_data,

Line 3816: 'oks_bill_util_pub.Get_next_bill_sch(x_return_status = '||x_return_status

3812: -- End - Modified by PMALLARA - Bug #3992530
3813:
3814: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
3815: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_hdr_level_elements.lvl_loop',
3816: 'oks_bill_util_pub.Get_next_bill_sch(x_return_status = '||x_return_status
3817: ||', next date = ' || l_fnd_lvl_out_rec.next_cycle_date
3818: ||', tuom per period = ' || l_fnd_lvl_in_rec.tuom_per_period
3819: ||', cycle_start_date = '|| l_next_cycle_dt ||')');
3820: END IF;

Line 3825: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_fnd_msg_data);

3821:
3822: -----errorout_ad('hdr Get_next_bill_sch status = ' || x_return_status);
3823:
3824: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3825: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_fnd_msg_data);
3826: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3827: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3828: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_fnd_msg_data);
3829: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 3828: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_fnd_msg_data);

3824: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3825: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_fnd_msg_data);
3826: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3827: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3828: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_fnd_msg_data);
3829: RAISE OKC_API.G_EXCEPTION_ERROR;
3830: END IF;
3831:
3832:

Line 4457: oks_bill_util_pub.get_seeded_timeunit(

4453: -------------------------------------------------------------------------
4454: ELSE
4455: For i in 1 .. l_sll_num Loop
4456: l_uom_code := p_sll_prorated_tab(i).sll_tuom ;
4457: oks_bill_util_pub.get_seeded_timeunit(
4458: p_timeunit => l_uom_code ,
4459: x_return_status => l_return_status,
4460: x_quantity => l_uom_quantity,
4461: x_timeunit => l_tce_code);

Line 4892: l_frequency := OKS_BILL_UTIL_PUB.get_frequency

4888: ||', st-end dt = ' || p_line_start_date || '-' || p_line_end_date );
4889: END IF;
4890:
4891: If p_line_start_date > p_cycle_start_date then ---and l_start_date < l_next_billing_date Then
4892: l_frequency := OKS_BILL_UTIL_PUB.get_frequency
4893: (p_tce_code => p_tce_code,
4894: p_fr_end_date => p_line_end_date ,
4895: p_fr_start_date => p_line_start_date, --this LINE st dt
4896: p_uom_quantity => p_uom_quantity,

Line 4901: l_frequency := OKS_BILL_UTIL_PUB.get_frequency

4897: x_return_status => X_return_status);
4898:
4899:
4900: ELSE
4901: l_frequency := OKS_BILL_UTIL_PUB.get_frequency
4902: (p_tce_code => p_tce_code,
4903: p_fr_end_date => p_line_end_date ,
4904: p_fr_start_date => p_cycle_start_date, --this cycle st dt to find remaining period
4905: p_uom_quantity => p_uom_quantity,

Line 4912: 'oks_bill_util_pub.get_frequency(x_return_status = '||x_return_status

4908: END IF;
4909:
4910: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
4911: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.get_constant_sll_amount.freq',
4912: 'oks_bill_util_pub.get_frequency(x_return_status = '||x_return_status
4913: ||', l_frequency = '|| l_frequency ||')');
4914: END IF;
4915:
4916: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then

Line 4960: x_period_freq := OKS_BILL_UTIL_PUB.get_frequency

4956:
4957: BEGIN
4958: x_return_status := OKC_API.G_RET_STS_SUCCESS;
4959: If p_line_start_date > p_cycle_start_date and p_line_start_date < P_next_billing_date Then
4960: x_period_freq := OKS_BILL_UTIL_PUB.get_frequency
4961: (p_tce_code => p_tce_code,
4962: p_fr_start_date => p_line_start_date,
4963: p_fr_end_date => p_next_billing_date - 1,
4964: p_uom_quantity => p_uom_quantity,

Line 4968: x_period_freq:= OKS_BILL_UTIL_PUB.get_frequency

4964: p_uom_quantity => p_uom_quantity,
4965: x_return_status => x_return_status);
4966:
4967: ElsiF( p_next_billing_date > p_line_end_date + 1) THEN
4968: x_period_freq:= OKS_BILL_UTIL_PUB.get_frequency
4969: (p_tce_code => p_tce_code,
4970: p_fr_end_date => p_line_end_date,
4971: p_fr_start_date => p_cycle_start_date,
4972: p_uom_quantity => p_uom_quantity,

Line 4984: 'oks_bill_util_pub.get_frequency(x_return_status = '||x_return_status

4980:
4981:
4982: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
4983: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.get_period_frequency.freq',
4984: 'oks_bill_util_pub.get_frequency(x_return_status = '||x_return_status
4985: ||', x_period_freq = '|| x_period_freq ||')');
4986: END IF;
4987:
4988: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then

Line 5349: OKS_BILL_UTIL_PUB.Adjust_line_price(

5345: END IF;
5346: -----if the subline is update then chk if max_bill_dt = end date and update the price.
5347: IF nvl(p_cp_new,'Y') = 'N' AND l_cp_rec.cp_amt > 0 THEN
5348:
5349: OKS_BILL_UTIL_PUB.Adjust_line_price(
5350: p_top_line_id => p_top_line_id,
5351: p_sub_line_id => p_cp_line_id ,
5352: p_end_date => l_cp_rec.cp_end_dt,
5353: p_amount => l_cp_rec.cp_amt,

Line 5737: OKS_BILL_UTIL_PUB.Adjust_line_price(

5733:
5734:
5735:
5736: IF l_usage_type = 'NPR' THEN
5737: OKS_BILL_UTIL_PUB.Adjust_line_price(
5738: p_top_line_id => p_top_line_id,
5739: p_sub_line_id => NULL,
5740: p_end_date => NULL,
5741: p_amount => NULL,

Line 5752: OKS_BILL_UTIL_PUB.Adjust_line_price(

5748: END IF; ---- l_usage_type_csr data found chk
5749: Close l_usage_type_csr;
5750:
5751: ELSE --- LINE lse_id <> 12
5752: OKS_BILL_UTIL_PUB.Adjust_line_price(
5753: p_top_line_id => p_top_line_id,
5754: p_sub_line_id => NULL,
5755: p_end_date => NULL,
5756: p_amount => NULL,

Line 5867: l_level_periods:=OKS_BILL_UTIL_PUB.Get_Periods(p_start_date => l_line_rec.line_start_dt,

5863: l_period_type IS NOT NULL AND
5864: l_period_start = 'CALENDAR'
5865: THEN
5866: -- IF(TRUNC(l_sll_start_date,'MM') = TRUNC(l_sll_start_date)) THEN
5867: l_level_periods:=OKS_BILL_UTIL_PUB.Get_Periods(p_start_date => l_line_rec.line_start_dt,
5868: p_end_date => TRUNC(l_sll_tbl(l_sll_tbl_index).End_date),
5869: p_uom_code => l_sll_tbl(l_sll_tbl_index).uom_code,
5870: p_period_start => l_period_start);
5871:

Line 5880: l_next_date := OKS_BILL_UTIL_PUB.Get_Enddate_Cal(

5876: l_sll_tbl(l_sll_tbl_index).sequence_no := l_sequence;
5877: l_sll_tbl(l_sll_tbl_index).start_date := l_line_rec.line_start_dt;
5878: l_sll_tbl(l_sll_tbl_index).end_date := TRUNC(l_sll_tbl(l_sll_tbl_index).End_date);
5879: l_sll_tbl(l_sll_tbl_index).level_periods := ceil(l_level_periods/l_sll_tbl(l_sll_tbl_index).uom_per_period);
5880: l_next_date := OKS_BILL_UTIL_PUB.Get_Enddate_Cal(
5881: p_start_date => l_sll_tbl(l_sll_tbl_index).start_date,
5882: p_uom_code => l_sll_tbl(l_sll_tbl_index).uom_code,
5883: p_duration => l_sll_tbl(l_sll_tbl_index).uom_per_period,
5884: p_level_periods => l_sll_tbl(l_sll_tbl_index).level_periods);

Line 5924: OKS_BILL_UTIL_PUB.get_seeded_timeunit(

5920: IF x_return_status <> 'S' THEN
5921: RAISE G_EXCEPTION_HALT_VALIDATION;
5922: END IF;
5923:
5924: OKS_BILL_UTIL_PUB.get_seeded_timeunit(
5925: p_timeunit => l_timeunit,
5926: x_return_status => x_return_status,
5927: x_quantity => l_uom_quantity ,
5928: x_timeunit => l_tce_code);

Line 5991: l_next_date := OKS_BILL_UTIL_PUB.Get_Enddate_Cal(

5987: IF l_period_start IS NOT NULL AND
5988: l_period_type IS NOT NULL AND
5989: l_period_start = 'CALENDAR'
5990: THEN
5991: l_next_date := OKS_BILL_UTIL_PUB.Get_Enddate_Cal(
5992: p_start_date => l_sll_tbl(l_sll_tbl_index).start_date,
5993: p_uom_code => l_sll_tbl(l_sll_tbl_index).uom_code,
5994: p_duration => l_sll_tbl(l_sll_tbl_index).uom_per_period,
5995: p_level_periods => l_sll_tbl(l_sll_tbl_index).level_periods);

Line 6120: l_level_periods:=OKS_BILL_UTIL_PUB.Get_Periods(p_start_date => l_line_rec.line_start_dt,

6116: IF l_period_start IS NOT NULL AND
6117: l_period_type IS NOT NULL AND
6118: l_period_start = 'CALENDAR'
6119: THEN
6120: l_level_periods:=OKS_BILL_UTIL_PUB.Get_Periods(p_start_date => l_line_rec.line_start_dt,
6121: p_end_date => l_sll_end_date,
6122: p_uom_code => l_sll_tbl(l_sll_tbl_index).uom_code,
6123: p_period_start => l_period_start);
6124:

Line 6128: l_next_date := OKS_BILL_UTIL_PUB.Get_Enddate_Cal(

6124:
6125: l_sll_tbl(l_sll_tbl_index).start_date := l_line_rec.line_start_dt;
6126: l_sll_tbl(l_sll_tbl_index).end_date := l_sll_end_date;
6127: l_sll_tbl(l_sll_tbl_index).level_periods := ceil(l_level_periods/l_sll_tbl(l_sll_tbl_index).uom_per_period);
6128: l_next_date := OKS_BILL_UTIL_PUB.Get_Enddate_Cal(
6129: p_start_date => l_sll_tbl(l_sll_tbl_index).start_date,
6130: p_uom_code => l_sll_tbl(l_sll_tbl_index).uom_code,
6131: p_duration => l_sll_tbl(l_sll_tbl_index).uom_per_period,
6132: p_level_periods => l_sll_tbl(l_sll_tbl_index).level_periods);

Line 6156: OKS_BILL_UTIL_PUB.get_seeded_timeunit(

6152: -----errorout_ad('l_sll_end_date = ' || l_sll_end_date);
6153:
6154: ----find out the periods between line start date and SLL end date
6155:
6156: OKS_BILL_UTIL_PUB.get_seeded_timeunit(
6157: p_timeunit => l_sll_tbl(l_sll_tbl_index).uom_code,
6158: x_return_status => x_return_status,
6159: x_quantity => l_uom_quantity ,
6160: x_timeunit => l_tce_code);

Line 6189: l_period_freq := OKS_BILL_UTIL_PUB.get_frequency

6185: -- END IF;
6186:
6187: -- ELSE ----not day
6188:
6189: l_period_freq := OKS_BILL_UTIL_PUB.get_frequency
6190: (p_tce_code => l_tce_code,
6191: p_fr_start_date => l_line_rec.line_start_dt,
6192: p_fr_end_date => l_sll_end_date,
6193: p_uom_quantity => l_uom_quantity,

Line 6236: l_next_date := OKS_BILL_UTIL_PUB.Get_Enddate_Cal(

6232: IF l_period_start IS NOT NULL AND
6233: l_period_type IS NOT NULL AND
6234: l_period_start = 'CALENDAR'
6235: THEN
6236: l_next_date := OKS_BILL_UTIL_PUB.Get_Enddate_Cal(
6237: p_start_date => l_sll_tbl(l_sll_tbl_index).start_date,
6238: p_uom_code => l_sll_tbl(l_sll_tbl_index).uom_code,
6239: p_duration => l_sll_tbl(l_sll_tbl_index).uom_per_period,
6240: p_level_periods => l_sll_tbl(l_sll_tbl_index).level_periods);

Line 6286: OKS_BILL_UTIL_PUB.get_seeded_timeunit(

6282: IF x_return_status <> 'S' THEN
6283: RAISE G_EXCEPTION_HALT_VALIDATION;
6284: END IF;
6285:
6286: OKS_BILL_UTIL_PUB.get_seeded_timeunit(
6287: p_timeunit => l_timeunit,
6288: x_return_status => x_return_status,
6289: x_quantity => l_uom_quantity ,
6290: x_timeunit => l_tce_code);

Line 6312: l_level_periods:=OKS_BILL_UTIL_PUB.Get_Periods(p_start_date => l_line_rec.line_start_dt,

6308: THEN
6309: IF l_price_uom IS NULL THEN
6310: l_price_uom := l_timeunit;
6311: END IF;
6312: l_level_periods:=OKS_BILL_UTIL_PUB.Get_Periods(p_start_date => l_line_rec.line_start_dt,
6313: p_end_date => l_line_rec.line_end_dt,
6314: p_uom_code => l_price_uom,
6315: p_period_start => l_period_start);
6316:

Line 6404: l_level_periods:=OKS_BILL_UTIL_PUB.Get_Periods(p_start_date => l_sll_tbl(l_sll_tbl_index).start_date,

6400: IF l_period_start IS NOT NULL AND
6401: l_period_type IS NOT NULL AND
6402: l_period_start = 'CALENDAR'
6403: THEN
6404: l_level_periods:=OKS_BILL_UTIL_PUB.Get_Periods(p_start_date => l_sll_tbl(l_sll_tbl_index).start_date,
6405: p_end_date => l_line_rec.line_END_dt,
6406: p_uom_code => l_sll_tbl(l_sll_tbl_index).uom_code,
6407: p_period_start => l_period_start);
6408:

Line 6416: l_next_date := OKS_BILL_UTIL_PUB.Get_Enddate_Cal(

6412: l_sll_tbl(l_sll_tbl_index).sequence_no := l_sll_tbl(l_sll_tbl_index).sequence_no;
6413: l_sll_tbl(l_sll_tbl_index).start_date := l_sll_tbl(l_sll_tbl_index).start_date;
6414: l_sll_tbl(l_sll_tbl_index).end_date := l_line_rec.line_END_dt;
6415: l_sll_tbl(l_sll_tbl_index).level_periods := ceil(l_level_periods/l_sll_tbl(l_sll_tbl_index).uom_per_period);
6416: l_next_date := OKS_BILL_UTIL_PUB.Get_Enddate_Cal(
6417: p_start_date => l_sll_tbl(l_sll_tbl_index).start_date,
6418: p_uom_code => l_sll_tbl(l_sll_tbl_index).uom_code,
6419: p_duration => l_sll_tbl(l_sll_tbl_index).uom_per_period,
6420: p_level_periods => l_sll_tbl(l_sll_tbl_index).level_periods);

Line 6436: OKS_BILL_UTIL_PUB.get_seeded_timeunit(

6432:
6433: ELSE --existing logic in this else block
6434:
6435:
6436: OKS_BILL_UTIL_PUB.get_seeded_timeunit(
6437: p_timeunit => l_sll_tbl(l_sll_tbl_index).uom_code,
6438: x_return_status => x_return_status,
6439: x_quantity => l_uom_quantity ,
6440: x_timeunit => l_tce_code);

Line 6463: l_period_freq := OKS_BILL_UTIL_PUB.get_frequency

6459: -----errorout_ad('l_sll_start_date of new sll to be inserted = '|| l_sll_start_date);
6460:
6461: l_uom_qty := nvl(l_sll_tbl(l_sll_tbl_index).uom_per_period,1) * nvl(l_uom_quantity,1);
6462:
6463: l_period_freq := OKS_BILL_UTIL_PUB.get_frequency
6464: (p_tce_code => l_tce_code,
6465: p_fr_start_date => l_sll_start_date,
6466: p_fr_end_date => l_line_rec.line_END_dt,
6467: p_uom_quantity => l_uom_qty,

Line 6550: OKS_BILL_UTIL_PUB.get_seeded_timeunit(

6546: IF x_return_status <> 'S' THEN
6547: RAISE G_EXCEPTION_HALT_VALIDATION;
6548: END IF;
6549:
6550: OKS_BILL_UTIL_PUB.get_seeded_timeunit(
6551: p_timeunit => l_timeunit,
6552: x_return_status => x_return_status,
6553: x_quantity => l_uom_quantity ,
6554: x_timeunit => l_tce_code);

Line 6576: l_level_periods:=OKS_BILL_UTIL_PUB.Get_Periods(p_start_date => l_line_rec.line_start_dt,

6572: THEN
6573: IF l_price_uom IS NULL THEN
6574: l_price_uom := l_timeunit;
6575: END IF;
6576: l_level_periods:=OKS_BILL_UTIL_PUB.Get_Periods(p_start_date => l_line_rec.line_start_dt,
6577: p_end_date => l_line_rec.line_end_dt,
6578: p_uom_code => l_price_uom,
6579: p_period_start => l_period_start);
6580:

Line 6671: OKS_BILL_UTIL_PUB.delete_level_elements (

6667: IF l_strm_lvl_tbl_in.COUNT > 0 THEN
6668: FOR l_sll_ind IN l_strm_lvl_tbl_in.FIRST .. l_strm_lvl_tbl_in.LAST
6669: LOOP
6670:
6671: OKS_BILL_UTIL_PUB.delete_level_elements (
6672: p_api_version => l_api_version,
6673: p_rule_id => l_strm_lvl_tbl_in(l_sll_ind).id,
6674: p_init_msg_list => l_msg_list,
6675: x_msg_count => x_msg_count,

Line 6681: 'oks_bill_util_pub.delete_level_elements(x_return_status = '||x_return_status

6677: x_return_status => x_return_status );
6678:
6679: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
6680: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_dates_sll.del_last_sll',
6681: 'oks_bill_util_pub.delete_level_elements(x_return_status = '||x_return_status
6682: ||', sll id passed = '|| l_strm_lvl_tbl_in(l_sll_ind).id ||')');
6683: END IF;
6684:
6685:

Line 7060: OKS_BILL_UTIL_PUB.get_seeded_timeunit(

7056: IF x_return_status <> 'S' THEN
7057: RAISE G_EXCEPTION_HALT_VALIDATION;
7058: END IF;
7059:
7060: OKS_BILL_UTIL_PUB.get_seeded_timeunit(
7061: p_timeunit => l_timeunit,
7062: x_return_status => x_return_status,
7063: x_quantity => l_uom_quantity ,
7064: x_timeunit => l_tce_code);

Line 8153: OKS_BILL_UTIL_PUB.get_seeded_timeunit(

8149: END IF;
8150:
8151:
8152: IF l_bill_type = 'T' THEN
8153: OKS_BILL_UTIL_PUB.get_seeded_timeunit(
8154: p_timeunit => p_sll_tbl(l_line_sll_counter).uom,
8155: x_return_status => x_return_status,
8156: x_quantity => l_uom_quantity ,
8157: x_timeunit => l_tce_code);

Line 8214: OKS_BILL_UTIL_PUB.Get_next_bill_sch

8210: -- Date 09-MAY-2005
8211: -- Added two new parameters p_period_start and p_period_type
8212: -------------------------------------------------------------------------
8213: -- Start - Modified by PMALLARA - Bug #3992530
8214: OKS_BILL_UTIL_PUB.Get_next_bill_sch
8215: (p_api_version => l_api_version,
8216: x_return_status => x_return_status,
8217: x_msg_count => l_msg_count,
8218: x_msg_data => l_msg_data,

Line 8230: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_msg_data);

8226:
8227: -----errorout_ad('LEVEL ELEMENT NEXT CYCLE DATE passed from Get_next_bill_sch = ' || TO_CHAR(l_fnd_lvl_out_rec.next_cycle_date));
8228:
8229: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
8230: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_msg_data);
8231: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
8232: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
8233: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_msg_data);
8234: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 8233: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_msg_data);

8229: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
8230: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_msg_data);
8231: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
8232: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
8233: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_msg_data);
8234: RAISE OKC_API.G_EXCEPTION_ERROR;
8235: END IF;
8236:
8237:

Line 9636: OKS_BILL_UTIL_PUB.get_seeded_timeunit(

9632: -----------errorout_ad('COMING IN');
9633: ELSE
9634:
9635: IF p_billing_type = 'T' THEN
9636: OKS_BILL_UTIL_PUB.get_seeded_timeunit(
9637: p_timeunit => p_cp_sll_tbl(l_cp_sll_counter).uom,
9638: x_return_status => x_return_status,
9639: x_quantity => l_uom_quantity ,
9640: x_timeunit => l_tce_code);

Line 9757: OKS_BILL_UTIL_PUB.Get_Seeded_Timeunit

9753: ' result l_uom = ' || l_uom);
9754: END IF;
9755:
9756: END IF;
9757: OKS_BILL_UTIL_PUB.Get_Seeded_Timeunit
9758: (p_timeunit => p_cp_sll_tbl(l_cp_sll_counter).uom,
9759: x_return_status => x_return_status,
9760: x_quantity => l_uom_quantity ,
9761: x_timeunit => l_tce_code);

Line 9818: 'Calling oks_bill_util_pub.Get_next_bill_sch with parameters '

9814:
9815: -- Start - Modified by PMALLARA - Bug #3992530
9816: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
9817: fnd_log.string(fnd_log.level_procedure,G_MODULE_CURRENT||'.Create_cp_Lvl_elements.lvl_loop',
9818: 'Calling oks_bill_util_pub.Get_next_bill_sch with parameters '
9819: ||'period start = ' || p_period_start
9820: ||', period type = ' || p_period_type);
9821: END IF;
9822: OKS_BILL_UTIL_PUB.Get_next_bill_sch

Line 9822: OKS_BILL_UTIL_PUB.Get_next_bill_sch

9818: 'Calling oks_bill_util_pub.Get_next_bill_sch with parameters '
9819: ||'period start = ' || p_period_start
9820: ||', period type = ' || p_period_type);
9821: END IF;
9822: OKS_BILL_UTIL_PUB.Get_next_bill_sch
9823: (p_api_version => l_api_version,
9824: x_return_status => x_return_status,
9825: x_msg_count => l_msg_count,
9826: x_msg_data => l_msg_data,

Line 9836: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch l_fnd_next_cycle = ' || x_return_status);

9832: Strm_Start_Date => Strm_Start_Date);
9833: -- End - Modified by PMALLARA - Bug #3992530
9834:
9835:
9836: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch l_fnd_next_cycle = ' || x_return_status);
9837: -----errorout_ad('l_fnd_lvl_out_rec.next_cycle_date = ' || l_fnd_lvl_out_rec.next_cycle_date );
9838:
9839:
9840: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 11289: OKS_BILL_UTIL_PUB.Get_next_bill_sch

11285: -- Date 09-MAY-2005
11286: -- Added two new parameters p_period_start and p_period_type
11287: -------------------------------------------------------------------------
11288: -- Start - Modified by PMALLARA - Bug #3992530
11289: OKS_BILL_UTIL_PUB.Get_next_bill_sch
11290: (p_api_version => l_api_version,
11291: x_return_status => x_return_status,
11292: x_msg_count => l_msg_count,
11293: x_msg_data => l_msg_data,

Line 12263: OKS_BILL_UTIL_PUB.ADJUST_SPLIT_BILL_REC(p_old_cp_id => l_old_cp_rec.cp_id,

12259:
12260:
12261: ---add new bill records in billing tables
12262:
12263: OKS_BILL_UTIL_PUB.ADJUST_SPLIT_BILL_REC(p_old_cp_id => l_old_cp_rec.cp_id,
12264: p_new_cp_id => l_new_cp_rec.cp_id,
12265: p_currency_code => l_currency_code,
12266: p_rgp_id => NULL,
12267: p_old_cp_lvl_tbl => l_cp_old_bs_tbl,

Line 12276: 'oks_bill_util_pub.adjust_split_bill_rec(x_return_status = '||x_return_status

12272:
12273:
12274: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
12275: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_split_bill_sch.bill_rec',
12276: 'oks_bill_util_pub.adjust_split_bill_rec(x_return_status = '||x_return_status
12277: ||'old line id = ' || l_old_cp_rec.cp_id || ')');
12278: END IF;
12279:
12280: IF NVL(x_return_status,'!') <> OKC_API.G_RET_STS_SUCCESS THEN