DBA Data[Home] [Help]

APPS.OKL_DCT_PVT SQL Statements

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

Line: 109

      SELECT  'x'
      FROM    OKX_REMARKET_TEAMS_V
      WHERE    ID = p_dctv_rec.rmr_id;
Line: 191

      SELECT  'x'
      FROM    OKX_ITEM_CATALOGS_V
      WHERE    ID = p_dctv_rec.ico_id;
Line: 273

      SELECT  'x'
      FROM    OKX_LOCATIONS_V
      WHERE    ID = p_dctv_rec.iln_id;
Line: 462

     SELECT id
     FROM   OKL_DF_CTGY_RMK_TMS
     WHERE  id    = p_id;
Line: 471

     SELECT NVL(date_effective_to, OKL_API.G_MISS_DATE)
     FROM   OKL_DF_CTGY_RMK_TMS
     WHERE  rmr_id =  p_rmr_id
     AND    ico_id =  p_ico_id
     ORDER BY date_effective_from DESC;
Line: 483

     SELECT NVL(date_effective_to, OKL_API.G_MISS_DATE)
     FROM   OKL_DF_CTGY_RMK_TMS
     WHERE  rmr_id =  p_rmr_id
     AND    ico_id =  p_ico_id
     AND    id     <> p_id
     ORDER BY date_effective_from DESC;
Line: 584

     SELECT 'x'
     FROM OKL_DF_CTGY_RMK_TMS
     WHERE  date_effective_from = p_date_effective_from
     AND    rmr_id = p_rmr_id
     AND    ico_id = p_ico_id
     AND    iln_id = p_iln_id;
Line: 687

    SELECT
            ID,
            ORG_ID,
            RMR_ID,
            ICO_ID,
            ILN_ID,
            DATE_EFFECTIVE_FROM,
            OBJECT_VERSION_NUMBER,
            CREATED_BY,
            DATE_EFFECTIVE_TO,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okl_Df_Ctgy_Rmk_Tms
     WHERE okl_df_ctgy_rmk_tms.id = p_id;
Line: 720

              l_dct_rec.LAST_UPDATED_BY,
              l_dct_rec.LAST_UPDATE_DATE,
              l_dct_rec.LAST_UPDATE_LOGIN;
Line: 743

    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            ORG_ID,
            RMR_ID,
            ICO_ID,
            ILN_ID,
            DATE_EFFECTIVE_FROM,
            DATE_EFFECTIVE_TO,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM OKL_DF_CTGY_RMK_TMS
     WHERE OKL_DF_CTGY_RMK_TMS.id = p_id;
Line: 776

              l_dctv_rec.LAST_UPDATED_BY,
              l_dctv_rec.LAST_UPDATE_DATE,
              l_dctv_rec.LAST_UPDATE_LOGIN;
