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_CCT_BUS dependencies on BEN_CCT_SHD

Line 48: l_api_updating := ben_cct_shd.api_updating

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

Line 55: <> ben_cct_shd.g_old_rec.cm_typ_id) then

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

Line 59: ben_cct_shd.constraint_error('BEN_CM_TYP_F_PK');

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

Line 69: ben_cct_shd.constraint_error('BEN_CM_TYP_F_PK');

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

Line 169: l_api_updating := ben_cct_shd.api_updating

165: Begin
166: --
167: hr_utility.set_location('Entering:'||l_proc, 5);
168: --
169: l_api_updating := ben_cct_shd.api_updating
170: (p_cm_typ_id => p_cm_typ_id,
171: p_effective_date => p_effective_date,
172: p_object_version_number => p_object_version_number);
173: --

Line 176: <> nvl(ben_cct_shd.g_old_rec.rcpent_cd,hr_api.g_varchar2)

172: p_object_version_number => p_object_version_number);
173: --
174: if (l_api_updating
175: and p_rcpent_cd
176: <> nvl(ben_cct_shd.g_old_rec.rcpent_cd,hr_api.g_varchar2)
177: or not l_api_updating) then
178: --
179: -- check if value of lookup falls within lookup type.
180: --

Line 241: l_api_updating := ben_cct_shd.api_updating

237: Begin
238: --
239: hr_utility.set_location('Entering:'||l_proc, 5);
240: --
241: l_api_updating := ben_cct_shd.api_updating
242: (p_cm_typ_id => p_cm_typ_id,
243: p_effective_date => p_effective_date,
244: p_object_version_number => p_object_version_number);
245: --

Line 248: <> ben_cct_shd.g_old_rec.inspn_rqd_rl

244: p_object_version_number => p_object_version_number);
245: --
246: if (l_api_updating
247: and nvl(p_inspn_rqd_rl,hr_api.g_number)
248: <> ben_cct_shd.g_old_rec.inspn_rqd_rl
249: or not l_api_updating)
250: and p_inspn_rqd_rl is not null then
251: --
252: -- check if value of formula rule is valid.

Line 311: l_api_updating := ben_cct_shd.api_updating

307: Begin
308: --
309: hr_utility.set_location('Entering:'||l_proc, 5);
310: --
311: l_api_updating := ben_cct_shd.api_updating
312: (p_cm_typ_id => p_cm_typ_id,
313: p_effective_date => p_effective_date,
314: p_object_version_number => p_object_version_number);
315: --

Line 318: <> nvl(ben_cct_shd.g_old_rec.inspn_rqd_flag,hr_api.g_varchar2)

314: p_object_version_number => p_object_version_number);
315: --
316: if (l_api_updating
317: and p_inspn_rqd_flag
318: <> nvl(ben_cct_shd.g_old_rec.inspn_rqd_flag,hr_api.g_varchar2)
319: or not l_api_updating) then
320: --
321: -- check if value of lookup falls within lookup type.
322: --

Line 382: l_api_updating := ben_cct_shd.api_updating

378: Begin
379: --
380: hr_utility.set_location('Entering:'||l_proc, 5);
381: --
382: l_api_updating := ben_cct_shd.api_updating
383: (p_cm_typ_id => p_cm_typ_id,
384: p_effective_date => p_effective_date,
385: p_object_version_number => p_object_version_number);
386: --

Line 389: <> ben_cct_shd.g_old_rec.to_be_sent_dt_rl

385: p_object_version_number => p_object_version_number);
386: --
387: if (l_api_updating
388: and nvl(p_to_be_sent_dt_rl,hr_api.g_number)
389: <> ben_cct_shd.g_old_rec.to_be_sent_dt_rl
390: or not l_api_updating)
391: and p_to_be_sent_dt_rl is not null then
392: --
393: -- check if value of formula rule is valid.

Line 452: l_api_updating := ben_cct_shd.api_updating

448: Begin
449: --
450: hr_utility.set_location('Entering:'||l_proc, 5);
451: --
452: l_api_updating := ben_cct_shd.api_updating
453: (p_cm_typ_id => p_cm_typ_id,
454: p_effective_date => p_effective_date,
455: p_object_version_number => p_object_version_number);
456: --

Line 459: <> nvl(ben_cct_shd.g_old_rec.to_be_sent_dt_cd,hr_api.g_varchar2)

455: p_object_version_number => p_object_version_number);
456: --
457: if (l_api_updating
458: and p_to_be_sent_dt_cd
459: <> nvl(ben_cct_shd.g_old_rec.to_be_sent_dt_cd,hr_api.g_varchar2)
460: or not l_api_updating) then
461: --
462: -- check if value of lookup falls within lookup type.
463: --

Line 524: l_api_updating := ben_cct_shd.api_updating

520: Begin
521: --
522: hr_utility.set_location('Entering:'||l_proc, 5);
523: --
524: l_api_updating := ben_cct_shd.api_updating
525: (p_cm_typ_id => p_cm_typ_id,
526: p_effective_date => p_effective_date,
527: p_object_version_number => p_object_version_number);
528: --

Line 531: <> nvl(ben_cct_shd.g_old_rec.trk_mlg_flag,hr_api.g_varchar2)

