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_XCT_BUS dependencies on HR_API

Line 39: hr_api.mandatory_arg_error

35: hr_utility.set_location('Entering:'|| l_proc, 10);
36: --
37: -- Ensure that all the mandatory parameter are not null
38: --
39: hr_api.mandatory_arg_error
40: (p_api_name => l_proc
41: ,p_argument => 'ext_crit_typ_id'
42: ,p_argument_value => p_ext_crit_typ_id
43: );

Line 62: hr_api.set_security_group_id

58: close csr_sec_grp;
59: --
60: -- Set the security_group_id in CLIENT_INFO
61: --
62: hr_api.set_security_group_id
63: (p_security_group_id => l_security_group_id
64: );
65: --
66: hr_utility.set_location(' Leaving:'|| l_proc, 20);

Line 160: and nvl(p_ext_crit_typ_id,hr_api.g_number)

156: (p_ext_crit_typ_id => p_ext_crit_typ_id,
157: p_object_version_number => p_object_version_number);
158: --
159: if (l_api_updating
160: and nvl(p_ext_crit_typ_id,hr_api.g_number)
161: <> ben_xct_shd.g_old_rec.ext_crit_typ_id) then
162: --
163: -- raise error as PK has changed
164: --

Line 232: and nvl(p_ext_crit_prfl_id,hr_api.g_number)

228: (p_ext_crit_typ_id => p_ext_crit_typ_id,
229: p_object_version_number => p_object_version_number);
230: --
231: if (l_api_updating
232: and nvl(p_ext_crit_prfl_id,hr_api.g_number)
233: <> nvl(ben_xct_shd.g_old_rec.ext_crit_prfl_id,hr_api.g_number)
234: or not l_api_updating) then
235: --
236: -- check if ext_crit_prfl_id value exists in ben_ext_crit_prfl table

Line 233: <> nvl(ben_xct_shd.g_old_rec.ext_crit_prfl_id,hr_api.g_number)

229: p_object_version_number => p_object_version_number);
230: --
231: if (l_api_updating
232: and nvl(p_ext_crit_prfl_id,hr_api.g_number)
233: <> nvl(ben_xct_shd.g_old_rec.ext_crit_prfl_id,hr_api.g_number)
234: or not l_api_updating) then
235: --
236: -- check if ext_crit_prfl_id value exists in ben_ext_crit_prfl table
237: --

Line 310: <> nvl(ben_xct_shd.g_old_rec.crit_typ_cd,hr_api.g_varchar2)

306: end if;
307: --
308: if (l_api_updating
309: and p_crit_typ_cd
310: <> nvl(ben_xct_shd.g_old_rec.crit_typ_cd,hr_api.g_varchar2)
311: or not l_api_updating)
312: and p_crit_typ_cd is not null then
313: --
314: -- check if value of lookup falls within lookup type.

Line 318: if hr_api.not_exists_in_hr_lookups

314: -- check if value of lookup falls within lookup type.
315: --
316: if p_business_group_id is not null then
317: /* BG is set, so use the existing call, with no modifications*/
318: if hr_api.not_exists_in_hr_lookups
319: (p_lookup_type => 'BEN_EXT_CRIT_TYP',
320: p_lookup_code => p_crit_typ_cd,
321: p_effective_date => p_effective_date) then
322: --

Line 333: if hr_api.not_exists_in_hrstanlookups

329: --
330: end if;
331: else
332: /* BG is null, so alternative call is required */
333: if hr_api.not_exists_in_hrstanlookups
334: (p_lookup_type => 'BEN_EXT_CRIT_TYP',
335: p_lookup_code => p_crit_typ_cd,
336: p_effective_date => p_effective_date) then
337: --

Line 410: <> nvl(ben_xct_shd.g_old_rec.crit_typ_cd,hr_api.g_varchar2)) then

406: --
407: -- on perform this edit if updating, and if value has changed.
408: --
409: if (l_api_updating and p_crit_typ_cd
410: <> nvl(ben_xct_shd.g_old_rec.crit_typ_cd,hr_api.g_varchar2)) then
411: --
412: -- error if child records exist
413: --
414: open c1;

Line 542: <> nvl(ben_xct_shd.g_old_rec.excld_flag, hr_api.g_varchar2)

538: -- ensure that the excld_flag has a valid value
539: --
540: if (l_api_updating
541: and p_excld_flag
542: <> nvl(ben_xct_shd.g_old_rec.excld_flag, hr_api.g_varchar2)
543: or not l_api_updating)
544: and p_excld_flag is not null then
545: --
546: -- check if the value is present for the lookup type

Line 550: if hr_api.not_exists_in_hr_lookups

546: -- check if the value is present for the lookup type
547: --
548: if p_business_group_id is not null then
549: /* BG is set, so use the existing call, with no modifications*/
550: if hr_api.not_exists_in_hr_lookups
551: (p_lookup_type => 'YES_NO',
552: p_lookup_code => p_excld_flag,
553: p_effective_date => p_effective_date) then
554: --

Line 565: if hr_api.not_exists_in_hrstanlookups

561: --
562: end if;
563: else
564: /* BG is null, so alternative call is required */
565: if hr_api.not_exists_in_hrstanlookups
566: (p_lookup_type => 'YES_NO',
567: p_lookup_code => p_excld_flag,
568: p_effective_date => p_effective_date) then
569: --

Line 603: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate bus_grp

599: chk_startup_action(True
600: ,p_rec.business_group_id
601: ,p_rec.legislation_code);
602: IF hr_startup_data_api_support.g_startup_mode NOT IN ('GENERIC','STARTUP') THEN
603: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate bus_grp
604: END IF;
605: --
606: chk_ext_crit_typ_id
607: (p_ext_crit_typ_id => p_rec.ext_crit_typ_id,

Line 657: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate bus_grp

653: chk_startup_action(False
654: ,p_rec.business_group_id
655: ,p_rec.legislation_code);
656: IF hr_startup_data_api_support.g_startup_mode NOT IN ('GENERIC','STARTUP') THEN
657: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate bus_grp
658: END IF;
659: --
660: chk_ext_crit_typ_id
661: (p_ext_crit_typ_id => p_rec.ext_crit_typ_id,

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

743: hr_utility.set_location('Entering:'|| l_proc, 10);
744: --
745: -- Ensure that all the mandatory parameter are not null
746: --
747: hr_api.mandatory_arg_error(p_api_name => l_proc,
748: p_argument => 'ext_crit_typ_id',
749: p_argument_value => p_ext_crit_typ_id);
750: --
751: open csr_leg_code;