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.AP_WEB_EXPENSE_WF dependencies on AME_UTIL

Line 9877: l_forwarder AME_UTIL.approverRecord2;

9873: l_preparer_id NUMBER;
9874: l_preparer_name wf_users.name%type;
9875: l_preparer_display_name wf_users.display_name%type;
9876: l_AMEEnabled VARCHAR2(1);
9877: l_forwarder AME_UTIL.approverRecord2;
9878: l_forwardee AME_UTIL.approverRecord2;
9879: l_approver_id NUMBER;
9880: l_approver_name varchar2(240);
9881:

Line 9878: l_forwardee AME_UTIL.approverRecord2;

9874: l_preparer_name wf_users.name%type;
9875: l_preparer_display_name wf_users.display_name%type;
9876: l_AMEEnabled VARCHAR2(1);
9877: l_forwarder AME_UTIL.approverRecord2;
9878: l_forwardee AME_UTIL.approverRecord2;
9879: l_approver_id NUMBER;
9880: l_approver_name varchar2(240);
9881:
9882: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;

Line 9895: l_nextApproversOut ame_util.approversTable2;

9891: C_WF_Version NUMBER := 0;
9892:
9893: l_itemkey wf_items.item_key%TYPE;
9894: l_approvalProcessCompleteYNOut varchar2(1);
9895: l_nextApproversOut ame_util.approversTable2;
9896: l_ApproverAuthority varchar2(10);
9897: l_oldApproversOut ame_util.approversTable2;
9898:
9899: CURSOR c_person_id IS

Line 9897: l_oldApproversOut ame_util.approversTable2;

9893: l_itemkey wf_items.item_key%TYPE;
9894: l_approvalProcessCompleteYNOut varchar2(1);
9895: l_nextApproversOut ame_util.approversTable2;
9896: l_ApproverAuthority varchar2(10);
9897: l_oldApproversOut ame_util.approversTable2;
9898:
9899: CURSOR c_person_id IS
9900: SELECT orig_system_id
9901: FROM wf_roles

Line 10058: -- need to set approval status to ame_util.forwardStatus so the

10054: l_itemkey := p_item_key;
10055: END IF;
10056:
10057: -- For bug 3062917, if AME is enabled and the approval is forwarded,
10058: -- need to set approval status to ame_util.forwardStatus so the
10059: -- current approver doesn't have to approve again later.
10060:
10061: ----------------------------------------------------------------
10062: l_debug_info := 'Retrieving APPROVER_ID Item Attribute';

Line 10105: l_forwarder.approval_status := ame_util.forwardStatus;

10101:
10102: /*
10103: l_forwarder.user_id := null;
10104: l_forwarder.person_id := l_approver_id;
10105: l_forwarder.approval_status := ame_util.forwardStatus;
10106: l_forwarder.authority := ame_util.authorityApprover;
10107:
10108: l_forwardee.user_id := null;
10109: l_forwardee.person_id := l_TransferToID;

Line 10106: l_forwarder.authority := ame_util.authorityApprover;

10102: /*
10103: l_forwarder.user_id := null;
10104: l_forwarder.person_id := l_approver_id;
10105: l_forwarder.approval_status := ame_util.forwardStatus;
10106: l_forwarder.authority := ame_util.authorityApprover;
10107:
10108: l_forwardee.user_id := null;
10109: l_forwardee.person_id := l_TransferToID;
10110: l_forwardee.api_insertion := ame_util.apiAuthorityInsertion;

Line 10110: l_forwardee.api_insertion := ame_util.apiAuthorityInsertion;

10106: l_forwarder.authority := ame_util.authorityApprover;
10107:
10108: l_forwardee.user_id := null;
10109: l_forwardee.person_id := l_TransferToID;
10110: l_forwardee.api_insertion := ame_util.apiAuthorityInsertion;
10111: l_forwardee.authority := ame_util.authorityApprover;
10112: l_forwardee.approval_status := null;
10113:
10114:

Line 10111: l_forwardee.authority := ame_util.authorityApprover;

10107:
10108: l_forwardee.user_id := null;
10109: l_forwardee.person_id := l_TransferToID;
10110: l_forwardee.api_insertion := ame_util.apiAuthorityInsertion;
10111: l_forwardee.authority := ame_util.authorityApprover;
10112: l_forwardee.approval_status := null;
10113:
10114:
10115: AME_API.updateApprovalStatus(applicationIdIn => AP_WEB_DB_UTIL_PKG.GetApplicationID,

Line 10123: l_forwarder.approval_status := ame_util.forwardStatus;

10119: transactionTypeIn => p_item_type);
10120: */
10121:
10122: l_forwarder.name := l_approver_name;
10123: l_forwarder.approval_status := ame_util.forwardStatus;
10124: l_forwarder.authority := nvl(l_ApproverAuthority,ame_util.authorityApprover);
10125:
10126: l_forwardee.name := l_TransferToName;
10127: l_forwardee.authority := nvl(l_ApproverAuthority,ame_util.authorityApprover);

Line 10124: l_forwarder.authority := nvl(l_ApproverAuthority,ame_util.authorityApprover);

10120: */
10121:
10122: l_forwarder.name := l_approver_name;
10123: l_forwarder.approval_status := ame_util.forwardStatus;
10124: l_forwarder.authority := nvl(l_ApproverAuthority,ame_util.authorityApprover);
10125:
10126: l_forwardee.name := l_TransferToName;
10127: l_forwardee.authority := nvl(l_ApproverAuthority,ame_util.authorityApprover);
10128: -- Bug 7272553

Line 10127: l_forwardee.authority := nvl(l_ApproverAuthority,ame_util.authorityApprover);

10123: l_forwarder.approval_status := ame_util.forwardStatus;
10124: l_forwarder.authority := nvl(l_ApproverAuthority,ame_util.authorityApprover);
10125:
10126: l_forwardee.name := l_TransferToName;
10127: l_forwardee.authority := nvl(l_ApproverAuthority,ame_util.authorityApprover);
10128: -- Bug 7272553
10129: -- Bug 7463317, altered if condition as suggested by AME dev for vacation rules.
10130: if (l_forwarder.authority = ame_util.authorityApprover and
10131: l_forwarder.api_insertion <> ame_util.apiInsertion) then

Line 10130: if (l_forwarder.authority = ame_util.authorityApprover and

10126: l_forwardee.name := l_TransferToName;
10127: l_forwardee.authority := nvl(l_ApproverAuthority,ame_util.authorityApprover);
10128: -- Bug 7272553
10129: -- Bug 7463317, altered if condition as suggested by AME dev for vacation rules.
10130: if (l_forwarder.authority = ame_util.authorityApprover and
10131: l_forwarder.api_insertion <> ame_util.apiInsertion) then
10132: l_forwardee.api_insertion := ame_util.apiAuthorityInsertion;
10133: else
10134: l_forwardee.api_insertion := ame_util.apiInsertion;

Line 10131: l_forwarder.api_insertion <> ame_util.apiInsertion) then

10127: l_forwardee.authority := nvl(l_ApproverAuthority,ame_util.authorityApprover);
10128: -- Bug 7272553
10129: -- Bug 7463317, altered if condition as suggested by AME dev for vacation rules.
10130: if (l_forwarder.authority = ame_util.authorityApprover and
10131: l_forwarder.api_insertion <> ame_util.apiInsertion) then
10132: l_forwardee.api_insertion := ame_util.apiAuthorityInsertion;
10133: else
10134: l_forwardee.api_insertion := ame_util.apiInsertion;
10135: end if;

Line 10132: l_forwardee.api_insertion := ame_util.apiAuthorityInsertion;

10128: -- Bug 7272553
10129: -- Bug 7463317, altered if condition as suggested by AME dev for vacation rules.
10130: if (l_forwarder.authority = ame_util.authorityApprover and
10131: l_forwarder.api_insertion <> ame_util.apiInsertion) then
10132: l_forwardee.api_insertion := ame_util.apiAuthorityInsertion;
10133: else
10134: l_forwardee.api_insertion := ame_util.apiInsertion;
10135: end if;
10136: l_forwardee.approval_status := null;

Line 10134: l_forwardee.api_insertion := ame_util.apiInsertion;

