APPS.HRI_OPL_SUP_ABSNC dependencies on HRI_MDP_SUP_ABSNC_OCC_CT

Line 70: p_process_table_name => 'HRI_MDP_SUP_ABSNC_OCC_CT');

66:
67: l_dbi_collection_start_date :=
68: hri_oltp_conc_param.get_date_parameter_value
69: (p_parameter_name => 'FULL_REFRESH_FROM_DATE',
70: p_process_table_name => 'HRI_MDP_SUP_ABSNC_OCC_CT');
71:
72: -- If called for the first time set the defaulted parameters
73: IF (p_mthd_stage_code = 'PRE_PROCESS') THEN
74:

Line 78: p_process_table_name => 'HRI_MDP_SUP_ABSNC_OCC_CT');

74:
75: g_full_refresh :=
76: hri_oltp_conc_param.get_parameter_value
77: (p_parameter_name => 'FULL_REFRESH',
78: p_process_table_name => 'HRI_MDP_SUP_ABSNC_OCC_CT');
79:
80: -- Log defaulted parameters so the slave processes pick up
81: hri_opl_multi_thread.update_parameters
82: (p_mthd_action_id => p_mthd_action_id,

Line 152: INSERT INTO hri_mdp_sup_absnc_occ_ct

148: -- Bulk insert rows if any exist
149: IF (g_tab_index > 0) THEN
150:
151: FORALL i IN 1..g_tab_index
152: INSERT INTO hri_mdp_sup_absnc_occ_ct
153: (supervisor_person_id
154: ,effective_date
155: ,absence_sk_fk
156: ,direct_ind

Line 506: DELETE FROM hri_mdp_sup_absnc_occ_ct tab

502:
503: BEGIN
504:
505: -- Delete changed rows
506: DELETE FROM hri_mdp_sup_absnc_occ_ct tab
507: WHERE tab.absence_sk_fk IN
508: (SELECT eq.source_id
509: FROM hri_eq_sup_absnc eq
510: WHERE eq.source_id BETWEEN p_start_abs_id AND p_end_abs_id

Line 614: run_sql_stmt_noerr('ALTER TRIGGER HRI_MDP_SUP_ABSNC_OCC_CT_WHO DISABLE');

610: null;
611: END IF;
612:
613: -- Disable WHO trigger
614: run_sql_stmt_noerr('ALTER TRIGGER HRI_MDP_SUP_ABSNC_OCC_CT_WHO DISABLE');
615:
616: -- ********************
617: -- Full Refresh Section
618: -- ********************

Line 623: l_sql_stmt := 'TRUNCATE TABLE ' || l_schema || '.HRI_MDP_SUP_ABSNC_OCC_CT';

619: IF (g_full_refresh = 'Y' OR
620: g_mthd_action_array.foundation_hr_flag = 'Y') THEN
621:
622: -- Empty out absence dimension table
623: l_sql_stmt := 'TRUNCATE TABLE ' || l_schema || '.HRI_MDP_SUP_ABSNC_OCC_CT';
624: EXECUTE IMMEDIATE(l_sql_stmt);
625:
626: -- In shared HR mode do not return a SQL statement so that the
627: -- process_range and post_process will not be executed

Line 639: p_table_name => 'HRI_MDP_SUP_ABSNC_OCC_CT',

635:
636: -- Drop all the indexes on the table
637: hri_utl_ddl.log_and_drop_indexes
638: (p_application_short_name => 'HRI',
639: p_table_name => 'HRI_MDP_SUP_ABSNC_OCC_CT',
640: p_table_owner => l_schema);
641:
642: -- Set the SQL statement for the entire range
643: p_sqlstr :=

Line 688: hri_bpl_conc_log.record_process_start('HRI_MDP_SUP_ABSNC_OCC_CT');

684:
685: IF (p_mthd_action_id > -1) THEN
686:
687: -- Log process end
688: hri_bpl_conc_log.record_process_start('HRI_MDP_SUP_ABSNC_OCC_CT');
689: hri_bpl_conc_log.log_process_end(
690: p_status => TRUE
691: ,p_period_from => TRUNC(g_refresh_start_date)
692: ,p_period_to => TRUNC(SYSDATE)

Line 698: run_sql_stmt_noerr('ALTER TRIGGER HRI_MDP_SUP_ABSNC_OCC_CT_WHO ENABLE');

694:
695: END IF;
696:
697: -- Enable WHO trigger
698: run_sql_stmt_noerr('ALTER TRIGGER HRI_MDP_SUP_ABSNC_OCC_CT_WHO ENABLE');
699:
700: -- Get HRI schema name - get_app_info populates l_schema
701: IF fnd_installation.get_app_info('HRI',l_dummy1, l_dummy2, l_schema) THEN
702: null;

Line 709: p_table_name => 'HRI_MDP_SUP_ABSNC_OCC_CT',

705: -- Recreate indexes
706: IF (g_full_refresh = 'Y') THEN
707: hri_utl_ddl.recreate_indexes
708: (p_application_short_name => 'HRI',
709: p_table_name => 'HRI_MDP_SUP_ABSNC_OCC_CT',
710: p_table_owner => l_schema);
711: END IF;
712:
713: -- Empty out absence summary event queue

Line 742: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_dummy || '.hri_mdp_sup_absnc_occ_ct';

738: g_end_of_time := hr_general.end_of_time;
739: l_dummy := 'HRI';
740:
741: -- Truncate table
742: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_dummy || '.hri_mdp_sup_absnc_occ_ct';
743:
744: -- Process range
745: IF (p_full_refresh_flag = 'Y') THEN
746: process_range_full(0, l_end_psn_id);