APPS.BEN_VPF_RKD SQL Statements

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

Line: 5

procedure AFTER_DELETE
(P_VRBL_RT_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_PL_TYP_OPT_TYP_ID_O in NUMBER
,P_PL_ID_O in NUMBER
,P_OIPL_ID_O in NUMBER
,P_COMP_LVL_FCTR_ID_O in NUMBER
,P_BUSINESS_GROUP_ID_O in NUMBER
,P_ACTY_TYP_CD_O in VARCHAR2
,P_RT_TYP_CD_O in VARCHAR2
,P_BNFT_RT_TYP_CD_O in VARCHAR2
,P_TX_TYP_CD_O in VARCHAR2
,P_VRBL_RT_TRTMT_CD_O in VARCHAR2
,P_ACTY_REF_PERD_CD_O in VARCHAR2
,P_MLT_CD_O in VARCHAR2
,P_INCRMNT_ELCN_VAL_O in NUMBER
,P_DFLT_ELCN_VAL_O in NUMBER
,P_MX_ELCN_VAL_O in NUMBER
,P_MN_ELCN_VAL_O in NUMBER
,P_LWR_LMT_VAL_O in NUMBER
,P_LWR_LMT_CALC_RL_O in NUMBER
,P_UPR_LMT_VAL_O in NUMBER
,P_UPR_LMT_CALC_RL_O in NUMBER
,P_ULTMT_UPR_LMT_O in NUMBER
,P_ULTMT_LWR_LMT_O in NUMBER
,P_ULTMT_UPR_LMT_CALC_RL_O in NUMBER
,P_ULTMT_LWR_LMT_CALC_RL_O in NUMBER
,P_ANN_MN_ELCN_VAL_O in NUMBER
,P_ANN_MX_ELCN_VAL_O in NUMBER
,P_VAL_O in NUMBER
,P_NAME_O in VARCHAR2
,P_NO_MN_ELCN_VAL_DFND_FLAG_O in VARCHAR2
,P_NO_MX_ELCN_VAL_DFND_FLAG_O in VARCHAR2
,P_ALWYS_SUM_ALL_CVG_FLAG_O in VARCHAR2
,P_ALWYS_CNT_ALL_PRTTS_FLAG_O in VARCHAR2
,P_VAL_CALC_RL_O in NUMBER
,P_VRBL_RT_PRFL_STAT_CD_O in VARCHAR2
,P_VRBL_USG_CD_O in VARCHAR2
,P_ASMT_TO_USE_CD_O in VARCHAR2
,P_RNDG_CD_O in VARCHAR2
,P_RNDG_RL_O in NUMBER
,P_RT_HRLY_SLRD_FLAG_O in VARCHAR2
,P_RT_PSTL_CD_FLAG_O in VARCHAR2
,P_RT_LBR_MMBR_FLAG_O in VARCHAR2
,P_RT_LGL_ENTY_FLAG_O in VARCHAR2
,P_RT_BENFTS_GRP_FLAG_O in VARCHAR2
,P_RT_WK_LOC_FLAG_O in VARCHAR2
,P_RT_BRGNG_UNIT_FLAG_O in VARCHAR2
,P_RT_AGE_FLAG_O in VARCHAR2
,P_RT_LOS_FLAG_O in VARCHAR2
,P_RT_PER_TYP_FLAG_O in VARCHAR2
,P_RT_FL_TM_PT_TM_FLAG_O in VARCHAR2
,P_RT_EE_STAT_FLAG_O in VARCHAR2
,P_RT_GRD_FLAG_O in VARCHAR2
,P_RT_PCT_FL_TM_FLAG_O in VARCHAR2
,P_RT_ASNT_SET_FLAG_O in VARCHAR2
,P_RT_HRS_WKD_FLAG_O in VARCHAR2
,P_RT_COMP_LVL_FLAG_O in VARCHAR2
,P_RT_ORG_UNIT_FLAG_O in VARCHAR2
,P_RT_LOA_RSN_FLAG_O in VARCHAR2
,P_RT_PYRL_FLAG_O in VARCHAR2
,P_RT_SCHEDD_HRS_FLAG_O in VARCHAR2
,P_RT_PY_BSS_FLAG_O in VARCHAR2
,P_RT_PRFL_RL_FLAG_O in VARCHAR2
,P_RT_CMBN_AGE_LOS_FLAG_O in VARCHAR2
,P_RT_PRTT_PL_FLAG_O in VARCHAR2
,P_RT_SVC_AREA_FLAG_O in VARCHAR2
,P_RT_PPL_GRP_FLAG_O in VARCHAR2
,P_RT_DSBLD_FLAG_O in VARCHAR2
,P_RT_HLTH_CVG_FLAG_O in VARCHAR2
,P_RT_POE_FLAG_O in VARCHAR2
,P_RT_TTL_CVG_VOL_FLAG_O in VARCHAR2
,P_RT_TTL_PRTT_FLAG_O in VARCHAR2
,P_RT_GNDR_FLAG_O in VARCHAR2
,P_RT_TBCO_USE_FLAG_O in VARCHAR2
,P_VPF_ATTRIBUTE_CATEGORY_O in VARCHAR2
,P_VPF_ATTRIBUTE1_O in VARCHAR2
,P_VPF_ATTRIBUTE2_O in VARCHAR2
,P_VPF_ATTRIBUTE3_O in VARCHAR2
,P_VPF_ATTRIBUTE4_O in VARCHAR2
,P_VPF_ATTRIBUTE5_O in VARCHAR2
,P_VPF_ATTRIBUTE6_O in VARCHAR2
,P_VPF_ATTRIBUTE7_O in VARCHAR2
,P_VPF_ATTRIBUTE8_O in VARCHAR2
,P_VPF_ATTRIBUTE9_O in VARCHAR2
,P_VPF_ATTRIBUTE10_O in VARCHAR2
,P_VPF_ATTRIBUTE11_O in VARCHAR2
,P_VPF_ATTRIBUTE12_O in VARCHAR2
,P_VPF_ATTRIBUTE13_O in VARCHAR2
,P_VPF_ATTRIBUTE14_O in VARCHAR2
,P_VPF_ATTRIBUTE15_O in VARCHAR2
,P_VPF_ATTRIBUTE16_O in VARCHAR2
,P_VPF_ATTRIBUTE17_O in VARCHAR2
,P_VPF_ATTRIBUTE18_O in VARCHAR2
,P_VPF_ATTRIBUTE19_O in VARCHAR2
,P_VPF_ATTRIBUTE20_O in VARCHAR2
,P_VPF_ATTRIBUTE21_O in VARCHAR2
,P_VPF_ATTRIBUTE22_O in VARCHAR2
,P_VPF_ATTRIBUTE23_O in VARCHAR2
,P_VPF_ATTRIBUTE24_O in VARCHAR2
,P_VPF_ATTRIBUTE25_O in VARCHAR2
,P_VPF_ATTRIBUTE26_O in VARCHAR2
,P_VPF_ATTRIBUTE27_O in VARCHAR2
,P_VPF_ATTRIBUTE28_O in VARCHAR2
,P_VPF_ATTRIBUTE29_O in VARCHAR2
,P_VPF_ATTRIBUTE30_O in VARCHAR2
,P_OBJECT_VERSION_NUMBER_O in NUMBER
,P_RT_CNTNG_PRTN_PRFL_FLAG_O in VARCHAR2
,P_RT_CBR_QUALD_BNF_FLAG_O in VARCHAR2
,P_RT_OPTD_MDCR_FLAG_O in VARCHAR2
,P_RT_LVG_RSN_FLAG_O in VARCHAR2
,P_RT_PSTN_FLAG_O in VARCHAR2
,P_RT_COMPTNCY_FLAG_O in VARCHAR2
,P_RT_JOB_FLAG_O in VARCHAR2
,P_RT_QUAL_TITL_FLAG_O in VARCHAR2
,P_RT_DPNT_CVRD_PL_FLAG_O in VARCHAR2
,P_RT_DPNT_CVRD_PLIP_FLAG_O in VARCHAR2
,P_RT_DPNT_CVRD_PTIP_FLAG_O in VARCHAR2
,P_RT_DPNT_CVRD_PGM_FLAG_O in VARCHAR2
,P_RT_ENRLD_OIPL_FLAG_O in VARCHAR2
,P_RT_ENRLD_PL_FLAG_O in VARCHAR2
,P_RT_ENRLD_PLIP_FLAG_O in VARCHAR2
,P_RT_ENRLD_PTIP_FLAG_O in VARCHAR2
,P_RT_ENRLD_PGM_FLAG_O in VARCHAR2
,P_RT_PRTT_ANTHR_PL_FLAG_O in VARCHAR2
,P_RT_OTHR_PTIP_FLAG_O in VARCHAR2
,P_RT_NO_OTHR_CVG_FLAG_O in VARCHAR2
,P_RT_DPNT_OTHR_PTIP_FLAG_O in VARCHAR2
,P_RT_QUA_IN_GR_FLAG_O in VARCHAR2
,P_RT_PERF_RTNG_FLAG_O in VARCHAR2
,P_RT_ELIG_PRFL_FLAG_O in VARCHAR2
)is
begin
hr_utility.set_location('Entering: ben_vpf_RKD.AFTER_DELETE', 10);

Line: 145

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

Line: 146

end AFTER_DELETE;