APPS.ENI_DENORM_HRCHY dependencies on ENI_ICAT_CDENORM_HIERARCHIES

Line 1823: -- [ENI_ICAT_CDENORM_HIERARCHIES]. It is designed to support SBA/OBIEE requirements.

1819: END IF;
1820: END split_category_codes;
1821:
1822: -- This Procedure Denormalizes the Product Catalog Hierarchy into a separate denorm table
1823: -- [ENI_ICAT_CDENORM_HIERARCHIES]. It is designed to support SBA/OBIEE requirements.
1824: -- The program is designed to flatten the hierarchy for levels raning between 5 and 10.
1825: -- The number of levels to denormalize is dynamic and is governed by a profile value.
1826: -- Currently it only supports FULL REFRESH.
1827: PROCEDURE LOAD_OBIEE_HIERARCHY(errbuf OUT NOCOPY VARCHAR2, retcode OUT NOCOPY VARCHAR2) IS

Line 1871: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_tab_schema || '.ENI_ICAT_CDENORM_HIERARCHIES';

1867:
1868: --Truncate the table first [INITIAL LOAD]
1869: FND_FILE.PUT_LINE(FND_FILE.LOG,'Truncating the DENORM table');
1870:
1871: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_tab_schema || '.ENI_ICAT_CDENORM_HIERARCHIES';
1872:
1873: --Fetch the profile value for No of levels to flatten
1874: fnd_profile.get('ENI_ICAT_DENORM_LEVEL', l_levels_to_flatten);
1875:

Line 1887: 'INSERT INTO eni_icat_cdenorm_hierarchies ( ' ||

1883: FND_FILE.PUT_LINE(FND_FILE.LOG,'Denormalizing catalog [' || l_product_catalog || '] to ' || l_levels_to_flatten || ' levels.');
1884: FND_FILE.PUT_LINE(FND_FILE.LOG,'Denormalization is Row + Column flattening');
1885:
1886: l_sql :=
1887: 'INSERT INTO eni_icat_cdenorm_hierarchies ( ' ||
1888: ' category_id_level1 ' ||
1889: ' ,category_id_level2 ' ||
1890: ' ,category_id_level3 ' ||
1891: ' ,category_id_level4 ' ||

Line 1966: INSERT INTO eni_icat_cdenorm_hierarchies (

1962: END IF;
1963:
1964: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Insert the UNASSIGNED product category row.');
1965:
1966: INSERT INTO eni_icat_cdenorm_hierarchies (
1967: category_id_level1
1968: ,category_id_level2
1969: ,category_id_level3
1970: ,category_id_level4

Line 2001: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Gathering statistics on table: ENI_ICAT_CDENORM_HIERARCHIES ');

1997: ,SYSDATE
1998: ,l_conc_program_id
1999: );
2000:
2001: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Gathering statistics on table: ENI_ICAT_CDENORM_HIERARCHIES ');
2002: FND_STATS.gather_table_stats (ownname=>g_tab_schema, tabname=>'ENI_ICAT_CDENORM_HIERARCHIES');
2003:
2004: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Denorm table Initial Load completed successfully');
2005:

Line 2002: FND_STATS.gather_table_stats (ownname=>g_tab_schema, tabname=>'ENI_ICAT_CDENORM_HIERARCHIES');

1998: ,l_conc_program_id
1999: );
2000:
2001: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Gathering statistics on table: ENI_ICAT_CDENORM_HIERARCHIES ');
2002: FND_STATS.gather_table_stats (ownname=>g_tab_schema, tabname=>'ENI_ICAT_CDENORM_HIERARCHIES');
2003:
2004: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Denorm table Initial Load completed successfully');
2005:
2006: COMMIT;