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

Line 63: FROM qa_plan_chars

59: -- SHKALYAN 24-JUL-2006
60: --
61: CURSOR c IS
62: SELECT to_number(SUBSTR(result_column_name, 10)) num
63: FROM qa_plan_chars
64: WHERE plan_id = p_plan_id AND
65: result_column_name LIKE 'CHARACTER%';
66:
67: BEGIN

Line 181: FROM qa_plan_chars

177: -- Check if an element already exists in a plan.
178: --
179: CURSOR c IS
180: SELECT 1
181: FROM qa_plan_chars
182: WHERE plan_id = p_plan_id AND
183: char_id = p_char_id;
184:
185: result BOOLEAN;

Line 209: FROM qa_plan_chars

205: RETURN BOOLEAN IS
206:
207: CURSOR c IS
208: SELECT 1
209: FROM qa_plan_chars
210: WHERE plan_id = p_plan_id AND
211: mandatory_flag = 1 AND
212: enabled_flag = 1;
213:

Line 234: FROM qa_plan_chars

230: p_prompt_sequence IN NUMBER) RETURN BOOLEAN IS
231:
232: CURSOR c IS
233: SELECT 1
234: FROM qa_plan_chars
235: WHERE plan_id = p_plan_id AND
236: prompt_sequence = p_prompt_sequence;
237:
238: l_dummy NUMBER;

Line 356: FROM qa_plan_chars

352: -- element is going to be added.
353: --
354: CURSOR c IS
355: SELECT max(prompt_sequence)
356: FROM qa_plan_chars
357: WHERE plan_id = p_plan_id;
358:
359: p NUMBER;
360:

Line 404: FROM qa_plan_chars

400: --
401:
402: CURSOR c IS
403: SELECT max(to_number(substr(result_column_name, 10)))
404: FROM qa_plan_chars
405: WHERE plan_id = p_plan_id AND
406: upper(result_column_name) like 'CHARACTER%';
407:
408: p NUMBER;

Line 409: result qa_plan_chars.result_column_name%TYPE;

405: WHERE plan_id = p_plan_id AND
406: upper(result_column_name) like 'CHARACTER%';
407:
408: p NUMBER;
409: result qa_plan_chars.result_column_name%TYPE;
410:
411: BEGIN
412:
413: OPEN c;

Line 464: l_default_column qa_plan_chars.result_column_name%TYPE;

460: --
461: FUNCTION suggest_result_column(p_plan_id NUMBER, p_char_id NUMBER)
462: RETURN VARCHAR2 IS
463:
464: l_default_column qa_plan_chars.result_column_name%TYPE;
465: dummy NUMBER;
466:
467: BEGIN
468: IF p_plan_id <> g_plan_id THEN

Line 537: -- Set dependency flags from qa_plan_chars:

533:
534:
535: PROCEDURE check_element_dependencies(p_plan_id IN NUMBER) IS
536:
537: -- Set dependency flags from qa_plan_chars:
538: -- 1 = characteristic exists on the QPlan
539: -- 2 = characteristic does NOT exist on the QPlan
540:
541: CURSOR c IS

Line 587: FROM qa_plan_chars

583: min(decode(char_id, 2147483553, 1, 2)) process_activity,
584: min(decode(char_id, 2147483552, 1, 2)) process_resources,
585: min(decode(char_id, 2147483551, 1, 2)) process_parameter_name
586: -- R12 OPM Deviations. Bug 4345503 End
587: FROM qa_plan_chars
588: WHERE plan_id = p_plan_id AND enabled_flag = 1;
589:
590: -- qa_plan_char flags
591:

Line 1201: qa_plan_chars

1197: information_flag,
1198: decimal_precision,
1199: uom_code
1200: FROM
1201: qa_plan_chars
1202: WHERE
1203: plan_id = p_copy_from_plan_id AND char_id NOT IN
1204: (SELECT char_id
1205: FROM qa_plan_chars

Line 1205: FROM qa_plan_chars

1201: qa_plan_chars
1202: WHERE
1203: plan_id = p_copy_from_plan_id AND char_id NOT IN
1204: (SELECT char_id
1205: FROM qa_plan_chars
1206: WHERE plan_id = p_copy_to_plan_id)
1207: ORDER BY prompt_sequence;
1208:
1209: l_prompt_sequence NUMBER;

Line 1212: l_result_column qa_plan_chars.result_column_name%TYPE;

1208:
1209: l_prompt_sequence NUMBER;
1210: l_char_sequence NUMBER;
1211: l_char_column_name VARCHAR2(30);
1212: l_result_column qa_plan_chars.result_column_name%TYPE;
1213:
1214: BEGIN
1215:
1216: l_prompt_sequence := get_next_sequence(p_copy_to_plan_id);

Line 1259: INSERT INTO qa_plan_chars(

1255: -- Bug 3726391. shkalyan 30 June 2004
1256: -- Removed insert of attribute_category,attribute1 to attribute15
1257: -- As per code review comments
1258:
1259: INSERT INTO qa_plan_chars(
1260: plan_id,
1261: char_id,
1262: last_update_date,
1263: last_updated_by,

Line 1324: TYPE prompt_tab IS TABLE OF qa_plan_chars.prompt%TYPE

1320: p_copy_to_plan_id IN NUMBER,
1321: p_copy_values_flag IN VARCHAR2,
1322: p_user_id IN NUMBER) IS
1323:
1324: TYPE prompt_tab IS TABLE OF qa_plan_chars.prompt%TYPE
1325: INDEX BY BINARY_INTEGER;
1326:
1327: TYPE default_tab IS TABLE OF qa_plan_chars.default_value%TYPE
1328: INDEX BY BINARY_INTEGER;

Line 1327: TYPE default_tab IS TABLE OF qa_plan_chars.default_value%TYPE

1323:
1324: TYPE prompt_tab IS TABLE OF qa_plan_chars.prompt%TYPE
1325: INDEX BY BINARY_INTEGER;
1326:
1327: TYPE default_tab IS TABLE OF qa_plan_chars.default_value%TYPE
1328: INDEX BY BINARY_INTEGER;
1329:
1330: TYPE result_tab IS TABLE OF qa_plan_chars.result_column_name%TYPE
1331: INDEX BY BINARY_INTEGER;

Line 1330: TYPE result_tab IS TABLE OF qa_plan_chars.result_column_name%TYPE

1326:
1327: TYPE default_tab IS TABLE OF qa_plan_chars.default_value%TYPE
1328: INDEX BY BINARY_INTEGER;
1329:
1330: TYPE result_tab IS TABLE OF qa_plan_chars.result_column_name%TYPE
1331: INDEX BY BINARY_INTEGER;
1332:
1333: char_ids number_tab;
1334: prompt_sequences number_tab;

Line 1363: TYPE uom_code_tab IS TABLE OF qa_plan_chars.uom_code%TYPE

1359: -- Bug 3726391. shkalyan 30 June 2004
1360: -- Removed insert of attribute_category,attribute1 to attribute15
1361: -- As per code review comments
1362:
1363: TYPE uom_code_tab IS TABLE OF qa_plan_chars.uom_code%TYPE
1364: INDEX BY BINARY_INTEGER;
1365:
1366: decimal_precisions number_tab;
1367: uom_codes uom_code_tab;

Line 1440: qa_plan_chars

1436: device_flags,
1437: device_ids,
1438: override_flags
1439: FROM
1440: qa_plan_chars
1441: WHERE
1442: plan_id = p_copy_from_plan_id AND char_id NOT IN
1443: (SELECT char_id
1444: FROM qa_plan_chars

Line 1444: FROM qa_plan_chars

1440: qa_plan_chars
1441: WHERE
1442: plan_id = p_copy_from_plan_id AND char_id NOT IN
1443: (SELECT char_id
1444: FROM qa_plan_chars
1445: WHERE plan_id = p_copy_to_plan_id)
1446: ORDER BY prompt_sequence;
1447:
1448: IF char_ids.COUNT = 0 THEN

Line 1526: INSERT INTO qa_plan_chars(

1522: -- device_flag and override_flags.
1523: -- bhsankar Mon Jan 7 22:00:17 PST 2008
1524:
1525: FORALL i IN char_ids.FIRST .. char_ids.LAST
1526: INSERT INTO qa_plan_chars(
1527: plan_id,
1528: char_id,
1529: last_update_date,
1530: last_updated_by,

Line 1614: FROM qa_plan_chars

1610: short_code_id
1611: FROM qa_plan_char_value_lookups
1612: WHERE plan_id = p_copy_from_plan_id AND char_id NOT IN
1613: (SELECT char_id
1614: FROM qa_plan_chars
1615: WHERE plan_id = p_copy_to_plan_id);
1616:
1617: END copy_plan_element_values;
1618:

Line 1639: FROM qa_plan_chars

1635: high_value_other_id
1636: FROM qa_plan_char_action_triggers
1637: WHERE plan_id = p_copy_from_plan_id AND char_id NOT IN
1638: (SELECT char_id
1639: FROM qa_plan_chars
1640: WHERE plan_id = p_copy_to_plan_id)
1641: ORDER BY trigger_sequence;
1642:
1643: CURSOR action_cursor(x NUMBER) IS

Line 2187: l_result_column_name qa_plan_chars.result_column_name%TYPE;

2183: c ref_cursor;
2184:
2185: l_dummy NUMBER;
2186: l_found BOOLEAN;
2187: l_result_column_name qa_plan_chars.result_column_name%TYPE;
2188: l_sql_statement VARCHAR2(200);
2189:
2190: BEGIN
2191:

Line 2281: l_result_column qa_plan_chars.result_column_name%TYPE;

2277: END delete_plan_element_values;
2278:
2279:
2280: PROCEDURE delete_plan_element(p_plan_id IN NUMBER, p_element_id IN NUMBER) IS
2281: l_result_column qa_plan_chars.result_column_name%TYPE;
2282: BEGIN
2283: DELETE FROM qa_plan_chars
2284: WHERE plan_id = p_plan_id AND char_id = p_element_id
2285: RETURNING result_column_name

Line 2283: DELETE FROM qa_plan_chars

2279:
2280: PROCEDURE delete_plan_element(p_plan_id IN NUMBER, p_element_id IN NUMBER) IS
2281: l_result_column qa_plan_chars.result_column_name%TYPE;
2282: BEGIN
2283: DELETE FROM qa_plan_chars
2284: WHERE plan_id = p_plan_id AND char_id = p_element_id
2285: RETURNING result_column_name
2286: INTO l_result_column; -- needed for Bug 3926150
2287:

Line 2308: FROM qa_plan_chars qpc, qa_char_indexes qci

2304: -- is disrupted due to this action.
2305: --
2306: CURSOR c IS
2307: SELECT qpc.char_id
2308: FROM qa_plan_chars qpc, qa_char_indexes qci
2309: WHERE qpc.plan_id = p_plan_id AND
2310: qpc.char_id = qci.char_id AND
2311: qpc.result_column_name <> qci.default_result_column;
2312: BEGIN

Line 2322: DELETE FROM qa_plan_chars

2318: FOR r IN c LOOP
2319: disable_index_private(r.char_id);
2320: END LOOP;
2321:
2322: DELETE FROM qa_plan_chars
2323: WHERE plan_id = p_plan_id;
2324:
2325: END delete_plan_elements;
2326:

Line 2900: INSERT INTO qa_plan_chars(

2896: l_override_flag := x_override_flag;
2897: END IF;
2898: -- 12.1 Device Integration Project End.
2899:
2900: INSERT INTO qa_plan_chars(
2901: last_update_date,
2902: last_updated_by,
2903: creation_date,
2904: created_by,