DBA Data[Home] [Help]

APPS.OKL_RSP_PVT SQL Statements

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

Line: 66

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

    SELECT
            STREAM_PARAMETER_ID,
            REPORT_ID,
            STY_ID,
            ACTIVITY_CODE,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okl_Report_Stream_Params
     WHERE okl_report_stream_params.stream_parameter_id = p_stream_parameter_id;
Line: 132

              l_rps_rec.last_updated_by,
              l_rps_rec.last_update_date,
              l_rps_rec.last_update_login;
Line: 194

    IF (l_rps_rec.last_updated_by = OKL_API.G_MISS_NUM ) THEN
      l_rps_rec.last_updated_by := NULL;
Line: 197

    IF (l_rps_rec.last_update_date = OKL_API.G_MISS_DATE ) THEN
      l_rps_rec.last_update_date := NULL;
Line: 200

    IF (l_rps_rec.last_update_login = OKL_API.G_MISS_NUM ) THEN
      l_rps_rec.last_update_login := NULL;
Line: 289

	   SELECT 1
	   FROM FND_LOOKUPS
	   WHERE LOOKUP_TYPE = 'OKL_REPORT_ACTIVITY'
	   AND LOOKUP_CODE = p_rpt_act_code;
Line: 351

       SELECT 1
       FROM OKL_REPORT_STREAM_PARAMS
       WHERE REPORT_ID = p_report_id
       AND STY_ID = p_sty_id
       AND STREAM_PARAMETER_ID <> p_stream_param_id;
Line: 694

  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_rps_rec                      IN rps_rec_type,
    x_rps_rec                      OUT NOCOPY rps_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 704

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

      l_rps_rec.LAST_UPDATE_DATE := l_rps_rec.CREATION_DATE;
Line: 719

      l_rps_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 720

      l_rps_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 776

    INSERT INTO OKL_REPORT_STREAM_PARAMS(
      stream_parameter_id,
      report_id,
      sty_id,
      activity_code,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login)
    VALUES (
      l_def_rps_rec.stream_parameter_id,
      l_def_rps_rec.report_id,
      l_def_rps_rec.sty_id,
      l_def_rps_rec.activity_code,
      l_def_rps_rec.created_by,
      l_def_rps_rec.creation_date,
      l_def_rps_rec.last_updated_by,
      l_def_rps_rec.last_update_date,
      l_def_rps_rec.last_update_login);
Line: 831

  END insert_row;
Line: 835

  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_rps_tbl                      IN rps_tbl_type,
    x_rps_tbl                      OUT NOCOPY rps_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 846

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

          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_rps_rec                      => p_rps_tbl(i),
            x_rps_rec                      => x_rps_tbl(i));
Line: 928

  END insert_row;
Line: 933

  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_rps_tbl                      IN rps_tbl_type,
    x_rps_tbl                      OUT NOCOPY rps_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 943

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

      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_rps_tbl                      => p_rps_tbl,
        x_rps_tbl                      => x_rps_tbl,
        px_error_tbl                   => l_error_tbl);
Line: 992

  END insert_row;
Line: 1009

    SELECT *
      FROM OKL_REPORT_STREAM_PARAMS
     WHERE STREAM_PARAMETER_ID = p_rps_rec.stream_parameter_id
    FOR UPDATE NOWAIT;
Line: 1045

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

  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_rps_rec                      IN rps_rec_type,
    x_rps_rec                      OUT NOCOPY rps_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1338

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

        IF x_rps_rec.last_updated_by IS NULL OR x_rps_rec.last_updated_by = OKL_API.G_MISS_NUM THEN
          x_rps_rec.last_updated_by := l_rps_rec.last_updated_by;
Line: 1379

        IF x_rps_rec.last_update_date IS NULL OR x_rps_rec.last_update_date = OKL_API.G_MISS_DATE THEN
          x_rps_rec.last_update_date := l_rps_rec.last_update_date;
Line: 1382

        IF x_rps_rec.last_update_login = OKL_API.G_MISS_NUM THEN
          x_rps_rec.last_update_login := l_rps_rec.last_update_login;
Line: 1427

    UPDATE OKL_REPORT_STREAM_PARAMS
    SET REPORT_ID = l_def_rps_rec.report_id,
        STY_ID = l_def_rps_rec.sty_id,
        ACTIVITY_CODE = l_def_rps_rec.activity_code,
        CREATED_BY = l_def_rps_rec.created_by,
        CREATION_DATE = l_def_rps_rec.creation_date,
        LAST_UPDATED_BY = l_def_rps_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_rps_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_rps_rec.last_update_login
    WHERE STREAM_PARAMETER_ID = l_def_rps_rec.stream_parameter_id;
Line: 1472

  END update_row;
Line: 1476

  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_rps_rec                      IN rps_rec_type,
    x_rps_rec                      OUT NOCOPY rps_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1486

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

      l_rps_rec.LAST_UPDATE_DATE := SYSDATE;
Line: 1501

      l_rps_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 1502

      l_rps_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 1539

        IF x_rps_rec.last_updated_by IS NULL OR x_rps_rec.last_updated_by = OKL_API.G_MISS_NUM THEN
          x_rps_rec.last_updated_by := l_db_rps_rec.last_updated_by;
Line: 1542

        IF x_rps_rec.last_update_date IS NULL OR x_rps_rec.last_update_date = OKL_API.G_MISS_DATE THEN
          x_rps_rec.last_update_date := l_db_rps_rec.last_update_date;
Line: 1545

        IF x_rps_rec.last_update_login = OKL_API.G_MISS_NUM THEN
          x_rps_rec.last_update_login := l_db_rps_rec.last_update_login;
Line: 1629

    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_rps_rec,
      lx_rps_rec
    );
Line: 1676

  END update_row;
Line: 1680

  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_rps_tbl                      IN rps_tbl_type,
    x_rps_tbl                      OUT NOCOPY rps_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_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                => 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_rps_rec                      => p_rps_tbl(i),
            x_rps_rec                      => x_rps_tbl(i));
Line: 1773

  END update_row;
Line: 1778

  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_rps_tbl                      IN rps_tbl_type,
    x_rps_tbl                      OUT NOCOPY rps_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                => OKL_API.G_FALSE,
        x_return_status                => x_return_status,
        x_msg_count                    => x_msg_count,
        x_msg_data                     => x_msg_data,
        p_rps_tbl                      => p_rps_tbl,
        x_rps_tbl                      => x_rps_tbl,
        px_error_tbl                   => l_error_tbl);
Line: 1837

  END update_row;
Line: 1845

  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_rps_rec                      IN rps_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_REPORT_STREAM_PARAMS
     WHERE STREAM_PARAMETER_ID = p_rps_rec.stream_parameter_id;
Line: 1904

  END delete_row;
Line: 1908

  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_rps_rec                      IN rps_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1917

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

    delete_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_rps_rec
    );
Line: 1984

  END delete_row;
Line: 1988

  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_rps_tbl                      IN rps_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1998

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

          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_rps_rec                      => p_rps_tbl(i));
Line: 2079

  END delete_row;
Line: 2084

  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_rps_tbl                      IN rps_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 2093

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

      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_rps_tbl                      => p_rps_tbl,
        px_error_tbl                   => l_error_tbl);
Line: 2141

  END delete_row;