APPS.FII_GL_EXPENSE_PKG_TREND dependencies on FII_TIME_API

Line 29: fii_gl_util_pkg.g_cy_period_end := fii_time_api.pwk_end(trunc(sysdate));

25: fii_gl_util_pkg.g_viewby_type := 'TIME+FII_TIME_WEEK';
26:
27: /* Commented out for bug 3893359 and replaced with select
28:
29: fii_gl_util_pkg.g_cy_period_end := fii_time_api.pwk_end(trunc(sysdate));
30: fii_gl_util_pkg.g_py_sday := fii_time_api.sd_lyswk(trunc(sysdate)); */
31:
32: select NVL(fii_time_api.pwk_end(trunc(sysdate)),g_min_start_date),
33: NVL(fii_time_api.sd_lyswk(trunc(sysdate)),g_min_start_date)

Line 30: fii_gl_util_pkg.g_py_sday := fii_time_api.sd_lyswk(trunc(sysdate)); */

26:
27: /* Commented out for bug 3893359 and replaced with select
28:
29: fii_gl_util_pkg.g_cy_period_end := fii_time_api.pwk_end(trunc(sysdate));
30: fii_gl_util_pkg.g_py_sday := fii_time_api.sd_lyswk(trunc(sysdate)); */
31:
32: select NVL(fii_time_api.pwk_end(trunc(sysdate)),g_min_start_date),
33: NVL(fii_time_api.sd_lyswk(trunc(sysdate)),g_min_start_date)
34: INTO fii_gl_util_pkg.g_cy_period_end,

Line 32: select NVL(fii_time_api.pwk_end(trunc(sysdate)),g_min_start_date),

28:
29: fii_gl_util_pkg.g_cy_period_end := fii_time_api.pwk_end(trunc(sysdate));
30: fii_gl_util_pkg.g_py_sday := fii_time_api.sd_lyswk(trunc(sysdate)); */
31:
32: select NVL(fii_time_api.pwk_end(trunc(sysdate)),g_min_start_date),
33: NVL(fii_time_api.sd_lyswk(trunc(sysdate)),g_min_start_date)
34: INTO fii_gl_util_pkg.g_cy_period_end,
35: fii_gl_util_pkg.g_py_sday
36: FROM dual;

Line 33: NVL(fii_time_api.sd_lyswk(trunc(sysdate)),g_min_start_date)

29: fii_gl_util_pkg.g_cy_period_end := fii_time_api.pwk_end(trunc(sysdate));
30: fii_gl_util_pkg.g_py_sday := fii_time_api.sd_lyswk(trunc(sysdate)); */
31:
32: select NVL(fii_time_api.pwk_end(trunc(sysdate)),g_min_start_date),
33: NVL(fii_time_api.sd_lyswk(trunc(sysdate)),g_min_start_date)
34: INTO fii_gl_util_pkg.g_cy_period_end,
35: fii_gl_util_pkg.g_py_sday
36: FROM dual;
37:

Line 51: fii_gl_util_pkg.g_cy_period_end := fii_time_api.ent_pper_end(trunc(sysdate));

47: fii_gl_util_pkg.g_viewby_type := 'TIME+FII_TIME_ENT_PERIOD';
48:
49: /* Commented out for bug 3893359 and replaced with select
50:
51: fii_gl_util_pkg.g_cy_period_end := fii_time_api.ent_pper_end(trunc(sysdate));
52: fii_gl_util_pkg.g_py_sday := fii_time_api.ent_sd_lysper_end(trunc(sysdate)); */
53:
54: select NVL(fii_time_api.ent_pper_end(trunc(sysdate)),g_min_start_date),
55: NVL(fii_time_api.ent_sd_lysper_end(trunc(sysdate)),g_min_start_date)

Line 52: fii_gl_util_pkg.g_py_sday := fii_time_api.ent_sd_lysper_end(trunc(sysdate)); */

48:
49: /* Commented out for bug 3893359 and replaced with select
50:
51: fii_gl_util_pkg.g_cy_period_end := fii_time_api.ent_pper_end(trunc(sysdate));
52: fii_gl_util_pkg.g_py_sday := fii_time_api.ent_sd_lysper_end(trunc(sysdate)); */
53:
54: select NVL(fii_time_api.ent_pper_end(trunc(sysdate)),g_min_start_date),
55: NVL(fii_time_api.ent_sd_lysper_end(trunc(sysdate)),g_min_start_date)
56: INTO fii_gl_util_pkg.g_cy_period_end,

Line 54: select NVL(fii_time_api.ent_pper_end(trunc(sysdate)),g_min_start_date),

50:
51: fii_gl_util_pkg.g_cy_period_end := fii_time_api.ent_pper_end(trunc(sysdate));
52: fii_gl_util_pkg.g_py_sday := fii_time_api.ent_sd_lysper_end(trunc(sysdate)); */
53:
54: select NVL(fii_time_api.ent_pper_end(trunc(sysdate)),g_min_start_date),
55: NVL(fii_time_api.ent_sd_lysper_end(trunc(sysdate)),g_min_start_date)
56: INTO fii_gl_util_pkg.g_cy_period_end,
57: fii_gl_util_pkg.g_py_sday
58: FROM dual;

Line 55: NVL(fii_time_api.ent_sd_lysper_end(trunc(sysdate)),g_min_start_date)

51: fii_gl_util_pkg.g_cy_period_end := fii_time_api.ent_pper_end(trunc(sysdate));
52: fii_gl_util_pkg.g_py_sday := fii_time_api.ent_sd_lysper_end(trunc(sysdate)); */
53:
54: select NVL(fii_time_api.ent_pper_end(trunc(sysdate)),g_min_start_date),
55: NVL(fii_time_api.ent_sd_lysper_end(trunc(sysdate)),g_min_start_date)
56: INTO fii_gl_util_pkg.g_cy_period_end,
57: fii_gl_util_pkg.g_py_sday
58: FROM dual;
59:

Line 73: fii_gl_util_pkg.g_cy_period_end := fii_time_api.ent_pqtr_end(trunc(sysdate));

69: l_ak_region_item := 'QUARTER';
70: fii_gl_util_pkg.g_viewby_type := 'TIME+FII_TIME_ENT_QTR';
71: /* Commented out for bug 3893359 and replaced with select
72:
73: fii_gl_util_pkg.g_cy_period_end := fii_time_api.ent_pqtr_end(trunc(sysdate));
74: fii_gl_util_pkg.g_py_sday := fii_time_api.ent_sd_lysqtr_end(
75: fii_time_api.ent_sd_lysqtr_end(
76: trunc(sysdate))); */
77:

Line 74: fii_gl_util_pkg.g_py_sday := fii_time_api.ent_sd_lysqtr_end(

70: fii_gl_util_pkg.g_viewby_type := 'TIME+FII_TIME_ENT_QTR';
71: /* Commented out for bug 3893359 and replaced with select
72:
73: fii_gl_util_pkg.g_cy_period_end := fii_time_api.ent_pqtr_end(trunc(sysdate));
74: fii_gl_util_pkg.g_py_sday := fii_time_api.ent_sd_lysqtr_end(
75: fii_time_api.ent_sd_lysqtr_end(
76: trunc(sysdate))); */
77:
78: select NVL(fii_time_api.ent_pqtr_end(trunc(sysdate)),g_min_start_date),

Line 75: fii_time_api.ent_sd_lysqtr_end(

71: /* Commented out for bug 3893359 and replaced with select
72:
73: fii_gl_util_pkg.g_cy_period_end := fii_time_api.ent_pqtr_end(trunc(sysdate));
74: fii_gl_util_pkg.g_py_sday := fii_time_api.ent_sd_lysqtr_end(
75: fii_time_api.ent_sd_lysqtr_end(
76: trunc(sysdate))); */
77:
78: select NVL(fii_time_api.ent_pqtr_end(trunc(sysdate)),g_min_start_date),
79: NVL(fii_time_api.ent_sd_lysqtr_end(fii_time_api.ent_sd_lysqtr_end(trunc(sysdate))),g_min_start_date)

Line 78: select NVL(fii_time_api.ent_pqtr_end(trunc(sysdate)),g_min_start_date),

74: fii_gl_util_pkg.g_py_sday := fii_time_api.ent_sd_lysqtr_end(
75: fii_time_api.ent_sd_lysqtr_end(
76: trunc(sysdate))); */
77:
78: select NVL(fii_time_api.ent_pqtr_end(trunc(sysdate)),g_min_start_date),
79: NVL(fii_time_api.ent_sd_lysqtr_end(fii_time_api.ent_sd_lysqtr_end(trunc(sysdate))),g_min_start_date)
80: INTO fii_gl_util_pkg.g_cy_period_end,
81: fii_gl_util_pkg.g_py_sday
82: FROM dual;

Line 79: NVL(fii_time_api.ent_sd_lysqtr_end(fii_time_api.ent_sd_lysqtr_end(trunc(sysdate))),g_min_start_date)

75: fii_time_api.ent_sd_lysqtr_end(
76: trunc(sysdate))); */
77:
78: select NVL(fii_time_api.ent_pqtr_end(trunc(sysdate)),g_min_start_date),
79: NVL(fii_time_api.ent_sd_lysqtr_end(fii_time_api.ent_sd_lysqtr_end(trunc(sysdate))),g_min_start_date)
80: INTO fii_gl_util_pkg.g_cy_period_end,
81: fii_gl_util_pkg.g_py_sday
82: FROM dual;
83:

Line 100: fii_gl_util_pkg.g_cy_period_end := fii_time_api.ent_pyr_end(

96: l_ak_region_item := 'YEAR';
97: fii_gl_util_pkg.g_viewby_type := 'TIME+FII_TIME_ENT_YEAR';
98:
99: /* Commented out for bug 3893359 and replaced with select
100: fii_gl_util_pkg.g_cy_period_end := fii_time_api.ent_pyr_end(
101: trunc(sysdate));
102: fii_gl_util_pkg.g_py_sday := fii_time_api.ent_pyr_start(
103: fii_time_api.ent_pyr_start(
104: fii_time_api.ent_pyr_start(

Line 102: fii_gl_util_pkg.g_py_sday := fii_time_api.ent_pyr_start(

98:
99: /* Commented out for bug 3893359 and replaced with select
100: fii_gl_util_pkg.g_cy_period_end := fii_time_api.ent_pyr_end(
101: trunc(sysdate));
102: fii_gl_util_pkg.g_py_sday := fii_time_api.ent_pyr_start(
103: fii_time_api.ent_pyr_start(
104: fii_time_api.ent_pyr_start(
105: fii_time_api.ent_pyr_start(
106: trunc(sysdate)))));

Line 103: fii_time_api.ent_pyr_start(

99: /* Commented out for bug 3893359 and replaced with select
100: fii_gl_util_pkg.g_cy_period_end := fii_time_api.ent_pyr_end(
101: trunc(sysdate));
102: fii_gl_util_pkg.g_py_sday := fii_time_api.ent_pyr_start(
103: fii_time_api.ent_pyr_start(
104: fii_time_api.ent_pyr_start(
105: fii_time_api.ent_pyr_start(
106: trunc(sysdate)))));
107: fii_gl_util_pkg.g_begin_date := fii_time_api.ent_pyr_start(

Line 104: fii_time_api.ent_pyr_start(

100: fii_gl_util_pkg.g_cy_period_end := fii_time_api.ent_pyr_end(
101: trunc(sysdate));
102: fii_gl_util_pkg.g_py_sday := fii_time_api.ent_pyr_start(
103: fii_time_api.ent_pyr_start(
104: fii_time_api.ent_pyr_start(
105: fii_time_api.ent_pyr_start(
106: trunc(sysdate)))));
107: fii_gl_util_pkg.g_begin_date := fii_time_api.ent_pyr_start(
108: fii_gl_util_pkg.g_py_sday); */

Line 105: fii_time_api.ent_pyr_start(

101: trunc(sysdate));
102: fii_gl_util_pkg.g_py_sday := fii_time_api.ent_pyr_start(
103: fii_time_api.ent_pyr_start(
104: fii_time_api.ent_pyr_start(
105: fii_time_api.ent_pyr_start(
106: trunc(sysdate)))));
107: fii_gl_util_pkg.g_begin_date := fii_time_api.ent_pyr_start(
108: fii_gl_util_pkg.g_py_sday); */
109:

Line 107: fii_gl_util_pkg.g_begin_date := fii_time_api.ent_pyr_start(

103: fii_time_api.ent_pyr_start(
104: fii_time_api.ent_pyr_start(
105: fii_time_api.ent_pyr_start(
106: trunc(sysdate)))));
107: fii_gl_util_pkg.g_begin_date := fii_time_api.ent_pyr_start(
108: fii_gl_util_pkg.g_py_sday); */
109:
110:
111: select NVL(fii_time_api.ent_pyr_end(trunc(sysdate)),g_min_start_date),

Line 111: select NVL(fii_time_api.ent_pyr_end(trunc(sysdate)),g_min_start_date),

107: fii_gl_util_pkg.g_begin_date := fii_time_api.ent_pyr_start(
108: fii_gl_util_pkg.g_py_sday); */
109:
110:
111: select NVL(fii_time_api.ent_pyr_end(trunc(sysdate)),g_min_start_date),
112: NVL(fii_time_api.ent_pyr_start(fii_time_api.ent_pyr_start(
113: fii_time_api.ent_pyr_start(
114: fii_time_api.ent_pyr_start(
115: trunc(sysdate))))),g_min_start_date)

Line 112: NVL(fii_time_api.ent_pyr_start(fii_time_api.ent_pyr_start(

108: fii_gl_util_pkg.g_py_sday); */
109:
110:
111: select NVL(fii_time_api.ent_pyr_end(trunc(sysdate)),g_min_start_date),
112: NVL(fii_time_api.ent_pyr_start(fii_time_api.ent_pyr_start(
113: fii_time_api.ent_pyr_start(
114: fii_time_api.ent_pyr_start(
115: trunc(sysdate))))),g_min_start_date)
116: INTO fii_gl_util_pkg.g_cy_period_end,

Line 113: fii_time_api.ent_pyr_start(

109:
110:
111: select NVL(fii_time_api.ent_pyr_end(trunc(sysdate)),g_min_start_date),
112: NVL(fii_time_api.ent_pyr_start(fii_time_api.ent_pyr_start(
113: fii_time_api.ent_pyr_start(
114: fii_time_api.ent_pyr_start(
115: trunc(sysdate))))),g_min_start_date)
116: INTO fii_gl_util_pkg.g_cy_period_end,
117: fii_gl_util_pkg.g_py_sday

Line 114: fii_time_api.ent_pyr_start(

110:
111: select NVL(fii_time_api.ent_pyr_end(trunc(sysdate)),g_min_start_date),
112: NVL(fii_time_api.ent_pyr_start(fii_time_api.ent_pyr_start(
113: fii_time_api.ent_pyr_start(
114: fii_time_api.ent_pyr_start(
115: trunc(sysdate))))),g_min_start_date)
116: INTO fii_gl_util_pkg.g_cy_period_end,
117: fii_gl_util_pkg.g_py_sday
118: FROM dual;

Line 120: SELECT NVL(fii_time_api.ent_pyr_start(fii_gl_util_pkg.g_py_sday),g_min_start_date)

116: INTO fii_gl_util_pkg.g_cy_period_end,
117: fii_gl_util_pkg.g_py_sday
118: FROM dual;
119:
120: SELECT NVL(fii_time_api.ent_pyr_start(fii_gl_util_pkg.g_py_sday),g_min_start_date)
121: INTO fii_gl_util_pkg.g_begin_date
122: FROM dual;
123:
124: