APPS.BEN_PON_BUS dependencies on HR_API

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

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

Line 182: <> nvl(ben_pon_shd.g_old_rec.pl_typ_opt_typ_cd,hr_api.g_varchar2)

178: p_object_version_number => p_object_version_number);
179: --
180: if (l_api_updating
181: and p_pl_typ_opt_typ_cd
182: <> nvl(ben_pon_shd.g_old_rec.pl_typ_opt_typ_cd,hr_api.g_varchar2)
183: or not l_api_updating) then
184: --
185: -- check if value of lookup falls within lookup type.
186: --

Line 188: if hr_api.not_exists_in_hr_lookups

184: --
185: -- check if value of lookup falls within lookup type.
186: --
187: --
188: if hr_api.not_exists_in_hr_lookups
189: (p_lookup_type => 'BEN_OPT_TYP',
190: p_lookup_code => p_pl_typ_opt_typ_cd,
191: p_effective_date => p_effective_date) then
192: --

Line 238: (p_opt_id in number default hr_api.g_number,

234: --
235: -- {End Of Comments}
236: -- ----------------------------------------------------------------------------
237: Procedure dt_update_validate
238: (p_opt_id in number default hr_api.g_number,
239: p_pl_typ_id in number default hr_api.g_number,
240: p_datetrack_mode in varchar2,
241: p_validation_start_date in date,
242: p_validation_end_date in date) Is

Line 239: p_pl_typ_id in number default hr_api.g_number,

235: -- {End Of Comments}
236: -- ----------------------------------------------------------------------------
237: Procedure dt_update_validate
238: (p_opt_id in number default hr_api.g_number,
239: p_pl_typ_id in number default hr_api.g_number,
240: p_datetrack_mode in varchar2,
241: p_validation_start_date in date,
242: p_validation_end_date in date) Is
243: --

Line 253: hr_api.mandatory_arg_error

249: hr_utility.set_location('Entering:'||l_proc, 5);
250: --
251: -- Ensure that the p_datetrack_mode argument is not null
252: --
253: hr_api.mandatory_arg_error
254: (p_api_name => l_proc,
255: p_argument => 'datetrack_mode',
256: p_argument_value => p_datetrack_mode);
257: --

Line 265: hr_api.mandatory_arg_error

261: --
262: --
263: -- Ensure the arguments are not null
264: --
265: hr_api.mandatory_arg_error
266: (p_api_name => l_proc,
267: p_argument => 'validation_start_date',
268: p_argument_value => p_validation_start_date);
269: --

Line 270: hr_api.mandatory_arg_error

266: (p_api_name => l_proc,
267: p_argument => 'validation_start_date',
268: p_argument_value => p_validation_start_date);
269: --
270: hr_api.mandatory_arg_error
271: (p_api_name => l_proc,
272: p_argument => 'validation_end_date',
273: p_argument_value => p_validation_end_date);
274: --

Line 275: If ((nvl(p_opt_id, hr_api.g_number) <> hr_api.g_number) and

271: (p_api_name => l_proc,
272: p_argument => 'validation_end_date',
273: p_argument_value => p_validation_end_date);
274: --
275: If ((nvl(p_opt_id, hr_api.g_number) <> hr_api.g_number) and
276: NOT (dt_api.check_min_max_dates
277: (p_base_table_name => 'ben_opt_f',
278: p_base_key_column => 'opt_id',
279: p_base_key_value => p_opt_id,

Line 285: If ((nvl(p_pl_typ_id, hr_api.g_number) <> hr_api.g_number) and

281: p_to_date => p_validation_end_date))) Then
282: l_table_name := 'ben_opt_f';
283: Raise l_integrity_error;
284: End If;
285: If ((nvl(p_pl_typ_id, hr_api.g_number) <> hr_api.g_number) and
286: NOT (dt_api.check_min_max_dates
287: (p_base_table_name => 'ben_pl_typ_f',
288: p_base_key_column => 'pl_typ_id',
289: p_base_key_value => p_pl_typ_id,

Line 368: hr_api.mandatory_arg_error

364: hr_utility.set_location('Entering:'||l_proc, 5);
365: --
366: -- Ensure that the p_datetrack_mode argument is not null
367: --
368: hr_api.mandatory_arg_error
369: (p_api_name => l_proc,
370: p_argument => 'datetrack_mode',
371: p_argument_value => p_datetrack_mode);
372: --

Line 382: hr_api.mandatory_arg_error

378: --
379: --
380: -- Ensure the arguments are not null
381: --
382: hr_api.mandatory_arg_error
383: (p_api_name => l_proc,
384: p_argument => 'validation_start_date',
385: p_argument_value => p_validation_start_date);
386: --

Line 387: hr_api.mandatory_arg_error

383: (p_api_name => l_proc,
384: p_argument => 'validation_start_date',
385: p_argument_value => p_validation_start_date);
386: --
387: hr_api.mandatory_arg_error
388: (p_api_name => l_proc,
389: p_argument => 'validation_end_date',
390: p_argument_value => p_validation_end_date);
391: --

Line 392: hr_api.mandatory_arg_error

388: (p_api_name => l_proc,
389: p_argument => 'validation_end_date',
390: p_argument_value => p_validation_end_date);
391: --
392: hr_api.mandatory_arg_error
393: (p_api_name => l_proc,
394: p_argument => 'pl_typ_opt_typ_id',
395: p_argument_value => p_pl_typ_opt_typ_id);
396: --

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

454: -- Call all supporting business operations
455: --
456: --
457: if p_rec.business_group_id is not null and p_rec.legislation_code is null then
458: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
459: end if;
460:
461: --
462: chk_pl_typ_opt_typ_id

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

498: -- Call all supporting business operations
499: --
500: --
501: if p_rec.business_group_id is not null and p_rec.legislation_code is null then
502: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
503: end if;
504: --
505: chk_pl_typ_opt_typ_id
506: (p_pl_typ_opt_typ_id => p_rec.pl_typ_opt_typ_id,

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

586: hr_utility.set_location('Entering:'|| l_proc, 10);
587: --
588: -- Ensure that all the mandatory parameter are not null
589: --
590: hr_api.mandatory_arg_error(p_api_name => l_proc,
591: p_argument => 'pl_typ_opt_typ_id',
592: p_argument_value => p_pl_typ_opt_typ_id);
593: --
594: open csr_leg_code;