APPS.QA_RESULTS_API dependencies on DUAL

Line 106: SELECT QA_COLLECTION_ID_S.NEXTVAL INTO x_collection_id FROM DUAL;

102: BEGIN
103: x_collection_id := p_collection_id;
104:
105: IF x_collection_id IS NULL THEN
106: SELECT QA_COLLECTION_ID_S.NEXTVAL INTO x_collection_id FROM DUAL;
107: p_collection_id := x_collection_id;
108: END IF;
109:
110: -- Ankur: Following logic makes sure that if OCCURRENCE is an IN parameter

Line 115: SELECT QA_OCCURRENCE_S.NEXTVAL INTO x_occurrence FROM DUAL;

111: -- then we put this value else we select next sequence value.
112: x_occurrence := p_occurrence;
113:
114: IF x_occurrence IS NULL THEN
115: SELECT QA_OCCURRENCE_S.NEXTVAL INTO x_occurrence FROM DUAL;
116: p_occurrence := x_occurrence;
117: END IF;
118:
119: -- Bug 2290747. In Parent-Child scanario History plan record is

Line 132: FROM DUAL;

128: SELECT sysdate,
129: MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
130: INTO x_sysdate,
131: x_txn_header_id
132: FROM DUAL;
133: ELSE
134: SELECT sysdate INTO x_sysdate FROM DUAL;
135: x_txn_header_id := p_txn_header_id;
136: END IF;

Line 134: SELECT sysdate INTO x_sysdate FROM DUAL;

130: INTO x_sysdate,
131: x_txn_header_id
132: FROM DUAL;
133: ELSE
134: SELECT sysdate INTO x_sysdate FROM DUAL;
135: x_txn_header_id := p_txn_header_id;
136: END IF;
137:
138: -- 12.1 QWB Usability Improvements

Line 527: FROM DUAL;

523:
524: IF p_txn_header_id IS NULL THEN
525: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
526: INTO x_txn_header_id
527: FROM DUAL;
528: ELSE
529: x_txn_header_id := p_txn_header_id;
530: END IF;
531:

Line 660: SELECT QA_RESULTS_UPDATE_HISTORY_S.NEXTVAL INTO x_update_id FROM DUAL;

656: ELSE
657: value_string := value_string || ', ' || column_name || ' = ' || ':X' || to_char(k) || ' ';
658: END IF;
659:
660: SELECT QA_RESULTS_UPDATE_HISTORY_S.NEXTVAL INTO x_update_id FROM DUAL;
661:
662: -- Bug 3776542. Performance issue due to the use of literals in the SQL below.
663: -- Modified the string to include bind variables.
664: -- srhariha. Thu Jul 29 00:27:59 PDT 2004.