DBA Data[Home] [Help]

APPS.BEN_BRC_BUS dependencies on HR_API

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

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

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

120: p_effective_date => p_effective_date,
121: p_object_version_number => p_object_version_number);
122: --
123: if (l_api_updating
124: and nvl(p_ctfn_rqd_when_rl,hr_api.g_number)
125: <> ben_brc_shd.g_old_rec.ctfn_rqd_when_rl
126: or not l_api_updating)
127: and p_ctfn_rqd_when_rl is not null then
128: --

Line 197: <> nvl(ben_brc_shd.g_old_rec.enrt_ctfn_typ_cd,hr_api.g_varchar2)

193: p_object_version_number => p_object_version_number);
194: --
195: if (l_api_updating
196: and p_enrt_ctfn_typ_cd
197: <> nvl(ben_brc_shd.g_old_rec.enrt_ctfn_typ_cd,hr_api.g_varchar2)
198: or not l_api_updating)
199: and p_enrt_ctfn_typ_cd is not null then
200: --
201: -- check if value of lookup falls within lookup type.

Line 203: if hr_api.not_exists_in_hr_lookups

199: and p_enrt_ctfn_typ_cd is not null then
200: --
201: -- check if value of lookup falls within lookup type.
202: --
203: if hr_api.not_exists_in_hr_lookups
204: (p_lookup_type => 'BEN_ENRT_CTFN_TYP',
205: p_lookup_code => p_enrt_ctfn_typ_cd,
206: p_effective_date => p_effective_date) then
207: --

Line 333: <> nvl(ben_brc_shd.g_old_rec.rqd_flag,hr_api.g_varchar2)

329: p_object_version_number => p_object_version_number);
330: --
331: if (l_api_updating
332: and p_rqd_flag
333: <> nvl(ben_brc_shd.g_old_rec.rqd_flag,hr_api.g_varchar2)
334: or not l_api_updating) and p_rqd_flag is not null then
335: --
336: -- check if value of lookup falls within lookup type.
337: --

Line 339: if hr_api.not_exists_in_hr_lookups

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

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

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

Line 403: hr_api.mandatory_arg_error

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

Line 415: hr_api.mandatory_arg_error

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

Line 420: hr_api.mandatory_arg_error

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

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

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

Line 507: hr_api.mandatory_arg_error

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

Line 521: hr_api.mandatory_arg_error

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

Line 526: hr_api.mandatory_arg_error

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

Line 531: hr_api.mandatory_arg_error

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

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

574: --
575: -- Call all supporting business operations
576: --
577: --
578: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
579: --
580: chk_bnft_rstrn_ctfn_id
581: (p_bnft_rstrn_ctfn_id => p_rec.bnft_rstrn_ctfn_id,
582: p_effective_date => p_effective_date,

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

630: --
631: -- Call all supporting business operations
632: --
633: --
634: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
635: --
636: chk_bnft_rstrn_ctfn_id
637: (p_bnft_rstrn_ctfn_id => p_rec.bnft_rstrn_ctfn_id,
638: 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 => 'bnft_rstrn_ctfn_id',
736: p_argument_value => p_bnft_rstrn_ctfn_id);
737: --
738: open csr_leg_code;