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

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

Line: 5


procedure AFTER_DELETE
(P_PRTT_ENRT_RSLT_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_BUSINESS_GROUP_ID_O in NUMBER
,P_OIPL_ID_O in NUMBER
,P_PERSON_ID_O in NUMBER
,P_ASSIGNMENT_ID_O in NUMBER
,P_PGM_ID_O in NUMBER
,P_PL_ID_O in NUMBER
,P_RPLCS_SSPNDD_RSLT_ID_O in NUMBER
,P_PTIP_ID_O in NUMBER
,P_PL_TYP_ID_O in NUMBER
,P_LER_ID_O in NUMBER
,P_SSPNDD_FLAG_O in VARCHAR2
,P_PRTT_IS_CVRD_FLAG_O in VARCHAR2
,P_BNFT_AMT_O in NUMBER
,P_UOM_O in VARCHAR2
,P_ORGNL_ENRT_DT_O in DATE
,P_ENRT_MTHD_CD_O in VARCHAR2
,P_NO_LNGR_ELIG_FLAG_O in VARCHAR2
,P_ENRT_OVRIDN_FLAG_O in VARCHAR2
,P_ENRT_OVRID_RSN_CD_O in VARCHAR2
,P_ERLST_DEENRT_DT_O in DATE
,P_ENRT_CVG_STRT_DT_O in DATE
,P_ENRT_CVG_THRU_DT_O in DATE
,P_ENRT_OVRID_THRU_DT_O in DATE
,P_PL_ORDR_NUM_O in NUMBER
,P_PLIP_ORDR_NUM_O in NUMBER
,P_PTIP_ORDR_NUM_O in NUMBER
,P_OIPL_ORDR_NUM_O in NUMBER
,P_PEN_ATTRIBUTE_CATEGORY_O in VARCHAR2
,P_PEN_ATTRIBUTE1_O in VARCHAR2
,P_PEN_ATTRIBUTE2_O in VARCHAR2
,P_PEN_ATTRIBUTE3_O in VARCHAR2
,P_PEN_ATTRIBUTE4_O in VARCHAR2
,P_PEN_ATTRIBUTE5_O in VARCHAR2
,P_PEN_ATTRIBUTE6_O in VARCHAR2
,P_PEN_ATTRIBUTE7_O in VARCHAR2
,P_PEN_ATTRIBUTE8_O in VARCHAR2
,P_PEN_ATTRIBUTE9_O in VARCHAR2
,P_PEN_ATTRIBUTE10_O in VARCHAR2
,P_PEN_ATTRIBUTE11_O in VARCHAR2
,P_PEN_ATTRIBUTE12_O in VARCHAR2
,P_PEN_ATTRIBUTE13_O in VARCHAR2
,P_PEN_ATTRIBUTE14_O in VARCHAR2
,P_PEN_ATTRIBUTE15_O in VARCHAR2
,P_PEN_ATTRIBUTE16_O in VARCHAR2
,P_PEN_ATTRIBUTE17_O in VARCHAR2
,P_PEN_ATTRIBUTE18_O in VARCHAR2
,P_PEN_ATTRIBUTE19_O in VARCHAR2
,P_PEN_ATTRIBUTE20_O in VARCHAR2
,P_PEN_ATTRIBUTE21_O in VARCHAR2
,P_PEN_ATTRIBUTE22_O in VARCHAR2
,P_PEN_ATTRIBUTE23_O in VARCHAR2
,P_PEN_ATTRIBUTE24_O in VARCHAR2
,P_PEN_ATTRIBUTE25_O in VARCHAR2
,P_PEN_ATTRIBUTE26_O in VARCHAR2
,P_PEN_ATTRIBUTE27_O in VARCHAR2
,P_PEN_ATTRIBUTE28_O in VARCHAR2
,P_PEN_ATTRIBUTE29_O in VARCHAR2
,P_PEN_ATTRIBUTE30_O in VARCHAR2
,P_REQUEST_ID_O in NUMBER
,P_PROGRAM_APPLICATION_ID_O in NUMBER
,P_PROGRAM_ID_O in NUMBER
,P_PROGRAM_UPDATE_DATE_O in DATE
,P_OBJECT_VERSION_NUMBER_O in NUMBER
,P_PER_IN_LER_ID_O in NUMBER
,P_BNFT_TYP_CD_O in VARCHAR2
,P_BNFT_ORDR_NUM_O in NUMBER
,P_PRTT_ENRT_RSLT_STAT_CD_O in VARCHAR2
,P_BNFT_NNMNTRY_UOM_O in VARCHAR2
,P_COMP_LVL_CD_O in VARCHAR2
)is
begin
hr_utility.set_location('Entering: BEN_PEN_RKD.AFTER_DELETE', 10);

Line: 86


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

Line: 87


end AFTER_DELETE;