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.PAY_INTERPRETER_PKG dependencies on HR_API

Line 2112: hr_api.g_sot,

2108: NULL,
2109: NULL,
2110: NULL,
2111: l_internal_mode,
2112: hr_api.g_sot,
2113: hr_api.g_eot,
2114: sysdate,
2115: 'N',
2116: null,

Line 2113: hr_api.g_eot,

2109: NULL,
2110: NULL,
2111: l_internal_mode,
2112: hr_api.g_sot,
2113: hr_api.g_eot,
2114: sysdate,
2115: 'N',
2116: null,
2117: t_detailed_output,

Line 2192: hr_api.g_sot,

2188: NULL,
2189: NULL,
2190: NULL,
2191: 'PRORATION',
2192: hr_api.g_sot,
2193: hr_api.g_eot,
2194: sysdate,
2195: 'Y',
2196: null,

Line 2193: hr_api.g_eot,

2189: NULL,
2190: NULL,
2191: 'PRORATION',
2192: hr_api.g_sot,
2193: hr_api.g_eot,
2194: sysdate,
2195: 'Y',
2196: null,
2197: t_detailed_output,

Line 2233: hr_api.g_sot,

2229: p_mode,
2230: p_process,
2231: p_event_group_id,
2232: 'ENTRY_RETROSTATUS',
2233: hr_api.g_sot,
2234: hr_api.g_eot,
2235: sysdate,
2236: 'Y',
2237: null,

Line 2234: hr_api.g_eot,

2230: p_process,
2231: p_event_group_id,
2232: 'ENTRY_RETROSTATUS',
2233: hr_api.g_sot,
2234: hr_api.g_eot,
2235: sysdate,
2236: 'Y',
2237: null,
2238: t_detailed_output,

Line 2275: hr_api.g_sot,

2271: p_mode,
2272: p_process,
2273: p_event_group_id,
2274: 'ENTRY_RETROSTATUS',
2275: hr_api.g_sot,
2276: hr_api.g_eot,
2277: sysdate,
2278: 'Y',
2279: null,

Line 2276: hr_api.g_eot,

2272: p_process,
2273: p_event_group_id,
2274: 'ENTRY_RETROSTATUS',
2275: hr_api.g_sot,
2276: hr_api.g_eot,
2277: sysdate,
2278: 'Y',
2279: null,
2280: t_detailed_output,

Line 3697: l_date_dummy date := hr_api.g_eot;

3693:
3694: l_search varchar2(30) := p_dtevent_rec.update_type;
3695: l_statement varchar2(800);
3696: l_dummy number := null;
3697: l_date_dummy date := hr_api.g_eot;
3698:
3699: l_proc VARCHAR2(80) := g_pkg||'.extra_tests_dbt_u_e';
3700:
3701: BEGIN

Line 3941: if (p_pro_evt_rec.event_type = hr_api.g_delete) then

3937: BEGIN
3938: if (g_dbg) then
3939: hr_utility.set_location(l_proc, 10);
3940: end if;
3941: if (p_pro_evt_rec.event_type = hr_api.g_delete) then
3942:
3943: -- >>> PHASE 2: Check e is still relevant
3944: --
3945: hr_utility.set_location(l_proc, 20);

Line 4142: -- AND p_pro_evt_rec.event_type <> hr_api.g_insert) then

4138: -- 1 >>> Check the found process event is an Insert
4139: --Quick short-circuit opportunity
4140: -- Removed here as done prior in calling code
4141: --if (p_pro_evt_rec.event_type <> 'I'
4142: -- AND p_pro_evt_rec.event_type <> hr_api.g_insert) then
4143: -- p_disco := G_DISCO_NONE;
4144: -- RETURN;
4145: --end if;
4146:

Line 4216: AND peu.event_type = hr_api.g_update

4212: Look at candidate process event to see if it is an update
4213: --
4214: Detail Logic:
4215: 1) Check the event update is the right type
4216: AND peu.event_type = hr_api.g_update
4217: 2) Check the update is one we're interested
4218:
4219: ---------------------------------------------------------- */
4220: PROCEDURE extra_tests_dyt_pkg_u

Line 4251: if ( p_pro_evt_rec.event_type = hr_api.g_update

4247: if (g_dbg) then
4248: hr_utility.set_location(l_proc, 10);
4249: end if;
4250:
4251: if ( p_pro_evt_rec.event_type = hr_api.g_update
4252: or p_pro_evt_rec.event_type = hr_api.g_update_override
4253: or p_pro_evt_rec.event_type = hr_api.g_update_change_insert
4254: ) then
4255:

Line 4252: or p_pro_evt_rec.event_type = hr_api.g_update_override

4248: hr_utility.set_location(l_proc, 10);
4249: end if;
4250:
4251: if ( p_pro_evt_rec.event_type = hr_api.g_update
4252: or p_pro_evt_rec.event_type = hr_api.g_update_override
4253: or p_pro_evt_rec.event_type = hr_api.g_update_change_insert
4254: ) then
4255:
4256: event_group_table_updated(p_element_entry_id,

Line 4253: or p_pro_evt_rec.event_type = hr_api.g_update_change_insert

4249: end if;
4250:
4251: if ( p_pro_evt_rec.event_type = hr_api.g_update
4252: or p_pro_evt_rec.event_type = hr_api.g_update_override
4253: or p_pro_evt_rec.event_type = hr_api.g_update_change_insert
4254: ) then
4255:
4256: event_group_table_updated(p_element_entry_id,
4257: p_assignment_action_id,

Line 4424: IF ( p_pro_evt_rec.event_type = hr_api.g_future_change or

4420:
4421: -- >>> PHASE 4: Check no future rows
4422: --
4423:
4424: IF ( p_pro_evt_rec.event_type = hr_api.g_future_change or
4425: p_pro_evt_rec.event_type = hr_api.g_delete_next_change ) THEN
4426:
4427: --Check the base table to see if any future dated records exist,
4428: -- Eg we know we have a FUTURE_CHANGE or a DELETE_NEXT_CHANGE

Line 4425: p_pro_evt_rec.event_type = hr_api.g_delete_next_change ) THEN

4421: -- >>> PHASE 4: Check no future rows
4422: --
4423:
4424: IF ( p_pro_evt_rec.event_type = hr_api.g_future_change or
4425: p_pro_evt_rec.event_type = hr_api.g_delete_next_change ) THEN
4426:
4427: --Check the base table to see if any future dated records exist,
4428: -- Eg we know we have a FUTURE_CHANGE or a DELETE_NEXT_CHANGE
4429: -- but check it still applies, not been overriden

Line 4588: p_mst_pe_rec.event_type = hr_api.g_insert) then

4584: --
4585: IF ( l_search = 'I' and p_mst_pe_rec.event_type = 'I') then
4586: extra_tests_i(p_mst_pe_rec,l_look_for_rec,disco);
4587: ELSIF (l_search = 'I' and
4588: p_mst_pe_rec.event_type = hr_api.g_insert) then
4589: extra_tests_i(p_mst_pe_rec,l_look_for_rec,disco);
4590: --
4591: ELSIF (l_search = 'U' and p_mst_pe_rec.event_type = 'U'
4592: and l_all_upd_events_recorded <> TRUE) then

Line 4654: and p_mst_pe_rec.event_type = hr_api.g_correction) then

4650: p_mst_pe_rec.event_type not in ('I','U','D')) then
4651: --
4652: -- Simple test for Dynamic Package styled Correction
4653: if (p_mst_pe_rec.updated_column_name = l_look_for_rec.column_name
4654: and p_mst_pe_rec.event_type = hr_api.g_correction) then
4655: disco := G_DISCO_STANDARD;
4656: end if;
4657:
4658: ELSIF (l_search = 'P' and p_mst_pe_rec.event_type = 'D') then

Line 4661: p_mst_pe_rec.event_type = hr_api.g_zap ) then

