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 224: -- Create or find ben_pil_elctbl_chc_popl

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

Line 420: ben_Pil_Elctbl_chc_Popl_api.create_Pil_Elctbl_chc_Popl

416: --
417: hr_utility.set_location(' l_reinstate_cd '||l_reinstate_cd,100);
418: hr_utility.set_location(' l_reinstate_ovrdn_cd '||l_reinstate_ovrdn_cd,100);
419: --
420: ben_Pil_Elctbl_chc_Popl_api.create_Pil_Elctbl_chc_Popl
421: (p_validate => FALSE
422: ,p_pil_elctbl_chc_popl_id => l_pil_elctbl_chc_popl_id
423: ,p_dflt_enrt_dt => l_dflt_enrt_dt
424: ,p_cls_enrt_dt_to_use_cd => l_cls_enrt_dt_to_use_cd

Line 469: update ben_Pil_Elctbl_chc_Popl

465: end if;
466: if g_debug then
467: hr_utility.set_location('p_assignment_id '|| p_assignment_id, 10);
468: end if;
469: update ben_Pil_Elctbl_chc_Popl
470: set ws_mgr_id = p_ws_mgr_id,
471: assignment_id = p_assignment_id
472: where Pil_Elctbl_chc_Popl_id = l_pil_elctbl_chc_popl_id;
473: if g_debug then

Line 549: ben_Pil_Elctbl_chc_Popl_api.update_Pil_Elctbl_chc_Popl

545: if l_update_pel then
546: if g_debug then
547: hr_utility.set_location('BPECPAPI_UPD: '|| l_proc, 10);
548: end if;
549: ben_Pil_Elctbl_chc_Popl_api.update_Pil_Elctbl_chc_Popl
550: (p_validate => FALSE
551: ,p_pil_elctbl_chc_popl_id => l_pil_elctbl_chc_popl_id
552: ,p_object_version_number => l_pel_ovn
553: ,p_dflt_enrt_dt => l_pel_dflt_enrt_dt

Line 730: -- Create or find ben_pil_elctbl_chc_popl

726: --
727: savepoint create_ELIG_PER_ELC_CHC;
728: --
729: --
730: -- Create or find ben_pil_elctbl_chc_popl
731: --
732: CreOrSel_pil_elctbl_chc_popl
733: (p_per_in_ler_id => p_per_in_ler_id
734: ,p_effective_date => p_effective_date

Line 1301: -- Create or find ben_pil_elctbl_chc_popl

1297: -- Issue a savepoint if operating in validation only mode
1298: --
1299: savepoint create_perf_ELIG_PER_ELC_CHC;
1300: --
1301: -- Create or find ben_pil_elctbl_chc_popl
1302: --
1303: CreOrSel_pil_elctbl_chc_popl
1304: (p_per_in_ler_id => p_per_in_ler_id
1305: ,p_effective_date => p_effective_date