DBA Data[Home] [Help]

APPS.OKC_CSO_PVT SQL Statements

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

Line: 55

    SELECT
            CRO_CODE,
            RLE_CODE,
            BUY_OR_SELL,
            START_DATE,
            END_DATE,
            JTOT_OBJECT_CODE,
            OBJECT_VERSION_NUMBER,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            CONSTRAINED_YN,
            LAST_UPDATE_LOGIN,
            ACCESS_LEVEL
      FROM Okc_Contact_Sources
     WHERE okc_contact_sources.cro_code = p_cro_code
       AND okc_contact_sources.rle_code = p_rle_code
       AND okc_contact_sources.buy_or_sell = p_buy_or_sell
       AND okc_contact_sources.start_date = p_start_date;
Line: 94

              l_cso_rec.LAST_UPDATED_BY,
              l_cso_rec.LAST_UPDATE_DATE,
              l_cso_rec.CONSTRAINED_YN,
              l_cso_rec.LAST_UPDATE_LOGIN,
              l_cso_rec.ACCESS_LEVEL;
Line: 122

    SELECT
            RLE_CODE,
            CRO_CODE,
            BUY_OR_SELL,
            START_DATE,
            END_DATE,
            JTOT_OBJECT_CODE,
            OBJECT_VERSION_NUMBER,
            CONSTRAINED_YN,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN,
            ACCESS_LEVEL
      FROM Okc_Contact_Sources
     WHERE okc_contact_sources.rle_code = p_rle_code
       AND okc_contact_sources.cro_code = p_cro_code
       AND okc_contact_sources.buy_or_sell = p_buy_or_sell
       AND okc_contact_sources.start_date = p_start_date;
Line: 162

              l_csov_rec.LAST_UPDATED_BY,
              l_csov_rec.LAST_UPDATE_DATE,
              l_csov_rec.LAST_UPDATE_LOGIN,
              l_csov_rec.ACCESS_LEVEL;
Line: 211

    IF (l_csov_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
      l_csov_rec.last_updated_by := NULL;
Line: 214

    IF (l_csov_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
      l_csov_rec.last_update_date := NULL;
Line: 217

    IF (l_csov_rec.last_update_login = OKC_API.G_MISS_NUM) THEN
      l_csov_rec.last_update_login := NULL;
Line: 455

select '!'
from
	jtf_objects_vl J, jtf_object_usages U
where
	J.OBJECT_code = p_csov_rec.JTOT_OBJECT_CODE
	and sysdate between NVL(J.START_DATE_ACTIVE,sysdate)
		and NVL(J.END_DATE_ACTIVE,sysdate)
	and U.OBJECT_code = p_csov_rec.JTOT_OBJECT_CODE
	and U.object_user_code='OKX_CONTACTS';
Line: 652

    ,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: 665

      SELECT
              APPLICATION_ID,
              LOOKUP_TYPE,
              LOOKUP_CODE,
              MEANING,
              DESCRIPTION,
              ENABLED_FLAG,
              START_DATE_ACTIVE,
              END_DATE_ACTIVE,
              CREATED_BY,
              CREATION_DATE,
              LAST_UPDATE_DATE,
              LAST_UPDATED_BY,
              LAST_UPDATE_LOGIN,
              access_level,
        FROM Fnd_Common_Lookups
       WHERE fnd_common_lookups.lookup_code = p_lookup_code;
Line: 722

    select '!' from okc_contact_sources
    where rle_code = p_csov_rec.rle_code
	and cro_code = p_csov_rec.cro_code
      and buy_or_sell = p_csov_rec.buy_or_sell
	and start_date = p_csov_rec.start_date;
Line: 729

    if (p_mode = 'INSERT') then
--
      if (p_csov_rec.rle_code = OKC_API.G_MISS_CHAR
		and p_csov_rec.cro_code = OKC_API.G_MISS_CHAR
		and p_csov_rec.buy_or_sell = OKC_API.G_MISS_CHAR
		and p_csov_rec.start_date = OKC_API.G_MISS_DATE )
	then
   		return x_return_status;
Line: 750

    else  -- other mode than INSERT
      return x_return_status;
Line: 784

    p_to.last_updated_by := p_from.last_updated_by;
Line: 785

    p_to.last_update_date := p_from.last_update_date;
Line: 787

    p_to.last_update_login := p_from.last_update_login;
Line: 804

    p_to.last_updated_by := p_from.last_updated_by;
Line: 805

    p_to.last_update_date := p_from.last_update_date;
Line: 807

    p_to.last_update_login := p_from.last_update_login;
Line: 961

  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_cso_rec                      IN cso_rec_type,
    x_cso_rec                      OUT NOCOPY cso_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 970

    l_api_name                     CONSTANT VARCHAR2(30) := 'SOURCES_insert_row';
Line: 1006

    INSERT INTO OKC_CONTACT_SOURCES(
        cro_code,
        rle_code,
        buy_or_sell,
        start_date,
        end_date,
        JTOT_OBJECT_CODE,
        object_version_number,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        constrained_yn,
        last_update_login,
        access_level)
      VALUES (
        l_cso_rec.cro_code,
        l_cso_rec.rle_code,
        l_cso_rec.buy_or_sell,
        l_cso_rec.start_date,
        l_cso_rec.end_date,
        l_cso_rec.JTOT_OBJECT_CODE,
        l_cso_rec.object_version_number,
        l_cso_rec.created_by,
        l_cso_rec.creation_date,
        l_cso_rec.last_updated_by,
        l_cso_rec.last_update_date,
        l_cso_rec.constrained_yn,
        l_cso_rec.last_update_login,
        l_cso_rec.access_level);
Line: 1070

  END insert_row;
Line: 1074

  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_csov_rec                     IN csov_rec_type,
    x_csov_rec                     OUT NOCOPY csov_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1084

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

      l_csov_rec.LAST_UPDATE_DATE := SYSDATE;
Line: 1101

      l_csov_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 1102

      l_csov_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 1155

    l_return_status := Validate_Record(l_def_csov_rec,'INSERT');
Line: 1169

    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_cso_rec,
      lx_cso_rec
    );
Line: 1217

  END insert_row;
Line: 1221

  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_csov_tbl                     IN csov_tbl_type,
    x_csov_tbl                     OUT NOCOPY csov_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1231

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

        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_csov_rec                     => p_csov_tbl(i),
          x_csov_rec                     => x_csov_tbl(i));
Line: 1283

  END insert_row;
Line: 1301

    SELECT OBJECT_VERSION_NUMBER
      FROM OKC_CONTACT_SOURCES
     WHERE CRO_CODE = p_cso_rec.cro_code
       AND RLE_CODE = p_cso_rec.rle_code
       AND BUY_OR_SELL = p_cso_rec.buy_or_sell
       AND START_DATE = p_cso_rec.start_date
       AND OBJECT_VERSION_NUMBER = p_cso_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
Line: 1311

    SELECT OBJECT_VERSION_NUMBER
      FROM OKC_CONTACT_SOURCES
    WHERE CRO_CODE = p_cso_rec.cro_code
       AND RLE_CODE = p_cso_rec.rle_code
       AND BUY_OR_SELL = p_cso_rec.buy_or_sell
       AND START_DATE = p_cso_rec.start_date;
Line: 1355

      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
Line: 1364

      OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
Line: 1551

  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_cso_rec                      IN cso_rec_type,
    x_cso_rec                      OUT NOCOPY cso_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1560

    l_api_name                     CONSTANT VARCHAR2(30) := 'SOURCES_update_row';
Line: 1618

      IF (x_cso_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_cso_rec.last_updated_by := l_cso_rec.last_updated_by;
Line: 1622

      IF (x_cso_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_cso_rec.last_update_date := l_cso_rec.last_update_date;
Line: 1630

      IF (x_cso_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_cso_rec.last_update_login := l_cso_rec.last_update_login;
Line: 1678

    UPDATE  OKC_CONTACT_SOURCES
    SET END_DATE = l_def_cso_rec.end_date,
        JTOT_OBJECT_CODE = l_def_cso_rec.JTOT_OBJECT_CODE,
        OBJECT_VERSION_NUMBER = l_def_cso_rec.object_version_number,
        CREATED_BY = l_def_cso_rec.created_by,
        CREATION_DATE = l_def_cso_rec.creation_date,
        LAST_UPDATED_BY = l_def_cso_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_cso_rec.last_update_date,
        CONSTRAINED_YN = l_def_cso_rec.constrained_yn,
        LAST_UPDATE_LOGIN = l_def_cso_rec.last_update_login,
        ACCESS_LEVEL = l_def_cso_rec.access_level
    WHERE CRO_CODE = l_def_cso_rec.cro_code
      AND RLE_CODE = l_def_cso_rec.rle_code
      AND BUY_OR_SELL = l_def_cso_rec.buy_or_sell
      AND START_DATE = l_def_cso_rec.start_date;
Line: 1727

  END update_row;
Line: 1731

  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_csov_rec                     IN csov_rec_type,
    x_csov_rec                     OUT NOCOPY csov_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1741

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

      l_csov_rec.LAST_UPDATE_DATE := SYSDATE;
Line: 1756

      l_csov_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 1757

      l_csov_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 1817

      IF (x_csov_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_csov_rec.last_updated_by := l_csov_rec.last_updated_by;
Line: 1821

      IF (x_csov_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_csov_rec.last_update_date := l_csov_rec.last_update_date;
Line: 1825

      IF (x_csov_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_csov_rec.last_update_login := l_csov_rec.last_update_login;
Line: 1900

    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_cso_rec,
      lx_cso_rec
    );
Line: 1947

  END update_row;
Line: 1951

  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_csov_tbl                     IN csov_tbl_type,
    x_csov_tbl                     OUT NOCOPY csov_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1961

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

        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_csov_rec                     => p_csov_tbl(i),
          x_csov_rec                     => x_csov_tbl(i));
Line: 2013

  END update_row;
Line: 2021

  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_cso_rec                      IN cso_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 2029

    l_api_name                     CONSTANT VARCHAR2(30) := 'SOURCES_delete_row';
Line: 2043

    DELETE FROM OKC_CONTACT_SOURCES
     WHERE CRO_CODE = l_cso_rec.cro_code AND
RLE_CODE = l_cso_rec.rle_code AND
BUY_OR_SELL = l_cso_rec.buy_or_sell AND
START_DATE = l_cso_rec.start_date;
Line: 2081

  END delete_row;
Line: 2085

  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_csov_rec                     IN csov_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 2094

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

    delete_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_cso_rec
    );
Line: 2162

  END delete_row;
Line: 2166

  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_csov_tbl                     IN csov_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 2175

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

        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_csov_rec                     => p_csov_tbl(i));
Line: 2226

  END delete_row;