[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL,
SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)
FROM DUAL;
PROCEDURE update_adoption_ifexists (p_article_version_id IN NUMBER,
p_org_id IN NUMBER,
p_article_status IN VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2) IS
CURSOR l_article_adoption_csr(cp_article_version_id IN NUMBER,
cp_local_org_id IN NUMBER) is
SELECT rowid from OKC_ARTICLE_ADOPTIONS
WHERE LOCAL_ARTICLE_VERSION_ID = cp_article_version_id
AND LOCAL_ORG_ID = cp_local_org_id
AND ADOPTION_TYPE = 'LOCALIZED'
FOR UPDATE OF object_version_number ;
okc_debug.log('500: Entering update adoption if exists ', 2);
UPDATE OKC_ARTICLE_ADOPTIONS
SET ADOPTION_STATUS = p_article_status,
OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
LAST_UPDATE_DATE = SYSDATE
WHERE CURRENT OF l_article_adoption_csr;
okc_debug.log('500: Leaving update adoption if exists successfully', 2);
okc_debug.log('500: Leaving update adoption if exists because of EXCEPTION: '||sqlerrm, 2);
END update_adoption_ifexists;
PROCEDURE update_prev_vers_enddate (p_article_version_id IN NUMBER,
p_article_id IN NUMBER,
p_end_date IN DATE,
p_current_org_id IN NUMBER,
x_return_status OUT NOCOPY VARCHAR2) IS
CURSOR l_earlier_version_csr(p_article_id IN NUMBER, p_article_version_id IN NUMBER) IS
-- 8.1.7.4 compatibility
select
av.global_yn,
av.article_status,
av.adoption_type,
av.start_date,
av.end_date,
av.article_version_number,
av.article_version_id
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.end_date is null
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 A.END_DATE IS NULL
AND ARTICLE_VERSION_ID <> p_article_version_id
) S
WHERE S.START_DATE = S.MAX_START_DATE;
okc_debug.log('500: Entering update prev vers end date ', 2);
OKC_ARTICLE_VERSIONS_PVT.Update_Row(
p_validation_level => FND_API.G_VALID_LEVEL_NONE,
x_return_status => x_return_status,
p_article_version_id => l_earlier_version_rec.article_version_id,
p_article_id => NULL,
p_article_version_number => NULL,
p_article_text => NULL,
p_provision_yn => NULL,
p_insert_by_reference => NULL,
p_lock_text => NULL,
p_global_yn => NULL,
p_article_language => NULL,
p_article_status => NULL,
p_sav_release => NULL,
p_start_date => NULL,
p_end_date => p_end_date,
p_std_article_version_id => NULL,
p_display_name => NULL,
p_translated_yn => NULL,
p_article_description => NULL,
p_date_approved => NULL,
p_default_section => NULL,
p_reference_source => NULL,
p_reference_text => NULL,
p_orig_system_reference_code => NULL,
p_orig_system_reference_id1 => NULL,
p_orig_system_reference_id2 => NULL,
p_additional_instructions => NULL,
p_variation_description => NULL,
p_current_org_id => p_current_org_id,
p_attribute_category => NULL,
p_attribute1 => NULL,
p_attribute2 => NULL,
p_attribute3 => NULL,
p_attribute4 => NULL,
p_attribute5 => NULL,
p_attribute6 => NULL,
p_attribute7 => NULL,
p_attribute8 => NULL,
p_attribute9 => NULL,
p_attribute10 => NULL,
p_attribute11 => NULL,
p_attribute12 => NULL,
p_attribute13 => NULL,
p_attribute14 => NULL,
p_attribute15 => NULL,
p_object_version_number => NULL,
x_article_status => l_article_status,
x_article_id => l_article_id,
x_earlier_version_id => l_earlier_version_id
);
okc_debug.log('500: Leaving update prev end date successfully', 2);
okc_debug.log('500: Leaving update prev vers end date because of EXCEPTION: '||sqlerrm, 2);
END update_prev_vers_enddate;
SELECT org_id, article_status, global_yn, art.article_id
FROM okc_articles_all art, okc_article_versions ver
WHERE ver.article_id = art.article_id
AND ver.article_version_id = cp_article_version_id
AND art.standard_yn = 'Y'
FOR UPDATE OF start_date;
okc_debug.log('120: Starting Update Adoption Statuses if Global Article ', 2);
update okc_article_adoptions
set adoption_status = l_new_article_status,
OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
LAST_UPDATE_DATE = SYSDATE
where global_article_version_id = p_article_version_id
and adoption_type = 'ADOPTED';
update okc_article_adoptions
set adoption_status = l_new_article_status,
OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
LAST_UPDATE_DATE = SYSDATE
where global_article_version_id = p_article_version_id
and adoption_type = 'AVAILABLE';
update okc_article_adoptions
set adoption_status = null,
OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
LAST_UPDATE_DATE = SYSDATE
where global_article_version_id = p_article_version_id
and adoption_type = 'AVAILABLE';
okc_debug.log('140: Finishing Update Adoption Statuses if Global Article ', 2);
okc_debug.log('160: Starting Update Article Status ', 2);
UPDATE OKC_ARTICLE_VERSIONS
SET ARTICLE_STATUS = l_new_article_status,
OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
LAST_UPDATE_DATE = SYSDATE
WHERE current of l_article_version_csr;
okc_debug.log('180: Finishing Update Article Status ', 2);
l_delete_adoption VARCHAR2(1) := 'T';
SELECT BVT.VARIABLE_NAME,
nvl(BVB.DISABLED_YN,'N'),
nvl(BVB.VALUE_SET_ID, -99),
BVB.VARIABLE_TYPE,
BVB.VARIABLE_SOURCE, -- Added for Bug 5958643
BVB.PROCEDURE_NAME -- Added for Bug 5958643
FROM
OKC_BUS_VARIABLES_TL BVT,
OKC_BUS_VARIABLES_B BVB,
OKC_ARTICLE_VARIABLES AAV
WHERE BVB.VARIABLE_CODE = BVT.VARIABLE_CODE
AND BVB.VARIABLE_CODE = AAV.VARIABLE_CODE
AND BVT.LANGUAGE = USERENV('LANG')
--AND BVB.DISABLED_YN = 'Y'
AND AAV.ARTICLE_VERSION_ID = cp_article_version_id;
select '1'
from
fnd_flex_value_sets
where flex_value_set_id = bvb_value_set_id;
SELECT DEFAULT_SECTION, ARTICLE_TYPE
FROM OKC_ARTICLE_VERSIONS VER,OKC_ARTICLES_ALL ART
WHERE
ART.ARTICLE_ID = VER.ARTICLE_ID
AND VER.ARTICLE_VERSION_ID = cp_article_version_id;
SELECT status
FROM all_objects
WHERE object_name = SUBSTR(p_procedure_name,
INSTR(p_procedure_name,'.')+1,
(INSTR(p_procedure_name,'.',1,2) -
INSTR(p_procedure_name,'.') - 1))
AND object_type = 'PACKAGE'
AND owner = SUBSTR(p_procedure_name,1,INSTR(p_procedure_name,'.')-1);
SELECT status
FROM all_objects
WHERE object_name = SUBSTR(p_procedure_name,
INSTR(p_procedure_name,'.')+1,
(INSTR(p_procedure_name,'.',1,2) -
INSTR(p_procedure_name,'.') - 1))
AND object_type = 'PACKAGE BODY'
AND owner = SUBSTR(p_procedure_name,1,INSTR(p_procedure_name,'.')-1);
SELECT 'X'
FROM all_source
WHERE name = SUBSTR(p_procedure_name,
INSTR(p_procedure_name,'.')+1,
(INSTR(p_procedure_name,'.',1,2) -
INSTR(p_procedure_name,'.') - 1))
AND type = 'PACKAGE'
AND owner = SUBSTR(p_procedure_name,1,INSTR(p_procedure_name,'.')-1)
AND text LIKE '%' || SUBSTR(p_procedure_name,INSTR(p_procedure_name,'.',1,2)+1) || '%';
l_variable_tbl.DELETE;
OKC_ARTICLE_VERSIONS_PVT.Update_Row(
p_validation_level => FND_API.G_VALID_LEVEL_NONE,
x_return_status => x_return_status,
p_article_version_id => p_article_version_id,
p_article_id => NULL,
p_article_version_number => NULL,
p_article_text => NULL,
p_provision_yn => NULL,
p_insert_by_reference => NULL,
p_lock_text => NULL,
p_global_yn => NULL,
p_article_language => NULL,
p_article_status => 'PENDING_APPROVAL',
p_sav_release => NULL,
p_start_date => NULL,
p_end_date => NULL,
p_std_article_version_id => NULL,
p_display_name => NULL,
p_translated_yn => NULL,
p_article_description => NULL,
p_date_approved => NULL,
p_default_section => NULL,
p_reference_source => NULL,
p_reference_text => NULL,
p_orig_system_reference_code => NULL,
p_orig_system_reference_id1 => NULL,
p_orig_system_reference_id2 => NULL,
p_additional_instructions => NULL,
p_variation_description => NULL,
p_current_org_id => p_current_org_id,
p_attribute_category => NULL,
p_attribute1 => NULL,
p_attribute2 => NULL,
p_attribute3 => NULL,
p_attribute4 => NULL,
p_attribute5 => NULL,
p_attribute6 => NULL,
p_attribute7 => NULL,
p_attribute8 => NULL,
p_attribute9 => NULL,
p_attribute10 => NULL,
p_attribute11 => NULL,
p_attribute12 => NULL,
p_attribute13 => NULL,
p_attribute14 => NULL,
p_attribute15 => NULL,
p_object_version_number => NULL,
x_article_status => l_article_status,
x_article_id => l_article_id,
x_earlier_version_id => l_earlier_version_id
);
OKC_ARTICLE_ADOPTIONS_PVT.update_row(
x_return_status => x_return_status,
p_global_article_version_id => p_article_version_id,
p_adoption_type => 'ADOPTED',
p_local_org_id => p_current_org_id,
p_orig_local_version_id => NULL,
p_new_local_version_id => NULL,
p_adoption_status => 'PENDING_APPROVAL',
p_object_version_number => NULL
);
INSERT INTO OKC_ARTICLE_RELATNS_ALL
(
SOURCE_ARTICLE_ID,
TARGET_ARTICLE_ID,
ORG_ID,
RELATIONSHIP_TYPE,
OBJECT_VERSION_NUMBER,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
LAST_UPDATE_DATE
)
SELECT source_article_id,
target_article_id,
p_current_org_id,
RELATIONSHIP_TYPE,
1.0,
l_user_id,
sysdate,
l_user_id,
l_login_id,
sysdate
from OKC_ARTICLE_RELATNS_ALL ARL1
WHERE org_id = G_GLOBAL_ORG_ID
AND exists
(select 1 from okc_article_versions, okc_article_adoptions adp
where article_id = target_article_id
and adp.global_article_version_id = article_version_id
and adp.local_org_id = p_current_org_id
and adp.adoption_type = 'ADOPTED')
AND EXISTS
(select 1 from okc_article_versions
where article_version_id = p_article_version_id
and source_article_id = article_id)
AND NOT EXISTS
(select 1 from okc_article_relatns_all ARL2
where arl1.source_article_id = arl2.source_article_id
and arl1.target_article_id = arl2.target_article_id
and arl1.relationship_type = arl2.relationship_type
and arl2.org_id = p_current_org_id);
INSERT INTO OKC_ARTICLE_RELATNS_ALL
(
SOURCE_ARTICLE_ID,
TARGET_ARTICLE_ID,
ORG_ID,
RELATIONSHIP_TYPE,
OBJECT_VERSION_NUMBER,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
LAST_UPDATE_DATE
)
SELECT source_article_id,
target_article_id,
p_current_org_id,
relationship_type,
1.0,
l_user_id,
sysdate,
l_user_id,
l_login_id,
sysdate
from OKC_ARTICLE_RELATNS_ALL ARL1
WHERE org_id = G_GLOBAL_ORG_ID
AND exists
(select 1 from okc_article_versions, okc_article_adoptions adp
where article_id = source_article_id
and adp.global_article_version_id = article_version_id
and adp.local_org_id = p_current_org_id
and adp.adoption_type = 'ADOPTED')
AND EXISTS
(select 1 from okc_article_versions
where article_version_id = p_article_version_id
and target_article_id = article_id)
AND NOT EXISTS
(select 1 from okc_article_relatns_all ARL2
where arl1.source_article_id = arl2.source_article_id
and arl1.target_article_id = arl2.target_article_id
and arl1.relationship_type = arl2.relationship_type
and arl2.org_id = p_current_org_id);
OKC_ARTICLE_VERSIONS_PVT.Update_Row(
p_validation_level => FND_API.G_VALID_LEVEL_NONE,
x_return_status => x_return_status,
p_article_version_id => p_article_version_id,
p_article_id => NULL,
p_article_version_number => NULL,
p_article_text => NULL,
p_provision_yn => NULL,
p_insert_by_reference => NULL,
p_lock_text => NULL,
p_global_yn => NULL,
p_article_language => NULL,
p_article_status => 'PENDING_APPROVAL',
p_sav_release => NULL,
p_start_date => NULL,
p_end_date => NULL,
p_std_article_version_id => NULL,
p_display_name => NULL,
p_translated_yn => NULL,
p_article_description => NULL,
p_date_approved => NULL,
p_default_section => NULL,
p_reference_source => NULL,
p_reference_text => NULL,
p_orig_system_reference_code => NULL,
p_orig_system_reference_id1 => NULL,
p_orig_system_reference_id2 => NULL,
p_additional_instructions => NULL,
p_variation_description => NULL,
p_current_org_id => p_current_org_id,
p_attribute_category => NULL,
p_attribute1 => NULL,
p_attribute2 => NULL,
p_attribute3 => NULL,
p_attribute4 => NULL,
p_attribute5 => NULL,
p_attribute6 => NULL,
p_attribute7 => NULL,
p_attribute8 => NULL,
p_attribute9 => NULL,
p_attribute10 => NULL,
p_attribute11 => NULL,
p_attribute12 => NULL,
p_attribute13 => NULL,
p_attribute14 => NULL,
p_attribute15 => NULL,
p_object_version_number => NULL,
x_article_status => l_article_status,
x_article_id => l_article_id,
x_earlier_version_id => l_earlier_version_id
);
update_adoption_ifexists (p_article_version_id,
p_current_org_id,
'PENDING_APPROVAL',
x_return_status );
l_delete_adoption VARCHAR2(1) := 'T';
SELECT global_yn, org_id, art.article_id, start_date
FROM okc_articles_all art, okc_article_versions ver
WHERE ver.article_id = art.article_id
AND ver.article_version_id = cp_article_version_id;
OKC_ARTICLE_VERSIONS_PVT.Update_Row(
p_validation_level => FND_API.G_VALID_LEVEL_NONE,
x_return_status => x_return_status,
p_article_version_id => p_article_version_id,
p_article_id => NULL,
p_article_version_number => NULL,
p_article_text => NULL,
p_provision_yn => NULL,
p_insert_by_reference => NULL,
p_lock_text => NULL,
p_global_yn => NULL,
p_article_language => NULL,
p_article_status => 'APPROVED',
p_sav_release => NULL,
p_start_date => NULL,
p_end_date => NULL,
p_std_article_version_id => NULL,
p_display_name => NULL,
p_translated_yn => NULL,
p_article_description => NULL,
p_date_approved => sysdate,
p_default_section => NULL,
p_reference_source => NULL,
p_reference_text => NULL,
p_orig_system_reference_code => NULL,
p_orig_system_reference_id1 => NULL,
p_orig_system_reference_id2 => NULL,
p_additional_instructions => NULL,
p_variation_description => NULL,
p_current_org_id => p_current_org_id ,
p_attribute_category => NULL,
p_attribute1 => NULL,
p_attribute2 => NULL,
p_attribute3 => NULL,
p_attribute4 => NULL,
p_attribute5 => NULL,
p_attribute6 => NULL,
p_attribute7 => NULL,
p_attribute8 => NULL,
p_attribute9 => NULL,
p_attribute10 => NULL,
p_attribute11 => NULL,
p_attribute12 => NULL,
p_attribute13 => NULL,
p_attribute14 => NULL,
p_attribute15 => NULL,
p_object_version_number => NULL,
x_article_status => l_article_status,
x_article_id => l_article_id,
x_earlier_version_id => l_earlier_version_id
);
update_prev_vers_enddate (p_article_version_id ,
l_article_version_rec.article_id,
l_article_version_rec.start_date - 1/86400,
p_current_org_id,
x_return_status );
OKC_ARTICLE_ADOPTIONS_PVT.update_row(
x_return_status => x_return_status,
p_global_article_version_id => p_article_version_id,
p_adoption_type => 'ADOPTED',
p_local_org_id => p_current_org_id ,
p_orig_local_version_id => NULL,
p_new_local_version_id => NULL,
p_adoption_status => 'APPROVED',
p_object_version_number => NULL
);
OKC_ARTICLE_VERSIONS_PVT.Update_Row(
p_validation_level => FND_API.G_VALID_LEVEL_NONE,
x_return_status => x_return_status,
p_article_version_id => p_article_version_id,
p_article_id => NULL,
p_article_version_number => NULL,
p_article_text => NULL,
p_provision_yn => NULL,
p_insert_by_reference => NULL,
p_lock_text => NULL,
p_global_yn => NULL,
p_article_language => NULL,
p_article_status => 'APPROVED',
p_sav_release => NULL,
p_start_date => NULL,
p_end_date => NULL,
p_std_article_version_id => NULL,
p_display_name => NULL,
p_translated_yn => NULL,
p_article_description => NULL,
p_date_approved => sysdate,
p_default_section => NULL,
p_reference_source => NULL,
p_reference_text => NULL,
p_orig_system_reference_code => NULL,
p_orig_system_reference_id1 => NULL,
p_orig_system_reference_id2 => NULL,
p_additional_instructions => NULL,
p_variation_description => NULL,
p_current_org_id => p_current_org_id ,
p_attribute_category => NULL,
p_attribute1 => NULL,
p_attribute2 => NULL,
p_attribute3 => NULL,
p_attribute4 => NULL,
p_attribute5 => NULL,
p_attribute6 => NULL,
p_attribute7 => NULL,
p_attribute8 => NULL,
p_attribute9 => NULL,
p_attribute10 => NULL,
p_attribute11 => NULL,
p_attribute12 => NULL,
p_attribute13 => NULL,
p_attribute14 => NULL,
p_attribute15 => NULL,
p_object_version_number => NULL,
x_article_status => l_article_status,
x_article_id => l_article_id,
x_earlier_version_id => l_earlier_version_id
);
update_prev_vers_enddate (p_article_version_id ,
l_article_version_rec.article_id,
l_article_version_rec.start_date - 1/86400,
p_current_org_id,
x_return_status );
update_adoption_ifexists (p_article_version_id,
p_current_org_id ,
'APPROVED',
x_return_status );
l_delete_adoption VARCHAR2(1) := 'T';
SELECT global_yn, org_id, art.article_id, start_date
FROM okc_articles_all art, okc_article_versions ver
WHERE ver.article_id = art.article_id
AND ver.article_version_id = cp_article_version_id;
OKC_ARTICLE_VERSIONS_PVT.Update_Row(
p_validation_level => FND_API.G_VALID_LEVEL_NONE,
x_return_status => x_return_status,
p_article_version_id => p_article_version_id,
p_article_id => NULL,
p_article_version_number => NULL,
p_article_text => NULL,
p_provision_yn => NULL,
p_insert_by_reference => NULL,
p_lock_text => NULL,
p_global_yn => NULL,
p_article_language => NULL,
p_article_status => 'REJECTED',
p_sav_release => NULL,
p_start_date => NULL,
p_end_date => NULL,
p_std_article_version_id => NULL,
p_display_name => NULL,
p_translated_yn => NULL,
p_article_description => NULL,
p_date_approved => NULL,
p_default_section => NULL,
p_reference_source => NULL,
p_reference_text => NULL,
p_orig_system_reference_code => NULL,
p_orig_system_reference_id1 => NULL,
p_orig_system_reference_id2 => NULL,
p_additional_instructions => NULL,
p_variation_description => NULL,
p_current_org_id => p_current_org_id ,
p_attribute_category => NULL,
p_attribute1 => NULL,
p_attribute2 => NULL,
p_attribute3 => NULL,
p_attribute4 => NULL,
p_attribute5 => NULL,
p_attribute6 => NULL,
p_attribute7 => NULL,
p_attribute8 => NULL,
p_attribute9 => NULL,
p_attribute10 => NULL,
p_attribute11 => NULL,
p_attribute12 => NULL,
p_attribute13 => NULL,
p_attribute14 => NULL,
p_attribute15 => NULL,
p_object_version_number => NULL,
x_article_status => l_article_status,
x_article_id => l_article_id,
x_earlier_version_id => l_earlier_version_id
);
OKC_ARTICLE_ADOPTIONS_PVT.update_row(
x_return_status => x_return_status,
p_global_article_version_id => p_article_version_id,
p_adoption_type => 'AVAILABLE',
p_local_org_id => p_current_org_id ,
p_orig_local_version_id => NULL,
p_new_local_version_id => NULL,
p_adoption_status => 'REJECTED',
p_object_version_number => NULL
);
DELETE FROM OKC_ARTICLE_RELATNS_ALL
WHERE source_article_id = l_article_version_rec.article_id
AND org_id = p_current_org_id
AND NOT EXISTS
(SELECT 1 FROM OKC_ARTICLE_ADOPTIONS ADP, OKC_ARTICLE_VERSIONS AV
WHERE ARTICLE_ID = l_article_version_rec.article_id
AND ARTICLE_VERSION_ID <> p_article_version_id
AND ADP.ADOPTION_TYPE = 'ADOPTED'
AND global_article_version_id = article_version_id
);
DELETE FROM OKC_ARTICLE_RELATNS_ALL
WHERE target_article_id = l_article_version_rec.article_id
AND org_id = p_current_org_id
AND NOT EXISTS
(SELECT 1 FROM OKC_ARTICLE_ADOPTIONS ADP, OKC_ARTICLE_VERSIONS AV
WHERE ARTICLE_ID = l_article_version_rec.article_id
AND ARTICLE_VERSION_ID <> p_article_version_id
AND ADP.ADOPTION_TYPE = 'ADOPTED'
AND global_article_version_id = article_version_id
);
OKC_ARTICLE_VERSIONS_PVT.Update_Row(
p_validation_level => FND_API.G_VALID_LEVEL_NONE,
x_return_status => x_return_status,
p_article_version_id => p_article_version_id,
p_article_id => NULL,
p_article_version_number => NULL,
p_article_text => NULL,
p_provision_yn => NULL,
p_insert_by_reference => NULL,
p_lock_text => NULL,
p_global_yn => NULL,
p_article_language => NULL,
p_article_status => 'REJECTED',
p_sav_release => NULL,
p_start_date => NULL,
p_end_date => NULL,
p_std_article_version_id => NULL,
p_display_name => NULL,
p_translated_yn => NULL,
p_article_description => NULL,
p_date_approved => NULL,
p_default_section => NULL,
p_reference_source => NULL,
p_reference_text => NULL,
p_orig_system_reference_code => NULL,
p_orig_system_reference_id1 => NULL,
p_orig_system_reference_id2 => NULL,
p_additional_instructions => NULL,
p_variation_description => NULL,
p_current_org_id => p_current_org_id ,
p_attribute_category => NULL,
p_attribute1 => NULL,
p_attribute2 => NULL,
p_attribute3 => NULL,
p_attribute4 => NULL,
p_attribute5 => NULL,
p_attribute6 => NULL,
p_attribute7 => NULL,
p_attribute8 => NULL,
p_attribute9 => NULL,
p_attribute10 => NULL,
p_attribute11 => NULL,
p_attribute12 => NULL,
p_attribute13 => NULL,
p_attribute14 => NULL,
p_attribute15 => NULL,
p_object_version_number => NULL,
x_article_status => l_article_status,
x_article_id => l_article_id,
x_earlier_version_id => l_earlier_version_id
);
update_adoption_ifexists (p_article_version_id,
p_current_org_id ,
'REJECTED',
x_return_status );
okc_debug.log('300: Leaving delete_Adoption: OKC_API.G_EXCEPTION_ERROR Exception', 2);
okc_debug.log('500: Leaving delete_Adoption because of EXCEPTION: '||sqlerrm, 2);