APPS.BEN_APR_BUS dependencies on BEN_APR_SHD

Line 48: l_api_updating := ben_apr_shd.api_updating

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

Line 55: <> ben_apr_shd.g_old_rec.actl_prem_id) then

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

Line 59: ben_apr_shd.constraint_error('BEN_ACTL_PREM_F_PK');

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

Line 69: ben_apr_shd.constraint_error('BEN_ACTL_PREM_F_PK');

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

Line 156: l_api_updating := ben_apr_shd.api_updating

152: Begin
153: --
154: hr_utility.set_location('Entering:'||l_proc,5);
155: --
156: l_api_updating := ben_apr_shd.api_updating
157: (p_actl_prem_id => p_actl_prem_id,
158: p_effective_date => p_effective_date,
159: p_object_version_number => p_object_version_number);
160: --

Line 163: <> nvl(ben_apr_shd.g_old_rec.organization_id,hr_api.g_number)

159: p_object_version_number => p_object_version_number);
160: --
161: if (l_api_updating
162: and nvl(p_organization_id,hr_api.g_number)
163: <> nvl(ben_apr_shd.g_old_rec.organization_id,hr_api.g_number)
164: or not l_api_updating) and p_organization_id is not null then
165: --
166: -- check if organization_id value exists in hr_all_organization_units
167: -- table

Line 277: l_api_updating := ben_apr_shd.api_updating

273: Begin
274: --
275: hr_utility.set_location('Entering:'||l_proc, 5);
276: --
277: l_api_updating := ben_apr_shd.api_updating
278: (p_actl_prem_id => p_actl_prem_id,
279: p_effective_date => p_effective_date,
280: p_object_version_number => p_object_version_number);
281: --

Line 284: <> ben_apr_shd.g_old_rec.rndg_rl

280: p_object_version_number => p_object_version_number);
281: --
282: if (l_api_updating
283: and nvl(p_rndg_rl,hr_api.g_number)
284: <> ben_apr_shd.g_old_rec.rndg_rl
285: or not l_api_updating)
286: and p_rndg_rl is not null then
287: --
288: -- check if value of formula rule is valid.

Line 372: l_api_updating := ben_apr_shd.api_updating

368: Begin
369: --
370: hr_utility.set_location('Entering:'||l_proc, 5);
371: --
372: l_api_updating := ben_apr_shd.api_updating
373: (p_actl_prem_id => p_actl_prem_id,
374: p_effective_date => p_effective_date,
375: p_object_version_number => p_object_version_number);
376: --

Line 379: <> ben_apr_shd.g_old_rec.val_calc_rl

375: p_object_version_number => p_object_version_number);
376: --
377: if (l_api_updating
378: and nvl(p_val_calc_rl,hr_api.g_number)
379: <> ben_apr_shd.g_old_rec.val_calc_rl
380: or not l_api_updating)
381: and p_val_calc_rl is not null then
382: --
383: -- check if value of formula rule is valid.

Line 467: l_api_updating := ben_apr_shd.api_updating

463: Begin
464: --
465: hr_utility.set_location('Entering:'||l_proc, 5);
466: --
467: l_api_updating := ben_apr_shd.api_updating
468: (p_actl_prem_id => p_actl_prem_id,
469: p_effective_date => p_effective_date,
470: p_object_version_number => p_object_version_number);
471: --

Line 474: <> ben_apr_shd.g_old_rec.vrbl_rt_add_on_calc_rl

470: p_object_version_number => p_object_version_number);
471: --
472: if (l_api_updating
473: and nvl(p_vrbl_rt_add_on_calc_rl,hr_api.g_number)
474: <> ben_apr_shd.g_old_rec.vrbl_rt_add_on_calc_rl
475: or not l_api_updating)
476: and p_vrbl_rt_add_on_calc_rl is not null then
477: --
478: -- check if value of formula rule is valid.

Line 545: l_api_updating := ben_apr_shd.api_updating

541: Begin
542: --
543: hr_utility.set_location('Entering:'||l_proc, 5);
544: --
545: l_api_updating := ben_apr_shd.api_updating
546: (p_actl_prem_id => p_actl_prem_id,
547: p_effective_date => p_effective_date,
548: p_object_version_number => p_object_version_number);
549: --

Line 552: <> nvl(ben_apr_shd.g_old_rec.rndg_cd,hr_api.g_varchar2)

548: p_object_version_number => p_object_version_number);
549: --
550: if (l_api_updating
551: and p_rndg_cd
552: <> nvl(ben_apr_shd.g_old_rec.rndg_cd,hr_api.g_varchar2)
553: or not l_api_updating)
554: and p_rndg_cd is not null then
555: --
556: -- check if value of lookup falls within lookup type.

Line 614: l_api_updating := ben_apr_shd.api_updating

610: Begin
611: --
612: hr_utility.set_location('Entering:'||l_proc, 5);
613: --
614: l_api_updating := ben_apr_shd.api_updating
615: (p_actl_prem_id => p_actl_prem_id,
616: p_effective_date => p_effective_date,
617: p_object_version_number => p_object_version_number);
618: --

Line 621: <> nvl(ben_apr_shd.g_old_rec.prdct_cd,hr_api.g_varchar2)

617: p_object_version_number => p_object_version_number);
618: --
619: if (l_api_updating
620: and p_prdct_cd
621: <> nvl(ben_apr_shd.g_old_rec.prdct_cd,hr_api.g_varchar2)
622: or not l_api_updating)
623: and p_prdct_cd is not null then
624: --
625: -- check if value of lookup falls within lookup type.

Line 683: l_api_updating := ben_apr_shd.api_updating

679: Begin
680: --
681: hr_utility.set_location('Entering:'||l_proc, 5);
682: --
683: l_api_updating := ben_apr_shd.api_updating
684: (p_actl_prem_id => p_actl_prem_id,
685: p_effective_date => p_effective_date,
686: p_object_version_number => p_object_version_number);
687: --

Line 690: <> nvl(ben_apr_shd.g_old_rec.mlt_cd,hr_api.g_varchar2)

686: p_object_version_number => p_object_version_number);
687: --
688: if (l_api_updating
689: and p_mlt_cd
690: <> nvl(ben_apr_shd.g_old_rec.mlt_cd,hr_api.g_varchar2)
691: or not l_api_updating)
692: and p_mlt_cd is not null then
693: --
694: -- check if value of lookup falls within lookup type.

Line 758: l_api_updating := ben_apr_shd.api_updating

754: Begin
755: --
756: hr_utility.set_location('Entering:'||l_proc, 5);
757: --
758: l_api_updating := ben_apr_shd.api_updating
759: (p_actl_prem_id => p_actl_prem_id,
760: p_effective_date => p_effective_date,
761: p_object_version_number => p_object_version_number);
762: --

Line 765: <> nvl(ben_apr_shd.g_old_rec.prtl_mo_det_mthd_cd,hr_api.g_varchar2)

761: p_object_version_number => p_object_version_number);
762: --
763: if (l_api_updating
764: and p_prtl_mo_det_mthd_cd
765: <> nvl(ben_apr_shd.g_old_rec.prtl_mo_det_mthd_cd,hr_api.g_varchar2)
766: or not l_api_updating)
767: and p_prtl_mo_det_mthd_cd is not null then
768: --
769: -- check if value of lookup falls within lookup type.

Line 827: l_api_updating := ben_apr_shd.api_updating

823: Begin
824: --
825: hr_utility.set_location('Entering:'||l_proc, 5);
826: --
827: l_api_updating := ben_apr_shd.api_updating
828: (p_actl_prem_id => p_actl_prem_id,
829: p_effective_date => p_effective_date,
830: p_object_version_number => p_object_version_number);
831: --

