DBA Data[Home] [Help]

APPS.OKS_COPY_CONTRACT_PVT dependencies on FND_ATTACHMENT_UTIL_PKG

Line 1178: FND_ATTACHMENT_UTIL_PKG.function_name IS NULL

1174: FROM okc_k_headers_b
1175: WHERE id = p_chr_id;
1176: BEGIN
1177: If (p_chr_id IS NOT NULL AND
1178: FND_ATTACHMENT_UTIL_PKG.function_name IS NULL
1179: )
1180: Then
1181: open l_chr_csr;
1182: fetch l_chr_csr into l_app_id;

Line 1187: FND_ATTACHMENT_UTIL_PKG.function_name := 'OKSAUDET';

1183: close l_chr_csr;
1184:
1185: -- Added for Bug 2384423
1186: If (l_app_id = 515) Then
1187: FND_ATTACHMENT_UTIL_PKG.function_name := 'OKSAUDET';
1188: FND_ATTACHMENT_UTIL_PKG.function_type := 'O';
1189: Else
1190: FND_ATTACHMENT_UTIL_PKG.function_name := 'OKCAUDET';
1191: FND_ATTACHMENT_UTIL_PKG.function_type := 'O';

Line 1188: FND_ATTACHMENT_UTIL_PKG.function_type := 'O';

1184:
1185: -- Added for Bug 2384423
1186: If (l_app_id = 515) Then
1187: FND_ATTACHMENT_UTIL_PKG.function_name := 'OKSAUDET';
1188: FND_ATTACHMENT_UTIL_PKG.function_type := 'O';
1189: Else
1190: FND_ATTACHMENT_UTIL_PKG.function_name := 'OKCAUDET';
1191: FND_ATTACHMENT_UTIL_PKG.function_type := 'O';
1192: End If;

Line 1190: FND_ATTACHMENT_UTIL_PKG.function_name := 'OKCAUDET';

1186: If (l_app_id = 515) Then
1187: FND_ATTACHMENT_UTIL_PKG.function_name := 'OKSAUDET';
1188: FND_ATTACHMENT_UTIL_PKG.function_type := 'O';
1189: Else
1190: FND_ATTACHMENT_UTIL_PKG.function_name := 'OKCAUDET';
1191: FND_ATTACHMENT_UTIL_PKG.function_type := 'O';
1192: End If;
1193:
1194: End If;

Line 1191: FND_ATTACHMENT_UTIL_PKG.function_type := 'O';

1187: FND_ATTACHMENT_UTIL_PKG.function_name := 'OKSAUDET';
1188: FND_ATTACHMENT_UTIL_PKG.function_type := 'O';
1189: Else
1190: FND_ATTACHMENT_UTIL_PKG.function_name := 'OKCAUDET';
1191: FND_ATTACHMENT_UTIL_PKG.function_type := 'O';
1192: End If;
1193:
1194: End If;
1195: END;

Line 1893: -- before calling fnd_attachment_util_pkg.get_atchmt_exists

1889: RAISE G_EXCEPTION_HALT_VALIDATION;
1890: END IF;
1891:
1892: -- set attachement session variables
1893: -- before calling fnd_attachment_util_pkg.get_atchmt_exists
1894: Set_Attach_Session_Vars(p_from_chr_id);
1895:
1896: l_entity_name := 'OKC_K_HEADERS_V';
1897: l_from_entity_name := 'OKC_K_HEADERS_V';

Line 1902: ,l_module_name||'.fnd_attachment_util_pkg.get_atchmt_exists'

1898: l_to_entity_name := 'OKC_K_HEADERS_V';
1899:
1900: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1901: FND_LOG.string(FND_LOG.level_statement
1902: ,l_module_name||'.fnd_attachment_util_pkg.get_atchmt_exists'
1903: ,'Before call to fnd_attachment_util_pkg.get_atchmt_exists'
1904: ||' l_entity_name='||l_entity_name
1905: ||',l_pkey1='||p_from_chr_id
1906: ||',l_peky2='||l_from_version

Line 1903: ,'Before call to fnd_attachment_util_pkg.get_atchmt_exists'

1899:
1900: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1901: FND_LOG.string(FND_LOG.level_statement
1902: ,l_module_name||'.fnd_attachment_util_pkg.get_atchmt_exists'
1903: ,'Before call to fnd_attachment_util_pkg.get_atchmt_exists'
1904: ||' l_entity_name='||l_entity_name
1905: ||',l_pkey1='||p_from_chr_id
1906: ||',l_peky2='||l_from_version
1907: ||',x_to_chr_id='||x_to_chr_id

Line 1908: ||',12_function_type='||FND_ATTACHMENT_UTIL_PKG.function_type

1904: ||' l_entity_name='||l_entity_name
1905: ||',l_pkey1='||p_from_chr_id
1906: ||',l_peky2='||l_from_version
1907: ||',x_to_chr_id='||x_to_chr_id
1908: ||',12_function_type='||FND_ATTACHMENT_UTIL_PKG.function_type
1909: ||',12_function_name='||FND_ATTACHMENT_UTIL_PKG.function_name
1910: );
1911: END IF;
1912: If (fnd_attachment_util_pkg.get_atchmt_exists (

Line 1909: ||',12_function_name='||FND_ATTACHMENT_UTIL_PKG.function_name

1905: ||',l_pkey1='||p_from_chr_id
1906: ||',l_peky2='||l_from_version
1907: ||',x_to_chr_id='||x_to_chr_id
1908: ||',12_function_type='||FND_ATTACHMENT_UTIL_PKG.function_type
1909: ||',12_function_name='||FND_ATTACHMENT_UTIL_PKG.function_name
1910: );
1911: END IF;
1912: If (fnd_attachment_util_pkg.get_atchmt_exists (
1913: l_entity_name => l_entity_name,

Line 1912: If (fnd_attachment_util_pkg.get_atchmt_exists (

1908: ||',12_function_type='||FND_ATTACHMENT_UTIL_PKG.function_type
1909: ||',12_function_name='||FND_ATTACHMENT_UTIL_PKG.function_name
1910: );
1911: END IF;
1912: If (fnd_attachment_util_pkg.get_atchmt_exists (
1913: l_entity_name => l_entity_name,
1914: l_pkey1 => p_from_chr_id
1915: --l_pkey2 => l_from_version
1916: ) = 'Y') then

Line 1926: ,'After call to fnd_attachment_util_pkg.get_atchmt_exists'

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'
1927: );
1928: END IF;
1929:
1930: Begin