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_FLEX_SERVER1 dependencies on DBMS_SQL

Line 4431: cursornum := dbms_sql.open_cursor;

4427: -- Copy SQL string to array for debugging purposes
4428: --
4429: add_sql_string(fnd_dsql.get_text(p_with_debug => TRUE));
4430:
4431: cursornum := dbms_sql.open_cursor;
4432: fnd_dsql.set_cursor(cursornum);
4433:
4434: sql_statement := fnd_dsql.get_text(p_with_debug => FALSE);
4435: dbms_sql.parse(cursornum, sql_statement, dbms_sql.v7);

Line 4435: dbms_sql.parse(cursornum, sql_statement, dbms_sql.v7);

4431: cursornum := dbms_sql.open_cursor;
4432: fnd_dsql.set_cursor(cursornum);
4433:
4434: sql_statement := fnd_dsql.get_text(p_with_debug => FALSE);
4435: dbms_sql.parse(cursornum, sql_statement, dbms_sql.v7);
4436:
4437: fnd_dsql.do_binds;
4438:
4439: nprocessed := dbms_sql.execute(cursornum);

Line 4439: nprocessed := dbms_sql.execute(cursornum);

4435: dbms_sql.parse(cursornum, sql_statement, dbms_sql.v7);
4436:
4437: fnd_dsql.do_binds;
4438:
4439: nprocessed := dbms_sql.execute(cursornum);
4440: IF (fnd_flex_server1.g_debug_level > 0) THEN
4441: add_debug('(DSQL_execute processed ' || to_char(nprocessed));
4442: add_debug(' rows.)');
4443: END IF;

Line 4444: dbms_sql.close_cursor(cursornum);

4440: IF (fnd_flex_server1.g_debug_level > 0) THEN
4441: add_debug('(DSQL_execute processed ' || to_char(nprocessed));
4442: add_debug(' rows.)');
4443: END IF;
4444: dbms_sql.close_cursor(cursornum);
4445: return(nprocessed);
4446:
4447: EXCEPTION
4448: WHEN OTHERS then

Line 4449: if(dbms_sql.is_open(cursornum)) then

4445: return(nprocessed);
4446:
4447: EXCEPTION
4448: WHEN OTHERS then
4449: if(dbms_sql.is_open(cursornum)) then
4450: dbms_sql.close_cursor(cursornum);
4451: end if;
4452: FND_MESSAGE.set_name('FND', 'FLEX-DSQL EXCEPTION');
4453: FND_MESSAGE.set_token('MSG', SQLERRM);

Line 4450: dbms_sql.close_cursor(cursornum);

4446:
4447: EXCEPTION
4448: WHEN OTHERS then
4449: if(dbms_sql.is_open(cursornum)) then
4450: dbms_sql.close_cursor(cursornum);
4451: end if;
4452: FND_MESSAGE.set_name('FND', 'FLEX-DSQL EXCEPTION');
4453: FND_MESSAGE.set_token('MSG', SQLERRM);
4454: FND_MESSAGE.set_token('SQLSTR', SUBSTRB(sql_statement, 1, 1000));

Line 4483: cursornum := dbms_sql.open_cursor;

4479: --
4480: add_sql_string(fnd_dsql.get_text(p_with_debug => TRUE));
4481:
4482: selected_col := NULL;
4483: cursornum := dbms_sql.open_cursor;
4484: fnd_dsql.set_cursor(cursornum);
4485:
4486: sql_statement := fnd_dsql.get_text(p_with_debug => FALSE);
4487: dbms_sql.parse(cursornum, sql_statement, dbms_sql.v7);

Line 4487: dbms_sql.parse(cursornum, sql_statement, dbms_sql.v7);

4483: cursornum := dbms_sql.open_cursor;
4484: fnd_dsql.set_cursor(cursornum);
4485:
4486: sql_statement := fnd_dsql.get_text(p_with_debug => FALSE);
4487: dbms_sql.parse(cursornum, sql_statement, dbms_sql.v7);
4488:
4489: fnd_dsql.do_binds;
4490:
4491: dbms_sql.define_column(cursornum, 1, selected_col, 2000);

Line 4491: dbms_sql.define_column(cursornum, 1, selected_col, 2000);

4487: dbms_sql.parse(cursornum, sql_statement, dbms_sql.v7);
4488:
4489: fnd_dsql.do_binds;
4490:
4491: dbms_sql.define_column(cursornum, 1, selected_col, 2000);
4492: num_returned := dbms_sql.execute_and_fetch(cursornum, TRUE);
4493: if(num_returned = 1) then
4494: dbms_sql.column_value(cursornum, 1, selected_col);
4495: returned_column := selected_col;

Line 4492: num_returned := dbms_sql.execute_and_fetch(cursornum, TRUE);

4488:
4489: fnd_dsql.do_binds;
4490:
4491: dbms_sql.define_column(cursornum, 1, selected_col, 2000);
4492: num_returned := dbms_sql.execute_and_fetch(cursornum, TRUE);
4493: if(num_returned = 1) then
4494: dbms_sql.column_value(cursornum, 1, selected_col);
4495: returned_column := selected_col;
4496: IF (fnd_flex_server1.g_debug_level > 0) THEN

Line 4494: dbms_sql.column_value(cursornum, 1, selected_col);

4490:
4491: dbms_sql.define_column(cursornum, 1, selected_col, 2000);
4492: num_returned := dbms_sql.execute_and_fetch(cursornum, TRUE);
4493: if(num_returned = 1) then
4494: dbms_sql.column_value(cursornum, 1, selected_col);
4495: returned_column := selected_col;
4496: IF (fnd_flex_server1.g_debug_level > 0) THEN
4497: add_debug('(DSQL returned ' || selected_col || ')');
4498: END IF;

Line 4505: dbms_sql.close_cursor(cursornum);

4501: returned_column := NULL;
4502: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
4503: FND_MESSAGE.set_token('MSG', 'x_dsql_select_one() could not fetch rows');
4504: end if;
4505: dbms_sql.close_cursor(cursornum);
4506: return(num_returned);
4507:
4508: EXCEPTION
4509: WHEN NO_DATA_FOUND or invalid_rowid then

Line 4514: dbms_sql.close_cursor(cursornum);

4510: returned_column := NULL;
4511: IF (fnd_flex_server1.g_debug_level > 0) THEN
4512: add_debug('(DSQL returned: NULL)');
4513: END IF;
4514: dbms_sql.close_cursor(cursornum);
4515: return(0);
4516: WHEN TOO_MANY_ROWS then
4517: dbms_sql.column_value(cursornum, 1, selected_col);
4518: returned_column := selected_col;

Line 4517: dbms_sql.column_value(cursornum, 1, selected_col);

4513: END IF;
4514: dbms_sql.close_cursor(cursornum);
4515: return(0);
4516: WHEN TOO_MANY_ROWS then
4517: dbms_sql.column_value(cursornum, 1, selected_col);
4518: returned_column := selected_col;
4519: IF (fnd_flex_server1.g_debug_level > 0) THEN
4520: add_debug('(DSQL returned: TOO MANY ROWS)');
4521: END IF;

Line 4522: dbms_sql.close_cursor(cursornum);

4518: returned_column := selected_col;
4519: IF (fnd_flex_server1.g_debug_level > 0) THEN
4520: add_debug('(DSQL returned: TOO MANY ROWS)');
4521: END IF;
4522: dbms_sql.close_cursor(cursornum);
4523: return(2);
4524: WHEN OTHERS then
4525: if(dbms_sql.is_open(cursornum)) then
4526: dbms_sql.close_cursor(cursornum);

Line 4525: if(dbms_sql.is_open(cursornum)) then

4521: END IF;
4522: dbms_sql.close_cursor(cursornum);
4523: return(2);
4524: WHEN OTHERS then
4525: if(dbms_sql.is_open(cursornum)) then
4526: dbms_sql.close_cursor(cursornum);
4527: end if;
4528: FND_MESSAGE.set_name('FND', 'FLEX-DSQL EXCEPTION');
4529: FND_MESSAGE.set_token('MSG', SQLERRM);

Line 4526: dbms_sql.close_cursor(cursornum);

4522: dbms_sql.close_cursor(cursornum);
4523: return(2);
4524: WHEN OTHERS then
4525: if(dbms_sql.is_open(cursornum)) then
4526: dbms_sql.close_cursor(cursornum);
4527: end if;
4528: FND_MESSAGE.set_name('FND', 'FLEX-DSQL EXCEPTION');
4529: FND_MESSAGE.set_token('MSG', SQLERRM);
4530: FND_MESSAGE.set_token('SQLSTR', SUBSTRB(sql_statement, 1, 1000));

Line 4557: cursornum := dbms_sql.open_cursor;

4553: -- Copy SQL string to array for debugging purposes
4554: --
4555: add_sql_string(fnd_dsql.get_text(p_with_debug => TRUE));
4556:
4557: cursornum := dbms_sql.open_cursor;
4558: fnd_dsql.set_cursor(cursornum);
4559:
4560: sql_statement := fnd_dsql.get_text(p_with_debug => FALSE);
4561: dbms_sql.parse(cursornum, sql_statement, dbms_sql.v7);

Line 4561: dbms_sql.parse(cursornum, sql_statement, dbms_sql.v7);

4557: cursornum := dbms_sql.open_cursor;
4558: fnd_dsql.set_cursor(cursornum);
4559:
4560: sql_statement := fnd_dsql.get_text(p_with_debug => FALSE);
4561: dbms_sql.parse(cursornum, sql_statement, dbms_sql.v7);
4562:
4563: fnd_dsql.do_binds;
4564:
4565: for i in 1..n_selected_cols loop

