DBA Data[Home] [Help]

APPS.FND_DATADICT_PKG SQL Statements

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

Line: 28

/* Comment these following manual updates cause we have API to do that now */
/*
    update fnd_tables
    set   table_name = p_new_tablename
          , user_table_name = p_new_tablename
    where table_name = p_old_tablename
    and   application_id = p_appl_id;
Line: 38

    update fnd_descriptive_flexs
    set   application_table_name = p_new_tablename
    where application_table_name = p_old_tablename
    and   table_application_id = p_appl_id;
Line: 45

    update fnd_id_flexs
    set   application_table_name = p_new_tablename
    where application_table_name = p_old_tablename
    and   table_application_id = p_appl_id;
Line: 52

    update fnd_doc_sequence_categories
    set   table_name = p_new_tablename
    where table_name = p_old_tablename
    and   application_id = p_appl_id;
Line: 72

  ret := fnd_dictionary_pkg.updatepkcolumns('FND','FND_TABLES',
                                   colnames, pkvalue_old, pkvalue_new);