DBA Data[Home] [Help]

APPS.OKC_ARTICLE_VERSIONS_PVT dependencies on OKC_ARTICLE_VERSIONS

Line 1: PACKAGE BODY OKC_ARTICLE_VERSIONS_PVT AS

1: PACKAGE BODY OKC_ARTICLE_VERSIONS_PVT AS
2: /* $Header: OKCVAVNB.pls 120.4.12000000.2 2007/02/26 22:34:08 ssivarap ship $ */
3:
4: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5:

Line 30: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_ARTICLE_VERSIONS_PVT';

26: G_RECORD_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_RECORD_VALID_LEVEL;
27: ---------------------------------------------------------------------------
28: -- GLOBAL VARIABLES
29: ---------------------------------------------------------------------------
30: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_ARTICLE_VERSIONS_PVT';
31: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
32:
33: ------------------------------------------------------------------------------
34: -- GLOBAL CONSTANTS

Line 71: SELECT OKC_ARTICLE_VERSIONS_S1.NEXTVAL FROM DUAL;

67: p_article_version_id IN NUMBER,
68: x_article_version_id OUT NOCOPY NUMBER
69: ) RETURN VARCHAR2 IS
70: CURSOR l_seq_csr IS
71: SELECT OKC_ARTICLE_VERSIONS_S1.NEXTVAL FROM DUAL;
72: BEGIN
73: IF (l_debug = 'Y') THEN
74: Okc_Debug.Log('100: Entered get_seq_id', 2);
75: END IF;

Line 113: -- FUNCTION get_rec for: OKC_ARTICLE_VERSIONS

109:
110: END Get_Seq_Id;
111:
112: ---------------------------------------------------------------------------
113: -- FUNCTION get_rec for: OKC_ARTICLE_VERSIONS
114: ---------------------------------------------------------------------------
115: FUNCTION Get_Rec (
116: p_article_version_id IN NUMBER,
117:

Line 172: CURSOR OKC_ARTICLE_VERSIONS_pk_csr (cp_article_version_id IN NUMBER) IS

168: x_last_update_login OUT NOCOPY NUMBER,
169: x_last_update_date OUT NOCOPY DATE
170:
171: ) RETURN VARCHAR2 IS
172: CURSOR OKC_ARTICLE_VERSIONS_pk_csr (cp_article_version_id IN NUMBER) IS
173: SELECT
174: ARTICLE_ID,
175: ARTICLE_VERSION_NUMBER,
176: ARTICLE_TEXT,

Line 226: FROM OKC_ARTICLE_VERSIONS t

222: CREATION_DATE,
223: LAST_UPDATED_BY,
224: LAST_UPDATE_LOGIN,
225: LAST_UPDATE_DATE
226: FROM OKC_ARTICLE_VERSIONS t
227: WHERE t.ARTICLE_VERSION_ID = cp_article_version_id;
228: BEGIN
229:
230: IF (l_debug = 'Y') THEN

Line 235: OPEN OKC_ARTICLE_VERSIONS_pk_csr (p_article_version_id);

231: Okc_Debug.Log('400: Entered get_rec', 2);
232: END IF;
233:
234: -- Get current database values
235: OPEN OKC_ARTICLE_VERSIONS_pk_csr (p_article_version_id);
236: FETCH OKC_ARTICLE_VERSIONS_pk_csr INTO
237: x_article_id,
238: x_article_version_number,
239: x_article_text,

Line 236: FETCH OKC_ARTICLE_VERSIONS_pk_csr INTO

232: END IF;
233:
234: -- Get current database values
235: OPEN OKC_ARTICLE_VERSIONS_pk_csr (p_article_version_id);
236: FETCH OKC_ARTICLE_VERSIONS_pk_csr INTO
237: x_article_id,
238: x_article_version_number,
239: x_article_text,
240: x_provision_yn,

Line 289: IF OKC_ARTICLE_VERSIONS_pk_csr%NOTFOUND THEN

285: x_creation_date,
286: x_last_updated_by,
287: x_last_update_login,
288: x_last_update_date;
289: IF OKC_ARTICLE_VERSIONS_pk_csr%NOTFOUND THEN
290: RAISE NO_DATA_FOUND;
291: END IF;
292: CLOSE OKC_ARTICLE_VERSIONS_pk_csr;
293:

Line 292: CLOSE OKC_ARTICLE_VERSIONS_pk_csr;

288: x_last_update_date;
289: IF OKC_ARTICLE_VERSIONS_pk_csr%NOTFOUND THEN
290: RAISE NO_DATA_FOUND;
291: END IF;
292: CLOSE OKC_ARTICLE_VERSIONS_pk_csr;
293:
294: IF (l_debug = 'Y') THEN
295: Okc_Debug.Log('500: Leaving get_rec ', 2);
296: END IF;

Line 314: IF OKC_ARTICLE_VERSIONS_pk_csr%ISOPEN THEN

310: p_token1_value => sqlcode,
311: p_token2 => G_SQLERRM_TOKEN,
312: p_token2_value => sqlerrm);
313:
314: IF OKC_ARTICLE_VERSIONS_pk_csr%ISOPEN THEN
315: CLOSE OKC_ARTICLE_VERSIONS_pk_csr;
316: END IF;
317:
318: RETURN G_RET_STS_UNEXP_ERROR ;

Line 315: CLOSE OKC_ARTICLE_VERSIONS_pk_csr;

311: p_token2 => G_SQLERRM_TOKEN,
312: p_token2_value => sqlerrm);
313:
314: IF OKC_ARTICLE_VERSIONS_pk_csr%ISOPEN THEN
315: CLOSE OKC_ARTICLE_VERSIONS_pk_csr;
316: END IF;
317:
318: RETURN G_RET_STS_UNEXP_ERROR ;
319:

Line 323: -- Set_Attributes for:OKC_ARTICLE_VERSIONS --

319:
320: END Get_Rec;
321:
322: -----------------------------------------
323: -- Set_Attributes for:OKC_ARTICLE_VERSIONS --
324: -----------------------------------------
325: FUNCTION Set_Attributes(
326: p_article_version_id IN NUMBER,
327: p_article_id IN NUMBER,

Line 423: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;

419: x_attribute14 OUT NOCOPY VARCHAR2,
420: x_attribute15 OUT NOCOPY VARCHAR2
421: ) RETURN VARCHAR2 IS
422: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
423: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;
424: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
425: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
426: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
427: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;

Line 424: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;

420: x_attribute15 OUT NOCOPY VARCHAR2
421: ) RETURN VARCHAR2 IS
422: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
423: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;
424: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
425: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
426: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
427: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
428: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;

Line 425: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;

421: ) RETURN VARCHAR2 IS
422: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
423: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;
424: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
425: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
426: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
427: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
428: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;
429: BEGIN

Line 426: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;

422: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
423: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;
424: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
425: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
426: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
427: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
428: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;
429: BEGIN
430: IF (l_debug = 'Y') THEN

Line 427: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;

423: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;
424: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
425: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
426: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
427: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
428: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;
429: BEGIN
430: IF (l_debug = 'Y') THEN
431: Okc_Debug.Log('700: Entered Set_Attributes ', 2);

Line 428: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;

424: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
425: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
426: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
427: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
428: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;
429: BEGIN
430: IF (l_debug = 'Y') THEN
431: Okc_Debug.Log('700: Entered Set_Attributes ', 2);
432: END IF;

Line 865: -- Validate_Attributes for: OKC_ARTICLE_VERSIONS --

861:
862: END Set_Attributes ;
863:
864: ----------------------------------------------
865: -- Validate_Attributes for: OKC_ARTICLE_VERSIONS --
866: ----------------------------------------------
867: FUNCTION Validate_Attributes (
868: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
869: p_import_action IN VARCHAR2 := NULL,

Line 923: l_dummy_date OKC_ARTICLE_VERSIONS.DATE_PUBLISHED%TYPE;

919: ) RETURN VARCHAR2 IS
920: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
921: l_tmp_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
922: l_dummy_var VARCHAR2(1) := '?';
923: l_dummy_date OKC_ARTICLE_VERSIONS.DATE_PUBLISHED%TYPE;
924:
925:
926: CURSOR l_article_language_csr(p_article_id IN NUMBER, p_article_language IN VARCHAR2) is
927: SELECT '!'

Line 934: FROM OKC_ARTICLES_ALL AA,OKC_ARTICLE_VERSIONS AV

930: AND ARTICLE_ID = p_article_id;
931:
932: CURSOR l_std_article_version_id_csr is
933: SELECT '!'
934: FROM OKC_ARTICLES_ALL AA,OKC_ARTICLE_VERSIONS AV
935: WHERE AA.ARTICLE_ID = AV.ARTICLE_ID
936: AND AV.ARTICLE_VERSION_ID = p_std_article_version_id
937: AND AA.STANDARD_YN = 'Y';
938:

Line 942: FROM OKC_ARTICLE_VERSIONS AV

938:
939: -- Below Added for FAR/DFAR Import
940: CURSOR l_date_published_csr is
941: SELECT av.date_published
942: FROM OKC_ARTICLE_VERSIONS AV
943: WHERE AV.ARTICLE_VERSION_ID = p_article_version_id;
944:
945: BEGIN
946:

Line 1269: okc_article_versions v,

1265: c_provision_yn in varchar2)
1266: IS
1267: select 'E' result
1268: from
1269: okc_article_versions v,
1270: okc_article_relatns_all r
1271: where
1272: r.source_article_id = c_source_article_id
1273: and

Line 1295: -- Validate_Record for:OKC_ARTICLE_VERSIONS --

1291: -- PROCEDURE Validate_Record
1292: -- It calls Item Level Validations and then makes Record Level Validations
1293: ---------------------------------------------------------------------------
1294: ------------------------------------------
1295: -- Validate_Record for:OKC_ARTICLE_VERSIONS --
1296: ------------------------------------------
1297: FUNCTION Validate_Record (
1298: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1299: p_import_action IN VARCHAR2 := NULL,

Line 1380: okc_article_versions av

1376: av.article_version_number,
1377: av.article_version_id,
1378: av.date_published
1379: from
1380: okc_article_versions av
1381: where
1382: av.article_id = p_article_id
1383: and
1384: av.start_date = (select

Line 1387: okc_article_versions av1

1383: and
1384: av.start_date = (select
1385: max(av1.start_date)
1386: from
1387: okc_article_versions av1
1388: where
1389: av1.article_id = av.article_id
1390: and
1391: av1.article_version_id <> p_article_version_id

Line 1411: FROM OKC_ARTICLE_VERSIONS A

1407: A.START_DATE, A.END_DATE,
1408: MAX(A.START_DATE) OVER (PARTITION BY A.ARTICLE_ID) AS MAX_START_DATE,
1409: A.ARTICLE_VERSION_NUMBER,
1410: A.ARTICLE_VERSION_ID
1411: FROM OKC_ARTICLE_VERSIONS A
1412: WHERE A.ARTICLE_ID = p_article_id
1413: AND ARTICLE_VERSION_ID <> p_article_version_id
1414: ) S
1415: WHERE S.START_DATE = S.MAX_START_DATE;

Line 1427: FROM OKC_ARTICLE_VERSIONS AVN, OKC_ARTICLE_ADOPTIONS ADP

1423: -- Bug#3672511: Validation of start date of a localized clause should be >= start date of global clause.
1424:
1425: CURSOR l_global_csr(p_article_version_id IN NUMBER, p_local_org_id IN NUMBER) is
1426: SELECT start_date
1427: FROM OKC_ARTICLE_VERSIONS AVN, OKC_ARTICLE_ADOPTIONS ADP
1428: WHERE ARTICLE_VERSION_ID = GLOBAL_ARTICLE_VERSION_ID
1429: AND LOCAL_ARTICLE_VERSION_ID = p_article_version_id
1430: AND LOCAL_ORG_ID = p_local_org_id
1431: AND ADP.ADOPTION_TYPE = 'LOCALIZED' ;

Line 1838: -- validate_row for:OKC_ARTICLE_VERSIONS --

1834: ---------------------------------------------------------------------------
1835: -- PROCEDURE validate_row
1836: ---------------------------------------------------------------------------
1837: ---------------------------------------
1838: -- validate_row for:OKC_ARTICLE_VERSIONS --
1839: ---------------------------------------
1840: PROCEDURE validate_row(
1841: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1842: p_import_action IN VARCHAR2 := NULL,

Line 1901: l_article_id OKC_ARTICLE_VERSIONS.ARTICLE_ID%TYPE;

1897: p_attribute15 IN VARCHAR2 := NULL,
1898:
1899: p_object_version_number IN NUMBER
1900: ) IS
1901: l_article_id OKC_ARTICLE_VERSIONS.ARTICLE_ID%TYPE;
1902: l_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
1903: l_article_text OKC_ARTICLE_VERSIONS.ARTICLE_TEXT%TYPE;
1904: l_provision_yn OKC_ARTICLE_VERSIONS.PROVISION_YN%TYPE;
1905: l_insert_by_reference OKC_ARTICLE_VERSIONS.INSERT_BY_REFERENCE%TYPE;

Line 1902: l_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;

1898:
1899: p_object_version_number IN NUMBER
1900: ) IS
1901: l_article_id OKC_ARTICLE_VERSIONS.ARTICLE_ID%TYPE;
1902: l_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
1903: l_article_text OKC_ARTICLE_VERSIONS.ARTICLE_TEXT%TYPE;
1904: l_provision_yn OKC_ARTICLE_VERSIONS.PROVISION_YN%TYPE;
1905: l_insert_by_reference OKC_ARTICLE_VERSIONS.INSERT_BY_REFERENCE%TYPE;
1906: l_lock_text OKC_ARTICLE_VERSIONS.LOCK_TEXT%TYPE;

Line 1903: l_article_text OKC_ARTICLE_VERSIONS.ARTICLE_TEXT%TYPE;

1899: p_object_version_number IN NUMBER
1900: ) IS
1901: l_article_id OKC_ARTICLE_VERSIONS.ARTICLE_ID%TYPE;
1902: l_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
1903: l_article_text OKC_ARTICLE_VERSIONS.ARTICLE_TEXT%TYPE;
1904: l_provision_yn OKC_ARTICLE_VERSIONS.PROVISION_YN%TYPE;
1905: l_insert_by_reference OKC_ARTICLE_VERSIONS.INSERT_BY_REFERENCE%TYPE;
1906: l_lock_text OKC_ARTICLE_VERSIONS.LOCK_TEXT%TYPE;
1907: l_global_yn OKC_ARTICLE_VERSIONS.GLOBAL_YN%TYPE;

