DBA Data[Home] [Help]

APPS.OKL_FUNDING_PUB SQL Statements

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

Line: 22

G_FORM_RECORD_DELETED        CONSTANT VARCHAR2(30) := OKL_API.G_FORM_RECORD_DELETED;
Line: 24

G_RECORD_LOGICALLY_DELETED	 CONSTANT VARCHAR2(30) := OKL_API.G_RECORD_LOGICALLY_DELETED;
Line: 146

PROCEDURE update_funding_header(
  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_tapv_rec                     IN tapv_rec_type
 ,x_tapv_rec                     OUT NOCOPY tapv_rec_type
)
IS
  l_api_name        CONSTANT VARCHAR2(30) := 'UPDATE_FUNDING_HEADER';
Line: 164

  SAVEPOINT UPDATE_FUNDING_HEADER_PUB;
Line: 189

    OKL_FUNDING_PVT.update_funding_header(
      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_tapv_rec      => l_tapv_rec,
      x_tapv_rec      => x_tapv_rec);
Line: 217

    ROLLBACK TO UPDATE_FUNDING_HEADER_PUB;
Line: 224

    ROLLBACK TO UPDATE_FUNDING_HEADER_PUB;
Line: 231

	ROLLBACK TO UPDATE_FUNDING_HEADER_PUB;
Line: 243

  END update_funding_header;
Line: 247

PROCEDURE delete_funding_header(
  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_tapv_rec                     IN tapv_rec_type
)
IS
  l_api_name        CONSTANT VARCHAR2(30) := 'DELETE_FUNDING_HEADER';
Line: 261

  SAVEPOINT DELETE_FUNDING_HEADER_PUB;
Line: 287

      OKL_TRX_AP_INVOICES_PUB.DELETE_TRX_AP_INVOICES(
      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_tapv_rec      => p_tapv_rec);
Line: 313

    ROLLBACK TO DELETE_FUNDING_HEADER_PUB;
Line: 320

    ROLLBACK TO DELETE_FUNDING_HEADER_PUB;
Line: 327

    ROLLBACK TO DELETE_FUNDING_HEADER_PUB;
Line: 339

END delete_funding_header;
Line: 553

PROCEDURE update_funding_lines(
  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_tplv_tbl                     IN tplv_tbl_type
 ,x_tplv_tbl                     OUT NOCOPY tplv_tbl_type
)
IS
  l_api_name        CONSTANT VARCHAR2(30) := 'UPDATE_FUNDING_LINES';
Line: 571

  SAVEPOINT UPDATE_FUNDING_LINES_PUB;
Line: 596

    OKL_FUNDING_PVT.update_funding_lines(
      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_tplv_tbl      => l_tplv_tbl,
      x_tplv_tbl      => x_tplv_tbl);
Line: 624

    ROLLBACK TO UPDATE_FUNDING_LINES_PUB;
Line: 631

    ROLLBACK TO UPDATE_FUNDING_LINES_PUB;
Line: 638

    ROLLBACK TO UPDATE_FUNDING_LINES_PUB;
Line: 650

END update_funding_lines;
Line: 653

PROCEDURE delete_funding_lines(
  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_tplv_tbl                     IN tplv_tbl_type
)
IS
  l_api_name        CONSTANT VARCHAR2(30) := 'DELETE_FUNDING_LINES';
Line: 669

      SELECT l.tap_id
        FROM OKL_TXL_AP_INV_LNS_B l
       WHERE l.id = p_line_id
    ;
Line: 676

  SAVEPOINT DELETE_FUNDING_LINES_PUB;
Line: 708

    OKL_TXL_AP_INV_LNS_PUB.DELETE_TXL_AP_INV_LNS(
      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_tplv_tbl      => p_tplv_tbl);
Line: 750

    ROLLBACK TO DELETE_FUNDING_LINES_PUB;
Line: 757

    ROLLBACK TO DELETE_FUNDING_LINES_PUB;
Line: 764

    ROLLBACK TO DELETE_FUNDING_LINES_PUB;
Line: 776

END delete_funding_lines;