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 956: purge_queue('HRI_EQ_ASGN_EVNTS');

952: purge_queue('HRI_EQ_SPRVSR_HRCHY_CHGS');
953: -- Purge supervisor history queue
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

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

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

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

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

Line 1939: FROM hri_eq_asgn_evnts

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

Line 1969: INSERT INTO hri_eq_asgn_evnts

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

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

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

Line 1993: UPDATE hri_eq_asgn_evnts

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

Line 2016: ,p_event_queue_table => 'HRI_EQ_ASGN_EVNTS'

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