DBA Data[Home] [Help]

APPS.BEN_ABC_BUS dependencies on HR_API

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

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

Line 124: <> nvl(ben_abc_shd.g_old_rec.enrt_ctfn_typ_cd,hr_api.g_varchar2)

120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and p_enrt_ctfn_typ_cd
124: <> nvl(ben_abc_shd.g_old_rec.enrt_ctfn_typ_cd,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 => 'BEN_ENRT_CTFN_TYP',
132: p_lookup_code => p_enrt_ctfn_typ_cd,
133: p_effective_date => p_effective_date) then
134: --

Line 259: <> nvl(ben_abc_shd.g_old_rec.rqd_flag,hr_api.g_varchar2)

255: p_object_version_number => p_object_version_number);
256: --
257: if (l_api_updating
258: and p_rqd_flag
259: <> nvl(ben_abc_shd.g_old_rec.rqd_flag,hr_api.g_varchar2)
260: or not l_api_updating) then
261: --
262: -- check if value of lookup falls within lookup type.
263: --

Line 265: if hr_api.not_exists_in_hr_lookups

261: --
262: -- check if value of lookup falls within lookup type.
263: --
264: --
265: if hr_api.not_exists_in_hr_lookups
266: (p_lookup_type => 'YES_NO',
267: p_lookup_code => p_rqd_flag,
268: p_effective_date => p_effective_date) then
269: --

Line 330: and nvl(p_ctfn_rqd_when_rl,hr_api.g_number)

326: p_effective_date => p_effective_date,
327: p_object_version_number => p_object_version_number);
328: --
329: if (l_api_updating
330: and nvl(p_ctfn_rqd_when_rl,hr_api.g_number)
331: <> ben_abc_shd.g_old_rec.ctfn_rqd_when_rl
332: or not l_api_updating)
333: and p_ctfn_rqd_when_rl is not null then
334: --

Line 388: (p_acty_base_rt_id in number default hr_api.g_number,

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

Line 402: hr_api.mandatory_arg_error

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

Line 414: hr_api.mandatory_arg_error

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

Line 419: hr_api.mandatory_arg_error

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

Line 424: If ((nvl(p_acty_base_rt_id, hr_api.g_number) <> hr_api.g_number) and

420: (p_api_name => l_proc,
421: p_argument => 'validation_end_date',
422: p_argument_value => p_validation_end_date);
423: --
424: If ((nvl(p_acty_base_rt_id, hr_api.g_number) <> hr_api.g_number) and
425: NOT (dt_api.check_min_max_dates
426: (p_base_table_name => 'ben_acty_base_rt_f',
427: p_base_key_column => 'acty_base_rt_id',
428: p_base_key_value => p_acty_base_rt_id,

Line 508: hr_api.mandatory_arg_error

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

Line 522: hr_api.mandatory_arg_error

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

Line 527: hr_api.mandatory_arg_error

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

Line 532: hr_api.mandatory_arg_error

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

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

576: --
577: -- Call all supporting business operations
578: --
579: --
580: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
581: --
582: chk_acty_base_rt_ctfn_id
583: (p_acty_base_rt_ctfn_id => p_rec.acty_base_rt_ctfn_id,
584: p_effective_date => p_effective_date,

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

631: --
632: -- Call all supporting business operations
633: --
634: --
635: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
636: --
637: chk_acty_base_rt_ctfn_id
638: (p_acty_base_rt_ctfn_id => p_rec.acty_base_rt_ctfn_id,
639: p_effective_date => p_effective_date,

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

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