APPS.DOM_DOCUMENT_UTIL SQL Statements

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

Line: 28

       SELECT rev.document_id
            , rev.revision_id
            , rev.lifecycle_tracking_id
            , rev.lifecycle_phase_id
            , lifecycle.sequence_number
            , rev.checkout_status
            , lifecycle.status_code
            , stat.status_type
            , lifecycle.change_wf_route_id
            , stat.status_name
       FROM eng_change_statuses_vl stat
          , eng_lifecycle_statuses lifecycle
          , dom_document_revisions rev
       WHERE lifecycle.status_code = stat.status_code
       AND lifecycle.change_wf_route_id = c_route_id
       AND lifecycle.entity_id1 = rev.lifecycle_tracking_id
       AND lifecycle.entity_name = 'ENG_CHANGE'
       AND lifecycle.active_flag = 'Y'
       AND rev.lifecycle_tracking_id = c_lc_tracking_id  ;

Line: 115

    UPDATE dom_document_revisions SET  lifecycle_phase_id = p_lc_phase_code
    WHERE lifecycle_tracking_id  =  p_change_id;

Line: 166

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

 l_api_name             CONSTANT VARCHAR2(50) := 'Update_Approval_Status';

Line: 227

    SELECT rev.lifecycle_phase_id, status_type, life.sequence_number
    INTO l_status_code, l_status_type, l_seq_num
    FROM eng_change_statuses stat, dom_document_revisions rev, eng_lifecycle_statuses life
    WHERE
        life.status_code = stat.status_code AND
        stat.status_code = rev.lifecycle_phase_id AND
        life.entity_id1 = rev.lifecycle_tracking_id AND
        life.active_flag = 'Y' AND
        rev.lifecycle_tracking_id = p_change_id;

Line: 238

    SELECT status_code INTO l_approval_status
    FROM dom_doc_rev_versions
    WHERE version_id = (
    SELECT max(version_id)
        FROM dom_doc_rev_versions
        WHERE revision_id = (SELECT revision_id FROM dom_document_revisions WHERE lifecycle_tracking_id = p_change_id));

Line: 257

                    SELECT Count(*)
                    INTO l_row_count
                    FROM eng_lifecycle_statuses life,eng_change_statuses_vl stat
                    WHERE
                    life.status_code = stat.status_code and
                    life.entity_id1 = p_change_id AND
                    stat.status_type = l_status_type AND
                    life.sequence_number >  l_seq_num;

Line: 285

                    SELECT Count(*)
                    INTO l_row_count
                    FROM eng_lifecycle_statuses life,eng_change_statuses_vl stat
                    WHERE
                    life.status_code = stat.status_code and
                    life.entity_id1 = p_change_id AND
                    stat.status_type = l_status_type AND
                    life.sequence_number >  l_seq_num;

Line: 303

        UPDATE dom_doc_rev_versions SET  STATUS_CODE = l_approval_status
        WHERE version_id =
        (SELECT version_id FROM dom_doc_rev_versions
        WHERE creation_date = (
        SELECT Max(ver.creation_date) FROM dom_doc_rev_versions ver, dom_document_revisions rev
        WHERE ver.revision_id  =  rev.revision_id
        AND rev.revision_id = ver.revision_id
        AND rev.lifecycle_tracking_id  =  p_change_id));

Line: 355

END Update_Approval_Status;

Line: 878

SELECT
      DOC_NUM_SCHEME INTO l_doc_num_scheme
      FROM(
        SELECT  CATEGORY_ID
              , PARENT_CATEGORY_ID
              , DOC_NUM_SCHEME
          FROM  dom_document_categories
         WHERE  DOC_NUM_SCHEME <> 'INHERITED'
                CONNECT BY PRIOR parent_category_id = category_id
                START WITH category_id = P_CATEGORY_ID ) doc_schemes
 WHERE ROWNUM=1;

Line: 909

      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;