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

Line 55: and nvl(p_qual_titl_rt_id,hr_api.g_number)

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

Line 125: <> nvl(ben_qtr_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

121: p_object_version_number => p_object_version_number);
122: --
123: if (l_api_updating
124: and p_excld_flag
125: <> nvl(ben_qtr_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
126: or not l_api_updating) then
127: --
128: -- check if value of lookup falls within lookup type.
129: --

Line 131: if hr_api.not_exists_in_hr_lookups

127: --
128: -- check if value of lookup falls within lookup type.
129: --
130: --
131: if hr_api.not_exists_in_hr_lookups
132: (p_lookup_type => 'YES_NO',
133: p_lookup_code => p_excld_flag,
134: p_effective_date => p_effective_date) then
135: --

Line 202: and nvl(p_qualification_type_id,hr_api.g_number)

198: p_effective_date => p_effective_date,
199: p_object_version_number => p_object_version_number);
200: --
201: if (l_api_updating
202: and nvl(p_qualification_type_id,hr_api.g_number)
203: <> nvl(ben_qtr_shd.g_old_rec.qualification_type_id,hr_api.g_number)
204: or not l_api_updating)
205: and p_qualification_type_id is not null then
206: --

Line 203: <> nvl(ben_qtr_shd.g_old_rec.qualification_type_id,hr_api.g_number)

199: p_object_version_number => p_object_version_number);
200: --
201: if (l_api_updating
202: and nvl(p_qualification_type_id,hr_api.g_number)
203: <> nvl(ben_qtr_shd.g_old_rec.qualification_type_id,hr_api.g_number)
204: or not l_api_updating)
205: and p_qualification_type_id is not null then
206: --
207: -- check if qualification_type_id value exists in

Line 279: and qtr.qual_titl_rt_id <> nvl(p_qual_titl_rt_id,hr_api.g_number)

275: from ben_qual_titl_rt_f qtr
276: where nvl(qtr.qualification_type_id,-1) = nvl(p_qualification_type_id,-1)
277: and nvl(qtr.title,-1) = nvl(p_title,-1)
278: and qtr.vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
279: and qtr.qual_titl_rt_id <> nvl(p_qual_titl_rt_id,hr_api.g_number)
280: and qtr.business_group_id = p_business_group_id
281: and p_validation_start_date <= qtr.effective_end_date
282: and p_validation_end_date >= qtr.effective_start_date;
283:

Line 407: (p_vrbl_rt_prfl_id in number default hr_api.g_number,

403: --
404: -- {End Of Comments}
405: -- ----------------------------------------------------------------------------
406: Procedure dt_update_validate
407: (p_vrbl_rt_prfl_id in number default hr_api.g_number,
408: p_datetrack_mode in varchar2,
409: p_validation_start_date in date,
410: p_validation_end_date in date) Is
411: --

Line 421: hr_api.mandatory_arg_error

417: hr_utility.set_location('Entering:'||l_proc, 5);
418: --
419: -- Ensure that the p_datetrack_mode argument is not null
420: --
421: hr_api.mandatory_arg_error
422: (p_api_name => l_proc,
423: p_argument => 'datetrack_mode',
424: p_argument_value => p_datetrack_mode);
425: --

Line 433: hr_api.mandatory_arg_error

429: --
430: --
431: -- Ensure the arguments are not null
432: --
433: hr_api.mandatory_arg_error
434: (p_api_name => l_proc,
435: p_argument => 'validation_start_date',
436: p_argument_value => p_validation_start_date);
437: --

Line 438: hr_api.mandatory_arg_error

434: (p_api_name => l_proc,
435: p_argument => 'validation_start_date',
436: p_argument_value => p_validation_start_date);
437: --
438: hr_api.mandatory_arg_error
439: (p_api_name => l_proc,
440: p_argument => 'validation_end_date',
441: p_argument_value => p_validation_end_date);
442: --

Line 443: If ((nvl(p_vrbl_rt_prfl_id, hr_api.g_number) <> hr_api.g_number) and

439: (p_api_name => l_proc,
440: p_argument => 'validation_end_date',
441: p_argument_value => p_validation_end_date);
442: --
443: If ((nvl(p_vrbl_rt_prfl_id, hr_api.g_number) <> hr_api.g_number) and
444: NOT (dt_api.check_min_max_dates
445: (p_base_table_name => 'ben_vrbl_rt_prfl_f',
446: p_base_key_column => 'vrbl_rt_prfl_id',
447: p_base_key_value => p_vrbl_rt_prfl_id,

Line 526: hr_api.mandatory_arg_error

522: hr_utility.set_location('Entering:'||l_proc, 5);
523: --
524: -- Ensure that the p_datetrack_mode argument is not null
525: --
526: hr_api.mandatory_arg_error
527: (p_api_name => l_proc,
528: p_argument => 'datetrack_mode',
529: p_argument_value => p_datetrack_mode);
530: --

Line 540: hr_api.mandatory_arg_error

536: --
537: --
538: -- Ensure the arguments are not null
539: --
540: hr_api.mandatory_arg_error
541: (p_api_name => l_proc,
542: p_argument => 'validation_start_date',
543: p_argument_value => p_validation_start_date);
544: --

Line 545: hr_api.mandatory_arg_error

541: (p_api_name => l_proc,
542: p_argument => 'validation_start_date',
543: p_argument_value => p_validation_start_date);
544: --
545: hr_api.mandatory_arg_error
546: (p_api_name => l_proc,
547: p_argument => 'validation_end_date',
548: p_argument_value => p_validation_end_date);
549: --

Line 550: hr_api.mandatory_arg_error

546: (p_api_name => l_proc,
547: p_argument => 'validation_end_date',
548: p_argument_value => p_validation_end_date);
549: --
550: hr_api.mandatory_arg_error
551: (p_api_name => l_proc,
552: p_argument => 'qual_titl_rt_id',
553: p_argument_value => p_qual_titl_rt_id);
554: --

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

594: --
595: -- Call all supporting business operations
596: --
597: --
598: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
599: --
600: chk_qual_titl_rt_id
601: (p_qual_titl_rt_id => p_rec.qual_titl_rt_id,
602: p_effective_date => p_effective_date,

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

654: --
655: -- Call all supporting business operations
656: --
657: --
658: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
659: --
660: chk_qual_titl_rt_id
661: (p_qual_titl_rt_id => p_rec.qual_titl_rt_id,
662: p_effective_date => p_effective_date,

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

757: hr_utility.set_location('Entering:'|| l_proc, 10);
758: --
759: -- Ensure that all the mandatory parameter are not null
760: --
761: hr_api.mandatory_arg_error(p_api_name => l_proc,
762: p_argument => 'qual_titl_rt_id',
763: p_argument_value => p_qual_titl_rt_id);
764: --
765: open csr_leg_code;