[Home] [Help]
PACKAGE: APPS.HR_TRANSACTION_SWI
Source
4 g_date_format varchar2(10) := 'RRRR/MM/DD';
1 PACKAGE HR_TRANSACTION_SWI AUTHID CURRENT_USER as
2 /* $Header: hrtrnswi.pkh 120.4.12020000.2 2012/07/05 00:04:23 amnaraya ship $ */
3 -- Global variables
5
6 --
7 -- ---------------------------------------------------------------------- --
8 -- ----------------------<create_transaction>---------------------------- --
9 -- ---------------------------------------------------------------------- --
10 --
11
12 procedure create_transaction
13 (
14 P_TRANSACTION_ID IN NUMBER
15 ,P_CREATOR_PERSON_ID IN NUMBER
16 ,P_TRANSACTION_PRIVILEGE IN VARCHAR2
17 ,P_PRODUCT_CODE IN VARCHAR2 DEFAULT NULL
18 ,P_URL IN LONG DEFAULT NULL
19 ,P_STATUS IN VARCHAR2 DEFAULT NULL
20 ,P_SECTION_DISPLAY_NAME IN VARCHAR2 DEFAULT NULL
21 ,P_FUNCTION_ID IN NUMBER DEFAULT NULL
22 ,P_TRANSACTION_REF_TABLE IN VARCHAR2 DEFAULT NULL
23 ,P_TRANSACTION_REF_ID IN NUMBER DEFAULT NULL
24 ,P_TRANSACTION_TYPE IN VARCHAR2 DEFAULT NULL
25 ,P_ASSIGNMENT_ID IN NUMBER DEFAULT NULL
26 ,P_API_ADDTNL_INFO IN VARCHAR2 DEFAULT NULL
27 ,P_SELECTED_PERSON_ID IN NUMBER DEFAULT NULL
31 ,P_PROCESS_NAME IN VARCHAR2 DEFAULT NULL
28 ,P_ITEM_TYPE IN VARCHAR2 DEFAULT NULL
29 ,P_ITEM_KEY IN VARCHAR2 DEFAULT NULL
30 ,P_TRANSACTION_EFFECTIVE_DATE IN DATE DEFAULT NULL
32 ,P_TRANSACTION_STATE IN VARCHAR2 DEFAULT NULL
33 ,P_EFFECTIVE_DATE_OPTION IN VARCHAR2 DEFAULT NULL
34 ,P_RPTG_GRP_ID IN NUMBER DEFAULT NULL
35 ,P_PLAN_ID IN NUMBER DEFAULT NULL
36 ,P_CREATOR_ROLE IN VARCHAR2 DEFAULT NULL
37 ,P_LAST_UPDATE_ROLE IN VARCHAR2 DEFAULT NULL
38 ,P_PARENT_TRANSACTION_ID IN NUMBER DEFAULT NULL
39 ,P_RELAUNCH_FUNCTION IN VARCHAR2 DEFAULT NULL
40 ,P_TRANSACTION_GROUP IN VARCHAR2 DEFAULT NULL
41 ,P_TRANSACTION_IDENTIFIER IN VARCHAR2 DEFAULT NULL
42 ,P_TRANSACTION_DOCUMENT IN CLOB DEFAULT NULL
43 ,P_VALIDATE IN NUMBER default hr_api.g_false_num
44 );
45 --
46 -- ---------------------------------------------------------------------- --
47 -- --------------------<create_transaction_step>------------------------- --
48 -- ---------------------------------------------------------------------- --
49 --
50 procedure create_transaction_step
51 (
52 P_API_NAME IN VARCHAR2
53 ,P_API_DISPLAY_NAME IN VARCHAR2 DEFAULT NULL
54 ,P_PROCESSING_ORDER IN NUMBER
55 ,P_ITEM_TYPE IN VARCHAR2 DEFAULT NULL
56 ,P_ITEM_KEY IN VARCHAR2 DEFAULT NULL
57 ,P_ACTIVITY_ID IN NUMBER DEFAULT NULL
58 ,P_CREATOR_PERSON_ID IN NUMBER
59 ,P_UPDATE_PERSON_ID IN NUMBER DEFAULT NULL
60 ,P_OBJECT_TYPE IN VARCHAR2 DEFAULT NULL
61 ,P_OBJECT_NAME IN VARCHAR2 DEFAULT NULL
62 ,P_OBJECT_IDENTIFIER IN VARCHAR2 DEFAULT NULL
63 ,P_OBJECT_STATE IN VARCHAR2 DEFAULT NULL
64 ,P_PK1 IN VARCHAR2 DEFAULT NULL
65 ,P_PK2 IN VARCHAR2 DEFAULT NULL
66 ,P_PK3 IN VARCHAR2 DEFAULT NULL
67 ,P_PK4 IN VARCHAR2 DEFAULT NULL
68 ,P_PK5 IN VARCHAR2 DEFAULT NULL
69 ,P_VALIDATE IN NUMBER default hr_api.g_false_num
70 ,P_OBJECT_VERSION_NUMBER IN OUT nocopy NUMBER
71 ,P_TRANSACTION_ID IN NUMBER
72 ,P_TRANSACTION_STEP_ID IN NUMBER
73 ,p_information_category in VARCHAR2 default null
74 ,p_information1 in VARCHAR2 default null
75 ,p_information2 in VARCHAR2 default null
76 ,p_information3 in VARCHAR2 default null
77 ,p_information4 in VARCHAR2 default null
78 ,p_information5 in VARCHAR2 default null
79 ,p_information6 in VARCHAR2 default null
80 ,p_information7 in VARCHAR2 default null
81 ,p_information8 in VARCHAR2 default null
82 ,p_information9 in VARCHAR2 default null
83 ,p_information10 in VARCHAR2 default null
84 ,p_information11 in VARCHAR2 default null
85 ,p_information12 in VARCHAR2 default null
86 ,p_information13 in VARCHAR2 default null
87 ,p_information14 in VARCHAR2 default null
88 ,p_information15 in VARCHAR2 default null
89 ,p_information16 in VARCHAR2 default null
90 ,p_information17 in VARCHAR2 default null
91 ,p_information18 in VARCHAR2 default null
92 ,p_information19 in VARCHAR2 default null
93 ,p_information20 in VARCHAR2 default null
94 ,p_information21 in VARCHAR2 default null
95 ,p_information22 in VARCHAR2 default null
96 ,p_information23 in VARCHAR2 default null
97 ,p_information24 in VARCHAR2 default null
98 ,p_information25 in VARCHAR2 default null
99 ,p_information26 in VARCHAR2 default null
100 ,p_information27 in VARCHAR2 default null
101 ,p_information28 in VARCHAR2 default null
102 ,p_information29 in VARCHAR2 default null
103 ,p_information30 in VARCHAR2 default null
104 );
105 --
106 -- ---------------------------------------------------------------------- --
107 -- ----------------------<update_transaction>---------------------------- --
108 -- ---------------------------------------------------------------------- --
109 --
110 procedure update_transaction
111 (
112 P_TRANSACTION_ID IN NUMBER
113 ,P_CREATOR_PERSON_ID IN NUMBER
114 ,P_TRANSACTION_PRIVILEGE IN VARCHAR2
118 ,P_SECTION_DISPLAY_NAME IN VARCHAR2 DEFAULT NULL
115 ,P_PRODUCT_CODE IN VARCHAR2 DEFAULT NULL
116 ,P_URL IN LONG DEFAULT NULL
117 ,P_STATUS IN VARCHAR2 DEFAULT NULL
119 ,P_FUNCTION_ID IN NUMBER DEFAULT NULL
120 ,P_TRANSACTION_REF_TABLE IN VARCHAR2 DEFAULT NULL
121 ,P_TRANSACTION_REF_ID IN NUMBER DEFAULT NULL
122 ,P_TRANSACTION_TYPE IN VARCHAR2 DEFAULT NULL
123 ,P_ASSIGNMENT_ID IN NUMBER DEFAULT NULL
124 ,P_API_ADDTNL_INFO IN VARCHAR2 DEFAULT NULL
125 ,P_SELECTED_PERSON_ID IN NUMBER DEFAULT NULL
126 ,P_ITEM_TYPE IN VARCHAR2 DEFAULT NULL
127 ,P_ITEM_KEY IN VARCHAR2 DEFAULT NULL
128 ,P_TRANSACTION_EFFECTIVE_DATE IN DATE DEFAULT NULL
129 ,P_PROCESS_NAME IN VARCHAR2 DEFAULT NULL
130 ,P_TRANSACTION_STATE IN VARCHAR2 DEFAULT NULL
131 ,P_EFFECTIVE_DATE_OPTION IN VARCHAR2 DEFAULT NULL
132 ,P_RPTG_GRP_ID IN NUMBER DEFAULT NULL
133 ,P_PLAN_ID IN NUMBER DEFAULT NULL
134 ,P_CREATOR_ROLE IN VARCHAR2 DEFAULT NULL
135 ,P_LAST_UPDATE_ROLE IN VARCHAR2 DEFAULT NULL
136 ,P_PARENT_TRANSACTION_ID IN NUMBER DEFAULT NULL
137 ,P_RELAUNCH_FUNCTION IN VARCHAR2 DEFAULT NULL
138 ,P_TRANSACTION_GROUP IN VARCHAR2 DEFAULT NULL
139 ,P_TRANSACTION_IDENTIFIER IN VARCHAR2 DEFAULT NULL
140 ,P_TRANSACTION_DOCUMENT IN CLOB DEFAULT NULL
141 ,P_VALIDATE IN NUMBER default hr_api.g_false_num
142 );
143 --
144 -- ---------------------------------------------------------------------- --
145 -- --------------------<update_transaction_step>------------------------- --
146 -- ---------------------------------------------------------------------- --
147 --
148 procedure update_transaction_step
149 (
150 P_API_NAME IN VARCHAR2
151 ,P_API_DISPLAY_NAME IN VARCHAR2 DEFAULT NULL
152 ,P_PROCESSING_ORDER IN NUMBER
153 ,P_ITEM_TYPE IN VARCHAR2 DEFAULT NULL
154 ,P_ITEM_KEY IN VARCHAR2 DEFAULT NULL
155 ,P_ACTIVITY_ID IN NUMBER DEFAULT NULL
156 ,P_CREATOR_PERSON_ID IN NUMBER
157 ,P_UPDATE_PERSON_ID IN NUMBER DEFAULT NULL
158 ,P_OBJECT_TYPE IN VARCHAR2 DEFAULT NULL
159 ,P_OBJECT_NAME IN VARCHAR2 DEFAULT NULL
160 ,P_OBJECT_IDENTIFIER IN VARCHAR2 DEFAULT NULL
161 ,P_OBJECT_STATE IN VARCHAR2 DEFAULT NULL
162 ,P_PK1 IN VARCHAR2 DEFAULT NULL
163 ,P_PK2 IN VARCHAR2 DEFAULT NULL
164 ,P_PK3 IN VARCHAR2 DEFAULT NULL
165 ,P_PK4 IN VARCHAR2 DEFAULT NULL
166 ,P_PK5 IN VARCHAR2 DEFAULT NULL
167 ,P_VALIDATE IN NUMBER default hr_api.g_false_num
168 ,P_OBJECT_VERSION_NUMBER IN OUT nocopy NUMBER
169 ,P_TRANSACTION_ID IN NUMBER
170 ,P_TRANSACTION_STEP_ID IN NUMBER
171 ,p_information_category in VARCHAR2 default hr_api.g_varchar2
172 ,p_information1 in VARCHAR2 default hr_api.g_varchar2
173 ,p_information2 in VARCHAR2 default hr_api.g_varchar2
174 ,p_information3 in VARCHAR2 default hr_api.g_varchar2
175 ,p_information4 in VARCHAR2 default hr_api.g_varchar2
176 ,p_information5 in VARCHAR2 default hr_api.g_varchar2
177 ,p_information6 in VARCHAR2 default hr_api.g_varchar2
178 ,p_information7 in VARCHAR2 default hr_api.g_varchar2
179 ,p_information8 in VARCHAR2 default hr_api.g_varchar2
180 ,p_information9 in VARCHAR2 default hr_api.g_varchar2
181 ,p_information10 in VARCHAR2 default hr_api.g_varchar2
182 ,p_information11 in VARCHAR2 default hr_api.g_varchar2
183 ,p_information12 in VARCHAR2 default hr_api.g_varchar2
184 ,p_information13 in VARCHAR2 default hr_api.g_varchar2
185 ,p_information14 in VARCHAR2 default hr_api.g_varchar2
186 ,p_information15 in VARCHAR2 default hr_api.g_varchar2
187 ,p_information16 in VARCHAR2 default hr_api.g_varchar2
188 ,p_information17 in VARCHAR2 default hr_api.g_varchar2
189 ,p_information18 in VARCHAR2 default hr_api.g_varchar2
190 ,p_information19 in VARCHAR2 default hr_api.g_varchar2
191 ,p_information20 in VARCHAR2 default hr_api.g_varchar2
192 ,p_information21 in VARCHAR2 default hr_api.g_varchar2
193 ,p_information22 in VARCHAR2 default hr_api.g_varchar2
194 ,p_information23 in VARCHAR2 default hr_api.g_varchar2
195 ,p_information24 in VARCHAR2 default hr_api.g_varchar2
196 ,p_information25 in VARCHAR2 default hr_api.g_varchar2
197 ,p_information26 in VARCHAR2 default hr_api.g_varchar2
201 ,p_information30 in VARCHAR2 default hr_api.g_varchar2
198 ,p_information27 in VARCHAR2 default hr_api.g_varchar2
199 ,p_information28 in VARCHAR2 default hr_api.g_varchar2
200 ,p_information29 in VARCHAR2 default hr_api.g_varchar2
202 );
203
204 --
205 -- ---------------------------------------------------------------------- --
206 -- --------------------<delete_transaction_step>------------------------- --
207 -- ---------------------------------------------------------------------- --
208 --
209 procedure delete_transaction_step
210 ( p_transaction_step_id in number
211 ,p_person_id in number
212 ,p_object_version_number in number
213 ,p_validate in number default hr_api.g_false_num
214 );
215
216 --
217 -- ---------------------------------------------------------------------- --
218 -- --------------------<set_transaction_context>------------------------- --
219 -- ---------------------------------------------------------------------- --
220 --
221 procedure set_transaction_context(
222 p_transaction_id in number);
223
224 --
225 -- ---------------------------------------------------------------------- --
226 -- -----------------------<set_person_context>--------------------------- --
227 -- ---------------------------------------------------------------------- --
228 --
229
230 procedure set_person_context(
231 p_selected_person_id in number,
232 p_selected_assignment_id in number,
233 p_effective_date in DATE);
234
235 --
236 -- ---------------------------------------------------------------------- --
237 -- --------------------------<init_profiles>----------------------------- --
238 -- ---------------------------------------------------------------------- --
239 --
240
241 procedure init_profiles(
242 p_person_id in number,
243 p_assignment_id in Number,
244 p_business_group_Id in Number,
245 p_organization_Id in Number,
246 p_location_id in Number,
247 p_payroll_id in number
248 );
249
250
251
252
253 Type g_txn_details_rec Is Record
254 (
255 TRANSACTION_ID NUMBER(15),
256 CREATOR_PERSON_ID NUMBER(15),
257 STATUS VARCHAR2(10),
258 FUNCTION_ID NUMBER(10),
259 TRANSACTION_REF_TABLE VARCHAR2(100),
260 TRANSACTION_REF_ID NUMBER(15),
261 TRANSACTION_TYPE VARCHAR2(10),
262 ASSIGNMENT_ID NUMBER(15),
263 SELECTED_PERSON_ID NUMBER(15),
264 ITEM_TYPE VARCHAR2(10),
265 ITEM_KEY VARCHAR2(240),
266 EFFECTIVE_DATE DATE,
267 PROCESS_NAME VARCHAR2(30),
268 TRANSACTION_STATE VARCHAR2(10),
269 EFFECTIVE_DATE_OPTION VARCHAR2(10)
270 );
271
272 g_txn_ctx g_txn_details_rec;
273
274 Type g_person_details_rec Is Record
275 (
276 FULL_NAME VARCHAR2(240),
277 PERSON_ID NUMBER(10),
278 EMPLOYEE_NUMBER VARCHAR2(30),
279 NPW_NUMBER VARCHAR2(30),
280 ACTIVE VARCHAR2(10),
281 ASSIGNMENT_ID NUMBER(10),
282 ASSIGNMENT_NUMBER VARCHAR2(30),
283 ASSIGNMENT_TYPE VARCHAR2(1),
284 PRIMARY_FLAG VARCHAR2(30),
285 SUPERVISOR_ID NUMBER(10),
286 SUPERVISOR_NAME VARCHAR2(240),
287 BUSINESS_GROUP_ID NUMBER(15),
288 ORGANIZATION_ID NUMBER(15),
289 BUSINESS_GROUP_NAME VARCHAR2(240),
290 ORGANIZATION_NAME VARCHAR2(240),
291 JOB_ID NUMBER(15),
292 JOB_NAME VARCHAR2(700),
293 POSITION_ID NUMBER(15),
294 POSITION_NAME VARCHAR2(240),
295 LOCATION_ID NUMBER(15),
296 CURRENCY_CODE VARCHAR2(150),
297 EMPLOYEE_NUMBER_GENERATION VARCHAR2(150),
298 APPLICANT_NUMBER_GENERATION VARCHAR2(150),
299 NPW_NUMBER_GENERATION VARCHAR2(150),
300 LEGISLATION_CODE VARCHAR2(150),
301 PEOPLE_GRP_F_STRUCT_CODE VARCHAR2(30),
302 SECURITY_GROUP_ID VARCHAR2(150),
303 PAYROLL_ID NUMBER(10)
304 );
305
306 g_person_ctx g_person_details_rec;
307
308
309 --
310 -- ---------------------------------------------------------------------- --
311 -- --------------------------<getDateValue>----------------------------- --
312 -- ---------------------------------------------------------------------- --
313 --
314
315 -- Removed the Gmis Values and used Hr_Api.<gmisvalue>
316 Function getDateValue(
317 commitNode in xmldom.DOMNode,
318 attributeName in VARCHAR2,
319 gmisc_value in date default hr_api.g_date)
320 return DATE;
321
322 --
323 -- ---------------------------------------------------------------------- --
324 -- --------------------------<set_status>----------------------------- --
325 -- ---------------------------------------------------------------------- --
326 --
327
328 Function set_status(
329 p_curent_status in VARCHAR2,
330 p_dyn_sql_processapi_sts in VARCHAR2)
331 return VARCHAR2;
332
333 --
334 -- ---------------------------------------------------------------------- --
335 -- --------------------------<getVarchar2Value>-------------------------- --
336 -- ---------------------------------------------------------------------- --
337 --
338 Function getVarchar2Value(
339 commitNode in xmldom.DOMNode,
340 attributeName in VARCHAR2,
341 gmisc_value in varchar2 default hr_api.g_varchar2)
342 return varchar2;
343
344 --
345 -- ---------------------------------------------------------------------- --
346 -- --------------------------<getNumberValue>---------------------------- --
347 -- ---------------------------------------------------------------------- --
348 --
349 Function getNumberValue(
350 commitNode in xmldom.DOMNode,
351 attributeName in VARCHAR2,
352 gmisc_value in number default hr_api.g_number)
353 return NUMBER;
354
355
356 --
357 -- ---------------------------------------------------------------------- --
358 -- -------------------------<delete_transaction>------------------------- --
359 -- ---------------------------------------------------------------------- --
360 --
361 procedure delete_transaction(
362 p_transaction_id in NUMBER,
363 p_validate in NUMBER default hr_api.g_false_num);
364
365 --
366 -- ---------------------------------------------------------------------- --
367 -- -------------------------<process_api_internal>----------------------- --
368 -- ---------------------------------------------------------------------- --
369 --
370 Function process_api_internal(
371 p_transaction_id in number,
372 p_root_node in xmldom.DOMNode,
373 p_validate in number default hr_api.g_false_num,
374 p_effective_date in DATE,
375 p_return_status in varchar2)
376 return varchar2;
377
378 --
379 -- ---------------------------------------------------------------------- --
380 -- -----------------------<convertCLOBtoXMLElement>---------------------- --
381 -- ---------------------------------------------------------------------- --
382 --
383 function convertCLOBtoXMLElement(
384 p_document in CLOB)
385 return xmldom.DOMElement;
386
387 --
388 -- ---------------------------------------------------------------------- --
389 -- --------------------------<process_api_call>-------------------------- --
390 -- ---------------------------------------------------------------------- --
391 --
392 Function process_api_call(
393 p_transaction_step_id in NUMBER,
394 p_api_name in VARCHAR2,
395 p_root_node in xmldom.DOMNode,
396 p_validate in number default hr_api.g_false_num,
397 p_effective_date in DATE,
398 p_return_status in varchar2)
399 return varchar2;
400
401 --
402 -- ---------------------------------------------------------------------- --
403 -- --------------------------<setTransactionStatus>----------------------- --
404 -- ---------------------------------------------------------------------- --
405 --
406 procedure setTransactionStatus(
407 p_transaction_id in NUMBER,
408 p_transaction_ref_table in varchar2,
409 p_currentTxnStatus in varchar2,
410 p_proposedTxnStatus in varchar2,
411 p_propagateMessagePub in number,
412 p_status out nocopy varchar2);
413
414 procedure setTransactionStatus(
415 p_transaction_id in NUMBER,
416 p_approver_comments in varchar2,
417 p_transaction_ref_table in varchar2,
418 p_currentTxnStatus in varchar2,
419 p_proposedTxnStatus in varchar2,
420 p_propagateMessagePub in number,
421 p_fyidet in varchar2,
422 p_status out nocopy varchar2);
423
424 --
425 -- ---------------------------------------------------------------------- --
426 -- ---------------------------<isDeleteAllowed>-------------------------- --
427 -- ---------------------------------------------------------------------- --
428 --
429 function isDeleteAllowed(p_transaction_id in number,
430 p_transaction_status in varchar2,
431 p_notification_id in number,
432 p_authenticateNtf in number,
433 p_propagateMessagePub in number)
434 return varchar2;
435
436 --
437 -- ---------------------------------------------------------------------- --
438 -- ---------------------------<isEditAllowed>-------------------------- --
439 -- ---------------------------------------------------------------------- --
440 --
441 function isEditAllowed(p_transaction_id in number,
442 p_transaction_status in varchar2,
443 p_notification_id in number,
444 p_authenticateNtf in number,
445 p_loginPersonId in number,
446 p_loginPersonBgId in number,
447 p_propagateMessagePub in number)
448 return varchar2;
449 --
450 -- ---------------------------------------------------------------------- --
451 -- ---------------------------<cancelAction>-------------------------- --
452 -- ---------------------------------------------------------------------- --
453 --
454 procedure cancelAction(p_transaction_id in number);
455
456 --
457 -- ---------------------------------------------------------------------- --
458 -- ---------------------------<deleteAction>-------------------------- --
459 -- ---------------------------------------------------------------------- --
460 --
461 procedure deleteAction(p_transaction_id in number);
462
463 --
464 -- ---------------------------------------------------------------------- --
465 -- ---------------------------<isTxnOwner>-------------------------- --
466 -- ---------------------------------------------------------------------- --
467 --
468 function isTxnOwner(p_transaction_id in number,
469 p_person_id in number) return boolean;
470
471 --
472 -- ---------------------------------------------------------------------- --
473 -- -------------------------delete_transaction_steps>-------------------- --
474 -- ---------------------------------------------------------------------- --
475 --
476 procedure delete_transaction_children(
477 p_transaction_id in NUMBER,
478 p_validate in NUMBER default hr_api.g_false_num);
479
480 --
481 -- ---------------------------------------------------------------------- --
482 -- --------------------------<commit_transaction>----------------------- --
483 -- ---------------------------------------------------------------------- --
484 --
485 Function commit_transaction(
486 p_transaction_id in NUMBER,
487 p_validate in number default hr_api.g_false_num,
488 p_effective_date in DATE default SYSDATE) return VARCHAR2;
489
490
491 procedure setTransactionStatus(
492 p_transaction_id in NUMBER,
493 p_approver_comments in varchar2,
494 p_transaction_ref_table in varchar2,
495 p_currentTxnStatus in varchar2,
496 p_proposedTxnStatus in varchar2,
497 p_propagateMessagePub in number,
498 p_status out nocopy varchar2);
499
500 procedure commit_transaction(
501 p_transaction_id in NUMBER,
502 p_validate in number default hr_api.g_false_num,
503 p_effective_date in DATE default SYSDATE,
504 p_process_all_on_error in number default hr_api.g_false_num,
505 p_status out nocopy varchar2,
506 p_error_log in out nocopy CLOB);
507
508 --
509 -- ---------------------------------------------------------------------- --
510 -- --------------------------<initiatorDeleteAction>----------------------- --
511 -- ---------------------------------------------------------------------- --
512 --
513
514 procedure initiatorDeleteAction(p_transaction_id in number);
515
516
517 end hr_transaction_swi;