DBA Data[Home] [Help]

APPS.PA_REQUESTS_CREATION_WARN_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_WARN_TEMP.request_name%TYPE,
	      p_warning			                    IN PA_REQ_CREATE_WARN_TEMP.warning%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: 26

  INSERT INTO PA_REQ_CREATE_WARN_TEMP
     (request_name                          ,
  	warning)
    VALUES
     (p_request_name			        ,
      p_warning);
Line: 41

                          p_procedure_name     => 'insert_row');
Line: 58

END insert_row;