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_CA_FF_UDFS dependencies on HR_CA_FF_UDFS

Line 1: PACKAGE BODY hr_ca_ff_udfs AS

1: PACKAGE BODY hr_ca_ff_udfs AS
2: /* $Header: pycaudfs.pkb 120.7.12020000.4 2012/12/12 17:51:56 tclewis ship $ */
3: /*
4: +======================================================================+
5: | Copyright (c) 1994 Oracle Corporation |

Line 10: Name : hr_ca_ff_udfs

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

Line 3342: v_pay_basis_rate := fnd_number.canonical_to_number(hr_ca_ff_udfs.convert_period_type(

3338: FETCH cur_element_type_id
3339: INTO l_time_entry_ele_id;
3340: CLOSE cur_element_type_id;
3341:
3342: v_pay_basis_rate := fnd_number.canonical_to_number(hr_ca_ff_udfs.convert_period_type(
3343: p_bus_grp_id => p_bg_id,
3344: p_payroll_id => p_pay_id,
3345: p_assignment_action_id => p_ass_action_id,
3346: p_assignment_id => p_ass_id ,

Line 3504: v_regsal_rate := hr_ca_ff_udfs.Convert_Period_Type(

3500: AND UPPER(IPV.name) = 'MONTHLY SALARY';
3501: --
3502: hr_utility.set_location('OT_Base_Rate', 60);
3503:
3504: v_regsal_rate := hr_ca_ff_udfs.Convert_Period_Type(
3505: p_bus_grp_id => p_bg_id,
3506: p_payroll_id => p_pay_id,
3507: p_assignment_action_id => p_ass_action_id,
3508: p_assignment_id => p_ass_id ,

Line 3553: v_flat_total := v_flat_total + hr_ca_ff_udfs.Convert_Period_Type(

3549: EXIT WHEN get_flat_amounts%NOTFOUND;
3550: v_flat_count := v_flat_count + 1;
3551: hr_utility.set_location('OT_Base_Rate', 90);
3552:
3553: v_flat_total := v_flat_total + hr_ca_ff_udfs.Convert_Period_Type(
3554: p_bus_grp_id => p_bg_id,
3555: p_payroll_id => p_pay_id,
3556: p_assignment_action_id => p_ass_action_id,
3557: p_assignment_id => p_ass_id ,

Line 3703: v_gross_total := v_gross_total + hr_ca_ff_udfs.Convert_Period_Type(

3699: IF v_gross_results <> 0 THEN
3700: -- Convert gross result to hourly figure.
3701: hr_utility.set_location('OT_Base_Rate', 160);
3702:
3703: v_gross_total := v_gross_total + hr_ca_ff_udfs.Convert_Period_Type(
3704: p_bus_grp_id => p_bg_id,
3705: p_payroll_id => p_pay_id,
3706: p_assignment_action_id => p_ass_action_id,
3707: p_assignment_id => p_ass_id ,

Line 4022: hr_utility.set_location('hr_ca_ff_udfs.arrearage', 1);

4018: --
4019: p_to_arrears := 0;
4020: p_not_taken := 0;
4021:
4022: hr_utility.set_location('hr_ca_ff_udfs.arrearage', 1);
4023:
4024: -- Determine if Arrears = 'Y' for this dedn
4025: -- Can do this by checking for "Clear Arrears" input value on base ele.
4026: -- This input value is only created when Arrears is marked Yes on Deductions

Line 4214: hr_utility.set_location('hr_ca_ff_udfs.addr_val', 20);

4210: RETURN l_geocode;
4211: --
4212: EXCEPTION
4213: WHEN OTHERS THEN
4214: hr_utility.set_location('hr_ca_ff_udfs.addr_val', 20);
4215: l_geocode := '00-000-0000';
4216: RETURN l_geocode;
4217: --
4218: END addr_val; -- addr_val

Line 4250: hr_utility.set_location('hr_ca_ff_udfs.addr_val', 1);

4246: IF (p_skip_rule = 'Y') THEN
4247: RAISE TOO_MANY_ROWS;
4248: END IF;
4249:
4250: hr_utility.set_location('hr_ca_ff_udfs.addr_val', 1);
4251:
4252: SELECT a.state_code||'-'||a.county_code||'-'||a.city_code
4253: INTO l_geocode
4254: FROM pay_us_zip_codes z,

Line 4266: hr_utility.set_location('hr_ca_ff_udfs.addr_val', 3);

4262: --
4263: EXCEPTION -- (2)
4264: --
4265: WHEN NO_DATA_FOUND THEN -- Invalid city/zip combo
4266: hr_utility.set_location('hr_ca_ff_udfs.addr_val', 3);
4267: l_geocode := '00-000-0000';
4268: RETURN l_geocode;
4269: --
4270: WHEN TOO_MANY_ROWS THEN -- city/zip does not uniquely defn geo

Line 4277: hr_utility.set_location('hr_ca_ff_udfs.addr_val', 5);

4273: INTO l_state_code
4274: FROM pay_us_states
4275: WHERE state_abbrev = p_state_abbrev;
4276:
4277: hr_utility.set_location('hr_ca_ff_udfs.addr_val', 5);
4278: SELECT a.state_code||'-'||a.county_code||'-'||a.city_code
4279: INTO l_geocode
4280: FROM pay_us_zip_codes z,
4281: pay_us_city_names a,

Line 4299: hr_utility.set_location('hr_ca_ff_udfs.addr_val', 7);

4295: --
4296: -- Fallout from (2) ie. county/city/zip combo invalid or does not
4297: -- uniquely define geocode.
4298: WHEN NO_DATA_FOUND THEN
4299: hr_utility.set_location('hr_ca_ff_udfs.addr_val', 7);
4300: l_geocode := '00-000-0000';
4301: RETURN l_geocode;
4302: --
4303: WHEN TOO_MANY_ROWS THEN

Line 4304: hr_utility.set_location('hr_ca_ff_udfs.addr_val', 9);

4300: l_geocode := '00-000-0000';
4301: RETURN l_geocode;
4302: --
4303: WHEN TOO_MANY_ROWS THEN
4304: hr_utility.set_location('hr_ca_ff_udfs.addr_val', 9);
4305: SELECT a.state_code||'-'||a.county_code||'-'||a.city_code
4306: INTO l_geocode
4307: FROM pay_us_zip_codes z,
4308: pay_us_city_names a,

Line 4330: hr_utility.set_location('hr_ca_ff_udfs.addr_val', 11);

4326: end; -- (1)
4327: --
4328: -- We're in Main
4329: --
4330: hr_utility.set_location('hr_ca_ff_udfs.addr_val', 11);
4331: --
4332: if (substr(l_geocode,8,1) = 'U') THEN
4333: l_geocode := substr(l_geocode,1,7)||'0000';
4334: END IF;

Line 4342: hr_utility.set_location('hr_ca_ff_udfs.addr_val', 13);

4338: EXCEPTION -- Main addr_val
4339: -- Fallout from (1) state/county/city/zip does not uniquely define a geo.
4340: -- Return failure geocode.
4341: WHEN NO_DATA_FOUND THEN
4342: hr_utility.set_location('hr_ca_ff_udfs.addr_val', 13);
4343: l_geocode := '00-000-0000';
4344: RETURN l_geocode;
4345: --
4346: WHEN TOO_MANY_ROWS THEN

Line 4347: hr_utility.set_location('hr_ca_ff_udfs.addr_val', 15);

4343: l_geocode := '00-000-0000';
4344: RETURN l_geocode;
4345: --
4346: WHEN TOO_MANY_ROWS THEN
4347: hr_utility.set_location('hr_ca_ff_udfs.addr_val', 15);
4348: l_geocode := '00-000-0000';
4349: RETURN l_geocode;
4350: --
4351: END addr_val; -- Main addr_val

Line 4442: END hr_ca_ff_udfs;

4438:
4439: END get_earnings_and_type;
4440:
4441:
4442: END hr_ca_ff_udfs;