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.IEM_TAGPROCESS_PUB dependencies on DBMS_SQL

Line 166: l_select_csr := DBMS_SQL.OPEN_CURSOR;

162: l_temp := null;
163:
164: -- Begin QUERY processing
165: BEGIN
166: l_select_csr := DBMS_SQL.OPEN_CURSOR;
167: DBMS_SQL.PARSE(l_select_csr, l_temp_value, DBMS_SQL.native);
168: DBMS_SQL.DEFINE_COLUMN(l_select_csr, 1, l_query_result, 256);
169: l_dummy := DBMS_SQL.EXECUTE(l_select_csr);
170:

Line 167: DBMS_SQL.PARSE(l_select_csr, l_temp_value, DBMS_SQL.native);

163:
164: -- Begin QUERY processing
165: BEGIN
166: l_select_csr := DBMS_SQL.OPEN_CURSOR;
167: DBMS_SQL.PARSE(l_select_csr, l_temp_value, DBMS_SQL.native);
168: DBMS_SQL.DEFINE_COLUMN(l_select_csr, 1, l_query_result, 256);
169: l_dummy := DBMS_SQL.EXECUTE(l_select_csr);
170:
171: -- fetch the first result if there is any

Line 168: DBMS_SQL.DEFINE_COLUMN(l_select_csr, 1, l_query_result, 256);

164: -- Begin QUERY processing
165: BEGIN
166: l_select_csr := DBMS_SQL.OPEN_CURSOR;
167: DBMS_SQL.PARSE(l_select_csr, l_temp_value, DBMS_SQL.native);
168: DBMS_SQL.DEFINE_COLUMN(l_select_csr, 1, l_query_result, 256);
169: l_dummy := DBMS_SQL.EXECUTE(l_select_csr);
170:
171: -- fetch the first result if there is any
172: IF DBMS_SQL.FETCH_ROWS(l_select_csr) = 0 THEN

Line 169: l_dummy := DBMS_SQL.EXECUTE(l_select_csr);

165: BEGIN
166: l_select_csr := DBMS_SQL.OPEN_CURSOR;
167: DBMS_SQL.PARSE(l_select_csr, l_temp_value, DBMS_SQL.native);
168: DBMS_SQL.DEFINE_COLUMN(l_select_csr, 1, l_query_result, 256);
169: l_dummy := DBMS_SQL.EXECUTE(l_select_csr);
170:
171: -- fetch the first result if there is any
172: IF DBMS_SQL.FETCH_ROWS(l_select_csr) = 0 THEN
173: l_temp := null;

Line 172: IF DBMS_SQL.FETCH_ROWS(l_select_csr) = 0 THEN

168: DBMS_SQL.DEFINE_COLUMN(l_select_csr, 1, l_query_result, 256);
169: l_dummy := DBMS_SQL.EXECUTE(l_select_csr);
170:
171: -- fetch the first result if there is any
172: IF DBMS_SQL.FETCH_ROWS(l_select_csr) = 0 THEN
173: l_temp := null;
174: ELSE
175: DBMS_SQL.COLUMN_VALUE(l_select_csr, 1, l_query_result);
176: l_temp := l_query_result;

Line 175: DBMS_SQL.COLUMN_VALUE(l_select_csr, 1, l_query_result);

171: -- fetch the first result if there is any
172: IF DBMS_SQL.FETCH_ROWS(l_select_csr) = 0 THEN
173: l_temp := null;
174: ELSE
175: DBMS_SQL.COLUMN_VALUE(l_select_csr, 1, l_query_result);
176: l_temp := l_query_result;
177:
178: -- check if there are more than 1 rows selected.
179: IF DBMS_SQL.FETCH_ROWS(l_select_csr) <> 0 THEN

Line 179: IF DBMS_SQL.FETCH_ROWS(l_select_csr) <> 0 THEN

175: DBMS_SQL.COLUMN_VALUE(l_select_csr, 1, l_query_result);
176: l_temp := l_query_result;
177:
178: -- check if there are more than 1 rows selected.
179: IF DBMS_SQL.FETCH_ROWS(l_select_csr) <> 0 THEN
180: if l_log_enabled then
181: logMessage := '[ERROR (too many rows selected) when execute query for keyId: '||v_tags.tag_id ||']';
182: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_TAGPROCESS_PUB.getEncryptId', logMessage);
183: end if;

Line 190: DBMS_SQL.CLOSE_CURSOR(l_select_csr);

186: END IF;
187: end if;
188:
189: -- Close the cursor
190: DBMS_SQL.CLOSE_CURSOR(l_select_csr);
191:
192: -- Insert data in key-value pair table
193: l_keyVal_tbl(l_indx).email_tag_key := 'IEMS'||v_tags.tag_id;
194: l_keyVal_tbl(l_indx).email_tag_value := l_temp;

Line 199: DBMS_SQL.CLOSE_CURSOR(l_select_csr);

195: l_indx := l_indx + 1;
196:
197: EXCEPTION
198: WHEN OTHERS THEN
199: DBMS_SQL.CLOSE_CURSOR(l_select_csr);
200:
201: if l_log_enabled then
202: logMessage := '[ERROR (Other exception) when execute query for keyId: '||v_tags.tag_id||'. Error:' ||sqlerrm||']';
203: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_TAGPROCESS_PUB.getEncryptId', logMessage);