DBA Data[Home] [Help]

APPS.BEN_CPP_RKI SQL Statements

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

Line: 5

procedure AFTER_INSERT
(P_PLIP_ID in NUMBER
,P_EFFECTIVE_START_DATE in DATE
,P_EFFECTIVE_END_DATE in DATE
,P_BUSINESS_GROUP_ID in NUMBER
,P_PGM_ID in NUMBER
,P_PL_ID in NUMBER
,P_CMBN_PLIP_ID in NUMBER
,P_DFLT_FLAG in VARCHAR2
,P_PLIP_STAT_CD in VARCHAR2
,P_DFLT_ENRT_CD in VARCHAR2
,P_DFLT_ENRT_DET_RL in NUMBER
,P_ORDR_NUM in NUMBER
,P_ALWS_UNRSTRCTD_ENRT_FLAG in VARCHAR2
,P_AUTO_ENRT_MTHD_RL in NUMBER
,P_ENRT_CD in VARCHAR2
,P_ENRT_MTHD_CD in VARCHAR2
,P_ENRT_RL in NUMBER
,P_IVR_IDENT in VARCHAR2
,P_URL_REF_NAME in VARCHAR2
,P_ENRT_CVG_STRT_DT_CD in VARCHAR2
,P_ENRT_CVG_STRT_DT_RL in NUMBER
,P_ENRT_CVG_END_DT_CD in VARCHAR2
,P_ENRT_CVG_END_DT_RL in NUMBER
,P_RT_STRT_DT_CD in VARCHAR2
,P_RT_STRT_DT_RL in NUMBER
,P_RT_END_DT_CD in VARCHAR2
,P_RT_END_DT_RL in NUMBER
,P_DRVBL_FCTR_APLS_RTS_FLAG in VARCHAR2
,P_DRVBL_FCTR_PRTN_ELIG_FLAG in VARCHAR2
,P_ELIG_APLS_FLAG in VARCHAR2
,P_PRTN_ELIG_OVRID_ALWD_FLAG in VARCHAR2
,P_TRK_INELIG_PER_FLAG in VARCHAR2
,P_POSTELCN_EDIT_RL in NUMBER
,P_DFLT_TO_ASN_PNDG_CTFN_CD in VARCHAR2
,P_DFLT_TO_ASN_PNDG_CTFN_RL in NUMBER
,P_MN_CVG_AMT in NUMBER
,P_MN_CVG_RL in NUMBER
,P_MX_CVG_ALWD_AMT in NUMBER
,P_MX_CVG_INCR_ALWD_AMT in NUMBER
,P_MX_CVG_INCR_WCF_ALWD_AMT in NUMBER
,P_MX_CVG_MLT_INCR_NUM in NUMBER
,P_MX_CVG_MLT_INCR_WCF_NUM in NUMBER
,P_MX_CVG_RL in NUMBER
,P_MX_CVG_WCFN_AMT in NUMBER
,P_MX_CVG_WCFN_MLT_NUM in NUMBER
,P_NO_MN_CVG_AMT_APLS_FLAG in VARCHAR2
,P_NO_MN_CVG_INCR_APLS_FLAG in VARCHAR2
,P_NO_MX_CVG_AMT_APLS_FLAG in VARCHAR2
,P_NO_MX_CVG_INCR_APLS_FLAG in VARCHAR2
,P_UNSSPND_ENRT_CD in VARCHAR2
,P_PRORT_PRTL_YR_CVG_RSTRN_CD in VARCHAR2
,P_PRORT_PRTL_YR_CVG_RSTRN_RL in NUMBER
,P_CVG_INCR_R_DECR_ONLY_CD in VARCHAR2
,P_BNFT_OR_OPTION_RSTRCTN_CD in VARCHAR2
,P_PER_CVRD_CD in VARCHAR2
,P_SHORT_NAME in VARCHAR2
,P_SHORT_CODE in VARCHAR2
,P_LEGISLATION_CODE in VARCHAR2
,P_LEGISLATION_SUBGROUP in VARCHAR2
,P_VRFY_FMLY_MMBR_RL in NUMBER
,P_VRFY_FMLY_MMBR_CD in VARCHAR2
,P_USE_CSD_RSD_PRCCNG_CD in VARCHAR2
,P_CPP_ATTRIBUTE_CATEGORY in VARCHAR2
,P_CPP_ATTRIBUTE1 in VARCHAR2
,P_CPP_ATTRIBUTE2 in VARCHAR2
,P_CPP_ATTRIBUTE3 in VARCHAR2
,P_CPP_ATTRIBUTE4 in VARCHAR2
,P_CPP_ATTRIBUTE5 in VARCHAR2
,P_CPP_ATTRIBUTE6 in VARCHAR2
,P_CPP_ATTRIBUTE7 in VARCHAR2
,P_CPP_ATTRIBUTE8 in VARCHAR2
,P_CPP_ATTRIBUTE9 in VARCHAR2
,P_CPP_ATTRIBUTE10 in VARCHAR2
,P_CPP_ATTRIBUTE11 in VARCHAR2
,P_CPP_ATTRIBUTE12 in VARCHAR2
,P_CPP_ATTRIBUTE13 in VARCHAR2
,P_CPP_ATTRIBUTE14 in VARCHAR2
,P_CPP_ATTRIBUTE15 in VARCHAR2
,P_CPP_ATTRIBUTE16 in VARCHAR2
,P_CPP_ATTRIBUTE17 in VARCHAR2
,P_CPP_ATTRIBUTE18 in VARCHAR2
,P_CPP_ATTRIBUTE19 in VARCHAR2
,P_CPP_ATTRIBUTE20 in VARCHAR2
,P_CPP_ATTRIBUTE21 in VARCHAR2
,P_CPP_ATTRIBUTE22 in VARCHAR2
,P_CPP_ATTRIBUTE23 in VARCHAR2
,P_CPP_ATTRIBUTE24 in VARCHAR2
,P_CPP_ATTRIBUTE25 in VARCHAR2
,P_CPP_ATTRIBUTE26 in VARCHAR2
,P_CPP_ATTRIBUTE27 in VARCHAR2
,P_CPP_ATTRIBUTE28 in VARCHAR2
,P_CPP_ATTRIBUTE29 in VARCHAR2
,P_CPP_ATTRIBUTE30 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_cpp_RKI.AFTER_INSERT', 10);
Line: 106

hr_utility.set_location(' Leaving: ben_cpp_RKI.AFTER_INSERT', 20);
Line: 107

end AFTER_INSERT;