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.15.12020000.3 2012/11/01 17:27:37 emunisek 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 3686: v_pay_basis_rate := FND_NUMBER.CANONICAL_TO_NUMBER(hr_us_ff_udfs.convert_period_type(

3682: from per_time_periods
3683: where payroll_id = p_pay_id
3684: and p_date_earned between start_date and end_date;
3685:
3686: v_pay_basis_rate := FND_NUMBER.CANONICAL_TO_NUMBER(hr_us_ff_udfs.convert_period_type(
3687: p_bus_grp_id => p_bg_id,
3688: p_payroll_id => p_pay_id,
3689: p_asst_work_schedule => p_work_sched,
3690: p_asst_std_hours => p_std_hours,

Line 3898: v_regsal_rate := hr_us_ff_udfs.Convert_Period_Type(

3894:
3895: --
3896: hr_utility.set_location('OT_Base_Rate', 60);
3897:
3898: v_regsal_rate := hr_us_ff_udfs.Convert_Period_Type(
3899: p_bus_grp_id => p_bg_id,
3900: p_payroll_id => p_pay_id,
3901: p_asst_work_schedule => p_work_sched,
3902: p_asst_std_hours => p_std_hours,

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

3939: EXIT WHEN get_flat_amounts%NOTFOUND;
3940: v_flat_count := v_flat_count + 1;
3941: hr_utility.set_location('OT_Base_Rate', 90);
3942:
3943: v_flat_total := v_flat_total + hr_us_ff_udfs.Convert_Period_Type(
3944: p_bus_grp_id => p_bg_id,
3945: p_payroll_id => p_pay_id,
3946: p_asst_work_schedule => p_work_sched,
3947: p_asst_std_hours => p_std_hours,

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

4082: IF v_gross_results <> 0 THEN
4083: -- Convert gross result to hourly figure.
4084: hr_utility.set_location('OT_Base_Rate', 160);
4085:
4086: v_gross_total := v_gross_total + hr_us_ff_udfs.Convert_Period_Type(
4087: p_bus_grp_id => p_bg_id,
4088: p_payroll_id => p_pay_id,
4089: p_asst_work_schedule => p_work_sched,
4090: p_asst_std_hours => p_std_hours,

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

4479: p_to_arrears := 0;
4480: p_not_taken := 0;
4481: l_arrear_contr_value := 0 ;
4482:
4483: hr_utility.set_location('hr_us_ff_udfs.arrearage', 1);
4484:
4485: -- Determine if Arrears = 'Y' for this dedn
4486: -- Can do this by checking for "Clear Arrears" input value on base ele.
4487: -- This input value is only created when Arrears is marked Yes on Deductions

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

4728: RETURN l_geocode;
4729: --
4730: EXCEPTION
4731: WHEN OTHERS THEN
4732: hr_utility.set_location('hr_us_ff_udfs.addr_val', 20);
4733: l_geocode := '00-000-0000';
4734: RETURN l_geocode;
4735: --
4736: END addr_val; -- addr_val

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

4807: IF (p_skip_rule = 'Y') THEN
4808: RAISE TOO_MANY_ROWS;
4809: END IF;
4810:
4811: hr_utility.set_location('hr_us_ff_udfs.addr_val', 1);
4812:
4813: IF (nvl(hr_general2.get_oracle_db_version, 0) < 9.0) THEN
4814: SELECT /*+ ORDERED */ a.state_code||'-'||a.county_code||'-'||a.city_code
4815: INTO l_geocode

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

4837: --
4838: EXCEPTION -- (2)
4839: --
4840: WHEN NO_DATA_FOUND THEN -- Invalid city/zip combo
4841: hr_utility.set_location('hr_us_ff_udfs.addr_val', 3);
4842: l_geocode := '00-000-0000';
4843: RETURN l_geocode;
4844: --
4845:

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

4849: INTO l_state_code
4850: FROM pay_us_states
4851: WHERE state_abbrev = p_state_abbrev;
4852:
4853: hr_utility.set_location('hr_us_ff_udfs.addr_val', 5);
4854: SELECT a.state_code||'-'||a.county_code||'-'||a.city_code
4855: INTO l_geocode
4856: FROM pay_us_zip_codes z,
4857: pay_us_city_names a,

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

4871: --
4872: -- Fallout from (2) ie. county/city/zip combo invalid or does not
4873: -- uniquely define geocode.
4874: WHEN NO_DATA_FOUND THEN
4875: hr_utility.set_location('hr_us_ff_udfs.addr_val', 7);
4876: l_geocode := '00-000-0000';
4877: RETURN l_geocode;
4878: --
4879: WHEN TOO_MANY_ROWS THEN

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

4876: l_geocode := '00-000-0000';
4877: RETURN l_geocode;
4878: --
4879: WHEN TOO_MANY_ROWS THEN
4880: hr_utility.set_location('hr_us_ff_udfs.addr_val', 9);
4881: SELECT a.state_code||'-'||a.county_code||'-'||a.city_code
4882: INTO l_geocode
4883: FROM pay_us_zip_codes z,
4884: pay_us_city_names a,

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

4902: end; -- (1)
4903: --
4904: -- We're in Main
4905: --
4906: hr_utility.set_location('hr_us_ff_udfs.addr_val', 11);
4907: --
4908: if (substr(l_geocode,8,1) = 'U') THEN
4909: l_geocode := substr(l_geocode,1,7)||'0000';
4910: END IF;

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

4914: EXCEPTION -- Main addr_val
4915: -- Fallout from (1) state/county/city/zip does not uniquely define a geo.
4916: -- Return failure geocode.
4917: WHEN NO_DATA_FOUND THEN
4918: hr_utility.set_location('hr_us_ff_udfs.addr_val', 13);
4919: l_geocode := '00-000-0000';
4920: RETURN l_geocode;
4921: --
4922: WHEN TOO_MANY_ROWS THEN

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

4919: l_geocode := '00-000-0000';
4920: RETURN l_geocode;
4921: --
4922: WHEN TOO_MANY_ROWS THEN
4923: hr_utility.set_location('hr_us_ff_udfs.addr_val', 15);
4924: l_geocode := '00-000-0000';
4925: RETURN l_geocode;
4926: --
4927: END addr_val; -- Main addr_val

Line 4974: hr_utility.trace('Entering hr_us_ff_udfs.catchup_type_details in '||p_mode||' Mode');

4970: RETURN VARCHAR2 IS
4971:
4972: BEGIN
4973:
4974: hr_utility.trace('Entering hr_us_ff_udfs.catchup_type_details in '||p_mode||' Mode');
4975: hr_utility.trace('p_plan : '||p_plan);
4976: hr_utility.trace('p_assignment_action_id : '||p_assignment_action_id);
4977: hr_utility.trace('p_base_element_name : '||p_base_element_name);
4978: hr_utility.trace('p_catchup_type : '||p_catchup_type);

Line 5059: hr_utility.trace('Leaving hr_us_ff_udfs.catchup_type_details successfully');

5055: END IF; /*catchup_type_table.EXISTS IF*/
5056:
5057: END IF; /* p_mode = 'OUT' IF */
5058:
5059: hr_utility.trace('Leaving hr_us_ff_udfs.catchup_type_details successfully');
5060:
5061: RETURN 'Y';
5062:
5063: EXCEPTION

Line 5065: hr_utility.trace('Exception raised in hr_us_ff_udfs.catchup_type_details');

5061: RETURN 'Y';
5062:
5063: EXCEPTION
5064: WHEN others THEN
5065: hr_utility.trace('Exception raised in hr_us_ff_udfs.catchup_type_details');
5066: RETURN NULL ;
5067: END catchup_type_details;
5068:
5069: --

Line 5102: hr_utility.trace('Entering hr_us_ff_udfs.direct_fed_data_archived for year '||p_reporting_year);

5098: BEGIN
5099:
5100: /*Added for Bug#14385437 */
5101:
5102: hr_utility.trace('Entering hr_us_ff_udfs.direct_fed_data_archived for year '||p_reporting_year);
5103:
5104: l_direct_fed_bal_starting_year := NVL(fnd_profile.value('PAY_US_DIRECT_BALANCE_START_YEAR'),'0001');
5105:
5106: hr_utility.trace('Starting year for Direct US Federal Balances :'||l_direct_fed_bal_starting_year);

Line 5125: hr_utility.trace('Leaving hr_us_ff_udfs.direct_fed_data_archived successfully');

5121: l_return := 'N';
5122: END IF;
5123: CLOSE check_archive_data;
5124:
5125: hr_utility.trace('Leaving hr_us_ff_udfs.direct_fed_data_archived successfully');
5126:
5127: RETURN l_return;
5128:
5129: EXCEPTION

Line 5131: hr_utility.trace('Exception raised in hr_us_ff_udfs.direct_fed_data_archived');

5127: RETURN l_return;
5128:
5129: EXCEPTION
5130: WHEN others THEN
5131: hr_utility.trace('Exception raised in hr_us_ff_udfs.direct_fed_data_archived');
5132: RETURN NULL ;
5133: END direct_fed_data_archived;
5134:
5135: /*End of changes for Bug#13614766* */

Line 5139: END hr_us_ff_udfs;

5135: /*End of changes for Bug#13614766* */
5136:
5137: --
5138:
5139: END hr_us_ff_udfs;