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.

[Home] [Help]

APPS.FND_FLEX_SERVER4 dependencies on FND_DSQL

Line 561: fnd_dsql.init;

557: FND_FLEX_SERVER1.add_debug(fnd_global.newline ||
558: 'BEGIN SV4.read_datafield() ');
559: END IF;
560:
561: fnd_dsql.init;
562: fnd_dsql.add_text('select SUBSTRB(' || datafield || ', 1, 2000)' ||
563: ' from ' || table_name ||
564: ' where rowid = CHARTOROWID(');
565: fnd_dsql.add_bind(ROWIDTOCHAR(row_id));

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

558: 'BEGIN SV4.read_datafield() ');
559: END IF;
560:
561: fnd_dsql.init;
562: fnd_dsql.add_text('select SUBSTRB(' || datafield || ', 1, 2000)' ||
563: ' from ' || table_name ||
564: ' where rowid = CHARTOROWID(');
565: fnd_dsql.add_bind(ROWIDTOCHAR(row_id));
566: fnd_dsql.add_text(')');

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

561: fnd_dsql.init;
562: fnd_dsql.add_text('select SUBSTRB(' || datafield || ', 1, 2000)' ||
563: ' from ' || table_name ||
564: ' where rowid = CHARTOROWID(');
565: fnd_dsql.add_bind(ROWIDTOCHAR(row_id));
566: fnd_dsql.add_text(')');
567:
568: -- Look up the segment values or ids.
569: --

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

562: fnd_dsql.add_text('select SUBSTRB(' || datafield || ', 1, 2000)' ||
563: ' from ' || table_name ||
564: ' where rowid = CHARTOROWID(');
565: fnd_dsql.add_bind(ROWIDTOCHAR(row_id));
566: fnd_dsql.add_text(')');
567:
568: -- Look up the segment values or ids.
569: --
570: rstat := FND_FLEX_SERVER1.x_dsql_select_one(concat_segids);

Line 648: fnd_dsql.init;

644: IF (fnd_flex_server1.g_debug_level > 0) THEN
645: FND_FLEX_SERVER1.add_debug(' Context col: '||dflex_info.context_column);
646: END IF;
647:
648: fnd_dsql.init;
649: fnd_dsql.add_text('select SUBSTRB(' || dflex_info.context_column || ', 1, 80)' ||
650: ' from ' || table_name ||
651: ' where rowid = CHARTOROWID(');
652: fnd_dsql.add_bind(ROWIDTOCHAR(row_id));

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

645: FND_FLEX_SERVER1.add_debug(' Context col: '||dflex_info.context_column);
646: END IF;
647:
648: fnd_dsql.init;
649: fnd_dsql.add_text('select SUBSTRB(' || dflex_info.context_column || ', 1, 80)' ||
650: ' from ' || table_name ||
651: ' where rowid = CHARTOROWID(');
652: fnd_dsql.add_bind(ROWIDTOCHAR(row_id));
653: fnd_dsql.add_text(')');

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

648: fnd_dsql.init;
649: fnd_dsql.add_text('select SUBSTRB(' || dflex_info.context_column || ', 1, 80)' ||
650: ' from ' || table_name ||
651: ' where rowid = CHARTOROWID(');
652: fnd_dsql.add_bind(ROWIDTOCHAR(row_id));
653: fnd_dsql.add_text(')');
654:
655: rstat := FND_FLEX_SERVER1.x_dsql_select_one(context);
656: if(rstat <> 1) then

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

649: fnd_dsql.add_text('select SUBSTRB(' || dflex_info.context_column || ', 1, 80)' ||
650: ' from ' || table_name ||
651: ' where rowid = CHARTOROWID(');
652: fnd_dsql.add_bind(ROWIDTOCHAR(row_id));
653: fnd_dsql.add_text(')');
654:
655: rstat := FND_FLEX_SERVER1.x_dsql_select_one(context);
656: if(rstat <> 1) then
657: if(rstat = 0) then

Line 685: fnd_dsql.init;

681: -- Build SQL statement to select segment columns in order for
682: -- global segments, the context segment, and context-sensitive segments.
683: --
684:
685: fnd_dsql.init;
686: fnd_dsql.add_text('select ');
687: for i in 1..ncols loop
688: if(i > 1) then
689: fnd_dsql.add_text(', ');

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

682: -- global segments, the context segment, and context-sensitive segments.
683: --
684:
685: fnd_dsql.init;
686: fnd_dsql.add_text('select ');
687: for i in 1..ncols loop
688: if(i > 1) then
689: fnd_dsql.add_text(', ');
690: end if;

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

685: fnd_dsql.init;
686: fnd_dsql.add_text('select ');
687: for i in 1..ncols loop
688: if(i > 1) then
689: fnd_dsql.add_text(', ');
690: end if;
691: fnd_dsql.add_text(FND_FLEX_SERVER1.select_clause
692: (cols(i), coltypes(i),
693: value_component, segfmts.vs_format(i), segfmts.vs_maxsize(i)));

Line 691: fnd_dsql.add_text(FND_FLEX_SERVER1.select_clause

687: for i in 1..ncols loop
688: if(i > 1) then
689: fnd_dsql.add_text(', ');
690: end if;
691: fnd_dsql.add_text(FND_FLEX_SERVER1.select_clause
692: (cols(i), coltypes(i),
693: value_component, segfmts.vs_format(i), segfmts.vs_maxsize(i)));
694: end loop;
695: fnd_dsql.add_text(' from ' || table_name ||

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

691: fnd_dsql.add_text(FND_FLEX_SERVER1.select_clause
692: (cols(i), coltypes(i),
693: value_component, segfmts.vs_format(i), segfmts.vs_maxsize(i)));
694: end loop;
695: fnd_dsql.add_text(' from ' || table_name ||
696: ' where rowid = CHARTOROWID(');
697: fnd_dsql.add_bind(ROWIDTOCHAR(row_id));
698: fnd_dsql.add_text(')');
699:

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

693: value_component, segfmts.vs_format(i), segfmts.vs_maxsize(i)));
694: end loop;
695: fnd_dsql.add_text(' from ' || table_name ||
696: ' where rowid = CHARTOROWID(');
697: fnd_dsql.add_bind(ROWIDTOCHAR(row_id));
698: fnd_dsql.add_text(')');
699:
700: -- Look up the segment values or ids.
701: --

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

694: end loop;
695: fnd_dsql.add_text(' from ' || table_name ||
696: ' where rowid = CHARTOROWID(');
697: fnd_dsql.add_bind(ROWIDTOCHAR(row_id));
698: fnd_dsql.add_text(')');
699:
700: -- Look up the segment values or ids.
701: --
702: rstat := FND_FLEX_SERVER1.x_dsql_select(ncols, segs);