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 DUAL

Line 5377: from dual

5373: and orig_system = origSystemIn
5374: and rownum <2;
5375: cursor getStatus(c_nameIn in varchar2) is
5376: select 1
5377: from dual
5378: where exists
5379: (select null
5380: from ame_trans_approval_history a
5381: where application_id = engAmeApplicationId

Line 9353: from dual;

9349: and approvers(i).approval_status = ame_util.notifiedStatus
9350: then
9351: select ame_trans_approval_history_s.nextval
9352: into tempTransHistoryId
9353: from dual;
9354: insert into AME_TRANS_APPROVAL_HISTORY
9355: (TRANS_HISTORY_ID
9356: ,TRANSACTION_ID
9357: ,APPLICATION_ID

Line 9393: from dual;

9389: ,approvers(i).member_order_number
9390: ,notificationIdIn
9391: ,null
9392: ,null
9393: from dual;
9394: end if;
9395: end loop;
9396: return;
9397: end if;

Line 9411: from dual;

9407: -- and approvers(i).approval_status = ame_util.notifiedStatus
9408: then
9409: select ame_trans_approval_history_s.nextval
9410: into tempTransHistoryId
9411: from dual;
9412: insert into AME_TRANS_APPROVAL_HISTORY
9413: (TRANS_HISTORY_ID
9414: ,TRANSACTION_ID
9415: ,APPLICATION_ID

Line 9451: from dual;

9447: ,approvers(i).member_order_number
9448: ,notificationIdIn
9449: ,null
9450: ,null
9451: from dual;
9452: end if;
9453: end loop;
9454: return;
9455: end if;

Line 9458: from dual;

9454: return;
9455: end if;
9456: select ame_trans_approval_history_s.nextval
9457: into tempTransHistoryId
9458: from dual;
9459: if historyTypeIn = 'APPROVERPRESENT' then
9460: insert into AME_TRANS_APPROVAL_HISTORY
9461: (TRANS_HISTORY_ID
9462: ,TRANSACTION_ID

Line 9694: select ame_temp_transactions_s.nextval into tempTransSeqId from dual;

9690: application_id = engAmeApplicationId and
9691: transaction_id = engTransactionId and
9692: rownum < 2; /* Avoids second fetch otherwise required by ANSI standard to check for too many rows. */
9693: if(tempCount = 0) then
9694: select ame_temp_transactions_s.nextval into tempTransSeqId from dual;
9695: insert into ame_temp_transactions(
9696: application_id,
9697: transaction_id,
9698: row_timestamp,

Line 13048: ,ame_util.repeatedStatus) into tempStatus from dual;

13044: ,ame_util2.reassignStatus
13045: ,ame_util.nullStatus
13046: ,ame_util.noResponseStatus
13047: ,ame_util2.noResponseByRepeatedStatus
13048: ,ame_util.repeatedStatus) into tempStatus from dual;
13049: setInsertedApprovalStatus(currentApproverIndexIn => repeatedAppIndexes(z)
13050: ,approvalStatusIn => tempStatus);
13051: l_frw_index := repeatedAppIndexes(z);
13052: l_actionTypeId := currentApprovers(l_frw_index).action_type_id;