eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_ARTICLES_GRP dependencies on DBMS_LOB

Line 131: --dbms_lob.writeappend ( p_clob_large, p_art_str_w_tags_length, p_art_text_with_tags);

127: then
128:
129: -- changed for Bug 3697706 using length() to get length in chars instead of
130: -- using the already calculated p_art_str_w_tags_length which is in bytes
131: --dbms_lob.writeappend ( p_clob_large, p_art_str_w_tags_length, p_art_text_with_tags);
132: dbms_lob.writeappend ( p_clob_large, length(p_art_text_with_tags), p_art_text_with_tags);
133:
134: end if;
135: if (p_append_str_length > 0)

Line 132: dbms_lob.writeappend ( p_clob_large, length(p_art_text_with_tags), p_art_text_with_tags);

128:
129: -- changed for Bug 3697706 using length() to get length in chars instead of
130: -- using the already calculated p_art_str_w_tags_length which is in bytes
131: --dbms_lob.writeappend ( p_clob_large, p_art_str_w_tags_length, p_art_text_with_tags);
132: dbms_lob.writeappend ( p_clob_large, length(p_art_text_with_tags), p_art_text_with_tags);
133:
134: end if;
135: if (p_append_str_length > 0)
136: then

Line 141: -- dbms_lob.writeappend ( p_clob_large, p_append_str_length, p_append_str);

137: -- dbms_output.put_line(' ***IN CHECK LENGTH writing into clob 111**');
138:
139: -- changed for Bug 3697706 using length() to get length in chars instead of
140: -- using the already calculated p_append_str_length which is in bytes
141: -- dbms_lob.writeappend ( p_clob_large, p_append_str_length, p_append_str);
142: dbms_lob.writeappend ( p_clob_large, length(p_append_str), p_append_str);
143:
144: end if;
145: else

Line 142: dbms_lob.writeappend ( p_clob_large, length(p_append_str), p_append_str);

138:
139: -- changed for Bug 3697706 using length() to get length in chars instead of
140: -- using the already calculated p_append_str_length which is in bytes
141: -- dbms_lob.writeappend ( p_clob_large, p_append_str_length, p_append_str);
142: dbms_lob.writeappend ( p_clob_large, length(p_append_str), p_append_str);
143:
144: end if;
145: else
146: --dbms_output.put_line(' ***IN CHECK LENGTH writing into clob 222**');

Line 150: --dbms_lob.writeappend ( p_clob_large,l_check_length , (p_art_text_with_tags || p_append_str));

146: --dbms_output.put_line(' ***IN CHECK LENGTH writing into clob 222**');
147:
148: -- changed for Bug 3697706 using length() to get length in chars instead of
149: -- using the already calculated l_check_length which is in bytes
150: --dbms_lob.writeappend ( p_clob_large,l_check_length , (p_art_text_with_tags || p_append_str));
151: dbms_lob.writeappend ( p_clob_large,length(p_art_text_with_tags || p_append_str) , (p_art_text_with_tags || p_append_str));
152:
153: -- dbms_output.put_line(' ***IN CHECK LENGTH writing into clob 222**');
154:

Line 151: dbms_lob.writeappend ( p_clob_large,length(p_art_text_with_tags || p_append_str) , (p_art_text_with_tags || p_append_str));

147:
148: -- changed for Bug 3697706 using length() to get length in chars instead of
149: -- using the already calculated l_check_length which is in bytes
150: --dbms_lob.writeappend ( p_clob_large,l_check_length , (p_art_text_with_tags || p_append_str));
151: dbms_lob.writeappend ( p_clob_large,length(p_art_text_with_tags || p_append_str) , (p_art_text_with_tags || p_append_str));
152:
153: -- dbms_output.put_line(' ***IN CHECK LENGTH writing into clob 222**');
154:
155: end if ;

Line 375: l_article_text_length := DBMS_LOB.GETLENGTH(p_article_text);

