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

Line 11: fii_ea_util_pkg.reset_globals;

7:
8: sqlstmt VARCHAR2(30000);
9:
10: BEGIN
11: fii_ea_util_pkg.reset_globals;
12: fii_ea_util_pkg.g_fin_cat_type := 'OE';
13:
14: sqlstmt := fii_ea_page_pkg.get_revexp(p_page_parameter_tbl);
15:

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

8: sqlstmt VARCHAR2(30000);
9:
10: BEGIN
11: fii_ea_util_pkg.reset_globals;
12: fii_ea_util_pkg.g_fin_cat_type := 'OE';
13:
14: sqlstmt := fii_ea_page_pkg.get_revexp(p_page_parameter_tbl);
15:
16: fii_ea_util_pkg.bind_variable(sqlstmt, p_page_parameter_tbl, exp_ana_page_sql, exp_ana_page_output);

Line 16: fii_ea_util_pkg.bind_variable(sqlstmt, p_page_parameter_tbl, exp_ana_page_sql, exp_ana_page_output);

12: fii_ea_util_pkg.g_fin_cat_type := 'OE';
13:
14: sqlstmt := fii_ea_page_pkg.get_revexp(p_page_parameter_tbl);
15:
16: fii_ea_util_pkg.bind_variable(sqlstmt, p_page_parameter_tbl, exp_ana_page_sql, exp_ana_page_output);
17:
18: END get_exp;
19:
20:

Line 44: fii_ea_util_pkg.get_parameters(p_page_parameter_tbl);

40: l_prior_g VARCHAR2(10000);
41:
42: BEGIN
43:
44: fii_ea_util_pkg.get_parameters(p_page_parameter_tbl);
45:
46: fii_ea_util_pkg.get_viewby_id(p_aggrt_viewby_id, p_snap_aggrt_viewby_id, p_nonaggrt_viewby_id);
47:
48: fii_ea_util_pkg.populate_security_gt_tables(p_aggrt_gt_is_empty, p_non_aggrt_gt_is_empty);

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

42: BEGIN
43:
44: fii_ea_util_pkg.get_parameters(p_page_parameter_tbl);
45:
46: fii_ea_util_pkg.get_viewby_id(p_aggrt_viewby_id, p_snap_aggrt_viewby_id, p_nonaggrt_viewby_id);
47:
48: fii_ea_util_pkg.populate_security_gt_tables(p_aggrt_gt_is_empty, p_non_aggrt_gt_is_empty);
49:
50: CASE fii_ea_util_pkg.g_time_comp

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

44: fii_ea_util_pkg.get_parameters(p_page_parameter_tbl);
45:
46: fii_ea_util_pkg.get_viewby_id(p_aggrt_viewby_id, p_snap_aggrt_viewby_id, p_nonaggrt_viewby_id);
47:
48: fii_ea_util_pkg.populate_security_gt_tables(p_aggrt_gt_is_empty, p_non_aggrt_gt_is_empty);
49:
50: CASE fii_ea_util_pkg.g_time_comp
51:
52: WHEN 'BUDGET' THEN

Line 50: CASE fii_ea_util_pkg.g_time_comp

46: fii_ea_util_pkg.get_viewby_id(p_aggrt_viewby_id, p_snap_aggrt_viewby_id, p_nonaggrt_viewby_id);
47:
48: fii_ea_util_pkg.populate_security_gt_tables(p_aggrt_gt_is_empty, p_non_aggrt_gt_is_empty);
49:
50: CASE fii_ea_util_pkg.g_time_comp
51:
52: WHEN 'BUDGET' THEN
53: l_prior_g := 'SUM(DECODE(inner_inline_view.report_date, :ASOF_DATE,
54: (CASE WHEN bitand(inner_inline_view.record_type_id,:BUDGET_BITAND) = :BUDGET_BITAND

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

86: SUM(SUM(FII_EA_PRIOR_XTD_EXP)) over()) /
87: ABS(NULLIF(SUM(SUM(FII_EA_PRIOR_XTD_EXP)) over(),0)) * 100 FII_EA_GT_CHANGE,';
88: END CASE;
89:
90: IF fii_ea_util_pkg.g_view_by = 'FINANCIAL ITEM+GL_FII_FIN_ITEM' THEN
91:
92: fii_ea_util_pkg.check_if_leaf(fii_ea_util_pkg.g_category_id);
93: l_if_leaf_flag := fii_ea_util_pkg.g_fin_cat_is_leaf;
94:

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

88: END CASE;
89:
90: IF fii_ea_util_pkg.g_view_by = 'FINANCIAL ITEM+GL_FII_FIN_ITEM' THEN
91:
92: fii_ea_util_pkg.check_if_leaf(fii_ea_util_pkg.g_category_id);
93: l_if_leaf_flag := fii_ea_util_pkg.g_fin_cat_is_leaf;
94:
95: -- This issue was found during testing of fix for bug 4127077. Since these variables are used to
96: -- check for loading of budgets against summary nodes, we don't need to append

Line 93: l_if_leaf_flag := fii_ea_util_pkg.g_fin_cat_is_leaf;

89:
90: IF fii_ea_util_pkg.g_view_by = 'FINANCIAL ITEM+GL_FII_FIN_ITEM' THEN
91:
92: fii_ea_util_pkg.check_if_leaf(fii_ea_util_pkg.g_category_id);
93: l_if_leaf_flag := fii_ea_util_pkg.g_fin_cat_is_leaf;
94:
95: -- This issue was found during testing of fix for bug 4127077. Since these variables are used to
96: -- check for loading of budgets against summary nodes, we don't need to append
97: -- l_budget_decode to the main sql, when we choose a leaf category node.

Line 116: SELECT DECODE(fii_ea_util_pkg.g_region_code,'FII_EA_PAGE','FII_EA_EXP_SUM','FII_EA_EXP_BY_COMP_PORT','FII_EA_EXP_SUM','FII_PSI_EXP_SUM')

112:
113: -- Added check for FII_EA_EXP_BY_COMP_PORT AK region
114:
115:
116: SELECT DECODE(fii_ea_util_pkg.g_region_code,'FII_EA_PAGE','FII_EA_EXP_SUM','FII_EA_EXP_BY_COMP_PORT','FII_EA_EXP_SUM','FII_PSI_EXP_SUM')
117: INTO l_drill_source
118: FROM DUAL;
119:
120: sqlstmt :='

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

186: SUM(DECODE(inner_inline_view.report_date, :ASOF_DATE,
187: (CASE WHEN bitand(inner_inline_view.record_type_id,:FORECAST_BITAND) = :FORECAST_BITAND
188: THEN f.forecast_g ELSE NULL END) ) ) FII_EA_FORECAST
189:
190: FROM fii_gl_trend_sum_mv'||fii_ea_util_pkg.g_curr_view||' f,
191: ( SELECT /*+ NO_MERGE cardinality(gt 1) */ *
192: FROM fii_time_structures cal,
193: fii_pmv_aggrt_gt gt
194: WHERE report_date in (:ASOF_DATE, :PREVIOUS_ASOF_DATE, :PRIOR_PERIOD_END)