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_PM_PROGRAMS_PVT dependencies on OKC_TIME_UTIL_PUB

Line 44: -- l_schedule_date := nvl(p_first_sch_date,okc_time_util_pub.get_enddate(p_start_date,p_period,p_duration));

40: END IF;
41:
42:
43: i:=1;
44: -- l_schedule_date := nvl(p_first_sch_date,okc_time_util_pub.get_enddate(p_start_date,p_period,p_duration));
45: l_schedule_date := p_first_sch_date;
46:
47:
48: if trunc(l_schedule_date) >= trunc(p_end_date) then

Line 64: l_schedule_date := okc_time_util_pub.get_enddate(l_schedule_date+1,p_period,p_duration);

60: IF trunc(l_schedule_date) <> trunc(p_end_date) THEN
61:
62: LOOP
63:
64: l_schedule_date := okc_time_util_pub.get_enddate(l_schedule_date+1,p_period,p_duration);
65:
66: if trunc(l_schedule_date) > trunc(p_end_date) OR
67: (l_period_ctr is not null AND l_period_ctr = 0 ) then
68: exit;

Line 421: l_first_sch_date := nvl(okc_time_util_pub.get_enddate(l_start_date,

417: l_pmlrulv_tbl(pml_ctr).START_DATE := l_start_date;
418:
419:
420:
421: l_first_sch_date := nvl(okc_time_util_pub.get_enddate(l_start_date,
422: l_pmlrulv_tbl(pml_ctr).offset_uom,
423: l_pmlrulv_tbl(pml_ctr).offset_duration) + 1, l_start_date);
424: l_duration := NULL;
425: l_timeunit := NULL;

Line 436: okc_time_util_pub.get_duration(

432: (trunc(l_first_sch_date) >= trunc(p_cov_end_date))) THEN
433:
434: l_first_sch_date := trunc(p_cov_end_date);
435:
436: okc_time_util_pub.get_duration(
437: p_start_date => l_start_date,
438: p_end_date => l_first_sch_date - 1,
439: x_duration => l_duration,
440: x_timeunit => l_timeunit,

Line 452: l_sch_end_date := okc_time_util_pub.get_enddate(l_first_sch_date,

448: /* This handles the following scenario -In the else, if the number of occurences (period) for
449: the last stream level in template may be null*/
450: IF to_number(l_pmlrulv_tbl(pml_ctr).number_of_occurences) IS NOT NULL THEN
451:
452: l_sch_end_date := okc_time_util_pub.get_enddate(l_first_sch_date,
453: l_pmlrulv_tbl(pml_ctr).frequency_uom,
454: to_number(l_pmlrulv_tbl(pml_ctr).frequency)*
455: to_number(l_pmlrulv_tbl(pml_ctr).number_of_occurences));
456:

Line 501: l_sch_end_date := okc_time_util_pub.get_enddate(l_first_sch_date,

497: IF l_check_renew ='Y'
498: THEN
499: IF to_number(l_pmlrulv_tbl(pml_ctr).number_of_occurences) IS NOT NULL THEN
500:
501: l_sch_end_date := okc_time_util_pub.get_enddate(l_first_sch_date,
502: l_pmlrulv_tbl(pml_ctr).frequency_uom,
503: to_number(l_pmlrulv_tbl(pml_ctr).frequency)*
504: to_number(l_pmlrulv_tbl(pml_ctr).number_of_occurences));
505:

Line 736: l_first_sch_date := nvl(okc_time_util_pub.get_enddate(l_start_date,

732: l_pmlrulv_tbl(pml_ctr).START_DATE := l_start_date;
733:
734:
735:
736: l_first_sch_date := nvl(okc_time_util_pub.get_enddate(l_start_date,
737: l_pmlrulv_tbl(pml_ctr).offset_uom,
738: l_pmlrulv_tbl(pml_ctr).offset_duration) + 1, l_start_date);
739: l_duration := NULL;
740: l_timeunit := NULL;

Line 748: okc_time_util_pub.get_duration(

744: (trunc(l_first_sch_date) >= trunc(p_cov_end_date))) THEN
745:
746: l_first_sch_date := trunc(p_cov_end_date);
747:
748: okc_time_util_pub.get_duration(
749: p_start_date => l_start_date,
750: p_end_date => l_first_sch_date - 1,
751: x_duration => l_duration,
752: x_timeunit => l_timeunit,

Line 763: l_sch_end_date := okc_time_util_pub.get_enddate(l_first_sch_date,

759: END IF;
760:
761: IF to_number(l_pmlrulv_tbl(pml_ctr).number_of_occurences) IS NOT NULL THEN
762:
763: l_sch_end_date := okc_time_util_pub.get_enddate(l_first_sch_date,
764: l_pmlrulv_tbl(pml_ctr).frequency_uom,
765: to_number(l_pmlrulv_tbl(pml_ctr).frequency)*
766: to_number(l_pmlrulv_tbl(pml_ctr).number_of_occurences));
767:

Line 813: l_sch_end_date := okc_time_util_pub.get_enddate(l_first_sch_date,

809: IF l_check_renew ='Y'
810: THEN
811: IF to_number(l_pmlrulv_tbl(pml_ctr).NUMBER_OF_OCCURENCES) IS NOT NULL THEN
812:
813: l_sch_end_date := okc_time_util_pub.get_enddate(l_first_sch_date,
814: l_pmlrulv_tbl(pml_ctr).frequency_uom,
815: to_number(l_pmlrulv_tbl(pml_ctr).frequency)*
816: to_number(l_pmlrulv_tbl(pml_ctr).number_of_occurences));
817:

Line 1121: l_first_sch_date := nvl(okc_time_util_pub.get_enddate(l_start_date,

1117:
1118: FOR i in l_pmlrulv_tbl.FIRST..l_pmlrulv_tbl.LAST LOOP
1119:
1120:
1121: l_first_sch_date := nvl(okc_time_util_pub.get_enddate(l_start_date,
1122: l_pmlrulv_tbl(i).OFFSET_UOM,
1123: l_pmlrulv_tbl(i).OFFSET_DURATION) + 1,l_start_date);
1124:
1125: l_duration := NULL;

Line 1134: okc_time_util_pub.get_duration(

1130: (trunc(l_first_sch_date) >= trunc(p_cov_tbl(1).end_date))) THEN
1131:
1132: l_first_sch_date := trunc(p_cov_tbl(1).end_date);
1133:
1134: okc_time_util_pub.get_duration(
1135: p_start_date => l_start_date,
1136: p_end_date => l_first_sch_date - 1,
1137: x_duration => l_duration,
1138: x_timeunit => l_timeunit,

Line 1149: l_sch_end_date := okc_time_util_pub.get_enddate(l_first_sch_date,

1145: END IF;
1146:
1147:
1148:
1149: l_sch_end_date := okc_time_util_pub.get_enddate(l_first_sch_date,
1150: l_pmlrulv_tbl(i).FREQUENCY_UOM,
1151: to_number(l_pmlrulv_tbl(i).FREQUENCY)*
1152: to_number(l_pmlrulv_tbl(i).NUMBER_OF_OCCURENCES));
1153: IF trunc(l_sch_end_date) >= trunc(p_cov_tbl(1).end_date) then

Line 2230: l_first_sch_date := nvl(okc_time_util_pub.get_enddate(trunc(p_new_start_date),

2226: pml_ins_ctr := 1;
2227: l_first_sch_date := NULL;
2228: l_next_sch_date := NULL;
2229:
2230: l_first_sch_date := nvl(okc_time_util_pub.get_enddate(trunc(p_new_start_date),
2231: l_pmlrulv_tbl_rfr(pml_rfr_ctr).offset_uom,
2232: l_pmlrulv_tbl_rfr(pml_rfr_ctr).offset_duration) + 1,
2233: trunc(p_new_start_date));
2234:

Line 2249: l_next_sch_date := okc_time_util_pub.get_enddate(trunc(l_first_sch_date)+1,

2245: l_pmschvtbl_ins(pms_ins_ctr).schedule_date := l_first_sch_date;
2246:
2247:
2248: l_pmschvtbl_ins(pms_ins_ctr).sch_sequence := 1;
2249: l_next_sch_date := okc_time_util_pub.get_enddate(trunc(l_first_sch_date)+1,
2250: l_pmlrulv_tbl_rfr(pml_rfr_ctr).frequency_uom,
2251: l_pmlrulv_tbl_rfr(pml_rfr_ctr).frequency);
2252:
2253: WHILE 1 = 1 LOOP

Line 2275: l_next_sch_date := okc_time_util_pub.get_enddate(trunc(l_next_sch_date)+1,

2271:
2272: EXIT;
2273:
2274: END IF;
2275: l_next_sch_date := okc_time_util_pub.get_enddate(trunc(l_next_sch_date)+1,
2276: l_pmlrulv_tbl_rfr(pml_rfr_ctr).FREQUENCY_UOM,
2277: l_pmlrulv_tbl_rfr(pml_rfr_ctr).FREQUENCY);
2278:
2279: END LOOP;

Line 2460: okc_time_util_pub.get_duration(

2456: l_pmlrulv_tbl_start(1).id = l_first_rule_id AND
2457: l_pmlrulv_tbl_start(1).AUTOSCHEDULE_YN = 'Y') THEN
2458: IF trunc(p_new_start_date) <> trunc(nvl(l_pmschv_start(1).schedule_date,
2459: l_pmschv_start(1).schedule_date_from)) THEN
2460: okc_time_util_pub.get_duration(
2461: p_start_date => trunc(p_new_start_date),
2462: p_end_date => nvl(l_pmschv_start(1).schedule_date,
2463: l_pmschv_start(1).schedule_date_from) - 1,
2464: x_duration => l_duration,

Line 2497: l_prev_sch_date := trunc(okc_time_util_pub.get_enddate(l_pmschv_start(1).schedule_date - 1,

2493: l_pmschvtbl_Ins.DELETE;
2494: pms_ins_ctr := 0;
2495: pms_upd_ctr := 0;
2496:
2497: l_prev_sch_date := trunc(okc_time_util_pub.get_enddate(l_pmschv_start(1).schedule_date - 1,
2498: l_pmlrulv_tbl_start(1).frequency_uom,
2499: -1*(to_number(l_pmlrulv_tbl_start(1).frequency))));
2500:
2501: WHILE 1 = 1 LOOP

Line 2519: okc_time_util_pub.get_duration(

2515: IF l_pmschvtbl_Ins.COUNT > 0 THEN
2516:
2517: IF trunc(p_new_start_date) <> trunc(l_pmschvtbl_Ins(pms_ins_ctr).schedule_date) THEN
2518:
2519: okc_time_util_pub.get_duration(
2520: p_start_date => trunc(p_new_start_date),
2521: p_end_date => l_pmschvtbl_Ins(pms_ins_ctr).schedule_date - 1,
2522: x_duration => l_duration,
2523: x_timeunit => l_timeunit,

Line 2539: okc_time_util_pub.get_duration(

2535:
2536: IF trunc(p_new_start_date) <> trunc(nvl(l_pmschv_start(1).schedule_date,
2537: l_pmschv_start(1).schedule_date_from)) THEN
2538:
2539: okc_time_util_pub.get_duration(
2540: p_start_date => trunc(p_new_start_date),
2541: p_end_date => nvl(l_pmschv_start(1).schedule_date,
2542: l_pmschv_start(1).schedule_date_from) - 1,
2543: x_duration => l_duration,

Line 2575: l_prev_sch_date := trunc(okc_time_util_pub.get_enddate(l_prev_sch_date - 1,

2571: EXIT;
2572:
2573: END IF;
2574:
2575: l_prev_sch_date := trunc(okc_time_util_pub.get_enddate(l_prev_sch_date - 1,
2576: l_pmlrulv_tbl_start(1).frequency_uom,
2577: -1*(to_number(l_pmlrulv_tbl_start(1).frequency))));
2578:
2579: END LOOP;

Line 2691: okc_time_util_pub.get_duration(

2687: l_pmlrulv_tbl_start(1).AUTOSCHEDULE_YN = 'Y') THEN
2688:
2689: IF trunc(p_new_start_date) <> trunc(nvl(l_pmschv_start(1).schedule_date,
2690: l_pmschv_start(1).schedule_date_from)) THEN
2691: okc_time_util_pub.get_duration(
2692: p_start_date => trunc(p_new_start_date),
2693: p_end_date => nvl(l_pmschv_start(1).schedule_date,
2694: l_pmschv_start(1).schedule_date_from) - 1,
2695: x_duration => l_duration,

Line 2730: l_prev_sch_date := trunc(okc_time_util_pub.get_enddate(l_pmschv_start(1).schedule_date - 1,

2726: l_pmschvtbl_Ins.DELETE;
2727: pms_ins_ctr := 0;
2728: pms_upd_ctr := 0;
2729:
2730: l_prev_sch_date := trunc(okc_time_util_pub.get_enddate(l_pmschv_start(1).schedule_date - 1,
2731: l_pmlrulv_tbl_start(1).frequency_uom,
2732: -1*(to_number(l_pmlrulv_tbl_start(1).frequency))));
2733:
2734: WHILE 1 = 1 LOOP

Line 2751: okc_time_util_pub.get_duration(

2747: IF l_pmschvtbl_Ins.COUNT > 0 THEN
2748:
2749: IF trunc(p_new_start_date) <> trunc(l_pmschvtbl_Ins(pms_ins_ctr).schedule_date) THEN
2750:
2751: okc_time_util_pub.get_duration(
2752: p_start_date => trunc(p_new_start_date),
2753: p_end_date => l_pmschvtbl_Ins(pms_ins_ctr).schedule_date - 1,
2754: x_duration => l_duration,
2755: x_timeunit => l_timeunit,

Line 2771: okc_time_util_pub.get_duration(

2767:
2768: IF trunc(p_new_start_date) <> trunc(nvl(l_pmschv_start(1).schedule_date,
2769: l_pmschv_start(1).schedule_date_from)) THEN
2770:
2771: okc_time_util_pub.get_duration(
2772: p_start_date => trunc(p_new_start_date),
2773: p_end_date => nvl(l_pmschv_start(1).schedule_date,
2774: l_pmschv_start(1).schedule_date_from) - 1,
2775: x_duration => l_duration,

Line 2807: l_prev_sch_date := trunc(okc_time_util_pub.get_enddate(l_prev_sch_date - 1,

2803: EXIT;
2804:
2805: END IF;
2806:
2807: l_prev_sch_date := trunc(okc_time_util_pub.get_enddate(l_prev_sch_date - 1,
2808: l_pmlrulv_tbl_start(1).frequency_uom,
2809: -1*(to_number(l_pmlrulv_tbl_start(1).frequency))));
2810:
2811: END LOOP;

Line 2852: l_next_sch_date := trunc(okc_time_util_pub.get_enddate(l_pmschv_end(1).schedule_date + 1,

2848:
2849: l_pmschvtbl_Ins.DELETE;
2850: pms_ins_ctr := 0;
2851:
2852: l_next_sch_date := trunc(okc_time_util_pub.get_enddate(l_pmschv_end(1).schedule_date + 1,
2853: l_pmlrulv_tbl_end(1).frequency_uom,
2854: to_number(l_pmlrulv_tbl_end(1).frequency)));
2855:
2856:

Line 2880: l_next_sch_date := trunc(okc_time_util_pub.get_enddate(l_next_sch_date + 1,

2876: EXIT;
2877:
2878: END IF;
2879:
2880: l_next_sch_date := trunc(okc_time_util_pub.get_enddate(l_next_sch_date + 1,
2881: l_pmlrulv_tbl_end(1).frequency_uom,
2882: to_number(l_pmlrulv_tbl_end(1).frequency)));
2883:
2884:

Line 3003: l_next_sch_date := trunc(okc_time_util_pub.get_enddate(l_pmschv_end(1).schedule_date + 1,

2999:
3000: l_pmschvtbl_Ins.DELETE;
3001: pms_ins_ctr := 0;
3002:
3003: l_next_sch_date := trunc(okc_time_util_pub.get_enddate(l_pmschv_end(1).schedule_date + 1,
3004: l_pmlrulv_tbl_end(1).frequency_uom,
3005: to_number(l_pmlrulv_tbl_end(1).frequency)));
3006:
3007: WHILE 1 = 1 LOOP

Line 3029: l_next_sch_date := trunc(okc_time_util_pub.get_enddate(l_next_sch_date + 1,

3025: EXIT;
3026:
3027: END IF;
3028:
3029: l_next_sch_date := trunc(okc_time_util_pub.get_enddate(l_next_sch_date + 1,
3030: l_pmlrulv_tbl_end(1).frequency_uom,
3031: to_number(l_pmlrulv_tbl_end(1).frequency)));
3032:
3033: END LOOP;

Line 3415: okc_time_util_pub.get_duration(

3411:
3412:
3413: IF trunc(p_new_start_date) <> trunc(nvl(l_pmschv_start(1).schedule_date,
3414: l_pmschv_start(1).schedule_date_from)) THEN
3415: okc_time_util_pub.get_duration(
3416: p_start_date => trunc(p_new_start_date),
3417: p_end_date => nvl(l_pmschv_start(1).schedule_date,
3418: l_pmschv_start(1).schedule_date_from) - 1,
3419: x_duration => l_duration,

Line 3454: l_prev_sch_date := trunc(okc_time_util_pub.get_enddate(l_pmschv_start(1).schedule_date - 1,

3450:
3451: pms_ins_ctr := 0;
3452: pms_upd_ctr := 0;
3453:
3454: l_prev_sch_date := trunc(okc_time_util_pub.get_enddate(l_pmschv_start(1).schedule_date - 1,
3455: l_pmlrulv_tbl_start(1).frequency_uom,
3456: -1*(to_number(l_pmlrulv_tbl_start(1).frequency))));
3457:
3458: WHILE 1 = 1 LOOP

Line 3496: okc_time_util_pub.get_duration(

3492:
3493:
3494: IF trunc(p_new_start_date) <> trunc(l_pmschvtbl_Ins(pms_ins_ctr).schedule_date) THEN
3495:
3496: okc_time_util_pub.get_duration(
3497: p_start_date => trunc(p_new_start_date),
3498: p_end_date => l_pmschvtbl_Ins(pms_ins_ctr).schedule_date - 1,
3499: x_duration => l_duration,
3500: x_timeunit => l_timeunit,

Line 3515: okc_time_util_pub.get_duration(

3511:
3512: IF trunc(p_new_start_date) <> trunc(nvl(l_pmschv_start(1).schedule_date,
3513: l_pmschv_start(1).schedule_date_from)) THEN
3514:
3515: okc_time_util_pub.get_duration(
3516: p_start_date => trunc(p_new_start_date),
3517: p_end_date => nvl(l_pmschv_start(1).schedule_date,
3518: l_pmschv_start(1).schedule_date_from) - 1,
3519: x_duration => l_duration,

Line 3543: l_prev_sch_date := trunc(okc_time_util_pub.get_enddate(l_prev_sch_date - 1,

3539: EXIT;
3540:
3541: END IF;
3542:
3543: l_prev_sch_date := trunc(okc_time_util_pub.get_enddate(l_prev_sch_date - 1,
3544: l_pmlrulv_tbl_start(1).frequency_uom,
3545: -1*(to_number(l_pmlrulv_tbl_start(1).frequency))));
3546:
3547: END LOOP;

Line 3866: l_next_sch_date := trunc(okc_time_util_pub.get_enddate(l_pmschv_end(1).schedule_date + 1,

3862:
3863: l_pmschvtbl_Ins.DELETE;
3864: pms_ins_ctr := 0;
3865:
3866: l_next_sch_date := trunc(okc_time_util_pub.get_enddate(l_pmschv_end(1).schedule_date + 1,
3867: l_pmlrulv_tbl_end(1).frequency_uom,
3868: to_number(l_pmlrulv_tbl_end(1).frequency)));
3869:
3870: WHILE 1 = 1 LOOP

Line 3891: l_next_sch_date := trunc(okc_time_util_pub.get_enddate(l_next_sch_date + 1,

3887: EXIT;
3888:
3889: END IF;
3890:
3891: l_next_sch_date := trunc(okc_time_util_pub.get_enddate(l_next_sch_date + 1,
3892: l_pmlrulv_tbl_end(1).frequency_uom,
3893: to_number(l_pmlrulv_tbl_end(1).frequency)));
3894:
3895: END LOOP;