APPS.BEN_EPT_BUS dependencies on BEN_EPT_SHD

Line 117: l_api_updating := ben_ept_shd.api_updating

113: Begin
114: --
115: hr_utility.set_location('Entering:'||l_proc, 5);
116: --
117: l_api_updating := ben_ept_shd.api_updating
118: (p_effective_date => p_effective_date,
119: p_elig_per_typ_prte_id => p_elig_per_typ_prte_id,
120: p_object_version_number => p_object_version_number);
121: --

Line 124: <> ben_ept_shd.g_old_rec.elig_per_typ_prte_id) then

120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and nvl(p_elig_per_typ_prte_id,hr_api.g_number)
124: <> ben_ept_shd.g_old_rec.elig_per_typ_prte_id) then
125: --
126: -- raise error as PK has changed
127: --
128: ben_ept_shd.constraint_error('BEN_ELIG_PER_TYP_PK');

Line 128: ben_ept_shd.constraint_error('BEN_ELIG_PER_TYP_PK');

124: <> ben_ept_shd.g_old_rec.elig_per_typ_prte_id) then
125: --
126: -- raise error as PK has changed
127: --
128: ben_ept_shd.constraint_error('BEN_ELIG_PER_TYP_PK');
129: --
130: elsif not l_api_updating then
131: --
132: -- check if PK is null

Line 138: ben_ept_shd.constraint_error('BEN_ELIG_PER_TYP_PK');

134: if p_elig_per_typ_prte_id is not null then
135: --
136: -- raise error as PK is not null
137: --
138: ben_ept_shd.constraint_error('BEN_ELIG_PER_TYP_PK');
139: --
140: end if;
141: --
142: end if;

Line 258: l_api_updating := ben_ept_shd.api_updating

254: Begin
255: --
256: hr_utility.set_location('Entering:'||l_proc,5);
257: --
258: l_api_updating := ben_ept_shd.api_updating
259: (p_elig_per_typ_prte_id => p_elig_per_typ_prte_id,
260: p_effective_date => p_effective_date,
261: p_object_version_number => p_object_version_number);
262: --

Line 265: <> nvl(ben_ept_shd.g_old_rec.per_typ_cd,hr_api.g_number)

261: p_object_version_number => p_object_version_number);
262: --
263: if (l_api_updating
264: and nvl(p_per_typ_cd,hr_api.g_number)
265: <> nvl(ben_ept_shd.g_old_rec.per_typ_cd,hr_api.g_number)
266: or not l_api_updating) then
267: --
268: -- check if per_typ_cd value exists in per_person_types table
269: --

Line 280: ben_ept_shd.constraint_error('BEN_ELIG_PER_TYP_PRTE_FK2');

276: --
277: -- raise error as FK does not relate to PK in per_person_types
278: -- table.
279: --
280: ben_ept_shd.constraint_error('BEN_ELIG_PER_TYP_PRTE_FK2');
281: --
282: end if;
283: --
284: close c1;

Line 312: -- ben_ept_shd.constraint_error('BEN_ELIG_PER_TYP_PRTE_FK2');

308: close c2;
309: --
310: -- raise error as person type can not be set to not employee
311: -- need to create message
312: -- ben_ept_shd.constraint_error('BEN_ELIG_PER_TYP_PRTE_FK2');
313: fnd_message.set_name('BEN', 'BEN_91387_INV_PER_TYPE');
314: fnd_message.raise_error;
315: --
316: end if;

Line 389: l_api_updating := ben_ept_shd.api_updating

385: Begin
386: --
387: hr_utility.set_location('Entering:'||l_proc, 5);
388: --
389: l_api_updating := ben_ept_shd.api_updating
390: (p_effective_date =>p_effective_date,
391: p_elig_per_typ_prte_id => p_elig_per_typ_prte_id,
392: p_object_version_number =>p_object_version_number);
393: --

Line 400: <>nvl(ben_ept_shd.g_old_rec.per_typ_cd,hr_api.g_varchar2)

396: --
397: /* --
398: if (l_api_updating
399: and p_per_typ_cd
400: <>nvl(ben_ept_shd.g_old_rec.per_typ_cd,hr_api.g_varchar2)
401: or not l_api_updating)
402: and p_per_typ_cd is not null then
403: -- */
404: --

Line 407: <>nvl(ben_ept_shd.g_old_rec.person_type_id,hr_api.g_number)

403: -- */
404: --
405: if (l_api_updating
406: and p_person_type_id
407: <>nvl(ben_ept_shd.g_old_rec.person_type_id,hr_api.g_number)
408: or not l_api_updating)
409: and p_person_type_id is not null then
410: --
411: open c1;

Line 470: l_api_updating := ben_ept_shd.api_updating

466: Begin
467: --
468: hr_utility.set_location('Entering:'||l_proc, 5);
469: --
470: l_api_updating := ben_ept_shd.api_updating
471: (p_elig_per_typ_prte_id => p_elig_per_typ_prte_id,
472: p_effective_date => p_effective_date,
473: p_object_version_number => p_object_version_number);
474: --

Line 477: <> nvl(ben_ept_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

473: p_object_version_number => p_object_version_number);
474: --
475: if (l_api_updating
476: and p_excld_flag
477: <> nvl(ben_ept_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
478: or not l_api_updating) then
479: --
480: -- check if value of lookup falls within lookup type.
481: --

Line 767: (p_rec in ben_ept_shd.g_rec_type,

763: -- ----------------------------------------------------------------------------
764: -- |---------------------------< insert_validate >----------------------------|
765: -- ----------------------------------------------------------------------------
766: Procedure insert_validate
767: (p_rec in ben_ept_shd.g_rec_type,
768: p_effective_date in date,
769: p_datetrack_mode in varchar2,
770: p_validation_start_date in date,
771: p_validation_end_date in date) is

Line 830: (p_rec in ben_ept_shd.g_rec_type,

826: -- ----------------------------------------------------------------------------
827: -- |---------------------------< update_validate >----------------------------|
828: -- ----------------------------------------------------------------------------
829: Procedure update_validate
830: (p_rec in ben_ept_shd.g_rec_type,
831: p_effective_date in date,
832: p_datetrack_mode in varchar2,
833: p_validation_start_date in date,
834: p_validation_end_date in date) is

Line 901: (p_rec in ben_ept_shd.g_rec_type,

897: -- ----------------------------------------------------------------------------
898: -- |---------------------------< delete_validate >----------------------------|
899: -- ----------------------------------------------------------------------------
900: Procedure delete_validate
901: (p_rec in ben_ept_shd.g_rec_type,
902: p_effective_date in date,
903: p_datetrack_mode in varchar2,
904: p_validation_start_date in date,
905: p_validation_end_date in date) is