1 PACKAGE GHR_WGI_PKG AUTHID CURRENT_USER AS
2 /* $Header: ghwgipro.pkh 120.1.12010000.1 2008/07/28 10:41:42 appldev ship $ */
3
4 PROCEDURE GHR_WGI_PROCESS
5 (
6 errbuf out nocopy varchar2,
7 retcode out nocopy number,
8 p_personnel_office_id in
9 ghr_pa_requests.personnel_office_id%TYPE default null,
10 p_pay_plan in
11 ghr_pay_plans.pay_plan%TYPE default null
12 );
13 --
14 --
15 Procedure GHR_WGI_EMP (
16 p_effective_date in date default trunc(sysdate),
17 p_frequency in number default 90,
18 p_log_flag in char default 'N',
19 p_errbuf OUT nocopy varchar2,
20 p_retcode OUT nocopy number,
21 p_personnel_office_id in
22 ghr_pa_requests.personnel_office_id%TYPE default null,
23 p_pay_plan in ghr_pay_plans.pay_plan%TYPE
24 default null
25 );
26 --
27 --
28 procedure create_ghr_errorlog(
29 p_program_name in ghr_process_log.program_name%type,
30 p_log_text in ghr_process_log.log_text%type,
31 p_message_name in ghr_process_log.message_name%type,
32 p_log_date in ghr_process_log.log_date%type);
33 --
34 procedure get_noa_code_desc (
35 p_code in ghr_nature_of_actions.code%type,
36 p_effective_date in date default sysdate,
37 p_nature_of_action_id out nocopy ghr_nature_of_actions.nature_of_action_id%type,
38 p_description out nocopy ghr_nature_of_actions.description%type);
39 --
40 function Get_fnd_lookup_meaning (
41 p_lookup_type in hr_lookups.lookup_type%TYPE,
42 p_lookup_code in hr_lookups.lookup_code%TYPE,
43 p_effective_date in date default sysdate )
44 return hr_lookups.meaning%TYPE ;
45
46 --
47 -- Check assignment id
48 --
49 function check_assignment_prd
50 (p_pay_rate_determinant in ghr_pa_requests.pay_rate_determinant%TYPE
51 ) return boolean;
52 ----
53 -- Verify person in PA requests
54 --
55 function person_in_pa_requests(p_person_id in ghr_pa_requests.person_id%TYPE,
56 p_effective_date in ghr_pa_requests.effective_date%TYPE,
57 p_first_noa_code in ghr_pa_requests.first_noa_code%TYPE,
58 p_days in number )
59 return boolean;
60 --
61 function check_pay_plan( p_pay_plan in VARCHAR2)
62 return boolean;
63 --
64 -- This record structure will keep all the in parameters that are passed to the
65 -- WGI Custom Hook
66 TYPE wgi_in_rec_type IS RECORD
67 ( person_id per_people_f.person_id%type
68 ,assignment_id per_assignments.assignment_id%type
69 ,position_id per_assignments.position_id%type
70 ,effective_date ghr_pa_requests.effective_date%type
71 );
72 --
73 -- This record structure will keep all the out parameters that are passed from the
74 -- WGI Custom Hook
75 TYPE wgi_out_rec_type IS RECORD
76 (
77 process_person BOOLEAN
78 );
79 --
80 --
81 procedure derive_legal_auth_cd_remarks
82 (
83 p_first_noa_code in ghr_pa_requests.first_noa_code%TYPE,
84 p_pay_rate_determinant in ghr_pa_requests.pay_rate_determinant%TYPE,
85 p_from_pay_plan in ghr_pa_requests.from_pay_plan%TYPE,
86 p_grade_or_level in ghr_pa_requests.from_grade_or_level%TYPE,
87 p_step_or_rate in ghr_pa_requests.from_step_or_rate%TYPE,
88 p_retained_pay_plan in ghr_pa_requests.from_pay_plan%TYPE default null,
89 p_retained_grade_or_level in ghr_pa_requests.from_grade_or_level%TYPE default null,
90 p_retained_step_or_rate in ghr_pa_requests.from_step_or_rate%TYPE default null,
91 -- Bug#5204589
92 p_temp_step in ghr_pa_requests.from_step_or_rate%TYPE default null,
93 p_effective_date in ghr_pa_requests.effective_date%TYPE,
94 p_first_action_la_code1 in out nocopy ghr_pa_requests.first_action_la_code1%TYPE,
95 p_first_action_la_desc1 in out nocopy ghr_pa_requests.first_action_la_desc1%TYPE,
96 p_first_action_la_code2 in out nocopy ghr_pa_requests.first_action_la_code2%TYPE,
97 p_first_action_la_desc2 in out nocopy ghr_pa_requests.first_action_la_desc2%TYPE,
98 p_remark_id1 out nocopy ghr_pa_remarks.remark_id%TYPE,
99 p_remark_desc1 out nocopy ghr_pa_remarks.description%type,
100 p_remark1_info1 out nocopy ghr_pa_remarks.remark_code_information1%TYPE,
101 p_remark1_info2 out nocopy ghr_pa_remarks.remark_code_information2%TYPE,
102 p_remark1_info3 out nocopy ghr_pa_remarks.remark_code_information3%TYPE,
103 p_remark_id2 out nocopy ghr_pa_remarks.remark_id%TYPE,
104 p_remark_desc2 out nocopy ghr_pa_remarks.description%type,
105 p_remark2_info1 out nocopy ghr_pa_remarks.remark_code_information1%TYPE,
106 p_remark2_info2 out nocopy ghr_pa_remarks.remark_code_information2%TYPE,
107 p_remark2_info3 out nocopy ghr_pa_remarks.remark_code_information3%TYPE
108 );
109
110 --
111 function CheckIfFWPayPlan( p_from_pay_plan in ghr_pa_requests.from_pay_plan%TYPE
112 )
113 return boolean;
114 --
115 --
116 function CheckPayPlanParm (
117 p_in_pay_plan in ghr_pa_requests.from_pay_plan%TYPE
118 ,p_from_pay_plan in ghr_pa_requests.from_pay_plan%TYPE
119 )
120 return boolean;
121 --
122 --
123 function CheckPOIParm (
124 p_in_personnel_office_id in out NOCOPY ghr_pa_requests.personnel_office_id%TYPE
125 ,p_position_id in per_assignments.position_id%TYPE
126 ,p_effective_date in ghr_pa_requests.effective_date%TYPE
127 )
128 return boolean ;
129 --
130 --
131 function CheckIfMaxPayPlan( p_from_pay_plan in ghr_pa_requests.from_pay_plan%TYPE
132 ,p_from_step_or_rate in ghr_pa_requests.from_step_or_rate%TYPE
133 )
134 return boolean ;
135 --
136 --
137
138 FUNCTION ret_wgi_pay_date (
139 p_assignment_id IN per_all_assignments_f.assignment_id%type,
140 p_effective_date IN per_all_assignments_f.effective_start_date%type ,
141 p_frequency IN NUMBER
142 )
143 RETURN VARCHAR2;
144
145 end GHR_WGI_PKG;
146