DBA Data[Home] [Help]

APPS.OKS_BILL_UTIL_PUB dependencies on OKC_TIME_UTIL_PUB

Line 280: l_end_date := OKC_TIME_UTIL_PUB.GET_ENDDATE

276: l_level_periods := p_level_periods - 1;
277: END IF;
278:
279: IF l_level_periods > 0 THEN
280: l_end_date := OKC_TIME_UTIL_PUB.GET_ENDDATE
281: (p_start_date => l_next_start_date,
282: p_timeunit => p_uom_code,
283: p_duration => l_level_periods*l_duration
284: );

Line 550: l_next_billing_date := okc_time_util_pub.get_enddate

546: x_return_status := 'E';
547: return;
548: End if;
549:
550: l_next_billing_date := okc_time_util_pub.get_enddate
551: ( p_start_date => l_cycle_start_date,
552: p_timeunit => l_tuom_code,
553: p_duration => l_tuom_per_period
554: ) + 1 ;

Line 779: l_next_billing_date:= OKC_TIME_UTIL_PUB.GET_ENDDATE

775: l_next_date :=Last_day(TRUNC(Strm_Start_date))+ 1 ;
776: ELSE
777: l_next_date := Strm_Start_date;
778: END IF;
779: l_next_billing_date:= OKC_TIME_UTIL_PUB.GET_ENDDATE
780: (p_start_date => l_next_date,
781: p_timeunit => l_tuom_code,
782: p_duration => l_tuom_per_period
783: )+1;

Line 787: l_next_billing_date := OKC_TIME_UTIL_PUB.GET_ENDDATE

783: )+1;
784: /*Added for bug:9689805*/
785: /*Modified for bug:10140710*/
786: IF (l_next_billing_date <= l_cycle_start_date) THEN
787: l_next_billing_date := OKC_TIME_UTIL_PUB.GET_ENDDATE
788: (p_start_date => l_cycle_start_date,
789: p_timeunit => l_tuom_code,
790: p_duration => l_uom_per_period
791: )+1;

Line 800: l_next_billing_date := okc_time_util_pub.get_enddate

796: -------------------------------------------------------------------------
797: ELSE
798:
799: -- Start - Modified by PMALLARA - Bug #3992530
800: l_next_billing_date := okc_time_util_pub.get_enddate
801: ( p_start_date => Strm_Start_Date,
802: p_timeunit => l_tuom_code,
803: p_duration => l_tuom_per_period
804: ) + 1 ;

Line 809: l_next_billing_date := OKC_TIME_UTIL_PUB.GET_ENDDATE

805:
806: /*Added for bug:9689805*/
807: /*Modified for bug:10140710*/
808: IF (l_next_billing_date <=l_cycle_start_date) THEN
809: l_next_billing_date := OKC_TIME_UTIL_PUB.GET_ENDDATE
810: (p_start_date => l_cycle_start_date,
811: p_timeunit => l_tuom_code,
812: p_duration => l_uom_per_period
813: )+1;

Line 1032: -- l_bill_to_date := okc_time_util_pub.get_enddate(

1028: IF(l_terminated_date is NULL) THEN
1029: l_bill_to_date := l_end_date;
1030: --ELSIF ((l_terminated_date is NOT NULL) AND
1031: -- (trunc(l_start_date) = trunc(level_element_rec.date_start) )) THEN
1032: -- l_bill_to_date := okc_time_util_pub.get_enddate(
1033: -- to_date(level_element_rec.tp_start_date),
1034: -- l_advance_period ,
1035: -- l_tuom_quantity );
1036: ELSIF (l_terminated_date is NOT NULL) THEN

Line 1038: l_bill_to_date := okc_time_util_pub.get_enddate

1034: -- l_advance_period ,
1035: -- l_tuom_quantity );
1036: ELSIF (l_terminated_date is NOT NULL) THEN
1037: -- (trunc(l_start_date) <> trunc(level_element_rec.date_start) )) THEN
1038: l_bill_to_date := okc_time_util_pub.get_enddate
1039: (level_element_rec.date_start,
1040: l_advance_period ,
1041: l_tuom_quantity );
1042: END IF;