APPS.FII_GL_TOP_SPENDERS_PKG2 dependencies on FII_GL_UTIL_PKG

Line 16: fii_gl_util_pkg.reset_globals;

12: l_stmt VARCHAR2(200) ;
13:
14: BEGIN
15:
16: fii_gl_util_pkg.reset_globals;
17: fii_gl_util_pkg.get_parameters(p_page_parameter_tbl);
18:
19: l_global_curr_view := fii_gl_util_pkg.g_global_curr_view;
20:

Line 17: fii_gl_util_pkg.get_parameters(p_page_parameter_tbl);

13:
14: BEGIN
15:
16: fii_gl_util_pkg.reset_globals;
17: fii_gl_util_pkg.get_parameters(p_page_parameter_tbl);
18:
19: l_global_curr_view := fii_gl_util_pkg.g_global_curr_view;
20:
21: /* Hardcoded 'sys' schema name to use sys.all_tables (instead of all_tables) in order to make the code gscc compliant */

Line 19: l_global_curr_view := fii_gl_util_pkg.g_global_curr_view;

15:
16: fii_gl_util_pkg.reset_globals;
17: fii_gl_util_pkg.get_parameters(p_page_parameter_tbl);
18:
19: l_global_curr_view := fii_gl_util_pkg.g_global_curr_view;
20:
21: /* Hardcoded 'sys' schema name to use sys.all_tables (instead of all_tables) in order to make the code gscc compliant */
22:
23: BEGIN

Line 40: IF fii_gl_util_pkg.g_mgr_id = -99999 THEN

36: l_stmt := 'SELECT count(*) FROM per_empdir_people WHERE orig_system = ''PER'' AND rownum <= 1';
37: EXECUTE IMMEDIATE(l_stmt) INTO l_exists2;
38: END IF;
39:
40: IF fii_gl_util_pkg.g_mgr_id = -99999 THEN
41:
42: sqlstmt := '
43: SELECT NULL FII_MEASURE1,
44: NULL FII_MEASURE2,

Line 94: fii_gl_util_pkg.bind_variable(sqlstmt, p_page_parameter_tbl, top_spenders_sql, top_spenders_output);

90: ORDER BY p.FII_MEASURE3 desc';
91:
92: END IF;
93:
94: fii_gl_util_pkg.bind_variable(sqlstmt, p_page_parameter_tbl, top_spenders_sql, top_spenders_output);
95:
96: END get_top_spenders;
97:
98:

Line 111: fii_gl_util_pkg.reset_globals;

107:
108:
109: BEGIN
110:
111: fii_gl_util_pkg.reset_globals;
112: fii_gl_util_pkg.get_parameters(p_page_parameter_tbl);
113: fii_gl_util_pkg.get_bitmasks;
114: l_currency := fii_gl_util_pkg.g_currency;
115:

Line 112: fii_gl_util_pkg.get_parameters(p_page_parameter_tbl);

108:
109: BEGIN
110:
111: fii_gl_util_pkg.reset_globals;
112: fii_gl_util_pkg.get_parameters(p_page_parameter_tbl);
113: fii_gl_util_pkg.get_bitmasks;
114: l_currency := fii_gl_util_pkg.g_currency;
115:
116:

Line 113: fii_gl_util_pkg.get_bitmasks;

109: BEGIN
110:
111: fii_gl_util_pkg.reset_globals;
112: fii_gl_util_pkg.get_parameters(p_page_parameter_tbl);
113: fii_gl_util_pkg.get_bitmasks;
114: l_currency := fii_gl_util_pkg.g_currency;
115:
116:
117: IF (p_page_parameter_tbl.count > 0) THEN

Line 114: l_currency := fii_gl_util_pkg.g_currency;

110:
111: fii_gl_util_pkg.reset_globals;
112: fii_gl_util_pkg.get_parameters(p_page_parameter_tbl);
113: fii_gl_util_pkg.get_bitmasks;
114: l_currency := fii_gl_util_pkg.g_currency;
115:
116:
117: IF (p_page_parameter_tbl.count > 0) THEN
118: FOR i IN p_page_parameter_tbl.first..p_page_parameter_tbl.last LOOP

Line 120: fii_gl_util_pkg.g_prev_mgr_id := p_page_parameter_tbl(i).parameter_value;

116:
117: IF (p_page_parameter_tbl.count > 0) THEN
118: FOR i IN p_page_parameter_tbl.first..p_page_parameter_tbl.last LOOP
119: IF p_page_parameter_tbl(i).parameter_name = 'FII_MEASURE8' THEN
120: fii_gl_util_pkg.g_prev_mgr_id := p_page_parameter_tbl(i).parameter_value;
121: END IF;
122: IF p_page_parameter_tbl(i).parameter_name = 'FII_MEASURE9' THEN
123: fii_gl_util_pkg.g_emp_id := p_page_parameter_tbl(i).parameter_value;
124: END IF;

Line 123: fii_gl_util_pkg.g_emp_id := p_page_parameter_tbl(i).parameter_value;

119: IF p_page_parameter_tbl(i).parameter_name = 'FII_MEASURE8' THEN
120: fii_gl_util_pkg.g_prev_mgr_id := p_page_parameter_tbl(i).parameter_value;
121: END IF;
122: IF p_page_parameter_tbl(i).parameter_name = 'FII_MEASURE9' THEN
123: fii_gl_util_pkg.g_emp_id := p_page_parameter_tbl(i).parameter_value;
124: END IF;
125: END LOOP;
126: END IF;
127:

Line 175: fii_gl_util_pkg.bind_variable(sqlstmt, p_page_parameter_tbl, top_spenders_drilldown_sql, top_spenders_drilldown_output);

171: AND tl.language = userenv(''LANG'')
172: GROUP BY x.invoice_num, headers.report_header_id, tl.name, headers.description, x.inv_currency_code, x.account_date, headers.total
173: &ORDER_BY_CLAUSE';
174:
175: fii_gl_util_pkg.bind_variable(sqlstmt, p_page_parameter_tbl, top_spenders_drilldown_sql, top_spenders_drilldown_output);
176:
177: END get_top_spenders_drilldown;
178:
179: END fii_gl_top_spenders_pkg2;