APPS.QLTTRAWB dependencies on DUAL

Line 3172: 'AND NOT EXISTS (SELECT ''x'' FROM DUAL WHERE QRI.' ||

3168: 'WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
3169: 'QRI.TRANSACTION_INTERFACE_ID ' ||
3170: 'AND QIE.ERROR_COLUMN IN (:c1,:c2,:c3,:c4,:c5)) ' ||
3171: 'AND QRI.' || COL_NAME || ' IS NOT NULL ' ||
3172: 'AND NOT EXISTS (SELECT ''x'' FROM DUAL WHERE QRI.' ||
3173: COL_NAME || ' IN ' || '(' || FORMATTED_SQL_STRING || ') )';
3174:
3175: BEGIN
3176:

Line 8134: THEN SELECT QA_COLLECTION_ID_S.NEXTVAL INTO X_COLLECTION_ID FROM DUAL;

8130: -- if they are null for inserts
8131: -- update qa_created_by and qa_last_updated_by if they are null for updates
8132:
8133: IF TYPE_OF_TXN <> 2
8134: THEN SELECT QA_COLLECTION_ID_S.NEXTVAL INTO X_COLLECTION_ID FROM DUAL;
8135: UPDATE QA_RESULTS_INTERFACE
8136: SET COLLECTION_ID = NVL(COLLECTION_ID, X_COLLECTION_ID),
8137: QA_CREATED_BY = NVL(QA_CREATED_BY, X_USER_ID),
8138: QA_LAST_UPDATED_BY = NVL(QA_LAST_UPDATED_BY, X_USER_ID)

Line 8163: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL INTO X_TXN_HEADER_ID FROM DUAL;

8159: CLOSE C;
8160:
8161: -- we need to select a txn_header_id, in case actions were fired
8162:
8163: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL INTO X_TXN_HEADER_ID FROM DUAL;
8164:
8165: -- insert the valid records into the results table
8166: -- modified for update capabilities; 1 = 'INSERT' and 2 = 'UPDATE'
8167: -- also everything else will be interpreted as 'INSERT'

Line 8314: SELECT QA_GROUP_S.NEXTVAL INTO NEW_GROUP_ID FROM DUAL;

8310: -- Loop through the group of update records
8311: RESULT := TRUE;
8312: FOR rec IN c1 LOOP
8313: -- Get a new group ID to be used for the update records.
8314: SELECT QA_GROUP_S.NEXTVAL INTO NEW_GROUP_ID FROM DUAL;
8315:
8316: UPDATE QA_RESULTS_INTERFACE
8317: SET GROUP_ID = NEW_GROUP_ID
8318: WHERE rowid = rec.rowid;