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

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

23:
24: l_sqlstmt := get_rev_exp_trend_dtl (p_page_parameter_tbl => p_page_parameter_tbl,
25: p_fin_cat => l_fin_cat);
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 58: fii_ea_util_pkg.bind_variable(p_sqlstmt => l_sqlstmt,

54:
55: l_sqlstmt := get_rev_exp_trend_dtl (p_page_parameter_tbl => p_page_parameter_tbl,
56: p_fin_cat => l_fin_cat);
57:
58: fii_ea_util_pkg.bind_variable(p_sqlstmt => l_sqlstmt,
59: p_page_parameter_tbl => p_page_parameter_tbl,
60: p_sql_output => p_exp_trend_dtl_sql,
61: p_bind_output_table => p_exp_trend_dtl_output);
62:

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

83:
84: l_sqlstmt := get_rev_exp_trend_dtl (p_page_parameter_tbl => p_page_parameter_tbl,
85: p_fin_cat => l_fin_cat);
86:
87: fii_ea_util_pkg.bind_variable(p_sqlstmt => l_sqlstmt,
88: p_page_parameter_tbl => p_page_parameter_tbl,
89: p_sql_output => p_rev_trend_dtl_sql,
90: p_bind_output_table => p_rev_trend_dtl_output);
91:

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

151: l_order VARCHAR2(500);
152: l_order2 VARCHAR2(2500);
153:
154: BEGIN
155: -- initialization. Calling fii_ea_util_pkg APIs necessary for constructing
156: -- the PMV sql.
157:
158: fii_ea_util_pkg.reset_globals;
159: fii_ea_util_pkg.get_parameters(p_page_parameter_tbl);

Line 158: fii_ea_util_pkg.reset_globals;

154: BEGIN
155: -- initialization. Calling fii_ea_util_pkg APIs necessary for constructing
156: -- the PMV sql.
157:
158: fii_ea_util_pkg.reset_globals;
159: fii_ea_util_pkg.get_parameters(p_page_parameter_tbl);
160: fii_ea_util_pkg.get_rolling_period;
161: l_ledger_where := fii_ea_util_pkg.get_ledger_for_detail;
162: l_as_of_date := fii_ea_util_pkg.g_as_of_date;

Line 159: fii_ea_util_pkg.get_parameters(p_page_parameter_tbl);

155: -- initialization. Calling fii_ea_util_pkg APIs necessary for constructing
156: -- the PMV sql.
157:
158: fii_ea_util_pkg.reset_globals;
159: fii_ea_util_pkg.get_parameters(p_page_parameter_tbl);
160: fii_ea_util_pkg.get_rolling_period;
161: l_ledger_where := fii_ea_util_pkg.get_ledger_for_detail;
162: l_as_of_date := fii_ea_util_pkg.g_as_of_date;
163: l_page_period_type := fii_ea_util_pkg.g_page_period_type;

Line 160: fii_ea_util_pkg.get_rolling_period;

156: -- the PMV sql.
157:
158: fii_ea_util_pkg.reset_globals;
159: fii_ea_util_pkg.get_parameters(p_page_parameter_tbl);
160: fii_ea_util_pkg.get_rolling_period;
161: l_ledger_where := fii_ea_util_pkg.get_ledger_for_detail;
162: l_as_of_date := fii_ea_util_pkg.g_as_of_date;
163: l_page_period_type := fii_ea_util_pkg.g_page_period_type;
164: l_company_id := fii_ea_util_pkg.g_company_id;

Line 161: l_ledger_where := fii_ea_util_pkg.get_ledger_for_detail;

157:
158: fii_ea_util_pkg.reset_globals;
159: fii_ea_util_pkg.get_parameters(p_page_parameter_tbl);
160: fii_ea_util_pkg.get_rolling_period;
161: l_ledger_where := fii_ea_util_pkg.get_ledger_for_detail;
162: l_as_of_date := fii_ea_util_pkg.g_as_of_date;
163: l_page_period_type := fii_ea_util_pkg.g_page_period_type;
164: l_company_id := fii_ea_util_pkg.g_company_id;
165: l_cost_center_id := fii_ea_util_pkg.g_cost_center_id;

Line 162: l_as_of_date := fii_ea_util_pkg.g_as_of_date;

158: fii_ea_util_pkg.reset_globals;
159: fii_ea_util_pkg.get_parameters(p_page_parameter_tbl);
160: fii_ea_util_pkg.get_rolling_period;
161: l_ledger_where := fii_ea_util_pkg.get_ledger_for_detail;
162: l_as_of_date := fii_ea_util_pkg.g_as_of_date;
163: l_page_period_type := fii_ea_util_pkg.g_page_period_type;
164: l_company_id := fii_ea_util_pkg.g_company_id;
165: l_cost_center_id := fii_ea_util_pkg.g_cost_center_id;
166: l_curr_view := fii_ea_util_pkg.g_curr_view;

Line 163: l_page_period_type := fii_ea_util_pkg.g_page_period_type;

159: fii_ea_util_pkg.get_parameters(p_page_parameter_tbl);
160: fii_ea_util_pkg.get_rolling_period;
161: l_ledger_where := fii_ea_util_pkg.get_ledger_for_detail;
162: l_as_of_date := fii_ea_util_pkg.g_as_of_date;
163: l_page_period_type := fii_ea_util_pkg.g_page_period_type;
164: l_company_id := fii_ea_util_pkg.g_company_id;
165: l_cost_center_id := fii_ea_util_pkg.g_cost_center_id;
166: l_curr_view := fii_ea_util_pkg.g_curr_view;
167: l_fin_category_id := fii_ea_util_pkg.g_fin_category_id;

Line 164: l_company_id := fii_ea_util_pkg.g_company_id;

160: fii_ea_util_pkg.get_rolling_period;
161: l_ledger_where := fii_ea_util_pkg.get_ledger_for_detail;
162: l_as_of_date := fii_ea_util_pkg.g_as_of_date;
163: l_page_period_type := fii_ea_util_pkg.g_page_period_type;
164: l_company_id := fii_ea_util_pkg.g_company_id;
165: l_cost_center_id := fii_ea_util_pkg.g_cost_center_id;
166: l_curr_view := fii_ea_util_pkg.g_curr_view;
167: l_fin_category_id := fii_ea_util_pkg.g_fin_category_id;
168: l_fud1_where := fii_ea_util_pkg.get_fud1_for_detail;

Line 165: l_cost_center_id := fii_ea_util_pkg.g_cost_center_id;

161: l_ledger_where := fii_ea_util_pkg.get_ledger_for_detail;
162: l_as_of_date := fii_ea_util_pkg.g_as_of_date;
163: l_page_period_type := fii_ea_util_pkg.g_page_period_type;
164: l_company_id := fii_ea_util_pkg.g_company_id;
165: l_cost_center_id := fii_ea_util_pkg.g_cost_center_id;
166: l_curr_view := fii_ea_util_pkg.g_curr_view;
167: l_fin_category_id := fii_ea_util_pkg.g_fin_category_id;
168: l_fud1_where := fii_ea_util_pkg.get_fud1_for_detail;
169: l_fud2_where := fii_ea_util_pkg.get_fud2_for_detail;

Line 166: l_curr_view := fii_ea_util_pkg.g_curr_view;

162: l_as_of_date := fii_ea_util_pkg.g_as_of_date;
163: l_page_period_type := fii_ea_util_pkg.g_page_period_type;
164: l_company_id := fii_ea_util_pkg.g_company_id;
165: l_cost_center_id := fii_ea_util_pkg.g_cost_center_id;
166: l_curr_view := fii_ea_util_pkg.g_curr_view;
167: l_fin_category_id := fii_ea_util_pkg.g_fin_category_id;
168: l_fud1_where := fii_ea_util_pkg.get_fud1_for_detail;
169: l_fud2_where := fii_ea_util_pkg.get_fud2_for_detail;
170:

Line 167: l_fin_category_id := fii_ea_util_pkg.g_fin_category_id;

163: l_page_period_type := fii_ea_util_pkg.g_page_period_type;
164: l_company_id := fii_ea_util_pkg.g_company_id;
165: l_cost_center_id := fii_ea_util_pkg.g_cost_center_id;
166: l_curr_view := fii_ea_util_pkg.g_curr_view;
167: l_fin_category_id := fii_ea_util_pkg.g_fin_category_id;
168: l_fud1_where := fii_ea_util_pkg.get_fud1_for_detail;
169: l_fud2_where := fii_ea_util_pkg.get_fud2_for_detail;
170:
171: l_previous_three_end_date := fii_ea_util_pkg.g_previous_three_end_date;

Line 168: l_fud1_where := fii_ea_util_pkg.get_fud1_for_detail;

164: l_company_id := fii_ea_util_pkg.g_company_id;
165: l_cost_center_id := fii_ea_util_pkg.g_cost_center_id;
166: l_curr_view := fii_ea_util_pkg.g_curr_view;
167: l_fin_category_id := fii_ea_util_pkg.g_fin_category_id;
168: l_fud1_where := fii_ea_util_pkg.get_fud1_for_detail;
169: l_fud2_where := fii_ea_util_pkg.get_fud2_for_detail;
170:
171: l_previous_three_end_date := fii_ea_util_pkg.g_previous_three_end_date;
172: l_previous_two_end_date := fii_ea_util_pkg.g_previous_two_end_date;

Line 169: l_fud2_where := fii_ea_util_pkg.get_fud2_for_detail;

165: l_cost_center_id := fii_ea_util_pkg.g_cost_center_id;
166: l_curr_view := fii_ea_util_pkg.g_curr_view;
167: l_fin_category_id := fii_ea_util_pkg.g_fin_category_id;
168: l_fud1_where := fii_ea_util_pkg.get_fud1_for_detail;
169: l_fud2_where := fii_ea_util_pkg.get_fud2_for_detail;
170:
171: l_previous_three_end_date := fii_ea_util_pkg.g_previous_three_end_date;
172: l_previous_two_end_date := fii_ea_util_pkg.g_previous_two_end_date;
173: l_previous_one_end_date := fii_ea_util_pkg.g_previous_one_end_date;

Line 171: l_previous_three_end_date := fii_ea_util_pkg.g_previous_three_end_date;

167: l_fin_category_id := fii_ea_util_pkg.g_fin_category_id;
168: l_fud1_where := fii_ea_util_pkg.get_fud1_for_detail;
169: l_fud2_where := fii_ea_util_pkg.get_fud2_for_detail;
170:
171: l_previous_three_end_date := fii_ea_util_pkg.g_previous_three_end_date;
172: l_previous_two_end_date := fii_ea_util_pkg.g_previous_two_end_date;
173: l_previous_one_end_date := fii_ea_util_pkg.g_previous_one_end_date;
174:
175:

Line 172: l_previous_two_end_date := fii_ea_util_pkg.g_previous_two_end_date;

168: l_fud1_where := fii_ea_util_pkg.get_fud1_for_detail;
169: l_fud2_where := fii_ea_util_pkg.get_fud2_for_detail;
170:
171: l_previous_three_end_date := fii_ea_util_pkg.g_previous_three_end_date;
172: l_previous_two_end_date := fii_ea_util_pkg.g_previous_two_end_date;
173: l_previous_one_end_date := fii_ea_util_pkg.g_previous_one_end_date;
174:
175:
176: -- order by clause

Line 173: l_previous_one_end_date := fii_ea_util_pkg.g_previous_one_end_date;

169: l_fud2_where := fii_ea_util_pkg.get_fud2_for_detail;
170:
171: l_previous_three_end_date := fii_ea_util_pkg.g_previous_three_end_date;
172: l_previous_two_end_date := fii_ea_util_pkg.g_previous_two_end_date;
173: l_previous_one_end_date := fii_ea_util_pkg.g_previous_one_end_date;
174:
175:
176: -- order by clause
177: IF (p_page_parameter_tbl.count > 0) THEN

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

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

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

264: , fii_company_hierarchies co_hier
265: , fii_cost_ctr_hierarchies cc_hier
266: , fii_com_cc_dim_maps ccom_map ';
267: l_company_id_where := ' and fcg.user_id = fnd_global.user_id
268: and fcg.report_region_code = '''||fii_ea_util_pkg.g_region_code||'''
269: and co_hier.parent_company_id = fcg.company_id
270: and co_hier.child_company_id = ccom_map.parent_company_dim_id
271: and ccom_map.child_company_id = f.company_id
272: and cc_hier.parent_cc_id = :COST_CENTER_ID

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

288: , fii_company_hierarchies co_hier
289: , fii_cost_ctr_hierarchies cc_hier
290: , fii_com_cc_dim_maps ccom_map ';
291: l_company_id_where := ' and fcg.user_id = fnd_global.user_id
292: and fcg.report_region_code = '''||fii_ea_util_pkg.g_region_code||'''
293: and co_hier.parent_company_id = fcg.company_id
294: and fcg.user_id = ccg.user_id
295: and fcg.report_region_code = ccg.report_region_code
296: and co_hier.child_company_id = ccom_map.parent_company_dim_id

Line 394: IF fii_ea_util_pkg.g_snapshot = 'Y' THEN

390: -- Populating xtd and hist_amt4 columns in the report when period_type = Year
391:
392: IF l_page_period_type = 'FII_TIME_ENT_YEAR' THEN
393:
394: IF fii_ea_util_pkg.g_snapshot = 'Y' THEN
395: xtd := 'G_YTD';
396: hist_amt4 := 'G_QTD';
397: ELSE
398:

Line 497: IF fii_ea_util_pkg.g_snapshot = 'Y' THEN

493: -- Populating xtd and hist_amt4 columns in the report when period_type = Quarter
494:
495: ELSIF l_page_period_type = 'FII_TIME_ENT_QTR' THEN
496:
497: IF fii_ea_util_pkg.g_snapshot = 'Y' THEN
498: xtd := 'G_QTD';
499: hist_amt4 := 'G_MTD';
500: ELSE
501: -- to find the sequence of the month of as-of-date. Based on the sequence number

Line 603: IF fii_ea_util_pkg.g_snapshot = 'Y' THEN

599: -- the xtd column of the report will be populated.
600: SELECT sequence, ent_year_id INTO l_months, l_year_id
601: FROM fii_time_ent_period WHERE l_as_of_date BETWEEN start_date AND end_date;
602:
603: IF fii_ea_util_pkg.g_snapshot = 'Y' THEN
604: xtd := 'G_MTD';
605: ELSE
606: xtd := 'G_MONTH'||l_months;
607:

Line 621: fii_ea_util_pkg.g_year_id := l_year_id;

617: p_hist_amt3 := null;
618:
619: END IF; -- period_type - period
620:
621: fii_ea_util_pkg.g_year_id := l_year_id;
622: fii_ea_util_pkg.g_prior_year_id := l_prior_year_id;
623:
624: -- Constructing the sql when rolling periods extend to previous year
625:

Line 622: fii_ea_util_pkg.g_prior_year_id := l_prior_year_id;

618:
619: END IF; -- period_type - period
620:
621: fii_ea_util_pkg.g_year_id := l_year_id;
622: fii_ea_util_pkg.g_prior_year_id := l_prior_year_id;
623:
624: -- Constructing the sql when rolling periods extend to previous year
625:
626: -- coded like SUM('||p_hist_amt1||'+0). Sometimes p_hist_amt1 can be null.