APPS.FND_DICTIONARY_PKG SQL Statements

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

Line: 20

   select count(*)
   into   l_tmp
   from   FND_PRIMARY_KEYS
   where  APPLICATION_ID = x_application_id
   and    TABLE_ID       = x_table_id
   and    PRIMARY_KEY_NAME  <> upper(x_primary_key_name)
   and    PRIMARY_KEY_TYPE = 'D';

Line: 49

     select P.APPLICATION_ID, P.TABLE_ID, P.PRIMARY_KEY_ID
     into   x_pk_application_id, x_pk_table_id, x_pk_id
     from   FND_PRIMARY_KEYS P,
            FND_TABLES T,
            FND_APPLICATION A
     where  A.APPLICATION_SHORT_NAME = x_application_short_name
     and    A.APPLICATION_ID = T.APPLICATION_ID
     and    T.TABLE_NAME = x_table_name
     and    T.TABLE_ID = P.TABLE_ID
     and    T.APPLICATION_ID = P.APPLICATION_ID
     and    P.PRIMARY_KEY_NAME  = upper(x_primary_key_name);

Line: 85

  update FND_COLUMNS
  set USER_COLUMN_NAME = '@'||USER_COLUMN_NAME
  where APPLICATION_ID = x_application_id
  and 	TABLE_ID = x_table_id
  and   COLUMN_NAME <> x_column_name
  and   USER_COLUMN_NAME = x_user_column_name;

Line: 92

  select max(column_sequence)
  into maxseq
  from FND_COLUMNS
  where APPLICATION_ID = x_application_id
  and   TABLE_ID = x_table_id;

Line: 98

  update FND_COLUMNS
  set COLUMN_SEQUENCE = to_number('200001') + maxseq
  where APPLICATION_ID = x_application_id
  and 	TABLE_ID = x_table_id
  and   COLUMN_NAME <> x_column_name
  and   COLUMN_SEQUENCE = to_number(x_column_sequence);

Line: 112

procedure InsertTable (
  x_application_id               in number,
  x_table_name                   in varchar2,
  x_user_table_name              in varchar2,
  x_table_type                   in varchar2,
  x_description                  in varchar2,
  x_auto_size                    in varchar2,
  x_initial_extent               in varchar2,
  x_next_extent                  in varchar2,
  x_min_extents                  in varchar2,
  x_max_extents                  in varchar2,
  x_ini_trans                    in varchar2,
  x_max_trans                    in varchar2,
  x_pct_free                     in varchar2,
  x_pct_increase                 in varchar2,
  x_pct_used                     in varchar2,
  x_hosted_support_style         in varchar2,
  x_creation_date                in date,
  x_created_by                   in number,
  x_last_update_date             in date,
  x_last_updated_by              in number,
  x_last_update_login            in number
) is
begin
  insert into FND_TABLES (
    APPLICATION_ID,
    TABLE_ID,
    TABLE_NAME,
    USER_TABLE_NAME,
    TABLE_TYPE,
    DESCRIPTION,
    AUTO_SIZE,
    INITIAL_EXTENT,
    NEXT_EXTENT,
    MIN_EXTENTS,
    MAX_EXTENTS,
    INI_TRANS,
    MAX_TRANS,
    PCT_FREE,
    PCT_INCREASE,
    PCT_USED,
    HOSTED_SUPPORT_STYLE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    CREATION_DATE,
    CREATED_BY)
    values (
    x_application_id,
    FND_TABLES_S.NEXTVAL,
    x_table_name,
    x_user_table_name,
    x_table_type,
    x_description,
    x_auto_size,
    x_initial_extent,
    x_next_extent,
    x_min_extents,
    x_max_extents,
    x_ini_trans,
    x_max_trans,
    x_pct_free,
    x_pct_increase,
    x_pct_used,
    x_hosted_support_style,
    x_last_updated_by,
    x_last_update_date,
    x_last_update_login,
    x_last_update_date,
    x_last_updated_by);

Line: 183

end InsertTable;

Line: 190

procedure InsertColumn (
  x_application_id               in number,
  x_table_id                     in number,
  x_column_name                  in varchar2,
  x_user_column_name             in varchar2,
  x_column_sequence              in varchar2,
  x_column_type                  in varchar2,
  x_width                        in varchar2,
  x_null_allowed_flag            in varchar2,
  x_description                  in varchar2,
  x_default_value                in varchar2,
  x_translate_flag               in varchar2,
  x_precision                    in varchar2,
  x_scale                        in varchar2,
  x_flexfield_usage_code         in varchar2,
  x_flexfield_application_id     in varchar2,
  x_flexfield_name               in varchar2,
  x_flex_value_set_app_id        in varchar2,
  x_flex_value_set_id            in varchar2,
  x_creation_date                in date,
  x_created_by                   in number,
  x_last_update_date             in date,
  x_last_updated_by              in number,
  x_last_update_login            in number
) is

begin

  insert into FND_COLUMNS (
      APPLICATION_ID,
      TABLE_ID,
      COLUMN_ID,
      COLUMN_NAME,
      USER_COLUMN_NAME,
      COLUMN_SEQUENCE,
      COLUMN_TYPE,
      WIDTH,
      NULL_ALLOWED_FLAG,
      DESCRIPTION,
      DEFAULT_VALUE,
      TRANSLATE_FLAG,
      PRECISION,
      SCALE,
      FLEXFIELD_USAGE_CODE,
      FLEXFIELD_APPLICATION_ID,
      FLEXFIELD_NAME,
      FLEX_VALUE_SET_APPLICATION_ID,
      FLEX_VALUE_SET_ID,
      CREATION_DATE,
      CREATED_BY,
      LAST_UPDATED_BY,
      LAST_UPDATE_DATE,
      LAST_UPDATE_LOGIN)
      values (
      x_application_id,
      x_table_id,
      FND_COLUMNS_S.NEXTVAL,
      x_column_name,
      x_user_column_name,
      x_column_sequence,
      x_column_type,
      x_width,
      x_null_allowed_flag,
      x_description,
      x_default_value,
      x_translate_flag,
      x_precision,
      x_scale,
      x_flexfield_usage_code,
      x_flexfield_application_id,
      x_flexfield_name,
      x_flex_value_set_app_id,
      x_flex_value_set_id,
      x_last_update_date,
      x_last_updated_by,
      x_last_updated_by,
      x_last_update_date,
      x_last_update_login);

Line: 269

end InsertColumn;

Line: 276

procedure InsertIndex (
  x_application_id               in number,
  x_table_id                     in number,
  x_index_name                   in varchar2,
  x_uniqueness                   in varchar2,
  x_auto_size                    in varchar2,
  x_description                  in varchar2,
  x_initial_extent               in varchar2,
  x_next_extent                  in varchar2,
  x_min_extents                  in varchar2,
  x_max_extents                  in varchar2,
  x_ini_trans                    in varchar2,
  x_max_trans                    in varchar2,
  x_pct_free                     in varchar2,
  x_pct_increase                 in varchar2,
  x_creation_date                in date,
  x_created_by                   in number,
  x_last_update_date             in date,
  x_last_updated_by              in number,
  x_last_update_login            in number

) is

begin

  insert into FND_INDEXES (
      APPLICATION_ID,
      TABLE_ID,
      INDEX_ID,
      INDEX_NAME,
      UNIQUENESS,
      AUTO_SIZE,
      DESCRIPTION,
      INITIAL_EXTENT,
      NEXT_EXTENT,
      MIN_EXTENTS,
      MAX_EXTENTS,
      INI_TRANS,
      MAX_TRANS,
      PCT_FREE,
      PCT_INCREASE,
      LAST_UPDATED_BY,
      LAST_UPDATE_DATE,
      LAST_UPDATE_LOGIN,
      CREATION_DATE,
      CREATED_BY)
      values (
      x_application_id,
      x_table_id,
      FND_INDEXES_S.NEXTVAL,
      x_index_name,
      x_uniqueness,
      x_auto_size,
      x_description,
      x_initial_extent,
      x_next_extent,
      x_min_extents,
      x_max_extents,
      x_ini_trans,
      x_max_trans,
      x_pct_free,
      x_pct_increase,
      x_last_updated_by,
      x_last_update_date,
      x_last_update_login,
      x_last_update_date,
      x_last_updated_by);

