eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_TRANSACTION_SWI dependencies on HR_API

Line 57: ,P_VALIDATE IN NUMBER default hr_api.g_false_num

53: ,P_RELAUNCH_FUNCTION IN VARCHAR2 DEFAULT NULL
54: ,P_TRANSACTION_GROUP IN VARCHAR2 DEFAULT NULL
55: ,P_TRANSACTION_IDENTIFIER IN VARCHAR2 DEFAULT NULL
56: ,P_TRANSACTION_DOCUMENT IN CLOB DEFAULT NULL
57: ,P_VALIDATE IN NUMBER default hr_api.g_false_num
58: )
59: is
60:
61: l_TRANSACTION_ID hr_api_transactions.TRANSACTION_ID%type;

Line 61: l_TRANSACTION_ID hr_api_transactions.TRANSACTION_ID%type;

57: ,P_VALIDATE IN NUMBER default hr_api.g_false_num
58: )
59: is
60:
61: l_TRANSACTION_ID hr_api_transactions.TRANSACTION_ID%type;
62: l_creator_role hr_api_transactions.creator_role%type;
63: l_last_update_role hr_api_transactions.last_update_role%type;
64:
65:

Line 62: l_creator_role hr_api_transactions.creator_role%type;

58: )
59: is
60:
61: l_TRANSACTION_ID hr_api_transactions.TRANSACTION_ID%type;
62: l_creator_role hr_api_transactions.creator_role%type;
63: l_last_update_role hr_api_transactions.last_update_role%type;
64:
65:
66: PRAGMA AUTONOMOUS_TRANSACTION;

Line 63: l_last_update_role hr_api_transactions.last_update_role%type;

59: is
60:
61: l_TRANSACTION_ID hr_api_transactions.TRANSACTION_ID%type;
62: l_creator_role hr_api_transactions.creator_role%type;
63: l_last_update_role hr_api_transactions.last_update_role%type;
64:
65:
66: PRAGMA AUTONOMOUS_TRANSACTION;
67: begin

Line 110: If P_VALIDATE = hr_api.g_false_num Then

106:
107:
108:
109: );
110: If P_VALIDATE = hr_api.g_false_num Then
111: commit;
112: Else
113: rollback;
114: End If;

Line 145: ,P_VALIDATE IN NUMBER DEFAULT hr_api.g_false_num

141: ,P_PK2 IN VARCHAR2 DEFAULT NULL
142: ,P_PK3 IN VARCHAR2 DEFAULT NULL
143: ,P_PK4 IN VARCHAR2 DEFAULT NULL
144: ,P_PK5 IN VARCHAR2 DEFAULT NULL
145: ,P_VALIDATE IN NUMBER DEFAULT hr_api.g_false_num
146: ,P_OBJECT_VERSION_NUMBER IN OUT nocopy NUMBER
147: ,P_TRANSACTION_ID IN NUMBER
148: ,P_TRANSACTION_STEP_ID IN NUMBER
149: ,p_information_category in VARCHAR2 default null

Line 186: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;

182: is
183: l_proc varchar2(72) := g_package || 'create_transaction_step';
184: l_result varchar2(100);
185: l_trns_object_version_number number;
186: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;
187: PRAGMA AUTONOMOUS_TRANSACTION;
188: begin
189: --savepoint create_transaction_step;
190: l_transaction_step_id := P_TRANSACTION_STEP_ID;

Line 247: If P_VALIDATE = hr_api.g_false_num Then

243: p_information29 => p_information29,
244: p_information30 => p_information30,
245: p_validate => false
246: );
247: If P_VALIDATE = hr_api.g_false_num Then
248: commit;
249: Else
250: rollback;
251: End If;

Line 289: ,P_VALIDATE IN NUMBER default hr_api.g_false_num

285: ,P_RELAUNCH_FUNCTION IN VARCHAR2 DEFAULT NULL
286: ,P_TRANSACTION_GROUP IN VARCHAR2 DEFAULT NULL
287: ,P_TRANSACTION_IDENTIFIER IN VARCHAR2 DEFAULT NULL
288: ,P_TRANSACTION_DOCUMENT IN CLOB DEFAULT NULL
289: ,P_VALIDATE IN NUMBER default hr_api.g_false_num
290: )
291: is
292: l_proc varchar2(72) := 'update_transaction';
293: l_last_update_role hr_api_transactions.last_update_role%type;

Line 293: l_last_update_role hr_api_transactions.last_update_role%type;

289: ,P_VALIDATE IN NUMBER default hr_api.g_false_num
290: )
291: is
292: l_proc varchar2(72) := 'update_transaction';
293: l_last_update_role hr_api_transactions.last_update_role%type;
294: PRAGMA AUTONOMOUS_TRANSACTION;
295: begin
296: --savepoint update_transaction;
297: l_last_update_role := nvl(P_LAST_UPDATE_ROLE, 'PER:' || fnd_global.employee_id);

Line 330: If P_VALIDATE = hr_api.g_false_num Then

326: ,p_transaction_identifier => p_transaction_identifier
327: ,p_transaction_document => p_transaction_document
328: ,p_transaction_state => p_transaction_state -- Heena
329: );
330: If P_VALIDATE = hr_api.g_false_num Then
331: commit;
332: Else
333: rollback;
334: End If;

Line 365: ,P_VALIDATE IN NUMBER default hr_api.g_false_num

361: ,P_PK2 IN VARCHAR2 DEFAULT NULL
362: ,P_PK3 IN VARCHAR2 DEFAULT NULL
363: ,P_PK4 IN VARCHAR2 DEFAULT NULL
364: ,P_PK5 IN VARCHAR2 DEFAULT NULL
365: ,P_VALIDATE IN NUMBER default hr_api.g_false_num
366: ,P_OBJECT_VERSION_NUMBER IN OUT nocopy NUMBER
367: ,P_TRANSACTION_ID IN NUMBER
368: ,P_TRANSACTION_STEP_ID IN NUMBER
369: ,p_information_category in VARCHAR2 default hr_api.g_varchar2

Line 369: ,p_information_category in VARCHAR2 default hr_api.g_varchar2

365: ,P_VALIDATE IN NUMBER default hr_api.g_false_num
366: ,P_OBJECT_VERSION_NUMBER IN OUT nocopy NUMBER
367: ,P_TRANSACTION_ID IN NUMBER
368: ,P_TRANSACTION_STEP_ID IN NUMBER
369: ,p_information_category in VARCHAR2 default hr_api.g_varchar2
370: ,p_information1 in VARCHAR2 default hr_api.g_varchar2
371: ,p_information2 in VARCHAR2 default hr_api.g_varchar2
372: ,p_information3 in VARCHAR2 default hr_api.g_varchar2
373: ,p_information4 in VARCHAR2 default hr_api.g_varchar2

Line 370: ,p_information1 in VARCHAR2 default hr_api.g_varchar2

366: ,P_OBJECT_VERSION_NUMBER IN OUT nocopy NUMBER
367: ,P_TRANSACTION_ID IN NUMBER
368: ,P_TRANSACTION_STEP_ID IN NUMBER
369: ,p_information_category in VARCHAR2 default hr_api.g_varchar2
370: ,p_information1 in VARCHAR2 default hr_api.g_varchar2
371: ,p_information2 in VARCHAR2 default hr_api.g_varchar2
372: ,p_information3 in VARCHAR2 default hr_api.g_varchar2
373: ,p_information4 in VARCHAR2 default hr_api.g_varchar2
374: ,p_information5 in VARCHAR2 default hr_api.g_varchar2

Line 371: ,p_information2 in VARCHAR2 default hr_api.g_varchar2

367: ,P_TRANSACTION_ID IN NUMBER
368: ,P_TRANSACTION_STEP_ID IN NUMBER
369: ,p_information_category in VARCHAR2 default hr_api.g_varchar2
370: ,p_information1 in VARCHAR2 default hr_api.g_varchar2
371: ,p_information2 in VARCHAR2 default hr_api.g_varchar2
372: ,p_information3 in VARCHAR2 default hr_api.g_varchar2
373: ,p_information4 in VARCHAR2 default hr_api.g_varchar2
374: ,p_information5 in VARCHAR2 default hr_api.g_varchar2
375: ,p_information6 in VARCHAR2 default hr_api.g_varchar2

Line 372: ,p_information3 in VARCHAR2 default hr_api.g_varchar2

368: ,P_TRANSACTION_STEP_ID IN NUMBER
369: ,p_information_category in VARCHAR2 default hr_api.g_varchar2
370: ,p_information1 in VARCHAR2 default hr_api.g_varchar2
371: ,p_information2 in VARCHAR2 default hr_api.g_varchar2
372: ,p_information3 in VARCHAR2 default hr_api.g_varchar2
373: ,p_information4 in VARCHAR2 default hr_api.g_varchar2
374: ,p_information5 in VARCHAR2 default hr_api.g_varchar2
375: ,p_information6 in VARCHAR2 default hr_api.g_varchar2
376: ,p_information7 in VARCHAR2 default hr_api.g_varchar2

Line 373: ,p_information4 in VARCHAR2 default hr_api.g_varchar2

369: ,p_information_category in VARCHAR2 default hr_api.g_varchar2
370: ,p_information1 in VARCHAR2 default hr_api.g_varchar2
371: ,p_information2 in VARCHAR2 default hr_api.g_varchar2
372: ,p_information3 in VARCHAR2 default hr_api.g_varchar2
373: ,p_information4 in VARCHAR2 default hr_api.g_varchar2
374: ,p_information5 in VARCHAR2 default hr_api.g_varchar2
375: ,p_information6 in VARCHAR2 default hr_api.g_varchar2
376: ,p_information7 in VARCHAR2 default hr_api.g_varchar2
377: ,p_information8 in VARCHAR2 default hr_api.g_varchar2

Line 374: ,p_information5 in VARCHAR2 default hr_api.g_varchar2

370: ,p_information1 in VARCHAR2 default hr_api.g_varchar2
371: ,p_information2 in VARCHAR2 default hr_api.g_varchar2
372: ,p_information3 in VARCHAR2 default hr_api.g_varchar2
373: ,p_information4 in VARCHAR2 default hr_api.g_varchar2
374: ,p_information5 in VARCHAR2 default hr_api.g_varchar2
375: ,p_information6 in VARCHAR2 default hr_api.g_varchar2
376: ,p_information7 in VARCHAR2 default hr_api.g_varchar2
377: ,p_information8 in VARCHAR2 default hr_api.g_varchar2
378: ,p_information9 in VARCHAR2 default hr_api.g_varchar2

Line 375: ,p_information6 in VARCHAR2 default hr_api.g_varchar2

371: ,p_information2 in VARCHAR2 default hr_api.g_varchar2
372: ,p_information3 in VARCHAR2 default hr_api.g_varchar2
373: ,p_information4 in VARCHAR2 default hr_api.g_varchar2
374: ,p_information5 in VARCHAR2 default hr_api.g_varchar2
375: ,p_information6 in VARCHAR2 default hr_api.g_varchar2
376: ,p_information7 in VARCHAR2 default hr_api.g_varchar2
377: ,p_information8 in VARCHAR2 default hr_api.g_varchar2
378: ,p_information9 in VARCHAR2 default hr_api.g_varchar2
379: ,p_information10 in VARCHAR2 default hr_api.g_varchar2

Line 376: ,p_information7 in VARCHAR2 default hr_api.g_varchar2

372: ,p_information3 in VARCHAR2 default hr_api.g_varchar2
373: ,p_information4 in VARCHAR2 default hr_api.g_varchar2
374: ,p_information5 in VARCHAR2 default hr_api.g_varchar2
375: ,p_information6 in VARCHAR2 default hr_api.g_varchar2
376: ,p_information7 in VARCHAR2 default hr_api.g_varchar2
377: ,p_information8 in VARCHAR2 default hr_api.g_varchar2
378: ,p_information9 in VARCHAR2 default hr_api.g_varchar2
379: ,p_information10 in VARCHAR2 default hr_api.g_varchar2
380: ,p_information11 in VARCHAR2 default hr_api.g_varchar2

Line 377: ,p_information8 in VARCHAR2 default hr_api.g_varchar2

373: ,p_information4 in VARCHAR2 default hr_api.g_varchar2
374: ,p_information5 in VARCHAR2 default hr_api.g_varchar2
375: ,p_information6 in VARCHAR2 default hr_api.g_varchar2
376: ,p_information7 in VARCHAR2 default hr_api.g_varchar2
377: ,p_information8 in VARCHAR2 default hr_api.g_varchar2
378: ,p_information9 in VARCHAR2 default hr_api.g_varchar2
379: ,p_information10 in VARCHAR2 default hr_api.g_varchar2
380: ,p_information11 in VARCHAR2 default hr_api.g_varchar2
381: ,p_information12 in VARCHAR2 default hr_api.g_varchar2

Line 378: ,p_information9 in VARCHAR2 default hr_api.g_varchar2

374: ,p_information5 in VARCHAR2 default hr_api.g_varchar2
375: ,p_information6 in VARCHAR2 default hr_api.g_varchar2
376: ,p_information7 in VARCHAR2 default hr_api.g_varchar2
377: ,p_information8 in VARCHAR2 default hr_api.g_varchar2
378: ,p_information9 in VARCHAR2 default hr_api.g_varchar2
379: ,p_information10 in VARCHAR2 default hr_api.g_varchar2
380: ,p_information11 in VARCHAR2 default hr_api.g_varchar2
381: ,p_information12 in VARCHAR2 default hr_api.g_varchar2
382: ,p_information13 in VARCHAR2 default hr_api.g_varchar2

Line 379: ,p_information10 in VARCHAR2 default hr_api.g_varchar2

375: ,p_information6 in VARCHAR2 default hr_api.g_varchar2
376: ,p_information7 in VARCHAR2 default hr_api.g_varchar2
377: ,p_information8 in VARCHAR2 default hr_api.g_varchar2
378: ,p_information9 in VARCHAR2 default hr_api.g_varchar2
379: ,p_information10 in VARCHAR2 default hr_api.g_varchar2
380: ,p_information11 in VARCHAR2 default hr_api.g_varchar2
381: ,p_information12 in VARCHAR2 default hr_api.g_varchar2
382: ,p_information13 in VARCHAR2 default hr_api.g_varchar2
383: ,p_information14 in VARCHAR2 default hr_api.g_varchar2

Line 380: ,p_information11 in VARCHAR2 default hr_api.g_varchar2

376: ,p_information7 in VARCHAR2 default hr_api.g_varchar2
377: ,p_information8 in VARCHAR2 default hr_api.g_varchar2
378: ,p_information9 in VARCHAR2 default hr_api.g_varchar2
379: ,p_information10 in VARCHAR2 default hr_api.g_varchar2
380: ,p_information11 in VARCHAR2 default hr_api.g_varchar2
381: ,p_information12 in VARCHAR2 default hr_api.g_varchar2
382: ,p_information13 in VARCHAR2 default hr_api.g_varchar2
383: ,p_information14 in VARCHAR2 default hr_api.g_varchar2
384: ,p_information15 in VARCHAR2 default hr_api.g_varchar2

Line 381: ,p_information12 in VARCHAR2 default hr_api.g_varchar2

377: ,p_information8 in VARCHAR2 default hr_api.g_varchar2
378: ,p_information9 in VARCHAR2 default hr_api.g_varchar2
379: ,p_information10 in VARCHAR2 default hr_api.g_varchar2
380: ,p_information11 in VARCHAR2 default hr_api.g_varchar2
381: ,p_information12 in VARCHAR2 default hr_api.g_varchar2
382: ,p_information13 in VARCHAR2 default hr_api.g_varchar2
383: ,p_information14 in VARCHAR2 default hr_api.g_varchar2
384: ,p_information15 in VARCHAR2 default hr_api.g_varchar2
385: ,p_information16 in VARCHAR2 default hr_api.g_varchar2

Line 382: ,p_information13 in VARCHAR2 default hr_api.g_varchar2

378: ,p_information9 in VARCHAR2 default hr_api.g_varchar2
379: ,p_information10 in VARCHAR2 default hr_api.g_varchar2
380: ,p_information11 in VARCHAR2 default hr_api.g_varchar2
381: ,p_information12 in VARCHAR2 default hr_api.g_varchar2
382: ,p_information13 in VARCHAR2 default hr_api.g_varchar2
383: ,p_information14 in VARCHAR2 default hr_api.g_varchar2
384: ,p_information15 in VARCHAR2 default hr_api.g_varchar2
385: ,p_information16 in VARCHAR2 default hr_api.g_varchar2
386: ,p_information17 in VARCHAR2 default hr_api.g_varchar2

Line 383: ,p_information14 in VARCHAR2 default hr_api.g_varchar2

379: ,p_information10 in VARCHAR2 default hr_api.g_varchar2
380: ,p_information11 in VARCHAR2 default hr_api.g_varchar2
381: ,p_information12 in VARCHAR2 default hr_api.g_varchar2
382: ,p_information13 in VARCHAR2 default hr_api.g_varchar2
383: ,p_information14 in VARCHAR2 default hr_api.g_varchar2
384: ,p_information15 in VARCHAR2 default hr_api.g_varchar2
385: ,p_information16 in VARCHAR2 default hr_api.g_varchar2
386: ,p_information17 in VARCHAR2 default hr_api.g_varchar2
387: ,p_information18 in VARCHAR2 default hr_api.g_varchar2

Line 384: ,p_information15 in VARCHAR2 default hr_api.g_varchar2

380: ,p_information11 in VARCHAR2 default hr_api.g_varchar2
381: ,p_information12 in VARCHAR2 default hr_api.g_varchar2
382: ,p_information13 in VARCHAR2 default hr_api.g_varchar2
383: ,p_information14 in VARCHAR2 default hr_api.g_varchar2
384: ,p_information15 in VARCHAR2 default hr_api.g_varchar2
385: ,p_information16 in VARCHAR2 default hr_api.g_varchar2
386: ,p_information17 in VARCHAR2 default hr_api.g_varchar2
387: ,p_information18 in VARCHAR2 default hr_api.g_varchar2
388: ,p_information19 in VARCHAR2 default hr_api.g_varchar2

Line 385: ,p_information16 in VARCHAR2 default hr_api.g_varchar2

381: ,p_information12 in VARCHAR2 default hr_api.g_varchar2
382: ,p_information13 in VARCHAR2 default hr_api.g_varchar2
383: ,p_information14 in VARCHAR2 default hr_api.g_varchar2
384: ,p_information15 in VARCHAR2 default hr_api.g_varchar2
385: ,p_information16 in VARCHAR2 default hr_api.g_varchar2
386: ,p_information17 in VARCHAR2 default hr_api.g_varchar2
387: ,p_information18 in VARCHAR2 default hr_api.g_varchar2
388: ,p_information19 in VARCHAR2 default hr_api.g_varchar2
389: ,p_information20 in VARCHAR2 default hr_api.g_varchar2

Line 386: ,p_information17 in VARCHAR2 default hr_api.g_varchar2

382: ,p_information13 in VARCHAR2 default hr_api.g_varchar2
383: ,p_information14 in VARCHAR2 default hr_api.g_varchar2
384: ,p_information15 in VARCHAR2 default hr_api.g_varchar2
385: ,p_information16 in VARCHAR2 default hr_api.g_varchar2
386: ,p_information17 in VARCHAR2 default hr_api.g_varchar2
387: ,p_information18 in VARCHAR2 default hr_api.g_varchar2
388: ,p_information19 in VARCHAR2 default hr_api.g_varchar2
389: ,p_information20 in VARCHAR2 default hr_api.g_varchar2
390: ,p_information21 in VARCHAR2 default hr_api.g_varchar2

Line 387: ,p_information18 in VARCHAR2 default hr_api.g_varchar2

383: ,p_information14 in VARCHAR2 default hr_api.g_varchar2
384: ,p_information15 in VARCHAR2 default hr_api.g_varchar2
385: ,p_information16 in VARCHAR2 default hr_api.g_varchar2
386: ,p_information17 in VARCHAR2 default hr_api.g_varchar2
387: ,p_information18 in VARCHAR2 default hr_api.g_varchar2
388: ,p_information19 in VARCHAR2 default hr_api.g_varchar2
389: ,p_information20 in VARCHAR2 default hr_api.g_varchar2
390: ,p_information21 in VARCHAR2 default hr_api.g_varchar2
391: ,p_information22 in VARCHAR2 default hr_api.g_varchar2

Line 388: ,p_information19 in VARCHAR2 default hr_api.g_varchar2

384: ,p_information15 in VARCHAR2 default hr_api.g_varchar2
385: ,p_information16 in VARCHAR2 default hr_api.g_varchar2
386: ,p_information17 in VARCHAR2 default hr_api.g_varchar2
387: ,p_information18 in VARCHAR2 default hr_api.g_varchar2
388: ,p_information19 in VARCHAR2 default hr_api.g_varchar2
389: ,p_information20 in VARCHAR2 default hr_api.g_varchar2
390: ,p_information21 in VARCHAR2 default hr_api.g_varchar2
391: ,p_information22 in VARCHAR2 default hr_api.g_varchar2
392: ,p_information23 in VARCHAR2 default hr_api.g_varchar2

Line 389: ,p_information20 in VARCHAR2 default hr_api.g_varchar2

385: ,p_information16 in VARCHAR2 default hr_api.g_varchar2
386: ,p_information17 in VARCHAR2 default hr_api.g_varchar2
387: ,p_information18 in VARCHAR2 default hr_api.g_varchar2
388: ,p_information19 in VARCHAR2 default hr_api.g_varchar2
389: ,p_information20 in VARCHAR2 default hr_api.g_varchar2
390: ,p_information21 in VARCHAR2 default hr_api.g_varchar2
391: ,p_information22 in VARCHAR2 default hr_api.g_varchar2
392: ,p_information23 in VARCHAR2 default hr_api.g_varchar2
393: ,p_information24 in VARCHAR2 default hr_api.g_varchar2

Line 390: ,p_information21 in VARCHAR2 default hr_api.g_varchar2

386: ,p_information17 in VARCHAR2 default hr_api.g_varchar2
387: ,p_information18 in VARCHAR2 default hr_api.g_varchar2
388: ,p_information19 in VARCHAR2 default hr_api.g_varchar2
389: ,p_information20 in VARCHAR2 default hr_api.g_varchar2
390: ,p_information21 in VARCHAR2 default hr_api.g_varchar2
391: ,p_information22 in VARCHAR2 default hr_api.g_varchar2
392: ,p_information23 in VARCHAR2 default hr_api.g_varchar2
393: ,p_information24 in VARCHAR2 default hr_api.g_varchar2
394: ,p_information25 in VARCHAR2 default hr_api.g_varchar2

Line 391: ,p_information22 in VARCHAR2 default hr_api.g_varchar2

387: ,p_information18 in VARCHAR2 default hr_api.g_varchar2
388: ,p_information19 in VARCHAR2 default hr_api.g_varchar2
389: ,p_information20 in VARCHAR2 default hr_api.g_varchar2
390: ,p_information21 in VARCHAR2 default hr_api.g_varchar2
391: ,p_information22 in VARCHAR2 default hr_api.g_varchar2
392: ,p_information23 in VARCHAR2 default hr_api.g_varchar2
393: ,p_information24 in VARCHAR2 default hr_api.g_varchar2
394: ,p_information25 in VARCHAR2 default hr_api.g_varchar2
395: ,p_information26 in VARCHAR2 default hr_api.g_varchar2

Line 392: ,p_information23 in VARCHAR2 default hr_api.g_varchar2

388: ,p_information19 in VARCHAR2 default hr_api.g_varchar2
389: ,p_information20 in VARCHAR2 default hr_api.g_varchar2
390: ,p_information21 in VARCHAR2 default hr_api.g_varchar2
391: ,p_information22 in VARCHAR2 default hr_api.g_varchar2
392: ,p_information23 in VARCHAR2 default hr_api.g_varchar2
393: ,p_information24 in VARCHAR2 default hr_api.g_varchar2
394: ,p_information25 in VARCHAR2 default hr_api.g_varchar2
395: ,p_information26 in VARCHAR2 default hr_api.g_varchar2
396: ,p_information27 in VARCHAR2 default hr_api.g_varchar2

Line 393: ,p_information24 in VARCHAR2 default hr_api.g_varchar2

389: ,p_information20 in VARCHAR2 default hr_api.g_varchar2
390: ,p_information21 in VARCHAR2 default hr_api.g_varchar2
391: ,p_information22 in VARCHAR2 default hr_api.g_varchar2
392: ,p_information23 in VARCHAR2 default hr_api.g_varchar2
393: ,p_information24 in VARCHAR2 default hr_api.g_varchar2
394: ,p_information25 in VARCHAR2 default hr_api.g_varchar2
395: ,p_information26 in VARCHAR2 default hr_api.g_varchar2
396: ,p_information27 in VARCHAR2 default hr_api.g_varchar2
397: ,p_information28 in VARCHAR2 default hr_api.g_varchar2

Line 394: ,p_information25 in VARCHAR2 default hr_api.g_varchar2

390: ,p_information21 in VARCHAR2 default hr_api.g_varchar2
391: ,p_information22 in VARCHAR2 default hr_api.g_varchar2
392: ,p_information23 in VARCHAR2 default hr_api.g_varchar2
393: ,p_information24 in VARCHAR2 default hr_api.g_varchar2
394: ,p_information25 in VARCHAR2 default hr_api.g_varchar2
395: ,p_information26 in VARCHAR2 default hr_api.g_varchar2
396: ,p_information27 in VARCHAR2 default hr_api.g_varchar2
397: ,p_information28 in VARCHAR2 default hr_api.g_varchar2
398: ,p_information29 in VARCHAR2 default hr_api.g_varchar2

Line 395: ,p_information26 in VARCHAR2 default hr_api.g_varchar2

391: ,p_information22 in VARCHAR2 default hr_api.g_varchar2
392: ,p_information23 in VARCHAR2 default hr_api.g_varchar2
393: ,p_information24 in VARCHAR2 default hr_api.g_varchar2
394: ,p_information25 in VARCHAR2 default hr_api.g_varchar2
395: ,p_information26 in VARCHAR2 default hr_api.g_varchar2
396: ,p_information27 in VARCHAR2 default hr_api.g_varchar2
397: ,p_information28 in VARCHAR2 default hr_api.g_varchar2
398: ,p_information29 in VARCHAR2 default hr_api.g_varchar2
399: ,p_information30 in VARCHAR2 default hr_api.g_varchar2

Line 396: ,p_information27 in VARCHAR2 default hr_api.g_varchar2

392: ,p_information23 in VARCHAR2 default hr_api.g_varchar2
393: ,p_information24 in VARCHAR2 default hr_api.g_varchar2
394: ,p_information25 in VARCHAR2 default hr_api.g_varchar2
395: ,p_information26 in VARCHAR2 default hr_api.g_varchar2
396: ,p_information27 in VARCHAR2 default hr_api.g_varchar2
397: ,p_information28 in VARCHAR2 default hr_api.g_varchar2
398: ,p_information29 in VARCHAR2 default hr_api.g_varchar2
399: ,p_information30 in VARCHAR2 default hr_api.g_varchar2
400: )

Line 397: ,p_information28 in VARCHAR2 default hr_api.g_varchar2

393: ,p_information24 in VARCHAR2 default hr_api.g_varchar2
394: ,p_information25 in VARCHAR2 default hr_api.g_varchar2
395: ,p_information26 in VARCHAR2 default hr_api.g_varchar2
396: ,p_information27 in VARCHAR2 default hr_api.g_varchar2
397: ,p_information28 in VARCHAR2 default hr_api.g_varchar2
398: ,p_information29 in VARCHAR2 default hr_api.g_varchar2
399: ,p_information30 in VARCHAR2 default hr_api.g_varchar2
400: )
401: is

Line 398: ,p_information29 in VARCHAR2 default hr_api.g_varchar2

394: ,p_information25 in VARCHAR2 default hr_api.g_varchar2
395: ,p_information26 in VARCHAR2 default hr_api.g_varchar2
396: ,p_information27 in VARCHAR2 default hr_api.g_varchar2
397: ,p_information28 in VARCHAR2 default hr_api.g_varchar2
398: ,p_information29 in VARCHAR2 default hr_api.g_varchar2
399: ,p_information30 in VARCHAR2 default hr_api.g_varchar2
400: )
401: is
402: l_proc varchar2(72) := 'update_transaction_step';

Line 399: ,p_information30 in VARCHAR2 default hr_api.g_varchar2

395: ,p_information26 in VARCHAR2 default hr_api.g_varchar2
396: ,p_information27 in VARCHAR2 default hr_api.g_varchar2
397: ,p_information28 in VARCHAR2 default hr_api.g_varchar2
398: ,p_information29 in VARCHAR2 default hr_api.g_varchar2
399: ,p_information30 in VARCHAR2 default hr_api.g_varchar2
400: )
401: is
402: l_proc varchar2(72) := 'update_transaction_step';
403: l_result varchar2(100);

Line 462: If P_VALIDATE = hr_api.g_false_num Then

458: p_information29 => p_information29,
459: p_information30 => p_information30,
460: p_validate => false
461: );
462: If P_VALIDATE = hr_api.g_false_num Then
463: commit;
464: Else
465: rollback;
466: End If;

Line 476: ,p_validate in number default hr_api.g_false_num

472: procedure delete_transaction_step
473: ( p_transaction_step_id in number
474: ,p_person_id in number
475: ,p_object_version_number in number
476: ,p_validate in number default hr_api.g_false_num
477: ) is
478: --
479: l_proc constant varchar2(100) := g_package || ' delete_transaction_step';
480: PRAGMA AUTONOMOUS_TRANSACTION;

Line 489: If p_validate = hr_api.g_false_num Then

485: ,p_transaction_step_id => p_transaction_step_id
486: ,p_person_id => p_person_id
487: ,p_object_version_number => p_object_version_number
488: );
489: If p_validate = hr_api.g_false_num Then
490: commit;
491: Else
492: rollback;
493: End If;

Line 533: gmisc_value in date default hr_api.g_date)

529:
530: Function getDateValue(
531: commitNode in xmldom.DOMNode,
532: attributeName in VARCHAR2,
533: gmisc_value in date default hr_api.g_date)
534: return DATE IS
535: l_date DATE;
536: l_isNull VARCHAR2(10);
537: l_string VARCHAR2(100);

Line 566: gmisc_value in varchar2 default hr_api.g_varchar2)

562:
563: Function getVarchar2Value(
564: commitNode in xmldom.DOMNode,
565: attributeName in VARCHAR2,
566: gmisc_value in varchar2 default hr_api.g_varchar2)
567: return varchar2 IS
568: l_varchar2 VARCHAR2(4000);
569: l_isNull VARCHAR2(10);
570: l_element xmldom.DOMElement;

Line 590: gmisc_value in number default hr_api.g_number)

586:
587: Function getNumberValue(
588: commitNode in xmldom.DOMNode,
589: attributeName in VARCHAR2,
590: gmisc_value in number default hr_api.g_number)
591: return NUMBER IS
592: l_number NUMBER;
593: l_isNull VARCHAR2(22);
594: l_element xmldom.DOMElement;

Line 646: p_validate in number default hr_api.g_false_num,

642:
643: Function process_api_internal(
644: p_transaction_id in number,
645: p_root_node in xmldom.DOMNode,
646: p_validate in number default hr_api.g_false_num,
647: p_effective_date in DATE,
648: p_return_status in varchar2)
649: return VARCHAR2 IS
650:

Line 653: from hr_api_transaction_steps

649: return VARCHAR2 IS
650:
651: cursor csr_hat_steps(p_Api_Name in varchar2) is
652: select *
653: from hr_api_transaction_steps
654: where transaction_id=p_transaction_id
655: and API_NAME = p_Api_Name
656: and OBJECT_TYPE is null;
657:

Line 753: p_validate in number default hr_api.g_false_num,

749: Function process_api_call(
750: p_transaction_step_id in NUMBER,
751: p_api_name in VARCHAR2,
752: p_root_node in xmldom.DOMNode,
753: p_validate in number default hr_api.g_false_num,
754: p_effective_date in DATE,
755: p_return_status in varchar2)
756: return VARCHAR2 IS
757: l_procapi_retstat_out VARCHAR2(1);

Line 857: from hr_api_transactions hat

853: hat.transaction_effective_date,
854: hat.process_name,
855: hat.transaction_state,
856: hat.effective_date_option
857: from hr_api_transactions hat
858: where hat.transaction_id =p_transaction_id;
859: step_row csr_hat%rowtype;
860: l_proc varchar2(72) := g_package || 'set_transaction_context';
861: Begin

Line 1064: p_validate in NUMBER default hr_api.g_false_num)

1060:
1061:
1062: procedure delete_transaction(
1063: p_transaction_id in NUMBER,
1064: p_validate in NUMBER default hr_api.g_false_num)
1065: is
1066: l_proc varchar2(72) := g_package || 'delete_transaction';
1067: begin
1068: hr_utility.set_location(' Entering:' || l_proc,10);

Line 1074: p_validate => (p_validate=hr_api.g_true_num));

1070: delete_transaction_children(p_transaction_id, p_validate);
1071: hr_sflutil_ss.closesflnotifications(p_transaction_id,null,null);
1072: hr_transaction_api.rollback_transaction(
1073: p_transaction_id => p_transaction_id,
1074: p_validate => (p_validate=hr_api.g_true_num));
1075: hr_utility.set_location(' Exiting :' || l_proc,20);
1076: end delete_transaction;
1077:
1078: function convertCLOBtoXMLElement(

Line 1107: c_updateStatus hr_api_transactions.status%type;

1103: PRAGMA AUTONOMOUS_TRANSACTION;
1104: --
1105: -- local variables
1106: c_proc constant varchar2(30) := 'setTransactionStatus';
1107: c_updateStatus hr_api_transactions.status%type;
1108: ln_notification_id wf_notifications.notification_id%type;
1109: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
1110:
1111: begin

Line 1109: lr_hr_api_transaction_rec hr_api_transactions%rowtype;

1105: -- local variables
1106: c_proc constant varchar2(30) := 'setTransactionStatus';
1107: c_updateStatus hr_api_transactions.status%type;
1108: ln_notification_id wf_notifications.notification_id%type;
1109: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
1110:
1111: begin
1112: -- check if debug enabled
1113: if g_debug then

Line 1172: lr_hr_api_transaction_rec hr_api_transactions%rowtype;

1168: return varchar2
1169: is
1170: -- local variables
1171: editAllowed varchar2(1);
1172: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
1173: l_authenticateNtf boolean;
1174: begin
1175:
1176: -- check if we need to propagate the error messages

Line 1177: if(p_propagateMessagePub=hr_api.g_true_num) then

1173: l_authenticateNtf boolean;
1174: begin
1175:
1176: -- check if we need to propagate the error messages
1177: if(p_propagateMessagePub=hr_api.g_true_num) then
1178: hr_multi_message.enable_message_list;
1179: end if;
1180:
1181: -- set the default return satatus

Line 1185: if((p_authenticateNtf is null) or (p_authenticateNtf=hr_api.g_true_num)) then

1181: -- set the default return satatus
1182: editAllowed :='N';
1183:
1184: -- set the default ntf authentication
1185: if((p_authenticateNtf is null) or (p_authenticateNtf=hr_api.g_true_num)) then
1186: l_authenticateNtf := true;
1187: else
1188: l_authenticateNtf := false;
1189: end if;

Line 1223: select * into lr_hr_api_transaction_rec

1219:
1220: if(p_transaction_id is not null) then
1221: -- get the transaction details
1222: begin
1223: select * into lr_hr_api_transaction_rec
1224: from hr_api_transactions
1225: where transaction_id=p_transaction_id;
1226: exception
1227: when others then

Line 1224: from hr_api_transactions

1220: if(p_transaction_id is not null) then
1221: -- get the transaction details
1222: begin
1223: select * into lr_hr_api_transaction_rec
1224: from hr_api_transactions
1225: where transaction_id=p_transaction_id;
1226: exception
1227: when others then
1228: editAllowed :='N';

Line 1232: and isTxnOwner(null,lr_hr_api_transaction_rec.creator_person_id)) then

1228: editAllowed :='N';
1229: end;
1230:
1231: if(p_transaction_status not in ('Y','YS','RO','ROS')
1232: and isTxnOwner(null,lr_hr_api_transaction_rec.creator_person_id)) then
1233: -- it is the creator editing the transaction
1234: editAllowed := 'Y';
1235: return editAllowed;
1236: elsif(p_transaction_status in ('Y','YS','RO','ROS' )) then

Line 1240: if(fnd_global.user_name=wf_engine.getitemattrtext(lr_hr_api_transaction_rec.item_type,

1236: elsif(p_transaction_status in ('Y','YS','RO','ROS' )) then
1237: -- case where approvers trying to edit
1238:
1239: -- check if the login person is the approver
1240: if(fnd_global.user_name=wf_engine.getitemattrtext(lr_hr_api_transaction_rec.item_type,
1241: lr_hr_api_transaction_rec.item_key,
1242: 'FORWARD_TO_USERNAME',true)) then
1243: -- check the profile if the system is configured for approvers editing
1244: IF ( nvl(fnd_profile.value('PQH_ALLOW_APPROVER_TO_EDIT_TXN'),'N') = 'Y' ) THEN

Line 1241: lr_hr_api_transaction_rec.item_key,

1237: -- case where approvers trying to edit
1238:
1239: -- check if the login person is the approver
1240: if(fnd_global.user_name=wf_engine.getitemattrtext(lr_hr_api_transaction_rec.item_type,
1241: lr_hr_api_transaction_rec.item_key,
1242: 'FORWARD_TO_USERNAME',true)) then
1243: -- check the profile if the system is configured for approvers editing
1244: IF ( nvl(fnd_profile.value('PQH_ALLOW_APPROVER_TO_EDIT_TXN'),'N') = 'Y' ) THEN
1245: -- add specific override logic here

Line 1249: if(wf_engine.getitemattrtext(lr_hr_api_transaction_rec.item_type,

1245: -- add specific override logic here
1246: -- case 1: check the programatic overide for the flow
1247: -- wf item attribute HR_RESTRICT_EDIT_ATTR
1248:
1249: if(wf_engine.getitemattrtext(lr_hr_api_transaction_rec.item_type,
1250: lr_hr_api_transaction_rec.item_key,
1251: 'HR_RESTRICT_EDIT_ATTR',true)='Y') then
1252: editAllowed := 'N';
1253: return editAllowed;

Line 1250: lr_hr_api_transaction_rec.item_key,

1246: -- case 1: check the programatic overide for the flow
1247: -- wf item attribute HR_RESTRICT_EDIT_ATTR
1248:
1249: if(wf_engine.getitemattrtext(lr_hr_api_transaction_rec.item_type,
1250: lr_hr_api_transaction_rec.item_key,
1251: 'HR_RESTRICT_EDIT_ATTR',true)='Y') then
1252: editAllowed := 'N';
1253: return editAllowed;
1254: end if;

Line 1258: if(lr_hr_api_transaction_rec.transaction_ref_table='PER_APPRAISALS') then

1254: end if;
1255:
1256: -- case 2: Functional module layer
1257: -- appraisal specific, not edit allowed for now by approvers
1258: if(lr_hr_api_transaction_rec.transaction_ref_table='PER_APPRAISALS') then
1259: editAllowed := 'N';
1260: -- no more checks return
1261: return editAllowed;
1262: end if;

Line 1277: IF (p_propagateMessagePub=hr_api.g_true_num) THEN

1273: end if; -- approver check
1274: end if; -- transaction status check
1275: end if; -- transaction id null check
1276: -- disable the message propagation
1277: IF (p_propagateMessagePub=hr_api.g_true_num) THEN
1278: hr_multi_message.disable_message_list;
1279: END IF;
1280:
1281: return editAllowed;

Line 1299: lr_hr_api_transaction_rec hr_api_transactions%rowtype;

1295: return varchar2
1296: is
1297: -- local variables
1298: deleteAllowed varchar2(1);
1299: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
1300: l_authenticateNtf boolean;
1301: begin
1302:
1303: -- set default

Line 1306: if(p_propagateMessagePub=hr_api.g_true_num) then

1302:
1303: -- set default
1304: deleteAllowed :='N';
1305: -- check if we need to propagate the error messages
1306: if(p_propagateMessagePub=hr_api.g_true_num) then
1307: hr_multi_message.enable_message_list;
1308: end if;
1309:
1310: -- set the default ntf authentication

Line 1311: if((p_authenticateNtf is null) or (p_authenticateNtf=hr_api.g_true_num)) then

1307: hr_multi_message.enable_message_list;
1308: end if;
1309:
1310: -- set the default ntf authentication
1311: if((p_authenticateNtf is null) or (p_authenticateNtf=hr_api.g_true_num)) then
1312: l_authenticateNtf := true;
1313: else
1314: l_authenticateNtf := false;
1315: end if;

Line 1350: select * into lr_hr_api_transaction_rec

1346:
1347: if(p_transaction_id is not null) then
1348: -- get the transaction details
1349: begin
1350: select * into lr_hr_api_transaction_rec
1351: from hr_api_transactions
1352: where transaction_id=p_transaction_id;
1353: exception
1354: when others then

Line 1351: from hr_api_transactions

1347: if(p_transaction_id is not null) then
1348: -- get the transaction details
1349: begin
1350: select * into lr_hr_api_transaction_rec
1351: from hr_api_transactions
1352: where transaction_id=p_transaction_id;
1353: exception
1354: when others then
1355: deleteAllowed :='N';

Line 1359: and isTxnOwner(null,lr_hr_api_transaction_rec.creator_person_id)) then

1355: deleteAllowed :='N';
1356: end;
1357:
1358: if(p_transaction_status not in ('Y','YS','RO','ROS')
1359: and isTxnOwner(null,lr_hr_api_transaction_rec.creator_person_id)) then
1360: -- it is the creator editing the transaction
1361: deleteAllowed := 'Y';
1362: else
1363: deleteAllowed :='N';

Line 1367: IF (p_propagateMessagePub=hr_api.g_true_num) THEN

1363: deleteAllowed :='N';
1364: end if;
1365:
1366: -- disable the message propagation
1367: IF (p_propagateMessagePub=hr_api.g_true_num) THEN
1368: hr_multi_message.disable_message_list;
1369: END IF;
1370: end if;
1371:

Line 1488: lr_hr_api_transaction_rec hr_api_transactions%rowtype;

1484: p_transaction_type in varchar2,
1485: p_item_type in varchar2,
1486: p_item_key in varchar2)
1487: is
1488: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
1489: lv_result varchar2(100);
1490: ln_notification_id wf_notifications.notification_id%type;
1491: ln_activity_id wf_item_activity_statuses.process_activity%type;
1492: begin

Line 1548: lr_hr_api_transaction_rec hr_api_transactions%rowtype;

1544: end othersDeleteAction;
1545:
1546: procedure deleteAction(p_transaction_id in number)
1547: is
1548: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
1549: lv_result varchar2(100);
1550: begin
1551: -- this routine is called from all actions UI
1552: --

Line 1569: select * into lr_hr_api_transaction_rec

1565:
1566: */
1567: if(p_transaction_id is not null) then
1568: begin
1569: select * into lr_hr_api_transaction_rec
1570: from hr_api_transactions
1571: where transaction_id=p_transaction_id;
1572: exception
1573: when others then

Line 1570: from hr_api_transactions

1566: */
1567: if(p_transaction_id is not null) then
1568: begin
1569: select * into lr_hr_api_transaction_rec
1570: from hr_api_transactions
1571: where transaction_id=p_transaction_id;
1572: exception
1573: when others then
1574: raise;

Line 1578: if(isTxnOwner(null,lr_hr_api_transaction_rec.creator_person_id)) then

1574: raise;
1575: end;
1576:
1577: -- check the current owner
1578: if(isTxnOwner(null,lr_hr_api_transaction_rec.creator_person_id)) then
1579: -- do logic specific to creator
1580: ownerDeleteAction(p_transaction_id ,
1581: lr_hr_api_transaction_rec.status,
1582: lr_hr_api_transaction_rec.transaction_type,

Line 1581: lr_hr_api_transaction_rec.status,

1577: -- check the current owner
1578: if(isTxnOwner(null,lr_hr_api_transaction_rec.creator_person_id)) then
1579: -- do logic specific to creator
1580: ownerDeleteAction(p_transaction_id ,
1581: lr_hr_api_transaction_rec.status,
1582: lr_hr_api_transaction_rec.transaction_type,
1583: lr_hr_api_transaction_rec.item_type,
1584: lr_hr_api_transaction_rec.item_key);
1585: else -- approvers case

Line 1582: lr_hr_api_transaction_rec.transaction_type,

1578: if(isTxnOwner(null,lr_hr_api_transaction_rec.creator_person_id)) then
1579: -- do logic specific to creator
1580: ownerDeleteAction(p_transaction_id ,
1581: lr_hr_api_transaction_rec.status,
1582: lr_hr_api_transaction_rec.transaction_type,
1583: lr_hr_api_transaction_rec.item_type,
1584: lr_hr_api_transaction_rec.item_key);
1585: else -- approvers case
1586: othersDeleteAction(p_transaction_id ,

Line 1583: lr_hr_api_transaction_rec.item_type,

1579: -- do logic specific to creator
1580: ownerDeleteAction(p_transaction_id ,
1581: lr_hr_api_transaction_rec.status,
1582: lr_hr_api_transaction_rec.transaction_type,
1583: lr_hr_api_transaction_rec.item_type,
1584: lr_hr_api_transaction_rec.item_key);
1585: else -- approvers case
1586: othersDeleteAction(p_transaction_id ,
1587: lr_hr_api_transaction_rec.status,

Line 1584: lr_hr_api_transaction_rec.item_key);

1580: ownerDeleteAction(p_transaction_id ,
1581: lr_hr_api_transaction_rec.status,
1582: lr_hr_api_transaction_rec.transaction_type,
1583: lr_hr_api_transaction_rec.item_type,
1584: lr_hr_api_transaction_rec.item_key);
1585: else -- approvers case
1586: othersDeleteAction(p_transaction_id ,
1587: lr_hr_api_transaction_rec.status,
1588: lr_hr_api_transaction_rec.transaction_type,

Line 1587: lr_hr_api_transaction_rec.status,

1583: lr_hr_api_transaction_rec.item_type,
1584: lr_hr_api_transaction_rec.item_key);
1585: else -- approvers case
1586: othersDeleteAction(p_transaction_id ,
1587: lr_hr_api_transaction_rec.status,
1588: lr_hr_api_transaction_rec.transaction_type,
1589: lr_hr_api_transaction_rec.item_type,
1590: lr_hr_api_transaction_rec.item_key);
1591: end if;-- transaction owner check

Line 1588: lr_hr_api_transaction_rec.transaction_type,

1584: lr_hr_api_transaction_rec.item_key);
1585: else -- approvers case
1586: othersDeleteAction(p_transaction_id ,
1587: lr_hr_api_transaction_rec.status,
1588: lr_hr_api_transaction_rec.transaction_type,
1589: lr_hr_api_transaction_rec.item_type,
1590: lr_hr_api_transaction_rec.item_key);
1591: end if;-- transaction owner check
1592: end if;-- transaction id check

Line 1589: lr_hr_api_transaction_rec.item_type,

1585: else -- approvers case
1586: othersDeleteAction(p_transaction_id ,
1587: lr_hr_api_transaction_rec.status,
1588: lr_hr_api_transaction_rec.transaction_type,
1589: lr_hr_api_transaction_rec.item_type,
1590: lr_hr_api_transaction_rec.item_key);
1591: end if;-- transaction owner check
1592: end if;-- transaction id check
1593:

Line 1590: lr_hr_api_transaction_rec.item_key);

1586: othersDeleteAction(p_transaction_id ,
1587: lr_hr_api_transaction_rec.status,
1588: lr_hr_api_transaction_rec.transaction_type,
1589: lr_hr_api_transaction_rec.item_type,
1590: lr_hr_api_transaction_rec.item_key);
1591: end if;-- transaction owner check
1592: end if;-- transaction id check
1593:
1594: exception

Line 1603: lr_hr_api_transaction_rec hr_api_transactions%rowtype;

1599:
1600: procedure initiatorDeleteAction(p_transaction_id in number)
1601: is
1602: lv_result varchar2(100);
1603: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
1604: begin
1605:
1606: if(p_transaction_id is not null) then
1607: -- Read Transaction Details

Line 1609: select * into lr_hr_api_transaction_rec

1605:
1606: if(p_transaction_id is not null) then
1607: -- Read Transaction Details
1608: begin
1609: select * into lr_hr_api_transaction_rec
1610: from hr_api_transactions
1611: where transaction_id=p_transaction_id;
1612: exception
1613: when others then

Line 1610: from hr_api_transactions

1606: if(p_transaction_id is not null) then
1607: -- Read Transaction Details
1608: begin
1609: select * into lr_hr_api_transaction_rec
1610: from hr_api_transactions
1611: where transaction_id=p_transaction_id;
1612: exception
1613: when others then
1614: raise;

Line 1619: if(lr_hr_api_transaction_rec.item_type is not null) then

1615: end;
1616:
1617: -- check if WF based on non-WF based
1618:
1619: if(lr_hr_api_transaction_rec.item_type is not null) then
1620: -- WF case.
1621: -- hsundar: Delete any open SFL Notification for this txn
1622: hr_sflutil_ss.closesflnotifications(p_transaction_id
1623: ,lr_hr_api_transaction_rec.item_type

Line 1623: ,lr_hr_api_transaction_rec.item_type

1619: if(lr_hr_api_transaction_rec.item_type is not null) then
1620: -- WF case.
1621: -- hsundar: Delete any open SFL Notification for this txn
1622: hr_sflutil_ss.closesflnotifications(p_transaction_id
1623: ,lr_hr_api_transaction_rec.item_type
1624: ,lr_hr_api_transaction_rec.item_key);
1625:
1626: hr_transaction_ss.rollback_transaction(lr_hr_api_transaction_rec.item_type,
1627: lr_hr_api_transaction_rec.item_key,

Line 1624: ,lr_hr_api_transaction_rec.item_key);

1620: -- WF case.
1621: -- hsundar: Delete any open SFL Notification for this txn
1622: hr_sflutil_ss.closesflnotifications(p_transaction_id
1623: ,lr_hr_api_transaction_rec.item_type
1624: ,lr_hr_api_transaction_rec.item_key);
1625:
1626: hr_transaction_ss.rollback_transaction(lr_hr_api_transaction_rec.item_type,
1627: lr_hr_api_transaction_rec.item_key,
1628: null,

Line 1626: hr_transaction_ss.rollback_transaction(lr_hr_api_transaction_rec.item_type,

1622: hr_sflutil_ss.closesflnotifications(p_transaction_id
1623: ,lr_hr_api_transaction_rec.item_type
1624: ,lr_hr_api_transaction_rec.item_key);
1625:
1626: hr_transaction_ss.rollback_transaction(lr_hr_api_transaction_rec.item_type,
1627: lr_hr_api_transaction_rec.item_key,
1628: null,
1629: wf_engine.eng_run,
1630: lv_result);

Line 1627: lr_hr_api_transaction_rec.item_key,

1623: ,lr_hr_api_transaction_rec.item_type
1624: ,lr_hr_api_transaction_rec.item_key);
1625:
1626: hr_transaction_ss.rollback_transaction(lr_hr_api_transaction_rec.item_type,
1627: lr_hr_api_transaction_rec.item_key,
1628: null,
1629: wf_engine.eng_run,
1630: lv_result);
1631: wf_engine.abortprocess(itemtype => lr_hr_api_transaction_rec.item_type

Line 1631: wf_engine.abortprocess(itemtype => lr_hr_api_transaction_rec.item_type

1627: lr_hr_api_transaction_rec.item_key,
1628: null,
1629: wf_engine.eng_run,
1630: lv_result);
1631: wf_engine.abortprocess(itemtype => lr_hr_api_transaction_rec.item_type
1632: ,itemkey => lr_hr_api_transaction_rec.item_key
1633: ,process =>null
1634: ,result => wf_engine.eng_force
1635: ,verify_lock => true

Line 1632: ,itemkey => lr_hr_api_transaction_rec.item_key

1628: null,
1629: wf_engine.eng_run,
1630: lv_result);
1631: wf_engine.abortprocess(itemtype => lr_hr_api_transaction_rec.item_type
1632: ,itemkey => lr_hr_api_transaction_rec.item_key
1633: ,process =>null
1634: ,result => wf_engine.eng_force
1635: ,verify_lock => true
1636: ,cascade => true);

Line 1648: end if; -- End of 2nd if(lr_hr_api_transaction_rec.item_type is not null)

1644: -- close all sfl notifications
1645: hr_sflutil_ss.closesflnotifications(p_transaction_id,null,null);
1646: -- do the module specific logic
1647:
1648: end if; -- End of 2nd if(lr_hr_api_transaction_rec.item_type is not null)
1649:
1650: else
1651: -- transaction id is null raise error ??
1652: null;

Line 1665: lr_hr_api_transaction_rec hr_api_transactions%rowtype;

1661:
1662:
1663: procedure cancelAction(p_transaction_id in number)
1664: is
1665: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
1666: begin
1667:
1668: if(p_transaction_id is not null) then
1669: begin

Line 1670: select * into lr_hr_api_transaction_rec

1666: begin
1667:
1668: if(p_transaction_id is not null) then
1669: begin
1670: select * into lr_hr_api_transaction_rec
1671: from hr_api_transactions
1672: where transaction_id=p_transaction_id;
1673: exception
1674: when others then

Line 1671: from hr_api_transactions

1667:
1668: if(p_transaction_id is not null) then
1669: begin
1670: select * into lr_hr_api_transaction_rec
1671: from hr_api_transactions
1672: where transaction_id=p_transaction_id;
1673: exception
1674: when others then
1675: null;

Line 1679: if(lr_hr_api_transaction_rec.status='W') then

1675: null;
1676: end;
1677:
1678: -- check the status
1679: if(lr_hr_api_transaction_rec.status='W') then
1680: -- delete the transaction if owner
1681: -- check the current owner
1682: if(isTxnOwner(null,lr_hr_api_transaction_rec.creator_person_id)) then
1683: deleteAction(p_transaction_id);

Line 1682: if(isTxnOwner(null,lr_hr_api_transaction_rec.creator_person_id)) then

1678: -- check the status
1679: if(lr_hr_api_transaction_rec.status='W') then
1680: -- delete the transaction if owner
1681: -- check the current owner
1682: if(isTxnOwner(null,lr_hr_api_transaction_rec.creator_person_id)) then
1683: deleteAction(p_transaction_id);
1684: else
1685: -- raise error ??
1686: -- not a valid call to this action

Line 1716: lr_hr_api_transaction_rec hr_api_transactions%rowtype;

1712: p_person_id in number) return boolean
1713: is
1714: -- local variables
1715: x_returnStatus boolean;
1716: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
1717: ln_person_id number;
1718: begin
1719:
1720: -- set the default value

Line 1727: select hr_api_transactions.creator_person_id

1723:
1724: if(p_transaction_id is not null) then
1725: -- ignore passed personid
1726: -- derive from the transaction details
1727: select hr_api_transactions.creator_person_id
1728: into ln_person_id
1729: from hr_api_transactions
1730: where transaction_id=p_transaction_id;
1731: end if;

Line 1729: from hr_api_transactions

1725: -- ignore passed personid
1726: -- derive from the transaction details
1727: select hr_api_transactions.creator_person_id
1728: into ln_person_id
1729: from hr_api_transactions
1730: where transaction_id=p_transaction_id;
1731: end if;
1732:
1733: --

Line 1747: p_validate in NUMBER default hr_api.g_false_num)

1743: end isTxnOwner;
1744:
1745: procedure delete_transaction_children(
1746: p_transaction_id in NUMBER,
1747: p_validate in NUMBER default hr_api.g_false_num)
1748: is
1749: cursor csr_trn is
1750: select trn.transaction_id
1751: from hr_api_transactions trn

Line 1751: from hr_api_transactions trn

1747: p_validate in NUMBER default hr_api.g_false_num)
1748: is
1749: cursor csr_trn is
1750: select trn.transaction_id
1751: from hr_api_transactions trn
1752: where trn.parent_transaction_id = p_transaction_id;
1753: begin
1754: for csr_row in csr_trn loop
1755: delete_transaction(csr_row.transaction_id);

Line 1761: p_validate IN NUMBER DEFAULT hr_api.g_false_num,

1757: end delete_transaction_children;
1758:
1759: FUNCTION commit_transaction(
1760: p_transaction_id IN NUMBER,
1761: p_validate IN NUMBER DEFAULT hr_api.g_false_num,
1762: p_effective_date IN DATE DEFAULT SYSDATE)
1763: RETURN VARCHAR2 IS
1764: l_proc VARCHAR2(72) := g_package || 'commit_transaction';
1765: x_return_status VARCHAR2(1);

Line 1774: p_process_all_on_error =>hr_api.g_false_num,

1770: commit_transaction(
1771: p_transaction_id=>p_transaction_id,
1772: p_validate =>p_validate,
1773: p_effective_date=>p_effective_date,
1774: p_process_all_on_error =>hr_api.g_false_num,
1775: p_status=>x_return_status,
1776: p_error_log=>p_error_log);
1777: hr_utility.set_location(' Exiting:' || l_proc,20);
1778:

Line 1791: lr_transaction_rec hr_api_transactions%rowtype;

1787: ,p_status out nocopy varchar2) as
1788:
1789:
1790: lv_item_type wf_items.item_type%type;
1791: lr_transaction_rec hr_api_transactions%rowtype;
1792: lv_status varchar2(8);
1793: lv_result varchar2(30);
1794: lv_errorActid wf_item_activity_statuses.process_activity%type;
1795: lv_errname VARCHAR2(4000);

Line 1821: from hr_api_transactions

1817: if(p_transaction_id is not null) then
1818: -- get the transaction details
1819: select *
1820: into lr_transaction_rec
1821: from hr_api_transactions
1822: where transaction_id=p_transaction_id;
1823:
1824: -- derive the fnd function params values from txn
1825: lv_approval_required := hr_xml_util.get_node_value(p_transaction_id,

Line 2046: c_updateStatus hr_api_transactions.status%type;

2042: PRAGMA AUTONOMOUS_TRANSACTION;
2043: --
2044: -- local variables
2045: c_proc constant varchar2(30) := 'setTransactionStatus';
2046: c_updateStatus hr_api_transactions.status%type;
2047: ln_notification_id wf_notifications.notification_id%type;
2048: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
2049: lv_item_key wf_items.item_key%type;
2050: lt_additional_wf_attributes HR_WF_ATTR_TABLE;

Line 2048: lr_hr_api_transaction_rec hr_api_transactions%rowtype;

2044: -- local variables
2045: c_proc constant varchar2(30) := 'setTransactionStatus';
2046: c_updateStatus hr_api_transactions.status%type;
2047: ln_notification_id wf_notifications.notification_id%type;
2048: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
2049: lv_item_key wf_items.item_key%type;
2050: lt_additional_wf_attributes HR_WF_ATTR_TABLE;
2051: lv_error_message varchar2(4000);
2052: lv_errstack varchar2(4000);

Line 2055: lv_currentTxnStatus hr_api_transactions.status%type;

2051: lv_error_message varchar2(4000);
2052: lv_errstack varchar2(4000);
2053: lv_status varchar2(30); -- revisit on the size
2054: lv_wf_item_attribute HR_WF_ATTR_TYPE;
2055: lv_currentTxnStatus hr_api_transactions.status%type;
2056:
2057:
2058: begin
2059: -- check if debug enabled

Line 2064: if(p_propagateMessagePub=hr_api.g_true_num) then

2060: if g_debug then
2061: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
2062: end if;
2063: -- check if we need to propagate the error messages
2064: if(p_propagateMessagePub=hr_api.g_true_num) then
2065: hr_multi_message.enable_message_list;
2066: end if;
2067: -- check the proposed status
2068: -- S --> SFL

Line 2076: from hr_api_transactions

2072: c_updateStatus:='Y';
2073: elsif(p_proposedTxnStatus='S')then
2074: begin
2075: select status into lv_currentTxnStatus
2076: from hr_api_transactions
2077: where transaction_id=p_transaction_id;
2078: exception
2079: when others then
2080: null;

Line 2098: into lr_hr_api_transaction_rec

2094: if(p_proposedTxnStatus='S')then
2095: -- send SFL notification
2096: -- get the transaction record
2097: select *
2098: into lr_hr_api_transaction_rec
2099: from hr_api_transactions
2100: where transaction_id=p_transaction_id;
2101: -- send sfl notification to login user
2102: hr_sflutil_ss.sendsflnotification(p_transaction_id,

Line 2099: from hr_api_transactions

2095: -- send SFL notification
2096: -- get the transaction record
2097: select *
2098: into lr_hr_api_transaction_rec
2099: from hr_api_transactions
2100: where transaction_id=p_transaction_id;
2101: -- send sfl notification to login user
2102: hr_sflutil_ss.sendsflnotification(p_transaction_id,
2103: p_transaction_ref_table,

Line 2126: into lr_hr_api_transaction_rec

2122:
2123: begin
2124: -- check if the wf process is initialized or not
2125: select *
2126: into lr_hr_api_transaction_rec
2127: from hr_api_transactions
2128: where transaction_id=p_transaction_id;
2129:
2130: exception

Line 2127: from hr_api_transactions

2123: begin
2124: -- check if the wf process is initialized or not
2125: select *
2126: into lr_hr_api_transaction_rec
2127: from hr_api_transactions
2128: where transaction_id=p_transaction_id;
2129:
2130: exception
2131: when others then

Line 2135: if(lr_hr_api_transaction_rec.item_key is not null) then

2131: when others then
2132: raise;
2133: end;
2134:
2135: if(lr_hr_api_transaction_rec.item_key is not null) then
2136:
2137: -- call the code to transition flow in case of approvals
2138: hr_approval_ss.processapprovalsubmit(p_transaction_id,
2139: p_approver_comments);

Line 2172: IF (p_propagateMessagePub=hr_api.g_true_num) THEN

2168: -- propagate the error message
2169:
2170: end;
2171: -- disable the message propagation
2172: IF (p_propagateMessagePub=hr_api.g_true_num) THEN
2173: hr_multi_message.disable_message_list;
2174: END IF;
2175:
2176: -- finally commit the data

Line 2268: p_validate IN NUMBER DEFAULT hr_api.g_false_num,

2264: end;
2265:
2266: PROCEDURE commit_transaction(
2267: p_transaction_id IN NUMBER,
2268: p_validate IN NUMBER DEFAULT hr_api.g_false_num,
2269: p_effective_date IN DATE DEFAULT SYSDATE,
2270: p_process_all_on_error IN NUMBER DEFAULT hr_api.g_false_num,
2271: p_status OUT nocopy VARCHAR2,
2272: p_error_log IN OUT nocopy CLOB)IS

Line 2270: p_process_all_on_error IN NUMBER DEFAULT hr_api.g_false_num,

2266: PROCEDURE commit_transaction(
2267: p_transaction_id IN NUMBER,
2268: p_validate IN NUMBER DEFAULT hr_api.g_false_num,
2269: p_effective_date IN DATE DEFAULT SYSDATE,
2270: p_process_all_on_error IN NUMBER DEFAULT hr_api.g_false_num,
2271: p_status OUT nocopy VARCHAR2,
2272: p_error_log IN OUT nocopy CLOB)IS
2273: CURSOR csr_trn IS
2274: SELECT transaction_document

Line 2275: FROM hr_api_transactions

2271: p_status OUT nocopy VARCHAR2,
2272: p_error_log IN OUT nocopy CLOB)IS
2273: CURSOR csr_trn IS
2274: SELECT transaction_document
2275: FROM hr_api_transactions
2276: WHERE transaction_id = p_transaction_id;
2277:
2278: rootNode xmldom.DOMNode;
2279: l_TXN_Node xmldom.DOMNode;

Line 2415: IF p_process_all_on_error = hr_api.g_false_num THEN

2411: error_EO_Node :=xmldom.makeNode(error_EO_elmt);
2412: createEOErrorMSgNode(error_doc,error_EO_Node);
2413: error_temp_Node:=xmldom.appendChild(error_doc_main_node,error_EO_Node);
2414: -- see if we need to progress on the siblings ?
2415: IF p_process_all_on_error = hr_api.g_false_num THEN
2416: RAISE g_process_api_internal_error;
2417: END IF;
2418:
2419: END;

Line 2430: IF p_validate = hr_api.g_true_num THEN

2426:
2427: writeXMLDocToClob(error_doc ,p_error_log );
2428:
2429: hr_utility.set_location(' Exiting For Loop:' || l_proc,40);
2430: IF p_validate = hr_api.g_true_num THEN
2431: hr_utility.set_location(' p_validate=TRUE:' || l_proc,45);
2432: RAISE hr_api.validate_enabled;
2433: END IF;
2434: -- Return the status to the calling procedure

Line 2432: RAISE hr_api.validate_enabled;

2428:
2429: hr_utility.set_location(' Exiting For Loop:' || l_proc,40);
2430: IF p_validate = hr_api.g_true_num THEN
2431: hr_utility.set_location(' p_validate=TRUE:' || l_proc,45);
2432: RAISE hr_api.validate_enabled;
2433: END IF;
2434: -- Return the status to the calling procedure
2435: -- hsundar: There is no need to commit as Work-Flow takes care of it implicitly
2436: /*if p_validate = hr_api.g_false_num then

Line 2436: /*if p_validate = hr_api.g_false_num then

2432: RAISE hr_api.validate_enabled;
2433: END IF;
2434: -- Return the status to the calling procedure
2435: -- hsundar: There is no need to commit as Work-Flow takes care of it implicitly
2436: /*if p_validate = hr_api.g_false_num then
2437: hr_utility.set_location('Commiting as p_validate=FALSE:' || l_proc,50);
2438: COMMIT;
2439: END IF; */
2440:

Line 2456: WHEN hr_api.validate_enabled THEN

2452: --do something here
2453: hr_utility.set_location('Exception:hr_utility.hr_error' || l_proc,555);
2454: ROLLBACK TO commit_transaction_swi;
2455: RAISE;
2456: WHEN hr_api.validate_enabled THEN
2457: -- As the Validate_Enabled exception has been raised
2458: -- we must rollback to the savepoint
2459: hr_utility.set_location('Exception:hr_api.validate_enabled' || l_proc,560);
2460: ROLLBACK TO commit_transaction_swi;

Line 2459: hr_utility.set_location('Exception:hr_api.validate_enabled' || l_proc,560);

2455: RAISE;
2456: WHEN hr_api.validate_enabled THEN
2457: -- As the Validate_Enabled exception has been raised
2458: -- we must rollback to the savepoint
2459: hr_utility.set_location('Exception:hr_api.validate_enabled' || l_proc,560);
2460: ROLLBACK TO commit_transaction_swi;
2461: p_status :=x_return_status;
2462: WHEN others THEN
2463: hr_utility.set_location('Exception:others' || l_proc,565);