APPS.HZ_DQM_DIAGNOSTICS_XML dependencies on FND_INSTALLATION

Line 362: if(fnd_installation.GET_APP_INFO('AR',l_status,l_temp,l_owner)) then

358: dbms_lob.copy(result,l_result,dbms_lob.getlength(l_result)-l_resultOffset,
359: l_result_length,l_resultOffset);
360: END IF;
361:
362: if(fnd_installation.GET_APP_INFO('AR',l_status,l_temp,l_owner)) then
363: qryCtx := dbms_xmlgen.newContext('select * from sys.dba_ind_columns where table_owner=''AR'' and table_name in(''HZ_STAGED_PARTIES'',''HZ_STAGED_PARTY_SITES'',''HZ_STAGED_CONTACTS'',''HZ_STAGED_CONTACT_POINTS'') ');
364: DBMS_XMLGEN.setRowTag(qryCtx, 'Bulk Indexes');
365: l_result := DBMS_XMLGEN.getXML(qryCtx);
366: l_rows_processed := DBMS_XMLGEN.getNumRowsProcessed(qryCtx);

Line 609: IF (fnd_installation.GET_APP_INFO('AR',l_status,l_temp,l_owner1)) THEN

605: l_db_block_size NUMBER;
606: l_number_of_blocks NUMBER;
607:
608: BEGIN
609: IF (fnd_installation.GET_APP_INFO('AR',l_status,l_temp,l_owner1)) THEN
610: OPEN c_number_of_blocks(p_table_name,l_owner1);
611: FETCH c_number_of_blocks into l_number_of_blocks;
612: CLOSE c_number_of_blocks;
613: OPEN c_db_block_size;