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_EA_SUM_TREND_PKG dependencies on FII_EA_UTIL_PKG

Line 16: fii_ea_util_pkg.reset_globals;

12:
13: sqlstmt VARCHAR2(30000);
14:
15: BEGIN
16: fii_ea_util_pkg.reset_globals;
17: fii_ea_util_pkg.g_fin_cat_type := 'OE';
18:
19: sqlstmt := fii_ea_sum_trend_pkg.get_revexp_sum(p_page_parameter_tbl);
20: fii_ea_util_pkg.bind_variable(sqlstmt, p_page_parameter_tbl, exp_sum_sql, exp_sum_output);

Line 17: fii_ea_util_pkg.g_fin_cat_type := 'OE';

13: sqlstmt VARCHAR2(30000);
14:
15: BEGIN
16: fii_ea_util_pkg.reset_globals;
17: fii_ea_util_pkg.g_fin_cat_type := 'OE';
18:
19: sqlstmt := fii_ea_sum_trend_pkg.get_revexp_sum(p_page_parameter_tbl);
20: fii_ea_util_pkg.bind_variable(sqlstmt, p_page_parameter_tbl, exp_sum_sql, exp_sum_output);
21:

Line 20: fii_ea_util_pkg.bind_variable(sqlstmt, p_page_parameter_tbl, exp_sum_sql, exp_sum_output);

16: fii_ea_util_pkg.reset_globals;
17: fii_ea_util_pkg.g_fin_cat_type := 'OE';
18:
19: sqlstmt := fii_ea_sum_trend_pkg.get_revexp_sum(p_page_parameter_tbl);
20: fii_ea_util_pkg.bind_variable(sqlstmt, p_page_parameter_tbl, exp_sum_sql, exp_sum_output);
21:
22: END get_exp_sum;
23:
24: -- get_rev_sum procedure is called by Revenue Summary report. It is a wrapper for get_revexp_sum.

Line 33: fii_ea_util_pkg.reset_globals;

29:
30: sqlstmt VARCHAR2(30000);
31:
32: BEGIN
33: fii_ea_util_pkg.reset_globals;
34: fii_ea_util_pkg.g_fin_cat_type := 'R';
35:
36: sqlstmt := fii_ea_sum_trend_pkg.get_revexp_sum(p_page_parameter_tbl);
37: fii_ea_util_pkg.bind_variable(sqlstmt, p_page_parameter_tbl, rev_sum_sql, rev_sum_output);

Line 34: fii_ea_util_pkg.g_fin_cat_type := 'R';

30: sqlstmt VARCHAR2(30000);
31:
32: BEGIN
33: fii_ea_util_pkg.reset_globals;
34: fii_ea_util_pkg.g_fin_cat_type := 'R';
35:
36: sqlstmt := fii_ea_sum_trend_pkg.get_revexp_sum(p_page_parameter_tbl);
37: fii_ea_util_pkg.bind_variable(sqlstmt, p_page_parameter_tbl, rev_sum_sql, rev_sum_output);
38:

Line 37: fii_ea_util_pkg.bind_variable(sqlstmt, p_page_parameter_tbl, rev_sum_sql, rev_sum_output);

33: fii_ea_util_pkg.reset_globals;
34: fii_ea_util_pkg.g_fin_cat_type := 'R';
35:
36: sqlstmt := fii_ea_sum_trend_pkg.get_revexp_sum(p_page_parameter_tbl);
37: fii_ea_util_pkg.bind_variable(sqlstmt, p_page_parameter_tbl, rev_sum_sql, rev_sum_output);
38:
39: END get_rev_sum;
40:
41: --

Line 52: fii_ea_util_pkg.reset_globals;

48:
49: sqlstmt VARCHAR2(30000);
50:
51: BEGIN
52: fii_ea_util_pkg.reset_globals;
53: fii_ea_util_pkg.g_fin_cat_type := 'CGS';
54:
55: sqlstmt := fii_ea_sum_trend_pkg.get_revexp_sum(p_page_parameter_tbl);
56:

Line 53: fii_ea_util_pkg.g_fin_cat_type := 'CGS';

49: sqlstmt VARCHAR2(30000);
50:
51: BEGIN
52: fii_ea_util_pkg.reset_globals;
53: fii_ea_util_pkg.g_fin_cat_type := 'CGS';
54:
55: sqlstmt := fii_ea_sum_trend_pkg.get_revexp_sum(p_page_parameter_tbl);
56:
57: fii_ea_util_pkg.bind_variable(sqlstmt, p_page_parameter_tbl, rev_sum_sql, rev_sum_output);

Line 57: fii_ea_util_pkg.bind_variable(sqlstmt, p_page_parameter_tbl, rev_sum_sql, rev_sum_output);

53: fii_ea_util_pkg.g_fin_cat_type := 'CGS';
54:
55: sqlstmt := fii_ea_sum_trend_pkg.get_revexp_sum(p_page_parameter_tbl);
56:
57: fii_ea_util_pkg.bind_variable(sqlstmt, p_page_parameter_tbl, rev_sum_sql, rev_sum_output);
58:
59: END get_cgs_sum;
60:
61: -- get_revexp_sum is a common procedure, used both by Expense and Revenue Summary reports

Line 105: fii_ea_util_pkg.get_parameters(p_page_parameter_tbl);

101: l_drill_source VARCHAR2(40);
102:
103:
104: BEGIN
105: fii_ea_util_pkg.get_parameters(p_page_parameter_tbl);
106: fii_ea_util_pkg.get_rolling_period;
107: fii_ea_util_pkg.get_viewby_id(p_aggrt_viewby_id, p_snap_aggrt_viewby_id, p_nonaggrt_viewby_id);
108: fii_ea_util_pkg.populate_security_gt_tables(p_aggrt_gt_is_empty, p_non_aggrt_gt_is_empty);
109:

Line 106: fii_ea_util_pkg.get_rolling_period;

102:
103:
104: BEGIN
105: fii_ea_util_pkg.get_parameters(p_page_parameter_tbl);
106: fii_ea_util_pkg.get_rolling_period;
107: fii_ea_util_pkg.get_viewby_id(p_aggrt_viewby_id, p_snap_aggrt_viewby_id, p_nonaggrt_viewby_id);
108: fii_ea_util_pkg.populate_security_gt_tables(p_aggrt_gt_is_empty, p_non_aggrt_gt_is_empty);
109:
110: CASE fii_ea_util_pkg.g_page_period_type -- we set different 'period type' dependent variables in this CASE structure

Line 107: fii_ea_util_pkg.get_viewby_id(p_aggrt_viewby_id, p_snap_aggrt_viewby_id, p_nonaggrt_viewby_id);

103:
104: BEGIN
105: fii_ea_util_pkg.get_parameters(p_page_parameter_tbl);
106: fii_ea_util_pkg.get_rolling_period;
107: fii_ea_util_pkg.get_viewby_id(p_aggrt_viewby_id, p_snap_aggrt_viewby_id, p_nonaggrt_viewby_id);
108: fii_ea_util_pkg.populate_security_gt_tables(p_aggrt_gt_is_empty, p_non_aggrt_gt_is_empty);
109:
110: CASE fii_ea_util_pkg.g_page_period_type -- we set different 'period type' dependent variables in this CASE structure
111:

Line 108: fii_ea_util_pkg.populate_security_gt_tables(p_aggrt_gt_is_empty, p_non_aggrt_gt_is_empty);

104: BEGIN
105: fii_ea_util_pkg.get_parameters(p_page_parameter_tbl);
106: fii_ea_util_pkg.get_rolling_period;
107: fii_ea_util_pkg.get_viewby_id(p_aggrt_viewby_id, p_snap_aggrt_viewby_id, p_nonaggrt_viewby_id);
108: fii_ea_util_pkg.populate_security_gt_tables(p_aggrt_gt_is_empty, p_non_aggrt_gt_is_empty);
109:
110: CASE fii_ea_util_pkg.g_page_period_type -- we set different 'period type' dependent variables in this CASE structure
111:
112: WHEN 'FII_TIME_ENT_YEAR' THEN

Line 110: CASE fii_ea_util_pkg.g_page_period_type -- we set different 'period type' dependent variables in this CASE structure

106: fii_ea_util_pkg.get_rolling_period;
107: fii_ea_util_pkg.get_viewby_id(p_aggrt_viewby_id, p_snap_aggrt_viewby_id, p_nonaggrt_viewby_id);
108: fii_ea_util_pkg.populate_security_gt_tables(p_aggrt_gt_is_empty, p_non_aggrt_gt_is_empty);
109:
110: CASE fii_ea_util_pkg.g_page_period_type -- we set different 'period type' dependent variables in this CASE structure
111:
112: WHEN 'FII_TIME_ENT_YEAR' THEN
113: l_roll_column := 'qtd';
114: l_xtd_column := 'ytd' ;

Line 126: IF (fii_ea_util_pkg.g_time_comp = 'BUDGET') THEN

122: l_xtd_column := 'mtd' ;
123:
124: END CASE;
125:
126: IF (fii_ea_util_pkg.g_time_comp = 'BUDGET') THEN
127: l_snap_prior := 'SUM(f.budget_cur_'||l_xtd_column||') FII_EA_PRIOR_XTD_EXP_G,
128: NULL FII_EA_PRIOR_XTD_EXP,
129: NULL FII_EA_PRIOR_BUDGET,
130: NULL FII_EA_PRIOR_FORECAST,

Line 141: ELSIF fii_ea_util_pkg.g_time_comp = 'SEQUENTIAL' THEN

137: NULL FII_EA_PRIOR_BUDGET,
138: NULL FII_EA_PRIOR_FORECAST,
139: NULL FII_EA_PRIOR_TOTAL_G,
140: NULL FII_EA_CURR_TOTAL_G,';
141: ELSIF fii_ea_util_pkg.g_time_comp = 'SEQUENTIAL' THEN
142: l_snap_prior := 'SUM(f.actual_prior_'||l_xtd_column||') FII_EA_PRIOR_XTD_EXP_G,
143: SUM(f.actual_prior_'||l_xtd_column||') FII_EA_PRIOR_XTD_EXP,
144: SUM(f.budget_prior_'||l_xtd_column||') FII_EA_PRIOR_BUDGET,
145: SUM(f.forecast_prior_'||l_xtd_column||') FII_EA_PRIOR_FORECAST,

Line 166: ELSIF fii_ea_util_pkg.g_page_period_type = 'FII_TIME_ENT_YEAR' THEN

162: THEN f.actual_g ELSE NULL END))) FII_EA_PRIOR_TOTAL_G,
163: SUM(DECODE(inner_inline_view.report_date, :CURR_PERIOD_END,
164: (CASE WHEN bitand(inner_inline_view.record_type_id,:ACTUAL_BITAND) = :ACTUAL_BITAND
165: THEN f.actual_g ELSE NULL END))) FII_EA_CURR_TOTAL_G,';
166: ELSIF fii_ea_util_pkg.g_page_period_type = 'FII_TIME_ENT_YEAR' THEN
167: l_snap_prior := 'SUM(f.actual_prior_'||l_xtd_column||') FII_EA_PRIOR_XTD_EXP_G,
168: SUM(f.actual_prior_'||l_xtd_column||') FII_EA_PRIOR_XTD_EXP,
169: SUM(f.budget_prior_'||l_xtd_column||') FII_EA_PRIOR_BUDGET,
170: SUM(f.forecast_prior_'||l_xtd_column||') FII_EA_PRIOR_FORECAST,

Line 225: IF fii_ea_util_pkg.g_fin_category_id = 'All' THEN

221: -- For this, while keeping parent_id as A, we want to look only for A in fii_gl_base_map_mv
222: -- so that we do not get duplication of actuals..hence we append conditional decode
223: -- statements l_cat_decode and l_fud1_decode in l_sqlstmt2 and l_snap_sqlstmt2..
224:
225: IF fii_ea_util_pkg.g_fin_category_id = 'All' THEN
226: IF fii_ea_util_pkg.g_fin_cat_top_node_count = 1 THEN
227: l_cat_decode := 'and fin_hier.parent_fin_cat_id = decode(fin_hier.parent_fin_cat_id,:CATEGORY_ID,
228: fin_hier.child_fin_cat_id,fin_hier.parent_fin_cat_id)';
229: END IF;

Line 226: IF fii_ea_util_pkg.g_fin_cat_top_node_count = 1 THEN

222: -- so that we do not get duplication of actuals..hence we append conditional decode
223: -- statements l_cat_decode and l_fud1_decode in l_sqlstmt2 and l_snap_sqlstmt2..
224:
225: IF fii_ea_util_pkg.g_fin_category_id = 'All' THEN
226: IF fii_ea_util_pkg.g_fin_cat_top_node_count = 1 THEN
227: l_cat_decode := 'and fin_hier.parent_fin_cat_id = decode(fin_hier.parent_fin_cat_id,:CATEGORY_ID,
228: fin_hier.child_fin_cat_id,fin_hier.parent_fin_cat_id)';
229: END IF;
230: ELSE

Line 235: IF fii_ea_util_pkg.g_view_by = 'FINANCIAL ITEM+GL_FII_FIN_ITEM' THEN

231: l_cat_decode := 'and fin_hier.parent_fin_cat_id = DECODE(fin_hier.parent_fin_cat_id, :CATEGORY_ID,
232: fin_hier.child_fin_cat_id, fin_hier.parent_fin_cat_id)';
233: END IF;
234:
235: IF fii_ea_util_pkg.g_view_by = 'FINANCIAL ITEM+GL_FII_FIN_ITEM' THEN
236:
237: fii_ea_util_pkg.check_if_leaf(fii_ea_util_pkg.g_category_id);
238: l_if_leaf_flag := fii_ea_util_pkg.g_fin_cat_is_leaf;
239:

Line 237: fii_ea_util_pkg.check_if_leaf(fii_ea_util_pkg.g_category_id);

233: END IF;
234:
235: IF fii_ea_util_pkg.g_view_by = 'FINANCIAL ITEM+GL_FII_FIN_ITEM' THEN
236:
237: fii_ea_util_pkg.check_if_leaf(fii_ea_util_pkg.g_category_id);
238: l_if_leaf_flag := fii_ea_util_pkg.g_fin_cat_is_leaf;
239:
240: -- This issue was found during testing of fix for bug 4127077. Since these variables are used to check for loading of budgets against summary nodes,
241: -- we don't need to append l_budget_snap_decode and l_budget_decode to the main sql, when we choose a leaf category node.

Line 238: l_if_leaf_flag := fii_ea_util_pkg.g_fin_cat_is_leaf;

234:
235: IF fii_ea_util_pkg.g_view_by = 'FINANCIAL ITEM+GL_FII_FIN_ITEM' THEN
236:
237: fii_ea_util_pkg.check_if_leaf(fii_ea_util_pkg.g_category_id);
238: l_if_leaf_flag := fii_ea_util_pkg.g_fin_cat_is_leaf;
239:
240: -- This issue was found during testing of fix for bug 4127077. Since these variables are used to check for loading of budgets against summary nodes,
241: -- we don't need to append l_budget_snap_decode and l_budget_decode to the main sql, when we choose a leaf category node.
242:

Line 251: ELSIF fii_ea_util_pkg.g_view_by = 'FII_USER_DEFINED+FII_USER_DEFINED_1' THEN

247: l_budget_decode := 'and f.fin_category_id = DECODE(:G_ID, f.fin_category_id,
248: DECODE(f.time_id,:TIME_ID, f.fin_category_id,-99999),f.fin_category_id)';
249: END IF;
250:
251: ELSIF fii_ea_util_pkg.g_view_by = 'FII_USER_DEFINED+FII_USER_DEFINED_1' THEN
252:
253: fii_ea_util_pkg.check_if_leaf(fii_ea_util_pkg.g_udd1_id);
254: l_if_leaf_flag := fii_ea_util_pkg.g_ud1_is_leaf;
255:

Line 253: fii_ea_util_pkg.check_if_leaf(fii_ea_util_pkg.g_udd1_id);

249: END IF;
250:
251: ELSIF fii_ea_util_pkg.g_view_by = 'FII_USER_DEFINED+FII_USER_DEFINED_1' THEN
252:
253: fii_ea_util_pkg.check_if_leaf(fii_ea_util_pkg.g_udd1_id);
254: l_if_leaf_flag := fii_ea_util_pkg.g_ud1_is_leaf;
255:
256: -- This issue was found during testing of fix for bug 4127077. Since these variables are used to check for loading of budgets against summary nodes,
257: -- we don't need to append l_budget_snap_decode and l_budget_decode to the main sql, when we choose a leaf fud1 node.

Line 254: l_if_leaf_flag := fii_ea_util_pkg.g_ud1_is_leaf;

250:
251: ELSIF fii_ea_util_pkg.g_view_by = 'FII_USER_DEFINED+FII_USER_DEFINED_1' THEN
252:
253: fii_ea_util_pkg.check_if_leaf(fii_ea_util_pkg.g_udd1_id);
254: l_if_leaf_flag := fii_ea_util_pkg.g_ud1_is_leaf;
255:
256: -- This issue was found during testing of fix for bug 4127077. Since these variables are used to check for loading of budgets against summary nodes,
257: -- we don't need to append l_budget_snap_decode and l_budget_decode to the main sql, when we choose a leaf fud1 node.
258:

Line 275: SELECT DECODE(fii_ea_util_pkg.g_region_code,'FII_EA_EXP_SUM','FII_EA_EXP_SUM','FII_PSI_EXP_SUM')

271: -- Done for enhancement 4269343
272: -- Depending upon the drill source, i.e. Funds Management Page OR Expense Analysis page, the drill source
273: -- changes accordingly
274:
275: SELECT DECODE(fii_ea_util_pkg.g_region_code,'FII_EA_EXP_SUM','FII_EA_EXP_SUM','FII_PSI_EXP_SUM')
276: INTO l_drill_source
277: FROM DUAL;
278:
279: -- Checking if User Defined Dimension2 is enabled

Line 287: IF fii_ea_util_pkg.g_view_by = 'FII_USER_DEFINED+FII_USER_DEFINED_2' THEN

283: WHERE dimension_short_name = 'FII_USER_DEFINED_2';
284:
285: IF l_fud2_enabled_flag = 'Y' THEN
286:
287: IF fii_ea_util_pkg.g_view_by = 'FII_USER_DEFINED+FII_USER_DEFINED_2' THEN
288:
289: l_fud2_from := ' fii_udd2_hierarchies fud2_hier, ';
290:
291: l_fud2_snap_where := ' and fud2_hier.parent_value_id = gt.fud2_id

Line 297: ELSIF fii_ea_util_pkg.g_fud2_id <> 'All' THEN

293:
294: l_fud2_where := ' and fud2_hier.parent_value_id = inner_inline_view.fud2_id
295: and fud2_hier.child_value_id = f.fud2_id ';
296:
297: ELSIF fii_ea_util_pkg.g_fud2_id <> 'All' THEN
298:
299: l_fud2_from := ' fii_udd2_hierarchies fud2_hier, ';
300:
301: l_fud2_snap_where := ' and fud2_hier.parent_value_id = gt.fud2_id

Line 310: IF fii_ea_util_pkg.g_fin_cat_type = 'R' THEN

306: END IF;
307:
308: END IF;
309:
310: IF fii_ea_util_pkg.g_fin_cat_type = 'R' THEN
311: l_viewby_drill_url := 'pFunctionName=FII_EA_REV_SUM&VIEW_BY_NAME=VIEW_BY_ID&VIEW_BY=VIEW_BY&pParamIds=Y';
312: l_xtd_drill_url := 'pFunctionName=FII_EA_REV_TREND_DTL&VIEW_BY=TIME+FII_TIME_ENT_PERIOD&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y';
313: ELSIF fii_ea_util_pkg.g_fin_cat_type = 'CGS' THEN
314: l_viewby_drill_url := 'pFunctionName=FII_PL_COGS_SUM&VIEW_BY_NAME=VIEW_BY_ID&VIEW_BY=VIEW_BY&pParamIds=Y';

Line 313: ELSIF fii_ea_util_pkg.g_fin_cat_type = 'CGS' THEN

309:
310: IF fii_ea_util_pkg.g_fin_cat_type = 'R' THEN
311: l_viewby_drill_url := 'pFunctionName=FII_EA_REV_SUM&VIEW_BY_NAME=VIEW_BY_ID&VIEW_BY=VIEW_BY&pParamIds=Y';
312: l_xtd_drill_url := 'pFunctionName=FII_EA_REV_TREND_DTL&VIEW_BY=TIME+FII_TIME_ENT_PERIOD&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y';
313: ELSIF fii_ea_util_pkg.g_fin_cat_type = 'CGS' THEN
314: l_viewby_drill_url := 'pFunctionName=FII_PL_COGS_SUM&VIEW_BY_NAME=VIEW_BY_ID&VIEW_BY=VIEW_BY&pParamIds=Y';
315: l_xtd_drill_url := 'pFunctionName=FII_PL_CGS_TREND_DTL&VIEW_BY=TIME+FII_TIME_ENT_PERIOD&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y';
316: ELSE
317: l_viewby_drill_url := 'pFunctionName='||l_drill_source||'&VIEW_BY_NAME=VIEW_BY_ID&VIEW_BY=VIEW_BY&pParamIds=Y';

Line 353: FROM fii_gl_agrt_sum_mv'||fii_ea_util_pkg.g_curr_view||' f,

349: (CASE WHEN bitand(inner_inline_view.record_type_id,:FORECAST_BITAND) = :FORECAST_BITAND
350: THEN f.forecast_g ELSE NULL END) ) ) FII_EA_FORECAST
351:
352:
353: FROM fii_gl_agrt_sum_mv'||fii_ea_util_pkg.g_curr_view||' f,
354: '||l_fud2_from||'
355: ( select /*+ NO_MERGE cardinality(gt 1) */ *
356: from fii_time_structures cal,
357: fii_pmv_aggrt_gt gt

Line 418: FROM fii_gl_base_map_mv'||fii_ea_util_pkg.g_curr_view||' f,

414: SUM(DECODE(inner_inline_view.report_date, :ASOF_DATE,
415: (CASE WHEN bitand(inner_inline_view.record_type_id,:FORECAST_BITAND) = :FORECAST_BITAND
416: THEN f.forecast_g ELSE NULL END) ) ) FII_EA_FORECAST
417:
418: FROM fii_gl_base_map_mv'||fii_ea_util_pkg.g_curr_view||' f,
419: fii_company_hierarchies co_hier,
420: fii_cost_ctr_hierarchies cc_hier,
421: fii_fin_item_leaf_hiers fin_hier,
422: fii_udd1_hierarchies fud1_hier,

Line 475: FROM fii_gl_snap_sum_f'||fii_ea_util_pkg.g_curr_view||' f,

471: SUM(f.budget_cur_'||l_xtd_column||') FII_EA_BUDGET,
472: SUM(f.forecast_cur_'||l_xtd_column||') FII_EA_FORECAST
473:
474:
475: FROM fii_gl_snap_sum_f'||fii_ea_util_pkg.g_curr_view||' f,
476: '||l_fud2_from||'
477: fii_pmv_aggrt_gt gt
478:
479: WHERE f.parent_company_id = gt.parent_company_id

Line 524: FROM fii_gl_agrt_sum_mv'||fii_ea_util_pkg.g_curr_view||' f,

520: THEN f.actual_g ELSE NULL END))) FII_EA_CURR_TOTAL_G,
521: NULL FII_EA_BUDGET,
522: NULL FII_EA_FORECAST
523:
524: FROM fii_gl_agrt_sum_mv'||fii_ea_util_pkg.g_curr_view||' f,
525: '||l_fud2_from||'
526: ( select /*+ NO_MERGE cardinality(gt 1) */ *
527: from fii_time_structures cal,
528: fii_pmv_aggrt_gt gt

Line 590: FROM fii_gl_base_map_mv'||fii_ea_util_pkg.g_curr_view||' f,

586: (CASE WHEN bitand(inner_inline_view.record_type_id,:FORECAST_BITAND) = :FORECAST_BITAND
587: THEN f.forecast_g ELSE NULL END) ) ) FII_EA_FORECAST
588:
589:
590: FROM fii_gl_base_map_mv'||fii_ea_util_pkg.g_curr_view||' f,
591: fii_company_hierarchies co_hier,
592: fii_cost_ctr_hierarchies cc_hier,
593: fii_fin_item_leaf_hiers fin_hier,
594: fii_udd1_hierarchies fud1_hier,

Line 657: FROM fii_gl_trend_sum_mv'||fii_ea_util_pkg.g_curr_view||' f,

653: (CASE WHEN bitand(inner_inline_view.record_type_id,:FORECAST_BITAND) = :FORECAST_BITAND
654: THEN f.forecast_g ELSE NULL END) ) ) FII_EA_FORECAST
655:
656:
657: FROM fii_gl_trend_sum_mv'||fii_ea_util_pkg.g_curr_view||' f,
658: ( SELECT /*+ NO_MERGE cardinality(gt 1) */ *
659: FROM fii_time_structures cal,
660: fii_pmv_aggrt_gt gt
661: where report_date in ( :PREVIOUS_ONE_END_DATE, :PREVIOUS_TWO_END_DATE,

Line 684: IF fii_ea_util_pkg.g_if_trend_sum_mv = 'Y' THEN

680: '||l_budget_decode||'
681:
682: GROUP BY '||p_aggrt_viewby_id||', inner_inline_view.viewby, inner_inline_view.sort_order';
683:
684: IF fii_ea_util_pkg.g_if_trend_sum_mv = 'Y' THEN
685:
686: l_aggrt_sql := l_trend_sum_mv_sql;
687:
688: ELSIF fii_ea_util_pkg.g_snapshot = 'Y' THEN

Line 688: ELSIF fii_ea_util_pkg.g_snapshot = 'Y' THEN

684: IF fii_ea_util_pkg.g_if_trend_sum_mv = 'Y' THEN
685:
686: l_aggrt_sql := l_trend_sum_mv_sql;
687:
688: ELSIF fii_ea_util_pkg.g_snapshot = 'Y' THEN
689:
690:
691: IF p_aggrt_gt_is_empty = 'N' then -- aggrt GT table is populated
692:

Line 836: fii_ea_util_pkg.reset_globals;

832:
833: l_sqlstmt VARCHAR2(30000);
834:
835: BEGIN
836: fii_ea_util_pkg.reset_globals;
837: fii_ea_util_pkg.g_fin_cat_type := 'CGS';
838:
839: l_sqlstmt := fii_ea_sum_trend_pkg.get_revexp_trend(p_page_parameter_tbl);
840: fii_ea_util_pkg.bind_variable( l_sqlstmt

Line 837: fii_ea_util_pkg.g_fin_cat_type := 'CGS';

833: l_sqlstmt VARCHAR2(30000);
834:
835: BEGIN
836: fii_ea_util_pkg.reset_globals;
837: fii_ea_util_pkg.g_fin_cat_type := 'CGS';
838:
839: l_sqlstmt := fii_ea_sum_trend_pkg.get_revexp_trend(p_page_parameter_tbl);
840: fii_ea_util_pkg.bind_variable( l_sqlstmt
841: ,p_page_parameter_tbl

Line 840: fii_ea_util_pkg.bind_variable( l_sqlstmt

836: fii_ea_util_pkg.reset_globals;
837: fii_ea_util_pkg.g_fin_cat_type := 'CGS';
838:
839: l_sqlstmt := fii_ea_sum_trend_pkg.get_revexp_trend(p_page_parameter_tbl);
840: fii_ea_util_pkg.bind_variable( l_sqlstmt
841: ,p_page_parameter_tbl
842: ,p_cogs_trend_sql
843: ,p_cogs_trend_output
844: );

Line 858: fii_ea_util_pkg.reset_globals;

854:
855: sqlstmt VARCHAR2(30000);
856:
857: BEGIN
858: fii_ea_util_pkg.reset_globals;
859: fii_ea_util_pkg.g_fin_cat_type := 'OE';
860:
861: sqlstmt := fii_ea_sum_trend_pkg.get_revexp_trend(p_page_parameter_tbl);
862: fii_ea_util_pkg.bind_variable(sqlstmt, p_page_parameter_tbl, exp_trend_sql, exp_trend_output);

Line 859: fii_ea_util_pkg.g_fin_cat_type := 'OE';

855: sqlstmt VARCHAR2(30000);
856:
857: BEGIN
858: fii_ea_util_pkg.reset_globals;
859: fii_ea_util_pkg.g_fin_cat_type := 'OE';
860:
861: sqlstmt := fii_ea_sum_trend_pkg.get_revexp_trend(p_page_parameter_tbl);
862: fii_ea_util_pkg.bind_variable(sqlstmt, p_page_parameter_tbl, exp_trend_sql, exp_trend_output);
863:

Line 862: fii_ea_util_pkg.bind_variable(sqlstmt, p_page_parameter_tbl, exp_trend_sql, exp_trend_output);

858: fii_ea_util_pkg.reset_globals;
859: fii_ea_util_pkg.g_fin_cat_type := 'OE';
860:
861: sqlstmt := fii_ea_sum_trend_pkg.get_revexp_trend(p_page_parameter_tbl);
862: fii_ea_util_pkg.bind_variable(sqlstmt, p_page_parameter_tbl, exp_trend_sql, exp_trend_output);
863:
864: END get_exp_trend;
865:
866: -- get_rev_trend procedure is called by Revenue Rolling Trend report. It is a wrapper for get_revexp_trend.

Line 875: fii_ea_util_pkg.reset_globals;

871:
872: sqlstmt VARCHAR2(30000);
873:
874: BEGIN
875: fii_ea_util_pkg.reset_globals;
876: fii_ea_util_pkg.g_fin_cat_type := 'R';
877:
878: sqlstmt := fii_ea_sum_trend_pkg.get_revexp_trend(p_page_parameter_tbl);
879: fii_ea_util_pkg.bind_variable(sqlstmt, p_page_parameter_tbl, rev_trend_sql, rev_trend_output);

Line 876: fii_ea_util_pkg.g_fin_cat_type := 'R';

872: sqlstmt VARCHAR2(30000);
873:
874: BEGIN
875: fii_ea_util_pkg.reset_globals;
876: fii_ea_util_pkg.g_fin_cat_type := 'R';
877:
878: sqlstmt := fii_ea_sum_trend_pkg.get_revexp_trend(p_page_parameter_tbl);
879: fii_ea_util_pkg.bind_variable(sqlstmt, p_page_parameter_tbl, rev_trend_sql, rev_trend_output);
880:

Line 879: fii_ea_util_pkg.bind_variable(sqlstmt, p_page_parameter_tbl, rev_trend_sql, rev_trend_output);

875: fii_ea_util_pkg.reset_globals;
876: fii_ea_util_pkg.g_fin_cat_type := 'R';
877:
878: sqlstmt := fii_ea_sum_trend_pkg.get_revexp_trend(p_page_parameter_tbl);
879: fii_ea_util_pkg.bind_variable(sqlstmt, p_page_parameter_tbl, rev_trend_sql, rev_trend_output);
880:
881: END get_rev_trend;
882:
883: -- get_revexp_trend is a common procedure, used both by Expense and Revenue Rolling Trend reports

Line 912: fii_ea_util_pkg.get_parameters(p_page_parameter_tbl);

908: l_trend_sum_mv_sql VARCHAR2(10000) := NULL;
909:
910: BEGIN
911:
912: fii_ea_util_pkg.get_parameters(p_page_parameter_tbl);
913: fii_ea_util_pkg.g_page_period_type := 'FII_TIME_ENT_PERIOD';
914: fii_ea_util_pkg.populate_security_gt_tables(p_aggrt_gt_is_empty, p_non_aggrt_gt_is_empty);
915: l_ledger_where := fii_ea_util_pkg.get_ledger_for_detail;
916:

Line 913: fii_ea_util_pkg.g_page_period_type := 'FII_TIME_ENT_PERIOD';

909:
910: BEGIN
911:
912: fii_ea_util_pkg.get_parameters(p_page_parameter_tbl);
913: fii_ea_util_pkg.g_page_period_type := 'FII_TIME_ENT_PERIOD';
914: fii_ea_util_pkg.populate_security_gt_tables(p_aggrt_gt_is_empty, p_non_aggrt_gt_is_empty);
915: l_ledger_where := fii_ea_util_pkg.get_ledger_for_detail;
916:
917: SELECT DISTINCT per.sequence INTO l_curr_per_sequence

Line 914: fii_ea_util_pkg.populate_security_gt_tables(p_aggrt_gt_is_empty, p_non_aggrt_gt_is_empty);

910: BEGIN
911:
912: fii_ea_util_pkg.get_parameters(p_page_parameter_tbl);
913: fii_ea_util_pkg.g_page_period_type := 'FII_TIME_ENT_PERIOD';
914: fii_ea_util_pkg.populate_security_gt_tables(p_aggrt_gt_is_empty, p_non_aggrt_gt_is_empty);
915: l_ledger_where := fii_ea_util_pkg.get_ledger_for_detail;
916:
917: SELECT DISTINCT per.sequence INTO l_curr_per_sequence
918: FROM FII_TIME_ENT_PERIOD per

Line 915: l_ledger_where := fii_ea_util_pkg.get_ledger_for_detail;

911:
912: fii_ea_util_pkg.get_parameters(p_page_parameter_tbl);
913: fii_ea_util_pkg.g_page_period_type := 'FII_TIME_ENT_PERIOD';
914: fii_ea_util_pkg.populate_security_gt_tables(p_aggrt_gt_is_empty, p_non_aggrt_gt_is_empty);
915: l_ledger_where := fii_ea_util_pkg.get_ledger_for_detail;
916:
917: SELECT DISTINCT per.sequence INTO l_curr_per_sequence
918: FROM FII_TIME_ENT_PERIOD per
919: WHERE fii_ea_util_pkg.g_as_of_date BETWEEN per.start_date and per.end_date;

Line 919: WHERE fii_ea_util_pkg.g_as_of_date BETWEEN per.start_date and per.end_date;

915: l_ledger_where := fii_ea_util_pkg.get_ledger_for_detail;
916:
917: SELECT DISTINCT per.sequence INTO l_curr_per_sequence
918: FROM FII_TIME_ENT_PERIOD per
919: WHERE fii_ea_util_pkg.g_as_of_date BETWEEN per.start_date and per.end_date;
920:
921: IF fii_ea_util_pkg.g_fin_cat_type = 'R' THEN
922: l_cat_type := 'EA_REV';
923: ELSIF fii_ea_util_pkg.g_fin_cat_type = 'CGS' THEN

Line 921: IF fii_ea_util_pkg.g_fin_cat_type = 'R' THEN

917: SELECT DISTINCT per.sequence INTO l_curr_per_sequence
918: FROM FII_TIME_ENT_PERIOD per
919: WHERE fii_ea_util_pkg.g_as_of_date BETWEEN per.start_date and per.end_date;
920:
921: IF fii_ea_util_pkg.g_fin_cat_type = 'R' THEN
922: l_cat_type := 'EA_REV';
923: ELSIF fii_ea_util_pkg.g_fin_cat_type = 'CGS' THEN
924: l_cat_type := 'PL_CGS';
925: ELSE

Line 923: ELSIF fii_ea_util_pkg.g_fin_cat_type = 'CGS' THEN

919: WHERE fii_ea_util_pkg.g_as_of_date BETWEEN per.start_date and per.end_date;
920:
921: IF fii_ea_util_pkg.g_fin_cat_type = 'R' THEN
922: l_cat_type := 'EA_REV';
923: ELSIF fii_ea_util_pkg.g_fin_cat_type = 'CGS' THEN
924: l_cat_type := 'PL_CGS';
925: ELSE
926: l_cat_type := 'EA_EXP';
927: END IF;

Line 931: WHERE fii_ea_util_pkg.g_as_of_date between start_date and end_date;

927: END IF;
928:
929: SELECT end_date INTO l_curr_end_date
930: FROM fii_time_ent_period
931: WHERE fii_ea_util_pkg.g_as_of_date between start_date and end_date;
932:
933: -- Checking if User Defined Dimension2 is enabled
934:
935: SELECT dbi_enabled_flag

Line 942: IF fii_ea_util_pkg.g_fud2_id <> 'All' THEN

938: WHERE dimension_short_name = 'FII_USER_DEFINED_2';
939:
940: IF l_fud2_enabled_flag = 'Y' THEN
941:
942: IF fii_ea_util_pkg.g_fud2_id <> 'All' THEN
943:
944: l_fud2_from := ' fii_udd2_hierarchies fud2_hier, ';
945:
946: l_fud2_where := ' and fud2_hier.parent_value_id = gt.fud2_id

Line 953: IF fii_ea_util_pkg.g_as_of_date <> l_curr_end_date THEN

949:
950: END IF;
951:
952:
953: IF fii_ea_util_pkg.g_as_of_date <> l_curr_end_date THEN
954: l_union_agrt_snap_sql := 'UNION ALL
955:
956: SELECT /*+ index(f fii_gl_snap_sum_f_n1) */
957: '||l_curr_per_sequence||' FII_EFFECTIVE_NUM,

Line 960: FROM fii_gl_snap_sum_f'||fii_ea_util_pkg.g_curr_view||' f ,

956: SELECT /*+ index(f fii_gl_snap_sum_f_n1) */
957: '||l_curr_per_sequence||' FII_EFFECTIVE_NUM,
958: f.actual_cur_mtd FII_EA_XTD,
959: f.actual_last_year_mtd FII_EA_PRIOR_XTD
960: FROM fii_gl_snap_sum_f'||fii_ea_util_pkg.g_curr_view||' f ,
961: '||l_fud2_from||'
962: fii_pmv_aggrt_gt gt
963: WHERE f.parent_company_id = gt.parent_company_id
964: and f.company_id = gt.company_id

Line 985: fii_gl_base_map_mv'||fii_ea_util_pkg.g_curr_view||' f,

981: THEN f.actual_g ELSE to_number(NULL)
982: END FII_EA_PRIOR_XTD
983:
984: FROM fii_time_structures cal,
985: fii_gl_base_map_mv'||fii_ea_util_pkg.g_curr_view||' f,
986: fii_company_hierarchies co_hier,
987: fii_cost_ctr_hierarchies cc_hier,
988: fii_fin_item_leaf_hiers fin_hier,
989: fii_udd1_hierarchies fud1_hier,

Line 1020: fii_gl_agrt_sum_mv'||fii_ea_util_pkg.g_curr_view||' f,

1016: CASE WHEN per.end_date <= :SD_PRIOR
1017: THEN f.actual_g ELSE to_number(NULL)
1018: END FII_EA_PRIOR_XTD
1019: FROM fii_time_ent_period per,
1020: fii_gl_agrt_sum_mv'||fii_ea_util_pkg.g_curr_view||' f,
1021: '||l_fud2_from||'
1022: fii_pmv_aggrt_gt gt
1023:
1024: WHERE per.ent_period_id = f.time_id

Line 1049: fii_gl_agrt_sum_mv'||fii_ea_util_pkg.g_curr_view||' f,

1045: CASE WHEN per.end_date <= :SD_PRIOR
1046: THEN f.actual_g ELSE to_number(NULL)
1047: END FII_EA_PRIOR_XTD
1048: FROM fii_time_ent_period per,
1049: fii_gl_agrt_sum_mv'||fii_ea_util_pkg.g_curr_view||' f,
1050: '||l_fud2_from||'
1051: fii_pmv_aggrt_gt gt
1052:
1053: WHERE per.ent_period_id = f.time_id

Line 1079: fii_gl_base_map_mv'||fii_ea_util_pkg.g_curr_view||' f,

1075: CASE WHEN per.end_date <= :SD_PRIOR
1076: THEN f.actual_g ELSE to_number(NULL)
1077: END FII_EA_PRIOR_XTD
1078: FROM fii_time_ent_period per,
1079: fii_gl_base_map_mv'||fii_ea_util_pkg.g_curr_view||' f,
1080: fii_company_hierarchies co_hier,
1081: fii_cost_ctr_hierarchies cc_hier,
1082: fii_fin_item_leaf_hiers fin_hier,
1083: fii_udd1_hierarchies fud1_hier,

Line 1114: fii_gl_base_map_mv'||fii_ea_util_pkg.g_curr_view||' f,

1110: CASE WHEN per.end_date <= :SD_PRIOR
1111: THEN f.actual_g ELSE to_number(NULL)
1112: END FII_EA_PRIOR_XTD
1113: FROM fii_time_ent_period per,
1114: fii_gl_base_map_mv'||fii_ea_util_pkg.g_curr_view||' f,
1115: fii_company_hierarchies co_hier,
1116: fii_cost_ctr_hierarchies cc_hier,
1117: fii_fin_item_leaf_hiers fin_hier,
1118: fii_udd1_hierarchies fud1_hier,

Line 1146: fii_gl_trend_sum_mv'||fii_ea_util_pkg.g_curr_view||' f,

1142: CASE WHEN per.end_date <= :SD_PRIOR
1143: THEN f.actual_g ELSE to_number(NULL)
1144: END FII_EA_PRIOR_XTD
1145: FROM fii_time_ent_period per,
1146: fii_gl_trend_sum_mv'||fii_ea_util_pkg.g_curr_view||' f,
1147: fii_pmv_aggrt_gt gt
1148:
1149: WHERE per.ent_period_id = f.time_id
1150: and f.period_type_id = 32

Line 1160: -- IF fii_ea_util_pkg.g_as_of_date = trunc(sysdate) THEN

1156: and f.cost_center_id = gt.cc_id
1157: and f.parent_fin_category_id = gt.parent_fin_category_id
1158: and f.fin_category_id = gt.fin_category_id';
1159:
1160: -- IF fii_ea_util_pkg.g_as_of_date = trunc(sysdate) THEN
1161: /* commented out temporarily for testing snapshot table queries */
1162: IF fii_ea_util_pkg.g_if_trend_sum_mv = 'Y' THEN
1163: l_sqlstmt1 := l_trend_sum_mv_sql;
1164:

Line 1162: IF fii_ea_util_pkg.g_if_trend_sum_mv = 'Y' THEN

1158: and f.fin_category_id = gt.fin_category_id';
1159:
1160: -- IF fii_ea_util_pkg.g_as_of_date = trunc(sysdate) THEN
1161: /* commented out temporarily for testing snapshot table queries */
1162: IF fii_ea_util_pkg.g_if_trend_sum_mv = 'Y' THEN
1163: l_sqlstmt1 := l_trend_sum_mv_sql;
1164:
1165: ELSIF fii_ea_util_pkg.g_snapshot = 'Y' THEN
1166:

Line 1165: ELSIF fii_ea_util_pkg.g_snapshot = 'Y' THEN

1161: /* commented out temporarily for testing snapshot table queries */
1162: IF fii_ea_util_pkg.g_if_trend_sum_mv = 'Y' THEN
1163: l_sqlstmt1 := l_trend_sum_mv_sql;
1164:
1165: ELSIF fii_ea_util_pkg.g_snapshot = 'Y' THEN
1166:
1167:
1168: IF p_aggrt_gt_is_empty = 'N' then -- aggrt GT table is populated
1169:

Line 1213: ELSIF month-end date is > fii_ea_util_pkg.g_as_of_date THEN pass sysdate to called report

1209: Logic for MTD drill region item, FII_EA_XTD_DRILL:
1210:
1211: IF MTD amount is 0 THEN NO DRILL
1212: ELSIF MTD amount is NULL THEN NO DRILL
1213: ELSIF month-end date is > fii_ea_util_pkg.g_as_of_date THEN pass sysdate to called report
1214: ELSE pass month-end date to called report
1215: END IF;
1216: */
1217: