DBA Data[Home] [Help]

APPS.BEN_ETU_BUS dependencies on HR_API

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

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

Line 177: and etu.elig_tbco_use_prte_id <> nvl(p_elig_tbco_use_prte_id, hr_api.g_number) ;

173: select null
174: from ben_elig_tbco_use_prte_f etu
175: where etu.eligy_prfl_id = p_eligy_prfl_id
176: and etu.uses_tbco_flag = p_uses_tbco_flag
177: and etu.elig_tbco_use_prte_id <> nvl(p_elig_tbco_use_prte_id, hr_api.g_number) ;
178: --
179: Begin
180: --
181: hr_utility.set_location('Entering:'||l_proc, 5);

Line 255: <> nvl(ben_etu_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

251: p_object_version_number => p_object_version_number);
252: --
253: if (l_api_updating
254: and p_excld_flag
255: <> nvl(ben_etu_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
256: or not l_api_updating) then
257: --
258: -- check if value of lookup falls within lookup type.
259: --

Line 261: if hr_api.not_exists_in_hr_lookups

257: --
258: -- check if value of lookup falls within lookup type.
259: --
260: --
261: if hr_api.not_exists_in_hr_lookups
262: (p_lookup_type => 'YES_NO',
263: p_lookup_code => p_excld_flag,
264: p_effective_date => p_effective_date) then
265: --

Line 324: <> nvl(ben_etu_shd.g_old_rec.uses_tbco_flag,hr_api.g_varchar2)

320: p_object_version_number => p_object_version_number);
321: --
322: if (l_api_updating
323: and p_uses_tbco_flag
324: <> nvl(ben_etu_shd.g_old_rec.uses_tbco_flag,hr_api.g_varchar2)
325: or not l_api_updating) then
326: --
327: -- check if value of lookup falls within lookup type.
328: --

Line 330: if hr_api.not_exists_in_hr_lookups

326: --
327: -- check if value of lookup falls within lookup type.
328: --
329: --
330: if hr_api.not_exists_in_hr_lookups
331: (p_lookup_type => 'TOBACCO_USER',
332: p_lookup_code => p_uses_tbco_flag,
333: p_effective_date => p_effective_date) then
334: --

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

374: --
375: -- {End Of Comments}
376: -- ----------------------------------------------------------------------------
377: Procedure dt_update_validate
378: (p_eligy_prfl_id in number default hr_api.g_number,
379: p_datetrack_mode in varchar2,
380: p_validation_start_date in date,
381: p_validation_end_date in date) Is
382: --

Line 392: hr_api.mandatory_arg_error

388: hr_utility.set_location('Entering:'||l_proc, 5);
389: --
390: -- Ensure that the p_datetrack_mode argument is not null
391: --
392: hr_api.mandatory_arg_error
393: (p_api_name => l_proc,
394: p_argument => 'datetrack_mode',
395: p_argument_value => p_datetrack_mode);
396: --

Line 404: hr_api.mandatory_arg_error

400: --
401: --
402: -- Ensure the arguments are not null
403: --
404: hr_api.mandatory_arg_error
405: (p_api_name => l_proc,
406: p_argument => 'validation_start_date',
407: p_argument_value => p_validation_start_date);
408: --

Line 409: hr_api.mandatory_arg_error

405: (p_api_name => l_proc,
406: p_argument => 'validation_start_date',
407: p_argument_value => p_validation_start_date);
408: --
409: hr_api.mandatory_arg_error
410: (p_api_name => l_proc,
411: p_argument => 'validation_end_date',
412: p_argument_value => p_validation_end_date);
413: --

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

410: (p_api_name => l_proc,
411: p_argument => 'validation_end_date',
412: p_argument_value => p_validation_end_date);
413: --
414: If ((nvl(p_eligy_prfl_id, hr_api.g_number) <> hr_api.g_number) and
415: NOT (dt_api.check_min_max_dates
416: (p_base_table_name => 'ben_eligy_prfl_f',
417: p_base_key_column => 'eligy_prfl_id',
418: p_base_key_value => p_eligy_prfl_id,

Line 497: hr_api.mandatory_arg_error

493: hr_utility.set_location('Entering:'||l_proc, 5);
494: --
495: -- Ensure that the p_datetrack_mode argument is not null
496: --
497: hr_api.mandatory_arg_error
498: (p_api_name => l_proc,
499: p_argument => 'datetrack_mode',
500: p_argument_value => p_datetrack_mode);
501: --

Line 511: hr_api.mandatory_arg_error

507: --
508: --
509: -- Ensure the arguments are not null
510: --
511: hr_api.mandatory_arg_error
512: (p_api_name => l_proc,
513: p_argument => 'validation_start_date',
514: p_argument_value => p_validation_start_date);
515: --

Line 516: hr_api.mandatory_arg_error

512: (p_api_name => l_proc,
513: p_argument => 'validation_start_date',
514: p_argument_value => p_validation_start_date);
515: --
516: hr_api.mandatory_arg_error
517: (p_api_name => l_proc,
518: p_argument => 'validation_end_date',
519: p_argument_value => p_validation_end_date);
520: --

Line 521: hr_api.mandatory_arg_error

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

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

565: --
566: -- Call all supporting business operations
567: --
568: --
569: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
570: --
571: chk_elig_tbco_use_prte_id
572: (p_elig_tbco_use_prte_id => p_rec.elig_tbco_use_prte_id,
573: p_effective_date => p_effective_date,

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

618: --
619: -- Call all supporting business operations
620: --
621: --
622: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
623: --
624: chk_elig_tbco_use_prte_id
625: (p_elig_tbco_use_prte_id => p_rec.elig_tbco_use_prte_id,
626: p_effective_date => p_effective_date,

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

715: hr_utility.set_location('Entering:'|| l_proc, 10);
716: --
717: -- Ensure that all the mandatory parameter are not null
718: --
719: hr_api.mandatory_arg_error(p_api_name => l_proc,
720: p_argument => 'elig_tbco_use_prte_id',
721: p_argument_value => p_elig_tbco_use_prte_id);
722: --
723: open csr_leg_code;