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

Line 54: and nvl(p_pl_extract_identifier_id,hr_api.g_number)

50: p_pl_extract_identifier_id => p_pl_extract_identifier_id,
51: p_object_version_number => p_object_version_number);
52: --
53: if (l_api_updating
54: and nvl(p_pl_extract_identifier_id,hr_api.g_number)
55: <> ben_pei_shd.g_old_rec.pl_extract_identifier_id) then
56: --
57: -- raise error as PK has changed
58: --

Line 228: <> nvl(ben_pei_shd.g_old_rec.home_state,hr_api.g_varchar2)

224: p_object_version_number => p_object_version_number);
225: --
226: if (l_api_updating
227: and p_home_state
228: <> nvl(ben_pei_shd.g_old_rec.home_state,hr_api.g_varchar2)
229: or not l_api_updating)
230: and p_home_state is not null then
231: --
232: -- check if value of lookup falls within lookup type.

Line 234: if hr_api.not_exists_in_hr_lookups

230: and p_home_state is not null then
231: --
232: -- check if value of lookup falls within lookup type.
233: --
234: if hr_api.not_exists_in_hr_lookups
235: (p_lookup_type => 'US_STATE',
236: p_lookup_code => p_home_state,
237: p_effective_date => p_effective_date) then
238: --

Line 285: (p_pl_id in number default hr_api.g_number,

281: --
282: -- {End Of Comments}
283: -- ----------------------------------------------------------------------------
284: Procedure dt_update_validate
285: (p_pl_id in number default hr_api.g_number,
286: p_plip_id in number default hr_api.g_number,
287: p_oipl_id in number default hr_api.g_number,
288: p_datetrack_mode in varchar2,
289: p_validation_start_date in date,

Line 286: p_plip_id in number default hr_api.g_number,

282: -- {End Of Comments}
283: -- ----------------------------------------------------------------------------
284: Procedure dt_update_validate
285: (p_pl_id in number default hr_api.g_number,
286: p_plip_id in number default hr_api.g_number,
287: p_oipl_id in number default hr_api.g_number,
288: p_datetrack_mode in varchar2,
289: p_validation_start_date in date,
290: p_validation_end_date in date) Is

Line 287: p_oipl_id in number default hr_api.g_number,

283: -- ----------------------------------------------------------------------------
284: Procedure dt_update_validate
285: (p_pl_id in number default hr_api.g_number,
286: p_plip_id in number default hr_api.g_number,
287: p_oipl_id in number default hr_api.g_number,
288: p_datetrack_mode in varchar2,
289: p_validation_start_date in date,
290: p_validation_end_date in date) Is
291: --

Line 301: hr_api.mandatory_arg_error

297: hr_utility.set_location('Entering:'||l_proc, 5);
298: --
299: -- Ensure that the p_datetrack_mode argument is not null
300: --
301: hr_api.mandatory_arg_error
302: (p_api_name => l_proc,
303: p_argument => 'datetrack_mode',
304: p_argument_value => p_datetrack_mode);
305: --

Line 313: hr_api.mandatory_arg_error

309: --
310: --
311: -- Ensure the arguments are not null
312: --
313: hr_api.mandatory_arg_error
314: (p_api_name => l_proc,
315: p_argument => 'validation_start_date',
316: p_argument_value => p_validation_start_date);
317: --

Line 318: hr_api.mandatory_arg_error

314: (p_api_name => l_proc,
315: p_argument => 'validation_start_date',
316: p_argument_value => p_validation_start_date);
317: --
318: hr_api.mandatory_arg_error
319: (p_api_name => l_proc,
320: p_argument => 'validation_end_date',
321: p_argument_value => p_validation_end_date);
322: --

Line 323: If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and

319: (p_api_name => l_proc,
320: p_argument => 'validation_end_date',
321: p_argument_value => p_validation_end_date);
322: --
323: If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and
324: NOT (dt_api.check_min_max_dates
325: (p_base_table_name => 'ben_pl_f',
326: p_base_key_column => 'pl_id',
327: p_base_key_value => p_pl_id,

Line 333: If ((nvl(p_plip_id, hr_api.g_number) <> hr_api.g_number) and

329: p_to_date => p_validation_end_date))) Then
330: l_table_name := 'ben_pl_f';
331: Raise l_integrity_error;
332: End If;
333: If ((nvl(p_plip_id, hr_api.g_number) <> hr_api.g_number) and
334: NOT (dt_api.check_min_max_dates
335: (p_base_table_name => 'ben_plip_f',
336: p_base_key_column => 'plip_id',
337: p_base_key_value => p_plip_id,

Line 343: If ((nvl(p_oipl_id, hr_api.g_number) <> hr_api.g_number) and

339: p_to_date => p_validation_end_date))) Then
340: l_table_name := 'ben_plip_f';
341: Raise l_integrity_error;
342: End If;
343: If ((nvl(p_oipl_id, hr_api.g_number) <> hr_api.g_number) and
344: NOT (dt_api.check_min_max_dates
345: (p_base_table_name => 'ben_oipl_f',
346: p_base_key_column => 'oipl_id',
347: p_base_key_value => p_oipl_id,

Line 426: hr_api.mandatory_arg_error

422: hr_utility.set_location('Entering:'||l_proc, 5);
423: --
424: -- Ensure that the p_datetrack_mode argument is not null
425: --
426: hr_api.mandatory_arg_error
427: (p_api_name => l_proc,
428: p_argument => 'datetrack_mode',
429: p_argument_value => p_datetrack_mode);
430: --

Line 440: hr_api.mandatory_arg_error

436: --
437: --
438: -- Ensure the arguments are not null
439: --
440: hr_api.mandatory_arg_error
441: (p_api_name => l_proc,
442: p_argument => 'validation_start_date',
443: p_argument_value => p_validation_start_date);
444: --

Line 445: hr_api.mandatory_arg_error

441: (p_api_name => l_proc,
442: p_argument => 'validation_start_date',
443: p_argument_value => p_validation_start_date);
444: --
445: hr_api.mandatory_arg_error
446: (p_api_name => l_proc,
447: p_argument => 'validation_end_date',
448: p_argument_value => p_validation_end_date);
449: --

Line 450: hr_api.mandatory_arg_error

446: (p_api_name => l_proc,
447: p_argument => 'validation_end_date',
448: p_argument_value => p_validation_end_date);
449: --
450: hr_api.mandatory_arg_error
451: (p_api_name => l_proc,
452: p_argument => 'pl_extract_identifier_id',
453: p_argument_value => p_pl_extract_identifier_id);
454: --

Line 495: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

491: --
492: -- Call all supporting business operations
493: --
494: if p_rec.business_group_id is not null then
495: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
496: end if;
497: --
498: chk_pl_extract_identifier_id
499: (p_pl_extract_identifier_id => p_rec.pl_extract_identifier_id,

Line 540: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

536: --
537: -- Call all supporting business operations
538: --
539: if p_rec.business_group_id is not null then
540: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
541: end if;
542: --
543: chk_pl_extract_identifier_id
544: (p_pl_extract_identifier_id => p_rec.pl_extract_identifier_id,

Line 632: hr_api.mandatory_arg_error(p_api_name => l_proc,

628: hr_utility.set_location('Entering:'|| l_proc, 10);
629: --
630: -- Ensure that all the mandatory parameter are not null
631: --
632: hr_api.mandatory_arg_error(p_api_name => l_proc,
633: p_argument => 'pl_extract_identifier_id',
634: p_argument_value => p_pl_extract_identifier_id);
635: --
636: open csr_leg_code;