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_US_REPORTS dependencies on HR_US_REPORTS

Line 1: PACKAGE BODY hr_us_reports AS

1: PACKAGE BODY hr_us_reports AS
2: /* $Header: pyuslrep.pkb 120.3.12010000.2 2008/08/06 08:33:19 ubhat ship $ */
3: /*
4: ******************************************************************
5: * *

Line 22: Name : hr_us_reports (BODY)

18: * Oracle Park, Bittams Lane, Guildford Road, Chertsey, Surrey, *
19: * England. *
20: * *
21: ******************************************************************
22: Name : hr_us_reports (BODY)
23: File : pyuslrep.pkb
24: Description : This package declares functions and procedures which are used
25: to return values for the srw2 US Payroll r10 reports.
26:

Line 227: hr_utility.set_location('hr_us_reports.get_salary',5);

223: l_frequency per_all_assignments_f.frequency%type;
224: --
225: Begin
226: --
227: hr_utility.set_location('hr_us_reports.get_salary',5);
228: hr_utility.trace('p_business_group_id ->'||to_char(p_business_group_id));
229: hr_utility.trace('p_assignment_id ->'||to_char(p_assignment_id));
230: hr_utility.trace('p_report_date ->'||p_report_date );
231: --

Line 285: hr_utility.set_location('hr_us_reports.get_salary',10);

281: --
282: exception
283: when NO_DATA_FOUND then RETURN NULL;
284: when others then
285: hr_utility.set_location('hr_us_reports.get_salary',10);
286: RETURN NULL;
287: --
288: end;
289: --

Line 295: hr_utility.set_location('hr_us_reports.get_salary',15);

291: l_annual_salary := hr_us_ff_udfs.Convert_Period_Type
292: (p_business_group_id,null,l_work_schedule,l_normal_hours,l_salary,l_pay_basis,'Year',
293: null,null,l_frequency); -- Bug 3669973
294: --
295: hr_utility.set_location('hr_us_reports.get_salary',15);
296: hr_utility.trace('l_annual_salary ->'||to_char(l_annual_salary));
297: --
298: return (l_annual_salary);
299: --

Line 338: hr_utility.set_location('Entered hr_us_reports.get_new_hire_contact',5);

334:
335: --
336: begin
337: --
338: hr_utility.set_location('Entered hr_us_reports.get_new_hire_contact',5);
339: --
340: OPEN c_new_hire_record;
341:
342: --LOOP

Line 356: hr_utility.set_location('Leaving hr_us_reports.get_new_hire_contact',10);

352: CLOSE c_new_hire_record;
353: --
354: hr_utility.trace('Contact name : '||v_contact_name);
355: hr_utility.trace('Contact title : '||v_contact_title);
356: hr_utility.set_location('Leaving hr_us_reports.get_new_hire_contact',10);
357: --
358: exception
359: when no_data_found then
360: hr_utility.set_location('Error found in hr_us_reports.get_new_hire.contact',20);

Line 360: hr_utility.set_location('Error found in hr_us_reports.get_new_hire.contact',20);

356: hr_utility.set_location('Leaving hr_us_reports.get_new_hire_contact',10);
357: --
358: exception
359: when no_data_found then
360: hr_utility.set_location('Error found in hr_us_reports.get_new_hire.contact',20);
361: NULL;
362: when others then
363: hr_utility.set_location('Error found in hr_us_reports.get_new_hire_contact',15);
364: --

Line 363: hr_utility.set_location('Error found in hr_us_reports.get_new_hire_contact',15);

359: when no_data_found then
360: hr_utility.set_location('Error found in hr_us_reports.get_new_hire.contact',20);
361: NULL;
362: when others then
363: hr_utility.set_location('Error found in hr_us_reports.get_new_hire_contact',15);
364: --
365: end get_new_hire_contact;
366: --
367: --

Line 387: hr_utility.set_location('Entered hr_us_reports.get_address', 5);

383: where location_id = p_location_id;
384: --
385: begin
386: --
387: hr_utility.set_location('Entered hr_us_reports.get_address', 5);
388: --
389: open get_location_record;
390: --
391: fetch get_location_record into v_address_line_1, v_address_line_2,

Line 394: hr_utility.set_location('hr_us_reports.get_address', 10);

390: --
391: fetch get_location_record into v_address_line_1, v_address_line_2,
392: v_address_line_3, v_town_or_city, v_region_2, v_postal_code;
393: --
394: hr_utility.set_location('hr_us_reports.get_address', 10);
395: --
396: if get_location_record%found
397: then
398: --

Line 429: hr_utility.set_location('hr_us_reports.get_address', 15);

425: end if;
426: --
427: close get_location_record;
428: --
429: hr_utility.set_location('hr_us_reports.get_address', 15);
430: --
431: hr_utility.trace('location is '|| f_address);
432: p_address := f_address;
433: --

Line 438: hr_utility.trace('Error in hr_us_reports.get_address');

434: end if;
435: --
436: exception
437: when others then
438: hr_utility.trace('Error in hr_us_reports.get_address');
439: hr_utility.set_location('hr_us_reports.get_address', 20);
440: --
441: end get_address;
442: --

Line 439: hr_utility.set_location('hr_us_reports.get_address', 20);

435: --
436: exception
437: when others then
438: hr_utility.trace('Error in hr_us_reports.get_address');
439: hr_utility.set_location('hr_us_reports.get_address', 20);
440: --
441: end get_address;
442: --
443: --

Line 583: hr_utility.set_location('Entered hr_us_reports.get_employee_address', 0);

579: and nvl(date_to, sysdate) >= sysdate;
580: --
581: begin
582: --
583: hr_utility.set_location('Entered hr_us_reports.get_employee_address', 0);
584: --
585: open get_address_record;
586: --
587: fetch get_address_record into v_address_line1, v_address_line2,

Line 590: hr_utility.set_location('Entered hr_us_reports.get_employee_address', 5);

586: --
587: fetch get_address_record into v_address_line1, v_address_line2,
588: v_address_line3, v_town_or_city, v_region_2, v_postal_code;
589: --
590: hr_utility.set_location('Entered hr_us_reports.get_employee_address', 5);
591: --
592: if get_address_record%found
593: then
594: --

Line 625: hr_utility.set_location('hr_us_reports.get_employee_address', 10);

621: end if;
622: --
623: insert into pay_us_rpt_totals(ATTRIBUTE30,attribute1) values(f_address,'test1');
624: commit;
625: hr_utility.set_location('hr_us_reports.get_employee_address', 10);
626: close get_address_record;
627: --
628: hr_utility.trace('Person Address is '|| f_address);
629: --

Line 634: hr_utility.set_location('Leaving hr_us_reports.get_employee_address', 15);

630: p_address := f_address;
631: --
632: end if;
633: --
634: hr_utility.set_location('Leaving hr_us_reports.get_employee_address', 15);
635: --
636: exception when NO_DATA_FOUND then NULL;
637: --
638: end get_employee_address;

Line 736: hr_utility.set_location('hr_us_reports.get_consolidation_set',5);

732: --
733: hr_utility.trace('Entered Get_consolidation_set');
734: --
735: begin
736: hr_utility.set_location('hr_us_reports.get_consolidation_set',5);
737: SELECT consolidation_set_name
738: INTO l_consolidation_set_name
739: FROM pay_consolidation_sets
740: WHERE consolidation_set_id = p_consolidation_set_id;

Line 761: hr_utility.set_location('hr_us_reports.get_payment_type_name',5);

757: --
758: hr_utility.trace('Entered Get_payment_type_name');
759: --
760: begin
761: hr_utility.set_location('hr_us_reports.get_payment_type_name',5);
762: SELECT ppt_tl.payment_type_name
763: INTO l_payment_type_name
764: FROM pay_payment_types_tl ppt_tl,
765: pay_payment_types ppt

Line 789: hr_utility.set_location('hr_us_reports.get_element_type_name',5);

785: --
786: hr_utility.trace('Entered Get_element_type_name');
787: --
788: begin
789: hr_utility.set_location('hr_us_reports.get_element_type_name',5);
790: SELECT pet_tl.element_name
791: INTO l_element_type_name
792: FROM pay_element_classifications pec,
793: pay_element_types_f_tl pet_tl,

Line 819: hr_utility.set_location('hr_us_reports.get_tax_unit',5);

815: --
816: hr_utility.trace('Entered Get_tax_unit');
817: --
818: begin
819: hr_utility.set_location('hr_us_reports.get_tax_unit',5);
820: SELECT name
821: INTO l_tax_unit_name
822: FROM hr_organization_units
823: WHERE organization_id = p_tax_unit_id;

Line 844: hr_utility.set_location('hr_us_reports.get_person_name',5);

840: --
841: hr_utility.trace('Entered get_person_name');
842: --
843: begin
844: hr_utility.set_location('hr_us_reports.get_person_name',5);
845: SELECT distinct full_name
846: INTO l_person_name
847: FROM per_people_f ppf
848: WHERE person_id = p_person_id

Line 874: hr_utility.set_location('hr_us_reports.get_payroll_action',5);

870: --
871: hr_utility.trace('Entered Get_payroll_action');
872: --
873: begin
874: hr_utility.set_location('hr_us_reports.get_payroll_action',5);
875: SELECT action_type
876: INTO l_action_type
877: FROM pay_payroll_actions
878: WHERE payroll_action_id = p_payroll_action_id;

Line 884: hr_utility.set_location('hr_us_reports.get_payroll_action',10);

880: exception when NO_DATA_FOUND then RETURN NULL;
881: end;
882: if l_action_type = 'P' then
883: begin
884: hr_utility.set_location('hr_us_reports.get_payroll_action',10);
885: SELECT ppa.display_run_number || '-' || pcs.consolidation_set_name
886: || '-' || ppa.effective_date || '-' || ppa.payroll_action_id
887: INTO l_payroll_action_name
888: FROM pay_consolidation_sets pcs,

Line 897: hr_utility.set_location('hr_us_reports.get_payroll_action',15);

893: when no_data_found then RETURN NULL;
894: end;
895: elsif l_action_type = 'R' then
896: begin
897: hr_utility.set_location('hr_us_reports.get_payroll_action',15);
898: SELECT ppa.display_run_number || '-' || has.assignment_set_name
899: || '-' || pes.element_set_name
900: INTO l_payroll_action_name
901: FROM hr_assignment_sets has,

Line 947: hr_utility.set_location('hr_us_reports.get_legislation_code',5);

943: --
944: hr_utility.trace('Entered Get_legislation_code');
945: --
946: begin
947: hr_utility.set_location('hr_us_reports.get_legislation_code',5);
948: SELECT org_information9
949: INTO l_legislation_code
950: FROM hr_organization_information
951: WHERE organization_id = p_business_group_id

Line 993: hr_utility.set_location('hr_us_reports.get_defined_balance_id',5);

989: -- If the balance is not in the Cache get it from the database.
990: --
991: if (l_found = FALSE) then
992: begin
993: hr_utility.set_location('hr_us_reports.get_defined_balance_id',5);
994: /* Legislation code is added in this query so that it does not
995: fetch multiple values after Canadian Payroll is installed - mmukherj*/
996: SELECT pdb.defined_balance_id
997: INTO l_defined_balance_id

Line 1037: hr_utility.set_location('hr_us_reports.get_startup_defined_balance',5);

1033: --
1034: hr_utility.trace('Entered Get_startup_defined_balance');
1035: --
1036: begin
1037: hr_utility.set_location('hr_us_reports.get_startup_defined_balance',5);
1038: SELECT pdb.defined_balance_id
1039: INTO l_defined_balance_id
1040: FROM pay_defined_balances pdb
1041: , pay_balance_dimensions pbd

Line 1072: hr_utility.set_location('hr_us_reports.get_defined_balance_by_type',5);

1068: hr_utility.trace('Entered Get_defined_balance_by_type');
1069: --
1070: -- **NOTE** We do not yet have the 'US_TAX DEDUCTIONS' category seeded yet.
1071: --
1072: hr_utility.set_location('hr_us_reports.get_defined_balance_by_type',5);
1073: --
1074: IF
1075: p_box_num = '10' THEN
1076: l_balance_type_name := 'Dependent Care'; -- *OK*

Line 1100: hr_utility.set_location('hr_us_reports.get_defined_balance_by_type',10);

1096: when NO_DATA_FOUND then RETURN NULL;
1097: end;
1098: --
1099: begin
1100: hr_utility.set_location('hr_us_reports.get_defined_balance_by_type',10);
1101: --
1102: SELECT pdb.defined_balance_id
1103: INTO l_defined_balance_id
1104: FROM pay_defined_balances pdb

Line 1454: hr_utility.set_location('Entered hr_us_reports.get_state_name',5);

1450: l_state_name VARCHAR2(60);
1451: --
1452: begin
1453: --
1454: hr_utility.set_location('Entered hr_us_reports.get_state_name',5);
1455: --
1456: SELECT state_name
1457: INTO l_state_name
1458: FROM pay_us_states

Line 1461: hr_utility.set_location('Leaving hr_us_reports.get_state_name',10);

1457: INTO l_state_name
1458: FROM pay_us_states
1459: WHERE state_abbrev = p_state_code;
1460: --
1461: hr_utility.set_location('Leaving hr_us_reports.get_state_name',10);
1462: --
1463: return l_state_name;
1464: --
1465: exception when NO_DATA_FOUND then RETURN NULL;

Line 1478: hr_utility.set_location('Entered hr_us_reports.get_org_name',5);

1474: l_org_name VARCHAR2(240);
1475: --
1476: begin
1477: --
1478: hr_utility.set_location('Entered hr_us_reports.get_org_name',5);
1479: --
1480: SELECT name
1481: INTO l_org_name
1482: FROM hr_organization_units

Line 1486: hr_utility.set_location('Leaving hr_us_reports.get_org_name',10);

1482: FROM hr_organization_units
1483: WHERE organization_id = p_organization_id
1484: AND business_group_id + 0 = p_business_group_id;
1485: --
1486: hr_utility.set_location('Leaving hr_us_reports.get_org_name',10);
1487: return l_org_name;
1488: --
1489: exception when NO_DATA_FOUND then RETURN NULL;
1490: when others then

Line 1491: hr_utility.set_location('Error found in hr_us_reports.get_org_name',15);

1487: return l_org_name;
1488: --
1489: exception when NO_DATA_FOUND then RETURN NULL;
1490: when others then
1491: hr_utility.set_location('Error found in hr_us_reports.get_org_name',15);
1492: RETURN NULL;
1493: --
1494: end get_org_name;
1495: --

Line 1599: l_proc := 'hr_us_reports.get_top_org_id';

1595: l_exists varchar2(1);
1596: --
1597: BEGIN
1598:
1599: l_proc := 'hr_us_reports.get_top_org_id';
1600:
1601: hr_utility.set_location('Entering...' || l_proc,10);
1602:
1603: open csr_get_element;

Line 1779: hr_utility.set_location('Entered hr_us_reports.get_employee_address40', 0);

1775: --
1776: begin
1777: --
1778:
1779: hr_utility.set_location('Entered hr_us_reports.get_employee_address40', 0);
1780: --
1781: open get_address_record;
1782: --
1783: fetch get_address_record into v_address_line1, v_address_line2,

Line 1786: hr_utility.set_location('Entered hr_us_reports.get_employee_address40', 5);

1782: --
1783: fetch get_address_record into v_address_line1, v_address_line2,
1784: v_address_line3, v_town_or_city, v_region_2, v_postal_code;
1785: --
1786: hr_utility.set_location('Entered hr_us_reports.get_employee_address40', 5);
1787: --
1788: if get_address_record%found
1789: then
1790: --

Line 1819: hr_utility.set_location('hr_us_reports.get_employee_address40', 10);

1815: f_address := f_address ||v_region_2||' '||
1816: v_postal_code;
1817: end if;
1818: --
1819: hr_utility.set_location('hr_us_reports.get_employee_address40', 10);
1820: close get_address_record;
1821: --
1822: hr_utility.trace('Person Address is '|| f_address);
1823: --

Line 1828: hr_utility.set_location('Leaving hr_us_reports.get_employee_address40', 15);

1824: p_address := f_address;
1825: --
1826: end if;
1827: --
1828: hr_utility.set_location('Leaving hr_us_reports.get_employee_address40', 15);
1829: --
1830: exception when NO_DATA_FOUND then NULL;
1831: --
1832: end get_employee_address40;

Line 1839: -- end hr_us_reports

1835:
1836: begin
1837: g_nxt_free_defbal := 1;
1838: --
1839: -- end hr_us_reports
1840: --
1841: end hr_us_reports;
1842: --/
1843: --show errors package body hr_us_reports

Line 1841: end hr_us_reports;

1837: g_nxt_free_defbal := 1;
1838: --
1839: -- end hr_us_reports
1840: --
1841: end hr_us_reports;
1842: --/
1843: --show errors package body hr_us_reports
1844: --
1845: --select to_date('SQLERROR')

Line 1843: --show errors package body hr_us_reports

1839: -- end hr_us_reports
1840: --
1841: end hr_us_reports;
1842: --/
1843: --show errors package body hr_us_reports
1844: --
1845: --select to_date('SQLERROR')
1846: --from user_errors
1847: --where type = 'PACKAGE BODY'

Line 1848: --and name = upper('hr_us_reports')

1844: --
1845: --select to_date('SQLERROR')
1846: --from user_errors
1847: --where type = 'PACKAGE BODY'
1848: --and name = upper('hr_us_reports')