APPS.EAM_MTL_TXN_PROCESS dependencies on DUAL

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

184:
185: /* Checking the Transaction date */
186: if(p_dateNotInFuture = 1) then
187: begin
188: select 1 into x_future_date from dual where p_date <= sysdate ;
189: exception
190: when no_data_found then
191: x_error_flag := 1;
192: x_error_mssg := 'EAM_FUTURE_DATE';

Line 399: from dual;

395: /* Initializing the Global variables for MTI Transaction API */
396: if(p_txn_header_id is null) then
397: select
398: mtl_material_transactions_s.nextval into x_header_id
399: from dual;
400: x_trx_temp_id := x_header_id;
401: else
402: x_header_id := p_txn_header_id;
403: end if;

Line 411: from dual;

407: INV_TRANSACTIONS.G_Interface_ID := x_header_id;
408:
409: if(p_serial_ctrl_code <> 1) then
410: select mtl_material_transactions_s.nextval into INV_TRANSACTIONS.G_Serial_ID
411: from dual;
412: end if;
413:
414: if (l_slog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
415: 'Inserting into MTI with Tx Header ID=' || x_header_id);