DBA Data[Home] [Help]

APPS.BEN_PRD_BUS dependencies on BEN_PRD_SHD

Line 48: l_api_updating := ben_prd_shd.api_updating

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

Line 55: <> ben_prd_shd.g_old_rec.paird_rt_id) then

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

Line 59: ben_prd_shd.constraint_error('BEN_PAIRD_RT_PK');

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

Line 69: ben_prd_shd.constraint_error('BEN_PAIRD_RT_PK');

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

Line 117: l_api_updating := ben_prd_shd.api_updating

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

Line 124: <> nvl(ben_prd_shd.g_old_rec.no_cmbnd_mn_amt_dfnd_flag,hr_api.g_varchar2)

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

Line 186: l_api_updating := ben_prd_shd.api_updating

182: Begin
183: --
184: hr_utility.set_location('Entering:'||l_proc, 5);
185: --
186: l_api_updating := ben_prd_shd.api_updating
187: (p_paird_rt_id => p_paird_rt_id,
188: p_effective_date => p_effective_date,
189: p_object_version_number => p_object_version_number);
190: --

Line 193: <> nvl(ben_prd_shd.g_old_rec.no_cmbnd_mx_amt_dfnd_flag,hr_api.g_varchar2)

189: p_object_version_number => p_object_version_number);
190: --
191: if (l_api_updating
192: and p_no_cmbnd_mx_amt_dfnd_flag
193: <> nvl(ben_prd_shd.g_old_rec.no_cmbnd_mx_amt_dfnd_flag,hr_api.g_varchar2)
194: or not l_api_updating) then
195: --
196: -- check if value of lookup falls within lookup type.
197: --

Line 255: l_api_updating := ben_prd_shd.api_updating

251: Begin
252: --
253: hr_utility.set_location('Entering:'||l_proc, 5);
254: --
255: l_api_updating := ben_prd_shd.api_updating
256: (p_paird_rt_id => p_paird_rt_id,
257: p_effective_date => p_effective_date,
258: p_object_version_number => p_object_version_number);
259: --

Line 262: <> nvl(ben_prd_shd.g_old_rec.use_parnt_pymt_sched_flag,hr_api.g_varchar2)

258: p_object_version_number => p_object_version_number);
259: --
260: if (l_api_updating
261: and p_use_parnt_pymt_sched_flag
262: <> nvl(ben_prd_shd.g_old_rec.use_parnt_pymt_sched_flag,hr_api.g_varchar2)
263: or not l_api_updating) then
264: --
265: -- check if value of lookup falls within lookup type.
266: --

Line 324: l_api_updating := ben_prd_shd.api_updating

320: Begin
321: --
322: hr_utility.set_location('Entering:'||l_proc, 5);
323: --
324: l_api_updating := ben_prd_shd.api_updating
325: (p_paird_rt_id => p_paird_rt_id,
326: p_effective_date => p_effective_date,
327: p_object_version_number => p_object_version_number);
328: --

Line 331: <> nvl(ben_prd_shd.g_old_rec.alloc_sme_as_parnt_flag,hr_api.g_varchar2)

327: p_object_version_number => p_object_version_number);
328: --
329: if (l_api_updating
330: and p_alloc_sme_as_parnt_flag
331: <> nvl(ben_prd_shd.g_old_rec.alloc_sme_as_parnt_flag,hr_api.g_varchar2)
332: or not l_api_updating) then
333: --
334: -- check if value of lookup falls within lookup type.
335: --

Line 393: l_api_updating := ben_prd_shd.api_updating

389: Begin
390: --
391: hr_utility.set_location('Entering:'||l_proc, 5);
392: --
393: l_api_updating := ben_prd_shd.api_updating
394: (p_paird_rt_id => p_paird_rt_id,
395: p_effective_date => p_effective_date,
396: p_object_version_number => p_object_version_number);
397: --

Line 400: <> nvl(ben_prd_shd.g_old_rec.use_parnt_prtl_mo_cd_flag,hr_api.g_varchar2)

396: p_object_version_number => p_object_version_number);
397: --
398: if (l_api_updating
399: and p_use_parnt_prtl_mo_cd_flag
400: <> nvl(ben_prd_shd.g_old_rec.use_parnt_prtl_mo_cd_flag,hr_api.g_varchar2)
401: or not l_api_updating) then
402: --
403: -- check if value of lookup falls within lookup type.
404: --

Line 462: l_api_updating := ben_prd_shd.api_updating

458: Begin
459: --
460: hr_utility.set_location('Entering:'||l_proc, 5);
461: --
462: l_api_updating := ben_prd_shd.api_updating
463: (p_paird_rt_id => p_paird_rt_id,
464: p_effective_date => p_effective_date,
465: p_object_version_number => p_object_version_number);
466: --

