[Home] [Help]
1: PACKAGE ghr_pa_requests_pkg AUTHID CURRENT_USER AS
2: /* $Header: ghparqst.pkh 120.5.12020000.2 2012/07/05 14:41:21 amnaraya ship $ */
3:
4: PROCEDURE get_process_method(
5: p_noa_family_code IN ghr_noa_fam_proc_methods.noa_family_code%TYPE
129: ,p_personnelist_flag IN OUT NOCOPY VARCHAR2
130: ,p_approver_flag IN OUT NOCOPY VARCHAR2
131: ,p_reviewer_flag IN OUT NOCOPY VARCHAR2);
132: --
133: PROCEDURE get_last_routing_list(p_pa_request_id IN ghr_pa_requests.pa_request_id%TYPE
134: ,p_routing_list_id OUT NOCOPY ghr_routing_lists.routing_list_id%TYPE
135: ,p_routing_list_name OUT NOCOPY ghr_routing_lists.name%TYPE
136: ,p_next_seq_number OUT NOCOPY ghr_routing_list_members.seq_number%TYPE
137: ,p_next_user_name OUT NOCOPY ghr_routing_list_members.user_name%TYPE
207: --
208: PROCEDURE get_SF52_to_data_elements
209: (p_position_id IN hr_all_positions_f.position_id%TYPE
210: ,p_effective_date IN date default sysdate
211: ,p_prd IN ghr_pa_requests.pay_rate_determinant%TYPE
212: ,p_grade_id IN OUT NOCOPY number
213: ,p_job_id IN OUT NOCOPY number
214: ,p_organization_id IN OUT NOCOPY number
215: ,p_location_id IN OUT NOCOPY number
228:
229: -- This procedure only really needs to be called for realignment. For this NOA the 6 'address' lines seen
230: -- on the to side should come from the 'position organization' on the PAR extra info (if given)
231: --
232: PROCEDURE get_rei_org_lines (p_pa_request_id IN ghr_pa_requests.pa_request_id%TYPE
233: ,p_organization_id IN OUT NOCOPY VARCHAR2
234: ,p_position_org_line1 OUT NOCOPY varchar2
235: ,p_position_org_line2 OUT NOCOPY varchar2
236: ,p_position_org_line3 OUT NOCOPY varchar2
332: ,p_noa_family_code IN VARCHAR2
333: ,p_second_noa_family_code IN VARCHAR2)
334: RETURN VARCHAR2;
335: --
336: PROCEDURE get_corr_other_pay(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_to_basic_pay OUT NOCOPY NUMBER
339: ,p_to_adj_basic_pay OUT NOCOPY NUMBER
340: ,p_to_auo_ppi OUT NOCOPY VARCHAR2
353: ,p_locality_adj OUT NOCOPY NUMBER
354: -- Corr Warn
355: );
356:
357: PROCEDURE get_corr_rpa_other_pay(p_pa_request_id IN ghr_pa_requests.pa_request_id%TYPE
358: ,p_noa_code IN ghr_nature_of_actions.code%TYPE
359: ,p_from_basic_pay OUT NOCOPY NUMBER
360: ,p_to_basic_pay OUT NOCOPY NUMBER
361: ,p_to_adj_basic_pay OUT NOCOPY NUMBER
380:
381: --
382: -- This procedure gets the amounts that are not displayed in a correction form that
383: -- are needed to do an award
384: PROCEDURE get_corr_award (p_pa_request_id IN ghr_pa_requests.pa_request_id%TYPE
385: ,p_noa_code IN ghr_nature_of_actions.code%TYPE
386: ,p_from_basic_pay OUT NOCOPY NUMBER
387: ,p_from_pay_basis OUT NOCOPY VARCHAR2
388: );
403: RETURN varchar2;
404: --
405: FUNCTION get_upd34_pay_basis (p_person_id IN per_people_f.person_id%TYPE
406: ,p_position_id IN per_positions.position_id%type
407: ,p_prd IN ghr_pa_requests.pay_rate_determinant%TYPE
408: ,p_noa_code IN varchar2 DEFAULT NULL
409: ,p_pa_request_id IN NUMBER DEFAULT NULL
410: ,p_effective_date IN DATE)
411: RETURN VARCHAR2;
415: ,p_date IN DATE
416: ,p_altered_pa_request_id in NUMBER);
417: --
418: --
419: FUNCTION temp_step_true (p_pa_request_id IN ghr_pa_requests.pa_request_id%type)
420: RETURN BOOLEAN;
421: --
422: --
423: END ghr_pa_requests_pkg;
419: FUNCTION temp_step_true (p_pa_request_id IN ghr_pa_requests.pa_request_id%type)
420: RETURN BOOLEAN;
421: --
422: --
423: END ghr_pa_requests_pkg;
424: