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 FND_LOBS

Line 356: l_content_type FND_LOBS.file_content_type%TYPE := 'text/plain';

352: END get_blob_from_file;
353:
354: FUNCTION get_content_type(p_file_name varchar2)
355: RETURN varchar2 IS
356: l_content_type FND_LOBS.file_content_type%TYPE := 'text/plain';
357: l_file_name varchar2(2000);
358: BEGIN
359: l_file_name := lower(p_file_name);
360: IF l_file_name LIKE '%.avi' THEN

Line 465: l_content_type FND_LOBS.file_content_type%TYPE;

461: lc_document_id OKC_TEMPLATE_USAGES.DOCUMENT_ID%TYPE := p_document_id;
462: l_dummy VARCHAR2(1) := NULL;
463: l_blob BLOB := null;
464: l_fid NUMBER;
465: l_content_type FND_LOBS.file_content_type%TYPE;
466: l_attachment_file_name FND_LOBS.file_name%TYPE;
467: l_attachment_file_loc VARCHAR2(2000);
468: l_attachment_file_desc FND_DOCUMENTS_TL.description%TYPE;
469: l_rowid VARCHAR2(120);

Line 466: l_attachment_file_name FND_LOBS.file_name%TYPE;

462: l_dummy VARCHAR2(1) := NULL;
463: l_blob BLOB := null;
464: l_fid NUMBER;
465: l_content_type FND_LOBS.file_content_type%TYPE;
466: l_attachment_file_name FND_LOBS.file_name%TYPE;
467: l_attachment_file_loc VARCHAR2(2000);
468: l_attachment_file_desc FND_DOCUMENTS_TL.description%TYPE;
469: l_rowid VARCHAR2(120);
470: l_created_by OKC_CONTRACT_DOCS.CREATED_BY%TYPE;

Line 550: CURSOR l_fnd_lobs_nextval_csr IS

546: OKC_ALLOWED_TMPL_USAGES
547: WHERE document_type = p_document_type
548: AND template_id = l_template_id;
549:
550: CURSOR l_fnd_lobs_nextval_csr IS
551: SELECT fnd_lobs_s.nextval
552: FROM
553: DUAL;
554:

Line 551: SELECT fnd_lobs_s.nextval

547: WHERE document_type = p_document_type
548: AND template_id = l_template_id;
549:
550: CURSOR l_fnd_lobs_nextval_csr IS
551: SELECT fnd_lobs_s.nextval
552: FROM
553: DUAL;
554:
555: CURSOR l_fnd_att_doc_nextval_csr IS

Line 964: OPEN l_fnd_lobs_nextval_csr;

960: RAISE FND_API.G_EXC_ERROR ;
961: END IF;
962:
963:
964: OPEN l_fnd_lobs_nextval_csr;
965: FETCH l_fnd_lobs_nextval_csr INTO l_fid ;
966: IF l_fnd_lobs_nextval_csr%NOTFOUND THEN
967: RAISE NO_DATA_FOUND;
968: END IF;

Line 965: FETCH l_fnd_lobs_nextval_csr INTO l_fid ;

961: END IF;
962:
963:
964: OPEN l_fnd_lobs_nextval_csr;
965: FETCH l_fnd_lobs_nextval_csr INTO l_fid ;
966: IF l_fnd_lobs_nextval_csr%NOTFOUND THEN
967: RAISE NO_DATA_FOUND;
968: END IF;
969: CLOSE l_fnd_lobs_nextval_csr;

Line 966: IF l_fnd_lobs_nextval_csr%NOTFOUND THEN

962:
963:
964: OPEN l_fnd_lobs_nextval_csr;
965: FETCH l_fnd_lobs_nextval_csr INTO l_fid ;
966: IF l_fnd_lobs_nextval_csr%NOTFOUND THEN
967: RAISE NO_DATA_FOUND;
968: END IF;
969: CLOSE l_fnd_lobs_nextval_csr;
970:

Line 969: CLOSE l_fnd_lobs_nextval_csr;

965: FETCH l_fnd_lobs_nextval_csr INTO l_fid ;
966: IF l_fnd_lobs_nextval_csr%NOTFOUND THEN
967: RAISE NO_DATA_FOUND;
968: END IF;
969: CLOSE l_fnd_lobs_nextval_csr;
970:
971: l_content_type := get_content_type(p_file_name => l_attachment_file_name);
972:
973: BEGIN

Line 974: INSERT INTO fnd_lobs (

970:
971: l_content_type := get_content_type(p_file_name => l_attachment_file_name);
972:
973: BEGIN
974: INSERT INTO fnd_lobs (
975: file_id,
976: file_name,
977: file_content_type,
978: upload_date,

Line 1236: l_attachment_file_name FND_LOBS.file_name%TYPE;

1232: )
1233: IS
1234: l_api_version CONSTANT NUMBER := 1;
1235: l_api_name CONSTANT VARCHAR2(30) := 'Add_Contract_Doc';
1236: l_attachment_file_name FND_LOBS.file_name%TYPE;
1237: l_attachment_file_loc VARCHAR2(2000);
1238: l_description FND_DOCUMENTS_TL.description%TYPE;
1239: l_content_type FND_LOBS.file_content_type%TYPE;
1240: l_blob BLOB := null;

Line 1239: l_content_type FND_LOBS.file_content_type%TYPE;

1235: l_api_name CONSTANT VARCHAR2(30) := 'Add_Contract_Doc';
1236: l_attachment_file_name FND_LOBS.file_name%TYPE;
1237: l_attachment_file_loc VARCHAR2(2000);
1238: l_description FND_DOCUMENTS_TL.description%TYPE;
1239: l_content_type FND_LOBS.file_content_type%TYPE;
1240: l_blob BLOB := null;
1241: l_fid NUMBER;
1242: l_new_attachment_id FND_ATTACHED_DOCUMENTS.ATTACHED_DOCUMENT_ID%TYPE;
1243: l_business_document_version NUMBER := -99;

Line 1275: CURSOR l_fnd_lobs_nextval_csr IS

1271: OKC_TEMPLATE_USAGES
1272: WHERE document_type = p_document_type
1273: AND document_id = p_document_id;
1274:
1275: CURSOR l_fnd_lobs_nextval_csr IS
1276: SELECT fnd_lobs_s.nextval
1277: FROM
1278: DUAL;
1279:

Line 1276: SELECT fnd_lobs_s.nextval

1272: WHERE document_type = p_document_type
1273: AND document_id = p_document_id;
1274:
1275: CURSOR l_fnd_lobs_nextval_csr IS
1276: SELECT fnd_lobs_s.nextval
1277: FROM
1278: DUAL;
1279:
1280: CURSOR l_fnd_att_doc_nextval_csr IS

Line 1442: OPEN l_fnd_lobs_nextval_csr;

1438: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1439: RAISE FND_API.G_EXC_ERROR ;
1440: END IF;
1441:
1442: OPEN l_fnd_lobs_nextval_csr;
1443: FETCH l_fnd_lobs_nextval_csr INTO l_fid ;
1444: IF l_fnd_lobs_nextval_csr%NOTFOUND THEN
1445: RAISE NO_DATA_FOUND;
1446: END IF;

Line 1443: FETCH l_fnd_lobs_nextval_csr INTO l_fid ;

1439: RAISE FND_API.G_EXC_ERROR ;
1440: END IF;
1441:
1442: OPEN l_fnd_lobs_nextval_csr;
1443: FETCH l_fnd_lobs_nextval_csr INTO l_fid ;
1444: IF l_fnd_lobs_nextval_csr%NOTFOUND THEN
1445: RAISE NO_DATA_FOUND;
1446: END IF;
1447: CLOSE l_fnd_lobs_nextval_csr;

Line 1444: IF l_fnd_lobs_nextval_csr%NOTFOUND THEN

1440: END IF;
1441:
1442: OPEN l_fnd_lobs_nextval_csr;
1443: FETCH l_fnd_lobs_nextval_csr INTO l_fid ;
1444: IF l_fnd_lobs_nextval_csr%NOTFOUND THEN
1445: RAISE NO_DATA_FOUND;
1446: END IF;
1447: CLOSE l_fnd_lobs_nextval_csr;
1448:

Line 1447: CLOSE l_fnd_lobs_nextval_csr;

1443: FETCH l_fnd_lobs_nextval_csr INTO l_fid ;
1444: IF l_fnd_lobs_nextval_csr%NOTFOUND THEN
1445: RAISE NO_DATA_FOUND;
1446: END IF;
1447: CLOSE l_fnd_lobs_nextval_csr;
1448:
1449: l_content_type := get_content_type(p_file_name => l_attachment_file_name);
1450:
1451: BEGIN

Line 1452: INSERT INTO fnd_lobs (

1448:
1449: l_content_type := get_content_type(p_file_name => l_attachment_file_name);
1450:
1451: BEGIN
1452: INSERT INTO fnd_lobs (
1453: file_id,
1454: file_name,
1455: file_content_type,
1456: upload_date,