APPS.FND_FLEX_SERVER2 dependencies on FND_DSQL

Line 937: fnd_dsql.init;

933: -- First build the select statement appropriate for the include or
934: -- exclude rule search.
935: --
936:
937: fnd_dsql.init;
938:
939: sqls := cvrule_clause_begin;
940:
941: IF (inex = 'E') THEN

Line 953: fnd_dsql.add_text(sqls);

949: else
950: sqls := sqls || cvrule_clause_exclude_mid;
951: end if;
952:
953: fnd_dsql.add_text(sqls);
954:
955: -- Build column select statements for each column.
956: --
957: for i in reverse 1..nsegs loop

Line 964: fnd_dsql.add_text(cvrule_clause_end);

960: hicol := 'L.SEGMENT' || to_char(i) || '_HIGH';
961: fnd_flex_server1.x_inrange_clause(segs(i), datatype,locol, hicol);
962: end loop;
963:
964: fnd_dsql.add_text(cvrule_clause_end);
965:
966: -- Stop at the first row if exclude rule violated
967: --
968: if(inex = 'E') then

Line 969: fnd_dsql.add_text('and ROWNUM = 1 ');

965:
966: -- Stop at the first row if exclude rule violated
967: --
968: if(inex = 'E') then
969: fnd_dsql.add_text('and ROWNUM = 1 ');
970: end if;
971:
972: -- Now do the select using dynamic sql
973: --

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

1017: end if;
1018:
1019: -- Save the SQL string in the debug string
1020: --
1021: FND_FLEX_SERVER1.add_sql_string(fnd_dsql.get_text(p_with_debug => TRUE));
1022:
1023: cursornum := dbms_sql.open_cursor;
1024: fnd_dsql.set_cursor(cursornum);
1025:

Line 1024: fnd_dsql.set_cursor(cursornum);

1020: --
1021: FND_FLEX_SERVER1.add_sql_string(fnd_dsql.get_text(p_with_debug => TRUE));
1022:
1023: cursornum := dbms_sql.open_cursor;
1024: fnd_dsql.set_cursor(cursornum);
1025:
1026: sql_str := fnd_dsql.get_text(p_with_debug => FALSE);
1027: dbms_sql.parse(cursornum, sql_str, dbms_sql.v7);
1028:

Line 1026: sql_str := fnd_dsql.get_text(p_with_debug => FALSE);

1022:
1023: cursornum := dbms_sql.open_cursor;
1024: fnd_dsql.set_cursor(cursornum);
1025:
1026: sql_str := fnd_dsql.get_text(p_with_debug => FALSE);
1027: dbms_sql.parse(cursornum, sql_str, dbms_sql.v7);
1028:
1029: fnd_dsql.do_binds;
1030: dbms_sql.bind_variable(cursornum, ':VDATE', v_date);

Line 1029: fnd_dsql.do_binds;

1025:
1026: sql_str := fnd_dsql.get_text(p_with_debug => FALSE);
1027: dbms_sql.parse(cursornum, sql_str, dbms_sql.v7);
1028:
1029: fnd_dsql.do_binds;
1030: dbms_sql.bind_variable(cursornum, ':VDATE', v_date);
1031: dbms_sql.bind_variable(cursornum, ':APID', fstruct.application_id);
1032: dbms_sql.bind_variable(cursornum, ':CODE', fstruct.id_flex_code);
1033: dbms_sql.bind_variable(cursornum, ':NUM', fstruct.id_flex_num);