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.

SYS.DBMS_QOPATCH dependencies on XMLTYPE

Line 3: xslt xmltype := NULL;

1: PACKAGE dbms_qopatch AUTHID DEFINER AS
2:
3: xslt xmltype := NULL;
4:
5: --Provides ORACLE_HOME details
6: function get_opatch_install_info return xmltype;
7:

Line 6: function get_opatch_install_info return xmltype;

2:
3: xslt xmltype := NULL;
4:
5: --Provides ORACLE_HOME details
6: function get_opatch_install_info return xmltype;
7:
8: --Provides top level patch info for patch
9: function GET_OPATCH_DATA (pnum IN varchar2) return xmltype;
10:

Line 9: function GET_OPATCH_DATA (pnum IN varchar2) return xmltype;

5: --Provides ORACLE_HOME details
6: function get_opatch_install_info return xmltype;
7:
8: --Provides top level patch info for patch
9: function GET_OPATCH_DATA (pnum IN varchar2) return xmltype;
10:
11: --Provides bugs list in a patch or all the patches
12: function GET_OPATCH_BUGS (pnum IN varchar2 DEFAULT NULL) return xmltype;
13:

Line 12: function GET_OPATCH_BUGS (pnum IN varchar2 DEFAULT NULL) return xmltype;

8: --Provides top level patch info for patch
9: function GET_OPATCH_DATA (pnum IN varchar2) return xmltype;
10:
11: --Provides bugs list in a patch or all the patches
12: function GET_OPATCH_BUGS (pnum IN varchar2 DEFAULT NULL) return xmltype;
13:
14: --Provides list of files modified by a patch or all the patches
15: function GET_OPATCH_FILES (pnum IN varchar2) return xmltype;
16:

Line 15: function GET_OPATCH_FILES (pnum IN varchar2) return xmltype;

11: --Provides bugs list in a patch or all the patches
12: function GET_OPATCH_BUGS (pnum IN varchar2 DEFAULT NULL) return xmltype;
13:
14: --Provides list of files modified by a patch or all the patches
15: function GET_OPATCH_FILES (pnum IN varchar2) return xmltype;
16:
17: --Provides installed patches total count
18: function GET_OPATCH_COUNT return xmltype;
19:

Line 18: function GET_OPATCH_COUNT return xmltype;

14: --Provides list of files modified by a patch or all the patches
15: function GET_OPATCH_FILES (pnum IN varchar2) return xmltype;
16:
17: --Provides installed patches total count
18: function GET_OPATCH_COUNT return xmltype;
19:
20: -- Get list of patches installed
21: function GET_OPATCH_LIST return xmltype;
22:

Line 21: function GET_OPATCH_LIST return xmltype;

17: --Provides installed patches total count
18: function GET_OPATCH_COUNT return xmltype;
19:
20: -- Get list of patches installed
21: function GET_OPATCH_LIST return xmltype;
22:
23: --Provides prerequisite patches for a patch
24: function GET_OPATCH_PREQS (pnum IN varchar2) return xmltype;
25:

Line 24: function GET_OPATCH_PREQS (pnum IN varchar2) return xmltype;

20: -- Get list of patches installed
21: function GET_OPATCH_LIST return xmltype;
22:
23: --Provides prerequisite patches for a patch
24: function GET_OPATCH_PREQS (pnum IN varchar2) return xmltype;
25:
26: --Provides overlay patches for a patch
27: function GET_OPATCH_OLAYS (pnum IN varchar2) return xmltype;
28:

Line 27: function GET_OPATCH_OLAYS (pnum IN varchar2) return xmltype;

23: --Provides prerequisite patches for a patch
24: function GET_OPATCH_PREQS (pnum IN varchar2) return xmltype;
25:
26: --Provides overlay patches for a patch
27: function GET_OPATCH_OLAYS (pnum IN varchar2) return xmltype;
28:
29: --Detects patch conflicts for given files
30: function PATCH_CONFLICT_DETECTION (fileName IN varchar2) return xmltype;
31:

Line 30: function PATCH_CONFLICT_DETECTION (fileName IN varchar2) return xmltype;

26: --Provides overlay patches for a patch
27: function GET_OPATCH_OLAYS (pnum IN varchar2) return xmltype;
28:
29: --Detects patch conflicts for given files
30: function PATCH_CONFLICT_DETECTION (fileName IN varchar2) return xmltype;
31:
32: -- Provides list of patches installed
33: function IS_PATCH_INSTALLED (pnum IN VARCHAR2) return xmltype;
34:

Line 33: function IS_PATCH_INSTALLED (pnum IN VARCHAR2) return xmltype;

29: --Detects patch conflicts for given files
30: function PATCH_CONFLICT_DETECTION (fileName IN varchar2) return xmltype;
31:
32: -- Provides list of patches installed
33: function IS_PATCH_INSTALLED (pnum IN VARCHAR2) return xmltype;
34:
35: -- Get sql patch status of all RAC instances
36: function GET_PENDING_ACTIVITY return xmltype;
37:

Line 36: function GET_PENDING_ACTIVITY return xmltype;

32: -- Provides list of patches installed
33: function IS_PATCH_INSTALLED (pnum IN VARCHAR2) return xmltype;
34:
35: -- Get sql patch status of all RAC instances
36: function GET_PENDING_ACTIVITY return xmltype;
37:
38: -- Set current node, instance name in case of RAC
39: PROCEDURE set_current_opinst(node_name IN VARCHAR2 DEFAULT NULL,
40: inst_name IN VARCHAR2 DEFAULT NULL);

Line 46: function get_opatch_xslt return xmltype;

42: -- To call job to refresh the inventory
43: PROCEDURE opatch_inv_refresh_job;
44:
45: -- To get the stylesheet for result presentation
46: function get_opatch_xslt return xmltype;
47:
48: --To get the full opatch lsinventory
49: function get_opatch_lsinventory return xmltype;
50:

Line 49: function get_opatch_lsinventory return xmltype;

45: -- To get the stylesheet for result presentation
46: function get_opatch_xslt return xmltype;
47:
48: --To get the full opatch lsinventory
49: function get_opatch_lsinventory return xmltype;
50:
51: -- To create job on newly added node
52: FUNCTION add_oinv_job(nname VARCHAR2, iname VARCHAR2) RETURN BOOLEAN;
53: