[Home] [Help]
211: ln_user_row_id NUMBER;
212: ln_value VARCHAR2(100);
213:
214: BEGIN
215: hr_utility.trace('Entering into get_wrk_sch_std_hrs');
216: hr_utility.trace('Parameters Passed..');
217: hr_utility.trace('p_assignment_action_id := ' || p_assignment_action_id);
218: hr_utility.trace('p_assignment_id := ' || p_assignment_id);
219: hr_utility.trace('p_bg_id := ' || p_bg_id);
212: ln_value VARCHAR2(100);
213:
214: BEGIN
215: hr_utility.trace('Entering into get_wrk_sch_std_hrs');
216: hr_utility.trace('Parameters Passed..');
217: hr_utility.trace('p_assignment_action_id := ' || p_assignment_action_id);
218: hr_utility.trace('p_assignment_id := ' || p_assignment_id);
219: hr_utility.trace('p_bg_id := ' || p_bg_id);
220: hr_utility.trace('p_element_entry_id := ' || p_element_entry_id);
213:
214: BEGIN
215: hr_utility.trace('Entering into get_wrk_sch_std_hrs');
216: hr_utility.trace('Parameters Passed..');
217: hr_utility.trace('p_assignment_action_id := ' || p_assignment_action_id);
218: hr_utility.trace('p_assignment_id := ' || p_assignment_id);
219: hr_utility.trace('p_bg_id := ' || p_bg_id);
220: hr_utility.trace('p_element_entry_id := ' || p_element_entry_id);
221: hr_utility.trace('p_date_earned := ' || TO_CHAR(p_date_earned));
214: BEGIN
215: hr_utility.trace('Entering into get_wrk_sch_std_hrs');
216: hr_utility.trace('Parameters Passed..');
217: hr_utility.trace('p_assignment_action_id := ' || p_assignment_action_id);
218: hr_utility.trace('p_assignment_id := ' || p_assignment_id);
219: hr_utility.trace('p_bg_id := ' || p_bg_id);
220: hr_utility.trace('p_element_entry_id := ' || p_element_entry_id);
221: hr_utility.trace('p_date_earned := ' || TO_CHAR(p_date_earned));
222: hr_utility.trace('p_period_start := ' || TO_CHAR(p_period_start));
215: hr_utility.trace('Entering into get_wrk_sch_std_hrs');
216: hr_utility.trace('Parameters Passed..');
217: hr_utility.trace('p_assignment_action_id := ' || p_assignment_action_id);
218: hr_utility.trace('p_assignment_id := ' || p_assignment_id);
219: hr_utility.trace('p_bg_id := ' || p_bg_id);
220: hr_utility.trace('p_element_entry_id := ' || p_element_entry_id);
221: hr_utility.trace('p_date_earned := ' || TO_CHAR(p_date_earned));
222: hr_utility.trace('p_period_start := ' || TO_CHAR(p_period_start));
223: hr_utility.trace('p_period_end := ' || TO_CHAR(p_period_end));
216: hr_utility.trace('Parameters Passed..');
217: hr_utility.trace('p_assignment_action_id := ' || p_assignment_action_id);
218: hr_utility.trace('p_assignment_id := ' || p_assignment_id);
219: hr_utility.trace('p_bg_id := ' || p_bg_id);
220: hr_utility.trace('p_element_entry_id := ' || p_element_entry_id);
221: hr_utility.trace('p_date_earned := ' || TO_CHAR(p_date_earned));
222: hr_utility.trace('p_period_start := ' || TO_CHAR(p_period_start));
223: hr_utility.trace('p_period_end := ' || TO_CHAR(p_period_end));
224:
217: hr_utility.trace('p_assignment_action_id := ' || p_assignment_action_id);
218: hr_utility.trace('p_assignment_id := ' || p_assignment_id);
219: hr_utility.trace('p_bg_id := ' || p_bg_id);
220: hr_utility.trace('p_element_entry_id := ' || p_element_entry_id);
221: hr_utility.trace('p_date_earned := ' || TO_CHAR(p_date_earned));
222: hr_utility.trace('p_period_start := ' || TO_CHAR(p_period_start));
223: hr_utility.trace('p_period_end := ' || TO_CHAR(p_period_end));
224:
225: OPEN get_id_flex_num;
218: hr_utility.trace('p_assignment_id := ' || p_assignment_id);
219: hr_utility.trace('p_bg_id := ' || p_bg_id);
220: hr_utility.trace('p_element_entry_id := ' || p_element_entry_id);
221: hr_utility.trace('p_date_earned := ' || TO_CHAR(p_date_earned));
222: hr_utility.trace('p_period_start := ' || TO_CHAR(p_period_start));
223: hr_utility.trace('p_period_end := ' || TO_CHAR(p_period_end));
224:
225: OPEN get_id_flex_num;
226: FETCH get_id_flex_num INTO ln_id_flex_num;
219: hr_utility.trace('p_bg_id := ' || p_bg_id);
220: hr_utility.trace('p_element_entry_id := ' || p_element_entry_id);
221: hr_utility.trace('p_date_earned := ' || TO_CHAR(p_date_earned));
222: hr_utility.trace('p_period_start := ' || TO_CHAR(p_period_start));
223: hr_utility.trace('p_period_end := ' || TO_CHAR(p_period_end));
224:
225: OPEN get_id_flex_num;
226: FETCH get_id_flex_num INTO ln_id_flex_num;
227: CLOSE get_id_flex_num;
225: OPEN get_id_flex_num;
226: FETCH get_id_flex_num INTO ln_id_flex_num;
227: CLOSE get_id_flex_num;
228:
229: hr_utility.trace('ln_id_flex_num := ' || ln_id_flex_num);
230:
231: OPEN get_ws_name(p_id_flex_num => ln_id_flex_num
232: ,p_date_earned => p_date_earned
233: ,p_assignment_id => p_assignment_id);
233: ,p_assignment_id => p_assignment_id);
234: FETCH get_ws_name INTO ln_user_col_id;
235: CLOSE get_ws_name;
236:
237: hr_utility.trace('ln_user_col_id := ' || ln_user_col_id);
238:
239: OPEN get_user_table(p_business_grp_id => p_bg_id);
240: FETCH get_user_table INTO ln_user_table_id
241: ,lv_user_table_name;
240: FETCH get_user_table INTO ln_user_table_id
241: ,lv_user_table_name;
242: CLOSE get_user_table;
243:
244: hr_utility.trace('ln_user_table_id := ' || ln_user_table_id);
245: hr_utility.trace('lv_user_table_name := ' || lv_user_table_name);
246:
247: OPEN get_user_cols(p_user_table_id => ln_user_table_id
248: ,p_user_col_id => ln_user_col_id
241: ,lv_user_table_name;
242: CLOSE get_user_table;
243:
244: hr_utility.trace('ln_user_table_id := ' || ln_user_table_id);
245: hr_utility.trace('lv_user_table_name := ' || lv_user_table_name);
246:
247: OPEN get_user_cols(p_user_table_id => ln_user_table_id
248: ,p_user_col_id => ln_user_col_id
249: ,p_bg_id => p_bg_id);
250: FETCH get_user_cols INTO ln_user_col_id
251: ,lv_user_col_name;
252: CLOSE get_user_cols;
253:
254: hr_utility.trace('ln_user_col_id := ' || ln_user_col_id);
255: hr_utility.trace('lv_user_col_name := ' || lv_user_col_name);
256:
257: ln_std_hrs_wrksch := 0;
258: hr_utility.trace('ln_std_hrs_wrksch := ' || ln_std_hrs_wrksch);
251: ,lv_user_col_name;
252: CLOSE get_user_cols;
253:
254: hr_utility.trace('ln_user_col_id := ' || ln_user_col_id);
255: hr_utility.trace('lv_user_col_name := ' || lv_user_col_name);
256:
257: ln_std_hrs_wrksch := 0;
258: hr_utility.trace('ln_std_hrs_wrksch := ' || ln_std_hrs_wrksch);
259: OPEN get_user_rows(p_user_table_id => ln_user_table_id
254: hr_utility.trace('ln_user_col_id := ' || ln_user_col_id);
255: hr_utility.trace('lv_user_col_name := ' || lv_user_col_name);
256:
257: ln_std_hrs_wrksch := 0;
258: hr_utility.trace('ln_std_hrs_wrksch := ' || ln_std_hrs_wrksch);
259: OPEN get_user_rows(p_user_table_id => ln_user_table_id
260: ,p_date_earned => p_date_earned);
261: LOOP
262: FETCH get_user_rows INTO ln_user_row_id;
260: ,p_date_earned => p_date_earned);
261: LOOP
262: FETCH get_user_rows INTO ln_user_row_id;
263:
264: hr_utility.trace('ln_user_row_id := ' || ln_user_row_id);
265:
266: EXIT WHEN get_user_rows%NOTFOUND;
267: OPEN get_user_col_values(p_user_row_id => ln_user_row_id
268: ,p_user_col_id => ln_user_col_id
273: CLOSE get_user_col_values;
274:
275: END LOOP;
276: CLOSE get_user_rows;
277: hr_utility.trace('Returning ln_std_hrs_wrksch := ' || ln_std_hrs_wrksch);
278: RETURN ln_std_hrs_wrksch;
279:
280: END get_wrk_sch_std_hrs;
281:
482: -- Selecting "count" because we want to continue processing even if
483: -- the from_freq is not a pay basis.
484: --
485:
486: hr_utility.trace(' Entered Get_Annualizing_Factor ');
487:
488: BEGIN -- Is Freq pay basis?
489:
490: --
491: -- Decode pay basis and set v_annualizing_factor accordingly.
492: -- PAY_BASIS "Meaning" is passed from FF !
493: --
494:
495: hr_utility.trace(' Getting lookup code for lookup_type = PAY_BASIS');
496: hr_utility.trace(' p_freq = '||p_freq);
497:
498:
499: IF p_freq IS NULL THEN
492: -- PAY_BASIS "Meaning" is passed from FF !
493: --
494:
495: hr_utility.trace(' Getting lookup code for lookup_type = PAY_BASIS');
496: hr_utility.trace(' p_freq = '||p_freq);
497:
498:
499: IF p_freq IS NULL THEN
500: v_use_pay_basis := 0;
512: END IF;
513:
514: --v_pay_basis := p_freq;
515:
516: hr_utility.trace(' Lookup_code ie v_pay_basis ='||v_pay_basis);
517:
518: IF v_pay_basis = 'MONTHLY' THEN
519:
520: hr_utility.trace(' Entered for MONTHLY v_pay_basis');
516: hr_utility.trace(' Lookup_code ie v_pay_basis ='||v_pay_basis);
517:
518: IF v_pay_basis = 'MONTHLY' THEN
519:
520: hr_utility.trace(' Entered for MONTHLY v_pay_basis');
521:
522: v_annualizing_factor := 12;
523:
524: hr_utility.trace(' v_annualizing_factor = 12 ');
520: hr_utility.trace(' Entered for MONTHLY v_pay_basis');
521:
522: v_annualizing_factor := 12;
523:
524: hr_utility.trace(' v_annualizing_factor = 12 ');
525:
526: ELSIF v_pay_basis = 'HOURLY' THEN
527:
528: hr_utility.trace(' Entered for HOURLY v_pay_basis');
524: hr_utility.trace(' v_annualizing_factor = 12 ');
525:
526: ELSIF v_pay_basis = 'HOURLY' THEN
527:
528: hr_utility.trace(' Entered for HOURLY v_pay_basis');
529:
530: IF p_period_start_date IS NOT NULL THEN
531:
532: hr_utility.trace(' p_period_start_date IS NOT NULL ' ||
528: hr_utility.trace(' Entered for HOURLY v_pay_basis');
529:
530: IF p_period_start_date IS NOT NULL THEN
531:
532: hr_utility.trace(' p_period_start_date IS NOT NULL ' ||
533: ' v_period_hours=T');
534:
535: v_range_start := p_period_start_date;
536: v_range_end := p_period_end_date;
537: v_period_hours := TRUE;
538:
539: ELSE
540:
541: hr_utility.trace(' p_period_start_date IS NULL');
542:
543: v_range_start := sysdate;
544: v_range_end := sysdate + 6;
545: v_period_hours := FALSE;
565: ,v_return_message);
566:
567: IF v_period_hours THEN
568:
569: hr_utility.trace(' v_period_hours is TRUE');
570:
571: SELECT TPT.number_per_fiscal_year
572: INTO v_periods_per_fiscal_yr
573: FROM pay_payrolls_f PPF,
589: END IF;
590:
591: ELSIF v_pay_basis = 'PERIOD' THEN
592:
593: hr_utility.trace(' v_pay_basis = PERIOD');
594:
595: SELECT TPT.number_per_fiscal_year
596: INTO v_annualizing_factor
597: FROM pay_payrolls_f PRL,
607:
608: ELSIF v_pay_basis = 'ANNUAL' THEN
609:
610:
611: hr_utility.trace(' v_pay_basis = ANNUAL');
612:
613: v_annualizing_factor := 1;
614:
615: ELSE
616:
617: -- Did not recognize "pay basis", return -999 as annualizing factor.
618: -- Remember this for debugging when zeroes come out as results!!!
619:
620: hr_utility.trace(' Did not recognize pay basis');
621:
622: v_annualizing_factor := 0;
623:
624: RETURN v_annualizing_factor;
629: EXCEPTION
630:
631: WHEN NO_DATA_FOUND THEN
632:
633: hr_utility.trace(' When no data found' );
634: v_use_pay_basis := 0;
635:
636: END; /* SELECT LOOKUP CODE */
637:
637:
638:
639: IF v_use_pay_basis = 0 THEN
640:
641: hr_utility.trace(' Not using pay basis as frequency');
642:
643: -- Not using pay basis as frequency...
644:
645: IF (p_freq IS NULL) OR
648: THEN
649:
650: -- Get "annuallizing factor" from period type of the payroll.
651:
652: hr_utility.trace('Get annuallizing factor from period '||
653: 'type of the payroll');
654:
655: SELECT TPT.number_per_fiscal_year
656: INTO v_annualizing_factor
663: AND PRL.effective_end_date
664: AND PRL.payroll_id = p_payroll_id
665: AND PRL.business_group_id + 0 = p_bg;
666:
667: hr_utility.trace('v_annualizing_factor ='||
668: to_number(v_annualizing_factor));
669:
670:
671: ELSIF UPPER(p_freq) = 'HOURLY' THEN -- Hourly employee...
669:
670:
671: ELSIF UPPER(p_freq) = 'HOURLY' THEN -- Hourly employee...
672:
673: hr_utility.trace(' Hourly Employee');
674:
675: IF p_period_start_date IS NOT NULL THEN
676: v_range_start := p_period_start_date;
677: v_range_end := p_period_end_date;
699: ,v_schedule
700: ,v_return_status
701: ,v_return_message);
702:
703: hr_utility.trace('v_hrs_per_range ='||v_hrs_per_range);
704: IF v_period_hours THEN
705:
706: hr_utility.trace('v_period_hours = TRUE');
707:
702:
703: hr_utility.trace('v_hrs_per_range ='||v_hrs_per_range);
704: IF v_period_hours THEN
705:
706: hr_utility.trace('v_period_hours = TRUE');
707:
708: SELECT TPT.number_per_fiscal_year
709: INTO v_periods_per_fiscal_yr
710: FROM pay_payrolls_f ppf,
718:
719: v_annualizing_factor :=
720: v_hrs_per_range * v_periods_per_fiscal_yr;
721:
722: hr_utility.trace('v_hrs_per_range ='||
723: to_number(v_hrs_per_range));
724: hr_utility.trace('v_periods_per_fiscal_yr ='||
725: to_number(v_periods_per_fiscal_yr));
726: hr_utility.trace('v_annualizing_factor ='||
720: v_hrs_per_range * v_periods_per_fiscal_yr;
721:
722: hr_utility.trace('v_hrs_per_range ='||
723: to_number(v_hrs_per_range));
724: hr_utility.trace('v_periods_per_fiscal_yr ='||
725: to_number(v_periods_per_fiscal_yr));
726: hr_utility.trace('v_annualizing_factor ='||
727: to_number(v_annualizing_factor));
728:
722: hr_utility.trace('v_hrs_per_range ='||
723: to_number(v_hrs_per_range));
724: hr_utility.trace('v_periods_per_fiscal_yr ='||
725: to_number(v_periods_per_fiscal_yr));
726: hr_utility.trace('v_annualizing_factor ='||
727: to_number(v_annualizing_factor));
728:
729: ELSE
730:
727: to_number(v_annualizing_factor));
728:
729: ELSE
730:
731: hr_utility.trace('v_period_hours = FALSE');
732:
733: v_annualizing_factor := v_hrs_per_range * c_weeks_per_year;
734:
735: hr_utility.trace('v_hrs_per_range ='||
731: hr_utility.trace('v_period_hours = FALSE');
732:
733: v_annualizing_factor := v_hrs_per_range * c_weeks_per_year;
734:
735: hr_utility.trace('v_hrs_per_range ='||
736: to_number(v_hrs_per_range));
737: hr_utility.trace('c_weeks_per_year ='||
738: to_number(c_weeks_per_year));
739: hr_utility.trace('v_annualizing_factor ='||
733: v_annualizing_factor := v_hrs_per_range * c_weeks_per_year;
734:
735: hr_utility.trace('v_hrs_per_range ='||
736: to_number(v_hrs_per_range));
737: hr_utility.trace('c_weeks_per_year ='||
738: to_number(c_weeks_per_year));
739: hr_utility.trace('v_annualizing_factor ='||
740: to_number(v_annualizing_factor));
741:
735: hr_utility.trace('v_hrs_per_range ='||
736: to_number(v_hrs_per_range));
737: hr_utility.trace('c_weeks_per_year ='||
738: to_number(c_weeks_per_year));
739: hr_utility.trace('v_annualizing_factor ='||
740: to_number(v_annualizing_factor));
741:
742: END IF;
743:
744: ELSE
745:
746: -- Not hourly, an actual time period type!
747:
748: hr_utility.trace('Not hourly - an actual time period type');
749:
750: BEGIN
751:
752: hr_utility.trace(' selecting from per_time_period_types');
748: hr_utility.trace('Not hourly - an actual time period type');
749:
750: BEGIN
751:
752: hr_utility.trace(' selecting from per_time_period_types');
753:
754: SELECT PT.number_per_fiscal_year
755: INTO v_annualizing_factor
756: FROM per_time_period_types PT
755: INTO v_annualizing_factor
756: FROM per_time_period_types PT
757: WHERE UPPER(PT.period_type) = UPPER(p_freq);
758:
759: hr_utility.trace('v_annualizing_factor ='||
760: to_number(v_annualizing_factor));
761:
762: EXCEPTION WHEN no_data_found THEN
763:
767: -- 'Day' or 'Month' which do not map to a time period type.
768: -- So we'll do these by hand.
769:
770: IF UPPER(p_freq) = 'DAY' THEN
771: hr_utility.trace(' p_freq = DAY');
772: v_annualizing_factor := c_days_per_year;
773: ELSIF UPPER(p_freq) = 'MONTH' THEN
774: v_annualizing_factor := c_months_per_year;
775: hr_utility.trace(' p_freq = MONTH');
771: hr_utility.trace(' p_freq = DAY');
772: v_annualizing_factor := c_days_per_year;
773: ELSIF UPPER(p_freq) = 'MONTH' THEN
774: v_annualizing_factor := c_months_per_year;
775: hr_utility.trace(' p_freq = MONTH');
776: END IF;
777:
778: END;
779:
781:
782: END IF; -- (v_use_pay_basis = 0)
783:
784:
785: hr_utility.trace(' Getting out of Get_Annualizing_Factor for '||
786: v_pay_basis);
787: RETURN v_annualizing_factor;
788:
789: END Get_Annualizing_Factor;
790:
791: BEGIN -- Convert Figure
792: --begin_convert_period_type
793:
794: --hr_utility.trace_on(null,'pay_core_ff_udfs');
795:
796: IF p_from_freq IS NULL THEN
797: v_from_freq := 'NOT ENTERED';
798: END IF;
804: /* IF p_rate_calc_override IS NULL THEN
805: v_rate_calc_override := 'NOT ENTERED';
806: END IF;
807: */
808: hr_utility.trace('COREUDFS Entered Convert_Period_Type');
809:
810: hr_utility.trace('assignment_action_id=' || p_assignment_action_id);
811: hr_utility.trace('assignment_id=' || p_assignment_id);
812: hr_utility.trace('business_group_id=' || p_bg);
806: END IF;
807: */
808: hr_utility.trace('COREUDFS Entered Convert_Period_Type');
809:
810: hr_utility.trace('assignment_action_id=' || p_assignment_action_id);
811: hr_utility.trace('assignment_id=' || p_assignment_id);
812: hr_utility.trace('business_group_id=' || p_bg);
813: hr_utility.trace('element_entry_id=' || p_element_entry_id);
814: hr_utility.trace( 'p-date_earned '||p_date_earned);
807: */
808: hr_utility.trace('COREUDFS Entered Convert_Period_Type');
809:
810: hr_utility.trace('assignment_action_id=' || p_assignment_action_id);
811: hr_utility.trace('assignment_id=' || p_assignment_id);
812: hr_utility.trace('business_group_id=' || p_bg);
813: hr_utility.trace('element_entry_id=' || p_element_entry_id);
814: hr_utility.trace( 'p-date_earned '||p_date_earned);
815: hr_utility.trace(' p_payroll_id: '||p_payroll_id);
808: hr_utility.trace('COREUDFS Entered Convert_Period_Type');
809:
810: hr_utility.trace('assignment_action_id=' || p_assignment_action_id);
811: hr_utility.trace('assignment_id=' || p_assignment_id);
812: hr_utility.trace('business_group_id=' || p_bg);
813: hr_utility.trace('element_entry_id=' || p_element_entry_id);
814: hr_utility.trace( 'p-date_earned '||p_date_earned);
815: hr_utility.trace(' p_payroll_id: '||p_payroll_id);
816: hr_utility.trace(' p_figure: '||p_figure);
809:
810: hr_utility.trace('assignment_action_id=' || p_assignment_action_id);
811: hr_utility.trace('assignment_id=' || p_assignment_id);
812: hr_utility.trace('business_group_id=' || p_bg);
813: hr_utility.trace('element_entry_id=' || p_element_entry_id);
814: hr_utility.trace( 'p-date_earned '||p_date_earned);
815: hr_utility.trace(' p_payroll_id: '||p_payroll_id);
816: hr_utility.trace(' p_figure: '||p_figure);
817: hr_utility.trace('p_period_start_date=' || p_period_start_date);
810: hr_utility.trace('assignment_action_id=' || p_assignment_action_id);
811: hr_utility.trace('assignment_id=' || p_assignment_id);
812: hr_utility.trace('business_group_id=' || p_bg);
813: hr_utility.trace('element_entry_id=' || p_element_entry_id);
814: hr_utility.trace( 'p-date_earned '||p_date_earned);
815: hr_utility.trace(' p_payroll_id: '||p_payroll_id);
816: hr_utility.trace(' p_figure: '||p_figure);
817: hr_utility.trace('p_period_start_date=' || p_period_start_date);
818: hr_utility.trace('p_period_end_date=' || p_period_end_date);
811: hr_utility.trace('assignment_id=' || p_assignment_id);
812: hr_utility.trace('business_group_id=' || p_bg);
813: hr_utility.trace('element_entry_id=' || p_element_entry_id);
814: hr_utility.trace( 'p-date_earned '||p_date_earned);
815: hr_utility.trace(' p_payroll_id: '||p_payroll_id);
816: hr_utility.trace(' p_figure: '||p_figure);
817: hr_utility.trace('p_period_start_date=' || p_period_start_date);
818: hr_utility.trace('p_period_end_date=' || p_period_end_date);
819: /*hr_utility.trace('p_schedule_category=' || p_schedule_category);
812: hr_utility.trace('business_group_id=' || p_bg);
813: hr_utility.trace('element_entry_id=' || p_element_entry_id);
814: hr_utility.trace( 'p-date_earned '||p_date_earned);
815: hr_utility.trace(' p_payroll_id: '||p_payroll_id);
816: hr_utility.trace(' p_figure: '||p_figure);
817: hr_utility.trace('p_period_start_date=' || p_period_start_date);
818: hr_utility.trace('p_period_end_date=' || p_period_end_date);
819: /*hr_utility.trace('p_schedule_category=' || p_schedule_category);
820: hr_utility.trace('p_schedule_source=' || p_schedule_source);
813: hr_utility.trace('element_entry_id=' || p_element_entry_id);
814: hr_utility.trace( 'p-date_earned '||p_date_earned);
815: hr_utility.trace(' p_payroll_id: '||p_payroll_id);
816: hr_utility.trace(' p_figure: '||p_figure);
817: hr_utility.trace('p_period_start_date=' || p_period_start_date);
818: hr_utility.trace('p_period_end_date=' || p_period_end_date);
819: /*hr_utility.trace('p_schedule_category=' || p_schedule_category);
820: hr_utility.trace('p_schedule_source=' || p_schedule_source);
821: hr_utility.trace('p_include_exceptions=' || p_include_exceptions);
814: hr_utility.trace( 'p-date_earned '||p_date_earned);
815: hr_utility.trace(' p_payroll_id: '||p_payroll_id);
816: hr_utility.trace(' p_figure: '||p_figure);
817: hr_utility.trace('p_period_start_date=' || p_period_start_date);
818: hr_utility.trace('p_period_end_date=' || p_period_end_date);
819: /*hr_utility.trace('p_schedule_category=' || p_schedule_category);
820: hr_utility.trace('p_schedule_source=' || p_schedule_source);
821: hr_utility.trace('p_include_exceptions=' || p_include_exceptions);
822: hr_utility.trace('p_busy_tentative_as=' || p_busy_tentative_as);
815: hr_utility.trace(' p_payroll_id: '||p_payroll_id);
816: hr_utility.trace(' p_figure: '||p_figure);
817: hr_utility.trace('p_period_start_date=' || p_period_start_date);
818: hr_utility.trace('p_period_end_date=' || p_period_end_date);
819: /*hr_utility.trace('p_schedule_category=' || p_schedule_category);
820: hr_utility.trace('p_schedule_source=' || p_schedule_source);
821: hr_utility.trace('p_include_exceptions=' || p_include_exceptions);
822: hr_utility.trace('p_busy_tentative_as=' || p_busy_tentative_as);
823: hr_utility.trace('p_schedule=' || p_schedule);*/
816: hr_utility.trace(' p_figure: '||p_figure);
817: hr_utility.trace('p_period_start_date=' || p_period_start_date);
818: hr_utility.trace('p_period_end_date=' || p_period_end_date);
819: /*hr_utility.trace('p_schedule_category=' || p_schedule_category);
820: hr_utility.trace('p_schedule_source=' || p_schedule_source);
821: hr_utility.trace('p_include_exceptions=' || p_include_exceptions);
822: hr_utility.trace('p_busy_tentative_as=' || p_busy_tentative_as);
823: hr_utility.trace('p_schedule=' || p_schedule);*/
824:
817: hr_utility.trace('p_period_start_date=' || p_period_start_date);
818: hr_utility.trace('p_period_end_date=' || p_period_end_date);
819: /*hr_utility.trace('p_schedule_category=' || p_schedule_category);
820: hr_utility.trace('p_schedule_source=' || p_schedule_source);
821: hr_utility.trace('p_include_exceptions=' || p_include_exceptions);
822: hr_utility.trace('p_busy_tentative_as=' || p_busy_tentative_as);
823: hr_utility.trace('p_schedule=' || p_schedule);*/
824:
825: hr_utility.trace(' p_from_freq : '||p_from_freq);
818: hr_utility.trace('p_period_end_date=' || p_period_end_date);
819: /*hr_utility.trace('p_schedule_category=' || p_schedule_category);
820: hr_utility.trace('p_schedule_source=' || p_schedule_source);
821: hr_utility.trace('p_include_exceptions=' || p_include_exceptions);
822: hr_utility.trace('p_busy_tentative_as=' || p_busy_tentative_as);
823: hr_utility.trace('p_schedule=' || p_schedule);*/
824:
825: hr_utility.trace(' p_from_freq : '||p_from_freq);
826: hr_utility.trace(' p_to_freq: '||p_to_freq);
819: /*hr_utility.trace('p_schedule_category=' || p_schedule_category);
820: hr_utility.trace('p_schedule_source=' || p_schedule_source);
821: hr_utility.trace('p_include_exceptions=' || p_include_exceptions);
822: hr_utility.trace('p_busy_tentative_as=' || p_busy_tentative_as);
823: hr_utility.trace('p_schedule=' || p_schedule);*/
824:
825: hr_utility.trace(' p_from_freq : '||p_from_freq);
826: hr_utility.trace(' p_to_freq: '||p_to_freq);
827: hr_utility.trace(' p_asst_std_freq: '||p_asst_std_freq);
821: hr_utility.trace('p_include_exceptions=' || p_include_exceptions);
822: hr_utility.trace('p_busy_tentative_as=' || p_busy_tentative_as);
823: hr_utility.trace('p_schedule=' || p_schedule);*/
824:
825: hr_utility.trace(' p_from_freq : '||p_from_freq);
826: hr_utility.trace(' p_to_freq: '||p_to_freq);
827: hr_utility.trace(' p_asst_std_freq: '||p_asst_std_freq);
828:
829:
822: hr_utility.trace('p_busy_tentative_as=' || p_busy_tentative_as);
823: hr_utility.trace('p_schedule=' || p_schedule);*/
824:
825: hr_utility.trace(' p_from_freq : '||p_from_freq);
826: hr_utility.trace(' p_to_freq: '||p_to_freq);
827: hr_utility.trace(' p_asst_std_freq: '||p_asst_std_freq);
828:
829:
830: IF g_legislation_code IS NULL THEN
823: hr_utility.trace('p_schedule=' || p_schedule);*/
824:
825: hr_utility.trace(' p_from_freq : '||p_from_freq);
826: hr_utility.trace(' p_to_freq: '||p_to_freq);
827: hr_utility.trace(' p_asst_std_freq: '||p_asst_std_freq);
828:
829:
830: IF g_legislation_code IS NULL THEN
831: hr_utility.trace('g_legislation_code is null ');
827: hr_utility.trace(' p_asst_std_freq: '||p_asst_std_freq);
828:
829:
830: IF g_legislation_code IS NULL THEN
831: hr_utility.trace('g_legislation_code is null ');
832: g_legislation_code := get_legislation_code(p_bg);
833: END IF;
834:
835: hr_utility.trace(' p_asst_std_freq: '||p_asst_std_freq);
831: hr_utility.trace('g_legislation_code is null ');
832: g_legislation_code := get_legislation_code(p_bg);
833: END IF;
834:
835: hr_utility.trace(' p_asst_std_freq: '||p_asst_std_freq);
836:
837:
838: --
839: -- If From_Freq and To_Freq are the same, then we're done.
843:
844: RETURN p_figure;
845:
846: END IF;
847: hr_utility.trace('Calling Get_Annualizing_Factor for FROM case');
848: v_from_annualizing_factor := Get_Annualizing_Factor
849: ( p_bg
850: ,p_assignment_id
851: ,p_payroll_id
858:
859:
860:
861:
862: hr_utility.trace('Calling Get_Annualizing_Factor for TO case');
863:
864: v_to_annualizing_factor := Get_Annualizing_Factor(
865: p_bg -- context
866: ,p_assignment_id -- context
875:
876: --
877: -- Annualize "Figure" and convert to To_Freq.
878: --
879: hr_utility.trace('v_from_annualizing_factor ='||to_char(v_from_annualizing_factor));
880: hr_utility.trace('v_to_annualizing_factor ='||to_char(v_to_annualizing_factor));
881:
882: IF v_to_annualizing_factor = 0 OR
883: v_to_annualizing_factor = -999 OR
876: --
877: -- Annualize "Figure" and convert to To_Freq.
878: --
879: hr_utility.trace('v_from_annualizing_factor ='||to_char(v_from_annualizing_factor));
880: hr_utility.trace('v_to_annualizing_factor ='||to_char(v_to_annualizing_factor));
881:
882: IF v_to_annualizing_factor = 0 OR
883: v_to_annualizing_factor = -999 OR
884: v_from_annualizing_factor = -999 THEN
882: IF v_to_annualizing_factor = 0 OR
883: v_to_annualizing_factor = -999 OR
884: v_from_annualizing_factor = -999 THEN
885:
886: hr_utility.trace(' v_to_ann =0 or -999 or v_from = -999');
887:
888: v_converted_figure := 0;
889: RETURN v_converted_figure;
890:
889: RETURN v_converted_figure;
890:
891: ELSE
892:
893: hr_utility.trace(' v_to_ann NOT 0 or -999 or v_from = -999');
894:
895: hr_utility.trace('p_figure Monthly Salary = '||p_figure);
896: hr_utility.trace('v_from_annualizing_factor = '||v_from_annualizing_factor);
897: hr_utility.trace('v_to_annualizing_factor = '||v_to_annualizing_factor);
891: ELSE
892:
893: hr_utility.trace(' v_to_ann NOT 0 or -999 or v_from = -999');
894:
895: hr_utility.trace('p_figure Monthly Salary = '||p_figure);
896: hr_utility.trace('v_from_annualizing_factor = '||v_from_annualizing_factor);
897: hr_utility.trace('v_to_annualizing_factor = '||v_to_annualizing_factor);
898:
899: v_converted_figure := (p_figure * v_from_annualizing_factor) / v_to_annualizing_factor;
892:
893: hr_utility.trace(' v_to_ann NOT 0 or -999 or v_from = -999');
894:
895: hr_utility.trace('p_figure Monthly Salary = '||p_figure);
896: hr_utility.trace('v_from_annualizing_factor = '||v_from_annualizing_factor);
897: hr_utility.trace('v_to_annualizing_factor = '||v_to_annualizing_factor);
898:
899: v_converted_figure := (p_figure * v_from_annualizing_factor) / v_to_annualizing_factor;
900: hr_utility.trace('conv figure is monthly_sal * ann_from div by ann to');
893: hr_utility.trace(' v_to_ann NOT 0 or -999 or v_from = -999');
894:
895: hr_utility.trace('p_figure Monthly Salary = '||p_figure);
896: hr_utility.trace('v_from_annualizing_factor = '||v_from_annualizing_factor);
897: hr_utility.trace('v_to_annualizing_factor = '||v_to_annualizing_factor);
898:
899: v_converted_figure := (p_figure * v_from_annualizing_factor) / v_to_annualizing_factor;
900: hr_utility.trace('conv figure is monthly_sal * ann_from div by ann to');
901:
896: hr_utility.trace('v_from_annualizing_factor = '||v_from_annualizing_factor);
897: hr_utility.trace('v_to_annualizing_factor = '||v_to_annualizing_factor);
898:
899: v_converted_figure := (p_figure * v_from_annualizing_factor) / v_to_annualizing_factor;
900: hr_utility.trace('conv figure is monthly_sal * ann_from div by ann to');
901:
902: hr_utility.trace('CORE UDFS v_converted_figure := '||v_converted_figure);
903:
904: END IF;
898:
899: v_converted_figure := (p_figure * v_from_annualizing_factor) / v_to_annualizing_factor;
900: hr_utility.trace('conv figure is monthly_sal * ann_from div by ann to');
901:
902: hr_utility.trace('CORE UDFS v_converted_figure := '||v_converted_figure);
903:
904: END IF;
905:
906: -- Done
953: ,lv_leg_code
954: ,lv_class_name;
955: CLOSE get_earnings_dtls;
956:
957: hr_utility.trace('ln_bg_id := ' || ln_bg_id);
958: hr_utility.trace('lv_leg_code := ' || lv_leg_code);
959: hr_utility.trace('lv_class_name := ' || lv_class_name);
960:
961: -- Changes for Bug# 7458563
954: ,lv_class_name;
955: CLOSE get_earnings_dtls;
956:
957: hr_utility.trace('ln_bg_id := ' || ln_bg_id);
958: hr_utility.trace('lv_leg_code := ' || lv_leg_code);
959: hr_utility.trace('lv_class_name := ' || lv_class_name);
960:
961: -- Changes for Bug# 7458563
962:
955: CLOSE get_earnings_dtls;
956:
957: hr_utility.trace('ln_bg_id := ' || ln_bg_id);
958: hr_utility.trace('lv_leg_code := ' || lv_leg_code);
959: hr_utility.trace('lv_class_name := ' || lv_class_name);
960:
961: -- Changes for Bug# 7458563
962:
963: open get_earning_xtra_ele_info(p_element_entry_id
965: ,p_bg);
966: fetch get_earning_xtra_ele_info into lv_ele_xtra_info;
967: close get_earning_xtra_ele_info;
968:
969: hr_utility.trace('g_legislation_code := ' || g_legislation_code);
970: hr_utility.trace('ln_regsal_ele_entry_id := ' || ln_regsal_ele_entry_id);
971: hr_utility.trace('p_element_entry_id := ' || p_element_entry_id);
972: hr_utility.trace('lv_ele_xtra_info := ' || lv_ele_xtra_info);
973:
966: fetch get_earning_xtra_ele_info into lv_ele_xtra_info;
967: close get_earning_xtra_ele_info;
968:
969: hr_utility.trace('g_legislation_code := ' || g_legislation_code);
970: hr_utility.trace('ln_regsal_ele_entry_id := ' || ln_regsal_ele_entry_id);
971: hr_utility.trace('p_element_entry_id := ' || p_element_entry_id);
972: hr_utility.trace('lv_ele_xtra_info := ' || lv_ele_xtra_info);
973:
974: -- This will Affect for Both US And Canada
967: close get_earning_xtra_ele_info;
968:
969: hr_utility.trace('g_legislation_code := ' || g_legislation_code);
970: hr_utility.trace('ln_regsal_ele_entry_id := ' || ln_regsal_ele_entry_id);
971: hr_utility.trace('p_element_entry_id := ' || p_element_entry_id);
972: hr_utility.trace('lv_ele_xtra_info := ' || lv_ele_xtra_info);
973:
974: -- This will Affect for Both US And Canada
975: -- depending on g_legislation_code
968:
969: hr_utility.trace('g_legislation_code := ' || g_legislation_code);
970: hr_utility.trace('ln_regsal_ele_entry_id := ' || ln_regsal_ele_entry_id);
971: hr_utility.trace('p_element_entry_id := ' || p_element_entry_id);
972: hr_utility.trace('lv_ele_xtra_info := ' || lv_ele_xtra_info);
973:
974: -- This will Affect for Both US And Canada
975: -- depending on g_legislation_code
976:
1022: ,p_date_earned => p_date_earned
1023: ,p_period_start => p_period_start_date
1024: ,p_period_end => p_period_start_date);
1025:
1026: hr_utility.trace('From Work Schedule l_normal_hours := '||l_normal_hours);
1027:
1028: -- In case Work Schedule is NOT defined
1029: -- If Assignment Frequency is Week
1030: -- Standard Condition will give Number of Hours per Week
1037: ,l_normal_hours;
1038: close get_asg_hours_freq;
1039: END IF;
1040:
1041: hr_utility.trace('From Standard Condition l_normal_hours := '||l_normal_hours);
1042:
1043: hr_utility.trace('p_figure := '||p_figure);
1044: hr_utility.trace('v_from_stnd_factor := '||v_from_stnd_factor);
1045:
1039: END IF;
1040:
1041: hr_utility.trace('From Standard Condition l_normal_hours := '||l_normal_hours);
1042:
1043: hr_utility.trace('p_figure := '||p_figure);
1044: hr_utility.trace('v_from_stnd_factor := '||v_from_stnd_factor);
1045:
1046: -- Following Condition will Arrive If NO Work Schedule Defined
1047: -- Or, Work Schedule User Table does NOT have
1040:
1041: hr_utility.trace('From Standard Condition l_normal_hours := '||l_normal_hours);
1042:
1043: hr_utility.trace('p_figure := '||p_figure);
1044: hr_utility.trace('v_from_stnd_factor := '||v_from_stnd_factor);
1045:
1046: -- Following Condition will Arrive If NO Work Schedule Defined
1047: -- Or, Work Schedule User Table does NOT have
1048: -- "Days of the Week / Standard Hours Worked" Structure
1057: END IF;
1058:
1059: v_converted_figure :=(p_figure * v_from_stnd_factor/(52 * l_normal_hours ));
1060:
1061: hr_utility.trace('v_converted_figure := '||v_converted_figure);
1062: END IF;
1063: END IF;
1064:
1065: -- End Changes for Bug# 6163428
1201:
1202: --p_wsched := 'NOT ENTERED';
1203: v_prorated_earn := 0;
1204:
1205: hr_utility.trace('UDFS Entered Prorate Earnings');
1206: hr_utility.trace('p_bg_id ='||to_char(p_bg_id));
1207: hr_utility.trace('p_asg_hrly_rate ='||to_char(p_asg_hrly_rate));
1208: -- hr_utility.trace('p_wsched ='||p_wsched);
1209: -- hr_utility.trace('p_asg_std_hours ='||to_char(p_asg_std_hours));
1202: --p_wsched := 'NOT ENTERED';
1203: v_prorated_earn := 0;
1204:
1205: hr_utility.trace('UDFS Entered Prorate Earnings');
1206: hr_utility.trace('p_bg_id ='||to_char(p_bg_id));
1207: hr_utility.trace('p_asg_hrly_rate ='||to_char(p_asg_hrly_rate));
1208: -- hr_utility.trace('p_wsched ='||p_wsched);
1209: -- hr_utility.trace('p_asg_std_hours ='||to_char(p_asg_std_hours));
1210: -- hr_utility.trace('p_asg_std_freq ='||p_asg_std_freq);
1203: v_prorated_earn := 0;
1204:
1205: hr_utility.trace('UDFS Entered Prorate Earnings');
1206: hr_utility.trace('p_bg_id ='||to_char(p_bg_id));
1207: hr_utility.trace('p_asg_hrly_rate ='||to_char(p_asg_hrly_rate));
1208: -- hr_utility.trace('p_wsched ='||p_wsched);
1209: -- hr_utility.trace('p_asg_std_hours ='||to_char(p_asg_std_hours));
1210: -- hr_utility.trace('p_asg_std_freq ='||p_asg_std_freq);
1211: hr_utility.trace('UDFS p_range_start_date ='||to_char(p_range_start_date));
1204:
1205: hr_utility.trace('UDFS Entered Prorate Earnings');
1206: hr_utility.trace('p_bg_id ='||to_char(p_bg_id));
1207: hr_utility.trace('p_asg_hrly_rate ='||to_char(p_asg_hrly_rate));
1208: -- hr_utility.trace('p_wsched ='||p_wsched);
1209: -- hr_utility.trace('p_asg_std_hours ='||to_char(p_asg_std_hours));
1210: -- hr_utility.trace('p_asg_std_freq ='||p_asg_std_freq);
1211: hr_utility.trace('UDFS p_range_start_date ='||to_char(p_range_start_date));
1212: hr_utility.trace('UDFS p_range_end_date ='||to_char(p_range_end_date));
1205: hr_utility.trace('UDFS Entered Prorate Earnings');
1206: hr_utility.trace('p_bg_id ='||to_char(p_bg_id));
1207: hr_utility.trace('p_asg_hrly_rate ='||to_char(p_asg_hrly_rate));
1208: -- hr_utility.trace('p_wsched ='||p_wsched);
1209: -- hr_utility.trace('p_asg_std_hours ='||to_char(p_asg_std_hours));
1210: -- hr_utility.trace('p_asg_std_freq ='||p_asg_std_freq);
1211: hr_utility.trace('UDFS p_range_start_date ='||to_char(p_range_start_date));
1212: hr_utility.trace('UDFS p_range_end_date ='||to_char(p_range_end_date));
1213: hr_utility.trace('p_act_hrs_worked ='||to_char(p_act_hrs_worked));
1206: hr_utility.trace('p_bg_id ='||to_char(p_bg_id));
1207: hr_utility.trace('p_asg_hrly_rate ='||to_char(p_asg_hrly_rate));
1208: -- hr_utility.trace('p_wsched ='||p_wsched);
1209: -- hr_utility.trace('p_asg_std_hours ='||to_char(p_asg_std_hours));
1210: -- hr_utility.trace('p_asg_std_freq ='||p_asg_std_freq);
1211: hr_utility.trace('UDFS p_range_start_date ='||to_char(p_range_start_date));
1212: hr_utility.trace('UDFS p_range_end_date ='||to_char(p_range_end_date));
1213: hr_utility.trace('p_act_hrs_worked ='||to_char(p_act_hrs_worked));
1214:
1207: hr_utility.trace('p_asg_hrly_rate ='||to_char(p_asg_hrly_rate));
1208: -- hr_utility.trace('p_wsched ='||p_wsched);
1209: -- hr_utility.trace('p_asg_std_hours ='||to_char(p_asg_std_hours));
1210: -- hr_utility.trace('p_asg_std_freq ='||p_asg_std_freq);
1211: hr_utility.trace('UDFS p_range_start_date ='||to_char(p_range_start_date));
1212: hr_utility.trace('UDFS p_range_end_date ='||to_char(p_range_end_date));
1213: hr_utility.trace('p_act_hrs_worked ='||to_char(p_act_hrs_worked));
1214:
1215: -- Prorate using hourly rate passed in as param:
1208: -- hr_utility.trace('p_wsched ='||p_wsched);
1209: -- hr_utility.trace('p_asg_std_hours ='||to_char(p_asg_std_hours));
1210: -- hr_utility.trace('p_asg_std_freq ='||p_asg_std_freq);
1211: hr_utility.trace('UDFS p_range_start_date ='||to_char(p_range_start_date));
1212: hr_utility.trace('UDFS p_range_end_date ='||to_char(p_range_end_date));
1213: hr_utility.trace('p_act_hrs_worked ='||to_char(p_act_hrs_worked));
1214:
1215: -- Prorate using hourly rate passed in as param:
1216:
1209: -- hr_utility.trace('p_asg_std_hours ='||to_char(p_asg_std_hours));
1210: -- hr_utility.trace('p_asg_std_freq ='||p_asg_std_freq);
1211: hr_utility.trace('UDFS p_range_start_date ='||to_char(p_range_start_date));
1212: hr_utility.trace('UDFS p_range_end_date ='||to_char(p_range_end_date));
1213: hr_utility.trace('p_act_hrs_worked ='||to_char(p_act_hrs_worked));
1214:
1215: -- Prorate using hourly rate passed in as param:
1216:
1217: /*
1216:
1217: /*
1218: IF UPPER(p_wsched) = 'NOT ENTERED' THEN
1219:
1220: hr_utility.set_location('Prorate_Earnings', 7);
1221: hr_utility.trace('p_wsched NOT ENTERED');
1222: hr_utility.trace('Calling Standard Hours Worked');
1223:
1224: v_hours_in_range := Standard_Hours_Worked( p_asg_std_hours,
1217: /*
1218: IF UPPER(p_wsched) = 'NOT ENTERED' THEN
1219:
1220: hr_utility.set_location('Prorate_Earnings', 7);
1221: hr_utility.trace('p_wsched NOT ENTERED');
1222: hr_utility.trace('Calling Standard Hours Worked');
1223:
1224: v_hours_in_range := Standard_Hours_Worked( p_asg_std_hours,
1225: p_range_start_date,
1218: IF UPPER(p_wsched) = 'NOT ENTERED' THEN
1219:
1220: hr_utility.set_location('Prorate_Earnings', 7);
1221: hr_utility.trace('p_wsched NOT ENTERED');
1222: hr_utility.trace('Calling Standard Hours Worked');
1223:
1224: v_hours_in_range := Standard_Hours_Worked( p_asg_std_hours,
1225: p_range_start_date,
1226: p_range_end_date,
1226: p_range_end_date,
1227: p_asg_std_freq);
1228:
1229: -- Keep running total of ACTUAL hours worked.
1230: hr_utility.set_location('Prorate_Earnings', 11);
1231:
1232: hr_utility.trace('Keep running total of ACTUAL hours worked');
1233:
1234: hr_utility.trace('actual_hours_worked before call= '||
1228:
1229: -- Keep running total of ACTUAL hours worked.
1230: hr_utility.set_location('Prorate_Earnings', 11);
1231:
1232: hr_utility.trace('Keep running total of ACTUAL hours worked');
1233:
1234: hr_utility.trace('actual_hours_worked before call= '||
1235: to_char(p_act_hrs_worked));
1236: hr_utility.trace('v_hours_in_range in current call= '||
1230: hr_utility.set_location('Prorate_Earnings', 11);
1231:
1232: hr_utility.trace('Keep running total of ACTUAL hours worked');
1233:
1234: hr_utility.trace('actual_hours_worked before call= '||
1235: to_char(p_act_hrs_worked));
1236: hr_utility.trace('v_hours_in_range in current call= '||
1237: to_char(v_hours_in_range));
1238:
1232: hr_utility.trace('Keep running total of ACTUAL hours worked');
1233:
1234: hr_utility.trace('actual_hours_worked before call= '||
1235: to_char(p_act_hrs_worked));
1236: hr_utility.trace('v_hours_in_range in current call= '||
1237: to_char(v_hours_in_range));
1238:
1239: p_act_hrs_worked := p_act_hrs_worked + v_hours_in_range;
1240:
1237: to_char(v_hours_in_range));
1238:
1239: p_act_hrs_worked := p_act_hrs_worked + v_hours_in_range;
1240:
1241: hr_utility.trace('UDFS actual_hours_worked after call = '||
1242: to_char(p_act_hrs_worked));
1243:
1244: ELSE
1245:
1242: to_char(p_act_hrs_worked));
1243:
1244: ELSE
1245:
1246: hr_utility.set_location('Prorate_Earnings', 17);
1247: hr_utility.trace('Entered WORK SCHEDULE');
1248:
1249: hr_utility.trace('Getting WORK SCHEDULE Name');
1250:
1243:
1244: ELSE
1245:
1246: hr_utility.set_location('Prorate_Earnings', 17);
1247: hr_utility.trace('Entered WORK SCHEDULE');
1248:
1249: hr_utility.trace('Getting WORK SCHEDULE Name');
1250:
1251: -- Get work schedule name:
1245:
1246: hr_utility.set_location('Prorate_Earnings', 17);
1247: hr_utility.trace('Entered WORK SCHEDULE');
1248:
1249: hr_utility.trace('Getting WORK SCHEDULE Name');
1250:
1251: -- Get work schedule name:
1252:
1253: v_ws_id := fnd_number.canonical_to_number(p_wsched);
1251: -- Get work schedule name:
1252:
1253: v_ws_id := fnd_number.canonical_to_number(p_wsched);
1254:
1255: hr_utility.trace('v_ws_id ='||to_char(v_ws_id));
1256:
1257: SELECT user_column_name
1258: INTO v_ws_name
1259: FROM pay_user_columns
1260: WHERE user_column_id = v_ws_id
1261: AND NVL(business_group_id, p_bg_id) = p_bg_id
1262: AND NVL(legislation_code,'US') = 'US';
1263:
1264: hr_utility.trace('v_ws_name ='||v_ws_name );
1265: hr_utility.trace('Calling Work_Schedule_Total_Hours');
1266:
1267: v_hours_in_range := Work_Schedule_Total_Hours(
1268: p_bg_id,
1261: AND NVL(business_group_id, p_bg_id) = p_bg_id
1262: AND NVL(legislation_code,'US') = 'US';
1263:
1264: hr_utility.trace('v_ws_name ='||v_ws_name );
1265: hr_utility.trace('Calling Work_Schedule_Total_Hours');
1266:
1267: v_hours_in_range := Work_Schedule_Total_Hours(
1268: p_bg_id,
1269: v_ws_name,
1270: p_range_start_date,
1271: p_range_end_date);
1272:
1273: p_act_hrs_worked := p_act_hrs_worked + v_hours_in_range;
1274: hr_utility.trace('v_hours_in_range = '||to_char(v_hours_in_range));
1275:
1276: END IF; -- Hours in date range via work schedule or std hours.
1277: */
1278:
1276: END IF; -- Hours in date range via work schedule or std hours.
1277: */
1278:
1279:
1280: hr_utility.trace('calling PAY_CORE_FF_UDFS.calculate_actual_hours_worked');
1281: v_hours_in_range := pay_core_ff_udfs.calculate_actual_hours_worked (
1282: null
1283: ,p_asst_id
1284: ,p_bus_grp_id
1295: ,v_return_status
1296: ,v_return_message);
1297:
1298: p_act_hrs_worked := p_act_hrs_worked + v_hours_in_range;
1299: hr_utility.trace('v_hours_in_range = '||to_char(v_hours_in_range));
1300:
1301:
1302: hr_utility.trace('v_prorated_earnings = p_asg_hrly_rate * v_hours_in_range');
1303:
1298: p_act_hrs_worked := p_act_hrs_worked + v_hours_in_range;
1299: hr_utility.trace('v_hours_in_range = '||to_char(v_hours_in_range));
1300:
1301:
1302: hr_utility.trace('v_prorated_earnings = p_asg_hrly_rate * v_hours_in_range');
1303:
1304:
1305: hr_utility.trace('v_prorated_earnings = p_asg_hrly_rate * v_hours_in_range');
1306:
1301:
1302: hr_utility.trace('v_prorated_earnings = p_asg_hrly_rate * v_hours_in_range');
1303:
1304:
1305: hr_utility.trace('v_prorated_earnings = p_asg_hrly_rate * v_hours_in_range');
1306:
1307: v_prorated_earn := v_prorated_earn + (p_asg_hrly_rate * v_hours_in_range);
1308:
1309: hr_utility.trace('UDFS final v_prorated_earnings = '||to_char(v_prorated_earn));
1305: hr_utility.trace('v_prorated_earnings = p_asg_hrly_rate * v_hours_in_range');
1306:
1307: v_prorated_earn := v_prorated_earn + (p_asg_hrly_rate * v_hours_in_range);
1308:
1309: hr_utility.trace('UDFS final v_prorated_earnings = '||to_char(v_prorated_earn));
1310: hr_utility.set_location('Prorate_Earnings', 97);
1311: p_act_hrs_worked := ROUND(p_act_hrs_worked, 3);
1312: hr_utility.trace('p_act_hrs_worked ='||to_char(p_act_hrs_worked));
1313: hr_utility.trace('UDFS Leaving Prorated Earnings');
1306:
1307: v_prorated_earn := v_prorated_earn + (p_asg_hrly_rate * v_hours_in_range);
1308:
1309: hr_utility.trace('UDFS final v_prorated_earnings = '||to_char(v_prorated_earn));
1310: hr_utility.set_location('Prorate_Earnings', 97);
1311: p_act_hrs_worked := ROUND(p_act_hrs_worked, 3);
1312: hr_utility.trace('p_act_hrs_worked ='||to_char(p_act_hrs_worked));
1313: hr_utility.trace('UDFS Leaving Prorated Earnings');
1314:
1308:
1309: hr_utility.trace('UDFS final v_prorated_earnings = '||to_char(v_prorated_earn));
1310: hr_utility.set_location('Prorate_Earnings', 97);
1311: p_act_hrs_worked := ROUND(p_act_hrs_worked, 3);
1312: hr_utility.trace('p_act_hrs_worked ='||to_char(p_act_hrs_worked));
1313: hr_utility.trace('UDFS Leaving Prorated Earnings');
1314:
1315: RETURN v_prorated_earn;
1316:
1309: hr_utility.trace('UDFS final v_prorated_earnings = '||to_char(v_prorated_earn));
1310: hr_utility.set_location('Prorate_Earnings', 97);
1311: p_act_hrs_worked := ROUND(p_act_hrs_worked, 3);
1312: hr_utility.trace('p_act_hrs_worked ='||to_char(p_act_hrs_worked));
1313: hr_utility.trace('UDFS Leaving Prorated Earnings');
1314:
1315: RETURN v_prorated_earn;
1316:
1317: END Prorate_Earnings;
1365: --p_work_sched := 'NOT ENTERED';
1366: v_eev_prorated_earnings := 0;
1367:
1368:
1369: hr_utility.trace('UDFS Entering PRORATE_EEV');
1370: hr_utility.trace('p_bus_group_id ='||to_char(p_bus_group_id));
1371: hr_utility.trace('p_pay_id ='||to_char(p_pay_id));
1372: -- hr_utility.trace('p_work_sched ='||p_work_sched);
1373: --hr_utility.trace('p_asg_std_hrs ='||to_char(p_asg_std_hrs));
1366: v_eev_prorated_earnings := 0;
1367:
1368:
1369: hr_utility.trace('UDFS Entering PRORATE_EEV');
1370: hr_utility.trace('p_bus_group_id ='||to_char(p_bus_group_id));
1371: hr_utility.trace('p_pay_id ='||to_char(p_pay_id));
1372: -- hr_utility.trace('p_work_sched ='||p_work_sched);
1373: --hr_utility.trace('p_asg_std_hrs ='||to_char(p_asg_std_hrs));
1374: -- hr_utility.trace('p_asg_std_freq ='||p_asg_std_freq);
1367:
1368:
1369: hr_utility.trace('UDFS Entering PRORATE_EEV');
1370: hr_utility.trace('p_bus_group_id ='||to_char(p_bus_group_id));
1371: hr_utility.trace('p_pay_id ='||to_char(p_pay_id));
1372: -- hr_utility.trace('p_work_sched ='||p_work_sched);
1373: --hr_utility.trace('p_asg_std_hrs ='||to_char(p_asg_std_hrs));
1374: -- hr_utility.trace('p_asg_std_freq ='||p_asg_std_freq);
1375: hr_utility.trace('p_pay_basis ='||p_pay_basis);
1368:
1369: hr_utility.trace('UDFS Entering PRORATE_EEV');
1370: hr_utility.trace('p_bus_group_id ='||to_char(p_bus_group_id));
1371: hr_utility.trace('p_pay_id ='||to_char(p_pay_id));
1372: -- hr_utility.trace('p_work_sched ='||p_work_sched);
1373: --hr_utility.trace('p_asg_std_hrs ='||to_char(p_asg_std_hrs));
1374: -- hr_utility.trace('p_asg_std_freq ='||p_asg_std_freq);
1375: hr_utility.trace('p_pay_basis ='||p_pay_basis);
1376: hr_utility.trace('p_hrly_rate ='||to_char(p_hrly_rate));
1369: hr_utility.trace('UDFS Entering PRORATE_EEV');
1370: hr_utility.trace('p_bus_group_id ='||to_char(p_bus_group_id));
1371: hr_utility.trace('p_pay_id ='||to_char(p_pay_id));
1372: -- hr_utility.trace('p_work_sched ='||p_work_sched);
1373: --hr_utility.trace('p_asg_std_hrs ='||to_char(p_asg_std_hrs));
1374: -- hr_utility.trace('p_asg_std_freq ='||p_asg_std_freq);
1375: hr_utility.trace('p_pay_basis ='||p_pay_basis);
1376: hr_utility.trace('p_hrly_rate ='||to_char(p_hrly_rate));
1377: hr_utility.trace('UDFS p_range_start_date ='||to_char(p_range_start_date));
1370: hr_utility.trace('p_bus_group_id ='||to_char(p_bus_group_id));
1371: hr_utility.trace('p_pay_id ='||to_char(p_pay_id));
1372: -- hr_utility.trace('p_work_sched ='||p_work_sched);
1373: --hr_utility.trace('p_asg_std_hrs ='||to_char(p_asg_std_hrs));
1374: -- hr_utility.trace('p_asg_std_freq ='||p_asg_std_freq);
1375: hr_utility.trace('p_pay_basis ='||p_pay_basis);
1376: hr_utility.trace('p_hrly_rate ='||to_char(p_hrly_rate));
1377: hr_utility.trace('UDFS p_range_start_date ='||to_char(p_range_start_date));
1378: hr_utility.trace('UDFS p_range_end_date ='||to_char(p_range_end_date));
1371: hr_utility.trace('p_pay_id ='||to_char(p_pay_id));
1372: -- hr_utility.trace('p_work_sched ='||p_work_sched);
1373: --hr_utility.trace('p_asg_std_hrs ='||to_char(p_asg_std_hrs));
1374: -- hr_utility.trace('p_asg_std_freq ='||p_asg_std_freq);
1375: hr_utility.trace('p_pay_basis ='||p_pay_basis);
1376: hr_utility.trace('p_hrly_rate ='||to_char(p_hrly_rate));
1377: hr_utility.trace('UDFS p_range_start_date ='||to_char(p_range_start_date));
1378: hr_utility.trace('UDFS p_range_end_date ='||to_char(p_range_end_date));
1379: hr_utility.trace('p_actual_hrs_worked ='||to_char(p_actual_hrs_worked));
1372: -- hr_utility.trace('p_work_sched ='||p_work_sched);
1373: --hr_utility.trace('p_asg_std_hrs ='||to_char(p_asg_std_hrs));
1374: -- hr_utility.trace('p_asg_std_freq ='||p_asg_std_freq);
1375: hr_utility.trace('p_pay_basis ='||p_pay_basis);
1376: hr_utility.trace('p_hrly_rate ='||to_char(p_hrly_rate));
1377: hr_utility.trace('UDFS p_range_start_date ='||to_char(p_range_start_date));
1378: hr_utility.trace('UDFS p_range_end_date ='||to_char(p_range_end_date));
1379: hr_utility.trace('p_actual_hrs_worked ='||to_char(p_actual_hrs_worked));
1380: hr_utility.trace('p_element_entry_id ='||to_char(p_element_entry_id));
1373: --hr_utility.trace('p_asg_std_hrs ='||to_char(p_asg_std_hrs));
1374: -- hr_utility.trace('p_asg_std_freq ='||p_asg_std_freq);
1375: hr_utility.trace('p_pay_basis ='||p_pay_basis);
1376: hr_utility.trace('p_hrly_rate ='||to_char(p_hrly_rate));
1377: hr_utility.trace('UDFS p_range_start_date ='||to_char(p_range_start_date));
1378: hr_utility.trace('UDFS p_range_end_date ='||to_char(p_range_end_date));
1379: hr_utility.trace('p_actual_hrs_worked ='||to_char(p_actual_hrs_worked));
1380: hr_utility.trace('p_element_entry_id ='||to_char(p_element_entry_id));
1381: hr_utility.trace('p_inpval_id ='||to_char(p_inpval_id));
1374: -- hr_utility.trace('p_asg_std_freq ='||p_asg_std_freq);
1375: hr_utility.trace('p_pay_basis ='||p_pay_basis);
1376: hr_utility.trace('p_hrly_rate ='||to_char(p_hrly_rate));
1377: hr_utility.trace('UDFS p_range_start_date ='||to_char(p_range_start_date));
1378: hr_utility.trace('UDFS p_range_end_date ='||to_char(p_range_end_date));
1379: hr_utility.trace('p_actual_hrs_worked ='||to_char(p_actual_hrs_worked));
1380: hr_utility.trace('p_element_entry_id ='||to_char(p_element_entry_id));
1381: hr_utility.trace('p_inpval_id ='||to_char(p_inpval_id));
1382: --
1375: hr_utility.trace('p_pay_basis ='||p_pay_basis);
1376: hr_utility.trace('p_hrly_rate ='||to_char(p_hrly_rate));
1377: hr_utility.trace('UDFS p_range_start_date ='||to_char(p_range_start_date));
1378: hr_utility.trace('UDFS p_range_end_date ='||to_char(p_range_end_date));
1379: hr_utility.trace('p_actual_hrs_worked ='||to_char(p_actual_hrs_worked));
1380: hr_utility.trace('p_element_entry_id ='||to_char(p_element_entry_id));
1381: hr_utility.trace('p_inpval_id ='||to_char(p_inpval_id));
1382: --
1383: -- Find all EEV changes, calculate new hourly rate, prorate:
1376: hr_utility.trace('p_hrly_rate ='||to_char(p_hrly_rate));
1377: hr_utility.trace('UDFS p_range_start_date ='||to_char(p_range_start_date));
1378: hr_utility.trace('UDFS p_range_end_date ='||to_char(p_range_end_date));
1379: hr_utility.trace('p_actual_hrs_worked ='||to_char(p_actual_hrs_worked));
1380: hr_utility.trace('p_element_entry_id ='||to_char(p_element_entry_id));
1381: hr_utility.trace('p_inpval_id ='||to_char(p_inpval_id));
1382: --
1383: -- Find all EEV changes, calculate new hourly rate, prorate:
1384: -- SELECT (EEV1):
1377: hr_utility.trace('UDFS p_range_start_date ='||to_char(p_range_start_date));
1378: hr_utility.trace('UDFS p_range_end_date ='||to_char(p_range_end_date));
1379: hr_utility.trace('p_actual_hrs_worked ='||to_char(p_actual_hrs_worked));
1380: hr_utility.trace('p_element_entry_id ='||to_char(p_element_entry_id));
1381: hr_utility.trace('p_inpval_id ='||to_char(p_inpval_id));
1382: --
1383: -- Find all EEV changes, calculate new hourly rate, prorate:
1384: -- SELECT (EEV1):
1385: -- Select for SINGLE record that includes Period Start Date but does not
1386: -- span entire period.
1387: -- We know this select will return a row, otherwise there would be no
1388: -- EEV changes to detect.
1389: --
1390: hr_utility.set_location('Prorate_EEV', 103);
1391: SELECT EEV.screen_entry_value,
1392: GREATEST(EEV.effective_start_date, p_range_start_date),
1393: EEV.effective_end_date
1394: INTO v_earnings_entry,
1401: AND EEV.effective_end_date >= p_range_start_date
1402: AND EEV.effective_end_date < p_range_end_date;
1403:
1404:
1405: hr_utility.trace('screen_entry_value ='||v_earnings_entry);
1406: hr_utility.trace('v_entry_start ='||to_char(v_entry_start));
1407: hr_utility.trace('v_entry_end ='||to_char(v_entry_end));
1408: hr_utility.trace('Calling Convert_Period_Type ');
1409: hr_utility.set_location('Prorate_EEV', 105);
1402: AND EEV.effective_end_date < p_range_end_date;
1403:
1404:
1405: hr_utility.trace('screen_entry_value ='||v_earnings_entry);
1406: hr_utility.trace('v_entry_start ='||to_char(v_entry_start));
1407: hr_utility.trace('v_entry_end ='||to_char(v_entry_end));
1408: hr_utility.trace('Calling Convert_Period_Type ');
1409: hr_utility.set_location('Prorate_EEV', 105);
1410:
1403:
1404:
1405: hr_utility.trace('screen_entry_value ='||v_earnings_entry);
1406: hr_utility.trace('v_entry_start ='||to_char(v_entry_start));
1407: hr_utility.trace('v_entry_end ='||to_char(v_entry_end));
1408: hr_utility.trace('Calling Convert_Period_Type ');
1409: hr_utility.set_location('Prorate_EEV', 105);
1410:
1411: v_curr_hrly_rate := Convert_Period_Type(p_bus_grp_id
1404:
1405: hr_utility.trace('screen_entry_value ='||v_earnings_entry);
1406: hr_utility.trace('v_entry_start ='||to_char(v_entry_start));
1407: hr_utility.trace('v_entry_end ='||to_char(v_entry_end));
1408: hr_utility.trace('Calling Convert_Period_Type ');
1409: hr_utility.set_location('Prorate_EEV', 105);
1410:
1411: v_curr_hrly_rate := Convert_Period_Type(p_bus_grp_id
1412: ,p_asst_id
1405: hr_utility.trace('screen_entry_value ='||v_earnings_entry);
1406: hr_utility.trace('v_entry_start ='||to_char(v_entry_start));
1407: hr_utility.trace('v_entry_end ='||to_char(v_entry_end));
1408: hr_utility.trace('Calling Convert_Period_Type ');
1409: hr_utility.set_location('Prorate_EEV', 105);
1410:
1411: v_curr_hrly_rate := Convert_Period_Type(p_bus_grp_id
1412: ,p_asst_id
1413: ,p_payroll_id
1438: 'HOURLY',
1439: p_period_start,
1440: p_period_end,
1441: p_asg_std_freq); */
1442: hr_utility.trace('v_curr_hrly_rate ='||to_char(v_curr_hrly_rate));
1443: hr_utility.set_location('Prorate_EEV', 107);
1444:
1445: v_eev_prorated_earnings := v_eev_prorated_earnings +
1446: Prorate_Earnings (
1439: p_period_start,
1440: p_period_end,
1441: p_asg_std_freq); */
1442: hr_utility.trace('v_curr_hrly_rate ='||to_char(v_curr_hrly_rate));
1443: hr_utility.set_location('Prorate_EEV', 107);
1444:
1445: v_eev_prorated_earnings := v_eev_prorated_earnings +
1446: Prorate_Earnings (
1447: p_bg_id => p_bus_group_id,
1449: p_range_start_date => v_entry_start,
1450: p_range_end_date => v_entry_end,
1451: p_act_hrs_worked => p_actual_hrs_worked);
1452:
1453: hr_utility.trace('v_eev_prorated_earnings ='||
1454: to_char(v_eev_prorated_earnings));
1455: -- SELECT (EEV2):
1456: hr_utility.trace('Opening get_entry_chgs cursor EEV2');
1457:
1452:
1453: hr_utility.trace('v_eev_prorated_earnings ='||
1454: to_char(v_eev_prorated_earnings));
1455: -- SELECT (EEV2):
1456: hr_utility.trace('Opening get_entry_chgs cursor EEV2');
1457:
1458: OPEN get_entry_chgs (p_range_start_date, p_range_end_date);
1459: LOOP
1460: --
1463: v_entry_start,
1464: v_entry_end;
1465: EXIT WHEN get_entry_chgs%NOTFOUND;
1466: --
1467: hr_utility.trace('v_earnings_entry ='||v_earnings_entry);
1468: hr_utility.trace('v_entry_start ='||to_char(v_entry_start));
1469: hr_utility.trace('v_entry_end ='||to_char(v_entry_end));
1470: hr_utility.set_location('Prorate_EEV', 115);
1471: --
1464: v_entry_end;
1465: EXIT WHEN get_entry_chgs%NOTFOUND;
1466: --
1467: hr_utility.trace('v_earnings_entry ='||v_earnings_entry);
1468: hr_utility.trace('v_entry_start ='||to_char(v_entry_start));
1469: hr_utility.trace('v_entry_end ='||to_char(v_entry_end));
1470: hr_utility.set_location('Prorate_EEV', 115);
1471: --
1472: -- For each range of dates found, add to running prorated earnings total.
1465: EXIT WHEN get_entry_chgs%NOTFOUND;
1466: --
1467: hr_utility.trace('v_earnings_entry ='||v_earnings_entry);
1468: hr_utility.trace('v_entry_start ='||to_char(v_entry_start));
1469: hr_utility.trace('v_entry_end ='||to_char(v_entry_end));
1470: hr_utility.set_location('Prorate_EEV', 115);
1471: --
1472: -- For each range of dates found, add to running prorated earnings total.
1473: --
1466: --
1467: hr_utility.trace('v_earnings_entry ='||v_earnings_entry);
1468: hr_utility.trace('v_entry_start ='||to_char(v_entry_start));
1469: hr_utility.trace('v_entry_end ='||to_char(v_entry_end));
1470: hr_utility.set_location('Prorate_EEV', 115);
1471: --
1472: -- For each range of dates found, add to running prorated earnings total.
1473: --
1474: hr_utility.trace('Calling Convert_Period_Type ');
1470: hr_utility.set_location('Prorate_EEV', 115);
1471: --
1472: -- For each range of dates found, add to running prorated earnings total.
1473: --
1474: hr_utility.trace('Calling Convert_Period_Type ');
1475:
1476: v_curr_hrly_rate := Convert_Period_Type(p_bus_grp_id
1477: ,p_asst_id
1478: ,p_payroll_id
1496: p_period_end,
1497: p_asg_std_freq); */
1498:
1499:
1500: hr_utility.trace('v_curr_hrly_rate ='||to_char(v_curr_hrly_rate));
1501: hr_utility.set_location('Prorate_EEV', 119);
1502: v_eev_prorated_earnings := v_eev_prorated_earnings +
1503: Prorate_Earnings (
1504: p_bg_id => p_bus_group_id,
1497: p_asg_std_freq); */
1498:
1499:
1500: hr_utility.trace('v_curr_hrly_rate ='||to_char(v_curr_hrly_rate));
1501: hr_utility.set_location('Prorate_EEV', 119);
1502: v_eev_prorated_earnings := v_eev_prorated_earnings +
1503: Prorate_Earnings (
1504: p_bg_id => p_bus_group_id,
1505: p_asg_hrly_rate => v_curr_hrly_rate,
1506: p_range_start_date => v_entry_start,
1507: p_range_end_date => v_entry_end,
1508: p_act_hrs_worked => p_actual_hrs_worked);
1509:
1510: hr_utility.trace('v_eev_prorated_earnings ='||to_char(v_eev_prorated_earnings));
1511:
1512: END LOOP;
1513: --
1514: CLOSE get_entry_chgs;
1517: -- Select for SINGLE record that exists across Period End Date:
1518: -- NOTE: Will only return a row if select (2) does not return a row where
1519: -- Effective End Date = Period End Date !
1520:
1521: hr_utility.trace('Select EEV3');
1522: hr_utility.set_location('Prorate_EEV', 141);
1523: SELECT EEV.screen_entry_value,
1524: EEV.effective_start_date,
1525: LEAST(EEV.effective_end_date, p_range_end_date)
1518: -- NOTE: Will only return a row if select (2) does not return a row where
1519: -- Effective End Date = Period End Date !
1520:
1521: hr_utility.trace('Select EEV3');
1522: hr_utility.set_location('Prorate_EEV', 141);
1523: SELECT EEV.screen_entry_value,
1524: EEV.effective_start_date,
1525: LEAST(EEV.effective_end_date, p_range_end_date)
1526: INTO v_earnings_entry,
1531: AND EEV.input_value_id = p_inpval_id
1532: AND EEV.effective_start_date > p_range_start_date
1533: AND EEV.effective_start_date <= p_range_end_date
1534: AND EEV.effective_end_date > p_range_end_date;
1535: hr_utility.set_location('Prorate_EEV', 147);
1536: hr_utility.trace('screen_entry_value ='||v_earnings_entry);
1537: hr_utility.trace('v_entry_start ='||to_char(v_entry_start));
1538: hr_utility.trace('v_entry_end ='||to_char(v_entry_end));
1539:
1532: AND EEV.effective_start_date > p_range_start_date
1533: AND EEV.effective_start_date <= p_range_end_date
1534: AND EEV.effective_end_date > p_range_end_date;
1535: hr_utility.set_location('Prorate_EEV', 147);
1536: hr_utility.trace('screen_entry_value ='||v_earnings_entry);
1537: hr_utility.trace('v_entry_start ='||to_char(v_entry_start));
1538: hr_utility.trace('v_entry_end ='||to_char(v_entry_end));
1539:
1540: hr_utility.trace('Calling Convert_Period_Type ');
1533: AND EEV.effective_start_date <= p_range_end_date
1534: AND EEV.effective_end_date > p_range_end_date;
1535: hr_utility.set_location('Prorate_EEV', 147);
1536: hr_utility.trace('screen_entry_value ='||v_earnings_entry);
1537: hr_utility.trace('v_entry_start ='||to_char(v_entry_start));
1538: hr_utility.trace('v_entry_end ='||to_char(v_entry_end));
1539:
1540: hr_utility.trace('Calling Convert_Period_Type ');
1541:
1534: AND EEV.effective_end_date > p_range_end_date;
1535: hr_utility.set_location('Prorate_EEV', 147);
1536: hr_utility.trace('screen_entry_value ='||v_earnings_entry);
1537: hr_utility.trace('v_entry_start ='||to_char(v_entry_start));
1538: hr_utility.trace('v_entry_end ='||to_char(v_entry_end));
1539:
1540: hr_utility.trace('Calling Convert_Period_Type ');
1541:
1542: v_curr_hrly_rate := Convert_Period_Type(p_bus_grp_id
1536: hr_utility.trace('screen_entry_value ='||v_earnings_entry);
1537: hr_utility.trace('v_entry_start ='||to_char(v_entry_start));
1538: hr_utility.trace('v_entry_end ='||to_char(v_entry_end));
1539:
1540: hr_utility.trace('Calling Convert_Period_Type ');
1541:
1542: v_curr_hrly_rate := Convert_Period_Type(p_bus_grp_id
1543: ,p_asst_id
1544: ,p_payroll_id
1560: p_period_start,
1561: p_period_end,
1562: p_asg_std_freq);
1563: */
1564: hr_utility.set_location('Prorate_EEV', 151);
1565: hr_utility.trace('After Call v_curr_hrly_rate ='||to_char(v_curr_hrly_rate));
1566:
1567: v_eev_prorated_earnings := v_eev_prorated_earnings +
1568: Prorate_Earnings (
1561: p_period_end,
1562: p_asg_std_freq);
1563: */
1564: hr_utility.set_location('Prorate_EEV', 151);
1565: hr_utility.trace('After Call v_curr_hrly_rate ='||to_char(v_curr_hrly_rate));
1566:
1567: v_eev_prorated_earnings := v_eev_prorated_earnings +
1568: Prorate_Earnings (
1569: p_bg_id => p_bus_group_id,
1572: p_range_end_date => v_entry_end,
1573: p_act_hrs_worked => p_actual_hrs_worked);
1574:
1575: -- We're Done!
1576: hr_utility.trace('v_eev_prorated_earnings ='||
1577: to_char(v_eev_prorated_earnings));
1578: hr_utility.set_location('Prorate_EEV', 167);
1579: p_actual_hrs_worked := ROUND(p_actual_hrs_worked, 3);
1580: p_hrly_rate := v_curr_hrly_rate;
1574:
1575: -- We're Done!
1576: hr_utility.trace('v_eev_prorated_earnings ='||
1577: to_char(v_eev_prorated_earnings));
1578: hr_utility.set_location('Prorate_EEV', 167);
1579: p_actual_hrs_worked := ROUND(p_actual_hrs_worked, 3);
1580: p_hrly_rate := v_curr_hrly_rate;
1581:
1582: hr_utility.trace('p_actual_hrs_worked ='||to_char(p_actual_hrs_worked));
1578: hr_utility.set_location('Prorate_EEV', 167);
1579: p_actual_hrs_worked := ROUND(p_actual_hrs_worked, 3);
1580: p_hrly_rate := v_curr_hrly_rate;
1581:
1582: hr_utility.trace('p_actual_hrs_worked ='||to_char(p_actual_hrs_worked));
1583: hr_utility.trace('p_hrly_rate ='||to_char(p_hrly_rate));
1584:
1585: hr_utility.trace('UDFS Leaving Prorated EEV');
1586:
1579: p_actual_hrs_worked := ROUND(p_actual_hrs_worked, 3);
1580: p_hrly_rate := v_curr_hrly_rate;
1581:
1582: hr_utility.trace('p_actual_hrs_worked ='||to_char(p_actual_hrs_worked));
1583: hr_utility.trace('p_hrly_rate ='||to_char(p_hrly_rate));
1584:
1585: hr_utility.trace('UDFS Leaving Prorated EEV');
1586:
1587: RETURN v_eev_prorated_earnings;
1581:
1582: hr_utility.trace('p_actual_hrs_worked ='||to_char(p_actual_hrs_worked));
1583: hr_utility.trace('p_hrly_rate ='||to_char(p_hrly_rate));
1584:
1585: hr_utility.trace('UDFS Leaving Prorated EEV');
1586:
1587: RETURN v_eev_prorated_earnings;
1588:
1589: EXCEPTION WHEN NO_DATA_FOUND THEN
1586:
1587: RETURN v_eev_prorated_earnings;
1588:
1589: EXCEPTION WHEN NO_DATA_FOUND THEN
1590: hr_utility.set_location('Prorate_EEV', 177);
1591: hr_utility.trace('Into exception of Prorate_EEV');
1592:
1593: p_actual_hrs_worked := ROUND(p_actual_hrs_worked, 3);
1594: p_hrly_rate := v_curr_hrly_rate;
1587: RETURN v_eev_prorated_earnings;
1588:
1589: EXCEPTION WHEN NO_DATA_FOUND THEN
1590: hr_utility.set_location('Prorate_EEV', 177);
1591: hr_utility.trace('Into exception of Prorate_EEV');
1592:
1593: p_actual_hrs_worked := ROUND(p_actual_hrs_worked, 3);
1594: p_hrly_rate := v_curr_hrly_rate;
1595:
1592:
1593: p_actual_hrs_worked := ROUND(p_actual_hrs_worked, 3);
1594: p_hrly_rate := v_curr_hrly_rate;
1595:
1596: hr_utility.trace('p_actual_hrs_worked ='||to_char(p_actual_hrs_worked));
1597: hr_utility.trace('p_hrly_rate ='||to_char(p_hrly_rate));
1598:
1599: RETURN v_eev_prorated_earnings;
1600:
1593: p_actual_hrs_worked := ROUND(p_actual_hrs_worked, 3);
1594: p_hrly_rate := v_curr_hrly_rate;
1595:
1596: hr_utility.trace('p_actual_hrs_worked ='||to_char(p_actual_hrs_worked));
1597: hr_utility.trace('p_hrly_rate ='||to_char(p_hrly_rate));
1598:
1599: RETURN v_eev_prorated_earnings;
1600:
1601: END Prorate_EEV;
1634:
1635: /* Init */
1636: l_vac_pay := 0;
1637:
1638: hr_utility.set_location('get_vac_pay', 11);
1639: hr_utility.trace('Entered Vacation Pay');
1640:
1641: OPEN get_vac_hours (p_asg_id, p_eff_date);
1642: LOOP
1635: /* Init */
1636: l_vac_pay := 0;
1637:
1638: hr_utility.set_location('get_vac_pay', 11);
1639: hr_utility.trace('Entered Vacation Pay');
1640:
1641: OPEN get_vac_hours (p_asg_id, p_eff_date);
1642: LOOP
1643:
1640:
1641: OPEN get_vac_hours (p_asg_id, p_eff_date);
1642: LOOP
1643:
1644: hr_utility.set_location('get_vac_pay', 13);
1645: hr_utility.trace('Opened get_vac_hours');
1646:
1647: FETCH get_vac_hours
1648: INTO l_vac_hours;
1641: OPEN get_vac_hours (p_asg_id, p_eff_date);
1642: LOOP
1643:
1644: hr_utility.set_location('get_vac_pay', 13);
1645: hr_utility.trace('Opened get_vac_hours');
1646:
1647: FETCH get_vac_hours
1648: INTO l_vac_hours;
1649: EXIT WHEN get_vac_hours%NOTFOUND;
1652:
1653: END LOOP;
1654: CLOSE get_vac_hours;
1655:
1656: hr_utility.set_location('get_vac_pay', 15);
1657:
1658: IF p_vac_hours <> 0 THEN
1659:
1660: l_vac_pay := p_vac_hours * p_curr_rate;
1660: l_vac_pay := p_vac_hours * p_curr_rate;
1661:
1662: END IF;
1663:
1664: hr_utility.trace('Leaving Vacation Pay');
1665: RETURN l_vac_pay;
1666:
1667: END vacation_pay;
1668:
1698:
1699: /* Init */
1700: l_sick_pay :=0;
1701:
1702: hr_utility.set_location('get_sick_pay', 11);
1703: hr_utility.trace('Entered Sick Pay');
1704:
1705: OPEN get_sick_hours (p_asg_id, p_eff_date);
1706: LOOP
1699: /* Init */
1700: l_sick_pay :=0;
1701:
1702: hr_utility.set_location('get_sick_pay', 11);
1703: hr_utility.trace('Entered Sick Pay');
1704:
1705: OPEN get_sick_hours (p_asg_id, p_eff_date);
1706: LOOP
1707:
1704:
1705: OPEN get_sick_hours (p_asg_id, p_eff_date);
1706: LOOP
1707:
1708: hr_utility.trace('get_sick_pay');
1709: hr_utility.set_location('get_sick_pay', 13);
1710:
1711: FETCH get_sick_hours
1712: INTO l_sick_hours;
1705: OPEN get_sick_hours (p_asg_id, p_eff_date);
1706: LOOP
1707:
1708: hr_utility.trace('get_sick_pay');
1709: hr_utility.set_location('get_sick_pay', 13);
1710:
1711: FETCH get_sick_hours
1712: INTO l_sick_hours;
1713: EXIT WHEN get_sick_hours%NOTFOUND;
1716:
1717: END LOOP;
1718: CLOSE get_sick_hours;
1719:
1720: hr_utility.set_location('get_sick_pay', 15);
1721: hr_utility.trace('get_sick_pay');
1722:
1723: IF p_sick_hours <> 0 THEN
1724:
1717: END LOOP;
1718: CLOSE get_sick_hours;
1719:
1720: hr_utility.set_location('get_sick_pay', 15);
1721: hr_utility.trace('get_sick_pay');
1722:
1723: IF p_sick_hours <> 0 THEN
1724:
1725: l_sick_pay := p_sick_hours * p_curr_rate;
1725: l_sick_pay := p_sick_hours * p_curr_rate;
1726:
1727: END IF;
1728:
1729: hr_utility.trace('Leaving get_sick_pay');
1730: RETURN l_sick_pay;
1731:
1732: END sick_pay;
1733:
1739: v_prorated_earnings := 0;
1740: v_curr_hrly_rate := 0;
1741: l_mid_period_asg_change := FALSE;
1742:
1743: -- hr_utility.trace_on(null,'coreff');
1744:
1745: hr_utility.trace('UDFS Entered Calculate_Period_Earnings');
1746: hr_utility.trace('p_asst_id ='||to_char(p_asst_id));
1747: hr_utility.trace('p_payroll_id ='||to_char(p_payroll_id));
1741: l_mid_period_asg_change := FALSE;
1742:
1743: -- hr_utility.trace_on(null,'coreff');
1744:
1745: hr_utility.trace('UDFS Entered Calculate_Period_Earnings');
1746: hr_utility.trace('p_asst_id ='||to_char(p_asst_id));
1747: hr_utility.trace('p_payroll_id ='||to_char(p_payroll_id));
1748: hr_utility.trace('p_ele_entry_id ='||to_char(p_ele_entry_id));
1749: hr_utility.trace('p_tax_unit_id ='||to_char(p_tax_unit_id));
1742:
1743: -- hr_utility.trace_on(null,'coreff');
1744:
1745: hr_utility.trace('UDFS Entered Calculate_Period_Earnings');
1746: hr_utility.trace('p_asst_id ='||to_char(p_asst_id));
1747: hr_utility.trace('p_payroll_id ='||to_char(p_payroll_id));
1748: hr_utility.trace('p_ele_entry_id ='||to_char(p_ele_entry_id));
1749: hr_utility.trace('p_tax_unit_id ='||to_char(p_tax_unit_id));
1750: hr_utility.trace('p_date_earned ='||to_char(p_date_earned));
1743: -- hr_utility.trace_on(null,'coreff');
1744:
1745: hr_utility.trace('UDFS Entered Calculate_Period_Earnings');
1746: hr_utility.trace('p_asst_id ='||to_char(p_asst_id));
1747: hr_utility.trace('p_payroll_id ='||to_char(p_payroll_id));
1748: hr_utility.trace('p_ele_entry_id ='||to_char(p_ele_entry_id));
1749: hr_utility.trace('p_tax_unit_id ='||to_char(p_tax_unit_id));
1750: hr_utility.trace('p_date_earned ='||to_char(p_date_earned));
1751: hr_utility.trace('p_pay_basis ='||p_pay_basis);
1744:
1745: hr_utility.trace('UDFS Entered Calculate_Period_Earnings');
1746: hr_utility.trace('p_asst_id ='||to_char(p_asst_id));
1747: hr_utility.trace('p_payroll_id ='||to_char(p_payroll_id));
1748: hr_utility.trace('p_ele_entry_id ='||to_char(p_ele_entry_id));
1749: hr_utility.trace('p_tax_unit_id ='||to_char(p_tax_unit_id));
1750: hr_utility.trace('p_date_earned ='||to_char(p_date_earned));
1751: hr_utility.trace('p_pay_basis ='||p_pay_basis);
1752: hr_utility.trace('p_inpval_name ='||p_inpval_name);
1745: hr_utility.trace('UDFS Entered Calculate_Period_Earnings');
1746: hr_utility.trace('p_asst_id ='||to_char(p_asst_id));
1747: hr_utility.trace('p_payroll_id ='||to_char(p_payroll_id));
1748: hr_utility.trace('p_ele_entry_id ='||to_char(p_ele_entry_id));
1749: hr_utility.trace('p_tax_unit_id ='||to_char(p_tax_unit_id));
1750: hr_utility.trace('p_date_earned ='||to_char(p_date_earned));
1751: hr_utility.trace('p_pay_basis ='||p_pay_basis);
1752: hr_utility.trace('p_inpval_name ='||p_inpval_name);
1753: hr_utility.trace('p_ass_hrly_figure ='||to_char(p_ass_hrly_figure));
1746: hr_utility.trace('p_asst_id ='||to_char(p_asst_id));
1747: hr_utility.trace('p_payroll_id ='||to_char(p_payroll_id));
1748: hr_utility.trace('p_ele_entry_id ='||to_char(p_ele_entry_id));
1749: hr_utility.trace('p_tax_unit_id ='||to_char(p_tax_unit_id));
1750: hr_utility.trace('p_date_earned ='||to_char(p_date_earned));
1751: hr_utility.trace('p_pay_basis ='||p_pay_basis);
1752: hr_utility.trace('p_inpval_name ='||p_inpval_name);
1753: hr_utility.trace('p_ass_hrly_figure ='||to_char(p_ass_hrly_figure));
1754: hr_utility.trace('UDFS p_period_start ='||to_char(p_period_start));
1747: hr_utility.trace('p_payroll_id ='||to_char(p_payroll_id));
1748: hr_utility.trace('p_ele_entry_id ='||to_char(p_ele_entry_id));
1749: hr_utility.trace('p_tax_unit_id ='||to_char(p_tax_unit_id));
1750: hr_utility.trace('p_date_earned ='||to_char(p_date_earned));
1751: hr_utility.trace('p_pay_basis ='||p_pay_basis);
1752: hr_utility.trace('p_inpval_name ='||p_inpval_name);
1753: hr_utility.trace('p_ass_hrly_figure ='||to_char(p_ass_hrly_figure));
1754: hr_utility.trace('UDFS p_period_start ='||to_char(p_period_start));
1755: hr_utility.trace('UDFS p_period_end ='||to_char(p_period_end));
1748: hr_utility.trace('p_ele_entry_id ='||to_char(p_ele_entry_id));
1749: hr_utility.trace('p_tax_unit_id ='||to_char(p_tax_unit_id));
1750: hr_utility.trace('p_date_earned ='||to_char(p_date_earned));
1751: hr_utility.trace('p_pay_basis ='||p_pay_basis);
1752: hr_utility.trace('p_inpval_name ='||p_inpval_name);
1753: hr_utility.trace('p_ass_hrly_figure ='||to_char(p_ass_hrly_figure));
1754: hr_utility.trace('UDFS p_period_start ='||to_char(p_period_start));
1755: hr_utility.trace('UDFS p_period_end ='||to_char(p_period_end));
1756: --hr_utility.trace('p_work_schedule ='||p_work_schedule);
1749: hr_utility.trace('p_tax_unit_id ='||to_char(p_tax_unit_id));
1750: hr_utility.trace('p_date_earned ='||to_char(p_date_earned));
1751: hr_utility.trace('p_pay_basis ='||p_pay_basis);
1752: hr_utility.trace('p_inpval_name ='||p_inpval_name);
1753: hr_utility.trace('p_ass_hrly_figure ='||to_char(p_ass_hrly_figure));
1754: hr_utility.trace('UDFS p_period_start ='||to_char(p_period_start));
1755: hr_utility.trace('UDFS p_period_end ='||to_char(p_period_end));
1756: --hr_utility.trace('p_work_schedule ='||p_work_schedule);
1757: --hr_utility.trace('p_asst_std_hrs ='||to_char(p_asst_std_hrs));
1750: hr_utility.trace('p_date_earned ='||to_char(p_date_earned));
1751: hr_utility.trace('p_pay_basis ='||p_pay_basis);
1752: hr_utility.trace('p_inpval_name ='||p_inpval_name);
1753: hr_utility.trace('p_ass_hrly_figure ='||to_char(p_ass_hrly_figure));
1754: hr_utility.trace('UDFS p_period_start ='||to_char(p_period_start));
1755: hr_utility.trace('UDFS p_period_end ='||to_char(p_period_end));
1756: --hr_utility.trace('p_work_schedule ='||p_work_schedule);
1757: --hr_utility.trace('p_asst_std_hrs ='||to_char(p_asst_std_hrs));
1758: hr_utility.trace('p_actual_hours_worked ='||to_char(p_actual_hours_worked));
1751: hr_utility.trace('p_pay_basis ='||p_pay_basis);
1752: hr_utility.trace('p_inpval_name ='||p_inpval_name);
1753: hr_utility.trace('p_ass_hrly_figure ='||to_char(p_ass_hrly_figure));
1754: hr_utility.trace('UDFS p_period_start ='||to_char(p_period_start));
1755: hr_utility.trace('UDFS p_period_end ='||to_char(p_period_end));
1756: --hr_utility.trace('p_work_schedule ='||p_work_schedule);
1757: --hr_utility.trace('p_asst_std_hrs ='||to_char(p_asst_std_hrs));
1758: hr_utility.trace('p_actual_hours_worked ='||to_char(p_actual_hours_worked));
1759: hr_utility.trace('p_vac_hours_worked ='||to_char(p_vac_hours_worked));
1752: hr_utility.trace('p_inpval_name ='||p_inpval_name);
1753: hr_utility.trace('p_ass_hrly_figure ='||to_char(p_ass_hrly_figure));
1754: hr_utility.trace('UDFS p_period_start ='||to_char(p_period_start));
1755: hr_utility.trace('UDFS p_period_end ='||to_char(p_period_end));
1756: --hr_utility.trace('p_work_schedule ='||p_work_schedule);
1757: --hr_utility.trace('p_asst_std_hrs ='||to_char(p_asst_std_hrs));
1758: hr_utility.trace('p_actual_hours_worked ='||to_char(p_actual_hours_worked));
1759: hr_utility.trace('p_vac_hours_worked ='||to_char(p_vac_hours_worked));
1760: hr_utility.trace('p_vac_pay ='||to_char(p_vac_pay));
1753: hr_utility.trace('p_ass_hrly_figure ='||to_char(p_ass_hrly_figure));
1754: hr_utility.trace('UDFS p_period_start ='||to_char(p_period_start));
1755: hr_utility.trace('UDFS p_period_end ='||to_char(p_period_end));
1756: --hr_utility.trace('p_work_schedule ='||p_work_schedule);
1757: --hr_utility.trace('p_asst_std_hrs ='||to_char(p_asst_std_hrs));
1758: hr_utility.trace('p_actual_hours_worked ='||to_char(p_actual_hours_worked));
1759: hr_utility.trace('p_vac_hours_worked ='||to_char(p_vac_hours_worked));
1760: hr_utility.trace('p_vac_pay ='||to_char(p_vac_pay));
1761: hr_utility.trace('p_sick_hours_worked ='||to_char(p_sick_hours_worked));
1754: hr_utility.trace('UDFS p_period_start ='||to_char(p_period_start));
1755: hr_utility.trace('UDFS p_period_end ='||to_char(p_period_end));
1756: --hr_utility.trace('p_work_schedule ='||p_work_schedule);
1757: --hr_utility.trace('p_asst_std_hrs ='||to_char(p_asst_std_hrs));
1758: hr_utility.trace('p_actual_hours_worked ='||to_char(p_actual_hours_worked));
1759: hr_utility.trace('p_vac_hours_worked ='||to_char(p_vac_hours_worked));
1760: hr_utility.trace('p_vac_pay ='||to_char(p_vac_pay));
1761: hr_utility.trace('p_sick_hours_worked ='||to_char(p_sick_hours_worked));
1762: hr_utility.trace('p_sick_pay ='||to_char(p_sick_pay));
1755: hr_utility.trace('UDFS p_period_end ='||to_char(p_period_end));
1756: --hr_utility.trace('p_work_schedule ='||p_work_schedule);
1757: --hr_utility.trace('p_asst_std_hrs ='||to_char(p_asst_std_hrs));
1758: hr_utility.trace('p_actual_hours_worked ='||to_char(p_actual_hours_worked));
1759: hr_utility.trace('p_vac_hours_worked ='||to_char(p_vac_hours_worked));
1760: hr_utility.trace('p_vac_pay ='||to_char(p_vac_pay));
1761: hr_utility.trace('p_sick_hours_worked ='||to_char(p_sick_hours_worked));
1762: hr_utility.trace('p_sick_pay ='||to_char(p_sick_pay));
1763: hr_utility.trace('UDFS p_prorate ='||p_prorate);
1756: --hr_utility.trace('p_work_schedule ='||p_work_schedule);
1757: --hr_utility.trace('p_asst_std_hrs ='||to_char(p_asst_std_hrs));
1758: hr_utility.trace('p_actual_hours_worked ='||to_char(p_actual_hours_worked));
1759: hr_utility.trace('p_vac_hours_worked ='||to_char(p_vac_hours_worked));
1760: hr_utility.trace('p_vac_pay ='||to_char(p_vac_pay));
1761: hr_utility.trace('p_sick_hours_worked ='||to_char(p_sick_hours_worked));
1762: hr_utility.trace('p_sick_pay ='||to_char(p_sick_pay));
1763: hr_utility.trace('UDFS p_prorate ='||p_prorate);
1764: hr_utility.trace('p_asst_std_freq ='||p_asst_std_freq);
1757: --hr_utility.trace('p_asst_std_hrs ='||to_char(p_asst_std_hrs));
1758: hr_utility.trace('p_actual_hours_worked ='||to_char(p_actual_hours_worked));
1759: hr_utility.trace('p_vac_hours_worked ='||to_char(p_vac_hours_worked));
1760: hr_utility.trace('p_vac_pay ='||to_char(p_vac_pay));
1761: hr_utility.trace('p_sick_hours_worked ='||to_char(p_sick_hours_worked));
1762: hr_utility.trace('p_sick_pay ='||to_char(p_sick_pay));
1763: hr_utility.trace('UDFS p_prorate ='||p_prorate);
1764: hr_utility.trace('p_asst_std_freq ='||p_asst_std_freq);
1765:
1758: hr_utility.trace('p_actual_hours_worked ='||to_char(p_actual_hours_worked));
1759: hr_utility.trace('p_vac_hours_worked ='||to_char(p_vac_hours_worked));
1760: hr_utility.trace('p_vac_pay ='||to_char(p_vac_pay));
1761: hr_utility.trace('p_sick_hours_worked ='||to_char(p_sick_hours_worked));
1762: hr_utility.trace('p_sick_pay ='||to_char(p_sick_pay));
1763: hr_utility.trace('UDFS p_prorate ='||p_prorate);
1764: hr_utility.trace('p_asst_std_freq ='||p_asst_std_freq);
1765:
1766: hr_utility.trace('Find earnings element input value id');
1759: hr_utility.trace('p_vac_hours_worked ='||to_char(p_vac_hours_worked));
1760: hr_utility.trace('p_vac_pay ='||to_char(p_vac_pay));
1761: hr_utility.trace('p_sick_hours_worked ='||to_char(p_sick_hours_worked));
1762: hr_utility.trace('p_sick_pay ='||to_char(p_sick_pay));
1763: hr_utility.trace('UDFS p_prorate ='||p_prorate);
1764: hr_utility.trace('p_asst_std_freq ='||p_asst_std_freq);
1765:
1766: hr_utility.trace('Find earnings element input value id');
1767:
1760: hr_utility.trace('p_vac_pay ='||to_char(p_vac_pay));
1761: hr_utility.trace('p_sick_hours_worked ='||to_char(p_sick_hours_worked));
1762: hr_utility.trace('p_sick_pay ='||to_char(p_sick_pay));
1763: hr_utility.trace('UDFS p_prorate ='||p_prorate);
1764: hr_utility.trace('p_asst_std_freq ='||p_asst_std_freq);
1765:
1766: hr_utility.trace('Find earnings element input value id');
1767:
1768: p_actual_hours_worked := 0;
1762: hr_utility.trace('p_sick_pay ='||to_char(p_sick_pay));
1763: hr_utility.trace('UDFS p_prorate ='||p_prorate);
1764: hr_utility.trace('p_asst_std_freq ='||p_asst_std_freq);
1765:
1766: hr_utility.trace('Find earnings element input value id');
1767:
1768: p_actual_hours_worked := 0;
1769:
1770: -- Step (1): Find earnings element input value.
1777: IF p_pay_basis IS NOT NULL THEN
1778:
1779: BEGIN
1780:
1781: hr_utility.trace(' p_pay_basis IS NOT NULL');
1782: hr_utility.set_location('calculate_period_earnings', 10);
1783:
1784: SELECT PYB.input_value_id,
1785: FCL.meaning
1778:
1779: BEGIN
1780:
1781: hr_utility.trace(' p_pay_basis IS NOT NULL');
1782: hr_utility.set_location('calculate_period_earnings', 10);
1783:
1784: SELECT PYB.input_value_id,
1785: FCL.meaning
1786: INTO v_inpval_id,
1796: AND p_date_earned BETWEEN ASG.effective_start_date
1797: AND ASG.effective_end_date;
1798:
1799: EXCEPTION WHEN NO_DATA_FOUND THEN
1800: hr_utility.set_location('calculate_period_earnings', 11);
1801: hr_utility.trace(' In EXCEPTION p_pay_basis IS NOT NULL');
1802:
1803: v_period_earn := 0;
1804: p_actual_hours_worked := ROUND(p_actual_hours_worked, 3);
1797: AND ASG.effective_end_date;
1798:
1799: EXCEPTION WHEN NO_DATA_FOUND THEN
1800: hr_utility.set_location('calculate_period_earnings', 11);
1801: hr_utility.trace(' In EXCEPTION p_pay_basis IS NOT NULL');
1802:
1803: v_period_earn := 0;
1804: p_actual_hours_worked := ROUND(p_actual_hours_worked, 3);
1805:
1802:
1803: v_period_earn := 0;
1804: p_actual_hours_worked := ROUND(p_actual_hours_worked, 3);
1805:
1806: hr_utility.trace('p_actual_hours_worked ='||to_char(p_actual_hours_worked));
1807:
1808: RETURN v_period_earn;
1809:
1810:
1809:
1810:
1811: END;
1812:
1813: hr_utility.trace('p_inpval_name = '||p_inpval_name);
1814:
1815: ELSIF UPPER(p_inpval_name) = 'RATE' THEN
1816:
1817: hr_utility.trace(' p_pay_basis IS NULL');
1813: hr_utility.trace('p_inpval_name = '||p_inpval_name);
1814:
1815: ELSIF UPPER(p_inpval_name) = 'RATE' THEN
1816:
1817: hr_utility.trace(' p_pay_basis IS NULL');
1818: hr_utility.trace('In p_inpval_name = RATE');
1819: /* Changed the element_name and name to init case and added
1820: the date join for pay_element_types_f */
1821:
1814:
1815: ELSIF UPPER(p_inpval_name) = 'RATE' THEN
1816:
1817: hr_utility.trace(' p_pay_basis IS NULL');
1818: hr_utility.trace('In p_inpval_name = RATE');
1819: /* Changed the element_name and name to init case and added
1820: the date join for pay_element_types_f */
1821:
1822: begin
1836: v_pay_basis := 'HOURLY';
1837: --
1838: EXCEPTION WHEN NO_DATA_FOUND THEN
1839:
1840: hr_utility.trace('Exception of RATE ');
1841:
1842: v_period_earn := 0;
1843: p_actual_hours_worked := ROUND(p_actual_hours_worked, 3);
1844:
1841:
1842: v_period_earn := 0;
1843: p_actual_hours_worked := ROUND(p_actual_hours_worked, 3);
1844:
1845: hr_utility.trace('p_actual_hours_worked ='||to_char(p_actual_hours_worked));
1846:
1847: RETURN v_period_earn;
1848: end;
1849: --
1851: /* Changed the element_name and name to init case and added
1852: the date join for pay_element_types_f */
1853:
1854: begin
1855: hr_utility.trace('In RATE CODE');
1856:
1857: SELECT IPV.input_value_id
1858: INTO v_inpval_id
1859: FROM pay_input_values_f IPV,
1869: --
1870: v_pay_basis := 'HOURLY';
1871: --
1872: EXCEPTION WHEN NO_DATA_FOUND THEN
1873: hr_utility.trace('Exception of Rate Code');
1874:
1875: v_period_earn := 0;
1876: p_actual_hours_worked := ROUND(p_actual_hours_worked, 3);
1877:
1874:
1875: v_period_earn := 0;
1876: p_actual_hours_worked := ROUND(p_actual_hours_worked, 3);
1877:
1878: hr_utility.trace('p_actual_hours_worked ='||to_char(p_actual_hours_worked));
1879:
1880: RETURN v_period_earn;
1881:
1882: end;
1886: /* Changed the element_name and name to init case and added
1887: the date join for pay_element_types_f */
1888:
1889: begin
1890: hr_utility.trace('in MONTHLY SALARY');
1891:
1892: SELECT IPV.input_value_id
1893: INTO v_inpval_id
1894: FROM pay_input_values_f IPV,
1904:
1905: v_pay_basis := 'MONTHLY';
1906:
1907: EXCEPTION WHEN NO_DATA_FOUND THEN
1908: hr_utility.set_location('calculate_period_earnings', 18);
1909: v_period_earn := 0;
1910: p_actual_hours_worked := ROUND(p_actual_hours_worked, 3);
1911: hr_utility.trace('p_actual_hours_worked ='||to_char(p_actual_hours_worked));
1912: RETURN v_period_earn;
1907: EXCEPTION WHEN NO_DATA_FOUND THEN
1908: hr_utility.set_location('calculate_period_earnings', 18);
1909: v_period_earn := 0;
1910: p_actual_hours_worked := ROUND(p_actual_hours_worked, 3);
1911: hr_utility.trace('p_actual_hours_worked ='||to_char(p_actual_hours_worked));
1912: RETURN v_period_earn;
1913: END;
1914:
1915: END IF;
1913: END;
1914:
1915: END IF;
1916:
1917: hr_utility.trace('Now know the pay basis for this assignment');
1918: hr_utility.trace('v_inpval_id ='||to_char(v_inpval_id));
1919: hr_utility.trace('v_pay_basis ='||v_pay_basis);
1920: /*
1921: -- Now know the pay basis for this assignment (v_pay_basis).
1914:
1915: END IF;
1916:
1917: hr_utility.trace('Now know the pay basis for this assignment');
1918: hr_utility.trace('v_inpval_id ='||to_char(v_inpval_id));
1919: hr_utility.trace('v_pay_basis ='||v_pay_basis);
1920: /*
1921: -- Now know the pay basis for this assignment (v_pay_basis).
1922: -- Want to convert entered earnings to pay period earnings.
1915: END IF;
1916:
1917: hr_utility.trace('Now know the pay basis for this assignment');
1918: hr_utility.trace('v_inpval_id ='||to_char(v_inpval_id));
1919: hr_utility.trace('v_pay_basis ='||v_pay_basis);
1920: /*
1921: -- Now know the pay basis for this assignment (v_pay_basis).
1922: -- Want to convert entered earnings to pay period earnings.
1923: -- For pay basis of Annual, Monthly, Bi-Weekly, Semi-Monthly,
1953: -- Find # of payroll period types per fiscal year:
1954:
1955: begin
1956:
1957: hr_utility.trace('Find # of payroll period types per fiscal year');
1958: hr_utility.set_location('calculate_period_earnings', 40);
1959:
1960: SELECT TPT.number_per_fiscal_year
1961: INTO v_pay_periods_per_year
1954:
1955: begin
1956:
1957: hr_utility.trace('Find # of payroll period types per fiscal year');
1958: hr_utility.set_location('calculate_period_earnings', 40);
1959:
1960: SELECT TPT.number_per_fiscal_year
1961: INTO v_pay_periods_per_year
1962: FROM pay_payrolls_f PRL,
1966: and PRL.effective_end_date
1967: AND PRL.payroll_id = p_payroll_id
1968: AND PRL.business_group_id + 0 = p_bus_grp_id;
1969:
1970: hr_utility.trace('v_pay_periods_per_year ='||to_char(v_pay_periods_per_year));
1971:
1972: exception when NO_DATA_FOUND then
1973:
1974: hr_utility.set_location('calculate_period_earnings', 41);
1970: hr_utility.trace('v_pay_periods_per_year ='||to_char(v_pay_periods_per_year));
1971:
1972: exception when NO_DATA_FOUND then
1973:
1974: hr_utility.set_location('calculate_period_earnings', 41);
1975: hr_utility.trace('Exception Find # of payroll period');
1976: v_period_earn := 0;
1977: p_actual_hours_worked := ROUND(p_actual_hours_worked, 3);
1978: hr_utility.trace('p_actual_hours_worked ='||to_char(p_actual_hours_worked));
1971:
1972: exception when NO_DATA_FOUND then
1973:
1974: hr_utility.set_location('calculate_period_earnings', 41);
1975: hr_utility.trace('Exception Find # of payroll period');
1976: v_period_earn := 0;
1977: p_actual_hours_worked := ROUND(p_actual_hours_worked, 3);
1978: hr_utility.trace('p_actual_hours_worked ='||to_char(p_actual_hours_worked));
1979:
1974: hr_utility.set_location('calculate_period_earnings', 41);
1975: hr_utility.trace('Exception Find # of payroll period');
1976: v_period_earn := 0;
1977: p_actual_hours_worked := ROUND(p_actual_hours_worked, 3);
1978: hr_utility.trace('p_actual_hours_worked ='||to_char(p_actual_hours_worked));
1979:
1980: RETURN v_period_earn;
1981:
1982: end;
1995: -- scheduled hours, not
1996: -- actual hours for a week, converted to a period figure.
1997: */
1998: --
1999: hr_utility.set_location('calculate_period_earnings', 45);
2000: hr_utility.trace('Get hours scheduled for the current period');
2001:
2002: /*IF p_work_schedule <> 'NOT ENTERED' THEN
2003: --
1996: -- actual hours for a week, converted to a period figure.
1997: */
1998: --
1999: hr_utility.set_location('calculate_period_earnings', 45);
2000: hr_utility.trace('Get hours scheduled for the current period');
2001:
2002: /*IF p_work_schedule <> 'NOT ENTERED' THEN
2003: --
2004: -- Find hours worked between period start and end dates.
2002: /*IF p_work_schedule <> 'NOT ENTERED' THEN
2003: --
2004: -- Find hours worked between period start and end dates.
2005: --
2006: hr_utility.trace('Asg has Work Schedule');
2007: hr_utility.trace('p_work_schedule ='||p_work_schedule);
2008:
2009: v_ws_id := fnd_number.canonical_to_number(p_work_schedule);
2010: hr_utility.trace('v_ws_id ='||to_char(v_ws_id));
2003: --
2004: -- Find hours worked between period start and end dates.
2005: --
2006: hr_utility.trace('Asg has Work Schedule');
2007: hr_utility.trace('p_work_schedule ='||p_work_schedule);
2008:
2009: v_ws_id := fnd_number.canonical_to_number(p_work_schedule);
2010: hr_utility.trace('v_ws_id ='||to_char(v_ws_id));
2011: --
2006: hr_utility.trace('Asg has Work Schedule');
2007: hr_utility.trace('p_work_schedule ='||p_work_schedule);
2008:
2009: v_ws_id := fnd_number.canonical_to_number(p_work_schedule);
2010: hr_utility.trace('v_ws_id ='||to_char(v_ws_id));
2011: --
2012: SELECT user_column_name
2013: INTO v_work_sched_name
2014: FROM pay_user_columns
2015: WHERE user_column_id = v_ws_id
2016: AND NVL(business_group_id, p_bus_grp_id) = p_bus_grp_id
2017: AND NVL(legislation_code,'US') = 'US';
2018:
2019: hr_utility.trace('v_work_sched_name ='||v_work_sched_name);
2020: hr_utility.trace('Calling Work_Schedule_Total_Hours');
2021:
2022: v_hrs_per_range := Work_Schedule_Total_Hours( p_bus_grp_id,
2023: v_work_sched_name,
2016: AND NVL(business_group_id, p_bus_grp_id) = p_bus_grp_id
2017: AND NVL(legislation_code,'US') = 'US';
2018:
2019: hr_utility.trace('v_work_sched_name ='||v_work_sched_name);
2020: hr_utility.trace('Calling Work_Schedule_Total_Hours');
2021:
2022: v_hrs_per_range := Work_Schedule_Total_Hours( p_bus_grp_id,
2023: v_work_sched_name,
2024: p_period_start,
2022: v_hrs_per_range := Work_Schedule_Total_Hours( p_bus_grp_id,
2023: v_work_sched_name,
2024: p_period_start,
2025: p_period_end);
2026: hr_utility.trace('v_hrs_per_range ='||to_char(v_hrs_per_range));
2027: ELSE
2028:
2029: hr_utility.trace('Asg has No Work Schedule');
2030: hr_utility.trace('Calling Standard_Hours_Worked');
2025: p_period_end);
2026: hr_utility.trace('v_hrs_per_range ='||to_char(v_hrs_per_range));
2027: ELSE
2028:
2029: hr_utility.trace('Asg has No Work Schedule');
2030: hr_utility.trace('Calling Standard_Hours_Worked');
2031:
2032: v_hrs_per_range := Standard_Hours_Worked( p_asst_std_hrs,
2033: p_period_start,
2026: hr_utility.trace('v_hrs_per_range ='||to_char(v_hrs_per_range));
2027: ELSE
2028:
2029: hr_utility.trace('Asg has No Work Schedule');
2030: hr_utility.trace('Calling Standard_Hours_Worked');
2031:
2032: v_hrs_per_range := Standard_Hours_Worked( p_asst_std_hrs,
2033: p_period_start,
2034: p_period_end,
2032: v_hrs_per_range := Standard_Hours_Worked( p_asst_std_hrs,
2033: p_period_start,
2034: p_period_end,
2035: p_asst_std_freq);
2036: hr_utility.trace('v_hrs_per_range ='||to_char(v_hrs_per_range));
2037:
2038: END IF;
2039: */
2040:
2053: ,v_schedule_source
2054: ,v_schedule
2055: ,v_return_status
2056: ,v_return_message);
2057: hr_utility.trace('v_hrs_per_range ='||to_char(v_hrs_per_range));
2058:
2059: hr_utility.trace('Compute earnings and actual hours');
2060: hr_utility.trace('calling convert_period_type from calculate_period_earnings');
2061: hr_utility.set_location('calculate_period_earnings', 46);
2055: ,v_return_status
2056: ,v_return_message);
2057: hr_utility.trace('v_hrs_per_range ='||to_char(v_hrs_per_range));
2058:
2059: hr_utility.trace('Compute earnings and actual hours');
2060: hr_utility.trace('calling convert_period_type from calculate_period_earnings');
2061: hr_utility.set_location('calculate_period_earnings', 46);
2062:
2063: v_period_earn := Convert_Period_Type(p_bus_grp_id
2056: ,v_return_message);
2057: hr_utility.trace('v_hrs_per_range ='||to_char(v_hrs_per_range));
2058:
2059: hr_utility.trace('Compute earnings and actual hours');
2060: hr_utility.trace('calling convert_period_type from calculate_period_earnings');
2061: hr_utility.set_location('calculate_period_earnings', 46);
2062:
2063: v_period_earn := Convert_Period_Type(p_bus_grp_id
2064: ,p_asst_id
2057: hr_utility.trace('v_hrs_per_range ='||to_char(v_hrs_per_range));
2058:
2059: hr_utility.trace('Compute earnings and actual hours');
2060: hr_utility.trace('calling convert_period_type from calculate_period_earnings');
2061: hr_utility.set_location('calculate_period_earnings', 46);
2062:
2063: v_period_earn := Convert_Period_Type(p_bus_grp_id
2064: ,p_asst_id
2065: ,p_payroll_id
2082: p_period_start,
2083: p_period_end,
2084: p_asst_std_freq); */
2085:
2086: hr_utility.trace('v_period_earn ='||to_char(v_period_earn));
2087: hr_utility.set_location('calculate_period_earnings', 47);
2088:
2089: p_actual_hours_worked := v_hrs_per_range;
2090:
2083: p_period_end,
2084: p_asst_std_freq); */
2085:
2086: hr_utility.trace('v_period_earn ='||to_char(v_period_earn));
2087: hr_utility.set_location('calculate_period_earnings', 47);
2088:
2089: p_actual_hours_worked := v_hrs_per_range;
2090:
2091: hr_utility.trace('p_actual_hours_worked ='||to_char(p_actual_hours_worked));
2087: hr_utility.set_location('calculate_period_earnings', 47);
2088:
2089: p_actual_hours_worked := v_hrs_per_range;
2090:
2091: hr_utility.trace('p_actual_hours_worked ='||to_char(p_actual_hours_worked));
2092:
2093: IF p_prorate = 'N' THEN
2094:
2095: hr_utility.trace('No proration');
2091: hr_utility.trace('p_actual_hours_worked ='||to_char(p_actual_hours_worked));
2092:
2093: IF p_prorate = 'N' THEN
2094:
2095: hr_utility.trace('No proration');
2096: hr_utility.trace('Calling p_vac_pay');
2097: hr_utility.set_location('calculate_period_earnings', 49);
2098:
2099: p_vac_pay := vacation_pay( p_vac_hours => p_vac_hours_worked,
2092:
2093: IF p_prorate = 'N' THEN
2094:
2095: hr_utility.trace('No proration');
2096: hr_utility.trace('Calling p_vac_pay');
2097: hr_utility.set_location('calculate_period_earnings', 49);
2098:
2099: p_vac_pay := vacation_pay( p_vac_hours => p_vac_hours_worked,
2100: p_asg_id => p_asst_id,
2093: IF p_prorate = 'N' THEN
2094:
2095: hr_utility.trace('No proration');
2096: hr_utility.trace('Calling p_vac_pay');
2097: hr_utility.set_location('calculate_period_earnings', 49);
2098:
2099: p_vac_pay := vacation_pay( p_vac_hours => p_vac_hours_worked,
2100: p_asg_id => p_asst_id,
2101: p_eff_date => p_period_end,
2100: p_asg_id => p_asst_id,
2101: p_eff_date => p_period_end,
2102: p_curr_rate => p_ass_hrly_figure);
2103:
2104: hr_utility.trace('p_vac_pay ='||to_char(p_vac_pay));
2105:
2106: hr_utility.trace('Calling sick Pay');
2107: p_sick_pay := sick_pay( p_sick_hours => p_sick_hours_worked,
2108: p_asg_id => p_asst_id,
2102: p_curr_rate => p_ass_hrly_figure);
2103:
2104: hr_utility.trace('p_vac_pay ='||to_char(p_vac_pay));
2105:
2106: hr_utility.trace('Calling sick Pay');
2107: p_sick_pay := sick_pay( p_sick_hours => p_sick_hours_worked,
2108: p_asg_id => p_asst_id,
2109: p_eff_date => p_period_end,
2110: p_curr_rate => p_ass_hrly_figure);
2109: p_eff_date => p_period_end,
2110: p_curr_rate => p_ass_hrly_figure);
2111:
2112:
2113: hr_utility.trace('p_sick_pay ='||to_char(p_sick_pay));
2114:
2115: p_actual_hours_worked := ROUND(p_actual_hours_worked, 3);
2116:
2117: hr_utility.trace('p_actual_hours_worked ='||to_char(p_actual_hours_worked));
2113: hr_utility.trace('p_sick_pay ='||to_char(p_sick_pay));
2114:
2115: p_actual_hours_worked := ROUND(p_actual_hours_worked, 3);
2116:
2117: hr_utility.trace('p_actual_hours_worked ='||to_char(p_actual_hours_worked));
2118: hr_utility.trace('UDFS v_period_earn ='||to_char(v_period_earn));
2119:
2120: RETURN v_period_earn;
2121:
2114:
2115: p_actual_hours_worked := ROUND(p_actual_hours_worked, 3);
2116:
2117: hr_utility.trace('p_actual_hours_worked ='||to_char(p_actual_hours_worked));
2118: hr_utility.trace('UDFS v_period_earn ='||to_char(v_period_earn));
2119:
2120: RETURN v_period_earn;
2121:
2122: END IF; /* IF p_prorate = 'N' */
2121:
2122: END IF; /* IF p_prorate = 'N' */
2123:
2124:
2125: hr_utility.trace('UDFS check for ASGMPE changes');
2126: hr_utility.set_location('calculate_period_earnings', 51);
2127: /* ************************************************************** */
2128:
2129: BEGIN /* Check ASGMPE */
2122: END IF; /* IF p_prorate = 'N' */
2123:
2124:
2125: hr_utility.trace('UDFS check for ASGMPE changes');
2126: hr_utility.set_location('calculate_period_earnings', 51);
2127: /* ************************************************************** */
2128:
2129: BEGIN /* Check ASGMPE */
2130:
2144: AND SCL.soft_coding_keyflex_id = ASG.soft_coding_keyflex_id
2145: AND SCL.segment1 = TO_CHAR(p_tax_unit_id)
2146: AND SCL.enabled_flag = 'Y' );
2147:
2148: hr_utility.trace('ASGMPE Changes found');
2149: hr_utility.trace('Need to prorate b/c of ASGMPE');
2150: hr_utility.trace('Set l_mid_period_asg_change to TRUE I');
2151:
2152: l_mid_period_asg_change := TRUE;
2145: AND SCL.segment1 = TO_CHAR(p_tax_unit_id)
2146: AND SCL.enabled_flag = 'Y' );
2147:
2148: hr_utility.trace('ASGMPE Changes found');
2149: hr_utility.trace('Need to prorate b/c of ASGMPE');
2150: hr_utility.trace('Set l_mid_period_asg_change to TRUE I');
2151:
2152: l_mid_period_asg_change := TRUE;
2153:
2146: AND SCL.enabled_flag = 'Y' );
2147:
2148: hr_utility.trace('ASGMPE Changes found');
2149: hr_utility.trace('Need to prorate b/c of ASGMPE');
2150: hr_utility.trace('Set l_mid_period_asg_change to TRUE I');
2151:
2152: l_mid_period_asg_change := TRUE;
2153:
2154: hr_utility.set_location('calculate_period_earnings', 56);
2150: hr_utility.trace('Set l_mid_period_asg_change to TRUE I');
2151:
2152: l_mid_period_asg_change := TRUE;
2153:
2154: hr_utility.set_location('calculate_period_earnings', 56);
2155: hr_utility.trace('Look for EEVMPE changes');
2156:
2157: BEGIN /* EEVMPE check - maybe pick*/
2158:
2151:
2152: l_mid_period_asg_change := TRUE;
2153:
2154: hr_utility.set_location('calculate_period_earnings', 56);
2155: hr_utility.trace('Look for EEVMPE changes');
2156:
2157: BEGIN /* EEVMPE check - maybe pick*/
2158:
2159: select 1 INTO l_eev_info_changes
2170: ) );
2171:
2172:
2173:
2174: hr_utility.trace('EEVMPE changes found after ASGMPE');
2175:
2176: EXCEPTION
2177:
2178: WHEN NO_DATA_FOUND THEN
2177:
2178: WHEN NO_DATA_FOUND THEN
2179: l_eev_info_changes := 0;
2180:
2181: hr_utility.trace('From EXCEPTION ASGMPE changes found No EEVMPE changes');
2182:
2183: END; /* EEV1 check*/
2184:
2185: EXCEPTION
2186:
2187: WHEN NO_DATA_FOUND THEN
2188:
2189: l_asg_info_changes := 0;
2190: hr_utility.trace('From EXCEPTION No ASGMPE changes, nor EEVMPE changes');
2191:
2192: END; /* ASGMPE check*/
2193:
2194: /* ************************************************ */
2194: /* ************************************************ */
2195:
2196: IF l_asg_info_changes = 0 THEN /* Check ASGMPS */
2197:
2198: hr_utility.trace(' Into l_asg_info_changes = 0');
2199: hr_utility.trace('UDFS looking for ASGMPS changes');
2200: hr_utility.set_location('calculate_period_earnings', 56);
2201:
2202: BEGIN /* ASGMPS changes */
2195:
2196: IF l_asg_info_changes = 0 THEN /* Check ASGMPS */
2197:
2198: hr_utility.trace(' Into l_asg_info_changes = 0');
2199: hr_utility.trace('UDFS looking for ASGMPS changes');
2200: hr_utility.set_location('calculate_period_earnings', 56);
2201:
2202: BEGIN /* ASGMPS changes */
2203:
2196: IF l_asg_info_changes = 0 THEN /* Check ASGMPS */
2197:
2198: hr_utility.trace(' Into l_asg_info_changes = 0');
2199: hr_utility.trace('UDFS looking for ASGMPS changes');
2200: hr_utility.set_location('calculate_period_earnings', 56);
2201:
2202: BEGIN /* ASGMPS changes */
2203:
2204: select 1 INTO l_asg_info_changes
2218: AND SCL.enabled_flag = 'Y');
2219:
2220: l_mid_period_asg_change := TRUE;
2221:
2222: hr_utility.trace('Need to prorate for ASGMPS changes');
2223: hr_utility.set_location('calculate_period_earnings', 57);
2224:
2225: BEGIN /* EEVMPE changes ASGMPS */
2226:
2219:
2220: l_mid_period_asg_change := TRUE;
2221:
2222: hr_utility.trace('Need to prorate for ASGMPS changes');
2223: hr_utility.set_location('calculate_period_earnings', 57);
2224:
2225: BEGIN /* EEVMPE changes ASGMPS */
2226:
2227: select 1 INTO l_eev_info_changes
2237: --OR ( EEV.effective_start_date between p_period_start and p_period_end)
2238: ) );
2239:
2240:
2241: hr_utility.trace('Need to prorate EEVMPS changes after ASGMPS ');
2242:
2243: EXCEPTION
2244:
2245: WHEN NO_DATA_FOUND THEN
2245: WHEN NO_DATA_FOUND THEN
2246:
2247: l_eev_info_changes := 0;
2248:
2249: hr_utility.trace('From EXCEPTIION No EEVMPE changes');
2250:
2251: END; /* EEVMPE changes */
2252:
2253: EXCEPTION
2255: WHEN NO_DATA_FOUND THEN
2256:
2257: l_asg_info_changes := 0;
2258:
2259: hr_utility.trace('From EXCEPTION no changes due to ASGMPS or EEVMPE');
2260:
2261: END; /* ASGMPS changes */
2262:
2263: END IF; /* Check ASGMPS */
2267: IF l_asg_info_changes = 0 THEN /* ASGMPE=0 and ASGMPS=0 */
2268:
2269: BEGIN /* Check for EEVMPE changes */
2270:
2271: hr_utility.set_location('calculate_period_earnings', 58);
2272: hr_utility.trace('Check for EEVMPE changes nevertheless');
2273:
2274: select 1 INTO l_eev_info_changes
2275: from dual
2268:
2269: BEGIN /* Check for EEVMPE changes */
2270:
2271: hr_utility.set_location('calculate_period_earnings', 58);
2272: hr_utility.trace('Check for EEVMPE changes nevertheless');
2273:
2274: select 1 INTO l_eev_info_changes
2275: from dual
2276: where exists (
2281: AND EEV.effective_start_date <= p_period_start
2282: AND EEV.effective_end_date >= p_period_start
2283: AND EEV.effective_end_date < p_period_end);
2284:
2285: hr_utility.trace('Proration due to EEVMPE changes');
2286:
2287:
2288: EXCEPTION
2289:
2288: EXCEPTION
2289:
2290: WHEN NO_DATA_FOUND THEN
2291:
2292: hr_utility.trace('ASG AND EEV changes DO NOT EXIST EXCEPT ');
2293:
2294:
2295: /* Bug 10063757 Check to see if we want to confirm the Assignment Status is
2296: Active Assignmnet prior to continuing. We check the pay_action_parameter
2319: END;
2320:
2321:
2322:
2323: hr_utility.trace(' Check assignment status of current asg record');
2324:
2325: IF l_proc_reg_sal <> 'Y' THEN
2326:
2327:
2339: AND SCL.enabled_flag = 'Y';
2340:
2341: IF v_asg_status <> 'ACTIVE_ASSIGN' THEN
2342:
2343: hr_utility.trace(' Asg not active');
2344: v_period_earn := 0;
2345: p_actual_hours_worked := 0;
2346:
2347: END IF;
2347: END IF;
2348:
2349: END IF;
2350:
2351: hr_utility.trace('Chk for vac pay since no ASG EEV changes to prorate' );
2352:
2353: p_vac_pay := vacation_pay(p_vac_hours => p_vac_hours_worked,
2354: p_asg_id => p_asst_id,
2355: p_eff_date => p_period_end,
2354: p_asg_id => p_asst_id,
2355: p_eff_date => p_period_end,
2356: p_curr_rate => p_ass_hrly_figure);
2357:
2358: hr_utility.trace('p_vac_pay ='||p_vac_pay);
2359: p_sick_pay := sick_pay( p_sick_hours => p_sick_hours_worked,
2360: p_asg_id => p_asst_id,
2361: p_eff_date => p_period_end,
2362: p_curr_rate => p_ass_hrly_figure);
2361: p_eff_date => p_period_end,
2362: p_curr_rate => p_ass_hrly_figure);
2363:
2364:
2365: hr_utility.trace('p_sick_pay ='||p_sick_pay);
2366:
2367: p_actual_hours_worked := ROUND(p_actual_hours_worked, 3);
2368: RETURN v_period_earn;
2369:
2381:
2382: /* ************** ONLY ASG CHANGES START **** */
2383:
2384: p_actual_hours_worked := 0;
2385: hr_utility.set_location('calculate_period_earnings', 70);
2386: hr_utility.trace('UDFS ONLY ASG CHANGES START');
2387:
2388: BEGIN /* Get Asg Details ASGMPE */
2389:
2382: /* ************** ONLY ASG CHANGES START **** */
2383:
2384: p_actual_hours_worked := 0;
2385: hr_utility.set_location('calculate_period_earnings', 70);
2386: hr_utility.trace('UDFS ONLY ASG CHANGES START');
2387:
2388: BEGIN /* Get Asg Details ASGMPE */
2389:
2390: hr_utility.trace('Get Asg details - ASGMPE');
2386: hr_utility.trace('UDFS ONLY ASG CHANGES START');
2387:
2388: BEGIN /* Get Asg Details ASGMPE */
2389:
2390: hr_utility.trace('Get Asg details - ASGMPE');
2391: hr_utility.set_location('calculate_period_earnings', 71);
2392:
2393: SELECT GREATEST(ASG.effective_start_date, p_period_start),
2394: ASG.effective_end_date,
2387:
2388: BEGIN /* Get Asg Details ASGMPE */
2389:
2390: hr_utility.trace('Get Asg details - ASGMPE');
2391: hr_utility.set_location('calculate_period_earnings', 71);
2392:
2393: SELECT GREATEST(ASG.effective_start_date, p_period_start),
2394: ASG.effective_end_date,
2395: NVL(ASG.NORMAL_HOURS, 0),
2417: AND HRL.lookup_code(+) = ASG.frequency
2418: AND HRL.lookup_type(+) = 'FREQUENCY';
2419:
2420:
2421: hr_utility.trace('If ASGMPE Details succ. then Calling Prorate_Earnings');
2422: hr_utility.set_location('calculate_period_earnings', 72);
2423: v_prorated_earnings := v_prorated_earnings +
2424: Prorate_Earnings (
2425: p_bg_id => p_bus_grp_id,
2418: AND HRL.lookup_type(+) = 'FREQUENCY';
2419:
2420:
2421: hr_utility.trace('If ASGMPE Details succ. then Calling Prorate_Earnings');
2422: hr_utility.set_location('calculate_period_earnings', 72);
2423: v_prorated_earnings := v_prorated_earnings +
2424: Prorate_Earnings (
2425: p_bg_id => p_bus_grp_id,
2426: p_asg_hrly_rate => p_ass_hrly_figure,
2427: p_range_start_date => v_range_start,
2428: p_range_end_date => v_range_end,
2429: p_act_hrs_worked => p_actual_hours_worked);
2430:
2431: hr_utility.trace('After Calling Prorate_Earnings');
2432:
2433: EXCEPTION WHEN NO_DATA_FOUND THEN
2434:
2435: NULL;
2436:
2437: END; /* Get Asg Details */
2438:
2439:
2440: hr_utility.trace('ONLY ASG , select MULTIASG');
2441: hr_utility.set_location('calculate_period_earnings', 77);
2442:
2443: OPEN get_asst_chgs; -- SELECT (ASG2 MULTIASG)
2444: LOOP
2437: END; /* Get Asg Details */
2438:
2439:
2440: hr_utility.trace('ONLY ASG , select MULTIASG');
2441: hr_utility.set_location('calculate_period_earnings', 77);
2442:
2443: OPEN get_asst_chgs; -- SELECT (ASG2 MULTIASG)
2444: LOOP
2445:
2449: v_asst_std_hrs,
2450: v_asst_std_freq,
2451: v_work_schedule;
2452: EXIT WHEN get_asst_chgs%NOTFOUND;
2453: hr_utility.set_location('calculate_period_earnings', 79);
2454:
2455:
2456: hr_utility.trace('ONLY ASG Calling Prorate_Earning as MULTIASG successful');
2457:
2452: EXIT WHEN get_asst_chgs%NOTFOUND;
2453: hr_utility.set_location('calculate_period_earnings', 79);
2454:
2455:
2456: hr_utility.trace('ONLY ASG Calling Prorate_Earning as MULTIASG successful');
2457:
2458: v_prorated_earnings := v_prorated_earnings +
2459: Prorate_Earnings (
2460: p_bg_id => p_bus_grp_id,
2463: p_range_end_date => v_range_end,
2464: p_act_hrs_worked => p_actual_hours_worked);
2465:
2466:
2467: hr_utility.trace('After calling Prorate_Earnings from MULTIASG');
2468:
2469: END LOOP;
2470:
2471: CLOSE get_asst_chgs;
2471: CLOSE get_asst_chgs;
2472:
2473: BEGIN /* END_SPAN_RECORD */
2474:
2475: hr_utility.set_location('calculate_period_earnings', 89);
2476: hr_utility.trace('ONLY ASG , select END_SPAN_RECORD');
2477:
2478: SELECT ASG.effective_start_date,
2479: LEAST(ASG.effective_end_date, p_period_end),
2472:
2473: BEGIN /* END_SPAN_RECORD */
2474:
2475: hr_utility.set_location('calculate_period_earnings', 89);
2476: hr_utility.trace('ONLY ASG , select END_SPAN_RECORD');
2477:
2478: SELECT ASG.effective_start_date,
2479: LEAST(ASG.effective_end_date, p_period_end),
2480: NVL(ASG.normal_hours, 0),
2501: AND SCL.enabled_flag = 'Y'
2502: AND HRL.lookup_code(+) = ASG.frequency
2503: AND HRL.lookup_type(+) = 'FREQUENCY';
2504:
2505: hr_utility.trace('Calling Prorate_Earnings for ONLY ASG END_SPAN_RECORD');
2506: hr_utility.set_location('calculate_period_earnings', 91);
2507: v_prorated_earnings := v_prorated_earnings +
2508: Prorate_Earnings (
2509: p_bg_id => p_bus_grp_id,
2502: AND HRL.lookup_code(+) = ASG.frequency
2503: AND HRL.lookup_type(+) = 'FREQUENCY';
2504:
2505: hr_utility.trace('Calling Prorate_Earnings for ONLY ASG END_SPAN_RECORD');
2506: hr_utility.set_location('calculate_period_earnings', 91);
2507: v_prorated_earnings := v_prorated_earnings +
2508: Prorate_Earnings (
2509: p_bg_id => p_bus_grp_id,
2510: p_asg_hrly_rate => p_ass_hrly_figure,
2512: p_range_end_date => v_range_end,
2513: p_act_hrs_worked => p_actual_hours_worked);
2514:
2515:
2516: hr_utility.trace('Calling Vacation Pay as END_SPAN succ');
2517: hr_utility.set_location('calculate_period_earnings', 101);
2518:
2519: p_vac_pay := vacation_pay( p_vac_hours => p_vac_hours_worked,
2520: p_asg_id => p_asst_id,
2513: p_act_hrs_worked => p_actual_hours_worked);
2514:
2515:
2516: hr_utility.trace('Calling Vacation Pay as END_SPAN succ');
2517: hr_utility.set_location('calculate_period_earnings', 101);
2518:
2519: p_vac_pay := vacation_pay( p_vac_hours => p_vac_hours_worked,
2520: p_asg_id => p_asst_id,
2521: p_eff_date => p_period_end,
2520: p_asg_id => p_asst_id,
2521: p_eff_date => p_period_end,
2522: p_curr_rate => p_ass_hrly_figure);
2523:
2524: hr_utility.trace('Calling Sick Pay as ASG3 succ');
2525:
2526: p_sick_pay := sick_pay( p_sick_hours => p_sick_hours_worked,
2527: p_asg_id => p_asst_id,
2528: p_eff_date => p_period_end,
2532: p_actual_hours_worked := ROUND(p_actual_hours_worked, 3);
2533: RETURN v_prorated_earnings;
2534:
2535: EXCEPTION WHEN NO_DATA_FOUND THEN
2536: hr_utility.set_location('calculate_period_earnings', 102);
2537: hr_utility.trace('Exception of ASG_MID_START_LAST_SPAN_END_DT');
2538:
2539: p_vac_pay := vacation_pay( p_vac_hours => p_vac_hours_worked,
2540: p_asg_id => p_asst_id,
2533: RETURN v_prorated_earnings;
2534:
2535: EXCEPTION WHEN NO_DATA_FOUND THEN
2536: hr_utility.set_location('calculate_period_earnings', 102);
2537: hr_utility.trace('Exception of ASG_MID_START_LAST_SPAN_END_DT');
2538:
2539: p_vac_pay := vacation_pay( p_vac_hours => p_vac_hours_worked,
2540: p_asg_id => p_asst_id,
2541: p_eff_date => p_period_end,
2540: p_asg_id => p_asst_id,
2541: p_eff_date => p_period_end,
2542: p_curr_rate => p_ass_hrly_figure);
2543:
2544: hr_utility.trace('Calling Sick Pay as ASG3 not succ');
2545: p_sick_pay := sick_pay( p_sick_hours => p_sick_hours_worked,
2546: p_asg_id => p_asst_id,
2547: p_eff_date => p_period_end,
2548: p_curr_rate => p_ass_hrly_figure);
2559: ELSIF (l_asg_info_changes = 0) AND (l_eev_info_changes > 0) THEN
2560:
2561: /* ******************* ONLY EEV CHANGES START ****** */
2562:
2563: hr_utility.trace(' Only EEV changes exist');
2564: hr_utility.set_location('calculate_period_earnings', 103);
2565: p_actual_hours_worked := 0;
2566:
2567:
2560:
2561: /* ******************* ONLY EEV CHANGES START ****** */
2562:
2563: hr_utility.trace(' Only EEV changes exist');
2564: hr_utility.set_location('calculate_period_earnings', 103);
2565: p_actual_hours_worked := 0;
2566:
2567:
2568: hr_utility.trace('Calling Prorate_EEV');
2564: hr_utility.set_location('calculate_period_earnings', 103);
2565: p_actual_hours_worked := 0;
2566:
2567:
2568: hr_utility.trace('Calling Prorate_EEV');
2569:
2570: v_prorated_earnings := v_prorated_earnings +
2571: Prorate_EEV (
2572: p_bus_group_id => p_bus_grp_id,
2578: p_actual_hrs_worked => p_actual_hours_worked,
2579: p_element_entry_id => p_ele_entry_id,
2580: p_inpval_id => v_inpval_id);
2581:
2582: hr_utility.trace('After Calling Prorate_EEV');
2583: hr_utility.set_location('calculate_period_earnings', 127);
2584:
2585: hr_utility.trace('Calling vacation_pay');
2586:
2579: p_element_entry_id => p_ele_entry_id,
2580: p_inpval_id => v_inpval_id);
2581:
2582: hr_utility.trace('After Calling Prorate_EEV');
2583: hr_utility.set_location('calculate_period_earnings', 127);
2584:
2585: hr_utility.trace('Calling vacation_pay');
2586:
2587: p_vac_pay := vacation_pay( p_vac_hours => p_vac_hours_worked,
2581:
2582: hr_utility.trace('After Calling Prorate_EEV');
2583: hr_utility.set_location('calculate_period_earnings', 127);
2584:
2585: hr_utility.trace('Calling vacation_pay');
2586:
2587: p_vac_pay := vacation_pay( p_vac_hours => p_vac_hours_worked,
2588: p_asg_id => p_asst_id,
2589: p_eff_date => p_period_end,
2588: p_asg_id => p_asst_id,
2589: p_eff_date => p_period_end,
2590: p_curr_rate => p_ass_hrly_figure);
2591:
2592: hr_utility.trace('Calling sick_pay');
2593:
2594: p_sick_pay := sick_pay( p_sick_hours => p_sick_hours_worked,
2595: p_asg_id => p_asst_id,
2596: p_eff_date => p_period_end,
2606:
2607: /* ******************* BOTH ASG AND EEV CHANGES START ************ */
2608:
2609:
2610: hr_utility.trace('UDFS BOTH ASG and EEV chages exist');
2611:
2612:
2613: p_actual_hours_worked := 0;
2614:
2614:
2615:
2616: BEGIN /* Latest Screen Entry Value */
2617:
2618: hr_utility.trace('BOTH ASG Get latest screen entry value for EEVMPE');
2619: hr_utility.set_location('calculate_period_earnings', 128);
2620:
2621: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
2622: INTO v_earnings_entry
2615:
2616: BEGIN /* Latest Screen Entry Value */
2617:
2618: hr_utility.trace('BOTH ASG Get latest screen entry value for EEVMPE');
2619: hr_utility.set_location('calculate_period_earnings', 128);
2620:
2621: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
2622: INTO v_earnings_entry
2623: FROM pay_element_entry_values_f EEV
2630: AND EEV.effective_end_date > p_period_start;
2631: */
2632: --AND EEV.effective_end_date < p_period_end
2633:
2634: hr_utility.trace('BOTH ASG Get ASGMPE ');
2635:
2636: SELECT GREATEST(ASG.effective_start_date, p_period_start),
2637: ASG.effective_end_date,
2638: NVL(ASG.NORMAL_HOURS, 0),
2659: AND SCL.enabled_flag = 'Y'
2660: AND HRL.lookup_code(+) = ASG.frequency
2661: AND HRL.lookup_type(+) = 'FREQUENCY';
2662:
2663: hr_utility.trace('Calling Convert_Period_Type from ASGMPE');
2664: hr_utility.set_location('v_earnings_entry='||v_earnings_entry, 129);
2665:
2666: v_curr_hrly_rate := Convert_Period_Type(p_bus_grp_id
2667: ,p_asst_id
2660: AND HRL.lookup_code(+) = ASG.frequency
2661: AND HRL.lookup_type(+) = 'FREQUENCY';
2662:
2663: hr_utility.trace('Calling Convert_Period_Type from ASGMPE');
2664: hr_utility.set_location('v_earnings_entry='||v_earnings_entry, 129);
2665:
2666: v_curr_hrly_rate := Convert_Period_Type(p_bus_grp_id
2667: ,p_asst_id
2668: ,p_payroll_id
2684: p_period_start,
2685: p_period_end,
2686: v_asst_std_freq);*/
2687:
2688: hr_utility.trace('Select app. EEVMPE again after range is determined');
2689: hr_utility.set_location('calculate_period_earnings', 130);
2690:
2691: SELECT COUNT(EEV.element_entry_value_id)
2692: INTO l_eev_info_changes
2685: p_period_end,
2686: v_asst_std_freq);*/
2687:
2688: hr_utility.trace('Select app. EEVMPE again after range is determined');
2689: hr_utility.set_location('calculate_period_earnings', 130);
2690:
2691: SELECT COUNT(EEV.element_entry_value_id)
2692: INTO l_eev_info_changes
2693: FROM pay_element_entry_values_f EEV
2699:
2700: IF l_eev_info_changes = 0 THEN
2701:
2702:
2703: hr_utility.trace('NO EEVMPE changes');
2704: hr_utility.set_location('calculate_period_earnings', 132);
2705:
2706: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
2707: INTO v_earnings_entry
2700: IF l_eev_info_changes = 0 THEN
2701:
2702:
2703: hr_utility.trace('NO EEVMPE changes');
2704: hr_utility.set_location('calculate_period_earnings', 132);
2705:
2706: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
2707: INTO v_earnings_entry
2708: FROM pay_element_entry_values_f EEV
2710: AND EEV.input_value_id = v_inpval_id
2711: AND v_range_end BETWEEN EEV.effective_start_date
2712: AND EEV.effective_end_date;
2713:
2714: hr_utility.trace('Calling Convert_Period_Type');
2715: hr_utility.set_location('calculate_period_earnings', 134);
2716:
2717: v_curr_hrly_rate := Convert_Period_Type(p_bus_grp_id
2718: ,p_asst_id
2711: AND v_range_end BETWEEN EEV.effective_start_date
2712: AND EEV.effective_end_date;
2713:
2714: hr_utility.trace('Calling Convert_Period_Type');
2715: hr_utility.set_location('calculate_period_earnings', 134);
2716:
2717: v_curr_hrly_rate := Convert_Period_Type(p_bus_grp_id
2718: ,p_asst_id
2719: ,p_payroll_id
2735: p_period_start,
2736: p_period_end,
2737: v_asst_std_freq);*/
2738:
2739: hr_utility.trace('Calling Prorate_Earnings');
2740: hr_utility.set_location('calculate_period_earnings', 135);
2741:
2742: v_prorated_earnings := v_prorated_earnings +
2743: Prorate_Earnings (
2736: p_period_end,
2737: v_asst_std_freq);*/
2738:
2739: hr_utility.trace('Calling Prorate_Earnings');
2740: hr_utility.set_location('calculate_period_earnings', 135);
2741:
2742: v_prorated_earnings := v_prorated_earnings +
2743: Prorate_Earnings (
2744: p_bg_id => p_bus_grp_id,
2746: p_range_start_date => v_range_start,
2747: p_range_end_date => v_range_end,
2748: p_act_hrs_worked => p_actual_hours_worked);
2749:
2750: hr_utility.set_location('calculate_period_earnings', 137);
2751:
2752: ELSE
2753: -- Do proration for this ASG range by EEV !
2754:
2751:
2752: ELSE
2753: -- Do proration for this ASG range by EEV !
2754:
2755: hr_utility.trace('EEVMPE True');
2756: hr_utility.trace('Do proration for this ASG range by EEV');
2757: hr_utility.set_location('calculate_period_earnings', 139);
2758:
2759: hr_utility.trace('Calling Prorate_EEV');
2752: ELSE
2753: -- Do proration for this ASG range by EEV !
2754:
2755: hr_utility.trace('EEVMPE True');
2756: hr_utility.trace('Do proration for this ASG range by EEV');
2757: hr_utility.set_location('calculate_period_earnings', 139);
2758:
2759: hr_utility.trace('Calling Prorate_EEV');
2760:
2753: -- Do proration for this ASG range by EEV !
2754:
2755: hr_utility.trace('EEVMPE True');
2756: hr_utility.trace('Do proration for this ASG range by EEV');
2757: hr_utility.set_location('calculate_period_earnings', 139);
2758:
2759: hr_utility.trace('Calling Prorate_EEV');
2760:
2761: v_prorated_earnings := v_prorated_earnings +
2755: hr_utility.trace('EEVMPE True');
2756: hr_utility.trace('Do proration for this ASG range by EEV');
2757: hr_utility.set_location('calculate_period_earnings', 139);
2758:
2759: hr_utility.trace('Calling Prorate_EEV');
2760:
2761: v_prorated_earnings := v_prorated_earnings +
2762: Prorate_EEV (
2763: p_bus_group_id => p_bus_grp_id,
2768: p_range_end_date => v_range_end,
2769: p_actual_hrs_worked => p_actual_hours_worked,
2770: p_element_entry_id => p_ele_entry_id,
2771: p_inpval_id => v_inpval_id);
2772: hr_utility.set_location('calculate_period_earnings', 140);
2773:
2774: END IF; -- EEV info changes
2775:
2776: EXCEPTION WHEN NO_DATA_FOUND THEN
2777: NULL;
2778:
2779: END; /* Latest Screen Entry Value */
2780:
2781: hr_utility.trace(' BOTH ASG - SELECT ASG_MULTI_WITHIN');
2782: hr_utility.set_location('calculate_period_earnings', 141);
2783:
2784: OPEN get_asst_chgs; -- SELECT ( ASG_MULTI_WITHIN)
2785: LOOP
2778:
2779: END; /* Latest Screen Entry Value */
2780:
2781: hr_utility.trace(' BOTH ASG - SELECT ASG_MULTI_WITHIN');
2782: hr_utility.set_location('calculate_period_earnings', 141);
2783:
2784: OPEN get_asst_chgs; -- SELECT ( ASG_MULTI_WITHIN)
2785: LOOP
2786:
2792: v_work_schedule;
2793: EXIT WHEN get_asst_chgs%NOTFOUND;
2794:
2795: --EEV_BEFORE_RANGE_END
2796: hr_utility.trace('BOTH ASG MULTI select app. EEVMPE again after range det.');
2797: hr_utility.set_location('calculate_period_earnings', 145);
2798:
2799: SELECT COUNT(EEV.element_entry_value_id)
2800: INTO l_eev_info_changes
2793: EXIT WHEN get_asst_chgs%NOTFOUND;
2794:
2795: --EEV_BEFORE_RANGE_END
2796: hr_utility.trace('BOTH ASG MULTI select app. EEVMPE again after range det.');
2797: hr_utility.set_location('calculate_period_earnings', 145);
2798:
2799: SELECT COUNT(EEV.element_entry_value_id)
2800: INTO l_eev_info_changes
2801: FROM pay_element_entry_values_f EEV
2808: IF l_eev_info_changes = 0 THEN /* IF l_eev_info_changes = 0 */
2809:
2810: -- EEV_FOR_CURR_RANGE_END
2811:
2812: hr_utility.trace('BOTH ASG - EEV false');
2813: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
2814: INTO v_earnings_entry
2815: FROM pay_element_entry_values_f EEV
2816: WHERE EEV.element_entry_id = p_ele_entry_id
2816: WHERE EEV.element_entry_id = p_ele_entry_id
2817: AND EEV.input_value_id = v_inpval_id
2818: AND v_range_end BETWEEN EEV.effective_start_date
2819: AND EEV.effective_end_date;
2820: hr_utility.set_location('calculate_period_earnings', 150);
2821: v_curr_hrly_rate := Convert_Period_Type(p_bus_grp_id
2822: ,p_asst_id
2823: ,p_payroll_id
2824: ,p_ele_entry_id
2847: p_range_start_date => v_range_start,
2848: p_range_end_date => v_range_end,
2849: p_act_hrs_worked => p_actual_hours_worked);
2850:
2851: hr_utility.set_location('calculate_period_earnings', 155);
2852: ELSE
2853: hr_utility.trace('BOTH ASG - EEV true');
2854: v_prorated_earnings := v_prorated_earnings +
2855: Prorate_EEV (
2849: p_act_hrs_worked => p_actual_hours_worked);
2850:
2851: hr_utility.set_location('calculate_period_earnings', 155);
2852: ELSE
2853: hr_utility.trace('BOTH ASG - EEV true');
2854: v_prorated_earnings := v_prorated_earnings +
2855: Prorate_EEV (
2856: p_bus_group_id => p_bus_grp_id,
2857: p_pay_id => p_payroll_id,
2871:
2872:
2873: BEGIN /* SPAN_RECORD */
2874:
2875: hr_utility.trace('BOTH ASG SELECT END_SPAN_RECORD');
2876: hr_utility.set_location('calculate_period_earnings', 160);
2877:
2878: SELECT ASG.effective_start_date,
2879: LEAST(ASG.effective_end_date, p_period_end),
2872:
2873: BEGIN /* SPAN_RECORD */
2874:
2875: hr_utility.trace('BOTH ASG SELECT END_SPAN_RECORD');
2876: hr_utility.set_location('calculate_period_earnings', 160);
2877:
2878: SELECT ASG.effective_start_date,
2879: LEAST(ASG.effective_end_date, p_period_end),
2880: NVL(ASG.normal_hours, 0),
2903: AND HRL.lookup_type(+) = 'FREQUENCY';
2904:
2905:
2906:
2907: hr_utility.trace('SELECT EEVMPE');
2908:
2909: SELECT COUNT(EEV.element_entry_value_id)
2910: INTO l_eev_info_changes
2911: FROM pay_element_entry_values_f EEV
2916: AND EEV.effective_end_date < v_range_end;
2917:
2918: IF l_eev_info_changes = 0 THEN
2919:
2920: hr_utility.trace('BOTH ASG SPAN - SELECT EEV_FOR_CURR_RANGE_END');
2921: hr_utility.set_location('calculate_period_earnings', 165);
2922:
2923: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
2924: INTO v_earnings_entry
2917:
2918: IF l_eev_info_changes = 0 THEN
2919:
2920: hr_utility.trace('BOTH ASG SPAN - SELECT EEV_FOR_CURR_RANGE_END');
2921: hr_utility.set_location('calculate_period_earnings', 165);
2922:
2923: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
2924: INTO v_earnings_entry
2925: FROM pay_element_entry_values_f EEV
2957: p_range_start_date => v_range_start,
2958: p_range_end_date => v_range_end,
2959: p_act_hrs_worked => p_actual_hours_worked);
2960:
2961: hr_utility.set_location('calculate_period_earnings', 170);
2962: ELSE /* EEV succ */
2963:
2964: hr_utility.trace('BOTH ASG END_SPAN - EEV true');
2965: v_prorated_earnings := v_prorated_earnings +
2960:
2961: hr_utility.set_location('calculate_period_earnings', 170);
2962: ELSE /* EEV succ */
2963:
2964: hr_utility.trace('BOTH ASG END_SPAN - EEV true');
2965: v_prorated_earnings := v_prorated_earnings +
2966: Prorate_EEV (
2967: p_bus_group_id => p_bus_grp_id,
2968: p_pay_id => p_payroll_id,
2972: p_range_end_date => v_range_end,
2973: p_actual_hrs_worked => p_actual_hours_worked,
2974: p_element_entry_id => p_ele_entry_id,
2975: p_inpval_id => v_inpval_id);
2976: hr_utility.set_location('calculate_period_earnings', 175);
2977: END IF;
2978:
2979:
2980: p_vac_pay := vacation_pay( p_vac_hours => p_vac_hours_worked,
2980: p_vac_pay := vacation_pay( p_vac_hours => p_vac_hours_worked,
2981: p_asg_id => p_asst_id,
2982: p_eff_date => p_period_end,
2983: p_curr_rate => p_ass_hrly_figure);
2984: hr_utility.set_location('calculate_period_earnings', 180);
2985:
2986: p_sick_pay := sick_pay( p_sick_hours => p_sick_hours_worked,
2987: p_asg_id => p_asst_id,
2988: p_eff_date => p_period_end,
2986: p_sick_pay := sick_pay( p_sick_hours => p_sick_hours_worked,
2987: p_asg_id => p_asst_id,
2988: p_eff_date => p_period_end,
2989: p_curr_rate => p_ass_hrly_figure);
2990: hr_utility.set_location('calculate_period_earnings', 185);
2991:
2992: p_actual_hours_worked := ROUND(p_actual_hours_worked, 3);
2993: RETURN v_prorated_earnings;
2994:
3118:
3119:
3120: BEGIN
3121:
3122: hr_utility.trace(' Entered get_hourly_rate ');
3123: --hr_utility.trace_on(null,'wrkschd');
3124:
3125:
3126: hr_utility.trace('assignment_action_id=' || p_assignment_action_id);
3119:
3120: BEGIN
3121:
3122: hr_utility.trace(' Entered get_hourly_rate ');
3123: --hr_utility.trace_on(null,'wrkschd');
3124:
3125:
3126: hr_utility.trace('assignment_action_id=' || p_assignment_action_id);
3127: hr_utility.trace('assignment_id=' || p_assignment_id);
3122: hr_utility.trace(' Entered get_hourly_rate ');
3123: --hr_utility.trace_on(null,'wrkschd');
3124:
3125:
3126: hr_utility.trace('assignment_action_id=' || p_assignment_action_id);
3127: hr_utility.trace('assignment_id=' || p_assignment_id);
3128: hr_utility.trace('business_group_id=' || p_bg);
3129: hr_utility.trace('element_entry_id=' || p_element_entry_id);
3130: hr_utility.trace('p_date_earned '||p_date_earned);
3123: --hr_utility.trace_on(null,'wrkschd');
3124:
3125:
3126: hr_utility.trace('assignment_action_id=' || p_assignment_action_id);
3127: hr_utility.trace('assignment_id=' || p_assignment_id);
3128: hr_utility.trace('business_group_id=' || p_bg);
3129: hr_utility.trace('element_entry_id=' || p_element_entry_id);
3130: hr_utility.trace('p_date_earned '||p_date_earned);
3131: hr_utility.trace('p_payroll_id: '||p_payroll_id);
3124:
3125:
3126: hr_utility.trace('assignment_action_id=' || p_assignment_action_id);
3127: hr_utility.trace('assignment_id=' || p_assignment_id);
3128: hr_utility.trace('business_group_id=' || p_bg);
3129: hr_utility.trace('element_entry_id=' || p_element_entry_id);
3130: hr_utility.trace('p_date_earned '||p_date_earned);
3131: hr_utility.trace('p_payroll_id: '||p_payroll_id);
3132:
3125:
3126: hr_utility.trace('assignment_action_id=' || p_assignment_action_id);
3127: hr_utility.trace('assignment_id=' || p_assignment_id);
3128: hr_utility.trace('business_group_id=' || p_bg);
3129: hr_utility.trace('element_entry_id=' || p_element_entry_id);
3130: hr_utility.trace('p_date_earned '||p_date_earned);
3131: hr_utility.trace('p_payroll_id: '||p_payroll_id);
3132:
3133: l_hourly_rate := 0;
3126: hr_utility.trace('assignment_action_id=' || p_assignment_action_id);
3127: hr_utility.trace('assignment_id=' || p_assignment_id);
3128: hr_utility.trace('business_group_id=' || p_bg);
3129: hr_utility.trace('element_entry_id=' || p_element_entry_id);
3130: hr_utility.trace('p_date_earned '||p_date_earned);
3131: hr_utility.trace('p_payroll_id: '||p_payroll_id);
3132:
3133: l_hourly_rate := 0;
3134:
3127: hr_utility.trace('assignment_id=' || p_assignment_id);
3128: hr_utility.trace('business_group_id=' || p_bg);
3129: hr_utility.trace('element_entry_id=' || p_element_entry_id);
3130: hr_utility.trace('p_date_earned '||p_date_earned);
3131: hr_utility.trace('p_payroll_id: '||p_payroll_id);
3132:
3133: l_hourly_rate := 0;
3134:
3135: OPEN get_period_dates(p_date_earned,p_payroll_id);
3136: FETCH get_period_dates INTO l_period_start_date,l_period_end_date;
3137: CLOSE get_period_dates;
3138:
3139:
3140: hr_utility.trace('l_period_start_date =' || l_period_start_date);
3141: hr_utility.trace('l_period_end_date =' || l_period_end_date);
3142:
3143: OPEN get_salary_basis(p_date_earned, p_assignment_id);
3144: FETCH get_salary_basis INTO l_salary_basis, l_input_value_id;
3137: CLOSE get_period_dates;
3138:
3139:
3140: hr_utility.trace('l_period_start_date =' || l_period_start_date);
3141: hr_utility.trace('l_period_end_date =' || l_period_end_date);
3142:
3143: OPEN get_salary_basis(p_date_earned, p_assignment_id);
3144: FETCH get_salary_basis INTO l_salary_basis, l_input_value_id;
3145: CLOSE get_salary_basis;
3143: OPEN get_salary_basis(p_date_earned, p_assignment_id);
3144: FETCH get_salary_basis INTO l_salary_basis, l_input_value_id;
3145: CLOSE get_salary_basis;
3146:
3147: hr_utility.trace('l_salary_basis =' || l_salary_basis);
3148: hr_utility.trace('l_input_value_id =' || l_input_value_id);
3149:
3150: OPEN get_salary(p_date_earned, p_assignment_id,l_input_value_id);
3151: FETCH get_salary INTO l_asg_salary;
3144: FETCH get_salary_basis INTO l_salary_basis, l_input_value_id;
3145: CLOSE get_salary_basis;
3146:
3147: hr_utility.trace('l_salary_basis =' || l_salary_basis);
3148: hr_utility.trace('l_input_value_id =' || l_input_value_id);
3149:
3150: OPEN get_salary(p_date_earned, p_assignment_id,l_input_value_id);
3151: FETCH get_salary INTO l_asg_salary;
3152: CLOSE get_salary;
3156: OPEN get_termination_date(p_date_earned, p_assignment_id);
3157: FETCH get_termination_date INTO l_termination_date;
3158: CLOSE get_termination_date;
3159:
3160: hr_utility.trace('l_termination_date =' || l_termination_date);
3161:
3162: OPEN get_salary(l_termination_date,
3163: p_assignment_id,l_input_value_id);
3164: FETCH get_salary INTO l_asg_salary;
3165: CLOSE get_salary;
3166: l_date_used := nvl(l_termination_date,p_date_earned);
3167: END IF;
3168:
3169: hr_utility.trace('l_asg_salary =' || l_asg_salary);
3170:
3171: l_hourly_rate := Convert_Period_Type(p_bg
3172: ,p_assignment_id
3173: ,p_payroll_id
3213: v_curr_date := NULL;
3214: v_curr_day :=NULL;
3215:
3216: -- Check for valid range
3217: hr_utility.trace('Entered standard_hours_worked');
3218:
3219: IF p_range_start > p_range_end THEN
3220: hr_utility.trace('p_range_start greater than p_range_end');
3221: RETURN v_total_hours;
3216: -- Check for valid range
3217: hr_utility.trace('Entered standard_hours_worked');
3218:
3219: IF p_range_start > p_range_end THEN
3220: hr_utility.trace('p_range_start greater than p_range_end');
3221: RETURN v_total_hours;
3222: -- hr_utility.set_message(801,'PAY_xxxx_INVALID_DATE_RANGE');
3223: -- hr_utility.raise_error;
3224: END IF;
3218:
3219: IF p_range_start > p_range_end THEN
3220: hr_utility.trace('p_range_start greater than p_range_end');
3221: RETURN v_total_hours;
3222: -- hr_utility.set_message(801,'PAY_xxxx_INVALID_DATE_RANGE');
3223: -- hr_utility.raise_error;
3224: END IF;
3225: --
3226:
3219: IF p_range_start > p_range_end THEN
3220: hr_utility.trace('p_range_start greater than p_range_end');
3221: RETURN v_total_hours;
3222: -- hr_utility.set_message(801,'PAY_xxxx_INVALID_DATE_RANGE');
3223: -- hr_utility.raise_error;
3224: END IF;
3225: --
3226:
3227: IF UPPER(p_std_freq) = 'WEEK' THEN
3224: END IF;
3225: --
3226:
3227: IF UPPER(p_std_freq) = 'WEEK' THEN
3228: hr_utility.trace('p_std_freq = WEEK ');
3229:
3230: v_wrkday_hours := p_std_hrs / c_wkdays_per_week;
3231:
3232: hr_utility.trace('p_std_hrs ='||to_number(p_std_hrs));
3228: hr_utility.trace('p_std_freq = WEEK ');
3229:
3230: v_wrkday_hours := p_std_hrs / c_wkdays_per_week;
3231:
3232: hr_utility.trace('p_std_hrs ='||to_number(p_std_hrs));
3233: hr_utility.trace('c_wkdays_per_week ='||to_number(c_wkdays_per_week));
3234: hr_utility.trace('v_wrkday_hours ='||to_number(v_wrkday_hours));
3235:
3236: ELSIF UPPER(p_std_freq) = 'MONTH' THEN
3229:
3230: v_wrkday_hours := p_std_hrs / c_wkdays_per_week;
3231:
3232: hr_utility.trace('p_std_hrs ='||to_number(p_std_hrs));
3233: hr_utility.trace('c_wkdays_per_week ='||to_number(c_wkdays_per_week));
3234: hr_utility.trace('v_wrkday_hours ='||to_number(v_wrkday_hours));
3235:
3236: ELSIF UPPER(p_std_freq) = 'MONTH' THEN
3237:
3230: v_wrkday_hours := p_std_hrs / c_wkdays_per_week;
3231:
3232: hr_utility.trace('p_std_hrs ='||to_number(p_std_hrs));
3233: hr_utility.trace('c_wkdays_per_week ='||to_number(c_wkdays_per_week));
3234: hr_utility.trace('v_wrkday_hours ='||to_number(v_wrkday_hours));
3235:
3236: ELSIF UPPER(p_std_freq) = 'MONTH' THEN
3237:
3238: hr_utility.trace('p_std_freq = MONTH ');
3234: hr_utility.trace('v_wrkday_hours ='||to_number(v_wrkday_hours));
3235:
3236: ELSIF UPPER(p_std_freq) = 'MONTH' THEN
3237:
3238: hr_utility.trace('p_std_freq = MONTH ');
3239:
3240: v_wrkday_hours := p_std_hrs / c_wkdays_per_month;
3241:
3242:
3239:
3240: v_wrkday_hours := p_std_hrs / c_wkdays_per_month;
3241:
3242:
3243: hr_utility.trace('p_std_hrs ='||to_number(p_std_hrs));
3244: hr_utility.trace('c_wkdays_per_month ='||to_number(c_wkdays_per_month));
3245: hr_utility.trace('v_wrkday_hours ='||to_number(v_wrkday_hours));
3246:
3247: ELSIF UPPER(p_std_freq) = 'YEAR' THEN
3240: v_wrkday_hours := p_std_hrs / c_wkdays_per_month;
3241:
3242:
3243: hr_utility.trace('p_std_hrs ='||to_number(p_std_hrs));
3244: hr_utility.trace('c_wkdays_per_month ='||to_number(c_wkdays_per_month));
3245: hr_utility.trace('v_wrkday_hours ='||to_number(v_wrkday_hours));
3246:
3247: ELSIF UPPER(p_std_freq) = 'YEAR' THEN
3248:
3241:
3242:
3243: hr_utility.trace('p_std_hrs ='||to_number(p_std_hrs));
3244: hr_utility.trace('c_wkdays_per_month ='||to_number(c_wkdays_per_month));
3245: hr_utility.trace('v_wrkday_hours ='||to_number(v_wrkday_hours));
3246:
3247: ELSIF UPPER(p_std_freq) = 'YEAR' THEN
3248:
3249: hr_utility.trace('p_std_freq = YEAR ');
3245: hr_utility.trace('v_wrkday_hours ='||to_number(v_wrkday_hours));
3246:
3247: ELSIF UPPER(p_std_freq) = 'YEAR' THEN
3248:
3249: hr_utility.trace('p_std_freq = YEAR ');
3250: v_wrkday_hours := p_std_hrs / c_wkdays_per_year;
3251:
3252: hr_utility.trace('p_std_hrs ='||to_number(p_std_hrs));
3253: hr_utility.trace('c_wkdays_per_year ='||to_number(c_wkdays_per_year));
3248:
3249: hr_utility.trace('p_std_freq = YEAR ');
3250: v_wrkday_hours := p_std_hrs / c_wkdays_per_year;
3251:
3252: hr_utility.trace('p_std_hrs ='||to_number(p_std_hrs));
3253: hr_utility.trace('c_wkdays_per_year ='||to_number(c_wkdays_per_year));
3254: hr_utility.trace('v_wrkday_hours ='||to_number(v_wrkday_hours));
3255:
3256: ELSE
3249: hr_utility.trace('p_std_freq = YEAR ');
3250: v_wrkday_hours := p_std_hrs / c_wkdays_per_year;
3251:
3252: hr_utility.trace('p_std_hrs ='||to_number(p_std_hrs));
3253: hr_utility.trace('c_wkdays_per_year ='||to_number(c_wkdays_per_year));
3254: hr_utility.trace('v_wrkday_hours ='||to_number(v_wrkday_hours));
3255:
3256: ELSE
3257: hr_utility.trace('p_std_freq in ELSE ');
3250: v_wrkday_hours := p_std_hrs / c_wkdays_per_year;
3251:
3252: hr_utility.trace('p_std_hrs ='||to_number(p_std_hrs));
3253: hr_utility.trace('c_wkdays_per_year ='||to_number(c_wkdays_per_year));
3254: hr_utility.trace('v_wrkday_hours ='||to_number(v_wrkday_hours));
3255:
3256: ELSE
3257: hr_utility.trace('p_std_freq in ELSE ');
3258: v_wrkday_hours := p_std_hrs;
3253: hr_utility.trace('c_wkdays_per_year ='||to_number(c_wkdays_per_year));
3254: hr_utility.trace('v_wrkday_hours ='||to_number(v_wrkday_hours));
3255:
3256: ELSE
3257: hr_utility.trace('p_std_freq in ELSE ');
3258: v_wrkday_hours := p_std_hrs;
3259: END IF;
3260:
3261: v_curr_date := p_range_start;
3259: END IF;
3260:
3261: v_curr_date := p_range_start;
3262:
3263: hr_utility.trace('v_curr_date is range start'||to_char(v_curr_date));
3264:
3265:
3266: LOOP
3267:
3272:
3273:
3274: v_total_hours := nvl(v_total_hours,0) + v_wrkday_hours;
3275:
3276: hr_utility.trace(' v_day_no = '||to_char(v_day_no));
3277: hr_utility.trace(' v_total_hours = '||to_char(v_total_hours));
3278: END IF;
3279:
3280: v_curr_date := v_curr_date + 1;
3273:
3274: v_total_hours := nvl(v_total_hours,0) + v_wrkday_hours;
3275:
3276: hr_utility.trace(' v_day_no = '||to_char(v_day_no));
3277: hr_utility.trace(' v_total_hours = '||to_char(v_total_hours));
3278: END IF;
3279:
3280: v_curr_date := v_curr_date + 1;
3281: EXIT WHEN v_curr_date > p_range_end;
3279:
3280: v_curr_date := v_curr_date + 1;
3281: EXIT WHEN v_curr_date > p_range_end;
3282: END LOOP;
3283: hr_utility.trace(' Final v_total_hours = '||to_char(v_total_hours));
3284: hr_utility.trace(' Leaving standard_hours_worked' );
3285: --
3286: RETURN v_total_hours;
3287: --
3280: v_curr_date := v_curr_date + 1;
3281: EXIT WHEN v_curr_date > p_range_end;
3282: END LOOP;
3283: hr_utility.trace(' Final v_total_hours = '||to_char(v_total_hours));
3284: hr_utility.trace(' Leaving standard_hours_worked' );
3285: --
3286: RETURN v_total_hours;
3287: --
3288: END standard_hours_worked;
3406: --
3407: e_bad_time_format EXCEPTION;
3408: --
3409: BEGIN
3410: hr_utility.set_location('Entering '||g_package||'.calc_sch_based_dur',10);
3411: p_duration := 0;
3412: l_time_start := p_time_start;
3413: l_time_end := p_time_end;
3414: --
3431: END IF;
3432: l_start_date := TO_DATE(TO_CHAR(p_date_start,'DD-MM-YYYY')||' '||l_time_start,'DD-MM-YYYY HH24:MI');
3433: l_end_date := TO_DATE(TO_CHAR(p_date_end,'DD-MM-YYYY')||' '||l_time_end,'DD-MM-YYYY HH24:MI');
3434:
3435: hr_utility.trace('p_assignment_id ' ||p_assignment_id);
3436: hr_utility.trace('l_start_date ' ||l_start_date);
3437: hr_utility.trace('l_end_date ' ||l_end_date);
3438: hr_utility.trace('p_time_start ' ||p_time_start);
3439: hr_utility.trace('p_time_end ' ||p_time_end);
3432: l_start_date := TO_DATE(TO_CHAR(p_date_start,'DD-MM-YYYY')||' '||l_time_start,'DD-MM-YYYY HH24:MI');
3433: l_end_date := TO_DATE(TO_CHAR(p_date_end,'DD-MM-YYYY')||' '||l_time_end,'DD-MM-YYYY HH24:MI');
3434:
3435: hr_utility.trace('p_assignment_id ' ||p_assignment_id);
3436: hr_utility.trace('l_start_date ' ||l_start_date);
3437: hr_utility.trace('l_end_date ' ||l_end_date);
3438: hr_utility.trace('p_time_start ' ||p_time_start);
3439: hr_utility.trace('p_time_end ' ||p_time_end);
3440: hr_utility.trace('p_days_or_hours ' ||p_days_or_hours);
3433: l_end_date := TO_DATE(TO_CHAR(p_date_end,'DD-MM-YYYY')||' '||l_time_end,'DD-MM-YYYY HH24:MI');
3434:
3435: hr_utility.trace('p_assignment_id ' ||p_assignment_id);
3436: hr_utility.trace('l_start_date ' ||l_start_date);
3437: hr_utility.trace('l_end_date ' ||l_end_date);
3438: hr_utility.trace('p_time_start ' ||p_time_start);
3439: hr_utility.trace('p_time_end ' ||p_time_end);
3440: hr_utility.trace('p_days_or_hours ' ||p_days_or_hours);
3441:
3434:
3435: hr_utility.trace('p_assignment_id ' ||p_assignment_id);
3436: hr_utility.trace('l_start_date ' ||l_start_date);
3437: hr_utility.trace('l_end_date ' ||l_end_date);
3438: hr_utility.trace('p_time_start ' ||p_time_start);
3439: hr_utility.trace('p_time_end ' ||p_time_end);
3440: hr_utility.trace('p_days_or_hours ' ||p_days_or_hours);
3441:
3442: --
3435: hr_utility.trace('p_assignment_id ' ||p_assignment_id);
3436: hr_utility.trace('l_start_date ' ||l_start_date);
3437: hr_utility.trace('l_end_date ' ||l_end_date);
3438: hr_utility.trace('p_time_start ' ||p_time_start);
3439: hr_utility.trace('p_time_end ' ||p_time_end);
3440: hr_utility.trace('p_days_or_hours ' ||p_days_or_hours);
3441:
3442: --
3443: -- Fetch the work schedule
3436: hr_utility.trace('l_start_date ' ||l_start_date);
3437: hr_utility.trace('l_end_date ' ||l_end_date);
3438: hr_utility.trace('p_time_start ' ||p_time_start);
3439: hr_utility.trace('p_time_end ' ||p_time_end);
3440: hr_utility.trace('p_days_or_hours ' ||p_days_or_hours);
3441:
3442: --
3443: -- Fetch the work schedule
3444: --
3455: , x_return_message => l_return_message
3456: );
3457: --
3458:
3459: hr_utility.trace('l_return_status ' ||l_return_status);
3460: IF l_return_status = '0' THEN
3461: --
3462: -- Calculate duration
3463: --
3461: --
3462: -- Calculate duration
3463: --
3464: l_idx := l_schedule.first;
3465: hr_utility.trace('l_idx ' || l_idx);
3466: hr_utility.trace('Schedule Counts ' ||l_schedule.count);
3467: --
3468: IF p_days_or_hours = 'D' THEN
3469: --
3462: -- Calculate duration
3463: --
3464: l_idx := l_schedule.first;
3465: hr_utility.trace('l_idx ' || l_idx);
3466: hr_utility.trace('Schedule Counts ' ||l_schedule.count);
3467: --
3468: IF p_days_or_hours = 'D' THEN
3469: --
3470: l_first_band := TRUE;
3495: l_day_start_time := '00:00';
3496: l_day_end_time := '23:59';
3497: WHILE l_idx IS NOT NULL
3498: LOOP
3499: hr_utility.trace('l_schedule(l_idx).FREE_BUSY_TYPE ' || l_schedule(l_idx).FREE_BUSY_TYPE );
3500: hr_utility.trace('l_schedule(l_idx).END_DATE_TIME ' || l_schedule(l_idx).END_DATE_TIME );
3501: hr_utility.trace('l_schedule(l_idx).START_DATE_TIME ' || l_schedule(l_idx).START_DATE_TIME );
3502:
3503: IF l_schedule(l_idx).FREE_BUSY_TYPE IS NOT NULL THEN
3496: l_day_end_time := '23:59';
3497: WHILE l_idx IS NOT NULL
3498: LOOP
3499: hr_utility.trace('l_schedule(l_idx).FREE_BUSY_TYPE ' || l_schedule(l_idx).FREE_BUSY_TYPE );
3500: hr_utility.trace('l_schedule(l_idx).END_DATE_TIME ' || l_schedule(l_idx).END_DATE_TIME );
3501: hr_utility.trace('l_schedule(l_idx).START_DATE_TIME ' || l_schedule(l_idx).START_DATE_TIME );
3502:
3503: IF l_schedule(l_idx).FREE_BUSY_TYPE IS NOT NULL THEN
3504: hr_utility.trace('l_schedule(l_idx).FREE_BUSY_TYPE is not null ' || l_schedule(l_idx).FREE_BUSY_TYPE );
3497: WHILE l_idx IS NOT NULL
3498: LOOP
3499: hr_utility.trace('l_schedule(l_idx).FREE_BUSY_TYPE ' || l_schedule(l_idx).FREE_BUSY_TYPE );
3500: hr_utility.trace('l_schedule(l_idx).END_DATE_TIME ' || l_schedule(l_idx).END_DATE_TIME );
3501: hr_utility.trace('l_schedule(l_idx).START_DATE_TIME ' || l_schedule(l_idx).START_DATE_TIME );
3502:
3503: IF l_schedule(l_idx).FREE_BUSY_TYPE IS NOT NULL THEN
3504: hr_utility.trace('l_schedule(l_idx).FREE_BUSY_TYPE is not null ' || l_schedule(l_idx).FREE_BUSY_TYPE );
3505: IF l_schedule(l_idx).FREE_BUSY_TYPE = 'FREE' THEN
3500: hr_utility.trace('l_schedule(l_idx).END_DATE_TIME ' || l_schedule(l_idx).END_DATE_TIME );
3501: hr_utility.trace('l_schedule(l_idx).START_DATE_TIME ' || l_schedule(l_idx).START_DATE_TIME );
3502:
3503: IF l_schedule(l_idx).FREE_BUSY_TYPE IS NOT NULL THEN
3504: hr_utility.trace('l_schedule(l_idx).FREE_BUSY_TYPE is not null ' || l_schedule(l_idx).FREE_BUSY_TYPE );
3505: IF l_schedule(l_idx).FREE_BUSY_TYPE = 'FREE' THEN
3506: hr_utility.trace('l_schedule(l_idx).FREE_BUSY_TYPE is FREE ' || l_schedule(l_idx).FREE_BUSY_TYPE );
3507: hr_utility.trace('l_schedule(l_idx).END_DATE_TIME ' || l_schedule(l_idx).END_DATE_TIME );
3508: hr_utility.trace('l_schedule(l_idx).START_DATE_TIME ' || l_schedule(l_idx).START_DATE_TIME );
3502:
3503: IF l_schedule(l_idx).FREE_BUSY_TYPE IS NOT NULL THEN
3504: hr_utility.trace('l_schedule(l_idx).FREE_BUSY_TYPE is not null ' || l_schedule(l_idx).FREE_BUSY_TYPE );
3505: IF l_schedule(l_idx).FREE_BUSY_TYPE = 'FREE' THEN
3506: hr_utility.trace('l_schedule(l_idx).FREE_BUSY_TYPE is FREE ' || l_schedule(l_idx).FREE_BUSY_TYPE );
3507: hr_utility.trace('l_schedule(l_idx).END_DATE_TIME ' || l_schedule(l_idx).END_DATE_TIME );
3508: hr_utility.trace('l_schedule(l_idx).START_DATE_TIME ' || l_schedule(l_idx).START_DATE_TIME );
3509: IF l_schedule(l_idx).END_DATE_TIME < l_schedule(l_idx).START_DATE_TIME THEN
3510: -- Skip this invalid slot which ends before it starts
3503: IF l_schedule(l_idx).FREE_BUSY_TYPE IS NOT NULL THEN
3504: hr_utility.trace('l_schedule(l_idx).FREE_BUSY_TYPE is not null ' || l_schedule(l_idx).FREE_BUSY_TYPE );
3505: IF l_schedule(l_idx).FREE_BUSY_TYPE = 'FREE' THEN
3506: hr_utility.trace('l_schedule(l_idx).FREE_BUSY_TYPE is FREE ' || l_schedule(l_idx).FREE_BUSY_TYPE );
3507: hr_utility.trace('l_schedule(l_idx).END_DATE_TIME ' || l_schedule(l_idx).END_DATE_TIME );
3508: hr_utility.trace('l_schedule(l_idx).START_DATE_TIME ' || l_schedule(l_idx).START_DATE_TIME );
3509: IF l_schedule(l_idx).END_DATE_TIME < l_schedule(l_idx).START_DATE_TIME THEN
3510: -- Skip this invalid slot which ends before it starts
3511: NULL;
3504: hr_utility.trace('l_schedule(l_idx).FREE_BUSY_TYPE is not null ' || l_schedule(l_idx).FREE_BUSY_TYPE );
3505: IF l_schedule(l_idx).FREE_BUSY_TYPE = 'FREE' THEN
3506: hr_utility.trace('l_schedule(l_idx).FREE_BUSY_TYPE is FREE ' || l_schedule(l_idx).FREE_BUSY_TYPE );
3507: hr_utility.trace('l_schedule(l_idx).END_DATE_TIME ' || l_schedule(l_idx).END_DATE_TIME );
3508: hr_utility.trace('l_schedule(l_idx).START_DATE_TIME ' || l_schedule(l_idx).START_DATE_TIME );
3509: IF l_schedule(l_idx).END_DATE_TIME < l_schedule(l_idx).START_DATE_TIME THEN
3510: -- Skip this invalid slot which ends before it starts
3511: NULL;
3512: ELSE
3514: -- Start and End on different days
3515: --
3516: -- Get first day hours
3517: l_start_time := TO_CHAR(l_schedule(l_idx).START_DATE_TIME,'HH24:MI');
3518: hr_utility.trace('l_start_time ' || l_start_time);
3519:
3520: SELECT p_duration + (((SUBSTR(l_day_end_time,1,2)*60 + SUBSTR(l_day_end_time,4,2)) -
3521: (SUBSTR(l_start_time,1,2)*60 + SUBSTR(l_start_time,4,2)))/60)
3522: INTO p_duration
3520: SELECT p_duration + (((SUBSTR(l_day_end_time,1,2)*60 + SUBSTR(l_day_end_time,4,2)) -
3521: (SUBSTR(l_start_time,1,2)*60 + SUBSTR(l_start_time,4,2)))/60)
3522: INTO p_duration
3523: FROM DUAL;
3524: -- hr_utility.trace('p_start_duration ' || p_start_duration);
3525: hr_utility.trace('Start p_duration ' || p_duration);
3526:
3527: --
3528: -- Get last day hours
3521: (SUBSTR(l_start_time,1,2)*60 + SUBSTR(l_start_time,4,2)))/60)
3522: INTO p_duration
3523: FROM DUAL;
3524: -- hr_utility.trace('p_start_duration ' || p_start_duration);
3525: hr_utility.trace('Start p_duration ' || p_duration);
3526:
3527: --
3528: -- Get last day hours
3529: l_end_time := TO_CHAR(l_schedule(l_idx).END_DATE_TIME,'HH24:MI');
3526:
3527: --
3528: -- Get last day hours
3529: l_end_time := TO_CHAR(l_schedule(l_idx).END_DATE_TIME,'HH24:MI');
3530: hr_utility.trace('l_end_time ' || l_end_time);
3531: SELECT p_duration + (((SUBSTR(l_end_time,1,2)*60 + SUBSTR(l_end_time,4,2)) -
3532: (SUBSTR(l_day_start_time,1,2)*60 + SUBSTR(l_day_start_time,4,2)) + 1)/60)
3533: INTO p_duration
3534: FROM DUAL;
3531: SELECT p_duration + (((SUBSTR(l_end_time,1,2)*60 + SUBSTR(l_end_time,4,2)) -
3532: (SUBSTR(l_day_start_time,1,2)*60 + SUBSTR(l_day_start_time,4,2)) + 1)/60)
3533: INTO p_duration
3534: FROM DUAL;
3535: --hr_utility.trace('p_end_duration ' || p_end_duration);
3536: hr_utility.trace('End p_duration ' || p_duration);
3537: --
3538: -- Get between full day hours
3539: SELECT p_duration + ((TRUNC(l_schedule(l_idx).END_DATE_TIME) - TRUNC(l_schedule(l_idx).START_DATE_TIME) - 1) * 24)
3532: (SUBSTR(l_day_start_time,1,2)*60 + SUBSTR(l_day_start_time,4,2)) + 1)/60)
3533: INTO p_duration
3534: FROM DUAL;
3535: --hr_utility.trace('p_end_duration ' || p_end_duration);
3536: hr_utility.trace('End p_duration ' || p_duration);
3537: --
3538: -- Get between full day hours
3539: SELECT p_duration + ((TRUNC(l_schedule(l_idx).END_DATE_TIME) - TRUNC(l_schedule(l_idx).START_DATE_TIME) - 1) * 24)
3540: INTO p_duration
3543: -- Start and End on same day
3544: l_start_time := TO_CHAR(l_schedule(l_idx).START_DATE_TIME,'HH24:MI');
3545: l_end_time := TO_CHAR(l_schedule(l_idx).END_DATE_TIME,'HH24:MI');
3546:
3547: hr_utility.trace('l_start_time ' || l_start_time);
3548: hr_utility.trace('l_end_time ' || l_end_time);
3549:
3550: SELECT p_duration + (((SUBSTR(l_end_time,1,2)*60 + SUBSTR(l_end_time,4,2)) -
3551: (SUBSTR(l_start_time,1,2)*60 + SUBSTR(l_start_time,4,2)))/60)
3544: l_start_time := TO_CHAR(l_schedule(l_idx).START_DATE_TIME,'HH24:MI');
3545: l_end_time := TO_CHAR(l_schedule(l_idx).END_DATE_TIME,'HH24:MI');
3546:
3547: hr_utility.trace('l_start_time ' || l_start_time);
3548: hr_utility.trace('l_end_time ' || l_end_time);
3549:
3550: SELECT p_duration + (((SUBSTR(l_end_time,1,2)*60 + SUBSTR(l_end_time,4,2)) -
3551: (SUBSTR(l_start_time,1,2)*60 + SUBSTR(l_start_time,4,2)))/60)
3552: INTO p_duration
3550: SELECT p_duration + (((SUBSTR(l_end_time,1,2)*60 + SUBSTR(l_end_time,4,2)) -
3551: (SUBSTR(l_start_time,1,2)*60 + SUBSTR(l_start_time,4,2)))/60)
3552: INTO p_duration
3553: FROM DUAL;
3554: hr_utility.trace('duration l_idx '||l_idx||' ' ||p_duration);
3555:
3556: END IF;
3557: END IF;
3558: END IF;
3558: END IF;
3559: END IF;
3560: l_idx := l_schedule(l_idx).NEXT_OBJECT_INDEX;
3561: END LOOP;
3562: hr_utility.trace('duration ' ||p_duration);
3563:
3564: p_duration := ROUND(p_duration,2);
3565: --
3566: END IF;
3565: --
3566: END IF;
3567: END IF;
3568: --
3569: hr_utility.set_location('Leaving '||g_package||'.calc_sch_based_dur',20);
3570: EXCEPTION
3571: --
3572: WHEN e_bad_time_format THEN
3573: hr_utility.set_location('Leaving '||g_package||'.calc_sch_based_dur',30);
3569: hr_utility.set_location('Leaving '||g_package||'.calc_sch_based_dur',20);
3570: EXCEPTION
3571: --
3572: WHEN e_bad_time_format THEN
3573: hr_utility.set_location('Leaving '||g_package||'.calc_sch_based_dur',30);
3574: hr_utility.set_location(SQLERRM,35);
3575: RAISE;
3576: --
3577: WHEN OTHERS THEN
3570: EXCEPTION
3571: --
3572: WHEN e_bad_time_format THEN
3573: hr_utility.set_location('Leaving '||g_package||'.calc_sch_based_dur',30);
3574: hr_utility.set_location(SQLERRM,35);
3575: RAISE;
3576: --
3577: WHEN OTHERS THEN
3578: hr_utility.set_location('Leaving '||g_package||'.calc_sch_based_dur',40);
3574: hr_utility.set_location(SQLERRM,35);
3575: RAISE;
3576: --
3577: WHEN OTHERS THEN
3578: hr_utility.set_location('Leaving '||g_package||'.calc_sch_based_dur',40);
3579: hr_utility.set_location(SQLERRM,45);
3580: RAISE;
3581: --
3582: END calc_sch_based_dur;
3575: RAISE;
3576: --
3577: WHEN OTHERS THEN
3578: hr_utility.set_location('Leaving '||g_package||'.calc_sch_based_dur',40);
3579: hr_utility.set_location(SQLERRM,45);
3580: RAISE;
3581: --
3582: END calc_sch_based_dur;
3583:
3620:
3621: BEGIN
3622: l_work_schedule_found := FALSE;
3623: l_total_hours := 0;
3624: -- hr_utility.trace_on(NULL, 'PAY_CALC_HOURS_WORKED');
3625: hr_utility.trace( 'Assignment Id '||assignment_id);
3626: hr_utility.trace( 'date_earned '||date_earned);
3627: hr_utility.trace( 'p_days_or_hours '||p_days_or_hours);
3628: hr_utility.trace( 'p_period_start_date '||p_period_start_date);
3621: BEGIN
3622: l_work_schedule_found := FALSE;
3623: l_total_hours := 0;
3624: -- hr_utility.trace_on(NULL, 'PAY_CALC_HOURS_WORKED');
3625: hr_utility.trace( 'Assignment Id '||assignment_id);
3626: hr_utility.trace( 'date_earned '||date_earned);
3627: hr_utility.trace( 'p_days_or_hours '||p_days_or_hours);
3628: hr_utility.trace( 'p_period_start_date '||p_period_start_date);
3629: hr_utility.trace( 'p_period_end_date '||p_period_end_date);
3622: l_work_schedule_found := FALSE;
3623: l_total_hours := 0;
3624: -- hr_utility.trace_on(NULL, 'PAY_CALC_HOURS_WORKED');
3625: hr_utility.trace( 'Assignment Id '||assignment_id);
3626: hr_utility.trace( 'date_earned '||date_earned);
3627: hr_utility.trace( 'p_days_or_hours '||p_days_or_hours);
3628: hr_utility.trace( 'p_period_start_date '||p_period_start_date);
3629: hr_utility.trace( 'p_period_end_date '||p_period_end_date);
3630: hr_utility.trace( 'p_legislation_code '||p_legislation_code);
3623: l_total_hours := 0;
3624: -- hr_utility.trace_on(NULL, 'PAY_CALC_HOURS_WORKED');
3625: hr_utility.trace( 'Assignment Id '||assignment_id);
3626: hr_utility.trace( 'date_earned '||date_earned);
3627: hr_utility.trace( 'p_days_or_hours '||p_days_or_hours);
3628: hr_utility.trace( 'p_period_start_date '||p_period_start_date);
3629: hr_utility.trace( 'p_period_end_date '||p_period_end_date);
3630: hr_utility.trace( 'p_legislation_code '||p_legislation_code);
3631:
3624: -- hr_utility.trace_on(NULL, 'PAY_CALC_HOURS_WORKED');
3625: hr_utility.trace( 'Assignment Id '||assignment_id);
3626: hr_utility.trace( 'date_earned '||date_earned);
3627: hr_utility.trace( 'p_days_or_hours '||p_days_or_hours);
3628: hr_utility.trace( 'p_period_start_date '||p_period_start_date);
3629: hr_utility.trace( 'p_period_end_date '||p_period_end_date);
3630: hr_utility.trace( 'p_legislation_code '||p_legislation_code);
3631:
3632: IF (p_legislation_code) IS NULL or (p_legislation_code ='') or
3625: hr_utility.trace( 'Assignment Id '||assignment_id);
3626: hr_utility.trace( 'date_earned '||date_earned);
3627: hr_utility.trace( 'p_days_or_hours '||p_days_or_hours);
3628: hr_utility.trace( 'p_period_start_date '||p_period_start_date);
3629: hr_utility.trace( 'p_period_end_date '||p_period_end_date);
3630: hr_utility.trace( 'p_legislation_code '||p_legislation_code);
3631:
3632: IF (p_legislation_code) IS NULL or (p_legislation_code ='') or
3633: (g_legislation_code IS NULL) THEN
3626: hr_utility.trace( 'date_earned '||date_earned);
3627: hr_utility.trace( 'p_days_or_hours '||p_days_or_hours);
3628: hr_utility.trace( 'p_period_start_date '||p_period_start_date);
3629: hr_utility.trace( 'p_period_end_date '||p_period_end_date);
3630: hr_utility.trace( 'p_legislation_code '||p_legislation_code);
3631:
3632: IF (p_legislation_code) IS NULL or (p_legislation_code ='') or
3633: (g_legislation_code IS NULL) THEN
3634: g_legislation_code := get_legislation_code(business_group_id);
3635: ELSE
3636: g_legislation_code := nvl(g_legislation_code,p_legislation_code);
3637: END IF;
3638:
3639: hr_utility.trace( 'Legislation code : g_legislation_code '||g_legislation_code);
3640:
3641: /* Calculate hours worked based on ATG work schedule information using
3642: API : HR_WRK_SCH_PKG.GET_PER_ASG_SCHEDULE ()
3643: This part will be coded later once this API is available from HR
3644: IF p_include_exceptions IS NULL THEN
3645: use p_include_exceptions = 'Y';
3646:
3647: */
3648: hr_utility.trace( 'getting work schedule from ATG ');
3649:
3650: calc_sch_based_dur ( p_days_or_hours,
3651: p_period_start_date,
3652: p_period_end_date+1,
3658:
3659:
3660: IF (l_duration > 0) THEN
3661: l_work_schedule_found := true;
3662: hr_utility.trace( 'Got work schedule from ATG,duration : '||l_duration);
3663:
3664: return l_duration;
3665: END IF;
3666:
3665: END IF;
3666:
3667: IF NOT l_work_schedule_found THEN
3668: BEGIN
3669: hr_utility.trace( 'getting work schedule from SCL ');
3670: lv_wk_sch_found := 'FALSE';
3671: EXECUTE IMMEDIATE 'BEGIN :1 := PAY_'||g_legislation_code||
3672: '_RULES.Work_Schedule_Total_Hours(:2,:3,:4,:5,:6,:7,:8,:9); END;'
3673: USING OUT l_total_hours,
3674: IN assignment_action_id,IN assignment_id,IN business_group_id,IN element_entry_id
3675: ,IN date_earned,IN p_period_start_date,IN p_period_end_date,IN OUT lv_wk_sch_found;
3676: /*
3677: IF l_total_hours > 0 THEN
3678: hr_utility.trace( 'work schedule found from SCL ');
3679: l_work_schedule_found := TRUE;
3680: return l_total_hours;
3681: END IF;
3682: */
3686: -- total hours returned by work schedule may be zero for the FLSA
3687: -- or pro ration period.
3688:
3689: IF lv_wk_sch_found = 'TRUE' THEN
3690: hr_utility.trace( 'work schedule found from SCL ');
3691: l_work_schedule_found := TRUE;
3692: return l_total_hours;
3693: END IF;
3694:
3704: worked are not available from either ATG work schedule or work schedule
3705: at assignment/org level */
3706:
3707: IF NOT l_work_schedule_found THEN
3708: hr_utility.trace('Calculating hours based on Standard conditions ');
3709: hr_utility.trace( 'Assignment Id '||assignment_id);
3710: hr_utility.trace( 'date_earned '||date_earned);
3711: OPEN get_asg_hours_freq(date_earned,assignment_id);
3712: FETCH get_asg_hours_freq
3705: at assignment/org level */
3706:
3707: IF NOT l_work_schedule_found THEN
3708: hr_utility.trace('Calculating hours based on Standard conditions ');
3709: hr_utility.trace( 'Assignment Id '||assignment_id);
3710: hr_utility.trace( 'date_earned '||date_earned);
3711: OPEN get_asg_hours_freq(date_earned,assignment_id);
3712: FETCH get_asg_hours_freq
3713: INTO l_asg_frequency, l_normal_hours;
3706:
3707: IF NOT l_work_schedule_found THEN
3708: hr_utility.trace('Calculating hours based on Standard conditions ');
3709: hr_utility.trace( 'Assignment Id '||assignment_id);
3710: hr_utility.trace( 'date_earned '||date_earned);
3711: OPEN get_asg_hours_freq(date_earned,assignment_id);
3712: FETCH get_asg_hours_freq
3713: INTO l_asg_frequency, l_normal_hours;
3714: CLOSE get_asg_hours_freq;
3712: FETCH get_asg_hours_freq
3713: INTO l_asg_frequency, l_normal_hours;
3714: CLOSE get_asg_hours_freq;
3715:
3716: hr_utility.trace( 'l_asg_frequency '||l_asg_frequency);
3717: hr_utility.trace( 'l_normal_hours '||l_normal_hours);
3718:
3719: IF l_asg_frequency IS NOT NULL and l_normal_hours IS NOT NULL THEN
3720: l_total_hours := standard_hours_worked(l_normal_hours
3713: INTO l_asg_frequency, l_normal_hours;
3714: CLOSE get_asg_hours_freq;
3715:
3716: hr_utility.trace( 'l_asg_frequency '||l_asg_frequency);
3717: hr_utility.trace( 'l_normal_hours '||l_normal_hours);
3718:
3719: IF l_asg_frequency IS NOT NULL and l_normal_hours IS NOT NULL THEN
3720: l_total_hours := standard_hours_worked(l_normal_hours
3721: ,p_period_start_date
3725: END IF;
3726:
3727: END IF;
3728: return 0;
3729: -- hr_utility.trace_off;
3730: END calculate_actual_hours_worked;
3731:
3732: -- Added For Skip Rule for "Regular Wages" Element, "REGULAR_PAY"
3733:
3832: ld_lsp_dt_earned date;
3833:
3834: begin
3835:
3836: hr_utility.trace('ctx_date_earned := '|| to_char(ctx_date_earned));
3837: hr_utility.trace('ctx_payroll_id := '|| ctx_payroll_id);
3838: hr_utility.trace('ctx_assignment_id := '|| ctx_assignment_id);
3839: hr_utility.trace('p_user_entered_time := '|| p_user_entered_time);
3840: hr_utility.trace('p_final_pay_processed := '|| p_final_pay_processed);
3833:
3834: begin
3835:
3836: hr_utility.trace('ctx_date_earned := '|| to_char(ctx_date_earned));
3837: hr_utility.trace('ctx_payroll_id := '|| ctx_payroll_id);
3838: hr_utility.trace('ctx_assignment_id := '|| ctx_assignment_id);
3839: hr_utility.trace('p_user_entered_time := '|| p_user_entered_time);
3840: hr_utility.trace('p_final_pay_processed := '|| p_final_pay_processed);
3841: hr_utility.trace('p_lspd_pay_processed := '|| p_lspd_pay_processed);
3834: begin
3835:
3836: hr_utility.trace('ctx_date_earned := '|| to_char(ctx_date_earned));
3837: hr_utility.trace('ctx_payroll_id := '|| ctx_payroll_id);
3838: hr_utility.trace('ctx_assignment_id := '|| ctx_assignment_id);
3839: hr_utility.trace('p_user_entered_time := '|| p_user_entered_time);
3840: hr_utility.trace('p_final_pay_processed := '|| p_final_pay_processed);
3841: hr_utility.trace('p_lspd_pay_processed := '|| p_lspd_pay_processed);
3842: hr_utility.trace('p_payroll_termination_type := '|| p_payroll_termination_type);
3835:
3836: hr_utility.trace('ctx_date_earned := '|| to_char(ctx_date_earned));
3837: hr_utility.trace('ctx_payroll_id := '|| ctx_payroll_id);
3838: hr_utility.trace('ctx_assignment_id := '|| ctx_assignment_id);
3839: hr_utility.trace('p_user_entered_time := '|| p_user_entered_time);
3840: hr_utility.trace('p_final_pay_processed := '|| p_final_pay_processed);
3841: hr_utility.trace('p_lspd_pay_processed := '|| p_lspd_pay_processed);
3842: hr_utility.trace('p_payroll_termination_type := '|| p_payroll_termination_type);
3843: hr_utility.trace('p_bg_termination_type := '|| p_bg_termination_type);
3836: hr_utility.trace('ctx_date_earned := '|| to_char(ctx_date_earned));
3837: hr_utility.trace('ctx_payroll_id := '|| ctx_payroll_id);
3838: hr_utility.trace('ctx_assignment_id := '|| ctx_assignment_id);
3839: hr_utility.trace('p_user_entered_time := '|| p_user_entered_time);
3840: hr_utility.trace('p_final_pay_processed := '|| p_final_pay_processed);
3841: hr_utility.trace('p_lspd_pay_processed := '|| p_lspd_pay_processed);
3842: hr_utility.trace('p_payroll_termination_type := '|| p_payroll_termination_type);
3843: hr_utility.trace('p_bg_termination_type := '|| p_bg_termination_type);
3844: hr_utility.trace('p_already_processed := '|| p_already_processed);
3837: hr_utility.trace('ctx_payroll_id := '|| ctx_payroll_id);
3838: hr_utility.trace('ctx_assignment_id := '|| ctx_assignment_id);
3839: hr_utility.trace('p_user_entered_time := '|| p_user_entered_time);
3840: hr_utility.trace('p_final_pay_processed := '|| p_final_pay_processed);
3841: hr_utility.trace('p_lspd_pay_processed := '|| p_lspd_pay_processed);
3842: hr_utility.trace('p_payroll_termination_type := '|| p_payroll_termination_type);
3843: hr_utility.trace('p_bg_termination_type := '|| p_bg_termination_type);
3844: hr_utility.trace('p_already_processed := '|| p_already_processed);
3845:
3838: hr_utility.trace('ctx_assignment_id := '|| ctx_assignment_id);
3839: hr_utility.trace('p_user_entered_time := '|| p_user_entered_time);
3840: hr_utility.trace('p_final_pay_processed := '|| p_final_pay_processed);
3841: hr_utility.trace('p_lspd_pay_processed := '|| p_lspd_pay_processed);
3842: hr_utility.trace('p_payroll_termination_type := '|| p_payroll_termination_type);
3843: hr_utility.trace('p_bg_termination_type := '|| p_bg_termination_type);
3844: hr_utility.trace('p_already_processed := '|| p_already_processed);
3845:
3846: OPEN csr_pay_period(ctx_date_earned
3839: hr_utility.trace('p_user_entered_time := '|| p_user_entered_time);
3840: hr_utility.trace('p_final_pay_processed := '|| p_final_pay_processed);
3841: hr_utility.trace('p_lspd_pay_processed := '|| p_lspd_pay_processed);
3842: hr_utility.trace('p_payroll_termination_type := '|| p_payroll_termination_type);
3843: hr_utility.trace('p_bg_termination_type := '|| p_bg_termination_type);
3844: hr_utility.trace('p_already_processed := '|| p_already_processed);
3845:
3846: OPEN csr_pay_period(ctx_date_earned
3847: ,ctx_payroll_id) ;
3840: hr_utility.trace('p_final_pay_processed := '|| p_final_pay_processed);
3841: hr_utility.trace('p_lspd_pay_processed := '|| p_lspd_pay_processed);
3842: hr_utility.trace('p_payroll_termination_type := '|| p_payroll_termination_type);
3843: hr_utility.trace('p_bg_termination_type := '|| p_bg_termination_type);
3844: hr_utility.trace('p_already_processed := '|| p_already_processed);
3845:
3846: OPEN csr_pay_period(ctx_date_earned
3847: ,ctx_payroll_id) ;
3848: FETCH csr_pay_period INTO ld_pay_start_date
3869: lv_term_typ := 'L';
3870: END IF;
3871: END IF;
3872:
3873: hr_utility.trace('ld_pay_start_date := '|| to_char(ld_pay_start_date));
3874: hr_utility.trace('ld_pay_end_date := '|| to_char(ld_pay_end_date));
3875: hr_utility.trace('ld_atd := '|| to_char(ld_atd));
3876: hr_utility.trace('ld_lspd := '|| to_char(ld_lspd));
3877: hr_utility.trace('ld_fpd := '|| to_char(ld_fpd));
3870: END IF;
3871: END IF;
3872:
3873: hr_utility.trace('ld_pay_start_date := '|| to_char(ld_pay_start_date));
3874: hr_utility.trace('ld_pay_end_date := '|| to_char(ld_pay_end_date));
3875: hr_utility.trace('ld_atd := '|| to_char(ld_atd));
3876: hr_utility.trace('ld_lspd := '|| to_char(ld_lspd));
3877: hr_utility.trace('ld_fpd := '|| to_char(ld_fpd));
3878: hr_utility.trace('lv_term_typ := '|| lv_term_typ);
3871: END IF;
3872:
3873: hr_utility.trace('ld_pay_start_date := '|| to_char(ld_pay_start_date));
3874: hr_utility.trace('ld_pay_end_date := '|| to_char(ld_pay_end_date));
3875: hr_utility.trace('ld_atd := '|| to_char(ld_atd));
3876: hr_utility.trace('ld_lspd := '|| to_char(ld_lspd));
3877: hr_utility.trace('ld_fpd := '|| to_char(ld_fpd));
3878: hr_utility.trace('lv_term_typ := '|| lv_term_typ);
3879:
3872:
3873: hr_utility.trace('ld_pay_start_date := '|| to_char(ld_pay_start_date));
3874: hr_utility.trace('ld_pay_end_date := '|| to_char(ld_pay_end_date));
3875: hr_utility.trace('ld_atd := '|| to_char(ld_atd));
3876: hr_utility.trace('ld_lspd := '|| to_char(ld_lspd));
3877: hr_utility.trace('ld_fpd := '|| to_char(ld_fpd));
3878: hr_utility.trace('lv_term_typ := '|| lv_term_typ);
3879:
3880: IF lv_term_typ = 'A' THEN -- Termination Rule 'First Pay After Term Date'
3873: hr_utility.trace('ld_pay_start_date := '|| to_char(ld_pay_start_date));
3874: hr_utility.trace('ld_pay_end_date := '|| to_char(ld_pay_end_date));
3875: hr_utility.trace('ld_atd := '|| to_char(ld_atd));
3876: hr_utility.trace('ld_lspd := '|| to_char(ld_lspd));
3877: hr_utility.trace('ld_fpd := '|| to_char(ld_fpd));
3878: hr_utility.trace('lv_term_typ := '|| lv_term_typ);
3879:
3880: IF lv_term_typ = 'A' THEN -- Termination Rule 'First Pay After Term Date'
3881: IF ld_atd <= ctx_date_earned THEN
3874: hr_utility.trace('ld_pay_end_date := '|| to_char(ld_pay_end_date));
3875: hr_utility.trace('ld_atd := '|| to_char(ld_atd));
3876: hr_utility.trace('ld_lspd := '|| to_char(ld_lspd));
3877: hr_utility.trace('ld_fpd := '|| to_char(ld_fpd));
3878: hr_utility.trace('lv_term_typ := '|| lv_term_typ);
3879:
3880: IF lv_term_typ = 'A' THEN -- Termination Rule 'First Pay After Term Date'
3881: IF ld_atd <= ctx_date_earned THEN
3882: IF p_final_pay_processed = 'Y' THEN
3884: ,ctx_assignment_id);
3885: FETCH csr_fpprocd_min_dtearned INTO ld_fp_dt_earned;
3886: CLOSE csr_fpprocd_min_dtearned;
3887:
3888: hr_utility.trace('ld_fp_dt_earned := '|| TO_CHAR(ld_fp_dt_earned));
3889:
3890: IF ctx_date_earned > ld_fp_dt_earned THEN
3891: return 'Y';
3892: ELSE
3935: ,ctx_assignment_id);
3936: FETCH csr_lspprocd_min_dtearned INTO ld_lsp_dt_earned;
3937: CLOSE csr_lspprocd_min_dtearned;
3938:
3939: hr_utility.trace('ld_fp_dt_earned := '|| TO_CHAR(ld_lsp_dt_earned));
3940:
3941: IF ctx_date_earned > ld_lsp_dt_earned THEN
3942: return 'Y';
3943: ELSE
4021: and ASSIGN.assignment_id = p_assignment_id;
4022:
4023:
4024: BEGIN
4025: hr_utility.trace('Entering Into hours_between.');
4026: l_work_schedule_found := FALSE;
4027: l_total_hours := 0;
4028:
4029: hr_utility.trace( 'Assignment Id '||assignment_id);
4025: hr_utility.trace('Entering Into hours_between.');
4026: l_work_schedule_found := FALSE;
4027: l_total_hours := 0;
4028:
4029: hr_utility.trace( 'Assignment Id '||assignment_id);
4030: hr_utility.trace( 'date_earned '||date_earned);
4031: hr_utility.trace( 'p_days_or_hours '||p_days_or_hours);
4032: hr_utility.trace( 'p_period_start_date '||p_period_start_date);
4033: hr_utility.trace( 'p_period_end_date '||p_period_end_date);
4026: l_work_schedule_found := FALSE;
4027: l_total_hours := 0;
4028:
4029: hr_utility.trace( 'Assignment Id '||assignment_id);
4030: hr_utility.trace( 'date_earned '||date_earned);
4031: hr_utility.trace( 'p_days_or_hours '||p_days_or_hours);
4032: hr_utility.trace( 'p_period_start_date '||p_period_start_date);
4033: hr_utility.trace( 'p_period_end_date '||p_period_end_date);
4034: hr_utility.trace( 'p_legislation_code '||p_legislation_code);
4027: l_total_hours := 0;
4028:
4029: hr_utility.trace( 'Assignment Id '||assignment_id);
4030: hr_utility.trace( 'date_earned '||date_earned);
4031: hr_utility.trace( 'p_days_or_hours '||p_days_or_hours);
4032: hr_utility.trace( 'p_period_start_date '||p_period_start_date);
4033: hr_utility.trace( 'p_period_end_date '||p_period_end_date);
4034: hr_utility.trace( 'p_legislation_code '||p_legislation_code);
4035:
4028:
4029: hr_utility.trace( 'Assignment Id '||assignment_id);
4030: hr_utility.trace( 'date_earned '||date_earned);
4031: hr_utility.trace( 'p_days_or_hours '||p_days_or_hours);
4032: hr_utility.trace( 'p_period_start_date '||p_period_start_date);
4033: hr_utility.trace( 'p_period_end_date '||p_period_end_date);
4034: hr_utility.trace( 'p_legislation_code '||p_legislation_code);
4035:
4036: IF (p_legislation_code) IS NULL or (p_legislation_code ='') or
4029: hr_utility.trace( 'Assignment Id '||assignment_id);
4030: hr_utility.trace( 'date_earned '||date_earned);
4031: hr_utility.trace( 'p_days_or_hours '||p_days_or_hours);
4032: hr_utility.trace( 'p_period_start_date '||p_period_start_date);
4033: hr_utility.trace( 'p_period_end_date '||p_period_end_date);
4034: hr_utility.trace( 'p_legislation_code '||p_legislation_code);
4035:
4036: IF (p_legislation_code) IS NULL or (p_legislation_code ='') or
4037: (g_legislation_code IS NULL) THEN
4030: hr_utility.trace( 'date_earned '||date_earned);
4031: hr_utility.trace( 'p_days_or_hours '||p_days_or_hours);
4032: hr_utility.trace( 'p_period_start_date '||p_period_start_date);
4033: hr_utility.trace( 'p_period_end_date '||p_period_end_date);
4034: hr_utility.trace( 'p_legislation_code '||p_legislation_code);
4035:
4036: IF (p_legislation_code) IS NULL or (p_legislation_code ='') or
4037: (g_legislation_code IS NULL) THEN
4038: g_legislation_code := get_legislation_code(business_group_id);
4039: ELSE
4040: g_legislation_code := nvl(g_legislation_code,p_legislation_code);
4041: END IF;
4042:
4043: hr_utility.trace( 'Legislation code : g_legislation_code '||g_legislation_code);
4044:
4045: /* Calculate hours worked based on ATG work schedule information using
4046: API : HR_WRK_SCH_PKG.GET_PER_ASG_SCHEDULE ()
4047: This part will be coded later once this API is available from HR
4049: use p_include_exceptions = 'Y';
4050:
4051: */
4052:
4053: hr_utility.trace( 'getting work schedule from ATG ');
4054:
4055: calc_sch_based_dur ( p_days_or_hours,
4056: p_period_start_date,
4057: p_period_end_date+1,
4063:
4064:
4065: IF (l_duration > 0) THEN
4066: l_work_schedule_found := true;
4067: hr_utility.trace( 'Got work schedule from ATG,duration : '||l_duration);
4068: pay_core_ff_udfs.g_normal_hours := l_duration;
4069: return l_duration;
4070: END IF;
4071:
4070: END IF;
4071:
4072: IF NOT l_work_schedule_found THEN
4073: BEGIN
4074: hr_utility.trace( 'getting work schedule from SCL ');
4075: lv_wk_sch_found := 'FALSE';
4076: EXECUTE IMMEDIATE 'BEGIN :1 := PAY_'||g_legislation_code||
4077: '_RULES.Work_Schedule_Total_Hours(:2,:3,:4,:5,:6,:7,:8,:9); END;'
4078: USING OUT l_total_hours,
4079: IN assignment_action_id,IN assignment_id,IN business_group_id,IN element_entry_id
4080: ,IN date_earned,IN p_period_start_date,IN p_period_end_date,IN OUT lv_wk_sch_found;
4081:
4082: IF lv_wk_sch_found = 'TRUE' THEN
4083: hr_utility.trace( 'work schedule found from SCL ');
4084: l_work_schedule_found := TRUE;
4085: pay_core_ff_udfs.g_normal_hours := l_total_hours;
4086: return l_total_hours;
4087: END IF;
4097: worked are not available from either ATG work schedule or work schedule
4098: at assignment/org level */
4099:
4100: IF NOT l_work_schedule_found THEN
4101: hr_utility.trace('Calculating hours based on Standard conditions ');
4102: hr_utility.trace( 'Assignment Id '||assignment_id);
4103: hr_utility.trace( 'date_earned '||date_earned);
4104: OPEN get_asg_hours_freq(date_earned,assignment_id);
4105: FETCH get_asg_hours_freq
4098: at assignment/org level */
4099:
4100: IF NOT l_work_schedule_found THEN
4101: hr_utility.trace('Calculating hours based on Standard conditions ');
4102: hr_utility.trace( 'Assignment Id '||assignment_id);
4103: hr_utility.trace( 'date_earned '||date_earned);
4104: OPEN get_asg_hours_freq(date_earned,assignment_id);
4105: FETCH get_asg_hours_freq
4106: INTO l_asg_frequency, l_normal_hours;
4099:
4100: IF NOT l_work_schedule_found THEN
4101: hr_utility.trace('Calculating hours based on Standard conditions ');
4102: hr_utility.trace( 'Assignment Id '||assignment_id);
4103: hr_utility.trace( 'date_earned '||date_earned);
4104: OPEN get_asg_hours_freq(date_earned,assignment_id);
4105: FETCH get_asg_hours_freq
4106: INTO l_asg_frequency, l_normal_hours;
4107: CLOSE get_asg_hours_freq;
4105: FETCH get_asg_hours_freq
4106: INTO l_asg_frequency, l_normal_hours;
4107: CLOSE get_asg_hours_freq;
4108:
4109: hr_utility.trace( 'l_asg_frequency '||l_asg_frequency);
4110: hr_utility.trace( 'l_normal_hours '||l_normal_hours);
4111:
4112: IF l_asg_frequency IS NOT NULL and pay_core_ff_udfs.g_normal_hours IS NOT NULL THEN
4113: l_total_hours := standard_hours_worked(l_normal_hours
4106: INTO l_asg_frequency, l_normal_hours;
4107: CLOSE get_asg_hours_freq;
4108:
4109: hr_utility.trace( 'l_asg_frequency '||l_asg_frequency);
4110: hr_utility.trace( 'l_normal_hours '||l_normal_hours);
4111:
4112: IF l_asg_frequency IS NOT NULL and pay_core_ff_udfs.g_normal_hours IS NOT NULL THEN
4113: l_total_hours := standard_hours_worked(l_normal_hours
4114: ,p_period_start_date
4118: END IF;
4119:
4120: END IF;
4121: return 0;
4122: -- hr_utility.trace_off;
4123: END hours_between;
4124:
4125: --
4126: -- Introduced for Enabling Core Proration Functionality into
4190: -- Return immediately when no sick time has been taken.
4191:
4192: BEGIN
4193:
4194: hr_utility.trace('Entered calc_sick_pay');
4195: hr_utility.trace('Passed ctx_asg_id := ' || ctx_asg_id);
4196: hr_utility.trace('Passed p_period_end_dt := ' || TO_CHAR(p_period_end_dt));
4197: hr_utility.trace('Passed p_prorate_start_dt := ' || TO_CHAR(p_prorate_start_dt));
4198: hr_utility.trace('Passed p_prorate_end_dt := ' || TO_CHAR(p_prorate_end_dt));
4191:
4192: BEGIN
4193:
4194: hr_utility.trace('Entered calc_sick_pay');
4195: hr_utility.trace('Passed ctx_asg_id := ' || ctx_asg_id);
4196: hr_utility.trace('Passed p_period_end_dt := ' || TO_CHAR(p_period_end_dt));
4197: hr_utility.trace('Passed p_prorate_start_dt := ' || TO_CHAR(p_prorate_start_dt));
4198: hr_utility.trace('Passed p_prorate_end_dt := ' || TO_CHAR(p_prorate_end_dt));
4199: hr_utility.trace('Passed p_curr_rate := ' || p_curr_rate);
4192: BEGIN
4193:
4194: hr_utility.trace('Entered calc_sick_pay');
4195: hr_utility.trace('Passed ctx_asg_id := ' || ctx_asg_id);
4196: hr_utility.trace('Passed p_period_end_dt := ' || TO_CHAR(p_period_end_dt));
4197: hr_utility.trace('Passed p_prorate_start_dt := ' || TO_CHAR(p_prorate_start_dt));
4198: hr_utility.trace('Passed p_prorate_end_dt := ' || TO_CHAR(p_prorate_end_dt));
4199: hr_utility.trace('Passed p_curr_rate := ' || p_curr_rate);
4200: hr_utility.trace('Passed p_sick_hours := ' || p_sick_hours);
4193:
4194: hr_utility.trace('Entered calc_sick_pay');
4195: hr_utility.trace('Passed ctx_asg_id := ' || ctx_asg_id);
4196: hr_utility.trace('Passed p_period_end_dt := ' || TO_CHAR(p_period_end_dt));
4197: hr_utility.trace('Passed p_prorate_start_dt := ' || TO_CHAR(p_prorate_start_dt));
4198: hr_utility.trace('Passed p_prorate_end_dt := ' || TO_CHAR(p_prorate_end_dt));
4199: hr_utility.trace('Passed p_curr_rate := ' || p_curr_rate);
4200: hr_utility.trace('Passed p_sick_hours := ' || p_sick_hours);
4201:
4194: hr_utility.trace('Entered calc_sick_pay');
4195: hr_utility.trace('Passed ctx_asg_id := ' || ctx_asg_id);
4196: hr_utility.trace('Passed p_period_end_dt := ' || TO_CHAR(p_period_end_dt));
4197: hr_utility.trace('Passed p_prorate_start_dt := ' || TO_CHAR(p_prorate_start_dt));
4198: hr_utility.trace('Passed p_prorate_end_dt := ' || TO_CHAR(p_prorate_end_dt));
4199: hr_utility.trace('Passed p_curr_rate := ' || p_curr_rate);
4200: hr_utility.trace('Passed p_sick_hours := ' || p_sick_hours);
4201:
4202: /* Init */
4195: hr_utility.trace('Passed ctx_asg_id := ' || ctx_asg_id);
4196: hr_utility.trace('Passed p_period_end_dt := ' || TO_CHAR(p_period_end_dt));
4197: hr_utility.trace('Passed p_prorate_start_dt := ' || TO_CHAR(p_prorate_start_dt));
4198: hr_utility.trace('Passed p_prorate_end_dt := ' || TO_CHAR(p_prorate_end_dt));
4199: hr_utility.trace('Passed p_curr_rate := ' || p_curr_rate);
4200: hr_utility.trace('Passed p_sick_hours := ' || p_sick_hours);
4201:
4202: /* Init */
4203: l_sick_pay :=0;
4196: hr_utility.trace('Passed p_period_end_dt := ' || TO_CHAR(p_period_end_dt));
4197: hr_utility.trace('Passed p_prorate_start_dt := ' || TO_CHAR(p_prorate_start_dt));
4198: hr_utility.trace('Passed p_prorate_end_dt := ' || TO_CHAR(p_prorate_end_dt));
4199: hr_utility.trace('Passed p_curr_rate := ' || p_curr_rate);
4200: hr_utility.trace('Passed p_sick_hours := ' || p_sick_hours);
4201:
4202: /* Init */
4203: l_sick_pay :=0;
4204: l_sick_hours := 0;
4210:
4211: OPEN get_sick_hours (ctx_asg_id, /*p_period_end_dt*/ p_prorate_start_dt, p_prorate_end_dt);
4212: LOOP
4213:
4214: hr_utility.trace('calc_sick_pay');
4215: hr_utility.set_location('calc_sick_pay', 13);
4216:
4217: FETCH get_sick_hours
4218: INTO ln_ele_entry_id
4211: OPEN get_sick_hours (ctx_asg_id, /*p_period_end_dt*/ p_prorate_start_dt, p_prorate_end_dt);
4212: LOOP
4213:
4214: hr_utility.trace('calc_sick_pay');
4215: hr_utility.set_location('calc_sick_pay', 13);
4216:
4217: FETCH get_sick_hours
4218: INTO ln_ele_entry_id
4219: ,ln_abs_att_id
4221: ,ld_end_date
4222: ,l_sick_hours;
4223: EXIT WHEN get_sick_hours%NOTFOUND;
4224:
4225: hr_utility.trace('ln_ele_entry_id := ' || ln_ele_entry_id);
4226: hr_utility.trace('ln_abs_att_id := ' || ln_abs_att_id);
4227: hr_utility.trace('ld_start_date := ' || to_char(ld_start_date));
4228: hr_utility.trace('ld_end_date := ' || to_char(ld_end_date));
4229: hr_utility.trace('l_sick_hours := ' || l_sick_hours);
4222: ,l_sick_hours;
4223: EXIT WHEN get_sick_hours%NOTFOUND;
4224:
4225: hr_utility.trace('ln_ele_entry_id := ' || ln_ele_entry_id);
4226: hr_utility.trace('ln_abs_att_id := ' || ln_abs_att_id);
4227: hr_utility.trace('ld_start_date := ' || to_char(ld_start_date));
4228: hr_utility.trace('ld_end_date := ' || to_char(ld_end_date));
4229: hr_utility.trace('l_sick_hours := ' || l_sick_hours);
4230:
4223: EXIT WHEN get_sick_hours%NOTFOUND;
4224:
4225: hr_utility.trace('ln_ele_entry_id := ' || ln_ele_entry_id);
4226: hr_utility.trace('ln_abs_att_id := ' || ln_abs_att_id);
4227: hr_utility.trace('ld_start_date := ' || to_char(ld_start_date));
4228: hr_utility.trace('ld_end_date := ' || to_char(ld_end_date));
4229: hr_utility.trace('l_sick_hours := ' || l_sick_hours);
4230:
4231: p_sick_hours := p_sick_hours + l_sick_hours;
4224:
4225: hr_utility.trace('ln_ele_entry_id := ' || ln_ele_entry_id);
4226: hr_utility.trace('ln_abs_att_id := ' || ln_abs_att_id);
4227: hr_utility.trace('ld_start_date := ' || to_char(ld_start_date));
4228: hr_utility.trace('ld_end_date := ' || to_char(ld_end_date));
4229: hr_utility.trace('l_sick_hours := ' || l_sick_hours);
4230:
4231: p_sick_hours := p_sick_hours + l_sick_hours;
4232: END LOOP;
4225: hr_utility.trace('ln_ele_entry_id := ' || ln_ele_entry_id);
4226: hr_utility.trace('ln_abs_att_id := ' || ln_abs_att_id);
4227: hr_utility.trace('ld_start_date := ' || to_char(ld_start_date));
4228: hr_utility.trace('ld_end_date := ' || to_char(ld_end_date));
4229: hr_utility.trace('l_sick_hours := ' || l_sick_hours);
4230:
4231: p_sick_hours := p_sick_hours + l_sick_hours;
4232: END LOOP;
4233: CLOSE get_sick_hours;
4247:
4248: END IF;
4249: */
4250:
4251: hr_utility.trace('Returned p_sick_hours := ' || p_sick_hours);
4252: hr_utility.trace('Returned p_sick_pay := ' || p_sick_pay);
4253:
4254: RETURN p_sick_pay;
4255:
4248: END IF;
4249: */
4250:
4251: hr_utility.trace('Returned p_sick_hours := ' || p_sick_hours);
4252: hr_utility.trace('Returned p_sick_pay := ' || p_sick_pay);
4253:
4254: RETURN p_sick_pay;
4255:
4256: END calc_sick_pay;
4324: -- Need to loop thru all "Vacation Plans" and check for entries in the current
4325: -- period for this assignment.
4326:
4327: BEGIN
4328: hr_utility.trace('Entered calc_vacation_pay');
4329: hr_utility.trace('Passed ctx_asg_id := ' || ctx_asg_id);
4330: hr_utility.trace('Passed p_period_end_dt := ' || TO_CHAR(p_period_end_dt));
4331: hr_utility.trace('Passed p_prorate_start_dt := ' || TO_CHAR(p_prorate_start_dt));
4332: hr_utility.trace('Passed p_prorate_end_dt := ' || TO_CHAR(p_prorate_end_dt));
4325: -- period for this assignment.
4326:
4327: BEGIN
4328: hr_utility.trace('Entered calc_vacation_pay');
4329: hr_utility.trace('Passed ctx_asg_id := ' || ctx_asg_id);
4330: hr_utility.trace('Passed p_period_end_dt := ' || TO_CHAR(p_period_end_dt));
4331: hr_utility.trace('Passed p_prorate_start_dt := ' || TO_CHAR(p_prorate_start_dt));
4332: hr_utility.trace('Passed p_prorate_end_dt := ' || TO_CHAR(p_prorate_end_dt));
4333: hr_utility.trace('Passed p_curr_rate := ' || p_curr_rate);
4326:
4327: BEGIN
4328: hr_utility.trace('Entered calc_vacation_pay');
4329: hr_utility.trace('Passed ctx_asg_id := ' || ctx_asg_id);
4330: hr_utility.trace('Passed p_period_end_dt := ' || TO_CHAR(p_period_end_dt));
4331: hr_utility.trace('Passed p_prorate_start_dt := ' || TO_CHAR(p_prorate_start_dt));
4332: hr_utility.trace('Passed p_prorate_end_dt := ' || TO_CHAR(p_prorate_end_dt));
4333: hr_utility.trace('Passed p_curr_rate := ' || p_curr_rate);
4334: hr_utility.trace('Passed p_vac_hours := ' || p_vac_hours);
4327: BEGIN
4328: hr_utility.trace('Entered calc_vacation_pay');
4329: hr_utility.trace('Passed ctx_asg_id := ' || ctx_asg_id);
4330: hr_utility.trace('Passed p_period_end_dt := ' || TO_CHAR(p_period_end_dt));
4331: hr_utility.trace('Passed p_prorate_start_dt := ' || TO_CHAR(p_prorate_start_dt));
4332: hr_utility.trace('Passed p_prorate_end_dt := ' || TO_CHAR(p_prorate_end_dt));
4333: hr_utility.trace('Passed p_curr_rate := ' || p_curr_rate);
4334: hr_utility.trace('Passed p_vac_hours := ' || p_vac_hours);
4335:
4328: hr_utility.trace('Entered calc_vacation_pay');
4329: hr_utility.trace('Passed ctx_asg_id := ' || ctx_asg_id);
4330: hr_utility.trace('Passed p_period_end_dt := ' || TO_CHAR(p_period_end_dt));
4331: hr_utility.trace('Passed p_prorate_start_dt := ' || TO_CHAR(p_prorate_start_dt));
4332: hr_utility.trace('Passed p_prorate_end_dt := ' || TO_CHAR(p_prorate_end_dt));
4333: hr_utility.trace('Passed p_curr_rate := ' || p_curr_rate);
4334: hr_utility.trace('Passed p_vac_hours := ' || p_vac_hours);
4335:
4336: /* Init */
4329: hr_utility.trace('Passed ctx_asg_id := ' || ctx_asg_id);
4330: hr_utility.trace('Passed p_period_end_dt := ' || TO_CHAR(p_period_end_dt));
4331: hr_utility.trace('Passed p_prorate_start_dt := ' || TO_CHAR(p_prorate_start_dt));
4332: hr_utility.trace('Passed p_prorate_end_dt := ' || TO_CHAR(p_prorate_end_dt));
4333: hr_utility.trace('Passed p_curr_rate := ' || p_curr_rate);
4334: hr_utility.trace('Passed p_vac_hours := ' || p_vac_hours);
4335:
4336: /* Init */
4337: l_vac_pay := 0;
4330: hr_utility.trace('Passed p_period_end_dt := ' || TO_CHAR(p_period_end_dt));
4331: hr_utility.trace('Passed p_prorate_start_dt := ' || TO_CHAR(p_prorate_start_dt));
4332: hr_utility.trace('Passed p_prorate_end_dt := ' || TO_CHAR(p_prorate_end_dt));
4333: hr_utility.trace('Passed p_curr_rate := ' || p_curr_rate);
4334: hr_utility.trace('Passed p_vac_hours := ' || p_vac_hours);
4335:
4336: /* Init */
4337: l_vac_pay := 0;
4338: l_vac_hours := 0;
4343: */
4344: OPEN get_vac_hours (ctx_asg_id, /*p_period_end_dt*/ p_prorate_start_dt, p_prorate_end_dt);
4345: LOOP
4346:
4347: hr_utility.set_location('calc_vacation_pay', 13);
4348: hr_utility.trace('Opened get_vac_hours');
4349:
4350: FETCH get_vac_hours
4351: INTO ln_ele_entry_id
4344: OPEN get_vac_hours (ctx_asg_id, /*p_period_end_dt*/ p_prorate_start_dt, p_prorate_end_dt);
4345: LOOP
4346:
4347: hr_utility.set_location('calc_vacation_pay', 13);
4348: hr_utility.trace('Opened get_vac_hours');
4349:
4350: FETCH get_vac_hours
4351: INTO ln_ele_entry_id
4352: ,ln_abs_att_id
4354: ,ld_end_date
4355: ,l_vac_hours;
4356: EXIT WHEN get_vac_hours%NOTFOUND;
4357:
4358: hr_utility.trace('ln_ele_entry_id := ' || ln_ele_entry_id);
4359: hr_utility.trace('ln_abs_att_id := ' || ln_abs_att_id);
4360: hr_utility.trace('ld_start_date := ' || to_char(ld_start_date));
4361: hr_utility.trace('ld_end_date := ' || to_char(ld_end_date));
4362: hr_utility.trace('l_vac_hours := ' || l_vac_hours);
4355: ,l_vac_hours;
4356: EXIT WHEN get_vac_hours%NOTFOUND;
4357:
4358: hr_utility.trace('ln_ele_entry_id := ' || ln_ele_entry_id);
4359: hr_utility.trace('ln_abs_att_id := ' || ln_abs_att_id);
4360: hr_utility.trace('ld_start_date := ' || to_char(ld_start_date));
4361: hr_utility.trace('ld_end_date := ' || to_char(ld_end_date));
4362: hr_utility.trace('l_vac_hours := ' || l_vac_hours);
4363:
4356: EXIT WHEN get_vac_hours%NOTFOUND;
4357:
4358: hr_utility.trace('ln_ele_entry_id := ' || ln_ele_entry_id);
4359: hr_utility.trace('ln_abs_att_id := ' || ln_abs_att_id);
4360: hr_utility.trace('ld_start_date := ' || to_char(ld_start_date));
4361: hr_utility.trace('ld_end_date := ' || to_char(ld_end_date));
4362: hr_utility.trace('l_vac_hours := ' || l_vac_hours);
4363:
4364: p_vac_hours := p_vac_hours + l_vac_hours;
4357:
4358: hr_utility.trace('ln_ele_entry_id := ' || ln_ele_entry_id);
4359: hr_utility.trace('ln_abs_att_id := ' || ln_abs_att_id);
4360: hr_utility.trace('ld_start_date := ' || to_char(ld_start_date));
4361: hr_utility.trace('ld_end_date := ' || to_char(ld_end_date));
4362: hr_utility.trace('l_vac_hours := ' || l_vac_hours);
4363:
4364: p_vac_hours := p_vac_hours + l_vac_hours;
4365:
4358: hr_utility.trace('ln_ele_entry_id := ' || ln_ele_entry_id);
4359: hr_utility.trace('ln_abs_att_id := ' || ln_abs_att_id);
4360: hr_utility.trace('ld_start_date := ' || to_char(ld_start_date));
4361: hr_utility.trace('ld_end_date := ' || to_char(ld_end_date));
4362: hr_utility.trace('l_vac_hours := ' || l_vac_hours);
4363:
4364: p_vac_hours := p_vac_hours + l_vac_hours;
4365:
4366: END LOOP;
4379: p_vac_pay := l_vac_pay;
4380: END IF;
4381: */
4382:
4383: hr_utility.trace('Returned p_vac_hours := ' || p_vac_hours);
4384: hr_utility.trace('Returned p_vac_pay := ' || p_vac_pay);
4385:
4386: RETURN p_vac_pay;
4387:
4380: END IF;
4381: */
4382:
4383: hr_utility.trace('Returned p_vac_hours := ' || p_vac_hours);
4384: hr_utility.trace('Returned p_vac_pay := ' || p_vac_pay);
4385:
4386: RETURN p_vac_pay;
4387:
4388: END calc_vacation_pay;
4403: RETURN VARCHAR2 IS
4404: ln_red_regular_earn NUMBER;
4405: ln_red_regular_hrs NUMBER;
4406: BEGIN
4407: hr_utility.trace('Entered into pay_core_ff_udfs.calc_reduced_reg');
4408: hr_utility.trace('ctx_assignment_id := ' || ctx_assignment_id);
4409: hr_utility.trace('ctx_assignment_action_id := ' || ctx_assignment_action_id);
4410: hr_utility.trace('p_period_end_dt := ' || TO_CHAR(p_period_end_dt));
4411: hr_utility.trace('p_prorate_start_dt := ' || p_prorate_start_dt);
4404: ln_red_regular_earn NUMBER;
4405: ln_red_regular_hrs NUMBER;
4406: BEGIN
4407: hr_utility.trace('Entered into pay_core_ff_udfs.calc_reduced_reg');
4408: hr_utility.trace('ctx_assignment_id := ' || ctx_assignment_id);
4409: hr_utility.trace('ctx_assignment_action_id := ' || ctx_assignment_action_id);
4410: hr_utility.trace('p_period_end_dt := ' || TO_CHAR(p_period_end_dt));
4411: hr_utility.trace('p_prorate_start_dt := ' || p_prorate_start_dt);
4412: hr_utility.trace('p_prorate_end_dt := ' || p_prorate_end_dt);
4405: ln_red_regular_hrs NUMBER;
4406: BEGIN
4407: hr_utility.trace('Entered into pay_core_ff_udfs.calc_reduced_reg');
4408: hr_utility.trace('ctx_assignment_id := ' || ctx_assignment_id);
4409: hr_utility.trace('ctx_assignment_action_id := ' || ctx_assignment_action_id);
4410: hr_utility.trace('p_period_end_dt := ' || TO_CHAR(p_period_end_dt));
4411: hr_utility.trace('p_prorate_start_dt := ' || p_prorate_start_dt);
4412: hr_utility.trace('p_prorate_end_dt := ' || p_prorate_end_dt);
4413: hr_utility.trace('p_red_reg_earn := ' || p_red_reg_earn);
4406: BEGIN
4407: hr_utility.trace('Entered into pay_core_ff_udfs.calc_reduced_reg');
4408: hr_utility.trace('ctx_assignment_id := ' || ctx_assignment_id);
4409: hr_utility.trace('ctx_assignment_action_id := ' || ctx_assignment_action_id);
4410: hr_utility.trace('p_period_end_dt := ' || TO_CHAR(p_period_end_dt));
4411: hr_utility.trace('p_prorate_start_dt := ' || p_prorate_start_dt);
4412: hr_utility.trace('p_prorate_end_dt := ' || p_prorate_end_dt);
4413: hr_utility.trace('p_red_reg_earn := ' || p_red_reg_earn);
4414: hr_utility.trace('p_red_reg_hrs := ' || p_red_reg_hrs);
4407: hr_utility.trace('Entered into pay_core_ff_udfs.calc_reduced_reg');
4408: hr_utility.trace('ctx_assignment_id := ' || ctx_assignment_id);
4409: hr_utility.trace('ctx_assignment_action_id := ' || ctx_assignment_action_id);
4410: hr_utility.trace('p_period_end_dt := ' || TO_CHAR(p_period_end_dt));
4411: hr_utility.trace('p_prorate_start_dt := ' || p_prorate_start_dt);
4412: hr_utility.trace('p_prorate_end_dt := ' || p_prorate_end_dt);
4413: hr_utility.trace('p_red_reg_earn := ' || p_red_reg_earn);
4414: hr_utility.trace('p_red_reg_hrs := ' || p_red_reg_hrs);
4415:
4408: hr_utility.trace('ctx_assignment_id := ' || ctx_assignment_id);
4409: hr_utility.trace('ctx_assignment_action_id := ' || ctx_assignment_action_id);
4410: hr_utility.trace('p_period_end_dt := ' || TO_CHAR(p_period_end_dt));
4411: hr_utility.trace('p_prorate_start_dt := ' || p_prorate_start_dt);
4412: hr_utility.trace('p_prorate_end_dt := ' || p_prorate_end_dt);
4413: hr_utility.trace('p_red_reg_earn := ' || p_red_reg_earn);
4414: hr_utility.trace('p_red_reg_hrs := ' || p_red_reg_hrs);
4415:
4416: IF p_period_end_dt BETWEEN p_prorate_start_dt AND p_prorate_end_dt THEN
4409: hr_utility.trace('ctx_assignment_action_id := ' || ctx_assignment_action_id);
4410: hr_utility.trace('p_period_end_dt := ' || TO_CHAR(p_period_end_dt));
4411: hr_utility.trace('p_prorate_start_dt := ' || p_prorate_start_dt);
4412: hr_utility.trace('p_prorate_end_dt := ' || p_prorate_end_dt);
4413: hr_utility.trace('p_red_reg_earn := ' || p_red_reg_earn);
4414: hr_utility.trace('p_red_reg_hrs := ' || p_red_reg_hrs);
4415:
4416: IF p_period_end_dt BETWEEN p_prorate_start_dt AND p_prorate_end_dt THEN
4417: ln_red_regular_earn := (-1) * p_red_reg_earn;
4410: hr_utility.trace('p_period_end_dt := ' || TO_CHAR(p_period_end_dt));
4411: hr_utility.trace('p_prorate_start_dt := ' || p_prorate_start_dt);
4412: hr_utility.trace('p_prorate_end_dt := ' || p_prorate_end_dt);
4413: hr_utility.trace('p_red_reg_earn := ' || p_red_reg_earn);
4414: hr_utility.trace('p_red_reg_hrs := ' || p_red_reg_hrs);
4415:
4416: IF p_period_end_dt BETWEEN p_prorate_start_dt AND p_prorate_end_dt THEN
4417: ln_red_regular_earn := (-1) * p_red_reg_earn;
4418: ln_red_regular_hrs := (-1) * p_red_reg_hrs;
4424: p_red_reg_earn := 0;
4425: p_red_reg_hrs := 0;
4426: END IF;
4427:
4428: hr_utility.trace('Returned p_red_reg_earn := ' || p_red_reg_earn);
4429: hr_utility.trace('Returned p_red_reg_hrs := ' || p_red_reg_hrs);
4430:
4431: RETURN 'TRUE';
4432:
4425: p_red_reg_hrs := 0;
4426: END IF;
4427:
4428: hr_utility.trace('Returned p_red_reg_earn := ' || p_red_reg_earn);
4429: hr_utility.trace('Returned p_red_reg_hrs := ' || p_red_reg_hrs);
4430:
4431: RETURN 'TRUE';
4432:
4433: END calc_reduced_reg;
4497: IF l_proc_reg_sal <> 'Y' THEN
4498: IF pay_us_rsrw_upgrev.get_assignment_status(p_ctx_asg_id => ctx_asg_id
4499: ,p_prorate_end_dt => prorate_end_dt) = 'ACTIVE_ASSIGN' THEN
4500:
4501: hr_utility.trace('Assignment status is ACTIVE_ASSIGN.');
4502: RETURN 'Y';
4503: ELSE
4504: hr_utility.trace('Assignment status is NOT ACTIVE_ASSIGN.');
4505: RETURN 'N';
4500:
4501: hr_utility.trace('Assignment status is ACTIVE_ASSIGN.');
4502: RETURN 'Y';
4503: ELSE
4504: hr_utility.trace('Assignment status is NOT ACTIVE_ASSIGN.');
4505: RETURN 'N';
4506: END IF;
4507: ELSE
4508: RETURN 'Y';