APPS.QP_COPY_DEBUG_PVT dependencies on DUAL

Line 690: SELECT qp_debug_req_s.nextval FROM dual;

686: PROCEDURE Generate_Debug_Req_Seq(x_return_status out NOCOPY varchar2,
687: x_status_text out NOCOPY varchar2)
688: IS
689: CURSOR DEBUG_REQUEST_ID_CUR IS
690: SELECT qp_debug_req_s.nextval FROM dual;
691: l_request_id number;
692: BEGIN
693: -- dbms_output.put_line('*** Initializing Global Variables***');
694: G_DEBUG_TEXT_LINE_NO := 0;

Line 1103: -- SELECT qp_debug_req_s.nextval FROM dual;

1099: --added by yangli for Java Engine 3086881
1100: ORDER BY LINE_INDEX, PRICE_FORMULA_ID, STEP_NUMBER;
1101:
1102: -- CURSOR REQUEST_ID_CUR IS
1103: -- SELECT qp_debug_req_s.nextval FROM dual;
1104:
1105: CURSOR LINE_ID_CUR IS
1106: SELECT LINE_ID FROM qp_npreq_lines_tmp
1107: WHERE QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'N'

Line 1135: SELECT qp_line_attr_s.nextval FROM dual;

1131: WHERE QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'Y'
1132: AND ROWNUM = 1;
1133:
1134: CURSOR LINE_ATTR_ID_CUR is
1135: SELECT qp_line_attr_s.nextval FROM dual;
1136:
1137: CURSOR ORDER_NUMBER_CUR (p_line_id VARCHAR2) IS -- sfiresto 2374448
1138: SELECT ORDER_NUMBER FROM OE_ORDER_HEADERS_ALL
1139: WHERE header_id = p_line_id;

Line 1451: select QP_LINE_ATTR_S.nextval into l_LINE_ATTRIBUTE_ID from dual;

1447: FOR Tbl_Index in LINE_INDEX_T.FIRST .. LINE_INDEX_T.LAST LOOP
1448: -- dbms_output.put_line('***attrs - 3***');
1449: --REQUEST_ID_T(Tbl_Index):= l_request_id;
1450: REQUEST_ID_T(Tbl_Index):= G_DEBUG_REQUEST_ID;
1451: select QP_LINE_ATTR_S.nextval into l_LINE_ATTRIBUTE_ID from dual;
1452: LINE_ATTRIBUTE_ID_T(Tbl_Index) := l_LINE_ATTRIBUTE_ID;
1453: END LOOP;
1454: END IF;
1455: