DBA Data[Home] [Help]

APPS.BEN_PRT_BUS dependencies on BEN_PRT_SHD

Line 48: l_api_updating := ben_prt_shd.api_updating

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

Line 55: <> ben_prt_shd.g_old_rec.poe_rt_id) then

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

Line 59: ben_prt_shd.constraint_error('BEN_POE_RT_F_PK');

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

Line 69: ben_prt_shd.constraint_error('BEN_POE_RT_F_PK');

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

Line 117: l_api_updating := ben_prt_shd.api_updating

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

Line 124: <> nvl(ben_prt_shd.g_old_rec.poe_nnmntry_uom,hr_api.g_varchar2)

120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and p_poe_nnmntry_uom
124: <> nvl(ben_prt_shd.g_old_rec.poe_nnmntry_uom,hr_api.g_varchar2)
125: or not l_api_updating)
126: and p_poe_nnmntry_uom is not null then
127: --
128: -- check if value of lookup falls within lookup type.

Line 198: l_api_updating := ben_prt_shd.api_updating

194: Begin
195: --
196: hr_utility.set_location('Entering:'||l_proc, 5);
197: --
198: l_api_updating := ben_prt_shd.api_updating
199: (p_poe_rt_id => p_poe_rt_id,
200: p_effective_date => p_effective_date,
201: p_object_version_number => p_object_version_number);
202: --

Line 205: <> ben_prt_shd.g_old_rec.rndg_rl

201: p_object_version_number => p_object_version_number);
202: --
203: if (l_api_updating
204: and nvl(p_rndg_rl,hr_api.g_number)
205: <> ben_prt_shd.g_old_rec.rndg_rl
206: or not l_api_updating)
207: and p_rndg_rl is not null then
208: --
209: -- check if value of formula rule is valid.

Line 274: l_api_updating := ben_prt_shd.api_updating

270: Begin
271: --
272: hr_utility.set_location('Entering:'||l_proc, 5);
273: --
274: l_api_updating := ben_prt_shd.api_updating
275: (p_poe_rt_id => p_poe_rt_id,
276: p_effective_date => p_effective_date,
277: p_object_version_number => p_object_version_number);
278: --

Line 281: <> nvl(ben_prt_shd.g_old_rec.rndg_cd,hr_api.g_varchar2)

277: p_object_version_number => p_object_version_number);
278: --
279: if (l_api_updating
280: and p_rndg_cd
281: <> nvl(ben_prt_shd.g_old_rec.rndg_cd,hr_api.g_varchar2)
282: or not l_api_updating)
283: and p_rndg_cd is not null then
284: --
285: -- check if value of lookup falls within lookup type.

Line 343: l_api_updating := ben_prt_shd.api_updating

339: Begin
340: --
341: hr_utility.set_location('Entering:'||l_proc, 5);
342: --
343: l_api_updating := ben_prt_shd.api_updating
344: (p_poe_rt_id => p_poe_rt_id,
345: p_effective_date => p_effective_date,
346: p_object_version_number => p_object_version_number);
347: --

Line 350: <> nvl(ben_prt_shd.g_old_rec.no_mx_poe_flag,hr_api.g_varchar2)

346: p_object_version_number => p_object_version_number);
347: --
348: if (l_api_updating
349: and p_no_mx_poe_flag
350: <> nvl(ben_prt_shd.g_old_rec.no_mx_poe_flag,hr_api.g_varchar2)
351: or not l_api_updating) then
352: --
353: -- check if value of lookup falls within lookup type.
354: --

Line 412: l_api_updating := ben_prt_shd.api_updating

408: Begin
409: --
410: hr_utility.set_location('Entering:'||l_proc, 5);
411: --
412: l_api_updating := ben_prt_shd.api_updating
413: (p_poe_rt_id => p_poe_rt_id,
414: p_effective_date => p_effective_date,
415: p_object_version_number => p_object_version_number);
416: --

Line 419: <> nvl(ben_prt_shd.g_old_rec.no_mn_poe_flag,hr_api.g_varchar2)

415: p_object_version_number => p_object_version_number);
416: --
417: if (l_api_updating
418: and p_no_mn_poe_flag
419: <> nvl(ben_prt_shd.g_old_rec.no_mn_poe_flag,hr_api.g_varchar2)
420: or not l_api_updating) then
421: --
422: -- check if value of lookup falls within lookup type.
423: --

Line 481: l_api_updating := ben_prt_shd.api_updating

477: Begin
478: --
479: hr_utility.set_location('Entering:'||l_proc, 5);
480: --
481: l_api_updating := ben_prt_shd.api_updating
482: (p_poe_rt_id => p_poe_rt_id,
483: p_effective_date => p_effective_date,
484: p_object_version_number => p_object_version_number);
485: --

Line 488: <> nvl(ben_prt_shd.g_old_rec.cbr_dsblty_apls_flag,hr_api.g_varchar2)

484: p_object_version_number => p_object_version_number);
485: --
486: if (l_api_updating
487: and p_cbr_dsblty_apls_flag
488: <> nvl(ben_prt_shd.g_old_rec.cbr_dsblty_apls_flag,hr_api.g_varchar2)
489: or not l_api_updating) then
490: --
491: -- check if value of lookup falls within lookup type.
492: --

Line 817: (p_rec in ben_prt_shd.g_rec_type,

813: -- ----------------------------------------------------------------------------
814: -- |---------------------------< insert_validate >----------------------------|
815: -- ----------------------------------------------------------------------------
816: Procedure insert_validate
817: (p_rec in ben_prt_shd.g_rec_type,
818: p_effective_date in date,
819: p_datetrack_mode in varchar2,
820: p_validation_start_date in date,
821: p_validation_end_date in date) is

Line 888: (p_rec in ben_prt_shd.g_rec_type,

884: -- ----------------------------------------------------------------------------
885: -- |---------------------------< update_validate >----------------------------|
886: -- ----------------------------------------------------------------------------
887: Procedure update_validate
888: (p_rec in ben_prt_shd.g_rec_type,
889: p_effective_date in date,
890: p_datetrack_mode in varchar2,
891: p_validation_start_date in date,
892: p_validation_end_date in date) is

Line 967: (p_rec in ben_prt_shd.g_rec_type,

963: -- ----------------------------------------------------------------------------
964: -- |---------------------------< delete_validate >----------------------------|
965: -- ----------------------------------------------------------------------------
966: Procedure delete_validate
967: (p_rec in ben_prt_shd.g_rec_type,
968: p_effective_date in date,
969: p_datetrack_mode in varchar2,
970: p_validation_start_date in date,
971: p_validation_end_date in date) is