APPS.HRI_OPL_CMNTS_ACTLS dependencies on HRI_MD_CMNTS_ACTLS_CT

Line 112: INSERT INTO HRI_MD_CMNTS_ACTLS_CT (

108: --
109: l_current_time := SYSDATE;
110: l_user_id := fnd_global.user_id;
111: --
112: INSERT INTO HRI_MD_CMNTS_ACTLS_CT (
113: EFFECTIVE_START_DATE
114: ,EFFECTIVE_END_DATE
115: ,ASSIGNMENT_ID
116: ,ORGANIZATION_ID

Line 172: dbg(SQL%ROWCOUNT||' commitment records inserted into HRI_MD_CMNTS_ACTLS_CT');

168: ,SYSDATE
169: FROM hri_mb_cmnts_ct cmnts
170: WHERE cmnts.effective_start_date BETWEEN g_refresh_start_date AND g_refresh_end_date;
171: --
172: dbg(SQL%ROWCOUNT||' commitment records inserted into HRI_MD_CMNTS_ACTLS_CT');
173: --
174: COMMIT;
175: --
176: dbg('Exiting process');

Line 209: run_sql_stmt_noerr('ALTER TRIGGER HRI_MD_CMNTS_ACTLS_CT_WHO DISABLE');

205: set_parameters;
206: --
207: -- Disable the WHO trigger
208: --
209: run_sql_stmt_noerr('ALTER TRIGGER HRI_MD_CMNTS_ACTLS_CT_WHO DISABLE');
210: --
211: -- ---------------------------------------------------------------------------
212: -- Full Refresh Section
213: -- ---------------------------------------------------------------------------

Line 225: p_table_name => 'HRI_MD_CMNTS_ACTLS_CT',

221: -- Drop Indexes
222: --
223: hri_utl_ddl.log_and_drop_indexes(
224: p_application_short_name => 'HRI',
225: p_table_name => 'HRI_MD_CMNTS_ACTLS_CT',
226: p_table_owner => l_schema);
227: --
228: -- Truncate the table
229: --

Line 230: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_schema || '.HRI_MD_CMNTS_ACTLS_CT';

226: p_table_owner => l_schema);
227: --
228: -- Truncate the table
229: --
230: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_schema || '.HRI_MD_CMNTS_ACTLS_CT';
231: --
232: END IF;
233: --
234: END IF;

Line 269: p_table_name => 'HRI_MD_CMNTS_ACTLS_CT',

265: dbg('Full Refresh selected - Creating indexes');
266: --
267: hri_utl_ddl.recreate_indexes(
268: p_application_short_name => 'HRI',
269: p_table_name => 'HRI_MD_CMNTS_ACTLS_CT',
270: p_table_owner => l_schema);
271: --
272: -- Collect the statistics only when the process is NOT invoked by a concurrent manager
273: --

Line 277: fnd_stats.gather_table_stats(l_schema,'HRI_MD_CMNTS_ACTLS_CT');

273: --
274: IF fnd_global.conc_request_id is null THEN
275: --
276: dbg('Full Refresh selected - gathering stats');
277: fnd_stats.gather_table_stats(l_schema,'HRI_MD_CMNTS_ACTLS_CT');
278: --
279: END IF;
280: --
281: END IF;

Line 294: run_sql_stmt_noerr('ALTER TRIGGER HRI_MD_CMNTS_ACTLS_CT_WHO ENABLE');

290: --
291: -- Enable the WHO trigger on the fact table
292: --
293: dbg('Enabling the who trigger');
294: run_sql_stmt_noerr('ALTER TRIGGER HRI_MD_CMNTS_ACTLS_CT_WHO ENABLE');
295: --
296: hri_bpl_conc_log.log_process_end(
297: p_status => TRUE
298: ,p_period_from => TRUNC(g_refresh_start_date)