371:
372:
373: BEGIN
374: okc_debug.log('100: Entering parse_n_replace_text', 2);
375: l_article_text_length := DBMS_LOB.GETLENGTH(p_article_text);
376: l_amount_left_to_read := l_article_text_length;
377: --dbms_output.put_line('the lenght of the article text clob' || l_article_text_length);
378:
379: --DBMS_LOB.CREATETEMPORARY(l_clob,true);

Line 379: --DBMS_LOB.CREATETEMPORARY(l_clob,true);

375: l_article_text_length := DBMS_LOB.GETLENGTH(p_article_text);
376: l_amount_left_to_read := l_article_text_length;
377: --dbms_output.put_line('the lenght of the article text clob' || l_article_text_length);
378:
379: --DBMS_LOB.CREATETEMPORARY(l_clob,true);
380: --DBMS_LOB.CREATETEMPORARY(p_dest_clob,true);
381: --DBMS_LOB.COPY(l_clob, p_article_text, l_article_text_length, 1, 1);
382:
383: while (l_amount_left_to_read > 0 ) loop

Line 380: --DBMS_LOB.CREATETEMPORARY(p_dest_clob,true);

376: l_amount_left_to_read := l_article_text_length;
377: --dbms_output.put_line('the lenght of the article text clob' || l_article_text_length);
378:
379: --DBMS_LOB.CREATETEMPORARY(l_clob,true);
380: --DBMS_LOB.CREATETEMPORARY(p_dest_clob,true);
381: --DBMS_LOB.COPY(l_clob, p_article_text, l_article_text_length, 1, 1);
382:
383: while (l_amount_left_to_read > 0 ) loop
384: -- made changes for bug3697706 june 17th 2004 l_max_read_amount is set to 3333 instead of 8000

Line 381: --DBMS_LOB.COPY(l_clob, p_article_text, l_article_text_length, 1, 1);

377: --dbms_output.put_line('the lenght of the article text clob' || l_article_text_length);
378:
379: --DBMS_LOB.CREATETEMPORARY(l_clob,true);
380: --DBMS_LOB.CREATETEMPORARY(p_dest_clob,true);
381: --DBMS_LOB.COPY(l_clob, p_article_text, l_article_text_length, 1, 1);
382:
383: while (l_amount_left_to_read > 0 ) loop
384: -- made changes for bug3697706 june 17th 2004 l_max_read_amount is set to 3333 instead of 8000
385: -- the max size we are putting in our varchar2 is 10000 bytes i.e. max of 3333 chars in a tri-byte

Line 396: dbms_lob.read (p_article_text, l_chk_max_read_amt, (l_read_start_position+l_max_read_amount-1), l_chk_split);-- dbms_lob returns in chars

392: if l_amount_left_to_read > 3333
393: then
394:
395: -- bug 12593967 starts
396: dbms_lob.read (p_article_text, l_chk_max_read_amt, (l_read_start_position+l_max_read_amount-1), l_chk_split);-- dbms_lob returns in chars
397: IF l_chk_split='[@' THEN
398: l_max_read_amount := l_max_read_amount-1;
399: END IF;
400: -- bug 12593967 Ends

Line 402: dbms_lob.read (p_article_text, l_max_read_amount, l_read_start_position, l_temp_art_text);-- dbms_lob returns in chars

398: l_max_read_amount := l_max_read_amount-1;
399: END IF;
400: -- bug 12593967 Ends
401:
402: dbms_lob.read (p_article_text, l_max_read_amount, l_read_start_position, l_temp_art_text);-- dbms_lob returns in chars
403: --special_char_decoders(l_temp_art_text);
404: --dbms_output.put_line(' read clob amount = ' || l_max_read_amount|| 'l_read_start_position = ' || l_read_start_position);
405:
406: l_read_start_position := l_read_start_position + l_max_read_amount; -- in chars

Line 412: dbms_lob.read(p_article_text, l_amount_left_to_read, l_read_start_position, l_temp_art_text); -- in chars.

408: l_amount_left_to_read := l_amount_left_to_read - l_max_read_amount; -- in chars
409: -- made changes for bug3697706 june 17th 2004 checking for 3333 instead of 8000
410: elsif l_amount_left_to_read < 3333 then
411: --dbms_output.put_line(' if length to read is less than 4000');
412: dbms_lob.read(p_article_text, l_amount_left_to_read, l_read_start_position, l_temp_art_text); -- in chars.
413: --special_char_decoders(l_temp_art_text);
414: l_amount_left_to_read := 0;
415: end if;
416: elsif l_tag_not_closed_read_more

Line 423: dbms_lob.read(p_article_text, l_amount_left_to_read, l_read_start_position, l_temp_art_text);

419: -- made changes for bug3697706 june 17th 2004 checking for 3333 instead of 8000
420: if( (length(l_temp_tag_unclosed) + l_amount_left_to_read)< 3333) -- in chars
421: then
422: --dbms_output.put_line(' if tag not ***1 ');
423: dbms_lob.read(p_article_text, l_amount_left_to_read, l_read_start_position, l_temp_art_text);
424: --special_char_decoders(l_temp_art_text);
425: l_temp_art_text := l_temp_tag_unclosed || l_temp_art_text;
426: --dbms_output.put_line(' if tag not ***1 -- ' || l_amount_left_to_read ||'readstart' || l_read_start_position );
427:

Line 434: dbms_lob.read(p_article_text, l_max_read_amount , l_read_start_position, l_temp_art_text);

430: then
431: l_max_read_amount := l_max_read_amount - length(l_temp_tag_unclosed);
432:
433: --dbms_output.put_line(' if tag not ***2 ');
434: dbms_lob.read(p_article_text, l_max_read_amount , l_read_start_position, l_temp_art_text);
435: --special_char_decoders(l_temp_art_text);
436: l_temp_art_text := l_temp_tag_unclosed || l_temp_art_text;
437: l_read_start_position := l_read_start_position + l_max_read_amount;
438:

Line 484: if (l_art_text_with_tags is null and dbms_lob.getlength(p_dest_clob)

480: RAISE FND_API.G_EXC_ERROR ;
481: END IF;
482:
483: end if;
484: if (l_art_text_with_tags is null and dbms_lob.getlength(p_dest_clob)
485: = 0 )then
486:
487: l_art_text_with_tags := SUBSTR(l_temp_art_text,1,(l_tag_start_postion - 1 ));
488:

Line 528: dbms_lob.writeappend ( p_dest_clob, l_check_length, l_art_text_with_tags);

524: l_check_length := length(l_art_text_with_tags);
525: --dbms_output.put_line(' lessthat 4000 - 66');
526: if (l_check_length > 0) then
527: --dbms_output.put_line(' flushing into clob ');
528: dbms_lob.writeappend ( p_dest_clob, l_check_length, l_art_text_with_tags);
529:
530: end if;
531: --dbms_output.put_line(' here 99');
532:

Line 539: p_dest_clob_length := DBMS_LOB.GETLENGTH(p_dest_clob);

535: --dbms_output.put_line(' VAR NOT FOUND 3 ');
536: x_return_status := G_RET_STS_ERROR;
537: elsif ((not (nvl(l_return_status,'S') = G_VAR_NOT_FOUND_RET_STS) )
538: and (p_replace_text = 'Y') ) then
539: p_dest_clob_length := DBMS_LOB.GETLENGTH(p_dest_clob);
540: if (p_calling_mode = 'CALLED_FROM_CREATE_UPDATE') then
541: -- DBMS_LOB.COPY(p_article_text, p_dest_clob, p_dest_clob_length, 1, 1);
542: -- DBMS_LOB.TRIM(p_article_text,p_dest_clob_length);
543: x_return_status := G_RET_STS_SUCCESS;

Line 541: -- DBMS_LOB.COPY(p_article_text, p_dest_clob, p_dest_clob_length, 1, 1);

537: elsif ((not (nvl(l_return_status,'S') = G_VAR_NOT_FOUND_RET_STS) )
538: and (p_replace_text = 'Y') ) then
539: p_dest_clob_length := DBMS_LOB.GETLENGTH(p_dest_clob);
540: if (p_calling_mode = 'CALLED_FROM_CREATE_UPDATE') then
541: -- DBMS_LOB.COPY(p_article_text, p_dest_clob, p_dest_clob_length, 1, 1);
542: -- DBMS_LOB.TRIM(p_article_text,p_dest_clob_length);
543: x_return_status := G_RET_STS_SUCCESS;
544: else
545: x_return_status := G_RET_STS_SUCCESS;

Line 542: -- DBMS_LOB.TRIM(p_article_text,p_dest_clob_length);

538: and (p_replace_text = 'Y') ) then
539: p_dest_clob_length := DBMS_LOB.GETLENGTH(p_dest_clob);
540: if (p_calling_mode = 'CALLED_FROM_CREATE_UPDATE') then
541: -- DBMS_LOB.COPY(p_article_text, p_dest_clob, p_dest_clob_length, 1, 1);
542: -- DBMS_LOB.TRIM(p_article_text,p_dest_clob_length);
543: x_return_status := G_RET_STS_SUCCESS;
544: else
545: x_return_status := G_RET_STS_SUCCESS;
546: end if;

Line 551: --dbms_lob.freetemporary(l_clob);

547: else
548: x_return_status := G_RET_STS_SUCCESS;
549: end if;
550:
551: --dbms_lob.freetemporary(l_clob);
552: --dbms_lob.freetemporary(p_dest_clob);
553: okc_debug.log('100: Leaving parse_n_replace_text', 2);
554: EXCEPTION
555: WHEN G_VAR_NOT_FOUND then

Line 552: --dbms_lob.freetemporary(p_dest_clob);

548: x_return_status := G_RET_STS_SUCCESS;
549: end if;
550:
551: --dbms_lob.freetemporary(l_clob);
552: --dbms_lob.freetemporary(p_dest_clob);
553: okc_debug.log('100: Leaving parse_n_replace_text', 2);
554: EXCEPTION
555: WHEN G_VAR_NOT_FOUND then
556: --dbms_output.put_line(' VAR NOT FOUND 1 ');

Line 2389: DBMS_LOB.CREATETEMPORARY(l_clob,true);

2385: RAISE FND_API.G_EXC_ERROR ;
2386: END IF;
2387:
2388: l_article_text := p_article_text;
2389: DBMS_LOB.CREATETEMPORARY(l_clob,true);
2390: parse_n_replace_text(
2391: p_api_version => p_api_version,
2392: p_init_msg_list => p_init_msg_list,
2393: p_article_text => l_article_text,

Line 2404: --dbms_lob.freetemporary(l_clob);

2400: x_msg_count => x_msg_count,
2401: x_msg_data => x_msg_data,
2402: x_variables_tbl => l_variable_code_tbl
2403: ) ;
2404: --dbms_lob.freetemporary(l_clob);
2405: --------------------------------------------
2406: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2407: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2408: ELSIF (x_return_status = G_RET_STS_ERROR) THEN

Line 2980: DBMS_LOB.CREATETEMPORARY(l_clob,true);

2976: -- nvl added to cater to non-standard articles. Std Articles will never be of NULL status
2977:
2978: IF p_article_text is NOT NULL AND
2979: nvl(l_article_status,'DRAFT') IN ('DRAFT','REJECTED') THEN
2980: DBMS_LOB.CREATETEMPORARY(l_clob,true);
2981: parse_n_replace_text(
2982: p_api_version => p_api_version,
2983: p_init_msg_list => p_init_msg_list,
2984: p_article_text => l_article_text,

Line 2995: --dbms_lob.freetemporary(l_clob);

2991: x_msg_count => x_msg_count,
2992: x_msg_data => x_msg_data,
2993: x_variables_tbl => l_variable_code_tbl
2994: ) ;
2995: --dbms_lob.freetemporary(l_clob);
2996: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2997: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2998: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2999: RAISE FND_API.G_EXC_ERROR ;