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.QLTAUFLB dependencies on QA_PLAN_CHARS

Line 19: FROM qa_plan_chars

15: --
16:
17: CURSOR c_result_columns(p_plan_id NUMBER) IS
18: SELECT to_number(substr(result_column_name,10)) res_column_name
19: FROM qa_plan_chars
20: WHERE plan_id = p_plan_id AND
21: result_column_name like 'CHARACTER%'
22: ORDER BY to_number(substr(result_column_name,10));
23:

Line 89: qa_plan_chars qpc,

85: qpc.attribute14,
86: qpc.attribute15,
87: qpc.default_value_id
88: FROM
89: qa_plan_chars qpc,
90: qa_chars qc
91: WHERE
92: qpc.plan_id = p_from_plan_id AND
93: qpc.char_id IN (

Line 99: FROM qa_plan_chars

95: FROM qa_performance_temp
96: WHERE key = p_char_id_key) AND
97: qpc.char_id NOT IN (
98: SELECT char_id
99: FROM qa_plan_chars
100: WHERE plan_id = p_to_plan_id) AND
101: qpc.char_id = qc.char_id
102: ORDER BY
103: qpc.prompt_sequence;

Line 361: SELECT MAX(PROMPT_SEQUENCE) FROM QA_PLAN_CHARS

357: COLUMN_NUMBER NUMBER;
358: NEW_RESULT_COLUMN_NAME VARCHAR2(30);
359:
360: CURSOR C6 IS
361: SELECT MAX(PROMPT_SEQUENCE) FROM QA_PLAN_CHARS
362: WHERE PLAN_ID = X_PLAN_ID;
363:
364: NEW_PROMPT_SEQUENCE NUMBER;
365:

