APPS.ENG_DOCUMENT_UTIL SQL Statements

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

Line: 39

       SELECT VALUE
        FROM V$PARAMETER
        WHERE NAME = 'utl_file_dir';

Line: 253

           SELECT eec.change_mgmt_type_code
                , ecot.base_change_mgmt_type_code
           FROM eng_engineering_changes eec,
                eng_change_order_types ecot
           WHERE ecot.change_order_type_id = eec.change_order_type_id
           AND eec.change_id = c_change_id ;

Line: 301

     SELECT TO_NUMBER(pk2_value)  document_revision_id
          , TO_NUMBER(pk1_value)  document_id
     INTO   x_document_revision_id
          , x_document_id
     FROM  ENG_CHANGE_SUBJECTS subj
     WHERE subj.entity_name = 'DOM_DOCUMENT_REVISION'
     AND   subj.change_id  = p_change_id
     AND   ROWNUM = 1 ;

Line: 327

    /*  SELECT dom_doc.document_id
           , dom_doc.doc_number
           , dom_doc_rev.revision
           , dom_doc.name
       INTO  x_document_id
           , x_document_number
           , x_document_revision
           , x_documnet_name
        FROM dom_documents_vl        dom_doc
           , dom_document_revisions  dom_doc_rev
       WHERE dom_doc.document_id  = dom_doc_rev.document_id
       AND   dom_doc_rev.revision_id = p_document_revision_id ;

Line: 354

  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_debug                     IN   VARCHAR2 := FND_API.G_FALSE        --
   ,p_output_dir                IN   VARCHAR2 := NULL
   ,p_debug_filename            IN   VARCHAR2 := NULL
   ,x_return_status             OUT  NOCOPY  VARCHAR2                   --
   ,x_msg_count                 OUT  NOCOPY  NUMBER                     --
   ,x_msg_data                  OUT  NOCOPY  VARCHAR2                   --
   ,p_change_id                 IN   NUMBER                             -- header's change_id
   ,p_approval_status           IN   NUMBER                             -- header new approval status
   ,p_wf_route_status           IN   VARCHAR2                           -- workflow routing status (for document types)
   ,p_api_caller                IN   VARCHAR2 := NULL                   -- Optionnal for future use
  )
  IS

    l_return_status      VARCHAR2(1);

Line: 387

   Write_Debug('ENG_DOCUMENT_UTIL.Update_Approval_Status Log');

Line: 394

   Write_Debug('Calling DOM_LIFECYCLE_UTIL.UPDATE_APPROVAL_STATUS');

Line: 403

                          || '  DOM_DOCUMENT_UTIL.UPDATE_APPROVAL_STATUS'
                          || '  ( p_api_version        => :1 '
                          || '   ,p_init_msg_list      => :2 '
                          || '   ,p_commit             => :3 '
                          || '   ,p_validation_level   => :4 '
                          || '   ,x_return_status      => :5 '
                          || '   ,x_msg_count          => :6 '
                          || '   ,x_msg_data           => :7 '
                          || '   ,p_change_id          => :8 '
                          || '   ,p_approval_status    => :9 '
                          || '   ,p_wf_route_status    => :10 '
                          || '   ,p_api_caller         => :11 '
                          || ' ); '

Line: 443

   Write_Debug('After Calling DOM_DOCUMENT_UTIL.UPDATE_APPROVAL_STATUS: ' || l_return_status);

Line: 456

   Write_Debug('Exception Update_Approval_Status: PLSQL_COMPILE_ERROR ');

Line: 463

   Write_Debug('Unexpected Exception Update_Approval_Status: ' || SQLERRM);

Line: 471

            p_procedure_name      => 'UPDATE_APPROVAL_STATUS',
            p_error_text          => Substr(To_Char(SQLCODE)||'/'||SQLERRM,1,240)
          );

Line: 481

  END  Update_Approval_Status ;