APPS.OKC_ARTICLE_VERSIONS_PVT dependencies on DBMS_LOB

Line 512: IF dbms_lob.getlength(p_article_text) = length(G_MISS_CHAR) THEN

508: ELSIF (P_ARTICLE_VERSION_NUMBER IS NOT NULL) THEN
509: x_article_version_number := p_article_version_number;
510: END IF;
511:
512: IF dbms_lob.getlength(p_article_text) = length(G_MISS_CHAR) THEN
513: IF (dbms_lob.substr(p_article_text,dbms_lob.getlength(p_article_text)) = G_MISS_CHAR) THEN
514: x_article_text := NULL;
515: END IF;
516: ELSIF (p_ARTICLE_TEXT IS NOT NULL) THEN

Line 513: IF (dbms_lob.substr(p_article_text,dbms_lob.getlength(p_article_text)) = G_MISS_CHAR) THEN

509: x_article_version_number := p_article_version_number;
510: END IF;
511:
512: IF dbms_lob.getlength(p_article_text) = length(G_MISS_CHAR) THEN
513: IF (dbms_lob.substr(p_article_text,dbms_lob.getlength(p_article_text)) = G_MISS_CHAR) THEN
514: x_article_text := NULL;
515: END IF;
516: ELSIF (p_ARTICLE_TEXT IS NOT NULL) THEN
517: x_article_text := p_article_text;

Line 3671: DBMS_LOB.CREATETEMPORARY(c1,true);

3667: c1 CLOB;
3668:
3669: BEGIN
3670:
3671: DBMS_LOB.CREATETEMPORARY(c1,true);
3672: DBMS_LOB.OPEN(c1,dbms_lob.lob_readwrite);
3673: DBMS_LOB.WRITE(c1,1,1,' ');
3674: RETURN c1;
3675: END ArticleClob;

Line 3672: DBMS_LOB.OPEN(c1,dbms_lob.lob_readwrite);

3668:
3669: BEGIN
3670:
3671: DBMS_LOB.CREATETEMPORARY(c1,true);
3672: DBMS_LOB.OPEN(c1,dbms_lob.lob_readwrite);
3673: DBMS_LOB.WRITE(c1,1,1,' ');
3674: RETURN c1;
3675: END ArticleClob;
3676:

Line 3673: DBMS_LOB.WRITE(c1,1,1,' ');

3669: BEGIN
3670:
3671: DBMS_LOB.CREATETEMPORARY(c1,true);
3672: DBMS_LOB.OPEN(c1,dbms_lob.lob_readwrite);
3673: DBMS_LOB.WRITE(c1,1,1,' ');
3674: RETURN c1;
3675: END ArticleClob;
3676:
3677: