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 HR_UTILITY

Line 33: hr_utility.set_location('Entering:' || l_proc,10);

29: l_proc varchar2(72) := g_package || 'download' ;
30: l_xml_header varchar2(80) := '';
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);

Line 46: hr_utility.set_location(l_proc,60);

42: fnd_file.put_line(fnd_file.output,'');
43: --
44: -- For HR_H2PI_LOCATIONS_V VIEW
45: --
46: hr_utility.set_location(l_proc,60);
47: l_query_string := 'select ' ||
48: ' last_upd_date,' ||
49: TO_CHAR(p_business_group_id)||' business_group_id,'||
50: ' location_id, ' ||

Line 108: hr_utility.set_location(l_proc,70);

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:
111: --
112: fnd_file.put_line(fnd_file.output,l_xml_header);

Line 121: hr_utility.set_location(l_proc,100);

117:
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');

Line 133: hr_utility.set_location(l_proc,110);

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:
136: fnd_file.put_line(fnd_file.output,l_xml_header);
137: fnd_file.put_line(fnd_file.output,'');

Line 142: hr_utility.set_location(l_proc,140);

138: fnd_file.put_line(fnd_file.output,'');
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);

Line 152: hr_utility.set_location(l_proc,150);

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:
155: --
156: -- For HR_H2PI_ELEMENT_TYPES_V VIEW

Line 158: hr_utility.set_location(l_proc,160);

154:
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, ' ||

Line 186: hr_utility.set_location(l_proc,170);

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:
189: --
190: -- For HR_H2PI_INPUT_VALUES_V VIEW

Line 192: hr_utility.set_location(l_proc,180);

188:
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, ' ||

Line 227: hr_utility.set_location(l_proc,190);

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:
230: --
231: -- For HR_H2PI_ELEMENT_LINKS_V VIEW

Line 233: hr_utility.set_location(l_proc,200);

229:
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, ' ||

Line 255: hr_utility.set_location(l_proc,210);

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:
258: --
259: -- For HR_H2PI_BG_AND_GRE_V VIEW

Line 261: hr_utility.set_location(l_proc,220);

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

Line 271: hr_utility.set_location(l_proc,230);

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:
274: --
275: -- For HR_H2PI_ORG_PAYMENT_METHODS_V VIEW

Line 277: hr_utility.set_location(l_proc,240);

273:
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');

Line 287: hr_utility.set_location(l_proc,260);

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);
290: fnd_file.put_line(fnd_file.output,'');
291: fnd_file.put_line(fnd_file.output,'');

Line 317: hr_utility.set_location(l_proc,420);

313:
314: --
315: -- For HR_H2PI_ORGANIZATION_INFO_V VIEW
316: --
317: hr_utility.set_location(l_proc,420);
318: l_query_string := 'SELECT ogi.last_update_date last_upd_date, '||
319: 'org.business_group_id, ogi.org_information_id, '||
320: 'ogi.organization_id, ogi.org_information_context, '||
321: 'ogi.org_information1, ogi.org_information2, '||

Line 367: hr_utility.set_location(l_proc,430);

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);
370: fnd_file.put_line(fnd_file.output,'');
371: fnd_file.put_line(fnd_file.output,'');

Line 392: hr_utility.set_location('Leaving:' || l_proc,580);

388: fnd_file.put_line(fnd_file.output,'');
389: fnd_file.put_line(fnd_file.output,'');
390:
391: COMMIT;
392: hr_utility.set_location('Leaving:' || l_proc,580);
393: END download ;
394:
395: END hr_h2pi_baseline_data_download ;