Line 1904: l_provision_yn OKC_ARTICLE_VERSIONS.PROVISION_YN%TYPE;

1900: ) IS
1901: l_article_id OKC_ARTICLE_VERSIONS.ARTICLE_ID%TYPE;
1902: l_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
1903: l_article_text OKC_ARTICLE_VERSIONS.ARTICLE_TEXT%TYPE;
1904: l_provision_yn OKC_ARTICLE_VERSIONS.PROVISION_YN%TYPE;
1905: l_insert_by_reference OKC_ARTICLE_VERSIONS.INSERT_BY_REFERENCE%TYPE;
1906: l_lock_text OKC_ARTICLE_VERSIONS.LOCK_TEXT%TYPE;
1907: l_global_yn OKC_ARTICLE_VERSIONS.GLOBAL_YN%TYPE;
1908: l_article_language OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;

Line 1905: l_insert_by_reference OKC_ARTICLE_VERSIONS.INSERT_BY_REFERENCE%TYPE;

1901: l_article_id OKC_ARTICLE_VERSIONS.ARTICLE_ID%TYPE;
1902: l_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
1903: l_article_text OKC_ARTICLE_VERSIONS.ARTICLE_TEXT%TYPE;
1904: l_provision_yn OKC_ARTICLE_VERSIONS.PROVISION_YN%TYPE;
1905: l_insert_by_reference OKC_ARTICLE_VERSIONS.INSERT_BY_REFERENCE%TYPE;
1906: l_lock_text OKC_ARTICLE_VERSIONS.LOCK_TEXT%TYPE;
1907: l_global_yn OKC_ARTICLE_VERSIONS.GLOBAL_YN%TYPE;
1908: l_article_language OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;
1909: l_article_language_out OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;

Line 1906: l_lock_text OKC_ARTICLE_VERSIONS.LOCK_TEXT%TYPE;

1902: l_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
1903: l_article_text OKC_ARTICLE_VERSIONS.ARTICLE_TEXT%TYPE;
1904: l_provision_yn OKC_ARTICLE_VERSIONS.PROVISION_YN%TYPE;
1905: l_insert_by_reference OKC_ARTICLE_VERSIONS.INSERT_BY_REFERENCE%TYPE;
1906: l_lock_text OKC_ARTICLE_VERSIONS.LOCK_TEXT%TYPE;
1907: l_global_yn OKC_ARTICLE_VERSIONS.GLOBAL_YN%TYPE;
1908: l_article_language OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;
1909: l_article_language_out OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;
1910: l_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;

Line 1907: l_global_yn OKC_ARTICLE_VERSIONS.GLOBAL_YN%TYPE;

1903: l_article_text OKC_ARTICLE_VERSIONS.ARTICLE_TEXT%TYPE;
1904: l_provision_yn OKC_ARTICLE_VERSIONS.PROVISION_YN%TYPE;
1905: l_insert_by_reference OKC_ARTICLE_VERSIONS.INSERT_BY_REFERENCE%TYPE;
1906: l_lock_text OKC_ARTICLE_VERSIONS.LOCK_TEXT%TYPE;
1907: l_global_yn OKC_ARTICLE_VERSIONS.GLOBAL_YN%TYPE;
1908: l_article_language OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;
1909: l_article_language_out OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;
1910: l_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
1911: l_sav_release OKC_ARTICLE_VERSIONS.SAV_RELEASE%TYPE;

Line 1908: l_article_language OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;

1904: l_provision_yn OKC_ARTICLE_VERSIONS.PROVISION_YN%TYPE;
1905: l_insert_by_reference OKC_ARTICLE_VERSIONS.INSERT_BY_REFERENCE%TYPE;
1906: l_lock_text OKC_ARTICLE_VERSIONS.LOCK_TEXT%TYPE;
1907: l_global_yn OKC_ARTICLE_VERSIONS.GLOBAL_YN%TYPE;
1908: l_article_language OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;
1909: l_article_language_out OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;
1910: l_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
1911: l_sav_release OKC_ARTICLE_VERSIONS.SAV_RELEASE%TYPE;
1912: l_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE;

Line 1909: l_article_language_out OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;

1905: l_insert_by_reference OKC_ARTICLE_VERSIONS.INSERT_BY_REFERENCE%TYPE;
1906: l_lock_text OKC_ARTICLE_VERSIONS.LOCK_TEXT%TYPE;
1907: l_global_yn OKC_ARTICLE_VERSIONS.GLOBAL_YN%TYPE;
1908: l_article_language OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;
1909: l_article_language_out OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;
1910: l_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
1911: l_sav_release OKC_ARTICLE_VERSIONS.SAV_RELEASE%TYPE;
1912: l_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE;
1913: l_end_date OKC_ARTICLE_VERSIONS.END_DATE%TYPE;

Line 1910: l_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;

1906: l_lock_text OKC_ARTICLE_VERSIONS.LOCK_TEXT%TYPE;
1907: l_global_yn OKC_ARTICLE_VERSIONS.GLOBAL_YN%TYPE;
1908: l_article_language OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;
1909: l_article_language_out OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;
1910: l_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
1911: l_sav_release OKC_ARTICLE_VERSIONS.SAV_RELEASE%TYPE;
1912: l_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE;
1913: l_end_date OKC_ARTICLE_VERSIONS.END_DATE%TYPE;
1914: l_std_article_version_id OKC_ARTICLE_VERSIONS.STD_ARTICLE_VERSION_ID%TYPE;

Line 1911: l_sav_release OKC_ARTICLE_VERSIONS.SAV_RELEASE%TYPE;

1907: l_global_yn OKC_ARTICLE_VERSIONS.GLOBAL_YN%TYPE;
1908: l_article_language OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;
1909: l_article_language_out OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;
1910: l_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
1911: l_sav_release OKC_ARTICLE_VERSIONS.SAV_RELEASE%TYPE;
1912: l_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE;
1913: l_end_date OKC_ARTICLE_VERSIONS.END_DATE%TYPE;
1914: l_std_article_version_id OKC_ARTICLE_VERSIONS.STD_ARTICLE_VERSION_ID%TYPE;
1915: l_display_name OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE;

Line 1912: l_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE;

1908: l_article_language OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;
1909: l_article_language_out OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;
1910: l_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
1911: l_sav_release OKC_ARTICLE_VERSIONS.SAV_RELEASE%TYPE;
1912: l_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE;
1913: l_end_date OKC_ARTICLE_VERSIONS.END_DATE%TYPE;
1914: l_std_article_version_id OKC_ARTICLE_VERSIONS.STD_ARTICLE_VERSION_ID%TYPE;
1915: l_display_name OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE;
1916: l_translated_yn OKC_ARTICLE_VERSIONS.TRANSLATED_YN%TYPE;

Line 1913: l_end_date OKC_ARTICLE_VERSIONS.END_DATE%TYPE;

1909: l_article_language_out OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;
1910: l_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
1911: l_sav_release OKC_ARTICLE_VERSIONS.SAV_RELEASE%TYPE;
1912: l_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE;
1913: l_end_date OKC_ARTICLE_VERSIONS.END_DATE%TYPE;
1914: l_std_article_version_id OKC_ARTICLE_VERSIONS.STD_ARTICLE_VERSION_ID%TYPE;
1915: l_display_name OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE;
1916: l_translated_yn OKC_ARTICLE_VERSIONS.TRANSLATED_YN%TYPE;
1917: l_article_description OKC_ARTICLE_VERSIONS.ARTICLE_DESCRIPTION%TYPE;

Line 1914: l_std_article_version_id OKC_ARTICLE_VERSIONS.STD_ARTICLE_VERSION_ID%TYPE;

1910: l_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
1911: l_sav_release OKC_ARTICLE_VERSIONS.SAV_RELEASE%TYPE;
1912: l_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE;
1913: l_end_date OKC_ARTICLE_VERSIONS.END_DATE%TYPE;
1914: l_std_article_version_id OKC_ARTICLE_VERSIONS.STD_ARTICLE_VERSION_ID%TYPE;
1915: l_display_name OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE;
1916: l_translated_yn OKC_ARTICLE_VERSIONS.TRANSLATED_YN%TYPE;
1917: l_article_description OKC_ARTICLE_VERSIONS.ARTICLE_DESCRIPTION%TYPE;
1918: l_date_approved OKC_ARTICLE_VERSIONS.DATE_APPROVED%TYPE;

Line 1915: l_display_name OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE;

1911: l_sav_release OKC_ARTICLE_VERSIONS.SAV_RELEASE%TYPE;
1912: l_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE;
1913: l_end_date OKC_ARTICLE_VERSIONS.END_DATE%TYPE;
1914: l_std_article_version_id OKC_ARTICLE_VERSIONS.STD_ARTICLE_VERSION_ID%TYPE;
1915: l_display_name OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE;
1916: l_translated_yn OKC_ARTICLE_VERSIONS.TRANSLATED_YN%TYPE;
1917: l_article_description OKC_ARTICLE_VERSIONS.ARTICLE_DESCRIPTION%TYPE;
1918: l_date_approved OKC_ARTICLE_VERSIONS.DATE_APPROVED%TYPE;
1919: l_default_section OKC_ARTICLE_VERSIONS.DEFAULT_SECTION%TYPE;

Line 1916: l_translated_yn OKC_ARTICLE_VERSIONS.TRANSLATED_YN%TYPE;

1912: l_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE;
1913: l_end_date OKC_ARTICLE_VERSIONS.END_DATE%TYPE;
1914: l_std_article_version_id OKC_ARTICLE_VERSIONS.STD_ARTICLE_VERSION_ID%TYPE;
1915: l_display_name OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE;
1916: l_translated_yn OKC_ARTICLE_VERSIONS.TRANSLATED_YN%TYPE;
1917: l_article_description OKC_ARTICLE_VERSIONS.ARTICLE_DESCRIPTION%TYPE;
1918: l_date_approved OKC_ARTICLE_VERSIONS.DATE_APPROVED%TYPE;
1919: l_default_section OKC_ARTICLE_VERSIONS.DEFAULT_SECTION%TYPE;
1920: l_reference_source OKC_ARTICLE_VERSIONS.REFERENCE_SOURCE%TYPE;

Line 1917: l_article_description OKC_ARTICLE_VERSIONS.ARTICLE_DESCRIPTION%TYPE;

1913: l_end_date OKC_ARTICLE_VERSIONS.END_DATE%TYPE;
1914: l_std_article_version_id OKC_ARTICLE_VERSIONS.STD_ARTICLE_VERSION_ID%TYPE;
1915: l_display_name OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE;
1916: l_translated_yn OKC_ARTICLE_VERSIONS.TRANSLATED_YN%TYPE;
1917: l_article_description OKC_ARTICLE_VERSIONS.ARTICLE_DESCRIPTION%TYPE;
1918: l_date_approved OKC_ARTICLE_VERSIONS.DATE_APPROVED%TYPE;
1919: l_default_section OKC_ARTICLE_VERSIONS.DEFAULT_SECTION%TYPE;
1920: l_reference_source OKC_ARTICLE_VERSIONS.REFERENCE_SOURCE%TYPE;
1921: l_reference_text OKC_ARTICLE_VERSIONS.REFERENCE_TEXT%TYPE;

Line 1918: l_date_approved OKC_ARTICLE_VERSIONS.DATE_APPROVED%TYPE;

1914: l_std_article_version_id OKC_ARTICLE_VERSIONS.STD_ARTICLE_VERSION_ID%TYPE;
1915: l_display_name OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE;
1916: l_translated_yn OKC_ARTICLE_VERSIONS.TRANSLATED_YN%TYPE;
1917: l_article_description OKC_ARTICLE_VERSIONS.ARTICLE_DESCRIPTION%TYPE;
1918: l_date_approved OKC_ARTICLE_VERSIONS.DATE_APPROVED%TYPE;
1919: l_default_section OKC_ARTICLE_VERSIONS.DEFAULT_SECTION%TYPE;
1920: l_reference_source OKC_ARTICLE_VERSIONS.REFERENCE_SOURCE%TYPE;
1921: l_reference_text OKC_ARTICLE_VERSIONS.REFERENCE_TEXT%TYPE;
1922: l_orig_system_reference_code OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_CODE%TYPE;

Line 1919: l_default_section OKC_ARTICLE_VERSIONS.DEFAULT_SECTION%TYPE;

