APPS.IEX_PROMISE_RECON_RPT_PKG dependencies on DBMS_LOB

Line 58: DBMS_LOB.INSTR (lob_loc => lob_loc,

54: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
55:
56: LOOP
57: l_end :=
58: DBMS_LOB.INSTR (lob_loc => lob_loc,
59: pattern => c_endline,
60: offset => l_start,
61: nth => 1
62: );

Line 73: DBMS_LOB.SUBSTR (lob_loc => lob_loc,

69: EXIT;
70: END IF;
71:
72: l_one_line :=
73: DBMS_LOB.SUBSTR (lob_loc => lob_loc,
74: amount => l_end - l_start,
75: offset => l_start
76: );
77: FND_FILE.put_line( FND_FILE.LOG,'l_one_line-->'||l_one_line);

Line 454: l_resultOffset := DBMS_LOB.INSTR(l_result,'>');

450:
451: IF l_rows_processed <> 0 THEN
452: FND_FILE.put_line( FND_FILE.LOG,'8') ;
453: --get the length og the rowset header
454: l_resultOffset := DBMS_LOB.INSTR(l_result,'>');
455: FND_FILE.put_line( FND_FILE.LOG,'9') ;
456: ELSE
457: l_resultOffset := 0;
458: END IF;

Line 494: l_xml_header_length := dbms_lob.getlength(l_xml_header);

490: l_xml_header := l_xml_header ||l_new_line||' ' ||TO_CHAR(l_sysdate,'YYYY-MM-DD')||'';
491: l_xml_header := l_xml_header ||l_new_line||' ';
492: l_close_tag := l_new_line||''||l_new_line;
493:
494: l_xml_header_length := dbms_lob.getlength(l_xml_header);
495: tempResult:=l_xml_header;
496:
497: IF l_rows_processed <> 0 THEN
498: --copy result set to tempResult

Line 499: dbms_lob.copy(tempResult,l_result,dbms_lob.getlength(l_result)-l_resultOffset,

495: tempResult:=l_xml_header;
496:
497: IF l_rows_processed <> 0 THEN
498: --copy result set to tempResult
499: dbms_lob.copy(tempResult,l_result,dbms_lob.getlength(l_result)-l_resultOffset,
500: l_xml_header_length,l_resultOffset);
501:
502: ELSE
503:

Line 504: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);

500: l_xml_header_length,l_resultOffset);
501:
502: ELSE
503:
504: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
505: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
506: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
507: END IF;
508:

Line 505: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);

501:
502: ELSE
503:
504: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
505: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
506: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
507: END IF;
508:
509: FND_FILE.put_line( FND_FILE.LOG,'5.base_curr'||g_base_curr);

Line 506: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);

502: ELSE
503:
504: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
505: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
506: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
507: END IF;
508:
509: FND_FILE.put_line( FND_FILE.LOG,'5.base_curr'||g_base_curr);
510: --append the close tag to tempResult

Line 511: dbms_lob.writeAppend(tempResult, length(l_close_tag), l_close_tag);

507: END IF;
508:
509: FND_FILE.put_line( FND_FILE.LOG,'5.base_curr'||g_base_curr);
510: --append the close tag to tempResult
511: dbms_lob.writeAppend(tempResult, length(l_close_tag), l_close_tag);
512: --print to the o/p file
513: print_clob(lob_loc => tempResult);
514:
515: FND_FILE.put_line( FND_FILE.LOG,'15--end') ;