DBA Data[Home] [Help]

APPS.PER_ZA_WSP_XML_GEN_PKG dependencies on XMLDOM

Line 40: type xml_dom_table is table of xmldom.DOMNode index by binary_integer;

36: --
37: g_package constant varchar2(31) := 'PER_ZA_WSP_XML_GEN_PKG.';
38: g_debug boolean;
39: --
40: type xml_dom_table is table of xmldom.DOMNode index by binary_integer;
41: --
42: g_xml_dom xmldom.DOMDocument;
43: g_node_list xml_dom_table;
44: --

Line 42: g_xml_dom xmldom.DOMDocument;

38: g_debug boolean;
39: --
40: type xml_dom_table is table of xmldom.DOMNode index by binary_integer;
41: --
42: g_xml_dom xmldom.DOMDocument;
43: g_node_list xml_dom_table;
44: --
45: g_root_level constant binary_integer := 0;
46: g_company_level constant binary_integer := 1;

Line 105: parent_node xmldom.DOMNode;

101: procedure update_dom( p_name varchar2
102: , p_text varchar2
103: , p_level binary_integer) is
104:
105: parent_node xmldom.DOMNode;
106:
107: item_node xmldom.DOMNode;
108: item_elmt xmldom.DOMElement;
109: item_text xmldom.DOMText;

Line 107: item_node xmldom.DOMNode;

103: , p_level binary_integer) is
104:
105: parent_node xmldom.DOMNode;
106:
107: item_node xmldom.DOMNode;
108: item_elmt xmldom.DOMElement;
109: item_text xmldom.DOMText;
110:
111: begin

Line 108: item_elmt xmldom.DOMElement;

104:
105: parent_node xmldom.DOMNode;
106:
107: item_node xmldom.DOMNode;
108: item_elmt xmldom.DOMElement;
109: item_text xmldom.DOMText;
110:
111: begin
112: parent_node := g_node_list(p_level);

Line 109: item_text xmldom.DOMText;

105: parent_node xmldom.DOMNode;
106:
107: item_node xmldom.DOMNode;
108: item_elmt xmldom.DOMElement;
109: item_text xmldom.DOMText;
110:
111: begin
112: parent_node := g_node_list(p_level);
113:

Line 114: item_elmt := xmldom.createElement(g_xml_dom, p_name);

110:
111: begin
112: parent_node := g_node_list(p_level);
113:
114: item_elmt := xmldom.createElement(g_xml_dom, p_name);
115: item_node := xmldom.appendChild(parent_node, xmldom.makeNode(item_elmt));
116:
117: if p_text is not null
118: then

Line 115: item_node := xmldom.appendChild(parent_node, xmldom.makeNode(item_elmt));

111: begin
112: parent_node := g_node_list(p_level);
113:
114: item_elmt := xmldom.createElement(g_xml_dom, p_name);
115: item_node := xmldom.appendChild(parent_node, xmldom.makeNode(item_elmt));
116:
117: if p_text is not null
118: then
119: item_text := xmldom.createTextNode(g_xml_dom, p_text);

Line 119: item_text := xmldom.createTextNode(g_xml_dom, p_text);

115: item_node := xmldom.appendChild(parent_node, xmldom.makeNode(item_elmt));
116:
117: if p_text is not null
118: then
119: item_text := xmldom.createTextNode(g_xml_dom, p_text);
120: item_node := xmldom.appendChild(item_node, xmldom.makeNode(item_text));
121: end if;
122:
123: g_node_list(p_level+1) := item_node;

Line 120: item_node := xmldom.appendChild(item_node, xmldom.makeNode(item_text));

116:
117: if p_text is not null
118: then
119: item_text := xmldom.createTextNode(g_xml_dom, p_text);
120: item_node := xmldom.appendChild(item_node, xmldom.makeNode(item_text));
121: end if;
122:
123: g_node_list(p_level+1) := item_node;
124: end update_dom;

Line 1009: main_node xmldom.DOMNode;

1005: , p_xml out nocopy clob) is
1006:
1007: l_proc varchar2(100) := g_package || 'populate_xml_data';
1008:
1009: main_node xmldom.DOMNode;
1010: root_node xmldom.DOMNode;
1011: parent_node xmldom.DOMNode;
1012: item_node xmldom.DOMNode;
1013:

Line 1010: root_node xmldom.DOMNode;

1006:
1007: l_proc varchar2(100) := g_package || 'populate_xml_data';
1008:
1009: main_node xmldom.DOMNode;
1010: root_node xmldom.DOMNode;
1011: parent_node xmldom.DOMNode;
1012: item_node xmldom.DOMNode;
1013:
1014: root_elmt xmldom.DOMElement;

Line 1011: parent_node xmldom.DOMNode;

1007: l_proc varchar2(100) := g_package || 'populate_xml_data';
1008:
1009: main_node xmldom.DOMNode;
1010: root_node xmldom.DOMNode;
1011: parent_node xmldom.DOMNode;
1012: item_node xmldom.DOMNode;
1013:
1014: root_elmt xmldom.DOMElement;
1015: item_elmt xmldom.DOMElement;

Line 1012: item_node xmldom.DOMNode;

1008:
1009: main_node xmldom.DOMNode;
1010: root_node xmldom.DOMNode;
1011: parent_node xmldom.DOMNode;
1012: item_node xmldom.DOMNode;
1013:
1014: root_elmt xmldom.DOMElement;
1015: item_elmt xmldom.DOMElement;
1016: item_text xmldom.DOMText;

Line 1014: root_elmt xmldom.DOMElement;

1010: root_node xmldom.DOMNode;
1011: parent_node xmldom.DOMNode;
1012: item_node xmldom.DOMNode;
1013:
1014: root_elmt xmldom.DOMElement;
1015: item_elmt xmldom.DOMElement;
1016: item_text xmldom.DOMText;
1017:
1018: cursor csr_legal_entities is

Line 1015: item_elmt xmldom.DOMElement;

1011: parent_node xmldom.DOMNode;
1012: item_node xmldom.DOMNode;
1013:
1014: root_elmt xmldom.DOMElement;
1015: item_elmt xmldom.DOMElement;
1016: item_text xmldom.DOMText;
1017:
1018: cursor csr_legal_entities is
1019: select distinct action_information2 legal_entity_id -- Legal entity ID

Line 1016: item_text xmldom.DOMText;

1012: item_node xmldom.DOMNode;
1013:
1014: root_elmt xmldom.DOMElement;
1015: item_elmt xmldom.DOMElement;
1016: item_text xmldom.DOMText;
1017:
1018: cursor csr_legal_entities is
1019: select distinct action_information2 legal_entity_id -- Legal entity ID
1020: from pay_action_information

Line 1032: g_xml_dom := xmldom.newDOMDocument;

1028: -- hr_utility.trace_on(null, 'WSP_GEN');
1029: hr_utility.set_location ('Entering ' || l_proc, 10);
1030:
1031: -- Initialize g_xml_dom and create root node
1032: g_xml_dom := xmldom.newDOMDocument;
1033: main_node := xmldom.makeNode(g_xml_dom);
1034: root_elmt := xmldom.createElement(g_xml_dom, 'ZA_WSP_ATR_ROOT');
1035: root_node := xmldom.appendChild(main_node, xmldom.makeNode(root_elmt));
1036: g_node_list(g_root_level) := root_node;

Line 1033: main_node := xmldom.makeNode(g_xml_dom);

1029: hr_utility.set_location ('Entering ' || l_proc, 10);
1030:
1031: -- Initialize g_xml_dom and create root node
1032: g_xml_dom := xmldom.newDOMDocument;
1033: main_node := xmldom.makeNode(g_xml_dom);
1034: root_elmt := xmldom.createElement(g_xml_dom, 'ZA_WSP_ATR_ROOT');
1035: root_node := xmldom.appendChild(main_node, xmldom.makeNode(root_elmt));
1036: g_node_list(g_root_level) := root_node;
1037:

Line 1034: root_elmt := xmldom.createElement(g_xml_dom, 'ZA_WSP_ATR_ROOT');

1030:
1031: -- Initialize g_xml_dom and create root node
1032: g_xml_dom := xmldom.newDOMDocument;
1033: main_node := xmldom.makeNode(g_xml_dom);
1034: root_elmt := xmldom.createElement(g_xml_dom, 'ZA_WSP_ATR_ROOT');
1035: root_node := xmldom.appendChild(main_node, xmldom.makeNode(root_elmt));
1036: g_node_list(g_root_level) := root_node;
1037:
1038: for rec in csr_legal_entities

Line 1035: root_node := xmldom.appendChild(main_node, xmldom.makeNode(root_elmt));

1031: -- Initialize g_xml_dom and create root node
1032: g_xml_dom := xmldom.newDOMDocument;
1033: main_node := xmldom.makeNode(g_xml_dom);
1034: root_elmt := xmldom.createElement(g_xml_dom, 'ZA_WSP_ATR_ROOT');
1035: root_node := xmldom.appendChild(main_node, xmldom.makeNode(root_elmt));
1036: g_node_list(g_root_level) := root_node;
1037:
1038: for rec in csr_legal_entities
1039: loop

Line 1054: xmldom.writeToClob(g_xml_dom, p_xml);

1050: end loop;
1051:
1052: -- Update out variable p_xml and release xml dom
1053: dbms_lob.createtemporary(p_xml, true);
1054: xmldom.writeToClob(g_xml_dom, p_xml);
1055: xmldom.freeDocument(g_xml_dom);
1056: -- open the file p_xml
1057: -- Why ? In the Core wrapper package(PAY_XML_GEN_PKG) this is being closed
1058: dbms_lob.open(p_xml, dbms_lob.lob_readonly);

Line 1055: xmldom.freeDocument(g_xml_dom);

1051:
1052: -- Update out variable p_xml and release xml dom
1053: dbms_lob.createtemporary(p_xml, true);
1054: xmldom.writeToClob(g_xml_dom, p_xml);
1055: xmldom.freeDocument(g_xml_dom);
1056: -- open the file p_xml
1057: -- Why ? In the Core wrapper package(PAY_XML_GEN_PKG) this is being closed
1058: dbms_lob.open(p_xml, dbms_lob.lob_readonly);
1059: