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_INSERTIONS

Line 1968: from ame_temp_insertions

1964: maxInsertionOrderNumber number;
1965: begin
1966: select max(insertion_order)
1967: into maxInsertionOrderNumber
1968: from ame_temp_insertions
1969: where transaction_id = engTransactionId
1970: and application_id = engAmeApplicationId;
1971: if maxinsertionOrderNumber is null
1972: then

Line 5034: from ame_temp_insertions

5030: insertion_order,
5031: effective_date,
5032: reason,
5033: approval_status
5034: from ame_temp_insertions
5035: where
5036: application_id = applicationIdIn and
5037: transaction_id = transactionIdIn
5038: order by insertion_order;

Line 6133: parameter ame_temp_insertions.parameter%type;

6129: origSystemOut out nocopy varchar2,
6130: origSystemIdOut out nocopy integer,
6131: displayNameOut out nocopy varchar2,
6132: sourceOut out nocopy varchar2) as
6133: parameter ame_temp_insertions.parameter%type;
6134: l_error_code number;
6135: l_action_type_name varchar2(100);
6136: errorCode integer;
6137: errorMessage ame_util.longestStringType;

Line 6198: parameter ame_temp_insertions.parameter%type;

6194: origSystemOut out nocopy varchar2,
6195: origSystemIdOut out nocopy integer,
6196: displayNameOut out nocopy varchar2,
6197: sourceOut out nocopy varchar2) as
6198: parameter ame_temp_insertions.parameter%type;
6199: l_error_code number;
6200: errorCode integer;
6201: errorMessage ame_util.longestStringType;
6202: l_action_type_name varchar2(200);

Line 6764: nextApproverDescription ame_temp_insertions.description%type;

6760: availableInsertionsIndex integer; /* pre-increment */
6761: errorCode integer;
6762: errorMessage ame_util.longestStringType;
6763: invalidPositionException exception;
6764: nextApproverDescription ame_temp_insertions.description%type;
6765: prevApproverDescription ame_temp_insertions.description%type;
6766: ruleIdList ame_util.idList;
6767: sourceDescription ame_util.stringType;
6768: tempBoolean boolean;

Line 6765: prevApproverDescription ame_temp_insertions.description%type;

6761: errorCode integer;
6762: errorMessage ame_util.longestStringType;
6763: invalidPositionException exception;
6764: nextApproverDescription ame_temp_insertions.description%type;
6765: prevApproverDescription ame_temp_insertions.description%type;
6766: ruleIdList ame_util.idList;
6767: sourceDescription ame_util.stringType;
6768: tempBoolean boolean;
6769: tempInsertionDoesNotExist boolean;

Line 6770: tempParameter ame_temp_insertions.parameter%type;

6766: ruleIdList ame_util.idList;
6767: sourceDescription ame_util.stringType;
6768: tempBoolean boolean;
6769: tempInsertionDoesNotExist boolean;
6770: tempParameter ame_temp_insertions.parameter%type;
6771: l_error_code number;
6772: begin
6773:
6774: engStApproversCount := engStApprovers.count;

Line 9018: If the status is not available in ame_temp_insertions get it from

9014: /* Copy the input approver to the target index. */
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)

Line 9989: tempItemClass ame_temp_insertions.item_class%type;

9985: tempAnchorIndex integer;
9986: tempBoolean boolean;
9987: tempIndex integer;
9988: tempIndex2 integer;
9989: tempItemClass ame_temp_insertions.item_class%type;
9990: tempItemId ame_temp_insertions.item_id%type;
9991: tempOrderType ame_temp_insertions.order_type%type;
9992: l_error_code number;
9993: errorCode integer;

Line 9990: tempItemId ame_temp_insertions.item_id%type;

9986: tempBoolean boolean;
9987: tempIndex integer;
9988: tempIndex2 integer;
9989: tempItemClass ame_temp_insertions.item_class%type;
9990: tempItemId ame_temp_insertions.item_id%type;
9991: tempOrderType ame_temp_insertions.order_type%type;
9992: l_error_code number;
9993: errorCode integer;
9994: errorMessage ame_util.longestStringType;

Line 9991: tempOrderType ame_temp_insertions.order_type%type;

9987: tempIndex integer;
9988: tempIndex2 integer;
9989: tempItemClass ame_temp_insertions.item_class%type;
9990: tempItemId ame_temp_insertions.item_id%type;
9991: tempOrderType ame_temp_insertions.order_type%type;
9992: l_error_code number;
9993: errorCode integer;
9994: errorMessage ame_util.longestStringType;
9995: begin

Line 11914: update ame_temp_insertions

11910: if insIndex is not null then
11911: loop
11912: if engInsApproverIndex(insIndex) = currentApproverIndexIn then
11913: engInsertedApproverList(insIndex).approval_status := approvalStatusIn;
11914: update ame_temp_insertions
11915: set approval_status = approvalStatusIn
11916: where application_id = engAmeApplicationId
11917: and transaction_id = engTransactionId
11918: and insertion_order = engInsertionOrderList(insIndex)

Line 12560: tempParameter ame_temp_insertions.parameter%type;

12556: repeatedIndexes ame_util.idList;
12557: repeatedAppIndexes ame_util.idList;
12558: superiorApprover ame_util.approverRecord2;
12559: tempInsertionOrder integer;
12560: tempParameter ame_temp_insertions.parameter%type;
12561: tempCOAGroupActionTypeId integer;
12562: tempPreGroupActionTypeId integer;
12563: tempPostGroupActionTypeId integer;
12564: votingRegime ame_util.charType;

Line 13296: insert into ame_temp_insertions(

13292: ame_util.fieldDelimiter ||
13293: approver.group_or_chain_id ||
13294: ame_util.fieldDelimiter ||
13295: approver.occurrence;
13296: insert into ame_temp_insertions(
13297: transaction_id,
13298: application_id,
13299: insertion_order,
13300: order_type,

Line 13382: insert into ame_temp_insertions(

13378: ame_util.fieldDelimiter ||
13379: approver.group_or_chain_id ||
13380: ame_util.fieldDelimiter ||
13381: approver.occurrence;
13382: insert into ame_temp_insertions(
13383: transaction_id,
13384: application_id,
13385: insertion_order,
13386: order_type,

Line 13459: insert into ame_temp_insertions(

13455: ame_util.fieldDelimiter ||
13456: approver.group_or_chain_id ||
13457: ame_util.fieldDelimiter ||
13458: approver.occurrence;
13459: insert into ame_temp_insertions(
13460: transaction_id,
13461: application_id,
13462: insertion_order,
13463: order_type,

Line 13505: insert into ame_temp_insertions(

13501: ame_util.fieldDelimiter ||
13502: forwardee.group_or_chain_id ||
13503: ame_util.fieldDelimiter ||
13504: forwardee.occurrence;
13505: insert into ame_temp_insertions(
13506: transaction_id,
13507: application_id,
13508: insertion_order,
13509: order_type,

Line 13561: insert into ame_temp_insertions(

13557: ame_util.fieldDelimiter ||
13558: approver.group_or_chain_id ||
13559: ame_util.fieldDelimiter ||
13560: approver.occurrence;
13561: insert into ame_temp_insertions(
13562: transaction_id,
13563: application_id,
13564: insertion_order,
13565: order_type,

Line 13639: insert into ame_temp_insertions(

13635: ame_util.fieldDelimiter ||
13636: insertedApprover.group_or_chain_id ||
13637: ame_util.fieldDelimiter ||
13638: insertedApprover.occurrence;
13639: insert into ame_temp_insertions(
13640: transaction_id,
13641: application_id,
13642: insertion_order,
13643: order_type,

Line 13710: insert into ame_temp_insertions(

13706: ame_util.fieldDelimiter ||
13707: approver.group_or_chain_id ||
13708: ame_util.fieldDelimiter ||
13709: prevApproverOccurrence;
13710: insert into ame_temp_insertions(
13711: transaction_id,
13712: application_id,
13713: insertion_order,
13714: order_type,

Line 13875: update ame_temp_insertions

13871: tempIndex := engStInsertionIndexes.next(indexIn);
13872: while engStInsertionIndexes.exists(tempIndex) loop
13873: approverInsertionOrder := engStInsertionIndexes(tempIndex);
13874: if approverInsertionOrder > deletionInsertionOrder then
13875: update ame_temp_insertions
13876: set parameter = parameter - 1
13877: where insertion_order = approverInsertionOrder
13878: and application_id = engAmeApplicationId
13879: and transaction_id = engTransactionId