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_DOWNLOAD dependencies on HR_UTILITY

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

18:
19: l_business_group_name hr_all_organization_units.name%TYPE;
20: l_proc varchar2(72) := g_package || 'record_extract_history' ;
21: begin
22: hr_utility.set_location('Entering:' || l_proc,10);
23: select name
24: into l_business_group_name
25: from hr_all_organization_units
26: where organization_id = p_bg_id;

Line 51: hr_utility.set_location('Leaving:' || l_proc,20);

47: p_request_id,
48: null,
49: null,
50: sysdate);
51: hr_utility.set_location('Leaving:' || l_proc,20);
52: exception
53: when no_data_found then
54: hr_utility.set_location(l_proc || l_proc,30);
55: fnd_message.set_name('PER','HR_6673_PO_EMP_NO_BG');

Line 54: hr_utility.set_location(l_proc || l_proc,30);

50: sysdate);
51: hr_utility.set_location('Leaving:' || l_proc,20);
52: exception
53: when no_data_found then
54: hr_utility.set_location(l_proc || l_proc,30);
55: fnd_message.set_name('PER','HR_6673_PO_EMP_NO_BG');
56: fnd_message.raise_error;
57: END record_extract_history;
58: --

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

149: i NUMBER;
150: l_proc varchar2(72) := g_package || '.get_value_from_id' ;
151:
152: BEGIN
153: hr_utility.set_location('Entering:' || l_proc,10);
154: FOR v_rec IN csr_org_info LOOP
155: fnd_flex_descval.set_column_value('ORG_INFORMATION_CONTEXT', v_rec.context);
156: fnd_flex_descval.set_column_value('ORG_INFORMATION1', v_rec.ogi1 );
157: fnd_flex_descval.set_column_value('ORG_INFORMATION2', v_rec.ogi2 );

Line 189: hr_utility.trace('Column Name : ' || v_org_info.col_name);

185:
186: FOR v_org_info IN csr_flex_cols(v_rec.context) LOOP
187: IF v_org_info.col_name = 'ORG_INFORMATION'||TO_CHAR(p_org_info_number) THEN
188: idx := i;
189: hr_utility.trace('Column Name : ' || v_org_info.col_name);
190: END IF;
191: i:=i+1;
192: END LOOP;
193:

Line 205: hr_utility.set_location('Leaving:' || l_proc,90);

201:
202: return(l_seg_value);
203:
204: END LOOP;
205: hr_utility.set_location('Leaving:' || l_proc,90);
206: END;
207: --
208: --
209: -- --------------------------------------------------------------------------------

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

222: l_dstatus varchar2(80);
223: l_message varchar2(80);
224: l_proc varchar2(72) := g_package || 'get_request_id';
225: BEGIN
226: hr_utility.set_location('Entering:' || l_proc,10);
227: l_call_status := fnd_concurrent.get_request_status
228: (l_request_id,
229: 'PER',
230: 'H2PI_DOWNLOAD',

Line 236: hr_utility.set_location('Leaving:' || l_proc,20);

232: l_rstatus,
233: l_dphase,
234: l_dstatus,
235: l_message);
236: hr_utility.set_location('Leaving:' || l_proc,20);
237: return l_request_id;
238: EXCEPTION
239: when others then
240: hr_utility.set_location(l_proc,30);

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

236: hr_utility.set_location('Leaving:' || l_proc,20);
237: return l_request_id;
238: EXCEPTION
239: when others then
240: hr_utility.set_location(l_proc,30);
241: fnd_message.raise_error;
242: END get_request_id;
243: --
244: -- --------------------------------------------------------------------------------

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

265:
266: l_proc varchar2(72) := g_package || 'write' ;
267:
268: begin
269: hr_utility.set_location('Entering:' || l_proc,10);
270: l_cloblength := dbms_lob.getlength(p_clob_to_write);
271: l_offset := 0;
272: l_new_position := 0;
273: loop

Line 288: hr_utility.set_location('Leaving:' || l_proc,20);

284: if ( (l_offset) >= l_cloblength ) then
285: exit;
286: end if;
287: end loop;
288: hr_utility.set_location('Leaving:' || l_proc,20);
289: end write;
290: --
291: -- --------------------------------------------------------------------------------
292: -- Description: Procedure to download data from the H2PI views into a XML file

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

317: l_query_string varchar2(10000);
318: l_proc varchar2(72) := g_package || 'download' ;
319:
320: BEGIN
321: hr_utility.set_location('Entering:' || l_proc,10);
322:
323: l_request_id := get_request_id;
324:
325: --

Line 328: hr_utility.set_location(l_proc,20);

324:
325: --
326: -- For HR_H2PI_EMPLOYEES_V VIEW
327: --
328: hr_utility.set_location(l_proc,20);
329: l_query_string := 'select emp.*, :q_client_id client_id from hr_h2pi_employees_v emp where business_group_id = :q_bg_id and last_upd_date between ' ||
330: ' to_date(''' || to_char(l_start_date, 'yyyy/mm/dd:hh24:mi:ss') || ''', ''yyyy/mm/dd:hh24:mi:ss'') and to_date(''' || to_char(l_end_date, 'yyyy/mm/dd:hh24:mi:ss') || ''', ''yyyy/mm/dd:hh24:mi:ss'') ';
331: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
332: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);

Line 340: hr_utility.set_location(l_proc,30);

336: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
337: write(x,y,xmlstring1);
338: DBMS_XMLQuery.closeContext(queryCtx);
339: xmlString1 := null;
340: hr_utility.set_location(l_proc,30);
341: --
342:
343: --
344: -- For HR_H2PI_ADDRESSES_V VIEW

Line 346: hr_utility.set_location(l_proc,40);

342:
343: --
344: -- For HR_H2PI_ADDRESSES_V VIEW
345: --
346: hr_utility.set_location(l_proc,40);
347: l_query_string := 'select adr.last_upd_date, GREATEST(per.per_date, adr.date_from) date_from,adr.business_group_id, adr.address_id, adr.person_id, adr.style, ' ||
348: ' adr.date_to, adr.address_type, adr.address_line1, adr.address_line2, adr.address_line3, adr.town_or_city, adr.region_1, adr.region_2, ' ||
349: ' adr.region_3, adr.postal_code, adr.country, adr.telephone_number_1, adr.telephone_number_2, adr.telephone_number_3, adr.add_information13, ' ||
350: ' adr.add_information14, adr.add_information15, adr.add_information16, adr.add_information17, adr.add_information18, adr.add_information19, ' ||

Line 375: hr_utility.set_location(l_proc,50);

371: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
372: write(x,y,xmlstring1);
373: DBMS_XMLQuery.closeContext(queryCtx);
374: xmlString1 := null;
375: hr_utility.set_location(l_proc,50);
376: --
377:
378: --
379: -- For HR_H2PI_LOCATIONS_V VIEW

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

377:
378: --
379: -- For HR_H2PI_LOCATIONS_V VIEW
380: --
381: hr_utility.set_location(l_proc,60);
382: l_query_string := 'select ' ||
383: ' last_upd_date,' ||
384: ' nvl(business_group_id,:q_bg_id1 ) business_group_id, ' ||
385: ' location_id, ' ||

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

440: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
441: write(x,y,xmlstring1);
442: DBMS_XMLQuery.closeContext(queryCtx);
443: xmlString1 := null;
444: hr_utility.set_location(l_proc,70);
445: --
446:
447: --
448: -- For HR_H2PI_ASSIGNMENTS_V VIEW

Line 450: hr_utility.set_location(l_proc,80);

446:
447: --
448: -- For HR_H2PI_ASSIGNMENTS_V VIEW
449: --
450: hr_utility.set_location(l_proc,80);
451: l_query_string := 'select p1.*,:q_client_id client_id from hr_h2pi_assignments_v p1 where business_group_id = :q_bg_id and effective_start_date >= ' ||
452: ' ((select min(effective_start_date) from hr_h2pi_assignments_v p2 where p2.last_upd_date between ' ||
453: ' to_date(''' || to_char(l_start_date, 'yyyy/mm/dd:hh24:mi:ss') || ''', ''yyyy/mm/dd:hh24:mi:ss'') and to_date(''' || to_char(l_end_date, 'yyyy/mm/dd:hh24:mi:ss') || ''', ''yyyy/mm/dd:hh24:mi:ss'') ' ||
454: ' and p2.assignment_id = p1.assignment_id ))';

Line 464: hr_utility.set_location(l_proc,90);

460: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
461: write(x,y,xmlstring1);
462: DBMS_XMLQuery.closeContext(queryCtx);
463: xmlString1 := null;
464: hr_utility.set_location(l_proc,90);
465: --
466:
467: -- Following is for Baseline data
468:

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

468:
469: --
470: -- For HR_H2PI_PAY_BASES_V VIEW
471: --
472: hr_utility.set_location(l_proc,100);
473: queryCtx := DBMS_XMLQuery.newContext('select pay.*,:q_client_id client_id from hr_h2pi_pay_bases_v pay where business_group_id = :q_bg_id');
474: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_PAY_BASES');
475: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
476: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);

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

478: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
479: write(x,y,xmlstring1);
480: DBMS_XMLQuery.closeContext(queryCtx);
481: xmlString1 := null;
482: hr_utility.set_location(l_proc,110);
483: --
484:
485: --
486: -- For HR_H2PI_HR_ORGANIZATIONS_V VIEW

Line 488: hr_utility.set_location(l_proc,120);

484:
485: --
486: -- For HR_H2PI_HR_ORGANIZATIONS_V VIEW
487: --
488: hr_utility.set_location(l_proc,120);
489: queryCtx := DBMS_XMLQuery.newContext('select org.*,:q_client_id client_id from hr_h2pi_hr_organizations_v org where business_group_id = :q_bg_id and ' ||
490: ' last_upd_date between to_date(''' || to_char(l_start_date, 'yyyy/mm/dd:hh24:mi:ss') || ''', ''yyyy/mm/dd:hh24:mi:ss'') and to_date(''' || to_char(l_end_date, 'yyyy/mm/dd:hh24:mi:ss') || ''', ''yyyy/mm/dd:hh24:mi:ss'') ');
491: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_HR_ORGANIZATIONS');
492: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);

Line 499: hr_utility.set_location(l_proc,130);

495: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
496: write(x,y,xmlstring1);
497: DBMS_XMLQuery.closeContext(queryCtx);
498: xmlString1 := null;
499: hr_utility.set_location(l_proc,130);
500: --
501:
502: --
503: -- For HR_H2PI_PAYROLLS_V VIEW

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

501:
502: --
503: -- For HR_H2PI_PAYROLLS_V VIEW
504: --
505: hr_utility.set_location(l_proc,140);
506: queryCtx := DBMS_XMLQuery.newContext('select pay.*,:q_client_id client_id from hr_h2pi_payrolls_v pay where business_group_id = :q_bg_id');
507: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_PAYROLLS');
508: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
509: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);

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

511: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
512: write(x,y,xmlstring1);
513: DBMS_XMLQuery.closeContext(queryCtx);
514: xmlString1 := null;
515: hr_utility.set_location(l_proc,150);
516: --
517:
518: --
519: -- For HR_H2PI_ELEMENT_TYPES_V VIEW

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

517:
518: --
519: -- For HR_H2PI_ELEMENT_TYPES_V VIEW
520: --
521: hr_utility.set_location(l_proc,160);
522: queryCtx := DBMS_XMLQuery.newContext('select et.*,:q_client_id client_id from hr_h2pi_element_types_v et where business_group_id = :q_bg_id');
523: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ELEMENT_TYPES');
524: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
525: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);

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

527: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
528: write(x,y,xmlstring1);
529: DBMS_XMLQuery.closeContext(queryCtx);
530: xmlString1 := null;
531: hr_utility.set_location(l_proc,170);
532: --
533:
534: --
535: -- For HR_H2PI_INPUT_VALUES_V VIEW

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

533:
534: --
535: -- For HR_H2PI_INPUT_VALUES_V VIEW
536: --
537: hr_utility.set_location(l_proc,180);
538: queryCtx := DBMS_XMLQuery.newContext('select iv.*,:q_client_id client_id from hr_h2pi_input_values_v iv where business_group_id = :q_bg_id');
539: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_INPUT_VALUES');
540: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
541: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);

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

543: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
544: write(x,y,xmlstring1);
545: DBMS_XMLQuery.closeContext(queryCtx);
546: xmlString1 := null;
547: hr_utility.set_location(l_proc,190);
548: --
549:
550: --
551: -- For HR_H2PI_ELEMENT_LINKS_V VIEW

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

549:
550: --
551: -- For HR_H2PI_ELEMENT_LINKS_V VIEW
552: --
553: hr_utility.set_location(l_proc,200);
554: queryCtx := DBMS_XMLQuery.newContext('select el.*,:q_client_id client_id from hr_h2pi_element_links_v el where business_group_id = :q_bg_id');
555: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ELEMENT_LINKS');
556: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
557: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);

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

559: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
560: write(x,y,xmlstring1);
561: DBMS_XMLQuery.closeContext(queryCtx);
562: xmlString1 := null;
563: hr_utility.set_location(l_proc,210);
564: --
565:
566: --
567: -- For HR_H2PI_BG_AND_GRE_V VIEW

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

565:
566: --
567: -- For HR_H2PI_BG_AND_GRE_V VIEW
568: --
569: hr_utility.set_location(l_proc,220);
570: 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');
571: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_BG_AND_GRE');
572: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
573: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);

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

575: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
576: write(x,y,xmlstring1);
577: DBMS_XMLQuery.closeContext(queryCtx);
578: xmlString1 := null;
579: hr_utility.set_location(l_proc,230);
580: --
581:
582: --
583: -- For HR_H2PI_ORG_PAYMENT_METHODS_V VIEW

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

581:
582: --
583: -- For HR_H2PI_ORG_PAYMENT_METHODS_V VIEW
584: --
585: hr_utility.set_location(l_proc,240);
586: 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');
587: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
588: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
589: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ORG_PAYMENT_METHODS');

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

591: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
592: write(x,y,xmlstring1);
593: DBMS_XMLQuery.closeContext(queryCtx);
594: xmlString1 := null;
595: hr_utility.set_location(l_proc,260);
596: --
597:
598: --
599: -- For HR_H2PI_PATCH_STATUS_V VIEW

Line 601: hr_utility.set_location(l_proc,270);

597:
598: --
599: -- For HR_H2PI_PATCH_STATUS_V VIEW
600: --
601: hr_utility.set_location(l_proc,270);
602: queryCtx := DBMS_XMLQuery.newContext('select pat.*,:q_bg_id business_group_id,:q_client_id client_id from hr_h2pi_patch_status_v pat');
603: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_PATCH_STATUS');
604: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
605: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);

Line 611: hr_utility.set_location(l_proc,280);

607: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
608: write(x,y,xmlstring1);
609: DBMS_XMLQuery.closeContext(queryCtx);
610: xmlString1 := null;
611: hr_utility.set_location(l_proc,280);
612: --
613:
614: --
615: -- For HR_H2PI_FEDERAL_TAX_RULES_V VIEW

Line 617: hr_utility.set_location(l_proc,290);

613:
614: --
615: -- For HR_H2PI_FEDERAL_TAX_RULES_V VIEW
616: --
617: hr_utility.set_location(l_proc,290);
618: l_query_string := 'select p1.*,:q_client_id client_id from hr_h2pi_federal_tax_rules_v p1 where business_group_id = :q_bg_id ' ||
619: ' and effective_start_date >= ((select min(effective_start_date) from hr_h2pi_federal_tax_rules_v p2 where p2.last_upd_date between ' ||
620: ' to_date(''' || to_char(l_start_date, 'yyyy/mm/dd:hh24:mi:ss') || ''', ''yyyy/mm/dd:hh24:mi:ss'') and to_date(''' || to_char(l_end_date, 'yyyy/mm/dd:hh24:mi:ss') || ''', ''yyyy/mm/dd:hh24:mi:ss'') ' ||
621: ' and p2.emp_fed_tax_rule_id = p1.emp_fed_tax_rule_id ))' ;

Line 631: hr_utility.set_location(l_proc,300);

627: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
628: write(x,y,xmlstring1);
629: DBMS_XMLQuery.closeContext(queryCtx);
630: xmlString1 := null;
631: hr_utility.set_location(l_proc,300);
632: --
633:
634: --
635: -- For HR_H2PI_STATE_TAX_RULES_V VIEW

Line 637: hr_utility.set_location(l_proc,310);

633:
634: --
635: -- For HR_H2PI_STATE_TAX_RULES_V VIEW
636: --
637: hr_utility.set_location(l_proc,310);
638: l_query_string := 'select p1.*,:q_client_id client_id from hr_h2pi_state_tax_rules_v p1 where business_group_id = :q_bg_id' ||
639: ' and effective_start_date >= ((select min(effective_start_date) from hr_h2pi_state_tax_rules_v p2 where p2.last_upd_date between ' ||
640: ' to_date(''' || to_char(l_start_date, 'yyyy/mm/dd:hh24:mi:ss') || ''', ''yyyy/mm/dd:hh24:mi:ss'') and to_date(''' || to_char(l_end_date, 'yyyy/mm/dd:hh24:mi:ss') || ''', ''yyyy/mm/dd:hh24:mi:ss'') ' ||
641: ' and p2.emp_state_tax_rule_id = p1.emp_state_tax_rule_id ))';

Line 651: hr_utility.set_location(l_proc,320);

647: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
648: write(x,y,xmlstring1);
649: DBMS_XMLQuery.closeContext(queryCtx);
650: xmlString1 := null;
651: hr_utility.set_location(l_proc,320);
652: --
653:
654:
655: --

Line 658: hr_utility.set_location(l_proc,330);

654:
655: --
656: -- For HR_H2PI_COUNTY_TAX_RULES_V VIEW
657: --
658: hr_utility.set_location(l_proc,330);
659: l_query_string := 'select p1.*,:q_client_id client_id from hr_h2pi_county_tax_rules_v p1 where business_group_id = :q_bg_id' ||
660: ' and effective_start_date >= ((select min(effective_start_date) from hr_h2pi_county_tax_rules_v p2 where p2.last_upd_date between ' ||
661: ' to_date(''' || to_char(l_start_date, 'yyyy/mm/dd:hh24:mi:ss') || ''', ''yyyy/mm/dd:hh24:mi:ss'') and to_date(''' || to_char(l_end_date, 'yyyy/mm/dd:hh24:mi:ss') || ''', ''yyyy/mm/dd:hh24:mi:ss'') ' ||
662: ' and p2.emp_county_tax_rule_id = p1.emp_county_tax_rule_id ))';

Line 672: hr_utility.set_location(l_proc,340);

668: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
669: write(x,y,xmlstring1);
670: DBMS_XMLQuery.closeContext(queryCtx);
671: xmlString1 := null;
672: hr_utility.set_location(l_proc,340);
673: --
674:
675: --
676: -- For HR_H2PI_CITY_TAX_RULES_V VIEW

Line 678: hr_utility.set_location(l_proc,350);

674:
675: --
676: -- For HR_H2PI_CITY_TAX_RULES_V VIEW
677: --
678: hr_utility.set_location(l_proc,350);
679: l_query_string := 'select p1.*,:q_client_id client_id from hr_h2pi_city_tax_rules_v p1 where business_group_id = :q_bg_id' ||
680: ' and effective_start_date >= ((select min(effective_start_date) from hr_h2pi_city_tax_rules_v p2 where p2.last_upd_date between ' ||
681: ' to_date(''' || to_char(l_start_date, 'yyyy/mm/dd:hh24:mi:ss') || ''', ''yyyy/mm/dd:hh24:mi:ss'') and to_date(''' || to_char(l_end_date, 'yyyy/mm/dd:hh24:mi:ss') || ''', ''yyyy/mm/dd:hh24:mi:ss'') ' ||
682: ' and p2.emp_city_tax_rule_id = p1.emp_city_tax_rule_id ))';

Line 692: hr_utility.set_location(l_proc,360);

688: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
689: write(x,y,xmlstring1);
690: DBMS_XMLQuery.closeContext(queryCtx);
691: xmlString1 := null;
692: hr_utility.set_location(l_proc,360);
693: --
694:
695: --
696: -- For HR_H2PI_ORGANIZATION_CLASS_V VIEW

Line 698: hr_utility.set_location(l_proc,370);

694:
695: --
696: -- For HR_H2PI_ORGANIZATION_CLASS_V VIEW
697: --
698: hr_utility.set_location(l_proc,370);
699: l_query_string := 'select org.*,:q_client_id client_id from hr_h2pi_organization_class_v org where business_group_id = :q_bg_id and ' ||
700: ' last_upd_date between to_date(''' || to_char(l_start_date, 'yyyy/mm/dd:hh24:mi:ss') || ''', ''yyyy/mm/dd:hh24:mi:ss'') and to_date(''' || to_char(l_end_date, 'yyyy/mm/dd:hh24:mi:ss') || ''', ''yyyy/mm/dd:hh24:mi:ss'') ';
701: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
702: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);

Line 710: hr_utility.set_location(l_proc,380);

706: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
707: write(x,y,xmlstring1);
708: DBMS_XMLQuery.closeContext(queryCtx);
709: xmlString1 := null;
710: hr_utility.set_location(l_proc,380);
711: --
712:
713: --
714: -- For HR_H2PI_PERIODS_OF_SERVICE_V VIEW

Line 717: hr_utility.set_location(l_proc,380);

713: --
714: -- For HR_H2PI_PERIODS_OF_SERVICE_V VIEW
715: --
716:
717: hr_utility.set_location(l_proc,380);
718: l_query_string := 'select pos.*,:q_client_id client_id from hr_h2pi_periods_of_service_v pos where business_group_id = :q_bg_id and ' ||
719: ' last_upd_date between to_date(''' || to_char(l_start_date, 'yyyy/mm/dd:hh24:mi:ss') || ''', ''yyyy/mm/dd:hh24:mi:ss'') and to_date(''' || to_char(l_end_date, 'yyyy/mm/dd:hh24:mi:ss') || ''', ''yyyy/mm/dd:hh24:mi:ss'') ';
720: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
721: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);

Line 729: hr_utility.set_location(l_proc,390);

725: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
726: write(x,y,xmlstring1);
727: DBMS_XMLQuery.closeContext(queryCtx);
728: xmlString1 := null;
729: hr_utility.set_location(l_proc,390);
730: --
731:
732: --
733: -- For HR_H2PI_SALARIES_V VIEW

Line 735: hr_utility.set_location(l_proc,400);

731:
732: --
733: -- For HR_H2PI_SALARIES_V VIEW
734: --
735: hr_utility.set_location(l_proc,400);
736: l_query_string := 'select sal.*,:q_client_id client_id from hr_h2pi_salaries_v sal where business_group_id = :q_bg_id and ' ||
737: ' last_upd_date between to_date(''' || to_char(l_start_date, 'yyyy/mm/dd:hh24:mi:ss') || ''', ''yyyy/mm/dd:hh24:mi:ss'') and to_date(''' || to_char(l_end_date, 'yyyy/mm/dd:hh24:mi:ss') || ''', ''yyyy/mm/dd:hh24:mi:ss'') ';
738: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
739: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);

Line 747: hr_utility.set_location(l_proc,410);

743: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
744: write(x,y,xmlstring1);
745: DBMS_XMLQuery.closeContext(queryCtx);
746: xmlString1 := null;
747: hr_utility.set_location(l_proc,410);
748: --
749:
750: --
751: -- For HR_H2PI_ORGANIZATION_INFO_V VIEW

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

749:
750: --
751: -- For HR_H2PI_ORGANIZATION_INFO_V VIEW
752: --
753: hr_utility.set_location(l_proc,420);
754: l_query_string := 'select org.*,:q_client_id client_id from hr_h2pi_organization_info_v org where business_group_id = :q_bg_id ' ||
755: ' and last_upd_date between to_date(''' || to_char(l_start_date, 'yyyy/mm/dd:hh24:mi:ss') || ''', ''yyyy/mm/dd:hh24:mi:ss'') and to_date(''' || to_char(l_end_date, 'yyyy/mm/dd:hh24:mi:ss') || ''', ''yyyy/mm/dd:hh24:mi:ss'') ';
756: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
757: hr_utility.trace(l_query_string);

Line 757: hr_utility.trace(l_query_string);

753: hr_utility.set_location(l_proc,420);
754: l_query_string := 'select org.*,:q_client_id client_id from hr_h2pi_organization_info_v org where business_group_id = :q_bg_id ' ||
755: ' and last_upd_date between to_date(''' || to_char(l_start_date, 'yyyy/mm/dd:hh24:mi:ss') || ''', ''yyyy/mm/dd:hh24:mi:ss'') and to_date(''' || to_char(l_end_date, 'yyyy/mm/dd:hh24:mi:ss') || ''', ''yyyy/mm/dd:hh24:mi:ss'') ';
756: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
757: hr_utility.trace(l_query_string);
758: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
759: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
760: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ORGANIZATION_INFO');
761: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);

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

762: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
763: write(x,y,xmlstring1);
764: DBMS_XMLQuery.closeContext(queryCtx);
765: xmlString1 := null;
766: hr_utility.set_location(l_proc,430);
767: --
768:
769: --
770: -- For HR_H2PI_COST_ALLOCATIONS_V VIEW

Line 772: hr_utility.set_location(l_proc,440);

768:
769: --
770: -- For HR_H2PI_COST_ALLOCATIONS_V VIEW
771: --
772: hr_utility.set_location(l_proc,440);
773: l_query_string := 'select p1.*,:q_client_id client_id from hr_h2pi_cost_allocations_v p1 where business_group_id = :q_bg_id ' ||
774: ' and effective_start_date >= ((select min(effective_start_date) from hr_h2pi_cost_allocations_v p2 where p2.last_upd_date between ' ||
775: ' to_date(''' || to_char(l_start_date, 'yyyy/mm/dd:hh24:mi:ss') || ''', ''yyyy/mm/dd:hh24:mi:ss'') and to_date(''' || to_char(l_end_date, 'yyyy/mm/dd:hh24:mi:ss') || ''', ''yyyy/mm/dd:hh24:mi:ss'') ' ||
776: ' and p2.cost_allocation_id = p1.cost_allocation_id ))';

Line 786: hr_utility.set_location(l_proc,450);

782: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
783: write(x,y,xmlstring1);
784: DBMS_XMLQuery.closeContext(queryCtx);
785: xmlString1 := null;
786: hr_utility.set_location(l_proc,450);
787: --
788:
789:
790: --

Line 793: hr_utility.set_location(l_proc,460);

789:
790: --
791: -- For HR_H2PI_PAYMENT_METHODS_V VIEW
792: --
793: hr_utility.set_location(l_proc,460);
794: l_query_string := 'select p1.*,:q_client_id client_id from hr_h2pi_payment_methods_v p1 where business_group_id = :q_bg_id ' ||
795: ' and ( (p1.payee_type <> ''P'') OR (p1.payee_type IS NULL) )' ||
796: ' and effective_start_date >= ((select min(effective_start_date) from hr_h2pi_payment_methods_v p2 where p2.last_upd_date between ' ||
797: ' to_date(''' || to_char(l_start_date, 'yyyy/mm/dd:hh24:mi:ss') || ''', ''yyyy/mm/dd:hh24:mi:ss'') and to_date(''' || to_char(l_end_date, 'yyyy/mm/dd:hh24:mi:ss') || ''', ''yyyy/mm/dd:hh24:mi:ss'') ' ||

Line 809: hr_utility.set_location(l_proc,470);

805: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
806: write(x,y,xmlstring1);
807: DBMS_XMLQuery.closeContext(queryCtx);
808: xmlString1 := null;
809: hr_utility.set_location(l_proc,470);
810: --
811:
812: --
813: -- For HR_H2PI_ELEMENT_NAMES_V VIEW

Line 815: hr_utility.set_location(l_proc,480);

811:
812: --
813: -- For HR_H2PI_ELEMENT_NAMES_V VIEW
814: --
815: hr_utility.set_location(l_proc,480);
816: l_query_string := 'select en.*,:q_client_id client_id from hr_h2pi_element_names_v en where business_group_id = :q_bg_id and ' ||
817: ' last_upd_date between to_date(''' || to_char(l_start_date, 'yyyy/mm/dd:hh24:mi:ss') || ''', ''yyyy/mm/dd:hh24:mi:ss'') and to_date(''' || to_char(l_end_date, 'yyyy/mm/dd:hh24:mi:ss') || ''', ''yyyy/mm/dd:hh24:mi:ss'') ';
818: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
819: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);

Line 827: hr_utility.set_location(l_proc,490);

823: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
824: write(x,y,xmlstring1);
825: DBMS_XMLQuery.closeContext(queryCtx);
826: xmlString1 := null;
827: hr_utility.set_location(l_proc,490);
828: --
829:
830: --
831: -- For HR_H2PI_ELEMENT_ENTRIES_V VIEW

Line 833: hr_utility.set_location(l_proc,500);

829:
830: --
831: -- For HR_H2PI_ELEMENT_ENTRIES_V VIEW
832: --
833: hr_utility.set_location(l_proc,500);
834: l_query_string := 'select p1.*, :q_client_id client_id from hr_h2pi_element_entries_v p1 where business_group_id = :q_bg_id and ' ||
835: ' effective_start_date >= ((select min(effective_start_date) from hr_h2pi_element_entries_v p2 where p2.last_upd_date between ' ||
836: ' to_date(''' || to_char(l_start_date, 'yyyy/mm/dd:hh24:mi:ss') || ''', ''yyyy/mm/dd:hh24:mi:ss'') and to_date(''' || to_char(l_end_date, 'yyyy/mm/dd:hh24:mi:ss') || ''', ''yyyy/mm/dd:hh24:mi:ss'') ' ||
837: ' and p2.element_entry_id = p1.element_entry_id ))';

Line 847: hr_utility.set_location(l_proc,510);

843: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
844: write(x,y,xmlstring1);
845: DBMS_XMLQuery.closeContext(queryCtx);
846: xmlString1 := null;
847: hr_utility.set_location(l_proc,510);
848: --
849:
850: --
851: -- For HR_H2PI_ELEMENT_ENTRY_VALUES_V VIEW

Line 854: hr_utility.set_location(l_proc,520);

850: --
851: -- For HR_H2PI_ELEMENT_ENTRY_VALUES_V VIEW
852: --
853: --
854: hr_utility.set_location(l_proc,520);
855: l_query_string := 'select p1.*, :q_client_id client_id from hr_h2pi_element_entry_values_v p1 where business_group_id = :q_bg_id and ' ||
856: ' effective_start_date >= ((select min(effective_start_date) from hr_h2pi_element_entry_values_v p2 where p2.last_upd_date between ' ||
857: ' to_date(''' || to_char(l_start_date, 'yyyy/mm/dd:hh24:mi:ss') || ''', ''yyyy/mm/dd:hh24:mi:ss'') and to_date(''' || to_char(l_end_date, 'yyyy/mm/dd:hh24:mi:ss') || ''', ''yyyy/mm/dd:hh24:mi:ss'') ' ||
858: ' and p2.element_entry_id = p1.element_entry_id ))';

Line 868: hr_utility.set_location(l_proc,530);

864: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
865: write(x,y,xmlstring1);
866: DBMS_XMLQuery.closeContext(queryCtx);
867: xmlString1 := null;
868: hr_utility.set_location(l_proc,530);
869: --
870:
871: --
872: -- For HR_H2PI_US_MODIFIED_GEOCODES_V VIEW

Line 874: hr_utility.set_location(l_proc,540);

870:
871: --
872: -- For HR_H2PI_US_MODIFIED_GEOCODES_V VIEW
873: --
874: hr_utility.set_location(l_proc,540);
875: queryCtx := DBMS_XMLQuery.newContext('select geo.*, :q_bg_id business_group_id, :q_client_id client_id from hr_h2pi_us_modified_geocodes_v geo where patch_name = (select NVL(MAX(patch_name),''GEOCODE_1900_Q1'') FROM hr_h2pi_patch_status_v) ');
876: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
877: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
878: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_US_MODIFIED_GEOCODES');

Line 884: hr_utility.set_location(l_proc,550);

880: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
881: write(x,y,xmlstring1);
882: DBMS_XMLQuery.closeContext(queryCtx);
883: xmlString1 := null;
884: hr_utility.set_location(l_proc,550);
885: --
886:
887: --
888: -- For HR_H2PI_US_CITIES_V VIEW

Line 890: hr_utility.set_location(l_proc,560);

886:
887: --
888: -- For HR_H2PI_US_CITIES_V VIEW
889: --
890: hr_utility.set_location(l_proc,560);
891: queryCtx := DBMS_XMLQuery.newContext('select cit.*, :q_bg_id business_group_id, :q_client_id client_id from hr_h2pi_us_city_names_v cit');
892: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
893: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_US_CITY_NAMES');
894: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);

Line 900: hr_utility.set_location(l_proc,570);

896: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
897: write(x,y,xmlstring1);
898: DBMS_XMLQuery.closeContext(queryCtx);
899: xmlString1 := null;
900: hr_utility.set_location(l_proc,570);
901: --
902:
903: record_extract_history(p_business_group_id,p_client_id,l_request_id,l_start_date, l_end_date);
904:

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

902:
903: record_extract_history(p_business_group_id,p_client_id,l_request_id,l_start_date, l_end_date);
904:
905: commit;
906: hr_utility.set_location('Leaving:' || l_proc,580);
907: END download ;
908:
909: END hr_h2pi_download ;