1915: l_display_name OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE;
1916: l_translated_yn OKC_ARTICLE_VERSIONS.TRANSLATED_YN%TYPE;
1917: l_article_description OKC_ARTICLE_VERSIONS.ARTICLE_DESCRIPTION%TYPE;
1918: l_date_approved OKC_ARTICLE_VERSIONS.DATE_APPROVED%TYPE;
1919: l_default_section OKC_ARTICLE_VERSIONS.DEFAULT_SECTION%TYPE;
1920: l_reference_source OKC_ARTICLE_VERSIONS.REFERENCE_SOURCE%TYPE;
1921: l_reference_text OKC_ARTICLE_VERSIONS.REFERENCE_TEXT%TYPE;
1922: l_orig_system_reference_code OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
1923: l_orig_system_reference_id1 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID1%TYPE;

Line 1920: l_reference_source OKC_ARTICLE_VERSIONS.REFERENCE_SOURCE%TYPE;

1916: l_translated_yn OKC_ARTICLE_VERSIONS.TRANSLATED_YN%TYPE;
1917: l_article_description OKC_ARTICLE_VERSIONS.ARTICLE_DESCRIPTION%TYPE;
1918: l_date_approved OKC_ARTICLE_VERSIONS.DATE_APPROVED%TYPE;
1919: l_default_section OKC_ARTICLE_VERSIONS.DEFAULT_SECTION%TYPE;
1920: l_reference_source OKC_ARTICLE_VERSIONS.REFERENCE_SOURCE%TYPE;
1921: l_reference_text OKC_ARTICLE_VERSIONS.REFERENCE_TEXT%TYPE;
1922: l_orig_system_reference_code OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
1923: l_orig_system_reference_id1 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
1924: l_orig_system_reference_id2 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID2%TYPE;

Line 1921: l_reference_text OKC_ARTICLE_VERSIONS.REFERENCE_TEXT%TYPE;

1917: l_article_description OKC_ARTICLE_VERSIONS.ARTICLE_DESCRIPTION%TYPE;
1918: l_date_approved OKC_ARTICLE_VERSIONS.DATE_APPROVED%TYPE;
1919: l_default_section OKC_ARTICLE_VERSIONS.DEFAULT_SECTION%TYPE;
1920: l_reference_source OKC_ARTICLE_VERSIONS.REFERENCE_SOURCE%TYPE;
1921: l_reference_text OKC_ARTICLE_VERSIONS.REFERENCE_TEXT%TYPE;
1922: l_orig_system_reference_code OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
1923: l_orig_system_reference_id1 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
1924: l_orig_system_reference_id2 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
1925: l_additional_instructions OKC_ARTICLE_VERSIONS.ADDITIONAL_INSTRUCTIONS%TYPE;

Line 1922: l_orig_system_reference_code OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_CODE%TYPE;

1918: l_date_approved OKC_ARTICLE_VERSIONS.DATE_APPROVED%TYPE;
1919: l_default_section OKC_ARTICLE_VERSIONS.DEFAULT_SECTION%TYPE;
1920: l_reference_source OKC_ARTICLE_VERSIONS.REFERENCE_SOURCE%TYPE;
1921: l_reference_text OKC_ARTICLE_VERSIONS.REFERENCE_TEXT%TYPE;
1922: l_orig_system_reference_code OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
1923: l_orig_system_reference_id1 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
1924: l_orig_system_reference_id2 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
1925: l_additional_instructions OKC_ARTICLE_VERSIONS.ADDITIONAL_INSTRUCTIONS%TYPE;
1926: l_variation_description OKC_ARTICLE_VERSIONS.VARIATION_DESCRIPTION%TYPE;

Line 1923: l_orig_system_reference_id1 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID1%TYPE;

1919: l_default_section OKC_ARTICLE_VERSIONS.DEFAULT_SECTION%TYPE;
1920: l_reference_source OKC_ARTICLE_VERSIONS.REFERENCE_SOURCE%TYPE;
1921: l_reference_text OKC_ARTICLE_VERSIONS.REFERENCE_TEXT%TYPE;
1922: l_orig_system_reference_code OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
1923: l_orig_system_reference_id1 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
1924: l_orig_system_reference_id2 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
1925: l_additional_instructions OKC_ARTICLE_VERSIONS.ADDITIONAL_INSTRUCTIONS%TYPE;
1926: l_variation_description OKC_ARTICLE_VERSIONS.VARIATION_DESCRIPTION%TYPE;
1927: l_date_published OKC_ARTICLE_VERSIONS.DATE_PUBLISHED%TYPE;

Line 1924: l_orig_system_reference_id2 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID2%TYPE;

1920: l_reference_source OKC_ARTICLE_VERSIONS.REFERENCE_SOURCE%TYPE;
1921: l_reference_text OKC_ARTICLE_VERSIONS.REFERENCE_TEXT%TYPE;
1922: l_orig_system_reference_code OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
1923: l_orig_system_reference_id1 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
1924: l_orig_system_reference_id2 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
1925: l_additional_instructions OKC_ARTICLE_VERSIONS.ADDITIONAL_INSTRUCTIONS%TYPE;
1926: l_variation_description OKC_ARTICLE_VERSIONS.VARIATION_DESCRIPTION%TYPE;
1927: l_date_published OKC_ARTICLE_VERSIONS.DATE_PUBLISHED%TYPE;
1928: l_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE;

Line 1925: l_additional_instructions OKC_ARTICLE_VERSIONS.ADDITIONAL_INSTRUCTIONS%TYPE;

1921: l_reference_text OKC_ARTICLE_VERSIONS.REFERENCE_TEXT%TYPE;
1922: l_orig_system_reference_code OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
1923: l_orig_system_reference_id1 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
1924: l_orig_system_reference_id2 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
1925: l_additional_instructions OKC_ARTICLE_VERSIONS.ADDITIONAL_INSTRUCTIONS%TYPE;
1926: l_variation_description OKC_ARTICLE_VERSIONS.VARIATION_DESCRIPTION%TYPE;
1927: l_date_published OKC_ARTICLE_VERSIONS.DATE_PUBLISHED%TYPE;
1928: l_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE;
1929: l_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE;

Line 1926: l_variation_description OKC_ARTICLE_VERSIONS.VARIATION_DESCRIPTION%TYPE;

1922: l_orig_system_reference_code OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
1923: l_orig_system_reference_id1 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
1924: l_orig_system_reference_id2 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
1925: l_additional_instructions OKC_ARTICLE_VERSIONS.ADDITIONAL_INSTRUCTIONS%TYPE;
1926: l_variation_description OKC_ARTICLE_VERSIONS.VARIATION_DESCRIPTION%TYPE;
1927: l_date_published OKC_ARTICLE_VERSIONS.DATE_PUBLISHED%TYPE;
1928: l_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE;
1929: l_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE;
1930: l_program_application_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE;

Line 1927: l_date_published OKC_ARTICLE_VERSIONS.DATE_PUBLISHED%TYPE;

1923: l_orig_system_reference_id1 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
1924: l_orig_system_reference_id2 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
1925: l_additional_instructions OKC_ARTICLE_VERSIONS.ADDITIONAL_INSTRUCTIONS%TYPE;
1926: l_variation_description OKC_ARTICLE_VERSIONS.VARIATION_DESCRIPTION%TYPE;
1927: l_date_published OKC_ARTICLE_VERSIONS.DATE_PUBLISHED%TYPE;
1928: l_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE;
1929: l_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE;
1930: l_program_application_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE;
1931: l_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE;

Line 1928: l_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE;

1924: l_orig_system_reference_id2 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
1925: l_additional_instructions OKC_ARTICLE_VERSIONS.ADDITIONAL_INSTRUCTIONS%TYPE;
1926: l_variation_description OKC_ARTICLE_VERSIONS.VARIATION_DESCRIPTION%TYPE;
1927: l_date_published OKC_ARTICLE_VERSIONS.DATE_PUBLISHED%TYPE;
1928: l_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE;
1929: l_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE;
1930: l_program_application_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE;
1931: l_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE;
1932: l_attribute_category OKC_ARTICLE_VERSIONS.ATTRIBUTE_CATEGORY%TYPE;

Line 1929: l_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE;

1925: l_additional_instructions OKC_ARTICLE_VERSIONS.ADDITIONAL_INSTRUCTIONS%TYPE;
1926: l_variation_description OKC_ARTICLE_VERSIONS.VARIATION_DESCRIPTION%TYPE;
1927: l_date_published OKC_ARTICLE_VERSIONS.DATE_PUBLISHED%TYPE;
1928: l_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE;
1929: l_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE;
1930: l_program_application_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE;
1931: l_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE;
1932: l_attribute_category OKC_ARTICLE_VERSIONS.ATTRIBUTE_CATEGORY%TYPE;
1933: l_attribute1 OKC_ARTICLE_VERSIONS.ATTRIBUTE1%TYPE;

Line 1930: l_program_application_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE;

1926: l_variation_description OKC_ARTICLE_VERSIONS.VARIATION_DESCRIPTION%TYPE;
1927: l_date_published OKC_ARTICLE_VERSIONS.DATE_PUBLISHED%TYPE;
1928: l_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE;
1929: l_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE;
1930: l_program_application_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE;
1931: l_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE;
1932: l_attribute_category OKC_ARTICLE_VERSIONS.ATTRIBUTE_CATEGORY%TYPE;
1933: l_attribute1 OKC_ARTICLE_VERSIONS.ATTRIBUTE1%TYPE;
1934: l_attribute2 OKC_ARTICLE_VERSIONS.ATTRIBUTE2%TYPE;

Line 1931: l_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE;

1927: l_date_published OKC_ARTICLE_VERSIONS.DATE_PUBLISHED%TYPE;
1928: l_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE;
1929: l_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE;
1930: l_program_application_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE;
1931: l_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE;
1932: l_attribute_category OKC_ARTICLE_VERSIONS.ATTRIBUTE_CATEGORY%TYPE;
1933: l_attribute1 OKC_ARTICLE_VERSIONS.ATTRIBUTE1%TYPE;
1934: l_attribute2 OKC_ARTICLE_VERSIONS.ATTRIBUTE2%TYPE;
1935: l_attribute3 OKC_ARTICLE_VERSIONS.ATTRIBUTE3%TYPE;

Line 1932: l_attribute_category OKC_ARTICLE_VERSIONS.ATTRIBUTE_CATEGORY%TYPE;

1928: l_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE;
1929: l_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE;
1930: l_program_application_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE;
1931: l_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE;
1932: l_attribute_category OKC_ARTICLE_VERSIONS.ATTRIBUTE_CATEGORY%TYPE;
1933: l_attribute1 OKC_ARTICLE_VERSIONS.ATTRIBUTE1%TYPE;
1934: l_attribute2 OKC_ARTICLE_VERSIONS.ATTRIBUTE2%TYPE;
1935: l_attribute3 OKC_ARTICLE_VERSIONS.ATTRIBUTE3%TYPE;
1936: l_attribute4 OKC_ARTICLE_VERSIONS.ATTRIBUTE4%TYPE;

Line 1933: l_attribute1 OKC_ARTICLE_VERSIONS.ATTRIBUTE1%TYPE;

1929: l_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE;
1930: l_program_application_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE;
1931: l_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE;
1932: l_attribute_category OKC_ARTICLE_VERSIONS.ATTRIBUTE_CATEGORY%TYPE;
1933: l_attribute1 OKC_ARTICLE_VERSIONS.ATTRIBUTE1%TYPE;
1934: l_attribute2 OKC_ARTICLE_VERSIONS.ATTRIBUTE2%TYPE;
1935: l_attribute3 OKC_ARTICLE_VERSIONS.ATTRIBUTE3%TYPE;
1936: l_attribute4 OKC_ARTICLE_VERSIONS.ATTRIBUTE4%TYPE;
1937: l_attribute5 OKC_ARTICLE_VERSIONS.ATTRIBUTE5%TYPE;

Line 1934: l_attribute2 OKC_ARTICLE_VERSIONS.ATTRIBUTE2%TYPE;

1930: l_program_application_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE;
1931: l_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE;
1932: l_attribute_category OKC_ARTICLE_VERSIONS.ATTRIBUTE_CATEGORY%TYPE;
1933: l_attribute1 OKC_ARTICLE_VERSIONS.ATTRIBUTE1%TYPE;
1934: l_attribute2 OKC_ARTICLE_VERSIONS.ATTRIBUTE2%TYPE;
1935: l_attribute3 OKC_ARTICLE_VERSIONS.ATTRIBUTE3%TYPE;
1936: l_attribute4 OKC_ARTICLE_VERSIONS.ATTRIBUTE4%TYPE;
1937: l_attribute5 OKC_ARTICLE_VERSIONS.ATTRIBUTE5%TYPE;
1938: l_attribute6 OKC_ARTICLE_VERSIONS.ATTRIBUTE6%TYPE;

Line 1935: l_attribute3 OKC_ARTICLE_VERSIONS.ATTRIBUTE3%TYPE;

1931: l_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE;
1932: l_attribute_category OKC_ARTICLE_VERSIONS.ATTRIBUTE_CATEGORY%TYPE;
1933: l_attribute1 OKC_ARTICLE_VERSIONS.ATTRIBUTE1%TYPE;
1934: l_attribute2 OKC_ARTICLE_VERSIONS.ATTRIBUTE2%TYPE;
1935: l_attribute3 OKC_ARTICLE_VERSIONS.ATTRIBUTE3%TYPE;
1936: l_attribute4 OKC_ARTICLE_VERSIONS.ATTRIBUTE4%TYPE;
1937: l_attribute5 OKC_ARTICLE_VERSIONS.ATTRIBUTE5%TYPE;
1938: l_attribute6 OKC_ARTICLE_VERSIONS.ATTRIBUTE6%TYPE;
1939: l_attribute7 OKC_ARTICLE_VERSIONS.ATTRIBUTE7%TYPE;

Line 1936: l_attribute4 OKC_ARTICLE_VERSIONS.ATTRIBUTE4%TYPE;

1932: l_attribute_category OKC_ARTICLE_VERSIONS.ATTRIBUTE_CATEGORY%TYPE;
1933: l_attribute1 OKC_ARTICLE_VERSIONS.ATTRIBUTE1%TYPE;
1934: l_attribute2 OKC_ARTICLE_VERSIONS.ATTRIBUTE2%TYPE;
1935: l_attribute3 OKC_ARTICLE_VERSIONS.ATTRIBUTE3%TYPE;
1936: l_attribute4 OKC_ARTICLE_VERSIONS.ATTRIBUTE4%TYPE;
1937: l_attribute5 OKC_ARTICLE_VERSIONS.ATTRIBUTE5%TYPE;
1938: l_attribute6 OKC_ARTICLE_VERSIONS.ATTRIBUTE6%TYPE;
1939: l_attribute7 OKC_ARTICLE_VERSIONS.ATTRIBUTE7%TYPE;
1940: l_attribute8 OKC_ARTICLE_VERSIONS.ATTRIBUTE8%TYPE;

Line 1937: l_attribute5 OKC_ARTICLE_VERSIONS.ATTRIBUTE5%TYPE;

1933: l_attribute1 OKC_ARTICLE_VERSIONS.ATTRIBUTE1%TYPE;
1934: l_attribute2 OKC_ARTICLE_VERSIONS.ATTRIBUTE2%TYPE;
1935: l_attribute3 OKC_ARTICLE_VERSIONS.ATTRIBUTE3%TYPE;
1936: l_attribute4 OKC_ARTICLE_VERSIONS.ATTRIBUTE4%TYPE;
1937: l_attribute5 OKC_ARTICLE_VERSIONS.ATTRIBUTE5%TYPE;
1938: l_attribute6 OKC_ARTICLE_VERSIONS.ATTRIBUTE6%TYPE;
1939: l_attribute7 OKC_ARTICLE_VERSIONS.ATTRIBUTE7%TYPE;
1940: l_attribute8 OKC_ARTICLE_VERSIONS.ATTRIBUTE8%TYPE;
1941: l_attribute9 OKC_ARTICLE_VERSIONS.ATTRIBUTE9%TYPE;

Line 1938: l_attribute6 OKC_ARTICLE_VERSIONS.ATTRIBUTE6%TYPE;

1934: l_attribute2 OKC_ARTICLE_VERSIONS.ATTRIBUTE2%TYPE;
1935: l_attribute3 OKC_ARTICLE_VERSIONS.ATTRIBUTE3%TYPE;
1936: l_attribute4 OKC_ARTICLE_VERSIONS.ATTRIBUTE4%TYPE;
1937: l_attribute5 OKC_ARTICLE_VERSIONS.ATTRIBUTE5%TYPE;
1938: l_attribute6 OKC_ARTICLE_VERSIONS.ATTRIBUTE6%TYPE;
1939: l_attribute7 OKC_ARTICLE_VERSIONS.ATTRIBUTE7%TYPE;
1940: l_attribute8 OKC_ARTICLE_VERSIONS.ATTRIBUTE8%TYPE;
1941: l_attribute9 OKC_ARTICLE_VERSIONS.ATTRIBUTE9%TYPE;
1942: l_attribute10 OKC_ARTICLE_VERSIONS.ATTRIBUTE10%TYPE;

Line 1939: l_attribute7 OKC_ARTICLE_VERSIONS.ATTRIBUTE7%TYPE;

1935: l_attribute3 OKC_ARTICLE_VERSIONS.ATTRIBUTE3%TYPE;
1936: l_attribute4 OKC_ARTICLE_VERSIONS.ATTRIBUTE4%TYPE;
1937: l_attribute5 OKC_ARTICLE_VERSIONS.ATTRIBUTE5%TYPE;
1938: l_attribute6 OKC_ARTICLE_VERSIONS.ATTRIBUTE6%TYPE;
1939: l_attribute7 OKC_ARTICLE_VERSIONS.ATTRIBUTE7%TYPE;
1940: l_attribute8 OKC_ARTICLE_VERSIONS.ATTRIBUTE8%TYPE;
1941: l_attribute9 OKC_ARTICLE_VERSIONS.ATTRIBUTE9%TYPE;
1942: l_attribute10 OKC_ARTICLE_VERSIONS.ATTRIBUTE10%TYPE;
1943: l_attribute11 OKC_ARTICLE_VERSIONS.ATTRIBUTE11%TYPE;

Line 1940: l_attribute8 OKC_ARTICLE_VERSIONS.ATTRIBUTE8%TYPE;

1936: l_attribute4 OKC_ARTICLE_VERSIONS.ATTRIBUTE4%TYPE;
1937: l_attribute5 OKC_ARTICLE_VERSIONS.ATTRIBUTE5%TYPE;
1938: l_attribute6 OKC_ARTICLE_VERSIONS.ATTRIBUTE6%TYPE;
1939: l_attribute7 OKC_ARTICLE_VERSIONS.ATTRIBUTE7%TYPE;
1940: l_attribute8 OKC_ARTICLE_VERSIONS.ATTRIBUTE8%TYPE;
1941: l_attribute9 OKC_ARTICLE_VERSIONS.ATTRIBUTE9%TYPE;
1942: l_attribute10 OKC_ARTICLE_VERSIONS.ATTRIBUTE10%TYPE;
1943: l_attribute11 OKC_ARTICLE_VERSIONS.ATTRIBUTE11%TYPE;
1944: l_attribute12 OKC_ARTICLE_VERSIONS.ATTRIBUTE12%TYPE;

Line 1941: l_attribute9 OKC_ARTICLE_VERSIONS.ATTRIBUTE9%TYPE;

1937: l_attribute5 OKC_ARTICLE_VERSIONS.ATTRIBUTE5%TYPE;
1938: l_attribute6 OKC_ARTICLE_VERSIONS.ATTRIBUTE6%TYPE;
1939: l_attribute7 OKC_ARTICLE_VERSIONS.ATTRIBUTE7%TYPE;
1940: l_attribute8 OKC_ARTICLE_VERSIONS.ATTRIBUTE8%TYPE;
1941: l_attribute9 OKC_ARTICLE_VERSIONS.ATTRIBUTE9%TYPE;
1942: l_attribute10 OKC_ARTICLE_VERSIONS.ATTRIBUTE10%TYPE;
1943: l_attribute11 OKC_ARTICLE_VERSIONS.ATTRIBUTE11%TYPE;
1944: l_attribute12 OKC_ARTICLE_VERSIONS.ATTRIBUTE12%TYPE;
1945: l_attribute13 OKC_ARTICLE_VERSIONS.ATTRIBUTE13%TYPE;

Line 1942: l_attribute10 OKC_ARTICLE_VERSIONS.ATTRIBUTE10%TYPE;

1938: l_attribute6 OKC_ARTICLE_VERSIONS.ATTRIBUTE6%TYPE;
1939: l_attribute7 OKC_ARTICLE_VERSIONS.ATTRIBUTE7%TYPE;
1940: l_attribute8 OKC_ARTICLE_VERSIONS.ATTRIBUTE8%TYPE;
1941: l_attribute9 OKC_ARTICLE_VERSIONS.ATTRIBUTE9%TYPE;
1942: l_attribute10 OKC_ARTICLE_VERSIONS.ATTRIBUTE10%TYPE;
1943: l_attribute11 OKC_ARTICLE_VERSIONS.ATTRIBUTE11%TYPE;
1944: l_attribute12 OKC_ARTICLE_VERSIONS.ATTRIBUTE12%TYPE;
1945: l_attribute13 OKC_ARTICLE_VERSIONS.ATTRIBUTE13%TYPE;
1946: l_attribute14 OKC_ARTICLE_VERSIONS.ATTRIBUTE14%TYPE;

Line 1943: l_attribute11 OKC_ARTICLE_VERSIONS.ATTRIBUTE11%TYPE;

1939: l_attribute7 OKC_ARTICLE_VERSIONS.ATTRIBUTE7%TYPE;
1940: l_attribute8 OKC_ARTICLE_VERSIONS.ATTRIBUTE8%TYPE;
1941: l_attribute9 OKC_ARTICLE_VERSIONS.ATTRIBUTE9%TYPE;
1942: l_attribute10 OKC_ARTICLE_VERSIONS.ATTRIBUTE10%TYPE;
1943: l_attribute11 OKC_ARTICLE_VERSIONS.ATTRIBUTE11%TYPE;
1944: l_attribute12 OKC_ARTICLE_VERSIONS.ATTRIBUTE12%TYPE;
1945: l_attribute13 OKC_ARTICLE_VERSIONS.ATTRIBUTE13%TYPE;
1946: l_attribute14 OKC_ARTICLE_VERSIONS.ATTRIBUTE14%TYPE;
1947: l_attribute15 OKC_ARTICLE_VERSIONS.ATTRIBUTE15%TYPE;

Line 1944: l_attribute12 OKC_ARTICLE_VERSIONS.ATTRIBUTE12%TYPE;

1940: l_attribute8 OKC_ARTICLE_VERSIONS.ATTRIBUTE8%TYPE;
1941: l_attribute9 OKC_ARTICLE_VERSIONS.ATTRIBUTE9%TYPE;
1942: l_attribute10 OKC_ARTICLE_VERSIONS.ATTRIBUTE10%TYPE;
1943: l_attribute11 OKC_ARTICLE_VERSIONS.ATTRIBUTE11%TYPE;
1944: l_attribute12 OKC_ARTICLE_VERSIONS.ATTRIBUTE12%TYPE;
1945: l_attribute13 OKC_ARTICLE_VERSIONS.ATTRIBUTE13%TYPE;
1946: l_attribute14 OKC_ARTICLE_VERSIONS.ATTRIBUTE14%TYPE;
1947: l_attribute15 OKC_ARTICLE_VERSIONS.ATTRIBUTE15%TYPE;
1948: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;

Line 1945: l_attribute13 OKC_ARTICLE_VERSIONS.ATTRIBUTE13%TYPE;

1941: l_attribute9 OKC_ARTICLE_VERSIONS.ATTRIBUTE9%TYPE;
1942: l_attribute10 OKC_ARTICLE_VERSIONS.ATTRIBUTE10%TYPE;
1943: l_attribute11 OKC_ARTICLE_VERSIONS.ATTRIBUTE11%TYPE;
1944: l_attribute12 OKC_ARTICLE_VERSIONS.ATTRIBUTE12%TYPE;
1945: l_attribute13 OKC_ARTICLE_VERSIONS.ATTRIBUTE13%TYPE;
1946: l_attribute14 OKC_ARTICLE_VERSIONS.ATTRIBUTE14%TYPE;
1947: l_attribute15 OKC_ARTICLE_VERSIONS.ATTRIBUTE15%TYPE;
1948: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;
1949: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;

Line 1946: l_attribute14 OKC_ARTICLE_VERSIONS.ATTRIBUTE14%TYPE;

1942: l_attribute10 OKC_ARTICLE_VERSIONS.ATTRIBUTE10%TYPE;
1943: l_attribute11 OKC_ARTICLE_VERSIONS.ATTRIBUTE11%TYPE;
1944: l_attribute12 OKC_ARTICLE_VERSIONS.ATTRIBUTE12%TYPE;
1945: l_attribute13 OKC_ARTICLE_VERSIONS.ATTRIBUTE13%TYPE;
1946: l_attribute14 OKC_ARTICLE_VERSIONS.ATTRIBUTE14%TYPE;
1947: l_attribute15 OKC_ARTICLE_VERSIONS.ATTRIBUTE15%TYPE;
1948: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;
1949: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
1950: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;

Line 1947: l_attribute15 OKC_ARTICLE_VERSIONS.ATTRIBUTE15%TYPE;

1943: l_attribute11 OKC_ARTICLE_VERSIONS.ATTRIBUTE11%TYPE;
1944: l_attribute12 OKC_ARTICLE_VERSIONS.ATTRIBUTE12%TYPE;
1945: l_attribute13 OKC_ARTICLE_VERSIONS.ATTRIBUTE13%TYPE;
1946: l_attribute14 OKC_ARTICLE_VERSIONS.ATTRIBUTE14%TYPE;
1947: l_attribute15 OKC_ARTICLE_VERSIONS.ATTRIBUTE15%TYPE;
1948: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;
1949: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
1950: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
1951: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;

Line 1948: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;

1944: l_attribute12 OKC_ARTICLE_VERSIONS.ATTRIBUTE12%TYPE;
1945: l_attribute13 OKC_ARTICLE_VERSIONS.ATTRIBUTE13%TYPE;
1946: l_attribute14 OKC_ARTICLE_VERSIONS.ATTRIBUTE14%TYPE;
1947: l_attribute15 OKC_ARTICLE_VERSIONS.ATTRIBUTE15%TYPE;
1948: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;
1949: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
1950: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
1951: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
1952: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;

Line 1949: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;

1945: l_attribute13 OKC_ARTICLE_VERSIONS.ATTRIBUTE13%TYPE;
1946: l_attribute14 OKC_ARTICLE_VERSIONS.ATTRIBUTE14%TYPE;
1947: l_attribute15 OKC_ARTICLE_VERSIONS.ATTRIBUTE15%TYPE;
1948: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;
1949: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
1950: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
1951: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
1952: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
1953: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;

Line 1950: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;

1946: l_attribute14 OKC_ARTICLE_VERSIONS.ATTRIBUTE14%TYPE;
1947: l_attribute15 OKC_ARTICLE_VERSIONS.ATTRIBUTE15%TYPE;
1948: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;
1949: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
1950: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
1951: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
1952: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
1953: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;
1954: l_earlier_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;

Line 1951: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;

1947: l_attribute15 OKC_ARTICLE_VERSIONS.ATTRIBUTE15%TYPE;
1948: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;
1949: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
1950: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
1951: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
1952: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
1953: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;
1954: l_earlier_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
1955: l_earlier_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE;

Line 1952: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;

1948: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;
1949: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
1950: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
1951: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
1952: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
1953: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;
1954: l_earlier_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
1955: l_earlier_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE;
1956: BEGIN

Line 1953: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;

1949: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
1950: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
1951: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
1952: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
1953: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;
1954: l_earlier_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
1955: l_earlier_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE;
1956: BEGIN
1957:

Line 1954: l_earlier_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;

1950: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
1951: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
1952: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
1953: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;
1954: l_earlier_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
1955: l_earlier_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE;
1956: BEGIN
1957:
1958: IF (l_debug = 'Y') THEN

Line 1955: l_earlier_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE;

1951: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
1952: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
1953: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;
1954: l_earlier_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
1955: l_earlier_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE;
1956: BEGIN
1957:
1958: IF (l_debug = 'Y') THEN
1959: Okc_Debug.Log('3100: Entered validate_row', 2);

Line 2230: -- Insert_Row for:OKC_ARTICLE_VERSIONS --

2226: ---------------------------------------------------------------------------
2227: -- PROCEDURE Insert_Row
2228: ---------------------------------------------------------------------------
2229: -------------------------------------
2230: -- Insert_Row for:OKC_ARTICLE_VERSIONS --
2231: -------------------------------------
2232: FUNCTION Insert_Row(
2233: p_article_version_id IN NUMBER,
2234: p_article_id IN NUMBER,

Line 2291: l_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE;

2287:
2288: ) RETURN VARCHAR2 IS
2289:
2290:
2291: l_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE;
2292: l_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE;
2293: l_program_appl_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE;
2294: l_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE;
2295:

Line 2292: l_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE;

2288: ) RETURN VARCHAR2 IS
2289:
2290:
2291: l_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE;
2292: l_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE;
2293: l_program_appl_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE;
2294: l_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE;
2295:
2296:

Line 2293: l_program_appl_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE;

2289:
2290:
2291: l_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE;
2292: l_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE;
2293: l_program_appl_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE;
2294: l_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE;
2295:
2296:
2297: BEGIN

Line 2294: l_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE;

2290:
2291: l_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE;
2292: l_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE;
2293: l_program_appl_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE;
2294: l_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE;
2295:
2296:
2297: BEGIN
2298:

Line 2322: INSERT INTO OKC_ARTICLE_VERSIONS(

2318: ELSE
2319: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
2320: END IF;
2321:
2322: INSERT INTO OKC_ARTICLE_VERSIONS(
2323: ARTICLE_VERSION_ID,
2324: ARTICLE_ID,
2325: ARTICLE_VERSION_NUMBER,
2326: ARTICLE_TEXT,

Line 2459: -- Insert_Row for:OKC_ARTICLE_VERSIONS --

2455: END Insert_Row;
2456:
2457:
2458: -------------------------------------
2459: -- Insert_Row for:OKC_ARTICLE_VERSIONS --
2460: -------------------------------------
2461: PROCEDURE Insert_Row(
2462: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2463: x_return_status OUT NOCOPY VARCHAR2,

Line 2520: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;

2516: x_article_version_id OUT NOCOPY NUMBER
2517:
2518: ) IS
2519:
2520: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;
2521: l_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
2522: l_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
2523: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
2524: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;

Line 2521: l_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;

2517:
2518: ) IS
2519:
2520: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;
2521: l_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
2522: l_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
2523: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
2524: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
2525: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;

Line 2522: l_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;

2518: ) IS
2519:
2520: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;
2521: l_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
2522: l_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
2523: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
2524: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
2525: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
2526: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;

Line 2523: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;

2519:
2520: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;
2521: l_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
2522: l_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
2523: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
2524: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
2525: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
2526: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
2527: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;

Line 2524: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;

2520: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;
2521: l_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
2522: l_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
2523: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
2524: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
2525: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
2526: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
2527: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;
2528: l_article_language OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;

Line 2525: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;

2521: l_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
2522: l_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
2523: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
2524: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
2525: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
2526: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
2527: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;
2528: l_article_language OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;
2529:

Line 2526: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;

2522: l_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
2523: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
2524: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
2525: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
2526: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
2527: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;
2528: l_article_language OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;
2529:
2530: BEGIN

Line 2527: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;

2523: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
2524: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
2525: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
2526: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
2527: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;
2528: l_article_language OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;
2529:
2530: BEGIN
2531:

Line 2528: l_article_language OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;

2524: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
2525: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
2526: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
2527: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;
2528: l_article_language OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;
2529:
2530: BEGIN
2531:
2532: x_return_status := G_RET_STS_SUCCESS;

Line 2762: -- Lock_Row for:OKC_ARTICLE_VERSIONS --

2758: ---------------------------------------------------------------------------
2759: -- PROCEDURE Lock_Row
2760: ---------------------------------------------------------------------------
2761: -----------------------------------
2762: -- Lock_Row for:OKC_ARTICLE_VERSIONS --
2763: -----------------------------------
2764: FUNCTION Lock_Row(
2765: p_article_version_id IN NUMBER,
2766: p_object_version_number IN NUMBER

Line 2774: FROM OKC_ARTICLE_VERSIONS

2770: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2771:
2772: CURSOR lock_csr (cp_article_version_id NUMBER, cp_object_version_number NUMBER) IS
2773: SELECT object_version_number
2774: FROM OKC_ARTICLE_VERSIONS
2775: WHERE ARTICLE_VERSION_ID = cp_article_version_id
2776: AND (object_version_number = cp_object_version_number OR cp_object_version_number IS NULL)
2777: FOR UPDATE OF object_version_number NOWAIT;
2778:

Line 2781: FROM OKC_ARTICLE_VERSIONS

2777: FOR UPDATE OF object_version_number NOWAIT;
2778:
2779: CURSOR lchk_csr (cp_article_version_id NUMBER) IS
2780: SELECT object_version_number
2781: FROM OKC_ARTICLE_VERSIONS
2782: WHERE ARTICLE_VERSION_ID = cp_article_version_id;
2783:
2784: l_return_status VARCHAR2(1);
2785:

Line 2786: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;

2782: WHERE ARTICLE_VERSION_ID = cp_article_version_id;
2783:
2784: l_return_status VARCHAR2(1);
2785:
2786: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;
2787:
2788: l_row_notfound BOOLEAN := FALSE;
2789: BEGIN
2790:

Line 2868: -- Lock_Row for:OKC_ARTICLE_VERSIONS --

2864: RETURN( G_RET_STS_UNEXP_ERROR );
2865: END Lock_Row;
2866:
2867: -----------------------------------
2868: -- Lock_Row for:OKC_ARTICLE_VERSIONS --
2869: -----------------------------------
2870: PROCEDURE Lock_Row(
2871: x_return_status OUT NOCOPY VARCHAR2,
2872:

Line 2932: -- Update_Row for:OKC_ARTICLE_VERSIONS --

2928: ---------------------------------------------------------------------------
2929: -- PROCEDURE Update_Row
2930: ---------------------------------------------------------------------------
2931: -------------------------------------
2932: -- Update_Row for:OKC_ARTICLE_VERSIONS --
2933: -------------------------------------
2934: FUNCTION Update_Row(
2935: p_article_version_id IN NUMBER,
2936: p_article_id IN NUMBER,

Line 2991: l_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE;

2987: p_last_update_date IN DATE
2988: ) RETURN VARCHAR2 IS
2989:
2990:
2991: l_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE;
2992: l_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE;
2993: l_program_appl_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE;
2994: l_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE;
2995:

Line 2992: l_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE;

2988: ) RETURN VARCHAR2 IS
2989:
2990:
2991: l_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE;
2992: l_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE;
2993: l_program_appl_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE;
2994: l_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE;
2995:
2996: BEGIN

Line 2993: l_program_appl_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE;

2989:
2990:
2991: l_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE;
2992: l_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE;
2993: l_program_appl_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE;
2994: l_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE;
2995:
2996: BEGIN
2997:

Line 2994: l_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE;

2990:
2991: l_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE;
2992: l_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE;
2993: l_program_appl_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE;
2994: l_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE;
2995:
2996: BEGIN
2997:
2998: IF (l_debug = 'Y') THEN

Line 3021: UPDATE OKC_ARTICLE_VERSIONS

3017: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
3018: END IF;
3019:
3020:
3021: UPDATE OKC_ARTICLE_VERSIONS
3022: SET ARTICLE_ID = p_article_id,
3023: -- ARTICLE_VERSION_NUMBER = p_article_version_number,
3024: ARTICLE_TEXT = p_article_text,
3025: PROVISION_YN = p_provision_yn,

Line 3100: -- Update_Row for:OKC_ARTICLE_VERSIONS --

3096:
3097: END Update_Row;
3098:
3099: -------------------------------------
3100: -- Update_Row for:OKC_ARTICLE_VERSIONS --
3101: -------------------------------------
3102: PROCEDURE Update_Row(
3103: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3104:

Line 3162: l_article_id OKC_ARTICLE_VERSIONS.ARTICLE_ID%TYPE;

3158: x_article_id OUT NOCOPY NUMBER,
3159: x_earlier_version_id OUT NOCOPY NUMBER
3160: ) IS
3161:
3162: l_article_id OKC_ARTICLE_VERSIONS.ARTICLE_ID%TYPE;
3163: l_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
3164: l_article_text OKC_ARTICLE_VERSIONS.ARTICLE_TEXT%TYPE;
3165: l_provision_yn OKC_ARTICLE_VERSIONS.PROVISION_YN%TYPE;
3166: l_insert_by_reference OKC_ARTICLE_VERSIONS.INSERT_BY_REFERENCE%TYPE;

Line 3163: l_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;

3159: x_earlier_version_id OUT NOCOPY NUMBER
3160: ) IS
3161:
3162: l_article_id OKC_ARTICLE_VERSIONS.ARTICLE_ID%TYPE;
3163: l_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
3164: l_article_text OKC_ARTICLE_VERSIONS.ARTICLE_TEXT%TYPE;
3165: l_provision_yn OKC_ARTICLE_VERSIONS.PROVISION_YN%TYPE;
3166: l_insert_by_reference OKC_ARTICLE_VERSIONS.INSERT_BY_REFERENCE%TYPE;
3167: l_lock_text OKC_ARTICLE_VERSIONS.LOCK_TEXT%TYPE;

Line 3164: l_article_text OKC_ARTICLE_VERSIONS.ARTICLE_TEXT%TYPE;

3160: ) IS
3161:
3162: l_article_id OKC_ARTICLE_VERSIONS.ARTICLE_ID%TYPE;
3163: l_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
3164: l_article_text OKC_ARTICLE_VERSIONS.ARTICLE_TEXT%TYPE;
3165: l_provision_yn OKC_ARTICLE_VERSIONS.PROVISION_YN%TYPE;
3166: l_insert_by_reference OKC_ARTICLE_VERSIONS.INSERT_BY_REFERENCE%TYPE;
3167: l_lock_text OKC_ARTICLE_VERSIONS.LOCK_TEXT%TYPE;
3168: l_global_yn OKC_ARTICLE_VERSIONS.GLOBAL_YN%TYPE;

Line 3165: l_provision_yn OKC_ARTICLE_VERSIONS.PROVISION_YN%TYPE;

3161:
3162: l_article_id OKC_ARTICLE_VERSIONS.ARTICLE_ID%TYPE;
3163: l_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
3164: l_article_text OKC_ARTICLE_VERSIONS.ARTICLE_TEXT%TYPE;
3165: l_provision_yn OKC_ARTICLE_VERSIONS.PROVISION_YN%TYPE;
3166: l_insert_by_reference OKC_ARTICLE_VERSIONS.INSERT_BY_REFERENCE%TYPE;
3167: l_lock_text OKC_ARTICLE_VERSIONS.LOCK_TEXT%TYPE;
3168: l_global_yn OKC_ARTICLE_VERSIONS.GLOBAL_YN%TYPE;
3169: l_article_language OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;

Line 3166: l_insert_by_reference OKC_ARTICLE_VERSIONS.INSERT_BY_REFERENCE%TYPE;

3162: l_article_id OKC_ARTICLE_VERSIONS.ARTICLE_ID%TYPE;
3163: l_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
3164: l_article_text OKC_ARTICLE_VERSIONS.ARTICLE_TEXT%TYPE;
3165: l_provision_yn OKC_ARTICLE_VERSIONS.PROVISION_YN%TYPE;
3166: l_insert_by_reference OKC_ARTICLE_VERSIONS.INSERT_BY_REFERENCE%TYPE;
3167: l_lock_text OKC_ARTICLE_VERSIONS.LOCK_TEXT%TYPE;
3168: l_global_yn OKC_ARTICLE_VERSIONS.GLOBAL_YN%TYPE;
3169: l_article_language OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;
3170: l_article_language_out OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;

Line 3167: l_lock_text OKC_ARTICLE_VERSIONS.LOCK_TEXT%TYPE;

