DBA Data[Home] [Help]

APPS.BEN_PET_BUS dependencies on HR_API

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

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

Line 126: and popl_enrt_typ_cycl_id <> nvl(p_popl_enrt_typ_cycl_id, hr_api.g_number)

122: cursor chk_unique is
123: select null
124: from ben_popl_enrt_typ_cycl_f
125: where enrt_typ_cycl_cd = p_enrt_typ_cycl_cd
126: and popl_enrt_typ_cycl_id <> nvl(p_popl_enrt_typ_cycl_id, hr_api.g_number)
127: and (pgm_id = p_pgm_id or pl_id = p_pl_id)
128: and business_group_id + 0 = p_business_group_id
129: and p_validation_start_date <= effective_end_date
130: and p_validation_end_date >= effective_start_date;

Line 143: <> nvl(ben_pet_shd.g_old_rec.enrt_typ_cycl_cd,hr_api.g_varchar2)

139: p_object_version_number => p_object_version_number);
140: --
141: if (l_api_updating
142: and p_enrt_typ_cycl_cd
143: <> nvl(ben_pet_shd.g_old_rec.enrt_typ_cycl_cd,hr_api.g_varchar2)
144: or not l_api_updating) then
145: --
146: -- check if value of lookup falls within lookup type.
147: --

Line 149: if hr_api.not_exists_in_hr_lookups

145: --
146: -- check if value of lookup falls within lookup type.
147: --
148: --
149: if hr_api.not_exists_in_hr_lookups
150: (p_lookup_type => 'BEN_ENRT_TYP_CYCL',
151: p_lookup_code => p_enrt_typ_cycl_cd,
152: p_effective_date => p_effective_date) then
153: --

Line 277: (p_pl_id in number default hr_api.g_number,

273: --
274: -- {End Of Comments}
275: -- ----------------------------------------------------------------------------
276: Procedure dt_update_validate
277: (p_pl_id in number default hr_api.g_number,
278: p_pgm_id in number default hr_api.g_number,
279: p_datetrack_mode in varchar2,
280: p_validation_start_date in date,
281: p_validation_end_date in date) Is

Line 278: p_pgm_id in number default hr_api.g_number,

274: -- {End Of Comments}
275: -- ----------------------------------------------------------------------------
276: Procedure dt_update_validate
277: (p_pl_id in number default hr_api.g_number,
278: p_pgm_id in number default hr_api.g_number,
279: p_datetrack_mode in varchar2,
280: p_validation_start_date in date,
281: p_validation_end_date in date) Is
282: --

Line 292: hr_api.mandatory_arg_error

288: hr_utility.set_location('Entering:'||l_proc, 5);
289: --
290: -- Ensure that the p_datetrack_mode argument is not null
291: --
292: hr_api.mandatory_arg_error
293: (p_api_name => l_proc,
294: p_argument => 'datetrack_mode',
295: p_argument_value => p_datetrack_mode);
296: --

Line 304: hr_api.mandatory_arg_error

300: --
301: --
302: -- Ensure the arguments are not null
303: --
304: hr_api.mandatory_arg_error
305: (p_api_name => l_proc,
306: p_argument => 'validation_start_date',
307: p_argument_value => p_validation_start_date);
308: --

Line 309: hr_api.mandatory_arg_error

305: (p_api_name => l_proc,
306: p_argument => 'validation_start_date',
307: p_argument_value => p_validation_start_date);
308: --
309: hr_api.mandatory_arg_error
310: (p_api_name => l_proc,
311: p_argument => 'validation_end_date',
312: p_argument_value => p_validation_end_date);
313: --

Line 314: If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and

310: (p_api_name => l_proc,
311: p_argument => 'validation_end_date',
312: p_argument_value => p_validation_end_date);
313: --
314: If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and
315: NOT (dt_api.check_min_max_dates
316: (p_base_table_name => 'ben_pl_f',
317: p_base_key_column => 'pl_id',
318: p_base_key_value => p_pl_id,

Line 324: If ((nvl(p_pgm_id, hr_api.g_number) <> hr_api.g_number) and

320: p_to_date => p_validation_end_date))) Then
321: l_table_name := 'ben_pl_f';
322: Raise l_integrity_error;
323: End If;
324: If ((nvl(p_pgm_id, hr_api.g_number) <> hr_api.g_number) and
325: NOT (dt_api.check_min_max_dates
326: (p_base_table_name => 'ben_pgm_f',
327: p_base_key_column => 'pgm_id',
328: p_base_key_value => p_pgm_id,

Line 406: hr_api.mandatory_arg_error

402: hr_utility.set_location('Entering:'||l_proc, 5);
403: --
404: -- Ensure that the p_datetrack_mode argument is not null
405: --
406: hr_api.mandatory_arg_error
407: (p_api_name => l_proc,
408: p_argument => 'datetrack_mode',
409: p_argument_value => p_datetrack_mode);
410: --

Line 420: hr_api.mandatory_arg_error

416: --
417: --
418: -- Ensure the arguments are not null
419: --
420: hr_api.mandatory_arg_error
421: (p_api_name => l_proc,
422: p_argument => 'validation_start_date',
423: p_argument_value => p_validation_start_date);
424: --

Line 425: hr_api.mandatory_arg_error

421: (p_api_name => l_proc,
422: p_argument => 'validation_start_date',
423: p_argument_value => p_validation_start_date);
424: --
425: hr_api.mandatory_arg_error
426: (p_api_name => l_proc,
427: p_argument => 'validation_end_date',
428: p_argument_value => p_validation_end_date);
429: --

Line 430: hr_api.mandatory_arg_error

426: (p_api_name => l_proc,
427: p_argument => 'validation_end_date',
428: p_argument_value => p_validation_end_date);
429: --
430: hr_api.mandatory_arg_error
431: (p_api_name => l_proc,
432: p_argument => 'popl_enrt_typ_cycl_id',
433: p_argument_value => p_popl_enrt_typ_cycl_id);
434: --

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

484: --
485: -- Call all supporting business operations
486: --
487: --
488: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
489: --
490: chk_popl_enrt_typ_cycl_id
491: (p_popl_enrt_typ_cycl_id => p_rec.popl_enrt_typ_cycl_id,
492: p_effective_date => p_effective_date,

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

523: --
524: -- Call all supporting business operations
525: --
526: --
527: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
528: --
529: chk_popl_enrt_typ_cycl_id
530: (p_popl_enrt_typ_cycl_id => p_rec.popl_enrt_typ_cycl_id,
531: p_effective_date => p_effective_date,

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

607: hr_utility.set_location('Entering:'|| l_proc, 10);
608: --
609: -- Ensure that all the mandatory parameter are not null
610: --
611: hr_api.mandatory_arg_error(p_api_name => l_proc,
612: p_argument => 'popl_enrt_typ_cycl_id',
613: p_argument_value => p_popl_enrt_typ_cycl_id);
614: --
615: open csr_leg_code;