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.AD_PATCH_HIST_REPS dependencies on DBMS_XMLQUERY

Line 478: queryCtx DBMS_XMLquery.ctxType;

474: v_act_args varchar2(2000);
475:
476: --Variables which store the formatted Action data
477:
478: queryCtx DBMS_XMLquery.ctxType;
479: result CLOB;
480:
481: -- Variable to store line numbers
482: v_line_num number := 0;

Line 543: queryCtx := DBMS_XMLQuery.newContext(query_str1);

539:
540:
541: query_str1:='Select '''||query_str1||''' LIMITTOFORMS from dual';
542:
543: queryCtx := DBMS_XMLQuery.newContext(query_str1);
544:
545: result := DBMS_XMLQuery.getXML(queryCtx);
546:
547: DBMS_XMLQuery.closeContext(queryCtx);

Line 545: result := DBMS_XMLQuery.getXML(queryCtx);

541: query_str1:='Select '''||query_str1||''' LIMITTOFORMS from dual';
542:
543: queryCtx := DBMS_XMLQuery.newContext(query_str1);
544:
545: result := DBMS_XMLQuery.getXML(queryCtx);
546:
547: DBMS_XMLQuery.closeContext(queryCtx);
548:
549: v_line_num:=printClobOut(result,v_line_num);

Line 547: DBMS_XMLQuery.closeContext(queryCtx);

543: queryCtx := DBMS_XMLQuery.newContext(query_str1);
544:
545: result := DBMS_XMLQuery.getXML(queryCtx);
546:
547: DBMS_XMLQuery.closeContext(queryCtx);
548:
549: v_line_num:=printClobOut(result,v_line_num);
550:
551:

Line 561: queryCtx := DBMS_XMLQuery.newContext(query_str1);

557: end if;
558:
559: query_str1:='Select '''||query_str1||''' LIMITTOPATCHES from dual';
560:
561: queryCtx := DBMS_XMLQuery.newContext(query_str1);
562:
563: result := DBMS_XMLQuery.getXML(queryCtx);
564:
565: DBMS_XMLQuery.closeContext(queryCtx);

Line 563: result := DBMS_XMLQuery.getXML(queryCtx);

559: query_str1:='Select '''||query_str1||''' LIMITTOPATCHES from dual';
560:
561: queryCtx := DBMS_XMLQuery.newContext(query_str1);
562:
563: result := DBMS_XMLQuery.getXML(queryCtx);
564:
565: DBMS_XMLQuery.closeContext(queryCtx);
566:
567: v_line_num:=printClobOut(result,v_line_num);

Line 565: DBMS_XMLQuery.closeContext(queryCtx);

561: queryCtx := DBMS_XMLQuery.newContext(query_str1);
562:
563: result := DBMS_XMLQuery.getXML(queryCtx);
564:
565: DBMS_XMLQuery.closeContext(queryCtx);
566:
567: v_line_num:=printClobOut(result,v_line_num);
568:
569:

Line 573: queryCtx := DBMS_XMLQuery.newContext(query_str1);

569:
570:
571: query_str1:='Select '''||NVL(p_bug_num,'ALL')||''' BUGNUMBER from dual';
572:
573: queryCtx := DBMS_XMLQuery.newContext(query_str1);
574:
575:
576: result := DBMS_XMLQuery.getXML(queryCtx);
577:

Line 576: result := DBMS_XMLQuery.getXML(queryCtx);

572:
573: queryCtx := DBMS_XMLQuery.newContext(query_str1);
574:
575:
576: result := DBMS_XMLQuery.getXML(queryCtx);
577:
578: DBMS_XMLQuery.closeContext(queryCtx);
579:
580: v_line_num:=printClobOut(result,v_line_num);

Line 578: DBMS_XMLQuery.closeContext(queryCtx);

574:
575:
576: result := DBMS_XMLQuery.getXML(queryCtx);
577:
578: DBMS_XMLQuery.closeContext(queryCtx);
579:
580: v_line_num:=printClobOut(result,v_line_num);
581:
582: query_str1:='Select '''||NVL(p_bug_prod_abbr,'ALL')||''' BUG_PRODUCT from dual';

Line 584: queryCtx := DBMS_XMLQuery.newContext(query_str1);

580: v_line_num:=printClobOut(result,v_line_num);
581:
582: query_str1:='Select '''||NVL(p_bug_prod_abbr,'ALL')||''' BUG_PRODUCT from dual';
583:
584: queryCtx := DBMS_XMLQuery.newContext(query_str1);
585:
586:
587: result := DBMS_XMLQuery.getXML(queryCtx);
588:

Line 587: result := DBMS_XMLQuery.getXML(queryCtx);

583:
584: queryCtx := DBMS_XMLQuery.newContext(query_str1);
585:
586:
587: result := DBMS_XMLQuery.getXML(queryCtx);
588:
589: DBMS_XMLQuery.closeContext(queryCtx);
590:
591: v_line_num:=printClobOut(result,v_line_num);

Line 589: DBMS_XMLQuery.closeContext(queryCtx);

585:
586:
587: result := DBMS_XMLQuery.getXML(queryCtx);
588:
589: DBMS_XMLQuery.closeContext(queryCtx);
590:
591: v_line_num:=printClobOut(result,v_line_num);
592:
593:

Line 597: queryCtx := DBMS_XMLQuery.newContext(query_str1);

593:
594:
595: query_str1:='Select '''||NVL(p_end_dt_from_v,'ALL')||''' END_DATE_FROM from dual';
596:
597: queryCtx := DBMS_XMLQuery.newContext(query_str1);
598:
599:
600: result := DBMS_XMLQuery.getXML(queryCtx);
601:

Line 600: result := DBMS_XMLQuery.getXML(queryCtx);

596:
597: queryCtx := DBMS_XMLQuery.newContext(query_str1);
598:
599:
600: result := DBMS_XMLQuery.getXML(queryCtx);
601:
602: DBMS_XMLQuery.closeContext(queryCtx);
603:
604: v_line_num:=printClobOut(result,v_line_num);

Line 602: DBMS_XMLQuery.closeContext(queryCtx);

598:
599:
600: result := DBMS_XMLQuery.getXML(queryCtx);
601:
602: DBMS_XMLQuery.closeContext(queryCtx);
603:
604: v_line_num:=printClobOut(result,v_line_num);
605:
606: query_str1:='Select '''||NVL(p_end_dt_to_v,'ALL')||''' END_DATE_TO from dual';

Line 608: queryCtx := DBMS_XMLQuery.newContext(query_str1);

604: v_line_num:=printClobOut(result,v_line_num);
605:
606: query_str1:='Select '''||NVL(p_end_dt_to_v,'ALL')||''' END_DATE_TO from dual';
607:
608: queryCtx := DBMS_XMLQuery.newContext(query_str1);
609:
610: result := DBMS_XMLQuery.getXML(queryCtx);
611:
612: DBMS_XMLQuery.closeContext(queryCtx);

Line 610: result := DBMS_XMLQuery.getXML(queryCtx);

606: query_str1:='Select '''||NVL(p_end_dt_to_v,'ALL')||''' END_DATE_TO from dual';
607:
608: queryCtx := DBMS_XMLQuery.newContext(query_str1);
609:
610: result := DBMS_XMLQuery.getXML(queryCtx);
611:
612: DBMS_XMLQuery.closeContext(queryCtx);
613:
614: v_line_num:=printClobOut(result,v_line_num);

Line 612: DBMS_XMLQuery.closeContext(queryCtx);

608: queryCtx := DBMS_XMLQuery.newContext(query_str1);
609:
610: result := DBMS_XMLQuery.getXML(queryCtx);
611:
612: DBMS_XMLQuery.closeContext(queryCtx);
613:
614: v_line_num:=printClobOut(result,v_line_num);
615:
616:

Line 619: queryCtx := DBMS_XMLQuery.newContext(query_str1);

615:
616:
617: query_str1:='Select '''||NVL(p_patch_nm,'ALL')||''' PATCH_NAME from dual';
618:
619: queryCtx := DBMS_XMLQuery.newContext(query_str1);
620:
621: result := DBMS_XMLQuery.getXML(queryCtx);
622:
623: DBMS_XMLQuery.closeContext(queryCtx);

Line 621: result := DBMS_XMLQuery.getXML(queryCtx);

617: query_str1:='Select '''||NVL(p_patch_nm,'ALL')||''' PATCH_NAME from dual';
618:
619: queryCtx := DBMS_XMLQuery.newContext(query_str1);
620:
621: result := DBMS_XMLQuery.getXML(queryCtx);
622:
623: DBMS_XMLQuery.closeContext(queryCtx);
624:
625: v_line_num:=printClobOut(result,v_line_num);

Line 623: DBMS_XMLQuery.closeContext(queryCtx);

619: queryCtx := DBMS_XMLQuery.newContext(query_str1);
620:
621: result := DBMS_XMLQuery.getXML(queryCtx);
622:
623: DBMS_XMLQuery.closeContext(queryCtx);
624:
625: v_line_num:=printClobOut(result,v_line_num);
626:
627:

Line 630: queryCtx := DBMS_XMLQuery.newContext(query_str1);

626:
627:
628: query_str1:='Select '''||NVL(p_patch_type,'ALL')||''' PATCH_TYPE from dual';
629:
630: queryCtx := DBMS_XMLQuery.newContext(query_str1);
631:
632: result := DBMS_XMLQuery.getXML(queryCtx);
633:
634: DBMS_XMLQuery.closeContext(queryCtx);

Line 632: result := DBMS_XMLQuery.getXML(queryCtx);

628: query_str1:='Select '''||NVL(p_patch_type,'ALL')||''' PATCH_TYPE from dual';
629:
630: queryCtx := DBMS_XMLQuery.newContext(query_str1);
631:
632: result := DBMS_XMLQuery.getXML(queryCtx);
633:
634: DBMS_XMLQuery.closeContext(queryCtx);
635:
636: v_line_num:=printClobOut(result,v_line_num);

Line 634: DBMS_XMLQuery.closeContext(queryCtx);

630: queryCtx := DBMS_XMLQuery.newContext(query_str1);
631:
632: result := DBMS_XMLQuery.getXML(queryCtx);
633:
634: DBMS_XMLQuery.closeContext(queryCtx);
635:
636: v_line_num:=printClobOut(result,v_line_num);
637:
638:

Line 641: queryCtx := DBMS_XMLQuery.newContext(query_str1);

637:
638:
639: query_str1:='Select '''||NVL(p_level,'ALL')||''' PATCH_LEVEL from dual';
640:
641: queryCtx := DBMS_XMLQuery.newContext(query_str1);
642:
643: result := DBMS_XMLQuery.getXML(queryCtx);
644:
645: DBMS_XMLQuery.closeContext(queryCtx);

Line 643: result := DBMS_XMLQuery.getXML(queryCtx);

639: query_str1:='Select '''||NVL(p_level,'ALL')||''' PATCH_LEVEL from dual';
640:
641: queryCtx := DBMS_XMLQuery.newContext(query_str1);
642:
643: result := DBMS_XMLQuery.getXML(queryCtx);
644:
645: DBMS_XMLQuery.closeContext(queryCtx);
646:
647: v_line_num:=printClobOut(result,v_line_num);

Line 645: DBMS_XMLQuery.closeContext(queryCtx);

641: queryCtx := DBMS_XMLQuery.newContext(query_str1);
642:
643: result := DBMS_XMLQuery.getXML(queryCtx);
644:
645: DBMS_XMLQuery.closeContext(queryCtx);
646:
647: v_line_num:=printClobOut(result,v_line_num);
648:
649: query_str1:='Select '''||NVL(p_lang,'ALL')||''' LANGUAGE from dual';

Line 651: queryCtx := DBMS_XMLQuery.newContext(query_str1);

647: v_line_num:=printClobOut(result,v_line_num);
648:
649: query_str1:='Select '''||NVL(p_lang,'ALL')||''' LANGUAGE from dual';
650:
651: queryCtx := DBMS_XMLQuery.newContext(query_str1);
652:
653: result := DBMS_XMLQuery.getXML(queryCtx);
654:
655: DBMS_XMLQuery.closeContext(queryCtx);

Line 653: result := DBMS_XMLQuery.getXML(queryCtx);

649: query_str1:='Select '''||NVL(p_lang,'ALL')||''' LANGUAGE from dual';
650:
651: queryCtx := DBMS_XMLQuery.newContext(query_str1);
652:
653: result := DBMS_XMLQuery.getXML(queryCtx);
654:
655: DBMS_XMLQuery.closeContext(queryCtx);
656:
657: v_line_num:=printClobOut(result,v_line_num);

Line 655: DBMS_XMLQuery.closeContext(queryCtx);

651: queryCtx := DBMS_XMLQuery.newContext(query_str1);
652:
653: result := DBMS_XMLQuery.getXML(queryCtx);
654:
655: DBMS_XMLQuery.closeContext(queryCtx);
656:
657: v_line_num:=printClobOut(result,v_line_num);
658:
659:

Line 662: queryCtx := DBMS_XMLQuery.newContext(query_str1);

658:
659:
660: query_str1:='Select '''||NVL(p_appltop_nm,'ALL')||''' APPL_TOP from dual';
661:
662: queryCtx := DBMS_XMLQuery.newContext(query_str1);
663:
664: result := DBMS_XMLQuery.getXML(queryCtx);
665:
666: DBMS_XMLQuery.closeContext(queryCtx);

Line 664: result := DBMS_XMLQuery.getXML(queryCtx);

660: query_str1:='Select '''||NVL(p_appltop_nm,'ALL')||''' APPL_TOP from dual';
661:
662: queryCtx := DBMS_XMLQuery.newContext(query_str1);
663:
664: result := DBMS_XMLQuery.getXML(queryCtx);
665:
666: DBMS_XMLQuery.closeContext(queryCtx);
667:
668: v_line_num:=printClobOut(result,v_line_num);

Line 666: DBMS_XMLQuery.closeContext(queryCtx);

662: queryCtx := DBMS_XMLQuery.newContext(query_str1);
663:
664: result := DBMS_XMLQuery.getXML(queryCtx);
665:
666: DBMS_XMLQuery.closeContext(queryCtx);
667:
668: v_line_num:=printClobOut(result,v_line_num);
669:
670: v_line_num:=printEndSearch(v_line_num);

Line 916: queryCtx := DBMS_XMLQuery.newContext(query_str1);

912: v_platform ||''' PATCH_PLATFORM , ''' ||
913: v_servertype ||''' SERVERTYPE from dual';
914:
915:
916: queryCtx := DBMS_XMLQuery.newContext(query_str1);
917:
918:
919: result := DBMS_XMLQuery.getXML(queryCtx);
920:

Line 919: result := DBMS_XMLQuery.getXML(queryCtx);

915:
916: queryCtx := DBMS_XMLQuery.newContext(query_str1);
917:
918:
919: result := DBMS_XMLQuery.getXML(queryCtx);
920:
921: DBMS_XMLQuery.closeContext(queryCtx);
922: v_line_num:=printClobOut(result,v_line_num);
923:

Line 921: DBMS_XMLQuery.closeContext(queryCtx);

917:
918:
919: result := DBMS_XMLQuery.getXML(queryCtx);
920:
921: DBMS_XMLQuery.closeContext(queryCtx);
922: v_line_num:=printClobOut(result,v_line_num);
923:
924:
925: if (p_query_depth > 1)

Line 978: queryCtx := DBMS_XMLQuery.newContext(query_str1);

974: v_applied||''' APPLIED_FLAG ,'''||
975: v_reason ||''' REASON_NOT_APPLIED from dual';
976:
977: v_line_num:=printBeginBug(v_line_num);
978: queryCtx := DBMS_XMLQuery.newContext(query_str1);
979:
980: result := DBMS_XMLQuery.getXML(queryCtx);
981:
982: DBMS_XMLQuery.closeContext(queryCtx);

Line 980: result := DBMS_XMLQuery.getXML(queryCtx);

976:
977: v_line_num:=printBeginBug(v_line_num);
978: queryCtx := DBMS_XMLQuery.newContext(query_str1);
979:
980: result := DBMS_XMLQuery.getXML(queryCtx);
981:
982: DBMS_XMLQuery.closeContext(queryCtx);
983:
984: v_line_num:=printClobOut(result,v_line_num);

Line 982: DBMS_XMLQuery.closeContext(queryCtx);

978: queryCtx := DBMS_XMLQuery.newContext(query_str1);
979:
980: result := DBMS_XMLQuery.getXML(queryCtx);
981:
982: DBMS_XMLQuery.closeContext(queryCtx);
983:
984: v_line_num:=printClobOut(result,v_line_num);
985:
986:

Line 1103: queryCtx := DBMS_XMLQuery.newContext(query_str1);

1099: v_act_Modfr||''' ACTION_MODIFIER from dual';
1100:
1101: v_line_num:=printBeginAction(v_line_num);
1102:
1103: queryCtx := DBMS_XMLQuery.newContext(query_str1);
1104:
1105: result := DBMS_XMLQuery.getXML(queryCtx);
1106:
1107: DBMS_XMLQuery.closeContext(queryCtx);

Line 1105: result := DBMS_XMLQuery.getXML(queryCtx);

1101: v_line_num:=printBeginAction(v_line_num);
1102:
1103: queryCtx := DBMS_XMLQuery.newContext(query_str1);
1104:
1105: result := DBMS_XMLQuery.getXML(queryCtx);
1106:
1107: DBMS_XMLQuery.closeContext(queryCtx);
1108:
1109: v_line_num:=printClobOut(result,v_line_num);

Line 1107: DBMS_XMLQuery.closeContext(queryCtx);

1103: queryCtx := DBMS_XMLQuery.newContext(query_str1);
1104:
1105: result := DBMS_XMLQuery.getXML(queryCtx);
1106:
1107: DBMS_XMLQuery.closeContext(queryCtx);
1108:
1109: v_line_num:=printClobOut(result,v_line_num);
1110:
1111: v_line_num:=printEndAction(v_line_num);