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.CLN_CH_COLLABORATION_PKG dependencies on XMLDOM

Line 29: l_element IN xmldom.domElement,

25: -- Notes
26: -- Only called by get_document_creation_date
27:
28: FUNCTION GET_CHILD_ELEMENT_VALUE(
29: l_element IN xmldom.domElement,
30: l_child_name IN VARCHAR2) RETURN VARCHAR2
31: IS
32: l_child_value VARCHAR2(100);
33: BEGIN

Line 34: l_child_value := xmldom.getNodeValue(xmldom.getFirstChild(xmldom.item( Xmldom.getElementsByTagName(l_element, l_child_name), 0 )));

30: l_child_name IN VARCHAR2) RETURN VARCHAR2
31: IS
32: l_child_value VARCHAR2(100);
33: BEGIN
34: l_child_value := xmldom.getNodeValue(xmldom.getFirstChild(xmldom.item( Xmldom.getElementsByTagName(l_element, l_child_name), 0 )));
35: RETURN l_child_value;
36: EXCEPTION
37: WHEN OTHERS THEN
38: IF (l_Debug_Level <= 1) THEN

Line 63: l_domDoc xmldom.DOMDocument;

59: x_doc_creation_date IN OUT NOCOPY DATE)
60: IS
61: l_xmlDoc CLOB;
62: l_parser xmlparser.parser := xmlparser.newParser;
63: l_domDoc xmldom.DOMDocument;
64: l_node xmldom.domNode;
65: l_element xmldom.domElement;
66: l_nodeList xmldom.domNodeList;
67: l_size number;

Line 64: l_node xmldom.domNode;

60: IS
61: l_xmlDoc CLOB;
62: l_parser xmlparser.parser := xmlparser.newParser;
63: l_domDoc xmldom.DOMDocument;
64: l_node xmldom.domNode;
65: l_element xmldom.domElement;
66: l_nodeList xmldom.domNodeList;
67: l_size number;
68: l_Nname varchar2(255);

Line 65: l_element xmldom.domElement;

61: l_xmlDoc CLOB;
62: l_parser xmlparser.parser := xmlparser.newParser;
63: l_domDoc xmldom.DOMDocument;
64: l_node xmldom.domNode;
65: l_element xmldom.domElement;
66: l_nodeList xmldom.domNodeList;
67: l_size number;
68: l_Nname varchar2(255);
69: l_Nvalue varchar2(255);

Line 66: l_nodeList xmldom.domNodeList;

62: l_parser xmlparser.parser := xmlparser.newParser;
63: l_domDoc xmldom.DOMDocument;
64: l_node xmldom.domNode;
65: l_element xmldom.domElement;
66: l_nodeList xmldom.domNodeList;
67: l_size number;
68: l_Nname varchar2(255);
69: l_Nvalue varchar2(255);
70: l_error_code VARCHAR2(255);

Line 135: l_nodeList := Xmldom.getElementsByTagName(l_domDoc, 'CNTROLAREA');

131: xmlparser.parseClob(l_parser,l_xmlDoc);
132: END IF;
133:
134: l_domDoc := xmlparser.getDocument(l_parser);
135: l_nodeList := Xmldom.getElementsByTagName(l_domDoc, 'CNTROLAREA');
136: l_element := xmldom.makeElement(xmldom.item( l_nodeList, 0 ));
137: l_nodeList := Xmldom.getElementsByTagName(l_element, 'DATETIME');
138: l_element := xmldom.makeElement(xmldom.item( l_nodeList, 0 ));
139:

Line 136: l_element := xmldom.makeElement(xmldom.item( l_nodeList, 0 ));

132: END IF;
133:
134: l_domDoc := xmlparser.getDocument(l_parser);
135: l_nodeList := Xmldom.getElementsByTagName(l_domDoc, 'CNTROLAREA');
136: l_element := xmldom.makeElement(xmldom.item( l_nodeList, 0 ));
137: l_nodeList := Xmldom.getElementsByTagName(l_element, 'DATETIME');
138: l_element := xmldom.makeElement(xmldom.item( l_nodeList, 0 ));
139:
140: IF (l_Debug_Level <= 1) THEN

Line 137: l_nodeList := Xmldom.getElementsByTagName(l_element, 'DATETIME');

133:
134: l_domDoc := xmlparser.getDocument(l_parser);
135: l_nodeList := Xmldom.getElementsByTagName(l_domDoc, 'CNTROLAREA');
136: l_element := xmldom.makeElement(xmldom.item( l_nodeList, 0 ));
137: l_nodeList := Xmldom.getElementsByTagName(l_element, 'DATETIME');
138: l_element := xmldom.makeElement(xmldom.item( l_nodeList, 0 ));
139:
140: IF (l_Debug_Level <= 1) THEN
141: ecx_cln_debug_pub.Add('About to get values of child elements of DATETIME', 1);

Line 138: l_element := xmldom.makeElement(xmldom.item( l_nodeList, 0 ));

134: l_domDoc := xmlparser.getDocument(l_parser);
135: l_nodeList := Xmldom.getElementsByTagName(l_domDoc, 'CNTROLAREA');
136: l_element := xmldom.makeElement(xmldom.item( l_nodeList, 0 ));
137: l_nodeList := Xmldom.getElementsByTagName(l_element, 'DATETIME');
138: l_element := xmldom.makeElement(xmldom.item( l_nodeList, 0 ));
139:
140: IF (l_Debug_Level <= 1) THEN
141: ecx_cln_debug_pub.Add('About to get values of child elements of DATETIME', 1);
142: END IF;

Line 243: l_domDoc xmldom.DOMDocument;

239: )
240: IS
241: l_xmlDoc CLOB;
242: l_parser xmlparser.parser := xmlparser.newParser;
243: l_domDoc xmldom.DOMDocument;
244: l_node xmldom.domNode;
245: l_element xmldom.domElement;
246: l_nodeList xmldom.domNodeList;
247: l_size number;

Line 244: l_node xmldom.domNode;

240: IS
241: l_xmlDoc CLOB;
242: l_parser xmlparser.parser := xmlparser.newParser;
243: l_domDoc xmldom.DOMDocument;
244: l_node xmldom.domNode;
245: l_element xmldom.domElement;
246: l_nodeList xmldom.domNodeList;
247: l_size number;
248: l_Nname varchar2(255);

Line 245: l_element xmldom.domElement;

241: l_xmlDoc CLOB;
242: l_parser xmlparser.parser := xmlparser.newParser;
243: l_domDoc xmldom.DOMDocument;
244: l_node xmldom.domNode;
245: l_element xmldom.domElement;
246: l_nodeList xmldom.domNodeList;
247: l_size number;
248: l_Nname varchar2(255);
249: l_Nvalue varchar2(255);

Line 246: l_nodeList xmldom.domNodeList;

242: l_parser xmlparser.parser := xmlparser.newParser;
243: l_domDoc xmldom.DOMDocument;
244: l_node xmldom.domNode;
245: l_element xmldom.domElement;
246: l_nodeList xmldom.domNodeList;
247: l_size number;
248: l_Nname varchar2(255);
249: l_Nvalue varchar2(255);
250: l_error_code VARCHAR2(255);

Line 315: l_nodeList := Xmldom.getElementsByTagName(l_domDoc, 'CNTROLAREA');

311: END IF;
312:
313: l_domDoc := xmlparser.getDocument(l_parser);
314: IF(p_collaboration_standard = 'OAG') THEN
315: l_nodeList := Xmldom.getElementsByTagName(l_domDoc, 'CNTROLAREA');
316: l_element := xmldom.makeElement(xmldom.item( l_nodeList, 0 ));
317: l_nodeList := Xmldom.getElementsByTagName(l_element, 'REFERENCEID');
318: ELSIF (p_collaboration_standard = 'ROSETTANET') THEN
319: l_nodeList := Xmldom.getElementsByTagName(l_domDoc, 'thisDocumentIdentifier');

