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_ELP_RKD SQL Statements

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

Line: 5


procedure AFTER_DELETE
(P_ELIGY_PRFL_ID in NUMBER
,P_DATETRACK_MODE in VARCHAR2
,P_VALIDATION_START_DATE in DATE
,P_VALIDATION_END_DATE in DATE
,P_EFFECTIVE_START_DATE in DATE
,P_EFFECTIVE_END_DATE in DATE
,P_EFFECTIVE_START_DATE_O in DATE
,P_EFFECTIVE_END_DATE_O in DATE
,P_NAME_O in VARCHAR2
,P_DESCRIPTION_O in VARCHAR2
,P_STAT_CD_O in VARCHAR2
,P_ASMT_TO_USE_CD_O in VARCHAR2
,P_ELIG_ENRLD_PLIP_FLAG_O in VARCHAR2
,P_ELIG_CBR_QUALD_BNF_FLAG_O in VARCHAR2
,P_ELIG_ENRLD_PTIP_FLAG_O in VARCHAR2
,P_ELIG_DPNT_CVRD_PLIP_FLAG_O in VARCHAR2
,P_ELIG_DPNT_CVRD_PTIP_FLAG_O in VARCHAR2
,P_ELIG_DPNT_CVRD_PGM_FLAG_O in VARCHAR2
,P_ELIG_JOB_FLAG_O in VARCHAR2
,P_ELIG_HRLY_SLRD_FLAG_O in VARCHAR2
,P_ELIG_PSTL_CD_FLAG_O in VARCHAR2
,P_ELIG_LBR_MMBR_FLAG_O in VARCHAR2
,P_ELIG_LGL_ENTY_FLAG_O in VARCHAR2
,P_ELIG_BENFTS_GRP_FLAG_O in VARCHAR2
,P_ELIG_WK_LOC_FLAG_O in VARCHAR2
,P_ELIG_BRGNG_UNIT_FLAG_O in VARCHAR2
,P_ELIG_AGE_FLAG_O in VARCHAR2
,P_ELIG_LOS_FLAG_O in VARCHAR2
,P_ELIG_PER_TYP_FLAG_O in VARCHAR2
,P_ELIG_FL_TM_PT_TM_FLAG_O in VARCHAR2
,P_ELIG_EE_STAT_FLAG_O in VARCHAR2
,P_ELIG_GRD_FLAG_O in VARCHAR2
,P_ELIG_PCT_FL_TM_FLAG_O in VARCHAR2
,P_ELIG_ASNT_SET_FLAG_O in VARCHAR2
,P_ELIG_HRS_WKD_FLAG_O in VARCHAR2
,P_ELIG_COMP_LVL_FLAG_O in VARCHAR2
,P_ELIG_ORG_UNIT_FLAG_O in VARCHAR2
,P_ELIG_LOA_RSN_FLAG_O in VARCHAR2
,P_ELIG_PYRL_FLAG_O in VARCHAR2
,P_ELIG_SCHEDD_HRS_FLAG_O in VARCHAR2
,P_ELIG_PY_BSS_FLAG_O in VARCHAR2
,P_ELIGY_PRFL_RL_FLAG_O in VARCHAR2
,P_ELIG_CMBN_AGE_LOS_FLAG_O in VARCHAR2
,P_CNTNG_PRTN_ELIG_PRFL_FLAG_O in VARCHAR2
,P_ELIG_PRTT_PL_FLAG_O in VARCHAR2
,P_ELIG_PPL_GRP_FLAG_O in VARCHAR2
,P_ELIG_SVC_AREA_FLAG_O in VARCHAR2
,P_ELIG_PTIP_PRTE_FLAG_O in VARCHAR2
,P_ELIG_NO_OTHR_CVG_FLAG_O in VARCHAR2
,P_ELIG_ENRLD_PL_FLAG_O in VARCHAR2
,P_ELIG_ENRLD_OIPL_FLAG_O in VARCHAR2
,P_ELIG_ENRLD_PGM_FLAG_O in VARCHAR2
,P_ELIG_DPNT_CVRD_PL_FLAG_O in VARCHAR2
,P_ELIG_LVG_RSN_FLAG_O in VARCHAR2
,P_ELIG_OPTD_MDCR_FLAG_O in VARCHAR2
,P_ELIG_TBCO_USE_FLAG_O in VARCHAR2
,P_ELIG_DPNT_OTHR_PTIP_FLAG_O in VARCHAR2
,P_BUSINESS_GROUP_ID_O in NUMBER
,P_ELP_ATTRIBUTE_CATEGORY_O in VARCHAR2
,P_ELP_ATTRIBUTE1_O in VARCHAR2
,P_ELP_ATTRIBUTE2_O in VARCHAR2
,P_ELP_ATTRIBUTE3_O in VARCHAR2
,P_ELP_ATTRIBUTE4_O in VARCHAR2
,P_ELP_ATTRIBUTE5_O in VARCHAR2
,P_ELP_ATTRIBUTE6_O in VARCHAR2
,P_ELP_ATTRIBUTE7_O in VARCHAR2
,P_ELP_ATTRIBUTE8_O in VARCHAR2
,P_ELP_ATTRIBUTE9_O in VARCHAR2
,P_ELP_ATTRIBUTE10_O in VARCHAR2
,P_ELP_ATTRIBUTE11_O in VARCHAR2
,P_ELP_ATTRIBUTE12_O in VARCHAR2
,P_ELP_ATTRIBUTE13_O in VARCHAR2
,P_ELP_ATTRIBUTE14_O in VARCHAR2
,P_ELP_ATTRIBUTE15_O in VARCHAR2
,P_ELP_ATTRIBUTE16_O in VARCHAR2
,P_ELP_ATTRIBUTE17_O in VARCHAR2
,P_ELP_ATTRIBUTE18_O in VARCHAR2
,P_ELP_ATTRIBUTE19_O in VARCHAR2
,P_ELP_ATTRIBUTE20_O in VARCHAR2
,P_ELP_ATTRIBUTE21_O in VARCHAR2
,P_ELP_ATTRIBUTE22_O in VARCHAR2
,P_ELP_ATTRIBUTE23_O in VARCHAR2
,P_ELP_ATTRIBUTE24_O in VARCHAR2
,P_ELP_ATTRIBUTE25_O in VARCHAR2
,P_ELP_ATTRIBUTE26_O in VARCHAR2
,P_ELP_ATTRIBUTE27_O in VARCHAR2
,P_ELP_ATTRIBUTE28_O in VARCHAR2
,P_ELP_ATTRIBUTE29_O in VARCHAR2
,P_ELP_ATTRIBUTE30_O in VARCHAR2
,P_ELIG_MRTL_STS_FLAG_O in VARCHAR2
,P_ELIG_GNDR_FLAG_O in VARCHAR2
,P_ELIG_DSBLTY_CTG_FLAG_O in VARCHAR2
,P_ELIG_DSBLTY_RSN_FLAG_O in VARCHAR2
,P_ELIG_DSBLTY_DGR_FLAG_O in VARCHAR2
,P_ELIG_SUPPL_ROLE_FLAG_O in VARCHAR2
,P_ELIG_QUAL_TITL_FLAG_O in VARCHAR2
,P_ELIG_PSTN_FLAG_O in VARCHAR2
,P_ELIG_PRBTN_PERD_FLAG_O in VARCHAR2
,P_ELIG_SP_CLNG_PRG_PT_FLAG_O in VARCHAR2
,P_BNFT_CAGR_PRTN_CD_O in VARCHAR2
,P_ELIG_DSBLD_FLAG_O in VARCHAR2
,P_ELIG_TTL_CVG_VOL_FLAG_O in VARCHAR2
,P_ELIG_TTL_PRTT_FLAG_O in VARCHAR2
,P_ELIG_COMPTNCY_FLAG_O in VARCHAR2
,P_ELIG_HLTH_CVG_FLAG_O in VARCHAR2
,P_ELIG_ANTHR_PL_FLAG_O in VARCHAR2
,P_ELIG_QUA_IN_GR_FLAG_O in VARCHAR2
,P_ELIG_PERF_RTNG_FLAG_O in VARCHAR2
,P_ELIG_CRIT_VALUES_FLAG_O in VARCHAR2
,P_OBJECT_VERSION_NUMBER_O in NUMBER
)is
begin
hr_utility.set_location('Entering: ben_elp_RKD.AFTER_DELETE', 10);

Line: 119


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

Line: 120


end AFTER_DELETE;