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

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

Line: 5


procedure AFTER_DELETE
(P_ENRT_PERD_ID in NUMBER
,P_BUSINESS_GROUP_ID_O in NUMBER
,P_YR_PERD_ID_O in NUMBER
,P_POPL_ENRT_TYP_CYCL_ID_O in NUMBER
,P_END_DT_O in DATE
,P_STRT_DT_O in DATE
,P_ASND_LF_EVT_DT_O in DATE
,P_CLS_ENRT_DT_TO_USE_CD_O in VARCHAR2
,P_DFLT_ENRT_DT_O in DATE
,P_ENRT_CVG_STRT_DT_CD_O in VARCHAR2
,P_RT_STRT_DT_RL_O in NUMBER
,P_ENRT_CVG_END_DT_CD_O in VARCHAR2
,P_ENRT_CVG_STRT_DT_RL_O in NUMBER
,P_ENRT_CVG_END_DT_RL_O in NUMBER
,P_PROCG_END_DT_O in DATE
,P_RT_STRT_DT_CD_O in VARCHAR2
,P_RT_END_DT_CD_O in VARCHAR2
,P_RT_END_DT_RL_O in NUMBER
,P_BDGT_UPD_STRT_DT_O in DATE
,P_BDGT_UPD_END_DT_O in DATE
,P_WS_UPD_STRT_DT_O in DATE
,P_WS_UPD_END_DT_O in DATE
,P_DFLT_WS_ACC_CD_O in VARCHAR2
,P_PRSVR_BDGT_CD_O in VARCHAR2
,P_USES_BDGT_FLAG_O in VARCHAR2
,P_AUTO_DISTR_FLAG_O in VARCHAR2
,P_HRCHY_TO_USE_CD_O in VARCHAR2
,P_POS_STRUCTURE_VERSION_ID_O in NUMBER
,P_EMP_INTERVIEW_TYPE_CD_O in VARCHAR2
,P_WTHN_YR_PERD_ID_O in NUMBER
,P_LER_ID_O in NUMBER
,P_PERF_REVW_STRT_DT_O in DATE
,P_ASG_UPDT_EFF_DATE_O in DATE
,P_ENP_ATTRIBUTE_CATEGORY_O in VARCHAR2
,P_ENP_ATTRIBUTE1_O in VARCHAR2
,P_ENP_ATTRIBUTE2_O in VARCHAR2
,P_ENP_ATTRIBUTE3_O in VARCHAR2
,P_ENP_ATTRIBUTE4_O in VARCHAR2
,P_ENP_ATTRIBUTE5_O in VARCHAR2
,P_ENP_ATTRIBUTE6_O in VARCHAR2
,P_ENP_ATTRIBUTE7_O in VARCHAR2
,P_ENP_ATTRIBUTE8_O in VARCHAR2
,P_ENP_ATTRIBUTE9_O in VARCHAR2
,P_ENP_ATTRIBUTE10_O in VARCHAR2
,P_ENP_ATTRIBUTE11_O in VARCHAR2
,P_ENP_ATTRIBUTE12_O in VARCHAR2
,P_ENP_ATTRIBUTE13_O in VARCHAR2
,P_ENP_ATTRIBUTE14_O in VARCHAR2
,P_ENP_ATTRIBUTE15_O in VARCHAR2
,P_ENP_ATTRIBUTE16_O in VARCHAR2
,P_ENP_ATTRIBUTE17_O in VARCHAR2
,P_ENP_ATTRIBUTE18_O in VARCHAR2
,P_ENP_ATTRIBUTE19_O in VARCHAR2
,P_ENP_ATTRIBUTE20_O in VARCHAR2
,P_ENP_ATTRIBUTE21_O in VARCHAR2
,P_ENP_ATTRIBUTE22_O in VARCHAR2
,P_ENP_ATTRIBUTE23_O in VARCHAR2
,P_ENP_ATTRIBUTE24_O in VARCHAR2
,P_ENP_ATTRIBUTE25_O in VARCHAR2
,P_ENP_ATTRIBUTE26_O in VARCHAR2
,P_ENP_ATTRIBUTE27_O in VARCHAR2
,P_ENP_ATTRIBUTE28_O in VARCHAR2
,P_ENP_ATTRIBUTE29_O in VARCHAR2
,P_ENP_ATTRIBUTE30_O in VARCHAR2
,P_ENRT_PERD_DET_OVRLP_CD_O in VARCHAR2
,P_DATA_FREEZE_DATE_O in DATE
,P_SAL_CHG_REASON_CD_O in VARCHAR2
,P_APPROVAL_MODE_CD_O in VARCHAR2
,P_HRCHY_AME_TRN_CD_O in VARCHAR2
,P_HRCHY_RL_O in NUMBER
,P_HRCHY_AME_APP_ID_O in NUMBER
,P_OBJECT_VERSION_NUMBER_O in NUMBER
,P_REINSTATE_CD_O in VARCHAR2
,P_REINSTATE_OVRDN_CD_O in VARCHAR2
,P_DEFER_DEENROL_FLAG_O in VARCHAR2
)is
begin
hr_utility.set_location('Entering: ben_enp_RKD.AFTER_DELETE', 10);

Line: 84


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

Line: 85


end AFTER_DELETE;