APPS.MSD_DEM_DEMANTRA_UTILITIES dependencies on DBA_TAB_COLUMNS

Line 1390: FROM dba_tab_columns

1386: p_column_name VARCHAR2,
1387: p_data_type VARCHAR2)
1388: IS
1389: SELECT count(1)
1390: FROM dba_tab_columns
1391: WHERE owner = p_owner
1392: AND table_name = p_table_name
1393: AND column_name = p_column_name
1394: AND data_type = p_data_type;

Line 1784: x_sql := 'SELECT COUNT(1) FROM ( SELECT COLUMN_NAME FROM DBA_TAB_COLUMNS WHERE owner = ''' || x_dem_schema || ''' and table_name = ''T_SRC_SALES_TMPL'' '

1780: IF (x_count3 = 1)
1781: THEN
1782: log_message ('Check, drop and recreate the table EP_T_SRC_SALES_TMPL_LD - ');
1783: x_count2 := -1;
1784: x_sql := 'SELECT COUNT(1) FROM ( SELECT COLUMN_NAME FROM DBA_TAB_COLUMNS WHERE owner = ''' || x_dem_schema || ''' and table_name = ''T_SRC_SALES_TMPL'' '
1785: || ' MINUS '
1786: || ' SELECT COLUMN_NAME FROM DBA_TAB_COLUMNS WHERE owner = ''' || x_dem_schema || ''' and table_name = ''EP_T_SRC_SALES_TMPL_LD'' ) ';
1787: log_debug (x_sql);
1788: EXECUTE IMMEDIATE x_sql INTO x_count2;

Line 1786: || ' SELECT COLUMN_NAME FROM DBA_TAB_COLUMNS WHERE owner = ''' || x_dem_schema || ''' and table_name = ''EP_T_SRC_SALES_TMPL_LD'' ) ';

1782: log_message ('Check, drop and recreate the table EP_T_SRC_SALES_TMPL_LD - ');
1783: x_count2 := -1;
1784: x_sql := 'SELECT COUNT(1) FROM ( SELECT COLUMN_NAME FROM DBA_TAB_COLUMNS WHERE owner = ''' || x_dem_schema || ''' and table_name = ''T_SRC_SALES_TMPL'' '
1785: || ' MINUS '
1786: || ' SELECT COLUMN_NAME FROM DBA_TAB_COLUMNS WHERE owner = ''' || x_dem_schema || ''' and table_name = ''EP_T_SRC_SALES_TMPL_LD'' ) ';
1787: log_debug (x_sql);
1788: EXECUTE IMMEDIATE x_sql INTO x_count2;
1789:
1790: IF (x_count2 <> 0)