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

Line 196: l_cursor := dbms_sql.open_cursor;

192: l_sql_stmt := l_sql_stmt|| 'AND fad.pk5_value = :pkey5 ';
193: END IF;
194:
195: -- open the cursor
196: l_cursor := dbms_sql.open_cursor;
197: -- parse the sql
198: dbms_sql.parse(l_cursor, l_sql_stmt||' '||l_sqlstmt||')',
199: dbms_sql.v7);
200:

Line 198: dbms_sql.parse(l_cursor, l_sql_stmt||' '||l_sqlstmt||')',

194:
195: -- open the cursor
196: l_cursor := dbms_sql.open_cursor;
197: -- parse the sql
198: dbms_sql.parse(l_cursor, l_sql_stmt||' '||l_sqlstmt||')',
199: dbms_sql.v7);
200:
201: -- define the column
202: dbms_sql.define_column(l_cursor, 1, l_exists_flag, 1);

Line 199: dbms_sql.v7);

195: -- open the cursor
196: l_cursor := dbms_sql.open_cursor;
197: -- parse the sql
198: dbms_sql.parse(l_cursor, l_sql_stmt||' '||l_sqlstmt||')',
199: dbms_sql.v7);
200:
201: -- define the column
202: dbms_sql.define_column(l_cursor, 1, l_exists_flag, 1);
203:

Line 202: dbms_sql.define_column(l_cursor, 1, l_exists_flag, 1);

198: dbms_sql.parse(l_cursor, l_sql_stmt||' '||l_sqlstmt||')',
199: dbms_sql.v7);
200:
201: -- define the column
202: dbms_sql.define_column(l_cursor, 1, l_exists_flag, 1);
203:
204: -- bind variables
205: dbms_sql.bind_variable(l_cursor, ':ename', l_entity_name);
206: dbms_sql.bind_variable(l_cursor, ':function_type', l2_function_type);

Line 205: dbms_sql.bind_variable(l_cursor, ':ename', l_entity_name);

201: -- define the column
202: dbms_sql.define_column(l_cursor, 1, l_exists_flag, 1);
203:
204: -- bind variables
205: dbms_sql.bind_variable(l_cursor, ':ename', l_entity_name);
206: dbms_sql.bind_variable(l_cursor, ':function_type', l2_function_type);
207: dbms_sql.bind_variable(l_cursor, ':function_name', l2_function_name);
208:
209: IF (l_pkey1 IS NOT NULL) THEN

Line 206: dbms_sql.bind_variable(l_cursor, ':function_type', l2_function_type);

202: dbms_sql.define_column(l_cursor, 1, l_exists_flag, 1);
203:
204: -- bind variables
205: dbms_sql.bind_variable(l_cursor, ':ename', l_entity_name);
206: dbms_sql.bind_variable(l_cursor, ':function_type', l2_function_type);
207: dbms_sql.bind_variable(l_cursor, ':function_name', l2_function_name);
208:
209: IF (l_pkey1 IS NOT NULL) THEN
210: dbms_sql.bind_variable(l_cursor, ':pkey1', l_pkey1);

Line 207: dbms_sql.bind_variable(l_cursor, ':function_name', l2_function_name);

203:
204: -- bind variables
205: dbms_sql.bind_variable(l_cursor, ':ename', l_entity_name);
206: dbms_sql.bind_variable(l_cursor, ':function_type', l2_function_type);
207: dbms_sql.bind_variable(l_cursor, ':function_name', l2_function_name);
208:
209: IF (l_pkey1 IS NOT NULL) THEN
210: dbms_sql.bind_variable(l_cursor, ':pkey1', l_pkey1);
211: END IF;

Line 210: dbms_sql.bind_variable(l_cursor, ':pkey1', l_pkey1);

206: dbms_sql.bind_variable(l_cursor, ':function_type', l2_function_type);
207: dbms_sql.bind_variable(l_cursor, ':function_name', l2_function_name);
208:
209: IF (l_pkey1 IS NOT NULL) THEN
210: dbms_sql.bind_variable(l_cursor, ':pkey1', l_pkey1);
211: END IF;
212:
213: IF (l_pkey2 IS NOT NULL) THEN
214: dbms_sql.bind_variable(l_cursor, ':pkey2', l_pkey2);

Line 214: dbms_sql.bind_variable(l_cursor, ':pkey2', l_pkey2);

210: dbms_sql.bind_variable(l_cursor, ':pkey1', l_pkey1);
211: END IF;
212:
213: IF (l_pkey2 IS NOT NULL) THEN
214: dbms_sql.bind_variable(l_cursor, ':pkey2', l_pkey2);
215: END IF;
216:
217: IF (l_pkey3 IS NOT NULL) THEN
218: dbms_sql.bind_variable(l_cursor, ':pkey3', l_pkey3);

Line 218: dbms_sql.bind_variable(l_cursor, ':pkey3', l_pkey3);

214: dbms_sql.bind_variable(l_cursor, ':pkey2', l_pkey2);
215: END IF;
216:
217: IF (l_pkey3 IS NOT NULL) THEN
218: dbms_sql.bind_variable(l_cursor, ':pkey3', l_pkey3);
219: END IF;
220:
221: IF (l_pkey4 IS NOT NULL) THEN
222: dbms_sql.bind_variable(l_cursor, ':pkey4', l_pkey4);

Line 222: dbms_sql.bind_variable(l_cursor, ':pkey4', l_pkey4);

218: dbms_sql.bind_variable(l_cursor, ':pkey3', l_pkey3);
219: END IF;
220:
221: IF (l_pkey4 IS NOT NULL) THEN
222: dbms_sql.bind_variable(l_cursor, ':pkey4', l_pkey4);
223: END IF;
224:
225: IF (l_pkey5 IS NOT NULL) THEN
226: dbms_sql.bind_variable(l_cursor, ':pkey5', l_pkey5);

Line 226: dbms_sql.bind_variable(l_cursor, ':pkey5', l_pkey5);

222: dbms_sql.bind_variable(l_cursor, ':pkey4', l_pkey4);
223: END IF;
224:
225: IF (l_pkey5 IS NOT NULL) THEN
226: dbms_sql.bind_variable(l_cursor, ':pkey5', l_pkey5);
227: END IF;
228:
229:
230: l_rows_processed := dbms_sql.execute_and_fetch(l_cursor);

Line 230: l_rows_processed := dbms_sql.execute_and_fetch(l_cursor);

226: dbms_sql.bind_variable(l_cursor, ':pkey5', l_pkey5);
227: END IF;
228:
229:
230: l_rows_processed := dbms_sql.execute_and_fetch(l_cursor);
231: dbms_sql.column_value(l_cursor,1,l_exists_flag);
232: dbms_sql.close_cursor(l_cursor);
233:
234: IF (l_exists_Flag = 'Y') THEN

Line 231: dbms_sql.column_value(l_cursor,1,l_exists_flag);

227: END IF;
228:
229:
230: l_rows_processed := dbms_sql.execute_and_fetch(l_cursor);
231: dbms_sql.column_value(l_cursor,1,l_exists_flag);
232: dbms_sql.close_cursor(l_cursor);
233:
234: IF (l_exists_Flag = 'Y') THEN
235: return('Y');

Line 232: dbms_sql.close_cursor(l_cursor);

228:
229:
230: l_rows_processed := dbms_sql.execute_and_fetch(l_cursor);
231: dbms_sql.column_value(l_cursor,1,l_exists_flag);
232: dbms_sql.close_cursor(l_cursor);
233:
234: IF (l_exists_Flag = 'Y') THEN
235: return('Y');
236: ELSE

Line 243: dbms_sql.close_cursor(l_cursor);

239:
240:
241: EXCEPTION
242: WHEN OTHERS THEN
243: dbms_sql.close_cursor(l_cursor);
244: return('N');
245:
246: END get_atchmt_exists_sql;
247:

Line 475: l_cursor := dbms_sql.open_cursor;

471: -- get set of books description if security type = 2
472: IF (X_security_type = 2) THEN
473: -- user dynamic sql as AOL may not have reference to
474: -- sets of books
475: l_cursor := dbms_sql.open_cursor;
476: -- parse the statement
477: dbms_sql.parse(l_cursor,
478: 'SELECT short_name FROM gl_sets_of_books '||
479: 'WHERE set_of_books_id = :sob_id', dbms_sql.v7);

Line 477: dbms_sql.parse(l_cursor,

473: -- user dynamic sql as AOL may not have reference to
474: -- sets of books
475: l_cursor := dbms_sql.open_cursor;
476: -- parse the statement
477: dbms_sql.parse(l_cursor,
478: 'SELECT short_name FROM gl_sets_of_books '||
479: 'WHERE set_of_books_id = :sob_id', dbms_sql.v7);
480: -- define the column
481: dbms_sql.define_column(l_cursor, 1, l_security_desc, 20);

Line 479: 'WHERE set_of_books_id = :sob_id', dbms_sql.v7);

475: l_cursor := dbms_sql.open_cursor;
476: -- parse the statement
477: dbms_sql.parse(l_cursor,
478: 'SELECT short_name FROM gl_sets_of_books '||
479: 'WHERE set_of_books_id = :sob_id', dbms_sql.v7);
480: -- define the column
481: dbms_sql.define_column(l_cursor, 1, l_security_desc, 20);
482: -- bind variable
483: dbms_sql.bind_variable(l_cursor, ':sob_id', X_security_id);

Line 481: dbms_sql.define_column(l_cursor, 1, l_security_desc, 20);

477: dbms_sql.parse(l_cursor,
478: 'SELECT short_name FROM gl_sets_of_books '||
479: 'WHERE set_of_books_id = :sob_id', dbms_sql.v7);
480: -- define the column
481: dbms_sql.define_column(l_cursor, 1, l_security_desc, 20);
482: -- bind variable
483: dbms_sql.bind_variable(l_cursor, ':sob_id', X_security_id);
484:
485: rows_processed := dbms_sql.execute_and_fetch(l_cursor);

Line 483: dbms_sql.bind_variable(l_cursor, ':sob_id', X_security_id);

479: 'WHERE set_of_books_id = :sob_id', dbms_sql.v7);
480: -- define the column
481: dbms_sql.define_column(l_cursor, 1, l_security_desc, 20);
482: -- bind variable
483: dbms_sql.bind_variable(l_cursor, ':sob_id', X_security_id);
484:
485: rows_processed := dbms_sql.execute_and_fetch(l_cursor);
486: dbms_sql.column_value(l_cursor,1,l_security_desc);
487: dbms_sql.close_cursor(l_cursor);

Line 485: rows_processed := dbms_sql.execute_and_fetch(l_cursor);

481: dbms_sql.define_column(l_cursor, 1, l_security_desc, 20);
482: -- bind variable
483: dbms_sql.bind_variable(l_cursor, ':sob_id', X_security_id);
484:
485: rows_processed := dbms_sql.execute_and_fetch(l_cursor);
486: dbms_sql.column_value(l_cursor,1,l_security_desc);
487: dbms_sql.close_cursor(l_cursor);
488: X_security_desc := l_security_desc;
489:

Line 486: dbms_sql.column_value(l_cursor,1,l_security_desc);

482: -- bind variable
483: dbms_sql.bind_variable(l_cursor, ':sob_id', X_security_id);
484:
485: rows_processed := dbms_sql.execute_and_fetch(l_cursor);
486: dbms_sql.column_value(l_cursor,1,l_security_desc);
487: dbms_sql.close_cursor(l_cursor);
488: X_security_desc := l_security_desc;
489:
490: END IF;

Line 487: dbms_sql.close_cursor(l_cursor);

483: dbms_sql.bind_variable(l_cursor, ':sob_id', X_security_id);
484:
485: rows_processed := dbms_sql.execute_and_fetch(l_cursor);
486: dbms_sql.column_value(l_cursor,1,l_security_desc);
487: dbms_sql.close_cursor(l_cursor);
488: X_security_desc := l_security_desc;
489:
490: END IF;
491: