eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AZ_R12_TRANSFORM_CASCADE dependencies on AZ_REQUESTS

Line 95: FROM az_requests d,TABLE(XMLSequence(extract(d.selection_set,'/EXT/H/V[@N="EntityOccuranceCode" and .="'||p_dependant_eo_code||'"]/..'))) e

91: extractValue(value(e),'/H/V[@N="EntityOccuranceCode"]/text()') code,
92: extractValue(value(e),'/H/V[@N="RefEntityOccuranceCode"]/text()') ref,
93: extractValue(value(e),'/H/S/text()') source,
94: to_number(extractValue(value(e),'/H/V[@N="SeqNum"]/text()')) seq_num
95: FROM az_requests d,TABLE(XMLSequence(extract(d.selection_set,'/EXT/H/V[@N="EntityOccuranceCode" and .="'||p_dependant_eo_code||'"]/..'))) e
96: where d.request_id=p_request_id AND d.request_type='T'
97: union all
98: select extractValue(value(e),'/H/V[@N="EntityOccuranceName"]/text()') name,
99: extractValue(value(e),'/H/V[@N="EntityOccuranceCode"]/text()') code,

Line 103: FROM az_requests d,TABLE(XMLSequence(extract(d.selection_set,'/EXT/H[@A3="Y"]/V[@N="EntityOccuranceName" or @N="EntityOccuranceCode" or @N="RefEntityOccuranceCode"]/..'))) e

99: extractValue(value(e),'/H/V[@N="EntityOccuranceCode"]/text()') code,
100: extractValue(value(e),'/H/V[@N="RefEntityOccuranceCode"]/text()') ref,
101: extractValue(value(e),'/H/S/text()') source,
102: to_number(extractValue(value(e),'/H/V[@N="SeqNum"]/text()')) seq_num
103: FROM az_requests d,TABLE(XMLSequence(extract(d.selection_set,'/EXT/H[@A3="Y"]/V[@N="EntityOccuranceName" or @N="EntityOccuranceCode" or @N="RefEntityOccuranceCode"]/..'))) e
104: where d.request_id=p_request_id AND d.request_type='T' ) f
105: start with f.code=p_dependant_eo_code
106: connect by prior f.code=f.ref
107: order siblings by f.seq_num;

Line 593: -- LMATHUR -> Now Update the AZ_REQUESTS selection_set XML to ensure that the conflicted attributes are open for editing

589: THEN
590: -- LMATHUR -> update T=1 for all the attributes which can be marked as conflicting so that they can be edited from the UI
591:
592: --Redundancy removal
593: -- LMATHUR -> Now Update the AZ_REQUESTS selection_set XML to ensure that the conflicted attributes are open for editing
594: -- select count(1) into V_CONFLICT_PARAM3_COUNT from az_diff_results d where d.param3 = 'Y' and
595: -- d.request_id = P_REQUEST_ID
596: -- and d.source=p_dependant_source;
597: --

Line 601: -- EXECUTE IMMEDIATE 'UPDATE az_requests d

597: --
598: -- IF V_CONFLICT_PARAM3_COUNT > 0
599: -- THEN
600: -- --LMATHUR - To show conflict icon in the VIEW mode, we need an indicator for conflicts- A5=C indicate conflicts
601: -- EXECUTE IMMEDIATE 'UPDATE az_requests d
602: -- SET d.selection_set = updatexml(d.selection_set, ''/EXT/H[S="'||p_dependant_source||'"]/@A5'',''C'')
603: -- WHERE d.request_id = '||P_REQUEST_ID||
604: -- ' AND d.request_type = ''T''';
605: --

Line 642: FROM AZ_REQUESTS D,

638: BEGIN
639:
640: SELECT EXTRACTVALUE(VALUE(E), '/H/@A2')
641: INTO V_AUTO_SELECTED
642: FROM AZ_REQUESTS D,
643: TABLE(XMLSEQUENCE(EXTRACT(D.SELECTION_SET,
644: '/EXT/H/V[@N="EntityOccuranceCode" and .="' || P_DEPENDANT_eo_code || '"]/..'))) E
645: WHERE D.REQUEST_ID = P_REQUEST_ID
646: AND D.REQUEST_TYPE = 'T';

Line 658: UPDATE AZ_REQUESTS D

654: AND is_transformed='Y';
655:
656: IF v_count>0 THEN
657:
658: UPDATE AZ_REQUESTS D
659: SET D.SELECTION_SET = UPDATEXML(D.SELECTION_SET,
660: '/EXT/H[S="'||P_DEPENDANT_SOURCE||'"]/T/text()',v_count)
661: WHERE D.REQUEST_ID = P_REQUEST_ID
662: AND d.REQUEST_TYPE = 'T';

Line 669: UPDATE AZ_REQUESTS D

665:
666: IF V_AUTO_SELECTED = 'Y' AND v_count>0 THEN
667:
668:
669: UPDATE AZ_REQUESTS D
670: SET D.SELECTION_SET = UPDATEXML(D.SELECTION_SET,
671: '/EXT/H/V[@N="EntityOccuranceCode" and .="' || P_DEPENDANT_eo_code || '"]/../@A4', 'Y')
672: WHERE D.REQUEST_ID = P_REQUEST_ID
673: AND D.REQUEST_TYPE = 'T';

Line 679: FROM AZ_REQUESTS D,

675: ELSIF V_AUTO_SELECTED <> 'Y' AND v_count>0 THEN
676: SELECT EXTRACTVALUE(VALUE(E), '/H/V[@N="EntityOccuranceCode"]/text()'),
677: EXTRACTVALUE(VALUE(E), '/H/V[@N="RefEntityOccuranceCode"]/text()')
678: INTO V_EO_CODE, V_REF_EO_CODE
679: FROM AZ_REQUESTS D,
680: TABLE(XMLSEQUENCE(EXTRACT(D.SELECTION_SET,
681: '/EXT/H/V[@N="EntityOccuranceCode" and .="' || P_DEPENDANT_eo_code || '"]/..'))) E
682: WHERE D.REQUEST_ID = P_REQUEST_ID
683: AND D.REQUEST_TYPE = 'T';

Line 693: FROM AZ_REQUESTS D,

689: EXTRACTVALUE(VALUE(E),
690: '/H/V[@N="RefEntityOccuranceCode"]/text()'),
691: EXTRACTVALUE(VALUE(E), '/H/@A2')
692: INTO V_EO_CODE, V_REF_EO_CODE, V_AUTO_SELECTED
693: FROM AZ_REQUESTS D,
694: TABLE(XMLSEQUENCE(EXTRACT(D.SELECTION_SET,
695: '/EXT/H/V[@N="EntityOccuranceCode" and .="' ||
696: V_REF_EO_CODE || '"]/..'))) E
697: WHERE D.REQUEST_ID = P_REQUEST_ID

Line 704: UPDATE AZ_REQUESTS D

700:
701: IF V_AUTO_SELECTED = 'Y' THEN
702:
703:
704: UPDATE AZ_REQUESTS D
705: SET D.SELECTION_SET = UPDATEXML(D.SELECTION_SET,
706: '/EXT/H/V[@N="EntityOccuranceCode" and .="' ||
707: V_EO_CODE || '"]/../@A4',
708: 'Y')

Line 847: FROM az_requests d,

843: '/H/V[@N="EntityCode"]/text()') entity_code,
844: extractvalue(VALUE(e),'/H/S/text()') SOURCE,
845: nvl(extractvalue(VALUE(e),'/H/@A3'),'N') split_flag
846:
847: FROM az_requests d,
848: TABLE(xmlsequence(extract(d.selection_set,
849: '/EXT/H'))) e
850: WHERE existsnode(VALUE(e),
851: '/H/V[@N="EntityOccuranceName" or @N="EntityOccuranceCode" or @N="RefEntityOccuranceCode"]') = 1

Line 868: FROM az_requests d,

864: '/V/@N'),
865: extract(VALUE(e),
866: '/V/text()').getstringval() BULK COLLECT
867: INTO v_attribute_name_list, v_attribute_value_list
868: FROM az_requests d,
869: TABLE(xmlsequence(extract(d.selection_set,
870: '/EXT/H/S[.="' || p_source ||
871: '"]/../V[@T="1"]'))) e
872: WHERE job_name = p_job_name

Line 965: FROM az_requests d,

961: END LOOP;
962: ELSE
963: SELECT f.api_code
964: INTO v_parent_api_code
965: FROM az_requests d,
966: TABLE(xmlsequence(extract(d.selection_set,
967: '/EXT/H'))) e,
968: az_structure_apis_b f
969: WHERE existsnode(VALUE(e),

Line 993: FROM az_requests d,

989: else
990:
991: SELECT f.api_code
992: INTO v_current_api_code
993: FROM az_requests d,
994: TABLE(xmlsequence(extract(d.selection_set,
995: '/EXT/H'))) e,
996: az_structure_apis_b f
997: WHERE existsnode(VALUE(e),

Line 1410: -- EXECUTE IMMEDIATE 'UPDATE az_requests d

1406: --
1407: -- IF V_CONFLICT_PARAM3_COUNT > 0
1408: -- THEN
1409: -- --LMATHUR - To show conflict icon in the VIEW mode, we need an indicator for conflicts- A5=C indicate conflicts
1410: -- EXECUTE IMMEDIATE 'UPDATE az_requests d
1411: -- SET d.selection_set = updatexml(d.selection_set, ''/EXT/H[S="'||p_source||'"]/@A5'',''C'')
1412: -- WHERE d.request_id = '||P_REQUEST_ID||
1413: -- ' AND d.request_type = ''T''';
1414: -- END IF;

Line 1497: EXECUTE IMMEDIATE 'UPDATE az_requests g

1493: -- Now check if all the conflicts are resolved for this source
1494: select count(1) into v_count from az_diff_results e where request_id= p_request_id
1495: and source = p_source and existsnode(e.attr_diff,'/H/V[@A1="Y" and (./A/text()=./B/text())]') = 1;
1496:
1497: EXECUTE IMMEDIATE 'UPDATE az_requests g
1498: SET g.selection_set = updateXML(g.selection_set, ''/EXT/H/V[@N="EntityOccuranceCode" and .="'|| P_SOURCE||'"]/../@A5'',decode('||v_count||',0,''Y'',''C'') )
1499: WHERE g.request_id = '||p_request_id||' and request_type=''T''';
1500:
1501: