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_ECQ_BUS dependencies on BEN_ECQ_SHD

Line 48: l_api_updating := ben_ecq_shd.api_updating

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

Line 55: <> ben_ecq_shd.g_old_rec.elig_cbr_quald_bnf_id) then

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

Line 59: ben_ecq_shd.constraint_error('BEN_ELIG_CBR_QUALD_BNF_F_PK');

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

Line 69: ben_ecq_shd.constraint_error('BEN_ELIG_CBR_QUALD_BNF_F_PK');

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

Line 122: l_api_updating := ben_ecq_shd.api_updating

118: Begin
119: --
120: hr_utility.set_location('Entering:'||l_proc,5);
121: --
122: l_api_updating := ben_ecq_shd.api_updating
123: (p_effective_date => p_effective_date,
124: p_elig_cbr_quald_bnf_id => p_elig_cbr_quald_bnf_id,
125: p_object_version_number => p_object_version_number);
126: --

Line 129: <> nvl(ben_ecq_shd.g_old_rec.pgm_id,hr_api.g_number)

125: p_object_version_number => p_object_version_number);
126: --
127: if (l_api_updating
128: and nvl(p_pgm_id,hr_api.g_number)
129: <> nvl(ben_ecq_shd.g_old_rec.pgm_id,hr_api.g_number)
130: or not l_api_updating) and p_pgm_id is not null then
131: --
132: -- check if pgm_id value exists in ben_pgm_f table
133: --

Line 144: ben_ecq_shd.constraint_error('BEN_ELIG_CBR_QUALD_BNF_F_DT3');

140: --
141: -- raise error as FK does not relate to PK in ben_pgm_f
142: -- table.
143: --
144: ben_ecq_shd.constraint_error('BEN_ELIG_CBR_QUALD_BNF_F_DT3');
145: --
146: end if;
147: --
148: close c1;

Line 199: l_api_updating := ben_ecq_shd.api_updating

195: Begin
196: --
197: hr_utility.set_location('Entering:'||l_proc,5);
198: --
199: l_api_updating := ben_ecq_shd.api_updating
200: (p_effective_date => p_effective_date,
201: p_elig_cbr_quald_bnf_id => p_elig_cbr_quald_bnf_id,
202: p_object_version_number => p_object_version_number);
203: --

Line 206: <> nvl(ben_ecq_shd.g_old_rec.ptip_id,hr_api.g_number)

202: p_object_version_number => p_object_version_number);
203: --
204: if (l_api_updating
205: and nvl(p_ptip_id,hr_api.g_number)
206: <> nvl(ben_ecq_shd.g_old_rec.ptip_id,hr_api.g_number)
207: or not l_api_updating) and p_ptip_id is not null then
208: --
209: -- check if ptip_id value exists in ben_ptip_f table
210: --

Line 221: ben_ecq_shd.constraint_error('BEN_ELIG_CBR_QUALD_BNF_F_DT2');

217: --
218: -- raise error as FK does not relate to PK in ben_ptip_f
219: -- table.
220: --
221: ben_ecq_shd.constraint_error('BEN_ELIG_CBR_QUALD_BNF_F_DT2');
222: --
223: end if;
224: --
225: close c1;

Line 271: l_api_updating := ben_ecq_shd.api_updating

267: Begin
268: --
269: hr_utility.set_location('Entering:'||l_proc, 5);
270: --
271: l_api_updating := ben_ecq_shd.api_updating
272: (p_elig_cbr_quald_bnf_id => p_elig_cbr_quald_bnf_id,
273: p_effective_date => p_effective_date,
274: p_object_version_number => p_object_version_number);
275: --

Line 278: <> nvl(ben_ecq_shd.g_old_rec.quald_bnf_flag,hr_api.g_varchar2)

274: p_object_version_number => p_object_version_number);
275: --
276: if (l_api_updating
277: and p_quald_bnf_flag
278: <> nvl(ben_ecq_shd.g_old_rec.quald_bnf_flag,hr_api.g_varchar2)
279: or not l_api_updating) then
280: --
281: -- check if value of lookup falls within lookup type.
282: --

Line 591: (p_rec in ben_ecq_shd.g_rec_type,

587: -- ----------------------------------------------------------------------------
588: -- |---------------------------< insert_validate >----------------------------|
589: -- ----------------------------------------------------------------------------
590: Procedure insert_validate
591: (p_rec in ben_ecq_shd.g_rec_type,
592: p_effective_date in date,
593: p_datetrack_mode in varchar2,
594: p_validation_start_date in date,
595: p_validation_end_date in date) is

Line 643: (p_rec in ben_ecq_shd.g_rec_type,

639: -- ----------------------------------------------------------------------------
640: -- |---------------------------< update_validate >----------------------------|
641: -- ----------------------------------------------------------------------------
642: Procedure update_validate
643: (p_rec in ben_ecq_shd.g_rec_type,
644: p_effective_date in date,
645: p_datetrack_mode in varchar2,
646: p_validation_start_date in date,
647: p_validation_end_date in date) is

Line 705: (p_rec in ben_ecq_shd.g_rec_type,

701: -- ----------------------------------------------------------------------------
702: -- |---------------------------< delete_validate >----------------------------|
703: -- ----------------------------------------------------------------------------
704: Procedure delete_validate
705: (p_rec in ben_ecq_shd.g_rec_type,
706: p_effective_date in date,
707: p_datetrack_mode in varchar2,
708: p_validation_start_date in date,
709: p_validation_end_date in date) is