[Home] [Help]
10:
11: PROCEDURE get_pa_request_id_ovn (
12: p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE,
13: p_effective_date in date,
14: p_person_id in per_people_f.person_id%TYPE,
15: p_pa_notification_id out nocopy ghr_pa_requests.pa_notification_id%TYPE,
16: p_rpa_type out nocopy ghr_pa_requests.rpa_type%TYPE,
17: p_object_version_number out nocopy ghr_pa_requests.object_version_number%TYPE)
18:
57: PROCEDURE refresh_ei_details
58: (
59: p_noa_action in ghr_pa_requests.first_noa_code%TYPE,
60: p_effective_date in date,
61: p_person_id in per_people_f.person_id%TYPE,
62: p_pa_request_id in ghr_pa_requests.pa_request_id%type
63: )
64:
65: IS
593: (
594: p_noa_action in VARCHAR2,
595: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,
596: p_effective_date in date,
597: p_person_id in per_people_f.person_id%TYPE,
598: p_pa_request_rec in out nocopy ghr_pa_requests%rowtype ,
599: p_log_text out nocopy varchar2
600: )
601: IS
1128: ( p_noa_action in VARCHAR2,
1129: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,
1130: p_effective_date in date,
1131: p_nte_date in varchar2,
1132: p_person_id in per_people_f.person_id%TYPE,
1133: p_assignment_id in per_assignments_f.assignment_id%TYPE,
1134: p_position_id in hr_positions_f.position_id%TYPE,
1135: p_location_id in hr_locations.location_id%TYPE,
1136: p_business_group_id in number,
1143: l_proc varchar2(172) := g_package || 'build_rpa';
1144: l_dummy varchar2(30);
1145: l_dummy_number number;
1146: l_pa_request_rec ghr_pa_requests%rowtype;
1147: l_personnel_officer_name per_people_f.full_name%type;
1148: l_approving_off_work_title ghr_pa_requests.APPROVING_OFFICIAL_WORK_TITLE%type;
1149: l_1_prh_object_version_number ghr_pa_requests.object_version_number%type;
1150: l_1_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
1151: l_multiple_error_flag boolean;
1868: l_asg_extra_info_rec per_assignment_extra_info%rowtype;
1869: l_elig_flag BOOLEAN := FALSE;
1870: l_emergency_ess_emp VARCHAR2(20);
1871: l_full_name VARCHAR2(380);
1872: l_employee_number per_people_f.employee_number%type;
1873:
1874: CURSOR cur_people (l_eff_date date) IS
1875: SELECT ppf.person_id PERSON_ID,
1876: ppf.first_name FIRST_NAME,
1886: paf.organization_id ORGANIZATION_ID,
1887: paf.business_group_id BUSINESS_GROUP_ID,
1888: paf.assignment_status_type_id ASSIGNMENT_STATUS_TYPE_ID
1889: FROM per_assignments_f paf,
1890: per_people_f ppf,
1891: per_person_types ppt,
1892: hr_organization_units hou
1893: WHERE ppf.person_id = paf.person_id
1894: AND l_eff_date between ppf.effective_start_date and ppf.effective_end_date
1936: paf.organization_id ORGANIZATION_ID,
1937: paf.business_group_id BUSINESS_GROUP_ID,
1938: paf.assignment_status_type_id ASSIGNMENT_STATUS_TYPE_ID
1939: FROM per_assignments_f paf,
1940: per_people_f ppf,
1941: per_person_types ppt,
1942: hr_organization_units hou,
1943: per_assignment_status_types past
1944: WHERE ppf.person_id = paf.person_id