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 2132: l_end_date := OKS_BILL_UTIL_PUB.get_enddate_cal

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

Line 3296: OKS_BILL_UTIL_PUB.get_seeded_timeunit(

3292: RETURN;
3293: END IF;
3294:
3295: IF l_bill_type = 'T' AND p_line_rec.lse_id = 46 THEN
3296: OKS_BILL_UTIL_PUB.get_seeded_timeunit(
3297: p_timeunit => p_sll_tbl(l_line_sll_counter).uom,
3298: x_return_status => x_return_status,
3299: x_quantity => l_uom_quantity ,
3300: x_timeunit => l_tce_code);

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

3300: x_timeunit => l_tce_code);
3301:
3302: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
3303: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.Create_Level_elements.seed_time',
3304: 'OKS_BILL_UTIL_PUB.get_seeded_timeunit(x_return_status = '||x_return_status
3305: ||', x_timeunit = ' || l_tce_code
3306: ||', x_quantity = '|| l_uom_quantity ||')');
3307: END IF;
3308:

Line 3339: OKS_BILL_UTIL_PUB.Get_Seeded_Timeunit

3335: RAISE G_EXCEPTION_HALT_VALIDATION;
3336: END IF;
3337: END IF; ---end of lse_id = 46
3338:
3339: OKS_BILL_UTIL_PUB.Get_Seeded_Timeunit
3340: (p_timeunit => p_sll_tbl(l_line_sll_counter).uom,
3341: x_return_status => x_return_status,
3342: x_quantity => l_uom_quantity ,
3343: x_timeunit => l_tce_code);

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

3368: l_fnd_lvl_in_rec.uom_per_period := p_sll_tbl(l_line_sll_counter).uom_Per_Period;
3369: -----errorout_ad(' p_Line_rec.line_start_dt :' || to_char(p_line_rec.line_start_dt));
3370: -----errorout_ad(' p_Line_rec.line_end_dt :' || to_char(p_line_rec.line_end_dt));
3371: -----errorout_ad(' l_line_amt :' || l_line_amt);
3372: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch for line passed period :' || to_char(l_fnd_lvl_in_rec.uom_per_period));
3373: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch for line passed uom :' || l_fnd_lvl_in_rec.uom);
3374: -----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));
3375:
3376: -------------------------------------------------------------------------

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

3369: -----errorout_ad(' p_Line_rec.line_start_dt :' || to_char(p_line_rec.line_start_dt));
3370: -----errorout_ad(' p_Line_rec.line_end_dt :' || to_char(p_line_rec.line_end_dt));
3371: -----errorout_ad(' l_line_amt :' || l_line_amt);
3372: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch for line passed period :' || to_char(l_fnd_lvl_in_rec.uom_per_period));
3373: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch for line passed uom :' || l_fnd_lvl_in_rec.uom);
3374: -----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));
3375:
3376: -------------------------------------------------------------------------
3377: -- Begin partial period computation logic

Line 3374: -----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));

3370: -----errorout_ad(' p_Line_rec.line_end_dt :' || to_char(p_line_rec.line_end_dt));
3371: -----errorout_ad(' l_line_amt :' || l_line_amt);
3372: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch for line passed period :' || to_char(l_fnd_lvl_in_rec.uom_per_period));
3373: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch for line passed uom :' || l_fnd_lvl_in_rec.uom);
3374: -----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));
3375:
3376: -------------------------------------------------------------------------
3377: -- Begin partial period computation logic
3378: -- Developer Mani Choudhary

Line 3384: 'Calling oks_bill_util_pub.Get_next_bill_sch with parameters '

3380: -- Added two new parameters p_period_start and p_period_type
3381: -- Start - Modified by PMALLARA - Bug #3992530
3382: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
3383: fnd_log.string(fnd_log.level_procedure,G_MODULE_CURRENT||'.Create_Level_elements.lvl_loop',
3384: 'Calling oks_bill_util_pub.Get_next_bill_sch with parameters '
3385: ||'period start = ' || p_period_start
3386: ||', period type = ' || p_period_type);
3387: END IF;
3388:

Line 3389: OKS_BILL_UTIL_PUB.Get_next_bill_sch

3385: ||'period start = ' || p_period_start
3386: ||', period type = ' || p_period_type);
3387: END IF;
3388:
3389: OKS_BILL_UTIL_PUB.Get_next_bill_sch
3390: (p_api_version => l_api_version,
3391: x_return_status => x_return_status,
3392: x_msg_count => l_msg_count,
3393: x_msg_data => l_msg_data,

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

3401:
3402:
3403: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
3404: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.Create_Level_elements.lvl_loop',
3405: 'oks_bill_util_pub.Get_next_bill_sch(x_return_status = '||x_return_status
3406: ||', next date = ' || l_fnd_lvl_out_rec.next_cycle_date
3407: ||', tuom per period = ' || l_fnd_lvl_in_rec.tuom_per_period
3408: ||', cycle_start_date = '|| l_next_cycle_dt ||')');
3409: END IF;

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

3411:
3412: -----errorout_ad('LEVEL ELEMENT NEXT CYCLE DATE passed from Get_next_bill_sch = ' || TO_CHAR(l_fnd_lvl_out_rec.next_cycle_date));
3413:
3414: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3415: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_msg_data);
3416: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3417: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3418: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_msg_data);
3419: RAISE OKC_API.G_EXCEPTION_ERROR;

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

3414: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3415: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_msg_data);
3416: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3417: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3418: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_msg_data);
3419: RAISE OKC_API.G_EXCEPTION_ERROR;
3420: END IF;
3421:
3422:

Line 3818: OKS_BILL_UTIL_PUB.Get_next_bill_sch

3814: -- Developer Mani Choudhary
3815: -- Date 09-MAY-2005
3816: -- Added two new parameters p_period_start and p_period_type
3817: -- Start - Modified by PMALLARA - Bug #3992530
3818: OKS_BILL_UTIL_PUB.Get_next_bill_sch
3819: (p_api_version => l_api_version,
3820: x_return_status => x_return_status,
3821: x_msg_count => l_msg_count,
3822: x_msg_data => l_msg_data,

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

3829: -- End - Modified by PMALLARA - Bug #3992530
3830:
3831: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
3832: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_hdr_level_elements.lvl_loop',
3833: 'oks_bill_util_pub.Get_next_bill_sch(x_return_status = '||x_return_status
3834: ||', next date = ' || l_fnd_lvl_out_rec.next_cycle_date
3835: ||', tuom per period = ' || l_fnd_lvl_in_rec.tuom_per_period
3836: ||', cycle_start_date = '|| l_next_cycle_dt ||')');
3837: END IF;

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

3838:
3839: -----errorout_ad('hdr Get_next_bill_sch status = ' || x_return_status);
3840:
3841: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3842: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_fnd_msg_data);
3843: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3844: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3845: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_fnd_msg_data);
3846: RAISE OKC_API.G_EXCEPTION_ERROR;

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

3841: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3842: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_fnd_msg_data);
3843: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3844: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3845: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_fnd_msg_data);
3846: RAISE OKC_API.G_EXCEPTION_ERROR;
3847: END IF;
3848:
3849:

Line 4474: oks_bill_util_pub.get_seeded_timeunit(

4470: -------------------------------------------------------------------------
4471: ELSE
4472: For i in 1 .. l_sll_num Loop
4473: l_uom_code := p_sll_prorated_tab(i).sll_tuom ;
4474: oks_bill_util_pub.get_seeded_timeunit(
4475: p_timeunit => l_uom_code ,
4476: x_return_status => l_return_status,
4477: x_quantity => l_uom_quantity,
4478: x_timeunit => l_tce_code);

Line 4909: l_frequency := OKS_BILL_UTIL_PUB.get_frequency

4905: ||', st-end dt = ' || p_line_start_date || '-' || p_line_end_date );
4906: END IF;
4907:
4908: If p_line_start_date > p_cycle_start_date then ---and l_start_date < l_next_billing_date Then
4909: l_frequency := OKS_BILL_UTIL_PUB.get_frequency
4910: (p_tce_code => p_tce_code,
4911: p_fr_end_date => p_line_end_date ,
4912: p_fr_start_date => p_line_start_date, --this LINE st dt
4913: p_uom_quantity => p_uom_quantity,

Line 4918: l_frequency := OKS_BILL_UTIL_PUB.get_frequency

4914: x_return_status => X_return_status);
4915:
4916:
4917: ELSE
4918: l_frequency := OKS_BILL_UTIL_PUB.get_frequency
4919: (p_tce_code => p_tce_code,
4920: p_fr_end_date => p_line_end_date ,
4921: p_fr_start_date => p_cycle_start_date, --this cycle st dt to find remaining period
4922: p_uom_quantity => p_uom_quantity,

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

4925: END IF;
4926:
4927: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
4928: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.get_constant_sll_amount.freq',
4929: 'oks_bill_util_pub.get_frequency(x_return_status = '||x_return_status
4930: ||', l_frequency = '|| l_frequency ||')');
4931: END IF;
4932:
4933: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then

Line 4977: x_period_freq := OKS_BILL_UTIL_PUB.get_frequency

4973:
4974: BEGIN
4975: x_return_status := OKC_API.G_RET_STS_SUCCESS;
4976: If p_line_start_date > p_cycle_start_date and p_line_start_date < P_next_billing_date Then
4977: x_period_freq := OKS_BILL_UTIL_PUB.get_frequency
4978: (p_tce_code => p_tce_code,
4979: p_fr_start_date => p_line_start_date,
4980: p_fr_end_date => p_next_billing_date - 1,
4981: p_uom_quantity => p_uom_quantity,

Line 4985: x_period_freq:= OKS_BILL_UTIL_PUB.get_frequency

4981: p_uom_quantity => p_uom_quantity,
4982: x_return_status => x_return_status);
4983:
4984: ElsiF( p_next_billing_date > p_line_end_date + 1) THEN
4985: x_period_freq:= OKS_BILL_UTIL_PUB.get_frequency
4986: (p_tce_code => p_tce_code,
4987: p_fr_end_date => p_line_end_date,
4988: p_fr_start_date => p_cycle_start_date,
4989: p_uom_quantity => p_uom_quantity,

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

4997:
4998:
4999: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
5000: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.get_period_frequency.freq',
5001: 'oks_bill_util_pub.get_frequency(x_return_status = '||x_return_status
5002: ||', x_period_freq = '|| x_period_freq ||')');
5003: END IF;
5004:
5005: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then

