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 10325: l_forwarder AME_UTIL.approverRecord2 default ame_util.emptyApproverRecord2;

10321: l_preparer_display_name wf_users.display_name%type;
10322: l_employee_id NUMBER;
10323: l_AMEEnabled VARCHAR2(1);
10324: l_AmeMasterItemKey VARCHAR2(30);
10325: l_forwarder AME_UTIL.approverRecord2 default ame_util.emptyApproverRecord2;
10326: l_forwardee AME_UTIL.approverRecord2 default ame_util.emptyApproverRecord2;
10327: l_notificationIn ame_util2.notificationRecord default ame_util2.emptyNotificationRecord;
10328: l_approver_id NUMBER;
10329: l_approver_name varchar2(240);

Line 10326: l_forwardee AME_UTIL.approverRecord2 default ame_util.emptyApproverRecord2;

10322: l_employee_id NUMBER;
10323: l_AMEEnabled VARCHAR2(1);
10324: l_AmeMasterItemKey VARCHAR2(30);
10325: l_forwarder AME_UTIL.approverRecord2 default ame_util.emptyApproverRecord2;
10326: l_forwardee AME_UTIL.approverRecord2 default ame_util.emptyApproverRecord2;
10327: l_notificationIn ame_util2.notificationRecord default ame_util2.emptyNotificationRecord;
10328: l_approver_id NUMBER;
10329: l_approver_name varchar2(240);
10330: l_approverResponse varchar2(80);

Line 10327: l_notificationIn ame_util2.notificationRecord default ame_util2.emptyNotificationRecord;

10323: l_AMEEnabled VARCHAR2(1);
10324: l_AmeMasterItemKey VARCHAR2(30);
10325: l_forwarder AME_UTIL.approverRecord2 default ame_util.emptyApproverRecord2;
10326: l_forwardee AME_UTIL.approverRecord2 default ame_util.emptyApproverRecord2;
10327: l_notificationIn ame_util2.notificationRecord default ame_util2.emptyNotificationRecord;
10328: l_approver_id NUMBER;
10329: l_approver_name varchar2(240);
10330: l_approverResponse varchar2(80);
10331: l_approvalStatusIn varchar2(20);

Line 10346: l_nextApproversOut ame_util.approversTable2;

10342: C_WF_Version NUMBER := 0;
10343:
10344: l_itemkey wf_items.item_key%TYPE;
10345: l_approvalProcessCompleteYNOut varchar2(1);
10346: l_nextApproversOut ame_util.approversTable2;
10347: l_ApproverAuthority varchar2(10);
10348: l_oldApproversOut ame_util.approversTable2;
10349: -- Bug: 7463317
10350: l_approvers ame_util.approversTable2;

Line 10348: l_oldApproversOut ame_util.approversTable2;

10344: l_itemkey wf_items.item_key%TYPE;
10345: l_approvalProcessCompleteYNOut varchar2(1);
10346: l_nextApproversOut ame_util.approversTable2;
10347: l_ApproverAuthority varchar2(10);
10348: l_oldApproversOut ame_util.approversTable2;
10349: -- Bug: 7463317
10350: l_approvers ame_util.approversTable2;
10351: l_approvalProcessCompleteYN varchar2(20) := ame_util.booleanFalse;
10352: l_message_name wf_notifications.message_name%type;

Line 10350: l_approvers ame_util.approversTable2;

10346: l_nextApproversOut ame_util.approversTable2;
10347: l_ApproverAuthority varchar2(10);
10348: l_oldApproversOut ame_util.approversTable2;
10349: -- Bug: 7463317
10350: l_approvers ame_util.approversTable2;
10351: l_approvalProcessCompleteYN varchar2(20) := ame_util.booleanFalse;
10352: l_message_name wf_notifications.message_name%type;
10353: l_temp_item_key wf_items.item_key%TYPE := p_item_key;
10354: l_n_org_id Number;

Line 10351: l_approvalProcessCompleteYN varchar2(20) := ame_util.booleanFalse;

10347: l_ApproverAuthority varchar2(10);
10348: l_oldApproversOut ame_util.approversTable2;
10349: -- Bug: 7463317
10350: l_approvers ame_util.approversTable2;
10351: l_approvalProcessCompleteYN varchar2(20) := ame_util.booleanFalse;
10352: l_message_name wf_notifications.message_name%type;
10353: l_temp_item_key wf_items.item_key%TYPE := p_item_key;
10354: l_n_org_id Number;
10355: l_temp_entered_by NUMBER;

Line 10433: l_approvalStatusIn := AME_UTIL.approvedStatus;

10429: l_forwarder.name := l_approver_name;
10430: l_approverResponse := WF_NOTIFICATION.GetAttrText(l_notificationID,'RESULT');
10431:
10432: IF (l_approverResponse = 'APPROVED') THEN
10433: l_approvalStatusIn := AME_UTIL.approvedStatus;
10434: ELSIF (l_approverResponse = 'REJECTED') THEN
10435: l_approvalStatusIn := AME_UTIL.rejectStatus;
10436: ELSIF (l_approverResponse = 'NO_RESPONSE' or l_approverResponse IS NULL) THEN -- Bug 9011191(sodash): Added this clause because in case of time out, the value of the attribute RESULT is set as NULL by workflow
10437: l_approvalStatusIn := AME_UTIL.noResponseStatus;

Line 10435: l_approvalStatusIn := AME_UTIL.rejectStatus;

10431:
10432: IF (l_approverResponse = 'APPROVED') THEN
10433: l_approvalStatusIn := AME_UTIL.approvedStatus;
10434: ELSIF (l_approverResponse = 'REJECTED') THEN
10435: l_approvalStatusIn := AME_UTIL.rejectStatus;
10436: ELSIF (l_approverResponse = 'NO_RESPONSE' or l_approverResponse IS NULL) THEN -- Bug 9011191(sodash): Added this clause because in case of time out, the value of the attribute RESULT is set as NULL by workflow
10437: l_approvalStatusIn := AME_UTIL.noResponseStatus;
10438: ELSIF (l_approverResponse = 'FYI') THEN
10439: l_approvalStatusIn := AME_UTIL.notifiedStatus;

Line 10437: l_approvalStatusIn := AME_UTIL.noResponseStatus;

10433: l_approvalStatusIn := AME_UTIL.approvedStatus;
10434: ELSIF (l_approverResponse = 'REJECTED') THEN
10435: l_approvalStatusIn := AME_UTIL.rejectStatus;
10436: ELSIF (l_approverResponse = 'NO_RESPONSE' or l_approverResponse IS NULL) THEN -- Bug 9011191(sodash): Added this clause because in case of time out, the value of the attribute RESULT is set as NULL by workflow
10437: l_approvalStatusIn := AME_UTIL.noResponseStatus;
10438: ELSIF (l_approverResponse = 'FYI') THEN
10439: l_approvalStatusIn := AME_UTIL.notifiedStatus;
10440: END IF;
10441:

Line 10439: l_approvalStatusIn := AME_UTIL.notifiedStatus;

10435: l_approvalStatusIn := AME_UTIL.rejectStatus;
10436: ELSIF (l_approverResponse = 'NO_RESPONSE' or l_approverResponse IS NULL) THEN -- Bug 9011191(sodash): Added this clause because in case of time out, the value of the attribute RESULT is set as NULL by workflow
10437: l_approvalStatusIn := AME_UTIL.noResponseStatus;
10438: ELSIF (l_approverResponse = 'FYI') THEN
10439: l_approvalStatusIn := AME_UTIL.notifiedStatus;
10440: END IF;
10441:
10442: l_forwarder.approval_status := l_approvalStatusIn;
10443: l_notificationIn.notification_id := l_notificationID;

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

10620: l_itemkey := p_item_key;
10621: END IF;
10622:
10623: -- For bug 3062917, if AME is enabled and the approval is forwarded,
10624: -- need to set approval status to ame_util.forwardStatus so the
10625: -- current approver doesn't have to approve again later.
10626:
10627: ----------------------------------------------------------------
10628: l_debug_info := 'Retrieving APPROVER_ID Item Attribute';

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

10667:
10668: /*
10669: l_forwarder.user_id := null;
10670: l_forwarder.person_id := l_approver_id;
10671: l_forwarder.approval_status := ame_util.forwardStatus;
10672: l_forwarder.authority := ame_util.authorityApprover;
10673:
10674: l_forwardee.user_id := null;
10675: l_forwardee.person_id := l_TransferToID;

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

10668: /*
10669: l_forwarder.user_id := null;
10670: l_forwarder.person_id := l_approver_id;
10671: l_forwarder.approval_status := ame_util.forwardStatus;
10672: l_forwarder.authority := ame_util.authorityApprover;
10673:
10674: l_forwardee.user_id := null;
10675: l_forwardee.person_id := l_TransferToID;
10676: l_forwardee.api_insertion := ame_util.apiAuthorityInsertion;

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

10672: l_forwarder.authority := ame_util.authorityApprover;
10673:
10674: l_forwardee.user_id := null;
10675: l_forwardee.person_id := l_TransferToID;
10676: l_forwardee.api_insertion := ame_util.apiAuthorityInsertion;
10677: l_forwardee.authority := ame_util.authorityApprover;
10678: l_forwardee.approval_status := null;
10679:
10680:

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

10673:
10674: l_forwardee.user_id := null;
10675: l_forwardee.person_id := l_TransferToID;
10676: l_forwardee.api_insertion := ame_util.apiAuthorityInsertion;
10677: l_forwardee.authority := ame_util.authorityApprover;
10678: l_forwardee.approval_status := null;
10679:
10680:
10681: AME_API.updateApprovalStatus(applicationIdIn => AP_WEB_DB_UTIL_PKG.GetApplicationID,

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

10685: transactionTypeIn => p_item_type);
10686: */
10687:
10688: /*l_forwarder.name := l_approver_name;
10689: l_forwarder.approval_status := ame_util.forwardStatus;
10690: l_forwarder.authority := nvl(l_ApproverAuthority,ame_util.authorityApprover);*/
10691:
10692: -- Bug: 7463317
10693: ame_api2.getAllApprovers7

