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 HR_API

Line 51: and nvl(p_cbr_quald_bnf_id,hr_api.g_number)

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
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: --

Line 123: and nvl(p_pgm_id,hr_api.g_number)

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
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

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 198: and nvl(p_ptip_id,hr_api.g_number)

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
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: --

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 274: and nvl(p_pl_typ_id,hr_api.g_number)

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
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: --

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 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 355: if hr_api.not_exists_in_hr_lookups

351: --
352: -- check if value of lookup falls within lookup type.
353: --
354: --
355: if hr_api.not_exists_in_hr_lookups
356: (p_lookup_type => 'YES_NO',
357: p_lookup_code => p_quald_bnf_flag,
358: p_effective_date => p_effective_date) then
359: --

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 439: if hr_api.not_exists_in_hr_lookups

435: --
436: -- check if value of lookup falls within lookup type.
437: --
438: --
439: if hr_api.not_exists_in_hr_lookups
440: (p_lookup_type => 'BEN_CBR_INELG_RSN',
441: p_lookup_code => p_cbr_inelg_rsn_cd,
442: p_effective_date => p_effective_date) then
443: --

Line 472: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

468: hr_utility.set_location('Entering:'||l_proc, 5);
469: --
470: -- Call all supporting business operations
471: --
472: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
473: --
474: chk_cbr_quald_bnf_id
475: (p_cbr_quald_bnf_id => p_rec.cbr_quald_bnf_id,
476: p_object_version_number => p_rec.object_version_number);

Line 523: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

519: hr_utility.set_location('Entering:'||l_proc, 5);
520: --
521: -- Call all supporting business operations
522: --
523: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
524: --
525: chk_cbr_quald_bnf_id
526: (p_cbr_quald_bnf_id => p_rec.cbr_quald_bnf_id,
527: p_object_version_number => p_rec.object_version_number);

Line 605: hr_api.mandatory_arg_error(p_api_name => l_proc,

601: hr_utility.set_location('Entering:'|| l_proc, 10);
602: --
603: -- Ensure that all the mandatory parameter are not null
604: --
605: hr_api.mandatory_arg_error(p_api_name => l_proc,
606: p_argument => 'cbr_quald_bnf_id',
607: p_argument_value => p_cbr_quald_bnf_id);
608: --
609: open csr_leg_code;