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_ARCHIVE_EVENTS

Line 953: truncate_table('HRI_ARCHIVE_EVENTS');

949: --
950: -- Empty the Event Queues
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');

Line 1203: -- Updates hri_archive_events with details of the action taken for

1199: -- ----------------------------------------------------------------------------
1200: -- Update_archive_record
1201: -- Log details for the identified event
1202: -- ============================================================================
1203: -- Updates hri_archive_events with details of the action taken for
1204: -- the earliest event found for an assignent event.
1205: --
1206: PROCEDURE Update_archive_record
1207: (p_assignment_id IN NUMBER

Line 1221: INSERT INTO hri_archive_events

1217: IS
1218: --
1219: BEGIN
1220: --
1221: INSERT INTO hri_archive_events
1222: (
1223: assignment_id
1224: ,event_queue_table
1225: ,action_taken

Line 1254: -- The procedure will also insert arecord of the event in hri_archive_events

1250: -- exists, and has a later date than the new event you have found.
1251: -- + Do nothing to the event queue as there is already an early change record
1252: -- for the assignment.
1253: --
1254: -- The procedure will also insert arecord of the event in hri_archive_events
1255: -- for audit purposes to record the event capture and what was done to the
1256: -- event queue as a result of the event capture.
1257: --
1258: PROCEDURE Update_Sprvsr_Hstry_Evnt_Q

Line 1285: -- into hri_archive_events to show what action

1281: -- in the event queue.
1282: --
1283: l_action_taken VARCHAR2(30); -- used to store what we do with the passed
1284: -- in event. This is used when inserting
1285: -- into hri_archive_events to show what action
1286: -- we took with the captured event.
1287: --
1288: BEGIN
1289: --

Line 1354: -- Update the hri_archive_events table with details of what we have

1350: l_action_taken := 'NONE';
1351: --
1352: END IF;
1353: --
1354: -- Update the hri_archive_events table with details of what we have
1355: -- done for the identified event.
1356: --
1357: IF g_enable_archive_flag = 'Y' THEN
1358: --

Line 1387: -- The procedure will also insert arecord of the event in hri_archive_events

1383: -- exists, and has a later date than the new event you have found.
1384: -- + Do nothing to the event queue as there is already an early change record
1385: -- for the assignment.
1386: --
1387: -- The procedure will also insert arecord of the event in hri_archive_events
1388: -- for audit purposes to record the event capture and what was done to the
1389: -- event queue as a result of the event capture.
1390: --
1391: PROCEDURE Update_Sprvsr_Hrchy_Evnt_Q

Line 1418: -- into hri_archive_events to show what action

1414: -- in the event queue.
1415: --
1416: l_action_taken VARCHAR2(30); -- used to store what we do with the passed
1417: -- in event. This is used when inserting
1418: -- into hri_archive_events to show what action
1419: -- we took with the captured event.
1420: --
1421: BEGIN
1422: --

Line 1489: -- Update the hri_archive_events table with details of what we have

1485: l_action_taken := 'NONE';
1486: --
1487: END IF;
1488: --
1489: -- Update the hri_archive_events table with details of what we have
1490: -- done for the identified event.
1491: --
1492: IF g_enable_archive_flag = 'Y' THEN
1493: --

Line 1920: -- The procedure will also insert arecord of the event in hri_archive_events

1916: -- exists, and has a later date than the new event you have found.
1917: -- + Do nothing to the event queue as there is already an early change record
1918: -- for the assignment.
1919: --
1920: -- The procedure will also insert arecord of the event in hri_archive_events
1921: -- for audit purposes to record the event capture and what was done to the
1922: -- event queue as a result of the event capture.
1923: --
1924: PROCEDURE Update_Asgn_Evnt_Fct_Evnt_Q

Line 1951: -- into hri_archive_events to show what action

1947: -- in the wvwnt queue.
1948: --
1949: l_action_taken VARCHAR2(30); -- used to store what we do with the passed
1950: -- in event. This is used when inserting
1951: -- into hri_archive_events to show what action
1952: -- we took with the captured event.
1953: --
1954: BEGIN
1955: --

Line 2010: -- Update the hri_archive_events table with details of what we have

2006: l_action_taken := 'NONE';
2007: --
2008: END IF;
2009: --
2010: -- Update the hri_archive_events table with details of what we have
2011: -- done for the identified event.
2012: --
2013: IF g_enable_archive_flag = 'Y' THEN
2014: --

Line 2042: -- The procedure will also insert arecord of the event in hri_archive_events

2038: -- exists for the assignment).
2039: -- + Do nothing to the event queue as there is already a change record
2040: -- for the assignment.
2041: --
2042: -- The procedure will also insert arecord of the event in hri_archive_events
2043: -- for audit purposes to record the event capture and what was done to the
2044: -- event queue as a result of the event capture.
2045: --
2046: PROCEDURE Update_Absence_Dim_Evnt_Q

Line 2140: -- Update the hri_archive_events table with details of what we have

2136: -- Close Curosr c_get_queued_event
2137: --
2138: CLOSE c_get_queued_event;
2139: --
2140: -- Update the hri_archive_events table with details of what we have
2141: -- done for the identified event.
2142: --
2143: IF g_enable_archive_flag = 'Y' THEN
2144: --