APPS.QLTTRAMB dependencies on QA_RESULTS_INTERFACE

Line 128: fnd_stats.gather_table_stats('QA','QA_RESULTS_INTERFACE');

124: -- Check if the parameter 'Gather Statistics' is Yes or not.
125: -- for bug 2141009. kabalakr 4 feb 2002.
126:
127: IF (upper(ARGUMENT4) = 'YES') THEN
128: fnd_stats.gather_table_stats('QA','QA_RESULTS_INTERFACE');
129: END IF;
130:
131: TYPE_OF_TXN := TO_NUMBER(ARGUMENT2);
132:

Line 154: FROM QA_RESULTS_INTERFACE

150: -- count the number of rows where validate flag is true or, more
151: -- specifically, where validate flag is not false
152:
153: FOR REC IN (SELECT ROWID, PLAN_NAME, SOURCE_CODE
154: FROM QA_RESULTS_INTERFACE
155: WHERE PROCESS_STATUS = 1
156: AND GROUP_ID IS NULL
157: AND ((VALIDATE_FLAG <> 2) OR (VALIDATE_FLAG IS NULL))
158: AND NVL(INSERT_TYPE,1) = TYPE_OF_TXN

Line 180: FROM QA_RESULTS_INTERFACE

176:
177: -- count the number of rows where validate flag is false
178:
179: FOR REC IN (SELECT ROWID, PLAN_NAME
180: FROM QA_RESULTS_INTERFACE
181: WHERE PROCESS_STATUS = 1
182: AND GROUP_ID IS NULL
183: AND VALIDATE_FLAG = 2
184: AND NVL(INSERT_TYPE,1) = TYPE_OF_TXN

Line 233: UPDATE QA_RESULTS_INTERFACE

229: END IF;
230:
231: -- assign the current group id to the current row
232:
233: UPDATE QA_RESULTS_INTERFACE
234: SET GROUP_ID = X_GROUP_ID,
235: REQUEST_ID = X_REQUEST_ID,
236: CREATION_DATE = NVL(CREATION_DATE, who_creation_date),
237: CREATED_BY = NVL(CREATED_BY, who_created_by),

Line 249: UPDATE QA_RESULTS_INTERFACE

245:
246: -- if transaction interface id for the current row is left blank,
247: -- assign it a unique value
248:
249: UPDATE QA_RESULTS_INTERFACE
250: SET TRANSACTION_INTERFACE_ID = QA_TXN_INTERFACE_S.NEXTVAL
251: WHERE ROWID = ROWID_TABLE(I)
252: AND TRANSACTION_INTERFACE_ID IS NULL;
253: