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 FND_DSQL

Line 2661: fnd_dsql.init;

2657: l_sql := l_sql || l_tbl_rec.summary_column_name || ', ';
2658: l_sql := l_sql || l_tbl_rec.compiled_attribute_column_name;
2659: l_sql := l_sql || ' from ' || l_tbl_rec.application_table_name || ' where ';
2660:
2661: fnd_dsql.init;
2662: fnd_dsql.add_text(l_sql);
2663:
2664: --
2665: -- The where clause needs to be surrounded by parentheses so we can

Line 2662: fnd_dsql.add_text(l_sql);

2658: l_sql := l_sql || l_tbl_rec.compiled_attribute_column_name;
2659: l_sql := l_sql || ' from ' || l_tbl_rec.application_table_name || ' where ';
2660:
2661: fnd_dsql.init;
2662: fnd_dsql.add_text(l_sql);
2663:
2664: --
2665: -- The where clause needs to be surrounded by parentheses so we can
2666: -- add additional restrictions using AND without overriding ORs inside it.

Line 2669: fnd_dsql.add_text('(');

2665: -- The where clause needs to be surrounded by parentheses so we can
2666: -- add additional restrictions using AND without overriding ORs inside it.
2667: --
2668: IF (l_sql_pieces.COUNT > 0) THEN
2669: fnd_dsql.add_text('(');
2670:
2671: FOR i IN 1 .. l_sql_pieces.COUNT LOOP
2672: IF (l_sql_pieces(i).piece_type = SSP_PIECE_TYPE_BIND) THEN
2673: fnd_dsql.add_bind(l_sql_pieces(i).bind_value);

Line 2673: fnd_dsql.add_bind(l_sql_pieces(i).bind_value);

2669: fnd_dsql.add_text('(');
2670:
2671: FOR i IN 1 .. l_sql_pieces.COUNT LOOP
2672: IF (l_sql_pieces(i).piece_type = SSP_PIECE_TYPE_BIND) THEN
2673: fnd_dsql.add_bind(l_sql_pieces(i).bind_value);
2674: ELSE
2675: fnd_dsql.add_text(l_sql_pieces(i).piece_text);
2676: END IF;
2677: END LOOP;

Line 2675: fnd_dsql.add_text(l_sql_pieces(i).piece_text);

2671: FOR i IN 1 .. l_sql_pieces.COUNT LOOP
2672: IF (l_sql_pieces(i).piece_type = SSP_PIECE_TYPE_BIND) THEN
2673: fnd_dsql.add_bind(l_sql_pieces(i).bind_value);
2674: ELSE
2675: fnd_dsql.add_text(l_sql_pieces(i).piece_text);
2676: END IF;
2677: END LOOP;
2678:
2679: fnd_dsql.add_text(') and ');

Line 2679: fnd_dsql.add_text(') and ');

2675: fnd_dsql.add_text(l_sql_pieces(i).piece_text);
2676: END IF;
2677: END LOOP;
2678:
2679: fnd_dsql.add_text(') and ');
2680: END IF;
2681:
2682: -- Build comparison appropriate for data type of value or id column
2683: --

Line 2685: fnd_dsql.add_text(l_tbl_rec.value_column_name || ' = ');

2681:
2682: -- Build comparison appropriate for data type of value or id column
2683: --
2684: if(p_is_value) THEN
2685: fnd_dsql.add_text(l_tbl_rec.value_column_name || ' = ');
2686: x_compare_clause(l_tbl_rec.value_column_type, l_tbl_rec.value_column_name, p_charval,
2687: VC_VALUE, p_vs_info.vsformat, p_vs_info.maxsize);
2688: else
2689: fnd_dsql.add_text(l_tbl_rec.id_column_name || ' = ');

Line 2689: fnd_dsql.add_text(l_tbl_rec.id_column_name || ' = ');

2685: fnd_dsql.add_text(l_tbl_rec.value_column_name || ' = ');
2686: x_compare_clause(l_tbl_rec.value_column_type, l_tbl_rec.value_column_name, p_charval,
2687: VC_VALUE, p_vs_info.vsformat, p_vs_info.maxsize);
2688: else
2689: fnd_dsql.add_text(l_tbl_rec.id_column_name || ' = ');
2690: x_compare_clause(l_tbl_rec.id_column_type, l_tbl_rec.id_column_name, p_charval,
2691: VC_ID, p_vs_info.vsformat, p_vs_info.maxsize);
2692: end if;
2693:

Line 2823: fnd_dsql.init;

2819: prev_ids, prev_descs,
2820: prev_segnames, prev_vsnames,
2821: l_sql_pieces);
2822: IF (v_code = FF_VVALID) THEN
2823: fnd_dsql.init;
2824:
2825: FOR i IN 1 .. l_sql_pieces.COUNT LOOP
2826: IF (l_sql_pieces(i).piece_type = SSP_PIECE_TYPE_BIND) THEN
2827: fnd_dsql.add_bind(l_sql_pieces(i).bind_value);

Line 2827: fnd_dsql.add_bind(l_sql_pieces(i).bind_value);

2823: fnd_dsql.init;
2824:
2825: FOR i IN 1 .. l_sql_pieces.COUNT LOOP
2826: IF (l_sql_pieces(i).piece_type = SSP_PIECE_TYPE_BIND) THEN
2827: fnd_dsql.add_bind(l_sql_pieces(i).bind_value);
2828: ELSE
2829: fnd_dsql.add_text(l_sql_pieces(i).piece_text);
2830: END IF;
2831: END LOOP;

Line 2829: fnd_dsql.add_text(l_sql_pieces(i).piece_text);

2825: FOR i IN 1 .. l_sql_pieces.COUNT LOOP
2826: IF (l_sql_pieces(i).piece_type = SSP_PIECE_TYPE_BIND) THEN
2827: fnd_dsql.add_bind(l_sql_pieces(i).bind_value);
2828: ELSE
2829: fnd_dsql.add_text(l_sql_pieces(i).piece_text);
2830: END IF;
2831: END LOOP;
2832:
2833: nfound := x_dsql_select_one(stored_val);

Line 2836: FND_MESSAGE.set_token('SQLSTR', SUBSTRB(fnd_dsql.get_text(FALSE), 1, 1000));

2832:
2833: nfound := x_dsql_select_one(stored_val);
2834: IF (nfound > 1) then
2835: FND_MESSAGE.set_name('FND', 'FLEX-DFLT MULTIPLE SQL ROWS');
2836: FND_MESSAGE.set_token('SQLSTR', SUBSTRB(fnd_dsql.get_text(FALSE), 1, 1000));
2837: v_code := FF_VERROR;
2838: ELSIF (nfound < 0) then
2839: v_code := FF_VERROR;
2840: else

Line 4230: fnd_dsql.add_text('and (');

4226: colhi VARCHAR2(200);
4227: datefmt VARCHAR2(24);
4228:
4229: BEGIN
4230: fnd_dsql.add_text('and (');
4231: IF (valstr IS NULL) THEN
4232: fnd_dsql.add_text(mincol || ' is null or ' ||
4233: maxcol || ' is null) ');
4234: ELSE

Line 4232: fnd_dsql.add_text(mincol || ' is null or ' ||

4228:
4229: BEGIN
4230: fnd_dsql.add_text('and (');
4231: IF (valstr IS NULL) THEN
4232: fnd_dsql.add_text(mincol || ' is null or ' ||
4233: maxcol || ' is null) ');
4234: ELSE
4235: IF (valtype = 'N') THEN
4236: fnd_dsql.add_bind(fnd_number.canonical_to_number(valstr));

Line 4236: fnd_dsql.add_bind(fnd_number.canonical_to_number(valstr));

4232: fnd_dsql.add_text(mincol || ' is null or ' ||
4233: maxcol || ' is null) ');
4234: ELSE
4235: IF (valtype = 'N') THEN
4236: fnd_dsql.add_bind(fnd_number.canonical_to_number(valstr));
4237:
4238: fnd_dsql.add_text(' between nvl(fnd_number.canonical_to_number('
4239: || mincol || '),');
4240: fnd_dsql.add_bind(fnd_number.canonical_to_number(valstr));

Line 4238: fnd_dsql.add_text(' between nvl(fnd_number.canonical_to_number('

4234: ELSE
4235: IF (valtype = 'N') THEN
4236: fnd_dsql.add_bind(fnd_number.canonical_to_number(valstr));
4237:
4238: fnd_dsql.add_text(' between nvl(fnd_number.canonical_to_number('
4239: || mincol || '),');
4240: fnd_dsql.add_bind(fnd_number.canonical_to_number(valstr));
4241:
4242: fnd_dsql.add_text(') and nvl(fnd_number.canonical_to_number('

Line 4240: fnd_dsql.add_bind(fnd_number.canonical_to_number(valstr));

4236: fnd_dsql.add_bind(fnd_number.canonical_to_number(valstr));
4237:
4238: fnd_dsql.add_text(' between nvl(fnd_number.canonical_to_number('
4239: || mincol || '),');
4240: fnd_dsql.add_bind(fnd_number.canonical_to_number(valstr));
4241:
4242: fnd_dsql.add_text(') and nvl(fnd_number.canonical_to_number('
4243: || maxcol || '),');
4244: fnd_dsql.add_bind(fnd_number.canonical_to_number(valstr));

Line 4242: fnd_dsql.add_text(') and nvl(fnd_number.canonical_to_number('

4238: fnd_dsql.add_text(' between nvl(fnd_number.canonical_to_number('
4239: || mincol || '),');
4240: fnd_dsql.add_bind(fnd_number.canonical_to_number(valstr));
4241:
4242: fnd_dsql.add_text(') and nvl(fnd_number.canonical_to_number('
4243: || maxcol || '),');
4244: fnd_dsql.add_bind(fnd_number.canonical_to_number(valstr));
4245:
4246: ELSIF (valtype in ('D', 'T', 't', 'I', 'X', 'Y', 'Z')) THEN

Line 4244: fnd_dsql.add_bind(fnd_number.canonical_to_number(valstr));

4240: fnd_dsql.add_bind(fnd_number.canonical_to_number(valstr));
4241:
4242: fnd_dsql.add_text(') and nvl(fnd_number.canonical_to_number('
4243: || maxcol || '),');
4244: fnd_dsql.add_bind(fnd_number.canonical_to_number(valstr));
4245:
4246: ELSIF (valtype in ('D', 'T', 't', 'I', 'X', 'Y', 'Z')) THEN
4247: datefmt := stored_date_format(valtype, LENGTH(valstr));
4248: fnd_dsql.add_bind(To_date(valstr, datefmt));

Line 4248: fnd_dsql.add_bind(To_date(valstr, datefmt));

4244: fnd_dsql.add_bind(fnd_number.canonical_to_number(valstr));
4245:
4246: ELSIF (valtype in ('D', 'T', 't', 'I', 'X', 'Y', 'Z')) THEN
4247: datefmt := stored_date_format(valtype, LENGTH(valstr));
4248: fnd_dsql.add_bind(To_date(valstr, datefmt));
4249:
4250: fnd_dsql.add_text(' between nvl(to_date(' ||
4251: mincol || ',''' || datefmt || '''),');
4252: fnd_dsql.add_bind(To_date(valstr, datefmt));

Line 4250: fnd_dsql.add_text(' between nvl(to_date(' ||

4246: ELSIF (valtype in ('D', 'T', 't', 'I', 'X', 'Y', 'Z')) THEN
4247: datefmt := stored_date_format(valtype, LENGTH(valstr));
4248: fnd_dsql.add_bind(To_date(valstr, datefmt));
4249:
4250: fnd_dsql.add_text(' between nvl(to_date(' ||
4251: mincol || ',''' || datefmt || '''),');
4252: fnd_dsql.add_bind(To_date(valstr, datefmt));
4253:
4254: fnd_dsql.add_text(') and nvl(to_date(' ||

Line 4252: fnd_dsql.add_bind(To_date(valstr, datefmt));

4248: fnd_dsql.add_bind(To_date(valstr, datefmt));
4249:
4250: fnd_dsql.add_text(' between nvl(to_date(' ||
4251: mincol || ',''' || datefmt || '''),');
4252: fnd_dsql.add_bind(To_date(valstr, datefmt));
4253:
4254: fnd_dsql.add_text(') and nvl(to_date(' ||
4255: maxcol || ',''' || datefmt || '''),');
4256: fnd_dsql.add_bind(To_date(valstr, datefmt));

Line 4254: fnd_dsql.add_text(') and nvl(to_date(' ||

4250: fnd_dsql.add_text(' between nvl(to_date(' ||
4251: mincol || ',''' || datefmt || '''),');
4252: fnd_dsql.add_bind(To_date(valstr, datefmt));
4253:
4254: fnd_dsql.add_text(') and nvl(to_date(' ||
4255: maxcol || ',''' || datefmt || '''),');
4256: fnd_dsql.add_bind(To_date(valstr, datefmt));
4257:
4258: ELSE

Line 4256: fnd_dsql.add_bind(To_date(valstr, datefmt));

4252: fnd_dsql.add_bind(To_date(valstr, datefmt));
4253:
4254: fnd_dsql.add_text(') and nvl(to_date(' ||
4255: maxcol || ',''' || datefmt || '''),');
4256: fnd_dsql.add_bind(To_date(valstr, datefmt));
4257:
4258: ELSE
4259: fnd_dsql.add_bind(valstr);
4260:

Line 4259: fnd_dsql.add_bind(valstr);

4255: maxcol || ',''' || datefmt || '''),');
4256: fnd_dsql.add_bind(To_date(valstr, datefmt));
4257:
4258: ELSE
4259: fnd_dsql.add_bind(valstr);
4260:
4261: fnd_dsql.add_text(' between nvl(' || mincol || ',');
4262: fnd_dsql.add_bind(valstr);
4263:

Line 4261: fnd_dsql.add_text(' between nvl(' || mincol || ',');

4257:
4258: ELSE
4259: fnd_dsql.add_bind(valstr);
4260:
4261: fnd_dsql.add_text(' between nvl(' || mincol || ',');
4262: fnd_dsql.add_bind(valstr);
4263:
4264: fnd_dsql.add_text(') and nvl(' || maxcol || ',');
4265: fnd_dsql.add_bind(valstr);

Line 4262: fnd_dsql.add_bind(valstr);

4258: ELSE
4259: fnd_dsql.add_bind(valstr);
4260:
4261: fnd_dsql.add_text(' between nvl(' || mincol || ',');
4262: fnd_dsql.add_bind(valstr);
4263:
4264: fnd_dsql.add_text(') and nvl(' || maxcol || ',');
4265: fnd_dsql.add_bind(valstr);
4266:

Line 4264: fnd_dsql.add_text(') and nvl(' || maxcol || ',');

4260:
4261: fnd_dsql.add_text(' between nvl(' || mincol || ',');
4262: fnd_dsql.add_bind(valstr);
4263:
4264: fnd_dsql.add_text(') and nvl(' || maxcol || ',');
4265: fnd_dsql.add_bind(valstr);
4266:
4267: END IF;
4268: fnd_dsql.add_text(')) ');

Line 4265: fnd_dsql.add_bind(valstr);

4261: fnd_dsql.add_text(' between nvl(' || mincol || ',');
4262: fnd_dsql.add_bind(valstr);
4263:
4264: fnd_dsql.add_text(') and nvl(' || maxcol || ',');
4265: fnd_dsql.add_bind(valstr);
4266:
4267: END IF;
4268: fnd_dsql.add_text(')) ');
4269: END IF;

Line 4268: fnd_dsql.add_text(')) ');

4264: fnd_dsql.add_text(') and nvl(' || maxcol || ',');
4265: fnd_dsql.add_bind(valstr);
4266:
4267: END IF;
4268: fnd_dsql.add_text(')) ');
4269: END IF;
4270: END x_inrange_clause;
4271:
4272: /* ----------------------------------------------------------------------- */

Line 4348: fnd_dsql.add_bind(fnd_number.canonical_to_number(char_val));

4344: IS
4345: datefmt VARCHAR2(30);
4346: BEGIN
4347: IF (coltype = 'N') THEN
4348: fnd_dsql.add_bind(fnd_number.canonical_to_number(char_val));
4349: ELSIF (coltype = 'D') then
4350: IF (vs_fmt in ('X', 'Y', 'Z', 'D', 'T', 'I', 't')) then
4351: datefmt := stored_date_format(vs_fmt, vs_len);
4352: fnd_dsql.add_bind(To_date(char_val, datefmt));

Line 4352: fnd_dsql.add_bind(To_date(char_val, datefmt));

4348: fnd_dsql.add_bind(fnd_number.canonical_to_number(char_val));
4349: ELSIF (coltype = 'D') then
4350: IF (vs_fmt in ('X', 'Y', 'Z', 'D', 'T', 'I', 't')) then
4351: datefmt := stored_date_format(vs_fmt, vs_len);
4352: fnd_dsql.add_bind(To_date(char_val, datefmt));
4353: ELSE
4354: fnd_dsql.add_bind(char_val);
4355: end if;
4356: else

Line 4354: fnd_dsql.add_bind(char_val);

4350: IF (vs_fmt in ('X', 'Y', 'Z', 'D', 'T', 'I', 't')) then
4351: datefmt := stored_date_format(vs_fmt, vs_len);
4352: fnd_dsql.add_bind(To_date(char_val, datefmt));
4353: ELSE
4354: fnd_dsql.add_bind(char_val);
4355: end if;
4356: else
4357: fnd_dsql.add_bind(char_val);
4358: end if;

Line 4357: fnd_dsql.add_bind(char_val);

4353: ELSE
4354: fnd_dsql.add_bind(char_val);
4355: end if;
4356: else
4357: fnd_dsql.add_bind(char_val);
4358: end if;
4359:
4360: END x_compare_clause;
4361:

Line 4429: add_sql_string(fnd_dsql.get_text(p_with_debug => TRUE));

4425: BEGIN
4426:
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:

Line 4432: fnd_dsql.set_cursor(cursornum);

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);
4436:

Line 4434: sql_statement := fnd_dsql.get_text(p_with_debug => FALSE);

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);
4436:
4437: fnd_dsql.do_binds;
4438:

Line 4437: fnd_dsql.do_binds;

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);
4440: IF (fnd_flex_server1.g_debug_level > 0) THEN
4441: add_debug('(DSQL_execute processed ' || to_char(nprocessed));

Line 4480: add_sql_string(fnd_dsql.get_text(p_with_debug => TRUE));

4476: BEGIN
4477:
4478: -- Copy SQL string to array for debugging purposes
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);

Line 4484: fnd_dsql.set_cursor(cursornum);

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);
4488:

Line 4486: sql_statement := fnd_dsql.get_text(p_with_debug => FALSE);

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);
4488:
4489: fnd_dsql.do_binds;
4490:

Line 4489: fnd_dsql.do_binds;

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);
4492: num_returned := dbms_sql.execute_and_fetch(cursornum, TRUE);
4493: if(num_returned = 1) then

Line 4555: add_sql_string(fnd_dsql.get_text(p_with_debug => TRUE));

4551: BEGIN
4552:
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:

Line 4558: fnd_dsql.set_cursor(cursornum);

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);
4562:

Line 4560: sql_statement := fnd_dsql.get_text(p_with_debug => FALSE);

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);
4562:
4563: fnd_dsql.do_binds;
4564:

Line 4563: fnd_dsql.do_binds;

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
4566: -- The following prevents NO-DATA-FOUND exception...
4567: selected_cols(i) := NULL;