APPS.BEN_ELP_RKI SQL Statements

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

Line: 5

procedure AFTER_INSERT
(P_ELIGY_PRFL_ID in NUMBER
,P_EFFECTIVE_START_DATE in DATE
,P_EFFECTIVE_END_DATE in DATE
,P_NAME in VARCHAR2
,P_DESCRIPTION in VARCHAR2
,P_STAT_CD in VARCHAR2
,P_ASMT_TO_USE_CD in VARCHAR2
,P_ELIG_ENRLD_PLIP_FLAG in VARCHAR2
,P_ELIG_CBR_QUALD_BNF_FLAG in VARCHAR2
,P_ELIG_ENRLD_PTIP_FLAG in VARCHAR2
,P_ELIG_DPNT_CVRD_PLIP_FLAG in VARCHAR2
,P_ELIG_DPNT_CVRD_PTIP_FLAG in VARCHAR2
,P_ELIG_DPNT_CVRD_PGM_FLAG in VARCHAR2
,P_ELIG_JOB_FLAG in VARCHAR2
,P_ELIG_HRLY_SLRD_FLAG in VARCHAR2
,P_ELIG_PSTL_CD_FLAG in VARCHAR2
,P_ELIG_LBR_MMBR_FLAG in VARCHAR2
,P_ELIG_LGL_ENTY_FLAG in VARCHAR2
,P_ELIG_BENFTS_GRP_FLAG in VARCHAR2
,P_ELIG_WK_LOC_FLAG in VARCHAR2
,P_ELIG_BRGNG_UNIT_FLAG in VARCHAR2
,P_ELIG_AGE_FLAG in VARCHAR2
,P_ELIG_LOS_FLAG in VARCHAR2
,P_ELIG_PER_TYP_FLAG in VARCHAR2
,P_ELIG_FL_TM_PT_TM_FLAG in VARCHAR2
,P_ELIG_EE_STAT_FLAG in VARCHAR2
,P_ELIG_GRD_FLAG in VARCHAR2
,P_ELIG_PCT_FL_TM_FLAG in VARCHAR2
,P_ELIG_ASNT_SET_FLAG in VARCHAR2
,P_ELIG_HRS_WKD_FLAG in VARCHAR2
,P_ELIG_COMP_LVL_FLAG in VARCHAR2
,P_ELIG_ORG_UNIT_FLAG in VARCHAR2
,P_ELIG_LOA_RSN_FLAG in VARCHAR2
,P_ELIG_PYRL_FLAG in VARCHAR2
,P_ELIG_SCHEDD_HRS_FLAG in VARCHAR2
,P_ELIG_PY_BSS_FLAG in VARCHAR2
,P_ELIGY_PRFL_RL_FLAG in VARCHAR2
,P_ELIG_CMBN_AGE_LOS_FLAG in VARCHAR2
,P_CNTNG_PRTN_ELIG_PRFL_FLAG in VARCHAR2
,P_ELIG_PRTT_PL_FLAG in VARCHAR2
,P_ELIG_PPL_GRP_FLAG in VARCHAR2
,P_ELIG_SVC_AREA_FLAG in VARCHAR2
,P_ELIG_PTIP_PRTE_FLAG in VARCHAR2
,P_ELIG_NO_OTHR_CVG_FLAG in VARCHAR2
,P_ELIG_ENRLD_PL_FLAG in VARCHAR2
,P_ELIG_ENRLD_OIPL_FLAG in VARCHAR2
,P_ELIG_ENRLD_PGM_FLAG in VARCHAR2
,P_ELIG_DPNT_CVRD_PL_FLAG in VARCHAR2
,P_ELIG_LVG_RSN_FLAG in VARCHAR2
,P_ELIG_OPTD_MDCR_FLAG in VARCHAR2
,P_ELIG_TBCO_USE_FLAG in VARCHAR2
,P_ELIG_DPNT_OTHR_PTIP_FLAG in VARCHAR2
,P_BUSINESS_GROUP_ID in NUMBER
,P_ELP_ATTRIBUTE_CATEGORY in VARCHAR2
,P_ELP_ATTRIBUTE1 in VARCHAR2
,P_ELP_ATTRIBUTE2 in VARCHAR2
,P_ELP_ATTRIBUTE3 in VARCHAR2
,P_ELP_ATTRIBUTE4 in VARCHAR2
,P_ELP_ATTRIBUTE5 in VARCHAR2
,P_ELP_ATTRIBUTE6 in VARCHAR2
,P_ELP_ATTRIBUTE7 in VARCHAR2
,P_ELP_ATTRIBUTE8 in VARCHAR2
,P_ELP_ATTRIBUTE9 in VARCHAR2
,P_ELP_ATTRIBUTE10 in VARCHAR2
,P_ELP_ATTRIBUTE11 in VARCHAR2
,P_ELP_ATTRIBUTE12 in VARCHAR2
,P_ELP_ATTRIBUTE13 in VARCHAR2
,P_ELP_ATTRIBUTE14 in VARCHAR2
,P_ELP_ATTRIBUTE15 in VARCHAR2
,P_ELP_ATTRIBUTE16 in VARCHAR2
,P_ELP_ATTRIBUTE17 in VARCHAR2
,P_ELP_ATTRIBUTE18 in VARCHAR2
,P_ELP_ATTRIBUTE19 in VARCHAR2
,P_ELP_ATTRIBUTE20 in VARCHAR2
,P_ELP_ATTRIBUTE21 in VARCHAR2
,P_ELP_ATTRIBUTE22 in VARCHAR2
,P_ELP_ATTRIBUTE23 in VARCHAR2
,P_ELP_ATTRIBUTE24 in VARCHAR2
,P_ELP_ATTRIBUTE25 in VARCHAR2
,P_ELP_ATTRIBUTE26 in VARCHAR2
,P_ELP_ATTRIBUTE27 in VARCHAR2
,P_ELP_ATTRIBUTE28 in VARCHAR2
,P_ELP_ATTRIBUTE29 in VARCHAR2
,P_ELP_ATTRIBUTE30 in VARCHAR2
,P_ELIG_MRTL_STS_FLAG in VARCHAR2
,P_ELIG_GNDR_FLAG in VARCHAR2
,P_ELIG_DSBLTY_CTG_FLAG in VARCHAR2
,P_ELIG_DSBLTY_RSN_FLAG in VARCHAR2
,P_ELIG_DSBLTY_DGR_FLAG in VARCHAR2
,P_ELIG_SUPPL_ROLE_FLAG in VARCHAR2
,P_ELIG_QUAL_TITL_FLAG in VARCHAR2
,P_ELIG_PSTN_FLAG in VARCHAR2
,P_ELIG_PRBTN_PERD_FLAG in VARCHAR2
,P_ELIG_SP_CLNG_PRG_PT_FLAG in VARCHAR2
,P_BNFT_CAGR_PRTN_CD in VARCHAR2
,P_ELIG_DSBLD_FLAG in VARCHAR2
,P_ELIG_TTL_CVG_VOL_FLAG in VARCHAR2
,P_ELIG_TTL_PRTT_FLAG in VARCHAR2
,P_ELIG_COMPTNCY_FLAG in VARCHAR2
,P_ELIG_HLTH_CVG_FLAG in VARCHAR2
,P_ELIG_ANTHR_PL_FLAG in VARCHAR2
,P_ELIG_QUA_IN_GR_FLAG in VARCHAR2
,P_ELIG_PERF_RTNG_FLAG in VARCHAR2
,P_ELIG_CRIT_VALUES_FLAG in VARCHAR2
,P_OBJECT_VERSION_NUMBER in NUMBER
,P_EFFECTIVE_DATE in DATE
,P_VALIDATION_START_DATE in DATE
,P_VALIDATION_END_DATE in DATE
)is
begin
hr_utility.set_location('Entering: ben_elp_RKI.AFTER_INSERT', 10);

Line: 117

hr_utility.set_location(' Leaving: ben_elp_RKI.AFTER_INSERT', 20);

Line: 118

end AFTER_INSERT;