[Home] [Help]
1: PACKAGE ghr_pa_requests_pkg AS
2: /* $Header: ghparqst.pkh 120.2.12010000.1 2008/07/28 10:35:30 appldev ship $ */
3:
4: PROCEDURE get_process_method(
5: p_noa_family_code IN ghr_noa_fam_proc_methods.noa_family_code%TYPE
81: ,p_personnelist_flag IN OUT NOCOPY VARCHAR2
82: ,p_approver_flag IN OUT NOCOPY VARCHAR2
83: ,p_reviewer_flag IN OUT NOCOPY VARCHAR2);
84: --
85: PROCEDURE get_last_routing_list(p_pa_request_id IN ghr_pa_requests.pa_request_id%TYPE
86: ,p_routing_list_id OUT NOCOPY ghr_routing_lists.routing_list_id%TYPE
87: ,p_routing_list_name OUT NOCOPY ghr_routing_lists.name%TYPE
88: ,p_next_seq_number OUT NOCOPY ghr_routing_list_members.seq_number%TYPE
89: ,p_next_user_name OUT NOCOPY ghr_routing_list_members.user_name%TYPE
159: --
160: PROCEDURE get_SF52_to_data_elements
161: (p_position_id IN hr_all_positions_f.position_id%TYPE
162: ,p_effective_date IN date default sysdate
163: ,p_prd IN ghr_pa_requests.pay_rate_determinant%TYPE
164: ,p_grade_id IN OUT NOCOPY number
165: ,p_job_id IN OUT NOCOPY number
166: ,p_organization_id IN OUT NOCOPY number
167: ,p_location_id IN OUT NOCOPY number
180:
181: -- This procedure only really needs to be called for realignment. For this NOA the 6 'address' lines seen
182: -- on the to side should come from the 'position organization' on the PAR extra info (if given)
183: --
184: PROCEDURE get_rei_org_lines (p_pa_request_id IN ghr_pa_requests.pa_request_id%TYPE
185: ,p_organization_id IN OUT NOCOPY VARCHAR2
186: ,p_position_org_line1 OUT NOCOPY varchar2
187: ,p_position_org_line2 OUT NOCOPY varchar2
188: ,p_position_org_line3 OUT NOCOPY varchar2
284: ,p_noa_family_code IN VARCHAR2
285: ,p_second_noa_family_code IN VARCHAR2)
286: RETURN VARCHAR2;
287: --
288: PROCEDURE get_corr_other_pay(p_pa_request_id IN ghr_pa_requests.pa_request_id%TYPE
289: ,p_noa_code IN ghr_nature_of_actions.code%TYPE
290: ,p_to_basic_pay OUT NOCOPY NUMBER
291: ,p_to_adj_basic_pay OUT NOCOPY NUMBER
292: ,p_to_auo_ppi OUT NOCOPY VARCHAR2
305: ,p_locality_adj OUT NOCOPY NUMBER
306: -- Corr Warn
307: );
308:
309: PROCEDURE get_corr_rpa_other_pay(p_pa_request_id IN ghr_pa_requests.pa_request_id%TYPE
310: ,p_noa_code IN ghr_nature_of_actions.code%TYPE
311: ,p_from_basic_pay OUT NOCOPY NUMBER
312: ,p_to_basic_pay OUT NOCOPY NUMBER
313: ,p_to_adj_basic_pay OUT NOCOPY NUMBER
332:
333: --
334: -- This procedure gets the amounts that are not displayed in a correction form that
335: -- are needed to do an award
336: PROCEDURE get_corr_award (p_pa_request_id IN ghr_pa_requests.pa_request_id%TYPE
337: ,p_noa_code IN ghr_nature_of_actions.code%TYPE
338: ,p_from_basic_pay OUT NOCOPY NUMBER
339: ,p_from_pay_basis OUT NOCOPY VARCHAR2
340: );
355: RETURN varchar2;
356: --
357: FUNCTION get_upd34_pay_basis (p_person_id IN per_people_f.person_id%TYPE
358: ,p_position_id IN per_positions.position_id%type
359: ,p_prd IN ghr_pa_requests.pay_rate_determinant%TYPE
360: ,p_noa_code IN varchar2 DEFAULT NULL
361: ,p_pa_request_id IN NUMBER DEFAULT NULL
362: ,p_effective_date IN DATE)
363: RETURN VARCHAR2;
367: ,p_date IN DATE
368: ,p_altered_pa_request_id in NUMBER);
369: --
370: --
371: FUNCTION temp_step_true (p_pa_request_id IN ghr_pa_requests.pa_request_id%type)
372: RETURN BOOLEAN;
373: --
374: --
375: END ghr_pa_requests_pkg;
371: FUNCTION temp_step_true (p_pa_request_id IN ghr_pa_requests.pa_request_id%type)
372: RETURN BOOLEAN;
373: --
374: --
375: END ghr_pa_requests_pkg;
376: