APPS.FII_EA_JE_TRAN_PKG dependencies on FII_EA_UTIL_PKG

Line 15: WHERE fin_category_id= fii_ea_util_pkg.g_fin_category_id

11:
12: SELECT fin_cat_type_code
13: INTO FII_EA_JE_TRAN_PKG.g_fin_type
14: FROM fii_fin_cat_type_assgns
15: WHERE fin_category_id= fii_ea_util_pkg.g_fin_category_id
16: AND fin_cat_type_code IN ('EXP','R');
17:
18: EXCEPTION
19: WHEN no_data_found THEN

Line 48: FII_EA_UTIL_PKG.reset_globals;

44:
45:
46: BEGIN
47:
48: FII_EA_UTIL_PKG.reset_globals;
49: FII_EA_UTIL_PKG.get_parameters(p_page_parameter_tbl=>p_page_parameter_tbl);
50:
51: /* Getting category type for a category */
52: FII_EA_JE_TRAN_PKG.get_cat_type;

Line 49: FII_EA_UTIL_PKG.get_parameters(p_page_parameter_tbl=>p_page_parameter_tbl);

45:
46: BEGIN
47:
48: FII_EA_UTIL_PKG.reset_globals;
49: FII_EA_UTIL_PKG.get_parameters(p_page_parameter_tbl=>p_page_parameter_tbl);
50:
51: /* Getting category type for a category */
52: FII_EA_JE_TRAN_PKG.get_cat_type;
53:

Line 63: l_fud1_where := fii_ea_util_pkg.get_fud1_for_detail;

59: l_cost_center_where := ' AND f.cost_center_id = &ORGANIZATION+HRI_CL_ORGCC ';
60:
61:
62:
63: l_fud1_where := fii_ea_util_pkg.get_fud1_for_detail;
64: l_fud2_where := fii_ea_util_pkg.get_fud2_for_detail;
65:
66: l_fud1_where := REPLACE(l_fud1_where,'f.fud1_id','f.user_dim1_id');
67: l_fud2_where := REPLACE(l_fud2_where,'f.fud2_id','f.user_dim2_id');

Line 64: l_fud2_where := fii_ea_util_pkg.get_fud2_for_detail;

60:
61:
62:
63: l_fud1_where := fii_ea_util_pkg.get_fud1_for_detail;
64: l_fud2_where := fii_ea_util_pkg.get_fud2_for_detail;
65:
66: l_fud1_where := REPLACE(l_fud1_where,'f.fud1_id','f.user_dim1_id');
67: l_fud2_where := REPLACE(l_fud2_where,'f.fud2_id','f.user_dim2_id');
68:

Line 73: SELECT chart_of_accounts_id INTO FII_EA_UTIL_PKG.g_coaid

69:
70: /* Selecting Chart of Accounts ID */
71:
72: BEGIN
73: SELECT chart_of_accounts_id INTO FII_EA_UTIL_PKG.g_coaid
74: FROM gl_ledgers_public_v
75: WHERE ledger_id = FII_EA_UTIL_PKG.g_ledger_id;
76: END;
77:

Line 75: WHERE ledger_id = FII_EA_UTIL_PKG.g_ledger_id;

71:
72: BEGIN
73: SELECT chart_of_accounts_id INTO FII_EA_UTIL_PKG.g_coaid
74: FROM gl_ledgers_public_v
75: WHERE ledger_id = FII_EA_UTIL_PKG.g_ledger_id;
76: END;
77:
78: /* Select columns based on call for Expense or Revenue */
79:

Line 147: FII_EA_UTIL_PKG.bind_variable(

143:
144:
145: -- Attach bind parameters
146:
147: FII_EA_UTIL_PKG.bind_variable(
148: p_sqlstmt=>sqlstmt,
149: p_page_parameter_tbl=>p_page_parameter_tbl,
150: p_sql_output=>jrnl_dtl_sql,
151: p_bind_output_table=>jrnl_dtl_output);

Line 183: FII_EA_UTIL_PKG.get_parameters(p_page_parameter_tbl=>p_page_parameter_tbl);

179:
180:
181: BEGIN
182:
183: FII_EA_UTIL_PKG.get_parameters(p_page_parameter_tbl=>p_page_parameter_tbl);
184:
185: /* Getting category type for a category */
186: FII_EA_JE_TRAN_PKG.get_cat_type;
187:

Line 196: l_fud1_where := fii_ea_util_pkg.get_fud1_for_detail;

192: l_company_where := ' f.company_id = &FII_COMPANIES+FII_COMPANIES ';
193: l_cost_center_where := ' AND f.cost_center_id = &ORGANIZATION+HRI_CL_ORGCC ';
194:
195:
196: l_fud1_where := fii_ea_util_pkg.get_fud1_for_detail;
197: l_fud2_where := fii_ea_util_pkg.get_fud2_for_detail;
198:
199: l_fud1_where := REPLACE(l_fud1_where,'f.fud1_id','f.user_dim1_id');
200: l_fud2_where := REPLACE(l_fud2_where,'f.fud2_id','f.user_dim2_id');

Line 197: l_fud2_where := fii_ea_util_pkg.get_fud2_for_detail;

193: l_cost_center_where := ' AND f.cost_center_id = &ORGANIZATION+HRI_CL_ORGCC ';
194:
195:
196: l_fud1_where := fii_ea_util_pkg.get_fud1_for_detail;
197: l_fud2_where := fii_ea_util_pkg.get_fud2_for_detail;
198:
199: l_fud1_where := REPLACE(l_fud1_where,'f.fud1_id','f.user_dim1_id');
200: l_fud2_where := REPLACE(l_fud2_where,'f.fud2_id','f.user_dim2_id');
201:

Line 206: SELECT chart_of_accounts_id INTO FII_EA_UTIL_PKG.g_coaid

202:
203: /* Selecting Chart of Accounts ID */
204:
205: BEGIN
206: SELECT chart_of_accounts_id INTO FII_EA_UTIL_PKG.g_coaid
207: FROM gl_ledgers_public_v
208: WHERE ledger_id = FII_EA_UTIL_PKG.g_ledger_id;
209: END;
210:

Line 208: WHERE ledger_id = FII_EA_UTIL_PKG.g_ledger_id;

204:
205: BEGIN
206: SELECT chart_of_accounts_id INTO FII_EA_UTIL_PKG.g_coaid
207: FROM gl_ledgers_public_v
208: WHERE ledger_id = FII_EA_UTIL_PKG.g_ledger_id;
209: END;
210:
211: /* Select columns based on call for Expense or Revenue */
212:

Line 309: FII_EA_UTIL_PKG.bind_variable(

305:
306:
307: -- Attach bind parameters
308:
309: FII_EA_UTIL_PKG.bind_variable(
310: p_sqlstmt=>sqlstmt,
311: p_page_parameter_tbl=>p_page_parameter_tbl,
312: p_sql_output=>jrnl_dtl_sql,
313: p_bind_output_table=>jrnl_dtl_output);