APPS.HRI_OPL_CMNTS_ACTLS_ORGMGR dependencies on HRI_MDP_CMNTS_ACTLS_ORGMGR_CT

Line 151: INSERT INTO HRI_MDP_CMNTS_ACTLS_ORGMGR_CT (

147: --
148: l_current_time := SYSDATE;
149: l_user_id := fnd_global.user_id;
150: --
151: INSERT INTO HRI_MDP_CMNTS_ACTLS_ORGMGR_CT (
152: orgmgr_id
153: ,effective_start_date
154: ,effective_end_date
155: ,assignment_id

Line 210: dbg(SQL%ROWCOUNT||' records inserted into HRI_MDP_CMNTS_ACTLS_ORGMGR_CT');

206: ,hri_cs_suph_orgmgr_ct orgmgr
207: WHERE cmntactl.organization_id = orgmgr.sub_organization_id
208: AND orgmgr.sup_person_id = p_person_id;
209: --
210: dbg(SQL%ROWCOUNT||' records inserted into HRI_MDP_CMNTS_ACTLS_ORGMGR_CT');
211: dbg('Exiting process');
212: COMMIT;
213: --
214: EXCEPTION

Line 336: -- run_sql_stmt_noerr('ALTER TRIGGER HRI_MDP_CMNTS_ACTLS_ORGMGR_CT_WHO DISABLE');

332: set_parameters( p_mthd_action_id => p_mthd_action_id );
333: --
334: -- Disable the WHO trigger
335: --
336: -- run_sql_stmt_noerr('ALTER TRIGGER HRI_MDP_CMNTS_ACTLS_ORGMGR_CT_WHO DISABLE');
337: --
338: -- ---------------------------------------------------------------------------
339: -- Full Refresh Section
340: -- ---------------------------------------------------------------------------

Line 352: p_table_name => 'HRI_MDP_CMNTS_ACTLS_ORGMGR_CT',

348: -- Drop Indexes
349: --
350: hri_utl_ddl.log_and_drop_indexes(
351: p_application_short_name => 'HRI',
352: p_table_name => 'HRI_MDP_CMNTS_ACTLS_ORGMGR_CT',
353: p_table_owner => l_schema);
354: --
355: -- Truncate the table
356: --

Line 357: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_schema || '.HRI_MDP_CMNTS_ACTLS_ORGMGR_CT';

353: p_table_owner => l_schema);
354: --
355: -- Truncate the table
356: --
357: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_schema || '.HRI_MDP_CMNTS_ACTLS_ORGMGR_CT';
358: --
359: -- Select all organization managers in the collection range.
360: --
361: p_sqlstr :=

Line 478: p_table_name => 'HRI_MDP_CMNTS_ACTLS_ORGMGR_CT',

474: dbg('Full Refresh selected - Creating indexes');
475: --
476: hri_utl_ddl.recreate_indexes(
477: p_application_short_name => 'HRI',
478: p_table_name => 'HRI_MDP_CMNTS_ACTLS_ORGMGR_CT',
479: p_table_owner => l_schema);
480: --
481: -- Collect the statistics only when the process is NOT invoked by a concurrent manager
482: --

Line 486: fnd_stats.gather_table_stats(l_schema,'HRI_MDP_CMNTS_ACTLS_ORGMGR_CT');

482: --
483: IF fnd_global.conc_request_id is null THEN
484: --
485: dbg('Full Refresh selected - gathering stats');
486: fnd_stats.gather_table_stats(l_schema,'HRI_MDP_CMNTS_ACTLS_ORGMGR_CT');
487: --
488: END IF;
489: --
490: END IF;

Line 503: -- run_sql_stmt_noerr('ALTER TRIGGER HRI_MDP_CMNTS_ACTLS_ORGMGR_CT_WHO ENABLE');

499: --
500: -- Enable the WHO trigger on the fact table
501: --
502: dbg('Enabling the who trigger');
503: -- run_sql_stmt_noerr('ALTER TRIGGER HRI_MDP_CMNTS_ACTLS_ORGMGR_CT_WHO ENABLE');
504: --
505: hri_bpl_conc_log.log_process_end(
506: p_status => TRUE
507: ,p_period_from => TRUNC(g_refresh_start_date)