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.PER_VETS_MAG_REPORT dependencies on HR_UTILITY

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

511: begin
512: --
513: -- Set form type
514: --
515: hr_utility.set_location(l_proc,10);
516: hr_utility.trace('l_estab_rec.max_count : ' || l_estab_rec.max_count);
517: if l_estab_rec.hq = 'Y' and
518: nvl(l_org_rec.form_type,'-1') <> 'S' then
519: --

Line 516: hr_utility.trace('l_estab_rec.max_count : ' || l_estab_rec.max_count);

512: --
513: -- Set form type
514: --
515: hr_utility.set_location(l_proc,10);
516: hr_utility.trace('l_estab_rec.max_count : ' || l_estab_rec.max_count);
517: if l_estab_rec.hq = 'Y' and
518: nvl(l_org_rec.form_type,'-1') <> 'S' then
519: --
520: hr_utility.set_location(l_proc,20);

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

516: hr_utility.trace('l_estab_rec.max_count : ' || l_estab_rec.max_count);
517: if l_estab_rec.hq = 'Y' and
518: nvl(l_org_rec.form_type,'-1') <> 'S' then
519: --
520: hr_utility.set_location(l_proc,20);
521: l_org_rec.form_type := 'MHQ';
522: --
523: end if;
524: --

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

529: l_tot_emps >= 50
530: or l_all_estab = 'N'
531: ) then
532: --
533: hr_utility.set_location(l_proc,30);
534: l_org_rec.form_type := 'MHL';
535: --
536: end if;
537: --

Line 1410: hr_utility.set_location(l_proc,10);

1406: l_proc varchar2(40) := 'loop_through_establishments';
1407: --
1408: begin
1409: --
1410: hr_utility.set_location(l_proc,10);
1411: --
1412: open c1;
1413: --
1414: loop

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

1415: --
1416: fetch c1 into l_c1;
1417: exit when c1%notfound;
1418: --
1419: hr_utility.set_location(l_proc,20);
1420: hr_utility.trace('l_c1.street : ' || l_c1.street);
1421: l_estab_rec := l_estab_rec_blank;
1422: --
1423: l_hierarchy_node_id := l_c1.hierarchy_node_id;

Line 1420: hr_utility.trace('l_c1.street : ' || l_c1.street);

1416: fetch c1 into l_c1;
1417: exit when c1%notfound;
1418: --
1419: hr_utility.set_location(l_proc,20);
1420: hr_utility.trace('l_c1.street : ' || l_c1.street);
1421: l_estab_rec := l_estab_rec_blank;
1422: --
1423: l_hierarchy_node_id := l_c1.hierarchy_node_id;
1424: l_estab_rec.reporting_name := l_c1.reporting_name;

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

1439: --
1440: fetch c2 into l_c2;
1441: exit when c2%notfound;
1442: --
1443: hr_utility.set_location(l_proc,30);
1444: if l_c2.lookup_code = '1' then
1445: --
1446: l_estab_rec.l1_total := l_c2.no_dis_vets;
1447: l_estab_rec.m1_total := l_c2.no_viet_vets;

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

1507: --
1508: fetch c3 into l_c3;
1509: exit when c3%notfound;
1510: --
1511: hr_utility.set_location(l_proc,40);
1512: if l_c3.lookup_code = '1' then
1513: --
1514: l_estab_rec.o1_total := l_c3.no_nh_dis_vets;
1515: l_estab_rec.p1_total := l_c3.no_nh_viet_vets;

Line 1626: hr_utility.trace('l_c1.state : ' || l_c1.state);

1622: end loop;
1623: --
1624: close c3;
1625: --
1626: hr_utility.trace('l_c1.state : ' || l_c1.state);
1627: hr_utility.trace('l_consol_rec.state : ' || l_consol_rec.state);
1628: if l_c1.state <> nvl(l_consol_rec.state,l_c1.state) then
1629: --
1630: -- Write out the old consolidated report and

Line 1627: hr_utility.trace('l_consol_rec.state : ' || l_consol_rec.state);

1623: --
1624: close c3;
1625: --
1626: hr_utility.trace('l_c1.state : ' || l_c1.state);
1627: hr_utility.trace('l_consol_rec.state : ' || l_consol_rec.state);
1628: if l_c1.state <> nvl(l_consol_rec.state,l_c1.state) then
1629: --
1630: -- Write out the old consolidated report and
1631: -- process the next record which is for a different state.

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

1629: --
1630: -- Write out the old consolidated report and
1631: -- process the next record which is for a different state.
1632: --
1633: hr_utility.set_location(l_proc,50);
1634: write_consolidated_record;
1635: l_consol_rec := l_estab_rec_blank;
1636: l_month_rec := l_month_rec_blank;
1637: --

Line 1645: hr_utility.trace('l_tot_emps : ' || l_tot_emps);

1641: --
1642: open c_tot_emps;
1643: fetch c_tot_emps into l_tot_emps;
1644: close c_tot_emps;
1645: hr_utility.trace('l_tot_emps : ' || l_tot_emps);
1646:
1647: --while l_start_date < p_end_date loop
1648: for l_month_number in 1 .. 12 loop
1649:

Line 1653: hr_utility.trace('l_month_start_date : ' || l_month_start_date);

1649:
1650: l_month_start_date := ADD_MONTHS(p_end_date,-l_month_number);
1651: l_month_end_date := ADD_MONTHS(l_month_start_date,1);
1652:
1653: hr_utility.trace('l_month_start_date : ' || l_month_start_date);
1654: hr_utility.trace('l_month_end_date : ' || l_month_end_date);
1655: --
1656: open c_min_max;
1657: --

Line 1654: hr_utility.trace('l_month_end_date : ' || l_month_end_date);

1650: l_month_start_date := ADD_MONTHS(p_end_date,-l_month_number);
1651: l_month_end_date := ADD_MONTHS(l_month_start_date,1);
1652:
1653: hr_utility.trace('l_month_start_date : ' || l_month_start_date);
1654: hr_utility.trace('l_month_end_date : ' || l_month_end_date);
1655: --
1656: open c_min_max;
1657: --
1658: fetch c_min_max into l_min_max;

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

1657: --
1658: fetch c_min_max into l_min_max;
1659:
1660: --
1661: hr_utility.set_location(l_proc,60);
1662: hr_utility.trace('l_min_max : ' || l_min_max.num_people);
1663: hr_utility.trace('p_hierarchy_version_id : ' || p_hierarchy_version_id);
1664: hr_utility.trace('l_hierarchy_node_id : ' || l_hierarchy_node_id);
1665: if l_estab_rec.min_count is null then

Line 1662: hr_utility.trace('l_min_max : ' || l_min_max.num_people);

1658: fetch c_min_max into l_min_max;
1659:
1660: --
1661: hr_utility.set_location(l_proc,60);
1662: hr_utility.trace('l_min_max : ' || l_min_max.num_people);
1663: hr_utility.trace('p_hierarchy_version_id : ' || p_hierarchy_version_id);
1664: hr_utility.trace('l_hierarchy_node_id : ' || l_hierarchy_node_id);
1665: if l_estab_rec.min_count is null then
1666: --

Line 1663: hr_utility.trace('p_hierarchy_version_id : ' || p_hierarchy_version_id);

1659:
1660: --
1661: hr_utility.set_location(l_proc,60);
1662: hr_utility.trace('l_min_max : ' || l_min_max.num_people);
1663: hr_utility.trace('p_hierarchy_version_id : ' || p_hierarchy_version_id);
1664: hr_utility.trace('l_hierarchy_node_id : ' || l_hierarchy_node_id);
1665: if l_estab_rec.min_count is null then
1666: --
1667: l_estab_rec.min_count := l_min_max.num_people;

Line 1664: hr_utility.trace('l_hierarchy_node_id : ' || l_hierarchy_node_id);

1660: --
1661: hr_utility.set_location(l_proc,60);
1662: hr_utility.trace('l_min_max : ' || l_min_max.num_people);
1663: hr_utility.trace('p_hierarchy_version_id : ' || p_hierarchy_version_id);
1664: hr_utility.trace('l_hierarchy_node_id : ' || l_hierarchy_node_id);
1665: if l_estab_rec.min_count is null then
1666: --
1667: l_estab_rec.min_count := l_min_max.num_people;
1668: --

Line 1798: --hr_utility.trace_on(null,'ORACLE');

1794: l_count number;
1795: --
1796: begin
1797: --
1798: --hr_utility.trace_on(null,'ORACLE');
1799: l_org_rec.ending_period := to_char(l_end_date,'MMDDYYYY');
1800: l_all_estab := p_all_establishments; -- BUG3695203
1801: set_org_details(p_hierarchy_version_id => p_hierarchy_version_id,
1802: p_business_group_id => p_business_group_id);