DBA Data[Home] [Help]

APPS.OKC_RSC_PVT SQL Statements

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

Line: 54

    SELECT
            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,
            LAST_UPDATE_LOGIN,
            ACCESS_LEVEL
      FROM Okc_Role_Sources
     WHERE okc_role_sources.rle_code = p_rle_code
       AND okc_role_sources.buy_or_sell = p_buy_or_sell
       AND okc_role_sources.start_date = p_start_date;
Line: 88

              l_rsc_rec.LAST_UPDATED_BY,
              l_rsc_rec.LAST_UPDATE_DATE,
              l_rsc_rec.LAST_UPDATE_LOGIN,
              l_rsc_rec.ACCESS_LEVEL;
Line: 114

    SELECT
            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,
            LAST_UPDATE_LOGIN,
            ACCESS_LEVEL
      FROM Okc_Role_Sources
     WHERE okc_role_sources.rle_code = p_rle_code
       AND okc_role_sources.buy_or_sell = p_buy_or_sell
       AND okc_role_sources.start_date = p_start_date;
Line: 148

              l_rscv_rec.LAST_UPDATED_BY,
              l_rscv_rec.LAST_UPDATE_DATE,
              l_rscv_rec.LAST_UPDATE_LOGIN,
              l_rscv_rec.ACCESS_LEVEL;
Line: 188

    IF (l_rscv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
      l_rscv_rec.last_updated_by := NULL;
Line: 191

    IF (l_rscv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
      l_rscv_rec.last_update_date := NULL;
Line: 194

    IF (l_rscv_rec.last_update_login= OKC_API.G_MISS_NUM) THEN
      l_rscv_rec.last_update_login := NULL;
Line: 316

select '!'
from
	jtf_objects_vl J, jtf_object_usages U
where
	J.OBJECT_CODE = p_rscv_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_rscv_rec.JTOT_OBJECT_CODE
	and U.object_user_code='OKX_ROLES';
Line: 524

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

    select '!' from okc_role_sources
    where rle_code = p_rscv_rec.rle_code
      and buy_or_sell = p_rscv_rec.buy_or_sell
	and start_date = p_rscv_rec.start_date;
Line: 542

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

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

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

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

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

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

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

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

  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_rsc_rec                      IN rsc_rec_type,
    x_rsc_rec                      OUT NOCOPY rsc_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 778

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

    INSERT INTO OKC_ROLE_SOURCES(
        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,
        last_update_login,
        access_level)
      VALUES (
        l_rsc_rec.rle_code,
        l_rsc_rec.buy_or_sell,
        l_rsc_rec.start_date,
        l_rsc_rec.end_date,
        l_rsc_rec.JTOT_OBJECT_CODE,
        l_rsc_rec.object_version_number,
        l_rsc_rec.created_by,
        l_rsc_rec.creation_date,
        l_rsc_rec.last_updated_by,
        l_rsc_rec.last_update_date,
        l_rsc_rec.last_update_login,
        l_rsc_rec.access_level);
Line: 874

  END insert_row;
Line: 878

  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_rscv_rec                     IN rscv_rec_type,
    x_rscv_rec                     OUT NOCOPY rscv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 888

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

      l_rscv_rec.LAST_UPDATE_DATE := SYSDATE;
Line: 905

      l_rscv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 906

      l_rscv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 959

    l_return_status := Validate_Record(l_def_rscv_rec,'INSERT');
Line: 973

    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_rsc_rec,
      lx_rsc_rec
    );
Line: 1021

  END insert_row;
Line: 1025

  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_rscv_tbl                     IN rscv_tbl_type,
    x_rscv_tbl                     OUT NOCOPY rscv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1035

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

        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_rscv_rec                     => p_rscv_tbl(i),
          x_rscv_rec                     => x_rscv_tbl(i));
Line: 1087

  END insert_row;
Line: 1105

    SELECT OBJECT_VERSION_NUMBER
      FROM OKC_ROLE_SOURCES
     WHERE RLE_CODE = p_rsc_rec.rle_code
       AND BUY_OR_SELL = p_rsc_rec.buy_or_sell
       AND START_DATE = p_rsc_rec.start_date
       AND OBJECT_VERSION_NUMBER = p_rsc_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
Line: 1114

    SELECT OBJECT_VERSION_NUMBER
      FROM OKC_ROLE_SOURCES
    WHERE RLE_CODE = p_rsc_rec.rle_code
       AND BUY_OR_SELL = p_rsc_rec.buy_or_sell
       AND START_DATE = p_rsc_rec.start_date;
Line: 1157

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

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

  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_rsc_rec                      IN rsc_rec_type,
    x_rsc_rec                      OUT NOCOPY rsc_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1362

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

      IF (x_rsc_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_rsc_rec.last_updated_by := l_rsc_rec.last_updated_by;
Line: 1420

      IF (x_rsc_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_rsc_rec.last_update_date := l_rsc_rec.last_update_date;
Line: 1424

      IF (x_rsc_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_rsc_rec.last_update_login := l_rsc_rec.last_update_login;
Line: 1472

    UPDATE  OKC_ROLE_SOURCES
    SET END_DATE = l_def_rsc_rec.end_date,
        JTOT_OBJECT_CODE = l_def_rsc_rec.JTOT_OBJECT_CODE,
        OBJECT_VERSION_NUMBER = l_def_rsc_rec.object_version_number,
        CREATED_BY = l_def_rsc_rec.created_by,
        CREATION_DATE = l_def_rsc_rec.creation_date,
        LAST_UPDATED_BY = l_def_rsc_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_rsc_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_rsc_rec.last_update_login,
        ACCESS_LEVEL = l_def_rsc_rec.access_level
    WHERE RLE_CODE = l_def_rsc_rec.rle_code
      AND BUY_OR_SELL = l_def_rsc_rec.buy_or_sell
      AND START_DATE = l_def_rsc_rec.start_date;
Line: 1519

  END update_row;
Line: 1523

  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_rscv_rec                     IN rscv_rec_type,
    x_rscv_rec                     OUT NOCOPY rscv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1533

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

      l_rscv_rec.LAST_UPDATE_DATE := SYSDATE;
Line: 1548

      l_rscv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 1549

      l_rscv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 1601

      IF (x_rscv_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_rscv_rec.last_updated_by := l_rscv_rec.last_updated_by;
Line: 1605

      IF (x_rscv_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_rscv_rec.last_update_date := l_rscv_rec.last_update_date;
Line: 1609

      IF (x_rscv_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_rscv_rec.last_update_login := l_rscv_rec.last_update_login;
Line: 1684

    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_rsc_rec,
      lx_rsc_rec
    );
Line: 1731

  END update_row;
Line: 1735

  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_rscv_tbl                     IN rscv_tbl_type,
    x_rscv_tbl                     OUT NOCOPY rscv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1745

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

        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_rscv_rec                     => p_rscv_tbl(i),
          x_rscv_rec                     => x_rscv_tbl(i));
Line: 1797

  END update_row;
Line: 1805

  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_rsc_rec                      IN rsc_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1813

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

    DELETE FROM OKC_ROLE_SOURCES
     WHERE RLE_CODE = l_rsc_rec.rle_code AND
BUY_OR_SELL = l_rsc_rec.buy_or_sell AND
START_DATE = l_rsc_rec.start_date;
Line: 1864

  END delete_row;
Line: 1868

  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_rscv_rec                     IN rscv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1877

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

    delete_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_rsc_rec
    );
Line: 1945

  END delete_row;
Line: 1949

  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_rscv_tbl                     IN rscv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1958

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

        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_rscv_rec                     => p_rscv_tbl(i));
Line: 2009

  END delete_row;