292:
293: /* ACHANDA : Bug # 3511203 : get apps schema and use it to get the data type from all_tab_columns */
294: SELECT oracle_username
295: INTO l_apps_schema_name
296: FROM fnd_oracle_userid
297: WHERE read_only_flag = 'U';
298:
299: -- get the column datatype
300: OPEN c_column_datatype (p_column_name, p_table_name, l_apps_schema_name);
476:
477: /* ACHANDA : Bug # 3511203 : get apps schema and use it to get the data type from all_tab_columns */
478: SELECT oracle_username
479: INTO l_apps_schema_name
480: FROM fnd_oracle_userid
481: WHERE read_only_flag = 'U';
482:
483: /* check if table exists */
484: OPEN c_chk_table_exists (p_table_name, l_apps_schema_name);