[Home] [Help]
PACKAGE: APPS.PAY_BATCH_BALANCEADJ_WRAPPER
Source
4 PROCEDURE create_batch_header(p_batch_name in varchar2,
1 PACKAGE pay_batch_balanceadj_wrapper AUTHID CURRENT_USER AS
2 /* $Header: paybbawebadi.pkh 120.7.12010000.1 2008/07/27 21:44:48 appldev ship $ */
3
5 p_business_group_id in number,
6 p_batch_reference in varchar2 default null,
7 p_batch_source in varchar2 default null,
8 p_batch_status in varchar2 default 'U',
9 p_batch_id out nocopy number );
10
11 PROCEDURE update_batch_header(p_batch_id in number,
12 p_batch_name in varchar2 default hr_api.g_varchar2,
13 p_batch_reference in varchar2 default hr_api.g_varchar2,
14 p_batch_source in varchar2 default hr_api.g_varchar2,
15 p_batch_status in varchar2 default hr_api.g_varchar2);
16
17 PROCEDURE update_batch_groups_lines(p_batch_id in number,
18 p_batch_name in varchar2,
19 p_batch_group_id in number, -- NEW
20 p_batch_line_id in number, -- NEW
21 p_effective_date in date, -- effective date
22 p_employee_id in varchar2, -- Employee Name
23 p_assignment_id in varchar2, -- assignment_number
24 p_element_name in varchar2,
25 p_element_type_id in number,
26 p_element_link_id in number,
27 p_payroll_id in number default null,
28 p_business_group_id in number,
29 p_consolidation_set_id in number default null,
30 p_gre_id in number default null,
31 p_prepay_flag in varchar2 ,
32 p_costing_flag in varchar2 ,
33 p_cost_allocation_keyflex in number default null,
34 p_concatenated_segments in varchar2 default null,
35 segment1 in varchar2 default null,
36 segment2 in varchar2 default null,
37 segment3 in varchar2 default null,
38 segment4 in varchar2 default null,
39 segment5 in varchar2 default null,
40 segment6 in varchar2 default null,
41 segment7 in varchar2 default null,
42 segment8 in varchar2 default null,
43 segment9 in varchar2 default null,
44 segment10 in varchar2 default null,
45 segment11 in varchar2 default null,
46 segment12 in varchar2 default null,
47 segment13 in varchar2 default null,
48 segment14 in varchar2 default null,
49 segment15 in varchar2 default null,
50 segment16 in varchar2 default null,
51 segment17 in varchar2 default null,
52 segment18 in varchar2 default null,
53 segment19 in varchar2 default null,
54 segment20 in varchar2 default null,
55 segment21 in varchar2 default null,
56 segment22 in varchar2 default null,
57 segment23 in varchar2 default null,
58 segment24 in varchar2 default null,
59 segment25 in varchar2 default null,
63 segment29 in varchar2 default null,
60 segment26 in varchar2 default null,
61 segment27 in varchar2 default null,
62 segment28 in varchar2 default null,
64 segment30 in varchar2 default null,
65 p_ee_value1 in varchar2 default null,
66 p_ee_value2 in varchar2 default null,
67 p_ee_value3 in varchar2 default null,
68 p_ee_value4 in varchar2 default null,
69 p_ee_value5 in varchar2 default null,
70 p_ee_value6 in varchar2 default null,
71 p_ee_value7 in varchar2 default null,
72 p_ee_value8 in varchar2 default null,
73 p_ee_value9 in varchar2 default null,
74 p_ee_value10 in varchar2 default null,
75 p_ee_value11 in varchar2 default null,
76 p_ee_value12 in varchar2 default null,
77 p_ee_value13 in varchar2 default null,
78 p_ee_value14 in varchar2 default null,
79 p_ee_value15 in varchar2 default null,
80 p_col1 in number default null,
81 p_col2 in number default null,
82 p_col3 in number default null,
83 p_col4 in number default null,
84 p_col5 in number default null,
85 p_col_val1 in varchar2 default null,
86 p_col_val2 in varchar2 default null,
87 p_col_val3 in varchar2 default null,
88 p_col_val4 in varchar2 default null,
89 p_col_val5 in varchar2 default null);
90
91
92 PROCEDURE upload_data(p_batch_id in number,
93 p_batch_name in varchar2,
94 p_effective_date in date, -- effective date
95 p_employee_id in varchar2, -- Employee Name
96 p_assignment_id in varchar2, -- assignment_number
97 p_element_name in varchar2,
98 p_element_type_id in number,
99 p_element_link_id in number default null,
100 p_payroll_id in varchar2 default null, -- Payroll Name
101 p_business_group_id in number,
102 p_consolidation_set_id in number default null,
103 p_gre_id in varchar2 default null,
104 p_prepay_flag in varchar2 ,
105 p_costing_flag in varchar2 ,
106 p_cost_allocation_keyflex in number default null,
107 p_concatenated_segments in varchar2 default null,
108 segment1 in varchar2 default null,
109 segment2 in varchar2 default null,
110 segment3 in varchar2 default null,
111 segment4 in varchar2 default null,
112 segment5 in varchar2 default null,
113 segment6 in varchar2 default null,
114 segment7 in varchar2 default null,
115 segment8 in varchar2 default null,
116 segment9 in varchar2 default null,
117 segment10 in varchar2 default null,
121 segment14 in varchar2 default null,
118 segment11 in varchar2 default null,
119 segment12 in varchar2 default null,
120 segment13 in varchar2 default null,
122 segment15 in varchar2 default null,
123 segment16 in varchar2 default null,
124 segment17 in varchar2 default null,
125 segment18 in varchar2 default null,
126 segment19 in varchar2 default null,
127 segment20 in varchar2 default null,
128 segment21 in varchar2 default null,
129 segment22 in varchar2 default null,
130 segment23 in varchar2 default null,
131 segment24 in varchar2 default null,
132 segment25 in varchar2 default null,
133 segment26 in varchar2 default null,
134 segment27 in varchar2 default null,
135 segment28 in varchar2 default null,
136 segment29 in varchar2 default null,
137 segment30 in varchar2 default null,
138 p_ee_value1 in varchar2 default null,
139 p_ee_value2 in varchar2 default null,
140 p_ee_value3 in varchar2 default null,
141 p_ee_value4 in varchar2 default null,
142 p_ee_value5 in varchar2 default null,
143 p_ee_value6 in varchar2 default null,
144 p_ee_value7 in varchar2 default null,
145 p_ee_value8 in varchar2 default null,
146 p_ee_value9 in varchar2 default null,
147 p_ee_value10 in varchar2 default null,
148 p_ee_value11 in varchar2 default null,
149 p_ee_value12 in varchar2 default null,
150 p_ee_value13 in varchar2 default null,
151 p_ee_value14 in varchar2 default null,
152 p_ee_value15 in varchar2 default null,
153 p_col1 in number default null,
154 p_col2 in number default null,
155 p_col3 in number default null,
156 p_col4 in number default null,
157 p_col5 in number default null,
158 p_col_val1 in varchar2 default null,
159 p_col_val2 in varchar2 default null,
160 p_col_val3 in varchar2 default null,
161 p_col_val4 in varchar2 default null,
162 p_col_val5 in varchar2 default null,
163 p_batch_line_id in number default null,
164 p_batch_group_id in number default null,
165 p_batch_line_status in varchar2 default null,
166 p_mode in varchar2 default null);
167
168 FUNCTION convert_internal_to_display(p_element_type_id IN VARCHAR2,
169 p_input_value IN VARCHAR2,
170 p_input_value_number IN NUMBER,
171 p_session_date IN DATE,
172 p_batch_id IN NUMBER,
173 p_calling_mode IN VARCHAR2
174 ) return varchar2;
175 --
176
177 g_element_type_id number default null;
178
179 g_ip_id1 number default null;
180 g_ip_id2 number default null;
181 g_ip_id3 number default null;
182 g_ip_id4 number default null;
183 g_ip_id5 number default null;
184 g_ip_id6 number default null;
185 g_ip_id7 number default null;
186 g_ip_id8 number default null;
187 g_ip_id9 number default null;
188 g_ip_id10 number default null;
189 g_ip_id11 number default null;
190 g_ip_id12 number default null;
191 g_ip_id13 number default null;
195 -- Bug: 5200900
192 g_ip_id14 number default null;
193 g_ip_id15 number default null;
194
196 g_ee_value1 varchar2(60) default null;
197 g_ee_value2 varchar2(60) default null;
198 g_ee_value3 varchar2(60) default null;
199 g_ee_value4 varchar2(60) default null;
200 g_ee_value5 varchar2(60) default null;
201 g_ee_value6 varchar2(60) default null;
202 g_ee_value7 varchar2(60) default null;
203 g_ee_value8 varchar2(60) default null;
204 g_ee_value9 varchar2(60) default null;
205 g_ee_value10 varchar2(60) default null;
206 g_ee_value11 varchar2(60) default null;
207 g_ee_value12 varchar2(60) default null;
208 g_ee_value13 varchar2(60) default null;
209 g_ee_value14 varchar2(60) default null;
210 g_ee_value15 varchar2(60) default null;
211
212 g_batch_id number;
213
214 g_pactid_flag boolean default FALSE;
215 g_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
216 g_flex_num number;
217
218 g_display_sequence number;
219
220 /* Pl/Sql table to store and compare unique combination
221 values to create batch_group_id */
222
223 TYPE batch_group_rec IS RECORD(batch_id number(30)
224 ,consolidation_set_id number(30)
225 ,payroll_id number(30)
226 ,effective_date date
227 ,prepay_flag varchar2(2)
228 ,batch_group_status varchar2(2)
229 ,batch_group_id number(30)
230 );
231
232 TYPE batch_group_table IS TABLE OF batch_group_rec
233 INDEX BY BINARY_INTEGER;
234
235 gtr_batch_group_data batch_group_table;
236
237 end pay_batch_balanceadj_wrapper;