APPS.PO_CLM_OKC_INTEG_PKG SQL Statements

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

Line: 32

PROCEDURE insert_exhibits
(
  p_document_type_tbl IN PO_TBL_VARCHAR30,
  p_document_id_tbl   IN PO_TBL_NUMBER,
  p_exhibit_name_tbl  IN PO_TBL_VARCHAR30,
  p_exhibit_description_tbl IN PO_TBL_VARCHAR240,
  p_is_cdrl_tbl       IN PO_TBL_VARCHAR1,
  p_revision_num_tbl  IN PO_TBL_NUMBER,
  x_return_status OUT NOCOPY VARCHAR2,
  x_return_msg   OUT NOCOPY VARCHAR2
) IS

l_return_status       VARCHAR2(30);

Line: 47

d_module CONSTANT VARCHAR2(200) := d_pkg_name || '.' || 'insert_exhibits';

Line: 57

  PO_EXHIBITS_PVT.insert_exhibits
                                (
                                  p_document_type_tbl => p_document_type_tbl,
                                  p_document_id_tbl   => p_document_id_tbl,
                                  p_exhibit_name_tbl  => p_exhibit_name_tbl,
                                  p_exhibit_description_tbl => p_exhibit_description_tbl,
                                  p_is_cdrl_tbl       => p_is_cdrl_tbl,
				  p_revision_num_tbl  => p_revision_num_tbl,
                                  x_return_status     => l_return_status,
                                  x_return_msg        => l_return_msg
                                );

Line: 82

END insert_exhibits;

Line: 108

PROCEDURE delete_exhibits
(
  p_document_type_tbl IN PO_TBL_VARCHAR30,
  p_document_id_tbl   IN PO_TBL_NUMBER,
  p_exhibit_name_tbl  IN PO_TBL_VARCHAR30,
  p_is_cdrl_tbl       IN PO_TBL_VARCHAR1,
  x_return_status OUT NOCOPY VARCHAR2,
  x_return_msg   OUT NOCOPY VARCHAR2
) IS

l_return_status       VARCHAR2(30);

Line: 121

d_module CONSTANT VARCHAR2(200) := d_pkg_name || '.' || 'delete_exhibits';

Line: 131

  PO_EXHIBITS_PVT.delete_exhibits
                                (
                                  p_document_type_tbl => p_document_type_tbl,
                                  p_document_id_tbl   => p_document_id_tbl,
                                  p_exhibit_name_tbl  => p_exhibit_name_tbl,
                                  p_is_cdrl_tbl       => p_is_cdrl_tbl,
                                  x_return_status     => l_return_status,
                                  x_return_msg        => l_return_msg
                                );

Line: 154

END delete_exhibits;