eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QA_PLAN_ELEMENT_API dependencies on QA_PLAN_CHARS

Line 39: -- of QA Plan elements instead of selecting * from QA_PLAN_CHARS

35:
36: -- Bug 3769260. shkalyan 30 July 2004.
37: -- Added this record type for storing relevant QA Plan elements.
38: -- This is needed as we need to select only specific columns
39: -- of QA Plan elements instead of selecting * from QA_PLAN_CHARS
40:
41: TYPE qa_plan_char_rec IS RECORD
42: (
43: plan_id qa_plan_chars.plan_id%TYPE,

Line 43: plan_id qa_plan_chars.plan_id%TYPE,

39: -- of QA Plan elements instead of selecting * from QA_PLAN_CHARS
40:
41: TYPE qa_plan_char_rec IS RECORD
42: (
43: plan_id qa_plan_chars.plan_id%TYPE,
44: char_id qa_plan_chars.char_id%TYPE,
45: prompt_sequence qa_plan_chars.prompt_sequence%TYPE,
46: prompt qa_plan_chars.prompt%TYPE,
47: enabled_flag qa_plan_chars.enabled_flag%TYPE,

Line 44: char_id qa_plan_chars.char_id%TYPE,

40:
41: TYPE qa_plan_char_rec IS RECORD
42: (
43: plan_id qa_plan_chars.plan_id%TYPE,
44: char_id qa_plan_chars.char_id%TYPE,
45: prompt_sequence qa_plan_chars.prompt_sequence%TYPE,
46: prompt qa_plan_chars.prompt%TYPE,
47: enabled_flag qa_plan_chars.enabled_flag%TYPE,
48: mandatory_flag qa_plan_chars.mandatory_flag%TYPE,

Line 45: prompt_sequence qa_plan_chars.prompt_sequence%TYPE,

41: TYPE qa_plan_char_rec IS RECORD
42: (
43: plan_id qa_plan_chars.plan_id%TYPE,
44: char_id qa_plan_chars.char_id%TYPE,
45: prompt_sequence qa_plan_chars.prompt_sequence%TYPE,
46: prompt qa_plan_chars.prompt%TYPE,
47: enabled_flag qa_plan_chars.enabled_flag%TYPE,
48: mandatory_flag qa_plan_chars.mandatory_flag%TYPE,
49: default_value qa_plan_chars.default_value%TYPE,

Line 46: prompt qa_plan_chars.prompt%TYPE,

42: (
43: plan_id qa_plan_chars.plan_id%TYPE,
44: char_id qa_plan_chars.char_id%TYPE,
45: prompt_sequence qa_plan_chars.prompt_sequence%TYPE,
46: prompt qa_plan_chars.prompt%TYPE,
47: enabled_flag qa_plan_chars.enabled_flag%TYPE,
48: mandatory_flag qa_plan_chars.mandatory_flag%TYPE,
49: default_value qa_plan_chars.default_value%TYPE,
50: default_value_id qa_plan_chars.default_value_id%TYPE,

Line 47: enabled_flag qa_plan_chars.enabled_flag%TYPE,

43: plan_id qa_plan_chars.plan_id%TYPE,
44: char_id qa_plan_chars.char_id%TYPE,
45: prompt_sequence qa_plan_chars.prompt_sequence%TYPE,
46: prompt qa_plan_chars.prompt%TYPE,
47: enabled_flag qa_plan_chars.enabled_flag%TYPE,
48: mandatory_flag qa_plan_chars.mandatory_flag%TYPE,
49: default_value qa_plan_chars.default_value%TYPE,
50: default_value_id qa_plan_chars.default_value_id%TYPE,
51: result_column_name qa_plan_chars.result_column_name%TYPE,

Line 48: mandatory_flag qa_plan_chars.mandatory_flag%TYPE,

44: char_id qa_plan_chars.char_id%TYPE,
45: prompt_sequence qa_plan_chars.prompt_sequence%TYPE,
46: prompt qa_plan_chars.prompt%TYPE,
47: enabled_flag qa_plan_chars.enabled_flag%TYPE,
48: mandatory_flag qa_plan_chars.mandatory_flag%TYPE,
49: default_value qa_plan_chars.default_value%TYPE,
50: default_value_id qa_plan_chars.default_value_id%TYPE,
51: result_column_name qa_plan_chars.result_column_name%TYPE,
52: values_exist_flag qa_plan_chars.values_exist_flag%TYPE,

Line 49: default_value qa_plan_chars.default_value%TYPE,

45: prompt_sequence qa_plan_chars.prompt_sequence%TYPE,
46: prompt qa_plan_chars.prompt%TYPE,
47: enabled_flag qa_plan_chars.enabled_flag%TYPE,
48: mandatory_flag qa_plan_chars.mandatory_flag%TYPE,
49: default_value qa_plan_chars.default_value%TYPE,
50: default_value_id qa_plan_chars.default_value_id%TYPE,
51: result_column_name qa_plan_chars.result_column_name%TYPE,
52: values_exist_flag qa_plan_chars.values_exist_flag%TYPE,
53: displayed_flag qa_plan_chars.displayed_flag%TYPE,

Line 50: default_value_id qa_plan_chars.default_value_id%TYPE,

46: prompt qa_plan_chars.prompt%TYPE,
47: enabled_flag qa_plan_chars.enabled_flag%TYPE,
48: mandatory_flag qa_plan_chars.mandatory_flag%TYPE,
49: default_value qa_plan_chars.default_value%TYPE,
50: default_value_id qa_plan_chars.default_value_id%TYPE,
51: result_column_name qa_plan_chars.result_column_name%TYPE,
52: values_exist_flag qa_plan_chars.values_exist_flag%TYPE,
53: displayed_flag qa_plan_chars.displayed_flag%TYPE,
54: decimal_precision qa_plan_chars.decimal_precision%TYPE,

Line 51: result_column_name qa_plan_chars.result_column_name%TYPE,

47: enabled_flag qa_plan_chars.enabled_flag%TYPE,
48: mandatory_flag qa_plan_chars.mandatory_flag%TYPE,
49: default_value qa_plan_chars.default_value%TYPE,
50: default_value_id qa_plan_chars.default_value_id%TYPE,
51: result_column_name qa_plan_chars.result_column_name%TYPE,
52: values_exist_flag qa_plan_chars.values_exist_flag%TYPE,
53: displayed_flag qa_plan_chars.displayed_flag%TYPE,
54: decimal_precision qa_plan_chars.decimal_precision%TYPE,
55: uom_code qa_plan_chars.uom_code%TYPE,

Line 52: values_exist_flag qa_plan_chars.values_exist_flag%TYPE,

48: mandatory_flag qa_plan_chars.mandatory_flag%TYPE,
49: default_value qa_plan_chars.default_value%TYPE,
50: default_value_id qa_plan_chars.default_value_id%TYPE,
51: result_column_name qa_plan_chars.result_column_name%TYPE,
52: values_exist_flag qa_plan_chars.values_exist_flag%TYPE,
53: displayed_flag qa_plan_chars.displayed_flag%TYPE,
54: decimal_precision qa_plan_chars.decimal_precision%TYPE,
55: uom_code qa_plan_chars.uom_code%TYPE,
56: read_only_flag qa_plan_chars.read_only_flag%TYPE,

Line 53: displayed_flag qa_plan_chars.displayed_flag%TYPE,

49: default_value qa_plan_chars.default_value%TYPE,
50: default_value_id qa_plan_chars.default_value_id%TYPE,
51: result_column_name qa_plan_chars.result_column_name%TYPE,
52: values_exist_flag qa_plan_chars.values_exist_flag%TYPE,
53: displayed_flag qa_plan_chars.displayed_flag%TYPE,
54: decimal_precision qa_plan_chars.decimal_precision%TYPE,
55: uom_code qa_plan_chars.uom_code%TYPE,
56: read_only_flag qa_plan_chars.read_only_flag%TYPE,
57: ss_poplist_flag qa_plan_chars.ss_poplist_flag%TYPE,

Line 54: decimal_precision qa_plan_chars.decimal_precision%TYPE,

50: default_value_id qa_plan_chars.default_value_id%TYPE,
51: result_column_name qa_plan_chars.result_column_name%TYPE,
52: values_exist_flag qa_plan_chars.values_exist_flag%TYPE,
53: displayed_flag qa_plan_chars.displayed_flag%TYPE,
54: decimal_precision qa_plan_chars.decimal_precision%TYPE,
55: uom_code qa_plan_chars.uom_code%TYPE,
56: read_only_flag qa_plan_chars.read_only_flag%TYPE,
57: ss_poplist_flag qa_plan_chars.ss_poplist_flag%TYPE,
58: information_flag qa_plan_chars.information_flag%TYPE

Line 55: uom_code qa_plan_chars.uom_code%TYPE,

51: result_column_name qa_plan_chars.result_column_name%TYPE,
52: values_exist_flag qa_plan_chars.values_exist_flag%TYPE,
53: displayed_flag qa_plan_chars.displayed_flag%TYPE,
54: decimal_precision qa_plan_chars.decimal_precision%TYPE,
55: uom_code qa_plan_chars.uom_code%TYPE,
56: read_only_flag qa_plan_chars.read_only_flag%TYPE,
57: ss_poplist_flag qa_plan_chars.ss_poplist_flag%TYPE,
58: information_flag qa_plan_chars.information_flag%TYPE
59: );

Line 56: read_only_flag qa_plan_chars.read_only_flag%TYPE,

52: values_exist_flag qa_plan_chars.values_exist_flag%TYPE,
53: displayed_flag qa_plan_chars.displayed_flag%TYPE,
54: decimal_precision qa_plan_chars.decimal_precision%TYPE,
55: uom_code qa_plan_chars.uom_code%TYPE,
56: read_only_flag qa_plan_chars.read_only_flag%TYPE,
57: ss_poplist_flag qa_plan_chars.ss_poplist_flag%TYPE,
58: information_flag qa_plan_chars.information_flag%TYPE
59: );
60:

Line 57: ss_poplist_flag qa_plan_chars.ss_poplist_flag%TYPE,

53: displayed_flag qa_plan_chars.displayed_flag%TYPE,
54: decimal_precision qa_plan_chars.decimal_precision%TYPE,
55: uom_code qa_plan_chars.uom_code%TYPE,
56: read_only_flag qa_plan_chars.read_only_flag%TYPE,
57: ss_poplist_flag qa_plan_chars.ss_poplist_flag%TYPE,
58: information_flag qa_plan_chars.information_flag%TYPE
59: );
60:
61: TYPE qa_plan_chars_table IS TABLE OF qa_plan_char_rec

Line 58: information_flag qa_plan_chars.information_flag%TYPE

54: decimal_precision qa_plan_chars.decimal_precision%TYPE,
55: uom_code qa_plan_chars.uom_code%TYPE,
56: read_only_flag qa_plan_chars.read_only_flag%TYPE,
57: ss_poplist_flag qa_plan_chars.ss_poplist_flag%TYPE,
58: information_flag qa_plan_chars.information_flag%TYPE
59: );
60:
61: TYPE qa_plan_chars_table IS TABLE OF qa_plan_char_rec
62: INDEX BY BINARY_INTEGER;

Line 61: TYPE qa_plan_chars_table IS TABLE OF qa_plan_char_rec

57: ss_poplist_flag qa_plan_chars.ss_poplist_flag%TYPE,
58: information_flag qa_plan_chars.information_flag%TYPE
59: );
60:
61: TYPE qa_plan_chars_table IS TABLE OF qa_plan_char_rec
62: INDEX BY BINARY_INTEGER;
63:
64: --12.1 QWB Usability Improvements project
65: Type string_list is table of varchar2(200) index by binary_integer;

Line 67: --TYPE qa_plan_chars_table IS TABLE OF qa_plan_chars%ROWTYPE

63:
64: --12.1 QWB Usability Improvements project
65: Type string_list is table of varchar2(200) index by binary_integer;
66:
67: --TYPE qa_plan_chars_table IS TABLE OF qa_plan_chars%ROWTYPE
68: -- INDEX BY BINARY_INTEGER;
69:
70: CURSOR cursor_qa_plan_chars(p_id NUMBER) IS
71: SELECT plan_id,

Line 70: CURSOR cursor_qa_plan_chars(p_id NUMBER) IS

66:
67: --TYPE qa_plan_chars_table IS TABLE OF qa_plan_chars%ROWTYPE
68: -- INDEX BY BINARY_INTEGER;
69:
70: CURSOR cursor_qa_plan_chars(p_id NUMBER) IS
71: SELECT plan_id,
72: char_id,
73: prompt_sequence,
74: prompt,

Line 87: FROM qa_plan_chars

83: uom_code,
84: read_only_flag,
85: ss_poplist_flag,
86: information_flag
87: FROM qa_plan_chars
88: WHERE plan_id = p_id
89: AND enabled_flag = 1;
90:
91: --

Line 96: x_qa_plan_chars_array qa_plan_chars_table;

92: -- Package Variables: These will be populated at run time
93: --
94:
95: x_qa_spec_chars_array qa_spec_chars_table;
96: x_qa_plan_chars_array qa_plan_chars_table;
97:
98: --
99: -- All the fetch_... procedures are auxiliary caching functions
100: -- called only by inquiry APIs that return the object's attributes.

Line 144: IF NOT x_qa_plan_chars_array.EXISTS(i) THEN

140: i := mod(plan_id * qa_ss_const.max_elements + element_id,
141: 2147483647);
142:
143: LOOP
144: IF NOT x_qa_plan_chars_array.EXISTS(i) THEN
145: RETURN i;
146: END IF;
147:
148: IF x_qa_plan_chars_array(i).plan_id = plan_id AND

Line 148: IF x_qa_plan_chars_array(i).plan_id = plan_id AND

144: IF NOT x_qa_plan_chars_array.EXISTS(i) THEN
145: RETURN i;
146: END IF;
147:
148: IF x_qa_plan_chars_array(i).plan_id = plan_id AND
149: x_qa_plan_chars_array(i).char_id = element_id THEN
150: RETURN i;
151: END IF;
152:

Line 149: x_qa_plan_chars_array(i).char_id = element_id THEN

145: RETURN i;
146: END IF;
147:
148: IF x_qa_plan_chars_array(i).plan_id = plan_id AND
149: x_qa_plan_chars_array(i).char_id = element_id THEN
150: RETURN i;
151: END IF;
152:
153: i := mod(i + 1, 2147483647);

Line 282: FUNCTION exists_qa_plan_chars(plan_id IN NUMBER, element_id IN NUMBER)

