APPS.OKS_COPY_CONTRACT_PVT dependencies on FND_ATTACHED_DOCUMENTS

Line 1207: x_from_version FND_ATTACHED_DOCUMENTS.PK2_VALUE%TYPE := NULL;

1203: SELECT to_char(major_version)
1204: FROM okc_k_vers_numbers
1205: WHERE chr_id = p_chr_id;
1206:
1207: x_from_version FND_ATTACHED_DOCUMENTS.PK2_VALUE%TYPE := NULL;
1208:
1209: BEGIN
1210: open l_cvm_csr;
1211: fetch l_cvm_csr into x_from_version;

Line 1593: l_from_version FND_ATTACHED_DOCUMENTS.PK2_VALUE%TYPE;

1589: l_sts_code VARCHAR2(30);
1590: l_status_type VARCHAR2(30) := 'ENTERED';
1591: l_orig_system_source_code VARCHAR2(30) := 'OKC_HDR';
1592: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1593: l_from_version FND_ATTACHED_DOCUMENTS.PK2_VALUE%TYPE;
1594:
1595: l_euro_currency varchar2(15) := NULL; /* For Euro Conversion - Bug 2155930 */
1596: l_converted_amount number := NULL; /* For Euro Conversion - Bug 2155930 */
1597:

Line 1885: -- in fnd_attached_documents2_pkg.copy_attachments call

1881: -- The following line to be added to the code once
1882: -- bug 1553916 completes
1883: -- ,l_pkey2 => l_from_version) = 'Y')
1884: -- also below remove the comments
1885: -- in fnd_attached_documents2_pkg.copy_attachments call
1886: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1887: FND_LOG.string(FND_LOG.level_statement
1888: ,l_module_name
1889: ,'After call to fnd_attachment_util_pkg.get_atchmt_exists'

Line 1894: fnd_attached_documents2_pkg.copy_attachments(

1890: );
1891: END IF;
1892:
1893: Begin
1894: fnd_attached_documents2_pkg.copy_attachments(
1895: x_from_entity_name => l_from_entity_name,
1896: x_from_pk1_value => p_from_chr_id,
1897: --x_from_pk2_value => l_from_version,
1898: x_to_entity_name => l_to_entity_name,

Line 1905: ,'After call to fnd_attached_documents2_pkg.copy_attachments'

1901: );
1902: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1903: FND_LOG.string(FND_LOG.level_statement
1904: ,l_module_name
1905: ,'After call to fnd_attached_documents2_pkg.copy_attachments'
1906: );
1907: END IF;
1908:
1909: EXCEPTION

Line 1914: ,l_module_name||'.fnd_attached_documents2_pkg.copy_attachments'

1910: WHEN OTHERS THEN
1911: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
1912: IF (FND_LOG.test(FND_LOG.level_unexpected, l_module_name)) THEN
1913: FND_LOG.string(FND_LOG.level_unexpected
1914: ,l_module_name||'.fnd_attached_documents2_pkg.copy_attachments'
1915: ,'After call to fnd_attached_documents2_pkg.copy_attachments'
1916: ||' '||SQLERRM
1917: );
1918: END IF;

Line 1915: ,'After call to fnd_attached_documents2_pkg.copy_attachments'

1911: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
1912: IF (FND_LOG.test(FND_LOG.level_unexpected, l_module_name)) THEN
1913: FND_LOG.string(FND_LOG.level_unexpected
1914: ,l_module_name||'.fnd_attached_documents2_pkg.copy_attachments'
1915: ,'After call to fnd_attached_documents2_pkg.copy_attachments'
1916: ||' '||SQLERRM
1917: );
1918: END IF;
1919: END IF;