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_FF_UDFS dependencies on HR_US_FF_UDFS

Line 1: package body hr_us_ff_udfs as

1: package body hr_us_ff_udfs as
2: /* $Header: pyusudfs.pkb 120.8.12010000.1 2008/07/27 23:58:08 appldev ship $ */
3: /*
4: +======================================================================+
5: | Copyright (c) 1994 Oracle Corporation |

Line 10: Name : hr_us_ff_udfs

6: | Redwood Shores, California, USA |
7: | All rights reserved. |
8: +======================================================================+
9:
10: Name : hr_us_ff_udfs
11: Filename : pyusudfs.sql
12: Change List
13: -----------
14: Date Name Vers Bug No Description

Line 3677: v_pay_basis_rate := FND_NUMBER.CANONICAL_TO_NUMBER(hr_us_ff_udfs.convert_period_type(

3673: from per_time_periods
3674: where payroll_id = p_pay_id
3675: and p_date_earned between start_date and end_date;
3676:
3677: v_pay_basis_rate := FND_NUMBER.CANONICAL_TO_NUMBER(hr_us_ff_udfs.convert_period_type(
3678: p_bus_grp_id => p_bg_id,
3679: p_payroll_id => p_pay_id,
3680: p_asst_work_schedule => p_work_sched,
3681: p_asst_std_hours => p_std_hours,

Line 3889: v_regsal_rate := hr_us_ff_udfs.Convert_Period_Type(

3885:
3886: --
3887: hr_utility.set_location('OT_Base_Rate', 60);
3888:
3889: v_regsal_rate := hr_us_ff_udfs.Convert_Period_Type(
3890: p_bus_grp_id => p_bg_id,
3891: p_payroll_id => p_pay_id,
3892: p_asst_work_schedule => p_work_sched,
3893: p_asst_std_hours => p_std_hours,

Line 3934: v_flat_total := v_flat_total + hr_us_ff_udfs.Convert_Period_Type(

3930: EXIT WHEN get_flat_amounts%NOTFOUND;
3931: v_flat_count := v_flat_count + 1;
3932: hr_utility.set_location('OT_Base_Rate', 90);
3933:
3934: v_flat_total := v_flat_total + hr_us_ff_udfs.Convert_Period_Type(
3935: p_bus_grp_id => p_bg_id,
3936: p_payroll_id => p_pay_id,
3937: p_asst_work_schedule => p_work_sched,
3938: p_asst_std_hours => p_std_hours,

Line 4077: v_gross_total := v_gross_total + hr_us_ff_udfs.Convert_Period_Type(

4073: IF v_gross_results <> 0 THEN
4074: -- Convert gross result to hourly figure.
4075: hr_utility.set_location('OT_Base_Rate', 160);
4076:
4077: v_gross_total := v_gross_total + hr_us_ff_udfs.Convert_Period_Type(
4078: p_bus_grp_id => p_bg_id,
4079: p_payroll_id => p_pay_id,
4080: p_asst_work_schedule => p_work_sched,
4081: p_asst_std_hours => p_std_hours,

Line 4467: hr_utility.set_location('hr_us_ff_udfs.arrearage', 1);

4463: --
4464: p_to_arrears := 0;
4465: p_not_taken := 0;
4466:
4467: hr_utility.set_location('hr_us_ff_udfs.arrearage', 1);
4468:
4469: -- Determine if Arrears = 'Y' for this dedn
4470: -- Can do this by checking for "Clear Arrears" input value on base ele.
4471: -- This input value is only created when Arrears is marked Yes on Deductions

Line 4670: hr_utility.set_location('hr_us_ff_udfs.addr_val', 20);

4666: RETURN l_geocode;
4667: --
4668: EXCEPTION
4669: WHEN OTHERS THEN
4670: hr_utility.set_location('hr_us_ff_udfs.addr_val', 20);
4671: l_geocode := '00-000-0000';
4672: RETURN l_geocode;
4673: --
4674: END addr_val; -- addr_val

Line 4746: hr_utility.set_location('hr_us_ff_udfs.addr_val', 1);

4742: IF (p_skip_rule = 'Y') THEN
4743: RAISE TOO_MANY_ROWS;
4744: END IF;
4745:
4746: hr_utility.set_location('hr_us_ff_udfs.addr_val', 1);
4747:
4748: IF (nvl(hr_general2.get_oracle_db_version, 0) < 9.0) THEN
4749: SELECT /*+ ORDERED */ a.state_code||'-'||a.county_code||'-'||a.city_code
4750: INTO l_geocode

Line 4776: hr_utility.set_location('hr_us_ff_udfs.addr_val', 3);

4772: --
4773: EXCEPTION -- (2)
4774: --
4775: WHEN NO_DATA_FOUND THEN -- Invalid city/zip combo
4776: hr_utility.set_location('hr_us_ff_udfs.addr_val', 3);
4777: l_geocode := '00-000-0000';
4778: RETURN l_geocode;
4779: --
4780:

Line 4788: hr_utility.set_location('hr_us_ff_udfs.addr_val', 5);

4784: INTO l_state_code
4785: FROM pay_us_states
4786: WHERE state_abbrev = p_state_abbrev;
4787:
4788: hr_utility.set_location('hr_us_ff_udfs.addr_val', 5);
4789: SELECT a.state_code||'-'||a.county_code||'-'||a.city_code
4790: INTO l_geocode
4791: FROM pay_us_zip_codes z,
4792: pay_us_city_names a,

Line 4810: hr_utility.set_location('hr_us_ff_udfs.addr_val', 7);

4806: --
4807: -- Fallout from (2) ie. county/city/zip combo invalid or does not
4808: -- uniquely define geocode.
4809: WHEN NO_DATA_FOUND THEN
4810: hr_utility.set_location('hr_us_ff_udfs.addr_val', 7);
4811: l_geocode := '00-000-0000';
4812: RETURN l_geocode;
4813: --
4814: WHEN TOO_MANY_ROWS THEN

Line 4815: hr_utility.set_location('hr_us_ff_udfs.addr_val', 9);

4811: l_geocode := '00-000-0000';
4812: RETURN l_geocode;
4813: --
4814: WHEN TOO_MANY_ROWS THEN
4815: hr_utility.set_location('hr_us_ff_udfs.addr_val', 9);
4816: SELECT a.state_code||'-'||a.county_code||'-'||a.city_code
4817: INTO l_geocode
4818: FROM pay_us_zip_codes z,
4819: pay_us_city_names a,

Line 4841: hr_utility.set_location('hr_us_ff_udfs.addr_val', 11);

4837: end; -- (1)
4838: --
4839: -- We're in Main
4840: --
4841: hr_utility.set_location('hr_us_ff_udfs.addr_val', 11);
4842: --
4843: if (substr(l_geocode,8,1) = 'U') THEN
4844: l_geocode := substr(l_geocode,1,7)||'0000';
4845: END IF;

Line 4853: hr_utility.set_location('hr_us_ff_udfs.addr_val', 13);

4849: EXCEPTION -- Main addr_val
4850: -- Fallout from (1) state/county/city/zip does not uniquely define a geo.
4851: -- Return failure geocode.
4852: WHEN NO_DATA_FOUND THEN
4853: hr_utility.set_location('hr_us_ff_udfs.addr_val', 13);
4854: l_geocode := '00-000-0000';
4855: RETURN l_geocode;
4856: --
4857: WHEN TOO_MANY_ROWS THEN

Line 4858: hr_utility.set_location('hr_us_ff_udfs.addr_val', 15);

4854: l_geocode := '00-000-0000';
4855: RETURN l_geocode;
4856: --
4857: WHEN TOO_MANY_ROWS THEN
4858: hr_utility.set_location('hr_us_ff_udfs.addr_val', 15);
4859: l_geocode := '00-000-0000';
4860: RETURN l_geocode;
4861: --
4862: END addr_val; -- Main addr_val

Line 4901: END hr_us_ff_udfs;

4897:
4898:
4899: --
4900:
4901: END hr_us_ff_udfs;