Line: 827

    IF (l_dctv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
      l_dctv_rec.last_updated_by := NULL;
Line: 830

    IF (l_dctv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
      l_dctv_rec.last_update_date := NULL;
Line: 833

    IF (l_dctv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN
      l_dctv_rec.last_update_login := NULL;
Line: 1019

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

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

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

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

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

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

  PROCEDURE insert_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_dct_rec                      IN dct_rec_type,
    x_dct_rec                      OUT NOCOPY dct_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1219

    l_api_name                     CONSTANT VARCHAR2(30) := 'TMS_insert_row';
Line: 1255

    INSERT INTO OKL_DF_CTGY_RMK_TMS(
        id,
        org_id,
        rmr_id,
        ico_id,
        iln_id,
        date_effective_from,
        object_version_number,
        created_by,
        date_effective_to,
        creation_date,
        last_updated_by,
        last_update_date,
        last_update_login)
      VALUES (
        l_dct_rec.id,
        l_dct_rec.org_id,
        l_dct_rec.rmr_id,
        l_dct_rec.ico_id,
        l_dct_rec.iln_id,
        l_dct_rec.date_effective_from,
        l_dct_rec.object_version_number,
        l_dct_rec.created_by,
        l_dct_rec.date_effective_to,
        l_dct_rec.creation_date,
        l_dct_rec.last_updated_by,
        l_dct_rec.last_update_date,
        l_dct_rec.last_update_login);
Line: 1317

  END insert_row;
Line: 1321

  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_dctv_rec                     IN dctv_rec_type,
    x_dctv_rec                     OUT NOCOPY dctv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1331

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

      l_dctv_rec.LAST_UPDATE_DATE := SYSDATE;
Line: 1348

      l_dctv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 1349

      l_dctv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 1418

    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_dct_rec,
      lx_dct_rec
    );
Line: 1466

  END insert_row;
Line: 1470

  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_dctv_tbl                     IN dctv_tbl_type,
    x_dctv_tbl                     OUT NOCOPY dctv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1480

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

        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_dctv_rec                     => p_dctv_tbl(i),
          x_dctv_rec                     => x_dctv_tbl(i));
Line: 1549

  END insert_row;
Line: 1567

    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_DF_CTGY_RMK_TMS
     WHERE ID = p_dct_rec.id
       AND OBJECT_VERSION_NUMBER = p_dct_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
Line: 1574

    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_DF_CTGY_RMK_TMS
    WHERE ID = p_dct_rec.id;
Line: 1615

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

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

  PROCEDURE update_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_dct_rec                      IN dct_rec_type,
    x_dct_rec                      OUT NOCOPY dct_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1836

    l_api_name                     CONSTANT VARCHAR2(30) := 'TMS_update_row';
Line: 1898

      IF (x_dct_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_dct_rec.last_updated_by := l_dct_rec.last_updated_by;
Line: 1902

      IF (x_dct_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_dct_rec.last_update_date := l_dct_rec.last_update_date;
Line: 1906

      IF (x_dct_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_dct_rec.last_update_login := l_dct_rec.last_update_login;
Line: 1950

    UPDATE  OKL_DF_CTGY_RMK_TMS
    SET ORG_ID = l_def_dct_rec.org_id,
        RMR_ID = l_def_dct_rec.rmr_id,
        ICO_ID = l_def_dct_rec.ico_id,
        ILN_ID = l_def_dct_rec.iln_id,
        DATE_EFFECTIVE_FROM = l_def_dct_rec.date_effective_from,
        OBJECT_VERSION_NUMBER = l_def_dct_rec.object_version_number,
        CREATED_BY = l_def_dct_rec.created_by,
        DATE_EFFECTIVE_TO = l_def_dct_rec.date_effective_to,
        CREATION_DATE = l_def_dct_rec.creation_date,
        LAST_UPDATED_BY = l_def_dct_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_dct_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_dct_rec.last_update_login
    WHERE ID = l_def_dct_rec.id;
Line: 1998

  END update_row;
Line: 2002

  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_dctv_rec                     IN dctv_rec_type,
    x_dctv_rec                     OUT NOCOPY dctv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 2012

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

      l_dctv_rec.LAST_UPDATE_DATE := SYSDATE;
Line: 2027

      l_dctv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 2028

      l_dctv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 2088

      IF (x_dctv_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_dctv_rec.last_updated_by := l_dctv_rec.last_updated_by;
Line: 2092

      IF (x_dctv_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_dctv_rec.last_update_date := l_dctv_rec.last_update_date;
Line: 2096

      IF (x_dctv_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_dctv_rec.last_update_login := l_dctv_rec.last_update_login;
Line: 2167

    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_dct_rec,
      lx_dct_rec
    );
Line: 2214

  END update_row;
Line: 2218

  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_dctv_tbl                     IN dctv_tbl_type,
    x_dctv_tbl                     OUT NOCOPY dctv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 2228

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

        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_dctv_rec                     => p_dctv_tbl(i),
          x_dctv_rec                     => x_dctv_tbl(i));
Line: 2296

  END update_row;
Line: 2304

  PROCEDURE delete_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_dct_rec                      IN dct_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 2312

    l_api_name                     CONSTANT VARCHAR2(30) := 'TMS_delete_row';
Line: 2326

    DELETE FROM OKL_DF_CTGY_RMK_TMS
     WHERE ID = l_dct_rec.id;
Line: 2361

  END delete_row;
Line: 2365

  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_dctv_rec                     IN dctv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 2374

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

    delete_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_dct_rec
    );
Line: 2442

  END delete_row;
Line: 2446

  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_dctv_tbl                     IN dctv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 2455

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

        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_dctv_rec                     => p_dctv_tbl(i));
Line: 2522

  END delete_row;