APPS.QLTTRAWB dependencies on QA_CORE_PKG

Line 236: qa_core_pkg.dsql_add_text('(');

232: OP VARCHAR2(30);
233:
234:
235: BEGIN
236: qa_core_pkg.dsql_add_text('(');
237: qa_core_pkg.dsql_add_text(' SELECT 1 ' ||
238: ' FROM QA_SPEC_CHARS_V QSC, QA_CHARS QC ' ||
239: ' WHERE QSC.CHAR_ID (+) = QC.CHAR_ID ' ||
240: ' AND QC.CHAR_ID = ');

Line 237: qa_core_pkg.dsql_add_text(' SELECT 1 ' ||

233:
234:
235: BEGIN
236: qa_core_pkg.dsql_add_text('(');
237: qa_core_pkg.dsql_add_text(' SELECT 1 ' ||
238: ' FROM QA_SPEC_CHARS_V QSC, QA_CHARS QC ' ||
239: ' WHERE QSC.CHAR_ID (+) = QC.CHAR_ID ' ||
240: ' AND QC.CHAR_ID = ');
241:

Line 242: qa_core_pkg.dsql_add_bind(X_CHAR_ID);

238: ' FROM QA_SPEC_CHARS_V QSC, QA_CHARS QC ' ||
239: ' WHERE QSC.CHAR_ID (+) = QC.CHAR_ID ' ||
240: ' AND QC.CHAR_ID = ');
241:
242: qa_core_pkg.dsql_add_bind(X_CHAR_ID);
243:
244: qa_core_pkg.dsql_add_text(' AND QSC.SPEC_ID (+) = NVL(QRI.SPEC_ID, -1) ' ||
245: ' AND QSC.SPEC_CHAR_ENABLED (+) = 1 ' ||
246: ' AND ');

Line 244: qa_core_pkg.dsql_add_text(' AND QSC.SPEC_ID (+) = NVL(QRI.SPEC_ID, -1) ' ||

240: ' AND QC.CHAR_ID = ');
241:
242: qa_core_pkg.dsql_add_bind(X_CHAR_ID);
243:
244: qa_core_pkg.dsql_add_text(' AND QSC.SPEC_ID (+) = NVL(QRI.SPEC_ID, -1) ' ||
245: ' AND QSC.SPEC_CHAR_ENABLED (+) = 1 ' ||
246: ' AND ');
247:
248:

Line 250: qa_core_pkg.dsql_add_text(' qltdate.any_to_number(QRI.' || COL_NAME || ') ');

246: ' AND ');
247:
248:
249: IF x_datatype = 2 THEN
250: qa_core_pkg.dsql_add_text(' qltdate.any_to_number(QRI.' || COL_NAME || ') ');
251:
252: ELSIF x_datatype = 3 THEN
253: qa_core_pkg.dsql_add_text(' qltdate.any_to_date(QRI.' || COL_NAME || ') ');
254:

Line 253: qa_core_pkg.dsql_add_text(' qltdate.any_to_date(QRI.' || COL_NAME || ') ');

249: IF x_datatype = 2 THEN
250: qa_core_pkg.dsql_add_text(' qltdate.any_to_number(QRI.' || COL_NAME || ') ');
251:
252: ELSIF x_datatype = 3 THEN
253: qa_core_pkg.dsql_add_text(' qltdate.any_to_date(QRI.' || COL_NAME || ') ');
254:
255: ELSIF x_datatype = 6 THEN
256: qa_core_pkg.dsql_add_text(' qltdate.any_to_datetime(QRI.' || COL_NAME || ') ');
257:

Line 256: qa_core_pkg.dsql_add_text(' qltdate.any_to_datetime(QRI.' || COL_NAME || ') ');

252: ELSIF x_datatype = 3 THEN
253: qa_core_pkg.dsql_add_text(' qltdate.any_to_date(QRI.' || COL_NAME || ') ');
254:
255: ELSIF x_datatype = 6 THEN
256: qa_core_pkg.dsql_add_text(' qltdate.any_to_datetime(QRI.' || COL_NAME || ') ');
257:
258: ELSE
259: qa_core_pkg.dsql_add_text(' QRI.' || COL_NAME || ' ');
260: END IF;

Line 259: qa_core_pkg.dsql_add_text(' QRI.' || COL_NAME || ' ');

255: ELSIF x_datatype = 6 THEN
256: qa_core_pkg.dsql_add_text(' qltdate.any_to_datetime(QRI.' || COL_NAME || ') ');
257:
258: ELSE
259: qa_core_pkg.dsql_add_text(' QRI.' || COL_NAME || ' ');
260: END IF;
261:
262:
263: OP := QLTTRAFB.DECODE_OPERATOR(X_OP_CODE);

Line 285: qa_core_pkg.dsql_add_text(' ' || OP || ' DECODE(QSC.CHAR_ID, NULL, ' ||

281: LV2 := 'qltdate.canon_to_date(' || LV2 || ')';
282:
283: END IF;
284:
285: qa_core_pkg.dsql_add_text(' ' || OP || ' DECODE(QSC.CHAR_ID, NULL, ' ||
286: LV1 || ', ' || LV2 || ')');
287:
288:
289: ELSE -- binds required

Line 291: qa_core_pkg.dsql_add_text(' ' || OP || ' DECODE(QSC.CHAR_ID, NULL, ');

287:
288:
289: ELSE -- binds required
290:
291: qa_core_pkg.dsql_add_text(' ' || OP || ' DECODE(QSC.CHAR_ID, NULL, ');
292:
293: IF (X_DATATYPE = 2) THEN
294: qa_core_pkg.dsql_add_bind(qltdate.canon_to_number(X_LV_OTHER_VALUE));
295: qa_core_pkg.dsql_add_text(' ,');

Line 294: qa_core_pkg.dsql_add_bind(qltdate.canon_to_number(X_LV_OTHER_VALUE));

290:
291: qa_core_pkg.dsql_add_text(' ' || OP || ' DECODE(QSC.CHAR_ID, NULL, ');
292:
293: IF (X_DATATYPE = 2) THEN
294: qa_core_pkg.dsql_add_bind(qltdate.canon_to_number(X_LV_OTHER_VALUE));
295: qa_core_pkg.dsql_add_text(' ,');
296: qa_core_pkg.dsql_add_bind(qltdate.canon_to_number(X_LV_OTHER_VALUE));
297: qa_core_pkg.dsql_add_text(' )');
298:

Line 295: qa_core_pkg.dsql_add_text(' ,');

291: qa_core_pkg.dsql_add_text(' ' || OP || ' DECODE(QSC.CHAR_ID, NULL, ');
292:
293: IF (X_DATATYPE = 2) THEN
294: qa_core_pkg.dsql_add_bind(qltdate.canon_to_number(X_LV_OTHER_VALUE));
295: qa_core_pkg.dsql_add_text(' ,');
296: qa_core_pkg.dsql_add_bind(qltdate.canon_to_number(X_LV_OTHER_VALUE));
297: qa_core_pkg.dsql_add_text(' )');
298:
299: ELSIF (X_DATATYPE IN (3, 6)) THEN

Line 296: qa_core_pkg.dsql_add_bind(qltdate.canon_to_number(X_LV_OTHER_VALUE));

292:
293: IF (X_DATATYPE = 2) THEN
294: qa_core_pkg.dsql_add_bind(qltdate.canon_to_number(X_LV_OTHER_VALUE));
295: qa_core_pkg.dsql_add_text(' ,');
296: qa_core_pkg.dsql_add_bind(qltdate.canon_to_number(X_LV_OTHER_VALUE));
297: qa_core_pkg.dsql_add_text(' )');
298:
299: ELSIF (X_DATATYPE IN (3, 6)) THEN
300: qa_core_pkg.dsql_add_bind(qltdate.canon_to_date(X_LV_OTHER_VALUE));

Line 297: qa_core_pkg.dsql_add_text(' )');

293: IF (X_DATATYPE = 2) THEN
294: qa_core_pkg.dsql_add_bind(qltdate.canon_to_number(X_LV_OTHER_VALUE));
295: qa_core_pkg.dsql_add_text(' ,');
296: qa_core_pkg.dsql_add_bind(qltdate.canon_to_number(X_LV_OTHER_VALUE));
297: qa_core_pkg.dsql_add_text(' )');
298:
299: ELSIF (X_DATATYPE IN (3, 6)) THEN
300: qa_core_pkg.dsql_add_bind(qltdate.canon_to_date(X_LV_OTHER_VALUE));
301: qa_core_pkg.dsql_add_text(' ,');

Line 300: qa_core_pkg.dsql_add_bind(qltdate.canon_to_date(X_LV_OTHER_VALUE));

296: qa_core_pkg.dsql_add_bind(qltdate.canon_to_number(X_LV_OTHER_VALUE));
297: qa_core_pkg.dsql_add_text(' )');
298:
299: ELSIF (X_DATATYPE IN (3, 6)) THEN
300: qa_core_pkg.dsql_add_bind(qltdate.canon_to_date(X_LV_OTHER_VALUE));
301: qa_core_pkg.dsql_add_text(' ,');
302: qa_core_pkg.dsql_add_bind(qltdate.canon_to_date(X_LV_OTHER_VALUE));
303: qa_core_pkg.dsql_add_text(' )');
304:

Line 301: qa_core_pkg.dsql_add_text(' ,');

297: qa_core_pkg.dsql_add_text(' )');
298:
299: ELSIF (X_DATATYPE IN (3, 6)) THEN
300: qa_core_pkg.dsql_add_bind(qltdate.canon_to_date(X_LV_OTHER_VALUE));
301: qa_core_pkg.dsql_add_text(' ,');
302: qa_core_pkg.dsql_add_bind(qltdate.canon_to_date(X_LV_OTHER_VALUE));
303: qa_core_pkg.dsql_add_text(' )');
304:
305: ELSE

Line 302: qa_core_pkg.dsql_add_bind(qltdate.canon_to_date(X_LV_OTHER_VALUE));

298:
299: ELSIF (X_DATATYPE IN (3, 6)) THEN
300: qa_core_pkg.dsql_add_bind(qltdate.canon_to_date(X_LV_OTHER_VALUE));
301: qa_core_pkg.dsql_add_text(' ,');
302: qa_core_pkg.dsql_add_bind(qltdate.canon_to_date(X_LV_OTHER_VALUE));
303: qa_core_pkg.dsql_add_text(' )');
304:
305: ELSE
306: qa_core_pkg.dsql_add_bind(X_LV_OTHER_VALUE);

Line 303: qa_core_pkg.dsql_add_text(' )');

299: ELSIF (X_DATATYPE IN (3, 6)) THEN
300: qa_core_pkg.dsql_add_bind(qltdate.canon_to_date(X_LV_OTHER_VALUE));
301: qa_core_pkg.dsql_add_text(' ,');
302: qa_core_pkg.dsql_add_bind(qltdate.canon_to_date(X_LV_OTHER_VALUE));
303: qa_core_pkg.dsql_add_text(' )');
304:
305: ELSE
306: qa_core_pkg.dsql_add_bind(X_LV_OTHER_VALUE);
307: qa_core_pkg.dsql_add_text(' ,');

Line 306: qa_core_pkg.dsql_add_bind(X_LV_OTHER_VALUE);

302: qa_core_pkg.dsql_add_bind(qltdate.canon_to_date(X_LV_OTHER_VALUE));
303: qa_core_pkg.dsql_add_text(' )');
304:
305: ELSE
306: qa_core_pkg.dsql_add_bind(X_LV_OTHER_VALUE);
307: qa_core_pkg.dsql_add_text(' ,');
308: qa_core_pkg.dsql_add_bind(X_LV_OTHER_VALUE);
309: qa_core_pkg.dsql_add_text(' )');
310:

Line 307: qa_core_pkg.dsql_add_text(' ,');

303: qa_core_pkg.dsql_add_text(' )');
304:
305: ELSE
306: qa_core_pkg.dsql_add_bind(X_LV_OTHER_VALUE);
307: qa_core_pkg.dsql_add_text(' ,');
308: qa_core_pkg.dsql_add_bind(X_LV_OTHER_VALUE);
309: qa_core_pkg.dsql_add_text(' )');
310:
311: END IF;

Line 308: qa_core_pkg.dsql_add_bind(X_LV_OTHER_VALUE);

304:
305: ELSE
306: qa_core_pkg.dsql_add_bind(X_LV_OTHER_VALUE);
307: qa_core_pkg.dsql_add_text(' ,');
308: qa_core_pkg.dsql_add_bind(X_LV_OTHER_VALUE);
309: qa_core_pkg.dsql_add_text(' )');
310:
311: END IF;
312:

Line 309: qa_core_pkg.dsql_add_text(' )');

305: ELSE
306: qa_core_pkg.dsql_add_bind(X_LV_OTHER_VALUE);
307: qa_core_pkg.dsql_add_text(' ,');
308: qa_core_pkg.dsql_add_bind(X_LV_OTHER_VALUE);
309: qa_core_pkg.dsql_add_text(' )');
310:
311: END IF;
312:
313: END IF; -- x_lv_lookup_value is null

Line 335: qa_core_pkg.dsql_add_text(' AND ' || ' DECODE(QSC.CHAR_ID, NULL, ' ||

331: HV2 := 'qltdate.canon_to_date(' || HV2 || ')';
332:
333: END IF;
334:
335: qa_core_pkg.dsql_add_text(' AND ' || ' DECODE(QSC.CHAR_ID, NULL, ' ||
336: HV1 || ', ' || HV2 || ')');
337:
338:
339: ELSE -- binds required

Line 341: qa_core_pkg.dsql_add_text(' AND ' || ' DECODE(QSC.CHAR_ID, NULL, ');

337:
338:
339: ELSE -- binds required
340:
341: qa_core_pkg.dsql_add_text(' AND ' || ' DECODE(QSC.CHAR_ID, NULL, ');
342:
343: IF (X_DATATYPE = 2) THEN
344: qa_core_pkg.dsql_add_bind(qltdate.canon_to_number(X_HV_OTHER_VALUE));
345: qa_core_pkg.dsql_add_text(' ,');

Line 344: qa_core_pkg.dsql_add_bind(qltdate.canon_to_number(X_HV_OTHER_VALUE));

340:
341: qa_core_pkg.dsql_add_text(' AND ' || ' DECODE(QSC.CHAR_ID, NULL, ');
342:
343: IF (X_DATATYPE = 2) THEN
344: qa_core_pkg.dsql_add_bind(qltdate.canon_to_number(X_HV_OTHER_VALUE));
345: qa_core_pkg.dsql_add_text(' ,');
346: qa_core_pkg.dsql_add_bind(qltdate.canon_to_number(X_HV_OTHER_VALUE));
347: qa_core_pkg.dsql_add_text(' )');
348:

Line 345: qa_core_pkg.dsql_add_text(' ,');

341: qa_core_pkg.dsql_add_text(' AND ' || ' DECODE(QSC.CHAR_ID, NULL, ');
342:
343: IF (X_DATATYPE = 2) THEN
344: qa_core_pkg.dsql_add_bind(qltdate.canon_to_number(X_HV_OTHER_VALUE));
345: qa_core_pkg.dsql_add_text(' ,');
346: qa_core_pkg.dsql_add_bind(qltdate.canon_to_number(X_HV_OTHER_VALUE));
347: qa_core_pkg.dsql_add_text(' )');
348:
349: ELSIF (X_DATATYPE IN (3, 6)) THEN

Line 346: qa_core_pkg.dsql_add_bind(qltdate.canon_to_number(X_HV_OTHER_VALUE));

342:
343: IF (X_DATATYPE = 2) THEN
344: qa_core_pkg.dsql_add_bind(qltdate.canon_to_number(X_HV_OTHER_VALUE));
345: qa_core_pkg.dsql_add_text(' ,');
346: qa_core_pkg.dsql_add_bind(qltdate.canon_to_number(X_HV_OTHER_VALUE));
347: qa_core_pkg.dsql_add_text(' )');
348:
349: ELSIF (X_DATATYPE IN (3, 6)) THEN
350: qa_core_pkg.dsql_add_bind(qltdate.canon_to_date(X_HV_OTHER_VALUE));

Line 347: qa_core_pkg.dsql_add_text(' )');

343: IF (X_DATATYPE = 2) THEN
344: qa_core_pkg.dsql_add_bind(qltdate.canon_to_number(X_HV_OTHER_VALUE));
345: qa_core_pkg.dsql_add_text(' ,');
346: qa_core_pkg.dsql_add_bind(qltdate.canon_to_number(X_HV_OTHER_VALUE));
347: qa_core_pkg.dsql_add_text(' )');
348:
349: ELSIF (X_DATATYPE IN (3, 6)) THEN
350: qa_core_pkg.dsql_add_bind(qltdate.canon_to_date(X_HV_OTHER_VALUE));
351: qa_core_pkg.dsql_add_text(' ,');

Line 350: qa_core_pkg.dsql_add_bind(qltdate.canon_to_date(X_HV_OTHER_VALUE));

346: qa_core_pkg.dsql_add_bind(qltdate.canon_to_number(X_HV_OTHER_VALUE));
347: qa_core_pkg.dsql_add_text(' )');
348:
349: ELSIF (X_DATATYPE IN (3, 6)) THEN
350: qa_core_pkg.dsql_add_bind(qltdate.canon_to_date(X_HV_OTHER_VALUE));
351: qa_core_pkg.dsql_add_text(' ,');
352: qa_core_pkg.dsql_add_bind(qltdate.canon_to_date(X_HV_OTHER_VALUE));
353: qa_core_pkg.dsql_add_text(' )');
354:

Line 351: qa_core_pkg.dsql_add_text(' ,');

347: qa_core_pkg.dsql_add_text(' )');
348:
349: ELSIF (X_DATATYPE IN (3, 6)) THEN
350: qa_core_pkg.dsql_add_bind(qltdate.canon_to_date(X_HV_OTHER_VALUE));
351: qa_core_pkg.dsql_add_text(' ,');
352: qa_core_pkg.dsql_add_bind(qltdate.canon_to_date(X_HV_OTHER_VALUE));
353: qa_core_pkg.dsql_add_text(' )');
354:
355: ELSE

Line 352: qa_core_pkg.dsql_add_bind(qltdate.canon_to_date(X_HV_OTHER_VALUE));

348:
349: ELSIF (X_DATATYPE IN (3, 6)) THEN
350: qa_core_pkg.dsql_add_bind(qltdate.canon_to_date(X_HV_OTHER_VALUE));
351: qa_core_pkg.dsql_add_text(' ,');
352: qa_core_pkg.dsql_add_bind(qltdate.canon_to_date(X_HV_OTHER_VALUE));
353: qa_core_pkg.dsql_add_text(' )');
354:
355: ELSE
356: qa_core_pkg.dsql_add_bind(X_HV_OTHER_VALUE);

Line 353: qa_core_pkg.dsql_add_text(' )');

349: ELSIF (X_DATATYPE IN (3, 6)) THEN
350: qa_core_pkg.dsql_add_bind(qltdate.canon_to_date(X_HV_OTHER_VALUE));
351: qa_core_pkg.dsql_add_text(' ,');
352: qa_core_pkg.dsql_add_bind(qltdate.canon_to_date(X_HV_OTHER_VALUE));
353: qa_core_pkg.dsql_add_text(' )');
354:
355: ELSE
356: qa_core_pkg.dsql_add_bind(X_HV_OTHER_VALUE);
357: qa_core_pkg.dsql_add_text(' ,');

Line 356: qa_core_pkg.dsql_add_bind(X_HV_OTHER_VALUE);

352: qa_core_pkg.dsql_add_bind(qltdate.canon_to_date(X_HV_OTHER_VALUE));
353: qa_core_pkg.dsql_add_text(' )');
354:
355: ELSE
356: qa_core_pkg.dsql_add_bind(X_HV_OTHER_VALUE);
357: qa_core_pkg.dsql_add_text(' ,');
358: qa_core_pkg.dsql_add_bind(X_HV_OTHER_VALUE);
359: qa_core_pkg.dsql_add_text(' )');
360:

Line 357: qa_core_pkg.dsql_add_text(' ,');

353: qa_core_pkg.dsql_add_text(' )');
354:
355: ELSE
356: qa_core_pkg.dsql_add_bind(X_HV_OTHER_VALUE);
357: qa_core_pkg.dsql_add_text(' ,');
358: qa_core_pkg.dsql_add_bind(X_HV_OTHER_VALUE);
359: qa_core_pkg.dsql_add_text(' )');
360:
361: END IF;

Line 358: qa_core_pkg.dsql_add_bind(X_HV_OTHER_VALUE);

354:
355: ELSE
356: qa_core_pkg.dsql_add_bind(X_HV_OTHER_VALUE);
357: qa_core_pkg.dsql_add_text(' ,');
358: qa_core_pkg.dsql_add_bind(X_HV_OTHER_VALUE);
359: qa_core_pkg.dsql_add_text(' )');
360:
361: END IF;
362:

Line 359: qa_core_pkg.dsql_add_text(' )');

355: ELSE
356: qa_core_pkg.dsql_add_bind(X_HV_OTHER_VALUE);
357: qa_core_pkg.dsql_add_text(' ,');
358: qa_core_pkg.dsql_add_bind(X_HV_OTHER_VALUE);
359: qa_core_pkg.dsql_add_text(' )');
360:
361: END IF;
362:
363: END IF; -- hv_lookup

Line 369: qa_core_pkg.dsql_add_text(' ' || OP);

365: END IF; -- x_operator in 9,10
366:
367: -- is null or is not null
368: ELSE
369: qa_core_pkg.dsql_add_text(' ' || OP);
370:
371: END IF; -- not in (7,8)
372:
373: qa_core_pkg.dsql_add_text(' )');

Line 373: qa_core_pkg.dsql_add_text(' )');

369: qa_core_pkg.dsql_add_text(' ' || OP);
370:
371: END IF; -- not in (7,8)
372:
373: qa_core_pkg.dsql_add_text(' )');
374:
375:
376: END VALIDATE_ACTIONS_HELPER;
377:

Line 414: qa_core_pkg.dsql_init;

410:
411:
412: parse_error_columns(ERROR_COL_LIST, l_col1, l_col2, l_col3, l_col4, l_col5);
413:
414: qa_core_pkg.dsql_init;
415: qa_core_pkg.dsql_add_text(' UPDATE QA_RESULTS_INTERFACE QRI ' ||
416: 'SET LAST_UPDATE_DATE = SYSDATE' ||
417: ', LAST_UPDATE_LOGIN = ');
418: qa_core_pkg.dsql_add_bind(X_LAST_UPDATE_LOGIN);

Line 415: qa_core_pkg.dsql_add_text(' UPDATE QA_RESULTS_INTERFACE QRI ' ||

411:
412: parse_error_columns(ERROR_COL_LIST, l_col1, l_col2, l_col3, l_col4, l_col5);
413:
414: qa_core_pkg.dsql_init;
415: qa_core_pkg.dsql_add_text(' UPDATE QA_RESULTS_INTERFACE QRI ' ||
416: 'SET LAST_UPDATE_DATE = SYSDATE' ||
417: ', LAST_UPDATE_LOGIN = ');
418: qa_core_pkg.dsql_add_bind(X_LAST_UPDATE_LOGIN);
419: qa_core_pkg.dsql_add_text(' , REQUEST_ID = ');

Line 418: qa_core_pkg.dsql_add_bind(X_LAST_UPDATE_LOGIN);

414: qa_core_pkg.dsql_init;
415: qa_core_pkg.dsql_add_text(' UPDATE QA_RESULTS_INTERFACE QRI ' ||
416: 'SET LAST_UPDATE_DATE = SYSDATE' ||
417: ', LAST_UPDATE_LOGIN = ');
418: qa_core_pkg.dsql_add_bind(X_LAST_UPDATE_LOGIN);
419: qa_core_pkg.dsql_add_text(' , REQUEST_ID = ');
420: qa_core_pkg.dsql_add_bind(X_REQUEST_ID);
421: qa_core_pkg.dsql_add_text(' , PROGRAM_APPLICATION_ID = ');
422: qa_core_pkg.dsql_add_bind(X_PROGRAM_APPLICATION_ID);

Line 419: qa_core_pkg.dsql_add_text(' , REQUEST_ID = ');

415: qa_core_pkg.dsql_add_text(' UPDATE QA_RESULTS_INTERFACE QRI ' ||
416: 'SET LAST_UPDATE_DATE = SYSDATE' ||
417: ', LAST_UPDATE_LOGIN = ');
418: qa_core_pkg.dsql_add_bind(X_LAST_UPDATE_LOGIN);
419: qa_core_pkg.dsql_add_text(' , REQUEST_ID = ');
420: qa_core_pkg.dsql_add_bind(X_REQUEST_ID);
421: qa_core_pkg.dsql_add_text(' , PROGRAM_APPLICATION_ID = ');
422: qa_core_pkg.dsql_add_bind(X_PROGRAM_APPLICATION_ID);
423: qa_core_pkg.dsql_add_text(' , PROGRAM_ID = ');

Line 420: qa_core_pkg.dsql_add_bind(X_REQUEST_ID);

416: 'SET LAST_UPDATE_DATE = SYSDATE' ||
417: ', LAST_UPDATE_LOGIN = ');
418: qa_core_pkg.dsql_add_bind(X_LAST_UPDATE_LOGIN);
419: qa_core_pkg.dsql_add_text(' , REQUEST_ID = ');
420: qa_core_pkg.dsql_add_bind(X_REQUEST_ID);
421: qa_core_pkg.dsql_add_text(' , PROGRAM_APPLICATION_ID = ');
422: qa_core_pkg.dsql_add_bind(X_PROGRAM_APPLICATION_ID);
423: qa_core_pkg.dsql_add_text(' , PROGRAM_ID = ');
424: qa_core_pkg.dsql_add_bind(X_PROGRAM_ID);

Line 421: qa_core_pkg.dsql_add_text(' , PROGRAM_APPLICATION_ID = ');

417: ', LAST_UPDATE_LOGIN = ');
418: qa_core_pkg.dsql_add_bind(X_LAST_UPDATE_LOGIN);
419: qa_core_pkg.dsql_add_text(' , REQUEST_ID = ');
420: qa_core_pkg.dsql_add_bind(X_REQUEST_ID);
421: qa_core_pkg.dsql_add_text(' , PROGRAM_APPLICATION_ID = ');
422: qa_core_pkg.dsql_add_bind(X_PROGRAM_APPLICATION_ID);
423: qa_core_pkg.dsql_add_text(' , PROGRAM_ID = ');
424: qa_core_pkg.dsql_add_bind(X_PROGRAM_ID);
425: qa_core_pkg.dsql_add_text(' , PROGRAM_UPDATE_DATE = SYSDATE ' ||

Line 422: qa_core_pkg.dsql_add_bind(X_PROGRAM_APPLICATION_ID);

418: qa_core_pkg.dsql_add_bind(X_LAST_UPDATE_LOGIN);
419: qa_core_pkg.dsql_add_text(' , REQUEST_ID = ');
420: qa_core_pkg.dsql_add_bind(X_REQUEST_ID);
421: qa_core_pkg.dsql_add_text(' , PROGRAM_APPLICATION_ID = ');
422: qa_core_pkg.dsql_add_bind(X_PROGRAM_APPLICATION_ID);
423: qa_core_pkg.dsql_add_text(' , PROGRAM_ID = ');
424: qa_core_pkg.dsql_add_bind(X_PROGRAM_ID);
425: qa_core_pkg.dsql_add_text(' , PROGRAM_UPDATE_DATE = SYSDATE ' ||
426: ' , MARKER = ');

Line 423: qa_core_pkg.dsql_add_text(' , PROGRAM_ID = ');

419: qa_core_pkg.dsql_add_text(' , REQUEST_ID = ');
420: qa_core_pkg.dsql_add_bind(X_REQUEST_ID);
421: qa_core_pkg.dsql_add_text(' , PROGRAM_APPLICATION_ID = ');
422: qa_core_pkg.dsql_add_bind(X_PROGRAM_APPLICATION_ID);
423: qa_core_pkg.dsql_add_text(' , PROGRAM_ID = ');
424: qa_core_pkg.dsql_add_bind(X_PROGRAM_ID);
425: qa_core_pkg.dsql_add_text(' , PROGRAM_UPDATE_DATE = SYSDATE ' ||
426: ' , MARKER = ');
427:

Line 424: qa_core_pkg.dsql_add_bind(X_PROGRAM_ID);

420: qa_core_pkg.dsql_add_bind(X_REQUEST_ID);
421: qa_core_pkg.dsql_add_text(' , PROGRAM_APPLICATION_ID = ');
422: qa_core_pkg.dsql_add_bind(X_PROGRAM_APPLICATION_ID);
423: qa_core_pkg.dsql_add_text(' , PROGRAM_ID = ');
424: qa_core_pkg.dsql_add_bind(X_PROGRAM_ID);
425: qa_core_pkg.dsql_add_text(' , PROGRAM_UPDATE_DATE = SYSDATE ' ||
426: ' , MARKER = ');
427:
428: qa_core_pkg.dsql_add_bind(X_PCAT_ID);

Line 425: qa_core_pkg.dsql_add_text(' , PROGRAM_UPDATE_DATE = SYSDATE ' ||

421: qa_core_pkg.dsql_add_text(' , PROGRAM_APPLICATION_ID = ');
422: qa_core_pkg.dsql_add_bind(X_PROGRAM_APPLICATION_ID);
423: qa_core_pkg.dsql_add_text(' , PROGRAM_ID = ');
424: qa_core_pkg.dsql_add_bind(X_PROGRAM_ID);
425: qa_core_pkg.dsql_add_text(' , PROGRAM_UPDATE_DATE = SYSDATE ' ||
426: ' , MARKER = ');
427:
428: qa_core_pkg.dsql_add_bind(X_PCAT_ID);
429: qa_core_pkg.dsql_add_text(' ');

Line 428: qa_core_pkg.dsql_add_bind(X_PCAT_ID);

424: qa_core_pkg.dsql_add_bind(X_PROGRAM_ID);
425: qa_core_pkg.dsql_add_text(' , PROGRAM_UPDATE_DATE = SYSDATE ' ||
426: ' , MARKER = ');
427:
428: qa_core_pkg.dsql_add_bind(X_PCAT_ID);
429: qa_core_pkg.dsql_add_text(' ');
430:
431: -- update_sql_two
432: qa_core_pkg.dsql_add_text(' WHERE QRI.GROUP_ID = ');

Line 429: qa_core_pkg.dsql_add_text(' ');

425: qa_core_pkg.dsql_add_text(' , PROGRAM_UPDATE_DATE = SYSDATE ' ||
426: ' , MARKER = ');
427:
428: qa_core_pkg.dsql_add_bind(X_PCAT_ID);
429: qa_core_pkg.dsql_add_text(' ');
430:
431: -- update_sql_two
432: qa_core_pkg.dsql_add_text(' WHERE QRI.GROUP_ID = ');
433: qa_core_pkg.dsql_add_bind(X_GROUP_ID);

Line 432: qa_core_pkg.dsql_add_text(' WHERE QRI.GROUP_ID = ');

428: qa_core_pkg.dsql_add_bind(X_PCAT_ID);
429: qa_core_pkg.dsql_add_text(' ');
430:
431: -- update_sql_two
432: qa_core_pkg.dsql_add_text(' WHERE QRI.GROUP_ID = ');
433: qa_core_pkg.dsql_add_bind(X_GROUP_ID);
434: qa_core_pkg.dsql_add_text(' AND QRI.PROCESS_STATUS = 2 ' ||
435: ' AND NOT EXISTS ' ||
436: ' (SELECT 1 ' ||

Line 433: qa_core_pkg.dsql_add_bind(X_GROUP_ID);

429: qa_core_pkg.dsql_add_text(' ');
430:
431: -- update_sql_two
432: qa_core_pkg.dsql_add_text(' WHERE QRI.GROUP_ID = ');
433: qa_core_pkg.dsql_add_bind(X_GROUP_ID);
434: qa_core_pkg.dsql_add_text(' AND QRI.PROCESS_STATUS = 2 ' ||
435: ' AND NOT EXISTS ' ||
436: ' (SELECT 1 ' ||
437: ' FROM QA_INTERFACE_ERRORS QIE ' ||

Line 434: qa_core_pkg.dsql_add_text(' AND QRI.PROCESS_STATUS = 2 ' ||

430:
431: -- update_sql_two
432: qa_core_pkg.dsql_add_text(' WHERE QRI.GROUP_ID = ');
433: qa_core_pkg.dsql_add_bind(X_GROUP_ID);
434: qa_core_pkg.dsql_add_text(' AND QRI.PROCESS_STATUS = 2 ' ||
435: ' AND NOT EXISTS ' ||
436: ' (SELECT 1 ' ||
437: ' FROM QA_INTERFACE_ERRORS QIE ' ||
438: ' WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||

Line 441: qa_core_pkg.dsql_add_bind(l_col1);

437: ' FROM QA_INTERFACE_ERRORS QIE ' ||
438: ' WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
439: ' QRI.TRANSACTION_INTERFACE_ID ' ||
440: ' AND QIE.ERROR_COLUMN IN ( ' );
441: qa_core_pkg.dsql_add_bind(l_col1);
442: qa_core_pkg.dsql_add_text(' ,');
443: qa_core_pkg.dsql_add_bind(l_col2);
444: qa_core_pkg.dsql_add_text(' ,');
445: qa_core_pkg.dsql_add_bind(l_col3);

Line 442: qa_core_pkg.dsql_add_text(' ,');

438: ' WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
439: ' QRI.TRANSACTION_INTERFACE_ID ' ||
440: ' AND QIE.ERROR_COLUMN IN ( ' );
441: qa_core_pkg.dsql_add_bind(l_col1);
442: qa_core_pkg.dsql_add_text(' ,');
443: qa_core_pkg.dsql_add_bind(l_col2);
444: qa_core_pkg.dsql_add_text(' ,');
445: qa_core_pkg.dsql_add_bind(l_col3);
446: qa_core_pkg.dsql_add_text(' ,');

Line 443: qa_core_pkg.dsql_add_bind(l_col2);

439: ' QRI.TRANSACTION_INTERFACE_ID ' ||
440: ' AND QIE.ERROR_COLUMN IN ( ' );
441: qa_core_pkg.dsql_add_bind(l_col1);
442: qa_core_pkg.dsql_add_text(' ,');
443: qa_core_pkg.dsql_add_bind(l_col2);
444: qa_core_pkg.dsql_add_text(' ,');
445: qa_core_pkg.dsql_add_bind(l_col3);
446: qa_core_pkg.dsql_add_text(' ,');
447: qa_core_pkg.dsql_add_bind(l_col4);

Line 444: qa_core_pkg.dsql_add_text(' ,');

440: ' AND QIE.ERROR_COLUMN IN ( ' );
441: qa_core_pkg.dsql_add_bind(l_col1);
442: qa_core_pkg.dsql_add_text(' ,');
443: qa_core_pkg.dsql_add_bind(l_col2);
444: qa_core_pkg.dsql_add_text(' ,');
445: qa_core_pkg.dsql_add_bind(l_col3);
446: qa_core_pkg.dsql_add_text(' ,');
447: qa_core_pkg.dsql_add_bind(l_col4);
448: qa_core_pkg.dsql_add_text(' ,');

Line 445: qa_core_pkg.dsql_add_bind(l_col3);

441: qa_core_pkg.dsql_add_bind(l_col1);
442: qa_core_pkg.dsql_add_text(' ,');
443: qa_core_pkg.dsql_add_bind(l_col2);
444: qa_core_pkg.dsql_add_text(' ,');
445: qa_core_pkg.dsql_add_bind(l_col3);
446: qa_core_pkg.dsql_add_text(' ,');
447: qa_core_pkg.dsql_add_bind(l_col4);
448: qa_core_pkg.dsql_add_text(' ,');
449: qa_core_pkg.dsql_add_bind(l_col5);

Line 446: qa_core_pkg.dsql_add_text(' ,');

442: qa_core_pkg.dsql_add_text(' ,');
443: qa_core_pkg.dsql_add_bind(l_col2);
444: qa_core_pkg.dsql_add_text(' ,');
445: qa_core_pkg.dsql_add_bind(l_col3);
446: qa_core_pkg.dsql_add_text(' ,');
447: qa_core_pkg.dsql_add_bind(l_col4);
448: qa_core_pkg.dsql_add_text(' ,');
449: qa_core_pkg.dsql_add_bind(l_col5);
450: qa_core_pkg.dsql_add_text(' )');

Line 447: qa_core_pkg.dsql_add_bind(l_col4);

443: qa_core_pkg.dsql_add_bind(l_col2);
444: qa_core_pkg.dsql_add_text(' ,');
445: qa_core_pkg.dsql_add_bind(l_col3);
446: qa_core_pkg.dsql_add_text(' ,');
447: qa_core_pkg.dsql_add_bind(l_col4);
448: qa_core_pkg.dsql_add_text(' ,');
449: qa_core_pkg.dsql_add_bind(l_col5);
450: qa_core_pkg.dsql_add_text(' )');
451:

Line 448: qa_core_pkg.dsql_add_text(' ,');

444: qa_core_pkg.dsql_add_text(' ,');
445: qa_core_pkg.dsql_add_bind(l_col3);
446: qa_core_pkg.dsql_add_text(' ,');
447: qa_core_pkg.dsql_add_bind(l_col4);
448: qa_core_pkg.dsql_add_text(' ,');
449: qa_core_pkg.dsql_add_bind(l_col5);
450: qa_core_pkg.dsql_add_text(' )');
451:
452: qa_core_pkg.dsql_add_text(') AND EXISTS ');

Line 449: qa_core_pkg.dsql_add_bind(l_col5);

445: qa_core_pkg.dsql_add_bind(l_col3);
446: qa_core_pkg.dsql_add_text(' ,');
447: qa_core_pkg.dsql_add_bind(l_col4);
448: qa_core_pkg.dsql_add_text(' ,');
449: qa_core_pkg.dsql_add_bind(l_col5);
450: qa_core_pkg.dsql_add_text(' )');
451:
452: qa_core_pkg.dsql_add_text(') AND EXISTS ');
453:

Line 450: qa_core_pkg.dsql_add_text(' )');

446: qa_core_pkg.dsql_add_text(' ,');
447: qa_core_pkg.dsql_add_bind(l_col4);
448: qa_core_pkg.dsql_add_text(' ,');
449: qa_core_pkg.dsql_add_bind(l_col5);
450: qa_core_pkg.dsql_add_text(' )');
451:
452: qa_core_pkg.dsql_add_text(') AND EXISTS ');
453:
454:

Line 452: qa_core_pkg.dsql_add_text(') AND EXISTS ');

448: qa_core_pkg.dsql_add_text(' ,');
449: qa_core_pkg.dsql_add_bind(l_col5);
450: qa_core_pkg.dsql_add_text(' )');
451:
452: qa_core_pkg.dsql_add_text(') AND EXISTS ');
453:
454:
455: VALIDATE_ACTIONS_HELPER (ERROR_COL_NAME, COL_NAME,X_DATATYPE, X_CHAR_ID, X_PLAN_ID,
456: X_LV_LOOKUP_VALUE, X_LV_OTHER_VALUE,

Line 461: qa_core_pkg.dsql_execute;

457: X_HV_LOOKUP_VALUE, X_HV_OTHER_VALUE,
458: X_OP_CODE);
459:
460:
461: qa_core_pkg.dsql_execute;
462:
463:
464:
465: END UPDATE_MARKER;

Line 502: qa_core_pkg.dsql_init;

498:
499:
500: BEGIN
501: parse_error_columns(ERROR_COL_LIST, l_col1, l_col2, l_col3, l_col4, l_col5);
502: qa_core_pkg.dsql_init;
503:
504: qa_core_pkg.dsql_add_text(' INSERT INTO QA_INTERFACE_ERRORS ' ||
505: '( TRANSACTION_INTERFACE_ID, ' ||
506: ' ERROR_COLUMN, ' ||

Line 504: qa_core_pkg.dsql_add_text(' INSERT INTO QA_INTERFACE_ERRORS ' ||

500: BEGIN
501: parse_error_columns(ERROR_COL_LIST, l_col1, l_col2, l_col3, l_col4, l_col5);
502: qa_core_pkg.dsql_init;
503:
504: qa_core_pkg.dsql_add_text(' INSERT INTO QA_INTERFACE_ERRORS ' ||
505: '( TRANSACTION_INTERFACE_ID, ' ||
506: ' ERROR_COLUMN, ' ||
507: ' ERROR_MESSAGE, ' ||
508: ' LAST_UPDATE_DATE,' ||

Line 518: qa_core_pkg.dsql_add_text(' SELECT QRI.TRANSACTION_INTERFACE_ID, ');

514: ' PROGRAM_APPLICATION_ID, ' ||
515: ' PROGRAM_ID, ' ||
516: ' PROGRAM_UPDATE_DATE ) ' );
517:
518: qa_core_pkg.dsql_add_text(' SELECT QRI.TRANSACTION_INTERFACE_ID, ');
519: qa_core_pkg.dsql_add_bind(ERROR_COL_NAME);
520: qa_core_pkg.dsql_add_text(' ,');
521: qa_core_pkg.dsql_add_bind(ERROR_REJECT);
522: qa_core_pkg.dsql_add_text(' ,');

Line 519: qa_core_pkg.dsql_add_bind(ERROR_COL_NAME);

515: ' PROGRAM_ID, ' ||
516: ' PROGRAM_UPDATE_DATE ) ' );
517:
518: qa_core_pkg.dsql_add_text(' SELECT QRI.TRANSACTION_INTERFACE_ID, ');
519: qa_core_pkg.dsql_add_bind(ERROR_COL_NAME);
520: qa_core_pkg.dsql_add_text(' ,');
521: qa_core_pkg.dsql_add_bind(ERROR_REJECT);
522: qa_core_pkg.dsql_add_text(' ,');
523: qa_core_pkg.dsql_add_text(' SYSDATE, '); -- last_update_date

Line 520: qa_core_pkg.dsql_add_text(' ,');

516: ' PROGRAM_UPDATE_DATE ) ' );
517:
518: qa_core_pkg.dsql_add_text(' SELECT QRI.TRANSACTION_INTERFACE_ID, ');
519: qa_core_pkg.dsql_add_bind(ERROR_COL_NAME);
520: qa_core_pkg.dsql_add_text(' ,');
521: qa_core_pkg.dsql_add_bind(ERROR_REJECT);
522: qa_core_pkg.dsql_add_text(' ,');
523: qa_core_pkg.dsql_add_text(' SYSDATE, '); -- last_update_date
524: qa_core_pkg.dsql_add_bind(X_USER_ID); -- last_updated_by

Line 521: qa_core_pkg.dsql_add_bind(ERROR_REJECT);

517:
518: qa_core_pkg.dsql_add_text(' SELECT QRI.TRANSACTION_INTERFACE_ID, ');
519: qa_core_pkg.dsql_add_bind(ERROR_COL_NAME);
520: qa_core_pkg.dsql_add_text(' ,');
521: qa_core_pkg.dsql_add_bind(ERROR_REJECT);
522: qa_core_pkg.dsql_add_text(' ,');
523: qa_core_pkg.dsql_add_text(' SYSDATE, '); -- last_update_date
524: qa_core_pkg.dsql_add_bind(X_USER_ID); -- last_updated_by
525: qa_core_pkg.dsql_add_text(' , SYSDATE,'); -- creation_date

Line 522: qa_core_pkg.dsql_add_text(' ,');

518: qa_core_pkg.dsql_add_text(' SELECT QRI.TRANSACTION_INTERFACE_ID, ');
519: qa_core_pkg.dsql_add_bind(ERROR_COL_NAME);
520: qa_core_pkg.dsql_add_text(' ,');
521: qa_core_pkg.dsql_add_bind(ERROR_REJECT);
522: qa_core_pkg.dsql_add_text(' ,');
523: qa_core_pkg.dsql_add_text(' SYSDATE, '); -- last_update_date
524: qa_core_pkg.dsql_add_bind(X_USER_ID); -- last_updated_by
525: qa_core_pkg.dsql_add_text(' , SYSDATE,'); -- creation_date
526: qa_core_pkg.dsql_add_bind(X_USER_ID); -- created by

Line 523: qa_core_pkg.dsql_add_text(' SYSDATE, '); -- last_update_date

519: qa_core_pkg.dsql_add_bind(ERROR_COL_NAME);
520: qa_core_pkg.dsql_add_text(' ,');
521: qa_core_pkg.dsql_add_bind(ERROR_REJECT);
522: qa_core_pkg.dsql_add_text(' ,');
523: qa_core_pkg.dsql_add_text(' SYSDATE, '); -- last_update_date
524: qa_core_pkg.dsql_add_bind(X_USER_ID); -- last_updated_by
525: qa_core_pkg.dsql_add_text(' , SYSDATE,'); -- creation_date
526: qa_core_pkg.dsql_add_bind(X_USER_ID); -- created by
527: qa_core_pkg.dsql_add_text(' , ');

Line 524: qa_core_pkg.dsql_add_bind(X_USER_ID); -- last_updated_by

520: qa_core_pkg.dsql_add_text(' ,');
521: qa_core_pkg.dsql_add_bind(ERROR_REJECT);
522: qa_core_pkg.dsql_add_text(' ,');
523: qa_core_pkg.dsql_add_text(' SYSDATE, '); -- last_update_date
524: qa_core_pkg.dsql_add_bind(X_USER_ID); -- last_updated_by
525: qa_core_pkg.dsql_add_text(' , SYSDATE,'); -- creation_date
526: qa_core_pkg.dsql_add_bind(X_USER_ID); -- created by
527: qa_core_pkg.dsql_add_text(' , ');
528: qa_core_pkg.dsql_add_bind(X_LAST_UPDATE_LOGIN); -- last_update_login

Line 525: qa_core_pkg.dsql_add_text(' , SYSDATE,'); -- creation_date

521: qa_core_pkg.dsql_add_bind(ERROR_REJECT);
522: qa_core_pkg.dsql_add_text(' ,');
523: qa_core_pkg.dsql_add_text(' SYSDATE, '); -- last_update_date
524: qa_core_pkg.dsql_add_bind(X_USER_ID); -- last_updated_by
525: qa_core_pkg.dsql_add_text(' , SYSDATE,'); -- creation_date
526: qa_core_pkg.dsql_add_bind(X_USER_ID); -- created by
527: qa_core_pkg.dsql_add_text(' , ');
528: qa_core_pkg.dsql_add_bind(X_LAST_UPDATE_LOGIN); -- last_update_login
529: qa_core_pkg.dsql_add_text(' ,');

Line 526: qa_core_pkg.dsql_add_bind(X_USER_ID); -- created by

522: qa_core_pkg.dsql_add_text(' ,');
523: qa_core_pkg.dsql_add_text(' SYSDATE, '); -- last_update_date
524: qa_core_pkg.dsql_add_bind(X_USER_ID); -- last_updated_by
525: qa_core_pkg.dsql_add_text(' , SYSDATE,'); -- creation_date
526: qa_core_pkg.dsql_add_bind(X_USER_ID); -- created by
527: qa_core_pkg.dsql_add_text(' , ');
528: qa_core_pkg.dsql_add_bind(X_LAST_UPDATE_LOGIN); -- last_update_login
529: qa_core_pkg.dsql_add_text(' ,');
530: qa_core_pkg.dsql_add_bind(X_REQUEST_ID);

Line 527: qa_core_pkg.dsql_add_text(' , ');

523: qa_core_pkg.dsql_add_text(' SYSDATE, '); -- last_update_date
524: qa_core_pkg.dsql_add_bind(X_USER_ID); -- last_updated_by
525: qa_core_pkg.dsql_add_text(' , SYSDATE,'); -- creation_date
526: qa_core_pkg.dsql_add_bind(X_USER_ID); -- created by
527: qa_core_pkg.dsql_add_text(' , ');
528: qa_core_pkg.dsql_add_bind(X_LAST_UPDATE_LOGIN); -- last_update_login
529: qa_core_pkg.dsql_add_text(' ,');
530: qa_core_pkg.dsql_add_bind(X_REQUEST_ID);
531: qa_core_pkg.dsql_add_text(' ,');

Line 528: qa_core_pkg.dsql_add_bind(X_LAST_UPDATE_LOGIN); -- last_update_login

524: qa_core_pkg.dsql_add_bind(X_USER_ID); -- last_updated_by
525: qa_core_pkg.dsql_add_text(' , SYSDATE,'); -- creation_date
526: qa_core_pkg.dsql_add_bind(X_USER_ID); -- created by
527: qa_core_pkg.dsql_add_text(' , ');
528: qa_core_pkg.dsql_add_bind(X_LAST_UPDATE_LOGIN); -- last_update_login
529: qa_core_pkg.dsql_add_text(' ,');
530: qa_core_pkg.dsql_add_bind(X_REQUEST_ID);
531: qa_core_pkg.dsql_add_text(' ,');
532: qa_core_pkg.dsql_add_bind(X_PROGRAM_APPLICATION_ID);

Line 529: qa_core_pkg.dsql_add_text(' ,');

525: qa_core_pkg.dsql_add_text(' , SYSDATE,'); -- creation_date
526: qa_core_pkg.dsql_add_bind(X_USER_ID); -- created by
527: qa_core_pkg.dsql_add_text(' , ');
528: qa_core_pkg.dsql_add_bind(X_LAST_UPDATE_LOGIN); -- last_update_login
529: qa_core_pkg.dsql_add_text(' ,');
530: qa_core_pkg.dsql_add_bind(X_REQUEST_ID);
531: qa_core_pkg.dsql_add_text(' ,');
532: qa_core_pkg.dsql_add_bind(X_PROGRAM_APPLICATION_ID);
533: qa_core_pkg.dsql_add_text(' ,');

Line 530: qa_core_pkg.dsql_add_bind(X_REQUEST_ID);

526: qa_core_pkg.dsql_add_bind(X_USER_ID); -- created by
527: qa_core_pkg.dsql_add_text(' , ');
528: qa_core_pkg.dsql_add_bind(X_LAST_UPDATE_LOGIN); -- last_update_login
529: qa_core_pkg.dsql_add_text(' ,');
530: qa_core_pkg.dsql_add_bind(X_REQUEST_ID);
531: qa_core_pkg.dsql_add_text(' ,');
532: qa_core_pkg.dsql_add_bind(X_PROGRAM_APPLICATION_ID);
533: qa_core_pkg.dsql_add_text(' ,');
534: qa_core_pkg.dsql_add_bind(X_PROGRAM_ID);

Line 531: qa_core_pkg.dsql_add_text(' ,');

527: qa_core_pkg.dsql_add_text(' , ');
528: qa_core_pkg.dsql_add_bind(X_LAST_UPDATE_LOGIN); -- last_update_login
529: qa_core_pkg.dsql_add_text(' ,');
530: qa_core_pkg.dsql_add_bind(X_REQUEST_ID);
531: qa_core_pkg.dsql_add_text(' ,');
532: qa_core_pkg.dsql_add_bind(X_PROGRAM_APPLICATION_ID);
533: qa_core_pkg.dsql_add_text(' ,');
534: qa_core_pkg.dsql_add_bind(X_PROGRAM_ID);
535: qa_core_pkg.dsql_add_text(' , SYSDATE ');

Line 532: qa_core_pkg.dsql_add_bind(X_PROGRAM_APPLICATION_ID);

528: qa_core_pkg.dsql_add_bind(X_LAST_UPDATE_LOGIN); -- last_update_login
529: qa_core_pkg.dsql_add_text(' ,');
530: qa_core_pkg.dsql_add_bind(X_REQUEST_ID);
531: qa_core_pkg.dsql_add_text(' ,');
532: qa_core_pkg.dsql_add_bind(X_PROGRAM_APPLICATION_ID);
533: qa_core_pkg.dsql_add_text(' ,');
534: qa_core_pkg.dsql_add_bind(X_PROGRAM_ID);
535: qa_core_pkg.dsql_add_text(' , SYSDATE ');
536:

Line 533: qa_core_pkg.dsql_add_text(' ,');

529: qa_core_pkg.dsql_add_text(' ,');
530: qa_core_pkg.dsql_add_bind(X_REQUEST_ID);
531: qa_core_pkg.dsql_add_text(' ,');
532: qa_core_pkg.dsql_add_bind(X_PROGRAM_APPLICATION_ID);
533: qa_core_pkg.dsql_add_text(' ,');
534: qa_core_pkg.dsql_add_bind(X_PROGRAM_ID);
535: qa_core_pkg.dsql_add_text(' , SYSDATE ');
536:
537:

Line 534: qa_core_pkg.dsql_add_bind(X_PROGRAM_ID);

530: qa_core_pkg.dsql_add_bind(X_REQUEST_ID);
531: qa_core_pkg.dsql_add_text(' ,');
532: qa_core_pkg.dsql_add_bind(X_PROGRAM_APPLICATION_ID);
533: qa_core_pkg.dsql_add_text(' ,');
534: qa_core_pkg.dsql_add_bind(X_PROGRAM_ID);
535: qa_core_pkg.dsql_add_text(' , SYSDATE ');
536:
537:
538: qa_core_pkg.dsql_add_text(' FROM QA_RESULTS_INTERFACE QRI ' ||

Line 535: qa_core_pkg.dsql_add_text(' , SYSDATE ');

531: qa_core_pkg.dsql_add_text(' ,');
532: qa_core_pkg.dsql_add_bind(X_PROGRAM_APPLICATION_ID);
533: qa_core_pkg.dsql_add_text(' ,');
534: qa_core_pkg.dsql_add_bind(X_PROGRAM_ID);
535: qa_core_pkg.dsql_add_text(' , SYSDATE ');
536:
537:
538: qa_core_pkg.dsql_add_text(' FROM QA_RESULTS_INTERFACE QRI ' ||
539: 'WHERE QRI.GROUP_ID = ' );

Line 538: qa_core_pkg.dsql_add_text(' FROM QA_RESULTS_INTERFACE QRI ' ||

534: qa_core_pkg.dsql_add_bind(X_PROGRAM_ID);
535: qa_core_pkg.dsql_add_text(' , SYSDATE ');
536:
537:
538: qa_core_pkg.dsql_add_text(' FROM QA_RESULTS_INTERFACE QRI ' ||
539: 'WHERE QRI.GROUP_ID = ' );
540:
541: qa_core_pkg.dsql_add_bind(X_GROUP_ID);
542: qa_core_pkg.dsql_add_text(' ');

Line 541: qa_core_pkg.dsql_add_bind(X_GROUP_ID);

537:
538: qa_core_pkg.dsql_add_text(' FROM QA_RESULTS_INTERFACE QRI ' ||
539: 'WHERE QRI.GROUP_ID = ' );
540:
541: qa_core_pkg.dsql_add_bind(X_GROUP_ID);
542: qa_core_pkg.dsql_add_text(' ');
543:
544: qa_core_pkg.dsql_add_text(' AND QRI.PROCESS_STATUS = 2 ' ||
545: ' AND NVL(QRI.MARKER, 0) = 0 ' ||

Line 542: qa_core_pkg.dsql_add_text(' ');

538: qa_core_pkg.dsql_add_text(' FROM QA_RESULTS_INTERFACE QRI ' ||
539: 'WHERE QRI.GROUP_ID = ' );
540:
541: qa_core_pkg.dsql_add_bind(X_GROUP_ID);
542: qa_core_pkg.dsql_add_text(' ');
543:
544: qa_core_pkg.dsql_add_text(' AND QRI.PROCESS_STATUS = 2 ' ||
545: ' AND NVL(QRI.MARKER, 0) = 0 ' ||
546: ' AND NOT EXISTS ' ||

Line 544: qa_core_pkg.dsql_add_text(' AND QRI.PROCESS_STATUS = 2 ' ||

540:
541: qa_core_pkg.dsql_add_bind(X_GROUP_ID);
542: qa_core_pkg.dsql_add_text(' ');
543:
544: qa_core_pkg.dsql_add_text(' AND QRI.PROCESS_STATUS = 2 ' ||
545: ' AND NVL(QRI.MARKER, 0) = 0 ' ||
546: ' AND NOT EXISTS ' ||
547: ' (SELECT 1 ' ||
548: ' FROM QA_INTERFACE_ERRORS QIE ' ||

Line 553: qa_core_pkg.dsql_add_bind(l_col1);

549: ' WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
550: ' QRI.TRANSACTION_INTERFACE_ID ' ||
551: ' AND QIE.ERROR_COLUMN IN ( ');
552:
553: qa_core_pkg.dsql_add_bind(l_col1);
554: qa_core_pkg.dsql_add_text(' ,');
555: qa_core_pkg.dsql_add_bind(l_col2);
556: qa_core_pkg.dsql_add_text(' ,');
557: qa_core_pkg.dsql_add_bind(l_col3);

Line 554: qa_core_pkg.dsql_add_text(' ,');

550: ' QRI.TRANSACTION_INTERFACE_ID ' ||
551: ' AND QIE.ERROR_COLUMN IN ( ');
552:
553: qa_core_pkg.dsql_add_bind(l_col1);
554: qa_core_pkg.dsql_add_text(' ,');
555: qa_core_pkg.dsql_add_bind(l_col2);
556: qa_core_pkg.dsql_add_text(' ,');
557: qa_core_pkg.dsql_add_bind(l_col3);
558: qa_core_pkg.dsql_add_text(' ,');

Line 555: qa_core_pkg.dsql_add_bind(l_col2);

551: ' AND QIE.ERROR_COLUMN IN ( ');
552:
553: qa_core_pkg.dsql_add_bind(l_col1);
554: qa_core_pkg.dsql_add_text(' ,');
555: qa_core_pkg.dsql_add_bind(l_col2);
556: qa_core_pkg.dsql_add_text(' ,');
557: qa_core_pkg.dsql_add_bind(l_col3);
558: qa_core_pkg.dsql_add_text(' ,');
559: qa_core_pkg.dsql_add_bind(l_col4);

Line 556: qa_core_pkg.dsql_add_text(' ,');

552:
553: qa_core_pkg.dsql_add_bind(l_col1);
554: qa_core_pkg.dsql_add_text(' ,');
555: qa_core_pkg.dsql_add_bind(l_col2);
556: qa_core_pkg.dsql_add_text(' ,');
557: qa_core_pkg.dsql_add_bind(l_col3);
558: qa_core_pkg.dsql_add_text(' ,');
559: qa_core_pkg.dsql_add_bind(l_col4);
560: qa_core_pkg.dsql_add_text(' ,');

Line 557: qa_core_pkg.dsql_add_bind(l_col3);

553: qa_core_pkg.dsql_add_bind(l_col1);
554: qa_core_pkg.dsql_add_text(' ,');
555: qa_core_pkg.dsql_add_bind(l_col2);
556: qa_core_pkg.dsql_add_text(' ,');
557: qa_core_pkg.dsql_add_bind(l_col3);
558: qa_core_pkg.dsql_add_text(' ,');
559: qa_core_pkg.dsql_add_bind(l_col4);
560: qa_core_pkg.dsql_add_text(' ,');
561: qa_core_pkg.dsql_add_bind(l_col5);

Line 558: qa_core_pkg.dsql_add_text(' ,');

554: qa_core_pkg.dsql_add_text(' ,');
555: qa_core_pkg.dsql_add_bind(l_col2);
556: qa_core_pkg.dsql_add_text(' ,');
557: qa_core_pkg.dsql_add_bind(l_col3);
558: qa_core_pkg.dsql_add_text(' ,');
559: qa_core_pkg.dsql_add_bind(l_col4);
560: qa_core_pkg.dsql_add_text(' ,');
561: qa_core_pkg.dsql_add_bind(l_col5);
562: qa_core_pkg.dsql_add_text(' )');

Line 559: qa_core_pkg.dsql_add_bind(l_col4);

555: qa_core_pkg.dsql_add_bind(l_col2);
556: qa_core_pkg.dsql_add_text(' ,');
557: qa_core_pkg.dsql_add_bind(l_col3);
558: qa_core_pkg.dsql_add_text(' ,');
559: qa_core_pkg.dsql_add_bind(l_col4);
560: qa_core_pkg.dsql_add_text(' ,');
561: qa_core_pkg.dsql_add_bind(l_col5);
562: qa_core_pkg.dsql_add_text(' )');
563:

Line 560: qa_core_pkg.dsql_add_text(' ,');

556: qa_core_pkg.dsql_add_text(' ,');
557: qa_core_pkg.dsql_add_bind(l_col3);
558: qa_core_pkg.dsql_add_text(' ,');
559: qa_core_pkg.dsql_add_bind(l_col4);
560: qa_core_pkg.dsql_add_text(' ,');
561: qa_core_pkg.dsql_add_bind(l_col5);
562: qa_core_pkg.dsql_add_text(' )');
563:
564: qa_core_pkg.dsql_add_text(') AND EXISTS ');

Line 561: qa_core_pkg.dsql_add_bind(l_col5);

557: qa_core_pkg.dsql_add_bind(l_col3);
558: qa_core_pkg.dsql_add_text(' ,');
559: qa_core_pkg.dsql_add_bind(l_col4);
560: qa_core_pkg.dsql_add_text(' ,');
561: qa_core_pkg.dsql_add_bind(l_col5);
562: qa_core_pkg.dsql_add_text(' )');
563:
564: qa_core_pkg.dsql_add_text(') AND EXISTS ');
565:

Line 562: qa_core_pkg.dsql_add_text(' )');

558: qa_core_pkg.dsql_add_text(' ,');
559: qa_core_pkg.dsql_add_bind(l_col4);
560: qa_core_pkg.dsql_add_text(' ,');
561: qa_core_pkg.dsql_add_bind(l_col5);
562: qa_core_pkg.dsql_add_text(' )');
563:
564: qa_core_pkg.dsql_add_text(') AND EXISTS ');
565:
566:

Line 564: qa_core_pkg.dsql_add_text(') AND EXISTS ');

560: qa_core_pkg.dsql_add_text(' ,');
561: qa_core_pkg.dsql_add_bind(l_col5);
562: qa_core_pkg.dsql_add_text(' )');
563:
564: qa_core_pkg.dsql_add_text(') AND EXISTS ');
565:
566:
567: VALIDATE_ACTIONS_HELPER (ERROR_COL_NAME, COL_NAME,X_DATATYPE, X_CHAR_ID, X_PLAN_ID,
568: X_LV_LOOKUP_VALUE, X_LV_OTHER_VALUE,

Line 573: qa_core_pkg.dsql_execute;

569: X_HV_LOOKUP_VALUE, X_HV_OTHER_VALUE,
570: X_OP_CODE);
571:
572:
573: qa_core_pkg.dsql_execute;
574:
575:
576: END REJECT_INPUT;
577:

Line 583: -- Modified the logic to use qa_core_pkg.dsql method.

579:
580:
581:
582: -- Bug 4270911. CU2 SQL Literal fix. TD #23
583: -- Modified the logic to use qa_core_pkg.dsql method.
584: -- srhariha. Wed Apr 20 06:05:49 PDT 2005.
585:
586:
587: PROCEDURE VALIDATE_ACTIONS (COL_NAME VARCHAR2,