APPS.OKS_TIME_MEASURES_PUB dependencies on OKC_TIME_UTIL_PUB

Line 209: l_end_date := okc_time_util_pub.get_enddate(p_start_date,p_source_uom,p_source_qty);

205: ELSE
206: IF p_start_date IS NOT NULL
207: THEN
208: l_start_date := p_start_date;
209: l_end_date := okc_time_util_pub.get_enddate(p_start_date,p_source_uom,p_source_qty);
210: ELSE
211: l_start_date := sysdate;
212: l_end_date := okc_time_util_pub.get_enddate(sysdate,p_source_uom,p_source_qty);
213: END IF;

Line 212: l_end_date := okc_time_util_pub.get_enddate(sysdate,p_source_uom,p_source_qty);

208: l_start_date := p_start_date;
209: l_end_date := okc_time_util_pub.get_enddate(p_start_date,p_source_uom,p_source_qty);
210: ELSE
211: l_start_date := sysdate;
212: l_end_date := okc_time_util_pub.get_enddate(sysdate,p_source_uom,p_source_qty);
213: END IF;
214:
215: l_no_days := l_end_date - l_start_date+1;
216:

Line 339: l_target_qty := (okc_time_util_pub.get_enddate(nvl(p_start_date,SYSDATE),p_source_uom,p_source_qty)-nvl(p_start_date,SYSDATE)+1)

335: bugno:4255530
336: */
337: IF (nvl(l_target_qty,0) =0 AND p_source_qty <> 0)
338: THEN
339: l_target_qty := (okc_time_util_pub.get_enddate(nvl(p_start_date,SYSDATE),p_source_uom,p_source_qty)-nvl(p_start_date,SYSDATE)+1)
340: /(okc_time_util_pub.get_enddate(nvl(p_start_date,SYSDATE),p_target_uom,1)-nvl(p_start_date,SYSDATE)+1);
341: END IF;
342: -- End bugno:4255530
343: END IF;

Line 340: /(okc_time_util_pub.get_enddate(nvl(p_start_date,SYSDATE),p_target_uom,1)-nvl(p_start_date,SYSDATE)+1);

336: */
337: IF (nvl(l_target_qty,0) =0 AND p_source_qty <> 0)
338: THEN
339: l_target_qty := (okc_time_util_pub.get_enddate(nvl(p_start_date,SYSDATE),p_source_uom,p_source_qty)-nvl(p_start_date,SYSDATE)+1)
340: /(okc_time_util_pub.get_enddate(nvl(p_start_date,SYSDATE),p_target_uom,1)-nvl(p_start_date,SYSDATE)+1);
341: END IF;
342: -- End bugno:4255530
343: END IF;
344:

Line 395: okc_time_util_pub.get_duration(p_start_date,p_end_date,l_duration,l_timeunit,x_return_status);

391: x_return_status := OKC_API.G_RET_STS_ERROR;
392: return;
393: end if;
394:
395: okc_time_util_pub.get_duration(p_start_date,p_end_date,l_duration,l_timeunit,x_return_status);
396: if x_return_status <> OKC_API.G_RET_STS_SUCCESS then
397: l_duration := NULL;
398: l_timeunit := NULL;
399: end if;

Line 605: okc_time_util_pub.get_duration (

601: p_period_type,
602: 18);
603: ELSE
604:
605: okc_time_util_pub.get_duration (
606: p_start_date => l_start_date,
607: p_end_date => l_end_date,
608: x_duration => l_source_qty,
609: x_timeunit => l_period_uom_code,

Line 1014: l_months_in_uom := months_between(OKC_TIME_UTIL_PUB.get_enddate(TRUNC(p_start_date,'MM'),p_price_uom,1)+1 ,TRUNC(p_start_date,'MM'));

1010: IF x_return_status <> 'S' THEN
1011: RAISE INVALID_UOM_EXCEPTION;
1012: END IF;
1013: --The following logic is to get other uoms conversion factor in Month
1014: l_months_in_uom := months_between(OKC_TIME_UTIL_PUB.get_enddate(TRUNC(p_start_date,'MM'),p_price_uom,1)+1 ,TRUNC(p_start_date,'MM'));
1015: IF(l_months_in_uom <1 AND l_tce_code='DAY')
1016: THEN
1017: l_days_in_partial_period := (p_end_date+1)- p_start_date;
1018: --l_days_in_uom := (OKC_TIME_UTIL_PUB.get_enddate(p_start_date,p_price_uom,1)+1) - p_start_date;

Line 1018: --l_days_in_uom := (OKC_TIME_UTIL_PUB.get_enddate(p_start_date,p_price_uom,1)+1) - p_start_date;

1014: l_months_in_uom := months_between(OKC_TIME_UTIL_PUB.get_enddate(TRUNC(p_start_date,'MM'),p_price_uom,1)+1 ,TRUNC(p_start_date,'MM'));
1015: IF(l_months_in_uom <1 AND l_tce_code='DAY')
1016: THEN
1017: l_days_in_partial_period := (p_end_date+1)- p_start_date;
1018: --l_days_in_uom := (OKC_TIME_UTIL_PUB.get_enddate(p_start_date,p_price_uom,1)+1) - p_start_date;
1019: l_days_in_uom := l_uom_quantity;
1020: l_partial_period := l_days_in_partial_period/l_days_in_uom;
1021: ELSE
1022: l_full_months := floor(months_between(p_end_date+1,p_start_date));