DBA Data[Home] [Help]

APPS.BEN_PEA_BUS dependencies on HR_API

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

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

Line 129: and nvl(p_actn_typ_id,hr_api.g_number)

125: p_effective_date => p_effective_date,
126: p_object_version_number => p_object_version_number);
127: --
128: if (l_api_updating
129: and nvl(p_actn_typ_id,hr_api.g_number)
130: <> nvl(ben_pea_shd.g_old_rec.actn_typ_id,hr_api.g_number)
131: or not l_api_updating) then
132: --
133: -- check if actn_typ_id value exists in ben_actn_typ table

Line 130: <> nvl(ben_pea_shd.g_old_rec.actn_typ_id,hr_api.g_number)

126: p_object_version_number => p_object_version_number);
127: --
128: if (l_api_updating
129: and nvl(p_actn_typ_id,hr_api.g_number)
130: <> nvl(ben_pea_shd.g_old_rec.actn_typ_id,hr_api.g_number)
131: or not l_api_updating) then
132: --
133: -- check if actn_typ_id value exists in ben_actn_typ table
134: --

Line 187: (p_prtt_enrt_rslt_id in number default hr_api.g_number,

183: --
184: -- {End Of Comments}
185: -- ----------------------------------------------------------------------------
186: Procedure dt_update_validate
187: (p_prtt_enrt_rslt_id in number default hr_api.g_number,
188: p_datetrack_mode in varchar2,
189: p_validation_start_date in date,
190: p_validation_end_date in date) Is
191: --

Line 201: hr_api.mandatory_arg_error

197: hr_utility.set_location('Entering:'||l_proc, 5);
198: --
199: -- Ensure that the p_datetrack_mode argument is not null
200: --
201: hr_api.mandatory_arg_error
202: (p_api_name => l_proc,
203: p_argument => 'datetrack_mode',
204: p_argument_value => p_datetrack_mode);
205: --

Line 213: hr_api.mandatory_arg_error

209: --
210: --
211: -- Ensure the arguments are not null
212: --
213: hr_api.mandatory_arg_error
214: (p_api_name => l_proc,
215: p_argument => 'validation_start_date',
216: p_argument_value => p_validation_start_date);
217: --

Line 218: hr_api.mandatory_arg_error

214: (p_api_name => l_proc,
215: p_argument => 'validation_start_date',
216: p_argument_value => p_validation_start_date);
217: --
218: hr_api.mandatory_arg_error
219: (p_api_name => l_proc,
220: p_argument => 'validation_end_date',
221: p_argument_value => p_validation_end_date);
222: --

Line 223: If ((nvl(p_prtt_enrt_rslt_id, hr_api.g_number) <> hr_api.g_number) and

219: (p_api_name => l_proc,
220: p_argument => 'validation_end_date',
221: p_argument_value => p_validation_end_date);
222: --
223: If ((nvl(p_prtt_enrt_rslt_id, hr_api.g_number) <> hr_api.g_number) and
224: NOT (dt_api.check_min_max_dates
225: (p_base_table_name => 'ben_prtt_enrt_rslt_f',
226: p_base_key_column => 'prtt_enrt_rslt_id',
227: p_base_key_value => p_prtt_enrt_rslt_id,

Line 307: hr_api.mandatory_arg_error

303: hr_utility.set_location('Entering:'||l_proc, 5);
304: --
305: -- Ensure that the p_datetrack_mode argument is not null
306: --
307: hr_api.mandatory_arg_error
308: (p_api_name => l_proc,
309: p_argument => 'datetrack_mode',
310: p_argument_value => p_datetrack_mode);
311: --

Line 321: hr_api.mandatory_arg_error

317: --
318: --
319: -- Ensure the arguments are not null
320: --
321: hr_api.mandatory_arg_error
322: (p_api_name => l_proc,
323: p_argument => 'validation_start_date',
324: p_argument_value => p_validation_start_date);
325: --

Line 326: hr_api.mandatory_arg_error

322: (p_api_name => l_proc,
323: p_argument => 'validation_start_date',
324: p_argument_value => p_validation_start_date);
325: --
326: hr_api.mandatory_arg_error
327: (p_api_name => l_proc,
328: p_argument => 'validation_end_date',
329: p_argument_value => p_validation_end_date);
330: --

Line 331: hr_api.mandatory_arg_error

327: (p_api_name => l_proc,
328: p_argument => 'validation_end_date',
329: p_argument_value => p_validation_end_date);
330: --
331: hr_api.mandatory_arg_error
332: (p_api_name => l_proc,
333: p_argument => 'prtt_enrt_actn_id',
334: p_argument_value => p_prtt_enrt_actn_id);
335: --

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

401: --
402: -- Call all supporting business operations
403: --
404: --
405: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
406: --
407: chk_prtt_enrt_actn_id
408: (p_prtt_enrt_actn_id => p_rec.prtt_enrt_actn_id,
409: p_effective_date => p_effective_date,

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

435: --
436: -- Call all supporting business operations
437: --
438: --
439: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
440: --
441: chk_prtt_enrt_actn_id
442: (p_prtt_enrt_actn_id => p_rec.prtt_enrt_actn_id,
443: p_effective_date => p_effective_date,

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

513: hr_utility.set_location('Entering:'|| l_proc, 10);
514: --
515: -- Ensure that all the mandatory parameter are not null
516: --
517: hr_api.mandatory_arg_error(p_api_name => l_proc,
518: p_argument => 'prtt_enrt_actn_id',
519: p_argument_value => p_prtt_enrt_actn_id);
520: --
521: open csr_leg_code;