APPS.HRI_OPL_WRKFC_ORGMGR dependencies on HRI_MAP_WRKFC_ORGMGR_CT

Line 144: INSERT INTO HRI_MAP_WRKFC_ORGMGR_CT (

140: --
141: l_current_time := SYSDATE;
142: l_user_id := fnd_global.user_id;
143: --
144: INSERT INTO HRI_MAP_WRKFC_ORGMGR_CT (
145: --
146: -- Organization Manager Id
147: --
148: orgmgr_id

Line 263: dbg(SQL%ROWCOUNT||' records inserted into HRI_MAP_WRKFC_ORGMGR_CT');

259: ,dlt.job_id
260: ,dlt.position_id
261: ,dlt.grade_id;
262: --
263: dbg(SQL%ROWCOUNT||' records inserted into HRI_MAP_WRKFC_ORGMGR_CT');
264: dbg('Exiting post_headcount_actuals');
265: --
266:
267: EXCEPTION

Line 389: run_sql_stmt_noerr('ALTER TRIGGER HRI_MAP_WRKFC_ORGMGR_CT_WHO DISABLE');

385: set_parameters( p_mthd_action_id => p_mthd_action_id );
386: --
387: -- Disable the WHO trigger
388: --
389: run_sql_stmt_noerr('ALTER TRIGGER HRI_MAP_WRKFC_ORGMGR_CT_WHO DISABLE');
390: --
391: -- ---------------------------------------------------------------------------
392: -- Full Refresh Section
393: -- ---------------------------------------------------------------------------

Line 405: p_table_name => 'HRI_MAP_WRKFC_ORGMGR_CT',

401: -- Drop Indexes
402: --
403: hri_utl_ddl.log_and_drop_indexes(
404: p_application_short_name => 'HRI',
405: p_table_name => 'HRI_MAP_WRKFC_ORGMGR_CT',
406: p_table_owner => l_schema);
407: --
408: -- Truncate the table
409: --

Line 410: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_schema || '.HRI_MAP_WRKFC_ORGMGR_CT';

406: p_table_owner => l_schema);
407: --
408: -- Truncate the table
409: --
410: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_schema || '.HRI_MAP_WRKFC_ORGMGR_CT';
411: --
412: -- Select all people with employee assignments in the collection range.
413: -- The bind variable must be present for this sql to work when called
414: -- by PYUGEN, else itwill give error.

Line 533: p_table_name => 'HRI_MAP_WRKFC_ORGMGR_CT',

529: dbg('Full Refresh selected - Creating indexes');
530: --
531: hri_utl_ddl.recreate_indexes(
532: p_application_short_name => 'HRI',
533: p_table_name => 'HRI_MAP_WRKFC_ORGMGR_CT',
534: p_table_owner => l_schema);
535: --
536: -- Collect the statistics only when the process is NOT invoked by a concurrent manager
537: --

Line 541: fnd_stats.gather_table_stats(l_schema,'HRI_MAP_WRKFC_ORGMGR_CT');

537: --
538: IF fnd_global.conc_request_id is null THEN
539: --
540: dbg('Full Refresh selected - gathering stats');
541: fnd_stats.gather_table_stats(l_schema,'HRI_MAP_WRKFC_ORGMGR_CT');
542: --
543: END IF;
544: --
545: END IF;

Line 558: run_sql_stmt_noerr('ALTER TRIGGER HRI_MAP_WRKFC_ORGMGR_CT_WHO ENABLE');

554: --
555: -- Enable the WHO trigger on the fact table
556: --
557: dbg('Enabling the who trigger');
558: run_sql_stmt_noerr('ALTER TRIGGER HRI_MAP_WRKFC_ORGMGR_CT_WHO ENABLE');
559: --
560: hri_bpl_conc_log.log_process_end(
561: p_status => TRUE
562: ,p_period_from => TRUNC(g_refresh_start_date)