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 DBMS_XMLQUERY

Line 303: queryCtx DBMS_XMLQuery.ctxType;

299: p_transfer_start_date IN VARCHAR2,
300: p_transfer_end_date IN VARCHAR2,
301: p_client_id IN NUMBER) IS
302:
303: queryCtx DBMS_XMLQuery.ctxType;
304: xmlString1 CLOB := NULL;
305:
306: xmlString2 CLOB := NULL;
307: dtdString CLOB := NULL;

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

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);
333: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
334: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_EMPLOYEES');
335: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);

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

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);
333: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
334: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_EMPLOYEES');
335: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
336: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);

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

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);
333: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
334: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_EMPLOYEES');
335: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
336: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
337: write(x,y,xmlstring1);

Line 334: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_EMPLOYEES');

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);
333: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
334: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_EMPLOYEES');
335: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
336: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
337: write(x,y,xmlstring1);
338: DBMS_XMLQuery.closeContext(queryCtx);

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

331: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
332: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
333: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
334: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_EMPLOYEES');
335: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
336: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
337: write(x,y,xmlstring1);
338: DBMS_XMLQuery.closeContext(queryCtx);
339: xmlString1 := null;

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

332: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
333: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
334: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_EMPLOYEES');
335: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
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);

Line 338: DBMS_XMLQuery.closeContext(queryCtx);

334: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_EMPLOYEES');
335: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
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:

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

361: ' OR per.person_id IN (select adr1.person_id from hr_h2pi_addresses_v adr1 where adr1.business_group_id = :q_bg_id1 and adr1.last_upd_date between ' ||
362: ' 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'') ' ||
363: ' group by adr1.person_id having count(*)> 0 ) )' ;
364:
365: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
366: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
367: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
368: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id1',p_business_group_id);
369: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ADDRESSES');

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

362: ' 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'') ' ||
363: ' group by adr1.person_id having count(*)> 0 ) )' ;
364:
365: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
366: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
367: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
368: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id1',p_business_group_id);
369: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ADDRESSES');
370: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);

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

363: ' group by adr1.person_id having count(*)> 0 ) )' ;
364:
365: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
366: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
367: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
368: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id1',p_business_group_id);
369: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ADDRESSES');
370: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
371: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);

Line 368: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id1',p_business_group_id);

364:
365: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
366: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
367: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
368: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id1',p_business_group_id);
369: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ADDRESSES');
370: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
371: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
372: write(x,y,xmlstring1);

Line 369: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ADDRESSES');

365: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
366: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
367: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
368: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id1',p_business_group_id);
369: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ADDRESSES');
370: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
371: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
372: write(x,y,xmlstring1);
373: DBMS_XMLQuery.closeContext(queryCtx);

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

366: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
367: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
368: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id1',p_business_group_id);
369: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ADDRESSES');
370: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
371: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
372: write(x,y,xmlstring1);
373: DBMS_XMLQuery.closeContext(queryCtx);
374: xmlString1 := null;

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

367: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
368: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id1',p_business_group_id);
369: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ADDRESSES');
370: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
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);

Line 373: DBMS_XMLQuery.closeContext(queryCtx);

369: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ADDRESSES');
370: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
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:

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

430: ' attribute20, ' ||
431: ' :q_client_id client_id ' ||
432: ' from hr_h2pi_locations_v where ( business_group_id = :q_bg_id OR business_group_id is null ) ' ||
433: ' 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'') ';
434: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
435: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id1',p_business_group_id);
436: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
437: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
438: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_LOCATIONS');

Line 435: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id1',p_business_group_id);

431: ' :q_client_id client_id ' ||
432: ' from hr_h2pi_locations_v where ( business_group_id = :q_bg_id OR business_group_id is null ) ' ||
433: ' 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'') ';
434: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
435: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id1',p_business_group_id);
436: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
437: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
438: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_LOCATIONS');
439: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);

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

432: ' from hr_h2pi_locations_v where ( business_group_id = :q_bg_id OR business_group_id is null ) ' ||
433: ' 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'') ';
434: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
435: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id1',p_business_group_id);
436: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
437: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
438: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_LOCATIONS');
439: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
440: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);

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

433: ' 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'') ';
434: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
435: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id1',p_business_group_id);
436: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
437: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
438: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_LOCATIONS');
439: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
440: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
441: write(x,y,xmlstring1);

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

434: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
435: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id1',p_business_group_id);
436: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
437: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
438: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_LOCATIONS');
439: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
440: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
441: write(x,y,xmlstring1);
442: DBMS_XMLQuery.closeContext(queryCtx);

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

435: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id1',p_business_group_id);
436: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
437: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
438: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_LOCATIONS');
439: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
440: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
441: write(x,y,xmlstring1);
442: DBMS_XMLQuery.closeContext(queryCtx);
443: xmlString1 := null;

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

436: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
437: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
438: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_LOCATIONS');
439: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
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);

Line 442: DBMS_XMLQuery.closeContext(queryCtx);

438: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_LOCATIONS');
439: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
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:

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

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 ))';
455: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
456: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
457: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
458: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ASSIGNMENTS');
459: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);

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

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 ))';
455: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
456: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
457: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
458: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ASSIGNMENTS');
459: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
460: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);

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

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 ))';
455: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
456: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
457: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
458: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ASSIGNMENTS');
459: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
460: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
461: write(x,y,xmlstring1);

Line 458: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ASSIGNMENTS');

454: ' and p2.assignment_id = p1.assignment_id ))';
455: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
456: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
457: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
458: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ASSIGNMENTS');
459: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
460: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
461: write(x,y,xmlstring1);
462: DBMS_XMLQuery.closeContext(queryCtx);

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

455: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
456: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
457: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
458: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ASSIGNMENTS');
459: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
460: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
461: write(x,y,xmlstring1);
462: DBMS_XMLQuery.closeContext(queryCtx);
463: xmlString1 := null;

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

456: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
457: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
458: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ASSIGNMENTS');
459: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
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);

Line 462: DBMS_XMLQuery.closeContext(queryCtx);

458: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ASSIGNMENTS');
459: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
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:

Line 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');

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);
477: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);

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

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);
477: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
478: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);

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

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);
477: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
478: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
479: write(x,y,xmlstring1);

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

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);
477: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
478: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
479: write(x,y,xmlstring1);
480: DBMS_XMLQuery.closeContext(queryCtx);

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

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);
477: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
478: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
479: write(x,y,xmlstring1);
480: DBMS_XMLQuery.closeContext(queryCtx);
481: xmlString1 := null;

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

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);
477: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
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);

Line 480: DBMS_XMLQuery.closeContext(queryCtx);

476: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
477: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
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:

Line 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 ' ||

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);
493: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);

Line 491: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_HR_ORGANIZATIONS');

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);
493: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
494: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
495: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);

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

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);
493: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
494: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
495: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
496: write(x,y,xmlstring1);

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

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);
493: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
494: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
495: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
496: write(x,y,xmlstring1);
497: DBMS_XMLQuery.closeContext(queryCtx);

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

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);
493: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
494: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
495: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
496: write(x,y,xmlstring1);
497: DBMS_XMLQuery.closeContext(queryCtx);
498: xmlString1 := null;

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

491: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_HR_ORGANIZATIONS');
492: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
493: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
494: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
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);

Line 497: DBMS_XMLQuery.closeContext(queryCtx);

493: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
494: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
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:

Line 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');

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);
510: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);

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

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);
510: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
511: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);

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

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);
510: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
511: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
512: write(x,y,xmlstring1);

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

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);
510: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
511: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
512: write(x,y,xmlstring1);
513: DBMS_XMLQuery.closeContext(queryCtx);

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

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);
510: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
511: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
512: write(x,y,xmlstring1);
513: DBMS_XMLQuery.closeContext(queryCtx);
514: xmlString1 := null;

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

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);
510: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
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);

Line 513: DBMS_XMLQuery.closeContext(queryCtx);

509: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
510: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
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:

Line 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');

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);
526: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);

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

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);
526: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
527: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);

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

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);
526: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
527: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
528: write(x,y,xmlstring1);

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

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);
526: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
527: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
528: write(x,y,xmlstring1);
529: DBMS_XMLQuery.closeContext(queryCtx);

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

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);
526: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
527: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
528: write(x,y,xmlstring1);
529: DBMS_XMLQuery.closeContext(queryCtx);
530: xmlString1 := null;

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

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);
526: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
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);

Line 529: DBMS_XMLQuery.closeContext(queryCtx);

525: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
526: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
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:

Line 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');

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);
542: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);

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

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);
542: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
543: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);

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

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);
542: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
543: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
544: write(x,y,xmlstring1);

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

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);
542: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
543: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
544: write(x,y,xmlstring1);
545: DBMS_XMLQuery.closeContext(queryCtx);

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

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);
542: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
543: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
544: write(x,y,xmlstring1);
545: DBMS_XMLQuery.closeContext(queryCtx);
546: xmlString1 := null;

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

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);
542: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
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);

Line 545: DBMS_XMLQuery.closeContext(queryCtx);

541: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
542: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
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:

Line 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');

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);
558: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);

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

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);
558: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
559: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);

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

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);
558: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
559: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
560: write(x,y,xmlstring1);

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

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);
558: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
559: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
560: write(x,y,xmlstring1);
561: DBMS_XMLQuery.closeContext(queryCtx);

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

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);
558: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
559: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
560: write(x,y,xmlstring1);
561: DBMS_XMLQuery.closeContext(queryCtx);
562: xmlString1 := null;

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

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);
558: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
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);

Line 561: DBMS_XMLQuery.closeContext(queryCtx);

557: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
558: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
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:

Line 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');

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);
574: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);

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

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);
574: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
575: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);

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

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);
574: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
575: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
576: write(x,y,xmlstring1);

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

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);
574: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
575: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
576: write(x,y,xmlstring1);
577: DBMS_XMLQuery.closeContext(queryCtx);

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

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);
574: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
575: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
576: write(x,y,xmlstring1);
577: DBMS_XMLQuery.closeContext(queryCtx);
578: xmlString1 := null;

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

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);
574: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
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);

Line 577: DBMS_XMLQuery.closeContext(queryCtx);

573: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
574: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
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:

Line 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');

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');
590: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);

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

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');
590: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
591: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);

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

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');
590: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
591: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
592: write(x,y,xmlstring1);

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

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');
590: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
591: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
592: write(x,y,xmlstring1);
593: DBMS_XMLQuery.closeContext(queryCtx);

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

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');
590: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
591: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
592: write(x,y,xmlstring1);
593: DBMS_XMLQuery.closeContext(queryCtx);
594: xmlString1 := null;

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

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');
590: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
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);

Line 593: DBMS_XMLQuery.closeContext(queryCtx);

589: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ORG_PAYMENT_METHODS');
590: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
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:

Line 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');

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);
606: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);

Line 603: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_PATCH_STATUS');

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);
606: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
607: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);

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

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);
606: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
607: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
608: write(x,y,xmlstring1);

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

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);
606: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
607: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
608: write(x,y,xmlstring1);
609: DBMS_XMLQuery.closeContext(queryCtx);

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

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);
606: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
607: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
608: write(x,y,xmlstring1);
609: DBMS_XMLQuery.closeContext(queryCtx);
610: xmlString1 := null;

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

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);
606: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
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);

Line 609: DBMS_XMLQuery.closeContext(queryCtx);

605: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
606: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
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:

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

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 ))' ;
622: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
623: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_FEDERAL_TAX_RULES');
624: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
625: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
626: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);

Line 623: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_FEDERAL_TAX_RULES');

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 ))' ;
622: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
623: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_FEDERAL_TAX_RULES');
624: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
625: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
626: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
627: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);

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

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 ))' ;
622: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
623: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_FEDERAL_TAX_RULES');
624: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
625: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
626: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
627: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
628: write(x,y,xmlstring1);

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

621: ' and p2.emp_fed_tax_rule_id = p1.emp_fed_tax_rule_id ))' ;
622: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
623: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_FEDERAL_TAX_RULES');
624: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
625: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
626: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
627: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
628: write(x,y,xmlstring1);
629: DBMS_XMLQuery.closeContext(queryCtx);

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

622: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
623: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_FEDERAL_TAX_RULES');
624: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
625: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
626: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
627: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
628: write(x,y,xmlstring1);
629: DBMS_XMLQuery.closeContext(queryCtx);
630: xmlString1 := null;

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

623: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_FEDERAL_TAX_RULES');
624: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
625: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
626: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
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);

Line 629: DBMS_XMLQuery.closeContext(queryCtx);

625: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
626: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
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:

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

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 ))';
642: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
643: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_STATE_TAX_RULES');
644: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
645: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
646: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);

Line 643: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_STATE_TAX_RULES');

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 ))';
642: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
643: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_STATE_TAX_RULES');
644: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
645: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
646: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
647: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);

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

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 ))';
642: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
643: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_STATE_TAX_RULES');
644: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
645: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
646: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
647: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
648: write(x,y,xmlstring1);

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

641: ' and p2.emp_state_tax_rule_id = p1.emp_state_tax_rule_id ))';
642: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
643: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_STATE_TAX_RULES');
644: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
645: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
646: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
647: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
648: write(x,y,xmlstring1);
649: DBMS_XMLQuery.closeContext(queryCtx);

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

642: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
643: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_STATE_TAX_RULES');
644: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
645: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
646: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
647: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
648: write(x,y,xmlstring1);
649: DBMS_XMLQuery.closeContext(queryCtx);
650: xmlString1 := null;

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

643: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_STATE_TAX_RULES');
644: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
645: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
646: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
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);

Line 649: DBMS_XMLQuery.closeContext(queryCtx);

645: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
646: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
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:

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

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 ))';
663: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
664: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_COUNTY_TAX_RULES');
665: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
666: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
667: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);

Line 664: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_COUNTY_TAX_RULES');

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 ))';
663: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
664: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_COUNTY_TAX_RULES');
665: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
666: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
667: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
668: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);

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

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 ))';
663: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
664: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_COUNTY_TAX_RULES');
665: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
666: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
667: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
668: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
669: write(x,y,xmlstring1);

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

662: ' and p2.emp_county_tax_rule_id = p1.emp_county_tax_rule_id ))';
663: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
664: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_COUNTY_TAX_RULES');
665: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
666: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
667: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
668: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
669: write(x,y,xmlstring1);
670: DBMS_XMLQuery.closeContext(queryCtx);

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

663: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
664: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_COUNTY_TAX_RULES');
665: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
666: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
667: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
668: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
669: write(x,y,xmlstring1);
670: DBMS_XMLQuery.closeContext(queryCtx);
671: xmlString1 := null;

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

664: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_COUNTY_TAX_RULES');
665: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
666: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
667: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
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);

Line 670: DBMS_XMLQuery.closeContext(queryCtx);

666: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
667: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
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:

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

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 ))';
683: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
684: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_CITY_TAX_RULES');
685: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
686: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
687: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);

Line 684: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_CITY_TAX_RULES');

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 ))';
683: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
684: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_CITY_TAX_RULES');
685: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
686: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
687: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
688: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);

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

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 ))';
683: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
684: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_CITY_TAX_RULES');
685: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
686: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
687: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
688: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
689: write(x,y,xmlstring1);

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

682: ' and p2.emp_city_tax_rule_id = p1.emp_city_tax_rule_id ))';
683: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
684: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_CITY_TAX_RULES');
685: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
686: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
687: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
688: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
689: write(x,y,xmlstring1);
690: DBMS_XMLQuery.closeContext(queryCtx);

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

683: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
684: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_CITY_TAX_RULES');
685: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
686: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
687: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
688: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
689: write(x,y,xmlstring1);
690: DBMS_XMLQuery.closeContext(queryCtx);
691: xmlString1 := null;

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

684: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_CITY_TAX_RULES');
685: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
686: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
687: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
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);

Line 690: DBMS_XMLQuery.closeContext(queryCtx);

686: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
687: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
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:

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

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);
703: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
704: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ORGANIZATION_CLASS');
705: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);

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

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);
703: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
704: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ORGANIZATION_CLASS');
705: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
706: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);

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

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);
703: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
704: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ORGANIZATION_CLASS');
705: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
706: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
707: write(x,y,xmlstring1);

Line 704: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ORGANIZATION_CLASS');

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);
703: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
704: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ORGANIZATION_CLASS');
705: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
706: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
707: write(x,y,xmlstring1);
708: DBMS_XMLQuery.closeContext(queryCtx);

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

701: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
702: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
703: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
704: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ORGANIZATION_CLASS');
705: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
706: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
707: write(x,y,xmlstring1);
708: DBMS_XMLQuery.closeContext(queryCtx);
709: xmlString1 := null;

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

702: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
703: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
704: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ORGANIZATION_CLASS');
705: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
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);

Line 708: DBMS_XMLQuery.closeContext(queryCtx);

704: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ORGANIZATION_CLASS');
705: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
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:

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

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);
722: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
723: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_PERIODS_OF_SERVICE');
724: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);

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

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);
722: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
723: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_PERIODS_OF_SERVICE');
724: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
725: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);

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

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);
722: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
723: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_PERIODS_OF_SERVICE');
724: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
725: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
726: write(x,y,xmlstring1);

Line 723: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_PERIODS_OF_SERVICE');

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);
722: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
723: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_PERIODS_OF_SERVICE');
724: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
725: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
726: write(x,y,xmlstring1);
727: DBMS_XMLQuery.closeContext(queryCtx);

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

720: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
721: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
722: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
723: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_PERIODS_OF_SERVICE');
724: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
725: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
726: write(x,y,xmlstring1);
727: DBMS_XMLQuery.closeContext(queryCtx);
728: xmlString1 := null;

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

721: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
722: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
723: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_PERIODS_OF_SERVICE');
724: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
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);

Line 727: DBMS_XMLQuery.closeContext(queryCtx);

723: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_PERIODS_OF_SERVICE');
724: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
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:

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

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);
740: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
741: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_SALARIES');
742: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);

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

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);
740: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
741: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_SALARIES');
742: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
743: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);

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

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);
740: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
741: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_SALARIES');
742: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
743: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
744: write(x,y,xmlstring1);

Line 741: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_SALARIES');

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);
740: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
741: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_SALARIES');
742: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
743: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
744: write(x,y,xmlstring1);
745: DBMS_XMLQuery.closeContext(queryCtx);

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

738: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
739: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
740: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
741: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_SALARIES');
742: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
743: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
744: write(x,y,xmlstring1);
745: DBMS_XMLQuery.closeContext(queryCtx);
746: xmlString1 := null;

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

739: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
740: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
741: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_SALARIES');
742: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
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);

Line 745: DBMS_XMLQuery.closeContext(queryCtx);

741: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_SALARIES');
742: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
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:

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

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

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

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);
762: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);

Line 759: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_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);
762: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
763: write(x,y,xmlstring1);

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

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);
762: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
763: write(x,y,xmlstring1);
764: DBMS_XMLQuery.closeContext(queryCtx);

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

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);
762: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
763: write(x,y,xmlstring1);
764: DBMS_XMLQuery.closeContext(queryCtx);
765: xmlString1 := null;

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

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

Line 764: DBMS_XMLQuery.closeContext(queryCtx);

760: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ORGANIZATION_INFO');
761: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
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:

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

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 ))';
777: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
778: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
779: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
780: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_COST_ALLOCATIONS');
781: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);

Line 778: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_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 ))';
777: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
778: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
779: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
780: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_COST_ALLOCATIONS');
781: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
782: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);

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

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 ))';
777: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
778: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
779: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
780: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_COST_ALLOCATIONS');
781: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
782: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
783: write(x,y,xmlstring1);

Line 780: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_COST_ALLOCATIONS');

776: ' and p2.cost_allocation_id = p1.cost_allocation_id ))';
777: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
778: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
779: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
780: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_COST_ALLOCATIONS');
781: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
782: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
783: write(x,y,xmlstring1);
784: DBMS_XMLQuery.closeContext(queryCtx);

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

777: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
778: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
779: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
780: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_COST_ALLOCATIONS');
781: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
782: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
783: write(x,y,xmlstring1);
784: DBMS_XMLQuery.closeContext(queryCtx);
785: xmlString1 := null;

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

778: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
779: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
780: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_COST_ALLOCATIONS');
781: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
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);

Line 784: DBMS_XMLQuery.closeContext(queryCtx);

780: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_COST_ALLOCATIONS');
781: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
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:

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

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'') ' ||
798: ' and p2.personal_payment_method_id = p1.personal_payment_method_id ))';
799: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
800: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
801: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
802: --DBMS_XMLQuery.setBindValue(queryCtx,'q_payee_type','P');
803: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_PAYMENT_METHODS');

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

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'') ' ||
798: ' and p2.personal_payment_method_id = p1.personal_payment_method_id ))';
799: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
800: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
801: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
802: --DBMS_XMLQuery.setBindValue(queryCtx,'q_payee_type','P');
803: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_PAYMENT_METHODS');
804: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);

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

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'') ' ||
798: ' and p2.personal_payment_method_id = p1.personal_payment_method_id ))';
799: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
800: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
801: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
802: --DBMS_XMLQuery.setBindValue(queryCtx,'q_payee_type','P');
803: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_PAYMENT_METHODS');
804: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
805: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);

Line 802: --DBMS_XMLQuery.setBindValue(queryCtx,'q_payee_type','P');

798: ' and p2.personal_payment_method_id = p1.personal_payment_method_id ))';
799: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
800: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
801: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
802: --DBMS_XMLQuery.setBindValue(queryCtx,'q_payee_type','P');
803: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_PAYMENT_METHODS');
804: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
805: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
806: write(x,y,xmlstring1);

Line 803: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_PAYMENT_METHODS');

799: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
800: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
801: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
802: --DBMS_XMLQuery.setBindValue(queryCtx,'q_payee_type','P');
803: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_PAYMENT_METHODS');
804: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
805: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
806: write(x,y,xmlstring1);
807: DBMS_XMLQuery.closeContext(queryCtx);

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

800: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
801: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
802: --DBMS_XMLQuery.setBindValue(queryCtx,'q_payee_type','P');
803: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_PAYMENT_METHODS');
804: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
805: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
806: write(x,y,xmlstring1);
807: DBMS_XMLQuery.closeContext(queryCtx);
808: xmlString1 := null;

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

801: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
802: --DBMS_XMLQuery.setBindValue(queryCtx,'q_payee_type','P');
803: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_PAYMENT_METHODS');
804: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
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);

Line 807: DBMS_XMLQuery.closeContext(queryCtx);

803: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_PAYMENT_METHODS');
804: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
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:

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

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);
820: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
821: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ELEMENT_NAMES');
822: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);

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

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);
820: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
821: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ELEMENT_NAMES');
822: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
823: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);

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

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);
820: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
821: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ELEMENT_NAMES');
822: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
823: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
824: write(x,y,xmlstring1);

Line 821: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ELEMENT_NAMES');

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);
820: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
821: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ELEMENT_NAMES');
822: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
823: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
824: write(x,y,xmlstring1);
825: DBMS_XMLQuery.closeContext(queryCtx);

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

818: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
819: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
820: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
821: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ELEMENT_NAMES');
822: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
823: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
824: write(x,y,xmlstring1);
825: DBMS_XMLQuery.closeContext(queryCtx);
826: xmlString1 := null;

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

819: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
820: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
821: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ELEMENT_NAMES');
822: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
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);

Line 825: DBMS_XMLQuery.closeContext(queryCtx);

821: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ELEMENT_NAMES');
822: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
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:

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

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 ))';
838: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
839: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
840: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
841: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ELEMENT_ENTRIES');
842: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);

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

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 ))';
838: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
839: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
840: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
841: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ELEMENT_ENTRIES');
842: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
843: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);

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

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 ))';
838: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
839: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
840: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
841: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ELEMENT_ENTRIES');
842: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
843: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
844: write(x,y,xmlstring1);

Line 841: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ELEMENT_ENTRIES');

837: ' and p2.element_entry_id = p1.element_entry_id ))';
838: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
839: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
840: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
841: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ELEMENT_ENTRIES');
842: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
843: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
844: write(x,y,xmlstring1);
845: DBMS_XMLQuery.closeContext(queryCtx);

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

838: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
839: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
840: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
841: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ELEMENT_ENTRIES');
842: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
843: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
844: write(x,y,xmlstring1);
845: DBMS_XMLQuery.closeContext(queryCtx);
846: xmlString1 := null;

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

839: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
840: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
841: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ELEMENT_ENTRIES');
842: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
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);

Line 845: DBMS_XMLQuery.closeContext(queryCtx);

841: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ELEMENT_ENTRIES');
842: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
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:

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

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 ))';
859: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
860: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
861: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
862: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ELEMENT_ENTRY_VALUES');
863: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);

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

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 ))';
859: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
860: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
861: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
862: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ELEMENT_ENTRY_VALUES');
863: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
864: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);

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

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 ))';
859: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
860: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
861: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
862: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ELEMENT_ENTRY_VALUES');
863: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
864: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
865: write(x,y,xmlstring1);

Line 862: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ELEMENT_ENTRY_VALUES');

858: ' and p2.element_entry_id = p1.element_entry_id ))';
859: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
860: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
861: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
862: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ELEMENT_ENTRY_VALUES');
863: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
864: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
865: write(x,y,xmlstring1);
866: DBMS_XMLQuery.closeContext(queryCtx);

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

859: queryCtx := DBMS_XMLQuery.newContext(l_query_string);
860: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
861: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
862: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ELEMENT_ENTRY_VALUES');
863: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
864: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
865: write(x,y,xmlstring1);
866: DBMS_XMLQuery.closeContext(queryCtx);
867: xmlString1 := null;

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

860: DBMS_XMLQuery.setBindValue(queryCtx,'q_bg_id',p_business_group_id);
861: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
862: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ELEMENT_ENTRY_VALUES');
863: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
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);

Line 866: DBMS_XMLQuery.closeContext(queryCtx);

862: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_ELEMENT_ENTRY_VALUES');
863: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
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:

Line 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) ');

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');
879: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);

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

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');
879: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
880: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);

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

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');
879: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
880: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
881: write(x,y,xmlstring1);

Line 878: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_US_MODIFIED_GEOCODES');

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');
879: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
880: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
881: write(x,y,xmlstring1);
882: DBMS_XMLQuery.closeContext(queryCtx);

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

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');
879: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
880: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
881: write(x,y,xmlstring1);
882: DBMS_XMLQuery.closeContext(queryCtx);
883: xmlString1 := null;

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

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');
879: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
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);

Line 882: DBMS_XMLQuery.closeContext(queryCtx);

878: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_US_MODIFIED_GEOCODES');
879: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
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:

Line 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');

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);
895: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);

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

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);
895: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
896: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);

Line 893: DBMS_XMLQuery.setRowsetTag(queryCtx,'HR_H2PI_US_CITY_NAMES');

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);
895: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
896: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
897: write(x,y,xmlstring1);

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

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);
895: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
896: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
897: write(x,y,xmlstring1);
898: DBMS_XMLQuery.closeContext(queryCtx);

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

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);
895: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
896: xmlString1 := DBMS_XMLQuery.getXML(queryCtx);
897: write(x,y,xmlstring1);
898: DBMS_XMLQuery.closeContext(queryCtx);
899: xmlString1 := null;

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

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);
895: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
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);

Line 898: DBMS_XMLQuery.closeContext(queryCtx);

894: DBMS_XMLQuery.setBindValue(queryCtx,'q_client_id',p_client_id);
895: DBMS_XMLQuery.setMaxRows(queryCtx,99999999);
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: