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 650: p_validate in number default hr_api.g_false_num,

646:
647: Function process_api_internal(
648: p_transaction_id in number,
649: p_root_node in xmldom.DOMNode,
650: p_validate in number default hr_api.g_false_num,
651: p_effective_date in DATE,
652: p_return_status in varchar2)
653: return VARCHAR2 IS
654:

Line 657: from hr_api_transaction_steps

653: return VARCHAR2 IS
654:
655: cursor csr_hat_steps(p_Api_Name in varchar2) is
656: select *
657: from hr_api_transaction_steps
658: where transaction_id=p_transaction_id
659: and API_NAME = p_Api_Name
660: and OBJECT_TYPE is null;
661:

Line 757: p_validate in number default hr_api.g_false_num,

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

Line 861: from hr_api_transactions hat

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

Line 977: lr_hr_api_transaction_rec hr_api_transactions%rowtype;

973: step_row csr_person_details%rowtype;
974: l_proc varchar2(72) := g_package || 'set_person_context';
975: l_orgid number;
976: ----------
977: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
978: p_transaction_id number;
979: dummy VARCHAR2(10);
980: ----------
981: Begin

Line 1053: select * into lr_hr_api_transaction_rec

1049: hr_utility.trace('Inside hr_transaction_swi.set_person_context: p_transaction_id := ' || p_transaction_id);
1050: /*
1051: if(p_transaction_id is not null) then
1052: begin
1053: select * into lr_hr_api_transaction_rec
1054: from hr_api_transactions
1055: where transaction_id= p_transaction_id;
1056:
1057: if(lr_hr_api_transaction_rec.item_key IS NOT NULL) THEN

Line 1054: from hr_api_transactions

1050: /*
1051: if(p_transaction_id is not null) then
1052: begin
1053: select * into lr_hr_api_transaction_rec
1054: from hr_api_transactions
1055: where transaction_id= p_transaction_id;
1056:
1057: if(lr_hr_api_transaction_rec.item_key IS NOT NULL) THEN
1058: if(wf_engine.getitemattrtext(lr_hr_api_transaction_rec.item_type,

Line 1057: if(lr_hr_api_transaction_rec.item_key IS NOT NULL) THEN

1053: select * into lr_hr_api_transaction_rec
1054: from hr_api_transactions
1055: where transaction_id= p_transaction_id;
1056:
1057: if(lr_hr_api_transaction_rec.item_key IS NOT NULL) THEN
1058: if(wf_engine.getitemattrtext(lr_hr_api_transaction_rec.item_type,
1059: lr_hr_api_transaction_rec.item_key,
1060: 'HR_DEFER_COMMIT_ATTR',true)='Y' and fnd_profile.value('HR_CROSS_BUSINESS_GROUP')='N') then
1061:

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

1054: from hr_api_transactions
1055: where transaction_id= p_transaction_id;
1056:
1057: if(lr_hr_api_transaction_rec.item_key IS NOT NULL) THEN
1058: if(wf_engine.getitemattrtext(lr_hr_api_transaction_rec.item_type,
1059: lr_hr_api_transaction_rec.item_key,
1060: 'HR_DEFER_COMMIT_ATTR',true)='Y' and fnd_profile.value('HR_CROSS_BUSINESS_GROUP')='N') then
1061:
1062: BEGIN

Line 1059: lr_hr_api_transaction_rec.item_key,

1055: where transaction_id= p_transaction_id;
1056:
1057: if(lr_hr_api_transaction_rec.item_key IS NOT NULL) THEN
1058: if(wf_engine.getitemattrtext(lr_hr_api_transaction_rec.item_type,
1059: lr_hr_api_transaction_rec.item_key,
1060: 'HR_DEFER_COMMIT_ATTR',true)='Y' and fnd_profile.value('HR_CROSS_BUSINESS_GROUP')='N') then
1061:
1062: BEGIN
1063:

Line 1092: from hr_api_transactions

1088:
1089: declare
1090: cursor cur is
1091: select *
1092: from hr_api_transactions
1093: where transaction_id = p_transaction_id;
1094: begin
1095:
1096: hr_utility.trace('Entered into anonymous block for fix 11776102');

Line 1099: fetch cur into lr_hr_api_transaction_rec;

1095:
1096: hr_utility.trace('Entered into anonymous block for fix 11776102');
1097:
1098: open cur;
1099: fetch cur into lr_hr_api_transaction_rec;
1100: if cur%NOTFOUND then
1101: lr_hr_api_transaction_rec.item_type := NULL;
1102: lr_hr_api_transaction_rec.item_key := NULL;
1103: hr_utility.trace('Cursor cur fetches no record !');

Line 1101: lr_hr_api_transaction_rec.item_type := NULL;

1097:
1098: open cur;
1099: fetch cur into lr_hr_api_transaction_rec;
1100: if cur%NOTFOUND then
1101: lr_hr_api_transaction_rec.item_type := NULL;
1102: lr_hr_api_transaction_rec.item_key := NULL;
1103: hr_utility.trace('Cursor cur fetches no record !');
1104: end if;
1105: if cur%ROWCOUNT > 1 then

Line 1102: lr_hr_api_transaction_rec.item_key := NULL;

1098: open cur;
1099: fetch cur into lr_hr_api_transaction_rec;
1100: if cur%NOTFOUND then
1101: lr_hr_api_transaction_rec.item_type := NULL;
1102: lr_hr_api_transaction_rec.item_key := NULL;
1103: hr_utility.trace('Cursor cur fetches no record !');
1104: end if;
1105: if cur%ROWCOUNT > 1 then
1106: hr_utility.trace('Cursor cur fetches more than one record!');

Line 1111: if(lr_hr_api_transaction_rec.item_key IS NOT NULL) THEN

1107: NULL;
1108: end if;
1109: close cur;
1110:
1111: if(lr_hr_api_transaction_rec.item_key IS NOT NULL) THEN
1112:
1113: if(wf_engine.getitemattrtext(lr_hr_api_transaction_rec.item_type,
1114: lr_hr_api_transaction_rec.item_key,
1115: 'HR_DEFER_COMMIT_ATTR',true)='Y' AND

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

1109: close cur;
1110:
1111: if(lr_hr_api_transaction_rec.item_key IS NOT NULL) THEN
1112:
1113: if(wf_engine.getitemattrtext(lr_hr_api_transaction_rec.item_type,
1114: lr_hr_api_transaction_rec.item_key,
1115: 'HR_DEFER_COMMIT_ATTR',true)='Y' AND
1116: fnd_profile.value('HR_CROSS_BUSINESS_GROUP')='N') THEN
1117:

Line 1114: lr_hr_api_transaction_rec.item_key,

1110:
1111: if(lr_hr_api_transaction_rec.item_key IS NOT NULL) THEN
1112:
1113: if(wf_engine.getitemattrtext(lr_hr_api_transaction_rec.item_type,
1114: lr_hr_api_transaction_rec.item_key,
1115: 'HR_DEFER_COMMIT_ATTR',true)='Y' AND
1116: fnd_profile.value('HR_CROSS_BUSINESS_GROUP')='N') THEN
1117:
1118: BEGIN

Line 1177: p_validate in NUMBER default hr_api.g_false_num)

1173:
1174:
1175: procedure delete_transaction(
1176: p_transaction_id in NUMBER,
1177: p_validate in NUMBER default hr_api.g_false_num)
1178: is
1179: l_proc varchar2(72) := g_package || 'delete_transaction';
1180: begin
1181: hr_utility.set_location(' Entering:' || l_proc,10);

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

1183: delete_transaction_children(p_transaction_id, p_validate);
1184: hr_sflutil_ss.closesflnotifications(p_transaction_id,null,null);
1185: hr_transaction_api.rollback_transaction(
1186: p_transaction_id => p_transaction_id,
1187: p_validate => (p_validate=hr_api.g_true_num));
1188: hr_utility.set_location(' Exiting :' || l_proc,20);
1189: end delete_transaction;
1190:
1191: function convertCLOBtoXMLElement(

Line 1220: c_updateStatus hr_api_transactions.status%type;

1216: PRAGMA AUTONOMOUS_TRANSACTION;
1217: --
1218: -- local variables
1219: c_proc constant varchar2(30) := 'setTransactionStatus';
1220: c_updateStatus hr_api_transactions.status%type;
1221: ln_notification_id wf_notifications.notification_id%type;
1222: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
1223:
1224: begin

Line 1222: lr_hr_api_transaction_rec hr_api_transactions%rowtype;

1218: -- local variables
1219: c_proc constant varchar2(30) := 'setTransactionStatus';
1220: c_updateStatus hr_api_transactions.status%type;
1221: ln_notification_id wf_notifications.notification_id%type;
1222: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
1223:
1224: begin
1225: -- check if debug enabled
1226: if g_debug then

Line 1285: lr_hr_api_transaction_rec hr_api_transactions%rowtype;

1281: return varchar2
1282: is
1283: -- local variables
1284: editAllowed varchar2(1);
1285: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
1286: lr_per_appraisals_rec per_appraisals%rowtype;
1287: l_authenticateNtf boolean;
1288:
1289: CURSOR csr_appr_details (p_appraisal_id IN NUMBER)

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

1293:
1294: begin
1295:
1296: -- check if we need to propagate the error messages
1297: if(p_propagateMessagePub=hr_api.g_true_num) then
1298: hr_multi_message.enable_message_list;
1299: end if;
1300:
1301: -- set the default return satatus

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

1301: -- set the default return satatus
1302: editAllowed :='N';
1303:
1304: -- set the default ntf authentication
1305: if((p_authenticateNtf is null) or (p_authenticateNtf=hr_api.g_true_num)) then
1306: l_authenticateNtf := true;
1307: else
1308: l_authenticateNtf := false;
1309: end if;

Line 1343: select * into lr_hr_api_transaction_rec

1339:
1340: if(p_transaction_id is not null) then
1341: -- get the transaction details
1342: begin
1343: select * into lr_hr_api_transaction_rec
1344: from hr_api_transactions
1345: where transaction_id=p_transaction_id;
1346: exception
1347: when others then

Line 1344: from hr_api_transactions

1340: if(p_transaction_id is not null) then
1341: -- get the transaction details
1342: begin
1343: select * into lr_hr_api_transaction_rec
1344: from hr_api_transactions
1345: where transaction_id=p_transaction_id;
1346: exception
1347: when others then
1348: editAllowed :='N';

Line 1352: if(lr_hr_api_transaction_rec.process_name='PAY_BATCH_JSP_PRC') then

1348: editAllowed :='N';
1349: end;
1350:
1351: -- 14341883 edit allowed is disabled for all the entries confined to Batch Element Entry
1352: if(lr_hr_api_transaction_rec.process_name='PAY_BATCH_JSP_PRC') then
1353: editAllowed := 'N';
1354: return editAllowed;
1355: end if;
1356: -- 14341883 edit allowed is disabled for all the entries confined to Batch Element Entry

Line 1360: if(p_transaction_status in ('W', 'RI') and (lr_hr_api_transaction_rec.transaction_ref_table='PER_APPRAISALS'))

1356: -- 14341883 edit allowed is disabled for all the entries confined to Batch Element Entry
1357:
1358: --start - fix for bug 14592885
1359: if(p_transaction_status not in ('Y','YS','RO','ROS')) then
1360: if(p_transaction_status in ('W', 'RI') and (lr_hr_api_transaction_rec.transaction_ref_table='PER_APPRAISALS'))
1361: then
1362: OPEN csr_appr_details (lr_hr_api_transaction_rec.transaction_ref_id);
1363: FETCH csr_appr_details INTO lr_per_appraisals_rec;
1364: CLOSE csr_appr_details;

Line 1362: OPEN csr_appr_details (lr_hr_api_transaction_rec.transaction_ref_id);

1358: --start - fix for bug 14592885
1359: if(p_transaction_status not in ('Y','YS','RO','ROS')) then
1360: if(p_transaction_status in ('W', 'RI') and (lr_hr_api_transaction_rec.transaction_ref_table='PER_APPRAISALS'))
1361: then
1362: OPEN csr_appr_details (lr_hr_api_transaction_rec.transaction_ref_id);
1363: FETCH csr_appr_details INTO lr_per_appraisals_rec;
1364: CLOSE csr_appr_details;
1365:
1366: if(lr_per_appraisals_rec.main_appraiser_id = p_loginPersonId AND (lr_per_appraisals_rec.appraisal_system_status in ('ONGOING', 'RFC')))

Line 1378: elsif(isTxnOwner(null,lr_hr_api_transaction_rec.creator_person_id))

1374: else
1375: editAllowed := 'N';
1376: return editAllowed;
1377: end if;
1378: elsif(isTxnOwner(null,lr_hr_api_transaction_rec.creator_person_id))
1379: then
1380: -- it is the creator editing the transaction
1381: editAllowed := 'Y';
1382: return editAllowed;

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

1385: elsif(p_transaction_status in ('Y','YS','RO','ROS' )) then
1386: -- case where approvers trying to edit
1387:
1388: -- check if the login person is the approver
1389: if(fnd_global.user_name=wf_engine.getitemattrtext(lr_hr_api_transaction_rec.item_type,
1390: lr_hr_api_transaction_rec.item_key,
1391: 'FORWARD_TO_USERNAME',true)) then
1392: -- check the profile if the system is configured for approvers editing
1393: IF ( nvl(fnd_profile.value('PQH_ALLOW_APPROVER_TO_EDIT_TXN'),'N') = 'Y' ) THEN

Line 1390: lr_hr_api_transaction_rec.item_key,

1386: -- case where approvers trying to edit
1387:
1388: -- check if the login person is the approver
1389: if(fnd_global.user_name=wf_engine.getitemattrtext(lr_hr_api_transaction_rec.item_type,
1390: lr_hr_api_transaction_rec.item_key,
1391: 'FORWARD_TO_USERNAME',true)) then
1392: -- check the profile if the system is configured for approvers editing
1393: IF ( nvl(fnd_profile.value('PQH_ALLOW_APPROVER_TO_EDIT_TXN'),'N') = 'Y' ) THEN
1394: -- add specific override logic here

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

1394: -- add specific override logic here
1395: -- case 1: check the programatic overide for the flow
1396: -- wf item attribute HR_RESTRICT_EDIT_ATTR
1397:
1398: if(wf_engine.getitemattrtext(lr_hr_api_transaction_rec.item_type,
1399: lr_hr_api_transaction_rec.item_key,
1400: 'HR_RESTRICT_EDIT_ATTR',true)='Y') then
1401: editAllowed := 'N';
1402: return editAllowed;

Line 1399: lr_hr_api_transaction_rec.item_key,

1395: -- case 1: check the programatic overide for the flow
1396: -- wf item attribute HR_RESTRICT_EDIT_ATTR
1397:
1398: if(wf_engine.getitemattrtext(lr_hr_api_transaction_rec.item_type,
1399: lr_hr_api_transaction_rec.item_key,
1400: 'HR_RESTRICT_EDIT_ATTR',true)='Y') then
1401: editAllowed := 'N';
1402: return editAllowed;
1403: end if;

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

1403: end if;
1404:
1405: -- case 2: Functional module layer
1406: -- appraisal specific, not edit allowed for now by approvers
1407: if(lr_hr_api_transaction_rec.transaction_ref_table='PER_APPRAISALS') then
1408: editAllowed := 'N';
1409: -- no more checks return
1410: return editAllowed;
1411: end if;

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

1422: end if; -- approver check
1423: end if; -- transaction status check
1424: end if; -- transaction id null check
1425: -- disable the message propagation
1426: IF (p_propagateMessagePub=hr_api.g_true_num) THEN
1427: hr_multi_message.disable_message_list;
1428: END IF;
1429:
1430:

Line 1450: lr_hr_api_transaction_rec hr_api_transactions%rowtype;

1446: return varchar2
1447: is
1448: -- local variables
1449: deleteAllowed varchar2(1);
1450: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
1451: l_authenticateNtf boolean;
1452: begin
1453:
1454: -- set default

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

1453:
1454: -- set default
1455: deleteAllowed :='N';
1456: -- check if we need to propagate the error messages
1457: if(p_propagateMessagePub=hr_api.g_true_num) then
1458: hr_multi_message.enable_message_list;
1459: end if;
1460:
1461: -- set the default ntf authentication

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

1458: hr_multi_message.enable_message_list;
1459: end if;
1460:
1461: -- set the default ntf authentication
1462: if((p_authenticateNtf is null) or (p_authenticateNtf=hr_api.g_true_num)) then
1463: l_authenticateNtf := true;
1464: else
1465: l_authenticateNtf := false;
1466: end if;

Line 1501: select * into lr_hr_api_transaction_rec

1497:
1498: if(p_transaction_id is not null) then
1499: -- get the transaction details
1500: begin
1501: select * into lr_hr_api_transaction_rec
1502: from hr_api_transactions
1503: where transaction_id=p_transaction_id;
1504: exception
1505: when others then

Line 1502: from hr_api_transactions

1498: if(p_transaction_id is not null) then
1499: -- get the transaction details
1500: begin
1501: select * into lr_hr_api_transaction_rec
1502: from hr_api_transactions
1503: where transaction_id=p_transaction_id;
1504: exception
1505: when others then
1506: deleteAllowed :='N';

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

1506: deleteAllowed :='N';
1507: end;
1508:
1509: if(p_transaction_status not in ('Y','YS','RO','ROS')
1510: and isTxnOwner(null,lr_hr_api_transaction_rec.creator_person_id)) then
1511: -- it is the creator editing the transaction
1512: --- added for 9661713 -- delete always disabled for Appraisal notifications
1513: IF lr_hr_api_transaction_rec.transaction_ref_table = 'PER_APPRAISALS'
1514: and lr_hr_api_transaction_rec.status IN ('C','RI','RIS') THEN

Line 1513: IF lr_hr_api_transaction_rec.transaction_ref_table = 'PER_APPRAISALS'

1509: if(p_transaction_status not in ('Y','YS','RO','ROS')
1510: and isTxnOwner(null,lr_hr_api_transaction_rec.creator_person_id)) then
1511: -- it is the creator editing the transaction
1512: --- added for 9661713 -- delete always disabled for Appraisal notifications
1513: IF lr_hr_api_transaction_rec.transaction_ref_table = 'PER_APPRAISALS'
1514: and lr_hr_api_transaction_rec.status IN ('C','RI','RIS') THEN
1515: deleteAllowed := 'N';
1516: ELSE
1517: deleteAllowed := 'Y';

Line 1514: and lr_hr_api_transaction_rec.status IN ('C','RI','RIS') THEN

1510: and isTxnOwner(null,lr_hr_api_transaction_rec.creator_person_id)) then
1511: -- it is the creator editing the transaction
1512: --- added for 9661713 -- delete always disabled for Appraisal notifications
1513: IF lr_hr_api_transaction_rec.transaction_ref_table = 'PER_APPRAISALS'
1514: and lr_hr_api_transaction_rec.status IN ('C','RI','RIS') THEN
1515: deleteAllowed := 'N';
1516: ELSE
1517: deleteAllowed := 'Y';
1518: END IF;

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

1521: deleteAllowed :='N';
1522: end if;
1523:
1524: -- disable the message propagation
1525: IF (p_propagateMessagePub=hr_api.g_true_num) THEN
1526: hr_multi_message.disable_message_list;
1527: END IF;
1528: end if;
1529:

Line 1646: lr_hr_api_transaction_rec hr_api_transactions%rowtype;

1642: p_transaction_type in varchar2,
1643: p_item_type in varchar2,
1644: p_item_key in varchar2)
1645: is
1646: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
1647: lv_result varchar2(100);
1648: ln_notification_id wf_notifications.notification_id%type;
1649: ln_activity_id wf_item_activity_statuses.process_activity%type;
1650: begin

Line 1706: lr_hr_api_transaction_rec hr_api_transactions%rowtype;

1702: end othersDeleteAction;
1703:
1704: procedure deleteAction(p_transaction_id in number)
1705: is
1706: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
1707: lv_result varchar2(100);
1708: begin
1709: -- this routine is called from all actions UI
1710: --

Line 1727: select * into lr_hr_api_transaction_rec

1723:
1724: */
1725: if(p_transaction_id is not null) then
1726: begin
1727: select * into lr_hr_api_transaction_rec
1728: from hr_api_transactions
1729: where transaction_id=p_transaction_id;
1730: exception
1731: when others then