278:
279: END fetch_qa_spec_chars;
280:
281:
282: FUNCTION exists_qa_plan_chars(plan_id IN NUMBER, element_id IN NUMBER)
283: RETURN BOOLEAN IS
284: BEGIN
285:
286: RETURN x_qa_plan_chars_array.EXISTS(

Line 286: RETURN x_qa_plan_chars_array.EXISTS(

282: FUNCTION exists_qa_plan_chars(plan_id IN NUMBER, element_id IN NUMBER)
283: RETURN BOOLEAN IS
284: BEGIN
285:
286: RETURN x_qa_plan_chars_array.EXISTS(
287: plan_element_index(plan_id, element_id));
288: END exists_qa_plan_chars;
289:
290:

Line 288: END exists_qa_plan_chars;

284: BEGIN
285:
286: RETURN x_qa_plan_chars_array.EXISTS(
287: plan_element_index(plan_id, element_id));
288: END exists_qa_plan_chars;
289:
290:
291: PROCEDURE fetch_qa_plan_chars (plan_id IN NUMBER, element_id IN NUMBER) IS
292:

Line 291: PROCEDURE fetch_qa_plan_chars (plan_id IN NUMBER, element_id IN NUMBER) IS

287: plan_element_index(plan_id, element_id));
288: END exists_qa_plan_chars;
289:
290:
291: PROCEDURE fetch_qa_plan_chars (plan_id IN NUMBER, element_id IN NUMBER) IS
292:
293: -- Bug 3769260. shkalyan 30 July 2004.
294: -- Modified cursor to select only specific columns
295: -- of QA plan elements instead of selecting * from QA_PLAN_CHARS

Line 295: -- of QA plan elements instead of selecting * from QA_PLAN_CHARS

291: PROCEDURE fetch_qa_plan_chars (plan_id IN NUMBER, element_id IN NUMBER) IS
292:
293: -- Bug 3769260. shkalyan 30 July 2004.
294: -- Modified cursor to select only specific columns
295: -- of QA plan elements instead of selecting * from QA_PLAN_CHARS
296:
297: CURSOR C1 (p_id NUMBER, e_id NUMBER) IS
298: SELECT plan_id,
299: char_id,

Line 314: FROM qa_plan_chars

310: uom_code,
311: read_only_flag,
312: ss_poplist_flag,
313: information_flag
314: FROM qa_plan_chars
315: WHERE plan_id = p_id
316: AND char_id = e_id
317: AND enabled_flag = 1;
318:

Line 321: IF NOT exists_qa_plan_chars(plan_id, element_id) THEN

317: AND enabled_flag = 1;
318:
319: BEGIN
320:
321: IF NOT exists_qa_plan_chars(plan_id, element_id) THEN
322:
323: OPEN C1(plan_id, element_id);
324: FETCH C1 INTO x_qa_plan_chars_array(
325: plan_element_index(plan_id, element_id));

Line 324: FETCH C1 INTO x_qa_plan_chars_array(

320:
321: IF NOT exists_qa_plan_chars(plan_id, element_id) THEN
322:
323: OPEN C1(plan_id, element_id);
324: FETCH C1 INTO x_qa_plan_chars_array(
325: plan_element_index(plan_id, element_id));
326:
327: CLOSE C1;
328: END IF;

Line 332: END fetch_qa_plan_chars;

328: END IF;
329:
330: EXCEPTION WHEN OTHERS THEN
331: RAISE;
332: END fetch_qa_plan_chars;
333:
334: -- Bug 3769260. shkalyan 30 July 2004.
335: -- Added this procedure to fetch all the elements of a plan
336: -- The reason for introducing this procedure is to reduce the number of

Line 337: -- hits on the QA_PLAN_CHARS.

333:
334: -- Bug 3769260. shkalyan 30 July 2004.
335: -- Added this procedure to fetch all the elements of a plan
336: -- The reason for introducing this procedure is to reduce the number of
337: -- hits on the QA_PLAN_CHARS.
338: -- Callers will use this procedure to pre-fetch all the Plan elements
339: -- to the cache if all the elements of a plan would be accessed.
340:
341: PROCEDURE fetch_qa_plan_chars (plan_id IN NUMBER) IS

Line 341: PROCEDURE fetch_qa_plan_chars (plan_id IN NUMBER) IS

337: -- hits on the QA_PLAN_CHARS.
338: -- Callers will use this procedure to pre-fetch all the Plan elements
339: -- to the cache if all the elements of a plan would be accessed.
340:
341: PROCEDURE fetch_qa_plan_chars (plan_id IN NUMBER) IS
342: l_plan_char_rec qa_plan_char_rec;
343:
344: -- Bug 5182097. Cursor C1 is needed in the new proc
345: -- refetch_qa_plan_chars, so extracted out to package

Line 345: -- refetch_qa_plan_chars, so extracted out to package

341: PROCEDURE fetch_qa_plan_chars (plan_id IN NUMBER) IS
342: l_plan_char_rec qa_plan_char_rec;
343:
344: -- Bug 5182097. Cursor C1 is needed in the new proc
345: -- refetch_qa_plan_chars, so extracted out to package
346: -- level and renaming it to cursor_qa_plan_chars.
347: -- bso Mon May 1 16:59:56 PDT 2006
348:
349: BEGIN

Line 346: -- level and renaming it to cursor_qa_plan_chars.

342: l_plan_char_rec qa_plan_char_rec;
343:
344: -- Bug 5182097. Cursor C1 is needed in the new proc
345: -- refetch_qa_plan_chars, so extracted out to package
346: -- level and renaming it to cursor_qa_plan_chars.
347: -- bso Mon May 1 16:59:56 PDT 2006
348:
349: BEGIN
350:

Line 351: OPEN cursor_qa_plan_chars(plan_id);

347: -- bso Mon May 1 16:59:56 PDT 2006
348:
349: BEGIN
350:
351: OPEN cursor_qa_plan_chars(plan_id);
352: LOOP
353: FETCH cursor_qa_plan_chars INTO l_plan_char_rec;
354: EXIT WHEN cursor_qa_plan_chars%NOTFOUND;
355:

Line 353: FETCH cursor_qa_plan_chars INTO l_plan_char_rec;

349: BEGIN
350:
351: OPEN cursor_qa_plan_chars(plan_id);
352: LOOP
353: FETCH cursor_qa_plan_chars INTO l_plan_char_rec;
354: EXIT WHEN cursor_qa_plan_chars%NOTFOUND;
355:
356: IF NOT exists_qa_plan_chars(plan_id, l_plan_char_rec.char_id) THEN
357: x_qa_plan_chars_array(plan_element_index(plan_id, l_plan_char_rec.char_id)) := l_plan_char_rec;

Line 354: EXIT WHEN cursor_qa_plan_chars%NOTFOUND;

350:
351: OPEN cursor_qa_plan_chars(plan_id);
352: LOOP
353: FETCH cursor_qa_plan_chars INTO l_plan_char_rec;
354: EXIT WHEN cursor_qa_plan_chars%NOTFOUND;
355:
356: IF NOT exists_qa_plan_chars(plan_id, l_plan_char_rec.char_id) THEN
357: x_qa_plan_chars_array(plan_element_index(plan_id, l_plan_char_rec.char_id)) := l_plan_char_rec;
358: END IF;

Line 356: IF NOT exists_qa_plan_chars(plan_id, l_plan_char_rec.char_id) THEN

352: LOOP
353: FETCH cursor_qa_plan_chars INTO l_plan_char_rec;
354: EXIT WHEN cursor_qa_plan_chars%NOTFOUND;
355:
356: IF NOT exists_qa_plan_chars(plan_id, l_plan_char_rec.char_id) THEN
357: x_qa_plan_chars_array(plan_element_index(plan_id, l_plan_char_rec.char_id)) := l_plan_char_rec;
358: END IF;
359: END LOOP;
360: CLOSE cursor_qa_plan_chars;

Line 357: x_qa_plan_chars_array(plan_element_index(plan_id, l_plan_char_rec.char_id)) := l_plan_char_rec;

353: FETCH cursor_qa_plan_chars INTO l_plan_char_rec;
354: EXIT WHEN cursor_qa_plan_chars%NOTFOUND;
355:
356: IF NOT exists_qa_plan_chars(plan_id, l_plan_char_rec.char_id) THEN
357: x_qa_plan_chars_array(plan_element_index(plan_id, l_plan_char_rec.char_id)) := l_plan_char_rec;
358: END IF;
359: END LOOP;
360: CLOSE cursor_qa_plan_chars;
361:

Line 360: CLOSE cursor_qa_plan_chars;

356: IF NOT exists_qa_plan_chars(plan_id, l_plan_char_rec.char_id) THEN
357: x_qa_plan_chars_array(plan_element_index(plan_id, l_plan_char_rec.char_id)) := l_plan_char_rec;
358: END IF;
359: END LOOP;
360: CLOSE cursor_qa_plan_chars;
361:
362: END fetch_qa_plan_chars;
363:
364:

Line 362: END fetch_qa_plan_chars;

358: END IF;
359: END LOOP;
360: CLOSE cursor_qa_plan_chars;
361:
362: END fetch_qa_plan_chars;
363:
364:
365: PROCEDURE refetch_qa_plan_chars(p_plan_id IN NUMBER) IS
366: --

Line 365: PROCEDURE refetch_qa_plan_chars(p_plan_id IN NUMBER) IS

361:
362: END fetch_qa_plan_chars;
363:
364:
365: PROCEDURE refetch_qa_plan_chars(p_plan_id IN NUMBER) IS
366: --
367: -- Bug 5182097. Need a procedure to repopulate qpc otherwise
368: -- some subtle changes in Setup Collection Plans are not immediately
369: -- reflected in QWB. Also need Map_in_demand to call this proc during

Line 372: -- The procedure is almost identical to fetch_qa_plan_chars except

368: -- some subtle changes in Setup Collection Plans are not immediately
369: -- reflected in QWB. Also need Map_in_demand to call this proc during
370: -- qwb execution.
371: --
372: -- The procedure is almost identical to fetch_qa_plan_chars except
373: -- it doesn't first check if the plan char exists. Fetching is
374: -- forced to avoid caching problem.
375: --
376: -- bso Mon May 1 17:01:45 PDT 2006

Line 382: OPEN cursor_qa_plan_chars(p_plan_id);

378: l_plan_char_rec qa_plan_char_rec;
379:
380: BEGIN
381:
382: OPEN cursor_qa_plan_chars(p_plan_id);
383: LOOP
384: FETCH cursor_qa_plan_chars INTO l_plan_char_rec;
385: EXIT WHEN cursor_qa_plan_chars%NOTFOUND;
386:

Line 384: FETCH cursor_qa_plan_chars INTO l_plan_char_rec;

380: BEGIN
381:
382: OPEN cursor_qa_plan_chars(p_plan_id);
383: LOOP
384: FETCH cursor_qa_plan_chars INTO l_plan_char_rec;
385: EXIT WHEN cursor_qa_plan_chars%NOTFOUND;
386:
387: x_qa_plan_chars_array(plan_element_index(p_plan_id,
388: l_plan_char_rec.char_id)) := l_plan_char_rec;

Line 385: EXIT WHEN cursor_qa_plan_chars%NOTFOUND;

381:
382: OPEN cursor_qa_plan_chars(p_plan_id);
383: LOOP
384: FETCH cursor_qa_plan_chars INTO l_plan_char_rec;
385: EXIT WHEN cursor_qa_plan_chars%NOTFOUND;
386:
387: x_qa_plan_chars_array(plan_element_index(p_plan_id,
388: l_plan_char_rec.char_id)) := l_plan_char_rec;
389: END LOOP;

Line 387: x_qa_plan_chars_array(plan_element_index(p_plan_id,

383: LOOP
384: FETCH cursor_qa_plan_chars INTO l_plan_char_rec;
385: EXIT WHEN cursor_qa_plan_chars%NOTFOUND;
386:
387: x_qa_plan_chars_array(plan_element_index(p_plan_id,
388: l_plan_char_rec.char_id)) := l_plan_char_rec;
389: END LOOP;
390: CLOSE cursor_qa_plan_chars;
391:

Line 390: CLOSE cursor_qa_plan_chars;

386:
387: x_qa_plan_chars_array(plan_element_index(p_plan_id,
388: l_plan_char_rec.char_id)) := l_plan_char_rec;
389: END LOOP;
390: CLOSE cursor_qa_plan_chars;
391:
392: END refetch_qa_plan_chars;
393:
394: --

Line 392: END refetch_qa_plan_chars;

388: l_plan_char_rec.char_id)) := l_plan_char_rec;
389: END LOOP;
390: CLOSE cursor_qa_plan_chars;
391:
392: END refetch_qa_plan_chars;
393:
394: --
395: -- This is a qa_spec_chars inquiry API.
396: --

Line 425: -- This is a qa_plan_chars inquiry API.

421: END qsc_upper_reasonable_limit;
422:
423:
424: --
425: -- This is a qa_plan_chars inquiry API.
426: --
427: FUNCTION qpc_enabled_flag(plan_id IN NUMBER,
428: element_id IN NUMBER) RETURN NUMBER IS
429: BEGIN

Line 430: fetch_qa_plan_chars(plan_id, element_id);

426: --
427: FUNCTION qpc_enabled_flag(plan_id IN NUMBER,
428: element_id IN NUMBER) RETURN NUMBER IS
429: BEGIN
430: fetch_qa_plan_chars(plan_id, element_id);
431: IF NOT exists_qa_plan_chars(plan_id, element_id) THEN
432: RETURN NULL;
433: END IF;
434: RETURN x_qa_plan_chars_array(plan_element_index(plan_id, element_id)).

Line 431: IF NOT exists_qa_plan_chars(plan_id, element_id) THEN

427: FUNCTION qpc_enabled_flag(plan_id IN NUMBER,
428: element_id IN NUMBER) RETURN NUMBER IS
429: BEGIN
430: fetch_qa_plan_chars(plan_id, element_id);
431: IF NOT exists_qa_plan_chars(plan_id, element_id) THEN
432: RETURN NULL;
433: END IF;
434: RETURN x_qa_plan_chars_array(plan_element_index(plan_id, element_id)).
435: enabled_flag;

Line 434: RETURN x_qa_plan_chars_array(plan_element_index(plan_id, element_id)).

430: fetch_qa_plan_chars(plan_id, element_id);
431: IF NOT exists_qa_plan_chars(plan_id, element_id) THEN
432: RETURN NULL;
433: END IF;
434: RETURN x_qa_plan_chars_array(plan_element_index(plan_id, element_id)).
435: enabled_flag;
436: END qpc_enabled_flag;
437:
438: --

Line 444: -- Decimal Precision is taken from qa_plan_chars

440: -- The decimal precision for a number type collection
441: -- element is to be configured at plan level.
442: -- rkunchal Wed Oct 16 05:32:33 PDT 2002
443: --
444: -- Decimal Precision is taken from qa_plan_chars
445: --
446:
447: --
448: -- This is a qa_plan_chars inquiry API.

Line 448: -- This is a qa_plan_chars inquiry API.

444: -- Decimal Precision is taken from qa_plan_chars
445: --
446:
447: --
448: -- This is a qa_plan_chars inquiry API.
449: --
450: FUNCTION qpc_decimal_precision(p_plan_id IN NUMBER,
451: p_element_id IN NUMBER) RETURN NUMBER IS
452: BEGIN

Line 454: fetch_qa_plan_chars(p_plan_id, p_element_id);

450: FUNCTION qpc_decimal_precision(p_plan_id IN NUMBER,
451: p_element_id IN NUMBER) RETURN NUMBER IS
452: BEGIN
453:
454: fetch_qa_plan_chars(p_plan_id, p_element_id);
455: IF NOT exists_qa_plan_chars(p_plan_id, p_element_id) THEN
456: RETURN NULL;
457: END IF;
458:

Line 455: IF NOT exists_qa_plan_chars(p_plan_id, p_element_id) THEN

451: p_element_id IN NUMBER) RETURN NUMBER IS
452: BEGIN
453:
454: fetch_qa_plan_chars(p_plan_id, p_element_id);
455: IF NOT exists_qa_plan_chars(p_plan_id, p_element_id) THEN
456: RETURN NULL;
457: END IF;
458:
459: RETURN x_qa_plan_chars_array(plan_element_index(p_plan_id, p_element_id)).

Line 459: RETURN x_qa_plan_chars_array(plan_element_index(p_plan_id, p_element_id)).

455: IF NOT exists_qa_plan_chars(p_plan_id, p_element_id) THEN
456: RETURN NULL;
457: END IF;
458:
459: RETURN x_qa_plan_chars_array(plan_element_index(p_plan_id, p_element_id)).
460: decimal_precision;
461:
462: END qpc_decimal_precision;
463:

Line 465: -- This is a qa_plan_chars inquiry API.

461:
462: END qpc_decimal_precision;
463:
464: --
465: -- This is a qa_plan_chars inquiry API.
466: --
467: FUNCTION qpc_mandatory_flag(plan_id IN NUMBER,
468: element_id IN NUMBER) RETURN NUMBER IS
469: BEGIN

Line 470: fetch_qa_plan_chars(plan_id, element_id);

466: --
467: FUNCTION qpc_mandatory_flag(plan_id IN NUMBER,
468: element_id IN NUMBER) RETURN NUMBER IS
469: BEGIN
470: fetch_qa_plan_chars(plan_id, element_id);
471: IF NOT exists_qa_plan_chars(plan_id, element_id) THEN
472: RETURN NULL;
473: END IF;
474: RETURN x_qa_plan_chars_array(plan_element_index(plan_id, element_id)).

Line 471: IF NOT exists_qa_plan_chars(plan_id, element_id) THEN

467: FUNCTION qpc_mandatory_flag(plan_id IN NUMBER,
468: element_id IN NUMBER) RETURN NUMBER IS
469: BEGIN
470: fetch_qa_plan_chars(plan_id, element_id);
471: IF NOT exists_qa_plan_chars(plan_id, element_id) THEN
472: RETURN NULL;
473: END IF;
474: RETURN x_qa_plan_chars_array(plan_element_index(plan_id, element_id)).
475: mandatory_flag;

Line 474: RETURN x_qa_plan_chars_array(plan_element_index(plan_id, element_id)).

470: fetch_qa_plan_chars(plan_id, element_id);
471: IF NOT exists_qa_plan_chars(plan_id, element_id) THEN
472: RETURN NULL;
473: END IF;
474: RETURN x_qa_plan_chars_array(plan_element_index(plan_id, element_id)).
475: mandatory_flag;
476: END qpc_mandatory_flag;
477:
478:

Line 479: -- New get functions added for the new columns in qa_plan_chars

475: mandatory_flag;
476: END qpc_mandatory_flag;
477:
478:
479: -- New get functions added for the new columns in qa_plan_chars
480: -- SSQR project
481:
482: FUNCTION qpc_displayed_flag(plan_id IN NUMBER,
483: element_id IN NUMBER) RETURN NUMBER IS

Line 485: fetch_qa_plan_chars(plan_id, element_id);

481:
482: FUNCTION qpc_displayed_flag(plan_id IN NUMBER,
483: element_id IN NUMBER) RETURN NUMBER IS
484: BEGIN
485: fetch_qa_plan_chars(plan_id, element_id);
486: IF NOT exists_qa_plan_chars(plan_id, element_id) THEN
487: RETURN NULL;
488: END IF;
489: RETURN x_qa_plan_chars_array(plan_element_index(plan_id, element_id)).

Line 486: IF NOT exists_qa_plan_chars(plan_id, element_id) THEN

482: FUNCTION qpc_displayed_flag(plan_id IN NUMBER,
483: element_id IN NUMBER) RETURN NUMBER IS
484: BEGIN
485: fetch_qa_plan_chars(plan_id, element_id);
486: IF NOT exists_qa_plan_chars(plan_id, element_id) THEN
487: RETURN NULL;
488: END IF;
489: RETURN x_qa_plan_chars_array(plan_element_index(plan_id, element_id)).
490: displayed_flag;

Line 489: RETURN x_qa_plan_chars_array(plan_element_index(plan_id, element_id)).

485: fetch_qa_plan_chars(plan_id, element_id);
486: IF NOT exists_qa_plan_chars(plan_id, element_id) THEN
487: RETURN NULL;
488: END IF;
489: RETURN x_qa_plan_chars_array(plan_element_index(plan_id, element_id)).
490: displayed_flag;
491: END qpc_displayed_flag;
492:
493:

Line 498: fetch_qa_plan_chars(plan_id, element_id);

494:
495: FUNCTION qpc_poplist_flag(plan_id IN NUMBER,
496: element_id IN NUMBER) RETURN NUMBER IS
497: BEGIN
498: fetch_qa_plan_chars(plan_id, element_id);
499: IF NOT exists_qa_plan_chars(plan_id, element_id) THEN
500: RETURN NULL;
501: END IF;
502: RETURN x_qa_plan_chars_array(plan_element_index(plan_id, element_id)).

Line 499: IF NOT exists_qa_plan_chars(plan_id, element_id) THEN

495: FUNCTION qpc_poplist_flag(plan_id IN NUMBER,
496: element_id IN NUMBER) RETURN NUMBER IS
497: BEGIN
498: fetch_qa_plan_chars(plan_id, element_id);
499: IF NOT exists_qa_plan_chars(plan_id, element_id) THEN
500: RETURN NULL;
501: END IF;
502: RETURN x_qa_plan_chars_array(plan_element_index(plan_id, element_id)).
503: ss_poplist_flag;

Line 502: RETURN x_qa_plan_chars_array(plan_element_index(plan_id, element_id)).

498: fetch_qa_plan_chars(plan_id, element_id);
499: IF NOT exists_qa_plan_chars(plan_id, element_id) THEN
500: RETURN NULL;
501: END IF;
502: RETURN x_qa_plan_chars_array(plan_element_index(plan_id, element_id)).
503: ss_poplist_flag;
504: END qpc_poplist_flag;
505:
506:

Line 511: fetch_qa_plan_chars(plan_id, element_id);

507:
508: FUNCTION qpc_read_only_flag(plan_id IN NUMBER,
509: element_id IN NUMBER) RETURN NUMBER IS
510: BEGIN
511: fetch_qa_plan_chars(plan_id, element_id);
512: IF NOT exists_qa_plan_chars(plan_id, element_id) THEN
513: RETURN NULL;
514: END IF;
515: RETURN x_qa_plan_chars_array(plan_element_index(plan_id, element_id)).

Line 512: IF NOT exists_qa_plan_chars(plan_id, element_id) THEN

508: FUNCTION qpc_read_only_flag(plan_id IN NUMBER,
509: element_id IN NUMBER) RETURN NUMBER IS
510: BEGIN
511: fetch_qa_plan_chars(plan_id, element_id);
512: IF NOT exists_qa_plan_chars(plan_id, element_id) THEN
513: RETURN NULL;
514: END IF;
515: RETURN x_qa_plan_chars_array(plan_element_index(plan_id, element_id)).
516: read_only_flag;

Line 515: RETURN x_qa_plan_chars_array(plan_element_index(plan_id, element_id)).

511: fetch_qa_plan_chars(plan_id, element_id);
512: IF NOT exists_qa_plan_chars(plan_id, element_id) THEN
513: RETURN NULL;
514: END IF;
515: RETURN x_qa_plan_chars_array(plan_element_index(plan_id, element_id)).
516: read_only_flag;
517: END qpc_read_only_flag;
518:
519: --

Line 520: -- This is a qa_plan_chars inquiry API.

516: read_only_flag;
517: END qpc_read_only_flag;
518:
519: --
520: -- This is a qa_plan_chars inquiry API.
521: --
522: FUNCTION qpc_values_exist_flag(plan_id IN NUMBER,
523: element_id IN NUMBER) RETURN NUMBER IS
524: BEGIN

Line 526: fetch_qa_plan_chars(plan_id, element_id);

522: FUNCTION qpc_values_exist_flag(plan_id IN NUMBER,
523: element_id IN NUMBER) RETURN NUMBER IS
524: BEGIN
525:
526: fetch_qa_plan_chars(plan_id, element_id);
527: IF NOT exists_qa_plan_chars(plan_id, element_id) THEN
528: RETURN NULL;
529: END IF;
530:

Line 527: IF NOT exists_qa_plan_chars(plan_id, element_id) THEN

523: element_id IN NUMBER) RETURN NUMBER IS
524: BEGIN
525:
526: fetch_qa_plan_chars(plan_id, element_id);
527: IF NOT exists_qa_plan_chars(plan_id, element_id) THEN
528: RETURN NULL;
529: END IF;
530:
531: RETURN x_qa_plan_chars_array(plan_element_index(plan_id, element_id)).

