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

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

Line: 5


procedure UPDATE_EFF_REPORT_DETAILS_A
(P_EFFORT_REPORT_DETAIL_ID in NUMBER
,P_ASSIGNMENT_ID 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_EXPENDITURE_ORG_ID in NUMBER
,P_EXPENDITURE_TYPE in VARCHAR2
,P_TASK_ID in NUMBER
,P_AWARD_ID in NUMBER
,P_COUNT_EFF_DETAIL_ID in NUMBER
,P_EFFORT_START_DATE in DATE
,P_EFFORT_END_DATE in DATE
,P_INVESTIGATOR_PERSON_ID in NUMBER
,P_INVESTIGATOR_NAME in VARCHAR2
,P_INVESTIGATOR_ORG_NAME in VARCHAR2
,P_INVESTIGATOR_PRIMARY_ORG_ID in NUMBER
)is
begin
hr_utility.set_location('Entering: PSP_EFF_REPORT_DETAILS_BK1.UPDATE_EFF_REPORT_DETAILS_A', 10);

Line: 53


hr_utility.set_location(' Leaving: PSP_EFF_REPORT_DETAILS_BK1.UPDATE_EFF_REPORT_DETAILS_A', 20);

Line: 54


end UPDATE_EFF_REPORT_DETAILS_A;

Line: 55


procedure UPDATE_EFF_REPORT_DETAILS_B
(P_EFFORT_REPORT_DETAIL_ID in NUMBER
,P_ASSIGNMENT_ID 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_EXPENDITURE_ORG_ID in NUMBER
,P_EXPENDITURE_TYPE in VARCHAR2
,P_TASK_ID in NUMBER
,P_AWARD_ID in NUMBER
,P_COUNT_EFF_DETAIL_ID in NUMBER
,P_EFFORT_START_DATE in DATE
,P_EFFORT_END_DATE in DATE
,P_INVESTIGATOR_PERSON_ID in NUMBER
,P_INVESTIGATOR_NAME in VARCHAR2
,P_INVESTIGATOR_ORG_NAME in VARCHAR2
,P_INVESTIGATOR_PRIMARY_ORG_ID in NUMBER
)is
l_commit_unit_number number;

Line: 104


hr_utility.set_location('Entering: PSP_EFF_REPORT_DETAILS_BK1.UPDATE_EFF_REPORT_DETAILS_B', 10);

Line: 107


PSP_ERD_EXT.UPDATE_EFF_REPORT_DETAILS_EXT
(P_EFFORT_REPORT_DETAIL_ID => P_EFFORT_REPORT_DETAIL_ID
,P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
,P_GL_SEGMENT1 => P_GL_SEGMENT1
,P_GL_SEGMENT2 => P_GL_SEGMENT2
,P_GL_SEGMENT3 => P_GL_SEGMENT3
,P_GL_SEGMENT4 => P_GL_SEGMENT4
,P_GL_SEGMENT5 => P_GL_SEGMENT5
,P_GL_SEGMENT6 => P_GL_SEGMENT6
,P_GL_SEGMENT7 => P_GL_SEGMENT7
,P_GL_SEGMENT8 => P_GL_SEGMENT8
,P_GL_SEGMENT9 => P_GL_SEGMENT9
,P_GL_SEGMENT10 => P_GL_SEGMENT10
,P_GL_SEGMENT11 => P_GL_SEGMENT11
,P_GL_SEGMENT12 => P_GL_SEGMENT12
,P_GL_SEGMENT13 => P_GL_SEGMENT13
,P_GL_SEGMENT14 => P_GL_SEGMENT14
,P_GL_SEGMENT15 => P_GL_SEGMENT15
,P_GL_SEGMENT16 => P_GL_SEGMENT16
,P_GL_SEGMENT17 => P_GL_SEGMENT17
,P_GL_SEGMENT18 => P_GL_SEGMENT18
,P_GL_SEGMENT19 => P_GL_SEGMENT19
,P_GL_SEGMENT20 => P_GL_SEGMENT20
,P_GL_SEGMENT21 => P_GL_SEGMENT21
,P_GL_SEGMENT22 => P_GL_SEGMENT22
,P_GL_SEGMENT23 => P_GL_SEGMENT23
,P_GL_SEGMENT24 => P_GL_SEGMENT24
,P_GL_SEGMENT25 => P_GL_SEGMENT25
,P_GL_SEGMENT26 => P_GL_SEGMENT26
,P_GL_SEGMENT27 => P_GL_SEGMENT27
,P_GL_SEGMENT28 => P_GL_SEGMENT28
,P_GL_SEGMENT29 => P_GL_SEGMENT29
,P_GL_SEGMENT30 => P_GL_SEGMENT30
,P_PROJECT_ID => P_PROJECT_ID
,P_EXPENDITURE_ORG_ID => P_EXPENDITURE_ORG_ID
,P_EXPENDITURE_TYPE => P_EXPENDITURE_TYPE
,P_TASK_ID => P_TASK_ID
,P_AWARD_ID => P_AWARD_ID
,P_COUNT_EFF_DETAIL_ID => P_COUNT_EFF_DETAIL_ID
,P_EFFORT_START_DATE => P_EFFORT_START_DATE
,P_EFFORT_END_DATE => P_EFFORT_END_DATE
,P_INVESTIGATOR_PERSON_ID => P_INVESTIGATOR_PERSON_ID
,P_INVESTIGATOR_NAME => P_INVESTIGATOR_NAME
,P_INVESTIGATOR_ORG_NAME => P_INVESTIGATOR_ORG_NAME
,P_INVESTIGATOR_PRIMARY_ORG_ID => P_INVESTIGATOR_PRIMARY_ORG_ID
);

Line: 154


hr_api.validate_commit_unit(l_commit_unit_number, 'UPDATE_EFF_REPORT_DETAILS', 'BP');

Line: 155


hr_utility.set_location(' Leaving: PSP_EFF_REPORT_DETAILS_BK1.UPDATE_EFF_REPORT_DETAILS_B', 20);

Line: 156


end UPDATE_EFF_REPORT_DETAILS_B;