DBA Data[Home] [Help]

APPS.HR_H2PI_BASELINE_DATA_DOWNLOAD dependencies on HR_H2PI_DOWNLOAD

Line 35: l_request_id := hr_h2pi_download.get_request_id;

31:
32: BEGIN
33: hr_utility.set_location('Entering:' || l_proc,10);
34:
35: l_request_id := hr_h2pi_download.get_request_id;
36:
37: fnd_file.put_line(fnd_file.output,l_xml_header);
38: fnd_file.put_line(fnd_file.output,'');
39: fnd_file.put_line(fnd_file.output,'');

Line 105: hr_h2pi_download.write(x,y,xmlstring1);

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);
109: --

Line 130: hr_h2pi_download.write(x,y,xmlstring1);

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);
134: --

Line 149: hr_h2pi_download.write(x,y,xmlstring1);

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);
153: --

Line 183: hr_h2pi_download.write(x,y,xmlstring1);

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);
187: --

Line 224: hr_h2pi_download.write(x,y,xmlstring1);

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);
228: --

Line 252: hr_h2pi_download.write(x,y,xmlstring1);

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);
256: --

Line 268: hr_h2pi_download.write(x,y,xmlstring1);

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);
272: --

Line 284: hr_h2pi_download.write(x,y,xmlstring1);

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);
288: --

Line 364: hr_h2pi_download.write(x,y,xmlstring1);

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);
368: