DBA Data[Home] [Help]

APPS.OKS_CONTRACT_SLL_PUB SQL Statements

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

Line: 28

      oks_sll_pvt.insert_row
           (
             p_api_version    => p_api_version,
             p_init_msg_list  => p_init_msg_list,
             x_return_status  => x_return_status,
             x_msg_count      => x_msg_count,
             x_msg_data       => x_msg_data,
             p_sllv_rec       => p_sllv_rec,
             x_sllv_rec       => x_sllv_rec
           );
Line: 66

      oks_sll_pvt.insert_row
           (
             p_api_version    => p_api_version,
             p_init_msg_list  => p_init_msg_list,
             x_return_status  => x_return_status,
             x_msg_count      => x_msg_count,
             x_msg_data       => x_msg_data,
             p_sllv_tbl       => p_sllv_tbl,
             x_sllv_tbl       => x_sllv_tbl,
             px_error_tbl     => px_error_tbl
           );
Line: 103

      oks_sll_pvt.insert_row
           (
             p_api_version    => p_api_version,
             p_init_msg_list  => p_init_msg_list,
             x_return_status  => x_return_status,
             x_msg_count      => x_msg_count,
             x_msg_data       => x_msg_data,
             p_sllv_tbl       => p_sllv_tbl,
             x_sllv_tbl       => x_sllv_tbl
           );
Line: 116

  PROCEDURE update_sll(
    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_sllv_rec                     IN sllv_rec_type,
    x_sllv_rec                     OUT NOCOPY sllv_rec_type,
    p_validate_yn                  IN VARCHAR2) IS
  BEGIN
    x_return_status := G_RET_STS_SUCCESS;
Line: 139

      oks_sll_pvt.update_row
           (
             p_api_version    => p_api_version,
             p_init_msg_list  => p_init_msg_list,
             x_return_status  => x_return_status,
             x_msg_count      => x_msg_count,
             x_msg_data       => x_msg_data,
             p_sllv_rec       => p_sllv_rec,
             x_sllv_rec       => x_sllv_rec
           );
Line: 150

  END update_sll;
Line: 152

  PROCEDURE update_sll(
    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_sllv_tbl                     IN sllv_tbl_type,
    x_sllv_tbl                     OUT NOCOPY sllv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE,
    p_validate_yn                  IN VARCHAR2) IS
  BEGIN
    x_return_status := G_RET_STS_SUCCESS;
Line: 177

      oks_sll_pvt.update_row
           (
             p_api_version    => p_api_version,
             p_init_msg_list  => p_init_msg_list,
             x_return_status  => x_return_status,
             x_msg_count      => x_msg_count,
             x_msg_data       => x_msg_data,
             p_sllv_tbl       => p_sllv_tbl,
             x_sllv_tbl       => x_sllv_tbl,
             px_error_tbl     => px_error_tbl
           );
Line: 189

  END update_sll;
Line: 191

  PROCEDURE update_sll(
    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_sllv_tbl                     IN sllv_tbl_type,
    x_sllv_tbl                     OUT NOCOPY sllv_tbl_type,
    p_validate_yn                  IN VARCHAR2) IS
  BEGIN
    x_return_status := G_RET_STS_SUCCESS;
Line: 214

      oks_sll_pvt.update_row
           (
             p_api_version    => p_api_version,
             p_init_msg_list  => p_init_msg_list,
             x_return_status  => x_return_status,
             x_msg_count      => x_msg_count,
             x_msg_data       => x_msg_data,
             p_sllv_tbl       => p_sllv_tbl,
             x_sllv_tbl       => x_sllv_tbl
           );
Line: 225

  END update_sll;
Line: 286

  PROCEDURE delete_sll(
    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_sllv_rec                     IN sllv_rec_type) IS
  BEGIN
    oks_sll_pvt.delete_row
           (
             p_api_version    => p_api_version,
             p_init_msg_list  => p_init_msg_list,
             x_return_status  => x_return_status,
             x_msg_count      => x_msg_count,
             x_msg_data       => x_msg_data,
             p_sllv_rec       => p_sllv_rec
           );
Line: 303

  END delete_sll;
Line: 305

  PROCEDURE delete_sll(
    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_sllv_tbl                     IN sllv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
  BEGIN
    oks_sll_pvt.delete_row
           (
             p_api_version    => p_api_version,
             p_init_msg_list  => p_init_msg_list,
             x_return_status  => x_return_status,
             x_msg_count      => x_msg_count,
             x_msg_data       => x_msg_data,
             p_sllv_tbl       => p_sllv_tbl,
             px_error_tbl     => px_error_tbl
           );
Line: 324

  END delete_sll;
Line: 326

  PROCEDURE delete_sll(
    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_sllv_tbl                     IN sllv_tbl_type) IS
  BEGIN
    oks_sll_pvt.delete_row
           (
             p_api_version    => p_api_version,
             p_init_msg_list  => p_init_msg_list,
             x_return_status  => x_return_status,
             x_msg_count      => x_msg_count,
             x_msg_data       => x_msg_data,
             p_sllv_tbl       => p_sllv_tbl
           );
Line: 343

  END delete_sll;
Line: 379

PROCEDURE INSERT_ROW_UPG(x_return_status OUT NOCOPY VARCHAR2,
                         p_sllv_tbl   IN sllv_tbl_type) IS

      l_tabsize NUMBER := p_sllv_tbl.COUNT;
Line: 405

      in_last_updated_by        OKC_DATATYPES.Number15TabTyp;
Line: 406

      in_last_update_date       OKC_DATATYPES.DateTabTyp;
Line: 407

      in_last_update_login      OKC_DATATYPES.Number15TabTyp;
Line: 442

      in_last_updated_by(j) := 	  p_sllv_tbl(i).last_updated_by;
Line: 443

      in_last_update_date(j) :=   p_sllv_tbl(i).last_update_date;
Line: 444

      in_last_update_login (j) := p_sllv_tbl(i).last_update_login;
Line: 449

    INSERT
    INTO OKS_STREAM_LEVELS_B(
      id,
      chr_id,
      cle_id,
      dnz_chr_id,
      sequence_no,
      uom_code,
      start_date,
      end_date,
      level_periods,
      uom_per_period,
      advance_periods,
      level_amount,
      invoice_offset_days,
      interface_offset_days,
      comments,
      due_arr_yn,
      amount,
      lines_detailed_yn,
      object_version_number,
      request_id,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login
    ) VALUES (
      in_id(i),
      in_chr_id(i),
      in_cle_id(i),
      in_dnz_chr_id(i),
      in_sequence_no(i),
      in_uom_code(i),
      in_start_date(i),
      in_end_date(i),
      in_level_periods(i),
      in_uom_per_period(i),
      in_advance_periods(i),
      in_level_amount(i),
      in_invoice_offset_days(i),
      in_interface_offset_days(i),
      in_comments(i),
      in_due_arr_yn(i),
      in_amount(i),
      in_lines_detailed_yn(i),
      in_object_version_number(i),
      in_request_id(i),
      in_created_by(i),
      in_creation_date(i),
      in_last_updated_by(i),
      in_last_update_date(i),
      in_last_update_login(i)
      );
Line: 518

END INSERT_ROW_UPG;