DBA Data[Home] [Help]

APPS.QP_COPY_DEBUG_PVT dependencies on QP_LINE_ATTR_S

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: