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: -- --------------------
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
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: -- --------------------
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
198: ,p_information27 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
198: ,p_information27 in VARCHAR2 default hr_api.g_varchar2
199: ,p_information28 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
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
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
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
201: ,p_information30 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
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
201: ,p_information30 in VARCHAR2 default hr_api.g_varchar2
202: );
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
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
201: ,p_information30 in VARCHAR2 default hr_api.g_varchar2
202: );
203:
196: ,p_information25 in VARCHAR2 default hr_api.g_varchar2
197: ,p_information26 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
201: ,p_information30 in VARCHAR2 default hr_api.g_varchar2
202: );
203:
204: --
197: ,p_information26 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
201: ,p_information30 in VARCHAR2 default hr_api.g_varchar2
202: );
203:
204: --
205: -- ---------------------------------------------------------------------- --
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: -- ---------------------------------------------------------------------- --
311: -- --------------------------
312: -- ---------------------------------------------------------------------- --
313: --
314:
315: -- Removed the Gmis Values and used Hr_Api.
317: commitNode in xmldom.DOMNode,
318: attributeName in VARCHAR2,
319: gmisc_value in date default hr_api.g_date)
315: -- Removed the Gmis Values and used Hr_Api.
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: -- ---------------------------------------------------------------------- --
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: -- ---------------------------------------------------------------------- --
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: --
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: -- -------------------------
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:
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:
464: -- ---------------------------------------------------------------------- --
465: --
466: procedure delete_transaction_children(
467: p_transaction_id in NUMBER,
468: p_validate in NUMBER default hr_api.g_false_num);
469:
470: --
471: -- ---------------------------------------------------------------------- --
472: -- --------------------------
473: -- ---------------------------------------------------------------------- --
474: --
475: Function commit_transaction(
476: p_transaction_id in NUMBER,
477: p_validate in number default hr_api.g_false_num,
478: p_effective_date in DATE default SYSDATE) return VARCHAR2;
479:
480:
481: procedure setTransactionStatus(
488: p_status out nocopy varchar2);
489:
490: procedure commit_transaction(
491: p_transaction_id in NUMBER,
492: p_validate in number default hr_api.g_false_num,
493: p_effective_date in DATE default SYSDATE,
494: p_process_all_on_error in number default hr_api.g_false_num,
495: p_status out nocopy varchar2,
496: p_error_log in out nocopy CLOB);
490: procedure commit_transaction(
491: p_transaction_id in NUMBER,
492: p_validate in number default hr_api.g_false_num,
493: p_effective_date in DATE default SYSDATE,
494: p_process_all_on_error in number default hr_api.g_false_num,
495: p_status out nocopy varchar2,
496: p_error_log in out nocopy CLOB);
497:
498: --