DBA Data[Home] [Help]

APPS.BEN_CRT_BUS dependencies on HR_API

Line 51: and nvl(p_crt_ordr_id,hr_api.g_number)

47: (p_crt_ordr_id => p_crt_ordr_id,
48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating
51: and nvl(p_crt_ordr_id,hr_api.g_number)
52: <> ben_crt_shd.g_old_rec.crt_ordr_id) then
53: --
54: -- raise error as PK has changed
55: --

Line 128: and nvl(p_person_id,hr_api.g_number)

124: (p_crt_ordr_id => p_crt_ordr_id,
125: p_object_version_number => p_object_version_number);
126: --
127: if (l_api_updating
128: and nvl(p_person_id,hr_api.g_number)
129: <> nvl(ben_crt_shd.g_old_rec.person_id,hr_api.g_number)
130: or not l_api_updating) then
131: --
132: -- check if person_id value exists in per_all_people_f table

Line 129: <> nvl(ben_crt_shd.g_old_rec.person_id,hr_api.g_number)

125: p_object_version_number => p_object_version_number);
126: --
127: if (l_api_updating
128: and nvl(p_person_id,hr_api.g_number)
129: <> nvl(ben_crt_shd.g_old_rec.person_id,hr_api.g_number)
130: or not l_api_updating) then
131: --
132: -- check if person_id value exists in per_all_people_f table
133: --

Line 219: and nvl(p_pl_id,hr_api.g_number)

215: (p_crt_ordr_id => p_crt_ordr_id,
216: p_object_version_number => p_object_version_number);
217: --
218: if (l_api_updating
219: and nvl(p_pl_id,hr_api.g_number)
220: <> nvl(ben_crt_shd.g_old_rec.pl_id,hr_api.g_number)
221: or not l_api_updating)
222: and p_pl_id is not null then
223: --

Line 220: <> nvl(ben_crt_shd.g_old_rec.pl_id,hr_api.g_number)

216: p_object_version_number => p_object_version_number);
217: --
218: if (l_api_updating
219: and nvl(p_pl_id,hr_api.g_number)
220: <> nvl(ben_crt_shd.g_old_rec.pl_id,hr_api.g_number)
221: or not l_api_updating)
222: and p_pl_id is not null then
223: --
224: -- check if pl_id value exists in ben_pl_f table

Line 362: and nvl(p_pl_typ_id,hr_api.g_number)

358: (p_crt_ordr_id => p_crt_ordr_id,
359: p_object_version_number => p_object_version_number);
360: --
361: if (l_api_updating
362: and nvl(p_pl_typ_id,hr_api.g_number)
363: <> nvl(ben_crt_shd.g_old_rec.pl_typ_id,hr_api.g_number)
364: or not l_api_updating)
365: and p_pl_typ_id is not null then
366: --

Line 363: <> nvl(ben_crt_shd.g_old_rec.pl_typ_id,hr_api.g_number)

359: p_object_version_number => p_object_version_number);
360: --
361: if (l_api_updating
362: and nvl(p_pl_typ_id,hr_api.g_number)
363: <> nvl(ben_crt_shd.g_old_rec.pl_typ_id,hr_api.g_number)
364: or not l_api_updating)
365: and p_pl_typ_id is not null then
366: --
367: -- check if pl_typ_id value exists in ben_pl_typ_f table

Line 487: <> nvl(ben_crt_shd.g_old_rec.qdro_dstr_mthd_cd,hr_api.g_varchar2)

483: p_object_version_number => p_object_version_number);
484: --
485: if (l_api_updating
486: and p_qdro_dstr_mthd_cd
487: <> nvl(ben_crt_shd.g_old_rec.qdro_dstr_mthd_cd,hr_api.g_varchar2)
488: or not l_api_updating)
489: and p_qdro_dstr_mthd_cd is not null then
490: --
491: -- check if value of lookup falls within lookup type.

Line 494: if hr_api.not_exists_in_hr_lookups

490: --
491: -- check if value of lookup falls within lookup type.
492: --
493: --
494: if hr_api.not_exists_in_hr_lookups
495: (p_lookup_type => 'BEN_QDRO_DSTR_MTHD',
496: p_lookup_code => p_qdro_dstr_mthd_cd,
497: p_effective_date => p_effective_date) then
498: --

Line 558: <> nvl(ben_crt_shd.g_old_rec.qdro_per_perd_cd,hr_api.g_varchar2)

554: p_object_version_number => p_object_version_number);
555: --
556: if (l_api_updating
557: and p_qdro_per_perd_cd
558: <> nvl(ben_crt_shd.g_old_rec.qdro_per_perd_cd,hr_api.g_varchar2)
559: or not l_api_updating)
560: and p_qdro_per_perd_cd is not null then
561: --
562: -- check if value of lookup falls within lookup type.

Line 565: if hr_api.not_exists_in_hr_lookups

561: --
562: -- check if value of lookup falls within lookup type.
563: --
564: --
565: if hr_api.not_exists_in_hr_lookups
566: (p_lookup_type => 'BEN_BNDRY_PERD',
567: p_lookup_code => p_qdro_per_perd_cd,
568: p_effective_date => p_effective_date) then
569: --

Line 629: <> nvl(ben_crt_shd.g_old_rec.crt_ordr_typ_cd,hr_api.g_varchar2)

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

Line 635: if hr_api.not_exists_in_hr_lookups

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

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

747: --
748: -- Call all supporting business operations
749: --
750: --
751: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
752: --
753: chk_crt_ordr_id
754: (p_crt_ordr_id => p_rec.crt_ordr_id,
755: p_object_version_number => p_rec.object_version_number);

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

825: --
826: -- Call all supporting business operations
827: --
828: --
829: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
830: --
831: chk_crt_ordr_id
832: (p_crt_ordr_id => p_rec.crt_ordr_id,
833: p_object_version_number => p_rec.object_version_number);

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

933: hr_utility.set_location('Entering:'|| l_proc, 10);
934: --
935: -- Ensure that all the mandatory parameter are not null
936: --
937: hr_api.mandatory_arg_error(p_api_name => l_proc,
938: p_argument => 'crt_ordr_id',
939: p_argument_value => p_crt_ordr_id);
940: --
941: open csr_leg_code;