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_LEN_BUS dependencies on BEN_LEN_SHD

Line 48: l_api_updating := ben_len_shd.api_updating

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

Line 55: <> ben_len_shd.g_old_rec.lee_rsn_id) then

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

Line 59: ben_len_shd.constraint_error('BEN_LEE_RSN_F_PK');

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

Line 69: ben_len_shd.constraint_error('BEN_LEE_RSN_F_PK');

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

Line 171: l_api_updating := ben_len_shd.api_updating

167: Begin
168: --
169: hr_utility.set_location('Entering:'||l_proc, 5);
170: --
171: l_api_updating := ben_len_shd.api_updating
172: (p_lee_rsn_id => p_lee_rsn_id,
173: p_effective_date => p_effective_date,
174: p_object_version_number => p_object_version_number);
175: --

Line 178: <> ben_len_shd.g_old_rec.enrt_cvg_strt_dt_rl

174: p_object_version_number => p_object_version_number);
175: --
176: if (l_api_updating
177: and nvl(p_enrt_cvg_strt_dt_rl,hr_api.g_number)
178: <> ben_len_shd.g_old_rec.enrt_cvg_strt_dt_rl
179: or not l_api_updating)
180: and p_enrt_cvg_strt_dt_rl is not null then
181: --
182: -- check if value of formula rule is valid.

Line 244: l_api_updating := ben_len_shd.api_updating

240: Begin
241: --
242: hr_utility.set_location('Entering:'||l_proc, 5);
243: --
244: l_api_updating := ben_len_shd.api_updating
245: (p_lee_rsn_id => p_lee_rsn_id,
246: p_effective_date => p_effective_date,
247: p_object_version_number => p_object_version_number);
248: --

Line 251: <> ben_len_shd.g_old_rec.enrt_cvg_end_dt_rl

247: p_object_version_number => p_object_version_number);
248: --
249: if (l_api_updating
250: and nvl(p_enrt_cvg_end_dt_rl,hr_api.g_number)
251: <> ben_len_shd.g_old_rec.enrt_cvg_end_dt_rl
252: or not l_api_updating)
253: and p_enrt_cvg_end_dt_rl is not null then
254: --
255: -- check if value of formula rule is valid.

Line 317: l_api_updating := ben_len_shd.api_updating

313: Begin
314: --
315: hr_utility.set_location('Entering:'||l_proc, 5);
316: --
317: l_api_updating := ben_len_shd.api_updating
318: (p_lee_rsn_id => p_lee_rsn_id,
319: p_effective_date => p_effective_date,
320: p_object_version_number => p_object_version_number);
321: --

Line 324: <> ben_len_shd.g_old_rec.rt_strt_dt_rl

320: p_object_version_number => p_object_version_number);
321: --
322: if (l_api_updating
323: and nvl(p_rt_strt_dt_rl,hr_api.g_number)
324: <> ben_len_shd.g_old_rec.rt_strt_dt_rl
325: or not l_api_updating)
326: and p_rt_strt_dt_rl is not null then
327: --
328: -- check if value of formula rule is valid.

Line 389: l_api_updating := ben_len_shd.api_updating

385: Begin
386: --
387: hr_utility.set_location('Entering:'||l_proc, 5);
388: --
389: l_api_updating := ben_len_shd.api_updating
390: (p_lee_rsn_id => p_lee_rsn_id,
391: p_effective_date => p_effective_date,
392: p_object_version_number => p_object_version_number);
393: --

Line 396: <> nvl(ben_len_shd.g_old_rec.rt_strt_dt_cd,hr_api.g_varchar2)

392: p_object_version_number => p_object_version_number);
393: --
394: if (l_api_updating
395: and p_rt_strt_dt_cd
396: <> nvl(ben_len_shd.g_old_rec.rt_strt_dt_cd,hr_api.g_varchar2)
397: or not l_api_updating)
398: and p_rt_strt_dt_cd is not null then
399: --
400: -- check if value of lookup falls within lookup type.

Line 462: l_api_updating := ben_len_shd.api_updating

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

Line 469: <> ben_len_shd.g_old_rec.rt_end_dt_rl

465: p_object_version_number => p_object_version_number);
466: --
467: if (l_api_updating
468: and nvl(p_rt_end_dt_rl,hr_api.g_number)
469: <> ben_len_shd.g_old_rec.rt_end_dt_rl
470: or not l_api_updating)
471: and p_rt_end_dt_rl is not null then
472: --
473: -- check if value of formula rule is valid.

Line 534: l_api_updating := ben_len_shd.api_updating

530: Begin
531: --
532: hr_utility.set_location('Entering:'||l_proc, 5);
533: --
534: l_api_updating := ben_len_shd.api_updating
535: (p_lee_rsn_id => p_lee_rsn_id,
536: p_effective_date => p_effective_date,
537: p_object_version_number => p_object_version_number);
538: --

Line 541: <> nvl(ben_len_shd.g_old_rec.rt_end_dt_cd,hr_api.g_varchar2)

537: p_object_version_number => p_object_version_number);
538: --
539: if (l_api_updating
540: and p_rt_end_dt_cd
541: <> nvl(ben_len_shd.g_old_rec.rt_end_dt_cd,hr_api.g_varchar2)
542: or not l_api_updating)
543: and p_rt_end_dt_cd is not null then
544: --
545: -- check if value of lookup falls within lookup type.

Line 606: l_api_updating := ben_len_shd.api_updating

602: Begin
603: --
604: hr_utility.set_location('Entering:'||l_proc, 5);
605: --
606: l_api_updating := ben_len_shd.api_updating
607: (p_lee_rsn_id => p_lee_rsn_id,
608: p_effective_date => p_effective_date,
609: p_object_version_number => p_object_version_number);
610: --

Line 613: <> ben_len_shd.g_old_rec.enrt_perd_end_dt_rl

609: p_object_version_number => p_object_version_number);
610: --
611: if (l_api_updating
612: and nvl(p_enrt_perd_end_dt_rl,hr_api.g_number)
613: <> ben_len_shd.g_old_rec.enrt_perd_end_dt_rl
614: or not l_api_updating)
615: and p_enrt_perd_end_dt_rl is not null then
616: --
617: -- check if value of formula rule is valid.

Line 678: l_api_updating := ben_len_shd.api_updating

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

Line 685: <> nvl(ben_len_shd.g_old_rec.enrt_perd_end_dt_cd,hr_api.g_varchar2)

681: p_object_version_number => p_object_version_number);
682: --
683: if (l_api_updating
684: and p_enrt_perd_end_dt_cd
685: <> nvl(ben_len_shd.g_old_rec.enrt_perd_end_dt_cd,hr_api.g_varchar2)
686: or not l_api_updating)
687: and p_enrt_perd_end_dt_cd is not null then
688: --
689: -- check if value of lookup falls within lookup type.

Line 750: l_api_updating := ben_len_shd.api_updating

746: Begin
747: --
748: hr_utility.set_location('Entering:'||l_proc, 5);
749: --
750: l_api_updating := ben_len_shd.api_updating
751: (p_lee_rsn_id => p_lee_rsn_id,
752: p_effective_date => p_effective_date,
753: p_object_version_number => p_object_version_number);
754: --

Line 757: <> ben_len_shd.g_old_rec.enrt_perd_strt_dt_rl

753: p_object_version_number => p_object_version_number);
754: --
755: if (l_api_updating
756: and nvl(p_enrt_perd_strt_dt_rl,hr_api.g_number)
757: <> ben_len_shd.g_old_rec.enrt_perd_strt_dt_rl
758: or not l_api_updating)
759: and p_enrt_perd_strt_dt_rl is not null then
760: --
761: -- check if value of formula rule is valid.

Line 822: l_api_updating := ben_len_shd.api_updating

818: Begin
819: --
820: hr_utility.set_location('Entering:'||l_proc, 5);
821: --
822: l_api_updating := ben_len_shd.api_updating
823: (p_lee_rsn_id => p_lee_rsn_id,
824: p_effective_date => p_effective_date,
825: p_object_version_number => p_object_version_number);
826: --

Line 829: <> nvl(ben_len_shd.g_old_rec.enrt_perd_strt_dt_cd,hr_api.g_varchar2)

825: p_object_version_number => p_object_version_number);
826: --
827: if (l_api_updating
828: and p_enrt_perd_strt_dt_cd
829: <> nvl(ben_len_shd.g_old_rec.enrt_perd_strt_dt_cd,hr_api.g_varchar2)
830: or not l_api_updating)
831: and p_enrt_perd_strt_dt_cd is not null then
832: --
833: -- check if value of lookup falls within lookup type.

