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 = p_request_id and PRIM.source = p_source
291: and PRIM.id=v_children_A_ID_List(i) and PRIM.is_primary='Y'
292: and SEC.request_id = p_request_id and SEC.source = p_source

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

292: and SEC.request_id = p_request_id and SEC.source = p_source
293: and SEC.id = v_matching_VO_id_B
294: and SEC.is_primary = 'N';
295:
296: SELECT decode(existsnode(v_temp_xmltype, '/H/V[./A/text()!=./B/text() and not(@U="Y")]'), 1, 'C', 'N')
297: INTO v_is_different
298: FROM dual;
299:
300: SELECT existsnode(v_temp_xmltype, '/H/V[not(@U="Y")]')

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

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

Line 332: v_exclude_details, v_temp_xmltype);

328: 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
329: v_is_different, -- isdifferent
330: 'N', -- istransformed
331: decode(v_is_different, 'C', 'Y', 'N'), --show only diff--v_show_only_diff, -- show_only_diff
332: v_exclude_details, v_temp_xmltype);
333:
334: v_dml_count := v_dml_count + 1;
335: commit_if_required;
336:

Line 408: v_temp_xmltype xmltype;

404: v_hcd_a VARCHAR2(4000);
405: v_results_pid NUMBER;
406:
407: v_children_a_id_list typ_nest_tab_number;
408: v_temp_xmltype xmltype;
409: v_amount INTEGER;
410: v_type NUMBER;
411:
412: v_exclude_details VARCHAR2(1);

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

437: AND source = p_source
438: AND id = p_data_id
439: AND is_primary = 'Y';
440:
441: SELECT d.attributes.transform(v_a_xmltype)
442: INTO v_temp_xmltype
443: FROM az_reporter_data d
444: WHERE request_id = p_request_id
445: AND source = p_source

Line 442: INTO v_temp_xmltype

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

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

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

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

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

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

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

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

476: 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
477: 'A', -- isdifferent
478: 'N', -- istransformed
479: 'Y', -- show_diff_only
480: v_exclude_details, xmltype(v_temp_xmltype.getclobval(), diff_schema_url, 1, 1));
481:
482: v_dml_count := v_dml_count + 1;
483: commit_if_required;
484:

Line 529: v_temp_xmltype xmltype;

525:
526: v_attr_str VARCHAR2(32767);
527: v_amount INTEGER;
528: v_type NUMBER;
529: v_temp_xmltype xmltype;
530: v_exclude_details VARCHAR2(1);
531: v_exclude_details_temp VARCHAR2(1);
532: l_api_name constant VARCHAR2(30) := 'output_B_only : ';
533: BEGIN

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

555: AND source = p_source
556: AND id = p_data_id
557: AND is_primary = 'N';
558:
559: SELECT d.attributes.transform(v_b_xmltype)
560: INTO v_temp_xmltype
561: FROM az_reporter_data d
562: WHERE request_id = p_request_id
563: AND source = p_source

Line 560: INTO v_temp_xmltype

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

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

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

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

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

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

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

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

595: 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
596: 'B', -- isdifferent
597: 'N', -- istransformed
598: 'Y', -- show_diff_only
599: v_exclude_details, xmltype(v_temp_xmltype.getclobval(), diff_schema_url, 1, 1));
600:
601: v_dml_count := v_dml_count + 1;
602: commit_if_required;
603:

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

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

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

837: ';
838:
839: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
840: fnd_log.string(fnd_log.level_statement, c_log_head || l_api_name ||
841: to_char(systimestamp), 'Query to update selection set with counts : update az_requests d set d.selection_set = d.selection_set.transform(xmltype(''' ||
842: v_transform_xml || ''')).createSchemabasedxml(d.selection_set.getSchemaURL()) WHERE request_id=' || p_request_id || ' and request_type=''C''');
843: END IF;
844:
845: 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 845: 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''';

841: to_char(systimestamp), 'Query to update selection set with counts : update az_requests d set d.selection_set = d.selection_set.transform(xmltype(''' ||
842: v_transform_xml || ''')).createSchemabasedxml(d.selection_set.getSchemaURL()) WHERE request_id=' || p_request_id || ' and request_type=''C''');
843: END IF;
844:
845: 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''';
846: END IF;
847:
848: EXCEPTION
849: WHEN no_data_found THEN