eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_ARTICLES_GRP dependencies on OKC_ARTICLE_VERSIONS

Line 857: OKC_ARTICLE_VERSIONS_PVT.Delete_Row(

853:
854: --------------------------------------------
855: -- Calling Simple API for Deleting A Row
856: --------------------------------------------
857: OKC_ARTICLE_VERSIONS_PVT.Delete_Row(
858: x_return_status => x_return_status,
859: p_article_version_id => p_article_version_id,
860: p_object_version_number => p_object_version_number
861: );

Line 1023: l_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;

1019: ) IS
1020: l_api_version CONSTANT NUMBER := 1;
1021: l_api_name CONSTANT VARCHAR2(30) := 'g_validate_article';
1022: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1023: l_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
1024:
1025: BEGIN
1026:
1027: IF (l_debug = 'Y') THEN

Line 1077: OKC_ARTICLE_VERSIONS_PVT.Validate_Row(

1073: l_article_status := 'APPROVED';
1074: ELSE
1075: l_article_status := p_article_status;
1076: END IF;
1077: OKC_ARTICLE_VERSIONS_PVT.Validate_Row(
1078: p_validation_level => p_validation_level,
1079: p_import_action => p_import_action,
1080: x_return_status => x_return_status,
1081: x_earlier_adoption_type => x_earlier_adoption_type,

Line 1823: l_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;

1819: l_api_name CONSTANT VARCHAR2(30) := 'g_delete_article';
1820: l_status VARCHAR2(30) ;
1821: l_standard_yn VARCHAR2(1) ;
1822: l_only_version VARCHAR2(1) := 'T';
1823: l_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
1824: l_dummy1 VARCHAR2(1) := '?';
1825:
1826: Cursor l_status_csr (cp_article_id IN NUMBER,
1827: cp_article_version_id IN NUMBER) IS

Line 1829: FROM okc_article_versions av,okc_articles_all aa

1825:
1826: Cursor l_status_csr (cp_article_id IN NUMBER,
1827: cp_article_version_id IN NUMBER) IS
1828: SELECT article_status,standard_yn, adoption_type
1829: FROM okc_article_versions av,okc_articles_all aa
1830: WHERE aa.article_id = av.article_id
1831: AND av.article_id = cp_article_id
1832: AND av.article_version_id = cp_article_version_id;
1833:

Line 1838: FROM OKC_ARTICLE_VERSIONS A

1834:
1835: CURSOR l_only_version_csr(cp_article_id IN NUMBER,
1836: cp_article_version_id IN NUMBER) IS
1837: SELECT 'F'
1838: FROM OKC_ARTICLE_VERSIONS A
1839: WHERE A.ARTICLE_ID = cp_article_id
1840: AND A.ARTICLE_VERSION_ID <> cp_article_version_id
1841: AND rownum < 2 ;
1842:

Line 2089: l_earlier_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;

2085: p_attribute15 IN VARCHAR2 := NULL
2086: ) IS
2087: l_api_version CONSTANT NUMBER := 1;
2088: l_api_name CONSTANT VARCHAR2(30) := 'g_validate_article_version';
2089: l_earlier_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
2090:
2091: BEGIN
2092:
2093: IF (l_debug = 'Y') THEN

Line 2113: OKC_ARTICLE_VERSIONS_PVT.Validate_Row(

2109:
2110: --------------------------------------------
2111: -- Calling Simple API for Article Version Validation
2112: --------------------------------------------
2113: OKC_ARTICLE_VERSIONS_PVT.Validate_Row(
2114: p_validation_level => p_validation_level,
2115: p_import_action => p_import_action,
2116: x_return_status => x_return_status,
2117: x_earlier_adoption_type => x_earlier_adoption_type,

Line 2276: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE := 1;

2272: ) IS
2273:
2274: l_api_version CONSTANT NUMBER := 1;
2275: l_api_name CONSTANT VARCHAR2(30) := 'g_create_article_version';
2276: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE := 1;
2277: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
2278: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
2279: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
2280: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;

Line 2277: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;

2273:
2274: l_api_version CONSTANT NUMBER := 1;
2275: l_api_name CONSTANT VARCHAR2(30) := 'g_create_article_version';
2276: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE := 1;
2277: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
2278: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
2279: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
2280: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
2281: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;

Line 2278: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;

2274: l_api_version CONSTANT NUMBER := 1;
2275: l_api_name CONSTANT VARCHAR2(30) := 'g_create_article_version';
2276: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE := 1;
2277: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
2278: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
2279: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
2280: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
2281: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;
2282: l_adoption_type OKC_ARTICLE_ADOPTIONS.ADOPTION_TYPE%TYPE;

Line 2279: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;

2275: l_api_name CONSTANT VARCHAR2(30) := 'g_create_article_version';
2276: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE := 1;
2277: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
2278: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
2279: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
2280: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
2281: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;
2282: l_adoption_type OKC_ARTICLE_ADOPTIONS.ADOPTION_TYPE%TYPE;
2283: l_earlier_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;

Line 2280: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;

2276: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE := 1;
2277: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
2278: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
2279: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
2280: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
2281: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;
2282: l_adoption_type OKC_ARTICLE_ADOPTIONS.ADOPTION_TYPE%TYPE;
2283: l_earlier_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
2284: l_variable_code_tbl variable_code_tbl_type;

Line 2281: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;

2277: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
2278: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
2279: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
2280: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
2281: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;
2282: l_adoption_type OKC_ARTICLE_ADOPTIONS.ADOPTION_TYPE%TYPE;
2283: l_earlier_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
2284: l_variable_code_tbl variable_code_tbl_type;
2285: l_org_id NUMBER;

Line 2283: l_earlier_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;

2279: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
2280: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
2281: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;
2282: l_adoption_type OKC_ARTICLE_ADOPTIONS.ADOPTION_TYPE%TYPE;
2283: l_earlier_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
2284: l_variable_code_tbl variable_code_tbl_type;
2285: l_org_id NUMBER;
2286: l_global_article_version_id NUMBER;
2287: l_global_version_id_out NUMBER;

Line 2294: l_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;

2290: l_earlier_version_id NUMBER;
2291: l_row_notfound BOOLEAN := TRUE;
2292: l_rowid ROWID;
2293: l_article_text CLOB;
2294: l_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
2295: i NUMBER := 0;
2296: l_clob CLOB;
2297: -- Bug 3917777
2298: l_user_id NUMBER := FND_GLOBAL.USER_ID;

Line 2366: OKC_ARTICLE_VERSIONS_PVT.Insert_Row(

2362:
2363: --------------------------------------------
2364: -- Calling Simple API for Creating A Row
2365: --------------------------------------------
2366: OKC_ARTICLE_VERSIONS_PVT.Insert_Row(
2367: p_validation_level => p_validation_level,
2368: x_return_status => x_return_status,
2369: p_article_id => p_article_id,
2370: p_article_text => l_clob,

Line 2502: UPDATE OKC_ARTICLE_VERSIONS

2498:
2499: -- Update denormalized adoption type in article versions table
2500: -- No need to call the update API as the row is still locked and it will be an overhead
2501:
2502: UPDATE OKC_ARTICLE_VERSIONS
2503: SET adoption_type = nvl(l_adoption_type, 'LOCAL')
2504: WHERE article_version_id = x_article_version_id;
2505: END IF;
2506:

Line 2587: OKC_ARTICLE_VERSIONS_PVT.lock_row(

2583:
2584: --------------------------------------------
2585: -- Calling Simple API for Locking A Row
2586: --------------------------------------------
2587: OKC_ARTICLE_VERSIONS_PVT.lock_row(
2588: x_return_status => x_return_status,
2589: p_article_version_id => p_article_version_id,
2590: p_object_version_number => p_object_version_number
2591: );

Line 2824: l_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;

2820: l_api_name CONSTANT VARCHAR2(30) := 'g_update_article_version';
2821: l_earlier_version_id NUMBER;
2822: l_article_id NUMBER;
2823: l_article_text CLOB;
2824: l_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
2825: l_variable_code_tbl variable_code_tbl_type;
2826: l_variables_to_insert_tbl variable_code_tbl_type;
2827: l_variables_to_delete_tbl variable_code_tbl_type;
2828: l_clob CLOB;

Line 2918: OKC_ARTICLE_VERSIONS_PVT.Update_Row(

2914: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_NULL_ORG_ID');
2915: RAISE FND_API.G_EXC_ERROR ;
2916: END IF;
2917:
2918: OKC_ARTICLE_VERSIONS_PVT.Update_Row(
2919: p_validation_level => p_validation_level,
2920: x_return_status => x_return_status,
2921: p_article_version_id => p_article_version_id,
2922: p_article_id => p_article_id,

Line 3106: lv_article_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE ;

3102: l_last_updated_by OKC_ARTICLES_ALL.LAST_UPDATED_BY%TYPE;
3103: l_last_update_login OKC_ARTICLES_ALL.LAST_UPDATE_LOGIN%TYPE;
3104:
3105: -- Article Version Attributes
3106: lv_article_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE ;
3107: lv_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE ;
3108: lv_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE ;
3109: lv_article_id OKC_ARTICLE_VERSIONS.ARTICLE_ID%TYPE ;
3110: lv_article_text OKC_ARTICLE_VERSIONS.ARTICLE_TEXT%TYPE;

Line 3107: lv_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE ;

3103: l_last_update_login OKC_ARTICLES_ALL.LAST_UPDATE_LOGIN%TYPE;
3104:
3105: -- Article Version Attributes
3106: lv_article_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE ;
3107: lv_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE ;
3108: lv_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE ;
3109: lv_article_id OKC_ARTICLE_VERSIONS.ARTICLE_ID%TYPE ;
3110: lv_article_text OKC_ARTICLE_VERSIONS.ARTICLE_TEXT%TYPE;
3111: lv_provision_yn OKC_ARTICLE_VERSIONS.PROVISION_YN%TYPE;

Line 3108: lv_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE ;

3104:
3105: -- Article Version Attributes
3106: lv_article_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE ;
3107: lv_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE ;
3108: lv_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE ;
3109: lv_article_id OKC_ARTICLE_VERSIONS.ARTICLE_ID%TYPE ;
3110: lv_article_text OKC_ARTICLE_VERSIONS.ARTICLE_TEXT%TYPE;
3111: lv_provision_yn OKC_ARTICLE_VERSIONS.PROVISION_YN%TYPE;
3112: lv_insert_by_reference OKC_ARTICLE_VERSIONS.INSERT_BY_REFERENCE%TYPE;

Line 3109: lv_article_id OKC_ARTICLE_VERSIONS.ARTICLE_ID%TYPE ;

3105: -- Article Version Attributes
3106: lv_article_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE ;
3107: lv_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE ;
3108: lv_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE ;
3109: lv_article_id OKC_ARTICLE_VERSIONS.ARTICLE_ID%TYPE ;
3110: lv_article_text OKC_ARTICLE_VERSIONS.ARTICLE_TEXT%TYPE;
3111: lv_provision_yn OKC_ARTICLE_VERSIONS.PROVISION_YN%TYPE;
3112: lv_insert_by_reference OKC_ARTICLE_VERSIONS.INSERT_BY_REFERENCE%TYPE;
3113: lv_lock_text OKC_ARTICLE_VERSIONS.LOCK_TEXT%TYPE;

Line 3110: lv_article_text OKC_ARTICLE_VERSIONS.ARTICLE_TEXT%TYPE;

3106: lv_article_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE ;
3107: lv_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE ;
3108: lv_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE ;
3109: lv_article_id OKC_ARTICLE_VERSIONS.ARTICLE_ID%TYPE ;
3110: lv_article_text OKC_ARTICLE_VERSIONS.ARTICLE_TEXT%TYPE;
3111: lv_provision_yn OKC_ARTICLE_VERSIONS.PROVISION_YN%TYPE;
3112: lv_insert_by_reference OKC_ARTICLE_VERSIONS.INSERT_BY_REFERENCE%TYPE;
3113: lv_lock_text OKC_ARTICLE_VERSIONS.LOCK_TEXT%TYPE;
3114: lv_global_yn OKC_ARTICLE_VERSIONS.GLOBAL_YN%TYPE;

Line 3111: lv_provision_yn OKC_ARTICLE_VERSIONS.PROVISION_YN%TYPE;

3107: lv_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE ;
3108: lv_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE ;
3109: lv_article_id OKC_ARTICLE_VERSIONS.ARTICLE_ID%TYPE ;
3110: lv_article_text OKC_ARTICLE_VERSIONS.ARTICLE_TEXT%TYPE;
3111: lv_provision_yn OKC_ARTICLE_VERSIONS.PROVISION_YN%TYPE;
3112: lv_insert_by_reference OKC_ARTICLE_VERSIONS.INSERT_BY_REFERENCE%TYPE;
3113: lv_lock_text OKC_ARTICLE_VERSIONS.LOCK_TEXT%TYPE;
3114: lv_global_yn OKC_ARTICLE_VERSIONS.GLOBAL_YN%TYPE;
3115: lv_article_language OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE ;

Line 3112: lv_insert_by_reference OKC_ARTICLE_VERSIONS.INSERT_BY_REFERENCE%TYPE;

3108: lv_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE ;
3109: lv_article_id OKC_ARTICLE_VERSIONS.ARTICLE_ID%TYPE ;
3110: lv_article_text OKC_ARTICLE_VERSIONS.ARTICLE_TEXT%TYPE;
3111: lv_provision_yn OKC_ARTICLE_VERSIONS.PROVISION_YN%TYPE;
3112: lv_insert_by_reference OKC_ARTICLE_VERSIONS.INSERT_BY_REFERENCE%TYPE;
3113: lv_lock_text OKC_ARTICLE_VERSIONS.LOCK_TEXT%TYPE;
3114: lv_global_yn OKC_ARTICLE_VERSIONS.GLOBAL_YN%TYPE;
3115: lv_article_language OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE ;
3116: lv_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;

Line 3113: lv_lock_text OKC_ARTICLE_VERSIONS.LOCK_TEXT%TYPE;

3109: lv_article_id OKC_ARTICLE_VERSIONS.ARTICLE_ID%TYPE ;
3110: lv_article_text OKC_ARTICLE_VERSIONS.ARTICLE_TEXT%TYPE;
3111: lv_provision_yn OKC_ARTICLE_VERSIONS.PROVISION_YN%TYPE;
3112: lv_insert_by_reference OKC_ARTICLE_VERSIONS.INSERT_BY_REFERENCE%TYPE;
3113: lv_lock_text OKC_ARTICLE_VERSIONS.LOCK_TEXT%TYPE;
3114: lv_global_yn OKC_ARTICLE_VERSIONS.GLOBAL_YN%TYPE;
3115: lv_article_language OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE ;
3116: lv_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
3117: lv_sav_release OKC_ARTICLE_VERSIONS.SAV_RELEASE%TYPE;

Line 3114: lv_global_yn OKC_ARTICLE_VERSIONS.GLOBAL_YN%TYPE;

3110: lv_article_text OKC_ARTICLE_VERSIONS.ARTICLE_TEXT%TYPE;
3111: lv_provision_yn OKC_ARTICLE_VERSIONS.PROVISION_YN%TYPE;
3112: lv_insert_by_reference OKC_ARTICLE_VERSIONS.INSERT_BY_REFERENCE%TYPE;
3113: lv_lock_text OKC_ARTICLE_VERSIONS.LOCK_TEXT%TYPE;
3114: lv_global_yn OKC_ARTICLE_VERSIONS.GLOBAL_YN%TYPE;
3115: lv_article_language OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE ;
3116: lv_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
3117: lv_sav_release OKC_ARTICLE_VERSIONS.SAV_RELEASE%TYPE;
3118: lv_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE ;

Line 3115: lv_article_language OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE ;

3111: lv_provision_yn OKC_ARTICLE_VERSIONS.PROVISION_YN%TYPE;
3112: lv_insert_by_reference OKC_ARTICLE_VERSIONS.INSERT_BY_REFERENCE%TYPE;
3113: lv_lock_text OKC_ARTICLE_VERSIONS.LOCK_TEXT%TYPE;
3114: lv_global_yn OKC_ARTICLE_VERSIONS.GLOBAL_YN%TYPE;
3115: lv_article_language OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE ;
3116: lv_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
3117: lv_sav_release OKC_ARTICLE_VERSIONS.SAV_RELEASE%TYPE;
3118: lv_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE ;
3119: lv_end_date OKC_ARTICLE_VERSIONS.END_DATE%TYPE;

Line 3116: lv_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;

3112: lv_insert_by_reference OKC_ARTICLE_VERSIONS.INSERT_BY_REFERENCE%TYPE;
3113: lv_lock_text OKC_ARTICLE_VERSIONS.LOCK_TEXT%TYPE;
3114: lv_global_yn OKC_ARTICLE_VERSIONS.GLOBAL_YN%TYPE;
3115: lv_article_language OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE ;
3116: lv_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
3117: lv_sav_release OKC_ARTICLE_VERSIONS.SAV_RELEASE%TYPE;
3118: lv_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE ;
3119: lv_end_date OKC_ARTICLE_VERSIONS.END_DATE%TYPE;
3120: lv_std_article_version_id OKC_ARTICLE_VERSIONS.STD_ARTICLE_VERSION_ID%TYPE ;

Line 3117: lv_sav_release OKC_ARTICLE_VERSIONS.SAV_RELEASE%TYPE;

3113: lv_lock_text OKC_ARTICLE_VERSIONS.LOCK_TEXT%TYPE;
3114: lv_global_yn OKC_ARTICLE_VERSIONS.GLOBAL_YN%TYPE;
3115: lv_article_language OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE ;
3116: lv_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
3117: lv_sav_release OKC_ARTICLE_VERSIONS.SAV_RELEASE%TYPE;
3118: lv_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE ;
3119: lv_end_date OKC_ARTICLE_VERSIONS.END_DATE%TYPE;
3120: lv_std_article_version_id OKC_ARTICLE_VERSIONS.STD_ARTICLE_VERSION_ID%TYPE ;
3121: lv_display_name OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE;

Line 3118: lv_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE ;

3114: lv_global_yn OKC_ARTICLE_VERSIONS.GLOBAL_YN%TYPE;
3115: lv_article_language OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE ;
3116: lv_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
3117: lv_sav_release OKC_ARTICLE_VERSIONS.SAV_RELEASE%TYPE;
3118: lv_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE ;
3119: lv_end_date OKC_ARTICLE_VERSIONS.END_DATE%TYPE;
3120: lv_std_article_version_id OKC_ARTICLE_VERSIONS.STD_ARTICLE_VERSION_ID%TYPE ;
3121: lv_display_name OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE;
3122: lv_translated_yn OKC_ARTICLE_VERSIONS.TRANSLATED_YN%TYPE;

Line 3119: lv_end_date OKC_ARTICLE_VERSIONS.END_DATE%TYPE;

3115: lv_article_language OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE ;
3116: lv_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
3117: lv_sav_release OKC_ARTICLE_VERSIONS.SAV_RELEASE%TYPE;
3118: lv_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE ;
3119: lv_end_date OKC_ARTICLE_VERSIONS.END_DATE%TYPE;
3120: lv_std_article_version_id OKC_ARTICLE_VERSIONS.STD_ARTICLE_VERSION_ID%TYPE ;
3121: lv_display_name OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE;
3122: lv_translated_yn OKC_ARTICLE_VERSIONS.TRANSLATED_YN%TYPE;
3123: lv_article_description OKC_ARTICLE_VERSIONS.ARTICLE_DESCRIPTION%TYPE;

Line 3120: lv_std_article_version_id OKC_ARTICLE_VERSIONS.STD_ARTICLE_VERSION_ID%TYPE ;

3116: lv_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
3117: lv_sav_release OKC_ARTICLE_VERSIONS.SAV_RELEASE%TYPE;
3118: lv_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE ;
3119: lv_end_date OKC_ARTICLE_VERSIONS.END_DATE%TYPE;
3120: lv_std_article_version_id OKC_ARTICLE_VERSIONS.STD_ARTICLE_VERSION_ID%TYPE ;
3121: lv_display_name OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE;
3122: lv_translated_yn OKC_ARTICLE_VERSIONS.TRANSLATED_YN%TYPE;
3123: lv_article_description OKC_ARTICLE_VERSIONS.ARTICLE_DESCRIPTION%TYPE;
3124: lv_date_approved OKC_ARTICLE_VERSIONS.DATE_APPROVED%TYPE;

Line 3121: lv_display_name OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE;

3117: lv_sav_release OKC_ARTICLE_VERSIONS.SAV_RELEASE%TYPE;
3118: lv_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE ;
3119: lv_end_date OKC_ARTICLE_VERSIONS.END_DATE%TYPE;
3120: lv_std_article_version_id OKC_ARTICLE_VERSIONS.STD_ARTICLE_VERSION_ID%TYPE ;
3121: lv_display_name OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE;
3122: lv_translated_yn OKC_ARTICLE_VERSIONS.TRANSLATED_YN%TYPE;
3123: lv_article_description OKC_ARTICLE_VERSIONS.ARTICLE_DESCRIPTION%TYPE;
3124: lv_date_approved OKC_ARTICLE_VERSIONS.DATE_APPROVED%TYPE;
3125: lv_default_section OKC_ARTICLE_VERSIONS.DEFAULT_SECTION%TYPE;

Line 3122: lv_translated_yn OKC_ARTICLE_VERSIONS.TRANSLATED_YN%TYPE;

3118: lv_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE ;
3119: lv_end_date OKC_ARTICLE_VERSIONS.END_DATE%TYPE;
3120: lv_std_article_version_id OKC_ARTICLE_VERSIONS.STD_ARTICLE_VERSION_ID%TYPE ;
3121: lv_display_name OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE;
3122: lv_translated_yn OKC_ARTICLE_VERSIONS.TRANSLATED_YN%TYPE;
3123: lv_article_description OKC_ARTICLE_VERSIONS.ARTICLE_DESCRIPTION%TYPE;
3124: lv_date_approved OKC_ARTICLE_VERSIONS.DATE_APPROVED%TYPE;
3125: lv_default_section OKC_ARTICLE_VERSIONS.DEFAULT_SECTION%TYPE;
3126: lv_reference_source OKC_ARTICLE_VERSIONS.REFERENCE_SOURCE%TYPE;

Line 3123: lv_article_description OKC_ARTICLE_VERSIONS.ARTICLE_DESCRIPTION%TYPE;

3119: lv_end_date OKC_ARTICLE_VERSIONS.END_DATE%TYPE;
3120: lv_std_article_version_id OKC_ARTICLE_VERSIONS.STD_ARTICLE_VERSION_ID%TYPE ;
3121: lv_display_name OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE;
3122: lv_translated_yn OKC_ARTICLE_VERSIONS.TRANSLATED_YN%TYPE;
3123: lv_article_description OKC_ARTICLE_VERSIONS.ARTICLE_DESCRIPTION%TYPE;
3124: lv_date_approved OKC_ARTICLE_VERSIONS.DATE_APPROVED%TYPE;
3125: lv_default_section OKC_ARTICLE_VERSIONS.DEFAULT_SECTION%TYPE;
3126: lv_reference_source OKC_ARTICLE_VERSIONS.REFERENCE_SOURCE%TYPE;
3127: lv_reference_text OKC_ARTICLE_VERSIONS.REFERENCE_TEXT%TYPE;

Line 3124: lv_date_approved OKC_ARTICLE_VERSIONS.DATE_APPROVED%TYPE;

3120: lv_std_article_version_id OKC_ARTICLE_VERSIONS.STD_ARTICLE_VERSION_ID%TYPE ;
3121: lv_display_name OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE;
3122: lv_translated_yn OKC_ARTICLE_VERSIONS.TRANSLATED_YN%TYPE;
3123: lv_article_description OKC_ARTICLE_VERSIONS.ARTICLE_DESCRIPTION%TYPE;
3124: lv_date_approved OKC_ARTICLE_VERSIONS.DATE_APPROVED%TYPE;
3125: lv_default_section OKC_ARTICLE_VERSIONS.DEFAULT_SECTION%TYPE;
3126: lv_reference_source OKC_ARTICLE_VERSIONS.REFERENCE_SOURCE%TYPE;
3127: lv_reference_text OKC_ARTICLE_VERSIONS.REFERENCE_TEXT%TYPE;
3128: lv_additional_instructions OKC_ARTICLE_VERSIONS.ADDITIONAL_INSTRUCTIONS%TYPE;

Line 3125: lv_default_section OKC_ARTICLE_VERSIONS.DEFAULT_SECTION%TYPE;

3121: lv_display_name OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE;
3122: lv_translated_yn OKC_ARTICLE_VERSIONS.TRANSLATED_YN%TYPE;
3123: lv_article_description OKC_ARTICLE_VERSIONS.ARTICLE_DESCRIPTION%TYPE;
3124: lv_date_approved OKC_ARTICLE_VERSIONS.DATE_APPROVED%TYPE;
3125: lv_default_section OKC_ARTICLE_VERSIONS.DEFAULT_SECTION%TYPE;
3126: lv_reference_source OKC_ARTICLE_VERSIONS.REFERENCE_SOURCE%TYPE;
3127: lv_reference_text OKC_ARTICLE_VERSIONS.REFERENCE_TEXT%TYPE;
3128: lv_additional_instructions OKC_ARTICLE_VERSIONS.ADDITIONAL_INSTRUCTIONS%TYPE;
3129: lv_variation_description OKC_ARTICLE_VERSIONS.VARIATION_DESCRIPTION%TYPE;

Line 3126: lv_reference_source OKC_ARTICLE_VERSIONS.REFERENCE_SOURCE%TYPE;

3122: lv_translated_yn OKC_ARTICLE_VERSIONS.TRANSLATED_YN%TYPE;
3123: lv_article_description OKC_ARTICLE_VERSIONS.ARTICLE_DESCRIPTION%TYPE;
3124: lv_date_approved OKC_ARTICLE_VERSIONS.DATE_APPROVED%TYPE;
3125: lv_default_section OKC_ARTICLE_VERSIONS.DEFAULT_SECTION%TYPE;
3126: lv_reference_source OKC_ARTICLE_VERSIONS.REFERENCE_SOURCE%TYPE;
3127: lv_reference_text OKC_ARTICLE_VERSIONS.REFERENCE_TEXT%TYPE;
3128: lv_additional_instructions OKC_ARTICLE_VERSIONS.ADDITIONAL_INSTRUCTIONS%TYPE;
3129: lv_variation_description OKC_ARTICLE_VERSIONS.VARIATION_DESCRIPTION%TYPE;
3130: lv_date_published OKC_ARTICLE_VERSIONS.DATE_PUBLISHED%TYPE;

Line 3127: lv_reference_text OKC_ARTICLE_VERSIONS.REFERENCE_TEXT%TYPE;

3123: lv_article_description OKC_ARTICLE_VERSIONS.ARTICLE_DESCRIPTION%TYPE;
3124: lv_date_approved OKC_ARTICLE_VERSIONS.DATE_APPROVED%TYPE;
3125: lv_default_section OKC_ARTICLE_VERSIONS.DEFAULT_SECTION%TYPE;
3126: lv_reference_source OKC_ARTICLE_VERSIONS.REFERENCE_SOURCE%TYPE;
3127: lv_reference_text OKC_ARTICLE_VERSIONS.REFERENCE_TEXT%TYPE;
3128: lv_additional_instructions OKC_ARTICLE_VERSIONS.ADDITIONAL_INSTRUCTIONS%TYPE;
3129: lv_variation_description OKC_ARTICLE_VERSIONS.VARIATION_DESCRIPTION%TYPE;
3130: lv_date_published OKC_ARTICLE_VERSIONS.DATE_PUBLISHED%TYPE;
3131: lv_orig_system_reference_code OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_CODE%TYPE;

Line 3128: lv_additional_instructions OKC_ARTICLE_VERSIONS.ADDITIONAL_INSTRUCTIONS%TYPE;

3124: lv_date_approved OKC_ARTICLE_VERSIONS.DATE_APPROVED%TYPE;
3125: lv_default_section OKC_ARTICLE_VERSIONS.DEFAULT_SECTION%TYPE;
3126: lv_reference_source OKC_ARTICLE_VERSIONS.REFERENCE_SOURCE%TYPE;
3127: lv_reference_text OKC_ARTICLE_VERSIONS.REFERENCE_TEXT%TYPE;
3128: lv_additional_instructions OKC_ARTICLE_VERSIONS.ADDITIONAL_INSTRUCTIONS%TYPE;
3129: lv_variation_description OKC_ARTICLE_VERSIONS.VARIATION_DESCRIPTION%TYPE;
3130: lv_date_published OKC_ARTICLE_VERSIONS.DATE_PUBLISHED%TYPE;
3131: lv_orig_system_reference_code OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
3132: lv_orig_system_reference_id1 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID1%TYPE;

Line 3129: lv_variation_description OKC_ARTICLE_VERSIONS.VARIATION_DESCRIPTION%TYPE;

3125: lv_default_section OKC_ARTICLE_VERSIONS.DEFAULT_SECTION%TYPE;
3126: lv_reference_source OKC_ARTICLE_VERSIONS.REFERENCE_SOURCE%TYPE;
3127: lv_reference_text OKC_ARTICLE_VERSIONS.REFERENCE_TEXT%TYPE;
3128: lv_additional_instructions OKC_ARTICLE_VERSIONS.ADDITIONAL_INSTRUCTIONS%TYPE;
3129: lv_variation_description OKC_ARTICLE_VERSIONS.VARIATION_DESCRIPTION%TYPE;
3130: lv_date_published OKC_ARTICLE_VERSIONS.DATE_PUBLISHED%TYPE;
3131: lv_orig_system_reference_code OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
3132: lv_orig_system_reference_id1 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
3133: lv_orig_system_reference_id2 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID2%TYPE;

Line 3130: lv_date_published OKC_ARTICLE_VERSIONS.DATE_PUBLISHED%TYPE;

3126: lv_reference_source OKC_ARTICLE_VERSIONS.REFERENCE_SOURCE%TYPE;
3127: lv_reference_text OKC_ARTICLE_VERSIONS.REFERENCE_TEXT%TYPE;
3128: lv_additional_instructions OKC_ARTICLE_VERSIONS.ADDITIONAL_INSTRUCTIONS%TYPE;
3129: lv_variation_description OKC_ARTICLE_VERSIONS.VARIATION_DESCRIPTION%TYPE;
3130: lv_date_published OKC_ARTICLE_VERSIONS.DATE_PUBLISHED%TYPE;
3131: lv_orig_system_reference_code OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
3132: lv_orig_system_reference_id1 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
3133: lv_orig_system_reference_id2 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
3134: lv_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE ;

Line 3131: lv_orig_system_reference_code OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_CODE%TYPE;

3127: lv_reference_text OKC_ARTICLE_VERSIONS.REFERENCE_TEXT%TYPE;
3128: lv_additional_instructions OKC_ARTICLE_VERSIONS.ADDITIONAL_INSTRUCTIONS%TYPE;
3129: lv_variation_description OKC_ARTICLE_VERSIONS.VARIATION_DESCRIPTION%TYPE;
3130: lv_date_published OKC_ARTICLE_VERSIONS.DATE_PUBLISHED%TYPE;
3131: lv_orig_system_reference_code OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
3132: lv_orig_system_reference_id1 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
3133: lv_orig_system_reference_id2 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
3134: lv_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE ;
3135: lv_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE ;

Line 3132: lv_orig_system_reference_id1 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID1%TYPE;

3128: lv_additional_instructions OKC_ARTICLE_VERSIONS.ADDITIONAL_INSTRUCTIONS%TYPE;
3129: lv_variation_description OKC_ARTICLE_VERSIONS.VARIATION_DESCRIPTION%TYPE;
3130: lv_date_published OKC_ARTICLE_VERSIONS.DATE_PUBLISHED%TYPE;
3131: lv_orig_system_reference_code OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
3132: lv_orig_system_reference_id1 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
3133: lv_orig_system_reference_id2 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
3134: lv_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE ;
3135: lv_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE ;
3136: lv_program_application_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE ;

Line 3133: lv_orig_system_reference_id2 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID2%TYPE;

3129: lv_variation_description OKC_ARTICLE_VERSIONS.VARIATION_DESCRIPTION%TYPE;
3130: lv_date_published OKC_ARTICLE_VERSIONS.DATE_PUBLISHED%TYPE;
3131: lv_orig_system_reference_code OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
3132: lv_orig_system_reference_id1 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
3133: lv_orig_system_reference_id2 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
3134: lv_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE ;
3135: lv_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE ;
3136: lv_program_application_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE ;
3137: lv_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE ;

Line 3134: lv_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE ;

3130: lv_date_published OKC_ARTICLE_VERSIONS.DATE_PUBLISHED%TYPE;
3131: lv_orig_system_reference_code OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
3132: lv_orig_system_reference_id1 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
3133: lv_orig_system_reference_id2 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
3134: lv_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE ;
3135: lv_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE ;
3136: lv_program_application_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE ;
3137: lv_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE ;
3138: lv_attribute_category OKC_ARTICLE_VERSIONS.ATTRIBUTE_CATEGORY%TYPE;

Line 3135: lv_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE ;

3131: lv_orig_system_reference_code OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
3132: lv_orig_system_reference_id1 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
3133: lv_orig_system_reference_id2 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
3134: lv_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE ;
3135: lv_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE ;
3136: lv_program_application_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE ;
3137: lv_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE ;
3138: lv_attribute_category OKC_ARTICLE_VERSIONS.ATTRIBUTE_CATEGORY%TYPE;
3139: lv_attribute1 OKC_ARTICLE_VERSIONS.ATTRIBUTE1%TYPE;

Line 3136: lv_program_application_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE ;

3132: lv_orig_system_reference_id1 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
3133: lv_orig_system_reference_id2 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
3134: lv_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE ;
3135: lv_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE ;
3136: lv_program_application_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE ;
3137: lv_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE ;
3138: lv_attribute_category OKC_ARTICLE_VERSIONS.ATTRIBUTE_CATEGORY%TYPE;
3139: lv_attribute1 OKC_ARTICLE_VERSIONS.ATTRIBUTE1%TYPE;
3140: lv_attribute2 OKC_ARTICLE_VERSIONS.ATTRIBUTE2%TYPE;

Line 3137: lv_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE ;

3133: lv_orig_system_reference_id2 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
3134: lv_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE ;
3135: lv_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE ;
3136: lv_program_application_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE ;
3137: lv_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE ;
3138: lv_attribute_category OKC_ARTICLE_VERSIONS.ATTRIBUTE_CATEGORY%TYPE;
3139: lv_attribute1 OKC_ARTICLE_VERSIONS.ATTRIBUTE1%TYPE;
3140: lv_attribute2 OKC_ARTICLE_VERSIONS.ATTRIBUTE2%TYPE;
3141: lv_attribute3 OKC_ARTICLE_VERSIONS.ATTRIBUTE3%TYPE;

Line 3138: lv_attribute_category OKC_ARTICLE_VERSIONS.ATTRIBUTE_CATEGORY%TYPE;

3134: lv_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE ;
3135: lv_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE ;
3136: lv_program_application_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE ;
3137: lv_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE ;
3138: lv_attribute_category OKC_ARTICLE_VERSIONS.ATTRIBUTE_CATEGORY%TYPE;
3139: lv_attribute1 OKC_ARTICLE_VERSIONS.ATTRIBUTE1%TYPE;
3140: lv_attribute2 OKC_ARTICLE_VERSIONS.ATTRIBUTE2%TYPE;
3141: lv_attribute3 OKC_ARTICLE_VERSIONS.ATTRIBUTE3%TYPE;
3142: lv_attribute4 OKC_ARTICLE_VERSIONS.ATTRIBUTE4%TYPE;

Line 3139: lv_attribute1 OKC_ARTICLE_VERSIONS.ATTRIBUTE1%TYPE;

3135: lv_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE ;
3136: lv_program_application_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE ;
3137: lv_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE ;
3138: lv_attribute_category OKC_ARTICLE_VERSIONS.ATTRIBUTE_CATEGORY%TYPE;
3139: lv_attribute1 OKC_ARTICLE_VERSIONS.ATTRIBUTE1%TYPE;
3140: lv_attribute2 OKC_ARTICLE_VERSIONS.ATTRIBUTE2%TYPE;
3141: lv_attribute3 OKC_ARTICLE_VERSIONS.ATTRIBUTE3%TYPE;
3142: lv_attribute4 OKC_ARTICLE_VERSIONS.ATTRIBUTE4%TYPE;
3143: lv_attribute5 OKC_ARTICLE_VERSIONS.ATTRIBUTE5%TYPE;

Line 3140: lv_attribute2 OKC_ARTICLE_VERSIONS.ATTRIBUTE2%TYPE;

3136: lv_program_application_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE ;
3137: lv_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE ;
3138: lv_attribute_category OKC_ARTICLE_VERSIONS.ATTRIBUTE_CATEGORY%TYPE;
3139: lv_attribute1 OKC_ARTICLE_VERSIONS.ATTRIBUTE1%TYPE;
3140: lv_attribute2 OKC_ARTICLE_VERSIONS.ATTRIBUTE2%TYPE;
3141: lv_attribute3 OKC_ARTICLE_VERSIONS.ATTRIBUTE3%TYPE;
3142: lv_attribute4 OKC_ARTICLE_VERSIONS.ATTRIBUTE4%TYPE;
3143: lv_attribute5 OKC_ARTICLE_VERSIONS.ATTRIBUTE5%TYPE;
3144: lv_attribute6 OKC_ARTICLE_VERSIONS.ATTRIBUTE6%TYPE;

Line 3141: lv_attribute3 OKC_ARTICLE_VERSIONS.ATTRIBUTE3%TYPE;

3137: lv_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE ;
3138: lv_attribute_category OKC_ARTICLE_VERSIONS.ATTRIBUTE_CATEGORY%TYPE;
3139: lv_attribute1 OKC_ARTICLE_VERSIONS.ATTRIBUTE1%TYPE;
3140: lv_attribute2 OKC_ARTICLE_VERSIONS.ATTRIBUTE2%TYPE;
3141: lv_attribute3 OKC_ARTICLE_VERSIONS.ATTRIBUTE3%TYPE;
3142: lv_attribute4 OKC_ARTICLE_VERSIONS.ATTRIBUTE4%TYPE;
3143: lv_attribute5 OKC_ARTICLE_VERSIONS.ATTRIBUTE5%TYPE;
3144: lv_attribute6 OKC_ARTICLE_VERSIONS.ATTRIBUTE6%TYPE;
3145: lv_attribute7 OKC_ARTICLE_VERSIONS.ATTRIBUTE7%TYPE;

Line 3142: lv_attribute4 OKC_ARTICLE_VERSIONS.ATTRIBUTE4%TYPE;

3138: lv_attribute_category OKC_ARTICLE_VERSIONS.ATTRIBUTE_CATEGORY%TYPE;
3139: lv_attribute1 OKC_ARTICLE_VERSIONS.ATTRIBUTE1%TYPE;
3140: lv_attribute2 OKC_ARTICLE_VERSIONS.ATTRIBUTE2%TYPE;
3141: lv_attribute3 OKC_ARTICLE_VERSIONS.ATTRIBUTE3%TYPE;
3142: lv_attribute4 OKC_ARTICLE_VERSIONS.ATTRIBUTE4%TYPE;
3143: lv_attribute5 OKC_ARTICLE_VERSIONS.ATTRIBUTE5%TYPE;
3144: lv_attribute6 OKC_ARTICLE_VERSIONS.ATTRIBUTE6%TYPE;
3145: lv_attribute7 OKC_ARTICLE_VERSIONS.ATTRIBUTE7%TYPE;
3146: lv_attribute8 OKC_ARTICLE_VERSIONS.ATTRIBUTE8%TYPE;

Line 3143: lv_attribute5 OKC_ARTICLE_VERSIONS.ATTRIBUTE5%TYPE;

3139: lv_attribute1 OKC_ARTICLE_VERSIONS.ATTRIBUTE1%TYPE;
3140: lv_attribute2 OKC_ARTICLE_VERSIONS.ATTRIBUTE2%TYPE;
3141: lv_attribute3 OKC_ARTICLE_VERSIONS.ATTRIBUTE3%TYPE;
3142: lv_attribute4 OKC_ARTICLE_VERSIONS.ATTRIBUTE4%TYPE;
3143: lv_attribute5 OKC_ARTICLE_VERSIONS.ATTRIBUTE5%TYPE;
3144: lv_attribute6 OKC_ARTICLE_VERSIONS.ATTRIBUTE6%TYPE;
3145: lv_attribute7 OKC_ARTICLE_VERSIONS.ATTRIBUTE7%TYPE;
3146: lv_attribute8 OKC_ARTICLE_VERSIONS.ATTRIBUTE8%TYPE;
3147: lv_attribute9 OKC_ARTICLE_VERSIONS.ATTRIBUTE9%TYPE;

Line 3144: lv_attribute6 OKC_ARTICLE_VERSIONS.ATTRIBUTE6%TYPE;

3140: lv_attribute2 OKC_ARTICLE_VERSIONS.ATTRIBUTE2%TYPE;
3141: lv_attribute3 OKC_ARTICLE_VERSIONS.ATTRIBUTE3%TYPE;
3142: lv_attribute4 OKC_ARTICLE_VERSIONS.ATTRIBUTE4%TYPE;
3143: lv_attribute5 OKC_ARTICLE_VERSIONS.ATTRIBUTE5%TYPE;
3144: lv_attribute6 OKC_ARTICLE_VERSIONS.ATTRIBUTE6%TYPE;
3145: lv_attribute7 OKC_ARTICLE_VERSIONS.ATTRIBUTE7%TYPE;
3146: lv_attribute8 OKC_ARTICLE_VERSIONS.ATTRIBUTE8%TYPE;
3147: lv_attribute9 OKC_ARTICLE_VERSIONS.ATTRIBUTE9%TYPE;
3148: lv_attribute10 OKC_ARTICLE_VERSIONS.ATTRIBUTE10%TYPE;

Line 3145: lv_attribute7 OKC_ARTICLE_VERSIONS.ATTRIBUTE7%TYPE;

3141: lv_attribute3 OKC_ARTICLE_VERSIONS.ATTRIBUTE3%TYPE;
3142: lv_attribute4 OKC_ARTICLE_VERSIONS.ATTRIBUTE4%TYPE;
3143: lv_attribute5 OKC_ARTICLE_VERSIONS.ATTRIBUTE5%TYPE;
3144: lv_attribute6 OKC_ARTICLE_VERSIONS.ATTRIBUTE6%TYPE;
3145: lv_attribute7 OKC_ARTICLE_VERSIONS.ATTRIBUTE7%TYPE;
3146: lv_attribute8 OKC_ARTICLE_VERSIONS.ATTRIBUTE8%TYPE;
3147: lv_attribute9 OKC_ARTICLE_VERSIONS.ATTRIBUTE9%TYPE;
3148: lv_attribute10 OKC_ARTICLE_VERSIONS.ATTRIBUTE10%TYPE;
3149: lv_attribute11 OKC_ARTICLE_VERSIONS.ATTRIBUTE11%TYPE;

Line 3146: lv_attribute8 OKC_ARTICLE_VERSIONS.ATTRIBUTE8%TYPE;

3142: lv_attribute4 OKC_ARTICLE_VERSIONS.ATTRIBUTE4%TYPE;
3143: lv_attribute5 OKC_ARTICLE_VERSIONS.ATTRIBUTE5%TYPE;
3144: lv_attribute6 OKC_ARTICLE_VERSIONS.ATTRIBUTE6%TYPE;
3145: lv_attribute7 OKC_ARTICLE_VERSIONS.ATTRIBUTE7%TYPE;
3146: lv_attribute8 OKC_ARTICLE_VERSIONS.ATTRIBUTE8%TYPE;
3147: lv_attribute9 OKC_ARTICLE_VERSIONS.ATTRIBUTE9%TYPE;
3148: lv_attribute10 OKC_ARTICLE_VERSIONS.ATTRIBUTE10%TYPE;
3149: lv_attribute11 OKC_ARTICLE_VERSIONS.ATTRIBUTE11%TYPE;
3150: lv_attribute12 OKC_ARTICLE_VERSIONS.ATTRIBUTE12%TYPE;

Line 3147: lv_attribute9 OKC_ARTICLE_VERSIONS.ATTRIBUTE9%TYPE;

3143: lv_attribute5 OKC_ARTICLE_VERSIONS.ATTRIBUTE5%TYPE;
3144: lv_attribute6 OKC_ARTICLE_VERSIONS.ATTRIBUTE6%TYPE;
3145: lv_attribute7 OKC_ARTICLE_VERSIONS.ATTRIBUTE7%TYPE;
3146: lv_attribute8 OKC_ARTICLE_VERSIONS.ATTRIBUTE8%TYPE;
3147: lv_attribute9 OKC_ARTICLE_VERSIONS.ATTRIBUTE9%TYPE;
3148: lv_attribute10 OKC_ARTICLE_VERSIONS.ATTRIBUTE10%TYPE;
3149: lv_attribute11 OKC_ARTICLE_VERSIONS.ATTRIBUTE11%TYPE;
3150: lv_attribute12 OKC_ARTICLE_VERSIONS.ATTRIBUTE12%TYPE;
3151: lv_attribute13 OKC_ARTICLE_VERSIONS.ATTRIBUTE13%TYPE;

Line 3148: lv_attribute10 OKC_ARTICLE_VERSIONS.ATTRIBUTE10%TYPE;

3144: lv_attribute6 OKC_ARTICLE_VERSIONS.ATTRIBUTE6%TYPE;
3145: lv_attribute7 OKC_ARTICLE_VERSIONS.ATTRIBUTE7%TYPE;
3146: lv_attribute8 OKC_ARTICLE_VERSIONS.ATTRIBUTE8%TYPE;
3147: lv_attribute9 OKC_ARTICLE_VERSIONS.ATTRIBUTE9%TYPE;
3148: lv_attribute10 OKC_ARTICLE_VERSIONS.ATTRIBUTE10%TYPE;
3149: lv_attribute11 OKC_ARTICLE_VERSIONS.ATTRIBUTE11%TYPE;
3150: lv_attribute12 OKC_ARTICLE_VERSIONS.ATTRIBUTE12%TYPE;
3151: lv_attribute13 OKC_ARTICLE_VERSIONS.ATTRIBUTE13%TYPE;
3152: lv_attribute14 OKC_ARTICLE_VERSIONS.ATTRIBUTE14%TYPE;

Line 3149: lv_attribute11 OKC_ARTICLE_VERSIONS.ATTRIBUTE11%TYPE;

3145: lv_attribute7 OKC_ARTICLE_VERSIONS.ATTRIBUTE7%TYPE;
3146: lv_attribute8 OKC_ARTICLE_VERSIONS.ATTRIBUTE8%TYPE;
3147: lv_attribute9 OKC_ARTICLE_VERSIONS.ATTRIBUTE9%TYPE;
3148: lv_attribute10 OKC_ARTICLE_VERSIONS.ATTRIBUTE10%TYPE;
3149: lv_attribute11 OKC_ARTICLE_VERSIONS.ATTRIBUTE11%TYPE;
3150: lv_attribute12 OKC_ARTICLE_VERSIONS.ATTRIBUTE12%TYPE;
3151: lv_attribute13 OKC_ARTICLE_VERSIONS.ATTRIBUTE13%TYPE;
3152: lv_attribute14 OKC_ARTICLE_VERSIONS.ATTRIBUTE14%TYPE;
3153: lv_attribute15 OKC_ARTICLE_VERSIONS.ATTRIBUTE15%TYPE;

Line 3150: lv_attribute12 OKC_ARTICLE_VERSIONS.ATTRIBUTE12%TYPE;

3146: lv_attribute8 OKC_ARTICLE_VERSIONS.ATTRIBUTE8%TYPE;
3147: lv_attribute9 OKC_ARTICLE_VERSIONS.ATTRIBUTE9%TYPE;
3148: lv_attribute10 OKC_ARTICLE_VERSIONS.ATTRIBUTE10%TYPE;
3149: lv_attribute11 OKC_ARTICLE_VERSIONS.ATTRIBUTE11%TYPE;
3150: lv_attribute12 OKC_ARTICLE_VERSIONS.ATTRIBUTE12%TYPE;
3151: lv_attribute13 OKC_ARTICLE_VERSIONS.ATTRIBUTE13%TYPE;
3152: lv_attribute14 OKC_ARTICLE_VERSIONS.ATTRIBUTE14%TYPE;
3153: lv_attribute15 OKC_ARTICLE_VERSIONS.ATTRIBUTE15%TYPE;
3154: lv_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;

Line 3151: lv_attribute13 OKC_ARTICLE_VERSIONS.ATTRIBUTE13%TYPE;

3147: lv_attribute9 OKC_ARTICLE_VERSIONS.ATTRIBUTE9%TYPE;
3148: lv_attribute10 OKC_ARTICLE_VERSIONS.ATTRIBUTE10%TYPE;
3149: lv_attribute11 OKC_ARTICLE_VERSIONS.ATTRIBUTE11%TYPE;
3150: lv_attribute12 OKC_ARTICLE_VERSIONS.ATTRIBUTE12%TYPE;
3151: lv_attribute13 OKC_ARTICLE_VERSIONS.ATTRIBUTE13%TYPE;
3152: lv_attribute14 OKC_ARTICLE_VERSIONS.ATTRIBUTE14%TYPE;
3153: lv_attribute15 OKC_ARTICLE_VERSIONS.ATTRIBUTE15%TYPE;
3154: lv_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
3155: lv_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;

Line 3152: lv_attribute14 OKC_ARTICLE_VERSIONS.ATTRIBUTE14%TYPE;

3148: lv_attribute10 OKC_ARTICLE_VERSIONS.ATTRIBUTE10%TYPE;
3149: lv_attribute11 OKC_ARTICLE_VERSIONS.ATTRIBUTE11%TYPE;
3150: lv_attribute12 OKC_ARTICLE_VERSIONS.ATTRIBUTE12%TYPE;
3151: lv_attribute13 OKC_ARTICLE_VERSIONS.ATTRIBUTE13%TYPE;
3152: lv_attribute14 OKC_ARTICLE_VERSIONS.ATTRIBUTE14%TYPE;
3153: lv_attribute15 OKC_ARTICLE_VERSIONS.ATTRIBUTE15%TYPE;
3154: lv_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
3155: lv_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
3156: lv_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;

Line 3153: lv_attribute15 OKC_ARTICLE_VERSIONS.ATTRIBUTE15%TYPE;

3149: lv_attribute11 OKC_ARTICLE_VERSIONS.ATTRIBUTE11%TYPE;
3150: lv_attribute12 OKC_ARTICLE_VERSIONS.ATTRIBUTE12%TYPE;
3151: lv_attribute13 OKC_ARTICLE_VERSIONS.ATTRIBUTE13%TYPE;
3152: lv_attribute14 OKC_ARTICLE_VERSIONS.ATTRIBUTE14%TYPE;
3153: lv_attribute15 OKC_ARTICLE_VERSIONS.ATTRIBUTE15%TYPE;
3154: lv_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
3155: lv_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
3156: lv_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;
3157: lv_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;

Line 3154: lv_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;

3150: lv_attribute12 OKC_ARTICLE_VERSIONS.ATTRIBUTE12%TYPE;
3151: lv_attribute13 OKC_ARTICLE_VERSIONS.ATTRIBUTE13%TYPE;
3152: lv_attribute14 OKC_ARTICLE_VERSIONS.ATTRIBUTE14%TYPE;
3153: lv_attribute15 OKC_ARTICLE_VERSIONS.ATTRIBUTE15%TYPE;
3154: lv_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
3155: lv_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
3156: lv_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;
3157: lv_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
3158: lv_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;

Line 3155: lv_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;

3151: lv_attribute13 OKC_ARTICLE_VERSIONS.ATTRIBUTE13%TYPE;
3152: lv_attribute14 OKC_ARTICLE_VERSIONS.ATTRIBUTE14%TYPE;
3153: lv_attribute15 OKC_ARTICLE_VERSIONS.ATTRIBUTE15%TYPE;
3154: lv_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
3155: lv_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
3156: lv_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;
3157: lv_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
3158: lv_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
3159:

Line 3156: lv_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;

3152: lv_attribute14 OKC_ARTICLE_VERSIONS.ATTRIBUTE14%TYPE;
3153: lv_attribute15 OKC_ARTICLE_VERSIONS.ATTRIBUTE15%TYPE;
3154: lv_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
3155: lv_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
3156: lv_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;
3157: lv_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
3158: lv_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
3159:
3160: l_p_standard_yn VARCHAR2(1);

Line 3157: lv_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;

3153: lv_attribute15 OKC_ARTICLE_VERSIONS.ATTRIBUTE15%TYPE;
3154: lv_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
3155: lv_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
3156: lv_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;
3157: lv_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
3158: lv_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
3159:
3160: l_p_standard_yn VARCHAR2(1);
3161: l_p_article_id NUMBER;

Line 3158: lv_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;

3154: lv_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
3155: lv_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
3156: lv_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;
3157: lv_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
3158: lv_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
3159:
3160: l_p_standard_yn VARCHAR2(1);
3161: l_p_article_id NUMBER;
3162: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;

Line 3167: l_earlier_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;

3163: l_api_version CONSTANT NUMBER := 1;
3164: l_api_name CONSTANT VARCHAR2(30) := 'g_copy_article';
3165: l_p_org_id NUMBER;
3166: l_earlier_version_id NUMBER;
3167: l_earlier_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
3168: -- TYPE l_source_article_id_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.SOURCE_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
3169: TYPE l_target_article_id_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.TARGET_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
3170: TYPE l_relationship_type_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.RELATIONSHIP_TYPE%TYPE INDEX BY BINARY_INTEGER ;
3171:

Line 3179: FROM OKC_ARTICLES_ALL aa,OKC_ARTICLE_VERSIONS av

3175: i NUMBER := 0;
3176:
3177: CURSOR l_article_csr (cp_article_version_id IN NUMBER) is
3178: SELECT aa.standard_yn,av.article_id
3179: FROM OKC_ARTICLES_ALL aa,OKC_ARTICLE_VERSIONS av
3180: WHERE aa.ARTICLE_ID = av.ARTICLE_ID
3181: AND av.ARTICLE_VERSION_ID = cp_article_version_id;
3182:
3183: CURSOR l_relationship_csr (cp_article_id IN NUMBER,

Line 3284: l_return_status := OKC_ARTICLE_VERSIONS_PVT.Get_Rec(

3280:
3281: IF( p_article_version_id IS NOT NULL ) THEN
3282: -- Get current database values for article version
3283: --dbms_output.put_line('l_return_status is2 '||l_return_status);
3284: l_return_status := OKC_ARTICLE_VERSIONS_PVT.Get_Rec(
3285: p_article_version_id => p_article_version_id,
3286: x_article_id => lv_article_id,
3287: x_article_version_number => lv_article_version_number,
3288: x_article_text => lv_article_text,

Line 3447: OKC_ARTICLE_VERSIONS_PVT.Insert_Row(

3443: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3444: RAISE FND_API.G_EXC_ERROR ;
3445: END IF;
3446: --------------------------------------------
3447: OKC_ARTICLE_VERSIONS_PVT.Insert_Row(
3448: p_validation_level => p_validation_level,
3449: x_return_status => x_return_status,
3450: p_article_id => x_article_id,
3451: p_article_text => lv_article_text,

Line 3710: OKC_ARTICLE_VERSIONS V1 ,

3706: ) IS
3707: CURSOR l_local_article_csr(cp_article_id IN NUMBER,
3708: cp_local_org_id IN NUMBER) IS
3709: SELECT V2.article_id FROM OKC_ARTICLE_ADOPTIONS AA,
3710: OKC_ARTICLE_VERSIONS V1 ,
3711: OKC_ARTICLE_VERSIONS V2
3712: WHERE V1.ARTICLE_VERSION_ID = AA.GLOBAL_ARTICLE_VERSION_ID
3713: AND V2.ARTICLE_VERSION_ID = AA.LOCAL_ARTICLE_VERSION_ID
3714: AND V1.ARTICLE_ID = cp_article_id

Line 3711: OKC_ARTICLE_VERSIONS V2

3707: CURSOR l_local_article_csr(cp_article_id IN NUMBER,
3708: cp_local_org_id IN NUMBER) IS
3709: SELECT V2.article_id FROM OKC_ARTICLE_ADOPTIONS AA,
3710: OKC_ARTICLE_VERSIONS V1 ,
3711: OKC_ARTICLE_VERSIONS V2
3712: WHERE V1.ARTICLE_VERSION_ID = AA.GLOBAL_ARTICLE_VERSION_ID
3713: AND V2.ARTICLE_VERSION_ID = AA.LOCAL_ARTICLE_VERSION_ID
3714: AND V1.ARTICLE_ID = cp_article_id
3715: AND AA.LOCAL_ORG_ID = cp_local_org_id

Line 3722: OKC_ARTICLE_VERSIONS V1

3718: AND NVL(V2.END_DATE, SYSDATE+1) > SYSDATE
3719: AND rownum < 2
3720: UNION ALL
3721: SELECT V1.article_id FROM OKC_ARTICLE_ADOPTIONS AA,
3722: OKC_ARTICLE_VERSIONS V1
3723: WHERE V1.ARTICLE_VERSION_ID = AA.GLOBAL_ARTICLE_VERSION_ID
3724: AND V1.ARTICLE_ID = cp_article_id
3725: AND AA.LOCAL_ORG_ID = cp_local_org_id
3726: AND AA.ADOPTION_TYPE = 'ADOPTED'

Line 3811: OKC_ARTICLE_VERSIONS V1,

3807: CURSOR l_local_article_csr(cp_src_article_id IN NUMBER,
3808: cp_tar_article_id IN NUMBER,
3809: cp_local_org_id IN NUMBER) IS
3810: SELECT '1' FROM OKC_ARTICLE_ADOPTIONS AA1,
3811: OKC_ARTICLE_VERSIONS V1,
3812: OKC_ARTICLE_ADOPTIONS AA2,
3813: OKC_ARTICLE_VERSIONS V2
3814: WHERE V1.ARTICLE_VERSION_ID = AA1.GLOBAL_ARTICLE_VERSION_ID
3815: AND V1.ARTICLE_ID = cp_src_article_id

Line 3813: OKC_ARTICLE_VERSIONS V2

3809: cp_local_org_id IN NUMBER) IS
3810: SELECT '1' FROM OKC_ARTICLE_ADOPTIONS AA1,
3811: OKC_ARTICLE_VERSIONS V1,
3812: OKC_ARTICLE_ADOPTIONS AA2,
3813: OKC_ARTICLE_VERSIONS V2
3814: WHERE V1.ARTICLE_VERSION_ID = AA1.GLOBAL_ARTICLE_VERSION_ID
3815: AND V1.ARTICLE_ID = cp_src_article_id
3816: AND AA1.LOCAL_ORG_ID = cp_local_org_id
3817: AND AA1.ADOPTION_TYPE = 'ADOPTED'

Line 3918: (SELECT 1 FROM OKC_ARTICLE_VERSIONS V

3914: FROM OKC_ARTICLES_ALL A, OKC_ARTICLES_ALL B
3915: WHERE A.ARTICLE_ID = cp_src_global_article_id
3916: AND B.ARTICLE_ID = cp_tar_global_article_id
3917: AND EXISTS
3918: (SELECT 1 FROM OKC_ARTICLE_VERSIONS V
3919: WHERE V.ARTICLE_ID = B.ARTICLE_ID
3920: AND V.GLOBAL_YN = 'Y'
3921: AND V.ARTICLE_STATUS = 'APPROVED'
3922: AND NVL(V.END_DATE,SYSDATE + 1) > SYSDATE

Line 3925: (SELECT 1 FROM OKC_ARTICLE_VERSIONS V1

3921: AND V.ARTICLE_STATUS = 'APPROVED'
3922: AND NVL(V.END_DATE,SYSDATE + 1) > SYSDATE
3923: )
3924: AND EXISTS
3925: (SELECT 1 FROM OKC_ARTICLE_VERSIONS V1
3926: WHERE V1.ARTICLE_ID = A.ARTICLE_ID
3927: AND V1.GLOBAL_YN = 'Y'
3928: AND V1.ARTICLE_STATUS = 'APPROVED'
3929: AND NVL(V1.END_DATE,SYSDATE + 1) > SYSDATE

Line 4525: okc_article_versions av

4521: cp_start_date IN DATE) IS
4522: select
4523: 'Y'
4524: from
4525: okc_article_versions av
4526: where
4527: av.article_id = cp_article_id and
4528: av.start_date > cp_start_date and
4529: av.article_status in ( 'APPROVED', 'HOLD') and