DBA Data[Home] [Help]

APPS.BEN_EDI_BUS dependencies on HR_API

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

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

Line 124: <> nvl(ben_edi_shd.g_old_rec.enrl_det_dt_cd,hr_api.g_varchar2)

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

Line 130: if hr_api.not_exists_in_hr_lookups

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

Line 196: <> nvl(ben_edi_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

192: p_object_version_number => p_object_version_number);
193: --
194: if (l_api_updating
195: and p_excld_flag
196: <> nvl(ben_edi_shd.g_old_rec.excld_flag,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 => 'YES_NO',
204: p_lookup_code => p_excld_flag,
205: p_effective_date => p_effective_date) then
206: --

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

307: --
308: -- {End Of Comments}
309: -- ----------------------------------------------------------------------------
310: Procedure dt_update_validate
311: (p_eligy_prfl_id in number default hr_api.g_number,
312: p_plip_id in number default hr_api.g_number,
313: p_datetrack_mode in varchar2,
314: p_validation_start_date in date,
315: p_validation_end_date in date) Is

Line 312: p_plip_id in number default hr_api.g_number,

308: -- {End Of Comments}
309: -- ----------------------------------------------------------------------------
310: Procedure dt_update_validate
311: (p_eligy_prfl_id in number default hr_api.g_number,
312: p_plip_id in number default hr_api.g_number,
313: p_datetrack_mode in varchar2,
314: p_validation_start_date in date,
315: p_validation_end_date in date) Is
316: --

Line 326: hr_api.mandatory_arg_error

322: hr_utility.set_location('Entering:'||l_proc, 5);
323: --
324: -- Ensure that the p_datetrack_mode argument is not null
325: --
326: hr_api.mandatory_arg_error
327: (p_api_name => l_proc,
328: p_argument => 'datetrack_mode',
329: p_argument_value => p_datetrack_mode);
330: --

Line 338: hr_api.mandatory_arg_error

334: --
335: --
336: -- Ensure the arguments are not null
337: --
338: hr_api.mandatory_arg_error
339: (p_api_name => l_proc,
340: p_argument => 'validation_start_date',
341: p_argument_value => p_validation_start_date);
342: --

Line 343: hr_api.mandatory_arg_error

339: (p_api_name => l_proc,
340: p_argument => 'validation_start_date',
341: p_argument_value => p_validation_start_date);
342: --
343: hr_api.mandatory_arg_error
344: (p_api_name => l_proc,
345: p_argument => 'validation_end_date',
346: p_argument_value => p_validation_end_date);
347: --

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

344: (p_api_name => l_proc,
345: p_argument => 'validation_end_date',
346: p_argument_value => p_validation_end_date);
347: --
348: If ((nvl(p_eligy_prfl_id, hr_api.g_number) <> hr_api.g_number) and
349: NOT (dt_api.check_min_max_dates
350: (p_base_table_name => 'ben_eligy_prfl_f',
351: p_base_key_column => 'eligy_prfl_id',
352: p_base_key_value => p_eligy_prfl_id,

Line 358: If ((nvl(p_plip_id, hr_api.g_number) <> hr_api.g_number) and

354: p_to_date => p_validation_end_date))) Then
355: l_table_name := 'ben_eligy_prfl_f';
356: Raise l_integrity_error;
357: End If;
358: If ((nvl(p_plip_id, hr_api.g_number) <> hr_api.g_number) and
359: NOT (dt_api.check_min_max_dates
360: (p_base_table_name => 'ben_plip_f',
361: p_base_key_column => 'plip_id',
362: p_base_key_value => p_plip_id,

Line 442: hr_api.mandatory_arg_error

438: hr_utility.set_location('Entering:'||l_proc, 5);
439: --
440: -- Ensure that the p_datetrack_mode argument is not null
441: --
442: hr_api.mandatory_arg_error
443: (p_api_name => l_proc,
444: p_argument => 'datetrack_mode',
445: p_argument_value => p_datetrack_mode);
446: --

Line 456: hr_api.mandatory_arg_error

452: --
453: --
454: -- Ensure the arguments are not null
455: --
456: hr_api.mandatory_arg_error
457: (p_api_name => l_proc,
458: p_argument => 'validation_start_date',
459: p_argument_value => p_validation_start_date);
460: --

Line 461: hr_api.mandatory_arg_error

457: (p_api_name => l_proc,
458: p_argument => 'validation_start_date',
459: p_argument_value => p_validation_start_date);
460: --
461: hr_api.mandatory_arg_error
462: (p_api_name => l_proc,
463: p_argument => 'validation_end_date',
464: p_argument_value => p_validation_end_date);
465: --

Line 466: hr_api.mandatory_arg_error

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

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

532: ,p_eligy_prfl_id => p_rec.eligy_prfl_id
533: ,p_ordr_num => p_rec.ordr_num
534: ,p_business_group_id => p_rec.business_group_id);
535: --
536: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
537: --
538: hr_utility.set_location(' Leaving:'||l_proc, 10);
539: End insert_validate;
540: --

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

577: ,p_eligy_prfl_id => p_rec.eligy_prfl_id
578: ,p_ordr_num => p_rec.ordr_num
579: ,p_business_group_id => p_rec.business_group_id);
580: --
581: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
582: --
583: -- Call the datetrack update integrity operation
584: --
585: dt_update_validate

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

645: hr_utility.set_location('Entering:'|| l_proc, 10);
646: --
647: -- Ensure that all the mandatory parameter are not null
648: --
649: hr_api.mandatory_arg_error(p_api_name => l_proc,
650: p_argument => 'elig_dpnt_cvrd_plip_id',
651: p_argument_value => p_elig_dpnt_cvrd_plip_id);
652: --
653: open csr_leg_code;