616: -- Initialize
617: --
618: -- p_assignment_action_id1 := -1;
619: -- p_avg_sal1 := 0;
620: -- p_avg_sal1_std := hr_api.g_sot;
621: -- p_avg_sal1_edd := hr_api.g_sot;
622: -- p_avg_sal1_wkd := 0;
623: -- p_assignment_action_id2 := -1;
624: -- p_avg_sal2 := 0;
617: --
618: -- p_assignment_action_id1 := -1;
619: -- p_avg_sal1 := 0;
620: -- p_avg_sal1_std := hr_api.g_sot;
621: -- p_avg_sal1_edd := hr_api.g_sot;
622: -- p_avg_sal1_wkd := 0;
623: -- p_assignment_action_id2 := -1;
624: -- p_avg_sal2 := 0;
625: -- p_avg_sal2_std := hr_api.g_sot;
621: -- p_avg_sal1_edd := hr_api.g_sot;
622: -- p_avg_sal1_wkd := 0;
623: -- p_assignment_action_id2 := -1;
624: -- p_avg_sal2 := 0;
625: -- p_avg_sal2_std := hr_api.g_sot;
626: -- p_avg_sal2_edd := hr_api.g_sot;
627: -- p_avg_sal2_wkd := 0;
628: -- p_assignment_action_id3 := -1;
629: -- p_avg_sal3 := 0;
622: -- p_avg_sal1_wkd := 0;
623: -- p_assignment_action_id2 := -1;
624: -- p_avg_sal2 := 0;
625: -- p_avg_sal2_std := hr_api.g_sot;
626: -- p_avg_sal2_edd := hr_api.g_sot;
627: -- p_avg_sal2_wkd := 0;
628: -- p_assignment_action_id3 := -1;
629: -- p_avg_sal3 := 0;
630: -- p_avg_sal3_std := hr_api.g_sot;
626: -- p_avg_sal2_edd := hr_api.g_sot;
627: -- p_avg_sal2_wkd := 0;
628: -- p_assignment_action_id3 := -1;
629: -- p_avg_sal3 := 0;
630: -- p_avg_sal3_std := hr_api.g_sot;
631: -- p_avg_sal3_edd := hr_api.g_sot;
632: -- p_avg_sal3_wkd := 0;
633: -- p_assignment_action_id4 := -1;
634: -- p_avg_sal4 := 0;
627: -- p_avg_sal2_wkd := 0;
628: -- p_assignment_action_id3 := -1;
629: -- p_avg_sal3 := 0;
630: -- p_avg_sal3_std := hr_api.g_sot;
631: -- p_avg_sal3_edd := hr_api.g_sot;
632: -- p_avg_sal3_wkd := 0;
633: -- p_assignment_action_id4 := -1;
634: -- p_avg_sal4 := 0;
635: -- p_avg_sal4_std := hr_api.g_sot;
631: -- p_avg_sal3_edd := hr_api.g_sot;
632: -- p_avg_sal3_wkd := 0;
633: -- p_assignment_action_id4 := -1;
634: -- p_avg_sal4 := 0;
635: -- p_avg_sal4_std := hr_api.g_sot;
636: -- p_avg_sal4_edd := hr_api.g_sot;
637: -- p_avg_sal4_wkd := 0;
638: -- p_assignment_action_idb := -1;
639: -- p_avg_bon := 0;
632: -- p_avg_sal3_wkd := 0;
633: -- p_assignment_action_id4 := -1;
634: -- p_avg_sal4 := 0;
635: -- p_avg_sal4_std := hr_api.g_sot;
636: -- p_avg_sal4_edd := hr_api.g_sot;
637: -- p_avg_sal4_wkd := 0;
638: -- p_assignment_action_idb := -1;
639: -- p_avg_bon := 0;
640: -- p_assignment_action_ida := -1;
661:
662: if g_avg_val.base_assignment_action_id is null or g_avg_val.base_assignment_action_id <> p_assignment_action_id then
663: g_avg_val.base_assignment_action_id := p_assignment_action_id;
664: g_avg_val.base_action_sequence := -1;
665: g_avg_val.base_start_date := hr_api.g_sot;
666: g_avg_val.base_end_date := hr_api.g_sot;
667: g_avg_val.assignment_id := -1;
668: g_avg_val.effective_date := hr_api.g_sot;
669: g_avg_val.assignment_action_id := -1;
662: if g_avg_val.base_assignment_action_id is null or g_avg_val.base_assignment_action_id <> p_assignment_action_id then
663: g_avg_val.base_assignment_action_id := p_assignment_action_id;
664: g_avg_val.base_action_sequence := -1;
665: g_avg_val.base_start_date := hr_api.g_sot;
666: g_avg_val.base_end_date := hr_api.g_sot;
667: g_avg_val.assignment_id := -1;
668: g_avg_val.effective_date := hr_api.g_sot;
669: g_avg_val.assignment_action_id := -1;
670: g_avg_val.action_sequence := -1;
664: g_avg_val.base_action_sequence := -1;
665: g_avg_val.base_start_date := hr_api.g_sot;
666: g_avg_val.base_end_date := hr_api.g_sot;
667: g_avg_val.assignment_id := -1;
668: g_avg_val.effective_date := hr_api.g_sot;
669: g_avg_val.assignment_action_id := -1;
670: g_avg_val.action_sequence := -1;
671: g_avg_val.assignment_action_id1 := -1;
672: g_avg_val.avg_sal1 := 0;
669: g_avg_val.assignment_action_id := -1;
670: g_avg_val.action_sequence := -1;
671: g_avg_val.assignment_action_id1 := -1;
672: g_avg_val.avg_sal1 := 0;
673: g_avg_val.avg_sal1_std := hr_api.g_sot;
674: g_avg_val.avg_sal1_edd := hr_api.g_sot;
675: g_avg_val.avg_sal1_wkd := 0;
676: g_avg_val.assignment_action_id2 := -1;
677: g_avg_val.avg_sal2 := 0;
670: g_avg_val.action_sequence := -1;
671: g_avg_val.assignment_action_id1 := -1;
672: g_avg_val.avg_sal1 := 0;
673: g_avg_val.avg_sal1_std := hr_api.g_sot;
674: g_avg_val.avg_sal1_edd := hr_api.g_sot;
675: g_avg_val.avg_sal1_wkd := 0;
676: g_avg_val.assignment_action_id2 := -1;
677: g_avg_val.avg_sal2 := 0;
678: g_avg_val.avg_sal2_std := hr_api.g_sot;
674: g_avg_val.avg_sal1_edd := hr_api.g_sot;
675: g_avg_val.avg_sal1_wkd := 0;
676: g_avg_val.assignment_action_id2 := -1;
677: g_avg_val.avg_sal2 := 0;
678: g_avg_val.avg_sal2_std := hr_api.g_sot;
679: g_avg_val.avg_sal2_edd := hr_api.g_sot;
680: g_avg_val.avg_sal2_wkd := 0;
681: g_avg_val.assignment_action_id3 := -1;
682: g_avg_val.avg_sal3 := 0;
675: g_avg_val.avg_sal1_wkd := 0;
676: g_avg_val.assignment_action_id2 := -1;
677: g_avg_val.avg_sal2 := 0;
678: g_avg_val.avg_sal2_std := hr_api.g_sot;
679: g_avg_val.avg_sal2_edd := hr_api.g_sot;
680: g_avg_val.avg_sal2_wkd := 0;
681: g_avg_val.assignment_action_id3 := -1;
682: g_avg_val.avg_sal3 := 0;
683: g_avg_val.avg_sal3_std := hr_api.g_sot;
679: g_avg_val.avg_sal2_edd := hr_api.g_sot;
680: g_avg_val.avg_sal2_wkd := 0;
681: g_avg_val.assignment_action_id3 := -1;
682: g_avg_val.avg_sal3 := 0;
683: g_avg_val.avg_sal3_std := hr_api.g_sot;
684: g_avg_val.avg_sal3_edd := hr_api.g_sot;
685: g_avg_val.avg_sal3_wkd := 0;
686: g_avg_val.assignment_action_id4 := -1;
687: g_avg_val.avg_sal4 := 0;
680: g_avg_val.avg_sal2_wkd := 0;
681: g_avg_val.assignment_action_id3 := -1;
682: g_avg_val.avg_sal3 := 0;
683: g_avg_val.avg_sal3_std := hr_api.g_sot;
684: g_avg_val.avg_sal3_edd := hr_api.g_sot;
685: g_avg_val.avg_sal3_wkd := 0;
686: g_avg_val.assignment_action_id4 := -1;
687: g_avg_val.avg_sal4 := 0;
688: g_avg_val.avg_sal4_std := hr_api.g_sot;
684: g_avg_val.avg_sal3_edd := hr_api.g_sot;
685: g_avg_val.avg_sal3_wkd := 0;
686: g_avg_val.assignment_action_id4 := -1;
687: g_avg_val.avg_sal4 := 0;
688: g_avg_val.avg_sal4_std := hr_api.g_sot;
689: g_avg_val.avg_sal4_edd := hr_api.g_sot;
690: g_avg_val.avg_sal4_wkd := 0;
691: g_avg_val.assignment_action_idb := -1;
692: g_avg_val.action_sequenceb := -1;
685: g_avg_val.avg_sal3_wkd := 0;
686: g_avg_val.assignment_action_id4 := -1;
687: g_avg_val.avg_sal4 := 0;
688: g_avg_val.avg_sal4_std := hr_api.g_sot;
689: g_avg_val.avg_sal4_edd := hr_api.g_sot;
690: g_avg_val.avg_sal4_wkd := 0;
691: g_avg_val.assignment_action_idb := -1;
692: g_avg_val.action_sequenceb := -1;
693: g_avg_val.avg_bon := 0;
690: g_avg_val.avg_sal4_wkd := 0;
691: g_avg_val.assignment_action_idb := -1;
692: g_avg_val.action_sequenceb := -1;
693: g_avg_val.avg_bon := 0;
694: g_avg_val.avg_bon_std := hr_api.g_sot;
695: g_avg_val.avg_bon_edd := hr_api.g_sot;
696: g_avg_val.assignment_action_ida := -1;
697: g_avg_val.action_sequencea := -1;
698: g_avg_val.avg_alr := 0;
691: g_avg_val.assignment_action_idb := -1;
692: g_avg_val.action_sequenceb := -1;
693: g_avg_val.avg_bon := 0;
694: g_avg_val.avg_bon_std := hr_api.g_sot;
695: g_avg_val.avg_bon_edd := hr_api.g_sot;
696: g_avg_val.assignment_action_ida := -1;
697: g_avg_val.action_sequencea := -1;
698: g_avg_val.avg_alr := 0;
699: g_avg_val.avg_alr_std := hr_api.g_sot;
695: g_avg_val.avg_bon_edd := hr_api.g_sot;
696: g_avg_val.assignment_action_ida := -1;
697: g_avg_val.action_sequencea := -1;
698: g_avg_val.avg_alr := 0;
699: g_avg_val.avg_alr_std := hr_api.g_sot;
700: g_avg_val.avg_alr_edd := hr_api.g_sot;
701: --
702: g_mth_past_action.assignment_action_id.delete;
703: g_mth_past_action.action_sequence.delete;
696: g_avg_val.assignment_action_ida := -1;
697: g_avg_val.action_sequencea := -1;
698: g_avg_val.avg_alr := 0;
699: g_avg_val.avg_alr_std := hr_api.g_sot;
700: g_avg_val.avg_alr_edd := hr_api.g_sot;
701: --
702: g_mth_past_action.assignment_action_id.delete;
703: g_mth_past_action.action_sequence.delete;
704: g_mth_past_action.assignment_id.delete;
737: end if;
738: --
739: if not l_found then
740: l_type := 'MTH';
741: l_end_date := hr_api.g_eot;
742: l_row_cnt := 0;
743: --
744: if g_debug then
745: hr_utility.trace('l_end_date' || l_end_date);
790: g_avg_val.avg_sal4_wkd := g_avg_val.avg_sal4_edd - g_avg_val.avg_sal4_std + 1;
791: end if;
792: end loop;
793: --
794: l_end_date := hr_api.g_eot;
795: l_row_cnt := 0;
796: --
797: if not l_found then
798: open csr_past_action;
895: g_avg_val.avg_sal4 := g_avg_val.avg_sal4 * l_rate;
896: end if;
897: --
898: l_type := 'BON';
899: l_end_date := hr_api.g_eot;
900: l_row_cnt := 0;
901: l_found := FALSE;
902: --
903: l_bon_index := g_bon_past_action.assignment_action_id.count;
953: p_target_end_date => g_avg_val.avg_bon_edd,
954: p_balance_type_id => g_balance_type_id);
955: --
956: l_type := 'ALR';
957: l_end_date := hr_api.g_eot;
958: l_row_cnt := 0;
959: l_found := FALSE;
960: --
961: l_alr_index := g_alr_past_action.assignment_action_id.count;