DBA Data[Home] [Help]

APPS.OKS_OMINT_PUB dependencies on OKC_TIME_UTIL_PUB

Line 157: OKC_TIME_UTIL_PUB.get_duration (

153: End if;
154: End Loop;
155: End if;
156:
157: OKC_TIME_UTIL_PUB.get_duration (
158: p_start_date => p_start_date,
159: p_end_date => x_new_end_date,
160: x_duration => x_service_duration,
161: x_timeunit => x_service_period,

Line 171: x_new_end_date := OKC_TIME_UTIL_PUB.GET_ENDDATE

167: End if;
168: Else
169:
170: If p_end_date is null then
171: x_new_end_date := OKC_TIME_UTIL_PUB.GET_ENDDATE
172: (
173: p_start_date => p_start_date,
174: p_timeunit => l_unit_of_measure,
175: p_duration => p_service_duration

Line 187: x_new_end_date := OKC_TIME_UTIL_PUB.get_enddate

183: if months_between(x_new_end_date,p_start_date) < l_min_duration then
184: Open l_tce_csr('MONTH',1);
185: Fetch l_tce_csr into l_tce_rec;
186: Close l_tce_csr;
187: x_new_end_date := OKC_TIME_UTIL_PUB.get_enddate
188: (
189: p_start_date => p_start_date,
190: p_duration => l_min_duration,
191: p_timeunit => l_tce_rec.uom_code

Line 199: x_new_end_date := OKC_TIME_UTIL_PUB.get_enddate

195: If (x_new_end_date - p_start_Date) < l_min_duration then
196: Open l_tce_csr('DAY',1);
197: Fetch l_tce_csr into l_tce_rec;
198: Close l_tce_csr;
199: x_new_end_date := OKC_TIME_UTIL_PUB.get_enddate
200: (
201: p_start_date => p_start_date,
202: p_duration => l_min_duration,
203: p_timeunit => l_tce_rec.uom_code

Line 211: x_new_end_date := OKC_TIME_UTIL_PUB.get_enddate

207: If months_between(x_new_end_date,p_start_date) < (l_min_duration * 12) then
208: Open l_tce_csr('YEAR',1);
209: Fetch l_tce_csr into l_tce_rec;
210: Close l_tce_csr;
211: x_new_end_date := OKC_TIME_UTIL_PUB.get_enddate
212: (
213: p_start_date => p_start_date,
214: p_duration => l_min_duration,
215: p_timeunit => l_tce_rec.uom_code

Line 220: OKC_TIME_UTIL_PUB.get_duration (

216: );
217: End if;
218: End if;
219:
220: OKC_TIME_UTIL_PUB.get_duration (
221: p_start_date => p_start_date,
222: p_end_date => x_new_end_date,
223: x_duration => x_service_duration,
224: x_timeunit => x_service_period,

Line 1552: X_end_date := okc_time_util_pub.get_enddate

1548: l_return_status := 'E';
1549: OKC_API.set_message(G_APP_NAME,'OKS_NULL_SDT','LINE_ID',p_order_line_id);
1550: Raise G_EXCEPTION_HALT_VALIDATION;
1551: End If;
1552: X_end_date := okc_time_util_pub.get_enddate
1553: ( X_Start_Date
1554: ,l_line_rec.service_period
1555: ,l_line_rec.service_duration
1556: );