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.3.12000000.4 2007/05/15 09:48:36 amigarg noship $ */
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 3305: v_pay_basis_rate := fnd_number.canonical_to_number(hr_ca_ff_udfs.convert_period_type(

3301: FETCH cur_element_type_id
3302: INTO l_time_entry_ele_id;
3303: CLOSE cur_element_type_id;
3304:
3305: v_pay_basis_rate := fnd_number.canonical_to_number(hr_ca_ff_udfs.convert_period_type(
3306: p_bus_grp_id => p_bg_id,
3307: p_payroll_id => p_pay_id,
3308: p_assignment_action_id => p_ass_action_id,
3309: p_assignment_id => p_ass_id ,

Line 3467: v_regsal_rate := hr_ca_ff_udfs.Convert_Period_Type(

3463: AND UPPER(IPV.name) = 'MONTHLY SALARY';
3464: --
3465: hr_utility.set_location('OT_Base_Rate', 60);
3466:
3467: v_regsal_rate := hr_ca_ff_udfs.Convert_Period_Type(
3468: p_bus_grp_id => p_bg_id,
3469: p_payroll_id => p_pay_id,
3470: p_assignment_action_id => p_ass_action_id,
3471: p_assignment_id => p_ass_id ,

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

3512: EXIT WHEN get_flat_amounts%NOTFOUND;
3513: v_flat_count := v_flat_count + 1;
3514: hr_utility.set_location('OT_Base_Rate', 90);
3515:
3516: v_flat_total := v_flat_total + hr_ca_ff_udfs.Convert_Period_Type(
3517: p_bus_grp_id => p_bg_id,
3518: p_payroll_id => p_pay_id,
3519: p_assignment_action_id => p_ass_action_id,
3520: p_assignment_id => p_ass_id ,

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

3662: IF v_gross_results <> 0 THEN
3663: -- Convert gross result to hourly figure.
3664: hr_utility.set_location('OT_Base_Rate', 160);
3665:
3666: v_gross_total := v_gross_total + hr_ca_ff_udfs.Convert_Period_Type(
3667: p_bus_grp_id => p_bg_id,
3668: p_payroll_id => p_pay_id,
3669: p_assignment_action_id => p_ass_action_id,
3670: p_assignment_id => p_ass_id ,

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

3981: --
3982: p_to_arrears := 0;
3983: p_not_taken := 0;
3984:
3985: hr_utility.set_location('hr_ca_ff_udfs.arrearage', 1);
3986:
3987: -- Determine if Arrears = 'Y' for this dedn
3988: -- Can do this by checking for "Clear Arrears" input value on base ele.
3989: -- This input value is only created when Arrears is marked Yes on Deductions

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

4173: RETURN l_geocode;
4174: --
4175: EXCEPTION
4176: WHEN OTHERS THEN
4177: hr_utility.set_location('hr_ca_ff_udfs.addr_val', 20);
4178: l_geocode := '00-000-0000';
4179: RETURN l_geocode;
4180: --
4181: END addr_val; -- addr_val

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

4209: IF (p_skip_rule = 'Y') THEN
4210: RAISE TOO_MANY_ROWS;
4211: END IF;
4212:
4213: hr_utility.set_location('hr_ca_ff_udfs.addr_val', 1);
4214:
4215: SELECT a.state_code||'-'||a.county_code||'-'||a.city_code
4216: INTO l_geocode
4217: FROM pay_us_zip_codes z,

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

4225: --
4226: EXCEPTION -- (2)
4227: --
4228: WHEN NO_DATA_FOUND THEN -- Invalid city/zip combo
4229: hr_utility.set_location('hr_ca_ff_udfs.addr_val', 3);
4230: l_geocode := '00-000-0000';
4231: RETURN l_geocode;
4232: --
4233: WHEN TOO_MANY_ROWS THEN -- city/zip does not uniquely defn geo

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

4236: INTO l_state_code
4237: FROM pay_us_states
4238: WHERE state_abbrev = p_state_abbrev;
4239:
4240: hr_utility.set_location('hr_ca_ff_udfs.addr_val', 5);
4241: SELECT a.state_code||'-'||a.county_code||'-'||a.city_code
4242: INTO l_geocode
4243: FROM pay_us_zip_codes z,
4244: pay_us_city_names a,

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

4258: --
4259: -- Fallout from (2) ie. county/city/zip combo invalid or does not
4260: -- uniquely define geocode.
4261: WHEN NO_DATA_FOUND THEN
4262: hr_utility.set_location('hr_ca_ff_udfs.addr_val', 7);
4263: l_geocode := '00-000-0000';
4264: RETURN l_geocode;
4265: --
4266: WHEN TOO_MANY_ROWS THEN

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

4263: l_geocode := '00-000-0000';
4264: RETURN l_geocode;
4265: --
4266: WHEN TOO_MANY_ROWS THEN
4267: hr_utility.set_location('hr_ca_ff_udfs.addr_val', 9);
4268: SELECT a.state_code||'-'||a.county_code||'-'||a.city_code
4269: INTO l_geocode
4270: FROM pay_us_zip_codes z,
4271: pay_us_city_names a,

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

4289: end; -- (1)
4290: --
4291: -- We're in Main
4292: --
4293: hr_utility.set_location('hr_ca_ff_udfs.addr_val', 11);
4294: --
4295: if (substr(l_geocode,8,1) = 'U') THEN
4296: l_geocode := substr(l_geocode,1,7)||'0000';
4297: END IF;

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

4301: EXCEPTION -- Main addr_val
4302: -- Fallout from (1) state/county/city/zip does not uniquely define a geo.
4303: -- Return failure geocode.
4304: WHEN NO_DATA_FOUND THEN
4305: hr_utility.set_location('hr_ca_ff_udfs.addr_val', 13);
4306: l_geocode := '00-000-0000';
4307: RETURN l_geocode;
4308: --
4309: WHEN TOO_MANY_ROWS THEN

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

4306: l_geocode := '00-000-0000';
4307: RETURN l_geocode;
4308: --
4309: WHEN TOO_MANY_ROWS THEN
4310: hr_utility.set_location('hr_ca_ff_udfs.addr_val', 15);
4311: l_geocode := '00-000-0000';
4312: RETURN l_geocode;
4313: --
4314: END addr_val; -- Main addr_val

Line 4405: END hr_ca_ff_udfs;

4401:
4402: END get_earnings_and_type;
4403:
4404:
4405: END hr_ca_ff_udfs;