3163: l_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
3164: l_article_text OKC_ARTICLE_VERSIONS.ARTICLE_TEXT%TYPE;
3165: l_provision_yn OKC_ARTICLE_VERSIONS.PROVISION_YN%TYPE;
3166: l_insert_by_reference OKC_ARTICLE_VERSIONS.INSERT_BY_REFERENCE%TYPE;
3167: l_lock_text OKC_ARTICLE_VERSIONS.LOCK_TEXT%TYPE;
3168: l_global_yn OKC_ARTICLE_VERSIONS.GLOBAL_YN%TYPE;
3169: l_article_language OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;
3170: l_article_language_out OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;
3171: l_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;

Line 3168: l_global_yn OKC_ARTICLE_VERSIONS.GLOBAL_YN%TYPE;

3164: l_article_text OKC_ARTICLE_VERSIONS.ARTICLE_TEXT%TYPE;
3165: l_provision_yn OKC_ARTICLE_VERSIONS.PROVISION_YN%TYPE;
3166: l_insert_by_reference OKC_ARTICLE_VERSIONS.INSERT_BY_REFERENCE%TYPE;
3167: l_lock_text OKC_ARTICLE_VERSIONS.LOCK_TEXT%TYPE;
3168: l_global_yn OKC_ARTICLE_VERSIONS.GLOBAL_YN%TYPE;
3169: l_article_language OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;
3170: l_article_language_out OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;
3171: l_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
3172: l_sav_release OKC_ARTICLE_VERSIONS.SAV_RELEASE%TYPE;

Line 3169: l_article_language OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;

3165: l_provision_yn OKC_ARTICLE_VERSIONS.PROVISION_YN%TYPE;
3166: l_insert_by_reference OKC_ARTICLE_VERSIONS.INSERT_BY_REFERENCE%TYPE;
3167: l_lock_text OKC_ARTICLE_VERSIONS.LOCK_TEXT%TYPE;
3168: l_global_yn OKC_ARTICLE_VERSIONS.GLOBAL_YN%TYPE;
3169: l_article_language OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;
3170: l_article_language_out OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;
3171: l_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
3172: l_sav_release OKC_ARTICLE_VERSIONS.SAV_RELEASE%TYPE;
3173: l_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE;

Line 3170: l_article_language_out OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;

3166: l_insert_by_reference OKC_ARTICLE_VERSIONS.INSERT_BY_REFERENCE%TYPE;
3167: l_lock_text OKC_ARTICLE_VERSIONS.LOCK_TEXT%TYPE;
3168: l_global_yn OKC_ARTICLE_VERSIONS.GLOBAL_YN%TYPE;
3169: l_article_language OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;
3170: l_article_language_out OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;
3171: l_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
3172: l_sav_release OKC_ARTICLE_VERSIONS.SAV_RELEASE%TYPE;
3173: l_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE;
3174: l_end_date OKC_ARTICLE_VERSIONS.END_DATE%TYPE;

Line 3171: l_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;

3167: l_lock_text OKC_ARTICLE_VERSIONS.LOCK_TEXT%TYPE;
3168: l_global_yn OKC_ARTICLE_VERSIONS.GLOBAL_YN%TYPE;
3169: l_article_language OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;
3170: l_article_language_out OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;
3171: l_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
3172: l_sav_release OKC_ARTICLE_VERSIONS.SAV_RELEASE%TYPE;
3173: l_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE;
3174: l_end_date OKC_ARTICLE_VERSIONS.END_DATE%TYPE;
3175: l_std_article_version_id OKC_ARTICLE_VERSIONS.STD_ARTICLE_VERSION_ID%TYPE;

Line 3172: l_sav_release OKC_ARTICLE_VERSIONS.SAV_RELEASE%TYPE;

3168: l_global_yn OKC_ARTICLE_VERSIONS.GLOBAL_YN%TYPE;
3169: l_article_language OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;
3170: l_article_language_out OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;
3171: l_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
3172: l_sav_release OKC_ARTICLE_VERSIONS.SAV_RELEASE%TYPE;
3173: l_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE;
3174: l_end_date OKC_ARTICLE_VERSIONS.END_DATE%TYPE;
3175: l_std_article_version_id OKC_ARTICLE_VERSIONS.STD_ARTICLE_VERSION_ID%TYPE;
3176: l_display_name OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE;

Line 3173: l_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE;

3169: l_article_language OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;
3170: l_article_language_out OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;
3171: l_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
3172: l_sav_release OKC_ARTICLE_VERSIONS.SAV_RELEASE%TYPE;
3173: l_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE;
3174: l_end_date OKC_ARTICLE_VERSIONS.END_DATE%TYPE;
3175: l_std_article_version_id OKC_ARTICLE_VERSIONS.STD_ARTICLE_VERSION_ID%TYPE;
3176: l_display_name OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE;
3177: l_translated_yn OKC_ARTICLE_VERSIONS.TRANSLATED_YN%TYPE;

Line 3174: l_end_date OKC_ARTICLE_VERSIONS.END_DATE%TYPE;

3170: l_article_language_out OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;
3171: l_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
3172: l_sav_release OKC_ARTICLE_VERSIONS.SAV_RELEASE%TYPE;
3173: l_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE;
3174: l_end_date OKC_ARTICLE_VERSIONS.END_DATE%TYPE;
3175: l_std_article_version_id OKC_ARTICLE_VERSIONS.STD_ARTICLE_VERSION_ID%TYPE;
3176: l_display_name OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE;
3177: l_translated_yn OKC_ARTICLE_VERSIONS.TRANSLATED_YN%TYPE;
3178: l_article_description OKC_ARTICLE_VERSIONS.ARTICLE_DESCRIPTION%TYPE;

Line 3175: l_std_article_version_id OKC_ARTICLE_VERSIONS.STD_ARTICLE_VERSION_ID%TYPE;

3171: l_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
3172: l_sav_release OKC_ARTICLE_VERSIONS.SAV_RELEASE%TYPE;
3173: l_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE;
3174: l_end_date OKC_ARTICLE_VERSIONS.END_DATE%TYPE;
3175: l_std_article_version_id OKC_ARTICLE_VERSIONS.STD_ARTICLE_VERSION_ID%TYPE;
3176: l_display_name OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE;
3177: l_translated_yn OKC_ARTICLE_VERSIONS.TRANSLATED_YN%TYPE;
3178: l_article_description OKC_ARTICLE_VERSIONS.ARTICLE_DESCRIPTION%TYPE;
3179: l_date_approved OKC_ARTICLE_VERSIONS.DATE_APPROVED%TYPE;

Line 3176: l_display_name OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE;

3172: l_sav_release OKC_ARTICLE_VERSIONS.SAV_RELEASE%TYPE;
3173: l_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE;
3174: l_end_date OKC_ARTICLE_VERSIONS.END_DATE%TYPE;
3175: l_std_article_version_id OKC_ARTICLE_VERSIONS.STD_ARTICLE_VERSION_ID%TYPE;
3176: l_display_name OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE;
3177: l_translated_yn OKC_ARTICLE_VERSIONS.TRANSLATED_YN%TYPE;
3178: l_article_description OKC_ARTICLE_VERSIONS.ARTICLE_DESCRIPTION%TYPE;
3179: l_date_approved OKC_ARTICLE_VERSIONS.DATE_APPROVED%TYPE;
3180: l_default_section OKC_ARTICLE_VERSIONS.DEFAULT_SECTION%TYPE;

Line 3177: l_translated_yn OKC_ARTICLE_VERSIONS.TRANSLATED_YN%TYPE;

3173: l_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE;
3174: l_end_date OKC_ARTICLE_VERSIONS.END_DATE%TYPE;
3175: l_std_article_version_id OKC_ARTICLE_VERSIONS.STD_ARTICLE_VERSION_ID%TYPE;
3176: l_display_name OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE;
3177: l_translated_yn OKC_ARTICLE_VERSIONS.TRANSLATED_YN%TYPE;
3178: l_article_description OKC_ARTICLE_VERSIONS.ARTICLE_DESCRIPTION%TYPE;
3179: l_date_approved OKC_ARTICLE_VERSIONS.DATE_APPROVED%TYPE;
3180: l_default_section OKC_ARTICLE_VERSIONS.DEFAULT_SECTION%TYPE;
3181: l_reference_source OKC_ARTICLE_VERSIONS.REFERENCE_SOURCE%TYPE;

Line 3178: l_article_description OKC_ARTICLE_VERSIONS.ARTICLE_DESCRIPTION%TYPE;

3174: l_end_date OKC_ARTICLE_VERSIONS.END_DATE%TYPE;
3175: l_std_article_version_id OKC_ARTICLE_VERSIONS.STD_ARTICLE_VERSION_ID%TYPE;
3176: l_display_name OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE;
3177: l_translated_yn OKC_ARTICLE_VERSIONS.TRANSLATED_YN%TYPE;
3178: l_article_description OKC_ARTICLE_VERSIONS.ARTICLE_DESCRIPTION%TYPE;
3179: l_date_approved OKC_ARTICLE_VERSIONS.DATE_APPROVED%TYPE;
3180: l_default_section OKC_ARTICLE_VERSIONS.DEFAULT_SECTION%TYPE;
3181: l_reference_source OKC_ARTICLE_VERSIONS.REFERENCE_SOURCE%TYPE;
3182: l_reference_text OKC_ARTICLE_VERSIONS.REFERENCE_TEXT%TYPE;

Line 3179: l_date_approved OKC_ARTICLE_VERSIONS.DATE_APPROVED%TYPE;

3175: l_std_article_version_id OKC_ARTICLE_VERSIONS.STD_ARTICLE_VERSION_ID%TYPE;
3176: l_display_name OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE;
3177: l_translated_yn OKC_ARTICLE_VERSIONS.TRANSLATED_YN%TYPE;
3178: l_article_description OKC_ARTICLE_VERSIONS.ARTICLE_DESCRIPTION%TYPE;
3179: l_date_approved OKC_ARTICLE_VERSIONS.DATE_APPROVED%TYPE;
3180: l_default_section OKC_ARTICLE_VERSIONS.DEFAULT_SECTION%TYPE;
3181: l_reference_source OKC_ARTICLE_VERSIONS.REFERENCE_SOURCE%TYPE;
3182: l_reference_text OKC_ARTICLE_VERSIONS.REFERENCE_TEXT%TYPE;
3183: l_orig_system_reference_code OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_CODE%TYPE;

Line 3180: l_default_section OKC_ARTICLE_VERSIONS.DEFAULT_SECTION%TYPE;

3176: l_display_name OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE;
3177: l_translated_yn OKC_ARTICLE_VERSIONS.TRANSLATED_YN%TYPE;
3178: l_article_description OKC_ARTICLE_VERSIONS.ARTICLE_DESCRIPTION%TYPE;
3179: l_date_approved OKC_ARTICLE_VERSIONS.DATE_APPROVED%TYPE;
3180: l_default_section OKC_ARTICLE_VERSIONS.DEFAULT_SECTION%TYPE;
3181: l_reference_source OKC_ARTICLE_VERSIONS.REFERENCE_SOURCE%TYPE;
3182: l_reference_text OKC_ARTICLE_VERSIONS.REFERENCE_TEXT%TYPE;
3183: l_orig_system_reference_code OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
3184: l_orig_system_reference_id1 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID1%TYPE;

Line 3181: l_reference_source OKC_ARTICLE_VERSIONS.REFERENCE_SOURCE%TYPE;

3177: l_translated_yn OKC_ARTICLE_VERSIONS.TRANSLATED_YN%TYPE;
3178: l_article_description OKC_ARTICLE_VERSIONS.ARTICLE_DESCRIPTION%TYPE;
3179: l_date_approved OKC_ARTICLE_VERSIONS.DATE_APPROVED%TYPE;
3180: l_default_section OKC_ARTICLE_VERSIONS.DEFAULT_SECTION%TYPE;
3181: l_reference_source OKC_ARTICLE_VERSIONS.REFERENCE_SOURCE%TYPE;
3182: l_reference_text OKC_ARTICLE_VERSIONS.REFERENCE_TEXT%TYPE;
3183: l_orig_system_reference_code OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
3184: l_orig_system_reference_id1 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
3185: l_orig_system_reference_id2 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID2%TYPE;

Line 3182: l_reference_text OKC_ARTICLE_VERSIONS.REFERENCE_TEXT%TYPE;

3178: l_article_description OKC_ARTICLE_VERSIONS.ARTICLE_DESCRIPTION%TYPE;
3179: l_date_approved OKC_ARTICLE_VERSIONS.DATE_APPROVED%TYPE;
3180: l_default_section OKC_ARTICLE_VERSIONS.DEFAULT_SECTION%TYPE;
3181: l_reference_source OKC_ARTICLE_VERSIONS.REFERENCE_SOURCE%TYPE;
3182: l_reference_text OKC_ARTICLE_VERSIONS.REFERENCE_TEXT%TYPE;
3183: l_orig_system_reference_code OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
3184: l_orig_system_reference_id1 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
3185: l_orig_system_reference_id2 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
3186: l_additional_instructions OKC_ARTICLE_VERSIONS.ADDITIONAL_INSTRUCTIONS%TYPE;

Line 3183: l_orig_system_reference_code OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_CODE%TYPE;

3179: l_date_approved OKC_ARTICLE_VERSIONS.DATE_APPROVED%TYPE;
3180: l_default_section OKC_ARTICLE_VERSIONS.DEFAULT_SECTION%TYPE;
3181: l_reference_source OKC_ARTICLE_VERSIONS.REFERENCE_SOURCE%TYPE;
3182: l_reference_text OKC_ARTICLE_VERSIONS.REFERENCE_TEXT%TYPE;
3183: l_orig_system_reference_code OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
3184: l_orig_system_reference_id1 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
3185: l_orig_system_reference_id2 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
3186: l_additional_instructions OKC_ARTICLE_VERSIONS.ADDITIONAL_INSTRUCTIONS%TYPE;
3187: l_variation_description OKC_ARTICLE_VERSIONS.VARIATION_DESCRIPTION%TYPE;

Line 3184: l_orig_system_reference_id1 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID1%TYPE;

3180: l_default_section OKC_ARTICLE_VERSIONS.DEFAULT_SECTION%TYPE;
3181: l_reference_source OKC_ARTICLE_VERSIONS.REFERENCE_SOURCE%TYPE;
3182: l_reference_text OKC_ARTICLE_VERSIONS.REFERENCE_TEXT%TYPE;
3183: l_orig_system_reference_code OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
3184: l_orig_system_reference_id1 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
3185: l_orig_system_reference_id2 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
3186: l_additional_instructions OKC_ARTICLE_VERSIONS.ADDITIONAL_INSTRUCTIONS%TYPE;
3187: l_variation_description OKC_ARTICLE_VERSIONS.VARIATION_DESCRIPTION%TYPE;
3188: l_date_published OKC_ARTICLE_VERSIONS.DATE_PUBLISHED%TYPE;

Line 3185: l_orig_system_reference_id2 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID2%TYPE;

3181: l_reference_source OKC_ARTICLE_VERSIONS.REFERENCE_SOURCE%TYPE;
3182: l_reference_text OKC_ARTICLE_VERSIONS.REFERENCE_TEXT%TYPE;
3183: l_orig_system_reference_code OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
3184: l_orig_system_reference_id1 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
3185: l_orig_system_reference_id2 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
3186: l_additional_instructions OKC_ARTICLE_VERSIONS.ADDITIONAL_INSTRUCTIONS%TYPE;
3187: l_variation_description OKC_ARTICLE_VERSIONS.VARIATION_DESCRIPTION%TYPE;
3188: l_date_published OKC_ARTICLE_VERSIONS.DATE_PUBLISHED%TYPE;
3189: l_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE;

Line 3186: l_additional_instructions OKC_ARTICLE_VERSIONS.ADDITIONAL_INSTRUCTIONS%TYPE;

3182: l_reference_text OKC_ARTICLE_VERSIONS.REFERENCE_TEXT%TYPE;
3183: l_orig_system_reference_code OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
3184: l_orig_system_reference_id1 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
3185: l_orig_system_reference_id2 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
3186: l_additional_instructions OKC_ARTICLE_VERSIONS.ADDITIONAL_INSTRUCTIONS%TYPE;
3187: l_variation_description OKC_ARTICLE_VERSIONS.VARIATION_DESCRIPTION%TYPE;
3188: l_date_published OKC_ARTICLE_VERSIONS.DATE_PUBLISHED%TYPE;
3189: l_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE;
3190: l_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE;

Line 3187: l_variation_description OKC_ARTICLE_VERSIONS.VARIATION_DESCRIPTION%TYPE;

3183: l_orig_system_reference_code OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
3184: l_orig_system_reference_id1 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
3185: l_orig_system_reference_id2 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
3186: l_additional_instructions OKC_ARTICLE_VERSIONS.ADDITIONAL_INSTRUCTIONS%TYPE;
3187: l_variation_description OKC_ARTICLE_VERSIONS.VARIATION_DESCRIPTION%TYPE;
3188: l_date_published OKC_ARTICLE_VERSIONS.DATE_PUBLISHED%TYPE;
3189: l_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE;
3190: l_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE;
3191: l_program_application_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE;

Line 3188: l_date_published OKC_ARTICLE_VERSIONS.DATE_PUBLISHED%TYPE;

3184: l_orig_system_reference_id1 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
3185: l_orig_system_reference_id2 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
3186: l_additional_instructions OKC_ARTICLE_VERSIONS.ADDITIONAL_INSTRUCTIONS%TYPE;
3187: l_variation_description OKC_ARTICLE_VERSIONS.VARIATION_DESCRIPTION%TYPE;
3188: l_date_published OKC_ARTICLE_VERSIONS.DATE_PUBLISHED%TYPE;
3189: l_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE;
3190: l_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE;
3191: l_program_application_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE;
3192: l_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE;

Line 3189: l_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE;

3185: l_orig_system_reference_id2 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
3186: l_additional_instructions OKC_ARTICLE_VERSIONS.ADDITIONAL_INSTRUCTIONS%TYPE;
3187: l_variation_description OKC_ARTICLE_VERSIONS.VARIATION_DESCRIPTION%TYPE;
3188: l_date_published OKC_ARTICLE_VERSIONS.DATE_PUBLISHED%TYPE;
3189: l_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE;
3190: l_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE;
3191: l_program_application_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE;
3192: l_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE;
3193: l_attribute_category OKC_ARTICLE_VERSIONS.ATTRIBUTE_CATEGORY%TYPE;

Line 3190: l_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE;

3186: l_additional_instructions OKC_ARTICLE_VERSIONS.ADDITIONAL_INSTRUCTIONS%TYPE;
3187: l_variation_description OKC_ARTICLE_VERSIONS.VARIATION_DESCRIPTION%TYPE;
3188: l_date_published OKC_ARTICLE_VERSIONS.DATE_PUBLISHED%TYPE;
3189: l_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE;
3190: l_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE;
3191: l_program_application_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE;
3192: l_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE;
3193: l_attribute_category OKC_ARTICLE_VERSIONS.ATTRIBUTE_CATEGORY%TYPE;
3194: l_attribute1 OKC_ARTICLE_VERSIONS.ATTRIBUTE1%TYPE;

Line 3191: l_program_application_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE;

3187: l_variation_description OKC_ARTICLE_VERSIONS.VARIATION_DESCRIPTION%TYPE;
3188: l_date_published OKC_ARTICLE_VERSIONS.DATE_PUBLISHED%TYPE;
3189: l_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE;
3190: l_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE;
3191: l_program_application_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE;
3192: l_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE;
3193: l_attribute_category OKC_ARTICLE_VERSIONS.ATTRIBUTE_CATEGORY%TYPE;
3194: l_attribute1 OKC_ARTICLE_VERSIONS.ATTRIBUTE1%TYPE;
3195: l_attribute2 OKC_ARTICLE_VERSIONS.ATTRIBUTE2%TYPE;

Line 3192: l_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE;

3188: l_date_published OKC_ARTICLE_VERSIONS.DATE_PUBLISHED%TYPE;
3189: l_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE;
3190: l_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE;
3191: l_program_application_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE;
3192: l_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE;
3193: l_attribute_category OKC_ARTICLE_VERSIONS.ATTRIBUTE_CATEGORY%TYPE;
3194: l_attribute1 OKC_ARTICLE_VERSIONS.ATTRIBUTE1%TYPE;
3195: l_attribute2 OKC_ARTICLE_VERSIONS.ATTRIBUTE2%TYPE;
3196: l_attribute3 OKC_ARTICLE_VERSIONS.ATTRIBUTE3%TYPE;

Line 3193: l_attribute_category OKC_ARTICLE_VERSIONS.ATTRIBUTE_CATEGORY%TYPE;

3189: l_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE;
3190: l_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE;
3191: l_program_application_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE;
3192: l_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE;
3193: l_attribute_category OKC_ARTICLE_VERSIONS.ATTRIBUTE_CATEGORY%TYPE;
3194: l_attribute1 OKC_ARTICLE_VERSIONS.ATTRIBUTE1%TYPE;
3195: l_attribute2 OKC_ARTICLE_VERSIONS.ATTRIBUTE2%TYPE;
3196: l_attribute3 OKC_ARTICLE_VERSIONS.ATTRIBUTE3%TYPE;
3197: l_attribute4 OKC_ARTICLE_VERSIONS.ATTRIBUTE4%TYPE;

Line 3194: l_attribute1 OKC_ARTICLE_VERSIONS.ATTRIBUTE1%TYPE;

3190: l_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE;
3191: l_program_application_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE;
3192: l_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE;
3193: l_attribute_category OKC_ARTICLE_VERSIONS.ATTRIBUTE_CATEGORY%TYPE;
3194: l_attribute1 OKC_ARTICLE_VERSIONS.ATTRIBUTE1%TYPE;
3195: l_attribute2 OKC_ARTICLE_VERSIONS.ATTRIBUTE2%TYPE;
3196: l_attribute3 OKC_ARTICLE_VERSIONS.ATTRIBUTE3%TYPE;
3197: l_attribute4 OKC_ARTICLE_VERSIONS.ATTRIBUTE4%TYPE;
3198: l_attribute5 OKC_ARTICLE_VERSIONS.ATTRIBUTE5%TYPE;

Line 3195: l_attribute2 OKC_ARTICLE_VERSIONS.ATTRIBUTE2%TYPE;

3191: l_program_application_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE;
3192: l_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE;
3193: l_attribute_category OKC_ARTICLE_VERSIONS.ATTRIBUTE_CATEGORY%TYPE;
3194: l_attribute1 OKC_ARTICLE_VERSIONS.ATTRIBUTE1%TYPE;
3195: l_attribute2 OKC_ARTICLE_VERSIONS.ATTRIBUTE2%TYPE;
3196: l_attribute3 OKC_ARTICLE_VERSIONS.ATTRIBUTE3%TYPE;
3197: l_attribute4 OKC_ARTICLE_VERSIONS.ATTRIBUTE4%TYPE;
3198: l_attribute5 OKC_ARTICLE_VERSIONS.ATTRIBUTE5%TYPE;
3199: l_attribute6 OKC_ARTICLE_VERSIONS.ATTRIBUTE6%TYPE;

Line 3196: l_attribute3 OKC_ARTICLE_VERSIONS.ATTRIBUTE3%TYPE;

3192: l_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE;
3193: l_attribute_category OKC_ARTICLE_VERSIONS.ATTRIBUTE_CATEGORY%TYPE;
3194: l_attribute1 OKC_ARTICLE_VERSIONS.ATTRIBUTE1%TYPE;
3195: l_attribute2 OKC_ARTICLE_VERSIONS.ATTRIBUTE2%TYPE;
3196: l_attribute3 OKC_ARTICLE_VERSIONS.ATTRIBUTE3%TYPE;
3197: l_attribute4 OKC_ARTICLE_VERSIONS.ATTRIBUTE4%TYPE;
3198: l_attribute5 OKC_ARTICLE_VERSIONS.ATTRIBUTE5%TYPE;
3199: l_attribute6 OKC_ARTICLE_VERSIONS.ATTRIBUTE6%TYPE;
3200: l_attribute7 OKC_ARTICLE_VERSIONS.ATTRIBUTE7%TYPE;

Line 3197: l_attribute4 OKC_ARTICLE_VERSIONS.ATTRIBUTE4%TYPE;

3193: l_attribute_category OKC_ARTICLE_VERSIONS.ATTRIBUTE_CATEGORY%TYPE;
3194: l_attribute1 OKC_ARTICLE_VERSIONS.ATTRIBUTE1%TYPE;
3195: l_attribute2 OKC_ARTICLE_VERSIONS.ATTRIBUTE2%TYPE;
3196: l_attribute3 OKC_ARTICLE_VERSIONS.ATTRIBUTE3%TYPE;
3197: l_attribute4 OKC_ARTICLE_VERSIONS.ATTRIBUTE4%TYPE;
3198: l_attribute5 OKC_ARTICLE_VERSIONS.ATTRIBUTE5%TYPE;
3199: l_attribute6 OKC_ARTICLE_VERSIONS.ATTRIBUTE6%TYPE;
3200: l_attribute7 OKC_ARTICLE_VERSIONS.ATTRIBUTE7%TYPE;
3201: l_attribute8 OKC_ARTICLE_VERSIONS.ATTRIBUTE8%TYPE;

Line 3198: l_attribute5 OKC_ARTICLE_VERSIONS.ATTRIBUTE5%TYPE;

3194: l_attribute1 OKC_ARTICLE_VERSIONS.ATTRIBUTE1%TYPE;
3195: l_attribute2 OKC_ARTICLE_VERSIONS.ATTRIBUTE2%TYPE;
3196: l_attribute3 OKC_ARTICLE_VERSIONS.ATTRIBUTE3%TYPE;
3197: l_attribute4 OKC_ARTICLE_VERSIONS.ATTRIBUTE4%TYPE;
3198: l_attribute5 OKC_ARTICLE_VERSIONS.ATTRIBUTE5%TYPE;
3199: l_attribute6 OKC_ARTICLE_VERSIONS.ATTRIBUTE6%TYPE;
3200: l_attribute7 OKC_ARTICLE_VERSIONS.ATTRIBUTE7%TYPE;
3201: l_attribute8 OKC_ARTICLE_VERSIONS.ATTRIBUTE8%TYPE;
3202: l_attribute9 OKC_ARTICLE_VERSIONS.ATTRIBUTE9%TYPE;

Line 3199: l_attribute6 OKC_ARTICLE_VERSIONS.ATTRIBUTE6%TYPE;

3195: l_attribute2 OKC_ARTICLE_VERSIONS.ATTRIBUTE2%TYPE;
3196: l_attribute3 OKC_ARTICLE_VERSIONS.ATTRIBUTE3%TYPE;
3197: l_attribute4 OKC_ARTICLE_VERSIONS.ATTRIBUTE4%TYPE;
3198: l_attribute5 OKC_ARTICLE_VERSIONS.ATTRIBUTE5%TYPE;
3199: l_attribute6 OKC_ARTICLE_VERSIONS.ATTRIBUTE6%TYPE;
3200: l_attribute7 OKC_ARTICLE_VERSIONS.ATTRIBUTE7%TYPE;
3201: l_attribute8 OKC_ARTICLE_VERSIONS.ATTRIBUTE8%TYPE;
3202: l_attribute9 OKC_ARTICLE_VERSIONS.ATTRIBUTE9%TYPE;
3203: l_attribute10 OKC_ARTICLE_VERSIONS.ATTRIBUTE10%TYPE;

