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

Line 23: FII_EA_UTIL_PKG.reset_globals;

19:
20:
21: BEGIN
22:
23: FII_EA_UTIL_PKG.reset_globals;
24: FII_EA_UTIL_PKG.get_parameters(p_page_parameter_tbl=>p_page_parameter_tbl);
25:
26: /* Preparing Dynamic where clauses for PMV sql */
27:

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

20:
21: BEGIN
22:
23: FII_EA_UTIL_PKG.reset_globals;
24: FII_EA_UTIL_PKG.get_parameters(p_page_parameter_tbl=>p_page_parameter_tbl);
25:
26: /* Preparing Dynamic where clauses for PMV sql */
27:
28: l_category_where := ' AND f.natural_account_id = &FINANCIAL ITEM+GL_FII_FIN_ITEM ';

Line 33: l_fud1_where := REPLACE(fii_ea_util_pkg.get_fud1_for_detail, 'fud1_id', 'user_dim1_id');

29: l_enc_category_where := ' AND f.fin_category_id = &FINANCIAL ITEM+GL_FII_FIN_ITEM ';
30: l_company_where := ' f.company_id = &FII_COMPANIES+FII_COMPANIES ';
31: l_cost_center_where := ' AND f.cost_center_id = &ORGANIZATION+HRI_CL_ORGCC ';
32:
33: l_fud1_where := REPLACE(fii_ea_util_pkg.get_fud1_for_detail, 'fud1_id', 'user_dim1_id');
34: l_fud2_where := REPLACE(fii_ea_util_pkg.get_fud2_for_detail, 'fud2_id', 'user_dim2_id');
35:
36: SELECT report_date_julian INTO fii_ea_util_pkg.g_curr_per_start_id
37: FROM fii_time_day

Line 34: l_fud2_where := REPLACE(fii_ea_util_pkg.get_fud2_for_detail, 'fud2_id', 'user_dim2_id');

30: l_company_where := ' f.company_id = &FII_COMPANIES+FII_COMPANIES ';
31: l_cost_center_where := ' AND f.cost_center_id = &ORGANIZATION+HRI_CL_ORGCC ';
32:
33: l_fud1_where := REPLACE(fii_ea_util_pkg.get_fud1_for_detail, 'fud1_id', 'user_dim1_id');
34: l_fud2_where := REPLACE(fii_ea_util_pkg.get_fud2_for_detail, 'fud2_id', 'user_dim2_id');
35:
36: SELECT report_date_julian INTO fii_ea_util_pkg.g_curr_per_start_id
37: FROM fii_time_day
38: WHERE report_date = fii_ea_util_pkg.g_curr_per_start;

Line 36: SELECT report_date_julian INTO fii_ea_util_pkg.g_curr_per_start_id

32:
33: l_fud1_where := REPLACE(fii_ea_util_pkg.get_fud1_for_detail, 'fud1_id', 'user_dim1_id');
34: l_fud2_where := REPLACE(fii_ea_util_pkg.get_fud2_for_detail, 'fud2_id', 'user_dim2_id');
35:
36: SELECT report_date_julian INTO fii_ea_util_pkg.g_curr_per_start_id
37: FROM fii_time_day
38: WHERE report_date = fii_ea_util_pkg.g_curr_per_start;
39:
40: SELECT report_date_julian INTO fii_ea_util_pkg.g_as_of_date_id

Line 38: WHERE report_date = fii_ea_util_pkg.g_curr_per_start;

34: l_fud2_where := REPLACE(fii_ea_util_pkg.get_fud2_for_detail, 'fud2_id', 'user_dim2_id');
35:
36: SELECT report_date_julian INTO fii_ea_util_pkg.g_curr_per_start_id
37: FROM fii_time_day
38: WHERE report_date = fii_ea_util_pkg.g_curr_per_start;
39:
40: SELECT report_date_julian INTO fii_ea_util_pkg.g_as_of_date_id
41: FROM fii_time_day
42: WHERE report_date = fii_ea_util_pkg.g_as_of_date;

Line 40: SELECT report_date_julian INTO fii_ea_util_pkg.g_as_of_date_id

36: SELECT report_date_julian INTO fii_ea_util_pkg.g_curr_per_start_id
37: FROM fii_time_day
38: WHERE report_date = fii_ea_util_pkg.g_curr_per_start;
39:
40: SELECT report_date_julian INTO fii_ea_util_pkg.g_as_of_date_id
41: FROM fii_time_day
42: WHERE report_date = fii_ea_util_pkg.g_as_of_date;
43:
44: /* For a Purchase Order, gl_je_lines.reference_2 and gl_je_lines.reference_4 store po_header_id and po_number respectively.

Line 42: WHERE report_date = fii_ea_util_pkg.g_as_of_date;

38: WHERE report_date = fii_ea_util_pkg.g_curr_per_start;
39:
40: SELECT report_date_julian INTO fii_ea_util_pkg.g_as_of_date_id
41: FROM fii_time_day
42: WHERE report_date = fii_ea_util_pkg.g_as_of_date;
43:
44: /* For a Purchase Order, gl_je_lines.reference_2 and gl_je_lines.reference_4 store po_header_id and po_number respectively.
45: We join between gl_je_lines and po_distributions_all on po_header_id to fetch po_release_id (to be passed in PO drill).
46: While joining, we are using outer join since all encumbrance entries may not come through PO. */

Line 133: FII_EA_UTIL_PKG.bind_variable(

129:
130:
131: -- Attach bind parameters
132:
133: FII_EA_UTIL_PKG.bind_variable(
134: p_sqlstmt=>sqlstmt,
135: p_page_parameter_tbl=>p_page_parameter_tbl,
136: p_sql_output=>jrnl_dtl_sql,
137: p_bind_output_table=>jrnl_dtl_output);

Line 166: FII_EA_UTIL_PKG.reset_globals;

162: l_currency_where VARCHAR2(1000) := NULL;
163:
164: BEGIN
165:
166: FII_EA_UTIL_PKG.reset_globals;
167: FII_EA_UTIL_PKG.get_parameters(p_page_parameter_tbl=>p_page_parameter_tbl);
168:
169: /* Preparing Dynamic where clauses for PMV sql */
170:

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

163:
164: BEGIN
165:
166: FII_EA_UTIL_PKG.reset_globals;
167: FII_EA_UTIL_PKG.get_parameters(p_page_parameter_tbl=>p_page_parameter_tbl);
168:
169: /* Preparing Dynamic where clauses for PMV sql */
170:
171: l_category_where := ' AND f.natural_account_id = &FINANCIAL ITEM+GL_FII_FIN_ITEM ';

Line 175: l_fud1_where := REPLACE(fii_ea_util_pkg.get_fud1_for_detail, 'fud1_id', 'user_dim1_id');

171: l_category_where := ' AND f.natural_account_id = &FINANCIAL ITEM+GL_FII_FIN_ITEM ';
172: l_company_where := ' f.company_id = &FII_COMPANIES+FII_COMPANIES ';
173: l_cost_center_where := ' AND f.cost_center_id = &ORGANIZATION+HRI_CL_ORGCC ';
174:
175: l_fud1_where := REPLACE(fii_ea_util_pkg.get_fud1_for_detail, 'fud1_id', 'user_dim1_id');
176: l_fud2_where := REPLACE(fii_ea_util_pkg.get_fud2_for_detail, 'fud2_id', 'user_dim2_id');
177:
178: l_prim_global_curr := BIS_COMMON_PARAMETERS.get_currency_code;
179: l_sec_global_curr := BIS_COMMON_PARAMETERS.get_secondary_currency_code;

Line 176: l_fud2_where := REPLACE(fii_ea_util_pkg.get_fud2_for_detail, 'fud2_id', 'user_dim2_id');

172: l_company_where := ' f.company_id = &FII_COMPANIES+FII_COMPANIES ';
173: l_cost_center_where := ' AND f.cost_center_id = &ORGANIZATION+HRI_CL_ORGCC ';
174:
175: l_fud1_where := REPLACE(fii_ea_util_pkg.get_fud1_for_detail, 'fud1_id', 'user_dim1_id');
176: l_fud2_where := REPLACE(fii_ea_util_pkg.get_fud2_for_detail, 'fud2_id', 'user_dim2_id');
177:
178: l_prim_global_curr := BIS_COMMON_PARAMETERS.get_currency_code;
179: l_sec_global_curr := BIS_COMMON_PARAMETERS.get_secondary_currency_code;
180:

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);