[Home] [Help]
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;
SELECT NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL,
SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)
FROM DUAL;
SELECT OKC_ARTICLE_VERSIONS_S1.NEXTVAL FROM DUAL;
x_insert_by_reference OUT NOCOPY VARCHAR2,
x_lock_text OUT NOCOPY VARCHAR2,
x_global_yn OUT NOCOPY VARCHAR2,
x_article_language OUT NOCOPY VARCHAR2,
x_article_status OUT NOCOPY VARCHAR2,
x_sav_release OUT NOCOPY VARCHAR2,
x_start_date OUT NOCOPY DATE,
x_end_date OUT NOCOPY DATE,
x_std_article_version_id OUT NOCOPY NUMBER,
x_display_name OUT NOCOPY VARCHAR2,
x_translated_yn OUT NOCOPY VARCHAR2,
x_article_description OUT NOCOPY VARCHAR2,
x_date_approved OUT NOCOPY DATE,
x_default_section OUT NOCOPY VARCHAR2,
x_reference_source OUT NOCOPY VARCHAR2,
x_reference_text OUT NOCOPY VARCHAR2,
x_orig_system_reference_code OUT NOCOPY VARCHAR2,
x_orig_system_reference_id1 OUT NOCOPY VARCHAR2,
x_orig_system_reference_id2 OUT NOCOPY VARCHAR2,
x_additional_instructions OUT NOCOPY VARCHAR2,
x_variation_description OUT NOCOPY VARCHAR2,
x_date_published OUT NOCOPY DATE,
x_program_id OUT NOCOPY NUMBER,
x_program_login_id OUT NOCOPY NUMBER,
x_program_application_id OUT NOCOPY NUMBER,
x_request_id OUT NOCOPY NUMBER,
x_attribute_category OUT NOCOPY VARCHAR2,
x_attribute1 OUT NOCOPY VARCHAR2,
x_attribute2 OUT NOCOPY VARCHAR2,
x_attribute3 OUT NOCOPY VARCHAR2,
x_attribute4 OUT NOCOPY VARCHAR2,
x_attribute5 OUT NOCOPY VARCHAR2,
x_attribute6 OUT NOCOPY VARCHAR2,
x_attribute7 OUT NOCOPY VARCHAR2,
x_attribute8 OUT NOCOPY VARCHAR2,
x_attribute9 OUT NOCOPY VARCHAR2,
x_attribute10 OUT NOCOPY VARCHAR2,
x_attribute11 OUT NOCOPY VARCHAR2,
x_attribute12 OUT NOCOPY VARCHAR2,
x_attribute13 OUT NOCOPY VARCHAR2,
x_attribute14 OUT NOCOPY VARCHAR2,
x_attribute15 OUT NOCOPY VARCHAR2,
x_object_version_number OUT NOCOPY NUMBER,
x_edited_in_word OUT NOCOPY VARCHAR2,
x_article_text_in_word OUT NOCOPY BLOB,
x_created_by OUT NOCOPY NUMBER,
x_creation_date OUT NOCOPY DATE,
x_last_updated_by OUT NOCOPY NUMBER,
x_last_update_login OUT NOCOPY NUMBER,
x_last_update_date OUT NOCOPY DATE,
x_variable_code OUT NOCOPY VARCHAR2 --CLM
) RETURN VARCHAR2 IS
CURSOR OKC_ARTICLE_VERSIONS_pk_csr (cp_article_version_id IN NUMBER) IS
SELECT
ARTICLE_ID,
ARTICLE_VERSION_NUMBER,
ARTICLE_TEXT,
PROVISION_YN,
INSERT_BY_REFERENCE,
LOCK_TEXT,
GLOBAL_YN,
ARTICLE_LANGUAGE,
ARTICLE_STATUS,
SAV_RELEASE,
START_DATE,
END_DATE,
STD_ARTICLE_VERSION_ID,
DISPLAY_NAME,
TRANSLATED_YN,
ARTICLE_DESCRIPTION,
DATE_APPROVED,
DEFAULT_SECTION,
REFERENCE_SOURCE,
REFERENCE_TEXT,
ORIG_SYSTEM_REFERENCE_CODE,
ORIG_SYSTEM_REFERENCE_ID1,
ORIG_SYSTEM_REFERENCE_ID2,
ADDITIONAL_INSTRUCTIONS,
VARIATION_DESCRIPTION,
DATE_PUBLISHED,
PROGRAM_ID,
PROGRAM_LOGIN_ID,
PROGRAM_APPLICATION_ID,
REQUEST_ID,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
OBJECT_VERSION_NUMBER,
EDITED_IN_WORD,
ARTICLE_TEXT_IN_WORD,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
LAST_UPDATE_DATE,
VARIABLE_CODE
FROM OKC_ARTICLE_VERSIONS t
WHERE t.ARTICLE_VERSION_ID = cp_article_version_id;
x_insert_by_reference,
x_lock_text,
x_global_yn,
x_article_language,
x_article_status,
x_sav_release,
x_start_date,
x_end_date,
x_std_article_version_id,
x_display_name,
x_translated_yn,
x_article_description,
x_date_approved,
x_default_section,
x_reference_source,
x_reference_text,
x_orig_system_reference_code,
x_orig_system_reference_id1,
x_orig_system_reference_id2,
x_additional_instructions,
x_variation_description,
x_date_published,
x_program_id,
x_program_login_id,
x_program_application_id,
x_request_id,
x_attribute_category,
x_attribute1,
x_attribute2,
x_attribute3,
x_attribute4,
x_attribute5,
x_attribute6,
x_attribute7,
x_attribute8,
x_attribute9,
x_attribute10,
x_attribute11,
x_attribute12,
x_attribute13,
x_attribute14,
x_attribute15,
x_object_version_number,
x_edited_in_word,
x_article_text_in_word,
x_created_by,
x_creation_date,
x_last_updated_by,
x_last_update_login,
x_last_update_date,
x_variable_code;
p_insert_by_reference IN VARCHAR2,
p_lock_text IN VARCHAR2,
p_global_yn IN VARCHAR2,
p_article_language IN VARCHAR2,
p_article_status IN VARCHAR2,
p_sav_release IN VARCHAR2,
p_start_date IN DATE,
p_end_date IN DATE,
p_std_article_version_id IN NUMBER,
p_display_name IN VARCHAR2,
p_translated_yn IN VARCHAR2,
p_article_description IN VARCHAR2,
p_date_approved IN DATE,
p_default_section IN VARCHAR2,
p_reference_source IN VARCHAR2,
p_reference_text IN VARCHAR2,
p_orig_system_reference_code IN VARCHAR2,
p_orig_system_reference_id1 IN VARCHAR2,
p_orig_system_reference_id2 IN VARCHAR2,
p_additional_instructions IN VARCHAR2,
p_variation_description IN VARCHAR2,
p_date_published IN DATE,
p_program_id IN NUMBER,
p_program_login_id IN NUMBER,
p_program_application_id IN NUMBER,
p_request_id 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_object_version_number IN NUMBER,
p_edited_in_word IN VARCHAR2,
p_article_text_in_word IN BLOB,
p_variable_code IN VARCHAR2, --clm
x_article_id OUT NOCOPY NUMBER,
x_article_version_number OUT NOCOPY NUMBER,
x_article_text OUT NOCOPY CLOB,
x_provision_yn OUT NOCOPY VARCHAR2,
x_insert_by_reference OUT NOCOPY VARCHAR2,
x_lock_text OUT NOCOPY VARCHAR2,
x_global_yn OUT NOCOPY VARCHAR2,
x_article_language OUT NOCOPY VARCHAR2,
x_article_status OUT NOCOPY VARCHAR2,
x_sav_release OUT NOCOPY VARCHAR2,
x_start_date OUT NOCOPY DATE,
x_end_date OUT NOCOPY DATE,
x_std_article_version_id OUT NOCOPY NUMBER,
x_display_name OUT NOCOPY VARCHAR2,
x_translated_yn OUT NOCOPY VARCHAR2,
x_article_description OUT NOCOPY VARCHAR2,
x_date_approved OUT NOCOPY DATE,
x_default_section OUT NOCOPY VARCHAR2,
x_reference_source OUT NOCOPY VARCHAR2,
x_reference_text OUT NOCOPY VARCHAR2,
x_orig_system_reference_code OUT NOCOPY VARCHAR2,
x_orig_system_reference_id1 OUT NOCOPY VARCHAR2,
x_orig_system_reference_id2 OUT NOCOPY VARCHAR2,
x_additional_instructions OUT NOCOPY VARCHAR2,
x_variation_description OUT NOCOPY VARCHAR2,
x_date_published OUT NOCOPY DATE,
x_program_id OUT NOCOPY NUMBER,
x_program_login_id OUT NOCOPY NUMBER,
x_program_application_id OUT NOCOPY NUMBER,
x_request_id OUT NOCOPY NUMBER,
x_attribute_category OUT NOCOPY VARCHAR2,
x_attribute1 OUT NOCOPY VARCHAR2,
x_attribute2 OUT NOCOPY VARCHAR2,
x_attribute3 OUT NOCOPY VARCHAR2,
x_attribute4 OUT NOCOPY VARCHAR2,
x_attribute5 OUT NOCOPY VARCHAR2,
x_attribute6 OUT NOCOPY VARCHAR2,
x_attribute7 OUT NOCOPY VARCHAR2,
x_attribute8 OUT NOCOPY VARCHAR2,
x_attribute9 OUT NOCOPY VARCHAR2,
x_attribute10 OUT NOCOPY VARCHAR2,
x_attribute11 OUT NOCOPY VARCHAR2,
x_attribute12 OUT NOCOPY VARCHAR2,
x_attribute13 OUT NOCOPY VARCHAR2,
x_attribute14 OUT NOCOPY VARCHAR2,
x_attribute15 OUT NOCOPY VARCHAR2,
x_edited_in_word OUT NOCOPY VARCHAR2,
x_article_text_in_word OUT NOCOPY BLOB,
x_variable_code OUT NOCOPY VARCHAR2 --clm
) RETURN VARCHAR2 IS
l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;
x_insert_by_reference => x_insert_by_reference,
x_lock_text => x_lock_text,
x_global_yn => x_global_yn,
x_article_language => x_article_language,
x_article_status => x_article_status,
x_sav_release => x_sav_release,
x_start_date => x_start_date,
x_end_date => x_end_date,
x_std_article_version_id => x_std_article_version_id,
x_display_name => x_display_name,
x_translated_yn => x_translated_yn,
x_article_description => x_article_description,
x_date_approved => x_date_approved,
x_default_section => x_default_section,
x_reference_source => x_reference_source,
x_reference_text => x_reference_text,
x_orig_system_reference_code => x_orig_system_reference_code,
x_orig_system_reference_id1 => x_orig_system_reference_id1,
x_orig_system_reference_id2 => x_orig_system_reference_id2,
x_additional_instructions => x_additional_instructions,
x_variation_description => x_variation_description,
x_date_published => x_date_published,
x_program_id => x_program_id,
x_program_login_id => x_program_login_id,
x_program_application_id => x_program_application_id,
x_request_id => x_request_id,
x_attribute_category => x_attribute_category,
x_attribute1 => x_attribute1,
x_attribute2 => x_attribute2,
x_attribute3 => x_attribute3,
x_attribute4 => x_attribute4,
x_attribute5 => x_attribute5,
x_attribute6 => x_attribute6,
x_attribute7 => x_attribute7,
x_attribute8 => x_attribute8,
x_attribute9 => x_attribute9,
x_attribute10 => x_attribute10,
x_attribute11 => x_attribute11,
x_attribute12 => x_attribute12,
x_attribute13 => x_attribute13,
x_attribute14 => x_attribute14,
x_attribute15 => x_attribute15,
x_object_version_number => l_object_version_number,
x_edited_in_word => x_edited_in_word,
x_article_text_in_word => x_article_text_in_word,
x_created_by => l_created_by,
x_creation_date => l_creation_date,
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_variable_code => x_variable_code --clm
);
IF (p_insert_by_reference = G_MISS_CHAR) THEN
x_insert_by_reference := NULL;
ELSIF (p_INSERT_BY_REFERENCE IS NOT NULL) THEN
-- x_insert_by_reference := p_insert_by_reference; -- Modified
x_insert_by_reference := UPPER(p_insert_by_reference);
x_insert_by_reference := p_insert_by_reference;
p_insert_by_reference IN VARCHAR2,
p_lock_text IN VARCHAR2,
p_global_yn IN VARCHAR2,
p_article_language IN VARCHAR2,
p_article_status IN VARCHAR2,
p_sav_release IN VARCHAR2,
p_start_date IN DATE,
p_end_date IN DATE,
p_std_article_version_id IN NUMBER,
p_display_name IN VARCHAR2,
p_translated_yn IN VARCHAR2,
p_article_description IN VARCHAR2,
p_date_approved IN DATE,
p_default_section IN VARCHAR2,
p_reference_source IN VARCHAR2,
p_reference_text IN VARCHAR2,
p_orig_system_reference_code IN VARCHAR2,
p_orig_system_reference_id1 IN VARCHAR2,
p_orig_system_reference_id2 IN VARCHAR2,
p_additional_instructions IN VARCHAR2,
p_variation_description IN VARCHAR2,
p_date_published IN DATE,
p_program_id IN NUMBER,
p_program_login_id IN NUMBER,
p_program_application_id IN NUMBER,
p_request_id 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_edited_in_word IN VARCHAR2,
p_article_text_in_word IN BLOB,
p_variable_code IN VARCHAR2 --clm
) RETURN VARCHAR2 IS
l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
SELECT '!'
FROM OKC_ARTICLES_ALL
WHERE ARTICLE_LANGUAGE = p_article_language
AND ARTICLE_ID = p_article_id;
SELECT '!'
FROM OKC_ARTICLES_ALL AA,OKC_ARTICLE_VERSIONS AV
WHERE AA.ARTICLE_ID = AV.ARTICLE_ID
AND AV.ARTICLE_VERSION_ID = p_std_article_version_id
AND AA.STANDARD_YN = 'Y';
SELECT av.date_published
FROM OKC_ARTICLE_VERSIONS AV
WHERE AV.ARTICLE_VERSION_ID = p_article_version_id;
Okc_Debug.Log('1400: - attribute INSERT_BY_REFERENCE ', 2);
IF ( p_insert_by_reference IS NULL) THEN
IF (l_debug = 'Y') THEN
Okc_Debug.Log('1500: - attribute INSERT_BY_REFERENCE is invalid', 2);
Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'INSERT_BY_REFERENCE');
IF p_insert_by_reference NOT IN ('Y','N') THEN
IF (l_debug = 'Y') THEN
Okc_Debug.Log('1800: - attribute INSERT_BY_REFERENCE is invalid', 2);
Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'INSERT_BY_REFERENCE');
select 'E' result
from
okc_article_versions v,
okc_article_relatns_all r
where
r.source_article_id = c_source_article_id
and
r.org_id = c_org_id
and
v.article_id = r.target_article_id
and
v.article_version_number = 1
and
v.provision_yn <> c_provision_yn;
p_insert_by_reference IN VARCHAR2,
p_lock_text IN VARCHAR2,
p_global_yn IN VARCHAR2,
p_article_language IN VARCHAR2,
p_article_status IN VARCHAR2,
p_sav_release IN VARCHAR2,
p_start_date IN DATE,
p_end_date IN DATE,
p_std_article_version_id IN NUMBER,
p_display_name IN VARCHAR2,
p_translated_yn IN VARCHAR2,
p_article_description IN VARCHAR2,
p_date_approved IN DATE,
p_default_section IN VARCHAR2,
p_reference_source IN VARCHAR2,
p_reference_text IN VARCHAR2,
p_orig_system_reference_code IN VARCHAR2,
p_orig_system_reference_id1 IN VARCHAR2,
p_orig_system_reference_id2 IN VARCHAR2,
p_additional_instructions IN VARCHAR2,
p_variation_description IN VARCHAR2,
p_program_id IN NUMBER := NULL,
p_program_login_id IN NUMBER := NULL,
p_program_application_id IN NUMBER := NULL,
p_request_id IN NUMBER := NULL,
p_current_org_id IN NUMBER := NULL,
p_date_published IN DATE,
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_edited_in_word IN VARCHAR2 DEFAULT 'N',
p_article_text_in_word IN BLOB DEFAULT NULL,
p_variable_code IN VARCHAR2 DEFAULT NULL,
x_earlier_adoption_type OUT NOCOPY VARCHAR2,
x_earlier_version_number OUT NOCOPY NUMBER,
x_earlier_version_id OUT NOCOPY NUMBER,
x_article_language OUT NOCOPY VARCHAR2
) RETURN VARCHAR2 IS
l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
select
av.global_yn,
av.article_status,
av.adoption_type,
av.start_date,
av.end_date,
av.provision_yn,
av.article_version_number,
av.article_version_id,
av.date_published
from
okc_article_versions av
where
av.article_id = p_article_id
and
av.start_date = (select
max(av1.start_date)
from
okc_article_versions av1
where
av1.article_id = av.article_id
and
av1.article_version_id <> p_article_version_id
);
SELECT S.GLOBAL_YN,
S.ARTICLE_STATUS,
S.ADOPTION_TYPE,
S.START_DATE,
S.END_DATE,
S.MAX_START_DATE,
S.ARTICLE_VERSION_NUMBER,
S.ARTICLE_VERSION_ID
FROM (
SELECT
A.GLOBAL_YN,
A.ARTICLE_STATUS,
A.ADOPTION_TYPE,
A.START_DATE, A.END_DATE,
MAX(A.START_DATE) OVER (PARTITION BY A.ARTICLE_ID) AS MAX_START_DATE,
A.ARTICLE_VERSION_NUMBER,
A.ARTICLE_VERSION_ID
FROM OKC_ARTICLE_VERSIONS A
WHERE A.ARTICLE_ID = p_article_id
AND ARTICLE_VERSION_ID <> p_article_version_id
) S
WHERE S.START_DATE = S.MAX_START_DATE;
SELECT standard_yn, article_language
FROM OKC_ARTICLES_ALL
WHERE ARTICLE_ID = p_article_id;
SELECT start_date
FROM OKC_ARTICLE_VERSIONS AVN, OKC_ARTICLE_ADOPTIONS ADP
WHERE ARTICLE_VERSION_ID = GLOBAL_ARTICLE_VERSION_ID
AND LOCAL_ARTICLE_VERSION_ID = p_article_version_id
AND LOCAL_ORG_ID = p_local_org_id
AND ADP.ADOPTION_TYPE = 'LOCALIZED' ;
p_insert_by_reference => p_insert_by_reference,
p_lock_text => p_lock_text,
p_global_yn => p_global_yn,
p_article_language => p_article_language,
p_article_status => p_article_status,
p_sav_release => p_sav_release,
p_start_date => p_start_date,
p_end_date => p_end_date,
p_std_article_version_id => p_std_article_version_id,
p_display_name => p_display_name,
p_translated_yn => p_translated_yn,
p_article_description => p_article_description,
p_date_approved => p_date_approved,
p_default_section => p_default_section,
p_reference_source => p_reference_source,
p_reference_text => p_reference_text,
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_additional_instructions => p_additional_instructions,
p_variation_description => p_variation_description,
p_date_published => p_date_published,
p_program_id => p_program_id,
p_program_login_id => p_program_application_id,
p_program_application_id => p_program_application_id,
p_request_id => p_request_id,
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_edited_in_word => p_edited_in_word,
p_article_text_in_word => p_article_text_in_word,
p_variable_code => p_variable_code --clm
);
IF ( p_insert_by_reference = 'Y' ) THEN
IF ( p_reference_text IS NULL ) THEN
IF (l_debug = 'Y') THEN
Okc_Debug.Log('1300: attribute REFERENCE_TEXT cannot be null if INSERT_BY_REFERENCE is YES', 2);
p_insert_by_reference IN VARCHAR2,
p_lock_text IN VARCHAR2,
p_global_yn IN VARCHAR2,
p_article_language IN VARCHAR2,
p_article_status IN VARCHAR2,
p_sav_release IN VARCHAR2,
p_start_date IN DATE,
p_end_date IN DATE,
p_std_article_version_id IN NUMBER,
p_display_name IN VARCHAR2,
p_translated_yn IN VARCHAR2,
p_article_description IN VARCHAR2,
p_date_approved IN DATE,
p_default_section IN VARCHAR2,
p_reference_source IN VARCHAR2,
p_reference_text IN VARCHAR2,
p_orig_system_reference_code IN VARCHAR2,
p_orig_system_reference_id1 IN VARCHAR2,
p_orig_system_reference_id2 IN VARCHAR2,
p_additional_instructions IN VARCHAR2,
p_variation_description IN VARCHAR2,
p_program_id IN NUMBER := NULL,
p_program_login_id IN NUMBER := NULL,
p_program_application_id IN NUMBER := NULL,
p_request_id IN NUMBER := NULL,
p_current_org_id IN NUMBER := NULL,
p_date_published IN DATE ,
p_attribute_category IN VARCHAR2 := NULL,
p_attribute1 IN VARCHAR2 := NULL,
p_attribute2 IN VARCHAR2 := NULL,
p_attribute3 IN VARCHAR2 := NULL,
p_attribute4 IN VARCHAR2 := NULL,
p_attribute5 IN VARCHAR2 := NULL,
p_attribute6 IN VARCHAR2 := NULL,
p_attribute7 IN VARCHAR2 := NULL,
p_attribute8 IN VARCHAR2 := NULL,
p_attribute9 IN VARCHAR2 := NULL,
p_attribute10 IN VARCHAR2 := NULL,
p_attribute11 IN VARCHAR2 := NULL,
p_attribute12 IN VARCHAR2 := NULL,
p_attribute13 IN VARCHAR2 := NULL,
p_attribute14 IN VARCHAR2 := NULL,
p_attribute15 IN VARCHAR2 := NULL,
p_object_version_number IN NUMBER,
p_edited_in_word IN VARCHAR2,
p_article_text_in_word IN BLOB,
p_variable_code IN VARCHAR2 DEFAULT NULL --clm
) IS
l_article_id OKC_ARTICLE_VERSIONS.ARTICLE_ID%TYPE;
l_insert_by_reference OKC_ARTICLE_VERSIONS.INSERT_BY_REFERENCE%TYPE;
l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;
l_insert_by_reference := p_insert_by_reference;
p_insert_by_reference => p_insert_by_reference,
p_lock_text => p_lock_text,
p_global_yn => p_global_yn,
p_article_language => p_article_language,
p_article_status => p_article_status,
p_sav_release => p_sav_release,
p_start_date => p_start_date,
p_end_date => p_end_date,
p_std_article_version_id => p_std_article_version_id,
p_display_name => p_display_name,
p_translated_yn => p_translated_yn,
p_article_description => p_article_description,
p_date_approved => p_date_approved,
p_default_section => p_default_section,
p_reference_source => p_reference_source,
p_reference_text => p_reference_text,
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_additional_instructions => p_additional_instructions,
p_variation_description => p_variation_description,
p_date_published => p_date_published,
p_program_id => p_program_id,
p_program_login_id => p_program_login_id,
p_program_application_id => p_program_application_id,
p_request_id => p_request_id,
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_object_version_number => p_object_version_number,
p_edited_in_word => p_edited_in_word,
p_article_text_in_word => p_article_text_in_word,
p_variable_code => p_variable_code, --clm
x_article_id => l_article_id,
x_article_version_number => l_article_version_number,
x_article_text => l_article_text,
x_provision_yn => l_provision_yn,
x_insert_by_reference => l_insert_by_reference,
x_lock_text => l_lock_text,
x_global_yn => l_global_yn,
x_article_language => l_article_language,
x_article_status => l_article_status,
x_sav_release => l_sav_release,
x_start_date => l_start_date,
x_end_date => l_end_date,
x_std_article_version_id => l_std_article_version_id,
x_display_name => l_display_name,
x_translated_yn => l_translated_yn,
x_article_description => l_article_description,
x_date_approved => l_date_approved,
x_default_section => l_default_section,
x_reference_source => l_reference_source,
x_reference_text => l_reference_text,
x_orig_system_reference_code => l_orig_system_reference_code,
x_orig_system_reference_id1 => l_orig_system_reference_id1,
x_orig_system_reference_id2 => l_orig_system_reference_id2,
x_additional_instructions => l_additional_instructions,
x_variation_description => l_variation_description,
x_date_published => l_date_published,
x_program_id => l_program_id,
x_program_login_id => l_program_login_id,
x_program_application_id => l_program_application_id,
x_request_id => l_request_id,
x_attribute_category => l_attribute_category,
x_attribute1 => l_attribute1,
x_attribute2 => l_attribute2,
x_attribute3 => l_attribute3,
x_attribute4 => l_attribute4,
x_attribute5 => l_attribute5,
x_attribute6 => l_attribute6,
x_attribute7 => l_attribute7,
x_attribute8 => l_attribute8,
x_attribute9 => l_attribute9,
x_attribute10 => l_attribute10,
x_attribute11 => l_attribute11,
x_attribute12 => l_attribute12,
x_attribute13 => l_attribute13,
x_attribute14 => l_attribute14,
x_attribute15 => l_attribute15,
x_edited_in_word => l_edited_in_word,
x_article_text_in_word => l_article_text_in_word,
x_variable_code => l_variable_code --clm
);
p_insert_by_reference => l_insert_by_reference,
p_lock_text => l_lock_text,
p_global_yn => l_global_yn,
p_article_language => l_article_language,
p_article_status => l_article_status,
p_sav_release => l_sav_release,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_std_article_version_id => l_std_article_version_id,
p_display_name => l_display_name,
p_translated_yn => l_translated_yn,
p_article_description => l_article_description,
p_date_approved => l_date_approved,
p_default_section => l_default_section,
p_reference_source => l_reference_source,
p_reference_text => l_reference_text,
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_additional_instructions => l_additional_instructions,
p_variation_description => l_variation_description,
p_program_id => l_program_id,
p_program_login_id => l_program_login_id,
p_program_application_id => l_program_application_id,
p_request_id => l_request_id,
p_current_org_id => G_CURRENT_ORG_ID,
p_date_published => l_date_published,
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_edited_in_word => l_edited_in_word,
p_article_text_in_word => l_article_text_in_word,
p_variable_code => l_variable_code, --clm
x_earlier_adoption_type => x_earlier_adoption_type,
x_article_language => l_article_language_out,
x_earlier_version_id => x_earlier_version_id,
x_earlier_version_number => x_earlier_version_number
);
FUNCTION Insert_Row(
p_article_version_id IN NUMBER,
p_article_id IN NUMBER,
p_article_version_number IN NUMBER,
p_article_text IN CLOB,
p_provision_yn IN VARCHAR2,
p_insert_by_reference IN VARCHAR2,
p_lock_text IN VARCHAR2,
p_global_yn IN VARCHAR2,
p_article_language IN VARCHAR2,
p_article_status IN VARCHAR2,
p_sav_release IN VARCHAR2,
p_start_date IN DATE,
p_end_date IN DATE,
p_std_article_version_id IN NUMBER,
p_display_name IN VARCHAR2,
p_translated_yn IN VARCHAR2,
p_article_description IN VARCHAR2,
p_date_approved IN DATE,
p_default_section IN VARCHAR2,
p_adoption_type IN VARCHAR2,
p_reference_source IN VARCHAR2,
p_reference_text IN VARCHAR2,
p_orig_system_reference_code IN VARCHAR2,
p_orig_system_reference_id1 IN VARCHAR2,
p_orig_system_reference_id2 IN VARCHAR2,
p_additional_instructions IN VARCHAR2,
p_variation_description IN VARCHAR2,
p_date_published IN DATE,
p_program_id IN NUMBER,
p_program_login_id IN NUMBER,
p_program_application_id IN NUMBER,
p_request_id 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_object_version_number IN NUMBER,
p_edited_in_word IN VARCHAR2,
p_article_text_in_word IN BLOB,
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_variable_code IN VARCHAR2 DEFAULT NULL --clm
) RETURN VARCHAR2 IS
l_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE;
Okc_Debug.Log('3600: Entered Insert_Row function', 2);
INSERT INTO OKC_ARTICLE_VERSIONS(
ARTICLE_VERSION_ID,
ARTICLE_ID,
ARTICLE_VERSION_NUMBER,
ARTICLE_TEXT,
PROVISION_YN,
INSERT_BY_REFERENCE,
LOCK_TEXT,
GLOBAL_YN,
ARTICLE_LANGUAGE,
ARTICLE_STATUS,
SAV_RELEASE,
START_DATE,
END_DATE,
STD_ARTICLE_VERSION_ID,
DISPLAY_NAME,
TRANSLATED_YN,
ARTICLE_DESCRIPTION,
DATE_APPROVED,
DEFAULT_SECTION,
ADOPTION_TYPE,
REFERENCE_SOURCE,
REFERENCE_TEXT,
ORIG_SYSTEM_REFERENCE_CODE,
ORIG_SYSTEM_REFERENCE_ID1,
ORIG_SYSTEM_REFERENCE_ID2,
ADDITIONAL_INSTRUCTIONS,
VARIATION_DESCRIPTION,
DATE_PUBLISHED,
PROGRAM_ID,
PROGRAM_LOGIN_ID,
PROGRAM_APPLICATION_ID,
REQUEST_ID,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
OBJECT_VERSION_NUMBER,
EDITED_IN_WORD,
ARTICLE_TEXT_IN_WORD,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
LAST_UPDATE_DATE,
VARIABLE_CODE)
VALUES (
p_article_version_id,
p_article_id,
p_article_version_number,
p_article_text,
p_provision_yn,
p_insert_by_reference,
p_lock_text,
p_global_yn,
p_article_language,
p_article_status,
p_sav_release,
p_start_date,
p_end_date,
p_std_article_version_id,
p_display_name,
p_translated_yn,
p_article_description,
p_date_approved,
p_default_section,
p_adoption_type,
p_reference_source,
p_reference_text,
p_orig_system_reference_code,
p_orig_system_reference_id1,
p_orig_system_reference_id2,
p_additional_instructions,
p_variation_description,
p_date_published,
l_program_id,
l_program_login_id,
l_program_appl_id,
l_request_id,
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_object_version_number,
p_edited_in_word,
p_article_text_in_word,
p_created_by,
p_creation_date,
p_last_updated_by,
p_last_update_login,
p_last_update_date,
p_variable_code);
Okc_Debug.Log('3700: Leaving Insert_Row', 2);
Okc_Debug.Log('3800: Leaving Insert_Row:OTHERS Exception', 2);
END Insert_Row;
PROCEDURE Insert_Row(
p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
x_return_status OUT NOCOPY VARCHAR2,
p_article_version_id IN NUMBER,
p_article_id IN NUMBER,
p_article_version_number IN NUMBER,
p_article_text IN CLOB,
p_provision_yn IN VARCHAR2,
p_insert_by_reference IN VARCHAR2,
p_lock_text IN VARCHAR2,
p_global_yn IN VARCHAR2,
p_article_language IN VARCHAR2,
p_article_status IN VARCHAR2,
p_sav_release IN VARCHAR2,
p_start_date IN DATE,
p_end_date IN DATE,
p_std_article_version_id IN NUMBER,
p_display_name IN VARCHAR2,
p_translated_yn IN VARCHAR2,
p_article_description IN VARCHAR2,
p_date_approved IN DATE,
p_default_section IN VARCHAR2,
p_reference_source IN VARCHAR2,
p_reference_text IN VARCHAR2,
p_orig_system_reference_code IN VARCHAR2,
p_orig_system_reference_id1 IN VARCHAR2,
p_orig_system_reference_id2 IN VARCHAR2,
p_additional_instructions IN VARCHAR2,
p_variation_description IN VARCHAR2,
p_program_id IN NUMBER := NULL,
p_program_login_id IN NUMBER := NULL,
p_program_application_id IN NUMBER := NULL,
p_request_id IN NUMBER := NULL,
p_current_org_id IN NUMBER := NULL,
p_date_published IN DATE ,
p_attribute_category IN VARCHAR2 := NULL,
p_attribute1 IN VARCHAR2 := NULL,
p_attribute2 IN VARCHAR2 := NULL,
p_attribute3 IN VARCHAR2 := NULL,
p_attribute4 IN VARCHAR2 := NULL,
p_attribute5 IN VARCHAR2 := NULL,
p_attribute6 IN VARCHAR2 := NULL,
p_attribute7 IN VARCHAR2 := NULL,
p_attribute8 IN VARCHAR2 := NULL,
p_attribute9 IN VARCHAR2 := NULL,
p_attribute10 IN VARCHAR2 := NULL,
p_attribute11 IN VARCHAR2 := NULL,
p_attribute12 IN VARCHAR2 := NULL,
p_attribute13 IN VARCHAR2 := NULL,
p_attribute14 IN VARCHAR2 := NULL,
p_attribute15 IN VARCHAR2 := NULL,
p_edited_in_word IN VARCHAR2,
p_article_text_in_word IN BLOB,
p_variable_code IN VARCHAR2 DEFAULT NULL, --clm
x_earlier_adoption_type OUT NOCOPY VARCHAR2,
x_earlier_version_id OUT NOCOPY NUMBER,
x_article_version_id OUT NOCOPY NUMBER
) IS
l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;
l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;
Okc_Debug.Log('4200: 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;
p_insert_by_reference => p_insert_by_reference,
p_lock_text => p_lock_text,
p_global_yn => p_global_yn,
p_article_language => p_article_language,
p_article_status => p_article_status,
p_sav_release => p_sav_release,
p_start_date => p_start_date,
p_end_date => p_end_date,
p_std_article_version_id => p_std_article_version_id,
p_display_name => p_display_name,
p_translated_yn => p_translated_yn,
p_article_description => p_article_description,
p_date_approved => p_date_approved,
p_default_section => p_default_section,
p_reference_source => p_reference_source,
p_reference_text => p_reference_text,
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_additional_instructions => p_additional_instructions,
p_variation_description => p_variation_description,
p_program_id => p_program_id,
p_program_login_id => p_program_login_id,
p_program_application_id => p_program_application_id,
p_request_id => p_request_id,
p_current_org_id => G_CURRENT_ORG_ID,
p_date_published => p_date_published,
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_edited_in_word => p_edited_in_word,
p_article_text_in_word => p_article_text_in_word,
p_variable_code => p_variable_code, --clm
x_article_language => l_article_language,
x_earlier_adoption_type => x_earlier_adoption_type,
x_earlier_version_id => x_earlier_version_id,
x_earlier_version_number => l_article_version_number
);
Okc_Debug.Log('4300: Call the internal Insert_Row for Base Table', 2);
x_return_status := Insert_Row(
p_article_version_id => x_article_version_id,
p_article_id => p_article_id,
p_article_version_number => l_article_version_number,
p_article_text => p_article_text,
p_provision_yn => p_provision_yn,
p_insert_by_reference => p_insert_by_reference,
p_lock_text => p_lock_text,
p_global_yn => p_global_yn,
p_article_language => l_article_language,
p_article_status => p_article_status,
p_sav_release => p_sav_release,
p_start_date => p_start_date,
p_end_date => p_end_date,
p_std_article_version_id => p_std_article_version_id,
p_display_name => p_display_name,
p_translated_yn => p_translated_yn,
p_article_description => p_article_description,
p_date_approved => p_date_approved,
p_default_section => p_default_section,
p_adoption_type => l_adoption_type,
p_reference_source => p_reference_source,
p_reference_text => p_reference_text,
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_additional_instructions => p_additional_instructions,
p_variation_description => p_variation_description,
p_date_published => p_date_published,
p_program_id => p_program_id,
p_program_login_id => p_program_login_id,
p_program_application_id => p_program_application_id,
p_request_id => p_request_id,
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_object_version_number => l_object_version_number,
p_edited_in_word => p_edited_in_word,
p_article_text_in_word => p_article_text_in_word,
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_variable_code => p_variable_code --clm
);
Okc_Debug.Log('4500: Leaving Insert_Row', 2);
Okc_Debug.Log('4600: Leaving Insert_Row:FND_API.G_EXC_ERROR Exception', 2);
Okc_Debug.Log('4700: Leaving Insert_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
Okc_Debug.Log('4800: Leaving Insert_Row because of EXCEPTION: '||sqlerrm, 2);
END Insert_Row;
SELECT object_version_number
FROM OKC_ARTICLE_VERSIONS
WHERE ARTICLE_VERSION_ID = cp_article_version_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_ARTICLE_VERSIONS
WHERE ARTICLE_VERSION_ID = cp_article_version_id;
Okc_Api.Set_Message(G_FND_APP,G_RECORD_DELETED);
Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
FUNCTION Update_Row(
p_article_version_id IN NUMBER,
p_article_id IN NUMBER,
p_article_version_number IN NUMBER,
p_article_text IN CLOB,
p_provision_yn IN VARCHAR2,
p_insert_by_reference IN VARCHAR2,
p_lock_text IN VARCHAR2,
p_global_yn IN VARCHAR2,
p_article_language IN VARCHAR2,
p_article_status IN VARCHAR2,
p_sav_release IN VARCHAR2,
p_start_date IN DATE,
p_end_date IN DATE,
p_std_article_version_id IN NUMBER,
p_display_name IN VARCHAR2,
p_translated_yn IN VARCHAR2,
p_article_description IN VARCHAR2,
p_date_approved IN DATE,
p_default_section IN VARCHAR2,
p_reference_source IN VARCHAR2,
p_reference_text IN VARCHAR2,
p_orig_system_reference_code IN VARCHAR2,
p_orig_system_reference_id1 IN VARCHAR2,
p_orig_system_reference_id2 IN VARCHAR2,
p_additional_instructions IN VARCHAR2,
p_variation_description IN VARCHAR2,
p_date_published IN DATE,
p_program_id IN NUMBER,
p_program_login_id IN NUMBER,
p_program_application_id IN NUMBER,
p_request_id 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_object_version_number IN NUMBER,
p_edited_in_word IN VARCHAR2,
p_article_text_in_word IN BLOB,
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_variable_code IN VARCHAR2 --clm
) RETURN VARCHAR2 IS
l_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE;
Okc_Debug.Log('6400: Entered Update_Row', 2);
UPDATE OKC_ARTICLE_VERSIONS
SET ARTICLE_ID = p_article_id,
-- ARTICLE_VERSION_NUMBER = p_article_version_number,
ARTICLE_TEXT = p_article_text,
PROVISION_YN = p_provision_yn,
INSERT_BY_REFERENCE = p_insert_by_reference,
LOCK_TEXT = p_lock_text,
GLOBAL_YN = p_global_yn,
-- ARTICLE_LANGUAGE = p_article_language,
ARTICLE_STATUS = p_article_status,
SAV_RELEASE = p_sav_release,
START_DATE = p_start_date,
END_DATE = p_end_date,
STD_ARTICLE_VERSION_ID = p_std_article_version_id,
DISPLAY_NAME = p_display_name,
TRANSLATED_YN = p_translated_yn,
ARTICLE_DESCRIPTION = p_article_description,
DATE_APPROVED = p_date_approved,
DEFAULT_SECTION = p_default_section,
REFERENCE_SOURCE = p_reference_source,
REFERENCE_TEXT = p_reference_text,
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,
ADDITIONAL_INSTRUCTIONS = p_additional_instructions,
VARIATION_DESCRIPTION = p_variation_description,
-- DATE_PUBLISHED = p_date_published,
PROGRAM_ID = l_program_id,
REQUEST_ID = l_request_id,
PROGRAM_LOGIN_ID = l_program_login_id,
PROGRAM_APPLICATION_ID = l_program_appl_id,
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,
-- muteshev
OBJECT_VERSION_NUMBER = object_version_number+1,
EDITED_IN_WORD = p_edited_in_word,
ARTICLE_TEXT_IN_WORD = p_article_text_in_word,
LAST_UPDATED_BY = p_last_updated_by,
LAST_UPDATE_LOGIN = p_last_update_login,
LAST_UPDATE_DATE = p_last_update_date,
--clm
VARIABLE_CODE = p_variable_code
WHERE ARTICLE_VERSION_ID = p_article_version_id;
Okc_Debug.Log('6500: Leaving Update_Row', 2);
Okc_Debug.Log('6600: 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_article_version_id IN NUMBER,
p_article_id IN NUMBER,
p_article_version_number IN NUMBER,
p_article_text IN CLOB,
p_provision_yn IN VARCHAR2,
p_insert_by_reference IN VARCHAR2,
p_lock_text IN VARCHAR2,
p_global_yn IN VARCHAR2,
p_article_language IN VARCHAR2,
p_article_status IN VARCHAR2,
p_sav_release IN VARCHAR2,
p_start_date IN DATE,
p_end_date IN DATE,
p_std_article_version_id IN NUMBER,
p_display_name IN VARCHAR2,
p_translated_yn IN VARCHAR2,
p_article_description IN VARCHAR2,
p_date_approved IN DATE,
p_default_section IN VARCHAR2,
p_reference_source IN VARCHAR2,
p_reference_text IN VARCHAR2,
p_orig_system_reference_code IN VARCHAR2,
p_orig_system_reference_id1 IN VARCHAR2,
p_orig_system_reference_id2 IN VARCHAR2,
p_additional_instructions IN VARCHAR2,
p_variation_description IN VARCHAR2,
p_program_id IN NUMBER := NULL,
p_program_login_id IN NUMBER := NULL,
p_program_application_id IN NUMBER := NULL,
p_request_id IN NUMBER := NULL,
p_current_org_id IN NUMBER := NULL,
p_date_published IN DATE ,
p_attribute_category IN VARCHAR2 := NULL,
p_attribute1 IN VARCHAR2 := NULL,
p_attribute2 IN VARCHAR2 := NULL,
p_attribute3 IN VARCHAR2 := NULL,
p_attribute4 IN VARCHAR2 := NULL,
p_attribute5 IN VARCHAR2 := NULL,
p_attribute6 IN VARCHAR2 := NULL,
p_attribute7 IN VARCHAR2 := NULL,
p_attribute8 IN VARCHAR2 := NULL,
p_attribute9 IN VARCHAR2 := NULL,
p_attribute10 IN VARCHAR2 := NULL,
p_attribute11 IN VARCHAR2 := NULL,
p_attribute12 IN VARCHAR2 := NULL,
p_attribute13 IN VARCHAR2 := NULL,
p_attribute14 IN VARCHAR2 := NULL,
p_attribute15 IN VARCHAR2 := NULL,
p_object_version_number IN NUMBER,
p_edited_in_word IN VARCHAR2,
p_article_text_in_word IN BLOB,
p_variable_code IN VARCHAR2 DEFAULT NULL, ---clm
x_article_status IN VARCHAR2,
x_article_id OUT NOCOPY NUMBER,
x_earlier_version_id OUT NOCOPY NUMBER
) IS
l_article_id OKC_ARTICLE_VERSIONS.ARTICLE_ID%TYPE;
l_insert_by_reference OKC_ARTICLE_VERSIONS.INSERT_BY_REFERENCE%TYPE;
l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;
Okc_Debug.Log('7000: Entered Update_Row', 2);
p_insert_by_reference => p_insert_by_reference,
p_lock_text => p_lock_text,
p_global_yn => p_global_yn,
p_article_language => p_article_language,
p_article_status => p_article_status,
p_sav_release => p_sav_release,
p_start_date => p_start_date,
p_end_date => p_end_date,
p_std_article_version_id => p_std_article_version_id,
p_display_name => p_display_name,
p_translated_yn => p_translated_yn,
p_article_description => p_article_description,
p_date_approved => p_date_approved,
p_default_section => p_default_section,
p_reference_source => p_reference_source,
p_reference_text => p_reference_text,
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_additional_instructions => p_additional_instructions,
p_variation_description => p_variation_description,
p_date_published => p_date_published,
p_program_id => p_program_id,
p_program_login_id => p_program_login_id,
p_program_application_id => p_program_application_id,
p_request_id => p_request_id,
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_object_version_number => p_object_version_number,
p_edited_in_word => p_edited_in_word,
p_article_text_in_word => p_article_text_in_word,
p_variable_code => p_variable_code, --clm
x_article_id => l_article_id,
x_article_version_number => l_article_version_number,
x_article_text => l_article_text,
x_provision_yn => l_provision_yn,
x_insert_by_reference => l_insert_by_reference,
x_lock_text => l_lock_text,
x_global_yn => l_global_yn,
x_article_language => l_article_language,
x_article_status => l_article_status,
x_sav_release => l_sav_release,
x_start_date => l_start_date,
x_end_date => l_end_date,
x_std_article_version_id => l_std_article_version_id,
x_display_name => l_display_name,
x_translated_yn => l_translated_yn,
x_article_description => l_article_description,
x_date_approved => l_date_approved,
x_default_section => l_default_section,
x_reference_source => l_reference_source,
x_reference_text => l_reference_text,
x_orig_system_reference_code => l_orig_system_reference_code,
x_orig_system_reference_id1 => l_orig_system_reference_id1,
x_orig_system_reference_id2 => l_orig_system_reference_id2,
x_additional_instructions => l_additional_instructions,
x_variation_description => l_variation_description,
x_date_published => l_date_published,
x_program_id => l_program_id,
x_program_login_id => l_program_login_id,
x_program_application_id => l_program_application_id,
x_request_id => l_request_id,
x_attribute_category => l_attribute_category,
x_attribute1 => l_attribute1,
x_attribute2 => l_attribute2,
x_attribute3 => l_attribute3,
x_attribute4 => l_attribute4,
x_attribute5 => l_attribute5,
x_attribute6 => l_attribute6,
x_attribute7 => l_attribute7,
x_attribute8 => l_attribute8,
x_attribute9 => l_attribute9,
x_attribute10 => l_attribute10,
x_attribute11 => l_attribute11,
x_attribute12 => l_attribute12,
x_attribute13 => l_attribute13,
x_attribute14 => l_attribute14,
x_attribute15 => l_attribute15,
x_edited_in_word => l_edited_in_word,
x_article_text_in_word => l_article_text_in_word,
x_variable_code => l_variable_code --clm
);
p_insert_by_reference => l_insert_by_reference,
p_lock_text => l_lock_text,
p_global_yn => l_global_yn,
p_article_language => l_article_language,
p_article_status => l_article_status,
p_sav_release => l_sav_release,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_std_article_version_id => l_std_article_version_id,
p_display_name => l_display_name,
p_translated_yn => l_translated_yn,
p_article_description => l_article_description,
p_date_approved => l_date_approved,
p_default_section => l_default_section,
p_reference_source => l_reference_source,
p_reference_text => l_reference_text,
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_additional_instructions => l_additional_instructions,
p_variation_description => l_variation_description,
p_date_published => l_date_published,
p_program_id => l_program_id,
p_program_login_id => l_program_login_id,
p_program_application_id => l_program_application_id,
p_request_id => l_request_id,
p_current_org_id => G_CURRENT_ORG_ID,
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_edited_in_word => l_edited_in_word,
p_article_text_in_word => l_article_text_in_word,
p_variable_code => l_variable_code, --clm
x_article_language => l_article_language_out,
x_earlier_adoption_type => l_earlier_adoption_type,
x_earlier_version_id => x_earlier_version_id,
x_earlier_version_number => l_earlier_version_number
);
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_article_version_id => p_article_version_id,
p_article_id => l_article_id,
p_article_version_number => l_article_version_number,
p_article_text => l_article_text,
p_provision_yn => l_provision_yn,
p_insert_by_reference => l_insert_by_reference,
p_lock_text => l_lock_text,
p_global_yn => l_global_yn,
p_article_language => l_article_language,
p_article_status => l_article_status,
p_sav_release => l_sav_release,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_std_article_version_id => l_std_article_version_id,
p_display_name => l_display_name,
p_translated_yn => l_translated_yn,
p_article_description => l_article_description,
p_date_approved => l_date_approved,
p_default_section => l_default_section,
p_reference_source => l_reference_source,
p_reference_text => l_reference_text,
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_additional_instructions => l_additional_instructions,
p_variation_description => l_variation_description,
p_date_published => l_date_published,
p_program_id => l_program_id,
p_program_login_id => l_program_login_id,
p_program_application_id => l_program_application_id,
p_request_id => l_request_id,
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_object_version_number => l_object_version_number,
p_edited_in_word => l_edited_in_word,
p_article_text_in_word => l_article_text_in_word,
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_variable_code => l_variable_code --clm
);
Okc_Debug.Log('7800: Leaving Update_Row', 2);
Okc_Debug.Log('7900: Leaving Update_Row:FND_API.G_EXC_ERROR Exception', 2);
Okc_Debug.Log('8000: Leaving Update_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
Okc_Debug.Log('8100: Leaving Update_Row because of EXCEPTION: '||sqlerrm, 2);
END Update_Row;
FUNCTION Delete_Row(
p_article_version_id IN NUMBER
) RETURN VARCHAR2 IS
BEGIN
IF (l_debug = 'Y') THEN
Okc_Debug.Log('8200: Entered Delete_Row', 2);
DELETE FROM OKC_ARTICLE_VERSIONS WHERE ARTICLE_VERSION_ID = P_ARTICLE_VERSION_ID;
Okc_Debug.Log('8300: Leaving Delete_Row', 2);
Okc_Debug.Log('8400: Leaving Delete_Row because of EXCEPTION: '||sqlerrm, 2);
END Delete_Row;
PROCEDURE Delete_Row(
x_return_status OUT NOCOPY VARCHAR2,
p_article_version_id IN NUMBER,
p_object_version_number IN NUMBER
) IS
l_api_name CONSTANT VARCHAR2(30) := 'B_Delete_Row';
Okc_Debug.Log('8800: Entered Delete_Row', 2);
x_return_status := Delete_Row( p_article_version_id => p_article_version_id );
Okc_Debug.Log('9300: Leaving Delete_Row', 2);
Okc_Debug.Log('9400: Leaving Delete_Row:FND_API.G_EXC_ERROR Exception', 2);
Okc_Debug.Log('9500: Leaving Delete_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
Okc_Debug.Log('9600: Leaving Delete_Row because of EXCEPTION: '||sqlerrm, 2);
END Delete_Row;
-- and Update Article in Java Classes
-------------------------------------
FUNCTION ArticleBlob
RETURN BLOB IS
b1 BLOB;