[Home] [Help]
60: p_id IN NUMBER,
61: x_id OUT NOCOPY NUMBER
62: ) RETURN VARCHAR2 IS
63: CURSOR c_seq IS
64: SELECT OKC_K_ARTICLES_B_S.NEXTVAL FROM DUAL;
65: BEGIN
66: IF (l_debug = 'Y') THEN
67: Okc_Debug.Log('100: Entered get_seq_id', 2);
68: END IF;
102:
103: END Get_Seq_Id;
104:
105: ---------------------------------------------------------------------------
106: -- FUNCTION get_rec for: OKC_K_ARTICLES_B
107: ---------------------------------------------------------------------------
108: FUNCTION Get_Rec (
109: p_id IN NUMBER,
110: p_major_version IN NUMBER := NULL,
153: x_last_amended_by OUT NOCOPY NUMBER,
154: x_last_amendment_date OUT NOCOPY DATE,
155: x_mandatory_rwa OUT NOCOPY VARCHAR2
156: ) RETURN VARCHAR2 IS
157: CURSOR OKC_K_ARTICLES_B_pk_csr (cp_id IN NUMBER) IS
158: SELECT
159: SAV_SAE_ID,
160: DOCUMENT_TYPE,
161: DOCUMENT_ID,
200: LAST_UPDATE_DATE,
201: LAST_AMENDED_BY,
202: LAST_AMENDMENT_DATE,
203: MANDATORY_RWA
204: FROM OKC_K_ARTICLES_B t
205: WHERE t.ID = cp_id;
206: CURSOR OKC_K_ARTICLES_BH_pk_csr (cp_id IN NUMBER, cp_major_version VARCHAR2) IS
207: SELECT
208: SAV_SAE_ID,
202: LAST_AMENDMENT_DATE,
203: MANDATORY_RWA
204: FROM OKC_K_ARTICLES_B t
205: WHERE t.ID = cp_id;
206: CURSOR OKC_K_ARTICLES_BH_pk_csr (cp_id IN NUMBER, cp_major_version VARCHAR2) IS
207: SELECT
208: SAV_SAE_ID,
209: DOCUMENT_TYPE,
210: DOCUMENT_ID,
249: LAST_UPDATE_DATE,
250: LAST_AMENDED_BY,
251: LAST_AMENDMENT_DATE,
252: MANDATORY_RWA
253: FROM OKC_K_ARTICLES_BH t
254: WHERE t.ID = cp_id and major_version=cp_major_version;
255: BEGIN
256:
257: IF (l_debug = 'Y') THEN
263: Okc_Debug.Log('401: Get current database values', 2);
264: END IF;
265:
266: -- Get current database values
267: OPEN OKC_K_ARTICLES_B_pk_csr (p_id);
268: FETCH OKC_K_ARTICLES_B_pk_csr INTO
269: x_sav_sae_id,
270: x_document_type,
271: x_document_id,
264: END IF;
265:
266: -- Get current database values
267: OPEN OKC_K_ARTICLES_B_pk_csr (p_id);
268: FETCH OKC_K_ARTICLES_B_pk_csr INTO
269: x_sav_sae_id,
270: x_document_type,
271: x_document_id,
272: x_cle_id,
310: x_last_update_date,
311: x_last_amended_by,
312: x_last_amendment_date,
313: x_mandatory_rwa;
314: IF OKC_K_ARTICLES_B_pk_csr%NOTFOUND THEN
315: Okc_Api.Set_Message(G_APP_NAME,G_LOCK_RECORD_DELETED,
316: 'ENTITYNAME','OKC_K_ARTICLES_B',
317: 'PKEY',p_id,
318: 'OVN',p_major_version
312: x_last_amendment_date,
313: x_mandatory_rwa;
314: IF OKC_K_ARTICLES_B_pk_csr%NOTFOUND THEN
315: Okc_Api.Set_Message(G_APP_NAME,G_LOCK_RECORD_DELETED,
316: 'ENTITYNAME','OKC_K_ARTICLES_B',
317: 'PKEY',p_id,
318: 'OVN',p_major_version
319: );
320: RAISE NO_DATA_FOUND;
318: 'OVN',p_major_version
319: );
320: RAISE NO_DATA_FOUND;
321: END IF;
322: CLOSE OKC_K_ARTICLES_B_pk_csr;
323: ELSE
324: IF (l_debug = 'Y') THEN
325: Okc_Debug.Log('402: Get history database values', 2);
326: END IF;
325: Okc_Debug.Log('402: Get history database values', 2);
326: END IF;
327:
328: -- Get history database values
329: OPEN OKC_K_ARTICLES_BH_pk_csr (p_id, p_major_version);
330: FETCH OKC_K_ARTICLES_BH_pk_csr INTO
331: x_sav_sae_id,
332: x_document_type,
333: x_document_id,
326: END IF;
327:
328: -- Get history database values
329: OPEN OKC_K_ARTICLES_BH_pk_csr (p_id, p_major_version);
330: FETCH OKC_K_ARTICLES_BH_pk_csr INTO
331: x_sav_sae_id,
332: x_document_type,
333: x_document_id,
334: x_cle_id,
373: x_last_amended_by,
374: x_last_amendment_date,
375: x_mandatory_rwa;
376:
377: IF OKC_K_ARTICLES_BH_pk_csr%NOTFOUND THEN
378: Okc_Api.Set_Message(G_APP_NAME,G_LOCK_RECORD_DELETED,
379: 'ENTITYNAME','OKC_K_ARTICLES_BH',
380: 'PKEY',p_id,
381: 'OVN',p_major_version
375: x_mandatory_rwa;
376:
377: IF OKC_K_ARTICLES_BH_pk_csr%NOTFOUND THEN
378: Okc_Api.Set_Message(G_APP_NAME,G_LOCK_RECORD_DELETED,
379: 'ENTITYNAME','OKC_K_ARTICLES_BH',
380: 'PKEY',p_id,
381: 'OVN',p_major_version
382: );
383: RAISE NO_DATA_FOUND;
381: 'OVN',p_major_version
382: );
383: RAISE NO_DATA_FOUND;
384: END IF;
385: CLOSE OKC_K_ARTICLES_BH_pk_csr;
386: END IF;
387:
388: IF (l_debug = 'Y') THEN
389: Okc_Debug.Log('500: Leaving get_rec ', 2);
398: END IF;
399:
400: -- moved upper where an exception is raised
401: -- Okc_Api.Set_Message(G_APP_NAME,G_LOCK_RECORD_DELETED,
402: -- 'ENTITYNAME','OKC_K_ARTICLES_BH',
403: -- 'PKEY',p_id,
404: -- 'OVN',p_major_version
405: -- );
406:
403: -- 'PKEY',p_id,
404: -- 'OVN',p_major_version
405: -- );
406:
407: IF OKC_K_ARTICLES_B_pk_csr%ISOPEN THEN
408: CLOSE OKC_K_ARTICLES_B_pk_csr;
409: END IF;
410:
411: IF OKC_K_ARTICLES_BH_pk_csr%ISOPEN THEN
404: -- 'OVN',p_major_version
405: -- );
406:
407: IF OKC_K_ARTICLES_B_pk_csr%ISOPEN THEN
408: CLOSE OKC_K_ARTICLES_B_pk_csr;
409: END IF;
410:
411: IF OKC_K_ARTICLES_BH_pk_csr%ISOPEN THEN
412: CLOSE OKC_K_ARTICLES_BH_pk_csr;
407: IF OKC_K_ARTICLES_B_pk_csr%ISOPEN THEN
408: CLOSE OKC_K_ARTICLES_B_pk_csr;
409: END IF;
410:
411: IF OKC_K_ARTICLES_BH_pk_csr%ISOPEN THEN
412: CLOSE OKC_K_ARTICLES_BH_pk_csr;
413: END IF;
414:
415: RETURN G_RET_STS_ERROR ;
408: CLOSE OKC_K_ARTICLES_B_pk_csr;
409: END IF;
410:
411: IF OKC_K_ARTICLES_BH_pk_csr%ISOPEN THEN
412: CLOSE OKC_K_ARTICLES_BH_pk_csr;
413: END IF;
414:
415: RETURN G_RET_STS_ERROR ;
416:
426: p_token1_value => sqlcode,
427: p_token2 => G_SQLERRM_TOKEN,
428: p_token2_value => sqlerrm);
429:
430: IF OKC_K_ARTICLES_B_pk_csr%ISOPEN THEN
431: CLOSE OKC_K_ARTICLES_B_pk_csr;
432: END IF;
433:
434: RETURN G_RET_STS_UNEXP_ERROR ;
427: p_token2 => G_SQLERRM_TOKEN,
428: p_token2_value => sqlerrm);
429:
430: IF OKC_K_ARTICLES_B_pk_csr%ISOPEN THEN
431: CLOSE OKC_K_ARTICLES_B_pk_csr;
432: END IF;
433:
434: RETURN G_RET_STS_UNEXP_ERROR ;
435:
435:
436: END Get_Rec;
437:
438: -----------------------------------------
439: -- Set_Attributes for:OKC_K_ARTICLES_B --
440: -----------------------------------------
441: FUNCTION Set_Attributes(
442: p_id IN NUMBER,
443: p_sav_sae_id IN NUMBER,
522: x_mandatory_rwa OUT NOCOPY VARCHAR2,
523: p_mandatory_rwa IN VARCHAR2
524: ) RETURN VARCHAR2 IS
525: l_return_status VARCHAR2(1);
526: l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;
527: l_created_by OKC_K_ARTICLES_B.CREATED_BY%TYPE;
528: l_creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE;
529: l_last_updated_by OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;
530: l_last_update_login OKC_K_ARTICLES_B.LAST_UPDATE_LOGIN%TYPE;
523: p_mandatory_rwa IN VARCHAR2
524: ) RETURN VARCHAR2 IS
525: l_return_status VARCHAR2(1);
526: l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;
527: l_created_by OKC_K_ARTICLES_B.CREATED_BY%TYPE;
528: l_creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE;
529: l_last_updated_by OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;
530: l_last_update_login OKC_K_ARTICLES_B.LAST_UPDATE_LOGIN%TYPE;
531: l_last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE;
524: ) RETURN VARCHAR2 IS
525: l_return_status VARCHAR2(1);
526: l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;
527: l_created_by OKC_K_ARTICLES_B.CREATED_BY%TYPE;
528: l_creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE;
529: l_last_updated_by OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;
530: l_last_update_login OKC_K_ARTICLES_B.LAST_UPDATE_LOGIN%TYPE;
531: l_last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE;
532: BEGIN
525: l_return_status VARCHAR2(1);
526: l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;
527: l_created_by OKC_K_ARTICLES_B.CREATED_BY%TYPE;
528: l_creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE;
529: l_last_updated_by OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;
530: l_last_update_login OKC_K_ARTICLES_B.LAST_UPDATE_LOGIN%TYPE;
531: l_last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE;
532: BEGIN
533: IF( p_id IS NOT NULL ) THEN
526: l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;
527: l_created_by OKC_K_ARTICLES_B.CREATED_BY%TYPE;
528: l_creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE;
529: l_last_updated_by OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;
530: l_last_update_login OKC_K_ARTICLES_B.LAST_UPDATE_LOGIN%TYPE;
531: l_last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE;
532: BEGIN
533: IF( p_id IS NOT NULL ) THEN
534: -- Get current database values
527: l_created_by OKC_K_ARTICLES_B.CREATED_BY%TYPE;
528: l_creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE;
529: l_last_updated_by OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;
530: l_last_update_login OKC_K_ARTICLES_B.LAST_UPDATE_LOGIN%TYPE;
531: l_last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE;
532: BEGIN
533: IF( p_id IS NOT NULL ) THEN
534: -- Get current database values
535: l_return_status := Get_Rec(
832: END IF;
833: RETURN G_RET_STS_SUCCESS ;
834: END;
835: -----------------------------------------
836: -- End of Set_Attributes for:OKC_K_ARTICLES_B --
837: -----------------------------------------
838:
839: ----------------------------------------------
840: -- Validate_Attributes for: OKC_K_ARTICLES_B --
836: -- End of Set_Attributes for:OKC_K_ARTICLES_B --
837: -----------------------------------------
838:
839: ----------------------------------------------
840: -- Validate_Attributes for: OKC_K_ARTICLES_B --
841: ----------------------------------------------
842: FUNCTION Validate_Attributes (
843: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
844:
1200: -- PROCEDURE Validate_Record
1201: -- It calls Item Level Validations and then makes Record Level Validations
1202: ---------------------------------------------------------------------------
1203: ------------------------------------------
1204: -- Validate_Record for:OKC_K_ARTICLES_B --
1205: ------------------------------------------
1206: FUNCTION Validate_Record (
1207: p_validation_level IN NUMBER,
1208: p_id IN NUMBER,
1363: ---------------------------------------------------------------------------
1364: -- PROCEDURE validate_row
1365: ---------------------------------------------------------------------------
1366: ---------------------------------------
1367: -- validate_row for:OKC_K_ARTICLES_B --
1368: ---------------------------------------
1369: PROCEDURE validate_row(
1370: p_validation_level IN NUMBER,
1371: x_return_status OUT NOCOPY VARCHAR2,
1408: p_ref_article_version_id IN NUMBER,
1409: p_object_version_number IN NUMBER,
1410: p_mandatory_rwa IN VARCHAR2
1411: ) IS
1412: l_sav_sae_id OKC_K_ARTICLES_B.SAV_SAE_ID%TYPE;
1413: l_document_type OKC_K_ARTICLES_B.DOCUMENT_TYPE%TYPE;
1414: l_document_id OKC_K_ARTICLES_B.DOCUMENT_ID%TYPE;
1415: l_cle_id OKC_K_ARTICLES_B.CLE_ID%TYPE;
1416: l_source_flag OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE;
1409: p_object_version_number IN NUMBER,
1410: p_mandatory_rwa IN VARCHAR2
1411: ) IS
1412: l_sav_sae_id OKC_K_ARTICLES_B.SAV_SAE_ID%TYPE;
1413: l_document_type OKC_K_ARTICLES_B.DOCUMENT_TYPE%TYPE;
1414: l_document_id OKC_K_ARTICLES_B.DOCUMENT_ID%TYPE;
1415: l_cle_id OKC_K_ARTICLES_B.CLE_ID%TYPE;
1416: l_source_flag OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE;
1417: l_mandatory_yn OKC_K_ARTICLES_B.MANDATORY_YN%TYPE;
1410: p_mandatory_rwa IN VARCHAR2
1411: ) IS
1412: l_sav_sae_id OKC_K_ARTICLES_B.SAV_SAE_ID%TYPE;
1413: l_document_type OKC_K_ARTICLES_B.DOCUMENT_TYPE%TYPE;
1414: l_document_id OKC_K_ARTICLES_B.DOCUMENT_ID%TYPE;
1415: l_cle_id OKC_K_ARTICLES_B.CLE_ID%TYPE;
1416: l_source_flag OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE;
1417: l_mandatory_yn OKC_K_ARTICLES_B.MANDATORY_YN%TYPE;
1418: l_mandatory_rwa OKC_K_ARTICLES_B.MANDATORY_RWA%TYPE;
1411: ) IS
1412: l_sav_sae_id OKC_K_ARTICLES_B.SAV_SAE_ID%TYPE;
1413: l_document_type OKC_K_ARTICLES_B.DOCUMENT_TYPE%TYPE;
1414: l_document_id OKC_K_ARTICLES_B.DOCUMENT_ID%TYPE;
1415: l_cle_id OKC_K_ARTICLES_B.CLE_ID%TYPE;
1416: l_source_flag OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE;
1417: l_mandatory_yn OKC_K_ARTICLES_B.MANDATORY_YN%TYPE;
1418: l_mandatory_rwa OKC_K_ARTICLES_B.MANDATORY_RWA%TYPE;
1419: l_scn_id OKC_K_ARTICLES_B.SCN_ID%TYPE;
1412: l_sav_sae_id OKC_K_ARTICLES_B.SAV_SAE_ID%TYPE;
1413: l_document_type OKC_K_ARTICLES_B.DOCUMENT_TYPE%TYPE;
1414: l_document_id OKC_K_ARTICLES_B.DOCUMENT_ID%TYPE;
1415: l_cle_id OKC_K_ARTICLES_B.CLE_ID%TYPE;
1416: l_source_flag OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE;
1417: l_mandatory_yn OKC_K_ARTICLES_B.MANDATORY_YN%TYPE;
1418: l_mandatory_rwa OKC_K_ARTICLES_B.MANDATORY_RWA%TYPE;
1419: l_scn_id OKC_K_ARTICLES_B.SCN_ID%TYPE;
1420: l_label OKC_K_ARTICLES_B.LABEL%TYPE;
1413: l_document_type OKC_K_ARTICLES_B.DOCUMENT_TYPE%TYPE;
1414: l_document_id OKC_K_ARTICLES_B.DOCUMENT_ID%TYPE;
1415: l_cle_id OKC_K_ARTICLES_B.CLE_ID%TYPE;
1416: l_source_flag OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE;
1417: l_mandatory_yn OKC_K_ARTICLES_B.MANDATORY_YN%TYPE;
1418: l_mandatory_rwa OKC_K_ARTICLES_B.MANDATORY_RWA%TYPE;
1419: l_scn_id OKC_K_ARTICLES_B.SCN_ID%TYPE;
1420: l_label OKC_K_ARTICLES_B.LABEL%TYPE;
1421: l_amendment_description OKC_K_ARTICLES_B.AMENDMENT_DESCRIPTION%TYPE;
1414: l_document_id OKC_K_ARTICLES_B.DOCUMENT_ID%TYPE;
1415: l_cle_id OKC_K_ARTICLES_B.CLE_ID%TYPE;
1416: l_source_flag OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE;
1417: l_mandatory_yn OKC_K_ARTICLES_B.MANDATORY_YN%TYPE;
1418: l_mandatory_rwa OKC_K_ARTICLES_B.MANDATORY_RWA%TYPE;
1419: l_scn_id OKC_K_ARTICLES_B.SCN_ID%TYPE;
1420: l_label OKC_K_ARTICLES_B.LABEL%TYPE;
1421: l_amendment_description OKC_K_ARTICLES_B.AMENDMENT_DESCRIPTION%TYPE;
1422: l_amendment_operation_code OKC_K_ARTICLES_B.AMENDMENT_OPERATION_CODE%TYPE;
1415: l_cle_id OKC_K_ARTICLES_B.CLE_ID%TYPE;
1416: l_source_flag OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE;
1417: l_mandatory_yn OKC_K_ARTICLES_B.MANDATORY_YN%TYPE;
1418: l_mandatory_rwa OKC_K_ARTICLES_B.MANDATORY_RWA%TYPE;
1419: l_scn_id OKC_K_ARTICLES_B.SCN_ID%TYPE;
1420: l_label OKC_K_ARTICLES_B.LABEL%TYPE;
1421: l_amendment_description OKC_K_ARTICLES_B.AMENDMENT_DESCRIPTION%TYPE;
1422: l_amendment_operation_code OKC_K_ARTICLES_B.AMENDMENT_OPERATION_CODE%TYPE;
1423: l_article_version_id OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE;
1416: l_source_flag OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE;
1417: l_mandatory_yn OKC_K_ARTICLES_B.MANDATORY_YN%TYPE;
1418: l_mandatory_rwa OKC_K_ARTICLES_B.MANDATORY_RWA%TYPE;
1419: l_scn_id OKC_K_ARTICLES_B.SCN_ID%TYPE;
1420: l_label OKC_K_ARTICLES_B.LABEL%TYPE;
1421: l_amendment_description OKC_K_ARTICLES_B.AMENDMENT_DESCRIPTION%TYPE;
1422: l_amendment_operation_code OKC_K_ARTICLES_B.AMENDMENT_OPERATION_CODE%TYPE;
1423: l_article_version_id OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE;
1424: l_change_nonstd_yn OKC_K_ARTICLES_B.CHANGE_NONSTD_YN%TYPE;
1417: l_mandatory_yn OKC_K_ARTICLES_B.MANDATORY_YN%TYPE;
1418: l_mandatory_rwa OKC_K_ARTICLES_B.MANDATORY_RWA%TYPE;
1419: l_scn_id OKC_K_ARTICLES_B.SCN_ID%TYPE;
1420: l_label OKC_K_ARTICLES_B.LABEL%TYPE;
1421: l_amendment_description OKC_K_ARTICLES_B.AMENDMENT_DESCRIPTION%TYPE;
1422: l_amendment_operation_code OKC_K_ARTICLES_B.AMENDMENT_OPERATION_CODE%TYPE;
1423: l_article_version_id OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE;
1424: l_change_nonstd_yn OKC_K_ARTICLES_B.CHANGE_NONSTD_YN%TYPE;
1425: l_orig_system_reference_code OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
1418: l_mandatory_rwa OKC_K_ARTICLES_B.MANDATORY_RWA%TYPE;
1419: l_scn_id OKC_K_ARTICLES_B.SCN_ID%TYPE;
1420: l_label OKC_K_ARTICLES_B.LABEL%TYPE;
1421: l_amendment_description OKC_K_ARTICLES_B.AMENDMENT_DESCRIPTION%TYPE;
1422: l_amendment_operation_code OKC_K_ARTICLES_B.AMENDMENT_OPERATION_CODE%TYPE;
1423: l_article_version_id OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE;
1424: l_change_nonstd_yn OKC_K_ARTICLES_B.CHANGE_NONSTD_YN%TYPE;
1425: l_orig_system_reference_code OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
1426: l_orig_system_reference_id1 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
1419: l_scn_id OKC_K_ARTICLES_B.SCN_ID%TYPE;
1420: l_label OKC_K_ARTICLES_B.LABEL%TYPE;
1421: l_amendment_description OKC_K_ARTICLES_B.AMENDMENT_DESCRIPTION%TYPE;
1422: l_amendment_operation_code OKC_K_ARTICLES_B.AMENDMENT_OPERATION_CODE%TYPE;
1423: l_article_version_id OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE;
1424: l_change_nonstd_yn OKC_K_ARTICLES_B.CHANGE_NONSTD_YN%TYPE;
1425: l_orig_system_reference_code OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
1426: l_orig_system_reference_id1 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
1427: l_orig_system_reference_id2 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
1420: l_label OKC_K_ARTICLES_B.LABEL%TYPE;
1421: l_amendment_description OKC_K_ARTICLES_B.AMENDMENT_DESCRIPTION%TYPE;
1422: l_amendment_operation_code OKC_K_ARTICLES_B.AMENDMENT_OPERATION_CODE%TYPE;
1423: l_article_version_id OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE;
1424: l_change_nonstd_yn OKC_K_ARTICLES_B.CHANGE_NONSTD_YN%TYPE;
1425: l_orig_system_reference_code OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
1426: l_orig_system_reference_id1 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
1427: l_orig_system_reference_id2 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
1428: l_display_sequence OKC_K_ARTICLES_B.DISPLAY_SEQUENCE%TYPE;
1421: l_amendment_description OKC_K_ARTICLES_B.AMENDMENT_DESCRIPTION%TYPE;
1422: l_amendment_operation_code OKC_K_ARTICLES_B.AMENDMENT_OPERATION_CODE%TYPE;
1423: l_article_version_id OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE;
1424: l_change_nonstd_yn OKC_K_ARTICLES_B.CHANGE_NONSTD_YN%TYPE;
1425: l_orig_system_reference_code OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
1426: l_orig_system_reference_id1 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
1427: l_orig_system_reference_id2 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
1428: l_display_sequence OKC_K_ARTICLES_B.DISPLAY_SEQUENCE%TYPE;
1429: l_attribute_category OKC_K_ARTICLES_B.ATTRIBUTE_CATEGORY%TYPE;
1422: l_amendment_operation_code OKC_K_ARTICLES_B.AMENDMENT_OPERATION_CODE%TYPE;
1423: l_article_version_id OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE;
1424: l_change_nonstd_yn OKC_K_ARTICLES_B.CHANGE_NONSTD_YN%TYPE;
1425: l_orig_system_reference_code OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
1426: l_orig_system_reference_id1 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
1427: l_orig_system_reference_id2 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
1428: l_display_sequence OKC_K_ARTICLES_B.DISPLAY_SEQUENCE%TYPE;
1429: l_attribute_category OKC_K_ARTICLES_B.ATTRIBUTE_CATEGORY%TYPE;
1430: l_attribute1 OKC_K_ARTICLES_B.ATTRIBUTE1%TYPE;
1423: l_article_version_id OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE;
1424: l_change_nonstd_yn OKC_K_ARTICLES_B.CHANGE_NONSTD_YN%TYPE;
1425: l_orig_system_reference_code OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
1426: l_orig_system_reference_id1 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
1427: l_orig_system_reference_id2 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
1428: l_display_sequence OKC_K_ARTICLES_B.DISPLAY_SEQUENCE%TYPE;
1429: l_attribute_category OKC_K_ARTICLES_B.ATTRIBUTE_CATEGORY%TYPE;
1430: l_attribute1 OKC_K_ARTICLES_B.ATTRIBUTE1%TYPE;
1431: l_attribute2 OKC_K_ARTICLES_B.ATTRIBUTE2%TYPE;
1424: l_change_nonstd_yn OKC_K_ARTICLES_B.CHANGE_NONSTD_YN%TYPE;
1425: l_orig_system_reference_code OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
1426: l_orig_system_reference_id1 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
1427: l_orig_system_reference_id2 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
1428: l_display_sequence OKC_K_ARTICLES_B.DISPLAY_SEQUENCE%TYPE;
1429: l_attribute_category OKC_K_ARTICLES_B.ATTRIBUTE_CATEGORY%TYPE;
1430: l_attribute1 OKC_K_ARTICLES_B.ATTRIBUTE1%TYPE;
1431: l_attribute2 OKC_K_ARTICLES_B.ATTRIBUTE2%TYPE;
1432: l_attribute3 OKC_K_ARTICLES_B.ATTRIBUTE3%TYPE;
1425: l_orig_system_reference_code OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
1426: l_orig_system_reference_id1 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
1427: l_orig_system_reference_id2 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
1428: l_display_sequence OKC_K_ARTICLES_B.DISPLAY_SEQUENCE%TYPE;
1429: l_attribute_category OKC_K_ARTICLES_B.ATTRIBUTE_CATEGORY%TYPE;
1430: l_attribute1 OKC_K_ARTICLES_B.ATTRIBUTE1%TYPE;
1431: l_attribute2 OKC_K_ARTICLES_B.ATTRIBUTE2%TYPE;
1432: l_attribute3 OKC_K_ARTICLES_B.ATTRIBUTE3%TYPE;
1433: l_attribute4 OKC_K_ARTICLES_B.ATTRIBUTE4%TYPE;
1426: l_orig_system_reference_id1 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
1427: l_orig_system_reference_id2 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
1428: l_display_sequence OKC_K_ARTICLES_B.DISPLAY_SEQUENCE%TYPE;
1429: l_attribute_category OKC_K_ARTICLES_B.ATTRIBUTE_CATEGORY%TYPE;
1430: l_attribute1 OKC_K_ARTICLES_B.ATTRIBUTE1%TYPE;
1431: l_attribute2 OKC_K_ARTICLES_B.ATTRIBUTE2%TYPE;
1432: l_attribute3 OKC_K_ARTICLES_B.ATTRIBUTE3%TYPE;
1433: l_attribute4 OKC_K_ARTICLES_B.ATTRIBUTE4%TYPE;
1434: l_attribute5 OKC_K_ARTICLES_B.ATTRIBUTE5%TYPE;
1427: l_orig_system_reference_id2 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
1428: l_display_sequence OKC_K_ARTICLES_B.DISPLAY_SEQUENCE%TYPE;
1429: l_attribute_category OKC_K_ARTICLES_B.ATTRIBUTE_CATEGORY%TYPE;
1430: l_attribute1 OKC_K_ARTICLES_B.ATTRIBUTE1%TYPE;
1431: l_attribute2 OKC_K_ARTICLES_B.ATTRIBUTE2%TYPE;
1432: l_attribute3 OKC_K_ARTICLES_B.ATTRIBUTE3%TYPE;
1433: l_attribute4 OKC_K_ARTICLES_B.ATTRIBUTE4%TYPE;
1434: l_attribute5 OKC_K_ARTICLES_B.ATTRIBUTE5%TYPE;
1435: l_attribute6 OKC_K_ARTICLES_B.ATTRIBUTE6%TYPE;
1428: l_display_sequence OKC_K_ARTICLES_B.DISPLAY_SEQUENCE%TYPE;
1429: l_attribute_category OKC_K_ARTICLES_B.ATTRIBUTE_CATEGORY%TYPE;
1430: l_attribute1 OKC_K_ARTICLES_B.ATTRIBUTE1%TYPE;
1431: l_attribute2 OKC_K_ARTICLES_B.ATTRIBUTE2%TYPE;
1432: l_attribute3 OKC_K_ARTICLES_B.ATTRIBUTE3%TYPE;
1433: l_attribute4 OKC_K_ARTICLES_B.ATTRIBUTE4%TYPE;
1434: l_attribute5 OKC_K_ARTICLES_B.ATTRIBUTE5%TYPE;
1435: l_attribute6 OKC_K_ARTICLES_B.ATTRIBUTE6%TYPE;
1436: l_attribute7 OKC_K_ARTICLES_B.ATTRIBUTE7%TYPE;
1429: l_attribute_category OKC_K_ARTICLES_B.ATTRIBUTE_CATEGORY%TYPE;
1430: l_attribute1 OKC_K_ARTICLES_B.ATTRIBUTE1%TYPE;
1431: l_attribute2 OKC_K_ARTICLES_B.ATTRIBUTE2%TYPE;
1432: l_attribute3 OKC_K_ARTICLES_B.ATTRIBUTE3%TYPE;
1433: l_attribute4 OKC_K_ARTICLES_B.ATTRIBUTE4%TYPE;
1434: l_attribute5 OKC_K_ARTICLES_B.ATTRIBUTE5%TYPE;
1435: l_attribute6 OKC_K_ARTICLES_B.ATTRIBUTE6%TYPE;
1436: l_attribute7 OKC_K_ARTICLES_B.ATTRIBUTE7%TYPE;
1437: l_attribute8 OKC_K_ARTICLES_B.ATTRIBUTE8%TYPE;
1430: l_attribute1 OKC_K_ARTICLES_B.ATTRIBUTE1%TYPE;
1431: l_attribute2 OKC_K_ARTICLES_B.ATTRIBUTE2%TYPE;
1432: l_attribute3 OKC_K_ARTICLES_B.ATTRIBUTE3%TYPE;
1433: l_attribute4 OKC_K_ARTICLES_B.ATTRIBUTE4%TYPE;
1434: l_attribute5 OKC_K_ARTICLES_B.ATTRIBUTE5%TYPE;
1435: l_attribute6 OKC_K_ARTICLES_B.ATTRIBUTE6%TYPE;
1436: l_attribute7 OKC_K_ARTICLES_B.ATTRIBUTE7%TYPE;
1437: l_attribute8 OKC_K_ARTICLES_B.ATTRIBUTE8%TYPE;
1438: l_attribute9 OKC_K_ARTICLES_B.ATTRIBUTE9%TYPE;
1431: l_attribute2 OKC_K_ARTICLES_B.ATTRIBUTE2%TYPE;
1432: l_attribute3 OKC_K_ARTICLES_B.ATTRIBUTE3%TYPE;
1433: l_attribute4 OKC_K_ARTICLES_B.ATTRIBUTE4%TYPE;
1434: l_attribute5 OKC_K_ARTICLES_B.ATTRIBUTE5%TYPE;
1435: l_attribute6 OKC_K_ARTICLES_B.ATTRIBUTE6%TYPE;
1436: l_attribute7 OKC_K_ARTICLES_B.ATTRIBUTE7%TYPE;
1437: l_attribute8 OKC_K_ARTICLES_B.ATTRIBUTE8%TYPE;
1438: l_attribute9 OKC_K_ARTICLES_B.ATTRIBUTE9%TYPE;
1439: l_attribute10 OKC_K_ARTICLES_B.ATTRIBUTE10%TYPE;
1432: l_attribute3 OKC_K_ARTICLES_B.ATTRIBUTE3%TYPE;
1433: l_attribute4 OKC_K_ARTICLES_B.ATTRIBUTE4%TYPE;
1434: l_attribute5 OKC_K_ARTICLES_B.ATTRIBUTE5%TYPE;
1435: l_attribute6 OKC_K_ARTICLES_B.ATTRIBUTE6%TYPE;
1436: l_attribute7 OKC_K_ARTICLES_B.ATTRIBUTE7%TYPE;
1437: l_attribute8 OKC_K_ARTICLES_B.ATTRIBUTE8%TYPE;
1438: l_attribute9 OKC_K_ARTICLES_B.ATTRIBUTE9%TYPE;
1439: l_attribute10 OKC_K_ARTICLES_B.ATTRIBUTE10%TYPE;
1440: l_attribute11 OKC_K_ARTICLES_B.ATTRIBUTE11%TYPE;
1433: l_attribute4 OKC_K_ARTICLES_B.ATTRIBUTE4%TYPE;
1434: l_attribute5 OKC_K_ARTICLES_B.ATTRIBUTE5%TYPE;
1435: l_attribute6 OKC_K_ARTICLES_B.ATTRIBUTE6%TYPE;
1436: l_attribute7 OKC_K_ARTICLES_B.ATTRIBUTE7%TYPE;
1437: l_attribute8 OKC_K_ARTICLES_B.ATTRIBUTE8%TYPE;
1438: l_attribute9 OKC_K_ARTICLES_B.ATTRIBUTE9%TYPE;
1439: l_attribute10 OKC_K_ARTICLES_B.ATTRIBUTE10%TYPE;
1440: l_attribute11 OKC_K_ARTICLES_B.ATTRIBUTE11%TYPE;
1441: l_attribute12 OKC_K_ARTICLES_B.ATTRIBUTE12%TYPE;
1434: l_attribute5 OKC_K_ARTICLES_B.ATTRIBUTE5%TYPE;
1435: l_attribute6 OKC_K_ARTICLES_B.ATTRIBUTE6%TYPE;
1436: l_attribute7 OKC_K_ARTICLES_B.ATTRIBUTE7%TYPE;
1437: l_attribute8 OKC_K_ARTICLES_B.ATTRIBUTE8%TYPE;
1438: l_attribute9 OKC_K_ARTICLES_B.ATTRIBUTE9%TYPE;
1439: l_attribute10 OKC_K_ARTICLES_B.ATTRIBUTE10%TYPE;
1440: l_attribute11 OKC_K_ARTICLES_B.ATTRIBUTE11%TYPE;
1441: l_attribute12 OKC_K_ARTICLES_B.ATTRIBUTE12%TYPE;
1442: l_attribute13 OKC_K_ARTICLES_B.ATTRIBUTE13%TYPE;
1435: l_attribute6 OKC_K_ARTICLES_B.ATTRIBUTE6%TYPE;
1436: l_attribute7 OKC_K_ARTICLES_B.ATTRIBUTE7%TYPE;
1437: l_attribute8 OKC_K_ARTICLES_B.ATTRIBUTE8%TYPE;
1438: l_attribute9 OKC_K_ARTICLES_B.ATTRIBUTE9%TYPE;
1439: l_attribute10 OKC_K_ARTICLES_B.ATTRIBUTE10%TYPE;
1440: l_attribute11 OKC_K_ARTICLES_B.ATTRIBUTE11%TYPE;
1441: l_attribute12 OKC_K_ARTICLES_B.ATTRIBUTE12%TYPE;
1442: l_attribute13 OKC_K_ARTICLES_B.ATTRIBUTE13%TYPE;
1443: l_attribute14 OKC_K_ARTICLES_B.ATTRIBUTE14%TYPE;
1436: l_attribute7 OKC_K_ARTICLES_B.ATTRIBUTE7%TYPE;
1437: l_attribute8 OKC_K_ARTICLES_B.ATTRIBUTE8%TYPE;
1438: l_attribute9 OKC_K_ARTICLES_B.ATTRIBUTE9%TYPE;
1439: l_attribute10 OKC_K_ARTICLES_B.ATTRIBUTE10%TYPE;
1440: l_attribute11 OKC_K_ARTICLES_B.ATTRIBUTE11%TYPE;
1441: l_attribute12 OKC_K_ARTICLES_B.ATTRIBUTE12%TYPE;
1442: l_attribute13 OKC_K_ARTICLES_B.ATTRIBUTE13%TYPE;
1443: l_attribute14 OKC_K_ARTICLES_B.ATTRIBUTE14%TYPE;
1444: l_attribute15 OKC_K_ARTICLES_B.ATTRIBUTE15%TYPE;
1437: l_attribute8 OKC_K_ARTICLES_B.ATTRIBUTE8%TYPE;
1438: l_attribute9 OKC_K_ARTICLES_B.ATTRIBUTE9%TYPE;
1439: l_attribute10 OKC_K_ARTICLES_B.ATTRIBUTE10%TYPE;
1440: l_attribute11 OKC_K_ARTICLES_B.ATTRIBUTE11%TYPE;
1441: l_attribute12 OKC_K_ARTICLES_B.ATTRIBUTE12%TYPE;
1442: l_attribute13 OKC_K_ARTICLES_B.ATTRIBUTE13%TYPE;
1443: l_attribute14 OKC_K_ARTICLES_B.ATTRIBUTE14%TYPE;
1444: l_attribute15 OKC_K_ARTICLES_B.ATTRIBUTE15%TYPE;
1445: l_print_text_yn OKC_K_ARTICLES_B.print_text_yn%TYPE;
1438: l_attribute9 OKC_K_ARTICLES_B.ATTRIBUTE9%TYPE;
1439: l_attribute10 OKC_K_ARTICLES_B.ATTRIBUTE10%TYPE;
1440: l_attribute11 OKC_K_ARTICLES_B.ATTRIBUTE11%TYPE;
1441: l_attribute12 OKC_K_ARTICLES_B.ATTRIBUTE12%TYPE;
1442: l_attribute13 OKC_K_ARTICLES_B.ATTRIBUTE13%TYPE;
1443: l_attribute14 OKC_K_ARTICLES_B.ATTRIBUTE14%TYPE;
1444: l_attribute15 OKC_K_ARTICLES_B.ATTRIBUTE15%TYPE;
1445: l_print_text_yn OKC_K_ARTICLES_B.print_text_yn%TYPE;
1446: l_summary_amend_operation_code OKC_K_ARTICLES_B.summary_amend_operation_code%TYPE;
1439: l_attribute10 OKC_K_ARTICLES_B.ATTRIBUTE10%TYPE;
1440: l_attribute11 OKC_K_ARTICLES_B.ATTRIBUTE11%TYPE;
1441: l_attribute12 OKC_K_ARTICLES_B.ATTRIBUTE12%TYPE;
1442: l_attribute13 OKC_K_ARTICLES_B.ATTRIBUTE13%TYPE;
1443: l_attribute14 OKC_K_ARTICLES_B.ATTRIBUTE14%TYPE;
1444: l_attribute15 OKC_K_ARTICLES_B.ATTRIBUTE15%TYPE;
1445: l_print_text_yn OKC_K_ARTICLES_B.print_text_yn%TYPE;
1446: l_summary_amend_operation_code OKC_K_ARTICLES_B.summary_amend_operation_code%TYPE;
1447: l_ref_article_id OKC_K_ARTICLES_B.ref_article_id%TYPE;
1440: l_attribute11 OKC_K_ARTICLES_B.ATTRIBUTE11%TYPE;
1441: l_attribute12 OKC_K_ARTICLES_B.ATTRIBUTE12%TYPE;
1442: l_attribute13 OKC_K_ARTICLES_B.ATTRIBUTE13%TYPE;
1443: l_attribute14 OKC_K_ARTICLES_B.ATTRIBUTE14%TYPE;
1444: l_attribute15 OKC_K_ARTICLES_B.ATTRIBUTE15%TYPE;
1445: l_print_text_yn OKC_K_ARTICLES_B.print_text_yn%TYPE;
1446: l_summary_amend_operation_code OKC_K_ARTICLES_B.summary_amend_operation_code%TYPE;
1447: l_ref_article_id OKC_K_ARTICLES_B.ref_article_id%TYPE;
1448: l_ref_article_version_id OKC_K_ARTICLES_B.ref_article_version_id%TYPE;
1441: l_attribute12 OKC_K_ARTICLES_B.ATTRIBUTE12%TYPE;
1442: l_attribute13 OKC_K_ARTICLES_B.ATTRIBUTE13%TYPE;
1443: l_attribute14 OKC_K_ARTICLES_B.ATTRIBUTE14%TYPE;
1444: l_attribute15 OKC_K_ARTICLES_B.ATTRIBUTE15%TYPE;
1445: l_print_text_yn OKC_K_ARTICLES_B.print_text_yn%TYPE;
1446: l_summary_amend_operation_code OKC_K_ARTICLES_B.summary_amend_operation_code%TYPE;
1447: l_ref_article_id OKC_K_ARTICLES_B.ref_article_id%TYPE;
1448: l_ref_article_version_id OKC_K_ARTICLES_B.ref_article_version_id%TYPE;
1449: l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;
1442: l_attribute13 OKC_K_ARTICLES_B.ATTRIBUTE13%TYPE;
1443: l_attribute14 OKC_K_ARTICLES_B.ATTRIBUTE14%TYPE;
1444: l_attribute15 OKC_K_ARTICLES_B.ATTRIBUTE15%TYPE;
1445: l_print_text_yn OKC_K_ARTICLES_B.print_text_yn%TYPE;
1446: l_summary_amend_operation_code OKC_K_ARTICLES_B.summary_amend_operation_code%TYPE;
1447: l_ref_article_id OKC_K_ARTICLES_B.ref_article_id%TYPE;
1448: l_ref_article_version_id OKC_K_ARTICLES_B.ref_article_version_id%TYPE;
1449: l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;
1450: l_created_by OKC_K_ARTICLES_B.CREATED_BY%TYPE;
1443: l_attribute14 OKC_K_ARTICLES_B.ATTRIBUTE14%TYPE;
1444: l_attribute15 OKC_K_ARTICLES_B.ATTRIBUTE15%TYPE;
1445: l_print_text_yn OKC_K_ARTICLES_B.print_text_yn%TYPE;
1446: l_summary_amend_operation_code OKC_K_ARTICLES_B.summary_amend_operation_code%TYPE;
1447: l_ref_article_id OKC_K_ARTICLES_B.ref_article_id%TYPE;
1448: l_ref_article_version_id OKC_K_ARTICLES_B.ref_article_version_id%TYPE;
1449: l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;
1450: l_created_by OKC_K_ARTICLES_B.CREATED_BY%TYPE;
1451: l_creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE;
1444: l_attribute15 OKC_K_ARTICLES_B.ATTRIBUTE15%TYPE;
1445: l_print_text_yn OKC_K_ARTICLES_B.print_text_yn%TYPE;
1446: l_summary_amend_operation_code OKC_K_ARTICLES_B.summary_amend_operation_code%TYPE;
1447: l_ref_article_id OKC_K_ARTICLES_B.ref_article_id%TYPE;
1448: l_ref_article_version_id OKC_K_ARTICLES_B.ref_article_version_id%TYPE;
1449: l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;
1450: l_created_by OKC_K_ARTICLES_B.CREATED_BY%TYPE;
1451: l_creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE;
1452: l_last_updated_by OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;
1445: l_print_text_yn OKC_K_ARTICLES_B.print_text_yn%TYPE;
1446: l_summary_amend_operation_code OKC_K_ARTICLES_B.summary_amend_operation_code%TYPE;
1447: l_ref_article_id OKC_K_ARTICLES_B.ref_article_id%TYPE;
1448: l_ref_article_version_id OKC_K_ARTICLES_B.ref_article_version_id%TYPE;
1449: l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;
1450: l_created_by OKC_K_ARTICLES_B.CREATED_BY%TYPE;
1451: l_creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE;
1452: l_last_updated_by OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;
1453: l_last_update_login OKC_K_ARTICLES_B.LAST_UPDATE_LOGIN%TYPE;
1446: l_summary_amend_operation_code OKC_K_ARTICLES_B.summary_amend_operation_code%TYPE;
1447: l_ref_article_id OKC_K_ARTICLES_B.ref_article_id%TYPE;
1448: l_ref_article_version_id OKC_K_ARTICLES_B.ref_article_version_id%TYPE;
1449: l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;
1450: l_created_by OKC_K_ARTICLES_B.CREATED_BY%TYPE;
1451: l_creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE;
1452: l_last_updated_by OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;
1453: l_last_update_login OKC_K_ARTICLES_B.LAST_UPDATE_LOGIN%TYPE;
1454: l_last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE;
1447: l_ref_article_id OKC_K_ARTICLES_B.ref_article_id%TYPE;
1448: l_ref_article_version_id OKC_K_ARTICLES_B.ref_article_version_id%TYPE;
1449: l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;
1450: l_created_by OKC_K_ARTICLES_B.CREATED_BY%TYPE;
1451: l_creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE;
1452: l_last_updated_by OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;
1453: l_last_update_login OKC_K_ARTICLES_B.LAST_UPDATE_LOGIN%TYPE;
1454: l_last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE;
1455: l_last_amended_by OKC_K_ARTICLES_B.LAST_AMENDED_BY%TYPE;
1448: l_ref_article_version_id OKC_K_ARTICLES_B.ref_article_version_id%TYPE;
1449: l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;
1450: l_created_by OKC_K_ARTICLES_B.CREATED_BY%TYPE;
1451: l_creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE;
1452: l_last_updated_by OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;
1453: l_last_update_login OKC_K_ARTICLES_B.LAST_UPDATE_LOGIN%TYPE;
1454: l_last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE;
1455: l_last_amended_by OKC_K_ARTICLES_B.LAST_AMENDED_BY%TYPE;
1456: l_last_amendment_date OKC_K_ARTICLES_B.LAST_AMENDMENT_DATE%TYPE;
1449: l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;
1450: l_created_by OKC_K_ARTICLES_B.CREATED_BY%TYPE;
1451: l_creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE;
1452: l_last_updated_by OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;
1453: l_last_update_login OKC_K_ARTICLES_B.LAST_UPDATE_LOGIN%TYPE;
1454: l_last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE;
1455: l_last_amended_by OKC_K_ARTICLES_B.LAST_AMENDED_BY%TYPE;
1456: l_last_amendment_date OKC_K_ARTICLES_B.LAST_AMENDMENT_DATE%TYPE;
1457: BEGIN
1450: l_created_by OKC_K_ARTICLES_B.CREATED_BY%TYPE;
1451: l_creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE;
1452: l_last_updated_by OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;
1453: l_last_update_login OKC_K_ARTICLES_B.LAST_UPDATE_LOGIN%TYPE;
1454: l_last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE;
1455: l_last_amended_by OKC_K_ARTICLES_B.LAST_AMENDED_BY%TYPE;
1456: l_last_amendment_date OKC_K_ARTICLES_B.LAST_AMENDMENT_DATE%TYPE;
1457: BEGIN
1458:
1451: l_creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE;
1452: l_last_updated_by OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;
1453: l_last_update_login OKC_K_ARTICLES_B.LAST_UPDATE_LOGIN%TYPE;
1454: l_last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE;
1455: l_last_amended_by OKC_K_ARTICLES_B.LAST_AMENDED_BY%TYPE;
1456: l_last_amendment_date OKC_K_ARTICLES_B.LAST_AMENDMENT_DATE%TYPE;
1457: BEGIN
1458:
1459: IF (l_debug = 'Y') THEN
1452: l_last_updated_by OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;
1453: l_last_update_login OKC_K_ARTICLES_B.LAST_UPDATE_LOGIN%TYPE;
1454: l_last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE;
1455: l_last_amended_by OKC_K_ARTICLES_B.LAST_AMENDED_BY%TYPE;
1456: l_last_amendment_date OKC_K_ARTICLES_B.LAST_AMENDMENT_DATE%TYPE;
1457: BEGIN
1458:
1459: IF (l_debug = 'Y') THEN
1460: Okc_Debug.Log('2600: Entered validate_row', 2);
1632: ---------------------------------------------------------------------------
1633: -- PROCEDURE Insert_Row
1634: ---------------------------------------------------------------------------
1635: -------------------------------------
1636: -- Insert_Row for:OKC_K_ARTICLES_B --
1637: -------------------------------------
1638: FUNCTION Insert_Row(
1639: p_id IN NUMBER,
1640: p_sav_sae_id IN NUMBER,
1695: IF p_document_type IN ('OKC_SELL','OKC_BUY','OKO','OKS','OKE_SELL','OKE_BUY','OKL') THEN
1696: l_chr_id := okc_terms_util_pvt.get_chr_id_for_doc_id(p_document_id);
1697: END IF;
1698:
1699: INSERT INTO OKC_K_ARTICLES_B(
1700: ID,
1701: SAV_SAE_ID,
1702: SAV_SAV_RELEASE,
1703: SBT_CODE,
1831:
1832: END Insert_Row;
1833:
1834: -------------------------------------
1835: -- Insert_Row for:OKC_K_ARTICLES_B --
1836: -------------------------------------
1837: PROCEDURE Insert_Row(
1838: p_validation_level IN NUMBER,
1839: x_return_status OUT NOCOPY VARCHAR2,
1879: x_id OUT NOCOPY NUMBER
1880:
1881: ) IS
1882:
1883: l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;
1884: l_created_by OKC_K_ARTICLES_B.CREATED_BY%TYPE;
1885: l_creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE;
1886: l_last_updated_by OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;
1887: l_last_update_login OKC_K_ARTICLES_B.LAST_UPDATE_LOGIN%TYPE;
1880:
1881: ) IS
1882:
1883: l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;
1884: l_created_by OKC_K_ARTICLES_B.CREATED_BY%TYPE;
1885: l_creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE;
1886: l_last_updated_by OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;
1887: l_last_update_login OKC_K_ARTICLES_B.LAST_UPDATE_LOGIN%TYPE;
1888: l_last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE;
1881: ) IS
1882:
1883: l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;
1884: l_created_by OKC_K_ARTICLES_B.CREATED_BY%TYPE;
1885: l_creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE;
1886: l_last_updated_by OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;
1887: l_last_update_login OKC_K_ARTICLES_B.LAST_UPDATE_LOGIN%TYPE;
1888: l_last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE;
1889: l_last_amended_by OKC_K_ARTICLES_B.LAST_AMENDED_BY%TYPE;
1882:
1883: l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;
1884: l_created_by OKC_K_ARTICLES_B.CREATED_BY%TYPE;
1885: l_creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE;
1886: l_last_updated_by OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;
1887: l_last_update_login OKC_K_ARTICLES_B.LAST_UPDATE_LOGIN%TYPE;
1888: l_last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE;
1889: l_last_amended_by OKC_K_ARTICLES_B.LAST_AMENDED_BY%TYPE;
1890: l_last_amendment_date OKC_K_ARTICLES_B.LAST_AMENDMENT_DATE%TYPE;
1883: l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;
1884: l_created_by OKC_K_ARTICLES_B.CREATED_BY%TYPE;
1885: l_creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE;
1886: l_last_updated_by OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;
1887: l_last_update_login OKC_K_ARTICLES_B.LAST_UPDATE_LOGIN%TYPE;
1888: l_last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE;
1889: l_last_amended_by OKC_K_ARTICLES_B.LAST_AMENDED_BY%TYPE;
1890: l_last_amendment_date OKC_K_ARTICLES_B.LAST_AMENDMENT_DATE%TYPE;
1891:
1884: l_created_by OKC_K_ARTICLES_B.CREATED_BY%TYPE;
1885: l_creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE;
1886: l_last_updated_by OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;
1887: l_last_update_login OKC_K_ARTICLES_B.LAST_UPDATE_LOGIN%TYPE;
1888: l_last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE;
1889: l_last_amended_by OKC_K_ARTICLES_B.LAST_AMENDED_BY%TYPE;
1890: l_last_amendment_date OKC_K_ARTICLES_B.LAST_AMENDMENT_DATE%TYPE;
1891:
1892: BEGIN
1885: l_creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE;
1886: l_last_updated_by OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;
1887: l_last_update_login OKC_K_ARTICLES_B.LAST_UPDATE_LOGIN%TYPE;
1888: l_last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE;
1889: l_last_amended_by OKC_K_ARTICLES_B.LAST_AMENDED_BY%TYPE;
1890: l_last_amendment_date OKC_K_ARTICLES_B.LAST_AMENDMENT_DATE%TYPE;
1891:
1892: BEGIN
1893:
1886: l_last_updated_by OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;
1887: l_last_update_login OKC_K_ARTICLES_B.LAST_UPDATE_LOGIN%TYPE;
1888: l_last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE;
1889: l_last_amended_by OKC_K_ARTICLES_B.LAST_AMENDED_BY%TYPE;
1890: l_last_amendment_date OKC_K_ARTICLES_B.LAST_AMENDMENT_DATE%TYPE;
1891:
1892: BEGIN
1893:
1894: x_return_status := G_RET_STS_SUCCESS;
2070: ---------------------------------------------------------------------------
2071: -- PROCEDURE Lock_Row
2072: ---------------------------------------------------------------------------
2073: -----------------------------------
2074: -- Lock_Row for:OKC_K_ARTICLES_B --
2075: -----------------------------------
2076: FUNCTION Lock_Row(
2077: p_id IN NUMBER,
2078: p_object_version_number IN NUMBER
2080:
2081:
2082: CURSOR lock_csr (cp_id NUMBER, cp_object_version_number NUMBER) IS
2083: SELECT object_version_number
2084: FROM OKC_K_ARTICLES_B
2085: WHERE ID = cp_id
2086: AND (object_version_number = cp_object_version_number OR cp_object_version_number IS NULL)
2087: FOR UPDATE OF object_version_number NOWAIT;
2088:
2087: FOR UPDATE OF object_version_number NOWAIT;
2088:
2089: CURSOR lchk_csr (cp_id NUMBER) IS
2090: SELECT object_version_number
2091: FROM OKC_K_ARTICLES_B
2092: WHERE ID = cp_id;
2093:
2094: l_return_status VARCHAR2(1);
2095:
2092: WHERE ID = cp_id;
2093:
2094: l_return_status VARCHAR2(1);
2095:
2096: l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;
2097:
2098: l_row_notfound BOOLEAN := FALSE;
2099: BEGIN
2100:
2133: CLOSE lchk_csr;
2134:
2135: IF (l_row_notfound) THEN
2136: Okc_Api.Set_Message(G_APP_NAME,G_LOCK_RECORD_DELETED,
2137: 'ENTITYNAME','OKC_K_ARTICLES_B',
2138: 'PKEY',p_id,
2139: 'OVN',p_object_version_number
2140: );
2141: ELSIF l_object_version_number > p_object_version_number THEN
2178:
2179: RETURN( G_RET_STS_UNEXP_ERROR );
2180: END Lock_Row;
2181: -----------------------------------
2182: -- Lock_Row for:OKC_K_ARTICLES_B --
2183: -----------------------------------
2184: PROCEDURE Lock_Row(
2185: x_return_status OUT NOCOPY VARCHAR2,
2186: p_id IN NUMBER,
2243: ---------------------------------------------------------------------------
2244: -- PROCEDURE Update_Row
2245: ---------------------------------------------------------------------------
2246: -------------------------------------
2247: -- Update_Row for:OKC_K_ARTICLES_B --
2248: -------------------------------------
2249: FUNCTION Update_Row(
2250: p_id IN NUMBER,
2251: p_sav_sae_id IN NUMBER,
2305: IF p_document_type IN ('OKC_SELL','OKC_BUY','OKO','OKS','OKE_SELL','OKE_BUY','OKL') THEN
2306: l_chr_id := okc_terms_util_pvt.get_chr_id_for_doc_id(p_document_id);
2307: END IF;
2308:
2309: UPDATE OKC_K_ARTICLES_B
2310: SET SAV_SAE_ID = p_sav_sae_id,
2311: DOCUMENT_TYPE = p_document_type,
2312: DOCUMENT_ID = p_document_id,
2313: CLE_ID = p_cle_id,
2377: RETURN G_RET_STS_UNEXP_ERROR ;
2378:
2379: END Update_Row;
2380: -------------------------------------
2381: -- Update_Row for:OKC_K_ARTICLES_B --
2382: -------------------------------------
2383: PROCEDURE Update_Row(
2384: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2385: x_return_status OUT NOCOPY VARCHAR2,
2426: p_last_amendment_date IN DATE
2427:
2428: ) IS
2429:
2430: l_sav_sae_id OKC_K_ARTICLES_B.SAV_SAE_ID%TYPE;
2431: l_document_type OKC_K_ARTICLES_B.DOCUMENT_TYPE%TYPE;
2432: l_document_id OKC_K_ARTICLES_B.DOCUMENT_ID%TYPE;
2433: l_cle_id OKC_K_ARTICLES_B.cle_id%TYPE;
2434: l_source_flag OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE;
2427:
2428: ) IS
2429:
2430: l_sav_sae_id OKC_K_ARTICLES_B.SAV_SAE_ID%TYPE;
2431: l_document_type OKC_K_ARTICLES_B.DOCUMENT_TYPE%TYPE;
2432: l_document_id OKC_K_ARTICLES_B.DOCUMENT_ID%TYPE;
2433: l_cle_id OKC_K_ARTICLES_B.cle_id%TYPE;
2434: l_source_flag OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE;
2435: l_mandatory_yn OKC_K_ARTICLES_B.MANDATORY_YN%TYPE;
2428: ) IS
2429:
2430: l_sav_sae_id OKC_K_ARTICLES_B.SAV_SAE_ID%TYPE;
2431: l_document_type OKC_K_ARTICLES_B.DOCUMENT_TYPE%TYPE;
2432: l_document_id OKC_K_ARTICLES_B.DOCUMENT_ID%TYPE;
2433: l_cle_id OKC_K_ARTICLES_B.cle_id%TYPE;
2434: l_source_flag OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE;
2435: l_mandatory_yn OKC_K_ARTICLES_B.MANDATORY_YN%TYPE;
2436: l_mandatory_rwa OKC_K_ARTICLES_B.MANDATORY_RWA%TYPE;
2429:
2430: l_sav_sae_id OKC_K_ARTICLES_B.SAV_SAE_ID%TYPE;
2431: l_document_type OKC_K_ARTICLES_B.DOCUMENT_TYPE%TYPE;
2432: l_document_id OKC_K_ARTICLES_B.DOCUMENT_ID%TYPE;
2433: l_cle_id OKC_K_ARTICLES_B.cle_id%TYPE;
2434: l_source_flag OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE;
2435: l_mandatory_yn OKC_K_ARTICLES_B.MANDATORY_YN%TYPE;
2436: l_mandatory_rwa OKC_K_ARTICLES_B.MANDATORY_RWA%TYPE;
2437: l_scn_id OKC_K_ARTICLES_B.SCN_ID%TYPE;
2430: l_sav_sae_id OKC_K_ARTICLES_B.SAV_SAE_ID%TYPE;
2431: l_document_type OKC_K_ARTICLES_B.DOCUMENT_TYPE%TYPE;
2432: l_document_id OKC_K_ARTICLES_B.DOCUMENT_ID%TYPE;
2433: l_cle_id OKC_K_ARTICLES_B.cle_id%TYPE;
2434: l_source_flag OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE;
2435: l_mandatory_yn OKC_K_ARTICLES_B.MANDATORY_YN%TYPE;
2436: l_mandatory_rwa OKC_K_ARTICLES_B.MANDATORY_RWA%TYPE;
2437: l_scn_id OKC_K_ARTICLES_B.SCN_ID%TYPE;
2438: l_label OKC_K_ARTICLES_B.LABEL%TYPE;
2431: l_document_type OKC_K_ARTICLES_B.DOCUMENT_TYPE%TYPE;
2432: l_document_id OKC_K_ARTICLES_B.DOCUMENT_ID%TYPE;
2433: l_cle_id OKC_K_ARTICLES_B.cle_id%TYPE;
2434: l_source_flag OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE;
2435: l_mandatory_yn OKC_K_ARTICLES_B.MANDATORY_YN%TYPE;
2436: l_mandatory_rwa OKC_K_ARTICLES_B.MANDATORY_RWA%TYPE;
2437: l_scn_id OKC_K_ARTICLES_B.SCN_ID%TYPE;
2438: l_label OKC_K_ARTICLES_B.LABEL%TYPE;
2439: l_amendment_description OKC_K_ARTICLES_B.AMENDMENT_DESCRIPTION%TYPE;
2432: l_document_id OKC_K_ARTICLES_B.DOCUMENT_ID%TYPE;
2433: l_cle_id OKC_K_ARTICLES_B.cle_id%TYPE;
2434: l_source_flag OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE;
2435: l_mandatory_yn OKC_K_ARTICLES_B.MANDATORY_YN%TYPE;
2436: l_mandatory_rwa OKC_K_ARTICLES_B.MANDATORY_RWA%TYPE;
2437: l_scn_id OKC_K_ARTICLES_B.SCN_ID%TYPE;
2438: l_label OKC_K_ARTICLES_B.LABEL%TYPE;
2439: l_amendment_description OKC_K_ARTICLES_B.AMENDMENT_DESCRIPTION%TYPE;
2440: l_amendment_operation_code OKC_K_ARTICLES_B.AMENDMENT_OPERATION_CODE%TYPE;
2433: l_cle_id OKC_K_ARTICLES_B.cle_id%TYPE;
2434: l_source_flag OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE;
2435: l_mandatory_yn OKC_K_ARTICLES_B.MANDATORY_YN%TYPE;
2436: l_mandatory_rwa OKC_K_ARTICLES_B.MANDATORY_RWA%TYPE;
2437: l_scn_id OKC_K_ARTICLES_B.SCN_ID%TYPE;
2438: l_label OKC_K_ARTICLES_B.LABEL%TYPE;
2439: l_amendment_description OKC_K_ARTICLES_B.AMENDMENT_DESCRIPTION%TYPE;
2440: l_amendment_operation_code OKC_K_ARTICLES_B.AMENDMENT_OPERATION_CODE%TYPE;
2441: l_article_version_id OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE;
2434: l_source_flag OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE;
2435: l_mandatory_yn OKC_K_ARTICLES_B.MANDATORY_YN%TYPE;
2436: l_mandatory_rwa OKC_K_ARTICLES_B.MANDATORY_RWA%TYPE;
2437: l_scn_id OKC_K_ARTICLES_B.SCN_ID%TYPE;
2438: l_label OKC_K_ARTICLES_B.LABEL%TYPE;
2439: l_amendment_description OKC_K_ARTICLES_B.AMENDMENT_DESCRIPTION%TYPE;
2440: l_amendment_operation_code OKC_K_ARTICLES_B.AMENDMENT_OPERATION_CODE%TYPE;
2441: l_article_version_id OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE;
2442: l_change_nonstd_yn OKC_K_ARTICLES_B.CHANGE_NONSTD_YN%TYPE;
2435: l_mandatory_yn OKC_K_ARTICLES_B.MANDATORY_YN%TYPE;
2436: l_mandatory_rwa OKC_K_ARTICLES_B.MANDATORY_RWA%TYPE;
2437: l_scn_id OKC_K_ARTICLES_B.SCN_ID%TYPE;
2438: l_label OKC_K_ARTICLES_B.LABEL%TYPE;
2439: l_amendment_description OKC_K_ARTICLES_B.AMENDMENT_DESCRIPTION%TYPE;
2440: l_amendment_operation_code OKC_K_ARTICLES_B.AMENDMENT_OPERATION_CODE%TYPE;
2441: l_article_version_id OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE;
2442: l_change_nonstd_yn OKC_K_ARTICLES_B.CHANGE_NONSTD_YN%TYPE;
2443: l_orig_system_reference_code OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
2436: l_mandatory_rwa OKC_K_ARTICLES_B.MANDATORY_RWA%TYPE;
2437: l_scn_id OKC_K_ARTICLES_B.SCN_ID%TYPE;
2438: l_label OKC_K_ARTICLES_B.LABEL%TYPE;
2439: l_amendment_description OKC_K_ARTICLES_B.AMENDMENT_DESCRIPTION%TYPE;
2440: l_amendment_operation_code OKC_K_ARTICLES_B.AMENDMENT_OPERATION_CODE%TYPE;
2441: l_article_version_id OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE;
2442: l_change_nonstd_yn OKC_K_ARTICLES_B.CHANGE_NONSTD_YN%TYPE;
2443: l_orig_system_reference_code OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
2444: l_orig_system_reference_id1 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
2437: l_scn_id OKC_K_ARTICLES_B.SCN_ID%TYPE;
2438: l_label OKC_K_ARTICLES_B.LABEL%TYPE;
2439: l_amendment_description OKC_K_ARTICLES_B.AMENDMENT_DESCRIPTION%TYPE;
2440: l_amendment_operation_code OKC_K_ARTICLES_B.AMENDMENT_OPERATION_CODE%TYPE;
2441: l_article_version_id OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE;
2442: l_change_nonstd_yn OKC_K_ARTICLES_B.CHANGE_NONSTD_YN%TYPE;
2443: l_orig_system_reference_code OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
2444: l_orig_system_reference_id1 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
2445: l_orig_system_reference_id2 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
2438: l_label OKC_K_ARTICLES_B.LABEL%TYPE;
2439: l_amendment_description OKC_K_ARTICLES_B.AMENDMENT_DESCRIPTION%TYPE;
2440: l_amendment_operation_code OKC_K_ARTICLES_B.AMENDMENT_OPERATION_CODE%TYPE;
2441: l_article_version_id OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE;
2442: l_change_nonstd_yn OKC_K_ARTICLES_B.CHANGE_NONSTD_YN%TYPE;
2443: l_orig_system_reference_code OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
2444: l_orig_system_reference_id1 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
2445: l_orig_system_reference_id2 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
2446: l_display_sequence OKC_K_ARTICLES_B.DISPLAY_SEQUENCE%TYPE;
2439: l_amendment_description OKC_K_ARTICLES_B.AMENDMENT_DESCRIPTION%TYPE;
2440: l_amendment_operation_code OKC_K_ARTICLES_B.AMENDMENT_OPERATION_CODE%TYPE;
2441: l_article_version_id OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE;
2442: l_change_nonstd_yn OKC_K_ARTICLES_B.CHANGE_NONSTD_YN%TYPE;
2443: l_orig_system_reference_code OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
2444: l_orig_system_reference_id1 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
2445: l_orig_system_reference_id2 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
2446: l_display_sequence OKC_K_ARTICLES_B.DISPLAY_SEQUENCE%TYPE;
2447: l_attribute_category OKC_K_ARTICLES_B.ATTRIBUTE_CATEGORY%TYPE;
2440: l_amendment_operation_code OKC_K_ARTICLES_B.AMENDMENT_OPERATION_CODE%TYPE;
2441: l_article_version_id OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE;
2442: l_change_nonstd_yn OKC_K_ARTICLES_B.CHANGE_NONSTD_YN%TYPE;
2443: l_orig_system_reference_code OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
2444: l_orig_system_reference_id1 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
2445: l_orig_system_reference_id2 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
2446: l_display_sequence OKC_K_ARTICLES_B.DISPLAY_SEQUENCE%TYPE;
2447: l_attribute_category OKC_K_ARTICLES_B.ATTRIBUTE_CATEGORY%TYPE;
2448: l_attribute1 OKC_K_ARTICLES_B.ATTRIBUTE1%TYPE;
2441: l_article_version_id OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE;
2442: l_change_nonstd_yn OKC_K_ARTICLES_B.CHANGE_NONSTD_YN%TYPE;
2443: l_orig_system_reference_code OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
2444: l_orig_system_reference_id1 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
2445: l_orig_system_reference_id2 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
2446: l_display_sequence OKC_K_ARTICLES_B.DISPLAY_SEQUENCE%TYPE;
2447: l_attribute_category OKC_K_ARTICLES_B.ATTRIBUTE_CATEGORY%TYPE;
2448: l_attribute1 OKC_K_ARTICLES_B.ATTRIBUTE1%TYPE;
2449: l_attribute2 OKC_K_ARTICLES_B.ATTRIBUTE2%TYPE;
2442: l_change_nonstd_yn OKC_K_ARTICLES_B.CHANGE_NONSTD_YN%TYPE;
2443: l_orig_system_reference_code OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
2444: l_orig_system_reference_id1 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
2445: l_orig_system_reference_id2 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
2446: l_display_sequence OKC_K_ARTICLES_B.DISPLAY_SEQUENCE%TYPE;
2447: l_attribute_category OKC_K_ARTICLES_B.ATTRIBUTE_CATEGORY%TYPE;
2448: l_attribute1 OKC_K_ARTICLES_B.ATTRIBUTE1%TYPE;
2449: l_attribute2 OKC_K_ARTICLES_B.ATTRIBUTE2%TYPE;
2450: l_attribute3 OKC_K_ARTICLES_B.ATTRIBUTE3%TYPE;
2443: l_orig_system_reference_code OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
2444: l_orig_system_reference_id1 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
2445: l_orig_system_reference_id2 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
2446: l_display_sequence OKC_K_ARTICLES_B.DISPLAY_SEQUENCE%TYPE;
2447: l_attribute_category OKC_K_ARTICLES_B.ATTRIBUTE_CATEGORY%TYPE;
2448: l_attribute1 OKC_K_ARTICLES_B.ATTRIBUTE1%TYPE;
2449: l_attribute2 OKC_K_ARTICLES_B.ATTRIBUTE2%TYPE;
2450: l_attribute3 OKC_K_ARTICLES_B.ATTRIBUTE3%TYPE;
2451: l_attribute4 OKC_K_ARTICLES_B.ATTRIBUTE4%TYPE;
2444: l_orig_system_reference_id1 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
2445: l_orig_system_reference_id2 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
2446: l_display_sequence OKC_K_ARTICLES_B.DISPLAY_SEQUENCE%TYPE;
2447: l_attribute_category OKC_K_ARTICLES_B.ATTRIBUTE_CATEGORY%TYPE;
2448: l_attribute1 OKC_K_ARTICLES_B.ATTRIBUTE1%TYPE;
2449: l_attribute2 OKC_K_ARTICLES_B.ATTRIBUTE2%TYPE;
2450: l_attribute3 OKC_K_ARTICLES_B.ATTRIBUTE3%TYPE;
2451: l_attribute4 OKC_K_ARTICLES_B.ATTRIBUTE4%TYPE;
2452: l_attribute5 OKC_K_ARTICLES_B.ATTRIBUTE5%TYPE;
2445: l_orig_system_reference_id2 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
2446: l_display_sequence OKC_K_ARTICLES_B.DISPLAY_SEQUENCE%TYPE;
2447: l_attribute_category OKC_K_ARTICLES_B.ATTRIBUTE_CATEGORY%TYPE;
2448: l_attribute1 OKC_K_ARTICLES_B.ATTRIBUTE1%TYPE;
2449: l_attribute2 OKC_K_ARTICLES_B.ATTRIBUTE2%TYPE;
2450: l_attribute3 OKC_K_ARTICLES_B.ATTRIBUTE3%TYPE;
2451: l_attribute4 OKC_K_ARTICLES_B.ATTRIBUTE4%TYPE;
2452: l_attribute5 OKC_K_ARTICLES_B.ATTRIBUTE5%TYPE;
2453: l_attribute6 OKC_K_ARTICLES_B.ATTRIBUTE6%TYPE;
2446: l_display_sequence OKC_K_ARTICLES_B.DISPLAY_SEQUENCE%TYPE;
2447: l_attribute_category OKC_K_ARTICLES_B.ATTRIBUTE_CATEGORY%TYPE;
2448: l_attribute1 OKC_K_ARTICLES_B.ATTRIBUTE1%TYPE;
2449: l_attribute2 OKC_K_ARTICLES_B.ATTRIBUTE2%TYPE;
2450: l_attribute3 OKC_K_ARTICLES_B.ATTRIBUTE3%TYPE;
2451: l_attribute4 OKC_K_ARTICLES_B.ATTRIBUTE4%TYPE;
2452: l_attribute5 OKC_K_ARTICLES_B.ATTRIBUTE5%TYPE;
2453: l_attribute6 OKC_K_ARTICLES_B.ATTRIBUTE6%TYPE;
2454: l_attribute7 OKC_K_ARTICLES_B.ATTRIBUTE7%TYPE;
2447: l_attribute_category OKC_K_ARTICLES_B.ATTRIBUTE_CATEGORY%TYPE;
2448: l_attribute1 OKC_K_ARTICLES_B.ATTRIBUTE1%TYPE;
2449: l_attribute2 OKC_K_ARTICLES_B.ATTRIBUTE2%TYPE;
2450: l_attribute3 OKC_K_ARTICLES_B.ATTRIBUTE3%TYPE;
2451: l_attribute4 OKC_K_ARTICLES_B.ATTRIBUTE4%TYPE;
2452: l_attribute5 OKC_K_ARTICLES_B.ATTRIBUTE5%TYPE;
2453: l_attribute6 OKC_K_ARTICLES_B.ATTRIBUTE6%TYPE;
2454: l_attribute7 OKC_K_ARTICLES_B.ATTRIBUTE7%TYPE;
2455: l_attribute8 OKC_K_ARTICLES_B.ATTRIBUTE8%TYPE;
2448: l_attribute1 OKC_K_ARTICLES_B.ATTRIBUTE1%TYPE;
2449: l_attribute2 OKC_K_ARTICLES_B.ATTRIBUTE2%TYPE;
2450: l_attribute3 OKC_K_ARTICLES_B.ATTRIBUTE3%TYPE;
2451: l_attribute4 OKC_K_ARTICLES_B.ATTRIBUTE4%TYPE;
2452: l_attribute5 OKC_K_ARTICLES_B.ATTRIBUTE5%TYPE;
2453: l_attribute6 OKC_K_ARTICLES_B.ATTRIBUTE6%TYPE;
2454: l_attribute7 OKC_K_ARTICLES_B.ATTRIBUTE7%TYPE;
2455: l_attribute8 OKC_K_ARTICLES_B.ATTRIBUTE8%TYPE;
2456: l_attribute9 OKC_K_ARTICLES_B.ATTRIBUTE9%TYPE;
2449: l_attribute2 OKC_K_ARTICLES_B.ATTRIBUTE2%TYPE;
2450: l_attribute3 OKC_K_ARTICLES_B.ATTRIBUTE3%TYPE;
2451: l_attribute4 OKC_K_ARTICLES_B.ATTRIBUTE4%TYPE;
2452: l_attribute5 OKC_K_ARTICLES_B.ATTRIBUTE5%TYPE;
2453: l_attribute6 OKC_K_ARTICLES_B.ATTRIBUTE6%TYPE;
2454: l_attribute7 OKC_K_ARTICLES_B.ATTRIBUTE7%TYPE;
2455: l_attribute8 OKC_K_ARTICLES_B.ATTRIBUTE8%TYPE;
2456: l_attribute9 OKC_K_ARTICLES_B.ATTRIBUTE9%TYPE;
2457: l_attribute10 OKC_K_ARTICLES_B.ATTRIBUTE10%TYPE;
2450: l_attribute3 OKC_K_ARTICLES_B.ATTRIBUTE3%TYPE;
2451: l_attribute4 OKC_K_ARTICLES_B.ATTRIBUTE4%TYPE;
2452: l_attribute5 OKC_K_ARTICLES_B.ATTRIBUTE5%TYPE;
2453: l_attribute6 OKC_K_ARTICLES_B.ATTRIBUTE6%TYPE;
2454: l_attribute7 OKC_K_ARTICLES_B.ATTRIBUTE7%TYPE;
2455: l_attribute8 OKC_K_ARTICLES_B.ATTRIBUTE8%TYPE;
2456: l_attribute9 OKC_K_ARTICLES_B.ATTRIBUTE9%TYPE;
2457: l_attribute10 OKC_K_ARTICLES_B.ATTRIBUTE10%TYPE;
2458: l_attribute11 OKC_K_ARTICLES_B.ATTRIBUTE11%TYPE;
2451: l_attribute4 OKC_K_ARTICLES_B.ATTRIBUTE4%TYPE;
2452: l_attribute5 OKC_K_ARTICLES_B.ATTRIBUTE5%TYPE;
2453: l_attribute6 OKC_K_ARTICLES_B.ATTRIBUTE6%TYPE;
2454: l_attribute7 OKC_K_ARTICLES_B.ATTRIBUTE7%TYPE;
2455: l_attribute8 OKC_K_ARTICLES_B.ATTRIBUTE8%TYPE;
2456: l_attribute9 OKC_K_ARTICLES_B.ATTRIBUTE9%TYPE;
2457: l_attribute10 OKC_K_ARTICLES_B.ATTRIBUTE10%TYPE;
2458: l_attribute11 OKC_K_ARTICLES_B.ATTRIBUTE11%TYPE;
2459: l_attribute12 OKC_K_ARTICLES_B.ATTRIBUTE12%TYPE;
2452: l_attribute5 OKC_K_ARTICLES_B.ATTRIBUTE5%TYPE;
2453: l_attribute6 OKC_K_ARTICLES_B.ATTRIBUTE6%TYPE;
2454: l_attribute7 OKC_K_ARTICLES_B.ATTRIBUTE7%TYPE;
2455: l_attribute8 OKC_K_ARTICLES_B.ATTRIBUTE8%TYPE;
2456: l_attribute9 OKC_K_ARTICLES_B.ATTRIBUTE9%TYPE;
2457: l_attribute10 OKC_K_ARTICLES_B.ATTRIBUTE10%TYPE;
2458: l_attribute11 OKC_K_ARTICLES_B.ATTRIBUTE11%TYPE;
2459: l_attribute12 OKC_K_ARTICLES_B.ATTRIBUTE12%TYPE;
2460: l_attribute13 OKC_K_ARTICLES_B.ATTRIBUTE13%TYPE;
2453: l_attribute6 OKC_K_ARTICLES_B.ATTRIBUTE6%TYPE;
2454: l_attribute7 OKC_K_ARTICLES_B.ATTRIBUTE7%TYPE;
2455: l_attribute8 OKC_K_ARTICLES_B.ATTRIBUTE8%TYPE;
2456: l_attribute9 OKC_K_ARTICLES_B.ATTRIBUTE9%TYPE;
2457: l_attribute10 OKC_K_ARTICLES_B.ATTRIBUTE10%TYPE;
2458: l_attribute11 OKC_K_ARTICLES_B.ATTRIBUTE11%TYPE;
2459: l_attribute12 OKC_K_ARTICLES_B.ATTRIBUTE12%TYPE;
2460: l_attribute13 OKC_K_ARTICLES_B.ATTRIBUTE13%TYPE;
2461: l_attribute14 OKC_K_ARTICLES_B.ATTRIBUTE14%TYPE;
2454: l_attribute7 OKC_K_ARTICLES_B.ATTRIBUTE7%TYPE;
2455: l_attribute8 OKC_K_ARTICLES_B.ATTRIBUTE8%TYPE;
2456: l_attribute9 OKC_K_ARTICLES_B.ATTRIBUTE9%TYPE;
2457: l_attribute10 OKC_K_ARTICLES_B.ATTRIBUTE10%TYPE;
2458: l_attribute11 OKC_K_ARTICLES_B.ATTRIBUTE11%TYPE;
2459: l_attribute12 OKC_K_ARTICLES_B.ATTRIBUTE12%TYPE;
2460: l_attribute13 OKC_K_ARTICLES_B.ATTRIBUTE13%TYPE;
2461: l_attribute14 OKC_K_ARTICLES_B.ATTRIBUTE14%TYPE;
2462: l_attribute15 OKC_K_ARTICLES_B.ATTRIBUTE15%TYPE;
2455: l_attribute8 OKC_K_ARTICLES_B.ATTRIBUTE8%TYPE;
2456: l_attribute9 OKC_K_ARTICLES_B.ATTRIBUTE9%TYPE;
2457: l_attribute10 OKC_K_ARTICLES_B.ATTRIBUTE10%TYPE;
2458: l_attribute11 OKC_K_ARTICLES_B.ATTRIBUTE11%TYPE;
2459: l_attribute12 OKC_K_ARTICLES_B.ATTRIBUTE12%TYPE;
2460: l_attribute13 OKC_K_ARTICLES_B.ATTRIBUTE13%TYPE;
2461: l_attribute14 OKC_K_ARTICLES_B.ATTRIBUTE14%TYPE;
2462: l_attribute15 OKC_K_ARTICLES_B.ATTRIBUTE15%TYPE;
2463: l_print_text_yn OKC_K_ARTICLES_B.print_text_yn%TYPE;
2456: l_attribute9 OKC_K_ARTICLES_B.ATTRIBUTE9%TYPE;
2457: l_attribute10 OKC_K_ARTICLES_B.ATTRIBUTE10%TYPE;
2458: l_attribute11 OKC_K_ARTICLES_B.ATTRIBUTE11%TYPE;
2459: l_attribute12 OKC_K_ARTICLES_B.ATTRIBUTE12%TYPE;
2460: l_attribute13 OKC_K_ARTICLES_B.ATTRIBUTE13%TYPE;
2461: l_attribute14 OKC_K_ARTICLES_B.ATTRIBUTE14%TYPE;
2462: l_attribute15 OKC_K_ARTICLES_B.ATTRIBUTE15%TYPE;
2463: l_print_text_yn OKC_K_ARTICLES_B.print_text_yn%TYPE;
2464: l_summary_amend_operation_code OKC_K_ARTICLES_B.summary_amend_operation_code%TYPE;
2457: l_attribute10 OKC_K_ARTICLES_B.ATTRIBUTE10%TYPE;
2458: l_attribute11 OKC_K_ARTICLES_B.ATTRIBUTE11%TYPE;
2459: l_attribute12 OKC_K_ARTICLES_B.ATTRIBUTE12%TYPE;
2460: l_attribute13 OKC_K_ARTICLES_B.ATTRIBUTE13%TYPE;
2461: l_attribute14 OKC_K_ARTICLES_B.ATTRIBUTE14%TYPE;
2462: l_attribute15 OKC_K_ARTICLES_B.ATTRIBUTE15%TYPE;
2463: l_print_text_yn OKC_K_ARTICLES_B.print_text_yn%TYPE;
2464: l_summary_amend_operation_code OKC_K_ARTICLES_B.summary_amend_operation_code%TYPE;
2465: l_ref_article_id OKC_K_ARTICLES_B.ref_article_id%TYPE;
2458: l_attribute11 OKC_K_ARTICLES_B.ATTRIBUTE11%TYPE;
2459: l_attribute12 OKC_K_ARTICLES_B.ATTRIBUTE12%TYPE;
2460: l_attribute13 OKC_K_ARTICLES_B.ATTRIBUTE13%TYPE;
2461: l_attribute14 OKC_K_ARTICLES_B.ATTRIBUTE14%TYPE;
2462: l_attribute15 OKC_K_ARTICLES_B.ATTRIBUTE15%TYPE;
2463: l_print_text_yn OKC_K_ARTICLES_B.print_text_yn%TYPE;
2464: l_summary_amend_operation_code OKC_K_ARTICLES_B.summary_amend_operation_code%TYPE;
2465: l_ref_article_id OKC_K_ARTICLES_B.ref_article_id%TYPE;
2466: l_ref_article_version_id OKC_K_ARTICLES_B.ref_article_version_id%TYPE;
2459: l_attribute12 OKC_K_ARTICLES_B.ATTRIBUTE12%TYPE;
2460: l_attribute13 OKC_K_ARTICLES_B.ATTRIBUTE13%TYPE;
2461: l_attribute14 OKC_K_ARTICLES_B.ATTRIBUTE14%TYPE;
2462: l_attribute15 OKC_K_ARTICLES_B.ATTRIBUTE15%TYPE;
2463: l_print_text_yn OKC_K_ARTICLES_B.print_text_yn%TYPE;
2464: l_summary_amend_operation_code OKC_K_ARTICLES_B.summary_amend_operation_code%TYPE;
2465: l_ref_article_id OKC_K_ARTICLES_B.ref_article_id%TYPE;
2466: l_ref_article_version_id OKC_K_ARTICLES_B.ref_article_version_id%TYPE;
2467: l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;
2460: l_attribute13 OKC_K_ARTICLES_B.ATTRIBUTE13%TYPE;
2461: l_attribute14 OKC_K_ARTICLES_B.ATTRIBUTE14%TYPE;
2462: l_attribute15 OKC_K_ARTICLES_B.ATTRIBUTE15%TYPE;
2463: l_print_text_yn OKC_K_ARTICLES_B.print_text_yn%TYPE;
2464: l_summary_amend_operation_code OKC_K_ARTICLES_B.summary_amend_operation_code%TYPE;
2465: l_ref_article_id OKC_K_ARTICLES_B.ref_article_id%TYPE;
2466: l_ref_article_version_id OKC_K_ARTICLES_B.ref_article_version_id%TYPE;
2467: l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;
2468: l_created_by OKC_K_ARTICLES_B.CREATED_BY%TYPE;
2461: l_attribute14 OKC_K_ARTICLES_B.ATTRIBUTE14%TYPE;
2462: l_attribute15 OKC_K_ARTICLES_B.ATTRIBUTE15%TYPE;
2463: l_print_text_yn OKC_K_ARTICLES_B.print_text_yn%TYPE;
2464: l_summary_amend_operation_code OKC_K_ARTICLES_B.summary_amend_operation_code%TYPE;
2465: l_ref_article_id OKC_K_ARTICLES_B.ref_article_id%TYPE;
2466: l_ref_article_version_id OKC_K_ARTICLES_B.ref_article_version_id%TYPE;
2467: l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;
2468: l_created_by OKC_K_ARTICLES_B.CREATED_BY%TYPE;
2469: l_creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE;
2462: l_attribute15 OKC_K_ARTICLES_B.ATTRIBUTE15%TYPE;
2463: l_print_text_yn OKC_K_ARTICLES_B.print_text_yn%TYPE;
2464: l_summary_amend_operation_code OKC_K_ARTICLES_B.summary_amend_operation_code%TYPE;
2465: l_ref_article_id OKC_K_ARTICLES_B.ref_article_id%TYPE;
2466: l_ref_article_version_id OKC_K_ARTICLES_B.ref_article_version_id%TYPE;
2467: l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;
2468: l_created_by OKC_K_ARTICLES_B.CREATED_BY%TYPE;
2469: l_creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE;
2470: l_last_updated_by OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;
2463: l_print_text_yn OKC_K_ARTICLES_B.print_text_yn%TYPE;
2464: l_summary_amend_operation_code OKC_K_ARTICLES_B.summary_amend_operation_code%TYPE;
2465: l_ref_article_id OKC_K_ARTICLES_B.ref_article_id%TYPE;
2466: l_ref_article_version_id OKC_K_ARTICLES_B.ref_article_version_id%TYPE;
2467: l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;
2468: l_created_by OKC_K_ARTICLES_B.CREATED_BY%TYPE;
2469: l_creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE;
2470: l_last_updated_by OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;
2471: l_last_update_login OKC_K_ARTICLES_B.LAST_UPDATE_LOGIN%TYPE;
2464: l_summary_amend_operation_code OKC_K_ARTICLES_B.summary_amend_operation_code%TYPE;
2465: l_ref_article_id OKC_K_ARTICLES_B.ref_article_id%TYPE;
2466: l_ref_article_version_id OKC_K_ARTICLES_B.ref_article_version_id%TYPE;
2467: l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;
2468: l_created_by OKC_K_ARTICLES_B.CREATED_BY%TYPE;
2469: l_creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE;
2470: l_last_updated_by OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;
2471: l_last_update_login OKC_K_ARTICLES_B.LAST_UPDATE_LOGIN%TYPE;
2472: l_last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE;
2465: l_ref_article_id OKC_K_ARTICLES_B.ref_article_id%TYPE;
2466: l_ref_article_version_id OKC_K_ARTICLES_B.ref_article_version_id%TYPE;
2467: l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;
2468: l_created_by OKC_K_ARTICLES_B.CREATED_BY%TYPE;
2469: l_creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE;
2470: l_last_updated_by OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;
2471: l_last_update_login OKC_K_ARTICLES_B.LAST_UPDATE_LOGIN%TYPE;
2472: l_last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE;
2473: l_last_amended_by OKC_K_ARTICLES_B.LAST_AMENDED_BY%TYPE;
2466: l_ref_article_version_id OKC_K_ARTICLES_B.ref_article_version_id%TYPE;
2467: l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;
2468: l_created_by OKC_K_ARTICLES_B.CREATED_BY%TYPE;
2469: l_creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE;
2470: l_last_updated_by OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;
2471: l_last_update_login OKC_K_ARTICLES_B.LAST_UPDATE_LOGIN%TYPE;
2472: l_last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE;
2473: l_last_amended_by OKC_K_ARTICLES_B.LAST_AMENDED_BY%TYPE;
2474: l_last_amendment_date OKC_K_ARTICLES_B.LAST_AMENDMENT_DATE%TYPE;
2467: l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;
2468: l_created_by OKC_K_ARTICLES_B.CREATED_BY%TYPE;
2469: l_creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE;
2470: l_last_updated_by OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;
2471: l_last_update_login OKC_K_ARTICLES_B.LAST_UPDATE_LOGIN%TYPE;
2472: l_last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE;
2473: l_last_amended_by OKC_K_ARTICLES_B.LAST_AMENDED_BY%TYPE;
2474: l_last_amendment_date OKC_K_ARTICLES_B.LAST_AMENDMENT_DATE%TYPE;
2475:
2468: l_created_by OKC_K_ARTICLES_B.CREATED_BY%TYPE;
2469: l_creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE;
2470: l_last_updated_by OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;
2471: l_last_update_login OKC_K_ARTICLES_B.LAST_UPDATE_LOGIN%TYPE;
2472: l_last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE;
2473: l_last_amended_by OKC_K_ARTICLES_B.LAST_AMENDED_BY%TYPE;
2474: l_last_amendment_date OKC_K_ARTICLES_B.LAST_AMENDMENT_DATE%TYPE;
2475:
2476: BEGIN
2469: l_creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE;
2470: l_last_updated_by OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;
2471: l_last_update_login OKC_K_ARTICLES_B.LAST_UPDATE_LOGIN%TYPE;
2472: l_last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE;
2473: l_last_amended_by OKC_K_ARTICLES_B.LAST_AMENDED_BY%TYPE;
2474: l_last_amendment_date OKC_K_ARTICLES_B.LAST_AMENDMENT_DATE%TYPE;
2475:
2476: BEGIN
2477:
2470: l_last_updated_by OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;
2471: l_last_update_login OKC_K_ARTICLES_B.LAST_UPDATE_LOGIN%TYPE;
2472: l_last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE;
2473: l_last_amended_by OKC_K_ARTICLES_B.LAST_AMENDED_BY%TYPE;
2474: l_last_amendment_date OKC_K_ARTICLES_B.LAST_AMENDMENT_DATE%TYPE;
2475:
2476: BEGIN
2477:
2478: IF (l_debug = 'Y') THEN
2751: ---------------------------------------------------------------------------
2752: -- PROCEDURE Delete_Row
2753: ---------------------------------------------------------------------------
2754: -------------------------------------
2755: -- Delete_Row for:OKC_K_ARTICLES_B --
2756: -------------------------------------
2757: FUNCTION Delete_Row(
2758: p_id IN NUMBER
2759: ) RETURN VARCHAR2 IS
2763: IF (l_debug = 'Y') THEN
2764: Okc_Debug.Log('6100: Entered Delete_Row', 2);
2765: END IF;
2766:
2767: DELETE FROM OKC_K_ARTICLES_B WHERE ID = p_ID;
2768:
2769: IF (l_debug = 'Y') THEN
2770: Okc_Debug.Log('6200: Leaving Delete_Row', 2);
2771: END IF;
2789: RETURN( G_RET_STS_UNEXP_ERROR );
2790:
2791: END Delete_Row;
2792: -------------------------------------
2793: -- Delete_Row for:OKC_K_ARTICLES_B --
2794: -------------------------------------
2795: PROCEDURE Delete_Row(
2796: x_return_status OUT NOCOPY VARCHAR2,
2797: p_id IN NUMBER,
2809: CURSOR l_art_csr (cp_id IN NUMBER) IS
2810: SELECT art.standard_yn,
2811: kart.sav_sae_id,
2812: kart.article_version_id
2813: FROM okc_k_articles_b kart,
2814: okc_articles_all art
2815: WHERE kart.id = cp_id
2816: AND art.article_id = kart.sav_sae_id;
2817:
2816: AND art.article_id = kart.sav_sae_id;
2817:
2818: CURSOR l_non_std_exists_csr(cp_article_version_id IN NUMBER) IS
2819: SELECT 'Y'
2820: FROM okc_k_articles_b
2821: WHERE article_version_id = cp_article_version_id
2822: UNION ALL
2823: SELECT 'Y'
2824: FROM OKC_K_ARTICLES_BH
2820: FROM okc_k_articles_b
2821: WHERE article_version_id = cp_article_version_id
2822: UNION ALL
2823: SELECT 'Y'
2824: FROM OKC_K_ARTICLES_BH
2825: WHERE article_version_id = cp_article_version_id;
2826:
2827: BEGIN
2828:
2921: p_scn_id IN NUMBER
2922: ) IS
2923: CURSOR lock_csr IS
2924: SELECT rowid
2925: FROM OKC_K_ARTICLES_B
2926: WHERE SCN_ID=P_SCN_ID
2927: FOR UPDATE NOWAIT;
2928: BEGIN
2929: IF (l_debug = 'Y') THEN
2933: -- making OPEN/CLOSE cursor to lock records
2934: OPEN lock_csr;
2935: CLOSE lock_csr;
2936:
2937: DELETE FROM OKC_K_ARTICLES_B
2938: WHERE SCN_ID=P_SCN_ID;
2939:
2940: IF (l_debug = 'Y') THEN
2941: Okc_Debug.Log('11000: Leaving Delete_set', 2);
2998: ,p_retain_lock_terms_yn IN VARCHAR2 := 'N'
2999: ) IS
3000: CURSOR lock_csr IS
3001: SELECT rowid
3002: FROM OKC_K_ARTICLES_B
3003: WHERE DOCUMENT_TYPE=p_doc_type
3004: AND DOCUMENT_ID = p_doc_id
3005: AND (( p_retain_lock_terms_yn = 'N')
3006: OR
3018: -- making OPEN/CLOSE cursor to lock records
3019: OPEN lock_csr;
3020: CLOSE lock_csr;
3021:
3022: DELETE FROM OKC_K_ARTICLES_B
3023: WHERE DOCUMENT_TYPE=p_doc_type
3024: AND DOCUMENT_ID = p_doc_id
3025: AND (( p_retain_lock_terms_yn = 'N')
3026: OR
3100: CURSOR non_std_csr IS
3101: SELECT KART.ID,
3102: KART.SAV_SAE_ID,
3103: KART.ARTICLE_VERSION_ID
3104: FROM OKC_K_ARTICLES_B KART,
3105: OKC_ARTICLES_ALL ART
3106: WHERE KART.document_type = p_doc_type
3107: AND KART.document_id = p_doc_id
3108: AND KART.SAV_SAE_ID = ART.ARTICLE_ID
3116:
3117: -----------------------------------------
3118: -- Saving Base Table
3119: -----------------------------------------
3120: INSERT INTO OKC_K_ARTICLES_BH (
3121: major_version,
3122: ID,
3123: SAV_SAE_ID,
3124: SAV_SAV_RELEASE,
3228: ORIG_ARTICLE_ID,
3229: LAST_AMENDED_BY,
3230: LAST_AMENDMENT_DATE,
3231: MANDATORY_RWA
3232: FROM OKC_K_ARTICLES_B
3233: WHERE document_type = p_doc_type
3234: AND document_id = p_doc_id;
3235:
3236: IF (l_debug = 'Y') THEN
3262: RAISE FND_API.G_EXC_ERROR;
3263: END IF;
3264:
3265: IF (l_debug = 'Y') THEN
3266: Okc_Debug.Log('6920: Before updating new Non-Std in the OKC_K_ARTICLES_B', 2);
3267: END IF;
3268:
3269:
3270: -----------------------------------------
3267: END IF;
3268:
3269:
3270: -----------------------------------------
3271: -- Updating OKC_K_ARTICLES_B
3272: -----------------------------------------
3273: UPDATE OKC_K_ARTICLES_B
3274: SET SAV_SAE_ID = l_article_id,
3275: ARTICLE_VERSION_ID = l_article_version_id
3269:
3270: -----------------------------------------
3271: -- Updating OKC_K_ARTICLES_B
3272: -----------------------------------------
3273: UPDATE OKC_K_ARTICLES_B
3274: SET SAV_SAE_ID = l_article_id,
3275: ARTICLE_VERSION_ID = l_article_version_id
3276: WHERE ID = rec.id;
3277:
3275: ARTICLE_VERSION_ID = l_article_version_id
3276: WHERE ID = rec.id;
3277:
3278: IF (l_debug = 'Y') THEN
3279: Okc_Debug.Log('6930: After Updating Non-Std in OKC_K_ARTICLES_B', 2);
3280: END IF;
3281:
3282: END LOOP;
3283:
3347:
3348: -----------------------------------------
3349: -- Restoring Base Table
3350: -----------------------------------------
3351: INSERT INTO OKC_K_ARTICLES_B (
3352: ID,
3353: SAV_SAE_ID,
3354: SAV_SAV_RELEASE,
3355: SBT_CODE,
3457: ORIG_ARTICLE_ID,
3458: LAST_AMENDED_BY,
3459: LAST_AMENDMENT_DATE,
3460: MANDATORY_RWA
3461: FROM OKC_K_ARTICLES_BH
3462: WHERE document_type = p_doc_type
3463: AND document_id = p_doc_id
3464: AND major_version = p_major_version;
3465:
3505: -----------------------------------------
3506: -- Restoring Base Table
3507: -----------------------------------------
3508: DELETE
3509: FROM OKC_K_ARTICLES_BH
3510: WHERE document_type = p_doc_type
3511: AND document_id = p_doc_id
3512: AND major_version = p_major_version;
3513: