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_LDC_BUS dependencies on BEN_LDC_SHD

Line 48: l_api_updating := ben_ldc_shd.api_updating

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

Line 55: <> ben_ldc_shd.g_old_rec.ler_chg_dpnt_cvg_id) then

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

Line 59: ben_ldc_shd.constraint_error('BEN_LER_CHG_DPNT_CVG_PK');

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

Line 69: ben_ldc_shd.constraint_error('BEN_LER_CHG_DPNT_CVG_PK');

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

Line 137: l_api_updating := ben_ldc_shd.api_updating

133: Begin
134: --
135: hr_utility.set_location('Entering:'||l_proc, 5);
136: --
137: l_api_updating := ben_ldc_shd.api_updating
138: (p_ler_chg_dpnt_cvg_id => p_ler_chg_dpnt_cvg_id ,
139: p_effective_date => p_effective_date,
140: p_object_version_number => p_object_version_number);
141: --

Line 144: <> nvl(ben_ldc_shd.g_old_rec.ler_id,hr_api.g_number)

140: p_object_version_number => p_object_version_number);
141: --
142: if (l_api_updating
143: and p_ler_id
144: <> nvl(ben_ldc_shd.g_old_rec.ler_id,hr_api.g_number)
145: or not l_api_updating) then
146: --
147: -- this value must be unique
148: --

Line 225: l_api_updating := ben_ldc_shd.api_updating

221: Begin
222: --
223: hr_utility.set_location('Entering:'||l_proc, 5);
224: --
225: l_api_updating := ben_ldc_shd.api_updating
226: (p_ler_chg_dpnt_cvg_id => p_ler_chg_dpnt_cvg_id,
227: p_effective_date => p_effective_date,
228: p_object_version_number => p_object_version_number);
229: --

Line 232: <> ben_ldc_shd.g_old_rec.cvg_eff_end_rl

228: p_object_version_number => p_object_version_number);
229: --
230: if (l_api_updating
231: and nvl(p_cvg_eff_end_rl,hr_api.g_number)
232: <> ben_ldc_shd.g_old_rec.cvg_eff_end_rl
233: or not l_api_updating)
234: and p_cvg_eff_end_rl is not null then
235: --
236: -- check if value of formula rule is valid.

Line 318: l_api_updating := ben_ldc_shd.api_updating

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

Line 325: <> ben_ldc_shd.g_old_rec.cvg_eff_strt_rl

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

Line 411: l_api_updating := ben_ldc_shd.api_updating

407: Begin
408: --
409: hr_utility.set_location('Entering:'||l_proc, 5);
410: --
411: l_api_updating := ben_ldc_shd.api_updating
412: (p_ler_chg_dpnt_cvg_id => p_ler_chg_dpnt_cvg_id,
413: p_effective_date => p_effective_date,
414: p_object_version_number => p_object_version_number);
415: --

Line 418: <> ben_ldc_shd.g_old_rec.ler_chg_dpnt_cvg_rl

414: p_object_version_number => p_object_version_number);
415: --
416: if (l_api_updating
417: and nvl(p_ler_chg_dpnt_cvg_rl,hr_api.g_number)
418: <> ben_ldc_shd.g_old_rec.ler_chg_dpnt_cvg_rl
419: or not l_api_updating)
420: and p_ler_chg_dpnt_cvg_rl is not null then
421: --
422: -- check if value of formula rule is valid.

Line 487: l_api_updating := ben_ldc_shd.api_updating

483: Begin
484: --
485: hr_utility.set_location('Entering:'||l_proc, 5);
486: --
487: l_api_updating := ben_ldc_shd.api_updating
488: (p_ler_chg_dpnt_cvg_id => p_ler_chg_dpnt_cvg_id,
489: p_effective_date => p_effective_date,
490: p_object_version_number => p_object_version_number);
491: --

Line 494: <> nvl(ben_ldc_shd.g_old_rec.cvg_eff_strt_cd,hr_api.g_varchar2)

490: p_object_version_number => p_object_version_number);
491: --
492: if (l_api_updating
493: and p_cvg_eff_strt_cd
494: <> nvl(ben_ldc_shd.g_old_rec.cvg_eff_strt_cd,hr_api.g_varchar2)
495: or not l_api_updating)
496: and p_cvg_eff_strt_cd is not null then
497: --
498: -- check if value of lookup falls within lookup type.

Line 558: l_api_updating := ben_ldc_shd.api_updating

554: Begin
555: --
556: hr_utility.set_location('Entering:'||l_proc, 5);
557: --
558: l_api_updating := ben_ldc_shd.api_updating
559: (p_ler_chg_dpnt_cvg_id => p_ler_chg_dpnt_cvg_id,
560: p_effective_date => p_effective_date,
561: p_object_version_number => p_object_version_number);
562: --

Line 565: <> nvl(ben_ldc_shd.g_old_rec.cvg_eff_end_cd,hr_api.g_varchar2)

561: p_object_version_number => p_object_version_number);
562: --
563: if (l_api_updating
564: and p_cvg_eff_end_cd
565: <> nvl(ben_ldc_shd.g_old_rec.cvg_eff_end_cd,hr_api.g_varchar2)
566: or not l_api_updating)
567: and p_cvg_eff_end_cd is not null then
568: --
569: -- check if value of lookup falls within lookup type.

Line 629: l_api_updating := ben_ldc_shd.api_updating

625: Begin
626: --
627: hr_utility.set_location('Entering:'||l_proc, 5);
628: --
629: l_api_updating := ben_ldc_shd.api_updating
630: (p_ler_chg_dpnt_cvg_id => p_ler_chg_dpnt_cvg_id,
631: p_effective_date => p_effective_date,
632: p_object_version_number => p_object_version_number);
633: --

Line 636: <> nvl(ben_ldc_shd.g_old_rec.add_rmv_cvg_cd,hr_api.g_varchar2)

632: p_object_version_number => p_object_version_number);
633: --
634: if (l_api_updating
635: and p_add_rmv_cvg_cd
636: <> nvl(ben_ldc_shd.g_old_rec.add_rmv_cvg_cd,hr_api.g_varchar2)
637: or not l_api_updating) then
638: --
639: -- check if value of lookup falls within lookup type.
640: --

Line 786: l_api_updating := ben_ldc_shd.api_updating

782: Begin
783: --
784: hr_utility.set_location('Entering:'||l_proc, 5);
785: --
786: l_api_updating := ben_ldc_shd.api_updating
787: (p_ler_chg_dpnt_cvg_id => p_ler_chg_dpnt_cvg_id,
788: p_effective_date => p_effective_date,
789: p_object_version_number => p_object_version_number);
790: --

Line 793: <> nvl(ben_ldc_shd.g_old_rec.ler_chg_dpnt_cvg_cd,hr_api.g_varchar2)

789: p_object_version_number => p_object_version_number);
790: --
791: if (l_api_updating
792: and p_ler_chg_dpnt_cvg_cd
793: <> nvl(ben_ldc_shd.g_old_rec.ler_chg_dpnt_cvg_cd,hr_api.g_varchar2)
794: or not l_api_updating)
795: and p_ler_chg_dpnt_cvg_cd is not null then
796: --
797: -- check if value of lookup falls within lookup type.

Line 879: l_api_updating := ben_ldc_shd.api_updating

875: Begin
876: --
877: hr_utility.set_location('Entering:'||l_proc, 5);
878: --
879: l_api_updating := ben_ldc_shd.api_updating
880: (p_ler_chg_dpnt_cvg_id => p_ler_chg_dpnt_cvg_id,
881: p_effective_date => p_effective_date,
882: p_object_version_number => p_object_version_number);
883: --

Line 887: <> nvl(ben_ldc_shd.g_old_rec.cvg_eff_strt_cd,hr_api.g_varchar2) or

883: --
884: if (l_api_updating
885: and
886: (nvl(p_cvg_eff_strt_cd,hr_api.g_varchar2)
887: <> nvl(ben_ldc_shd.g_old_rec.cvg_eff_strt_cd,hr_api.g_varchar2) or
888: nvl(p_cvg_eff_strt_rl,hr_api.g_number)
889: <> nvl(ben_ldc_shd.g_old_rec.cvg_eff_strt_rl,hr_api.g_number))
890: or not l_api_updating) then
891: --

Line 889: <> nvl(ben_ldc_shd.g_old_rec.cvg_eff_strt_rl,hr_api.g_number))

885: and
886: (nvl(p_cvg_eff_strt_cd,hr_api.g_varchar2)
887: <> nvl(ben_ldc_shd.g_old_rec.cvg_eff_strt_cd,hr_api.g_varchar2) or
888: nvl(p_cvg_eff_strt_rl,hr_api.g_number)
889: <> nvl(ben_ldc_shd.g_old_rec.cvg_eff_strt_rl,hr_api.g_number))
890: or not l_api_updating) then
891: --
892: if (p_cvg_eff_strt_cd = 'RL' and p_cvg_eff_strt_rl is null) then
893: --

Line 954: l_api_updating := ben_ldc_shd.api_updating

950: Begin
951: --
952: hr_utility.set_location('Entering:'||l_proc, 5);
953: --
954: l_api_updating := ben_ldc_shd.api_updating
955: (p_ler_chg_dpnt_cvg_id => p_ler_chg_dpnt_cvg_id,
956: p_effective_date => p_effective_date,
957: p_object_version_number => p_object_version_number);
958: --

Line 962: <> nvl(ben_ldc_shd.g_old_rec.cvg_eff_end_cd,hr_api.g_varchar2) or

958: --
959: if (l_api_updating
960: and
961: (nvl(p_cvg_eff_end_cd,hr_api.g_varchar2)
962: <> nvl(ben_ldc_shd.g_old_rec.cvg_eff_end_cd,hr_api.g_varchar2) or
963: nvl(p_cvg_eff_end_rl,hr_api.g_number)
964: <> nvl(ben_ldc_shd.g_old_rec.cvg_eff_end_rl,hr_api.g_number))
965: or not l_api_updating) then
966: --

Line 964: <> nvl(ben_ldc_shd.g_old_rec.cvg_eff_end_rl,hr_api.g_number))

960: and
961: (nvl(p_cvg_eff_end_cd,hr_api.g_varchar2)
962: <> nvl(ben_ldc_shd.g_old_rec.cvg_eff_end_cd,hr_api.g_varchar2) or
963: nvl(p_cvg_eff_end_rl,hr_api.g_number)
964: <> nvl(ben_ldc_shd.g_old_rec.cvg_eff_end_rl,hr_api.g_number))
965: or not l_api_updating) then
966: --
967: if (p_cvg_eff_end_cd = 'RL' and p_cvg_eff_end_rl is null) then
968: --

Line 1031: l_api_updating := ben_ldc_shd.api_updating

1027: Begin
1028: --
1029: hr_utility.set_location('Entering:'||l_proc, 5);
1030: --
1031: l_api_updating := ben_ldc_shd.api_updating
1032: (p_ler_chg_dpnt_cvg_id => p_ler_chg_dpnt_cvg_id,
1033: p_effective_date => p_effective_date,
1034: p_object_version_number => p_object_version_number);
1035: --

Line 1039: <> nvl(ben_ldc_shd.g_old_rec.ler_chg_dpnt_cvg_cd,hr_api.g_varchar2) or

1035: --
1036: if (l_api_updating
1037: and
1038: (nvl(p_ler_chg_dpnt_cvg_cd,hr_api.g_varchar2)
1039: <> nvl(ben_ldc_shd.g_old_rec.ler_chg_dpnt_cvg_cd,hr_api.g_varchar2) or
1040: nvl(p_ler_chg_dpnt_cvg_rl,hr_api.g_number)
1041: <> nvl(ben_ldc_shd.g_old_rec.ler_chg_dpnt_cvg_rl,hr_api.g_number))
1042: or not l_api_updating) then
1043: --

Line 1041: <> nvl(ben_ldc_shd.g_old_rec.ler_chg_dpnt_cvg_rl,hr_api.g_number))

1037: and
1038: (nvl(p_ler_chg_dpnt_cvg_cd,hr_api.g_varchar2)
1039: <> nvl(ben_ldc_shd.g_old_rec.ler_chg_dpnt_cvg_cd,hr_api.g_varchar2) or
1040: nvl(p_ler_chg_dpnt_cvg_rl,hr_api.g_number)
1041: <> nvl(ben_ldc_shd.g_old_rec.ler_chg_dpnt_cvg_rl,hr_api.g_number))
1042: or not l_api_updating) then
1043: --
1044: if (p_ler_chg_dpnt_cvg_cd = 'RL' and p_ler_chg_dpnt_cvg_rl is null) then
1045: --

Line 1344: (p_rec in ben_ldc_shd.g_rec_type,

1340: -- ----------------------------------------------------------------------------
1341: -- |---------------------------< insert_validate >----------------------------|
1342: -- ----------------------------------------------------------------------------
1343: Procedure insert_validate
1344: (p_rec in ben_ldc_shd.g_rec_type,
1345: p_effective_date in date,
1346: p_datetrack_mode in varchar2,
1347: p_validation_start_date in date,
1348: p_validation_end_date in date) is

Line 1462: (p_rec in ben_ldc_shd.g_rec_type,

1458: -- ----------------------------------------------------------------------------
1459: -- |---------------------------< update_validate >----------------------------|
1460: -- ----------------------------------------------------------------------------
1461: Procedure update_validate
1462: (p_rec in ben_ldc_shd.g_rec_type,
1463: p_effective_date in date,
1464: p_datetrack_mode in varchar2,
1465: p_validation_start_date in date,
1466: p_validation_end_date in date) is

Line 1594: (p_rec in ben_ldc_shd.g_rec_type,

1590: -- ----------------------------------------------------------------------------
1591: -- |---------------------------< delete_validate >----------------------------|
1592: -- ----------------------------------------------------------------------------
1593: Procedure delete_validate
1594: (p_rec in ben_ldc_shd.g_rec_type,
1595: p_effective_date in date,
1596: p_datetrack_mode in varchar2,
1597: p_validation_start_date in date,
1598: p_validation_end_date in date) is