APPS.HRI_OPL_EVENT_CAPTURE dependencies on HRI_EQ_UTL_ABSNC_DIM

Line 958: purge_queue('HRI_EQ_UTL_ABSNC_DIM');

954: purge_queue('HRI_EQ_SPRVSR_HSTRY_CHGS');
955: -- Purge assignment events queue
956: purge_queue('HRI_EQ_ASGN_EVNTS');
957: -- Purge absence events queue
958: purge_queue('HRI_EQ_UTL_ABSNC_DIM');
959: --
960: -- Record the full refresh process has ended. This is the main purpose of
961: -- full refresh, as these dates will then be used to drive the dates that
962: -- the events capture process is then run for.

Line 2058: FROM hri_eq_utl_absnc_dim

2054: -- Identify if an event is already queued for the absence_attendance_id
2055: --
2056: CURSOR c_get_queued_event(cp_absence_attendance_id IN NUMBER) IS
2057: SELECT 'X' h_dummy
2058: FROM hri_eq_utl_absnc_dim
2059: WHERE absence_attendance_id = cp_absence_attendance_id;
2060: --
2061: -- Stores the previous absence attendance id being processed.
2062: --

Line 2111: INSERT INTO hri_eq_utl_absnc_dim

2107: THEN
2108: --
2109: dbg('No record for assignment '||p_assignment_id||' exists, so INSERT.');
2110: --
2111: INSERT INTO hri_eq_utl_absnc_dim
2112: (
2113: absence_attendance_id
2114: )
2115: VALUES

Line 2148: ,p_event_queue_table => 'HRI_EQ_UTL_ABSNC_DIM '

2144: Update_archive_record
2145: (
2146: p_assignment_id => p_sub_evt_grp_tbl(i).surrogate_key
2147: ,p_change_date => NULL
2148: ,p_event_queue_table => 'HRI_EQ_UTL_ABSNC_DIM '
2149: ,p_action_taken => l_action_taken
2150: ,p_capture_from_date => p_start_date
2151: );
2152: --