APPS.AMS_CPAGEUTILITY_PVT dependencies on DBMS_LOB

Line 6178: l_length := dbms_lob.getlength(l_blob);

6174: from fnd_lobs
6175: where file_id = p_file_id
6176: for update;
6177:
6178: l_length := dbms_lob.getlength(l_blob);
6179: AMS_UTILITY_PVT.debug_message('Length of lob erased : '||TO_CHAR(l_length));
6180:
6181: dbms_lob.erase(l_blob,l_length,1);
6182: dbms_lob.trim(l_blob,0);

Line 6181: dbms_lob.erase(l_blob,l_length,1);

6177:
6178: l_length := dbms_lob.getlength(l_blob);
6179: AMS_UTILITY_PVT.debug_message('Length of lob erased : '||TO_CHAR(l_length));
6180:
6181: dbms_lob.erase(l_blob,l_length,1);
6182: dbms_lob.trim(l_blob,0);
6183:
6184: x_blob := l_blob;
6185:

Line 6182: dbms_lob.trim(l_blob,0);

6178: l_length := dbms_lob.getlength(l_blob);
6179: AMS_UTILITY_PVT.debug_message('Length of lob erased : '||TO_CHAR(l_length));
6180:
6181: dbms_lob.erase(l_blob,l_length,1);
6182: dbms_lob.trim(l_blob,0);
6183:
6184: x_blob := l_blob;
6185:
6186: AMS_UTILITY_PVT.debug_message('erase successful');