APPS.BEN_CCP_BUS dependencies on HR_API

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

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

Line 124: <> nvl(ben_ccp_shd.g_old_rec.dpnt_dsgn_ctfn_rqd_flag,hr_api.g_varchar2)

120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and p_dpnt_dsgn_ctfn_rqd_flag
124: <> nvl(ben_ccp_shd.g_old_rec.dpnt_dsgn_ctfn_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_dpnt_dsgn_ctfn_rqd_flag,
133: p_effective_date => p_effective_date) then
134: --

Line 201: and ccp.cvrd_dpnt_ctfn_prvdd_id <> nvl(p_cvrd_dpnt_ctfn_prvdd_id, hr_api.g_number)

197: and pea.prtt_enrt_actn_id = p_prtt_enrt_actn_id
198: and pea.prtt_enrt_actn_id = ccp.prtt_enrt_actn_id
199: and pil.per_in_ler_id = pea.per_in_ler_id
200: and pil.per_in_ler_stat_cd not in ('BCKDT', 'VOIDD')
201: and ccp.cvrd_dpnt_ctfn_prvdd_id <> nvl(p_cvrd_dpnt_ctfn_prvdd_id, hr_api.g_number)
202: and ccp.business_group_id = p_business_group_id
203: and p_effective_date between pea.effective_start_date
204: and pea.effective_end_date
205: and p_validation_start_date <= ccp.effective_end_date

Line 222: <> nvl(ben_ccp_shd.g_old_rec.dpnt_dsgn_ctfn_typ_cd,hr_api.g_varchar2)

218: p_object_version_number => p_object_version_number);
219: --
220: if (l_api_updating
221: and p_dpnt_dsgn_ctfn_typ_cd
222: <> nvl(ben_ccp_shd.g_old_rec.dpnt_dsgn_ctfn_typ_cd,hr_api.g_varchar2)
223: or not l_api_updating) then
224: --
225: -- check if value of lookup falls within lookup type.
226: --

Line 228: if hr_api.not_exists_in_hr_lookups

224: --
225: -- check if value of lookup falls within lookup type.
226: --
227: --
228: if hr_api.not_exists_in_hr_lookups
229: (p_lookup_type => 'BEN_DPNT_CVG_CTFN_TYP',
230: p_lookup_code => p_dpnt_dsgn_ctfn_typ_cd,
231: p_effective_date => p_effective_date) then
232: --

Line 315: <> nvl(ben_ccp_shd.g_old_rec.dpnt_dsgn_ctfn_recd_dt,hr_api.g_date)

311: p_object_version_number => p_object_version_number);
312: --
313: if (l_api_updating
314: and p_dpnt_dsgn_ctfn_recd_dt
315: <> nvl(ben_ccp_shd.g_old_rec.dpnt_dsgn_ctfn_recd_dt,hr_api.g_date)
316: or not l_api_updating) then
317: --
318: -- check if received date < than efective start date. .
319: --

Line 363: (p_elig_cvrd_dpnt_id in number default hr_api.g_number,

359: --
360: -- {End Of Comments}
361: -- ----------------------------------------------------------------------------
362: Procedure dt_update_validate
363: (p_elig_cvrd_dpnt_id in number default hr_api.g_number,
364: p_prtt_enrt_actn_id in number default hr_api.g_number,
365: p_datetrack_mode in varchar2,
366: p_validation_start_date in date,
367: p_validation_end_date in date) Is

Line 364: p_prtt_enrt_actn_id in number default hr_api.g_number,

360: -- {End Of Comments}
361: -- ----------------------------------------------------------------------------
362: Procedure dt_update_validate
363: (p_elig_cvrd_dpnt_id in number default hr_api.g_number,
364: p_prtt_enrt_actn_id in number default hr_api.g_number,
365: p_datetrack_mode in varchar2,
366: p_validation_start_date in date,
367: p_validation_end_date in date) Is
368: --

Line 378: hr_api.mandatory_arg_error

374: hr_utility.set_location('Entering:'||l_proc, 5);
375: --
376: -- Ensure that the p_datetrack_mode argument is not null
377: --
378: hr_api.mandatory_arg_error
379: (p_api_name => l_proc,
380: p_argument => 'datetrack_mode',
381: p_argument_value => p_datetrack_mode);
382: --

Line 390: hr_api.mandatory_arg_error

386: --
387: --
388: -- Ensure the arguments are not null
389: --
390: hr_api.mandatory_arg_error
391: (p_api_name => l_proc,
392: p_argument => 'validation_start_date',
393: p_argument_value => p_validation_start_date);
394: --

Line 395: hr_api.mandatory_arg_error

391: (p_api_name => l_proc,
392: p_argument => 'validation_start_date',
393: p_argument_value => p_validation_start_date);
394: --
395: hr_api.mandatory_arg_error
396: (p_api_name => l_proc,
397: p_argument => 'validation_end_date',
398: p_argument_value => p_validation_end_date);
399: --

Line 400: If ((nvl(p_elig_cvrd_dpnt_id, hr_api.g_number) <> hr_api.g_number) and

396: (p_api_name => l_proc,
397: p_argument => 'validation_end_date',
398: p_argument_value => p_validation_end_date);
399: --
400: If ((nvl(p_elig_cvrd_dpnt_id, hr_api.g_number) <> hr_api.g_number) and
401: NOT (dt_api.check_min_max_dates
402: (p_base_table_name => 'ben_elig_cvrd_dpnt_f',
403: p_base_key_column => 'elig_cvrd_dpnt_id',
404: p_base_key_value => p_elig_cvrd_dpnt_id,

Line 410: If ((nvl(p_prtt_enrt_actn_id, hr_api.g_number) <> hr_api.g_number) and

406: p_to_date => p_validation_end_date))) Then
407: l_table_name := 'ben_elig_cvrd_dpnt_f';
408: Raise l_integrity_error;
409: End If;
410: If ((nvl(p_prtt_enrt_actn_id, hr_api.g_number) <> hr_api.g_number) and
411: NOT (dt_api.check_min_max_dates
412: (p_base_table_name => 'ben_prtt_enrt_actn_f',
413: p_base_key_column => 'prtt_enrt_actn_id',
414: p_base_key_value => p_prtt_enrt_actn_id,

Line 493: hr_api.mandatory_arg_error

489: hr_utility.set_location('Entering:'||l_proc, 5);
490: --
491: -- Ensure that the p_datetrack_mode argument is not null
492: --
493: hr_api.mandatory_arg_error
494: (p_api_name => l_proc,
495: p_argument => 'datetrack_mode',
496: p_argument_value => p_datetrack_mode);
497: --

Line 507: hr_api.mandatory_arg_error

503: --
504: --
505: -- Ensure the arguments are not null
506: --
507: hr_api.mandatory_arg_error
508: (p_api_name => l_proc,
509: p_argument => 'validation_start_date',
510: p_argument_value => p_validation_start_date);
511: --

Line 512: hr_api.mandatory_arg_error

508: (p_api_name => l_proc,
509: p_argument => 'validation_start_date',
510: p_argument_value => p_validation_start_date);
511: --
512: hr_api.mandatory_arg_error
513: (p_api_name => l_proc,
514: p_argument => 'validation_end_date',
515: p_argument_value => p_validation_end_date);
516: --

Line 517: hr_api.mandatory_arg_error

513: (p_api_name => l_proc,
514: p_argument => 'validation_end_date',
515: p_argument_value => p_validation_end_date);
516: --
517: hr_api.mandatory_arg_error
518: (p_api_name => l_proc,
519: p_argument => 'cvrd_dpnt_ctfn_prvdd_id',
520: p_argument_value => p_cvrd_dpnt_ctfn_prvdd_id);
521: --

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

560: --
561: -- Call all supporting business operations
562: --
563: --
564: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
565: --
566: chk_cvrd_dpnt_ctfn_prvdd_id
567: (p_cvrd_dpnt_ctfn_prvdd_id => p_rec.cvrd_dpnt_ctfn_prvdd_id,
568: p_effective_date => p_effective_date,

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

615: --
616: -- Call all supporting business operations
617: --
618: --
619: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
620: --
621: chk_cvrd_dpnt_ctfn_prvdd_id
622: (p_cvrd_dpnt_ctfn_prvdd_id => p_rec.cvrd_dpnt_ctfn_prvdd_id,
623: p_effective_date => p_effective_date,

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

715: hr_utility.set_location('Entering:'|| l_proc, 10);
716: --
717: -- Ensure that all the mandatory parameter are not null
718: --
719: hr_api.mandatory_arg_error(p_api_name => l_proc,
720: p_argument => 'cvrd_dpnt_ctfn_prvdd_id',
721: p_argument_value => p_cvrd_dpnt_ctfn_prvdd_id);
722: --
723: open csr_leg_code;