DBA Data[Home] [Help]

APPS.BEN_ECY_BUS dependencies on HR_API

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

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

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

122: Begin
123: --
124: hr_utility.set_location('Entering:'||l_proc,5);
125: --
126: hr_api.mandatory_arg_error(p_api_name => l_proc,
127: p_argument => 'competence_id',
128: p_argument_value => p_competence_id);
129:
130: l_api_updating := ben_ecy_shd.api_updating

Line 136: and nvl(p_competence_id,hr_api.g_number)

132: p_effective_date => p_effective_date,
133: p_object_version_number => p_object_version_number);
134: --
135: if (l_api_updating
136: and nvl(p_competence_id,hr_api.g_number)
137: <> nvl(ben_ecy_shd.g_old_rec.competence_id,hr_api.g_number)
138: or not l_api_updating)
139: and p_competence_id is not null then
140: --

Line 137: <> nvl(ben_ecy_shd.g_old_rec.competence_id,hr_api.g_number)

133: p_object_version_number => p_object_version_number);
134: --
135: if (l_api_updating
136: and nvl(p_competence_id,hr_api.g_number)
137: <> nvl(ben_ecy_shd.g_old_rec.competence_id,hr_api.g_number)
138: or not l_api_updating)
139: and p_competence_id is not null then
140: --
141: -- check if competence_id value exists in

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

220: Begin
221: --
222: hr_utility.set_location('Entering:'||l_proc,5);
223: --
224: hr_api.mandatory_arg_error(p_api_name => l_proc,
225: p_argument => 'rating_level_id',
226: p_argument_value => p_rating_level_id);
227:
228: l_api_updating := ben_ecy_shd.api_updating

Line 234: and nvl(p_rating_level_id,hr_api.g_number)

230: p_effective_date => p_effective_date,
231: p_object_version_number => p_object_version_number);
232: --
233: if (l_api_updating
234: and nvl(p_rating_level_id,hr_api.g_number)
235: <> nvl(ben_ecy_shd.g_old_rec.rating_level_id,hr_api.g_number)
236: or not l_api_updating)
237: and p_rating_level_id is not null then
238: --

Line 235: <> nvl(ben_ecy_shd.g_old_rec.rating_level_id,hr_api.g_number)

231: p_object_version_number => p_object_version_number);
232: --
233: if (l_api_updating
234: and nvl(p_rating_level_id,hr_api.g_number)
235: <> nvl(ben_ecy_shd.g_old_rec.rating_level_id,hr_api.g_number)
236: or not l_api_updating)
237: and p_rating_level_id is not null then
238: --
239: -- check if rating_level_id value exists in

Line 309: <> nvl(ben_ecy_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

305: p_object_version_number => p_object_version_number);
306: --
307: if (l_api_updating
308: and p_excld_flag
309: <> nvl(ben_ecy_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
310: or not l_api_updating) then
311: --
312: -- check if value of lookup falls within lookup type.
313: --

Line 315: if hr_api.not_exists_in_hr_lookups

311: --
312: -- check if value of lookup falls within lookup type.
313: --
314: --
315: if hr_api.not_exists_in_hr_lookups
316: (p_lookup_type => 'YES_NO',
317: p_lookup_code => p_excld_flag,
318: p_effective_date => p_effective_date) then
319: --

Line 422: p_eligy_prfl_id in number default hr_api.g_number,

418: -- {End Of Comments}
419: -- ----------------------------------------------------------------------------
420: Procedure dt_update_validate
421: (
422: p_eligy_prfl_id in number default hr_api.g_number,
423: p_datetrack_mode in varchar2,
424: p_validation_start_date in date,
425: p_validation_end_date in date) Is
426: --

Line 436: hr_api.mandatory_arg_error

432: hr_utility.set_location('Entering:'||l_proc, 5);
433: --
434: -- Ensure that the p_datetrack_mode argument is not null
435: --
436: hr_api.mandatory_arg_error
437: (p_api_name => l_proc,
438: p_argument => 'datetrack_mode',
439: p_argument_value => p_datetrack_mode);
440: --

Line 448: hr_api.mandatory_arg_error

444: --
445: --
446: -- Ensure the arguments are not null
447: --
448: hr_api.mandatory_arg_error
449: (p_api_name => l_proc,
450: p_argument => 'validation_start_date',
451: p_argument_value => p_validation_start_date);
452: --

Line 453: hr_api.mandatory_arg_error

449: (p_api_name => l_proc,
450: p_argument => 'validation_start_date',
451: p_argument_value => p_validation_start_date);
452: --
453: hr_api.mandatory_arg_error
454: (p_api_name => l_proc,
455: p_argument => 'validation_end_date',
456: p_argument_value => p_validation_end_date);
457: --

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

454: (p_api_name => l_proc,
455: p_argument => 'validation_end_date',
456: p_argument_value => p_validation_end_date);
457: --
458: If ((nvl(p_eligy_prfl_id, hr_api.g_number) <> hr_api.g_number) and
459: NOT (dt_api.check_min_max_dates
460: (p_base_table_name => 'ben_eligy_prfl_f',
461: p_base_key_column => 'eligy_prfl_id',
462: p_base_key_value => p_eligy_prfl_id,

Line 540: hr_api.mandatory_arg_error

536: hr_utility.set_location('Entering:'||l_proc, 5);
537: --
538: -- Ensure that the p_datetrack_mode argument is not null
539: --
540: hr_api.mandatory_arg_error
541: (p_api_name => l_proc,
542: p_argument => 'datetrack_mode',
543: p_argument_value => p_datetrack_mode);
544: --

Line 554: hr_api.mandatory_arg_error

550: --
551: --
552: -- Ensure the arguments are not null
553: --
554: hr_api.mandatory_arg_error
555: (p_api_name => l_proc,
556: p_argument => 'validation_start_date',
557: p_argument_value => p_validation_start_date);
558: --

Line 559: hr_api.mandatory_arg_error

555: (p_api_name => l_proc,
556: p_argument => 'validation_start_date',
557: p_argument_value => p_validation_start_date);
558: --
559: hr_api.mandatory_arg_error
560: (p_api_name => l_proc,
561: p_argument => 'validation_end_date',
562: p_argument_value => p_validation_end_date);
563: --

Line 564: hr_api.mandatory_arg_error

560: (p_api_name => l_proc,
561: p_argument => 'validation_end_date',
562: p_argument_value => p_validation_end_date);
563: --
564: hr_api.mandatory_arg_error
565: (p_api_name => l_proc,
566: p_argument => 'ELIG_COMPTNCY_PRTE_id',
567: p_argument_value => p_ELIG_COMPTNCY_PRTE_id);
568: --

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

637: p_eligy_prfl_id => p_rec.eligy_prfl_id,
638: p_ordr_num => p_rec.ordr_num,
639: p_business_group_id => p_rec.business_group_id);
640: --
641: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
642: --
643: hr_utility.set_location(' Leaving:'||l_proc, 10);
644: End insert_validate;
645: --

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

691: p_eligy_prfl_id => p_rec.eligy_prfl_id,
692: p_ordr_num => p_rec.ordr_num,
693: p_business_group_id => p_rec.business_group_id);
694: --
695: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
696: --
697: -- Call the datetrack update integrity operation
698: --
699: dt_update_validate

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

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