DBA Data[Home] [Help]

APPS.BEN_PCM_BUS dependencies on HR_API

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

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

Line 210: (p_cm_typ_id in number default hr_api.g_number,

206: --
207: -- {End Of Comments}
208: -- ----------------------------------------------------------------------------
209: Procedure dt_update_validate
210: (p_cm_typ_id in number default hr_api.g_number,
211: p_prtt_enrt_actn_id in number default hr_api.g_number,
212: p_datetrack_mode in varchar2,
213: p_validation_start_date in date,
214: p_validation_end_date in date) Is

Line 211: p_prtt_enrt_actn_id in number default hr_api.g_number,

207: -- {End Of Comments}
208: -- ----------------------------------------------------------------------------
209: Procedure dt_update_validate
210: (p_cm_typ_id in number default hr_api.g_number,
211: p_prtt_enrt_actn_id in number default hr_api.g_number,
212: p_datetrack_mode in varchar2,
213: p_validation_start_date in date,
214: p_validation_end_date in date) Is
215: --

Line 225: hr_api.mandatory_arg_error

221: hr_utility.set_location('Entering:'||l_proc, 5);
222: --
223: -- Ensure that the p_datetrack_mode argument is not null
224: --
225: hr_api.mandatory_arg_error
226: (p_api_name => l_proc,
227: p_argument => 'datetrack_mode',
228: p_argument_value => p_datetrack_mode);
229: --

Line 237: hr_api.mandatory_arg_error

233: --
234: --
235: -- Ensure the arguments are not null
236: --
237: hr_api.mandatory_arg_error
238: (p_api_name => l_proc,
239: p_argument => 'validation_start_date',
240: p_argument_value => p_validation_start_date);
241: --

Line 242: hr_api.mandatory_arg_error

238: (p_api_name => l_proc,
239: p_argument => 'validation_start_date',
240: p_argument_value => p_validation_start_date);
241: --
242: hr_api.mandatory_arg_error
243: (p_api_name => l_proc,
244: p_argument => 'validation_end_date',
245: p_argument_value => p_validation_end_date);
246: --

Line 247: If ((nvl(p_cm_typ_id, hr_api.g_number) <> hr_api.g_number) and

243: (p_api_name => l_proc,
244: p_argument => 'validation_end_date',
245: p_argument_value => p_validation_end_date);
246: --
247: If ((nvl(p_cm_typ_id, hr_api.g_number) <> hr_api.g_number) and
248: NOT (dt_api.check_min_max_dates
249: (p_base_table_name => 'ben_cm_typ_f',
250: p_base_key_column => 'cm_typ_id',
251: p_base_key_value => p_cm_typ_id,

Line 257: If ((nvl(p_prtt_enrt_actn_id, hr_api.g_number) <> hr_api.g_number) and

253: p_to_date => p_validation_end_date))) Then
254: l_table_name := 'ben_cm_typ_f';
255: Raise l_integrity_error;
256: End If;
257: If ((nvl(p_prtt_enrt_actn_id, hr_api.g_number) <> hr_api.g_number) and
258: NOT (dt_api.check_min_max_dates
259: (p_base_table_name => 'ben_prtt_enrt_actn_f',
260: p_base_key_column => 'prtt_enrt_actn_id',
261: p_base_key_value => p_prtt_enrt_actn_id,

Line 340: hr_api.mandatory_arg_error

336: hr_utility.set_location('Entering:'||l_proc, 5);
337: --
338: -- Ensure that the p_datetrack_mode argument is not null
339: --
340: hr_api.mandatory_arg_error
341: (p_api_name => l_proc,
342: p_argument => 'datetrack_mode',
343: p_argument_value => p_datetrack_mode);
344: --

Line 354: hr_api.mandatory_arg_error

350: --
351: --
352: -- Ensure the arguments are not null
353: --
354: hr_api.mandatory_arg_error
355: (p_api_name => l_proc,
356: p_argument => 'validation_start_date',
357: p_argument_value => p_validation_start_date);
358: --

Line 359: hr_api.mandatory_arg_error

355: (p_api_name => l_proc,
356: p_argument => 'validation_start_date',
357: p_argument_value => p_validation_start_date);
358: --
359: hr_api.mandatory_arg_error
360: (p_api_name => l_proc,
361: p_argument => 'validation_end_date',
362: p_argument_value => p_validation_end_date);
363: --

Line 364: hr_api.mandatory_arg_error

360: (p_api_name => l_proc,
361: p_argument => 'validation_end_date',
362: p_argument_value => p_validation_end_date);
363: --
364: hr_api.mandatory_arg_error
365: (p_api_name => l_proc,
366: p_argument => 'per_cm_id',
367: p_argument_value => p_per_cm_id);
368: --

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

433: --
434: -- Call all supporting business operations
435: --
436: --
437: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
438: --
439: chk_per_cm_id
440: (p_per_cm_id => p_rec.per_cm_id,
441: p_effective_date => p_effective_date,

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

467: --
468: -- Call all supporting business operations
469: --
470: --
471: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
472: --
473: chk_per_cm_id
474: (p_per_cm_id => p_rec.per_cm_id,
475: p_effective_date => p_effective_date,

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

540: hr_utility.set_location('Entering:'|| l_proc, 10);
541: --
542: -- Ensure that all the mandatory parameter are not null
543: --
544: hr_api.mandatory_arg_error(p_api_name => l_proc,
545: p_argument => 'per_cm_id',
546: p_argument_value => p_per_cm_id);
547: --
548: open csr_leg_code;