DBA Data[Home] [Help]

APPS.BEN_ERP_BUS dependencies on HR_API

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

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

Line 124: and nvl(p_rt_end_dt_rl,hr_api.g_number)

120: p_effective_date => p_effective_date,
121: p_object_version_number => p_object_version_number);
122: --
123: if (l_api_updating
124: and nvl(p_rt_end_dt_rl,hr_api.g_number)
125: <> ben_erp_shd.g_old_rec.rt_end_dt_rl
126: or not l_api_updating)
127: and p_rt_end_dt_rl is not null then
128: --

Line 197: <> nvl(ben_erp_shd.g_old_rec.rt_end_dt_cd,hr_api.g_varchar2)

193: p_object_version_number => p_object_version_number);
194: --
195: if (l_api_updating
196: and p_rt_end_dt_cd
197: <> nvl(ben_erp_shd.g_old_rec.rt_end_dt_cd,hr_api.g_varchar2)
198: or not l_api_updating)
199: and p_rt_end_dt_cd is not null then
200: --
201: -- check if value of lookup falls within lookup type.

Line 203: if hr_api.not_exists_in_hr_lookups

199: and p_rt_end_dt_cd is not null then
200: --
201: -- check if value of lookup falls within lookup type.
202: --
203: if hr_api.not_exists_in_hr_lookups
204: (p_lookup_type => 'BEN_RT_END',
205: p_lookup_code => p_rt_end_dt_cd,
206: p_effective_date => p_effective_date) then
207: --

Line 268: and nvl(p_rt_strt_dt_rl,hr_api.g_number)

264: p_effective_date => p_effective_date,
265: p_object_version_number => p_object_version_number);
266: --
267: if (l_api_updating
268: and nvl(p_rt_strt_dt_rl,hr_api.g_number)
269: <> ben_erp_shd.g_old_rec.rt_strt_dt_rl
270: or not l_api_updating)
271: and p_rt_strt_dt_rl is not null then
272: --

Line 341: <> nvl(ben_erp_shd.g_old_rec.rt_strt_dt_cd,hr_api.g_varchar2)

337: p_object_version_number => p_object_version_number);
338: --
339: if (l_api_updating
340: and p_rt_strt_dt_cd
341: <> nvl(ben_erp_shd.g_old_rec.rt_strt_dt_cd,hr_api.g_varchar2)
342: or not l_api_updating)
343: and p_rt_strt_dt_cd is not null then
344: --
345: -- check if value of lookup falls within lookup type.

Line 347: if hr_api.not_exists_in_hr_lookups

343: and p_rt_strt_dt_cd is not null then
344: --
345: -- check if value of lookup falls within lookup type.
346: --
347: if hr_api.not_exists_in_hr_lookups
348: (p_lookup_type => 'BEN_RT_STRT',
349: p_lookup_code => p_rt_strt_dt_cd,
350: p_effective_date => p_effective_date) then
351: --

Line 412: and nvl(p_enrt_cvg_end_dt_rl,hr_api.g_number)

408: p_effective_date => p_effective_date,
409: p_object_version_number => p_object_version_number);
410: --
411: if (l_api_updating
412: and nvl(p_enrt_cvg_end_dt_rl,hr_api.g_number)
413: <> ben_erp_shd.g_old_rec.enrt_cvg_end_dt_rl
414: or not l_api_updating)
415: and p_enrt_cvg_end_dt_rl is not null then
416: --

Line 485: <> nvl(ben_erp_shd.g_old_rec.enrt_cvg_end_dt_cd,hr_api.g_varchar2)

481: p_object_version_number => p_object_version_number);
482: --
483: if (l_api_updating
484: and p_enrt_cvg_end_dt_cd
485: <> nvl(ben_erp_shd.g_old_rec.enrt_cvg_end_dt_cd,hr_api.g_varchar2)
486: or not l_api_updating)
487: and p_enrt_cvg_end_dt_cd is not null then
488: --
489: -- check if value of lookup falls within lookup type.

Line 491: if hr_api.not_exists_in_hr_lookups

487: and p_enrt_cvg_end_dt_cd is not null then
488: --
489: -- check if value of lookup falls within lookup type.
490: --
491: if hr_api.not_exists_in_hr_lookups
492: (p_lookup_type => 'BEN_ENRT_CVG_END',
493: p_lookup_code => p_enrt_cvg_end_dt_cd,
494: p_effective_date => p_effective_date) then
495: --

Line 556: and nvl(p_enrt_cvg_strt_dt_rl,hr_api.g_number)

552: p_effective_date => p_effective_date,
553: p_object_version_number => p_object_version_number);
554: --
555: if (l_api_updating
556: and nvl(p_enrt_cvg_strt_dt_rl,hr_api.g_number)
557: <> ben_erp_shd.g_old_rec.enrt_cvg_strt_dt_rl
558: or not l_api_updating)
559: and p_enrt_cvg_strt_dt_rl is not null then
560: --

Line 629: <> nvl(ben_erp_shd.g_old_rec.enrt_cvg_strt_dt_cd,hr_api.g_varchar2)

625: p_object_version_number => p_object_version_number);
626: --
627: if (l_api_updating
628: and p_enrt_cvg_strt_dt_cd
629: <> nvl(ben_erp_shd.g_old_rec.enrt_cvg_strt_dt_cd,hr_api.g_varchar2)
630: or not l_api_updating)
631: and p_enrt_cvg_strt_dt_cd is not null then
632: --
633: -- check if value of lookup falls within lookup type.

Line 635: if hr_api.not_exists_in_hr_lookups

631: and p_enrt_cvg_strt_dt_cd is not null then
632: --
633: -- check if value of lookup falls within lookup type.
634: --
635: if hr_api.not_exists_in_hr_lookups
636: (p_lookup_type => 'BEN_ENRT_CVG_STRT',
637: p_lookup_code => p_enrt_cvg_strt_dt_cd,
638: p_effective_date => p_effective_date) then
639: --

Line 685: (p_lee_rsn_id in number default hr_api.g_number,

681: --
682: -- {End Of Comments}
683: -- ----------------------------------------------------------------------------
684: Procedure dt_update_validate
685: (p_lee_rsn_id in number default hr_api.g_number,
686: p_pl_id in number default hr_api.g_number,
687: p_datetrack_mode in varchar2,
688: p_validation_start_date in date,
689: p_validation_end_date in date) Is

Line 686: p_pl_id in number default hr_api.g_number,

682: -- {End Of Comments}
683: -- ----------------------------------------------------------------------------
684: Procedure dt_update_validate
685: (p_lee_rsn_id in number default hr_api.g_number,
686: p_pl_id in number default hr_api.g_number,
687: p_datetrack_mode in varchar2,
688: p_validation_start_date in date,
689: p_validation_end_date in date) Is
690: --

Line 700: hr_api.mandatory_arg_error

696: hr_utility.set_location('Entering:'||l_proc, 5);
697: --
698: -- Ensure that the p_datetrack_mode argument is not null
699: --
700: hr_api.mandatory_arg_error
701: (p_api_name => l_proc,
702: p_argument => 'datetrack_mode',
703: p_argument_value => p_datetrack_mode);
704: --

Line 712: hr_api.mandatory_arg_error

708: --
709: --
710: -- Ensure the arguments are not null
711: --
712: hr_api.mandatory_arg_error
713: (p_api_name => l_proc,
714: p_argument => 'validation_start_date',
715: p_argument_value => p_validation_start_date);
716: --

Line 717: hr_api.mandatory_arg_error

713: (p_api_name => l_proc,
714: p_argument => 'validation_start_date',
715: p_argument_value => p_validation_start_date);
716: --
717: hr_api.mandatory_arg_error
718: (p_api_name => l_proc,
719: p_argument => 'validation_end_date',
720: p_argument_value => p_validation_end_date);
721: --

Line 722: If ((nvl(p_lee_rsn_id, hr_api.g_number) <> hr_api.g_number) and

718: (p_api_name => l_proc,
719: p_argument => 'validation_end_date',
720: p_argument_value => p_validation_end_date);
721: --
722: If ((nvl(p_lee_rsn_id, hr_api.g_number) <> hr_api.g_number) and
723: NOT (dt_api.check_min_max_dates
724: (p_base_table_name => 'ben_lee_rsn_f',
725: p_base_key_column => 'lee_rsn_id',
726: p_base_key_value => p_lee_rsn_id,

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

728: p_to_date => p_validation_end_date))) Then
729: l_table_name := 'ben_lee_rsn_f';
730: Raise l_integrity_error;
731: End If;
732: If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and
733: NOT (dt_api.check_min_max_dates
734: (p_base_table_name => 'ben_pl_f',
735: p_base_key_column => 'pl_id',
736: p_base_key_value => p_pl_id,

Line 816: hr_api.mandatory_arg_error

812: hr_utility.set_location('Entering:'||l_proc, 5);
813: --
814: -- Ensure that the p_datetrack_mode argument is not null
815: --
816: hr_api.mandatory_arg_error
817: (p_api_name => l_proc,
818: p_argument => 'datetrack_mode',
819: p_argument_value => p_datetrack_mode);
820: --

Line 830: hr_api.mandatory_arg_error

826: --
827: --
828: -- Ensure the arguments are not null
829: --
830: hr_api.mandatory_arg_error
831: (p_api_name => l_proc,
832: p_argument => 'validation_start_date',
833: p_argument_value => p_validation_start_date);
834: --

Line 835: hr_api.mandatory_arg_error

831: (p_api_name => l_proc,
832: p_argument => 'validation_start_date',
833: p_argument_value => p_validation_start_date);
834: --
835: hr_api.mandatory_arg_error
836: (p_api_name => l_proc,
837: p_argument => 'validation_end_date',
838: p_argument_value => p_validation_end_date);
839: --

Line 840: hr_api.mandatory_arg_error

836: (p_api_name => l_proc,
837: p_argument => 'validation_end_date',
838: p_argument_value => p_validation_end_date);
839: --
840: hr_api.mandatory_arg_error
841: (p_api_name => l_proc,
842: p_argument => 'enrt_perd_for_pl_id',
843: p_argument_value => p_enrt_perd_for_pl_id);
844: --

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

884: --
885: -- Call all supporting business operations
886: --
887: --
888: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
889: --
890: chk_enrt_perd_for_pl_id
891: (p_enrt_perd_for_pl_id => p_rec.enrt_perd_for_pl_id,
892: p_effective_date => p_effective_date,

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

964: --
965: -- Call all supporting business operations
966: --
967: --
968: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
969: --
970: chk_enrt_perd_for_pl_id
971: (p_enrt_perd_for_pl_id => p_rec.enrt_perd_for_pl_id,
972: p_effective_date => p_effective_date,

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

1089: hr_utility.set_location('Entering:'|| l_proc, 10);
1090: --
1091: -- Ensure that all the mandatory parameter are not null
1092: --
1093: hr_api.mandatory_arg_error(p_api_name => l_proc,
1094: p_argument => 'enrt_perd_for_pl_id',
1095: p_argument_value => p_enrt_perd_for_pl_id);
1096: --
1097: open csr_leg_code;