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.WSH_DOCUMENT_SETS dependencies on DBMS_SQL

Line 729: l_cursor := dbms_sql.open_cursor;

725: -- NOTE not all values will be defined if this references another
726: -- flex field, this will cause an error in which case continue
727: BEGIN
728: BEGIN
729: l_cursor := dbms_sql.open_cursor;
730: dbms_sql.parse(l_cursor, l_arg_default_value, dbms_sql.v7);
731: dbms_sql.define_column(l_cursor, 1, l_sql_value, 100 );
732: l_rows := dbms_sql.execute(l_cursor);
733: l_rows := dbms_sql.fetch_rows(l_cursor);

Line 730: dbms_sql.parse(l_cursor, l_arg_default_value, dbms_sql.v7);

726: -- flex field, this will cause an error in which case continue
727: BEGIN
728: BEGIN
729: l_cursor := dbms_sql.open_cursor;
730: dbms_sql.parse(l_cursor, l_arg_default_value, dbms_sql.v7);
731: dbms_sql.define_column(l_cursor, 1, l_sql_value, 100 );
732: l_rows := dbms_sql.execute(l_cursor);
733: l_rows := dbms_sql.fetch_rows(l_cursor);
734: dbms_sql.column_value(l_cursor, 1, l_sql_value);

Line 731: dbms_sql.define_column(l_cursor, 1, l_sql_value, 100 );

727: BEGIN
728: BEGIN
729: l_cursor := dbms_sql.open_cursor;
730: dbms_sql.parse(l_cursor, l_arg_default_value, dbms_sql.v7);
731: dbms_sql.define_column(l_cursor, 1, l_sql_value, 100 );
732: l_rows := dbms_sql.execute(l_cursor);
733: l_rows := dbms_sql.fetch_rows(l_cursor);
734: dbms_sql.column_value(l_cursor, 1, l_sql_value);
735: IF dbms_sql.is_open(l_cursor) THEN

Line 732: l_rows := dbms_sql.execute(l_cursor);

728: BEGIN
729: l_cursor := dbms_sql.open_cursor;
730: dbms_sql.parse(l_cursor, l_arg_default_value, dbms_sql.v7);
731: dbms_sql.define_column(l_cursor, 1, l_sql_value, 100 );
732: l_rows := dbms_sql.execute(l_cursor);
733: l_rows := dbms_sql.fetch_rows(l_cursor);
734: dbms_sql.column_value(l_cursor, 1, l_sql_value);
735: IF dbms_sql.is_open(l_cursor) THEN
736: dbms_sql.close_cursor(l_cursor);

Line 733: l_rows := dbms_sql.fetch_rows(l_cursor);

729: l_cursor := dbms_sql.open_cursor;
730: dbms_sql.parse(l_cursor, l_arg_default_value, dbms_sql.v7);
731: dbms_sql.define_column(l_cursor, 1, l_sql_value, 100 );
732: l_rows := dbms_sql.execute(l_cursor);
733: l_rows := dbms_sql.fetch_rows(l_cursor);
734: dbms_sql.column_value(l_cursor, 1, l_sql_value);
735: IF dbms_sql.is_open(l_cursor) THEN
736: dbms_sql.close_cursor(l_cursor);
737: END IF;

Line 734: dbms_sql.column_value(l_cursor, 1, l_sql_value);

730: dbms_sql.parse(l_cursor, l_arg_default_value, dbms_sql.v7);
731: dbms_sql.define_column(l_cursor, 1, l_sql_value, 100 );
732: l_rows := dbms_sql.execute(l_cursor);
733: l_rows := dbms_sql.fetch_rows(l_cursor);
734: dbms_sql.column_value(l_cursor, 1, l_sql_value);
735: IF dbms_sql.is_open(l_cursor) THEN
736: dbms_sql.close_cursor(l_cursor);
737: END IF;
738:

Line 735: IF dbms_sql.is_open(l_cursor) THEN

731: dbms_sql.define_column(l_cursor, 1, l_sql_value, 100 );
732: l_rows := dbms_sql.execute(l_cursor);
733: l_rows := dbms_sql.fetch_rows(l_cursor);
734: dbms_sql.column_value(l_cursor, 1, l_sql_value);
735: IF dbms_sql.is_open(l_cursor) THEN
736: dbms_sql.close_cursor(l_cursor);
737: END IF;
738:
739: l_argument(l_arg_cnt) := l_sql_value;

Line 736: dbms_sql.close_cursor(l_cursor);

732: l_rows := dbms_sql.execute(l_cursor);
733: l_rows := dbms_sql.fetch_rows(l_cursor);
734: dbms_sql.column_value(l_cursor, 1, l_sql_value);
735: IF dbms_sql.is_open(l_cursor) THEN
736: dbms_sql.close_cursor(l_cursor);
737: END IF;
738:
739: l_argument(l_arg_cnt) := l_sql_value;
740: END;

Line 746: IF dbms_sql.is_open(l_cursor) THEN

742: EXCEPTION
743: WHEN OTHERS THEN
744: --NULL;
745: -- Bug 3596524
746: IF dbms_sql.is_open(l_cursor) THEN
747: dbms_sql.close_cursor(l_cursor);
748: END IF;
749: END;
750: END IF;

Line 747: dbms_sql.close_cursor(l_cursor);

743: WHEN OTHERS THEN
744: --NULL;
745: -- Bug 3596524
746: IF dbms_sql.is_open(l_cursor) THEN
747: dbms_sql.close_cursor(l_cursor);
748: END IF;
749: END;
750: END IF;
751:

Line 770: l_cursor := dbms_sql.open_cursor;

766: l_select_clause || ' where 1=1 ' || l_additional_clause
767: || ' ' || l_where_clause;
768:
769: BEGIN
770: l_cursor := dbms_sql.open_cursor;
771: dbms_sql.parse(l_cursor, l_value_set_lookup, dbms_sql.v7);
772: dbms_sql.bind_variable(l_cursor, ':value', l_argument(l_arg_cnt));
773: dbms_sql.define_column(l_cursor, 1, l_sql_value, 255 );
774: l_rows := dbms_sql.execute(l_cursor);

Line 771: dbms_sql.parse(l_cursor, l_value_set_lookup, dbms_sql.v7);

767: || ' ' || l_where_clause;
768:
769: BEGIN
770: l_cursor := dbms_sql.open_cursor;
771: dbms_sql.parse(l_cursor, l_value_set_lookup, dbms_sql.v7);
772: dbms_sql.bind_variable(l_cursor, ':value', l_argument(l_arg_cnt));
773: dbms_sql.define_column(l_cursor, 1, l_sql_value, 255 );
774: l_rows := dbms_sql.execute(l_cursor);
775: l_rows := dbms_sql.fetch_rows(l_cursor);

Line 772: dbms_sql.bind_variable(l_cursor, ':value', l_argument(l_arg_cnt));

768:
769: BEGIN
770: l_cursor := dbms_sql.open_cursor;
771: dbms_sql.parse(l_cursor, l_value_set_lookup, dbms_sql.v7);
772: dbms_sql.bind_variable(l_cursor, ':value', l_argument(l_arg_cnt));
773: dbms_sql.define_column(l_cursor, 1, l_sql_value, 255 );
774: l_rows := dbms_sql.execute(l_cursor);
775: l_rows := dbms_sql.fetch_rows(l_cursor);
776: dbms_sql.column_value(l_cursor, 1, l_sql_value);

Line 773: dbms_sql.define_column(l_cursor, 1, l_sql_value, 255 );

769: BEGIN
770: l_cursor := dbms_sql.open_cursor;
771: dbms_sql.parse(l_cursor, l_value_set_lookup, dbms_sql.v7);
772: dbms_sql.bind_variable(l_cursor, ':value', l_argument(l_arg_cnt));
773: dbms_sql.define_column(l_cursor, 1, l_sql_value, 255 );
774: l_rows := dbms_sql.execute(l_cursor);
775: l_rows := dbms_sql.fetch_rows(l_cursor);
776: dbms_sql.column_value(l_cursor, 1, l_sql_value);
777:

Line 774: l_rows := dbms_sql.execute(l_cursor);

770: l_cursor := dbms_sql.open_cursor;
771: dbms_sql.parse(l_cursor, l_value_set_lookup, dbms_sql.v7);
772: dbms_sql.bind_variable(l_cursor, ':value', l_argument(l_arg_cnt));
773: dbms_sql.define_column(l_cursor, 1, l_sql_value, 255 );
774: l_rows := dbms_sql.execute(l_cursor);
775: l_rows := dbms_sql.fetch_rows(l_cursor);
776: dbms_sql.column_value(l_cursor, 1, l_sql_value);
777:
778: EXCEPTION

Line 775: l_rows := dbms_sql.fetch_rows(l_cursor);

771: dbms_sql.parse(l_cursor, l_value_set_lookup, dbms_sql.v7);
772: dbms_sql.bind_variable(l_cursor, ':value', l_argument(l_arg_cnt));
773: dbms_sql.define_column(l_cursor, 1, l_sql_value, 255 );
774: l_rows := dbms_sql.execute(l_cursor);
775: l_rows := dbms_sql.fetch_rows(l_cursor);
776: dbms_sql.column_value(l_cursor, 1, l_sql_value);
777:
778: EXCEPTION
779: WHEN OTHERS THEN

Line 776: dbms_sql.column_value(l_cursor, 1, l_sql_value);

772: dbms_sql.bind_variable(l_cursor, ':value', l_argument(l_arg_cnt));
773: dbms_sql.define_column(l_cursor, 1, l_sql_value, 255 );
774: l_rows := dbms_sql.execute(l_cursor);
775: l_rows := dbms_sql.fetch_rows(l_cursor);
776: dbms_sql.column_value(l_cursor, 1, l_sql_value);
777:
778: EXCEPTION
779: WHEN OTHERS THEN
780: l_sql_value := NULL;

Line 783: IF dbms_sql.is_open(l_cursor) THEN

779: WHEN OTHERS THEN
780: l_sql_value := NULL;
781: END;
782:
783: IF dbms_sql.is_open(l_cursor) THEN
784: dbms_sql.close_cursor(l_cursor);
785: END IF;
786:
787: IF l_sql_value IS NOT NULL THEN

Line 784: dbms_sql.close_cursor(l_cursor);

780: l_sql_value := NULL;
781: END;
782:
783: IF dbms_sql.is_open(l_cursor) THEN
784: dbms_sql.close_cursor(l_cursor);
785: END IF;
786:
787: IF l_sql_value IS NOT NULL THEN
788: l_argument(l_arg_cnt) := l_sql_value;