APPS.OKC_CONTRACT_DOCS_PVT SQL Statements

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

Line: 13

    G_RECORD_DELETED             CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_DELETED;

Line: 14

    G_NEW_RECORD_DELETED         CONSTANT VARCHAR2(200) := 'OKC_LOCK_RECORD_DELETED';

Line: 16

    G_RECORD_LOGICALLY_DELETED   CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;

Line: 80

    x_program_update_date       OUT NOCOPY DATE,
    x_parent_attached_doc_id    OUT NOCOPY NUMBER,
    x_delete_flag               OUT NOCOPY VARCHAR2,
    x_generated_flag            OUT NOCOPY VARCHAR2,
    x_object_version_number     OUT NOCOPY NUMBER,
    x_created_by                OUT NOCOPY NUMBER,
    x_creation_date             OUT NOCOPY DATE,
    x_last_updated_by           OUT NOCOPY NUMBER,
    x_last_update_login         OUT NOCOPY NUMBER,
    x_last_update_date          OUT NOCOPY DATE,

    x_primary_contract_doc_flag OUT NOCOPY VARCHAR2,
    x_mergeable_doc_flag        OUT NOCOPY VARCHAR2

  ) RETURN VARCHAR2 IS
    l_api_name                    CONSTANT VARCHAR2(30) := 'get_rec';

Line: 97

    SELECT
            EXTERNAL_VISIBILITY_FLAG,
            EFFECTIVE_FROM_TYPE,
            EFFECTIVE_FROM_ID,
            EFFECTIVE_FROM_VERSION,
            INCLUDE_FOR_APPROVAL_FLAG,
            PROGRAM_ID,
            PROGRAM_APPLICATION_ID,
            REQUEST_ID,
            PROGRAM_UPDATE_DATE,
            PARENT_ATTACHED_DOC_ID,
            DELETE_FLAG,
            GENERATED_FLAG,
            OBJECT_VERSION_NUMBER,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_LOGIN,
            LAST_UPDATE_DATE,
            PRIMARY_CONTRACT_DOC_FLAG,
      MERGEABLE_DOC_FLAG
      FROM OKC_CONTRACT_DOCS t
     WHERE t.BUSINESS_DOCUMENT_TYPE = cp_business_document_type and
           t.BUSINESS_DOCUMENT_ID = cp_business_document_id and
           t.BUSINESS_DOCUMENT_VERSION = cp_business_document_version and
           t.ATTACHED_DOCUMENT_ID = cp_attached_document_id;

Line: 140

            x_program_update_date,
            x_parent_attached_doc_id,
            x_delete_flag,
            x_generated_flag,
            x_object_version_number,
            x_created_by,
            x_creation_date,
            x_last_updated_by,
            x_last_update_login,
            x_last_update_date,
            x_primary_contract_doc_flag,
      x_mergeable_doc_flag ;

Line: 201

    p_program_update_date       IN DATE,
    p_parent_attached_doc_id    IN NUMBER,
    p_delete_flag               IN VARCHAR2,
    p_generated_flag            IN VARCHAR2,
    p_object_version_number     IN OUT NOCOPY NUMBER,
    p_primary_contract_doc_flag IN VARCHAR2,
    p_mergeable_doc_flag        IN VARCHAR2,

    x_external_visibility_flag  OUT NOCOPY VARCHAR2,
    x_effective_from_type       OUT NOCOPY VARCHAR2,
    x_effective_from_id         OUT NOCOPY NUMBER,
    x_effective_from_version    OUT NOCOPY NUMBER,
    x_include_for_approval_flag OUT NOCOPY VARCHAR2,
    x_program_id                OUT NOCOPY NUMBER,
    x_program_application_id    OUT NOCOPY NUMBER,
    x_request_id                OUT NOCOPY NUMBER,
    x_program_update_date       OUT NOCOPY DATE,
    x_parent_attached_doc_id    OUT NOCOPY NUMBER,
    x_delete_flag               OUT NOCOPY VARCHAR2,
    x_generated_flag            OUT NOCOPY VARCHAR2,
    x_primary_contract_doc_flag OUT NOCOPY VARCHAR2,
    x_mergeable_doc_flag        OUT NOCOPY VARCHAR2
  ) RETURN VARCHAR2 IS
    l_api_name                    CONSTANT VARCHAR2(30) := 'set_attributes';

Line: 229

    l_last_updated_by           OKC_CONTRACT_DOCS.LAST_UPDATED_BY%TYPE;

Line: 230

    l_last_update_login         OKC_CONTRACT_DOCS.LAST_UPDATE_LOGIN%TYPE;

Line: 231

    l_last_update_date          OKC_CONTRACT_DOCS.LAST_UPDATE_DATE%TYPE;

Line: 252

        x_program_update_date       => x_program_update_date,
        x_parent_attached_doc_id    => x_parent_attached_doc_id,
        x_delete_flag               => x_delete_flag,
        x_generated_flag            => x_generated_flag,
        x_object_version_number     => l_object_version_number,
        x_created_by                => l_created_by,
        x_creation_date             => l_creation_date,
        x_last_updated_by           => l_last_updated_by,
        x_last_update_login         => l_last_update_login,
        x_last_update_date          => l_last_update_date,
        x_primary_contract_doc_flag => x_primary_contract_doc_flag,
        x_mergeable_doc_flag        => x_mergeable_doc_flag
      );

Line: 322

      IF (p_program_update_date = G_MISS_DATE) THEN
        x_program_update_date := NULL;

Line: 324

       ELSIF (p_program_update_date IS NOT NULL) THEN
        x_program_update_date := p_program_update_date;

Line: 334

      IF (p_delete_flag = G_MISS_CHAR) THEN
        x_delete_flag := NULL;

Line: 336

       ELSIF (p_delete_flag IS NOT NULL) THEN
        x_delete_flag := p_delete_flag;

Line: 416

    p_program_update_date       IN DATE,
    p_parent_attached_doc_id    IN NUMBER,
    p_delete_flag               IN VARCHAR2,
    p_generated_flag            IN VARCHAR2,

    p_primary_contract_doc_flag IN VARCHAR2,
    p_mergeable_doc_flag        IN VARCHAR2
  ) RETURN VARCHAR2 IS
    l_api_name                    CONSTANT VARCHAR2(30) := 'validate_attributes';

Line: 627

    p_program_update_date       IN DATE,
    p_parent_attached_doc_id    IN NUMBER,
    p_delete_flag               IN VARCHAR2,
    p_generated_flag            IN VARCHAR2,

    p_primary_contract_doc_flag IN VARCHAR2,
    p_mergeable_doc_flag        IN VARCHAR2
  ) RETURN VARCHAR2 IS
    l_api_name                    CONSTANT VARCHAR2(30) := 'validate_record';

Line: 659

      p_program_update_date       => p_program_update_date,
      p_parent_attached_doc_id    => p_parent_attached_doc_id,
      p_delete_flag               => p_delete_flag,
      p_generated_flag            => p_generated_flag,
      p_primary_contract_doc_flag => p_primary_contract_doc_flag,
      p_mergeable_doc_flag        => p_mergeable_doc_flag
    );

Line: 726

    p_program_update_date       IN DATE,
    p_parent_attached_doc_id    IN NUMBER,
    p_delete_flag               IN VARCHAR2,
    p_generated_flag            IN VARCHAR2,

    p_primary_contract_doc_flag IN VARCHAR2,
    p_mergeable_doc_flag        IN VARCHAR2,

    p_object_version_number     IN NUMBER
  ) IS
      l_api_name                    CONSTANT VARCHAR2(30) := 'validate_row';

Line: 745

      l_program_update_date       OKC_CONTRACT_DOCS.PROGRAM_UPDATE_DATE%TYPE;

Line: 747

      l_delete_flag               OKC_CONTRACT_DOCS.DELETE_FLAG%TYPE;

Line: 752

      l_last_updated_by           OKC_CONTRACT_DOCS.LAST_UPDATED_BY%TYPE;

Line: 753

      l_last_update_login         OKC_CONTRACT_DOCS.LAST_UPDATE_LOGIN%TYPE;

Line: 754

      l_last_update_date          OKC_CONTRACT_DOCS.LAST_UPDATE_DATE%TYPE;

Line: 777

      p_program_update_date       => p_program_update_date,
      p_parent_attached_doc_id    => p_parent_attached_doc_id,
      p_delete_flag               => p_delete_flag,
      p_generated_flag            => p_generated_flag,
      p_object_version_number     => l_object_version_number,
      p_primary_contract_doc_flag => p_primary_contract_doc_flag,
      p_mergeable_doc_flag        => p_mergeable_doc_flag  ,

      x_external_visibility_flag  => l_external_visibility_flag,
      x_effective_from_type       => l_effective_from_type,
      x_effective_from_id         => l_effective_from_id,
      x_effective_from_version    => l_effective_from_version,
      x_include_for_approval_flag => l_include_for_approval_flag,
      x_program_id                => l_program_id,
      x_program_application_id    => l_program_application_id,
      x_request_id                => l_request_id,
      x_program_update_date       => l_program_update_date,
      x_parent_attached_doc_id    => l_parent_attached_doc_id,
      x_delete_flag               => l_delete_flag,
      x_generated_flag            => l_generated_flag,
      x_primary_contract_doc_flag => l_primary_contract_doc_flag,
      x_mergeable_doc_flag        => l_mergeable_doc_flag
    );

Line: 822

      p_program_update_date       => l_program_update_date,
      p_parent_attached_doc_id    => l_parent_attached_doc_id,
      p_delete_flag               => l_delete_flag,
      p_generated_flag            => l_generated_flag,
      p_primary_contract_doc_flag => l_primary_contract_doc_flag,
      p_mergeable_doc_flag        => l_mergeable_doc_flag
    );

Line: 867

  FUNCTION Insert_Row(
    p_business_document_type    IN VARCHAR2,
    p_business_document_id      IN NUMBER,
    p_business_document_version IN NUMBER,
    p_attached_document_id      IN NUMBER,
    p_external_visibility_flag  IN VARCHAR2,
    p_effective_from_type       IN VARCHAR2,
    p_effective_from_id         IN NUMBER,
    p_effective_from_version    IN NUMBER,
    p_include_for_approval_flag IN VARCHAR2,
    p_program_id                IN NUMBER,
    p_program_application_id    IN NUMBER,
    p_request_id                IN NUMBER,
    p_program_update_date       IN DATE,
    p_parent_attached_doc_id    IN NUMBER,
    p_delete_flag               IN VARCHAR2,
    p_generated_flag            IN VARCHAR2,
    p_object_version_number     IN NUMBER,
    p_created_by                IN NUMBER,
    p_creation_date             IN DATE,
    p_last_updated_by           IN NUMBER,
    p_last_update_login         IN NUMBER,
    p_last_update_date          IN DATE,

    p_primary_contract_doc_flag IN VARCHAR2,
    p_mergeable_doc_flag        IN VARCHAR2
  ) RETURN VARCHAR2 IS
    l_api_name                    CONSTANT VARCHAR2(30) := 'insert_row';

Line: 898

       FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3600: Entered Insert_Row function');

Line: 901

    INSERT INTO OKC_CONTRACT_DOCS(
        BUSINESS_DOCUMENT_TYPE,
        BUSINESS_DOCUMENT_ID,
        BUSINESS_DOCUMENT_VERSION,
        ATTACHED_DOCUMENT_ID,
        EXTERNAL_VISIBILITY_FLAG,
        EFFECTIVE_FROM_TYPE,
        EFFECTIVE_FROM_ID,
        EFFECTIVE_FROM_VERSION,
        INCLUDE_FOR_APPROVAL_FLAG,
        PROGRAM_ID,
        PROGRAM_APPLICATION_ID,
        REQUEST_ID,
        PROGRAM_UPDATE_DATE,
        PARENT_ATTACHED_DOC_ID,
        DELETE_FLAG,
        GENERATED_FLAG,
        OBJECT_VERSION_NUMBER,
        CREATED_BY,
        CREATION_DATE,
        LAST_UPDATED_BY,
        LAST_UPDATE_LOGIN,
        LAST_UPDATE_DATE,
        PRIMARY_CONTRACT_DOC_FLAG,
  MERGEABLE_DOC_FLAG  )
      VALUES (
        p_business_document_type,
        p_business_document_id,
        p_business_document_version,
        p_attached_document_id,
        p_external_visibility_flag,
        p_effective_from_type,
        p_effective_from_id,
        p_effective_from_version,
        p_include_for_approval_flag,
        p_program_id,
        p_program_application_id,
        p_request_id,
        p_program_update_date,
        p_parent_attached_doc_id,
        p_delete_flag,
        p_generated_flag,
        p_object_version_number,
        p_created_by,
        p_creation_date,
        p_last_updated_by,
        p_last_update_login,
        p_last_update_date,
        p_primary_contract_doc_flag,
  p_mergeable_doc_flag  );

Line: 953

       FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3700: Leaving Insert_Row');

Line: 962

         FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'3800: Leaving Insert_Row:OTHERS Exception');

Line: 974

  END Insert_Row;

Line: 980

  PROCEDURE Insert_Row(
    p_validation_level        IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
    x_return_status           OUT NOCOPY VARCHAR2,

    p_business_document_type    IN VARCHAR2,
    p_business_document_id      IN NUMBER,
    p_business_document_version IN NUMBER,
    p_attached_document_id      IN NUMBER,
    p_external_visibility_flag  IN VARCHAR2,
    p_effective_from_type       IN VARCHAR2,
    p_effective_from_id         IN NUMBER,
    p_effective_from_version    IN NUMBER,
    p_include_for_approval_flag IN VARCHAR2,
    p_program_id                IN NUMBER,
    p_program_application_id    IN NUMBER,
    p_request_id                IN NUMBER,
    p_program_update_date       IN DATE,
    p_parent_attached_doc_id    IN NUMBER,
    p_delete_flag               IN VARCHAR2,
    p_generated_flag            IN VARCHAR2,

    p_primary_contract_doc_flag IN VARCHAR2,
    p_mergeable_doc_flag        IN VARCHAR2,

    x_business_document_type    OUT NOCOPY VARCHAR2,
    x_business_document_id      OUT NOCOPY NUMBER,
    x_business_document_version OUT NOCOPY NUMBER,
    x_attached_document_id      OUT NOCOPY NUMBER

  ) IS
    l_api_name                    CONSTANT VARCHAR2(30) := 'insert_row';

Line: 1014

    l_last_updated_by           OKC_CONTRACT_DOCS.LAST_UPDATED_BY%TYPE;

Line: 1015

    l_last_update_login         OKC_CONTRACT_DOCS.LAST_UPDATE_LOGIN%TYPE;

Line: 1016

    l_last_update_date          OKC_CONTRACT_DOCS.LAST_UPDATE_DATE%TYPE;

Line: 1022

       FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'4200: Entered Insert_Row');

Line: 1032

    l_last_update_date := l_creation_date;

Line: 1033

    l_last_updated_by := l_created_by;

Line: 1034

    l_last_update_login := Fnd_Global.Login_Id;

Line: 1052

      p_program_update_date       => p_program_update_date,
      p_parent_attached_doc_id    => p_parent_attached_doc_id,
      p_delete_flag               => p_delete_flag,
      p_generated_flag            => p_generated_flag,
      p_primary_contract_doc_flag => p_primary_contract_doc_flag,
      p_mergeable_doc_flag        => p_mergeable_doc_flag
    );

Line: 1070

       FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'4300: Call the internal Insert_Row for Base Table');

Line: 1073

    x_return_status := Insert_Row(
      p_business_document_type    => x_business_document_type,
      p_business_document_id      => x_business_document_id,
      p_business_document_version => x_business_document_version,
      p_attached_document_id      => x_attached_document_id,
      p_external_visibility_flag  => p_external_visibility_flag,
      p_effective_from_type       => p_effective_from_type,
      p_effective_from_id         => p_effective_from_id,
      p_effective_from_version    => p_effective_from_version,
      p_include_for_approval_flag => p_include_for_approval_flag,
      p_program_id                => p_program_id,
      p_program_application_id    => p_program_application_id,
      p_request_id                => p_request_id,
      p_program_update_date       => p_program_update_date,
      p_parent_attached_doc_id    => p_parent_attached_doc_id,
      p_delete_flag               => p_delete_flag,
      p_generated_flag            => p_generated_flag,
      p_object_version_number     => l_object_version_number,
      p_created_by                => l_created_by,
      p_creation_date             => l_creation_date,
      p_last_updated_by           => l_last_updated_by,
      p_last_update_login         => l_last_update_login,
      p_last_update_date          => l_last_update_date,
      p_primary_contract_doc_flag => p_primary_contract_doc_flag,
      p_mergeable_doc_flag        => p_mergeable_doc_flag
    );

Line: 1108

       FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'4500: Leaving Insert_Row');

Line: 1114

         FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'4600: Leaving Insert_Row:FND_API.G_EXC_ERROR Exception');

Line: 1120

         FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'4700: Leaving Insert_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception');

Line: 1126

         FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'4800: Leaving Insert_Row because of EXCEPTION: '||sqlerrm);

Line: 1136

  END Insert_Row;

Line: 1157

    SELECT object_version_number
      FROM OKC_CONTRACT_DOCS
     WHERE BUSINESS_DOCUMENT_TYPE = cp_business_document_type AND BUSINESS_DOCUMENT_ID = cp_business_document_id AND BUSINESS_DOCUMENT_VERSION = cp_business_document_version AND ATTACHED_DOCUMENT_ID = cp_attached_document_id
       AND (object_version_number = cp_object_version_number OR cp_object_version_number IS NULL)
    FOR UPDATE OF object_version_number NOWAIT;

Line: 1164

    SELECT object_version_number
      FROM OKC_CONTRACT_DOCS
     WHERE BUSINESS_DOCUMENT_TYPE = cp_business_document_type AND BUSINESS_DOCUMENT_ID = cp_business_document_id AND BUSINESS_DOCUMENT_VERSION = cp_business_document_version AND ATTACHED_DOCUMENT_ID = cp_attached_document_id;

Line: 1206

                                      p_msg_name     => G_NEW_RECORD_DELETED,
                                      p_token1       => 'ENTITYNAME',
                                      p_token1_value => G_ENTITY_NAME,
                                      p_token2       => 'PKEY',
                                      p_token2_value => l_pk_string,
                                      p_token3       => 'OVN',
                        p_token3_value => l_object_version_number);

Line: 1218

        Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 1330

  FUNCTION Update_Row(
    p_business_document_type    IN VARCHAR2,
    p_business_document_id      IN NUMBER,
    p_business_document_version IN NUMBER,
    p_attached_document_id      IN NUMBER,
    p_external_visibility_flag  IN VARCHAR2,
    p_effective_from_type       IN VARCHAR2,
    p_effective_from_id         IN NUMBER,
    p_effective_from_version    IN NUMBER,
    p_include_for_approval_flag IN VARCHAR2,
    p_program_id                IN NUMBER,
    p_program_application_id    IN NUMBER,
    p_request_id                IN NUMBER,
    p_program_update_date       IN DATE,
    p_parent_attached_doc_id    IN NUMBER,
    p_delete_flag               IN VARCHAR2,
    p_generated_flag            IN VARCHAR2,
    p_object_version_number     IN NUMBER,
    p_last_updated_by           IN NUMBER,
    p_last_update_login         IN NUMBER,
    p_last_update_date          IN DATE,

    p_primary_contract_doc_flag IN VARCHAR2,
    p_mergeable_doc_flag        IN VARCHAR2
   ) RETURN VARCHAR2 IS
     l_api_name                    CONSTANT VARCHAR2(30) := 'update_row';

Line: 1359

       FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'6400: Entered Update_Row');

Line: 1362

    UPDATE OKC_CONTRACT_DOCS
     SET EXTERNAL_VISIBILITY_FLAG  = p_external_visibility_flag,
         EFFECTIVE_FROM_TYPE       = p_effective_from_type,
         EFFECTIVE_FROM_ID         = p_effective_from_id,
         EFFECTIVE_FROM_VERSION    = p_effective_from_version,
         INCLUDE_FOR_APPROVAL_FLAG = p_include_for_approval_flag,
         PROGRAM_ID                = p_program_id,
         PROGRAM_APPLICATION_ID    = p_program_application_id,
         REQUEST_ID                = p_request_id,
         PROGRAM_UPDATE_DATE       = p_program_update_date,
         PARENT_ATTACHED_DOC_ID    = p_parent_attached_doc_id,
         DELETE_FLAG               = p_delete_flag,
         GENERATED_FLAG            = p_generated_flag,
         OBJECT_VERSION_NUMBER     = p_object_version_number,
         LAST_UPDATED_BY           = p_last_updated_by,
         LAST_UPDATE_LOGIN         = p_last_update_login,
         LAST_UPDATE_DATE          = p_last_update_date,
         PRIMARY_CONTRACT_DOC_FLAG = p_primary_contract_doc_flag,
   MERGEABLE_DOC_FLAG        = p_mergeable_doc_flag
    WHERE BUSINESS_DOCUMENT_TYPE    = p_business_document_type AND BUSINESS_DOCUMENT_ID      = p_business_document_id AND BUSINESS_DOCUMENT_VERSION = p_business_document_version AND ATTACHED_DOCUMENT_ID      = p_attached_document_id;

Line: 1384

       FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'6500: Leaving Update_Row');

Line: 1393

         FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'6600: Leaving Update_Row because of EXCEPTION: '||sqlerrm);

Line: 1405

  END Update_Row;

Line: 1410

  PROCEDURE Update_Row(
    p_validation_level             IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

    x_return_status                OUT NOCOPY VARCHAR2,

    p_business_document_type    IN VARCHAR2,
    p_business_document_id      IN NUMBER,
    p_business_document_version IN NUMBER,
    p_attached_document_id      IN NUMBER,

    p_external_visibility_flag  IN VARCHAR2 := NULL,
    p_effective_from_type       IN VARCHAR2 := NULL,
    p_effective_from_id         IN NUMBER := NULL,
    p_effective_from_version    IN NUMBER := NULL,
    p_include_for_approval_flag IN VARCHAR2 := NULL,
    p_program_id                IN NUMBER := NULL,
    p_program_application_id    IN NUMBER := NULL,
    p_request_id                IN NUMBER := NULL,
    p_program_update_date       IN DATE := NULL,
    p_parent_attached_doc_id    IN NUMBER := NULL,
    p_delete_flag               IN VARCHAR2 := NULL,
    p_generated_flag            IN VARCHAR2 := NULL,

    p_primary_contract_doc_flag IN VARCHAR2 := NULL,
    p_mergeable_doc_flag        IN VARCHAR2 := NULL,

    p_object_version_number     IN NUMBER

   ) IS
    l_api_name                    CONSTANT VARCHAR2(30) := 'update_row';

Line: 1448

    l_program_update_date       OKC_CONTRACT_DOCS.PROGRAM_UPDATE_DATE%TYPE;

Line: 1450

    l_delete_flag               OKC_CONTRACT_DOCS.DELETE_FLAG%TYPE;

Line: 1453

    l_last_updated_by           OKC_CONTRACT_DOCS.LAST_UPDATED_BY%TYPE;

Line: 1454

    l_last_update_login         OKC_CONTRACT_DOCS.LAST_UPDATE_LOGIN%TYPE;

Line: 1455

    l_last_update_date          OKC_CONTRACT_DOCS.LAST_UPDATE_DATE%TYPE;

Line: 1462

       FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7000: Entered Update_Row');

Line: 1498

      p_program_update_date       => p_program_update_date,
      p_parent_attached_doc_id    => p_parent_attached_doc_id,
      p_delete_flag               => p_delete_flag,
      p_generated_flag            => p_generated_flag,
      p_object_version_number     => l_object_version_number,
      p_primary_contract_doc_flag => p_primary_contract_doc_flag,
      p_mergeable_doc_flag        => p_mergeable_doc_flag,

      x_external_visibility_flag  => l_external_visibility_flag,
      x_effective_from_type       => l_effective_from_type,
      x_effective_from_id         => l_effective_from_id,
      x_effective_from_version    => l_effective_from_version,
      x_include_for_approval_flag => l_include_for_approval_flag,
      x_program_id                => l_program_id,
      x_program_application_id    => l_program_application_id,
      x_request_id                => l_request_id,
      x_program_update_date       => l_program_update_date,
      x_parent_attached_doc_id    => l_parent_attached_doc_id,
      x_delete_flag               => l_delete_flag,
      x_generated_flag            => l_generated_flag,
      x_primary_contract_doc_flag => l_primary_contract_doc_flag,
      x_mergeable_doc_flag        => l_mergeable_doc_flag
    );

Line: 1546

      p_program_update_date       => l_program_update_date,
      p_parent_attached_doc_id    => l_parent_attached_doc_id,
      p_delete_flag               => l_delete_flag,
      p_generated_flag            => l_generated_flag,
      p_primary_contract_doc_flag => l_primary_contract_doc_flag,
      p_mergeable_doc_flag        => l_mergeable_doc_flag
    );

Line: 1565

    l_last_update_date := SYSDATE;

Line: 1566

    l_last_updated_by := FND_GLOBAL.USER_ID;

Line: 1567

    l_last_update_login := FND_GLOBAL.LOGIN_ID;

Line: 1582

    x_return_status := Update_Row(
      p_business_document_type    => p_business_document_type,
      p_business_document_id      => p_business_document_id,
      p_business_document_version => p_business_document_version,
      p_attached_document_id      => p_attached_document_id,
      p_external_visibility_flag  => l_external_visibility_flag,
      p_effective_from_type       => l_effective_from_type,
      p_effective_from_id         => l_effective_from_id,
      p_effective_from_version    => l_effective_from_version,
      p_include_for_approval_flag => l_include_for_approval_flag,
      p_program_id                => l_program_id,
      p_program_application_id    => l_program_application_id,
      p_request_id                => l_request_id,
      p_program_update_date       => l_program_update_date,
      p_parent_attached_doc_id    => l_parent_attached_doc_id,
      p_delete_flag               => l_delete_flag,
      p_generated_flag            => l_generated_flag,
      p_object_version_number     => l_object_version_number,
      p_last_updated_by           => l_last_updated_by,
      p_last_update_login         => l_last_update_login,
      p_last_update_date          => l_last_update_date,
      p_primary_contract_doc_flag => l_primary_contract_doc_flag,
      p_mergeable_doc_flag        => l_mergeable_doc_flag
    );

Line: 1614

      FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7800: Leaving Update_Row');

Line: 1620

        FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving Update_Row:FND_API.G_EXC_ERROR Exception');

Line: 1626

        FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving Update_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception');

Line: 1632

        FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8100: Leaving Update_Row because of EXCEPTION: '||sqlerrm);

Line: 1642

  END Update_Row;

Line: 1650

  FUNCTION Delete_Row(
    p_business_document_type    IN VARCHAR2,
    p_business_document_id      IN NUMBER,
    p_business_document_version IN NUMBER,
    p_attached_document_id      IN NUMBER
  ) RETURN VARCHAR2 IS
    l_api_name                    CONSTANT VARCHAR2(30) := 'delete_row';

Line: 1660

       FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'8200: Entered Delete_Row');

Line: 1663

    DELETE FROM OKC_CONTRACT_DOCS
      WHERE BUSINESS_DOCUMENT_TYPE = p_BUSINESS_DOCUMENT_TYPE AND BUSINESS_DOCUMENT_ID = p_BUSINESS_DOCUMENT_ID AND BUSINESS_DOCUMENT_VERSION = p_BUSINESS_DOCUMENT_VERSION AND ATTACHED_DOCUMENT_ID = p_ATTACHED_DOCUMENT_ID;

Line: 1667

       FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'8300: Leaving Delete_Row');

Line: 1676

         FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8400: Leaving Delete_Row because of EXCEPTION: '||sqlerrm);

Line: 1688

  END Delete_Row;

Line: 1693

  PROCEDURE Delete_Row(
    x_return_status                OUT NOCOPY VARCHAR2,
    p_business_document_type    IN VARCHAR2,
    p_business_document_id      IN NUMBER,
    p_business_document_version IN NUMBER,
    p_attached_document_id      IN NUMBER,
    p_object_version_number     IN NUMBER
  ) IS
    l_api_name                     CONSTANT VARCHAR2(30) := 'B_Delete_Row';

Line: 1705

       FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'8800: Entered Delete_Row');

Line: 1726

    x_return_status := Delete_Row( p_business_document_type => p_business_document_type,p_business_document_id => p_business_document_id,p_business_document_version => p_business_document_version,p_attached_document_id => p_attached_document_id );

Line: 1735

       FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'9300: Leaving Delete_Row');

Line: 1741

         FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'9400: Leaving Delete_Row:FND_API.G_EXC_ERROR Exception');

Line: 1747

         FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'9500: Leaving Delete_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception');

Line: 1753

         FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'9600: Leaving Delete_Row because of EXCEPTION: '||sqlerrm);

Line: 1763

  END Delete_Row;

Line: 1815

    UPDATE okc_contract_docs
    SET    effective_from_version = -99
    WHERE delete_flag = 'N'
    AND   business_document_version = p_business_document_version - 1
    AND   business_document_id = p_business_document_id
    AND   business_document_type = p_business_document_type
    AND   business_document_version = effective_from_version;

Line: 1825

    UPDATE okc_contract_docs
    SET    business_document_version = -99
    WHERE delete_flag = 'N'
    AND   business_document_version = p_business_document_version - 1
    AND   business_document_id = p_business_document_id
    AND   business_document_type = p_business_document_type;