DBA Data[Home] [Help]

APPS.BEN_LBC_BUS dependencies on HR_API

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

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

Line 124: <> nvl(ben_lbc_shd.g_old_rec.rqd_flag,hr_api.g_varchar2)

120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and p_rqd_flag
124: <> nvl(ben_lbc_shd.g_old_rec.rqd_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_rqd_flag,
133: p_effective_date => p_effective_date) then
134: --

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

191: p_effective_date => p_effective_date,
192: p_object_version_number => p_object_version_number);
193: --
194: if (l_api_updating
195: and nvl(p_ctfn_rqd_when_rl,hr_api.g_number)
196: <> ben_lbc_shd.g_old_rec.ctfn_rqd_when_rl
197: or not l_api_updating)
198: and p_ctfn_rqd_when_rl is not null then
199: --

Line 268: <> nvl(ben_lbc_shd.g_old_rec.enrt_ctfn_typ_cd,hr_api.g_varchar2)

264: p_object_version_number => p_object_version_number);
265: --
266: if (l_api_updating
267: and p_enrt_ctfn_typ_cd
268: <> nvl(ben_lbc_shd.g_old_rec.enrt_ctfn_typ_cd,hr_api.g_varchar2)
269: or not l_api_updating)
270: and p_enrt_ctfn_typ_cd is not null then
271: --
272: -- check if value of lookup falls within lookup type.

Line 274: if hr_api.not_exists_in_hr_lookups

270: and p_enrt_ctfn_typ_cd is not null then
271: --
272: -- check if value of lookup falls within lookup type.
273: --
274: if hr_api.not_exists_in_hr_lookups
275: (p_lookup_type => 'BEN_ENRT_CTFN_TYP',
276: p_lookup_code => p_enrt_ctfn_typ_cd,
277: p_effective_date => p_effective_date) then
278: --

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

385: --
386: -- {End Of Comments}
387: -- ----------------------------------------------------------------------------
388: Procedure dt_update_validate
389: (p_ler_bnft_rstrn_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_ler_bnft_rstrn_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_ler_bnft_rstrn_id, hr_api.g_number) <> hr_api.g_number) and
426: NOT (dt_api.check_min_max_dates
427: (p_base_table_name => 'ben_ler_bnft_rstrn_f',
428: p_base_key_column => 'ler_bnft_rstrn_id',
429: p_base_key_value => p_ler_bnft_rstrn_id,

Line 509: hr_api.mandatory_arg_error

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

Line 523: hr_api.mandatory_arg_error

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

Line 528: hr_api.mandatory_arg_error

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

Line 533: hr_api.mandatory_arg_error

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

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

577: --
578: -- Call all supporting business operations
579: --
580: --
581: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
582: --
583: chk_ler_bnft_rstrn_ctfn_id
584: (p_ler_bnft_rstrn_ctfn_id => p_rec.ler_bnft_rstrn_ctfn_id,
585: p_effective_date => p_effective_date,

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

633: --
634: -- Call all supporting business operations
635: --
636: --
637: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
638: --
639: chk_ler_bnft_rstrn_ctfn_id
640: (p_ler_bnft_rstrn_ctfn_id => p_rec.ler_bnft_rstrn_ctfn_id,
641: p_effective_date => p_effective_date,

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

733: hr_utility.set_location('Entering:'|| l_proc, 10);
734: --
735: -- Ensure that all the mandatory parameter are not null
736: --
737: hr_api.mandatory_arg_error(p_api_name => l_proc,
738: p_argument => 'ler_bnft_rstrn_ctfn_id',
739: p_argument_value => p_ler_bnft_rstrn_ctfn_id);
740: --
741: open csr_leg_code;