DBA Data[Home] [Help]

APPS.BEN_PCS_BUS dependencies on HR_API

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

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

Line 168: <> nvl(ben_pcs_shd.g_old_rec.enrt_r_bnft_ctfn_cd,hr_api.g_varchar2)

164: p_object_version_number => p_object_version_number);
165: --
166: if (l_api_updating
167: and p_enrt_r_bnft_ctfn_cd
168: <> nvl(ben_pcs_shd.g_old_rec.enrt_r_bnft_ctfn_cd,hr_api.g_varchar2)
169: or not l_api_updating)
170: and p_enrt_r_bnft_ctfn_cd is not null then
171: --
172: -- check if value of lookup falls within lookup type.

Line 174: if hr_api.not_exists_in_hr_lookups

170: and p_enrt_r_bnft_ctfn_cd is not null then
171: --
172: -- check if value of lookup falls within lookup type.
173: --
174: if hr_api.not_exists_in_hr_lookups
175: (p_lookup_type => 'BEN_ENRT_R_BNFT_CTFN',
176: p_lookup_code => p_enrt_r_bnft_ctfn_cd,
177: p_effective_date => p_effective_date) then
178: --

Line 240: <> nvl(ben_pcs_shd.g_old_rec.enrt_ctfn_typ_cd,hr_api.g_varchar2)

236: p_object_version_number => p_object_version_number);
237: --
238: if (l_api_updating
239: and p_enrt_ctfn_typ_cd
240: <> nvl(ben_pcs_shd.g_old_rec.enrt_ctfn_typ_cd,hr_api.g_varchar2)
241: or not l_api_updating)
242: and p_enrt_ctfn_typ_cd is not null then
243: --
244: -- check if value of lookup falls within lookup type.

Line 246: if hr_api.not_exists_in_hr_lookups

242: and p_enrt_ctfn_typ_cd is not null then
243: --
244: -- check if value of lookup falls within lookup type.
245: --
246: if hr_api.not_exists_in_hr_lookups
247: (p_lookup_type => 'BEN_ENRT_CTFN_TYP',
248: p_lookup_code => p_enrt_ctfn_typ_cd,
249: p_effective_date => p_effective_date) then
250: --

Line 401: <> nvl(ben_pcs_shd.g_old_rec.enrt_ctfn_rqd_flag,hr_api.g_varchar2)

397: p_object_version_number => p_object_version_number);
398: --
399: if (l_api_updating
400: and p_enrt_ctfn_rqd_flag
401: <> nvl(ben_pcs_shd.g_old_rec.enrt_ctfn_rqd_flag,hr_api.g_varchar2)
402: or not l_api_updating) then
403: --
404: -- check if value of lookup falls within lookup type.
405: --

Line 407: if hr_api.not_exists_in_hr_lookups

403: --
404: -- check if value of lookup falls within lookup type.
405: --
406: --
407: if hr_api.not_exists_in_hr_lookups
408: (p_lookup_type => 'YES_NO',
409: p_lookup_code => p_enrt_ctfn_rqd_flag,
410: p_effective_date => p_effective_date) then
411: --

Line 457: (p_prtt_enrt_actn_id in number default hr_api.g_number,

453: --
454: -- {End Of Comments}
455: -- ----------------------------------------------------------------------------
456: Procedure dt_update_validate
457: (p_prtt_enrt_actn_id in number default hr_api.g_number,
458: p_prtt_enrt_rslt_id in number default hr_api.g_number,
459: p_datetrack_mode in varchar2,
460: p_validation_start_date in date,
461: p_validation_end_date in date) Is

Line 458: p_prtt_enrt_rslt_id in number default hr_api.g_number,

454: -- {End Of Comments}
455: -- ----------------------------------------------------------------------------
456: Procedure dt_update_validate
457: (p_prtt_enrt_actn_id in number default hr_api.g_number,
458: p_prtt_enrt_rslt_id in number default hr_api.g_number,
459: p_datetrack_mode in varchar2,
460: p_validation_start_date in date,
461: p_validation_end_date in date) Is
462: --

Line 472: hr_api.mandatory_arg_error

468: hr_utility.set_location('Entering:'||l_proc, 5);
469: --
470: -- Ensure that the p_datetrack_mode argument is not null
471: --
472: hr_api.mandatory_arg_error
473: (p_api_name => l_proc,
474: p_argument => 'datetrack_mode',
475: p_argument_value => p_datetrack_mode);
476: --

Line 484: hr_api.mandatory_arg_error

480: --
481: --
482: -- Ensure the arguments are not null
483: --
484: hr_api.mandatory_arg_error
485: (p_api_name => l_proc,
486: p_argument => 'validation_start_date',
487: p_argument_value => p_validation_start_date);
488: --

Line 489: hr_api.mandatory_arg_error

485: (p_api_name => l_proc,
486: p_argument => 'validation_start_date',
487: p_argument_value => p_validation_start_date);
488: --
489: hr_api.mandatory_arg_error
490: (p_api_name => l_proc,
491: p_argument => 'validation_end_date',
492: p_argument_value => p_validation_end_date);
493: --

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

490: (p_api_name => l_proc,
491: p_argument => 'validation_end_date',
492: p_argument_value => p_validation_end_date);
493: --
494: If ((nvl(p_prtt_enrt_actn_id, hr_api.g_number) <> hr_api.g_number) and
495: NOT (dt_api.check_min_max_dates
496: (p_base_table_name => 'ben_prtt_enrt_actn_f',
497: p_base_key_column => 'prtt_enrt_actn_id',
498: p_base_key_value => p_prtt_enrt_actn_id,

Line 504: If ((nvl(p_prtt_enrt_rslt_id, hr_api.g_number) <> hr_api.g_number) and

500: p_to_date => p_validation_end_date))) Then
501: l_table_name := 'ben_prtt_enrt_actn_f';
502: Raise l_integrity_error;
503: End If;
504: If ((nvl(p_prtt_enrt_rslt_id, hr_api.g_number) <> hr_api.g_number) and
505: NOT (dt_api.check_min_max_dates
506: (p_base_table_name => 'ben_prtt_enrt_rslt_f',
507: p_base_key_column => 'prtt_enrt_rslt_id',
508: p_base_key_value => p_prtt_enrt_rslt_id,

Line 588: hr_api.mandatory_arg_error

584: hr_utility.set_location('Entering:'||l_proc, 5);
585: --
586: -- Ensure that the p_datetrack_mode argument is not null
587: --
588: hr_api.mandatory_arg_error
589: (p_api_name => l_proc,
590: p_argument => 'datetrack_mode',
591: p_argument_value => p_datetrack_mode);
592: --

Line 602: hr_api.mandatory_arg_error

598: --
599: --
600: -- Ensure the arguments are not null
601: --
602: hr_api.mandatory_arg_error
603: (p_api_name => l_proc,
604: p_argument => 'validation_start_date',
605: p_argument_value => p_validation_start_date);
606: --

Line 607: hr_api.mandatory_arg_error

603: (p_api_name => l_proc,
604: p_argument => 'validation_start_date',
605: p_argument_value => p_validation_start_date);
606: --
607: hr_api.mandatory_arg_error
608: (p_api_name => l_proc,
609: p_argument => 'validation_end_date',
610: p_argument_value => p_validation_end_date);
611: --

Line 612: hr_api.mandatory_arg_error

608: (p_api_name => l_proc,
609: p_argument => 'validation_end_date',
610: p_argument_value => p_validation_end_date);
611: --
612: hr_api.mandatory_arg_error
613: (p_api_name => l_proc,
614: p_argument => 'prtt_enrt_ctfn_prvdd_id',
615: p_argument_value => p_prtt_enrt_ctfn_prvdd_id);
616: --

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

656: --
657: -- Call all supporting business operations
658: --
659: --
660: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
661: --
662: chk_prtt_enrt_ctfn_prvdd_id
663: (p_prtt_enrt_ctfn_prvdd_id => p_rec.prtt_enrt_ctfn_prvdd_id,
664: p_effective_date => p_effective_date,

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

716: --
717: -- Call all supporting business operations
718: --
719: --
720: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
721: --
722: chk_prtt_enrt_ctfn_prvdd_id
723: (p_prtt_enrt_ctfn_prvdd_id => p_rec.prtt_enrt_ctfn_prvdd_id,
724: p_effective_date => p_effective_date,

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

822: hr_utility.set_location('Entering:'|| l_proc, 10);
823: --
824: -- Ensure that all the mandatory parameter are not null
825: --
826: hr_api.mandatory_arg_error(p_api_name => l_proc,
827: p_argument => 'prtt_enrt_ctfn_prvdd_id',
828: p_argument_value => p_prtt_enrt_ctfn_prvdd_id);
829: --
830: open csr_leg_code;