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

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

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

Line 129: and nvl(p_comp_lvl_fctr_id,hr_api.g_number)

125: p_effective_date => p_effective_date,
126: p_object_version_number => p_object_version_number);
127: --
128: if (p_comp_lvl_fctr_id is not null) and (l_api_updating
129: and nvl(p_comp_lvl_fctr_id,hr_api.g_number)
130: <> nvl(ben_mtr_shd.g_old_rec.comp_lvl_fctr_id,hr_api.g_number)
131: or not l_api_updating) then
132: --
133: -- check if comp_lvl_fctr_id value exists in ben_comp_lvl_fctr table

Line 130: <> nvl(ben_mtr_shd.g_old_rec.comp_lvl_fctr_id,hr_api.g_number)

126: p_object_version_number => p_object_version_number);
127: --
128: if (p_comp_lvl_fctr_id is not null) and (l_api_updating
129: and nvl(p_comp_lvl_fctr_id,hr_api.g_number)
130: <> nvl(ben_mtr_shd.g_old_rec.comp_lvl_fctr_id,hr_api.g_number)
131: or not l_api_updating) then
132: --
133: -- check if comp_lvl_fctr_id value exists in ben_comp_lvl_fctr table
134: --

Line 202: <> nvl(ben_mtr_shd.g_old_rec.no_mx_pct_of_py_num_flag,hr_api.g_varchar2)

198: p_object_version_number => p_object_version_number);
199: --
200: if (l_api_updating
201: and p_no_mx_pct_of_py_num_flag
202: <> nvl(ben_mtr_shd.g_old_rec.no_mx_pct_of_py_num_flag,hr_api.g_varchar2)
203: or not l_api_updating) then
204: --
205: -- check if value of lookup falls within lookup type.
206: --

Line 208: if hr_api.not_exists_in_hr_lookups

204: --
205: -- check if value of lookup falls within lookup type.
206: --
207: --
208: if hr_api.not_exists_in_hr_lookups
209: (p_lookup_type => 'YES_NO',
210: p_lookup_code => p_no_mx_pct_of_py_num_flag,
211: p_effective_date => p_effective_date) then
212: --

Line 271: <> nvl(ben_mtr_shd.g_old_rec.no_mx_mtch_amt_flag,hr_api.g_varchar2)

267: p_object_version_number => p_object_version_number);
268: --
269: if (l_api_updating
270: and p_no_mx_mtch_amt_flag
271: <> nvl(ben_mtr_shd.g_old_rec.no_mx_mtch_amt_flag,hr_api.g_varchar2)
272: or not l_api_updating) then
273: --
274: -- check if value of lookup falls within lookup type.
275: --

Line 277: if hr_api.not_exists_in_hr_lookups

273: --
274: -- check if value of lookup falls within lookup type.
275: --
276: --
277: if hr_api.not_exists_in_hr_lookups
278: (p_lookup_type => 'YES_NO',
279: p_lookup_code => p_no_mx_mtch_amt_flag,
280: p_effective_date => p_effective_date) then
281: --

Line 356: and nvl(p_mtchg_rt_calc_rl,hr_api.g_number)

352: p_effective_date => p_effective_date,
353: p_object_version_number => p_object_version_number);
354: --
355: if (l_api_updating
356: and nvl(p_mtchg_rt_calc_rl,hr_api.g_number)
357: <> ben_mtr_shd.g_old_rec.mtchg_rt_calc_rl
358: or not l_api_updating)
359: and p_mtchg_rt_calc_rl is not null then
360: --

Line 435: <> nvl(ben_mtr_shd.g_old_rec.no_mx_amt_of_py_num_flag,hr_api.g_varchar2)

431: p_object_version_number => p_object_version_number);
432: --
433: if (l_api_updating
434: and p_no_mx_amt_of_py_num_flag
435: <> nvl(ben_mtr_shd.g_old_rec.no_mx_amt_of_py_num_flag,hr_api.g_varchar2)
436: or not l_api_updating) then
437: --
438: -- check if value of lookup falls within lookup type.
439: --

Line 441: if hr_api.not_exists_in_hr_lookups

437: --
438: -- check if value of lookup falls within lookup type.
439: --
440: --
441: if hr_api.not_exists_in_hr_lookups
442: (p_lookup_type => 'YES_NO',
443: p_lookup_code => p_no_mx_amt_of_py_num_flag,
444: p_effective_date => p_effective_date) then
445: --

Line 504: <> nvl(ben_mtr_shd.g_old_rec.cntnu_mtch_aftr_mx_rl_flag,hr_api.g_varchar2)

500: p_object_version_number => p_object_version_number);
501: --
502: if (l_api_updating
503: and p_cntnu_mtch_aftr_mx_rl_flag
504: <> nvl(ben_mtr_shd.g_old_rec.cntnu_mtch_aftr_mx_rl_flag,hr_api.g_varchar2)
505: or not l_api_updating) then
506: --
507: -- check if value of lookup falls within lookup type.
508: --

Line 510: if hr_api.not_exists_in_hr_lookups

506: --
507: -- check if value of lookup falls within lookup type.
508: --
509: --
510: if hr_api.not_exists_in_hr_lookups
511: (p_lookup_type => 'YES_NO',
512: p_lookup_code => p_cntnu_mtch_aftr_mx_rl_flag,
513: p_effective_date => p_effective_date) then
514: --

Line 801: (p_acty_base_rt_id in number default hr_api.g_number,

797: --
798: -- {End Of Comments}
799: -- ----------------------------------------------------------------------------
800: Procedure dt_update_validate
801: (p_acty_base_rt_id in number default hr_api.g_number,
802: p_datetrack_mode in varchar2,
803: p_validation_start_date in date,
804: p_validation_end_date in date) Is
805: --

Line 815: hr_api.mandatory_arg_error

811: hr_utility.set_location('Entering:'||l_proc, 5);
812: --
813: -- Ensure that the p_datetrack_mode argument is not null
814: --
815: hr_api.mandatory_arg_error
816: (p_api_name => l_proc,
817: p_argument => 'datetrack_mode',
818: p_argument_value => p_datetrack_mode);
819: --

Line 827: hr_api.mandatory_arg_error

823: --
824: --
825: -- Ensure the arguments are not null
826: --
827: hr_api.mandatory_arg_error
828: (p_api_name => l_proc,
829: p_argument => 'validation_start_date',
830: p_argument_value => p_validation_start_date);
831: --

Line 832: hr_api.mandatory_arg_error

828: (p_api_name => l_proc,
829: p_argument => 'validation_start_date',
830: p_argument_value => p_validation_start_date);
831: --
832: hr_api.mandatory_arg_error
833: (p_api_name => l_proc,
834: p_argument => 'validation_end_date',
835: p_argument_value => p_validation_end_date);
836: --

Line 837: If ((nvl(p_acty_base_rt_id, hr_api.g_number) <> hr_api.g_number) and

833: (p_api_name => l_proc,
834: p_argument => 'validation_end_date',
835: p_argument_value => p_validation_end_date);
836: --
837: If ((nvl(p_acty_base_rt_id, hr_api.g_number) <> hr_api.g_number) and
838: NOT (dt_api.check_min_max_dates
839: (p_base_table_name => 'ben_acty_base_rt_f',
840: p_base_key_column => 'acty_base_rt_id',
841: p_base_key_value => p_acty_base_rt_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 => 'mtchg_rt_id',
948: p_argument_value => p_mtchg_rt_id);
949: --

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

989: --
990: -- Call all supporting business operations
991: --
992: --
993: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
994: --
995: chk_mtchg_rt_id
996: (p_mtchg_rt_id => p_rec.mtchg_rt_id,
997: p_effective_date => p_effective_date,

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

1076: --
1077: -- Call all supporting business operations
1078: --
1079: --
1080: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1081: --
1082: chk_mtchg_rt_id
1083: (p_mtchg_rt_id => p_rec.mtchg_rt_id,
1084: p_effective_date => p_effective_date,

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

1208: hr_utility.set_location('Entering:'|| l_proc, 10);
1209: --
1210: -- Ensure that all the mandatory parameter are not null
1211: --
1212: hr_api.mandatory_arg_error(p_api_name => l_proc,
1213: p_argument => 'mtchg_rt_id',
1214: p_argument_value => p_mtchg_rt_id);
1215: --
1216: open csr_leg_code;