DBA Data[Home] [Help]

APPS.BEN_ECR_BUS dependencies on HR_API

Line 50: and nvl(p_enrt_rt_id,hr_api.g_number)

46: (p_enrt_rt_id => p_enrt_rt_id,
47: p_object_version_number => p_object_version_number);
48: --
49: if (l_api_updating
50: and nvl(p_enrt_rt_id,hr_api.g_number)
51: <> ben_ecr_shd.g_old_rec.enrt_rt_id) then
52: --
53: -- raise error as PK has changed
54: --

Line 122: and nvl(p_elig_per_elctbl_chc_id,hr_api.g_number)

118: (p_enrt_rt_id => p_enrt_rt_id,
119: p_object_version_number => p_object_version_number);
120: --
121: if (l_api_updating
122: and nvl(p_elig_per_elctbl_chc_id,hr_api.g_number)
123: <> nvl(ben_ecr_shd.g_old_rec.elig_per_elctbl_chc_id,hr_api.g_number)
124: or not l_api_updating) and p_elig_per_elctbl_chc_id is not null then
125: --
126: -- check if elig_per_elctbl_chc_id value exists in

Line 123: <> nvl(ben_ecr_shd.g_old_rec.elig_per_elctbl_chc_id,hr_api.g_number)

119: p_object_version_number => p_object_version_number);
120: --
121: if (l_api_updating
122: and nvl(p_elig_per_elctbl_chc_id,hr_api.g_number)
123: <> nvl(ben_ecr_shd.g_old_rec.elig_per_elctbl_chc_id,hr_api.g_number)
124: or not l_api_updating) and p_elig_per_elctbl_chc_id is not null then
125: --
126: -- check if elig_per_elctbl_chc_id value exists in
127: -- ben_elig_per_elctbl_chc table

Line 198: and nvl(p_enrt_bnft_id,hr_api.g_number)

194: (p_enrt_rt_id => p_enrt_rt_id,
195: p_object_version_number => p_object_version_number);
196: --
197: if (l_api_updating
198: and nvl(p_enrt_bnft_id,hr_api.g_number)
199: <> nvl(ben_ecr_shd.g_old_rec.enrt_bnft_id,hr_api.g_number)
200: or not l_api_updating) and p_enrt_bnft_id is not null then
201: --
202: -- check if enrt_bnft_id value exists in

Line 199: <> nvl(ben_ecr_shd.g_old_rec.enrt_bnft_id,hr_api.g_number)

195: p_object_version_number => p_object_version_number);
196: --
197: if (l_api_updating
198: and nvl(p_enrt_bnft_id,hr_api.g_number)
199: <> nvl(ben_ecr_shd.g_old_rec.enrt_bnft_id,hr_api.g_number)
200: or not l_api_updating) and p_enrt_bnft_id is not null then
201: --
202: -- check if enrt_bnft_id value exists in
203: -- ben_enrt_bnft table

Line 271: and nvl(p_rt_strt_dt_rl,hr_api.g_number)

267: (p_enrt_rt_id => p_enrt_rt_id,
268: p_object_version_number => p_object_version_number);
269: --
270: if (l_api_updating
271: and nvl(p_rt_strt_dt_rl,hr_api.g_number)
272: <> ben_ecr_shd.g_old_rec.rt_strt_dt_rl
273: or not l_api_updating)
274: and p_rt_strt_dt_rl is not null then
275: --

Line 359: <> nvl(ben_ecr_shd.g_old_rec.entr_ann_val_flag,hr_api.g_varchar2)

355: p_object_version_number => p_object_version_number);
356: --
357: if (l_api_updating
358: and p_entr_ann_val_flag
359: <> nvl(ben_ecr_shd.g_old_rec.entr_ann_val_flag,hr_api.g_varchar2)
360: or not l_api_updating) then
361: --
362: -- check if value of lookup falls within lookup type.
363: --

Line 365: if hr_api.not_exists_in_hr_lookups

361: --
362: -- check if value of lookup falls within lookup type.
363: --
364: --
365: if hr_api.not_exists_in_hr_lookups
366: (p_lookup_type => 'YES_NO',
367: p_lookup_code => p_entr_ann_val_flag,
368: p_effective_date => p_effective_date) then
369: --

Line 383: <> nvl(ben_ecr_shd.g_old_rec.ctfn_rqd_flag,hr_api.g_varchar2)

379: end if;
380: --
381: if (l_api_updating
382: and p_ctfn_rqd_flag
383: <> nvl(ben_ecr_shd.g_old_rec.ctfn_rqd_flag,hr_api.g_varchar2)
384: or not l_api_updating) then
385: --
386: -- check if value of lookup falls within lookup type.
387: --

Line 389: if hr_api.not_exists_in_hr_lookups

385: --
386: -- check if value of lookup falls within lookup type.
387: --
388: --
389: if hr_api.not_exists_in_hr_lookups
390: (p_lookup_type => 'YES_NO',
391: p_lookup_code => p_ctfn_rqd_flag,
392: p_effective_date => p_effective_date) then
393: --

Line 407: <> nvl(ben_ecr_shd.g_old_rec.dflt_flag,hr_api.g_varchar2)

403: end if;
404: --
405: if (l_api_updating
406: and p_dflt_flag
407: <> nvl(ben_ecr_shd.g_old_rec.dflt_flag,hr_api.g_varchar2)
408: or not l_api_updating) then
409: --
410: -- check if value of lookup falls within lookup type.
411: --

Line 413: if hr_api.not_exists_in_hr_lookups

409: --
410: -- check if value of lookup falls within lookup type.
411: --
412: --
413: if hr_api.not_exists_in_hr_lookups
414: (p_lookup_type => 'YES_NO',
415: p_lookup_code => p_dflt_flag,
416: p_effective_date => p_effective_date) then
417: --

Line 431: <> nvl(ben_ecr_shd.g_old_rec.dflt_pndg_ctfn_flag,hr_api.g_varchar2)

427: end if;
428: --
429: if (l_api_updating
430: and p_dflt_pndg_ctfn_flag
431: <> nvl(ben_ecr_shd.g_old_rec.dflt_pndg_ctfn_flag,hr_api.g_varchar2)
432: or not l_api_updating) then
433: --
434: -- check if value of lookup falls within lookup type.
435: --

Line 437: if hr_api.not_exists_in_hr_lookups

433: --
434: -- check if value of lookup falls within lookup type.
435: --
436: --
437: if hr_api.not_exists_in_hr_lookups
438: (p_lookup_type => 'YES_NO',
439: p_lookup_code => p_dflt_pndg_ctfn_flag,
440: p_effective_date => p_effective_date) then
441: --

Line 455: <> nvl(ben_ecr_shd.g_old_rec.dsply_on_enrt_flag,hr_api.g_varchar2)

451: end if;
452: --
453: if (l_api_updating
454: and p_dsply_on_enrt_flag
455: <> nvl(ben_ecr_shd.g_old_rec.dsply_on_enrt_flag,hr_api.g_varchar2)
456: or not l_api_updating) then
457: --
458: -- check if value of lookup falls within lookup type.
459: --

Line 461: if hr_api.not_exists_in_hr_lookups

457: --
458: -- check if value of lookup falls within lookup type.
459: --
460: --
461: if hr_api.not_exists_in_hr_lookups
462: (p_lookup_type => 'YES_NO',
463: p_lookup_code => p_dsply_on_enrt_flag,
464: p_effective_date => p_effective_date) then
465: --

Line 479: <> nvl(ben_ecr_shd.g_old_rec.use_to_calc_net_flx_cr_flag,hr_api.g_varchar2)

475: end if;
476: --
477: if (l_api_updating
478: and p_use_to_calc_net_flx_cr_flag
479: <> nvl(ben_ecr_shd.g_old_rec.use_to_calc_net_flx_cr_flag,hr_api.g_varchar2)
480: or not l_api_updating) then
481: --
482: -- check if value of lookup falls within lookup type.
483: --

Line 485: if hr_api.not_exists_in_hr_lookups

481: --
482: -- check if value of lookup falls within lookup type.
483: --
484: --
485: if hr_api.not_exists_in_hr_lookups
486: (p_lookup_type => 'YES_NO',
487: p_lookup_code => p_use_to_calc_net_flx_cr_flag,
488: p_effective_date => p_effective_date) then
489: --

Line 503: <> nvl(ben_ecr_shd.g_old_rec.entr_val_at_enrt_flag,hr_api.g_varchar2)

499: end if;
500: --
501: if (l_api_updating
502: and p_entr_val_at_enrt_flag
503: <> nvl(ben_ecr_shd.g_old_rec.entr_val_at_enrt_flag,hr_api.g_varchar2)
504: or not l_api_updating) then
505: --
506: -- check if value of lookup falls within lookup type.
507: --

Line 509: if hr_api.not_exists_in_hr_lookups

505: --
506: -- check if value of lookup falls within lookup type.
507: --
508: --
509: if hr_api.not_exists_in_hr_lookups
510: (p_lookup_type => 'YES_NO',
511: p_lookup_code => p_entr_val_at_enrt_flag,
512: p_effective_date => p_effective_date) then
513: --

Line 527: <> nvl(ben_ecr_shd.g_old_rec.asn_on_enrt_flag,hr_api.g_varchar2)

523: end if;
524: --
525: if (l_api_updating
526: and p_asn_on_enrt_flag
527: <> nvl(ben_ecr_shd.g_old_rec.asn_on_enrt_flag,hr_api.g_varchar2)
528: or not l_api_updating) then
529: --
530: -- check if value of lookup falls within lookup type.
531: --

Line 533: if hr_api.not_exists_in_hr_lookups

529: --
530: -- check if value of lookup falls within lookup type.
531: --
532: --
533: if hr_api.not_exists_in_hr_lookups
534: (p_lookup_type => 'YES_NO',
535: p_lookup_code => p_asn_on_enrt_flag,
536: p_effective_date => p_effective_date) then
537: --

