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_DCR_BUS dependencies on BEN_DCR_SHD

Line 48: l_api_updating := ben_dcr_shd.api_updating

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

Line 55: <> ben_dcr_shd.g_old_rec.dpnt_cvg_rqd_rlshp_id) then

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

Line 59: ben_dcr_shd.constraint_error('BEN_DP_CVG_R_RLSP_PK');

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

Line 69: ben_dcr_shd.constraint_error('BEN_DP_CVG_R_RLSP_PK');

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

Line 118: l_api_updating := ben_dcr_shd.api_updating

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

Line 125: <> nvl(ben_dcr_shd.g_old_rec.per_relshp_typ_cd,hr_api.g_varchar2)

121: p_object_version_number => p_object_version_number);
122: --
123: if (l_api_updating
124: and nvl(p_per_relshp_typ_cd,hr_api.g_varchar2)
125: <> nvl(ben_dcr_shd.g_old_rec.per_relshp_typ_cd,hr_api.g_varchar2)
126: or not l_api_updating) then
127: --
128: -- check if per_relshp_typ_cd value exists in hr_lookups table
129: --

Line 196: l_api_updating := ben_dcr_shd.api_updating

192: Begin
193: --
194: hr_utility.set_location('Entering:'||l_proc, 5);
195: --
196: l_api_updating := ben_dcr_shd.api_updating
197: (p_dpnt_cvg_rqd_rlshp_id => p_dpnt_cvg_rqd_rlshp_id,
198: p_effective_date => p_effective_date,
199: p_object_version_number => p_object_version_number);
200: --

Line 203: <> ben_dcr_shd.g_old_rec.cvg_strt_dt_rl

199: p_object_version_number => p_object_version_number);
200: --
201: if (l_api_updating
202: and nvl(p_cvg_strt_dt_rl,hr_api.g_number)
203: <> ben_dcr_shd.g_old_rec.cvg_strt_dt_rl
204: or not l_api_updating)
205: and p_cvg_strt_dt_rl is not null then
206: --
207: -- check if value of formula rule is valid.

Line 273: l_api_updating := ben_dcr_shd.api_updating

269: Begin
270: --
271: hr_utility.set_location('Entering:'||l_proc, 5);
272: --
273: l_api_updating := ben_dcr_shd.api_updating
274: (p_dpnt_cvg_rqd_rlshp_id => p_dpnt_cvg_rqd_rlshp_id,
275: p_effective_date => p_effective_date,
276: p_object_version_number => p_object_version_number);
277: --

Line 280: <> nvl(ben_dcr_shd.g_old_rec.cvg_thru_dt_cd,hr_api.g_varchar2)

276: p_object_version_number => p_object_version_number);
277: --
278: if (l_api_updating
279: and p_cvg_thru_dt_cd
280: <> nvl(ben_dcr_shd.g_old_rec.cvg_thru_dt_cd,hr_api.g_varchar2)
281: or not l_api_updating)
282: and p_cvg_thru_dt_cd is not null then
283: --
284: -- check if value of lookup falls within lookup type.

Line 352: l_api_updating := ben_dcr_shd.api_updating

348: Begin
349: --
350: hr_utility.set_location('Entering:'||l_proc, 5);
351: --
352: l_api_updating := ben_dcr_shd.api_updating
353: (p_dpnt_cvg_rqd_rlshp_id => p_dpnt_cvg_rqd_rlshp_id,
354: p_effective_date => p_effective_date,
355: p_object_version_number => p_object_version_number);
356: --

Line 359: <> ben_dcr_shd.g_old_rec.cvg_thru_dt_rl

355: p_object_version_number => p_object_version_number);
356: --
357: if (l_api_updating
358: and nvl(p_cvg_thru_dt_rl,hr_api.g_number)
359: <> ben_dcr_shd.g_old_rec.cvg_thru_dt_rl
360: or not l_api_updating)
361: and p_cvg_thru_dt_rl is not null then
362: --
363: -- check if value of formula rule is valid.

Line 429: l_api_updating := ben_dcr_shd.api_updating

425: Begin
426: --
427: hr_utility.set_location('Entering:'||l_proc, 5);
428: --
429: l_api_updating := ben_dcr_shd.api_updating
430: (p_dpnt_cvg_rqd_rlshp_id => p_dpnt_cvg_rqd_rlshp_id,
431: p_effective_date => p_effective_date,
432: p_object_version_number => p_object_version_number);
433: --

Line 436: <> nvl(ben_dcr_shd.g_old_rec.cvg_strt_dt_cd,hr_api.g_varchar2)

432: p_object_version_number => p_object_version_number);
433: --
434: if (l_api_updating
435: and p_cvg_strt_dt_cd
436: <> nvl(ben_dcr_shd.g_old_rec.cvg_strt_dt_cd,hr_api.g_varchar2)
437: or not l_api_updating)
438: and p_cvg_strt_dt_cd is not null then
439: --
440: -- check if value of lookup falls within lookup type.

Line 505: l_api_updating := ben_dcr_shd.api_updating

501: Begin
502: --
503: hr_utility.set_location('Entering:'||l_proc, 5);
504: --
505: l_api_updating := ben_dcr_shd.api_updating
506: (p_dpnt_cvg_rqd_rlshp_id => p_dpnt_cvg_rqd_rlshp_id,
507: p_effective_date => p_effective_date,
508: p_object_version_number => p_object_version_number);
509: --

Line 513: nvl(ben_dcr_shd.g_old_rec.cvg_strt_dt_cd,hr_api.g_varchar2) or

509: --
510:
511: if (l_api_updating
512: and (nvl(p_cvg_strt_dt_cd, hr_api.g_varchar2) <>
513: nvl(ben_dcr_shd.g_old_rec.cvg_strt_dt_cd,hr_api.g_varchar2) or
514: nvl(p_cvg_strt_dt_rl, hr_api.g_number) <>
515: nvl(ben_dcr_shd.g_old_rec.cvg_strt_dt_rl,hr_api.g_number))
516: or not l_api_updating) then
517:

Line 515: nvl(ben_dcr_shd.g_old_rec.cvg_strt_dt_rl,hr_api.g_number))

511: if (l_api_updating
512: and (nvl(p_cvg_strt_dt_cd, hr_api.g_varchar2) <>
513: nvl(ben_dcr_shd.g_old_rec.cvg_strt_dt_cd,hr_api.g_varchar2) or
514: nvl(p_cvg_strt_dt_rl, hr_api.g_number) <>
515: nvl(ben_dcr_shd.g_old_rec.cvg_strt_dt_rl,hr_api.g_number))
516: or not l_api_updating) then
517:
518: --
519: -- check dependency of Code and Rule.

Line 584: l_api_updating := ben_dcr_shd.api_updating

580: Begin
581: --
582: hr_utility.set_location('Entering:'||l_proc, 5);
583: --
584: l_api_updating := ben_dcr_shd.api_updating
585: (p_dpnt_cvg_rqd_rlshp_id => p_dpnt_cvg_rqd_rlshp_id,
586: p_effective_date => p_effective_date,
587: p_object_version_number => p_object_version_number);
588: --

Line 592: nvl(ben_dcr_shd.g_old_rec.cvg_thru_dt_cd,hr_api.g_varchar2) or

588: --
589:
590: if (l_api_updating
591: and (nvl(p_cvg_thru_dt_cd, hr_api.g_varchar2) <>
592: nvl(ben_dcr_shd.g_old_rec.cvg_thru_dt_cd,hr_api.g_varchar2) or
593: nvl(p_cvg_thru_dt_rl, hr_api.g_number) <>
594: nvl(ben_dcr_shd.g_old_rec.cvg_thru_dt_rl,hr_api.g_number))
595: or not l_api_updating) then
596:

Line 594: nvl(ben_dcr_shd.g_old_rec.cvg_thru_dt_rl,hr_api.g_number))

590: if (l_api_updating
591: and (nvl(p_cvg_thru_dt_cd, hr_api.g_varchar2) <>
592: nvl(ben_dcr_shd.g_old_rec.cvg_thru_dt_cd,hr_api.g_varchar2) or
593: nvl(p_cvg_thru_dt_rl, hr_api.g_number) <>
594: nvl(ben_dcr_shd.g_old_rec.cvg_thru_dt_rl,hr_api.g_number))
595: or not l_api_updating) then
596:
597: --
598: -- check dependency of Code and Rule.

Line 663: l_api_updating := ben_dcr_shd.api_updating

659: Begin
660: --
661: hr_utility.set_location('Entering:'||l_proc, 5);
662: --
663: l_api_updating := ben_dcr_shd.api_updating
664: (p_dpnt_cvg_rqd_rlshp_id => p_dpnt_cvg_rqd_rlshp_id,
665: p_effective_date => p_effective_date,
666: p_object_version_number => p_object_version_number);
667: --

Line 671: nvl(ben_dcr_shd.g_old_rec.cvg_strt_dt_cd,hr_api.g_varchar2) or

667: --
668:
669: if (l_api_updating
670: and (nvl(p_cvg_strt_dt_cd, hr_api.g_varchar2) <>
671: nvl(ben_dcr_shd.g_old_rec.cvg_strt_dt_cd,hr_api.g_varchar2) or
672: nvl(p_cvg_thru_dt_cd, hr_api.g_varchar2) <>
673: nvl(ben_dcr_shd.g_old_rec.cvg_thru_dt_cd,hr_api.g_varchar2))
674: or not l_api_updating) then
675:

Line 673: nvl(ben_dcr_shd.g_old_rec.cvg_thru_dt_cd,hr_api.g_varchar2))

669: if (l_api_updating
670: and (nvl(p_cvg_strt_dt_cd, hr_api.g_varchar2) <>
671: nvl(ben_dcr_shd.g_old_rec.cvg_strt_dt_cd,hr_api.g_varchar2) or
672: nvl(p_cvg_thru_dt_cd, hr_api.g_varchar2) <>
673: nvl(ben_dcr_shd.g_old_rec.cvg_thru_dt_cd,hr_api.g_varchar2))
674: or not l_api_updating) then
675:
676: --
677: -- check dependent Relationship of Start Date and through Date.

Line 968: (p_rec in ben_dcr_shd.g_rec_type,

964: -- ----------------------------------------------------------------------------
965: -- |---------------------------< insert_validate >----------------------------|
966: -- ----------------------------------------------------------------------------
967: Procedure insert_validate
968: (p_rec in ben_dcr_shd.g_rec_type,
969: p_effective_date in date,
970: p_datetrack_mode in varchar2,
971: p_validation_start_date in date,
972: p_validation_end_date in date) is

Line 1047: (p_rec in ben_dcr_shd.g_rec_type,

1043: -- ----------------------------------------------------------------------------
1044: -- |---------------------------< update_validate >----------------------------|
1045: -- ----------------------------------------------------------------------------
1046: Procedure update_validate
1047: (p_rec in ben_dcr_shd.g_rec_type,
1048: p_effective_date in date,
1049: p_datetrack_mode in varchar2,
1050: p_validation_start_date in date,
1051: p_validation_end_date in date) is

Line 1135: (p_rec in ben_dcr_shd.g_rec_type,

1131: -- ----------------------------------------------------------------------------
1132: -- |---------------------------< delete_validate >----------------------------|
1133: -- ----------------------------------------------------------------------------
1134: Procedure delete_validate
1135: (p_rec in ben_dcr_shd.g_rec_type,
1136: p_effective_date in date,
1137: p_datetrack_mode in varchar2,
1138: p_validation_start_date in date,
1139: p_validation_end_date in date) is