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 868: OKC_ARTICLE_VERSIONS_PVT.Delete_Row(

864:
865: --------------------------------------------
866: -- Calling Simple API for Deleting A Row
867: --------------------------------------------
868: OKC_ARTICLE_VERSIONS_PVT.Delete_Row(
869: x_return_status => x_return_status,
870: p_article_version_id => p_article_version_id,
871: p_object_version_number => p_object_version_number
872: );

Line 1039: l_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;

1035: ) IS
1036: l_api_version CONSTANT NUMBER := 1;
1037: l_api_name CONSTANT VARCHAR2(30) := 'g_validate_article';
1038: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1039: l_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
1040:
1041: BEGIN
1042:
1043: IF (l_debug = 'Y') THEN

Line 1094: OKC_ARTICLE_VERSIONS_PVT.Validate_Row(

1090: l_article_status := 'APPROVED';
1091: ELSE
1092: l_article_status := p_article_status;
1093: END IF;
1094: OKC_ARTICLE_VERSIONS_PVT.Validate_Row(
1095: p_validation_level => p_validation_level,
1096: p_import_action => p_import_action,
1097: x_return_status => x_return_status,
1098: x_earlier_adoption_type => x_earlier_adoption_type,

Line 1865: l_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;

1861: l_api_name CONSTANT VARCHAR2(30) := 'g_delete_article';
1862: l_status VARCHAR2(30) ;
1863: l_standard_yn VARCHAR2(1) ;
1864: l_only_version VARCHAR2(1) := 'T';
1865: l_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
1866: l_dummy1 VARCHAR2(1) := '?';
1867:
1868: Cursor l_status_csr (cp_article_id IN NUMBER,
1869: cp_article_version_id IN NUMBER) IS

Line 1871: FROM okc_article_versions av,okc_articles_all aa

1867:
1868: Cursor l_status_csr (cp_article_id IN NUMBER,
1869: cp_article_version_id IN NUMBER) IS
1870: SELECT article_status,standard_yn, adoption_type
1871: FROM okc_article_versions av,okc_articles_all aa
1872: WHERE aa.article_id = av.article_id
1873: AND av.article_id = cp_article_id
1874: AND av.article_version_id = cp_article_version_id;
1875:

Line 1880: FROM OKC_ARTICLE_VERSIONS A

1876:
1877: CURSOR l_only_version_csr(cp_article_id IN NUMBER,
1878: cp_article_version_id IN NUMBER) IS
1879: SELECT 'F'
1880: FROM OKC_ARTICLE_VERSIONS A
1881: WHERE A.ARTICLE_ID = cp_article_id
1882: AND A.ARTICLE_VERSION_ID <> cp_article_version_id
1883: AND rownum < 2 ;
1884:

Line 2135: l_earlier_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;

2131: p_variable_code IN VARCHAR2 DEFAULT NULL
2132: ) IS
2133: l_api_version CONSTANT NUMBER := 1;
2134: l_api_name CONSTANT VARCHAR2(30) := 'g_validate_article_version';
2135: l_earlier_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
2136:
2137: BEGIN
2138:
2139: IF (l_debug = 'Y') THEN

Line 2159: OKC_ARTICLE_VERSIONS_PVT.Validate_Row(

2155:
2156: --------------------------------------------
2157: -- Calling Simple API for Article Version Validation
2158: --------------------------------------------
2159: OKC_ARTICLE_VERSIONS_PVT.Validate_Row(
2160: p_validation_level => p_validation_level,
2161: p_import_action => p_import_action,
2162: x_return_status => x_return_status,
2163: x_earlier_adoption_type => x_earlier_adoption_type,

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

2328: ) IS
2329:
2330: l_api_version CONSTANT NUMBER := 1;
2331: l_api_name CONSTANT VARCHAR2(30) := 'g_create_article_version';
2332: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE := 1;
2333: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
2334: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
2335: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
2336: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;

Line 2333: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;

2329:
2330: l_api_version CONSTANT NUMBER := 1;
2331: l_api_name CONSTANT VARCHAR2(30) := 'g_create_article_version';
2332: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE := 1;
2333: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
2334: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
2335: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
2336: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
2337: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;

Line 2334: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;

2330: l_api_version CONSTANT NUMBER := 1;
2331: l_api_name CONSTANT VARCHAR2(30) := 'g_create_article_version';
2332: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE := 1;
2333: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
2334: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
2335: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
2336: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
2337: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;
2338: l_adoption_type OKC_ARTICLE_ADOPTIONS.ADOPTION_TYPE%TYPE;

Line 2335: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;

2331: l_api_name CONSTANT VARCHAR2(30) := 'g_create_article_version';
2332: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE := 1;
2333: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
2334: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
2335: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
2336: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
2337: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;
2338: l_adoption_type OKC_ARTICLE_ADOPTIONS.ADOPTION_TYPE%TYPE;
2339: l_earlier_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;

Line 2336: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;

2332: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE := 1;
2333: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
2334: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
2335: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
2336: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
2337: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;
2338: l_adoption_type OKC_ARTICLE_ADOPTIONS.ADOPTION_TYPE%TYPE;
2339: l_earlier_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
2340: l_variable_code_tbl variable_code_tbl_type;

Line 2337: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;

2333: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
2334: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
2335: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
2336: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
2337: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;
2338: l_adoption_type OKC_ARTICLE_ADOPTIONS.ADOPTION_TYPE%TYPE;
2339: l_earlier_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
2340: l_variable_code_tbl variable_code_tbl_type;
2341: l_org_id NUMBER;

Line 2339: l_earlier_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;

2335: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
2336: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
2337: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;
2338: l_adoption_type OKC_ARTICLE_ADOPTIONS.ADOPTION_TYPE%TYPE;
2339: l_earlier_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
2340: l_variable_code_tbl variable_code_tbl_type;
2341: l_org_id NUMBER;
2342: l_global_article_version_id NUMBER;
2343: l_global_version_id_out NUMBER;

Line 2350: l_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;

2346: l_earlier_version_id NUMBER;
2347: l_row_notfound BOOLEAN := TRUE;
2348: l_rowid ROWID;
2349: l_article_text CLOB;
2350: l_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
2351: i NUMBER := 0;
2352: l_clob CLOB;
2353: -- Bug 3917777
2354: l_user_id NUMBER := FND_GLOBAL.USER_ID;

Line 2422: OKC_ARTICLE_VERSIONS_PVT.Insert_Row(

2418:
2419: --------------------------------------------
2420: -- Calling Simple API for Creating A Row
2421: --------------------------------------------
2422: OKC_ARTICLE_VERSIONS_PVT.Insert_Row(
2423: p_validation_level => p_validation_level,
2424: x_return_status => x_return_status,
2425: p_article_id => p_article_id,
2426: p_article_text => l_clob,

Line 2563: UPDATE OKC_ARTICLE_VERSIONS

2559:
2560: -- Update denormalized adoption type in article versions table
2561: -- No need to call the update API as the row is still locked and it will be an overhead
2562:
2563: UPDATE OKC_ARTICLE_VERSIONS
2564: SET adoption_type = nvl(l_adoption_type, 'LOCAL')
2565: WHERE article_version_id = x_article_version_id;
2566: END IF;
2567:

Line 2689: OKC_ARTICLE_VERSIONS_PVT.lock_row(

2685:
2686: --------------------------------------------
2687: -- Calling Simple API for Locking A Row
2688: --------------------------------------------
2689: OKC_ARTICLE_VERSIONS_PVT.lock_row(
2690: x_return_status => x_return_status,
2691: p_article_version_id => p_article_version_id,
2692: p_object_version_number => p_object_version_number
2693: );

Line 2931: l_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;

2927: l_api_name CONSTANT VARCHAR2(30) := 'g_update_article_version';
2928: l_earlier_version_id NUMBER;
2929: l_article_id NUMBER;
2930: l_article_text CLOB;
2931: l_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
2932: l_variable_code_tbl variable_code_tbl_type;
2933: l_variables_to_insert_tbl variable_code_tbl_type;
2934: l_variables_to_delete_tbl variable_code_tbl_type;
2935: l_clob CLOB;

Line 3025: OKC_ARTICLE_VERSIONS_PVT.Update_Row(

3021: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_NULL_ORG_ID');
3022: RAISE FND_API.G_EXC_ERROR ;
3023: END IF;
3024:
3025: OKC_ARTICLE_VERSIONS_PVT.Update_Row(
3026: p_validation_level => p_validation_level,
3027: x_return_status => x_return_status,
3028: p_article_version_id => p_article_version_id,
3029: p_article_id => p_article_id,

Line 3218: lv_article_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE ;

3214: l_last_updated_by OKC_ARTICLES_ALL.LAST_UPDATED_BY%TYPE;
3215: l_last_update_login OKC_ARTICLES_ALL.LAST_UPDATE_LOGIN%TYPE;
3216:
3217: -- Article Version Attributes
3218: lv_article_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE ;
3219: lv_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE ;
3220: lv_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE ;
3221: lv_article_id OKC_ARTICLE_VERSIONS.ARTICLE_ID%TYPE ;
3222: lv_article_text OKC_ARTICLE_VERSIONS.ARTICLE_TEXT%TYPE;

Line 3219: lv_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE ;

3215: l_last_update_login OKC_ARTICLES_ALL.LAST_UPDATE_LOGIN%TYPE;
3216:
3217: -- Article Version Attributes
3218: lv_article_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE ;
3219: lv_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE ;
3220: lv_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE ;
3221: lv_article_id OKC_ARTICLE_VERSIONS.ARTICLE_ID%TYPE ;
3222: lv_article_text OKC_ARTICLE_VERSIONS.ARTICLE_TEXT%TYPE;
3223: lv_provision_yn OKC_ARTICLE_VERSIONS.PROVISION_YN%TYPE;

Line 3220: lv_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE ;

3216:
3217: -- Article Version Attributes
3218: lv_article_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE ;
3219: lv_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE ;
3220: lv_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE ;
3221: lv_article_id OKC_ARTICLE_VERSIONS.ARTICLE_ID%TYPE ;
3222: lv_article_text OKC_ARTICLE_VERSIONS.ARTICLE_TEXT%TYPE;
3223: lv_provision_yn OKC_ARTICLE_VERSIONS.PROVISION_YN%TYPE;
3224: lv_insert_by_reference OKC_ARTICLE_VERSIONS.INSERT_BY_REFERENCE%TYPE;

Line 3221: lv_article_id OKC_ARTICLE_VERSIONS.ARTICLE_ID%TYPE ;

3217: -- Article Version Attributes
3218: lv_article_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE ;
3219: lv_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE ;
3220: lv_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE ;
3221: lv_article_id OKC_ARTICLE_VERSIONS.ARTICLE_ID%TYPE ;
3222: lv_article_text OKC_ARTICLE_VERSIONS.ARTICLE_TEXT%TYPE;
3223: lv_provision_yn OKC_ARTICLE_VERSIONS.PROVISION_YN%TYPE;
3224: lv_insert_by_reference OKC_ARTICLE_VERSIONS.INSERT_BY_REFERENCE%TYPE;
3225: lv_lock_text OKC_ARTICLE_VERSIONS.LOCK_TEXT%TYPE;

Line 3222: lv_article_text OKC_ARTICLE_VERSIONS.ARTICLE_TEXT%TYPE;

3218: lv_article_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE ;
3219: lv_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE ;
3220: lv_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE ;
3221: lv_article_id OKC_ARTICLE_VERSIONS.ARTICLE_ID%TYPE ;
3222: lv_article_text OKC_ARTICLE_VERSIONS.ARTICLE_TEXT%TYPE;
3223: lv_provision_yn OKC_ARTICLE_VERSIONS.PROVISION_YN%TYPE;
3224: lv_insert_by_reference OKC_ARTICLE_VERSIONS.INSERT_BY_REFERENCE%TYPE;
3225: lv_lock_text OKC_ARTICLE_VERSIONS.LOCK_TEXT%TYPE;
3226: lv_global_yn OKC_ARTICLE_VERSIONS.GLOBAL_YN%TYPE;

Line 3223: lv_provision_yn OKC_ARTICLE_VERSIONS.PROVISION_YN%TYPE;

3219: lv_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE ;
3220: lv_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE ;
3221: lv_article_id OKC_ARTICLE_VERSIONS.ARTICLE_ID%TYPE ;
3222: lv_article_text OKC_ARTICLE_VERSIONS.ARTICLE_TEXT%TYPE;
3223: lv_provision_yn OKC_ARTICLE_VERSIONS.PROVISION_YN%TYPE;
3224: lv_insert_by_reference OKC_ARTICLE_VERSIONS.INSERT_BY_REFERENCE%TYPE;
3225: lv_lock_text OKC_ARTICLE_VERSIONS.LOCK_TEXT%TYPE;
3226: lv_global_yn OKC_ARTICLE_VERSIONS.GLOBAL_YN%TYPE;
3227: lv_article_language OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE ;

Line 3224: lv_insert_by_reference OKC_ARTICLE_VERSIONS.INSERT_BY_REFERENCE%TYPE;

3220: lv_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE ;
3221: lv_article_id OKC_ARTICLE_VERSIONS.ARTICLE_ID%TYPE ;
3222: lv_article_text OKC_ARTICLE_VERSIONS.ARTICLE_TEXT%TYPE;
3223: lv_provision_yn OKC_ARTICLE_VERSIONS.PROVISION_YN%TYPE;
3224: lv_insert_by_reference OKC_ARTICLE_VERSIONS.INSERT_BY_REFERENCE%TYPE;
3225: lv_lock_text OKC_ARTICLE_VERSIONS.LOCK_TEXT%TYPE;
3226: lv_global_yn OKC_ARTICLE_VERSIONS.GLOBAL_YN%TYPE;
3227: lv_article_language OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE ;
3228: lv_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;

Line 3225: lv_lock_text OKC_ARTICLE_VERSIONS.LOCK_TEXT%TYPE;

3221: lv_article_id OKC_ARTICLE_VERSIONS.ARTICLE_ID%TYPE ;
3222: lv_article_text OKC_ARTICLE_VERSIONS.ARTICLE_TEXT%TYPE;
3223: lv_provision_yn OKC_ARTICLE_VERSIONS.PROVISION_YN%TYPE;
3224: lv_insert_by_reference OKC_ARTICLE_VERSIONS.INSERT_BY_REFERENCE%TYPE;
3225: lv_lock_text OKC_ARTICLE_VERSIONS.LOCK_TEXT%TYPE;
3226: lv_global_yn OKC_ARTICLE_VERSIONS.GLOBAL_YN%TYPE;
3227: lv_article_language OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE ;
3228: lv_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
3229: lv_sav_release OKC_ARTICLE_VERSIONS.SAV_RELEASE%TYPE;

Line 3226: lv_global_yn OKC_ARTICLE_VERSIONS.GLOBAL_YN%TYPE;

3222: lv_article_text OKC_ARTICLE_VERSIONS.ARTICLE_TEXT%TYPE;
3223: lv_provision_yn OKC_ARTICLE_VERSIONS.PROVISION_YN%TYPE;
3224: lv_insert_by_reference OKC_ARTICLE_VERSIONS.INSERT_BY_REFERENCE%TYPE;
3225: lv_lock_text OKC_ARTICLE_VERSIONS.LOCK_TEXT%TYPE;
3226: lv_global_yn OKC_ARTICLE_VERSIONS.GLOBAL_YN%TYPE;
3227: lv_article_language OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE ;
3228: lv_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
3229: lv_sav_release OKC_ARTICLE_VERSIONS.SAV_RELEASE%TYPE;
3230: lv_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE ;

Line 3227: lv_article_language OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE ;

3223: lv_provision_yn OKC_ARTICLE_VERSIONS.PROVISION_YN%TYPE;
3224: lv_insert_by_reference OKC_ARTICLE_VERSIONS.INSERT_BY_REFERENCE%TYPE;
3225: lv_lock_text OKC_ARTICLE_VERSIONS.LOCK_TEXT%TYPE;
3226: lv_global_yn OKC_ARTICLE_VERSIONS.GLOBAL_YN%TYPE;
3227: lv_article_language OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE ;
3228: lv_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
3229: lv_sav_release OKC_ARTICLE_VERSIONS.SAV_RELEASE%TYPE;
3230: lv_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE ;
3231: lv_end_date OKC_ARTICLE_VERSIONS.END_DATE%TYPE;

Line 3228: lv_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;

3224: lv_insert_by_reference OKC_ARTICLE_VERSIONS.INSERT_BY_REFERENCE%TYPE;
3225: lv_lock_text OKC_ARTICLE_VERSIONS.LOCK_TEXT%TYPE;
3226: lv_global_yn OKC_ARTICLE_VERSIONS.GLOBAL_YN%TYPE;
3227: lv_article_language OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE ;
3228: lv_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
3229: lv_sav_release OKC_ARTICLE_VERSIONS.SAV_RELEASE%TYPE;
3230: lv_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE ;
3231: lv_end_date OKC_ARTICLE_VERSIONS.END_DATE%TYPE;
3232: lv_std_article_version_id OKC_ARTICLE_VERSIONS.STD_ARTICLE_VERSION_ID%TYPE ;

Line 3229: lv_sav_release OKC_ARTICLE_VERSIONS.SAV_RELEASE%TYPE;

3225: lv_lock_text OKC_ARTICLE_VERSIONS.LOCK_TEXT%TYPE;
3226: lv_global_yn OKC_ARTICLE_VERSIONS.GLOBAL_YN%TYPE;
3227: lv_article_language OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE ;
3228: lv_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
3229: lv_sav_release OKC_ARTICLE_VERSIONS.SAV_RELEASE%TYPE;
3230: lv_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE ;
3231: lv_end_date OKC_ARTICLE_VERSIONS.END_DATE%TYPE;
3232: lv_std_article_version_id OKC_ARTICLE_VERSIONS.STD_ARTICLE_VERSION_ID%TYPE ;
3233: lv_display_name OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE;

Line 3230: lv_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE ;

3226: lv_global_yn OKC_ARTICLE_VERSIONS.GLOBAL_YN%TYPE;
3227: lv_article_language OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE ;
3228: lv_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
3229: lv_sav_release OKC_ARTICLE_VERSIONS.SAV_RELEASE%TYPE;
3230: lv_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE ;
3231: lv_end_date OKC_ARTICLE_VERSIONS.END_DATE%TYPE;
3232: lv_std_article_version_id OKC_ARTICLE_VERSIONS.STD_ARTICLE_VERSION_ID%TYPE ;
3233: lv_display_name OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE;
3234: lv_translated_yn OKC_ARTICLE_VERSIONS.TRANSLATED_YN%TYPE;

Line 3231: lv_end_date OKC_ARTICLE_VERSIONS.END_DATE%TYPE;

3227: lv_article_language OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE ;
3228: lv_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
3229: lv_sav_release OKC_ARTICLE_VERSIONS.SAV_RELEASE%TYPE;
3230: lv_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE ;
3231: lv_end_date OKC_ARTICLE_VERSIONS.END_DATE%TYPE;
3232: lv_std_article_version_id OKC_ARTICLE_VERSIONS.STD_ARTICLE_VERSION_ID%TYPE ;
3233: lv_display_name OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE;
3234: lv_translated_yn OKC_ARTICLE_VERSIONS.TRANSLATED_YN%TYPE;
3235: lv_article_description OKC_ARTICLE_VERSIONS.ARTICLE_DESCRIPTION%TYPE;

Line 3232: lv_std_article_version_id OKC_ARTICLE_VERSIONS.STD_ARTICLE_VERSION_ID%TYPE ;

3228: lv_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
3229: lv_sav_release OKC_ARTICLE_VERSIONS.SAV_RELEASE%TYPE;
3230: lv_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE ;
3231: lv_end_date OKC_ARTICLE_VERSIONS.END_DATE%TYPE;
3232: lv_std_article_version_id OKC_ARTICLE_VERSIONS.STD_ARTICLE_VERSION_ID%TYPE ;
3233: lv_display_name OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE;
3234: lv_translated_yn OKC_ARTICLE_VERSIONS.TRANSLATED_YN%TYPE;
3235: lv_article_description OKC_ARTICLE_VERSIONS.ARTICLE_DESCRIPTION%TYPE;
3236: lv_date_approved OKC_ARTICLE_VERSIONS.DATE_APPROVED%TYPE;

Line 3233: lv_display_name OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE;

3229: lv_sav_release OKC_ARTICLE_VERSIONS.SAV_RELEASE%TYPE;
3230: lv_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE ;
3231: lv_end_date OKC_ARTICLE_VERSIONS.END_DATE%TYPE;
3232: lv_std_article_version_id OKC_ARTICLE_VERSIONS.STD_ARTICLE_VERSION_ID%TYPE ;
3233: lv_display_name OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE;
3234: lv_translated_yn OKC_ARTICLE_VERSIONS.TRANSLATED_YN%TYPE;
3235: lv_article_description OKC_ARTICLE_VERSIONS.ARTICLE_DESCRIPTION%TYPE;
3236: lv_date_approved OKC_ARTICLE_VERSIONS.DATE_APPROVED%TYPE;
3237: lv_default_section OKC_ARTICLE_VERSIONS.DEFAULT_SECTION%TYPE;

Line 3234: lv_translated_yn OKC_ARTICLE_VERSIONS.TRANSLATED_YN%TYPE;

3230: lv_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE ;
3231: lv_end_date OKC_ARTICLE_VERSIONS.END_DATE%TYPE;
3232: lv_std_article_version_id OKC_ARTICLE_VERSIONS.STD_ARTICLE_VERSION_ID%TYPE ;
3233: lv_display_name OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE;
3234: lv_translated_yn OKC_ARTICLE_VERSIONS.TRANSLATED_YN%TYPE;
3235: lv_article_description OKC_ARTICLE_VERSIONS.ARTICLE_DESCRIPTION%TYPE;
3236: lv_date_approved OKC_ARTICLE_VERSIONS.DATE_APPROVED%TYPE;
3237: lv_default_section OKC_ARTICLE_VERSIONS.DEFAULT_SECTION%TYPE;
3238: lv_reference_source OKC_ARTICLE_VERSIONS.REFERENCE_SOURCE%TYPE;

Line 3235: lv_article_description OKC_ARTICLE_VERSIONS.ARTICLE_DESCRIPTION%TYPE;

3231: lv_end_date OKC_ARTICLE_VERSIONS.END_DATE%TYPE;
3232: lv_std_article_version_id OKC_ARTICLE_VERSIONS.STD_ARTICLE_VERSION_ID%TYPE ;
3233: lv_display_name OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE;
3234: lv_translated_yn OKC_ARTICLE_VERSIONS.TRANSLATED_YN%TYPE;
3235: lv_article_description OKC_ARTICLE_VERSIONS.ARTICLE_DESCRIPTION%TYPE;
3236: lv_date_approved OKC_ARTICLE_VERSIONS.DATE_APPROVED%TYPE;
3237: lv_default_section OKC_ARTICLE_VERSIONS.DEFAULT_SECTION%TYPE;
3238: lv_reference_source OKC_ARTICLE_VERSIONS.REFERENCE_SOURCE%TYPE;
3239: lv_reference_text OKC_ARTICLE_VERSIONS.REFERENCE_TEXT%TYPE;

Line 3236: lv_date_approved OKC_ARTICLE_VERSIONS.DATE_APPROVED%TYPE;

3232: lv_std_article_version_id OKC_ARTICLE_VERSIONS.STD_ARTICLE_VERSION_ID%TYPE ;
3233: lv_display_name OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE;
3234: lv_translated_yn OKC_ARTICLE_VERSIONS.TRANSLATED_YN%TYPE;
3235: lv_article_description OKC_ARTICLE_VERSIONS.ARTICLE_DESCRIPTION%TYPE;
3236: lv_date_approved OKC_ARTICLE_VERSIONS.DATE_APPROVED%TYPE;
3237: lv_default_section OKC_ARTICLE_VERSIONS.DEFAULT_SECTION%TYPE;
3238: lv_reference_source OKC_ARTICLE_VERSIONS.REFERENCE_SOURCE%TYPE;
3239: lv_reference_text OKC_ARTICLE_VERSIONS.REFERENCE_TEXT%TYPE;
3240: lv_additional_instructions OKC_ARTICLE_VERSIONS.ADDITIONAL_INSTRUCTIONS%TYPE;

Line 3237: lv_default_section OKC_ARTICLE_VERSIONS.DEFAULT_SECTION%TYPE;

3233: lv_display_name OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE;
3234: lv_translated_yn OKC_ARTICLE_VERSIONS.TRANSLATED_YN%TYPE;
3235: lv_article_description OKC_ARTICLE_VERSIONS.ARTICLE_DESCRIPTION%TYPE;
3236: lv_date_approved OKC_ARTICLE_VERSIONS.DATE_APPROVED%TYPE;
3237: lv_default_section OKC_ARTICLE_VERSIONS.DEFAULT_SECTION%TYPE;
3238: lv_reference_source OKC_ARTICLE_VERSIONS.REFERENCE_SOURCE%TYPE;
3239: lv_reference_text OKC_ARTICLE_VERSIONS.REFERENCE_TEXT%TYPE;
3240: lv_additional_instructions OKC_ARTICLE_VERSIONS.ADDITIONAL_INSTRUCTIONS%TYPE;
3241: lv_variation_description OKC_ARTICLE_VERSIONS.VARIATION_DESCRIPTION%TYPE;

Line 3238: lv_reference_source OKC_ARTICLE_VERSIONS.REFERENCE_SOURCE%TYPE;

3234: lv_translated_yn OKC_ARTICLE_VERSIONS.TRANSLATED_YN%TYPE;
3235: lv_article_description OKC_ARTICLE_VERSIONS.ARTICLE_DESCRIPTION%TYPE;
3236: lv_date_approved OKC_ARTICLE_VERSIONS.DATE_APPROVED%TYPE;
3237: lv_default_section OKC_ARTICLE_VERSIONS.DEFAULT_SECTION%TYPE;
3238: lv_reference_source OKC_ARTICLE_VERSIONS.REFERENCE_SOURCE%TYPE;
3239: lv_reference_text OKC_ARTICLE_VERSIONS.REFERENCE_TEXT%TYPE;
3240: lv_additional_instructions OKC_ARTICLE_VERSIONS.ADDITIONAL_INSTRUCTIONS%TYPE;
3241: lv_variation_description OKC_ARTICLE_VERSIONS.VARIATION_DESCRIPTION%TYPE;
3242: lv_date_published OKC_ARTICLE_VERSIONS.DATE_PUBLISHED%TYPE;

Line 3239: lv_reference_text OKC_ARTICLE_VERSIONS.REFERENCE_TEXT%TYPE;

3235: lv_article_description OKC_ARTICLE_VERSIONS.ARTICLE_DESCRIPTION%TYPE;
3236: lv_date_approved OKC_ARTICLE_VERSIONS.DATE_APPROVED%TYPE;
3237: lv_default_section OKC_ARTICLE_VERSIONS.DEFAULT_SECTION%TYPE;
3238: lv_reference_source OKC_ARTICLE_VERSIONS.REFERENCE_SOURCE%TYPE;
3239: lv_reference_text OKC_ARTICLE_VERSIONS.REFERENCE_TEXT%TYPE;
3240: lv_additional_instructions OKC_ARTICLE_VERSIONS.ADDITIONAL_INSTRUCTIONS%TYPE;
3241: lv_variation_description OKC_ARTICLE_VERSIONS.VARIATION_DESCRIPTION%TYPE;
3242: lv_date_published OKC_ARTICLE_VERSIONS.DATE_PUBLISHED%TYPE;
3243: lv_orig_system_reference_code OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_CODE%TYPE;

Line 3240: lv_additional_instructions OKC_ARTICLE_VERSIONS.ADDITIONAL_INSTRUCTIONS%TYPE;

3236: lv_date_approved OKC_ARTICLE_VERSIONS.DATE_APPROVED%TYPE;
3237: lv_default_section OKC_ARTICLE_VERSIONS.DEFAULT_SECTION%TYPE;
3238: lv_reference_source OKC_ARTICLE_VERSIONS.REFERENCE_SOURCE%TYPE;
3239: lv_reference_text OKC_ARTICLE_VERSIONS.REFERENCE_TEXT%TYPE;
3240: lv_additional_instructions OKC_ARTICLE_VERSIONS.ADDITIONAL_INSTRUCTIONS%TYPE;
3241: lv_variation_description OKC_ARTICLE_VERSIONS.VARIATION_DESCRIPTION%TYPE;
3242: lv_date_published OKC_ARTICLE_VERSIONS.DATE_PUBLISHED%TYPE;
3243: lv_orig_system_reference_code OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
3244: lv_orig_system_reference_id1 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID1%TYPE;

Line 3241: lv_variation_description OKC_ARTICLE_VERSIONS.VARIATION_DESCRIPTION%TYPE;

3237: lv_default_section OKC_ARTICLE_VERSIONS.DEFAULT_SECTION%TYPE;
3238: lv_reference_source OKC_ARTICLE_VERSIONS.REFERENCE_SOURCE%TYPE;
3239: lv_reference_text OKC_ARTICLE_VERSIONS.REFERENCE_TEXT%TYPE;
3240: lv_additional_instructions OKC_ARTICLE_VERSIONS.ADDITIONAL_INSTRUCTIONS%TYPE;
3241: lv_variation_description OKC_ARTICLE_VERSIONS.VARIATION_DESCRIPTION%TYPE;
3242: lv_date_published OKC_ARTICLE_VERSIONS.DATE_PUBLISHED%TYPE;
3243: lv_orig_system_reference_code OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
3244: lv_orig_system_reference_id1 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
3245: lv_orig_system_reference_id2 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID2%TYPE;

Line 3242: lv_date_published OKC_ARTICLE_VERSIONS.DATE_PUBLISHED%TYPE;

3238: lv_reference_source OKC_ARTICLE_VERSIONS.REFERENCE_SOURCE%TYPE;
3239: lv_reference_text OKC_ARTICLE_VERSIONS.REFERENCE_TEXT%TYPE;
3240: lv_additional_instructions OKC_ARTICLE_VERSIONS.ADDITIONAL_INSTRUCTIONS%TYPE;
3241: lv_variation_description OKC_ARTICLE_VERSIONS.VARIATION_DESCRIPTION%TYPE;
3242: lv_date_published OKC_ARTICLE_VERSIONS.DATE_PUBLISHED%TYPE;
3243: lv_orig_system_reference_code OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
3244: lv_orig_system_reference_id1 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
3245: lv_orig_system_reference_id2 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
3246: lv_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE ;

Line 3243: lv_orig_system_reference_code OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_CODE%TYPE;

3239: lv_reference_text OKC_ARTICLE_VERSIONS.REFERENCE_TEXT%TYPE;
3240: lv_additional_instructions OKC_ARTICLE_VERSIONS.ADDITIONAL_INSTRUCTIONS%TYPE;
3241: lv_variation_description OKC_ARTICLE_VERSIONS.VARIATION_DESCRIPTION%TYPE;
3242: lv_date_published OKC_ARTICLE_VERSIONS.DATE_PUBLISHED%TYPE;
3243: lv_orig_system_reference_code OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
3244: lv_orig_system_reference_id1 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
3245: lv_orig_system_reference_id2 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
3246: lv_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE ;
3247: lv_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE ;

Line 3244: lv_orig_system_reference_id1 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID1%TYPE;

3240: lv_additional_instructions OKC_ARTICLE_VERSIONS.ADDITIONAL_INSTRUCTIONS%TYPE;
3241: lv_variation_description OKC_ARTICLE_VERSIONS.VARIATION_DESCRIPTION%TYPE;
3242: lv_date_published OKC_ARTICLE_VERSIONS.DATE_PUBLISHED%TYPE;
3243: lv_orig_system_reference_code OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
3244: lv_orig_system_reference_id1 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
3245: lv_orig_system_reference_id2 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
3246: lv_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE ;
3247: lv_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE ;
3248: lv_program_application_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE ;

Line 3245: lv_orig_system_reference_id2 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID2%TYPE;

3241: lv_variation_description OKC_ARTICLE_VERSIONS.VARIATION_DESCRIPTION%TYPE;
3242: lv_date_published OKC_ARTICLE_VERSIONS.DATE_PUBLISHED%TYPE;
3243: lv_orig_system_reference_code OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
3244: lv_orig_system_reference_id1 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
3245: lv_orig_system_reference_id2 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
3246: lv_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE ;
3247: lv_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE ;
3248: lv_program_application_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE ;
3249: lv_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE ;

Line 3246: lv_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE ;

3242: lv_date_published OKC_ARTICLE_VERSIONS.DATE_PUBLISHED%TYPE;
3243: lv_orig_system_reference_code OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
3244: lv_orig_system_reference_id1 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
3245: lv_orig_system_reference_id2 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
3246: lv_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE ;
3247: lv_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE ;
3248: lv_program_application_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE ;
3249: lv_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE ;
3250: lv_attribute_category OKC_ARTICLE_VERSIONS.ATTRIBUTE_CATEGORY%TYPE;

Line 3247: lv_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE ;

3243: lv_orig_system_reference_code OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
3244: lv_orig_system_reference_id1 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
3245: lv_orig_system_reference_id2 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
3246: lv_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE ;
3247: lv_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE ;
3248: lv_program_application_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE ;
3249: lv_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE ;
3250: lv_attribute_category OKC_ARTICLE_VERSIONS.ATTRIBUTE_CATEGORY%TYPE;
3251: lv_attribute1 OKC_ARTICLE_VERSIONS.ATTRIBUTE1%TYPE;

Line 3248: lv_program_application_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE ;

3244: lv_orig_system_reference_id1 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
3245: lv_orig_system_reference_id2 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
3246: lv_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE ;
3247: lv_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE ;
3248: lv_program_application_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE ;
3249: lv_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE ;
3250: lv_attribute_category OKC_ARTICLE_VERSIONS.ATTRIBUTE_CATEGORY%TYPE;
3251: lv_attribute1 OKC_ARTICLE_VERSIONS.ATTRIBUTE1%TYPE;
3252: lv_attribute2 OKC_ARTICLE_VERSIONS.ATTRIBUTE2%TYPE;

Line 3249: lv_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE ;

3245: lv_orig_system_reference_id2 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
3246: lv_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE ;
3247: lv_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE ;
3248: lv_program_application_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE ;
3249: lv_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE ;
3250: lv_attribute_category OKC_ARTICLE_VERSIONS.ATTRIBUTE_CATEGORY%TYPE;
3251: lv_attribute1 OKC_ARTICLE_VERSIONS.ATTRIBUTE1%TYPE;
3252: lv_attribute2 OKC_ARTICLE_VERSIONS.ATTRIBUTE2%TYPE;
3253: lv_attribute3 OKC_ARTICLE_VERSIONS.ATTRIBUTE3%TYPE;

Line 3250: lv_attribute_category OKC_ARTICLE_VERSIONS.ATTRIBUTE_CATEGORY%TYPE;

3246: lv_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE ;
3247: lv_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE ;
3248: lv_program_application_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE ;
3249: lv_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE ;
3250: lv_attribute_category OKC_ARTICLE_VERSIONS.ATTRIBUTE_CATEGORY%TYPE;
3251: lv_attribute1 OKC_ARTICLE_VERSIONS.ATTRIBUTE1%TYPE;
3252: lv_attribute2 OKC_ARTICLE_VERSIONS.ATTRIBUTE2%TYPE;
3253: lv_attribute3 OKC_ARTICLE_VERSIONS.ATTRIBUTE3%TYPE;
3254: lv_attribute4 OKC_ARTICLE_VERSIONS.ATTRIBUTE4%TYPE;

Line 3251: lv_attribute1 OKC_ARTICLE_VERSIONS.ATTRIBUTE1%TYPE;

3247: lv_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE ;
3248: lv_program_application_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE ;
3249: lv_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE ;
3250: lv_attribute_category OKC_ARTICLE_VERSIONS.ATTRIBUTE_CATEGORY%TYPE;
3251: lv_attribute1 OKC_ARTICLE_VERSIONS.ATTRIBUTE1%TYPE;
3252: lv_attribute2 OKC_ARTICLE_VERSIONS.ATTRIBUTE2%TYPE;
3253: lv_attribute3 OKC_ARTICLE_VERSIONS.ATTRIBUTE3%TYPE;
3254: lv_attribute4 OKC_ARTICLE_VERSIONS.ATTRIBUTE4%TYPE;
3255: lv_attribute5 OKC_ARTICLE_VERSIONS.ATTRIBUTE5%TYPE;

Line 3252: lv_attribute2 OKC_ARTICLE_VERSIONS.ATTRIBUTE2%TYPE;

3248: lv_program_application_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE ;
3249: lv_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE ;
3250: lv_attribute_category OKC_ARTICLE_VERSIONS.ATTRIBUTE_CATEGORY%TYPE;
3251: lv_attribute1 OKC_ARTICLE_VERSIONS.ATTRIBUTE1%TYPE;
3252: lv_attribute2 OKC_ARTICLE_VERSIONS.ATTRIBUTE2%TYPE;
3253: lv_attribute3 OKC_ARTICLE_VERSIONS.ATTRIBUTE3%TYPE;
3254: lv_attribute4 OKC_ARTICLE_VERSIONS.ATTRIBUTE4%TYPE;
3255: lv_attribute5 OKC_ARTICLE_VERSIONS.ATTRIBUTE5%TYPE;
3256: lv_attribute6 OKC_ARTICLE_VERSIONS.ATTRIBUTE6%TYPE;

Line 3253: lv_attribute3 OKC_ARTICLE_VERSIONS.ATTRIBUTE3%TYPE;

3249: lv_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE ;
3250: lv_attribute_category OKC_ARTICLE_VERSIONS.ATTRIBUTE_CATEGORY%TYPE;
3251: lv_attribute1 OKC_ARTICLE_VERSIONS.ATTRIBUTE1%TYPE;
3252: lv_attribute2 OKC_ARTICLE_VERSIONS.ATTRIBUTE2%TYPE;
3253: lv_attribute3 OKC_ARTICLE_VERSIONS.ATTRIBUTE3%TYPE;
3254: lv_attribute4 OKC_ARTICLE_VERSIONS.ATTRIBUTE4%TYPE;
3255: lv_attribute5 OKC_ARTICLE_VERSIONS.ATTRIBUTE5%TYPE;
3256: lv_attribute6 OKC_ARTICLE_VERSIONS.ATTRIBUTE6%TYPE;
3257: lv_attribute7 OKC_ARTICLE_VERSIONS.ATTRIBUTE7%TYPE;

Line 3254: lv_attribute4 OKC_ARTICLE_VERSIONS.ATTRIBUTE4%TYPE;

3250: lv_attribute_category OKC_ARTICLE_VERSIONS.ATTRIBUTE_CATEGORY%TYPE;
3251: lv_attribute1 OKC_ARTICLE_VERSIONS.ATTRIBUTE1%TYPE;
3252: lv_attribute2 OKC_ARTICLE_VERSIONS.ATTRIBUTE2%TYPE;
3253: lv_attribute3 OKC_ARTICLE_VERSIONS.ATTRIBUTE3%TYPE;
3254: lv_attribute4 OKC_ARTICLE_VERSIONS.ATTRIBUTE4%TYPE;
3255: lv_attribute5 OKC_ARTICLE_VERSIONS.ATTRIBUTE5%TYPE;
3256: lv_attribute6 OKC_ARTICLE_VERSIONS.ATTRIBUTE6%TYPE;
3257: lv_attribute7 OKC_ARTICLE_VERSIONS.ATTRIBUTE7%TYPE;
3258: lv_attribute8 OKC_ARTICLE_VERSIONS.ATTRIBUTE8%TYPE;

Line 3255: lv_attribute5 OKC_ARTICLE_VERSIONS.ATTRIBUTE5%TYPE;

3251: lv_attribute1 OKC_ARTICLE_VERSIONS.ATTRIBUTE1%TYPE;
3252: lv_attribute2 OKC_ARTICLE_VERSIONS.ATTRIBUTE2%TYPE;
3253: lv_attribute3 OKC_ARTICLE_VERSIONS.ATTRIBUTE3%TYPE;
3254: lv_attribute4 OKC_ARTICLE_VERSIONS.ATTRIBUTE4%TYPE;
3255: lv_attribute5 OKC_ARTICLE_VERSIONS.ATTRIBUTE5%TYPE;
3256: lv_attribute6 OKC_ARTICLE_VERSIONS.ATTRIBUTE6%TYPE;
3257: lv_attribute7 OKC_ARTICLE_VERSIONS.ATTRIBUTE7%TYPE;
3258: lv_attribute8 OKC_ARTICLE_VERSIONS.ATTRIBUTE8%TYPE;
3259: lv_attribute9 OKC_ARTICLE_VERSIONS.ATTRIBUTE9%TYPE;

Line 3256: lv_attribute6 OKC_ARTICLE_VERSIONS.ATTRIBUTE6%TYPE;

3252: lv_attribute2 OKC_ARTICLE_VERSIONS.ATTRIBUTE2%TYPE;
3253: lv_attribute3 OKC_ARTICLE_VERSIONS.ATTRIBUTE3%TYPE;
3254: lv_attribute4 OKC_ARTICLE_VERSIONS.ATTRIBUTE4%TYPE;
3255: lv_attribute5 OKC_ARTICLE_VERSIONS.ATTRIBUTE5%TYPE;
3256: lv_attribute6 OKC_ARTICLE_VERSIONS.ATTRIBUTE6%TYPE;
3257: lv_attribute7 OKC_ARTICLE_VERSIONS.ATTRIBUTE7%TYPE;
3258: lv_attribute8 OKC_ARTICLE_VERSIONS.ATTRIBUTE8%TYPE;
3259: lv_attribute9 OKC_ARTICLE_VERSIONS.ATTRIBUTE9%TYPE;
3260: lv_attribute10 OKC_ARTICLE_VERSIONS.ATTRIBUTE10%TYPE;

Line 3257: lv_attribute7 OKC_ARTICLE_VERSIONS.ATTRIBUTE7%TYPE;

3253: lv_attribute3 OKC_ARTICLE_VERSIONS.ATTRIBUTE3%TYPE;
3254: lv_attribute4 OKC_ARTICLE_VERSIONS.ATTRIBUTE4%TYPE;
3255: lv_attribute5 OKC_ARTICLE_VERSIONS.ATTRIBUTE5%TYPE;
3256: lv_attribute6 OKC_ARTICLE_VERSIONS.ATTRIBUTE6%TYPE;
3257: lv_attribute7 OKC_ARTICLE_VERSIONS.ATTRIBUTE7%TYPE;
3258: lv_attribute8 OKC_ARTICLE_VERSIONS.ATTRIBUTE8%TYPE;
3259: lv_attribute9 OKC_ARTICLE_VERSIONS.ATTRIBUTE9%TYPE;
3260: lv_attribute10 OKC_ARTICLE_VERSIONS.ATTRIBUTE10%TYPE;
3261: lv_attribute11 OKC_ARTICLE_VERSIONS.ATTRIBUTE11%TYPE;

Line 3258: lv_attribute8 OKC_ARTICLE_VERSIONS.ATTRIBUTE8%TYPE;

3254: lv_attribute4 OKC_ARTICLE_VERSIONS.ATTRIBUTE4%TYPE;
3255: lv_attribute5 OKC_ARTICLE_VERSIONS.ATTRIBUTE5%TYPE;
3256: lv_attribute6 OKC_ARTICLE_VERSIONS.ATTRIBUTE6%TYPE;
3257: lv_attribute7 OKC_ARTICLE_VERSIONS.ATTRIBUTE7%TYPE;
3258: lv_attribute8 OKC_ARTICLE_VERSIONS.ATTRIBUTE8%TYPE;
3259: lv_attribute9 OKC_ARTICLE_VERSIONS.ATTRIBUTE9%TYPE;
3260: lv_attribute10 OKC_ARTICLE_VERSIONS.ATTRIBUTE10%TYPE;
3261: lv_attribute11 OKC_ARTICLE_VERSIONS.ATTRIBUTE11%TYPE;
3262: lv_attribute12 OKC_ARTICLE_VERSIONS.ATTRIBUTE12%TYPE;

Line 3259: lv_attribute9 OKC_ARTICLE_VERSIONS.ATTRIBUTE9%TYPE;

3255: lv_attribute5 OKC_ARTICLE_VERSIONS.ATTRIBUTE5%TYPE;
3256: lv_attribute6 OKC_ARTICLE_VERSIONS.ATTRIBUTE6%TYPE;
3257: lv_attribute7 OKC_ARTICLE_VERSIONS.ATTRIBUTE7%TYPE;
3258: lv_attribute8 OKC_ARTICLE_VERSIONS.ATTRIBUTE8%TYPE;
3259: lv_attribute9 OKC_ARTICLE_VERSIONS.ATTRIBUTE9%TYPE;
3260: lv_attribute10 OKC_ARTICLE_VERSIONS.ATTRIBUTE10%TYPE;
3261: lv_attribute11 OKC_ARTICLE_VERSIONS.ATTRIBUTE11%TYPE;
3262: lv_attribute12 OKC_ARTICLE_VERSIONS.ATTRIBUTE12%TYPE;
3263: lv_attribute13 OKC_ARTICLE_VERSIONS.ATTRIBUTE13%TYPE;

Line 3260: lv_attribute10 OKC_ARTICLE_VERSIONS.ATTRIBUTE10%TYPE;

3256: lv_attribute6 OKC_ARTICLE_VERSIONS.ATTRIBUTE6%TYPE;
3257: lv_attribute7 OKC_ARTICLE_VERSIONS.ATTRIBUTE7%TYPE;
3258: lv_attribute8 OKC_ARTICLE_VERSIONS.ATTRIBUTE8%TYPE;
3259: lv_attribute9 OKC_ARTICLE_VERSIONS.ATTRIBUTE9%TYPE;
3260: lv_attribute10 OKC_ARTICLE_VERSIONS.ATTRIBUTE10%TYPE;
3261: lv_attribute11 OKC_ARTICLE_VERSIONS.ATTRIBUTE11%TYPE;
3262: lv_attribute12 OKC_ARTICLE_VERSIONS.ATTRIBUTE12%TYPE;
3263: lv_attribute13 OKC_ARTICLE_VERSIONS.ATTRIBUTE13%TYPE;
3264: lv_attribute14 OKC_ARTICLE_VERSIONS.ATTRIBUTE14%TYPE;

Line 3261: lv_attribute11 OKC_ARTICLE_VERSIONS.ATTRIBUTE11%TYPE;

3257: lv_attribute7 OKC_ARTICLE_VERSIONS.ATTRIBUTE7%TYPE;
3258: lv_attribute8 OKC_ARTICLE_VERSIONS.ATTRIBUTE8%TYPE;
3259: lv_attribute9 OKC_ARTICLE_VERSIONS.ATTRIBUTE9%TYPE;
3260: lv_attribute10 OKC_ARTICLE_VERSIONS.ATTRIBUTE10%TYPE;
3261: lv_attribute11 OKC_ARTICLE_VERSIONS.ATTRIBUTE11%TYPE;
3262: lv_attribute12 OKC_ARTICLE_VERSIONS.ATTRIBUTE12%TYPE;
3263: lv_attribute13 OKC_ARTICLE_VERSIONS.ATTRIBUTE13%TYPE;
3264: lv_attribute14 OKC_ARTICLE_VERSIONS.ATTRIBUTE14%TYPE;
3265: lv_attribute15 OKC_ARTICLE_VERSIONS.ATTRIBUTE15%TYPE;

Line 3262: lv_attribute12 OKC_ARTICLE_VERSIONS.ATTRIBUTE12%TYPE;

3258: lv_attribute8 OKC_ARTICLE_VERSIONS.ATTRIBUTE8%TYPE;
3259: lv_attribute9 OKC_ARTICLE_VERSIONS.ATTRIBUTE9%TYPE;
3260: lv_attribute10 OKC_ARTICLE_VERSIONS.ATTRIBUTE10%TYPE;
3261: lv_attribute11 OKC_ARTICLE_VERSIONS.ATTRIBUTE11%TYPE;
3262: lv_attribute12 OKC_ARTICLE_VERSIONS.ATTRIBUTE12%TYPE;
3263: lv_attribute13 OKC_ARTICLE_VERSIONS.ATTRIBUTE13%TYPE;
3264: lv_attribute14 OKC_ARTICLE_VERSIONS.ATTRIBUTE14%TYPE;
3265: lv_attribute15 OKC_ARTICLE_VERSIONS.ATTRIBUTE15%TYPE;
3266: lv_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;

Line 3263: lv_attribute13 OKC_ARTICLE_VERSIONS.ATTRIBUTE13%TYPE;

3259: lv_attribute9 OKC_ARTICLE_VERSIONS.ATTRIBUTE9%TYPE;
3260: lv_attribute10 OKC_ARTICLE_VERSIONS.ATTRIBUTE10%TYPE;
3261: lv_attribute11 OKC_ARTICLE_VERSIONS.ATTRIBUTE11%TYPE;
3262: lv_attribute12 OKC_ARTICLE_VERSIONS.ATTRIBUTE12%TYPE;
3263: lv_attribute13 OKC_ARTICLE_VERSIONS.ATTRIBUTE13%TYPE;
3264: lv_attribute14 OKC_ARTICLE_VERSIONS.ATTRIBUTE14%TYPE;
3265: lv_attribute15 OKC_ARTICLE_VERSIONS.ATTRIBUTE15%TYPE;
3266: lv_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
3267: lv_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;

Line 3264: lv_attribute14 OKC_ARTICLE_VERSIONS.ATTRIBUTE14%TYPE;

3260: lv_attribute10 OKC_ARTICLE_VERSIONS.ATTRIBUTE10%TYPE;
3261: lv_attribute11 OKC_ARTICLE_VERSIONS.ATTRIBUTE11%TYPE;
3262: lv_attribute12 OKC_ARTICLE_VERSIONS.ATTRIBUTE12%TYPE;
3263: lv_attribute13 OKC_ARTICLE_VERSIONS.ATTRIBUTE13%TYPE;
3264: lv_attribute14 OKC_ARTICLE_VERSIONS.ATTRIBUTE14%TYPE;
3265: lv_attribute15 OKC_ARTICLE_VERSIONS.ATTRIBUTE15%TYPE;
3266: lv_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
3267: lv_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
3268: lv_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;

Line 3265: lv_attribute15 OKC_ARTICLE_VERSIONS.ATTRIBUTE15%TYPE;

3261: lv_attribute11 OKC_ARTICLE_VERSIONS.ATTRIBUTE11%TYPE;
3262: lv_attribute12 OKC_ARTICLE_VERSIONS.ATTRIBUTE12%TYPE;
3263: lv_attribute13 OKC_ARTICLE_VERSIONS.ATTRIBUTE13%TYPE;
3264: lv_attribute14 OKC_ARTICLE_VERSIONS.ATTRIBUTE14%TYPE;
3265: lv_attribute15 OKC_ARTICLE_VERSIONS.ATTRIBUTE15%TYPE;
3266: lv_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
3267: lv_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
3268: lv_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;
3269: lv_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;

Line 3266: lv_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;

3262: lv_attribute12 OKC_ARTICLE_VERSIONS.ATTRIBUTE12%TYPE;
3263: lv_attribute13 OKC_ARTICLE_VERSIONS.ATTRIBUTE13%TYPE;
3264: lv_attribute14 OKC_ARTICLE_VERSIONS.ATTRIBUTE14%TYPE;
3265: lv_attribute15 OKC_ARTICLE_VERSIONS.ATTRIBUTE15%TYPE;
3266: lv_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
3267: lv_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
3268: lv_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;
3269: lv_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
3270: lv_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;

Line 3267: lv_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;

3263: lv_attribute13 OKC_ARTICLE_VERSIONS.ATTRIBUTE13%TYPE;
3264: lv_attribute14 OKC_ARTICLE_VERSIONS.ATTRIBUTE14%TYPE;
3265: lv_attribute15 OKC_ARTICLE_VERSIONS.ATTRIBUTE15%TYPE;
3266: lv_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
3267: lv_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
3268: lv_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;
3269: lv_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
3270: lv_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
3271: --Clause Editing

Line 3268: lv_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;

3264: lv_attribute14 OKC_ARTICLE_VERSIONS.ATTRIBUTE14%TYPE;
3265: lv_attribute15 OKC_ARTICLE_VERSIONS.ATTRIBUTE15%TYPE;
3266: lv_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
3267: lv_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
3268: lv_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;
3269: lv_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
3270: lv_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
3271: --Clause Editing
3272: lv_edited_in_word OKC_ARTICLE_VERSIONS.EDITED_IN_WORD%TYPE;

Line 3269: lv_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;

3265: lv_attribute15 OKC_ARTICLE_VERSIONS.ATTRIBUTE15%TYPE;
3266: lv_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
3267: lv_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
3268: lv_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;
3269: lv_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
3270: lv_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
3271: --Clause Editing
3272: lv_edited_in_word OKC_ARTICLE_VERSIONS.EDITED_IN_WORD%TYPE;
3273: lv_article_text_in_word OKC_ARTICLE_VERSIONS.ARTICLE_TEXT_IN_WORD%TYPE;

Line 3270: lv_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;

3266: lv_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
3267: lv_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
3268: lv_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;
3269: lv_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
3270: lv_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
3271: --Clause Editing
3272: lv_edited_in_word OKC_ARTICLE_VERSIONS.EDITED_IN_WORD%TYPE;
3273: lv_article_text_in_word OKC_ARTICLE_VERSIONS.ARTICLE_TEXT_IN_WORD%TYPE;
3274: --CLM

Line 3272: lv_edited_in_word OKC_ARTICLE_VERSIONS.EDITED_IN_WORD%TYPE;

3268: lv_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;
3269: lv_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
3270: lv_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
3271: --Clause Editing
3272: lv_edited_in_word OKC_ARTICLE_VERSIONS.EDITED_IN_WORD%TYPE;
3273: lv_article_text_in_word OKC_ARTICLE_VERSIONS.ARTICLE_TEXT_IN_WORD%TYPE;
3274: --CLM
3275: lv_variable_code OKC_ARTICLE_VERSIONS.VARIABLE_CODE%TYPE;
3276:

Line 3273: lv_article_text_in_word OKC_ARTICLE_VERSIONS.ARTICLE_TEXT_IN_WORD%TYPE;

3269: lv_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
3270: lv_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
3271: --Clause Editing
3272: lv_edited_in_word OKC_ARTICLE_VERSIONS.EDITED_IN_WORD%TYPE;
3273: lv_article_text_in_word OKC_ARTICLE_VERSIONS.ARTICLE_TEXT_IN_WORD%TYPE;
3274: --CLM
3275: lv_variable_code OKC_ARTICLE_VERSIONS.VARIABLE_CODE%TYPE;
3276:
3277: l_p_standard_yn VARCHAR2(1);

Line 3275: lv_variable_code OKC_ARTICLE_VERSIONS.VARIABLE_CODE%TYPE;

3271: --Clause Editing
3272: lv_edited_in_word OKC_ARTICLE_VERSIONS.EDITED_IN_WORD%TYPE;
3273: lv_article_text_in_word OKC_ARTICLE_VERSIONS.ARTICLE_TEXT_IN_WORD%TYPE;
3274: --CLM
3275: lv_variable_code OKC_ARTICLE_VERSIONS.VARIABLE_CODE%TYPE;
3276:
3277: l_p_standard_yn VARCHAR2(1);
3278: l_p_article_id NUMBER;
3279: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;

Line 3284: l_earlier_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;

3280: l_api_version CONSTANT NUMBER := 1;
3281: l_api_name CONSTANT VARCHAR2(30) := 'g_copy_article';
3282: l_p_org_id NUMBER;
3283: l_earlier_version_id NUMBER;
3284: l_earlier_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
3285: -- TYPE l_source_article_id_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.SOURCE_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
3286: TYPE l_target_article_id_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.TARGET_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
3287: TYPE l_relationship_type_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.RELATIONSHIP_TYPE%TYPE INDEX BY BINARY_INTEGER ;
3288:

Line 3296: FROM OKC_ARTICLES_ALL aa,OKC_ARTICLE_VERSIONS av

3292: i NUMBER := 0;
3293:
3294: CURSOR l_article_csr (cp_article_version_id IN NUMBER) is
3295: SELECT aa.standard_yn,av.article_id
3296: FROM OKC_ARTICLES_ALL aa,OKC_ARTICLE_VERSIONS av
3297: WHERE aa.ARTICLE_ID = av.ARTICLE_ID
3298: AND av.ARTICLE_VERSION_ID = cp_article_version_id;
3299:
3300: CURSOR l_relationship_csr (cp_article_id IN NUMBER,

Line 3401: l_return_status := OKC_ARTICLE_VERSIONS_PVT.Get_Rec(

3397:
3398: IF( p_article_version_id IS NOT NULL ) THEN
3399: -- Get current database values for article version
3400: --dbms_output.put_line('l_return_status is2 '||l_return_status);
3401: l_return_status := OKC_ARTICLE_VERSIONS_PVT.Get_Rec(
3402: p_article_version_id => p_article_version_id,
3403: x_article_id => lv_article_id,
3404: x_article_version_number => lv_article_version_number,
3405: x_article_text => lv_article_text,

Line 3568: OKC_ARTICLE_VERSIONS_PVT.Insert_Row(

3564: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3565: RAISE FND_API.G_EXC_ERROR ;
3566: END IF;
3567: --------------------------------------------
3568: OKC_ARTICLE_VERSIONS_PVT.Insert_Row(
3569: p_validation_level => p_validation_level,
3570: x_return_status => x_return_status,
3571: p_article_id => x_article_id,
3572: p_article_text => lv_article_text,

Line 3877: OKC_ARTICLE_VERSIONS V1 ,

3873: ) IS
3874: CURSOR l_local_article_csr(cp_article_id IN NUMBER,
3875: cp_local_org_id IN NUMBER) IS
3876: SELECT V2.article_id FROM OKC_ARTICLE_ADOPTIONS AA,
3877: OKC_ARTICLE_VERSIONS V1 ,
3878: OKC_ARTICLE_VERSIONS V2
3879: WHERE V1.ARTICLE_VERSION_ID = AA.GLOBAL_ARTICLE_VERSION_ID
3880: AND V2.ARTICLE_VERSION_ID = AA.LOCAL_ARTICLE_VERSION_ID
3881: AND V1.ARTICLE_ID = cp_article_id

Line 3878: OKC_ARTICLE_VERSIONS V2

3874: CURSOR l_local_article_csr(cp_article_id IN NUMBER,
3875: cp_local_org_id IN NUMBER) IS
3876: SELECT V2.article_id FROM OKC_ARTICLE_ADOPTIONS AA,
3877: OKC_ARTICLE_VERSIONS V1 ,
3878: OKC_ARTICLE_VERSIONS V2
3879: WHERE V1.ARTICLE_VERSION_ID = AA.GLOBAL_ARTICLE_VERSION_ID
3880: AND V2.ARTICLE_VERSION_ID = AA.LOCAL_ARTICLE_VERSION_ID
3881: AND V1.ARTICLE_ID = cp_article_id
3882: AND AA.LOCAL_ORG_ID = cp_local_org_id

Line 3889: OKC_ARTICLE_VERSIONS V1

3885: AND NVL(V2.END_DATE, SYSDATE+1) > SYSDATE
3886: AND rownum < 2
3887: UNION ALL
3888: SELECT V1.article_id FROM OKC_ARTICLE_ADOPTIONS AA,
3889: OKC_ARTICLE_VERSIONS V1
3890: WHERE V1.ARTICLE_VERSION_ID = AA.GLOBAL_ARTICLE_VERSION_ID
3891: AND V1.ARTICLE_ID = cp_article_id
3892: AND AA.LOCAL_ORG_ID = cp_local_org_id
3893: AND AA.ADOPTION_TYPE = 'ADOPTED'

Line 3978: OKC_ARTICLE_VERSIONS V1,

3974: CURSOR l_local_article_csr(cp_src_article_id IN NUMBER,
3975: cp_tar_article_id IN NUMBER,
3976: cp_local_org_id IN NUMBER) IS
3977: SELECT '1' FROM OKC_ARTICLE_ADOPTIONS AA1,
3978: OKC_ARTICLE_VERSIONS V1,
3979: OKC_ARTICLE_ADOPTIONS AA2,
3980: OKC_ARTICLE_VERSIONS V2
3981: WHERE V1.ARTICLE_VERSION_ID = AA1.GLOBAL_ARTICLE_VERSION_ID
3982: AND V1.ARTICLE_ID = cp_src_article_id

Line 3980: OKC_ARTICLE_VERSIONS V2

3976: cp_local_org_id IN NUMBER) IS
3977: SELECT '1' FROM OKC_ARTICLE_ADOPTIONS AA1,
3978: OKC_ARTICLE_VERSIONS V1,
3979: OKC_ARTICLE_ADOPTIONS AA2,
3980: OKC_ARTICLE_VERSIONS V2
3981: WHERE V1.ARTICLE_VERSION_ID = AA1.GLOBAL_ARTICLE_VERSION_ID
3982: AND V1.ARTICLE_ID = cp_src_article_id
3983: AND AA1.LOCAL_ORG_ID = cp_local_org_id
3984: AND AA1.ADOPTION_TYPE = 'ADOPTED'

Line 4085: (SELECT 1 FROM OKC_ARTICLE_VERSIONS V

4081: FROM OKC_ARTICLES_ALL A, OKC_ARTICLES_ALL B
4082: WHERE A.ARTICLE_ID = cp_src_global_article_id
4083: AND B.ARTICLE_ID = cp_tar_global_article_id
4084: AND EXISTS
4085: (SELECT 1 FROM OKC_ARTICLE_VERSIONS V
4086: WHERE V.ARTICLE_ID = B.ARTICLE_ID
4087: AND V.GLOBAL_YN = 'Y'
4088: AND V.ARTICLE_STATUS = 'APPROVED'
4089: AND NVL(V.END_DATE,SYSDATE + 1) > SYSDATE

Line 4092: (SELECT 1 FROM OKC_ARTICLE_VERSIONS V1

4088: AND V.ARTICLE_STATUS = 'APPROVED'
4089: AND NVL(V.END_DATE,SYSDATE + 1) > SYSDATE
4090: )
4091: AND EXISTS
4092: (SELECT 1 FROM OKC_ARTICLE_VERSIONS V1
4093: WHERE V1.ARTICLE_ID = A.ARTICLE_ID
4094: AND V1.GLOBAL_YN = 'Y'
4095: AND V1.ARTICLE_STATUS = 'APPROVED'
4096: AND NVL(V1.END_DATE,SYSDATE + 1) > SYSDATE

Line 4692: okc_article_versions av

4688: cp_start_date IN DATE) IS
4689: select
4690: 'Y'
4691: from
4692: okc_article_versions av
4693: where
4694: av.article_id = cp_article_id and
4695: av.start_date > cp_start_date and
4696: av.article_status in ( 'APPROVED', 'HOLD') and