1 PACKAGE PSB_WRHR_EXTRACT_PROCESS AS
2 /* $Header: PSBWHRCS.pls 120.9 2005/11/07 05:55:43 masethur ship $ */
3
4 PROCEDURE Perform_Data_Extract
5 ( p_api_version IN NUMBER,
6 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7 p_commit IN VARCHAR2 := FND_API.G_FALSE,
8 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
9 p_return_status OUT NOCOPY VARCHAR2,
10 p_msg_count OUT NOCOPY NUMBER,
11 p_msg_data OUT NOCOPY VARCHAR2,
12 p_data_extract_id IN NUMBER
13 );
14
15 PROCEDURE Interface_Purge
16 (p_api_version IN NUMBER,
17 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
18 p_commit IN VARCHAR2 := FND_API.G_FALSE,
19 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
20 /* Start bug #4386374 */
21 p_data_extract_id IN NUMBER := null, -- Fixed for bug#4683895
22 p_populate_interface_flag IN VARCHAR2 := null,-- Fixed for bug#4683895
23 /* End bug #4386374 */
24 p_return_status OUT NOCOPY VARCHAR2,
25 p_msg_count OUT NOCOPY NUMBER,
26 p_msg_data OUT NOCOPY VARCHAR2
27 );
28
29 PROCEDURE Perform_Data_Extract_CP
30 (
31 errbuf OUT NOCOPY VARCHAR2,
32 retcode OUT NOCOPY VARCHAR2,
33 --
34 p_data_extract_id IN NUMBER
35 );
36
37 /* 1308558. Mass Position Assignment Rules Enhancement.
38 added an extra input parameter p_ruleset_id for passing
39 the id for the default ruleset */
40 PROCEDURE Assign_Position_Defaults_CP
41 (
42 errbuf OUT NOCOPY VARCHAR2,
43 retcode OUT NOCOPY VARCHAR2,
44 --
45 p_data_extract_id IN NUMBER ,
46 p_request_set_flag IN VARCHAR2 := 'N', -- Fix for bug 4683895
47 p_ruleset_id IN NUMBER := NULL -- Fix for bug 4683895
48
49 );
50
51 PROCEDURE Pre_Create_Extract_CP
52 (
53 errbuf OUT NOCOPY VARCHAR2,
54 retcode OUT NOCOPY VARCHAR2,
55 --
56 p_data_extract_id IN NUMBER
57 );
58
59
60 PROCEDURE Copy_Attributes_CP
61 (
62 errbuf OUT NOCOPY VARCHAR2,
63 retcode OUT NOCOPY VARCHAR2,
64 --
65 p_copy_defaults_flag IN VARCHAR2 ,
66 p_copy_defaults_status IN VARCHAR2 ,
67 p_copy_data_extract_id IN NUMBER,
68 p_data_extract_method IN VARCHAR2,
69 p_data_extract_id IN NUMBER
70 );
71
72 Procedure Copy_Elements_CP
73 (
74 errbuf OUT NOCOPY VARCHAR2 ,
75 retcode OUT NOCOPY VARCHAR2 ,
76 --
77 p_copy_defaults_flag IN VARCHAR2 ,
78 p_copy_defaults_status IN VARCHAR2 ,
79 p_copy_data_extract_id IN NUMBER,
80 p_copy_salary_flag IN VARCHAR2,
81 p_data_extract_method IN VARCHAR2,
82 p_data_extract_id IN NUMBER
83 );
84
85 Procedure Copy_Position_Sets_CP
86 (
87 errbuf OUT NOCOPY VARCHAR2 ,
88 retcode OUT NOCOPY VARCHAR2 ,
89 --
90 p_copy_defaults_flag IN VARCHAR2 ,
91 p_copy_defaults_status IN VARCHAR2 ,
92 p_copy_data_extract_id IN NUMBER,
93 p_data_extract_method IN VARCHAR2,
94 p_data_extract_id IN NUMBER
95 );
96
97 Procedure Copy_Default_Rules_CP
98 (
99 errbuf OUT NOCOPY VARCHAR2 ,
100 retcode OUT NOCOPY VARCHAR2 ,
101 --
102 p_copy_defaults_flag IN VARCHAR2 ,
103 p_copy_defaults_status IN VARCHAR2 ,
104 p_copy_data_extract_id IN NUMBER,
105 p_data_extract_method IN VARCHAR2,
106 p_data_extract_id IN NUMBER
107 );
108
109 Procedure Populate_Positions_CP
110 (
111 errbuf OUT NOCOPY VARCHAR2 ,
112 retcode OUT NOCOPY VARCHAR2 ,
113 --
114 p_populate_interface_flag IN VARCHAR2 ,
115 p_populate_interface_status IN VARCHAR2 ,
116 p_populate_data_flag IN VARCHAR2 ,
117 p_populate_data_status IN VARCHAR2 ,
118 p_data_extract_method IN VARCHAR2 ,
119 p_req_data_as_of_date IN DATE ,
120 p_position_id_flex_num IN NUMBER ,
121 p_business_group_id IN NUMBER ,
122 p_set_of_books_id IN NUMBER ,
123 p_data_extract_id IN NUMBER ,
124 -- de by org
125 p_extract_by_org IN VARCHAR2 := 'N'
126 );
127
128 Procedure Populate_Elements_CP
129 (
130 errbuf OUT NOCOPY VARCHAR2 ,
131 retcode OUT NOCOPY VARCHAR2 ,
132 --
133 p_populate_interface_flag IN VARCHAR2 ,
134 p_populate_interface_status IN VARCHAR2 ,
135 p_populate_data_flag IN VARCHAR2 ,
136 p_populate_data_status IN VARCHAR2 ,
137 p_data_extract_method IN VARCHAR2 ,
138 p_req_data_as_of_date IN DATE ,
139 p_business_group_id IN NUMBER ,
140 p_set_of_books_id IN NUMBER ,
141 p_data_extract_id IN NUMBER
142 );
143
144 Procedure Populate_Employees_CP
145 (
146 errbuf OUT NOCOPY VARCHAR2 ,
147 retcode OUT NOCOPY VARCHAR2 ,
148 --
149 p_populate_interface_flag IN VARCHAR2 ,
150 p_populate_interface_status IN VARCHAR2 ,
151 p_populate_data_flag IN VARCHAR2 ,
152 p_populate_data_status IN VARCHAR2 ,
153 p_data_extract_method IN VARCHAR2 ,
154 p_business_group_id IN NUMBER ,
155 p_set_of_books_id IN NUMBER ,
156 p_req_data_as_of_date IN DATE ,
157 p_copy_defaults_flag IN VARCHAR2 ,
158 p_copy_salary_flag IN VARCHAR2 ,
159 p_data_extract_id IN NUMBER ,
160 -- de by org
161 p_extract_by_org IN VARCHAR2 := 'N'
162 );
163
164 Procedure Populate_Attributes_CP
165 (
166 errbuf OUT NOCOPY VARCHAR2 ,
167 retcode OUT NOCOPY VARCHAR2 ,
168 --
169 p_populate_interface_flag IN VARCHAR2 ,
170 p_populate_interface_status IN VARCHAR2 ,
171 p_populate_data_flag IN VARCHAR2 ,
172 p_populate_data_status IN VARCHAR2 ,
173 p_data_extract_method IN VARCHAR2 ,
174 p_req_data_as_of_date IN DATE ,
175 p_business_group_id IN NUMBER ,
176 p_set_of_books_id IN NUMBER ,
177 p_data_extract_id IN NUMBER
178 );
179
180 Procedure Populate_Cost_Distributions_CP
181 (
182 errbuf OUT NOCOPY VARCHAR2 ,
183 retcode OUT NOCOPY VARCHAR2 ,
184 --
185 p_populate_interface_flag IN VARCHAR2 ,
186 p_populate_interface_status IN VARCHAR2 ,
187 p_populate_data_flag IN VARCHAR2 ,
188 p_populate_data_status IN VARCHAR2 ,
189 p_data_extract_method IN VARCHAR2 ,
190 p_business_group_id IN NUMBER ,
191 p_set_of_books_id IN NUMBER ,
192 p_req_data_as_of_date IN DATE ,
193 p_data_extract_id IN NUMBER ,
194 -- de by org
195 p_extract_by_org IN VARCHAR2 := 'N'
196 );
197
198 Procedure Populate_Pos_Assignments_CP
199 (
200 errbuf OUT NOCOPY VARCHAR2 ,
201 retcode OUT NOCOPY VARCHAR2 ,
202 --
203 p_populate_interface_flag IN VARCHAR2 ,
204 p_populate_interface_status IN VARCHAR2 ,
205 p_populate_data_flag IN VARCHAR2 ,
206 p_populate_data_status IN VARCHAR2 ,
207 p_data_extract_method IN VARCHAR2 ,
208 p_business_group_id IN NUMBER ,
209 p_set_of_books_id IN NUMBER ,
210 p_req_data_as_of_date IN DATE ,
211 p_data_extract_id IN NUMBER ,
212 -- de by org
213 p_extract_by_org IN VARCHAR2 := 'N'
214 );
215
216 Procedure Validate_Extract_CP
217 (
218 errbuf OUT NOCOPY VARCHAR2 ,
219 retcode OUT NOCOPY VARCHAR2 ,
220 --
221 p_validate_data_flag IN VARCHAR2 ,
222 p_validate_data_status IN VARCHAR2 ,
223 p_data_extract_method IN VARCHAR2 ,
224 p_req_data_as_of_date IN DATE ,
225 p_business_group_id IN NUMBER ,
226 p_data_extract_id IN NUMBER
227 );
228
229 Procedure Post_Extract_CP
230 (
231 errbuf OUT NOCOPY VARCHAR2 ,
232 retcode OUT NOCOPY VARCHAR2 ,
233 --
234 p_copy_defaults_flag IN VARCHAR2 ,
235 p_populate_interface_flag IN VARCHAR2 ,
236 p_populate_data_flag IN VARCHAR2 ,
237 p_validate_data_flag IN VARCHAR2 ,
238 p_data_extract_id IN NUMBER
239 );
240
241 FUNCTION get_debug RETURN VARCHAR2;
242
243 -- de by org
244
245 PROCEDURE Insert_Organizations
246 (
247 p_api_version IN NUMBER,
248 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
249 p_commit IN VARCHAR2 := FND_API.G_FALSE,
250 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
251 p_data_extract_id IN NUMBER,
252 p_as_of_date IN DATE,
253 p_business_group_id IN NUMBER,
254 p_return_status OUT NOCOPY VARCHAR2,
255 p_msg_count OUT NOCOPY NUMBER,
256 p_msg_data OUT NOCOPY VARCHAR2
257 );
258
259 PROCEDURE Submit_Data_Extract
260 (
261 p_api_version IN NUMBER,
262 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
263 p_commit IN VARCHAR2 := FND_API.G_FALSE,
264 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
265 p_return_status OUT NOCOPY VARCHAR2,
266 p_msg_count OUT NOCOPY NUMBER,
267 p_msg_data OUT NOCOPY VARCHAR2,
268 p_data_extract_id IN NUMBER,
269 p_data_extract_method IN VARCHAR2,
270 p_req_data_as_of_date IN DATE,
271 p_business_group_id IN NUMBER,
272 p_set_of_books_id IN NUMBER,
273 p_copy_defaults_flag IN VARCHAR2,
274 p_copy_defaults_extract_id IN NUMBER,
275 p_copy_defaults_status IN VARCHAR2,
276 p_populate_interface_flag IN VARCHAR2,
277 p_populate_interface_status IN VARCHAR2,
278 p_populate_data_flag IN VARCHAR2,
279 p_populate_data_status IN VARCHAR2,
280 p_validate_data_flag IN VARCHAR2,
281 p_validate_data_status IN VARCHAR2,
282 p_position_id_flex_num IN NUMBER,
283 p_request_id OUT NOCOPY NUMBER
284 );
285
286 /* Bug No. 1308558 Start */
287 PROCEDURE Create_Default_Rule_Set
288 ( x_return_status OUT NOCOPY VARCHAR2,
289 x_msg_count OUT NOCOPY NUMBER,
290 x_msg_data OUT NOCOPY VARCHAR2,
291 x_msg_init_list IN VARCHAR2 := FND_API.G_TRUE,
292 p_commit IN VARCHAR2 := FND_API.G_FALSE,
293 p_api_version IN NUMBER,
294 p_data_extract_id IN NUMBER,
295 p_rule_set_name IN VARCHAR2
296 );
297 /* Bug No. 1308558 End */
298
299 /* Bug No. 1308558 Start */
300 PROCEDURE Create_Default_Rule_Set_CP
301 ( errbuf OUT NOCOPY VARCHAR2,
302 retcode OUT NOCOPY VARCHAR2,
303 p_data_extract_id IN NUMBER,
304 p_rule_set_name IN VARCHAR2
305 );
306 /* Bug No. 1308558 End */
307
308
309 END PSB_WRHR_EXTRACT_PROCESS;