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.AME_ENGINE dependencies on AME_TEMP_OLD_APPROVER_LISTS

Line 11: engTransactionId ame_temp_old_approver_lists.transaction_id%type;

7: *************************************************************************************/
8: /* transaction identifiers */
9: engAmeApplicationId integer;
10: engFndApplicationId integer;
11: engTransactionId ame_temp_old_approver_lists.transaction_id%type;
12: engTransactionTypeId ame_calling_apps.transaction_type_id%type;
13: /* engTransactionIsLocked is for the transaction-locking utilities used by the APIs. */
14: engTransactionIsLocked boolean := false;
15: /*

Line 1534: itemClass ame_temp_old_approver_lists.item_class%type;

1530: itemIdIn in varchar2 default null,
1531: actionTypeIdIn in integer default null,
1532: groupOrChainIdIn in integer default null) return integer as
1533: engStApproversCount integer;
1534: itemClass ame_temp_old_approver_lists.item_class%type;
1535: itemId ame_temp_old_approver_lists.item_id%type;
1536: actionTypeId integer;
1537: groupOrChainId integer;
1538: occurrence integer;

Line 1535: itemId ame_temp_old_approver_lists.item_id%type;

1531: actionTypeIdIn in integer default null,
1532: groupOrChainIdIn in integer default null) return integer as
1533: engStApproversCount integer;
1534: itemClass ame_temp_old_approver_lists.item_class%type;
1535: itemId ame_temp_old_approver_lists.item_id%type;
1536: actionTypeId integer;
1537: groupOrChainId integer;
1538: occurrence integer;
1539: begin

Line 5302: from ame_temp_old_approver_lists

5298: approval_status,
5299: action_type_id,
5300: group_or_chain_id,
5301: occurrence
5302: from ame_temp_old_approver_lists
5303: where
5304: application_id = applicationIdIn and
5305: transaction_id = transactionIdIn
5306: order by order_number;

Line 7852: update ame_temp_old_approver_lists

7848: for x in 1 .. engStRepeatedIndexes.count loop
7849: if engStRepeatedIndexes(x) = currentTreeNode.approver_index
7850: and engStRepeatedAppIndexes(x) <> currentTreeNode.approver_index then
7851: --+
7852: update ame_temp_old_approver_lists
7853: set approval_status = ame_util.notifiedByRepeatedStatus
7854: where application_id = ameApplicationId
7855: and transaction_id = transactionIdIn
7856: and name = engStApprovers(engStRepeatedAppIndexes(x)).name --nextApproversOut(i).name

Line 7921: update ame_temp_old_approver_lists

7917: for x in 1 .. engStRepeatedIndexes.count loop
7918: if engStRepeatedIndexes(x) = engStApproversTree(currentTreeNode.sibling_index).approver_index
7919: and engStRepeatedAppIndexes(x) <> engStApproversTree(currentTreeNode.sibling_index).approver_index then
7920: --+
7921: update ame_temp_old_approver_lists
7922: set approval_status = ame_util.notifiedByRepeatedStatus
7923: where application_id = ameApplicationId
7924: and transaction_id = transactionIdIn
7925: and name = engStApprovers(engStRepeatedAppIndexes(x)).name --nextApproversOut(i).name

Line 8063: update ame_temp_old_approver_lists

8059: end if;
8060: if flagApproversAsNotifiedIn = ame_util.booleanTrue then
8061: ameApplicationId := ame_engine.getAmeApplicationId;
8062: for i in 1 .. nextApproversOut.count loop
8063: update ame_temp_old_approver_lists
8064: set approval_status = ame_util.notifiedStatus
8065: where item_class = nextApproversOut(i).item_class
8066: and item_id = nextApproversOut(i).item_id
8067: and name = nextApproversOut(i).name

Line 9019: ame_temp_old_approver_lists

9015: ame_util.copyApproverRecord2(approverRecord2In => approverIn,
9016: approverRecord2Out => engStApprovers(indexIn));
9017: /*
9018: If the status is not available in ame_temp_insertions get it from
9019: ame_temp_old_approver_lists
9020: */
9021: if engStApprovers(indexIn).approval_status is null then
9022: engStApprovers(indexIn).approval_status := getHandlerApprovalStatus(approverIn => engStApprovers(indexIn)
9023: ,isInsertionapprover => true);

Line 12444: delete from ame_temp_old_approver_lists

