APPS.AD_LONGTOLOB_PKG dependencies on DBA_TAB_COLUMNS

Line 279: register_table('AHM', 'AHM_DBA_TAB_COLUMNS', 'DATA_DEFAULT', 'LONG', 'DATA_DEFAULT', 'CLOB', G_WITH_DATA );

275: -- g_Counter := 0 ;
276:
277: register_table('AHM', 'AHM_DBA_CONSTRAINTS', 'SEARCH_CONDITION', 'LONG', 'SEARCH_CONDITION', 'CLOB', G_WITH_DATA );
278: register_table('AHM', 'AHM_DBA_IND_EXPRESSIONS', 'COLUMN_EXPRESSION', 'LONG', 'COLUMN_EXPRESSION', 'CLOB', G_WITH_DATA );
279: register_table('AHM', 'AHM_DBA_TAB_COLUMNS', 'DATA_DEFAULT', 'LONG', 'DATA_DEFAULT', 'CLOB', G_WITH_DATA );
280: register_table('ALR', 'ALR_ALERTS', 'SQL_STATEMENT_TEXT', 'LONG', 'SQL_STATEMENT_TEXT', 'CLOB', G_WITH_DATA );
281: register_table('ALR', 'ALR_PROFILE_OPTIONS', 'PROFILE_OPTION_LONG', 'LONG', 'PROFILE_OPTION_LONG', 'CLOB', G_WITH_DATA );
282: register_table('ALR', 'ALR_RESPONSE_MESSAGES', 'BODY', 'LONG', 'BODY', 'CLOB', G_WITH_DATA );
283: register_table('ALR', 'ALR_VALID_RESPONSES', 'RESPONSE_TEXT', 'LONG', 'RESPONSE_TEXT', 'CLOB', G_WITH_DATA );

Line 802: FROM dba_tab_columns a, dba_segments b

798: l_To_DataType_Tbl To_DataType_Tbl_Type;
799:
800: CURSOR c1(p_Table_Name VARCHAR2 ) IS
801: SELECT table_name, column_name, a.owner, data_type, bytes/1024/1024 t_size
802: FROM dba_tab_columns a, dba_segments b
803: WHERE data_type IN ('LONG', 'LONG RAW')
804: AND table_name = p_Table_name
805: AND segment_name = table_name
806: AND a.owner NOT IN ('SYS','SYSTEM','OUTLN')