APPS.AME_ENGINE dependencies on DUAL

Line 9007: from dual;

9003: and approvers(i).approval_status = ame_util.notifiedStatus
9004: then
9005: select ame_trans_approval_history_s.nextval
9006: into tempTransHistoryId
9007: from dual;
9008: insert into AME_TRANS_APPROVAL_HISTORY
9009: (TRANS_HISTORY_ID
9010: ,TRANSACTION_ID
9011: ,APPLICATION_ID

Line 9047: from dual;

9043: ,approvers(i).member_order_number
9044: ,notificationIdIn
9045: ,null
9046: ,null
9047: from dual;
9048: end if;
9049: end loop;
9050: return;
9051: end if;

Line 9054: from dual;

9050: return;
9051: end if;
9052: select ame_trans_approval_history_s.nextval
9053: into tempTransHistoryId
9054: from dual;
9055: if historyTypeIn = 'APPROVERPRESENT' then
9056: insert into AME_TRANS_APPROVAL_HISTORY
9057: (TRANS_HISTORY_ID
9058: ,TRANSACTION_ID

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

9286: application_id = engAmeApplicationId and
9287: transaction_id = engTransactionId and
9288: rownum < 2; /* Avoids second fetch otherwise required by ANSI standard to check for too many rows. */
9289: if(tempCount = 0) then
9290: select ame_temp_transactions_s.nextval into tempTransSeqId from dual;
9291: insert into ame_temp_transactions(
9292: application_id,
9293: transaction_id,
9294: row_timestamp,

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

12550: ,ame_util2.reassignStatus
12551: ,ame_util.nullStatus
12552: ,ame_util.noResponseStatus
12553: ,ame_util2.noResponseByRepeatedStatus
12554: ,ame_util.repeatedStatus) into tempStatus from dual;
12555: setInsertedApprovalStatus(currentApproverIndexIn => repeatedAppIndexes(z)
12556: ,approvalStatusIn => tempStatus);
12557: end if;
12558: end loop;