DBA Data[Home] [Help]

APPS.BEN_PAT_BUS dependencies on BEN_PAT_SHD

Line 49: l_api_updating := ben_pat_shd.api_updating

45: Begin
46: --
47: hr_utility.set_location('Entering:'||l_proc, 5);
48: --
49: l_api_updating := ben_pat_shd.api_updating
50: (p_effective_date => p_effective_date,
51: p_popl_actn_typ_id => p_popl_actn_typ_id,
52: p_object_version_number => p_object_version_number);
53: --

Line 56: <> ben_pat_shd.g_old_rec.popl_actn_typ_id) then

52: p_object_version_number => p_object_version_number);
53: --
54: if (l_api_updating
55: and nvl(p_popl_actn_typ_id,hr_api.g_number)
56: <> ben_pat_shd.g_old_rec.popl_actn_typ_id) then
57: --
58: -- raise error as PK has changed
59: --
60: ben_pat_shd.constraint_error('BEN_POPL_ACTN_TYP_PK');

Line 60: ben_pat_shd.constraint_error('BEN_POPL_ACTN_TYP_PK');

56: <> ben_pat_shd.g_old_rec.popl_actn_typ_id) then
57: --
58: -- raise error as PK has changed
59: --
60: ben_pat_shd.constraint_error('BEN_POPL_ACTN_TYP_PK');
61: --
62: elsif not l_api_updating then
63: --
64: -- check if PK is null

Line 70: ben_pat_shd.constraint_error('BEN_POPL_ACTN_TYP_PK');

66: if p_popl_actn_typ_id is not null then
67: --
68: -- raise error as PK is not null
69: --
70: ben_pat_shd.constraint_error('BEN_POPL_ACTN_TYP_PK');
71: --
72: end if;
73: --
74: end if;

Line 129: l_api_updating := ben_pat_shd.api_updating

125: Begin
126: --
127: hr_utility.set_location('Entering:'||l_proc, 5);
128: --
129: l_api_updating := ben_pat_shd.api_updating
130: (p_popl_actn_typ_id => p_popl_actn_typ_id,
131: p_effective_date => p_effective_date,
132: p_object_version_number => p_object_version_number);
133: --

Line 136: <> ben_pat_shd.g_old_rec.actn_typ_due_dt_rl

132: p_object_version_number => p_object_version_number);
133: --
134: if (l_api_updating
135: and nvl(p_actn_typ_due_dt_rl,hr_api.g_number)
136: <> ben_pat_shd.g_old_rec.actn_typ_due_dt_rl
137: or not l_api_updating)
138: and p_actn_typ_due_dt_rl is not null then
139: --
140: -- check if value of formula rule is valid.

Line 206: l_api_updating := ben_pat_shd.api_updating

202: Begin
203: --
204: hr_utility.set_location('Entering:'||l_proc, 5);
205: --
206: l_api_updating := ben_pat_shd.api_updating
207: (p_popl_actn_typ_id => p_popl_actn_typ_id,
208: p_effective_date => p_effective_date,
209: p_object_version_number => p_object_version_number);
210: --

Line 213: <> nvl(ben_pat_shd.g_old_rec.actn_typ_due_dt_cd,hr_api.g_varchar2)

209: p_object_version_number => p_object_version_number);
210: --
211: if (l_api_updating
212: and p_actn_typ_due_dt_cd
213: <> nvl(ben_pat_shd.g_old_rec.actn_typ_due_dt_cd,hr_api.g_varchar2)
214: or not l_api_updating)
215: and p_actn_typ_due_dt_cd is not null then
216: --
217: -- check if value of lookup falls within lookup type.

Line 282: l_api_updating := ben_pat_shd.api_updating

278: Begin
279: --
280: hr_utility.set_location('Entering:'||l_proc, 5);
281: --
282: l_api_updating := ben_pat_shd.api_updating
283: (p_popl_actn_typ_id => p_popl_actn_typ_id,
284: p_effective_date => p_effective_date,
285: p_object_version_number => p_object_version_number);
286: --

Line 289: <> nvl(ben_pat_shd.g_old_rec.actn_typ_due_dt_cd,hr_api.g_varchar2) or

285: p_object_version_number => p_object_version_number);
286: --
287: if (l_api_updating
288: and (nvl(p_actn_typ_due_dt_cd,hr_api.g_varchar2)
289: <> nvl(ben_pat_shd.g_old_rec.actn_typ_due_dt_cd,hr_api.g_varchar2) or
290: nvl(p_actn_typ_due_dt_rl,hr_api.g_number)
291: <> nvl(ben_pat_shd.g_old_rec.actn_typ_due_dt_rl,hr_api.g_number))
292: or not l_api_updating) then
293: --

Line 291: <> nvl(ben_pat_shd.g_old_rec.actn_typ_due_dt_rl,hr_api.g_number))

287: if (l_api_updating
288: and (nvl(p_actn_typ_due_dt_cd,hr_api.g_varchar2)
289: <> nvl(ben_pat_shd.g_old_rec.actn_typ_due_dt_cd,hr_api.g_varchar2) or
290: nvl(p_actn_typ_due_dt_rl,hr_api.g_number)
291: <> nvl(ben_pat_shd.g_old_rec.actn_typ_due_dt_rl,hr_api.g_number))
292: or not l_api_updating) then
293: --
294: if (p_actn_typ_due_dt_cd = 'RL' and p_actn_typ_due_dt_rl is null) then
295: --

Line 534: (p_rec in ben_pat_shd.g_rec_type,

530: -- ----------------------------------------------------------------------------
531: -- |---------------------------< insert_validate >----------------------------|
532: -- ----------------------------------------------------------------------------
533: Procedure insert_validate
534: (p_rec in ben_pat_shd.g_rec_type,
535: p_effective_date in date,
536: p_datetrack_mode in varchar2,
537: p_validation_start_date in date,
538: p_validation_end_date in date) is

Line 581: (p_rec in ben_pat_shd.g_rec_type,

577: -- ----------------------------------------------------------------------------
578: -- |---------------------------< update_validate >----------------------------|
579: -- ----------------------------------------------------------------------------
580: Procedure update_validate
581: (p_rec in ben_pat_shd.g_rec_type,
582: p_effective_date in date,
583: p_datetrack_mode in varchar2,
584: p_validation_start_date in date,
585: p_validation_end_date in date) is

Line 637: (p_rec in ben_pat_shd.g_rec_type,

633: -- ----------------------------------------------------------------------------
634: -- |---------------------------< delete_validate >----------------------------|
635: -- ----------------------------------------------------------------------------
636: Procedure delete_validate
637: (p_rec in ben_pat_shd.g_rec_type,
638: p_effective_date in date,
639: p_datetrack_mode in varchar2,
640: p_validation_start_date in date,
641: p_validation_end_date in date) is