eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FII_GL_CUMUL_REV_TREND_PKG dependencies on FII_GL_UTIL_PKG

Line 33: fii_gl_util_pkg.reset_globals;

29: l_dummy_mgr_id VARCHAR2(100);
30:
31: BEGIN
32:
33: fii_gl_util_pkg.reset_globals;
34: fii_gl_util_pkg.get_parameters(p_page_parameter_tbl);
35: fii_gl_util_pkg.get_bitmasks;
36: fii_gl_util_pkg.g_fin_type := 'R'; -- since it is a revenue report, we always put category as 'revenue'
37: fii_gl_util_pkg.get_mgr_pmv_sql;

Line 34: fii_gl_util_pkg.get_parameters(p_page_parameter_tbl);

30:
31: BEGIN
32:
33: fii_gl_util_pkg.reset_globals;
34: fii_gl_util_pkg.get_parameters(p_page_parameter_tbl);
35: fii_gl_util_pkg.get_bitmasks;
36: fii_gl_util_pkg.g_fin_type := 'R'; -- since it is a revenue report, we always put category as 'revenue'
37: fii_gl_util_pkg.get_mgr_pmv_sql;
38: fii_gl_util_pkg.get_cat_pmv_sql;

Line 35: fii_gl_util_pkg.get_bitmasks;

31: BEGIN
32:
33: fii_gl_util_pkg.reset_globals;
34: fii_gl_util_pkg.get_parameters(p_page_parameter_tbl);
35: fii_gl_util_pkg.get_bitmasks;
36: fii_gl_util_pkg.g_fin_type := 'R'; -- since it is a revenue report, we always put category as 'revenue'
37: fii_gl_util_pkg.get_mgr_pmv_sql;
38: fii_gl_util_pkg.get_cat_pmv_sql;
39:

Line 36: fii_gl_util_pkg.g_fin_type := 'R'; -- since it is a revenue report, we always put category as 'revenue'

32:
33: fii_gl_util_pkg.reset_globals;
34: fii_gl_util_pkg.get_parameters(p_page_parameter_tbl);
35: fii_gl_util_pkg.get_bitmasks;
36: fii_gl_util_pkg.g_fin_type := 'R'; -- since it is a revenue report, we always put category as 'revenue'
37: fii_gl_util_pkg.get_mgr_pmv_sql;
38: fii_gl_util_pkg.get_cat_pmv_sql;
39:
40: l_budget_forecast_profile := NVL(FND_PROFILE.Value( 'FII_FB_STEP'),'N');

Line 37: fii_gl_util_pkg.get_mgr_pmv_sql;

33: fii_gl_util_pkg.reset_globals;
34: fii_gl_util_pkg.get_parameters(p_page_parameter_tbl);
35: fii_gl_util_pkg.get_bitmasks;
36: fii_gl_util_pkg.g_fin_type := 'R'; -- since it is a revenue report, we always put category as 'revenue'
37: fii_gl_util_pkg.get_mgr_pmv_sql;
38: fii_gl_util_pkg.get_cat_pmv_sql;
39:
40: l_budget_forecast_profile := NVL(FND_PROFILE.Value( 'FII_FB_STEP'),'N');
41:

Line 38: fii_gl_util_pkg.get_cat_pmv_sql;

34: fii_gl_util_pkg.get_parameters(p_page_parameter_tbl);
35: fii_gl_util_pkg.get_bitmasks;
36: fii_gl_util_pkg.g_fin_type := 'R'; -- since it is a revenue report, we always put category as 'revenue'
37: fii_gl_util_pkg.get_mgr_pmv_sql;
38: fii_gl_util_pkg.get_cat_pmv_sql;
39:
40: l_budget_forecast_profile := NVL(FND_PROFILE.Value( 'FII_FB_STEP'),'N');
41:
42: IF fii_gl_util_pkg.g_time_comp = 'BUDGET' THEN

Line 42: IF fii_gl_util_pkg.g_time_comp = 'BUDGET' THEN

38: fii_gl_util_pkg.get_cat_pmv_sql;
39:
40: l_budget_forecast_profile := NVL(FND_PROFILE.Value( 'FII_FB_STEP'),'N');
41:
42: IF fii_gl_util_pkg.g_time_comp = 'BUDGET' THEN
43: l_if_budget := 'Y';
44: END IF;
45:
46: CASE fii_gl_util_pkg.g_page_period_type

Line 46: CASE fii_gl_util_pkg.g_page_period_type

42: IF fii_gl_util_pkg.g_time_comp = 'BUDGET' THEN
43: l_if_budget := 'Y';
44: END IF;
45:
46: CASE fii_gl_util_pkg.g_page_period_type
47:
48: WHEN 'FII_TIME_WEEK' THEN l_cond := 'NULL';
49:
50: ELSE

Line 58: CASE fii_gl_util_pkg.g_forecast_period_type

54: -- since the sql for getting forecast is generated dynamically, the following CASE statement assigns
55: -- values to different variables used to store the table-names, time-ids etc for each period.
56: -- The assignment depends upon the level at which forecast has been loaded.
57:
58: CASE fii_gl_util_pkg.g_forecast_period_type
59:
60: WHEN 0 THEN l_time_id := 'g.week_id';
61: l_time_id2 := 'g.week_id';
62: l_period_id := 0;

Line 87: '||fii_gl_util_pkg.g_view||fii_gl_util_pkg.g_mgr_from_clause||fii_gl_util_pkg.g_cat_from_clause||'

83:
84: sqlstmt2 := '
85: (SELECT SUM(DECODE(f.forecast_g,0,NULL,f.forecast_g))
86: FROM '||l_table_name||' g
87: '||fii_gl_util_pkg.g_view||fii_gl_util_pkg.g_mgr_from_clause||fii_gl_util_pkg.g_cat_from_clause||'
88: WHERE f.time_id = '||l_time_id||'
89: '||fii_gl_util_pkg.g_mgr_join||fii_gl_util_pkg.g_cat_join||''||fii_gl_util_pkg.g_gid||'
90: and to_date(:ASOF_DATE,''DD-MM-YYYY'') between g.start_date and g.end_date
91: and f.period_type_id = '||l_period_id||'

Line 89: '||fii_gl_util_pkg.g_mgr_join||fii_gl_util_pkg.g_cat_join||''||fii_gl_util_pkg.g_gid||'

85: (SELECT SUM(DECODE(f.forecast_g,0,NULL,f.forecast_g))
86: FROM '||l_table_name||' g
87: '||fii_gl_util_pkg.g_view||fii_gl_util_pkg.g_mgr_from_clause||fii_gl_util_pkg.g_cat_from_clause||'
88: WHERE f.time_id = '||l_time_id||'
89: '||fii_gl_util_pkg.g_mgr_join||fii_gl_util_pkg.g_cat_join||''||fii_gl_util_pkg.g_gid||'
90: and to_date(:ASOF_DATE,''DD-MM-YYYY'') between g.start_date and g.end_date
91: and f.period_type_id = '||l_period_id||'
92: )';
93:

Line 97: CASE fii_gl_util_pkg.g_page_period_type

93:
94:
95:
96:
97: CASE fii_gl_util_pkg.g_page_period_type
98:
99: WHEN 'FII_TIME_WEEK' THEN l_adjust1 := '1';
100: l_adjust2 := '1';
101: l_forecast := 'NULL';

Line 103: fii_gl_util_pkg.g_viewby_type := 'TIME+FII_TIME_DAY'; /* Done for bug 3449775 */

99: WHEN 'FII_TIME_WEEK' THEN l_adjust1 := '1';
100: l_adjust2 := '1';
101: l_forecast := 'NULL';
102: l_if_budget_zero := 'Y';
103: fii_gl_util_pkg.g_viewby_type := 'TIME+FII_TIME_DAY'; /* Done for bug 3449775 */
104: WHEN 'FII_TIME_ENT_PERIOD' THEN l_adjust1 := '1';
105: l_adjust2 := '1';
106: l_forecast := sqlstmt2;
107: fii_gl_util_pkg.g_viewby_type := 'TIME+FII_TIME_DAY';

Line 107: fii_gl_util_pkg.g_viewby_type := 'TIME+FII_TIME_DAY';

103: fii_gl_util_pkg.g_viewby_type := 'TIME+FII_TIME_DAY'; /* Done for bug 3449775 */
104: WHEN 'FII_TIME_ENT_PERIOD' THEN l_adjust1 := '1';
105: l_adjust2 := '1';
106: l_forecast := sqlstmt2;
107: fii_gl_util_pkg.g_viewby_type := 'TIME+FII_TIME_DAY';
108: WHEN 'FII_TIME_ENT_QTR' THEN l_adjust1 := 'to_date(:P_CURR_START,''DD-MM-YYYY'')-to_date(:P_CURR_END,''DD-MM-YYYY'')';
109: l_adjust2 := 'to_date(:P_PRIOR_START,''DD-MM-YYYY'')-to_date(:P_PRIOR_END,''DD-MM-YYYY'')';
110: l_forecast := sqlstmt2;
111: fii_gl_util_pkg.g_viewby_type := 'TIME+FII_TIME_DAY';

Line 111: fii_gl_util_pkg.g_viewby_type := 'TIME+FII_TIME_DAY';

107: fii_gl_util_pkg.g_viewby_type := 'TIME+FII_TIME_DAY';
108: WHEN 'FII_TIME_ENT_QTR' THEN l_adjust1 := 'to_date(:P_CURR_START,''DD-MM-YYYY'')-to_date(:P_CURR_END,''DD-MM-YYYY'')';
109: l_adjust2 := 'to_date(:P_PRIOR_START,''DD-MM-YYYY'')-to_date(:P_PRIOR_END,''DD-MM-YYYY'')';
110: l_forecast := sqlstmt2;
111: fii_gl_util_pkg.g_viewby_type := 'TIME+FII_TIME_DAY';
112: WHEN 'FII_TIME_ENT_YEAR' THEN l_adjust1 := NULL;
113: l_adjust2 := NULL;
114: l_forecast := sqlstmt2;
115: fii_gl_util_pkg.g_viewby_type := 'TIME+FII_TIME_ENT_PERIOD';

Line 115: fii_gl_util_pkg.g_viewby_type := 'TIME+FII_TIME_ENT_PERIOD';

111: fii_gl_util_pkg.g_viewby_type := 'TIME+FII_TIME_DAY';
112: WHEN 'FII_TIME_ENT_YEAR' THEN l_adjust1 := NULL;
113: l_adjust2 := NULL;
114: l_forecast := sqlstmt2;
115: fii_gl_util_pkg.g_viewby_type := 'TIME+FII_TIME_ENT_PERIOD';
116: END CASE;
117:
118: -- similar to forecast, since the sql for budget is also generated dynamically,
119: -- the folowing CASE statement assigns values to different variables used to compute the budget value.

Line 122: CASE fii_gl_util_pkg.g_time_comp

118: -- similar to forecast, since the sql for budget is also generated dynamically,
119: -- the folowing CASE statement assigns values to different variables used to compute the budget value.
120: -- The assignment depends upon the level at which budget has been loaded.
121:
122: CASE fii_gl_util_pkg.g_time_comp
123:
124: WHEN 'BUDGET' THEN
125:
126: CASE fii_gl_util_pkg.g_budget_period_type

Line 126: CASE fii_gl_util_pkg.g_budget_period_type

122: CASE fii_gl_util_pkg.g_time_comp
123:
124: WHEN 'BUDGET' THEN
125:
126: CASE fii_gl_util_pkg.g_budget_period_type
127:
128: WHEN 0 THEN l_budget_time_id := 'g.week_id';
129: l_budget_period_id := 0;
130: l_budget_table_name := 'fii_time_week';

Line 147: '||fii_gl_util_pkg.g_view||fii_gl_util_pkg.g_mgr_from_clause||fii_gl_util_pkg.g_cat_from_clause||'

143:
144: sqlstmt3 := '
145: (SELECT SUM(DECODE(f.budget_g,0,to_number(NULL),f.budget_g))
146: FROM '||l_budget_table_name||' g
147: '||fii_gl_util_pkg.g_view||fii_gl_util_pkg.g_mgr_from_clause||fii_gl_util_pkg.g_cat_from_clause||'
148: WHERE f.time_id = '||l_budget_time_id||'
149: '||fii_gl_util_pkg.g_mgr_join||fii_gl_util_pkg.g_cat_join||''||fii_gl_util_pkg.g_gid||' and
150: to_date(:ASOF_DATE,''DD-MM-YYYY'') between g.start_date and g.end_date and
151: f.period_type_id = '||l_budget_period_id||'

Line 149: '||fii_gl_util_pkg.g_mgr_join||fii_gl_util_pkg.g_cat_join||''||fii_gl_util_pkg.g_gid||' and

145: (SELECT SUM(DECODE(f.budget_g,0,to_number(NULL),f.budget_g))
146: FROM '||l_budget_table_name||' g
147: '||fii_gl_util_pkg.g_view||fii_gl_util_pkg.g_mgr_from_clause||fii_gl_util_pkg.g_cat_from_clause||'
148: WHERE f.time_id = '||l_budget_time_id||'
149: '||fii_gl_util_pkg.g_mgr_join||fii_gl_util_pkg.g_cat_join||''||fii_gl_util_pkg.g_gid||' and
150: to_date(:ASOF_DATE,''DD-MM-YYYY'') between g.start_date and g.end_date and
151: f.period_type_id = '||l_budget_period_id||'
152: )';
153:

Line 154: CASE fii_gl_util_pkg.g_page_period_type

150: to_date(:ASOF_DATE,''DD-MM-YYYY'') between g.start_date and g.end_date and
151: f.period_type_id = '||l_budget_period_id||'
152: )';
153:
154: CASE fii_gl_util_pkg.g_page_period_type
155:
156: WHEN 'FII_TIME_ENT_PERIOD' THEN l_budget := sqlstmt3;
157: WHEN 'FII_TIME_ENT_QTR' THEN l_budget := sqlstmt3;
158: WHEN 'FII_TIME_ENT_YEAR' THEN l_budget := sqlstmt3;

Line 166: IF fii_gl_util_pkg.g_mgr_id = -99999 THEN l_dummy_mgr_id := '-99999';

162: ELSE NULL;
163:
164: END CASE;
165:
166: IF fii_gl_util_pkg.g_mgr_id = -99999 THEN l_dummy_mgr_id := '-99999';
167: ELSE l_dummy_mgr_id := ' &HRI_PERSON+HRI_PER_USRDR_H';
168: END IF;
169:
170: /*-------------------------------------------------

Line 208: WHEN 'Y' THEN CASE fii_gl_util_pkg.g_time_comp

204: */
205:
206: CASE l_budget_forecast_profile
207:
208: WHEN 'Y' THEN CASE fii_gl_util_pkg.g_time_comp
209:
210: WHEN 'BUDGET' THEN
211:
212: CASE fii_gl_util_pkg.g_page_period_type

Line 212: CASE fii_gl_util_pkg.g_page_period_type

208: WHEN 'Y' THEN CASE fii_gl_util_pkg.g_time_comp
209:
210: WHEN 'BUDGET' THEN
211:
212: CASE fii_gl_util_pkg.g_page_period_type
213:
214: WHEN 'FII_TIME_ENT_YEAR' THEN
215:
216: sqlstmt := '

Line 245: '||fii_gl_util_pkg.g_view||fii_gl_util_pkg.g_mgr_from_clause||fii_gl_util_pkg.g_cat_from_clause||'

241: END) PREVIOUS,
242:
243: NULL CY_FOR
244: FROM fii_time_ent_period per
245: '||fii_gl_util_pkg.g_view||fii_gl_util_pkg.g_mgr_from_clause||fii_gl_util_pkg.g_cat_from_clause||'
246:
247: WHERE per.ent_period_id = f.time_id
248: '||fii_gl_util_pkg.g_mgr_join||fii_gl_util_pkg.g_cat_join||''||fii_gl_util_pkg.g_gid||' and
249: per.start_date >= to_date(:P_PRIOR_START,''DD-MM-YYYY'') and

Line 248: '||fii_gl_util_pkg.g_mgr_join||fii_gl_util_pkg.g_cat_join||''||fii_gl_util_pkg.g_gid||' and

244: FROM fii_time_ent_period per
245: '||fii_gl_util_pkg.g_view||fii_gl_util_pkg.g_mgr_from_clause||fii_gl_util_pkg.g_cat_from_clause||'
246:
247: WHERE per.ent_period_id = f.time_id
248: '||fii_gl_util_pkg.g_mgr_join||fii_gl_util_pkg.g_cat_join||''||fii_gl_util_pkg.g_gid||' and
249: per.start_date >= to_date(:P_PRIOR_START,''DD-MM-YYYY'') and
250: per.end_date <= to_date(:P_PRIOR_END,''DD-MM-YYYY'') and
251: f.period_type_id = 32
252:

Line 268: '||fii_gl_util_pkg.g_view||fii_gl_util_pkg.g_mgr_from_clause||fii_gl_util_pkg.g_cat_from_clause||'

264: END CURR,
265: NULL PREVIOUS,
266: NULL CY_FOR
267: FROM fii_time_ent_period per
268: '||fii_gl_util_pkg.g_view||fii_gl_util_pkg.g_mgr_from_clause||fii_gl_util_pkg.g_cat_from_clause||'
269:
270: WHERE per.ent_period_id = f.time_id
271: '||fii_gl_util_pkg.g_mgr_join||fii_gl_util_pkg.g_cat_join||''||fii_gl_util_pkg.g_gid||' and
272: per.start_date >= to_date(:P_CURR_START,''DD-MM-YYYY'') and