Line 10690: l_forwarder.authority := nvl(l_ApproverAuthority,ame_util.authorityApprover);*/

10686: */
10687:
10688: /*l_forwarder.name := l_approver_name;
10689: l_forwarder.approval_status := ame_util.forwardStatus;
10690: l_forwarder.authority := nvl(l_ApproverAuthority,ame_util.authorityApprover);*/
10691:
10692: -- Bug: 7463317
10693: ame_api2.getAllApprovers7
10694: (applicationIdIn => AP_WEB_DB_UTIL_PKG.GetApplicationID

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

10702: if l_approvers(i).orig_system_id = l_approver_id then
10703: l_forwarder := l_approvers(i);
10704: -- Bug: 7463317, set the approval status to forwarded so that AME does not wait for
10705: -- the approval from the forwarder when vacation rules are set.
10706: l_forwarder.approval_status := ame_util.forwardStatus;
10707: exit;
10708: end if;
10709: END LOOP;
10710:

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

10708: end if;
10709: END LOOP;
10710:
10711: l_forwardee.name := l_TransferToName;
10712: l_forwardee.authority := nvl(l_ApproverAuthority,ame_util.authorityApprover);
10713:
10714: -- Bug: 7463317, change the if condition according to the suggestions by AME
10715: if (l_forwarder.authority = ame_util.authorityApprover and
10716: l_forwarder.api_insertion <> ame_util.apiInsertion) then

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

10711: l_forwardee.name := l_TransferToName;
10712: l_forwardee.authority := nvl(l_ApproverAuthority,ame_util.authorityApprover);
10713:
10714: -- Bug: 7463317, change the if condition according to the suggestions by AME
10715: if (l_forwarder.authority = ame_util.authorityApprover and
10716: l_forwarder.api_insertion <> ame_util.apiInsertion) then
10717: l_forwardee.api_insertion := ame_util.apiAuthorityInsertion;
10718: else
10719: l_forwardee.api_insertion := ame_util.apiInsertion;

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

10712: l_forwardee.authority := nvl(l_ApproverAuthority,ame_util.authorityApprover);
10713:
10714: -- Bug: 7463317, change the if condition according to the suggestions by AME
10715: if (l_forwarder.authority = ame_util.authorityApprover and
10716: l_forwarder.api_insertion <> ame_util.apiInsertion) then
10717: l_forwardee.api_insertion := ame_util.apiAuthorityInsertion;
10718: else
10719: l_forwardee.api_insertion := ame_util.apiInsertion;
10720: end if;

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

10713:
10714: -- Bug: 7463317, change the if condition according to the suggestions by AME
10715: if (l_forwarder.authority = ame_util.authorityApprover and
10716: l_forwarder.api_insertion <> ame_util.apiInsertion) then
10717: l_forwardee.api_insertion := ame_util.apiAuthorityInsertion;
10718: else
10719: l_forwardee.api_insertion := ame_util.apiInsertion;
10720: end if;
10721: l_forwardee.approval_status := null;

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

10715: if (l_forwarder.authority = ame_util.authorityApprover and
10716: l_forwarder.api_insertion <> ame_util.apiInsertion) then
10717: l_forwardee.api_insertion := ame_util.apiAuthorityInsertion;
10718: else
10719: l_forwardee.api_insertion := ame_util.apiInsertion;
10720: end if;
10721: l_forwardee.approval_status := null;
10722:
10723: l_notificationIn.notification_id := l_notificationID;

Line 16170: l_nextApproversOut ame_util.approversTable2;

16166:
16167: l_debug_info varchar2(200);
16168:
16169: l_approvalProcessCompleteYNOut varchar2(1);
16170: l_nextApproversOut ame_util.approversTable2;
16171:
16172: l_childItemKeySeq number;
16173: l_childItemKey wf_items.item_key%type;
16174: l_child_item_key wf_items.item_key%type;

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

16238: l_childItemKeySeq := WF_ENGINE.GetItemAttrNumber(p_item_type,
16239: p_item_key,
16240: 'AME_CHILD_ITEM_KEY_SEQ');
16241:
16242: IF (l_approvalProcessCompleteYNOut = ame_util.booleanTrue) THEN
16243: BEGIN
16244: -- Bug 8490741: To cancel other active approval processes
16245: IF (l_childItemKeySeq IS NOT NULL AND l_childItemKeySeq > 0) THEN
16246: FOR i in 1 .. l_childItemKeySeq LOOP

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

16277: NULL;
16278: END;
16279: p_result := 'COMPLETE:Y';
16280: return;
16281: ELSIF (l_approvalProcessCompleteYNOut = ame_util2.completeNoApprovers) THEN
16282: p_result := 'COMPLETE:NOAPPROVER';
16283: return;
16284: END IF;
16285:

Line 16840: l_approverIn ame_util.approverRecord2;

16836: l_response varchar2(80);
16837: l_approvalStatusIn varchar2(20);
16838: l_approver_name varchar2(240);
16839:
16840: l_approverIn ame_util.approverRecord2;
16841:
16842: l_debug varchar2(3000);
16843: BEGIN
16844:

Line 16946: l_approvalStatusIn := AME_UTIL.approvedStatus;

16942: p_item_key,
16943: 'APPROVER_NAME');
16944:
16945: IF (l_response = 'APPROVED') THEN
16946: l_approvalStatusIn := AME_UTIL.approvedStatus;
16947: ELSIF (l_response = 'REJECTED') THEN
16948: l_approvalStatusIn := AME_UTIL.rejectStatus;
16949: ELSIF (l_response = 'NO_RESPONSE') THEN
16950: l_approvalStatusIn := AME_UTIL.noResponseStatus;

Line 16948: l_approvalStatusIn := AME_UTIL.rejectStatus;

16944:
16945: IF (l_response = 'APPROVED') THEN
16946: l_approvalStatusIn := AME_UTIL.approvedStatus;
16947: ELSIF (l_response = 'REJECTED') THEN
16948: l_approvalStatusIn := AME_UTIL.rejectStatus;
16949: ELSIF (l_response = 'NO_RESPONSE') THEN
16950: l_approvalStatusIn := AME_UTIL.noResponseStatus;
16951: ELSIF (l_response = 'FYI') THEN
16952: l_approvalStatusIn := AME_UTIL.notifiedStatus;

Line 16950: l_approvalStatusIn := AME_UTIL.noResponseStatus;

16946: l_approvalStatusIn := AME_UTIL.approvedStatus;
16947: ELSIF (l_response = 'REJECTED') THEN
16948: l_approvalStatusIn := AME_UTIL.rejectStatus;
16949: ELSIF (l_response = 'NO_RESPONSE') THEN
16950: l_approvalStatusIn := AME_UTIL.noResponseStatus;
16951: ELSIF (l_response = 'FYI') THEN
16952: l_approvalStatusIn := AME_UTIL.notifiedStatus;
16953: END IF;
16954:

Line 16952: l_approvalStatusIn := AME_UTIL.notifiedStatus;

16948: l_approvalStatusIn := AME_UTIL.rejectStatus;
16949: ELSIF (l_response = 'NO_RESPONSE') THEN
16950: l_approvalStatusIn := AME_UTIL.noResponseStatus;
16951: ELSIF (l_response = 'FYI') THEN
16952: l_approvalStatusIn := AME_UTIL.notifiedStatus;
16953: END IF;
16954:
16955: ------------------------------------------------------------------------------------------
16956: l_debug_info := 'l_response:'|| l_response || 'l_approvalStatusIn:' || l_approvalStatusIn;

Line 17077: l_nextApproversOut ame_util.approversTable2;

17073: l_check_error varchar2(1);
17074: l_result varchar2(1);
17075:
17076: l_approvalProcessCompleteYNOut varchar2(1);
17077: l_nextApproversOut ame_util.approversTable2;
17078:
17079: BEGIN
17080:
17081: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start AMECompleteApproval');

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

17117: transactionIdIn => l_AmeMasterItemKey,
17118: approvalProcessCompleteYNOut => l_approvalProcessCompleteYNOut,
17119: nextApproversOut => l_nextApproversOut);
17120:
17121: if (l_approvalProcessCompleteYNOut = ame_util.booleanTrue) then
17122: l_result := 'Y';
17123: else
17124: raise;
17125: end if; -- end if l_approvalProcessCompleteYNOut

Line 17172: l_approversOut ame_util.approversTable2;

17168: p_result OUT NOCOPY VARCHAR2) IS
17169: ----------------------------------------------------------------------
17170: l_debug_info varchar2(200);
17171: l_approvalProcessCompleteYNOut varchar2(10);
17172: l_approversOut ame_util.approversTable2;
17173: l_report_header_id number;
17174: BEGIN
17175:
17176: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start AMESetCurrentApprover');