APPS.HRI_OPL_EVENT_CAPTURE dependencies on HRI_EQ_UTL_ABSNC_DIM

Line 961: purge_queue('HRI_EQ_UTL_ABSNC_DIM');

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

Line 2061: FROM hri_eq_utl_absnc_dim

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

Line 2114: INSERT INTO hri_eq_utl_absnc_dim

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

Line 2151: ,p_event_queue_table => 'HRI_EQ_UTL_ABSNC_DIM '

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