Line 551: <> nvl(ben_ecr_shd.g_old_rec.rl_crs_only_flag,hr_api.g_varchar2)

547: end if;
548: --
549: if (l_api_updating
550: and p_rl_crs_only_flag
551: <> nvl(ben_ecr_shd.g_old_rec.rl_crs_only_flag,hr_api.g_varchar2)
552: or not l_api_updating) then
553: --
554: -- check if value of lookup falls within lookup type.
555: --

Line 557: if hr_api.not_exists_in_hr_lookups

553: --
554: -- check if value of lookup falls within lookup type.
555: --
556: --
557: if hr_api.not_exists_in_hr_lookups
558: (p_lookup_type => 'YES_NO',
559: p_lookup_code => p_rl_crs_only_flag,
560: p_effective_date => p_effective_date) then
561: --

Line 627: <> nvl(ben_ecr_shd.g_old_rec.acty_typ_cd,hr_api.g_varchar2)

623: p_object_version_number => p_object_version_number);
624: --
625: if (l_api_updating
626: and p_acty_typ_cd
627: <> nvl(ben_ecr_shd.g_old_rec.acty_typ_cd,hr_api.g_varchar2)
628: or not l_api_updating) then
629: --
630: -- check if value of lookup falls within lookup type.
631: --

Line 632: if hr_api.not_exists_in_hr_lookups

628: or not l_api_updating) then
629: --
630: -- check if value of lookup falls within lookup type.
631: --
632: if hr_api.not_exists_in_hr_lookups
633: (p_lookup_type => 'BEN_ACTY_TYP',
634: p_lookup_code => p_acty_typ_cd,
635: p_effective_date => p_effective_date) then
636: --

Line 650: <> nvl(ben_ecr_shd.g_old_rec.tx_typ_cd,hr_api.g_varchar2)

646: end if;
647: --
648: if (l_api_updating
649: and p_tx_typ_cd
650: <> nvl(ben_ecr_shd.g_old_rec.tx_typ_cd,hr_api.g_varchar2)
651: or not l_api_updating) then
652: --
653: -- check if value of lookup falls within lookup type.
654: --

Line 655: if hr_api.not_exists_in_hr_lookups

651: or not l_api_updating) then
652: --
653: -- check if value of lookup falls within lookup type.
654: --
655: if hr_api.not_exists_in_hr_lookups
656: (p_lookup_type => 'BEN_TX_TYP',
657: p_lookup_code => p_tx_typ_cd,
658: p_effective_date => p_effective_date) then
659: --

Line 673: <> nvl(ben_ecr_shd.g_old_rec.nnmntry_uom,hr_api.g_varchar2)

669: end if;
670: --
671: if (l_api_updating
672: and p_nnmntry_uom
673: <> nvl(ben_ecr_shd.g_old_rec.nnmntry_uom,hr_api.g_varchar2)
674: or not l_api_updating)
675: and p_nnmntry_uom is not null then
676: --
677: -- check if value of lookup falls within lookup type.

Line 679: if hr_api.not_exists_in_hr_lookups

675: and p_nnmntry_uom is not null then
676: --
677: -- check if value of lookup falls within lookup type.
678: --
679: if hr_api.not_exists_in_hr_lookups
680: (p_lookup_type => 'BEN_NNMNTRY_UOM',
681: p_lookup_code => p_nnmntry_uom,
682: p_effective_date => p_effective_date) then
683: --

Line 697: <> nvl(ben_ecr_shd.g_old_rec.cmcd_acty_ref_perd_cd,hr_api.g_varchar2)

693: end if;
694: --
695: if (l_api_updating
696: and p_cmcd_acty_ref_perd_cd
697: <> nvl(ben_ecr_shd.g_old_rec.cmcd_acty_ref_perd_cd,hr_api.g_varchar2)
698: or not l_api_updating)
699: and p_cmcd_acty_ref_perd_cd is not null then
700: --
701: -- check if value of lookup falls within lookup type.

Line 703: if hr_api.not_exists_in_hr_lookups

699: and p_cmcd_acty_ref_perd_cd is not null then
700: --
701: -- check if value of lookup falls within lookup type.
702: --
703: if hr_api.not_exists_in_hr_lookups
704: (p_lookup_type => 'BEN_ENRT_INFO_RT_FREQ',
705: p_lookup_code => p_cmcd_acty_ref_perd_cd,
706: p_effective_date => p_effective_date) then
707: --

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

740: /*
741: --
742: -- Call all supporting business operations
743: --
744: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
745: */
746: --
747: -- Call all supporting business operations
748: --

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

813: /*
814: --
815: -- Call all supporting business operations
816: --
817: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
818: */
819: --
820: -- Call all supporting business operations
821: --

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

908: hr_utility.set_location('Entering:'|| l_proc, 10);
909: --
910: -- Ensure that all the mandatory parameter are not null
911: --
912: hr_api.mandatory_arg_error(p_api_name => l_proc,
913: p_argument => 'enrt_rt_id',
914: p_argument_value => p_enrt_rt_id);
915: --
916: open csr_leg_code;