Line 316: l_element := xmldom.makeElement(xmldom.item( l_nodeList, 0 ));

312:
313: l_domDoc := xmlparser.getDocument(l_parser);
314: IF(p_collaboration_standard = 'OAG') THEN
315: l_nodeList := Xmldom.getElementsByTagName(l_domDoc, 'CNTROLAREA');
316: l_element := xmldom.makeElement(xmldom.item( l_nodeList, 0 ));
317: l_nodeList := Xmldom.getElementsByTagName(l_element, 'REFERENCEID');
318: ELSIF (p_collaboration_standard = 'ROSETTANET') THEN
319: l_nodeList := Xmldom.getElementsByTagName(l_domDoc, 'thisDocumentIdentifier');
320: l_element := xmldom.makeElement(xmldom.item( l_nodeList, 0 ));

Line 317: l_nodeList := Xmldom.getElementsByTagName(l_element, 'REFERENCEID');

313: l_domDoc := xmlparser.getDocument(l_parser);
314: IF(p_collaboration_standard = 'OAG') THEN
315: l_nodeList := Xmldom.getElementsByTagName(l_domDoc, 'CNTROLAREA');
316: l_element := xmldom.makeElement(xmldom.item( l_nodeList, 0 ));
317: l_nodeList := Xmldom.getElementsByTagName(l_element, 'REFERENCEID');
318: ELSIF (p_collaboration_standard = 'ROSETTANET') THEN
319: l_nodeList := Xmldom.getElementsByTagName(l_domDoc, 'thisDocumentIdentifier');
320: l_element := xmldom.makeElement(xmldom.item( l_nodeList, 0 ));
321: l_nodeList := Xmldom.getElementsByTagName(l_element, 'ProprietaryDocumentIdentifier');

Line 319: l_nodeList := Xmldom.getElementsByTagName(l_domDoc, 'thisDocumentIdentifier');

315: l_nodeList := Xmldom.getElementsByTagName(l_domDoc, 'CNTROLAREA');
316: l_element := xmldom.makeElement(xmldom.item( l_nodeList, 0 ));
317: l_nodeList := Xmldom.getElementsByTagName(l_element, 'REFERENCEID');
318: ELSIF (p_collaboration_standard = 'ROSETTANET') THEN
319: l_nodeList := Xmldom.getElementsByTagName(l_domDoc, 'thisDocumentIdentifier');
320: l_element := xmldom.makeElement(xmldom.item( l_nodeList, 0 ));
321: l_nodeList := Xmldom.getElementsByTagName(l_element, 'ProprietaryDocumentIdentifier');
322: ELSE
323: IF (l_Debug_Level <= 2) THEN

Line 320: l_element := xmldom.makeElement(xmldom.item( l_nodeList, 0 ));

316: l_element := xmldom.makeElement(xmldom.item( l_nodeList, 0 ));
317: l_nodeList := Xmldom.getElementsByTagName(l_element, 'REFERENCEID');
318: ELSIF (p_collaboration_standard = 'ROSETTANET') THEN
319: l_nodeList := Xmldom.getElementsByTagName(l_domDoc, 'thisDocumentIdentifier');
320: l_element := xmldom.makeElement(xmldom.item( l_nodeList, 0 ));
321: l_nodeList := Xmldom.getElementsByTagName(l_element, 'ProprietaryDocumentIdentifier');
322: ELSE
323: IF (l_Debug_Level <= 2) THEN
324: ecx_cln_debug_pub.Add('-----------EXITING GET_APP_REFID as the collaboration standard is not supported-----------', 1);

Line 321: l_nodeList := Xmldom.getElementsByTagName(l_element, 'ProprietaryDocumentIdentifier');

317: l_nodeList := Xmldom.getElementsByTagName(l_element, 'REFERENCEID');
318: ELSIF (p_collaboration_standard = 'ROSETTANET') THEN
319: l_nodeList := Xmldom.getElementsByTagName(l_domDoc, 'thisDocumentIdentifier');
320: l_element := xmldom.makeElement(xmldom.item( l_nodeList, 0 ));
321: l_nodeList := Xmldom.getElementsByTagName(l_element, 'ProprietaryDocumentIdentifier');
322: ELSE
323: IF (l_Debug_Level <= 2) THEN
324: ecx_cln_debug_pub.Add('-----------EXITING GET_APP_REFID as the collaboration standard is not supported-----------', 1);
325: END IF;

Line 328: l_node := xmldom.item( l_nodeList, 0 );

324: ecx_cln_debug_pub.Add('-----------EXITING GET_APP_REFID as the collaboration standard is not supported-----------', 1);
325: END IF;
326: RETURN;
327: END IF;
328: l_node := xmldom.item( l_nodeList, 0 );
329: l_Nvalue := xmldom.getNodeName(l_node);
330: l_node := xmldom.getFirstChild(l_node);
331:
332: IF NOT xmldom.IsNull(l_node) THEN

Line 329: l_Nvalue := xmldom.getNodeName(l_node);

325: END IF;
326: RETURN;
327: END IF;
328: l_node := xmldom.item( l_nodeList, 0 );
329: l_Nvalue := xmldom.getNodeName(l_node);
330: l_node := xmldom.getFirstChild(l_node);
331:
332: IF NOT xmldom.IsNull(l_node) THEN
333: l_error_code := SQLCODE;

Line 330: l_node := xmldom.getFirstChild(l_node);

326: RETURN;
327: END IF;
328: l_node := xmldom.item( l_nodeList, 0 );
329: l_Nvalue := xmldom.getNodeName(l_node);
330: l_node := xmldom.getFirstChild(l_node);
331:
332: IF NOT xmldom.IsNull(l_node) THEN
333: l_error_code := SQLCODE;
334: l_error_msg := SQLERRM;

Line 332: IF NOT xmldom.IsNull(l_node) THEN

328: l_node := xmldom.item( l_nodeList, 0 );
329: l_Nvalue := xmldom.getNodeName(l_node);
330: l_node := xmldom.getFirstChild(l_node);
331:
332: IF NOT xmldom.IsNull(l_node) THEN
333: l_error_code := SQLCODE;
334: l_error_msg := SQLERRM;
335: l_msg_data := l_error_code||' : '||l_error_msg;
336: IF (l_Debug_Level <= 5) THEN

Line 339: x_app_ref_id := xmldom.getNodeValue(l_node);

335: l_msg_data := l_error_code||' : '||l_error_msg;
336: IF (l_Debug_Level <= 5) THEN
337: ecx_cln_debug_pub.Add(l_msg_data,6);
338: END IF;
339: x_app_ref_id := xmldom.getNodeValue(l_node);
340: IF(p_collaboration_standard = 'ROSETTANET' and p_app_id is not null and p_coll_type is not null and x_app_ref_id is not null) THEN
341: x_app_ref_id := p_app_id || p_coll_type || x_app_ref_id;
342: END IF;
343: END IF;

Line 395: l_domDoc xmldom.DOMDocument;

391: p_coll_type IN VARCHAR2)
392: IS
393: l_xmlDoc CLOB;
394: l_parser xmlparser.parser := xmlparser.newParser;
395: l_domDoc xmldom.DOMDocument;
396: l_node xmldom.domNode;
397: l_element xmldom.domElement;
398: l_nodeList xmldom.domNodeList;
399: l_size number;

Line 396: l_node xmldom.domNode;

392: IS
393: l_xmlDoc CLOB;
394: l_parser xmlparser.parser := xmlparser.newParser;
395: l_domDoc xmldom.DOMDocument;
396: l_node xmldom.domNode;
397: l_element xmldom.domElement;
398: l_nodeList xmldom.domNodeList;
399: l_size number;
400: l_Nname varchar2(255);

Line 397: l_element xmldom.domElement;

393: l_xmlDoc CLOB;
394: l_parser xmlparser.parser := xmlparser.newParser;
395: l_domDoc xmldom.DOMDocument;
396: l_node xmldom.domNode;
397: l_element xmldom.domElement;
398: l_nodeList xmldom.domNodeList;
399: l_size number;
400: l_Nname varchar2(255);
401: l_Nvalue varchar2(255);

Line 398: l_nodeList xmldom.domNodeList;

394: l_parser xmlparser.parser := xmlparser.newParser;
395: l_domDoc xmldom.DOMDocument;
396: l_node xmldom.domNode;
397: l_element xmldom.domElement;
398: l_nodeList xmldom.domNodeList;
399: l_size number;
400: l_Nname varchar2(255);
401: l_Nvalue varchar2(255);
402: l_error_code VARCHAR2(255);

Line 483: l_nodeList := Xmldom.getElementsByTagName(l_domDoc, 'DATAAREA');

479: IF (l_Debug_Level <= 1) THEN
480: ecx_cln_debug_pub.Add('dom doc obtained', 1);
481: END IF;
482: IF(p_collaboration_standard = 'OAG') THEN
483: l_nodeList := Xmldom.getElementsByTagName(l_domDoc, 'DATAAREA');
484: IF (l_Debug_Level <= 1) THEN
485: ecx_cln_debug_pub.Add('IN OAG, data area found', 1);
486: END IF;
487: l_element := xmldom.makeElement(xmldom.item( l_nodeList, 0 ));

Line 487: l_element := xmldom.makeElement(xmldom.item( l_nodeList, 0 ));

483: l_nodeList := Xmldom.getElementsByTagName(l_domDoc, 'DATAAREA');
484: IF (l_Debug_Level <= 1) THEN
485: ecx_cln_debug_pub.Add('IN OAG, data area found', 1);
486: END IF;
487: l_element := xmldom.makeElement(xmldom.item( l_nodeList, 0 ));
488: IF (l_Debug_Level <= 1) THEN
489: ecx_cln_debug_pub.Add('data area element obtained', 1);
490: END IF;
491: l_nodeList := Xmldom.getElementsByTagName(l_element, 'REFERENCEID');

Line 491: l_nodeList := Xmldom.getElementsByTagName(l_element, 'REFERENCEID');

487: l_element := xmldom.makeElement(xmldom.item( l_nodeList, 0 ));
488: IF (l_Debug_Level <= 1) THEN
489: ecx_cln_debug_pub.Add('data area element obtained', 1);
490: END IF;
491: l_nodeList := Xmldom.getElementsByTagName(l_element, 'REFERENCEID');
492: IF (l_Debug_Level <= 1) THEN
493: ecx_cln_debug_pub.Add('Reference id element obtained', 1);
494: END IF;
495: ELSIF (p_collaboration_standard = 'ROSETTANET') THEN

Line 496: l_nodeList := Xmldom.getElementsByTagName(l_domDoc, 'requestingDocumentIdentifier');

492: IF (l_Debug_Level <= 1) THEN
493: ecx_cln_debug_pub.Add('Reference id element obtained', 1);
494: END IF;
495: ELSIF (p_collaboration_standard = 'ROSETTANET') THEN
496: l_nodeList := Xmldom.getElementsByTagName(l_domDoc, 'requestingDocumentIdentifier');
497: l_element := xmldom.makeElement(xmldom.item( l_nodeList, 0 ));
498: l_nodeList := Xmldom.getElementsByTagName(l_element, 'ProprietaryDocumentIdentifier');
499: ELSE
500: IF (l_Debug_Level <= 2) THEN

Line 497: l_element := xmldom.makeElement(xmldom.item( l_nodeList, 0 ));

493: ecx_cln_debug_pub.Add('Reference id element obtained', 1);
494: END IF;
495: ELSIF (p_collaboration_standard = 'ROSETTANET') THEN
496: l_nodeList := Xmldom.getElementsByTagName(l_domDoc, 'requestingDocumentIdentifier');
497: l_element := xmldom.makeElement(xmldom.item( l_nodeList, 0 ));
498: l_nodeList := Xmldom.getElementsByTagName(l_element, 'ProprietaryDocumentIdentifier');
499: ELSE
500: IF (l_Debug_Level <= 2) THEN
501: ecx_cln_debug_pub.Add('-----------EXITING GET_APP_REFID as the collaboration standard is not supported-----------', 1);

Line 498: l_nodeList := Xmldom.getElementsByTagName(l_element, 'ProprietaryDocumentIdentifier');

494: END IF;
495: ELSIF (p_collaboration_standard = 'ROSETTANET') THEN
496: l_nodeList := Xmldom.getElementsByTagName(l_domDoc, 'requestingDocumentIdentifier');
497: l_element := xmldom.makeElement(xmldom.item( l_nodeList, 0 ));
498: l_nodeList := Xmldom.getElementsByTagName(l_element, 'ProprietaryDocumentIdentifier');
499: ELSE
500: IF (l_Debug_Level <= 2) THEN
501: ecx_cln_debug_pub.Add('-----------EXITING GET_APP_REFID as the collaboration standard is not supported-----------', 1);
502: END IF;

Line 506: l_node := xmldom.item( l_nodeList, 0 );

502: END IF;
503: RETURN;
504: END IF;
505:
506: l_node := xmldom.item( l_nodeList, 0 );
507: l_Nvalue := xmldom.getNodeName(l_node);
508: l_node := xmldom.getFirstChild(l_node);
509:
510: IF NOT xmldom.IsNull(l_node) THEN

Line 507: l_Nvalue := xmldom.getNodeName(l_node);

503: RETURN;
504: END IF;
505:
506: l_node := xmldom.item( l_nodeList, 0 );
507: l_Nvalue := xmldom.getNodeName(l_node);
508: l_node := xmldom.getFirstChild(l_node);
509:
510: IF NOT xmldom.IsNull(l_node) THEN
511: IF (l_Debug_Level <= 1) THEN

Line 508: l_node := xmldom.getFirstChild(l_node);

504: END IF;
505:
506: l_node := xmldom.item( l_nodeList, 0 );
507: l_Nvalue := xmldom.getNodeName(l_node);
508: l_node := xmldom.getFirstChild(l_node);
509:
510: IF NOT xmldom.IsNull(l_node) THEN
511: IF (l_Debug_Level <= 1) THEN
512: ecx_cln_debug_pub.Add('about to obtain the value from the node, as node is not null', 1);

Line 510: IF NOT xmldom.IsNull(l_node) THEN

506: l_node := xmldom.item( l_nodeList, 0 );
507: l_Nvalue := xmldom.getNodeName(l_node);
508: l_node := xmldom.getFirstChild(l_node);
509:
510: IF NOT xmldom.IsNull(l_node) THEN
511: IF (l_Debug_Level <= 1) THEN
512: ecx_cln_debug_pub.Add('about to obtain the value from the node, as node is not null', 1);
513: END IF;
514: x_app_ref_id := xmldom.getNodeValue(l_node);

Line 514: x_app_ref_id := xmldom.getNodeValue(l_node);

510: IF NOT xmldom.IsNull(l_node) THEN
511: IF (l_Debug_Level <= 1) THEN
512: ecx_cln_debug_pub.Add('about to obtain the value from the node, as node is not null', 1);
513: END IF;
514: x_app_ref_id := xmldom.getNodeValue(l_node);
515: IF (l_Debug_Level <= 1) THEN
516: ecx_cln_debug_pub.Add('x_app_ref_id:' || x_app_ref_id, 1);
517: END IF;
518: IF(p_collaboration_standard = 'ROSETTANET' and p_app_id is not null and p_coll_type is not null and x_app_ref_id is not null) THEN