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_CQR_BUS dependencies on BEN_CQR_SHD

Line 48: l_api_updating := ben_cqr_shd.api_updating

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

Line 55: <> ben_cqr_shd.g_old_rec.cbr_quald_bnf_rt_id) then

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

Line 59: ben_cqr_shd.constraint_error('BEN_CBR_QUALD_BNF_RT_F_PK');

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

Line 69: ben_cqr_shd.constraint_error('BEN_CBR_QUALD_BNF_RT_F_PK');

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

Line 145: l_api_updating := ben_cqr_shd.api_updating

141: BEGIN
142: --
143: hr_utility.set_location('Entering:'||l_proc, 5);
144: --
145: l_api_updating := ben_cqr_shd.api_updating
146: (p_cbr_quald_bnf_rt_id => p_cbr_quald_bnf_rt_id,
147: p_effective_date => p_effective_date,
148: p_object_version_number => p_object_version_number);
149: --

Line 152: (p_quald_bnf_flag <> nvl(ben_cqr_shd.g_old_rec.quald_bnf_flag,hr_api.g_varchar2) or

148: p_object_version_number => p_object_version_number);
149: --
150: if (l_api_updating
151: and
152: (p_quald_bnf_flag <> nvl(ben_cqr_shd.g_old_rec.quald_bnf_flag,hr_api.g_varchar2) or
153: (nvl(p_pgm_id,hr_api.g_number) <> nvl(ben_cqr_shd.g_old_rec.pgm_id,hr_api.g_number)
154: or
155: nvl(p_ptip_id,hr_api.g_number) <> nvl(ben_cqr_shd.g_old_rec.ptip_id,hr_api.g_number)
156: )

Line 153: (nvl(p_pgm_id,hr_api.g_number) <> nvl(ben_cqr_shd.g_old_rec.pgm_id,hr_api.g_number)

149: --
150: if (l_api_updating
151: and
152: (p_quald_bnf_flag <> nvl(ben_cqr_shd.g_old_rec.quald_bnf_flag,hr_api.g_varchar2) or
153: (nvl(p_pgm_id,hr_api.g_number) <> nvl(ben_cqr_shd.g_old_rec.pgm_id,hr_api.g_number)
154: or
155: nvl(p_ptip_id,hr_api.g_number) <> nvl(ben_cqr_shd.g_old_rec.ptip_id,hr_api.g_number)
156: )
157: )

Line 155: nvl(p_ptip_id,hr_api.g_number) <> nvl(ben_cqr_shd.g_old_rec.ptip_id,hr_api.g_number)

151: and
152: (p_quald_bnf_flag <> nvl(ben_cqr_shd.g_old_rec.quald_bnf_flag,hr_api.g_varchar2) or
153: (nvl(p_pgm_id,hr_api.g_number) <> nvl(ben_cqr_shd.g_old_rec.pgm_id,hr_api.g_number)
154: or
155: nvl(p_ptip_id,hr_api.g_number) <> nvl(ben_cqr_shd.g_old_rec.ptip_id,hr_api.g_number)
156: )
157: )
158: or not l_api_updating) then
159:

Line 225: l_api_updating := ben_cqr_shd.api_updating

221: Begin
222: --
223: hr_utility.set_location('Entering:'||l_proc,5);
224: --
225: l_api_updating := ben_cqr_shd.api_updating
226: (p_effective_date => p_effective_date,
227: p_cbr_quald_bnf_rt_id => p_cbr_quald_bnf_rt_id,
228: p_object_version_number => p_object_version_number);
229: --

Line 232: <> nvl(ben_cqr_shd.g_old_rec.pgm_id,hr_api.g_number)

228: p_object_version_number => p_object_version_number);
229: --
230: if (l_api_updating
231: and nvl(p_pgm_id,hr_api.g_number)
232: <> nvl(ben_cqr_shd.g_old_rec.pgm_id,hr_api.g_number)
233: or not l_api_updating) and p_pgm_id is not null then
234: --
235: -- check if pgm_id value exists in ben_pgm_f table
236: --

Line 247: ben_cqr_shd.constraint_error('BEN_CBR_QUALD_BNF_RT_F_DT3');

243: --
244: -- raise error as FK does not relate to PK in ben_pgm_f
245: -- table.
246: --
247: ben_cqr_shd.constraint_error('BEN_CBR_QUALD_BNF_RT_F_DT3');
248: --
249: end if;
250: --
251: close c1;

Line 302: l_api_updating := ben_cqr_shd.api_updating

298: Begin
299: --
300: hr_utility.set_location('Entering:'||l_proc,5);
301: --
302: l_api_updating := ben_cqr_shd.api_updating
303: (p_effective_date => p_effective_date,
304: p_cbr_quald_bnf_rt_id => p_cbr_quald_bnf_rt_id,
305: p_object_version_number => p_object_version_number);
306: --

Line 309: <> nvl(ben_cqr_shd.g_old_rec.ptip_id,hr_api.g_number)

305: p_object_version_number => p_object_version_number);
306: --
307: if (l_api_updating
308: and nvl(p_ptip_id,hr_api.g_number)
309: <> nvl(ben_cqr_shd.g_old_rec.ptip_id,hr_api.g_number)
310: or not l_api_updating) and p_ptip_id is not null then
311: --
312: -- check if ptip_id value exists in ben_ptip_f table
313: --

Line 324: ben_cqr_shd.constraint_error('BEN_CBR_QUALD_BNF_RT_F_DT2');

320: --
321: -- raise error as FK does not relate to PK in ben_ptip_f
322: -- table.
323: --
324: ben_cqr_shd.constraint_error('BEN_CBR_QUALD_BNF_RT_F_DT2');
325: --
326: end if;
327: --
328: close c1;

Line 374: l_api_updating := ben_cqr_shd.api_updating

370: Begin
371: --
372: hr_utility.set_location('Entering:'||l_proc, 5);
373: --
374: l_api_updating := ben_cqr_shd.api_updating
375: (p_cbr_quald_bnf_rt_id => p_cbr_quald_bnf_rt_id,
376: p_effective_date => p_effective_date,
377: p_object_version_number => p_object_version_number);
378: --

Line 381: <> nvl(ben_cqr_shd.g_old_rec.quald_bnf_flag,hr_api.g_varchar2)

377: p_object_version_number => p_object_version_number);
378: --
379: if (l_api_updating
380: and p_quald_bnf_flag
381: <> nvl(ben_cqr_shd.g_old_rec.quald_bnf_flag,hr_api.g_varchar2)
382: or not l_api_updating) then
383: --
384: -- check if value of lookup falls within lookup type.
385: --

Line 702: (p_rec in ben_cqr_shd.g_rec_type,

698: -- ----------------------------------------------------------------------------
699: -- |---------------------------< insert_validate >----------------------------|
700: -- ----------------------------------------------------------------------------
701: Procedure insert_validate
702: (p_rec in ben_cqr_shd.g_rec_type,
703: p_effective_date in date,
704: p_datetrack_mode in varchar2,
705: p_validation_start_date in date,
706: p_validation_end_date in date) is

Line 770: (p_rec in ben_cqr_shd.g_rec_type,

766: -- ----------------------------------------------------------------------------
767: -- |---------------------------< update_validate >----------------------------|
768: -- ----------------------------------------------------------------------------
769: Procedure update_validate
770: (p_rec in ben_cqr_shd.g_rec_type,
771: p_effective_date in date,
772: p_datetrack_mode in varchar2,
773: p_validation_start_date in date,
774: p_validation_end_date in date) is

Line 847: (p_rec in ben_cqr_shd.g_rec_type,

843: -- ----------------------------------------------------------------------------
844: -- |---------------------------< delete_validate >----------------------------|
845: -- ----------------------------------------------------------------------------
846: Procedure delete_validate
847: (p_rec in ben_cqr_shd.g_rec_type,
848: p_effective_date in date,
849: p_datetrack_mode in varchar2,
850: p_validation_start_date in date,
851: p_validation_end_date in date) is