APPS.OKS_BILL_MIGRATION dependencies on OKC_TIME_UTIL_PUB

Line 833: OKC_TIME_UTIL_PUB.get_duration(

829: l_tbl_ctr := 0;
830: l_duration := NULL;
831: l_time := NULL;
832:
833: OKC_TIME_UTIL_PUB.get_duration(
834: top_line_grp_rec.start_date
835: ,l_max_date_billed_to
836: ,l_duration
837: ,l_time

Line 863: OKC_TIME_UTIL_PUB.get_duration(

859: IF l_max_date_billed_to + 1 <= top_line_grp_rec.end_date THEN
860: l_duration := NULL;
861: l_time := NULL;
862:
863: OKC_TIME_UTIL_PUB.get_duration(
864: l_max_date_billed_to +1
865: ,top_line_grp_rec.end_date
866: ,l_duration
867: ,l_time

Line 903: OKC_TIME_UTIL_PUB.get_duration(

899: l_tbl_ctr := 0;
900: l_duration := NULL;
901: l_time := NULL;
902:
903: OKC_TIME_UTIL_PUB.get_duration(
904: top_line_grp_rec.start_date
905: ,top_line_grp_rec.end_date
906: ,l_duration
907: ,l_time

Line 1626: okc_time_util_pub.get_duration(

1622:
1623: l_start_date := l_start_dt(i);
1624: l_end_date := TRUNC(TO_DATE(SUBSTR(rules_rec.rule_information3,1,21),'YYYY/MM/DD HH24:MI:SS'));
1625:
1626: okc_time_util_pub.get_duration(
1627: p_start_date => l_start_date,
1628: p_end_date => l_end_date,
1629: x_duration => l_duration,
1630: x_timeunit => l_time,

Line 1672: l_end_date := okc_time_util_pub.get_enddate

1668: IF l_end_dt(i) > l_end_date THEN
1669:
1670: IF l_flag = 'T' THEN
1671:
1672: l_end_date := okc_time_util_pub.get_enddate
1673: (l_end_date
1674: ,rules_rec.rule_information2
1675: ,1);
1676: l_end_date := TRUNC(l_end_date);

Line 1680: l_end_date := okc_time_util_pub.get_enddate

1676: l_end_date := TRUNC(l_end_date);
1677: l_flag := 'F';
1678:
1679: ELSE
1680: l_end_date := okc_time_util_pub.get_enddate
1681: (l_end_date + 1
1682: ,rules_rec.rule_information2
1683: ,1);
1684: l_end_date := TRUNC(l_end_date);

Line 1692: okc_time_util_pub.get_duration(

1688: --(1) check line end date is less than calculate rule end date
1689: IF l_end_dt(i) < l_end_date THEN
1690:
1691: l_end_date := l_end_dt(i);
1692: okc_time_util_pub.get_duration(
1693: p_start_date => l_start_date,
1694: p_end_date => l_end_date,
1695: x_duration => l_duration,
1696: x_timeunit => l_time,

Line 1726: okc_time_util_pub.get_duration(

1722: IF l_end_dt(i) = l_end_date THEN
1723:
1724: IF l_ctr = 0 THEN
1725:
1726: okc_time_util_pub.get_duration(
1727: p_start_date => l_start_date,
1728: p_end_date => l_end_date,
1729: x_duration => l_duration,
1730: x_timeunit => l_time,

Line 1764: okc_time_util_pub.get_duration(

1760:
1761: -- check line end date is greater than rule end date
1762: IF l_end_dt(i) > l_end_date THEN
1763: IF l_ctr = 0 THEN
1764: okc_time_util_pub.get_duration(
1765: p_start_date => l_start_date,
1766: p_end_date => l_end_date,
1767: x_duration => l_duration,
1768: x_timeunit => l_time,