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

Line 54: and nvl(p_dsgn_rqmt_id,hr_api.g_number)

50: p_dsgn_rqmt_id => p_dsgn_rqmt_id,
51: p_object_version_number => p_object_version_number);
52: --
53: if (l_api_updating
54: and nvl(p_dsgn_rqmt_id,hr_api.g_number)
55: <> ben_ddr_shd.g_old_rec.dsgn_rqmt_id) then
56: --
57: -- raise error as PK has changed
58: --

Line 124: <> nvl(ben_ddr_shd.g_old_rec.dsgn_typ_cd,hr_api.g_varchar2)

120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and p_dsgn_typ_cd
124: <> nvl(ben_ddr_shd.g_old_rec.dsgn_typ_cd,hr_api.g_varchar2)
125: or not l_api_updating)
126: and p_dsgn_typ_cd is not null then
127: --
128: -- check if value of lookup falls within lookup type.

Line 130: if hr_api.not_exists_in_hr_lookups

126: and p_dsgn_typ_cd is not null then
127: --
128: -- check if value of lookup falls within lookup type.
129: --
130: if hr_api.not_exists_in_hr_lookups
131: (p_lookup_type => 'BEN_DSGN_TYP',
132: p_lookup_code => p_dsgn_typ_cd,
133: p_effective_date => p_effective_date) then
134: --

Line 330: <> nvl(ben_ddr_shd.g_old_rec.cvr_all_elig_flag,hr_api.g_varchar2)

326: p_object_version_number => p_object_version_number);
327: --
328: if (l_api_updating
329: and p_cvr_all_elig_flag
330: <> nvl(ben_ddr_shd.g_old_rec.cvr_all_elig_flag,hr_api.g_varchar2)
331: or not l_api_updating) then
332: --
333: -- check if value of lookup falls within lookup type.
334: --

Line 336: if hr_api.not_exists_in_hr_lookups

332: --
333: -- check if value of lookup falls within lookup type.
334: --
335: --
336: if hr_api.not_exists_in_hr_lookups
337: (p_lookup_type => 'YES_NO',
338: p_lookup_code => p_cvr_all_elig_flag,
339: p_effective_date => p_effective_date) then
340: --

Line 399: <> nvl(ben_ddr_shd.g_old_rec.no_mx_num_dfnd_flag,hr_api.g_varchar2)

395: p_object_version_number => p_object_version_number);
396: --
397: if (l_api_updating
398: and p_no_mx_num_dfnd_flag
399: <> nvl(ben_ddr_shd.g_old_rec.no_mx_num_dfnd_flag,hr_api.g_varchar2)
400: or not l_api_updating) then
401: --
402: -- check if value of lookup falls within lookup type.
403: --

Line 405: if hr_api.not_exists_in_hr_lookups

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

Line 468: <> nvl(ben_ddr_shd.g_old_rec.no_mn_num_dfnd_flag,hr_api.g_varchar2)

464: p_object_version_number => p_object_version_number);
465: --
466: if (l_api_updating
467: and p_no_mn_num_dfnd_flag
468: <> nvl(ben_ddr_shd.g_old_rec.no_mn_num_dfnd_flag,hr_api.g_varchar2)
469: or not l_api_updating) then
470: --
471: -- check if value of lookup falls within lookup type.
472: --

Line 474: if hr_api.not_exists_in_hr_lookups

470: --
471: -- check if value of lookup falls within lookup type.
472: --
473: --
474: if hr_api.not_exists_in_hr_lookups
475: (p_lookup_type => 'YES_NO',
476: p_lookup_code => p_no_mn_num_dfnd_flag,
477: p_effective_date => p_effective_date) then
478: --

Line 537: <> nvl(ben_ddr_shd.g_old_rec.grp_rlshp_cd,hr_api.g_varchar2)

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

Line 543: if hr_api.not_exists_in_hr_lookups

539: and p_grp_rlshp_cd is not null then
540: --
541: -- check if value of lookup falls within lookup type.
542: --
543: if hr_api.not_exists_in_hr_lookups
544: (p_lookup_type => 'BEN_GRP_RLSHP',
545: p_lookup_code => p_grp_rlshp_cd,
546: p_effective_date => p_effective_date) then
547: --