527: p_object_version_number => p_object_version_number);
528: --
529: if (l_api_updating
530: and p_trk_mlg_flag
531: <> nvl(ben_cct_shd.g_old_rec.trk_mlg_flag,hr_api.g_varchar2)
532: or not l_api_updating) then
533: --
534: -- check if value of lookup falls within lookup type.
535: --

Line 595: l_api_updating := ben_cct_shd.api_updating

591: Begin
592: --
593: hr_utility.set_location('Entering:'||l_proc, 5);
594: --
595: l_api_updating := ben_cct_shd.api_updating
596: (p_cm_typ_id => p_cm_typ_id,
597: p_effective_date => p_effective_date,
598: p_object_version_number => p_object_version_number);
599: --

Line 602: <> nvl(ben_cct_shd.g_old_rec.pc_kit_cd,hr_api.g_varchar2)

598: p_object_version_number => p_object_version_number);
599: --
600: if (l_api_updating
601: and p_pc_kit_cd
602: <> nvl(ben_cct_shd.g_old_rec.pc_kit_cd,hr_api.g_varchar2)
603: or not l_api_updating)
604: and p_pc_kit_cd is not null then
605: --
606: -- check if value of lookup falls within lookup type.

Line 666: l_api_updating := ben_cct_shd.api_updating

662: Begin
663: --
664: hr_utility.set_location('Entering:'||l_proc, 5);
665: --
666: l_api_updating := ben_cct_shd.api_updating
667: (p_cm_typ_id => p_cm_typ_id,
668: p_effective_date => p_effective_date,
669: p_object_version_number => p_object_version_number);
670: --

Line 673: <> nvl(ben_cct_shd.g_old_rec.whnvr_trgrd_flag,hr_api.g_varchar2)

669: p_object_version_number => p_object_version_number);
670: --
671: if (l_api_updating
672: and p_whnvr_trgrd_flag
673: <> nvl(ben_cct_shd.g_old_rec.whnvr_trgrd_flag,hr_api.g_varchar2)
674: or not l_api_updating) then
675: --
676: -- check if value of lookup falls within lookup type.
677: --

Line 738: l_api_updating := ben_cct_shd.api_updating

734: Begin
735: --
736: hr_utility.set_location('Entering:'||l_proc, 5);
737: --
738: l_api_updating := ben_cct_shd.api_updating
739: (p_cm_typ_id => p_cm_typ_id,
740: p_effective_date => p_effective_date,
741: p_object_version_number => p_object_version_number);
742: --

Line 745: <> nvl(ben_cct_shd.g_old_rec.cm_usg_cd,hr_api.g_varchar2)

741: p_object_version_number => p_object_version_number);
742: --
743: if (l_api_updating
744: and p_cm_usg_cd
745: <> nvl(ben_cct_shd.g_old_rec.cm_usg_cd,hr_api.g_varchar2)
746: or not l_api_updating)
747: and p_cm_usg_cd is not null then
748: --
749: -- check if value of lookup falls within lookup type.

Line 819: l_api_updating := ben_cct_shd.api_updating

815: Begin
816: --
817: hr_utility.set_location('Entering:'||l_proc, 5);
818: --
819: l_api_updating := ben_cct_shd.api_updating
820: (p_cm_typ_id => p_cm_typ_id,
821: p_effective_date => p_effective_date,
822: p_object_version_number => p_object_version_number);
823: --

Line 826: <> ben_cct_shd.g_old_rec.cm_typ_rl

822: p_object_version_number => p_object_version_number);
823: --
824: if (l_api_updating
825: and nvl(p_cm_typ_rl,hr_api.g_number)
826: <> ben_cct_shd.g_old_rec.cm_typ_rl
827: or not l_api_updating)
828: and p_cm_typ_rl is not null then
829: --
830: -- check if value of formula rule is valid.

Line 1094: (p_rec in ben_cct_shd.g_rec_type,

1090: -- ----------------------------------------------------------------------------
1091: -- |---------------------------< insert_validate >----------------------------|
1092: -- ----------------------------------------------------------------------------
1093: Procedure insert_validate
1094: (p_rec in ben_cct_shd.g_rec_type,
1095: p_effective_date in date,
1096: p_datetrack_mode in varchar2,
1097: p_validation_start_date in date,
1098: p_validation_end_date in date) is

Line 1191: (p_rec in ben_cct_shd.g_rec_type,

1187: -- ----------------------------------------------------------------------------
1188: -- |---------------------------< update_validate >----------------------------|
1189: -- ----------------------------------------------------------------------------
1190: Procedure update_validate
1191: (p_rec in ben_cct_shd.g_rec_type,
1192: p_effective_date in date,
1193: p_datetrack_mode in varchar2,
1194: p_validation_start_date in date,
1195: p_validation_end_date in date) is

Line 1297: (p_rec in ben_cct_shd.g_rec_type,

1293: -- ----------------------------------------------------------------------------
1294: -- |---------------------------< delete_validate >----------------------------|
1295: -- ----------------------------------------------------------------------------
1296: Procedure delete_validate
1297: (p_rec in ben_cct_shd.g_rec_type,
1298: p_effective_date in date,
1299: p_datetrack_mode in varchar2,
1300: p_validation_start_date in date,
1301: p_validation_end_date in date) is