The following lines contain the word 'select', 'insert', 'update' or 'delete':
G_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_DELETED;
G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
G_LOCK_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_LOCK_RECORD_DELETED;
G_AMEND_CODE_DELETED CONSTANT VARCHAR2(30) := 'DELETED';
G_AMEND_CODE_UPDATED CONSTANT VARCHAR2(30) := 'UPDATED';
SELECT OKC_K_ARTICLES_B_S.NEXTVAL FROM DUAL;
x_last_updated_by OUT NOCOPY NUMBER,
x_last_update_login OUT NOCOPY NUMBER,
x_last_update_date OUT NOCOPY DATE,
x_last_amended_by OUT NOCOPY NUMBER,
x_last_amendment_date OUT NOCOPY DATE
) RETURN VARCHAR2 IS
CURSOR OKC_K_ARTICLES_B_pk_csr (cp_id IN NUMBER) IS
SELECT
SAV_SAE_ID,
DOCUMENT_TYPE,
DOCUMENT_ID,
CLE_ID,
SOURCE_FLAG,
MANDATORY_YN,
SCN_ID,
LABEL,
AMENDMENT_DESCRIPTION,
AMENDMENT_OPERATION_CODE,
ARTICLE_VERSION_ID,
CHANGE_NONSTD_YN,
ORIG_SYSTEM_REFERENCE_CODE,
ORIG_SYSTEM_REFERENCE_ID1,
ORIG_SYSTEM_REFERENCE_ID2,
DISPLAY_SEQUENCE,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
PRINT_TEXT_YN,
SUMMARY_AMEND_OPERATION_CODE,
REF_ARTICLE_ID,
REF_ARTICLE_VERSION_ID,
OBJECT_VERSION_NUMBER,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
LAST_UPDATE_DATE,
LAST_AMENDED_BY,
LAST_AMENDMENT_DATE
FROM OKC_K_ARTICLES_B t
WHERE t.ID = cp_id;
SELECT
SAV_SAE_ID,
DOCUMENT_TYPE,
DOCUMENT_ID,
CLE_ID,
SOURCE_FLAG,
MANDATORY_YN,
SCN_ID,
LABEL,
AMENDMENT_DESCRIPTION,
AMENDMENT_OPERATION_CODE,
ARTICLE_VERSION_ID,
CHANGE_NONSTD_YN,
ORIG_SYSTEM_REFERENCE_CODE,
ORIG_SYSTEM_REFERENCE_ID1,
ORIG_SYSTEM_REFERENCE_ID2,
DISPLAY_SEQUENCE,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
PRINT_TEXT_YN,
SUMMARY_AMEND_OPERATION_CODE,
REF_ARTICLE_ID,
REF_ARTICLE_VERSION_ID,
OBJECT_VERSION_NUMBER,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
LAST_UPDATE_DATE,
LAST_AMENDED_BY,
LAST_AMENDMENT_DATE
FROM OKC_K_ARTICLES_BH t
WHERE t.ID = cp_id and major_version=cp_major_version;
x_last_updated_by,
x_last_update_login,
x_last_update_date,
x_last_amended_by,
x_last_amendment_date;
Okc_Api.Set_Message(G_APP_NAME,G_LOCK_RECORD_DELETED,
'ENTITYNAME','OKC_K_ARTICLES_B',
'PKEY',p_id,
'OVN',p_major_version
);
x_last_updated_by,
x_last_update_login,
x_last_update_date,
x_last_amended_by,
x_last_amendment_date;
Okc_Api.Set_Message(G_APP_NAME,G_LOCK_RECORD_DELETED,
'ENTITYNAME','OKC_K_ARTICLES_BH',
'PKEY',p_id,
'OVN',p_major_version
);
l_last_updated_by OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;
l_last_update_login OKC_K_ARTICLES_B.LAST_UPDATE_LOGIN%TYPE;
l_last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE;
x_last_updated_by => l_last_updated_by,
x_last_update_login => l_last_update_login,
x_last_update_date => l_last_update_date,
x_last_amended_by => x_last_amended_by,
x_last_amendment_date => x_last_amendment_date
);
SELECT '!'
FROM okc_articles_all
WHERE article_id = p_sav_sae_id;
SELECT '!'
FROM okc_sections_b
WHERE ID = p_scn_id;
SELECT '!'
FROM okc_article_versions
WHERE ARTICLE_VERSION_ID = p_article_version_id;
SELECT '!'
FROM OKC_BUS_DOC_TYPES_V
WHERE document_type = p_document_type;
SELECT '!' FROM OKC_SECTIONS_B
WHERE ID = p_scn_id
AND AMENDMENT_OPERATION_CODE = G_AMEND_CODE_DELETED;
IF p_amendment_operation_code IN (G_AMEND_CODE_UPDATED,G_AMEND_CODE_ADDED) THEN
l_dummy_var := '?';
SELECT '!' FROM OKC_ARTICLE_VERSIONS
WHERE ARTICLE_VERSION_ID = p_article_version_id
AND ARTICLE_ID = p_sav_sae_id;
l_last_updated_by OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;
l_last_update_login OKC_K_ARTICLES_B.LAST_UPDATE_LOGIN%TYPE;
l_last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE;
FUNCTION Insert_Row(
p_id IN NUMBER,
p_sav_sae_id IN NUMBER,
p_cat_type IN VARCHAR2, -- Bug 3341342
p_document_type IN VARCHAR2,
p_document_id IN NUMBER,
p_cle_id IN NUMBER,
p_source_flag IN VARCHAR2,
p_mandatory_yn IN VARCHAR2,
p_scn_id IN NUMBER,
p_label IN VARCHAR2,
p_amendment_description IN VARCHAR2,
p_amendment_operation_code IN VARCHAR2,
p_article_version_id IN NUMBER,
p_change_nonstd_yn IN VARCHAR2,
p_orig_system_reference_code IN VARCHAR2,
p_orig_system_reference_id1 IN NUMBER,
p_orig_system_reference_id2 IN NUMBER,
p_display_sequence IN NUMBER,
p_attribute_category IN VARCHAR2,
p_attribute1 IN VARCHAR2,
p_attribute2 IN VARCHAR2,
p_attribute3 IN VARCHAR2,
p_attribute4 IN VARCHAR2,
p_attribute5 IN VARCHAR2,
p_attribute6 IN VARCHAR2,
p_attribute7 IN VARCHAR2,
p_attribute8 IN VARCHAR2,
p_attribute9 IN VARCHAR2,
p_attribute10 IN VARCHAR2,
p_attribute11 IN VARCHAR2,
p_attribute12 IN VARCHAR2,
p_attribute13 IN VARCHAR2,
p_attribute14 IN VARCHAR2,
p_attribute15 IN VARCHAR2,
p_print_text_yn IN VARCHAR2,
p_summary_amend_operation_code IN VARCHAR2,
p_ref_article_id IN NUMBER,
p_ref_article_version_id IN NUMBER,
p_object_version_number IN NUMBER,
p_created_by IN NUMBER,
p_creation_date IN DATE,
p_last_updated_by IN NUMBER,
p_last_update_login IN NUMBER,
p_last_update_date IN DATE,
p_last_amended_by IN NUMBER,
p_last_amendment_date IN DATE
) RETURN VARCHAR2 IS
l_chr_id NUMBER;
Okc_Debug.Log('3100: Entered Insert_Row function', 2);
INSERT INTO OKC_K_ARTICLES_B(
ID,
SAV_SAE_ID,
SAV_SAV_RELEASE,
SBT_CODE,
CAT_TYPE,
CHR_ID,
CAT_ID,
DNZ_CHR_ID,
FULLTEXT_YN,
DOCUMENT_TYPE,
DOCUMENT_ID,
CLE_ID,
SOURCE_FLAG,
MANDATORY_YN,
SCN_ID,
LABEL,
AMENDMENT_DESCRIPTION,
AMENDMENT_OPERATION_CODE,
ARTICLE_VERSION_ID,
CHANGE_NONSTD_YN,
ORIG_SYSTEM_REFERENCE_CODE,
ORIG_SYSTEM_REFERENCE_ID1,
ORIG_SYSTEM_REFERENCE_ID2,
DISPLAY_SEQUENCE,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
PRINT_TEXT_YN,
SUMMARY_AMEND_OPERATION_CODE,
REF_ARTICLE_ID,
REF_ARTICLE_VERSION_ID,
OBJECT_VERSION_NUMBER,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
LAST_UPDATE_DATE,
ORIG_ARTICLE_ID,
LAST_AMENDED_BY,
LAST_AMENDMENT_DATE)
VALUES (
p_id,
p_sav_sae_id,
Null,
Null,
p_cat_type,--Bug 3341342
decode(p_cle_id,NULL,l_chr_id,NULL),
Null,
l_chr_id,
Null,
p_document_type,
p_document_id,
p_cle_id,
p_source_flag,
p_mandatory_yn,
p_scn_id,
p_label,
p_amendment_description,
p_amendment_operation_code,
decode(p_document_type, OKC_TERMS_UTIL_GRP.G_TMPL_DOC_TYPE,NULL,p_article_version_id),
p_change_nonstd_yn,
p_orig_system_reference_code,
p_orig_system_reference_id1,
p_orig_system_reference_id2,
p_display_sequence,
p_attribute_category,
p_attribute1,
p_attribute2,
p_attribute3,
p_attribute4,
p_attribute5,
p_attribute6,
p_attribute7,
p_attribute8,
p_attribute9,
p_attribute10,
p_attribute11,
p_attribute12,
p_attribute13,
p_attribute14,
p_attribute15,
p_print_text_yn,
p_summary_amend_operation_code,
p_ref_article_id,
p_ref_article_version_id,
p_object_version_number,
p_created_by,
p_creation_date,
p_last_updated_by,
p_last_update_login,
p_last_update_date,
p_sav_sae_id,
p_last_amended_by,
p_last_amendment_date);
Okc_Debug.Log('3200: Leaving Insert_Row', 2);
Okc_Debug.Log('3300: Leaving Insert_Row:OTHERS Exception', 2);
END Insert_Row;
PROCEDURE Insert_Row(
p_validation_level IN NUMBER,
x_return_status OUT NOCOPY VARCHAR2,
p_id IN NUMBER,
p_sav_sae_id IN NUMBER,
p_cat_type IN VARCHAR2,--Bug 3341342
p_document_type IN VARCHAR2,
p_document_id IN NUMBER,
p_cle_id IN NUMBER,
p_source_flag IN VARCHAR2,
p_mandatory_yn IN VARCHAR2,
p_scn_id IN NUMBER,
p_label IN VARCHAR2,
p_amendment_description IN VARCHAR2,
p_amendment_operation_code IN VARCHAR2,
p_article_version_id IN NUMBER,
p_change_nonstd_yn IN VARCHAR2,
p_orig_system_reference_code IN VARCHAR2,
p_orig_system_reference_id1 IN NUMBER,
p_orig_system_reference_id2 IN NUMBER,
p_display_sequence IN NUMBER,
p_attribute_category IN VARCHAR2,
p_attribute1 IN VARCHAR2,
p_attribute2 IN VARCHAR2,
p_attribute3 IN VARCHAR2,
p_attribute4 IN VARCHAR2,
p_attribute5 IN VARCHAR2,
p_attribute6 IN VARCHAR2,
p_attribute7 IN VARCHAR2,
p_attribute8 IN VARCHAR2,
p_attribute9 IN VARCHAR2,
p_attribute10 IN VARCHAR2,
p_attribute11 IN VARCHAR2,
p_attribute12 IN VARCHAR2,
p_attribute13 IN VARCHAR2,
p_attribute14 IN VARCHAR2,
p_attribute15 IN VARCHAR2,
p_print_text_yn IN VARCHAR2,
p_summary_amend_operation_code IN VARCHAR2,
p_ref_article_id IN NUMBER,
p_ref_article_version_id IN NUMBER,
x_id OUT NOCOPY NUMBER
) IS
l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;
l_last_updated_by OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;
l_last_update_login OKC_K_ARTICLES_B.LAST_UPDATE_LOGIN%TYPE;
l_last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE;
Okc_Debug.Log('3400: Entered Insert_Row', 2);
l_last_update_date := l_creation_date;
l_last_updated_by := l_created_by;
l_last_update_login := Fnd_Global.Login_Id;
x_return_status := Insert_Row(
p_id => x_id,
p_sav_sae_id => p_sav_sae_id,
p_cat_type => p_cat_type, --Bug 3341342
p_document_type => p_document_type,
p_document_id => p_document_id,
p_cle_id => p_cle_id,
p_source_flag => p_source_flag,
p_mandatory_yn => p_mandatory_yn,
p_scn_id => p_scn_id,
p_label => p_label,
p_amendment_description => p_amendment_description,
p_amendment_operation_code => p_amendment_operation_code,
p_article_version_id => p_article_version_id,
p_change_nonstd_yn => p_change_nonstd_yn,
p_orig_system_reference_code => p_orig_system_reference_code,
p_orig_system_reference_id1 => p_orig_system_reference_id1,
p_orig_system_reference_id2 => p_orig_system_reference_id2,
p_display_sequence => p_display_sequence,
p_attribute_category => p_attribute_category,
p_attribute1 => p_attribute1,
p_attribute2 => p_attribute2,
p_attribute3 => p_attribute3,
p_attribute4 => p_attribute4,
p_attribute5 => p_attribute5,
p_attribute6 => p_attribute6,
p_attribute7 => p_attribute7,
p_attribute8 => p_attribute8,
p_attribute9 => p_attribute9,
p_attribute10 => p_attribute10,
p_attribute11 => p_attribute11,
p_attribute12 => p_attribute12,
p_attribute13 => p_attribute13,
p_attribute14 => p_attribute14,
p_attribute15 => p_attribute15,
p_print_text_yn => p_print_text_yn,
p_summary_amend_operation_code=> p_summary_amend_operation_code,
p_ref_article_id => p_ref_article_id,
p_ref_article_version_id => p_ref_article_version_id,
p_object_version_number => l_object_version_number,
p_created_by => l_created_by,
p_creation_date => l_creation_date,
p_last_updated_by => l_last_updated_by,
p_last_update_login => l_last_update_login,
p_last_update_date => l_last_update_date,
p_last_amended_by => l_last_amended_by,
p_last_amendment_date => l_last_amendment_date
);
Okc_Debug.Log('3500: Leaving Insert_Row', 2);
Okc_Debug.Log('3600: Leaving Insert_Row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
Okc_Debug.Log('3700: Leaving Insert_Row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
Okc_Debug.Log('3800: Leaving Insert_Row because of EXCEPTION: '||sqlerrm, 2);
END Insert_Row;
SELECT object_version_number
FROM OKC_K_ARTICLES_B
WHERE ID = cp_id
AND (object_version_number = cp_object_version_number OR cp_object_version_number IS NULL)
FOR UPDATE OF object_version_number NOWAIT;
SELECT object_version_number
FROM OKC_K_ARTICLES_B
WHERE ID = cp_id;
Okc_Api.Set_Message(G_APP_NAME,G_LOCK_RECORD_DELETED,
'ENTITYNAME','OKC_K_ARTICLES_B',
'PKEY',p_id,
'OVN',p_object_version_number
);
Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
FUNCTION Update_Row(
p_id IN NUMBER,
p_sav_sae_id IN NUMBER,
p_document_type IN VARCHAR2,
p_document_id IN NUMBER,
p_cle_id IN NUMBER,
p_source_flag IN VARCHAR2,
p_mandatory_yn IN VARCHAR2,
p_scn_id IN NUMBER,
p_label IN VARCHAR2,
p_amendment_description IN VARCHAR2,
p_amendment_operation_code IN VARCHAR2,
p_article_version_id IN NUMBER,
p_change_nonstd_yn IN VARCHAR2,
p_orig_system_reference_code IN VARCHAR2,
p_orig_system_reference_id1 IN NUMBER,
p_orig_system_reference_id2 IN NUMBER,
p_display_sequence IN NUMBER,
p_attribute_category IN VARCHAR2,
p_attribute1 IN VARCHAR2,
p_attribute2 IN VARCHAR2,
p_attribute3 IN VARCHAR2,
p_attribute4 IN VARCHAR2,
p_attribute5 IN VARCHAR2,
p_attribute6 IN VARCHAR2,
p_attribute7 IN VARCHAR2,
p_attribute8 IN VARCHAR2,
p_attribute9 IN VARCHAR2,
p_attribute10 IN VARCHAR2,
p_attribute11 IN VARCHAR2,
p_attribute12 IN VARCHAR2,
p_attribute13 IN VARCHAR2,
p_attribute14 IN VARCHAR2,
p_attribute15 IN VARCHAR2,
p_print_text_yn IN VARCHAR2,
p_summary_amend_operation_code IN VARCHAR2,
p_ref_article_id IN NUMBER,
p_ref_article_version_id IN NUMBER,
p_object_version_number IN NUMBER,
p_created_by IN NUMBER,
p_creation_date IN DATE,
p_last_updated_by IN NUMBER,
p_last_update_login IN NUMBER,
p_last_update_date IN DATE,
p_last_amended_by IN NUMBER,
p_last_amendment_date IN DATE
) RETURN VARCHAR2 IS
l_chr_id NUMBER;
Okc_Debug.Log('4800: Entered Update_Row', 2);
UPDATE OKC_K_ARTICLES_B
SET SAV_SAE_ID = p_sav_sae_id,
DOCUMENT_TYPE = p_document_type,
DOCUMENT_ID = p_document_id,
CLE_ID = p_cle_id,
SOURCE_FLAG = p_source_flag,
MANDATORY_YN = p_mandatory_yn,
SCN_ID = p_scn_id,
CHR_ID = decode(p_cle_id,NULL,l_chr_id,NULL),
DNZ_CHR_ID = l_chr_id,
LABEL = p_label,
AMENDMENT_DESCRIPTION = p_amendment_description,
AMENDMENT_OPERATION_CODE = p_amendment_operation_code,
ARTICLE_VERSION_ID = decode(p_document_type,OKC_TERMS_UTIL_GRP.G_TMPL_DOC_TYPE,NULL,p_article_version_id),
CHANGE_NONSTD_YN = p_change_nonstd_yn,
ORIG_SYSTEM_REFERENCE_CODE = p_orig_system_reference_code,
ORIG_SYSTEM_REFERENCE_ID1 = p_orig_system_reference_id1,
ORIG_SYSTEM_REFERENCE_ID2 = p_orig_system_reference_id2,
DISPLAY_SEQUENCE = p_display_sequence,
ATTRIBUTE_CATEGORY = p_attribute_category,
ATTRIBUTE1 = p_attribute1,
ATTRIBUTE2 = p_attribute2,
ATTRIBUTE3 = p_attribute3,
ATTRIBUTE4 = p_attribute4,
ATTRIBUTE5 = p_attribute5,
ATTRIBUTE6 = p_attribute6,
ATTRIBUTE7 = p_attribute7,
ATTRIBUTE8 = p_attribute8,
ATTRIBUTE9 = p_attribute9,
ATTRIBUTE10 = p_attribute10,
ATTRIBUTE11 = p_attribute11,
ATTRIBUTE12 = p_attribute12,
ATTRIBUTE13 = p_attribute13,
ATTRIBUTE14 = p_attribute14,
ATTRIBUTE15 = p_attribute15,
PRINT_TEXT_YN = p_print_text_yn,
SUMMARY_AMEND_OPERATION_CODE= p_summary_amend_operation_code,
REF_ARTICLE_ID = p_ref_article_id,
REF_ARTICLE_VERSION_ID = p_ref_article_version_id,
OBJECT_VERSION_NUMBER = p_object_version_number,
LAST_UPDATED_BY = p_last_updated_by,
LAST_UPDATE_LOGIN = p_last_update_login,
LAST_UPDATE_DATE = p_last_update_date,
LAST_AMENDED_BY = p_last_amended_by,
LAST_AMENDMENT_DATE = p_last_amendment_date
WHERE ID = p_id;
Okc_Debug.Log('4900: Leaving Update_Row', 2);
Okc_Debug.Log('5000: Leaving Update_Row because of EXCEPTION: '||sqlerrm, 2);
END Update_Row;
PROCEDURE Update_Row(
p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
x_return_status OUT NOCOPY VARCHAR2,
p_id IN NUMBER,
p_sav_sae_id IN NUMBER,
p_document_type IN VARCHAR2,
p_document_id IN NUMBER,
p_cle_id IN NUMBER,
p_source_flag IN VARCHAR2,
p_mandatory_yn IN VARCHAR2,
p_scn_id IN NUMBER,
p_label IN VARCHAR2,
p_amendment_description IN VARCHAR2,
p_amendment_operation_code IN VARCHAR2,
p_article_version_id IN NUMBER,
p_change_nonstd_yn IN VARCHAR2,
p_orig_system_reference_code IN VARCHAR2,
p_orig_system_reference_id1 IN NUMBER,
p_orig_system_reference_id2 IN NUMBER,
p_display_sequence IN NUMBER,
p_attribute_category IN VARCHAR2,
p_attribute1 IN VARCHAR2,
p_attribute2 IN VARCHAR2,
p_attribute3 IN VARCHAR2,
p_attribute4 IN VARCHAR2,
p_attribute5 IN VARCHAR2,
p_attribute6 IN VARCHAR2,
p_attribute7 IN VARCHAR2,
p_attribute8 IN VARCHAR2,
p_attribute9 IN VARCHAR2,
p_attribute10 IN VARCHAR2,
p_attribute11 IN VARCHAR2,
p_attribute12 IN VARCHAR2,
p_attribute13 IN VARCHAR2,
p_attribute14 IN VARCHAR2,
p_attribute15 IN VARCHAR2,
p_print_text_yn IN VARCHAR2,
p_summary_amend_operation_code IN VARCHAR2,
p_ref_article_id IN NUMBER,
p_ref_article_version_id IN NUMBER,
p_object_version_number IN NUMBER,
p_last_amended_by IN NUMBER,
p_last_amendment_date IN DATE
) IS
l_sav_sae_id OKC_K_ARTICLES_B.SAV_SAE_ID%TYPE;
l_last_updated_by OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;
l_last_update_login OKC_K_ARTICLES_B.LAST_UPDATE_LOGIN%TYPE;
l_last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE;
Okc_Debug.Log('5100: Entered Update_Row', 2);
l_last_update_date := SYSDATE;
l_last_updated_by := FND_GLOBAL.USER_ID;
l_last_update_login := FND_GLOBAL.LOGIN_ID;
x_return_status := Update_Row(
p_id => p_id,
p_sav_sae_id => l_sav_sae_id,
p_document_type => l_document_type,
p_document_id => l_document_id,
p_cle_id => l_cle_id,
p_source_flag => l_source_flag,
p_mandatory_yn => l_mandatory_yn,
p_scn_id => l_scn_id,
p_label => l_label,
p_amendment_description => l_amendment_description,
p_amendment_operation_code => l_amendment_operation_code,
p_article_version_id => l_article_version_id,
p_change_nonstd_yn => l_change_nonstd_yn,
p_orig_system_reference_code => l_orig_system_reference_code,
p_orig_system_reference_id1 => l_orig_system_reference_id1,
p_orig_system_reference_id2 => l_orig_system_reference_id2,
p_display_sequence => l_display_sequence,
p_attribute_category => l_attribute_category,
p_attribute1 => l_attribute1,
p_attribute2 => l_attribute2,
p_attribute3 => l_attribute3,
p_attribute4 => l_attribute4,
p_attribute5 => l_attribute5,
p_attribute6 => l_attribute6,
p_attribute7 => l_attribute7,
p_attribute8 => l_attribute8,
p_attribute9 => l_attribute9,
p_attribute10 => l_attribute10,
p_attribute11 => l_attribute11,
p_attribute12 => l_attribute12,
p_attribute13 => l_attribute13,
p_attribute14 => l_attribute14,
p_attribute15 => l_attribute15,
p_print_text_yn => l_print_text_yn,
p_summary_amend_operation_code => l_summary_amend_operation_code,
p_ref_article_id => l_ref_article_id,
p_ref_article_version_id => l_ref_article_version_id,
p_object_version_number => l_object_version_number,
p_created_by => l_created_by,
p_creation_date => l_creation_date,
p_last_updated_by => l_last_updated_by,
p_last_update_login => l_last_update_login,
p_last_update_date => l_last_update_date,
p_last_amended_by => l_last_amended_by,
p_last_amendment_date => l_last_amendment_date
);
Okc_Debug.Log('5700: Leaving Update_Row', 2);
Okc_Debug.Log('5800: Leaving Update_Row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
Okc_Debug.Log('5900: Leaving Update_Row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
Okc_Debug.Log('6000: Leaving Update_Row because of EXCEPTION: '||sqlerrm, 2);
END Update_Row;
FUNCTION Delete_Row(
p_id IN NUMBER
) RETURN VARCHAR2 IS
BEGIN
IF (l_debug = 'Y') THEN
Okc_Debug.Log('6100: Entered Delete_Row', 2);
DELETE FROM OKC_K_ARTICLES_B WHERE ID = p_ID;
Okc_Debug.Log('6200: Leaving Delete_Row', 2);
Okc_Debug.Log('6300: Leaving Delete_Row because of EXCEPTION: '||sqlerrm, 2);
END Delete_Row;
PROCEDURE Delete_Row(
x_return_status OUT NOCOPY VARCHAR2,
p_id IN NUMBER,
p_object_version_number IN NUMBER
) IS
l_standard_yn VARCHAR2(1) := 'Y';
SELECT art.standard_yn,
kart.sav_sae_id,
kart.article_version_id
FROM okc_k_articles_b kart,
okc_articles_all art
WHERE kart.id = cp_id
AND art.article_id = kart.sav_sae_id;
SELECT 'Y'
FROM okc_k_articles_b
WHERE article_version_id = cp_article_version_id
UNION ALL
SELECT 'Y'
FROM OKC_K_ARTICLES_BH
WHERE article_version_id = cp_article_version_id;
Okc_Debug.Log('6400: Entered Delete_Row', 2);
x_return_status := Delete_Row( p_id => p_id );
OKC_ARTICLES_GRP.delete_article(
p_api_version => 1,
p_init_msg_list => FND_API.G_FALSE,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_article_id => l_article_id,
p_article_version_id => l_article_version_id);
Okc_Debug.Log('6500: Leaving Delete_Row', 2);
Okc_Debug.Log('6600: Leaving Delete_Row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
Okc_Debug.Log('6700: Leaving Delete_Row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
Okc_Debug.Log('6800: Leaving Delete_Row because of EXCEPTION: '||sqlerrm, 2);
END Delete_Row;
PROCEDURE delete_set(
x_return_status OUT NOCOPY VARCHAR2,
p_scn_id IN NUMBER
) IS
CURSOR lock_csr IS
SELECT rowid
FROM OKC_K_ARTICLES_B
WHERE SCN_ID=P_SCN_ID
FOR UPDATE NOWAIT;
Okc_Debug.Log('9700: Entered Delete_Set', 2);
DELETE FROM OKC_K_ARTICLES_B
WHERE SCN_ID=P_SCN_ID;
Okc_Debug.Log('11000: Leaving Delete_set', 2);
Okc_Debug.Log('000: Leaving Delete_set:E_Resource_Busy Exception', 2);
Okc_Debug.Log('11100: Leaving Delete_Set:FND_API.G_EXC_ERROR Exception', 2);
Okc_Debug.Log('11200: Leaving Delete_Set:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
Okc_Debug.Log('11300: Leaving Delete_Set because of EXCEPTION: '||sqlerrm, 2);
END delete_set;
PROCEDURE delete_set(
x_return_status OUT NOCOPY VARCHAR2,
p_doc_type IN VARCHAR2,
p_doc_id IN NUMBER
) IS
CURSOR lock_csr IS
SELECT rowid
FROM OKC_K_ARTICLES_B
WHERE DOCUMENT_TYPE=p_doc_type
AND DOCUMENT_ID = p_doc_id
FOR UPDATE NOWAIT;
Okc_Debug.Log('9700: Entered Delete_Set', 2);
DELETE FROM OKC_K_ARTICLES_B
WHERE DOCUMENT_TYPE=p_doc_type
AND DOCUMENT_ID = p_doc_id;
Okc_Debug.Log('11000: Leaving Delete_set', 2);
Okc_Debug.Log('000: Leaving Delete_set:E_Resource_Busy Exception', 2);
Okc_Debug.Log('11100: Leaving Delete_Set:FND_API.G_EXC_ERROR Exception', 2);
Okc_Debug.Log('11200: Leaving Delete_Set:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
Okc_Debug.Log('11300: Leaving Delete_Set because of EXCEPTION: '||sqlerrm, 2);
END delete_set;
SELECT KART.ID,
KART.SAV_SAE_ID,
KART.ARTICLE_VERSION_ID
FROM OKC_K_ARTICLES_B KART,
OKC_ARTICLES_ALL ART
WHERE KART.document_type = p_doc_type
AND KART.document_id = p_doc_id
AND KART.SAV_SAE_ID = ART.ARTICLE_ID
AND ART.STANDARD_YN = 'N';
INSERT INTO OKC_K_ARTICLES_BH (
major_version,
ID,
SAV_SAE_ID,
SAV_SAV_RELEASE,
SBT_CODE,
CAT_TYPE,
CHR_ID,
CAT_ID,
DNZ_CHR_ID,
FULLTEXT_YN,
DOCUMENT_TYPE,
DOCUMENT_ID,
CLE_ID,
SOURCE_FLAG,
MANDATORY_YN,
SCN_ID,
LABEL,
AMENDMENT_DESCRIPTION,
AMENDMENT_OPERATION_CODE,
ARTICLE_VERSION_ID,
CHANGE_NONSTD_YN,
ORIG_SYSTEM_REFERENCE_CODE,
ORIG_SYSTEM_REFERENCE_ID1,
ORIG_SYSTEM_REFERENCE_ID2,
DISPLAY_SEQUENCE,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
PRINT_TEXT_YN,
SUMMARY_AMEND_OPERATION_CODE,
REF_ARTICLE_ID,
REF_ARTICLE_VERSION_ID,
OBJECT_VERSION_NUMBER,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
LAST_UPDATE_DATE,
ORIG_ARTICLE_ID,
LAST_AMENDED_BY,
LAST_AMENDMENT_DATE)
SELECT
p_major_version,
ID,
SAV_SAE_ID,
SAV_SAV_RELEASE,
SBT_CODE,
CAT_TYPE,
CHR_ID,
CAT_ID,
DNZ_CHR_ID,
FULLTEXT_YN,
DOCUMENT_TYPE,
DOCUMENT_ID,
CLE_ID,
SOURCE_FLAG,
MANDATORY_YN,
SCN_ID,
LABEL,
AMENDMENT_DESCRIPTION,
AMENDMENT_OPERATION_CODE,
ARTICLE_VERSION_ID,
CHANGE_NONSTD_YN,
ORIG_SYSTEM_REFERENCE_CODE,
ORIG_SYSTEM_REFERENCE_ID1,
ORIG_SYSTEM_REFERENCE_ID2,
DISPLAY_SEQUENCE,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
PRINT_TEXT_YN,
SUMMARY_AMEND_OPERATION_CODE,
REF_ARTICLE_ID,
REF_ARTICLE_VERSION_ID,
OBJECT_VERSION_NUMBER,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
LAST_UPDATE_DATE,
ORIG_ARTICLE_ID,
LAST_AMENDED_BY,
LAST_AMENDMENT_DATE
FROM OKC_K_ARTICLES_B
WHERE document_type = p_doc_type
AND document_id = p_doc_id;
UPDATE OKC_K_ARTICLES_B
SET SAV_SAE_ID = l_article_id,
ARTICLE_VERSION_ID = l_article_version_id
WHERE ID = rec.id;
INSERT INTO OKC_K_ARTICLES_B (
ID,
SAV_SAE_ID,
SAV_SAV_RELEASE,
SBT_CODE,
CAT_TYPE,
CHR_ID,
CLE_ID,
CAT_ID,
DNZ_CHR_ID,
FULLTEXT_YN,
DOCUMENT_TYPE,
DOCUMENT_ID,
SOURCE_FLAG,
MANDATORY_YN,
SCN_ID,
LABEL,
AMENDMENT_DESCRIPTION,
AMENDMENT_OPERATION_CODE,
ARTICLE_VERSION_ID,
CHANGE_NONSTD_YN,
ORIG_SYSTEM_REFERENCE_CODE,
ORIG_SYSTEM_REFERENCE_ID1,
ORIG_SYSTEM_REFERENCE_ID2,
DISPLAY_SEQUENCE,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
PRINT_TEXT_YN,
SUMMARY_AMEND_OPERATION_CODE,
REF_ARTICLE_ID,
REF_ARTICLE_VERSION_ID,
OBJECT_VERSION_NUMBER,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
LAST_UPDATE_DATE,
ORIG_ARTICLE_ID,
LAST_AMENDED_BY,
LAST_AMENDMENT_DATE)
SELECT
ID,
SAV_SAE_ID,
SAV_SAV_RELEASE,
SBT_CODE,
CAT_TYPE,
CHR_ID,
CLE_ID,
CAT_ID,
DNZ_CHR_ID,
FULLTEXT_YN,
DOCUMENT_TYPE,
DOCUMENT_ID,
SOURCE_FLAG,
MANDATORY_YN,
SCN_ID,
LABEL,
AMENDMENT_DESCRIPTION,
AMENDMENT_OPERATION_CODE,
ARTICLE_VERSION_ID,
CHANGE_NONSTD_YN,
ORIG_SYSTEM_REFERENCE_CODE,
ORIG_SYSTEM_REFERENCE_ID1,
ORIG_SYSTEM_REFERENCE_ID2,
DISPLAY_SEQUENCE,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
PRINT_TEXT_YN,
SUMMARY_AMEND_OPERATION_CODE,
REF_ARTICLE_ID,
REF_ARTICLE_VERSION_ID,
OBJECT_VERSION_NUMBER,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
LAST_UPDATE_DATE,
ORIG_ARTICLE_ID,
LAST_AMENDED_BY,
LAST_AMENDMENT_DATE
FROM OKC_K_ARTICLES_BH
WHERE document_type = p_doc_type
AND document_id = p_doc_id
AND major_version = p_major_version;
FUNCTION Delete_Version(
p_doc_type IN VARCHAR2,
p_doc_id IN NUMBER,
p_major_version IN NUMBER
) RETURN VARCHAR2 IS
BEGIN
IF (l_debug = 'Y') THEN
Okc_Debug.Log('7200: Entered Delete_Version', 2);
DELETE
FROM OKC_K_ARTICLES_BH
WHERE document_type = p_doc_type
AND document_id = p_doc_id
AND major_version = p_major_version;
Okc_Debug.Log('7300: Leaving Delete_Version', 2);
Okc_Debug.Log('7400: Leaving Delete_Version because of EXCEPTION: '||sqlerrm, 2);
END Delete_Version;