APPS.BEN_EPE_INS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 53

Procedure insert_dml(p_rec in out nocopy ben_epe_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'insert_dml';

Line: 65

  insert into ben_elig_per_elctbl_chc
  (	elig_per_elctbl_chc_id,
--	enrt_typ_cycl_cd,
	enrt_cvg_strt_dt_cd,
--	enrt_perd_end_dt,
--	enrt_perd_strt_dt,
	enrt_cvg_strt_dt_rl,
--	rt_strt_dt,
--	rt_strt_dt_rl,
--	rt_strt_dt_cd,
        ctfn_rqd_flag,
        pil_elctbl_chc_popl_id,
	roll_crs_flag,
	crntly_enrd_flag,
	dflt_flag,
	elctbl_flag,
	mndtry_flag,
        in_pndg_wkflow_flag,
--	dflt_enrt_dt,
	dpnt_cvg_strt_dt_cd,
	dpnt_cvg_strt_dt_rl,
	enrt_cvg_strt_dt,
	alws_dpnt_dsgn_flag,
	dpnt_dsgn_cd,
	ler_chg_dpnt_cvg_cd,
	erlst_deenrt_dt,
	procg_end_dt,
	comp_lvl_cd,
	pl_id,
	oipl_id,
	pgm_id,
	plip_id,
	ptip_id,
	pl_typ_id,
	oiplip_id,
	cmbn_plip_id,
	cmbn_ptip_id,
	cmbn_ptip_opt_id,
        assignment_id,
	spcl_rt_pl_id,
	spcl_rt_oipl_id,
	must_enrl_anthr_pl_id,
	interim_elig_per_elctbl_chc_id,
	prtt_enrt_rslt_id,
	bnft_prvdr_pool_id,
	per_in_ler_id,
	yr_perd_id,
	auto_enrt_flag,
	business_group_id,
        pl_ordr_num,
        plip_ordr_num,
        ptip_ordr_num,
        oipl_ordr_num,
        -- cwb
        comments,
        elig_flag,
        elig_ovrid_dt,
        elig_ovrid_person_id,
        inelig_rsn_cd,
        mgr_ovrid_dt,
        mgr_ovrid_person_id,
        ws_mgr_id,
        -- cwb
	epe_attribute_category,
	epe_attribute1,
	epe_attribute2,
	epe_attribute3,
	epe_attribute4,
	epe_attribute5,
	epe_attribute6,
	epe_attribute7,
	epe_attribute8,
	epe_attribute9,
	epe_attribute10,
	epe_attribute11,
	epe_attribute12,
	epe_attribute13,
	epe_attribute14,
	epe_attribute15,
	epe_attribute16,
	epe_attribute17,
	epe_attribute18,
	epe_attribute19,
	epe_attribute20,
	epe_attribute21,
	epe_attribute22,
	epe_attribute23,
	epe_attribute24,
	epe_attribute25,
	epe_attribute26,
	epe_attribute27,
	epe_attribute28,
	epe_attribute29,
	epe_attribute30,
	approval_status_cd,
        fonm_cvg_strt_dt,
        cryfwd_elig_dpnt_cd,
	request_id,
	program_application_id,
	program_id,
	program_update_date,
	object_version_number
  )
  Values
  (	p_rec.elig_per_elctbl_chc_id,
--	p_rec.enrt_typ_cycl_cd,
	p_rec.enrt_cvg_strt_dt_cd,
--	p_rec.enrt_perd_end_dt,
--	p_rec.enrt_perd_strt_dt,
	p_rec.enrt_cvg_strt_dt_rl,
--	p_rec.rt_strt_dt,
--	p_rec.rt_strt_dt_rl,
--	p_rec.rt_strt_dt_cd,
        p_rec.ctfn_rqd_flag,
        p_rec.pil_elctbl_chc_popl_id,
	p_rec.roll_crs_flag,
	p_rec.crntly_enrd_flag,
	p_rec.dflt_flag,
	p_rec.elctbl_flag,
	p_rec.mndtry_flag,
        p_rec.in_pndg_wkflow_flag,
--	p_rec.dflt_enrt_dt,
	p_rec.dpnt_cvg_strt_dt_cd,
	p_rec.dpnt_cvg_strt_dt_rl,
	p_rec.enrt_cvg_strt_dt,
	p_rec.alws_dpnt_dsgn_flag,
	p_rec.dpnt_dsgn_cd,
	p_rec.ler_chg_dpnt_cvg_cd,
	p_rec.erlst_deenrt_dt,
	p_rec.procg_end_dt,
	p_rec.comp_lvl_cd,
	p_rec.pl_id,
	p_rec.oipl_id,
	p_rec.pgm_id,
	p_rec.plip_id,
	p_rec.ptip_id,
	p_rec.pl_typ_id,
	p_rec.oiplip_id,
	p_rec.cmbn_plip_id,
	p_rec.cmbn_ptip_id,
	p_rec.cmbn_ptip_opt_id,
        p_rec.assignment_id,
	p_rec.spcl_rt_pl_id,
	p_rec.spcl_rt_oipl_id,
	p_rec.must_enrl_anthr_pl_id,
	p_rec.int_elig_per_elctbl_chc_id,
	p_rec.prtt_enrt_rslt_id,
	p_rec.bnft_prvdr_pool_id,
	p_rec.per_in_ler_id,
	p_rec.yr_perd_id,
	p_rec.auto_enrt_flag,
	p_rec.business_group_id,
        p_rec.pl_ordr_num,
        p_rec.plip_ordr_num,
        p_rec.ptip_ordr_num,
        p_rec.oipl_ordr_num,
        -- cwb
        p_rec.comments,
        p_rec.elig_flag,
        p_rec.elig_ovrid_dt,
        p_rec.elig_ovrid_person_id,
        p_rec.inelig_rsn_cd,
        p_rec.mgr_ovrid_dt,
        p_rec.mgr_ovrid_person_id,
        p_rec.ws_mgr_id,
        -- cwb
	p_rec.epe_attribute_category,
	p_rec.epe_attribute1,
	p_rec.epe_attribute2,
	p_rec.epe_attribute3,
	p_rec.epe_attribute4,
	p_rec.epe_attribute5,
	p_rec.epe_attribute6,
	p_rec.epe_attribute7,
	p_rec.epe_attribute8,
	p_rec.epe_attribute9,
	p_rec.epe_attribute10,
	p_rec.epe_attribute11,
	p_rec.epe_attribute12,
	p_rec.epe_attribute13,
	p_rec.epe_attribute14,
	p_rec.epe_attribute15,
	p_rec.epe_attribute16,
	p_rec.epe_attribute17,
	p_rec.epe_attribute18,
	p_rec.epe_attribute19,
	p_rec.epe_attribute20,
	p_rec.epe_attribute21,
	p_rec.epe_attribute22,
	p_rec.epe_attribute23,
	p_rec.epe_attribute24,
	p_rec.epe_attribute25,
	p_rec.epe_attribute26,
	p_rec.epe_attribute27,
	p_rec.epe_attribute28,
	p_rec.epe_attribute29,
	p_rec.epe_attribute30,
	p_rec.approval_status_cd,
        p_rec.fonm_cvg_strt_dt,
        p_rec.cryfwd_elig_dpnt_cd,
	p_rec.request_id,
	p_rec.program_application_id,
	p_rec.program_id,
	p_rec.program_update_date,
	p_rec.object_version_number
  );

Line: 294

End insert_dml;

Line: 333

Procedure pre_insert(p_rec  in out nocopy ben_epe_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'pre_insert';

Line: 338

  Cursor C_Sel1 is select ben_elig_per_elctbl_chc_s.nextval from sys.dual;

Line: 350

End pre_insert;

Line: 384

Procedure post_insert(p_rec in ben_epe_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'post_insert';

Line: 392

End post_insert;

Line: 410

  ben_epe_bus.insert_validate(p_rec,p_effective_date);

Line: 414

  pre_insert(p_rec);

Line: 418

  insert_dml(p_rec);

Line: 422

  post_insert(p_rec);

Line: 530

  p_program_update_date          in date             default null,
  p_object_version_number        out nocopy number
  ) is
--
  l_rec	  ben_epe_shd.g_rec_type;

Line: 645

  p_program_update_date,
  null
  );