APPS.QLTTRAMB dependencies on QA_RESULTS_INTERFACE

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

117: -- Check if the parameter 'Gather Statistics' is Yes or not.
118: -- for bug 2141009. kabalakr 4 feb 2002.
119:
120: IF (upper(ARGUMENT4) = 'YES') THEN
121: fnd_stats.gather_table_stats('QA','QA_RESULTS_INTERFACE');
122: END IF;
123:
124: TYPE_OF_TXN := TO_NUMBER(ARGUMENT2);
125:

Line 145: FROM QA_RESULTS_INTERFACE

141: -- count the number of rows where validate flag is true or, more
142: -- specifically, where validate flag is not false
143:
144: FOR REC IN (SELECT ROWID, PLAN_NAME, SOURCE_CODE
145: FROM QA_RESULTS_INTERFACE
146: WHERE PROCESS_STATUS = 1
147: AND GROUP_ID IS NULL
148: AND ((VALIDATE_FLAG <> 2) OR (VALIDATE_FLAG IS NULL))
149: AND NVL(INSERT_TYPE,1) = TYPE_OF_TXN

Line 171: FROM QA_RESULTS_INTERFACE

167:
168: -- count the number of rows where validate flag is false
169:
170: FOR REC IN (SELECT ROWID, PLAN_NAME
171: FROM QA_RESULTS_INTERFACE
172: WHERE PROCESS_STATUS = 1
173: AND GROUP_ID IS NULL
174: AND VALIDATE_FLAG = 2
175: AND NVL(INSERT_TYPE,1) = TYPE_OF_TXN

Line 224: UPDATE QA_RESULTS_INTERFACE

220: END IF;
221:
222: -- assign the current group id to the current row
223:
224: UPDATE QA_RESULTS_INTERFACE
225: SET GROUP_ID = X_GROUP_ID,
226: REQUEST_ID = X_REQUEST_ID,
227: CREATION_DATE = NVL(CREATION_DATE, who_creation_date),
228: CREATED_BY = NVL(CREATED_BY, who_created_by),

Line 240: UPDATE QA_RESULTS_INTERFACE

236:
237: -- if transaction interface id for the current row is left blank,
238: -- assign it a unique value
239:
240: UPDATE QA_RESULTS_INTERFACE
241: SET TRANSACTION_INTERFACE_ID = QA_TXN_INTERFACE_S.NEXTVAL
242: WHERE ROWID = ROWID_TABLE(I)
243: AND TRANSACTION_INTERFACE_ID IS NULL;
244: