DBA Data[Home] [Help]

APPS.BEN_LNR_BUS dependencies on HR_API

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

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

Line 140: and nvl(p_formula_id,hr_api.g_number)

136: p_effective_date => p_effective_date,
137: p_object_version_number => p_object_version_number);
138: --
139: if (l_api_updating
140: and nvl(p_formula_id,hr_api.g_number)
141: <> ben_lnr_shd.g_old_rec.formula_id
142: or not l_api_updating)
143: and p_formula_id is not null then
144: --

Line 203: (p_ler_chg_pl_nip_enrt_id in number default hr_api.g_number,

199: --
200: -- {End Of Comments}
201: -- ----------------------------------------------------------------------------
202: Procedure dt_update_validate
203: (p_ler_chg_pl_nip_enrt_id in number default hr_api.g_number,
204: p_datetrack_mode in varchar2,
205: p_validation_start_date in date,
206: p_validation_end_date in date) Is
207: --

Line 217: hr_api.mandatory_arg_error

213: hr_utility.set_location('Entering:'||l_proc, 5);
214: --
215: -- Ensure that the p_datetrack_mode argument is not null
216: --
217: hr_api.mandatory_arg_error
218: (p_api_name => l_proc,
219: p_argument => 'datetrack_mode',
220: p_argument_value => p_datetrack_mode);
221: --

Line 229: hr_api.mandatory_arg_error

225: --
226: --
227: -- Ensure the arguments are not null
228: --
229: hr_api.mandatory_arg_error
230: (p_api_name => l_proc,
231: p_argument => 'validation_start_date',
232: p_argument_value => p_validation_start_date);
233: --

Line 234: hr_api.mandatory_arg_error

230: (p_api_name => l_proc,
231: p_argument => 'validation_start_date',
232: p_argument_value => p_validation_start_date);
233: --
234: hr_api.mandatory_arg_error
235: (p_api_name => l_proc,
236: p_argument => 'validation_end_date',
237: p_argument_value => p_validation_end_date);
238: --

Line 239: If ((nvl(p_ler_chg_pl_nip_enrt_id, hr_api.g_number) <> hr_api.g_number) and

235: (p_api_name => l_proc,
236: p_argument => 'validation_end_date',
237: p_argument_value => p_validation_end_date);
238: --
239: If ((nvl(p_ler_chg_pl_nip_enrt_id, hr_api.g_number) <> hr_api.g_number) and
240: NOT (dt_api.check_min_max_dates
241: (p_base_table_name => 'ben_ler_chg_pl_nip_enrt_f',
242: p_base_key_column => 'ler_chg_pl_nip_enrt_id',
243: p_base_key_value => p_ler_chg_pl_nip_enrt_id,

Line 322: hr_api.mandatory_arg_error

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

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: 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: --
346: hr_api.mandatory_arg_error
347: (p_api_name => l_proc,
348: p_argument => 'ler_chg_pl_nip_rl_id',
349: p_argument_value => p_ler_chg_pl_nip_rl_id);
350: --

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

389: --
390: -- Call all supporting business operations
391: --
392: --
393: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
394: --
395: chk_ler_chg_pl_nip_rl_id
396: (p_ler_chg_pl_nip_rl_id => p_rec.ler_chg_pl_nip_rl_id,
397: p_effective_date => p_effective_date,

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

424: --
425: -- Call all supporting business operations
426: --
427: --
428: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
429: --
430: chk_ler_chg_pl_nip_rl_id
431: (p_ler_chg_pl_nip_rl_id => p_rec.ler_chg_pl_nip_rl_id,
432: p_effective_date => p_effective_date,

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

503: hr_utility.set_location('Entering:'|| l_proc, 10);
504: --
505: -- Ensure that all the mandatory parameter are not null
506: --
507: hr_api.mandatory_arg_error(p_api_name => l_proc,
508: p_argument => 'ler_chg_pl_nip_rl_id',
509: p_argument_value => p_ler_chg_pl_nip_rl_id);
510: --
511: open csr_leg_code;