DBA Data[Home] [Help]

APPS.OKL_RPP_PVT SQL Statements

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

Line: 66

    CURSOR c_pk_csr IS SELECT okl_report_parameters_s.NEXTVAL FROM DUAL;
Line: 107

    SELECT
            PARAMETER_ID,
            REPORT_ID,
            PARAMETER_TYPE_CODE,
            PARAM_NUM_VALUE1,
            PARAM_CHAR_VALUE1,
            PARAM_DATE_VALUE1,
            CREATED_BY,
            SOURCE_TABLE,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okl_Report_Parameters
     WHERE okl_report_parameters.parameter_id = p_parameter_id;
Line: 138

              l_rpp_rec.last_updated_by,
              l_rpp_rec.last_update_date,
              l_rpp_rec.last_update_login;
Line: 209

    IF (l_rpp_rec.last_updated_by = OKL_API.G_MISS_NUM ) THEN
      l_rpp_rec.last_updated_by := NULL;
Line: 212

    IF (l_rpp_rec.last_update_date = OKL_API.G_MISS_DATE ) THEN
      l_rpp_rec.last_update_date := NULL;
Line: 215

    IF (l_rpp_rec.last_update_login = OKL_API.G_MISS_NUM ) THEN
      l_rpp_rec.last_update_login := NULL;
Line: 313

       select 1
	from okl_report_parameters a,
	    fnd_lookups b
	where b.lookup_type='OKL_PARAMETER_TYPES'
	and b.lookup_code = a.parameter_type_code
	and a.parameter_type_code = p_param_type_code
	and a.report_id = p_report_id;
Line: 323

	   SELECT 1
	   FROM FND_LOOKUPS
	   WHERE LOOKUP_TYPE = 'OKL_BOOK_CLASS'
	   AND LOOKUP_CODE = p_bcc_value;
Line: 676

  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_rpp_rec                      IN rpp_rec_type,
    x_rpp_rec                      OUT NOCOPY rpp_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 686

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

      l_rpp_rec.LAST_UPDATE_DATE := l_rpp_rec.CREATION_DATE;
Line: 701

      l_rpp_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 702

      l_rpp_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 758

    INSERT INTO OKL_REPORT_PARAMETERS(
      parameter_id,
      report_id,
      parameter_type_code,
      param_num_value1,
      param_char_value1,
      param_date_value1,
      created_by,
      source_table,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login)
    VALUES (
      l_def_rpp_rec.parameter_id,
      l_def_rpp_rec.report_id,
      l_def_rpp_rec.parameter_type,
      l_def_rpp_rec.param_num_value1,
      l_def_rpp_rec.param_char_value1,
      l_def_rpp_rec.param_date_value1,
      l_def_rpp_rec.created_by,
      l_def_rpp_rec.source_table,
      l_def_rpp_rec.creation_date,
      l_def_rpp_rec.last_updated_by,
      l_def_rpp_rec.last_update_date,
      l_def_rpp_rec.last_update_login);
Line: 819

  END insert_row;
Line: 823

  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_rpp_tbl                      IN rpp_tbl_type,
    x_rpp_tbl                      OUT NOCOPY rpp_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 834

    l_api_name                     CONSTANT VARCHAR2(30) := 'error_tbl_insert_row';
Line: 848

          insert_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKL_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_rpp_rec                      => p_rpp_tbl(i),
            x_rpp_rec                      => x_rpp_tbl(i));
Line: 916

  END insert_row;
Line: 921

  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_rpp_tbl                      IN rpp_tbl_type,
    x_rpp_tbl                      OUT NOCOPY rpp_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 931

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

      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_rpp_tbl                      => p_rpp_tbl,
        x_rpp_tbl                      => x_rpp_tbl,
        px_error_tbl                   => l_error_tbl);
Line: 980

  END insert_row;
Line: 997

    SELECT *
      FROM OKL_REPORT_PARAMETERS
     WHERE PARAMETER_ID = p_rpp_rec.parameter_id
    FOR UPDATE NOWAIT;
Line: 1033

      OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
Line: 1317

  PROCEDURE update_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_rpp_rec                      IN rpp_rec_type,
    x_rpp_rec                      OUT NOCOPY rpp_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1326

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

        IF x_rpp_rec.last_updated_by IS NULL OR x_rpp_rec.last_updated_by = OKL_API.G_MISS_NUM THEN
          x_rpp_rec.last_updated_by := l_rpp_rec.last_updated_by;
Line: 1376

        IF x_rpp_rec.last_update_date IS NULL OR x_rpp_rec.last_update_date = OKL_API.G_MISS_DATE THEN
          x_rpp_rec.last_update_date := l_rpp_rec.last_update_date;
Line: 1379

        IF x_rpp_rec.last_update_login = OKL_API.G_MISS_NUM THEN
          x_rpp_rec.last_update_login := l_rpp_rec.last_update_login;
Line: 1423

    UPDATE OKL_REPORT_PARAMETERS
    SET REPORT_ID = l_def_rpp_rec.report_id,
        PARAMETER_TYPE_CODE = l_def_rpp_rec.parameter_type,
        PARAM_NUM_VALUE1 = l_def_rpp_rec.param_num_value1,
        PARAM_CHAR_VALUE1 = l_def_rpp_rec.param_char_value1,
        PARAM_DATE_VALUE1 = l_def_rpp_rec.param_date_value1,
        CREATED_BY = l_def_rpp_rec.created_by,
        SOURCE_TABLE = l_def_rpp_rec.source_table,
        CREATION_DATE = l_def_rpp_rec.creation_date,
        LAST_UPDATED_BY = l_def_rpp_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_rpp_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_rpp_rec.last_update_login
    WHERE PARAMETER_ID = l_def_rpp_rec.parameter_id;
Line: 1471

  END update_row;
Line: 1475

  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_rpp_rec                      IN rpp_rec_type,
    x_rpp_rec                      OUT NOCOPY rpp_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1485

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

      l_rpp_rec.LAST_UPDATE_DATE := SYSDATE;
Line: 1500

      l_rpp_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 1501

      l_rpp_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 1547

        IF x_rpp_rec.last_updated_by IS NULL OR x_rpp_rec.last_updated_by = OKL_API.G_MISS_NUM THEN
          x_rpp_rec.last_updated_by := l_db_rpp_rec.last_updated_by;
Line: 1550

        IF x_rpp_rec.last_update_date IS NULL OR x_rpp_rec.last_update_date = OKL_API.G_MISS_DATE THEN
          x_rpp_rec.last_update_date := l_db_rpp_rec.last_update_date;
Line: 1553

        IF x_rpp_rec.last_update_login = OKL_API.G_MISS_NUM THEN
          x_rpp_rec.last_update_login := l_db_rpp_rec.last_update_login;
Line: 1637

    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_rpp_rec,
      lx_rpp_rec
    );
Line: 1684

  END update_row;
Line: 1688

  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_rpp_tbl                      IN rpp_tbl_type,
    x_rpp_tbl                      OUT NOCOPY rpp_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1699

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

          update_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKL_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_rpp_rec                      => p_rpp_tbl(i),
            x_rpp_rec                      => x_rpp_tbl(i));
Line: 1781

  END update_row;
Line: 1786

  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_rpp_tbl                      IN rpp_tbl_type,
    x_rpp_tbl                      OUT NOCOPY rpp_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1796

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

      update_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_rpp_tbl                      => p_rpp_tbl,
        x_rpp_tbl                      => x_rpp_tbl,
        px_error_tbl                   => l_error_tbl);
Line: 1845

  END update_row;
Line: 1853

  PROCEDURE delete_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_rpp_rec                      IN rpp_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1861

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

    DELETE FROM OKL_REPORT_PARAMETERS
     WHERE PARAMETER_ID = p_rpp_rec.parameter_id;
Line: 1912

  END delete_row;
Line: 1916

  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_rpp_rec                      IN rpp_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1925

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

    delete_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_rpp_rec
    );
Line: 1992

  END delete_row;
Line: 1996

  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_rpp_tbl                      IN rpp_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 2006

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

          delete_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKL_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_rpp_rec                      => p_rpp_tbl(i));
Line: 2087

  END delete_row;
Line: 2092

  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_rpp_tbl                      IN rpp_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 2101

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

      delete_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_rpp_tbl                      => p_rpp_tbl,
        px_error_tbl                   => l_error_tbl);
Line: 2149

  END delete_row;