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_PBN_BUS dependencies on BEN_PBN_SHD

Line 48: l_api_updating := ben_pbn_shd.api_updating

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

Line 55: <> ben_pbn_shd.g_old_rec.pl_bnf_id) then

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

Line 59: ben_pbn_shd.constraint_error('BEN_PL_BNF_PK');

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

Line 69: ben_pbn_shd.constraint_error('BEN_PL_BNF_PK');

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

Line 117: l_api_updating := ben_pbn_shd.api_updating

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

Line 124: <> nvl(ben_pbn_shd.g_old_rec.prmry_cntngnt_cd,hr_api.g_varchar2)

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

Line 478: l_api_updating := ben_pbn_shd.api_updating

474: Begin
475: --
476: hr_utility.set_location('Entering:'||l_proc,5);
477: --
478: l_api_updating := ben_pbn_shd.api_updating
479: (p_pl_bnf_id => p_pl_bnf_id,
480: p_effective_date => p_effective_date,
481: p_object_version_number => p_object_version_number);
482: --

Line 486: <> nvl(ben_pbn_shd.g_old_rec.pct_dsgd_num, hr_api.g_number)

482: --
483: if p_pct_dsgd_num is not null then
484: if (l_api_updating
485: and nvl(p_pct_dsgd_num, hr_api.g_number)
486: <> nvl(ben_pbn_shd.g_old_rec.pct_dsgd_num, hr_api.g_number)
487: or not l_api_updating) then
488: --
489: -- check if sum of pct_dsgd_num is less or = 100
490: --

Line 579: l_api_updating := ben_pbn_shd.api_updating

575: Begin
576: --
577: hr_utility.set_location('Entering:'||l_proc,5);
578: --
579: l_api_updating := ben_pbn_shd.api_updating
580: (p_pl_bnf_id => p_pl_bnf_id,
581: p_effective_date => p_effective_date,
582: p_object_version_number => p_object_version_number);
583: --

Line 587: <> nvl(ben_pbn_shd.g_old_rec.amt_dsgd_val, hr_api.g_number)

583: --
584: if p_amt_dsgd_val is not null then
585: if (l_api_updating
586: and nvl(p_amt_dsgd_val,hr_api.g_number)
587: <> nvl(ben_pbn_shd.g_old_rec.amt_dsgd_val, hr_api.g_number)
588: or not l_api_updating) then
589: --
590: -- check if sum of amt_dsgd_val is less or = bnft_amt value on ben_prtt_enrt_rslt_f table
591: --

Line 602: ben_pbn_shd.constraint_error('BEN_PL_BNF_FK4');

598: --
599: -- raise error as corresponding rslt does not exist on ben_prtt_enrt_rslt_f
600: -- table.
601: --
602: ben_pbn_shd.constraint_error('BEN_PL_BNF_FK4');
603: else
604: --
605: open c2;
606: fetch c2 into l_sum;

Line 678: l_api_updating := ben_pbn_shd.api_updating

674: Begin
675: --
676: hr_utility.set_location('Entering:'||l_proc, 5);
677: --
678: l_api_updating := ben_pbn_shd.api_updating
679: (p_pl_bnf_id => p_pl_bnf_id,
680: p_effective_date => p_effective_date,
681: p_object_version_number => p_object_version_number);
682: --

Line 686: <> nvl(ben_pbn_shd.g_old_rec.amt_dsgd_uom,hr_api.g_varchar2)

682: --
683: if p_amt_dsgd_uom is not null then
684: if (l_api_updating
685: and p_amt_dsgd_uom
686: <> nvl(ben_pbn_shd.g_old_rec.amt_dsgd_uom,hr_api.g_varchar2)
687: or not l_api_updating)
688: and p_amt_dsgd_uom is not null then
689: --
690: -- check if value of lookup falls within lookup type.

Line 703: ben_pbn_shd.constraint_error('BEN_PL_BNF_FK4');

699: --
700: -- raise error as corresponding rslt does not exist on ben_prtt_enrt_rslt_f
701: -- table.
702: --
703: ben_pbn_shd.constraint_error('BEN_PL_BNF_FK4');
704: elsif p_amt_dsgd_uom <> l_uom then
705: --
706: fnd_message.set_name('BEN', 'BEN_91647_BNF_AMT_UOM_INVALID');
707: fnd_message.raise_error;

Line 795: l_api_updating := ben_pbn_shd.api_updating

791: Begin
792: --
793: hr_utility.set_location('Entering:'||l_proc,5);
794: --
795: l_api_updating := ben_pbn_shd.api_updating
796: (p_pl_bnf_id => p_pl_bnf_id,
797: p_effective_date => p_effective_date,
798: p_object_version_number => p_object_version_number);
799: --

Line 803: <> nvl(ben_pbn_shd.g_old_rec.bnf_person_id, hr_api.g_number)

799: --
800: if p_bnf_person_id is not null then
801: if (l_api_updating
802: and nvl(p_bnf_person_id,hr_api.g_number)
803: <> nvl(ben_pbn_shd.g_old_rec.bnf_person_id, hr_api.g_number)
804: or not l_api_updating) then
805: --
806: -- check if bnf_person_id value exists in per_all_people_f table
807: --

Line 818: ben_pbn_shd.constraint_error('BEN_PL_BNF_FK1');

814: --
815: -- raise error as FK does not relate to PK in per_all_people
816: -- table.
817: --
818: ben_pbn_shd.constraint_error('BEN_PL_BNF_FK1');
819: --
820: end if;
821: --
822: close c1;

Line 903: l_api_updating := ben_pbn_shd.api_updating

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

Line 911: <> nvl(ben_pbn_shd.g_old_rec.ttee_person_id, hr_api.g_number)

907: --
908: if p_ttee_person_id is not null then
909: if (l_api_updating
910: and nvl(p_ttee_person_id,hr_api.g_number)
911: <> nvl(ben_pbn_shd.g_old_rec.ttee_person_id, hr_api.g_number)
912: or not l_api_updating) then
913: --
914: -- check if ttee_person_id value exists in per_all_people_f table
915: --

Line 926: ben_pbn_shd.constraint_error('BEN_PL_BNF_FK2');

922: --
923: -- raise error as FK does not relate to PK in per_all_people
924: -- table.
925: --
926: ben_pbn_shd.constraint_error('BEN_PL_BNF_FK2');
927: --
928: end if;
929: --
930: close c1;

Line 1162: l_api_updating := ben_pbn_shd.api_updating

1158: Begin
1159: --
1160: hr_utility.set_location('Entering:'||l_proc,5);
1161: --
1162: l_api_updating := ben_pbn_shd.api_updating
1163: (p_pl_bnf_id => p_pl_bnf_id,
1164: p_effective_date => p_effective_date,
1165: p_object_version_number => p_object_version_number);
1166:

Line 1503: l_api_updating := ben_pbn_shd.api_updating

1499: Begin
1500: --
1501: hr_utility.set_location('Entering:'||l_proc,5);
1502: --
1503: l_api_updating := ben_pbn_shd.api_updating
1504: (p_pl_bnf_id => p_pl_bnf_id,
1505: p_effective_date => p_effective_date,
1506: p_object_version_number => p_object_version_number);
1507:

Line 1677: l_api_updating := ben_pbn_shd.api_updating

1673: Begin
1674: --
1675: hr_utility.set_location('Entering:'||l_proc,5);
1676: --
1677: l_api_updating := ben_pbn_shd.api_updating
1678: (p_pl_bnf_id => p_pl_bnf_id,
1679: p_effective_date => p_effective_date,
1680: p_object_version_number => p_object_version_number);
1681: --

Line 1685: <> nvl(ben_pbn_shd.g_old_rec.organization_id, hr_api.g_number)

1681: --
1682: if p_organization_id is not null then
1683: if (l_api_updating
1684: and nvl(p_organization_id,hr_api.g_number)
1685: <> nvl(ben_pbn_shd.g_old_rec.organization_id, hr_api.g_number)
1686: or not l_api_updating) then
1687: --
1688: -- check if organization_id value exists in hr_all_organization_units table
1689: --

Line 1700: ben_pbn_shd.constraint_error('BEN_PL_BNF_FK3');

1696: --
1697: -- raise error as FK does not relate to PK in per_all_people
1698: -- table.
1699: --
1700: ben_pbn_shd.constraint_error('BEN_PL_BNF_FK3');
1701: --
1702: end if;
1703: --
1704: close c1;

Line 1779: l_api_updating := ben_pbn_shd.api_updating

1775: Begin
1776: --
1777: hr_utility.set_location('Entering:'||l_proc,5);
1778: --
1779: l_api_updating := ben_pbn_shd.api_updating
1780: (p_pl_bnf_id => p_pl_bnf_id,
1781: p_effective_date => p_effective_date,
1782: p_object_version_number => p_object_version_number);
1783: --

Line 1785: and (nvl(p_organization_id,hr_api.g_number) <> nvl(ben_pbn_shd.g_old_rec.organization_id, hr_api.g_number)

1781: p_effective_date => p_effective_date,
1782: p_object_version_number => p_object_version_number);
1783: --
1784: if (l_api_updating
1785: and (nvl(p_organization_id,hr_api.g_number) <> nvl(ben_pbn_shd.g_old_rec.organization_id, hr_api.g_number)
1786: or nvl(p_bnf_person_id,hr_api.g_number) <> nvl(ben_pbn_shd.g_old_rec.bnf_person_id, hr_api.g_number)
1787: or nvl(p_prmry_cntngnt_cd,hr_api.g_varchar2) <> nvl(ben_pbn_shd.g_old_rec.prmry_cntngnt_cd, hr_api.g_varchar2))
1788: or not l_api_updating) then
1789: --

Line 1786: or nvl(p_bnf_person_id,hr_api.g_number) <> nvl(ben_pbn_shd.g_old_rec.bnf_person_id, hr_api.g_number)

1782: p_object_version_number => p_object_version_number);
1783: --
1784: if (l_api_updating
1785: and (nvl(p_organization_id,hr_api.g_number) <> nvl(ben_pbn_shd.g_old_rec.organization_id, hr_api.g_number)
1786: or nvl(p_bnf_person_id,hr_api.g_number) <> nvl(ben_pbn_shd.g_old_rec.bnf_person_id, hr_api.g_number)
1787: or nvl(p_prmry_cntngnt_cd,hr_api.g_varchar2) <> nvl(ben_pbn_shd.g_old_rec.prmry_cntngnt_cd, hr_api.g_varchar2))
1788: or not l_api_updating) then
1789: --
1790: -- check if person/organization has already been designated as a

Line 1787: or nvl(p_prmry_cntngnt_cd,hr_api.g_varchar2) <> nvl(ben_pbn_shd.g_old_rec.prmry_cntngnt_cd, hr_api.g_varchar2))

1783: --
1784: if (l_api_updating
1785: and (nvl(p_organization_id,hr_api.g_number) <> nvl(ben_pbn_shd.g_old_rec.organization_id, hr_api.g_number)
1786: or nvl(p_bnf_person_id,hr_api.g_number) <> nvl(ben_pbn_shd.g_old_rec.bnf_person_id, hr_api.g_number)
1787: or nvl(p_prmry_cntngnt_cd,hr_api.g_varchar2) <> nvl(ben_pbn_shd.g_old_rec.prmry_cntngnt_cd, hr_api.g_varchar2))
1788: or not l_api_updating) then
1789: --
1790: -- check if person/organization has already been designated as a
1791: -- bnf with a different prmry_cntngnt_cd

Line 2040: (p_rec in ben_pbn_shd.g_rec_type,

2036: -- ----------------------------------------------------------------------------
2037: -- |---------------------------< insert_validate >----------------------------|
2038: -- ----------------------------------------------------------------------------
2039: Procedure insert_validate
2040: (p_rec in ben_pbn_shd.g_rec_type,
2041: p_effective_date in date,
2042: p_datetrack_mode in varchar2,
2043: p_validation_start_date in date,
2044: p_validation_end_date in date) is

Line 2183: (p_rec in ben_pbn_shd.g_rec_type,

2179: -- ----------------------------------------------------------------------------
2180: -- |---------------------------< update_validate >----------------------------|
2181: -- ----------------------------------------------------------------------------
2182: Procedure update_validate
2183: (p_rec in ben_pbn_shd.g_rec_type,
2184: p_effective_date in date,
2185: p_datetrack_mode in varchar2,
2186: p_validation_start_date in date,
2187: p_validation_end_date in date) is

Line 2339: (p_rec in ben_pbn_shd.g_rec_type,

2335: -- ----------------------------------------------------------------------------
2336: -- |---------------------------< delete_validate >----------------------------|
2337: -- ----------------------------------------------------------------------------
2338: Procedure delete_validate
2339: (p_rec in ben_pbn_shd.g_rec_type,
2340: p_effective_date in date,
2341: p_datetrack_mode in varchar2,
2342: p_validation_start_date in date,
2343: p_validation_end_date in date) is