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_XRF_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_rcd_in_file_id'
90: ,p_argument_value => p_ext_rcd_in_file_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_rcd_in_file_id,hr_api.g_number)

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

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

228: (p_ext_rcd_in_file_id => p_ext_rcd_in_file_id,
229: p_object_version_number => p_object_version_number);
230: --
231: if (l_api_updating
232: and nvl(p_ext_rcd_id,hr_api.g_number)
233: <> nvl(ben_xrf_shd.g_old_rec.ext_rcd_id,hr_api.g_number)
234: or not l_api_updating) then
235: --
236: -- check if ext_rcd_id value exists in ben_ext_rcd table

Line 233: <> nvl(ben_xrf_shd.g_old_rec.ext_rcd_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_rcd_id,hr_api.g_number)
233: <> nvl(ben_xrf_shd.g_old_rec.ext_rcd_id,hr_api.g_number)
234: or not l_api_updating) then
235: --
236: -- check if ext_rcd_id value exists in ben_ext_rcd table
237: --

Line 307: and nvl(p_ext_file_id,hr_api.g_number)

303: (p_ext_rcd_in_file_id => p_ext_rcd_in_file_id,
304: p_object_version_number => p_object_version_number);
305: --
306: if (l_api_updating
307: and nvl(p_ext_file_id,hr_api.g_number)
308: <> nvl(ben_xrf_shd.g_old_rec.ext_file_id,hr_api.g_number)
309: or not l_api_updating) then
310: --
311: -- check if ext_file_id value exists in ben_ext_file table

Line 308: <> nvl(ben_xrf_shd.g_old_rec.ext_file_id,hr_api.g_number)

304: p_object_version_number => p_object_version_number);
305: --
306: if (l_api_updating
307: and nvl(p_ext_file_id,hr_api.g_number)
308: <> nvl(ben_xrf_shd.g_old_rec.ext_file_id,hr_api.g_number)
309: or not l_api_updating) then
310: --
311: -- check if ext_file_id value exists in ben_ext_file table
312: --

Line 381: <> nvl(ben_xrf_shd.g_old_rec.sprs_cd,hr_api.g_varchar2)

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

Line 389: if hr_api.not_exists_in_hr_lookups

385: -- check if value of lookup falls within lookup type.
386: --
387: if p_business_group_id is not null then
388: /* BG is set, so use the existing call, with no modifications*/
389: if hr_api.not_exists_in_hr_lookups
390: (p_lookup_type => 'BEN_EXT_SPRS',
391: p_lookup_code => p_sprs_cd,
392: p_effective_date => p_effective_date) then
393: --

Line 404: if hr_api.not_exists_in_hrstanlookups

400: --
401: end if;
402: else
403: /* BG is null, so alternative call is required */
404: if hr_api.not_exists_in_hrstanlookups
405: (p_lookup_type => 'BEN_EXT_SPRS',
406: p_lookup_code => p_sprs_cd,
407: p_effective_date => p_effective_date) then
408: --

Line 473: <> nvl(ben_xrf_shd.g_old_rec.any_or_all_cd,hr_api.g_varchar2)

469: p_object_version_number => p_object_version_number);
470: --
471: if (l_api_updating
472: and p_any_or_all_cd
473: <> nvl(ben_xrf_shd.g_old_rec.any_or_all_cd,hr_api.g_varchar2)
474: or not l_api_updating)
475: and p_any_or_all_cd is not null then
476: --
477: -- check if value of lookup falls within lookup type.

Line 481: if hr_api.not_exists_in_hr_lookups

477: -- check if value of lookup falls within lookup type.
478: --
479: if p_business_group_id is not null then
480: /* BG is set, so use the existing call, with no modifications*/
481: if hr_api.not_exists_in_hr_lookups
482: (p_lookup_type => 'YES_NO',
483: p_lookup_code => p_any_or_all_cd,
484: p_effective_date => p_effective_date) then
485: --

Line 496: if hr_api.not_exists_in_hrstanlookups

492: --
493: end if;
494: else
495: /* BG is null, so alternative call is required */
496: if hr_api.not_exists_in_hrstanlookups
497: (p_lookup_type => 'YES_NO',
498: p_lookup_code => p_any_or_all_cd,
499: p_effective_date => p_effective_date) then
500: --

Line 562: <> nvl(ben_xrf_shd.g_old_rec.rqd_flag,hr_api.g_varchar2)

558: p_object_version_number => p_object_version_number);
559: --
560: if (l_api_updating
561: and p_rqd_flag
562: <> nvl(ben_xrf_shd.g_old_rec.rqd_flag,hr_api.g_varchar2)
563: or not l_api_updating) then
564: --
565: -- check if value of lookup falls within lookup type.
566: --

Line 569: if hr_api.not_exists_in_hr_lookups

565: -- check if value of lookup falls within lookup type.
566: --
567: if p_business_group_id is not null then
568: /* BG is set, so use the existing call, with no modifications*/
569: if hr_api.not_exists_in_hr_lookups
570: (p_lookup_type => 'YES_NO',
571: p_lookup_code => p_rqd_flag,
572: p_effective_date => p_effective_date) then
573: --

Line 585: if hr_api.not_exists_in_hrstanlookups

581: --
582: end if;
583: else
584: /* BG is null, so alternative call is required */
585: if hr_api.not_exists_in_hrstanlookups
586: (p_lookup_type => 'YES_NO',
587: p_lookup_code => p_rqd_flag,
588: p_effective_date => p_effective_date) then
589: --

Line 655: <> nvl(ben_xrf_shd.g_old_rec.chg_rcd_upd_flag,hr_api.g_varchar2)

651: p_object_version_number => p_object_version_number);
652: --
653: if (l_api_updating
654: and p_chg_rcd_upd_flag
655: <> nvl(ben_xrf_shd.g_old_rec.chg_rcd_upd_flag,hr_api.g_varchar2)
656: or not l_api_updating) then
657: --
658: -- check if value of lookup falls within lookup type.
659: --

Line 662: if hr_api.not_exists_in_hr_lookups

658: -- check if value of lookup falls within lookup type.
659: --
660: if p_business_group_id is not null then
661: /* BG is set, so use the existing call, with no modifications*/
662: if hr_api.not_exists_in_hr_lookups
663: (p_lookup_type => 'YES_NO',
664: p_lookup_code => p_chg_rcd_upd_flag,
665: p_effective_date => p_effective_date) then
666: --

Line 678: if hr_api.not_exists_in_hrstanlookups

674: --
675: end if;
676: else
677: /* BG is null, so alternative call is required */
678: if hr_api.not_exists_in_hrstanlookups
679: (p_lookup_type => 'YES_NO',
680: p_lookup_code => p_chg_rcd_upd_flag,
681: p_effective_date => p_effective_date) then
682: --

Line 751: <> nvl(ben_xrf_shd.g_old_rec.hide_flag,hr_api.g_varchar2)

747: p_object_version_number => p_object_version_number);
748: --
749: if (l_api_updating
750: and p_hide_flag
751: <> nvl(ben_xrf_shd.g_old_rec.hide_flag,hr_api.g_varchar2)
752: or not l_api_updating) then
753: --
754: -- check if value of lookup falls within lookup type.
755: --

Line 758: if hr_api.not_exists_in_hr_lookups

754: -- check if value of lookup falls within lookup type.
755: --
756: if p_business_group_id is not null then
757: /* BG is set, so use the existing call, with no modifications*/
758: if hr_api.not_exists_in_hr_lookups
759: (p_lookup_type => 'YES_NO',
760: p_lookup_code => p_hide_flag,
761: p_effective_date => p_effective_date) then
762: --

Line 773: if hr_api.not_exists_in_hrstanlookups

769: --
770: end if;
771: else
772: /* BG is null, so alternative call is required */
773: if hr_api.not_exists_in_hrstanlookups
774: (p_lookup_type => 'YES_NO',
775: p_lookup_code => p_hide_flag,
776: p_effective_date => p_effective_date) then
777: --

Line 936: nvl(p_sort1_data_elmt_in_rcd_id,hr_api.g_number)

932: p_object_version_number => p_object_version_number);
933: --
934: if (l_api_updating and
935: (
936: nvl(p_sort1_data_elmt_in_rcd_id,hr_api.g_number)
937: <> nvl(ben_xrf_shd.g_old_rec.sort1_data_elmt_in_rcd_id ,hr_api.g_number) or
938: nvl(p_sort2_data_elmt_in_rcd_id,hr_api.g_number)
939: <> nvl(ben_xrf_shd.g_old_rec.sort2_data_elmt_in_rcd_id ,hr_api.g_number) or
940: nvl(p_sort3_data_elmt_in_rcd_id,hr_api.g_number)

Line 937: <> nvl(ben_xrf_shd.g_old_rec.sort1_data_elmt_in_rcd_id ,hr_api.g_number) or

933: --
934: if (l_api_updating and
935: (
936: nvl(p_sort1_data_elmt_in_rcd_id,hr_api.g_number)
937: <> nvl(ben_xrf_shd.g_old_rec.sort1_data_elmt_in_rcd_id ,hr_api.g_number) or
938: nvl(p_sort2_data_elmt_in_rcd_id,hr_api.g_number)
939: <> nvl(ben_xrf_shd.g_old_rec.sort2_data_elmt_in_rcd_id ,hr_api.g_number) or
940: nvl(p_sort3_data_elmt_in_rcd_id,hr_api.g_number)
941: <> nvl(ben_xrf_shd.g_old_rec.sort3_data_elmt_in_rcd_id ,hr_api.g_number) or

Line 938: nvl(p_sort2_data_elmt_in_rcd_id,hr_api.g_number)

934: if (l_api_updating and
935: (
936: nvl(p_sort1_data_elmt_in_rcd_id,hr_api.g_number)
937: <> nvl(ben_xrf_shd.g_old_rec.sort1_data_elmt_in_rcd_id ,hr_api.g_number) or
938: nvl(p_sort2_data_elmt_in_rcd_id,hr_api.g_number)
939: <> nvl(ben_xrf_shd.g_old_rec.sort2_data_elmt_in_rcd_id ,hr_api.g_number) or
940: nvl(p_sort3_data_elmt_in_rcd_id,hr_api.g_number)
941: <> nvl(ben_xrf_shd.g_old_rec.sort3_data_elmt_in_rcd_id ,hr_api.g_number) or
942: nvl(p_sort4_data_elmt_in_rcd_id,hr_api.g_number)

Line 939: <> nvl(ben_xrf_shd.g_old_rec.sort2_data_elmt_in_rcd_id ,hr_api.g_number) or

935: (
936: nvl(p_sort1_data_elmt_in_rcd_id,hr_api.g_number)
937: <> nvl(ben_xrf_shd.g_old_rec.sort1_data_elmt_in_rcd_id ,hr_api.g_number) or
938: nvl(p_sort2_data_elmt_in_rcd_id,hr_api.g_number)
939: <> nvl(ben_xrf_shd.g_old_rec.sort2_data_elmt_in_rcd_id ,hr_api.g_number) or
940: nvl(p_sort3_data_elmt_in_rcd_id,hr_api.g_number)
941: <> nvl(ben_xrf_shd.g_old_rec.sort3_data_elmt_in_rcd_id ,hr_api.g_number) or
942: nvl(p_sort4_data_elmt_in_rcd_id,hr_api.g_number)
943: <> nvl(ben_xrf_shd.g_old_rec.sort4_data_elmt_in_rcd_id ,hr_api.g_number)

Line 940: nvl(p_sort3_data_elmt_in_rcd_id,hr_api.g_number)

936: nvl(p_sort1_data_elmt_in_rcd_id,hr_api.g_number)
937: <> nvl(ben_xrf_shd.g_old_rec.sort1_data_elmt_in_rcd_id ,hr_api.g_number) or
938: nvl(p_sort2_data_elmt_in_rcd_id,hr_api.g_number)
939: <> nvl(ben_xrf_shd.g_old_rec.sort2_data_elmt_in_rcd_id ,hr_api.g_number) or
940: nvl(p_sort3_data_elmt_in_rcd_id,hr_api.g_number)
941: <> nvl(ben_xrf_shd.g_old_rec.sort3_data_elmt_in_rcd_id ,hr_api.g_number) or
942: nvl(p_sort4_data_elmt_in_rcd_id,hr_api.g_number)
943: <> nvl(ben_xrf_shd.g_old_rec.sort4_data_elmt_in_rcd_id ,hr_api.g_number)
944: )

Line 941: <> nvl(ben_xrf_shd.g_old_rec.sort3_data_elmt_in_rcd_id ,hr_api.g_number) or

937: <> nvl(ben_xrf_shd.g_old_rec.sort1_data_elmt_in_rcd_id ,hr_api.g_number) or
938: nvl(p_sort2_data_elmt_in_rcd_id,hr_api.g_number)
939: <> nvl(ben_xrf_shd.g_old_rec.sort2_data_elmt_in_rcd_id ,hr_api.g_number) or
940: nvl(p_sort3_data_elmt_in_rcd_id,hr_api.g_number)
941: <> nvl(ben_xrf_shd.g_old_rec.sort3_data_elmt_in_rcd_id ,hr_api.g_number) or
942: nvl(p_sort4_data_elmt_in_rcd_id,hr_api.g_number)
943: <> nvl(ben_xrf_shd.g_old_rec.sort4_data_elmt_in_rcd_id ,hr_api.g_number)
944: )
945: )

Line 942: nvl(p_sort4_data_elmt_in_rcd_id,hr_api.g_number)

938: nvl(p_sort2_data_elmt_in_rcd_id,hr_api.g_number)
939: <> nvl(ben_xrf_shd.g_old_rec.sort2_data_elmt_in_rcd_id ,hr_api.g_number) or
940: nvl(p_sort3_data_elmt_in_rcd_id,hr_api.g_number)
941: <> nvl(ben_xrf_shd.g_old_rec.sort3_data_elmt_in_rcd_id ,hr_api.g_number) or
942: nvl(p_sort4_data_elmt_in_rcd_id,hr_api.g_number)
943: <> nvl(ben_xrf_shd.g_old_rec.sort4_data_elmt_in_rcd_id ,hr_api.g_number)
944: )
945: )
946: or not l_api_updating then

Line 943: <> nvl(ben_xrf_shd.g_old_rec.sort4_data_elmt_in_rcd_id ,hr_api.g_number)

939: <> nvl(ben_xrf_shd.g_old_rec.sort2_data_elmt_in_rcd_id ,hr_api.g_number) or
940: nvl(p_sort3_data_elmt_in_rcd_id,hr_api.g_number)
941: <> nvl(ben_xrf_shd.g_old_rec.sort3_data_elmt_in_rcd_id ,hr_api.g_number) or
942: nvl(p_sort4_data_elmt_in_rcd_id,hr_api.g_number)
943: <> nvl(ben_xrf_shd.g_old_rec.sort4_data_elmt_in_rcd_id ,hr_api.g_number)
944: )
945: )
946: or not l_api_updating then
947:

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

1085: chk_startup_action(True
1086: ,p_rec.business_group_id
1087: ,p_rec.legislation_code);
1088: IF hr_startup_data_api_support.g_startup_mode NOT IN ('GENERIC','STARTUP') THEN
1089: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate bus_grp
1090: END IF;
1091: --
1092: chk_ext_rcd_in_file_id
1093: (p_ext_rcd_in_file_id => p_rec.ext_rcd_in_file_id,

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

1182: chk_startup_action(False
1183: ,p_rec.business_group_id
1184: ,p_rec.legislation_code);
1185: IF hr_startup_data_api_support.g_startup_mode NOT IN ('GENERIC','STARTUP') THEN
1186: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate bus_grp
1187: END IF;
1188: --
1189: chk_ext_rcd_in_file_id
1190: (p_ext_rcd_in_file_id => p_rec.ext_rcd_in_file_id,

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

1311: hr_utility.set_location('Entering:'|| l_proc, 10);
1312: --
1313: -- Ensure that all the mandatory parameter are not null
1314: --
1315: hr_api.mandatory_arg_error(p_api_name => l_proc,
1316: p_argument => 'ext_rcd_in_file_id',
1317: p_argument_value => p_ext_rcd_in_file_id);
1318: --
1319: open csr_leg_code;