DBA Data[Home] [Help]

APPS.BEN_PND_BUS dependencies on HR_API

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

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

Line 190: <> nvl(ben_pnd_shd.g_old_rec.rlshp_typ_cd,hr_api.g_varchar2)

186: p_object_version_number => p_object_version_number);
187: --
188: if (l_api_updating
189: and p_rlshp_typ_cd
190: <> nvl(ben_pnd_shd.g_old_rec.rlshp_typ_cd,hr_api.g_varchar2)
191: or not l_api_updating)
192: and p_rlshp_typ_cd is not null then
193: --
194: -- check if value of lookup falls within lookup type.

Line 196: if hr_api.not_exists_in_hr_lookups

192: and p_rlshp_typ_cd is not null then
193: --
194: -- check if value of lookup falls within lookup type.
195: --
196: if hr_api.not_exists_in_hr_lookups
197: (p_lookup_type => 'CONTACT',
198: p_lookup_code => p_rlshp_typ_cd,
199: p_effective_date => p_effective_date) then
200: --

Line 259: <> nvl(ben_pnd_shd.g_old_rec.rqd_flag,hr_api.g_varchar2)

255: p_object_version_number => p_object_version_number);
256: --
257: if (l_api_updating
258: and p_rqd_flag
259: <> nvl(ben_pnd_shd.g_old_rec.rqd_flag,hr_api.g_varchar2)
260: or not l_api_updating) then
261: --
262: -- check if value of lookup falls within lookup type.
263: --

Line 265: if hr_api.not_exists_in_hr_lookups

261: --
262: -- check if value of lookup falls within lookup type.
263: --
264: --
265: if hr_api.not_exists_in_hr_lookups
266: (p_lookup_type => 'YES_NO',
267: p_lookup_code => p_rqd_flag,
268: p_effective_date => p_effective_date) then
269: --

Line 328: <> nvl(ben_pnd_shd.g_old_rec.dpnt_cvg_ctfn_typ_cd,hr_api.g_varchar2)

324: p_object_version_number => p_object_version_number);
325: --
326: if (l_api_updating
327: and p_dpnt_cvg_ctfn_typ_cd
328: <> nvl(ben_pnd_shd.g_old_rec.dpnt_cvg_ctfn_typ_cd,hr_api.g_varchar2)
329: or not l_api_updating) then
330: --
331: -- check if value of lookup falls within lookup type.
332: --

Line 334: if hr_api.not_exists_in_hr_lookups

330: --
331: -- check if value of lookup falls within lookup type.
332: --
333: --
334: if hr_api.not_exists_in_hr_lookups
335: (p_lookup_type => 'BEN_DPNT_CVG_CTFN_TYP',
336: p_lookup_code => p_dpnt_cvg_ctfn_typ_cd,
337: p_effective_date => p_effective_date) then
338: --

Line 397: <> nvl(ben_pnd_shd.g_old_rec.lack_ctfn_sspnd_enrt_flag,hr_api.g_varchar2)

393: p_object_version_number => p_object_version_number);
394: --
395: if (l_api_updating
396: and p_lack_ctfn_sspnd_enrt_flag
397: <> nvl(ben_pnd_shd.g_old_rec.lack_ctfn_sspnd_enrt_flag,hr_api.g_varchar2)
398: or not l_api_updating) then
399: --
400: -- check if value of lookup falls within lookup type.
401: --

Line 403: if hr_api.not_exists_in_hr_lookups

399: --
400: -- check if value of lookup falls within lookup type.
401: --
402: --
403: if hr_api.not_exists_in_hr_lookups
404: (p_lookup_type => 'YES_NO',
405: p_lookup_code => p_lack_ctfn_sspnd_enrt_flag,
406: p_effective_date => p_effective_date) then
407: --

Line 482: and nvl(p_ctfn_rqd_when_rl,hr_api.g_number)

478: p_effective_date => p_effective_date,
479: p_object_version_number => p_object_version_number);
480: --
481: if (l_api_updating
482: and nvl(p_ctfn_rqd_when_rl,hr_api.g_number)
483: <> ben_pnd_shd.g_old_rec.ctfn_rqd_when_rl
484: or not l_api_updating)
485: and p_ctfn_rqd_when_rl is not null then
486: --

Line 562: <> nvl(ben_pnd_shd.g_old_rec.pfd_flag,hr_api.g_varchar2)

558: p_object_version_number => p_object_version_number);
559: --
560: if (l_api_updating
561: and p_pfd_flag
562: <> nvl(ben_pnd_shd.g_old_rec.pfd_flag,hr_api.g_varchar2)
563: or not l_api_updating) then
564: --
565: -- check if value of lookup falls within lookup type.
566: --

Line 568: if hr_api.not_exists_in_hr_lookups

564: --
565: -- check if value of lookup falls within lookup type.
566: --
567: --
568: if hr_api.not_exists_in_hr_lookups
569: (p_lookup_type => 'YES_NO',
570: p_lookup_code => p_pfd_flag,
571: p_effective_date => p_effective_date) then
572: --

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

612: --
613: -- {End Of Comments}
614: -- ----------------------------------------------------------------------------
615: Procedure dt_update_validate
616: (p_pl_id in number default hr_api.g_number,
617: p_datetrack_mode in varchar2,
618: p_validation_start_date in date,
619: p_validation_end_date in date) Is
620: --

Line 630: hr_api.mandatory_arg_error

626: hr_utility.set_location('Entering:'||l_proc, 5);
627: --
628: -- Ensure that the p_datetrack_mode argument is not null
629: --
630: hr_api.mandatory_arg_error
631: (p_api_name => l_proc,
632: p_argument => 'datetrack_mode',
633: p_argument_value => p_datetrack_mode);
634: --

Line 642: hr_api.mandatory_arg_error

638: --
639: --
640: -- Ensure the arguments are not null
641: --
642: hr_api.mandatory_arg_error
643: (p_api_name => l_proc,
644: p_argument => 'validation_start_date',
645: p_argument_value => p_validation_start_date);
646: --

Line 647: hr_api.mandatory_arg_error

643: (p_api_name => l_proc,
644: p_argument => 'validation_start_date',
645: p_argument_value => p_validation_start_date);
646: --
647: hr_api.mandatory_arg_error
648: (p_api_name => l_proc,
649: p_argument => 'validation_end_date',
650: p_argument_value => p_validation_end_date);
651: --

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

648: (p_api_name => l_proc,
649: p_argument => 'validation_end_date',
650: p_argument_value => p_validation_end_date);
651: --
652: If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and
653: NOT (dt_api.check_min_max_dates
654: (p_base_table_name => 'ben_pl_f',
655: p_base_key_column => 'pl_id',
656: p_base_key_value => p_pl_id,

Line 736: hr_api.mandatory_arg_error

732: hr_utility.set_location('Entering:'||l_proc, 5);
733: --
734: -- Ensure that the p_datetrack_mode argument is not null
735: --
736: hr_api.mandatory_arg_error
737: (p_api_name => l_proc,
738: p_argument => 'datetrack_mode',
739: p_argument_value => p_datetrack_mode);
740: --

Line 750: hr_api.mandatory_arg_error

746: --
747: --
748: -- Ensure the arguments are not null
749: --
750: hr_api.mandatory_arg_error
751: (p_api_name => l_proc,
752: p_argument => 'validation_start_date',
753: p_argument_value => p_validation_start_date);
754: --

Line 755: hr_api.mandatory_arg_error

751: (p_api_name => l_proc,
752: p_argument => 'validation_start_date',
753: p_argument_value => p_validation_start_date);
754: --
755: hr_api.mandatory_arg_error
756: (p_api_name => l_proc,
757: p_argument => 'validation_end_date',
758: p_argument_value => p_validation_end_date);
759: --

Line 760: hr_api.mandatory_arg_error

756: (p_api_name => l_proc,
757: p_argument => 'validation_end_date',
758: p_argument_value => p_validation_end_date);
759: --
760: hr_api.mandatory_arg_error
761: (p_api_name => l_proc,
762: p_argument => 'pl_dpnt_cvg_ctfn_id',
763: p_argument_value => p_pl_dpnt_cvg_ctfn_id);
764: --

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

804: --
805: -- Call all supporting business operations
806: --
807: --
808: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
809: --
810: chk_pl_dpnt_cvg_ctfn_id
811: (p_pl_dpnt_cvg_ctfn_id => p_rec.pl_dpnt_cvg_ctfn_id,
812: p_effective_date => p_effective_date,

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

878: --
879: -- Call all supporting business operations
880: --
881: --
882: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
883: --
884: chk_pl_dpnt_cvg_ctfn_id
885: (p_pl_dpnt_cvg_ctfn_id => p_rec.pl_dpnt_cvg_ctfn_id,
886: p_effective_date => p_effective_date,

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

996: hr_utility.set_location('Entering:'|| l_proc, 10);
997: --
998: -- Ensure that all the mandatory parameter are not null
999: --
1000: hr_api.mandatory_arg_error(p_api_name => l_proc,
1001: p_argument => 'pl_dpnt_cvg_ctfn_id',
1002: p_argument_value => p_pl_dpnt_cvg_ctfn_id);
1003: --
1004: open csr_leg_code;