APPS.BEN_PGC_BUS dependencies on HR_API

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

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

Line 127: and pgm_dpnt_cvg_ctfn_id<> nvl(p_pgm_dpnt_cvg_ctfn_id, hr_api.g_number)

123: select null
124: from ben_pgm_dpnt_cvg_ctfn_f
125: where nvl(dpnt_cvg_ctfn_typ_cd,0) = nvl(p_dpnt_cvg_ctfn_typ_cd,0)
126: and nvl(rlshp_typ_cd,0) = nvl(p_rlshp_typ_cd,0)
127: and pgm_dpnt_cvg_ctfn_id<> nvl(p_pgm_dpnt_cvg_ctfn_id, hr_api.g_number)
128: and pgm_id = p_pgm_id
129: and business_group_id + 0 = p_business_group_id
130: and p_validation_start_date <= effective_end_date
131: and p_validation_end_date >= effective_start_date;

Line 144: <> nvl(ben_pgc_shd.g_old_rec.dpnt_cvg_ctfn_typ_cd,hr_api.g_varchar2)

140: p_object_version_number => p_object_version_number);
141: --
142: if (l_api_updating
143: and p_dpnt_cvg_ctfn_typ_cd
144: <> nvl(ben_pgc_shd.g_old_rec.dpnt_cvg_ctfn_typ_cd,hr_api.g_varchar2)
145: or not l_api_updating) then
146: --
147: -- check if value of lookup falls within lookup type.
148: --

Line 150: if hr_api.not_exists_in_hr_lookups

146: --
147: -- check if value of lookup falls within lookup type.
148: --
149: --
150: if hr_api.not_exists_in_hr_lookups
151: (p_lookup_type => 'BEN_DPNT_CVG_CTFN_TYP',
152: p_lookup_code => p_dpnt_cvg_ctfn_typ_cd,
153: p_effective_date => p_effective_date) then
154: --

Line 231: and pgm_dpnt_cvg_ctfn_id<> nvl(p_pgm_dpnt_cvg_ctfn_id, hr_api.g_number)

227: select null
228: from ben_pgm_dpnt_cvg_ctfn_f
229: where pfd_flag = p_pfd_flag
230: and pfd_flag = 'Y'
231: and pgm_dpnt_cvg_ctfn_id<> nvl(p_pgm_dpnt_cvg_ctfn_id, hr_api.g_number)
232: and pgm_id = p_pgm_id
233: and business_group_id + 0 = p_business_group_id
234: and p_validation_start_date <= effective_end_date
235: and p_validation_end_date >= effective_start_date;

Line 248: <> nvl(ben_pgc_shd.g_old_rec.pfd_flag,hr_api.g_varchar2)

244: p_object_version_number => p_object_version_number);
245: --
246: if (l_api_updating
247: and p_pfd_flag
248: <> nvl(ben_pgc_shd.g_old_rec.pfd_flag,hr_api.g_varchar2)
249: or not l_api_updating)
250: and p_pfd_flag is not null then
251: --
252: -- check if value of lookup falls within lookup type.

Line 254: if hr_api.not_exists_in_hr_lookups

250: and p_pfd_flag is not null then
251: --
252: -- check if value of lookup falls within lookup type.
253: --
254: if hr_api.not_exists_in_hr_lookups
255: (p_lookup_type => 'YES_NO',
256: p_lookup_code => p_pfd_flag,
257: p_effective_date => p_effective_date) then
258: --

Line 333: <> nvl(ben_pgc_shd.g_old_rec.pfd_flag,hr_api.g_varchar2)

329: p_object_version_number => p_object_version_number);
330: --
331: if (l_api_updating
332: and p_rqd_flag
333: <> nvl(ben_pgc_shd.g_old_rec.pfd_flag,hr_api.g_varchar2)
334: or not l_api_updating)
335: and p_rqd_flag is not null then
336: --
337: -- check if value of lookup falls within lookup type.

Line 339: if hr_api.not_exists_in_hr_lookups

335: and p_rqd_flag is not null then
336: --
337: -- check if value of lookup falls within lookup type.
338: --
339: if hr_api.not_exists_in_hr_lookups
340: (p_lookup_type => 'YES_NO',
341: p_lookup_code => p_rqd_flag,
342: p_effective_date => p_effective_date) then
343: --

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

414: p_effective_date => p_effective_date,
415: p_object_version_number => p_object_version_number);
416: --
417: if (l_api_updating
418: and nvl(p_ctfn_rqd_when_rl,hr_api.g_number)
419: <> ben_pgc_shd.g_old_rec.ctfn_rqd_when_rl
420: or not l_api_updating)
421: and p_ctfn_rqd_when_rl is not null then
422: --

Line 497: <> nvl(ben_pgc_shd.g_old_rec.lack_ctfn_sspnd_enrt_flag,hr_api.g_varchar2)

493: p_object_version_number => p_object_version_number);
494: --
495: if (l_api_updating
496: and p_lack_ctfn_sspnd_enrt_flag
497: <> nvl(ben_pgc_shd.g_old_rec.lack_ctfn_sspnd_enrt_flag,hr_api.g_varchar2)
498: or not l_api_updating)
499: and p_lack_ctfn_sspnd_enrt_flag is not null then
500: --
501: -- check if value of lookup falls within lookup type.

Line 503: if hr_api.not_exists_in_hr_lookups

499: and p_lack_ctfn_sspnd_enrt_flag is not null then
500: --
501: -- check if value of lookup falls within lookup type.
502: --
503: if hr_api.not_exists_in_hr_lookups
504: (p_lookup_type => 'YES_NO',
505: p_lookup_code => p_lack_ctfn_sspnd_enrt_flag,
506: p_effective_date => p_effective_date) then
507: --

Line 551: (p_ctfn_rqd_when_rl in number default hr_api.g_number,

547: --
548: -- {End Of Comments}
549: -- ----------------------------------------------------------------------------
550: Procedure dt_update_validate
551: (p_ctfn_rqd_when_rl in number default hr_api.g_number,
552: p_pgm_id in number default hr_api.g_number,
553: p_datetrack_mode in varchar2,
554: p_validation_start_date in date,
555: p_validation_end_date in date) Is

Line 552: p_pgm_id in number default hr_api.g_number,

548: -- {End Of Comments}
549: -- ----------------------------------------------------------------------------
550: Procedure dt_update_validate
551: (p_ctfn_rqd_when_rl in number default hr_api.g_number,
552: p_pgm_id in number default hr_api.g_number,
553: p_datetrack_mode in varchar2,
554: p_validation_start_date in date,
555: p_validation_end_date in date) Is
556: --

Line 566: hr_api.mandatory_arg_error

562: hr_utility.set_location('Entering:'||l_proc, 5);
563: --
564: -- Ensure that the p_datetrack_mode argument is not null
565: --
566: hr_api.mandatory_arg_error
567: (p_api_name => l_proc,
568: p_argument => 'datetrack_mode',
569: p_argument_value => p_datetrack_mode);
570: --

Line 578: hr_api.mandatory_arg_error

574: --
575: --
576: -- Ensure the arguments are not null
577: --
578: hr_api.mandatory_arg_error
579: (p_api_name => l_proc,
580: p_argument => 'validation_start_date',
581: p_argument_value => p_validation_start_date);
582: --

Line 583: hr_api.mandatory_arg_error

579: (p_api_name => l_proc,
580: p_argument => 'validation_start_date',
581: p_argument_value => p_validation_start_date);
582: --
583: hr_api.mandatory_arg_error
584: (p_api_name => l_proc,
585: p_argument => 'validation_end_date',
586: p_argument_value => p_validation_end_date);
587: --

Line 588: If ((nvl(p_ctfn_rqd_when_rl, hr_api.g_number) <> hr_api.g_number) and

584: (p_api_name => l_proc,
585: p_argument => 'validation_end_date',
586: p_argument_value => p_validation_end_date);
587: --
588: If ((nvl(p_ctfn_rqd_when_rl, hr_api.g_number) <> hr_api.g_number) and
589: NOT (dt_api.check_min_max_dates
590: (p_base_table_name => 'ff_formulas_f',
591: p_base_key_column => 'formula_id',
592: p_base_key_value => p_ctfn_rqd_when_rl,

Line 598: If ((nvl(p_pgm_id, hr_api.g_number) <> hr_api.g_number) and

594: p_to_date => p_validation_end_date))) Then
595: l_table_name := 'ff_formulas_f';
596: Raise l_integrity_error;
597: End If;
598: If ((nvl(p_pgm_id, hr_api.g_number) <> hr_api.g_number) and
599: NOT (dt_api.check_min_max_dates
600: (p_base_table_name => 'ben_pgm_f',
601: p_base_key_column => 'pgm_id',
602: p_base_key_value => p_pgm_id,

Line 680: hr_api.mandatory_arg_error

676: hr_utility.set_location('Entering:'||l_proc, 5);
677: --
678: -- Ensure that the p_datetrack_mode argument is not null
679: --
680: hr_api.mandatory_arg_error
681: (p_api_name => l_proc,
682: p_argument => 'datetrack_mode',
683: p_argument_value => p_datetrack_mode);
684: --

Line 694: hr_api.mandatory_arg_error

690: --
691: --
692: -- Ensure the arguments are not null
693: --
694: hr_api.mandatory_arg_error
695: (p_api_name => l_proc,
696: p_argument => 'validation_start_date',
697: p_argument_value => p_validation_start_date);
698: --

Line 699: hr_api.mandatory_arg_error

695: (p_api_name => l_proc,
696: p_argument => 'validation_start_date',
697: p_argument_value => p_validation_start_date);
698: --
699: hr_api.mandatory_arg_error
700: (p_api_name => l_proc,
701: p_argument => 'validation_end_date',
702: p_argument_value => p_validation_end_date);
703: --

Line 704: hr_api.mandatory_arg_error

700: (p_api_name => l_proc,
701: p_argument => 'validation_end_date',
702: p_argument_value => p_validation_end_date);
703: --
704: hr_api.mandatory_arg_error
705: (p_api_name => l_proc,
706: p_argument => 'pgm_dpnt_cvg_ctfn_id',
707: p_argument_value => p_pgm_dpnt_cvg_ctfn_id);
708: --

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

746: --
747: -- Call all supporting business operations
748: --
749: --
750: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
751: --
752: chk_pgm_dpnt_cvg_ctfn_id
753: (p_pgm_dpnt_cvg_ctfn_id => p_rec.pgm_dpnt_cvg_ctfn_id,
754: p_effective_date => p_effective_date,

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

814: --
815: -- Call all supporting business operations
816: --
817: --
818: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
819: --
820: chk_pgm_dpnt_cvg_ctfn_id
821: (p_pgm_dpnt_cvg_ctfn_id => p_rec.pgm_dpnt_cvg_ctfn_id,
822: p_effective_date => p_effective_date,

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

927: hr_utility.set_location('Entering:'|| l_proc, 10);
928: --
929: -- Ensure that all the mandatory parameter are not null
930: --
931: hr_api.mandatory_arg_error(p_api_name => l_proc,
932: p_argument => 'pgm_dpnt_cvg_ctfn_id',
933: p_argument_value => p_pgm_dpnt_cvg_ctfn_id);
934: --
935: open csr_leg_code;