APPS.OKC_ARTICLE_VERSIONS_PVT dependencies on DBMS_LOB

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

526: ELSIF (P_ARTICLE_VERSION_NUMBER IS NOT NULL) THEN
527: x_article_version_number := p_article_version_number;
528: END IF;
529:
530: IF dbms_lob.getlength(p_article_text) = length(G_MISS_CHAR) THEN
531: IF (dbms_lob.substr(p_article_text,dbms_lob.getlength(p_article_text)) = G_MISS_CHAR) THEN
532: x_article_text := NULL;
533: END IF;
534: ELSIF (p_ARTICLE_TEXT IS NOT NULL) THEN

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

527: x_article_version_number := p_article_version_number;
528: END IF;
529:
530: IF dbms_lob.getlength(p_article_text) = length(G_MISS_CHAR) THEN
531: IF (dbms_lob.substr(p_article_text,dbms_lob.getlength(p_article_text)) = G_MISS_CHAR) THEN
532: x_article_text := NULL;
533: END IF;
534: ELSIF (p_ARTICLE_TEXT IS NOT NULL) THEN
535: x_article_text := p_article_text;

Line 807: IF dbms_lob.getlength(p_article_text_in_word) = length(G_MISS_CHAR) THEN

803: ELSIF (p_edited_in_word IS NOT NULL) THEN
804: x_edited_in_word := UPPER(p_edited_in_word);
805: END IF;
806:
807: IF dbms_lob.getlength(p_article_text_in_word) = length(G_MISS_CHAR) THEN
808: IF (dbms_lob.substr(p_article_text_in_word,dbms_lob.getlength(p_article_text_in_word)) = G_MISS_CHAR) THEN
809: x_article_text_in_word := NULL;
810: END IF;
811: ELSIF (p_article_text_in_word IS NOT NULL) THEN

Line 808: IF (dbms_lob.substr(p_article_text_in_word,dbms_lob.getlength(p_article_text_in_word)) = G_MISS_CHAR) THEN

804: x_edited_in_word := UPPER(p_edited_in_word);
805: END IF;
806:
807: IF dbms_lob.getlength(p_article_text_in_word) = length(G_MISS_CHAR) THEN
808: IF (dbms_lob.substr(p_article_text_in_word,dbms_lob.getlength(p_article_text_in_word)) = G_MISS_CHAR) THEN
809: x_article_text_in_word := NULL;
810: END IF;
811: ELSIF (p_article_text_in_word IS NOT NULL) THEN
812: x_article_text_in_word := p_article_text_in_word;

Line 1127: IF ( p_article_text_in_word IS NULL OR Dbms_Lob.SubStr(p_article_text_in_word,1,1) = '00') THEN

1123: IF p_edited_in_word = 'Y' Then
1124: IF (l_debug = 'Y') THEN
1125: Okc_Debug.Log('1400: - attribute ARTICLE_TEXT_IN_WORD ', 2);
1126: END IF;
1127: IF ( p_article_text_in_word IS NULL OR Dbms_Lob.SubStr(p_article_text_in_word,1,1) = '00') THEN
1128: IF (l_debug = 'Y') THEN
1129: Okc_Debug.Log('1500: - attribute ARTICLE_TEXT_IN_WORD is invalid', 2);
1130: END IF;
1131: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_ERROR_IMPORT_WORD');

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

3822: c1 CLOB;
3823:
3824: BEGIN
3825:
3826: DBMS_LOB.CREATETEMPORARY(c1,true);
3827: DBMS_LOB.OPEN(c1,dbms_lob.lob_readwrite);
3828: DBMS_LOB.WRITE(c1,1,1,' ');
3829: RETURN c1;
3830: END ArticleClob;

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

3823:
3824: BEGIN
3825:
3826: DBMS_LOB.CREATETEMPORARY(c1,true);
3827: DBMS_LOB.OPEN(c1,dbms_lob.lob_readwrite);
3828: DBMS_LOB.WRITE(c1,1,1,' ');
3829: RETURN c1;
3830: END ArticleClob;
3831:

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

3824: BEGIN
3825:
3826: DBMS_LOB.CREATETEMPORARY(c1,true);
3827: DBMS_LOB.OPEN(c1,dbms_lob.lob_readwrite);
3828: DBMS_LOB.WRITE(c1,1,1,' ');
3829: RETURN c1;
3830: END ArticleClob;
3831:
3832: -------------------------------------

Line 3845: DBMS_LOB.CREATETEMPORARY(b1,true);

3841: b1 BLOB;
3842:
3843: BEGIN
3844:
3845: DBMS_LOB.CREATETEMPORARY(b1,true);
3846: DBMS_LOB.OPEN(b1,dbms_lob.lob_readwrite);
3847: RETURN b1;
3848: END ArticleBlob;
3849:

Line 3846: DBMS_LOB.OPEN(b1,dbms_lob.lob_readwrite);

3842:
3843: BEGIN
3844:
3845: DBMS_LOB.CREATETEMPORARY(b1,true);
3846: DBMS_LOB.OPEN(b1,dbms_lob.lob_readwrite);
3847: RETURN b1;
3848: END ArticleBlob;
3849:
3850: