APPS.WSM_SERIAL_SUPPORT_GRP dependencies on DUAL

Line 336: from dual;

332: -- get a txn header id..
333: -- No will be passed...
334: /*SELECT mtl_material_transactions_s.nextval
335: into p_mtl_txn_hdr_id
336: from dual;
337: */
338:
339: /* Have to be passed....
340: if p_move_txn_type = wip_constants.RET_TXN then

Line 343: from dual;

339: /* Have to be passed....
340: if p_move_txn_type = wip_constants.RET_TXN then
341: SELECT mtl_material_transactions_s.nextval
342: into p_compl_txn_id
343: from dual;
344: end if;
345: */
346:
347: -- could be a move and scrap transaction too...

Line 394: from dual;

390:
391: l_stmt_num := 60;
392: select mtl_material_transactions_s.nextval
393: into l_temp_id
394: from dual;
395:
396: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
397: l_msg_tokens.delete;
398: WSM_log_PVT.logMessage (p_module_name => l_module ,

Line 567: from dual;

563: if l_lot_txn_rec.serial_transaction_id is not null then
564: l_stmt_num := 100;
565: select mtl_material_transactions_s.nextval
566: into l_serial_txn_id
567: from dual;
568: else
569: l_stmt_num := 110;
570: l_serial_txn_id := null;
571: end if;