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

Line 16: queryCtx DBMS_XMLQuery.ctxType;

12: p_retcode OUT NOCOPY NUMBER,
13: p_business_group_id IN NUMBER,
14: p_client_id IN NUMBER) IS
15:
16: queryCtx DBMS_XMLQuery.ctxType;
17: xmlString1 CLOB := NULL;
18:
19: xmlString2 CLOB := NULL;
20: dtdString CLOB := NULL;

Line 99: queryCtx := DBMS_XMLQuery.newContext(l_query_string);

95: ' attribute20, ' ||
96: ' :q_client_id client_id ' ||
97: ' from hr_h2pi_locations_v ' ||
98: ' where ( business_group_id = :q_bg_id OR business_group_id is null)';
99: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
100: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
101: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
102: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_LOCATIONS');
103: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);

Line 100: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);

96: ' :q_client_id client_id ' ||
97: ' from hr_h2pi_locations_v ' ||
98: ' where ( business_group_id = :q_bg_id OR business_group_id is null)';
99: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
100: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
101: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
102: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_LOCATIONS');
103: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
104: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);

Line 101: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);

97: ' from hr_h2pi_locations_v ' ||
98: ' where ( business_group_id = :q_bg_id OR business_group_id is null)';
99: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
100: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
101: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
102: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_LOCATIONS');
103: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
104: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
105: hr_h2pi_download.write(x,y,xmlstring1);

Line 102: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_LOCATIONS');

98: ' where ( business_group_id = :q_bg_id OR business_group_id is null)';
99: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
100: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
101: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
102: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_LOCATIONS');
103: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
104: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
105: hr_h2pi_download.write(x,y,xmlstring1);
106: DBMS_XMLQuery.closeContext(queryCtx);

Line 103: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);

99: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
100: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
101: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
102: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_LOCATIONS');
103: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
104: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
105: hr_h2pi_download.write(x,y,xmlstring1);
106: DBMS_XMLQuery.closeContext(queryCtx);
107: xmlString1 := null;

Line 104: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);

100: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
101: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
102: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_LOCATIONS');
103: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
104: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
105: hr_h2pi_download.write(x,y,xmlstring1);
106: DBMS_XMLQuery.closeContext(queryCtx);
107: xmlString1 := null;
108: hr_utility.set_location(l_proc,70);

Line 106: DBMS_XMLQuery.closeContext(queryCtx);

102: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_LOCATIONS');
103: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
104: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
105: hr_h2pi_download.write(x,y,xmlstring1);
106: DBMS_XMLQuery.closeContext(queryCtx);
107: xmlString1 := null;
108: hr_utility.set_location(l_proc,70);
109: --
110:

Line 122: queryCtx := DBMS_XMLQuery.newContext('select pay.*,:q_client_id client_id ' ||

118: --
119: -- For HR_H2PI_PAY_BASES_V VIEW
120: --
121: hr_utility.set_location(l_proc,100);
122: queryCtx := DBMS_XMLQuery.newContext('select pay.*,:q_client_id client_id ' ||
123: ' from hr_h2pi_pay_bases_v pay ' ||
124: ' where business_group_id = :q_bg_id ' );
125: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_PAY_BASES');
126: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);

Line 125: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_PAY_BASES');

121: hr_utility.set_location(l_proc,100);
122: queryCtx := DBMS_XMLQuery.newContext('select pay.*,:q_client_id client_id ' ||
123: ' from hr_h2pi_pay_bases_v pay ' ||
124: ' where business_group_id = :q_bg_id ' );
125: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_PAY_BASES');
126: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
127: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
128: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
129: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);

Line 126: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);

122: queryCtx := DBMS_XMLQuery.newContext('select pay.*,:q_client_id client_id ' ||
123: ' from hr_h2pi_pay_bases_v pay ' ||
124: ' where business_group_id = :q_bg_id ' );
125: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_PAY_BASES');
126: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
127: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
128: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
129: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
130: hr_h2pi_download.write(x,y,xmlstring1);

Line 127: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);

123: ' from hr_h2pi_pay_bases_v pay ' ||
124: ' where business_group_id = :q_bg_id ' );
125: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_PAY_BASES');
126: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
127: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
128: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
129: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
130: hr_h2pi_download.write(x,y,xmlstring1);
131: DBMS_XMLQuery.closeContext(queryCtx);

