DBA Data[Home] [Help]

APPS.AP_WFAPPROVAL_PKG dependencies on AME_UTIL

Line 214: l_next_approver AME_UTIL.approverRecord;

210: actid IN NUMBER,
211: funcmode IN VARCHAR2,
212: resultout OUT NOCOPY VARCHAR2 ) IS
213:
214: l_next_approver AME_UTIL.approverRecord;
215: l_admin_approver AME_UTIL.approverRecord;
216: l_ret_approver VARCHAR2(50);
217: l_name VARCHAR2(30);
218: l_display_name VARCHAR2(150);

Line 215: l_admin_approver AME_UTIL.approverRecord;

211: funcmode IN VARCHAR2,
212: resultout OUT NOCOPY VARCHAR2 ) IS
213:
214: l_next_approver AME_UTIL.approverRecord;
215: l_admin_approver AME_UTIL.approverRecord;
216: l_ret_approver VARCHAR2(50);
217: l_name VARCHAR2(30);
218: l_display_name VARCHAR2(150);
219: l_debug_info VARCHAR2(50);

Line 239: IF l_next_approver.approval_status = ame_util.exceptionStatus THEN

235: l_next_approver);
236:
237: --Bug 2743734 instead of checking against admin approver, checking
238: -- next approver status
239: IF l_next_approver.approval_status = ame_util.exceptionStatus THEN
240: -- raise EXCEPTION
241: l_debug_info := 'Error in AME_API.getNextApprover call';
242: APP_EXCEPTION.RAISE_EXCEPTION;
243:

Line 353: l_next_approver AME_UTIL.approverRecord;

349: actid IN NUMBER,
350: funcmode IN VARCHAR2,
351: resultout OUT NOCOPY VARCHAR2 ) IS
352:
353: l_next_approver AME_UTIL.approverRecord;
354: l_admin_approver AME_UTIL.approverRecord;
355: l_ret_approver VARCHAR2(50);
356: l_name VARCHAR2(30);
357: l_display_name VARCHAR2(150);

Line 354: l_admin_approver AME_UTIL.approverRecord;

350: funcmode IN VARCHAR2,
351: resultout OUT NOCOPY VARCHAR2 ) IS
352:
353: l_next_approver AME_UTIL.approverRecord;
354: l_admin_approver AME_UTIL.approverRecord;
355: l_ret_approver VARCHAR2(50);
356: l_name VARCHAR2(30);
357: l_display_name VARCHAR2(150);
358: l_debug_info VARCHAR2(50);

Line 423: approvalStatusIn => AME_UTIL.approvedStatus,

419: --update AME with response
420: IF l_result = 'APPROVED' THEN
421: AME_API.updateApprovalStatus2(applicationIdIn => 200,
422: transactionIdIn => to_char(l_invoice_id),
423: approvalStatusIn => AME_UTIL.approvedStatus,
424: approverPersonIdIn => l_approver_id,
425: approverUserIdIn => NULL,
426: transactionTypeIn => 'APINV');
427:

Line 431: approvalStatusIn => AME_UTIL.rejectStatus,

427:
428: ELSE
429: AME_API.updateApprovalStatus2(applicationIdIn => 200,
430: transactionIdIn => to_char(l_invoice_id),
431: approvalStatusIn => AME_UTIL.rejectStatus,
432: approverPersonIdIn => l_approver_id,
433: approverUserIdIn => NULL,
434: transactionTypeIn => 'APINV');
435: END IF;

Line 475: l_next_approver AME_UTIL.approverRecord;

471:
472: PROCEDURE insert_history(itemtype IN VARCHAR2,
473: itemkey IN VARCHAR2 ) IS
474:
475: l_next_approver AME_UTIL.approverRecord;
476: l_admin_approver AME_UTIL.approverRecord;
477: l_ret_approver VARCHAR2(50);
478: l_name VARCHAR2(30);
479: l_display_name VARCHAR2(150);

Line 476: l_admin_approver AME_UTIL.approverRecord;

472: PROCEDURE insert_history(itemtype IN VARCHAR2,
473: itemkey IN VARCHAR2 ) IS
474:
475: l_next_approver AME_UTIL.approverRecord;
476: l_admin_approver AME_UTIL.approverRecord;
477: l_ret_approver VARCHAR2(50);
478: l_name VARCHAR2(30);
479: l_display_name VARCHAR2(150);
480: l_debug_info VARCHAR2(50);

Line 626: l_esc_approver AME_UTIL.approverRecord;

622: actid IN NUMBER,
623: funcmode IN VARCHAR2,
624: resultout OUT NOCOPY VARCHAR2 ) IS
625:
626: l_esc_approver AME_UTIL.approverRecord;
627: l_admin_approver AME_UTIL.approverRecord;
628: l_ret_approver VARCHAR2(50);
629: l_name VARCHAR2(30);
630: l_display_name VARCHAR2(150);

Line 627: l_admin_approver AME_UTIL.approverRecord;

623: funcmode IN VARCHAR2,
624: resultout OUT NOCOPY VARCHAR2 ) IS
625:
626: l_esc_approver AME_UTIL.approverRecord;
627: l_admin_approver AME_UTIL.approverRecord;
628: l_ret_approver VARCHAR2(50);
629: l_name VARCHAR2(30);
630: l_display_name VARCHAR2(150);
631: l_debug_info VARCHAR2(50);

Line 675: l_esc_approver.api_insertion := ame_util.apiInsertion;

671: 'APINV_AHI');
672:
673: l_esc_approver.user_id := NULL;
674: l_esc_approver.person_id := l_manager_id;
675: l_esc_approver.api_insertion := ame_util.apiInsertion;
676: l_esc_approver.authority := ame_util.authorityApprover;
677: l_esc_approver.approval_status := ame_util.forwardStatus;
678:
679: --update AME

Line 676: l_esc_approver.authority := ame_util.authorityApprover;

672:
673: l_esc_approver.user_id := NULL;
674: l_esc_approver.person_id := l_manager_id;
675: l_esc_approver.api_insertion := ame_util.apiInsertion;
676: l_esc_approver.authority := ame_util.authorityApprover;
677: l_esc_approver.approval_status := ame_util.forwardStatus;
678:
679: --update AME
680: /*AME_API.updateApprovalStatus2(200,

Line 677: l_esc_approver.approval_status := ame_util.forwardStatus;

673: l_esc_approver.user_id := NULL;
674: l_esc_approver.person_id := l_manager_id;
675: l_esc_approver.api_insertion := ame_util.apiInsertion;
676: l_esc_approver.authority := ame_util.authorityApprover;
677: l_esc_approver.approval_status := ame_util.forwardStatus;
678:
679: --update AME
680: /*AME_API.updateApprovalStatus2(200,
681: l_invoice_id,

Line 682: ame_util.noResponseStatus,

678:
679: --update AME
680: /*AME_API.updateApprovalStatus2(200,
681: l_invoice_id,
682: ame_util.noResponseStatus,
683: l_employee_id,
684: null,
685: 'APINV',
686: l_esc_approver);*/

Line 690: approvalStatusIn => AME_UTIL.noResponseStatus,

686: l_esc_approver);*/
687:
688: AME_API.updateApprovalStatus2(applicationIdIn => 200,
689: transactionIdIn => to_char(l_invoice_id),
690: approvalStatusIn => AME_UTIL.noResponseStatus,
691: approverPersonIdIn => l_employee_id,
692: approverUserIdIn => NULL,
693: transactionTypeIn => 'APINV',
694: forwardeeIn => l_esc_approver);