DBA Data[Home] [Help]

APPS.BEN_ELU_BUS dependencies on HR_API

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

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

Line 123: and elig_lbr_mmbr_prte_id <> nvl(p_elig_lbr_mmbr_prte_id,hr_api.g_number)

119: select null
120: from ben_elig_lbr_mmbr_prte_f
121: where lbr_mmbr_flag = p_lbr_mmbr_flag
122: and eligy_prfl_id = p_eligy_prfl_id
123: and elig_lbr_mmbr_prte_id <> nvl(p_elig_lbr_mmbr_prte_id,hr_api.g_number)
124: and business_group_id + 0 = p_business_group_id
125: and p_validation_start_date <= effective_end_date
126: and p_validation_end_date >= effective_start_date
127: ;

Line 141: <> nvl(ben_elu_shd.g_old_rec.lbr_mmbr_flag,hr_api.g_varchar2)

137: p_object_version_number => p_object_version_number);
138: --
139: if (l_api_updating
140: and p_lbr_mmbr_flag
141: <> nvl(ben_elu_shd.g_old_rec.lbr_mmbr_flag,hr_api.g_varchar2)
142: or not l_api_updating) then
143: --
144: -- check if value of lookup falls within lookup type.
145: --

Line 147: if hr_api.not_exists_in_hr_lookups

143: --
144: -- check if value of lookup falls within lookup type.
145: --
146: --
147: if hr_api.not_exists_in_hr_lookups
148: (p_lookup_type => 'YES_NO',
149: p_lookup_code => p_lbr_mmbr_flag,
150: p_effective_date => p_effective_date) then
151: --

Line 224: <> nvl(ben_elu_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

220: p_object_version_number => p_object_version_number);
221: --
222: if (l_api_updating
223: and p_excld_flag
224: <> nvl(ben_elu_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
225: or not l_api_updating) then
226: --
227: -- check if value of lookup falls within lookup type.
228: --

Line 230: if hr_api.not_exists_in_hr_lookups

226: --
227: -- check if value of lookup falls within lookup type.
228: --
229: --
230: if hr_api.not_exists_in_hr_lookups
231: (p_lookup_type => 'YES_NO',
232: p_lookup_code => p_excld_flag,
233: p_effective_date => p_effective_date) then
234: --

Line 350: hr_api.mandatory_arg_error

346: hr_utility.set_location('Entering:'||l_proc, 5);
347: --
348: -- Ensure that the p_datetrack_mode argument is not null
349: --
350: hr_api.mandatory_arg_error
351: (p_api_name => l_proc,
352: p_argument => 'datetrack_mode',
353: p_argument_value => p_datetrack_mode);
354: --

Line 362: hr_api.mandatory_arg_error

358: --
359: --
360: -- Ensure the arguments are not null
361: --
362: hr_api.mandatory_arg_error
363: (p_api_name => l_proc,
364: p_argument => 'validation_start_date',
365: p_argument_value => p_validation_start_date);
366: --

Line 367: hr_api.mandatory_arg_error

363: (p_api_name => l_proc,
364: p_argument => 'validation_start_date',
365: p_argument_value => p_validation_start_date);
366: --
367: hr_api.mandatory_arg_error
368: (p_api_name => l_proc,
369: p_argument => 'validation_end_date',
370: p_argument_value => p_validation_end_date);
371: --

Line 447: hr_api.mandatory_arg_error

443: hr_utility.set_location('Entering:'||l_proc, 5);
444: --
445: -- Ensure that the p_datetrack_mode argument is not null
446: --
447: hr_api.mandatory_arg_error
448: (p_api_name => l_proc,
449: p_argument => 'datetrack_mode',
450: p_argument_value => p_datetrack_mode);
451: --

Line 461: hr_api.mandatory_arg_error

457: --
458: --
459: -- Ensure the arguments are not null
460: --
461: hr_api.mandatory_arg_error
462: (p_api_name => l_proc,
463: p_argument => 'validation_start_date',
464: p_argument_value => p_validation_start_date);
465: --

Line 466: hr_api.mandatory_arg_error

462: (p_api_name => l_proc,
463: p_argument => 'validation_start_date',
464: p_argument_value => p_validation_start_date);
465: --
466: hr_api.mandatory_arg_error
467: (p_api_name => l_proc,
468: p_argument => 'validation_end_date',
469: p_argument_value => p_validation_end_date);
470: --

Line 471: hr_api.mandatory_arg_error

467: (p_api_name => l_proc,
468: p_argument => 'validation_end_date',
469: p_argument_value => p_validation_end_date);
470: --
471: hr_api.mandatory_arg_error
472: (p_api_name => l_proc,
473: p_argument => 'elig_lbr_mmbr_prte_id',
474: p_argument_value => p_elig_lbr_mmbr_prte_id);
475: --

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

515: --
516: -- Call all supporting business operations
517: --
518: --
519: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
520: --
521: chk_elig_lbr_mmbr_prte_id
522: (p_elig_lbr_mmbr_prte_id => p_rec.elig_lbr_mmbr_prte_id,
523: p_effective_date => p_effective_date,

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_lbr_mmbr_prte_id
572: (p_elig_lbr_mmbr_prte_id => p_rec.elig_lbr_mmbr_prte_id,
573: p_effective_date => p_effective_date,

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

659: hr_utility.set_location('Entering:'|| l_proc, 10);
660: --
661: -- Ensure that all the mandatory parameter are not null
662: --
663: hr_api.mandatory_arg_error(p_api_name => l_proc,
664: p_argument => 'elig_lbr_mmbr_prte_id',
665: p_argument_value => p_elig_lbr_mmbr_prte_id);
666: --
667: open csr_leg_code;