eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_PRV_BUS dependencies on BEN_PRV_SHD

Line 46: l_api_updating := ben_prv_shd.api_updating

42: Begin
43: --
44: hr_utility.set_location('Entering:'||l_proc, 5);
45: --
46: l_api_updating := ben_prv_shd.api_updating
47: (p_prtt_rt_val_id => p_prtt_rt_val_id,
48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating

Line 52: <> ben_prv_shd.g_old_rec.prtt_rt_val_id) then

48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating
51: and nvl(p_prtt_rt_val_id,hr_api.g_number)
52: <> ben_prv_shd.g_old_rec.prtt_rt_val_id) then
53: --
54: -- raise error as PK has changed
55: --
56: ben_prv_shd.constraint_error('BEN_PRTT_RT_VAL_PK');

Line 56: ben_prv_shd.constraint_error('BEN_PRTT_RT_VAL_PK');

52: <> ben_prv_shd.g_old_rec.prtt_rt_val_id) then
53: --
54: -- raise error as PK has changed
55: --
56: ben_prv_shd.constraint_error('BEN_PRTT_RT_VAL_PK');
57: --
58: elsif not l_api_updating then
59: --
60: -- check if PK is null

Line 66: ben_prv_shd.constraint_error('BEN_PRTT_RT_VAL_PK');

62: if p_prtt_rt_val_id is not null then
63: --
64: -- raise error as PK is not null
65: --
66: ben_prv_shd.constraint_error('BEN_PRTT_RT_VAL_PK');
67: --
68: end if;
69: --
70: end if;

Line 123: l_api_updating := ben_prv_shd.api_updating

119: Begin
120: --
121: hr_utility.set_location('Entering:'||l_proc,5);
122: --
123: l_api_updating := ben_prv_shd.api_updating
124: (p_prtt_rt_val_id => p_prtt_rt_val_id,
125: p_object_version_number => p_object_version_number);
126: --
127: if (l_api_updating

Line 129: <> nvl(ben_prv_shd.g_old_rec.prtt_enrt_rslt_id,hr_api.g_number)

125: p_object_version_number => p_object_version_number);
126: --
127: if (l_api_updating
128: and nvl(p_prtt_enrt_rslt_id,hr_api.g_number)
129: <> nvl(ben_prv_shd.g_old_rec.prtt_enrt_rslt_id,hr_api.g_number)
130: or not l_api_updating) then
131: --
132: -- check if prtt_enrt_rslt_id value exists in ben_prtt_enrt_rslt_f table
133: --

Line 144: ben_prv_shd.constraint_error('BEN_PRTT_RT_VAL_DT1');

140: --
141: -- raise error as FK does not relate to PK in ben_prtt_enrt_rslt_f
142: -- table.
143: --
144: ben_prv_shd.constraint_error('BEN_PRTT_RT_VAL_DT1');
145: --
146: end if;
147: --
148: close c1;

Line 203: l_api_updating := ben_prv_shd.api_updating

199: Begin
200: --
201: hr_utility.set_location('Entering:'||l_proc,5);
202: --
203: l_api_updating := ben_prv_shd.api_updating
204: (p_prtt_rt_val_id => p_prtt_rt_val_id,
205: p_object_version_number => p_object_version_number);
206: --
207: if (l_api_updating

Line 209: <> nvl(ben_prv_shd.g_old_rec.element_entry_value_id,hr_api.g_number)

205: p_object_version_number => p_object_version_number);
206: --
207: if (l_api_updating
208: and nvl(p_element_entry_value_id,hr_api.g_number)
209: <> nvl(ben_prv_shd.g_old_rec.element_entry_value_id,hr_api.g_number)
210: or not l_api_updating) then
211: --
212: -- check if element_entry_value_id value exists in pay_element_entry_values_f table
213: --

Line 224: ben_prv_shd.constraint_error('BEN_PRTT_RT_VAL_DT2');

220: --
221: -- raise error as FK does not relate to PK in pay_element_entry_values_f
222: -- table.
223: --
224: ben_prv_shd.constraint_error('BEN_PRTT_RT_VAL_DT2');
225: --
226: end if;
227: --
228: close c1;

Line 274: l_api_updating := ben_prv_shd.api_updating

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

Line 280: <> nvl(ben_prv_shd.g_old_rec.cmcd_ref_perd_cd,hr_api.g_varchar2)

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

Line 343: l_api_updating := ben_prv_shd.api_updating

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

Line 349: <> nvl(ben_prv_shd.g_old_rec.prtt_rt_val_stat_cd,hr_api.g_varchar2)

345: p_object_version_number => p_object_version_number);
346: --
347: if (l_api_updating
348: and p_prtt_rt_val_stat_cd
349: <> nvl(ben_prv_shd.g_old_rec.prtt_rt_val_stat_cd,hr_api.g_varchar2)
350: or not l_api_updating)
351: and p_prtt_rt_val_stat_cd is not null then
352: --
353: -- check if value of lookup falls within lookup type.

Line 413: l_api_updating := ben_prv_shd.api_updating

409: Begin
410: --
411: hr_utility.set_location('Entering:'||l_proc, 5);
412: --
413: l_api_updating := ben_prv_shd.api_updating
414: (p_prtt_rt_val_id => p_prtt_rt_val_id,
415: p_object_version_number => p_object_version_number);
416: --
417: if (l_api_updating

Line 419: <> nvl(ben_prv_shd.g_old_rec.bnft_rt_typ_cd,hr_api.g_varchar2)

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

Line 483: l_api_updating := ben_prv_shd.api_updating

479: Begin
480: --
481: hr_utility.set_location('Entering:'||l_proc, 5);
482: --
483: l_api_updating := ben_prv_shd.api_updating
484: (p_prtt_rt_val_id => p_prtt_rt_val_id,
485: p_object_version_number => p_object_version_number);
486: --
487: if (l_api_updating

Line 489: <> nvl(ben_prv_shd.g_old_rec.acty_ref_perd_cd,hr_api.g_varchar2)

485: p_object_version_number => p_object_version_number);
486: --
487: if (l_api_updating
488: and p_acty_ref_perd_cd
489: <> nvl(ben_prv_shd.g_old_rec.acty_ref_perd_cd,hr_api.g_varchar2)
490: or not l_api_updating)
491: and p_acty_ref_perd_cd is not null then
492: --
493: -- check if value of lookup falls within lookup type.

Line 553: l_api_updating := ben_prv_shd.api_updating

549: Begin
550: --
551: hr_utility.set_location('Entering:'||l_proc, 5);
552: --
553: l_api_updating := ben_prv_shd.api_updating
554: (p_prtt_rt_val_id => p_prtt_rt_val_id,
555: p_object_version_number => p_object_version_number);
556: --
557: if (l_api_updating

Line 559: <> nvl(ben_prv_shd.g_old_rec.mlt_cd,hr_api.g_varchar2)

555: p_object_version_number => p_object_version_number);
556: --
557: if (l_api_updating
558: and p_mlt_cd
559: <> nvl(ben_prv_shd.g_old_rec.mlt_cd,hr_api.g_varchar2)
560: or not l_api_updating)
561: and p_mlt_cd is not null then
562: --
563: -- check if value of lookup falls within lookup type.

Line 623: l_api_updating := ben_prv_shd.api_updating

619: Begin
620: --
621: hr_utility.set_location('Entering:'||l_proc, 5);
622: --
623: l_api_updating := ben_prv_shd.api_updating
624: (p_prtt_rt_val_id => p_prtt_rt_val_id,
625: p_object_version_number => p_object_version_number);
626: --
627: if (l_api_updating

Line 629: <> nvl(ben_prv_shd.g_old_rec.acty_typ_cd,hr_api.g_varchar2)

625: p_object_version_number => p_object_version_number);
626: --
627: if (l_api_updating
628: and p_acty_typ_cd
629: <> nvl(ben_prv_shd.g_old_rec.acty_typ_cd,hr_api.g_varchar2)
630: or not l_api_updating)
631: and p_acty_typ_cd is not null then
632: --
633: -- check if value of lookup falls within lookup type.

Line 693: l_api_updating := ben_prv_shd.api_updating

689: Begin
690: --
691: hr_utility.set_location('Entering:'||l_proc, 5);
692: --
693: l_api_updating := ben_prv_shd.api_updating
694: (p_prtt_rt_val_id => p_prtt_rt_val_id,
695: p_object_version_number => p_object_version_number);
696: --
697: if (l_api_updating

Line 699: <> nvl(ben_prv_shd.g_old_rec.tx_typ_cd,hr_api.g_varchar2)

695: p_object_version_number => p_object_version_number);
696: --
697: if (l_api_updating
698: and p_tx_typ_cd
699: <> nvl(ben_prv_shd.g_old_rec.tx_typ_cd,hr_api.g_varchar2)
700: or not l_api_updating)
701: and p_tx_typ_cd is not null then
702: --
703: -- check if value of lookup falls within lookup type.

Line 763: l_api_updating := ben_prv_shd.api_updating

759: Begin
760: --
761: hr_utility.set_location('Entering:'||l_proc, 5);
762: --
763: l_api_updating := ben_prv_shd.api_updating
764: (p_prtt_rt_val_id => p_prtt_rt_val_id,
765: p_object_version_number => p_object_version_number);
766: --
767: if (l_api_updating

Line 769: <> nvl(ben_prv_shd.g_old_rec.rt_typ_cd,hr_api.g_varchar2)

765: p_object_version_number => p_object_version_number);
766: --
767: if (l_api_updating
768: and p_rt_typ_cd
769: <> nvl(ben_prv_shd.g_old_rec.rt_typ_cd,hr_api.g_varchar2)
770: or not l_api_updating)
771: and p_rt_typ_cd is not null then
772: --
773: -- check if value of lookup falls within lookup type.

Line 833: l_api_updating := ben_prv_shd.api_updating

829: Begin
830: --
831: hr_utility.set_location('Entering:'||l_proc, 5);
832: --
833: l_api_updating := ben_prv_shd.api_updating
834: (p_prtt_rt_val_id => p_prtt_rt_val_id,
835: p_object_version_number => p_object_version_number);
836: --
837: if (l_api_updating

Line 839: <> nvl(ben_prv_shd.g_old_rec.rt_ovridn_flag,hr_api.g_varchar2)

835: p_object_version_number => p_object_version_number);
836: --
837: if (l_api_updating
838: and p_rt_ovridn_flag
839: <> nvl(ben_prv_shd.g_old_rec.rt_ovridn_flag,hr_api.g_varchar2)
840: or not l_api_updating) then
841: --
842: -- check if value of lookup falls within lookup type.
843: --

Line 903: l_api_updating := ben_prv_shd.api_updating

899: Begin
900: --
901: hr_utility.set_location('Entering:'||l_proc, 5);
902: --
903: l_api_updating := ben_prv_shd.api_updating
904: (p_prtt_rt_val_id => p_prtt_rt_val_id,
905: p_object_version_number => p_object_version_number);
906: --
907: if (l_api_updating

Line 909: <> nvl(ben_prv_shd.g_old_rec.dsply_on_enrt_flag,hr_api.g_varchar2)

905: p_object_version_number => p_object_version_number);
906: --
907: if (l_api_updating
908: and p_dsply_on_enrt_flag
909: <> nvl(ben_prv_shd.g_old_rec.dsply_on_enrt_flag,hr_api.g_varchar2)
910: or not l_api_updating) then
911: --
912: -- check if value of lookup falls within lookup type.
913: --

Line 1029: l_api_updating := ben_prv_shd.api_updating

1025: Begin
1026: --
1027: hr_utility.set_location('Entering:'||l_proc, 5);
1028: --
1029: l_api_updating := ben_prv_shd.api_updating
1030: (p_prtt_rt_val_id => p_prtt_rt_val_id,
1031: p_object_version_number => p_object_version_number);
1032: --
1033: If (l_api_updating

Line 1035: <> nvl(ben_prv_shd.g_old_rec.ann_rt_val,hr_api.g_number)

1031: p_object_version_number => p_object_version_number);
1032: --
1033: If (l_api_updating
1034: and p_ann_rt_val
1035: <> nvl(ben_prv_shd.g_old_rec.ann_rt_val,hr_api.g_number)
1036: or not l_api_updating)
1037: and p_ann_rt_val is not null then
1038: --
1039: -- get the annual min max values from enrt_rt If enrt_rt_id is not NULL

Line 1277: l_api_updating := ben_prv_shd.api_updating

1273: Begin
1274: --
1275: hr_utility.set_location('Entering:'||l_proc, 5);
1276: --
1277: l_api_updating := ben_prv_shd.api_updating
1278: (p_prtt_rt_val_id => p_prtt_rt_val_id,
1279: p_object_version_number => p_object_version_number);
1280: --
1281: if (l_api_updating

Line 1283: <> nvl(ben_prv_shd.g_old_rec.rt_val,hr_api.g_number)

1279: p_object_version_number => p_object_version_number);
1280: --
1281: if (l_api_updating
1282: and p_rt_val
1283: <> nvl(ben_prv_shd.g_old_rec.rt_val,hr_api.g_number)
1284: or not l_api_updating)
1285: and p_rt_val is not null then
1286: --
1287: -- get the min max and incrt values from enrt_rt

Line 1458: l_api_updating := ben_prv_shd.api_updating

1454: Begin
1455: --
1456: hr_utility.set_location('Entering:'||l_proc, 5);
1457: --
1458: l_api_updating := ben_prv_shd.api_updating
1459: (p_prtt_rt_val_id => p_prtt_rt_val_id,
1460: p_object_version_number => p_object_version_number);
1461: --
1462: if (l_api_updating

Line 1464: <> nvl(ben_prv_shd.g_old_rec.acty_base_rt_id,hr_api.g_number)

1460: p_object_version_number => p_object_version_number);
1461: --
1462: if (l_api_updating
1463: and nvl(p_acty_base_rt_id,-1)
1464: <> nvl(ben_prv_shd.g_old_rec.acty_base_rt_id,hr_api.g_number)
1465: or not l_api_updating) then
1466:
1467: if p_acty_base_rt_id is not null then
1468: open c_abr;

Line 1539: Procedure insert_validate(p_rec in ben_prv_shd.g_rec_type,p_effective_date in date ) is

1535: --Bug#5088571 */
1536: -- ----------------------------------------------------------------------------
1537: -- |---------------------------< insert_validate >----------------------------|
1538: -- ----------------------------------------------------------------------------
1539: Procedure insert_validate(p_rec in ben_prv_shd.g_rec_type,p_effective_date in date ) is
1540:
1541: l_proc varchar2(72) := g_package||'insert_validate';
1542: -- p_effective_date date := sysdate;
1543: l_global_pil_rec ben_global_enrt.g_global_pil_rec_type;

Line 1673: Procedure update_validate(p_rec in ben_prv_shd.g_rec_type,p_effective_date in date) is

1669:
1670: -- ----------------------------------------------------------------------------
1671: -- |---------------------------< update_validate >----------------------------|
1672: -- ----------------------------------------------------------------------------
1673: Procedure update_validate(p_rec in ben_prv_shd.g_rec_type,p_effective_date in date) is
1674:
1675: l_proc varchar2(72) := g_package||'update_validate';
1676: -- p_effective_date date := sysdate;
1677: l_global_pil_rec ben_global_enrt.g_global_pil_rec_type;

Line 1805: Procedure delete_validate(p_rec in ben_prv_shd.g_rec_type) is

1801:
1802: -- ----------------------------------------------------------------------------
1803: -- |---------------------------< delete_validate >----------------------------|
1804: -- ----------------------------------------------------------------------------
1805: Procedure delete_validate(p_rec in ben_prv_shd.g_rec_type) is
1806: --
1807: l_proc varchar2(72) := g_package||'delete_validate';
1808: --
1809: Begin