APPS.HRI_OPL_EVENT_CAPTURE dependencies on HRI_EQ_SPRVSR_HSTRY_CHGS

Line 957: purge_queue('HRI_EQ_SPRVSR_HSTRY_CHGS');

953: truncate_table('HRI_ARCHIVE_EVENTS');
954: -- Purge supervisor hierarchy queue
955: purge_queue('HRI_EQ_SPRVSR_HRCHY_CHGS');
956: -- Purge supervisor history queue
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');

Line 1276: FROM hri_eq_sprvsr_hstry_chgs

1272: -- + Do nothing.
1273: --
1274: CURSOR c_get_queued_event(cp_assignment_id IN NUMBER) IS
1275: SELECT erlst_evnt_effective_date
1276: FROM hri_eq_sprvsr_hstry_chgs
1277: WHERE assignment_id = cp_assignment_id;
1278: --
1279: l_erlst_evnt_effective_date DATE; -- Stores the earliest event data for
1280: -- the assignment currently stored

Line 1316: INSERT INTO hri_eq_sprvsr_hstry_chgs

1312: THEN
1313: --
1314: dbg('No record for assignment '||p_assignment_id||' exists, so INSERT.');
1315: --
1316: INSERT INTO hri_eq_sprvsr_hstry_chgs
1317: (
1318: assignment_id
1319: ,erlst_evnt_effective_date
1320: )

Line 1340: UPDATE hri_eq_sprvsr_hstry_chgs

1336: THEN
1337: --
1338: dbg('Record is earlier than one in queue currently for '||p_assignment_id||', so UPDATE.');
1339: --
1340: UPDATE hri_eq_sprvsr_hstry_chgs
1341: SET erlst_evnt_effective_date = p_change_date
1342: WHERE assignment_id = p_assignment_id;
1343: --
1344: l_action_taken := 'UPDATED';

Line 1363: ,p_event_queue_table => 'HRI_EQ_SPRVSR_HSTRY_CHGS'

1359: Update_archive_record
1360: (
1361: p_assignment_id => p_assignment_id
1362: ,p_change_date => p_change_date
1363: ,p_event_queue_table => 'HRI_EQ_SPRVSR_HSTRY_CHGS'
1364: ,p_action_taken => l_action_taken
1365: ,p_capture_from_date => p_start_date
1366: );
1367: --