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

Line 145: OKC_TIME_UTIL_PUB.get_duration(Auto_renew_rec.start_date,

141: l_timeunit := p_uom_code;
142: l_return_status := OKC_API.G_RET_STS_SUCCESS;
143: Else
144:
145: OKC_TIME_UTIL_PUB.get_duration(Auto_renew_rec.start_date,
146: auto_renew_rec.END_date,
147: l_duration,
148: l_timeunit,
149: l_return_status);

Line 820: l_col_vals OKC_TIME_UTIL_PUB.T_COL_VALS;

816: CURSOR cur_ia(p_tve_id number) is
817: SELECT start_date ,end_date FROM okc_time_ia_startend_val_v
818: WHERE id = p_tve_id for update of id nowait;
819:
820: l_col_vals OKC_TIME_UTIL_PUB.T_COL_VALS;
821: tmp_rulv_rec OKC_RULE_PUB.rulv_rec_type;
822: l_no_of_cols number;
823:
824: E_Resource_Busy EXCEPTION;

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

1051: p_appl_id := okc_rld_pvt.get_appl_id(rule_rec.rule_information_category);
1052: p_dff_name := okc_rld_pvt.get_dff_name(rule_rec.rule_information_category);
1053:
1054: -- okc_debug.log('3400: Before get_dff_column_values');
1055: -- okc_time_util_pub.get_dff_column_values( p_app_id => 510, -- /striping/
1056: okc_time_util_pub.get_dff_column_values( p_app_id => p_appl_id,
1057: -- p_dff_name => 'OKC Rule Developer DF', -- /striping/
1058: p_dff_name => p_dff_name,
1059: p_rdf_code => rule_rec.rule_information_category,

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

1052: p_dff_name := okc_rld_pvt.get_dff_name(rule_rec.rule_information_category);
1053:
1054: -- okc_debug.log('3400: Before get_dff_column_values');
1055: -- okc_time_util_pub.get_dff_column_values( p_app_id => 510, -- /striping/
1056: okc_time_util_pub.get_dff_column_values( p_app_id => p_appl_id,
1057: -- p_dff_name => 'OKC Rule Developer DF', -- /striping/
1058: p_dff_name => p_dff_name,
1059: p_rdf_code => rule_rec.rule_information_category,
1060: p_fvs_name => 'FND_STANDARD_DATE',

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

1076: p_appl_id := okc_rld_pvt.get_appl_id(rule_rec.rule_information_category);
1077: p_dff_name := okc_rld_pvt.get_dff_name(rule_rec.rule_information_category);
1078:
1079: -- okc_debug.log('3600: Before get_dff_column_values');
1080: -- okc_time_util_pub.get_dff_column_values( p_app_id => 510, -- /striping/
1081: okc_time_util_pub.get_dff_column_values( p_app_id => p_appl_id,
1082: -- p_dff_name => 'OKC Rule Developer DF', -- /striping/
1083: p_dff_name => p_dff_name,
1084: p_rdf_code => rule_rec.rule_information_category,

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

1077: p_dff_name := okc_rld_pvt.get_dff_name(rule_rec.rule_information_category);
1078:
1079: -- okc_debug.log('3600: Before get_dff_column_values');
1080: -- okc_time_util_pub.get_dff_column_values( p_app_id => 510, -- /striping/
1081: okc_time_util_pub.get_dff_column_values( p_app_id => p_appl_id,
1082: -- p_dff_name => 'OKC Rule Developer DF', -- /striping/
1083: p_dff_name => p_dff_name,
1084: p_rdf_code => rule_rec.rule_information_category,
1085: p_fvs_name => 'OKC_TIMEVALUES',

Line 2056: -- okc_time_util_pub.get_duration(l_parent_orig_start_date,lines_rec.start_date, l_duration,l_uom_code,l_return_status);

2052: END IF; -- cle_id is null
2053: ELSIF l_cle_renew_type = 'KEP' then
2054: -- Bug#2249285: Replaced get_duration with oracle_months_and_days
2055: --
2056: -- okc_time_util_pub.get_duration(l_parent_orig_start_date,lines_rec.start_date, l_duration,l_uom_code,l_return_status);
2057: okc_time_util_pvt.get_oracle_months_and_days(l_parent_orig_start_date,lines_rec.start_date, l_duration,l_additional_days,l_return_status);
2058:
2059: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
2060: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2070: -- l_cle_rec.start_date := okc_time_util_pub.get_ENDdate(l_parent_start_date,l_uom_code,l_duration);

2066: END IF;
2067:
2068: -- Bug#2249285: Changed to add_months + days for offset calculations.
2069: --
2070: -- l_cle_rec.start_date := okc_time_util_pub.get_ENDdate(l_parent_start_date,l_uom_code,l_duration);
2071: --
2072: l_cle_rec.start_date := ADD_MONTHS(l_parent_Start_date, l_duration) + l_additional_days;
2073:
2074: -- For perpetual contracts, the parent may not have any end date

Line 2077: -- okc_time_util_pub.get_duration(l_parent_orig_start_date,

2073:
2074: -- For perpetual contracts, the parent may not have any end date
2075: IF l_cle_rec.start_date <= nvl(l_parent_end_date,l_cle_rec.start_date) then
2076: -- Bug#2249285: Replaced get_duration with oracle_months_and_days
2077: -- okc_time_util_pub.get_duration(l_parent_orig_start_date,
2078: -- lines_rec.end_date,l_duration,l_uom_code,l_return_status);
2079: l_duration := 0;
2080: l_additional_days := 0;
2081: okc_time_util_pvt.get_oracle_months_and_days(l_parent_orig_start_date,lines_rec.end_date, l_duration,l_additional_days,l_return_status);

Line 2093: -- l_cle_rec.END_date := okc_time_util_pub.get_ENDdate(l_parent_start_date, l_uom_code,l_duration);

2089: END IF;
2090: -- Bug#2249285: Changed to add_months + days for offset calculations.
2091:
2092: --
2093: -- l_cle_rec.END_date := okc_time_util_pub.get_ENDdate(l_parent_start_date, l_uom_code,l_duration);
2094:
2095: l_cle_rec.end_date := add_months(l_parent_Start_date, l_duration) + l_additional_days;
2096:
2097: IF l_cle_rec.end_date > nvl(l_parent_end_date,l_cle_rec.end_date) then

Line 3069: okc_time_util_pub.get_duration(p_renew_in_rec.p_start_date,

3065: p_renew_in_rec.p_end_date := l_ultimate_end_date;
3066: --
3067: -- Recalculate the UOM Code and the duration based on this
3068: -- new date.
3069: okc_time_util_pub.get_duration(p_renew_in_rec.p_start_date,
3070: p_renew_in_rec.p_end_date,
3071: p_renew_in_rec.p_duration,
3072: p_renew_in_rec.p_uom_code,
3073: l_return_status);

Line 3106: p_renew_in_rec.p_end_date := okc_time_util_pub.get_enddate

3102: -- calculate new end date if not provided else calculate duration and uom code
3103: If p_renew_in_rec.p_perpetual_flag = OKC_API.G_FALSE OR
3104: p_renew_in_parameters_rec.p_perpetual_flag IS NULL Then
3105: If p_renew_in_rec.p_end_date is null then
3106: p_renew_in_rec.p_end_date := okc_time_util_pub.get_enddate
3107: (p_renew_in_rec.p_start_date,
3108: p_renew_in_rec.p_uom_code,
3109: p_renew_in_rec.p_duration);
3110: --

Line 3125: okc_time_util_pub.get_duration(p_renew_in_rec.p_start_date,

3121: If l_return_status <> okc_api.g_ret_sts_success then
3122: return (l_return_status);
3123: End If;
3124: If p_renew_in_rec.p_uom_code is null OR p_renew_in_rec.p_duration is null then
3125: okc_time_util_pub.get_duration(p_renew_in_rec.p_start_date,
3126: p_renew_in_rec.p_end_date,
3127: p_renew_in_rec.p_duration,
3128: p_renew_in_rec.p_uom_code,
3129: l_return_status);