Line 469: <> nvl(ben_prd_shd.g_old_rec.asn_on_chc_of_parnt_flag,hr_api.g_varchar2)

465: p_object_version_number => p_object_version_number);
466: --
467: if (l_api_updating
468: and p_asn_on_chc_of_parnt_flag
469: <> nvl(ben_prd_shd.g_old_rec.asn_on_chc_of_parnt_flag,hr_api.g_varchar2)
470: or not l_api_updating) then
471: --
472: -- check if value of lookup falls within lookup type.
473: --

Line 531: l_api_updating := ben_prd_shd.api_updating

527: Begin
528: --
529: hr_utility.set_location('Entering:'||l_proc, 5);
530: --
531: l_api_updating := ben_prd_shd.api_updating
532: (p_paird_rt_id => p_paird_rt_id,
533: p_effective_date => p_effective_date,
534: p_object_version_number => p_object_version_number);
535: --

Line 538: <> nvl(ben_prd_shd.g_old_rec.use_parnt_ded_sched_flag,hr_api.g_varchar2)

534: p_object_version_number => p_object_version_number);
535: --
536: if (l_api_updating
537: and p_use_parnt_ded_sched_flag
538: <> nvl(ben_prd_shd.g_old_rec.use_parnt_ded_sched_flag,hr_api.g_varchar2)
539: or not l_api_updating) then
540: --
541: -- check if value of lookup falls within lookup type.
542: --

Line 600: l_api_updating := ben_prd_shd.api_updating

596: Begin
597: --
598: hr_utility.set_location('Entering:'||l_proc, 5);
599: --
600: l_api_updating := ben_prd_shd.api_updating
601: (p_paird_rt_id => p_paird_rt_id,
602: p_effective_date => p_effective_date,
603: p_object_version_number => p_object_version_number);
604: --

Line 607: <> nvl(ben_prd_shd.g_old_rec.no_cmbnd_mx_pct_dfnd_flag,hr_api.g_varchar2)

603: p_object_version_number => p_object_version_number);
604: --
605: if (l_api_updating
606: and p_no_cmbnd_mx_pct_dfnd_flag
607: <> nvl(ben_prd_shd.g_old_rec.no_cmbnd_mx_pct_dfnd_flag,hr_api.g_varchar2)
608: or not l_api_updating) then
609: --
610: -- check if value of lookup falls within lookup type.
611: --

Line 669: l_api_updating := ben_prd_shd.api_updating

665: Begin
666: --
667: hr_utility.set_location('Entering:'||l_proc, 5);
668: --
669: l_api_updating := ben_prd_shd.api_updating
670: (p_paird_rt_id => p_paird_rt_id,
671: p_effective_date => p_effective_date,
672: p_object_version_number => p_object_version_number);
673: --

Line 676: <> nvl(ben_prd_shd.g_old_rec.no_cmbnd_mn_pct_dfnd_flag,hr_api.g_varchar2)

672: p_object_version_number => p_object_version_number);
673: --
674: if (l_api_updating
675: and p_no_cmbnd_mn_pct_dfnd_flag
676: <> nvl(ben_prd_shd.g_old_rec.no_cmbnd_mn_pct_dfnd_flag,hr_api.g_varchar2)
677: or not l_api_updating) then
678: --
679: -- check if value of lookup falls within lookup type.
680: --

Line 1159: (p_rec in ben_prd_shd.g_rec_type,

1155: -- ----------------------------------------------------------------------------
1156: -- |---------------------------< insert_validate >----------------------------|
1157: -- ----------------------------------------------------------------------------
1158: Procedure insert_validate
1159: (p_rec in ben_prd_shd.g_rec_type,
1160: p_effective_date in date,
1161: p_datetrack_mode in varchar2,
1162: p_validation_start_date in date,
1163: p_validation_end_date in date) is

Line 1257: (p_rec in ben_prd_shd.g_rec_type,

1253: -- ----------------------------------------------------------------------------
1254: -- |---------------------------< update_validate >----------------------------|
1255: -- ----------------------------------------------------------------------------
1256: Procedure update_validate
1257: (p_rec in ben_prd_shd.g_rec_type,
1258: p_effective_date in date,
1259: p_datetrack_mode in varchar2,
1260: p_validation_start_date in date,
1261: p_validation_end_date in date) is

Line 1364: (p_rec in ben_prd_shd.g_rec_type,

1360: -- ----------------------------------------------------------------------------
1361: -- |---------------------------< delete_validate >----------------------------|
1362: -- ----------------------------------------------------------------------------
1363: Procedure delete_validate
1364: (p_rec in ben_prd_shd.g_rec_type,
1365: p_effective_date in date,
1366: p_datetrack_mode in varchar2,
1367: p_validation_start_date in date,
1368: p_validation_end_date in date) is