APPS.QA_CORE_PKG dependencies on QA_CHARS

Line 19: from qa_chars

15:
16: CURSOR c1 (P_ID NUMBER) IS
17:
18: select hardcoded_column
19: from qa_chars
20: where char_id = P_ID;
21:
22: CURSOR c2 (E_ID NUMBER) IS
23:

Line 25: from qa_chars

21:
22: CURSOR c2 (E_ID NUMBER) IS
23:
24: select developer_name
25: from qa_chars
26: where char_id = E_ID;
27:
28: CURSOR c3 (pl_id NUMBER,
29: ch_id NUMBER) IS

Line 39: -- Bug 3754667. We'll use the qa_chars_api and qa_plan_element_api

35: */
36:
37: BEGIN
38:
39: -- Bug 3754667. We'll use the qa_chars_api and qa_plan_element_api
40: -- functions to use the cache instead of the cursors that fetches
41: -- from the DB each time.
42: -- kabalakr. Wed Jul 28 03:06:38 PDT 2004.
43:

Line 49: hardcoded := qa_chars_api.hardcoded_column(ELEMENT_ID);

45: FETCH c1 INTO hardcoded;
46: CLOSE c1;
47: */
48:
49: hardcoded := qa_chars_api.hardcoded_column(ELEMENT_ID);
50:
51: if (hardcoded is not null) then
52:
53: /* OPEN c2 (ELEMENT_ID);

Line 58: name := qa_chars_api.developer_name(ELEMENT_ID);

54: FETCH c2 INTO name;
55: CLOSE c2;
56: */
57:
58: name := qa_chars_api.developer_name(ELEMENT_ID);
59:
60: else
61:
62: /* OPEN c3 (P_ID, ELEMENT_ID);

Line 90: from qa_chars

86:
87: BEGIN
88:
89: select char_id into ID
90: from qa_chars
91: where upper(Name) = upper(ELEMENT_NAME);
92:
93: return ID;
94:

Line 202: select datatype into atype from qa_chars where char_id = ELEMENT_ID;

198: atype number;
199:
200: BEGIN
201:
202: select datatype into atype from qa_chars where char_id = ELEMENT_ID;
203:
204: return atype;
205:
206: EXCEPTION when others then

Line 233: select datatype into atype from qa_chars where name = ELEMENT_NAME;

229: -- datatype 1 is Character
230: -- datatype 2 is Number
231: -- datatype 3 is Date
232:
233: select datatype into atype from qa_chars where name = ELEMENT_NAME;
234:
235: return atype;
236:
237: EXCEPTION when others then