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_ECT_BUS dependencies on HR_API

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

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

Line 137: and elig_dsblty_ctg_prte_id <> nvl(p_elig_dsblty_ctg_prte_id,hr_api.g_number)

133: select null
134: from ben_elig_dsblty_ctg_prte_f
135: where category = p_category
136: and eligy_prfl_id = p_eligy_prfl_id
137: and elig_dsblty_ctg_prte_id <> nvl(p_elig_dsblty_ctg_prte_id,hr_api.g_number)
138: and business_group_id + 0 = p_business_group_id
139: and p_validation_start_date <= effective_end_date
140: and p_validation_end_date >= effective_start_date
141: ;

Line 192: and nvl(p_category,hr_api.g_number)

188: p_effective_date => p_effective_date,
189: p_object_version_number => p_object_version_number);
190: --
191: if (l_api_updating
192: and nvl(p_category,hr_api.g_number)
193: <> nvl(ben_ect_shd.g_old_rec.category,hr_api.g_number)
194: or not l_api_updating) then
195: --
196: -- check if category value exists in per_person_types table

Line 193: <> nvl(ben_ect_shd.g_old_rec.category,hr_api.g_number)

189: p_object_version_number => p_object_version_number);
190: --
191: if (l_api_updating
192: and nvl(p_category,hr_api.g_number)
193: <> nvl(ben_ect_shd.g_old_rec.category,hr_api.g_number)
194: or not l_api_updating) then
195: --
196: -- check if category value exists in per_person_types table
197: --

Line 309: <>nvl(ben_ect_shd.g_old_rec.category,hr_api.g_varchar2)

305: p_object_version_number =>p_object_version_number);
306: --
307: if (l_api_updating
308: and p_category
309: <>nvl(ben_ect_shd.g_old_rec.category,hr_api.g_varchar2)
310: or not l_api_updating)
311: and p_category is not null then
312: --
313: open c1;

Line 379: <> nvl(ben_ect_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

375: p_object_version_number => p_object_version_number);
376: --
377: if (l_api_updating
378: and p_excld_flag
379: <> nvl(ben_ect_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
380: or not l_api_updating) then
381: --
382: -- check if value of lookup falls within lookup type.
383: --

Line 385: if hr_api.not_exists_in_hr_lookups

381: --
382: -- check if value of lookup falls within lookup type.
383: --
384: --
385: if hr_api.not_exists_in_hr_lookups
386: (p_lookup_type => 'YES_NO',
387: p_lookup_code => p_excld_flag,
388: p_effective_date => p_effective_date) then
389: --

Line 433: (p_eligy_prfl_id in number default hr_api.g_number,

429: --
430: -- {End Of Comments}
431: -- ----------------------------------------------------------------------------
432: Procedure dt_update_validate
433: (p_eligy_prfl_id in number default hr_api.g_number,
434: p_datetrack_mode in varchar2,
435: p_validation_start_date in date,
436: p_validation_end_date in date) Is
437: --

Line 447: hr_api.mandatory_arg_error

443: hr_utility.set_location('Entering:'||l_proc, 5);
444: --
445: -- Ensure that the p_datetrack_mode argument is not null
446: --
447: hr_api.mandatory_arg_error
448: (p_api_name => l_proc,
449: p_argument => 'datetrack_mode',
450: p_argument_value => p_datetrack_mode);
451: --

Line 459: hr_api.mandatory_arg_error

455: --
456: --
457: -- Ensure the arguments are not null
458: --
459: hr_api.mandatory_arg_error
460: (p_api_name => l_proc,
461: p_argument => 'validation_start_date',
462: p_argument_value => p_validation_start_date);
463: --

Line 464: hr_api.mandatory_arg_error

460: (p_api_name => l_proc,
461: p_argument => 'validation_start_date',
462: p_argument_value => p_validation_start_date);
463: --
464: hr_api.mandatory_arg_error
465: (p_api_name => l_proc,
466: p_argument => 'validation_end_date',
467: p_argument_value => p_validation_end_date);
468: --

Line 469: If ((nvl(p_eligy_prfl_id, hr_api.g_number) <> hr_api.g_number) and

465: (p_api_name => l_proc,
466: p_argument => 'validation_end_date',
467: p_argument_value => p_validation_end_date);
468: --
469: If ((nvl(p_eligy_prfl_id, hr_api.g_number) <> hr_api.g_number) and
470: NOT (dt_api.check_min_max_dates
471: (p_base_table_name => 'ben_eligy_prfl_f',
472: p_base_key_column => 'eligy_prfl_id',
473: p_base_key_value => p_eligy_prfl_id,

Line 553: hr_api.mandatory_arg_error

549: hr_utility.set_location('Entering:'||l_proc, 5);
550: --
551: -- Ensure that the p_datetrack_mode argument is not null
552: --
553: hr_api.mandatory_arg_error
554: (p_api_name => l_proc,
555: p_argument => 'datetrack_mode',
556: p_argument_value => p_datetrack_mode);
557: --

Line 567: hr_api.mandatory_arg_error

563: --
564: --
565: -- Ensure the arguments are not null
566: --
567: hr_api.mandatory_arg_error
568: (p_api_name => l_proc,
569: p_argument => 'validation_start_date',
570: p_argument_value => p_validation_start_date);
571: --

Line 572: hr_api.mandatory_arg_error

568: (p_api_name => l_proc,
569: p_argument => 'validation_start_date',
570: p_argument_value => p_validation_start_date);
571: --
572: hr_api.mandatory_arg_error
573: (p_api_name => l_proc,
574: p_argument => 'validation_end_date',
575: p_argument_value => p_validation_end_date);
576: --

Line 577: hr_api.mandatory_arg_error

573: (p_api_name => l_proc,
574: p_argument => 'validation_end_date',
575: p_argument_value => p_validation_end_date);
576: --
577: hr_api.mandatory_arg_error
578: (p_api_name => l_proc,
579: p_argument => 'elig_dsblty_ctg_prte_id',
580: p_argument_value => p_elig_dsblty_ctg_prte_id);
581: --

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

621: --
622: -- Call all supporting business operations
623: --
624: --
625: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
626: --
627: chk_elig_dsblty_ctg_prte_id
628: (p_elig_dsblty_ctg_prte_id => p_rec.elig_dsblty_ctg_prte_id,
629: p_effective_date => p_effective_date,

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

673: --
674: -- Call all supporting business operations
675: --
676: --
677: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
678: --
679: chk_elig_dsblty_ctg_prte_id
680: (p_elig_dsblty_ctg_prte_id => p_rec.elig_dsblty_ctg_prte_id,
681: p_effective_date => p_effective_date,

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

769: hr_utility.set_location('Entering:'|| l_proc, 10);
770: --
771: -- Ensure that all the mandatory parameter are not null
772: --
773: hr_api.mandatory_arg_error(p_api_name => l_proc,
774: p_argument => 'elig_dsblty_ctg_prte_id',
775: p_argument_value => p_elig_dsblty_ctg_prte_id);
776: --
777: open csr_leg_code;