[Home] [Help]
PACKAGE BODY: APPS.PAY_AU_TERMINATIONS_ENTRY_API
Source
1 PACKAGE BODY pay_au_terminations_entry_api AS
2 /* $Header: pyautapi.pkb 120.3.12000000.4 2007/09/06 06:41:30 priupadh ship $
3 **
4 ** Copyright (c) 1999 Oracle Corporation
5 ** All Rights Reserved
6 **
7 ** Procedures and functions used in AU terminations entry form
8 **
9 ** Change List
10 ** ===========
11 **
12 ** Date Author Reference Description
13 ** =========================================================
14 ** 15-NOV-2000 JMHATRE 115.0 Created for AU
15 ** 05-MAR-2002 JKAROUZA 115.1 2246310 Added new parameter
16 ** p_override_user_ent_chk in calls
17 ** to py_element_entry_api.
18 ** 22-MAR-2002 JKAROUZA 115.2 Added SET VERIFY OFF.
19 ** 04-DEC-2002 Ragovind 115.3 Added NOCOPY for the functions update_al_element_entry, update_etp_element_entry
20 ** ,update_lsl_element_entry,update_super_element_entry
21 **
22 ** 15-May-2003 Ragovind 115.4 Added new parameteres to the procedure update
23 _etp_element_entry for ETP pre/post enhancement.
24 **
25 ** 18-May-2003 Ragovind 115.5 Added Bug Reference - Bug#2819479.
26 ** 09-MAr-2006 hnainani 115.6 Bug# 5080026 - 2 new parameters for update_al_element_entry
27 ** 26-Jun-2006 hnainani 115.7 Added new parameters for update_lsl_element_entry
28 ** 09-MAY-2007 priupadh 115.10 5956223 Added New Parameters to update_etp_element_entry
29 ** 04-Sep-2007 priupadh 115.11 6192381 Added New Parameters to update_super_element_entry
30 ** Wrappers for updating the element entries through the
31 ** Terminations form.
32 **
33 */
34 ---------------------------------------------------------------------------------------
35
36 PROCEDURE update_al_element_entry
37 (p_dt_update_mode IN VARCHAR2
38 ,p_session_date IN DATE
39 ,p_business_group_id IN NUMBER
40 ,p_element_entry_id IN NUMBER
41 ,p_object_version_number IN OUT NOCOPY NUMBER
42 ,p_hours_input_value_id IN NUMBER
43 ,p_payment_input_value_id IN NUMBER
44 ,p_loading_input_value_id IN NUMBER
45 ,p_other_input_value_id IN NUMBER
46 ,p_hours_entry_value IN VARCHAR2
47 ,p_payment_entry_value IN VARCHAR2
48 ,p_loading_entry_value IN VARCHAR2
49 ,p_other_entry_value IN VARCHAR2
50 ,p_effective_start_date IN OUT NOCOPY DATE
51 ,p_effective_end_date IN OUT NOCOPY DATE
52 ,p_update_warning OUT NOCOPY BOOLEAN) IS
53 BEGIN
54 py_element_entry_api.update_element_entry
55 (p_datetrack_update_mode => P_dt_update_mode
56 ,p_effective_date => P_session_date
57 ,p_business_group_id => P_business_group_id
58 ,p_element_entry_id => P_element_entry_id
59 ,p_object_version_number => P_object_version_number
60 ,p_input_value_id1 => P_hours_input_value_id
61 ,p_input_value_id2 => p_payment_input_value_id
62 ,p_input_value_id3 => p_loading_input_value_id
63 ,p_input_value_id4 => p_other_input_value_id
64 ,p_entry_value1 => p_hours_entry_value
65 ,p_entry_value2 => p_payment_entry_value
66 ,p_entry_value3 => p_loading_entry_value
67 ,p_entry_value4 => p_other_entry_value
68 ,p_effective_start_date => p_effective_start_date
69 ,p_effective_end_date => p_effective_end_date
70 ,p_override_user_ent_chk => 'Y'
71 ,p_update_warning => p_update_warning);
72
73 END update_al_element_entry;
74
75
76 PROCEDURE update_lsl_element_entry
77 (p_dt_update_mode IN VARCHAR2
78 ,p_session_date IN DATE
79 ,p_business_group_id IN NUMBER
80 ,p_element_entry_id IN NUMBER
81 ,p_object_version_number IN OUT NOCOPY NUMBER
82 ,p_pre78_pay_input_value_id IN NUMBER
83 ,p_post78_pay_input_value_id IN NUMBER
84 ,p_post93_pay_input_value_id IN NUMBER
85 ,p_pre78_hours_input_value_id IN NUMBER
86 ,p_post78_hours_input_value_id IN NUMBER
87 ,p_post93_hours_input_value_id IN NUMBER
88 ,p_override_elig_input_value_id IN NUMBER /*Bug# 5056831 */
89 ,p_pre78_pay_entry_value IN VARCHAR2
90 ,p_post78_pay_entry_value IN VARCHAR2
91 ,p_post93_pay_entry_value IN VARCHAR2
92 ,p_pre78_hours_entry_value IN VARCHAR2
93 ,p_post78_hours_entry_value IN VARCHAR2
94 ,p_post93_hours_entry_value IN VARCHAR2
95 ,p_override_elig_entry_value IN VARCHAR2 /*Bug# 5056831 */
96 ,p_effective_start_date IN OUT NOCOPY DATE
97 ,p_effective_end_date IN OUT NOCOPY DATE
98 ,p_update_warning OUT NOCOPY BOOLEAN) IS
99 BEGIN
100
101
102 py_element_entry_api.update_element_entry
103 (p_datetrack_update_mode => p_dt_update_mode
104 ,p_effective_date => p_session_date
105 ,p_business_group_id => p_business_group_id
106 ,p_element_entry_id => p_element_entry_id
107 ,p_object_version_number => p_object_version_number
108 ,p_input_value_id1 => p_pre78_pay_input_value_id
109 ,p_input_value_id2 => p_post78_pay_input_value_id
110 ,p_input_value_id3 => p_post93_pay_input_value_id
111 ,p_input_value_id4 => p_pre78_hours_input_value_id
112 ,p_input_value_id5 => p_post78_hours_input_value_id
113 ,p_input_value_id6 => p_post93_hours_input_value_id
114 ,p_input_value_id7 => p_override_elig_input_value_id /*Bug# 5056831 */
115 ,p_entry_value1 => p_pre78_pay_entry_value
116 ,p_entry_value2 => p_post78_pay_entry_value
117 ,p_entry_value3 => p_post93_pay_entry_value
118 ,p_entry_value4 => p_pre78_hours_entry_value
119 ,p_entry_value5 => p_post78_hours_entry_value
120 ,p_entry_value6 => p_post93_hours_entry_value
121 ,p_entry_value7 => p_override_elig_entry_value /*Bug# 5056831 */
122 ,p_effective_start_date => p_effective_start_date
123 ,p_effective_end_date => p_effective_end_date
124 ,p_override_user_ent_chk => 'Y'
125 ,p_update_warning => p_update_warning);
126
127 END update_lsl_element_entry;
128
129 /* Added new parameters for update_etp_element_entry for Bug#2819479 */
130 PROCEDURE update_etp_element_entry(p_dt_update_mode IN VARCHAR2
131 ,p_session_date IN DATE
132 ,p_business_group_id IN NUMBER
133 ,p_element_entry_id IN NUMBER
134 ,p_object_version_number IN OUT NOCOPY NUMBER
135 ,p_redundancy_input_value_id IN NUMBER
136 ,p_pay_etp_input_value_id IN NUMBER
137 ,p_golden_input_value_id IN NUMBER
138 ,p_lieu_input_value_id IN NUMBER
139 ,p_sick_input_value_id IN NUMBER
140 ,p_rdo_input_value_id IN NUMBER
141 ,p_other_input_value_id IN NUMBER
142 ,p_pre_1983_input_value_id IN NUMBER
143 ,p_post_1983_input_value_id IN NUMBER
144 ,p_etp_cs_date_input_value_id IN NUMBER
145 ,p_trans_etp_input_value_id IN NUMBER /*5956223*/
146 ,p_part_prev_etp_input_value_id IN NUMBER /*5956223*/
147 ,p_redundancy_entry_value IN VARCHAR2
148 ,p_pay_etp_entry_value IN VARCHAR2
149 ,p_golden_entry_value IN VARCHAR2
150 ,p_lieu_entry_value IN VARCHAR2
151 ,p_sick_entry_value IN VARCHAR2
152 ,p_rdo_entry_value IN VARCHAR2
153 ,p_other_entry_value IN VARCHAR2
154 ,p_pre_1983_entry_value IN VARCHAR2
155 ,p_post_1983_entry_value IN VARCHAR2
156 ,p_etp_cs_date_entry_value IN VARCHAR2
157 ,p_trans_etp_entry_value IN VARCHAR2 /*5956223 */
158 ,p_part_of_prev_etp_entry_value IN VARCHAR2 /*5956223*/
159 ,p_effective_start_date IN OUT NOCOPY DATE
160 ,p_effective_end_date IN OUT NOCOPY DATE
161 ,p_update_warning OUT NOCOPY BOOLEAN) IS
162 BEGIN
163
164 py_element_entry_api.update_element_entry
165 (p_datetrack_update_mode => p_dt_update_mode
166 ,p_effective_date => p_session_date
167 ,p_business_group_id => p_business_group_id
168 ,p_element_entry_id => p_element_entry_id
169 ,p_object_version_number => p_object_version_number
170 ,p_input_value_id1 => p_redundancy_input_value_id
171 ,p_input_value_id2 => p_pay_etp_input_value_id
172 ,p_input_value_id3 => p_golden_input_value_id
173 ,p_input_value_id4 => p_lieu_input_value_id
174 ,p_input_value_id5 => p_sick_input_value_id
175 ,p_input_value_id6 => p_rdo_input_value_id
176 ,p_input_value_id7 => p_other_input_value_id
177 ,p_input_value_id8 => p_pre_1983_input_value_id
178 ,p_input_value_id9 => p_post_1983_input_value_id
179 ,p_input_value_id10 => p_etp_cs_date_input_value_id
180 ,p_input_value_id11 => p_trans_etp_input_value_id /*5956223 */
181 ,p_input_value_id12 => p_part_prev_etp_input_value_id /*5956223 */
182 ,p_entry_value1 => p_redundancy_entry_value
183 ,p_entry_value2 => p_pay_etp_entry_value
184 ,p_entry_value3 => p_golden_entry_value
185 ,p_entry_value4 => p_lieu_entry_value
186 ,p_entry_value5 => p_sick_entry_value
187 ,p_entry_value6 => p_rdo_entry_value
188 ,p_entry_value7 => p_other_entry_value
189 ,p_entry_value8 => p_pre_1983_entry_value
190 ,p_entry_value9 => p_post_1983_entry_value
191 ,p_entry_value10 => p_etp_cs_date_entry_value
192 ,p_entry_value11 => p_trans_etp_entry_value /*5956223 */
193 ,p_entry_value12 => p_part_of_prev_etp_entry_value /*5956223 */
194 ,p_effective_start_date => p_effective_start_date
195 ,p_effective_end_date => p_effective_end_date
196 ,p_override_user_ent_chk => 'Y'
197 ,p_update_warning => p_update_warning);
198
199 END update_etp_element_entry;
200
201 PROCEDURE update_super_element_entry
202 (p_dt_update_mode IN VARCHAR2
203 ,p_session_date IN DATE
204 ,p_business_group_id IN NUMBER
205 ,p_element_entry_id IN NUMBER
206 ,p_object_version_number IN OUT NOCOPY NUMBER
207 ,p_amount_input_value_id IN NUMBER
208 ,p_amount_entry_value IN VARCHAR2
209 ,p_amount_ppetp_input_value_id IN NUMBER
210 ,p_amount_ppetp_entry_value IN VARCHAR2
211 ,p_amount_nppetp_input_value_id IN NUMBER
212 ,p_amount_nppetp_entry_value IN VARCHAR2
213 ,p_personal_payment_method_id IN NUMBER
214 ,p_effective_start_date IN OUT NOCOPY DATE
215 ,p_effective_end_date IN OUT NOCOPY DATE
216 ,p_update_warning OUT NOCOPY BOOLEAN) IS
217 BEGIN
218
219 py_element_entry_api.update_element_entry
220 (p_datetrack_update_mode => p_dt_update_mode
221 ,p_effective_date => p_session_date
222 ,p_business_group_id => p_business_group_id
223 ,p_element_entry_id => p_element_entry_id
224 ,p_object_version_number => p_object_version_number
225 ,p_input_value_id1 => p_amount_input_value_id
226 ,p_entry_value1 => p_amount_entry_value
227 ,p_input_value_id2 => p_amount_ppetp_input_value_id
228 ,p_entry_value2 => p_amount_ppetp_entry_value
229 ,p_input_value_id3 => p_amount_nppetp_input_value_id
230 ,p_entry_value3 => p_amount_nppetp_entry_value
231 ,p_personal_payment_method_id => p_personal_payment_method_id
232 ,p_effective_start_date => p_effective_start_date
233 ,p_effective_end_date => p_effective_end_date
234 ,p_override_user_ent_chk => 'Y'
235 ,P_update_warning => p_update_warning );
236
237 END update_super_element_entry;
238
239 END pay_au_terminations_entry_api;