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

Line 27: fii_ea_util_pkg.bind_variable(p_sqlstmt => l_sqlstmt,

23: l_sqlstmt := get_bud_enc_trend_dtl (p_page_parameter_tbl => p_page_parameter_tbl,
24: p_fin_cat => l_fin_cat,
25: p_trend_type => l_trend_type);
26:
27: fii_ea_util_pkg.bind_variable(p_sqlstmt => l_sqlstmt,
28: p_page_parameter_tbl => p_page_parameter_tbl,
29: p_sql_output => p_exp_trend_dtl_sql,
30: p_bind_output_table => p_exp_trend_dtl_output);
31:

Line 57: fii_ea_util_pkg.bind_variable(p_sqlstmt => l_sqlstmt,

53: l_sqlstmt := get_bud_enc_trend_dtl (p_page_parameter_tbl => p_page_parameter_tbl,
54: p_fin_cat => l_fin_cat,
55: p_trend_type => l_trend_type);
56:
57: fii_ea_util_pkg.bind_variable(p_sqlstmt => l_sqlstmt,
58: p_page_parameter_tbl => p_page_parameter_tbl,
59: p_sql_output => p_rev_trend_dtl_sql,
60: p_bind_output_table => p_rev_trend_dtl_output);
61:

Line 130: -- initialization. Calling fii_ea_util_pkg APIs necessary for constructing

126: l_order VARCHAR2(500);
127: l_order2 VARCHAR2(2500);
128:
129: BEGIN
130: -- initialization. Calling fii_ea_util_pkg APIs necessary for constructing
131: -- the PMV sql.
132:
133: fii_ea_util_pkg.reset_globals;
134: fii_ea_util_pkg.get_parameters(p_page_parameter_tbl);

Line 133: fii_ea_util_pkg.reset_globals;

129: BEGIN
130: -- initialization. Calling fii_ea_util_pkg APIs necessary for constructing
131: -- the PMV sql.
132:
133: fii_ea_util_pkg.reset_globals;
134: fii_ea_util_pkg.get_parameters(p_page_parameter_tbl);
135: fii_ea_util_pkg.get_rolling_period;
136: l_ledger_where := fii_ea_util_pkg.get_ledger_for_detail;
137: l_as_of_date := fii_ea_util_pkg.g_as_of_date;

Line 134: fii_ea_util_pkg.get_parameters(p_page_parameter_tbl);

130: -- initialization. Calling fii_ea_util_pkg APIs necessary for constructing
131: -- the PMV sql.
132:
133: fii_ea_util_pkg.reset_globals;
134: fii_ea_util_pkg.get_parameters(p_page_parameter_tbl);
135: fii_ea_util_pkg.get_rolling_period;
136: l_ledger_where := fii_ea_util_pkg.get_ledger_for_detail;
137: l_as_of_date := fii_ea_util_pkg.g_as_of_date;
138: l_page_period_type := fii_ea_util_pkg.g_page_period_type;

Line 135: fii_ea_util_pkg.get_rolling_period;

131: -- the PMV sql.
132:
133: fii_ea_util_pkg.reset_globals;
134: fii_ea_util_pkg.get_parameters(p_page_parameter_tbl);
135: fii_ea_util_pkg.get_rolling_period;
136: l_ledger_where := fii_ea_util_pkg.get_ledger_for_detail;
137: l_as_of_date := fii_ea_util_pkg.g_as_of_date;
138: l_page_period_type := fii_ea_util_pkg.g_page_period_type;
139:

Line 136: l_ledger_where := fii_ea_util_pkg.get_ledger_for_detail;

132:
133: fii_ea_util_pkg.reset_globals;
134: fii_ea_util_pkg.get_parameters(p_page_parameter_tbl);
135: fii_ea_util_pkg.get_rolling_period;
136: l_ledger_where := fii_ea_util_pkg.get_ledger_for_detail;
137: l_as_of_date := fii_ea_util_pkg.g_as_of_date;
138: l_page_period_type := fii_ea_util_pkg.g_page_period_type;
139:
140: l_company_id := fii_ea_util_pkg.g_company_id;

Line 137: l_as_of_date := fii_ea_util_pkg.g_as_of_date;

133: fii_ea_util_pkg.reset_globals;
134: fii_ea_util_pkg.get_parameters(p_page_parameter_tbl);
135: fii_ea_util_pkg.get_rolling_period;
136: l_ledger_where := fii_ea_util_pkg.get_ledger_for_detail;
137: l_as_of_date := fii_ea_util_pkg.g_as_of_date;
138: l_page_period_type := fii_ea_util_pkg.g_page_period_type;
139:
140: l_company_id := fii_ea_util_pkg.g_company_id;
141: l_cost_center_id := fii_ea_util_pkg.g_cost_center_id;

Line 138: l_page_period_type := fii_ea_util_pkg.g_page_period_type;

134: fii_ea_util_pkg.get_parameters(p_page_parameter_tbl);
135: fii_ea_util_pkg.get_rolling_period;
136: l_ledger_where := fii_ea_util_pkg.get_ledger_for_detail;
137: l_as_of_date := fii_ea_util_pkg.g_as_of_date;
138: l_page_period_type := fii_ea_util_pkg.g_page_period_type;
139:
140: l_company_id := fii_ea_util_pkg.g_company_id;
141: l_cost_center_id := fii_ea_util_pkg.g_cost_center_id;
142: l_curr_view := fii_ea_util_pkg.g_curr_view;

Line 140: l_company_id := fii_ea_util_pkg.g_company_id;

136: l_ledger_where := fii_ea_util_pkg.get_ledger_for_detail;
137: l_as_of_date := fii_ea_util_pkg.g_as_of_date;
138: l_page_period_type := fii_ea_util_pkg.g_page_period_type;
139:
140: l_company_id := fii_ea_util_pkg.g_company_id;
141: l_cost_center_id := fii_ea_util_pkg.g_cost_center_id;
142: l_curr_view := fii_ea_util_pkg.g_curr_view;
143: l_fin_category_id := fii_ea_util_pkg.g_fin_category_id;
144: l_fud1_where := fii_ea_util_pkg.get_fud1_for_detail;

Line 141: l_cost_center_id := fii_ea_util_pkg.g_cost_center_id;

137: l_as_of_date := fii_ea_util_pkg.g_as_of_date;
138: l_page_period_type := fii_ea_util_pkg.g_page_period_type;
139:
140: l_company_id := fii_ea_util_pkg.g_company_id;
141: l_cost_center_id := fii_ea_util_pkg.g_cost_center_id;
142: l_curr_view := fii_ea_util_pkg.g_curr_view;
143: l_fin_category_id := fii_ea_util_pkg.g_fin_category_id;
144: l_fud1_where := fii_ea_util_pkg.get_fud1_for_detail;
145: l_fud2_where := fii_ea_util_pkg.get_fud2_for_detail;

Line 142: l_curr_view := fii_ea_util_pkg.g_curr_view;

138: l_page_period_type := fii_ea_util_pkg.g_page_period_type;
139:
140: l_company_id := fii_ea_util_pkg.g_company_id;
141: l_cost_center_id := fii_ea_util_pkg.g_cost_center_id;
142: l_curr_view := fii_ea_util_pkg.g_curr_view;
143: l_fin_category_id := fii_ea_util_pkg.g_fin_category_id;
144: l_fud1_where := fii_ea_util_pkg.get_fud1_for_detail;
145: l_fud2_where := fii_ea_util_pkg.get_fud2_for_detail;
146:

Line 143: l_fin_category_id := fii_ea_util_pkg.g_fin_category_id;

139:
140: l_company_id := fii_ea_util_pkg.g_company_id;
141: l_cost_center_id := fii_ea_util_pkg.g_cost_center_id;
142: l_curr_view := fii_ea_util_pkg.g_curr_view;
143: l_fin_category_id := fii_ea_util_pkg.g_fin_category_id;
144: l_fud1_where := fii_ea_util_pkg.get_fud1_for_detail;
145: l_fud2_where := fii_ea_util_pkg.get_fud2_for_detail;
146:
147: l_previous_three_end_date := fii_ea_util_pkg.g_previous_three_end_date;

Line 144: l_fud1_where := fii_ea_util_pkg.get_fud1_for_detail;

140: l_company_id := fii_ea_util_pkg.g_company_id;
141: l_cost_center_id := fii_ea_util_pkg.g_cost_center_id;
142: l_curr_view := fii_ea_util_pkg.g_curr_view;
143: l_fin_category_id := fii_ea_util_pkg.g_fin_category_id;
144: l_fud1_where := fii_ea_util_pkg.get_fud1_for_detail;
145: l_fud2_where := fii_ea_util_pkg.get_fud2_for_detail;
146:
147: l_previous_three_end_date := fii_ea_util_pkg.g_previous_three_end_date;
148: l_previous_two_end_date := fii_ea_util_pkg.g_previous_two_end_date;

Line 145: l_fud2_where := fii_ea_util_pkg.get_fud2_for_detail;

141: l_cost_center_id := fii_ea_util_pkg.g_cost_center_id;
142: l_curr_view := fii_ea_util_pkg.g_curr_view;
143: l_fin_category_id := fii_ea_util_pkg.g_fin_category_id;
144: l_fud1_where := fii_ea_util_pkg.get_fud1_for_detail;
145: l_fud2_where := fii_ea_util_pkg.get_fud2_for_detail;
146:
147: l_previous_three_end_date := fii_ea_util_pkg.g_previous_three_end_date;
148: l_previous_two_end_date := fii_ea_util_pkg.g_previous_two_end_date;
149: l_previous_one_end_date := fii_ea_util_pkg.g_previous_one_end_date;

Line 147: l_previous_three_end_date := fii_ea_util_pkg.g_previous_three_end_date;

143: l_fin_category_id := fii_ea_util_pkg.g_fin_category_id;
144: l_fud1_where := fii_ea_util_pkg.get_fud1_for_detail;
145: l_fud2_where := fii_ea_util_pkg.get_fud2_for_detail;
146:
147: l_previous_three_end_date := fii_ea_util_pkg.g_previous_three_end_date;
148: l_previous_two_end_date := fii_ea_util_pkg.g_previous_two_end_date;
149: l_previous_one_end_date := fii_ea_util_pkg.g_previous_one_end_date;
150:
151:

Line 148: l_previous_two_end_date := fii_ea_util_pkg.g_previous_two_end_date;

144: l_fud1_where := fii_ea_util_pkg.get_fud1_for_detail;
145: l_fud2_where := fii_ea_util_pkg.get_fud2_for_detail;
146:
147: l_previous_three_end_date := fii_ea_util_pkg.g_previous_three_end_date;
148: l_previous_two_end_date := fii_ea_util_pkg.g_previous_two_end_date;
149: l_previous_one_end_date := fii_ea_util_pkg.g_previous_one_end_date;
150:
151:
152: -- order by clause

Line 149: l_previous_one_end_date := fii_ea_util_pkg.g_previous_one_end_date;

145: l_fud2_where := fii_ea_util_pkg.get_fud2_for_detail;
146:
147: l_previous_three_end_date := fii_ea_util_pkg.g_previous_three_end_date;
148: l_previous_two_end_date := fii_ea_util_pkg.g_previous_two_end_date;
149: l_previous_one_end_date := fii_ea_util_pkg.g_previous_one_end_date;
150:
151:
152: -- order by clause
153: IF (p_page_parameter_tbl.count > 0) THEN

Line 253: and ccg.report_region_code = '''||fii_ea_util_pkg.g_region_code||'''

249: l_company_id_where := ' and co_hier.parent_company_id = :COMPANY_ID
250: and co_hier.child_company_id = ccom_map.parent_company_dim_id
251: and ccom_map.child_company_id = f.company_id
252: and ccg.user_id = fnd_global.user_id
253: and ccg.report_region_code = '''||fii_ea_util_pkg.g_region_code||'''
254: and cc_hier.parent_cc_id = ccg.cost_center_id
255: and cc_hier.child_cc_id = ccom_map.parent_cost_center_dim_id
256: and ccom_map.child_cost_center_id = f.cost_center_id';
257: ELSIF ((l_company_id = 'All') AND (l_cost_center_id <> 'All')) THEN

Line 263: and fcg.report_region_code = '''||fii_ea_util_pkg.g_region_code||'''

259: , fii_company_hierarchies co_hier
260: , fii_cost_ctr_hierarchies cc_hier
261: , fii_com_cc_dim_maps ccom_map ';
262: l_company_id_where := ' and fcg.user_id = fnd_global.user_id
263: and fcg.report_region_code = '''||fii_ea_util_pkg.g_region_code||'''
264: and co_hier.parent_company_id = fcg.company_id
265: and co_hier.child_company_id = ccom_map.parent_company_dim_id
266: and ccom_map.child_company_id = f.company_id
267: and cc_hier.parent_cc_id = :COST_CENTER_ID

Line 287: and fcg.report_region_code = '''||fii_ea_util_pkg.g_region_code||'''

283: , fii_company_hierarchies co_hier
284: , fii_cost_ctr_hierarchies cc_hier
285: , fii_com_cc_dim_maps ccom_map ';
286: l_company_id_where := ' and fcg.user_id = fnd_global.user_id
287: and fcg.report_region_code = '''||fii_ea_util_pkg.g_region_code||'''
288: and co_hier.parent_company_id = fcg.company_id
289: and fcg.user_id = ccg.user_id
290: and fcg.report_region_code = ccg.report_region_code
291: and co_hier.child_company_id = ccom_map.parent_company_dim_id

Line 601: fii_ea_util_pkg.g_year_id := l_year_id;

597: p_hist_amt3 := null;
598:
599: END IF; -- period_type - period
600:
601: fii_ea_util_pkg.g_year_id := l_year_id;
602: fii_ea_util_pkg.g_prior_year_id := l_prior_year_id;
603:
604: IF p_trend_type = 'B' THEN
605:

Line 602: fii_ea_util_pkg.g_prior_year_id := l_prior_year_id;

598:
599: END IF; -- period_type - period
600:
601: fii_ea_util_pkg.g_year_id := l_year_id;
602: fii_ea_util_pkg.g_prior_year_id := l_prior_year_id;
603:
604: IF p_trend_type = 'B' THEN
605:
606: l_amt_columns := ' DECODE(f.amount_type_code, ''B'',