APPS.PA_REQUESTS_CREATION_PKG SQL Statements

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

Line: 9

PROCEDURE insert_row
      ( p_request_name                    IN PA_REQ_CREATE_TEMP.request_name%TYPE,
        p_request_number		              IN PA_REQ_CREATE_TEMP.request_number%TYPE,
        p_request_type                    IN PA_REQ_CREATE_TEMP.request_type%TYPE,
        p_request_status_name             IN PA_REQ_CREATE_TEMP.request_status_name%TYPE,
        p_request_customer                IN PA_REQ_CREATE_TEMP.request_customer%TYPE,
        p_country			                    IN PA_REQ_CREATE_TEMP.country%TYPE,
        p_state	                          IN PA_REQ_CREATE_TEMP.state%TYPE,
        p_city				                    IN PA_REQ_CREATE_TEMP.city%TYPE,
        p_value                           IN PA_REQ_CREATE_TEMP.value%TYPE,
        p_currency_code                   IN PA_REQ_CREATE_TEMP.currency_code%TYPE,
        p_expected_proj_approval_date     IN PA_REQ_CREATE_TEMP.expected_project_approval_date%TYPE,
        p_source_reference                IN PA_REQ_CREATE_TEMP.source_reference%TYPE,
        x_return_status                   OUT  NOCOPY VARCHAR2                          ,  --File.Sql.39 bug 4440895
        x_msg_count                       OUT  NOCOPY NUMBER                            ,  --File.Sql.39 bug 4440895
        x_msg_data                        OUT  NOCOPY VARCHAR2 )  --File.Sql.39 bug 4440895
IS

   l_msg_index_out	     	 NUMBER;

Line: 36

  INSERT INTO PA_REQ_CREATE_TEMP
   (request_name                          ,
  	request_number                        ,
  	request_type                          ,
  	request_status_name                   ,
  	request_customer                      ,
  	country					  ,
  	state                                 ,
  	city						  ,
  	value                                 ,
  	currency_code                         ,
 	  expected_project_approval_date        ,
  	source_reference)
    VALUES
     (p_request_name			        ,
      p_request_number                      ,
      p_request_type			        ,
      p_request_status_name                 ,
      p_request_customer                    ,
      p_country              		        ,
      p_state					  ,
      p_city					  ,
	    p_value					  ,
			p_currency_code				  ,
			p_expected_proj_approval_date		  ,
			p_source_reference);

Line: 71

                          p_procedure_name     => 'insert_row');

Line: 88

END insert_row;