[Home] [Help]
205: -- Selecting "count" because we want to continue processing even if
206: -- the from_freq is not a pay basis.
207: --
208:
209: hr_utility.trace(' Entered Get_Annualizing_Factor ');
210:
211: BEGIN -- Is Freq pay basis?
212:
213: --
214: -- Decode pay basis and set v_annualizing_factor accordingly.
215: -- PAY_BASIS "Meaning" is passed from FF !
216: --
217:
218: hr_utility.trace(' Getting lookup code for lookup_type = PAY_BASIS');
219: hr_utility.trace(' p_freq = '||p_freq);
220:
221:
222: IF p_freq IS NULL THEN
215: -- PAY_BASIS "Meaning" is passed from FF !
216: --
217:
218: hr_utility.trace(' Getting lookup code for lookup_type = PAY_BASIS');
219: hr_utility.trace(' p_freq = '||p_freq);
220:
221:
222: IF p_freq IS NULL THEN
223: v_use_pay_basis := 0;
235: END IF;
236:
237: --v_pay_basis := p_freq;
238:
239: hr_utility.trace(' Lookup_code ie v_pay_basis ='||v_pay_basis);
240:
241: IF v_pay_basis = 'MONTHLY' THEN
242:
243: hr_utility.trace(' Entered for MONTHLY v_pay_basis');
239: hr_utility.trace(' Lookup_code ie v_pay_basis ='||v_pay_basis);
240:
241: IF v_pay_basis = 'MONTHLY' THEN
242:
243: hr_utility.trace(' Entered for MONTHLY v_pay_basis');
244:
245: v_annualizing_factor := 12;
246:
247: hr_utility.trace(' v_annualizing_factor = 12 ');
243: hr_utility.trace(' Entered for MONTHLY v_pay_basis');
244:
245: v_annualizing_factor := 12;
246:
247: hr_utility.trace(' v_annualizing_factor = 12 ');
248:
249: ELSIF v_pay_basis = 'HOURLY' THEN
250:
251: hr_utility.trace(' Entered for HOURLY v_pay_basis');
247: hr_utility.trace(' v_annualizing_factor = 12 ');
248:
249: ELSIF v_pay_basis = 'HOURLY' THEN
250:
251: hr_utility.trace(' Entered for HOURLY v_pay_basis');
252:
253: IF p_period_start_date IS NOT NULL THEN
254:
255: hr_utility.trace(' p_period_start_date IS NOT NULL ' ||
251: hr_utility.trace(' Entered for HOURLY v_pay_basis');
252:
253: IF p_period_start_date IS NOT NULL THEN
254:
255: hr_utility.trace(' p_period_start_date IS NOT NULL ' ||
256: ' v_period_hours=T');
257:
258: v_range_start := p_period_start_date;
259: v_range_end := p_period_end_date;
260: v_period_hours := TRUE;
261:
262: ELSE
263:
264: hr_utility.trace(' p_period_start_date IS NULL');
265:
266: v_range_start := sysdate;
267: v_range_end := sysdate + 6;
268: v_period_hours := FALSE;
288: ,v_return_message);
289:
290: IF v_period_hours THEN
291:
292: hr_utility.trace(' v_period_hours is TRUE');
293:
294: SELECT TPT.number_per_fiscal_year
295: INTO v_periods_per_fiscal_yr
296: FROM pay_payrolls_f PPF,
312: END IF;
313:
314: ELSIF v_pay_basis = 'PERIOD' THEN
315:
316: hr_utility.trace(' v_pay_basis = PERIOD');
317:
318: SELECT TPT.number_per_fiscal_year
319: INTO v_annualizing_factor
320: FROM pay_payrolls_f PRL,
330:
331: ELSIF v_pay_basis = 'ANNUAL' THEN
332:
333:
334: hr_utility.trace(' v_pay_basis = ANNUAL');
335:
336: v_annualizing_factor := 1;
337:
338: ELSE
339:
340: -- Did not recognize "pay basis", return -999 as annualizing factor.
341: -- Remember this for debugging when zeroes come out as results!!!
342:
343: hr_utility.trace(' Did not recognize pay basis');
344:
345: v_annualizing_factor := 0;
346:
347: RETURN v_annualizing_factor;
352: EXCEPTION
353:
354: WHEN NO_DATA_FOUND THEN
355:
356: hr_utility.trace(' When no data found' );
357: v_use_pay_basis := 0;
358:
359: END; /* SELECT LOOKUP CODE */
360:
360:
361:
362: IF v_use_pay_basis = 0 THEN
363:
364: hr_utility.trace(' Not using pay basis as frequency');
365:
366: -- Not using pay basis as frequency...
367:
368: IF (p_freq IS NULL) OR
371: THEN
372:
373: -- Get "annuallizing factor" from period type of the payroll.
374:
375: hr_utility.trace('Get annuallizing factor from period '||
376: 'type of the payroll');
377:
378: SELECT TPT.number_per_fiscal_year
379: INTO v_annualizing_factor
386: AND PRL.effective_end_date
387: AND PRL.payroll_id = p_payroll_id
388: AND PRL.business_group_id + 0 = p_bg;
389:
390: hr_utility.trace('v_annualizing_factor ='||
391: to_number(v_annualizing_factor));
392:
393:
394: ELSIF UPPER(p_freq) = 'HOURLY' THEN -- Hourly employee...
392:
393:
394: ELSIF UPPER(p_freq) = 'HOURLY' THEN -- Hourly employee...
395:
396: hr_utility.trace(' Hourly Employee');
397:
398: IF p_period_start_date IS NOT NULL THEN
399: v_range_start := p_period_start_date;
400: v_range_end := p_period_end_date;
422: ,v_schedule
423: ,v_return_status
424: ,v_return_message);
425:
426: hr_utility.trace('v_hrs_per_range ='||v_hrs_per_range);
427: IF v_period_hours THEN
428:
429: hr_utility.trace('v_period_hours = TRUE');
430:
425:
426: hr_utility.trace('v_hrs_per_range ='||v_hrs_per_range);
427: IF v_period_hours THEN
428:
429: hr_utility.trace('v_period_hours = TRUE');
430:
431: SELECT TPT.number_per_fiscal_year
432: INTO v_periods_per_fiscal_yr
433: FROM pay_payrolls_f ppf,
441:
442: v_annualizing_factor :=
443: v_hrs_per_range * v_periods_per_fiscal_yr;
444:
445: hr_utility.trace('v_hrs_per_range ='||
446: to_number(v_hrs_per_range));
447: hr_utility.trace('v_periods_per_fiscal_yr ='||
448: to_number(v_periods_per_fiscal_yr));
449: hr_utility.trace('v_annualizing_factor ='||
443: v_hrs_per_range * v_periods_per_fiscal_yr;
444:
445: hr_utility.trace('v_hrs_per_range ='||
446: to_number(v_hrs_per_range));
447: hr_utility.trace('v_periods_per_fiscal_yr ='||
448: to_number(v_periods_per_fiscal_yr));
449: hr_utility.trace('v_annualizing_factor ='||
450: to_number(v_annualizing_factor));
451:
445: hr_utility.trace('v_hrs_per_range ='||
446: to_number(v_hrs_per_range));
447: hr_utility.trace('v_periods_per_fiscal_yr ='||
448: to_number(v_periods_per_fiscal_yr));
449: hr_utility.trace('v_annualizing_factor ='||
450: to_number(v_annualizing_factor));
451:
452: ELSE
453:
450: to_number(v_annualizing_factor));
451:
452: ELSE
453:
454: hr_utility.trace('v_period_hours = FALSE');
455:
456: v_annualizing_factor := v_hrs_per_range * c_weeks_per_year;
457:
458: hr_utility.trace('v_hrs_per_range ='||
454: hr_utility.trace('v_period_hours = FALSE');
455:
456: v_annualizing_factor := v_hrs_per_range * c_weeks_per_year;
457:
458: hr_utility.trace('v_hrs_per_range ='||
459: to_number(v_hrs_per_range));
460: hr_utility.trace('c_weeks_per_year ='||
461: to_number(c_weeks_per_year));
462: hr_utility.trace('v_annualizing_factor ='||
456: v_annualizing_factor := v_hrs_per_range * c_weeks_per_year;
457:
458: hr_utility.trace('v_hrs_per_range ='||
459: to_number(v_hrs_per_range));
460: hr_utility.trace('c_weeks_per_year ='||
461: to_number(c_weeks_per_year));
462: hr_utility.trace('v_annualizing_factor ='||
463: to_number(v_annualizing_factor));
464:
458: hr_utility.trace('v_hrs_per_range ='||
459: to_number(v_hrs_per_range));
460: hr_utility.trace('c_weeks_per_year ='||
461: to_number(c_weeks_per_year));
462: hr_utility.trace('v_annualizing_factor ='||
463: to_number(v_annualizing_factor));
464:
465: END IF;
466:
467: ELSE
468:
469: -- Not hourly, an actual time period type!
470:
471: hr_utility.trace('Not hourly - an actual time period type');
472:
473: BEGIN
474:
475: hr_utility.trace(' selecting from per_time_period_types');
471: hr_utility.trace('Not hourly - an actual time period type');
472:
473: BEGIN
474:
475: hr_utility.trace(' selecting from per_time_period_types');
476:
477: SELECT PT.number_per_fiscal_year
478: INTO v_annualizing_factor
479: FROM per_time_period_types PT
478: INTO v_annualizing_factor
479: FROM per_time_period_types PT
480: WHERE UPPER(PT.period_type) = UPPER(p_freq);
481:
482: hr_utility.trace('v_annualizing_factor ='||
483: to_number(v_annualizing_factor));
484:
485: EXCEPTION WHEN no_data_found THEN
486:
490: -- 'Day' or 'Month' which do not map to a time period type.
491: -- So we'll do these by hand.
492:
493: IF UPPER(p_freq) = 'DAY' THEN
494: hr_utility.trace(' p_freq = DAY');
495: v_annualizing_factor := c_days_per_year;
496: ELSIF UPPER(p_freq) = 'MONTH' THEN
497: v_annualizing_factor := c_months_per_year;
498: hr_utility.trace(' p_freq = MONTH');
494: hr_utility.trace(' p_freq = DAY');
495: v_annualizing_factor := c_days_per_year;
496: ELSIF UPPER(p_freq) = 'MONTH' THEN
497: v_annualizing_factor := c_months_per_year;
498: hr_utility.trace(' p_freq = MONTH');
499: END IF;
500:
501: END;
502:
504:
505: END IF; -- (v_use_pay_basis = 0)
506:
507:
508: hr_utility.trace(' Getting out of Get_Annualizing_Factor for '||
509: v_pay_basis);
510: RETURN v_annualizing_factor;
511:
512: END Get_Annualizing_Factor;
514:
515: BEGIN -- Convert Figure
516: --begin_convert_period_type
517:
518: --hr_utility.trace_on(null,'pay_core_ff_udfs');
519:
520: IF p_from_freq IS NULL THEN
521: v_from_freq := 'NOT ENTERED';
522: END IF;
528: /* IF p_rate_calc_override IS NULL THEN
529: v_rate_calc_override := 'NOT ENTERED';
530: END IF;
531: */
532: hr_utility.trace('COREUDFS Entered Convert_Period_Type');
533:
534: hr_utility.trace('assignment_action_id=' || p_assignment_action_id);
535: hr_utility.trace('assignment_id=' || p_assignment_id);
536: hr_utility.trace('business_group_id=' || p_bg);
530: END IF;
531: */
532: hr_utility.trace('COREUDFS Entered Convert_Period_Type');
533:
534: hr_utility.trace('assignment_action_id=' || p_assignment_action_id);
535: hr_utility.trace('assignment_id=' || p_assignment_id);
536: hr_utility.trace('business_group_id=' || p_bg);
537: hr_utility.trace('element_entry_id=' || p_element_entry_id);
538: hr_utility.trace( 'p-date_earned '||p_date_earned);
531: */
532: hr_utility.trace('COREUDFS Entered Convert_Period_Type');
533:
534: hr_utility.trace('assignment_action_id=' || p_assignment_action_id);
535: hr_utility.trace('assignment_id=' || p_assignment_id);
536: hr_utility.trace('business_group_id=' || p_bg);
537: hr_utility.trace('element_entry_id=' || p_element_entry_id);
538: hr_utility.trace( 'p-date_earned '||p_date_earned);
539: hr_utility.trace(' p_payroll_id: '||p_payroll_id);
532: hr_utility.trace('COREUDFS Entered Convert_Period_Type');
533:
534: hr_utility.trace('assignment_action_id=' || p_assignment_action_id);
535: hr_utility.trace('assignment_id=' || p_assignment_id);
536: hr_utility.trace('business_group_id=' || p_bg);
537: hr_utility.trace('element_entry_id=' || p_element_entry_id);
538: hr_utility.trace( 'p-date_earned '||p_date_earned);
539: hr_utility.trace(' p_payroll_id: '||p_payroll_id);
540: hr_utility.trace(' p_figure: '||p_figure);
533:
534: hr_utility.trace('assignment_action_id=' || p_assignment_action_id);
535: hr_utility.trace('assignment_id=' || p_assignment_id);
536: hr_utility.trace('business_group_id=' || p_bg);
537: hr_utility.trace('element_entry_id=' || p_element_entry_id);
538: hr_utility.trace( 'p-date_earned '||p_date_earned);
539: hr_utility.trace(' p_payroll_id: '||p_payroll_id);
540: hr_utility.trace(' p_figure: '||p_figure);
541: hr_utility.trace('p_period_start_date=' || p_period_start_date);
534: hr_utility.trace('assignment_action_id=' || p_assignment_action_id);
535: hr_utility.trace('assignment_id=' || p_assignment_id);
536: hr_utility.trace('business_group_id=' || p_bg);
537: hr_utility.trace('element_entry_id=' || p_element_entry_id);
538: hr_utility.trace( 'p-date_earned '||p_date_earned);
539: hr_utility.trace(' p_payroll_id: '||p_payroll_id);
540: hr_utility.trace(' p_figure: '||p_figure);
541: hr_utility.trace('p_period_start_date=' || p_period_start_date);
542: hr_utility.trace('p_period_end_date=' || p_period_end_date);
535: hr_utility.trace('assignment_id=' || p_assignment_id);
536: hr_utility.trace('business_group_id=' || p_bg);
537: hr_utility.trace('element_entry_id=' || p_element_entry_id);
538: hr_utility.trace( 'p-date_earned '||p_date_earned);
539: hr_utility.trace(' p_payroll_id: '||p_payroll_id);
540: hr_utility.trace(' p_figure: '||p_figure);
541: hr_utility.trace('p_period_start_date=' || p_period_start_date);
542: hr_utility.trace('p_period_end_date=' || p_period_end_date);
543: /*hr_utility.trace('p_schedule_category=' || p_schedule_category);
536: hr_utility.trace('business_group_id=' || p_bg);
537: hr_utility.trace('element_entry_id=' || p_element_entry_id);
538: hr_utility.trace( 'p-date_earned '||p_date_earned);
539: hr_utility.trace(' p_payroll_id: '||p_payroll_id);
540: hr_utility.trace(' p_figure: '||p_figure);
541: hr_utility.trace('p_period_start_date=' || p_period_start_date);
542: hr_utility.trace('p_period_end_date=' || p_period_end_date);
543: /*hr_utility.trace('p_schedule_category=' || p_schedule_category);
544: hr_utility.trace('p_schedule_source=' || p_schedule_source);
537: hr_utility.trace('element_entry_id=' || p_element_entry_id);
538: hr_utility.trace( 'p-date_earned '||p_date_earned);
539: hr_utility.trace(' p_payroll_id: '||p_payroll_id);
540: hr_utility.trace(' p_figure: '||p_figure);
541: hr_utility.trace('p_period_start_date=' || p_period_start_date);
542: hr_utility.trace('p_period_end_date=' || p_period_end_date);
543: /*hr_utility.trace('p_schedule_category=' || p_schedule_category);
544: hr_utility.trace('p_schedule_source=' || p_schedule_source);
545: hr_utility.trace('p_include_exceptions=' || p_include_exceptions);
538: hr_utility.trace( 'p-date_earned '||p_date_earned);
539: hr_utility.trace(' p_payroll_id: '||p_payroll_id);
540: hr_utility.trace(' p_figure: '||p_figure);
541: hr_utility.trace('p_period_start_date=' || p_period_start_date);
542: hr_utility.trace('p_period_end_date=' || p_period_end_date);
543: /*hr_utility.trace('p_schedule_category=' || p_schedule_category);
544: hr_utility.trace('p_schedule_source=' || p_schedule_source);
545: hr_utility.trace('p_include_exceptions=' || p_include_exceptions);
546: hr_utility.trace('p_busy_tentative_as=' || p_busy_tentative_as);
539: hr_utility.trace(' p_payroll_id: '||p_payroll_id);
540: hr_utility.trace(' p_figure: '||p_figure);
541: hr_utility.trace('p_period_start_date=' || p_period_start_date);
542: hr_utility.trace('p_period_end_date=' || p_period_end_date);
543: /*hr_utility.trace('p_schedule_category=' || p_schedule_category);
544: hr_utility.trace('p_schedule_source=' || p_schedule_source);
545: hr_utility.trace('p_include_exceptions=' || p_include_exceptions);
546: hr_utility.trace('p_busy_tentative_as=' || p_busy_tentative_as);
547: hr_utility.trace('p_schedule=' || p_schedule);*/
540: hr_utility.trace(' p_figure: '||p_figure);
541: hr_utility.trace('p_period_start_date=' || p_period_start_date);
542: hr_utility.trace('p_period_end_date=' || p_period_end_date);
543: /*hr_utility.trace('p_schedule_category=' || p_schedule_category);
544: hr_utility.trace('p_schedule_source=' || p_schedule_source);
545: hr_utility.trace('p_include_exceptions=' || p_include_exceptions);
546: hr_utility.trace('p_busy_tentative_as=' || p_busy_tentative_as);
547: hr_utility.trace('p_schedule=' || p_schedule);*/
548:
541: hr_utility.trace('p_period_start_date=' || p_period_start_date);
542: hr_utility.trace('p_period_end_date=' || p_period_end_date);
543: /*hr_utility.trace('p_schedule_category=' || p_schedule_category);
544: hr_utility.trace('p_schedule_source=' || p_schedule_source);
545: hr_utility.trace('p_include_exceptions=' || p_include_exceptions);
546: hr_utility.trace('p_busy_tentative_as=' || p_busy_tentative_as);
547: hr_utility.trace('p_schedule=' || p_schedule);*/
548:
549: hr_utility.trace(' p_from_freq : '||p_from_freq);
542: hr_utility.trace('p_period_end_date=' || p_period_end_date);
543: /*hr_utility.trace('p_schedule_category=' || p_schedule_category);
544: hr_utility.trace('p_schedule_source=' || p_schedule_source);
545: hr_utility.trace('p_include_exceptions=' || p_include_exceptions);
546: hr_utility.trace('p_busy_tentative_as=' || p_busy_tentative_as);
547: hr_utility.trace('p_schedule=' || p_schedule);*/
548:
549: hr_utility.trace(' p_from_freq : '||p_from_freq);
550: hr_utility.trace(' p_to_freq: '||p_to_freq);
543: /*hr_utility.trace('p_schedule_category=' || p_schedule_category);
544: hr_utility.trace('p_schedule_source=' || p_schedule_source);
545: hr_utility.trace('p_include_exceptions=' || p_include_exceptions);
546: hr_utility.trace('p_busy_tentative_as=' || p_busy_tentative_as);
547: hr_utility.trace('p_schedule=' || p_schedule);*/
548:
549: hr_utility.trace(' p_from_freq : '||p_from_freq);
550: hr_utility.trace(' p_to_freq: '||p_to_freq);
551: hr_utility.trace(' p_asst_std_freq: '||p_asst_std_freq);
545: hr_utility.trace('p_include_exceptions=' || p_include_exceptions);
546: hr_utility.trace('p_busy_tentative_as=' || p_busy_tentative_as);
547: hr_utility.trace('p_schedule=' || p_schedule);*/
548:
549: hr_utility.trace(' p_from_freq : '||p_from_freq);
550: hr_utility.trace(' p_to_freq: '||p_to_freq);
551: hr_utility.trace(' p_asst_std_freq: '||p_asst_std_freq);
552:
553:
546: hr_utility.trace('p_busy_tentative_as=' || p_busy_tentative_as);
547: hr_utility.trace('p_schedule=' || p_schedule);*/
548:
549: hr_utility.trace(' p_from_freq : '||p_from_freq);
550: hr_utility.trace(' p_to_freq: '||p_to_freq);
551: hr_utility.trace(' p_asst_std_freq: '||p_asst_std_freq);
552:
553:
554: IF g_legislation_code IS NULL THEN
547: hr_utility.trace('p_schedule=' || p_schedule);*/
548:
549: hr_utility.trace(' p_from_freq : '||p_from_freq);
550: hr_utility.trace(' p_to_freq: '||p_to_freq);
551: hr_utility.trace(' p_asst_std_freq: '||p_asst_std_freq);
552:
553:
554: IF g_legislation_code IS NULL THEN
555: hr_utility.trace('g_legislation_code is null ');
551: hr_utility.trace(' p_asst_std_freq: '||p_asst_std_freq);
552:
553:
554: IF g_legislation_code IS NULL THEN
555: hr_utility.trace('g_legislation_code is null ');
556: g_legislation_code := get_legislation_code(p_bg);
557: END IF;
558:
559: hr_utility.trace(' p_asst_std_freq: '||p_asst_std_freq);
555: hr_utility.trace('g_legislation_code is null ');
556: g_legislation_code := get_legislation_code(p_bg);
557: END IF;
558:
559: hr_utility.trace(' p_asst_std_freq: '||p_asst_std_freq);
560:
561:
562: --
563: -- If From_Freq and To_Freq are the same, then we're done.
567:
568: RETURN p_figure;
569:
570: END IF;
571: hr_utility.trace('Calling Get_Annualizing_Factor for FROM case');
572: v_from_annualizing_factor := Get_Annualizing_Factor
573: ( p_bg
574: ,p_assignment_id
575: ,p_payroll_id
582:
583:
584:
585:
586: hr_utility.trace('Calling Get_Annualizing_Factor for TO case');
587:
588: v_to_annualizing_factor := Get_Annualizing_Factor(
589: p_bg -- context
590: ,p_assignment_id -- context
599:
600: --
601: -- Annualize "Figure" and convert to To_Freq.
602: --
603: hr_utility.trace('v_from_annualizing_factor ='||to_char(v_from_annualizing_factor));
604: hr_utility.trace('v_to_annualizing_factor ='||to_char(v_to_annualizing_factor));
605:
606: IF v_to_annualizing_factor = 0 OR
607: v_to_annualizing_factor = -999 OR
600: --
601: -- Annualize "Figure" and convert to To_Freq.
602: --
603: hr_utility.trace('v_from_annualizing_factor ='||to_char(v_from_annualizing_factor));
604: hr_utility.trace('v_to_annualizing_factor ='||to_char(v_to_annualizing_factor));
605:
606: IF v_to_annualizing_factor = 0 OR
607: v_to_annualizing_factor = -999 OR
608: v_from_annualizing_factor = -999 THEN
606: IF v_to_annualizing_factor = 0 OR
607: v_to_annualizing_factor = -999 OR
608: v_from_annualizing_factor = -999 THEN
609:
610: hr_utility.trace(' v_to_ann =0 or -999 or v_from = -999');
611:
612: v_converted_figure := 0;
613: RETURN v_converted_figure;
614:
613: RETURN v_converted_figure;
614:
615: ELSE
616:
617: hr_utility.trace(' v_to_ann NOT 0 or -999 or v_from = -999');
618:
619: hr_utility.trace('p_figure Monthly Salary = '||p_figure);
620: hr_utility.trace('v_from_annualizing_factor = '||v_from_annualizing_factor);
621: hr_utility.trace('v_to_annualizing_factor = '||v_to_annualizing_factor);
615: ELSE
616:
617: hr_utility.trace(' v_to_ann NOT 0 or -999 or v_from = -999');
618:
619: hr_utility.trace('p_figure Monthly Salary = '||p_figure);
620: hr_utility.trace('v_from_annualizing_factor = '||v_from_annualizing_factor);
621: hr_utility.trace('v_to_annualizing_factor = '||v_to_annualizing_factor);
622:
623: v_converted_figure := (p_figure * v_from_annualizing_factor) / v_to_annualizing_factor;
616:
617: hr_utility.trace(' v_to_ann NOT 0 or -999 or v_from = -999');
618:
619: hr_utility.trace('p_figure Monthly Salary = '||p_figure);
620: hr_utility.trace('v_from_annualizing_factor = '||v_from_annualizing_factor);
621: hr_utility.trace('v_to_annualizing_factor = '||v_to_annualizing_factor);
622:
623: v_converted_figure := (p_figure * v_from_annualizing_factor) / v_to_annualizing_factor;
624: hr_utility.trace('conv figure is monthly_sal * ann_from div by ann to');
617: hr_utility.trace(' v_to_ann NOT 0 or -999 or v_from = -999');
618:
619: hr_utility.trace('p_figure Monthly Salary = '||p_figure);
620: hr_utility.trace('v_from_annualizing_factor = '||v_from_annualizing_factor);
621: hr_utility.trace('v_to_annualizing_factor = '||v_to_annualizing_factor);
622:
623: v_converted_figure := (p_figure * v_from_annualizing_factor) / v_to_annualizing_factor;
624: hr_utility.trace('conv figure is monthly_sal * ann_from div by ann to');
625:
620: hr_utility.trace('v_from_annualizing_factor = '||v_from_annualizing_factor);
621: hr_utility.trace('v_to_annualizing_factor = '||v_to_annualizing_factor);
622:
623: v_converted_figure := (p_figure * v_from_annualizing_factor) / v_to_annualizing_factor;
624: hr_utility.trace('conv figure is monthly_sal * ann_from div by ann to');
625:
626: hr_utility.trace('CORE UDFS v_converted_figure := '||v_converted_figure);
627:
628: END IF;
622:
623: v_converted_figure := (p_figure * v_from_annualizing_factor) / v_to_annualizing_factor;
624: hr_utility.trace('conv figure is monthly_sal * ann_from div by ann to');
625:
626: hr_utility.trace('CORE UDFS v_converted_figure := '||v_converted_figure);
627:
628: END IF;
629:
630: -- Done
674: ,p_assignment_action_id
675: ,p_period_start_date
676: ,p_period_end_date
677: ,p_from_freq);
678: hr_utility.trace('l_normal_hours := '||l_normal_hours);
679: hr_utility.trace('p_figure := '||p_figure);
680: hr_utility.trace('v_from_stnd_factor := '||v_from_stnd_factor);
681:
682:
675: ,p_period_start_date
676: ,p_period_end_date
677: ,p_from_freq);
678: hr_utility.trace('l_normal_hours := '||l_normal_hours);
679: hr_utility.trace('p_figure := '||p_figure);
680: hr_utility.trace('v_from_stnd_factor := '||v_from_stnd_factor);
681:
682:
683: v_converted_figure :=(p_figure * v_from_stnd_factor/(52 * l_normal_hours ));
676: ,p_period_end_date
677: ,p_from_freq);
678: hr_utility.trace('l_normal_hours := '||l_normal_hours);
679: hr_utility.trace('p_figure := '||p_figure);
680: hr_utility.trace('v_from_stnd_factor := '||v_from_stnd_factor);
681:
682:
683: v_converted_figure :=(p_figure * v_from_stnd_factor/(52 * l_normal_hours ));
684: hr_utility.trace('v_converted_figure := '||v_converted_figure);
680: hr_utility.trace('v_from_stnd_factor := '||v_from_stnd_factor);
681:
682:
683: v_converted_figure :=(p_figure * v_from_stnd_factor/(52 * l_normal_hours ));
684: hr_utility.trace('v_converted_figure := '||v_converted_figure);
685:
686: END IF;
687:
688:
822:
823: --p_wsched := 'NOT ENTERED';
824: v_prorated_earn := 0;
825:
826: hr_utility.trace('UDFS Entered Prorate Earnings');
827: hr_utility.trace('p_bg_id ='||to_char(p_bg_id));
828: hr_utility.trace('p_asg_hrly_rate ='||to_char(p_asg_hrly_rate));
829: -- hr_utility.trace('p_wsched ='||p_wsched);
830: -- hr_utility.trace('p_asg_std_hours ='||to_char(p_asg_std_hours));
823: --p_wsched := 'NOT ENTERED';
824: v_prorated_earn := 0;
825:
826: hr_utility.trace('UDFS Entered Prorate Earnings');
827: hr_utility.trace('p_bg_id ='||to_char(p_bg_id));
828: hr_utility.trace('p_asg_hrly_rate ='||to_char(p_asg_hrly_rate));
829: -- hr_utility.trace('p_wsched ='||p_wsched);
830: -- hr_utility.trace('p_asg_std_hours ='||to_char(p_asg_std_hours));
831: -- hr_utility.trace('p_asg_std_freq ='||p_asg_std_freq);
824: v_prorated_earn := 0;
825:
826: hr_utility.trace('UDFS Entered Prorate Earnings');
827: hr_utility.trace('p_bg_id ='||to_char(p_bg_id));
828: hr_utility.trace('p_asg_hrly_rate ='||to_char(p_asg_hrly_rate));
829: -- hr_utility.trace('p_wsched ='||p_wsched);
830: -- hr_utility.trace('p_asg_std_hours ='||to_char(p_asg_std_hours));
831: -- hr_utility.trace('p_asg_std_freq ='||p_asg_std_freq);
832: hr_utility.trace('UDFS p_range_start_date ='||to_char(p_range_start_date));
825:
826: hr_utility.trace('UDFS Entered Prorate Earnings');
827: hr_utility.trace('p_bg_id ='||to_char(p_bg_id));
828: hr_utility.trace('p_asg_hrly_rate ='||to_char(p_asg_hrly_rate));
829: -- hr_utility.trace('p_wsched ='||p_wsched);
830: -- hr_utility.trace('p_asg_std_hours ='||to_char(p_asg_std_hours));
831: -- hr_utility.trace('p_asg_std_freq ='||p_asg_std_freq);
832: hr_utility.trace('UDFS p_range_start_date ='||to_char(p_range_start_date));
833: hr_utility.trace('UDFS p_range_end_date ='||to_char(p_range_end_date));
826: hr_utility.trace('UDFS Entered Prorate Earnings');
827: hr_utility.trace('p_bg_id ='||to_char(p_bg_id));
828: hr_utility.trace('p_asg_hrly_rate ='||to_char(p_asg_hrly_rate));
829: -- hr_utility.trace('p_wsched ='||p_wsched);
830: -- hr_utility.trace('p_asg_std_hours ='||to_char(p_asg_std_hours));
831: -- hr_utility.trace('p_asg_std_freq ='||p_asg_std_freq);
832: hr_utility.trace('UDFS p_range_start_date ='||to_char(p_range_start_date));
833: hr_utility.trace('UDFS p_range_end_date ='||to_char(p_range_end_date));
834: hr_utility.trace('p_act_hrs_worked ='||to_char(p_act_hrs_worked));
827: hr_utility.trace('p_bg_id ='||to_char(p_bg_id));
828: hr_utility.trace('p_asg_hrly_rate ='||to_char(p_asg_hrly_rate));
829: -- hr_utility.trace('p_wsched ='||p_wsched);
830: -- hr_utility.trace('p_asg_std_hours ='||to_char(p_asg_std_hours));
831: -- hr_utility.trace('p_asg_std_freq ='||p_asg_std_freq);
832: hr_utility.trace('UDFS p_range_start_date ='||to_char(p_range_start_date));
833: hr_utility.trace('UDFS p_range_end_date ='||to_char(p_range_end_date));
834: hr_utility.trace('p_act_hrs_worked ='||to_char(p_act_hrs_worked));
835:
828: hr_utility.trace('p_asg_hrly_rate ='||to_char(p_asg_hrly_rate));
829: -- hr_utility.trace('p_wsched ='||p_wsched);
830: -- hr_utility.trace('p_asg_std_hours ='||to_char(p_asg_std_hours));
831: -- hr_utility.trace('p_asg_std_freq ='||p_asg_std_freq);
832: hr_utility.trace('UDFS p_range_start_date ='||to_char(p_range_start_date));
833: hr_utility.trace('UDFS p_range_end_date ='||to_char(p_range_end_date));
834: hr_utility.trace('p_act_hrs_worked ='||to_char(p_act_hrs_worked));
835:
836: -- Prorate using hourly rate passed in as param:
829: -- hr_utility.trace('p_wsched ='||p_wsched);
830: -- hr_utility.trace('p_asg_std_hours ='||to_char(p_asg_std_hours));
831: -- hr_utility.trace('p_asg_std_freq ='||p_asg_std_freq);
832: hr_utility.trace('UDFS p_range_start_date ='||to_char(p_range_start_date));
833: hr_utility.trace('UDFS p_range_end_date ='||to_char(p_range_end_date));
834: hr_utility.trace('p_act_hrs_worked ='||to_char(p_act_hrs_worked));
835:
836: -- Prorate using hourly rate passed in as param:
837:
830: -- hr_utility.trace('p_asg_std_hours ='||to_char(p_asg_std_hours));
831: -- hr_utility.trace('p_asg_std_freq ='||p_asg_std_freq);
832: hr_utility.trace('UDFS p_range_start_date ='||to_char(p_range_start_date));
833: hr_utility.trace('UDFS p_range_end_date ='||to_char(p_range_end_date));
834: hr_utility.trace('p_act_hrs_worked ='||to_char(p_act_hrs_worked));
835:
836: -- Prorate using hourly rate passed in as param:
837:
838: /*
837:
838: /*
839: IF UPPER(p_wsched) = 'NOT ENTERED' THEN
840:
841: hr_utility.set_location('Prorate_Earnings', 7);
842: hr_utility.trace('p_wsched NOT ENTERED');
843: hr_utility.trace('Calling Standard Hours Worked');
844:
845: v_hours_in_range := Standard_Hours_Worked( p_asg_std_hours,
838: /*
839: IF UPPER(p_wsched) = 'NOT ENTERED' THEN
840:
841: hr_utility.set_location('Prorate_Earnings', 7);
842: hr_utility.trace('p_wsched NOT ENTERED');
843: hr_utility.trace('Calling Standard Hours Worked');
844:
845: v_hours_in_range := Standard_Hours_Worked( p_asg_std_hours,
846: p_range_start_date,
839: IF UPPER(p_wsched) = 'NOT ENTERED' THEN
840:
841: hr_utility.set_location('Prorate_Earnings', 7);
842: hr_utility.trace('p_wsched NOT ENTERED');
843: hr_utility.trace('Calling Standard Hours Worked');
844:
845: v_hours_in_range := Standard_Hours_Worked( p_asg_std_hours,
846: p_range_start_date,
847: p_range_end_date,
847: p_range_end_date,
848: p_asg_std_freq);
849:
850: -- Keep running total of ACTUAL hours worked.
851: hr_utility.set_location('Prorate_Earnings', 11);
852:
853: hr_utility.trace('Keep running total of ACTUAL hours worked');
854:
855: hr_utility.trace('actual_hours_worked before call= '||
849:
850: -- Keep running total of ACTUAL hours worked.
851: hr_utility.set_location('Prorate_Earnings', 11);
852:
853: hr_utility.trace('Keep running total of ACTUAL hours worked');
854:
855: hr_utility.trace('actual_hours_worked before call= '||
856: to_char(p_act_hrs_worked));
857: hr_utility.trace('v_hours_in_range in current call= '||
851: hr_utility.set_location('Prorate_Earnings', 11);
852:
853: hr_utility.trace('Keep running total of ACTUAL hours worked');
854:
855: hr_utility.trace('actual_hours_worked before call= '||
856: to_char(p_act_hrs_worked));
857: hr_utility.trace('v_hours_in_range in current call= '||
858: to_char(v_hours_in_range));
859:
853: hr_utility.trace('Keep running total of ACTUAL hours worked');
854:
855: hr_utility.trace('actual_hours_worked before call= '||
856: to_char(p_act_hrs_worked));
857: hr_utility.trace('v_hours_in_range in current call= '||
858: to_char(v_hours_in_range));
859:
860: p_act_hrs_worked := p_act_hrs_worked + v_hours_in_range;
861:
858: to_char(v_hours_in_range));
859:
860: p_act_hrs_worked := p_act_hrs_worked + v_hours_in_range;
861:
862: hr_utility.trace('UDFS actual_hours_worked after call = '||
863: to_char(p_act_hrs_worked));
864:
865: ELSE
866:
863: to_char(p_act_hrs_worked));
864:
865: ELSE
866:
867: hr_utility.set_location('Prorate_Earnings', 17);
868: hr_utility.trace('Entered WORK SCHEDULE');
869:
870: hr_utility.trace('Getting WORK SCHEDULE Name');
871:
864:
865: ELSE
866:
867: hr_utility.set_location('Prorate_Earnings', 17);
868: hr_utility.trace('Entered WORK SCHEDULE');
869:
870: hr_utility.trace('Getting WORK SCHEDULE Name');
871:
872: -- Get work schedule name:
866:
867: hr_utility.set_location('Prorate_Earnings', 17);
868: hr_utility.trace('Entered WORK SCHEDULE');
869:
870: hr_utility.trace('Getting WORK SCHEDULE Name');
871:
872: -- Get work schedule name:
873:
874: v_ws_id := fnd_number.canonical_to_number(p_wsched);
872: -- Get work schedule name:
873:
874: v_ws_id := fnd_number.canonical_to_number(p_wsched);
875:
876: hr_utility.trace('v_ws_id ='||to_char(v_ws_id));
877:
878: SELECT user_column_name
879: INTO v_ws_name
880: FROM pay_user_columns
881: WHERE user_column_id = v_ws_id
882: AND NVL(business_group_id, p_bg_id) = p_bg_id
883: AND NVL(legislation_code,'US') = 'US';
884:
885: hr_utility.trace('v_ws_name ='||v_ws_name );
886: hr_utility.trace('Calling Work_Schedule_Total_Hours');
887:
888: v_hours_in_range := Work_Schedule_Total_Hours(
889: p_bg_id,
882: AND NVL(business_group_id, p_bg_id) = p_bg_id
883: AND NVL(legislation_code,'US') = 'US';
884:
885: hr_utility.trace('v_ws_name ='||v_ws_name );
886: hr_utility.trace('Calling Work_Schedule_Total_Hours');
887:
888: v_hours_in_range := Work_Schedule_Total_Hours(
889: p_bg_id,
890: v_ws_name,
891: p_range_start_date,
892: p_range_end_date);
893:
894: p_act_hrs_worked := p_act_hrs_worked + v_hours_in_range;
895: hr_utility.trace('v_hours_in_range = '||to_char(v_hours_in_range));
896:
897: END IF; -- Hours in date range via work schedule or std hours.
898: */
899:
897: END IF; -- Hours in date range via work schedule or std hours.
898: */
899:
900:
901: hr_utility.trace('calling PAY_CORE_FF_UDFS.calculate_actual_hours_worked');
902: v_hours_in_range := pay_core_ff_udfs.calculate_actual_hours_worked (
903: null
904: ,p_asst_id
905: ,p_bus_grp_id
916: ,v_return_status
917: ,v_return_message);
918:
919: p_act_hrs_worked := p_act_hrs_worked + v_hours_in_range;
920: hr_utility.trace('v_hours_in_range = '||to_char(v_hours_in_range));
921:
922:
923: hr_utility.trace('v_prorated_earnings = p_asg_hrly_rate * v_hours_in_range');
924:
919: p_act_hrs_worked := p_act_hrs_worked + v_hours_in_range;
920: hr_utility.trace('v_hours_in_range = '||to_char(v_hours_in_range));
921:
922:
923: hr_utility.trace('v_prorated_earnings = p_asg_hrly_rate * v_hours_in_range');
924:
925:
926: hr_utility.trace('v_prorated_earnings = p_asg_hrly_rate * v_hours_in_range');
927:
922:
923: hr_utility.trace('v_prorated_earnings = p_asg_hrly_rate * v_hours_in_range');
924:
925:
926: hr_utility.trace('v_prorated_earnings = p_asg_hrly_rate * v_hours_in_range');
927:
928: v_prorated_earn := v_prorated_earn + (p_asg_hrly_rate * v_hours_in_range);
929:
930: hr_utility.trace('UDFS final v_prorated_earnings = '||to_char(v_prorated_earn));
926: hr_utility.trace('v_prorated_earnings = p_asg_hrly_rate * v_hours_in_range');
927:
928: v_prorated_earn := v_prorated_earn + (p_asg_hrly_rate * v_hours_in_range);
929:
930: hr_utility.trace('UDFS final v_prorated_earnings = '||to_char(v_prorated_earn));
931: hr_utility.set_location('Prorate_Earnings', 97);
932: p_act_hrs_worked := ROUND(p_act_hrs_worked, 3);
933: hr_utility.trace('p_act_hrs_worked ='||to_char(p_act_hrs_worked));
934: hr_utility.trace('UDFS Leaving Prorated Earnings');
927:
928: v_prorated_earn := v_prorated_earn + (p_asg_hrly_rate * v_hours_in_range);
929:
930: hr_utility.trace('UDFS final v_prorated_earnings = '||to_char(v_prorated_earn));
931: hr_utility.set_location('Prorate_Earnings', 97);
932: p_act_hrs_worked := ROUND(p_act_hrs_worked, 3);
933: hr_utility.trace('p_act_hrs_worked ='||to_char(p_act_hrs_worked));
934: hr_utility.trace('UDFS Leaving Prorated Earnings');
935:
929:
930: hr_utility.trace('UDFS final v_prorated_earnings = '||to_char(v_prorated_earn));
931: hr_utility.set_location('Prorate_Earnings', 97);
932: p_act_hrs_worked := ROUND(p_act_hrs_worked, 3);
933: hr_utility.trace('p_act_hrs_worked ='||to_char(p_act_hrs_worked));
934: hr_utility.trace('UDFS Leaving Prorated Earnings');
935:
936: RETURN v_prorated_earn;
937:
930: hr_utility.trace('UDFS final v_prorated_earnings = '||to_char(v_prorated_earn));
931: hr_utility.set_location('Prorate_Earnings', 97);
932: p_act_hrs_worked := ROUND(p_act_hrs_worked, 3);
933: hr_utility.trace('p_act_hrs_worked ='||to_char(p_act_hrs_worked));
934: hr_utility.trace('UDFS Leaving Prorated Earnings');
935:
936: RETURN v_prorated_earn;
937:
938: END Prorate_Earnings;
986: --p_work_sched := 'NOT ENTERED';
987: v_eev_prorated_earnings := 0;
988:
989:
990: hr_utility.trace('UDFS Entering PRORATE_EEV');
991: hr_utility.trace('p_bus_group_id ='||to_char(p_bus_group_id));
992: hr_utility.trace('p_pay_id ='||to_char(p_pay_id));
993: -- hr_utility.trace('p_work_sched ='||p_work_sched);
994: --hr_utility.trace('p_asg_std_hrs ='||to_char(p_asg_std_hrs));
987: v_eev_prorated_earnings := 0;
988:
989:
990: hr_utility.trace('UDFS Entering PRORATE_EEV');
991: hr_utility.trace('p_bus_group_id ='||to_char(p_bus_group_id));
992: hr_utility.trace('p_pay_id ='||to_char(p_pay_id));
993: -- hr_utility.trace('p_work_sched ='||p_work_sched);
994: --hr_utility.trace('p_asg_std_hrs ='||to_char(p_asg_std_hrs));
995: -- hr_utility.trace('p_asg_std_freq ='||p_asg_std_freq);
988:
989:
990: hr_utility.trace('UDFS Entering PRORATE_EEV');
991: hr_utility.trace('p_bus_group_id ='||to_char(p_bus_group_id));
992: hr_utility.trace('p_pay_id ='||to_char(p_pay_id));
993: -- hr_utility.trace('p_work_sched ='||p_work_sched);
994: --hr_utility.trace('p_asg_std_hrs ='||to_char(p_asg_std_hrs));
995: -- hr_utility.trace('p_asg_std_freq ='||p_asg_std_freq);
996: hr_utility.trace('p_pay_basis ='||p_pay_basis);
989:
990: hr_utility.trace('UDFS Entering PRORATE_EEV');
991: hr_utility.trace('p_bus_group_id ='||to_char(p_bus_group_id));
992: hr_utility.trace('p_pay_id ='||to_char(p_pay_id));
993: -- hr_utility.trace('p_work_sched ='||p_work_sched);
994: --hr_utility.trace('p_asg_std_hrs ='||to_char(p_asg_std_hrs));
995: -- hr_utility.trace('p_asg_std_freq ='||p_asg_std_freq);
996: hr_utility.trace('p_pay_basis ='||p_pay_basis);
997: hr_utility.trace('p_hrly_rate ='||to_char(p_hrly_rate));
990: hr_utility.trace('UDFS Entering PRORATE_EEV');
991: hr_utility.trace('p_bus_group_id ='||to_char(p_bus_group_id));
992: hr_utility.trace('p_pay_id ='||to_char(p_pay_id));
993: -- hr_utility.trace('p_work_sched ='||p_work_sched);
994: --hr_utility.trace('p_asg_std_hrs ='||to_char(p_asg_std_hrs));
995: -- hr_utility.trace('p_asg_std_freq ='||p_asg_std_freq);
996: hr_utility.trace('p_pay_basis ='||p_pay_basis);
997: hr_utility.trace('p_hrly_rate ='||to_char(p_hrly_rate));
998: hr_utility.trace('UDFS p_range_start_date ='||to_char(p_range_start_date));
991: hr_utility.trace('p_bus_group_id ='||to_char(p_bus_group_id));
992: hr_utility.trace('p_pay_id ='||to_char(p_pay_id));
993: -- hr_utility.trace('p_work_sched ='||p_work_sched);
994: --hr_utility.trace('p_asg_std_hrs ='||to_char(p_asg_std_hrs));
995: -- hr_utility.trace('p_asg_std_freq ='||p_asg_std_freq);
996: hr_utility.trace('p_pay_basis ='||p_pay_basis);
997: hr_utility.trace('p_hrly_rate ='||to_char(p_hrly_rate));
998: hr_utility.trace('UDFS p_range_start_date ='||to_char(p_range_start_date));
999: hr_utility.trace('UDFS p_range_end_date ='||to_char(p_range_end_date));
992: hr_utility.trace('p_pay_id ='||to_char(p_pay_id));
993: -- hr_utility.trace('p_work_sched ='||p_work_sched);
994: --hr_utility.trace('p_asg_std_hrs ='||to_char(p_asg_std_hrs));
995: -- hr_utility.trace('p_asg_std_freq ='||p_asg_std_freq);
996: hr_utility.trace('p_pay_basis ='||p_pay_basis);
997: hr_utility.trace('p_hrly_rate ='||to_char(p_hrly_rate));
998: hr_utility.trace('UDFS p_range_start_date ='||to_char(p_range_start_date));
999: hr_utility.trace('UDFS p_range_end_date ='||to_char(p_range_end_date));
1000: hr_utility.trace('p_actual_hrs_worked ='||to_char(p_actual_hrs_worked));
993: -- hr_utility.trace('p_work_sched ='||p_work_sched);
994: --hr_utility.trace('p_asg_std_hrs ='||to_char(p_asg_std_hrs));
995: -- hr_utility.trace('p_asg_std_freq ='||p_asg_std_freq);
996: hr_utility.trace('p_pay_basis ='||p_pay_basis);
997: hr_utility.trace('p_hrly_rate ='||to_char(p_hrly_rate));
998: hr_utility.trace('UDFS p_range_start_date ='||to_char(p_range_start_date));
999: hr_utility.trace('UDFS p_range_end_date ='||to_char(p_range_end_date));
1000: hr_utility.trace('p_actual_hrs_worked ='||to_char(p_actual_hrs_worked));
1001: hr_utility.trace('p_element_entry_id ='||to_char(p_element_entry_id));
994: --hr_utility.trace('p_asg_std_hrs ='||to_char(p_asg_std_hrs));
995: -- hr_utility.trace('p_asg_std_freq ='||p_asg_std_freq);
996: hr_utility.trace('p_pay_basis ='||p_pay_basis);
997: hr_utility.trace('p_hrly_rate ='||to_char(p_hrly_rate));
998: hr_utility.trace('UDFS p_range_start_date ='||to_char(p_range_start_date));
999: hr_utility.trace('UDFS p_range_end_date ='||to_char(p_range_end_date));
1000: hr_utility.trace('p_actual_hrs_worked ='||to_char(p_actual_hrs_worked));
1001: hr_utility.trace('p_element_entry_id ='||to_char(p_element_entry_id));
1002: hr_utility.trace('p_inpval_id ='||to_char(p_inpval_id));
995: -- hr_utility.trace('p_asg_std_freq ='||p_asg_std_freq);
996: hr_utility.trace('p_pay_basis ='||p_pay_basis);
997: hr_utility.trace('p_hrly_rate ='||to_char(p_hrly_rate));
998: hr_utility.trace('UDFS p_range_start_date ='||to_char(p_range_start_date));
999: hr_utility.trace('UDFS p_range_end_date ='||to_char(p_range_end_date));
1000: hr_utility.trace('p_actual_hrs_worked ='||to_char(p_actual_hrs_worked));
1001: hr_utility.trace('p_element_entry_id ='||to_char(p_element_entry_id));
1002: hr_utility.trace('p_inpval_id ='||to_char(p_inpval_id));
1003: --
996: hr_utility.trace('p_pay_basis ='||p_pay_basis);
997: hr_utility.trace('p_hrly_rate ='||to_char(p_hrly_rate));
998: hr_utility.trace('UDFS p_range_start_date ='||to_char(p_range_start_date));
999: hr_utility.trace('UDFS p_range_end_date ='||to_char(p_range_end_date));
1000: hr_utility.trace('p_actual_hrs_worked ='||to_char(p_actual_hrs_worked));
1001: hr_utility.trace('p_element_entry_id ='||to_char(p_element_entry_id));
1002: hr_utility.trace('p_inpval_id ='||to_char(p_inpval_id));
1003: --
1004: -- Find all EEV changes, calculate new hourly rate, prorate:
997: hr_utility.trace('p_hrly_rate ='||to_char(p_hrly_rate));
998: hr_utility.trace('UDFS p_range_start_date ='||to_char(p_range_start_date));
999: hr_utility.trace('UDFS p_range_end_date ='||to_char(p_range_end_date));
1000: hr_utility.trace('p_actual_hrs_worked ='||to_char(p_actual_hrs_worked));
1001: hr_utility.trace('p_element_entry_id ='||to_char(p_element_entry_id));
1002: hr_utility.trace('p_inpval_id ='||to_char(p_inpval_id));
1003: --
1004: -- Find all EEV changes, calculate new hourly rate, prorate:
1005: -- SELECT (EEV1):
998: hr_utility.trace('UDFS p_range_start_date ='||to_char(p_range_start_date));
999: hr_utility.trace('UDFS p_range_end_date ='||to_char(p_range_end_date));
1000: hr_utility.trace('p_actual_hrs_worked ='||to_char(p_actual_hrs_worked));
1001: hr_utility.trace('p_element_entry_id ='||to_char(p_element_entry_id));
1002: hr_utility.trace('p_inpval_id ='||to_char(p_inpval_id));
1003: --
1004: -- Find all EEV changes, calculate new hourly rate, prorate:
1005: -- SELECT (EEV1):
1006: -- Select for SINGLE record that includes Period Start Date but does not
1007: -- span entire period.
1008: -- We know this select will return a row, otherwise there would be no
1009: -- EEV changes to detect.
1010: --
1011: hr_utility.set_location('Prorate_EEV', 103);
1012: SELECT EEV.screen_entry_value,
1013: GREATEST(EEV.effective_start_date, p_range_start_date),
1014: EEV.effective_end_date
1015: INTO v_earnings_entry,
1022: AND EEV.effective_end_date >= p_range_start_date
1023: AND EEV.effective_end_date < p_range_end_date;
1024:
1025:
1026: hr_utility.trace('screen_entry_value ='||v_earnings_entry);
1027: hr_utility.trace('v_entry_start ='||to_char(v_entry_start));
1028: hr_utility.trace('v_entry_end ='||to_char(v_entry_end));
1029: hr_utility.trace('Calling Convert_Period_Type ');
1030: hr_utility.set_location('Prorate_EEV', 105);
1023: AND EEV.effective_end_date < p_range_end_date;
1024:
1025:
1026: hr_utility.trace('screen_entry_value ='||v_earnings_entry);
1027: hr_utility.trace('v_entry_start ='||to_char(v_entry_start));
1028: hr_utility.trace('v_entry_end ='||to_char(v_entry_end));
1029: hr_utility.trace('Calling Convert_Period_Type ');
1030: hr_utility.set_location('Prorate_EEV', 105);
1031:
1024:
1025:
1026: hr_utility.trace('screen_entry_value ='||v_earnings_entry);
1027: hr_utility.trace('v_entry_start ='||to_char(v_entry_start));
1028: hr_utility.trace('v_entry_end ='||to_char(v_entry_end));
1029: hr_utility.trace('Calling Convert_Period_Type ');
1030: hr_utility.set_location('Prorate_EEV', 105);
1031:
1032: v_curr_hrly_rate := Convert_Period_Type(p_bus_grp_id
1025:
1026: hr_utility.trace('screen_entry_value ='||v_earnings_entry);
1027: hr_utility.trace('v_entry_start ='||to_char(v_entry_start));
1028: hr_utility.trace('v_entry_end ='||to_char(v_entry_end));
1029: hr_utility.trace('Calling Convert_Period_Type ');
1030: hr_utility.set_location('Prorate_EEV', 105);
1031:
1032: v_curr_hrly_rate := Convert_Period_Type(p_bus_grp_id
1033: ,p_asst_id
1026: hr_utility.trace('screen_entry_value ='||v_earnings_entry);
1027: hr_utility.trace('v_entry_start ='||to_char(v_entry_start));
1028: hr_utility.trace('v_entry_end ='||to_char(v_entry_end));
1029: hr_utility.trace('Calling Convert_Period_Type ');
1030: hr_utility.set_location('Prorate_EEV', 105);
1031:
1032: v_curr_hrly_rate := Convert_Period_Type(p_bus_grp_id
1033: ,p_asst_id
1034: ,p_payroll_id
1059: 'HOURLY',
1060: p_period_start,
1061: p_period_end,
1062: p_asg_std_freq); */
1063: hr_utility.trace('v_curr_hrly_rate ='||to_char(v_curr_hrly_rate));
1064: hr_utility.set_location('Prorate_EEV', 107);
1065:
1066: v_eev_prorated_earnings := v_eev_prorated_earnings +
1067: Prorate_Earnings (
1060: p_period_start,
1061: p_period_end,
1062: p_asg_std_freq); */
1063: hr_utility.trace('v_curr_hrly_rate ='||to_char(v_curr_hrly_rate));
1064: hr_utility.set_location('Prorate_EEV', 107);
1065:
1066: v_eev_prorated_earnings := v_eev_prorated_earnings +
1067: Prorate_Earnings (
1068: p_bg_id => p_bus_group_id,
1070: p_range_start_date => v_entry_start,
1071: p_range_end_date => v_entry_end,
1072: p_act_hrs_worked => p_actual_hrs_worked);
1073:
1074: hr_utility.trace('v_eev_prorated_earnings ='||
1075: to_char(v_eev_prorated_earnings));
1076: -- SELECT (EEV2):
1077: hr_utility.trace('Opening get_entry_chgs cursor EEV2');
1078:
1073:
1074: hr_utility.trace('v_eev_prorated_earnings ='||
1075: to_char(v_eev_prorated_earnings));
1076: -- SELECT (EEV2):
1077: hr_utility.trace('Opening get_entry_chgs cursor EEV2');
1078:
1079: OPEN get_entry_chgs (p_range_start_date, p_range_end_date);
1080: LOOP
1081: --
1084: v_entry_start,
1085: v_entry_end;
1086: EXIT WHEN get_entry_chgs%NOTFOUND;
1087: --
1088: hr_utility.trace('v_earnings_entry ='||v_earnings_entry);
1089: hr_utility.trace('v_entry_start ='||to_char(v_entry_start));
1090: hr_utility.trace('v_entry_end ='||to_char(v_entry_end));
1091: hr_utility.set_location('Prorate_EEV', 115);
1092: --
1085: v_entry_end;
1086: EXIT WHEN get_entry_chgs%NOTFOUND;
1087: --
1088: hr_utility.trace('v_earnings_entry ='||v_earnings_entry);
1089: hr_utility.trace('v_entry_start ='||to_char(v_entry_start));
1090: hr_utility.trace('v_entry_end ='||to_char(v_entry_end));
1091: hr_utility.set_location('Prorate_EEV', 115);
1092: --
1093: -- For each range of dates found, add to running prorated earnings total.
1086: EXIT WHEN get_entry_chgs%NOTFOUND;
1087: --
1088: hr_utility.trace('v_earnings_entry ='||v_earnings_entry);
1089: hr_utility.trace('v_entry_start ='||to_char(v_entry_start));
1090: hr_utility.trace('v_entry_end ='||to_char(v_entry_end));
1091: hr_utility.set_location('Prorate_EEV', 115);
1092: --
1093: -- For each range of dates found, add to running prorated earnings total.
1094: --
1087: --
1088: hr_utility.trace('v_earnings_entry ='||v_earnings_entry);
1089: hr_utility.trace('v_entry_start ='||to_char(v_entry_start));
1090: hr_utility.trace('v_entry_end ='||to_char(v_entry_end));
1091: hr_utility.set_location('Prorate_EEV', 115);
1092: --
1093: -- For each range of dates found, add to running prorated earnings total.
1094: --
1095: hr_utility.trace('Calling Convert_Period_Type ');
1091: hr_utility.set_location('Prorate_EEV', 115);
1092: --
1093: -- For each range of dates found, add to running prorated earnings total.
1094: --
1095: hr_utility.trace('Calling Convert_Period_Type ');
1096:
1097: v_curr_hrly_rate := Convert_Period_Type(p_bus_grp_id
1098: ,p_asst_id
1099: ,p_payroll_id
1117: p_period_end,
1118: p_asg_std_freq); */
1119:
1120:
1121: hr_utility.trace('v_curr_hrly_rate ='||to_char(v_curr_hrly_rate));
1122: hr_utility.set_location('Prorate_EEV', 119);
1123: v_eev_prorated_earnings := v_eev_prorated_earnings +
1124: Prorate_Earnings (
1125: p_bg_id => p_bus_group_id,
1118: p_asg_std_freq); */
1119:
1120:
1121: hr_utility.trace('v_curr_hrly_rate ='||to_char(v_curr_hrly_rate));
1122: hr_utility.set_location('Prorate_EEV', 119);
1123: v_eev_prorated_earnings := v_eev_prorated_earnings +
1124: Prorate_Earnings (
1125: p_bg_id => p_bus_group_id,
1126: p_asg_hrly_rate => v_curr_hrly_rate,
1127: p_range_start_date => v_entry_start,
1128: p_range_end_date => v_entry_end,
1129: p_act_hrs_worked => p_actual_hrs_worked);
1130:
1131: hr_utility.trace('v_eev_prorated_earnings ='||to_char(v_eev_prorated_earnings));
1132:
1133: END LOOP;
1134: --
1135: CLOSE get_entry_chgs;
1138: -- Select for SINGLE record that exists across Period End Date:
1139: -- NOTE: Will only return a row if select (2) does not return a row where
1140: -- Effective End Date = Period End Date !
1141:
1142: hr_utility.trace('Select EEV3');
1143: hr_utility.set_location('Prorate_EEV', 141);
1144: SELECT EEV.screen_entry_value,
1145: EEV.effective_start_date,
1146: LEAST(EEV.effective_end_date, p_range_end_date)
1139: -- NOTE: Will only return a row if select (2) does not return a row where
1140: -- Effective End Date = Period End Date !
1141:
1142: hr_utility.trace('Select EEV3');
1143: hr_utility.set_location('Prorate_EEV', 141);
1144: SELECT EEV.screen_entry_value,
1145: EEV.effective_start_date,
1146: LEAST(EEV.effective_end_date, p_range_end_date)
1147: INTO v_earnings_entry,
1152: AND EEV.input_value_id = p_inpval_id
1153: AND EEV.effective_start_date > p_range_start_date
1154: AND EEV.effective_start_date <= p_range_end_date
1155: AND EEV.effective_end_date > p_range_end_date;
1156: hr_utility.set_location('Prorate_EEV', 147);
1157: hr_utility.trace('screen_entry_value ='||v_earnings_entry);
1158: hr_utility.trace('v_entry_start ='||to_char(v_entry_start));
1159: hr_utility.trace('v_entry_end ='||to_char(v_entry_end));
1160:
1153: AND EEV.effective_start_date > p_range_start_date
1154: AND EEV.effective_start_date <= p_range_end_date
1155: AND EEV.effective_end_date > p_range_end_date;
1156: hr_utility.set_location('Prorate_EEV', 147);
1157: hr_utility.trace('screen_entry_value ='||v_earnings_entry);
1158: hr_utility.trace('v_entry_start ='||to_char(v_entry_start));
1159: hr_utility.trace('v_entry_end ='||to_char(v_entry_end));
1160:
1161: hr_utility.trace('Calling Convert_Period_Type ');
1154: AND EEV.effective_start_date <= p_range_end_date
1155: AND EEV.effective_end_date > p_range_end_date;
1156: hr_utility.set_location('Prorate_EEV', 147);
1157: hr_utility.trace('screen_entry_value ='||v_earnings_entry);
1158: hr_utility.trace('v_entry_start ='||to_char(v_entry_start));
1159: hr_utility.trace('v_entry_end ='||to_char(v_entry_end));
1160:
1161: hr_utility.trace('Calling Convert_Period_Type ');
1162:
1155: AND EEV.effective_end_date > p_range_end_date;
1156: hr_utility.set_location('Prorate_EEV', 147);
1157: hr_utility.trace('screen_entry_value ='||v_earnings_entry);
1158: hr_utility.trace('v_entry_start ='||to_char(v_entry_start));
1159: hr_utility.trace('v_entry_end ='||to_char(v_entry_end));
1160:
1161: hr_utility.trace('Calling Convert_Period_Type ');
1162:
1163: v_curr_hrly_rate := Convert_Period_Type(p_bus_grp_id
1157: hr_utility.trace('screen_entry_value ='||v_earnings_entry);
1158: hr_utility.trace('v_entry_start ='||to_char(v_entry_start));
1159: hr_utility.trace('v_entry_end ='||to_char(v_entry_end));
1160:
1161: hr_utility.trace('Calling Convert_Period_Type ');
1162:
1163: v_curr_hrly_rate := Convert_Period_Type(p_bus_grp_id
1164: ,p_asst_id
1165: ,p_payroll_id
1181: p_period_start,
1182: p_period_end,
1183: p_asg_std_freq);
1184: */
1185: hr_utility.set_location('Prorate_EEV', 151);
1186: hr_utility.trace('After Call v_curr_hrly_rate ='||to_char(v_curr_hrly_rate));
1187:
1188: v_eev_prorated_earnings := v_eev_prorated_earnings +
1189: Prorate_Earnings (
1182: p_period_end,
1183: p_asg_std_freq);
1184: */
1185: hr_utility.set_location('Prorate_EEV', 151);
1186: hr_utility.trace('After Call v_curr_hrly_rate ='||to_char(v_curr_hrly_rate));
1187:
1188: v_eev_prorated_earnings := v_eev_prorated_earnings +
1189: Prorate_Earnings (
1190: p_bg_id => p_bus_group_id,
1193: p_range_end_date => v_entry_end,
1194: p_act_hrs_worked => p_actual_hrs_worked);
1195:
1196: -- We're Done!
1197: hr_utility.trace('v_eev_prorated_earnings ='||
1198: to_char(v_eev_prorated_earnings));
1199: hr_utility.set_location('Prorate_EEV', 167);
1200: p_actual_hrs_worked := ROUND(p_actual_hrs_worked, 3);
1201: p_hrly_rate := v_curr_hrly_rate;
1195:
1196: -- We're Done!
1197: hr_utility.trace('v_eev_prorated_earnings ='||
1198: to_char(v_eev_prorated_earnings));
1199: hr_utility.set_location('Prorate_EEV', 167);
1200: p_actual_hrs_worked := ROUND(p_actual_hrs_worked, 3);
1201: p_hrly_rate := v_curr_hrly_rate;
1202:
1203: hr_utility.trace('p_actual_hrs_worked ='||to_char(p_actual_hrs_worked));
1199: hr_utility.set_location('Prorate_EEV', 167);
1200: p_actual_hrs_worked := ROUND(p_actual_hrs_worked, 3);
1201: p_hrly_rate := v_curr_hrly_rate;
1202:
1203: hr_utility.trace('p_actual_hrs_worked ='||to_char(p_actual_hrs_worked));
1204: hr_utility.trace('p_hrly_rate ='||to_char(p_hrly_rate));
1205:
1206: hr_utility.trace('UDFS Leaving Prorated EEV');
1207:
1200: p_actual_hrs_worked := ROUND(p_actual_hrs_worked, 3);
1201: p_hrly_rate := v_curr_hrly_rate;
1202:
1203: hr_utility.trace('p_actual_hrs_worked ='||to_char(p_actual_hrs_worked));
1204: hr_utility.trace('p_hrly_rate ='||to_char(p_hrly_rate));
1205:
1206: hr_utility.trace('UDFS Leaving Prorated EEV');
1207:
1208: RETURN v_eev_prorated_earnings;
1202:
1203: hr_utility.trace('p_actual_hrs_worked ='||to_char(p_actual_hrs_worked));
1204: hr_utility.trace('p_hrly_rate ='||to_char(p_hrly_rate));
1205:
1206: hr_utility.trace('UDFS Leaving Prorated EEV');
1207:
1208: RETURN v_eev_prorated_earnings;
1209:
1210: EXCEPTION WHEN NO_DATA_FOUND THEN
1207:
1208: RETURN v_eev_prorated_earnings;
1209:
1210: EXCEPTION WHEN NO_DATA_FOUND THEN
1211: hr_utility.set_location('Prorate_EEV', 177);
1212: hr_utility.trace('Into exception of Prorate_EEV');
1213:
1214: p_actual_hrs_worked := ROUND(p_actual_hrs_worked, 3);
1215: p_hrly_rate := v_curr_hrly_rate;
1208: RETURN v_eev_prorated_earnings;
1209:
1210: EXCEPTION WHEN NO_DATA_FOUND THEN
1211: hr_utility.set_location('Prorate_EEV', 177);
1212: hr_utility.trace('Into exception of Prorate_EEV');
1213:
1214: p_actual_hrs_worked := ROUND(p_actual_hrs_worked, 3);
1215: p_hrly_rate := v_curr_hrly_rate;
1216:
1213:
1214: p_actual_hrs_worked := ROUND(p_actual_hrs_worked, 3);
1215: p_hrly_rate := v_curr_hrly_rate;
1216:
1217: hr_utility.trace('p_actual_hrs_worked ='||to_char(p_actual_hrs_worked));
1218: hr_utility.trace('p_hrly_rate ='||to_char(p_hrly_rate));
1219:
1220: RETURN v_eev_prorated_earnings;
1221:
1214: p_actual_hrs_worked := ROUND(p_actual_hrs_worked, 3);
1215: p_hrly_rate := v_curr_hrly_rate;
1216:
1217: hr_utility.trace('p_actual_hrs_worked ='||to_char(p_actual_hrs_worked));
1218: hr_utility.trace('p_hrly_rate ='||to_char(p_hrly_rate));
1219:
1220: RETURN v_eev_prorated_earnings;
1221:
1222: END Prorate_EEV;
1255:
1256: /* Init */
1257: l_vac_pay := 0;
1258:
1259: hr_utility.set_location('get_vac_pay', 11);
1260: hr_utility.trace('Entered Vacation Pay');
1261:
1262: OPEN get_vac_hours (p_asg_id, p_eff_date);
1263: LOOP
1256: /* Init */
1257: l_vac_pay := 0;
1258:
1259: hr_utility.set_location('get_vac_pay', 11);
1260: hr_utility.trace('Entered Vacation Pay');
1261:
1262: OPEN get_vac_hours (p_asg_id, p_eff_date);
1263: LOOP
1264:
1261:
1262: OPEN get_vac_hours (p_asg_id, p_eff_date);
1263: LOOP
1264:
1265: hr_utility.set_location('get_vac_pay', 13);
1266: hr_utility.trace('Opened get_vac_hours');
1267:
1268: FETCH get_vac_hours
1269: INTO l_vac_hours;
1262: OPEN get_vac_hours (p_asg_id, p_eff_date);
1263: LOOP
1264:
1265: hr_utility.set_location('get_vac_pay', 13);
1266: hr_utility.trace('Opened get_vac_hours');
1267:
1268: FETCH get_vac_hours
1269: INTO l_vac_hours;
1270: EXIT WHEN get_vac_hours%NOTFOUND;
1273:
1274: END LOOP;
1275: CLOSE get_vac_hours;
1276:
1277: hr_utility.set_location('get_vac_pay', 15);
1278:
1279: IF p_vac_hours <> 0 THEN
1280:
1281: l_vac_pay := p_vac_hours * p_curr_rate;
1281: l_vac_pay := p_vac_hours * p_curr_rate;
1282:
1283: END IF;
1284:
1285: hr_utility.trace('Leaving Vacation Pay');
1286: RETURN l_vac_pay;
1287:
1288: END vacation_pay;
1289:
1319:
1320: /* Init */
1321: l_sick_pay :=0;
1322:
1323: hr_utility.set_location('get_sick_pay', 11);
1324: hr_utility.trace('Entered Sick Pay');
1325:
1326: OPEN get_sick_hours (p_asg_id, p_eff_date);
1327: LOOP
1320: /* Init */
1321: l_sick_pay :=0;
1322:
1323: hr_utility.set_location('get_sick_pay', 11);
1324: hr_utility.trace('Entered Sick Pay');
1325:
1326: OPEN get_sick_hours (p_asg_id, p_eff_date);
1327: LOOP
1328:
1325:
1326: OPEN get_sick_hours (p_asg_id, p_eff_date);
1327: LOOP
1328:
1329: hr_utility.trace('get_sick_pay');
1330: hr_utility.set_location('get_sick_pay', 13);
1331:
1332: FETCH get_sick_hours
1333: INTO l_sick_hours;
1326: OPEN get_sick_hours (p_asg_id, p_eff_date);
1327: LOOP
1328:
1329: hr_utility.trace('get_sick_pay');
1330: hr_utility.set_location('get_sick_pay', 13);
1331:
1332: FETCH get_sick_hours
1333: INTO l_sick_hours;
1334: EXIT WHEN get_sick_hours%NOTFOUND;
1337:
1338: END LOOP;
1339: CLOSE get_sick_hours;
1340:
1341: hr_utility.set_location('get_sick_pay', 15);
1342: hr_utility.trace('get_sick_pay');
1343:
1344: IF p_sick_hours <> 0 THEN
1345:
1338: END LOOP;
1339: CLOSE get_sick_hours;
1340:
1341: hr_utility.set_location('get_sick_pay', 15);
1342: hr_utility.trace('get_sick_pay');
1343:
1344: IF p_sick_hours <> 0 THEN
1345:
1346: l_sick_pay := p_sick_hours * p_curr_rate;
1346: l_sick_pay := p_sick_hours * p_curr_rate;
1347:
1348: END IF;
1349:
1350: hr_utility.trace('Leaving get_sick_pay');
1351: RETURN l_sick_pay;
1352:
1353: END sick_pay;
1354:
1360: v_prorated_earnings := 0;
1361: v_curr_hrly_rate := 0;
1362: l_mid_period_asg_change := FALSE;
1363:
1364: -- hr_utility.trace_on(null,'coreff');
1365:
1366: hr_utility.trace('UDFS Entered Calculate_Period_Earnings');
1367: hr_utility.trace('p_asst_id ='||to_char(p_asst_id));
1368: hr_utility.trace('p_payroll_id ='||to_char(p_payroll_id));
1362: l_mid_period_asg_change := FALSE;
1363:
1364: -- hr_utility.trace_on(null,'coreff');
1365:
1366: hr_utility.trace('UDFS Entered Calculate_Period_Earnings');
1367: hr_utility.trace('p_asst_id ='||to_char(p_asst_id));
1368: hr_utility.trace('p_payroll_id ='||to_char(p_payroll_id));
1369: hr_utility.trace('p_ele_entry_id ='||to_char(p_ele_entry_id));
1370: hr_utility.trace('p_tax_unit_id ='||to_char(p_tax_unit_id));
1363:
1364: -- hr_utility.trace_on(null,'coreff');
1365:
1366: hr_utility.trace('UDFS Entered Calculate_Period_Earnings');
1367: hr_utility.trace('p_asst_id ='||to_char(p_asst_id));
1368: hr_utility.trace('p_payroll_id ='||to_char(p_payroll_id));
1369: hr_utility.trace('p_ele_entry_id ='||to_char(p_ele_entry_id));
1370: hr_utility.trace('p_tax_unit_id ='||to_char(p_tax_unit_id));
1371: hr_utility.trace('p_date_earned ='||to_char(p_date_earned));
1364: -- hr_utility.trace_on(null,'coreff');
1365:
1366: hr_utility.trace('UDFS Entered Calculate_Period_Earnings');
1367: hr_utility.trace('p_asst_id ='||to_char(p_asst_id));
1368: hr_utility.trace('p_payroll_id ='||to_char(p_payroll_id));
1369: hr_utility.trace('p_ele_entry_id ='||to_char(p_ele_entry_id));
1370: hr_utility.trace('p_tax_unit_id ='||to_char(p_tax_unit_id));
1371: hr_utility.trace('p_date_earned ='||to_char(p_date_earned));
1372: hr_utility.trace('p_pay_basis ='||p_pay_basis);
1365:
1366: hr_utility.trace('UDFS Entered Calculate_Period_Earnings');
1367: hr_utility.trace('p_asst_id ='||to_char(p_asst_id));
1368: hr_utility.trace('p_payroll_id ='||to_char(p_payroll_id));
1369: hr_utility.trace('p_ele_entry_id ='||to_char(p_ele_entry_id));
1370: hr_utility.trace('p_tax_unit_id ='||to_char(p_tax_unit_id));
1371: hr_utility.trace('p_date_earned ='||to_char(p_date_earned));
1372: hr_utility.trace('p_pay_basis ='||p_pay_basis);
1373: hr_utility.trace('p_inpval_name ='||p_inpval_name);
1366: hr_utility.trace('UDFS Entered Calculate_Period_Earnings');
1367: hr_utility.trace('p_asst_id ='||to_char(p_asst_id));
1368: hr_utility.trace('p_payroll_id ='||to_char(p_payroll_id));
1369: hr_utility.trace('p_ele_entry_id ='||to_char(p_ele_entry_id));
1370: hr_utility.trace('p_tax_unit_id ='||to_char(p_tax_unit_id));
1371: hr_utility.trace('p_date_earned ='||to_char(p_date_earned));
1372: hr_utility.trace('p_pay_basis ='||p_pay_basis);
1373: hr_utility.trace('p_inpval_name ='||p_inpval_name);
1374: hr_utility.trace('p_ass_hrly_figure ='||to_char(p_ass_hrly_figure));
1367: hr_utility.trace('p_asst_id ='||to_char(p_asst_id));
1368: hr_utility.trace('p_payroll_id ='||to_char(p_payroll_id));
1369: hr_utility.trace('p_ele_entry_id ='||to_char(p_ele_entry_id));
1370: hr_utility.trace('p_tax_unit_id ='||to_char(p_tax_unit_id));
1371: hr_utility.trace('p_date_earned ='||to_char(p_date_earned));
1372: hr_utility.trace('p_pay_basis ='||p_pay_basis);
1373: hr_utility.trace('p_inpval_name ='||p_inpval_name);
1374: hr_utility.trace('p_ass_hrly_figure ='||to_char(p_ass_hrly_figure));
1375: hr_utility.trace('UDFS p_period_start ='||to_char(p_period_start));
1368: hr_utility.trace('p_payroll_id ='||to_char(p_payroll_id));
1369: hr_utility.trace('p_ele_entry_id ='||to_char(p_ele_entry_id));
1370: hr_utility.trace('p_tax_unit_id ='||to_char(p_tax_unit_id));
1371: hr_utility.trace('p_date_earned ='||to_char(p_date_earned));
1372: hr_utility.trace('p_pay_basis ='||p_pay_basis);
1373: hr_utility.trace('p_inpval_name ='||p_inpval_name);
1374: hr_utility.trace('p_ass_hrly_figure ='||to_char(p_ass_hrly_figure));
1375: hr_utility.trace('UDFS p_period_start ='||to_char(p_period_start));
1376: hr_utility.trace('UDFS p_period_end ='||to_char(p_period_end));
1369: hr_utility.trace('p_ele_entry_id ='||to_char(p_ele_entry_id));
1370: hr_utility.trace('p_tax_unit_id ='||to_char(p_tax_unit_id));
1371: hr_utility.trace('p_date_earned ='||to_char(p_date_earned));
1372: hr_utility.trace('p_pay_basis ='||p_pay_basis);
1373: hr_utility.trace('p_inpval_name ='||p_inpval_name);
1374: hr_utility.trace('p_ass_hrly_figure ='||to_char(p_ass_hrly_figure));
1375: hr_utility.trace('UDFS p_period_start ='||to_char(p_period_start));
1376: hr_utility.trace('UDFS p_period_end ='||to_char(p_period_end));
1377: --hr_utility.trace('p_work_schedule ='||p_work_schedule);
1370: hr_utility.trace('p_tax_unit_id ='||to_char(p_tax_unit_id));
1371: hr_utility.trace('p_date_earned ='||to_char(p_date_earned));
1372: hr_utility.trace('p_pay_basis ='||p_pay_basis);
1373: hr_utility.trace('p_inpval_name ='||p_inpval_name);
1374: hr_utility.trace('p_ass_hrly_figure ='||to_char(p_ass_hrly_figure));
1375: hr_utility.trace('UDFS p_period_start ='||to_char(p_period_start));
1376: hr_utility.trace('UDFS p_period_end ='||to_char(p_period_end));
1377: --hr_utility.trace('p_work_schedule ='||p_work_schedule);
1378: --hr_utility.trace('p_asst_std_hrs ='||to_char(p_asst_std_hrs));
1371: hr_utility.trace('p_date_earned ='||to_char(p_date_earned));
1372: hr_utility.trace('p_pay_basis ='||p_pay_basis);
1373: hr_utility.trace('p_inpval_name ='||p_inpval_name);
1374: hr_utility.trace('p_ass_hrly_figure ='||to_char(p_ass_hrly_figure));
1375: hr_utility.trace('UDFS p_period_start ='||to_char(p_period_start));
1376: hr_utility.trace('UDFS p_period_end ='||to_char(p_period_end));
1377: --hr_utility.trace('p_work_schedule ='||p_work_schedule);
1378: --hr_utility.trace('p_asst_std_hrs ='||to_char(p_asst_std_hrs));
1379: hr_utility.trace('p_actual_hours_worked ='||to_char(p_actual_hours_worked));
1372: hr_utility.trace('p_pay_basis ='||p_pay_basis);
1373: hr_utility.trace('p_inpval_name ='||p_inpval_name);
1374: hr_utility.trace('p_ass_hrly_figure ='||to_char(p_ass_hrly_figure));
1375: hr_utility.trace('UDFS p_period_start ='||to_char(p_period_start));
1376: hr_utility.trace('UDFS p_period_end ='||to_char(p_period_end));
1377: --hr_utility.trace('p_work_schedule ='||p_work_schedule);
1378: --hr_utility.trace('p_asst_std_hrs ='||to_char(p_asst_std_hrs));
1379: hr_utility.trace('p_actual_hours_worked ='||to_char(p_actual_hours_worked));
1380: hr_utility.trace('p_vac_hours_worked ='||to_char(p_vac_hours_worked));
1373: hr_utility.trace('p_inpval_name ='||p_inpval_name);
1374: hr_utility.trace('p_ass_hrly_figure ='||to_char(p_ass_hrly_figure));
1375: hr_utility.trace('UDFS p_period_start ='||to_char(p_period_start));
1376: hr_utility.trace('UDFS p_period_end ='||to_char(p_period_end));
1377: --hr_utility.trace('p_work_schedule ='||p_work_schedule);
1378: --hr_utility.trace('p_asst_std_hrs ='||to_char(p_asst_std_hrs));
1379: hr_utility.trace('p_actual_hours_worked ='||to_char(p_actual_hours_worked));
1380: hr_utility.trace('p_vac_hours_worked ='||to_char(p_vac_hours_worked));
1381: hr_utility.trace('p_vac_pay ='||to_char(p_vac_pay));
1374: hr_utility.trace('p_ass_hrly_figure ='||to_char(p_ass_hrly_figure));
1375: hr_utility.trace('UDFS p_period_start ='||to_char(p_period_start));
1376: hr_utility.trace('UDFS p_period_end ='||to_char(p_period_end));
1377: --hr_utility.trace('p_work_schedule ='||p_work_schedule);
1378: --hr_utility.trace('p_asst_std_hrs ='||to_char(p_asst_std_hrs));
1379: hr_utility.trace('p_actual_hours_worked ='||to_char(p_actual_hours_worked));
1380: hr_utility.trace('p_vac_hours_worked ='||to_char(p_vac_hours_worked));
1381: hr_utility.trace('p_vac_pay ='||to_char(p_vac_pay));
1382: hr_utility.trace('p_sick_hours_worked ='||to_char(p_sick_hours_worked));
1375: hr_utility.trace('UDFS p_period_start ='||to_char(p_period_start));
1376: hr_utility.trace('UDFS p_period_end ='||to_char(p_period_end));
1377: --hr_utility.trace('p_work_schedule ='||p_work_schedule);
1378: --hr_utility.trace('p_asst_std_hrs ='||to_char(p_asst_std_hrs));
1379: hr_utility.trace('p_actual_hours_worked ='||to_char(p_actual_hours_worked));
1380: hr_utility.trace('p_vac_hours_worked ='||to_char(p_vac_hours_worked));
1381: hr_utility.trace('p_vac_pay ='||to_char(p_vac_pay));
1382: hr_utility.trace('p_sick_hours_worked ='||to_char(p_sick_hours_worked));
1383: hr_utility.trace('p_sick_pay ='||to_char(p_sick_pay));
1376: hr_utility.trace('UDFS p_period_end ='||to_char(p_period_end));
1377: --hr_utility.trace('p_work_schedule ='||p_work_schedule);
1378: --hr_utility.trace('p_asst_std_hrs ='||to_char(p_asst_std_hrs));
1379: hr_utility.trace('p_actual_hours_worked ='||to_char(p_actual_hours_worked));
1380: hr_utility.trace('p_vac_hours_worked ='||to_char(p_vac_hours_worked));
1381: hr_utility.trace('p_vac_pay ='||to_char(p_vac_pay));
1382: hr_utility.trace('p_sick_hours_worked ='||to_char(p_sick_hours_worked));
1383: hr_utility.trace('p_sick_pay ='||to_char(p_sick_pay));
1384: hr_utility.trace('UDFS p_prorate ='||p_prorate);
1377: --hr_utility.trace('p_work_schedule ='||p_work_schedule);
1378: --hr_utility.trace('p_asst_std_hrs ='||to_char(p_asst_std_hrs));
1379: hr_utility.trace('p_actual_hours_worked ='||to_char(p_actual_hours_worked));
1380: hr_utility.trace('p_vac_hours_worked ='||to_char(p_vac_hours_worked));
1381: hr_utility.trace('p_vac_pay ='||to_char(p_vac_pay));
1382: hr_utility.trace('p_sick_hours_worked ='||to_char(p_sick_hours_worked));
1383: hr_utility.trace('p_sick_pay ='||to_char(p_sick_pay));
1384: hr_utility.trace('UDFS p_prorate ='||p_prorate);
1385: hr_utility.trace('p_asst_std_freq ='||p_asst_std_freq);
1378: --hr_utility.trace('p_asst_std_hrs ='||to_char(p_asst_std_hrs));
1379: hr_utility.trace('p_actual_hours_worked ='||to_char(p_actual_hours_worked));
1380: hr_utility.trace('p_vac_hours_worked ='||to_char(p_vac_hours_worked));
1381: hr_utility.trace('p_vac_pay ='||to_char(p_vac_pay));
1382: hr_utility.trace('p_sick_hours_worked ='||to_char(p_sick_hours_worked));
1383: hr_utility.trace('p_sick_pay ='||to_char(p_sick_pay));
1384: hr_utility.trace('UDFS p_prorate ='||p_prorate);
1385: hr_utility.trace('p_asst_std_freq ='||p_asst_std_freq);
1386:
1379: hr_utility.trace('p_actual_hours_worked ='||to_char(p_actual_hours_worked));
1380: hr_utility.trace('p_vac_hours_worked ='||to_char(p_vac_hours_worked));
1381: hr_utility.trace('p_vac_pay ='||to_char(p_vac_pay));
1382: hr_utility.trace('p_sick_hours_worked ='||to_char(p_sick_hours_worked));
1383: hr_utility.trace('p_sick_pay ='||to_char(p_sick_pay));
1384: hr_utility.trace('UDFS p_prorate ='||p_prorate);
1385: hr_utility.trace('p_asst_std_freq ='||p_asst_std_freq);
1386:
1387: hr_utility.trace('Find earnings element input value id');
1380: hr_utility.trace('p_vac_hours_worked ='||to_char(p_vac_hours_worked));
1381: hr_utility.trace('p_vac_pay ='||to_char(p_vac_pay));
1382: hr_utility.trace('p_sick_hours_worked ='||to_char(p_sick_hours_worked));
1383: hr_utility.trace('p_sick_pay ='||to_char(p_sick_pay));
1384: hr_utility.trace('UDFS p_prorate ='||p_prorate);
1385: hr_utility.trace('p_asst_std_freq ='||p_asst_std_freq);
1386:
1387: hr_utility.trace('Find earnings element input value id');
1388:
1381: hr_utility.trace('p_vac_pay ='||to_char(p_vac_pay));
1382: hr_utility.trace('p_sick_hours_worked ='||to_char(p_sick_hours_worked));
1383: hr_utility.trace('p_sick_pay ='||to_char(p_sick_pay));
1384: hr_utility.trace('UDFS p_prorate ='||p_prorate);
1385: hr_utility.trace('p_asst_std_freq ='||p_asst_std_freq);
1386:
1387: hr_utility.trace('Find earnings element input value id');
1388:
1389: p_actual_hours_worked := 0;
1383: hr_utility.trace('p_sick_pay ='||to_char(p_sick_pay));
1384: hr_utility.trace('UDFS p_prorate ='||p_prorate);
1385: hr_utility.trace('p_asst_std_freq ='||p_asst_std_freq);
1386:
1387: hr_utility.trace('Find earnings element input value id');
1388:
1389: p_actual_hours_worked := 0;
1390:
1391: -- Step (1): Find earnings element input value.
1398: IF p_pay_basis IS NOT NULL THEN
1399:
1400: BEGIN
1401:
1402: hr_utility.trace(' p_pay_basis IS NOT NULL');
1403: hr_utility.set_location('calculate_period_earnings', 10);
1404:
1405: SELECT PYB.input_value_id,
1406: FCL.meaning
1399:
1400: BEGIN
1401:
1402: hr_utility.trace(' p_pay_basis IS NOT NULL');
1403: hr_utility.set_location('calculate_period_earnings', 10);
1404:
1405: SELECT PYB.input_value_id,
1406: FCL.meaning
1407: INTO v_inpval_id,
1417: AND p_date_earned BETWEEN ASG.effective_start_date
1418: AND ASG.effective_end_date;
1419:
1420: EXCEPTION WHEN NO_DATA_FOUND THEN
1421: hr_utility.set_location('calculate_period_earnings', 11);
1422: hr_utility.trace(' In EXCEPTION p_pay_basis IS NOT NULL');
1423:
1424: v_period_earn := 0;
1425: p_actual_hours_worked := ROUND(p_actual_hours_worked, 3);
1418: AND ASG.effective_end_date;
1419:
1420: EXCEPTION WHEN NO_DATA_FOUND THEN
1421: hr_utility.set_location('calculate_period_earnings', 11);
1422: hr_utility.trace(' In EXCEPTION p_pay_basis IS NOT NULL');
1423:
1424: v_period_earn := 0;
1425: p_actual_hours_worked := ROUND(p_actual_hours_worked, 3);
1426:
1423:
1424: v_period_earn := 0;
1425: p_actual_hours_worked := ROUND(p_actual_hours_worked, 3);
1426:
1427: hr_utility.trace('p_actual_hours_worked ='||to_char(p_actual_hours_worked));
1428:
1429: RETURN v_period_earn;
1430:
1431:
1430:
1431:
1432: END;
1433:
1434: hr_utility.trace('p_inpval_name = '||p_inpval_name);
1435:
1436: ELSIF UPPER(p_inpval_name) = 'RATE' THEN
1437:
1438: hr_utility.trace(' p_pay_basis IS NULL');
1434: hr_utility.trace('p_inpval_name = '||p_inpval_name);
1435:
1436: ELSIF UPPER(p_inpval_name) = 'RATE' THEN
1437:
1438: hr_utility.trace(' p_pay_basis IS NULL');
1439: hr_utility.trace('In p_inpval_name = RATE');
1440: /* Changed the element_name and name to init case and added
1441: the date join for pay_element_types_f */
1442:
1435:
1436: ELSIF UPPER(p_inpval_name) = 'RATE' THEN
1437:
1438: hr_utility.trace(' p_pay_basis IS NULL');
1439: hr_utility.trace('In p_inpval_name = RATE');
1440: /* Changed the element_name and name to init case and added
1441: the date join for pay_element_types_f */
1442:
1443: begin
1457: v_pay_basis := 'HOURLY';
1458: --
1459: EXCEPTION WHEN NO_DATA_FOUND THEN
1460:
1461: hr_utility.trace('Exception of RATE ');
1462:
1463: v_period_earn := 0;
1464: p_actual_hours_worked := ROUND(p_actual_hours_worked, 3);
1465:
1462:
1463: v_period_earn := 0;
1464: p_actual_hours_worked := ROUND(p_actual_hours_worked, 3);
1465:
1466: hr_utility.trace('p_actual_hours_worked ='||to_char(p_actual_hours_worked));
1467:
1468: RETURN v_period_earn;
1469: end;
1470: --
1472: /* Changed the element_name and name to init case and added
1473: the date join for pay_element_types_f */
1474:
1475: begin
1476: hr_utility.trace('In RATE CODE');
1477:
1478: SELECT IPV.input_value_id
1479: INTO v_inpval_id
1480: FROM pay_input_values_f IPV,
1490: --
1491: v_pay_basis := 'HOURLY';
1492: --
1493: EXCEPTION WHEN NO_DATA_FOUND THEN
1494: hr_utility.trace('Exception of Rate Code');
1495:
1496: v_period_earn := 0;
1497: p_actual_hours_worked := ROUND(p_actual_hours_worked, 3);
1498:
1495:
1496: v_period_earn := 0;
1497: p_actual_hours_worked := ROUND(p_actual_hours_worked, 3);
1498:
1499: hr_utility.trace('p_actual_hours_worked ='||to_char(p_actual_hours_worked));
1500:
1501: RETURN v_period_earn;
1502:
1503: end;
1507: /* Changed the element_name and name to init case and added
1508: the date join for pay_element_types_f */
1509:
1510: begin
1511: hr_utility.trace('in MONTHLY SALARY');
1512:
1513: SELECT IPV.input_value_id
1514: INTO v_inpval_id
1515: FROM pay_input_values_f IPV,
1525:
1526: v_pay_basis := 'MONTHLY';
1527:
1528: EXCEPTION WHEN NO_DATA_FOUND THEN
1529: hr_utility.set_location('calculate_period_earnings', 18);
1530: v_period_earn := 0;
1531: p_actual_hours_worked := ROUND(p_actual_hours_worked, 3);
1532: hr_utility.trace('p_actual_hours_worked ='||to_char(p_actual_hours_worked));
1533: RETURN v_period_earn;
1528: EXCEPTION WHEN NO_DATA_FOUND THEN
1529: hr_utility.set_location('calculate_period_earnings', 18);
1530: v_period_earn := 0;
1531: p_actual_hours_worked := ROUND(p_actual_hours_worked, 3);
1532: hr_utility.trace('p_actual_hours_worked ='||to_char(p_actual_hours_worked));
1533: RETURN v_period_earn;
1534: END;
1535:
1536: END IF;
1534: END;
1535:
1536: END IF;
1537:
1538: hr_utility.trace('Now know the pay basis for this assignment');
1539: hr_utility.trace('v_inpval_id ='||to_char(v_inpval_id));
1540: hr_utility.trace('v_pay_basis ='||v_pay_basis);
1541: /*
1542: -- Now know the pay basis for this assignment (v_pay_basis).
1535:
1536: END IF;
1537:
1538: hr_utility.trace('Now know the pay basis for this assignment');
1539: hr_utility.trace('v_inpval_id ='||to_char(v_inpval_id));
1540: hr_utility.trace('v_pay_basis ='||v_pay_basis);
1541: /*
1542: -- Now know the pay basis for this assignment (v_pay_basis).
1543: -- Want to convert entered earnings to pay period earnings.
1536: END IF;
1537:
1538: hr_utility.trace('Now know the pay basis for this assignment');
1539: hr_utility.trace('v_inpval_id ='||to_char(v_inpval_id));
1540: hr_utility.trace('v_pay_basis ='||v_pay_basis);
1541: /*
1542: -- Now know the pay basis for this assignment (v_pay_basis).
1543: -- Want to convert entered earnings to pay period earnings.
1544: -- For pay basis of Annual, Monthly, Bi-Weekly, Semi-Monthly,
1574: -- Find # of payroll period types per fiscal year:
1575:
1576: begin
1577:
1578: hr_utility.trace('Find # of payroll period types per fiscal year');
1579: hr_utility.set_location('calculate_period_earnings', 40);
1580:
1581: SELECT TPT.number_per_fiscal_year
1582: INTO v_pay_periods_per_year
1575:
1576: begin
1577:
1578: hr_utility.trace('Find # of payroll period types per fiscal year');
1579: hr_utility.set_location('calculate_period_earnings', 40);
1580:
1581: SELECT TPT.number_per_fiscal_year
1582: INTO v_pay_periods_per_year
1583: FROM pay_payrolls_f PRL,
1587: and PRL.effective_end_date
1588: AND PRL.payroll_id = p_payroll_id
1589: AND PRL.business_group_id + 0 = p_bus_grp_id;
1590:
1591: hr_utility.trace('v_pay_periods_per_year ='||to_char(v_pay_periods_per_year));
1592:
1593: exception when NO_DATA_FOUND then
1594:
1595: hr_utility.set_location('calculate_period_earnings', 41);
1591: hr_utility.trace('v_pay_periods_per_year ='||to_char(v_pay_periods_per_year));
1592:
1593: exception when NO_DATA_FOUND then
1594:
1595: hr_utility.set_location('calculate_period_earnings', 41);
1596: hr_utility.trace('Exception Find # of payroll period');
1597: v_period_earn := 0;
1598: p_actual_hours_worked := ROUND(p_actual_hours_worked, 3);
1599: hr_utility.trace('p_actual_hours_worked ='||to_char(p_actual_hours_worked));
1592:
1593: exception when NO_DATA_FOUND then
1594:
1595: hr_utility.set_location('calculate_period_earnings', 41);
1596: hr_utility.trace('Exception Find # of payroll period');
1597: v_period_earn := 0;
1598: p_actual_hours_worked := ROUND(p_actual_hours_worked, 3);
1599: hr_utility.trace('p_actual_hours_worked ='||to_char(p_actual_hours_worked));
1600:
1595: hr_utility.set_location('calculate_period_earnings', 41);
1596: hr_utility.trace('Exception Find # of payroll period');
1597: v_period_earn := 0;
1598: p_actual_hours_worked := ROUND(p_actual_hours_worked, 3);
1599: hr_utility.trace('p_actual_hours_worked ='||to_char(p_actual_hours_worked));
1600:
1601: RETURN v_period_earn;
1602:
1603: end;
1616: -- scheduled hours, not
1617: -- actual hours for a week, converted to a period figure.
1618: */
1619: --
1620: hr_utility.set_location('calculate_period_earnings', 45);
1621: hr_utility.trace('Get hours scheduled for the current period');
1622:
1623: /*IF p_work_schedule <> 'NOT ENTERED' THEN
1624: --
1617: -- actual hours for a week, converted to a period figure.
1618: */
1619: --
1620: hr_utility.set_location('calculate_period_earnings', 45);
1621: hr_utility.trace('Get hours scheduled for the current period');
1622:
1623: /*IF p_work_schedule <> 'NOT ENTERED' THEN
1624: --
1625: -- Find hours worked between period start and end dates.
1623: /*IF p_work_schedule <> 'NOT ENTERED' THEN
1624: --
1625: -- Find hours worked between period start and end dates.
1626: --
1627: hr_utility.trace('Asg has Work Schedule');
1628: hr_utility.trace('p_work_schedule ='||p_work_schedule);
1629:
1630: v_ws_id := fnd_number.canonical_to_number(p_work_schedule);
1631: hr_utility.trace('v_ws_id ='||to_char(v_ws_id));
1624: --
1625: -- Find hours worked between period start and end dates.
1626: --
1627: hr_utility.trace('Asg has Work Schedule');
1628: hr_utility.trace('p_work_schedule ='||p_work_schedule);
1629:
1630: v_ws_id := fnd_number.canonical_to_number(p_work_schedule);
1631: hr_utility.trace('v_ws_id ='||to_char(v_ws_id));
1632: --
1627: hr_utility.trace('Asg has Work Schedule');
1628: hr_utility.trace('p_work_schedule ='||p_work_schedule);
1629:
1630: v_ws_id := fnd_number.canonical_to_number(p_work_schedule);
1631: hr_utility.trace('v_ws_id ='||to_char(v_ws_id));
1632: --
1633: SELECT user_column_name
1634: INTO v_work_sched_name
1635: FROM pay_user_columns
1636: WHERE user_column_id = v_ws_id
1637: AND NVL(business_group_id, p_bus_grp_id) = p_bus_grp_id
1638: AND NVL(legislation_code,'US') = 'US';
1639:
1640: hr_utility.trace('v_work_sched_name ='||v_work_sched_name);
1641: hr_utility.trace('Calling Work_Schedule_Total_Hours');
1642:
1643: v_hrs_per_range := Work_Schedule_Total_Hours( p_bus_grp_id,
1644: v_work_sched_name,
1637: AND NVL(business_group_id, p_bus_grp_id) = p_bus_grp_id
1638: AND NVL(legislation_code,'US') = 'US';
1639:
1640: hr_utility.trace('v_work_sched_name ='||v_work_sched_name);
1641: hr_utility.trace('Calling Work_Schedule_Total_Hours');
1642:
1643: v_hrs_per_range := Work_Schedule_Total_Hours( p_bus_grp_id,
1644: v_work_sched_name,
1645: p_period_start,
1643: v_hrs_per_range := Work_Schedule_Total_Hours( p_bus_grp_id,
1644: v_work_sched_name,
1645: p_period_start,
1646: p_period_end);
1647: hr_utility.trace('v_hrs_per_range ='||to_char(v_hrs_per_range));
1648: ELSE
1649:
1650: hr_utility.trace('Asg has No Work Schedule');
1651: hr_utility.trace('Calling Standard_Hours_Worked');
1646: p_period_end);
1647: hr_utility.trace('v_hrs_per_range ='||to_char(v_hrs_per_range));
1648: ELSE
1649:
1650: hr_utility.trace('Asg has No Work Schedule');
1651: hr_utility.trace('Calling Standard_Hours_Worked');
1652:
1653: v_hrs_per_range := Standard_Hours_Worked( p_asst_std_hrs,
1654: p_period_start,
1647: hr_utility.trace('v_hrs_per_range ='||to_char(v_hrs_per_range));
1648: ELSE
1649:
1650: hr_utility.trace('Asg has No Work Schedule');
1651: hr_utility.trace('Calling Standard_Hours_Worked');
1652:
1653: v_hrs_per_range := Standard_Hours_Worked( p_asst_std_hrs,
1654: p_period_start,
1655: p_period_end,
1653: v_hrs_per_range := Standard_Hours_Worked( p_asst_std_hrs,
1654: p_period_start,
1655: p_period_end,
1656: p_asst_std_freq);
1657: hr_utility.trace('v_hrs_per_range ='||to_char(v_hrs_per_range));
1658:
1659: END IF;
1660: */
1661:
1674: ,v_schedule_source
1675: ,v_schedule
1676: ,v_return_status
1677: ,v_return_message);
1678: hr_utility.trace('v_hrs_per_range ='||to_char(v_hrs_per_range));
1679:
1680: hr_utility.trace('Compute earnings and actual hours');
1681: hr_utility.trace('calling convert_period_type from calculate_period_earnings');
1682: hr_utility.set_location('calculate_period_earnings', 46);
1676: ,v_return_status
1677: ,v_return_message);
1678: hr_utility.trace('v_hrs_per_range ='||to_char(v_hrs_per_range));
1679:
1680: hr_utility.trace('Compute earnings and actual hours');
1681: hr_utility.trace('calling convert_period_type from calculate_period_earnings');
1682: hr_utility.set_location('calculate_period_earnings', 46);
1683:
1684: v_period_earn := Convert_Period_Type(p_bus_grp_id
1677: ,v_return_message);
1678: hr_utility.trace('v_hrs_per_range ='||to_char(v_hrs_per_range));
1679:
1680: hr_utility.trace('Compute earnings and actual hours');
1681: hr_utility.trace('calling convert_period_type from calculate_period_earnings');
1682: hr_utility.set_location('calculate_period_earnings', 46);
1683:
1684: v_period_earn := Convert_Period_Type(p_bus_grp_id
1685: ,p_asst_id
1678: hr_utility.trace('v_hrs_per_range ='||to_char(v_hrs_per_range));
1679:
1680: hr_utility.trace('Compute earnings and actual hours');
1681: hr_utility.trace('calling convert_period_type from calculate_period_earnings');
1682: hr_utility.set_location('calculate_period_earnings', 46);
1683:
1684: v_period_earn := Convert_Period_Type(p_bus_grp_id
1685: ,p_asst_id
1686: ,p_payroll_id
1703: p_period_start,
1704: p_period_end,
1705: p_asst_std_freq); */
1706:
1707: hr_utility.trace('v_period_earn ='||to_char(v_period_earn));
1708: hr_utility.set_location('calculate_period_earnings', 47);
1709:
1710: p_actual_hours_worked := v_hrs_per_range;
1711:
1704: p_period_end,
1705: p_asst_std_freq); */
1706:
1707: hr_utility.trace('v_period_earn ='||to_char(v_period_earn));
1708: hr_utility.set_location('calculate_period_earnings', 47);
1709:
1710: p_actual_hours_worked := v_hrs_per_range;
1711:
1712: hr_utility.trace('p_actual_hours_worked ='||to_char(p_actual_hours_worked));
1708: hr_utility.set_location('calculate_period_earnings', 47);
1709:
1710: p_actual_hours_worked := v_hrs_per_range;
1711:
1712: hr_utility.trace('p_actual_hours_worked ='||to_char(p_actual_hours_worked));
1713:
1714: IF p_prorate = 'N' THEN
1715:
1716: hr_utility.trace('No proration');
1712: hr_utility.trace('p_actual_hours_worked ='||to_char(p_actual_hours_worked));
1713:
1714: IF p_prorate = 'N' THEN
1715:
1716: hr_utility.trace('No proration');
1717: hr_utility.trace('Calling p_vac_pay');
1718: hr_utility.set_location('calculate_period_earnings', 49);
1719:
1720: p_vac_pay := vacation_pay( p_vac_hours => p_vac_hours_worked,
1713:
1714: IF p_prorate = 'N' THEN
1715:
1716: hr_utility.trace('No proration');
1717: hr_utility.trace('Calling p_vac_pay');
1718: hr_utility.set_location('calculate_period_earnings', 49);
1719:
1720: p_vac_pay := vacation_pay( p_vac_hours => p_vac_hours_worked,
1721: p_asg_id => p_asst_id,
1714: IF p_prorate = 'N' THEN
1715:
1716: hr_utility.trace('No proration');
1717: hr_utility.trace('Calling p_vac_pay');
1718: hr_utility.set_location('calculate_period_earnings', 49);
1719:
1720: p_vac_pay := vacation_pay( p_vac_hours => p_vac_hours_worked,
1721: p_asg_id => p_asst_id,
1722: p_eff_date => p_period_end,
1721: p_asg_id => p_asst_id,
1722: p_eff_date => p_period_end,
1723: p_curr_rate => p_ass_hrly_figure);
1724:
1725: hr_utility.trace('p_vac_pay ='||to_char(p_vac_pay));
1726:
1727: hr_utility.trace('Calling sick Pay');
1728: p_sick_pay := sick_pay( p_sick_hours => p_sick_hours_worked,
1729: p_asg_id => p_asst_id,
1723: p_curr_rate => p_ass_hrly_figure);
1724:
1725: hr_utility.trace('p_vac_pay ='||to_char(p_vac_pay));
1726:
1727: hr_utility.trace('Calling sick Pay');
1728: p_sick_pay := sick_pay( p_sick_hours => p_sick_hours_worked,
1729: p_asg_id => p_asst_id,
1730: p_eff_date => p_period_end,
1731: p_curr_rate => p_ass_hrly_figure);
1730: p_eff_date => p_period_end,
1731: p_curr_rate => p_ass_hrly_figure);
1732:
1733:
1734: hr_utility.trace('p_sick_pay ='||to_char(p_sick_pay));
1735:
1736: p_actual_hours_worked := ROUND(p_actual_hours_worked, 3);
1737:
1738: hr_utility.trace('p_actual_hours_worked ='||to_char(p_actual_hours_worked));
1734: hr_utility.trace('p_sick_pay ='||to_char(p_sick_pay));
1735:
1736: p_actual_hours_worked := ROUND(p_actual_hours_worked, 3);
1737:
1738: hr_utility.trace('p_actual_hours_worked ='||to_char(p_actual_hours_worked));
1739: hr_utility.trace('UDFS v_period_earn ='||to_char(v_period_earn));
1740:
1741: RETURN v_period_earn;
1742:
1735:
1736: p_actual_hours_worked := ROUND(p_actual_hours_worked, 3);
1737:
1738: hr_utility.trace('p_actual_hours_worked ='||to_char(p_actual_hours_worked));
1739: hr_utility.trace('UDFS v_period_earn ='||to_char(v_period_earn));
1740:
1741: RETURN v_period_earn;
1742:
1743: END IF; /* IF p_prorate = 'N' */
1742:
1743: END IF; /* IF p_prorate = 'N' */
1744:
1745:
1746: hr_utility.trace('UDFS check for ASGMPE changes');
1747: hr_utility.set_location('calculate_period_earnings', 51);
1748: /* ************************************************************** */
1749:
1750: BEGIN /* Check ASGMPE */
1743: END IF; /* IF p_prorate = 'N' */
1744:
1745:
1746: hr_utility.trace('UDFS check for ASGMPE changes');
1747: hr_utility.set_location('calculate_period_earnings', 51);
1748: /* ************************************************************** */
1749:
1750: BEGIN /* Check ASGMPE */
1751:
1765: AND SCL.soft_coding_keyflex_id = ASG.soft_coding_keyflex_id
1766: AND SCL.segment1 = TO_CHAR(p_tax_unit_id)
1767: AND SCL.enabled_flag = 'Y' );
1768:
1769: hr_utility.trace('ASGMPE Changes found');
1770: hr_utility.trace('Need to prorate b/c of ASGMPE');
1771: hr_utility.trace('Set l_mid_period_asg_change to TRUE I');
1772:
1773: l_mid_period_asg_change := TRUE;
1766: AND SCL.segment1 = TO_CHAR(p_tax_unit_id)
1767: AND SCL.enabled_flag = 'Y' );
1768:
1769: hr_utility.trace('ASGMPE Changes found');
1770: hr_utility.trace('Need to prorate b/c of ASGMPE');
1771: hr_utility.trace('Set l_mid_period_asg_change to TRUE I');
1772:
1773: l_mid_period_asg_change := TRUE;
1774:
1767: AND SCL.enabled_flag = 'Y' );
1768:
1769: hr_utility.trace('ASGMPE Changes found');
1770: hr_utility.trace('Need to prorate b/c of ASGMPE');
1771: hr_utility.trace('Set l_mid_period_asg_change to TRUE I');
1772:
1773: l_mid_period_asg_change := TRUE;
1774:
1775: hr_utility.set_location('calculate_period_earnings', 56);
1771: hr_utility.trace('Set l_mid_period_asg_change to TRUE I');
1772:
1773: l_mid_period_asg_change := TRUE;
1774:
1775: hr_utility.set_location('calculate_period_earnings', 56);
1776: hr_utility.trace('Look for EEVMPE changes');
1777:
1778: BEGIN /* EEVMPE check - maybe pick*/
1779:
1772:
1773: l_mid_period_asg_change := TRUE;
1774:
1775: hr_utility.set_location('calculate_period_earnings', 56);
1776: hr_utility.trace('Look for EEVMPE changes');
1777:
1778: BEGIN /* EEVMPE check - maybe pick*/
1779:
1780: select 1 INTO l_eev_info_changes
1791: ) );
1792:
1793:
1794:
1795: hr_utility.trace('EEVMPE changes found after ASGMPE');
1796:
1797: EXCEPTION
1798:
1799: WHEN NO_DATA_FOUND THEN
1798:
1799: WHEN NO_DATA_FOUND THEN
1800: l_eev_info_changes := 0;
1801:
1802: hr_utility.trace('From EXCEPTION ASGMPE changes found No EEVMPE changes');
1803:
1804: END; /* EEV1 check*/
1805:
1806: EXCEPTION
1807:
1808: WHEN NO_DATA_FOUND THEN
1809:
1810: l_asg_info_changes := 0;
1811: hr_utility.trace('From EXCEPTION No ASGMPE changes, nor EEVMPE changes');
1812:
1813: END; /* ASGMPE check*/
1814:
1815: /* ************************************************ */
1815: /* ************************************************ */
1816:
1817: IF l_asg_info_changes = 0 THEN /* Check ASGMPS */
1818:
1819: hr_utility.trace(' Into l_asg_info_changes = 0');
1820: hr_utility.trace('UDFS looking for ASGMPS changes');
1821: hr_utility.set_location('calculate_period_earnings', 56);
1822:
1823: BEGIN /* ASGMPS changes */
1816:
1817: IF l_asg_info_changes = 0 THEN /* Check ASGMPS */
1818:
1819: hr_utility.trace(' Into l_asg_info_changes = 0');
1820: hr_utility.trace('UDFS looking for ASGMPS changes');
1821: hr_utility.set_location('calculate_period_earnings', 56);
1822:
1823: BEGIN /* ASGMPS changes */
1824:
1817: IF l_asg_info_changes = 0 THEN /* Check ASGMPS */
1818:
1819: hr_utility.trace(' Into l_asg_info_changes = 0');
1820: hr_utility.trace('UDFS looking for ASGMPS changes');
1821: hr_utility.set_location('calculate_period_earnings', 56);
1822:
1823: BEGIN /* ASGMPS changes */
1824:
1825: select 1 INTO l_asg_info_changes
1839: AND SCL.enabled_flag = 'Y');
1840:
1841: l_mid_period_asg_change := TRUE;
1842:
1843: hr_utility.trace('Need to prorate for ASGMPS changes');
1844: hr_utility.set_location('calculate_period_earnings', 57);
1845:
1846: BEGIN /* EEVMPE changes ASGMPS */
1847:
1840:
1841: l_mid_period_asg_change := TRUE;
1842:
1843: hr_utility.trace('Need to prorate for ASGMPS changes');
1844: hr_utility.set_location('calculate_period_earnings', 57);
1845:
1846: BEGIN /* EEVMPE changes ASGMPS */
1847:
1848: select 1 INTO l_eev_info_changes
1858: --OR ( EEV.effective_start_date between p_period_start and p_period_end)
1859: ) );
1860:
1861:
1862: hr_utility.trace('Need to prorate EEVMPS changes after ASGMPS ');
1863:
1864: EXCEPTION
1865:
1866: WHEN NO_DATA_FOUND THEN
1866: WHEN NO_DATA_FOUND THEN
1867:
1868: l_eev_info_changes := 0;
1869:
1870: hr_utility.trace('From EXCEPTIION No EEVMPE changes');
1871:
1872: END; /* EEVMPE changes */
1873:
1874: EXCEPTION
1876: WHEN NO_DATA_FOUND THEN
1877:
1878: l_asg_info_changes := 0;
1879:
1880: hr_utility.trace('From EXCEPTION no changes due to ASGMPS or EEVMPE');
1881:
1882: END; /* ASGMPS changes */
1883:
1884: END IF; /* Check ASGMPS */
1888: IF l_asg_info_changes = 0 THEN /* ASGMPE=0 and ASGMPS=0 */
1889:
1890: BEGIN /* Check for EEVMPE changes */
1891:
1892: hr_utility.set_location('calculate_period_earnings', 58);
1893: hr_utility.trace('Check for EEVMPE changes nevertheless');
1894:
1895: select 1 INTO l_eev_info_changes
1896: from dual
1889:
1890: BEGIN /* Check for EEVMPE changes */
1891:
1892: hr_utility.set_location('calculate_period_earnings', 58);
1893: hr_utility.trace('Check for EEVMPE changes nevertheless');
1894:
1895: select 1 INTO l_eev_info_changes
1896: from dual
1897: where exists (
1902: AND EEV.effective_start_date <= p_period_start
1903: AND EEV.effective_end_date >= p_period_start
1904: AND EEV.effective_end_date < p_period_end);
1905:
1906: hr_utility.trace('Proration due to EEVMPE changes');
1907:
1908:
1909: EXCEPTION
1910:
1909: EXCEPTION
1910:
1911: WHEN NO_DATA_FOUND THEN
1912:
1913: hr_utility.trace('ASG AND EEV changes DO NOT EXIST EXCEPT ');
1914:
1915: -- Either there are no changes to an Active Assignment OR
1916: -- the assignment was not active at all this period.
1917: -- Check assignment status of current asg record.
1915: -- Either there are no changes to an Active Assignment OR
1916: -- the assignment was not active at all this period.
1917: -- Check assignment status of current asg record.
1918:
1919: hr_utility.trace(' Check assignment status of current asg record');
1920:
1921: SELECT AST.per_system_status
1922: INTO v_asg_status
1923: FROM per_assignments_f ASG,
1932: AND SCL.enabled_flag = 'Y';
1933:
1934: IF v_asg_status <> 'ACTIVE_ASSIGN' THEN
1935:
1936: hr_utility.trace(' Asg not active');
1937: v_period_earn := 0;
1938: p_actual_hours_worked := 0;
1939:
1940: END IF;
1938: p_actual_hours_worked := 0;
1939:
1940: END IF;
1941:
1942: hr_utility.trace('Chk for vac pay since no ASG EEV changes to prorate' );
1943:
1944: p_vac_pay := vacation_pay(p_vac_hours => p_vac_hours_worked,
1945: p_asg_id => p_asst_id,
1946: p_eff_date => p_period_end,
1945: p_asg_id => p_asst_id,
1946: p_eff_date => p_period_end,
1947: p_curr_rate => p_ass_hrly_figure);
1948:
1949: hr_utility.trace('p_vac_pay ='||p_vac_pay);
1950: p_sick_pay := sick_pay( p_sick_hours => p_sick_hours_worked,
1951: p_asg_id => p_asst_id,
1952: p_eff_date => p_period_end,
1953: p_curr_rate => p_ass_hrly_figure);
1952: p_eff_date => p_period_end,
1953: p_curr_rate => p_ass_hrly_figure);
1954:
1955:
1956: hr_utility.trace('p_sick_pay ='||p_sick_pay);
1957:
1958: p_actual_hours_worked := ROUND(p_actual_hours_worked, 3);
1959: RETURN v_period_earn;
1960:
1972:
1973: /* ************** ONLY ASG CHANGES START **** */
1974:
1975: p_actual_hours_worked := 0;
1976: hr_utility.set_location('calculate_period_earnings', 70);
1977: hr_utility.trace('UDFS ONLY ASG CHANGES START');
1978:
1979: BEGIN /* Get Asg Details ASGMPE */
1980:
1973: /* ************** ONLY ASG CHANGES START **** */
1974:
1975: p_actual_hours_worked := 0;
1976: hr_utility.set_location('calculate_period_earnings', 70);
1977: hr_utility.trace('UDFS ONLY ASG CHANGES START');
1978:
1979: BEGIN /* Get Asg Details ASGMPE */
1980:
1981: hr_utility.trace('Get Asg details - ASGMPE');
1977: hr_utility.trace('UDFS ONLY ASG CHANGES START');
1978:
1979: BEGIN /* Get Asg Details ASGMPE */
1980:
1981: hr_utility.trace('Get Asg details - ASGMPE');
1982: hr_utility.set_location('calculate_period_earnings', 71);
1983:
1984: SELECT GREATEST(ASG.effective_start_date, p_period_start),
1985: ASG.effective_end_date,
1978:
1979: BEGIN /* Get Asg Details ASGMPE */
1980:
1981: hr_utility.trace('Get Asg details - ASGMPE');
1982: hr_utility.set_location('calculate_period_earnings', 71);
1983:
1984: SELECT GREATEST(ASG.effective_start_date, p_period_start),
1985: ASG.effective_end_date,
1986: NVL(ASG.NORMAL_HOURS, 0),
2008: AND HRL.lookup_code(+) = ASG.frequency
2009: AND HRL.lookup_type(+) = 'FREQUENCY';
2010:
2011:
2012: hr_utility.trace('If ASGMPE Details succ. then Calling Prorate_Earnings');
2013: hr_utility.set_location('calculate_period_earnings', 72);
2014: v_prorated_earnings := v_prorated_earnings +
2015: Prorate_Earnings (
2016: p_bg_id => p_bus_grp_id,
2009: AND HRL.lookup_type(+) = 'FREQUENCY';
2010:
2011:
2012: hr_utility.trace('If ASGMPE Details succ. then Calling Prorate_Earnings');
2013: hr_utility.set_location('calculate_period_earnings', 72);
2014: v_prorated_earnings := v_prorated_earnings +
2015: Prorate_Earnings (
2016: p_bg_id => p_bus_grp_id,
2017: p_asg_hrly_rate => p_ass_hrly_figure,
2018: p_range_start_date => v_range_start,
2019: p_range_end_date => v_range_end,
2020: p_act_hrs_worked => p_actual_hours_worked);
2021:
2022: hr_utility.trace('After Calling Prorate_Earnings');
2023:
2024: EXCEPTION WHEN NO_DATA_FOUND THEN
2025:
2026: NULL;
2027:
2028: END; /* Get Asg Details */
2029:
2030:
2031: hr_utility.trace('ONLY ASG , select MULTIASG');
2032: hr_utility.set_location('calculate_period_earnings', 77);
2033:
2034: OPEN get_asst_chgs; -- SELECT (ASG2 MULTIASG)
2035: LOOP
2028: END; /* Get Asg Details */
2029:
2030:
2031: hr_utility.trace('ONLY ASG , select MULTIASG');
2032: hr_utility.set_location('calculate_period_earnings', 77);
2033:
2034: OPEN get_asst_chgs; -- SELECT (ASG2 MULTIASG)
2035: LOOP
2036:
2040: v_asst_std_hrs,
2041: v_asst_std_freq,
2042: v_work_schedule;
2043: EXIT WHEN get_asst_chgs%NOTFOUND;
2044: hr_utility.set_location('calculate_period_earnings', 79);
2045:
2046:
2047: hr_utility.trace('ONLY ASG Calling Prorate_Earning as MULTIASG successful');
2048:
2043: EXIT WHEN get_asst_chgs%NOTFOUND;
2044: hr_utility.set_location('calculate_period_earnings', 79);
2045:
2046:
2047: hr_utility.trace('ONLY ASG Calling Prorate_Earning as MULTIASG successful');
2048:
2049: v_prorated_earnings := v_prorated_earnings +
2050: Prorate_Earnings (
2051: p_bg_id => p_bus_grp_id,
2054: p_range_end_date => v_range_end,
2055: p_act_hrs_worked => p_actual_hours_worked);
2056:
2057:
2058: hr_utility.trace('After calling Prorate_Earnings from MULTIASG');
2059:
2060: END LOOP;
2061:
2062: CLOSE get_asst_chgs;
2062: CLOSE get_asst_chgs;
2063:
2064: BEGIN /* END_SPAN_RECORD */
2065:
2066: hr_utility.set_location('calculate_period_earnings', 89);
2067: hr_utility.trace('ONLY ASG , select END_SPAN_RECORD');
2068:
2069: SELECT ASG.effective_start_date,
2070: LEAST(ASG.effective_end_date, p_period_end),
2063:
2064: BEGIN /* END_SPAN_RECORD */
2065:
2066: hr_utility.set_location('calculate_period_earnings', 89);
2067: hr_utility.trace('ONLY ASG , select END_SPAN_RECORD');
2068:
2069: SELECT ASG.effective_start_date,
2070: LEAST(ASG.effective_end_date, p_period_end),
2071: NVL(ASG.normal_hours, 0),
2092: AND SCL.enabled_flag = 'Y'
2093: AND HRL.lookup_code(+) = ASG.frequency
2094: AND HRL.lookup_type(+) = 'FREQUENCY';
2095:
2096: hr_utility.trace('Calling Prorate_Earnings for ONLY ASG END_SPAN_RECORD');
2097: hr_utility.set_location('calculate_period_earnings', 91);
2098: v_prorated_earnings := v_prorated_earnings +
2099: Prorate_Earnings (
2100: p_bg_id => p_bus_grp_id,
2093: AND HRL.lookup_code(+) = ASG.frequency
2094: AND HRL.lookup_type(+) = 'FREQUENCY';
2095:
2096: hr_utility.trace('Calling Prorate_Earnings for ONLY ASG END_SPAN_RECORD');
2097: hr_utility.set_location('calculate_period_earnings', 91);
2098: v_prorated_earnings := v_prorated_earnings +
2099: Prorate_Earnings (
2100: p_bg_id => p_bus_grp_id,
2101: p_asg_hrly_rate => p_ass_hrly_figure,
2103: p_range_end_date => v_range_end,
2104: p_act_hrs_worked => p_actual_hours_worked);
2105:
2106:
2107: hr_utility.trace('Calling Vacation Pay as END_SPAN succ');
2108: hr_utility.set_location('calculate_period_earnings', 101);
2109:
2110: p_vac_pay := vacation_pay( p_vac_hours => p_vac_hours_worked,
2111: p_asg_id => p_asst_id,
2104: p_act_hrs_worked => p_actual_hours_worked);
2105:
2106:
2107: hr_utility.trace('Calling Vacation Pay as END_SPAN succ');
2108: hr_utility.set_location('calculate_period_earnings', 101);
2109:
2110: p_vac_pay := vacation_pay( p_vac_hours => p_vac_hours_worked,
2111: p_asg_id => p_asst_id,
2112: p_eff_date => p_period_end,
2111: p_asg_id => p_asst_id,
2112: p_eff_date => p_period_end,
2113: p_curr_rate => p_ass_hrly_figure);
2114:
2115: hr_utility.trace('Calling Sick Pay as ASG3 succ');
2116:
2117: p_sick_pay := sick_pay( p_sick_hours => p_sick_hours_worked,
2118: p_asg_id => p_asst_id,
2119: p_eff_date => p_period_end,
2123: p_actual_hours_worked := ROUND(p_actual_hours_worked, 3);
2124: RETURN v_prorated_earnings;
2125:
2126: EXCEPTION WHEN NO_DATA_FOUND THEN
2127: hr_utility.set_location('calculate_period_earnings', 102);
2128: hr_utility.trace('Exception of ASG_MID_START_LAST_SPAN_END_DT');
2129:
2130: p_vac_pay := vacation_pay( p_vac_hours => p_vac_hours_worked,
2131: p_asg_id => p_asst_id,
2124: RETURN v_prorated_earnings;
2125:
2126: EXCEPTION WHEN NO_DATA_FOUND THEN
2127: hr_utility.set_location('calculate_period_earnings', 102);
2128: hr_utility.trace('Exception of ASG_MID_START_LAST_SPAN_END_DT');
2129:
2130: p_vac_pay := vacation_pay( p_vac_hours => p_vac_hours_worked,
2131: p_asg_id => p_asst_id,
2132: p_eff_date => p_period_end,
2131: p_asg_id => p_asst_id,
2132: p_eff_date => p_period_end,
2133: p_curr_rate => p_ass_hrly_figure);
2134:
2135: hr_utility.trace('Calling Sick Pay as ASG3 not succ');
2136: p_sick_pay := sick_pay( p_sick_hours => p_sick_hours_worked,
2137: p_asg_id => p_asst_id,
2138: p_eff_date => p_period_end,
2139: p_curr_rate => p_ass_hrly_figure);
2150: ELSIF (l_asg_info_changes = 0) AND (l_eev_info_changes > 0) THEN
2151:
2152: /* ******************* ONLY EEV CHANGES START ****** */
2153:
2154: hr_utility.trace(' Only EEV changes exist');
2155: hr_utility.set_location('calculate_period_earnings', 103);
2156: p_actual_hours_worked := 0;
2157:
2158:
2151:
2152: /* ******************* ONLY EEV CHANGES START ****** */
2153:
2154: hr_utility.trace(' Only EEV changes exist');
2155: hr_utility.set_location('calculate_period_earnings', 103);
2156: p_actual_hours_worked := 0;
2157:
2158:
2159: hr_utility.trace('Calling Prorate_EEV');
2155: hr_utility.set_location('calculate_period_earnings', 103);
2156: p_actual_hours_worked := 0;
2157:
2158:
2159: hr_utility.trace('Calling Prorate_EEV');
2160:
2161: v_prorated_earnings := v_prorated_earnings +
2162: Prorate_EEV (
2163: p_bus_group_id => p_bus_grp_id,
2169: p_actual_hrs_worked => p_actual_hours_worked,
2170: p_element_entry_id => p_ele_entry_id,
2171: p_inpval_id => v_inpval_id);
2172:
2173: hr_utility.trace('After Calling Prorate_EEV');
2174: hr_utility.set_location('calculate_period_earnings', 127);
2175:
2176: hr_utility.trace('Calling vacation_pay');
2177:
2170: p_element_entry_id => p_ele_entry_id,
2171: p_inpval_id => v_inpval_id);
2172:
2173: hr_utility.trace('After Calling Prorate_EEV');
2174: hr_utility.set_location('calculate_period_earnings', 127);
2175:
2176: hr_utility.trace('Calling vacation_pay');
2177:
2178: p_vac_pay := vacation_pay( p_vac_hours => p_vac_hours_worked,
2172:
2173: hr_utility.trace('After Calling Prorate_EEV');
2174: hr_utility.set_location('calculate_period_earnings', 127);
2175:
2176: hr_utility.trace('Calling vacation_pay');
2177:
2178: p_vac_pay := vacation_pay( p_vac_hours => p_vac_hours_worked,
2179: p_asg_id => p_asst_id,
2180: p_eff_date => p_period_end,
2179: p_asg_id => p_asst_id,
2180: p_eff_date => p_period_end,
2181: p_curr_rate => p_ass_hrly_figure);
2182:
2183: hr_utility.trace('Calling sick_pay');
2184:
2185: p_sick_pay := sick_pay( p_sick_hours => p_sick_hours_worked,
2186: p_asg_id => p_asst_id,
2187: p_eff_date => p_period_end,
2197:
2198: /* ******************* BOTH ASG AND EEV CHANGES START ************ */
2199:
2200:
2201: hr_utility.trace('UDFS BOTH ASG and EEV chages exist');
2202:
2203:
2204: p_actual_hours_worked := 0;
2205:
2205:
2206:
2207: BEGIN /* Latest Screen Entry Value */
2208:
2209: hr_utility.trace('BOTH ASG Get latest screen entry value for EEVMPE');
2210: hr_utility.set_location('calculate_period_earnings', 128);
2211:
2212: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
2213: INTO v_earnings_entry
2206:
2207: BEGIN /* Latest Screen Entry Value */
2208:
2209: hr_utility.trace('BOTH ASG Get latest screen entry value for EEVMPE');
2210: hr_utility.set_location('calculate_period_earnings', 128);
2211:
2212: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
2213: INTO v_earnings_entry
2214: FROM pay_element_entry_values_f EEV
2221: AND EEV.effective_end_date > p_period_start;
2222: */
2223: --AND EEV.effective_end_date < p_period_end
2224:
2225: hr_utility.trace('BOTH ASG Get ASGMPE ');
2226:
2227: SELECT GREATEST(ASG.effective_start_date, p_period_start),
2228: ASG.effective_end_date,
2229: NVL(ASG.NORMAL_HOURS, 0),
2250: AND SCL.enabled_flag = 'Y'
2251: AND HRL.lookup_code(+) = ASG.frequency
2252: AND HRL.lookup_type(+) = 'FREQUENCY';
2253:
2254: hr_utility.trace('Calling Convert_Period_Type from ASGMPE');
2255: hr_utility.set_location('v_earnings_entry='||v_earnings_entry, 129);
2256:
2257: v_curr_hrly_rate := Convert_Period_Type(p_bus_grp_id
2258: ,p_asst_id
2251: AND HRL.lookup_code(+) = ASG.frequency
2252: AND HRL.lookup_type(+) = 'FREQUENCY';
2253:
2254: hr_utility.trace('Calling Convert_Period_Type from ASGMPE');
2255: hr_utility.set_location('v_earnings_entry='||v_earnings_entry, 129);
2256:
2257: v_curr_hrly_rate := Convert_Period_Type(p_bus_grp_id
2258: ,p_asst_id
2259: ,p_payroll_id
2275: p_period_start,
2276: p_period_end,
2277: v_asst_std_freq);*/
2278:
2279: hr_utility.trace('Select app. EEVMPE again after range is determined');
2280: hr_utility.set_location('calculate_period_earnings', 130);
2281:
2282: SELECT COUNT(EEV.element_entry_value_id)
2283: INTO l_eev_info_changes
2276: p_period_end,
2277: v_asst_std_freq);*/
2278:
2279: hr_utility.trace('Select app. EEVMPE again after range is determined');
2280: hr_utility.set_location('calculate_period_earnings', 130);
2281:
2282: SELECT COUNT(EEV.element_entry_value_id)
2283: INTO l_eev_info_changes
2284: FROM pay_element_entry_values_f EEV
2290:
2291: IF l_eev_info_changes = 0 THEN
2292:
2293:
2294: hr_utility.trace('NO EEVMPE changes');
2295: hr_utility.set_location('calculate_period_earnings', 132);
2296:
2297: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
2298: INTO v_earnings_entry
2291: IF l_eev_info_changes = 0 THEN
2292:
2293:
2294: hr_utility.trace('NO EEVMPE changes');
2295: hr_utility.set_location('calculate_period_earnings', 132);
2296:
2297: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
2298: INTO v_earnings_entry
2299: FROM pay_element_entry_values_f EEV
2301: AND EEV.input_value_id = v_inpval_id
2302: AND v_range_end BETWEEN EEV.effective_start_date
2303: AND EEV.effective_end_date;
2304:
2305: hr_utility.trace('Calling Convert_Period_Type');
2306: hr_utility.set_location('calculate_period_earnings', 134);
2307:
2308: v_curr_hrly_rate := Convert_Period_Type(p_bus_grp_id
2309: ,p_asst_id
2302: AND v_range_end BETWEEN EEV.effective_start_date
2303: AND EEV.effective_end_date;
2304:
2305: hr_utility.trace('Calling Convert_Period_Type');
2306: hr_utility.set_location('calculate_period_earnings', 134);
2307:
2308: v_curr_hrly_rate := Convert_Period_Type(p_bus_grp_id
2309: ,p_asst_id
2310: ,p_payroll_id
2326: p_period_start,
2327: p_period_end,
2328: v_asst_std_freq);*/
2329:
2330: hr_utility.trace('Calling Prorate_Earnings');
2331: hr_utility.set_location('calculate_period_earnings', 135);
2332:
2333: v_prorated_earnings := v_prorated_earnings +
2334: Prorate_Earnings (
2327: p_period_end,
2328: v_asst_std_freq);*/
2329:
2330: hr_utility.trace('Calling Prorate_Earnings');
2331: hr_utility.set_location('calculate_period_earnings', 135);
2332:
2333: v_prorated_earnings := v_prorated_earnings +
2334: Prorate_Earnings (
2335: p_bg_id => p_bus_grp_id,
2337: p_range_start_date => v_range_start,
2338: p_range_end_date => v_range_end,
2339: p_act_hrs_worked => p_actual_hours_worked);
2340:
2341: hr_utility.set_location('calculate_period_earnings', 137);
2342:
2343: ELSE
2344: -- Do proration for this ASG range by EEV !
2345:
2342:
2343: ELSE
2344: -- Do proration for this ASG range by EEV !
2345:
2346: hr_utility.trace('EEVMPE True');
2347: hr_utility.trace('Do proration for this ASG range by EEV');
2348: hr_utility.set_location('calculate_period_earnings', 139);
2349:
2350: hr_utility.trace('Calling Prorate_EEV');
2343: ELSE
2344: -- Do proration for this ASG range by EEV !
2345:
2346: hr_utility.trace('EEVMPE True');
2347: hr_utility.trace('Do proration for this ASG range by EEV');
2348: hr_utility.set_location('calculate_period_earnings', 139);
2349:
2350: hr_utility.trace('Calling Prorate_EEV');
2351:
2344: -- Do proration for this ASG range by EEV !
2345:
2346: hr_utility.trace('EEVMPE True');
2347: hr_utility.trace('Do proration for this ASG range by EEV');
2348: hr_utility.set_location('calculate_period_earnings', 139);
2349:
2350: hr_utility.trace('Calling Prorate_EEV');
2351:
2352: v_prorated_earnings := v_prorated_earnings +
2346: hr_utility.trace('EEVMPE True');
2347: hr_utility.trace('Do proration for this ASG range by EEV');
2348: hr_utility.set_location('calculate_period_earnings', 139);
2349:
2350: hr_utility.trace('Calling Prorate_EEV');
2351:
2352: v_prorated_earnings := v_prorated_earnings +
2353: Prorate_EEV (
2354: p_bus_group_id => p_bus_grp_id,
2359: p_range_end_date => v_range_end,
2360: p_actual_hrs_worked => p_actual_hours_worked,
2361: p_element_entry_id => p_ele_entry_id,
2362: p_inpval_id => v_inpval_id);
2363: hr_utility.set_location('calculate_period_earnings', 140);
2364:
2365: END IF; -- EEV info changes
2366:
2367: EXCEPTION WHEN NO_DATA_FOUND THEN
2368: NULL;
2369:
2370: END; /* Latest Screen Entry Value */
2371:
2372: hr_utility.trace(' BOTH ASG - SELECT ASG_MULTI_WITHIN');
2373: hr_utility.set_location('calculate_period_earnings', 141);
2374:
2375: OPEN get_asst_chgs; -- SELECT ( ASG_MULTI_WITHIN)
2376: LOOP
2369:
2370: END; /* Latest Screen Entry Value */
2371:
2372: hr_utility.trace(' BOTH ASG - SELECT ASG_MULTI_WITHIN');
2373: hr_utility.set_location('calculate_period_earnings', 141);
2374:
2375: OPEN get_asst_chgs; -- SELECT ( ASG_MULTI_WITHIN)
2376: LOOP
2377:
2383: v_work_schedule;
2384: EXIT WHEN get_asst_chgs%NOTFOUND;
2385:
2386: --EEV_BEFORE_RANGE_END
2387: hr_utility.trace('BOTH ASG MULTI select app. EEVMPE again after range det.');
2388: hr_utility.set_location('calculate_period_earnings', 145);
2389:
2390: SELECT COUNT(EEV.element_entry_value_id)
2391: INTO l_eev_info_changes
2384: EXIT WHEN get_asst_chgs%NOTFOUND;
2385:
2386: --EEV_BEFORE_RANGE_END
2387: hr_utility.trace('BOTH ASG MULTI select app. EEVMPE again after range det.');
2388: hr_utility.set_location('calculate_period_earnings', 145);
2389:
2390: SELECT COUNT(EEV.element_entry_value_id)
2391: INTO l_eev_info_changes
2392: FROM pay_element_entry_values_f EEV
2399: IF l_eev_info_changes = 0 THEN /* IF l_eev_info_changes = 0 */
2400:
2401: -- EEV_FOR_CURR_RANGE_END
2402:
2403: hr_utility.trace('BOTH ASG - EEV false');
2404: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
2405: INTO v_earnings_entry
2406: FROM pay_element_entry_values_f EEV
2407: WHERE EEV.element_entry_id = p_ele_entry_id
2407: WHERE EEV.element_entry_id = p_ele_entry_id
2408: AND EEV.input_value_id = v_inpval_id
2409: AND v_range_end BETWEEN EEV.effective_start_date
2410: AND EEV.effective_end_date;
2411: hr_utility.set_location('calculate_period_earnings', 150);
2412: v_curr_hrly_rate := Convert_Period_Type(p_bus_grp_id
2413: ,p_asst_id
2414: ,p_payroll_id
2415: ,p_ele_entry_id
2438: p_range_start_date => v_range_start,
2439: p_range_end_date => v_range_end,
2440: p_act_hrs_worked => p_actual_hours_worked);
2441:
2442: hr_utility.set_location('calculate_period_earnings', 155);
2443: ELSE
2444: hr_utility.trace('BOTH ASG - EEV true');
2445: v_prorated_earnings := v_prorated_earnings +
2446: Prorate_EEV (
2440: p_act_hrs_worked => p_actual_hours_worked);
2441:
2442: hr_utility.set_location('calculate_period_earnings', 155);
2443: ELSE
2444: hr_utility.trace('BOTH ASG - EEV true');
2445: v_prorated_earnings := v_prorated_earnings +
2446: Prorate_EEV (
2447: p_bus_group_id => p_bus_grp_id,
2448: p_pay_id => p_payroll_id,
2462:
2463:
2464: BEGIN /* SPAN_RECORD */
2465:
2466: hr_utility.trace('BOTH ASG SELECT END_SPAN_RECORD');
2467: hr_utility.set_location('calculate_period_earnings', 160);
2468:
2469: SELECT ASG.effective_start_date,
2470: LEAST(ASG.effective_end_date, p_period_end),
2463:
2464: BEGIN /* SPAN_RECORD */
2465:
2466: hr_utility.trace('BOTH ASG SELECT END_SPAN_RECORD');
2467: hr_utility.set_location('calculate_period_earnings', 160);
2468:
2469: SELECT ASG.effective_start_date,
2470: LEAST(ASG.effective_end_date, p_period_end),
2471: NVL(ASG.normal_hours, 0),
2494: AND HRL.lookup_type(+) = 'FREQUENCY';
2495:
2496:
2497:
2498: hr_utility.trace('SELECT EEVMPE');
2499:
2500: SELECT COUNT(EEV.element_entry_value_id)
2501: INTO l_eev_info_changes
2502: FROM pay_element_entry_values_f EEV
2507: AND EEV.effective_end_date < v_range_end;
2508:
2509: IF l_eev_info_changes = 0 THEN
2510:
2511: hr_utility.trace('BOTH ASG SPAN - SELECT EEV_FOR_CURR_RANGE_END');
2512: hr_utility.set_location('calculate_period_earnings', 165);
2513:
2514: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
2515: INTO v_earnings_entry
2508:
2509: IF l_eev_info_changes = 0 THEN
2510:
2511: hr_utility.trace('BOTH ASG SPAN - SELECT EEV_FOR_CURR_RANGE_END');
2512: hr_utility.set_location('calculate_period_earnings', 165);
2513:
2514: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
2515: INTO v_earnings_entry
2516: FROM pay_element_entry_values_f EEV
2548: p_range_start_date => v_range_start,
2549: p_range_end_date => v_range_end,
2550: p_act_hrs_worked => p_actual_hours_worked);
2551:
2552: hr_utility.set_location('calculate_period_earnings', 170);
2553: ELSE /* EEV succ */
2554:
2555: hr_utility.trace('BOTH ASG END_SPAN - EEV true');
2556: v_prorated_earnings := v_prorated_earnings +
2551:
2552: hr_utility.set_location('calculate_period_earnings', 170);
2553: ELSE /* EEV succ */
2554:
2555: hr_utility.trace('BOTH ASG END_SPAN - EEV true');
2556: v_prorated_earnings := v_prorated_earnings +
2557: Prorate_EEV (
2558: p_bus_group_id => p_bus_grp_id,
2559: p_pay_id => p_payroll_id,
2563: p_range_end_date => v_range_end,
2564: p_actual_hrs_worked => p_actual_hours_worked,
2565: p_element_entry_id => p_ele_entry_id,
2566: p_inpval_id => v_inpval_id);
2567: hr_utility.set_location('calculate_period_earnings', 175);
2568: END IF;
2569:
2570:
2571: p_vac_pay := vacation_pay( p_vac_hours => p_vac_hours_worked,
2571: p_vac_pay := vacation_pay( p_vac_hours => p_vac_hours_worked,
2572: p_asg_id => p_asst_id,
2573: p_eff_date => p_period_end,
2574: p_curr_rate => p_ass_hrly_figure);
2575: hr_utility.set_location('calculate_period_earnings', 180);
2576:
2577: p_sick_pay := sick_pay( p_sick_hours => p_sick_hours_worked,
2578: p_asg_id => p_asst_id,
2579: p_eff_date => p_period_end,
2577: p_sick_pay := sick_pay( p_sick_hours => p_sick_hours_worked,
2578: p_asg_id => p_asst_id,
2579: p_eff_date => p_period_end,
2580: p_curr_rate => p_ass_hrly_figure);
2581: hr_utility.set_location('calculate_period_earnings', 185);
2582:
2583: p_actual_hours_worked := ROUND(p_actual_hours_worked, 3);
2584: RETURN v_prorated_earnings;
2585:
2709:
2710:
2711: BEGIN
2712:
2713: hr_utility.trace(' Entered get_hourly_rate ');
2714: --hr_utility.trace_on(null,'wrkschd');
2715:
2716:
2717: hr_utility.trace('assignment_action_id=' || p_assignment_action_id);
2710:
2711: BEGIN
2712:
2713: hr_utility.trace(' Entered get_hourly_rate ');
2714: --hr_utility.trace_on(null,'wrkschd');
2715:
2716:
2717: hr_utility.trace('assignment_action_id=' || p_assignment_action_id);
2718: hr_utility.trace('assignment_id=' || p_assignment_id);
2713: hr_utility.trace(' Entered get_hourly_rate ');
2714: --hr_utility.trace_on(null,'wrkschd');
2715:
2716:
2717: hr_utility.trace('assignment_action_id=' || p_assignment_action_id);
2718: hr_utility.trace('assignment_id=' || p_assignment_id);
2719: hr_utility.trace('business_group_id=' || p_bg);
2720: hr_utility.trace('element_entry_id=' || p_element_entry_id);
2721: hr_utility.trace('p_date_earned '||p_date_earned);
2714: --hr_utility.trace_on(null,'wrkschd');
2715:
2716:
2717: hr_utility.trace('assignment_action_id=' || p_assignment_action_id);
2718: hr_utility.trace('assignment_id=' || p_assignment_id);
2719: hr_utility.trace('business_group_id=' || p_bg);
2720: hr_utility.trace('element_entry_id=' || p_element_entry_id);
2721: hr_utility.trace('p_date_earned '||p_date_earned);
2722: hr_utility.trace('p_payroll_id: '||p_payroll_id);
2715:
2716:
2717: hr_utility.trace('assignment_action_id=' || p_assignment_action_id);
2718: hr_utility.trace('assignment_id=' || p_assignment_id);
2719: hr_utility.trace('business_group_id=' || p_bg);
2720: hr_utility.trace('element_entry_id=' || p_element_entry_id);
2721: hr_utility.trace('p_date_earned '||p_date_earned);
2722: hr_utility.trace('p_payroll_id: '||p_payroll_id);
2723:
2716:
2717: hr_utility.trace('assignment_action_id=' || p_assignment_action_id);
2718: hr_utility.trace('assignment_id=' || p_assignment_id);
2719: hr_utility.trace('business_group_id=' || p_bg);
2720: hr_utility.trace('element_entry_id=' || p_element_entry_id);
2721: hr_utility.trace('p_date_earned '||p_date_earned);
2722: hr_utility.trace('p_payroll_id: '||p_payroll_id);
2723:
2724: l_hourly_rate := 0;
2717: hr_utility.trace('assignment_action_id=' || p_assignment_action_id);
2718: hr_utility.trace('assignment_id=' || p_assignment_id);
2719: hr_utility.trace('business_group_id=' || p_bg);
2720: hr_utility.trace('element_entry_id=' || p_element_entry_id);
2721: hr_utility.trace('p_date_earned '||p_date_earned);
2722: hr_utility.trace('p_payroll_id: '||p_payroll_id);
2723:
2724: l_hourly_rate := 0;
2725:
2718: hr_utility.trace('assignment_id=' || p_assignment_id);
2719: hr_utility.trace('business_group_id=' || p_bg);
2720: hr_utility.trace('element_entry_id=' || p_element_entry_id);
2721: hr_utility.trace('p_date_earned '||p_date_earned);
2722: hr_utility.trace('p_payroll_id: '||p_payroll_id);
2723:
2724: l_hourly_rate := 0;
2725:
2726: OPEN get_period_dates(p_date_earned,p_payroll_id);
2727: FETCH get_period_dates INTO l_period_start_date,l_period_end_date;
2728: CLOSE get_period_dates;
2729:
2730:
2731: hr_utility.trace('l_period_start_date =' || l_period_start_date);
2732: hr_utility.trace('l_period_end_date =' || l_period_end_date);
2733:
2734: OPEN get_salary_basis(p_date_earned, p_assignment_id);
2735: FETCH get_salary_basis INTO l_salary_basis, l_input_value_id;
2728: CLOSE get_period_dates;
2729:
2730:
2731: hr_utility.trace('l_period_start_date =' || l_period_start_date);
2732: hr_utility.trace('l_period_end_date =' || l_period_end_date);
2733:
2734: OPEN get_salary_basis(p_date_earned, p_assignment_id);
2735: FETCH get_salary_basis INTO l_salary_basis, l_input_value_id;
2736: CLOSE get_salary_basis;
2734: OPEN get_salary_basis(p_date_earned, p_assignment_id);
2735: FETCH get_salary_basis INTO l_salary_basis, l_input_value_id;
2736: CLOSE get_salary_basis;
2737:
2738: hr_utility.trace('l_salary_basis =' || l_salary_basis);
2739: hr_utility.trace('l_input_value_id =' || l_input_value_id);
2740:
2741: OPEN get_salary(p_date_earned, p_assignment_id,l_input_value_id);
2742: FETCH get_salary INTO l_asg_salary;
2735: FETCH get_salary_basis INTO l_salary_basis, l_input_value_id;
2736: CLOSE get_salary_basis;
2737:
2738: hr_utility.trace('l_salary_basis =' || l_salary_basis);
2739: hr_utility.trace('l_input_value_id =' || l_input_value_id);
2740:
2741: OPEN get_salary(p_date_earned, p_assignment_id,l_input_value_id);
2742: FETCH get_salary INTO l_asg_salary;
2743: CLOSE get_salary;
2747: OPEN get_termination_date(p_date_earned, p_assignment_id);
2748: FETCH get_termination_date INTO l_termination_date;
2749: CLOSE get_termination_date;
2750:
2751: hr_utility.trace('l_termination_date =' || l_termination_date);
2752:
2753: OPEN get_salary(l_termination_date,
2754: p_assignment_id,l_input_value_id);
2755: FETCH get_salary INTO l_asg_salary;
2756: CLOSE get_salary;
2757: l_date_used := nvl(l_termination_date,p_date_earned);
2758: END IF;
2759:
2760: hr_utility.trace('l_asg_salary =' || l_asg_salary);
2761:
2762: l_hourly_rate := Convert_Period_Type(p_bg
2763: ,p_assignment_id
2764: ,p_payroll_id
2804: v_curr_date := NULL;
2805: v_curr_day :=NULL;
2806:
2807: -- Check for valid range
2808: hr_utility.trace('Entered standard_hours_worked');
2809:
2810: IF p_range_start > p_range_end THEN
2811: hr_utility.trace('p_range_start greater than p_range_end');
2812: RETURN v_total_hours;
2807: -- Check for valid range
2808: hr_utility.trace('Entered standard_hours_worked');
2809:
2810: IF p_range_start > p_range_end THEN
2811: hr_utility.trace('p_range_start greater than p_range_end');
2812: RETURN v_total_hours;
2813: -- hr_utility.set_message(801,'PAY_xxxx_INVALID_DATE_RANGE');
2814: -- hr_utility.raise_error;
2815: END IF;
2809:
2810: IF p_range_start > p_range_end THEN
2811: hr_utility.trace('p_range_start greater than p_range_end');
2812: RETURN v_total_hours;
2813: -- hr_utility.set_message(801,'PAY_xxxx_INVALID_DATE_RANGE');
2814: -- hr_utility.raise_error;
2815: END IF;
2816: --
2817:
2810: IF p_range_start > p_range_end THEN
2811: hr_utility.trace('p_range_start greater than p_range_end');
2812: RETURN v_total_hours;
2813: -- hr_utility.set_message(801,'PAY_xxxx_INVALID_DATE_RANGE');
2814: -- hr_utility.raise_error;
2815: END IF;
2816: --
2817:
2818: IF UPPER(p_std_freq) = 'WEEK' THEN
2815: END IF;
2816: --
2817:
2818: IF UPPER(p_std_freq) = 'WEEK' THEN
2819: hr_utility.trace('p_std_freq = WEEK ');
2820:
2821: v_wrkday_hours := p_std_hrs / c_wkdays_per_week;
2822:
2823: hr_utility.trace('p_std_hrs ='||to_number(p_std_hrs));
2819: hr_utility.trace('p_std_freq = WEEK ');
2820:
2821: v_wrkday_hours := p_std_hrs / c_wkdays_per_week;
2822:
2823: hr_utility.trace('p_std_hrs ='||to_number(p_std_hrs));
2824: hr_utility.trace('c_wkdays_per_week ='||to_number(c_wkdays_per_week));
2825: hr_utility.trace('v_wrkday_hours ='||to_number(v_wrkday_hours));
2826:
2827: ELSIF UPPER(p_std_freq) = 'MONTH' THEN
2820:
2821: v_wrkday_hours := p_std_hrs / c_wkdays_per_week;
2822:
2823: hr_utility.trace('p_std_hrs ='||to_number(p_std_hrs));
2824: hr_utility.trace('c_wkdays_per_week ='||to_number(c_wkdays_per_week));
2825: hr_utility.trace('v_wrkday_hours ='||to_number(v_wrkday_hours));
2826:
2827: ELSIF UPPER(p_std_freq) = 'MONTH' THEN
2828:
2821: v_wrkday_hours := p_std_hrs / c_wkdays_per_week;
2822:
2823: hr_utility.trace('p_std_hrs ='||to_number(p_std_hrs));
2824: hr_utility.trace('c_wkdays_per_week ='||to_number(c_wkdays_per_week));
2825: hr_utility.trace('v_wrkday_hours ='||to_number(v_wrkday_hours));
2826:
2827: ELSIF UPPER(p_std_freq) = 'MONTH' THEN
2828:
2829: hr_utility.trace('p_std_freq = MONTH ');
2825: hr_utility.trace('v_wrkday_hours ='||to_number(v_wrkday_hours));
2826:
2827: ELSIF UPPER(p_std_freq) = 'MONTH' THEN
2828:
2829: hr_utility.trace('p_std_freq = MONTH ');
2830:
2831: v_wrkday_hours := p_std_hrs / c_wkdays_per_month;
2832:
2833:
2830:
2831: v_wrkday_hours := p_std_hrs / c_wkdays_per_month;
2832:
2833:
2834: hr_utility.trace('p_std_hrs ='||to_number(p_std_hrs));
2835: hr_utility.trace('c_wkdays_per_month ='||to_number(c_wkdays_per_month));
2836: hr_utility.trace('v_wrkday_hours ='||to_number(v_wrkday_hours));
2837:
2838: ELSIF UPPER(p_std_freq) = 'YEAR' THEN
2831: v_wrkday_hours := p_std_hrs / c_wkdays_per_month;
2832:
2833:
2834: hr_utility.trace('p_std_hrs ='||to_number(p_std_hrs));
2835: hr_utility.trace('c_wkdays_per_month ='||to_number(c_wkdays_per_month));
2836: hr_utility.trace('v_wrkday_hours ='||to_number(v_wrkday_hours));
2837:
2838: ELSIF UPPER(p_std_freq) = 'YEAR' THEN
2839:
2832:
2833:
2834: hr_utility.trace('p_std_hrs ='||to_number(p_std_hrs));
2835: hr_utility.trace('c_wkdays_per_month ='||to_number(c_wkdays_per_month));
2836: hr_utility.trace('v_wrkday_hours ='||to_number(v_wrkday_hours));
2837:
2838: ELSIF UPPER(p_std_freq) = 'YEAR' THEN
2839:
2840: hr_utility.trace('p_std_freq = YEAR ');
2836: hr_utility.trace('v_wrkday_hours ='||to_number(v_wrkday_hours));
2837:
2838: ELSIF UPPER(p_std_freq) = 'YEAR' THEN
2839:
2840: hr_utility.trace('p_std_freq = YEAR ');
2841: v_wrkday_hours := p_std_hrs / c_wkdays_per_year;
2842:
2843: hr_utility.trace('p_std_hrs ='||to_number(p_std_hrs));
2844: hr_utility.trace('c_wkdays_per_year ='||to_number(c_wkdays_per_year));
2839:
2840: hr_utility.trace('p_std_freq = YEAR ');
2841: v_wrkday_hours := p_std_hrs / c_wkdays_per_year;
2842:
2843: hr_utility.trace('p_std_hrs ='||to_number(p_std_hrs));
2844: hr_utility.trace('c_wkdays_per_year ='||to_number(c_wkdays_per_year));
2845: hr_utility.trace('v_wrkday_hours ='||to_number(v_wrkday_hours));
2846:
2847: ELSE
2840: hr_utility.trace('p_std_freq = YEAR ');
2841: v_wrkday_hours := p_std_hrs / c_wkdays_per_year;
2842:
2843: hr_utility.trace('p_std_hrs ='||to_number(p_std_hrs));
2844: hr_utility.trace('c_wkdays_per_year ='||to_number(c_wkdays_per_year));
2845: hr_utility.trace('v_wrkday_hours ='||to_number(v_wrkday_hours));
2846:
2847: ELSE
2848: hr_utility.trace('p_std_freq in ELSE ');
2841: v_wrkday_hours := p_std_hrs / c_wkdays_per_year;
2842:
2843: hr_utility.trace('p_std_hrs ='||to_number(p_std_hrs));
2844: hr_utility.trace('c_wkdays_per_year ='||to_number(c_wkdays_per_year));
2845: hr_utility.trace('v_wrkday_hours ='||to_number(v_wrkday_hours));
2846:
2847: ELSE
2848: hr_utility.trace('p_std_freq in ELSE ');
2849: v_wrkday_hours := p_std_hrs;
2844: hr_utility.trace('c_wkdays_per_year ='||to_number(c_wkdays_per_year));
2845: hr_utility.trace('v_wrkday_hours ='||to_number(v_wrkday_hours));
2846:
2847: ELSE
2848: hr_utility.trace('p_std_freq in ELSE ');
2849: v_wrkday_hours := p_std_hrs;
2850: END IF;
2851:
2852: v_curr_date := p_range_start;
2850: END IF;
2851:
2852: v_curr_date := p_range_start;
2853:
2854: hr_utility.trace('v_curr_date is range start'||to_char(v_curr_date));
2855:
2856:
2857: LOOP
2858:
2863:
2864:
2865: v_total_hours := nvl(v_total_hours,0) + v_wrkday_hours;
2866:
2867: hr_utility.trace(' v_day_no = '||to_char(v_day_no));
2868: hr_utility.trace(' v_total_hours = '||to_char(v_total_hours));
2869: END IF;
2870:
2871: v_curr_date := v_curr_date + 1;
2864:
2865: v_total_hours := nvl(v_total_hours,0) + v_wrkday_hours;
2866:
2867: hr_utility.trace(' v_day_no = '||to_char(v_day_no));
2868: hr_utility.trace(' v_total_hours = '||to_char(v_total_hours));
2869: END IF;
2870:
2871: v_curr_date := v_curr_date + 1;
2872: EXIT WHEN v_curr_date > p_range_end;
2870:
2871: v_curr_date := v_curr_date + 1;
2872: EXIT WHEN v_curr_date > p_range_end;
2873: END LOOP;
2874: hr_utility.trace(' Final v_total_hours = '||to_char(v_total_hours));
2875: hr_utility.trace(' Leaving standard_hours_worked' );
2876: --
2877: RETURN v_total_hours;
2878: --
2871: v_curr_date := v_curr_date + 1;
2872: EXIT WHEN v_curr_date > p_range_end;
2873: END LOOP;
2874: hr_utility.trace(' Final v_total_hours = '||to_char(v_total_hours));
2875: hr_utility.trace(' Leaving standard_hours_worked' );
2876: --
2877: RETURN v_total_hours;
2878: --
2879: END standard_hours_worked;
2997: --
2998: e_bad_time_format EXCEPTION;
2999: --
3000: BEGIN
3001: hr_utility.set_location('Entering '||g_package||'.calc_sch_based_dur',10);
3002: p_duration := 0;
3003: l_time_start := p_time_start;
3004: l_time_end := p_time_end;
3005: --
3022: END IF;
3023: l_start_date := TO_DATE(TO_CHAR(p_date_start,'DD-MM-YYYY')||' '||l_time_start,'DD-MM-YYYY HH24:MI');
3024: l_end_date := TO_DATE(TO_CHAR(p_date_end,'DD-MM-YYYY')||' '||l_time_end,'DD-MM-YYYY HH24:MI');
3025:
3026: hr_utility.trace('p_assignment_id ' ||p_assignment_id);
3027: hr_utility.trace('l_start_date ' ||l_start_date);
3028: hr_utility.trace('l_end_date ' ||l_end_date);
3029: hr_utility.trace('p_time_start ' ||p_time_start);
3030: hr_utility.trace('p_time_end ' ||p_time_end);
3023: l_start_date := TO_DATE(TO_CHAR(p_date_start,'DD-MM-YYYY')||' '||l_time_start,'DD-MM-YYYY HH24:MI');
3024: l_end_date := TO_DATE(TO_CHAR(p_date_end,'DD-MM-YYYY')||' '||l_time_end,'DD-MM-YYYY HH24:MI');
3025:
3026: hr_utility.trace('p_assignment_id ' ||p_assignment_id);
3027: hr_utility.trace('l_start_date ' ||l_start_date);
3028: hr_utility.trace('l_end_date ' ||l_end_date);
3029: hr_utility.trace('p_time_start ' ||p_time_start);
3030: hr_utility.trace('p_time_end ' ||p_time_end);
3031: hr_utility.trace('p_days_or_hours ' ||p_days_or_hours);
3024: l_end_date := TO_DATE(TO_CHAR(p_date_end,'DD-MM-YYYY')||' '||l_time_end,'DD-MM-YYYY HH24:MI');
3025:
3026: hr_utility.trace('p_assignment_id ' ||p_assignment_id);
3027: hr_utility.trace('l_start_date ' ||l_start_date);
3028: hr_utility.trace('l_end_date ' ||l_end_date);
3029: hr_utility.trace('p_time_start ' ||p_time_start);
3030: hr_utility.trace('p_time_end ' ||p_time_end);
3031: hr_utility.trace('p_days_or_hours ' ||p_days_or_hours);
3032:
3025:
3026: hr_utility.trace('p_assignment_id ' ||p_assignment_id);
3027: hr_utility.trace('l_start_date ' ||l_start_date);
3028: hr_utility.trace('l_end_date ' ||l_end_date);
3029: hr_utility.trace('p_time_start ' ||p_time_start);
3030: hr_utility.trace('p_time_end ' ||p_time_end);
3031: hr_utility.trace('p_days_or_hours ' ||p_days_or_hours);
3032:
3033: --
3026: hr_utility.trace('p_assignment_id ' ||p_assignment_id);
3027: hr_utility.trace('l_start_date ' ||l_start_date);
3028: hr_utility.trace('l_end_date ' ||l_end_date);
3029: hr_utility.trace('p_time_start ' ||p_time_start);
3030: hr_utility.trace('p_time_end ' ||p_time_end);
3031: hr_utility.trace('p_days_or_hours ' ||p_days_or_hours);
3032:
3033: --
3034: -- Fetch the work schedule
3027: hr_utility.trace('l_start_date ' ||l_start_date);
3028: hr_utility.trace('l_end_date ' ||l_end_date);
3029: hr_utility.trace('p_time_start ' ||p_time_start);
3030: hr_utility.trace('p_time_end ' ||p_time_end);
3031: hr_utility.trace('p_days_or_hours ' ||p_days_or_hours);
3032:
3033: --
3034: -- Fetch the work schedule
3035: --
3046: , x_return_message => l_return_message
3047: );
3048: --
3049:
3050: hr_utility.trace('l_return_status ' ||l_return_status);
3051: IF l_return_status = '0' THEN
3052: --
3053: -- Calculate duration
3054: --
3052: --
3053: -- Calculate duration
3054: --
3055: l_idx := l_schedule.first;
3056: hr_utility.trace('l_idx ' || l_idx);
3057: hr_utility.trace('Schedule Counts ' ||l_schedule.count);
3058: --
3059: IF p_days_or_hours = 'D' THEN
3060: --
3053: -- Calculate duration
3054: --
3055: l_idx := l_schedule.first;
3056: hr_utility.trace('l_idx ' || l_idx);
3057: hr_utility.trace('Schedule Counts ' ||l_schedule.count);
3058: --
3059: IF p_days_or_hours = 'D' THEN
3060: --
3061: l_first_band := TRUE;
3086: l_day_start_time := '00:00';
3087: l_day_end_time := '23:59';
3088: WHILE l_idx IS NOT NULL
3089: LOOP
3090: hr_utility.trace('l_schedule(l_idx).FREE_BUSY_TYPE ' || l_schedule(l_idx).FREE_BUSY_TYPE );
3091: hr_utility.trace('l_schedule(l_idx).END_DATE_TIME ' || l_schedule(l_idx).END_DATE_TIME );
3092: hr_utility.trace('l_schedule(l_idx).START_DATE_TIME ' || l_schedule(l_idx).START_DATE_TIME );
3093:
3094: IF l_schedule(l_idx).FREE_BUSY_TYPE IS NOT NULL THEN
3087: l_day_end_time := '23:59';
3088: WHILE l_idx IS NOT NULL
3089: LOOP
3090: hr_utility.trace('l_schedule(l_idx).FREE_BUSY_TYPE ' || l_schedule(l_idx).FREE_BUSY_TYPE );
3091: hr_utility.trace('l_schedule(l_idx).END_DATE_TIME ' || l_schedule(l_idx).END_DATE_TIME );
3092: hr_utility.trace('l_schedule(l_idx).START_DATE_TIME ' || l_schedule(l_idx).START_DATE_TIME );
3093:
3094: IF l_schedule(l_idx).FREE_BUSY_TYPE IS NOT NULL THEN
3095: hr_utility.trace('l_schedule(l_idx).FREE_BUSY_TYPE is not null ' || l_schedule(l_idx).FREE_BUSY_TYPE );
3088: WHILE l_idx IS NOT NULL
3089: LOOP
3090: hr_utility.trace('l_schedule(l_idx).FREE_BUSY_TYPE ' || l_schedule(l_idx).FREE_BUSY_TYPE );
3091: hr_utility.trace('l_schedule(l_idx).END_DATE_TIME ' || l_schedule(l_idx).END_DATE_TIME );
3092: hr_utility.trace('l_schedule(l_idx).START_DATE_TIME ' || l_schedule(l_idx).START_DATE_TIME );
3093:
3094: IF l_schedule(l_idx).FREE_BUSY_TYPE IS NOT NULL THEN
3095: hr_utility.trace('l_schedule(l_idx).FREE_BUSY_TYPE is not null ' || l_schedule(l_idx).FREE_BUSY_TYPE );
3096: IF l_schedule(l_idx).FREE_BUSY_TYPE = 'FREE' THEN
3091: hr_utility.trace('l_schedule(l_idx).END_DATE_TIME ' || l_schedule(l_idx).END_DATE_TIME );
3092: hr_utility.trace('l_schedule(l_idx).START_DATE_TIME ' || l_schedule(l_idx).START_DATE_TIME );
3093:
3094: IF l_schedule(l_idx).FREE_BUSY_TYPE IS NOT NULL THEN
3095: hr_utility.trace('l_schedule(l_idx).FREE_BUSY_TYPE is not null ' || l_schedule(l_idx).FREE_BUSY_TYPE );
3096: IF l_schedule(l_idx).FREE_BUSY_TYPE = 'FREE' THEN
3097: hr_utility.trace('l_schedule(l_idx).FREE_BUSY_TYPE is FREE ' || l_schedule(l_idx).FREE_BUSY_TYPE );
3098: hr_utility.trace('l_schedule(l_idx).END_DATE_TIME ' || l_schedule(l_idx).END_DATE_TIME );
3099: hr_utility.trace('l_schedule(l_idx).START_DATE_TIME ' || l_schedule(l_idx).START_DATE_TIME );
3093:
3094: IF l_schedule(l_idx).FREE_BUSY_TYPE IS NOT NULL THEN
3095: hr_utility.trace('l_schedule(l_idx).FREE_BUSY_TYPE is not null ' || l_schedule(l_idx).FREE_BUSY_TYPE );
3096: IF l_schedule(l_idx).FREE_BUSY_TYPE = 'FREE' THEN
3097: hr_utility.trace('l_schedule(l_idx).FREE_BUSY_TYPE is FREE ' || l_schedule(l_idx).FREE_BUSY_TYPE );
3098: hr_utility.trace('l_schedule(l_idx).END_DATE_TIME ' || l_schedule(l_idx).END_DATE_TIME );
3099: hr_utility.trace('l_schedule(l_idx).START_DATE_TIME ' || l_schedule(l_idx).START_DATE_TIME );
3100: IF l_schedule(l_idx).END_DATE_TIME < l_schedule(l_idx).START_DATE_TIME THEN
3101: -- Skip this invalid slot which ends before it starts
3094: IF l_schedule(l_idx).FREE_BUSY_TYPE IS NOT NULL THEN
3095: hr_utility.trace('l_schedule(l_idx).FREE_BUSY_TYPE is not null ' || l_schedule(l_idx).FREE_BUSY_TYPE );
3096: IF l_schedule(l_idx).FREE_BUSY_TYPE = 'FREE' THEN
3097: hr_utility.trace('l_schedule(l_idx).FREE_BUSY_TYPE is FREE ' || l_schedule(l_idx).FREE_BUSY_TYPE );
3098: hr_utility.trace('l_schedule(l_idx).END_DATE_TIME ' || l_schedule(l_idx).END_DATE_TIME );
3099: hr_utility.trace('l_schedule(l_idx).START_DATE_TIME ' || l_schedule(l_idx).START_DATE_TIME );
3100: IF l_schedule(l_idx).END_DATE_TIME < l_schedule(l_idx).START_DATE_TIME THEN
3101: -- Skip this invalid slot which ends before it starts
3102: NULL;
3095: hr_utility.trace('l_schedule(l_idx).FREE_BUSY_TYPE is not null ' || l_schedule(l_idx).FREE_BUSY_TYPE );
3096: IF l_schedule(l_idx).FREE_BUSY_TYPE = 'FREE' THEN
3097: hr_utility.trace('l_schedule(l_idx).FREE_BUSY_TYPE is FREE ' || l_schedule(l_idx).FREE_BUSY_TYPE );
3098: hr_utility.trace('l_schedule(l_idx).END_DATE_TIME ' || l_schedule(l_idx).END_DATE_TIME );
3099: hr_utility.trace('l_schedule(l_idx).START_DATE_TIME ' || l_schedule(l_idx).START_DATE_TIME );
3100: IF l_schedule(l_idx).END_DATE_TIME < l_schedule(l_idx).START_DATE_TIME THEN
3101: -- Skip this invalid slot which ends before it starts
3102: NULL;
3103: ELSE
3105: -- Start and End on different days
3106: --
3107: -- Get first day hours
3108: l_start_time := TO_CHAR(l_schedule(l_idx).START_DATE_TIME,'HH24:MI');
3109: hr_utility.trace('l_start_time ' || l_start_time);
3110:
3111: SELECT p_duration + (((SUBSTR(l_day_end_time,1,2)*60 + SUBSTR(l_day_end_time,4,2)) -
3112: (SUBSTR(l_start_time,1,2)*60 + SUBSTR(l_start_time,4,2)))/60)
3113: INTO p_duration
3111: SELECT p_duration + (((SUBSTR(l_day_end_time,1,2)*60 + SUBSTR(l_day_end_time,4,2)) -
3112: (SUBSTR(l_start_time,1,2)*60 + SUBSTR(l_start_time,4,2)))/60)
3113: INTO p_duration
3114: FROM DUAL;
3115: -- hr_utility.trace('p_start_duration ' || p_start_duration);
3116: hr_utility.trace('Start p_duration ' || p_duration);
3117:
3118: --
3119: -- Get last day hours
3112: (SUBSTR(l_start_time,1,2)*60 + SUBSTR(l_start_time,4,2)))/60)
3113: INTO p_duration
3114: FROM DUAL;
3115: -- hr_utility.trace('p_start_duration ' || p_start_duration);
3116: hr_utility.trace('Start p_duration ' || p_duration);
3117:
3118: --
3119: -- Get last day hours
3120: l_end_time := TO_CHAR(l_schedule(l_idx).END_DATE_TIME,'HH24:MI');
3117:
3118: --
3119: -- Get last day hours
3120: l_end_time := TO_CHAR(l_schedule(l_idx).END_DATE_TIME,'HH24:MI');
3121: hr_utility.trace('l_end_time ' || l_end_time);
3122: SELECT p_duration + (((SUBSTR(l_end_time,1,2)*60 + SUBSTR(l_end_time,4,2)) -
3123: (SUBSTR(l_day_start_time,1,2)*60 + SUBSTR(l_day_start_time,4,2)) + 1)/60)
3124: INTO p_duration
3125: FROM DUAL;
3122: SELECT p_duration + (((SUBSTR(l_end_time,1,2)*60 + SUBSTR(l_end_time,4,2)) -
3123: (SUBSTR(l_day_start_time,1,2)*60 + SUBSTR(l_day_start_time,4,2)) + 1)/60)
3124: INTO p_duration
3125: FROM DUAL;
3126: --hr_utility.trace('p_end_duration ' || p_end_duration);
3127: hr_utility.trace('End p_duration ' || p_duration);
3128: --
3129: -- Get between full day hours
3130: SELECT p_duration + ((TRUNC(l_schedule(l_idx).END_DATE_TIME) - TRUNC(l_schedule(l_idx).START_DATE_TIME) - 1) * 24)
3123: (SUBSTR(l_day_start_time,1,2)*60 + SUBSTR(l_day_start_time,4,2)) + 1)/60)
3124: INTO p_duration
3125: FROM DUAL;
3126: --hr_utility.trace('p_end_duration ' || p_end_duration);
3127: hr_utility.trace('End p_duration ' || p_duration);
3128: --
3129: -- Get between full day hours
3130: SELECT p_duration + ((TRUNC(l_schedule(l_idx).END_DATE_TIME) - TRUNC(l_schedule(l_idx).START_DATE_TIME) - 1) * 24)
3131: INTO p_duration
3134: -- Start and End on same day
3135: l_start_time := TO_CHAR(l_schedule(l_idx).START_DATE_TIME,'HH24:MI');
3136: l_end_time := TO_CHAR(l_schedule(l_idx).END_DATE_TIME,'HH24:MI');
3137:
3138: hr_utility.trace('l_start_time ' || l_start_time);
3139: hr_utility.trace('l_end_time ' || l_end_time);
3140:
3141: SELECT p_duration + (((SUBSTR(l_end_time,1,2)*60 + SUBSTR(l_end_time,4,2)) -
3142: (SUBSTR(l_start_time,1,2)*60 + SUBSTR(l_start_time,4,2)))/60)
3135: l_start_time := TO_CHAR(l_schedule(l_idx).START_DATE_TIME,'HH24:MI');
3136: l_end_time := TO_CHAR(l_schedule(l_idx).END_DATE_TIME,'HH24:MI');
3137:
3138: hr_utility.trace('l_start_time ' || l_start_time);
3139: hr_utility.trace('l_end_time ' || l_end_time);
3140:
3141: SELECT p_duration + (((SUBSTR(l_end_time,1,2)*60 + SUBSTR(l_end_time,4,2)) -
3142: (SUBSTR(l_start_time,1,2)*60 + SUBSTR(l_start_time,4,2)))/60)
3143: INTO p_duration
3141: SELECT p_duration + (((SUBSTR(l_end_time,1,2)*60 + SUBSTR(l_end_time,4,2)) -
3142: (SUBSTR(l_start_time,1,2)*60 + SUBSTR(l_start_time,4,2)))/60)
3143: INTO p_duration
3144: FROM DUAL;
3145: hr_utility.trace('duration l_idx '||l_idx||' ' ||p_duration);
3146:
3147: END IF;
3148: END IF;
3149: END IF;
3149: END IF;
3150: END IF;
3151: l_idx := l_schedule(l_idx).NEXT_OBJECT_INDEX;
3152: END LOOP;
3153: hr_utility.trace('duration ' ||p_duration);
3154:
3155: p_duration := ROUND(p_duration,2);
3156: --
3157: END IF;
3156: --
3157: END IF;
3158: END IF;
3159: --
3160: hr_utility.set_location('Leaving '||g_package||'.calc_sch_based_dur',20);
3161: EXCEPTION
3162: --
3163: WHEN e_bad_time_format THEN
3164: hr_utility.set_location('Leaving '||g_package||'.calc_sch_based_dur',30);
3160: hr_utility.set_location('Leaving '||g_package||'.calc_sch_based_dur',20);
3161: EXCEPTION
3162: --
3163: WHEN e_bad_time_format THEN
3164: hr_utility.set_location('Leaving '||g_package||'.calc_sch_based_dur',30);
3165: hr_utility.set_location(SQLERRM,35);
3166: RAISE;
3167: --
3168: WHEN OTHERS THEN
3161: EXCEPTION
3162: --
3163: WHEN e_bad_time_format THEN
3164: hr_utility.set_location('Leaving '||g_package||'.calc_sch_based_dur',30);
3165: hr_utility.set_location(SQLERRM,35);
3166: RAISE;
3167: --
3168: WHEN OTHERS THEN
3169: hr_utility.set_location('Leaving '||g_package||'.calc_sch_based_dur',40);
3165: hr_utility.set_location(SQLERRM,35);
3166: RAISE;
3167: --
3168: WHEN OTHERS THEN
3169: hr_utility.set_location('Leaving '||g_package||'.calc_sch_based_dur',40);
3170: hr_utility.set_location(SQLERRM,45);
3171: RAISE;
3172: --
3173: END calc_sch_based_dur;
3166: RAISE;
3167: --
3168: WHEN OTHERS THEN
3169: hr_utility.set_location('Leaving '||g_package||'.calc_sch_based_dur',40);
3170: hr_utility.set_location(SQLERRM,45);
3171: RAISE;
3172: --
3173: END calc_sch_based_dur;
3174:
3210:
3211: BEGIN
3212: l_work_schedule_found := FALSE;
3213: l_total_hours := 0;
3214: -- hr_utility.trace_on(NULL, 'PAY_CALC_HOURS_WORKED');
3215: hr_utility.trace( 'Assignment Id '||assignment_id);
3216: hr_utility.trace( 'date_earned '||date_earned);
3217: hr_utility.trace( 'p_days_or_hours '||p_days_or_hours);
3218: hr_utility.trace( 'p_period_start_date '||p_period_start_date);
3211: BEGIN
3212: l_work_schedule_found := FALSE;
3213: l_total_hours := 0;
3214: -- hr_utility.trace_on(NULL, 'PAY_CALC_HOURS_WORKED');
3215: hr_utility.trace( 'Assignment Id '||assignment_id);
3216: hr_utility.trace( 'date_earned '||date_earned);
3217: hr_utility.trace( 'p_days_or_hours '||p_days_or_hours);
3218: hr_utility.trace( 'p_period_start_date '||p_period_start_date);
3219: hr_utility.trace( 'p_period_end_date '||p_period_end_date);
3212: l_work_schedule_found := FALSE;
3213: l_total_hours := 0;
3214: -- hr_utility.trace_on(NULL, 'PAY_CALC_HOURS_WORKED');
3215: hr_utility.trace( 'Assignment Id '||assignment_id);
3216: hr_utility.trace( 'date_earned '||date_earned);
3217: hr_utility.trace( 'p_days_or_hours '||p_days_or_hours);
3218: hr_utility.trace( 'p_period_start_date '||p_period_start_date);
3219: hr_utility.trace( 'p_period_end_date '||p_period_end_date);
3220: hr_utility.trace( 'p_legislation_code '||p_legislation_code);
3213: l_total_hours := 0;
3214: -- hr_utility.trace_on(NULL, 'PAY_CALC_HOURS_WORKED');
3215: hr_utility.trace( 'Assignment Id '||assignment_id);
3216: hr_utility.trace( 'date_earned '||date_earned);
3217: hr_utility.trace( 'p_days_or_hours '||p_days_or_hours);
3218: hr_utility.trace( 'p_period_start_date '||p_period_start_date);
3219: hr_utility.trace( 'p_period_end_date '||p_period_end_date);
3220: hr_utility.trace( 'p_legislation_code '||p_legislation_code);
3221:
3214: -- hr_utility.trace_on(NULL, 'PAY_CALC_HOURS_WORKED');
3215: hr_utility.trace( 'Assignment Id '||assignment_id);
3216: hr_utility.trace( 'date_earned '||date_earned);
3217: hr_utility.trace( 'p_days_or_hours '||p_days_or_hours);
3218: hr_utility.trace( 'p_period_start_date '||p_period_start_date);
3219: hr_utility.trace( 'p_period_end_date '||p_period_end_date);
3220: hr_utility.trace( 'p_legislation_code '||p_legislation_code);
3221:
3222: IF (p_legislation_code) IS NULL or (p_legislation_code ='') or
3215: hr_utility.trace( 'Assignment Id '||assignment_id);
3216: hr_utility.trace( 'date_earned '||date_earned);
3217: hr_utility.trace( 'p_days_or_hours '||p_days_or_hours);
3218: hr_utility.trace( 'p_period_start_date '||p_period_start_date);
3219: hr_utility.trace( 'p_period_end_date '||p_period_end_date);
3220: hr_utility.trace( 'p_legislation_code '||p_legislation_code);
3221:
3222: IF (p_legislation_code) IS NULL or (p_legislation_code ='') or
3223: (g_legislation_code IS NULL) THEN
3216: hr_utility.trace( 'date_earned '||date_earned);
3217: hr_utility.trace( 'p_days_or_hours '||p_days_or_hours);
3218: hr_utility.trace( 'p_period_start_date '||p_period_start_date);
3219: hr_utility.trace( 'p_period_end_date '||p_period_end_date);
3220: hr_utility.trace( 'p_legislation_code '||p_legislation_code);
3221:
3222: IF (p_legislation_code) IS NULL or (p_legislation_code ='') or
3223: (g_legislation_code IS NULL) THEN
3224: g_legislation_code := get_legislation_code(business_group_id);
3225: ELSE
3226: g_legislation_code := nvl(g_legislation_code,p_legislation_code);
3227: END IF;
3228:
3229: hr_utility.trace( 'Legislation code : g_legislation_code '||g_legislation_code);
3230:
3231: /* Calculate hours worked based on ATG work schedule information using
3232: API : HR_WRK_SCH_PKG.GET_PER_ASG_SCHEDULE ()
3233: This part will be coded later once this API is available from HR
3234: IF p_include_exceptions IS NULL THEN
3235: use p_include_exceptions = 'Y';
3236:
3237: */
3238: hr_utility.trace( 'getting work schedule from ATG ');
3239:
3240: calc_sch_based_dur ( p_days_or_hours,
3241: p_period_start_date,
3242: p_period_end_date+1,
3248:
3249:
3250: IF (l_duration > 0) THEN
3251: l_work_schedule_found := true;
3252: hr_utility.trace( 'Got work schedule from ATG,duration : '||l_duration);
3253:
3254: return l_duration;
3255: END IF;
3256:
3255: END IF;
3256:
3257: IF NOT l_work_schedule_found THEN
3258: BEGIN
3259: hr_utility.trace( 'getting work schedule from SCL ');
3260: EXECUTE IMMEDIATE 'BEGIN :1 := PAY_'||g_legislation_code||
3261: '_RULES.Work_Schedule_Total_Hours(:2,:3,:4,:5,:6,:7,:8); END;'
3262: USING OUT l_total_hours,
3263: IN assignment_action_id,assignment_id,business_group_id,element_entry_id
3263: IN assignment_action_id,assignment_id,business_group_id,element_entry_id
3264: ,date_earned,p_period_start_date,p_period_end_date;
3265:
3266: IF l_total_hours > 0 THEN
3267: hr_utility.trace( 'work schedule found from SCL ');
3268: l_work_schedule_found := TRUE;
3269: return l_total_hours;
3270: END IF;
3271: -- hr_utility.trace_off;
3267: hr_utility.trace( 'work schedule found from SCL ');
3268: l_work_schedule_found := TRUE;
3269: return l_total_hours;
3270: END IF;
3271: -- hr_utility.trace_off;
3272: EXCEPTION
3273: WHEN OTHERS THEN
3274: -- hr_utility.trace_off;
3275:
3270: END IF;
3271: -- hr_utility.trace_off;
3272: EXCEPTION
3273: WHEN OTHERS THEN
3274: -- hr_utility.trace_off;
3275:
3276: --Raise;
3277: null;
3278: END;
3277: null;
3278: END;
3279: END IF;
3280:
3281: -- hr_utility.trace_off;
3282:
3283:
3284: /* Calculate hours worked based on standard conditions if the actual hours
3285: worked are not available from either ATG work schedule or work schedule
3285: worked are not available from either ATG work schedule or work schedule
3286: at assignment/org level */
3287:
3288: IF NOT l_work_schedule_found THEN
3289: hr_utility.trace('Calculating hours based on Standard conditions ');
3290: hr_utility.trace( 'Assignment Id '||assignment_id);
3291: hr_utility.trace( 'date_earned '||date_earned);
3292: OPEN get_asg_hours_freq(date_earned,assignment_id);
3293: FETCH get_asg_hours_freq
3286: at assignment/org level */
3287:
3288: IF NOT l_work_schedule_found THEN
3289: hr_utility.trace('Calculating hours based on Standard conditions ');
3290: hr_utility.trace( 'Assignment Id '||assignment_id);
3291: hr_utility.trace( 'date_earned '||date_earned);
3292: OPEN get_asg_hours_freq(date_earned,assignment_id);
3293: FETCH get_asg_hours_freq
3294: INTO l_asg_frequency, l_normal_hours;
3287:
3288: IF NOT l_work_schedule_found THEN
3289: hr_utility.trace('Calculating hours based on Standard conditions ');
3290: hr_utility.trace( 'Assignment Id '||assignment_id);
3291: hr_utility.trace( 'date_earned '||date_earned);
3292: OPEN get_asg_hours_freq(date_earned,assignment_id);
3293: FETCH get_asg_hours_freq
3294: INTO l_asg_frequency, l_normal_hours;
3295: CLOSE get_asg_hours_freq;
3293: FETCH get_asg_hours_freq
3294: INTO l_asg_frequency, l_normal_hours;
3295: CLOSE get_asg_hours_freq;
3296:
3297: hr_utility.trace( 'l_asg_frequency '||l_asg_frequency);
3298: hr_utility.trace( 'l_normal_hours '||l_normal_hours);
3299:
3300: IF l_asg_frequency IS NOT NULL and l_normal_hours IS NOT NULL THEN
3301: l_total_hours := standard_hours_worked(l_normal_hours
3294: INTO l_asg_frequency, l_normal_hours;
3295: CLOSE get_asg_hours_freq;
3296:
3297: hr_utility.trace( 'l_asg_frequency '||l_asg_frequency);
3298: hr_utility.trace( 'l_normal_hours '||l_normal_hours);
3299:
3300: IF l_asg_frequency IS NOT NULL and l_normal_hours IS NOT NULL THEN
3301: l_total_hours := standard_hours_worked(l_normal_hours
3302: ,p_period_start_date
3306: END IF;
3307:
3308: END IF;
3309: return 0;
3310: -- hr_utility.trace_off;
3311: END calculate_actual_hours_worked;
3312:
3313: -- Added For Skip Rule for "Regular Wages" Element, "REGULAR_PAY"
3314:
3413: ld_lsp_dt_earned date;
3414:
3415: begin
3416:
3417: hr_utility.trace('ctx_date_earned := '|| to_char(ctx_date_earned));
3418: hr_utility.trace('ctx_payroll_id := '|| ctx_payroll_id);
3419: hr_utility.trace('ctx_assignment_id := '|| ctx_assignment_id);
3420: hr_utility.trace('p_user_entered_time := '|| p_user_entered_time);
3421: hr_utility.trace('p_final_pay_processed := '|| p_final_pay_processed);
3414:
3415: begin
3416:
3417: hr_utility.trace('ctx_date_earned := '|| to_char(ctx_date_earned));
3418: hr_utility.trace('ctx_payroll_id := '|| ctx_payroll_id);
3419: hr_utility.trace('ctx_assignment_id := '|| ctx_assignment_id);
3420: hr_utility.trace('p_user_entered_time := '|| p_user_entered_time);
3421: hr_utility.trace('p_final_pay_processed := '|| p_final_pay_processed);
3422: hr_utility.trace('p_lspd_pay_processed := '|| p_lspd_pay_processed);
3415: begin
3416:
3417: hr_utility.trace('ctx_date_earned := '|| to_char(ctx_date_earned));
3418: hr_utility.trace('ctx_payroll_id := '|| ctx_payroll_id);
3419: hr_utility.trace('ctx_assignment_id := '|| ctx_assignment_id);
3420: hr_utility.trace('p_user_entered_time := '|| p_user_entered_time);
3421: hr_utility.trace('p_final_pay_processed := '|| p_final_pay_processed);
3422: hr_utility.trace('p_lspd_pay_processed := '|| p_lspd_pay_processed);
3423: hr_utility.trace('p_payroll_termination_type := '|| p_payroll_termination_type);
3416:
3417: hr_utility.trace('ctx_date_earned := '|| to_char(ctx_date_earned));
3418: hr_utility.trace('ctx_payroll_id := '|| ctx_payroll_id);
3419: hr_utility.trace('ctx_assignment_id := '|| ctx_assignment_id);
3420: hr_utility.trace('p_user_entered_time := '|| p_user_entered_time);
3421: hr_utility.trace('p_final_pay_processed := '|| p_final_pay_processed);
3422: hr_utility.trace('p_lspd_pay_processed := '|| p_lspd_pay_processed);
3423: hr_utility.trace('p_payroll_termination_type := '|| p_payroll_termination_type);
3424: hr_utility.trace('p_bg_termination_type := '|| p_bg_termination_type);
3417: hr_utility.trace('ctx_date_earned := '|| to_char(ctx_date_earned));
3418: hr_utility.trace('ctx_payroll_id := '|| ctx_payroll_id);
3419: hr_utility.trace('ctx_assignment_id := '|| ctx_assignment_id);
3420: hr_utility.trace('p_user_entered_time := '|| p_user_entered_time);
3421: hr_utility.trace('p_final_pay_processed := '|| p_final_pay_processed);
3422: hr_utility.trace('p_lspd_pay_processed := '|| p_lspd_pay_processed);
3423: hr_utility.trace('p_payroll_termination_type := '|| p_payroll_termination_type);
3424: hr_utility.trace('p_bg_termination_type := '|| p_bg_termination_type);
3425: hr_utility.trace('p_already_processed := '|| p_already_processed);
3418: hr_utility.trace('ctx_payroll_id := '|| ctx_payroll_id);
3419: hr_utility.trace('ctx_assignment_id := '|| ctx_assignment_id);
3420: hr_utility.trace('p_user_entered_time := '|| p_user_entered_time);
3421: hr_utility.trace('p_final_pay_processed := '|| p_final_pay_processed);
3422: hr_utility.trace('p_lspd_pay_processed := '|| p_lspd_pay_processed);
3423: hr_utility.trace('p_payroll_termination_type := '|| p_payroll_termination_type);
3424: hr_utility.trace('p_bg_termination_type := '|| p_bg_termination_type);
3425: hr_utility.trace('p_already_processed := '|| p_already_processed);
3426:
3419: hr_utility.trace('ctx_assignment_id := '|| ctx_assignment_id);
3420: hr_utility.trace('p_user_entered_time := '|| p_user_entered_time);
3421: hr_utility.trace('p_final_pay_processed := '|| p_final_pay_processed);
3422: hr_utility.trace('p_lspd_pay_processed := '|| p_lspd_pay_processed);
3423: hr_utility.trace('p_payroll_termination_type := '|| p_payroll_termination_type);
3424: hr_utility.trace('p_bg_termination_type := '|| p_bg_termination_type);
3425: hr_utility.trace('p_already_processed := '|| p_already_processed);
3426:
3427: OPEN csr_pay_period(ctx_date_earned
3420: hr_utility.trace('p_user_entered_time := '|| p_user_entered_time);
3421: hr_utility.trace('p_final_pay_processed := '|| p_final_pay_processed);
3422: hr_utility.trace('p_lspd_pay_processed := '|| p_lspd_pay_processed);
3423: hr_utility.trace('p_payroll_termination_type := '|| p_payroll_termination_type);
3424: hr_utility.trace('p_bg_termination_type := '|| p_bg_termination_type);
3425: hr_utility.trace('p_already_processed := '|| p_already_processed);
3426:
3427: OPEN csr_pay_period(ctx_date_earned
3428: ,ctx_payroll_id) ;
3421: hr_utility.trace('p_final_pay_processed := '|| p_final_pay_processed);
3422: hr_utility.trace('p_lspd_pay_processed := '|| p_lspd_pay_processed);
3423: hr_utility.trace('p_payroll_termination_type := '|| p_payroll_termination_type);
3424: hr_utility.trace('p_bg_termination_type := '|| p_bg_termination_type);
3425: hr_utility.trace('p_already_processed := '|| p_already_processed);
3426:
3427: OPEN csr_pay_period(ctx_date_earned
3428: ,ctx_payroll_id) ;
3429: FETCH csr_pay_period INTO ld_pay_start_date
3450: lv_term_typ := 'L';
3451: END IF;
3452: END IF;
3453:
3454: hr_utility.trace('ld_pay_start_date := '|| to_char(ld_pay_start_date));
3455: hr_utility.trace('ld_pay_end_date := '|| to_char(ld_pay_end_date));
3456: hr_utility.trace('ld_atd := '|| to_char(ld_atd));
3457: hr_utility.trace('ld_lspd := '|| to_char(ld_lspd));
3458: hr_utility.trace('ld_fpd := '|| to_char(ld_fpd));
3451: END IF;
3452: END IF;
3453:
3454: hr_utility.trace('ld_pay_start_date := '|| to_char(ld_pay_start_date));
3455: hr_utility.trace('ld_pay_end_date := '|| to_char(ld_pay_end_date));
3456: hr_utility.trace('ld_atd := '|| to_char(ld_atd));
3457: hr_utility.trace('ld_lspd := '|| to_char(ld_lspd));
3458: hr_utility.trace('ld_fpd := '|| to_char(ld_fpd));
3459: hr_utility.trace('lv_term_typ := '|| lv_term_typ);
3452: END IF;
3453:
3454: hr_utility.trace('ld_pay_start_date := '|| to_char(ld_pay_start_date));
3455: hr_utility.trace('ld_pay_end_date := '|| to_char(ld_pay_end_date));
3456: hr_utility.trace('ld_atd := '|| to_char(ld_atd));
3457: hr_utility.trace('ld_lspd := '|| to_char(ld_lspd));
3458: hr_utility.trace('ld_fpd := '|| to_char(ld_fpd));
3459: hr_utility.trace('lv_term_typ := '|| lv_term_typ);
3460:
3453:
3454: hr_utility.trace('ld_pay_start_date := '|| to_char(ld_pay_start_date));
3455: hr_utility.trace('ld_pay_end_date := '|| to_char(ld_pay_end_date));
3456: hr_utility.trace('ld_atd := '|| to_char(ld_atd));
3457: hr_utility.trace('ld_lspd := '|| to_char(ld_lspd));
3458: hr_utility.trace('ld_fpd := '|| to_char(ld_fpd));
3459: hr_utility.trace('lv_term_typ := '|| lv_term_typ);
3460:
3461: IF lv_term_typ = 'A' THEN -- Termination Rule 'First Pay After Term Date'
3454: hr_utility.trace('ld_pay_start_date := '|| to_char(ld_pay_start_date));
3455: hr_utility.trace('ld_pay_end_date := '|| to_char(ld_pay_end_date));
3456: hr_utility.trace('ld_atd := '|| to_char(ld_atd));
3457: hr_utility.trace('ld_lspd := '|| to_char(ld_lspd));
3458: hr_utility.trace('ld_fpd := '|| to_char(ld_fpd));
3459: hr_utility.trace('lv_term_typ := '|| lv_term_typ);
3460:
3461: IF lv_term_typ = 'A' THEN -- Termination Rule 'First Pay After Term Date'
3462: IF ld_atd <= ctx_date_earned THEN
3455: hr_utility.trace('ld_pay_end_date := '|| to_char(ld_pay_end_date));
3456: hr_utility.trace('ld_atd := '|| to_char(ld_atd));
3457: hr_utility.trace('ld_lspd := '|| to_char(ld_lspd));
3458: hr_utility.trace('ld_fpd := '|| to_char(ld_fpd));
3459: hr_utility.trace('lv_term_typ := '|| lv_term_typ);
3460:
3461: IF lv_term_typ = 'A' THEN -- Termination Rule 'First Pay After Term Date'
3462: IF ld_atd <= ctx_date_earned THEN
3463: IF p_final_pay_processed = 'Y' THEN
3465: ,ctx_assignment_id);
3466: FETCH csr_fpprocd_min_dtearned INTO ld_fp_dt_earned;
3467: CLOSE csr_fpprocd_min_dtearned;
3468:
3469: hr_utility.trace('ld_fp_dt_earned := '|| TO_CHAR(ld_fp_dt_earned));
3470:
3471: IF ctx_date_earned > ld_fp_dt_earned THEN
3472: return 'Y';
3473: ELSE
3516: ,ctx_assignment_id);
3517: FETCH csr_lspprocd_min_dtearned INTO ld_lsp_dt_earned;
3518: CLOSE csr_lspprocd_min_dtearned;
3519:
3520: hr_utility.trace('ld_fp_dt_earned := '|| TO_CHAR(ld_lsp_dt_earned));
3521:
3522: IF ctx_date_earned > ld_lsp_dt_earned THEN
3523: return 'Y';
3524: ELSE