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.OKC_COPY_CONTRACT_PVT dependencies on OKC_TIME_UTIL_PUB

Line 2799: l_col_vals okc_time_util_pub.t_col_vals;

2795: l_old_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2796: l_cle_id NUMBER := OKC_API.G_MISS_NUM;
2797: l_tve_id NUMBER;
2798: l_tve_id_out NUMBER;
2799: l_col_vals okc_time_util_pub.t_col_vals;
2800: l_col_vals_temp okc_time_util_pub.t_col_vals;
2801: l_no_of_cols NUMBER;
2802: l_string VARCHAR2(2000);
2803: l_time_value_copied VARCHAR2(1):= 'Y';

Line 2800: l_col_vals_temp okc_time_util_pub.t_col_vals;

2796: l_cle_id NUMBER := OKC_API.G_MISS_NUM;
2797: l_tve_id NUMBER;
2798: l_tve_id_out NUMBER;
2799: l_col_vals okc_time_util_pub.t_col_vals;
2800: l_col_vals_temp okc_time_util_pub.t_col_vals;
2801: l_no_of_cols NUMBER;
2802: l_string VARCHAR2(2000);
2803: l_time_value_copied VARCHAR2(1):= 'Y';
2804: i NUMBER := 0;

Line 3021: -- okc_time_util_pub.get_dff_column_values( p_app_id => 510, -- /striping/

3017: -- /striping/
3018: p_appl_id := okc_rld_pvt.get_appl_id(l_c_rulv.rule_information_category);
3019: p_dff_name := okc_rld_pvt.get_dff_name(l_c_rulv.rule_information_category);
3020:
3021: -- okc_time_util_pub.get_dff_column_values( p_app_id => 510, -- /striping/
3022: okc_time_util_pub.get_dff_column_values( p_app_id => p_appl_id,
3023: -- p_dff_name => 'OKC Rule Developer DF', -- /striping/
3024: p_dff_name => p_dff_name,
3025: p_rdf_code => l_c_rulv.rule_information_category,

Line 3022: okc_time_util_pub.get_dff_column_values( p_app_id => p_appl_id,

3018: p_appl_id := okc_rld_pvt.get_appl_id(l_c_rulv.rule_information_category);
3019: p_dff_name := okc_rld_pvt.get_dff_name(l_c_rulv.rule_information_category);
3020:
3021: -- okc_time_util_pub.get_dff_column_values( p_app_id => 510, -- /striping/
3022: okc_time_util_pub.get_dff_column_values( p_app_id => p_appl_id,
3023: -- p_dff_name => 'OKC Rule Developer DF', -- /striping/
3024: p_dff_name => p_dff_name,
3025: p_rdf_code => l_c_rulv.rule_information_category,
3026: p_fvs_name => 'OKC_TIMEVALUES',

Line 12352: OKC_TIME_UTIL_PUB.get_duration(p_start_date => l_hdr_start_date, -- Template Hdr Start Date

12348: okc_debug.log('1050: End Date is NULL');
12349: END IF;
12350: -- Need to derive the end date based on template start date and UI start date
12351:
12352: OKC_TIME_UTIL_PUB.get_duration(p_start_date => l_hdr_start_date, -- Template Hdr Start Date
12353: p_end_date => l_hdr_end_date,
12354: x_duration => l_hdr_duration,
12355: x_timeunit => l_hdr_timeunit,
12356: x_return_status => l_return_status);

Line 12363: okc_debug.log('1060: after OKC_TIME_UTIL_PUB.get_duration Call');

12359: RAISE G_EXCEPTION_HALT_VALIDATION;
12360: END IF;
12361:
12362: IF (l_debug = 'Y') THEN
12363: okc_debug.log('1060: after OKC_TIME_UTIL_PUB.get_duration Call');
12364: END IF;
12365: -- Get the new end date for header
12366: l_hdr_end_date := OKC_TIME_UTIL_PUB.get_enddate(p_start_date => p_start_date,
12367: p_timeunit => l_hdr_timeunit,

Line 12366: l_hdr_end_date := OKC_TIME_UTIL_PUB.get_enddate(p_start_date => p_start_date,

12362: IF (l_debug = 'Y') THEN
12363: okc_debug.log('1060: after OKC_TIME_UTIL_PUB.get_duration Call');
12364: END IF;
12365: -- Get the new end date for header
12366: l_hdr_end_date := OKC_TIME_UTIL_PUB.get_enddate(p_start_date => p_start_date,
12367: p_timeunit => l_hdr_timeunit,
12368: p_duration => l_hdr_duration);
12369: IF (l_debug = 'Y') THEN
12370: okc_debug.log('1065: after OKC_TIME_UTIL_PUB.get_end date Call'||l_hdr_end_date);

Line 12370: okc_debug.log('1065: after OKC_TIME_UTIL_PUB.get_end date Call'||l_hdr_end_date);

12366: l_hdr_end_date := OKC_TIME_UTIL_PUB.get_enddate(p_start_date => p_start_date,
12367: p_timeunit => l_hdr_timeunit,
12368: p_duration => l_hdr_duration);
12369: IF (l_debug = 'Y') THEN
12370: okc_debug.log('1065: after OKC_TIME_UTIL_PUB.get_end date Call'||l_hdr_end_date);
12371: END IF;
12372:
12373:
12374: l_chrv_rec.id := p_chr_id;

Line 12422: OKC_TIME_UTIL_PUB.get_duration(p_start_date => l_hdr_start_date,

12418: -- Get the duratio b/n header start date and Line start date
12419: IF ( TRUNC(l_est_date) <= TRUNC(l_hdr_start_date) ) THEN
12420: l_khrv_tbl_in(1).est_rev_date := p_start_date;
12421: ELSE
12422: OKC_TIME_UTIL_PUB.get_duration(p_start_date => l_hdr_start_date,
12423: p_end_date => l_est_date -1,
12424: x_duration => l_hdr_est_duration,
12425: x_timeunit => l_hdr_est_timeunit,
12426: x_return_status => l_return_status);

Line 12429: l_start_date := OKC_TIME_UTIL_PUB.get_enddate(p_start_date => p_start_date + 1,

12425: x_timeunit => l_hdr_est_timeunit,
12426: x_return_status => l_return_status);
12427:
12428: -- Get the line start date based on new start date
12429: l_start_date := OKC_TIME_UTIL_PUB.get_enddate(p_start_date => p_start_date + 1,
12430: p_timeunit => l_hdr_est_timeunit,
12431: p_duration => l_hdr_est_duration);
12432: l_khrv_tbl_in(1).est_rev_date:= l_start_date;
12433: END IF;

Line 12484: OKC_TIME_UTIL_PUB.get_duration(p_start_date => line_rec.start_date,

12480: FOR line_rec IN get_contract_lines_csr(p_chr_id)
12481: LOOP
12482:
12483: -- Get the line duration
12484: OKC_TIME_UTIL_PUB.get_duration(p_start_date => line_rec.start_date,
12485: p_end_date => line_rec.end_date,
12486: x_duration => l_line_duration,
12487: x_timeunit => l_line_timeunit,
12488: x_return_status => l_return_status);

Line 12506: OKC_TIME_UTIL_PUB.get_duration(p_start_date => l_hdr_start_date,

12502: okc_debug.log('1100: Line start date and hdr date is different. '|| line_rec.id);
12503: END IF;
12504:
12505: -- Get the duratio b/n header start date and Line start date
12506: OKC_TIME_UTIL_PUB.get_duration(p_start_date => l_hdr_start_date,
12507: p_end_date => line_rec.start_date-1,
12508: x_duration => l_hdr_line_duration,
12509: x_timeunit => l_hdr_line_timeunit,
12510: x_return_status => l_return_status);

Line 12513: l_start_date := OKC_TIME_UTIL_PUB.get_enddate(p_start_date => p_start_date + 1,

12509: x_timeunit => l_hdr_line_timeunit,
12510: x_return_status => l_return_status);
12511:
12512: -- Get the line start date based on new start date
12513: l_start_date := OKC_TIME_UTIL_PUB.get_enddate(p_start_date => p_start_date + 1,
12514: p_timeunit => l_hdr_line_timeunit,
12515: p_duration => l_hdr_line_duration);
12516:
12517: l_end_date := OKC_TIME_UTIL_PUB.get_enddate(p_start_date => l_start_date,

Line 12517: l_end_date := OKC_TIME_UTIL_PUB.get_enddate(p_start_date => l_start_date,

12513: l_start_date := OKC_TIME_UTIL_PUB.get_enddate(p_start_date => p_start_date + 1,
12514: p_timeunit => l_hdr_line_timeunit,
12515: p_duration => l_hdr_line_duration);
12516:
12517: l_end_date := OKC_TIME_UTIL_PUB.get_enddate(p_start_date => l_start_date,
12518: p_timeunit => l_line_timeunit,
12519: p_duration => l_line_duration);
12520:
12521: ELSE

Line 12526: l_end_date := OKC_TIME_UTIL_PUB.get_enddate(p_start_date => l_start_date,

12522: IF (l_debug = 'Y') THEN
12523: okc_debug.log('1110: Line start date and hdr start date is same. '|| line_rec.id);
12524: END IF;
12525: l_start_date := p_start_date;
12526: l_end_date := OKC_TIME_UTIL_PUB.get_enddate(p_start_date => l_start_date,
12527: p_timeunit => l_line_timeunit,
12528: p_duration => l_line_duration);
12529: END IF;
12530:

Line 12719: OKC_TIME_UTIL_PUB.get_duration(p_start_date => topline_rec.start_date

12715: l_slh_rec.jtot_object2_code := 'OKS_TIMEVAL';
12716: --l_slh_rec.rule_information_category := 'SLH';
12717:
12718: --sll
12719: OKC_TIME_UTIL_PUB.get_duration(p_start_date => topline_rec.start_date
12720: , p_end_date => topline_rec.end_date
12721: , x_duration => l_duration
12722: , x_timeunit => l_timeunit
12723: , x_return_status => x_return_status);