Line: 343

end InsertIndex;

Line: 351

procedure InsertPrimaryKey(
  x_application_id               in number,
  x_table_id                     in number,
  x_primary_key_name             in varchar2,
  x_primary_key_type             in varchar2,
  x_audit_key_flag               in varchar2,
  x_enabled_flag                 in varchar2,
  x_description                  in varchar2,
  x_creation_date                in date,
  x_created_by                   in number,
  x_last_update_date             in date,
  x_last_updated_by              in number,
  x_last_update_login            in number
) is

begin

  insert into FND_PRIMARY_KEYS(
      APPLICATION_ID,
      TABLE_ID,
      PRIMARY_KEY_NAME,
      PRIMARY_KEY_ID,
      PRIMARY_KEY_TYPE,
      AUDIT_KEY_FLAG,
      ENABLED_FLAG,
      DESCRIPTION,
      LAST_UPDATED_BY,
      LAST_UPDATE_DATE,
      LAST_UPDATE_LOGIN,
      CREATION_DATE,
      CREATED_BY)
      values (
      x_application_id,
      x_table_id,
      x_primary_key_name,
      FND_PRIMARY_KEYS_S.NEXTVAL,
      x_primary_key_type,
      x_audit_key_flag,
      x_enabled_flag,
      x_description,
      x_last_updated_by,
      x_last_update_date,
      x_last_update_login,
      x_last_update_date,
      x_last_updated_by);

Line: 396

end InsertPrimaryKey;

Line: 404

procedure InsertForeignKey(
  x_application_id               in number,
  x_table_id                     in number,
  x_foreign_key_name             in varchar2,
  x_primary_key_application_id   in number,
  x_primary_key_table_id         in number,
  x_primary_key_id               in number,
  x_description                  in varchar2,
  x_cascade_behavior             in varchar2,
  x_foreign_key_relation         in varchar2,
  x_condition                    in varchar2,
  x_enabled_flag                 in varchar2,
  x_creation_date                in date,
  x_created_by                   in number,
  x_last_update_date             in date,
  x_last_updated_by              in number,
  x_last_update_login            in number
) is

begin

  insert into FND_FOREIGN_KEYS(
      APPLICATION_ID,
      TABLE_ID,
      FOREIGN_KEY_ID,
      FOREIGN_KEY_NAME,
      PRIMARY_KEY_APPLICATION_ID,
      PRIMARY_KEY_TABLE_ID,
      PRIMARY_KEY_ID,
      DESCRIPTION,
      CASCADE_BEHAVIOR,
      FOREIGN_KEY_RELATION,
      CONDITION,
      ENABLED_FLAG,
      LAST_UPDATED_BY,
      LAST_UPDATE_DATE,
      LAST_UPDATE_LOGIN,
      CREATION_DATE,
      CREATED_BY)
      values (
      x_application_id,
      x_table_id,
      FND_FOREIGN_KEYS_S.NEXTVAL,
      x_foreign_key_name,
      x_primary_key_application_id,
      x_primary_key_table_id,
      x_primary_key_id,
      x_description,
      x_cascade_behavior,
      x_foreign_key_relation,
      x_condition,
      x_enabled_flag,
      x_last_updated_by,
      x_last_update_date,
      x_last_update_login,
      x_last_update_date,
      x_last_updated_by);

Line: 461

end InsertForeignKey;

Line: 468

procedure InsertSequence (
  x_application_id               in number,
  x_sequence_name                in varchar2,
  x_start_value                  in varchar2,
  x_description                  in varchar2,
  x_increment_by                 in varchar2,
  x_min_value                    in varchar2,
  x_max_value                    in varchar2,
  x_cache_size                   in varchar2,
  x_cycle_flag                   in varchar2,
  x_order_flag                   in varchar2,
  x_creation_date                in date,
  x_created_by                   in number,
  x_last_update_date             in date,
  x_last_updated_by              in number,
  x_last_update_login            in number
) is
begin
  insert into FND_SEQUENCES (
    APPLICATION_ID,
    SEQUENCE_ID,
    SEQUENCE_NAME,
    START_VALUE,
    DESCRIPTION,
    INCREMENT_BY,
    MIN_VALUE,
    MAX_VALUE,
    CACHE_SIZE,
    CYCLE_FLAG,
    ORDER_FLAG,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    CREATION_DATE,
    CREATED_BY)
    values (
    x_application_id,
    FND_SEQUENCES_S.NEXTVAL,
    x_sequence_name,
    x_start_value,
    x_description,
    x_increment_by,
    x_min_value,
    x_max_value,
    x_cache_size,
    x_cycle_flag,
    x_order_flag,
    x_last_updated_by,
    x_last_update_date,
    x_last_update_login,
    x_last_update_date,
    x_last_updated_by);

Line: 521

end InsertSequence;

Line: 528

procedure InsertView (
  x_application_id               in number,
  x_view_name                    in varchar2,
  x_text                         in varchar2,
  x_description                  in varchar2,
  x_creation_date                in date,
  x_created_by                   in number,
  x_last_update_date             in date,
  x_last_updated_by              in number,
  x_last_update_login            in number
) is
begin
  insert into FND_VIEWS (
    APPLICATION_ID,
    VIEW_ID,
    VIEW_NAME,
    TEXT,
    DESCRIPTION,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    CREATION_DATE,
    CREATED_BY)
    values (
    x_application_id,
    FND_VIEWS_S.NEXTVAL,
    x_view_name,
    x_text,
    x_description,
    x_last_updated_by,
    x_last_update_date,
    x_last_update_login,
    x_last_update_date,
    x_last_updated_by);

Line: 563

end InsertView;

Line: 610

  x_last_update_date =>		null);

Line: 663

  x_last_update_date =>		   null);

Line: 689

  x_last_update_date => 	null);

Line: 735

  x_last_update_date => 	null,
  x_phase_mode =>		'BEGIN');

Line: 756

  x_last_update_date =>         null,
  x_phase_mode =>               'END');

Line: 785

  x_last_update_date => 	null);

Line: 815

  x_last_update_date => 	null,
  x_phase_mode =>		'BEGIN');

Line: 828

  x_last_update_date =>         null,
  x_phase_mode =>               'END');

Line: 856

  x_last_update_date =>		null);

Line: 895

  x_last_update_date =>         null,
  x_phase_mode =>		'BEGIN');

Line: 912

  x_last_update_date =>         null,
  x_phase_mode =>               'END');

Line: 942

  x_last_update_date =>		null);

Line: 979

  x_last_update_date => 	null);

Line: 1003

  x_last_update_date => 	null,
  x_phase_mode =>		'BEGIN');

Line: 1013

  x_last_update_date =>         null,
  x_phase_mode =>               'END');

Line: 1039

  x_last_update_date => 	null);

Line: 1056

   for r in (select text from fnd_views
             where application_id = x_application_id
             and   view_name = x_view_name) loop
     len := length(r.text);

Line: 1076

     select text
     into vtext
     from fnd_views
     where application_id = x_application_id
     and   view_name = x_view_name;

Line: 1109

    select application_id
    into appl_id
    from fnd_application
    where application_short_name = upper(x_application_short_name);

Line: 1124

    select table_id
    into tab_id
    from fnd_tables
    where application_id = appl_id
    and table_name = upper(x_table_name);

Line: 1140

    select column_id
    into col_id
    from fnd_columns
    where application_id = appl_id
    and table_id = tab_id
    and column_name = upper(x_column_name);

Line: 1161

  select count(*) into cnt
  from fnd_index_columns
  where application_id = appl_id
  and table_id = tab_id
  and column_id = col_id;

Line: 1178

  select count(*) into cnt
  from fnd_primary_key_columns
  where application_id = appl_id
  and table_id = tab_id
  and column_id = col_id;

Line: 1195

  select count(*) into cnt
  from fnd_foreign_key_columns
  where application_id = appl_id
  and table_id = tab_id
  and column_id = col_id;

Line: 1210

  delete from fnd_columns
  where application_id = appl_id
  and table_id = tab_id
  and column_id = col_id;

Line: 1230

    select application_id
    into appl_id
    from fnd_application
    where application_short_name = upper(x_application_short_name);

Line: 1245

    select table_id
    into tab_id
    from fnd_tables
    where application_id = appl_id
    and table_name = upper(x_table_name);

Line: 1261

    select index_id
    into ind_id
    from fnd_indexes
    where application_id = appl_id
    and table_id = tab_id
    and index_name = upper(x_index_name);

Line: 1278

  delete from fnd_index_columns
  where application_id = appl_id
  and table_id = tab_id
  and index_id = ind_id;

Line: 1283

  delete from fnd_indexes
  where application_id = appl_id
  and table_id = tab_id
  and index_id = ind_id;

Line: 1306

    select application_id
    into appl_id
    from fnd_application
    where application_short_name = upper(x_application_short_name);

Line: 1321

    select table_id
    into tab_id
    from fnd_tables
    where application_id = appl_id
    and table_name = upper(x_table_name);

Line: 1337

    select primary_key_id
    into pk_id
    from fnd_primary_keys
    where application_id = appl_id
    and table_id = tab_id
    and primary_key_name = upper(x_primary_key_name);

Line: 1357

  select count(*) into cnt
  from fnd_foreign_keys
  where primary_key_application_id = appl_id
  and primary_key_table_id = tab_id
  and primary_key_id = pk_id;

Line: 1364

    delete from fnd_primary_key_columns
    where application_id = appl_id
    and table_id = tab_id
    and primary_key_id = pk_id;

Line: 1369

    delete from fnd_primary_keys
    where application_id = appl_id
    and table_id = tab_id
    and primary_key_id = pk_id;

Line: 1398

    select application_id
    into appl_id
    from fnd_application
    where application_short_name = upper(x_application_short_name);

Line: 1413

    select table_id
    into tab_id
    from fnd_tables
    where application_id = appl_id
    and table_name = upper(x_table_name);

Line: 1429

    select foreign_key_id
    into fk_id
    from fnd_foreign_keys
    where application_id = appl_id
    and table_id = tab_id
    and foreign_key_name = upper(x_foreign_key_name);

Line: 1446

  delete from fnd_foreign_key_columns
  where application_id = appl_id
  and table_id = tab_id
  and foreign_key_id = fk_id;

Line: 1451

  delete from fnd_foreign_keys
  where application_id = appl_id
  and table_id = tab_id
  and foreign_key_id = fk_id;

Line: 1468

    select application_id
    into appl_id
    from fnd_application
    where application_short_name = upper(x_application_short_name);

Line: 1482

  delete from fnd_sequences
  where application_id = appl_id
  and sequence_name = upper(x_sequence_name);

Line: 1507

    select application_id
    into appl_id
    from fnd_application
    where application_short_name = upper(x_application_short_name);

Line: 1522

    select view_id into vw_id
    from fnd_views
    where application_id = appl_id
    and view_name = upper(x_view_name);

Line: 1537

  delete from fnd_view_columns
  where application_id = appl_id
  and view_id = vw_id;

Line: 1541

  delete from fnd_views
  where application_id = appl_id
  and view_id = vw_id;

Line: 1559

  select index_name
  from fnd_indexes
  where application_id = appl_id
  and table_id = tab_id;

Line: 1565

  select foreign_key_name
  from fnd_foreign_keys
  where application_id = appl_id
  and table_id = tab_id;

Line: 1571

  select primary_key_name
  from fnd_primary_keys
  where application_id = appl_id
  and table_id = tab_id;

Line: 1579

    select application_id
    into appl_id
    from fnd_application
    where application_short_name = upper(x_application_short_name);

Line: 1594

    select table_id
    into tab_id
    from fnd_tables
    where application_id = appl_id
    and table_name = upper(x_table_name);

Line: 1629

  delete from fnd_columns
  where application_id = appl_id
  and table_id = tab_id;

Line: 1634

  delete from fnd_tables
  where application_id = appl_id
  and table_id = tab_id;

Line: 1664

  x_last_update_date 		   in varchar2
) is
  appl_id number;

Line: 1669

  f_ludate  date;    -- entity update date in file

Line: 1671

  db_ludate date;    -- entity update date in db

Line: 1676

  select A.APPLICATION_ID
  into appl_id
  from FND_APPLICATION A
  where A.APPLICATION_SHORT_NAME = x_application_short_name;

Line: 1690

      select 'X' into dummy
        from fnd_lookups
       where lookup_type = 'HOSTED_SUPPORT_STYLE'
         and lookup_code = x_hosted_support_style;

Line: 1706

  f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);

Line: 1709

    select LAST_UPDATED_BY, LAST_UPDATE_DATE
    into db_luby, db_ludate
    from FND_TABLES
    where APPLICATION_ID = appl_id
    and TABLE_NAME = x_table_name;

Line: 1719

  update FND_TABLES
  set USER_TABLE_NAME = '@'||USER_TABLE_NAME
  where APPLICATION_ID = appl_id
  and 	TABLE_NAME <> x_table_name
  and   USER_TABLE_NAME = x_user_table_name;

Line: 1725

  update FND_TABLES set
      USER_TABLE_NAME = x_user_table_name,
      TABLE_TYPE = x_table_type,
      DESCRIPTION = x_description,
      AUTO_SIZE = x_auto_size,
      INITIAL_EXTENT = x_initial_extent,
      NEXT_EXTENT = x_next_extent,
      MIN_EXTENTS = x_min_extents,
      MAX_EXTENTS = x_max_extents,
      INI_TRANS = x_ini_trans,
      MAX_TRANS = x_max_trans,
      PCT_FREE = x_pct_free,
      PCT_INCREASE = x_pct_increase,
      PCT_USED = x_pct_used,
      HOSTED_SUPPORT_STYLE = x_hosted_support_style,
      LAST_UPDATED_BY = f_luby,
      LAST_UPDATE_DATE = f_ludate,
      LAST_UPDATE_LOGIN = f_luby
  where APPLICATION_ID = appl_id
  and   TABLE_NAME = x_table_name;

Line: 1748

    Fnd_Dictionary_Pkg.InsertTable(
        appl_id,
        x_table_name,
        x_user_table_name,
        x_table_type,
        x_description,
        x_auto_size,
        x_initial_extent,
        x_next_extent,
        x_min_extents,
        x_max_extents,
        x_ini_trans,
        x_max_trans,
        x_pct_free,
        x_pct_increase,
        x_pct_used,
        x_hosted_support_style,
        f_ludate,
        f_luby,
        f_ludate,
        f_luby,
        0);

Line: 1799

  x_last_update_date 		   in varchar2
) is
  tab_id number;

Line: 1804

  f_ludate  date;    -- entity update date in file

Line: 1806

  db_ludate date;    -- entity update date in db

Line: 1811

  select A.APPLICATION_ID
  into appl_id
  from FND_APPLICATION A
  where A.APPLICATION_SHORT_NAME = x_application_short_name;

Line: 1816

  select T.TABLE_ID into tab_id from FND_TABLES T
  where T.APPLICATION_ID = appl_id
  and T.TABLE_NAME = x_table_name;

Line: 1827

  f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);

Line: 1830

    select LAST_UPDATED_BY, LAST_UPDATE_DATE
    into db_luby, db_ludate
    from FND_COLUMNS
    where APPLICATION_ID = appl_id
    and TABLE_ID = tab_id
    and COLUMN_NAME = x_column_name;

Line: 1840

      update FND_COLUMNS set
      USER_COLUMN_NAME = x_user_column_name,
      COLUMN_SEQUENCE = x_column_sequence,
      COLUMN_TYPE = x_column_type,
      WIDTH = x_width,
      NULL_ALLOWED_FLAG = x_null_allowed_flag,
      DESCRIPTION = x_description,
      DEFAULT_VALUE = x_default_value,
      TRANSLATE_FLAG = x_translate_flag,
      PRECISION = x_precision,
      SCALE = x_scale,
      FLEXFIELD_USAGE_CODE = x_flexfield_usage_code,
      FLEXFIELD_APPLICATION_ID = x_flexfield_application_id,
      FLEXFIELD_NAME = x_flexfield_name,
      FLEX_VALUE_SET_APPLICATION_ID = x_flex_value_set_app_id,
      FLEX_VALUE_SET_ID = x_flex_value_set_id,
      LAST_UPDATED_BY = f_luby,
      LAST_UPDATE_DATE = f_ludate,
      LAST_UPDATE_LOGIN = f_luby
  where APPLICATION_ID = appl_id
  and   TABLE_ID = tab_id
  and   COLUMN_NAME = x_column_name;

Line: 1865

    Fnd_Dictionary_Pkg.InsertColumn(
        appl_id,
        tab_id,
        x_column_name,
        x_user_column_name,
        x_column_sequence,
        x_column_type,
        x_width,
        x_null_allowed_flag,
        x_description,
        x_default_value,
        x_translate_flag,
        x_precision,
        x_scale,
        x_flexfield_usage_code,
        x_flexfield_application_id,
        x_flexfield_name,
        x_flex_value_set_app_id,
        x_flex_value_set_id,
        f_ludate,
        f_luby,
        f_ludate,
        f_luby,
        0);

Line: 1905

  x_last_update_date 		   in varchar2
) is
  appl_id number;

Line: 1909

  f_ludate  date;    -- entity update date in file

Line: 1911

  db_ludate date;    -- entity update date in db

Line: 1916

  select A.APPLICATION_ID
  into appl_id
  from FND_APPLICATION A
  where A.APPLICATION_SHORT_NAME = x_application_short_name;

Line: 1925

  f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);

Line: 1928

    select LAST_UPDATED_BY, LAST_UPDATE_DATE
    into db_luby, db_ludate
    from FND_HISTOGRAM_COLS
    where APPLICATION_ID = appl_id
    and TABLE_NAME = x_table_name
    and COLUMN_NAME = x_column_name;

Line: 1938

  update FND_HISTOGRAM_COLS set
      PARTITION = x_partition,
      HSIZE = x_hsize,
      LAST_UPDATED_BY = f_luby,
      LAST_UPDATE_DATE = f_ludate,
      LAST_UPDATE_LOGIN = f_luby
  where APPLICATION_ID = appl_id
  and   TABLE_NAME = x_table_name
  and   COLUMN_NAME = x_column_name;

Line: 1950

    insert into FND_HISTOGRAM_COLS (
      APPLICATION_ID,
      TABLE_NAME,
      COLUMN_NAME,
      PARTITION,
      HSIZE,
      CREATION_DATE,
      CREATED_BY,
      LAST_UPDATED_BY,
      LAST_UPDATE_DATE,
      LAST_UPDATE_LOGIN)
      values (
      appl_id,
      x_table_name,
      x_column_name,
      x_partition,
      x_hsize,
      f_ludate,
      f_luby,
      f_luby,
      f_ludate,
      f_luby);

Line: 1999

  x_last_update_date 		   in varchar2,
  x_phase_mode			   in varchar2
) is
  tab_id number;

Line: 2005

  f_ludate  date;    -- entity update date in file

Line: 2007

  db_ludate date;    -- entity update date in db

Line: 2009

  child_file_ludate date;   -- child entity update date in file

Line: 2011

  child_db_ludate   date;   -- child update date in db

Line: 2020

  select A.APPLICATION_ID
  into appl_id
  from FND_APPLICATION A
  where A.APPLICATION_SHORT_NAME = x_application_short_name;

Line: 2025

  select T.TABLE_ID into tab_id from FND_TABLES T
  where T.APPLICATION_ID = appl_id
  and T.TABLE_NAME = x_table_name;

Line: 2038

    f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);

Line: 2042

     select INDEX_ID
     into ind_id
      from FND_INDEXES
     where APPLICATION_ID = appl_id
     and TABLE_ID = tab_id
     and INDEX_NAME = x_index_name;

Line: 2049

    select LAST_UPDATED_BY, LAST_UPDATE_DATE
    into db_luby, db_ludate
    from FND_INDEXES
    where APPLICATION_ID = appl_id
    and TABLE_ID = tab_id
    and INDEX_NAME = x_index_name;

Line: 2059

     update FND_INDEXES set
      UNIQUENESS = x_uniqueness,
      AUTO_SIZE = x_auto_size,
      DESCRIPTION = x_description,
      INITIAL_EXTENT = x_initial_extent,
      NEXT_EXTENT = x_next_extent,
      MIN_EXTENTS = x_min_extents,
      MAX_EXTENTS = x_max_extents,
      INI_TRANS = x_ini_trans,
      MAX_TRANS = x_max_trans,
      PCT_FREE = x_pct_free,
      PCT_INCREASE = x_pct_increase,
      LAST_UPDATED_BY = f_luby,
      LAST_UPDATE_DATE = f_ludate,
      LAST_UPDATE_LOGIN = f_luby
     where APPLICATION_ID = appl_id
     and   TABLE_ID = tab_id
     and   INDEX_NAME = x_index_name;

Line: 2083

      delete from FND_INDEX_COLUMNS
       where APPLICATION_ID = appl_id
       and TABLE_ID = tab_id
       and INDEX_ID = ind_id
       and COLUMN_ID < 0;

Line: 2094

     update FND_INDEX_COLUMNS
      set COLUMN_SEQUENCE = -1 * COLUMN_SEQUENCE,
          COLUMN_ID = -1 * COLUMN_ID
     where APPLICATION_ID = appl_id
     and   TABLE_ID = tab_id
     and   INDEX_ID = ind_id;

Line: 2103

     update FND_INDEX_COLUMNS
      set COLUMN_SEQUENCE = -1000
     where APPLICATION_ID = appl_id
     and   TABLE_ID = tab_id
     and   INDEX_ID = ind_id
     and COLUMN_SEQUENCE = 0;

Line: 2112

       Fnd_Dictionary_Pkg.InsertIndex(
        appl_id,
        tab_id,
        x_index_name,
        x_uniqueness,
        x_auto_size,
        x_description,
        x_initial_extent,
        x_next_extent,
        x_min_extents,
        x_max_extents,
        x_ini_trans,
        x_max_trans,
        x_pct_free,
        x_pct_increase,
        f_ludate,
        f_luby,
        f_ludate,
        f_luby,
        0);

Line: 2136

     select INDEX_ID
     into ind_id
      from FND_INDEXES
     where APPLICATION_ID = appl_id
     and TABLE_ID = tab_id
     and INDEX_NAME = x_index_name;

Line: 2146

  select max(last_update_date)
    into child_db_ludate
    from fnd_index_columns
    where application_id = appl_id
    and table_id = tab_id
    and index_id = ind_id
    and column_sequence < 0
    and column_id < 0;

Line: 2157

  select max(last_update_date)
    into child_file_ludate
    from fnd_index_columns
    where application_id = appl_id
    and table_id = tab_id
    and index_id = ind_id
    and column_sequence >= 0
    and column_id > 0;

Line: 2180

       select max(-1)
       into child_db_luby
       from fnd_index_columns
         where application_id = appl_id
         and table_id = tab_id
         and index_id = ind_id
         and column_sequence < 0
         and column_id < 0
         and last_updated_by not in (0,1,2);

Line: 2195

       select max(-1)
       into child_file_luby
       from fnd_index_columns
         where application_id = appl_id
         and table_id = tab_id
         and index_id = ind_id
         and column_sequence > 0
         and column_id > 0
         and last_updated_by not in (0,1,2);

Line: 2216

         delete from fnd_index_columns
            where application_id = appl_id
            and table_id = tab_id
            and index_id = ind_id
            and column_sequence < 0
            and column_id < 0;

Line: 2229

            delete from fnd_index_columns
            where application_id = appl_id
            and table_id = tab_id
            and index_id = ind_id
            and column_sequence >= 0
            and column_id > 0;

Line: 2240

         update FND_INDEX_COLUMNS
             set COLUMN_SEQUENCE = -1 * COLUMN_SEQUENCE,
                  COLUMN_ID = -1 * COLUMN_ID
    		where APPLICATION_ID = appl_id
    		and   TABLE_ID = tab_id
    		and   INDEX_ID = ind_id;

Line: 2249

         update FND_INDEX_COLUMNS
             set COLUMN_SEQUENCE = 0
                where APPLICATION_ID = appl_id
                and   TABLE_ID = tab_id
                and   INDEX_ID = ind_id
                and COLUMN_SEQUENCE = 1000;

Line: 2269

         update FND_INDEX_COLUMNS
             set COLUMN_SEQUENCE = -1 * COLUMN_SEQUENCE,
                  COLUMN_ID = -1 * COLUMN_ID
    		where APPLICATION_ID = appl_id
    		and   TABLE_ID = tab_id
    		and   INDEX_ID = ind_id;

Line: 2278

         update FND_INDEX_COLUMNS
             set COLUMN_SEQUENCE = 0
                where APPLICATION_ID = appl_id
                and   TABLE_ID = tab_id
                and   INDEX_ID = ind_id
                and COLUMN_SEQUENCE = 1000;

Line: 2303

  x_last_update_date 		   in varchar2
) is
  tab_id number;

Line: 2310

  f_ludate  date;    -- entity update date in file

Line: 2315

  select A.APPLICATION_ID
  into appl_id
  from FND_APPLICATION A
  where A.APPLICATION_SHORT_NAME = x_application_short_name;

Line: 2320

  select T.TABLE_ID into tab_id from FND_TABLES T
  where T.APPLICATION_ID = appl_id
  and T.TABLE_NAME = x_table_name;

Line: 2324

  select I.INDEX_ID into idx_id from FND_INDEXES I
  where I.APPLICATION_ID = appl_id
  and   I.TABLE_ID = tab_id
  and   I.INDEX_NAME = x_index_name;

Line: 2330

    select C.COLUMN_ID into col_id from FND_COLUMNS C
    where C.APPLICATION_ID = appl_id
    and   C.TABLE_ID = tab_id
    and   C.COLUMN_NAME = x_index_column_name;

Line: 2347

  f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);

Line: 2355

     insert into FND_INDEX_COLUMNS(
      APPLICATION_ID,
      TABLE_ID,
      INDEX_ID,
      COLUMN_ID,
      COLUMN_SEQUENCE,
      LAST_UPDATED_BY,
      LAST_UPDATE_DATE,
      LAST_UPDATE_LOGIN,
      CREATION_DATE,
      CREATED_BY)
      values (
      appl_id,
      tab_id,
      idx_id,
      col_id,
      x_index_column_sequence,
      f_luby,
      f_ludate,
      f_luby,
      f_ludate,
      f_luby);

Line: 2403

  x_last_update_date 		   in varchar2,
  x_phase_mode			   in varchar2
) is
  tab_id number;

Line: 2412

  f_ludate  date;    -- entity update date in file

Line: 2414

  db_ludate date;    -- entity update date in db

Line: 2417

  child_file_ludate date;   -- child entity update date in file

Line: 2419

  child_db_ludate   date;   -- child update date in db

Line: 2426

  select A.APPLICATION_ID
  into appl_id
  from FND_APPLICATION A
  where A.APPLICATION_SHORT_NAME = x_application_short_name;

Line: 2431

  select T.TABLE_ID into tab_id from FND_TABLES T
  where T.APPLICATION_ID = appl_id
  and T.TABLE_NAME = x_table_name;

Line: 2441

    pkmode := 'INSERT';

Line: 2443

    pkmode := 'UPDATE';

Line: 2446

  if ((pkmode = 'INSERT' and x_primary_key_type not in ('S', 'D')) or
      (pkmode = 'UPDATE' and nvl(x_primary_key_type, 'S') not in ('S', 'D'))) then
      fnd_message.set_name('FND', 'FND-INVALID PRIMARY KEY ATTR');

Line: 2455

  if ((pkmode = 'INSERT' and x_audit_key_flag not in ('Y', 'N')) or
      (pkmode = 'UPDATE' and nvl(x_audit_key_flag, 'Y') not in ('Y', 'N'))) then
      fnd_message.set_name('FND', 'FND-INVALID PRIMARY KEY ATTR');

Line: 2464

  if ((pkmode = 'INSERT' and x_enabled_flag not in ('Y', 'N')) or
      (pkmode = 'UPDATE' and nvl(x_enabled_flag, 'Y') not in ('Y', 'N'))) then
      fnd_message.set_name('FND', 'FND-INVALID PRIMARY KEY ATTR');

Line: 2489

  f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);

Line: 2493

    select LAST_UPDATED_BY, LAST_UPDATE_DATE
    into db_luby, db_ludate
    from FND_PRIMARY_KEYS
    where APPLICATION_ID = appl_id
    and TABLE_ID = tab_id
    and PRIMARY_KEY_NAME = x_primary_key_name;

Line: 2500

  if (pkmode = 'UPDATE') then

  if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
                                  db_ludate, X_CUSTOM_MODE)) then
    update FND_PRIMARY_KEYS set
      PRIMARY_KEY_TYPE = x_primary_key_type,
      AUDIT_KEY_FLAG = x_audit_key_flag,
      ENABLED_FLAG = x_enabled_flag,
      DESCRIPTION = x_description,
      LAST_UPDATED_BY = f_luby,
      LAST_UPDATE_DATE = f_ludate,
      LAST_UPDATE_LOGIN = f_luby
    where APPLICATION_ID = appl_id
    and   TABLE_ID = tab_id
    and   PRIMARY_KEY_NAME = x_primary_key_name;

Line: 2520

      delete from FND_PRIMARY_KEY_COLUMNS
       where APPLICATION_ID = appl_id
       and TABLE_ID = tab_id
       and PRIMARY_KEY_ID = pk_id
       and COLUMN_ID < 0;

Line: 2532

     update FND_PRIMARY_KEY_COLUMNS
      set PRIMARY_KEY_SEQUENCE = -1 * PRIMARY_KEY_SEQUENCE,
          COLUMN_ID = -1 * COLUMN_ID
     where APPLICATION_ID = appl_id
     and   TABLE_ID = tab_id
     and   PRIMARY_KEY_ID = pk_id;

Line: 2541

     update FND_PRIMARY_KEY_COLUMNS
      set PRIMARY_KEY_SEQUENCE = -1000
     where APPLICATION_ID = appl_id
     and   TABLE_ID = tab_id
     and   PRIMARY_KEY_ID = pk_id
     and PRIMARY_KEY_SEQUENCE = 0;

Line: 2549

    Fnd_Dictionary_Pkg.InsertPrimaryKey(
        appl_id,
        tab_id,
        x_primary_key_name,
        x_primary_key_type,
        x_audit_key_flag,
        x_enabled_flag,
        x_description,
        f_ludate,
        f_luby,
        f_ludate,
        f_luby,
        0);

Line: 2566

       Fnd_Dictionary_Pkg.InsertPrimaryKey(
        appl_id,
        tab_id,
        x_primary_key_name,
        x_primary_key_type,
        x_audit_key_flag,
        x_enabled_flag,
        x_description,
        f_ludate,
        f_luby,
        f_ludate,
        f_luby,
        0);

Line: 2587

  select max(last_update_date)
    into child_db_ludate
    from fnd_primary_key_columns
    where application_id = appl_id
    and table_id = tab_id
    and primary_key_id = pk_id
    and primary_key_sequence < 0
    and column_id < 0;

Line: 2598

  select max(last_update_date)
    into child_file_ludate
    from fnd_primary_key_columns
    where application_id = appl_id
    and table_id = tab_id
    and primary_key_id = pk_id
    and PRIMARY_KEY_SEQUENCE >= 0
    and column_id > 0;

Line: 2621

       select max(-1)
       into child_db_luby
       from fnd_primary_key_columns
         where application_id = appl_id
         and table_id = tab_id
         and primary_key_id = pk_id
         and PRIMARY_KEY_SEQUENCE < 0
         and column_id < 0
         and last_updated_by not in (0,1,2);

Line: 2636

       select max(-1)
       into child_file_luby
       from fnd_primary_key_columns
	 where application_id = appl_id
         and table_id = tab_id
         and primary_key_id = pk_id
         and PRIMARY_KEY_SEQUENCE > 0
         and column_id > 0
        and last_updated_by not in (0,1,2);

Line: 2657

         delete from fnd_primary_key_columns
    		where application_id = appl_id
    		and table_id = tab_id
    		and primary_key_id = pk_id
            and PRIMARY_KEY_SEQUENCE < 0
            and column_id < 0;

Line: 2670

         delete from fnd_primary_key_columns
	    	where application_id = appl_id
    		and table_id = tab_id
    		and primary_key_id = pk_id
            and PRIMARY_KEY_SEQUENCE >= 0
            and column_id > 0;

Line: 2681

         update FND_PRIMARY_KEY_COLUMNS
             set PRIMARY_KEY_SEQUENCE = -1 * PRIMARY_KEY_SEQUENCE,
                  COLUMN_ID = -1 * COLUMN_ID
    		where APPLICATION_ID = appl_id
    		and   TABLE_ID = tab_id
    		and   PRIMARY_KEY_ID = pk_id;

Line: 2690

         update FND_PRIMARY_KEY_COLUMNS
             set PRIMARY_KEY_SEQUENCE = 0
                where APPLICATION_ID = appl_id
                and   TABLE_ID = tab_id
                and   PRIMARY_KEY_ID = pk_id
                and PRIMARY_KEY_SEQUENCE = 1000;

Line: 2710

         update FND_PRIMARY_KEY_COLUMNS
             set PRIMARY_KEY_SEQUENCE = -1 * PRIMARY_KEY_SEQUENCE,
                  COLUMN_ID = -1 * COLUMN_ID
    		where APPLICATION_ID = appl_id
    		and   TABLE_ID = tab_id
    		and   PRIMARY_KEY_ID = pk_id;

Line: 2719

         update FND_PRIMARY_KEY_COLUMNS
             set PRIMARY_KEY_SEQUENCE = 0
                where APPLICATION_ID = appl_id
                and   TABLE_ID = tab_id
                and   PRIMARY_KEY_ID = pk_id
                and PRIMARY_KEY_SEQUENCE = 1000;

Line: 2745

  x_last_update_date 		   in varchar2
) is
  tab_id number;

Line: 2752

  f_ludate  date;    -- entity update date in file

Line: 2758

  select A.APPLICATION_ID
  into appl_id
  from FND_APPLICATION A
  where A.APPLICATION_SHORT_NAME = x_application_short_name;

Line: 2763

  select T.TABLE_ID into tab_id from FND_TABLES T
  where T.APPLICATION_ID = appl_id
  and T.TABLE_NAME = x_table_name;

Line: 2767

  select P.PRIMARY_KEY_ID into pk_id from FND_PRIMARY_KEYS P
  where P.APPLICATION_ID = appl_id
  and   P.TABLE_ID = tab_id
  and   P.PRIMARY_KEY_NAME = x_primary_key_name;

Line: 2773

    select C.COLUMN_ID into col_id from FND_COLUMNS C
    where C.APPLICATION_ID = appl_id
    and   C.TABLE_ID = tab_id
    and   C.COLUMN_NAME = x_primary_key_column_name;

Line: 2790

  f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);

Line: 2798

     insert into FND_PRIMARY_KEY_COLUMNS(
      APPLICATION_ID,
      TABLE_ID,
      PRIMARY_KEY_ID,
      COLUMN_ID,
      PRIMARY_KEY_SEQUENCE,
      LAST_UPDATED_BY,
      LAST_UPDATE_DATE,
      LAST_UPDATE_LOGIN,
      CREATION_DATE,
      CREATED_BY)
      values (
      appl_id,
      tab_id,
      pk_id,
      col_id,
      x_primary_key_column_sequence,
      f_luby,
      f_ludate,
      f_luby,
      f_ludate,
      f_luby);

Line: 2849

  x_last_update_date 		   in varchar2,
  x_phase_mode			 in varchar2
) is
  tab_id number;

Line: 2858

  f_ludate  date;    -- entity update date in file

Line: 2860

  db_ludate date;    -- entity update date in db

Line: 2863

  child_file_ludate date;   -- child entity update date in file

Line: 2865

  child_db_ludate   date;   -- child update date in db

Line: 2871

  select A.APPLICATION_ID
  into appl_id
  from FND_APPLICATION A
  where A.APPLICATION_SHORT_NAME = x_application_short_name;

Line: 2876

  select T.TABLE_ID into tab_id from FND_TABLES T
  where T.APPLICATION_ID = appl_id
  and T.TABLE_NAME = x_table_name;

Line: 2909

  f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);

Line: 2913

    select FOREIGN_KEY_ID
    into fk_id
    from FND_FOREIGN_KEYS
    where APPLICATION_ID = appl_id
    and TABLE_ID = tab_id
    and FOREIGN_KEY_NAME = x_foreign_key_name;

Line: 2920

    select LAST_UPDATED_BY, LAST_UPDATE_DATE
    into db_luby, db_ludate
    from FND_FOREIGN_KEYS
    where APPLICATION_ID = appl_id
    and TABLE_ID = tab_id
    and FOREIGN_KEY_NAME = x_foreign_key_name;

Line: 2930

  update FND_FOREIGN_KEYS set
      PRIMARY_KEY_APPLICATION_ID = pk_appl_id,
      PRIMARY_KEY_TABLE_ID = pk_tab_id,
      PRIMARY_KEY_ID = pk_id,
      CASCADE_BEHAVIOR = x_cascade_behavior,
      FOREIGN_KEY_RELATION = x_foreign_key_relation,
      DESCRIPTION = x_description,
      CONDITION = x_condition,
      ENABLED_FLAG = x_enabled_flag,
      LAST_UPDATED_BY = f_luby,
      LAST_UPDATE_DATE = f_ludate,
      LAST_UPDATE_LOGIN = f_luby
  where APPLICATION_ID = appl_id
  and   TABLE_ID = tab_id
  and   FOREIGN_KEY_NAME = x_foreign_key_name;

Line: 2951

      delete from FND_FOREIGN_KEY_COLUMNS
       where APPLICATION_ID = appl_id
       and TABLE_ID = tab_id
       and FOREIGN_KEY_ID = fk_id
       and COLUMN_ID < 0;

Line: 2963

     update FND_FOREIGN_KEY_COLUMNS
      set FOREIGN_KEY_SEQUENCE = -1 * FOREIGN_KEY_SEQUENCE,
          COLUMN_ID = -1 * COLUMN_ID
     where APPLICATION_ID = appl_id
     and   TABLE_ID = tab_id
     and   FOREIGN_KEY_ID = fk_id;

Line: 2972

     update FND_FOREIGN_KEY_COLUMNS
      set FOREIGN_KEY_SEQUENCE = -1000
     where APPLICATION_ID = appl_id
     and   TABLE_ID = tab_id
     and   FOREIGN_KEY_ID = fk_id
     and FOREIGN_KEY_SEQUENCE = 0;

Line: 2981

    Fnd_Dictionary_Pkg.InsertForeignKey(
        appl_id,
        tab_id,
        x_foreign_key_name,
        pk_appl_id,
        pk_tab_id,
        pk_id,
        x_description,
        x_cascade_behavior,
        x_foreign_key_relation,
        x_condition,
        x_enabled_flag,
        f_ludate,
        f_luby,
        f_ludate,
        f_luby,
        0);

Line: 3002

    select FOREIGN_KEY_ID
    into fk_id
    from FND_FOREIGN_KEYS
    where APPLICATION_ID = appl_id
    and TABLE_ID = tab_id
    and FOREIGN_KEY_NAME = x_foreign_key_name;

Line: 3013

  select max(last_update_date)
    into child_db_ludate
    from fnd_foreign_key_columns
    where application_id = appl_id
    and table_id = tab_id
    and foreign_key_id = fk_id
    and foreign_key_sequence < 0
    and column_id < 0;

Line: 3024

  select max(last_update_date)
    into child_file_ludate
    from fnd_foreign_key_columns
    where application_id = appl_id
    and table_id = tab_id
    and foreign_key_id = fk_id
    and foreign_key_sequence >= 0
    and column_id > 0;

Line: 3047

       select max(-1)
       into child_db_luby
       from fnd_foreign_key_columns
          where application_id = appl_id
          and table_id = tab_id
          and foreign_key_id = fk_id
          and foreign_key_sequence < 0
          and column_id < 0
         and last_updated_by not in (0,1,2);

Line: 3062

       select max(-1)
       into child_file_luby
       from fnd_foreign_key_columns
         where application_id = appl_id
         and table_id = tab_id
         and foreign_key_id = fk_id
         and foreign_key_sequence > 0
         and column_id > 0
         and last_updated_by not in (0,1,2);

Line: 3083

     delete from fnd_foreign_key_columns
     where application_id = appl_id
     and table_id = tab_id
     and foreign_key_id = fk_id
     and foreign_key_sequence < 0
     and column_id < 0;

Line: 3096

     delete from fnd_foreign_key_columns
     where application_id = appl_id
     and table_id = tab_id
     and foreign_key_id = fk_id
     and foreign_key_sequence >= 0
     and column_id > 0;

Line: 3107

         update FND_FOREIGN_KEY_COLUMNS
             set FOREIGN_KEY_SEQUENCE = -1 * FOREIGN_KEY_SEQUENCE,
                  COLUMN_ID = -1 * COLUMN_ID
    		where APPLICATION_ID = appl_id
    		and   TABLE_ID = tab_id
    		and   FOREIGN_KEY_ID = fk_id;

Line: 3116

         update FND_FOREIGN_KEY_COLUMNS
             set FOREIGN_KEY_SEQUENCE = 0
                where APPLICATION_ID = appl_id
                and   TABLE_ID = tab_id
                and   FOREIGN_KEY_ID = fk_id
                and FOREIGN_KEY_SEQUENCE = 1000;

Line: 3136

         update FND_FOREIGN_KEY_COLUMNS
             set FOREIGN_KEY_SEQUENCE = -1 * FOREIGN_KEY_SEQUENCE,
                  COLUMN_ID = -1 * COLUMN_ID
    		where APPLICATION_ID = appl_id
    		and   TABLE_ID = tab_id
    		and   FOREIGN_KEY_ID = fk_id;

Line: 3145

         update FND_FOREIGN_KEY_COLUMNS
             set FOREIGN_KEY_SEQUENCE = 0
                where APPLICATION_ID = appl_id
                and   TABLE_ID = tab_id
                and   FOREIGN_KEY_ID = fk_id
                and FOREIGN_KEY_SEQUENCE = 1000;

Line: 3171

  x_last_update_date 		   in varchar2
) is
  tab_id number;

Line: 3178

  f_ludate  date;    -- entity update date in file

Line: 3184

  select A.APPLICATION_ID
  into appl_id
  from FND_APPLICATION A
  where A.APPLICATION_SHORT_NAME = x_application_short_name;

Line: 3189

  select T.TABLE_ID into tab_id from FND_TABLES T
  where T.APPLICATION_ID = appl_id
  and T.TABLE_NAME = x_table_name;

Line: 3193

  select F.FOREIGN_KEY_ID into fk_id from FND_FOREIGN_KEYS F
  where F.APPLICATION_ID = appl_id
  and   F.TABLE_ID = tab_id
  and   F.FOREIGN_KEY_NAME = x_foreign_key_name;

Line: 3199

    select C.COLUMN_ID into col_id from FND_COLUMNS C
    where C.APPLICATION_ID = appl_id
    and   C.TABLE_ID = tab_id
    and   C.COLUMN_NAME = x_foreign_key_column_name;

Line: 3216

  f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);

Line: 3225

     insert into FND_FOREIGN_KEY_COLUMNS(
      APPLICATION_ID,
      TABLE_ID,
      FOREIGN_KEY_ID,
      COLUMN_ID,
      FOREIGN_KEY_SEQUENCE,
      CASCADE_VALUE,
      LAST_UPDATED_BY,
      LAST_UPDATE_DATE,
      LAST_UPDATE_LOGIN,
      CREATION_DATE,
      CREATED_BY)
      values (
      appl_id,
      tab_id,
      fk_id,
      col_id,
      x_foreign_key_column_sequence,
      x_cascade_value,
      f_luby,
      f_ludate,
      f_luby,
      f_ludate,
      f_luby);

Line: 3277

  x_last_update_date 		   in varchar2
) is
  appl_id number;

Line: 3281

  f_ludate  date;    -- entity update date in file

Line: 3283

  db_ludate date;    -- entity update date in db

Line: 3287

    select A.APPLICATION_ID
    into appl_id
    from FND_APPLICATION A
    where A.APPLICATION_SHORT_NAME = x_application_short_name;

Line: 3303

  f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);

Line: 3306

    select LAST_UPDATED_BY, LAST_UPDATE_DATE
    into db_luby, db_ludate
    from FND_SEQUENCES
    where APPLICATION_ID = appl_id
    and SEQUENCE_NAME = x_sequence_name;

Line: 3317

  update FND_SEQUENCES set
      START_VALUE = x_start_value,
      DESCRIPTION = x_description,
      INCREMENT_BY = x_increment_by,
      MIN_VALUE = x_min_value,
      MAX_VALUE = x_max_value,
      CACHE_SIZE = x_cache_size,
      CYCLE_FLAG = x_cycle_flag,
      ORDER_FLAG = x_order_flag,
      LAST_UPDATED_BY = f_luby,
      LAST_UPDATE_DATE = f_ludate,
      LAST_UPDATE_LOGIN = f_luby
  where APPLICATION_ID = appl_id
  and   SEQUENCE_NAME = x_sequence_name;

Line: 3334

    Fnd_Dictionary_Pkg.InsertSequence(
        appl_id,
        x_sequence_name,
        x_start_value,
        x_description,
        x_increment_by,
        x_min_value,
        x_max_value,
        x_cache_size,
        x_cycle_flag,
        x_order_flag,
        f_ludate,
        f_luby,
        f_ludate,
        f_luby,
        0);

Line: 3365

  x_last_update_date 		   in varchar2,
  x_phase_mode			 in varchar2
) is
  appl_id number;

Line: 3370

  f_ludate  date;    -- entity update date in file

Line: 3372

  db_ludate date;    -- entity update date in db

Line: 3374

  child_file_ludate date;   -- child entity update date in file

Line: 3376

  child_db_ludate   date;   -- child update date in db

Line: 3384

    select A.APPLICATION_ID
    into appl_id
    from FND_APPLICATION A
    where A.APPLICATION_SHORT_NAME = x_application_short_name;

Line: 3401

  f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);

Line: 3405

    select VIEW_ID
    into vw_id
    from fnd_views
    where application_id = appl_id
    and VIEW_NAME = x_view_name;

Line: 3411

    select LAST_UPDATED_BY, LAST_UPDATE_DATE
    into db_luby, db_ludate
    from FND_VIEWS
    where APPLICATION_ID = appl_id
    and VIEW_NAME = x_view_name;

Line: 3420

       update FND_VIEWS set
         TEXT = x_text,
         DESCRIPTION = x_description,
         LAST_UPDATED_BY = f_luby,
         LAST_UPDATE_DATE = f_ludate,
         LAST_UPDATE_LOGIN = f_luby
      where APPLICATION_ID = appl_id
       and   VIEW_NAME = x_view_name;

Line: 3434

     update FND_VIEW_COLUMNS
      set COLUMN_SEQUENCE = -1 * COLUMN_SEQUENCE,
          COLUMN_NAME = decode(instr(COLUMN_NAME,'_'),0,concat('#',COLUMN_NAME),
                                                 replace(COLUMN_NAME, '_','#'))
     where APPLICATION_ID = appl_id
     and   VIEW_ID = vw_id;

Line: 3443

    Fnd_Dictionary_Pkg.InsertView(
        appl_id,
        x_view_name,
        x_text,
        x_description,
        f_ludate,
        f_luby,
        f_ludate,
        f_luby,
        0);

Line: 3457

    select VIEW_ID
    into vw_id
    from fnd_views
    where application_id = appl_id
    and VIEW_NAME = x_view_name;

Line: 3466

  select max(last_update_date)
    into child_db_ludate
    from fnd_view_columns
    where application_id = appl_id
    and VIEW_ID = vw_id
    and column_sequence < 0;

Line: 3473

  select max(last_update_date)
    into child_file_ludate
    from fnd_view_columns
    where application_id = appl_id
    and VIEW_ID = vw_id
    and column_sequence > 0;

Line: 3494

       select max(-1)
       into child_db_luby
       from fnd_view_columns
         where application_id = appl_id
         and VIEW_ID = vw_id
         and column_sequence < 0
         and last_updated_by not in (0,1,2);

Line: 3507

       select max(-1)
       into child_file_luby
       from fnd_view_columns
          where application_id = appl_id
          and VIEW_ID = vw_id
          and column_sequence > 0
         and last_updated_by not in (0,1,2);

Line: 3526

         delete from fnd_view_columns
         where application_id = appl_id
         and VIEW_ID = vw_id
         and column_sequence < 0;

Line: 3536

         delete from fnd_view_columns
         where application_id = appl_id
         and VIEW_ID = vw_id
         and column_sequence > 0;

Line: 3545

        update FND_VIEW_COLUMNS
        set COLUMN_SEQUENCE = -1 * COLUMN_SEQUENCE,
         COLUMN_NAME = decode(instr(COLUMN_NAME, '#'),1,ltrim(COLUMN_NAME, '#'),
                                                  replace(COLUMN_NAME, '#','_'))
         where APPLICATION_ID = appl_id
    	 and   VIEW_ID = vw_id;

Line: 3565

         update FND_VIEW_COLUMNS
         set COLUMN_SEQUENCE = -1 * COLUMN_SEQUENCE,
         COLUMN_NAME = decode(instr(COLUMN_NAME, '#'),1,ltrim(COLUMN_NAME, '#'),
                                                  replace(COLUMN_NAME, '#','_'))
    	 where APPLICATION_ID = appl_id
    	 and   VIEW_ID = vw_id;

Line: 3588

  x_last_update_date 		   in varchar2
) is
  appl_id number;

Line: 3593

  f_ludate  date;    -- entity update date in file

Line: 3598

  select A.APPLICATION_ID
  into appl_id
  from FND_APPLICATION A
  where A.APPLICATION_SHORT_NAME = x_application_short_name;

Line: 3603

  select V.VIEW_ID into vw_id from FND_VIEWS V
  where V.APPLICATION_ID = appl_id
  and V.VIEW_NAME = x_view_name;

Line: 3611

  f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);

Line: 3619

    insert into FND_VIEW_COLUMNS(
      APPLICATION_ID,
      VIEW_ID,
      COLUMN_SEQUENCE,
      COLUMN_NAME,
      LAST_UPDATED_BY,
      LAST_UPDATE_DATE,
      LAST_UPDATE_LOGIN,
      CREATION_DATE,
      CREATED_BY)
      values (
      appl_id,
      vw_id,
      x_view_column_sequence,
      x_view_column_name,
      f_luby,
      f_ludate,
      f_luby,
      f_ludate,
      f_luby);

Line: 3697

function UpdateOrCheckChildren(x_application_id           in number,
                        x_primary_table_id           in number,
                        x_primary_key_id             in number,
                        x_col_sequences              in NumberArrayTyp,
                        x_primary_key_col_value_old  in NameArrayTyp,
                        x_primary_key_col_value_new  in NameArrayTyp)
return boolean is
  cursor fks is
  select a.application_id, a.application_short_name, ft.table_name,
         ft.table_id, f.foreign_key_id,
         f.foreign_key_name, f.condition
  from   fnd_tables ft, fnd_foreign_keys f, fnd_application a
  where  f.primary_key_application_id = x_application_id
  and    f.primary_key_table_id = x_primary_table_id
  and    f.primary_key_id = x_primary_key_id
  and    ft.table_id = f.table_id
  and    ft.application_id = f.application_id
  and    ft.application_id = a.application_id;

Line: 3717

  select fc.column_name
  from   fnd_columns fc, fnd_foreign_key_columns fcc
  where fcc.foreign_key_id = fkid
  and   fcc.table_id       = fktabid
  and   fcc.application_id = fkapplid
  and   fcc.column_id      = fc.column_id
  and   fcc.table_id       = fc.table_id
  and   fcc.application_id = fc.application_id
  order by fcc.foreign_key_sequence;

Line: 3748

  l_api_name CONSTANT varchar2(30) := 'UpdateChildren';

Line: 3789

      selbuf := 'select ''Y'' from dual where exists (select 1 from '||
                fk.table_name||' where ';

Line: 3802

      updbuf := 'update '||fk.table_name||' set ';

Line: 3890

          fnd_message.set_token('UPDATE_STATEMENT', updbuf);

Line: 3893

                         c_log_head || l_api_name || '.update_failed', FALSE);

Line: 3906

                         c_log_head || l_api_name || '.update_failed', FALSE);

Line: 3923

                      tmpbuf||' or LAST_UPDATED_BY or LAST_UPDATE_DATE' );

Line: 3927

                         c_log_head || l_api_name || '.update_failed', FALSE);

Line: 3935

          fnd_message.set_name('FND', 'FK_DUPLICATE_COLUMN_UPDATE');

Line: 3939

                         c_log_head || l_api_name || '.update_failed', FALSE);

Line: 3945

          fnd_message.set_token('ROUTINE', 'UpdateChildren');

Line: 3950

                         c_log_head || l_api_name || '.update_failed', FALSE);

Line: 3963

        fnd_message.set_name('FND', 'FK_FOUND_NO_DELETE_PK');

Line: 3978

    ret := UpdatePKColumns(fk.application_short_name,
                           fk.table_name,
                           colnames,
                           x_primary_key_col_value_old,
                           x_primary_key_col_value_new);

Line: 4000

end UpdateOrCheckChildren;

Line: 4023

function UpdatePKCols(x_application_short_name     in varchar2,
                      x_primary_table_name         in varchar2,
                      x_primary_key_col_names      in NameArrayTyp,
                      x_primary_key_col_value_old  in NameArrayTyp,
                      x_primary_key_col_value_new  in NameArrayTyp)
return boolean is
appl_id number;

Line: 4036

l_api_name CONSTANT varchar2(30) := 'UpdatePKColumns';

Line: 4041

select c.column_name
from fnd_columns c, fnd_primary_key_columns pc
where pc.application_id = aid
and   pc.table_id = tid
and   pc.primary_key_id = pid
and   pc.column_id = c.column_id
and   c.application_id = aid
and   c.table_id = tid
order by pc.primary_key_sequence;

Line: 4053

select p.primary_key_id, p.primary_key_name
from fnd_primary_keys p
where p.application_id = aid
and   p.table_id = tid;

Line: 4065

  select a.application_id, t.table_id
  into appl_id, tab_id
  from fnd_application a, fnd_tables t
  where a.application_short_name = x_application_short_name
  and   a.application_id = t.application_id
  and   t.table_name = x_primary_table_name;

Line: 4083

      fnd_message.set_token('ROUTINE', 'UpdatePKColumns');

Line: 4147

        hasChild := UpdateOrCheckChildren(appl_id, tab_id, pk.primary_key_id,
            colseqs, x_primary_key_col_value_old, x_primary_key_col_value_new);

Line: 4157

      ret := UpdateOrCheckChildren(appl_id, tab_id, pk.primary_key_id, colseqs,
                      x_primary_key_col_value_old,
                      x_primary_key_col_value_new);

Line: 4182

end UpdatePKCols;

Line: 4202

function UpdatePKColumns(x_application_short_name     in varchar2,
                         x_primary_table_name         in varchar2,
                         x_primary_key_col_names      in NameArrayTyp,
                         x_primary_key_col_value_old  in NameArrayTyp,
                         x_primary_key_col_value_new  in NameArrayTyp)
return boolean is
  ret boolean;

Line: 4210

  ret := UpdatePKCols(x_application_short_name,
                      x_primary_table_name,
                      x_primary_key_col_names,
                      x_primary_key_col_value_old,
                      x_primary_key_col_value_new);

Line: 4222

end UpdatePKColumns;

Line: 4257

  ret := UpdatePKCols(x_application_short_name, x_primary_table_name,
                  x_primary_key_col_names, x_primary_key_col_value_old,
                  nullarray);