APPS.PAY_US_INV_DED_FORMULAS dependencies on HR_US_FF_UDFS

Line 274: Removed call to package hr_us_ff_udfs

270: to pass 2 extra parameters NET_ASG_RUN
271: and NET_ASG_PTD.
272: 27-Nov-2008 sudedas 115.72 7600041 Changed Cal_Formula_BO for Edu Loan.
273: 17-Dec-2008 sudedas 115.73 7596224 Changed Function Convert_Period_Type.
274: Removed call to package hr_us_ff_udfs
275: 13-Jan-2008 sudedas 115.74 7589784 Changed Cal_Formula_BO for Bug 7589784
276: 15-Jan-2009 sudedas 115.75 7674615 Changed cal_formula_bo for multiple
277: Educational Loan.
278: 10-Apr-2009 sudedas 115.76 8343866 Changed Cal_Formula_BO for Alaska.

Line 2964: replace hr_us_ff_udfs.convert_period_type function call

2960: -- **********************************************************************
2961: -- **********************************************************************
2962:
2963: /* Introducing following Private function to be used to
2964: replace hr_us_ff_udfs.convert_period_type function call
2965: */
2966:
2967: FUNCTION Garn_Convert_Period_Type(
2968: p_bus_grp_id in NUMBER,

Line 3113: hr_utility.trace(' Calling hr_us_ff_udfs.Work_Schedule_Total_Hours');

3109: AND NVL(business_group_id, p_bg) = p_bg
3110: AND NVL(legislation_code,'US') = 'US';
3111:
3112: hr_utility.trace(' v_work_sched_name ='||v_work_sched_name);
3113: hr_utility.trace(' Calling hr_us_ff_udfs.Work_Schedule_Total_Hours');
3114:
3115: v_hrs_per_range := hr_us_ff_udfs.Work_Schedule_Total_Hours( p_bg,
3116: v_work_sched_name,
3117: v_range_start,

Line 3115: v_hrs_per_range := hr_us_ff_udfs.Work_Schedule_Total_Hours( p_bg,

3111:
3112: hr_utility.trace(' v_work_sched_name ='||v_work_sched_name);
3113: hr_utility.trace(' Calling hr_us_ff_udfs.Work_Schedule_Total_Hours');
3114:
3115: v_hrs_per_range := hr_us_ff_udfs.Work_Schedule_Total_Hours( p_bg,
3116: v_work_sched_name,
3117: v_range_start,
3118: v_range_end);
3119:

Line 3125: hr_utility.trace(' calling hr_us_ff_udfs.Standard_Hours_Worked');

3121:
3122: hr_utility.trace(' Hourly emp using Standard Hours on asg');
3123:
3124:
3125: hr_utility.trace(' calling hr_us_ff_udfs.Standard_Hours_Worked');
3126: v_hrs_per_range := hr_us_ff_udfs.Standard_Hours_Worked( p_asg_std_hrs,
3127: v_range_start,
3128: v_range_end,
3129: p_asg_std_freq);

Line 3126: v_hrs_per_range := hr_us_ff_udfs.Standard_Hours_Worked( p_asg_std_hrs,

3122: hr_utility.trace(' Hourly emp using Standard Hours on asg');
3123:
3124:
3125: hr_utility.trace(' calling hr_us_ff_udfs.Standard_Hours_Worked');
3126: v_hrs_per_range := hr_us_ff_udfs.Standard_Hours_Worked( p_asg_std_hrs,
3127: v_range_start,
3128: v_range_end,
3129: p_asg_std_freq);
3130:

Line 3287: v_hrs_per_range := hr_us_ff_udfs.WORK_SCHEDULE_TOTAL_HOURS( p_bg,

3283: AND NVL(business_group_id, p_bg) = p_bg
3284: AND NVL(legislation_code,'US') = 'US';
3285:
3286:
3287: v_hrs_per_range := hr_us_ff_udfs.WORK_SCHEDULE_TOTAL_HOURS( p_bg,
3288: v_work_sched_name,
3289: v_range_start,
3290: v_range_end);
3291:

Line 3296: hr_utility.trace('calling hr_us_ff_udfs.Standard_Hours_Worked');

3292: ELSE-- Hourly emp using Standard Hours on asg.
3293:
3294: hr_utility.trace(' Hourly emp using Standard Hours on asg');
3295:
3296: hr_utility.trace('calling hr_us_ff_udfs.Standard_Hours_Worked');
3297:
3298: v_hrs_per_range := hr_us_ff_udfs.Standard_Hours_Worked(p_asg_std_hrs,
3299: v_range_start,
3300: v_range_end,

Line 3298: v_hrs_per_range := hr_us_ff_udfs.Standard_Hours_Worked(p_asg_std_hrs,

3294: hr_utility.trace(' Hourly emp using Standard Hours on asg');
3295:
3296: hr_utility.trace('calling hr_us_ff_udfs.Standard_Hours_Worked');
3297:
3298: v_hrs_per_range := hr_us_ff_udfs.Standard_Hours_Worked(p_asg_std_hrs,
3299: v_range_start,
3300: v_range_end,
3301: p_asg_std_freq);
3302:

Line 3303: hr_utility.trace('returned hr_us_ff_udfs.Standard_Hours_Worked');

3299: v_range_start,
3300: v_range_end,
3301: p_asg_std_freq);
3302:
3303: hr_utility.trace('returned hr_us_ff_udfs.Standard_Hours_Worked');
3304: END IF;
3305:
3306:
3307: IF v_period_hours THEN

Line 3438: /* Instead of directly calling hr_us_ff_udfs, introducing an internal

3434: END Garn_Convert_Period_Type; -- End of Garn_Convert_Period_Type
3435:
3436: BEGIN -- Begin of CONVERT_PERIOD_TYPE
3437:
3438: /* Instead of directly calling hr_us_ff_udfs, introducing an internal
3439: (Private) Function Call to be used within pay_us_inv_ded_formulas.
3440: hr_us_ff_udfs.convert_period_type fails to convert 'weekly' figure
3441: to 'period' one and vica-versa in case 'Hours Calculation Type'
3442: is set to 'Standard' at Payroll definition level.

Line 3440: hr_us_ff_udfs.convert_period_type fails to convert 'weekly' figure

3436: BEGIN -- Begin of CONVERT_PERIOD_TYPE
3437:
3438: /* Instead of directly calling hr_us_ff_udfs, introducing an internal
3439: (Private) Function Call to be used within pay_us_inv_ded_formulas.
3440: hr_us_ff_udfs.convert_period_type fails to convert 'weekly' figure
3441: to 'period' one and vica-versa in case 'Hours Calculation Type'
3442: is set to 'Standard' at Payroll definition level.
3443: Irrespective of Payroll level 'Hours Calculation Type',
3444: (Annualized or Standard) system should be able to convert

Line 3448: RETURN (hr_us_ff_udfs.convert_period_type(CTX_BUSINESS_GROUP_ID,

3444: (Annualized or Standard) system should be able to convert
3445: weekly to period figure correctly and vice-versa.
3446: */
3447: /*
3448: RETURN (hr_us_ff_udfs.convert_period_type(CTX_BUSINESS_GROUP_ID,
3449: CTX_PAYROLL_ID,
3450: SCL_ASG_US_WORK_SCHEDULE,
3451: ASG_HOURS,
3452: FED_CRITERIA_PCT_PRD_DI_XMPT,

Line 3595: RETURN hr_us_ff_udfs.addr_val (OVERRIDE_ADR_REGION_2,

3591: OVERRIDE_ADR_CITY varchar2,
3592: OVERRIDE_ADR_POSTAL_CODE varchar2
3593: ) RETURN varchar2 IS
3594: BEGIN
3595: RETURN hr_us_ff_udfs.addr_val (OVERRIDE_ADR_REGION_2,
3596: OVERRIDE_ADR_REGION_1,
3597: OVERRIDE_ADR_CITY,
3598: OVERRIDE_ADR_POSTAL_CODE);
3599: END GET_GEOCODE;