APPS.BEN_LGL_BUS dependencies on HR_API

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

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

Line 189: and lgl_enty_rt_id <> nvl(p_lgl_enty_rt_id,hr_api.g_number)

185: select null
186: from ben_lgl_enty_rt_f
187: where organization_id = p_organization_id
188: and vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
189: and lgl_enty_rt_id <> nvl(p_lgl_enty_rt_id,hr_api.g_number)
190: and business_group_id + 0 = p_business_group_id
191: and p_validation_start_date <= effective_end_date
192: and p_validation_end_date >= effective_start_date;
193: --

Line 204: and p_organization_id <> nvl(ben_lgl_shd.g_old_rec.organization_id,hr_api.g_number)

200: p_effective_date => p_effective_date,
201: p_object_version_number => p_object_version_number);
202: --
203: if (l_api_updating
204: and p_organization_id <> nvl(ben_lgl_shd.g_old_rec.organization_id,hr_api.g_number)
205: or not l_api_updating) then
206:
207: open c_dup;
208: fetch c_dup into l_exists;

Line 332: <> nvl(ben_lgl_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

328: p_object_version_number => p_object_version_number);
329: --
330: if (l_api_updating
331: and p_excld_flag
332: <> nvl(ben_lgl_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
333: or not l_api_updating) then
334: --
335: -- check if value of lookup falls within lookup type.
336: --

Line 338: if hr_api.not_exists_in_hr_lookups

334: --
335: -- check if value of lookup falls within lookup type.
336: --
337: --
338: if hr_api.not_exists_in_hr_lookups
339: (p_lookup_type => 'YES_NO',
340: p_lookup_code => p_excld_flag,
341: p_effective_date => p_effective_date) then
342: --

Line 386: (p_vrbl_rt_prfl_id in number default hr_api.g_number,

382: --
383: -- {End Of Comments}
384: -- ----------------------------------------------------------------------------
385: Procedure dt_update_validate
386: (p_vrbl_rt_prfl_id in number default hr_api.g_number,
387: p_datetrack_mode in varchar2,
388: p_validation_start_date in date,
389: p_validation_end_date in date) Is
390: --

Line 400: hr_api.mandatory_arg_error

396: hr_utility.set_location('Entering:'||l_proc, 5);
397: --
398: -- Ensure that the p_datetrack_mode argument is not null
399: --
400: hr_api.mandatory_arg_error
401: (p_api_name => l_proc,
402: p_argument => 'datetrack_mode',
403: p_argument_value => p_datetrack_mode);
404: --

Line 412: hr_api.mandatory_arg_error

408: --
409: --
410: -- Ensure the arguments are not null
411: --
412: hr_api.mandatory_arg_error
413: (p_api_name => l_proc,
414: p_argument => 'validation_start_date',
415: p_argument_value => p_validation_start_date);
416: --

Line 417: hr_api.mandatory_arg_error

413: (p_api_name => l_proc,
414: p_argument => 'validation_start_date',
415: p_argument_value => p_validation_start_date);
416: --
417: hr_api.mandatory_arg_error
418: (p_api_name => l_proc,
419: p_argument => 'validation_end_date',
420: p_argument_value => p_validation_end_date);
421: --

Line 422: If ((nvl(p_vrbl_rt_prfl_id, hr_api.g_number) <> hr_api.g_number) and

418: (p_api_name => l_proc,
419: p_argument => 'validation_end_date',
420: p_argument_value => p_validation_end_date);
421: --
422: If ((nvl(p_vrbl_rt_prfl_id, hr_api.g_number) <> hr_api.g_number) and
423: NOT (dt_api.check_min_max_dates
424: (p_base_table_name => 'ben_vrbl_rt_prfl_f',
425: p_base_key_column => 'vrbl_rt_prfl_id',
426: p_base_key_value => p_vrbl_rt_prfl_id,

Line 505: hr_api.mandatory_arg_error

501: hr_utility.set_location('Entering:'||l_proc, 5);
502: --
503: -- Ensure that the p_datetrack_mode argument is not null
504: --
505: hr_api.mandatory_arg_error
506: (p_api_name => l_proc,
507: p_argument => 'datetrack_mode',
508: p_argument_value => p_datetrack_mode);
509: --

Line 519: hr_api.mandatory_arg_error

515: --
516: --
517: -- Ensure the arguments are not null
518: --
519: hr_api.mandatory_arg_error
520: (p_api_name => l_proc,
521: p_argument => 'validation_start_date',
522: p_argument_value => p_validation_start_date);
523: --

Line 524: hr_api.mandatory_arg_error

520: (p_api_name => l_proc,
521: p_argument => 'validation_start_date',
522: p_argument_value => p_validation_start_date);
523: --
524: hr_api.mandatory_arg_error
525: (p_api_name => l_proc,
526: p_argument => 'validation_end_date',
527: p_argument_value => p_validation_end_date);
528: --

Line 529: hr_api.mandatory_arg_error

525: (p_api_name => l_proc,
526: p_argument => 'validation_end_date',
527: p_argument_value => p_validation_end_date);
528: --
529: hr_api.mandatory_arg_error
530: (p_api_name => l_proc,
531: p_argument => 'lgl_enty_rt_id',
532: p_argument_value => p_lgl_enty_rt_id);
533: --

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

573: --
574: -- Call all supporting business operations
575: --
576: --
577: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
578: --
579: chk_lgl_enty_rt_id
580: (p_lgl_enty_rt_id => p_rec.lgl_enty_rt_id,
581: p_effective_date => p_effective_date,

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

629: --
630: -- Call all supporting business operations
631: --
632: --
633: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
634: --
635: chk_lgl_enty_rt_id
636: (p_lgl_enty_rt_id => p_rec.lgl_enty_rt_id,
637: p_effective_date => p_effective_date,

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

729: hr_utility.set_location('Entering:'|| l_proc, 10);
730: --
731: -- Ensure that all the mandatory parameter are not null
732: --
733: hr_api.mandatory_arg_error(p_api_name => l_proc,
734: p_argument => 'lgl_enty_rt_id',
735: p_argument_value => p_lgl_enty_rt_id);
736: --
737: open csr_leg_code;