Line 1728: from hr_api_transactions

1724: */
1725: if(p_transaction_id is not null) then
1726: begin
1727: select * into lr_hr_api_transaction_rec
1728: from hr_api_transactions
1729: where transaction_id=p_transaction_id;
1730: exception
1731: when others then
1732: raise;

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

1732: raise;
1733: end;
1734:
1735: -- check the current owner
1736: if(isTxnOwner(null,lr_hr_api_transaction_rec.creator_person_id)) then
1737: -- do logic specific to creator
1738: ownerDeleteAction(p_transaction_id ,
1739: lr_hr_api_transaction_rec.status,
1740: lr_hr_api_transaction_rec.transaction_type,

Line 1739: lr_hr_api_transaction_rec.status,

1735: -- check the current owner
1736: if(isTxnOwner(null,lr_hr_api_transaction_rec.creator_person_id)) then
1737: -- do logic specific to creator
1738: ownerDeleteAction(p_transaction_id ,
1739: lr_hr_api_transaction_rec.status,
1740: lr_hr_api_transaction_rec.transaction_type,
1741: lr_hr_api_transaction_rec.item_type,
1742: lr_hr_api_transaction_rec.item_key);
1743: else -- approvers case

Line 1740: lr_hr_api_transaction_rec.transaction_type,

1736: if(isTxnOwner(null,lr_hr_api_transaction_rec.creator_person_id)) then
1737: -- do logic specific to creator
1738: ownerDeleteAction(p_transaction_id ,
1739: lr_hr_api_transaction_rec.status,
1740: lr_hr_api_transaction_rec.transaction_type,
1741: lr_hr_api_transaction_rec.item_type,
1742: lr_hr_api_transaction_rec.item_key);
1743: else -- approvers case
1744: othersDeleteAction(p_transaction_id ,

Line 1741: lr_hr_api_transaction_rec.item_type,

1737: -- do logic specific to creator
1738: ownerDeleteAction(p_transaction_id ,
1739: lr_hr_api_transaction_rec.status,
1740: lr_hr_api_transaction_rec.transaction_type,
1741: lr_hr_api_transaction_rec.item_type,
1742: lr_hr_api_transaction_rec.item_key);
1743: else -- approvers case
1744: othersDeleteAction(p_transaction_id ,
1745: lr_hr_api_transaction_rec.status,

Line 1742: lr_hr_api_transaction_rec.item_key);

1738: ownerDeleteAction(p_transaction_id ,
1739: lr_hr_api_transaction_rec.status,
1740: lr_hr_api_transaction_rec.transaction_type,
1741: lr_hr_api_transaction_rec.item_type,
1742: lr_hr_api_transaction_rec.item_key);
1743: else -- approvers case
1744: othersDeleteAction(p_transaction_id ,
1745: lr_hr_api_transaction_rec.status,
1746: lr_hr_api_transaction_rec.transaction_type,

Line 1745: lr_hr_api_transaction_rec.status,

1741: lr_hr_api_transaction_rec.item_type,
1742: lr_hr_api_transaction_rec.item_key);
1743: else -- approvers case
1744: othersDeleteAction(p_transaction_id ,
1745: lr_hr_api_transaction_rec.status,
1746: lr_hr_api_transaction_rec.transaction_type,
1747: lr_hr_api_transaction_rec.item_type,
1748: lr_hr_api_transaction_rec.item_key);
1749: end if;-- transaction owner check

Line 1746: lr_hr_api_transaction_rec.transaction_type,

1742: lr_hr_api_transaction_rec.item_key);
1743: else -- approvers case
1744: othersDeleteAction(p_transaction_id ,
1745: lr_hr_api_transaction_rec.status,
1746: lr_hr_api_transaction_rec.transaction_type,
1747: lr_hr_api_transaction_rec.item_type,
1748: lr_hr_api_transaction_rec.item_key);
1749: end if;-- transaction owner check
1750: end if;-- transaction id check

Line 1747: lr_hr_api_transaction_rec.item_type,

1743: else -- approvers case
1744: othersDeleteAction(p_transaction_id ,
1745: lr_hr_api_transaction_rec.status,
1746: lr_hr_api_transaction_rec.transaction_type,
1747: lr_hr_api_transaction_rec.item_type,
1748: lr_hr_api_transaction_rec.item_key);
1749: end if;-- transaction owner check
1750: end if;-- transaction id check
1751:

Line 1748: lr_hr_api_transaction_rec.item_key);

1744: othersDeleteAction(p_transaction_id ,
1745: lr_hr_api_transaction_rec.status,
1746: lr_hr_api_transaction_rec.transaction_type,
1747: lr_hr_api_transaction_rec.item_type,
1748: lr_hr_api_transaction_rec.item_key);
1749: end if;-- transaction owner check
1750: end if;-- transaction id check
1751:
1752: exception

Line 1761: lr_hr_api_transaction_rec hr_api_transactions%rowtype;

1757:
1758: procedure initiatorDeleteAction(p_transaction_id in number)
1759: is
1760: lv_result varchar2(100);
1761: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
1762: begin
1763:
1764: if(p_transaction_id is not null) then
1765: -- Read Transaction Details

Line 1767: select * into lr_hr_api_transaction_rec

1763:
1764: if(p_transaction_id is not null) then
1765: -- Read Transaction Details
1766: begin
1767: select * into lr_hr_api_transaction_rec
1768: from hr_api_transactions
1769: where transaction_id=p_transaction_id;
1770: exception
1771: when others then

Line 1768: from hr_api_transactions

1764: if(p_transaction_id is not null) then
1765: -- Read Transaction Details
1766: begin
1767: select * into lr_hr_api_transaction_rec
1768: from hr_api_transactions
1769: where transaction_id=p_transaction_id;
1770: exception
1771: when others then
1772: raise;

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

