[Home] [Help]
PACKAGE: APPS.PAY_IN_SOE_PKG
Source
1 PACKAGE pay_in_soe_pkg AUTHID CURRENT_USER AS
2 /* $Header: pyinsoer.pkh 120.0.12010000.1 2008/07/27 22:54:34 appldev ship $ */
3
4 --------------------------------------------------------------------------
5 -- --
6 -- Name : GET_EMPLOYEE --
7 -- Type : FUNCTION --
8 -- Access : Public --
9 -- Description : Function to return SQL for Personal Information --
10 -- Region --
11 -- --
12 -- Parameters : --
13 -- IN : p_assignment_action_id NUMBER --
14 -- --
15 --------------------------------------------------------------------------
16 FUNCTION get_employee(p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE)
17 RETURN LONG;
18
19 --------------------------------------------------------------------------
20 -- --
21 -- Name : GET_FUR_PERSON_INFO --
22 -- Type : FUNCTION --
23 -- Access : Public --
24 -- Description : Function to return SQL for Further Person --
25 -- Information Region --
26 -- --
27 -- Parameters : --
28 -- IN : p_assignment_action_id NUMBER --
29 -- --
30 --------------------------------------------------------------------------
31 FUNCTION get_fur_person_info(p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE)
32 RETURN LONG;
33
34 --------------------------------------------------------------------------
35 -- --
36 -- Name : GET_PERIOD --
37 -- Type : FUNCTION --
38 -- Access : Public --
39 -- Description : Function to return SQL for Payroll Processing --
40 -- Information Region --
41 -- --
42 -- Parameters : --
43 -- IN : p_assignment_action_id NUMBER --
44 -- --
45 --------------------------------------------------------------------------
46 FUNCTION get_period(p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE)
47 RETURN LONG;
48
49 --------------------------------------------------------------------------
50 -- --
51 -- Name : GET_TAXABLE_EARNINGS --
52 -- Type : FUNCTION --
53 -- Access : Public --
54 -- Description : Function to return SQL for Earnings Region --
55 -- --
56 -- Parameters : --
57 -- IN : p_assignment_action_id NUMBER --
58 -- --
59 --------------------------------------------------------------------------
60 FUNCTION get_earnings(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
61 RETURN LONG;
62
63 --------------------------------------------------------------------------
64 -- --
65 -- Name : GET_DEDUCTIONS --
66 -- Type : FUNCTION --
67 -- Access : Public --
68 -- Description : Function to return SQL for Statutory Deductions --
69 -- Region --
70 -- --
71 -- Parameters : --
72 -- IN : p_assignment_action_id NUMBER --
73 -- --
74 --------------------------------------------------------------------------
75 FUNCTION get_deductions(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
76 RETURN LONG;
77
78 --------------------------------------------------------------------------
79 -- --
80 -- Name : GET_ADVANCES --
81 -- Type : FUNCTION --
82 -- Access : Public --
83 -- Description : Function to return SQL for Non Taxable Earnings --
84 -- Region --
85 -- --
86 -- Parameters : --
87 -- IN : p_assignment_action_id NUMBER --
88 -- --
89 --------------------------------------------------------------------------
90 FUNCTION get_advances(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
91 RETURN LONG;
92
93 --------------------------------------------------------------------------
94 -- --
95 -- Name : GET_FRINGE_BENEFITS --
96 -- Type : FUNCTION --
97 -- Access : Public --
98 -- Description : Function to return SQL for Voluntary Deductions --
99 -- Region --
100 -- --
101 -- Parameters : --
102 -- IN : p_assignment_action_id NUMBER --
103 -- --
104 --------------------------------------------------------------------------
105 FUNCTION get_fringe_benefits(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
106 RETURN LONG;
107
108 --------------------------------------------------------------------------
109 -- --
110 -- Name : GET_PERQUISITES --
111 -- Type : FUNCTION --
112 -- Access : Public --
113 -- Description : Function to return SQL for Perquisites --
114 -- Region --
115 -- --
116 -- Parameters : --
117 -- IN : p_assignment_action_id NUMBER --
118 -- --
119 --------------------------------------------------------------------------
120 FUNCTION get_perquisites(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
121 RETURN LONG;
122
123 --------------------------------------------------------------------------
124 -- --
125 -- Name : GET_EMPLOYER_CHARGES --
126 -- Type : FUNCTION --
127 -- Access : Public --
128 -- Description : Function to return SQL for Employer Charges --
129 -- Region --
130 -- --
131 -- Parameters : --
132 -- IN : p_assignment_action_id NUMBER --
133 -- --
134 --------------------------------------------------------------------------
135 FUNCTION get_employer_charges(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
136 RETURN LONG;
137
138 --------------------------------------------------------------------------
139 -- --
140 -- Name : GET_TERM_PAYMENTS --
141 -- Type : FUNCTION --
142 -- Access : Public --
143 -- Description : Function to return SQL for Termination Payments --
144 -- Region --
145 -- --
146 -- Parameters : --
147 -- IN : p_assignment_action_id NUMBER --
148 -- --
149 --------------------------------------------------------------------------
150 FUNCTION get_term_payments(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
151 RETURN LONG;
152
153 --------------------------------------------------------------------------
154 -- --
155 -- Name : GET_BALANCES --
156 -- Type : FUNCTION --
157 -- Access : Public --
158 -- Description : Function to return SQL for Balances Region --
159 -- --
160 -- Parameters : --
161 -- IN : p_assignment_action_id NUMBER --
162 -- --
163 --------------------------------------------------------------------------
164 FUNCTION get_balances( p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE)
165 RETURN LONG;
166
167 --------------------------------------------------------------------------
168 -- --
169 -- Name : GET_PAYMENT_METHODS --
170 -- Type : FUNCTION --
171 -- Access : Public --
172 -- Description : Function to return SQL for Payments Method Region --
173 -- --
174 -- Parameters : --
175 -- IN : p_assignment_action_id NUMBER --
176 -- --
177 --------------------------------------------------------------------------
178 FUNCTION get_payment_details(p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE)
179 RETURN LONG;
180
181 --------------------------------------------------------------------------
182 -- --
183 -- Name : GET_OTHER_ELEMENT_INFORMATION --
184 -- Type : FUNCTION --
185 -- Access : Public --
186 -- Description : Function to return SQL for Other Element --
190 -- IN : p_assignment_action_id NUMBER --
187 -- Information Region --
188 -- --
189 -- Parameters : --
191 -- --
192 --------------------------------------------------------------------------
193 FUNCTION get_other_element_information(p_assignment_action_id IN OUT NOCOPY pay_assignment_actions.assignment_action_id%TYPE)
194 RETURN LONG;
195
196 --------------------------------------------------------------------------
197 -- --
198 -- Name : GET_OTHER_BALANCE_INFORMATION --
199 -- Type : FUNCTION --
200 -- Access : Public --
201 -- Description : Function to return SQL for Other Balance --
202 -- Information Region --
203 -- --
204 -- Parameters : --
205 -- IN : p_assignment_action_id NUMBER --
206 -- --
207 --------------------------------------------------------------------------
208 FUNCTION get_other_balance_information(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
209 RETURN LONG;
210
211 --------------------------------------------------------------------------
212 -- --
213 -- Name : GET_ANNUAL_LEAVE_INFORMATION --
214 -- Type : FUNCTION --
215 -- Access : Public --
216 -- Description : Function to return SQL for Annual Leave --
217 -- Information Region --
218 -- --
219 -- Parameters : --
220 -- IN : p_assignment_action_id NUMBER --
221 -- --
222 --------------------------------------------------------------------------
223 FUNCTION get_annual_leave_information(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
224 RETURN LONG;
225
226 --------------------------------------------------------------------------
227 -- --
228 -- Name : GET_LEAVE_TAKEN --
229 -- Type : FUNCTION --
230 -- Access : Public --
231 -- Description : Function to return SQL for Leave Taken Region --
232 -- --
233 -- Parameters : --
234 -- IN : p_assignment_action_id NUMBER --
235 -- --
236 --------------------------------------------------------------------------
237 FUNCTION get_leave_taken(p_assignment_action_id IN OUT NOCOPY pay_assignment_actions.assignment_action_id%TYPE)
238 RETURN LONG;
239
240 --------------------------------------------------------------------------
241 -- --
242 -- Name : GET_MESSAGES --
243 -- Type : FUNCTION --
244 -- Access : Public --
245 -- Description : Function to return SQL for Messages Region --
246 -- --
247 -- Parameters : --
248 -- IN : p_assignment_action_id NUMBER --
249 -- --
250 --------------------------------------------------------------------------
251 FUNCTION get_messages(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
252 RETURN LONG;
253
254 END pay_in_soe_pkg;