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_SPEC_CHARS

Line 13: -- of QA spec elements instead of selecting * from QA_SPEC_CHARS

9:
10: -- Bug 3769260. shkalyan 30 July 2004.
11: -- Added this record type for storing relevant QA Spec elements.
12: -- This is needed as we need to select only specific columns
13: -- of QA spec elements instead of selecting * from QA_SPEC_CHARS
14:
15: TYPE qa_spec_char_rec IS RECORD
16: (
17: spec_id qa_spec_chars.spec_id%TYPE,

Line 17: spec_id qa_spec_chars.spec_id%TYPE,

13: -- of QA spec elements instead of selecting * from QA_SPEC_CHARS
14:
15: TYPE qa_spec_char_rec IS RECORD
16: (
17: spec_id qa_spec_chars.spec_id%TYPE,
18: char_id qa_spec_chars.char_id%TYPE,
19: enabled_flag qa_spec_chars.enabled_flag%TYPE,
20: target_value qa_spec_chars.target_value%TYPE,
21: upper_spec_limit qa_spec_chars.upper_spec_limit%TYPE,

Line 18: char_id qa_spec_chars.char_id%TYPE,

14:
15: TYPE qa_spec_char_rec IS RECORD
16: (
17: spec_id qa_spec_chars.spec_id%TYPE,
18: char_id qa_spec_chars.char_id%TYPE,
19: enabled_flag qa_spec_chars.enabled_flag%TYPE,
20: target_value qa_spec_chars.target_value%TYPE,
21: upper_spec_limit qa_spec_chars.upper_spec_limit%TYPE,
22: lower_spec_limit qa_spec_chars.lower_spec_limit%TYPE,

Line 19: enabled_flag qa_spec_chars.enabled_flag%TYPE,

15: TYPE qa_spec_char_rec IS RECORD
16: (
17: spec_id qa_spec_chars.spec_id%TYPE,
18: char_id qa_spec_chars.char_id%TYPE,
19: enabled_flag qa_spec_chars.enabled_flag%TYPE,
20: target_value qa_spec_chars.target_value%TYPE,
21: upper_spec_limit qa_spec_chars.upper_spec_limit%TYPE,
22: lower_spec_limit qa_spec_chars.lower_spec_limit%TYPE,
23: upper_reasonable_limit qa_spec_chars.upper_reasonable_limit%TYPE,

Line 20: target_value qa_spec_chars.target_value%TYPE,

16: (
17: spec_id qa_spec_chars.spec_id%TYPE,
18: char_id qa_spec_chars.char_id%TYPE,
19: enabled_flag qa_spec_chars.enabled_flag%TYPE,
20: target_value qa_spec_chars.target_value%TYPE,
21: upper_spec_limit qa_spec_chars.upper_spec_limit%TYPE,
22: lower_spec_limit qa_spec_chars.lower_spec_limit%TYPE,
23: upper_reasonable_limit qa_spec_chars.upper_reasonable_limit%TYPE,
24: lower_reasonable_limit qa_spec_chars.lower_reasonable_limit%TYPE,

Line 21: upper_spec_limit qa_spec_chars.upper_spec_limit%TYPE,

17: spec_id qa_spec_chars.spec_id%TYPE,
18: char_id qa_spec_chars.char_id%TYPE,
19: enabled_flag qa_spec_chars.enabled_flag%TYPE,
20: target_value qa_spec_chars.target_value%TYPE,
21: upper_spec_limit qa_spec_chars.upper_spec_limit%TYPE,
22: lower_spec_limit qa_spec_chars.lower_spec_limit%TYPE,
23: upper_reasonable_limit qa_spec_chars.upper_reasonable_limit%TYPE,
24: lower_reasonable_limit qa_spec_chars.lower_reasonable_limit%TYPE,
25: upper_user_defined_limit qa_spec_chars.upper_user_defined_limit%TYPE,

Line 22: lower_spec_limit qa_spec_chars.lower_spec_limit%TYPE,

18: char_id qa_spec_chars.char_id%TYPE,
19: enabled_flag qa_spec_chars.enabled_flag%TYPE,
20: target_value qa_spec_chars.target_value%TYPE,
21: upper_spec_limit qa_spec_chars.upper_spec_limit%TYPE,
22: lower_spec_limit qa_spec_chars.lower_spec_limit%TYPE,
23: upper_reasonable_limit qa_spec_chars.upper_reasonable_limit%TYPE,
24: lower_reasonable_limit qa_spec_chars.lower_reasonable_limit%TYPE,
25: upper_user_defined_limit qa_spec_chars.upper_user_defined_limit%TYPE,
26: lower_user_defined_limit qa_spec_chars.lower_user_defined_limit%TYPE,

Line 23: upper_reasonable_limit qa_spec_chars.upper_reasonable_limit%TYPE,

19: enabled_flag qa_spec_chars.enabled_flag%TYPE,
20: target_value qa_spec_chars.target_value%TYPE,
21: upper_spec_limit qa_spec_chars.upper_spec_limit%TYPE,
22: lower_spec_limit qa_spec_chars.lower_spec_limit%TYPE,
23: upper_reasonable_limit qa_spec_chars.upper_reasonable_limit%TYPE,
24: lower_reasonable_limit qa_spec_chars.lower_reasonable_limit%TYPE,
25: upper_user_defined_limit qa_spec_chars.upper_user_defined_limit%TYPE,
26: lower_user_defined_limit qa_spec_chars.lower_user_defined_limit%TYPE,
27: uom_code qa_spec_chars.uom_code%TYPE

Line 24: lower_reasonable_limit qa_spec_chars.lower_reasonable_limit%TYPE,

20: target_value qa_spec_chars.target_value%TYPE,
21: upper_spec_limit qa_spec_chars.upper_spec_limit%TYPE,
22: lower_spec_limit qa_spec_chars.lower_spec_limit%TYPE,
23: upper_reasonable_limit qa_spec_chars.upper_reasonable_limit%TYPE,
24: lower_reasonable_limit qa_spec_chars.lower_reasonable_limit%TYPE,
25: upper_user_defined_limit qa_spec_chars.upper_user_defined_limit%TYPE,
26: lower_user_defined_limit qa_spec_chars.lower_user_defined_limit%TYPE,
27: uom_code qa_spec_chars.uom_code%TYPE
28: );

Line 25: upper_user_defined_limit qa_spec_chars.upper_user_defined_limit%TYPE,

21: upper_spec_limit qa_spec_chars.upper_spec_limit%TYPE,
22: lower_spec_limit qa_spec_chars.lower_spec_limit%TYPE,
23: upper_reasonable_limit qa_spec_chars.upper_reasonable_limit%TYPE,
24: lower_reasonable_limit qa_spec_chars.lower_reasonable_limit%TYPE,
25: upper_user_defined_limit qa_spec_chars.upper_user_defined_limit%TYPE,
26: lower_user_defined_limit qa_spec_chars.lower_user_defined_limit%TYPE,
27: uom_code qa_spec_chars.uom_code%TYPE
28: );
29:

Line 26: lower_user_defined_limit qa_spec_chars.lower_user_defined_limit%TYPE,

22: lower_spec_limit qa_spec_chars.lower_spec_limit%TYPE,
23: upper_reasonable_limit qa_spec_chars.upper_reasonable_limit%TYPE,
24: lower_reasonable_limit qa_spec_chars.lower_reasonable_limit%TYPE,
25: upper_user_defined_limit qa_spec_chars.upper_user_defined_limit%TYPE,
26: lower_user_defined_limit qa_spec_chars.lower_user_defined_limit%TYPE,
27: uom_code qa_spec_chars.uom_code%TYPE
28: );
29:
30: TYPE qa_spec_chars_table IS TABLE OF qa_spec_char_rec

Line 27: uom_code qa_spec_chars.uom_code%TYPE

23: upper_reasonable_limit qa_spec_chars.upper_reasonable_limit%TYPE,
24: lower_reasonable_limit qa_spec_chars.lower_reasonable_limit%TYPE,
25: upper_user_defined_limit qa_spec_chars.upper_user_defined_limit%TYPE,
26: lower_user_defined_limit qa_spec_chars.lower_user_defined_limit%TYPE,
27: uom_code qa_spec_chars.uom_code%TYPE
28: );
29:
30: TYPE qa_spec_chars_table IS TABLE OF qa_spec_char_rec
31: INDEX BY BINARY_INTEGER;

Line 30: TYPE qa_spec_chars_table IS TABLE OF qa_spec_char_rec

26: lower_user_defined_limit qa_spec_chars.lower_user_defined_limit%TYPE,
27: uom_code qa_spec_chars.uom_code%TYPE
28: );
29:
30: TYPE qa_spec_chars_table IS TABLE OF qa_spec_char_rec
31: INDEX BY BINARY_INTEGER;
32:
33: --TYPE qa_spec_chars_table IS TABLE OF qa_spec_chars%ROWTYPE
34: -- INDEX BY BINARY_INTEGER;

Line 33: --TYPE qa_spec_chars_table IS TABLE OF qa_spec_chars%ROWTYPE

29:
30: TYPE qa_spec_chars_table IS TABLE OF qa_spec_char_rec
31: INDEX BY BINARY_INTEGER;
32:
33: --TYPE qa_spec_chars_table IS TABLE OF qa_spec_chars%ROWTYPE
34: -- INDEX BY BINARY_INTEGER;
35:
36: -- Bug 3769260. shkalyan 30 July 2004.
37: -- Added this record type for storing relevant QA Plan elements.

Line 95: x_qa_spec_chars_array qa_spec_chars_table;

91: --
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

Line 171: IF NOT x_qa_spec_chars_array.EXISTS(i) THEN

167: i := mod(p_spec_id * qa_ss_const.max_elements + p_element_id,
168: 2147483647);
169:
170: LOOP
171: IF NOT x_qa_spec_chars_array.EXISTS(i) THEN
172: RETURN i;
173: END IF;
174:
175: IF x_qa_spec_chars_array(i).spec_id = p_spec_id AND

Line 175: IF x_qa_spec_chars_array(i).spec_id = p_spec_id AND

171: IF NOT x_qa_spec_chars_array.EXISTS(i) THEN
172: RETURN i;
173: END IF;
174:
175: IF x_qa_spec_chars_array(i).spec_id = p_spec_id AND
176: x_qa_spec_chars_array(i).char_id = p_element_id THEN
177: RETURN i;
178: END IF;
179:

Line 176: x_qa_spec_chars_array(i).char_id = p_element_id THEN

172: RETURN i;
173: END IF;
174:
175: IF x_qa_spec_chars_array(i).spec_id = p_spec_id AND
176: x_qa_spec_chars_array(i).char_id = p_element_id THEN
177: RETURN i;
178: END IF;
179:
180: i := mod(i + 1, 2147483647);

Line 186: FUNCTION exists_qa_spec_chars(spec_id IN NUMBER, element_id IN NUMBER)

182:
183: END spec_element_index;
184:
185:
186: FUNCTION exists_qa_spec_chars(spec_id IN NUMBER, element_id IN NUMBER)
187: RETURN BOOLEAN IS
188: BEGIN
189: RETURN x_qa_spec_chars_array.EXISTS(
190: spec_element_index(spec_id, element_id));

Line 189: RETURN x_qa_spec_chars_array.EXISTS(

185:
186: FUNCTION exists_qa_spec_chars(spec_id IN NUMBER, element_id IN NUMBER)
187: RETURN BOOLEAN IS
188: BEGIN
189: RETURN x_qa_spec_chars_array.EXISTS(
190: spec_element_index(spec_id, element_id));
191: END exists_qa_spec_chars;
192:
193:

Line 191: END exists_qa_spec_chars;

187: RETURN BOOLEAN IS
188: BEGIN
189: RETURN x_qa_spec_chars_array.EXISTS(
190: spec_element_index(spec_id, element_id));
191: END exists_qa_spec_chars;
192:
193:
194: --
195: -- See Bug 2624112

Line 202: PROCEDURE fetch_qa_spec_chars (spec_id IN NUMBER, element_id IN NUMBER) IS

198: --
199: -- rkunchal
200: --
201:
202: PROCEDURE fetch_qa_spec_chars (spec_id IN NUMBER, element_id IN NUMBER) IS
203:
204: -- Bug 3769260. shkalyan 30 July 2004.
205: -- Modified cursor to select only specific columns
206: -- of QA spec elements instead of selecting * from QA_SPEC_CHARS

Line 206: -- of QA spec elements instead of selecting * from QA_SPEC_CHARS

202: PROCEDURE fetch_qa_spec_chars (spec_id IN NUMBER, element_id IN NUMBER) IS
203:
204: -- Bug 3769260. shkalyan 30 July 2004.
205: -- Modified cursor to select only specific columns
206: -- of QA spec elements instead of selecting * from QA_SPEC_CHARS
207:
208: CURSOR C1 (s_id NUMBER, e_id NUMBER) IS
209: SELECT QSC.spec_id,
210: QSC.char_id,

Line 220: FROM qa_spec_chars QSC,

216: QSC.lower_reasonable_limit,
217: QSC.upper_user_defined_limit,
218: QSC.lower_user_defined_limit,
219: QSC.uom_code
220: FROM qa_spec_chars QSC,
221: qa_specs QS
222: WHERE QSC.char_id = e_id
223: AND QSC.spec_id = QS.common_spec_id
224: AND QS.spec_id = s_id;

Line 228: IF NOT exists_qa_spec_chars(spec_id, element_id) THEN

224: AND QS.spec_id = s_id;
225:
226: BEGIN
227:
228: IF NOT exists_qa_spec_chars(spec_id, element_id) THEN
229: OPEN C1(spec_id, element_id);
230:
231: FETCH C1 INTO x_qa_spec_chars_array(
232: spec_element_index(spec_id, element_id));

Line 231: FETCH C1 INTO x_qa_spec_chars_array(

227:
228: IF NOT exists_qa_spec_chars(spec_id, element_id) THEN
229: OPEN C1(spec_id, element_id);
230:
231: FETCH C1 INTO x_qa_spec_chars_array(
232: spec_element_index(spec_id, element_id));
233: CLOSE C1;
234: END IF;
235:

Line 236: END fetch_qa_spec_chars;

232: spec_element_index(spec_id, element_id));
233: CLOSE C1;
234: END IF;
235:
236: END fetch_qa_spec_chars;
237:
238: -- Bug 3769260. shkalyan 30 July 2004.
239: -- Added this procedure to fetch all the elements of a specifications
240: -- The reason for introducing this procedure is to reduce the number of

Line 241: -- hits on the QA_SPEC_CHARS.

237:
238: -- Bug 3769260. shkalyan 30 July 2004.
239: -- Added this procedure to fetch all the elements of a specifications
240: -- The reason for introducing this procedure is to reduce the number of
241: -- hits on the QA_SPEC_CHARS.
242: -- Callers will use this procedure to pre-fetch all the Spec elements
243: -- to the cache if all the elements of a Spec would be accessed.
244:
245: PROCEDURE fetch_qa_spec_chars (spec_id IN NUMBER) IS

Line 245: PROCEDURE fetch_qa_spec_chars (spec_id IN NUMBER) IS

241: -- hits on the QA_SPEC_CHARS.
242: -- Callers will use this procedure to pre-fetch all the Spec elements
243: -- to the cache if all the elements of a Spec would be accessed.
244:
245: PROCEDURE fetch_qa_spec_chars (spec_id IN NUMBER) IS
246:
247: CURSOR C1 (s_id NUMBER) IS
248: SELECT QSC.spec_id,
249: QSC.char_id,

Line 259: FROM qa_spec_chars QSC,

255: QSC.lower_reasonable_limit,
256: QSC.upper_user_defined_limit,
257: QSC.lower_user_defined_limit,
258: QSC.uom_code
259: FROM qa_spec_chars QSC,
260: qa_specs QS
261: WHERE QSC.spec_id = QS.common_spec_id
262: AND QS.spec_id = s_id;
263:

Line 273: IF NOT exists_qa_spec_chars(spec_id, l_spec_char_rec.char_id) THEN

269: LOOP
270: FETCH C1 INTO l_spec_char_rec;
271: EXIT WHEN C1%NOTFOUND;
272:
273: IF NOT exists_qa_spec_chars(spec_id, l_spec_char_rec.char_id) THEN
274: x_qa_spec_chars_array(spec_element_index(spec_id, l_spec_char_rec.char_id)) := l_spec_char_rec;
275: END IF;
276: END LOOP;
277: CLOSE C1;

Line 274: x_qa_spec_chars_array(spec_element_index(spec_id, l_spec_char_rec.char_id)) := l_spec_char_rec;

270: FETCH C1 INTO l_spec_char_rec;
271: EXIT WHEN C1%NOTFOUND;
272:
273: IF NOT exists_qa_spec_chars(spec_id, l_spec_char_rec.char_id) THEN
274: x_qa_spec_chars_array(spec_element_index(spec_id, l_spec_char_rec.char_id)) := l_spec_char_rec;
275: END IF;
276: END LOOP;
277: CLOSE C1;
278:

Line 279: END fetch_qa_spec_chars;

275: END IF;
276: END LOOP;
277: CLOSE C1;
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

Line 395: -- This is a qa_spec_chars inquiry API.

391:
392: END refetch_qa_plan_chars;
393:
394: --
395: -- This is a qa_spec_chars inquiry API.
396: --
397: FUNCTION qsc_lower_reasonable_limit(spec_id IN NUMBER,
398: element_id IN NUMBER) RETURN VARCHAR2 IS
399: BEGIN

Line 400: fetch_qa_spec_chars(spec_id, element_id);

396: --
397: FUNCTION qsc_lower_reasonable_limit(spec_id IN NUMBER,
398: element_id IN NUMBER) RETURN VARCHAR2 IS
399: BEGIN
400: fetch_qa_spec_chars(spec_id, element_id);
401: IF NOT exists_qa_spec_chars(spec_id, element_id) THEN
402: RETURN NULL;
403: END IF;
404: RETURN x_qa_spec_chars_array(spec_element_index(spec_id, element_id)).

Line 401: IF NOT exists_qa_spec_chars(spec_id, element_id) THEN

397: FUNCTION qsc_lower_reasonable_limit(spec_id IN NUMBER,
398: element_id IN NUMBER) RETURN VARCHAR2 IS
399: BEGIN
400: fetch_qa_spec_chars(spec_id, element_id);
401: IF NOT exists_qa_spec_chars(spec_id, element_id) THEN
402: RETURN NULL;
403: END IF;
404: RETURN x_qa_spec_chars_array(spec_element_index(spec_id, element_id)).
405: lower_reasonable_limit;

Line 404: RETURN x_qa_spec_chars_array(spec_element_index(spec_id, element_id)).

400: fetch_qa_spec_chars(spec_id, element_id);
401: IF NOT exists_qa_spec_chars(spec_id, element_id) THEN
402: RETURN NULL;
403: END IF;
404: RETURN x_qa_spec_chars_array(spec_element_index(spec_id, element_id)).
405: lower_reasonable_limit;
406: END qsc_lower_reasonable_limit;
407:
408:

Line 410: -- This is a qa_spec_chars inquiry API.

406: END qsc_lower_reasonable_limit;
407:
408:
409: --
410: -- This is a qa_spec_chars inquiry API.
411: --
412: FUNCTION qsc_upper_reasonable_limit(spec_id IN NUMBER,
413: element_id IN NUMBER) RETURN VARCHAR2 IS
414: BEGIN

Line 415: fetch_qa_spec_chars(spec_id, element_id);

411: --
412: FUNCTION qsc_upper_reasonable_limit(spec_id IN NUMBER,
413: element_id IN NUMBER) RETURN VARCHAR2 IS
414: BEGIN
415: fetch_qa_spec_chars(spec_id, element_id);
416: IF NOT exists_qa_spec_chars(spec_id, element_id) THEN
417: RETURN NULL;
418: END IF;
419: RETURN x_qa_spec_chars_array(spec_element_index(spec_id, element_id)).

Line 416: IF NOT exists_qa_spec_chars(spec_id, element_id) THEN

412: FUNCTION qsc_upper_reasonable_limit(spec_id IN NUMBER,
413: element_id IN NUMBER) RETURN VARCHAR2 IS
414: BEGIN
415: fetch_qa_spec_chars(spec_id, element_id);
416: IF NOT exists_qa_spec_chars(spec_id, element_id) THEN
417: RETURN NULL;
418: END IF;
419: RETURN x_qa_spec_chars_array(spec_element_index(spec_id, element_id)).
420: upper_reasonable_limit;

Line 419: RETURN x_qa_spec_chars_array(spec_element_index(spec_id, element_id)).

415: fetch_qa_spec_chars(spec_id, element_id);
416: IF NOT exists_qa_spec_chars(spec_id, element_id) THEN
417: RETURN NULL;
418: END IF;
419: RETURN x_qa_spec_chars_array(spec_element_index(spec_id, element_id)).
420: upper_reasonable_limit;
421: END qsc_upper_reasonable_limit;
422:
423:

Line 707: from qa_spec_chars

703: lower_limit OUT NOCOPY VARCHAR2, upper_limit OUT NOCOPY VARCHAR2) IS
704:
705: CURSOR c IS
706: select uom_code
707: from qa_spec_chars
708: where spec_id = p_spec_id
709: and char_id = p_element_id;
710:
711: -- 12.1 QWB Usabiltiy Improvements

Line 721: l_spec_char_uom qa_spec_chars.uom_code%TYPE;

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);
725: l_decimal_precision := get_decimal_precision(p_plan_id, p_element_id);

Line 896: qa_spec_chars qsc,

892: qsc.LOWER_USER_DEFINED_LIMIT,
893: qsc.UOM_CODE
894:
895: from
896: qa_spec_chars qsc,
897: qa_specs qs
898:
899: where
900: qsc.spec_id = qs.common_spec_id and

Line 911: l_spec_char_uom qa_spec_chars.uom_code%TYPE;

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
915: OPEN c;

Line 988: fetch_qa_spec_chars(spec_id, element_id);

984: RETURN BOOLEAN IS
985:
986: BEGIN
987:
988: fetch_qa_spec_chars(spec_id, element_id);
989: RETURN exists_qa_spec_chars(spec_id, element_id);
990:
991: END element_in_spec;
992:

Line 989: RETURN exists_qa_spec_chars(spec_id, element_id);

985:
986: BEGIN
987:
988: fetch_qa_spec_chars(spec_id, element_id);
989: RETURN exists_qa_spec_chars(spec_id, element_id);
990:
991: END element_in_spec;
992:
993:

Line 4792: FROM qa_spec_chars

4788: lower_user_defined_limit,
4789: upper_user_defined_limit,
4790: lower_reasonable_limit,
4791: upper_reasonable_limit
4792: FROM qa_spec_chars
4793: WHERE spec_id = x_spec_id
4794: AND char_id = x_char_id;
4795:
4796: BEGIN