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_TERMS_MIGRATE_GRP dependencies on DBMS_LOB

Line 300: l_file_exists := dbms_lob.fileexists(l_from_file);

296:
297: l_from_file := bfilename('OKC_LEG_DOC_DIR', p_file_name);
298:
299: BEGIN
300: l_file_exists := dbms_lob.fileexists(l_from_file);
301: IF l_file_exists = 0 THEN
302: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
303: p_msg_name => 'OKC_TERMS_INV_FILE');
304: x_return_status := G_RET_STS_ERROR;

Line 314: WHEN DBMS_LOB.NOEXIST_DIRECTORY THEN

310: p_msg_name => 'OKC_TERMS_INV_FILE');
311: x_return_status := G_RET_STS_ERROR;
312: END IF;
313: EXCEPTION
314: WHEN DBMS_LOB.NOEXIST_DIRECTORY THEN
315: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
316: p_msg_name => 'OKC_TERMS_INV_DIR');
317: l_file_exists := 0;
318: x_return_status := G_RET_STS_ERROR;

Line 319: WHEN DBMS_LOB.NOPRIV_DIRECTORY THEN

315: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
316: p_msg_name => 'OKC_TERMS_INV_DIR');
317: l_file_exists := 0;
318: x_return_status := G_RET_STS_ERROR;
319: WHEN DBMS_LOB.NOPRIV_DIRECTORY THEN
320: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
321: p_msg_name => 'OKC_TERMS_INV_DIR');
322: l_file_exists := 0;
323: x_return_status := G_RET_STS_ERROR;

Line 324: WHEN DBMS_LOB.INVALID_DIRECTORY THEN

320: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
321: p_msg_name => 'OKC_TERMS_INV_DIR');
322: l_file_exists := 0;
323: x_return_status := G_RET_STS_ERROR;
324: WHEN DBMS_LOB.INVALID_DIRECTORY THEN
325: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
326: p_msg_name => 'OKC_TERMS_INV_DIR');
327: l_file_exists := 0;
328: x_return_status := G_RET_STS_ERROR;

Line 335: dbms_lob.fileopen(l_from_file, dbms_lob.file_readonly);

331:
332:
333: IF l_file_exists = 1 THEn
334: -- read file length
335: dbms_lob.fileopen(l_from_file, dbms_lob.file_readonly);
336: l_blob_length := dbms_lob.getlength(l_from_file);
337: dbms_lob.fileclose(l_from_file);
338: -- create blob locator
339: dbms_lob.createtemporary(l_temp_blob, false, dbms_lob.call);

Line 336: l_blob_length := dbms_lob.getlength(l_from_file);

332:
333: IF l_file_exists = 1 THEn
334: -- read file length
335: dbms_lob.fileopen(l_from_file, dbms_lob.file_readonly);
336: l_blob_length := dbms_lob.getlength(l_from_file);
337: dbms_lob.fileclose(l_from_file);
338: -- create blob locator
339: dbms_lob.createtemporary(l_temp_blob, false, dbms_lob.call);
340: -- load the blob

Line 337: dbms_lob.fileclose(l_from_file);

333: IF l_file_exists = 1 THEn
334: -- read file length
335: dbms_lob.fileopen(l_from_file, dbms_lob.file_readonly);
336: l_blob_length := dbms_lob.getlength(l_from_file);
337: dbms_lob.fileclose(l_from_file);
338: -- create blob locator
339: dbms_lob.createtemporary(l_temp_blob, false, dbms_lob.call);
340: -- load the blob
341: dbms_lob.open(l_from_file, dbms_lob.lob_readonly);

Line 339: dbms_lob.createtemporary(l_temp_blob, false, dbms_lob.call);

335: dbms_lob.fileopen(l_from_file, dbms_lob.file_readonly);
336: l_blob_length := dbms_lob.getlength(l_from_file);
337: dbms_lob.fileclose(l_from_file);
338: -- create blob locator
339: dbms_lob.createtemporary(l_temp_blob, false, dbms_lob.call);
340: -- load the blob
341: dbms_lob.open(l_from_file, dbms_lob.lob_readonly);
342: dbms_lob.open(l_temp_blob, dbms_lob.lob_readwrite);
343: dbms_lob.loadfromfile(l_temp_blob, l_from_file, l_blob_length);

