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.PSP_ERD_RKU SQL Statements

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

Line: 5


procedure AFTER_UPDATE
(P_EFFORT_REPORT_DETAIL_ID in NUMBER
,P_EFFORT_REPORT_ID in NUMBER
,P_OBJECT_VERSION_NUMBER in NUMBER
,P_ASSIGNMENT_ID in NUMBER
,P_ASSIGNMENT_NUMBER in VARCHAR2
,P_GL_SUM_CRITERIA_SEGMENT_NAME in VARCHAR2
,P_GL_SEGMENT1 in VARCHAR2
,P_GL_SEGMENT2 in VARCHAR2
,P_GL_SEGMENT3 in VARCHAR2
,P_GL_SEGMENT4 in VARCHAR2
,P_GL_SEGMENT5 in VARCHAR2
,P_GL_SEGMENT6 in VARCHAR2
,P_GL_SEGMENT7 in VARCHAR2
,P_GL_SEGMENT8 in VARCHAR2
,P_GL_SEGMENT9 in VARCHAR2
,P_GL_SEGMENT10 in VARCHAR2
,P_GL_SEGMENT11 in VARCHAR2
,P_GL_SEGMENT12 in VARCHAR2
,P_GL_SEGMENT13 in VARCHAR2
,P_GL_SEGMENT14 in VARCHAR2
,P_GL_SEGMENT15 in VARCHAR2
,P_GL_SEGMENT16 in VARCHAR2
,P_GL_SEGMENT17 in VARCHAR2
,P_GL_SEGMENT18 in VARCHAR2
,P_GL_SEGMENT19 in VARCHAR2
,P_GL_SEGMENT20 in VARCHAR2
,P_GL_SEGMENT21 in VARCHAR2
,P_GL_SEGMENT22 in VARCHAR2
,P_GL_SEGMENT23 in VARCHAR2
,P_GL_SEGMENT24 in VARCHAR2
,P_GL_SEGMENT25 in VARCHAR2
,P_GL_SEGMENT26 in VARCHAR2
,P_GL_SEGMENT27 in VARCHAR2
,P_GL_SEGMENT28 in VARCHAR2
,P_GL_SEGMENT29 in VARCHAR2
,P_GL_SEGMENT30 in VARCHAR2
,P_PROJECT_ID in NUMBER
,P_PROJECT_NUMBER in VARCHAR2
,P_PROJECT_NAME in VARCHAR2
,P_EXPENDITURE_ORGANIZATION_ID in NUMBER
,P_EXP_ORG_NAME in VARCHAR2
,P_EXPENDITURE_TYPE in VARCHAR2
,P_TASK_ID in NUMBER
,P_TASK_NUMBER in VARCHAR2
,P_TASK_NAME in VARCHAR2
,P_AWARD_ID in NUMBER
,P_AWARD_NUMBER in VARCHAR2
,P_AWARD_SHORT_NAME in VARCHAR2
,P_ACTUAL_SALARY_AMT in NUMBER
,P_PAYROLL_PERCENT in NUMBER
,P_PROPOSED_SALARY_AMT in NUMBER
,P_PROPOSED_EFFORT_PERCENT in NUMBER
,P_COMMITTED_COST_SHARE in NUMBER
,P_SCHEDULE_START_DATE in DATE
,P_SCHEDULE_END_DATE in DATE
,P_AME_TRANSACTION_ID in VARCHAR2
,P_INVESTIGATOR_NAME in VARCHAR2
,P_INVESTIGATOR_PERSON_ID in NUMBER
,P_INVESTIGATOR_ORG_NAME in VARCHAR2
,P_INVESTIGATOR_PRIMARY_ORG_ID in NUMBER
,P_VALUE1 in NUMBER
,P_VALUE2 in NUMBER
,P_VALUE3 in NUMBER
,P_VALUE4 in NUMBER
,P_VALUE5 in NUMBER
,P_VALUE6 in NUMBER
,P_VALUE7 in NUMBER
,P_VALUE8 in NUMBER
,P_VALUE9 in NUMBER
,P_VALUE10 in NUMBER
,P_ATTRIBUTE1 in VARCHAR2
,P_ATTRIBUTE2 in VARCHAR2
,P_ATTRIBUTE3 in VARCHAR2
,P_ATTRIBUTE4 in VARCHAR2
,P_ATTRIBUTE5 in VARCHAR2
,P_ATTRIBUTE6 in VARCHAR2
,P_ATTRIBUTE7 in VARCHAR2
,P_ATTRIBUTE8 in VARCHAR2
,P_ATTRIBUTE9 in VARCHAR2
,P_ATTRIBUTE10 in VARCHAR2
,P_GROUPING_CATEGORY in VARCHAR2
,P_EFFORT_REPORT_ID_O in NUMBER
,P_OBJECT_VERSION_NUMBER_O in NUMBER
,P_ASSIGNMENT_ID_O in NUMBER
,P_ASSIGNMENT_NUMBER_O in VARCHAR2
,P_GL_SUM_CRITERIA_SEGMENT_NA_O in VARCHAR2
,P_GL_SEGMENT1_O in VARCHAR2
,P_GL_SEGMENT2_O in VARCHAR2
,P_GL_SEGMENT3_O in VARCHAR2
,P_GL_SEGMENT4_O in VARCHAR2
,P_GL_SEGMENT5_O in VARCHAR2
,P_GL_SEGMENT6_O in VARCHAR2
,P_GL_SEGMENT7_O in VARCHAR2
,P_GL_SEGMENT8_O in VARCHAR2
,P_GL_SEGMENT9_O in VARCHAR2
,P_GL_SEGMENT10_O in VARCHAR2
,P_GL_SEGMENT11_O in VARCHAR2
,P_GL_SEGMENT12_O in VARCHAR2
,P_GL_SEGMENT13_O in VARCHAR2
,P_GL_SEGMENT14_O in VARCHAR2
,P_GL_SEGMENT15_O in VARCHAR2
,P_GL_SEGMENT16_O in VARCHAR2
,P_GL_SEGMENT17_O in VARCHAR2
,P_GL_SEGMENT18_O in VARCHAR2
,P_GL_SEGMENT19_O in VARCHAR2
,P_GL_SEGMENT20_O in VARCHAR2
,P_GL_SEGMENT21_O in VARCHAR2
,P_GL_SEGMENT22_O in VARCHAR2
,P_GL_SEGMENT23_O in VARCHAR2
,P_GL_SEGMENT24_O in VARCHAR2
,P_GL_SEGMENT25_O in VARCHAR2
,P_GL_SEGMENT26_O in VARCHAR2
,P_GL_SEGMENT27_O in VARCHAR2
,P_GL_SEGMENT28_O in VARCHAR2
,P_GL_SEGMENT29_O in VARCHAR2
,P_GL_SEGMENT30_O in VARCHAR2
,P_PROJECT_ID_O in NUMBER
,P_PROJECT_NUMBER_O in VARCHAR2
,P_PROJECT_NAME_O in VARCHAR2
,P_EXPENDITURE_ORGANIZATION_I_O in NUMBER
,P_EXP_ORG_NAME_O in VARCHAR2
,P_EXPENDITURE_TYPE_O in VARCHAR2
,P_TASK_ID_O in NUMBER
,P_TASK_NUMBER_O in VARCHAR2
,P_TASK_NAME_O in VARCHAR2
,P_AWARD_ID_O in NUMBER
,P_AWARD_NUMBER_O in VARCHAR2
,P_AWARD_SHORT_NAME_O in VARCHAR2
,P_ACTUAL_SALARY_AMT_O in NUMBER
,P_PAYROLL_PERCENT_O in NUMBER
,P_PROPOSED_SALARY_AMT_O in NUMBER
,P_PROPOSED_EFFORT_PERCENT_O in NUMBER
,P_COMMITTED_COST_SHARE_O in NUMBER
,P_SCHEDULE_START_DATE_O in DATE
,P_SCHEDULE_END_DATE_O in DATE
,P_AME_TRANSACTION_ID_O in VARCHAR2
,P_INVESTIGATOR_NAME_O in VARCHAR2
,P_INVESTIGATOR_PERSON_ID_O in NUMBER
,P_INVESTIGATOR_ORG_NAME_O in VARCHAR2
,P_INVESTIGATOR_PRIMARY_ORG_I_O in NUMBER
,P_VALUE1_O in NUMBER
,P_VALUE2_O in NUMBER
,P_VALUE3_O in NUMBER
,P_VALUE4_O in NUMBER
,P_VALUE5_O in NUMBER
,P_VALUE6_O in NUMBER
,P_VALUE7_O in NUMBER
,P_VALUE8_O in NUMBER
,P_VALUE9_O in NUMBER
,P_VALUE10_O in NUMBER
,P_ATTRIBUTE1_O in VARCHAR2
,P_ATTRIBUTE2_O in VARCHAR2
,P_ATTRIBUTE3_O in VARCHAR2
,P_ATTRIBUTE4_O in VARCHAR2
,P_ATTRIBUTE5_O in VARCHAR2
,P_ATTRIBUTE6_O in VARCHAR2
,P_ATTRIBUTE7_O in VARCHAR2
,P_ATTRIBUTE8_O in VARCHAR2
,P_ATTRIBUTE9_O in VARCHAR2
,P_ATTRIBUTE10_O in VARCHAR2
,P_GROUPING_CATEGORY_O in VARCHAR2
)is
begin
hr_utility.set_location('Entering: PSP_ERD_RKU.AFTER_UPDATE', 10);

Line: 170


hr_utility.set_location(' Leaving: PSP_ERD_RKU.AFTER_UPDATE', 20);

Line: 171


end AFTER_UPDATE;