[Home] [Help]
383:
384: SELECT
385: fn.host node_name ,
386: aat.appl_top_id appl_top_id ,
387: EXTRACTVALUE(XMLType(TEXT),'//shared_file_system') is_shared
388: FROM
389: fnd_nodes fn,
390: FND_OAM_CONTEXT_FILES focf,
391: fnd_product_groups fpg,
392: ad_appl_tops aat,
393: ad_releases ar
394: WHERE focf.NAME not in ('TEMPLATE','METADATA','config.txt') and focf.CTX_TYPE='A' and
395: (focf.status is null or upper(focf.status) in ('S','F')) and
396: EXTRACTVALUE(XMLType(focf.TEXT),'//file_edition_type') = 'run' and
397: focf.node_name=fn.host and
398: (fn.support_cp='Y' or fn.support_forms='Y' or
399: fn.support_web='Y' or fn.support_admin='Y') and
400: aat.appl_top_type='R' and aat.applications_system_name=fpg.applications_system_name and
400: aat.appl_top_type='R' and aat.applications_system_name=fpg.applications_system_name and
401: aat.active_flag='Y' and
402: fpg.release_name=ar.major_version||'.'||ar.minor_version||'.'||ar.tape_version and
403: fpg.aru_release_name=ar.aru_release_name and
404: aat.name=EXTRACTVALUE(XMLType(focf.TEXT),'//APPL_TOP_NAME');
405:
406: BEGIN
407: log(l_mod_name,'STATEMENT','START -->');
408:
1333: ad_releases ar
1334: WHERE focf.NAME not in ('TEMPLATE','METADATA','config.txt')
1335: and focf.CTX_TYPE='A'
1336: and (focf.status is null or upper(focf.status) in ('S','F'))
1337: and EXTRACTVALUE(XMLType(focf.TEXT),'//file_edition_type') = 'run'
1338: and focf.node_name=node.host
1339: and aat.appl_top_type='R'
1340: and aat.applications_system_name=fpg.applications_system_name
1341: and aat.active_flag='Y'
1342: and fpg.release_name=ar.major_version||'.'||
1343: ar.minor_version||'.'||
1344: ar.tape_version
1345: and fpg.aru_release_name=ar.aru_release_name
1346: and aat.name=EXTRACTVALUE(XMLType(focf.TEXT),'//APPL_TOP_NAME');
1347:
1348: select count(1) into l_clone_exists
1349: from ad_adop_session_patches
1350: where APPLTOP_ID=l_appl_top_id and node_name=node.host
1400: (XMLQuery(
1401: ' for $i in /oa_context/oa_services/oa_service_list/oa_service/oa_service_status
1402: where $i/text() eq "enabled"
1403: return fn:concat($i/@oa_var,",") '
1404: PASSING XMLType(TEXT) RETURNING CONTENT
1405: )).getStringVal() services, node_name node
1406: from FND_OAM_CONTEXT_FILES
1407: where NAME not in ('TEMPLATE','METADATA','config.txt') and
1408: CTX_TYPE='A' and (status is null or upper(status) in ('S','F'))
1405: )).getStringVal() services, node_name node
1406: from FND_OAM_CONTEXT_FILES
1407: where NAME not in ('TEMPLATE','METADATA','config.txt') and
1408: CTX_TYPE='A' and (status is null or upper(status) in ('S','F'))
1409: and EXTRACTVALUE(XMLType(TEXT),'//file_edition_type') = 'patch';
1410:
1411:
1412: cursor group_service_status is
1413: select
1414: (XMLQuery(
1415: ' for $i in /oa_context/oa_services/oa_service_group_list/oa_service_group/oa_service_group_status
1416: where $i/text() eq "enabled"
1417: return fn:concat($i/@oa_var,",") '
1418: PASSING XMLType(TEXT) RETURNING CONTENT
1419: )).getStringVal() group_services, node_name node
1420: from FND_OAM_CONTEXT_FILES
1421: where NAME not in ('TEMPLATE','METADATA','config.txt') and
1422: CTX_TYPE='A' and (status is null or upper(status) in ('S','F'))
1419: )).getStringVal() group_services, node_name node
1420: from FND_OAM_CONTEXT_FILES
1421: where NAME not in ('TEMPLATE','METADATA','config.txt') and
1422: CTX_TYPE='A' and (status is null or upper(status) in ('S','F'))
1423: and EXTRACTVALUE(XMLType(TEXT),'//file_edition_type')= 'patch';
1424:
1425:
1426: BEGIN
1427: