APPS.OKC_UBL_PVT SQL Statements

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

Line: 358

  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_ubn_rec                      IN ubn_rec_type,
    x_ubn_rec                      OUT NOCOPY ubn_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 367

    l_api_name                     CONSTANT VARCHAR2(30) := 'BINS_insert_row';

Line: 411

    INSERT INTO OKC_USER_BINS(
        contract_id,
        contract_number,
        bin_type,
        contract_type,
        program_name,
        created_by,
        creation_date,
        contract_number_modifier,
        short_description,
	   id)
      VALUES (
        l_ubn_rec.contract_id,
        l_ubn_rec.contract_number,
        l_ubn_rec.bin_type,
        l_ubn_rec.contract_type,
        l_ubn_rec.program_name,
        l_ubn_rec.created_by,
        l_ubn_rec.creation_date,
        l_ubn_rec.contract_number_modifier,
        l_ubn_rec.short_description,
	   l_ubn_rec.id);

Line: 468

  END insert_row;

Line: 472

  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_ubnv_rec                     IN ubnv_rec_type,
    x_ubnv_rec                     OUT NOCOPY ubnv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 482

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

Line: 568

    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_ubn_rec,
      lx_ubn_rec
    );

Line: 618

  END insert_row;

Line: 622

  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_ubnv_tbl                     IN ubnv_tbl_type,
    x_ubnv_tbl                     OUT NOCOPY ubnv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 632

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

Line: 641

        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_ubnv_rec                     => p_ubnv_tbl(i),
          x_ubnv_rec                     => x_ubnv_tbl(i));

Line: 684

  END insert_row;

Line: 702

    SELECT *
      FROM OKC_USER_BINS
    FOR UPDATE NOWAIT;

Line: 737

      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 961

  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_ubn_rec                      IN ubn_rec_type,
    x_ubn_rec                      OUT NOCOPY ubn_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 970

    l_api_name                     CONSTANT VARCHAR2(30) := 'BINS_update_row';

Line: 1068

    UPDATE  OKC_USER_BINS
    SET CONTRACT_ID = l_def_ubn_rec.contract_id,
        CONTRACT_NUMBER = l_def_ubn_rec.contract_number,
        BIN_TYPE = l_def_ubn_rec.bin_type,
        CONTRACT_TYPE = l_def_ubn_rec.contract_type,
        PROGRAM_NAME = l_def_ubn_rec.program_name,
        CREATED_BY = l_def_ubn_rec.created_by,
        CREATION_DATE = l_def_ubn_rec.creation_date,
        CONTRACT_NUMBER_MODIFIER = l_def_ubn_rec.contract_number_modifier,
        SHORT_DESCRIPTION = l_def_ubn_rec.short_description
    WHERE id = l_def_ubn_rec.id;

Line: 1113

  END update_row;

Line: 1117

  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_ubnv_rec                     IN ubnv_rec_type,
    x_ubnv_rec                     OUT NOCOPY ubnv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1127

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

Line: 1262

    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_ubn_rec,
      lx_ubn_rec
    );

Line: 1309

  END update_row;

Line: 1313

  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_ubnv_tbl                     IN ubnv_tbl_type,
    x_ubnv_tbl                     OUT NOCOPY ubnv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1323

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

Line: 1332

        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_ubnv_rec                     => p_ubnv_tbl(i),
          x_ubnv_rec                     => x_ubnv_tbl(i));

Line: 1375

  END update_row;

Line: 1383

  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_ubn_rec                      IN ubn_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1391

    l_api_name                     CONSTANT VARCHAR2(30) := 'BINS_delete_row';

Line: 1405

    DELETE FROM OKC_USER_BINS
     WHERE id = l_ubn_rec.id;

Line: 1439

  END delete_row;

Line: 1443

  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_ubnv_rec                     IN ubnv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1452

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

Line: 1476

    delete_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_ubn_rec
    );

Line: 1520

  END delete_row;

Line: 1524

  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_ubnv_tbl                     IN ubnv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1533

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

Line: 1542

        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_ubnv_rec                     => p_ubnv_tbl(i));

Line: 1584

  END delete_row;