APPS.BEN_LRC_BUS dependencies on BEN_LRC_SHD

Line 48: l_api_updating := ben_lrc_shd.api_updating

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

Line 55: <> ben_lrc_shd.g_old_rec.ler_rltd_per_cs_ler_id) then

51: p_object_version_number => p_object_version_number);
52: --
53: if (l_api_updating
54: and nvl(p_ler_rltd_per_cs_ler_id,hr_api.g_number)
55: <> ben_lrc_shd.g_old_rec.ler_rltd_per_cs_ler_id) then
56: --
57: -- raise error as PK has changed
58: --
59: ben_lrc_shd.constraint_error('BEN_LER_RTLD_PER_CS_LER_F_PK');

Line 59: ben_lrc_shd.constraint_error('BEN_LER_RTLD_PER_CS_LER_F_PK');

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

Line 69: ben_lrc_shd.constraint_error('BEN_LER_RTLD_PER_CS_LER_F_PK');

65: if p_ler_rltd_per_cs_ler_id is not null then
66: --
67: -- raise error as PK is not null
68: --
69: ben_lrc_shd.constraint_error('BEN_LER_RTLD_PER_CS_LER_F_PK');
70: --
71: end if;
72: --
73: end if;

Line 149: l_api_updating := ben_lrc_shd.api_updating

145: fnd_message.set_name('BEN', 'BEN_91016_PERSON_CHANGE_REQ');
146: fnd_message.raise_error;
147: end if;
148: --
149: l_api_updating := ben_lrc_shd.api_updating
150: (p_ler_rltd_per_cs_ler_id => p_ler_rltd_per_cs_ler_id,
151: p_effective_date => p_effective_date,
152: p_object_version_number => p_object_version_number);
153:

Line 157: <> nvl(ben_lrc_shd.g_old_rec.rltd_per_chg_cs_ler_id,hr_api.g_number)

153:
154: --
155: if (l_api_updating
156: and nvl(p_rltd_per_chg_cs_ler_id,hr_api.g_number)
157: <> nvl(ben_lrc_shd.g_old_rec.rltd_per_chg_cs_ler_id,hr_api.g_number)
158: or not l_api_updating) then
159: --
160: -- check if rltd_per_chg_cs_ler_id value exists in
161: -- ben_rltd_per_chg_cs_ler_f table

Line 169: ben_lrc_shd.constraint_error('BEN_LER_RLTD_PER_CS_LER_F_FK2');

165: if c1%notfound then
166: close c1;
167: -- raise error as FK does not relate to PK in ben_rltd_per_chg_cs_ler_f
168: -- table.
169: ben_lrc_shd.constraint_error('BEN_LER_RLTD_PER_CS_LER_F_FK2');
170: end if;
171: close c1;
172: -- check if the foreign key is unique for this ler.
173: open c2

Line 249: l_api_updating := ben_lrc_shd.api_updating

245: Begin
246: --
247: hr_utility.set_location('Entering:'||l_proc, 5);
248: --
249: l_api_updating := ben_lrc_shd.api_updating
250: (p_ler_rltd_per_cs_ler_id => p_ler_rltd_per_cs_ler_id,
251: p_effective_date => p_effective_date,
252: p_object_version_number => p_object_version_number);
253: --

Line 256: <> ben_lrc_shd.g_old_rec.ler_rltd_per_cs_chg_rl

252: p_object_version_number => p_object_version_number);
253: --
254: if (l_api_updating
255: and nvl(p_ler_rltd_per_cs_chg_rl,hr_api.g_number)
256: <> ben_lrc_shd.g_old_rec.ler_rltd_per_cs_chg_rl
257: or not l_api_updating)
258: and p_ler_rltd_per_cs_chg_rl is not null then
259: --
260: -- check if value of formula rule is valid.

Line 491: (p_rec in ben_lrc_shd.g_rec_type,

487: -- ----------------------------------------------------------------------------
488: -- |---------------------------< insert_validate >----------------------------|
489: -- ----------------------------------------------------------------------------
490: Procedure insert_validate
491: (p_rec in ben_lrc_shd.g_rec_type,
492: p_effective_date in date,
493: p_datetrack_mode in varchar2,
494: p_validation_start_date in date,
495: p_validation_end_date in date) is

Line 555: (p_rec in ben_lrc_shd.g_rec_type,

551: -- ----------------------------------------------------------------------------
552: -- |---------------------------< update_validate >----------------------------|
553: -- ----------------------------------------------------------------------------
554: Procedure update_validate
555: (p_rec in ben_lrc_shd.g_rec_type,
556: p_effective_date in date,
557: p_datetrack_mode in varchar2,
558: p_validation_start_date in date,
559: p_validation_end_date in date) is

Line 619: (p_rec in ben_lrc_shd.g_rec_type,

615: -- ----------------------------------------------------------------------------
616: -- |---------------------------< delete_validate >----------------------------|
617: -- ----------------------------------------------------------------------------
618: Procedure delete_validate
619: (p_rec in ben_lrc_shd.g_rec_type,
620: p_effective_date in date,
621: p_datetrack_mode in varchar2,
622: p_validation_start_date in date,
623: p_validation_end_date in date) is