4657:
4658: ELSIF (l_search = 'P' and p_mst_pe_rec.event_type = 'D') then
4659: extra_tests_dbt_p(p_mst_pe_rec,l_look_for_rec,disco);
4660: ELSIF (l_search = 'P' and
4661: p_mst_pe_rec.event_type = hr_api.g_zap ) then
4662: -- Simple test already performed for Dynamic Package styled Purge
4663: disco := G_DISCO_STANDARD;
4664:
4665: ELSIF (l_search = 'E' and

Line 5576: AND ( ppe.effective_date > nvl(cp_last_approved_date, hr_api.g_sot) or ppe.creation_date > nvl(cp_last_approved_date, hr_api.g_sot)) -- Bug 10092118

5572: AND ppe.effective_date BETWEEN cp_estart_date AND cp_eend_date
5573: /* Bug fix 12363861 Start
5574: AND ( ppe.effective_date > cp_last_approved_date or ppe.creation_date > cp_last_approved_date) -- Bug 10092118
5575: */
5576: AND ( ppe.effective_date > nvl(cp_last_approved_date, hr_api.g_sot) or ppe.creation_date > nvl(cp_last_approved_date, hr_api.g_sot)) -- Bug 10092118
5577: -- Bug fix 12363861 End
5578: AND ( (cp_bulk_processing = 'Y')
5579: or ( cp_bulk_processing = 'N'
5580: AND ( (pdt.table_name <> 'PAY_ELEMENT_ENTRIES_F' )

Line 6251: p_start_date IN DATE DEFAULT hr_api.g_sot, --events created since this date

6247: p_mode IN VARCHAR2 DEFAULT NULL ,
6248: p_process IN VARCHAR2 DEFAULT NULL ,
6249: p_event_group_id IN NUMBER DEFAULT NULL ,
6250: p_process_mode IN VARCHAR2 DEFAULT 'ENTRY_EFFECTIVE_DATE' ,
6251: p_start_date IN DATE DEFAULT hr_api.g_sot, --events created since this date
6252: p_end_date IN DATE DEFAULT hr_api.g_eot, --events created until this date
6253: p_process_date IN DATE DEFAULT SYSDATE, -- This date, drives for getting
6254: -- a dflt event grop id if one is not passed
6255: p_unique_sort IN VARCHAR2, --default 'Y', --quicker if N

Line 6252: p_end_date IN DATE DEFAULT hr_api.g_eot, --events created until this date

6248: p_process IN VARCHAR2 DEFAULT NULL ,
6249: p_event_group_id IN NUMBER DEFAULT NULL ,
6250: p_process_mode IN VARCHAR2 DEFAULT 'ENTRY_EFFECTIVE_DATE' ,
6251: p_start_date IN DATE DEFAULT hr_api.g_sot, --events created since this date
6252: p_end_date IN DATE DEFAULT hr_api.g_eot, --events created until this date
6253: p_process_date IN DATE DEFAULT SYSDATE, -- This date, drives for getting
6254: -- a dflt event grop id if one is not passed
6255: p_unique_sort IN VARCHAR2, --default 'Y', --quicker if N
6256: p_business_group_id IN NUMBER, --default null, in case someones wrapper needs it

Line 6567: p_start_date IN DATE DEFAULT hr_api.g_sot,

6563: PROCEDURE entries_affected
6564: (
6565: p_assignment_id IN NUMBER DEFAULT NULL ,
6566: p_mode IN VARCHAR2 DEFAULT NULL ,
6567: p_start_date IN DATE DEFAULT hr_api.g_sot,
6568: p_end_date IN DATE DEFAULT hr_api.g_eot,
6569: p_business_group_id IN NUMBER,
6570: p_global_env IN OUT NOCOPY t_global_env_rec,
6571: t_detailed_output OUT NOCOPY t_detailed_output_table_type,

Line 6568: p_end_date IN DATE DEFAULT hr_api.g_eot,

6564: (
6565: p_assignment_id IN NUMBER DEFAULT NULL ,
6566: p_mode IN VARCHAR2 DEFAULT NULL ,
6567: p_start_date IN DATE DEFAULT hr_api.g_sot,
6568: p_end_date IN DATE DEFAULT hr_api.g_eot,
6569: p_business_group_id IN NUMBER,
6570: p_global_env IN OUT NOCOPY t_global_env_rec,
6571: t_detailed_output OUT NOCOPY t_detailed_output_table_type,
6572: p_process_mode IN VARCHAR2 DEFAULT 'ENTRY_CREATION_DATE',