APPS.QLTCPPLB dependencies on QA_PLAN_CHARS

Line 39: CHAR_ID NOT IN (SELECT CHAR_ID FROM QA_PLAN_CHARS

35: LOW_VALUE_OTHER_ID,
36: HIGH_VALUE_OTHER_ID
37: FROM QA_PLAN_CHAR_ACTION_TRIGGERS
38: WHERE PLAN_ID = X_COPY_PLAN_ID AND
39: CHAR_ID NOT IN (SELECT CHAR_ID FROM QA_PLAN_CHARS
40: WHERE PLAN_ID = X_PLAN_ID)
41: ORDER BY TRIGGER_SEQUENCE,
42: PLAN_CHAR_ACTION_TRIGGER_ID;
43:

Line 228: FROM qa_plan_chars qpc,

224: qpc.attribute15,
225: qpc.default_value_id,
226: nvl(qpc.decimal_precision, qc.decimal_precision) decimal_precision ,
227: nvl(qpc.uom_code, qc.uom_code) uom_code
228: FROM qa_plan_chars qpc,
229: qa_chars qc
230: WHERE qpc.plan_id = X_COPY_PLAN_ID
231: AND qc.char_id = qpc.char_id
232: AND qc.char_id not in

Line 234: FROM qa_plan_chars

230: WHERE qpc.plan_id = X_COPY_PLAN_ID
231: AND qc.char_id = qpc.char_id
232: AND qc.char_id not in
233: (SELECT char_id
234: FROM qa_plan_chars
235: WHERE plan_id = X_PLAN_ID )
236: ORDER BY prompt_sequence;
237: /*
238: SELECT

Line 278: FROM QA_PLAN_CHARS_V

274: ATTRIBUTE15,
275: DEFAULT_VALUE_ID,
276: DECIMAL_PRECISION,
277: UOM_CODE
278: FROM QA_PLAN_CHARS_V
279: WHERE PLAN_ID = X_COPY_PLAN_ID
280: AND CHAR_ID NOT IN (SELECT CHAR_ID FROM QA_PLAN_CHARS
281: WHERE PLAN_ID = X_PLAN_ID)
282: ORDER BY PROMPT_SEQUENCE;

Line 280: AND CHAR_ID NOT IN (SELECT CHAR_ID FROM QA_PLAN_CHARS

276: DECIMAL_PRECISION,
277: UOM_CODE
278: FROM QA_PLAN_CHARS_V
279: WHERE PLAN_ID = X_COPY_PLAN_ID
280: AND CHAR_ID NOT IN (SELECT CHAR_ID FROM QA_PLAN_CHARS
281: WHERE PLAN_ID = X_PLAN_ID)
282: ORDER BY PROMPT_SEQUENCE;
283: */
284:

Line 296: FROM QA_PLAN_CHARS QPC, QA_CHARS QC

292:
293: -- -- Bug 4958761. SQL Repository Fix SQL ID: 15008205
294: CURSOR C7 IS
295: SELECT TO_NUMBER(SUBSTR(QPC.RESULT_COLUMN_NAME,10,3)) RES_COLUMN_NAME
296: FROM QA_PLAN_CHARS QPC, QA_CHARS QC
297: WHERE PLAN_ID = X_PLAN_ID
298: AND qc.char_id = qpc.char_id
299: AND QC.HARDCODED_COLUMN IS NULL
300: AND QC.DATATYPE in (1,2,3,6)

Line 305: FROM QA_PLAN_CHARS_V

301: ORDER BY TO_NUMBER(SUBSTR(QPC.RESULT_COLUMN_NAME,10,3));
302:
303: /*
304: SELECT TO_NUMBER(SUBSTR(RESULT_COLUMN_NAME,10,3)) RES_COLUMN_NAME
305: FROM QA_PLAN_CHARS_V
306: WHERE PLAN_ID = X_PLAN_ID
307: AND HARDCODED_COLUMN IS NULL
308: AND DATATYPE in (1,2,3,6)
309: ORDER BY TO_NUMBER(SUBSTR(RESULT_COLUMN_NAME,10,3));

Line 327: FROM QA_PLAN_CHARS QPC, QA_CHARS QC

323:
324: -- Bug 4958761. SQL Repository Fix SQL ID: 15008222
325: CURSOR C8 IS
326: SELECT TO_NUMBER(SUBSTR(RESULT_COLUMN_NAME,8,3)) RES_COLUMN_NAME
327: FROM QA_PLAN_CHARS QPC, QA_CHARS QC
328: WHERE QPC.PLAN_ID = X_PLAN_ID
329: and qc.char_id = qpc.char_id
330: AND QC.HARDCODED_COLUMN IS NULL
331: AND QC.DATATYPE = 4

Line 335: FROM QA_PLAN_CHARS_V

331: AND QC.DATATYPE = 4
332: ORDER BY TO_NUMBER(SUBSTR(QPC.RESULT_COLUMN_NAME,8,3));
333: /*
334: SELECT TO_NUMBER(SUBSTR(RESULT_COLUMN_NAME,8,3)) RES_COLUMN_NAME
335: FROM QA_PLAN_CHARS_V
336: WHERE PLAN_ID = X_PLAN_ID
337: AND HARDCODED_COLUMN IS NULL
338: AND DATATYPE = 4
339: ORDER BY TO_NUMBER(SUBSTR(RESULT_COLUMN_NAME,8,3));

Line 346: SELECT MAX(PROMPT_SEQUENCE) FROM QA_PLAN_CHARS

342: comment_cols column_num;
343: j binary_integer;
344:
345: CURSOR C6 IS
346: SELECT MAX(PROMPT_SEQUENCE) FROM QA_PLAN_CHARS
347: WHERE PLAN_ID = X_PLAN_ID;
348:
349: NEW_PROMPT_SEQUENCE NUMBER;
350:

Line 378: AND CHAR_ID NOT IN (SELECT CHAR_ID FROM QA_PLAN_CHARS

374: DESCRIPTION,
375: SHORT_CODE_ID
376: FROM QA_PLAN_CHAR_VALUE_LOOKUPS
377: WHERE PLAN_ID = X_COPY_PLAN_ID
378: AND CHAR_ID NOT IN (SELECT CHAR_ID FROM QA_PLAN_CHARS
379: WHERE PLAN_ID = X_PLAN_ID);
380:
381: OPEN C1;
382: LOOP

Line 871: INSERT INTO QA_PLAN_CHARS (

867: -- Tracking Bug : 3104827. Review Tracking Bug : 3148873
868: -- Modified the INSERT statement to include three new flags for collection plan elements
869: -- saugupta Mon Sep 22 23:38:15 PDT 2003
870:
871: INSERT INTO QA_PLAN_CHARS (
872: plan_id,
873: char_id,
874: last_update_date,
875: last_updated_by,