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

APPS.OKC_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.12.12020000.2 2012/07/16 16:16:58 harchand 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 175: CURSOR OKC_ARTICLE_VERSIONS_pk_csr (cp_article_version_id IN NUMBER) IS

171: x_last_update_date OUT NOCOPY DATE,
172: x_variable_code OUT NOCOPY VARCHAR2 --CLM
173:
174: ) RETURN VARCHAR2 IS
175: CURSOR OKC_ARTICLE_VERSIONS_pk_csr (cp_article_version_id IN NUMBER) IS
176: SELECT
177: ARTICLE_ID,
178: ARTICLE_VERSION_NUMBER,
179: ARTICLE_TEXT,

Line 232: FROM OKC_ARTICLE_VERSIONS t

228: LAST_UPDATED_BY,
229: LAST_UPDATE_LOGIN,
230: LAST_UPDATE_DATE,
231: VARIABLE_CODE
232: FROM OKC_ARTICLE_VERSIONS t
233: WHERE t.ARTICLE_VERSION_ID = cp_article_version_id;
234: BEGIN
235:
236: IF (l_debug = 'Y') THEN

Line 241: OPEN OKC_ARTICLE_VERSIONS_pk_csr (p_article_version_id);

237: Okc_Debug.Log('400: Entered get_rec', 2);
238: END IF;
239:
240: -- Get current database values
241: OPEN OKC_ARTICLE_VERSIONS_pk_csr (p_article_version_id);
242: FETCH OKC_ARTICLE_VERSIONS_pk_csr INTO
243: x_article_id,
244: x_article_version_number,
245: x_article_text,

Line 242: FETCH OKC_ARTICLE_VERSIONS_pk_csr INTO

238: END IF;
239:
240: -- Get current database values
241: OPEN OKC_ARTICLE_VERSIONS_pk_csr (p_article_version_id);
242: FETCH OKC_ARTICLE_VERSIONS_pk_csr INTO
243: x_article_id,
244: x_article_version_number,
245: x_article_text,
246: x_provision_yn,

Line 298: IF OKC_ARTICLE_VERSIONS_pk_csr%NOTFOUND THEN

294: x_last_updated_by,
295: x_last_update_login,
296: x_last_update_date,
297: x_variable_code;
298: IF OKC_ARTICLE_VERSIONS_pk_csr%NOTFOUND THEN
299: RAISE NO_DATA_FOUND;
300: END IF;
301: CLOSE OKC_ARTICLE_VERSIONS_pk_csr;
302:

Line 301: CLOSE OKC_ARTICLE_VERSIONS_pk_csr;

297: x_variable_code;
298: IF OKC_ARTICLE_VERSIONS_pk_csr%NOTFOUND THEN
299: RAISE NO_DATA_FOUND;
300: END IF;
301: CLOSE OKC_ARTICLE_VERSIONS_pk_csr;
302:
303: IF (l_debug = 'Y') THEN
304: Okc_Debug.Log('500: Leaving get_rec ', 2);
305: END IF;

Line 323: IF OKC_ARTICLE_VERSIONS_pk_csr%ISOPEN THEN

319: p_token1_value => sqlcode,
320: p_token2 => G_SQLERRM_TOKEN,
321: p_token2_value => sqlerrm);
322:
323: IF OKC_ARTICLE_VERSIONS_pk_csr%ISOPEN THEN
324: CLOSE OKC_ARTICLE_VERSIONS_pk_csr;
325: END IF;
326:
327: RETURN G_RET_STS_UNEXP_ERROR ;

Line 324: CLOSE OKC_ARTICLE_VERSIONS_pk_csr;

320: p_token2 => G_SQLERRM_TOKEN,
321: p_token2_value => sqlerrm);
322:
323: IF OKC_ARTICLE_VERSIONS_pk_csr%ISOPEN THEN
324: CLOSE OKC_ARTICLE_VERSIONS_pk_csr;
325: END IF;
326:
327: RETURN G_RET_STS_UNEXP_ERROR ;
328:

Line 332: -- Set_Attributes for:OKC_ARTICLE_VERSIONS --

328:
329: END Get_Rec;
330:
331: -----------------------------------------
332: -- Set_Attributes for:OKC_ARTICLE_VERSIONS --
333: -----------------------------------------
334: FUNCTION Set_Attributes(
335: p_article_version_id IN NUMBER,
336: p_article_id IN NUMBER,

Line 438: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;

434: x_article_text_in_word OUT NOCOPY BLOB,
435: x_variable_code OUT NOCOPY VARCHAR2 --clm
436: ) RETURN VARCHAR2 IS
437: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
438: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;
439: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
440: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
441: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
442: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;

Line 439: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;

435: x_variable_code OUT NOCOPY VARCHAR2 --clm
436: ) RETURN VARCHAR2 IS
437: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
438: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;
439: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
440: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
441: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
442: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
443: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;

Line 440: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;

436: ) RETURN VARCHAR2 IS
437: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
438: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;
439: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
440: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
441: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
442: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
443: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;
444: BEGIN

Line 441: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;

437: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
438: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;
439: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
440: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
441: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
442: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
443: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;
444: BEGIN
445: IF (l_debug = 'Y') THEN

Line 442: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;

438: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;
439: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
440: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
441: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
442: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
443: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;
444: BEGIN
445: IF (l_debug = 'Y') THEN
446: Okc_Debug.Log('700: Entered Set_Attributes ', 2);

Line 443: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;

439: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
440: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
441: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
442: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
443: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;
444: BEGIN
445: IF (l_debug = 'Y') THEN
446: Okc_Debug.Log('700: Entered Set_Attributes ', 2);
447: END IF;

Line 908: -- Validate_Attributes for: OKC_ARTICLE_VERSIONS --

904:
905: END Set_Attributes ;
906:
907: ----------------------------------------------
908: -- Validate_Attributes for: OKC_ARTICLE_VERSIONS --
909: ----------------------------------------------
910: FUNCTION Validate_Attributes (
911: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
912: p_import_action IN VARCHAR2 := NULL,

Line 969: l_dummy_date OKC_ARTICLE_VERSIONS.DATE_PUBLISHED%TYPE;

965: ) RETURN VARCHAR2 IS
966: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
967: l_tmp_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
968: l_dummy_var VARCHAR2(1) := '?';
969: l_dummy_date OKC_ARTICLE_VERSIONS.DATE_PUBLISHED%TYPE;
970: l_art_XML XMLType;
971:
972:
973: CURSOR l_article_language_csr(p_article_id IN NUMBER, p_article_language IN VARCHAR2) is

Line 981: FROM OKC_ARTICLES_ALL AA,OKC_ARTICLE_VERSIONS AV

977: AND ARTICLE_ID = p_article_id;
978:
979: CURSOR l_std_article_version_id_csr is
980: SELECT '!'
981: FROM OKC_ARTICLES_ALL AA,OKC_ARTICLE_VERSIONS AV
982: WHERE AA.ARTICLE_ID = AV.ARTICLE_ID
983: AND AV.ARTICLE_VERSION_ID = p_std_article_version_id
984: AND AA.STANDARD_YN = 'Y';
985:

Line 989: FROM OKC_ARTICLE_VERSIONS AV

985:
986: -- Below Added for FAR/DFAR Import
987: CURSOR l_date_published_csr is
988: SELECT av.date_published
989: FROM OKC_ARTICLE_VERSIONS AV
990: WHERE AV.ARTICLE_VERSION_ID = p_article_version_id;
991:
992: BEGIN
993:

Line 1356: okc_article_versions v,

1352: c_provision_yn in varchar2)
1353: IS
1354: select 'E' result
1355: from
1356: okc_article_versions v,
1357: okc_article_relatns_all r
1358: where
1359: r.source_article_id = c_source_article_id
1360: and

Line 1382: -- Validate_Record for:OKC_ARTICLE_VERSIONS --

1378: -- PROCEDURE Validate_Record
1379: -- It calls Item Level Validations and then makes Record Level Validations
1380: ---------------------------------------------------------------------------
1381: ------------------------------------------
1382: -- Validate_Record for:OKC_ARTICLE_VERSIONS --
1383: ------------------------------------------
1384: FUNCTION Validate_Record (
1385: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1386: p_import_action IN VARCHAR2 := NULL,

Line 1470: okc_article_versions av

1466: av.article_version_number,
1467: av.article_version_id,
1468: av.date_published
1469: from
1470: okc_article_versions av
1471: where
1472: av.article_id = p_article_id
1473: and
1474: av.start_date = (select

Line 1477: okc_article_versions av1

1473: and
1474: av.start_date = (select
1475: max(av1.start_date)
1476: from
1477: okc_article_versions av1
1478: where
1479: av1.article_id = av.article_id
1480: and
1481: av1.article_version_id <> p_article_version_id

Line 1501: FROM OKC_ARTICLE_VERSIONS A

1497: A.START_DATE, A.END_DATE,
1498: MAX(A.START_DATE) OVER (PARTITION BY A.ARTICLE_ID) AS MAX_START_DATE,
1499: A.ARTICLE_VERSION_NUMBER,
1500: A.ARTICLE_VERSION_ID
1501: FROM OKC_ARTICLE_VERSIONS A
1502: WHERE A.ARTICLE_ID = p_article_id
1503: AND ARTICLE_VERSION_ID <> p_article_version_id
1504: ) S
1505: WHERE S.START_DATE = S.MAX_START_DATE;

Line 1517: FROM OKC_ARTICLE_VERSIONS AVN, OKC_ARTICLE_ADOPTIONS ADP

1513: -- Bug#3672511: Validation of start date of a localized clause should be >= start date of global clause.
1514:
1515: CURSOR l_global_csr(p_article_version_id IN NUMBER, p_local_org_id IN NUMBER) is
1516: SELECT start_date
1517: FROM OKC_ARTICLE_VERSIONS AVN, OKC_ARTICLE_ADOPTIONS ADP
1518: WHERE ARTICLE_VERSION_ID = GLOBAL_ARTICLE_VERSION_ID
1519: AND LOCAL_ARTICLE_VERSION_ID = p_article_version_id
1520: AND LOCAL_ORG_ID = p_local_org_id
1521: AND ADP.ADOPTION_TYPE = 'LOCALIZED' ;

Line 1931: -- validate_row for:OKC_ARTICLE_VERSIONS --

1927: ---------------------------------------------------------------------------
1928: -- PROCEDURE validate_row
1929: ---------------------------------------------------------------------------
1930: ---------------------------------------
1931: -- validate_row for:OKC_ARTICLE_VERSIONS --
1932: ---------------------------------------
1933: PROCEDURE validate_row(
1934: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1935: p_import_action IN VARCHAR2 := NULL,

Line 1997: l_article_id OKC_ARTICLE_VERSIONS.ARTICLE_ID%TYPE;

1993: p_edited_in_word IN VARCHAR2,
1994: p_article_text_in_word IN BLOB,
1995: p_variable_code IN VARCHAR2 DEFAULT NULL --clm
1996: ) IS
1997: l_article_id OKC_ARTICLE_VERSIONS.ARTICLE_ID%TYPE;
1998: l_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
1999: l_article_text OKC_ARTICLE_VERSIONS.ARTICLE_TEXT%TYPE;
2000: l_provision_yn OKC_ARTICLE_VERSIONS.PROVISION_YN%TYPE;
2001: l_insert_by_reference OKC_ARTICLE_VERSIONS.INSERT_BY_REFERENCE%TYPE;

Line 1998: l_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;

1994: p_article_text_in_word IN BLOB,
1995: p_variable_code IN VARCHAR2 DEFAULT NULL --clm
1996: ) IS
1997: l_article_id OKC_ARTICLE_VERSIONS.ARTICLE_ID%TYPE;
1998: l_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
1999: l_article_text OKC_ARTICLE_VERSIONS.ARTICLE_TEXT%TYPE;
2000: l_provision_yn OKC_ARTICLE_VERSIONS.PROVISION_YN%TYPE;
2001: l_insert_by_reference OKC_ARTICLE_VERSIONS.INSERT_BY_REFERENCE%TYPE;
2002: l_lock_text OKC_ARTICLE_VERSIONS.LOCK_TEXT%TYPE;

Line 1999: l_article_text OKC_ARTICLE_VERSIONS.ARTICLE_TEXT%TYPE;

1995: p_variable_code IN VARCHAR2 DEFAULT NULL --clm
1996: ) IS
1997: l_article_id OKC_ARTICLE_VERSIONS.ARTICLE_ID%TYPE;
1998: l_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
1999: l_article_text OKC_ARTICLE_VERSIONS.ARTICLE_TEXT%TYPE;
2000: l_provision_yn OKC_ARTICLE_VERSIONS.PROVISION_YN%TYPE;
2001: l_insert_by_reference OKC_ARTICLE_VERSIONS.INSERT_BY_REFERENCE%TYPE;
2002: l_lock_text OKC_ARTICLE_VERSIONS.LOCK_TEXT%TYPE;
2003: l_global_yn OKC_ARTICLE_VERSIONS.GLOBAL_YN%TYPE;

Line 2000: l_provision_yn OKC_ARTICLE_VERSIONS.PROVISION_YN%TYPE;

1996: ) IS
1997: l_article_id OKC_ARTICLE_VERSIONS.ARTICLE_ID%TYPE;
1998: l_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
1999: l_article_text OKC_ARTICLE_VERSIONS.ARTICLE_TEXT%TYPE;
2000: l_provision_yn OKC_ARTICLE_VERSIONS.PROVISION_YN%TYPE;
2001: l_insert_by_reference OKC_ARTICLE_VERSIONS.INSERT_BY_REFERENCE%TYPE;
2002: l_lock_text OKC_ARTICLE_VERSIONS.LOCK_TEXT%TYPE;
2003: l_global_yn OKC_ARTICLE_VERSIONS.GLOBAL_YN%TYPE;
2004: l_article_language OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;

Line 2001: l_insert_by_reference OKC_ARTICLE_VERSIONS.INSERT_BY_REFERENCE%TYPE;

1997: l_article_id OKC_ARTICLE_VERSIONS.ARTICLE_ID%TYPE;
1998: l_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
1999: l_article_text OKC_ARTICLE_VERSIONS.ARTICLE_TEXT%TYPE;
2000: l_provision_yn OKC_ARTICLE_VERSIONS.PROVISION_YN%TYPE;
2001: l_insert_by_reference OKC_ARTICLE_VERSIONS.INSERT_BY_REFERENCE%TYPE;
2002: l_lock_text OKC_ARTICLE_VERSIONS.LOCK_TEXT%TYPE;
2003: l_global_yn OKC_ARTICLE_VERSIONS.GLOBAL_YN%TYPE;
2004: l_article_language OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;
2005: l_article_language_out OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;

Line 2002: l_lock_text OKC_ARTICLE_VERSIONS.LOCK_TEXT%TYPE;

1998: l_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
1999: l_article_text OKC_ARTICLE_VERSIONS.ARTICLE_TEXT%TYPE;
2000: l_provision_yn OKC_ARTICLE_VERSIONS.PROVISION_YN%TYPE;
2001: l_insert_by_reference OKC_ARTICLE_VERSIONS.INSERT_BY_REFERENCE%TYPE;
2002: l_lock_text OKC_ARTICLE_VERSIONS.LOCK_TEXT%TYPE;
2003: l_global_yn OKC_ARTICLE_VERSIONS.GLOBAL_YN%TYPE;
2004: l_article_language OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;
2005: l_article_language_out OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;
2006: l_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;

Line 2003: l_global_yn OKC_ARTICLE_VERSIONS.GLOBAL_YN%TYPE;

1999: l_article_text OKC_ARTICLE_VERSIONS.ARTICLE_TEXT%TYPE;
2000: l_provision_yn OKC_ARTICLE_VERSIONS.PROVISION_YN%TYPE;
2001: l_insert_by_reference OKC_ARTICLE_VERSIONS.INSERT_BY_REFERENCE%TYPE;
2002: l_lock_text OKC_ARTICLE_VERSIONS.LOCK_TEXT%TYPE;
2003: l_global_yn OKC_ARTICLE_VERSIONS.GLOBAL_YN%TYPE;
2004: l_article_language OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;
2005: l_article_language_out OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;
2006: l_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
2007: l_sav_release OKC_ARTICLE_VERSIONS.SAV_RELEASE%TYPE;

Line 2004: l_article_language OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;

2000: l_provision_yn OKC_ARTICLE_VERSIONS.PROVISION_YN%TYPE;
2001: l_insert_by_reference OKC_ARTICLE_VERSIONS.INSERT_BY_REFERENCE%TYPE;
2002: l_lock_text OKC_ARTICLE_VERSIONS.LOCK_TEXT%TYPE;
2003: l_global_yn OKC_ARTICLE_VERSIONS.GLOBAL_YN%TYPE;
2004: l_article_language OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;
2005: l_article_language_out OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;
2006: l_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
2007: l_sav_release OKC_ARTICLE_VERSIONS.SAV_RELEASE%TYPE;
2008: l_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE;

Line 2005: l_article_language_out OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;

2001: l_insert_by_reference OKC_ARTICLE_VERSIONS.INSERT_BY_REFERENCE%TYPE;
2002: l_lock_text OKC_ARTICLE_VERSIONS.LOCK_TEXT%TYPE;
2003: l_global_yn OKC_ARTICLE_VERSIONS.GLOBAL_YN%TYPE;
2004: l_article_language OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;
2005: l_article_language_out OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;
2006: l_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
2007: l_sav_release OKC_ARTICLE_VERSIONS.SAV_RELEASE%TYPE;
2008: l_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE;
2009: l_end_date OKC_ARTICLE_VERSIONS.END_DATE%TYPE;

Line 2006: l_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;

2002: l_lock_text OKC_ARTICLE_VERSIONS.LOCK_TEXT%TYPE;
2003: l_global_yn OKC_ARTICLE_VERSIONS.GLOBAL_YN%TYPE;
2004: l_article_language OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;
2005: l_article_language_out OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;
2006: l_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
2007: l_sav_release OKC_ARTICLE_VERSIONS.SAV_RELEASE%TYPE;
2008: l_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE;
2009: l_end_date OKC_ARTICLE_VERSIONS.END_DATE%TYPE;
2010: l_std_article_version_id OKC_ARTICLE_VERSIONS.STD_ARTICLE_VERSION_ID%TYPE;

Line 2007: l_sav_release OKC_ARTICLE_VERSIONS.SAV_RELEASE%TYPE;

2003: l_global_yn OKC_ARTICLE_VERSIONS.GLOBAL_YN%TYPE;
2004: l_article_language OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;
2005: l_article_language_out OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;
2006: l_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
2007: l_sav_release OKC_ARTICLE_VERSIONS.SAV_RELEASE%TYPE;
2008: l_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE;
2009: l_end_date OKC_ARTICLE_VERSIONS.END_DATE%TYPE;
2010: l_std_article_version_id OKC_ARTICLE_VERSIONS.STD_ARTICLE_VERSION_ID%TYPE;
2011: l_display_name OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE;

Line 2008: l_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE;

2004: l_article_language OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;
2005: l_article_language_out OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;
2006: l_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
2007: l_sav_release OKC_ARTICLE_VERSIONS.SAV_RELEASE%TYPE;
2008: l_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE;
2009: l_end_date OKC_ARTICLE_VERSIONS.END_DATE%TYPE;
2010: l_std_article_version_id OKC_ARTICLE_VERSIONS.STD_ARTICLE_VERSION_ID%TYPE;
2011: l_display_name OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE;
2012: l_translated_yn OKC_ARTICLE_VERSIONS.TRANSLATED_YN%TYPE;

Line 2009: l_end_date OKC_ARTICLE_VERSIONS.END_DATE%TYPE;

2005: l_article_language_out OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;
2006: l_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
2007: l_sav_release OKC_ARTICLE_VERSIONS.SAV_RELEASE%TYPE;
2008: l_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE;
2009: l_end_date OKC_ARTICLE_VERSIONS.END_DATE%TYPE;
2010: l_std_article_version_id OKC_ARTICLE_VERSIONS.STD_ARTICLE_VERSION_ID%TYPE;
2011: l_display_name OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE;
2012: l_translated_yn OKC_ARTICLE_VERSIONS.TRANSLATED_YN%TYPE;
2013: l_article_description OKC_ARTICLE_VERSIONS.ARTICLE_DESCRIPTION%TYPE;

Line 2010: l_std_article_version_id OKC_ARTICLE_VERSIONS.STD_ARTICLE_VERSION_ID%TYPE;

2006: l_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
2007: l_sav_release OKC_ARTICLE_VERSIONS.SAV_RELEASE%TYPE;
2008: l_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE;
2009: l_end_date OKC_ARTICLE_VERSIONS.END_DATE%TYPE;
2010: l_std_article_version_id OKC_ARTICLE_VERSIONS.STD_ARTICLE_VERSION_ID%TYPE;
2011: l_display_name OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE;
2012: l_translated_yn OKC_ARTICLE_VERSIONS.TRANSLATED_YN%TYPE;
2013: l_article_description OKC_ARTICLE_VERSIONS.ARTICLE_DESCRIPTION%TYPE;
2014: l_date_approved OKC_ARTICLE_VERSIONS.DATE_APPROVED%TYPE;

Line 2011: l_display_name OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE;

2007: l_sav_release OKC_ARTICLE_VERSIONS.SAV_RELEASE%TYPE;
2008: l_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE;
2009: l_end_date OKC_ARTICLE_VERSIONS.END_DATE%TYPE;
2010: l_std_article_version_id OKC_ARTICLE_VERSIONS.STD_ARTICLE_VERSION_ID%TYPE;
2011: l_display_name OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE;
2012: l_translated_yn OKC_ARTICLE_VERSIONS.TRANSLATED_YN%TYPE;
2013: l_article_description OKC_ARTICLE_VERSIONS.ARTICLE_DESCRIPTION%TYPE;
2014: l_date_approved OKC_ARTICLE_VERSIONS.DATE_APPROVED%TYPE;
2015: l_default_section OKC_ARTICLE_VERSIONS.DEFAULT_SECTION%TYPE;

Line 2012: l_translated_yn OKC_ARTICLE_VERSIONS.TRANSLATED_YN%TYPE;

2008: l_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE;
2009: l_end_date OKC_ARTICLE_VERSIONS.END_DATE%TYPE;
2010: l_std_article_version_id OKC_ARTICLE_VERSIONS.STD_ARTICLE_VERSION_ID%TYPE;
2011: l_display_name OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE;
2012: l_translated_yn OKC_ARTICLE_VERSIONS.TRANSLATED_YN%TYPE;
2013: l_article_description OKC_ARTICLE_VERSIONS.ARTICLE_DESCRIPTION%TYPE;
2014: l_date_approved OKC_ARTICLE_VERSIONS.DATE_APPROVED%TYPE;
2015: l_default_section OKC_ARTICLE_VERSIONS.DEFAULT_SECTION%TYPE;
2016: l_reference_source OKC_ARTICLE_VERSIONS.REFERENCE_SOURCE%TYPE;

Line 2013: l_article_description OKC_ARTICLE_VERSIONS.ARTICLE_DESCRIPTION%TYPE;

2009: l_end_date OKC_ARTICLE_VERSIONS.END_DATE%TYPE;
2010: l_std_article_version_id OKC_ARTICLE_VERSIONS.STD_ARTICLE_VERSION_ID%TYPE;
2011: l_display_name OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE;
2012: l_translated_yn OKC_ARTICLE_VERSIONS.TRANSLATED_YN%TYPE;
2013: l_article_description OKC_ARTICLE_VERSIONS.ARTICLE_DESCRIPTION%TYPE;
2014: l_date_approved OKC_ARTICLE_VERSIONS.DATE_APPROVED%TYPE;
2015: l_default_section OKC_ARTICLE_VERSIONS.DEFAULT_SECTION%TYPE;
2016: l_reference_source OKC_ARTICLE_VERSIONS.REFERENCE_SOURCE%TYPE;
2017: l_reference_text OKC_ARTICLE_VERSIONS.REFERENCE_TEXT%TYPE;

Line 2014: l_date_approved OKC_ARTICLE_VERSIONS.DATE_APPROVED%TYPE;

2010: l_std_article_version_id OKC_ARTICLE_VERSIONS.STD_ARTICLE_VERSION_ID%TYPE;
2011: l_display_name OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE;
2012: l_translated_yn OKC_ARTICLE_VERSIONS.TRANSLATED_YN%TYPE;
2013: l_article_description OKC_ARTICLE_VERSIONS.ARTICLE_DESCRIPTION%TYPE;
2014: l_date_approved OKC_ARTICLE_VERSIONS.DATE_APPROVED%TYPE;
2015: l_default_section OKC_ARTICLE_VERSIONS.DEFAULT_SECTION%TYPE;
2016: l_reference_source OKC_ARTICLE_VERSIONS.REFERENCE_SOURCE%TYPE;
2017: l_reference_text OKC_ARTICLE_VERSIONS.REFERENCE_TEXT%TYPE;
2018: l_orig_system_reference_code OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_CODE%TYPE;

Line 2015: l_default_section OKC_ARTICLE_VERSIONS.DEFAULT_SECTION%TYPE;

2011: l_display_name OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE;
2012: l_translated_yn OKC_ARTICLE_VERSIONS.TRANSLATED_YN%TYPE;
2013: l_article_description OKC_ARTICLE_VERSIONS.ARTICLE_DESCRIPTION%TYPE;
2014: l_date_approved OKC_ARTICLE_VERSIONS.DATE_APPROVED%TYPE;
2015: l_default_section OKC_ARTICLE_VERSIONS.DEFAULT_SECTION%TYPE;
2016: l_reference_source OKC_ARTICLE_VERSIONS.REFERENCE_SOURCE%TYPE;
2017: l_reference_text OKC_ARTICLE_VERSIONS.REFERENCE_TEXT%TYPE;
2018: l_orig_system_reference_code OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
2019: l_orig_system_reference_id1 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID1%TYPE;

Line 2016: l_reference_source OKC_ARTICLE_VERSIONS.REFERENCE_SOURCE%TYPE;

2012: l_translated_yn OKC_ARTICLE_VERSIONS.TRANSLATED_YN%TYPE;
2013: l_article_description OKC_ARTICLE_VERSIONS.ARTICLE_DESCRIPTION%TYPE;
2014: l_date_approved OKC_ARTICLE_VERSIONS.DATE_APPROVED%TYPE;
2015: l_default_section OKC_ARTICLE_VERSIONS.DEFAULT_SECTION%TYPE;
2016: l_reference_source OKC_ARTICLE_VERSIONS.REFERENCE_SOURCE%TYPE;
2017: l_reference_text OKC_ARTICLE_VERSIONS.REFERENCE_TEXT%TYPE;
2018: l_orig_system_reference_code OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
2019: l_orig_system_reference_id1 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
2020: l_orig_system_reference_id2 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID2%TYPE;

Line 2017: l_reference_text OKC_ARTICLE_VERSIONS.REFERENCE_TEXT%TYPE;

2013: l_article_description OKC_ARTICLE_VERSIONS.ARTICLE_DESCRIPTION%TYPE;
2014: l_date_approved OKC_ARTICLE_VERSIONS.DATE_APPROVED%TYPE;
2015: l_default_section OKC_ARTICLE_VERSIONS.DEFAULT_SECTION%TYPE;
2016: l_reference_source OKC_ARTICLE_VERSIONS.REFERENCE_SOURCE%TYPE;
2017: l_reference_text OKC_ARTICLE_VERSIONS.REFERENCE_TEXT%TYPE;
2018: l_orig_system_reference_code OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
2019: l_orig_system_reference_id1 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
2020: l_orig_system_reference_id2 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
2021: l_additional_instructions OKC_ARTICLE_VERSIONS.ADDITIONAL_INSTRUCTIONS%TYPE;

Line 2018: l_orig_system_reference_code OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_CODE%TYPE;

2014: l_date_approved OKC_ARTICLE_VERSIONS.DATE_APPROVED%TYPE;
2015: l_default_section OKC_ARTICLE_VERSIONS.DEFAULT_SECTION%TYPE;
2016: l_reference_source OKC_ARTICLE_VERSIONS.REFERENCE_SOURCE%TYPE;
2017: l_reference_text OKC_ARTICLE_VERSIONS.REFERENCE_TEXT%TYPE;
2018: l_orig_system_reference_code OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
2019: l_orig_system_reference_id1 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
2020: l_orig_system_reference_id2 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
2021: l_additional_instructions OKC_ARTICLE_VERSIONS.ADDITIONAL_INSTRUCTIONS%TYPE;
2022: l_variation_description OKC_ARTICLE_VERSIONS.VARIATION_DESCRIPTION%TYPE;

Line 2019: l_orig_system_reference_id1 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID1%TYPE;

2015: l_default_section OKC_ARTICLE_VERSIONS.DEFAULT_SECTION%TYPE;
2016: l_reference_source OKC_ARTICLE_VERSIONS.REFERENCE_SOURCE%TYPE;
2017: l_reference_text OKC_ARTICLE_VERSIONS.REFERENCE_TEXT%TYPE;
2018: l_orig_system_reference_code OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
2019: l_orig_system_reference_id1 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
2020: l_orig_system_reference_id2 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
2021: l_additional_instructions OKC_ARTICLE_VERSIONS.ADDITIONAL_INSTRUCTIONS%TYPE;
2022: l_variation_description OKC_ARTICLE_VERSIONS.VARIATION_DESCRIPTION%TYPE;
2023: l_date_published OKC_ARTICLE_VERSIONS.DATE_PUBLISHED%TYPE;

Line 2020: l_orig_system_reference_id2 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID2%TYPE;

2016: l_reference_source OKC_ARTICLE_VERSIONS.REFERENCE_SOURCE%TYPE;
2017: l_reference_text OKC_ARTICLE_VERSIONS.REFERENCE_TEXT%TYPE;
2018: l_orig_system_reference_code OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
2019: l_orig_system_reference_id1 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
2020: l_orig_system_reference_id2 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
2021: l_additional_instructions OKC_ARTICLE_VERSIONS.ADDITIONAL_INSTRUCTIONS%TYPE;
2022: l_variation_description OKC_ARTICLE_VERSIONS.VARIATION_DESCRIPTION%TYPE;
2023: l_date_published OKC_ARTICLE_VERSIONS.DATE_PUBLISHED%TYPE;
2024: l_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE;

Line 2021: l_additional_instructions OKC_ARTICLE_VERSIONS.ADDITIONAL_INSTRUCTIONS%TYPE;

2017: l_reference_text OKC_ARTICLE_VERSIONS.REFERENCE_TEXT%TYPE;
2018: l_orig_system_reference_code OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
2019: l_orig_system_reference_id1 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
2020: l_orig_system_reference_id2 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
2021: l_additional_instructions OKC_ARTICLE_VERSIONS.ADDITIONAL_INSTRUCTIONS%TYPE;
2022: l_variation_description OKC_ARTICLE_VERSIONS.VARIATION_DESCRIPTION%TYPE;
2023: l_date_published OKC_ARTICLE_VERSIONS.DATE_PUBLISHED%TYPE;
2024: l_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE;
2025: l_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE;

Line 2022: l_variation_description OKC_ARTICLE_VERSIONS.VARIATION_DESCRIPTION%TYPE;

2018: l_orig_system_reference_code OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
2019: l_orig_system_reference_id1 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
2020: l_orig_system_reference_id2 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
2021: l_additional_instructions OKC_ARTICLE_VERSIONS.ADDITIONAL_INSTRUCTIONS%TYPE;
2022: l_variation_description OKC_ARTICLE_VERSIONS.VARIATION_DESCRIPTION%TYPE;
2023: l_date_published OKC_ARTICLE_VERSIONS.DATE_PUBLISHED%TYPE;
2024: l_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE;
2025: l_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE;
2026: l_program_application_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE;

Line 2023: l_date_published OKC_ARTICLE_VERSIONS.DATE_PUBLISHED%TYPE;

2019: l_orig_system_reference_id1 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
2020: l_orig_system_reference_id2 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
2021: l_additional_instructions OKC_ARTICLE_VERSIONS.ADDITIONAL_INSTRUCTIONS%TYPE;
2022: l_variation_description OKC_ARTICLE_VERSIONS.VARIATION_DESCRIPTION%TYPE;
2023: l_date_published OKC_ARTICLE_VERSIONS.DATE_PUBLISHED%TYPE;
2024: l_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE;
2025: l_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE;
2026: l_program_application_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE;
2027: l_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE;

Line 2024: l_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE;

2020: l_orig_system_reference_id2 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
2021: l_additional_instructions OKC_ARTICLE_VERSIONS.ADDITIONAL_INSTRUCTIONS%TYPE;
2022: l_variation_description OKC_ARTICLE_VERSIONS.VARIATION_DESCRIPTION%TYPE;
2023: l_date_published OKC_ARTICLE_VERSIONS.DATE_PUBLISHED%TYPE;
2024: l_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE;
2025: l_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE;
2026: l_program_application_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE;
2027: l_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE;
2028: l_attribute_category OKC_ARTICLE_VERSIONS.ATTRIBUTE_CATEGORY%TYPE;

Line 2025: l_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE;

2021: l_additional_instructions OKC_ARTICLE_VERSIONS.ADDITIONAL_INSTRUCTIONS%TYPE;
2022: l_variation_description OKC_ARTICLE_VERSIONS.VARIATION_DESCRIPTION%TYPE;
2023: l_date_published OKC_ARTICLE_VERSIONS.DATE_PUBLISHED%TYPE;
2024: l_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE;
2025: l_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE;
2026: l_program_application_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE;
2027: l_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE;
2028: l_attribute_category OKC_ARTICLE_VERSIONS.ATTRIBUTE_CATEGORY%TYPE;
2029: l_attribute1 OKC_ARTICLE_VERSIONS.ATTRIBUTE1%TYPE;

Line 2026: l_program_application_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE;

2022: l_variation_description OKC_ARTICLE_VERSIONS.VARIATION_DESCRIPTION%TYPE;
2023: l_date_published OKC_ARTICLE_VERSIONS.DATE_PUBLISHED%TYPE;
2024: l_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE;
2025: l_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE;
2026: l_program_application_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE;
2027: l_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE;
2028: l_attribute_category OKC_ARTICLE_VERSIONS.ATTRIBUTE_CATEGORY%TYPE;
2029: l_attribute1 OKC_ARTICLE_VERSIONS.ATTRIBUTE1%TYPE;
2030: l_attribute2 OKC_ARTICLE_VERSIONS.ATTRIBUTE2%TYPE;

Line 2027: l_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE;

2023: l_date_published OKC_ARTICLE_VERSIONS.DATE_PUBLISHED%TYPE;
2024: l_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE;
2025: l_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE;
2026: l_program_application_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE;
2027: l_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE;
2028: l_attribute_category OKC_ARTICLE_VERSIONS.ATTRIBUTE_CATEGORY%TYPE;
2029: l_attribute1 OKC_ARTICLE_VERSIONS.ATTRIBUTE1%TYPE;
2030: l_attribute2 OKC_ARTICLE_VERSIONS.ATTRIBUTE2%TYPE;
2031: l_attribute3 OKC_ARTICLE_VERSIONS.ATTRIBUTE3%TYPE;

Line 2028: l_attribute_category OKC_ARTICLE_VERSIONS.ATTRIBUTE_CATEGORY%TYPE;

2024: l_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE;
2025: l_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE;
2026: l_program_application_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE;
2027: l_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE;
2028: l_attribute_category OKC_ARTICLE_VERSIONS.ATTRIBUTE_CATEGORY%TYPE;
2029: l_attribute1 OKC_ARTICLE_VERSIONS.ATTRIBUTE1%TYPE;
2030: l_attribute2 OKC_ARTICLE_VERSIONS.ATTRIBUTE2%TYPE;
2031: l_attribute3 OKC_ARTICLE_VERSIONS.ATTRIBUTE3%TYPE;
2032: l_attribute4 OKC_ARTICLE_VERSIONS.ATTRIBUTE4%TYPE;

Line 2029: l_attribute1 OKC_ARTICLE_VERSIONS.ATTRIBUTE1%TYPE;

2025: l_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE;
2026: l_program_application_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE;
2027: l_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE;
2028: l_attribute_category OKC_ARTICLE_VERSIONS.ATTRIBUTE_CATEGORY%TYPE;
2029: l_attribute1 OKC_ARTICLE_VERSIONS.ATTRIBUTE1%TYPE;
2030: l_attribute2 OKC_ARTICLE_VERSIONS.ATTRIBUTE2%TYPE;
2031: l_attribute3 OKC_ARTICLE_VERSIONS.ATTRIBUTE3%TYPE;
2032: l_attribute4 OKC_ARTICLE_VERSIONS.ATTRIBUTE4%TYPE;
2033: l_attribute5 OKC_ARTICLE_VERSIONS.ATTRIBUTE5%TYPE;

Line 2030: l_attribute2 OKC_ARTICLE_VERSIONS.ATTRIBUTE2%TYPE;

2026: l_program_application_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE;
2027: l_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE;
2028: l_attribute_category OKC_ARTICLE_VERSIONS.ATTRIBUTE_CATEGORY%TYPE;
2029: l_attribute1 OKC_ARTICLE_VERSIONS.ATTRIBUTE1%TYPE;
2030: l_attribute2 OKC_ARTICLE_VERSIONS.ATTRIBUTE2%TYPE;
2031: l_attribute3 OKC_ARTICLE_VERSIONS.ATTRIBUTE3%TYPE;
2032: l_attribute4 OKC_ARTICLE_VERSIONS.ATTRIBUTE4%TYPE;
2033: l_attribute5 OKC_ARTICLE_VERSIONS.ATTRIBUTE5%TYPE;
2034: l_attribute6 OKC_ARTICLE_VERSIONS.ATTRIBUTE6%TYPE;

Line 2031: l_attribute3 OKC_ARTICLE_VERSIONS.ATTRIBUTE3%TYPE;

2027: l_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE;
2028: l_attribute_category OKC_ARTICLE_VERSIONS.ATTRIBUTE_CATEGORY%TYPE;
2029: l_attribute1 OKC_ARTICLE_VERSIONS.ATTRIBUTE1%TYPE;
2030: l_attribute2 OKC_ARTICLE_VERSIONS.ATTRIBUTE2%TYPE;
2031: l_attribute3 OKC_ARTICLE_VERSIONS.ATTRIBUTE3%TYPE;
2032: l_attribute4 OKC_ARTICLE_VERSIONS.ATTRIBUTE4%TYPE;
2033: l_attribute5 OKC_ARTICLE_VERSIONS.ATTRIBUTE5%TYPE;
2034: l_attribute6 OKC_ARTICLE_VERSIONS.ATTRIBUTE6%TYPE;
2035: l_attribute7 OKC_ARTICLE_VERSIONS.ATTRIBUTE7%TYPE;

Line 2032: l_attribute4 OKC_ARTICLE_VERSIONS.ATTRIBUTE4%TYPE;

2028: l_attribute_category OKC_ARTICLE_VERSIONS.ATTRIBUTE_CATEGORY%TYPE;
2029: l_attribute1 OKC_ARTICLE_VERSIONS.ATTRIBUTE1%TYPE;
2030: l_attribute2 OKC_ARTICLE_VERSIONS.ATTRIBUTE2%TYPE;
2031: l_attribute3 OKC_ARTICLE_VERSIONS.ATTRIBUTE3%TYPE;
2032: l_attribute4 OKC_ARTICLE_VERSIONS.ATTRIBUTE4%TYPE;
2033: l_attribute5 OKC_ARTICLE_VERSIONS.ATTRIBUTE5%TYPE;
2034: l_attribute6 OKC_ARTICLE_VERSIONS.ATTRIBUTE6%TYPE;
2035: l_attribute7 OKC_ARTICLE_VERSIONS.ATTRIBUTE7%TYPE;
2036: l_attribute8 OKC_ARTICLE_VERSIONS.ATTRIBUTE8%TYPE;

Line 2033: l_attribute5 OKC_ARTICLE_VERSIONS.ATTRIBUTE5%TYPE;

2029: l_attribute1 OKC_ARTICLE_VERSIONS.ATTRIBUTE1%TYPE;
2030: l_attribute2 OKC_ARTICLE_VERSIONS.ATTRIBUTE2%TYPE;
2031: l_attribute3 OKC_ARTICLE_VERSIONS.ATTRIBUTE3%TYPE;
2032: l_attribute4 OKC_ARTICLE_VERSIONS.ATTRIBUTE4%TYPE;
2033: l_attribute5 OKC_ARTICLE_VERSIONS.ATTRIBUTE5%TYPE;
2034: l_attribute6 OKC_ARTICLE_VERSIONS.ATTRIBUTE6%TYPE;
2035: l_attribute7 OKC_ARTICLE_VERSIONS.ATTRIBUTE7%TYPE;
2036: l_attribute8 OKC_ARTICLE_VERSIONS.ATTRIBUTE8%TYPE;
2037: l_attribute9 OKC_ARTICLE_VERSIONS.ATTRIBUTE9%TYPE;

Line 2034: l_attribute6 OKC_ARTICLE_VERSIONS.ATTRIBUTE6%TYPE;

2030: l_attribute2 OKC_ARTICLE_VERSIONS.ATTRIBUTE2%TYPE;
2031: l_attribute3 OKC_ARTICLE_VERSIONS.ATTRIBUTE3%TYPE;
2032: l_attribute4 OKC_ARTICLE_VERSIONS.ATTRIBUTE4%TYPE;
2033: l_attribute5 OKC_ARTICLE_VERSIONS.ATTRIBUTE5%TYPE;
2034: l_attribute6 OKC_ARTICLE_VERSIONS.ATTRIBUTE6%TYPE;
2035: l_attribute7 OKC_ARTICLE_VERSIONS.ATTRIBUTE7%TYPE;
2036: l_attribute8 OKC_ARTICLE_VERSIONS.ATTRIBUTE8%TYPE;
2037: l_attribute9 OKC_ARTICLE_VERSIONS.ATTRIBUTE9%TYPE;
2038: l_attribute10 OKC_ARTICLE_VERSIONS.ATTRIBUTE10%TYPE;

Line 2035: l_attribute7 OKC_ARTICLE_VERSIONS.ATTRIBUTE7%TYPE;

2031: l_attribute3 OKC_ARTICLE_VERSIONS.ATTRIBUTE3%TYPE;
2032: l_attribute4 OKC_ARTICLE_VERSIONS.ATTRIBUTE4%TYPE;
2033: l_attribute5 OKC_ARTICLE_VERSIONS.ATTRIBUTE5%TYPE;
2034: l_attribute6 OKC_ARTICLE_VERSIONS.ATTRIBUTE6%TYPE;
2035: l_attribute7 OKC_ARTICLE_VERSIONS.ATTRIBUTE7%TYPE;
2036: l_attribute8 OKC_ARTICLE_VERSIONS.ATTRIBUTE8%TYPE;
2037: l_attribute9 OKC_ARTICLE_VERSIONS.ATTRIBUTE9%TYPE;
2038: l_attribute10 OKC_ARTICLE_VERSIONS.ATTRIBUTE10%TYPE;
2039: l_attribute11 OKC_ARTICLE_VERSIONS.ATTRIBUTE11%TYPE;

Line 2036: l_attribute8 OKC_ARTICLE_VERSIONS.ATTRIBUTE8%TYPE;

2032: l_attribute4 OKC_ARTICLE_VERSIONS.ATTRIBUTE4%TYPE;
2033: l_attribute5 OKC_ARTICLE_VERSIONS.ATTRIBUTE5%TYPE;
2034: l_attribute6 OKC_ARTICLE_VERSIONS.ATTRIBUTE6%TYPE;
2035: l_attribute7 OKC_ARTICLE_VERSIONS.ATTRIBUTE7%TYPE;
2036: l_attribute8 OKC_ARTICLE_VERSIONS.ATTRIBUTE8%TYPE;
2037: l_attribute9 OKC_ARTICLE_VERSIONS.ATTRIBUTE9%TYPE;
2038: l_attribute10 OKC_ARTICLE_VERSIONS.ATTRIBUTE10%TYPE;
2039: l_attribute11 OKC_ARTICLE_VERSIONS.ATTRIBUTE11%TYPE;
2040: l_attribute12 OKC_ARTICLE_VERSIONS.ATTRIBUTE12%TYPE;

Line 2037: l_attribute9 OKC_ARTICLE_VERSIONS.ATTRIBUTE9%TYPE;

2033: l_attribute5 OKC_ARTICLE_VERSIONS.ATTRIBUTE5%TYPE;
2034: l_attribute6 OKC_ARTICLE_VERSIONS.ATTRIBUTE6%TYPE;
2035: l_attribute7 OKC_ARTICLE_VERSIONS.ATTRIBUTE7%TYPE;
2036: l_attribute8 OKC_ARTICLE_VERSIONS.ATTRIBUTE8%TYPE;
2037: l_attribute9 OKC_ARTICLE_VERSIONS.ATTRIBUTE9%TYPE;
2038: l_attribute10 OKC_ARTICLE_VERSIONS.ATTRIBUTE10%TYPE;
2039: l_attribute11 OKC_ARTICLE_VERSIONS.ATTRIBUTE11%TYPE;
2040: l_attribute12 OKC_ARTICLE_VERSIONS.ATTRIBUTE12%TYPE;
2041: l_attribute13 OKC_ARTICLE_VERSIONS.ATTRIBUTE13%TYPE;

Line 2038: l_attribute10 OKC_ARTICLE_VERSIONS.ATTRIBUTE10%TYPE;

2034: l_attribute6 OKC_ARTICLE_VERSIONS.ATTRIBUTE6%TYPE;
2035: l_attribute7 OKC_ARTICLE_VERSIONS.ATTRIBUTE7%TYPE;
2036: l_attribute8 OKC_ARTICLE_VERSIONS.ATTRIBUTE8%TYPE;
2037: l_attribute9 OKC_ARTICLE_VERSIONS.ATTRIBUTE9%TYPE;
2038: l_attribute10 OKC_ARTICLE_VERSIONS.ATTRIBUTE10%TYPE;
2039: l_attribute11 OKC_ARTICLE_VERSIONS.ATTRIBUTE11%TYPE;
2040: l_attribute12 OKC_ARTICLE_VERSIONS.ATTRIBUTE12%TYPE;
2041: l_attribute13 OKC_ARTICLE_VERSIONS.ATTRIBUTE13%TYPE;
2042: l_attribute14 OKC_ARTICLE_VERSIONS.ATTRIBUTE14%TYPE;

Line 2039: l_attribute11 OKC_ARTICLE_VERSIONS.ATTRIBUTE11%TYPE;

2035: l_attribute7 OKC_ARTICLE_VERSIONS.ATTRIBUTE7%TYPE;
2036: l_attribute8 OKC_ARTICLE_VERSIONS.ATTRIBUTE8%TYPE;
2037: l_attribute9 OKC_ARTICLE_VERSIONS.ATTRIBUTE9%TYPE;
2038: l_attribute10 OKC_ARTICLE_VERSIONS.ATTRIBUTE10%TYPE;
2039: l_attribute11 OKC_ARTICLE_VERSIONS.ATTRIBUTE11%TYPE;
2040: l_attribute12 OKC_ARTICLE_VERSIONS.ATTRIBUTE12%TYPE;
2041: l_attribute13 OKC_ARTICLE_VERSIONS.ATTRIBUTE13%TYPE;
2042: l_attribute14 OKC_ARTICLE_VERSIONS.ATTRIBUTE14%TYPE;
2043: l_attribute15 OKC_ARTICLE_VERSIONS.ATTRIBUTE15%TYPE;

Line 2040: l_attribute12 OKC_ARTICLE_VERSIONS.ATTRIBUTE12%TYPE;

2036: l_attribute8 OKC_ARTICLE_VERSIONS.ATTRIBUTE8%TYPE;
2037: l_attribute9 OKC_ARTICLE_VERSIONS.ATTRIBUTE9%TYPE;
2038: l_attribute10 OKC_ARTICLE_VERSIONS.ATTRIBUTE10%TYPE;
2039: l_attribute11 OKC_ARTICLE_VERSIONS.ATTRIBUTE11%TYPE;
2040: l_attribute12 OKC_ARTICLE_VERSIONS.ATTRIBUTE12%TYPE;
2041: l_attribute13 OKC_ARTICLE_VERSIONS.ATTRIBUTE13%TYPE;
2042: l_attribute14 OKC_ARTICLE_VERSIONS.ATTRIBUTE14%TYPE;
2043: l_attribute15 OKC_ARTICLE_VERSIONS.ATTRIBUTE15%TYPE;
2044: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;

Line 2041: l_attribute13 OKC_ARTICLE_VERSIONS.ATTRIBUTE13%TYPE;

2037: l_attribute9 OKC_ARTICLE_VERSIONS.ATTRIBUTE9%TYPE;
2038: l_attribute10 OKC_ARTICLE_VERSIONS.ATTRIBUTE10%TYPE;
2039: l_attribute11 OKC_ARTICLE_VERSIONS.ATTRIBUTE11%TYPE;
2040: l_attribute12 OKC_ARTICLE_VERSIONS.ATTRIBUTE12%TYPE;
2041: l_attribute13 OKC_ARTICLE_VERSIONS.ATTRIBUTE13%TYPE;
2042: l_attribute14 OKC_ARTICLE_VERSIONS.ATTRIBUTE14%TYPE;
2043: l_attribute15 OKC_ARTICLE_VERSIONS.ATTRIBUTE15%TYPE;
2044: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;
2045: l_edited_in_word OKC_ARTICLE_VERSIONS.EDITED_IN_WORD%TYPE;

Line 2042: l_attribute14 OKC_ARTICLE_VERSIONS.ATTRIBUTE14%TYPE;

2038: l_attribute10 OKC_ARTICLE_VERSIONS.ATTRIBUTE10%TYPE;
2039: l_attribute11 OKC_ARTICLE_VERSIONS.ATTRIBUTE11%TYPE;
2040: l_attribute12 OKC_ARTICLE_VERSIONS.ATTRIBUTE12%TYPE;
2041: l_attribute13 OKC_ARTICLE_VERSIONS.ATTRIBUTE13%TYPE;
2042: l_attribute14 OKC_ARTICLE_VERSIONS.ATTRIBUTE14%TYPE;
2043: l_attribute15 OKC_ARTICLE_VERSIONS.ATTRIBUTE15%TYPE;
2044: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;
2045: l_edited_in_word OKC_ARTICLE_VERSIONS.EDITED_IN_WORD%TYPE;
2046: l_article_text_in_word OKC_ARTICLE_VERSIONS.ARTICLE_TEXT_IN_WORD%TYPE;

Line 2043: l_attribute15 OKC_ARTICLE_VERSIONS.ATTRIBUTE15%TYPE;

2039: l_attribute11 OKC_ARTICLE_VERSIONS.ATTRIBUTE11%TYPE;
2040: l_attribute12 OKC_ARTICLE_VERSIONS.ATTRIBUTE12%TYPE;
2041: l_attribute13 OKC_ARTICLE_VERSIONS.ATTRIBUTE13%TYPE;
2042: l_attribute14 OKC_ARTICLE_VERSIONS.ATTRIBUTE14%TYPE;
2043: l_attribute15 OKC_ARTICLE_VERSIONS.ATTRIBUTE15%TYPE;
2044: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;
2045: l_edited_in_word OKC_ARTICLE_VERSIONS.EDITED_IN_WORD%TYPE;
2046: l_article_text_in_word OKC_ARTICLE_VERSIONS.ARTICLE_TEXT_IN_WORD%TYPE;
2047: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;

Line 2044: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;

2040: l_attribute12 OKC_ARTICLE_VERSIONS.ATTRIBUTE12%TYPE;
2041: l_attribute13 OKC_ARTICLE_VERSIONS.ATTRIBUTE13%TYPE;
2042: l_attribute14 OKC_ARTICLE_VERSIONS.ATTRIBUTE14%TYPE;
2043: l_attribute15 OKC_ARTICLE_VERSIONS.ATTRIBUTE15%TYPE;
2044: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;
2045: l_edited_in_word OKC_ARTICLE_VERSIONS.EDITED_IN_WORD%TYPE;
2046: l_article_text_in_word OKC_ARTICLE_VERSIONS.ARTICLE_TEXT_IN_WORD%TYPE;
2047: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
2048: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;

Line 2045: l_edited_in_word OKC_ARTICLE_VERSIONS.EDITED_IN_WORD%TYPE;

2041: l_attribute13 OKC_ARTICLE_VERSIONS.ATTRIBUTE13%TYPE;
2042: l_attribute14 OKC_ARTICLE_VERSIONS.ATTRIBUTE14%TYPE;
2043: l_attribute15 OKC_ARTICLE_VERSIONS.ATTRIBUTE15%TYPE;
2044: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;
2045: l_edited_in_word OKC_ARTICLE_VERSIONS.EDITED_IN_WORD%TYPE;
2046: l_article_text_in_word OKC_ARTICLE_VERSIONS.ARTICLE_TEXT_IN_WORD%TYPE;
2047: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
2048: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
2049: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;

Line 2046: l_article_text_in_word OKC_ARTICLE_VERSIONS.ARTICLE_TEXT_IN_WORD%TYPE;

2042: l_attribute14 OKC_ARTICLE_VERSIONS.ATTRIBUTE14%TYPE;
2043: l_attribute15 OKC_ARTICLE_VERSIONS.ATTRIBUTE15%TYPE;
2044: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;
2045: l_edited_in_word OKC_ARTICLE_VERSIONS.EDITED_IN_WORD%TYPE;
2046: l_article_text_in_word OKC_ARTICLE_VERSIONS.ARTICLE_TEXT_IN_WORD%TYPE;
2047: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
2048: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
2049: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
2050: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;

Line 2047: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;

2043: l_attribute15 OKC_ARTICLE_VERSIONS.ATTRIBUTE15%TYPE;
2044: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;
2045: l_edited_in_word OKC_ARTICLE_VERSIONS.EDITED_IN_WORD%TYPE;
2046: l_article_text_in_word OKC_ARTICLE_VERSIONS.ARTICLE_TEXT_IN_WORD%TYPE;
2047: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
2048: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
2049: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
2050: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
2051: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;

Line 2048: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;

2044: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;
2045: l_edited_in_word OKC_ARTICLE_VERSIONS.EDITED_IN_WORD%TYPE;
2046: l_article_text_in_word OKC_ARTICLE_VERSIONS.ARTICLE_TEXT_IN_WORD%TYPE;
2047: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
2048: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
2049: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
2050: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
2051: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;
2052: l_earlier_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;

Line 2049: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;

2045: l_edited_in_word OKC_ARTICLE_VERSIONS.EDITED_IN_WORD%TYPE;
2046: l_article_text_in_word OKC_ARTICLE_VERSIONS.ARTICLE_TEXT_IN_WORD%TYPE;
2047: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
2048: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
2049: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
2050: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
2051: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;
2052: l_earlier_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
2053: l_earlier_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE;

Line 2050: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;

2046: l_article_text_in_word OKC_ARTICLE_VERSIONS.ARTICLE_TEXT_IN_WORD%TYPE;
2047: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
2048: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
2049: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
2050: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
2051: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;
2052: l_earlier_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
2053: l_earlier_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE;
2054: l_variable_code OKC_ARTICLE_VERSIONS.VARIABLE_CODE%TYPE; --clm

Line 2051: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;

2047: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
2048: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
2049: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
2050: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
2051: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;
2052: l_earlier_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
2053: l_earlier_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE;
2054: l_variable_code OKC_ARTICLE_VERSIONS.VARIABLE_CODE%TYPE; --clm
2055:

Line 2052: l_earlier_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;

2048: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
2049: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
2050: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
2051: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;
2052: l_earlier_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
2053: l_earlier_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE;
2054: l_variable_code OKC_ARTICLE_VERSIONS.VARIABLE_CODE%TYPE; --clm
2055:
2056: BEGIN

Line 2053: l_earlier_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE;

2049: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
2050: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
2051: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;
2052: l_earlier_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
2053: l_earlier_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE;
2054: l_variable_code OKC_ARTICLE_VERSIONS.VARIABLE_CODE%TYPE; --clm
2055:
2056: BEGIN
2057:

Line 2054: l_variable_code OKC_ARTICLE_VERSIONS.VARIABLE_CODE%TYPE; --clm

2050: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
2051: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;
2052: l_earlier_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
2053: l_earlier_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE;
2054: l_variable_code OKC_ARTICLE_VERSIONS.VARIABLE_CODE%TYPE; --clm
2055:
2056: BEGIN
2057:
2058: IF (l_debug = 'Y') THEN

Line 2342: -- Insert_Row for:OKC_ARTICLE_VERSIONS --

2338: ---------------------------------------------------------------------------
2339: -- PROCEDURE Insert_Row
2340: ---------------------------------------------------------------------------
2341: -------------------------------------
2342: -- Insert_Row for:OKC_ARTICLE_VERSIONS --
2343: -------------------------------------
2344: FUNCTION Insert_Row(
2345: p_article_version_id IN NUMBER,
2346: p_article_id IN NUMBER,

Line 2406: l_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE;

2402:
2403: ) RETURN VARCHAR2 IS
2404:
2405:
2406: l_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE;
2407: l_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE;
2408: l_program_appl_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE;
2409: l_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE;
2410:

Line 2407: l_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE;

2403: ) RETURN VARCHAR2 IS
2404:
2405:
2406: l_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE;
2407: l_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE;
2408: l_program_appl_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE;
2409: l_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE;
2410:
2411:

Line 2408: l_program_appl_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE;

2404:
2405:
2406: l_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE;
2407: l_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE;
2408: l_program_appl_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE;
2409: l_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE;
2410:
2411:
2412: BEGIN

Line 2409: l_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE;

2405:
2406: l_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE;
2407: l_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE;
2408: l_program_appl_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE;
2409: l_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE;
2410:
2411:
2412: BEGIN
2413:

Line 2437: INSERT INTO OKC_ARTICLE_VERSIONS(

2433: ELSE
2434: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
2435: END IF;
2436:
2437: INSERT INTO OKC_ARTICLE_VERSIONS(
2438: ARTICLE_VERSION_ID,
2439: ARTICLE_ID,
2440: ARTICLE_VERSION_NUMBER,
2441: ARTICLE_TEXT,

Line 2580: -- Insert_Row for:OKC_ARTICLE_VERSIONS --

2576: END Insert_Row;
2577:
2578:
2579: -------------------------------------
2580: -- Insert_Row for:OKC_ARTICLE_VERSIONS --
2581: -------------------------------------
2582: PROCEDURE Insert_Row(
2583: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2584: x_return_status OUT NOCOPY VARCHAR2,

Line 2644: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;

2640: x_article_version_id OUT NOCOPY NUMBER
2641:
2642: ) IS
2643:
2644: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;
2645: l_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
2646: l_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
2647: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
2648: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;

Line 2645: l_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;

2641:
2642: ) IS
2643:
2644: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;
2645: l_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
2646: l_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
2647: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
2648: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
2649: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;

Line 2646: l_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;

2642: ) IS
2643:
2644: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;
2645: l_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
2646: l_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
2647: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
2648: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
2649: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
2650: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;

Line 2647: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;

2643:
2644: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;
2645: l_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
2646: l_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
2647: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
2648: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
2649: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
2650: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
2651: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;

Line 2648: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;

2644: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;
2645: l_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
2646: l_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
2647: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
2648: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
2649: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
2650: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
2651: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;
2652: l_article_language OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;

Line 2649: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;

2645: l_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
2646: l_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
2647: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
2648: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
2649: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
2650: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
2651: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;
2652: l_article_language OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;
2653:

Line 2650: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;

2646: l_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
2647: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
2648: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
2649: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
2650: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
2651: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;
2652: l_article_language OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;
2653:
2654: BEGIN

Line 2651: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;

2647: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
2648: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
2649: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
2650: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
2651: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;
2652: l_article_language OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;
2653:
2654: BEGIN
2655:

Line 2652: l_article_language OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;

2648: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
2649: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
2650: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
2651: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;
2652: l_article_language OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;
2653:
2654: BEGIN
2655:
2656: x_return_status := G_RET_STS_SUCCESS;

Line 2892: -- Lock_Row for:OKC_ARTICLE_VERSIONS --

2888: ---------------------------------------------------------------------------
2889: -- PROCEDURE Lock_Row
2890: ---------------------------------------------------------------------------
2891: -----------------------------------
2892: -- Lock_Row for:OKC_ARTICLE_VERSIONS --
2893: -----------------------------------
2894: FUNCTION Lock_Row(
2895: p_article_version_id IN NUMBER,
2896: p_object_version_number IN NUMBER

Line 2904: FROM OKC_ARTICLE_VERSIONS

2900: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2901:
2902: CURSOR lock_csr (cp_article_version_id NUMBER, cp_object_version_number NUMBER) IS
2903: SELECT object_version_number
2904: FROM OKC_ARTICLE_VERSIONS
2905: WHERE ARTICLE_VERSION_ID = cp_article_version_id
2906: AND (object_version_number = cp_object_version_number OR cp_object_version_number IS NULL)
2907: FOR UPDATE OF object_version_number NOWAIT;
2908:

Line 2911: FROM OKC_ARTICLE_VERSIONS

2907: FOR UPDATE OF object_version_number NOWAIT;
2908:
2909: CURSOR lchk_csr (cp_article_version_id NUMBER) IS
2910: SELECT object_version_number
2911: FROM OKC_ARTICLE_VERSIONS
2912: WHERE ARTICLE_VERSION_ID = cp_article_version_id;
2913:
2914: l_return_status VARCHAR2(1);
2915:

Line 2916: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;

2912: WHERE ARTICLE_VERSION_ID = cp_article_version_id;
2913:
2914: l_return_status VARCHAR2(1);
2915:
2916: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;
2917:
2918: l_row_notfound BOOLEAN := FALSE;
2919: BEGIN
2920:

Line 2998: -- Lock_Row for:OKC_ARTICLE_VERSIONS --

2994: RETURN( G_RET_STS_UNEXP_ERROR );
2995: END Lock_Row;
2996:
2997: -----------------------------------
2998: -- Lock_Row for:OKC_ARTICLE_VERSIONS --
2999: -----------------------------------
3000: PROCEDURE Lock_Row(
3001: x_return_status OUT NOCOPY VARCHAR2,
3002:

Line 3062: -- Update_Row for:OKC_ARTICLE_VERSIONS --

3058: ---------------------------------------------------------------------------
3059: -- PROCEDURE Update_Row
3060: ---------------------------------------------------------------------------
3061: -------------------------------------
3062: -- Update_Row for:OKC_ARTICLE_VERSIONS --
3063: -------------------------------------
3064: FUNCTION Update_Row(
3065: p_article_version_id IN NUMBER,
3066: p_article_id IN NUMBER,

Line 3124: l_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE;

3120: p_variable_code IN VARCHAR2 --clm
3121: ) RETURN VARCHAR2 IS
3122:
3123:
3124: l_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE;
3125: l_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE;
3126: l_program_appl_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE;
3127: l_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE;
3128:

Line 3125: l_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE;

3121: ) RETURN VARCHAR2 IS
3122:
3123:
3124: l_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE;
3125: l_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE;
3126: l_program_appl_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE;
3127: l_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE;
3128:
3129: BEGIN

Line 3126: l_program_appl_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE;

3122:
3123:
3124: l_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE;
3125: l_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE;
3126: l_program_appl_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE;
3127: l_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE;
3128:
3129: BEGIN
3130:

Line 3127: l_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE;

3123:
3124: l_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE;
3125: l_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE;
3126: l_program_appl_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE;
3127: l_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE;
3128:
3129: BEGIN
3130:
3131: IF (l_debug = 'Y') THEN

Line 3154: UPDATE OKC_ARTICLE_VERSIONS

3150: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
3151: END IF;
3152:
3153:
3154: UPDATE OKC_ARTICLE_VERSIONS
3155: SET ARTICLE_ID = p_article_id,
3156: -- ARTICLE_VERSION_NUMBER = p_article_version_number,
3157: ARTICLE_TEXT = p_article_text,
3158: PROVISION_YN = p_provision_yn,

Line 3237: -- Update_Row for:OKC_ARTICLE_VERSIONS --

3233:
3234: END Update_Row;
3235:
3236: -------------------------------------
3237: -- Update_Row for:OKC_ARTICLE_VERSIONS --
3238: -------------------------------------
3239: PROCEDURE Update_Row(
3240: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3241:

Line 3302: l_article_id OKC_ARTICLE_VERSIONS.ARTICLE_ID%TYPE;

3298: x_article_id OUT NOCOPY NUMBER,
3299: x_earlier_version_id OUT NOCOPY NUMBER
3300: ) IS
3301:
3302: l_article_id OKC_ARTICLE_VERSIONS.ARTICLE_ID%TYPE;
3303: l_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
3304: l_article_text OKC_ARTICLE_VERSIONS.ARTICLE_TEXT%TYPE;
3305: l_provision_yn OKC_ARTICLE_VERSIONS.PROVISION_YN%TYPE;
3306: l_insert_by_reference OKC_ARTICLE_VERSIONS.INSERT_BY_REFERENCE%TYPE;

Line 3303: l_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;

3299: x_earlier_version_id OUT NOCOPY NUMBER
3300: ) IS
3301:
3302: l_article_id OKC_ARTICLE_VERSIONS.ARTICLE_ID%TYPE;
3303: l_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
3304: l_article_text OKC_ARTICLE_VERSIONS.ARTICLE_TEXT%TYPE;
3305: l_provision_yn OKC_ARTICLE_VERSIONS.PROVISION_YN%TYPE;
3306: l_insert_by_reference OKC_ARTICLE_VERSIONS.INSERT_BY_REFERENCE%TYPE;
3307: l_lock_text OKC_ARTICLE_VERSIONS.LOCK_TEXT%TYPE;

Line 3304: l_article_text OKC_ARTICLE_VERSIONS.ARTICLE_TEXT%TYPE;

3300: ) IS
3301:
3302: l_article_id OKC_ARTICLE_VERSIONS.ARTICLE_ID%TYPE;
3303: l_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
3304: l_article_text OKC_ARTICLE_VERSIONS.ARTICLE_TEXT%TYPE;
3305: l_provision_yn OKC_ARTICLE_VERSIONS.PROVISION_YN%TYPE;
3306: l_insert_by_reference OKC_ARTICLE_VERSIONS.INSERT_BY_REFERENCE%TYPE;
3307: l_lock_text OKC_ARTICLE_VERSIONS.LOCK_TEXT%TYPE;
3308: l_global_yn OKC_ARTICLE_VERSIONS.GLOBAL_YN%TYPE;

Line 3305: l_provision_yn OKC_ARTICLE_VERSIONS.PROVISION_YN%TYPE;

3301:
3302: l_article_id OKC_ARTICLE_VERSIONS.ARTICLE_ID%TYPE;
3303: l_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
3304: l_article_text OKC_ARTICLE_VERSIONS.ARTICLE_TEXT%TYPE;
3305: l_provision_yn OKC_ARTICLE_VERSIONS.PROVISION_YN%TYPE;
3306: l_insert_by_reference OKC_ARTICLE_VERSIONS.INSERT_BY_REFERENCE%TYPE;
3307: l_lock_text OKC_ARTICLE_VERSIONS.LOCK_TEXT%TYPE;
3308: l_global_yn OKC_ARTICLE_VERSIONS.GLOBAL_YN%TYPE;
3309: l_article_language OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;

Line 3306: l_insert_by_reference OKC_ARTICLE_VERSIONS.INSERT_BY_REFERENCE%TYPE;

3302: l_article_id OKC_ARTICLE_VERSIONS.ARTICLE_ID%TYPE;
3303: l_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
3304: l_article_text OKC_ARTICLE_VERSIONS.ARTICLE_TEXT%TYPE;
3305: l_provision_yn OKC_ARTICLE_VERSIONS.PROVISION_YN%TYPE;
3306: l_insert_by_reference OKC_ARTICLE_VERSIONS.INSERT_BY_REFERENCE%TYPE;
3307: l_lock_text OKC_ARTICLE_VERSIONS.LOCK_TEXT%TYPE;
3308: l_global_yn OKC_ARTICLE_VERSIONS.GLOBAL_YN%TYPE;
3309: l_article_language OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;
3310: l_article_language_out OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;

Line 3307: l_lock_text OKC_ARTICLE_VERSIONS.LOCK_TEXT%TYPE;

3303: l_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
3304: l_article_text OKC_ARTICLE_VERSIONS.ARTICLE_TEXT%TYPE;
3305: l_provision_yn OKC_ARTICLE_VERSIONS.PROVISION_YN%TYPE;
3306: l_insert_by_reference OKC_ARTICLE_VERSIONS.INSERT_BY_REFERENCE%TYPE;
3307: l_lock_text OKC_ARTICLE_VERSIONS.LOCK_TEXT%TYPE;
3308: l_global_yn OKC_ARTICLE_VERSIONS.GLOBAL_YN%TYPE;
3309: l_article_language OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;
3310: l_article_language_out OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;
3311: l_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;

Line 3308: l_global_yn OKC_ARTICLE_VERSIONS.GLOBAL_YN%TYPE;

3304: l_article_text OKC_ARTICLE_VERSIONS.ARTICLE_TEXT%TYPE;
3305: l_provision_yn OKC_ARTICLE_VERSIONS.PROVISION_YN%TYPE;
3306: l_insert_by_reference OKC_ARTICLE_VERSIONS.INSERT_BY_REFERENCE%TYPE;
3307: l_lock_text OKC_ARTICLE_VERSIONS.LOCK_TEXT%TYPE;
3308: l_global_yn OKC_ARTICLE_VERSIONS.GLOBAL_YN%TYPE;
3309: l_article_language OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;
3310: l_article_language_out OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;
3311: l_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
3312: l_sav_release OKC_ARTICLE_VERSIONS.SAV_RELEASE%TYPE;

Line 3309: l_article_language OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;

3305: l_provision_yn OKC_ARTICLE_VERSIONS.PROVISION_YN%TYPE;
3306: l_insert_by_reference OKC_ARTICLE_VERSIONS.INSERT_BY_REFERENCE%TYPE;
3307: l_lock_text OKC_ARTICLE_VERSIONS.LOCK_TEXT%TYPE;
3308: l_global_yn OKC_ARTICLE_VERSIONS.GLOBAL_YN%TYPE;
3309: l_article_language OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;
3310: l_article_language_out OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;
3311: l_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
3312: l_sav_release OKC_ARTICLE_VERSIONS.SAV_RELEASE%TYPE;
3313: l_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE;

Line 3310: l_article_language_out OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;

3306: l_insert_by_reference OKC_ARTICLE_VERSIONS.INSERT_BY_REFERENCE%TYPE;
3307: l_lock_text OKC_ARTICLE_VERSIONS.LOCK_TEXT%TYPE;
3308: l_global_yn OKC_ARTICLE_VERSIONS.GLOBAL_YN%TYPE;
3309: l_article_language OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;
3310: l_article_language_out OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;
3311: l_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
3312: l_sav_release OKC_ARTICLE_VERSIONS.SAV_RELEASE%TYPE;
3313: l_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE;
3314: l_end_date OKC_ARTICLE_VERSIONS.END_DATE%TYPE;

Line 3311: l_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;

3307: l_lock_text OKC_ARTICLE_VERSIONS.LOCK_TEXT%TYPE;
3308: l_global_yn OKC_ARTICLE_VERSIONS.GLOBAL_YN%TYPE;
3309: l_article_language OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;
3310: l_article_language_out OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;
3311: l_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
3312: l_sav_release OKC_ARTICLE_VERSIONS.SAV_RELEASE%TYPE;
3313: l_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE;
3314: l_end_date OKC_ARTICLE_VERSIONS.END_DATE%TYPE;
3315: l_std_article_version_id OKC_ARTICLE_VERSIONS.STD_ARTICLE_VERSION_ID%TYPE;

Line 3312: l_sav_release OKC_ARTICLE_VERSIONS.SAV_RELEASE%TYPE;

3308: l_global_yn OKC_ARTICLE_VERSIONS.GLOBAL_YN%TYPE;
3309: l_article_language OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;
3310: l_article_language_out OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;
3311: l_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
3312: l_sav_release OKC_ARTICLE_VERSIONS.SAV_RELEASE%TYPE;
3313: l_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE;
3314: l_end_date OKC_ARTICLE_VERSIONS.END_DATE%TYPE;
3315: l_std_article_version_id OKC_ARTICLE_VERSIONS.STD_ARTICLE_VERSION_ID%TYPE;
3316: l_display_name OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE;

Line 3313: l_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE;

3309: l_article_language OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;
3310: l_article_language_out OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;
3311: l_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
3312: l_sav_release OKC_ARTICLE_VERSIONS.SAV_RELEASE%TYPE;
3313: l_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE;
3314: l_end_date OKC_ARTICLE_VERSIONS.END_DATE%TYPE;
3315: l_std_article_version_id OKC_ARTICLE_VERSIONS.STD_ARTICLE_VERSION_ID%TYPE;
3316: l_display_name OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE;
3317: l_translated_yn OKC_ARTICLE_VERSIONS.TRANSLATED_YN%TYPE;

Line 3314: l_end_date OKC_ARTICLE_VERSIONS.END_DATE%TYPE;

3310: l_article_language_out OKC_ARTICLE_VERSIONS.ARTICLE_LANGUAGE%TYPE;
3311: l_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
3312: l_sav_release OKC_ARTICLE_VERSIONS.SAV_RELEASE%TYPE;
3313: l_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE;
3314: l_end_date OKC_ARTICLE_VERSIONS.END_DATE%TYPE;
3315: l_std_article_version_id OKC_ARTICLE_VERSIONS.STD_ARTICLE_VERSION_ID%TYPE;
3316: l_display_name OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE;
3317: l_translated_yn OKC_ARTICLE_VERSIONS.TRANSLATED_YN%TYPE;
3318: l_article_description OKC_ARTICLE_VERSIONS.ARTICLE_DESCRIPTION%TYPE;

Line 3315: l_std_article_version_id OKC_ARTICLE_VERSIONS.STD_ARTICLE_VERSION_ID%TYPE;

3311: l_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
3312: l_sav_release OKC_ARTICLE_VERSIONS.SAV_RELEASE%TYPE;
3313: l_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE;
3314: l_end_date OKC_ARTICLE_VERSIONS.END_DATE%TYPE;
3315: l_std_article_version_id OKC_ARTICLE_VERSIONS.STD_ARTICLE_VERSION_ID%TYPE;
3316: l_display_name OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE;
3317: l_translated_yn OKC_ARTICLE_VERSIONS.TRANSLATED_YN%TYPE;
3318: l_article_description OKC_ARTICLE_VERSIONS.ARTICLE_DESCRIPTION%TYPE;
3319: l_date_approved OKC_ARTICLE_VERSIONS.DATE_APPROVED%TYPE;

Line 3316: l_display_name OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE;

3312: l_sav_release OKC_ARTICLE_VERSIONS.SAV_RELEASE%TYPE;
3313: l_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE;
3314: l_end_date OKC_ARTICLE_VERSIONS.END_DATE%TYPE;
3315: l_std_article_version_id OKC_ARTICLE_VERSIONS.STD_ARTICLE_VERSION_ID%TYPE;
3316: l_display_name OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE;
3317: l_translated_yn OKC_ARTICLE_VERSIONS.TRANSLATED_YN%TYPE;
3318: l_article_description OKC_ARTICLE_VERSIONS.ARTICLE_DESCRIPTION%TYPE;
3319: l_date_approved OKC_ARTICLE_VERSIONS.DATE_APPROVED%TYPE;
3320: l_default_section OKC_ARTICLE_VERSIONS.DEFAULT_SECTION%TYPE;

Line 3317: l_translated_yn OKC_ARTICLE_VERSIONS.TRANSLATED_YN%TYPE;

3313: l_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE;
3314: l_end_date OKC_ARTICLE_VERSIONS.END_DATE%TYPE;
3315: l_std_article_version_id OKC_ARTICLE_VERSIONS.STD_ARTICLE_VERSION_ID%TYPE;
3316: l_display_name OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE;
3317: l_translated_yn OKC_ARTICLE_VERSIONS.TRANSLATED_YN%TYPE;
3318: l_article_description OKC_ARTICLE_VERSIONS.ARTICLE_DESCRIPTION%TYPE;
3319: l_date_approved OKC_ARTICLE_VERSIONS.DATE_APPROVED%TYPE;
3320: l_default_section OKC_ARTICLE_VERSIONS.DEFAULT_SECTION%TYPE;
3321: l_reference_source OKC_ARTICLE_VERSIONS.REFERENCE_SOURCE%TYPE;

Line 3318: l_article_description OKC_ARTICLE_VERSIONS.ARTICLE_DESCRIPTION%TYPE;

3314: l_end_date OKC_ARTICLE_VERSIONS.END_DATE%TYPE;
3315: l_std_article_version_id OKC_ARTICLE_VERSIONS.STD_ARTICLE_VERSION_ID%TYPE;
3316: l_display_name OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE;
3317: l_translated_yn OKC_ARTICLE_VERSIONS.TRANSLATED_YN%TYPE;
3318: l_article_description OKC_ARTICLE_VERSIONS.ARTICLE_DESCRIPTION%TYPE;
3319: l_date_approved OKC_ARTICLE_VERSIONS.DATE_APPROVED%TYPE;
3320: l_default_section OKC_ARTICLE_VERSIONS.DEFAULT_SECTION%TYPE;
3321: l_reference_source OKC_ARTICLE_VERSIONS.REFERENCE_SOURCE%TYPE;
3322: l_reference_text OKC_ARTICLE_VERSIONS.REFERENCE_TEXT%TYPE;

Line 3319: l_date_approved OKC_ARTICLE_VERSIONS.DATE_APPROVED%TYPE;

3315: l_std_article_version_id OKC_ARTICLE_VERSIONS.STD_ARTICLE_VERSION_ID%TYPE;
3316: l_display_name OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE;
3317: l_translated_yn OKC_ARTICLE_VERSIONS.TRANSLATED_YN%TYPE;
3318: l_article_description OKC_ARTICLE_VERSIONS.ARTICLE_DESCRIPTION%TYPE;
3319: l_date_approved OKC_ARTICLE_VERSIONS.DATE_APPROVED%TYPE;
3320: l_default_section OKC_ARTICLE_VERSIONS.DEFAULT_SECTION%TYPE;
3321: l_reference_source OKC_ARTICLE_VERSIONS.REFERENCE_SOURCE%TYPE;
3322: l_reference_text OKC_ARTICLE_VERSIONS.REFERENCE_TEXT%TYPE;
3323: l_orig_system_reference_code OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_CODE%TYPE;

Line 3320: l_default_section OKC_ARTICLE_VERSIONS.DEFAULT_SECTION%TYPE;

3316: l_display_name OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE;
3317: l_translated_yn OKC_ARTICLE_VERSIONS.TRANSLATED_YN%TYPE;
3318: l_article_description OKC_ARTICLE_VERSIONS.ARTICLE_DESCRIPTION%TYPE;
3319: l_date_approved OKC_ARTICLE_VERSIONS.DATE_APPROVED%TYPE;
3320: l_default_section OKC_ARTICLE_VERSIONS.DEFAULT_SECTION%TYPE;
3321: l_reference_source OKC_ARTICLE_VERSIONS.REFERENCE_SOURCE%TYPE;
3322: l_reference_text OKC_ARTICLE_VERSIONS.REFERENCE_TEXT%TYPE;
3323: l_orig_system_reference_code OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
3324: l_orig_system_reference_id1 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID1%TYPE;

Line 3321: l_reference_source OKC_ARTICLE_VERSIONS.REFERENCE_SOURCE%TYPE;

3317: l_translated_yn OKC_ARTICLE_VERSIONS.TRANSLATED_YN%TYPE;
3318: l_article_description OKC_ARTICLE_VERSIONS.ARTICLE_DESCRIPTION%TYPE;
3319: l_date_approved OKC_ARTICLE_VERSIONS.DATE_APPROVED%TYPE;
3320: l_default_section OKC_ARTICLE_VERSIONS.DEFAULT_SECTION%TYPE;
3321: l_reference_source OKC_ARTICLE_VERSIONS.REFERENCE_SOURCE%TYPE;
3322: l_reference_text OKC_ARTICLE_VERSIONS.REFERENCE_TEXT%TYPE;
3323: l_orig_system_reference_code OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
3324: l_orig_system_reference_id1 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
3325: l_orig_system_reference_id2 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID2%TYPE;

Line 3322: l_reference_text OKC_ARTICLE_VERSIONS.REFERENCE_TEXT%TYPE;

3318: l_article_description OKC_ARTICLE_VERSIONS.ARTICLE_DESCRIPTION%TYPE;
3319: l_date_approved OKC_ARTICLE_VERSIONS.DATE_APPROVED%TYPE;
3320: l_default_section OKC_ARTICLE_VERSIONS.DEFAULT_SECTION%TYPE;
3321: l_reference_source OKC_ARTICLE_VERSIONS.REFERENCE_SOURCE%TYPE;
3322: l_reference_text OKC_ARTICLE_VERSIONS.REFERENCE_TEXT%TYPE;
3323: l_orig_system_reference_code OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
3324: l_orig_system_reference_id1 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
3325: l_orig_system_reference_id2 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
3326: l_additional_instructions OKC_ARTICLE_VERSIONS.ADDITIONAL_INSTRUCTIONS%TYPE;

Line 3323: l_orig_system_reference_code OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_CODE%TYPE;

3319: l_date_approved OKC_ARTICLE_VERSIONS.DATE_APPROVED%TYPE;
3320: l_default_section OKC_ARTICLE_VERSIONS.DEFAULT_SECTION%TYPE;
3321: l_reference_source OKC_ARTICLE_VERSIONS.REFERENCE_SOURCE%TYPE;
3322: l_reference_text OKC_ARTICLE_VERSIONS.REFERENCE_TEXT%TYPE;
3323: l_orig_system_reference_code OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
3324: l_orig_system_reference_id1 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
3325: l_orig_system_reference_id2 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
3326: l_additional_instructions OKC_ARTICLE_VERSIONS.ADDITIONAL_INSTRUCTIONS%TYPE;
3327: l_variation_description OKC_ARTICLE_VERSIONS.VARIATION_DESCRIPTION%TYPE;

Line 3324: l_orig_system_reference_id1 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID1%TYPE;

3320: l_default_section OKC_ARTICLE_VERSIONS.DEFAULT_SECTION%TYPE;
3321: l_reference_source OKC_ARTICLE_VERSIONS.REFERENCE_SOURCE%TYPE;
3322: l_reference_text OKC_ARTICLE_VERSIONS.REFERENCE_TEXT%TYPE;
3323: l_orig_system_reference_code OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
3324: l_orig_system_reference_id1 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
3325: l_orig_system_reference_id2 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
3326: l_additional_instructions OKC_ARTICLE_VERSIONS.ADDITIONAL_INSTRUCTIONS%TYPE;
3327: l_variation_description OKC_ARTICLE_VERSIONS.VARIATION_DESCRIPTION%TYPE;
3328: l_date_published OKC_ARTICLE_VERSIONS.DATE_PUBLISHED%TYPE;

Line 3325: l_orig_system_reference_id2 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID2%TYPE;

3321: l_reference_source OKC_ARTICLE_VERSIONS.REFERENCE_SOURCE%TYPE;
3322: l_reference_text OKC_ARTICLE_VERSIONS.REFERENCE_TEXT%TYPE;
3323: l_orig_system_reference_code OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
3324: l_orig_system_reference_id1 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
3325: l_orig_system_reference_id2 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
3326: l_additional_instructions OKC_ARTICLE_VERSIONS.ADDITIONAL_INSTRUCTIONS%TYPE;
3327: l_variation_description OKC_ARTICLE_VERSIONS.VARIATION_DESCRIPTION%TYPE;
3328: l_date_published OKC_ARTICLE_VERSIONS.DATE_PUBLISHED%TYPE;
3329: l_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE;

Line 3326: l_additional_instructions OKC_ARTICLE_VERSIONS.ADDITIONAL_INSTRUCTIONS%TYPE;

3322: l_reference_text OKC_ARTICLE_VERSIONS.REFERENCE_TEXT%TYPE;
3323: l_orig_system_reference_code OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
3324: l_orig_system_reference_id1 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
3325: l_orig_system_reference_id2 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
3326: l_additional_instructions OKC_ARTICLE_VERSIONS.ADDITIONAL_INSTRUCTIONS%TYPE;
3327: l_variation_description OKC_ARTICLE_VERSIONS.VARIATION_DESCRIPTION%TYPE;
3328: l_date_published OKC_ARTICLE_VERSIONS.DATE_PUBLISHED%TYPE;
3329: l_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE;
3330: l_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE;

