APPS.BEN_ELIG_PER_ELC_CHC_API dependencies on BEN_PIL_ELCTBL_CHC_POPL

Line 13: -- Create or select ben_pil_elctbl_chc_popl

9: -- ----------------------------------------------------------------------------
10: -- |----------------------< CreOrSel_pil_elctbl_chc_popl >--------------------|
11: -- ----------------------------------------------------------------------------
12: --
13: -- Create or select ben_pil_elctbl_chc_popl
14: --
15: procedure CreOrSel_pil_elctbl_chc_popl
16: (p_per_in_ler_id in number
17: ,p_effective_date in date

Line 52: l_cbr_elig_perd_strt_dt ben_pil_elctbl_chc_popl.cbr_elig_perd_strt_dt%TYPE;

48: l_proc varchar2(72) ;
49: --
50: l_elig_per_elctbl_chc_id ben_elig_per_elctbl_chc.elig_per_elctbl_chc_id%TYPE;
51: l_object_version_number ben_elig_per_elctbl_chc.object_version_number%TYPE;
52: l_cbr_elig_perd_strt_dt ben_pil_elctbl_chc_popl.cbr_elig_perd_strt_dt%TYPE;
53: l_cbr_elig_perd_end_dt ben_pil_elctbl_chc_popl.cbr_elig_perd_end_dt%TYPE;
54: l_pel_pl_id number;
55: l_pel_pgm_id number;
56: l_pil_elctbl_chc_popl_id number;

Line 53: l_cbr_elig_perd_end_dt ben_pil_elctbl_chc_popl.cbr_elig_perd_end_dt%TYPE;

49: --
50: l_elig_per_elctbl_chc_id ben_elig_per_elctbl_chc.elig_per_elctbl_chc_id%TYPE;
51: l_object_version_number ben_elig_per_elctbl_chc.object_version_number%TYPE;
52: l_cbr_elig_perd_strt_dt ben_pil_elctbl_chc_popl.cbr_elig_perd_strt_dt%TYPE;
53: l_cbr_elig_perd_end_dt ben_pil_elctbl_chc_popl.cbr_elig_perd_end_dt%TYPE;
54: l_pel_pl_id number;
55: l_pel_pgm_id number;
56: l_pil_elctbl_chc_popl_id number;
57: l_pel_ovn number;

Line 89: from ben_pil_elctbl_chc_popl

85: enrt_perd_id,
86: procg_end_dt,
87: uom,
88: acty_ref_perd_cd
89: from ben_pil_elctbl_chc_popl
90: where
91: per_in_ler_id=p_per_in_ler_id and
92: pgm_id=l_pel_pgm_id
93: ;

Line 109: from ben_pil_elctbl_chc_popl

105: enrt_perd_id,
106: procg_end_dt,
107: uom,
108: acty_ref_perd_cd
109: from ben_pil_elctbl_chc_popl
110: where
111: per_in_ler_id=p_per_in_ler_id and
112: pl_id=l_pel_pl_id
113: ;

Line 221: -- Create or find ben_pil_elctbl_chc_popl

217: hr_utility.set_location(' p_enrt_perd_id '||p_enrt_perd_id,120);
218: --
219: end if;
220: --
221: -- Create or find ben_pil_elctbl_chc_popl
222: --
223: -- Determine if plan or program level record is needed
224: --
225: if p_pgm_id is not null then

Line 416: ben_Pil_Elctbl_chc_Popl_api.create_Pil_Elctbl_chc_Popl

412: --
413: hr_utility.set_location(' l_reinstate_cd '||l_reinstate_cd,100);
414: hr_utility.set_location(' l_reinstate_ovrdn_cd '||l_reinstate_ovrdn_cd,100);
415: --
416: ben_Pil_Elctbl_chc_Popl_api.create_Pil_Elctbl_chc_Popl
417: (p_validate => FALSE
418: ,p_pil_elctbl_chc_popl_id => l_pil_elctbl_chc_popl_id
419: ,p_dflt_enrt_dt => l_dflt_enrt_dt
420: ,p_cls_enrt_dt_to_use_cd => l_cls_enrt_dt_to_use_cd

Line 464: update ben_Pil_Elctbl_chc_Popl

460: end if;
461: if g_debug then
462: hr_utility.set_location('p_assignment_id '|| p_assignment_id, 10);
463: end if;
464: update ben_Pil_Elctbl_chc_Popl
465: set ws_mgr_id = p_ws_mgr_id,
466: assignment_id = p_assignment_id
467: where Pil_Elctbl_chc_Popl_id = l_pil_elctbl_chc_popl_id;
468: if g_debug then

Line 544: ben_Pil_Elctbl_chc_Popl_api.update_Pil_Elctbl_chc_Popl

540: if l_update_pel then
541: if g_debug then
542: hr_utility.set_location('BPECPAPI_UPD: '|| l_proc, 10);
543: end if;
544: ben_Pil_Elctbl_chc_Popl_api.update_Pil_Elctbl_chc_Popl
545: (p_validate => FALSE
546: ,p_pil_elctbl_chc_popl_id => l_pil_elctbl_chc_popl_id
547: ,p_object_version_number => l_pel_ovn
548: ,p_dflt_enrt_dt => l_pel_dflt_enrt_dt

Line 725: -- Create or find ben_pil_elctbl_chc_popl

721: --
722: savepoint create_ELIG_PER_ELC_CHC;
723: --
724: --
725: -- Create or find ben_pil_elctbl_chc_popl
726: --
727: CreOrSel_pil_elctbl_chc_popl
728: (p_per_in_ler_id => p_per_in_ler_id
729: ,p_effective_date => p_effective_date

Line 1296: -- Create or find ben_pil_elctbl_chc_popl

1292: -- Issue a savepoint if operating in validation only mode
1293: --
1294: savepoint create_perf_ELIG_PER_ELC_CHC;
1295: --
1296: -- Create or find ben_pil_elctbl_chc_popl
1297: --
1298: CreOrSel_pil_elctbl_chc_popl
1299: (p_per_in_ler_id => p_per_in_ler_id
1300: ,p_effective_date => p_effective_date