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 OKC_TIME_UTIL_PUB

Line 466: okc_time_util_pub.get_duration(lin_det_rec.start_date,p_end_date,l_duration,l_uom,x_return_status);

462: Close line_dtl_csr;
463:
464: --Fix for bug#5623498 unit price will be recalculated based on
465: --duration based uom if pricelist is not present
466: okc_time_util_pub.get_duration(lin_det_rec.start_date,p_end_date,l_duration,l_uom,x_return_status);
467: --errorout_ad(' l_uom '||l_uom);
468: --errorout_ad(' l_duration '||l_duration);
469: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
470: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Unit_Price_Per_Uom.product_pricing.price_uom_is_null',

Line 471: 'after calling okc_time_util_pub.get_duration '

467: --errorout_ad(' l_uom '||l_uom);
468: --errorout_ad(' l_duration '||l_duration);
469: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
470: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Unit_Price_Per_Uom.product_pricing.price_uom_is_null',
471: 'after calling okc_time_util_pub.get_duration '
472: ||' result l_duration = ' || l_duration||',l_uom = '||l_uom);
473: END IF;
474:
475:

Line 2141: l_end_date := OKC_TIME_UTIL_PUB.get_enddate(

2137:
2138: ELSE
2139: --Existing Logic for calculating SLL end date
2140:
2141: l_end_date := OKC_TIME_UTIL_PUB.get_enddate(
2142: l_start_date,
2143: p_strm_lvl_tbl(l_tbl_count).uom_code,
2144: (p_strm_lvl_tbl(l_tbl_count).level_periods * p_strm_lvl_tbl(l_tbl_count).uom_per_period));
2145:

Line 2884: l_element_end_dt := OKC_TIME_UTIL_PUB.get_enddate

2880: l_element_end_dt := x_top_line_bs(l_tbs_ind ).DATE_end;
2881:
2882: ELSE
2883:
2884: l_element_end_dt := OKC_TIME_UTIL_PUB.get_enddate
2885: (x_top_line_bs(l_tbs_ind ).DATE_START,
2886: p_uom,
2887: p_uom_Per_Period);
2888: END IF;

Line 3253: l_next_cycle_dt := OKC_TIME_UTIL_PUB.get_enddate

3249: IF l_line_sll_counter + 1 <= p_sll_tbl.LAST THEN
3250: l_next_cycle_dt := TRUNC(p_sll_tbl(l_line_sll_counter + 1).dt_start);
3251: ELSE
3252:
3253: l_next_cycle_dt := OKC_TIME_UTIL_PUB.get_enddate
3254: (TRUNC(p_sll_tbl(l_line_sll_counter).dt_start),
3255: p_sll_tbl(l_line_sll_counter).uom,
3256: (p_sll_tbl(l_line_sll_counter).uom_Per_Period *
3257: p_sll_tbl(l_line_sll_counter).level_period ));

Line 3270: L_next_cycle_dt := OKC_TIME_UTIL_PUB.get_enddate

3266: -----errorout_ad('uom = ' || p_sll_tbl(l_line_sll_counter).uom_Per_Period);
3267: IF L_next_cycle_dt IS null THEN
3268:
3269:
3270: L_next_cycle_dt := OKC_TIME_UTIL_PUB.get_enddate
3271: (l_last_cycle_dt,
3272: p_sll_tbl(l_line_sll_counter).uom,
3273: p_sll_tbl(l_line_sll_counter).uom_Per_Period);
3274:

Line 5285: l_sll_tbl(l_index).end_Date := OKC_TIME_UTIL_PUB.get_enddate(

5281: l_sll_tbl(l_index).end_Date := l_Line_SlL_rec.end_Date;
5282: ELSE
5283: l_update_required := 'Y';
5284:
5285: l_sll_tbl(l_index).end_Date := OKC_TIME_UTIL_PUB.get_enddate(
5286: l_Line_SlL_rec.Start_Date,
5287: l_Line_SlL_rec.uom_code,
5288: (l_Line_SlL_rec.level_periods *
5289: l_Line_SlL_rec.uom_per_period));

Line 5800: l_sll_tbl(l_index).end_Date := OKC_TIME_UTIL_PUB.get_enddate(

5796: IF l_Line_SlL_rec.end_Date IS NOT NULL THEN
5797: l_sll_tbl(l_index).end_Date := l_Line_SlL_rec.end_Date;
5798: ELSE
5799: l_update_end_date := 'Y';
5800: l_sll_tbl(l_index).end_Date := OKC_TIME_UTIL_PUB.get_enddate(
5801: l_Line_SlL_rec.Start_Date,
5802: l_Line_SlL_rec.uom_code,
5803: l_Line_SlL_rec.level_periods * l_Line_SlL_rec.uom_per_period);
5804: END IF;

Line 5921: /* OKC_TIME_UTIL_PUB.get_duration(

5917:
5918: ELSE --period start and period type are null
5919: --existing logic
5920: ----Commented the above code for bug 13799709
5921: /* OKC_TIME_UTIL_PUB.get_duration(
5922: p_start_date => l_line_rec.line_start_dt,
5923: p_end_date => l_sll_start_date - 1,
5924: x_duration => l_duration,
5925: x_timeunit => l_timeunit,

Line 5932: 'okc_time_util_pub.get_duration(x_return_status = '||x_return_status

5928: --mchoudha bug#5076095 added to_char for the dates in the following
5929: --fnd_log statement
5930: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
5931: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.cascade_dates_sll.sll_duration',
5932: 'okc_time_util_pub.get_duration(x_return_status = '||x_return_status
5933: ||', end date in MM/DD/YYYY HH24:MI:SS = ' || to_char(l_sll_start_date - 1,'MM/DD/YYYY HH24:MI:SS')
5934: ||', st date MM/DD/YYYY HH24:MI:SS ='|| to_char(l_line_rec.line_start_dt,'MM/DD/YYYY HH24:MI:SS')
5935: ||', returned timeunit and duration = ' ||l_duration || '-' || l_timeunit ||')');
5936: END IF;

Line 5952: 'okc_time_util_pub.get_seeded_timeunit(x_return_status = '||x_return_status

5948: x_timeunit => l_tce_code);
5949:
5950: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
5951: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.cascade_dates_sll.seeded',
5952: 'okc_time_util_pub.get_seeded_timeunit(x_return_status = '||x_return_status
5953: ||', returned timeunit and qty = ' ||l_tce_code || '-' || l_uom_quantity ||')');
5954: END IF;
5955:
5956: l_sequence := l_sll_tbl(l_sll_tbl_index).sequence_no - 1;

Line 5984: 'okc_time_util_pub.get_seeded_timeunit(x_return_status = '||x_return_status

5980: x_timeunit => l_tce_code);
5981:
5982: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
5983: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.cascade_dates_sll.seeded',
5984: 'okc_time_util_pub.get_seeded_timeunit(x_return_status = '||x_return_status
5985: ||', returned timeunit and qty = ' ||l_tce_code || '-' || l_uom_quantity ||')');
5986: END IF;
5987:
5988: l_sequence := l_sll_tbl(l_sll_tbl_index).sequence_no - 1;

Line 6013: l_end_date := OKC_TIME_UTIL_PUB.get_enddate(

6009:
6010: l_period_freq := ceil(l_period_freq);
6011:
6012:
6013: l_end_date := OKC_TIME_UTIL_PUB.get_enddate(
6014: l_line_rec.line_start_dt,
6015: l_sll_tbl(l_sll_tbl_index).uom_code,
6016: (l_sll_tbl(l_sll_tbl_index).uom_per_period * l_period_freq ));
6017:

Line 6027: OKC_TIME_UTIL_PUB.get_duration(

6023: If l_end_date <> TRUNC(l_sll_start_date) - 1 then
6024:
6025: l_sll_tbl(0).end_date := TRUNC(l_sll_start_date) - 1;
6026:
6027: OKC_TIME_UTIL_PUB.get_duration(
6028: p_start_date => l_line_rec.line_start_dt,
6029: p_end_date => l_sll_start_date - 1,
6030: x_duration => l_duration,
6031: x_timeunit => l_timeunit,

Line 6068: 'After okc_time_util_pub.get_frequency(x_return_status = '||x_return_status

6064:
6065: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6066:
6067: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.create_dates_sll.st_end_seed',
6068: 'After okc_time_util_pub.get_frequency(x_return_status = '||x_return_status
6069: ||', l_period_freq = '|| l_period_freq
6070: ||', l_duration = ' || l_duration ||',l_timeunit = '||l_timeunit ||')');
6071:
6072: END IF;

Line 6122: l_next_date := OKC_TIME_UTIL_PUB.get_enddate(

6118: p_level_periods => l_sll_tbl(l_sll_tbl_index).level_periods);
6119:
6120: ELSE
6121: --existing logic
6122: l_next_date := OKC_TIME_UTIL_PUB.get_enddate(
6123: l_sll_tbl(l_sll_tbl_index).start_date,
6124: l_sll_tbl(l_sll_tbl_index).uom_code,
6125: (l_sll_tbl(l_sll_tbl_index).level_periods * l_sll_tbl(l_sll_tbl_index).uom_per_period));
6126: END IF;

Line 6267: l_sll_end_date := OKC_TIME_UTIL_PUB.get_enddate(

6263: IF l_sll_tbl_index < l_sll_tbl.LAST THEN
6264: l_sll_end_date := l_sll_tbl(l_sll_tbl_index + 1).start_date + 1;
6265:
6266: ELSE
6267: l_sll_end_date := OKC_TIME_UTIL_PUB.get_enddate(
6268: l_sll_tbl(l_sll_tbl_index).start_date,
6269: l_sll_tbl(l_sll_tbl_index).uom_code,
6270: (l_sll_tbl(l_sll_tbl_index).level_periods * l_sll_tbl(l_sll_tbl_index).uom_per_period));
6271: END IF; --- chk for last sll

Line 6287: 'okc_time_util_pub.get_seeded_timeunit(x_return_status = '||x_return_status

6283: x_timeunit => l_tce_code);
6284:
6285: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
6286: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.cascade_dates_sll.seed',
6287: 'okc_time_util_pub.get_seeded_timeunit(x_return_status = '||x_return_status
6288: ||', returned timeunit and qty = ' ||l_tce_code || '-' || l_uom_quantity ||')');
6289: END IF;
6290:
6291: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

Line 6374: l_next_date := OKC_TIME_UTIL_PUB.get_enddate(

6370:
6371:
6372: ELSE
6373: --Existing logic
6374: l_next_date := OKC_TIME_UTIL_PUB.get_enddate(
6375: l_sll_tbl(l_sll_tbl_index).start_date,
6376: l_sll_tbl(l_sll_tbl_index).uom_code,
6377: (l_sll_tbl(l_sll_tbl_index).uom_per_period * l_sll_tbl(l_sll_tbl_index).level_periods));
6378:

Line 6410: OKC_TIME_UTIL_PUB.get_duration(

6406: END IF;
6407:
6408:
6409:
6410: OKC_TIME_UTIL_PUB.get_duration(
6411: p_start_date => l_line_rec.line_start_dt,
6412: p_end_date => l_line_rec.line_end_dt,
6413: x_duration => l_duration,
6414: x_timeunit => l_timeunit,

Line 6419: 'okc_time_util_pub.get_duration(x_return_status = '||x_return_status

6415: x_return_status => x_return_status);
6416:
6417: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
6418: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_dates_sll.duration',
6419: 'okc_time_util_pub.get_duration(x_return_status = '||x_return_status
6420: ||', l_duration = '|| l_duration
6421: ||', l_timeunit = ' || l_timeunit ||')');
6422: END IF;
6423:

Line 6436: 'okc_time_util_pub.get_seeded_timeunit(x_return_status = '||x_return_status

6432: x_timeunit => l_tce_code);
6433:
6434: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
6435: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_dates_sll.call_seed',
6436: 'okc_time_util_pub.get_seeded_timeunit(x_return_status = '||x_return_status
6437: ||', l_uom_quantity = '|| l_uom_quantity
6438: ||', l_tce_code = ' || l_tce_code ||')');
6439: END IF;
6440:

Line 6586: 'okc_time_util_pub.get_seeded_timeunit(x_return_status = '||x_return_status

6582: x_timeunit => l_tce_code);
6583:
6584: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
6585: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_dates_sll.st_end_seed',
6586: 'okc_time_util_pub.get_seeded_timeunit(x_return_status = '||x_return_status
6587: ||', l_uom_quantity = '|| l_uom_quantity
6588: ||', l_tce_code = ' || l_tce_code ||')');
6589: END IF;
6590:

Line 6641: l_sll_tbl(l_sll_tbl_index + 1).end_date := OKC_TIME_UTIL_PUB.get_enddate(

6637: l_sll_tbl(l_sll_tbl_index + 1).uom_per_period := l_sll_tbl(l_sll_tbl_index).uom_per_period;
6638: l_sll_tbl(l_sll_tbl_index + 1).uom_code := l_sll_tbl(l_sll_tbl_index).uom_code;
6639:
6640:
6641: l_sll_tbl(l_sll_tbl_index + 1).end_date := OKC_TIME_UTIL_PUB.get_enddate(
6642: l_sll_start_date,
6643: l_sll_tbl(l_sll_tbl_index).uom_code,
6644: l_period_freq * l_sll_tbl(l_sll_tbl_index).uom_per_period);
6645:

Line 6653: OKC_TIME_UTIL_PUB.get_duration(

6649: l_sll_tbl(l_sll_tbl_index + 1).end_date :=l_line_rec.line_END_dt;
6650:
6651:
6652:
6653: OKC_TIME_UTIL_PUB.get_duration(
6654: p_start_date => l_sll_tbl(l_sll_tbl_index + 1).start_date,
6655: p_end_date => l_sll_tbl(l_sll_tbl_index + 1).end_date,
6656: x_duration => l_duration,
6657: x_timeunit => l_timeunit,

Line 6694: 'After okc_time_util_pub.get_frequency(x_return_status = '||x_return_status

6690:
6691: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6692:
6693: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.create_dates_sll.st_end_seed',
6694: 'After okc_time_util_pub.get_frequency(x_return_status = '||x_return_status
6695: ||', l_period_freq = '|| l_period_freq
6696: ||', l_duration = ' || l_duration ||',l_timeunit = '||l_timeunit ||')');
6697:
6698: END IF;

Line 6732: OKC_TIME_UTIL_PUB.get_duration(

6728: 'sll count zero');
6729: END IF;
6730:
6731:
6732: OKC_TIME_UTIL_PUB.get_duration(
6733: p_start_date => l_line_rec.line_start_dt,
6734: p_end_date => l_line_rec.line_end_dt,
6735: x_duration => l_duration,
6736: x_timeunit => l_timeunit,

Line 6741: 'okc_time_util_pub.get_duration(x_return_status = '||x_return_status

6737: x_return_status => x_return_status);
6738:
6739: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
6740: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_dates_sll.sll_duration',
6741: 'okc_time_util_pub.get_duration(x_return_status = '||x_return_status
6742: ||', l_duration = '|| l_duration
6743: ||', l_timeunit = ' || l_timeunit ||')');
6744: END IF;
6745:

Line 6759: 'okc_time_util_pub.get_seeded_timeunit(x_return_status = '||x_return_status

6755: x_timeunit => l_tce_code);
6756:
6757: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
6758: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_dates_sll.end_seed',
6759: 'okc_time_util_pub.get_seeded_timeunit(x_return_status = '||x_return_status
6760: ||', l_uom_quantity = '|| l_uom_quantity
6761: ||', l_tce_code = ' || l_tce_code ||')');
6762: END IF;
6763:

Line 7260: OKC_TIME_UTIL_PUB.get_duration(

7256: IF x_return_status <> 'S' THEN
7257: RAISE G_EXCEPTION_HALT_VALIDATION;
7258: END IF;
7259:
7260: OKC_TIME_UTIL_PUB.get_duration(
7261: p_start_date => l_line_rec.start_dt,
7262: p_end_date => l_line_rec.end_dt,
7263: x_duration => l_duration,
7264: x_timeunit => l_timeunit,

Line 7910: l_sll_end_date := OKC_TIME_UTIL_PUB.get_enddate(

7906: IF l_line_SLL_rec.end_date IS NOT NULL THEN
7907:
7908: l_sll_end_date := l_line_SLL_rec.end_date;
7909: ELSE
7910: l_sll_end_date := OKC_TIME_UTIL_PUB.get_enddate(
7911: l_Line_SlL_rec.Start_Date,
7912: l_Line_SlL_rec.UOM_CODE,
7913: l_Line_SlL_rec.uom_per_period * l_Line_SlL_rec.level_periods);
7914: END IF;

Line 7967: l_date_transaction := okc_time_util_pub.get_enddate

7963: ELSE ---not last
7964: IF p_lse_id <> 46 THEN
7965: l_date_transaction := LEAST(l_sll_end_date, p_line_end_date ) + l_action_offset;
7966: ELSE
7967: l_date_transaction := okc_time_util_pub.get_enddate
7968: (l_bs_tbl(l_index).date_start,
7969: l_Line_SLL_rec.uom_code,
7970: l_Line_SLL_rec.uom_per_period) + l_action_offset;
7971: END IF; ---chk for 46

Line 8337: l_next_cycle_dt := OKC_TIME_UTIL_PUB.get_enddate

8333: IF l_line_sll_counter + 1 <= p_sll_tbl.LAST THEN
8334: l_next_cycle_dt := p_sll_tbl(l_line_sll_counter + 1).dt_start;
8335: ELSE
8336:
8337: l_next_cycle_dt := OKC_TIME_UTIL_PUB.get_enddate
8338: (p_sll_tbl(l_line_sll_counter).dt_start,
8339: p_sll_tbl(l_line_sll_counter).uom,
8340: (p_sll_tbl(l_line_sll_counter).uom_Per_Period *
8341: p_sll_tbl(l_line_sll_counter).level_period));

Line 8354: L_next_cycle_dt := OKC_TIME_UTIL_PUB.get_enddate

8350: -----errorout_ad('uom = ' || p_sll_tbl(l_line_sll_counter).uom_Per_Period);
8351: IF L_next_cycle_dt IS null THEN
8352:
8353:
8354: L_next_cycle_dt := OKC_TIME_UTIL_PUB.get_enddate
8355: (l_last_cycle_dt,
8356: p_sll_tbl(l_line_sll_counter).uom,
8357: p_sll_tbl(l_line_sll_counter).uom_Per_Period);
8358:

Line 8722: l_sll_in_tbl(l_index).end_Date := OKC_TIME_UTIL_PUB.get_enddate(

8718:
8719: l_sll_in_tbl(l_index).end_Date := l_Line_SlL_rec.end_Date;
8720: ELSE
8721: l_update_end_date := 'Y';
8722: l_sll_in_tbl(l_index).end_Date := OKC_TIME_UTIL_PUB.get_enddate(
8723: l_Line_SlL_rec.Start_Date,
8724: l_Line_SlL_rec.UOM_CODE,
8725: l_Line_SlL_rec.uom_per_period * l_Line_SlL_rec.level_periods);
8726: END IF;

Line 8879: l_sll_tbl(l_index).end_Date := OKC_TIME_UTIL_PUB.get_enddate(

8875:
8876: l_sll_tbl(l_index).end_Date := l_Line_SlL_rec.end_Date;
8877: ELSE
8878: l_update_end_date := 'Y';
8879: l_sll_tbl(l_index).end_Date := OKC_TIME_UTIL_PUB.get_enddate(
8880: l_Line_SlL_rec.Start_Date,
8881: l_Line_SlL_rec.UOM_CODE,
8882: l_Line_SlL_rec.uom_per_period * l_Line_SlL_rec.level_periods);
8883: END IF;

Line 9673: OKC_TIME_UTIL_PUB.Get_Duration(p_SubLine_rec.cp_start_dt,p_SubLine_rec.cp_end_dt,l_duration,l_uom,x_return_status);

9669: -- If price UOM is NULL , then derive the UOM based on the effective dates
9670: -- of the subline.
9671: -------------------------------------------------------------------------
9672: IF (p_SubLine_rec.cp_price_uom is null) THEN
9673: OKC_TIME_UTIL_PUB.Get_Duration(p_SubLine_rec.cp_start_dt,p_SubLine_rec.cp_end_dt,l_duration,l_uom,x_return_status);
9674: END IF;
9675: ------------------------------------------------------------------------
9676: -- End partial period computation logic
9677: -------------------------------------------------------------------------

Line 9776: l_next_cycle_dt := OKC_TIME_UTIL_PUB.get_enddate

9772:
9773: IF l_cp_sll_counter + 1 <= p_cp_sll_tbl.LAST THEN
9774: l_next_cycle_dt := p_cp_sll_tbl(l_cp_sll_counter + 1).dt_start;
9775: ELSE
9776: l_next_cycle_dt := OKC_TIME_UTIL_PUB.get_enddate
9777: (p_cp_sll_tbl(l_cp_sll_counter).dt_start,
9778: p_cp_sll_tbl(l_cp_sll_counter).uom,
9779: (p_cp_sll_tbl(l_cp_sll_counter).uom_Per_Period *
9780: p_cp_sll_tbl(l_cp_sll_counter).level_period));

Line 9790: l_next_cycle_dt := OKC_TIME_UTIL_PUB.get_enddate

9786:
9787: -----------errorout_ad('going in');
9788: -----------errorout_ad('l_last_cycle_dt = ' || l_last_cycle_dt);
9789: IF l_next_cycle_dt IS NULL THEN
9790: l_next_cycle_dt := OKC_TIME_UTIL_PUB.get_enddate
9791: (l_last_cycle_dt,
9792: p_cp_sll_tbl(l_cp_sll_counter).uom,
9793: p_cp_sll_tbl(l_cp_sll_counter).uom_Per_Period);
9794:

Line 10858: SELECT id, start_date, OKC_TIME_UTIL_PUB.get_enddate(

10854: AND sll.cle_id = p_line_id
10855: ORDER BY element.date_start;
10856:
10857: CURSOR l_line_sll_csr IS
10858: SELECT id, start_date, OKC_TIME_UTIL_PUB.get_enddate(
10859: start_date,
10860: uom_code,
10861: uom_per_period * level_periods) sll_end_date
10862: FROM oks_stream_levels_b

Line 10929: l_end_dt := OKC_TIME_UTIL_PUB.get_enddate(

10925: END LOOP;
10926:
10927: IF l_lvl_ele_tbl_in.COUNT > 0 THEN
10928:
10929: l_end_dt := OKC_TIME_UTIL_PUB.get_enddate(
10930: l_lvl_ele_tbl_in(i - 1).Date_start,
10931: l_uom_code,
10932: l_uom_per_period);
10933:

Line 11024: SELECT id, start_date, OKC_TIME_UTIL_PUB.get_enddate(

11020: AND sll.chr_id = p_chr_id
11021: ORDER BY element.date_start;
11022:
11023: CURSOR l_hdr_sll_csr IS
11024: SELECT id, start_date, OKC_TIME_UTIL_PUB.get_enddate(
11025: start_DATE,
11026: uom_code,
11027: uom_per_period * level_periods) sll_end_date
11028: FROM oks_stream_levels_b

Line 11092: l_end_dt := OKC_TIME_UTIL_PUB.get_enddate(

11088: i := i + 1;
11089: END LOOP;
11090:
11091: IF l_lvl_ele_tbl_in.COUNT > 0 THEN
11092: l_end_dt := OKC_TIME_UTIL_PUB.get_enddate(
11093: l_lvl_ele_tbl_in(i - 1).Date_start,
11094: l_uom_code,
11095: l_uom_per_period);
11096:

Line 11459: l_sll_prorate_tbl(l_index).sll_end_date := OKC_TIME_UTIL_PUB.get_enddate(

11455: ELSE
11456: l_sll_prorate_tbl(l_index).sll_start_date := l_sll_prorate_tbl(l_sll_prorate_tbl.PRIOR(l_index)).sll_end_date + 1;
11457: END IF;
11458:
11459: l_sll_prorate_tbl(l_index).sll_end_date := OKC_TIME_UTIL_PUB.get_enddate(
11460: l_sll_prorate_tbl(l_index).sll_start_date,
11461: p_sll_tbl(l_index).uom_code,
11462: (p_sll_tbl(l_index).level_periods * p_sll_tbl(l_index).uom_per_period));
11463:

Line 11715: OKC_TIME_UTIL_PUB.get_enddate(

11711: l_strm_lvl_tbl_in(l_sll_index).uom_code := l_old_sll_rec.uom_code;
11712: l_strm_lvl_tbl_in(l_sll_index).start_date := l_old_sll_rec.start_date;
11713:
11714: l_strm_lvl_tbl_in(l_sll_index).end_date := nvl(l_old_sll_rec.end_date,
11715: OKC_TIME_UTIL_PUB.get_enddate(
11716: l_old_sll_rec.start_date,
11717: l_old_sll_rec.uom_code,
11718: (l_old_sll_rec.level_periods *
11719: l_old_sll_rec.uom_per_period)) );

Line 13246: OKC_TIME_UTIL_PUB.get_duration(

13242: --dbms_output.put_line('l_billing_profile_Csr_Rec.BILLING_TYPE - '||l_billing_profile_Csr_Rec.BILLING_TYPE);
13243: IF l_billing_profile_Csr_Rec.BILLING_TYPE = 'ONETIME' THEN
13244:
13245: l_level_periods := 1;
13246: OKC_TIME_UTIL_PUB.get_duration(
13247: p_start_date => l_start_date
13248: , p_end_date => l_end_date
13249: , x_duration => l_duration
13250: , x_timeunit => l_timeunit

Line 13273: OKC_TIME_UTIL_PUB.get_duration(

13269: l_timeunit := l_billing_profile_Csr_Rec.interval; -- UOM
13270:
13271: ELSE
13272: l_level_periods := 1;
13273: OKC_TIME_UTIL_PUB.get_duration(
13274: p_start_date => l_start_date
13275: , p_end_date => l_end_date
13276: , x_duration => l_duration
13277: , x_timeunit => l_timeunit

Line 13322: okc_time_util_pub.get_duration(p_start_date,p_end_date,l_dur,l_uom,l_return_status);

13318: NULL); */
13319:
13320: /*Added for bug 16293821 */
13321:
13322: okc_time_util_pub.get_duration(p_start_date,p_end_date,l_dur,l_uom,l_return_status);
13323:
13324: l_dur := OKS_TIME_MEASURES_PUB.get_quantity (
13325: p_start_date => p_start_date,
13326: p_end_date => p_end_date,