APPS.AZ_R12_TRANSFORM_CASCADE dependencies on XMLTYPE

Line 524: V_TEMP_SQL := 'UPDATE az_diff_results q SET param3 = ''Y'', q.attr_diff = q.attr_diff.transform(xmltype('''||V_CONFLICT_XSL||''')).createSchemaBasedXml(''' ||

520: END LOOP;
521:
522: IF length(V_CONFLICT_XSL)>0
523: THEN
524: V_TEMP_SQL := 'UPDATE az_diff_results q SET param3 = ''Y'', q.attr_diff = q.attr_diff.transform(xmltype('''||V_CONFLICT_XSL||''')).createSchemaBasedXml(''' ||
525: DIFF_SCHEMA_URL || ''') WHERE '|| ' q.id = ' || V_DEPENDANT_IDS_LIST(K)
526: ||' AND q.request_id = '||P_REQUEST_ID||
527: ' AND ' || V_EXISTSNODE_STRING || ' q.source = '''||p_dependant_source||'''';
528:

Line 551: V_TEMP_SQL :='UPDATE az_diff_results q SET param3 = ''Y'', q.attr_diff = q.attr_diff.transform(xmltype('''||V_CONFLICT_XSL||''')).createSchemaBasedXml(''' ||

547: END IF;
548: -- For logging
549:
550: FOR Y IN 1 .. V_CONFLICT_CHILD_IDS_LIST.COUNT LOOP
551: V_TEMP_SQL :='UPDATE az_diff_results q SET param3 = ''Y'', q.attr_diff = q.attr_diff.transform(xmltype('''||V_CONFLICT_XSL||''')).createSchemaBasedXml(''' ||
552: DIFF_SCHEMA_URL || ''') WHERE '|| ' q.id = ' || V_CONFLICT_CHILD_IDS_LIST(Y)
553: ||' AND q.request_id = '||P_REQUEST_ID||
554: ' AND '|| V_EXISTSNODE_STRING || ' q.source = '''||p_dependant_source||'''';
555:

Line 909: --LMATHUR -- added to prevent the varchar overflow for Xmltype

905: END LOOP;
906:
907: IF LENGTH(V_UPDATE_XSL)>0
908: THEN
909: --LMATHUR -- added to prevent the varchar overflow for Xmltype
910: V_UPDATE_XSL := '
911:
912:
913:

Line 1174: V_TRANSFORM_SQL := V_TRANSFORM_SQL ||' e.attr_diff = (select d.attr_diff.transform( xmltype('' ';

1170: IF P_MASTER_FLAG = 'Y'
1171: THEN
1172: V_TRANSFORM_SQL := V_TRANSFORM_SQL ||' IS_TRANSFORMED = ''Y'',';
1173: END IF;
1174: V_TRANSFORM_SQL := V_TRANSFORM_SQL ||' e.attr_diff = (select d.attr_diff.transform( xmltype('' ';
1175:
1176: V_TRANSFORM_SQL := V_TRANSFORM_SQL ||
1177: ' ';
1178: V_TRANSFORM_SQL := V_TRANSFORM_SQL || ' ';

Line 1257: v_transform_all_sql := 'update az_diff_results e set e.param2 = ''Y'', e.attr_diff =e.attr_diff.transform( xmltype(:1';

1253: p_source IN VARCHAR2)
1254: RETURN VARCHAR2 IS
1255: v_transform_all_sql VARCHAR2(32767);
1256: BEGIN
1257: v_transform_all_sql := 'update az_diff_results e set e.param2 = ''Y'', e.attr_diff =e.attr_diff.transform( xmltype(:1';
1258:
1259:
1260: v_transform_all_sql := v_transform_all_sql ||
1261: ')).createSchemaBasedXml(''' || diff_schema_url ||

Line 1382: SET d.attr_diff = d.attr_diff.transform(xmltype('''||V_CONFLICT_XSL||''') ).createSchemaBasedXML('''||p_diff_schema_url||''')

1378:
1379: ';
1380: V_EXISTSNODE_STRING := '('||V_EXISTSNODE_STRING||')';
1381: V_QUERY_STR := 'UPDATE az_diff_results d
1382: SET d.attr_diff = d.attr_diff.transform(xmltype('''||V_CONFLICT_XSL||''') ).createSchemaBasedXML('''||p_diff_schema_url||''')
1383: WHERE '||V_EXISTSNODE_STRING||'
1384: AND d.request_id ='|| p_request_id||'
1385: AND d.source ='''|| p_source||'''
1386: AND d.id = '||v_child_id_list(j);