APPS.ENI_DENORM_HRCHY dependencies on ENI_ICAT_CDENORM_HIERARCHIES

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

1848: END IF;
1849: END split_category_codes;
1850:
1851: -- This Procedure Denormalizes the Product Catalog Hierarchy into a separate denorm table
1852: -- [ENI_ICAT_CDENORM_HIERARCHIES]. It is designed to support SBA/OBIEE requirements.
1853: -- The program is designed to flatten the hierarchy for levels raning between 5 and 10.
1854: -- The number of levels to denormalize is dynamic and is governed by a profile value.
1855: -- Currently it only supports FULL REFRESH.
1856: PROCEDURE LOAD_OBIEE_HIERARCHY(errbuf OUT NOCOPY VARCHAR2, retcode OUT NOCOPY VARCHAR2) IS

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

1896:
1897: --Truncate the table first [INITIAL LOAD]
1898: FND_FILE.PUT_LINE(FND_FILE.LOG,'Truncating the DENORM table');
1899:
1900: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_tab_schema || '.ENI_ICAT_CDENORM_HIERARCHIES';
1901:
1902: --Fetch the profile value for No of levels to flatten
1903: fnd_profile.get('ENI_ICAT_DENORM_LEVEL', l_levels_to_flatten);
1904:

Line 1916: 'INSERT INTO eni_icat_cdenorm_hierarchies ( ' ||

1912: FND_FILE.PUT_LINE(FND_FILE.LOG,'Denormalizing catalog [' || l_product_catalog || '] to ' || l_levels_to_flatten || ' levels.');
1913: FND_FILE.PUT_LINE(FND_FILE.LOG,'Denormalization is Row + Column flattening');
1914:
1915: l_sql :=
1916: 'INSERT INTO eni_icat_cdenorm_hierarchies ( ' ||
1917: ' category_id_level1 ' ||
1918: ' ,category_id_level2 ' ||
1919: ' ,category_id_level3 ' ||
1920: ' ,category_id_level4 ' ||

Line 1995: INSERT INTO eni_icat_cdenorm_hierarchies (

1991: END IF;
1992:
1993: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Insert the UNASSIGNED product category row.');
1994:
1995: INSERT INTO eni_icat_cdenorm_hierarchies (
1996: category_id_level1
1997: ,category_id_level2
1998: ,category_id_level3
1999: ,category_id_level4

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

2026: ,SYSDATE
2027: ,l_conc_program_id
2028: );
2029:
2030: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Gathering statistics on table: ENI_ICAT_CDENORM_HIERARCHIES ');
2031: FND_STATS.gather_table_stats (ownname=>g_tab_schema, tabname=>'ENI_ICAT_CDENORM_HIERARCHIES');
2032:
2033: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Denorm table Initial Load completed successfully');
2034:

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

2027: ,l_conc_program_id
2028: );
2029:
2030: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Gathering statistics on table: ENI_ICAT_CDENORM_HIERARCHIES ');
2031: FND_STATS.gather_table_stats (ownname=>g_tab_schema, tabname=>'ENI_ICAT_CDENORM_HIERARCHIES');
2032:
2033: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Denorm table Initial Load completed successfully');
2034:
2035: COMMIT;