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

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

602: begin
603: --
604: -- Set form type
605: --
606: hr_utility.set_location(l_proc,10);
607: hr_utility.trace('l_estab_rec.max_count : ' || l_estab_rec.max_count);
608: if l_estab_rec.hq = 'Y' and
609: nvl(l_org_rec.form_type,'-1') <> 'S' then
610: --

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

603: --
604: -- Set form type
605: --
606: hr_utility.set_location(l_proc,10);
607: hr_utility.trace('l_estab_rec.max_count : ' || l_estab_rec.max_count);
608: if l_estab_rec.hq = 'Y' and
609: nvl(l_org_rec.form_type,'-1') <> 'S' then
610: --
611: hr_utility.set_location(l_proc,20);

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

607: hr_utility.trace('l_estab_rec.max_count : ' || l_estab_rec.max_count);
608: if l_estab_rec.hq = 'Y' and
609: nvl(l_org_rec.form_type,'-1') <> 'S' then
610: --
611: hr_utility.set_location(l_proc,20);
612: l_org_rec.form_type := 'MHQ';
613: --
614: end if;
615: --

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

620: l_tot_emps >= 50
621: or l_all_estab = 'N'
622: ) then
623: --
624: hr_utility.set_location(l_proc,30);
625: l_org_rec.form_type := 'MHL';
626: --
627: end if;
628: --

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

1546: l_proc varchar2(40) := 'loop_through_establishments';
1547: --
1548: begin
1549: --
1550: hr_utility.set_location(l_proc,10);
1551: --
1552: open c1;
1553: --
1554: loop

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

1555: --
1556: fetch c1 into l_c1;
1557: exit when c1%notfound;
1558: --
1559: hr_utility.set_location(l_proc,20);
1560: hr_utility.trace('l_c1.street : ' || l_c1.street);
1561: l_estab_rec := l_estab_rec_blank;
1562: --
1563: l_hierarchy_node_id := l_c1.hierarchy_node_id;

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

1556: fetch c1 into l_c1;
1557: exit when c1%notfound;
1558: --
1559: hr_utility.set_location(l_proc,20);
1560: hr_utility.trace('l_c1.street : ' || l_c1.street);
1561: l_estab_rec := l_estab_rec_blank;
1562: --
1563: l_hierarchy_node_id := l_c1.hierarchy_node_id;
1564: l_estab_rec.reporting_name := l_c1.reporting_name;

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

1580: --
1581: fetch c2 into l_c2;
1582: exit when c2%notfound;
1583: --
1584: hr_utility.set_location(l_proc,30);
1585: if l_c2.lookup_code = '10' then
1586: --Executive/Senior Level Officials and Managers
1587: l_estab_rec.l1_total := l_c2.no_dis_vets;
1588: l_estab_rec.m1_total := l_c2.no_other_vets;

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

1813: --
1814: fetch c3 into l_c3;
1815: exit when c3%notfound;
1816: --
1817: hr_utility.set_location(l_proc,40);
1818: if l_c3.lookup_code = '10' then
1819: --
1820: l_estab_rec.q1_total := l_c3.nh_dis_vets;
1821: l_estab_rec.r1_total := l_c3.nh_other_vets;

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

2033: --
2034: end loop;
2035: --
2036: close c3_ns;
2037: hr_utility.trace('l_c1.state : ' || l_c1.state);
2038: hr_utility.trace('l_consol_rec.state : ' || l_consol_rec.state);
2039: if l_c1.state <> nvl(l_consol_rec.state,l_c1.state) then
2040: --
2041: -- Write out the old consolidated report and

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

2034: end loop;
2035: --
2036: close c3_ns;
2037: hr_utility.trace('l_c1.state : ' || l_c1.state);
2038: hr_utility.trace('l_consol_rec.state : ' || l_consol_rec.state);
2039: if l_c1.state <> nvl(l_consol_rec.state,l_c1.state) then
2040: --
2041: -- Write out the old consolidated report and
2042: -- process the next record which is for a different state.

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

2040: --
2041: -- Write out the old consolidated report and
2042: -- process the next record which is for a different state.
2043: --
2044: hr_utility.set_location(l_proc,50);
2045: write_consolidated_record;
2046: l_consol_rec := l_estab_rec_blank;
2047: l_month_rec := l_month_rec_blank;
2048: --

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

2052: --
2053: open c_tot_emps;
2054: fetch c_tot_emps into l_tot_emps;
2055: close c_tot_emps;
2056: hr_utility.trace('l_tot_emps : ' || l_tot_emps);
2057:
2058: --while l_start_date < p_end_date loop
2059: for l_month_number in 1 .. 12 loop
2060:

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

2062: l_month_start_date := ADD_MONTHS(p_end_date,-l_month_number)+1;
2063: l_month_end_date := ADD_MONTHS(l_month_start_date,1)-1;
2064:
2065:
2066: hr_utility.trace('l_month_start_date : ' || l_month_start_date);
2067: hr_utility.trace('l_month_end_date : ' || l_month_end_date);
2068: --
2069: open c_min_max;
2070: --

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

2063: l_month_end_date := ADD_MONTHS(l_month_start_date,1)-1;
2064:
2065:
2066: hr_utility.trace('l_month_start_date : ' || l_month_start_date);
2067: hr_utility.trace('l_month_end_date : ' || l_month_end_date);
2068: --
2069: open c_min_max;
2070: --
2071: fetch c_min_max into l_min_max;

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

2070: --
2071: fetch c_min_max into l_min_max;
2072:
2073: --
2074: hr_utility.set_location(l_proc,60);
2075: hr_utility.trace('l_min_max : ' || l_min_max.num_people);
2076: hr_utility.trace('p_hierarchy_version_id : ' || p_hierarchy_version_id);
2077: hr_utility.trace('l_hierarchy_node_id : ' || l_hierarchy_node_id);
2078: if l_estab_rec.min_count is null then

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

2071: fetch c_min_max into l_min_max;
2072:
2073: --
2074: hr_utility.set_location(l_proc,60);
2075: hr_utility.trace('l_min_max : ' || l_min_max.num_people);
2076: hr_utility.trace('p_hierarchy_version_id : ' || p_hierarchy_version_id);
2077: hr_utility.trace('l_hierarchy_node_id : ' || l_hierarchy_node_id);
2078: if l_estab_rec.min_count is null then
2079: --

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

2072:
2073: --
2074: hr_utility.set_location(l_proc,60);
2075: hr_utility.trace('l_min_max : ' || l_min_max.num_people);
2076: hr_utility.trace('p_hierarchy_version_id : ' || p_hierarchy_version_id);
2077: hr_utility.trace('l_hierarchy_node_id : ' || l_hierarchy_node_id);
2078: if l_estab_rec.min_count is null then
2079: --
2080: l_estab_rec.min_count := l_min_max.num_people;

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

2073: --
2074: hr_utility.set_location(l_proc,60);
2075: hr_utility.trace('l_min_max : ' || l_min_max.num_people);
2076: hr_utility.trace('p_hierarchy_version_id : ' || p_hierarchy_version_id);
2077: hr_utility.trace('l_hierarchy_node_id : ' || l_hierarchy_node_id);
2078: if l_estab_rec.min_count is null then
2079: --
2080: l_estab_rec.min_count := l_min_max.num_people;
2081: --

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

2207: l_count number;
2208: --
2209: begin
2210: --
2211: --hr_utility.trace_on(null,'ORACLE');
2212: l_org_rec.ending_period := to_char(l_end_date,'MMDDYYYY');
2213: l_all_estab := p_all_establishments;
2214: set_org_details(p_hierarchy_version_id => p_hierarchy_version_id,
2215: p_business_group_id => p_business_group_id);