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.8 2010/07/22 09:22:45 nkjaladi noship $ */
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 235: hr_utility.set_location('hr_us_reports.get_salary',5);

231: l_frequency per_all_assignments_f.frequency%type;
232: --
233: Begin
234: --
235: hr_utility.set_location('hr_us_reports.get_salary',5);
236: hr_utility.trace('p_business_group_id ->'||to_char(p_business_group_id));
237: hr_utility.trace('p_assignment_id ->'||to_char(p_assignment_id));
238: hr_utility.trace('p_report_date ->'||p_report_date );
239: --

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

289: --
290: exception
291: when NO_DATA_FOUND then RETURN NULL;
292: when others then
293: hr_utility.set_location('hr_us_reports.get_salary',10);
294: RETURN NULL;
295: --
296: end;
297: --

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

299: l_annual_salary := hr_us_ff_udfs.Convert_Period_Type
300: (p_business_group_id,null,l_work_schedule,l_normal_hours,l_salary,l_pay_basis,'Year',
301: null,null,l_frequency); -- Bug 3669973
302: --
303: hr_utility.set_location('hr_us_reports.get_salary',15);
304: hr_utility.trace('l_annual_salary ->'||to_char(l_annual_salary));
305: --
306: return (l_annual_salary);
307: --

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

342:
343: --
344: begin
345: --
346: hr_utility.set_location('Entered hr_us_reports.get_new_hire_contact',5);
347: --
348: OPEN c_new_hire_record;
349:
350: --LOOP

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

360: CLOSE c_new_hire_record;
361: --
362: hr_utility.trace('Contact name : '||v_contact_name);
363: hr_utility.trace('Contact title : '||v_contact_title);
364: hr_utility.set_location('Leaving hr_us_reports.get_new_hire_contact',10);
365: --
366: exception
367: when no_data_found then
368: hr_utility.set_location('Error found in hr_us_reports.get_new_hire.contact',20);

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

364: hr_utility.set_location('Leaving hr_us_reports.get_new_hire_contact',10);
365: --
366: exception
367: when no_data_found then
368: hr_utility.set_location('Error found in hr_us_reports.get_new_hire.contact',20);
369: NULL;
370: when others then
371: hr_utility.set_location('Error found in hr_us_reports.get_new_hire_contact',15);
372: --

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

367: when no_data_found then
368: hr_utility.set_location('Error found in hr_us_reports.get_new_hire.contact',20);
369: NULL;
370: when others then
371: hr_utility.set_location('Error found in hr_us_reports.get_new_hire_contact',15);
372: --
373: end get_new_hire_contact;
374: --
375: --

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

391: where location_id = p_location_id;
392: --
393: begin
394: --
395: hr_utility.set_location('Entered hr_us_reports.get_address', 5);
396: --
397: open get_location_record;
398: --
399: fetch get_location_record into v_address_line_1, v_address_line_2,

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

398: --
399: fetch get_location_record into v_address_line_1, v_address_line_2,
400: v_address_line_3, v_town_or_city, v_region_2, v_postal_code;
401: --
402: hr_utility.set_location('hr_us_reports.get_address', 10);
403: --
404: if get_location_record%found
405: then
406: --

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

433: end if;
434: --
435: close get_location_record;
436: --
437: hr_utility.set_location('hr_us_reports.get_address', 15);
438: --
439: hr_utility.trace('location is '|| f_address);
440: p_address := f_address;
441: --

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

442: end if;
443: --
444: exception
445: when others then
446: hr_utility.trace('Error in hr_us_reports.get_address');
447: hr_utility.set_location('hr_us_reports.get_address', 20);
448: --
449: end get_address;
450: --

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

443: --
444: exception
445: when others then
446: hr_utility.trace('Error in hr_us_reports.get_address');
447: hr_utility.set_location('hr_us_reports.get_address', 20);
448: --
449: end get_address;
450: --
451: --

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

593: and nvl(date_to, sysdate) >= sysdate;
594: --
595: begin
596: --
597: hr_utility.set_location('Entered hr_us_reports.get_employee_address', 0);
598: --
599: open get_address_record;
600: --
601: fetch get_address_record into v_address_line1, v_address_line2,

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

600: --
601: fetch get_address_record into v_address_line1, v_address_line2,
602: v_address_line3, v_town_or_city, v_region_2, v_postal_code;
603: --
604: hr_utility.set_location('Entered hr_us_reports.get_employee_address', 5);
605: --
606: if get_address_record%found
607: then
608: --

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

639: --
640: /* 9912897 - Commented this dbug DML stmt.
641: insert into pay_us_rpt_totals(ATTRIBUTE30,attribute1) values(f_address,'test1');
642: commit;*/
643: hr_utility.set_location('hr_us_reports.get_employee_address', 10);
644: close get_address_record;
645: --
646: hr_utility.trace('Person Address is '|| f_address);
647: --

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

648: p_address := f_address;
649: --
650: end if;
651: --
652: hr_utility.set_location('Leaving hr_us_reports.get_employee_address', 15);
653: --
654: exception when NO_DATA_FOUND then NULL;
655: --
656: end get_employee_address;

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

750: --
751: hr_utility.trace('Entered Get_consolidation_set');
752: --
753: begin
754: hr_utility.set_location('hr_us_reports.get_consolidation_set',5);
755: SELECT consolidation_set_name
756: INTO l_consolidation_set_name
757: FROM pay_consolidation_sets
758: WHERE consolidation_set_id = p_consolidation_set_id;

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

775: --
776: hr_utility.trace('Entered Get_payment_type_name');
777: --
778: begin
779: hr_utility.set_location('hr_us_reports.get_payment_type_name',5);
780: SELECT ppt_tl.payment_type_name
781: INTO l_payment_type_name
782: FROM pay_payment_types_tl ppt_tl,
783: pay_payment_types ppt

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

803: --
804: hr_utility.trace('Entered Get_element_type_name');
805: --
806: begin
807: hr_utility.set_location('hr_us_reports.get_element_type_name',5);
808: SELECT pet_tl.element_name
809: INTO l_element_type_name
810: FROM pay_element_classifications pec,
811: pay_element_types_f_tl pet_tl,

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

833: --
834: hr_utility.trace('Entered Get_tax_unit');
835: --
836: begin
837: hr_utility.set_location('hr_us_reports.get_tax_unit',5);
838: SELECT name
839: INTO l_tax_unit_name
840: FROM hr_organization_units
841: WHERE organization_id = p_tax_unit_id;

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

858: --
859: hr_utility.trace('Entered get_person_name');
860: --
861: begin
862: hr_utility.set_location('hr_us_reports.get_person_name',5);
863: SELECT distinct full_name
864: INTO l_person_name
865: FROM per_people_f ppf
866: WHERE person_id = p_person_id

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

888: --
889: hr_utility.trace('Entered Get_payroll_action');
890: --
891: begin
892: hr_utility.set_location('hr_us_reports.get_payroll_action',5);
893: SELECT action_type
894: INTO l_action_type
895: FROM pay_payroll_actions
896: WHERE payroll_action_id = p_payroll_action_id;

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

898: exception when NO_DATA_FOUND then RETURN NULL;
899: end;
900: if l_action_type = 'P' then
901: begin
902: hr_utility.set_location('hr_us_reports.get_payroll_action',10);
903: SELECT ppa.display_run_number || '-' || pcs.consolidation_set_name
904: || '-' || ppa.effective_date || '-' || ppa.payroll_action_id
905: INTO l_payroll_action_name
906: FROM pay_consolidation_sets pcs,

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

911: when no_data_found then RETURN NULL;
912: end;
913: elsif l_action_type = 'R' then
914: begin
915: hr_utility.set_location('hr_us_reports.get_payroll_action',15);
916: SELECT ppa.display_run_number || '-' || has.assignment_set_name
917: || '-' || pes.element_set_name
918: INTO l_payroll_action_name
919: FROM hr_assignment_sets has,

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

961: --
962: hr_utility.trace('Entered Get_legislation_code');
963: --
964: begin
965: hr_utility.set_location('hr_us_reports.get_legislation_code',5);
966: SELECT org_information9
967: INTO l_legislation_code
968: FROM hr_organization_information
969: WHERE organization_id = p_business_group_id

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

1007: -- If the balance is not in the Cache get it from the database.
1008: --
1009: if (l_found = FALSE) then
1010: begin
1011: hr_utility.set_location('hr_us_reports.get_defined_balance_id',5);
1012: /* Legislation code is added in this query so that it does not
1013: fetch multiple values after Canadian Payroll is installed - mmukherj*/
1014: SELECT pdb.defined_balance_id
1015: INTO l_defined_balance_id

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

1051: --
1052: hr_utility.trace('Entered Get_startup_defined_balance');
1053: --
1054: begin
1055: hr_utility.set_location('hr_us_reports.get_startup_defined_balance',5);
1056: SELECT pdb.defined_balance_id
1057: INTO l_defined_balance_id
1058: FROM pay_defined_balances pdb
1059: , pay_balance_dimensions pbd

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

1086: hr_utility.trace('Entered Get_defined_balance_by_type');
1087: --
1088: -- **NOTE** We do not yet have the 'US_TAX DEDUCTIONS' category seeded yet.
1089: --
1090: hr_utility.set_location('hr_us_reports.get_defined_balance_by_type',5);
1091: --
1092: IF
1093: p_box_num = '10' THEN
1094: l_balance_type_name := 'Dependent Care'; -- *OK*

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

1114: when NO_DATA_FOUND then RETURN NULL;
1115: end;
1116: --
1117: begin
1118: hr_utility.set_location('hr_us_reports.get_defined_balance_by_type',10);
1119: --
1120: SELECT pdb.defined_balance_id
1121: INTO l_defined_balance_id
1122: FROM pay_defined_balances pdb

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

1468: l_state_name VARCHAR2(60);
1469: --
1470: begin
1471: --
1472: hr_utility.set_location('Entered hr_us_reports.get_state_name',5);
1473: --
1474: SELECT state_name
1475: INTO l_state_name
1476: FROM pay_us_states

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

1475: INTO l_state_name
1476: FROM pay_us_states
1477: WHERE state_abbrev = p_state_code;
1478: --
1479: hr_utility.set_location('Leaving hr_us_reports.get_state_name',10);
1480: --
1481: return l_state_name;
1482: --
1483: exception when NO_DATA_FOUND then RETURN NULL;

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

1492: l_org_name VARCHAR2(240);
1493: --
1494: begin
1495: --
1496: hr_utility.set_location('Entered hr_us_reports.get_org_name',5);
1497: --
1498: SELECT name
1499: INTO l_org_name
1500: FROM hr_organization_units

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

1500: FROM hr_organization_units
1501: WHERE organization_id = p_organization_id
1502: AND business_group_id + 0 = p_business_group_id;
1503: --
1504: hr_utility.set_location('Leaving hr_us_reports.get_org_name',10);
1505: return l_org_name;
1506: --
1507: exception when NO_DATA_FOUND then RETURN NULL;
1508: when others then

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

1505: return l_org_name;
1506: --
1507: exception when NO_DATA_FOUND then RETURN NULL;
1508: when others then
1509: hr_utility.set_location('Error found in hr_us_reports.get_org_name',15);
1510: RETURN NULL;
1511: --
1512: end get_org_name;
1513: --

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

1613: l_exists varchar2(1);
1614: --
1615: BEGIN
1616:
1617: l_proc := 'hr_us_reports.get_top_org_id';
1618:
1619: hr_utility.set_location('Entering...' || l_proc,10);
1620:
1621: open csr_get_element;

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

1793: --
1794: begin
1795: --
1796:
1797: hr_utility.set_location('Entered hr_us_reports.get_employee_address40', 0);
1798: --
1799: open get_address_record;
1800: --
1801: fetch get_address_record into v_address_line1, v_address_line2,

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

1800: --
1801: fetch get_address_record into v_address_line1, v_address_line2,
1802: v_address_line3, v_town_or_city, v_region_2, v_postal_code;
1803: --
1804: hr_utility.set_location('Entered hr_us_reports.get_employee_address40', 5);
1805: --
1806: if get_address_record%found
1807: then
1808: --

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

1833: f_address := f_address ||v_region_2||' '||
1834: v_postal_code;
1835: end if;
1836: --
1837: hr_utility.set_location('hr_us_reports.get_employee_address40', 10);
1838: close get_address_record;
1839: --
1840: hr_utility.trace('Person Address is '|| f_address);
1841: --

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

1842: p_address := f_address;
1843: --
1844: end if;
1845: --
1846: hr_utility.set_location('Leaving hr_us_reports.get_employee_address40', 15);
1847: --
1848: exception when NO_DATA_FOUND then NULL;
1849: --
1850: end get_employee_address40;

Line 1857: -- end hr_us_reports

1853:
1854: begin
1855: g_nxt_free_defbal := 1;
1856: --
1857: -- end hr_us_reports
1858: --
1859: end hr_us_reports;
1860: --/
1861: --show errors package body hr_us_reports

Line 1859: end hr_us_reports;

1855: g_nxt_free_defbal := 1;
1856: --
1857: -- end hr_us_reports
1858: --
1859: end hr_us_reports;
1860: --/
1861: --show errors package body hr_us_reports
1862: --
1863: --select to_date('SQLERROR')

Line 1861: --show errors package body hr_us_reports

1857: -- end hr_us_reports
1858: --
1859: end hr_us_reports;
1860: --/
1861: --show errors package body hr_us_reports
1862: --
1863: --select to_date('SQLERROR')
1864: --from user_errors
1865: --where type = 'PACKAGE BODY'

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

1862: --
1863: --select to_date('SQLERROR')
1864: --from user_errors
1865: --where type = 'PACKAGE BODY'
1866: --and name = upper('hr_us_reports')