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 col.* from user_synonyms syn, dba_ind_columns col where col.table_owner=''AR'' and
364: col.table_name in (''HZ_STAGED_PARTIES'',''HZ_STAGED_PARTY_SITES'',''HZ_STAGED_CONTACTS'',''HZ_STAGED_CONTACT_POINTS'') and
365: col.index_owner = syn.table_owner and col.table_name = syn.synonym_name');
366: DBMS_XMLGEN.setRowTag(qryCtx, 'Bulk Indexes');

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

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