Line 3200: l_attribute7 OKC_ARTICLE_VERSIONS.ATTRIBUTE7%TYPE;

3196: l_attribute3 OKC_ARTICLE_VERSIONS.ATTRIBUTE3%TYPE;
3197: l_attribute4 OKC_ARTICLE_VERSIONS.ATTRIBUTE4%TYPE;
3198: l_attribute5 OKC_ARTICLE_VERSIONS.ATTRIBUTE5%TYPE;
3199: l_attribute6 OKC_ARTICLE_VERSIONS.ATTRIBUTE6%TYPE;
3200: l_attribute7 OKC_ARTICLE_VERSIONS.ATTRIBUTE7%TYPE;
3201: l_attribute8 OKC_ARTICLE_VERSIONS.ATTRIBUTE8%TYPE;
3202: l_attribute9 OKC_ARTICLE_VERSIONS.ATTRIBUTE9%TYPE;
3203: l_attribute10 OKC_ARTICLE_VERSIONS.ATTRIBUTE10%TYPE;
3204: l_attribute11 OKC_ARTICLE_VERSIONS.ATTRIBUTE11%TYPE;

Line 3201: l_attribute8 OKC_ARTICLE_VERSIONS.ATTRIBUTE8%TYPE;

3197: l_attribute4 OKC_ARTICLE_VERSIONS.ATTRIBUTE4%TYPE;
3198: l_attribute5 OKC_ARTICLE_VERSIONS.ATTRIBUTE5%TYPE;
3199: l_attribute6 OKC_ARTICLE_VERSIONS.ATTRIBUTE6%TYPE;
3200: l_attribute7 OKC_ARTICLE_VERSIONS.ATTRIBUTE7%TYPE;
3201: l_attribute8 OKC_ARTICLE_VERSIONS.ATTRIBUTE8%TYPE;
3202: l_attribute9 OKC_ARTICLE_VERSIONS.ATTRIBUTE9%TYPE;
3203: l_attribute10 OKC_ARTICLE_VERSIONS.ATTRIBUTE10%TYPE;
3204: l_attribute11 OKC_ARTICLE_VERSIONS.ATTRIBUTE11%TYPE;
3205: l_attribute12 OKC_ARTICLE_VERSIONS.ATTRIBUTE12%TYPE;

Line 3202: l_attribute9 OKC_ARTICLE_VERSIONS.ATTRIBUTE9%TYPE;

3198: l_attribute5 OKC_ARTICLE_VERSIONS.ATTRIBUTE5%TYPE;
3199: l_attribute6 OKC_ARTICLE_VERSIONS.ATTRIBUTE6%TYPE;
3200: l_attribute7 OKC_ARTICLE_VERSIONS.ATTRIBUTE7%TYPE;
3201: l_attribute8 OKC_ARTICLE_VERSIONS.ATTRIBUTE8%TYPE;
3202: l_attribute9 OKC_ARTICLE_VERSIONS.ATTRIBUTE9%TYPE;
3203: l_attribute10 OKC_ARTICLE_VERSIONS.ATTRIBUTE10%TYPE;
3204: l_attribute11 OKC_ARTICLE_VERSIONS.ATTRIBUTE11%TYPE;
3205: l_attribute12 OKC_ARTICLE_VERSIONS.ATTRIBUTE12%TYPE;
3206: l_attribute13 OKC_ARTICLE_VERSIONS.ATTRIBUTE13%TYPE;

Line 3203: l_attribute10 OKC_ARTICLE_VERSIONS.ATTRIBUTE10%TYPE;

3199: l_attribute6 OKC_ARTICLE_VERSIONS.ATTRIBUTE6%TYPE;
3200: l_attribute7 OKC_ARTICLE_VERSIONS.ATTRIBUTE7%TYPE;
3201: l_attribute8 OKC_ARTICLE_VERSIONS.ATTRIBUTE8%TYPE;
3202: l_attribute9 OKC_ARTICLE_VERSIONS.ATTRIBUTE9%TYPE;
3203: l_attribute10 OKC_ARTICLE_VERSIONS.ATTRIBUTE10%TYPE;
3204: l_attribute11 OKC_ARTICLE_VERSIONS.ATTRIBUTE11%TYPE;
3205: l_attribute12 OKC_ARTICLE_VERSIONS.ATTRIBUTE12%TYPE;
3206: l_attribute13 OKC_ARTICLE_VERSIONS.ATTRIBUTE13%TYPE;
3207: l_attribute14 OKC_ARTICLE_VERSIONS.ATTRIBUTE14%TYPE;

Line 3204: l_attribute11 OKC_ARTICLE_VERSIONS.ATTRIBUTE11%TYPE;

3200: l_attribute7 OKC_ARTICLE_VERSIONS.ATTRIBUTE7%TYPE;
3201: l_attribute8 OKC_ARTICLE_VERSIONS.ATTRIBUTE8%TYPE;
3202: l_attribute9 OKC_ARTICLE_VERSIONS.ATTRIBUTE9%TYPE;
3203: l_attribute10 OKC_ARTICLE_VERSIONS.ATTRIBUTE10%TYPE;
3204: l_attribute11 OKC_ARTICLE_VERSIONS.ATTRIBUTE11%TYPE;
3205: l_attribute12 OKC_ARTICLE_VERSIONS.ATTRIBUTE12%TYPE;
3206: l_attribute13 OKC_ARTICLE_VERSIONS.ATTRIBUTE13%TYPE;
3207: l_attribute14 OKC_ARTICLE_VERSIONS.ATTRIBUTE14%TYPE;
3208: l_attribute15 OKC_ARTICLE_VERSIONS.ATTRIBUTE15%TYPE;

Line 3205: l_attribute12 OKC_ARTICLE_VERSIONS.ATTRIBUTE12%TYPE;

3201: l_attribute8 OKC_ARTICLE_VERSIONS.ATTRIBUTE8%TYPE;
3202: l_attribute9 OKC_ARTICLE_VERSIONS.ATTRIBUTE9%TYPE;
3203: l_attribute10 OKC_ARTICLE_VERSIONS.ATTRIBUTE10%TYPE;
3204: l_attribute11 OKC_ARTICLE_VERSIONS.ATTRIBUTE11%TYPE;
3205: l_attribute12 OKC_ARTICLE_VERSIONS.ATTRIBUTE12%TYPE;
3206: l_attribute13 OKC_ARTICLE_VERSIONS.ATTRIBUTE13%TYPE;
3207: l_attribute14 OKC_ARTICLE_VERSIONS.ATTRIBUTE14%TYPE;
3208: l_attribute15 OKC_ARTICLE_VERSIONS.ATTRIBUTE15%TYPE;
3209: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;

Line 3206: l_attribute13 OKC_ARTICLE_VERSIONS.ATTRIBUTE13%TYPE;

3202: l_attribute9 OKC_ARTICLE_VERSIONS.ATTRIBUTE9%TYPE;
3203: l_attribute10 OKC_ARTICLE_VERSIONS.ATTRIBUTE10%TYPE;
3204: l_attribute11 OKC_ARTICLE_VERSIONS.ATTRIBUTE11%TYPE;
3205: l_attribute12 OKC_ARTICLE_VERSIONS.ATTRIBUTE12%TYPE;
3206: l_attribute13 OKC_ARTICLE_VERSIONS.ATTRIBUTE13%TYPE;
3207: l_attribute14 OKC_ARTICLE_VERSIONS.ATTRIBUTE14%TYPE;
3208: l_attribute15 OKC_ARTICLE_VERSIONS.ATTRIBUTE15%TYPE;
3209: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;
3210: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;

Line 3207: l_attribute14 OKC_ARTICLE_VERSIONS.ATTRIBUTE14%TYPE;

3203: l_attribute10 OKC_ARTICLE_VERSIONS.ATTRIBUTE10%TYPE;
3204: l_attribute11 OKC_ARTICLE_VERSIONS.ATTRIBUTE11%TYPE;
3205: l_attribute12 OKC_ARTICLE_VERSIONS.ATTRIBUTE12%TYPE;
3206: l_attribute13 OKC_ARTICLE_VERSIONS.ATTRIBUTE13%TYPE;
3207: l_attribute14 OKC_ARTICLE_VERSIONS.ATTRIBUTE14%TYPE;
3208: l_attribute15 OKC_ARTICLE_VERSIONS.ATTRIBUTE15%TYPE;
3209: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;
3210: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
3211: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;

Line 3208: l_attribute15 OKC_ARTICLE_VERSIONS.ATTRIBUTE15%TYPE;

3204: l_attribute11 OKC_ARTICLE_VERSIONS.ATTRIBUTE11%TYPE;
3205: l_attribute12 OKC_ARTICLE_VERSIONS.ATTRIBUTE12%TYPE;
3206: l_attribute13 OKC_ARTICLE_VERSIONS.ATTRIBUTE13%TYPE;
3207: l_attribute14 OKC_ARTICLE_VERSIONS.ATTRIBUTE14%TYPE;
3208: l_attribute15 OKC_ARTICLE_VERSIONS.ATTRIBUTE15%TYPE;
3209: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;
3210: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
3211: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
3212: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;

Line 3209: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;

3205: l_attribute12 OKC_ARTICLE_VERSIONS.ATTRIBUTE12%TYPE;
3206: l_attribute13 OKC_ARTICLE_VERSIONS.ATTRIBUTE13%TYPE;
3207: l_attribute14 OKC_ARTICLE_VERSIONS.ATTRIBUTE14%TYPE;
3208: l_attribute15 OKC_ARTICLE_VERSIONS.ATTRIBUTE15%TYPE;
3209: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;
3210: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
3211: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
3212: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
3213: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;

Line 3210: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;

3206: l_attribute13 OKC_ARTICLE_VERSIONS.ATTRIBUTE13%TYPE;
3207: l_attribute14 OKC_ARTICLE_VERSIONS.ATTRIBUTE14%TYPE;
3208: l_attribute15 OKC_ARTICLE_VERSIONS.ATTRIBUTE15%TYPE;
3209: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;
3210: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
3211: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
3212: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
3213: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
3214: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;

Line 3211: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;

3207: l_attribute14 OKC_ARTICLE_VERSIONS.ATTRIBUTE14%TYPE;
3208: l_attribute15 OKC_ARTICLE_VERSIONS.ATTRIBUTE15%TYPE;
3209: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;
3210: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
3211: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
3212: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
3213: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
3214: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;
3215: l_earlier_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;

Line 3212: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;

3208: l_attribute15 OKC_ARTICLE_VERSIONS.ATTRIBUTE15%TYPE;
3209: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;
3210: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
3211: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
3212: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
3213: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
3214: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;
3215: l_earlier_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
3216: l_earlier_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;

Line 3213: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;

3209: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;
3210: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
3211: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
3212: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
3213: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
3214: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;
3215: l_earlier_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
3216: l_earlier_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
3217:

Line 3214: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;

3210: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
3211: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
3212: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
3213: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
3214: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;
3215: l_earlier_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
3216: l_earlier_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
3217:
3218: BEGIN

Line 3215: l_earlier_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;

3211: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
3212: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
3213: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
3214: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;
3215: l_earlier_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
3216: l_earlier_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
3217:
3218: BEGIN
3219:

Line 3216: l_earlier_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;

3212: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
3213: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
3214: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;
3215: l_earlier_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
3216: l_earlier_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
3217:
3218: BEGIN
3219:
3220: IF (l_debug = 'Y') THEN

Line 3551: -- Delete_Row for:OKC_ARTICLE_VERSIONS --

3547: ---------------------------------------------------------------------------
3548: -- PROCEDURE Delete_Row
3549: ---------------------------------------------------------------------------
3550: -------------------------------------
3551: -- Delete_Row for:OKC_ARTICLE_VERSIONS --
3552: -------------------------------------
3553: FUNCTION Delete_Row(
3554: p_article_version_id IN NUMBER
3555: ) RETURN VARCHAR2 IS

Line 3563: DELETE FROM OKC_ARTICLE_VERSIONS WHERE ARTICLE_VERSION_ID = P_ARTICLE_VERSION_ID;

3559: IF (l_debug = 'Y') THEN
3560: Okc_Debug.Log('8200: Entered Delete_Row', 2);
3561: END IF;
3562:
3563: DELETE FROM OKC_ARTICLE_VERSIONS WHERE ARTICLE_VERSION_ID = P_ARTICLE_VERSION_ID;
3564:
3565: IF (l_debug = 'Y') THEN
3566: Okc_Debug.Log('8300: Leaving Delete_Row', 2);
3567: END IF;

Line 3590: -- Delete_Row for:OKC_ARTICLE_VERSIONS --

3586:
3587: END Delete_Row;
3588:
3589: -------------------------------------
3590: -- Delete_Row for:OKC_ARTICLE_VERSIONS --
3591: -------------------------------------
3592: PROCEDURE Delete_Row(
3593: x_return_status OUT NOCOPY VARCHAR2,
3594: p_article_version_id IN NUMBER,

Line 3678: END OKC_ARTICLE_VERSIONS_PVT;

3674: RETURN c1;
3675: END ArticleClob;
3676:
3677:
3678: END OKC_ARTICLE_VERSIONS_PVT;