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 2140: l_end_date := OKC_TIME_UTIL_PUB.get_enddate(

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

Line 2867: l_element_end_dt := OKC_TIME_UTIL_PUB.get_enddate

2863: l_element_end_dt := x_top_line_bs(l_tbs_ind ).DATE_end;
2864:
2865: ELSE
2866:
2867: l_element_end_dt := OKC_TIME_UTIL_PUB.get_enddate
2868: (x_top_line_bs(l_tbs_ind ).DATE_START,
2869: p_uom,
2870: p_uom_Per_Period);
2871: END IF;

Line 3236: l_next_cycle_dt := OKC_TIME_UTIL_PUB.get_enddate

3232: IF l_line_sll_counter + 1 <= p_sll_tbl.LAST THEN
3233: l_next_cycle_dt := TRUNC(p_sll_tbl(l_line_sll_counter + 1).dt_start);
3234: ELSE
3235:
3236: l_next_cycle_dt := OKC_TIME_UTIL_PUB.get_enddate
3237: (TRUNC(p_sll_tbl(l_line_sll_counter).dt_start),
3238: p_sll_tbl(l_line_sll_counter).uom,
3239: (p_sll_tbl(l_line_sll_counter).uom_Per_Period *
3240: p_sll_tbl(l_line_sll_counter).level_period ));

Line 3253: L_next_cycle_dt := OKC_TIME_UTIL_PUB.get_enddate

3249: -----errorout_ad('uom = ' || p_sll_tbl(l_line_sll_counter).uom_Per_Period);
3250: IF L_next_cycle_dt IS null THEN
3251:
3252:
3253: L_next_cycle_dt := OKC_TIME_UTIL_PUB.get_enddate
3254: (l_last_cycle_dt,
3255: p_sll_tbl(l_line_sll_counter).uom,
3256: p_sll_tbl(l_line_sll_counter).uom_Per_Period);
3257:

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

5264: l_sll_tbl(l_index).end_Date := l_Line_SlL_rec.end_Date;
5265: ELSE
5266: l_update_required := 'Y';
5267:
5268: l_sll_tbl(l_index).end_Date := OKC_TIME_UTIL_PUB.get_enddate(
5269: l_Line_SlL_rec.Start_Date,
5270: l_Line_SlL_rec.uom_code,
5271: (l_Line_SlL_rec.level_periods *
5272: l_Line_SlL_rec.uom_per_period));

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

5777: IF l_Line_SlL_rec.end_Date IS NOT NULL THEN
5778: l_sll_tbl(l_index).end_Date := l_Line_SlL_rec.end_Date;
5779: ELSE
5780: l_update_end_date := 'Y';
5781: l_sll_tbl(l_index).end_Date := OKC_TIME_UTIL_PUB.get_enddate(
5782: l_Line_SlL_rec.Start_Date,
5783: l_Line_SlL_rec.uom_code,
5784: l_Line_SlL_rec.level_periods * l_Line_SlL_rec.uom_per_period);
5785: END IF;

Line 5901: OKC_TIME_UTIL_PUB.get_duration(

5897: -- ELSE --sll start date not first day of calendar month
5898:
5899: ELSE --period start and period type are null
5900: --existing logic
5901: OKC_TIME_UTIL_PUB.get_duration(
5902: p_start_date => l_line_rec.line_start_dt,
5903: p_end_date => l_sll_start_date - 1,
5904: x_duration => l_duration,
5905: x_timeunit => l_timeunit,

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

5908: --mchoudha bug#5076095 added to_char for the dates in the following
5909: --fnd_log statement
5910: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
5911: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.cascade_dates_sll.sll_duration',
5912: 'okc_time_util_pub.get_duration(x_return_status = '||x_return_status
5913: ||', end date in MM/DD/YYYY HH24:MI:SS = ' || to_char(l_sll_start_date - 1,'MM/DD/YYYY HH24:MI:SS')
5914: ||', st date MM/DD/YYYY HH24:MI:SS ='|| to_char(l_line_rec.line_start_dt,'MM/DD/YYYY HH24:MI:SS')
5915: ||', returned timeunit and duration = ' ||l_duration || '-' || l_timeunit ||')');
5916: END IF;

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

5928: x_timeunit => l_tce_code);
5929:
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.seeded',
5932: 'okc_time_util_pub.get_seeded_timeunit(x_return_status = '||x_return_status
5933: ||', returned timeunit and qty = ' ||l_tce_code || '-' || l_uom_quantity ||')');
5934: END IF;
5935:
5936: l_sequence := l_sll_tbl(l_sll_tbl_index).sequence_no - 1;

Line 5999: l_next_date := OKC_TIME_UTIL_PUB.get_enddate(

5995: p_level_periods => l_sll_tbl(l_sll_tbl_index).level_periods);
5996:
5997: ELSE
5998: --existing logic
5999: l_next_date := OKC_TIME_UTIL_PUB.get_enddate(
6000: l_sll_tbl(l_sll_tbl_index).start_date,
6001: l_sll_tbl(l_sll_tbl_index).uom_code,
6002: (l_sll_tbl(l_sll_tbl_index).level_periods * l_sll_tbl(l_sll_tbl_index).uom_per_period));
6003: END IF;

Line 6144: l_sll_end_date := OKC_TIME_UTIL_PUB.get_enddate(

6140: IF l_sll_tbl_index < l_sll_tbl.LAST THEN
6141: l_sll_end_date := l_sll_tbl(l_sll_tbl_index + 1).start_date + 1;
6142:
6143: ELSE
6144: l_sll_end_date := OKC_TIME_UTIL_PUB.get_enddate(
6145: l_sll_tbl(l_sll_tbl_index).start_date,
6146: l_sll_tbl(l_sll_tbl_index).uom_code,
6147: (l_sll_tbl(l_sll_tbl_index).level_periods * l_sll_tbl(l_sll_tbl_index).uom_per_period));
6148: END IF; --- chk for last sll

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

6160: x_timeunit => l_tce_code);
6161:
6162: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
6163: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.cascade_dates_sll.seed',
6164: 'okc_time_util_pub.get_seeded_timeunit(x_return_status = '||x_return_status
6165: ||', returned timeunit and qty = ' ||l_tce_code || '-' || l_uom_quantity ||')');
6166: END IF;
6167:
6168: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

Line 6244: l_next_date := OKC_TIME_UTIL_PUB.get_enddate(

6240: p_level_periods => l_sll_tbl(l_sll_tbl_index).level_periods);
6241:
6242: ELSE
6243: --Existing logic
6244: l_next_date := OKC_TIME_UTIL_PUB.get_enddate(
6245: l_sll_tbl(l_sll_tbl_index).start_date,
6246: l_sll_tbl(l_sll_tbl_index).uom_code,
6247: (l_sll_tbl(l_sll_tbl_index).uom_per_period * l_sll_tbl(l_sll_tbl_index).level_periods));
6248:

Line 6268: OKC_TIME_UTIL_PUB.get_duration(

6264: END IF;
6265:
6266:
6267:
6268: OKC_TIME_UTIL_PUB.get_duration(
6269: p_start_date => l_line_rec.line_start_dt,
6270: p_end_date => l_line_rec.line_end_dt,
6271: x_duration => l_duration,
6272: x_timeunit => l_timeunit,

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

6273: x_return_status => x_return_status);
6274:
6275: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
6276: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_dates_sll.duration',
6277: 'okc_time_util_pub.get_duration(x_return_status = '||x_return_status
6278: ||', l_duration = '|| l_duration
6279: ||', l_timeunit = ' || l_timeunit ||')');
6280: END IF;
6281:

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

6290: x_timeunit => l_tce_code);
6291:
6292: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
6293: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_dates_sll.call_seed',
6294: 'okc_time_util_pub.get_seeded_timeunit(x_return_status = '||x_return_status
6295: ||', l_uom_quantity = '|| l_uom_quantity
6296: ||', l_tce_code = ' || l_tce_code ||')');
6297: END IF;
6298:

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

6440: x_timeunit => l_tce_code);
6441:
6442: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
6443: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_dates_sll.st_end_seed',
6444: 'okc_time_util_pub.get_seeded_timeunit(x_return_status = '||x_return_status
6445: ||', l_uom_quantity = '|| l_uom_quantity
6446: ||', l_tce_code = ' || l_tce_code ||')');
6447: END IF;
6448:

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

6493: -- ELSE
6494: l_sll_tbl(l_sll_tbl_index + 1).level_periods := l_period_freq;
6495: l_sll_tbl(l_sll_tbl_index + 1).uom_per_period := l_sll_tbl(l_sll_tbl_index).uom_per_period;
6496:
6497: l_sll_tbl(l_sll_tbl_index + 1).end_date := OKC_TIME_UTIL_PUB.get_enddate(
6498: l_sll_start_date,
6499: l_sll_tbl(l_sll_tbl_index).uom_code,
6500: l_period_freq * l_sll_tbl(l_sll_tbl_index).uom_per_period);
6501:

Line 6531: OKC_TIME_UTIL_PUB.get_duration(

6527: 'sll count zero');
6528: END IF;
6529:
6530:
6531: OKC_TIME_UTIL_PUB.get_duration(
6532: p_start_date => l_line_rec.line_start_dt,
6533: p_end_date => l_line_rec.line_end_dt,
6534: x_duration => l_duration,
6535: x_timeunit => l_timeunit,

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

6536: x_return_status => x_return_status);
6537:
6538: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
6539: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_dates_sll.sll_duration',
6540: 'okc_time_util_pub.get_duration(x_return_status = '||x_return_status
6541: ||', l_duration = '|| l_duration
6542: ||', l_timeunit = ' || l_timeunit ||')');
6543: END IF;
6544:

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

6554: x_timeunit => l_tce_code);
6555:
6556: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
6557: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_dates_sll.end_seed',
6558: 'okc_time_util_pub.get_seeded_timeunit(x_return_status = '||x_return_status
6559: ||', l_uom_quantity = '|| l_uom_quantity
6560: ||', l_tce_code = ' || l_tce_code ||')');
6561: END IF;
6562:

Line 7048: OKC_TIME_UTIL_PUB.get_duration(

7044: IF x_return_status <> 'S' THEN
7045: RAISE G_EXCEPTION_HALT_VALIDATION;
7046: END IF;
7047:
7048: OKC_TIME_UTIL_PUB.get_duration(
7049: p_start_date => l_line_rec.start_dt,
7050: p_end_date => l_line_rec.end_dt,
7051: x_duration => l_duration,
7052: x_timeunit => l_timeunit,

Line 7697: l_sll_end_date := OKC_TIME_UTIL_PUB.get_enddate(

7693: IF l_line_SLL_rec.end_date IS NOT NULL THEN
7694:
7695: l_sll_end_date := l_line_SLL_rec.end_date;
7696: ELSE
7697: l_sll_end_date := OKC_TIME_UTIL_PUB.get_enddate(
7698: l_Line_SlL_rec.Start_Date,
7699: l_Line_SlL_rec.UOM_CODE,
7700: l_Line_SlL_rec.uom_per_period * l_Line_SlL_rec.level_periods);
7701: END IF;

Line 7754: l_date_transaction := okc_time_util_pub.get_enddate

7750: ELSE ---not last
7751: IF p_lse_id <> 46 THEN
7752: l_date_transaction := LEAST(l_sll_end_date, p_line_end_date ) + l_action_offset;
7753: ELSE
7754: l_date_transaction := okc_time_util_pub.get_enddate
7755: (l_bs_tbl(l_index).date_start,
7756: l_Line_SLL_rec.uom_code,
7757: l_Line_SLL_rec.uom_per_period) + l_action_offset;
7758: END IF; ---chk for 46

Line 8124: l_next_cycle_dt := OKC_TIME_UTIL_PUB.get_enddate

8120: IF l_line_sll_counter + 1 <= p_sll_tbl.LAST THEN
8121: l_next_cycle_dt := p_sll_tbl(l_line_sll_counter + 1).dt_start;
8122: ELSE
8123:
8124: l_next_cycle_dt := OKC_TIME_UTIL_PUB.get_enddate
8125: (p_sll_tbl(l_line_sll_counter).dt_start,
8126: p_sll_tbl(l_line_sll_counter).uom,
8127: (p_sll_tbl(l_line_sll_counter).uom_Per_Period *
8128: p_sll_tbl(l_line_sll_counter).level_period));

Line 8141: L_next_cycle_dt := OKC_TIME_UTIL_PUB.get_enddate

8137: -----errorout_ad('uom = ' || p_sll_tbl(l_line_sll_counter).uom_Per_Period);
8138: IF L_next_cycle_dt IS null THEN
8139:
8140:
8141: L_next_cycle_dt := OKC_TIME_UTIL_PUB.get_enddate
8142: (l_last_cycle_dt,
8143: p_sll_tbl(l_line_sll_counter).uom,
8144: p_sll_tbl(l_line_sll_counter).uom_Per_Period);
8145:

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

8505:
8506: l_sll_in_tbl(l_index).end_Date := l_Line_SlL_rec.end_Date;
8507: ELSE
8508: l_update_end_date := 'Y';
8509: l_sll_in_tbl(l_index).end_Date := OKC_TIME_UTIL_PUB.get_enddate(
8510: l_Line_SlL_rec.Start_Date,
8511: l_Line_SlL_rec.UOM_CODE,
8512: l_Line_SlL_rec.uom_per_period * l_Line_SlL_rec.level_periods);
8513: END IF;

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

8662:
8663: l_sll_tbl(l_index).end_Date := l_Line_SlL_rec.end_Date;
8664: ELSE
8665: l_update_end_date := 'Y';
8666: l_sll_tbl(l_index).end_Date := OKC_TIME_UTIL_PUB.get_enddate(
8667: l_Line_SlL_rec.Start_Date,
8668: l_Line_SlL_rec.UOM_CODE,
8669: l_Line_SlL_rec.uom_per_period * l_Line_SlL_rec.level_periods);
8670: END IF;

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

9452: -- If price UOM is NULL , then derive the UOM based on the effective dates
9453: -- of the subline.
9454: -------------------------------------------------------------------------
9455: IF (p_SubLine_rec.cp_price_uom is null) THEN
9456: 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);
9457: END IF;
9458: ------------------------------------------------------------------------
9459: -- End partial period computation logic
9460: -------------------------------------------------------------------------

Line 9559: l_next_cycle_dt := OKC_TIME_UTIL_PUB.get_enddate

9555:
9556: IF l_cp_sll_counter + 1 <= p_cp_sll_tbl.LAST THEN
9557: l_next_cycle_dt := p_cp_sll_tbl(l_cp_sll_counter + 1).dt_start;
9558: ELSE
9559: l_next_cycle_dt := OKC_TIME_UTIL_PUB.get_enddate
9560: (p_cp_sll_tbl(l_cp_sll_counter).dt_start,
9561: p_cp_sll_tbl(l_cp_sll_counter).uom,
9562: (p_cp_sll_tbl(l_cp_sll_counter).uom_Per_Period *
9563: p_cp_sll_tbl(l_cp_sll_counter).level_period));

Line 9573: l_next_cycle_dt := OKC_TIME_UTIL_PUB.get_enddate

9569:
9570: -----------errorout_ad('going in');
9571: -----------errorout_ad('l_last_cycle_dt = ' || l_last_cycle_dt);
9572: IF l_next_cycle_dt IS NULL THEN
9573: l_next_cycle_dt := OKC_TIME_UTIL_PUB.get_enddate
9574: (l_last_cycle_dt,
9575: p_cp_sll_tbl(l_cp_sll_counter).uom,
9576: p_cp_sll_tbl(l_cp_sll_counter).uom_Per_Period);
9577:

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

10611: AND sll.cle_id = p_line_id
10612: ORDER BY element.date_start;
10613:
10614: CURSOR l_line_sll_csr IS
10615: SELECT id, start_date, OKC_TIME_UTIL_PUB.get_enddate(
10616: start_date,
10617: uom_code,
10618: uom_per_period * level_periods) sll_end_date
10619: FROM oks_stream_levels_b

Line 10686: l_end_dt := OKC_TIME_UTIL_PUB.get_enddate(

10682: END LOOP;
10683:
10684: IF l_lvl_ele_tbl_in.COUNT > 0 THEN
10685:
10686: l_end_dt := OKC_TIME_UTIL_PUB.get_enddate(
10687: l_lvl_ele_tbl_in(i - 1).Date_start,
10688: l_uom_code,
10689: l_uom_per_period);
10690:

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

10777: AND sll.chr_id = p_chr_id
10778: ORDER BY element.date_start;
10779:
10780: CURSOR l_hdr_sll_csr IS
10781: SELECT id, start_date, OKC_TIME_UTIL_PUB.get_enddate(
10782: start_DATE,
10783: uom_code,
10784: uom_per_period * level_periods) sll_end_date
10785: FROM oks_stream_levels_b

Line 10849: l_end_dt := OKC_TIME_UTIL_PUB.get_enddate(

10845: i := i + 1;
10846: END LOOP;
10847:
10848: IF l_lvl_ele_tbl_in.COUNT > 0 THEN
10849: l_end_dt := OKC_TIME_UTIL_PUB.get_enddate(
10850: l_lvl_ele_tbl_in(i - 1).Date_start,
10851: l_uom_code,
10852: l_uom_per_period);
10853:

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

11212: ELSE
11213: l_sll_prorate_tbl(l_index).sll_start_date := l_sll_prorate_tbl(l_sll_prorate_tbl.PRIOR(l_index)).sll_end_date + 1;
11214: END IF;
11215:
11216: l_sll_prorate_tbl(l_index).sll_end_date := OKC_TIME_UTIL_PUB.get_enddate(
11217: l_sll_prorate_tbl(l_index).sll_start_date,
11218: p_sll_tbl(l_index).uom_code,
11219: (p_sll_tbl(l_index).level_periods * p_sll_tbl(l_index).uom_per_period));
11220:

Line 11472: OKC_TIME_UTIL_PUB.get_enddate(

11468: l_strm_lvl_tbl_in(l_sll_index).uom_code := l_old_sll_rec.uom_code;
11469: l_strm_lvl_tbl_in(l_sll_index).start_date := l_old_sll_rec.start_date;
11470:
11471: l_strm_lvl_tbl_in(l_sll_index).end_date := nvl(l_old_sll_rec.end_date,
11472: OKC_TIME_UTIL_PUB.get_enddate(
11473: l_old_sll_rec.start_date,
11474: l_old_sll_rec.uom_code,
11475: (l_old_sll_rec.level_periods *
11476: l_old_sll_rec.uom_per_period)) );