DBA Data[Home] [Help]

APPS.INV_TXN_VALIDATIONS dependencies on DUAL

Line 14: --select to_char(sysdate,'MM/DD/YYYY HH:MM:SS') INTO l_ts from dual; -- Bug 13878269

10: l_msg VARCHAR2(5100);
11: l_ts VARCHAR2(30);
12: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
13: BEGIN
14: --select to_char(sysdate,'MM/DD/YYYY HH:MM:SS') INTO l_ts from dual; -- Bug 13878269
15: --l_msg := l_ts||' '||msg;
16: l_msg := msg;
17:
18: IF (l_debug = 1) THEN

Line 4212: FROM dual;

4208:
4209: IF p_transaction_header_id IS NULL THEN
4210: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
4211: INTO x_transaction_header_id
4212: FROM dual;
4213: ELSE
4214: x_transaction_header_id := p_transaction_header_id;
4215: END IF;
4216: