DBA Data[Home] [Help]

APPS.BEN_ECF_BUS dependencies on HR_API

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

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

Line 124: <> nvl(ben_ecf_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_ecf_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 262: <> nvl(ben_ecf_shd.g_old_rec.rqd_flag,hr_api.g_varchar2)

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

Line 268: if hr_api.not_exists_in_hr_lookups

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

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

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

Line 391: (p_pl_id in number default hr_api.g_number,

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

Line 392: p_oipl_id in number default hr_api.g_number,

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

Line 406: hr_api.mandatory_arg_error

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

Line 418: hr_api.mandatory_arg_error

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

Line 423: hr_api.mandatory_arg_error

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

Line 428: If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and

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

Line 438: If ((nvl(p_oipl_id, hr_api.g_number) <> hr_api.g_number) and

434: p_to_date => p_validation_end_date))) Then
435: l_table_name := 'ben_pl_f';
436: Raise l_integrity_error;
437: End If;
438: If ((nvl(p_oipl_id, hr_api.g_number) <> hr_api.g_number) and
439: NOT (dt_api.check_min_max_dates
440: (p_base_table_name => 'ben_oipl_f',
441: p_base_key_column => 'oipl_id',
442: p_base_key_value => p_oipl_id,

Line 522: hr_api.mandatory_arg_error

518: hr_utility.set_location('Entering:'||l_proc, 5);
519: --
520: -- Ensure that the p_datetrack_mode argument is not null
521: --
522: hr_api.mandatory_arg_error
523: (p_api_name => l_proc,
524: p_argument => 'datetrack_mode',
525: p_argument_value => p_datetrack_mode);
526: --

Line 536: hr_api.mandatory_arg_error

532: --
533: --
534: -- Ensure the arguments are not null
535: --
536: hr_api.mandatory_arg_error
537: (p_api_name => l_proc,
538: p_argument => 'validation_start_date',
539: p_argument_value => p_validation_start_date);
540: --

Line 541: hr_api.mandatory_arg_error

537: (p_api_name => l_proc,
538: p_argument => 'validation_start_date',
539: p_argument_value => p_validation_start_date);
540: --
541: hr_api.mandatory_arg_error
542: (p_api_name => l_proc,
543: p_argument => 'validation_end_date',
544: p_argument_value => p_validation_end_date);
545: --

Line 546: hr_api.mandatory_arg_error

542: (p_api_name => l_proc,
543: p_argument => 'validation_end_date',
544: p_argument_value => p_validation_end_date);
545: --
546: hr_api.mandatory_arg_error
547: (p_api_name => l_proc,
548: p_argument => 'enrt_ctfn_id',
549: p_argument_value => p_enrt_ctfn_id);
550: --

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

590: --
591: -- Call all supporting business operations
592: --
593: --
594: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
595: --
596: chk_enrt_ctfn_id
597: (p_enrt_ctfn_id => p_rec.enrt_ctfn_id,
598: p_effective_date => p_effective_date,

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

646: --
647: -- Call all supporting business operations
648: --
649: --
650: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
651: --
652: chk_enrt_ctfn_id
653: (p_enrt_ctfn_id => p_rec.enrt_ctfn_id,
654: p_effective_date => p_effective_date,

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

747: hr_utility.set_location('Entering:'|| l_proc, 10);
748: --
749: -- Ensure that all the mandatory parameter are not null
750: --
751: hr_api.mandatory_arg_error(p_api_name => l_proc,
752: p_argument => 'enrt_ctfn_id',
753: p_argument_value => p_enrt_ctfn_id);
754: --
755: open csr_leg_code;