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

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

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

Line 287: <> nvl(ben_opt_shd.g_old_rec.invk_wv_opt_flag,hr_api.g_varchar2)

283: p_object_version_number => p_object_version_number);
284: --
285: if (l_api_updating
286: and p_invk_wv_opt_flag
287: <> nvl(ben_opt_shd.g_old_rec.invk_wv_opt_flag,hr_api.g_varchar2)
288: or not l_api_updating)
289: and p_invk_wv_opt_flag is not null then
290: --
291: -- check if value of lookup falls within lookup type.

Line 293: if hr_api.not_exists_in_hr_lookups

289: and p_invk_wv_opt_flag is not null then
290: --
291: -- check if value of lookup falls within lookup type.
292: --
293: if hr_api.not_exists_in_hr_lookups
294: (p_lookup_type => 'YES_NO',
295: p_lookup_code => p_invk_wv_opt_flag,
296: p_effective_date => p_effective_date) then
297: --

Line 372: and nvl(p_rqd_perd_enrt_nenrt_rl,hr_api.g_number)

368: p_effective_date => p_effective_date,
369: p_object_version_number => p_object_version_number);
370: --
371: if (l_api_updating
372: and nvl(p_rqd_perd_enrt_nenrt_rl,hr_api.g_number)
373: <> nvl(ben_opt_shd.g_old_rec.rqd_perd_enrt_nenrt_rl,hr_api.g_number)
374: or not l_api_updating)
375: and p_rqd_perd_enrt_nenrt_rl is not null then
376: --

Line 373: <> nvl(ben_opt_shd.g_old_rec.rqd_perd_enrt_nenrt_rl,hr_api.g_number)

369: p_object_version_number => p_object_version_number);
370: --
371: if (l_api_updating
372: and nvl(p_rqd_perd_enrt_nenrt_rl,hr_api.g_number)
373: <> nvl(ben_opt_shd.g_old_rec.rqd_perd_enrt_nenrt_rl,hr_api.g_number)
374: or not l_api_updating)
375: and p_rqd_perd_enrt_nenrt_rl is not null then
376: --
377: -- check if value of formula rule is valid.

Line 449: <> nvl(ben_opt_shd.g_old_rec.rqd_perd_enrt_nenrt_uom,hr_api.g_varchar2)

445: p_object_version_number => p_object_version_number);
446: --
447: if (l_api_updating
448: and p_rqd_perd_enrt_nenrt_uom
449: <> nvl(ben_opt_shd.g_old_rec.rqd_perd_enrt_nenrt_uom,hr_api.g_varchar2)
450: or not l_api_updating)
451: and p_rqd_perd_enrt_nenrt_uom is not null then
452: --
453: -- check if value of lookup falls within lookup type.

Line 455: if hr_api.not_exists_in_hr_lookups

451: and p_rqd_perd_enrt_nenrt_uom is not null then
452: --
453: -- check if value of lookup falls within lookup type.
454: --
455: if hr_api.not_exists_in_hr_lookups
456: (p_lookup_type => 'BEN_RQD_PERD_ENRT_NENRT_TM_UOM',
457: p_lookup_code => p_rqd_perd_enrt_nenrt_uom,
458: p_effective_date => p_effective_date) then
459: --

Line 594: <> nvl(ben_opt_shd.g_old_rec.component_reason,hr_api.g_varchar2)

590: p_object_version_number => p_object_version_number);
591: --
592: if (l_api_updating
593: and p_component_reason
594: <> nvl(ben_opt_shd.g_old_rec.component_reason,hr_api.g_varchar2)
595: or not l_api_updating)
596: and p_component_reason is not null then
597: --
598: -- check if value of lookup falls within lookup type.

Line 600: if hr_api.not_exists_in_hr_lookups

596: and p_component_reason is not null then
597: --
598: -- check if value of lookup falls within lookup type.
599: --
600: if hr_api.not_exists_in_hr_lookups
601: (p_lookup_type => 'PROPOSAL_REASON',
602: p_lookup_code => p_component_reason,
603: p_effective_date => p_effective_date) then
604: --

Line 663: <> nvl(ben_opt_shd.g_old_rec.mapping_table_name,hr_api.g_varchar2)

659: p_object_version_number => p_object_version_number);
660: --
661: if (l_api_updating
662: and p_mapping_table_name
663: <> nvl(ben_opt_shd.g_old_rec.mapping_table_name,hr_api.g_varchar2)
664: or not l_api_updating)
665: and p_mapping_table_name is not null then
666: --
667: -- check if value of lookup falls within lookup type.

Line 669: if hr_api.not_exists_in_hr_lookups

665: and p_mapping_table_name is not null then
666: --
667: -- check if value of lookup falls within lookup type.
668: --
669: if hr_api.not_exists_in_hr_lookups
670: (p_lookup_type => 'BEN_MAPPING_OPTION_TABLE',
671: p_lookup_code => p_mapping_table_name,
672: p_effective_date => p_effective_date) then
673: --

Line 743: and nvl(p_mapping_table_pk_id,hr_api.g_number)

739: p_effective_date => p_effective_date,
740: p_object_version_number => p_object_version_number);
741: --
742: if (l_api_updating
743: and nvl(p_mapping_table_pk_id,hr_api.g_number)
744: <> nvl(ben_opt_shd.g_old_rec.mapping_table_pk_id,hr_api.g_number)
745: or not l_api_updating)
746: and p_mapping_table_pk_id is not null then
747: --