Line 128: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);

124: ' where business_group_id = :q_bg_id ' );
125: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_PAY_BASES');
126: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
127: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
128: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
129: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
130: hr_h2pi_download.write(x,y,xmlstring1);
131: DBMS_XMLQuery.closeContext(queryCtx);
132: xmlString1 := null;

Line 129: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);

125: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_PAY_BASES');
126: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
127: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
128: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
129: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
130: hr_h2pi_download.write(x,y,xmlstring1);
131: DBMS_XMLQuery.closeContext(queryCtx);
132: xmlString1 := null;
133: hr_utility.set_location(l_proc,110);

Line 131: DBMS_XMLQuery.closeContext(queryCtx);

127: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
128: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
129: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
130: hr_h2pi_download.write(x,y,xmlstring1);
131: DBMS_XMLQuery.closeContext(queryCtx);
132: xmlString1 := null;
133: hr_utility.set_location(l_proc,110);
134: --
135:

Line 143: queryCtx := DBMS_XMLQuery.newContext('select pay.*,:q_client_id client_id from hr_h2pi_payrolls_v pay where business_group_id = :q_bg_id');

139: --
140: -- For HR_H2PI_PAYROLLS_V VIEW
141: --
142: hr_utility.set_location(l_proc,140);
143: queryCtx := DBMS_XMLQuery.newContext('select pay.*,:q_client_id client_id from hr_h2pi_payrolls_v pay where business_group_id = :q_bg_id');
144: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_PAYROLLS');
145: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
146: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
147: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);

Line 144: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_PAYROLLS');

140: -- For HR_H2PI_PAYROLLS_V VIEW
141: --
142: hr_utility.set_location(l_proc,140);
143: queryCtx := DBMS_XMLQuery.newContext('select pay.*,:q_client_id client_id from hr_h2pi_payrolls_v pay where business_group_id = :q_bg_id');
144: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_PAYROLLS');
145: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
146: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
147: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
148: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);

Line 145: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);

141: --
142: hr_utility.set_location(l_proc,140);
143: queryCtx := DBMS_XMLQuery.newContext('select pay.*,:q_client_id client_id from hr_h2pi_payrolls_v pay where business_group_id = :q_bg_id');
144: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_PAYROLLS');
145: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
146: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
147: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
148: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
149: hr_h2pi_download.write(x,y,xmlstring1);

Line 146: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);

142: hr_utility.set_location(l_proc,140);
143: queryCtx := DBMS_XMLQuery.newContext('select pay.*,:q_client_id client_id from hr_h2pi_payrolls_v pay where business_group_id = :q_bg_id');
144: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_PAYROLLS');
145: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
146: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
147: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
148: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
149: hr_h2pi_download.write(x,y,xmlstring1);
150: DBMS_XMLQuery.closeContext(queryCtx);

Line 147: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);

143: queryCtx := DBMS_XMLQuery.newContext('select pay.*,:q_client_id client_id from hr_h2pi_payrolls_v pay where business_group_id = :q_bg_id');
144: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_PAYROLLS');
145: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
146: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
147: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
148: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
149: hr_h2pi_download.write(x,y,xmlstring1);
150: DBMS_XMLQuery.closeContext(queryCtx);
151: xmlString1 := null;

Line 148: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);

144: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_PAYROLLS');
145: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
146: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
147: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
148: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
149: hr_h2pi_download.write(x,y,xmlstring1);
150: DBMS_XMLQuery.closeContext(queryCtx);
151: xmlString1 := null;
152: hr_utility.set_location(l_proc,150);

Line 150: DBMS_XMLQuery.closeContext(queryCtx);

146: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
147: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
148: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
149: hr_h2pi_download.write(x,y,xmlstring1);
150: DBMS_XMLQuery.closeContext(queryCtx);
151: xmlString1 := null;
152: hr_utility.set_location(l_proc,150);
153: --
154:

Line 159: queryCtx := DBMS_XMLQuery.newContext(

155: --
156: -- For HR_H2PI_ELEMENT_TYPES_V VIEW
157: --
158: hr_utility.set_location(l_proc,160);
159: queryCtx := DBMS_XMLQuery.newContext(
160: 'select last_upd_date, element_type_id, ' ||
161: ' business_group_id, ' ||
162: ' element_name, processing_type, ' ||
163: ' effective_start_date, effective_end_date, ' ||

Line 177: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ELEMENT_TYPES');

173: ' et1.legislation_code ' ||
174: ' from pay_element_types_f et1 ' ||
175: ' where et1.business_group_id is null ' ||
176: ' and et1.legislation_code = ''US'' ' );
177: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ELEMENT_TYPES');
178: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
179: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
180: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id1',p_client_id);
181: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);

Line 178: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);

174: ' from pay_element_types_f et1 ' ||
175: ' where et1.business_group_id is null ' ||
176: ' and et1.legislation_code = ''US'' ' );
177: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ELEMENT_TYPES');
178: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
179: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
180: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id1',p_client_id);
181: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
182: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);

Line 179: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);

175: ' where et1.business_group_id is null ' ||
176: ' and et1.legislation_code = ''US'' ' );
177: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ELEMENT_TYPES');
178: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
179: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
180: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id1',p_client_id);
181: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
182: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
183: hr_h2pi_download.write(x,y,xmlstring1);

Line 180: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id1',p_client_id);

176: ' and et1.legislation_code = ''US'' ' );
177: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ELEMENT_TYPES');
178: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
179: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
180: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id1',p_client_id);
181: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
182: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
183: hr_h2pi_download.write(x,y,xmlstring1);
184: DBMS_XMLQuery.closeContext(queryCtx);

Line 181: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);

177: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ELEMENT_TYPES');
178: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
179: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
180: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id1',p_client_id);
181: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
182: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
183: hr_h2pi_download.write(x,y,xmlstring1);
184: DBMS_XMLQuery.closeContext(queryCtx);
185: xmlString1 := null;

Line 182: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);

178: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
179: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
180: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id1',p_client_id);
181: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
182: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
183: hr_h2pi_download.write(x,y,xmlstring1);
184: DBMS_XMLQuery.closeContext(queryCtx);
185: xmlString1 := null;
186: hr_utility.set_location(l_proc,170);

Line 184: DBMS_XMLQuery.closeContext(queryCtx);

180: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id1',p_client_id);
181: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
182: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
183: hr_h2pi_download.write(x,y,xmlstring1);
184: DBMS_XMLQuery.closeContext(queryCtx);
185: xmlString1 := null;
186: hr_utility.set_location(l_proc,170);
187: --
188:

Line 193: queryCtx := DBMS_XMLQuery.newContext(

189: --
190: -- For HR_H2PI_INPUT_VALUES_V VIEW
191: --
192: hr_utility.set_location(l_proc,180);
193: queryCtx := DBMS_XMLQuery.newContext(
194: 'select iv.last_upd_date, ' ||
195: ' iv.business_group_id, ' ||
196: ' iv.element_type_id, iv.effective_start_date, ' ||
197: ' iv.effective_end_date, iv.input_value_id, ' ||

Line 218: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_INPUT_VALUES');

214: ' and iv.business_group_id is null ' ||
215: ' and iv.legislation_code = ''US'' ' ||
216: ' and iv.effective_start_date between ' ||
217: ' et.effective_start_date and et.effective_end_date ' );
218: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_INPUT_VALUES');
219: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
220: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
221: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id1',p_client_id);
222: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);

Line 219: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);

215: ' and iv.legislation_code = ''US'' ' ||
216: ' and iv.effective_start_date between ' ||
217: ' et.effective_start_date and et.effective_end_date ' );
218: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_INPUT_VALUES');
219: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
220: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
221: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id1',p_client_id);
222: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
223: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);

Line 220: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);

216: ' and iv.effective_start_date between ' ||
217: ' et.effective_start_date and et.effective_end_date ' );
218: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_INPUT_VALUES');
219: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
220: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
221: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id1',p_client_id);
222: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
223: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
224: hr_h2pi_download.write(x,y,xmlstring1);

Line 221: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id1',p_client_id);

217: ' et.effective_start_date and et.effective_end_date ' );
218: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_INPUT_VALUES');
219: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
220: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
221: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id1',p_client_id);
222: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
223: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
224: hr_h2pi_download.write(x,y,xmlstring1);
225: DBMS_XMLQuery.closeContext(queryCtx);

Line 222: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);

218: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_INPUT_VALUES');
219: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
220: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
221: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id1',p_client_id);
222: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
223: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
224: hr_h2pi_download.write(x,y,xmlstring1);
225: DBMS_XMLQuery.closeContext(queryCtx);
226: xmlString1 := null;

Line 223: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);

219: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
220: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
221: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id1',p_client_id);
222: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
223: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
224: hr_h2pi_download.write(x,y,xmlstring1);
225: DBMS_XMLQuery.closeContext(queryCtx);
226: xmlString1 := null;
227: hr_utility.set_location(l_proc,190);

Line 225: DBMS_XMLQuery.closeContext(queryCtx);

221: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id1',p_client_id);
222: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
223: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
224: hr_h2pi_download.write(x,y,xmlstring1);
225: DBMS_XMLQuery.closeContext(queryCtx);
226: xmlString1 := null;
227: hr_utility.set_location(l_proc,190);
228: --
229:

Line 234: queryCtx := DBMS_XMLQuery.newContext(

230: --
231: -- For HR_H2PI_ELEMENT_LINKS_V VIEW
232: --
233: hr_utility.set_location(l_proc,200);
234: queryCtx := DBMS_XMLQuery.newContext(
235: 'select el.last_update_date last_upd_date, ' ||
236: ' el.element_link_id, ' ||
237: ' el.business_group_id, el.effective_start_date, ' ||
238: ' el.effective_end_date, el.payroll_id, ' ||

Line 247: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ELEMENT_LINKS');

243: ' pay_element_types_f et ' ||
244: ' where el.business_group_id = :q_bg_id ' ||
245: ' and et.element_type_id = el.element_type_id ' ||
246: ' and (el.attribute2 = ''Y'' OR et.business_group_id IS NULL)');
247: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ELEMENT_LINKS');
248: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
249: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
250: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
251: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);

Line 248: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);

244: ' where el.business_group_id = :q_bg_id ' ||
245: ' and et.element_type_id = el.element_type_id ' ||
246: ' and (el.attribute2 = ''Y'' OR et.business_group_id IS NULL)');
247: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ELEMENT_LINKS');
248: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
249: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
250: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
251: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
252: hr_h2pi_download.write(x,y,xmlstring1);

Line 249: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);

245: ' and et.element_type_id = el.element_type_id ' ||
246: ' and (el.attribute2 = ''Y'' OR et.business_group_id IS NULL)');
247: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ELEMENT_LINKS');
248: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
249: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
250: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
251: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
252: hr_h2pi_download.write(x,y,xmlstring1);
253: DBMS_XMLQuery.closeContext(queryCtx);

Line 250: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);

246: ' and (el.attribute2 = ''Y'' OR et.business_group_id IS NULL)');
247: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ELEMENT_LINKS');
248: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
249: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
250: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
251: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
252: hr_h2pi_download.write(x,y,xmlstring1);
253: DBMS_XMLQuery.closeContext(queryCtx);
254: xmlString1 := null;

Line 251: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);

247: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ELEMENT_LINKS');
248: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
249: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
250: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
251: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
252: hr_h2pi_download.write(x,y,xmlstring1);
253: DBMS_XMLQuery.closeContext(queryCtx);
254: xmlString1 := null;
255: hr_utility.set_location(l_proc,210);

Line 253: DBMS_XMLQuery.closeContext(queryCtx);

249: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
250: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
251: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
252: hr_h2pi_download.write(x,y,xmlstring1);
253: DBMS_XMLQuery.closeContext(queryCtx);
254: xmlString1 := null;
255: hr_utility.set_location(l_proc,210);
256: --
257:

Line 262: queryCtx := DBMS_XMLQuery.newContext('select bg.*,:q_client_id client_id from hr_h2pi_bg_and_gre_v bg where business_group_id = :q_bg_id');

258: --
259: -- For HR_H2PI_BG_AND_GRE_V VIEW
260: --
261: hr_utility.set_location(l_proc,220);
262: queryCtx := DBMS_XMLQuery.newContext('select bg.*,:q_client_id client_id from hr_h2pi_bg_and_gre_v bg where business_group_id = :q_bg_id');
263: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_BG_AND_GRE');
264: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
265: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
266: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);

Line 263: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_BG_AND_GRE');

259: -- For HR_H2PI_BG_AND_GRE_V VIEW
260: --
261: hr_utility.set_location(l_proc,220);
262: queryCtx := DBMS_XMLQuery.newContext('select bg.*,:q_client_id client_id from hr_h2pi_bg_and_gre_v bg where business_group_id = :q_bg_id');
263: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_BG_AND_GRE');
264: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
265: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
266: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
267: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);

Line 264: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);

260: --
261: hr_utility.set_location(l_proc,220);
262: queryCtx := DBMS_XMLQuery.newContext('select bg.*,:q_client_id client_id from hr_h2pi_bg_and_gre_v bg where business_group_id = :q_bg_id');
263: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_BG_AND_GRE');
264: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
265: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
266: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
267: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
268: hr_h2pi_download.write(x,y,xmlstring1);

Line 265: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);

261: hr_utility.set_location(l_proc,220);
262: queryCtx := DBMS_XMLQuery.newContext('select bg.*,:q_client_id client_id from hr_h2pi_bg_and_gre_v bg where business_group_id = :q_bg_id');
263: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_BG_AND_GRE');
264: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
265: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
266: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
267: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
268: hr_h2pi_download.write(x,y,xmlstring1);
269: DBMS_XMLQuery.closeContext(queryCtx);

Line 266: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);

262: queryCtx := DBMS_XMLQuery.newContext('select bg.*,:q_client_id client_id from hr_h2pi_bg_and_gre_v bg where business_group_id = :q_bg_id');
263: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_BG_AND_GRE');
264: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
265: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
266: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
267: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
268: hr_h2pi_download.write(x,y,xmlstring1);
269: DBMS_XMLQuery.closeContext(queryCtx);
270: xmlString1 := null;

Line 267: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);

263: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_BG_AND_GRE');
264: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
265: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
266: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
267: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
268: hr_h2pi_download.write(x,y,xmlstring1);
269: DBMS_XMLQuery.closeContext(queryCtx);
270: xmlString1 := null;
271: hr_utility.set_location(l_proc,230);

Line 269: DBMS_XMLQuery.closeContext(queryCtx);

265: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
266: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
267: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
268: hr_h2pi_download.write(x,y,xmlstring1);
269: DBMS_XMLQuery.closeContext(queryCtx);
270: xmlString1 := null;
271: hr_utility.set_location(l_proc,230);
272: --
273:

Line 278: queryCtx := DBMS_XMLQuery.newContext('select pmt.*,:q_client_id client_id from hr_h2pi_org_payment_methods_v pmt where business_group_id = :q_bg_id');

274: --
275: -- For HR_H2PI_ORG_PAYMENT_METHODS_V VIEW
276: --
277: hr_utility.set_location(l_proc,240);
278: queryCtx := DBMS_XMLQuery.newContext('select pmt.*,:q_client_id client_id from hr_h2pi_org_payment_methods_v pmt where business_group_id = :q_bg_id');
279: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
280: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
281: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ORG_PAYMENT_METHODS');
282: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);

Line 279: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);

275: -- For HR_H2PI_ORG_PAYMENT_METHODS_V VIEW
276: --
277: hr_utility.set_location(l_proc,240);
278: queryCtx := DBMS_XMLQuery.newContext('select pmt.*,:q_client_id client_id from hr_h2pi_org_payment_methods_v pmt where business_group_id = :q_bg_id');
279: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
280: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
281: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ORG_PAYMENT_METHODS');
282: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
283: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);

Line 280: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);

276: --
277: hr_utility.set_location(l_proc,240);
278: queryCtx := DBMS_XMLQuery.newContext('select pmt.*,:q_client_id client_id from hr_h2pi_org_payment_methods_v pmt where business_group_id = :q_bg_id');
279: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
280: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
281: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ORG_PAYMENT_METHODS');
282: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
283: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
284: hr_h2pi_download.write(x,y,xmlstring1);

Line 281: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ORG_PAYMENT_METHODS');

277: hr_utility.set_location(l_proc,240);
278: queryCtx := DBMS_XMLQuery.newContext('select pmt.*,:q_client_id client_id from hr_h2pi_org_payment_methods_v pmt where business_group_id = :q_bg_id');
279: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
280: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
281: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ORG_PAYMENT_METHODS');
282: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
283: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
284: hr_h2pi_download.write(x,y,xmlstring1);
285: DBMS_XMLQuery.closeContext(queryCtx);

Line 282: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);

278: queryCtx := DBMS_XMLQuery.newContext('select pmt.*,:q_client_id client_id from hr_h2pi_org_payment_methods_v pmt where business_group_id = :q_bg_id');
279: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
280: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
281: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ORG_PAYMENT_METHODS');
282: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
283: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
284: hr_h2pi_download.write(x,y,xmlstring1);
285: DBMS_XMLQuery.closeContext(queryCtx);
286: xmlString1 := null;

Line 283: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);

279: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
280: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
281: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ORG_PAYMENT_METHODS');
282: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
283: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
284: hr_h2pi_download.write(x,y,xmlstring1);
285: DBMS_XMLQuery.closeContext(queryCtx);
286: xmlString1 := null;
287: hr_utility.set_location(l_proc,260);

Line 285: DBMS_XMLQuery.closeContext(queryCtx);

281: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ORG_PAYMENT_METHODS');
282: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
283: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
284: hr_h2pi_download.write(x,y,xmlstring1);
285: DBMS_XMLQuery.closeContext(queryCtx);
286: xmlString1 := null;
287: hr_utility.set_location(l_proc,260);
288: --
289: fnd_file.put_line(fnd_file.output,l_xml_header);

Line 358: queryCtx := DBMS_XMLQuery.newContext(l_query_string);

354: ' and oitbc.org_information_type=oit.org_information_type '||
355: ' and (oit.legislation_code is NULL or oit.legislation_code = ''US'')'||
356: ' and oit.navigation_method = ''GS'' '||
357: ' and org.business_group_id = :q_bg_id ';
358: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
359: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
360: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
361: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ORGANIZATION_INFO');
362: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);

Line 359: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);

355: ' and (oit.legislation_code is NULL or oit.legislation_code = ''US'')'||
356: ' and oit.navigation_method = ''GS'' '||
357: ' and org.business_group_id = :q_bg_id ';
358: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
359: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
360: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
361: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ORGANIZATION_INFO');
362: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
363: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);

Line 360: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);

356: ' and oit.navigation_method = ''GS'' '||
357: ' and org.business_group_id = :q_bg_id ';
358: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
359: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
360: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
361: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ORGANIZATION_INFO');
362: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
363: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
364: hr_h2pi_download.write(x,y,xmlstring1);

Line 361: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ORGANIZATION_INFO');

357: ' and org.business_group_id = :q_bg_id ';
358: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
359: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
360: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
361: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ORGANIZATION_INFO');
362: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
363: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
364: hr_h2pi_download.write(x,y,xmlstring1);
365: DBMS_XMLQuery.closeContext(queryCtx);

Line 362: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);

358: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
359: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
360: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
361: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ORGANIZATION_INFO');
362: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
363: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
364: hr_h2pi_download.write(x,y,xmlstring1);
365: DBMS_XMLQuery.closeContext(queryCtx);
366: xmlString1 := null;

Line 363: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);

359: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
360: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
361: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ORGANIZATION_INFO');
362: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
363: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
364: hr_h2pi_download.write(x,y,xmlstring1);
365: DBMS_XMLQuery.closeContext(queryCtx);
366: xmlString1 := null;
367: hr_utility.set_location(l_proc,430);

Line 365: DBMS_XMLQuery.closeContext(queryCtx);

361: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ORGANIZATION_INFO');
362: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
363: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
364: hr_h2pi_download.write(x,y,xmlstring1);
365: DBMS_XMLQuery.closeContext(queryCtx);
366: xmlString1 := null;
367: hr_utility.set_location(l_proc,430);
368:
369: fnd_file.put_line(fnd_file.output,l_xml_header);