APPS.OKC_VERSION_PVT SQL Statements

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

Line: 34

    select major_version
      from okc_k_vers_numbers
     where chr_id = p_chr_id;

Line: 39

    select id
      from okc_k_lines_b
     where dnz_chr_id = p_chr_id;

Line: 44

    select object_version_number
      from okc_k_vers_numbers_h
     where chr_id = p_chr_id
       and major_version = l_minus_version;

Line: 89

       fnd_attached_documents2_pkg.delete_attachments(
						x_entity_name => 'OKC_K_HEADERS_B',
						x_pk1_value   => p_chr_id,
                              x_pk2_value   => l_minus_version,
                              x_delete_document_flag => 'Y'); --

Line: 105

         fnd_attached_documents2_pkg.delete_attachments(
							x_entity_name => 'OKC_K_LINES_B',
							x_pk1_value   => c_lines_rec.id,
                                   x_pk2_value   => l_minus_version,
                                   x_delete_document_flag => 'Y');

Line: 174

       fnd_attached_documents2_pkg.delete_attachments(
						x_entity_name => 'OKC_K_HEADERS_B',
						x_pk1_value   => p_chr_id,
                                                x_pk2_value   => l_ver_num,
                                                x_delete_document_flag => 'Y');

Line: 209

         fnd_attached_documents2_pkg.delete_attachments(
							x_entity_name => 'OKC_K_LINES_B',
							x_pk1_value   => c_lines_rec.id,
                                   x_pk2_value   => l_ver_num,
                                   x_delete_document_flag => 'Y');

Line: 249

       fnd_attached_documents2_pkg.delete_attachments(
						x_entity_name => 'OKC_K_HEADERS_B',
						x_pk1_value   => p_chr_id,
                              x_pk2_value   => l_minus_version,
                              x_delete_document_flag => 'Y'); --

Line: 265

         fnd_attached_documents2_pkg.delete_attachments(
							x_entity_name => 'OKC_K_LINES_B',
							x_pk1_value   => c_lines_rec.id,
                                   x_pk2_value   => l_minus_version,
                                   x_delete_document_flag => 'Y');

Line: 318

   SELECT
   decode(pdf.pdf_type,'PPS',
          pdf.package_name||'.'||pdf.procedure_name,NULL) proc_name
   FROM okc_process_defs_v pdf
   WHERE pdf.id = l_pdf_id;

Line: 367

       SELECT cls_code
       FROM okc_k_headers_b, okc_subclasses_b
       WHERE id = p_chr_id and code = scs_code;

Line: 373

    SELECT pdf_id
    FROM okc_class_operations
    WHERE opn_code = 'VERSIONING'
    AND   cls_code = p_cls_code;

Line: 789

select '!' from okc_k_vers_numbers
where chr_id = p_chr_id
for update of MAJOR_VERSION, MINOR_VERSION
nowait;

Line: 795

select b.cls_code
from okc_k_headers_b a,okc_subclasses_b b
where a.scs_code=b.code and a.id = p_chr_id;

Line: 1144

    insert into okc_k_vers_numbers_h
    (
	CHR_ID
	,MAJOR_VERSION
	,MINOR_VERSION
	,OBJECT_VERSION_NUMBER
	,CREATED_BY
	,CREATION_DATE
	,LAST_UPDATED_BY
	,LAST_UPDATE_DATE
	,LAST_UPDATE_LOGIN
    ) select
	CHR_ID
	,-1 -- otherwise UK violation
	,MINOR_VERSION
	,MAJOR_VERSION -- comes here instead of OBJECT_VERSION_NUMBER
	,CREATED_BY
	,CREATION_DATE
	,FND_GLOBAL.USER_ID
	,sysdate
	,FND_GLOBAL.LOGIN_ID
    from okc_k_vers_numbers
    where chr_id = p_chr_id;

Line: 1213

Procedure delete_version (p_chr_id 	  IN NUMBER,
					 p_major_version IN NUMBER,
					 p_minor_version IN NUMBER,
					 p_called_from   IN VARCHAR2) IS

l_major_version number := p_major_version;

Line: 1227

   DELETE FROM OKC_K_HEADERS_TLH
     WHERE id = p_chr_id
	  AND (MAJOR_VERSION = -2
	  AND p_called_from = 'ERASE_SAVED_VERSION');

Line: 1232

    DELETE FROM OKC_K_HEADERS_BH
     WHERE id= p_chr_id
	  AND (MAJOR_VERSION = -2
	  AND p_called_from = 'ERASE_SAVED_VERSION');

Line: 1240

    delete FROM OKC_CONDITION_HEADERS_TLH
     WHERE id in (select id from OKC_CONDITION_HEADERS_BH
	 		WHERE dnz_chr_id= p_chr_id)
	  and ((MAJOR_VERSION = -1
	  and p_called_from = 'ERASE_SAVED_VERSION')
        or (p_called_from = 'RESTORE_VERSION'
	  and (major_version > l_major_version
	   or major_version = -1)));

Line: 1249

    delete FROM OKC_CONDITION_HEADERS_BH
     WHERE dnz_chr_id= p_chr_id
	  and ((MAJOR_VERSION = -1
	  and p_called_from = 'ERASE_SAVED_VERSION')
        or (p_called_from = 'RESTORE_VERSION'
	  and (major_version > l_major_version
	   or major_version = -1)));

Line: 1257

    delete FROM OKC_CONDITION_LINES_TLH
     WHERE id in (select id from OKC_CONDITION_LINES_BH
	 		WHERE dnz_chr_id= p_chr_id)
	  and ((MAJOR_VERSION = -1
	  and p_called_from = 'ERASE_SAVED_VERSION')
        or (p_called_from = 'RESTORE_VERSION'
	  and (major_version > l_major_version
	   or major_version = -1)));

Line: 1266

    delete FROM OKC_CONDITION_LINES_BH
     WHERE dnz_chr_id= p_chr_id
	  and ((MAJOR_VERSION = -1
	  and p_called_from = 'ERASE_SAVED_VERSION')
        or (p_called_from = 'RESTORE_VERSION'
	  and (major_version > l_major_version
	   or major_version = -1)));

Line: 1274

    delete FROM OKC_CONTACTS_H
     WHERE dnz_chr_id= p_chr_id
	  and ((MAJOR_VERSION = -1
	  and p_called_from = 'ERASE_SAVED_VERSION')
        or (p_called_from = 'RESTORE_VERSION'
	  and (major_version > l_major_version
	   or major_version = -1)));

Line: 1282

    delete FROM OKC_COVER_TIMES_H
     WHERE dnz_chr_id= p_chr_id
	  and ((MAJOR_VERSION = -1
	  and p_called_from = 'ERASE_SAVED_VERSION')
        or (p_called_from = 'RESTORE_VERSION'
	  and (major_version > l_major_version
	   or major_version = -1)));

Line: 1290

    delete FROM OKC_FUNCTION_EXPR_PARAMS_H
     WHERE dnz_chr_id= p_chr_id
	  and ((MAJOR_VERSION = -1
	  and p_called_from = 'ERASE_SAVED_VERSION')
        or (p_called_from = 'RESTORE_VERSION'
	  and (major_version > l_major_version
	   or major_version = -1)));

Line: 1298

    delete FROM OKC_GOVERNANCES_H
     WHERE dnz_chr_id= p_chr_id
	  and ((MAJOR_VERSION = -1
	  and p_called_from = 'ERASE_SAVED_VERSION')
        or (p_called_from = 'RESTORE_VERSION'
	  and (major_version > l_major_version
	   or major_version = -1)));

Line: 1306

    delete FROM OKC_K_ACCESSES_H
     WHERE chr_id= p_chr_id
	  and ((MAJOR_VERSION = -1
	  and p_called_from = 'ERASE_SAVED_VERSION')
        or (p_called_from = 'RESTORE_VERSION'
	  and (major_version > l_major_version
	   or major_version = -1)));

Line: 1314

    delete FROM OKC_K_HEADERS_TLH
     WHERE id = p_chr_id
	  and ((MAJOR_VERSION = -1
	  and p_called_from = 'ERASE_SAVED_VERSION')
        or (p_called_from = 'RESTORE_VERSION'
	  and (major_version > l_major_version
	   or major_version = -1)));

Line: 1322

    delete FROM OKC_K_HEADERS_BH
     WHERE id= p_chr_id
	  and ((MAJOR_VERSION = -1
	  and p_called_from = 'ERASE_SAVED_VERSION')
        or (p_called_from = 'RESTORE_VERSION'
	  and (major_version > l_major_version
	   or major_version = -1)));

Line: 1330

    delete FROM OKS_K_HEADERS_BH
     WHERE chr_id= p_chr_id
	  and ((MAJOR_VERSION = -1
	  and p_called_from = 'ERASE_SAVED_VERSION')
        or (p_called_from = 'RESTORE_VERSION'
	  and (major_version > l_major_version
	   or major_version = -1)));

Line: 1338

    delete FROM OKC_K_ITEMS_H
     WHERE dnz_chr_id= p_chr_id
	  and ((MAJOR_VERSION = -1
	  and p_called_from = 'ERASE_SAVED_VERSION')
        or (p_called_from = 'RESTORE_VERSION'
	  and (major_version > l_major_version
	   or major_version = -1)));

Line: 1346

    delete FROM OKC_K_LINES_TLH
     WHERE id in (select id from OKC_K_LINES_BH
	 		WHERE dnz_chr_id= p_chr_id)
	  and ((MAJOR_VERSION = -1
	  and p_called_from = 'ERASE_SAVED_VERSION')
        or (p_called_from = 'RESTORE_VERSION'
	  and (major_version > l_major_version
	   or major_version = -1)));

Line: 1355

    delete FROM OKC_K_LINES_BH
     WHERE dnz_chr_id= p_chr_id
	  and ((MAJOR_VERSION = -1
	  and p_called_from = 'ERASE_SAVED_VERSION')
        or (p_called_from = 'RESTORE_VERSION'
	  and (major_version > l_major_version
	   or major_version = -1)));

Line: 1363

 delete FROM OKS_K_LINES_TLH
     WHERE id in (select id from OKS_K_LINES_BH
	 		WHERE dnz_chr_id= p_chr_id)
	  and ((MAJOR_VERSION = -1
	  and p_called_from = 'ERASE_SAVED_VERSION')
        or (p_called_from = 'RESTORE_VERSION'
	  and (major_version > l_major_version
	   or major_version = -1)));

Line: 1372

    delete FROM OKS_K_LINES_BH
     WHERE dnz_chr_id= p_chr_id
	  and ((MAJOR_VERSION = -1
	  and p_called_from = 'ERASE_SAVED_VERSION')
        or (p_called_from = 'RESTORE_VERSION'
	  and (major_version > l_major_version
	   or major_version = -1)));

Line: 1380

    delete FROM OKC_K_PARTY_ROLES_TLH
     WHERE id in (select id from OKC_K_PARTY_ROLES_BH
	 		WHERE dnz_chr_id= p_chr_id)
	  and ((MAJOR_VERSION = -1
	  and p_called_from = 'ERASE_SAVED_VERSION')
        or (p_called_from = 'RESTORE_VERSION'
	  and (major_version > l_major_version
	   or major_version = -1)));

Line: 1389

    delete FROM OKC_K_PARTY_ROLES_BH
     WHERE dnz_chr_id= p_chr_id
	  and ((MAJOR_VERSION = -1
	  and p_called_from = 'ERASE_SAVED_VERSION')
        or (p_called_from = 'RESTORE_VERSION'
	  and (major_version > l_major_version
	   or major_version = -1)));

Line: 1397

    delete FROM OKC_K_PROCESSES_H
     WHERE chr_id= p_chr_id
	  and ((MAJOR_VERSION = -1
	  and p_called_from = 'ERASE_SAVED_VERSION')
        or (p_called_from = 'RESTORE_VERSION'
	  and (major_version > l_major_version
	   or major_version = -1)));

Line: 1405

    delete FROM OKC_OUTCOME_ARGUMENTS_H
     WHERE dnz_chr_id= p_chr_id
	  and ((MAJOR_VERSION = -1
	  and p_called_from = 'ERASE_SAVED_VERSION')
        or (p_called_from = 'RESTORE_VERSION'
	  and (major_version > l_major_version
	   or major_version = -1)));

Line: 1413

    delete FROM OKC_OUTCOMES_TLH
     WHERE id in (select id from OKC_OUTCOMES_BH
	 		WHERE dnz_chr_id= p_chr_id)
	  and ((MAJOR_VERSION = -1
	  and p_called_from = 'ERASE_SAVED_VERSION')
        or (p_called_from = 'RESTORE_VERSION'
	  and (major_version > l_major_version
	   or major_version = -1)));

Line: 1422

    delete FROM OKC_OUTCOMES_BH
     WHERE dnz_chr_id= p_chr_id
	  and ((MAJOR_VERSION = -1
	  and p_called_from = 'ERASE_SAVED_VERSION')
        or (p_called_from = 'RESTORE_VERSION'
	  and (major_version > l_major_version
	   or major_version = -1)));

Line: 1430

    delete FROM OKC_REACT_INTERVALS_H
     WHERE dnz_chr_id= p_chr_id
	  and ((MAJOR_VERSION = -1
	  and p_called_from = 'ERASE_SAVED_VERSION')
        or (p_called_from = 'RESTORE_VERSION'
	  and (major_version > l_major_version
	   or major_version = -1)));

Line: 1438

    delete FROM OKC_RG_PARTY_ROLES_H
     WHERE dnz_chr_id= p_chr_id
	  and ((MAJOR_VERSION = -1
	  and p_called_from = 'ERASE_SAVED_VERSION')
        or (p_called_from = 'RESTORE_VERSION'
	  and (major_version > l_major_version
	   or major_version = -1)));

Line: 1446

    delete FROM OKC_RULE_GROUPS_TLH
     WHERE id in (select id from OKC_RULE_GROUPS_BH
	 		WHERE dnz_chr_id= p_chr_id)
	  and ((MAJOR_VERSION = -1
	  and p_called_from = 'ERASE_SAVED_VERSION')
        or (p_called_from = 'RESTORE_VERSION'
	  and (major_version > l_major_version
	   or major_version = -1)));

Line: 1455

    delete FROM OKC_RULE_GROUPS_BH
     WHERE dnz_chr_id= p_chr_id
	  and ((MAJOR_VERSION = -1
	  and p_called_from = 'ERASE_SAVED_VERSION')
        or (p_called_from = 'RESTORE_VERSION'
	  and (major_version > l_major_version
	   or major_version = -1)));

Line: 1465

    delete FROM OKC_RULES_TLH
     WHERE id in (select id from OKC_RULES_BH
	 		WHERE dnz_chr_id= p_chr_id)
	  and ((MAJOR_VERSION = -1
	  and p_called_from = 'ERASE_SAVED_VERSION')
        or (p_called_from = 'RESTORE_VERSION'
	  and (major_version > l_major_version
	   or major_version = -1)));

Line: 1475

    delete FROM OKC_RULES_BH
     WHERE dnz_chr_id= p_chr_id
	  and ((MAJOR_VERSION = -1
	  and p_called_from = 'ERASE_SAVED_VERSION')
        or (p_called_from = 'RESTORE_VERSION'
	  and (major_version > l_major_version
	   or major_version = -1)));

Line: 1486

    delete FROM OKC_TIMEVALUES_TLH
     WHERE id in (select id from OKC_TIMEVALUES_BH
	 		WHERE dnz_chr_id= p_chr_id)
	  and ((MAJOR_VERSION = -1
	  and p_called_from = 'ERASE_SAVED_VERSION')
        or (p_called_from = 'RESTORE_VERSION'
	  and (major_version > l_major_version
	   or major_version = -1)));

Line: 1497

    delete FROM OKC_TIMEVALUES_H
     WHERE dnz_chr_id= p_chr_id
	  and ((MAJOR_VERSION = -1
	  and p_called_from = 'ERASE_SAVED_VERSION')
        or (p_called_from = 'RESTORE_VERSION'
	  and (major_version > l_major_version
	   or major_version = -1)));

Line: 1506

     delete FROM OKC_PRICE_ADJUSTMENTS_H
     WHERE chr_id= p_chr_id
          and ((MAJOR_VERSION = -1
          and p_called_from = 'ERASE_SAVED_VERSION')
        or (p_called_from = 'RESTORE_VERSION'
          and (major_version > l_major_version
           or major_version = -1)));

Line: 1515

    delete FROM OKC_PRICE_ADJ_ASSOCS_H
     WHERE pat_id  IN
        ( SELECT pat_id
          FROM OKC_PRICE_ADJUSTMENTS
          WHERE chr_id = p_chr_id
             )
          and ((MAJOR_VERSION = -1
          and p_called_from = 'ERASE_SAVED_VERSION')
        or (p_called_from = 'RESTORE_VERSION'
          and (major_version > l_major_version
           or major_version = -1)));

Line: 1527

    delete FROM OKC_PRICE_ADJ_ATTRIBS_H
     WHERE pat_id  IN
        ( SELECT pat_id
          FROM OKC_PRICE_ADJUSTMENTS
          WHERE chr_id = p_chr_id
             )
          and ((MAJOR_VERSION = -1
          and p_called_from = 'ERASE_SAVED_VERSION')
        or (p_called_from = 'RESTORE_VERSION'
          and (major_version > l_major_version
           or major_version = -1)));

Line: 1542

    delete FROM OKC_PRICE_ATT_VALUES_H
     WHERE (chr_id= p_chr_id )
          and ((MAJOR_VERSION = -1
          and p_called_from = 'ERASE_SAVED_VERSION')
        or (p_called_from = 'RESTORE_VERSION'
          and (major_version >= l_major_version
           or major_version = -1)));

Line: 1550

    delete FROM OKC_PRICE_ATT_VALUES_H
     WHERE (CLE_ID IN (SELECT ID FROM OKC_K_LINES_B WHERE DNZ_CHR_ID=p_chr_id ) )
          and ((MAJOR_VERSION = -1
          and p_called_from = 'ERASE_SAVED_VERSION')
        or (p_called_from = 'RESTORE_VERSION'
          and (major_version >= l_major_version
           or major_version = -1)));

Line: 1560

    delete FROM OKC_PH_LINE_BREAKS_H       --price hold
     WHERE cle_id IN
         (SELECT id
          FROM okc_k_lines_b
          WHERE dnz_chr_id = p_chr_id        --price hold sub-line
             )
         and ((MAJOR_VERSION = -1
          and p_called_from = 'ERASE_SAVED_VERSION')
        or (p_called_from = 'RESTORE_VERSION'
          and (major_version > l_major_version
           or major_version = -1)));

Line: 1593

            OKC_TERMS_VERSION_GRP.delete_doc_version(
                      p_api_version   => 1,
                      x_return_status => l_return_status,
                      x_msg_data      => l_msg_data,
                      x_msg_count     => l_msg_count,
                      p_doc_type      => l_doc_type,
                      p_doc_id        => l_doc_id,
                      p_version_number =>-1);

Line: 1612

          FOR CR in (Select major_version from okc_k_headers_hv where id=p_chr_id and (major_version > p_major_version or major_version=-1)) LOOP

            OKC_TERMS_VERSION_GRP.delete_doc_version(
                      p_api_version   => 1,
                      x_return_status => l_return_status,
                      x_msg_data      => l_msg_data,
                      x_msg_count     => l_msg_count,
                      p_doc_type      => l_doc_type,
                      p_doc_id        => l_doc_id,
                      p_version_number=> cr.major_version);

Line: 1632

    delete FROM okc_k_vers_numbers_h
     WHERE chr_id= p_chr_id
	  and ((MAJOR_VERSION = -1
	  and p_called_from = 'ERASE_SAVED_VERSION')
        or (p_called_from = 'RESTORE_VERSION'
	  and (major_version > l_major_version
	  or  ((major_version = l_major_version
	  and minor_version >= l_minor_version))
	   or major_version = -1)));

Line: 1644

end delete_version;

Line: 1668

       SELECT cls_code
       FROM okc_k_headers_b, okc_subclasses_b
       WHERE id = p_chr_id and code = scs_code;

Line: 1674

    SELECT pdf_id
    FROM okc_class_operations
    WHERE opn_code = 'ERASE_VERSION'
    AND   cls_code = p_cls_code;

Line: 1694

   delete_version(p_chr_id =>p_chr_id,
			   p_major_version => -1,
			   p_minor_version => null,
			   p_called_from => 'ERASE_SAVED_VERSION');

Line: 1789

	select object_version_number, minor_version
	from okc_k_vers_numbers_h
     	WHERE chr_id= p_chr_id
	and MAJOR_VERSION = -1;

Line: 1795

select '!' from okc_k_vers_numbers
where chr_id = p_chr_id
for update of MAJOR_VERSION, MINOR_VERSION
nowait;

Line: 1801

		SELECT sts_code
		FROM okc_k_headers_b
		WHERE ID = p_chr_id;

Line: 1806

    	SELECT to_char (major_version)||'.'||to_char(minor_version)
    	FROM okc_k_vers_numbers
    	WHERE chr_id=p_chr_id;

Line: 1868

     delete from OKC_CONDITION_HEADERS_TL
	WHERE id in (select id from OKC_CONDITION_HEADERS_B
	 		WHERE dnz_chr_id= p_chr_id);

Line: 1872

     delete from OKC_CONDITION_HEADERS_B where DNZ_CHR_ID = p_chr_id;

Line: 1874

     delete from OKC_CONDITION_LINES_TL
	WHERE id in (select id from OKC_CONDITION_LINES_B
	 		WHERE dnz_chr_id= p_chr_id);

Line: 1878

     delete from OKC_CONDITION_LINES_B where DNZ_CHR_ID = p_chr_id;

Line: 1880

     delete from OKC_CONTACTS where DNZ_CHR_ID = p_chr_id;

Line: 1882

     delete from OKC_COVER_TIMES where DNZ_CHR_ID = p_chr_id;

Line: 1884

     delete from OKC_FUNCTION_EXPR_PARAMS where DNZ_CHR_ID = p_chr_id;

Line: 1886

     delete from OKC_GOVERNANCES where DNZ_CHR_ID = p_chr_id;

Line: 1888

     delete from OKC_K_ACCESSES where CHR_ID = p_chr_id;

Line: 1890

     delete from OKC_K_HEADERS_TL
     WHERE id = p_chr_id;

Line: 1893

     delete from OKC_K_HEADERS_B where ID = p_chr_id;

Line: 1895

     delete from OKC_K_ITEMS where DNZ_CHR_ID = p_chr_id;

Line: 1897

      delete from OKC_PRICE_ATT_VALUES  WHERE chr_id = p_chr_id or cle_id in (select id from okc_k_lines_b where dnz_chr_id=p_chr_id);

Line: 1900

      delete from OKC_PH_LINE_BREAKS  WHERE cle_id IN
                                    (SELECT id
                                     FROM okc_k_lines_b
                                     WHERE dnz_chr_id = p_chr_id);

Line: 1907

     delete from OKC_K_LINES_TL
     WHERE id in (select id from OKC_K_LINES_B
	 		WHERE dnz_chr_id= p_chr_id);

