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_COMP_REPORTER dependencies on XMLTYPE

Line 66: --v_prim_xmltype xmltype:= xmltype.createXml(PRIM_STYLESHEET);

62:
63:
64: ';
65:
66: --v_prim_xmltype xmltype:= xmltype.createXml(PRIM_STYLESHEET);
67: v_a_xmltype xmltype := xmltype.createxml(output_a_stylesheet);
68: v_b_xmltype xmltype := xmltype.createxml(output_b_stylesheet);
69:
70: -- constant := ;

Line 67: v_a_xmltype xmltype := xmltype.createxml(output_a_stylesheet);

63:
64: ';
65:
66: --v_prim_xmltype xmltype:= xmltype.createXml(PRIM_STYLESHEET);
67: v_a_xmltype xmltype := xmltype.createxml(output_a_stylesheet);
68: v_b_xmltype xmltype := xmltype.createxml(output_b_stylesheet);
69:
70: -- constant := ;
71:

Line 68: v_b_xmltype xmltype := xmltype.createxml(output_b_stylesheet);

64: ';
65:
66: --v_prim_xmltype xmltype:= xmltype.createXml(PRIM_STYLESHEET);
67: v_a_xmltype xmltype := xmltype.createxml(output_a_stylesheet);
68: v_b_xmltype xmltype := xmltype.createxml(output_b_stylesheet);
69:
70: -- constant := ;
71:
72: -- Private variable declarations

Line 209: v_temp_xmltype xmltype;

205: v_amount INTEGER;
206: v_is_different VARCHAR2(1) := 'N';
207: v_show_only_diff VARCHAR2(1) := 'N';
208: v_debug_str VARCHAR2(32767);
209: v_temp_xmltype xmltype;
210:
211: v_exclude_details VARCHAR2(1);
212: v_exclude_details_temp VARCHAR2(1);
213: l_api_name constant VARCHAR2(30) := 'output_DF : ';

Line 288: into v_temp_xmltype

284: else $j
285: return {$common}{$exprim}{$exsec}' passing
286: PRIM.attributes as "PRIM", SEC.attributes as "SEC"
287: returning content).createSchemaBasedXml(DIFF_SCHEMA_URL)
288: into v_temp_xmltype
289: from az_reporter_data PRIM,az_reporter_data SEC
290: where PRIM.request_id = SEC.request_id
291: and PRIM.source = SEC.source
292: and PRIM.request_id = p_request_id

Line 300: select decode(existsNode(v_temp_xmltype,'/H/V[((not(./A/text()!="") and ./B/text()!="") or (not(./B/text()!="") and ./A/text()!="") or (./A/text()!=./B/text())) and not(@U="Y")]'),1,'C','N')

296: and SEC.id = v_matching_VO_id_B
297: and SEC.is_primary = 'N';
298:
299: /* a is null/empty and b is not empty) or (b is null/empty and a is not empty) or (a is not equal to b) */
300: select decode(existsNode(v_temp_xmltype,'/H/V[((not(./A/text()!="") and ./B/text()!="") or (not(./B/text()!="") and ./A/text()!="") or (./A/text()!=./B/text())) and not(@U="Y")]'),1,'C','N')
301: INTO v_is_different
302: FROM dual;
303:
304: SELECT existsnode(v_temp_xmltype, '/H/V[not(@U="Y")]')

Line 304: SELECT existsnode(v_temp_xmltype, '/H/V[not(@U="Y")]')

300: select decode(existsNode(v_temp_xmltype,'/H/V[((not(./A/text()!="") and ./B/text()!="") or (not(./B/text()!="") and ./A/text()!="") or (./A/text()!=./B/text())) and not(@U="Y")]'),1,'C','N')
301: INTO v_is_different
302: FROM dual;
303:
304: SELECT existsnode(v_temp_xmltype, '/H/V[not(@U="Y")]')
305: INTO v_exclude_details_temp
306: FROM dual;
307:
308: IF(v_exclude_details_temp = '0' OR exclude_details = 'Y') THEN

Line 336: v_exclude_details, v_temp_xmltype);

332: VALUES(v_children_a_name_list(i), v_children_a_disp_name_list(i), p_request_id, p_source, v_type, p_results_id, p_results_pid, v_children_a_hcd_list(i), p_depth, -- depth
333: v_is_different, -- isdifferent
334: 'N', -- istransformed
335: decode(v_is_different, 'C', 'Y', 'N'), --show only diff--v_show_only_diff, -- show_only_diff
336: v_exclude_details, v_temp_xmltype);
337:
338: v_dml_count := v_dml_count + 1;
339: commit_if_required;
340:

Line 412: v_temp_xmltype xmltype;

408: v_hcd_a VARCHAR2(4000);
409: v_results_pid NUMBER;
410:
411: v_children_a_id_list typ_nest_tab_number;
412: v_temp_xmltype xmltype;
413: v_amount INTEGER;
414: v_type NUMBER;
415:
416: v_exclude_details VARCHAR2(1);

Line 445: SELECT d.attributes.transform(v_a_xmltype)

441: AND source = p_source
442: AND id = p_data_id
443: AND is_primary = 'Y';
444:
445: SELECT d.attributes.transform(v_a_xmltype)
446: INTO v_temp_xmltype
447: FROM az_reporter_data d
448: WHERE request_id = p_request_id
449: AND source = p_source

Line 446: INTO v_temp_xmltype

442: AND id = p_data_id
443: AND is_primary = 'Y';
444:
445: SELECT d.attributes.transform(v_a_xmltype)
446: INTO v_temp_xmltype
447: FROM az_reporter_data d
448: WHERE request_id = p_request_id
449: AND source = p_source
450: AND id = p_data_id

Line 453: SELECT existsnode(v_temp_xmltype, '/H/V[not(@U="Y")]')

449: AND source = p_source
450: AND id = p_data_id
451: AND is_primary = 'Y';
452:
453: SELECT existsnode(v_temp_xmltype, '/H/V[not(@U="Y")]')
454: INTO v_exclude_details_temp
455: FROM dual;
456:
457: IF(v_exclude_details_temp = '0' OR exclude_details = 'Y') THEN

Line 470: -- IF(LENGTH(v_temp_xmltype.getClobVal()) > 0 ) THEN

466: v_type := 2;
467: END IF;
468:
469: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
470: -- IF(LENGTH(v_temp_xmltype.getClobVal()) > 0 ) THEN
471: -- fnd_log.string(fnd_log.level_statement, c_log_head || l_api_name
472: -- || to_char(systimestamp), ' v_temp_xmltype: ' || v_temp_xmltype.getclobval());
473: -- END IF;
474: fnd_log.string(fnd_log.level_statement, c_log_head || l_api_name

Line 472: -- || to_char(systimestamp), ' v_temp_xmltype: ' || v_temp_xmltype.getclobval());

468:
469: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
470: -- IF(LENGTH(v_temp_xmltype.getClobVal()) > 0 ) THEN
471: -- fnd_log.string(fnd_log.level_statement, c_log_head || l_api_name
472: -- || to_char(systimestamp), ' v_temp_xmltype: ' || v_temp_xmltype.getclobval());
473: -- END IF;
474: fnd_log.string(fnd_log.level_statement, c_log_head || l_api_name
475: || to_char(systimestamp), 'v_exclude_details: ' || v_exclude_details || ' p_results_pid: ' || p_results_pid);
476: END IF;

Line 484: v_exclude_details, xmltype(v_temp_xmltype.getclobval(), diff_schema_url, 1, 1));

480: VALUES(v_name_a, v_disp_name_a, p_request_id, p_source, v_type, p_results_id, p_results_pid, v_hcd_a, p_depth, -- depth
481: 'A', -- isdifferent
482: 'N', -- istransformed
483: 'Y', -- show_diff_only
484: v_exclude_details, xmltype(v_temp_xmltype.getclobval(), diff_schema_url, 1, 1));
485:
486: v_dml_count := v_dml_count + 1;
487: commit_if_required;
488:

Line 533: v_temp_xmltype xmltype;

529:
530: v_attr_str VARCHAR2(32767);
531: v_amount INTEGER;
532: v_type NUMBER;
533: v_temp_xmltype xmltype;
534: v_exclude_details VARCHAR2(1);
535: v_exclude_details_temp VARCHAR2(1);
536: l_api_name constant VARCHAR2(30) := 'output_B_only : ';
537: BEGIN

Line 563: SELECT d.attributes.transform(v_b_xmltype)

559: AND source = p_source
560: AND id = p_data_id
561: AND is_primary = 'N';
562:
563: SELECT d.attributes.transform(v_b_xmltype)
564: INTO v_temp_xmltype
565: FROM az_reporter_data d
566: WHERE request_id = p_request_id
567: AND source = p_source

Line 564: INTO v_temp_xmltype

560: AND id = p_data_id
561: AND is_primary = 'N';
562:
563: SELECT d.attributes.transform(v_b_xmltype)
564: INTO v_temp_xmltype
565: FROM az_reporter_data d
566: WHERE request_id = p_request_id
567: AND source = p_source
568: AND id = p_data_id

Line 571: SELECT existsnode(v_temp_xmltype, '/H/V[not(@U="Y")]')

567: AND source = p_source
568: AND id = p_data_id
569: AND is_primary = 'N';
570:
571: SELECT existsnode(v_temp_xmltype, '/H/V[not(@U="Y")]')
572: INTO v_exclude_details_temp
573: FROM dual;
574:
575: IF(v_exclude_details_temp = '0' OR exclude_details = 'Y') THEN

Line 588: IF(LENGTH(v_temp_xmltype.getClobVal()) > 0 ) THEN

584: v_type := 2;
585: END IF;
586:
587: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
588: IF(LENGTH(v_temp_xmltype.getClobVal()) > 0 ) THEN
589: fnd_log.string(fnd_log.level_statement, c_log_head || l_api_name
590: || to_char(systimestamp), ' v_temp_xmltype: ' || v_temp_xmltype.getclobval());
591: END IF;
592: fnd_log.string(fnd_log.level_statement, c_log_head || l_api_name

Line 590: || to_char(systimestamp), ' v_temp_xmltype: ' || v_temp_xmltype.getclobval());

586:
587: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
588: IF(LENGTH(v_temp_xmltype.getClobVal()) > 0 ) THEN
589: fnd_log.string(fnd_log.level_statement, c_log_head || l_api_name
590: || to_char(systimestamp), ' v_temp_xmltype: ' || v_temp_xmltype.getclobval());
591: END IF;
592: fnd_log.string(fnd_log.level_statement, c_log_head || l_api_name
593: || to_char(systimestamp), 'v_exclude_details: ' || v_exclude_details || ' p_results_pid: '
594: || p_results_pid);

Line 603: v_exclude_details, xmltype(v_temp_xmltype.getclobval(), diff_schema_url, 1, 1));

599: VALUES(v_name_b, v_disp_name_b, p_request_id, p_source, v_type, p_results_id, p_results_pid, v_hcd_b, p_depth, -- depth
600: 'B', -- isdifferent
601: 'N', -- istransformed
602: 'Y', -- show_diff_only
603: v_exclude_details, xmltype(v_temp_xmltype.getclobval(), diff_schema_url, 1, 1));
604:
605: v_dml_count := v_dml_count + 1;
606: commit_if_required;
607:

Line 804: TABLE(xmlsequence(EXTRACT(xmltype(''), '/Root/node()'))) e

800: AND source = p_source
801: AND parent_id = 1
802: GROUP BY is_different)
803: k,
804: TABLE(xmlsequence(EXTRACT(xmltype(''), '/Root/node()'))) e
805: WHERE e.column_value.getrootelement() = name(+);
806:
807: FOR i IN 1 .. v_diff_type_list.COUNT
808: LOOP

Line 845: to_char(systimestamp), 'Query to update selection set with counts : update az_requests d set d.selection_set = d.selection_set.transform(xmltype(''' ||

841: ';
842:
843: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
844: fnd_log.string(fnd_log.level_statement, c_log_head || l_api_name ||
845: to_char(systimestamp), 'Query to update selection set with counts : update az_requests d set d.selection_set = d.selection_set.transform(xmltype(''' ||
846: v_transform_xml || ''')).createSchemabasedxml(d.selection_set.getSchemaURL()) WHERE request_id=' || p_request_id || ' and request_type=''C''');
847: END IF;
848:
849: EXECUTE IMMEDIATE 'update az_requests d set d.selection_set = d.selection_set.transform(xmltype(''' || v_transform_xml || ''')).createSchemabasedxml(d.selection_set.getSchemaURL()) WHERE request_id=' || p_request_id || ' and request_type=''C''';

Line 849: EXECUTE IMMEDIATE 'update az_requests d set d.selection_set = d.selection_set.transform(xmltype(''' || v_transform_xml || ''')).createSchemabasedxml(d.selection_set.getSchemaURL()) WHERE request_id=' || p_request_id || ' and request_type=''C''';

845: to_char(systimestamp), 'Query to update selection set with counts : update az_requests d set d.selection_set = d.selection_set.transform(xmltype(''' ||
846: v_transform_xml || ''')).createSchemabasedxml(d.selection_set.getSchemaURL()) WHERE request_id=' || p_request_id || ' and request_type=''C''');
847: END IF;
848:
849: EXECUTE IMMEDIATE 'update az_requests d set d.selection_set = d.selection_set.transform(xmltype(''' || v_transform_xml || ''')).createSchemabasedxml(d.selection_set.getSchemaURL()) WHERE request_id=' || p_request_id || ' and request_type=''C''';
850: END IF;
851:
852: EXCEPTION
853: WHEN no_data_found THEN