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_ATTACHED_DOCUMENTS

Line 94: l_pk2_value FND_ATTACHED_DOCUMENTS.pk2_value%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
98: l_rowid VARCHAR2(120);

Line 97: -- The following variables are required for updating the pk3_value in fnd_attached_documents table

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

Line 100: l_new_attachment_id FND_ATTACHED_DOCUMENTS.ATTACHED_DOCUMENT_ID%TYPE;

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:
104: CURSOR l_attachment_id_csr IS

Line 101: l_parent_attached_doc_id FND_ATTACHED_DOCUMENTS.ATTACHED_DOCUMENT_ID%TYPE := p_parent_attached_doc_id;

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:
104: CURSOR l_attachment_id_csr IS
105: SELECT fnd_attached_documents_s.nextval FROM dual;

Line 102: l_seq_num FND_ATTACHED_DOCUMENTS.SEQ_NUM%TYPE := 0;

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:
104: CURSOR l_attachment_id_csr IS
105: SELECT fnd_attached_documents_s.nextval FROM dual;
106:

Line 105: SELECT fnd_attached_documents_s.nextval FROM dual;

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:
104: CURSOR l_attachment_id_csr IS
105: SELECT fnd_attached_documents_s.nextval FROM dual;
106:
107: CURSOR seq_csr(l_entity_name VARCHAR2, l_pk1_value VARCHAR2,
108: l_pk2_value NUMBER, l_pk3_value NUMBER) IS
109: SELECT max(seq_num) s_num

Line 110: FROM FND_ATTACHED_DOCUMENTS

106:
107: CURSOR seq_csr(l_entity_name VARCHAR2, l_pk1_value VARCHAR2,
108: l_pk2_value NUMBER, l_pk3_value NUMBER) IS
109: SELECT max(seq_num) s_num
110: FROM FND_ATTACHED_DOCUMENTS
111: WHERE entity_name = l_entity_name
112: AND pk1_value = l_pk1_value
113: AND pk2_value = to_char(l_pk2_value)
114: AND pk3_value = to_char(l_pk3_value);

Line 219: -- Get document_id from FND_ATTACHED_DOCUMENTS table

215: END IF;
216: CLOSE l_attachment_id_csr;
217:
218:
219: -- Get document_id from FND_ATTACHED_DOCUMENTS table
220: SELECT document_id INTO l_document_id
221: FROM FND_ATTACHED_DOCUMENTS
222: WHERE attached_document_id = p_attached_document_id;
223:

Line 221: FROM FND_ATTACHED_DOCUMENTS

217:
218:
219: -- Get document_id from FND_ATTACHED_DOCUMENTS table
220: SELECT document_id INTO l_document_id
221: FROM FND_ATTACHED_DOCUMENTS
222: WHERE attached_document_id = p_attached_document_id;
223:
224: -- Get SEQ_NUM for the new record being added
225: FOR seq_rec IN seq_csr(G_ATTACH_ENTITY_NAME, p_business_document_type, p_business_document_id,

Line 249: fnd_attached_documents_pkg.insert_row(

245: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
246: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'651: document_id is: ' || l_document_id);
247: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'652: New seq_num is: ' || l_seq_num);
248: END IF;
249: fnd_attached_documents_pkg.insert_row(
250: x_rowid => l_rowid,
251: x_attached_document_id => l_new_attachment_id,
252: x_document_id => l_document_id,
253: x_creation_date => l_creation_date,

Line 641: l_attached_document_id FND_ATTACHED_DOCUMENTS.ATTACHED_DOCUMENT_ID%TYPE := -1;

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;
645: l_msg_data FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;

Line 648: l_pk2_value FND_ATTACHED_DOCUMENTS.pk2_value%TYPE;

644: l_msg_count NUMBER;
645: l_msg_data FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
646: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
647: l_parent_attached_doc_id OKC_CONTRACT_DOCS.PARENT_ATTACHED_DOC_ID%TYPE;
648: l_pk2_value FND_ATTACHED_DOCUMENTS.pk2_value%TYPE;
649:
650: CURSOR attach_csr(l_bus_doc_type VARCHAR2, l_bus_doc_id NUMBER, l_bus_doc_version NUMBER, l_attached_doc_id NUMBER) IS
651: SELECT * FROM OKC_CONTRACT_DOCS
652: WHERE business_document_type = l_bus_doc_type

Line 675: FROM FND_ATTACHED_DOCUMENTS fad

671: AND delete_flag = 'N';
672:
673: CURSOR fnd_attached_doc_csr IS
674: SELECT fad.rowid, fad.*
675: FROM FND_ATTACHED_DOCUMENTS fad
676: WHERE attached_document_id = p_attached_document_id;
677:
678:
679: CURSOR fnd_doc_csr(l_document_id NUMBER) IS

Line 838: -- add 'D' suffix to FND_ATTACHED_DOCUMENTS record's pk2_value column.

834: -- (l_effective_from_type = p_business_document_type AND
835: -- l_effective_from_id = p_business_document_id AND
836: -- l_effective_from_version <> p_business_document_version) THEN
837: -- DO not delete anything. Just update the OKC_CONTRACT_DOCS record to delete_flag='Y' and
838: -- add 'D' suffix to FND_ATTACHED_DOCUMENTS record's pk2_value column.
839: FOR attach_rec IN attach_csr(p_business_document_type, p_business_document_id,
840: p_business_document_version, p_attached_document_id)
841: LOOP
842: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 865: -- Update the corresponding record in FND_ATTACHED_DOCUMENTS tables. Add 'D' to pk2_value column.

861: END IF;
862:
863: -- Append 'D' to pk2_value
864: l_pk2_value := fnd_attached_doc_rec.pk2_value || 'D';
865: -- Update the corresponding record in FND_ATTACHED_DOCUMENTS tables. Add 'D' to pk2_value column.
866: fnd_attached_documents_pkg.Update_Row(
867: X_Rowid => fnd_attached_doc_rec.rowid,
868: X_attached_document_id => fnd_attached_doc_rec.attached_document_id,
869: X_document_id => fnd_attached_doc_rec.document_id,

Line 866: fnd_attached_documents_pkg.Update_Row(

862:
863: -- Append 'D' to pk2_value
864: l_pk2_value := fnd_attached_doc_rec.pk2_value || 'D';
865: -- Update the corresponding record in FND_ATTACHED_DOCUMENTS tables. Add 'D' to pk2_value column.
866: fnd_attached_documents_pkg.Update_Row(
867: X_Rowid => fnd_attached_doc_rec.rowid,
868: X_attached_document_id => fnd_attached_doc_rec.attached_document_id,
869: X_document_id => fnd_attached_doc_rec.document_id,
870: X_last_update_date => fnd_attached_doc_rec.last_update_date,

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 957: FND_ATTACHED_DOCUMENTS3_PKG.DELETE_ROW(

953: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
954: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2258: Deleting FND Attachments');
955: END IF;
956: -- Call FND delete attachment API to delete Media as well
957: FND_ATTACHED_DOCUMENTS3_PKG.DELETE_ROW(
958: X_attached_document_id => p_attached_document_id,
959: X_datatype_id => l_datatype_id,
960: delete_document_flag => 'Y');
961:

Line 1071: l_attached_document_id FND_ATTACHED_DOCUMENTS.ATTACHED_DOCUMENT_ID%TYPE;

1067: l_api_version NUMBER := 1;
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);

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 1297: -- Call FND delete attachment API to delete just the FND_ATTACHED_DOCUMENTS record

1293: || l_datatype_id);
1294: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2735: attached_document_id is: '
1295: || attach_rec.attached_document_id);
1296: END IF;
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

Line 1298: FND_ATTACHED_DOCUMENTS3_PKG.DELETE_ROW(

1294: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2735: attached_document_id is: '
1295: || attach_rec.attached_document_id);
1296: END IF;
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:

Line 1352: -- Call FND delete attachment API to delete just the FND_ATTACHED_DOCUMENTS record

1348: || l_datatype_id);
1349: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2748: attached_document_id is: '
1350: || ref_del_rec.attached_document_id);
1351: END IF;
1352: -- Call FND delete attachment API to delete just the FND_ATTACHED_DOCUMENTS record
1353: FND_ATTACHED_DOCUMENTS3_PKG.DELETE_ROW(
1354: X_attached_document_id => ref_del_rec.attached_document_id,
1355: X_datatype_id => l_datatype_id,
1356: delete_document_flag => 'N'); -- Don't delete FND_DOCUMENTS records

Line 1353: FND_ATTACHED_DOCUMENTS3_PKG.DELETE_ROW(

1349: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2748: attached_document_id is: '
1350: || ref_del_rec.attached_document_id);
1351: END IF;
1352: -- Call FND delete attachment API to delete just the FND_ATTACHED_DOCUMENTS record
1353: FND_ATTACHED_DOCUMENTS3_PKG.DELETE_ROW(
1354: X_attached_document_id => ref_del_rec.attached_document_id,
1355: X_datatype_id => l_datatype_id,
1356: delete_document_flag => 'N'); -- Don't delete FND_DOCUMENTS records
1357: -- Delete record in OKC_CONTRACT_DOCS table

Line 1767: l_attached_document_id FND_ATTACHED_DOCUMENTS.ATTACHED_DOCUMENT_ID%TYPE;

1763: l_business_document_type OKC_CONTRACT_DOCS.BUSINESS_DOCUMENT_TYPE%TYPE;
1764: l_business_document_id OKC_CONTRACT_DOCS.BUSINESS_DOCUMENT_ID%TYPE;
1765: l_business_document_version OKC_CONTRACT_DOCS.BUSINESS_DOCUMENT_VERSION%TYPE;
1766: l_from_version OKC_CONTRACT_DOCS.EFFECTIVE_FROM_VERSION%TYPE;
1767: l_attached_document_id FND_ATTACHED_DOCUMENTS.ATTACHED_DOCUMENT_ID%TYPE;
1768: l_contract_category_id FND_DOCUMENT_CATEGORIES.CATEGORY_ID%TYPE;
1769: l_supporting_category_id FND_DOCUMENT_CATEGORIES.CATEGORY_ID%TYPE;
1770: l_copy_all_docs_yn VARCHAR2(1);
1771: --Fix for bug 6468721 : Added code to copy SYSTEM-GENERATED ATTACHMENTS to the target Business Document.

Line 1798: FROM FND_ATTACHED_DOCUMENTS FADB1, OKC_CONTRACT_DOCS KDOC,

1794: KDOC.delete_flag delete_flag,
1795: FADB2.attached_document_id to_attached_document_id,
1796: KDOC.primary_contract_doc_flag,
1797: KDOC.mergeable_doc_flag
1798: FROM FND_ATTACHED_DOCUMENTS FADB1, OKC_CONTRACT_DOCS KDOC,
1799: FND_ATTACHED_DOCUMENTS FADB2,
1800: FND_DOCUMENTS_vl doc1,
1801: FND_DOCUMENTS_vl doc2
1802: WHERE

Line 1799: FND_ATTACHED_DOCUMENTS FADB2,

1795: FADB2.attached_document_id to_attached_document_id,
1796: KDOC.primary_contract_doc_flag,
1797: KDOC.mergeable_doc_flag
1798: FROM FND_ATTACHED_DOCUMENTS FADB1, OKC_CONTRACT_DOCS KDOC,
1799: FND_ATTACHED_DOCUMENTS FADB2,
1800: FND_DOCUMENTS_vl doc1,
1801: FND_DOCUMENTS_vl doc2
1802: WHERE
1803: KDOC.business_document_type = l_from_bus_doc_type

Line 1879: FND_ATTACHED_DOCUMENTS2_PKG.Copy_Attachments(

1875: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1876: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'4820: Category Id : ' || category_rec2.category_id);
1877: END IF;
1878: -- Copy FND Attachments. Program Id is set to -9999.
1879: FND_ATTACHED_DOCUMENTS2_PKG.Copy_Attachments(
1880: X_from_entity_name => G_ATTACH_ENTITY_NAME,
1881: X_from_pk1_value => p_from_bus_doc_type,
1882: X_from_pk2_value => p_from_bus_doc_id,
1883: X_from_pk3_value => p_from_bus_doc_version,

Line 1899: FND_ATTACHED_DOCUMENTS2_PKG.Copy_Attachments(

1895: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1896: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'4820: Category Id : ' || category_rec3.category_id);
1897: END IF;
1898: -- Copy FND Attachments. Program Id is set to -9999.
1899: FND_ATTACHED_DOCUMENTS2_PKG.Copy_Attachments(
1900: X_from_entity_name => G_ATTACH_ENTITY_NAME,
1901: X_from_pk1_value => p_from_bus_doc_type,
1902: X_from_pk2_value => p_from_bus_doc_id,
1903: X_from_pk3_value => p_from_bus_doc_version,

Line 1956: FND_ATTACHED_DOCUMENTS2_PKG.Copy_Attachments(

1952: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1953: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'4820: Category Id : ' || category_rec4.category_id);
1954: END IF;
1955: -- Copy FND Attachments. Program Id is set to -9999.
1956: FND_ATTACHED_DOCUMENTS2_PKG.Copy_Attachments(
1957: X_from_entity_name => G_ATTACH_ENTITY_NAME,
1958: X_from_pk1_value => p_from_bus_doc_type,
1959: X_from_pk2_value => p_from_bus_doc_id,
1960: X_from_pk3_value => l_from_bus_doc_version_latest,

Line 1976: FND_ATTACHED_DOCUMENTS2_PKG.Copy_Attachments(

1972: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1973: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'4820: Category Id : ' || category_rec1.category_id);
1974: END IF;
1975: -- Copy FND Attachments. Program Id is set to -9999.
1976: FND_ATTACHED_DOCUMENTS2_PKG.Copy_Attachments(
1977: X_from_entity_name => G_ATTACH_ENTITY_NAME,
1978: X_from_pk1_value => p_from_bus_doc_type,
1979: X_from_pk2_value => p_from_bus_doc_id,
1980: X_from_pk3_value => p_from_bus_doc_version,

Line 1997: FND_ATTACHED_DOCUMENTS2_PKG.Copy_Attachments(

1993: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1994: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'4820: Category Id : ' || category_rec2.category_id);
1995: END IF;
1996: -- Copy FND Attachments. Program Id is set to -9999.
1997: FND_ATTACHED_DOCUMENTS2_PKG.Copy_Attachments(
1998: X_from_entity_name => G_ATTACH_ENTITY_NAME,
1999: X_from_pk1_value => p_from_bus_doc_type,
2000: X_from_pk2_value => p_from_bus_doc_id,
2001: X_from_pk3_value => p_from_bus_doc_version,

Line 2168: l_attached_document_id FND_ATTACHED_DOCUMENTS.ATTACHED_DOCUMENT_ID%TYPE;

2164: l_business_document_type OKC_CONTRACT_DOCS.BUSINESS_DOCUMENT_TYPE%TYPE;
2165: l_business_document_id OKC_CONTRACT_DOCS.BUSINESS_DOCUMENT_ID%TYPE;
2166: l_business_document_version OKC_CONTRACT_DOCS.BUSINESS_DOCUMENT_VERSION%TYPE;
2167: l_from_version OKC_CONTRACT_DOCS.EFFECTIVE_FROM_VERSION%TYPE;
2168: l_attached_document_id FND_ATTACHED_DOCUMENTS.ATTACHED_DOCUMENT_ID%TYPE;
2169: l_category_name FND_DOCUMENT_CATEGORIES.NAME%TYPE;
2170: l_parent_attached_doc_id FND_ATTACHED_DOCUMENTS.ATTACHED_DOCUMENT_ID%TYPE;
2171:
2172:

Line 2170: l_parent_attached_doc_id FND_ATTACHED_DOCUMENTS.ATTACHED_DOCUMENT_ID%TYPE;

2166: l_business_document_version OKC_CONTRACT_DOCS.BUSINESS_DOCUMENT_VERSION%TYPE;
2167: l_from_version OKC_CONTRACT_DOCS.EFFECTIVE_FROM_VERSION%TYPE;
2168: l_attached_document_id FND_ATTACHED_DOCUMENTS.ATTACHED_DOCUMENT_ID%TYPE;
2169: l_category_name FND_DOCUMENT_CATEGORIES.NAME%TYPE;
2170: l_parent_attached_doc_id FND_ATTACHED_DOCUMENTS.ATTACHED_DOCUMENT_ID%TYPE;
2171:
2172:
2173: -- Attachment cursor to get the attachments for a given doc type, id and version
2174: CURSOR attach_csr(l_bus_doc_type VARCHAR2, l_bus_doc_id NUMBER, l_bus_doc_version NUMBER) IS

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

2180:
2181: -- Get the category code for a given fnd attachment.
2182: CURSOR category_csr (l_attached_document_id NUMBER) IS
2183: SELECT fdc.name
2184: FROM fnd_attached_documents fad, fnd_documents fd, fnd_document_categories fdc
2185: WHERE fad.attached_document_id = l_attached_document_id
2186: AND fad.document_id = fd.document_id
2187: AND fd.category_id = fdc.category_id;
2188:

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

2696:
2697: CURSOR contract_doc_csr IS
2698:
2699: SELECT b.media_id , docs.mergeable_doc_flag
2700: FROM OKC_CONTRACT_DOCS docs, FND_ATTACHED_DOCUMENTS fnd, FND_DOCUMENTS b
2701: WHERE docs.primary_contract_doc_flag = 'Y'
2702: AND NVL(docs.delete_flag,'N') = 'N'
2703: AND docs.business_document_version = -99
2704: AND docs.business_document_type = p_document_type