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

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

Line: 5


procedure AFTER_INSERT
(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
)is
begin
hr_utility.set_location('Entering: PSP_ERD_RKI.AFTER_INSERT', 10);

Line: 90


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

Line: 91


end AFTER_INSERT;