APPS.HRI_OPL_REC_CAND_PIPLN dependencies on HRI_MB_REC_CAND_PIPLN_CT

Line 433: p_process_table_name => 'HRI_MB_REC_CAND_PIPLN_CT');

429:
430: l_dbi_collection_start_date :=
431: hri_oltp_conc_param.get_date_parameter_value
432: (p_parameter_name => 'FULL_REFRESH_FROM_DATE',
433: p_process_table_name => 'HRI_MB_REC_CAND_PIPLN_CT');
434:
435: -- If called for the first time set the defaulted parameters
436: IF (p_mthd_stage_code = 'PRE_PROCESS') THEN
437:

Line 441: p_process_table_name => 'HRI_MB_REC_CAND_PIPLN_CT');

437:
438: g_full_refresh :=
439: hri_oltp_conc_param.get_parameter_value
440: (p_parameter_name => 'FULL_REFRESH',
441: p_process_table_name => 'HRI_MB_REC_CAND_PIPLN_CT');
442:
443: -- Log defaulted parameters so the slave processes pick up
444: hri_opl_multi_thread.update_parameters
445: (p_mthd_action_id => p_mthd_action_id,

Line 486: INSERT INTO hri_mb_rec_cand_pipln_ct

482:
483: IF g_no_rows > 0 THEN
484:
485: FORALL i IN 1..g_no_rows
486: INSERT INTO hri_mb_rec_cand_pipln_ct
487: (time_day_evt_fk,
488: time_day_evt_end_fk,
489: time_day_stg_evt_eff_end_fk,
490: per_person_cand_fk,

Line 2597: INSERT /*+ APPEND */ INTO hri_mb_rec_cand_pipln_ct

2593: BEGIN
2594:
2595: EXECUTE IMMEDIATE 'ALTER SESSION ENABLE PARALLEL DML';
2596:
2597: INSERT /*+ APPEND */ INTO hri_mb_rec_cand_pipln_ct
2598: (time_day_evt_fk,
2599: time_day_evt_end_fk,
2600: time_day_stg_evt_eff_end_fk,
2601: per_person_cand_fk,

Line 2796: l_sql_stmt := 'TRUNCATE TABLE ' || l_schema || '.HRI_MB_REC_CAND_PIPLN_CT';

2792: IF (g_full_refresh = 'Y' OR
2793: g_mthd_action_array.foundation_hr_flag = 'Y') THEN
2794:
2795: -- Empty out absence dimension table
2796: l_sql_stmt := 'TRUNCATE TABLE ' || l_schema || '.HRI_MB_REC_CAND_PIPLN_CT';
2797: EXECUTE IMMEDIATE(l_sql_stmt);
2798:
2799: -- In shared HR mode do not return a SQL statement so that the
2800: -- process_range and post_process will not be executed

Line 2810: run_sql_stmt_noerr('ALTER TRIGGER HRI_MB_REC_CAND_PIPLN_CT_WHO DISABLE');

2806:
2807: ELSE
2808:
2809: -- Disable WHO trigger
2810: run_sql_stmt_noerr('ALTER TRIGGER HRI_MB_REC_CAND_PIPLN_CT_WHO DISABLE');
2811:
2812: -- Drop all the indexes on the table
2813: hri_utl_ddl.log_and_drop_indexes
2814: (p_application_short_name => 'HRI',

Line 2815: p_table_name => 'HRI_MB_REC_CAND_PIPLN_CT',

2811:
2812: -- Drop all the indexes on the table
2813: hri_utl_ddl.log_and_drop_indexes
2814: (p_application_short_name => 'HRI',
2815: p_table_name => 'HRI_MB_REC_CAND_PIPLN_CT',
2816: p_table_owner => l_schema);
2817:
2818: -- Set the SQL statement for the entire range
2819: p_sqlstr :=

Line 2865: hri_bpl_conc_log.record_process_start('HRI_MB_REC_CAND_PIPLN_CT');

2861: (p_mthd_action_id => p_mthd_action_id,
2862: p_mthd_stage_code => 'POST_PROCESS');
2863:
2864: -- Log process end
2865: hri_bpl_conc_log.record_process_start('HRI_MB_REC_CAND_PIPLN_CT');
2866: hri_bpl_conc_log.log_process_end(
2867: p_status => TRUE
2868: ,p_period_from => TRUNC(g_refresh_start_date)
2869: ,p_period_to => TRUNC(SYSDATE)

Line 2886: run_sql_stmt_noerr('ALTER TRIGGER HRI_MB_REC_CAND_PIPLN_CT_WHO ENABLE');

2882: -- Add in vacancy records
2883: process_vacancies;
2884:
2885: -- Enable WHO trigger
2886: run_sql_stmt_noerr('ALTER TRIGGER HRI_MB_REC_CAND_PIPLN_CT_WHO ENABLE');
2887:
2888: hri_utl_ddl.recreate_indexes
2889: (p_application_short_name => 'HRI',
2890: p_table_name => 'HRI_MB_REC_CAND_PIPLN_CT',

Line 2890: p_table_name => 'HRI_MB_REC_CAND_PIPLN_CT',

2886: run_sql_stmt_noerr('ALTER TRIGGER HRI_MB_REC_CAND_PIPLN_CT_WHO ENABLE');
2887:
2888: hri_utl_ddl.recreate_indexes
2889: (p_application_short_name => 'HRI',
2890: p_table_name => 'HRI_MB_REC_CAND_PIPLN_CT',
2891: p_table_owner => l_schema);
2892:
2893: END IF;
2894:

Line 2968: DELETE FROM hri_mb_rec_cand_pipln_ct

2964: SELECT DISTINCT person_id INTO l_psn_id
2965: FROM per_all_assignments_f
2966: WHERE assignment_id = p_asg_id;
2967:
2968: DELETE FROM hri_mb_rec_cand_pipln_ct
2969: WHERE adt_assignment_id = p_asg_id;
2970:
2971: process_assignment(p_asg_id, l_psn_id);
2972: