APPS.FND_HELP dependencies on DBMS_SQL

Line 560: cur := dbms_sql.open_cursor;

556:
557: ------------------------------------------
558: -- Build and execute dynamic SQL cursor --
559: ------------------------------------------
560: cur := dbms_sql.open_cursor;
561: dbms_sql.parse(cur, selc||mainc||andc||orderc, dbms_sql.v7);
562:
563: dbms_sql.define_column(cur, 1, pct, 3);
564: dbms_sql.define_column(cur, 2, title, 256);

Line 561: dbms_sql.parse(cur, selc||mainc||andc||orderc, dbms_sql.v7);

557: ------------------------------------------
558: -- Build and execute dynamic SQL cursor --
559: ------------------------------------------
560: cur := dbms_sql.open_cursor;
561: dbms_sql.parse(cur, selc||mainc||andc||orderc, dbms_sql.v7);
562:
563: dbms_sql.define_column(cur, 1, pct, 3);
564: dbms_sql.define_column(cur, 2, title, 256);
565: dbms_sql.define_column(cur, 3, app, 50);

Line 563: dbms_sql.define_column(cur, 1, pct, 3);

559: ------------------------------------------
560: cur := dbms_sql.open_cursor;
561: dbms_sql.parse(cur, selc||mainc||andc||orderc, dbms_sql.v7);
562:
563: dbms_sql.define_column(cur, 1, pct, 3);
564: dbms_sql.define_column(cur, 2, title, 256);
565: dbms_sql.define_column(cur, 3, app, 50);
566: dbms_sql.define_column(cur, 4, fn, 256);
567:

Line 564: dbms_sql.define_column(cur, 2, title, 256);

560: cur := dbms_sql.open_cursor;
561: dbms_sql.parse(cur, selc||mainc||andc||orderc, dbms_sql.v7);
562:
563: dbms_sql.define_column(cur, 1, pct, 3);
564: dbms_sql.define_column(cur, 2, title, 256);
565: dbms_sql.define_column(cur, 3, app, 50);
566: dbms_sql.define_column(cur, 4, fn, 256);
567:
568: rows := dbms_sql.execute(cur);

Line 565: dbms_sql.define_column(cur, 3, app, 50);

561: dbms_sql.parse(cur, selc||mainc||andc||orderc, dbms_sql.v7);
562:
563: dbms_sql.define_column(cur, 1, pct, 3);
564: dbms_sql.define_column(cur, 2, title, 256);
565: dbms_sql.define_column(cur, 3, app, 50);
566: dbms_sql.define_column(cur, 4, fn, 256);
567:
568: rows := dbms_sql.execute(cur);
569:

Line 566: dbms_sql.define_column(cur, 4, fn, 256);

562:
563: dbms_sql.define_column(cur, 1, pct, 3);
564: dbms_sql.define_column(cur, 2, title, 256);
565: dbms_sql.define_column(cur, 3, app, 50);
566: dbms_sql.define_column(cur, 4, fn, 256);
567:
568: rows := dbms_sql.execute(cur);
569:
570:

Line 568: rows := dbms_sql.execute(cur);

564: dbms_sql.define_column(cur, 2, title, 256);
565: dbms_sql.define_column(cur, 3, app, 50);
566: dbms_sql.define_column(cur, 4, fn, 256);
567:
568: rows := dbms_sql.execute(cur);
569:
570:
571: i := 1;
572: while (TRUE) loop

Line 573: rows := dbms_sql.fetch_rows(cur);

569:
570:
571: i := 1;
572: while (TRUE) loop
573: rows := dbms_sql.fetch_rows(cur);
574:
575: -- Bug 3315934 Added row_limit to resolve performance issues
576: -- Will display all rows if no limit is specified.
577: if (rows = 0 or (row_limit is not null and i > row_limit)) then

Line 581: dbms_sql.column_value(cur, 1, pct);

577: if (rows = 0 or (row_limit is not null and i > row_limit)) then
578: exit;
579: end if;
580:
581: dbms_sql.column_value(cur, 1, pct);
582: dbms_sql.column_value(cur, 2, title);
583: dbms_sql.column_value(cur, 3, app);
584: dbms_sql.column_value(cur, 4, fn);
585:

Line 582: dbms_sql.column_value(cur, 2, title);

578: exit;
579: end if;
580:
581: dbms_sql.column_value(cur, 1, pct);
582: dbms_sql.column_value(cur, 2, title);
583: dbms_sql.column_value(cur, 3, app);
584: dbms_sql.column_value(cur, 4, fn);
585:
586: scores(i) := pct;

Line 583: dbms_sql.column_value(cur, 3, app);

579: end if;
580:
581: dbms_sql.column_value(cur, 1, pct);
582: dbms_sql.column_value(cur, 2, title);
583: dbms_sql.column_value(cur, 3, app);
584: dbms_sql.column_value(cur, 4, fn);
585:
586: scores(i) := pct;
587: titles(i) := title;

Line 584: dbms_sql.column_value(cur, 4, fn);

580:
581: dbms_sql.column_value(cur, 1, pct);
582: dbms_sql.column_value(cur, 2, title);
583: dbms_sql.column_value(cur, 3, app);
584: dbms_sql.column_value(cur, 4, fn);
585:
586: scores(i) := pct;
587: titles(i) := title;
588: apps(i) := app;

Line 593: dbms_sql.close_cursor(cur);

589: file_names(i) := fn;
590:
591: i := i + 1;
592: end loop;
593: dbms_sql.close_cursor(cur);
594:
595: if (atg = TRUE) then
596:
597: scores(i) := 0;