Line 3327: l_variation_description OKC_ARTICLE_VERSIONS.VARIATION_DESCRIPTION%TYPE;

3323: l_orig_system_reference_code OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
3324: l_orig_system_reference_id1 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
3325: l_orig_system_reference_id2 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
3326: l_additional_instructions OKC_ARTICLE_VERSIONS.ADDITIONAL_INSTRUCTIONS%TYPE;
3327: l_variation_description OKC_ARTICLE_VERSIONS.VARIATION_DESCRIPTION%TYPE;
3328: l_date_published OKC_ARTICLE_VERSIONS.DATE_PUBLISHED%TYPE;
3329: l_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE;
3330: l_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE;
3331: l_program_application_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE;

Line 3328: l_date_published OKC_ARTICLE_VERSIONS.DATE_PUBLISHED%TYPE;

3324: l_orig_system_reference_id1 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
3325: l_orig_system_reference_id2 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
3326: l_additional_instructions OKC_ARTICLE_VERSIONS.ADDITIONAL_INSTRUCTIONS%TYPE;
3327: l_variation_description OKC_ARTICLE_VERSIONS.VARIATION_DESCRIPTION%TYPE;
3328: l_date_published OKC_ARTICLE_VERSIONS.DATE_PUBLISHED%TYPE;
3329: l_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE;
3330: l_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE;
3331: l_program_application_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE;
3332: l_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE;

Line 3329: l_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE;

3325: l_orig_system_reference_id2 OKC_ARTICLE_VERSIONS.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
3326: l_additional_instructions OKC_ARTICLE_VERSIONS.ADDITIONAL_INSTRUCTIONS%TYPE;
3327: l_variation_description OKC_ARTICLE_VERSIONS.VARIATION_DESCRIPTION%TYPE;
3328: l_date_published OKC_ARTICLE_VERSIONS.DATE_PUBLISHED%TYPE;
3329: l_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE;
3330: l_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE;
3331: l_program_application_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE;
3332: l_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE;
3333: l_attribute_category OKC_ARTICLE_VERSIONS.ATTRIBUTE_CATEGORY%TYPE;

Line 3330: l_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE;

3326: l_additional_instructions OKC_ARTICLE_VERSIONS.ADDITIONAL_INSTRUCTIONS%TYPE;
3327: l_variation_description OKC_ARTICLE_VERSIONS.VARIATION_DESCRIPTION%TYPE;
3328: l_date_published OKC_ARTICLE_VERSIONS.DATE_PUBLISHED%TYPE;
3329: l_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE;
3330: l_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE;
3331: l_program_application_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE;
3332: l_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE;
3333: l_attribute_category OKC_ARTICLE_VERSIONS.ATTRIBUTE_CATEGORY%TYPE;
3334: l_attribute1 OKC_ARTICLE_VERSIONS.ATTRIBUTE1%TYPE;

Line 3331: l_program_application_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE;

3327: l_variation_description OKC_ARTICLE_VERSIONS.VARIATION_DESCRIPTION%TYPE;
3328: l_date_published OKC_ARTICLE_VERSIONS.DATE_PUBLISHED%TYPE;
3329: l_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE;
3330: l_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE;
3331: l_program_application_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE;
3332: l_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE;
3333: l_attribute_category OKC_ARTICLE_VERSIONS.ATTRIBUTE_CATEGORY%TYPE;
3334: l_attribute1 OKC_ARTICLE_VERSIONS.ATTRIBUTE1%TYPE;
3335: l_attribute2 OKC_ARTICLE_VERSIONS.ATTRIBUTE2%TYPE;

Line 3332: l_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE;

3328: l_date_published OKC_ARTICLE_VERSIONS.DATE_PUBLISHED%TYPE;
3329: l_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE;
3330: l_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE;
3331: l_program_application_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE;
3332: l_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE;
3333: l_attribute_category OKC_ARTICLE_VERSIONS.ATTRIBUTE_CATEGORY%TYPE;
3334: l_attribute1 OKC_ARTICLE_VERSIONS.ATTRIBUTE1%TYPE;
3335: l_attribute2 OKC_ARTICLE_VERSIONS.ATTRIBUTE2%TYPE;
3336: l_attribute3 OKC_ARTICLE_VERSIONS.ATTRIBUTE3%TYPE;

Line 3333: l_attribute_category OKC_ARTICLE_VERSIONS.ATTRIBUTE_CATEGORY%TYPE;

3329: l_program_id OKC_ARTICLE_VERSIONS.PROGRAM_ID%TYPE;
3330: l_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE;
3331: l_program_application_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE;
3332: l_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE;
3333: l_attribute_category OKC_ARTICLE_VERSIONS.ATTRIBUTE_CATEGORY%TYPE;
3334: l_attribute1 OKC_ARTICLE_VERSIONS.ATTRIBUTE1%TYPE;
3335: l_attribute2 OKC_ARTICLE_VERSIONS.ATTRIBUTE2%TYPE;
3336: l_attribute3 OKC_ARTICLE_VERSIONS.ATTRIBUTE3%TYPE;
3337: l_attribute4 OKC_ARTICLE_VERSIONS.ATTRIBUTE4%TYPE;

Line 3334: l_attribute1 OKC_ARTICLE_VERSIONS.ATTRIBUTE1%TYPE;

3330: l_program_login_id OKC_ARTICLE_VERSIONS.PROGRAM_LOGIN_ID%TYPE;
3331: l_program_application_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE;
3332: l_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE;
3333: l_attribute_category OKC_ARTICLE_VERSIONS.ATTRIBUTE_CATEGORY%TYPE;
3334: l_attribute1 OKC_ARTICLE_VERSIONS.ATTRIBUTE1%TYPE;
3335: l_attribute2 OKC_ARTICLE_VERSIONS.ATTRIBUTE2%TYPE;
3336: l_attribute3 OKC_ARTICLE_VERSIONS.ATTRIBUTE3%TYPE;
3337: l_attribute4 OKC_ARTICLE_VERSIONS.ATTRIBUTE4%TYPE;
3338: l_attribute5 OKC_ARTICLE_VERSIONS.ATTRIBUTE5%TYPE;

Line 3335: l_attribute2 OKC_ARTICLE_VERSIONS.ATTRIBUTE2%TYPE;

3331: l_program_application_id OKC_ARTICLE_VERSIONS.PROGRAM_APPLICATION_ID%TYPE;
3332: l_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE;
3333: l_attribute_category OKC_ARTICLE_VERSIONS.ATTRIBUTE_CATEGORY%TYPE;
3334: l_attribute1 OKC_ARTICLE_VERSIONS.ATTRIBUTE1%TYPE;
3335: l_attribute2 OKC_ARTICLE_VERSIONS.ATTRIBUTE2%TYPE;
3336: l_attribute3 OKC_ARTICLE_VERSIONS.ATTRIBUTE3%TYPE;
3337: l_attribute4 OKC_ARTICLE_VERSIONS.ATTRIBUTE4%TYPE;
3338: l_attribute5 OKC_ARTICLE_VERSIONS.ATTRIBUTE5%TYPE;
3339: l_attribute6 OKC_ARTICLE_VERSIONS.ATTRIBUTE6%TYPE;

Line 3336: l_attribute3 OKC_ARTICLE_VERSIONS.ATTRIBUTE3%TYPE;

3332: l_request_id OKC_ARTICLE_VERSIONS.REQUEST_ID%TYPE;
3333: l_attribute_category OKC_ARTICLE_VERSIONS.ATTRIBUTE_CATEGORY%TYPE;
3334: l_attribute1 OKC_ARTICLE_VERSIONS.ATTRIBUTE1%TYPE;
3335: l_attribute2 OKC_ARTICLE_VERSIONS.ATTRIBUTE2%TYPE;
3336: l_attribute3 OKC_ARTICLE_VERSIONS.ATTRIBUTE3%TYPE;
3337: l_attribute4 OKC_ARTICLE_VERSIONS.ATTRIBUTE4%TYPE;
3338: l_attribute5 OKC_ARTICLE_VERSIONS.ATTRIBUTE5%TYPE;
3339: l_attribute6 OKC_ARTICLE_VERSIONS.ATTRIBUTE6%TYPE;
3340: l_attribute7 OKC_ARTICLE_VERSIONS.ATTRIBUTE7%TYPE;

Line 3337: l_attribute4 OKC_ARTICLE_VERSIONS.ATTRIBUTE4%TYPE;

3333: l_attribute_category OKC_ARTICLE_VERSIONS.ATTRIBUTE_CATEGORY%TYPE;
3334: l_attribute1 OKC_ARTICLE_VERSIONS.ATTRIBUTE1%TYPE;
3335: l_attribute2 OKC_ARTICLE_VERSIONS.ATTRIBUTE2%TYPE;
3336: l_attribute3 OKC_ARTICLE_VERSIONS.ATTRIBUTE3%TYPE;
3337: l_attribute4 OKC_ARTICLE_VERSIONS.ATTRIBUTE4%TYPE;
3338: l_attribute5 OKC_ARTICLE_VERSIONS.ATTRIBUTE5%TYPE;
3339: l_attribute6 OKC_ARTICLE_VERSIONS.ATTRIBUTE6%TYPE;
3340: l_attribute7 OKC_ARTICLE_VERSIONS.ATTRIBUTE7%TYPE;
3341: l_attribute8 OKC_ARTICLE_VERSIONS.ATTRIBUTE8%TYPE;

Line 3338: l_attribute5 OKC_ARTICLE_VERSIONS.ATTRIBUTE5%TYPE;

3334: l_attribute1 OKC_ARTICLE_VERSIONS.ATTRIBUTE1%TYPE;
3335: l_attribute2 OKC_ARTICLE_VERSIONS.ATTRIBUTE2%TYPE;
3336: l_attribute3 OKC_ARTICLE_VERSIONS.ATTRIBUTE3%TYPE;
3337: l_attribute4 OKC_ARTICLE_VERSIONS.ATTRIBUTE4%TYPE;
3338: l_attribute5 OKC_ARTICLE_VERSIONS.ATTRIBUTE5%TYPE;
3339: l_attribute6 OKC_ARTICLE_VERSIONS.ATTRIBUTE6%TYPE;
3340: l_attribute7 OKC_ARTICLE_VERSIONS.ATTRIBUTE7%TYPE;
3341: l_attribute8 OKC_ARTICLE_VERSIONS.ATTRIBUTE8%TYPE;
3342: l_attribute9 OKC_ARTICLE_VERSIONS.ATTRIBUTE9%TYPE;

Line 3339: l_attribute6 OKC_ARTICLE_VERSIONS.ATTRIBUTE6%TYPE;

3335: l_attribute2 OKC_ARTICLE_VERSIONS.ATTRIBUTE2%TYPE;
3336: l_attribute3 OKC_ARTICLE_VERSIONS.ATTRIBUTE3%TYPE;
3337: l_attribute4 OKC_ARTICLE_VERSIONS.ATTRIBUTE4%TYPE;
3338: l_attribute5 OKC_ARTICLE_VERSIONS.ATTRIBUTE5%TYPE;
3339: l_attribute6 OKC_ARTICLE_VERSIONS.ATTRIBUTE6%TYPE;
3340: l_attribute7 OKC_ARTICLE_VERSIONS.ATTRIBUTE7%TYPE;
3341: l_attribute8 OKC_ARTICLE_VERSIONS.ATTRIBUTE8%TYPE;
3342: l_attribute9 OKC_ARTICLE_VERSIONS.ATTRIBUTE9%TYPE;
3343: l_attribute10 OKC_ARTICLE_VERSIONS.ATTRIBUTE10%TYPE;

Line 3340: l_attribute7 OKC_ARTICLE_VERSIONS.ATTRIBUTE7%TYPE;

3336: l_attribute3 OKC_ARTICLE_VERSIONS.ATTRIBUTE3%TYPE;
3337: l_attribute4 OKC_ARTICLE_VERSIONS.ATTRIBUTE4%TYPE;
3338: l_attribute5 OKC_ARTICLE_VERSIONS.ATTRIBUTE5%TYPE;
3339: l_attribute6 OKC_ARTICLE_VERSIONS.ATTRIBUTE6%TYPE;
3340: l_attribute7 OKC_ARTICLE_VERSIONS.ATTRIBUTE7%TYPE;
3341: l_attribute8 OKC_ARTICLE_VERSIONS.ATTRIBUTE8%TYPE;
3342: l_attribute9 OKC_ARTICLE_VERSIONS.ATTRIBUTE9%TYPE;
3343: l_attribute10 OKC_ARTICLE_VERSIONS.ATTRIBUTE10%TYPE;
3344: l_attribute11 OKC_ARTICLE_VERSIONS.ATTRIBUTE11%TYPE;

Line 3341: l_attribute8 OKC_ARTICLE_VERSIONS.ATTRIBUTE8%TYPE;

3337: l_attribute4 OKC_ARTICLE_VERSIONS.ATTRIBUTE4%TYPE;
3338: l_attribute5 OKC_ARTICLE_VERSIONS.ATTRIBUTE5%TYPE;
3339: l_attribute6 OKC_ARTICLE_VERSIONS.ATTRIBUTE6%TYPE;
3340: l_attribute7 OKC_ARTICLE_VERSIONS.ATTRIBUTE7%TYPE;
3341: l_attribute8 OKC_ARTICLE_VERSIONS.ATTRIBUTE8%TYPE;
3342: l_attribute9 OKC_ARTICLE_VERSIONS.ATTRIBUTE9%TYPE;
3343: l_attribute10 OKC_ARTICLE_VERSIONS.ATTRIBUTE10%TYPE;
3344: l_attribute11 OKC_ARTICLE_VERSIONS.ATTRIBUTE11%TYPE;
3345: l_attribute12 OKC_ARTICLE_VERSIONS.ATTRIBUTE12%TYPE;

Line 3342: l_attribute9 OKC_ARTICLE_VERSIONS.ATTRIBUTE9%TYPE;

3338: l_attribute5 OKC_ARTICLE_VERSIONS.ATTRIBUTE5%TYPE;
3339: l_attribute6 OKC_ARTICLE_VERSIONS.ATTRIBUTE6%TYPE;
3340: l_attribute7 OKC_ARTICLE_VERSIONS.ATTRIBUTE7%TYPE;
3341: l_attribute8 OKC_ARTICLE_VERSIONS.ATTRIBUTE8%TYPE;
3342: l_attribute9 OKC_ARTICLE_VERSIONS.ATTRIBUTE9%TYPE;
3343: l_attribute10 OKC_ARTICLE_VERSIONS.ATTRIBUTE10%TYPE;
3344: l_attribute11 OKC_ARTICLE_VERSIONS.ATTRIBUTE11%TYPE;
3345: l_attribute12 OKC_ARTICLE_VERSIONS.ATTRIBUTE12%TYPE;
3346: l_attribute13 OKC_ARTICLE_VERSIONS.ATTRIBUTE13%TYPE;

Line 3343: l_attribute10 OKC_ARTICLE_VERSIONS.ATTRIBUTE10%TYPE;

3339: l_attribute6 OKC_ARTICLE_VERSIONS.ATTRIBUTE6%TYPE;
3340: l_attribute7 OKC_ARTICLE_VERSIONS.ATTRIBUTE7%TYPE;
3341: l_attribute8 OKC_ARTICLE_VERSIONS.ATTRIBUTE8%TYPE;
3342: l_attribute9 OKC_ARTICLE_VERSIONS.ATTRIBUTE9%TYPE;
3343: l_attribute10 OKC_ARTICLE_VERSIONS.ATTRIBUTE10%TYPE;
3344: l_attribute11 OKC_ARTICLE_VERSIONS.ATTRIBUTE11%TYPE;
3345: l_attribute12 OKC_ARTICLE_VERSIONS.ATTRIBUTE12%TYPE;
3346: l_attribute13 OKC_ARTICLE_VERSIONS.ATTRIBUTE13%TYPE;
3347: l_attribute14 OKC_ARTICLE_VERSIONS.ATTRIBUTE14%TYPE;

Line 3344: l_attribute11 OKC_ARTICLE_VERSIONS.ATTRIBUTE11%TYPE;

3340: l_attribute7 OKC_ARTICLE_VERSIONS.ATTRIBUTE7%TYPE;
3341: l_attribute8 OKC_ARTICLE_VERSIONS.ATTRIBUTE8%TYPE;
3342: l_attribute9 OKC_ARTICLE_VERSIONS.ATTRIBUTE9%TYPE;
3343: l_attribute10 OKC_ARTICLE_VERSIONS.ATTRIBUTE10%TYPE;
3344: l_attribute11 OKC_ARTICLE_VERSIONS.ATTRIBUTE11%TYPE;
3345: l_attribute12 OKC_ARTICLE_VERSIONS.ATTRIBUTE12%TYPE;
3346: l_attribute13 OKC_ARTICLE_VERSIONS.ATTRIBUTE13%TYPE;
3347: l_attribute14 OKC_ARTICLE_VERSIONS.ATTRIBUTE14%TYPE;
3348: l_attribute15 OKC_ARTICLE_VERSIONS.ATTRIBUTE15%TYPE;

Line 3345: l_attribute12 OKC_ARTICLE_VERSIONS.ATTRIBUTE12%TYPE;

3341: l_attribute8 OKC_ARTICLE_VERSIONS.ATTRIBUTE8%TYPE;
3342: l_attribute9 OKC_ARTICLE_VERSIONS.ATTRIBUTE9%TYPE;
3343: l_attribute10 OKC_ARTICLE_VERSIONS.ATTRIBUTE10%TYPE;
3344: l_attribute11 OKC_ARTICLE_VERSIONS.ATTRIBUTE11%TYPE;
3345: l_attribute12 OKC_ARTICLE_VERSIONS.ATTRIBUTE12%TYPE;
3346: l_attribute13 OKC_ARTICLE_VERSIONS.ATTRIBUTE13%TYPE;
3347: l_attribute14 OKC_ARTICLE_VERSIONS.ATTRIBUTE14%TYPE;
3348: l_attribute15 OKC_ARTICLE_VERSIONS.ATTRIBUTE15%TYPE;
3349: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;

Line 3346: l_attribute13 OKC_ARTICLE_VERSIONS.ATTRIBUTE13%TYPE;

3342: l_attribute9 OKC_ARTICLE_VERSIONS.ATTRIBUTE9%TYPE;
3343: l_attribute10 OKC_ARTICLE_VERSIONS.ATTRIBUTE10%TYPE;
3344: l_attribute11 OKC_ARTICLE_VERSIONS.ATTRIBUTE11%TYPE;
3345: l_attribute12 OKC_ARTICLE_VERSIONS.ATTRIBUTE12%TYPE;
3346: l_attribute13 OKC_ARTICLE_VERSIONS.ATTRIBUTE13%TYPE;
3347: l_attribute14 OKC_ARTICLE_VERSIONS.ATTRIBUTE14%TYPE;
3348: l_attribute15 OKC_ARTICLE_VERSIONS.ATTRIBUTE15%TYPE;
3349: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;
3350: l_edited_in_word OKC_ARTICLE_VERSIONS.EDITED_IN_WORD%TYPE;

Line 3347: l_attribute14 OKC_ARTICLE_VERSIONS.ATTRIBUTE14%TYPE;

3343: l_attribute10 OKC_ARTICLE_VERSIONS.ATTRIBUTE10%TYPE;
3344: l_attribute11 OKC_ARTICLE_VERSIONS.ATTRIBUTE11%TYPE;
3345: l_attribute12 OKC_ARTICLE_VERSIONS.ATTRIBUTE12%TYPE;
3346: l_attribute13 OKC_ARTICLE_VERSIONS.ATTRIBUTE13%TYPE;
3347: l_attribute14 OKC_ARTICLE_VERSIONS.ATTRIBUTE14%TYPE;
3348: l_attribute15 OKC_ARTICLE_VERSIONS.ATTRIBUTE15%TYPE;
3349: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;
3350: l_edited_in_word OKC_ARTICLE_VERSIONS.EDITED_IN_WORD%TYPE;
3351: l_article_text_in_word OKC_ARTICLE_VERSIONS.ARTICLE_TEXT_IN_WORD%TYPE;

Line 3348: l_attribute15 OKC_ARTICLE_VERSIONS.ATTRIBUTE15%TYPE;

3344: l_attribute11 OKC_ARTICLE_VERSIONS.ATTRIBUTE11%TYPE;
3345: l_attribute12 OKC_ARTICLE_VERSIONS.ATTRIBUTE12%TYPE;
3346: l_attribute13 OKC_ARTICLE_VERSIONS.ATTRIBUTE13%TYPE;
3347: l_attribute14 OKC_ARTICLE_VERSIONS.ATTRIBUTE14%TYPE;
3348: l_attribute15 OKC_ARTICLE_VERSIONS.ATTRIBUTE15%TYPE;
3349: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;
3350: l_edited_in_word OKC_ARTICLE_VERSIONS.EDITED_IN_WORD%TYPE;
3351: l_article_text_in_word OKC_ARTICLE_VERSIONS.ARTICLE_TEXT_IN_WORD%TYPE;
3352: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;

Line 3349: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;

3345: l_attribute12 OKC_ARTICLE_VERSIONS.ATTRIBUTE12%TYPE;
3346: l_attribute13 OKC_ARTICLE_VERSIONS.ATTRIBUTE13%TYPE;
3347: l_attribute14 OKC_ARTICLE_VERSIONS.ATTRIBUTE14%TYPE;
3348: l_attribute15 OKC_ARTICLE_VERSIONS.ATTRIBUTE15%TYPE;
3349: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;
3350: l_edited_in_word OKC_ARTICLE_VERSIONS.EDITED_IN_WORD%TYPE;
3351: l_article_text_in_word OKC_ARTICLE_VERSIONS.ARTICLE_TEXT_IN_WORD%TYPE;
3352: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
3353: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;

Line 3350: l_edited_in_word OKC_ARTICLE_VERSIONS.EDITED_IN_WORD%TYPE;

3346: l_attribute13 OKC_ARTICLE_VERSIONS.ATTRIBUTE13%TYPE;
3347: l_attribute14 OKC_ARTICLE_VERSIONS.ATTRIBUTE14%TYPE;
3348: l_attribute15 OKC_ARTICLE_VERSIONS.ATTRIBUTE15%TYPE;
3349: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;
3350: l_edited_in_word OKC_ARTICLE_VERSIONS.EDITED_IN_WORD%TYPE;
3351: l_article_text_in_word OKC_ARTICLE_VERSIONS.ARTICLE_TEXT_IN_WORD%TYPE;
3352: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
3353: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
3354: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;

Line 3351: l_article_text_in_word OKC_ARTICLE_VERSIONS.ARTICLE_TEXT_IN_WORD%TYPE;

3347: l_attribute14 OKC_ARTICLE_VERSIONS.ATTRIBUTE14%TYPE;
3348: l_attribute15 OKC_ARTICLE_VERSIONS.ATTRIBUTE15%TYPE;
3349: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;
3350: l_edited_in_word OKC_ARTICLE_VERSIONS.EDITED_IN_WORD%TYPE;
3351: l_article_text_in_word OKC_ARTICLE_VERSIONS.ARTICLE_TEXT_IN_WORD%TYPE;
3352: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
3353: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
3354: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
3355: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;

Line 3352: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;

3348: l_attribute15 OKC_ARTICLE_VERSIONS.ATTRIBUTE15%TYPE;
3349: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;
3350: l_edited_in_word OKC_ARTICLE_VERSIONS.EDITED_IN_WORD%TYPE;
3351: l_article_text_in_word OKC_ARTICLE_VERSIONS.ARTICLE_TEXT_IN_WORD%TYPE;
3352: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
3353: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
3354: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
3355: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
3356: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;

Line 3353: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;

3349: l_object_version_number OKC_ARTICLE_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;
3350: l_edited_in_word OKC_ARTICLE_VERSIONS.EDITED_IN_WORD%TYPE;
3351: l_article_text_in_word OKC_ARTICLE_VERSIONS.ARTICLE_TEXT_IN_WORD%TYPE;
3352: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
3353: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
3354: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
3355: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
3356: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;
3357: l_earlier_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;

Line 3354: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;

3350: l_edited_in_word OKC_ARTICLE_VERSIONS.EDITED_IN_WORD%TYPE;
3351: l_article_text_in_word OKC_ARTICLE_VERSIONS.ARTICLE_TEXT_IN_WORD%TYPE;
3352: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
3353: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
3354: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
3355: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
3356: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;
3357: l_earlier_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
3358: l_earlier_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;

Line 3355: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;

3351: l_article_text_in_word OKC_ARTICLE_VERSIONS.ARTICLE_TEXT_IN_WORD%TYPE;
3352: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
3353: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
3354: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
3355: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
3356: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;
3357: l_earlier_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
3358: l_earlier_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
3359: l_variable_code OKC_ARTICLE_VERSIONS.VARIABLE_CODE%TYPE; ---clm

Line 3356: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;

3352: l_created_by OKC_ARTICLE_VERSIONS.CREATED_BY%TYPE;
3353: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
3354: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
3355: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
3356: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;
3357: l_earlier_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
3358: l_earlier_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
3359: l_variable_code OKC_ARTICLE_VERSIONS.VARIABLE_CODE%TYPE; ---clm
3360:

Line 3357: l_earlier_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;

3353: l_creation_date OKC_ARTICLE_VERSIONS.CREATION_DATE%TYPE;
3354: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
3355: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
3356: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;
3357: l_earlier_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
3358: l_earlier_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
3359: l_variable_code OKC_ARTICLE_VERSIONS.VARIABLE_CODE%TYPE; ---clm
3360:
3361: BEGIN

Line 3358: l_earlier_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;

3354: l_last_updated_by OKC_ARTICLE_VERSIONS.LAST_UPDATED_BY%TYPE;
3355: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
3356: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;
3357: l_earlier_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
3358: l_earlier_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
3359: l_variable_code OKC_ARTICLE_VERSIONS.VARIABLE_CODE%TYPE; ---clm
3360:
3361: BEGIN
3362:

Line 3359: l_variable_code OKC_ARTICLE_VERSIONS.VARIABLE_CODE%TYPE; ---clm

3355: l_last_update_login OKC_ARTICLE_VERSIONS.LAST_UPDATE_LOGIN%TYPE;
3356: l_last_update_date OKC_ARTICLE_VERSIONS.LAST_UPDATE_DATE%TYPE;
3357: l_earlier_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
3358: l_earlier_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
3359: l_variable_code OKC_ARTICLE_VERSIONS.VARIABLE_CODE%TYPE; ---clm
3360:
3361: BEGIN
3362:
3363: IF (l_debug = 'Y') THEN

Line 3706: -- Delete_Row for:OKC_ARTICLE_VERSIONS --

3702: ---------------------------------------------------------------------------
3703: -- PROCEDURE Delete_Row
3704: ---------------------------------------------------------------------------
3705: -------------------------------------
3706: -- Delete_Row for:OKC_ARTICLE_VERSIONS --
3707: -------------------------------------
3708: FUNCTION Delete_Row(
3709: p_article_version_id IN NUMBER
3710: ) RETURN VARCHAR2 IS

Line 3718: DELETE FROM OKC_ARTICLE_VERSIONS WHERE ARTICLE_VERSION_ID = P_ARTICLE_VERSION_ID;

3714: IF (l_debug = 'Y') THEN
3715: Okc_Debug.Log('8200: Entered Delete_Row', 2);
3716: END IF;
3717:
3718: DELETE FROM OKC_ARTICLE_VERSIONS WHERE ARTICLE_VERSION_ID = P_ARTICLE_VERSION_ID;
3719:
3720: IF (l_debug = 'Y') THEN
3721: Okc_Debug.Log('8300: Leaving Delete_Row', 2);
3722: END IF;

Line 3745: -- Delete_Row for:OKC_ARTICLE_VERSIONS --

3741:
3742: END Delete_Row;
3743:
3744: -------------------------------------
3745: -- Delete_Row for:OKC_ARTICLE_VERSIONS --
3746: -------------------------------------
3747: PROCEDURE Delete_Row(
3748: x_return_status OUT NOCOPY VARCHAR2,
3749: p_article_version_id IN NUMBER,

Line 3851: END OKC_ARTICLE_VERSIONS_PVT;

3847: RETURN b1;
3848: END ArticleBlob;
3849:
3850:
3851: END OKC_ARTICLE_VERSIONS_PVT;