DBA Data[Home] [Help]

APPS.PA_PROJECTS_UPDATE_PKG SQL Statements

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

Line: 35

  INSERT INTO pa_projects_update_temp
     (project_name                        ,
  	project_number                        ,
  	project_status_name                   ,
  	old_probability                       ,
  	new_probability				                ,
  	old_value                             ,
  	new_value					                    ,
    old_value_currency                    ,
  	new_value_currency                    ,
  	old_expected_proj_apprvl_date         ,
  	new_expected_proj_apprvl_date)
    VALUES
     (p_project_name			                ,
      p_project_number                    ,
      p_project_status_name               ,
      p_old_probability                   ,
      p_new_probability     		          ,
      p_old_value            					    ,
      p_new_value					                ,
      p_old_value_currency    					  ,
      p_new_value_currency    					  ,
	    p_old_exp_proj_apprvl_date	        ,
	    p_new_exp_proj_apprvl_date);
Line: 67

   FND_MSG_PUB.add_exc_msg( p_pkg_name         => 'PA_PROJECTS_UPDATE_PKG',
                          p_procedure_name     => 'insert_row');
Line: 86

END insert_row;