DBA Data[Home] [Help]

APPS.OKS_COPY_CONTRACT_PVT dependencies on FND_ATTACHMENT_UTIL_PKG

Line 1176: FND_ATTACHMENT_UTIL_PKG.function_name IS NULL

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

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

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

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

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

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

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

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

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

Line 1856: -- before calling fnd_attachment_util_pkg.get_atchmt_exists

1852: RAISE G_EXCEPTION_HALT_VALIDATION;
1853: END IF;
1854:
1855: -- set attachement session variables
1856: -- before calling fnd_attachment_util_pkg.get_atchmt_exists
1857: Set_Attach_Session_Vars(p_from_chr_id);
1858:
1859: l_entity_name := 'OKC_K_HEADERS_V';
1860: l_from_entity_name := 'OKC_K_HEADERS_V';

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

1861: l_to_entity_name := 'OKC_K_HEADERS_V';
1862:
1863: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1864: FND_LOG.string(FND_LOG.level_statement
1865: ,l_module_name||'.fnd_attachment_util_pkg.get_atchmt_exists'
1866: ,'Before call to fnd_attachment_util_pkg.get_atchmt_exists'
1867: ||' l_entity_name='||l_entity_name
1868: ||',l_pkey1='||p_from_chr_id
1869: ||',l_peky2='||l_from_version

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

1862:
1863: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1864: FND_LOG.string(FND_LOG.level_statement
1865: ,l_module_name||'.fnd_attachment_util_pkg.get_atchmt_exists'
1866: ,'Before call to fnd_attachment_util_pkg.get_atchmt_exists'
1867: ||' l_entity_name='||l_entity_name
1868: ||',l_pkey1='||p_from_chr_id
1869: ||',l_peky2='||l_from_version
1870: ||',x_to_chr_id='||x_to_chr_id

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

1867: ||' l_entity_name='||l_entity_name
1868: ||',l_pkey1='||p_from_chr_id
1869: ||',l_peky2='||l_from_version
1870: ||',x_to_chr_id='||x_to_chr_id
1871: ||',12_function_type='||FND_ATTACHMENT_UTIL_PKG.function_type
1872: ||',12_function_name='||FND_ATTACHMENT_UTIL_PKG.function_name
1873: );
1874: END IF;
1875: If (fnd_attachment_util_pkg.get_atchmt_exists (

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

1868: ||',l_pkey1='||p_from_chr_id
1869: ||',l_peky2='||l_from_version
1870: ||',x_to_chr_id='||x_to_chr_id
1871: ||',12_function_type='||FND_ATTACHMENT_UTIL_PKG.function_type
1872: ||',12_function_name='||FND_ATTACHMENT_UTIL_PKG.function_name
1873: );
1874: END IF;
1875: If (fnd_attachment_util_pkg.get_atchmt_exists (
1876: l_entity_name => l_entity_name,

Line 1875: If (fnd_attachment_util_pkg.get_atchmt_exists (

1871: ||',12_function_type='||FND_ATTACHMENT_UTIL_PKG.function_type
1872: ||',12_function_name='||FND_ATTACHMENT_UTIL_PKG.function_name
1873: );
1874: END IF;
1875: If (fnd_attachment_util_pkg.get_atchmt_exists (
1876: l_entity_name => l_entity_name,
1877: l_pkey1 => p_from_chr_id
1878: --l_pkey2 => l_from_version
1879: ) = 'Y') then

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

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'
1890: );
1891: END IF;
1892:
1893: Begin