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_XDF_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_dfn_id'
42: ,p_argument_value => p_ext_dfn_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 111: and nvl(p_ext_dfn_id,hr_api.g_number)

107: (p_ext_dfn_id => p_ext_dfn_id,
108: p_object_version_number => p_object_version_number);
109: --
110: if (l_api_updating
111: and nvl(p_ext_dfn_id,hr_api.g_number)
112: <> ben_xdf_shd.g_old_rec.ext_dfn_id) then
113: --
114: -- raise error as PK has changed
115: --

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

179: (p_ext_dfn_id => p_ext_dfn_id,
180: p_object_version_number => p_object_version_number);
181: --
182: if (l_api_updating
183: and nvl(p_ext_file_id,hr_api.g_number)
184: <> nvl(ben_xdf_shd.g_old_rec.ext_file_id,hr_api.g_number)
185: or not l_api_updating) and
186: p_ext_file_id is not null then
187: --

Line 184: <> nvl(ben_xdf_shd.g_old_rec.ext_file_id,hr_api.g_number)

180: p_object_version_number => p_object_version_number);
181: --
182: if (l_api_updating
183: and nvl(p_ext_file_id,hr_api.g_number)
184: <> nvl(ben_xdf_shd.g_old_rec.ext_file_id,hr_api.g_number)
185: or not l_api_updating) and
186: p_ext_file_id is not null then
187: --
188: -- check if ext_file_id value exists in ben_ext_file table

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

255: (p_ext_dfn_id => p_ext_dfn_id,
256: p_object_version_number => p_object_version_number);
257: --
258: if (l_api_updating
259: and nvl(p_ext_crit_prfl_id,hr_api.g_number)
260: <> nvl(ben_xdf_shd.g_old_rec.ext_crit_prfl_id,hr_api.g_number)
261: or not l_api_updating) and
262: p_ext_crit_prfl_id is not null then
263: --

Line 260: <> nvl(ben_xdf_shd.g_old_rec.ext_crit_prfl_id,hr_api.g_number)

256: p_object_version_number => p_object_version_number);
257: --
258: if (l_api_updating
259: and nvl(p_ext_crit_prfl_id,hr_api.g_number)
260: <> nvl(ben_xdf_shd.g_old_rec.ext_crit_prfl_id,hr_api.g_number)
261: or not l_api_updating) and
262: p_ext_crit_prfl_id is not null then
263: --
264: -- check if ext_crit_prfl_id value exists in ben_ext_crit_prfl table

Line 338: <> nvl(ben_xdf_shd.g_old_rec.data_typ_cd,hr_api.g_varchar2)

334: fnd_message.raise_error;
335: end if;
336: if (l_api_updating
337: and p_data_typ_cd
338: <> nvl(ben_xdf_shd.g_old_rec.data_typ_cd,hr_api.g_varchar2)
339: or not l_api_updating)
340: and p_data_typ_cd is not null then
341: --
342: -- check if value of lookup falls within lookup type.

Line 347: if hr_api.not_exists_in_hr_lookups

343: --
344:
345: if p_business_group_id is not null then
346: --
347: if hr_api.not_exists_in_hr_lookups
348: (p_lookup_type => 'BEN_EXT_DATA_TYP',
349: p_lookup_code => p_data_typ_cd,
350: p_effective_date => p_effective_date) then
351: --

Line 363: if hr_api.not_exists_in_hrstanlookups

359: end if;
360: --
361: else
362: --
363: if hr_api.not_exists_in_hrstanlookups
364: (p_lookup_type => 'BEN_EXT_DATA_TYP',
365: p_lookup_code => p_data_typ_cd,
366: p_effective_date => p_effective_date) then
367: --

Line 437: <> nvl(ben_xdf_shd.g_old_rec.apnd_rqst_id_flag,hr_api.g_varchar2)

433: p_object_version_number => p_object_version_number);
434: --
435: if (l_api_updating
436: and p_apnd_rqst_id_flag
437: <> nvl(ben_xdf_shd.g_old_rec.apnd_rqst_id_flag,hr_api.g_varchar2)
438: or not l_api_updating)
439: and p_apnd_rqst_id_flag is not null then
440: --
441: -- check if value of lookup falls within lookup type.

