APPS.JTF_NOTES_PKG dependencies on DBMS_SQL

Line 558: v_cursor := DBMS_SQL.OPEN_CURSOR;

554: OPEN cur_object;
555: FETCH cur_object INTO l_select_id,l_select_name,l_tablename,l_where_clause;
556: CLOSE cur_object;
557:
558: v_cursor := DBMS_SQL.OPEN_CURSOR;
559:
560: If l_where_clause is not null then
561: v_create_string := 'SELECT '||l_select_name||' FROM '||l_tablename||
562: ' WHERE '||l_select_id||' = '||p_note_context_type_id||

Line 570: DBMS_SQL.PARSE(v_cursor,v_create_string,DBMS_SQL.V7);

566: ' WHERE '||l_select_id||' = '||p_note_context_type_id;
567: end if;
568: -- dbms_output.put_line('string is '||v_create_string);
569:
570: DBMS_SQL.PARSE(v_cursor,v_create_string,DBMS_SQL.V7);
571: DBMS_SQL.DEFINE_COLUMN(v_cursor,1,l_note_context_value,80);
572: v_numrows := DBMS_SQL.EXECUTE(v_cursor);
573:
574: v_numrows := DBMS_SQL.FETCH_ROWS(v_cursor);

Line 571: DBMS_SQL.DEFINE_COLUMN(v_cursor,1,l_note_context_value,80);

567: end if;
568: -- dbms_output.put_line('string is '||v_create_string);
569:
570: DBMS_SQL.PARSE(v_cursor,v_create_string,DBMS_SQL.V7);
571: DBMS_SQL.DEFINE_COLUMN(v_cursor,1,l_note_context_value,80);
572: v_numrows := DBMS_SQL.EXECUTE(v_cursor);
573:
574: v_numrows := DBMS_SQL.FETCH_ROWS(v_cursor);
575:

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

568: -- dbms_output.put_line('string is '||v_create_string);
569:
570: DBMS_SQL.PARSE(v_cursor,v_create_string,DBMS_SQL.V7);
571: DBMS_SQL.DEFINE_COLUMN(v_cursor,1,l_note_context_value,80);
572: v_numrows := DBMS_SQL.EXECUTE(v_cursor);
573:
574: v_numrows := DBMS_SQL.FETCH_ROWS(v_cursor);
575:
576: DBMS_SQL.COLUMN_VALUE(v_cursor,1,l_note_context_value);

Line 574: v_numrows := DBMS_SQL.FETCH_ROWS(v_cursor);

570: DBMS_SQL.PARSE(v_cursor,v_create_string,DBMS_SQL.V7);
571: DBMS_SQL.DEFINE_COLUMN(v_cursor,1,l_note_context_value,80);
572: v_numrows := DBMS_SQL.EXECUTE(v_cursor);
573:
574: v_numrows := DBMS_SQL.FETCH_ROWS(v_cursor);
575:
576: DBMS_SQL.COLUMN_VALUE(v_cursor,1,l_note_context_value);
577:
578:

Line 576: DBMS_SQL.COLUMN_VALUE(v_cursor,1,l_note_context_value);

572: v_numrows := DBMS_SQL.EXECUTE(v_cursor);
573:
574: v_numrows := DBMS_SQL.FETCH_ROWS(v_cursor);
575:
576: DBMS_SQL.COLUMN_VALUE(v_cursor,1,l_note_context_value);
577:
578:
579: DBMS_SQL.CLOSE_CURSOR(v_cursor);
580:

Line 579: DBMS_SQL.CLOSE_CURSOR(v_cursor);

575:
576: DBMS_SQL.COLUMN_VALUE(v_cursor,1,l_note_context_value);
577:
578:
579: DBMS_SQL.CLOSE_CURSOR(v_cursor);
580:
581: return l_note_context_value;
582:
583: