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_ATTACHED_DOCUMENTS

Line 475: l_seq_num FND_ATTACHED_DOCUMENTS.SEQ_NUM%TYPE := 1;

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

Line 479: l_new_attachment_id FND_ATTACHED_DOCUMENTS.ATTACHED_DOCUMENT_ID%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;
482: lc_business_document_id OKC_CONTRACT_DOCS.BUSINESS_DOCUMENT_ID%TYPE;
483: lc_business_document_version OKC_CONTRACT_DOCS.BUSINESS_DOCUMENT_VERSION%TYPE;

Line 556: SELECT fnd_attached_documents_s.nextval

552: FROM
553: DUAL;
554:
555: CURSOR l_fnd_att_doc_nextval_csr IS
556: SELECT fnd_attached_documents_s.nextval
557: FROM
558: DUAL;
559:
560: CURSOR l_cat_id_csr IS

Line 1035: fnd_attached_documents_pkg.insert_row(

1031: l_last_updated_by := l_created_by;
1032: l_last_update_login := Fnd_Global.Login_Id;
1033:
1034:
1035: fnd_attached_documents_pkg.insert_row(
1036: x_rowid => l_rowid,
1037: x_attached_document_id => l_new_attachment_id,
1038: x_document_id => lf_document_id,
1039: x_creation_date => sysdate,

Line 1084: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'600: Finished FND_ATTACHED_DOCUMENTS_PKG.insert_row ');

1080:
1081: l_attached_document_id := l_new_attachment_id;
1082:
1083: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1084: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'600: Finished FND_ATTACHED_DOCUMENTS_PKG.insert_row ');
1085: END IF;
1086:
1087:
1088: okc_contract_docs_grp.Insert_Contract_Doc(

Line 1242: l_new_attachment_id FND_ATTACHED_DOCUMENTS.ATTACHED_DOCUMENT_ID%TYPE;

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;
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;

Line 1246: l_seq_num FND_ATTACHED_DOCUMENTS.SEQ_NUM%TYPE := 1;

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;
1250: lc_business_document_version OKC_CONTRACT_DOCS.BUSINESS_DOCUMENT_VERSION%TYPE;

Line 1281: SELECT fnd_attached_documents_s.nextval

1277: FROM
1278: DUAL;
1279:
1280: CURSOR l_fnd_att_doc_nextval_csr IS
1281: SELECT fnd_attached_documents_s.nextval
1282: FROM
1283: DUAL;
1284:
1285: CURSOR l_cat_id_csr(l_category IN VARCHAR2) IS

Line 1525: fnd_attached_documents_pkg.insert_row(

1521: l_last_updated_by := l_created_by;
1522: l_last_update_login := Fnd_Global.Login_Id;
1523:
1524:
1525: fnd_attached_documents_pkg.insert_row(
1526: x_rowid => l_rowid,
1527: x_attached_document_id => l_new_attachment_id,
1528: x_document_id => lf_document_id,
1529: x_creation_date => sysdate,

Line 1574: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'600: Finished FND_ATTACHED_DOCUMENTS_PKG.insert_row ');

1570:
1571: l_attached_document_id := l_new_attachment_id;
1572:
1573: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1574: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'600: Finished FND_ATTACHED_DOCUMENTS_PKG.insert_row ');
1575: END IF;
1576:
1577:
1578: okc_contract_docs_grp.Insert_Contract_Doc(