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_OPL_BDGTS_LBRCST_ORGMGR dependencies on HRI_MDP_BDGTS_LBRCST_ORGMGR_CT

Line 112: INSERT INTO HRI_MDP_BDGTS_LBRCST_ORGMGR_CT (

108: --
109: l_current_time := SYSDATE;
110: l_user_id := fnd_global.user_id;
111: --
112: INSERT INTO HRI_MDP_BDGTS_LBRCST_ORGMGR_CT (
113: orgmgr_id
114: ,effective_start_date
115: ,effective_end_date
116: ,organization_id

Line 157: dbg(SQL%ROWCOUNT||' records inserted into HRI_MDP_BDGTS_LBRCST_ORGMGR_CT');

153: ,hri_cs_suph_orgmgr_ct orgmgr
154: WHERE bdgts.organization_id = orgmgr.sub_organization_id
155: AND bdgts.budget_measurement_type = 'MONEY';
156: --
157: dbg(SQL%ROWCOUNT||' records inserted into HRI_MDP_BDGTS_LBRCST_ORGMGR_CT');
158: dbg('Exiting process');
159: COMMIT;
160: --
161: EXCEPTION

Line 192: run_sql_stmt_noerr('ALTER TRIGGER HRI_MDP_BDGTS_LBRCST_ORGMGR_CT_WHO DISABLE');

188: set_parameters;
189: --
190: -- Disable the WHO trigger
191: --
192: run_sql_stmt_noerr('ALTER TRIGGER HRI_MDP_BDGTS_LBRCST_ORGMGR_CT_WHO DISABLE');
193: --
194: -- ---------------------------------------------------------------------------
195: -- Full Refresh Section
196: -- ---------------------------------------------------------------------------

Line 208: p_table_name => 'HRI_MDP_BDGTS_LBRCST_ORGMGR_CT',

204: -- Drop Indexes
205: --
206: hri_utl_ddl.log_and_drop_indexes(
207: p_application_short_name => 'HRI',
208: p_table_name => 'HRI_MDP_BDGTS_LBRCST_ORGMGR_CT',
209: p_table_owner => l_schema);
210: --
211: -- Truncate the table
212: --

Line 213: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_schema || '.HRI_MDP_BDGTS_LBRCST_ORGMGR_CT';

209: p_table_owner => l_schema);
210: --
211: -- Truncate the table
212: --
213: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_schema || '.HRI_MDP_BDGTS_LBRCST_ORGMGR_CT';
214: --
215: END IF;
216: --
217: END IF;

Line 252: p_table_name => 'HRI_MDP_BDGTS_LBRCST_ORGMGR_CT',

248: dbg('Full Refresh selected - Creating indexes');
249: --
250: hri_utl_ddl.recreate_indexes(
251: p_application_short_name => 'HRI',
252: p_table_name => 'HRI_MDP_BDGTS_LBRCST_ORGMGR_CT',
253: p_table_owner => l_schema);
254: --
255: -- Collect the statistics only when the process is NOT invoked by a concurrent manager
256: --

Line 260: fnd_stats.gather_table_stats(l_schema,'HRI_MDP_BDGTS_LBRCST_ORGMGR_CT');

256: --
257: IF fnd_global.conc_request_id is null THEN
258: --
259: dbg('Full Refresh selected - gathering stats');
260: fnd_stats.gather_table_stats(l_schema,'HRI_MDP_BDGTS_LBRCST_ORGMGR_CT');
261: --
262: END IF;
263: --
264: END IF;

Line 277: run_sql_stmt_noerr('ALTER TRIGGER HRI_MDP_BDGTS_LBRCST_ORGMGR_CT_WHO ENABLE');

273: --
274: -- Enable the WHO trigger on the fact table
275: --
276: dbg('Enabling the who trigger');
277: run_sql_stmt_noerr('ALTER TRIGGER HRI_MDP_BDGTS_LBRCST_ORGMGR_CT_WHO ENABLE');
278: --
279: hri_bpl_conc_log.log_process_end(
280: p_status => TRUE
281: ,p_period_from => TRUNC(g_refresh_start_date)