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 236: FROM qa_plan_chars qpc,

232: qpc.attribute15,
233: qpc.default_value_id,
234: nvl(qpc.decimal_precision, qc.decimal_precision) decimal_precision ,
235: nvl(qpc.uom_code, qc.uom_code) uom_code
236: FROM qa_plan_chars qpc,
237: qa_chars qc
238: WHERE qpc.plan_id = X_COPY_PLAN_ID
239: AND qc.char_id = qpc.char_id
240: AND qc.char_id not in

Line 242: FROM qa_plan_chars

238: WHERE qpc.plan_id = X_COPY_PLAN_ID
239: AND qc.char_id = qpc.char_id
240: AND qc.char_id not in
241: (SELECT char_id
242: FROM qa_plan_chars
243: WHERE plan_id = X_PLAN_ID )
244: ORDER BY prompt_sequence;
245: /*
246: SELECT

Line 286: FROM QA_PLAN_CHARS_V

282: ATTRIBUTE15,
283: DEFAULT_VALUE_ID,
284: DECIMAL_PRECISION,
285: UOM_CODE
286: FROM QA_PLAN_CHARS_V
287: WHERE PLAN_ID = X_COPY_PLAN_ID
288: AND CHAR_ID NOT IN (SELECT CHAR_ID FROM QA_PLAN_CHARS
289: WHERE PLAN_ID = X_PLAN_ID)
290: ORDER BY PROMPT_SEQUENCE;

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

284: DECIMAL_PRECISION,
285: UOM_CODE
286: FROM QA_PLAN_CHARS_V
287: WHERE PLAN_ID = X_COPY_PLAN_ID
288: AND CHAR_ID NOT IN (SELECT CHAR_ID FROM QA_PLAN_CHARS
289: WHERE PLAN_ID = X_PLAN_ID)
290: ORDER BY PROMPT_SEQUENCE;
291: */
292:

Line 304: FROM QA_PLAN_CHARS QPC, QA_CHARS QC

300:
301: -- -- Bug 4958761. SQL Repository Fix SQL ID: 15008205
302: CURSOR C7 IS
303: SELECT TO_NUMBER(SUBSTR(QPC.RESULT_COLUMN_NAME,10,3)) RES_COLUMN_NAME
304: FROM QA_PLAN_CHARS QPC, QA_CHARS QC
305: WHERE PLAN_ID = X_PLAN_ID
306: AND qc.char_id = qpc.char_id
307: AND QC.HARDCODED_COLUMN IS NULL
308: AND QC.DATATYPE in (1,2,3,6)

Line 313: FROM QA_PLAN_CHARS_V

309: ORDER BY TO_NUMBER(SUBSTR(QPC.RESULT_COLUMN_NAME,10,3));
310:
311: /*
312: SELECT TO_NUMBER(SUBSTR(RESULT_COLUMN_NAME,10,3)) RES_COLUMN_NAME
313: FROM QA_PLAN_CHARS_V
314: WHERE PLAN_ID = X_PLAN_ID
315: AND HARDCODED_COLUMN IS NULL
316: AND DATATYPE in (1,2,3,6)
317: ORDER BY TO_NUMBER(SUBSTR(RESULT_COLUMN_NAME,10,3));

Line 335: FROM QA_PLAN_CHARS QPC, QA_CHARS QC

331:
332: -- Bug 4958761. SQL Repository Fix SQL ID: 15008222
333: CURSOR C8 IS
334: SELECT TO_NUMBER(SUBSTR(RESULT_COLUMN_NAME,8,3)) RES_COLUMN_NAME
335: FROM QA_PLAN_CHARS QPC, QA_CHARS QC
336: WHERE QPC.PLAN_ID = X_PLAN_ID
337: and qc.char_id = qpc.char_id
338: AND QC.HARDCODED_COLUMN IS NULL
339: AND QC.DATATYPE = 4

Line 343: FROM QA_PLAN_CHARS_V

339: AND QC.DATATYPE = 4
340: ORDER BY TO_NUMBER(SUBSTR(QPC.RESULT_COLUMN_NAME,8,3));
341: /*
342: SELECT TO_NUMBER(SUBSTR(RESULT_COLUMN_NAME,8,3)) RES_COLUMN_NAME
343: FROM QA_PLAN_CHARS_V
344: WHERE PLAN_ID = X_PLAN_ID
345: AND HARDCODED_COLUMN IS NULL
346: AND DATATYPE = 4
347: ORDER BY TO_NUMBER(SUBSTR(RESULT_COLUMN_NAME,8,3));

Line 354: SELECT MAX(PROMPT_SEQUENCE) FROM QA_PLAN_CHARS

350: comment_cols column_num;
351: j binary_integer;
352:
353: CURSOR C6 IS
354: SELECT MAX(PROMPT_SEQUENCE) FROM QA_PLAN_CHARS
355: WHERE PLAN_ID = X_PLAN_ID;
356:
357: NEW_PROMPT_SEQUENCE NUMBER;
358:

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

382: DESCRIPTION,
383: SHORT_CODE_ID
384: FROM QA_PLAN_CHAR_VALUE_LOOKUPS
385: WHERE PLAN_ID = X_COPY_PLAN_ID
386: AND CHAR_ID NOT IN (SELECT CHAR_ID FROM QA_PLAN_CHARS
387: WHERE PLAN_ID = X_PLAN_ID);
388:
389: OPEN C1;
390: LOOP

Line 887: INSERT INTO QA_PLAN_CHARS (

883: -- Tracking Bug : 3104827. Review Tracking Bug : 3148873
884: -- Modified the INSERT statement to include three new flags for collection plan elements
885: -- saugupta Mon Sep 22 23:38:15 PDT 2003
886:
887: INSERT INTO QA_PLAN_CHARS (
888: plan_id,
889: char_id,
890: last_update_date,
891: last_updated_by,