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 576: hr_utility.set_location(l_proc,10);

572: begin
573: --
574: -- Set form type
575: --
576: hr_utility.set_location(l_proc,10);
577: hr_utility.trace('l_estab_rec.max_count : ' || l_estab_rec.max_count);
578: if l_estab_rec.hq = 'Y' and
579: nvl(l_org_rec.form_type,'-1') <> 'S' then
580: --

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

573: --
574: -- Set form type
575: --
576: hr_utility.set_location(l_proc,10);
577: hr_utility.trace('l_estab_rec.max_count : ' || l_estab_rec.max_count);
578: if l_estab_rec.hq = 'Y' and
579: nvl(l_org_rec.form_type,'-1') <> 'S' then
580: --
581: hr_utility.set_location(l_proc,20);

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

577: hr_utility.trace('l_estab_rec.max_count : ' || l_estab_rec.max_count);
578: if l_estab_rec.hq = 'Y' and
579: nvl(l_org_rec.form_type,'-1') <> 'S' then
580: --
581: hr_utility.set_location(l_proc,20);
582: l_org_rec.form_type := 'MHQ';
583: --
584: end if;
585: --

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

590: l_tot_emps >= 50
591: or l_all_estab = 'N'
592: ) then
593: --
594: hr_utility.set_location(l_proc,30);
595: l_org_rec.form_type := 'MHL';
596: --
597: end if;
598: --

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

1530: l_proc varchar2(40) := 'loop_through_establishments';
1531: --
1532: begin
1533: --
1534: hr_utility.set_location(l_proc,10);
1535: --
1536: open c1;
1537: --
1538: loop

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

1539: --
1540: fetch c1 into l_c1;
1541: exit when c1%notfound;
1542: --
1543: hr_utility.set_location(l_proc,20);
1544: hr_utility.trace('l_c1.street : ' || l_c1.street);
1545: l_estab_rec := l_estab_rec_blank;
1546: --
1547: l_hierarchy_node_id := l_c1.hierarchy_node_id;

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

1540: fetch c1 into l_c1;
1541: exit when c1%notfound;
1542: --
1543: hr_utility.set_location(l_proc,20);
1544: hr_utility.trace('l_c1.street : ' || l_c1.street);
1545: l_estab_rec := l_estab_rec_blank;
1546: --
1547: l_hierarchy_node_id := l_c1.hierarchy_node_id;
1548: l_estab_rec.reporting_name := l_c1.reporting_name;

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

1564: --
1565: fetch c2 into l_c2;
1566: exit when c2%notfound;
1567: --
1568: hr_utility.set_location(l_proc,30);
1569: if l_c2.lookup_code = '1' then
1570: --
1571: l_estab_rec.l1_total := l_c2.no_dis_vets;
1572: l_estab_rec.m1_total := l_c2.no_viet_vets;

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

1643: exit when c3%notfound;
1644: --
1645: /*Bug 13905482 : Columns shifted as new column O is added
1646: Replaced the columns 'O', 'P', 'Q', 'R','S' by 'P','Q', 'S', 'R', 'T' respectively */
1647: hr_utility.set_location(l_proc,40);
1648: if l_c3.lookup_code = '1' then
1649: --
1650: l_estab_rec.p1_total := l_c3.no_nh_dis_vets;
1651: l_estab_rec.q1_total := l_c3.no_nh_viet_vets;

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

1767: end loop;
1768: --
1769: close c3;
1770: --
1771: hr_utility.trace('l_c1.state : ' || l_c1.state);
1772: hr_utility.trace('l_consol_rec.state : ' || l_consol_rec.state);
1773: if l_c1.state <> nvl(l_consol_rec.state,l_c1.state) then
1774: --
1775: -- Write out the old consolidated report and

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

1768: --
1769: close c3;
1770: --
1771: hr_utility.trace('l_c1.state : ' || l_c1.state);
1772: hr_utility.trace('l_consol_rec.state : ' || l_consol_rec.state);
1773: if l_c1.state <> nvl(l_consol_rec.state,l_c1.state) then
1774: --
1775: -- Write out the old consolidated report and
1776: -- process the next record which is for a different state.

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

1774: --
1775: -- Write out the old consolidated report and
1776: -- process the next record which is for a different state.
1777: --
1778: hr_utility.set_location(l_proc,50);
1779: write_consolidated_record;
1780: l_consol_rec := l_estab_rec_blank;
1781: l_month_rec := l_month_rec_blank;
1782: --

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

1786: --
1787: open c_tot_emps;
1788: fetch c_tot_emps into l_tot_emps;
1789: close c_tot_emps;
1790: hr_utility.trace('l_tot_emps : ' || l_tot_emps);
1791:
1792: --while l_start_date < p_end_date loop
1793: for l_month_number in 1 .. 12 loop
1794:

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

1795: --9000119
1796: l_month_start_date := ADD_MONTHS(p_end_date,-l_month_number)+1;
1797: l_month_end_date := ADD_MONTHS(l_month_start_date,1)-1;
1798:
1799: hr_utility.trace('l_month_start_date : ' || l_month_start_date);
1800: hr_utility.trace('l_month_end_date : ' || l_month_end_date);
1801: --
1802: open c_min_max;
1803: --

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

1796: l_month_start_date := ADD_MONTHS(p_end_date,-l_month_number)+1;
1797: l_month_end_date := ADD_MONTHS(l_month_start_date,1)-1;
1798:
1799: hr_utility.trace('l_month_start_date : ' || l_month_start_date);
1800: hr_utility.trace('l_month_end_date : ' || l_month_end_date);
1801: --
1802: open c_min_max;
1803: --
1804: fetch c_min_max into l_min_max;

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

1803: --
1804: fetch c_min_max into l_min_max;
1805:
1806: --
1807: hr_utility.set_location(l_proc,60);
1808: hr_utility.trace('l_min_max : ' || l_min_max.num_people);
1809: hr_utility.trace('p_hierarchy_version_id : ' || p_hierarchy_version_id);
1810: hr_utility.trace('l_hierarchy_node_id : ' || l_hierarchy_node_id);
1811: if l_estab_rec.min_count is null then

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

1804: fetch c_min_max into l_min_max;
1805:
1806: --
1807: hr_utility.set_location(l_proc,60);
1808: hr_utility.trace('l_min_max : ' || l_min_max.num_people);
1809: hr_utility.trace('p_hierarchy_version_id : ' || p_hierarchy_version_id);
1810: hr_utility.trace('l_hierarchy_node_id : ' || l_hierarchy_node_id);
1811: if l_estab_rec.min_count is null then
1812: --

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

1805:
1806: --
1807: hr_utility.set_location(l_proc,60);
1808: hr_utility.trace('l_min_max : ' || l_min_max.num_people);
1809: hr_utility.trace('p_hierarchy_version_id : ' || p_hierarchy_version_id);
1810: hr_utility.trace('l_hierarchy_node_id : ' || l_hierarchy_node_id);
1811: if l_estab_rec.min_count is null then
1812: --
1813: l_estab_rec.min_count := l_min_max.num_people;

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

1806: --
1807: hr_utility.set_location(l_proc,60);
1808: hr_utility.trace('l_min_max : ' || l_min_max.num_people);
1809: hr_utility.trace('p_hierarchy_version_id : ' || p_hierarchy_version_id);
1810: hr_utility.trace('l_hierarchy_node_id : ' || l_hierarchy_node_id);
1811: if l_estab_rec.min_count is null then
1812: --
1813: l_estab_rec.min_count := l_min_max.num_people;
1814: --

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

1940: l_count number;
1941: --
1942: begin
1943: --
1944: --hr_utility.trace_on(null,'ORACLE');
1945: l_org_rec.ending_period := to_char(l_end_date,'MMDDYYYY');
1946: l_all_estab := p_all_establishments; -- BUG3695203
1947:
1948: set_org_details(p_hierarchy_version_id => p_hierarchy_version_id,