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_DOCUMENTS

Line 468: l_attachment_file_desc FND_DOCUMENTS_TL.description%TYPE;

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;
471: l_creation_date OKC_CONTRACT_DOCS.CREATION_DATE%TYPE;
472: l_last_updated_by OKC_CONTRACT_DOCS.LAST_UPDATED_BY%TYPE;

Line 477: lf_document_id FND_DOCUMENTS.DOCUMENT_ID%TYPE;

473: l_last_update_login OKC_CONTRACT_DOCS.LAST_UPDATE_LOGIN%TYPE;
474: l_last_update_date OKC_CONTRACT_DOCS.LAST_UPDATE_DATE%TYPE;
475: l_seq_num FND_ATTACHED_DOCUMENTS.SEQ_NUM%TYPE := 1;
476: l_business_document_version NUMBER := -99;
477: lf_document_id FND_DOCUMENTS.DOCUMENT_ID%TYPE;
478:
479: l_new_attachment_id FND_ATTACHED_DOCUMENTS.ATTACHED_DOCUMENT_ID%TYPE;
480:
481: lc_business_document_type OKC_CONTRACT_DOCS.BUSINESS_DOCUMENT_TYPE%TYPE;

Line 487: l_media_id FND_DOCUMENTS_TL.MEDIA_ID%TYPE;

483: lc_business_document_version OKC_CONTRACT_DOCS.BUSINESS_DOCUMENT_VERSION%TYPE;
484: lc_attached_document_id OKC_CONTRACT_DOCS.ATTACHED_DOCUMENT_ID%TYPE;
485:
486: l_attached_document_id OKC_CONTRACT_DOCS.ATTACHED_DOCUMENT_ID%TYPE;
487: l_media_id FND_DOCUMENTS_TL.MEDIA_ID%TYPE;
488: L_primary_contract_doc_flag VARCHAR2(1) := 'N';
489: l_category_id FND_DOCUMENT_CATEGORIES.CATEGORY_ID%TYPE;
490:
491: l_doc_intent VARCHAR2(1);

Line 1238: l_description FND_DOCUMENTS_TL.description%TYPE;

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;
1241: l_fid NUMBER;
1242: l_new_attachment_id FND_ATTACHED_DOCUMENTS.ATTACHED_DOCUMENT_ID%TYPE;

Line 1244: lf_document_id FND_DOCUMENTS.DOCUMENT_ID%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;
1244: lf_document_id FND_DOCUMENTS.DOCUMENT_ID%TYPE;
1245: l_datatype_id FND_DOCUMENTS.DATATYPE_ID%TYPE;
1246: l_seq_num FND_ATTACHED_DOCUMENTS.SEQ_NUM%TYPE := 1;
1247:
1248: lc_business_document_type OKC_CONTRACT_DOCS.BUSINESS_DOCUMENT_TYPE%TYPE;

Line 1245: l_datatype_id FND_DOCUMENTS.DATATYPE_ID%TYPE;

1241: l_fid NUMBER;
1242: l_new_attachment_id FND_ATTACHED_DOCUMENTS.ATTACHED_DOCUMENT_ID%TYPE;
1243: l_business_document_version NUMBER := -99;
1244: lf_document_id FND_DOCUMENTS.DOCUMENT_ID%TYPE;
1245: l_datatype_id FND_DOCUMENTS.DATATYPE_ID%TYPE;
1246: l_seq_num FND_ATTACHED_DOCUMENTS.SEQ_NUM%TYPE := 1;
1247:
1248: lc_business_document_type OKC_CONTRACT_DOCS.BUSINESS_DOCUMENT_TYPE%TYPE;
1249: lc_business_document_id OKC_CONTRACT_DOCS.BUSINESS_DOCUMENT_ID%TYPE;

Line 1264: l_media_id FND_DOCUMENTS_TL.MEDIA_ID%TYPE;

1260: l_last_updated_by OKC_CONTRACT_DOCS.LAST_UPDATED_BY%TYPE;
1261: l_last_update_login OKC_CONTRACT_DOCS.LAST_UPDATE_LOGIN%TYPE;
1262: l_last_update_date OKC_CONTRACT_DOCS.LAST_UPDATE_DATE%TYPE;
1263:
1264: l_media_id FND_DOCUMENTS_TL.MEDIA_ID%TYPE;
1265: L_primary_contract_doc_flag VARCHAR2(1) := 'N';
1266: l_category_id FND_DOCUMENT_CATEGORIES.CATEGORY_ID%TYPE;
1267:
1268: CURSOR l_tmpl_doc_exist_csr IS