APPS.QLTTRAWB dependencies on DUAL

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

3298: 'WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
3299: 'QRI.TRANSACTION_INTERFACE_ID ' ||
3300: 'AND QIE.ERROR_COLUMN IN (:c1,:c2,:c3,:c4,:c5)) ' ||
3301: 'AND QRI.' || COL_NAME || ' IS NOT NULL ' ||
3302: 'AND NOT EXISTS (SELECT ''x'' FROM DUAL WHERE QRI.' ||
3303: COL_NAME || ' IN ' || '(' || FORMATTED_SQL_STRING || ') )'||
3304: ' AND to_char(QRI.' || COL_NAME || ') NOT IN (to_char(:null_num), :null_char, to_char(:null_date, ''DD-MON-YYYY HH24:MI:SS''))';
3305:
3306: BEGIN

Line 8697: SELECT QA_COLLECTION_ID_S.NEXTVAL INTO X_COLLECTION_ID FROM DUAL;

8693: IF TYPE_OF_TXN <> 2
8694: THEN
8695: QLTTRAMB.qa_import_log('type of transaction = insert, setting who columns');
8696:
8697: SELECT QA_COLLECTION_ID_S.NEXTVAL INTO X_COLLECTION_ID FROM DUAL;
8698:
8699: UPDATE QA_RESULTS_INTERFACE
8700: SET COLLECTION_ID = NVL(COLLECTION_ID, X_COLLECTION_ID),
8701: QA_CREATED_BY = NVL(QA_CREATED_BY, X_USER_ID),

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

8728: QLTTRAMB.qa_import_log('validation completed, inserting data now');
8729:
8730: -- we need to select a txn_header_id, in case actions were fired
8731:
8732: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL INTO X_TXN_HEADER_ID FROM DUAL;
8733:
8734: QLTTRAMB.qa_import_log('X_TXN_HEADER_ID :'||X_TXN_HEADER_ID ||' TYPE_OF_TXN :'||TYPE_OF_TXN);
8735:
8736: -- insert the valid records into the results table

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

8971: -- Loop through the group of update records
8972: RESULT := TRUE;
8973: FOR rec IN c1 LOOP
8974: -- Get a new group ID to be used for the update records.
8975: SELECT QA_GROUP_S.NEXTVAL INTO NEW_GROUP_ID FROM DUAL;
8976:
8977: UPDATE QA_RESULTS_INTERFACE
8978: SET GROUP_ID = NEW_GROUP_ID
8979: WHERE rowid = rec.rowid;