APPS.EAM_MTL_TXN_PROCESS dependencies on DUAL

Line 106: select 1 into x_future_date from dual where p_date <= sysdate ;

102:
103: /* Checking the Transaction date */
104: if(p_dateNotInFuture = 1) then
105: begin
106: select 1 into x_future_date from dual where p_date <= sysdate ;
107: exception
108: when no_data_found then
109: x_error_flag := 1;
110: x_error_mssg := 'EAM_FUTURE_DATE';

Line 301: from dual;

297: /* Initializing the Global variables for MTI Transaction API */
298: if(p_txn_header_id is null) then
299: select
300: mtl_material_transactions_s.nextval into x_header_id
301: from dual;
302: x_trx_temp_id := x_header_id;
303: else
304: x_header_id := p_txn_header_id;
305: end if;

Line 313: from dual;

309: INV_TRANSACTIONS.G_Interface_ID := x_header_id;
310:
311: if(p_serial_ctrl_code <> 1) then
312: select mtl_material_transactions_s.nextval into INV_TRANSACTIONS.G_Serial_ID
313: from dual;
314: end if;
315:
316: if (l_slog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
317: 'Inserting into MTI with Tx Header ID=' || x_header_id);