Line 531: RETURN x_qa_plan_chars_array(plan_element_index(plan_id, element_id)).

527: IF NOT exists_qa_plan_chars(plan_id, element_id) THEN
528: RETURN NULL;
529: END IF;
530:
531: RETURN x_qa_plan_chars_array(plan_element_index(plan_id, element_id)).
532: values_exist_flag;
533: END qpc_values_exist_flag;
534:
535:

Line 537: -- This is a qa_plan_chars inquiry API.

533: END qpc_values_exist_flag;
534:
535:
536: --
537: -- This is a qa_plan_chars inquiry API.
538: --
539: FUNCTION qpc_result_column_name (plan_id IN NUMBER,
540: element_id IN NUMBER) RETURN VARCHAR2 IS
541: BEGIN

Line 543: fetch_qa_plan_chars(plan_id, element_id);

539: FUNCTION qpc_result_column_name (plan_id IN NUMBER,
540: element_id IN NUMBER) RETURN VARCHAR2 IS
541: BEGIN
542:
543: fetch_qa_plan_chars(plan_id, element_id);
544: IF NOT exists_qa_plan_chars(plan_id, element_id) THEN
545: RETURN NULL;
546: END IF;
547:

Line 544: IF NOT exists_qa_plan_chars(plan_id, element_id) THEN

540: element_id IN NUMBER) RETURN VARCHAR2 IS
541: BEGIN
542:
543: fetch_qa_plan_chars(plan_id, element_id);
544: IF NOT exists_qa_plan_chars(plan_id, element_id) THEN
545: RETURN NULL;
546: END IF;
547:
548: RETURN x_qa_plan_chars_array(plan_element_index(plan_id, element_id)).

Line 548: RETURN x_qa_plan_chars_array(plan_element_index(plan_id, element_id)).

544: IF NOT exists_qa_plan_chars(plan_id, element_id) THEN
545: RETURN NULL;
546: END IF;
547:
548: RETURN x_qa_plan_chars_array(plan_element_index(plan_id, element_id)).
549: result_column_name;
550: END qpc_result_column_name;
551:
552: --

Line 553: -- This is a qa_plan_chars inquiry API.

549: result_column_name;
550: END qpc_result_column_name;
551:
552: --
553: -- This is a qa_plan_chars inquiry API.
554: --
555: FUNCTION get_prompt (plan_id IN NUMBER,
556: element_id IN NUMBER) RETURN VARCHAR2 IS
557: BEGIN

Line 559: fetch_qa_plan_chars(plan_id, element_id);

555: FUNCTION get_prompt (plan_id IN NUMBER,
556: element_id IN NUMBER) RETURN VARCHAR2 IS
557: BEGIN
558:
559: fetch_qa_plan_chars(plan_id, element_id);
560: IF NOT exists_qa_plan_chars(plan_id, element_id) THEN
561: RETURN NULL;
562: END IF;
563:

Line 560: IF NOT exists_qa_plan_chars(plan_id, element_id) THEN

556: element_id IN NUMBER) RETURN VARCHAR2 IS
557: BEGIN
558:
559: fetch_qa_plan_chars(plan_id, element_id);
560: IF NOT exists_qa_plan_chars(plan_id, element_id) THEN
561: RETURN NULL;
562: END IF;
563:
564: RETURN x_qa_plan_chars_array(plan_element_index(plan_id, element_id)).

Line 564: RETURN x_qa_plan_chars_array(plan_element_index(plan_id, element_id)).

560: IF NOT exists_qa_plan_chars(plan_id, element_id) THEN
561: RETURN NULL;
562: END IF;
563:
564: RETURN x_qa_plan_chars_array(plan_element_index(plan_id, element_id)).
565: prompt;
566: END get_prompt;
567:
568:

Line 570: -- This is a qa_plan_chars inquiry API.

566: END get_prompt;
567:
568:
569: --
570: -- This is a qa_plan_chars inquiry API.
571: --
572: FUNCTION get_uom_code (plan_id IN NUMBER,
573: element_id IN NUMBER) RETURN VARCHAR2 IS
574: BEGIN

Line 576: fetch_qa_plan_chars(plan_id, element_id);

572: FUNCTION get_uom_code (plan_id IN NUMBER,
573: element_id IN NUMBER) RETURN VARCHAR2 IS
574: BEGIN
575:
576: fetch_qa_plan_chars(plan_id, element_id);
577: IF NOT exists_qa_plan_chars(plan_id, element_id) THEN
578: RETURN NULL;
579: END IF;
580:

Line 577: IF NOT exists_qa_plan_chars(plan_id, element_id) THEN

573: element_id IN NUMBER) RETURN VARCHAR2 IS
574: BEGIN
575:
576: fetch_qa_plan_chars(plan_id, element_id);
577: IF NOT exists_qa_plan_chars(plan_id, element_id) THEN
578: RETURN NULL;
579: END IF;
580:
581: RETURN x_qa_plan_chars_array(plan_element_index(plan_id, element_id)).

Line 581: RETURN x_qa_plan_chars_array(plan_element_index(plan_id, element_id)).

577: IF NOT exists_qa_plan_chars(plan_id, element_id) THEN
578: RETURN NULL;
579: END IF;
580:
581: RETURN x_qa_plan_chars_array(plan_element_index(plan_id, element_id)).
582: uom_code;
583: END get_uom_code;
584:
585:

Line 587: -- This is a qa_plan_chars inquiry API.

583: END get_uom_code;
584:
585:
586: --
587: -- This is a qa_plan_chars inquiry API.
588: --
589: FUNCTION get_decimal_precision (plan_id IN NUMBER,
590: element_id IN NUMBER) RETURN VARCHAR2 IS
591: BEGIN

Line 593: fetch_qa_plan_chars(plan_id, element_id);

589: FUNCTION get_decimal_precision (plan_id IN NUMBER,
590: element_id IN NUMBER) RETURN VARCHAR2 IS
591: BEGIN
592:
593: fetch_qa_plan_chars(plan_id, element_id);
594: IF NOT exists_qa_plan_chars(plan_id, element_id) THEN
595: RETURN NULL;
596: END IF;
597:

Line 594: IF NOT exists_qa_plan_chars(plan_id, element_id) THEN

590: element_id IN NUMBER) RETURN VARCHAR2 IS
591: BEGIN
592:
593: fetch_qa_plan_chars(plan_id, element_id);
594: IF NOT exists_qa_plan_chars(plan_id, element_id) THEN
595: RETURN NULL;
596: END IF;
597:
598: RETURN x_qa_plan_chars_array(plan_element_index(plan_id, element_id)).

Line 598: RETURN x_qa_plan_chars_array(plan_element_index(plan_id, element_id)).

594: IF NOT exists_qa_plan_chars(plan_id, element_id) THEN
595: RETURN NULL;
596: END IF;
597:
598: RETURN x_qa_plan_chars_array(plan_element_index(plan_id, element_id)).
599: decimal_precision;
600: END get_decimal_precision;
601:
602:

Line 700: -- it is used for retrieving qa_plan_chars.uom_code for uom conversion

696:
697: -- BUG 3303285
698: -- ksoh Mon Dec 29 13:33:02 PST 2003
699: -- overloaded get_spec_limits with a version that takes in plan_id
700: -- it is used for retrieving qa_plan_chars.uom_code for uom conversion
701: PROCEDURE get_spec_limits (p_plan_id IN NUMBER, p_spec_id IN NUMBER,
702: p_element_id IN NUMBER,
703: lower_limit OUT NOCOPY VARCHAR2, upper_limit OUT NOCOPY VARCHAR2) IS
704:

Line 720: l_plan_char_uom qa_plan_chars.uom_code%TYPE;

716: from qa_chars
717: where char_id = p_element_id;
718:
719:
720: l_plan_char_uom qa_plan_chars.uom_code%TYPE;
721: l_spec_char_uom qa_spec_chars.uom_code%TYPE;
722: l_decimal_precision NUMBER;
723: BEGIN
724: l_plan_char_uom := get_uom_code(p_plan_id, p_element_id);

Line 882: qa_plan_chars qpc,

878: nvl(qpc.uom_code, qc.uom_code) PLAN_CHAR_UOM,
879: nvl(qpc.decimal_precision, qc.decimal_precision) DECIMAL_PRECISION
880: FROM
881: qa_chars qc,
882: qa_plan_chars qpc,
883: (select
884: qsc.CHAR_ID,
885: qsc.ENABLED_FLAG,
886: qsc.TARGET_VALUE,

Line 910: l_plan_char_uom qa_plan_chars.uom_code%TYPE;

906: qc.char_id = qpc.char_id AND
907: qc.char_id = QscQs.char_id (+) AND
908: qpc.char_id = p_element_id;
909:
910: l_plan_char_uom qa_plan_chars.uom_code%TYPE;
911: l_spec_char_uom qa_spec_chars.uom_code%TYPE;
912: l_decimal_precision NUMBER;
913:
914: BEGIN

Line 977: fetch_qa_plan_chars(plan_id, element_id);

973: RETURN BOOLEAN IS
974:
975: BEGIN
976:
977: fetch_qa_plan_chars(plan_id, element_id);
978: RETURN exists_qa_plan_chars(plan_id, element_id);
979:
980: END element_in_plan;
981:

Line 978: RETURN exists_qa_plan_chars(plan_id, element_id);

974:
975: BEGIN
976:
977: fetch_qa_plan_chars(plan_id, element_id);
978: RETURN exists_qa_plan_chars(plan_id, element_id);
979:
980: END element_in_plan;
981:
982:

Line 2514: -- from the QA_PLAN_CHARS table.

2510: -- element is to be configured at plan level.
2511: -- rkunchal Wed Oct 16 05:32:33 PDT 2002
2512: --
2513: -- New function to get the decimal precision for the element
2514: -- from the QA_PLAN_CHARS table.
2515: --
2516:
2517: FUNCTION decimal_precision (p_plan_id IN NUMBER, p_element_id IN NUMBER)
2518: RETURN NUMBER IS

Line 5937: select char_id from qa_plan_chars

5933:
5934: l_result_string VARCHAR2(32767);
5935:
5936: Cursor plan_chars_cur is
5937: select char_id from qa_plan_chars
5938: where plan_id = p_plan_id;
5939: BEGIN
5940: l_result_string := result_string;
5941:

Line 6033: FROM qa_plan_chars qpc

6029: -- ntungare
6030: --
6031: SELECT qpc.char_id bulk collect
6032: INTO hardcoded_char_tab
6033: FROM qa_plan_chars qpc
6034: WHERE qpc.plan_id = p_plan_id
6035: AND qpc.information_flag = 1
6036: ORDER BY prompt_sequence;
6037: