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_CONTRACT_DOCS_GRP dependencies on FND_DOCUMENTS

Line 93: l_media_id FND_DOCUMENTS.MEDIA_ID%TYPE;

89: l_last_updated_by OKC_CONTRACT_DOCS.LAST_UPDATED_BY%TYPE;
90: l_last_update_login OKC_CONTRACT_DOCS.LAST_UPDATE_LOGIN%TYPE;
91: l_last_update_date OKC_CONTRACT_DOCS.LAST_UPDATE_DATE%TYPE;
92: l_attached_document_id OKC_CONTRACT_DOCS.ATTACHED_DOCUMENT_ID%TYPE := p_attached_document_id;
93: l_media_id FND_DOCUMENTS.MEDIA_ID%TYPE;
94: l_pk2_value FND_ATTACHED_DOCUMENTS.pk2_value%TYPE;
95:
96:
97: -- The following variables are required for updating the pk3_value in fnd_attached_documents table

Line 99: l_document_id FND_DOCUMENTS.DOCUMENT_ID%TYPE;

95:
96:
97: -- The following variables are required for updating the pk3_value in fnd_attached_documents table
98: l_rowid VARCHAR2(120);
99: l_document_id FND_DOCUMENTS.DOCUMENT_ID%TYPE;
100: l_new_attachment_id FND_ATTACHED_DOCUMENTS.ATTACHED_DOCUMENT_ID%TYPE;
101: l_parent_attached_doc_id FND_ATTACHED_DOCUMENTS.ATTACHED_DOCUMENT_ID%TYPE := p_parent_attached_doc_id;
102: l_seq_num FND_ATTACHED_DOCUMENTS.SEQ_NUM%TYPE := 0;
103:

Line 640: l_datatype_id FND_DOCUMENTS.DATATYPE_ID%TYPE := -1;

636: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Contract_Doc';
637: l_effective_from_type OKC_CONTRACT_DOCS.EFFECTIVE_FROM_TYPE%TYPE;
638: l_effective_from_id OKC_CONTRACT_DOCS.EFFECTIVE_FROM_ID%TYPE;
639: l_effective_from_version OKC_CONTRACT_DOCS.EFFECTIVE_FROM_VERSION%TYPE;
640: l_datatype_id FND_DOCUMENTS.DATATYPE_ID%TYPE := -1;
641: l_attached_document_id FND_ATTACHED_DOCUMENTS.ATTACHED_DOCUMENT_ID%TYPE := -1;
642: l_object_version_number NUMBER := -1;
643: l_doc_approved_flag VARCHAR2(1);
644: l_msg_count NUMBER;

Line 696: FROM fnd_documents B, fnd_documents_tl TL

692: TL.description description,
693: B.file_name file_name,
694: B.url url,
695: B.media_id media_id
696: FROM fnd_documents B, fnd_documents_tl TL
697: WHERE B.document_id = l_document_id
698: AND TL.document_id = l_document_id
699: AND TL.language = USERENV('LANG');
700:

Line 938: FROM fnd_documents d, fnd_attached_documents ad

934: END LOOP;
935: ELSE
936: -- Delete the record
937: SELECT d.datatype_id INTO l_datatype_id
938: FROM fnd_documents d, fnd_attached_documents ad
939: WHERE d.document_id = ad.document_id
940: AND ad.attached_document_id = p_attached_document_id;
941:
942: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1072: l_datatype_id FND_DOCUMENTS.DATATYPE_ID%TYPE;

1068: l_business_document_type OKC_CONTRACT_DOCS.BUSINESS_DOCUMENT_TYPE%TYPE;
1069: l_business_document_id OKC_CONTRACT_DOCS.BUSINESS_DOCUMENT_ID%TYPE;
1070: l_business_document_version OKC_CONTRACT_DOCS.BUSINESS_DOCUMENT_VERSION%TYPE;
1071: l_attached_document_id FND_ATTACHED_DOCUMENTS.ATTACHED_DOCUMENT_ID%TYPE;
1072: l_datatype_id FND_DOCUMENTS.DATATYPE_ID%TYPE;
1073: l_effective_from_version OKC_CONTRACT_DOCS.effective_from_version%TYPE;
1074: l_parent_attached_doc_id OKC_CONTRACT_DOCS.parent_attached_doc_id%TYPE;
1075: l_non_ref_attachment_created VARCHAR2(1);
1076:

Line 1102: FROM fnd_documents d, fnd_attached_documents ad

1098:
1099: -- data_type cursor, will be required for deleting current version generated doc.
1100: CURSOR datatype_csr (l_attached_document_id NUMBER) IS
1101: SELECT d.datatype_id
1102: FROM fnd_documents d, fnd_attached_documents ad
1103: WHERE d.document_id = ad.document_id
1104: AND ad.attached_document_id = l_attached_document_id;
1105:
1106: BEGIN

Line 1301: delete_document_flag => 'N'); -- Don't delete FND_DOCUMENTS records

1297: -- Call FND delete attachment API to delete just the FND_ATTACHED_DOCUMENTS record
1298: FND_ATTACHED_DOCUMENTS3_PKG.DELETE_ROW(
1299: X_attached_document_id => attach_rec.attached_document_id,
1300: X_datatype_id => l_datatype_id,
1301: delete_document_flag => 'N'); -- Don't delete FND_DOCUMENTS records
1302:
1303: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1304: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2737: Deleting OKC_CONTRACT_DOCS record');
1305: END IF;

Line 1354: delete_document_flag => 'N'); -- Don't delete FND_DOCUMENTS records

1350: -- Call FND delete attachment API to delete just the FND_ATTACHED_DOCUMENTS record
1351: FND_ATTACHED_DOCUMENTS3_PKG.DELETE_ROW(
1352: X_attached_document_id => ref_del_rec.attached_document_id,
1353: X_datatype_id => l_datatype_id,
1354: delete_document_flag => 'N'); -- Don't delete FND_DOCUMENTS records
1355: -- Delete record in OKC_CONTRACT_DOCS table
1356: OKC_CONTRACT_DOCS_PVT.Delete_Row(
1357: x_return_status => l_return_status,
1358: p_business_document_type => ref_del_rec.business_document_type,

Line 2173: FROM fnd_attached_documents fad, fnd_documents fd, fnd_document_categories fdc

2169:
2170: -- Get the category code for a given fnd attachment.
2171: CURSOR category_csr (l_attached_document_id NUMBER) IS
2172: SELECT fdc.name
2173: FROM fnd_attached_documents fad, fnd_documents fd, fnd_document_categories fdc
2174: WHERE fad.attached_document_id = l_attached_document_id
2175: AND fad.document_id = fd.document_id
2176: AND fd.category_id = fdc.category_id;
2177:

Line 2374: l_datatype_id FND_DOCUMENTS.DATATYPE_ID%TYPE;

2370:
2371: ) IS
2372: l_api_name CONSTANT VARCHAR2(30) := 'Copy_Attachments';
2373: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2374: l_datatype_id FND_DOCUMENTS.DATATYPE_ID%TYPE;
2375: l_msg_count NUMBER;
2376: l_msg_data FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
2377: l_api_version NUMBER:= 1;
2378:

Line 2675: -- Returns FND_DOCUMENTS_TL.media_id of the Primary contract file for the current version of the document if it is non mergeable.

2671: END IF;
2672: RETURN 'E';
2673: END Is_Primary_Terms_Doc_Mergeable;
2674:
2675: -- Returns FND_DOCUMENTS_TL.media_id of the Primary contract file for the current version of the document if it is non mergeable.
2676: -- 0 if document is mergeable.
2677: -- -1 if no primary document exists.
2678: FUNCTION Get_Primary_Terms_Doc_File_Id(
2679: p_document_type IN VARCHAR2,

Line 2684: l_media_id FND_DOCUMENTS.MEDIA_ID%TYPE := -1;

2680: p_document_id IN NUMBER
2681: ) RETURN NUMBER IS
2682: l_api_name CONSTANT VARCHAR2(30) := 'Get_Primary_Terms_doc_File_Id';
2683: l_mergeable_doc_flag VARCHAR2(1) := '?';
2684: l_media_id FND_DOCUMENTS.MEDIA_ID%TYPE := -1;
2685:
2686: CURSOR contract_doc_csr IS
2687:
2688: SELECT b.media_id , docs.mergeable_doc_flag

Line 2689: FROM OKC_CONTRACT_DOCS docs, FND_ATTACHED_DOCUMENTS fnd, FND_DOCUMENTS b

2685:
2686: CURSOR contract_doc_csr IS
2687:
2688: SELECT b.media_id , docs.mergeable_doc_flag
2689: FROM OKC_CONTRACT_DOCS docs, FND_ATTACHED_DOCUMENTS fnd, FND_DOCUMENTS b
2690: WHERE docs.primary_contract_doc_flag = 'Y'
2691: AND NVL(docs.delete_flag,'N') = 'N'
2692: AND docs.business_document_version = -99
2693: AND docs.business_document_type = p_document_type