DBA Data[Home] [Help]

APPS.OKL_RAP_PVT SQL Statements

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

Line: 66

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

    SELECT
            ACC_PARAMETER_ID,
            REPORT_ID,
            ACCT_PARAM_TYPE_CODE,
            SEGMENT_RANGE_FROM,
            SEGMENT_RANGE_TO,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okl_Report_Acc_Params
     WHERE okl_report_acc_params.acc_parameter_id = p_acc_parameter_id;
Line: 134

              l_rap_rec.last_updated_by,
              l_rap_rec.last_update_date,
              l_rap_rec.last_update_login;
Line: 199

    IF (l_rap_rec.last_updated_by = OKL_API.G_MISS_NUM ) THEN
      l_rap_rec.last_updated_by := NULL;
Line: 202

    IF (l_rap_rec.last_update_date = OKL_API.G_MISS_DATE ) THEN
      l_rap_rec.last_update_date := NULL;
Line: 205

    IF (l_rap_rec.last_update_login = OKL_API.G_MISS_NUM ) THEN
      l_rap_rec.last_update_login := NULL;
Line: 279

       select 1
	from okl_report_acc_params a,
	    fnd_lookups b
	where b.lookup_type='OKL_ACC_PARAMETER_TYPES'
	and b.lookup_code = a.acct_param_type_code
	and a.acct_param_type_code = p_acct_param_type_code
	and a.report_id = p_report_id
	and a.segment_range_from = p_seg_range_from;
Line: 607

  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_rap_rec                      IN rap_rec_type,
    x_rap_rec                      OUT NOCOPY rap_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 617

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

      l_rap_rec.LAST_UPDATE_DATE := l_rap_rec.CREATION_DATE;
Line: 632

      l_rap_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 633

      l_rap_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 690

    INSERT INTO OKL_REPORT_ACC_PARAMS(
      acc_parameter_id,
      report_id,
      acct_param_type_code,
      segment_range_from,
      segment_range_to,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login)
    VALUES (
      l_def_rap_rec.acc_parameter_id,
      l_def_rap_rec.report_id,
      l_def_rap_rec.acct_param_type_code,
      l_def_rap_rec.segment_range_from,
      l_def_rap_rec.segment_range_to,
      l_def_rap_rec.created_by,
      l_def_rap_rec.creation_date,
      l_def_rap_rec.last_updated_by,
      l_def_rap_rec.last_update_date,
      l_def_rap_rec.last_update_login);
Line: 747

  END insert_row;
Line: 751

  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_rap_tbl                      IN rap_tbl_type,
    x_rap_tbl                      OUT NOCOPY rap_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 762

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

          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_rap_rec                      => p_rap_tbl(i),
            x_rap_rec                      => x_rap_tbl(i));
Line: 844

  END insert_row;
Line: 849

  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_rap_tbl                      IN rap_tbl_type,
    x_rap_tbl                      OUT NOCOPY rap_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 859

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

      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_rap_tbl                      => p_rap_tbl,
        x_rap_tbl                      => x_rap_tbl,
        px_error_tbl                   => l_error_tbl);
Line: 908

  END insert_row;
Line: 925

    SELECT *
      FROM OKL_REPORT_ACC_PARAMS
     WHERE ACC_PARAMETER_ID = p_rap_rec.acc_parameter_id
    FOR UPDATE NOWAIT;
Line: 961

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

  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_rap_rec                      IN rap_rec_type,
    x_rap_rec                      OUT NOCOPY rap_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1254

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

        IF x_rap_rec.last_updated_by IS NULL OR x_rap_rec.last_updated_by = OKL_API.G_MISS_NUM THEN
          x_rap_rec.last_updated_by := l_rap_rec.last_updated_by;
Line: 1298

        IF x_rap_rec.last_update_date IS NULL OR x_rap_rec.last_update_date = OKL_API.G_MISS_DATE THEN
          x_rap_rec.last_update_date := l_rap_rec.last_update_date;
Line: 1301

        IF x_rap_rec.last_update_login = OKL_API.G_MISS_NUM THEN
          x_rap_rec.last_update_login := l_rap_rec.last_update_login;
Line: 1345

    UPDATE OKL_REPORT_ACC_PARAMS
    SET REPORT_ID = l_def_rap_rec.report_id,
        ACCT_PARAM_TYPE_CODE = l_def_rap_rec.acct_param_type_code,
        SEGMENT_RANGE_FROM = l_def_rap_rec.segment_range_from,
        SEGMENT_RANGE_TO = l_def_rap_rec.segment_range_to,
        CREATED_BY = l_def_rap_rec.created_by,
        CREATION_DATE = l_def_rap_rec.creation_date,
        LAST_UPDATED_BY = l_def_rap_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_rap_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_rap_rec.last_update_login
    WHERE ACC_PARAMETER_ID = l_def_rap_rec.acc_parameter_id;
Line: 1391

  END update_row;
Line: 1395

  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_rap_rec                      IN rap_rec_type,
    x_rap_rec                      OUT NOCOPY rap_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1405

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

      l_rap_rec.LAST_UPDATE_DATE := SYSDATE;
Line: 1420

      l_rap_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 1421

      l_rap_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 1461

        IF x_rap_rec.last_updated_by IS NULL OR x_rap_rec.last_updated_by = OKL_API.G_MISS_NUM THEN
          x_rap_rec.last_updated_by := l_db_rap_rec.last_updated_by;
Line: 1464

        IF x_rap_rec.last_update_date IS NULL OR x_rap_rec.last_update_date = OKL_API.G_MISS_DATE THEN
          x_rap_rec.last_update_date := l_db_rap_rec.last_update_date;
Line: 1467

        IF x_rap_rec.last_update_login = OKL_API.G_MISS_NUM THEN
          x_rap_rec.last_update_login := l_db_rap_rec.last_update_login;
Line: 1551

    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_rap_rec,
      lx_rap_rec
    );
Line: 1598

  END update_row;
Line: 1602

  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_rap_tbl                      IN rap_tbl_type,
    x_rap_tbl                      OUT NOCOPY rap_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1613

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

          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_rap_rec                      => p_rap_tbl(i),
            x_rap_rec                      => x_rap_tbl(i));
Line: 1695

  END update_row;
Line: 1700

  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_rap_tbl                      IN rap_tbl_type,
    x_rap_tbl                      OUT NOCOPY rap_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1710

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

      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_rap_tbl                      => p_rap_tbl,
        x_rap_tbl                      => x_rap_tbl,
        px_error_tbl                   => l_error_tbl);
Line: 1759

  END update_row;
Line: 1767

  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_rap_rec                      IN rap_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1775

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

    DELETE FROM OKL_REPORT_ACC_PARAMS
     WHERE ACC_PARAMETER_ID = p_rap_rec.acc_parameter_id;
Line: 1826

  END delete_row;
Line: 1830

  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_rap_rec                      IN rap_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1839

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

    delete_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_rap_rec
    );
Line: 1906

  END delete_row;
Line: 1910

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

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1920

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

          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_rap_rec                      => p_rap_tbl(i));
Line: 2001

  END delete_row;
Line: 2006

  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_rap_tbl                      IN rap_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 2015

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

      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_rap_tbl                      => p_rap_tbl,
        px_error_tbl                   => l_error_tbl);
Line: 2063

  END delete_row;