Line 4568: dbms_sql.define_column(cursornum, i, selected_cols(i), 2000);

4564:
4565: for i in 1..n_selected_cols loop
4566: -- The following prevents NO-DATA-FOUND exception...
4567: selected_cols(i) := NULL;
4568: dbms_sql.define_column(cursornum, i, selected_cols(i), 2000);
4569: end loop;
4570: num_returned := dbms_sql.execute_and_fetch(cursornum, TRUE);
4571: if(num_returned = 1) then
4572: IF (fnd_flex_server1.g_debug_level > 0) THEN

Line 4570: num_returned := dbms_sql.execute_and_fetch(cursornum, TRUE);

4566: -- The following prevents NO-DATA-FOUND exception...
4567: selected_cols(i) := NULL;
4568: dbms_sql.define_column(cursornum, i, selected_cols(i), 2000);
4569: end loop;
4570: num_returned := dbms_sql.execute_and_fetch(cursornum, TRUE);
4571: if(num_returned = 1) then
4572: IF (fnd_flex_server1.g_debug_level > 0) THEN
4573: add_debug('(DSQL returned');
4574: END IF;

Line 4576: dbms_sql.column_value(cursornum, i, selected_cols(i));

4572: IF (fnd_flex_server1.g_debug_level > 0) THEN
4573: add_debug('(DSQL returned');
4574: END IF;
4575: for i in 1..n_selected_cols loop
4576: dbms_sql.column_value(cursornum, i, selected_cols(i));
4577: IF (fnd_flex_server1.g_debug_level > 0) THEN
4578: add_debug(' ''' || selected_cols(i) || '''');
4579: END IF;
4580: end loop;

Line 4589: dbms_sql.close_cursor(cursornum);

4585: num_returned := -1;
4586: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
4587: FND_MESSAGE.set_token('MSG', 'x_dsql_select() could not fetch rows');
4588: end if;
4589: dbms_sql.close_cursor(cursornum);
4590: returned_columns := selected_cols;
4591: return(num_returned);
4592:
4593: EXCEPTION

Line 4598: dbms_sql.close_cursor(cursornum);

4594: WHEN NO_DATA_FOUND OR invalid_rowid then
4595: IF (fnd_flex_server1.g_debug_level > 0) THEN
4596: add_debug('(DSQL returned: NULL)');
4597: END IF;
4598: dbms_sql.close_cursor(cursornum);
4599: return(0);
4600: WHEN TOO_MANY_ROWS then
4601: IF (fnd_flex_server1.g_debug_level > 0) THEN
4602: add_debug('(DSQL returned');

Line 4605: dbms_sql.column_value(cursornum, i, selected_cols(i));

4601: IF (fnd_flex_server1.g_debug_level > 0) THEN
4602: add_debug('(DSQL returned');
4603: END IF;
4604: for i in 1..n_selected_cols loop
4605: dbms_sql.column_value(cursornum, i, selected_cols(i));
4606: IF (fnd_flex_server1.g_debug_level > 0) THEN
4607: add_debug(' ''' || selected_cols(i) || '''');
4608: END IF;
4609: end loop;

Line 4614: dbms_sql.close_cursor(cursornum);

4610: IF (fnd_flex_server1.g_debug_level > 0) THEN
4611: add_debug(')');
4612: add_debug('(DSQL returned: TOO MANY ROWS)');
4613: END IF;
4614: dbms_sql.close_cursor(cursornum);
4615: returned_columns := selected_cols;
4616: return(2);
4617: WHEN OTHERS then
4618: if(dbms_sql.is_open(cursornum)) then

Line 4618: if(dbms_sql.is_open(cursornum)) then

4614: dbms_sql.close_cursor(cursornum);
4615: returned_columns := selected_cols;
4616: return(2);
4617: WHEN OTHERS then
4618: if(dbms_sql.is_open(cursornum)) then
4619: dbms_sql.close_cursor(cursornum);
4620: end if;
4621: FND_MESSAGE.set_name('FND', 'FLEX-DSQL EXCEPTION');
4622: FND_MESSAGE.set_token('MSG', SQLERRM);

Line 4619: dbms_sql.close_cursor(cursornum);

4615: returned_columns := selected_cols;
4616: return(2);
4617: WHEN OTHERS then
4618: if(dbms_sql.is_open(cursornum)) then
4619: dbms_sql.close_cursor(cursornum);
4620: end if;
4621: FND_MESSAGE.set_name('FND', 'FLEX-DSQL EXCEPTION');
4622: FND_MESSAGE.set_token('MSG', SQLERRM);
4623: FND_MESSAGE.set_token('SQLSTR', SUBSTRB(sql_statement, 1, 1000));