APPS.AS_FORECAST_ACTUAL_PKG dependencies on FND_LOBS

Line 769: FROM FND_LOBS

765: l_exception VARCHAR2(500) := '';
766: BEGIN
767: SELECT DBMS_LOB.GETLENGTH(file_data), file_data, file_name
768: INTO l_lob_len, l_lob_loc, l_file_name
769: FROM FND_LOBS
770: WHERE file_id = p_file_id;
771:
772: IF SQL%NOTFOUND THEN
773: raise NO_DATA_FOUND;

Line 1056: DELETE FND_LOBS WHERE FILE_ID = p_file_id;

1052: when others then
1053: UTL_FILE.PUT_LINE(p_filehandle,'Error while deleting Fnd_documents: '||sqlerrm);
1054: End ;
1055: begin
1056: DELETE FND_LOBS WHERE FILE_ID = p_file_id;
1057: exception
1058: when others then
1059: UTL_FILE.PUT_LINE(p_filehandle,'Error while deleting lob: '||sqlerrm);
1060: End ;

Line 1115: FROM FND_LOBS

1111: END IF;
1112: ELSIF (p_op_type = 'C') THEN
1113: SELECT file_data, dbms_lob.getlength(file_data)
1114: INTO dest_lob_loc, l_temp_amt_var1
1115: FROM FND_LOBS
1116: WHERE file_id = p_file_id
1117: FOR Update;
1118: dbms_lob.erase(dest_lob_loc, l_temp_amt_var1);
1119: l_temp_amt_var1 := dbms_lob.getlength(g_temp_blob);