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

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

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

Line 124: <> nvl(ben_eqg_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

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

Line 130: if hr_api.not_exists_in_hr_lookups

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

Line 196: <> nvl(ben_eqg_shd.g_old_rec.quar_in_grade_cd,hr_api.g_varchar2)

192: p_object_version_number => p_object_version_number);
193: --
194: if (l_api_updating
195: and p_quar_in_grade_cd
196: <> nvl(ben_eqg_shd.g_old_rec.quar_in_grade_cd,hr_api.g_varchar2)
197: or not l_api_updating) then
198: --
199: -- check if value of lookup falls within lookup type.
200: --

Line 202: if hr_api.not_exists_in_hr_lookups

198: --
199: -- check if value of lookup falls within lookup type.
200: --
201: --
202: if hr_api.not_exists_in_hr_lookups
203: (p_lookup_type => 'BEN_CWB_QUAR_IN_GRD',
204: p_lookup_code => p_quar_in_grade_cd,
205: p_effective_date => p_effective_date) then
206: --

Line 263: and eqg.ELIG_QUA_IN_GR_PRTE_id <> nvl(p_ELIG_QUA_IN_GR_PRTE_id, hr_api.g_number) ;

259: select null
260: from ben_ELIG_QUA_IN_GR_PRTE_f eqg
261: where eqg.eligy_prfl_id = p_eligy_prfl_id
262: and eqg.quar_in_grade_cd = p_quar_in_grade_cd
263: and eqg.ELIG_QUA_IN_GR_PRTE_id <> nvl(p_ELIG_QUA_IN_GR_PRTE_id, hr_api.g_number) ;
264: --
265: Begin
266: --
267: hr_utility.set_location('Entering:'||l_proc, 5);

Line 384: (p_eligy_prfl_id in number default hr_api.g_number,

380: --
381: -- {End Of Comments}
382: -- ----------------------------------------------------------------------------
383: Procedure dt_update_validate
384: (p_eligy_prfl_id in number default hr_api.g_number,
385: p_datetrack_mode in varchar2,
386: p_validation_start_date in date,
387: p_validation_end_date in date) Is
388: --

Line 398: hr_api.mandatory_arg_error

394: hr_utility.set_location('Entering:'||l_proc, 5);
395: --
396: -- Ensure that the p_datetrack_mode argument is not null
397: --
398: hr_api.mandatory_arg_error
399: (p_api_name => l_proc,
400: p_argument => 'datetrack_mode',
401: p_argument_value => p_datetrack_mode);
402: --

Line 410: hr_api.mandatory_arg_error

406: --
407: --
408: -- Ensure the arguments are not null
409: --
410: hr_api.mandatory_arg_error
411: (p_api_name => l_proc,
412: p_argument => 'validation_start_date',
413: p_argument_value => p_validation_start_date);
414: --

Line 415: hr_api.mandatory_arg_error

411: (p_api_name => l_proc,
412: p_argument => 'validation_start_date',
413: p_argument_value => p_validation_start_date);
414: --
415: hr_api.mandatory_arg_error
416: (p_api_name => l_proc,
417: p_argument => 'validation_end_date',
418: p_argument_value => p_validation_end_date);
419: --

Line 420: If ((nvl(p_eligy_prfl_id , hr_api.g_number) <> hr_api.g_number) and

416: (p_api_name => l_proc,
417: p_argument => 'validation_end_date',
418: p_argument_value => p_validation_end_date);
419: --
420: If ((nvl(p_eligy_prfl_id , hr_api.g_number) <> hr_api.g_number) and
421: NOT (dt_api.check_min_max_dates
422: (p_base_table_name => 'ben_eligy_prfl_f',
423: p_base_key_column => 'eligy_prfl_id ',
424: p_base_key_value => p_eligy_prfl_id ,

Line 503: hr_api.mandatory_arg_error

499: hr_utility.set_location('Entering:'||l_proc, 5);
500: --
501: -- Ensure that the p_datetrack_mode argument is not null
502: --
503: hr_api.mandatory_arg_error
504: (p_api_name => l_proc,
505: p_argument => 'datetrack_mode',
506: p_argument_value => p_datetrack_mode);
507: --

Line 517: hr_api.mandatory_arg_error

513: --
514: --
515: -- Ensure the arguments are not null
516: --
517: hr_api.mandatory_arg_error
518: (p_api_name => l_proc,
519: p_argument => 'validation_start_date',
520: p_argument_value => p_validation_start_date);
521: --

Line 522: hr_api.mandatory_arg_error

518: (p_api_name => l_proc,
519: p_argument => 'validation_start_date',
520: p_argument_value => p_validation_start_date);
521: --
522: hr_api.mandatory_arg_error
523: (p_api_name => l_proc,
524: p_argument => 'validation_end_date',
525: p_argument_value => p_validation_end_date);
526: --

Line 527: hr_api.mandatory_arg_error

523: (p_api_name => l_proc,
524: p_argument => 'validation_end_date',
525: p_argument_value => p_validation_end_date);
526: --
527: hr_api.mandatory_arg_error
528: (p_api_name => l_proc,
529: p_argument => 'ELIG_QUA_IN_GR_PRTE_id',
530: p_argument_value => p_ELIG_QUA_IN_GR_PRTE_id);
531: --

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

570: hr_utility.set_location('Entering:'||l_proc, 5);
571: --
572: -- Call all supporting business operations
573: --
574: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
575: --
576: chk_ELIG_QUA_IN_GR_PRTE_id
577: (p_ELIG_QUA_IN_GR_PRTE_id => p_rec.ELIG_QUA_IN_GR_PRTE_id,
578: p_effective_date => p_effective_date,

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

622: hr_utility.set_location('Entering:'||l_proc, 5);
623: --
624: -- Call all supporting business operations
625: --
626: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
627: --
628: chk_ELIG_QUA_IN_GR_PRTE_id
629: (p_ELIG_QUA_IN_GR_PRTE_id => p_rec.ELIG_QUA_IN_GR_PRTE_id,
630: p_effective_date => p_effective_date,

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

719: hr_utility.set_location('Entering:'|| l_proc, 10);
720: --
721: -- Ensure that all the mandatory parameter are not null
722: --
723: hr_api.mandatory_arg_error(p_api_name => l_proc,
724: p_argument => 'ELIG_QUA_IN_GR_PRTE_id',
725: p_argument_value => p_ELIG_QUA_IN_GR_PRTE_id);
726: --
727: open csr_leg_code;