eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_CONTRACT_SEQ_PVT SQL Statements

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

Line: 25


    okc_ksq_pvt.insert_row(
	    p_api_version,
	    p_init_msg_list,
	    x_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_ksqv_rec,
	    x_ksqv_rec);

Line: 52


    okc_ksq_pvt.insert_row(
	    p_api_version,
	    p_init_msg_list,
	    x_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_ksqv_tbl,
	    x_ksqv_tbl);

Line: 66


  PROCEDURE update_seq_header(
    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_ksqv_rec                     IN ksqv_rec_type,
    x_ksqv_rec                     OUT NOCOPY ksqv_rec_type) IS
  BEGIN
    IF (l_debug = 'Y') THEN
       okc_debug.set_indentation('update_seq_header');

Line: 77


       okc_debug.log('500: Entering update_seq_header', 2);

Line: 79


    okc_ksq_pvt.update_row(
	    p_api_version,
	    p_init_msg_list,
	    x_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_ksqv_rec,
	    x_ksqv_rec);

Line: 88


       okc_debug.log('600: Exiting update_seq_header', 2);

Line: 91


  END update_seq_header;

Line: 93


  PROCEDURE update_seq_header(
    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_ksqv_tbl                     IN ksqv_tbl_type,
    x_ksqv_tbl                     OUT NOCOPY ksqv_tbl_type) IS
  BEGIN
    IF (l_debug = 'Y') THEN
       okc_debug.set_indentation('update_seq_header');

Line: 104


       okc_debug.log('700: Entering update_seq_header', 2);

Line: 106


    okc_ksq_pvt.update_row(
	    p_api_version,
	    p_init_msg_list,
	    x_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_ksqv_tbl,
	    x_ksqv_tbl);

Line: 115


       okc_debug.log('800: Exiting update_seq_header', 2);

Line: 118


  END update_seq_header;

Line: 120


  PROCEDURE delete_seq_header(
    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_ksqv_rec                     IN ksqv_rec_type) IS
  BEGIN
    IF (l_debug = 'Y') THEN
       okc_debug.set_indentation('delete_seq_header');

Line: 130


       okc_debug.log('900: Entering delete_seq_header', 2);

Line: 132


    okc_ksq_pvt.delete_row(
	    p_api_version,
	    p_init_msg_list,
	    x_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_ksqv_rec);

Line: 140


       okc_debug.log('1000: Exiting delete_seq_header', 2);

Line: 143


  END delete_seq_header;

Line: 145


  PROCEDURE delete_seq_header(
    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_ksqv_tbl                     IN ksqv_tbl_type) IS
  BEGIN
    IF (l_debug = 'Y') THEN
       okc_debug.set_indentation('delete_seq_header');

Line: 155


       okc_debug.log('1100: Entering delete_seq_header', 2);

Line: 157


    okc_ksq_pvt.delete_row(
	    p_api_version,
	    p_init_msg_list,
	    x_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_ksqv_tbl);

Line: 165


       okc_debug.log('1200: Exiting delete_seq_header', 2);

Line: 168


  END delete_seq_header;

Line: 294


    select doc_sequence_id
      from okc_k_seq_lines
     where line_code = p_line_code
       and ((contract_number_prefix = p_prefix)
        or  (contract_number_prefix is null
       and   p_prefix is null))
       and ((contract_number_suffix = p_suffix)
        or  (contract_number_suffix is null
       and   p_suffix is null));

Line: 307


    select doc_sequence_id
      from fnd_document_sequences
     where name = l_docseq_name;

Line: 314


    select set_of_books_id
      from okx_organization_defs_v
     where id1= p_id
       and organization_type = 'OPERATING_UNIT'
       and information_type = 'Operating Unit Information';

Line: 324


    SELECT ou.organization_id
    FROM hr_operating_units ou
    WHERE mo_global.check_access(ou.organization_id) = 'Y';

Line: 349


      select okc_k_seq_lines_s1.nextval into l_seq from dual;

Line: 373


    okc_lsq_pvt.insert_row(
	    p_api_version,
	    p_init_msg_list,
	    l_return_status,
	    x_msg_count,
	    x_msg_data,
	    l_lsqv_rec,
	    x_lsqv_rec);

Line: 393


      Fnd_Seq_Categories_Pkg.Insert_Cat(
            x_application_id    => 510,
            x_category_code     => l_docseq_name,
            x_category_name     => l_docseq_name,
            x_description       => l_docseq_name,
            x_table_name        => 'OKC_K_HEADERS_B',
            x_last_updated_by   => x_lsqv_rec.last_updated_by,
            x_created_by        => x_lsqv_rec.created_by,
            x_last_update_login => x_lsqv_rec.last_update_login);

Line: 547


  PROCEDURE update_seq_lines(
    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_lsqv_rec                     IN lsqv_rec_type,
    x_lsqv_rec                     OUT NOCOPY lsqv_rec_type) IS
  BEGIN
    IF (l_debug = 'Y') THEN
       okc_debug.set_indentation('update_seq_lines');

Line: 558


       okc_debug.log('2900: Entering update_seq_lines', 2);

Line: 560


    okc_lsq_pvt.update_row(
	    p_api_version,
	    p_init_msg_list,
	    x_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_lsqv_rec,
	    x_lsqv_rec);

Line: 569


       okc_debug.log('3000: Exiting update_seq_lines', 2);

Line: 572


  END update_seq_lines;

Line: 574


  PROCEDURE update_seq_lines(
    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_lsqv_tbl                     IN lsqv_tbl_type,
    x_lsqv_tbl                     OUT NOCOPY lsqv_tbl_type) IS
  BEGIN
    IF (l_debug = 'Y') THEN
       okc_debug.set_indentation('update_seq_lines');

Line: 585


       okc_debug.log('3100: Entering update_seq_lines', 2);

Line: 587


    okc_lsq_pvt.update_row(
	    p_api_version,
	    p_init_msg_list,
	    x_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_lsqv_tbl,
	    x_lsqv_tbl);

Line: 596


       okc_debug.log('3200: Exiting update_seq_lines', 2);

Line: 599


  END update_seq_lines;

Line: 601


  PROCEDURE delete_seq_lines(
    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_lsqv_rec                     IN lsqv_rec_type) IS
  BEGIN
    IF (l_debug = 'Y') THEN
       okc_debug.set_indentation('delete_seq_lines');

Line: 611


       okc_debug.log('3300: Entering delete_seq_lines', 2);

Line: 613


    okc_lsq_pvt.delete_row(
	    p_api_version,
	    p_init_msg_list,
	    x_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_lsqv_rec);

Line: 621


       okc_debug.log('3400: Exiting delete_seq_lines', 2);

Line: 624


  END delete_seq_lines;

Line: 626


  PROCEDURE delete_seq_lines(
    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_lsqv_tbl                     IN lsqv_tbl_type) IS
  BEGIN
    IF (l_debug = 'Y') THEN
       okc_debug.set_indentation('delete_seq_lines');

Line: 636


       okc_debug.log('3500: Entering delete_seq_lines', 2);

Line: 638


    okc_lsq_pvt.delete_row(
	    p_api_version,
	    p_init_msg_list,
	    x_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_lsqv_tbl);

Line: 646


       okc_debug.log('3600: Exiting delete_seq_lines', 2);

Line: 649


  END delete_seq_lines;