217:
218: -- Variable Declaration
219: l_current_bg_id NUMBER(15);
220: l_current_person_id NUMBER(15);
221: l_benefits_eit_rec ghr_api.per_benefit_info_type;
222: l_pa_history_rec ghr_pa_history%rowtype;
223: l_new_effective_date DATE;
224: l_old_effective_date DATE;
225: l_cnt NUMBER;
278: )
279: ORDER BY effective_date,table_name,process_date,information1,pa_history_id;
280:
281:
282: PROCEDURE print_ben_record(p_benefits_eit_rec IN ghr_api.per_benefit_info_type,p_person_id IN NUMBER,
283: p_effective_date IN DATE) IS
284: BEGIN
285: hr_utility.set_location('PERSON ID : '||to_char(p_person_id),500);
286: hr_utility.set_location('Eff Date : '||to_char(p_effective_date),505);
324: END get_person_name_ssn;
325:
326: -- Procedure to BUILD the intermediate Benefits Record
327: PROCEDURE build_benefits_rec(p_pa_history_rec IN ghr_pa_history%rowtype,
328: p_benefits_eit_rec IN OUT nocopy ghr_api.per_benefit_info_type
329: ) IS
330:
331: l_benefits_eit_rec ghr_api.per_benefit_info_type;
332: l_element_name VARCHAR2(150);
327: PROCEDURE build_benefits_rec(p_pa_history_rec IN ghr_pa_history%rowtype,
328: p_benefits_eit_rec IN OUT nocopy ghr_api.per_benefit_info_type
329: ) IS
330:
331: l_benefits_eit_rec ghr_api.per_benefit_info_type;
332: l_element_name VARCHAR2(150);
333: l_input_value VARCHAR2(150);
334: l_input_value_id NUMBER(20);
335:
390: RAISE;
391: END build_benefits_rec;
392:
393: PROCEDURE insert_benefits_eit_rec(p_person_id IN NUMBER,
394: p_benefits_eit_rec IN ghr_api.per_benefit_info_type,
395: p_effective_date IN DATE) IS
396:
397: l_information_type per_people_extra_info.information_type%type;
398: l_person_extra_info_id NUMBER;