Line 446: if hr_api.not_exists_in_hr_lookups

442: --
443:
444: if p_business_group_id is not null then
445: --
446: if hr_api.not_exists_in_hr_lookups
447: (p_lookup_type => 'YES_NO',
448: p_lookup_code => p_apnd_rqst_id_flag,
449: p_effective_date => p_effective_date) then
450: --

Line 462: if hr_api.not_exists_in_hrstanlookups

458: end if;
459: --
460: else
461: --
462: if hr_api.not_exists_in_hrstanlookups
463: (p_lookup_type => 'YES_NO',
464: p_lookup_code => p_apnd_rqst_id_flag,
465: p_effective_date => p_effective_date) then
466: --

Line 537: <> nvl(ben_xdf_shd.g_old_rec.kickoff_wrt_prc_flag,hr_api.g_varchar2)

533: p_object_version_number => p_object_version_number);
534: --
535: if (l_api_updating
536: and p_kickoff_wrt_prc_flag
537: <> nvl(ben_xdf_shd.g_old_rec.kickoff_wrt_prc_flag,hr_api.g_varchar2)
538: or not l_api_updating)
539: and p_kickoff_wrt_prc_flag is not null then
540: --
541: -- check if value of lookup falls within lookup type.

Line 545: if hr_api.not_exists_in_hr_lookups

541: -- check if value of lookup falls within lookup type.
542: --
543: if p_business_group_id is not null then
544: --
545: if hr_api.not_exists_in_hr_lookups
546: (p_lookup_type => 'YES_NO',
547: p_lookup_code => p_kickoff_wrt_prc_flag,
548: p_effective_date => p_effective_date) then
549: --

Line 561: if hr_api.not_exists_in_hrstanlookups

557: end if;
558: --
559: else
560: --
561: if hr_api.not_exists_in_hrstanlookups
562: (p_lookup_type => 'YES_NO',
563: p_lookup_code => p_kickoff_wrt_prc_flag,
564: p_effective_date => p_effective_date) then
565: --

Line 626: <> nvl(ben_xdf_shd.g_old_rec.spcl_hndl_flag,hr_api.g_varchar2)

622: p_object_version_number => p_object_version_number);
623: --
624: if (l_api_updating
625: and p_spcl_hndl_flag
626: <> nvl(ben_xdf_shd.g_old_rec.spcl_hndl_flag,hr_api.g_varchar2)
627: or not l_api_updating)
628: and p_spcl_hndl_flag is not null then
629: --
630: -- check if value of lookup falls within lookup type.

Line 634: if hr_api.not_exists_in_hr_lookups

630: -- check if value of lookup falls within lookup type.
631: --
632: if p_business_group_id is not null then
633: --
634: if hr_api.not_exists_in_hr_lookups
635: (p_lookup_type => 'YES_NO',
636: p_lookup_code => p_spcl_hndl_flag,
637: p_effective_date => p_effective_date) then
638: --

Line 650: if hr_api.not_exists_in_hrstanlookups

646: end if;
647: --
648: else
649: --
650: if hr_api.not_exists_in_hrstanlookups
651: (p_lookup_type => 'YES_NO',
652: p_lookup_code => p_spcl_hndl_flag,
653: p_effective_date => p_effective_date) then
654: --

Line 693: <> nvl(ben_xdf_shd.g_old_rec.ext_global_flag,hr_api.g_varchar2)

689: p_object_version_number => p_object_version_number);
690: --
691: if (l_api_updating
692: and p_ext_global_flag
693: <> nvl(ben_xdf_shd.g_old_rec.ext_global_flag,hr_api.g_varchar2)
694: or not l_api_updating)
695: and p_ext_global_flag is not null then
696: --
697: -- check if value of lookup falls within lookup type.

Line 701: if hr_api.not_exists_in_hr_lookups

697: -- check if value of lookup falls within lookup type.
698: --
699: if p_business_group_id is not null then
700: --
701: if hr_api.not_exists_in_hr_lookups
702: (p_lookup_type => 'YES_NO',
703: p_lookup_code => p_ext_global_flag,
704: p_effective_date => p_effective_date) then
705: --

Line 717: if hr_api.not_exists_in_hrstanlookups

713: end if;
714: --
715: else
716: --
717: if hr_api.not_exists_in_hrstanlookups
718: (p_lookup_type => 'YES_NO',
719: p_lookup_code => p_ext_global_flag,
720: p_effective_date => p_effective_date) then
721: --

Line 760: <> nvl(ben_xdf_shd.g_old_rec.cm_display_flag,hr_api.g_varchar2)

756: p_object_version_number => p_object_version_number);
757: --
758: if (l_api_updating
759: and p_cm_display_flag
760: <> nvl(ben_xdf_shd.g_old_rec.cm_display_flag,hr_api.g_varchar2)
761: or not l_api_updating)
762: and p_cm_display_flag is not null then
763: --
764: -- check if value of lookup falls within lookup type.

Line 768: if hr_api.not_exists_in_hr_lookups

764: -- check if value of lookup falls within lookup type.
765: --
766: if p_business_group_id is not null then
767: --
768: if hr_api.not_exists_in_hr_lookups
769: (p_lookup_type => 'YES_NO',
770: p_lookup_code => p_cm_display_flag,
771: p_effective_date => p_effective_date) then
772: --

Line 784: if hr_api.not_exists_in_hrstanlookups

780: end if;
781: --
782: else
783: --
784: if hr_api.not_exists_in_hrstanlookups
785: (p_lookup_type => 'YES_NO',
786: p_lookup_code => p_cm_display_flag,
787: p_effective_date => p_effective_date) then
788: --

Line 850: <> nvl(ben_xdf_shd.g_old_rec.upd_cm_sent_dt_flag,hr_api.g_varchar2)

846: p_object_version_number => p_object_version_number);
847: --
848: if (l_api_updating
849: and p_upd_cm_sent_dt_flag
850: <> nvl(ben_xdf_shd.g_old_rec.upd_cm_sent_dt_flag,hr_api.g_varchar2)
851: or not l_api_updating)
852: and p_upd_cm_sent_dt_flag is not null then
853: --
854: -- check if value of lookup falls within lookup type.

Line 858: if hr_api.not_exists_in_hr_lookups

854: -- check if value of lookup falls within lookup type.
855: --
856: if p_business_group_id is not null then
857: --
858: if hr_api.not_exists_in_hr_lookups
859: (p_lookup_type => 'YES_NO',
860: p_lookup_code => p_upd_cm_sent_dt_flag,
861: p_effective_date => p_effective_date) then
862: --

Line 874: if hr_api.not_exists_in_hrstanlookups

870: end if;
871: --
872: else
873: --
874: if hr_api.not_exists_in_hrstanlookups
875: (p_lookup_type => 'YES_NO',
876: p_lookup_code => p_upd_cm_sent_dt_flag,
877: p_effective_date => p_effective_date) then
878: --

Line 940: <> nvl(ben_xdf_shd.g_old_rec.use_eff_dt_for_chgs_flag,hr_api.g_varchar2)

936: p_object_version_number => p_object_version_number);
937: --
938: if (l_api_updating
939: and p_use_eff_dt_for_chgs_flag
940: <> nvl(ben_xdf_shd.g_old_rec.use_eff_dt_for_chgs_flag,hr_api.g_varchar2)
941: or not l_api_updating)
942: and p_use_eff_dt_for_chgs_flag is not null then
943: --
944: -- check if value of lookup falls within lookup type.

Line 948: if hr_api.not_exists_in_hr_lookups

944: -- check if value of lookup falls within lookup type.
945: --
946: if p_business_group_id is not null then
947: --
948: if hr_api.not_exists_in_hr_lookups
949: (p_lookup_type => 'YES_NO',
950: p_lookup_code => p_use_eff_dt_for_chgs_flag,
951: p_effective_date => p_effective_date) then
952: --

Line 964: if hr_api.not_exists_in_hrstanlookups

960: end if;
961: --
962: else
963: --
964: if hr_api.not_exists_in_hrstanlookups
965: (p_lookup_type => 'YES_NO',
966: p_lookup_code => p_use_eff_dt_for_chgs_flag,
967: p_effective_date => p_effective_date) then
968: --

Line 1057: <> nvl(ben_xdf_shd.g_old_rec.strt_dt,hr_api.g_varchar2)

1053: end if;
1054: --
1055: if (l_api_updating
1056: and p_strt_dt
1057: <> nvl(ben_xdf_shd.g_old_rec.strt_dt,hr_api.g_varchar2)
1058: or not l_api_updating)
1059: and p_strt_dt is not null then
1060:
1061: if substr(p_strt_dt,1,1) in ('0','1','2','3','4','5','6','7','8','9') then

Line 1077: if hr_api.not_exists_in_hr_lookups

1073: --
1074:
1075: if p_business_group_id is not null then
1076: --
1077: if hr_api.not_exists_in_hr_lookups
1078: (p_lookup_type => 'BEN_EXT_DT',
1079: p_lookup_code => p_strt_dt,
1080: p_effective_date => p_effective_date) then
1081: --

Line 1093: if hr_api.not_exists_in_hrstanlookups

1089: end if;
1090: --
1091: else
1092: --
1093: if hr_api.not_exists_in_hrstanlookups
1094: (p_lookup_type => 'BEN_EXT_DT',
1095: p_lookup_code => p_strt_dt,
1096: p_effective_date => p_effective_date) then
1097: --

Line 1114: <> nvl(ben_xdf_shd.g_old_rec.end_dt,hr_api.g_varchar2)

1110: end if;
1111: --
1112: if (l_api_updating
1113: and p_end_dt
1114: <> nvl(ben_xdf_shd.g_old_rec.end_dt,hr_api.g_varchar2)
1115: or not l_api_updating)
1116: and p_end_dt is not null then
1117: if substr(p_end_dt,1,1) in ('0','1','2','3','4','5','6','7','8','9') then
1118: begin

Line 1132: if hr_api.not_exists_in_hr_lookups

1128: -- check if value of lookup falls within lookup type.
1129: --
1130: if p_business_group_id is not null then
1131: --
1132: if hr_api.not_exists_in_hr_lookups
1133: (p_lookup_type => 'BEN_EXT_DT',
1134: p_lookup_code => p_end_dt,
1135: p_effective_date => p_effective_date) then
1136: --

Line 1148: if hr_api.not_exists_in_hrstanlookups

1144: end if;
1145: --
1146: else
1147: --
1148: if hr_api.not_exists_in_hrstanlookups
1149: (p_lookup_type => 'BEN_EXT_DT',
1150: p_lookup_code => p_end_dt,
1151: p_effective_date => p_effective_date) then
1152: --

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

1437: ,p_rec.business_group_id
1438: ,p_rec.legislation_code);
1439: IF hr_startup_data_api_support.g_startup_mode NOT IN ('GENERIC','STARTUP') THEN
1440: --
1441: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate bus_grp
1442: --
1443: END IF;
1444:
1445: --

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

1566: ,p_rec.business_group_id
1567: ,p_rec.legislation_code);
1568: IF hr_startup_data_api_support.g_startup_mode NOT IN ('GENERIC','STARTUP') THEN
1569: --
1570: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate bus_grp
1571: --
1572: END IF;
1573:
1574: --

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

1726: hr_utility.set_location('Entering:'|| l_proc, 10);
1727: --
1728: -- Ensure that all the mandatory parameter are not null
1729: --
1730: hr_api.mandatory_arg_error(p_api_name => l_proc,
1731: p_argument => 'ext_dfn_id',
1732: p_argument_value => p_ext_dfn_id);
1733: --
1734: open csr_leg_code;

Line 1748: l_legislation_code := hr_api.return_legislation_code(l_business_group_id) ;

1744: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
1745: hr_utility.raise_error;
1746: --
1747: end if;
1748: l_legislation_code := hr_api.return_legislation_code(l_business_group_id) ;
1749:
1750: --
1751: close csr_leg_code;
1752: --