APPS.OKL_CS_LC_CONTRACT_PVT dependencies on DBMS_LOB

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

1196: BEGIN
1197: IF p_clob IS NULL THEN
1198: RETURN NULL;
1199: ELSE
1200: clob_size := dbms_lob.getlength(p_clob);
1201: IF clob_size < amount THEN
1202: amount := clob_size;
1203: END IF;
1204: IF clob_size = 0 THEN

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

1203: END IF;
1204: IF clob_size = 0 THEN
1205: RETURN NULL;
1206: END IF;
1207: dbms_lob.READ(p_clob, amount, 1, buffer);
1208: IF amount > 0 THEN
1209: RETURN buffer;
1210: ELSE
1211: RETURN NULL;

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

1234:
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;