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_PTP_BUS dependencies on BEN_PTP_SHD

Line 48: l_api_updating := ben_ptp_shd.api_updating

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

Line 55: <> ben_ptp_shd.g_old_rec.pl_typ_id) then

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

Line 59: ben_ptp_shd.constraint_error('BEN_PL_TYP_F_PK');

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

Line 69: ben_ptp_shd.constraint_error('BEN_PL_TYP_F_PK');

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

Line 117: l_api_updating := ben_ptp_shd.api_updating

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

Line 124: <> nvl(ben_ptp_shd.g_old_rec.no_mn_enrl_num_dfnd_flag,hr_api.g_varchar2)

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

Line 186: l_api_updating := ben_ptp_shd.api_updating

182: Begin
183: --
184: hr_utility.set_location('Entering:'||l_proc, 5);
185: --
186: l_api_updating := ben_ptp_shd.api_updating
187: (p_pl_typ_id => p_pl_typ_id,
188: p_effective_date => p_effective_date,
189: p_object_version_number => p_object_version_number);
190: --

Line 193: <> nvl(ben_ptp_shd.g_old_rec.no_mx_enrl_num_dfnd_flag,hr_api.g_varchar2)

189: p_object_version_number => p_object_version_number);
190: --
191: if (l_api_updating
192: and p_no_mx_enrl_num_dfnd_flag
193: <> nvl(ben_ptp_shd.g_old_rec.no_mx_enrl_num_dfnd_flag,hr_api.g_varchar2)
194: or not l_api_updating)
195: and p_no_mx_enrl_num_dfnd_flag is not null then
196: --
197: -- check if value of lookup falls within lookup type.

Line 255: l_api_updating := ben_ptp_shd.api_updating

251: Begin
252: --
253: hr_utility.set_location('Entering:'||l_proc, 5);
254: --
255: l_api_updating := ben_ptp_shd.api_updating
256: (p_pl_typ_id => p_pl_typ_id,
257: p_effective_date => p_effective_date,
258: p_object_version_number => p_object_version_number);
259: --

Line 262: <> nvl(ben_ptp_shd.g_old_rec.opt_typ_cd,hr_api.g_varchar2)

258: p_object_version_number => p_object_version_number);
259: --
260: if (l_api_updating
261: and p_opt_typ_cd
262: <> nvl(ben_ptp_shd.g_old_rec.opt_typ_cd,hr_api.g_varchar2)
263: or not l_api_updating) then
264: --
265: -- check if value of lookup falls within lookup type.
266: --

Line 349: l_api_updating := ben_ptp_shd.api_updating

345: Begin
346: --
347: hr_utility.set_location('Entering:'||l_proc, 5);
348: --
349: l_api_updating := ben_ptp_shd.api_updating
350: (p_pl_typ_id => p_pl_typ_id,
351: p_effective_date => p_effective_date,
352: p_object_version_number => p_object_version_number);
353: --

Line 355: and p_opt_typ_cd <> nvl(ben_ptp_shd.g_old_rec.opt_typ_cd,hr_api.g_varchar2)

351: p_effective_date => p_effective_date,
352: p_object_version_number => p_object_version_number);
353: --
354: if (l_api_updating
355: and p_opt_typ_cd <> nvl(ben_ptp_shd.g_old_rec.opt_typ_cd,hr_api.g_varchar2)
356: and nvl(ben_ptp_shd.g_old_rec.opt_typ_cd,hr_api.g_varchar2) = 'COMP')
357: then
358: --
359: --

Line 356: and nvl(ben_ptp_shd.g_old_rec.opt_typ_cd,hr_api.g_varchar2) = 'COMP')

352: p_object_version_number => p_object_version_number);
353: --
354: if (l_api_updating
355: and p_opt_typ_cd <> nvl(ben_ptp_shd.g_old_rec.opt_typ_cd,hr_api.g_varchar2)
356: and nvl(ben_ptp_shd.g_old_rec.opt_typ_cd,hr_api.g_varchar2) = 'COMP')
357: then
358: --
359: --
360: open c1;

Line 423: l_api_updating := ben_ptp_shd.api_updating

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

Line 430: <> nvl(ben_ptp_shd.g_old_rec.opt_dsply_fmt_cd,hr_api.g_varchar2)

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

Line 516: l_api_updating := ben_ptp_shd.api_updating

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

Line 523: <> nvl(ben_ptp_shd.g_old_rec.comp_typ_cd,hr_api.g_varchar2)

519: p_object_version_number => p_object_version_number);
520: --
521: if (l_api_updating
522: and p_comp_typ_cd
523: <> nvl(ben_ptp_shd.g_old_rec.comp_typ_cd,hr_api.g_varchar2)
524: or not l_api_updating)
525: and p_comp_typ_cd is not null then
526: --
527: -- check if value of lookup falls within lookup type.

Line 586: l_api_updating := ben_ptp_shd.api_updating

582: Begin
583: --
584: hr_utility.set_location('Entering:'||l_proc, 5);
585: --
586: l_api_updating := ben_ptp_shd.api_updating
587: (p_pl_typ_id => p_pl_typ_id,
588: p_effective_date => p_effective_date,
589: p_object_version_number => p_object_version_number);
590: --

Line 593: <> nvl(ben_ptp_shd.g_old_rec.pl_typ_stat_cd,hr_api.g_varchar2)

589: p_object_version_number => p_object_version_number);
590: --
591: if (l_api_updating
592: and p_pl_typ_stat_cd
593: <> nvl(ben_ptp_shd.g_old_rec.pl_typ_stat_cd,hr_api.g_varchar2)
594: or not l_api_updating)
595: and p_pl_typ_stat_cd is not null then
596: --
597: -- check if value of lookup falls within lookup type.

Line 677: l_api_updating := ben_ptp_shd.api_updating

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

Line 683: and p_name <> ben_ptp_shd.g_old_rec.name) or

679: p_pl_typ_id => p_pl_typ_id,
680: p_object_version_number => p_object_version_number);
681: --
682: if (l_api_updating
683: and p_name <> ben_ptp_shd.g_old_rec.name) or
684: not l_api_updating then
685: --
686: hr_utility.set_location('Entering:'||l_proc, 10);
687: --

Line 859: l_api_updating := ben_ptp_shd.api_updating

855: --
856: hr_utility.set_location('Entering:'||l_proc, 5);
857: --
858: --
859: l_api_updating := ben_ptp_shd.api_updating
860: (p_effective_date => p_effective_date,
861: p_pl_typ_id => p_pl_typ_id,
862: p_object_version_number => p_object_version_number);
863: --

Line 866: and p_opt_typ_cd <> ben_ptp_shd.g_old_rec.opt_typ_cd) or

862: p_object_version_number => p_object_version_number);
863: --
864: if p_opt_typ_cd = 'GSP' and
865: ((l_api_updating
866: and p_opt_typ_cd <> ben_ptp_shd.g_old_rec.opt_typ_cd) or
867: not l_api_updating )then
868: --
869: open c_opt_typ_cd;
870: fetch c_opt_typ_cd into l_dummy;

Line 1118: (p_rec in ben_ptp_shd.g_rec_type,

1114: -- ----------------------------------------------------------------------------
1115: -- |---------------------------< insert_validate >----------------------------|
1116: -- ----------------------------------------------------------------------------
1117: Procedure insert_validate
1118: (p_rec in ben_ptp_shd.g_rec_type,
1119: p_effective_date in date,
1120: p_datetrack_mode in varchar2,
1121: p_validation_start_date in date,
1122: p_validation_end_date in date) is

Line 1210: (p_rec in ben_ptp_shd.g_rec_type,

1206: -- ----------------------------------------------------------------------------
1207: -- |---------------------------< update_validate >----------------------------|
1208: -- ----------------------------------------------------------------------------
1209: Procedure update_validate
1210: (p_rec in ben_ptp_shd.g_rec_type,
1211: p_effective_date in date,
1212: p_datetrack_mode in varchar2,
1213: p_validation_start_date in date,
1214: p_validation_end_date in date) is

Line 1320: (p_rec in ben_ptp_shd.g_rec_type,

1316: -- ----------------------------------------------------------------------------
1317: -- |---------------------------< delete_validate >----------------------------|
1318: -- ----------------------------------------------------------------------------
1319: Procedure delete_validate
1320: (p_rec in ben_ptp_shd.g_rec_type,
1321: p_effective_date in date,
1322: p_datetrack_mode in varchar2,
1323: p_validation_start_date in date,
1324: p_validation_end_date in date) is