Line 834: <> nvl(ben_apr_shd.g_old_rec.rt_typ_cd,hr_api.g_varchar2)

830: p_object_version_number => p_object_version_number);
831: --
832: if (l_api_updating
833: and p_rt_typ_cd
834: <> nvl(ben_apr_shd.g_old_rec.rt_typ_cd,hr_api.g_varchar2)
835: or not l_api_updating)
836: and p_rt_typ_cd is not null then
837: --
838: -- check if value of lookup falls within lookup type.

Line 897: l_api_updating := ben_apr_shd.api_updating

893: Begin
894: --
895: hr_utility.set_location('Entering:'||l_proc, 5);
896: --
897: l_api_updating := ben_apr_shd.api_updating
898: (p_actl_prem_id => p_actl_prem_id,
899: p_effective_date => p_effective_date,
900: p_object_version_number => p_object_version_number);
901: --

Line 904: <> nvl(ben_apr_shd.g_old_rec.bnft_rt_typ_cd,hr_api.g_varchar2)

900: p_object_version_number => p_object_version_number);
901: --
902: if (l_api_updating
903: and p_bnft_rt_typ_cd
904: <> nvl(ben_apr_shd.g_old_rec.bnft_rt_typ_cd,hr_api.g_varchar2)
905: or not l_api_updating)
906: and p_bnft_rt_typ_cd is not null then
907: --
908: -- check if value of lookup falls within lookup type.

Line 967: l_api_updating := ben_apr_shd.api_updating

963: Begin
964: --
965: hr_utility.set_location('Entering:'||l_proc, 5);
966: --
967: l_api_updating := ben_apr_shd.api_updating
968: (p_actl_prem_id => p_actl_prem_id,
969: p_effective_date => p_effective_date,
970: p_object_version_number => p_object_version_number);
971: --

Line 974: <> nvl(ben_apr_shd.g_old_rec.acty_ref_perd_cd,hr_api.g_varchar2)

970: p_object_version_number => p_object_version_number);
971: --
972: if (l_api_updating
973: and p_acty_ref_perd_cd
974: <> nvl(ben_apr_shd.g_old_rec.acty_ref_perd_cd,hr_api.g_varchar2)
975: or not l_api_updating)
976: and p_acty_ref_perd_cd is not null then
977: --
978: -- check if value of lookup falls within lookup type.

Line 1055: l_api_updating := ben_apr_shd.api_updating

1051: Begin
1052: --
1053: hr_utility.set_location('Entering:'||l_proc, 5);
1054: --
1055: l_api_updating := ben_apr_shd.api_updating
1056: (p_actl_prem_id => p_actl_prem_id,
1057: p_effective_date => p_effective_date,
1058: p_object_version_number => p_object_version_number);
1059: --

Line 1061: and p_name <> ben_apr_shd.g_old_rec.name) or

1057: p_effective_date => p_effective_date,
1058: p_object_version_number => p_object_version_number);
1059: --
1060: if (l_api_updating
1061: and p_name <> ben_apr_shd.g_old_rec.name) or
1062: not l_api_updating then
1063: --
1064: hr_utility.set_location('name is :'||p_name, 10);
1065: --

Line 1130: -- l_api_updating := ben_apr_shd.api_updating

1126: --Begin
1127: --
1128: -- hr_utility.set_location('Entering:'||l_proc, 5);
1129: --
1130: -- l_api_updating := ben_apr_shd.api_updating
1131: -- (p_actl_prem_id => p_actl_prem_id,
1132: -- p_effective_date => p_effective_date,
1133: -- p_object_version_number => p_object_version_number);
1134: --

Line 1558: l_api_updating := ben_apr_shd.api_updating

1554: Begin
1555: --
1556: hr_utility.set_location('Entering:'||l_proc, 5);
1557: --
1558: l_api_updating := ben_apr_shd.api_updating
1559: (p_actl_prem_id => p_actl_prem_id,
1560: p_effective_date => p_effective_date,
1561: p_object_version_number => p_object_version_number);
1562: --

