DBA Data[Home] [Help]

APPS.GHR_ELT_TO_BEN_PKG dependencies on HR_API

Line 221: l_benefits_eit_rec ghr_api.per_benefit_info_type;

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;

Line 282: PROCEDURE print_ben_record(p_benefits_eit_rec IN ghr_api.per_benefit_info_type,p_person_id IN 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);

Line 328: p_benefits_eit_rec IN OUT nocopy ghr_api.per_benefit_info_type

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);

Line 331: l_benefits_eit_rec ghr_api.per_benefit_info_type;

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:

Line 394: p_benefits_eit_rec IN ghr_api.per_benefit_info_type,

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;