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

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

Line: 5


procedure AFTER_DELETE
(P_ELIGY_CRITERIA_DPNT_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_ALLOW_RANGE_VALIDATION_FLG_O in VARCHAR2
,P_USER_DEFINED_FLAG_O in VARCHAR2
,P_BUSINESS_GROUP_ID_O in NUMBER
,P_EGD_ATTRIBUTE_CATEGORY_O in VARCHAR2
,P_EGD_ATTRIBUTE1_O in VARCHAR2
,P_EGD_ATTRIBUTE2_O in VARCHAR2
,P_EGD_ATTRIBUTE3_O in VARCHAR2
,P_EGD_ATTRIBUTE4_O in VARCHAR2
,P_EGD_ATTRIBUTE5_O in VARCHAR2
,P_EGD_ATTRIBUTE6_O in VARCHAR2
,P_EGD_ATTRIBUTE7_O in VARCHAR2
,P_EGD_ATTRIBUTE8_O in VARCHAR2
,P_EGD_ATTRIBUTE9_O in VARCHAR2
,P_EGD_ATTRIBUTE10_O in VARCHAR2
,P_EGD_ATTRIBUTE11_O in VARCHAR2
,P_EGD_ATTRIBUTE12_O in VARCHAR2
,P_EGD_ATTRIBUTE13_O in VARCHAR2
,P_EGD_ATTRIBUTE14_O in VARCHAR2
,P_EGD_ATTRIBUTE15_O in VARCHAR2
,P_EGD_ATTRIBUTE16_O in VARCHAR2
,P_EGD_ATTRIBUTE17_O in VARCHAR2
,P_EGD_ATTRIBUTE18_O in VARCHAR2
,P_EGD_ATTRIBUTE19_O in VARCHAR2
,P_EGD_ATTRIBUTE20_O in VARCHAR2
,P_EGD_ATTRIBUTE21_O in VARCHAR2
,P_EGD_ATTRIBUTE22_O in VARCHAR2
,P_EGD_ATTRIBUTE23_O in VARCHAR2
,P_EGD_ATTRIBUTE24_O in VARCHAR2
,P_EGD_ATTRIBUTE25_O in VARCHAR2
,P_EGD_ATTRIBUTE26_O in VARCHAR2
,P_EGD_ATTRIBUTE27_O in VARCHAR2
,P_EGD_ATTRIBUTE28_O in VARCHAR2
,P_EGD_ATTRIBUTE29_O in VARCHAR2
,P_EGD_ATTRIBUTE30_O in VARCHAR2
,P_OBJECT_VERSION_NUMBER_O in NUMBER
,P_ALLW_RANGE_VALIDATION_FLG2_O in VARCHAR2
,P_TIME_ACCESS_CALC_RULE1_O in NUMBER
,P_TIME_ACCESS_CALC_RULE2_O in NUMBER
)is
begin
hr_utility.set_location('Entering: BEN_DPNT_EGD_RKD.AFTER_DELETE', 10);

Line: 68


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

Line: 69


end AFTER_DELETE;