Line 1565: <> nvl(ben_apr_shd.g_old_rec.prem_asnmt_cd,hr_api.g_varchar2)

1561: p_object_version_number => p_object_version_number);
1562: --
1563: if (l_api_updating
1564: and p_prem_asnmt_cd
1565: <> nvl(ben_apr_shd.g_old_rec.prem_asnmt_cd,hr_api.g_varchar2)
1566: or not l_api_updating)
1567: and p_prem_asnmt_cd is not null then
1568: --
1569: -- check if value of lookup falls within lookup type.

Line 1590: <> nvl(ben_apr_shd.g_old_rec.prem_asnmt_lvl_cd,hr_api.g_varchar2)

1586: end if;
1587: --
1588: if (l_api_updating
1589: and p_prem_asnmt_lvl_cd
1590: <> nvl(ben_apr_shd.g_old_rec.prem_asnmt_lvl_cd,hr_api.g_varchar2)
1591: or not l_api_updating)
1592: and p_prem_asnmt_lvl_cd is not null then
1593: --
1594: -- check if value of lookup falls within lookup type.

Line 1615: <> nvl(ben_apr_shd.g_old_rec.actl_prem_typ_cd,hr_api.g_varchar2)

1611: end if;
1612: --
1613: if (l_api_updating
1614: and p_actl_prem_typ_cd
1615: <> nvl(ben_apr_shd.g_old_rec.actl_prem_typ_cd,hr_api.g_varchar2)
1616: or not l_api_updating)
1617: and p_actl_prem_typ_cd is not null then
1618: --
1619: -- check if value of lookup falls within lookup type.

Line 1640: <> nvl(ben_apr_shd.g_old_rec.prem_pyr_cd,hr_api.g_varchar2)

1636: end if;
1637: --
1638: if (l_api_updating
1639: and p_prem_pyr_cd
1640: <> nvl(ben_apr_shd.g_old_rec.prem_pyr_cd,hr_api.g_varchar2)
1641: or not l_api_updating)
1642: and p_prem_pyr_cd is not null then
1643: --
1644: -- check if value of lookup falls within lookup type.

Line 1665: <> nvl(ben_apr_shd.g_old_rec.prsptv_r_rtsptv_cd,hr_api.g_varchar2)

1661: end if;
1662: --
1663: if (l_api_updating
1664: and p_prsptv_r_rtsptv_cd
1665: <> nvl(ben_apr_shd.g_old_rec.prsptv_r_rtsptv_cd,hr_api.g_varchar2)
1666: or not l_api_updating)
1667: and p_prsptv_r_rtsptv_cd is not null then
1668: --
1669: -- check if value of lookup falls within lookup type.

Line 1753: l_api_updating := ben_apr_shd.api_updating

1749: Begin
1750: --
1751: hr_utility.set_location('Entering:'||l_proc, 5);
1752: --
1753: l_api_updating := ben_apr_shd.api_updating
1754: (p_actl_prem_id => p_actl_prem_id,
1755: p_effective_date => p_effective_date,
1756: p_object_version_number => p_object_version_number);
1757: --

Line 1760: <> ben_apr_shd.g_old_rec.lwr_lmt_calc_rl

1756: p_object_version_number => p_object_version_number);
1757: --
1758: if (l_api_updating
1759: and nvl(p_lwr_lmt_calc_rl,hr_api.g_number)
1760: <> ben_apr_shd.g_old_rec.lwr_lmt_calc_rl
1761: or not l_api_updating)
1762: and p_lwr_lmt_calc_rl is not null then
1763: --
1764: -- check if value of formula rule is valid.

Line 1791: <> ben_apr_shd.g_old_rec.upr_lmt_calc_rl

1787: end if;
1788: --
1789: if (l_api_updating
1790: and nvl(p_upr_lmt_calc_rl,hr_api.g_number)
1791: <> ben_apr_shd.g_old_rec.upr_lmt_calc_rl
1792: or not l_api_updating)
1793: and p_upr_lmt_calc_rl is not null then
1794: --
1795: -- check if value of formula rule is valid.

Line 1823: <> ben_apr_shd.g_old_rec.prtl_mo_det_mthd_rl

1819: --
1820: --
1821: if (l_api_updating
1822: and nvl(p_prtl_mo_det_mthd_rl,hr_api.g_number)
1823: <> ben_apr_shd.g_old_rec.prtl_mo_det_mthd_rl
1824: or not l_api_updating)
1825: and p_prtl_mo_det_mthd_rl is not null then
1826: --
1827: -- check if value of formula rule is valid.

Line 2231: l_api_updating := ben_apr_shd.api_updating

2227: and coa.business_group_id = p_business_group_id;
2228:
2229: Begin
2230: hr_utility.set_location('Entering:'||l_proc, 5);
2231: l_api_updating := ben_apr_shd.api_updating
2232: (p_actl_prem_id => p_actl_prem_id,
2233: p_effective_date => p_effective_date,
2234: p_object_version_number => p_object_version_number);
2235: if (l_api_updating and

Line 2237: <> nvl(ben_apr_shd.g_old_rec.mlt_cd,hr_api.g_varchar2) or

2233: p_effective_date => p_effective_date,
2234: p_object_version_number => p_object_version_number);
2235: if (l_api_updating and
2236: (nvl(p_mlt_cd,hr_api.g_varchar2)
2237: <> nvl(ben_apr_shd.g_old_rec.mlt_cd,hr_api.g_varchar2) or
2238: nvl(p_val,hr_api.g_number)
2239: <> nvl(ben_apr_shd.g_old_rec.val,hr_api.g_number) or
2240: nvl(p_pl_id,hr_api.g_number)
2241: <> nvl(ben_apr_shd.g_old_rec.pl_id,hr_api.g_number) or

Line 2239: <> nvl(ben_apr_shd.g_old_rec.val,hr_api.g_number) or

2235: if (l_api_updating and
2236: (nvl(p_mlt_cd,hr_api.g_varchar2)
2237: <> nvl(ben_apr_shd.g_old_rec.mlt_cd,hr_api.g_varchar2) or
2238: nvl(p_val,hr_api.g_number)
2239: <> nvl(ben_apr_shd.g_old_rec.val,hr_api.g_number) or
2240: nvl(p_pl_id,hr_api.g_number)
2241: <> nvl(ben_apr_shd.g_old_rec.pl_id,hr_api.g_number) or
2242: nvl(p_oipl_id,hr_api.g_number)
2243: <> nvl(ben_apr_shd.g_old_rec.oipl_id,hr_api.g_number) or

Line 2241: <> nvl(ben_apr_shd.g_old_rec.pl_id,hr_api.g_number) or

2237: <> nvl(ben_apr_shd.g_old_rec.mlt_cd,hr_api.g_varchar2) or
2238: nvl(p_val,hr_api.g_number)
2239: <> nvl(ben_apr_shd.g_old_rec.val,hr_api.g_number) or
2240: nvl(p_pl_id,hr_api.g_number)
2241: <> nvl(ben_apr_shd.g_old_rec.pl_id,hr_api.g_number) or
2242: nvl(p_oipl_id,hr_api.g_number)
2243: <> nvl(ben_apr_shd.g_old_rec.oipl_id,hr_api.g_number) or
2244: nvl(p_rt_typ_cd,hr_api.g_varchar2)
2245: <> nvl(ben_apr_shd.g_old_rec.rt_typ_cd,hr_api.g_varchar2) or

Line 2243: <> nvl(ben_apr_shd.g_old_rec.oipl_id,hr_api.g_number) or

2239: <> nvl(ben_apr_shd.g_old_rec.val,hr_api.g_number) or
2240: nvl(p_pl_id,hr_api.g_number)
2241: <> nvl(ben_apr_shd.g_old_rec.pl_id,hr_api.g_number) or
2242: nvl(p_oipl_id,hr_api.g_number)
2243: <> nvl(ben_apr_shd.g_old_rec.oipl_id,hr_api.g_number) or
2244: nvl(p_rt_typ_cd,hr_api.g_varchar2)
2245: <> nvl(ben_apr_shd.g_old_rec.rt_typ_cd,hr_api.g_varchar2) or
2246: nvl(p_bnft_rt_typ_cd,hr_api.g_varchar2)
2247: <> nvl(ben_apr_shd.g_old_rec.bnft_rt_typ_cd,hr_api.g_varchar2)

Line 2245: <> nvl(ben_apr_shd.g_old_rec.rt_typ_cd,hr_api.g_varchar2) or

2241: <> nvl(ben_apr_shd.g_old_rec.pl_id,hr_api.g_number) or
2242: nvl(p_oipl_id,hr_api.g_number)
2243: <> nvl(ben_apr_shd.g_old_rec.oipl_id,hr_api.g_number) or
2244: nvl(p_rt_typ_cd,hr_api.g_varchar2)
2245: <> nvl(ben_apr_shd.g_old_rec.rt_typ_cd,hr_api.g_varchar2) or
2246: nvl(p_bnft_rt_typ_cd,hr_api.g_varchar2)
2247: <> nvl(ben_apr_shd.g_old_rec.bnft_rt_typ_cd,hr_api.g_varchar2)
2248: ) or not l_api_updating)
2249: then

Line 2247: <> nvl(ben_apr_shd.g_old_rec.bnft_rt_typ_cd,hr_api.g_varchar2)

2243: <> nvl(ben_apr_shd.g_old_rec.oipl_id,hr_api.g_number) or
2244: nvl(p_rt_typ_cd,hr_api.g_varchar2)
2245: <> nvl(ben_apr_shd.g_old_rec.rt_typ_cd,hr_api.g_varchar2) or
2246: nvl(p_bnft_rt_typ_cd,hr_api.g_varchar2)
2247: <> nvl(ben_apr_shd.g_old_rec.bnft_rt_typ_cd,hr_api.g_varchar2)
2248: ) or not l_api_updating)
2249: then
2250: if p_mlt_cd is NULL then
2251: fnd_message.set_name('BEN','BEN_91535_MLT_CD_RQD');

Line 2299: (p_rec in ben_apr_shd.g_rec_type,

2295: -- ----------------------------------------------------------------------------
2296: -- |---------------------------< insert_validate >----------------------------|
2297: -- ----------------------------------------------------------------------------
2298: Procedure insert_validate
2299: (p_rec in ben_apr_shd.g_rec_type,
2300: p_effective_date in date,
2301: p_datetrack_mode in varchar2,
2302: p_validation_start_date in date,
2303: p_validation_end_date in date) is

Line 2472: (p_rec in ben_apr_shd.g_rec_type,

2468: -- ----------------------------------------------------------------------------
2469: -- |---------------------------< update_validate >----------------------------|
2470: -- ----------------------------------------------------------------------------
2471: Procedure update_validate
2472: (p_rec in ben_apr_shd.g_rec_type,
2473: p_effective_date in date,
2474: p_datetrack_mode in varchar2,
2475: p_validation_start_date in date,
2476: p_validation_end_date in date) is

Line 2666: (p_rec in ben_apr_shd.g_rec_type,

2662: -- ----------------------------------------------------------------------------
2663: -- |---------------------------< delete_validate >----------------------------|
2664: -- ----------------------------------------------------------------------------
2665: Procedure delete_validate
2666: (p_rec in ben_apr_shd.g_rec_type,
2667: p_effective_date in date,
2668: p_datetrack_mode in varchar2,
2669: p_validation_start_date in date,
2670: p_validation_end_date in date) is