DBA Data[Home] [Help]

APPS.OKC_COPY_CONTRACT_PVT dependencies on OKC_TIME_UTIL_PUB

Line 2800: l_col_vals okc_time_util_pub.t_col_vals;

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

Line 2801: l_col_vals_temp okc_time_util_pub.t_col_vals;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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