APPS.FII_EA_SOURCE_PKG dependencies on FII_EA_UTIL_PKG

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

24:
25: l_sqlstmt := get_rev_exp_source (p_page_parameter_tbl => p_page_parameter_tbl,
26: p_multi_factor => l_multi_factor);
27:
28: fii_ea_util_pkg.bind_variable(p_sqlstmt => l_sqlstmt,
29: p_page_parameter_tbl => p_page_parameter_tbl,
30: p_sql_output => p_exp_source_sql,
31: p_bind_output_table => p_exp_source_output);
32:

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

54:
55: l_sqlstmt := get_rev_exp_source (p_page_parameter_tbl => p_page_parameter_tbl,
56: p_multi_factor => l_multi_factor);
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_rev_source_sql,
61: p_bind_output_table => p_rev_source_output);
62:

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

84: l_url_common VARCHAR2(500);
85:
86:
87: BEGIN
88: -- initialization. Calling fii_ea_util_pkg APIs necessary for constructing
89: -- the PMV sql.
90:
91: fii_ea_util_pkg.reset_globals;
92: fii_ea_util_pkg.get_parameters(p_page_parameter_tbl);

Line 91: fii_ea_util_pkg.reset_globals;

87: BEGIN
88: -- initialization. Calling fii_ea_util_pkg APIs necessary for constructing
89: -- the PMV sql.
90:
91: fii_ea_util_pkg.reset_globals;
92: fii_ea_util_pkg.get_parameters(p_page_parameter_tbl);
93: l_ledger_where := fii_ea_util_pkg.get_ledger_for_detail;
94: l_fud1_where := fii_ea_util_pkg.get_fud1_for_detail;
95: l_fud2_where := fii_ea_util_pkg.get_fud2_for_detail;

Line 92: fii_ea_util_pkg.get_parameters(p_page_parameter_tbl);

88: -- initialization. Calling fii_ea_util_pkg APIs necessary for constructing
89: -- the PMV sql.
90:
91: fii_ea_util_pkg.reset_globals;
92: fii_ea_util_pkg.get_parameters(p_page_parameter_tbl);
93: l_ledger_where := fii_ea_util_pkg.get_ledger_for_detail;
94: l_fud1_where := fii_ea_util_pkg.get_fud1_for_detail;
95: l_fud2_where := fii_ea_util_pkg.get_fud2_for_detail;
96: l_curr_view := fii_ea_util_pkg.g_curr_view;

Line 93: l_ledger_where := fii_ea_util_pkg.get_ledger_for_detail;

89: -- the PMV sql.
90:
91: fii_ea_util_pkg.reset_globals;
92: fii_ea_util_pkg.get_parameters(p_page_parameter_tbl);
93: l_ledger_where := fii_ea_util_pkg.get_ledger_for_detail;
94: l_fud1_where := fii_ea_util_pkg.get_fud1_for_detail;
95: l_fud2_where := fii_ea_util_pkg.get_fud2_for_detail;
96: l_curr_view := fii_ea_util_pkg.g_curr_view;
97: l_ledger_id := fii_ea_util_pkg.g_ledger_id;

Line 94: l_fud1_where := fii_ea_util_pkg.get_fud1_for_detail;

90:
91: fii_ea_util_pkg.reset_globals;
92: fii_ea_util_pkg.get_parameters(p_page_parameter_tbl);
93: l_ledger_where := fii_ea_util_pkg.get_ledger_for_detail;
94: l_fud1_where := fii_ea_util_pkg.get_fud1_for_detail;
95: l_fud2_where := fii_ea_util_pkg.get_fud2_for_detail;
96: l_curr_view := fii_ea_util_pkg.g_curr_view;
97: l_ledger_id := fii_ea_util_pkg.g_ledger_id;
98:

Line 95: l_fud2_where := fii_ea_util_pkg.get_fud2_for_detail;

91: fii_ea_util_pkg.reset_globals;
92: fii_ea_util_pkg.get_parameters(p_page_parameter_tbl);
93: l_ledger_where := fii_ea_util_pkg.get_ledger_for_detail;
94: l_fud1_where := fii_ea_util_pkg.get_fud1_for_detail;
95: l_fud2_where := fii_ea_util_pkg.get_fud2_for_detail;
96: l_curr_view := fii_ea_util_pkg.g_curr_view;
97: l_ledger_id := fii_ea_util_pkg.g_ledger_id;
98:
99: -- ledger , fii_ledger_v is already joining to FII_SOURCE_LEDGER_GROUPS, FII_SLG_ASSIGNMENTS.

Line 96: l_curr_view := fii_ea_util_pkg.g_curr_view;

92: fii_ea_util_pkg.get_parameters(p_page_parameter_tbl);
93: l_ledger_where := fii_ea_util_pkg.get_ledger_for_detail;
94: l_fud1_where := fii_ea_util_pkg.get_fud1_for_detail;
95: l_fud2_where := fii_ea_util_pkg.get_fud2_for_detail;
96: l_curr_view := fii_ea_util_pkg.g_curr_view;
97: l_ledger_id := fii_ea_util_pkg.g_ledger_id;
98:
99: -- ledger , fii_ledger_v is already joining to FII_SOURCE_LEDGER_GROUPS, FII_SLG_ASSIGNMENTS.
100: -- pslau: will review this code during perf testing

Line 97: l_ledger_id := fii_ea_util_pkg.g_ledger_id;

93: l_ledger_where := fii_ea_util_pkg.get_ledger_for_detail;
94: l_fud1_where := fii_ea_util_pkg.get_fud1_for_detail;
95: l_fud2_where := fii_ea_util_pkg.get_fud2_for_detail;
96: l_curr_view := fii_ea_util_pkg.g_curr_view;
97: l_ledger_id := fii_ea_util_pkg.g_ledger_id;
98:
99: -- ledger , fii_ledger_v is already joining to FII_SOURCE_LEDGER_GROUPS, FII_SLG_ASSIGNMENTS.
100: -- pslau: will review this code during perf testing
101: