APPS.AZ_R12_TRANSFORM_CASCADE dependencies on XMLSEQUENCE

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 206: TABLE(XMLSEQUENCE(EXTRACT(D.ATTR_DIFF, '/H/V'))) E

202:
203: SELECT count (distinct (EXTRACTVALUE(VALUE(E), '/V/B/text()')))
204: into V_CHECK_TRFM_ALL_FLAG
205: FROM AZ_DIFF_RESULTS D,
206: TABLE(XMLSEQUENCE(EXTRACT(D.ATTR_DIFF, '/H/V'))) E
207: WHERE D.REQUEST_ID = P_REQUEST_ID
208: AND D.SOURCE = P_REQUIRED_SOURCE
209: AND D.IS_TRANSFORMED = 'Y'
210: AND D.TYPE <> -1

Line 250: TABLE(XMLSEQUENCE(EXTRACT(D.ATTR_DIFF, '/H/V'))) E

246: INTO V_REQ_API_ATTR_NAME_LIST,
247: V_REQ_API_ATTR_NEW_VALUE_LIST,
248: V_REQ_API_ATTR_OLD_VALUE_LIST
249: FROM AZ_DIFF_RESULTS D,
250: TABLE(XMLSEQUENCE(EXTRACT(D.ATTR_DIFF, '/H/V'))) E
251: WHERE D.REQUEST_ID = P_REQUEST_ID
252: AND D.SOURCE = P_REQUIRED_SOURCE
253: AND D.IS_TRANSFORMED = 'Y'
254: AND D.ID = V_PARENT_ID_LIST(I)

Line 273: --- Change to remove the excess table xmlsequence

269:
270: ';
271: -- LMATHUR - added the copy-of for optimizing the stylesheet, need not copy all the attributes
272:
273: --- Change to remove the excess table xmlsequence
274: V_DEPENDANT_IDS_SQL := 'SELECT q.id FROM AZ_DIFF_RESULTS q ';
275: V_DEPENDANT_IDS_SQL := V_DEPENDANT_IDS_SQL ||
276: ' where q.request_id = ' || P_REQUEST_ID ||
277: ' AND ';

Line 643: TABLE(XMLSEQUENCE(EXTRACT(D.SELECTION_SET,

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';
647:

Line 680: TABLE(XMLSEQUENCE(EXTRACT(D.SELECTION_SET,

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';
684:

Line 694: TABLE(XMLSEQUENCE(EXTRACT(D.SELECTION_SET,

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
698: AND D.REQUEST_TYPE = 'T';

Line 848: TABLE(xmlsequence(extract(d.selection_set,

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
852: AND

Line 869: TABLE(xmlsequence(extract(d.selection_set,

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
873: AND user_id = p_user_id

Line 966: TABLE(xmlsequence(extract(d.selection_set,

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),
970: '/H/V[@N="EntityOccuranceName" or @N="EntityOccuranceCode" or @N="RefEntityOccuranceCode"]') = 1

Line 994: TABLE(xmlsequence(extract(d.selection_set,

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),
998: '/H/V[@N="EntityOccuranceName" or @N="EntityOccuranceCode" or @N="RefEntityOccuranceCode"]') = 1

Line 1308: TABLE(XMLSEQUENCE(EXTRACT(D.ATTR_DIFF, '/H/V'))) E

1304: INTO v_attr_name_list,
1305: v_attr_new_value_list,
1306: v_attr_old_value_list
1307: FROM AZ_DIFF_RESULTS D,
1308: TABLE(XMLSEQUENCE(EXTRACT(D.ATTR_DIFF, '/H/V'))) E
1309: WHERE D.REQUEST_ID = p_request_id
1310: AND D.SOURCE = p_source
1311: AND D.param2 = 'Y'
1312: AND D.ID = P_ID