10130: if (l_forwarder.authority = ame_util.authorityApprover and
10131: l_forwarder.api_insertion <> ame_util.apiInsertion) then
10132: l_forwardee.api_insertion := ame_util.apiAuthorityInsertion;
10133: else
10134: l_forwardee.api_insertion := ame_util.apiInsertion;
10135: end if;
10136: l_forwardee.approval_status := null;
10137:
10138: AME_API2.updateApprovalStatus(applicationIdIn => AP_WEB_DB_UTIL_PKG.GetApplicationID,

Line 15204: l_nextApproversOut ame_util.approversTable2;

15200:
15201: l_debug_info varchar2(200);
15202:
15203: l_approvalProcessCompleteYNOut varchar2(1);
15204: l_nextApproversOut ame_util.approversTable2;
15205:
15206: l_childItemKeySeq number;
15207: l_childItemKey wf_items.item_key%type;
15208: l_masterUserKey wf_items.user_key%type;

Line 15244: IF (l_approvalProcessCompleteYNOut = ame_util.booleanTrue) THEN

15240: l_instructions := FND_MESSAGE.Get;
15241: raise fixable_exception ;
15242: END;
15243:
15244: IF (l_approvalProcessCompleteYNOut = ame_util.booleanTrue) THEN
15245: p_result := 'COMPLETE:Y';
15246: return;
15247: ELSIF (l_approvalProcessCompleteYNOut = ame_util2.completeNoApprovers) THEN
15248: p_result := 'COMPLETE:NOAPPROVER';

Line 15247: ELSIF (l_approvalProcessCompleteYNOut = ame_util2.completeNoApprovers) THEN

15243:
15244: IF (l_approvalProcessCompleteYNOut = ame_util.booleanTrue) THEN
15245: p_result := 'COMPLETE:Y';
15246: return;
15247: ELSIF (l_approvalProcessCompleteYNOut = ame_util2.completeNoApprovers) THEN
15248: p_result := 'COMPLETE:NOAPPROVER';
15249: return;
15250: END IF;
15251:

Line 15767: l_approverIn ame_util.approverRecord2;

15763: l_response varchar2(80);
15764: l_approvalStatusIn varchar2(20);
15765: l_approver_name varchar2(240);
15766:
15767: l_approverIn ame_util.approverRecord2;
15768:
15769: l_debug varchar2(3000);
15770: BEGIN
15771:

Line 15851: l_approvalStatusIn := AME_UTIL.approvedStatus;

15847: p_item_key,
15848: 'APPROVER_NAME');
15849:
15850: IF (l_response = 'APPROVED') THEN
15851: l_approvalStatusIn := AME_UTIL.approvedStatus;
15852: ELSIF (l_response = 'REJECTED') THEN
15853: l_approvalStatusIn := AME_UTIL.rejectStatus;
15854: ELSIF (l_response = 'NO_RESPONSE') THEN
15855: l_approvalStatusIn := AME_UTIL.noResponseStatus;

Line 15853: l_approvalStatusIn := AME_UTIL.rejectStatus;

15849:
15850: IF (l_response = 'APPROVED') THEN
15851: l_approvalStatusIn := AME_UTIL.approvedStatus;
15852: ELSIF (l_response = 'REJECTED') THEN
15853: l_approvalStatusIn := AME_UTIL.rejectStatus;
15854: ELSIF (l_response = 'NO_RESPONSE') THEN
15855: l_approvalStatusIn := AME_UTIL.noResponseStatus;
15856: ELSIF (l_response = 'FYI') THEN
15857: l_approvalStatusIn := AME_UTIL.notifiedStatus;

Line 15855: l_approvalStatusIn := AME_UTIL.noResponseStatus;

15851: l_approvalStatusIn := AME_UTIL.approvedStatus;
15852: ELSIF (l_response = 'REJECTED') THEN
15853: l_approvalStatusIn := AME_UTIL.rejectStatus;
15854: ELSIF (l_response = 'NO_RESPONSE') THEN
15855: l_approvalStatusIn := AME_UTIL.noResponseStatus;
15856: ELSIF (l_response = 'FYI') THEN
15857: l_approvalStatusIn := AME_UTIL.notifiedStatus;
15858: END IF;
15859:

Line 15857: l_approvalStatusIn := AME_UTIL.notifiedStatus;

15853: l_approvalStatusIn := AME_UTIL.rejectStatus;
15854: ELSIF (l_response = 'NO_RESPONSE') THEN
15855: l_approvalStatusIn := AME_UTIL.noResponseStatus;
15856: ELSIF (l_response = 'FYI') THEN
15857: l_approvalStatusIn := AME_UTIL.notifiedStatus;
15858: END IF;
15859:
15860: ------------------------------------------------------------------------------------------
15861: l_debug_info := 'l_response:'|| l_response || 'l_approvalStatusIn:' || l_approvalStatusIn;

Line 15979: l_nextApproversOut ame_util.approversTable2;

15975: l_check_error varchar2(1);
15976: l_result varchar2(1);
15977:
15978: l_approvalProcessCompleteYNOut varchar2(1);
15979: l_nextApproversOut ame_util.approversTable2;
15980:
15981: BEGIN
15982:
15983: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start AMECompleteApproval');

Line 16023: if (l_approvalProcessCompleteYNOut = ame_util.booleanTrue) then

16019: transactionIdIn => l_AmeMasterItemKey,
16020: approvalProcessCompleteYNOut => l_approvalProcessCompleteYNOut,
16021: nextApproversOut => l_nextApproversOut);
16022:
16023: if (l_approvalProcessCompleteYNOut = ame_util.booleanTrue) then
16024: l_result := 'Y';
16025: else
16026: raise;
16027: end if; -- end if l_approvalProcessCompleteYNOut

Line 16074: l_approversOut ame_util.approversTable2;

16070: p_result OUT NOCOPY VARCHAR2) IS
16071: ----------------------------------------------------------------------
16072: l_debug_info varchar2(200);
16073: l_approvalProcessCompleteYNOut varchar2(10);
16074: l_approversOut ame_util.approversTable2;
16075: l_report_header_id number;
16076: BEGIN
16077:
16078: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start AMESetCurrentApprover');