1246: FROM okc_k_headers_b
1247: WHERE id = p_chr_id;
1248: BEGIN
1249: IF (p_chr_id IS NOT NULL AND
1250: FND_ATTACHMENT_UTIL_PKG.function_name IS NULL
1251: )
1252: THEN
1253: OPEN l_chr_csr;
1254: FETCH l_chr_csr INTO l_app_id;
1253: OPEN l_chr_csr;
1254: FETCH l_chr_csr INTO l_app_id;
1255: CLOSE l_chr_csr;
1256: IF (l_app_id = 510) THEN
1257: FND_ATTACHMENT_UTIL_PKG.function_name := 'OKCAUDET';
1258: FND_ATTACHMENT_UTIL_PKG.function_type := 'O';
1259: ELSIF (l_app_id = 515) THEN
1260: FND_ATTACHMENT_UTIL_PKG.function_name := 'OKSAUDET';
1261: FND_ATTACHMENT_UTIL_PKG.function_type := 'O';
1254: FETCH l_chr_csr INTO l_app_id;
1255: CLOSE l_chr_csr;
1256: IF (l_app_id = 510) THEN
1257: FND_ATTACHMENT_UTIL_PKG.function_name := 'OKCAUDET';
1258: FND_ATTACHMENT_UTIL_PKG.function_type := 'O';
1259: ELSIF (l_app_id = 515) THEN
1260: FND_ATTACHMENT_UTIL_PKG.function_name := 'OKSAUDET';
1261: FND_ATTACHMENT_UTIL_PKG.function_type := 'O';
1262: END IF;
1256: IF (l_app_id = 510) THEN
1257: FND_ATTACHMENT_UTIL_PKG.function_name := 'OKCAUDET';
1258: FND_ATTACHMENT_UTIL_PKG.function_type := 'O';
1259: ELSIF (l_app_id = 515) THEN
1260: FND_ATTACHMENT_UTIL_PKG.function_name := 'OKSAUDET';
1261: FND_ATTACHMENT_UTIL_PKG.function_type := 'O';
1262: END IF;
1263: END IF;
1264: END;
1257: FND_ATTACHMENT_UTIL_PKG.function_name := 'OKCAUDET';
1258: FND_ATTACHMENT_UTIL_PKG.function_type := 'O';
1259: ELSIF (l_app_id = 515) THEN
1260: FND_ATTACHMENT_UTIL_PKG.function_name := 'OKSAUDET';
1261: FND_ATTACHMENT_UTIL_PKG.function_type := 'O';
1262: END IF;
1263: END IF;
1264: END;
1265: