DBA Data[Home] [Help]

APPS.OKI_DBI_UTIL_PVT dependencies on FII_TIME_API

Line 25: l_date := fii_time_api.ent_cyr_start (as_of_date);

21: l_date DATE;
22: BEGIN
23: IF (period_type = 'YTD')
24: THEN
25: l_date := fii_time_api.ent_cyr_start (as_of_date);
26: ELSIF (period_type = 'QTD')
27: THEN
28: l_date := fii_time_api.ent_cqtr_start (as_of_date);
29: ELSIF (period_type = 'MTD')

Line 28: l_date := fii_time_api.ent_cqtr_start (as_of_date);

24: THEN
25: l_date := fii_time_api.ent_cyr_start (as_of_date);
26: ELSIF (period_type = 'QTD')
27: THEN
28: l_date := fii_time_api.ent_cqtr_start (as_of_date);
29: ELSIF (period_type = 'MTD')
30: THEN
31: l_date := fii_time_api.ent_cper_start (as_of_date);
32: ELSIF (period_type = 'WTD')

Line 31: l_date := fii_time_api.ent_cper_start (as_of_date);

27: THEN
28: l_date := fii_time_api.ent_cqtr_start (as_of_date);
29: ELSIF (period_type = 'MTD')
30: THEN
31: l_date := fii_time_api.ent_cper_start (as_of_date);
32: ELSIF (period_type = 'WTD')
33: THEN
34: l_date := fii_time_api.cwk_start (as_of_date);
35: END IF;

Line 34: l_date := fii_time_api.cwk_start (as_of_date);

30: THEN
31: l_date := fii_time_api.ent_cper_start (as_of_date);
32: ELSIF (period_type = 'WTD')
33: THEN
34: l_date := fii_time_api.cwk_start (as_of_date);
35: END IF;
36:
37: RETURN l_date;
38: EXCEPTION

Line 64: l_date := fii_time_api.ent_cyr_end (as_of_date);

60: l_date DATE;
61: BEGIN
62: IF (period_type = 'YTD')
63: THEN
64: l_date := fii_time_api.ent_cyr_end (as_of_date);
65: ELSIF (period_type = 'QTD')
66: THEN
67: l_date := fii_time_api.ent_cqtr_end (as_of_date);
68: ELSIF (period_type = 'MTD')

Line 67: l_date := fii_time_api.ent_cqtr_end (as_of_date);

63: THEN
64: l_date := fii_time_api.ent_cyr_end (as_of_date);
65: ELSIF (period_type = 'QTD')
66: THEN
67: l_date := fii_time_api.ent_cqtr_end (as_of_date);
68: ELSIF (period_type = 'MTD')
69: THEN
70: l_date := fii_time_api.ent_cper_end (as_of_date);
71: ELSIF (period_type = 'WTD')

Line 70: l_date := fii_time_api.ent_cper_end (as_of_date);

66: THEN
67: l_date := fii_time_api.ent_cqtr_end (as_of_date);
68: ELSIF (period_type = 'MTD')
69: THEN
70: l_date := fii_time_api.ent_cper_end (as_of_date);
71: ELSIF (period_type = 'WTD')
72: THEN
73: l_date := fii_time_api.cwk_end (as_of_date);
74: END IF;

Line 73: l_date := fii_time_api.cwk_end (as_of_date);

69: THEN
70: l_date := fii_time_api.ent_cper_end (as_of_date);
71: ELSIF (period_type = 'WTD')
72: THEN
73: l_date := fii_time_api.cwk_end (as_of_date);
74: END IF;
75:
76: RETURN l_date;
77: EXCEPTION

Line 179: l_date := fii_time_api.ent_cyr_start (as_of_date);

175: WHERE as_of_date BETWEEN start_date AND end_date;
176:
177: IF (l_curr_qtr = 4)
178: THEN
179: l_date := fii_time_api.ent_cyr_start (as_of_date);
180: ELSE
181: SELECT start_date
182: INTO l_date
183: FROM fii_time_ent_qtr

Line 275: l_date := fii_time_api.ent_sd_lyr_end (as_of_date);

271: l_date DATE;
272: BEGIN
273: IF (period_type = 'YTD')
274: THEN
275: l_date := fii_time_api.ent_sd_lyr_end (as_of_date);
276: ELSIF (period_type = 'QTD')
277: THEN
278: IF (comparison_type = 'Y')
279: THEN

Line 280: l_date := fii_time_api.ent_sd_lysqtr_end (as_of_date);

276: ELSIF (period_type = 'QTD')
277: THEN
278: IF (comparison_type = 'Y')
279: THEN
280: l_date := fii_time_api.ent_sd_lysqtr_end (as_of_date);
281: ELSE
282: l_date := fii_time_api.ent_sd_pqtr_end (as_of_date);
283: END IF;
284: ELSIF (period_type = 'MTD')

Line 282: l_date := fii_time_api.ent_sd_pqtr_end (as_of_date);

278: IF (comparison_type = 'Y')
279: THEN
280: l_date := fii_time_api.ent_sd_lysqtr_end (as_of_date);
281: ELSE
282: l_date := fii_time_api.ent_sd_pqtr_end (as_of_date);
283: END IF;
284: ELSIF (period_type = 'MTD')
285: THEN
286: IF (comparison_type = 'Y')

Line 288: l_date := fii_time_api.ent_sd_lysper_end (as_of_date);

284: ELSIF (period_type = 'MTD')
285: THEN
286: IF (comparison_type = 'Y')
287: THEN
288: l_date := fii_time_api.ent_sd_lysper_end (as_of_date);
289: ELSE
290: l_date := fii_time_api.ent_sd_pper_end (as_of_date);
291: END IF;
292: ELSIF (period_type = 'WTD')

Line 290: l_date := fii_time_api.ent_sd_pper_end (as_of_date);

286: IF (comparison_type = 'Y')
287: THEN
288: l_date := fii_time_api.ent_sd_lysper_end (as_of_date);
289: ELSE
290: l_date := fii_time_api.ent_sd_pper_end (as_of_date);
291: END IF;
292: ELSIF (period_type = 'WTD')
293: THEN
294: IF (comparison_type = 'Y')

Line 296: l_date := fii_time_api.sd_lyswk (as_of_date);

292: ELSIF (period_type = 'WTD')
293: THEN
294: IF (comparison_type = 'Y')
295: THEN
296: l_date := fii_time_api.sd_lyswk (as_of_date);
297: ELSE
298: l_date := fii_time_api.sd_pwk (as_of_date);
299: END IF;
300: END IF;

Line 298: l_date := fii_time_api.sd_pwk (as_of_date);

294: IF (comparison_type = 'Y')
295: THEN
296: l_date := fii_time_api.sd_lyswk (as_of_date);
297: ELSE
298: l_date := fii_time_api.sd_pwk (as_of_date);
299: END IF;
300: END IF;
301:
302: RETURN l_date;