DBA Data[Home] [Help]

APPS.MTL_CC_TRANSACT_PKG dependencies on DUAL

Line 215: FROM dual;

211: --inv_Debug.message('ssia', 'Sub is ' ||sub);
212: IF (TxnTempId IS NULL) THEN
213: SELECT mtl_material_transactions_s.NEXTVAL
214: INTO l_transaction_temp_id
215: FROM dual;
216: ELSE
217: l_transaction_temp_id := TxnTempId;
218: END IF;
219:

Line 426: FROM DUAL;

422: -- generate a serial transaction temp ID
423: IF (SerialNum IS NOT NULL) THEN
424: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
425: INTO l_serial_temp_id
426: FROM DUAL;
427: ELSE
428: l_serial_temp_id := NULL;
429: END IF;
430: