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_CQB_BUS dependencies on BEN_CQB_SHD

Line 46: l_api_updating := ben_cqb_shd.api_updating

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

Line 52: <> ben_cqb_shd.g_old_rec.cbr_quald_bnf_id) then

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

Line 56: ben_cqb_shd.constraint_error('BEN_CBR_QUALD_BNF_PK');

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

Line 66: ben_cqb_shd.constraint_error('BEN_CBR_QUALD_BNF_PK');

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

Line 118: l_api_updating := ben_cqb_shd.api_updating

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

Line 124: <> nvl(ben_cqb_shd.g_old_rec.pgm_id,hr_api.g_number)

120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and nvl(p_pgm_id,hr_api.g_number)
124: <> nvl(ben_cqb_shd.g_old_rec.pgm_id,hr_api.g_number)
125: or not l_api_updating) then
126: --
127: -- check if pgm_id value exists in ben_pgm_f table
128: --

Line 139: ben_cqb_shd.constraint_error('BEN_CBR_QUALD_BNF_DT3');

135: --
136: -- raise error as FK does not relate to PK in ben_pgm_f
137: -- table.
138: --
139: ben_cqb_shd.constraint_error('BEN_CBR_QUALD_BNF_DT3');
140: --
141: end if;
142: --
143: close c1;

Line 193: l_api_updating := ben_cqb_shd.api_updating

189: Begin
190: --
191: hr_utility.set_location('Entering:'||l_proc,5);
192: --
193: l_api_updating := ben_cqb_shd.api_updating
194: (p_cbr_quald_bnf_id => p_cbr_quald_bnf_id,
195: p_object_version_number => p_object_version_number);
196: --
197: if (l_api_updating

Line 199: <> nvl(ben_cqb_shd.g_old_rec.ptip_id,hr_api.g_number)

195: p_object_version_number => p_object_version_number);
196: --
197: if (l_api_updating
198: and nvl(p_ptip_id,hr_api.g_number)
199: <> nvl(ben_cqb_shd.g_old_rec.ptip_id,hr_api.g_number)
200: or not l_api_updating)and
201: p_ptip_id is not null then
202: --
203: -- check if ptip_id value exists in ben_ptip_f table

Line 215: ben_cqb_shd.constraint_error('BEN_CBR_QUALD_BNF_DT5');

211: --
212: -- raise error as FK does not relate to PK in ben_ptip_f
213: -- table.
214: --
215: ben_cqb_shd.constraint_error('BEN_CBR_QUALD_BNF_DT5');
216: --
217: end if;
218: --
219: close c1;

Line 269: l_api_updating := ben_cqb_shd.api_updating

265: Begin
266: --
267: hr_utility.set_location('Entering:'||l_proc,5);
268: --
269: l_api_updating := ben_cqb_shd.api_updating
270: (p_cbr_quald_bnf_id => p_cbr_quald_bnf_id,
271: p_object_version_number => p_object_version_number);
272: --
273: if (l_api_updating

Line 275: <> nvl(ben_cqb_shd.g_old_rec.pl_typ_id,hr_api.g_number)

271: p_object_version_number => p_object_version_number);
272: --
273: if (l_api_updating
274: and nvl(p_pl_typ_id,hr_api.g_number)
275: <> nvl(ben_cqb_shd.g_old_rec.pl_typ_id,hr_api.g_number)
276: or not l_api_updating) and
277: p_pl_typ_id is not null then
278: --
279: -- check if pl_typ_id value exists in ben_pl_typ_f table

Line 291: ben_cqb_shd.constraint_error('BEN_CBR_QUALD_BNF_DT4');

287: --
288: -- raise error as FK does not relate to PK in ben_pl_typ_f
289: -- table.
290: --
291: ben_cqb_shd.constraint_error('BEN_CBR_QUALD_BNF_DT4');
292: --
293: end if;
294: --
295: close c1;

Line 343: l_api_updating := ben_cqb_shd.api_updating

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

Line 349: <> nvl(ben_cqb_shd.g_old_rec.quald_bnf_flag,hr_api.g_varchar2)

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

Line 426: l_api_updating := ben_cqb_shd.api_updating

422: Begin
423: --
424: hr_utility.set_location('Entering:'||l_proc, 5);
425: --
426: l_api_updating := ben_cqb_shd.api_updating
427: (p_cbr_quald_bnf_id => p_cbr_quald_bnf_id,
428: p_object_version_number => p_object_version_number);
429: --
430: if (l_api_updating

Line 432: <> nvl(ben_cqb_shd.g_old_rec.cbr_inelg_rsn_cd,hr_api.g_varchar2)

428: p_object_version_number => p_object_version_number);
429: --
430: if (l_api_updating
431: and p_cbr_inelg_rsn_cd
432: <> nvl(ben_cqb_shd.g_old_rec.cbr_inelg_rsn_cd,hr_api.g_varchar2)
433: or not l_api_updating)
434: and p_cbr_inelg_rsn_cd is not null then
435: --
436: -- check if value of lookup falls within lookup type.

Line 462: Procedure insert_validate(p_rec in ben_cqb_shd.g_rec_type

458: --
459: -- ----------------------------------------------------------------------------
460: -- |---------------------------< insert_validate >----------------------------|
461: -- ----------------------------------------------------------------------------
462: Procedure insert_validate(p_rec in ben_cqb_shd.g_rec_type
463: ,p_effective_date in date) is
464: --
465: l_proc varchar2(72) := g_package||'insert_validate';
466: --

Line 513: Procedure update_validate(p_rec in ben_cqb_shd.g_rec_type

509: --
510: -- ----------------------------------------------------------------------------
511: -- |---------------------------< update_validate >----------------------------|
512: -- ----------------------------------------------------------------------------
513: Procedure update_validate(p_rec in ben_cqb_shd.g_rec_type
514: ,p_effective_date in date) is
515: --
516: l_proc varchar2(72) := g_package||'update_validate';
517: --

Line 564: Procedure delete_validate(p_rec in ben_cqb_shd.g_rec_type

560: --
561: -- ----------------------------------------------------------------------------
562: -- |---------------------------< delete_validate >----------------------------|
563: -- ----------------------------------------------------------------------------
564: Procedure delete_validate(p_rec in ben_cqb_shd.g_rec_type
565: ,p_effective_date in date) is
566: --
567: l_proc varchar2(72) := g_package||'delete_validate';
568: --