APPS.JTF_NOTES_PKG dependencies on DBMS_SQL

Line 561: v_cursor := DBMS_SQL.open_cursor;

557: INTO l_select_id, l_select_name, l_tablename, l_where_clause;
558:
559: CLOSE cur_object;
560:
561: v_cursor := DBMS_SQL.open_cursor;
562:
563: IF l_where_clause IS NOT NULL THEN
564: v_create_string :=
565: 'SELECT '

Line 585: DBMS_SQL.parse(v_cursor, v_create_string, DBMS_SQL.v7);

581: || l_select_id
582: || ' = :note_context_type_id';
583: END IF;
584:
585: DBMS_SQL.parse(v_cursor, v_create_string, DBMS_SQL.v7);
586:
587: DBMS_SQL.bind_variable(v_cursor, 'note_context_type_id', p_note_context_type_id);
588: DBMS_SQL.define_column(v_cursor, 1, l_note_context_value, 80);
589:

Line 587: DBMS_SQL.bind_variable(v_cursor, 'note_context_type_id', p_note_context_type_id);

583: END IF;
584:
585: DBMS_SQL.parse(v_cursor, v_create_string, DBMS_SQL.v7);
586:
587: DBMS_SQL.bind_variable(v_cursor, 'note_context_type_id', p_note_context_type_id);
588: DBMS_SQL.define_column(v_cursor, 1, l_note_context_value, 80);
589:
590: v_numrows := DBMS_SQL.EXECUTE(v_cursor);
591: v_numrows := DBMS_SQL.fetch_rows(v_cursor);

Line 588: DBMS_SQL.define_column(v_cursor, 1, l_note_context_value, 80);

584:
585: DBMS_SQL.parse(v_cursor, v_create_string, DBMS_SQL.v7);
586:
587: DBMS_SQL.bind_variable(v_cursor, 'note_context_type_id', p_note_context_type_id);
588: DBMS_SQL.define_column(v_cursor, 1, l_note_context_value, 80);
589:
590: v_numrows := DBMS_SQL.EXECUTE(v_cursor);
591: v_numrows := DBMS_SQL.fetch_rows(v_cursor);
592:

Line 590: v_numrows := DBMS_SQL.EXECUTE(v_cursor);

586:
587: DBMS_SQL.bind_variable(v_cursor, 'note_context_type_id', p_note_context_type_id);
588: DBMS_SQL.define_column(v_cursor, 1, l_note_context_value, 80);
589:
590: v_numrows := DBMS_SQL.EXECUTE(v_cursor);
591: v_numrows := DBMS_SQL.fetch_rows(v_cursor);
592:
593: DBMS_SQL.column_value(v_cursor, 1, l_note_context_value);
594: DBMS_SQL.close_cursor(v_cursor);

Line 591: v_numrows := DBMS_SQL.fetch_rows(v_cursor);

587: DBMS_SQL.bind_variable(v_cursor, 'note_context_type_id', p_note_context_type_id);
588: DBMS_SQL.define_column(v_cursor, 1, l_note_context_value, 80);
589:
590: v_numrows := DBMS_SQL.EXECUTE(v_cursor);
591: v_numrows := DBMS_SQL.fetch_rows(v_cursor);
592:
593: DBMS_SQL.column_value(v_cursor, 1, l_note_context_value);
594: DBMS_SQL.close_cursor(v_cursor);
595:

Line 593: DBMS_SQL.column_value(v_cursor, 1, l_note_context_value);

589:
590: v_numrows := DBMS_SQL.EXECUTE(v_cursor);
591: v_numrows := DBMS_SQL.fetch_rows(v_cursor);
592:
593: DBMS_SQL.column_value(v_cursor, 1, l_note_context_value);
594: DBMS_SQL.close_cursor(v_cursor);
595:
596: RETURN l_note_context_value;
597: EXCEPTION

Line 594: DBMS_SQL.close_cursor(v_cursor);

590: v_numrows := DBMS_SQL.EXECUTE(v_cursor);
591: v_numrows := DBMS_SQL.fetch_rows(v_cursor);
592:
593: DBMS_SQL.column_value(v_cursor, 1, l_note_context_value);
594: DBMS_SQL.close_cursor(v_cursor);
595:
596: RETURN l_note_context_value;
597: EXCEPTION
598: WHEN OTHERS THEN