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_ESH_BUS dependencies on BEN_ESH_SHD

Line 48: l_api_updating := ben_esh_shd.api_updating

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

Line 55: <> ben_esh_shd.g_old_rec.elig_schedd_hrs_prte_id) then

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

Line 59: ben_esh_shd.constraint_error('BEN_ELIG_SCH_HRS_PK');

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

Line 69: ben_esh_shd.constraint_error('BEN_ELIG_SCH_HRS_PK');

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

Line 117: l_api_updating := ben_esh_shd.api_updating

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

Line 124: <> nvl(ben_esh_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

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

Line 268: l_api_updating := ben_esh_shd.api_updating

264: Begin
265: --
266: hr_utility.set_location('Entering:'||l_proc, 5);
267: --
268: l_api_updating := ben_esh_shd.api_updating
269: (p_elig_schedd_hrs_prte_id => p_elig_schedd_hrs_prte_id,
270: p_effective_date => p_effective_date,
271: p_object_version_number => p_object_version_number);
272: --

Line 275: <> nvl(ben_esh_shd.g_old_rec.freq_cd,hr_api.g_varchar2)

271: p_object_version_number => p_object_version_number);
272: --
273: /* if (l_api_updating
274: and p_freq_cd
275: <> nvl(ben_esh_shd.g_old_rec.freq_cd,hr_api.g_varchar2)
276: or not l_api_updating)
277: and p_freq_cd is not null then
278: */
279: --

Line 346: l_api_updating := ben_esh_shd.api_updating

342: Begin
343: --
344: hr_utility.set_location('Entering:'||l_proc, 5);
345: --
346: l_api_updating := ben_esh_shd.api_updating
347: (p_elig_schedd_hrs_prte_id => p_elig_schedd_hrs_prte_id,
348: p_effective_date => p_effective_date,
349: p_object_version_number => p_object_version_number);
350: --

Line 353: <> nvl(ben_esh_shd.g_old_rec.freq_cd,hr_api.g_varchar2)

349: p_object_version_number => p_object_version_number);
350: --
351: if (l_api_updating
352: and p_freq_cd
353: <> nvl(ben_esh_shd.g_old_rec.freq_cd,hr_api.g_varchar2)
354: or not l_api_updating)
355: and p_freq_cd is not null then
356: --
357: -- check if value of lookup falls within lookup type.

Line 424: l_api_updating := ben_esh_shd.api_updating

420: Begin
421: --
422: hr_utility.set_location('Entering:'||l_proc, 5);
423: --
424: l_api_updating := ben_esh_shd.api_updating
425: (p_elig_schedd_hrs_prte_id => p_elig_schedd_hrs_prte_id,
426: p_effective_date => p_effective_date,
427: p_object_version_number => p_object_version_number);
428: --

Line 431: <> nvl(ben_esh_shd.g_old_rec.determination_cd,hr_api.g_varchar2)

427: p_object_version_number => p_object_version_number);
428: --
429: if (l_api_updating
430: and p_determination_cd
431: <> nvl(ben_esh_shd.g_old_rec.determination_cd,hr_api.g_varchar2)
432: or not l_api_updating)
433: and p_determination_cd is not null then
434: --
435: -- check if value of lookup falls within lookup type.

Line 516: l_api_updating := ben_esh_shd.api_updating

512: Begin
513: --
514: hr_utility.set_location('Entering:'||l_proc, 5);
515: --
516: l_api_updating := ben_esh_shd.api_updating
517: (p_elig_schedd_hrs_prte_id => p_elig_schedd_hrs_prte_id,
518: p_effective_date => p_effective_date,
519: p_object_version_number => p_object_version_number);
520: --

Line 523: <> nvl(ben_esh_shd.g_old_rec.rounding_cd,hr_api.g_varchar2)

519: p_object_version_number => p_object_version_number);
520: --
521: if (l_api_updating
522: and p_rounding_cd
523: <> nvl(ben_esh_shd.g_old_rec.rounding_cd,hr_api.g_varchar2)
524: or not l_api_updating)
525: and p_rounding_cd is not null then
526: --
527: if nvl(p_rounding_cd,hr_api.g_number)='RL' and p_rounding_rl is null then

Line 671: l_api_updating := ben_esh_shd.api_updating

667: Begin
668: --
669: hr_utility.set_location('Entering:'||l_proc, 5);
670: --
671: l_api_updating := ben_esh_shd.api_updating
672: (p_elig_schedd_hrs_prte_id => p_elig_schedd_hrs_prte_id,
673: p_effective_date => p_effective_date,
674: p_object_version_number => p_object_version_number);
675: --

Line 678: <> nvl(ben_esh_shd.g_old_rec.determination_rl,hr_api.g_number)

674: p_object_version_number => p_object_version_number);
675: --
676: if (l_api_updating
677: and p_determination_rl
678: <> nvl(ben_esh_shd.g_old_rec.determination_rl,hr_api.g_number)
679: or not l_api_updating)
680: -- and p_determination_cd is not null
681: and p_determination_rl is not null then
682: --

Line 765: l_api_updating := ben_esh_shd.api_updating

761: Begin
762: --
763: hr_utility.set_location('Entering:'||l_proc, 5);
764: --
765: l_api_updating := ben_esh_shd.api_updating
766: (p_elig_schedd_hrs_prte_id => p_elig_schedd_hrs_prte_id,
767: p_effective_date => p_effective_date,
768: p_object_version_number => p_object_version_number);
769: --

Line 772: <> nvl(ben_esh_shd.g_old_rec.rounding_rl,hr_api.g_number)

