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

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

Line: 5


procedure AFTER_INSERT
(P_CLPSE_LF_EVT_ID in NUMBER
,P_EFFECTIVE_START_DATE in DATE
,P_EFFECTIVE_END_DATE in DATE
,P_BUSINESS_GROUP_ID in NUMBER
,P_SEQ in NUMBER
,P_LER1_ID in NUMBER
,P_BOOL1_CD in VARCHAR2
,P_LER2_ID in NUMBER
,P_BOOL2_CD in VARCHAR2
,P_LER3_ID in NUMBER
,P_BOOL3_CD in VARCHAR2
,P_LER4_ID in NUMBER
,P_BOOL4_CD in VARCHAR2
,P_LER5_ID in NUMBER
,P_BOOL5_CD in VARCHAR2
,P_LER6_ID in NUMBER
,P_BOOL6_CD in VARCHAR2
,P_LER7_ID in NUMBER
,P_BOOL7_CD in VARCHAR2
,P_LER8_ID in NUMBER
,P_BOOL8_CD in VARCHAR2
,P_LER9_ID in NUMBER
,P_BOOL9_CD in VARCHAR2
,P_LER10_ID in NUMBER
,P_EVAL_CD in VARCHAR2
,P_EVAL_RL in NUMBER
,P_TLRNC_DYS_NUM in NUMBER
,P_EVAL_LER_ID in NUMBER
,P_EVAL_LER_DET_CD in VARCHAR2
,P_EVAL_LER_DET_RL in NUMBER
,P_CLP_ATTRIBUTE_CATEGORY in VARCHAR2
,P_CLP_ATTRIBUTE1 in VARCHAR2
,P_CLP_ATTRIBUTE2 in VARCHAR2
,P_CLP_ATTRIBUTE3 in VARCHAR2
,P_CLP_ATTRIBUTE4 in VARCHAR2
,P_CLP_ATTRIBUTE5 in VARCHAR2
,P_CLP_ATTRIBUTE6 in VARCHAR2
,P_CLP_ATTRIBUTE7 in VARCHAR2
,P_CLP_ATTRIBUTE8 in VARCHAR2
,P_CLP_ATTRIBUTE9 in VARCHAR2
,P_CLP_ATTRIBUTE10 in VARCHAR2
,P_CLP_ATTRIBUTE11 in VARCHAR2
,P_CLP_ATTRIBUTE12 in VARCHAR2
,P_CLP_ATTRIBUTE13 in VARCHAR2
,P_CLP_ATTRIBUTE14 in VARCHAR2
,P_CLP_ATTRIBUTE15 in VARCHAR2
,P_CLP_ATTRIBUTE16 in VARCHAR2
,P_CLP_ATTRIBUTE17 in VARCHAR2
,P_CLP_ATTRIBUTE18 in VARCHAR2
,P_CLP_ATTRIBUTE19 in VARCHAR2
,P_CLP_ATTRIBUTE20 in VARCHAR2
,P_CLP_ATTRIBUTE21 in VARCHAR2
,P_CLP_ATTRIBUTE22 in VARCHAR2
,P_CLP_ATTRIBUTE23 in VARCHAR2
,P_CLP_ATTRIBUTE24 in VARCHAR2
,P_CLP_ATTRIBUTE25 in VARCHAR2
,P_CLP_ATTRIBUTE26 in VARCHAR2
,P_CLP_ATTRIBUTE27 in VARCHAR2
,P_CLP_ATTRIBUTE28 in VARCHAR2
,P_CLP_ATTRIBUTE29 in VARCHAR2
,P_CLP_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_clp_RKI.AFTER_INSERT', 10);

Line: 74


hr_utility.set_location(' Leaving: ben_clp_RKI.AFTER_INSERT', 20);

Line: 75


end AFTER_INSERT;