Line 341: dbms_lob.open(l_from_file, dbms_lob.lob_readonly);

337: dbms_lob.fileclose(l_from_file);
338: -- create blob locator
339: dbms_lob.createtemporary(l_temp_blob, false, dbms_lob.call);
340: -- load the blob
341: dbms_lob.open(l_from_file, dbms_lob.lob_readonly);
342: dbms_lob.open(l_temp_blob, dbms_lob.lob_readwrite);
343: dbms_lob.loadfromfile(l_temp_blob, l_from_file, l_blob_length);
344: -- close handles to blob and file
345: dbms_lob.close(l_temp_blob);

Line 342: dbms_lob.open(l_temp_blob, dbms_lob.lob_readwrite);

338: -- create blob locator
339: dbms_lob.createtemporary(l_temp_blob, false, dbms_lob.call);
340: -- load the blob
341: dbms_lob.open(l_from_file, dbms_lob.lob_readonly);
342: dbms_lob.open(l_temp_blob, dbms_lob.lob_readwrite);
343: dbms_lob.loadfromfile(l_temp_blob, l_from_file, l_blob_length);
344: -- close handles to blob and file
345: dbms_lob.close(l_temp_blob);
346: dbms_lob.close(l_from_file);

Line 343: dbms_lob.loadfromfile(l_temp_blob, l_from_file, l_blob_length);

339: dbms_lob.createtemporary(l_temp_blob, false, dbms_lob.call);
340: -- load the blob
341: dbms_lob.open(l_from_file, dbms_lob.lob_readonly);
342: dbms_lob.open(l_temp_blob, dbms_lob.lob_readwrite);
343: dbms_lob.loadfromfile(l_temp_blob, l_from_file, l_blob_length);
344: -- close handles to blob and file
345: dbms_lob.close(l_temp_blob);
346: dbms_lob.close(l_from_file);
347: END IF;

Line 345: dbms_lob.close(l_temp_blob);

341: dbms_lob.open(l_from_file, dbms_lob.lob_readonly);
342: dbms_lob.open(l_temp_blob, dbms_lob.lob_readwrite);
343: dbms_lob.loadfromfile(l_temp_blob, l_from_file, l_blob_length);
344: -- close handles to blob and file
345: dbms_lob.close(l_temp_blob);
346: dbms_lob.close(l_from_file);
347: END IF;
348: return l_temp_blob;
349: EXCEPTION

Line 346: dbms_lob.close(l_from_file);

342: dbms_lob.open(l_temp_blob, dbms_lob.lob_readwrite);
343: dbms_lob.loadfromfile(l_temp_blob, l_from_file, l_blob_length);
344: -- close handles to blob and file
345: dbms_lob.close(l_temp_blob);
346: dbms_lob.close(l_from_file);
347: END IF;
348: return l_temp_blob;
349: EXCEPTION
350: WHEN OTHERS THEN

Line 948: -- Read the lob from the directory using DBMS_LOBS.

944: IF (p_contract_source = 'ATTACHED') THEN
945: l_primary_contract_doc_flag := 'Y';
946: END IF;
947:
948: -- Read the lob from the directory using DBMS_LOBS.
949: l_blob := get_blob_from_file(p_dir_name => l_attachment_file_loc,
950: p_file_name => l_attachment_file_name,
951: x_return_status => x_return_status);
952:

Line 1427: -- Read the lob from the directory using DBMS_LOBS.

1423: l_description := l_attachment_file_name;
1424: ELSE
1425: l_description := RTRIM(LTRIM(p_description));
1426: END IF;
1427: -- Read the lob from the directory using DBMS_LOBS.
1428: l_blob := get_blob_from_file(p_dir_name => l_attachment_file_loc,
1429: p_file_name => l_attachment_file_name,
1430: x_return_status => x_return_status);
1431: