[Home] [Help]
2797: p_id IN NUMBER,
2798: p_object_version_number IN NUMBER
2799: ) IS
2800:
2801: l_standard_yn VARCHAR2(1) := 'Y';
2802: l_article_id NUMBER;
2803: l_article_version_id NUMBER;
2804: l_non_std_exists VARCHAR2(1) := 'N';
2805: l_return_status VARCHAR2(30);
2806: l_msg_count NUMBER;
2807: l_msg_data VARCHAR2(2000);
2808:
2809: CURSOR l_art_csr (cp_id IN NUMBER) IS
2810: SELECT art.standard_yn,
2811: kart.sav_sae_id,
2812: kart.article_version_id
2813: FROM okc_k_articles_b kart,
2814: okc_articles_all art
2830: Okc_Debug.Log('6400: Entered Delete_Row', 2);
2831: END IF;
2832:
2833: OPEN l_art_csr(p_id);
2834: FETCH l_art_csr INTO l_standard_yn,l_article_id,l_article_version_id;
2835: CLOSE l_art_csr;
2836:
2837: x_return_status := Lock_row(
2838: p_id => p_id,
2850: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2851: RAISE OKC_API.G_EXCEPTION_ERROR;
2852: END IF;
2853:
2854: IF l_standard_yn = 'N' THEN
2855: OPEN l_non_std_exists_csr(l_article_version_id);
2856: FETCH l_non_std_exists_csr INTO l_non_std_exists;
2857: IF l_non_std_exists_csr%NOTFOUND THEN
2858: OKC_ARTICLES_GRP.delete_article(
3105: OKC_ARTICLES_ALL ART
3106: WHERE KART.document_type = p_doc_type
3107: AND KART.document_id = p_doc_id
3108: AND KART.SAV_SAE_ID = ART.ARTICLE_ID
3109: AND ART.STANDARD_YN = 'N';
3110:
3111: BEGIN
3112:
3113: IF (l_debug = 'Y') THEN
3247: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3248: p_commit => FND_API.G_FALSE,
3249: p_article_version_id => rec.article_version_id,
3250: p_new_article_title => NULL,
3251: p_create_standard_yn => 'N',
3252: x_article_version_id => l_article_version_id,
3253: x_article_id => l_article_id,
3254: x_article_number => l_article_number,
3255: x_return_status => l_return_status,