DBA Data[Home] [Help]

APPS.PON_PRINTING_PKG dependencies on DUAL

Line 3242: SELECT CURRENT_DATE INTO l_start_time FROM DUAL;

3238: and nvl(buyer_fax.date_to(+), trunc(sysdate)) >= trunc(sysdate);
3239:
3240: dbms_lob.createtemporary(result, TRUE);
3241:
3242: SELECT CURRENT_DATE INTO l_start_time FROM DUAL;
3243:
3244: xml_stmt := 'DECLARE
3245: queryCtx DBMS_XMLGEN.ctxHandle;
3246: BEGIN

Line 3256: SELECT CURRENT_DATE INTO l_end_time FROM DUAL;

3252: RAISE;
3253: END;';
3254: execute immediate xml_stmt USING IN OUT xml_query_cursor, IN OUT result;
3255:
3256: SELECT CURRENT_DATE INTO l_end_time FROM DUAL;
3257:
3258: CLOSE xml_query_cursor;
3259:
3260: IF l_statement_log_level >= l_current_log_level THEN