APPS.HRI_OPL_EVENT_CAPTURE dependencies on HRI_EQ_SPRVSR_HRCHY_CHGS

Line 955: purge_queue('HRI_EQ_SPRVSR_HRCHY_CHGS');

951: --
952: -- Truncate archive table
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');

Line 1409: FROM hri_eq_sprvsr_hrchy_chgs

1405: -- + Do nothing.
1406: --
1407: CURSOR c_get_queued_event(cp_assignment_id IN NUMBER) IS
1408: SELECT erlst_evnt_effective_date
1409: FROM hri_eq_sprvsr_hrchy_chgs
1410: WHERE assignment_id = cp_assignment_id;
1411: --
1412: l_erlst_evnt_effective_date DATE; -- Stores the earliest event data for
1413: -- the assignment currently stored

Line 1449: INSERT INTO hri_eq_sprvsr_hrchy_chgs

1445: THEN
1446: --
1447: dbg('No record for assignment '||p_assignment_id||' exists, so INSERT.');
1448: --
1449: INSERT INTO hri_eq_sprvsr_hrchy_chgs
1450: (
1451: assignment_id
1452: ,erlst_evnt_effective_date
1453: )

Line 1474: UPDATE hri_eq_sprvsr_hrchy_chgs

1470: --
1471: dbg('Record is earlier than one in queue currently for '
1472: ||p_assignment_id||', so UPDATE.');
1473: --
1474: UPDATE hri_eq_sprvsr_hrchy_chgs
1475: SET erlst_evnt_effective_date = p_change_date
1476: WHERE assignment_id = p_assignment_id;
1477: --
1478: l_action_taken := 'UPDATED';

Line 1498: ,p_event_queue_table => 'HRI_EQ_SPRVSR_HRCHY_CHGS'

1494: Update_archive_record
1495: (
1496: p_assignment_id => p_assignment_id
1497: ,p_change_date => p_change_date
1498: ,p_event_queue_table => 'HRI_EQ_SPRVSR_HRCHY_CHGS'
1499: ,p_action_taken => l_action_taken
1500: ,p_capture_from_date => p_start_date
1501: );
1502: --