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

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

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

Line 190: and nvl(p_cvg_vol_det_rl,hr_api.g_number)

186: p_effective_date => p_effective_date,
187: p_object_version_number => p_object_version_number);
188: --
189: if (l_api_updating
190: and nvl(p_cvg_vol_det_rl,hr_api.g_number)
191: <> ben_etc_shd.g_old_rec.cvg_vol_det_rl
192: or not l_api_updating)
193: and p_cvg_vol_det_rl is not null then
194: --

Line 267: <> nvl(ben_etc_shd.g_old_rec.cvg_vol_det_cd,hr_api.g_varchar2)

263: p_object_version_number => p_object_version_number);
264: --
265: if (l_api_updating
266: and p_cvg_vol_det_cd
267: <> nvl(ben_etc_shd.g_old_rec.cvg_vol_det_cd,hr_api.g_varchar2)
268: or not l_api_updating)
269: and p_cvg_vol_det_cd is not null then
270: --
271: -- check if value of lookup falls within lookup type.

Line 273: if hr_api.not_exists_in_hr_lookups

269: and p_cvg_vol_det_cd is not null then
270: --
271: -- check if value of lookup falls within lookup type.
272: --
273: if hr_api.not_exists_in_hr_lookups
274: (p_lookup_type => 'BEN_CVG_DET_DT',
275: p_lookup_code => p_cvg_vol_det_cd,
276: p_effective_date => p_effective_date) then
277: --

Line 338: <> nvl(ben_etc_shd.g_old_rec.no_mx_cvg_vol_amt_apls_flag,hr_api.g_varchar2)

334: p_object_version_number => p_object_version_number);
335: --
336: if (l_api_updating
337: and p_no_mx_cvg_vol_amt_apls_flag
338: <> nvl(ben_etc_shd.g_old_rec.no_mx_cvg_vol_amt_apls_flag,hr_api.g_varchar2)
339: or not l_api_updating) then
340: --
341: -- check if value of lookup falls within lookup type.
342: --

Line 344: if hr_api.not_exists_in_hr_lookups

340: --
341: -- check if value of lookup falls within lookup type.
342: --
343: --
344: if hr_api.not_exists_in_hr_lookups
345: (p_lookup_type => 'YES_NO',
346: p_lookup_code => p_no_mx_cvg_vol_amt_apls_flag,
347: p_effective_date => p_effective_date) then
348: --

Line 409: <> nvl(ben_etc_shd.g_old_rec.no_mn_cvg_vol_amt_apls_flag,hr_api.g_varchar2)

405: p_object_version_number => p_object_version_number);
406: --
407: if (l_api_updating
408: and p_no_mn_cvg_vol_amt_apls_flag
409: <> nvl(ben_etc_shd.g_old_rec.no_mn_cvg_vol_amt_apls_flag,hr_api.g_varchar2)
410: or not l_api_updating) then
411: --
412: -- check if value of lookup falls within lookup type.
413: --

Line 415: if hr_api.not_exists_in_hr_lookups

411: --
412: -- check if value of lookup falls within lookup type.
413: --
414: --
415: if hr_api.not_exists_in_hr_lookups
416: (p_lookup_type => 'YES_NO',
417: p_lookup_code => p_no_mn_cvg_vol_amt_apls_flag,
418: p_effective_date => p_effective_date) then
419: --

Line 480: <> nvl(ben_etc_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

476: p_object_version_number => p_object_version_number);
477: --
478: if (l_api_updating
479: and p_excld_flag
480: <> nvl(ben_etc_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
481: or not l_api_updating) then
482: --
483: -- check if value of lookup falls within lookup type.
484: --

Line 486: if hr_api.not_exists_in_hr_lookups

482: --
483: -- check if value of lookup falls within lookup type.
484: --
485: --
486: if hr_api.not_exists_in_hr_lookups
487: (p_lookup_type => 'YES_NO',
488: p_lookup_code => p_excld_flag,
489: p_effective_date => p_effective_date) then
490: --

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

674: --
675: -- {End Of Comments}
676: -- ----------------------------------------------------------------------------
677: Procedure dt_update_validate
678: (p_eligy_prfl_id in number default hr_api.g_number,
679: p_datetrack_mode in varchar2,
680: p_validation_start_date in date,
681: p_validation_end_date in date) Is
682: --

Line 692: hr_api.mandatory_arg_error

688: hr_utility.set_location('Entering:'||l_proc, 5);
689: --
690: -- Ensure that the p_datetrack_mode argument is not null
691: --
692: hr_api.mandatory_arg_error
693: (p_api_name => l_proc,
694: p_argument => 'datetrack_mode',
695: p_argument_value => p_datetrack_mode);
696: --

Line 704: hr_api.mandatory_arg_error

700: --
701: --
702: -- Ensure the arguments are not null
703: --
704: hr_api.mandatory_arg_error
705: (p_api_name => l_proc,
706: p_argument => 'validation_start_date',
707: p_argument_value => p_validation_start_date);
708: --

Line 709: hr_api.mandatory_arg_error

705: (p_api_name => l_proc,
706: p_argument => 'validation_start_date',
707: p_argument_value => p_validation_start_date);
708: --
709: hr_api.mandatory_arg_error
710: (p_api_name => l_proc,
711: p_argument => 'validation_end_date',
712: p_argument_value => p_validation_end_date);
713: --

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

710: (p_api_name => l_proc,
711: p_argument => 'validation_end_date',
712: p_argument_value => p_validation_end_date);
713: --
714: If ((nvl(p_eligy_prfl_id, hr_api.g_number) <> hr_api.g_number) and
715: NOT (dt_api.check_min_max_dates
716: (p_base_table_name => 'ben_eligy_prfl_f',
717: p_base_key_column => 'eligy_prfl_id',
718: p_base_key_value => p_eligy_prfl_id,

Line 796: hr_api.mandatory_arg_error

792: hr_utility.set_location('Entering:'||l_proc, 5);
793: --
794: -- Ensure that the p_datetrack_mode argument is not null
795: --
796: hr_api.mandatory_arg_error
797: (p_api_name => l_proc,
798: p_argument => 'datetrack_mode',
799: p_argument_value => p_datetrack_mode);
800: --

Line 810: hr_api.mandatory_arg_error

806: --
807: --
808: -- Ensure the arguments are not null
809: --
810: hr_api.mandatory_arg_error
811: (p_api_name => l_proc,
812: p_argument => 'validation_start_date',
813: p_argument_value => p_validation_start_date);
814: --

Line 815: hr_api.mandatory_arg_error

811: (p_api_name => l_proc,
812: p_argument => 'validation_start_date',
813: p_argument_value => p_validation_start_date);
814: --
815: hr_api.mandatory_arg_error
816: (p_api_name => l_proc,
817: p_argument => 'validation_end_date',
818: p_argument_value => p_validation_end_date);
819: --

Line 820: hr_api.mandatory_arg_error

816: (p_api_name => l_proc,
817: p_argument => 'validation_end_date',
818: p_argument_value => p_validation_end_date);
819: --
820: hr_api.mandatory_arg_error
821: (p_api_name => l_proc,
822: p_argument => 'elig_ttl_cvg_vol_prte_id',
823: p_argument_value => p_elig_ttl_cvg_vol_prte_id);
824: --

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

864: --
865: -- Call all supporting business operations
866: --
867: --
868: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
869: --
870: chk_elig_ttl_cvg_vol_prte_id
871: (p_elig_ttl_cvg_vol_prte_id => p_rec.elig_ttl_cvg_vol_prte_id,
872: p_effective_date => p_effective_date,

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

946: --
947: -- Call all supporting business operations
948: --
949: --
950: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
951: --
952: chk_elig_ttl_cvg_vol_prte_id
953: (p_elig_ttl_cvg_vol_prte_id => p_rec.elig_ttl_cvg_vol_prte_id,
954: p_effective_date => p_effective_date,

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

1072: hr_utility.set_location('Entering:'|| l_proc, 10);
1073: --
1074: -- Ensure that all the mandatory parameter are not null
1075: --
1076: hr_api.mandatory_arg_error(p_api_name => l_proc,
1077: p_argument => 'elig_ttl_cvg_vol_prte_id',
1078: p_argument_value => p_elig_ttl_cvg_vol_prte_id);
1079: --
1080: open csr_leg_code;