APPS.HRI_OPL_UTL_ABSNC_FACT dependencies on HRI_MB_UTL_ABSNC_CT

Line 66: p_process_table_name => 'HRI_MB_UTL_ABSNC_CT');

62:
63: g_dbi_collection_start_date :=
64: hri_oltp_conc_param.get_date_parameter_value
65: (p_parameter_name => 'FULL_REFRESH_FROM_DATE',
66: p_process_table_name => 'HRI_MB_UTL_ABSNC_CT');
67:
68: -- If called for the first time set the defaulted parameters
69: IF (p_mthd_stage_code = 'PRE_PROCESS') THEN
70:

Line 74: p_process_table_name => 'HRI_MB_UTL_ABSNC_CT');

70:
71: g_full_refresh :=
72: hri_oltp_conc_param.get_parameter_value
73: (p_parameter_name => 'FULL_REFRESH',
74: p_process_table_name => 'HRI_MB_UTL_ABSNC_CT');
75:
76: -- Log defaulted parameters so the slave processes pick up
77: hri_opl_multi_thread.update_parameters
78: (p_mthd_action_id => p_mthd_action_id,

Line 141: INSERT INTO hri_mb_utl_absnc_ct

137: -- Bulk insert rows if any exist
138: IF g_tab_index > 0 THEN
139:
140: FORALL i IN 1..g_tab_index
141: INSERT INTO hri_mb_utl_absnc_ct
142: (absence_sk_fk
143: ,effective_date
144: ,abs_drtn_days
145: ,abs_drtn_hrs

Line 384: DELETE FROM hri_mb_utl_absnc_ct fact

380:
381: BEGIN
382:
383: -- Delete old records
384: DELETE FROM hri_mb_utl_absnc_ct fact
385: WHERE fact.absence_sk_fk IN
386: (SELECT eq.absence_sk_fk
387: FROM hri_eq_utl_absnc_fact eq
388: WHERE eq.absence_sk_fk BETWEEN p_start_abs_id AND p_end_abs_id);

Line 495: run_sql_stmt_noerr('ALTER TRIGGER HRI_MB_UTL_ABSNC_CT_WHO DISABLE');

491: null;
492: END IF;
493:
494: -- Disable WHO trigger
495: run_sql_stmt_noerr('ALTER TRIGGER HRI_MB_UTL_ABSNC_CT_WHO DISABLE');
496:
497: -- ********************
498: -- Full Refresh Section
499: -- ********************

Line 504: l_sql_stmt := 'TRUNCATE TABLE ' || l_schema || '.HRI_MB_UTL_ABSNC_CT';

500: IF (g_full_refresh = 'Y' OR
501: g_mthd_action_array.foundation_hr_flag = 'Y') THEN
502:
503: -- Empty out absence fact table
504: l_sql_stmt := 'TRUNCATE TABLE ' || l_schema || '.HRI_MB_UTL_ABSNC_CT';
505: EXECUTE IMMEDIATE(l_sql_stmt);
506:
507: -- In shared HR mode do not return a SQL statement so that the
508: -- process_range and post_process will not be executed

Line 520: p_table_name => 'HRI_MB_UTL_ABSNC_CT',

516:
517: -- Drop indexes
518: hri_utl_ddl.log_and_drop_indexes
519: (p_application_short_name => 'HRI',
520: p_table_name => 'HRI_MB_UTL_ABSNC_CT',
521: p_table_owner => l_schema);
522:
523: -- Set the SQL statement for the entire range
524: p_sqlstr :=

Line 565: hri_bpl_conc_log.record_process_start('HRI_MB_UTL_ABSNC_CT');

561:
562: IF (p_mthd_action_id > -1) THEN
563:
564: -- Log process end
565: hri_bpl_conc_log.record_process_start('HRI_MB_UTL_ABSNC_CT');
566: hri_bpl_conc_log.log_process_end(
567: p_status => TRUE
568: ,p_period_from => TRUNC(g_refresh_start_date)
569: ,p_period_to => TRUNC(SYSDATE)

Line 575: run_sql_stmt_noerr('ALTER TRIGGER HRI_MB_UTL_ABSNC_CT_WHO ENABLE');

571:
572: END IF;
573:
574: -- Enable WHO trigger
575: run_sql_stmt_noerr('ALTER TRIGGER HRI_MB_UTL_ABSNC_CT_WHO ENABLE');
576:
577: -- Get HRI schema name - get_app_info populates l_schema
578: IF fnd_installation.get_app_info('HRI',l_dummy1, l_dummy2, l_schema) THEN
579: null;

Line 586: p_table_name => 'HRI_MB_UTL_ABSNC_CT',

582: -- Recreate indexes
583: IF (g_full_refresh = 'Y') THEN
584: hri_utl_ddl.recreate_indexes
585: (p_application_short_name => 'HRI',
586: p_table_name => 'HRI_MB_UTL_ABSNC_CT',
587: p_table_owner => l_schema);
588: END IF;
589:
590: -- Empty out absence dimension event queue

Line 620: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_dummy || '.hri_mb_utl_absnc_ct';

616: g_end_of_time := hr_general.end_of_time;
617: l_dummy := 'HRI';
618:
619: -- Truncate table
620: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_dummy || '.hri_mb_utl_absnc_ct';
621:
622: -- Process range
623: IF (p_full_refresh_flag = 'Y') THEN
624: process_range_full(0, l_end_psn_id);