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.QLTNINRB dependencies on QA_RESULTS

Line 15: SELECT * from QA_RESULTS

11: -- See Bug 1293975.
12: -- bso Sun May 28 16:07:56 PDT 2000
13: --
14: CURSOR table_stuff(X_TXN_HEADER_ID NUMBER, X_COLLECTIOn_ID NUMBER) IS
15: SELECT * from QA_RESULTS
16: WHERE TXN_HEADER_ID = NVL (X_TXN_HEADER_ID, TXN_HEADER_ID )
17: AND Collection_id = NVL( X_COLLECTION_ID, Collection_id );
18: */
19:

Line 21: CURSOR qa_results_txn(x NUMBER) IS

17: AND Collection_id = NVL( X_COLLECTION_ID, Collection_id );
18: */
19:
20: -- See comments in INIT_CURSOR
21: CURSOR qa_results_txn(x NUMBER) IS
22: SELECT *
23: FROM qa_results
24: WHERE txn_header_id = x;
25:

Line 23: FROM qa_results

19:
20: -- See comments in INIT_CURSOR
21: CURSOR qa_results_txn(x NUMBER) IS
22: SELECT *
23: FROM qa_results
24: WHERE txn_header_id = x;
25:
26: CURSOR qa_results_col(x NUMBER) IS
27: SELECT *

Line 26: CURSOR qa_results_col(x NUMBER) IS

22: SELECT *
23: FROM qa_results
24: WHERE txn_header_id = x;
25:
26: CURSOR qa_results_col(x NUMBER) IS
27: SELECT *
28: FROM qa_results
29: WHERE collection_id = x;
30:

Line 28: FROM qa_results

24: WHERE txn_header_id = x;
25:
26: CURSOR qa_results_col(x NUMBER) IS
27: SELECT *
28: FROM qa_results
29: WHERE collection_id = x;
30:
31: -- Added for bug1843356. kabalakr
32: CURSOR qa_results_occ(planID NUMBER, col_id NUMBER, occ NUMBER) IS

Line 32: CURSOR qa_results_occ(planID NUMBER, col_id NUMBER, occ NUMBER) IS

28: FROM qa_results
29: WHERE collection_id = x;
30:
31: -- Added for bug1843356. kabalakr
32: CURSOR qa_results_occ(planID NUMBER, col_id NUMBER, occ NUMBER) IS
33: SELECT *
34: FROM qa_results
35: WHERE plan_id = planID
36: AND collection_id = col_id

Line 34: FROM qa_results

30:
31: -- Added for bug1843356. kabalakr
32: CURSOR qa_results_occ(planID NUMBER, col_id NUMBER, occ NUMBER) IS
33: SELECT *
34: FROM qa_results
35: WHERE plan_id = planID
36: AND collection_id = col_id
37: AND occurrence = occ;
38:

Line 39: table_rec qa_results%ROWTYPE;

35: WHERE plan_id = planID
36: AND collection_id = col_id
37: AND occurrence = occ;
38:
39: table_rec qa_results%ROWTYPE;
40:
41: --
42: -- g_column can be TXN_HEADER_ID or COLLECTION_ID
43: -- There is no default value. It will be init by init_cursor.

Line 73: -- qa_results based on either txn_header_id or collection_id

69: --
70: -- This is an interesting exclusive OR situation.
71: -- The user must pass x_txn_header_id xor x_collection_id
72: -- into INIT_CURSOR. Hence, we select records from
73: -- qa_results based on either txn_header_id or collection_id
74: -- column. (Required two new indexes for these).
75: --
76: -- The natural implementation for this exclusive OR selection
77: -- is to declare a ref cursor at the package level and initialize

Line 92: OPEN qa_results_occ(x_plan_id, x_collection_id, x_occurrence);

88: -- kabalakr 22 feb 02
89:
90: IF x_occurrence IS NOT NULL THEN
91: g_column := 'OCCURRENCE';
92: OPEN qa_results_occ(x_plan_id, x_collection_id, x_occurrence);
93: ELSIF x_txn_header_id IS NOT NULL THEN
94: g_column := 'TXN_HEADER_ID';
95: OPEN qa_results_txn(x_txn_header_id);
96: ELSE -- x_collection_id IS NOT NULL

Line 95: OPEN qa_results_txn(x_txn_header_id);

91: g_column := 'OCCURRENCE';
92: OPEN qa_results_occ(x_plan_id, x_collection_id, x_occurrence);
93: ELSIF x_txn_header_id IS NOT NULL THEN
94: g_column := 'TXN_HEADER_ID';
95: OPEN qa_results_txn(x_txn_header_id);
96: ELSE -- x_collection_id IS NOT NULL
97: g_column := 'COLLECTION_ID';
98: OPEN qa_results_col(x_collection_id);
99: END IF;

Line 98: OPEN qa_results_col(x_collection_id);

94: g_column := 'TXN_HEADER_ID';
95: OPEN qa_results_txn(x_txn_header_id);
96: ELSE -- x_collection_id IS NOT NULL
97: g_column := 'COLLECTION_ID';
98: OPEN qa_results_col(x_collection_id);
99: END IF;
100:
101: END INIT_CURSOR;
102:

Line 113: -- qa_results based on either txn_header_id or collection_id

109: --
110: -- This is an interesting exclusive OR situation.
111: -- The user must pass x_txn_header_id xor x_collection_id
112: -- into INIT_CURSOR. Hence, we select records from
113: -- qa_results based on either txn_header_id or collection_id
114: -- column.
115: -- bso Sun May 28 16:24:10 PDT 2000
116: --
117:

Line 122: FETCH qa_results_occ INTO table_rec;

118: -- Bug1843356. Added the first IF condition.
119: -- kabalakr 22 feb 02
120:
121: IF g_column = 'OCCURRENCE' THEN
122: FETCH qa_results_occ INTO table_rec;
123: RETURN qa_results_occ%FOUND;
124: ELSIF g_column = 'TXN_HEADER_ID' THEN
125: FETCH qa_results_txn INTO table_rec;
126: RETURN qa_results_txn%FOUND;

Line 123: RETURN qa_results_occ%FOUND;

119: -- kabalakr 22 feb 02
120:
121: IF g_column = 'OCCURRENCE' THEN
122: FETCH qa_results_occ INTO table_rec;
123: RETURN qa_results_occ%FOUND;
124: ELSIF g_column = 'TXN_HEADER_ID' THEN
125: FETCH qa_results_txn INTO table_rec;
126: RETURN qa_results_txn%FOUND;
127: ELSIF g_column = 'COLLECTION_ID' THEN

Line 125: FETCH qa_results_txn INTO table_rec;

121: IF g_column = 'OCCURRENCE' THEN
122: FETCH qa_results_occ INTO table_rec;
123: RETURN qa_results_occ%FOUND;
124: ELSIF g_column = 'TXN_HEADER_ID' THEN
125: FETCH qa_results_txn INTO table_rec;
126: RETURN qa_results_txn%FOUND;
127: ELSIF g_column = 'COLLECTION_ID' THEN
128: FETCH qa_results_col INTO table_rec;
129: RETURN qa_results_col%FOUND;

Line 126: RETURN qa_results_txn%FOUND;

122: FETCH qa_results_occ INTO table_rec;
123: RETURN qa_results_occ%FOUND;
124: ELSIF g_column = 'TXN_HEADER_ID' THEN
125: FETCH qa_results_txn INTO table_rec;
126: RETURN qa_results_txn%FOUND;
127: ELSIF g_column = 'COLLECTION_ID' THEN
128: FETCH qa_results_col INTO table_rec;
129: RETURN qa_results_col%FOUND;
130: END IF;

Line 128: FETCH qa_results_col INTO table_rec;

124: ELSIF g_column = 'TXN_HEADER_ID' THEN
125: FETCH qa_results_txn INTO table_rec;
126: RETURN qa_results_txn%FOUND;
127: ELSIF g_column = 'COLLECTION_ID' THEN
128: FETCH qa_results_col INTO table_rec;
129: RETURN qa_results_col%FOUND;
130: END IF;
131:
132: RETURN FALSE; -- just in case g_column is not set!

Line 129: RETURN qa_results_col%FOUND;

125: FETCH qa_results_txn INTO table_rec;
126: RETURN qa_results_txn%FOUND;
127: ELSIF g_column = 'COLLECTION_ID' THEN
128: FETCH qa_results_col INTO table_rec;
129: RETURN qa_results_col%FOUND;
130: END IF;
131:
132: RETURN FALSE; -- just in case g_column is not set!
133:

Line 890: -- QA_RESULTS table for ASO project

886: END IF;
887:
888: --
889: -- Included the following newly added columns in
890: -- QA_RESULTS table for ASO project
891: -- rkunchal Thu Jul 25 01:43:48 PDT 2002
892: --
893:
894: IF X_COL_NAME = 'CSI_INSTANCE_ID' THEN

Line 1117: CLOSE qa_results_occ;

1113: -- Bug 1843356. Added the IF condition below.
1114: -- kabalakr 22 feb 02
1115:
1116: IF g_column = 'OCCURRENCE' THEN
1117: CLOSE qa_results_occ;
1118: ELSIF g_column = 'TXN_HEADER_ID' THEN
1119: CLOSE qa_results_txn;
1120: ELSE -- g_column = 'COLLECTION_ID'
1121: CLOSE qa_results_col;

Line 1119: CLOSE qa_results_txn;

1115:
1116: IF g_column = 'OCCURRENCE' THEN
1117: CLOSE qa_results_occ;
1118: ELSIF g_column = 'TXN_HEADER_ID' THEN
1119: CLOSE qa_results_txn;
1120: ELSE -- g_column = 'COLLECTION_ID'
1121: CLOSE qa_results_col;
1122: END IF;
1123:

Line 1121: CLOSE qa_results_col;

1117: CLOSE qa_results_occ;
1118: ELSIF g_column = 'TXN_HEADER_ID' THEN
1119: CLOSE qa_results_txn;
1120: ELSE -- g_column = 'COLLECTION_ID'
1121: CLOSE qa_results_col;
1122: END IF;
1123:
1124: END CLOSE_CURSOR;
1125: