APPS.OKE_VERSION_PVT SQL Statements

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

Line: 53

               'K_LINE_ID IN ( SELECT ID FROM OKC_K_LINES_B WHERE DNZ_CHR_ID = :id)' );

Line: 62

               'STANDARD_NOTES_ID IN ( SELECT STANDARD_NOTES_ID ' ||
               'FROM OKE_K_STANDARD_NOTES_B WHERE K_HEADER_ID = :id)' );

Line: 78

               'ID IN ( SELECT ID FROM OKC_K_LINES_B WHERE DNZ_CHR_ID = :id )');

Line: 91

               'ID IN ( SELECT ID FROM OKC_SECTIONS_B WHERE CHR_ID = :id )');

Line: 93

               'SCN_ID IN ( SELECT ID FROM OKC_SECTIONS_B WHERE CHR_ID = :id )');

Line: 96

               'ID IN ( SELECT ID FROM OKC_CONDITION_HEADERS_B WHERE DNZ_CHR_ID = :id )');

Line: 99

               'ID IN ( SELECT ID FROM OKC_CONDITION_LINES_B WHERE DNZ_CHR_ID = :id )');

Line: 102

               'ID IN ( SELECT ID FROM OKC_ITEM_PARTYS_B WHERE DNZ_CHR_ID = :id )');

Line: 105

               'ID IN ( SELECT ID FROM OKC_K_ARTICLES_B WHERE DNZ_CHR_ID = :id )');

Line: 108

               'ID IN ( SELECT ID FROM OKC_K_PARTY_ROLES_B WHERE DNZ_CHR_ID = :id )');

Line: 111

               'ID IN ( SELECT ID FROM OKC_OUTCOMES_B WHERE DNZ_CHR_ID = :id )');

Line: 118

               'K_LINE_ID IN ( SELECT ID FROM OKC_K_LINES_B WHERE DNZ_CHR_ID = :id)' );

Line: 127

               'STANDARD_NOTES_ID IN ( SELECT STANDARD_NOTES_ID ' ||
               'FROM OKE_K_STANDARD_NOTES_B WHERE K_HEADER_ID = :id)' );

Line: 151

    select   column_name, column_id
    from     all_tab_columns tc
    where     (tc.owner,tc.table_name) in  (
      select   us.table_owner,us.synonym_name
      from     user_synonyms      us
      where    us.synonym_name = p_table_name)
    and     tc.column_name  <> 'MAJOR_VERSION'
    and     tc.data_type not in ('LONG', 'LONG RAW')
    and     exists (
      select     1
      from       user_synonyms      us2,
                 all_tab_columns  tc2
      where      us2.synonym_name = p_hist_table_name
      and        tc2.table_name  = us2.synonym_name
      and        tc2.owner        = us2.table_owner
      and        tc2.column_name  = tc.column_name
      )
    order by column_id;

Line: 171

    select distinct column_name, column_id
    from   all_tab_columns tc
    ,      user_synonyms   us
    where  us.synonym_name = p_table_name
    and    tc.table_name   = us.synonym_name
    and    tc.owner        = us.table_owner
    and    tc.column_name  <> 'MAJOR_VERSION'
    and    tc.data_type not in ('LONG', 'LONG RAW')
    and exists (
      select null
      from   all_tab_columns tc2
      ,      user_synonyms   us2
      where  us2.synonym_name = p_hist_table_name
      and    tc2.table_name   = us2.synonym_name
      and    tc2.owner        = us2.table_owner
      and    tc2.column_name  = tc.column_name
    )
    order by column_id; */

Line: 210

  statement := 'INSERT INTO ' || p_hist_table_name || ' ( ' ||
               column_list || 'MAJOR_VERSION ) SELECT ' ||
               column_list || ':mv FROM ' || p_table_name ||
               ' WHERE ' || p_where_clause;

Line: 231

	statement := 'UPDATE '||p_table_name|| ' set PREVIOUS_AMOUNT=AMOUNT WHERE ' ||p_where_clause;

Line: 283

    select   column_name, column_id
    from     all_tab_columns tc
    where     (tc.owner,tc.table_name) in  (
      select   us.table_owner,us.synonym_name
      from     user_synonyms      us
      where    us.synonym_name = p_table_name)
    and     tc.column_name  <> 'MAJOR_VERSION'
    and     tc.data_type not in ('LONG', 'LONG RAW')
    and     exists (
      select     1
      from       user_synonyms      us2,
                 all_tab_columns  tc2
      where      us2.synonym_name = p_hist_table_name
      and        tc2.table_name  = us2.synonym_name
      and        tc2.owner        = us2.table_owner
      and        tc2.column_name  = tc.column_name
      )
    order by column_id;

Line: 303

    select distinct column_name, column_id
    from   all_tab_columns tc
    ,      user_synonyms   us
    where  us.synonym_name = p_table_name
    and    tc.table_name   = us.synonym_name
    and    tc.owner        = us.table_owner
    and    tc.column_name  <> 'MAJOR_VERSION'
    and    tc.data_type not in ('LONG', 'LONG RAW')
    and exists (
      select null
      from   all_tab_columns tc2
      ,      user_synonyms   us2
      where  us2.synonym_name = p_hist_table_name
      and    tc2.table_name   = us2.synonym_name
      and    tc2.owner        = us2.table_owner
      and    tc2.column_name  = tc.column_name
    )
    order by column_id;

Line: 353

  statement := 'DELETE FROM ' || p_table_name ||
               ' WHERE ' || p_where_clause;

Line: 368

  statement := 'INSERT INTO ' || p_table_name || ' ( ' ||
               column_list || ' ) SELECT ' ||
               column_list || ' FROM ' || p_hist_table_name ||
               ' WHERE ' || p_where_clause ||
               ' AND MAJOR_VERSION = :mv';

Line: 409

	statement := 'UPDATE '||p_table_name|| ' set PREVIOUS_AMOUNT=(SELECT AMOUNT FROM '||
	p_hist_table_name ||' WHERE '||p_where_clause||' AND MAJOR_VERSION = :mv)'
	|| 'WHERE ' ||p_where_clause;

Line: 464

  select kvn.chr_id
  ,      kvn.major_version
  ,      kvn.minor_version
  ,      kvn.object_version_number
  ,      kvn.created_by
  ,      kvn.creation_date
  ,      kvn.last_updated_by
  ,      kvn.last_update_date
  ,      kvn.last_update_login
  FROM   okc_k_vers_numbers kvn
  WHERE  chr_id = p_chr_id;

Line: 512

             ,    okc_cvmv_rec_in.last_updated_by
             ,    okc_cvmv_rec_in.last_update_date
             ,    okc_cvmv_rec_in.last_update_login;

Line: 603

	insert into OKE_K_VERS_NUMBERS_H
	(K_HEADER_ID
 	,MAJOR_VERSION
 	,CREATION_DATE
 	,CREATED_BY
 	,LAST_UPDATE_DATE
 	,LAST_UPDATED_BY
 	,LAST_UPDATE_LOGIN
 	,VERSION_REASON_CODE
 	,CHG_REQUEST_ID)
	values
	(p_chr_id
	,x_new_vers
        ,sysdate
	,fnd_global.user_id
	,sysdate
	,fnd_global.user_id
	,fnd_global.login_id
	,p_version_reason_code
	,p_chg_request_id
	);