APPS.OKL_CS_LC_CONTRACT_PVT dependencies on DBMS_LOB

Line 1238: clob_size := dbms_lob.getlength(p_clob);

1234: BEGIN
1235: IF p_clob IS NULL THEN
1236: RETURN NULL;
1237: ELSE
1238: clob_size := dbms_lob.getlength(p_clob);
1239: IF clob_size < amount THEN
1240: amount := clob_size;
1241: END IF;
1242: IF clob_size = 0 THEN

Line 1245: dbms_lob.READ(p_clob, amount, 1, buffer);

1241: END IF;
1242: IF clob_size = 0 THEN
1243: RETURN NULL;
1244: END IF;
1245: dbms_lob.READ(p_clob, amount, 1, buffer);
1246: IF amount > 0 THEN
1247: RETURN buffer;
1248: ELSE
1249: RETURN NULL;

Line 1276: clob_size := dbms_lob.getlength(p_clob);

1272:
1273: IF p_clob IS NULL THEN
1274: RETURN NULL;
1275: ELSE
1276: clob_size := dbms_lob.getlength(p_clob);
1277: IF clob_size < amount THEN
1278: amount := clob_size;
1279: END IF;
1280: IF clob_size = 0 THEN

Line 1283: dbms_lob.READ(p_clob, amount, 1, buffer);

1279: END IF;
1280: IF clob_size = 0 THEN
1281: RETURN NULL;
1282: END IF;
1283: dbms_lob.READ(p_clob, amount, 1, buffer);
1284: IF amount > 0 THEN
1285: RETURN buffer;
1286: ELSE
1287: RETURN NULL;