APPS.HZ_CUST_CLASS_DENORM dependencies on FND_INSTALLATION

Line 98: l_bool := fnd_installation.GET_APP_INFO('AR',l_status,l_tmp,l_index_owner);

94: l_status VARCHAR2(255);
95: l_index_owner VARCHAR2(255);
96: l_tmp VARCHAR2(2000);
97: begin
98: l_bool := fnd_installation.GET_APP_INFO('AR',l_status,l_tmp,l_index_owner);
99: if l_bool then
100: Write_Log(G_DEBUG_CONCURRENT, 1,'Intermedia index being re-built...');
101: EXECUTE IMMEDIATE 'ALTER INDEX ' || l_index_owner ||'.hz_class_code_denorm_t1 REBUILD online parameters (''sync'')';
102: Write_Log(G_DEBUG_CONCURRENT, 1,'Intermedia index rebuilt on column concat_class_code_meaning for table HZ_CLASS_CODE_DENORM.');

Line 653: l_bool := fnd_installation.GET_APP_INFO('AR',l_status_owner,l_tmp,l_table_owner);

649: if p_class_category is null
650: then
651: -- full refresh
652: -- Code added for Bug 3735880 starts here
653: l_bool := fnd_installation.GET_APP_INFO('AR',l_status_owner,l_tmp,l_table_owner);
654: if l_bool then
655: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_table_owner||'.HZ_CLASS_CODE_DENORM REUSE STORAGE';
656: end if;
657: -- Code added for Bug 3735880 ends here