APPS.QP_PREQ_GRP dependencies on DUAL

Line 8240: FROM dual;

8236:
8237: IF (p_line_tbl(I).LINE_ID IS NULL) THEN
8238: SELECT qp_limit_price_request_code_s.nextval
8239: INTO l_order_line_id
8240: FROM dual;
8241: ELSE
8242: l_order_line_id := p_line_tbl(I).LINE_ID;
8243: END IF;
8244:

Line 13448: FROM DUAL

13444: CURSOR get_excluded_prods_between(p_line_index PLS_INTEGER,
13445: p_list_header_id PLS_INTEGER,
13446: p_list_line_id PLS_INTEGER) IS
13447: SELECT 1
13448: FROM DUAL
13449: WHERE EXISTS
13450: (SELECT 'x'
13451: FROM QP_PREQ_LINE_ATTRS_TMP
13452: WHERE LINE_INDEX = p_line_index

Line 32211: FROM dual

32207: INDX,QP_PREQ_GRP.price_request.get_source_system_cur,QP_PRICE_REQ_SOURCES_PK,REQUEST_TYPE_CODE,1
32208: */
32209: CURSOR get_source_system_cur IS
32210: SELECT 'X'
32211: FROM dual
32212: WHERE EXISTS
32213: (Select 'X'
32214: --From QP_PRICE_REQ_SOURCES
32215: From QP_PRICE_REQ_SOURCES_V /* yangli */

Line 32257: FROM dual

32253: -- lines/headers; assuming that phase/qual on lines is a better EXISTS filter than
32254: -- active flag on headers (can purge if many inactive modifiers)
32255: CURSOR l_chk_phase_exists(p_phase_id IN PLS_INTEGER) IS
32256: SELECT 'x'
32257: FROM dual
32258: WHERE
32259: EXISTS (
32260: select /*+ ORDERED */ 'x'
32261: from qp_list_header_phases lhp, qp_list_headers_b qplh

Line 32285: select 'X' from dual

32281: and qpll.list_header_id = qplh.list_header_id
32282: and qpll.pricing_phase_id = p_phase_id
32283: and qpll.qualification_ind in (0, 2, 4, 6, 8, 10, 12, 14, 20, 22, 28, 30)
32284: and rownum = 1;
32285: select 'X' from dual
32286: where exists (select 'X' from qp_list_lines
32287: where pricing_phase_id = p_phase_id
32288: AND modifier_level_code IN ('LINE','LINEGROUP','ORDER') --3169430
32289: and rownum = 1);*/

Line 33960: execute immediate 'select ' || '''' || 'QP_PREQ_GRP: version, start redo, total redo, start time, total time: ' || G_VERSION || ', ' || g_start_redo || ', ' || g_total_redo || ', ' || g_start_time || ', ' || g_total_time || '''' || ' from dual ';

33956: g_total_redo := g_total_redo + (l_pricing_end_redo - l_pricing_start_redo);
33957:
33958: --Changes for bug2961617
33959: /*
33960: execute immediate 'select ' || '''' || 'QP_PREQ_GRP: version, start redo, total redo, start time, total time: ' || G_VERSION || ', ' || g_start_redo || ', ' || g_total_redo || ', ' || g_start_time || ', ' || g_total_time || '''' || ' from dual ';
33961: */
33962:
33963: IF G_QP_DEBUG_PROFILE_VALUE = G_ENGINE_TIME_TRACE_ON THEN --3085171
33964: BEGIN

Line 33966: execute immediate 'select ' || '''' || 'QP_PREQ_GRP: version, start redo, total redo, start time, total time: ' || G_VERSION || ', ' || g_start_redo || ', ' || g_total_redo || ', ' || g_start_time || ', ' || g_total_time || '''' || ' from dual ';

33962:
33963: IF G_QP_DEBUG_PROFILE_VALUE = G_ENGINE_TIME_TRACE_ON THEN --3085171
33964: BEGIN
33965:
33966: execute immediate 'select ' || '''' || 'QP_PREQ_GRP: version, start redo, total redo, start time, total time: ' || G_VERSION || ', ' || g_start_redo || ', ' || g_total_redo || ', ' || g_start_time || ', ' || g_total_time || '''' || ' from dual ';
33967: /*
33968: SELECT 'QP_PREQ_GRP: version, start redo, total redo, start time, total time: '||G_VERSION ||g_start_redo ||g_total_redo ||g_start_time ||g_total_time INTO l_time_stats FROM DUAL;
33969: */
33970:

Line 33968: SELECT 'QP_PREQ_GRP: version, start redo, total redo, start time, total time: '||G_VERSION ||g_start_redo ||g_total_redo ||g_start_time ||g_total_time INTO l_time_stats FROM DUAL;

33964: BEGIN
33965:
33966: execute immediate 'select ' || '''' || 'QP_PREQ_GRP: version, start redo, total redo, start time, total time: ' || G_VERSION || ', ' || g_start_redo || ', ' || g_total_redo || ', ' || g_start_time || ', ' || g_total_time || '''' || ' from dual ';
33967: /*
33968: SELECT 'QP_PREQ_GRP: version, start redo, total redo, start time, total time: '||G_VERSION ||g_start_redo ||g_total_redo ||g_start_time ||g_total_time INTO l_time_stats FROM DUAL;
33969: */
33970:
33971: EXCEPTION
33972:

Line 33983: execute immediate 'select '||''''|| ' Total Time in QP_PREQ_GRP(in sec) : ' || l_time_difference||' Total redo in QP_PREQ_GRP : '||l_redo_difference||''''||' from dual ';

33979:
33980: /*
33981: l_redo_difference := l_pricing_end_redo - l_pricing_start_redo ;
33982:
33983: execute immediate 'select '||''''|| ' Total Time in QP_PREQ_GRP(in sec) : ' || l_time_difference||' Total redo in QP_PREQ_GRP : '||l_redo_difference||''''||' from dual ';
33984: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
33985: engine_debug('redo log in GRP '||l_redo_difference);
33986: END IF;
33987: */