[Home] [Help]
38:
39: 21-AUG-2007 sodhingr 115.6 6163428 Changed the procedure, Conver_Period_Type to uncomment
40: the code to check the payroll calculation rule defined at the payroll level.
41: Also, moved the variable name l_normal_hours to global variable as this
42: will be used by the uncommented code to get the standard hours.
43: 08-Jan-2008 sudedas 115.7 6718164 Added new Function term_skip_rule_rwage
44: 21-Jan-2008 sudedas 115.8 Corrected Logic for Term Rule LSPD
45: Used Cursor csr_lspprocd_min_dtearned.
46: Contexxt
632: /***********************************************************
633: The is wrapper is added to check the caluclation rule given
634: at the payroll level. Depending upon the Rule we will the
635: Get_Annualizing_Factor fun calls. If the rule is
636: standard it goes to Standard Caluclation type. If the rule
637: is Annual then it goes to ANNU rule
638: **************************************************************/
639: IF p_period_start_date IS NULL THEN
640: v_stnd_start_date := sysdate;
839: IF UPPER(p_wsched) = 'NOT ENTERED' THEN
840:
841: hr_utility.set_location('Prorate_Earnings', 7);
842: hr_utility.trace('p_wsched NOT ENTERED');
843: hr_utility.trace('Calling Standard Hours Worked');
844:
845: v_hours_in_range := Standard_Hours_Worked( p_asg_std_hours,
846: p_range_start_date,
847: p_range_end_date,
841: hr_utility.set_location('Prorate_Earnings', 7);
842: hr_utility.trace('p_wsched NOT ENTERED');
843: hr_utility.trace('Calling Standard Hours Worked');
844:
845: v_hours_in_range := Standard_Hours_Worked( p_asg_std_hours,
846: p_range_start_date,
847: p_range_end_date,
848: p_asg_std_freq);
849:
1557: -- For Hourly pay basis:
1558: -- Get hours scheduled for the current period either from:
1559: -- 1. ASG work schedule
1560: -- 2. ORG default work schedule
1561: -- 3. ASG standard hours and frequency
1562: -- Multiply the hours scheduled for period by normal Hourly Rate (ie. from
1563: -- pre-defined earnings, REGULAR_WAGES_RATE) pay period earnings.
1564: --
1565: -- In either case, need to find the payroll period type, let's do it upfront:
1606: -- Pay basis is hourly,
1607: -- Get hours scheduled for the current period either from:
1608: -- 1. ASG work schedule
1609: -- 2. ORG default work schedule
1610: -- 3. ASG standard hours and frequency
1611: -- Do we pass in Work Schedule from asst scl db item? Yes
1612: -- 10-JAN-1996 hparicha : We no longer assume "standard hours" represent
1613: -- a weekly figure. We also no longer use a week as
1614: -- the basis for annualization,
1608: -- 1. ASG work schedule
1609: -- 2. ORG default work schedule
1610: -- 3. ASG standard hours and frequency
1611: -- Do we pass in Work Schedule from asst scl db item? Yes
1612: -- 10-JAN-1996 hparicha : We no longer assume "standard hours" represent
1613: -- a weekly figure. We also no longer use a week as
1614: -- the basis for annualization,
1615: -- even when using work schedule - ie. need to find ACTUAL
1616: -- scheduled hours, not
1647: hr_utility.trace('v_hrs_per_range ='||to_char(v_hrs_per_range));
1648: ELSE
1649:
1650: hr_utility.trace('Asg has No Work Schedule');
1651: hr_utility.trace('Calling Standard_Hours_Worked');
1652:
1653: v_hrs_per_range := Standard_Hours_Worked( p_asst_std_hrs,
1654: p_period_start,
1655: p_period_end,
1649:
1650: hr_utility.trace('Asg has No Work Schedule');
1651: hr_utility.trace('Calling Standard_Hours_Worked');
1652:
1653: v_hrs_per_range := Standard_Hours_Worked( p_asst_std_hrs,
1654: p_period_start,
1655: p_period_end,
1656: p_asst_std_freq);
1657: hr_utility.trace('v_hrs_per_range ='||to_char(v_hrs_per_range));
2775:
2776: END get_hourly_rate;
2777:
2778:
2779: FUNCTION standard_hours_worked(
2780: p_std_hrs in NUMBER,
2781: p_range_start in DATE,
2782: p_range_end in DATE,
2783: p_std_freq in VARCHAR2) RETURN NUMBER IS
2792: v_curr_date DATE;
2793: v_curr_day VARCHAR2(3); -- 3 char abbrev for day of wk.
2794: v_day_no NUMBER;
2795:
2796: BEGIN -- standard_hours_worked
2797:
2798: /* Init */
2799: c_wkdays_per_week := 5;
2800: c_wkdays_per_month := 20;
2804: v_curr_date := NULL;
2805: v_curr_day :=NULL;
2806:
2807: -- Check for valid range
2808: hr_utility.trace('Entered standard_hours_worked');
2809:
2810: IF p_range_start > p_range_end THEN
2811: hr_utility.trace('p_range_start greater than p_range_end');
2812: RETURN v_total_hours;
2871: v_curr_date := v_curr_date + 1;
2872: EXIT WHEN v_curr_date > p_range_end;
2873: END LOOP;
2874: hr_utility.trace(' Final v_total_hours = '||to_char(v_total_hours));
2875: hr_utility.trace(' Leaving standard_hours_worked' );
2876: --
2877: RETURN v_total_hours;
2878: --
2879: END standard_hours_worked;
2875: hr_utility.trace(' Leaving standard_hours_worked' );
2876: --
2877: RETURN v_total_hours;
2878: --
2879: END standard_hours_worked;
2880:
2881: -- +-------------------------------------------------------------------------+
2882: -- |-----------------< good_time_format >-------------------------|
2883: -- +-------------------------------------------------------------------------+
3280:
3281: -- hr_utility.trace_off;
3282:
3283:
3284: /* Calculate hours worked based on standard conditions if the actual hours
3285: worked are not available from either ATG work schedule or work schedule
3286: at assignment/org level */
3287:
3288: IF NOT l_work_schedule_found THEN
3285: worked are not available from either ATG work schedule or work schedule
3286: at assignment/org level */
3287:
3288: IF NOT l_work_schedule_found THEN
3289: hr_utility.trace('Calculating hours based on Standard conditions ');
3290: hr_utility.trace( 'Assignment Id '||assignment_id);
3291: hr_utility.trace( 'date_earned '||date_earned);
3292: OPEN get_asg_hours_freq(date_earned,assignment_id);
3293: FETCH get_asg_hours_freq
3297: hr_utility.trace( 'l_asg_frequency '||l_asg_frequency);
3298: hr_utility.trace( 'l_normal_hours '||l_normal_hours);
3299:
3300: IF l_asg_frequency IS NOT NULL and l_normal_hours IS NOT NULL THEN
3301: l_total_hours := standard_hours_worked(l_normal_hours
3302: ,p_period_start_date
3303: ,p_period_end_date
3304: ,l_asg_frequency);
3305: return l_total_hours;
3337:
3338: CURSOR csr_term_dates(p_date_earned date
3339: ,p_assignment_id number) is
3340: select pds.actual_termination_date
3341: ,pds.last_standard_process_date
3342: ,pds.final_process_date
3343: from per_periods_of_service PDS,
3344: per_assignments_f ASS
3345: WHERE PDS.actual_termination_date <= p_date_earned
3503: return 'Y';
3504: END IF;
3505: END IF; -- ATD <= Current Pay Period Date Earned
3506:
3507: ELSIF lv_term_typ = 'L' THEN -- Term Rule 'Last Standard Process Date'
3508: IF ((ld_atd <= ctx_date_earned
3509: AND ld_lspd <= ctx_date_earned) OR
3510: (ld_atd <= ctx_date_earned
3511: AND ld_lspd > ctx_date_earned)) THEN