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_ECC_BUS dependencies on BEN_ECC_SHD

Line 46: l_api_updating := ben_ecc_shd.api_updating

42: Begin
43: --
44: hr_utility.set_location('Entering:'||l_proc, 5);
45: --
46: l_api_updating := ben_ecc_shd.api_updating
47: (p_elctbl_chc_ctfn_id => p_elctbl_chc_ctfn_id,
48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating

Line 52: <> ben_ecc_shd.g_old_rec.elctbl_chc_ctfn_id) then

48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating
51: and nvl(p_elctbl_chc_ctfn_id,hr_api.g_number)
52: <> ben_ecc_shd.g_old_rec.elctbl_chc_ctfn_id) then
53: --
54: -- raise error as PK has changed
55: --
56: ben_ecc_shd.constraint_error('BEN_ELCTBL_CHC_CTFN_PK');

Line 56: ben_ecc_shd.constraint_error('BEN_ELCTBL_CHC_CTFN_PK');

52: <> ben_ecc_shd.g_old_rec.elctbl_chc_ctfn_id) then
53: --
54: -- raise error as PK has changed
55: --
56: ben_ecc_shd.constraint_error('BEN_ELCTBL_CHC_CTFN_PK');
57: --
58: elsif not l_api_updating then
59: --
60: -- check if PK is null

Line 66: ben_ecc_shd.constraint_error('BEN_ELCTBL_CHC_CTFN_PK');

62: if p_elctbl_chc_ctfn_id is not null then
63: --
64: -- raise error as PK is not null
65: --
66: ben_ecc_shd.constraint_error('BEN_ELCTBL_CHC_CTFN_PK');
67: --
68: end if;
69: --
70: end if;

Line 125: <> nvl(ben_ecc_shd.g_old_rec.enrt_bnft_id,hr_api.g_number)

121: p_object_version_number => null);
122: --
123: if (l_api_updating
124: and nvl(p_enrt_bnft_id,hr_api.g_number)
125: <> nvl(ben_ecc_shd.g_old_rec.enrt_bnft_id,hr_api.g_number)
126: or not l_api_updating) and
127: p_enrt_bnft_id is not null then
128: --
129: -- check if enrt_bnft_id value exists in ben_enrt_bnft table

Line 141: ben_ecc_shd.constraint_error('BEN_ELCTBL_CHC_CTFN_FK2');

137: --
138: -- raise error as FK does not relate to PK in ben_enrt_bnft
139: -- table.
140: --
141: ben_ecc_shd.constraint_error('BEN_ELCTBL_CHC_CTFN_FK2');
142: --
143: end if;
144: --
145: close c1;

Line 191: l_api_updating := ben_ecc_shd.api_updating

187: Begin
188: --
189: hr_utility.set_location('Entering:'||l_proc, 5);
190: --
191: l_api_updating := ben_ecc_shd.api_updating
192: (p_elctbl_chc_ctfn_id => p_elctbl_chc_ctfn_id,
193: p_object_version_number => p_object_version_number);
194: --
195: if (l_api_updating

Line 197: <> nvl(ben_ecc_shd.g_old_rec.rqd_flag,hr_api.g_varchar2)

193: p_object_version_number => p_object_version_number);
194: --
195: if (l_api_updating
196: and p_rqd_flag
197: <> nvl(ben_ecc_shd.g_old_rec.rqd_flag,hr_api.g_varchar2)
198: or not l_api_updating) then
199: --
200: -- check if value of lookup falls within lookup type.
201: --

Line 259: l_api_updating := ben_ecc_shd.api_updating

255: Begin
256: --
257: hr_utility.set_location('Entering:'||l_proc, 5);
258: --
259: l_api_updating := ben_ecc_shd.api_updating
260: (p_elctbl_chc_ctfn_id => p_elctbl_chc_ctfn_id,
261: p_object_version_number => p_object_version_number);
262: --
263: if (l_api_updating

Line 265: <> nvl(ben_ecc_shd.g_old_rec.enrt_ctfn_typ_cd,hr_api.g_varchar2)

261: p_object_version_number => p_object_version_number);
262: --
263: if (l_api_updating
264: and p_enrt_ctfn_typ_cd
265: <> nvl(ben_ecc_shd.g_old_rec.enrt_ctfn_typ_cd,hr_api.g_varchar2)
266: or not l_api_updating) then
267: --
268: -- check if value of lookup falls within lookup type.
269: --

Line 301: l_api_updating := ben_ecc_shd.api_updating

297: Begin
298: --
299: hr_utility.set_location('Entering:'||l_proc, 5);
300: --
301: l_api_updating := ben_ecc_shd.api_updating
302: (p_elctbl_chc_ctfn_id => p_elctbl_chc_ctfn_id,
303: p_object_version_number => p_object_version_number);
304: --
305: if (l_api_updating

Line 307: <> nvl(ben_ecc_shd.g_old_rec.ctfn_determine_cd,hr_api.g_varchar2)

303: p_object_version_number => p_object_version_number);
304: --
305: if (l_api_updating
306: and p_ctfn_determine_cd
307: <> nvl(ben_ecc_shd.g_old_rec.ctfn_determine_cd,hr_api.g_varchar2)
308: or not l_api_updating) then
309: --
310: -- check if value of lookup falls within lookup type.
311: --

Line 344: l_api_updating := ben_ecc_shd.api_updating

340: Begin
341: --
342: hr_utility.set_location('Entering:'||l_proc, 5);
343: --
344: l_api_updating := ben_ecc_shd.api_updating
345: (p_elctbl_chc_ctfn_id => p_elctbl_chc_ctfn_id,
346: p_object_version_number => p_object_version_number);
347: --
348: if (l_api_updating

Line 350: <> nvl(ben_ecc_shd.g_old_rec.susp_if_ctfn_not_prvd_flag,hr_api.g_varchar2)

346: p_object_version_number => p_object_version_number);
347: --
348: if (l_api_updating
349: and p_susp_if_ctfn_not_prvd_flag
350: <> nvl(ben_ecc_shd.g_old_rec.susp_if_ctfn_not_prvd_flag,hr_api.g_varchar2)
351: or not l_api_updating) then
352: --
353: -- check if value of lookup falls within lookup type.
354: --

Line 377: Procedure insert_validate(p_rec in ben_ecc_shd.g_rec_type

373:
374: -- ----------------------------------------------------------------------------
375: -- |---------------------------< insert_validate >----------------------------|
376: -- ----------------------------------------------------------------------------
377: Procedure insert_validate(p_rec in ben_ecc_shd.g_rec_type
378: ,p_effective_date in date) is
379: --
380: l_proc varchar2(72) := g_package||'insert_validate';
381: --

Line 429: Procedure update_validate(p_rec in ben_ecc_shd.g_rec_type

425: --
426: -- ----------------------------------------------------------------------------
427: -- |---------------------------< update_validate >----------------------------|
428: -- ----------------------------------------------------------------------------
429: Procedure update_validate(p_rec in ben_ecc_shd.g_rec_type
430: ,p_effective_date in date) is
431: --
432: l_proc varchar2(72) := g_package||'update_validate';
433: --

Line 483: Procedure delete_validate(p_rec in ben_ecc_shd.g_rec_type

479: --
480: -- ----------------------------------------------------------------------------
481: -- |---------------------------< delete_validate >----------------------------|
482: -- ----------------------------------------------------------------------------
483: Procedure delete_validate(p_rec in ben_ecc_shd.g_rec_type
484: ,p_effective_date in date) is
485: --
486: l_proc varchar2(72) := g_package||'delete_validate';
487: --