Line 5366: OKS_BILL_UTIL_PUB.Adjust_line_price(

5362: END IF;
5363: -----if the subline is update then chk if max_bill_dt = end date and update the price.
5364: IF nvl(p_cp_new,'Y') = 'N' AND l_cp_rec.cp_amt > 0 THEN
5365:
5366: OKS_BILL_UTIL_PUB.Adjust_line_price(
5367: p_top_line_id => p_top_line_id,
5368: p_sub_line_id => p_cp_line_id ,
5369: p_end_date => l_cp_rec.cp_end_dt,
5370: p_amount => l_cp_rec.cp_amt,

Line 5756: OKS_BILL_UTIL_PUB.Adjust_line_price(

5752:
5753:
5754:
5755: IF l_usage_type = 'NPR' THEN
5756: OKS_BILL_UTIL_PUB.Adjust_line_price(
5757: p_top_line_id => p_top_line_id,
5758: p_sub_line_id => NULL,
5759: p_end_date => NULL,
5760: p_amount => NULL,

Line 5771: OKS_BILL_UTIL_PUB.Adjust_line_price(

5767: END IF; ---- l_usage_type_csr data found chk
5768: Close l_usage_type_csr;
5769:
5770: ELSE --- LINE lse_id <> 12
5771: OKS_BILL_UTIL_PUB.Adjust_line_price(
5772: p_top_line_id => p_top_line_id,
5773: p_sub_line_id => NULL,
5774: p_end_date => NULL,
5775: p_amount => NULL,

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

5882: l_period_type IS NOT NULL AND
5883: l_period_start = 'CALENDAR'
5884: THEN
5885: -- IF(TRUNC(l_sll_start_date,'MM') = TRUNC(l_sll_start_date)) THEN
5886: l_level_periods:=OKS_BILL_UTIL_PUB.Get_Periods(p_start_date => l_line_rec.line_start_dt,
5887: p_end_date => TRUNC(l_sll_tbl(l_sll_tbl_index).End_date),
5888: p_uom_code => l_sll_tbl(l_sll_tbl_index).uom_code,
5889: p_period_start => l_period_start);
5890:

Line 5899: l_next_date := OKS_BILL_UTIL_PUB.Get_Enddate_Cal(

5895: l_sll_tbl(l_sll_tbl_index).sequence_no := l_sequence;
5896: l_sll_tbl(l_sll_tbl_index).start_date := l_line_rec.line_start_dt;
5897: l_sll_tbl(l_sll_tbl_index).end_date := TRUNC(l_sll_tbl(l_sll_tbl_index).End_date);
5898: l_sll_tbl(l_sll_tbl_index).level_periods := ceil(l_level_periods/l_sll_tbl(l_sll_tbl_index).uom_per_period);
5899: l_next_date := OKS_BILL_UTIL_PUB.Get_Enddate_Cal(
5900: p_start_date => l_sll_tbl(l_sll_tbl_index).start_date,
5901: p_uom_code => l_sll_tbl(l_sll_tbl_index).uom_code,
5902: p_duration => l_sll_tbl(l_sll_tbl_index).uom_per_period,
5903: p_level_periods => l_sll_tbl(l_sll_tbl_index).level_periods);

Line 5944: OKS_BILL_UTIL_PUB.get_seeded_timeunit(

5940: IF x_return_status <> 'S' THEN
5941: RAISE G_EXCEPTION_HALT_VALIDATION;
5942: END IF;
5943:
5944: OKS_BILL_UTIL_PUB.get_seeded_timeunit(
5945: p_timeunit => l_timeunit,
5946: x_return_status => x_return_status,
5947: x_quantity => l_uom_quantity ,
5948: x_timeunit => l_tce_code);

Line 5976: OKS_BILL_UTIL_PUB.get_seeded_timeunit(

5972:
5973: l_sll_tbl(0).uom_code := l_timeunit; */
5974: ----Commented the above code for bug 13799709
5975: /*Added for bug 14047785--enhaced bug for 13799709*/
5976: OKS_BILL_UTIL_PUB.get_seeded_timeunit(
5977: p_timeunit => l_sll_tbl(l_sll_tbl_index).uom_code,
5978: x_return_status => x_return_status,
5979: x_quantity => l_uom_quantity ,
5980: x_timeunit => l_tce_code);

Line 5999: l_period_freq := OKS_BILL_UTIL_PUB.get_frequency

5995:
5996:
5997: l_uom_qty := nvl(l_sll_tbl(l_sll_tbl_index).uom_per_period,1) * nvl(l_uom_quantity,1);
5998:
5999: l_period_freq := OKS_BILL_UTIL_PUB.get_frequency
6000: (p_tce_code => l_tce_code,
6001: p_fr_start_date => l_line_rec.line_start_dt,
6002: p_fr_end_date => TRUNC(l_sll_start_date) - 1,
6003: p_uom_quantity => l_uom_qty,

Line 6040: OKS_BILL_UTIL_PUB.get_seeded_timeunit(

6036: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
6037: RAISE OKC_API.G_EXCEPTION_ERROR;
6038: END IF;
6039:
6040: OKS_BILL_UTIL_PUB.get_seeded_timeunit(
6041: p_timeunit => l_timeunit,
6042: x_return_status => x_return_status,
6043: x_quantity => l_uom_quantity ,
6044: x_timeunit => l_tce_code);

Line 6048: l_period_freq := OKS_BILL_UTIL_PUB.get_frequency

6044: x_timeunit => l_tce_code);
6045:
6046: l_uom_qty := nvl(l_duration,1) * nvl(l_uom_quantity,1);
6047:
6048: l_period_freq := OKS_BILL_UTIL_PUB.get_frequency
6049: (p_tce_code => l_tce_code,
6050: p_fr_start_date => l_line_rec.line_start_dt,
6051: p_fr_end_date => l_sll_start_date - 1,
6052: p_uom_quantity => l_uom_qty,

Line 6114: l_next_date := OKS_BILL_UTIL_PUB.Get_Enddate_Cal(

6110: IF l_period_start IS NOT NULL AND
6111: l_period_type IS NOT NULL AND
6112: l_period_start = 'CALENDAR'
6113: THEN
6114: l_next_date := OKS_BILL_UTIL_PUB.Get_Enddate_Cal(
6115: p_start_date => l_sll_tbl(l_sll_tbl_index).start_date,
6116: p_uom_code => l_sll_tbl(l_sll_tbl_index).uom_code,
6117: p_duration => l_sll_tbl(l_sll_tbl_index).uom_per_period,
6118: p_level_periods => l_sll_tbl(l_sll_tbl_index).level_periods);

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

6239: IF l_period_start IS NOT NULL AND
6240: l_period_type IS NOT NULL AND
6241: l_period_start = 'CALENDAR'
6242: THEN
6243: l_level_periods:=OKS_BILL_UTIL_PUB.Get_Periods(p_start_date => l_line_rec.line_start_dt,
6244: p_end_date => l_sll_end_date,
6245: p_uom_code => l_sll_tbl(l_sll_tbl_index).uom_code,
6246: p_period_start => l_period_start);
6247:

Line 6251: l_next_date := OKS_BILL_UTIL_PUB.Get_Enddate_Cal(

6247:
6248: l_sll_tbl(l_sll_tbl_index).start_date := l_line_rec.line_start_dt;
6249: l_sll_tbl(l_sll_tbl_index).end_date := l_sll_end_date;
6250: l_sll_tbl(l_sll_tbl_index).level_periods := ceil(l_level_periods/l_sll_tbl(l_sll_tbl_index).uom_per_period);
6251: l_next_date := OKS_BILL_UTIL_PUB.Get_Enddate_Cal(
6252: p_start_date => l_sll_tbl(l_sll_tbl_index).start_date,
6253: p_uom_code => l_sll_tbl(l_sll_tbl_index).uom_code,
6254: p_duration => l_sll_tbl(l_sll_tbl_index).uom_per_period,
6255: p_level_periods => l_sll_tbl(l_sll_tbl_index).level_periods);

Line 6279: OKS_BILL_UTIL_PUB.get_seeded_timeunit(

6275: -----errorout_ad('l_sll_end_date = ' || l_sll_end_date);
6276:
6277: ----find out the periods between line start date and SLL end date
6278:
6279: OKS_BILL_UTIL_PUB.get_seeded_timeunit(
6280: p_timeunit => l_sll_tbl(l_sll_tbl_index).uom_code,
6281: x_return_status => x_return_status,
6282: x_quantity => l_uom_quantity ,
6283: x_timeunit => l_tce_code);

Line 6312: l_period_freq := OKS_BILL_UTIL_PUB.get_frequency

6308: -- END IF;
6309:
6310: -- ELSE ----not day
6311:
6312: l_period_freq := OKS_BILL_UTIL_PUB.get_frequency
6313: (p_tce_code => l_tce_code,
6314: p_fr_start_date => l_line_rec.line_start_dt,
6315: p_fr_end_date => l_sll_end_date,
6316: p_uom_quantity => l_uom_quantity,

Line 6359: l_next_date := OKS_BILL_UTIL_PUB.Get_Enddate_Cal(

6355: IF l_period_start IS NOT NULL AND
6356: l_period_type IS NOT NULL AND
6357: l_period_start = 'CALENDAR'
6358: THEN
6359: l_next_date := OKS_BILL_UTIL_PUB.Get_Enddate_Cal(
6360: p_start_date => l_sll_tbl(l_sll_tbl_index).start_date,
6361: p_uom_code => l_sll_tbl(l_sll_tbl_index).uom_code,
6362: p_duration => l_sll_tbl(l_sll_tbl_index).uom_per_period,
6363: p_level_periods => l_sll_tbl(l_sll_tbl_index).level_periods);

Line 6428: OKS_BILL_UTIL_PUB.get_seeded_timeunit(

6424: IF x_return_status <> 'S' THEN
6425: RAISE G_EXCEPTION_HALT_VALIDATION;
6426: END IF;
6427:
6428: OKS_BILL_UTIL_PUB.get_seeded_timeunit(
6429: p_timeunit => l_timeunit,
6430: x_return_status => x_return_status,
6431: x_quantity => l_uom_quantity ,
6432: x_timeunit => l_tce_code);

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

6450: THEN
6451: IF l_price_uom IS NULL THEN
6452: l_price_uom := l_timeunit;
6453: END IF;
6454: l_level_periods:=OKS_BILL_UTIL_PUB.Get_Periods(p_start_date => l_line_rec.line_start_dt,
6455: p_end_date => l_line_rec.line_end_dt,
6456: p_uom_code => l_price_uom,
6457: p_period_start => l_period_start);
6458:

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

6542: IF l_period_start IS NOT NULL AND
6543: l_period_type IS NOT NULL AND
6544: l_period_start = 'CALENDAR'
6545: THEN
6546: l_level_periods:=OKS_BILL_UTIL_PUB.Get_Periods(p_start_date => l_sll_tbl(l_sll_tbl_index).start_date,
6547: p_end_date => l_line_rec.line_END_dt,
6548: p_uom_code => l_sll_tbl(l_sll_tbl_index).uom_code,
6549: p_period_start => l_period_start);
6550:

Line 6558: l_next_date := OKS_BILL_UTIL_PUB.Get_Enddate_Cal(

6554: l_sll_tbl(l_sll_tbl_index).sequence_no := l_sll_tbl(l_sll_tbl_index).sequence_no;
6555: l_sll_tbl(l_sll_tbl_index).start_date := l_sll_tbl(l_sll_tbl_index).start_date;
6556: l_sll_tbl(l_sll_tbl_index).end_date := l_line_rec.line_END_dt;
6557: l_sll_tbl(l_sll_tbl_index).level_periods := ceil(l_level_periods/l_sll_tbl(l_sll_tbl_index).uom_per_period);
6558: l_next_date := OKS_BILL_UTIL_PUB.Get_Enddate_Cal(
6559: p_start_date => l_sll_tbl(l_sll_tbl_index).start_date,
6560: p_uom_code => l_sll_tbl(l_sll_tbl_index).uom_code,
6561: p_duration => l_sll_tbl(l_sll_tbl_index).uom_per_period,
6562: p_level_periods => l_sll_tbl(l_sll_tbl_index).level_periods);

Line 6578: OKS_BILL_UTIL_PUB.get_seeded_timeunit(

6574:
6575: ELSE --existing logic in this else block
6576:
6577:
6578: OKS_BILL_UTIL_PUB.get_seeded_timeunit(
6579: p_timeunit => l_sll_tbl(l_sll_tbl_index).uom_code,
6580: x_return_status => x_return_status,
6581: x_quantity => l_uom_quantity ,
6582: x_timeunit => l_tce_code);

Line 6605: l_period_freq := OKS_BILL_UTIL_PUB.get_frequency

6601: -----errorout_ad('l_sll_start_date of new sll to be inserted = '|| l_sll_start_date);
6602:
6603: l_uom_qty := nvl(l_sll_tbl(l_sll_tbl_index).uom_per_period,1) * nvl(l_uom_quantity,1);
6604:
6605: l_period_freq := OKS_BILL_UTIL_PUB.get_frequency
6606: (p_tce_code => l_tce_code,
6607: p_fr_start_date => l_sll_start_date,
6608: p_fr_end_date => l_line_rec.line_END_dt,
6609: p_uom_quantity => l_uom_qty,

Line 6666: OKS_BILL_UTIL_PUB.get_seeded_timeunit(

6662: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
6663: RAISE OKC_API.G_EXCEPTION_ERROR;
6664: END IF;
6665:
6666: OKS_BILL_UTIL_PUB.get_seeded_timeunit(
6667: p_timeunit => l_timeunit,
6668: x_return_status => x_return_status,
6669: x_quantity => l_uom_quantity ,
6670: x_timeunit => l_tce_code);

Line 6674: l_period_freq := OKS_BILL_UTIL_PUB.get_frequency

6670: x_timeunit => l_tce_code);
6671:
6672: l_uom_qty := nvl(l_duration,1) * nvl(l_uom_quantity,1);
6673:
6674: l_period_freq := OKS_BILL_UTIL_PUB.get_frequency
6675: (p_tce_code => l_tce_code,
6676: p_fr_start_date => l_sll_start_date,
6677: p_fr_end_date => l_line_rec.line_END_dt,
6678: p_uom_quantity => l_uom_qty,

Line 6751: OKS_BILL_UTIL_PUB.get_seeded_timeunit(

6747: IF x_return_status <> 'S' THEN
6748: RAISE G_EXCEPTION_HALT_VALIDATION;
6749: END IF;
6750:
6751: OKS_BILL_UTIL_PUB.get_seeded_timeunit(
6752: p_timeunit => l_timeunit,
6753: x_return_status => x_return_status,
6754: x_quantity => l_uom_quantity ,
6755: x_timeunit => l_tce_code);

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

6773: THEN
6774: IF l_price_uom IS NULL THEN
6775: l_price_uom := l_timeunit;
6776: END IF;
6777: l_level_periods:=OKS_BILL_UTIL_PUB.Get_Periods(p_start_date => l_line_rec.line_start_dt,
6778: p_end_date => l_line_rec.line_end_dt,
6779: p_uom_code => l_price_uom,
6780: p_period_start => l_period_start);
6781:

Line 6872: OKS_BILL_UTIL_PUB.delete_level_elements (

6868: IF l_strm_lvl_tbl_in.COUNT > 0 THEN
6869: FOR l_sll_ind IN l_strm_lvl_tbl_in.FIRST .. l_strm_lvl_tbl_in.LAST
6870: LOOP
6871:
6872: OKS_BILL_UTIL_PUB.delete_level_elements (
6873: p_api_version => l_api_version,
6874: p_rule_id => l_strm_lvl_tbl_in(l_sll_ind).id,
6875: p_init_msg_list => l_msg_list,
6876: x_msg_count => x_msg_count,

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

6878: x_return_status => x_return_status );
6879:
6880: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
6881: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_dates_sll.del_last_sll',
6882: 'oks_bill_util_pub.delete_level_elements(x_return_status = '||x_return_status
6883: ||', sll id passed = '|| l_strm_lvl_tbl_in(l_sll_ind).id ||')');
6884: END IF;
6885:
6886:

Line 7272: OKS_BILL_UTIL_PUB.get_seeded_timeunit(

7268: IF x_return_status <> 'S' THEN
7269: RAISE G_EXCEPTION_HALT_VALIDATION;
7270: END IF;
7271:
7272: OKS_BILL_UTIL_PUB.get_seeded_timeunit(
7273: p_timeunit => l_timeunit,
7274: x_return_status => x_return_status,
7275: x_quantity => l_uom_quantity ,
7276: x_timeunit => l_tce_code);

Line 8366: OKS_BILL_UTIL_PUB.get_seeded_timeunit(

8362: END IF;
8363:
8364:
8365: IF l_bill_type = 'T' THEN
8366: OKS_BILL_UTIL_PUB.get_seeded_timeunit(
8367: p_timeunit => p_sll_tbl(l_line_sll_counter).uom,
8368: x_return_status => x_return_status,
8369: x_quantity => l_uom_quantity ,
8370: x_timeunit => l_tce_code);

Line 8427: OKS_BILL_UTIL_PUB.Get_next_bill_sch

8423: -- Date 09-MAY-2005
8424: -- Added two new parameters p_period_start and p_period_type
8425: -------------------------------------------------------------------------
8426: -- Start - Modified by PMALLARA - Bug #3992530
8427: OKS_BILL_UTIL_PUB.Get_next_bill_sch
8428: (p_api_version => l_api_version,
8429: x_return_status => x_return_status,
8430: x_msg_count => l_msg_count,
8431: x_msg_data => l_msg_data,

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

8439:
8440: -----errorout_ad('LEVEL ELEMENT NEXT CYCLE DATE passed from Get_next_bill_sch = ' || TO_CHAR(l_fnd_lvl_out_rec.next_cycle_date));
8441:
8442: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
8443: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_msg_data);
8444: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
8445: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
8446: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_msg_data);
8447: RAISE OKC_API.G_EXCEPTION_ERROR;

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

8442: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
8443: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_msg_data);
8444: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
8445: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
8446: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_msg_data);
8447: RAISE OKC_API.G_EXCEPTION_ERROR;
8448: END IF;
8449:
8450:

Line 9853: OKS_BILL_UTIL_PUB.get_seeded_timeunit(

9849: -----------errorout_ad('COMING IN');
9850: ELSE
9851:
9852: IF p_billing_type = 'T' THEN
9853: OKS_BILL_UTIL_PUB.get_seeded_timeunit(
9854: p_timeunit => p_cp_sll_tbl(l_cp_sll_counter).uom,
9855: x_return_status => x_return_status,
9856: x_quantity => l_uom_quantity ,
9857: x_timeunit => l_tce_code);

Line 9974: OKS_BILL_UTIL_PUB.Get_Seeded_Timeunit

9970: ' result l_uom = ' || l_uom);
9971: END IF;
9972:
9973: END IF;
9974: OKS_BILL_UTIL_PUB.Get_Seeded_Timeunit
9975: (p_timeunit => p_cp_sll_tbl(l_cp_sll_counter).uom,
9976: x_return_status => x_return_status,
9977: x_quantity => l_uom_quantity ,
9978: x_timeunit => l_tce_code);

Line 10035: 'Calling oks_bill_util_pub.Get_next_bill_sch with parameters '

10031:
10032: -- Start - Modified by PMALLARA - Bug #3992530
10033: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
10034: fnd_log.string(fnd_log.level_procedure,G_MODULE_CURRENT||'.Create_cp_Lvl_elements.lvl_loop',
10035: 'Calling oks_bill_util_pub.Get_next_bill_sch with parameters '
10036: ||'period start = ' || p_period_start
10037: ||', period type = ' || p_period_type);
10038: END IF;
10039: OKS_BILL_UTIL_PUB.Get_next_bill_sch

Line 10039: OKS_BILL_UTIL_PUB.Get_next_bill_sch

10035: 'Calling oks_bill_util_pub.Get_next_bill_sch with parameters '
10036: ||'period start = ' || p_period_start
10037: ||', period type = ' || p_period_type);
10038: END IF;
10039: OKS_BILL_UTIL_PUB.Get_next_bill_sch
10040: (p_api_version => l_api_version,
10041: x_return_status => x_return_status,
10042: x_msg_count => l_msg_count,
10043: x_msg_data => l_msg_data,

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

10049: Strm_Start_Date => Strm_Start_Date);
10050: -- End - Modified by PMALLARA - Bug #3992530
10051:
10052:
10053: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch l_fnd_next_cycle = ' || x_return_status);
10054: -----errorout_ad('l_fnd_lvl_out_rec.next_cycle_date = ' || l_fnd_lvl_out_rec.next_cycle_date );
10055:
10056:
10057: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 11532: OKS_BILL_UTIL_PUB.Get_next_bill_sch

11528: -- Date 09-MAY-2005
11529: -- Added two new parameters p_period_start and p_period_type
11530: -------------------------------------------------------------------------
11531: -- Start - Modified by PMALLARA - Bug #3992530
11532: OKS_BILL_UTIL_PUB.Get_next_bill_sch
11533: (p_api_version => l_api_version,
11534: x_return_status => x_return_status,
11535: x_msg_count => l_msg_count,
11536: x_msg_data => l_msg_data,

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

12525:
12526:
12527: ---add new bill records in billing tables
12528:
12529: OKS_BILL_UTIL_PUB.ADJUST_SPLIT_BILL_REC(p_old_cp_id => l_old_cp_rec.cp_id,
12530: p_new_cp_id => l_new_cp_rec.cp_id,
12531: p_currency_code => l_currency_code,
12532: p_rgp_id => NULL,
12533: p_old_cp_lvl_tbl => l_cp_old_bs_tbl,

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

12538:
12539:
12540: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
12541: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_split_bill_sch.bill_rec',
12542: 'oks_bill_util_pub.adjust_split_bill_rec(x_return_status = '||x_return_status
12543: ||'old line id = ' || l_old_cp_rec.cp_id || ')');
12544: END IF;
12545:
12546: IF NVL(x_return_status,'!') <> OKC_API.G_RET_STS_SUCCESS THEN

Line 13110: l_fnd_lvl_in_rec oks_bill_util_pub.bill_det_inp_rec;

13106: l_return_status varchar2(10);
13107: l_tce_code VARCHAR2(100);
13108: l_uom_quantity NUMBER;
13109: l_remaining_amt NUMBER;
13110: l_fnd_lvl_in_rec oks_bill_util_pub.bill_det_inp_rec;
13111: l_fnd_lvl_out_rec oks_bill_util_pub.bill_sch_rec;
13112: Strm_Start_Date DATE;
13113: l_quantity NUMBER;
13114: l_lvl_amt NUMBER;

Line 13111: l_fnd_lvl_out_rec oks_bill_util_pub.bill_sch_rec;

13107: l_tce_code VARCHAR2(100);
13108: l_uom_quantity NUMBER;
13109: l_remaining_amt NUMBER;
13110: l_fnd_lvl_in_rec oks_bill_util_pub.bill_det_inp_rec;
13111: l_fnd_lvl_out_rec oks_bill_util_pub.bill_sch_rec;
13112: Strm_Start_Date DATE;
13113: l_quantity NUMBER;
13114: l_lvl_amt NUMBER;
13115: --l_adjusted_amt NUMBER;

Line 13285: OKS_BILL_UTIL_PUB.get_seeded_timeunit(

13281: END IF;
13282: END IF;
13283:
13284:
13285: OKS_BILL_UTIL_PUB.get_seeded_timeunit(
13286: p_timeunit => l_timeunit,
13287: x_return_status => l_return_status,
13288: x_quantity => l_uom_quantity ,
13289: x_timeunit => l_tce_code);

Line 13409: 'Calling oks_bill_util_pub.Get_next_bill_sch with parameters '

13405: l_fnd_lvl_in_rec.uom_per_period := l_level_periods;
13406:
13407: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
13408: fnd_log.string(fnd_log.level_procedure,G_MODULE_CURRENT||'.Get_Billed_Amount',
13409: 'Calling oks_bill_util_pub.Get_next_bill_sch with parameters '
13410: ||'period start = ' || l_period_start
13411: ||', period type = ' || l_period_type);
13412: END IF;
13413:

Line 13416: OKS_BILL_UTIL_PUB.Get_next_bill_sch

13412: END IF;
13413:
13414: --Dbms_Output.put_line('l_fnd_lvl_in_rec.line_start_date - '||l_fnd_lvl_in_rec.line_start_date);
13415:
13416: OKS_BILL_UTIL_PUB.Get_next_bill_sch
13417: (p_api_version => l_api_version,
13418: x_return_status => l_return_status,
13419: x_msg_count => l_msg_count,
13420: x_msg_data => l_msg_data,