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 371: l_article_text_length := DBMS_LOB.GETLENGTH(p_article_text);

367: l_invalid_var_intent Varchar2(1) := null;
368:
369: BEGIN
370: okc_debug.log('100: Entering parse_n_replace_text', 2);
371: l_article_text_length := DBMS_LOB.GETLENGTH(p_article_text);
372: l_amount_left_to_read := l_article_text_length;
373: --dbms_output.put_line('the lenght of the article text clob' || l_article_text_length);
374:
375: --DBMS_LOB.CREATETEMPORARY(l_clob,true);

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

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

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

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

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

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

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

387: -- made changes for bug3697706 june 17th 2004 checking for 3333 instead of 8000
388: if l_amount_left_to_read > 3333
389: then
390:
391: dbms_lob.read (p_article_text, l_max_read_amount, l_read_start_position, l_temp_art_text);-- dbms_lob returns in chars
392: --special_char_decoders(l_temp_art_text);
393: --dbms_output.put_line(' read clob amount = ' || l_max_read_amount|| 'l_read_start_position = ' || l_read_start_position);
394:
395: l_read_start_position := l_read_start_position + l_max_read_amount; -- in chars

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

397: l_amount_left_to_read := l_amount_left_to_read - l_max_read_amount; -- in chars
398: -- made changes for bug3697706 june 17th 2004 checking for 3333 instead of 8000
399: elsif l_amount_left_to_read < 3333 then
400: --dbms_output.put_line(' if length to read is less than 4000');
401: dbms_lob.read(p_article_text, l_amount_left_to_read, l_read_start_position, l_temp_art_text); -- in chars.
402: --special_char_decoders(l_temp_art_text);
403: l_amount_left_to_read := 0;
404: end if;
405: elsif l_tag_not_closed_read_more

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

408: -- made changes for bug3697706 june 17th 2004 checking for 3333 instead of 8000
409: if( (length(l_temp_tag_unclosed) + l_amount_left_to_read)< 3333) -- in chars
410: then
411: --dbms_output.put_line(' if tag not ***1 ');
412: dbms_lob.read(p_article_text, l_amount_left_to_read, l_read_start_position, l_temp_art_text);
413: --special_char_decoders(l_temp_art_text);
414: l_temp_art_text := l_temp_tag_unclosed || l_temp_art_text;
415: --dbms_output.put_line(' if tag not ***1 -- ' || l_amount_left_to_read ||'readstart' || l_read_start_position );
416:

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

419: then
420: l_max_read_amount := l_max_read_amount - length(l_temp_tag_unclosed);
421:
422: --dbms_output.put_line(' if tag not ***2 ');
423: dbms_lob.read(p_article_text, l_max_read_amount , 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: l_read_start_position := l_read_start_position + l_max_read_amount;
427:

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

469: RAISE FND_API.G_EXC_ERROR ;
470: END IF;
471:
472: end if;
473: if (l_art_text_with_tags is null and dbms_lob.getlength(p_dest_clob)
474: = 0 )then
475:
476: l_art_text_with_tags := SUBSTR(l_temp_art_text,1,(l_tag_start_postion - 1 ));
477:

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

513: l_check_length := length(l_art_text_with_tags);
514: --dbms_output.put_line(' lessthat 4000 - 66');
515: if (l_check_length > 0) then
516: --dbms_output.put_line(' flushing into clob ');
517: dbms_lob.writeappend ( p_dest_clob, l_check_length, l_art_text_with_tags);
518:
519: end if;
520: --dbms_output.put_line(' here 99');
521:

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

524: --dbms_output.put_line(' VAR NOT FOUND 3 ');
525: x_return_status := G_RET_STS_ERROR;
526: elsif ((not (nvl(l_return_status,'S') = G_VAR_NOT_FOUND_RET_STS) )
527: and (p_replace_text = 'Y') ) then
528: p_dest_clob_length := DBMS_LOB.GETLENGTH(p_dest_clob);
529: if (p_calling_mode = 'CALLED_FROM_CREATE_UPDATE') then
530: -- DBMS_LOB.COPY(p_article_text, p_dest_clob, p_dest_clob_length, 1, 1);
531: -- DBMS_LOB.TRIM(p_article_text,p_dest_clob_length);
532: x_return_status := G_RET_STS_SUCCESS;

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

526: elsif ((not (nvl(l_return_status,'S') = G_VAR_NOT_FOUND_RET_STS) )
527: and (p_replace_text = 'Y') ) then
528: p_dest_clob_length := DBMS_LOB.GETLENGTH(p_dest_clob);
529: if (p_calling_mode = 'CALLED_FROM_CREATE_UPDATE') then
530: -- DBMS_LOB.COPY(p_article_text, p_dest_clob, p_dest_clob_length, 1, 1);
531: -- DBMS_LOB.TRIM(p_article_text,p_dest_clob_length);
532: x_return_status := G_RET_STS_SUCCESS;
533: else
534: x_return_status := G_RET_STS_SUCCESS;

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

527: and (p_replace_text = 'Y') ) then
528: p_dest_clob_length := DBMS_LOB.GETLENGTH(p_dest_clob);
529: if (p_calling_mode = 'CALLED_FROM_CREATE_UPDATE') then
530: -- DBMS_LOB.COPY(p_article_text, p_dest_clob, p_dest_clob_length, 1, 1);
531: -- DBMS_LOB.TRIM(p_article_text,p_dest_clob_length);
532: x_return_status := G_RET_STS_SUCCESS;
533: else
534: x_return_status := G_RET_STS_SUCCESS;
535: end if;

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

536: else
537: x_return_status := G_RET_STS_SUCCESS;
538: end if;
539:
540: --dbms_lob.freetemporary(l_clob);
541: --dbms_lob.freetemporary(p_dest_clob);
542: okc_debug.log('100: Leaving parse_n_replace_text', 2);
543: EXCEPTION
544: WHEN G_VAR_NOT_FOUND then

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

537: x_return_status := G_RET_STS_SUCCESS;
538: end if;
539:
540: --dbms_lob.freetemporary(l_clob);
541: --dbms_lob.freetemporary(p_dest_clob);
542: okc_debug.log('100: Leaving parse_n_replace_text', 2);
543: EXCEPTION
544: WHEN G_VAR_NOT_FOUND then
545: --dbms_output.put_line(' VAR NOT FOUND 1 ');

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

2329: RAISE FND_API.G_EXC_ERROR ;
2330: END IF;
2331:
2332: l_article_text := p_article_text;
2333: DBMS_LOB.CREATETEMPORARY(l_clob,true);
2334: parse_n_replace_text(
2335: p_api_version => p_api_version,
2336: p_init_msg_list => p_init_msg_list,
2337: p_article_text => l_article_text,

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

2344: x_msg_count => x_msg_count,
2345: x_msg_data => x_msg_data,
2346: x_variables_tbl => l_variable_code_tbl
2347: ) ;
2348: --dbms_lob.freetemporary(l_clob);
2349: --------------------------------------------
2350: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2351: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2352: ELSIF (x_return_status = G_RET_STS_ERROR) THEN

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

2869: -- nvl added to cater to non-standard articles. Std Articles will never be of NULL status
2870:
2871: IF p_article_text is NOT NULL AND
2872: nvl(l_article_status,'DRAFT') IN ('DRAFT','REJECTED') THEN
2873: DBMS_LOB.CREATETEMPORARY(l_clob,true);
2874: parse_n_replace_text(
2875: p_api_version => p_api_version,
2876: p_init_msg_list => p_init_msg_list,
2877: p_article_text => l_article_text,

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

2884: x_msg_count => x_msg_count,
2885: x_msg_data => x_msg_data,
2886: x_variables_tbl => l_variable_code_tbl
2887: ) ;
2888: --dbms_lob.freetemporary(l_clob);
2889: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2890: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2891: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2892: RAISE FND_API.G_EXC_ERROR ;