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_PLSQL_XML dependencies on XMLDOM

Line 73: ) return xmldom.DOMDocument is

69: -- Local Procedures and Functions
70: --
71: function parse
72: (p_xml in varchar2
73: ) return xmldom.DOMDocument is
74: l_retDoc xmldom.DOMDocument;
75: l_parser xmlparser.parser;
76: begin
77: l_parser := xmlparser.newParser;

Line 74: l_retDoc xmldom.DOMDocument;

70: --
71: function parse
72: (p_xml in varchar2
73: ) return xmldom.DOMDocument is
74: l_retDoc xmldom.DOMDocument;
75: l_parser xmlparser.parser;
76: begin
77: l_parser := xmlparser.newParser;
78: xmlparser.parseBuffer(l_parser,p_xml);

Line 87: function tonode(doc xmldom.DOMDocument) return xmldom.DOMNode is

83: xmlparser.freeParser(l_parser);
84: return l_retDoc;
85: end parse;
86: --
87: function tonode(doc xmldom.DOMDocument) return xmldom.DOMNode is
88: begin
89: return xmldom.makenode(doc);
90: end tonode;
91: --

Line 89: return xmldom.makenode(doc);

85: end parse;
86: --
87: function tonode(doc xmldom.DOMDocument) return xmldom.DOMNode is
88: begin
89: return xmldom.makenode(doc);
90: end tonode;
91: --
92: function valueOf
93: (p_node in xmldom.DOMNode

Line 93: (p_node in xmldom.DOMNode

89: return xmldom.makenode(doc);
90: end tonode;
91: --
92: function valueOf
93: (p_node in xmldom.DOMNode
94: ,p_xpath in varchar2
95: ) return varchar2 is
96: begin
97: if xmldom.isnull(p_node) or p_xpath is null then

Line 97: if xmldom.isnull(p_node) or p_xpath is null then

93: (p_node in xmldom.DOMNode
94: ,p_xpath in varchar2
95: ) return varchar2 is
96: begin
97: if xmldom.isnull(p_node) or p_xpath is null then
98: return null;
99: else
100: return xslprocessor.valueof(p_node, p_xpath);
101: end if;

Line 105: (p_doc in xmldom.DOMDocument

101: end if;
102: end valueOf;
103: --
104: function valueOf
105: (p_doc in xmldom.DOMDocument
106: ,p_xpath in varchar2
107: ) return varchar2 is
108: begin
109: if xmldom.isnull(p_doc) or p_xpath is null then

Line 109: if xmldom.isnull(p_doc) or p_xpath is null then

105: (p_doc in xmldom.DOMDocument
106: ,p_xpath in varchar2
107: ) return varchar2 is
108: begin
109: if xmldom.isnull(p_doc) or p_xpath is null then
110: return null;
111: else
112: return valueof(toNode(p_doc), p_xpath);
113: end if;

Line 117: (p_node in xmldom.DOMNode

113: end if;
114: end valueOf;
115: --
116: function selectNodes
117: (p_node in xmldom.DOMNode
118: ,p_xpath in varchar2
119: ) return xmldom.DOMNodeList is
120: begin
121: return xslprocessor.selectNodes(p_node, p_xpath);

Line 119: ) return xmldom.DOMNodeList is

115: --
116: function selectNodes
117: (p_node in xmldom.DOMNode
118: ,p_xpath in varchar2
119: ) return xmldom.DOMNodeList is
120: begin
121: return xslprocessor.selectNodes(p_node, p_xpath);
122: end selectNodes;
123: --

Line 125: (p_doc in xmldom.DOMDocument

121: return xslprocessor.selectNodes(p_node, p_xpath);
122: end selectNodes;
123: --
124: function selectNodes
125: (p_doc in xmldom.DOMDocument
126: ,p_xpath in varchar2
127: ) return xmldom.DOMNodeList is
128: begin
129: return selectNodes(toNode(p_doc), p_xpath);

Line 127: ) return xmldom.DOMNodeList is

123: --
124: function selectNodes
125: (p_doc in xmldom.DOMDocument
126: ,p_xpath in varchar2
127: ) return xmldom.DOMNodeList is
128: begin
129: return selectNodes(toNode(p_doc), p_xpath);
130: end selectNodes;
131: --

Line 191: l_xmldoc xmldom.DOMDocument;

187: l_spare dbms_describe.number_table;
188: --
189: -- Other local variables
190: --
191: l_xmldoc xmldom.DOMDocument;
192: l_api_name varchar2(32);
193: l_api_pkg varchar2(32);
194: l_param_value varchar2(200); -- Value of parameter as listed
195: -- in xml document.

Line 216: l_api_call_list xmldom.DOMNodeList; -- List of nodes pointing to each

212: -- error for the call package
213: -- procedure.
214: l_call_code varchar2(32767) := null;
215: l_declare_code varchar2(32767) := null;
216: l_api_call_list xmldom.DOMNodeList; -- List of nodes pointing to each
217: -- API call in the API Call Set.
218: l_print_length number(15); -- Length position for printing out
219: -- source code for execution.
220: l_proc varchar2(72) := g_package||'call_plsql_api';

Line 228: if not xmldom.isnull(l_xmldoc) then

224: --
225: -- Parse the XML Document
226: --
227: l_xmldoc := parse(p_xml);
228: if not xmldom.isnull(l_xmldoc) then
229: hr_utility.set_location(l_proc, 12);
230: --
231: -- Once only set-up for start of PL/SQL block
232: --

Line 240: for l_num in 1..xmldom.getlength(l_api_call_list) loop

236: --
237: -- Loop for each APICall in the APICallSet
238: --
239: l_api_call_list := selectNodes(l_xmldoc, '/APICallSet/APICall');
240: for l_num in 1..xmldom.getlength(l_api_call_list) loop
241: --
242: -- Obtain the Name of the API to call from the XML Document
243: --
244: l_api_name := valueOf(xmldom.item(l_api_call_list, l_num - 1), 'APIName');

Line 244: l_api_name := valueOf(xmldom.item(l_api_call_list, l_num - 1), 'APIName');

240: for l_num in 1..xmldom.getlength(l_api_call_list) loop
241: --
242: -- Obtain the Name of the API to call from the XML Document
243: --
244: l_api_name := valueOf(xmldom.item(l_api_call_list, l_num - 1), 'APIName');
245: l_api_pkg := valueOf(xmldom.item(l_api_call_list, l_num - 1), 'APIPkg');
246: --
247: -- Above lines before processing sets were:
248: -- l_api_name := valueof(l_xmldoc, '/APICallSet/APICall/APIName');

Line 245: l_api_pkg := valueOf(xmldom.item(l_api_call_list, l_num - 1), 'APIPkg');

241: --
242: -- Obtain the Name of the API to call from the XML Document
243: --
244: l_api_name := valueOf(xmldom.item(l_api_call_list, l_num - 1), 'APIName');
245: l_api_pkg := valueOf(xmldom.item(l_api_call_list, l_num - 1), 'APIPkg');
246: --
247: -- Above lines before processing sets were:
248: -- l_api_name := valueof(l_xmldoc, '/APICallSet/APICall/APIName');
249: -- l_api_pkg := valueof(l_xmldoc, '/APICallSet/APICall/APIPkg');

Line 347: valueOf(xmldom.item(l_api_call_list, l_num - 1), l_argument_name(l_loop));

343: --
344: -- Find if parameter is has value in the XML document
345: --
346: l_param_value :=
347: valueOf(xmldom.item(l_api_call_list, l_num - 1), l_argument_name(l_loop));
348: l_param_link :=
349: valueOf(xmldom.item(l_api_call_list, l_num - 1), l_argument_name(l_loop)||'/@LINK');
350: --
351: -- Processing before sets the above line was:

Line 349: valueOf(xmldom.item(l_api_call_list, l_num - 1), l_argument_name(l_loop)||'/@LINK');

345: --
346: l_param_value :=
347: valueOf(xmldom.item(l_api_call_list, l_num - 1), l_argument_name(l_loop));
348: l_param_link :=
349: valueOf(xmldom.item(l_api_call_list, l_num - 1), l_argument_name(l_loop)||'/@LINK');
350: --
351: -- Processing before sets the above line was:
352: -- l_param_value := valueof(l_xmldoc, '/APICall/' || l_argument_name(l_loop));
353: --

Line 590: end if; -- not xmldom.isnull

586: -- Use dynamic SQL to perform the actual API call
587: --
588:
589: execute_source(l_declare_code || l_call_code);
590: end if; -- not xmldom.isnull
591: hr_utility.set_location(' Leaving:'||l_proc, 220);
592: end call_plsql_api;
593:
594: end az_plsql_xml;