1 PACKAGE GHR_MASS_SEL_NOA AUTHID CURRENT_USER AS
2 /* $Header: ghmasnoa.pkh 120.0.12020000.5 2013/01/22 11:32:52 utokachi noship $ */
3
4 mnoa_error EXCEPTION;
5
6 PROCEDURE execute_mnoa
7 (p_errbuf OUT NOCOPY varchar2
8 , p_retcode OUT NOCOPY number
9 , p_mass_salary_id IN number
10 , p_action IN varchar2);
11
12 --Begin Bug # 14467215
13 PROCEDURE execute_mcancel
14 (p_errbuf OUT NOCOPY varchar2
15 , p_retcode OUT NOCOPY number
16 , p_mass_salary_id IN number
17 , p_action IN varchar2);
18
19 --End Bug # 14467215
20 PROCEDURE fetch_and_validate_emp
21 (p_action IN varchar2
22 , p_mass_salary_id IN number
23 , p_mass_salary_name IN varchar2
24 , p_full_name IN per_people_f.full_name%TYPE
25 , p_national_identifier IN per_people_f.national_identifier%TYPE
26 , p_employee_number IN per_people_f.employee_number%TYPE
27 , p_assignment_id IN per_assignments_f.assignment_id%TYPE
28 , p_person_id IN per_assignments_f.person_id%TYPE
29 , p_position_id IN per_assignments_f.position_id%TYPE
30 , p_grade_id IN per_assignments_f.grade_id%TYPE
31 , p_business_group_id IN per_assignments_f.business_group_id%TYPE
32 , p_location_id IN per_assignments_f.location_id%TYPE
33 , p_organization_id IN per_assignments_f.organization_id%TYPE
34 , p_mnoa_organization_id IN per_assignments_f.organization_id%TYPE
35 , p_mnoa_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
36 , p_mnoa_personnel_office_id IN varchar2
37 , p_mnoa_agency_code_subelement IN varchar2
38 , p_mnoa_job_id IN number default NULL
39 , p_mnoa_bargaining_unit IN varchar2 default NULL
40 , p_mnoa_flsa_category IN varchar2 default NULL
41 , p_personnel_office_id OUT NOCOPY varchar2
42 , p_org_structure_id OUT NOCOPY varchar2
43 , p_position_title OUT NOCOPY varchar2
44 , p_position_number OUT NOCOPY varchar2
45 , p_position_seq_no OUT NOCOPY varchar2
46 , p_subelem_code OUT NOCOPY varchar2
47 , p_duty_station_id OUT NOCOPY ghr_duty_stations_f.duty_station_id%TYPE
48 , p_tenure OUT NOCOPY varchar2
49 , p_annuitant_indicator OUT NOCOPY varchar2
50 , p_pay_rate_determinant OUT NOCOPY varchar2
51 , p_work_schedule OUT NOCOPY varchar2
52 , p_part_time_hour OUT NOCOPY varchar2
53 , p_to_grade_id OUT NOCOPY per_assignments_f.grade_id%TYPE
54 , p_pay_plan OUT NOCOPY varchar2
55 , p_to_pay_plan OUT NOCOPY varchar2
56 , p_pay_table_id OUT NOCOPY number
57 , p_grade_or_level OUT NOCOPY varchar2
58 , p_to_grade_or_level OUT NOCOPY varchar2
59 , p_step_or_rate OUT NOCOPY varchar2
60 , p_pay_basis OUT NOCOPY varchar2
61 , p_elig_flag OUT NOCOPY boolean);
62
63 PROCEDURE pr
64 (msg IN varchar2
65 , par1 IN varchar2 DEFAULT NULL
66 , par2 IN varchar2 DEFAULT NULL);
67
68 PROCEDURE update_sel_flg
69 (p_person_id IN number
70 , p_effective_date IN date);
71
72 PROCEDURE refresh_ei_details
73 (p_noa_action IN ghr_pa_requests.first_noa_code%TYPE
74 , p_effective_date IN date
75 , p_person_id IN per_people_f.person_id%TYPE
76 , p_work_schedule IN ghr_pa_requests.work_schedule%TYPE
77 , p_pa_request_id IN ghr_pa_requests.pa_request_id%TYPE);
78
79 FUNCTION check_select_flg
80 (p_person_id IN number
81 , p_action IN varchar2
82 , p_effective_date IN date
83 , p_mass_salary_id IN number
84 , p_sel_flg IN OUT NOCOPY varchar2) RETURN boolean;
85
86 PROCEDURE get_extra_info_comments
87 (p_person_id IN number
88 , p_effective_date IN date
89 , p_sel_flag IN OUT NOCOPY varchar2
90 , p_comments IN OUT NOCOPY varchar2
91 , p_mass_salary_id IN number);
92
93 PROCEDURE ins_upd_per_extra_info
94 (p_person_id IN number
95 , p_effective_date IN date
96 , p_sel_flag IN varchar2
97 , p_comment IN varchar2
98 , p_msl_id IN number);
99
100 PROCEDURE get_lac_dtls
101 (p_pa_request_id IN number
102 , p_sf52_rec OUT NOCOPY ghr_pa_requests%ROWTYPE);
103
104 --Bug# 14751973
105 PROCEDURE purge_processed_noa_recs(p_session_id in number,
106 p_err_buf out nocopy varchar2);
107 END ghr_mass_sel_noa;
108