APPS.DOM_DOCUMENT_UTIL SQL Statements

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

Line: 65

Procedure Update_Approval_Status
(  p_api_version        IN  NUMBER                             --
  ,p_init_msg_list      IN  VARCHAR2 := FND_API.G_FALSE        --
  ,p_commit             IN  VARCHAR2 := FND_API.G_FALSE        --
  ,p_validation_level   IN  NUMBER   := FND_API.G_VALID_LEVEL_FULL
  ,p_change_id          IN  NUMBER
  ,p_approval_status    IN  NUMBER
  ,p_wf_route_status    IN  VARCHAR2
  ,p_api_caller         IN  VARCHAR2
  ,x_return_status      OUT  NOCOPY  VARCHAR2                   --
  ,x_msg_count          OUT  NOCOPY  NUMBER                     --
  ,x_msg_data           OUT  NOCOPY  VARCHAR2
)
IS


BEGIN
--Null out the method,as part of 12.2 Document Management Deprecation
 x_return_status := FND_API.G_RET_STS_SUCCESS ;

Line: 87

END Update_Approval_Status;

Line: 235

      3) If the returned rows should in a specified order, put that ORDER BY CLASS in the SELECT statement argument.
      4) If the SQL statement happened to return duplicate values, and if you don't want that to happen, put DISTINCT in the SELECT statement argument.
     */

  TYPE c_refcur IS REF CURSOR;