[Home] [Help]
PACKAGE: APPS.PAY_IN_TERMINATION_PKG
Source
1 PACKAGE pay_in_termination_pkg AS
2 /* $Header: pyinterm.pkh 120.0.12000000.3 2007/04/24 09:55:54 rsaharay noship $ */
3 g_leaving_reason per_periods_of_service.leaving_reason%TYPE;
4 --------------------------------------------------------------------------
5 -- --
6 -- Name : CREATE_TERMINATION_ELEMENTS --
7 -- Type : PROCEDURE --
8 -- Access : Public --
9 -- Description : Procedure to handle creation of Termination EE for --
10 -- terminated employee based on conditions as required --
11 -- for India Localization. --
12 -- --
13 -- Parameters : --
14 -- IN : p_period_of_service_id NUMBER --
15 -- p_business_group_id NUMBER --
16 -- p_actual_termination_date DATE --
17 -- p_calling_procedure VARCHAR2 --
18 -- OUT : p_message_name VARCHAR2 --
19 -- p_token_name pay_in_utils.char_tab_type--
20 -- p_token_value pay_in_utils.char_tab_type--
21 --------------------------------------------------------------------------
22 PROCEDURE create_termination_elements
23 (p_period_of_service_id IN NUMBER
24 ,p_business_group_id IN NUMBER
25 ,p_actual_termination_date IN DATE
26 ,p_calling_procedure IN VARCHAR2
27 ,p_message_name OUT NOCOPY VARCHAR2
28 ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type
29 ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type
30 );
31
32 --------------------------------------------------------------------------
33 -- --
34 -- Name : DELETE_TERMINATION_ELEMENTS --
35 -- Type : Procedure --
36 -- Access : Public --
37 -- Description : Procedure to delete all Termination Element entries --
38 -- if termination is reversed for the employee. --
39 -- --
40 -- Parameters : --
41 -- IN : p_period_of_service_id NUMBER --
42 -- p_business_group_id NUMBER --
43 -- p_actual_termination_date DATE --
44 -- p_calling_procedure VARCHAR2 --
45 -- OUT : p_message_name VARCHAR2 --
46 -- p_token_name pay_in_utils.char_tab_type--
47 -- p_token_value pay_in_utils.char_tab_type--
48 --------------------------------------------------------------------------
49 PROCEDURE delete_termination_elements
50 (p_period_of_service_id IN NUMBER
51 ,p_business_group_id IN NUMBER
52 ,p_actual_termination_date IN DATE
53 ,p_calling_procedure IN VARCHAR2
54 ,p_message_name OUT NOCOPY VARCHAR2
55 ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type
56 ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type
57 );
58
59 --------------------------------------------------------------------------
60 -- --
61 -- Name : YEARS_OF_SERVICE --
62 -- Type : FUNCTION --
63 -- Access : Private --
64 -- Description : Function to return the number of years of service --
65 -- for a terminated employee. --
66 -- --
67 -- Parameters : --
68 -- IN : p_start_date DATE --
69 -- p_end_date DATE --
70 -- p_flag VARCHAR2 --
71 -- --
72 --------------------------------------------------------------------------
73 FUNCTION years_of_service(p_start_date IN DATE
74 ,p_end_date IN DATE
75 ,p_flag IN VARCHAR2
76 )
77 RETURN NUMBER;
78
79 --------------------------------------------------------------------------
80 -- --
81 -- Name : GET_AVERAGE_SALARY --
82 -- Type : FUNCTION --
83 -- Access : Public --
84 -- Description : Function to return average salary for a duration --
85 -- --
86 -- Parameters : --
87 -- IN : p_assignment_id NUMBER --
88 -- p_assignment_action_id NUMBER --
89 -- p_payroll_id NUMBER --
90 -- p_balance_name VARCHAR2 --
91 -- p_end_date DATE --
92 -- p_duration NUMBER --
93 -- --
94 --------------------------------------------------------------------------
95 FUNCTION get_average_salary
96 (p_assignment_id IN NUMBER
97 ,p_assignment_action_id IN NUMBER
98 ,p_payroll_id IN NUMBER
99 ,p_balance_name IN VARCHAR2
100 ,p_end_date IN DATE
101 ,p_duration IN NUMBER
102 )
103 RETURN NUMBER;
104
105 --------------------------------------------------------------------------
106 -- Name : check_notice_period --
107 -- Type : Procedure --
108 -- Access : Public --
109 -- Description : Internal Proc to be called for validation --
110 -- Parameters : --
111 -- IN : p_organization_id NUMBER --
112 -- p_org_info_type_code VARCHAR2 --
113 -- p_emp_category VARCHAR2 --
114 -- p_notice_period VARCHAR2 --
115 -- p_calling_procedure VARCHAR2 --
116 -- OUT : p_message_name VARCHAR2 --
117 -- p_token_name pay_in_utils.char_tab_type --
118 -- p_token_value pay_in_utils.char_tab_type --
119 --------------------------------------------------------------------------
120 PROCEDURE check_notice_period
121 (p_organization_id IN NUMBER
122 ,p_org_information_id IN NUMBER
123 ,p_org_info_type_code IN VARCHAR2
124 ,p_emp_category IN VARCHAR2
125 ,p_notice_period IN VARCHAR2
126 ,p_calling_procedure IN VARCHAR2
127 ,p_message_name OUT NOCOPY VARCHAR2
128 ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type
129 ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type);
130
131 --------------------------------------------------------------------------
132 -- --
133 -- Name : CHECK_GRATUITY --
134 -- Type : PROCEDURE --
135 -- Access : Public --
136 -- Description : Procedure to validate gratuity as required for India--
137 -- Localization. --
138 -- --
139 -- Parameters : --
140 -- IN : p_element_entry_id NUMBER --
141 -- p_effective_date DATE --
142 -- p_calling_procedure VARCHAR2 --
143 -- OUT : p_message_name VARCHAR2 --
144 -- p_token_name pay_in_utils.char_tab_type--
145 -- p_token_value pay_in_utils.char_tab_type--
146 --------------------------------------------------------------------------
147 PROCEDURE check_gratuity
148 (p_element_entry_id IN NUMBER
149 ,p_effective_date IN DATE
150 ,p_calling_procedure IN VARCHAR2
151 ,p_message_name OUT NOCOPY VARCHAR2
152 ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type
153 ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type);
154
155 --------------------------------------------------------------------------
156 -- --
157 -- Name : CREATE_GRATUITY_ENTRY --
158 -- Type : PROCEDURE --
159 -- Access : Public --
160 -- Description : Procedure to handle creation of Gratuity entry for --
161 -- terminated employee based on conditions as required --
162 -- for India Localization. --
163 -- --
164 -- Parameters : --
165 -- IN : p_period_of_service_id NUMBER --
166 -- p_business_group_id NUMBER --
167 -- p_actual_termination_date DATE --
168 -- p_calling_procedure VARCHAR2 --
169 -- OUT : p_message_name VARCHAR2 --
170 -- p_token_name pay_in_utils.char_tab_type--
171 -- p_token_value pay_in_utils.char_tab_type--
172 -- Change History : --
173 --------------------------------------------------------------------------
174 -- Rev# Date Userid Description --
175 --------------------------------------------------------------------------
176 -- 1.0 19-OCT-04 statkar Created this procedure --
177 --------------------------------------------------------------------------
178 PROCEDURE create_gratuity_entry
179 (p_period_of_service_id IN NUMBER
180 ,p_business_group_id IN NUMBER
181 ,p_actual_termination_date IN DATE
182 ,p_calling_procedure IN VARCHAR2
183 ,p_message_name OUT NOCOPY VARCHAR2
184 ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type
185 ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type
186 );
187
188 --------------------------------------------------------------------------
189 -- --
190 -- Name : DELETE_GRATUITY_ENTRY --
191 -- Type : Procedure --
192 -- Access : Public --
193 -- Description : Procedure to delete 'Gratuity Information' Entry --
194 -- if termination is reversed for the employee. --
195 -- --
196 -- Parameters : --
197 -- IN : p_period_of_service_id NUMBER --
198 -- p_business_group_id NUMBER --
199 -- p_actual_termination_date DATE --
200 -- p_calling_procedure VARCHAR2 --
201 -- OUT : p_message_name VARCHAR2 --
202 -- p_token_name pay_in_utils.char_tab_type--
203 -- p_token_value pay_in_utils.char_tab_type--
204 -- Change History : --
205 --------------------------------------------------------------------------
206 -- Rev# Date Userid Description --
207 --------------------------------------------------------------------------
208 -- 1.0 19-OCT-04 statkar Created this procedure --
209 --------------------------------------------------------------------------
210 PROCEDURE delete_gratuity_entry
211 (p_period_of_service_id IN NUMBER
212 ,p_business_group_id IN NUMBER
213 ,p_actual_termination_date IN DATE
214 ,p_calling_procedure IN VARCHAR2
215 ,p_message_name OUT NOCOPY VARCHAR2
216 ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type
217 ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type
218 ) ;
219
220 --------------------------------------------------------------------------
221 -- --
222 -- Name : get_value_on_termination --
223 -- Type : FUNCTION --
224 -- Access : Public --
225 -- Description : Function to return balance value as of the --
226 -- termination month. --
227 -- --
228 -- Parameters : --
229 -- IN : p_assignment_id NUMBER --
230 -- p_end_date DATE --
231 -- p_balance_name VARCHAR2 --
232 -- p_dimension_name VARCHAR2 --
233 -- --
234 -- Change History : --
235 --------------------------------------------------------------------------
236 -- Rev# Date Userid Description --
237 --------------------------------------------------------------------------
238 -- 1.0 06-Jan-05 lnagaraj Created this function --
239 --------------------------------------------------------------------------
240
241 FUNCTION get_value_on_termination
242 (p_assignment_id IN NUMBER
243 ,p_end_date IN DATE
244 ,p_balance_name IN VARCHAR2
245 ,p_dimension_name IN VARCHAR2
246 )
247 RETURN NUMBER;
248
249 --
250
251 END pay_in_termination_pkg;