APPS.FII_GL_REV_PROD dependencies on FII_GL_UTIL_PKG

Line 12: fii_gl_util_pkg.reset_globals;

8: sqlstmt VARCHAR2(10000);
9: l_prod_join VARCHAR2(200) := NULL;
10:
11: BEGIN
12: fii_gl_util_pkg.reset_globals;
13: fii_gl_util_pkg.get_parameters(p_page_parameter_tbl);
14: fii_gl_util_pkg.get_bitmasks;
15: fii_gl_util_pkg.g_fin_type := 'R';
16: fii_gl_util_pkg.get_mgr_pmv_sql;

Line 13: fii_gl_util_pkg.get_parameters(p_page_parameter_tbl);

9: l_prod_join VARCHAR2(200) := NULL;
10:
11: BEGIN
12: fii_gl_util_pkg.reset_globals;
13: fii_gl_util_pkg.get_parameters(p_page_parameter_tbl);
14: fii_gl_util_pkg.get_bitmasks;
15: fii_gl_util_pkg.g_fin_type := 'R';
16: fii_gl_util_pkg.get_mgr_pmv_sql;
17:

Line 14: fii_gl_util_pkg.get_bitmasks;

10:
11: BEGIN
12: fii_gl_util_pkg.reset_globals;
13: fii_gl_util_pkg.get_parameters(p_page_parameter_tbl);
14: fii_gl_util_pkg.get_bitmasks;
15: fii_gl_util_pkg.g_fin_type := 'R';
16: fii_gl_util_pkg.get_mgr_pmv_sql;
17:
18: IF (fii_gl_util_pkg.g_prod_id is not NULL) and (upper(fii_gl_util_pkg.g_prod_id) <> upper('All')) THEN

Line 15: fii_gl_util_pkg.g_fin_type := 'R';

11: BEGIN
12: fii_gl_util_pkg.reset_globals;
13: fii_gl_util_pkg.get_parameters(p_page_parameter_tbl);
14: fii_gl_util_pkg.get_bitmasks;
15: fii_gl_util_pkg.g_fin_type := 'R';
16: fii_gl_util_pkg.get_mgr_pmv_sql;
17:
18: IF (fii_gl_util_pkg.g_prod_id is not NULL) and (upper(fii_gl_util_pkg.g_prod_id) <> upper('All')) THEN
19: l_prod_join :='

Line 16: fii_gl_util_pkg.get_mgr_pmv_sql;

12: fii_gl_util_pkg.reset_globals;
13: fii_gl_util_pkg.get_parameters(p_page_parameter_tbl);
14: fii_gl_util_pkg.get_bitmasks;
15: fii_gl_util_pkg.g_fin_type := 'R';
16: fii_gl_util_pkg.get_mgr_pmv_sql;
17:
18: IF (fii_gl_util_pkg.g_prod_id is not NULL) and (upper(fii_gl_util_pkg.g_prod_id) <> upper('All')) THEN
19: l_prod_join :='
20: and prod.parent_id = &ITEM+ENI_ITEM_VBH_CAT';

Line 18: IF (fii_gl_util_pkg.g_prod_id is not NULL) and (upper(fii_gl_util_pkg.g_prod_id) <> upper('All')) THEN

14: fii_gl_util_pkg.get_bitmasks;
15: fii_gl_util_pkg.g_fin_type := 'R';
16: fii_gl_util_pkg.get_mgr_pmv_sql;
17:
18: IF (fii_gl_util_pkg.g_prod_id is not NULL) and (upper(fii_gl_util_pkg.g_prod_id) <> upper('All')) THEN
19: l_prod_join :='
20: and prod.parent_id = &ITEM+ENI_ITEM_VBH_CAT';
21: ELSE
22: l_prod_join :='

Line 39: IF fii_gl_util_pkg.g_mgr_id = -99999 THEN /* Done for bug 3875336 */

35: * FII_MEASURE11 = Grand Total of Forecast amounts
36: * FII_MEASURE12 = Budget amounts
37: * FII_ATTRIBUTE2 = Prior Total amounts
38: *****************************************************************************/
39: IF fii_gl_util_pkg.g_mgr_id = -99999 THEN /* Done for bug 3875336 */
40:
41: sqlstmt := 'SELECT NULL FII_MEASURE1,
42: NULL FII_CAL2,
43: NULL FII_MEASURE2,

Line 85: fii_gl_prd_v'||fii_gl_util_pkg.g_global_curr_view||' f,

81: to_number(NULL) PY_ACTUAL,
82: to_number(NULL) PY_SPER_END
83: from FII_TIME_RPT_STRUCT cal,
84: eni_item_vbh_nodes_v prod,
85: fii_gl_prd_v'||fii_gl_util_pkg.g_global_curr_view||' f,
86: fii_fin_item_hierarchies cat,
87: fii_cc_mgr_hierarchies h
88: where h.mgr_id = &HRI_PERSON+HRI_PER_USRDR_H
89: and h.emp_id = f.manager_id

Line 114: fii_gl_prd_v'||fii_gl_util_pkg.g_global_curr_view||' f,

110: then f.actual_g
111: else to_number(NULL) end) PY_SPER_END
112: from FII_TIME_RPT_STRUCT cal,
113: eni_item_vbh_nodes_v prod,
114: fii_gl_prd_v'||fii_gl_util_pkg.g_global_curr_view||' f,
115: fii_fin_item_hierarchies cat,
116: fii_cc_mgr_hierarchies h
117: where h.mgr_id = &HRI_PERSON+HRI_PER_USRDR_H
118: and h.emp_id = f.manager_id

Line 132: fii_gl_util_pkg.bind_variable(sqlstmt, p_page_parameter_tbl, rev_by_prod_sql, rev_by_prod_output);

128: ';
129:
130: END IF;
131:
132: fii_gl_util_pkg.bind_variable(sqlstmt, p_page_parameter_tbl, rev_by_prod_sql, rev_by_prod_output);
133:
134: END get_rev_by_prod;
135:
136: END fii_gl_rev_prod;