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 2642: fnd_dsql.init;

2638: l_sql := l_sql || l_tbl_rec.summary_column_name || ', ';
2639: l_sql := l_sql || l_tbl_rec.compiled_attribute_column_name;
2640: l_sql := l_sql || ' from ' || l_tbl_rec.application_table_name || ' where ';
2641:
2642: fnd_dsql.init;
2643: fnd_dsql.add_text(l_sql);
2644:
2645: --
2646: -- The where clause needs to be surrounded by parentheses so we can

Line 2643: fnd_dsql.add_text(l_sql);

2639: l_sql := l_sql || l_tbl_rec.compiled_attribute_column_name;
2640: l_sql := l_sql || ' from ' || l_tbl_rec.application_table_name || ' where ';
2641:
2642: fnd_dsql.init;
2643: fnd_dsql.add_text(l_sql);
2644:
2645: --
2646: -- The where clause needs to be surrounded by parentheses so we can
2647: -- add additional restrictions using AND without overriding ORs inside it.

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

2646: -- The where clause needs to be surrounded by parentheses so we can
2647: -- add additional restrictions using AND without overriding ORs inside it.
2648: --
2649: IF (l_sql_pieces.COUNT > 0) THEN
2650: fnd_dsql.add_text('(');
2651:
2652: FOR i IN 1 .. l_sql_pieces.COUNT LOOP
2653: IF (l_sql_pieces(i).piece_type = SSP_PIECE_TYPE_BIND) THEN
2654: fnd_dsql.add_bind(l_sql_pieces(i).bind_value);

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

2650: fnd_dsql.add_text('(');
2651:
2652: FOR i IN 1 .. l_sql_pieces.COUNT LOOP
2653: IF (l_sql_pieces(i).piece_type = SSP_PIECE_TYPE_BIND) THEN
2654: fnd_dsql.add_bind(l_sql_pieces(i).bind_value);
2655: ELSE
2656: fnd_dsql.add_text(l_sql_pieces(i).piece_text);
2657: END IF;
2658: END LOOP;

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

2652: FOR i IN 1 .. l_sql_pieces.COUNT LOOP
2653: IF (l_sql_pieces(i).piece_type = SSP_PIECE_TYPE_BIND) THEN
2654: fnd_dsql.add_bind(l_sql_pieces(i).bind_value);
2655: ELSE
2656: fnd_dsql.add_text(l_sql_pieces(i).piece_text);
2657: END IF;
2658: END LOOP;
2659:
2660: fnd_dsql.add_text(') and ');

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

2656: fnd_dsql.add_text(l_sql_pieces(i).piece_text);
2657: END IF;
2658: END LOOP;
2659:
2660: fnd_dsql.add_text(') and ');
2661: END IF;
2662:
2663: -- Build comparison appropriate for data type of value or id column
2664: --

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

2662:
2663: -- Build comparison appropriate for data type of value or id column
2664: --
2665: if(p_is_value) THEN
2666: fnd_dsql.add_text(l_tbl_rec.value_column_name || ' = ');
2667: x_compare_clause(l_tbl_rec.value_column_type, l_tbl_rec.value_column_name, p_charval,
2668: VC_VALUE, p_vs_info.vsformat, p_vs_info.maxsize);
2669: else
2670: fnd_dsql.add_text(l_tbl_rec.id_column_name || ' = ');

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

2666: fnd_dsql.add_text(l_tbl_rec.value_column_name || ' = ');
2667: x_compare_clause(l_tbl_rec.value_column_type, l_tbl_rec.value_column_name, p_charval,
2668: VC_VALUE, p_vs_info.vsformat, p_vs_info.maxsize);
2669: else
2670: fnd_dsql.add_text(l_tbl_rec.id_column_name || ' = ');
2671: x_compare_clause(l_tbl_rec.id_column_type, l_tbl_rec.id_column_name, p_charval,
2672: VC_ID, p_vs_info.vsformat, p_vs_info.maxsize);
2673: end if;
2674:

Line 2803: fnd_dsql.init;

2799: prev_ids, prev_descs,
2800: prev_segnames, prev_vsnames,
2801: l_sql_pieces);
2802: IF (v_code = FF_VVALID) THEN
2803: fnd_dsql.init;
2804:
2805: FOR i IN 1 .. l_sql_pieces.COUNT LOOP
2806: IF (l_sql_pieces(i).piece_type = SSP_PIECE_TYPE_BIND) THEN
2807: fnd_dsql.add_bind(l_sql_pieces(i).bind_value);

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

2803: fnd_dsql.init;
2804:
2805: FOR i IN 1 .. l_sql_pieces.COUNT LOOP
2806: IF (l_sql_pieces(i).piece_type = SSP_PIECE_TYPE_BIND) THEN
2807: fnd_dsql.add_bind(l_sql_pieces(i).bind_value);
2808: ELSE
2809: fnd_dsql.add_text(l_sql_pieces(i).piece_text);
2810: END IF;
2811: END LOOP;

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

2805: FOR i IN 1 .. l_sql_pieces.COUNT LOOP
2806: IF (l_sql_pieces(i).piece_type = SSP_PIECE_TYPE_BIND) THEN
2807: fnd_dsql.add_bind(l_sql_pieces(i).bind_value);
2808: ELSE
2809: fnd_dsql.add_text(l_sql_pieces(i).piece_text);
2810: END IF;
2811: END LOOP;
2812:
2813: nfound := x_dsql_select_one(stored_val);

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

2812:
2813: nfound := x_dsql_select_one(stored_val);
2814: IF (nfound > 1) then
2815: FND_MESSAGE.set_name('FND', 'FLEX-DFLT MULTIPLE SQL ROWS');
2816: FND_MESSAGE.set_token('SQLSTR', SUBSTRB(fnd_dsql.get_text(FALSE), 1, 1000));
2817: v_code := FF_VERROR;
2818: ELSIF (nfound < 0) then
2819: v_code := FF_VERROR;
2820: else

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

4206: colhi VARCHAR2(200);
4207: datefmt VARCHAR2(24);
4208:
4209: BEGIN
4210: fnd_dsql.add_text('and (');
4211: IF (valstr IS NULL) THEN
4212: fnd_dsql.add_text(mincol || ' is null or ' ||
4213: maxcol || ' is null) ');
4214: ELSE

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

4208:
4209: BEGIN
4210: fnd_dsql.add_text('and (');
4211: IF (valstr IS NULL) THEN
4212: fnd_dsql.add_text(mincol || ' is null or ' ||
4213: maxcol || ' is null) ');
4214: ELSE
4215: IF (valtype = 'N') THEN
4216: fnd_dsql.add_bind(fnd_number.canonical_to_number(valstr));

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

4212: fnd_dsql.add_text(mincol || ' is null or ' ||
4213: maxcol || ' is null) ');
4214: ELSE
4215: IF (valtype = 'N') THEN
4216: fnd_dsql.add_bind(fnd_number.canonical_to_number(valstr));
4217:
4218: fnd_dsql.add_text(' between nvl(fnd_number.canonical_to_number('
4219: || mincol || '),');
4220: fnd_dsql.add_bind(fnd_number.canonical_to_number(valstr));

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

4214: ELSE
4215: IF (valtype = 'N') THEN
4216: fnd_dsql.add_bind(fnd_number.canonical_to_number(valstr));
4217:
4218: fnd_dsql.add_text(' between nvl(fnd_number.canonical_to_number('
4219: || mincol || '),');
4220: fnd_dsql.add_bind(fnd_number.canonical_to_number(valstr));
4221:
4222: fnd_dsql.add_text(') and nvl(fnd_number.canonical_to_number('

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

4216: fnd_dsql.add_bind(fnd_number.canonical_to_number(valstr));
4217:
4218: fnd_dsql.add_text(' between nvl(fnd_number.canonical_to_number('
4219: || mincol || '),');
4220: fnd_dsql.add_bind(fnd_number.canonical_to_number(valstr));
4221:
4222: fnd_dsql.add_text(') and nvl(fnd_number.canonical_to_number('
4223: || maxcol || '),');
4224: fnd_dsql.add_bind(fnd_number.canonical_to_number(valstr));

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

4218: fnd_dsql.add_text(' between nvl(fnd_number.canonical_to_number('
4219: || mincol || '),');
4220: fnd_dsql.add_bind(fnd_number.canonical_to_number(valstr));
4221:
4222: fnd_dsql.add_text(') and nvl(fnd_number.canonical_to_number('
4223: || maxcol || '),');
4224: fnd_dsql.add_bind(fnd_number.canonical_to_number(valstr));
4225:
4226: ELSIF (valtype in ('D', 'T', 't', 'I', 'X', 'Y', 'Z')) THEN

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

4220: fnd_dsql.add_bind(fnd_number.canonical_to_number(valstr));
4221:
4222: fnd_dsql.add_text(') and nvl(fnd_number.canonical_to_number('
4223: || maxcol || '),');
4224: fnd_dsql.add_bind(fnd_number.canonical_to_number(valstr));
4225:
4226: ELSIF (valtype in ('D', 'T', 't', 'I', 'X', 'Y', 'Z')) THEN
4227: datefmt := stored_date_format(valtype, LENGTH(valstr));
4228: fnd_dsql.add_bind(To_date(valstr, datefmt));

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

4224: fnd_dsql.add_bind(fnd_number.canonical_to_number(valstr));
4225:
4226: ELSIF (valtype in ('D', 'T', 't', 'I', 'X', 'Y', 'Z')) THEN
4227: datefmt := stored_date_format(valtype, LENGTH(valstr));
4228: fnd_dsql.add_bind(To_date(valstr, datefmt));
4229:
4230: fnd_dsql.add_text(' between nvl(to_date(' ||
4231: mincol || ',''' || datefmt || '''),');
4232: fnd_dsql.add_bind(To_date(valstr, datefmt));

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

4226: ELSIF (valtype in ('D', 'T', 't', 'I', 'X', 'Y', 'Z')) THEN
4227: datefmt := stored_date_format(valtype, LENGTH(valstr));
4228: fnd_dsql.add_bind(To_date(valstr, datefmt));
4229:
4230: fnd_dsql.add_text(' between nvl(to_date(' ||
4231: mincol || ',''' || datefmt || '''),');
4232: fnd_dsql.add_bind(To_date(valstr, datefmt));
4233:
4234: fnd_dsql.add_text(') and nvl(to_date(' ||

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

4228: fnd_dsql.add_bind(To_date(valstr, datefmt));
4229:
4230: fnd_dsql.add_text(' between nvl(to_date(' ||
4231: mincol || ',''' || datefmt || '''),');
4232: fnd_dsql.add_bind(To_date(valstr, datefmt));
4233:
4234: fnd_dsql.add_text(') and nvl(to_date(' ||
4235: maxcol || ',''' || datefmt || '''),');
4236: fnd_dsql.add_bind(To_date(valstr, datefmt));

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

4230: fnd_dsql.add_text(' between nvl(to_date(' ||
4231: mincol || ',''' || datefmt || '''),');
4232: fnd_dsql.add_bind(To_date(valstr, datefmt));
4233:
4234: fnd_dsql.add_text(') and nvl(to_date(' ||
4235: maxcol || ',''' || datefmt || '''),');
4236: fnd_dsql.add_bind(To_date(valstr, datefmt));
4237:
4238: ELSE

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

4232: fnd_dsql.add_bind(To_date(valstr, datefmt));
4233:
4234: fnd_dsql.add_text(') and nvl(to_date(' ||
4235: maxcol || ',''' || datefmt || '''),');
4236: fnd_dsql.add_bind(To_date(valstr, datefmt));
4237:
4238: ELSE
4239: fnd_dsql.add_bind(valstr);
4240:

Line 4239: fnd_dsql.add_bind(valstr);

4235: maxcol || ',''' || datefmt || '''),');
4236: fnd_dsql.add_bind(To_date(valstr, datefmt));
4237:
4238: ELSE
4239: fnd_dsql.add_bind(valstr);
4240:
4241: fnd_dsql.add_text(' between nvl(' || mincol || ',');
4242: fnd_dsql.add_bind(valstr);
4243:

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

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

Line 4242: fnd_dsql.add_bind(valstr);

4238: ELSE
4239: fnd_dsql.add_bind(valstr);
4240:
4241: fnd_dsql.add_text(' between nvl(' || mincol || ',');
4242: fnd_dsql.add_bind(valstr);
4243:
4244: fnd_dsql.add_text(') and nvl(' || maxcol || ',');
4245: fnd_dsql.add_bind(valstr);
4246:

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

4240:
4241: fnd_dsql.add_text(' between nvl(' || mincol || ',');
4242: fnd_dsql.add_bind(valstr);
4243:
4244: fnd_dsql.add_text(') and nvl(' || maxcol || ',');
4245: fnd_dsql.add_bind(valstr);
4246:
4247: END IF;
4248: fnd_dsql.add_text(')) ');

Line 4245: fnd_dsql.add_bind(valstr);

4241: fnd_dsql.add_text(' between nvl(' || mincol || ',');
4242: fnd_dsql.add_bind(valstr);
4243:
4244: fnd_dsql.add_text(') and nvl(' || maxcol || ',');
4245: fnd_dsql.add_bind(valstr);
4246:
4247: END IF;
4248: fnd_dsql.add_text(')) ');
4249: END IF;

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

4244: fnd_dsql.add_text(') and nvl(' || maxcol || ',');
4245: fnd_dsql.add_bind(valstr);
4246:
4247: END IF;
4248: fnd_dsql.add_text(')) ');
4249: END IF;
4250: END x_inrange_clause;
4251:
4252: /* ----------------------------------------------------------------------- */

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

4324: IS
4325: datefmt VARCHAR2(30);
4326: BEGIN
4327: IF (coltype = 'N') THEN
4328: fnd_dsql.add_bind(fnd_number.canonical_to_number(char_val));
4329: ELSIF (coltype = 'D') then
4330: IF (vs_fmt in ('X', 'Y', 'Z', 'D', 'T', 'I', 't')) then
4331: datefmt := stored_date_format(vs_fmt, vs_len);
4332: fnd_dsql.add_bind(To_date(char_val, datefmt));

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

4328: fnd_dsql.add_bind(fnd_number.canonical_to_number(char_val));
4329: ELSIF (coltype = 'D') then
4330: IF (vs_fmt in ('X', 'Y', 'Z', 'D', 'T', 'I', 't')) then
4331: datefmt := stored_date_format(vs_fmt, vs_len);
4332: fnd_dsql.add_bind(To_date(char_val, datefmt));
4333: ELSE
4334: fnd_dsql.add_bind(char_val);
4335: end if;
4336: else

Line 4334: fnd_dsql.add_bind(char_val);

4330: IF (vs_fmt in ('X', 'Y', 'Z', 'D', 'T', 'I', 't')) then
4331: datefmt := stored_date_format(vs_fmt, vs_len);
4332: fnd_dsql.add_bind(To_date(char_val, datefmt));
4333: ELSE
4334: fnd_dsql.add_bind(char_val);
4335: end if;
4336: else
4337: fnd_dsql.add_bind(char_val);
4338: end if;

Line 4337: fnd_dsql.add_bind(char_val);

4333: ELSE
4334: fnd_dsql.add_bind(char_val);
4335: end if;
4336: else
4337: fnd_dsql.add_bind(char_val);
4338: end if;
4339:
4340: END x_compare_clause;
4341:

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

4405: BEGIN
4406:
4407: -- Copy SQL string to array for debugging purposes
4408: --
4409: add_sql_string(fnd_dsql.get_text(p_with_debug => TRUE));
4410:
4411: cursornum := dbms_sql.open_cursor;
4412: fnd_dsql.set_cursor(cursornum);
4413:

Line 4412: fnd_dsql.set_cursor(cursornum);

4408: --
4409: add_sql_string(fnd_dsql.get_text(p_with_debug => TRUE));
4410:
4411: cursornum := dbms_sql.open_cursor;
4412: fnd_dsql.set_cursor(cursornum);
4413:
4414: sql_statement := fnd_dsql.get_text(p_with_debug => FALSE);
4415: dbms_sql.parse(cursornum, sql_statement, dbms_sql.v7);
4416:

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

4410:
4411: cursornum := dbms_sql.open_cursor;
4412: fnd_dsql.set_cursor(cursornum);
4413:
4414: sql_statement := fnd_dsql.get_text(p_with_debug => FALSE);
4415: dbms_sql.parse(cursornum, sql_statement, dbms_sql.v7);
4416:
4417: fnd_dsql.do_binds;
4418:

Line 4417: fnd_dsql.do_binds;

4413:
4414: sql_statement := fnd_dsql.get_text(p_with_debug => FALSE);
4415: dbms_sql.parse(cursornum, sql_statement, dbms_sql.v7);
4416:
4417: fnd_dsql.do_binds;
4418:
4419: nprocessed := dbms_sql.execute(cursornum);
4420: IF (fnd_flex_server1.g_debug_level > 0) THEN
4421: add_debug('(DSQL_execute processed ' || to_char(nprocessed));

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

4456: BEGIN
4457:
4458: -- Copy SQL string to array for debugging purposes
4459: --
4460: add_sql_string(fnd_dsql.get_text(p_with_debug => TRUE));
4461:
4462: selected_col := NULL;
4463: cursornum := dbms_sql.open_cursor;
4464: fnd_dsql.set_cursor(cursornum);

Line 4464: fnd_dsql.set_cursor(cursornum);

4460: add_sql_string(fnd_dsql.get_text(p_with_debug => TRUE));
4461:
4462: selected_col := NULL;
4463: cursornum := dbms_sql.open_cursor;
4464: fnd_dsql.set_cursor(cursornum);
4465:
4466: sql_statement := fnd_dsql.get_text(p_with_debug => FALSE);
4467: dbms_sql.parse(cursornum, sql_statement, dbms_sql.v7);
4468:

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

4462: selected_col := NULL;
4463: cursornum := dbms_sql.open_cursor;
4464: fnd_dsql.set_cursor(cursornum);
4465:
4466: sql_statement := fnd_dsql.get_text(p_with_debug => FALSE);
4467: dbms_sql.parse(cursornum, sql_statement, dbms_sql.v7);
4468:
4469: fnd_dsql.do_binds;
4470:

Line 4469: fnd_dsql.do_binds;

4465:
4466: sql_statement := fnd_dsql.get_text(p_with_debug => FALSE);
4467: dbms_sql.parse(cursornum, sql_statement, dbms_sql.v7);
4468:
4469: fnd_dsql.do_binds;
4470:
4471: dbms_sql.define_column(cursornum, 1, selected_col, 2000);
4472: num_returned := dbms_sql.execute_and_fetch(cursornum, TRUE);
4473: if(num_returned = 1) then

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

4531: BEGIN
4532:
4533: -- Copy SQL string to array for debugging purposes
4534: --
4535: add_sql_string(fnd_dsql.get_text(p_with_debug => TRUE));
4536:
4537: cursornum := dbms_sql.open_cursor;
4538: fnd_dsql.set_cursor(cursornum);
4539:

Line 4538: fnd_dsql.set_cursor(cursornum);

4534: --
4535: add_sql_string(fnd_dsql.get_text(p_with_debug => TRUE));
4536:
4537: cursornum := dbms_sql.open_cursor;
4538: fnd_dsql.set_cursor(cursornum);
4539:
4540: sql_statement := fnd_dsql.get_text(p_with_debug => FALSE);
4541: dbms_sql.parse(cursornum, sql_statement, dbms_sql.v7);
4542:

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

4536:
4537: cursornum := dbms_sql.open_cursor;
4538: fnd_dsql.set_cursor(cursornum);
4539:
4540: sql_statement := fnd_dsql.get_text(p_with_debug => FALSE);
4541: dbms_sql.parse(cursornum, sql_statement, dbms_sql.v7);
4542:
4543: fnd_dsql.do_binds;
4544:

Line 4543: fnd_dsql.do_binds;

4539:
4540: sql_statement := fnd_dsql.get_text(p_with_debug => FALSE);
4541: dbms_sql.parse(cursornum, sql_statement, dbms_sql.v7);
4542:
4543: fnd_dsql.do_binds;
4544:
4545: for i in 1..n_selected_cols loop
4546: -- The following prevents NO-DATA-FOUND exception...
4547: selected_cols(i) := NULL;