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

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

Line: 5


procedure AFTER_DELETE
(P_GROUP_PER_IN_LER_ID in NUMBER
,P_ASSIGNMENT_ID_O in NUMBER
,P_PERSON_ID_O in NUMBER
,P_SUPERVISOR_ID_O in NUMBER
,P_EFFECTIVE_DATE_O in DATE
,P_FULL_NAME_O in VARCHAR2
,P_BRIEF_NAME_O in VARCHAR2
,P_CUSTOM_NAME_O in VARCHAR2
,P_SUPERVISOR_FULL_NAME_O in VARCHAR2
,P_SUPERVISOR_BRIEF_NAME_O in VARCHAR2
,P_SUPERVISOR_CUSTOM_NAME_O in VARCHAR2
,P_LEGISLATION_CODE_O in VARCHAR2
,P_YEARS_EMPLOYED_O in NUMBER
,P_YEARS_IN_JOB_O in NUMBER
,P_YEARS_IN_POSITION_O in NUMBER
,P_YEARS_IN_GRADE_O in NUMBER
,P_EMPLOYEE_NUMBER_O in VARCHAR2
,P_START_DATE_O in DATE
,P_ORIGINAL_START_DATE_O in DATE
,P_ADJUSTED_SVC_DATE_O in DATE
,P_BASE_SALARY_O in NUMBER
,P_BASE_SALARY_CHANGE_DATE_O in DATE
,P_PAYROLL_NAME_O in VARCHAR2
,P_PERFORMANCE_RATING_O in VARCHAR2
,P_PERFORMANCE_RATING_TYPE_O in VARCHAR2
,P_PERFORMANCE_RATING_DATE_O in DATE
,P_BUSINESS_GROUP_ID_O in NUMBER
,P_ORGANIZATION_ID_O in NUMBER
,P_JOB_ID_O in NUMBER
,P_GRADE_ID_O in NUMBER
,P_POSITION_ID_O in NUMBER
,P_PEOPLE_GROUP_ID_O in NUMBER
,P_SOFT_CODING_KEYFLEX_ID_O in NUMBER
,P_LOCATION_ID_O in NUMBER
,P_PAY_RATE_ID_O in NUMBER
,P_ASSIGNMENT_STATUS_TYPE_ID_O in NUMBER
,P_FREQUENCY_O in VARCHAR2
,P_GRADE_ANNULIZATION_FACTOR_O in NUMBER
,P_PAY_ANNULIZATION_FACTOR_O in NUMBER
,P_GRD_MIN_VAL_O in NUMBER
,P_GRD_MAX_VAL_O in NUMBER
,P_GRD_MID_POINT_O in NUMBER
,P_GRD_QUARTILE_O in VARCHAR2
,P_GRD_COMPARATIO_O in NUMBER
,P_EMP_CATEGORY_O in VARCHAR2
,P_CHANGE_REASON_O in VARCHAR2
,P_NORMAL_HOURS_O in NUMBER
,P_EMAIL_ADDRESS_O in VARCHAR2
,P_BASE_SALARY_FREQUENCY_O in VARCHAR2
,P_NEW_ASSGN_OVN_O in NUMBER
,P_NEW_PERF_EVENT_ID_O in NUMBER
,P_NEW_PERF_REVIEW_ID_O in NUMBER
,P_POST_PROCESS_STAT_CD_O in VARCHAR2
,P_FEEDBACK_RATING_O in VARCHAR2
,P_FEEDBACK_COMMENTS_O in VARCHAR2
,P_OBJECT_VERSION_NUMBER_O in NUMBER
,P_CUSTOM_SEGMENT1_O in VARCHAR2
,P_CUSTOM_SEGMENT2_O in VARCHAR2
,P_CUSTOM_SEGMENT3_O in VARCHAR2
,P_CUSTOM_SEGMENT4_O in VARCHAR2
,P_CUSTOM_SEGMENT5_O in VARCHAR2
,P_CUSTOM_SEGMENT6_O in VARCHAR2
,P_CUSTOM_SEGMENT7_O in VARCHAR2
,P_CUSTOM_SEGMENT8_O in VARCHAR2
,P_CUSTOM_SEGMENT9_O in VARCHAR2
,P_CUSTOM_SEGMENT10_O in VARCHAR2
,P_CUSTOM_SEGMENT11_O in NUMBER
,P_CUSTOM_SEGMENT12_O in NUMBER
,P_CUSTOM_SEGMENT13_O in NUMBER
,P_CUSTOM_SEGMENT14_O in NUMBER
,P_CUSTOM_SEGMENT15_O in NUMBER
,P_CUSTOM_SEGMENT16_O in NUMBER
,P_CUSTOM_SEGMENT17_O in NUMBER
,P_CUSTOM_SEGMENT18_O in NUMBER
,P_CUSTOM_SEGMENT19_O in NUMBER
,P_CUSTOM_SEGMENT20_O in NUMBER
,P_PEOPLE_GROUP_NAME_O in VARCHAR2
,P_PEOPLE_GROUP_SEGMENT1_O in VARCHAR2
,P_PEOPLE_GROUP_SEGMENT2_O in VARCHAR2
,P_PEOPLE_GROUP_SEGMENT3_O in VARCHAR2
,P_PEOPLE_GROUP_SEGMENT4_O in VARCHAR2
,P_PEOPLE_GROUP_SEGMENT5_O in VARCHAR2
,P_PEOPLE_GROUP_SEGMENT6_O in VARCHAR2
,P_PEOPLE_GROUP_SEGMENT7_O in VARCHAR2
,P_PEOPLE_GROUP_SEGMENT8_O in VARCHAR2
,P_PEOPLE_GROUP_SEGMENT9_O in VARCHAR2
,P_PEOPLE_GROUP_SEGMENT10_O in VARCHAR2
,P_PEOPLE_GROUP_SEGMENT11_O in VARCHAR2
,P_ASS_ATTRIBUTE_CATEGORY_O in VARCHAR2
,P_ASS_ATTRIBUTE1_O in VARCHAR2
,P_ASS_ATTRIBUTE2_O in VARCHAR2
,P_ASS_ATTRIBUTE3_O in VARCHAR2
,P_ASS_ATTRIBUTE4_O in VARCHAR2
,P_ASS_ATTRIBUTE5_O in VARCHAR2
,P_ASS_ATTRIBUTE6_O in VARCHAR2
,P_ASS_ATTRIBUTE7_O in VARCHAR2
,P_ASS_ATTRIBUTE8_O in VARCHAR2
,P_ASS_ATTRIBUTE9_O in VARCHAR2
,P_ASS_ATTRIBUTE10_O in VARCHAR2
,P_ASS_ATTRIBUTE11_O in VARCHAR2
,P_ASS_ATTRIBUTE12_O in VARCHAR2
,P_ASS_ATTRIBUTE13_O in VARCHAR2
,P_ASS_ATTRIBUTE14_O in VARCHAR2
,P_ASS_ATTRIBUTE15_O in VARCHAR2
,P_ASS_ATTRIBUTE16_O in VARCHAR2
,P_ASS_ATTRIBUTE17_O in VARCHAR2
,P_ASS_ATTRIBUTE18_O in VARCHAR2
,P_ASS_ATTRIBUTE19_O in VARCHAR2
,P_ASS_ATTRIBUTE20_O in VARCHAR2
,P_ASS_ATTRIBUTE21_O in VARCHAR2
,P_ASS_ATTRIBUTE22_O in VARCHAR2
,P_ASS_ATTRIBUTE23_O in VARCHAR2
,P_ASS_ATTRIBUTE24_O in VARCHAR2
,P_ASS_ATTRIBUTE25_O in VARCHAR2
,P_ASS_ATTRIBUTE26_O in VARCHAR2
,P_ASS_ATTRIBUTE27_O in VARCHAR2
,P_ASS_ATTRIBUTE28_O in VARCHAR2
,P_ASS_ATTRIBUTE29_O in VARCHAR2
,P_ASS_ATTRIBUTE30_O in VARCHAR2
,P_WS_COMMENTS_O in VARCHAR2
,P_CPI_ATTRIBUTE_CATEGORY_O in VARCHAR2
,P_CPI_ATTRIBUTE1_O in VARCHAR2
,P_CPI_ATTRIBUTE2_O in VARCHAR2
,P_CPI_ATTRIBUTE3_O in VARCHAR2
,P_CPI_ATTRIBUTE4_O in VARCHAR2
,P_CPI_ATTRIBUTE5_O in VARCHAR2
,P_CPI_ATTRIBUTE6_O in VARCHAR2
,P_CPI_ATTRIBUTE7_O in VARCHAR2
,P_CPI_ATTRIBUTE8_O in VARCHAR2
,P_CPI_ATTRIBUTE9_O in VARCHAR2
,P_CPI_ATTRIBUTE10_O in VARCHAR2
,P_CPI_ATTRIBUTE11_O in VARCHAR2
,P_CPI_ATTRIBUTE12_O in VARCHAR2
,P_CPI_ATTRIBUTE13_O in VARCHAR2
,P_CPI_ATTRIBUTE14_O in VARCHAR2
,P_CPI_ATTRIBUTE15_O in VARCHAR2
,P_CPI_ATTRIBUTE16_O in VARCHAR2
,P_CPI_ATTRIBUTE17_O in VARCHAR2
,P_CPI_ATTRIBUTE18_O in VARCHAR2
,P_CPI_ATTRIBUTE19_O in VARCHAR2
,P_CPI_ATTRIBUTE20_O in VARCHAR2
,P_CPI_ATTRIBUTE21_O in VARCHAR2
,P_CPI_ATTRIBUTE22_O in VARCHAR2
,P_CPI_ATTRIBUTE23_O in VARCHAR2
,P_CPI_ATTRIBUTE24_O in VARCHAR2
,P_CPI_ATTRIBUTE25_O in VARCHAR2
,P_CPI_ATTRIBUTE26_O in VARCHAR2
,P_CPI_ATTRIBUTE27_O in VARCHAR2
,P_CPI_ATTRIBUTE28_O in VARCHAR2
,P_CPI_ATTRIBUTE29_O in VARCHAR2
,P_CPI_ATTRIBUTE30_O in VARCHAR2
,P_FEEDBACK_DATE_O in DATE
)is
begin
hr_utility.set_location('Entering: BEN_CPI_RKD.AFTER_DELETE', 10);

Line: 161


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

Line: 162


end AFTER_DELETE;