Line 893: l_api_updating := ben_len_shd.api_updating

889: Begin
890: --
891: hr_utility.set_location('Entering:'||l_proc, 5);
892: --
893: l_api_updating := ben_len_shd.api_updating
894: (p_lee_rsn_id => p_lee_rsn_id,
895: p_effective_date => p_effective_date,
896: p_object_version_number => p_object_version_number);
897: --

Line 900: <> nvl(ben_len_shd.g_old_rec.enrt_cvg_strt_dt_cd,hr_api.g_varchar2)

896: p_object_version_number => p_object_version_number);
897: --
898: if (l_api_updating
899: and p_enrt_cvg_strt_dt_cd
900: <> nvl(ben_len_shd.g_old_rec.enrt_cvg_strt_dt_cd,hr_api.g_varchar2)
901: or not l_api_updating)
902: and p_enrt_cvg_strt_dt_cd is not null then
903: --
904: -- check if value of lookup falls within lookup type.

Line 965: l_api_updating := ben_len_shd.api_updating

961: Begin
962: --
963: hr_utility.set_location('Entering:'||l_proc, 5);
964: --
965: l_api_updating := ben_len_shd.api_updating
966: (p_lee_rsn_id => p_lee_rsn_id,
967: p_effective_date => p_effective_date,
968: p_object_version_number => p_object_version_number);
969: --

Line 972: <> nvl(ben_len_shd.g_old_rec.reinstate_ovrdn_cd,hr_api.g_varchar2)

968: p_object_version_number => p_object_version_number);
969: --
970: if (l_api_updating
971: and p_reinstate_ovrdn_cd
972: <> nvl(ben_len_shd.g_old_rec.reinstate_ovrdn_cd,hr_api.g_varchar2)
973: or not l_api_updating)
974: and p_reinstate_ovrdn_cd is not null then
975: --
976: -- check if value of lookup falls within lookup type.

Line 1037: l_api_updating := ben_len_shd.api_updating

1033: Begin
1034: --
1035: hr_utility.set_location('Entering:'||l_proc, 5);
1036: --
1037: l_api_updating := ben_len_shd.api_updating
1038: (p_lee_rsn_id => p_lee_rsn_id,
1039: p_effective_date => p_effective_date,
1040: p_object_version_number => p_object_version_number);
1041: --

Line 1044: <> nvl(ben_len_shd.g_old_rec.reinstate_cd,hr_api.g_varchar2)

1040: p_object_version_number => p_object_version_number);
1041: --
1042: if (l_api_updating
1043: and p_reinstate_cd
1044: <> nvl(ben_len_shd.g_old_rec.reinstate_cd,hr_api.g_varchar2)
1045: or not l_api_updating)
1046: and p_reinstate_cd is not null then
1047: --
1048: -- check if value of lookup falls within lookup type.

Line 1108: l_api_updating := ben_len_shd.api_updating

1104: Begin
1105: --
1106: hr_utility.set_location('Entering:'||l_proc, 5);
1107: --
1108: l_api_updating := ben_len_shd.api_updating
1109: (p_lee_rsn_id => p_lee_rsn_id,
1110: p_effective_date => p_effective_date,
1111: p_object_version_number => p_object_version_number);
1112: --

Line 1115: <> nvl(ben_len_shd.g_old_rec.enrt_cvg_end_dt_cd,hr_api.g_varchar2)

1111: p_object_version_number => p_object_version_number);
1112: --
1113: if (l_api_updating
1114: and p_enrt_cvg_end_dt_cd
1115: <> nvl(ben_len_shd.g_old_rec.enrt_cvg_end_dt_cd,hr_api.g_varchar2)
1116: or not l_api_updating)
1117: and p_enrt_cvg_end_dt_cd is not null then
1118: --
1119: -- check if value of lookup falls within lookup type.

Line 1179: l_api_updating := ben_len_shd.api_updating

1175: Begin
1176: --
1177: hr_utility.set_location('Entering:'||l_proc, 5);
1178: --
1179: l_api_updating := ben_len_shd.api_updating
1180: (p_lee_rsn_id => p_lee_rsn_id,
1181: p_effective_date => p_effective_date,
1182: p_object_version_number => p_object_version_number);
1183: --

Line 1186: <> nvl(ben_len_shd.g_old_rec.cls_enrt_dt_to_use_cd,hr_api.g_varchar2)

1182: p_object_version_number => p_object_version_number);
1183: --
1184: if (l_api_updating
1185: and p_cls_enrt_dt_to_use_cd
1186: <> nvl(ben_len_shd.g_old_rec.cls_enrt_dt_to_use_cd,hr_api.g_varchar2)
1187: or not l_api_updating)
1188: and p_cls_enrt_dt_to_use_cd is not null then
1189: --
1190: -- check if value of lookup falls within lookup type.

Line 1442: l_api_updating := ben_len_shd.api_updating

1438: begin
1439: --
1440: hr_utility.set_location('Entering:'|| l_proc, 9653);
1441: --
1442: l_api_updating := ben_len_shd.api_updating
1443: (p_effective_date => p_effective_date,
1444: p_lee_rsn_id => p_lee_rsn_id,
1445: p_object_version_number => p_object_version_number);
1446: --

Line 1448: and p_defer_deenrol_flag <> nvl(ben_len_shd.g_old_rec.defer_deenrol_flag,hr_api.g_varchar2)

1444: p_lee_rsn_id => p_lee_rsn_id,
1445: p_object_version_number => p_object_version_number);
1446: --
1447: if (l_api_updating
1448: and p_defer_deenrol_flag <> nvl(ben_len_shd.g_old_rec.defer_deenrol_flag,hr_api.g_varchar2)
1449: or not l_api_updating)
1450: and p_defer_deenrol_flag is not null then
1451: --
1452: open c_pl_cd;

Line 1509: l_api_updating := ben_len_shd.api_updating

1505: begin
1506: --
1507: hr_utility.set_location('Entering:'|| l_proc, 9653);
1508: --
1509: l_api_updating := ben_len_shd.api_updating
1510: (p_effective_date => p_effective_date,
1511: p_lee_rsn_id => p_lee_rsn_id,
1512: p_object_version_number => p_object_version_number);
1513: --

Line 1515: and p_defer_deenrol_flag <> nvl(ben_len_shd.g_old_rec.defer_deenrol_flag,hr_api.g_varchar2)

1511: p_lee_rsn_id => p_lee_rsn_id,
1512: p_object_version_number => p_object_version_number);
1513: --
1514: if (l_api_updating
1515: and p_defer_deenrol_flag <> nvl(ben_len_shd.g_old_rec.defer_deenrol_flag,hr_api.g_varchar2)
1516: or not l_api_updating)
1517: and p_defer_deenrol_flag is not null then
1518: --
1519: if hr_api.not_exists_in_hr_lookups

Line 1764: (p_rec in ben_len_shd.g_rec_type,

1760: -- ----------------------------------------------------------------------------
1761: -- |---------------------------< insert_validate >----------------------------|
1762: -- ----------------------------------------------------------------------------
1763: Procedure insert_validate
1764: (p_rec in ben_len_shd.g_rec_type,
1765: p_effective_date in date,
1766: p_datetrack_mode in varchar2,
1767: p_validation_start_date in date,
1768: p_validation_end_date in date) is

Line 1947: (p_rec in ben_len_shd.g_rec_type,

1943: -- ----------------------------------------------------------------------------
1944: -- |---------------------------< update_validate >----------------------------|
1945: -- ----------------------------------------------------------------------------
1946: Procedure update_validate
1947: (p_rec in ben_len_shd.g_rec_type,
1948: p_effective_date in date,
1949: p_datetrack_mode in varchar2,
1950: p_validation_start_date in date,
1951: p_validation_end_date in date) is

Line 2139: (p_rec in ben_len_shd.g_rec_type,

2135: -- ----------------------------------------------------------------------------
2136: -- |---------------------------< delete_validate >----------------------------|
2137: -- ----------------------------------------------------------------------------
2138: Procedure delete_validate
2139: (p_rec in ben_len_shd.g_rec_type,
2140: p_effective_date in date,
2141: p_datetrack_mode in varchar2,
2142: p_validation_start_date in date,
2143: p_validation_end_date in date) is