APPS.AD_LONGTOLOB_PKG dependencies on DBMS_SQL

Line 656: ' rowtab dbms_sql.urowid_table;'||

652: ' cursor c_tab2 is'||
653: ' select apps_rowid, '||l_lob_value_col_name||
654: ' from ad_long_conv_temp2;'||
655: ''||
656: ' rowtab dbms_sql.urowid_table;'||
657: ''||
658: ' begin'||
659: ' open c_tab;'||
660: ''||

Line 726: l_cursor := DBMS_SQL.OPEN_CURSOR;

722: l_offset INTEGER; -- the byte position in the LONG column at which
723:
724: BEGIN
725: l_stmt := 'SELECT '||p_Long_Column_Name||' FROM '||p_Table_Name||' WHERE ROWID = '''||p_Rowid||'''';
726: l_cursor := DBMS_SQL.OPEN_CURSOR;
727: DBMS_SQL.PARSE(l_cursor, l_stmt, DBMS_SQL.NATIVE);
728: --
729: --Define the LONG column.
730: --

Line 727: DBMS_SQL.PARSE(l_cursor, l_stmt, DBMS_SQL.NATIVE);

723:
724: BEGIN
725: l_stmt := 'SELECT '||p_Long_Column_Name||' FROM '||p_Table_Name||' WHERE ROWID = '''||p_Rowid||'''';
726: l_cursor := DBMS_SQL.OPEN_CURSOR;
727: DBMS_SQL.PARSE(l_cursor, l_stmt, DBMS_SQL.NATIVE);
728: --
729: --Define the LONG column.
730: --
731: DBMS_SQL.DEFINE_COLUMN_LONG(l_cursor, 1);

Line 731: DBMS_SQL.DEFINE_COLUMN_LONG(l_cursor, 1);

727: DBMS_SQL.PARSE(l_cursor, l_stmt, DBMS_SQL.NATIVE);
728: --
729: --Define the LONG column.
730: --
731: DBMS_SQL.DEFINE_COLUMN_LONG(l_cursor, 1);
732: --
733: -- Execute the query.
734: --
735: l_ignore := DBMS_SQL.EXECUTE(l_cursor);

Line 735: l_ignore := DBMS_SQL.EXECUTE(l_cursor);

731: DBMS_SQL.DEFINE_COLUMN_LONG(l_cursor, 1);
732: --
733: -- Execute the query.
734: --
735: l_ignore := DBMS_SQL.EXECUTE(l_cursor);
736:
737: IF DBMS_SQL.FETCH_ROWS(l_cursor) > 0 THEN
738: l_offset := 0;
739: l_row_length := 0;

Line 737: IF DBMS_SQL.FETCH_ROWS(l_cursor) > 0 THEN

733: -- Execute the query.
734: --
735: l_ignore := DBMS_SQL.EXECUTE(l_cursor);
736:
737: IF DBMS_SQL.FETCH_ROWS(l_cursor) > 0 THEN
738: l_offset := 0;
739: l_row_length := 0;
740: --
741: -- Get the value of the LONG column piece by piece. Here a loop

Line 749: DBMS_SQL.COLUMN_VALUE_LONG(l_cursor, 1, num_bytes, l_offset, out_val, out_length);

745: LOOP
746: --
747: -- Get the value of a portion of the LONG column.
748: --
749: DBMS_SQL.COLUMN_VALUE_LONG(l_cursor, 1, num_bytes, l_offset, out_val, out_length);
750: IF out_length <> 0 THEN
751: l_offset := l_offset + num_bytes;
752: l_row_length := l_row_length + out_length;
753: ELSE

Line 763: DBMS_SQL.CLOSE_CURSOR(l_cursor);

759: END LOOP;
760: ELSE
761: l_row_length := 0;
762: END IF;
763: DBMS_SQL.CLOSE_CURSOR(l_cursor);
764: RETURN l_row_length ;
765: EXCEPTION
766: WHEN OTHERS THEN
767: -- DBMS_OUTPUT.PUT_LINE ('Errors in function get_long_length');

Line 769: IF DBMS_SQL.is_open(l_cursor) THEN

765: EXCEPTION
766: WHEN OTHERS THEN
767: -- DBMS_OUTPUT.PUT_LINE ('Errors in function get_long_length');
768: -- DBMS_OUTPUT.PUT_LINE(sqlerrm);
769: IF DBMS_SQL.is_open(l_cursor) THEN
770: DBMS_SQL.CLOSE_CURSOR(l_cursor);
771: END IF;
772: END;
773:

Line 770: DBMS_SQL.CLOSE_CURSOR(l_cursor);

766: WHEN OTHERS THEN
767: -- DBMS_OUTPUT.PUT_LINE ('Errors in function get_long_length');
768: -- DBMS_OUTPUT.PUT_LINE(sqlerrm);
769: IF DBMS_SQL.is_open(l_cursor) THEN
770: DBMS_SQL.CLOSE_CURSOR(l_cursor);
771: END IF;
772: END;
773:
774: PROCEDURE write_long_rep