APPS.FND_HELP dependencies on DBMS_SQL

Line 572: cur := dbms_sql.open_cursor;

568:
569: ------------------------------------------
570: -- Build and execute dynamic SQL cursor --
571: ------------------------------------------
572: cur := dbms_sql.open_cursor;
573: dbms_sql.parse(cur, selc||mainc||andc||orderc, dbms_sql.v7);
574:
575: dbms_sql.define_column(cur, 1, pct, 3);
576: dbms_sql.define_column(cur, 2, title, 256);

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

569: ------------------------------------------
570: -- Build and execute dynamic SQL cursor --
571: ------------------------------------------
572: cur := dbms_sql.open_cursor;
573: dbms_sql.parse(cur, selc||mainc||andc||orderc, dbms_sql.v7);
574:
575: dbms_sql.define_column(cur, 1, pct, 3);
576: dbms_sql.define_column(cur, 2, title, 256);
577: dbms_sql.define_column(cur, 3, app, 50);

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

571: ------------------------------------------
572: cur := dbms_sql.open_cursor;
573: dbms_sql.parse(cur, selc||mainc||andc||orderc, dbms_sql.v7);
574:
575: dbms_sql.define_column(cur, 1, pct, 3);
576: dbms_sql.define_column(cur, 2, title, 256);
577: dbms_sql.define_column(cur, 3, app, 50);
578: dbms_sql.define_column(cur, 4, fn, 256);
579:

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

572: cur := dbms_sql.open_cursor;
573: dbms_sql.parse(cur, selc||mainc||andc||orderc, dbms_sql.v7);
574:
575: dbms_sql.define_column(cur, 1, pct, 3);
576: dbms_sql.define_column(cur, 2, title, 256);
577: dbms_sql.define_column(cur, 3, app, 50);
578: dbms_sql.define_column(cur, 4, fn, 256);
579:
580: rows := dbms_sql.execute(cur);

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

573: dbms_sql.parse(cur, selc||mainc||andc||orderc, dbms_sql.v7);
574:
575: dbms_sql.define_column(cur, 1, pct, 3);
576: dbms_sql.define_column(cur, 2, title, 256);
577: dbms_sql.define_column(cur, 3, app, 50);
578: dbms_sql.define_column(cur, 4, fn, 256);
579:
580: rows := dbms_sql.execute(cur);
581:

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

574:
575: dbms_sql.define_column(cur, 1, pct, 3);
576: dbms_sql.define_column(cur, 2, title, 256);
577: dbms_sql.define_column(cur, 3, app, 50);
578: dbms_sql.define_column(cur, 4, fn, 256);
579:
580: rows := dbms_sql.execute(cur);
581:
582:

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

576: dbms_sql.define_column(cur, 2, title, 256);
577: dbms_sql.define_column(cur, 3, app, 50);
578: dbms_sql.define_column(cur, 4, fn, 256);
579:
580: rows := dbms_sql.execute(cur);
581:
582:
583: i := 1;
584: while (TRUE) loop

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

581:
582:
583: i := 1;
584: while (TRUE) loop
585: rows := dbms_sql.fetch_rows(cur);
586:
587: -- Bug 3315934 Added row_limit to resolve performance issues
588: -- Will display all rows if no limit is specified.
589: if (rows = 0 or (row_limit is not null and i > row_limit)) then

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

589: if (rows = 0 or (row_limit is not null and i > row_limit)) then
590: exit;
591: end if;
592:
593: dbms_sql.column_value(cur, 1, pct);
594: dbms_sql.column_value(cur, 2, title);
595: dbms_sql.column_value(cur, 3, app);
596: dbms_sql.column_value(cur, 4, fn);
597:

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

590: exit;
591: end if;
592:
593: dbms_sql.column_value(cur, 1, pct);
594: dbms_sql.column_value(cur, 2, title);
595: dbms_sql.column_value(cur, 3, app);
596: dbms_sql.column_value(cur, 4, fn);
597:
598: scores(i) := pct;

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

591: end if;
592:
593: dbms_sql.column_value(cur, 1, pct);
594: dbms_sql.column_value(cur, 2, title);
595: dbms_sql.column_value(cur, 3, app);
596: dbms_sql.column_value(cur, 4, fn);
597:
598: scores(i) := pct;
599: titles(i) := title;

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

592:
593: dbms_sql.column_value(cur, 1, pct);
594: dbms_sql.column_value(cur, 2, title);
595: dbms_sql.column_value(cur, 3, app);
596: dbms_sql.column_value(cur, 4, fn);
597:
598: scores(i) := pct;
599: titles(i) := title;
600: apps(i) := app;

Line 605: dbms_sql.close_cursor(cur);

601: file_names(i) := fn;
602:
603: i := i + 1;
604: end loop;
605: dbms_sql.close_cursor(cur);
606:
607: if (atg = TRUE) then
608:
609: scores(i) := 0;