eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HRI_OPL_EVENT_CAPTURE dependencies on HRI_EQ_ASGN_EVNTS

Line 959: purge_queue('HRI_EQ_ASGN_EVNTS');

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');
962: --
963: -- Record the full refresh process has ended. This is the main purpose of

Line 1330: -- If there is already a record in hri_eq_asgn_evnts for the assignment_id

1326: --
1327: l_action_taken := 'INSERTED';
1328: --
1329: --
1330: -- If there is already a record in hri_eq_asgn_evnts for the assignment_id
1331: -- but it is for an event that occurred later or at the same time as the
1332: -- new event we have found (p_change_date), then update the queue with the
1333: -- earlier date.
1334: --

Line 1463: -- If there is already a record in hri_eq_asgn_evnts for the assignment_id

1459: --
1460: l_action_taken := 'INSERTED';
1461: --
1462: --
1463: -- If there is already a record in hri_eq_asgn_evnts for the assignment_id
1464: -- but it is for an event that occurred later or at the same time as the
1465: -- new event we have found (p_change_date), then update the queue with the
1466: -- earlier date.
1467: --

Line 1942: FROM hri_eq_asgn_evnts

1938: -- + Do nothing.
1939: --
1940: CURSOR c_get_queued_event(cp_assignment_id IN NUMBER) IS
1941: SELECT erlst_evnt_effective_date
1942: FROM hri_eq_asgn_evnts
1943: WHERE assignment_id = cp_assignment_id;
1944: --
1945: l_erlst_evnt_effective_date DATE; -- Stores the earliest event data for
1946: -- the assignment currently stored

Line 1972: INSERT INTO hri_eq_asgn_evnts

1968: THEN
1969: --
1970: dbg('No record for assignment '||p_assignment_id||' exists, so INSERT.');
1971: --
1972: INSERT INTO hri_eq_asgn_evnts
1973: (
1974: assignment_id
1975: ,erlst_evnt_effective_date
1976: )

Line 1986: -- If there is already a record in hri_eq_asgn_evnts for the assignment_id

1982: --
1983: l_action_taken := 'INSERTED';
1984: --
1985: --
1986: -- If there is already a record in hri_eq_asgn_evnts for the assignment_id
1987: -- but it is for an event that occurred later or at the same time as the
1988: -- new event we have found (p_change_date), then update the queue with the
1989: -- earlier date.
1990: --

Line 1996: UPDATE hri_eq_asgn_evnts

1992: THEN
1993: --
1994: dbg('Record is earlier than one in queue currently for '||p_assignment_id||', so UPDATE.');
1995: --
1996: UPDATE hri_eq_asgn_evnts
1997: SET erlst_evnt_effective_date = p_change_date
1998: WHERE assignment_id = p_assignment_id;
1999: --
2000: l_action_taken := 'UPDATED';

Line 2019: ,p_event_queue_table => 'HRI_EQ_ASGN_EVNTS'

2015: Update_archive_record
2016: (
2017: p_assignment_id => p_assignment_id
2018: ,p_change_date => p_change_date
2019: ,p_event_queue_table => 'HRI_EQ_ASGN_EVNTS'
2020: ,p_action_taken => l_action_taken
2021: ,p_capture_from_date => p_start_date
2022: );
2023: --