Line 744: <> nvl(ben_opt_shd.g_old_rec.mapping_table_pk_id,hr_api.g_number)

740: p_object_version_number => p_object_version_number);
741: --
742: if (l_api_updating
743: and nvl(p_mapping_table_pk_id,hr_api.g_number)
744: <> nvl(ben_opt_shd.g_old_rec.mapping_table_pk_id,hr_api.g_number)
745: or not l_api_updating)
746: and p_mapping_table_pk_id is not null then
747: --
748: -- check if value of Mapping Table Primary Key Id is valid.

Line 886: (p_cmbn_ptip_opt_id in number default hr_api.g_number,

882: --
883: -- {End Of Comments}
884: -- ----------------------------------------------------------------------------
885: Procedure dt_update_validate
886: (p_cmbn_ptip_opt_id in number default hr_api.g_number,
887: p_datetrack_mode in varchar2,
888: p_validation_start_date in date,
889: p_validation_end_date in date) Is
890: --

Line 900: hr_api.mandatory_arg_error

896: hr_utility.set_location('Entering:'||l_proc, 5);
897: --
898: -- Ensure that the p_datetrack_mode argument is not null
899: --
900: hr_api.mandatory_arg_error
901: (p_api_name => l_proc,
902: p_argument => 'datetrack_mode',
903: p_argument_value => p_datetrack_mode);
904: --

Line 912: hr_api.mandatory_arg_error

908: --
909: --
910: -- Ensure the arguments are not null
911: --
912: hr_api.mandatory_arg_error
913: (p_api_name => l_proc,
914: p_argument => 'validation_start_date',
915: p_argument_value => p_validation_start_date);
916: --

Line 917: hr_api.mandatory_arg_error

913: (p_api_name => l_proc,
914: p_argument => 'validation_start_date',
915: p_argument_value => p_validation_start_date);
916: --
917: hr_api.mandatory_arg_error
918: (p_api_name => l_proc,
919: p_argument => 'validation_end_date',
920: p_argument_value => p_validation_end_date);
921: --

Line 922: /* If ((nvl(p_cmbn_ptip_opt_id, hr_api.g_number) <> hr_api.g_number) and

918: (p_api_name => l_proc,
919: p_argument => 'validation_end_date',
920: p_argument_value => p_validation_end_date);
921: --
922: /* If ((nvl(p_cmbn_ptip_opt_id, hr_api.g_number) <> hr_api.g_number) and
923: NOT (dt_api.check_min_max_dates
924: (p_base_table_name => 'ben_cmbn_ptip_opt_f',
925: p_base_key_column => 'cmbn_ptip_opt_id',
926: p_base_key_value => p_cmbn_ptip_opt_id,

Line 1005: hr_api.mandatory_arg_error

1001: hr_utility.set_location('Entering:'||l_proc, 5);
1002: --
1003: -- Ensure that the p_datetrack_mode argument is not null
1004: --
1005: hr_api.mandatory_arg_error
1006: (p_api_name => l_proc,
1007: p_argument => 'datetrack_mode',
1008: p_argument_value => p_datetrack_mode);
1009: --

Line 1019: hr_api.mandatory_arg_error

1015: --
1016: --
1017: -- Ensure the arguments are not null
1018: --
1019: hr_api.mandatory_arg_error
1020: (p_api_name => l_proc,
1021: p_argument => 'validation_start_date',
1022: p_argument_value => p_validation_start_date);
1023: --

Line 1024: hr_api.mandatory_arg_error

1020: (p_api_name => l_proc,
1021: p_argument => 'validation_start_date',
1022: p_argument_value => p_validation_start_date);
1023: --
1024: hr_api.mandatory_arg_error
1025: (p_api_name => l_proc,
1026: p_argument => 'validation_end_date',
1027: p_argument_value => p_validation_end_date);
1028: --

Line 1029: hr_api.mandatory_arg_error

1025: (p_api_name => l_proc,
1026: p_argument => 'validation_end_date',
1027: p_argument_value => p_validation_end_date);
1028: --
1029: hr_api.mandatory_arg_error
1030: (p_api_name => l_proc,
1031: p_argument => 'opt_id',
1032: p_argument_value => p_opt_id);
1033: --

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

1110: -- Call all supporting business operations
1111: --
1112: --
1113: if p_rec.business_group_id is not null and p_rec.legislation_code is null then
1114: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1115: end if;
1116: --
1117: chk_opt_id
1118: (p_opt_id => p_rec.opt_id,

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

1198: -- Call all supporting business operations
1199: --
1200: --
1201: if p_rec.business_group_id is not null and p_rec.legislation_code is null then
1202: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1203: end if;
1204: --
1205: chk_opt_id
1206: (p_opt_id => p_rec.opt_id,

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

1361: hr_utility.set_location('Entering:'|| l_proc, 10);
1362: --
1363: -- Ensure that all the mandatory parameter are not null
1364: --
1365: hr_api.mandatory_arg_error(p_api_name => l_proc,
1366: p_argument => 'opt_id',
1367: p_argument_value => p_opt_id);
1368: --
1369: open csr_leg_code;