APPS.CSI_INV_DISCREPANCY_PKG dependencies on DBMS_LOB

Line 117: l_amount := dbms_lob.getlength(msg_rec.body_text);

113: For msg_rec in msg_cur
114: Loop
115:
116: l_amount := Null;
117: l_amount := dbms_lob.getlength(msg_rec.body_text);
118: l_msg_text := Null;
119:
120: dbms_lob.read(
121: lob_loc => msg_rec.body_text,

Line 120: dbms_lob.read(

116: l_amount := Null;
117: l_amount := dbms_lob.getlength(msg_rec.body_text);
118: l_msg_text := Null;
119:
120: dbms_lob.read(
121: lob_loc => msg_rec.body_text,
122: amount => l_amount,
123: offset => 1,
124: buffer => l_msg_text );

Line 1079: dbms_lob.createtemporary(l_theCLOB, TRUE, DBMS_LOB.session);

1075:
1076: -- l_file := oe_debug_pub.set_debug_mode('FILE');
1077: --dbms_output.put_line('inside get_report_clob');
1078:
1079: dbms_lob.createtemporary(l_theCLOB, TRUE, DBMS_LOB.session);
1080:
1081: debug('Inside CSI_SEND_REPORT.GET_REPORT_CLOB');
1082: debug('document_id = ' || document_id);
1083:

Line 1104: l_exists := dbms_lob.fileexists(l_theBFILE);

1100: -- Set the BFILE Directory and FileName
1101: l_theBFILE := BFileName(p_filedir,p_filename);
1102:
1103: -- First make certain the requested file exists
1104: l_exists := dbms_lob.fileexists(l_theBFILE);
1105:
1106: -- If the OUTPUT file does not exist then Try the Log File
1107: if l_exists = 0 then
1108:

Line 1112: l_pos := dbms_lob.getlength(document) + 1;

1108:
1109: -- reset the l_comp_stat to 'F' so we will look for the log file in the next if statement
1110: l_comp_stat := 'F';
1111: l_document := 'OUTPUT file does not exists for request id, '|| document_id ||'. Attempting to retrieve log file.';
1112: l_pos := dbms_lob.getlength(document) + 1;
1113: l_amt := length(l_document);
1114: dbms_lob.write(document,l_amt,l_pos,l_document);
1115:
1116: end if; --l_exists = 0 then (OUTPUT FILE)

Line 1114: dbms_lob.write(document,l_amt,l_pos,l_document);

1110: l_comp_stat := 'F';
1111: l_document := 'OUTPUT file does not exists for request id, '|| document_id ||'. Attempting to retrieve log file.';
1112: l_pos := dbms_lob.getlength(document) + 1;
1113: l_amt := length(l_document);
1114: dbms_lob.write(document,l_amt,l_pos,l_document);
1115:
1116: end if; --l_exists = 0 then (OUTPUT FILE)
1117: end if; -- l_comp_stat = 'C'
1118:

Line 1131: l_exists := dbms_lob.fileexists(l_theBFILE);

1127: -- Set the BFILE Directory and FileName
1128: l_theBFILE := BFileName(p_filedir,p_filename);
1129:
1130: -- First make certain the requested file exists
1131: l_exists := dbms_lob.fileexists(l_theBFILE);
1132:
1133: -- If the OUTPUT file does not exist then Try the Log File
1134: if l_exists = 0 then
1135:

Line 1137: l_pos := dbms_lob.getlength(document) + 1;

1133: -- If the OUTPUT file does not exist then Try the Log File
1134: if l_exists = 0 then
1135:
1136: l_document := 'Neither an OUTPUT or LOG file exists for request id, '|| document_id;
1137: l_pos := dbms_lob.getlength(document) + 1;
1138: l_amt := length(l_document);
1139: dbms_lob.write(document,l_amt,l_pos,l_document);
1140:
1141: end if; --l_exists = 0 then (LOG FILE)

Line 1139: dbms_lob.write(document,l_amt,l_pos,l_document);

1135:
1136: l_document := 'Neither an OUTPUT or LOG file exists for request id, '|| document_id;
1137: l_pos := dbms_lob.getlength(document) + 1;
1138: l_amt := length(l_document);
1139: dbms_lob.write(document,l_amt,l_pos,l_document);
1140:
1141: end if; --l_exists = 0 then (LOG FILE)
1142: end if; -- l_comp_stat <> 'C'
1143:

Line 1148: l_open := dbms_lob.FILEISOPEN(l_theBFILE);

1144: -- Send the OUTPUT or LOG to the notification body if the file exists
1145: if l_exists = 1 then
1146:
1147: -- to see if the file was opened using the input BFILE locators
1148: l_open := dbms_lob.FILEISOPEN(l_theBFILE);
1149:
1150: if l_open = 1 then
1151: -- File is already open so ignore
1152: null;

Line 1156: dbms_lob.fileOpen(l_theBFILE);

1152: null;
1153: debug('File already opened');
1154: else
1155: -- Open the file
1156: dbms_lob.fileOpen(l_theBFILE);
1157: debug('Opened LOG File');
1158: end if; -- l_open = 1
1159: -- Read the LOG file into the CLOB;
1160: dbms_lob.loadFromFile(dest_lob => l_theCLOB,

Line 1160: dbms_lob.loadFromFile(dest_lob => l_theCLOB,

1156: dbms_lob.fileOpen(l_theBFILE);
1157: debug('Opened LOG File');
1158: end if; -- l_open = 1
1159: -- Read the LOG file into the CLOB;
1160: dbms_lob.loadFromFile(dest_lob => l_theCLOB,
1161: src_lob => l_theBFILE,
1162: amount => dbms_lob.getLength(l_theBFILE));
1163:
1164: l_total_bytes:=dbms_lob.getLength(l_theCLOB);

Line 1162: amount => dbms_lob.getLength(l_theBFILE));

1158: end if; -- l_open = 1
1159: -- Read the LOG file into the CLOB;
1160: dbms_lob.loadFromFile(dest_lob => l_theCLOB,
1161: src_lob => l_theBFILE,
1162: amount => dbms_lob.getLength(l_theBFILE));
1163:
1164: l_total_bytes:=dbms_lob.getLength(l_theCLOB);
1165:
1166: if (display_type = 'text/html') then

Line 1164: l_total_bytes:=dbms_lob.getLength(l_theCLOB);

1160: dbms_lob.loadFromFile(dest_lob => l_theCLOB,
1161: src_lob => l_theBFILE,
1162: amount => dbms_lob.getLength(l_theBFILE));
1163:
1164: l_total_bytes:=dbms_lob.getLength(l_theCLOB);
1165:
1166: if (display_type = 'text/html') then
1167: debug('Inside the text/html');
1168:

Line 1172: l_pos := dbms_lob.getlength(document) + 1;

1168:
1169: l_document := '
' || '

' ;

1170:         l_document := l_document || '';

1171: 

1172:         l_pos := dbms_lob.getlength(document) + 1;

1173:         l_amt := length(l_document);

1174:         dbms_lob.write(document,l_amt,l_pos,l_document);

1175: 

1176:         -- Now append l_theCLOB (report) to the document;


Line 1174: dbms_lob.write(document,l_amt,l_pos,l_document);


1170: l_document := l_document || '';

1171: 

1172: l_pos := dbms_lob.getlength(document) + 1;

1173: l_amt := length(l_document);

1174: dbms_lob.write(document,l_amt,l_pos,l_document);

1175: 

1176: -- Now append l_theCLOB (report) to the document;

1177: dbms_lob.append(document, l_theCLOB);

1178: 


Line 1177: dbms_lob.append(document, l_theCLOB);


1173: l_amt := length(l_document);

1174: dbms_lob.write(document,l_amt,l_pos,l_document);

1175: 

1176: -- Now append l_theCLOB (report) to the document;

1177: dbms_lob.append(document, l_theCLOB);

1178: 

1179: -- Append a few breaks on the end;

1180: l_document := '

' || '