DBA Data[Home] [Help]

APPS.BEN_LCC_BUS dependencies on HR_API

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

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

Line 125: <> nvl(ben_lcc_shd.g_old_rec.dpnt_cvg_ctfn_typ_cd,hr_api.g_varchar2)

121: p_object_version_number => p_object_version_number);
122: --
123: if (l_api_updating
124: and p_dpnt_cvg_ctfn_typ_cd
125: <> nvl(ben_lcc_shd.g_old_rec.dpnt_cvg_ctfn_typ_cd,hr_api.g_varchar2)
126: or not l_api_updating)
127: and p_dpnt_cvg_ctfn_typ_cd is not null then
128: --
129: -- check if value of lookup falls within lookup type.

Line 132: if hr_api.not_exists_in_hr_lookups

128: --
129: -- check if value of lookup falls within lookup type.
130: --
131: --
132: if hr_api.not_exists_in_hr_lookups
133: (p_lookup_type => 'BEN_DPNT_CVG_CTFN_TYP',
134: p_lookup_code => p_dpnt_cvg_ctfn_typ_cd,
135: p_effective_date => p_effective_date) then
136: --

Line 262: <> nvl(ben_lcc_shd.g_old_rec.rlshp_typ_cd,hr_api.g_varchar2)

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

Line 269: if hr_api.not_exists_in_hr_lookups

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

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_lcc_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_ler_chg_dpnt_cvg_id in number default hr_api.g_number,

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

Line 405: hr_api.mandatory_arg_error

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

Line 417: hr_api.mandatory_arg_error

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

Line 422: hr_api.mandatory_arg_error

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

Line 427: If ((nvl(p_ler_chg_dpnt_cvg_id, hr_api.g_number) <> hr_api.g_number) and

423: (p_api_name => l_proc,
424: p_argument => 'validation_end_date',
425: p_argument_value => p_validation_end_date);
426: --
427: If ((nvl(p_ler_chg_dpnt_cvg_id, hr_api.g_number) <> hr_api.g_number) and
428: NOT (dt_api.check_min_max_dates
429: (p_base_table_name => 'ben_ler_chg_dpnt_cvg_f',
430: p_base_key_column => 'ler_chg_dpnt_cvg_id',
431: p_base_key_value => p_ler_chg_dpnt_cvg_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_chg_dpnt_cvg_ctfn_id',
536: p_argument_value => p_ler_chg_dpnt_cvg_ctfn_id);
537: --

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_chg_dpnt_cvg_ctfn_id
582: (p_ler_chg_dpnt_cvg_ctfn_id => p_rec.ler_chg_dpnt_cvg_ctfn_id,
583: 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_ler_chg_dpnt_cvg_ctfn_id
638: (p_ler_chg_dpnt_cvg_ctfn_id => p_rec.ler_chg_dpnt_cvg_ctfn_id,
639: p_effective_date => p_effective_date,

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

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