eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_EPE_RKD SQL Statements

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

Line: 5


procedure AFTER_DELETE
(P_ELIG_PER_ELCTBL_CHC_ID in NUMBER
,P_ENRT_CVG_STRT_DT_CD_O in VARCHAR2
,P_ENRT_CVG_STRT_DT_RL_O in VARCHAR2
,P_CTFN_RQD_FLAG_O in VARCHAR2
,P_PIL_ELCTBL_CHC_POPL_ID_O in NUMBER
,P_ROLL_CRS_FLAG_O in VARCHAR2
,P_CRNTLY_ENRD_FLAG_O in VARCHAR2
,P_DFLT_FLAG_O in VARCHAR2
,P_ELCTBL_FLAG_O in VARCHAR2
,P_MNDTRY_FLAG_O in VARCHAR2
,P_IN_PNDG_WKFLOW_FLAG_O in VARCHAR2
,P_DPNT_CVG_STRT_DT_CD_O in VARCHAR2
,P_DPNT_CVG_STRT_DT_RL_O in VARCHAR2
,P_ENRT_CVG_STRT_DT_O in DATE
,P_ALWS_DPNT_DSGN_FLAG_O in VARCHAR2
,P_DPNT_DSGN_CD_O in VARCHAR2
,P_LER_CHG_DPNT_CVG_CD_O in VARCHAR2
,P_ERLST_DEENRT_DT_O in DATE
,P_PROCG_END_DT_O in DATE
,P_COMP_LVL_CD_O in VARCHAR2
,P_PL_ID_O in NUMBER
,P_OIPL_ID_O in NUMBER
,P_PGM_ID_O in NUMBER
,P_PLIP_ID_O in NUMBER
,P_PTIP_ID_O in NUMBER
,P_PL_TYP_ID_O in NUMBER
,P_OIPLIP_ID_O in NUMBER
,P_CMBN_PLIP_ID_O in NUMBER
,P_CMBN_PTIP_ID_O in NUMBER
,P_CMBN_PTIP_OPT_ID_O in NUMBER
,P_ASSIGNMENT_ID_O in NUMBER
,P_SPCL_RT_PL_ID_O in NUMBER
,P_SPCL_RT_OIPL_ID_O in NUMBER
,P_MUST_ENRL_ANTHR_PL_ID_O in NUMBER
,P_INT_ELIG_PER_ELCTBL_CHC_ID_O in NUMBER
,P_PRTT_ENRT_RSLT_ID_O in NUMBER
,P_BNFT_PRVDR_POOL_ID_O in NUMBER
,P_PER_IN_LER_ID_O in NUMBER
,P_YR_PERD_ID_O in NUMBER
,P_AUTO_ENRT_FLAG_O in VARCHAR2
,P_BUSINESS_GROUP_ID_O in NUMBER
,P_PL_ORDR_NUM_O in NUMBER
,P_PLIP_ORDR_NUM_O in NUMBER
,P_PTIP_ORDR_NUM_O in NUMBER
,P_OIPL_ORDR_NUM_O in NUMBER
,P_COMMENTS_O in VARCHAR2
,P_ELIG_FLAG_O in VARCHAR2
,P_ELIG_OVRID_DT_O in DATE
,P_ELIG_OVRID_PERSON_ID_O in NUMBER
,P_INELIG_RSN_CD_O in VARCHAR2
,P_MGR_OVRID_DT_O in DATE
,P_MGR_OVRID_PERSON_ID_O in NUMBER
,P_WS_MGR_ID_O in NUMBER
,P_EPE_ATTRIBUTE_CATEGORY_O in VARCHAR2
,P_EPE_ATTRIBUTE1_O in VARCHAR2
,P_EPE_ATTRIBUTE2_O in VARCHAR2
,P_EPE_ATTRIBUTE3_O in VARCHAR2
,P_EPE_ATTRIBUTE4_O in VARCHAR2
,P_EPE_ATTRIBUTE5_O in VARCHAR2
,P_EPE_ATTRIBUTE6_O in VARCHAR2
,P_EPE_ATTRIBUTE7_O in VARCHAR2
,P_EPE_ATTRIBUTE8_O in VARCHAR2
,P_EPE_ATTRIBUTE9_O in VARCHAR2
,P_EPE_ATTRIBUTE10_O in VARCHAR2
,P_EPE_ATTRIBUTE11_O in VARCHAR2
,P_EPE_ATTRIBUTE12_O in VARCHAR2
,P_EPE_ATTRIBUTE13_O in VARCHAR2
,P_EPE_ATTRIBUTE14_O in VARCHAR2
,P_EPE_ATTRIBUTE15_O in VARCHAR2
,P_EPE_ATTRIBUTE16_O in VARCHAR2
,P_EPE_ATTRIBUTE17_O in VARCHAR2
,P_EPE_ATTRIBUTE18_O in VARCHAR2
,P_EPE_ATTRIBUTE19_O in VARCHAR2
,P_EPE_ATTRIBUTE20_O in VARCHAR2
,P_EPE_ATTRIBUTE21_O in VARCHAR2
,P_EPE_ATTRIBUTE22_O in VARCHAR2
,P_EPE_ATTRIBUTE23_O in VARCHAR2
,P_EPE_ATTRIBUTE24_O in VARCHAR2
,P_EPE_ATTRIBUTE25_O in VARCHAR2
,P_EPE_ATTRIBUTE26_O in VARCHAR2
,P_EPE_ATTRIBUTE27_O in VARCHAR2
,P_EPE_ATTRIBUTE28_O in VARCHAR2
,P_EPE_ATTRIBUTE29_O in VARCHAR2
,P_EPE_ATTRIBUTE30_O in VARCHAR2
,P_APPROVAL_STATUS_CD_O in VARCHAR2
,P_FONM_CVG_STRT_DT_O in DATE
,P_CRYFWD_ELIG_DPNT_CD_O in VARCHAR2
,P_REQUEST_ID_O in NUMBER
,P_PROGRAM_APPLICATION_ID_O in NUMBER
,P_PROGRAM_ID_O in NUMBER
,P_PROGRAM_UPDATE_DATE_O in DATE
,P_OBJECT_VERSION_NUMBER_O in NUMBER
)is
begin
hr_utility.set_location('Entering: ben_epe_RKD.AFTER_DELETE', 10);

Line: 101


hr_utility.set_location(' Leaving: ben_epe_RKD.AFTER_DELETE', 20);

Line: 102


end AFTER_DELETE;