[Home] [Help]
2763: p_id IN NUMBER,
2764: p_object_version_number IN NUMBER
2765: ) IS
2766:
2767: l_standard_yn VARCHAR2(1) := 'Y';
2768: l_article_id NUMBER;
2769: l_article_version_id NUMBER;
2770: l_non_std_exists VARCHAR2(1) := 'N';
2771: l_return_status VARCHAR2(30);
2772: l_msg_count NUMBER;
2773: l_msg_data VARCHAR2(2000);
2774:
2775: CURSOR l_art_csr (cp_id IN NUMBER) IS
2776: SELECT art.standard_yn,
2777: kart.sav_sae_id,
2778: kart.article_version_id
2779: FROM okc_k_articles_b kart,
2780: okc_articles_all art
2796: Okc_Debug.Log('6400: Entered Delete_Row', 2);
2797: END IF;
2798:
2799: OPEN l_art_csr(p_id);
2800: FETCH l_art_csr INTO l_standard_yn,l_article_id,l_article_version_id;
2801: CLOSE l_art_csr;
2802:
2803: x_return_status := Lock_row(
2804: p_id => p_id,
2816: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2817: RAISE OKC_API.G_EXCEPTION_ERROR;
2818: END IF;
2819:
2820: IF l_standard_yn = 'N' THEN
2821: OPEN l_non_std_exists_csr(l_article_version_id);
2822: FETCH l_non_std_exists_csr INTO l_non_std_exists;
2823: IF l_non_std_exists_csr%NOTFOUND THEN
2824: OKC_ARTICLES_GRP.delete_article(
3061: OKC_ARTICLES_ALL ART
3062: WHERE KART.document_type = p_doc_type
3063: AND KART.document_id = p_doc_id
3064: AND KART.SAV_SAE_ID = ART.ARTICLE_ID
3065: AND ART.STANDARD_YN = 'N';
3066:
3067: BEGIN
3068:
3069: IF (l_debug = 'Y') THEN
3201: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3202: p_commit => FND_API.G_FALSE,
3203: p_article_version_id => rec.article_version_id,
3204: p_new_article_title => NULL,
3205: p_create_standard_yn => 'N',
3206: x_article_version_id => l_article_version_id,
3207: x_article_id => l_article_id,
3208: x_article_number => l_article_number,
3209: x_return_status => l_return_status,