Line 392: AND CHAR_ID NOT IN (SELECT CHAR_ID FROM QA_PLAN_CHARS

388: DESCRIPTION,
389: SHORT_CODE_ID
390: FROM QA_PLAN_CHAR_VALUE_LOOKUPS
391: WHERE PLAN_ID = X_COPY_PLAN_ID
392: AND CHAR_ID NOT IN (SELECT CHAR_ID FROM QA_PLAN_CHARS
393: WHERE PLAN_ID = X_PLAN_ID);
394:
395: --
396: -- Bug# 5739330. These statements delete only the actions 25 and 26 and

Line 689: INSERT INTO QA_PLAN_CHARS (

685: -- Bug # 3329507. Modifying the query to include read_only,
686: -- Self Service and Information flags.
687: -- saugupta Fri, 26 Dec 2003 04:16:08 -0800 PDT
688:
689: INSERT INTO QA_PLAN_CHARS (
690: plan_id,
691: char_id,
692: last_update_date,
693: last_updated_by,

Line 839: INSERT INTO QA_PLAN_CHARS (

835: -- Bug # 3329507. Modifying the query to include read_only,
836: -- Self Service and Information flags.
837: -- saugupta Fri, 26 Dec 2003 04:16:08 -0800 PDT
838:
839: INSERT INTO QA_PLAN_CHARS (
840: plan_id,
841: char_id,
842: last_update_date,
843: last_updated_by,

Line 946: SELECT MAX(prompt_sequence) FROM qa_plan_chars

942: -- generic c_plan_chars cursor.
943: -- bso Thu Feb 2 15:03:41 PST 2006
944:
945: CURSOR c2 IS
946: SELECT MAX(prompt_sequence) FROM qa_plan_chars
947: WHERE plan_id = p_plan_id;
948:
949: -- Bug 4958757. SQL Repository Fix SQL ID: 15008349
950: -- The cursor c3 has been extracted to package level as

Line 1027: INSERT INTO qa_plan_chars(

1023: -- Bug # 3329507. Modifying the query to include read_only,
1024: -- Self Service and Information flags.
1025: -- saugupta Fri, 26 Dec 2003 04:16:08 -0800 PDT
1026:
1027: INSERT INTO qa_plan_chars(
1028: plan_id,
1029: char_id,
1030: last_update_date,
1031: last_updated_by,

Line 1126: SELECT MAX(prompt_sequence) FROM qa_plan_chars

1122:
1123: -- The following cursor is to find the Max value of Prompt Sequence.
1124:
1125: CURSOR prompt_cur IS
1126: SELECT MAX(prompt_sequence) FROM qa_plan_chars
1127: WHERE plan_id = p_plan_id;
1128:
1129: -- The following cursor is to find the hardcoded values of the two collection
1130: -- elements Asset Group and Asset Number.

Line 1151: DELETE FROM qa_plan_chars

1147: -- If any one of the collection Elements Asset Group or Asset Number
1148: -- is present in the Collection plan it is deleted. The deleted Element
1149: -- will be added with the missing element in the following Insert statement.
1150:
1151: DELETE FROM qa_plan_chars
1152: WHERE plan_id = p_plan_id
1153: AND char_id IN (l_asset_group_char_id,l_asset_number_char_id);
1154:
1155: FOR i IN element_cur LOOP

Line 1165: INSERT INTO qa_plan_chars(

1161: -- Bug # 3329507. Modifying the query to include read_only,
1162: -- Self Service and Information flags.
1163: -- saugupta Fri, 26 Dec 2003 04:16:08 -0800 PDT
1164:
1165: INSERT INTO qa_plan_chars(
1166: plan_id,
1167: char_id,
1168: last_update_date,
1169: last_updated_by,

Line 1210: SELECT MAX(prompt_sequence) FROM qa_plan_chars

1206: FUNCTION auto_fill_lpn (X_PLAN_ID NUMBER,
1207: X_USER_ID NUMBER
1208: ) RETURN NUMBER IS
1209: CURSOR prompt_cur IS
1210: SELECT MAX(prompt_sequence) FROM qa_plan_chars
1211: WHERE plan_id = x_plan_id;
1212:
1213: -- Cursor to find the hardcoded values of the LPN
1214:

Line 1234: INSERT INTO qa_plan_chars(

1230: FETCH lpn_cur INTO LPN_REC;
1231: CLOSE lpn_cur;
1232:
1233:
1234: INSERT INTO qa_plan_chars(
1235: plan_id,
1236: char_id,
1237: last_update_date,
1238: last_updated_by,

Line 1279: SELECT MAX(prompt_sequence) FROM qa_plan_chars

1275: X_COPY_PLAN_ID NUMBER,
1276: X_USER_ID NUMBER
1277: ) RETURN NUMBER IS
1278: CURSOR prompt_cur IS
1279: SELECT MAX(prompt_sequence) FROM qa_plan_chars
1280: WHERE plan_id = X_PLAN_ID;
1281:
1282: -- Cursor to find the hardcoded values of the eam
1283:

Line 1290: qa_plan_chars qpc1

1286: mandatory_flag
1287: FROM qa_chars
1288: WHERE char_id in (SELECT char_id
1289: FROM
1290: qa_plan_chars qpc1
1291: WHERE plan_id=X_COPY_PLAN_ID
1292: AND enabled_flag =1
1293: and not exists
1294: ( select 1

Line 1296: qa_plan_chars qpc2

1292: AND enabled_flag =1
1293: and not exists
1294: ( select 1
1295: from
1296: qa_plan_chars qpc2
1297: where qpc2.plan_id=X_PLAN_ID
1298: and qpc2.char_id = qpc1.char_id)
1299: )
1300: AND enabled_flag =1;

Line 1318: INSERT INTO qa_plan_chars(

1314:
1315: FOR i IN eam_cur LOOP
1316: PROMPT_SEQ := PROMPT_SEQ + 10;
1317:
1318: INSERT INTO qa_plan_chars(
1319: plan_id,
1320: char_id,
1321: last_update_date,
1322: last_updated_by,