DBA Data[Home] [Help]

APPS.BEN_LNC_BUS dependencies on HR_API

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

50: p_ler_enrt_ctfn_id => p_ler_enrt_ctfn_id,
51: p_object_version_number => p_object_version_number);
52: --
53: if (l_api_updating
54: and nvl(p_ler_enrt_ctfn_id,hr_api.g_number)
55: <> ben_lnc_shd.g_old_rec.ler_enrt_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_lnc_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_lnc_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_lnc_shd.g_old_rec.enrt_ctfn_typ_cd,hr_api.g_varchar2)
198: or not l_api_updating) then
199: --
200: -- check if value of lookup falls within lookup type.
201: --

Line 202: if hr_api.not_exists_in_hr_lookups

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

Line 331: <> nvl(ben_lnc_shd.g_old_rec.rqd_flag,hr_api.g_varchar2)

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

Line 337: if hr_api.not_exists_in_hr_lookups

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

Line 387: (p_ler_rqrs_enrt_ctfn_id in number default hr_api.g_number,

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

Line 401: hr_api.mandatory_arg_error

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

Line 413: hr_api.mandatory_arg_error

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

Line 418: hr_api.mandatory_arg_error

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

Line 423: If ((nvl(p_ler_rqrs_enrt_ctfn_id, hr_api.g_number) <> hr_api.g_number) and

419: (p_api_name => l_proc,
420: p_argument => 'validation_end_date',
421: p_argument_value => p_validation_end_date);
422: --
423: If ((nvl(p_ler_rqrs_enrt_ctfn_id, hr_api.g_number) <> hr_api.g_number) and
424: NOT (dt_api.check_min_max_dates
425: (p_base_table_name => 'ben_ler_rqrs_enrt_ctfn_f',
426: p_base_key_column => 'ler_rqrs_enrt_ctfn_id',
427: p_base_key_value => p_ler_rqrs_enrt_ctfn_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 => 'ler_enrt_ctfn_id',
534: p_argument_value => p_ler_enrt_ctfn_id);
535: --

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

575: --
576: -- Call all supporting business operations
577: --
578: --
579: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
580: --
581: chk_ler_enrt_ctfn_id
582: (p_ler_enrt_ctfn_id => p_rec.ler_enrt_ctfn_id,
583: 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_ler_enrt_ctfn_id
637: (p_ler_enrt_ctfn_id => p_rec.ler_enrt_ctfn_id,
638: p_effective_date => p_effective_date,

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

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