eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_HU_ABS_REP_ARCHIVE_PKG dependencies on PER_ACCRUAL_CALC_FUNCTIONS

Line 495: IF per_accrual_calc_functions.check_assignment_enrollment(

491: ,l_co_formula_id_1;
492: CLOSE csr_accrual_details;
493:
494: IF l_accrual_plan_id_1 IS NOT NULL THEN
495: IF per_accrual_calc_functions.check_assignment_enrollment(
496: csr_rec.assignment_id
497: ,l_Base_ele_type_id
498: ,g_reporting_date) THEN
499:

Line 502: per_accrual_calc_functions.get_carry_over_values

498: ,g_reporting_date) THEN
499:
500: l_emp_enrolment := 1;
501:
502: per_accrual_calc_functions.get_carry_over_values
503: (p_co_formula_id => l_co_formula_id_1
504: ,p_assignment_id => csr_rec.assignment_id
505: ,p_calculation_date => g_reporting_date
506: ,p_accrual_plan_id => l_accrual_plan_id_1

Line 520: per_accrual_calc_functions.get_net_accrual

516: l_calculation_date := LEAST(l_term_end_date
517: ,NVL(csr_rec.termination_date
518: ,TO_DATE('31-12-4712','DD-MM-YYYY')));
519:
520: per_accrual_calc_functions.get_net_accrual
521: (p_assignment_id => csr_rec.assignment_id
522: ,p_plan_id => l_accrual_plan_id_1
523: ,p_payroll_id => csr_rec.payroll_id
524: ,p_business_group_id => g_business_group_id

Line 538: per_accrual_calc_functions.get_carry_over

534: ,p_net_entitlement => l_base_holiday);
535:
536: /* ***********************************************************
537: l_base_holiday_prev :=
538: per_accrual_calc_functions.get_carry_over
539: (p_assignment_id => csr_rec.assignment_id
540: ,p_plan_id => l_accrual_plan_id_1
541: ,p_start_date => l_start_date
542: ,p_calculation_date => l_end_date

Line 547: per_accrual_calc_functions.get_carry_over

543: );
544:
545:
546: l_base_holiday_carry_over :=
547: per_accrual_calc_functions.get_carry_over
548: (p_assignment_id => csr_rec.assignment_id
549: ,p_plan_id => l_accrual_plan_id_1
550: ,p_start_date => l_start_date
551: ,p_calculation_date => to_date('01-JAN'||to_char(g_reporting_date,'YYYY'),'dd/mm/yyyy')

Line 557: l_base_absence := per_accrual_calc_functions.get_absence(

553:
554:
555: l_base_holiday := nvl(l_base_holiday,0) - nvl(l_base_holiday_prev,0);
556:
557: l_base_absence := per_accrual_calc_functions.get_absence(
558: p_assignment_id => csr_rec.assignment_id
559: ,p_plan_id => l_accrual_plan_id_1
560: ,p_start_date => l_start_date
561: ,p_calculation_date =>g_reporting_date); -- to_date(to_char(l_base_exp_date,'dd/mm')||to_char(g_reporting_date,'YYYY'),'dd/mm/yyyy')

Line 566: per_accrual_calc_functions.get_carry_over

562: *********************************************************/
563:
564: IF TO_NUMBER(TO_CHAR(g_reporting_date,'mmdd')) <= TO_NUMBER(TO_CHAR(l_base_exp_date,'mmdd')) THEN
565: l_base_holiday_carry_over :=
566: per_accrual_calc_functions.get_carry_over
567: (p_assignment_id => csr_rec.assignment_id
568: ,p_plan_id => l_accrual_plan_id_1
569: ,p_start_date => l_start_date
570: ,p_calculation_date => to_date('01/01/'||to_char(g_reporting_date,'YYYY'),'dd/mm/yyyy')

Line 605: IF per_accrual_calc_functions.check_assignment_enrollment(

601: ,l_childcare_ele_type_id
602: ,l_co_formula_id_2;
603: CLOSE csr_accrual_details;
604: IF l_accrual_plan_id_2 IS NOT NULL THEN
605: IF per_accrual_calc_functions.check_assignment_enrollment(
606: csr_rec.assignment_id
607: ,l_childcare_ele_type_id
608: ,g_reporting_date) THEN
609:

Line 612: per_accrual_calc_functions.get_carry_over_values

608: ,g_reporting_date) THEN
609:
610: l_emp_enrolment := 1;
611:
612: per_accrual_calc_functions.get_carry_over_values
613: (p_co_formula_id => l_co_formula_id_2
614: ,p_assignment_id => csr_rec.assignment_id
615: ,p_calculation_date => g_reporting_date
616: ,p_accrual_plan_id => l_accrual_plan_id_2

Line 630: per_accrual_calc_functions.get_net_accrual

626: l_calculation_date := LEAST(l_term_end_date
627: ,NVL(csr_rec.termination_date
628: ,TO_DATE('31-12-4712','DD-MM-YYYY')));
629:
630: per_accrual_calc_functions.get_net_accrual
631: (p_assignment_id => csr_rec.assignment_id
632: ,p_plan_id => l_accrual_plan_id_2
633: ,p_payroll_id => csr_rec.payroll_id
634: ,p_business_group_id => g_business_group_id

Line 648: per_accrual_calc_functions.get_carry_over

644: ,p_net_entitlement => l_child_care_holiday);
645:
646: /*************************************************************
647: l_child_care_holiday_prev :=
648: per_accrual_calc_functions.get_carry_over
649: (p_assignment_id => csr_rec.assignment_id
650: ,p_plan_id => l_accrual_plan_id_2
651: ,p_start_date => l_start_date
652: ,p_calculation_date => l_end_date

Line 657: per_accrual_calc_functions.get_carry_over

653: );
654:
655:
656: l_child_hol_carry_over :=
657: per_accrual_calc_functions.get_carry_over
658: (p_assignment_id => csr_rec.assignment_id
659: ,p_plan_id => l_accrual_plan_id_2
660: ,p_start_date => l_start_date
661: ,p_calculation_date => to_date('01-JAN'||to_char(g_reporting_date,'YYYY'),'dd/mm/yyyy')

Line 667: l_child_care_absence := per_accrual_calc_functions.get_absence(

663:
664: l_child_care_holiday := nvl(l_child_care_holiday,0) -
665: nvl(l_child_care_holiday_prev,0);
666:
667: l_child_care_absence := per_accrual_calc_functions.get_absence(
668: p_assignment_id => csr_rec.assignment_id
669: ,p_plan_id => l_accrual_plan_id_2
670: ,p_start_date => l_start_date
671: ,p_calculation_date => g_reporting_date -- to_date(to_char(l_child_care_exp_date,'dd/mm')||to_char(g_reporting_date,'YYYY'),'dd/mm/yyyy')

Line 677: per_accrual_calc_functions.get_carry_over

673: ********************************************************/
674:
675: IF TO_NUMBER(TO_CHAR(g_reporting_date,'mmdd')) <= TO_NUMBER(TO_CHAR(l_child_care_exp_date,'mmdd')) THEN
676: l_child_hol_carry_over :=
677: per_accrual_calc_functions.get_carry_over
678: (p_assignment_id => csr_rec.assignment_id
679: ,p_plan_id => l_accrual_plan_id_2
680: ,p_start_date => l_start_date
681: ,p_calculation_date => to_date('01/01/'||to_char(g_reporting_date,'YYYY'),'dd/mm/yyyy')

Line 716: IF per_accrual_calc_functions.check_assignment_enrollment(

712: ,l_co_formula_id_3;
713: CLOSE csr_accrual_details;
714:
715: IF l_accrual_plan_id_3 IS NOT NULL THEN
716: IF per_accrual_calc_functions.check_assignment_enrollment(
717: csr_rec.assignment_id
718: ,l_other_ele_type_id
719: ,g_reporting_date) THEN
720:

Line 723: per_accrual_calc_functions.get_carry_over_values

719: ,g_reporting_date) THEN
720:
721: l_emp_enrolment := 1;
722:
723: per_accrual_calc_functions.get_carry_over_values
724: (p_co_formula_id => l_co_formula_id_3
725: ,p_assignment_id => csr_rec.assignment_id
726: ,p_calculation_date => g_reporting_date
727: ,p_accrual_plan_id => l_accrual_plan_id_3

Line 741: per_accrual_calc_functions.get_net_accrual

737: l_calculation_date := LEAST(l_term_end_date
738: ,NVL(csr_rec.termination_date
739: ,TO_DATE('31-12-4712','DD-MM-YYYY')));
740:
741: per_accrual_calc_functions.get_net_accrual
742: (p_assignment_id => csr_rec.assignment_id
743: ,p_plan_id => l_accrual_plan_id_3
744: ,p_payroll_id => csr_rec.payroll_id
745: ,p_business_group_id => g_business_group_id

Line 759: per_accrual_calc_functions.get_carry_over

755: ,p_net_entitlement => l_additional_holiday);
756:
757: /*************************************************************
758: l_additional_holiday_prev :=
759: per_accrual_calc_functions.get_carry_over
760: (p_assignment_id => csr_rec.assignment_id
761: ,p_plan_id => l_accrual_plan_id_3
762: ,p_start_date => l_start_date
763: ,p_calculation_date => l_end_date

Line 768: per_accrual_calc_functions.get_carry_over

764: );
765:
766:
767: l_add_holiday_carry_over :=
768: per_accrual_calc_functions.get_carry_over
769: (p_assignment_id => csr_rec.assignment_id
770: ,p_plan_id => l_accrual_plan_id_3
771: ,p_start_date => l_start_date
772: ,p_calculation_date => to_date('01-JAN'||to_char(g_reporting_date,'YYYY'),'dd/mm/yyyy')

Line 778: l_additional_absence := per_accrual_calc_functions.get_absence(

774:
775: l_additional_holiday := nvl(l_additional_holiday,0) -
776: nvl(l_additional_holiday_prev,0);
777:
778: l_additional_absence := per_accrual_calc_functions.get_absence(
779: p_assignment_id => csr_rec.assignment_id
780: ,p_plan_id => l_accrual_plan_id_3
781: ,p_start_date => l_start_date
782: ,p_calculation_date => g_reporting_date -- to_date(to_char(l_additional_exp_date,'dd/mm')||to_char(g_reporting_date,'YYYY'),'dd/mm/yyyy')

Line 787: per_accrual_calc_functions.get_carry_over

783: );
784: **********************************************************/
785: IF TO_NUMBER(TO_CHAR(g_reporting_date,'mmdd')) <= TO_NUMBER(TO_CHAR(l_additional_exp_date,'mmdd')) THEN
786: l_add_holiday_carry_over :=
787: per_accrual_calc_functions.get_carry_over
788: (p_assignment_id => csr_rec.assignment_id
789: ,p_plan_id => l_accrual_plan_id_3
790: ,p_start_date => l_start_date
791: ,p_calculation_date => to_date('01/01/'||to_char(g_reporting_date,'YYYY'),'dd/mm/yyyy')

Line 827: IF per_accrual_calc_functions.check_assignment_enrollment(

823: ,l_co_formula_id_4;
824: CLOSE csr_accrual_details;
825:
826: IF l_accrual_plan_id_4 IS NOT NULL THEN
827: IF per_accrual_calc_functions.check_assignment_enrollment(
828: csr_rec.assignment_id
829: ,l_sickness_ele_type_id
830: ,g_reporting_date) THEN
831:

Line 834: per_accrual_calc_functions.get_carry_over_values

830: ,g_reporting_date) THEN
831:
832: l_emp_enrolment := 1;
833:
834: per_accrual_calc_functions.get_carry_over_values
835: (p_co_formula_id => l_co_formula_id_4
836: ,p_assignment_id => csr_rec.assignment_id
837: ,p_calculation_date => g_reporting_date
838: ,p_accrual_plan_id => l_accrual_plan_id_4

Line 852: per_accrual_calc_functions.get_net_accrual

848: l_calculation_date := LEAST(l_term_end_date
849: ,NVL(csr_rec.termination_date
850: ,TO_DATE('31-12-4712','DD-MM-YYYY')));
851:
852: per_accrual_calc_functions.get_net_accrual
853: (p_assignment_id => csr_rec.assignment_id
854: ,p_plan_id => l_accrual_plan_id_4
855: ,p_payroll_id => csr_rec.payroll_id
856: ,p_business_group_id => g_business_group_id