APPS.MSD_DEM_DEMANTRA_UTILITIES dependencies on STANDARD

Line 1685: /* Start with dropping the standard error columns in the ERR table */

1681:
1682: IF (x_count1 = 0)
1683: THEN
1684:
1685: /* Start with dropping the standard error columns in the ERR table */
1686: x_sql := 'ALTER TABLE ' || x_dem_schema || '.T_SRC_SALES_TMPL_ERR '
1687: || ' DROP (ERROR_CODE_RECORD, LOAD_DATE, ERROR_MESSAGE_RECORD) ';
1688: EXECUTE IMMEDIATE x_sql;
1689: log_message ('Dropping columns ERROR_CODE_RECORD, LOAD_DATE and ERROR_MESSAGE_RECORD from Demantra table T_SRC_SALES_TMPL_ERR');

Line 1761: /* Add back the standard error columns in the ERR table */

1757: log_message ('Adding column EBS_BASE_MODEL_CODE to T_SRC_SALES_TMPL_ERR');
1758:
1759: END IF;
1760:
1761: /* Add back the standard error columns in the ERR table */
1762: x_sql := 'ALTER TABLE ' || x_dem_schema || '.T_SRC_SALES_TMPL_ERR '
1763: || ' ADD (ERROR_CODE_RECORD NUMBER(2), LOAD_DATE DATE, ERROR_MESSAGE_RECORD VARCHAR2(2000)) ';
1764: EXECUTE IMMEDIATE x_sql;
1765: log_message ('Adding columns ERROR_CODE_RECORD, LOAD_DATE and ERROR_MESSAGE_RECORD to Demantra table T_SRC_SALES_TMPL_ERR');

Line 1847: /* Dropping the standard error columns in the ERR table */

1843: EXECUTE IMMEDIATE 'ALTER TABLE ' || x_dem_schema || '.T_SRC_LOC_TMPL '
1844: || ' ADD (T_EP_LR2A_DESC VARCHAR2(100)) ';
1845: log_message ('Adding column T_EP_LR2A_DESC to T_SRC_LOC_TMPL');
1846:
1847: /* Dropping the standard error columns in the ERR table */
1848: x_sql := 'ALTER TABLE ' || x_dem_schema || '.T_SRC_LOC_TMPL_ERR '
1849: || ' DROP (ERROR_CODE_RECORD, LOAD_DATE, ERROR_MESSAGE_RECORD) ';
1850: EXECUTE IMMEDIATE x_sql;
1851: log_message ('Dropping columns ERROR_CODE_RECORD, LOAD_DATE and ERROR_MESSAGE_RECORD from Demantra table T_SRC_LOC_TMPL_ERR');

Line 1858: /* Add back the standard error columns in the ERR table */

1854: EXECUTE IMMEDIATE 'ALTER TABLE ' || x_dem_schema || '.T_SRC_LOC_TMPL_ERR '
1855: || ' ADD (T_EP_LR2A_DESC VARCHAR2(100)) ';
1856: log_message ('Adding column T_EP_LR2A_DESC to T_SRC_LOC_TMPL_ERR');
1857:
1858: /* Add back the standard error columns in the ERR table */
1859: x_sql := 'ALTER TABLE ' || x_dem_schema || '.T_SRC_LOC_TMPL_ERR '
1860: || ' ADD (ERROR_CODE_RECORD NUMBER(2), LOAD_DATE DATE, ERROR_MESSAGE_RECORD VARCHAR2(2000)) ';
1861: EXECUTE IMMEDIATE x_sql;
1862: log_message ('Adding columns ERROR_CODE_RECORD, LOAD_DATE and ERROR_MESSAGE_RECORD to Demantra table T_SRC_LOC_TMPL_ERR');