DBA Data[Home] [Help]

APPS.QLTTRAWB dependencies on QA_COLLECTION_ID_S

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)