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_GL_EXPENSE_PKG dependencies on FII_GL_UTIL_PKG

Line 10: fii_gl_util_pkg.reset_globals;

6: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL, exp_per_emp_sql out NOCOPY VARCHAR2,
7: exp_per_emp_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
8:
9: BEGIN
10: fii_gl_util_pkg.reset_globals;
11: fii_gl_util_pkg.g_fin_type := 'TE';
12:
13: fii_gl_expense_pkg.get_expenses_per_emp(p_page_parameter_tbl, exp_per_emp_sql, exp_per_emp_output);
14: END get_te_per_emp;

Line 11: fii_gl_util_pkg.g_fin_type := 'TE';

7: exp_per_emp_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
8:
9: BEGIN
10: fii_gl_util_pkg.reset_globals;
11: fii_gl_util_pkg.g_fin_type := 'TE';
12:
13: fii_gl_expense_pkg.get_expenses_per_emp(p_page_parameter_tbl, exp_per_emp_sql, exp_per_emp_output);
14: END get_te_per_emp;
15:

Line 21: fii_gl_util_pkg.reset_globals;

17: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL, exp_per_emp_sql out NOCOPY VARCHAR2,
18: exp_per_emp_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
19:
20: BEGIN
21: fii_gl_util_pkg.reset_globals;
22: fii_gl_util_pkg.g_fin_type := 'OE';
23:
24: fii_gl_expense_pkg.get_expenses_per_emp(p_page_parameter_tbl, exp_per_emp_sql, exp_per_emp_output);
25: END get_exp_per_emp;

Line 22: fii_gl_util_pkg.g_fin_type := 'OE';

18: exp_per_emp_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
19:
20: BEGIN
21: fii_gl_util_pkg.reset_globals;
22: fii_gl_util_pkg.g_fin_type := 'OE';
23:
24: fii_gl_expense_pkg.get_expenses_per_emp(p_page_parameter_tbl, exp_per_emp_sql, exp_per_emp_output);
25: END get_exp_per_emp;
26:

Line 44: fii_gl_util_pkg.g_view_by := 'HRI_PERSON+HRI_PER_USRDR_H';

40:
41: l_shared_hr_flag VARCHAR2(1) := NVL(fnd_profile.value('HRI_DBI_FORCE_SHARED_HR'),'N');
42:
43: BEGIN
44: fii_gl_util_pkg.g_view_by := 'HRI_PERSON+HRI_PER_USRDR_H';
45: fii_gl_util_pkg.get_parameters(p_page_parameter_tbl);
46: fii_gl_util_pkg.get_bitmasks;
47: fii_gl_util_pkg.get_viewby_sql;
48: fii_gl_util_pkg.get_mgr_pmv_sql;

Line 45: fii_gl_util_pkg.get_parameters(p_page_parameter_tbl);

41: l_shared_hr_flag VARCHAR2(1) := NVL(fnd_profile.value('HRI_DBI_FORCE_SHARED_HR'),'N');
42:
43: BEGIN
44: fii_gl_util_pkg.g_view_by := 'HRI_PERSON+HRI_PER_USRDR_H';
45: fii_gl_util_pkg.get_parameters(p_page_parameter_tbl);
46: fii_gl_util_pkg.get_bitmasks;
47: fii_gl_util_pkg.get_viewby_sql;
48: fii_gl_util_pkg.get_mgr_pmv_sql;
49: fii_gl_util_pkg.get_cat_pmv_sql;

Line 46: fii_gl_util_pkg.get_bitmasks;

42:
43: BEGIN
44: fii_gl_util_pkg.g_view_by := 'HRI_PERSON+HRI_PER_USRDR_H';
45: fii_gl_util_pkg.get_parameters(p_page_parameter_tbl);
46: fii_gl_util_pkg.get_bitmasks;
47: fii_gl_util_pkg.get_viewby_sql;
48: fii_gl_util_pkg.get_mgr_pmv_sql;
49: fii_gl_util_pkg.get_cat_pmv_sql;
50:

Line 47: fii_gl_util_pkg.get_viewby_sql;

43: BEGIN
44: fii_gl_util_pkg.g_view_by := 'HRI_PERSON+HRI_PER_USRDR_H';
45: fii_gl_util_pkg.get_parameters(p_page_parameter_tbl);
46: fii_gl_util_pkg.get_bitmasks;
47: fii_gl_util_pkg.get_viewby_sql;
48: fii_gl_util_pkg.get_mgr_pmv_sql;
49: fii_gl_util_pkg.get_cat_pmv_sql;
50:
51: /*

Line 48: fii_gl_util_pkg.get_mgr_pmv_sql;

44: fii_gl_util_pkg.g_view_by := 'HRI_PERSON+HRI_PER_USRDR_H';
45: fii_gl_util_pkg.get_parameters(p_page_parameter_tbl);
46: fii_gl_util_pkg.get_bitmasks;
47: fii_gl_util_pkg.get_viewby_sql;
48: fii_gl_util_pkg.get_mgr_pmv_sql;
49: fii_gl_util_pkg.get_cat_pmv_sql;
50:
51: /*
52: VIEWBY = MANAGER

Line 49: fii_gl_util_pkg.get_cat_pmv_sql;

45: fii_gl_util_pkg.get_parameters(p_page_parameter_tbl);
46: fii_gl_util_pkg.get_bitmasks;
47: fii_gl_util_pkg.get_viewby_sql;
48: fii_gl_util_pkg.get_mgr_pmv_sql;
49: fii_gl_util_pkg.get_cat_pmv_sql;
50:
51: /*
52: VIEWBY = MANAGER
53: FII_MEASURE1 = Current Expenses

Line 74: select total_headcount+1 into fii_gl_util_pkg.g_total_hc

70: -- and used in the Expenses per Head reports
71: -- -------------------------------------------------
72: --query below gets the headcount for the reporting date
73: begin
74: select total_headcount+1 into fii_gl_util_pkg.g_total_hc
75: from hri_mdp_sup_wmv_sup_mv
76: where supervisor_person_id = fii_gl_util_pkg.g_mgr_id
77: and effective_start_date = (SELECT max(aa.effective_start_date)
78: FROM hri_mdp_sup_wmv_sup_mv aa

Line 76: where supervisor_person_id = fii_gl_util_pkg.g_mgr_id

72: --query below gets the headcount for the reporting date
73: begin
74: select total_headcount+1 into fii_gl_util_pkg.g_total_hc
75: from hri_mdp_sup_wmv_sup_mv
76: where supervisor_person_id = fii_gl_util_pkg.g_mgr_id
77: and effective_start_date = (SELECT max(aa.effective_start_date)
78: FROM hri_mdp_sup_wmv_sup_mv aa
79: WHERE aa.supervisor_person_id = fii_gl_util_pkg.g_mgr_id
80: AND aa.effective_start_date <= decode(l_shared_hr_flag, 'N', fii_gl_util_pkg.g_as_of_date, sysdate));

Line 79: WHERE aa.supervisor_person_id = fii_gl_util_pkg.g_mgr_id

75: from hri_mdp_sup_wmv_sup_mv
76: where supervisor_person_id = fii_gl_util_pkg.g_mgr_id
77: and effective_start_date = (SELECT max(aa.effective_start_date)
78: FROM hri_mdp_sup_wmv_sup_mv aa
79: WHERE aa.supervisor_person_id = fii_gl_util_pkg.g_mgr_id
80: AND aa.effective_start_date <= decode(l_shared_hr_flag, 'N', fii_gl_util_pkg.g_as_of_date, sysdate));
81: exception
82: when others then
83: fii_gl_util_pkg.g_total_hc := 1;

Line 80: AND aa.effective_start_date <= decode(l_shared_hr_flag, 'N', fii_gl_util_pkg.g_as_of_date, sysdate));

76: where supervisor_person_id = fii_gl_util_pkg.g_mgr_id
77: and effective_start_date = (SELECT max(aa.effective_start_date)
78: FROM hri_mdp_sup_wmv_sup_mv aa
79: WHERE aa.supervisor_person_id = fii_gl_util_pkg.g_mgr_id
80: AND aa.effective_start_date <= decode(l_shared_hr_flag, 'N', fii_gl_util_pkg.g_as_of_date, sysdate));
81: exception
82: when others then
83: fii_gl_util_pkg.g_total_hc := 1;
84: end;

Line 83: fii_gl_util_pkg.g_total_hc := 1;

79: WHERE aa.supervisor_person_id = fii_gl_util_pkg.g_mgr_id
80: AND aa.effective_start_date <= decode(l_shared_hr_flag, 'N', fii_gl_util_pkg.g_as_of_date, sysdate));
81: exception
82: when others then
83: fii_gl_util_pkg.g_total_hc := 1;
84: end;
85:
86: --query below gets the headcount as of the prior reporting date
87: begin

Line 90: where supervisor_person_id = fii_gl_util_pkg.g_mgr_id

86: --query below gets the headcount as of the prior reporting date
87: begin
88: select total_headcount+1 into l_total_prior_hc
89: from hri_mdp_sup_wmv_sup_mv
90: where supervisor_person_id = fii_gl_util_pkg.g_mgr_id
91: and effective_start_date = (SELECT max(aa.effective_start_date)
92: FROM hri_mdp_sup_wmv_sup_mv aa
93: WHERE aa.supervisor_person_id = fii_gl_util_pkg.g_mgr_id
94: AND aa.effective_start_date <= decode(l_shared_hr_flag, 'N', fii_gl_util_pkg.g_previous_asof_date, sysdate));

Line 93: WHERE aa.supervisor_person_id = fii_gl_util_pkg.g_mgr_id

89: from hri_mdp_sup_wmv_sup_mv
90: where supervisor_person_id = fii_gl_util_pkg.g_mgr_id
91: and effective_start_date = (SELECT max(aa.effective_start_date)
92: FROM hri_mdp_sup_wmv_sup_mv aa
93: WHERE aa.supervisor_person_id = fii_gl_util_pkg.g_mgr_id
94: AND aa.effective_start_date <= decode(l_shared_hr_flag, 'N', fii_gl_util_pkg.g_previous_asof_date, sysdate));
95: exception
96: when others then
97: l_total_prior_hc := 1;

Line 94: AND aa.effective_start_date <= decode(l_shared_hr_flag, 'N', fii_gl_util_pkg.g_previous_asof_date, sysdate));

90: where supervisor_person_id = fii_gl_util_pkg.g_mgr_id
91: and effective_start_date = (SELECT max(aa.effective_start_date)
92: FROM hri_mdp_sup_wmv_sup_mv aa
93: WHERE aa.supervisor_person_id = fii_gl_util_pkg.g_mgr_id
94: AND aa.effective_start_date <= decode(l_shared_hr_flag, 'N', fii_gl_util_pkg.g_previous_asof_date, sysdate));
95: exception
96: when others then
97: l_total_prior_hc := 1;
98: end;

Line 107: IF (fii_gl_util_pkg.g_time_comp = 'BUDGET') then

103: --This union exlucdes the manager himself.
104: -- Third Union accounts for the directs and the manager themselves in the headcount number for both reporting date + prior reporting date.
105: -- Fourth Union gets the expenses for reporting date + prior reporting date.
106:
107: IF (fii_gl_util_pkg.g_time_comp = 'BUDGET') then
108: l_prior_exp := 'to_number(null) FII_MEASURE9,';
109: l_prior_hc := 'to_number(null) FII_MEASURE10,';
110: l_prior_gt_exp := 'to_number(null) FII_ATTRIBUTE10,';
111: l_prior_gt_hc := 'to_number(null) FII_ATTRIBUTE12,';

Line 122: IF fii_gl_util_pkg.g_mgr_id = -99999 THEN

118: l_prior_gt_exp := ' sum(PY_XTD) over() FII_ATTRIBUTE10,';
119: l_prior_gt_hc := l_total_prior_hc||' FII_ATTRIBUTE12,';
120: END IF;
121:
122: IF fii_gl_util_pkg.g_mgr_id = -99999 THEN
123:
124:
125: sqlstmt := 'SELECT NULL VIEWBY,
126: NULL VIEWBYID,

Line 147: decode(:MGR_ID, f.viewby_id, decode(:DIM_FLAG,''Y'','||fii_gl_util_pkg.g_viewby_value||', '||fii_gl_util_pkg.g_viewby_value||'||'''||' '||'''||:DIR_MSG), '||fii_gl_util_pkg.g_viewby_value||') VIEWBY,

143:
144:
145: sqlstmt := '
146: SELECT
147: decode(:MGR_ID, f.viewby_id, decode(:DIM_FLAG,''Y'','||fii_gl_util_pkg.g_viewby_value||', '||fii_gl_util_pkg.g_viewby_value||'||'''||' '||'''||:DIR_MSG), '||fii_gl_util_pkg.g_viewby_value||') VIEWBY,
148: f.viewby_id VIEWBYID,
149: CY_XTD FII_MEASURE1,
150: '||l_prior_exp||'
151: case when f.VIEWBY_ID = &HRI_PERSON+HRI_PER_USRDR_H

Line 225: FROM fii_time_rpt_struct cal'||fii_gl_util_pkg.g_view||'

221: sum(case when cal.report_date = &BIS_CURRENT_ASOF_DATE
222: then f.actual_g else to_number(null) end) CY_XTD,
223: sum(case when cal.report_date = &BIS_PREVIOUS_ASOF_DATE
224: then f.actual_g else to_number(null) end) PY_XTD
225: FROM fii_time_rpt_struct cal'||fii_gl_util_pkg.g_view||'
226: WHERE 1=1'||fii_gl_util_pkg.g_mgr_join||fii_gl_util_pkg.g_cat_join||fii_gl_util_pkg.g_gid||'
227: AND f.time_id = cal.time_id
228: AND f.period_type_id = cal.period_type_id
229: AND bitand(cal.record_type_id, :ACTUAL_PERIOD_TYPE)= cal.record_type_id

Line 226: WHERE 1=1'||fii_gl_util_pkg.g_mgr_join||fii_gl_util_pkg.g_cat_join||fii_gl_util_pkg.g_gid||'

222: then f.actual_g else to_number(null) end) CY_XTD,
223: sum(case when cal.report_date = &BIS_PREVIOUS_ASOF_DATE
224: then f.actual_g else to_number(null) end) PY_XTD
225: FROM fii_time_rpt_struct cal'||fii_gl_util_pkg.g_view||'
226: WHERE 1=1'||fii_gl_util_pkg.g_mgr_join||fii_gl_util_pkg.g_cat_join||fii_gl_util_pkg.g_gid||'
227: AND f.time_id = cal.time_id
228: AND f.period_type_id = cal.period_type_id
229: AND bitand(cal.record_type_id, :ACTUAL_PERIOD_TYPE)= cal.record_type_id
230: AND cal.report_date in (&BIS_CURRENT_ASOF_DATE, &BIS_PREVIOUS_ASOF_DATE)

Line 234: ) f, '||fii_gl_util_pkg.g_viewby_from_clause||'

230: AND cal.report_date in (&BIS_CURRENT_ASOF_DATE, &BIS_PREVIOUS_ASOF_DATE)
231: GROUP BY f.person_id
232: ) h
233: GROUP BY VIEWBY_ID
234: ) f, '||fii_gl_util_pkg.g_viewby_from_clause||'
235: WHERE '||fii_gl_util_pkg.g_viewby_join||'
236: ORDER BY NVL(FII_MEASURE3, -9999999999) desc';
237:
238: END IF;

Line 235: WHERE '||fii_gl_util_pkg.g_viewby_join||'

231: GROUP BY f.person_id
232: ) h
233: GROUP BY VIEWBY_ID
234: ) f, '||fii_gl_util_pkg.g_viewby_from_clause||'
235: WHERE '||fii_gl_util_pkg.g_viewby_join||'
236: ORDER BY NVL(FII_MEASURE3, -9999999999) desc';
237:
238: END IF;
239:

Line 241: fii_gl_util_pkg.bind_variable(sqlstmt, p_page_parameter_tbl, exp_per_emp_sql, exp_per_emp_output);

237:
238: END IF;
239:
240:
241: fii_gl_util_pkg.bind_variable(sqlstmt, p_page_parameter_tbl, exp_per_emp_sql, exp_per_emp_output);
242:
243:
244: END GET_EXPENSES_PER_EMP;
245: