APPS.OKC_ATN_PVT SQL Statements

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

Line: 52

    SELECT
            ID,
            CAT_ID,
            RUL_ID,
            CLE_ID,
            DNZ_CHR_ID,
            OBJECT_VERSION_NUMBER,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okc_Article_Trans
     WHERE okc_article_trans.id = p_id;

Line: 81

              l_atn_rec.LAST_UPDATED_BY,
              l_atn_rec.LAST_UPDATE_DATE,
              l_atn_rec.LAST_UPDATE_LOGIN;

Line: 104

    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            CAT_ID,
            CLE_ID,
            RUL_ID,
            DNZ_CHR_ID,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okc_Article_Trans_V
     WHERE okc_article_trans_v.id = p_id;

Line: 133

              l_atnv_rec.LAST_UPDATED_BY,
              l_atnv_rec.LAST_UPDATE_DATE,
              l_atnv_rec.LAST_UPDATE_LOGIN;

Line: 178

    IF (l_atnv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
      l_atnv_rec.last_updated_by := NULL;

Line: 181

    IF (l_atnv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
      l_atnv_rec.last_update_date := NULL;

Line: 184

    IF (l_atnv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN
      l_atnv_rec.last_update_login := NULL;

Line: 205

  select '!'
  from OKC_K_ARTICLES_B
  where id = p_atnv_rec.cat_id;

Line: 255

  select '!'
  from OKC_K_LINES_B
  where id = p_atnv_rec.cle_id;

Line: 298

  select '!'
  from OKC_RULES_B
  where id = p_atnv_rec.rul_id;

Line: 342

    select '!'
    from okc_k_headers_b
    where id = p_atnv_rec.dnz_chr_id;

Line: 476

    ,p_mode IN varchar2 DEFAULT 'UPDATE'  -- or 'INSERT'
--+++++++++++++++End   handcode +++++++++++++++++++++++++++++++++++
  ) RETURN VARCHAR2 IS
    l_return_status                VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line: 489

      SELECT
              ID,
              CHR_ID,
              CLE_ID,
              CAT_ID,
              OBJECT_VERSION_NUMBER,
              SFWT_FLAG,
              SAV_SAE_ID,
              SAV_SAV_RELEASE,
              SBT_CODE,
              DNZ_CHR_ID,
              COMMENTS,
              FULLTEXT_YN,
              VARIATION_DESCRIPTION,
              NAME,
              TEXT,
              ATTRIBUTE_CATEGORY,
              ATTRIBUTE1,
              ATTRIBUTE2,
              ATTRIBUTE3,
              ATTRIBUTE4,
              ATTRIBUTE5,
              ATTRIBUTE6,
              ATTRIBUTE7,
              ATTRIBUTE8,
              ATTRIBUTE9,
              ATTRIBUTE10,
              ATTRIBUTE11,
              ATTRIBUTE12,
              ATTRIBUTE13,
              ATTRIBUTE14,
              ATTRIBUTE15,
              CAT_TYPE,
              CREATED_BY,
              CREATION_DATE,
              LAST_UPDATED_BY,
              LAST_UPDATE_DATE,
              LAST_UPDATE_LOGIN
        FROM Okc_K_Articles_V
       WHERE okc_k_articles_v.id  = p_id;

Line: 531

      SELECT
              ID,
              OBJECT_VERSION_NUMBER,
              SFWT_FLAG,
              OBJECT1_ID1,
              OBJECT2_ID1,
              OBJECT3_ID1,
              OBJECT1_ID2,
              OBJECT2_ID2,
              OBJECT3_ID2,
              JTOT_OBJECT1_CODE,
              JTOT_OBJECT2_CODE,
              JTOT_OBJECT3_CODE,
              DNZ_CHR_ID,
              RGP_ID,
              SAV_SAE_ID,
              SAV_SAV_RELEASE,
              PRIORITY,
              STD_TEMPLATE_YN,
              COMMENTS,
              WARN_YN,
              ATTRIBUTE_CATEGORY,
              ATTRIBUTE1,
              ATTRIBUTE2,
              ATTRIBUTE3,
              ATTRIBUTE4,
              ATTRIBUTE5,
              ATTRIBUTE6,
              ATTRIBUTE7,
              ATTRIBUTE8,
              ATTRIBUTE9,
              ATTRIBUTE10,
              ATTRIBUTE11,
              ATTRIBUTE12,
              ATTRIBUTE13,
              ATTRIBUTE14,
              ATTRIBUTE15,
              CREATED_BY,
              CREATION_DATE,
              LAST_UPDATED_BY,
              LAST_UPDATE_DATE,
              LAST_UPDATE_LOGIN,
              TEXT,
              RULE_INFORMATION_CATEGORY,
              RULE_INFORMATION1,
              RULE_INFORMATION2,
              RULE_INFORMATION3,
              RULE_INFORMATION4,
              RULE_INFORMATION5,
              RULE_INFORMATION6,
              RULE_INFORMATION7,
              RULE_INFORMATION8,
              RULE_INFORMATION9,
              RULE_INFORMATION10,
              RULE_INFORMATION11,
              RULE_INFORMATION12,
              RULE_INFORMATION13,
              RULE_INFORMATION14,
              RULE_INFORMATION15
        FROM Okc_Rules_V
       WHERE okc_rules_v.id       = p_id;

Line: 594

      SELECT
              ID,
              OBJECT_VERSION_NUMBER,
              SFWT_FLAG,
              CHR_ID,
              CLE_ID,
              LSE_ID,
              LINE_NUMBER,
              STS_CODE,
              DISPLAY_SEQUENCE,
              TRN_CODE,
              DNZ_CHR_ID,
              COMMENTS,
              ITEM_DESCRIPTION,
              HIDDEN_IND,
              PRICE_NEGOTIATED,
              PRICE_LEVEL_IND,
              INVOICE_LINE_LEVEL_IND,
              DPAS_RATING,
              BLOCK23TEXT,
              EXCEPTION_YN,
              TEMPLATE_USED,
              DATE_TERMINATED,
              NAME,
              START_DATE,
              END_DATE,
              ATTRIBUTE_CATEGORY,
              ATTRIBUTE1,
              ATTRIBUTE2,
              ATTRIBUTE3,
              ATTRIBUTE4,
              ATTRIBUTE5,
              ATTRIBUTE6,
              ATTRIBUTE7,
              ATTRIBUTE8,
              ATTRIBUTE9,
              ATTRIBUTE10,
              ATTRIBUTE11,
              ATTRIBUTE12,
              ATTRIBUTE13,
              ATTRIBUTE14,
              ATTRIBUTE15,
              CREATED_BY,
              CREATION_DATE,
              LAST_UPDATED_BY,
              LAST_UPDATE_DATE,
              PRICE_TYPE,
              UNIT_OF_MEASURE,
              CURRENCY_CODE,
              LAST_UPDATE_LOGIN
        FROM Okc_K_Lines_V
       WHERE okc_k_lines_v.id     = p_id;

Line: 697

    select '!' from okc_article_trans_v
    where cat_id = p_atnv_rec.cat_id
      and cle_id = p_atnv_rec.cle_id;

Line: 701

    select '!' from okc_article_trans_v
    where cat_id = p_atnv_rec.cat_id
      and rul_id = p_atnv_rec.rul_id;

Line: 719

    if (p_mode = 'INSERT') then
      if not(p_atnv_rec.cle_id is NULL or p_atnv_rec.cle_id = OKC_API.G_MISS_NUM)
	then
	  open pk1_csr;

Line: 776

    p_to.last_updated_by := p_from.last_updated_by;

Line: 777

    p_to.last_update_date := p_from.last_update_date;

Line: 778

    p_to.last_update_login := p_from.last_update_login;

Line: 793

    p_to.last_updated_by := p_from.last_updated_by;

Line: 794

    p_to.last_update_date := p_from.last_update_date;

Line: 795

    p_to.last_update_login := p_from.last_update_login;

Line: 948

  PROCEDURE insert_row(
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_atn_rec                      IN atn_rec_type,
    x_atn_rec                      OUT NOCOPY atn_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 957

    l_api_name                     CONSTANT VARCHAR2(30) := 'TRANS_insert_row';

Line: 993

    INSERT INTO OKC_ARTICLE_TRANS(
        id,
        cat_id,
        rul_id,
        cle_id,
        dnz_chr_id,
        object_version_number,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        last_update_login)
      VALUES (
        l_atn_rec.id,
        l_atn_rec.cat_id,
        l_atn_rec.rul_id,
        l_atn_rec.cle_id,
        l_atn_rec.dnz_chr_id,
        l_atn_rec.object_version_number,
        l_atn_rec.created_by,
        l_atn_rec.creation_date,
        l_atn_rec.last_updated_by,
        l_atn_rec.last_update_date,
        l_atn_rec.last_update_login);

Line: 1051

  END insert_row;

Line: 1055

  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_atnv_rec                     IN atnv_rec_type,
    x_atnv_rec                     OUT NOCOPY atnv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1065

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_insert_row';

Line: 1081

      l_atnv_rec.LAST_UPDATE_DATE := l_atnv_rec.CREATION_DATE;

Line: 1082

      l_atnv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1083

      l_atnv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1138

    l_return_status := Validate_Record(l_def_atnv_rec,'INSERT');

Line: 1152

    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_atn_rec,
      lx_atn_rec
    );

Line: 1200

  END insert_row;

Line: 1204

  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_atnv_tbl                     IN atnv_tbl_type,
    x_atnv_tbl                     OUT NOCOPY atnv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1214

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';

Line: 1223

        insert_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => OKC_API.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_atnv_rec                     => p_atnv_tbl(i),
          x_atnv_rec                     => x_atnv_tbl(i));

Line: 1266

  END insert_row;

Line: 1284

    SELECT OBJECT_VERSION_NUMBER
      FROM OKC_ARTICLE_TRANS
     WHERE ID = p_atn_rec.id
       AND OBJECT_VERSION_NUMBER = p_atn_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1291

    SELECT OBJECT_VERSION_NUMBER
      FROM OKC_ARTICLE_TRANS
    WHERE ID = p_atn_rec.id;

Line: 1332

      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1341

      OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 1528

  PROCEDURE update_row(
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_atn_rec                      IN atn_rec_type,
    x_atn_rec                      OUT NOCOPY atn_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1537

    l_api_name                     CONSTANT VARCHAR2(30) := 'TRANS_update_row';

Line: 1591

      IF (x_atn_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_atn_rec.last_updated_by := l_atn_rec.last_updated_by;

Line: 1595

      IF (x_atn_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_atn_rec.last_update_date := l_atn_rec.last_update_date;

Line: 1599

      IF (x_atn_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_atn_rec.last_update_login := l_atn_rec.last_update_login;

Line: 1643

    UPDATE  OKC_ARTICLE_TRANS
    SET CAT_ID = l_def_atn_rec.cat_id,
        RUL_ID = l_def_atn_rec.rul_id,
        CLE_ID = l_def_atn_rec.cle_id,
        DNZ_CHR_ID = l_def_atn_rec.dnz_chr_id,
        OBJECT_VERSION_NUMBER = l_def_atn_rec.object_version_number,
        CREATED_BY = l_def_atn_rec.created_by,
        CREATION_DATE = l_def_atn_rec.creation_date,
        LAST_UPDATED_BY = l_def_atn_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_atn_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_atn_rec.last_update_login
    WHERE ID = l_def_atn_rec.id;

Line: 1689

  END update_row;

Line: 1693

  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_atnv_rec                     IN atnv_rec_type,
    x_atnv_rec                     OUT NOCOPY atnv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1703

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_update_row';

Line: 1717

      l_atnv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 1718

      l_atnv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1719

      l_atnv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1771

      IF (x_atnv_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_atnv_rec.last_updated_by := l_atnv_rec.last_updated_by;

Line: 1775

      IF (x_atnv_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_atnv_rec.last_update_date := l_atnv_rec.last_update_date;

Line: 1779

      IF (x_atnv_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_atnv_rec.last_update_login := l_atnv_rec.last_update_login;

Line: 1850

    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_atn_rec,
      lx_atn_rec
    );

Line: 1897

  END update_row;

Line: 1901

  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_atnv_tbl                     IN atnv_tbl_type,
    x_atnv_tbl                     OUT NOCOPY atnv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1911

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_tbl_update_row';

Line: 1920

        update_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => OKC_API.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_atnv_rec                     => p_atnv_tbl(i),
          x_atnv_rec                     => x_atnv_tbl(i));

Line: 1963

  END update_row;

Line: 1971

  PROCEDURE delete_row(
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_atn_rec                      IN atn_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1979

    l_api_name                     CONSTANT VARCHAR2(30) := 'TRANS_delete_row';

Line: 1993

    DELETE FROM OKC_ARTICLE_TRANS
     WHERE ID = l_atn_rec.id;

Line: 2028

  END delete_row;

Line: 2032

  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_atnv_rec                     IN atnv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2041

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_delete_row';

Line: 2065

    delete_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_atn_rec
    );

Line: 2109

  END delete_row;

Line: 2113

  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_atnv_tbl                     IN atnv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2122

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';

Line: 2131

        delete_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => OKC_API.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_atnv_rec                     => p_atnv_tbl(i));

Line: 2173

  END delete_row;

Line: 2189

INSERT INTO okc_article_trans_h
  (
      major_version,
      id,
      cat_id,
      rul_id,
      cle_id,
      dnz_chr_id,
      object_version_number,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login
)
  SELECT
      p_major_version,
      id,
      cat_id,
      rul_id,
      cle_id,
      dnz_chr_id,
      object_version_number,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login
  FROM okc_article_trans
WHERE dnz_chr_id = p_chr_id;

Line: 2249

INSERT INTO okc_article_trans
  (
      id,
      cat_id,
      rul_id,
      cle_id,
      dnz_chr_id,
      object_version_number,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login
)
  SELECT
      id,
      cat_id,
      rul_id,
      cle_id,
      dnz_chr_id,
      object_version_number,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login
  FROM okc_article_trans_h
WHERE dnz_chr_id = p_chr_id
  AND major_version = p_major_version;