[Home] [Help]
63: end get_people_ei_id_ason_date;
64:
65:
66: -- This function is a wrapper functions which returns the input value of an element on the given date.
67: -- This function calls ghr_per_sum.get_element_details procedure.
68:
69: function get_ele_value_ason_date (p_ele_name in varchar2
70: ,p_input_name in varchar2
71: ,p_asg_id in number
79: Begin
80: l_proc := g_package||'.get_ele_value_ason_date';
81: hr_utility.set_location('Entering... ' ||l_proc,1000);
82:
83: ghr_per_sum.get_element_details(p_ele_name,
84: p_input_name,
85: p_asg_id,
86: p_eff_date,
87: l_screen_entry_value,
94:
95: End get_ele_value_ason_date;
96:
97: -- This function is a wrapper functions which returns the input value of an element on the given date.
98: -- This function calls ghr_per_sum.get_element_entry_values procedure.
99:
100:
101: function get_ele_entry_value_ason_date (p_element_entry_id IN NUMBER
102: ,p_input_value_name IN VARCHAR2
109: Begin
110:
111: l_proc := g_package||'.get_ele_entry_value_ason_date';
112: hr_utility.set_location('Entering... ' ||l_proc,1000);
113: ghr_per_sum.get_element_entry_values (p_element_entry_id
114: ,p_input_value_name
115: ,p_effective_date
116: ,l_value
117: ,l_effective_start_date );
373:
374: End retrieve_element_curr_code;
375:
376: -- This is a wrapper function to get the locality pay area percentage.
377: -- This function calls ghr_per_sum.get_duty_station_details procedure.
378:
379: function get_loc_pay_area_percentage (p_location_id in number,
380: p_effective_date in date ) return varchar2 is
381: --
395: hr_utility.set_location('Location id : ' || p_location_id, 1000);
396: hr_utility.set_location('Effective_date : ' || p_effective_date, 1000);
397: end if;
398:
399: ghr_per_sum.get_duty_station_details (p_location_id
400: ,p_effective_date
401: ,l_duty_sation_code
402: ,l_duty_station_desc
403: ,l_locality_pay_area
806: exit;
807: END LOOP;
808: --BUG # 14558097 modified to consider assignment end date
809: -- fetch the total pay of the employee
810: ghr_per_sum.get_element_details(p_ele_name,
811: p_input_name,
812: l_asg_id,
813: ghr_ss_views_pkg.get_assignment_end_date(p_person_id),
814: l_screen_entry_value,