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

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

Line: 10


Procedure UPDATE_EFF_REPORT_DETAILS_EXT( 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
         ) as
BEGIN
	PSP_EFF_REPORT_DETAILS_API.g_er_proposed_salary_amt(p_count_eff_detail_id)     := hr_api.g_number;

Line: 86


               select INVESTIGATOR_PERSON_ID,
                              INVESTIGATOR_NAME,
                              INVESTIGATOR_ORG_NAME,
                              INVESTIGATOR_PRIMARY_ORG_ID
               into psp_eff_report_details_api.g_er_approver_person_id(p_count_eff_detail_id),
                              psp_eff_report_details_api.g_er_investigator_name(p_count_eff_detail_id),
                              psp_eff_report_details_api.g_er_investigator_org_name(p_count_eff_detail_id),
                              psp_eff_report_details_api.g_er_inv_primary_org_id(p_count_eff_detail_id)
                 from psp_eff_report_details
                 where effort_report_id in
                      (select effort_report_id
                        from psp_eff_report_details
                         where effort_report_detail_id = p_effort_report_detail_id)
                    and investigator_person_id is not null
                    and rownum = 1
                    order by payroll_percent desc;

Line: 110


	   fnd_msg_pub.add_exc_msg('PSP_ERD_EXT','UPDATE_EFF_REPORT_DETAILS_EXT');