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

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

Line: 5


procedure AFTER_DELETE
(P_ELIGY_CRITERIA_ID in NUMBER
,P_NAME_O in VARCHAR2
,P_SHORT_CODE_O in VARCHAR2
,P_DESCRIPTION_O in VARCHAR2
,P_CRITERIA_TYPE_O in VARCHAR2
,P_CRIT_COL1_VAL_TYPE_CD_O in VARCHAR2
,P_CRIT_COL1_DATATYPE_O in VARCHAR2
,P_COL1_LOOKUP_TYPE_O in VARCHAR2
,P_COL1_VALUE_SET_ID_O in NUMBER
,P_ACCESS_TABLE_NAME1_O in VARCHAR2
,P_ACCESS_COLUMN_NAME1_O in VARCHAR2
,P_TIME_ENTRY_ACCESS_TAB_NAM1_O in VARCHAR2
,P_TIME_ENTRY_ACCESS_COL_NAM1_O in VARCHAR2
,P_CRIT_COL2_VAL_TYPE_CD_O in VARCHAR2
,P_CRIT_COL2_DATATYPE_O in VARCHAR2
,P_COL2_LOOKUP_TYPE_O in VARCHAR2
,P_COL2_VALUE_SET_ID_O in NUMBER
,P_ACCESS_TABLE_NAME2_O in VARCHAR2
,P_ACCESS_COLUMN_NAME2_O in VARCHAR2
,P_TIME_ENTRY_ACCESS_TAB_NAM2_O in VARCHAR2
,P_TIME_ENTRY_ACCESS_COL_NAM2_O in VARCHAR2
,P_ACCESS_CALC_RULE_O in NUMBER
,P_ALLOW_RANGE_VALIDATION_FLG_O in VARCHAR2
,P_USER_DEFINED_FLAG_O in VARCHAR2
,P_BUSINESS_GROUP_ID_O in NUMBER
,P_LEGISLATION_CODE_O in VARCHAR2
,P_EGL_ATTRIBUTE_CATEGORY_O in VARCHAR2
,P_EGL_ATTRIBUTE1_O in VARCHAR2
,P_EGL_ATTRIBUTE2_O in VARCHAR2
,P_EGL_ATTRIBUTE3_O in VARCHAR2
,P_EGL_ATTRIBUTE4_O in VARCHAR2
,P_EGL_ATTRIBUTE5_O in VARCHAR2
,P_EGL_ATTRIBUTE6_O in VARCHAR2
,P_EGL_ATTRIBUTE7_O in VARCHAR2
,P_EGL_ATTRIBUTE8_O in VARCHAR2
,P_EGL_ATTRIBUTE9_O in VARCHAR2
,P_EGL_ATTRIBUTE10_O in VARCHAR2
,P_EGL_ATTRIBUTE11_O in VARCHAR2
,P_EGL_ATTRIBUTE12_O in VARCHAR2
,P_EGL_ATTRIBUTE13_O in VARCHAR2
,P_EGL_ATTRIBUTE14_O in VARCHAR2
,P_EGL_ATTRIBUTE15_O in VARCHAR2
,P_EGL_ATTRIBUTE16_O in VARCHAR2
,P_EGL_ATTRIBUTE17_O in VARCHAR2
,P_EGL_ATTRIBUTE18_O in VARCHAR2
,P_EGL_ATTRIBUTE19_O in VARCHAR2
,P_EGL_ATTRIBUTE20_O in VARCHAR2
,P_EGL_ATTRIBUTE21_O in VARCHAR2
,P_EGL_ATTRIBUTE22_O in VARCHAR2
,P_EGL_ATTRIBUTE23_O in VARCHAR2
,P_EGL_ATTRIBUTE24_O in VARCHAR2
,P_EGL_ATTRIBUTE25_O in VARCHAR2
,P_EGL_ATTRIBUTE26_O in VARCHAR2
,P_EGL_ATTRIBUTE27_O in VARCHAR2
,P_EGL_ATTRIBUTE28_O in VARCHAR2
,P_EGL_ATTRIBUTE29_O in VARCHAR2
,P_EGL_ATTRIBUTE30_O in VARCHAR2
,P_OBJECT_VERSION_NUMBER_O in NUMBER
,P_ALLW_RANGE_VALIDATION_FLG2_O in VARCHAR2
,P_ACCESS_CALC_RULE2_O in NUMBER
,P_TIME_ACCESS_CALC_RULE1_O in NUMBER
,P_TIME_ACCESS_CALC_RULE2_O in NUMBER
)is
begin
hr_utility.set_location('Entering: ben_egl_RKD.AFTER_DELETE', 10);

Line: 71


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

Line: 72


end AFTER_DELETE;