APPS.OKS_COPY_CONTRACT_PVT dependencies on FND_ATTACHED_DOCUMENTS

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

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

Line 1595: l_from_version FND_ATTACHED_DOCUMENTS.PK2_VALUE%TYPE;

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

Line 1922: -- in fnd_attached_documents2_pkg.copy_attachments call

1918: -- The following line to be added to the code once
1919: -- bug 1553916 completes
1920: -- ,l_pkey2 => l_from_version) = 'Y')
1921: -- also below remove the comments
1922: -- in fnd_attached_documents2_pkg.copy_attachments call
1923: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1924: FND_LOG.string(FND_LOG.level_statement
1925: ,l_module_name
1926: ,'After call to fnd_attachment_util_pkg.get_atchmt_exists'

Line 1931: fnd_attached_documents2_pkg.copy_attachments(

1927: );
1928: END IF;
1929:
1930: Begin
1931: fnd_attached_documents2_pkg.copy_attachments(
1932: x_from_entity_name => l_from_entity_name,
1933: x_from_pk1_value => p_from_chr_id,
1934: --x_from_pk2_value => l_from_version,
1935: x_to_entity_name => l_to_entity_name,

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

1938: );
1939: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1940: FND_LOG.string(FND_LOG.level_statement
1941: ,l_module_name
1942: ,'After call to fnd_attached_documents2_pkg.copy_attachments'
1943: );
1944: END IF;
1945:
1946: EXCEPTION

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

1947: WHEN OTHERS THEN
1948: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
1949: IF (FND_LOG.test(FND_LOG.level_unexpected, l_module_name)) THEN
1950: FND_LOG.string(FND_LOG.level_unexpected
1951: ,l_module_name||'.fnd_attached_documents2_pkg.copy_attachments'
1952: ,'After call to fnd_attached_documents2_pkg.copy_attachments'
1953: ||' '||SQLERRM
1954: );
1955: END IF;

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

1948: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
1949: IF (FND_LOG.test(FND_LOG.level_unexpected, l_module_name)) THEN
1950: FND_LOG.string(FND_LOG.level_unexpected
1951: ,l_module_name||'.fnd_attached_documents2_pkg.copy_attachments'
1952: ,'After call to fnd_attached_documents2_pkg.copy_attachments'
1953: ||' '||SQLERRM
1954: );
1955: END IF;
1956: END IF;