1773: end;
1774:
1775: -- check if WF based on non-WF based
1776:
1777: if(lr_hr_api_transaction_rec.item_type is not null) then
1778: -- WF case.
1779: -- hsundar: Delete any open SFL Notification for this txn
1780: hr_sflutil_ss.closesflnotifications(p_transaction_id
1781: ,lr_hr_api_transaction_rec.item_type

Line 1781: ,lr_hr_api_transaction_rec.item_type

1777: if(lr_hr_api_transaction_rec.item_type is not null) then
1778: -- WF case.
1779: -- hsundar: Delete any open SFL Notification for this txn
1780: hr_sflutil_ss.closesflnotifications(p_transaction_id
1781: ,lr_hr_api_transaction_rec.item_type
1782: ,lr_hr_api_transaction_rec.item_key);
1783:
1784: hr_transaction_ss.rollback_transaction(lr_hr_api_transaction_rec.item_type,
1785: lr_hr_api_transaction_rec.item_key,

Line 1782: ,lr_hr_api_transaction_rec.item_key);

1778: -- WF case.
1779: -- hsundar: Delete any open SFL Notification for this txn
1780: hr_sflutil_ss.closesflnotifications(p_transaction_id
1781: ,lr_hr_api_transaction_rec.item_type
1782: ,lr_hr_api_transaction_rec.item_key);
1783:
1784: hr_transaction_ss.rollback_transaction(lr_hr_api_transaction_rec.item_type,
1785: lr_hr_api_transaction_rec.item_key,
1786: null,

Line 1784: hr_transaction_ss.rollback_transaction(lr_hr_api_transaction_rec.item_type,

1780: hr_sflutil_ss.closesflnotifications(p_transaction_id
1781: ,lr_hr_api_transaction_rec.item_type
1782: ,lr_hr_api_transaction_rec.item_key);
1783:
1784: hr_transaction_ss.rollback_transaction(lr_hr_api_transaction_rec.item_type,
1785: lr_hr_api_transaction_rec.item_key,
1786: null,
1787: wf_engine.eng_run,
1788: lv_result);

Line 1785: lr_hr_api_transaction_rec.item_key,

1781: ,lr_hr_api_transaction_rec.item_type
1782: ,lr_hr_api_transaction_rec.item_key);
1783:
1784: hr_transaction_ss.rollback_transaction(lr_hr_api_transaction_rec.item_type,
1785: lr_hr_api_transaction_rec.item_key,
1786: null,
1787: wf_engine.eng_run,
1788: lv_result);
1789: wf_engine.abortprocess(itemtype => lr_hr_api_transaction_rec.item_type

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

1785: lr_hr_api_transaction_rec.item_key,
1786: null,
1787: wf_engine.eng_run,
1788: lv_result);
1789: wf_engine.abortprocess(itemtype => lr_hr_api_transaction_rec.item_type
1790: ,itemkey => lr_hr_api_transaction_rec.item_key
1791: ,process =>null
1792: ,result => wf_engine.eng_force
1793: ,verify_lock => true

Line 1790: ,itemkey => lr_hr_api_transaction_rec.item_key

1786: null,
1787: wf_engine.eng_run,
1788: lv_result);
1789: wf_engine.abortprocess(itemtype => lr_hr_api_transaction_rec.item_type
1790: ,itemkey => lr_hr_api_transaction_rec.item_key
1791: ,process =>null
1792: ,result => wf_engine.eng_force
1793: ,verify_lock => true
1794: ,cascade => true);

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

1802: -- close all sfl notifications
1803: hr_sflutil_ss.closesflnotifications(p_transaction_id,null,null);
1804: -- do the module specific logic
1805:
1806: end if; -- End of 2nd if(lr_hr_api_transaction_rec.item_type is not null)
1807:
1808: else
1809: -- transaction id is null raise error ??
1810: null;

Line 1823: lr_hr_api_transaction_rec hr_api_transactions%rowtype;

1819:
1820:
1821: procedure cancelAction(p_transaction_id in number)
1822: is
1823: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
1824: begin
1825:
1826: if(p_transaction_id is not null) then
1827: begin

Line 1828: select * into lr_hr_api_transaction_rec

1824: begin
1825:
1826: if(p_transaction_id is not null) then
1827: begin
1828: select * into lr_hr_api_transaction_rec
1829: from hr_api_transactions
1830: where transaction_id=p_transaction_id;
1831: exception
1832: when others then

Line 1829: from hr_api_transactions

1825:
1826: if(p_transaction_id is not null) then
1827: begin
1828: select * into lr_hr_api_transaction_rec
1829: from hr_api_transactions
1830: where transaction_id=p_transaction_id;
1831: exception
1832: when others then
1833: null;

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

1833: null;
1834: end;
1835:
1836: -- check the status
1837: if(lr_hr_api_transaction_rec.status='W') then
1838: -- delete the transaction if owner
1839: -- check the current owner
1840: if(isTxnOwner(null,lr_hr_api_transaction_rec.creator_person_id)) then
1841: deleteAction(p_transaction_id);

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

1836: -- check the status
1837: if(lr_hr_api_transaction_rec.status='W') then
1838: -- delete the transaction if owner
1839: -- check the current owner
1840: if(isTxnOwner(null,lr_hr_api_transaction_rec.creator_person_id)) then
1841: deleteAction(p_transaction_id);
1842: else
1843: -- raise error ??
1844: -- not a valid call to this action

Line 1874: lr_hr_api_transaction_rec hr_api_transactions%rowtype;

1870: p_person_id in number) return boolean
1871: is
1872: -- local variables
1873: x_returnStatus boolean;
1874: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
1875: ln_person_id number;
1876: begin
1877:
1878: -- set the default value

Line 1885: select hr_api_transactions.creator_person_id

1881:
1882: if(p_transaction_id is not null) then
1883: -- ignore passed personid
1884: -- derive from the transaction details
1885: select hr_api_transactions.creator_person_id
1886: into ln_person_id
1887: from hr_api_transactions
1888: where transaction_id=p_transaction_id;
1889: end if;

Line 1887: from hr_api_transactions

1883: -- ignore passed personid
1884: -- derive from the transaction details
1885: select hr_api_transactions.creator_person_id
1886: into ln_person_id
1887: from hr_api_transactions
1888: where transaction_id=p_transaction_id;
1889: end if;
1890:
1891: --

Line 1905: p_validate in NUMBER default hr_api.g_false_num)

1901: end isTxnOwner;
1902:
1903: procedure delete_transaction_children(
1904: p_transaction_id in NUMBER,
1905: p_validate in NUMBER default hr_api.g_false_num)
1906: is
1907: cursor csr_trn is
1908: select trn.transaction_id
1909: from hr_api_transactions trn

Line 1909: from hr_api_transactions trn

1905: p_validate in NUMBER default hr_api.g_false_num)
1906: is
1907: cursor csr_trn is
1908: select trn.transaction_id
1909: from hr_api_transactions trn
1910: where trn.parent_transaction_id = p_transaction_id;
1911: begin
1912: for csr_row in csr_trn loop
1913: delete_transaction(csr_row.transaction_id);

Line 1919: p_validate IN NUMBER DEFAULT hr_api.g_false_num,

1915: end delete_transaction_children;
1916:
1917: FUNCTION commit_transaction(
1918: p_transaction_id IN NUMBER,
1919: p_validate IN NUMBER DEFAULT hr_api.g_false_num,
1920: p_effective_date IN DATE DEFAULT SYSDATE)
1921: RETURN VARCHAR2 IS
1922: l_proc VARCHAR2(72) := g_package || 'commit_transaction';
1923: x_return_status VARCHAR2(1);

Line 1932: p_process_all_on_error =>hr_api.g_false_num,

1928: commit_transaction(
1929: p_transaction_id=>p_transaction_id,
1930: p_validate =>p_validate,
1931: p_effective_date=>p_effective_date,
1932: p_process_all_on_error =>hr_api.g_false_num,
1933: p_status=>x_return_status,
1934: p_error_log=>p_error_log);
1935: hr_utility.set_location(' Exiting:' || l_proc,20);
1936:

Line 1949: lr_transaction_rec hr_api_transactions%rowtype;

1945: ,p_status out nocopy varchar2) as
1946:
1947:
1948: lv_item_type wf_items.item_type%type;
1949: lr_transaction_rec hr_api_transactions%rowtype;
1950: lv_status varchar2(8);
1951: lv_result varchar2(30);
1952: lv_errorActid wf_item_activity_statuses.process_activity%type;
1953: lv_errname VARCHAR2(4000);

Line 1982: from hr_api_transactions

1978: if(p_transaction_id is not null) then
1979: -- get the transaction details
1980: select *
1981: into lr_transaction_rec
1982: from hr_api_transactions
1983: where transaction_id=p_transaction_id;
1984:
1985: -- derive the fnd function params values from txn
1986: lv_approval_required := hr_xml_util.get_node_value(p_transaction_id,

Line 2270: c_updateStatus hr_api_transactions.status%type;

2266: PRAGMA AUTONOMOUS_TRANSACTION;
2267: --
2268: -- local variables
2269: c_proc constant varchar2(30) := 'setTransactionStatus';
2270: c_updateStatus hr_api_transactions.status%type;
2271: ln_notification_id wf_notifications.notification_id%type;
2272: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
2273: lv_item_key wf_items.item_key%type;
2274: lt_additional_wf_attributes HR_WF_ATTR_TABLE;

Line 2272: lr_hr_api_transaction_rec hr_api_transactions%rowtype;

2268: -- local variables
2269: c_proc constant varchar2(30) := 'setTransactionStatus';
2270: c_updateStatus hr_api_transactions.status%type;
2271: ln_notification_id wf_notifications.notification_id%type;
2272: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
2273: lv_item_key wf_items.item_key%type;
2274: lt_additional_wf_attributes HR_WF_ATTR_TABLE;
2275: lv_error_message varchar2(4000);
2276: lv_errstack varchar2(4000);

Line 2279: lv_currentTxnStatus hr_api_transactions.status%type;

2275: lv_error_message varchar2(4000);
2276: lv_errstack varchar2(4000);
2277: lv_status varchar2(30); -- revisit on the size
2278: lv_wf_item_attribute HR_WF_ATTR_TYPE;
2279: lv_currentTxnStatus hr_api_transactions.status%type;
2280:
2281:
2282: begin
2283: -- check if debug enabled

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

2284: if g_debug then
2285: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
2286: end if;
2287: -- check if we need to propagate the error messages
2288: if(p_propagateMessagePub=hr_api.g_true_num) then
2289: hr_multi_message.enable_message_list;
2290: end if;
2291: -- check the proposed status
2292: -- S --> SFL

Line 2300: from hr_api_transactions

2296: c_updateStatus:='Y';
2297: elsif(p_proposedTxnStatus='S')then
2298: begin
2299: select status into lv_currentTxnStatus
2300: from hr_api_transactions
2301: where transaction_id=p_transaction_id;
2302: exception
2303: when others then
2304: null;

Line 2322: into lr_hr_api_transaction_rec

2318: if(p_proposedTxnStatus='S')then
2319: -- send SFL notification
2320: -- get the transaction record
2321: select *
2322: into lr_hr_api_transaction_rec
2323: from hr_api_transactions
2324: where transaction_id=p_transaction_id;
2325: -- send sfl notification to login user
2326: hr_sflutil_ss.sendsflnotification(p_transaction_id,

Line 2323: from hr_api_transactions

2319: -- send SFL notification
2320: -- get the transaction record
2321: select *
2322: into lr_hr_api_transaction_rec
2323: from hr_api_transactions
2324: where transaction_id=p_transaction_id;
2325: -- send sfl notification to login user
2326: hr_sflutil_ss.sendsflnotification(p_transaction_id,
2327: p_transaction_ref_table,

Line 2350: into lr_hr_api_transaction_rec

2346:
2347: begin
2348: -- check if the wf process is initialized or not
2349: select *
2350: into lr_hr_api_transaction_rec
2351: from hr_api_transactions
2352: where transaction_id=p_transaction_id;
2353:
2354: exception

Line 2351: from hr_api_transactions

2347: begin
2348: -- check if the wf process is initialized or not
2349: select *
2350: into lr_hr_api_transaction_rec
2351: from hr_api_transactions
2352: where transaction_id=p_transaction_id;
2353:
2354: exception
2355: when others then

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

2355: when others then
2356: raise;
2357: end;
2358:
2359: if(lr_hr_api_transaction_rec.item_key is not null) then
2360:
2361: -- call the code to transition flow in case of approvals
2362: hr_approval_ss.processapprovalsubmit(p_transaction_id,
2363: p_approver_comments);

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

2392: -- propagate the error message
2393:
2394: end;
2395: -- disable the message propagation
2396: IF (p_propagateMessagePub=hr_api.g_true_num) THEN
2397: hr_multi_message.disable_message_list;
2398: END IF;
2399:
2400: -- finally commit the data

Line 2430: c_updateStatus hr_api_transactions.status%type;

2426: PRAGMA AUTONOMOUS_TRANSACTION;
2427: --
2428: -- local variables
2429: c_proc constant varchar2(30) := 'setTransactionStatus';
2430: c_updateStatus hr_api_transactions.status%type;
2431: ln_notification_id wf_notifications.notification_id%type;
2432: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
2433: lv_item_key wf_items.item_key%type;
2434: lv_item_type wf_items.item_type%type;

Line 2432: lr_hr_api_transaction_rec hr_api_transactions%rowtype;

2428: -- local variables
2429: c_proc constant varchar2(30) := 'setTransactionStatus';
2430: c_updateStatus hr_api_transactions.status%type;
2431: ln_notification_id wf_notifications.notification_id%type;
2432: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
2433: lv_item_key wf_items.item_key%type;
2434: lv_item_type wf_items.item_type%type;
2435: lt_additional_wf_attributes HR_WF_ATTR_TABLE;
2436: lv_error_message varchar2(4000);

Line 2440: lv_currentTxnStatus hr_api_transactions.status%type;

2436: lv_error_message varchar2(4000);
2437: lv_errstack varchar2(4000);
2438: lv_status varchar2(30); -- revisit on the size
2439: lv_wf_item_attribute HR_WF_ATTR_TYPE;
2440: lv_currentTxnStatus hr_api_transactions.status%type;
2441:
2442:
2443: begin
2444:

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

2446: if g_debug then
2447: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
2448: end if;
2449: -- check if we need to propagate the error messages
2450: if(p_propagateMessagePub=hr_api.g_true_num) then
2451: hr_multi_message.enable_message_list;
2452: end if;
2453: -- check the proposed status
2454: -- S --> SFL

Line 2462: from hr_api_transactions

2458: c_updateStatus:='Y';
2459: elsif(p_proposedTxnStatus='S')then
2460: begin
2461: select status into lv_currentTxnStatus
2462: from hr_api_transactions
2463: where transaction_id=p_transaction_id;
2464: exception
2465: when others then
2466: null;

Line 2484: into lr_hr_api_transaction_rec

2480: if(p_proposedTxnStatus='S')then
2481: -- send SFL notification
2482: -- get the transaction record
2483: select *
2484: into lr_hr_api_transaction_rec
2485: from hr_api_transactions
2486: where transaction_id=p_transaction_id;
2487: -- send sfl notification to login user
2488: hr_sflutil_ss.sendsflnotification(p_transaction_id,

Line 2485: from hr_api_transactions

2481: -- send SFL notification
2482: -- get the transaction record
2483: select *
2484: into lr_hr_api_transaction_rec
2485: from hr_api_transactions
2486: where transaction_id=p_transaction_id;
2487: -- send sfl notification to login user
2488: hr_sflutil_ss.sendsflnotification(p_transaction_id,
2489: p_transaction_ref_table,

Line 2512: into lr_hr_api_transaction_rec

2508:
2509: begin
2510: -- check if the wf process is initialized or not
2511: select *
2512: into lr_hr_api_transaction_rec
2513: from hr_api_transactions
2514: where transaction_id=p_transaction_id;
2515:
2516: exception

Line 2513: from hr_api_transactions

2509: begin
2510: -- check if the wf process is initialized or not
2511: select *
2512: into lr_hr_api_transaction_rec
2513: from hr_api_transactions
2514: where transaction_id=p_transaction_id;
2515:
2516: exception
2517: when others then

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

2517: when others then
2518: raise;
2519: end;
2520:
2521: if(lr_hr_api_transaction_rec.item_key is not null) then
2522:
2523: -- call the code to transition flow in case of approvals
2524: hr_approval_ss.processapprovalsubmit(p_transaction_id,
2525: p_approver_comments);

Line 2535: lv_item_type := lr_hr_api_transaction_rec.item_type;

2531: ,p_status =>p_status);
2532: if(lv_item_key is null or p_status='E') then
2533: null; -- raise error
2534: else
2535: lv_item_type := lr_hr_api_transaction_rec.item_type;
2536: if(lv_item_type is null) then
2537: null; -- raise error
2538: else
2539: wf_engine.SetItemAttrText(itemtype => lv_item_type

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

2561: p_status := 'E';
2562: -- propagate the error message
2563: end;
2564: -- disable the message propagation
2565: IF (p_propagateMessagePub=hr_api.g_true_num) THEN
2566: hr_multi_message.disable_message_list;
2567: END IF;
2568:
2569: -- finally commit the data

Line 2679: p_validate IN NUMBER DEFAULT hr_api.g_false_num,

2675: end;
2676:
2677: PROCEDURE commit_transaction(
2678: p_transaction_id IN NUMBER,
2679: p_validate IN NUMBER DEFAULT hr_api.g_false_num,
2680: p_effective_date IN DATE DEFAULT SYSDATE,
2681: p_process_all_on_error IN NUMBER DEFAULT hr_api.g_false_num,
2682: p_status OUT nocopy VARCHAR2,
2683: p_error_log IN OUT nocopy CLOB)IS

Line 2681: p_process_all_on_error IN NUMBER DEFAULT hr_api.g_false_num,

2677: PROCEDURE commit_transaction(
2678: p_transaction_id IN NUMBER,
2679: p_validate IN NUMBER DEFAULT hr_api.g_false_num,
2680: p_effective_date IN DATE DEFAULT SYSDATE,
2681: p_process_all_on_error IN NUMBER DEFAULT hr_api.g_false_num,
2682: p_status OUT nocopy VARCHAR2,
2683: p_error_log IN OUT nocopy CLOB)IS
2684: CURSOR csr_trn IS
2685: SELECT transaction_document

Line 2686: FROM hr_api_transactions

2682: p_status OUT nocopy VARCHAR2,
2683: p_error_log IN OUT nocopy CLOB)IS
2684: CURSOR csr_trn IS
2685: SELECT transaction_document
2686: FROM hr_api_transactions
2687: WHERE transaction_id = p_transaction_id;
2688:
2689: CURSOR csr_trn_item IS
2690: SELECT item_type,item_key

Line 2691: FROM hr_api_transactions

2687: WHERE transaction_id = p_transaction_id;
2688:
2689: CURSOR csr_trn_item IS
2690: SELECT item_type,item_key
2691: FROM hr_api_transactions
2692: WHERE transaction_id = p_transaction_id;
2693: rootNode xmldom.DOMNode;
2694: l_TXN_Node xmldom.DOMNode;
2695: l_AM_Node xmldom.DOMNode;

Line 2834: IF p_process_all_on_error = hr_api.g_false_num THEN

2830: FETCH csr_trn_item INTO item_row;
2831: createEOErrorMSgNode(error_doc,error_EO_Node,item_row.item_type,item_row.item_key);
2832: error_temp_Node:=xmldom.appendChild(error_doc_main_node,error_EO_Node);
2833: -- see if we need to progress on the siblings ?
2834: IF p_process_all_on_error = hr_api.g_false_num THEN
2835: RAISE g_process_api_internal_error;
2836: END IF;
2837:
2838: END;

Line 2849: IF p_validate = hr_api.g_true_num THEN

2845:
2846: writeXMLDocToClob(error_doc ,p_error_log );
2847:
2848: hr_utility.set_location(' Exiting For Loop:' || l_proc,40);
2849: IF p_validate = hr_api.g_true_num THEN
2850: hr_utility.set_location(' p_validate=TRUE:' || l_proc,45);
2851: RAISE hr_api.validate_enabled;
2852: END IF;
2853: -- Return the status to the calling procedure

Line 2851: RAISE hr_api.validate_enabled;

2847:
2848: hr_utility.set_location(' Exiting For Loop:' || l_proc,40);
2849: IF p_validate = hr_api.g_true_num THEN
2850: hr_utility.set_location(' p_validate=TRUE:' || l_proc,45);
2851: RAISE hr_api.validate_enabled;
2852: END IF;
2853: -- Return the status to the calling procedure
2854: -- hsundar: There is no need to commit as Work-Flow takes care of it implicitly
2855: /*if p_validate = hr_api.g_false_num then

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

2851: RAISE hr_api.validate_enabled;
2852: END IF;
2853: -- Return the status to the calling procedure
2854: -- hsundar: There is no need to commit as Work-Flow takes care of it implicitly
2855: /*if p_validate = hr_api.g_false_num then
2856: hr_utility.set_location('Commiting as p_validate=FALSE:' || l_proc,50);
2857: COMMIT;
2858: END IF; */
2859:

Line 2875: WHEN hr_api.validate_enabled THEN

2871: --do something here
2872: hr_utility.set_location('Exception:hr_utility.hr_error' || l_proc,555);
2873: ROLLBACK TO commit_transaction_swi;
2874: RAISE;
2875: WHEN hr_api.validate_enabled THEN
2876: -- As the Validate_Enabled exception has been raised
2877: -- we must rollback to the savepoint
2878: hr_utility.set_location('Exception:hr_api.validate_enabled' || l_proc,560);
2879: ROLLBACK TO commit_transaction_swi;

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

2874: RAISE;
2875: WHEN hr_api.validate_enabled THEN
2876: -- As the Validate_Enabled exception has been raised
2877: -- we must rollback to the savepoint
2878: hr_utility.set_location('Exception:hr_api.validate_enabled' || l_proc,560);
2879: ROLLBACK TO commit_transaction_swi;
2880: p_status :=x_return_status;
2881: WHEN others THEN
2882: hr_utility.set_location('Exception:others' || l_proc,565);