Line 271: '||fii_gl_util_pkg.g_mgr_join||fii_gl_util_pkg.g_cat_join||''||fii_gl_util_pkg.g_gid||' and

267: FROM fii_time_ent_period per
268: '||fii_gl_util_pkg.g_view||fii_gl_util_pkg.g_mgr_from_clause||fii_gl_util_pkg.g_cat_from_clause||'
269:
270: WHERE per.ent_period_id = f.time_id
271: '||fii_gl_util_pkg.g_mgr_join||fii_gl_util_pkg.g_cat_join||''||fii_gl_util_pkg.g_gid||' and
272: per.start_date >= to_date(:P_CURR_START,''DD-MM-YYYY'') and
273: per.end_date <= to_date(:ASOF_DATE,''DD-MM-YYYY'') and
274: f.period_type_id = 32
275:

Line 310: '||fii_gl_util_pkg.g_view||fii_gl_util_pkg.g_mgr_from_clause||fii_gl_util_pkg.g_cat_from_clause||'

306: ELSE NULL
307: END) CY_FOR
308:
309: FROM fii_time_ent_period per
310: '||fii_gl_util_pkg.g_view||fii_gl_util_pkg.g_mgr_from_clause||fii_gl_util_pkg.g_cat_from_clause||'
311:
312: WHERE per.ent_period_id = f.time_id
313: '||fii_gl_util_pkg.g_mgr_join||fii_gl_util_pkg.g_cat_join||''||fii_gl_util_pkg.g_gid||' and
314: per.start_date >= to_date(:P_CURR_START,''DD-MM-YYYY'') and

Line 313: '||fii_gl_util_pkg.g_mgr_join||fii_gl_util_pkg.g_cat_join||''||fii_gl_util_pkg.g_gid||' and

309: FROM fii_time_ent_period per
310: '||fii_gl_util_pkg.g_view||fii_gl_util_pkg.g_mgr_from_clause||fii_gl_util_pkg.g_cat_from_clause||'
311:
312: WHERE per.ent_period_id = f.time_id
313: '||fii_gl_util_pkg.g_mgr_join||fii_gl_util_pkg.g_cat_join||''||fii_gl_util_pkg.g_gid||' and
314: per.start_date >= to_date(:P_CURR_START,''DD-MM-YYYY'') and
315: per.end_date <= to_date(:P_CURR_END,''DD-MM-YYYY'') and
316: f.period_type_id = 32
317:

Line 347: ( SELECT * FROM FII_GL_MGMT_SUM_V'||fii_gl_util_pkg.g_global_curr_view||' f

343: report_date,
344: NVL(SUM(SUM(f.actual_g)) OVER (ORDER BY g.report_date-to_date(:P_CURR_START,''DD-MM-YYYY'')+ to_number('||l_adjust1||') ROWS UNBOUNDED PRECEDING),0) CY_REV,
345: 0 PY_REV
346: FROM fii_time_day g,
347: ( SELECT * FROM FII_GL_MGMT_SUM_V'||fii_gl_util_pkg.g_global_curr_view||' f
348: WHERE ( 1=1 and f.person_id(+) = '||l_dummy_mgr_id||' and
349: f.manager_id(+) = :MGR_MGR_ID and
350: f.gid (+) = 4 and
351: f.period_type_id (+) = 1

Line 352: '||fii_gl_util_pkg.g_cat_join||')

348: WHERE ( 1=1 and f.person_id(+) = '||l_dummy_mgr_id||' and
349: f.manager_id(+) = :MGR_MGR_ID and
350: f.gid (+) = 4 and
351: f.period_type_id (+) = 1
352: '||fii_gl_util_pkg.g_cat_join||')
353: ) f
354: WHERE g.report_date_julian = f.time_id (+) and
355: g.report_date_julian between :CURR_START_DAY_ID and :CURR_END_DAY_ID
356:

Line 384: ( SELECT * FROM FII_GL_MGMT_SUM_V'||fii_gl_util_pkg.g_global_curr_view||' f

380: END CY_BUD
381:
382:
383: FROM fii_time_day g,
384: ( SELECT * FROM FII_GL_MGMT_SUM_V'||fii_gl_util_pkg.g_global_curr_view||' f
385: WHERE ( 1=1 and f.person_id(+) = '||l_dummy_mgr_id||' and
386: f.manager_id(+) =:MGR_MGR_ID and
387: f.gid (+) = 4 and
388: f.period_type_id (+) = '||l_period_id2||'

Line 389: '||fii_gl_util_pkg.g_cat_join||')

385: WHERE ( 1=1 and f.person_id(+) = '||l_dummy_mgr_id||' and
386: f.manager_id(+) =:MGR_MGR_ID and
387: f.gid (+) = 4 and
388: f.period_type_id (+) = '||l_period_id2||'
389: '||fii_gl_util_pkg.g_cat_join||')
390: ) f
391: WHERE '||l_time_id2||' = f.time_id (+) and
392: g.report_date_julian between :CURR_START_DAY_ID and :CURR_END_DAY_ID
393:

Line 422: ( SELECT * FROM FII_GL_MGMT_SUM_V'||fii_gl_util_pkg.g_global_curr_view||' f

418: ELSE NULL
419: END CY_FOR
420:
421: FROM fii_time_day g,
422: ( SELECT * FROM FII_GL_MGMT_SUM_V'||fii_gl_util_pkg.g_global_curr_view||' f
423: WHERE ( 1=1 and f.person_id(+) = '||l_dummy_mgr_id||' and
424: f.manager_id(+) =:MGR_MGR_ID and
425: f.gid (+) = 4 and
426: f.period_type_id (+) = '||l_period_id2||'

Line 427: '||fii_gl_util_pkg.g_cat_join||')

423: WHERE ( 1=1 and f.person_id(+) = '||l_dummy_mgr_id||' and
424: f.manager_id(+) =:MGR_MGR_ID and
425: f.gid (+) = 4 and
426: f.period_type_id (+) = '||l_period_id2||'
427: '||fii_gl_util_pkg.g_cat_join||')
428: ) f
429:
430: WHERE '||l_time_id2||' = f.time_id (+) and
431: g.report_date_julian between :CURR_START_DAY_ID and :CURR_END_DAY_ID

Line 448: CASE fii_gl_util_pkg.g_page_period_type

444: END CASE;
445:
446: ELSE
447:
448: CASE fii_gl_util_pkg.g_page_period_type
449:
450: WHEN 'FII_TIME_ENT_YEAR' THEN
451:
452: sqlstmt := '

Line 481: '||fii_gl_util_pkg.g_view||fii_gl_util_pkg.g_mgr_from_clause||fii_gl_util_pkg.g_cat_from_clause||'

477: ELSE to_number(NULL)
478: END) PREVIOUS,
479: NULL CY_FOR
480: FROM fii_time_ent_period per
481: '||fii_gl_util_pkg.g_view||fii_gl_util_pkg.g_mgr_from_clause||fii_gl_util_pkg.g_cat_from_clause||'
482:
483: WHERE per.ent_period_id = f.time_id
484: '||fii_gl_util_pkg.g_mgr_join||fii_gl_util_pkg.g_cat_join||''||fii_gl_util_pkg.g_gid||' and
485: per.start_date >= to_date(:P_PRIOR_START,''DD-MM-YYYY'') and

Line 484: '||fii_gl_util_pkg.g_mgr_join||fii_gl_util_pkg.g_cat_join||''||fii_gl_util_pkg.g_gid||' and

480: FROM fii_time_ent_period per
481: '||fii_gl_util_pkg.g_view||fii_gl_util_pkg.g_mgr_from_clause||fii_gl_util_pkg.g_cat_from_clause||'
482:
483: WHERE per.ent_period_id = f.time_id
484: '||fii_gl_util_pkg.g_mgr_join||fii_gl_util_pkg.g_cat_join||''||fii_gl_util_pkg.g_gid||' and
485: per.start_date >= to_date(:P_PRIOR_START,''DD-MM-YYYY'') and
486: per.end_date <= to_date(:P_PRIOR_END,''DD-MM-YYYY'') and
487: f.period_type_id = 32
488:

Line 504: '||fii_gl_util_pkg.g_view||fii_gl_util_pkg.g_mgr_from_clause||fii_gl_util_pkg.g_cat_from_clause||'

500: END CURR,
501: NULL PREVIOUS,
502: NULL CY_FOR
503: FROM fii_time_ent_period per
504: '||fii_gl_util_pkg.g_view||fii_gl_util_pkg.g_mgr_from_clause||fii_gl_util_pkg.g_cat_from_clause||'
505:
506: WHERE per.ent_period_id = f.time_id
507: '||fii_gl_util_pkg.g_mgr_join||fii_gl_util_pkg.g_cat_join||''||fii_gl_util_pkg.g_gid||' and
508: per.start_date >= to_date(:P_CURR_START,''DD-MM-YYYY'') and

Line 507: '||fii_gl_util_pkg.g_mgr_join||fii_gl_util_pkg.g_cat_join||''||fii_gl_util_pkg.g_gid||' and

503: FROM fii_time_ent_period per
504: '||fii_gl_util_pkg.g_view||fii_gl_util_pkg.g_mgr_from_clause||fii_gl_util_pkg.g_cat_from_clause||'
505:
506: WHERE per.ent_period_id = f.time_id
507: '||fii_gl_util_pkg.g_mgr_join||fii_gl_util_pkg.g_cat_join||''||fii_gl_util_pkg.g_gid||' and
508: per.start_date >= to_date(:P_CURR_START,''DD-MM-YYYY'') and
509: per.end_date <= to_date(:ASOF_DATE,''DD-MM-YYYY'') and
510: f.period_type_id = 32
511:

Line 543: '||fii_gl_util_pkg.g_view||fii_gl_util_pkg.g_mgr_from_clause||fii_gl_util_pkg.g_cat_from_clause||'

539: ELSE NULL
540: END) CY_FOR
541:
542: FROM fii_time_ent_period per
543: '||fii_gl_util_pkg.g_view||fii_gl_util_pkg.g_mgr_from_clause||fii_gl_util_pkg.g_cat_from_clause||'
544:
545: WHERE per.ent_period_id = f.time_id
546: '||fii_gl_util_pkg.g_mgr_join||fii_gl_util_pkg.g_cat_join||''||fii_gl_util_pkg.g_gid||' and
547: per.start_date >= to_date(:P_CURR_START,''DD-MM-YYYY'') and

Line 546: '||fii_gl_util_pkg.g_mgr_join||fii_gl_util_pkg.g_cat_join||''||fii_gl_util_pkg.g_gid||' and

542: FROM fii_time_ent_period per
543: '||fii_gl_util_pkg.g_view||fii_gl_util_pkg.g_mgr_from_clause||fii_gl_util_pkg.g_cat_from_clause||'
544:
545: WHERE per.ent_period_id = f.time_id
546: '||fii_gl_util_pkg.g_mgr_join||fii_gl_util_pkg.g_cat_join||''||fii_gl_util_pkg.g_gid||' and
547: per.start_date >= to_date(:P_CURR_START,''DD-MM-YYYY'') and
548: per.end_date <= to_date(:P_CURR_END,''DD-MM-YYYY'') and
549: f.period_type_id = 32
550:

Line 589: ( SELECT * FROM FII_GL_MGMT_SUM_V'||fii_gl_util_pkg.g_global_curr_view||' f

585: NVL(SUM(SUM(f.actual_g)) OVER (ORDER BY g.report_date-to_date(:P_CURR_START,''DD-MM-YYYY'')+
586: to_number('||l_adjust1||') ROWS UNBOUNDED PRECEDING),0) CY_REV,
587: 0 PY_REV
588: FROM fii_time_day g,
589: ( SELECT * FROM FII_GL_MGMT_SUM_V'||fii_gl_util_pkg.g_global_curr_view||' f
590: WHERE ( 1=1 and f.person_id(+) = '||l_dummy_mgr_id||' and
591: f.manager_id(+) = :MGR_MGR_ID and
592: f.gid (+) = 4 and
593: f.period_type_id (+) = 1

Line 594: '||fii_gl_util_pkg.g_cat_join||')

590: WHERE ( 1=1 and f.person_id(+) = '||l_dummy_mgr_id||' and
591: f.manager_id(+) = :MGR_MGR_ID and
592: f.gid (+) = 4 and
593: f.period_type_id (+) = 1
594: '||fii_gl_util_pkg.g_cat_join||')
595: ) f
596: WHERE g.report_date_julian = f.time_id (+) and
597: g.report_date_julian between :CURR_START_DAY_ID and :CURR_END_DAY_ID
598:

Line 609: ( SELECT * FROM FII_GL_MGMT_SUM_V'||fii_gl_util_pkg.g_global_curr_view||' f

605: to_number(NULL) CY_REV,
606: NVL(SUM(SUM(f.actual_g)) OVER (ORDER BY g.report_date-to_date(:P_PRIOR_START,''DD-MM-YYYY'')+
607: to_number('||l_adjust2||') ROWS UNBOUNDED PRECEDING),0) PY_REV
608: FROM fii_time_day g,
609: ( SELECT * FROM FII_GL_MGMT_SUM_V'||fii_gl_util_pkg.g_global_curr_view||' f
610: WHERE ( 1=1 and f.person_id(+) = '||l_dummy_mgr_id||' and
611: f.manager_id(+) = :MGR_MGR_ID and
612: f.gid (+) = 4 and
613: f.period_type_id (+) = 1

Line 614: '||fii_gl_util_pkg.g_cat_join||')

610: WHERE ( 1=1 and f.person_id(+) = '||l_dummy_mgr_id||' and
611: f.manager_id(+) = :MGR_MGR_ID and
612: f.gid (+) = 4 and
613: f.period_type_id (+) = 1
614: '||fii_gl_util_pkg.g_cat_join||')
615: ) f
616: WHERE f.time_id (+) = g.report_date_julian and
617: g.report_date_julian between :PRIOR_START_DAY_ID and :PRIOR_END_DAY_ID
618:

Line 643: ( SELECT * FROM FII_GL_MGMT_SUM_V'||fii_gl_util_pkg.g_global_curr_view||' f

639: ELSE NULL
640: END CY_FOR
641:
642: FROM fii_time_day g,
643: ( SELECT * FROM FII_GL_MGMT_SUM_V'||fii_gl_util_pkg.g_global_curr_view||' f
644: WHERE ( 1=1 and f.person_id(+) = '||l_dummy_mgr_id||' and
645: f.manager_id(+) =:MGR_MGR_ID and
646: f.gid (+) = 4 and
647: f.period_type_id (+) = '||l_period_id2||'

Line 648: '||fii_gl_util_pkg.g_cat_join||')

644: WHERE ( 1=1 and f.person_id(+) = '||l_dummy_mgr_id||' and
645: f.manager_id(+) =:MGR_MGR_ID and
646: f.gid (+) = 4 and
647: f.period_type_id (+) = '||l_period_id2||'
648: '||fii_gl_util_pkg.g_cat_join||')
649: ) f
650: WHERE
651: '||l_time_id2||' = f.time_id (+) and
652: g.report_date_julian between :CURR_START_DAY_ID and :CURR_END_DAY_ID

Line 676: CASE fii_gl_util_pkg.g_page_period_type

672: END CASE;
673:
674:
675: ELSE
676: CASE fii_gl_util_pkg.g_page_period_type
677:
678: WHEN 'FII_TIME_ENT_YEAR' THEN
679:
680: sqlstmt := '

Line 700: CASE WHEN '''||fii_gl_util_pkg.g_time_comp||'''=''BUDGET'' THEN '||l_budget||'

696: SELECT per.sequence FII_EFFECTIVE_NUM,
697: per.name month_name,
698: per.ent_period_id id,
699: NULL CURR,
700: CASE WHEN '''||fii_gl_util_pkg.g_time_comp||'''=''BUDGET'' THEN '||l_budget||'
701: ELSE
702: (CASE WHEN per.end_date <= to_date(:P_PRIOR_END,''DD-MM-YYYY'') THEN f.actual_g
703: ELSE to_number(NULL)
704: END)

Line 707: '||fii_gl_util_pkg.g_view||fii_gl_util_pkg.g_mgr_from_clause||fii_gl_util_pkg.g_cat_from_clause||'

703: ELSE to_number(NULL)
704: END)
705: END PREVIOUS
706: FROM fii_time_ent_period per
707: '||fii_gl_util_pkg.g_view||fii_gl_util_pkg.g_mgr_from_clause||fii_gl_util_pkg.g_cat_from_clause||'
708:
709: WHERE per.ent_period_id = f.time_id
710: '||fii_gl_util_pkg.g_mgr_join||fii_gl_util_pkg.g_cat_join||''||fii_gl_util_pkg.g_gid||' and
711: per.start_date >= to_date(:P_PRIOR_START,''DD-MM-YYYY'') and

Line 710: '||fii_gl_util_pkg.g_mgr_join||fii_gl_util_pkg.g_cat_join||''||fii_gl_util_pkg.g_gid||' and

706: FROM fii_time_ent_period per
707: '||fii_gl_util_pkg.g_view||fii_gl_util_pkg.g_mgr_from_clause||fii_gl_util_pkg.g_cat_from_clause||'
708:
709: WHERE per.ent_period_id = f.time_id
710: '||fii_gl_util_pkg.g_mgr_join||fii_gl_util_pkg.g_cat_join||''||fii_gl_util_pkg.g_gid||' and
711: per.start_date >= to_date(:P_PRIOR_START,''DD-MM-YYYY'') and
712: per.end_date <= to_date(:P_PRIOR_END,''DD-MM-YYYY'') and
713: f.period_type_id = 32
714:

Line 728: '||fii_gl_util_pkg.g_view||fii_gl_util_pkg.g_mgr_from_clause||fii_gl_util_pkg.g_cat_from_clause||'

724: ELSE to_number(NULL)
725: END CURR,
726: 0 PREVIOUS
727: FROM fii_time_ent_period per
728: '||fii_gl_util_pkg.g_view||fii_gl_util_pkg.g_mgr_from_clause||fii_gl_util_pkg.g_cat_from_clause||'
729:
730: WHERE per.ent_period_id = f.time_id
731: '||fii_gl_util_pkg.g_mgr_join||fii_gl_util_pkg.g_cat_join||''||fii_gl_util_pkg.g_gid||' and
732: per.start_date >= to_date(:P_CURR_START,''DD-MM-YYYY'') and

Line 731: '||fii_gl_util_pkg.g_mgr_join||fii_gl_util_pkg.g_cat_join||''||fii_gl_util_pkg.g_gid||' and

727: FROM fii_time_ent_period per
728: '||fii_gl_util_pkg.g_view||fii_gl_util_pkg.g_mgr_from_clause||fii_gl_util_pkg.g_cat_from_clause||'
729:
730: WHERE per.ent_period_id = f.time_id
731: '||fii_gl_util_pkg.g_mgr_join||fii_gl_util_pkg.g_cat_join||''||fii_gl_util_pkg.g_gid||' and
732: per.start_date >= to_date(:P_CURR_START,''DD-MM-YYYY'') and
733: per.end_date <= to_date(:ASOF_DATE,''DD-MM-YYYY'') and
734: f.period_type_id = 32
735:

Line 761: CASE WHEN '''||fii_gl_util_pkg.g_time_comp||'''=''BUDGET'' THEN '||l_budget||'

757:
758: sqlstmt := '
759: SELECT days VIEWBY,
760: SUM(DECODE(SIGN(report_date - to_date(:ASOF_DATE,''DD-MM-YYYY'')),1,NULL,CY_REV)) FII_CURRENT_TD ,
761: CASE WHEN '''||fii_gl_util_pkg.g_time_comp||'''=''BUDGET'' THEN '||l_budget||'
762: ELSE SUM(DECODE(SIGN(report_date - to_date(:P_PRIOR_END,''DD-MM-YYYY'')),1,NULL,PY_REV))
763: END FII_PRIOR_TD,
764: '||l_forecast||' FII_FORECAST
765: FROM(

Line 771: ( SELECT * FROM FII_GL_MGMT_SUM_V'||fii_gl_util_pkg.g_global_curr_view||' f

767: report_date,
768: NVL(SUM(SUM(f.actual_g)) OVER (ORDER BY g.report_date-to_date(:P_CURR_START,''DD-MM-YYYY'')+to_number('||l_adjust1||') ROWS UNBOUNDED PRECEDING),0) CY_REV,
769: 0 PY_REV
770: FROM fii_time_day g,
771: ( SELECT * FROM FII_GL_MGMT_SUM_V'||fii_gl_util_pkg.g_global_curr_view||' f
772: WHERE ( 1=1 and f.person_id(+) = '||l_dummy_mgr_id||' and
773: f.manager_id(+) = :MGR_MGR_ID and
774: f.gid (+) = 4 and
775: f.period_type_id (+) = 1

Line 776: '||fii_gl_util_pkg.g_cat_join||')

772: WHERE ( 1=1 and f.person_id(+) = '||l_dummy_mgr_id||' and
773: f.manager_id(+) = :MGR_MGR_ID and
774: f.gid (+) = 4 and
775: f.period_type_id (+) = 1
776: '||fii_gl_util_pkg.g_cat_join||')
777: ) f
778: WHERE g.report_date_julian = f.time_id (+) and
779: g.report_date_julian between :CURR_START_DAY_ID and :CURR_END_DAY_ID
780:

Line 790: ( SELECT * FROM FII_GL_MGMT_SUM_V'||fii_gl_util_pkg.g_global_curr_view||' f

786: report_date,
787: to_number(NULL) CY_REV,
788: NVL(SUM(SUM(f.actual_g)) OVER (ORDER BY g.report_date-to_date(:P_PRIOR_START,''DD-MM-YYYY'')+to_number('||l_adjust2||') ROWS UNBOUNDED PRECEDING),0) PY_REV
789: FROM fii_time_day g,
790: ( SELECT * FROM FII_GL_MGMT_SUM_V'||fii_gl_util_pkg.g_global_curr_view||' f
791: WHERE ( 1=1 and f.person_id(+) = '||l_dummy_mgr_id||' and
792: f.manager_id(+) = :MGR_MGR_ID and
793: f.gid (+) = 4 and
794: f.period_type_id (+) = 1

Line 795: '||fii_gl_util_pkg.g_cat_join||')

791: WHERE ( 1=1 and f.person_id(+) = '||l_dummy_mgr_id||' and
792: f.manager_id(+) = :MGR_MGR_ID and
793: f.gid (+) = 4 and
794: f.period_type_id (+) = 1
795: '||fii_gl_util_pkg.g_cat_join||')
796: ) f
797: WHERE g.report_date_julian = f.time_id (+) and
798: g.report_date_julian between :PRIOR_START_DAY_ID and :PRIOR_END_DAY_ID
799:

Line 809: fii_gl_util_pkg.bind_variable(p_sqlstmt=>sqlstmt,

805: END CASE;
806:
807: END CASE;
808:
809: fii_gl_util_pkg.bind_variable(p_sqlstmt=>sqlstmt,
810: p_page_parameter_tbl=>p_page_parameter_tbl,
811: p_sql_output=>cumul_rev_sql,
812: p_bind_output_table=>cumul_rev_output);
813: END get_cumul_rev;