APPS.HZ_IMP_DQM_STAGE dependencies on FND_INSTALLATION

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

494: l_status VARCHAR2(255);
495: l_owner1 VARCHAR2(255);
496: l_temp VARCHAR2(255);
497: BEGIN
498: IF (fnd_installation.GET_APP_INFO('AR',l_status,l_temp,l_owner1)) THEN
499: select owner into l_owner from sys.all_objects
500: where object_name = p_object_name and OBJECT_TYPE = p_object_type and owner = l_owner1;
501: END IF;
502: RETURN l_owner;

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

578:
579: IF (l_b = 'Y') THEN
580: IF ((l_a = 'Y') AND (l_c = l_d) ) THEN
581: IF (l_e = 'Y') THEN
582: IF (fnd_installation.GET_APP_INFO('AR',l_status,l_temp,l_owner1)) THEN
583: /*select owner into l_owner from sys.all_objects
584: where object_name = 'HZ_SRCH_PSITES' and OBJECT_TYPE = 'TABLE' and owner = l_owner1 ;*/
585: --Bug:4956084
586: l_sqlstr := 'select owner from sys.all_tables

Line 3640: IF (fnd_installation.GET_APP_INFO('AR',l_status,l_temp,l_owner)) THEN

3636: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3637: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');
3638: END IF;
3639: l_attribute_name := p_attribute_name || '_STD';
3640: IF (fnd_installation.GET_APP_INFO('AR',l_status,l_temp,l_owner)) THEN
3641: OPEN c1;
3642: FETCH c1 INTO l_bool;
3643: IF c1%NOTFOUND THEN
3644: l_attribute_name := ' a.' || p_attribute_name;