APPS.HZ_DQM_SEARCH_UTIL dependencies on FND_INSTALLATION

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

662: /*select count(*) into procCheck from sys.all_objects
663: where object_name=trim(upper(P_PROCEDURE_NAME))
664: and (object_type='PROCEDURE' OR object_type='FUNCTION');*/
665:
666: IF (fnd_installation.GET_APP_INFO('AR',l_status,l_temp,l_owner1)) THEN
667: l_sqlstr := ' select count(*) from sys.all_procedures where object_name=trim(upper(:P_PROCEDURE_NAME)) and owner=:2';
668: EXECUTE IMMEDIATE l_sql into procCheck USING P_PROCEDURE_NAME,l_owner1;
669: END IF;
670:

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

704: /*select count(*) into procCheck from sys.all_objects
705: where object_name=trim(upper(P_CUST_PROCEDURE_NAME))
706: and (object_type='PROCEDURE' OR object_type='FUNCTION');*/
707:
708: IF (fnd_installation.GET_APP_INFO('AR',l_status,l_temp,l_owner1)) THEN
709: l_sqlstr := ' select count(*) from sys.all_procedures where object_name=trim(upper(:1)) and owner=:2 ';
710: EXECUTE IMMEDIATE l_sql into procCheck USING P_CUST_PROCEDURE_NAME,l_owner1;
711: END IF;
712: