[Home] [Help]
56: l_index varchar2(10);
57: l_extra_info_id number(15);
58: l_extra_info_rec ghr_api.extra_info_rec_type;
59: --
60: l_asg_cre_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type;
61: l_asg_cre_ovn per_assignment_extra_info.object_version_number%type;
62: l_per_cre_extra_info_id per_people_extra_info.person_extra_info_id%type;
63: l_per_cre_ovn per_people_extra_info.object_version_number%type;
64: l_pos1_cre_extra_info_id per_position_extra_info.position_extra_info_id%type;
57: l_extra_info_id number(15);
58: l_extra_info_rec ghr_api.extra_info_rec_type;
59: --
60: l_asg_cre_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type;
61: l_asg_cre_ovn per_assignment_extra_info.object_version_number%type;
62: l_per_cre_extra_info_id per_people_extra_info.person_extra_info_id%type;
63: l_per_cre_ovn per_people_extra_info.object_version_number%type;
64: l_pos1_cre_extra_info_id per_position_extra_info.position_extra_info_id%type;
65: l_pos1_cre_ovn per_position_extra_info.object_version_number%type;
104:
105: Cursor c_asg_ei is
106: select assignment_extra_info_id,
107: object_version_number
108: from per_assignment_extra_info
109: where assignment_id = l_id
110: and information_type = p_l_information_type;
111:
112: Cursor c_per_ei is
1423: NVL(par.first_noa_cancel_or_correct, 'NULL') <> 'CANCEL'
1424: ORDER BY effective_date ASC;
1425: */
1426: l_noa_code VARCHAR2(80);
1427: l_NTE_Dates per_assignment_extra_info.aei_information4%TYPE;
1428:
1429: --
1430: -- for bug 3191704
1431: CURSOR cur_rei_poi(p_par_id in NUMBER)
1437:
1438: target_poi ghr_pa_requests.personnel_office_id%type;
1439: -- for bug 3191704
1440:
1441: --l_NTE_Dates per_assignment_extra_info.aei_information4%TYPE;
1442: ---------------------------------------------------------- added 2 cursors for 1274541
1443: --Begin Bug 5919705
1444: l_grade_or_level ghr_pa_requests.to_grade_or_level%type;
1445: l_pay_plan ghr_pa_requests.to_pay_plan%type;
1521: l_agency_code_transfer_to ghr_pa_requests.agency_code%type;
1522: --
1523: -- Bug 3390876
1524: l_np_eff_date ghr_pa_requests.effective_date%type;
1525: l_asg_ei_data per_assignment_extra_info%rowtype;
1526: Begin
1527: --
1528: hr_utility.set_location('Entering ' ||l_proc,5);
1529: hr_utility.set_location('CALL EXT INFOper_serv_oblig_flag '||p_per_service_oblig.per_service_oblig_flag,10);
3571: --
3572: --
3573: l_assgn_id NUMBER;
3574: l_eff_date DATE;
3575: l_NTE_Dates per_assignment_extra_info.aei_information4%TYPE;
3576: l_active_flag varchar2(1);
3577: l_RTD_noa_code VARCHAR2(80);
3578: l_bg_id NUMBER;
3579: -- BUG #8258924