Line 781: (p_oipl_id in number default hr_api.g_number,

777: --
778: -- {End Of Comments}
779: -- ----------------------------------------------------------------------------
780: Procedure dt_update_validate
781: (p_oipl_id in number default hr_api.g_number,
782: p_opt_id in number default hr_api.g_number,
783: p_pl_id in number default hr_api.g_number,
784: p_datetrack_mode in varchar2,
785: p_validation_start_date in date,

Line 782: p_opt_id in number default hr_api.g_number,

778: -- {End Of Comments}
779: -- ----------------------------------------------------------------------------
780: Procedure dt_update_validate
781: (p_oipl_id in number default hr_api.g_number,
782: p_opt_id in number default hr_api.g_number,
783: p_pl_id in number default hr_api.g_number,
784: p_datetrack_mode in varchar2,
785: p_validation_start_date in date,
786: p_validation_end_date in date) Is

Line 783: p_pl_id in number default hr_api.g_number,

779: -- ----------------------------------------------------------------------------
780: Procedure dt_update_validate
781: (p_oipl_id in number default hr_api.g_number,
782: p_opt_id in number default hr_api.g_number,
783: p_pl_id in number default hr_api.g_number,
784: p_datetrack_mode in varchar2,
785: p_validation_start_date in date,
786: p_validation_end_date in date) Is
787: --

Line 797: hr_api.mandatory_arg_error

793: hr_utility.set_location('Entering:'||l_proc, 5);
794: --
795: -- Ensure that the p_datetrack_mode argument is not null
796: --
797: hr_api.mandatory_arg_error
798: (p_api_name => l_proc,
799: p_argument => 'datetrack_mode',
800: p_argument_value => p_datetrack_mode);
801: --

Line 809: hr_api.mandatory_arg_error

805: --
806: --
807: -- Ensure the arguments are not null
808: --
809: hr_api.mandatory_arg_error
810: (p_api_name => l_proc,
811: p_argument => 'validation_start_date',
812: p_argument_value => p_validation_start_date);
813: --

Line 814: hr_api.mandatory_arg_error

810: (p_api_name => l_proc,
811: p_argument => 'validation_start_date',
812: p_argument_value => p_validation_start_date);
813: --
814: hr_api.mandatory_arg_error
815: (p_api_name => l_proc,
816: p_argument => 'validation_end_date',
817: p_argument_value => p_validation_end_date);
818: --

Line 819: If ((nvl(p_oipl_id, hr_api.g_number) <> hr_api.g_number) and

815: (p_api_name => l_proc,
816: p_argument => 'validation_end_date',
817: p_argument_value => p_validation_end_date);
818: --
819: If ((nvl(p_oipl_id, hr_api.g_number) <> hr_api.g_number) and
820: NOT (dt_api.check_min_max_dates
821: (p_base_table_name => 'ben_oipl_f',
822: p_base_key_column => 'oipl_id',
823: p_base_key_value => p_oipl_id,

Line 829: If ((nvl(p_opt_id, hr_api.g_number) <> hr_api.g_number) and

825: p_to_date => p_validation_end_date))) Then
826: l_table_name := 'ben_oipl_f';
827: Raise l_integrity_error;
828: End If;
829: If ((nvl(p_opt_id, hr_api.g_number) <> hr_api.g_number) and
830: NOT (dt_api.check_min_max_dates
831: (p_base_table_name => 'ben_opt_f',
832: p_base_key_column => 'opt_id',
833: p_base_key_value => p_opt_id,

Line 839: If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and

835: p_to_date => p_validation_end_date))) Then
836: l_table_name := 'ben_opt_f';
837: Raise l_integrity_error;
838: End If;
839: If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and
840: NOT (dt_api.check_min_max_dates
841: (p_base_table_name => 'ben_pl_f',
842: p_base_key_column => 'pl_id',
843: p_base_key_value => p_pl_id,

Line 921: hr_api.mandatory_arg_error

917: hr_utility.set_location('Entering:'||l_proc, 5);
918: --
919: -- Ensure that the p_datetrack_mode argument is not null
920: --
921: hr_api.mandatory_arg_error
922: (p_api_name => l_proc,
923: p_argument => 'datetrack_mode',
924: p_argument_value => p_datetrack_mode);
925: --

Line 935: hr_api.mandatory_arg_error

931: --
932: --
933: -- Ensure the arguments are not null
934: --
935: hr_api.mandatory_arg_error
936: (p_api_name => l_proc,
937: p_argument => 'validation_start_date',
938: p_argument_value => p_validation_start_date);
939: --

Line 940: hr_api.mandatory_arg_error

936: (p_api_name => l_proc,
937: p_argument => 'validation_start_date',
938: p_argument_value => p_validation_start_date);
939: --
940: hr_api.mandatory_arg_error
941: (p_api_name => l_proc,
942: p_argument => 'validation_end_date',
943: p_argument_value => p_validation_end_date);
944: --

Line 945: hr_api.mandatory_arg_error

941: (p_api_name => l_proc,
942: p_argument => 'validation_end_date',
943: p_argument_value => p_validation_end_date);
944: --
945: hr_api.mandatory_arg_error
946: (p_api_name => l_proc,
947: p_argument => 'dsgn_rqmt_id',
948: p_argument_value => p_dsgn_rqmt_id);
949: --

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

988: --
989: -- Call all supporting business operations
990: --
991: --
992: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
993: --
994: chk_dsgn_rqmt_id
995: (p_dsgn_rqmt_id => p_rec.dsgn_rqmt_id,
996: p_effective_date => p_effective_date,

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

1082: --
1083: -- Call all supporting business operations
1084: --
1085: --
1086: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1087: --
1088: chk_dsgn_rqmt_id
1089: (p_dsgn_rqmt_id => p_rec.dsgn_rqmt_id,
1090: p_effective_date => p_effective_date,

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

1246: hr_utility.set_location('Entering:'|| l_proc, 10);
1247: --
1248: -- Ensure that all the mandatory parameter are not null
1249: --
1250: hr_api.mandatory_arg_error(p_api_name => l_proc,
1251: p_argument => 'dsgn_rqmt_id',
1252: p_argument_value => p_dsgn_rqmt_id);
1253: --
1254: open csr_leg_code;