DBA Data[Home] [Help]

APPS.OKS_PBR_PVT SQL Statements

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

Line: 101

    SELECT
            ID,
            BSL_ID,
            BCL_ID,
            CLE_ID,
            CHR_ID,
            LINE_DETAIL_INDEX,
            LINE_INDEX,
            PRICING_CONTEXT,
            PRICING_METHOD,
            QUANTITY_FROM,
            QUANTITY_TO,
            QUANTITY,
            BREAK_UOM,
            PRORATE,
            UNIT_PRICE,
            AMOUNT,
            PRICE_LIST_ID,
            VALIDATED_FLAG,
            STATUS_CODE,
            STATUS_TEXT,
            LOCK_FLAG,
            LOCKED_PRICE_LIST_ID,
            LOCKED_PRICE_LIST_LINE_ID,
            PRICE_LIST_LINE_ID,
            OBJECT_VERSION_NUMBER,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Oks_Price_Breaks_V
     WHERE oks_price_breaks_v.id = p_id;
Line: 168

              l_pbrv_rec.last_updated_by,
              l_pbrv_rec.last_update_date,
              l_pbrv_rec.last_update_login;
Line: 212

    SELECT
            ID,
            BSL_ID,
            BCL_ID,
            CLE_ID,
            CHR_ID,
            LINE_DETAIL_INDEX,
            LINE_INDEX,
            PRICING_CONTEXT,
            PRICING_METHOD,
            QUANTITY_FROM,
            QUANTITY_TO,
            QUANTITY,
            BREAK_UOM,
            PRORATE,
            UNIT_PRICE,
            AMOUNT,
            PRICE_LIST_ID,
            VALIDATED_FLAG,
            STATUS_CODE,
            STATUS_TEXT,
            LOCK_FLAG,
            LOCKED_PRICE_LIST_ID,
            LOCKED_PRICE_LIST_LINE_ID,
            PRICE_LIST_LINE_ID,
            OBJECT_VERSION_NUMBER,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Oks_Price_Breaks
     WHERE oks_price_breaks.id  = p_id;
Line: 279

              l_pbr_rec.last_updated_by,
              l_pbr_rec.last_update_date,
              l_pbr_rec.last_update_login;
Line: 404

    IF (l_pbrv_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
      l_pbrv_rec.last_updated_by := NULL;
Line: 407

    IF (l_pbrv_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
      l_pbrv_rec.last_update_date := NULL;
Line: 410

    IF (l_pbrv_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
      l_pbrv_rec.last_update_login := NULL;
Line: 576

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

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

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

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

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

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

  PROCEDURE insert_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_pbr_rec                      IN pbr_rec_type,
    x_pbr_rec                      OUT NOCOPY pbr_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 869

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

    INSERT INTO OKS_PRICE_BREAKS(
      id,
      bsl_id,
      bcl_id,
      cle_id,
      chr_id,
      line_detail_index,
      line_index,
      pricing_context,
      pricing_method,
      quantity_from,
      quantity_to,
      quantity,
      break_uom,
      prorate,
      unit_price,
      amount,
      price_list_id,
      validated_flag,
      status_code,
      status_text,
      lock_flag,
      locked_price_list_id,
      locked_price_list_line_id,
      price_list_line_id,
      object_version_number,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login)
    VALUES (
      l_pbr_rec.id,
      l_pbr_rec.bsl_id,
      l_pbr_rec.bcl_id,
      l_pbr_rec.cle_id,
      l_pbr_rec.chr_id,
      l_pbr_rec.line_detail_index,
      l_pbr_rec.line_index,
      l_pbr_rec.pricing_context,
      l_pbr_rec.pricing_method,
      l_pbr_rec.quantity_from,
      l_pbr_rec.quantity_to,
      l_pbr_rec.quantity,
      l_pbr_rec.break_uom,
      l_pbr_rec.prorate,
      l_pbr_rec.unit_price,
      l_pbr_rec.amount,
      l_pbr_rec.price_list_id,
      l_pbr_rec.validated_flag,
      l_pbr_rec.status_code,
      l_pbr_rec.status_text,
      l_pbr_rec.lock_flag,
      l_pbr_rec.locked_price_list_id,
      l_pbr_rec.locked_price_list_line_id,
      l_pbr_rec.price_list_line_id,
      l_pbr_rec.object_version_number,
      l_pbr_rec.created_by,
      l_pbr_rec.creation_date,
      l_pbr_rec.last_updated_by,
      l_pbr_rec.last_update_date,
      l_pbr_rec.last_update_login);
Line: 1002

  END insert_row;
Line: 1006

  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_pbrv_rec                     IN pbrv_rec_type,
    x_pbrv_rec                     OUT NOCOPY pbrv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1016

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

      l_pbrv_rec.LAST_UPDATE_DATE := l_pbrv_rec.CREATION_DATE;
Line: 1033

      l_pbrv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 1034

      l_pbrv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 1098

    insert_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_pbr_rec,
      lx_pbr_rec
    );
Line: 1147

  END insert_row;
Line: 1151

  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_pbrv_tbl                     IN pbrv_tbl_type,
    x_pbrv_tbl                     OUT NOCOPY pbrv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1162

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_error_tbl_insert_row';
Line: 1176

          insert_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_pbrv_rec                     => p_pbrv_tbl(i),
            x_pbrv_rec                     => x_pbrv_tbl(i));
Line: 1244

  END insert_row;
Line: 1251

  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_pbrv_tbl                     IN pbrv_tbl_type,
    x_pbrv_tbl                     OUT NOCOPY pbrv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1261

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

      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_pbrv_tbl                     => p_pbrv_tbl,
        x_pbrv_tbl                     => x_pbrv_tbl,
        px_error_tbl                   => l_error_tbl);
Line: 1310

  END insert_row;
Line: 1328

    SELECT OBJECT_VERSION_NUMBER
      FROM OKS_PRICE_BREAKS
     WHERE ID = p_pbr_rec.id
       AND OBJECT_VERSION_NUMBER = p_pbr_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
Line: 1335

    SELECT OBJECT_VERSION_NUMBER
      FROM OKS_PRICE_BREAKS
     WHERE ID = p_pbr_rec.id;
Line: 1376

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

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

  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_pbr_rec                      IN pbr_rec_type,
    x_pbr_rec                      OUT NOCOPY pbr_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1674

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

        IF (x_pbr_rec.last_updated_by = OKC_API.G_MISS_NUM)
        THEN
          x_pbr_rec.last_updated_by := l_pbr_rec.last_updated_by;
Line: 1806

        IF (x_pbr_rec.last_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_pbr_rec.last_update_date := l_pbr_rec.last_update_date;
Line: 1810

        IF (x_pbr_rec.last_update_login = OKC_API.G_MISS_NUM)
        THEN
          x_pbr_rec.last_update_login := l_pbr_rec.last_update_login;
Line: 1856

    UPDATE OKS_PRICE_BREAKS
    SET BSL_ID = l_def_pbr_rec.bsl_id,
        BCL_ID = l_def_pbr_rec.bcl_id,
        CLE_ID = l_def_pbr_rec.cle_id,
        CHR_ID = l_def_pbr_rec.chr_id,
        LINE_DETAIL_INDEX = l_def_pbr_rec.line_detail_index,
        LINE_INDEX = l_def_pbr_rec.line_index,
        PRICING_CONTEXT = l_def_pbr_rec.pricing_context,
        PRICING_METHOD = l_def_pbr_rec.pricing_method,
        QUANTITY_FROM = l_def_pbr_rec.quantity_from,
        QUANTITY_TO = l_def_pbr_rec.quantity_to,
        QUANTITY = l_def_pbr_rec.quantity,
        BREAK_UOM = l_def_pbr_rec.break_uom,
        PRORATE = l_def_pbr_rec.prorate,
        UNIT_PRICE = l_def_pbr_rec.unit_price,
        AMOUNT = l_def_pbr_rec.amount,
        PRICE_LIST_ID = l_def_pbr_rec.price_list_id,
        VALIDATED_FLAG = l_def_pbr_rec.validated_flag,
        STATUS_CODE = l_def_pbr_rec.status_code,
        STATUS_TEXT = l_def_pbr_rec.status_text,
        LOCK_FLAG = l_def_pbr_rec.lock_flag,
        LOCKED_PRICE_LIST_ID = l_def_pbr_rec.locked_price_list_id,
        LOCKED_PRICE_LIST_LINE_ID = l_def_pbr_rec.locked_price_list_line_id,
        PRICE_LIST_LINE_ID = l_def_pbr_rec.price_list_line_id,
        OBJECT_VERSION_NUMBER = l_def_pbr_rec.object_version_number,
        CREATED_BY = l_def_pbr_rec.created_by,
        CREATION_DATE = l_def_pbr_rec.creation_date,
        LAST_UPDATED_BY = l_def_pbr_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_pbr_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_pbr_rec.last_update_login
    WHERE ID = l_def_pbr_rec.id;
Line: 1922

  END update_row;
Line: 1926

  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_pbrv_rec                     IN pbrv_rec_type,
    x_pbrv_rec                     OUT NOCOPY pbrv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1936

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

      l_pbrv_rec.LAST_UPDATE_DATE := SYSDATE;
Line: 1952

      l_pbrv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 1953

      l_pbrv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 2076

        IF (x_pbrv_rec.last_updated_by = OKC_API.G_MISS_NUM)
        THEN
          x_pbrv_rec.last_updated_by := l_db_pbrv_rec.last_updated_by;
Line: 2080

        IF (x_pbrv_rec.last_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_pbrv_rec.last_update_date := l_db_pbrv_rec.last_update_date;
Line: 2084

        IF (x_pbrv_rec.last_update_login = OKC_API.G_MISS_NUM)
        THEN
          x_pbrv_rec.last_update_login := l_db_pbrv_rec.last_update_login;
Line: 2169

    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_pbr_rec,
      lx_pbr_rec
    );
Line: 2217

  END update_row;
Line: 2221

  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_pbrv_tbl                     IN pbrv_tbl_type,
    x_pbrv_tbl                     OUT NOCOPY pbrv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 2232

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

          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_pbrv_rec                     => p_pbrv_tbl(i),
            x_pbrv_rec                     => x_pbrv_tbl(i));
Line: 2314

  END update_row;
Line: 2321

  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_pbrv_tbl                     IN pbrv_tbl_type,
    x_pbrv_tbl                     OUT NOCOPY pbrv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 2331

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

      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_pbrv_tbl                     => p_pbrv_tbl,
        x_pbrv_tbl                     => x_pbrv_tbl,
        px_error_tbl                   => l_error_tbl);
Line: 2380

  END update_row;
Line: 2388

  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_pbr_rec                      IN pbr_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 2396

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

    DELETE FROM OKS_PRICE_BREAKS
     WHERE ID = p_pbr_rec.id;
Line: 2447

  END delete_row;
Line: 2451

  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_pbrv_rec                     IN pbrv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 2460

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

    delete_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_pbr_rec
    );
Line: 2529

  END delete_row;
Line: 2533

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

    l_api_version                  CONSTANT NUMBER := 1;
Line: 2543

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

          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_pbrv_rec                     => p_pbrv_tbl(i));
Line: 2624

  END delete_row;
Line: 2629

  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_pbrv_tbl                     IN pbrv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 2638

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

      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_pbrv_tbl                     => p_pbrv_tbl,
        px_error_tbl                   => l_error_tbl);
Line: 2686

  END delete_row;