DBA Data[Home] [Help]

APPS.BEN_ETP_BUS dependencies on HR_API

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

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

Line 191: and nvl(p_prtt_det_rl,hr_api.g_number)

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

Line 268: <> nvl(ben_etp_shd.g_old_rec.prtt_det_cd,hr_api.g_varchar2)

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

Line 274: if hr_api.not_exists_in_hr_lookups

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

Line 339: <> nvl(ben_etp_shd.g_old_rec.no_mx_prtt_num_apls_flag,hr_api.g_varchar2)

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

Line 345: if hr_api.not_exists_in_hr_lookups

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

Line 410: <> nvl(ben_etp_shd.g_old_rec.no_mn_prtt_num_apls_flag,hr_api.g_varchar2)

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

Line 416: if hr_api.not_exists_in_hr_lookups

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

Line 481: <> nvl(ben_etp_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

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

Line 487: if hr_api.not_exists_in_hr_lookups

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

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

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

Line 691: hr_api.mandatory_arg_error

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

Line 703: hr_api.mandatory_arg_error

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

Line 708: hr_api.mandatory_arg_error

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

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

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

Line 795: hr_api.mandatory_arg_error

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

Line 809: hr_api.mandatory_arg_error

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

Line 814: hr_api.mandatory_arg_error

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

Line 819: hr_api.mandatory_arg_error

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

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

863: --
864: -- Call all supporting business operations
865: --
866: --
867: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
868: --
869: chk_ELIG_TTL_PRTT_PRTE_id
870: (p_ELIG_TTL_PRTT_PRTE_id => p_rec.ELIG_TTL_PRTT_PRTE_id,
871: p_effective_date => p_effective_date,

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

945: --
946: -- Call all supporting business operations
947: --
948: --
949: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
950: --
951: chk_ELIG_TTL_PRTT_PRTE_id
952: (p_ELIG_TTL_PRTT_PRTE_id => p_rec.ELIG_TTL_PRTT_PRTE_id,
953: p_effective_date => p_effective_date,

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

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