APPS.BEN_OUR_BUS dependencies on HR_API

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

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

Line 124: <> nvl(ben_our_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and p_excld_flag
124: <> nvl(ben_our_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
125: or not l_api_updating) then
126: --
127: -- check if value of lookup falls within lookup type.
128: --

Line 130: if hr_api.not_exists_in_hr_lookups

126: --
127: -- check if value of lookup falls within lookup type.
128: --
129: --
130: if hr_api.not_exists_in_hr_lookups
131: (p_lookup_type => 'YES_NO',
132: p_lookup_code => p_excld_flag,
133: p_effective_date => p_effective_date) then
134: --

Line 256: and org_unit_rt_id <> nvl(p_org_unit_rt_id,hr_api.g_number)

252: select null
253: from ben_org_unit_rt_f
254: where organization_id = p_organization_id
255: and vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
256: and org_unit_rt_id <> nvl(p_org_unit_rt_id,hr_api.g_number)
257: and business_group_id + 0 = p_business_group_id
258: and p_validation_start_date <= effective_end_date
259: and p_validation_end_date >= effective_start_date;
260: --

Line 271: and p_organization_id <> nvl(ben_our_shd.g_old_rec.organization_id,hr_api.g_number)

267: p_effective_date => p_effective_date,
268: p_object_version_number => p_object_version_number);
269: --
270: if (l_api_updating
271: and p_organization_id <> nvl(ben_our_shd.g_old_rec.organization_id,hr_api.g_number)
272: or not l_api_updating) then
273:
274: open c_dup;
275: fetch c_dup into l_exists;

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

389: --
390: -- {End Of Comments}
391: -- ----------------------------------------------------------------------------
392: Procedure dt_update_validate
393: (p_vrbl_rt_prfl_id in number default hr_api.g_number,
394: p_datetrack_mode in varchar2,
395: p_validation_start_date in date,
396: p_validation_end_date in date) Is
397: --

Line 407: hr_api.mandatory_arg_error

403: hr_utility.set_location('Entering:'||l_proc, 5);
404: --
405: -- Ensure that the p_datetrack_mode argument is not null
406: --
407: hr_api.mandatory_arg_error
408: (p_api_name => l_proc,
409: p_argument => 'datetrack_mode',
410: p_argument_value => p_datetrack_mode);
411: --

Line 419: hr_api.mandatory_arg_error

415: --
416: --
417: -- Ensure the arguments are not null
418: --
419: hr_api.mandatory_arg_error
420: (p_api_name => l_proc,
421: p_argument => 'validation_start_date',
422: p_argument_value => p_validation_start_date);
423: --

Line 424: hr_api.mandatory_arg_error

420: (p_api_name => l_proc,
421: p_argument => 'validation_start_date',
422: p_argument_value => p_validation_start_date);
423: --
424: hr_api.mandatory_arg_error
425: (p_api_name => l_proc,
426: p_argument => 'validation_end_date',
427: p_argument_value => p_validation_end_date);
428: --

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

425: (p_api_name => l_proc,
426: p_argument => 'validation_end_date',
427: p_argument_value => p_validation_end_date);
428: --
429: If ((nvl(p_vrbl_rt_prfl_id, hr_api.g_number) <> hr_api.g_number) and
430: NOT (dt_api.check_min_max_dates
431: (p_base_table_name => 'ben_vrbl_rt_prfl_f',
432: p_base_key_column => 'vrbl_rt_prfl_id',
433: p_base_key_value => p_vrbl_rt_prfl_id,

Line 512: hr_api.mandatory_arg_error

508: hr_utility.set_location('Entering:'||l_proc, 5);
509: --
510: -- Ensure that the p_datetrack_mode argument is not null
511: --
512: hr_api.mandatory_arg_error
513: (p_api_name => l_proc,
514: p_argument => 'datetrack_mode',
515: p_argument_value => p_datetrack_mode);
516: --

Line 526: hr_api.mandatory_arg_error

522: --
523: --
524: -- Ensure the arguments are not null
525: --
526: hr_api.mandatory_arg_error
527: (p_api_name => l_proc,
528: p_argument => 'validation_start_date',
529: p_argument_value => p_validation_start_date);
530: --

Line 531: hr_api.mandatory_arg_error

527: (p_api_name => l_proc,
528: p_argument => 'validation_start_date',
529: p_argument_value => p_validation_start_date);
530: --
531: hr_api.mandatory_arg_error
532: (p_api_name => l_proc,
533: p_argument => 'validation_end_date',
534: p_argument_value => p_validation_end_date);
535: --

Line 536: hr_api.mandatory_arg_error

532: (p_api_name => l_proc,
533: p_argument => 'validation_end_date',
534: p_argument_value => p_validation_end_date);
535: --
536: hr_api.mandatory_arg_error
537: (p_api_name => l_proc,
538: p_argument => 'org_unit_rt_id',
539: p_argument_value => p_org_unit_rt_id);
540: --

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

580: --
581: -- Call all supporting business operations
582: --
583: --
584: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
585: --
586: chk_org_unit_rt_id
587: (p_org_unit_rt_id => p_rec.org_unit_rt_id,
588: p_effective_date => p_effective_date,

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

639: --
640: -- Call all supporting business operations
641: --
642: --
643: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
644: --
645: chk_org_unit_rt_id
646: (p_org_unit_rt_id => p_rec.org_unit_rt_id,
647: p_effective_date => p_effective_date,

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

742: hr_utility.set_location('Entering:'|| l_proc, 10);
743: --
744: -- Ensure that all the mandatory parameter are not null
745: --
746: hr_api.mandatory_arg_error(p_api_name => l_proc,
747: p_argument => 'org_unit_rt_id',
748: p_argument_value => p_org_unit_rt_id);
749: --
750: open csr_leg_code;