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

Line 87: hr_api.mandatory_arg_error

83: hr_utility.set_location('Entering:'|| l_proc, 10);
84: --
85: -- Ensure that all the mandatory parameter are not null
86: --
87: hr_api.mandatory_arg_error
88: (p_api_name => l_proc
89: ,p_argument => 'ext_crit_cmbn_id'
90: ,p_argument_value => p_ext_crit_cmbn_id
91: );

Line 110: hr_api.set_security_group_id

106: close csr_sec_grp;
107: --
108: -- Set the security_group_id in CLIENT_INFO
109: --
110: hr_api.set_security_group_id
111: (p_security_group_id => l_security_group_id
112: );
113: --
114: hr_utility.set_location(' Leaving:'|| l_proc, 20);

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

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

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

228: (p_ext_crit_cmbn_id => p_ext_crit_cmbn_id,
229: p_object_version_number => p_object_version_number);
230: --
231: if (l_api_updating
232: and nvl(p_ext_crit_val_id,hr_api.g_number)
233: <> nvl(ben_xcc_shd.g_old_rec.ext_crit_val_id,hr_api.g_number)
234: or not l_api_updating) then
235: --
236: -- check if ext_crit_val_id value exists in ben_ext_crit_val table

Line 233: <> nvl(ben_xcc_shd.g_old_rec.ext_crit_val_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_val_id,hr_api.g_number)
233: <> nvl(ben_xcc_shd.g_old_rec.ext_crit_val_id,hr_api.g_number)
234: or not l_api_updating) then
235: --
236: -- check if ext_crit_val_id value exists in ben_ext_crit_val table
237: --

Line 305: <> nvl(ben_xcc_shd.g_old_rec.oper_cd,hr_api.g_varchar2)

301: p_object_version_number => p_object_version_number);
302: --
303: if (l_api_updating
304: and p_oper_cd
305: <> nvl(ben_xcc_shd.g_old_rec.oper_cd,hr_api.g_varchar2)
306: or not l_api_updating) then
307: --
308: -- check if value of lookup falls within lookup type.
309: --

Line 312: if hr_api.not_exists_in_hr_lookups

308: -- check if value of lookup falls within lookup type.
309: --
310: if p_business_group_id is not null then
311: /* BG is set, so use the existing call, with no modifications*/
312: if hr_api.not_exists_in_hr_lookups
313: (p_lookup_type => 'BEN_EXT_TTL_COND_OPER',
314: p_lookup_code => p_oper_cd,
315: p_effective_date => p_effective_date) then
316: --

Line 327: if hr_api.not_exists_in_hrstanlookups

323: --
324: end if;
325: else
326: /* BG is null, so alternative call is required */
327: if hr_api.not_exists_in_hrstanlookups
328: (p_lookup_type => 'BEN_EXT_TTL_COND_OPER',
329: p_lookup_code => p_oper_cd,
330: p_effective_date => p_effective_date) then
331: --

Line 393: <> nvl(ben_xcc_shd.g_old_rec.crit_typ_cd,hr_api.g_varchar2)

389: p_object_version_number => p_object_version_number);
390: --
391: if (l_api_updating
392: and p_crit_typ_cd
393: <> nvl(ben_xcc_shd.g_old_rec.crit_typ_cd,hr_api.g_varchar2)
394: or not l_api_updating) then
395: --
396: -- check if value of lookup falls within lookup type.
397: --

Line 404: if hr_api.not_exists_in_hr_lookups

400: --
401: -- check if value of lookup falls within lookup type.
402: --
403: --
404: if hr_api.not_exists_in_hr_lookups
405: (p_lookup_type => 'BEN_EXT_CRIT_TYP',
406: p_lookup_code => p_crit_typ_cd,
407: p_effective_date => p_effective_date) then
408: --

Line 423: if hr_api.not_exists_in_hrstanlookups

419: --
420: -- check if value of lookup falls within lookup type.
421: --
422: --
423: if hr_api.not_exists_in_hrstanlookups
424: (p_lookup_type => 'BEN_EXT_CRIT_TYP',
425: p_lookup_code => p_crit_typ_cd,
426: p_effective_date => p_effective_date) then
427: --

Line 492: <> nvl(ben_xcc_shd.g_old_rec.oper_cd,hr_api.g_varchar2)

488: p_object_version_number => p_object_version_number);
489: --
490: if (l_api_updating
491: and (p_oper_cd
492: <> nvl(ben_xcc_shd.g_old_rec.oper_cd,hr_api.g_varchar2)
493: or p_crit_typ_cd
494: <> nvl(ben_xcc_shd.g_old_rec.crit_typ_cd, hr_api.g_varchar2)
495: )
496: or not l_api_updating) then

Line 494: <> nvl(ben_xcc_shd.g_old_rec.crit_typ_cd, hr_api.g_varchar2)

490: if (l_api_updating
491: and (p_oper_cd
492: <> nvl(ben_xcc_shd.g_old_rec.oper_cd,hr_api.g_varchar2)
493: or p_crit_typ_cd
494: <> nvl(ben_xcc_shd.g_old_rec.crit_typ_cd, hr_api.g_varchar2)
495: )
496: or not l_api_updating) then
497: --
498: -- check if criteria is date then operator is '=' or 'between'

Line 581: <> nvl(ben_xcc_shd.g_old_rec.oper_cd,hr_api.g_varchar2)

577: p_object_version_number => p_object_version_number);
578: --
579: if (l_api_updating
580: and (p_oper_cd
581: <> nvl(ben_xcc_shd.g_old_rec.oper_cd,hr_api.g_varchar2)
582: or
583: p_crit_typ_cd
584: <> nvl(ben_xcc_shd.g_old_rec.crit_typ_cd,hr_api.g_varchar2)
585: )

Line 584: <> nvl(ben_xcc_shd.g_old_rec.crit_typ_cd,hr_api.g_varchar2)

580: and (p_oper_cd
581: <> nvl(ben_xcc_shd.g_old_rec.oper_cd,hr_api.g_varchar2)
582: or
583: p_crit_typ_cd
584: <> nvl(ben_xcc_shd.g_old_rec.crit_typ_cd,hr_api.g_varchar2)
585: )
586: or not l_api_updating) then
587: --
588: -- check if criteria is change event then operator is '=' or '<>'

Line 684: <> nvl(ben_xcc_shd.g_old_rec.oper_cd,hr_api.g_varchar2))

680: p_object_version_number => p_object_version_number);
681: --
682: if (l_api_updating
683: and ((p_oper_cd
684: <> nvl(ben_xcc_shd.g_old_rec.oper_cd,hr_api.g_varchar2))
685: or (p_val_1 <> nvl(ben_xcc_shd.g_old_rec.val_1, hr_api.g_varchar2))
686: or (p_val_2 <> nvl(ben_xcc_shd.g_old_rec.val_2, hr_api.g_varchar2))
687: ))
688: or not l_api_updating then

Line 685: or (p_val_1 <> nvl(ben_xcc_shd.g_old_rec.val_1, hr_api.g_varchar2))

681: --
682: if (l_api_updating
683: and ((p_oper_cd
684: <> nvl(ben_xcc_shd.g_old_rec.oper_cd,hr_api.g_varchar2))
685: or (p_val_1 <> nvl(ben_xcc_shd.g_old_rec.val_1, hr_api.g_varchar2))
686: or (p_val_2 <> nvl(ben_xcc_shd.g_old_rec.val_2, hr_api.g_varchar2))
687: ))
688: or not l_api_updating then
689: --

Line 686: or (p_val_2 <> nvl(ben_xcc_shd.g_old_rec.val_2, hr_api.g_varchar2))

682: if (l_api_updating
683: and ((p_oper_cd
684: <> nvl(ben_xcc_shd.g_old_rec.oper_cd,hr_api.g_varchar2))
685: or (p_val_1 <> nvl(ben_xcc_shd.g_old_rec.val_1, hr_api.g_varchar2))
686: or (p_val_2 <> nvl(ben_xcc_shd.g_old_rec.val_2, hr_api.g_varchar2))
687: ))
688: or not l_api_updating then
689: --
690: -- check if operator is between then val_1 and val_2 are not null

Line 757: <> nvl(ben_xcc_shd.g_old_rec.oper_cd,hr_api.g_varchar2))

753: p_object_version_number => p_object_version_number);
754: --
755: if (l_api_updating
756: and ((p_oper_cd
757: <> nvl(ben_xcc_shd.g_old_rec.oper_cd,hr_api.g_varchar2))
758: or (p_val_1 <> nvl(ben_xcc_shd.g_old_rec.val_1, hr_api.g_varchar2))
759: or (p_val_2 <> nvl(ben_xcc_shd.g_old_rec.val_2, hr_api.g_varchar2))
760: ))
761: or not l_api_updating then

Line 758: or (p_val_1 <> nvl(ben_xcc_shd.g_old_rec.val_1, hr_api.g_varchar2))

754: --
755: if (l_api_updating
756: and ((p_oper_cd
757: <> nvl(ben_xcc_shd.g_old_rec.oper_cd,hr_api.g_varchar2))
758: or (p_val_1 <> nvl(ben_xcc_shd.g_old_rec.val_1, hr_api.g_varchar2))
759: or (p_val_2 <> nvl(ben_xcc_shd.g_old_rec.val_2, hr_api.g_varchar2))
760: ))
761: or not l_api_updating then
762: --

Line 759: or (p_val_2 <> nvl(ben_xcc_shd.g_old_rec.val_2, hr_api.g_varchar2))

755: if (l_api_updating
756: and ((p_oper_cd
757: <> nvl(ben_xcc_shd.g_old_rec.oper_cd,hr_api.g_varchar2))
758: or (p_val_1 <> nvl(ben_xcc_shd.g_old_rec.val_1, hr_api.g_varchar2))
759: or (p_val_2 <> nvl(ben_xcc_shd.g_old_rec.val_2, hr_api.g_varchar2))
760: ))
761: or not l_api_updating then
762: --
763: -- check if operator is between then val_1 and val_2 are not null

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

793: chk_startup_action(True
794: ,p_rec.business_group_id
795: ,p_rec.legislation_code);
796: IF hr_startup_data_api_support.g_startup_mode NOT IN ('GENERIC','STARTUP') THEN
797: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate bus_grp
798: END IF;
799: --
800: chk_ext_crit_cmbn_id
801: (p_ext_crit_cmbn_id => p_rec.ext_crit_cmbn_id,

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

871: chk_startup_action(False
872: ,p_rec.business_group_id
873: ,p_rec.legislation_code);
874: IF hr_startup_data_api_support.g_startup_mode NOT IN ('GENERIC','STARTUP') THEN
875: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate bus_grp
876: END IF;
877: --
878: chk_ext_crit_cmbn_id
879: (p_ext_crit_cmbn_id => p_rec.ext_crit_cmbn_id,

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

978: hr_utility.set_location('Entering:'|| l_proc, 10);
979: --
980: -- Ensure that all the mandatory parameter are not null
981: --
982: hr_api.mandatory_arg_error(p_api_name => l_proc,
983: p_argument => 'ext_crit_cmbn_id',
984: p_argument_value => p_ext_crit_cmbn_id);
985: --
986: open csr_leg_code;