DBA Data[Home] [Help]

APPS.BEN_EAI_BUS dependencies on HR_API

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

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

Line 124: <> nvl(ben_eai_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_eai_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 195: <> nvl(ben_eai_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

191: p_object_version_number => p_object_version_number);
192: --
193: if (l_api_updating
194: and p_excld_flag
195: <> nvl(ben_eai_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
196: or not l_api_updating) then
197: --
198: -- check if value of lookup falls within lookup type.
199: --

Line 201: if hr_api.not_exists_in_hr_lookups

197: --
198: -- check if value of lookup falls within lookup type.
199: --
200: --
201: if hr_api.not_exists_in_hr_lookups
202: (p_lookup_type => 'YES_NO',
203: p_lookup_code => p_excld_flag,
204: p_effective_date => p_effective_date) then
205: --

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

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

Line 310: p_plip_id in number default hr_api.g_number,

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

Line 324: hr_api.mandatory_arg_error

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

Line 336: hr_api.mandatory_arg_error

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

Line 341: hr_api.mandatory_arg_error

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

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

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

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

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

Line 439: hr_api.mandatory_arg_error

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

Line 453: hr_api.mandatory_arg_error

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

Line 458: hr_api.mandatory_arg_error

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

Line 463: hr_api.mandatory_arg_error

459: (p_api_name => l_proc,
460: p_argument => 'validation_end_date',
461: p_argument_value => p_validation_end_date);
462: --
463: hr_api.mandatory_arg_error
464: (p_api_name => l_proc,
465: p_argument => 'elig_enrld_anthr_plip_id',
466: p_argument_value => p_elig_enrld_anthr_plip_id);
467: --

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

507: --
508: -- Call all supporting business operations
509: --
510: --
511: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
512: --
513: chk_elig_enrld_anthr_plip_id
514: (p_elig_enrld_anthr_plip_id => p_rec.elig_enrld_anthr_plip_id,
515: p_effective_date => p_effective_date,

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

553: --
554: -- Call all supporting business operations
555: --
556: --
557: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
558: --
559: chk_elig_enrld_anthr_plip_id
560: (p_elig_enrld_anthr_plip_id => p_rec.elig_enrld_anthr_plip_id,
561: p_effective_date => p_effective_date,

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

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