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.HRI_DBI_WMV_BUDGET dependencies on HRI_DBI_WMV_BUDGET

Line 1: PACKAGE BODY hri_dbi_wmv_budget AS

1: PACKAGE BODY hri_dbi_wmv_budget AS
2: /* $Header: hribdgco.pkb 120.0 2005/05/29 07:01:54 appldev noship $ */
3: --
4: --**********************************************
5: --* Define global constants *

Line 9: g_con_info_category CONSTANT VARCHAR2(30) := 'HRI_DBI_WMV_BUDGET';

5: --* Define global constants *
6: --**********************************************
7: --
8: g_con_context_type CONSTANT VARCHAR2(30) := 'SUPERVISOR';
9: g_con_info_category CONSTANT VARCHAR2(30) := 'HRI_DBI_WMV_BUDGET';
10: g_object_name CONSTANT VARCHAR2(30) := 'HRI_DBI_WMV_BUDGET';
11: --
12: --***********************************************
13: --* Define global parameters *

Line 10: g_object_name CONSTANT VARCHAR2(30) := 'HRI_DBI_WMV_BUDGET';

6: --**********************************************
7: --
8: g_con_context_type CONSTANT VARCHAR2(30) := 'SUPERVISOR';
9: g_con_info_category CONSTANT VARCHAR2(30) := 'HRI_DBI_WMV_BUDGET';
10: g_object_name CONSTANT VARCHAR2(30) := 'HRI_DBI_WMV_BUDGET';
11: --
12: --***********************************************
13: --* Define global parameters *
14: --***********************************************

Line 25: INSERT INTO hri_dbi_wmv_budget_evts_tmp

21: --
22: PROCEDURE calc_events ( p_effective_start_date IN DATE
23: ,p_effective_end_date IN DATE) IS
24: BEGIN
25: INSERT INTO hri_dbi_wmv_budget_evts_tmp
26: ( supervisor_id
27: ,effective_start_date
28: ,effective_end_date
29: ,budget_version_id

Line 54: UPDATE hri_dbi_wmv_budget_evts_tmp hrp

50: --
51: PROCEDURE get_budgeted_headcount IS
52:
53: BEGIN
54: UPDATE hri_dbi_wmv_budget_evts_tmp hrp
55: SET hrp.budgeted_count = (SELECT sum(decode(g_abv_type,b.budget_unit1_system_type_cd, b.budget_unit1_value,
56: b.budget_unit2_system_type_cd, b.budget_unit2_value,
57: b.budget_unit1_system_type_cd,b.budget_unit3_value ))
58: FROM HRI_MB_BUDGET_V b,

Line 111: FROM hri_dbi_wmv_budget_evts_tmp hrp;

107:
108: CURSOR c_events IS
109: SELECT hrp.supervisor_id, hrp.effective_start_date, hrp.effective_end_date,
110: hrp.budgeted_count
111: FROM hri_dbi_wmv_budget_evts_tmp hrp;
112: BEGIN
113:
114: bis_collection_utilities.log('********************************',1);
115: bis_collection_utilities.log('*HRI_DBI_WMV_BUDGET.FULL_REFRESH*',1);

Line 115: bis_collection_utilities.log('HRI_DBI_WMV_BUDGET.FULL_REFRESH',1);

111: FROM hri_dbi_wmv_budget_evts_tmp hrp;
112: BEGIN
113:
114: bis_collection_utilities.log('********************************',1);
115: bis_collection_utilities.log('*HRI_DBI_WMV_BUDGET.FULL_REFRESH*',1);
116: bis_collection_utilities.log('********************************',1);
117:
118: DELETE
119: FROM hr_ptl_summary_data psum

Line 120: WHERE psum.sum_information_category = 'HRI_DBI_WMV_BUDGET'

116: bis_collection_utilities.log('********************************',1);
117:
118: DELETE
119: FROM hr_ptl_summary_data psum
120: WHERE psum.sum_information_category = 'HRI_DBI_WMV_BUDGET'
121: AND psum.summary_context_type = 'SUPERVISOR';
122: COMMIT;
123: --
124: bis_collection_utilities.log('Delete records from the HR_PORTAL_SUMMARY_DATA table',1);

Line 141: hri_dbi_wmv_budget.calc_events(l_effective_start_date,l_effective_end_date);

137: --
138: bis_collection_utilities.log('Workforce Measurement Value: '||g_abv_type,1);
139: --
140: --events population
141: hri_dbi_wmv_budget.calc_events(l_effective_start_date,l_effective_end_date);
142: --
143: --calculate budgeted headcount
144: hri_dbi_wmv_budget.get_budgeted_headcount;
145:

Line 144: hri_dbi_wmv_budget.get_budgeted_headcount;

140: --events population
141: hri_dbi_wmv_budget.calc_events(l_effective_start_date,l_effective_end_date);
142: --
143: --calculate budgeted headcount
144: hri_dbi_wmv_budget.get_budgeted_headcount;
145:
146: OPEN c_events;
147: LOOP
148: FETCH c_events INTO l_supervisor_id, l_effective_date, l_effective_date1, l_budgeted_headcount;

Line 202: hri_dbi_wmv_budget.full_refresh(errbuf,retcode,l_effective_from_date,l_effective_to_date);

198: BEGIN
199: l_effective_from_date := fnd_date.date_to_canonical(TRUNC(bis_common_parameters.get_global_start_date));
200: l_effective_to_date := fnd_date.date_to_canonical(TRUNC(sysdate));
201:
202: hri_dbi_wmv_budget.full_refresh(errbuf,retcode,l_effective_from_date,l_effective_to_date);
203:
204: END refresh_from_deltas;
205: --
206: -- **********************************************************************

Line 218: dbms_mview.refresh('HRI_DBI_WMV_BUDGET_MV','C');

214: bis_collection_utilities.log('****************************',1);
215: bis_collection_utilities.log('*Refresh Materialized Views*',1);
216: bis_collection_utilities.log('****************************',1);
217: --
218: dbms_mview.refresh('HRI_DBI_WMV_BUDGET_MV','C');
219: --
220: bis_collection_utilities.log('HRI_DBI_WMV_BUDGET_MV Materialized View refreshed',1);
221: --
222: fnd_stats.gather_table_stats('APPS','HRI_DBI_WMV_BUDGET_MV');

Line 220: bis_collection_utilities.log('HRI_DBI_WMV_BUDGET_MV Materialized View refreshed',1);

216: bis_collection_utilities.log('****************************',1);
217: --
218: dbms_mview.refresh('HRI_DBI_WMV_BUDGET_MV','C');
219: --
220: bis_collection_utilities.log('HRI_DBI_WMV_BUDGET_MV Materialized View refreshed',1);
221: --
222: fnd_stats.gather_table_stats('APPS','HRI_DBI_WMV_BUDGET_MV');
223: --
224: bis_collection_utilities.log('HRI_DBI_WMV_BUDGET_MV view statastics gathered',1);

Line 222: fnd_stats.gather_table_stats('APPS','HRI_DBI_WMV_BUDGET_MV');

218: dbms_mview.refresh('HRI_DBI_WMV_BUDGET_MV','C');
219: --
220: bis_collection_utilities.log('HRI_DBI_WMV_BUDGET_MV Materialized View refreshed',1);
221: --
222: fnd_stats.gather_table_stats('APPS','HRI_DBI_WMV_BUDGET_MV');
223: --
224: bis_collection_utilities.log('HRI_DBI_WMV_BUDGET_MV view statastics gathered',1);
225: --
226: EXCEPTION

Line 224: bis_collection_utilities.log('HRI_DBI_WMV_BUDGET_MV view statastics gathered',1);

220: bis_collection_utilities.log('HRI_DBI_WMV_BUDGET_MV Materialized View refreshed',1);
221: --
222: fnd_stats.gather_table_stats('APPS','HRI_DBI_WMV_BUDGET_MV');
223: --
224: bis_collection_utilities.log('HRI_DBI_WMV_BUDGET_MV view statastics gathered',1);
225: --
226: EXCEPTION
227: WHEN OTHERS THEN
228: errbuf := SQLERRM;

Line 231: END hri_dbi_wmv_budget;

227: WHEN OTHERS THEN
228: errbuf := SQLERRM;
229: retcode := SQLCODE;
230: END refresh_mvs;
231: END hri_dbi_wmv_budget;