12440: tempOccurrences ame_util.idList;
12441: tempOrderNumbers ame_util.idList;
12442: tempStatuses ame_util.stringList;
12443: begin
12444: delete from ame_temp_old_approver_lists
12445: where
12446: application_id = engAmeApplicationId and
12447: transaction_id = engTransactionId;
12448: /*

Line 12449: Bulk insert the transaction's current state into ame_temp_old_approver_lists.

12445: where
12446: application_id = engAmeApplicationId and
12447: transaction_id = engTransactionId;
12448: /*
12449: Bulk insert the transaction's current state into ame_temp_old_approver_lists.
12450: Take the state from engStApprovers, to account for all operations on the approver list.
12451: */
12452: ame_util.convertApproversTable2ToValues(approversTableIn => engStApprovers,
12453: namesOut => tempNames,

Line 12476: insert into ame_temp_old_approver_lists(

12472: setInsertedApprovalStatus(currentApproverIndexIn => i
12473: ,approvalStatusIn => engStApprovers(i).approval_status);
12474: end loop;
12475: forall i in 1 .. tempCount
12476: insert into ame_temp_old_approver_lists(
12477: transaction_id,
12478: application_id,
12479: order_number,
12480: name,

Line 12945: Update the status of approverIn in ame_temp_old_approver_lists. If updateItemIn

12941: ,userCommentsIn => notificationIn.user_comments
12942: ,dateClearedIn => null
12943: ,historyTypeIn => 'APPROVERPRESENT');
12944: /*
12945: Update the status of approverIn in ame_temp_old_approver_lists. If updateItemIn
12946: is true, update also any other occurrences of the same approver for the same item
12947: class and item ID.
12948: */
12949: if(updateItemIn) then

Line 12952: update ame_temp_old_approver_lists

12948: */
12949: if(updateItemIn) then
12950: if(approver.approval_status in (ame_util.forwardStatus, ame_util.approveAndForwardStatus)) then
12951: /* Update the forwarder proper. */
12952: update ame_temp_old_approver_lists
12953: set approval_status = approver.approval_status
12954: where
12955: application_id = ameApplicationId and
12956: transaction_id = transactionIdIn and

Line 12964: update ame_temp_old_approver_lists

12960: action_type_id = approver.action_type_id and
12961: group_or_chain_id = approver.group_or_chain_id and
12962: occurrence = approver.occurrence;
12963: /* Suppress other occurrences of the approver, for the same item. */
12964: update ame_temp_old_approver_lists
12965: set approval_status = ame_util.suppressedStatus
12966: where
12967: application_id = ameApplicationId and
12968: transaction_id = transactionIdIn and

Line 12976: update ame_temp_old_approver_lists

12972: (action_type_id <> approver.action_type_id or
12973: group_or_chain_id <> approver.group_or_chain_id or
12974: occurrence <> approver.occurrence);
12975: else
12976: update ame_temp_old_approver_lists
12977: set approval_status = approver.approval_status
12978: where
12979: application_id = ameApplicationId and
12980: transaction_id = transactionIdIn and

Line 12986: update ame_temp_old_approver_lists

12982: item_class = approver.item_class and
12983: item_id = approver.item_id;
12984: end if;
12985: else
12986: update ame_temp_old_approver_lists
12987: set approval_status = approver.approval_status
12988: where
12989: application_id = ameApplicationId and
12990: transaction_id = transactionIdIn and

Line 13010: update ame_temp_old_approver_lists

13006: ,ame_util.forwardStatus
13007: ,ame_util.noResponseStatus) then
13008: for z in 1 .. repeatedIndexes.count loop
13009: if repeatedIndexes(z) = approverInIndex and repeatedAppIndexes(z) <> approverInIndex then
13010: update ame_temp_old_approver_lists
13011: set approval_status = decode(approver.approval_status
13012: ,ame_util.approvedStatus
13013: ,ame_util.approvedByRepeatedStatus
13014: ,ame_util.approveAndForwardStatus

Line 13064: from ame_temp_old_approver_lists

13060: if l_votingRegime = ame_util.firstApproverVoting then
13061: tempfrwCount := 0;
13062: select count(*)
13063: into tempfrwCount
13064: from ame_temp_old_approver_lists
13065: where
13066: application_id = ameApplicationId and
13067: transaction_id = transactionIdIn and
13068: item_class = currentApprovers(l_frw_index).item_class and

Line 13076: from ame_temp_old_approver_lists

13072: approver_category = ame_util.approvalApproverCategory and
13073: approval_status in (ame_util.notifiedStatus
13074: ,ame_util.notifiedByRepeatedStatus) and
13075: exists ( select null
13076: from ame_temp_old_approver_lists
13077: where application_id = ameApplicationId and
13078: transaction_id = transactionIdIn and
13079: item_class = currentApprovers(l_frw_index).item_class and
13080: item_id = currentApprovers(l_frw_index).item_id and

Line 13090: from ame_temp_old_approver_lists

13086: ,ame_util.rejectStatus
13087: ,ame_util.rejectedByRepeatedStatus)
13088: ) and
13089: not exists ( select null
13090: from ame_temp_old_approver_lists
13091: where application_id = ameApplicationId and
13092: transaction_id = transactionIdIn and
13093: item_class = currentApprovers(l_frw_index).item_class and
13094: item_id = currentApprovers(l_frw_index).item_id and

Line 13102: update ame_temp_old_approver_lists

13098: (approval_status is null or approval_status in (
13099: ame_util.nullStatus
13100: ,ame_util.repeatedStatus)));
13101: if tempfrwCount > 0 then
13102: update ame_temp_old_approver_lists
13103: set approval_status = ame_util.beatByFirstResponderStatus
13104: where
13105: application_id = ameApplicationId and
13106: transaction_id = transactionIdIn and

Line 13165: update ame_temp_old_approver_lists

13161: approverIn must be the first responder (otherwise, they would be suppressed,
13162: and we would have returned above). Suppress the other approval approvers in the
13163: group or chain (including other occurrences of the input approver).
13164: */
13165: update ame_temp_old_approver_lists
13166: set approval_status = ame_util.beatByFirstResponderStatus
13167: where
13168: application_id = ameApplicationId and
13169: transaction_id = transactionIdIn and

Line 13217: update ame_temp_old_approver_lists

13213: /*
13214: the approval status is null. This is the request to clear the approval status.
13215: As this approver is from a FRW approver group, need to clear the status of all the group members.
13216: */
13217: update ame_temp_old_approver_lists
13218: set approval_status = null
13219: where
13220: application_id = ameApplicationId and
13221: transaction_id = transactionIdIn and