768: p_object_version_number => p_object_version_number);
769: --
770: if (l_api_updating
771: and p_rounding_rl
772: <> nvl(ben_esh_shd.g_old_rec.rounding_rl,hr_api.g_number)
773: or not l_api_updating)
774: -- and p_rounding_cd is not null
775: and p_rounding_rl is not null then
776: --

Line 853: l_api_updating := ben_esh_shd.api_updating

849: Begin
850: --
851: hr_utility.set_location('Entering:'||l_proc, 5);
852: --
853: l_api_updating := ben_esh_shd.api_updating
854: (p_elig_schedd_hrs_prte_id => p_elig_schedd_hrs_prte_id,
855: p_effective_date => p_effective_date,
856: p_object_version_number => p_object_version_number);
857: --

Line 860: <> nvl(ben_esh_shd.g_old_rec.schedd_hrs_rl,hr_api.g_number)

856: p_object_version_number => p_object_version_number);
857: --
858: if (l_api_updating
859: and p_schedd_hrs_rl
860: <> nvl(ben_esh_shd.g_old_rec.schedd_hrs_rl,hr_api.g_number)
861: or not l_api_updating)
862: and p_schedd_hrs_rl is not null then
863: --
864: -- check if formula exists.

Line 926: l_api_updating := ben_esh_shd.api_updating

922: Begin
923: --
924: hr_utility.set_location('Entering:'||l_proc, 5);
925: --
926: l_api_updating := ben_esh_shd.api_updating
927: (p_elig_schedd_hrs_prte_id => p_elig_schedd_hrs_prte_id,
928: p_effective_date => p_effective_date,
929: p_object_version_number => p_object_version_number);
930: --

Line 931: if (l_api_updating and p_hrs_num <> nvl(ben_esh_shd.g_old_rec.hrs_num,hr_api.g_number))

927: (p_elig_schedd_hrs_prte_id => p_elig_schedd_hrs_prte_id,
928: p_effective_date => p_effective_date,
929: p_object_version_number => p_object_version_number);
930: --
931: if (l_api_updating and p_hrs_num <> nvl(ben_esh_shd.g_old_rec.hrs_num,hr_api.g_number))
932: or (l_api_updating and p_max_hrs_num <> nvl(ben_esh_shd.g_old_rec.max_hrs_num,hr_api.g_number))
933: or (l_api_updating and p_freq_cd <> nvl(ben_esh_shd.g_old_rec.freq_cd,hr_api.g_varchar2))
934: or not l_api_updating
935: or (nvl(p_hrs_num,hr_api.g_number) is not null and nvl(p_max_hrs_num,hr_api.g_number) is not null) then

Line 932: or (l_api_updating and p_max_hrs_num <> nvl(ben_esh_shd.g_old_rec.max_hrs_num,hr_api.g_number))

928: p_effective_date => p_effective_date,
929: p_object_version_number => p_object_version_number);
930: --
931: if (l_api_updating and p_hrs_num <> nvl(ben_esh_shd.g_old_rec.hrs_num,hr_api.g_number))
932: or (l_api_updating and p_max_hrs_num <> nvl(ben_esh_shd.g_old_rec.max_hrs_num,hr_api.g_number))
933: or (l_api_updating and p_freq_cd <> nvl(ben_esh_shd.g_old_rec.freq_cd,hr_api.g_varchar2))
934: or not l_api_updating
935: or (nvl(p_hrs_num,hr_api.g_number) is not null and nvl(p_max_hrs_num,hr_api.g_number) is not null) then
936: --

Line 933: or (l_api_updating and p_freq_cd <> nvl(ben_esh_shd.g_old_rec.freq_cd,hr_api.g_varchar2))

929: p_object_version_number => p_object_version_number);
930: --
931: if (l_api_updating and p_hrs_num <> nvl(ben_esh_shd.g_old_rec.hrs_num,hr_api.g_number))
932: or (l_api_updating and p_max_hrs_num <> nvl(ben_esh_shd.g_old_rec.max_hrs_num,hr_api.g_number))
933: or (l_api_updating and p_freq_cd <> nvl(ben_esh_shd.g_old_rec.freq_cd,hr_api.g_varchar2))
934: or not l_api_updating
935: or (nvl(p_hrs_num,hr_api.g_number) is not null and nvl(p_max_hrs_num,hr_api.g_number) is not null) then
936: --
937: hr_utility.set_location('Inside:'||l_proc,8);

Line 1184: (p_rec in ben_esh_shd.g_rec_type,

1180: -- ----------------------------------------------------------------------------
1181: -- |---------------------------< insert_validate >----------------------------|
1182: -- ----------------------------------------------------------------------------
1183: Procedure insert_validate
1184: (p_rec in ben_esh_shd.g_rec_type,
1185: p_effective_date in date,
1186: p_datetrack_mode in varchar2,
1187: p_validation_start_date in date,
1188: p_validation_end_date in date) is

Line 1289: (p_rec in ben_esh_shd.g_rec_type,

1285: -- ----------------------------------------------------------------------------
1286: -- |---------------------------< update_validate >----------------------------|
1287: -- ----------------------------------------------------------------------------
1288: Procedure update_validate
1289: (p_rec in ben_esh_shd.g_rec_type,
1290: p_effective_date in date,
1291: p_datetrack_mode in varchar2,
1292: p_validation_start_date in date,
1293: p_validation_end_date in date) is

Line 1402: (p_rec in ben_esh_shd.g_rec_type,

1398: -- ----------------------------------------------------------------------------
1399: -- |---------------------------< delete_validate >----------------------------|
1400: -- ----------------------------------------------------------------------------
1401: Procedure delete_validate
1402: (p_rec in ben_esh_shd.g_rec_type,
1403: p_effective_date in date,
1404: p_datetrack_mode in varchar2,
1405: p_validation_start_date in date,
1406: p_validation_end_date in date) is