APPS.OKC_REP_CONTRACT_SEARCH_PVT SQL Statements

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

Line: 57

  PROCEDURE update_text_index(
  p_api_version   IN          NUMBER,
  p_init_msg_list IN          VARCHAR2,
  x_msg_data      OUT NOCOPY  VARCHAR2,
  x_msg_count     OUT NOCOPY  NUMBER,
  x_return_status OUT NOCOPY  VARCHAR2)
  IS
    l_api_version NUMBER;

Line: 69

    l_api_name    := 'update_text_index';

Line: 76

        'Entering OKC_REP_CONTRACT_SEARCH_PVT.update_text_index');

Line: 107

          'Leaving update_text_index because of EXCEPTION: ' || SQLERRM);

Line: 223

  PROCEDURE update_text_index_ctx(
    errbuf  OUT NOCOPY VARCHAR2,
    retcode OUT NOCOPY NUMBER
  )
  IS
    l_api_version   NUMBER;

Line: 241

        'Entering OKC_REP_CONTRACT_SEARCH_PVT.update_text_index_ctx');

Line: 244

    l_api_name    := 'update_text_index_ctx';

Line: 248

    update_text_index(
      p_api_version   => l_api_version,
      p_init_msg_list => l_init_msg_list,
      x_msg_data      => l_msg_data,
      x_msg_count     => l_msg_count,
      x_return_status => l_return_status
    );

Line: 264

        'Leaving OKC_REP_CONTRACT_SEARCH_PVT.update_text_index_ctx');

Line: 273

            'Leaving update_text_index_ctx because of EXCEPTION: ' || SQLERRM);