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_SS_LOV_API dependencies on QA_PLAN_CHARS

Line 5: TYPE qa_plan_chars_table IS TABLE OF qa_plan_chars%ROWTYPE

1: PACKAGE BODY qa_ss_lov_api AS
2: /* $Header: qltsslob.plb 120.16.12010000.4 2008/10/17 08:05:57 pdube ship $ */
3:
4:
5: TYPE qa_plan_chars_table IS TABLE OF qa_plan_chars%ROWTYPE
6: INDEX BY BINARY_INTEGER;
7:
8: --
9: -- Package Variables: These will be populated at run time

Line 12: x_qa_plan_chars_array qa_plan_chars_table;

8: --
9: -- Package Variables: These will be populated at run time
10: --
11:
12: x_qa_plan_chars_array qa_plan_chars_table;
13: g_bind_value_list_seperator CONSTANT VARCHAR2(3) := ',';
14:
15:
16: -- anagarwa Thu Aug 12 15:49:51 PDT 2004

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

120: i := mod(plan_id * qa_ss_const.max_elements + element_id,
121: 2147483647);
122:
123: LOOP
124: IF NOT x_qa_plan_chars_array.EXISTS(i) THEN
125: RETURN i;
126: END IF;
127:
128: IF x_qa_plan_chars_array(i).plan_id = plan_id AND

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

124: IF NOT x_qa_plan_chars_array.EXISTS(i) THEN
125: RETURN i;
126: END IF;
127:
128: IF x_qa_plan_chars_array(i).plan_id = plan_id AND
129: x_qa_plan_chars_array(i).char_id = element_id THEN
130: RETURN i;
131: END IF;
132:

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

125: RETURN i;
126: END IF;
127:
128: IF x_qa_plan_chars_array(i).plan_id = plan_id AND
129: x_qa_plan_chars_array(i).char_id = element_id THEN
130: RETURN i;
131: END IF;
132:
133: i := mod(i + 1, 2147483647);

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

135:
136: END plan_element_index;
137:
138:
139: FUNCTION exists_qa_plan_chars(plan_id IN NUMBER, element_id IN NUMBER)
140: RETURN BOOLEAN IS
141: BEGIN
142:
143: RETURN x_qa_plan_chars_array.EXISTS(

Line 143: RETURN x_qa_plan_chars_array.EXISTS(

139: FUNCTION exists_qa_plan_chars(plan_id IN NUMBER, element_id IN NUMBER)
140: RETURN BOOLEAN IS
141: BEGIN
142:
143: RETURN x_qa_plan_chars_array.EXISTS(
144: plan_element_index(plan_id, element_id));
145: END exists_qa_plan_chars;
146:
147:

Line 145: END exists_qa_plan_chars;

141: BEGIN
142:
143: RETURN x_qa_plan_chars_array.EXISTS(
144: plan_element_index(plan_id, element_id));
145: END exists_qa_plan_chars;
146:
147:
148: PROCEDURE fetch_qa_plan_chars (plan_id IN NUMBER, element_id IN NUMBER) IS
149:

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

144: plan_element_index(plan_id, element_id));
145: END exists_qa_plan_chars;
146:
147:
148: PROCEDURE fetch_qa_plan_chars (plan_id IN NUMBER, element_id IN NUMBER) IS
149:
150: CURSOR C1 (p_id NUMBER, e_id NUMBER) IS
151: SELECT *
152: FROM qa_plan_chars

Line 152: FROM qa_plan_chars

148: PROCEDURE fetch_qa_plan_chars (plan_id IN NUMBER, element_id IN NUMBER) IS
149:
150: CURSOR C1 (p_id NUMBER, e_id NUMBER) IS
151: SELECT *
152: FROM qa_plan_chars
153: WHERE plan_id = p_id AND char_id = e_id;
154:
155: BEGIN
156:

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

153: WHERE plan_id = p_id AND char_id = e_id;
154:
155: BEGIN
156:
157: IF NOT exists_qa_plan_chars(plan_id, element_id) THEN
158:
159: OPEN C1(plan_id, element_id);
160: FETCH C1 INTO x_qa_plan_chars_array(
161: plan_element_index(plan_id, element_id));

Line 160: FETCH C1 INTO x_qa_plan_chars_array(

156:
157: IF NOT exists_qa_plan_chars(plan_id, element_id) THEN
158:
159: OPEN C1(plan_id, element_id);
160: FETCH C1 INTO x_qa_plan_chars_array(
161: plan_element_index(plan_id, element_id));
162:
163: CLOSE C1;
164: END IF;

Line 168: END fetch_qa_plan_chars;

164: END IF;
165:
166: EXCEPTION WHEN OTHERS THEN
167: RAISE;
168: END fetch_qa_plan_chars;
169:
170: --parent-child addition
171: FUNCTION qa_chars_values_exist (x_char_id IN NUMBER)
172: RETURN BOOLEAN IS

Line 199: fetch_qa_plan_chars(plan_id, element_id);

195: FUNCTION qpc_values_exist_flag(plan_id IN NUMBER,
196: element_id IN NUMBER) RETURN NUMBER IS
197: BEGIN
198:
199: fetch_qa_plan_chars(plan_id, element_id);
200: IF NOT exists_qa_plan_chars(plan_id, element_id) THEN
201: RETURN NULL;
202: END IF;
203:

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

196: element_id IN NUMBER) RETURN NUMBER IS
197: BEGIN
198:
199: fetch_qa_plan_chars(plan_id, element_id);
200: IF NOT exists_qa_plan_chars(plan_id, element_id) THEN
201: RETURN NULL;
202: END IF;
203:
204: RETURN x_qa_plan_chars_array(plan_element_index(plan_id, element_id)).

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

200: IF NOT exists_qa_plan_chars(plan_id, element_id) THEN
201: RETURN NULL;
202: END IF;
203:
204: RETURN x_qa_plan_chars_array(plan_element_index(plan_id, element_id)).
205: values_exist_flag;
206: END qpc_values_exist_flag;
207:
208:

Line 234: fetch_qa_plan_chars(plan_id, element_id);

230: RETURN BOOLEAN IS
231:
232: BEGIN
233:
234: fetch_qa_plan_chars(plan_id, element_id);
235: RETURN exists_qa_plan_chars(plan_id, element_id);
236:
237: END element_in_plan;
238:

Line 235: RETURN exists_qa_plan_chars(plan_id, element_id);

231:
232: BEGIN
233:
234: fetch_qa_plan_chars(plan_id, element_id);
235: RETURN exists_qa_plan_chars(plan_id, element_id);
236:
237: END element_in_plan;
238:
239: