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 1238: qa_plan_chars

1234: information_flag,
1235: decimal_precision,
1236: uom_code
1237: FROM
1238: qa_plan_chars
1239: WHERE
1240: plan_id = p_copy_from_plan_id AND char_id NOT IN
1241: (SELECT char_id
1242: FROM qa_plan_chars

Line 1242: FROM qa_plan_chars

1238: qa_plan_chars
1239: WHERE
1240: plan_id = p_copy_from_plan_id AND char_id NOT IN
1241: (SELECT char_id
1242: FROM qa_plan_chars
1243: WHERE plan_id = p_copy_to_plan_id)
1244: ORDER BY prompt_sequence;
1245:
1246: l_prompt_sequence NUMBER;

Line 1249: l_result_column qa_plan_chars.result_column_name%TYPE;

1245:
1246: l_prompt_sequence NUMBER;
1247: l_char_sequence NUMBER;
1248: l_char_column_name VARCHAR2(30);
1249: l_result_column qa_plan_chars.result_column_name%TYPE;
1250:
1251: BEGIN
1252:
1253: l_prompt_sequence := get_next_sequence(p_copy_to_plan_id);

Line 1296: INSERT INTO qa_plan_chars(

1292: -- Bug 3726391. shkalyan 30 June 2004
1293: -- Removed insert of attribute_category,attribute1 to attribute15
1294: -- As per code review comments
1295:
1296: INSERT INTO qa_plan_chars(
1297: plan_id,
1298: char_id,
1299: last_update_date,
1300: last_updated_by,

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

1357: p_copy_to_plan_id IN NUMBER,
1358: p_copy_values_flag IN VARCHAR2,
1359: p_user_id IN NUMBER) IS
1360:
1361: TYPE prompt_tab IS TABLE OF qa_plan_chars.prompt%TYPE
1362: INDEX BY BINARY_INTEGER;
1363:
1364: TYPE default_tab IS TABLE OF qa_plan_chars.default_value%TYPE
1365: INDEX BY BINARY_INTEGER;

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

1360:
1361: TYPE prompt_tab IS TABLE OF qa_plan_chars.prompt%TYPE
1362: INDEX BY BINARY_INTEGER;
1363:
1364: TYPE default_tab IS TABLE OF qa_plan_chars.default_value%TYPE
1365: INDEX BY BINARY_INTEGER;
1366:
1367: TYPE result_tab IS TABLE OF qa_plan_chars.result_column_name%TYPE
1368: INDEX BY BINARY_INTEGER;

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

1363:
1364: TYPE default_tab IS TABLE OF qa_plan_chars.default_value%TYPE
1365: INDEX BY BINARY_INTEGER;
1366:
1367: TYPE result_tab IS TABLE OF qa_plan_chars.result_column_name%TYPE
1368: INDEX BY BINARY_INTEGER;
1369:
1370: char_ids number_tab;
1371: prompt_sequences number_tab;

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

1396: -- Bug 3726391. shkalyan 30 June 2004
1397: -- Removed insert of attribute_category,attribute1 to attribute15
1398: -- As per code review comments
1399:
1400: TYPE uom_code_tab IS TABLE OF qa_plan_chars.uom_code%TYPE
1401: INDEX BY BINARY_INTEGER;
1402:
1403: decimal_precisions number_tab;
1404: uom_codes uom_code_tab;

Line 1419: TYPE attr_cat_tab IS TABLE OF qa_plan_chars.attribute_category%TYPE

1415: -- bug 9562325
1416: -- Added new parameters to set the DFF attributes
1417: -- on the plan element level
1418: --
1419: TYPE attr_cat_tab IS TABLE OF qa_plan_chars.attribute_category%TYPE
1420: INDEX BY BINARY_INTEGER;
1421:
1422: TYPE attr_tab IS TABLE OF qa_plan_chars.attribute1%TYPE;
1423:

Line 1422: TYPE attr_tab IS TABLE OF qa_plan_chars.attribute1%TYPE;

1418: --
1419: TYPE attr_cat_tab IS TABLE OF qa_plan_chars.attribute_category%TYPE
1420: INDEX BY BINARY_INTEGER;
1421:
1422: TYPE attr_tab IS TABLE OF qa_plan_chars.attribute1%TYPE;
1423:
1424: attribute_categories attr_cat_tab;
1425: attribute1s attr_tab;
1426: attribute2s attr_tab;

Line 1534: qa_plan_chars

1530: attribute13s,
1531: attribute14s,
1532: attribute15s
1533: FROM
1534: qa_plan_chars
1535: WHERE
1536: plan_id = p_copy_from_plan_id AND char_id NOT IN
1537: (SELECT char_id
1538: FROM qa_plan_chars

Line 1538: FROM qa_plan_chars

1534: qa_plan_chars
1535: WHERE
1536: plan_id = p_copy_from_plan_id AND char_id NOT IN
1537: (SELECT char_id
1538: FROM qa_plan_chars
1539: WHERE plan_id = p_copy_to_plan_id)
1540: ORDER BY prompt_sequence;
1541:
1542: IF char_ids.COUNT = 0 THEN

Line 1624: INSERT INTO qa_plan_chars(

1620: -- Added new parameters to set the DFF attributes
1621: -- on the plan element level
1622: --
1623: FORALL i IN char_ids.FIRST .. char_ids.LAST
1624: INSERT INTO qa_plan_chars(
1625: plan_id,
1626: char_id,
1627: last_update_date,
1628: last_updated_by,

Line 1744: FROM qa_plan_chars

1740: short_code_id
1741: FROM qa_plan_char_value_lookups
1742: WHERE plan_id = p_copy_from_plan_id AND char_id NOT IN
1743: (SELECT char_id
1744: FROM qa_plan_chars
1745: WHERE plan_id = p_copy_to_plan_id);
1746:
1747: END copy_plan_element_values;
1748:

Line 1769: FROM qa_plan_chars

1765: high_value_other_id
1766: FROM qa_plan_char_action_triggers
1767: WHERE plan_id = p_copy_from_plan_id AND char_id NOT IN
1768: (SELECT char_id
1769: FROM qa_plan_chars
1770: WHERE plan_id = p_copy_to_plan_id)
1771: ORDER BY trigger_sequence;
1772:
1773: CURSOR action_cursor(x NUMBER) IS

Line 2317: l_result_column_name qa_plan_chars.result_column_name%TYPE;

2313: c ref_cursor;
2314:
2315: l_dummy NUMBER;
2316: l_found BOOLEAN;
2317: l_result_column_name qa_plan_chars.result_column_name%TYPE;
2318: l_sql_statement VARCHAR2(200);
2319:
2320: BEGIN
2321:

Line 2411: l_result_column qa_plan_chars.result_column_name%TYPE;

2407: END delete_plan_element_values;
2408:
2409:
2410: PROCEDURE delete_plan_element(p_plan_id IN NUMBER, p_element_id IN NUMBER) IS
2411: l_result_column qa_plan_chars.result_column_name%TYPE;
2412: BEGIN
2413: DELETE FROM qa_plan_chars
2414: WHERE plan_id = p_plan_id AND char_id = p_element_id
2415: RETURNING result_column_name

Line 2413: DELETE FROM qa_plan_chars

2409:
2410: PROCEDURE delete_plan_element(p_plan_id IN NUMBER, p_element_id IN NUMBER) IS
2411: l_result_column qa_plan_chars.result_column_name%TYPE;
2412: BEGIN
2413: DELETE FROM qa_plan_chars
2414: WHERE plan_id = p_plan_id AND char_id = p_element_id
2415: RETURNING result_column_name
2416: INTO l_result_column; -- needed for Bug 3926150
2417:

Line 2438: FROM qa_plan_chars qpc, qa_char_indexes qci

2434: -- is disrupted due to this action.
2435: --
2436: CURSOR c IS
2437: SELECT qpc.char_id
2438: FROM qa_plan_chars qpc, qa_char_indexes qci
2439: WHERE qpc.plan_id = p_plan_id AND
2440: qpc.char_id = qci.char_id AND
2441: qpc.result_column_name <> qci.default_result_column;
2442: BEGIN

Line 2452: DELETE FROM qa_plan_chars

2448: FOR r IN c LOOP
2449: disable_index_private(r.char_id);
2450: END LOOP;
2451:
2452: DELETE FROM qa_plan_chars
2453: WHERE plan_id = p_plan_id;
2454:
2455: END delete_plan_elements;
2456:

Line 3108: INSERT INTO qa_plan_chars(

3104: l_override_flag := x_override_flag;
3105: END IF;
3106: -- 12.1 Device Integration Project End.
3107:
3108: INSERT INTO qa_plan_chars(
3109: last_update_date,
3110: last_updated_by,
3111: creation_date,
3112: created_by,