DBA Data[Home] [Help]

APPS.OKL_IPM_PVT SQL Statements

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

Line: 101

    SELECT
            ID,
            SOURCE_TABLE,
            SOURCE_ID,
            PARAM_NAME,
            PARAM_VALUE,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okl_Trx_Params_B
     WHERE okl_trx_params_b.id  = p_id;
Line: 128

              l_ipm_rec.last_updated_by,
              l_ipm_rec.last_update_date,
              l_ipm_rec.last_update_login;
Line: 193

    IF (l_ipm_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
      l_ipm_rec.last_updated_by := NULL;
Line: 196

    IF (l_ipm_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
      l_ipm_rec.last_update_date := NULL;
Line: 199

    IF (l_ipm_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
      l_ipm_rec.last_update_login := NULL;
Line: 458

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

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

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

  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_ipm_rec                      IN ipm_rec_type,
    x_ipm_rec                      OUT NOCOPY ipm_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 714

    l_api_name                     CONSTANT VARCHAR2(30) := 'B_insert_row';
Line: 729

      l_ipm_rec.LAST_UPDATE_DATE := SYSDATE;
Line: 730

      l_ipm_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
Line: 731

      l_ipm_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
Line: 794

    INSERT INTO OKL_TRX_PARAMS_B(
      id,
      source_table,
      source_id,
      param_name,
      param_value,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login)
    VALUES (
      l_ipm_rec.id,
      l_ipm_rec.source_table,
      l_ipm_rec.source_id,
      l_ipm_rec.param_name,
      l_ipm_rec.param_value,
      l_ipm_rec.created_by,
      l_ipm_rec.creation_date,
      l_ipm_rec.last_updated_by,
      l_ipm_rec.last_update_date,
      l_ipm_rec.last_update_login);
Line: 852

  END insert_row;
Line: 856

  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_ipm_tbl                     IN ipm_tbl_type,
    x_ipm_tbl                     OUT NOCOPY ipm_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 866

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

        insert_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => okl_api.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_ipm_rec                     => p_ipm_tbl(i),
          x_ipm_rec                     => x_ipm_tbl(i));
Line: 927

  END insert_row;
Line: 945

    SELECT *
      FROM OKL_TRX_PARAMS_B
     WHERE ID = p_ipm_rec.id
    FOR UPDATE NOWAIT;
Line: 981

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

      IF (l_lock_var.last_updated_by <> p_ipm_rec.last_updated_by) THEN
        OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
Line: 1016

      IF (l_lock_var.last_update_date <> p_ipm_rec.last_update_date) THEN
        OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
Line: 1020

      IF (l_lock_var.last_update_login <> p_ipm_rec.last_update_login) THEN
        OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
Line: 1302

  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_ipm_rec                      IN ipm_rec_type,
    x_ipm_rec                      OUT NOCOPY ipm_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1311

    l_api_name                     CONSTANT VARCHAR2(30) := 'B_update_row';
Line: 1359

        IF (x_ipm_rec.last_updated_by = OKC_API.G_MISS_NUM)
        THEN
          x_ipm_rec.last_updated_by := l_ipm_rec.last_updated_by;
Line: 1363

        IF (x_ipm_rec.last_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_ipm_rec.last_update_date := l_ipm_rec.last_update_date;
Line: 1367

        IF (x_ipm_rec.last_update_login = OKC_API.G_MISS_NUM)
        THEN
          x_ipm_rec.last_update_login := l_ipm_rec.last_update_login;
Line: 1412

    UPDATE OKL_TRX_PARAMS_B
    SET SOURCE_TABLE = l_def_ipm_rec.source_table,
        SOURCE_ID = l_def_ipm_rec.source_id,
        PARAM_NAME = l_def_ipm_rec.param_name,
        PARAM_VALUE = l_def_ipm_rec.param_value,
        CREATED_BY = l_def_ipm_rec.created_by,
        CREATION_DATE = l_def_ipm_rec.creation_date,
        LAST_UPDATED_BY = l_def_ipm_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_ipm_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_ipm_rec.last_update_login
    WHERE ID = l_def_ipm_rec.id;
Line: 1458

  END update_row;
Line: 1462

  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_ipm_rec                      IN ipm_rec_type,
    x_ipm_rec                      OUT NOCOPY ipm_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1472

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

      l_ipm_rec.LAST_UPDATE_DATE := SYSDATE;
Line: 1487

      l_ipm_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 1488

      l_ipm_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 1535

        IF (x_ipm_rec.last_updated_by = OKC_API.G_MISS_NUM)
        THEN
          x_ipm_rec.last_updated_by := l_db_ipm_rec.last_updated_by;
Line: 1539

        IF (x_ipm_rec.last_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_ipm_rec.last_update_date := l_db_ipm_rec.last_update_date;
Line: 1543

        IF (x_ipm_rec.last_update_login = OKC_API.G_MISS_NUM)
        THEN
          x_ipm_rec.last_update_login := l_db_ipm_rec.last_update_login;
Line: 1628

    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_ipm_rec,
      lx_ipm_rec
    );
Line: 1676

  END update_row;
Line: 1680

  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_ipm_tbl                      IN ipm_tbl_type,
    x_ipm_tbl                      OUT NOCOPY ipm_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1691

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_error_tbl_update_row';
Line: 1705

          update_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKC_API.G_FALSE,
            x_return_status                => l_error_rec.error_type,
            x_msg_count                    => l_error_rec.msg_count,
            x_msg_data                     => l_error_rec.msg_data,
            p_ipm_rec                      => p_ipm_tbl(i),
            x_ipm_rec                      => x_ipm_tbl(i));
Line: 1773

  END update_row;
Line: 1778

  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_ipm_tbl                      IN ipm_tbl_type,
    x_ipm_tbl                      OUT NOCOPY ipm_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1788

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

      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_ipm_tbl                      => p_ipm_tbl,
        x_ipm_tbl                      => x_ipm_tbl,
        px_error_tbl                   => l_error_tbl);
Line: 1837

  END update_row;
Line: 1845

  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_ipm_rec                      IN ipm_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1853

    l_api_name                     CONSTANT VARCHAR2(30) := 'B_delete_row';
Line: 1868

    DELETE FROM OKL_TRX_PARAMS_B
     WHERE ID = p_ipm_rec.id;
Line: 1904

  END delete_row;
Line: 1908

  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_ipm_rec                      IN ipm_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1917

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

    delete_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_ipm_rec
    );
Line: 1985

  END delete_row;
Line: 1989

  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_ipm_tbl                      IN ipm_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1999

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_error_tbl_delete_row';
Line: 2013

          delete_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKC_API.G_FALSE,
            x_return_status                => l_error_rec.error_type,
            x_msg_count                    => l_error_rec.msg_count,
            x_msg_data                     => l_error_rec.msg_data,
            p_ipm_rec                      => p_ipm_tbl(i));
Line: 2080

  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_ipm_tbl                      IN ipm_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 2094

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

      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_ipm_tbl                      => p_ipm_tbl,
        px_error_tbl                   => l_error_tbl);
Line: 2142

  END delete_row;