APPS.MSD_DEM_COMMON_UTILITIES dependencies on DBA_TAB_COLUMNS

Line 411: FROM dba_tab_columns

407: p_column_name VARCHAR2,
408: p_data_type VARCHAR2)
409: IS
410: SELECT count(1)
411: FROM dba_tab_columns
412: WHERE owner = p_owner
413: AND table_name = p_table_name
414: AND column_name = p_column_name
415: AND data_type = p_data_type;

Line 804: 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'' '

800: IF (x_count3 = 1)
801: THEN
802: log_message ('Check, drop and recreate the table EP_T_SRC_SALES_TMPL_LD - ');
803: x_count2 := -1;
804: 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'' '
805: || ' MINUS '
806: || ' SELECT COLUMN_NAME FROM DBA_TAB_COLUMNS WHERE owner = ''' || x_dem_schema || ''' and table_name = ''EP_T_SRC_SALES_TMPL_LD'' ) ';
807: log_debug (x_sql);
808: EXECUTE IMMEDIATE x_sql INTO x_count2;

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

802: log_message ('Check, drop and recreate the table EP_T_SRC_SALES_TMPL_LD - ');
803: x_count2 := -1;
804: 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'' '
805: || ' MINUS '
806: || ' SELECT COLUMN_NAME FROM DBA_TAB_COLUMNS WHERE owner = ''' || x_dem_schema || ''' and table_name = ''EP_T_SRC_SALES_TMPL_LD'' ) ';
807: log_debug (x_sql);
808: EXECUTE IMMEDIATE x_sql INTO x_count2;
809:
810: IF (x_count2 <> 0)

Line 1984: FROM dba_tab_columns

1980:
1981: -- bug#14694463 nallkuma
1982: SELECT nvl(count(1),0)
1983: INTO x_col_ep_id_present
1984: FROM dba_tab_columns
1985: WHERE owner = upper(C_MSD_DEM_SCHEMA)
1986: AND table_name = upper(p_lookup_table_name)
1987: and column_name = upper(p_lookup_table_name)|| '_EP_ID' ;
1988:

Line 1991: FROM dba_tab_columns

1987: and column_name = upper(p_lookup_table_name)|| '_EP_ID' ;
1988:
1989: SELECT nvl(count(1),0)
1990: INTO x_col_id_present
1991: FROM dba_tab_columns
1992: WHERE owner = upper(C_MSD_DEM_SCHEMA)
1993: AND table_name = upper(p_lookup_table_name)
1994: and column_name = upper(p_lookup_table_name)|| '_ID' ;
1995: