APPS.JL_BR_SPED_DATA_EXTRACT_PKG dependencies on DBMS_LOB

Line 6422: l_data_length := DBMS_LOB.GETLENGTH(l_lob_data); --getting the total length of rtf file

6418: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
6419: END IF;
6420: END;
6421:
6422: l_data_length := DBMS_LOB.GETLENGTH(l_lob_data); --getting the total length of rtf file
6423:
6424: -- FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': '||l_api_name||'(): Length of '||l_file_ids_rec.file_id ||' is:' ||l_data_length);
6425:
6426: WHILE (l_read_length < l_data_length )

Line 6429: DBMS_LOB.READ(l_lob_data,l_amount_to_read,l_read_length,l_data_var_raw); --reading lob data. l_amount_to_read is IN OUT parameter.

6425:
6426: WHILE (l_read_length < l_data_length )
6427: LOOP
6428:
6429: DBMS_LOB.READ(l_lob_data,l_amount_to_read,l_read_length,l_data_var_raw); --reading lob data. l_amount_to_read is IN OUT parameter.
6430:
6431: l_data_var_char := UTL_RAW.CAST_TO_VARCHAR2(TO_CHAR(l_data_var_raw));
6432:
6433: INSERT INTO jl_br_sped_extr_data_t