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_SERVER4 dependencies on FND_DSQL

Line 550: fnd_dsql.init;

546: FND_FLEX_SERVER1.add_debug(fnd_global.newline ||
547: 'BEGIN SV4.read_datafield() ');
548: END IF;
549:
550: fnd_dsql.init;
551: fnd_dsql.add_text('select SUBSTRB(' || datafield || ', 1, 2000)' ||
552: ' from ' || table_name ||
553: ' where rowid = CHARTOROWID(');
554: fnd_dsql.add_bind(ROWIDTOCHAR(row_id));

Line 551: fnd_dsql.add_text('select SUBSTRB(' || datafield || ', 1, 2000)' ||

547: 'BEGIN SV4.read_datafield() ');
548: END IF;
549:
550: fnd_dsql.init;
551: fnd_dsql.add_text('select SUBSTRB(' || datafield || ', 1, 2000)' ||
552: ' from ' || table_name ||
553: ' where rowid = CHARTOROWID(');
554: fnd_dsql.add_bind(ROWIDTOCHAR(row_id));
555: fnd_dsql.add_text(')');

Line 554: fnd_dsql.add_bind(ROWIDTOCHAR(row_id));

550: fnd_dsql.init;
551: fnd_dsql.add_text('select SUBSTRB(' || datafield || ', 1, 2000)' ||
552: ' from ' || table_name ||
553: ' where rowid = CHARTOROWID(');
554: fnd_dsql.add_bind(ROWIDTOCHAR(row_id));
555: fnd_dsql.add_text(')');
556:
557: -- Look up the segment values or ids.
558: --

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

551: fnd_dsql.add_text('select SUBSTRB(' || datafield || ', 1, 2000)' ||
552: ' from ' || table_name ||
553: ' where rowid = CHARTOROWID(');
554: fnd_dsql.add_bind(ROWIDTOCHAR(row_id));
555: fnd_dsql.add_text(')');
556:
557: -- Look up the segment values or ids.
558: --
559: rstat := FND_FLEX_SERVER1.x_dsql_select_one(concat_segids);

Line 637: fnd_dsql.init;

633: IF (fnd_flex_server1.g_debug_level > 0) THEN
634: FND_FLEX_SERVER1.add_debug(' Context col: '||dflex_info.context_column);
635: END IF;
636:
637: fnd_dsql.init;
638: fnd_dsql.add_text('select SUBSTRB(' || dflex_info.context_column || ', 1, 80)' ||
639: ' from ' || table_name ||
640: ' where rowid = CHARTOROWID(');
641: fnd_dsql.add_bind(ROWIDTOCHAR(row_id));

Line 638: fnd_dsql.add_text('select SUBSTRB(' || dflex_info.context_column || ', 1, 80)' ||

634: FND_FLEX_SERVER1.add_debug(' Context col: '||dflex_info.context_column);
635: END IF;
636:
637: fnd_dsql.init;
638: fnd_dsql.add_text('select SUBSTRB(' || dflex_info.context_column || ', 1, 80)' ||
639: ' from ' || table_name ||
640: ' where rowid = CHARTOROWID(');
641: fnd_dsql.add_bind(ROWIDTOCHAR(row_id));
642: fnd_dsql.add_text(')');

Line 641: fnd_dsql.add_bind(ROWIDTOCHAR(row_id));

637: fnd_dsql.init;
638: fnd_dsql.add_text('select SUBSTRB(' || dflex_info.context_column || ', 1, 80)' ||
639: ' from ' || table_name ||
640: ' where rowid = CHARTOROWID(');
641: fnd_dsql.add_bind(ROWIDTOCHAR(row_id));
642: fnd_dsql.add_text(')');
643:
644: rstat := FND_FLEX_SERVER1.x_dsql_select_one(context);
645: if(rstat <> 1) then

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

638: fnd_dsql.add_text('select SUBSTRB(' || dflex_info.context_column || ', 1, 80)' ||
639: ' from ' || table_name ||
640: ' where rowid = CHARTOROWID(');
641: fnd_dsql.add_bind(ROWIDTOCHAR(row_id));
642: fnd_dsql.add_text(')');
643:
644: rstat := FND_FLEX_SERVER1.x_dsql_select_one(context);
645: if(rstat <> 1) then
646: if(rstat = 0) then

Line 674: fnd_dsql.init;

670: -- Build SQL statement to select segment columns in order for
671: -- global segments, the context segment, and context-sensitive segments.
672: --
673:
674: fnd_dsql.init;
675: fnd_dsql.add_text('select ');
676: for i in 1..ncols loop
677: if(i > 1) then
678: fnd_dsql.add_text(', ');

Line 675: fnd_dsql.add_text('select ');

671: -- global segments, the context segment, and context-sensitive segments.
672: --
673:
674: fnd_dsql.init;
675: fnd_dsql.add_text('select ');
676: for i in 1..ncols loop
677: if(i > 1) then
678: fnd_dsql.add_text(', ');
679: end if;

Line 678: fnd_dsql.add_text(', ');

674: fnd_dsql.init;
675: fnd_dsql.add_text('select ');
676: for i in 1..ncols loop
677: if(i > 1) then
678: fnd_dsql.add_text(', ');
679: end if;
680: fnd_dsql.add_text(FND_FLEX_SERVER1.select_clause
681: (cols(i), coltypes(i),
682: value_component, segfmts.vs_format(i), segfmts.vs_maxsize(i)));

Line 680: fnd_dsql.add_text(FND_FLEX_SERVER1.select_clause

676: for i in 1..ncols loop
677: if(i > 1) then
678: fnd_dsql.add_text(', ');
679: end if;
680: fnd_dsql.add_text(FND_FLEX_SERVER1.select_clause
681: (cols(i), coltypes(i),
682: value_component, segfmts.vs_format(i), segfmts.vs_maxsize(i)));
683: end loop;
684: fnd_dsql.add_text(' from ' || table_name ||

Line 684: fnd_dsql.add_text(' from ' || table_name ||

680: fnd_dsql.add_text(FND_FLEX_SERVER1.select_clause
681: (cols(i), coltypes(i),
682: value_component, segfmts.vs_format(i), segfmts.vs_maxsize(i)));
683: end loop;
684: fnd_dsql.add_text(' from ' || table_name ||
685: ' where rowid = CHARTOROWID(');
686: fnd_dsql.add_bind(ROWIDTOCHAR(row_id));
687: fnd_dsql.add_text(')');
688:

Line 686: fnd_dsql.add_bind(ROWIDTOCHAR(row_id));

682: value_component, segfmts.vs_format(i), segfmts.vs_maxsize(i)));
683: end loop;
684: fnd_dsql.add_text(' from ' || table_name ||
685: ' where rowid = CHARTOROWID(');
686: fnd_dsql.add_bind(ROWIDTOCHAR(row_id));
687: fnd_dsql.add_text(')');
688:
689: -- Look up the segment values or ids.
690: --

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

683: end loop;
684: fnd_dsql.add_text(' from ' || table_name ||
685: ' where rowid = CHARTOROWID(');
686: fnd_dsql.add_bind(ROWIDTOCHAR(row_id));
687: fnd_dsql.add_text(')');
688:
689: -- Look up the segment values or ids.
690: --
691: rstat := FND_FLEX_SERVER1.x_dsql_select(ncols, segs);