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 285: PROCEDURE print_ben_record(p_benefits_eit_rec IN ghr_api.per_benefit_info_type,p_person_id IN NUMBER,

281: )
282: ORDER BY effective_date,table_name,process_date,information1,pa_history_id;
283:
284:
285: PROCEDURE print_ben_record(p_benefits_eit_rec IN ghr_api.per_benefit_info_type,p_person_id IN NUMBER,
286: p_effective_date IN DATE) IS
287: BEGIN
288: hr_utility.set_location('PERSON ID : '||to_char(p_person_id),500);
289: hr_utility.set_location('Eff Date : '||to_char(p_effective_date),505);

Line 331: p_benefits_eit_rec IN OUT nocopy ghr_api.per_benefit_info_type

327: END get_person_name_ssn;
328:
329: -- Procedure to BUILD the intermediate Benefits Record
330: PROCEDURE build_benefits_rec(p_pa_history_rec IN ghr_pa_history%rowtype,
331: p_benefits_eit_rec IN OUT nocopy ghr_api.per_benefit_info_type
332: ) IS
333:
334: l_benefits_eit_rec ghr_api.per_benefit_info_type;
335: l_element_name VARCHAR2(150);

Line 334: l_benefits_eit_rec ghr_api.per_benefit_info_type;

330: PROCEDURE build_benefits_rec(p_pa_history_rec IN ghr_pa_history%rowtype,
331: p_benefits_eit_rec IN OUT nocopy ghr_api.per_benefit_info_type
332: ) IS
333:
334: l_benefits_eit_rec ghr_api.per_benefit_info_type;
335: l_element_name VARCHAR2(150);
336: l_input_value VARCHAR2(150);
337: l_input_value_id NUMBER(20);
338:

Line 397: p_benefits_eit_rec IN ghr_api.per_benefit_info_type,

393: RAISE;
394: END build_benefits_rec;
395:
396: PROCEDURE insert_benefits_eit_rec(p_person_id IN NUMBER,
397: p_benefits_eit_rec IN ghr_api.per_benefit_info_type,
398: p_effective_date IN DATE) IS
399:
400: l_information_type per_people_extra_info.information_type%type;
401: l_person_extra_info_id NUMBER;

Line 2124: AND ghr_api.get_position_agency_code_pos(paf.position_id,paf.business_group_id) like SUBSTR(p_agency_code,1,2)||SUBSTR(p_agency_sub_code,1,2)||'%' ;

2120: --and fnd_date.canonical_to_date(ppei.pei_information14) >= l_agency_effective_date
2121: and ppei.pei_information14 IS NOT NULL
2122: and ppf.business_group_id=paf.business_group_id
2123: and ppf.business_group_id= NVL(p_business_group_id,ppf.business_group_id)
2124: AND ghr_api.get_position_agency_code_pos(paf.position_id,paf.business_group_id) like SUBSTR(p_agency_code,1,2)||SUBSTR(p_agency_sub_code,1,2)||'%' ;
2125:
2126: l_rpa_effective_date ghr_pa_requests.effective_date%type;
2127: l_rpa_tsp_status_code ghr_pa_request_extra_info.rei_information15%type;
2128: l_rpa_agncy_contrib_elig_date ghr_pa_request_extra_info.rei_information17%type;

Line 2490: ghr_api.g_api_dml := TRUE;

2486: );
2487:
2488:
2489:
2490: ghr_api.g_api_dml := TRUE;
2491: ghr_history_api.post_update_process;
2492: ghr_history_api.reinit_g_session_var;
2493: ghr_api.g_api_dml := FALSE;
2494:

Line 2493: ghr_api.g_api_dml := FALSE;

2489:
2490: ghr_api.g_api_dml := TRUE;
2491: ghr_history_api.post_update_process;
2492: ghr_history_api.reinit_g_session_var;
2493: ghr_api.g_api_dml := FALSE;
2494:
2495: IF (l_agency_effective_date <= fnd_date.canonical_to_date(l_agncy_contrib_elig_date)
2496: AND fnd_date.canonical_to_date(l_agncy_contrib_elig_date) < SYSDATE)
2497: AND l_process_log_upd_flag = 0 THEN

Line 2536: ghr_api.g_api_dml := FALSE;

2532: ' SQLERR ' || SQLERRM,
2533: p_log_date => sysdate);
2534:
2535: ghr_history_api.reinit_g_session_var;
2536: ghr_api.g_api_dml := FALSE;
2537:
2538: END;--B4
2539: END IF;--l_retirement_plan IN('K','L', 'M
2540: END IF;--IF fnd_date.canonical_to_date(l_agncy_contrib_elig_date) >