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

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

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

Line 129: and elig_wk_loc_prte_id <> nvl(p_elig_wk_loc_prte_id,hr_api.g_number)

125: select null
126: from ben_elig_wk_loc_prte_f
127: where location_id = p_location_id
128: and eligy_prfl_id = p_eligy_prfl_id
129: and elig_wk_loc_prte_id <> nvl(p_elig_wk_loc_prte_id,hr_api.g_number)
130: and business_group_id + 0 = p_business_group_id
131: and p_validation_start_date <= effective_end_date
132: and p_validation_end_date >= effective_start_date
133: ;

Line 145: and nvl(p_location_id,hr_api.g_number)

141: p_effective_date => p_effective_date,
142: p_object_version_number => p_object_version_number);
143: --
144: if (l_api_updating
145: and nvl(p_location_id,hr_api.g_number)
146: <> nvl(ben_ewl_shd.g_old_rec.location_id,hr_api.g_number)
147: or not l_api_updating) then
148: --
149: -- check if location_id value exists in hr_locations table

Line 146: <> nvl(ben_ewl_shd.g_old_rec.location_id,hr_api.g_number)

142: p_object_version_number => p_object_version_number);
143: --
144: if (l_api_updating
145: and nvl(p_location_id,hr_api.g_number)
146: <> nvl(ben_ewl_shd.g_old_rec.location_id,hr_api.g_number)
147: or not l_api_updating) then
148: --
149: -- check if location_id value exists in hr_locations table
150: --

Line 232: <> nvl(ben_ewl_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

228: p_object_version_number => p_object_version_number);
229: --
230: if (l_api_updating
231: and p_excld_flag
232: <> nvl(ben_ewl_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
233: or not l_api_updating) then
234: --
235: -- check if value of lookup falls within lookup type.
236: --

Line 238: if hr_api.not_exists_in_hr_lookups

234: --
235: -- check if value of lookup falls within lookup type.
236: --
237: --
238: if hr_api.not_exists_in_hr_lookups
239: (p_lookup_type => 'YES_NO',
240: p_lookup_code => p_excld_flag,
241: p_effective_date => p_effective_date) then
242: --

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

340: --
341: -- {End Of Comments}
342: -- ----------------------------------------------------------------------------
343: Procedure dt_update_validate
344: (p_eligy_prfl_id in number default hr_api.g_number,
345: p_datetrack_mode in varchar2,
346: p_validation_start_date in date,
347: p_validation_end_date in date) Is
348: --

Line 358: hr_api.mandatory_arg_error

354: hr_utility.set_location('Entering:'||l_proc, 5);
355: --
356: -- Ensure that the p_datetrack_mode argument is not null
357: --
358: hr_api.mandatory_arg_error
359: (p_api_name => l_proc,
360: p_argument => 'datetrack_mode',
361: p_argument_value => p_datetrack_mode);
362: --

Line 370: hr_api.mandatory_arg_error

366: --
367: --
368: -- Ensure the arguments are not null
369: --
370: hr_api.mandatory_arg_error
371: (p_api_name => l_proc,
372: p_argument => 'validation_start_date',
373: p_argument_value => p_validation_start_date);
374: --

Line 375: hr_api.mandatory_arg_error

371: (p_api_name => l_proc,
372: p_argument => 'validation_start_date',
373: p_argument_value => p_validation_start_date);
374: --
375: hr_api.mandatory_arg_error
376: (p_api_name => l_proc,
377: p_argument => 'validation_end_date',
378: p_argument_value => p_validation_end_date);
379: --

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

376: (p_api_name => l_proc,
377: p_argument => 'validation_end_date',
378: p_argument_value => p_validation_end_date);
379: --
380: If ((nvl(p_eligy_prfl_id, hr_api.g_number) <> hr_api.g_number) and
381: NOT (dt_api.check_min_max_dates
382: (p_base_table_name => 'ben_eligy_prfl_f',
383: p_base_key_column => 'eligy_prfl_id',
384: p_base_key_value => p_eligy_prfl_id,

Line 464: hr_api.mandatory_arg_error

460: hr_utility.set_location('Entering:'||l_proc, 5);
461: --
462: -- Ensure that the p_datetrack_mode argument is not null
463: --
464: hr_api.mandatory_arg_error
465: (p_api_name => l_proc,
466: p_argument => 'datetrack_mode',
467: p_argument_value => p_datetrack_mode);
468: --

Line 478: hr_api.mandatory_arg_error

474: --
475: --
476: -- Ensure the arguments are not null
477: --
478: hr_api.mandatory_arg_error
479: (p_api_name => l_proc,
480: p_argument => 'validation_start_date',
481: p_argument_value => p_validation_start_date);
482: --

Line 483: hr_api.mandatory_arg_error

479: (p_api_name => l_proc,
480: p_argument => 'validation_start_date',
481: p_argument_value => p_validation_start_date);
482: --
483: hr_api.mandatory_arg_error
484: (p_api_name => l_proc,
485: p_argument => 'validation_end_date',
486: p_argument_value => p_validation_end_date);
487: --

Line 488: hr_api.mandatory_arg_error

484: (p_api_name => l_proc,
485: p_argument => 'validation_end_date',
486: p_argument_value => p_validation_end_date);
487: --
488: hr_api.mandatory_arg_error
489: (p_api_name => l_proc,
490: p_argument => 'elig_wk_loc_prte_id',
491: p_argument_value => p_elig_wk_loc_prte_id);
492: --

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

532: --
533: -- Call all supporting business operations
534: --
535: --
536: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
537: --
538: chk_elig_wk_loc_prte_id
539: (p_elig_wk_loc_prte_id => p_rec.elig_wk_loc_prte_id,
540: p_effective_date => p_effective_date,

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

582: --
583: -- Call all supporting business operations
584: --
585: --
586: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
587: --
588: chk_elig_wk_loc_prte_id
589: (p_elig_wk_loc_prte_id => p_rec.elig_wk_loc_prte_id,
590: p_effective_date => p_effective_date,

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

676: hr_utility.set_location('Entering:'|| l_proc, 10);
677: --
678: -- Ensure that all the mandatory parameter are not null
679: --
680: hr_api.mandatory_arg_error(p_api_name => l_proc,
681: p_argument => 'elig_wk_loc_prte_id',
682: p_argument_value => p_elig_wk_loc_prte_id);
683: --
684: open csr_leg_code;