Line: 1911

     delete from OKC_K_LINES_B where DNZ_CHR_ID = p_chr_id;

Line: 1913

     delete from OKC_K_PARTY_ROLES_TL
     WHERE id in (select id from OKC_K_PARTY_ROLES_B
	 		WHERE dnz_chr_id= p_chr_id);

Line: 1917

     delete from OKC_K_PARTY_ROLES_B where DNZ_CHR_ID = p_chr_id;

Line: 1919

     delete from OKC_K_PROCESSES where CHR_ID = p_chr_id;

Line: 1921

     delete from OKC_OUTCOME_ARGUMENTS where DNZ_CHR_ID = p_chr_id;

Line: 1923

     delete from OKC_OUTCOMES_TL
     WHERE id in (select id from OKC_OUTCOMES_B
	 		WHERE dnz_chr_id= p_chr_id);

Line: 1927

     delete from OKC_OUTCOMES_B where DNZ_CHR_ID = p_chr_id;

Line: 1929

     delete from OKC_REACT_INTERVALS where DNZ_CHR_ID = p_chr_id;

Line: 1931

     delete from OKC_RG_PARTY_ROLES where DNZ_CHR_ID = p_chr_id;

Line: 1933

     delete from OKC_RULE_GROUPS_TL
     WHERE id in (select id from OKC_RULE_GROUPS_B
	 		WHERE dnz_chr_id= p_chr_id);

Line: 1937

     delete from OKC_RULE_GROUPS_B where DNZ_CHR_ID = p_chr_id;

Line: 1940

     delete from OKC_RULES_TL
     WHERE id in (select id from OKC_RULES_B
	 		WHERE dnz_chr_id= p_chr_id);

Line: 1944

     delete from OKC_RULES_B where DNZ_CHR_ID = p_chr_id;

Line: 1948

     delete from OKC_TIMEVALUES_TL
     WHERE id in (select id from OKC_TIMEVALUES_B
	 		WHERE dnz_chr_id= p_chr_id);

Line: 1953

     delete from OKC_TIMEVALUES where DNZ_CHR_ID = p_chr_id;

Line: 1955

     delete from OKC_PRICE_ADJUSTMENTS
         WHERE chr_id = p_chr_id;

Line: 1958

     delete from OKC_PRICE_ADJ_ASSOCS
         WHERE pat_id_from in ( select pat_id
                           from OKC_PRICE_ADJUSTMENTS
                           where chr_id = p_chr_id);

Line: 1963

     delete from OKC_PRICE_ADJ_ATTRIBS
         WHERE pat_id in ( select pat_id
                           from OKC_PRICE_ADJUSTMENTS
                           where chr_id = p_chr_id);

Line: 1973

      delete from OKC_K_SALES_CREDITS  WHERE dnz_chr_id = p_chr_id;

Line: 2254

     delete from okc_k_vers_numbers where CHR_ID = p_chr_id;

Line: 2255

     INSERT INTO okc_k_vers_numbers(
	CHR_ID
	,MAJOR_VERSION
	,MINOR_VERSION
	,OBJECT_VERSION_NUMBER
	,CREATED_BY
	,CREATION_DATE
	,LAST_UPDATED_BY
	,LAST_UPDATE_DATE
	,LAST_UPDATE_LOGIN
	) select
	CHR_ID
	,OBJECT_VERSION_NUMBER
	,MINOR_VERSION
	,0
	,CREATED_BY
	,CREATION_DATE
	,FND_GLOBAL.USER_ID
	,sysdate
	,FND_GLOBAL.LOGIN_ID
	from okc_k_vers_numbers_h
	where chr_id = p_chr_id
	and MAJOR_VERSION = -1;

Line: 2279

  delete_version( p_chr_id 	    => p_chr_id,
			   p_called_from   => 'RESTORE_VERSION',
			   p_major_version => l_major_version,
			   p_minor_version => l_minor_version);

Line: 2369

	      SELECT application_id
	      FROM okc_k_headers_b
	      WHERE id = p_chr_id;