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 BIS_COLLECTION_UTILITIES

Line 43: bis_collection_utilities.log('Events Population Done',1);

39: AND b.version_date_from BETWEEN p_effective_start_date
40: AND p_effective_end_date;
41: COMMIT;
42: --
43: bis_collection_utilities.log('Events Population Done',1);
44: --
45: END calc_events;
46: --
47: --*******************************

Line 69: bis_collection_utilities.log('Budgeted Headcount Calculation Done',1);

65: AND b.budget_version_id = hrp.budget_version_id);
66:
67: COMMIT;
68: --
69: bis_collection_utilities.log('Budgeted Headcount Calculation Done',1);
70: --
71: END get_budgeted_headcount;
72: --
73: --*******************************

Line 114: bis_collection_utilities.log('********************************',1);

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);
116: bis_collection_utilities.log('********************************',1);
117:
118: DELETE

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 116: bis_collection_utilities.log('********************************',1);

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
120: WHERE psum.sum_information_category = 'HRI_DBI_WMV_BUDGET'

Line 124: bis_collection_utilities.log('Delete records from the HR_PORTAL_SUMMARY_DATA table',1);

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);
125: --
126: --set dates
127: l_effective_start_date := trunc(fnd_date.canonical_to_date(p_effective_start_date));
128: l_effective_end_date := trunc(fnd_date.canonical_to_date(p_effective_end_date));

Line 131: bis_collection_utilities.log('Effective Start Date : '||TO_CHAR(l_effective_start_date),1);

127: l_effective_start_date := trunc(fnd_date.canonical_to_date(p_effective_start_date));
128: l_effective_end_date := trunc(fnd_date.canonical_to_date(p_effective_end_date));
129:
130: --
131: bis_collection_utilities.log('Effective Start Date : '||TO_CHAR(l_effective_start_date),1);
132: bis_collection_utilities.log('Effective End Date : '||TO_CHAR(l_effective_end_date),1);
133: --
134: --set global parameters
135: --

Line 132: bis_collection_utilities.log('Effective End Date : '||TO_CHAR(l_effective_end_date),1);

128: l_effective_end_date := trunc(fnd_date.canonical_to_date(p_effective_end_date));
129:
130: --
131: bis_collection_utilities.log('Effective Start Date : '||TO_CHAR(l_effective_start_date),1);
132: bis_collection_utilities.log('Effective End Date : '||TO_CHAR(l_effective_end_date),1);
133: --
134: --set global parameters
135: --
136: g_abv_type := fnd_profile.value('BIS_WORKFORCE_MEASUREMENT_TYPE');

Line 138: bis_collection_utilities.log('Workforce Measurement Value: '||g_abv_type,1);

134: --set global parameters
135: --
136: g_abv_type := fnd_profile.value('BIS_WORKFORCE_MEASUREMENT_TYPE');
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: --

Line 180: bis_collection_utilities.log('Full Refresh Complete',1);

176: END LOOP;
177: CLOSE c_events;
178: COMMIT;
179: --
180: bis_collection_utilities.log('Full Refresh Complete',1);
181: --
182: EXCEPTION
183: WHEN OTHERS THEN
184: errbuf := SQLERRM;

Line 214: bis_collection_utilities.log('****************************',1);

210: PROCEDURE refresh_mvs( errbuf OUT NOCOPY VARCHAR2
211: ,retcode OUT NOCOPY NUMBER) IS
212: BEGIN
213: --
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');

Line 215: bis_collection_utilities.log('Refresh Materialized Views',1);

211: ,retcode OUT NOCOPY NUMBER) IS
212: BEGIN
213: --
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: --

Line 216: bis_collection_utilities.log('****************************',1);

212: BEGIN
213: --
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);

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