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_K_ARTICLES_PVT dependencies on OKC_K_ARTICLES_B

Line 64: SELECT OKC_K_ARTICLES_B_S.NEXTVAL FROM DUAL;

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;

Line 106: -- FUNCTION get_rec for: OKC_K_ARTICLES_B

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,

Line 157: CURSOR OKC_K_ARTICLES_B_pk_csr (cp_id IN NUMBER) IS

153: x_last_amended_by OUT NOCOPY NUMBER,
154: x_last_amendment_date OUT NOCOPY DATE
155:
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,

Line 203: FROM OKC_K_ARTICLES_B t

199: LAST_UPDATE_LOGIN,
200: LAST_UPDATE_DATE,
201: LAST_AMENDED_BY,
202: LAST_AMENDMENT_DATE
203: FROM OKC_K_ARTICLES_B t
204: WHERE t.ID = cp_id;
205: CURSOR OKC_K_ARTICLES_BH_pk_csr (cp_id IN NUMBER, cp_major_version VARCHAR2) IS
206: SELECT
207: SAV_SAE_ID,

Line 205: CURSOR OKC_K_ARTICLES_BH_pk_csr (cp_id IN NUMBER, cp_major_version VARCHAR2) IS

201: LAST_AMENDED_BY,
202: LAST_AMENDMENT_DATE
203: FROM OKC_K_ARTICLES_B t
204: WHERE t.ID = cp_id;
205: CURSOR OKC_K_ARTICLES_BH_pk_csr (cp_id IN NUMBER, cp_major_version VARCHAR2) IS
206: SELECT
207: SAV_SAE_ID,
208: DOCUMENT_TYPE,
209: DOCUMENT_ID,

Line 251: FROM OKC_K_ARTICLES_BH t

247: LAST_UPDATE_LOGIN,
248: LAST_UPDATE_DATE,
249: LAST_AMENDED_BY,
250: LAST_AMENDMENT_DATE
251: FROM OKC_K_ARTICLES_BH t
252: WHERE t.ID = cp_id and major_version=cp_major_version;
253: BEGIN
254:
255: IF (l_debug = 'Y') THEN

Line 265: OPEN OKC_K_ARTICLES_B_pk_csr (p_id);

261: Okc_Debug.Log('401: Get current database values', 2);
262: END IF;
263:
264: -- Get current database values
265: OPEN OKC_K_ARTICLES_B_pk_csr (p_id);
266: FETCH OKC_K_ARTICLES_B_pk_csr INTO
267: x_sav_sae_id,
268: x_document_type,
269: x_document_id,

Line 266: FETCH OKC_K_ARTICLES_B_pk_csr INTO

262: END IF;
263:
264: -- Get current database values
265: OPEN OKC_K_ARTICLES_B_pk_csr (p_id);
266: FETCH OKC_K_ARTICLES_B_pk_csr INTO
267: x_sav_sae_id,
268: x_document_type,
269: x_document_id,
270: x_cle_id,

Line 311: IF OKC_K_ARTICLES_B_pk_csr%NOTFOUND THEN

307: x_last_update_login,
308: x_last_update_date,
309: x_last_amended_by,
310: x_last_amendment_date;
311: IF OKC_K_ARTICLES_B_pk_csr%NOTFOUND THEN
312: Okc_Api.Set_Message(G_APP_NAME,G_LOCK_RECORD_DELETED,
313: 'ENTITYNAME','OKC_K_ARTICLES_B',
314: 'PKEY',p_id,
315: 'OVN',p_major_version

Line 313: 'ENTITYNAME','OKC_K_ARTICLES_B',

309: x_last_amended_by,
310: x_last_amendment_date;
311: IF OKC_K_ARTICLES_B_pk_csr%NOTFOUND THEN
312: Okc_Api.Set_Message(G_APP_NAME,G_LOCK_RECORD_DELETED,
313: 'ENTITYNAME','OKC_K_ARTICLES_B',
314: 'PKEY',p_id,
315: 'OVN',p_major_version
316: );
317: RAISE NO_DATA_FOUND;

Line 319: CLOSE OKC_K_ARTICLES_B_pk_csr;

315: 'OVN',p_major_version
316: );
317: RAISE NO_DATA_FOUND;
318: END IF;
319: CLOSE OKC_K_ARTICLES_B_pk_csr;
320: ELSE
321: IF (l_debug = 'Y') THEN
322: Okc_Debug.Log('402: Get history database values', 2);
323: END IF;

Line 326: OPEN OKC_K_ARTICLES_BH_pk_csr (p_id, p_major_version);

322: Okc_Debug.Log('402: Get history database values', 2);
323: END IF;
324:
325: -- Get history database values
326: OPEN OKC_K_ARTICLES_BH_pk_csr (p_id, p_major_version);
327: FETCH OKC_K_ARTICLES_BH_pk_csr INTO
328: x_sav_sae_id,
329: x_document_type,
330: x_document_id,

Line 327: FETCH OKC_K_ARTICLES_BH_pk_csr INTO

323: END IF;
324:
325: -- Get history database values
326: OPEN OKC_K_ARTICLES_BH_pk_csr (p_id, p_major_version);
327: FETCH OKC_K_ARTICLES_BH_pk_csr INTO
328: x_sav_sae_id,
329: x_document_type,
330: x_document_id,
331: x_cle_id,

Line 372: IF OKC_K_ARTICLES_BH_pk_csr%NOTFOUND THEN

368: x_last_update_login,
369: x_last_update_date,
370: x_last_amended_by,
371: x_last_amendment_date;
372: IF OKC_K_ARTICLES_BH_pk_csr%NOTFOUND THEN
373: Okc_Api.Set_Message(G_APP_NAME,G_LOCK_RECORD_DELETED,
374: 'ENTITYNAME','OKC_K_ARTICLES_BH',
375: 'PKEY',p_id,
376: 'OVN',p_major_version

Line 374: 'ENTITYNAME','OKC_K_ARTICLES_BH',

370: x_last_amended_by,
371: x_last_amendment_date;
372: IF OKC_K_ARTICLES_BH_pk_csr%NOTFOUND THEN
373: Okc_Api.Set_Message(G_APP_NAME,G_LOCK_RECORD_DELETED,
374: 'ENTITYNAME','OKC_K_ARTICLES_BH',
375: 'PKEY',p_id,
376: 'OVN',p_major_version
377: );
378: RAISE NO_DATA_FOUND;

Line 380: CLOSE OKC_K_ARTICLES_BH_pk_csr;

376: 'OVN',p_major_version
377: );
378: RAISE NO_DATA_FOUND;
379: END IF;
380: CLOSE OKC_K_ARTICLES_BH_pk_csr;
381: END IF;
382:
383: IF (l_debug = 'Y') THEN
384: Okc_Debug.Log('500: Leaving get_rec ', 2);

Line 397: -- 'ENTITYNAME','OKC_K_ARTICLES_BH',

393: END IF;
394:
395: -- moved upper where an exception is raised
396: -- Okc_Api.Set_Message(G_APP_NAME,G_LOCK_RECORD_DELETED,
397: -- 'ENTITYNAME','OKC_K_ARTICLES_BH',
398: -- 'PKEY',p_id,
399: -- 'OVN',p_major_version
400: -- );
401:

Line 402: IF OKC_K_ARTICLES_B_pk_csr%ISOPEN THEN

398: -- 'PKEY',p_id,
399: -- 'OVN',p_major_version
400: -- );
401:
402: IF OKC_K_ARTICLES_B_pk_csr%ISOPEN THEN
403: CLOSE OKC_K_ARTICLES_B_pk_csr;
404: END IF;
405:
406: IF OKC_K_ARTICLES_BH_pk_csr%ISOPEN THEN

Line 403: CLOSE OKC_K_ARTICLES_B_pk_csr;

399: -- 'OVN',p_major_version
400: -- );
401:
402: IF OKC_K_ARTICLES_B_pk_csr%ISOPEN THEN
403: CLOSE OKC_K_ARTICLES_B_pk_csr;
404: END IF;
405:
406: IF OKC_K_ARTICLES_BH_pk_csr%ISOPEN THEN
407: CLOSE OKC_K_ARTICLES_BH_pk_csr;

Line 406: IF OKC_K_ARTICLES_BH_pk_csr%ISOPEN THEN

402: IF OKC_K_ARTICLES_B_pk_csr%ISOPEN THEN
403: CLOSE OKC_K_ARTICLES_B_pk_csr;
404: END IF;
405:
406: IF OKC_K_ARTICLES_BH_pk_csr%ISOPEN THEN
407: CLOSE OKC_K_ARTICLES_BH_pk_csr;
408: END IF;
409:
410: RETURN G_RET_STS_ERROR ;

Line 407: CLOSE OKC_K_ARTICLES_BH_pk_csr;

403: CLOSE OKC_K_ARTICLES_B_pk_csr;
404: END IF;
405:
406: IF OKC_K_ARTICLES_BH_pk_csr%ISOPEN THEN
407: CLOSE OKC_K_ARTICLES_BH_pk_csr;
408: END IF;
409:
410: RETURN G_RET_STS_ERROR ;
411:

Line 425: IF OKC_K_ARTICLES_B_pk_csr%ISOPEN THEN

421: p_token1_value => sqlcode,
422: p_token2 => G_SQLERRM_TOKEN,
423: p_token2_value => sqlerrm);
424:
425: IF OKC_K_ARTICLES_B_pk_csr%ISOPEN THEN
426: CLOSE OKC_K_ARTICLES_B_pk_csr;
427: END IF;
428:
429: RETURN G_RET_STS_UNEXP_ERROR ;

Line 426: CLOSE OKC_K_ARTICLES_B_pk_csr;

422: p_token2 => G_SQLERRM_TOKEN,
423: p_token2_value => sqlerrm);
424:
425: IF OKC_K_ARTICLES_B_pk_csr%ISOPEN THEN
426: CLOSE OKC_K_ARTICLES_B_pk_csr;
427: END IF;
428:
429: RETURN G_RET_STS_UNEXP_ERROR ;
430:

Line 434: -- Set_Attributes for:OKC_K_ARTICLES_B --

430:
431: END Get_Rec;
432:
433: -----------------------------------------
434: -- Set_Attributes for:OKC_K_ARTICLES_B --
435: -----------------------------------------
436: FUNCTION Set_Attributes(
437: p_id IN NUMBER,
438: p_sav_sae_id IN NUMBER,

Line 519: l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;

515: x_last_amended_by OUT NOCOPY NUMBER,
516: x_last_amendment_date OUT NOCOPY DATE
517: ) RETURN VARCHAR2 IS
518: l_return_status VARCHAR2(1);
519: l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;
520: l_created_by OKC_K_ARTICLES_B.CREATED_BY%TYPE;
521: l_creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE;
522: l_last_updated_by OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;
523: l_last_update_login OKC_K_ARTICLES_B.LAST_UPDATE_LOGIN%TYPE;

Line 520: l_created_by OKC_K_ARTICLES_B.CREATED_BY%TYPE;

516: x_last_amendment_date OUT NOCOPY DATE
517: ) RETURN VARCHAR2 IS
518: l_return_status VARCHAR2(1);
519: l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;
520: l_created_by OKC_K_ARTICLES_B.CREATED_BY%TYPE;
521: l_creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE;
522: l_last_updated_by OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;
523: l_last_update_login OKC_K_ARTICLES_B.LAST_UPDATE_LOGIN%TYPE;
524: l_last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE;

Line 521: l_creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE;

517: ) RETURN VARCHAR2 IS
518: l_return_status VARCHAR2(1);
519: l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;
520: l_created_by OKC_K_ARTICLES_B.CREATED_BY%TYPE;
521: l_creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE;
522: l_last_updated_by OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;
523: l_last_update_login OKC_K_ARTICLES_B.LAST_UPDATE_LOGIN%TYPE;
524: l_last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE;
525: BEGIN

Line 522: l_last_updated_by OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;

518: l_return_status VARCHAR2(1);
519: l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;
520: l_created_by OKC_K_ARTICLES_B.CREATED_BY%TYPE;
521: l_creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE;
522: l_last_updated_by OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;
523: l_last_update_login OKC_K_ARTICLES_B.LAST_UPDATE_LOGIN%TYPE;
524: l_last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE;
525: BEGIN
526: IF( p_id IS NOT NULL ) THEN

Line 523: l_last_update_login OKC_K_ARTICLES_B.LAST_UPDATE_LOGIN%TYPE;

519: l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;
520: l_created_by OKC_K_ARTICLES_B.CREATED_BY%TYPE;
521: l_creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE;
522: l_last_updated_by OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;
523: l_last_update_login OKC_K_ARTICLES_B.LAST_UPDATE_LOGIN%TYPE;
524: l_last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE;
525: BEGIN
526: IF( p_id IS NOT NULL ) THEN
527: -- Get current database values

Line 524: l_last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE;

520: l_created_by OKC_K_ARTICLES_B.CREATED_BY%TYPE;
521: l_creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE;
522: l_last_updated_by OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;
523: l_last_update_login OKC_K_ARTICLES_B.LAST_UPDATE_LOGIN%TYPE;
524: l_last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE;
525: BEGIN
526: IF( p_id IS NOT NULL ) THEN
527: -- Get current database values
528: l_return_status := Get_Rec(

Line 822: -- End of Set_Attributes for:OKC_K_ARTICLES_B --

818: END IF;
819: RETURN G_RET_STS_SUCCESS ;
820: END;
821: -----------------------------------------
822: -- End of Set_Attributes for:OKC_K_ARTICLES_B --
823: -----------------------------------------
824:
825: ----------------------------------------------
826: -- Validate_Attributes for: OKC_K_ARTICLES_B --

Line 826: -- Validate_Attributes for: OKC_K_ARTICLES_B --

822: -- End of Set_Attributes for:OKC_K_ARTICLES_B --
823: -----------------------------------------
824:
825: ----------------------------------------------
826: -- Validate_Attributes for: OKC_K_ARTICLES_B --
827: ----------------------------------------------
828: FUNCTION Validate_Attributes (
829: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
830:

Line 1190: -- Validate_Record for:OKC_K_ARTICLES_B --

1186: -- PROCEDURE Validate_Record
1187: -- It calls Item Level Validations and then makes Record Level Validations
1188: ---------------------------------------------------------------------------
1189: ------------------------------------------
1190: -- Validate_Record for:OKC_K_ARTICLES_B --
1191: ------------------------------------------
1192: FUNCTION Validate_Record (
1193: p_validation_level IN NUMBER,
1194: p_id IN NUMBER,

Line 1352: -- validate_row for:OKC_K_ARTICLES_B --

1348: ---------------------------------------------------------------------------
1349: -- PROCEDURE validate_row
1350: ---------------------------------------------------------------------------
1351: ---------------------------------------
1352: -- validate_row for:OKC_K_ARTICLES_B --
1353: ---------------------------------------
1354: PROCEDURE validate_row(
1355: p_validation_level IN NUMBER,
1356: x_return_status OUT NOCOPY VARCHAR2,

Line 1396: l_sav_sae_id OKC_K_ARTICLES_B.SAV_SAE_ID%TYPE;

1392: p_ref_article_id IN NUMBER,
1393: p_ref_article_version_id IN NUMBER,
1394: p_object_version_number IN NUMBER
1395: ) IS
1396: l_sav_sae_id OKC_K_ARTICLES_B.SAV_SAE_ID%TYPE;
1397: l_document_type OKC_K_ARTICLES_B.DOCUMENT_TYPE%TYPE;
1398: l_document_id OKC_K_ARTICLES_B.DOCUMENT_ID%TYPE;
1399: l_cle_id OKC_K_ARTICLES_B.CLE_ID%TYPE;
1400: l_source_flag OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE;

Line 1397: l_document_type OKC_K_ARTICLES_B.DOCUMENT_TYPE%TYPE;

1393: p_ref_article_version_id IN NUMBER,
1394: p_object_version_number IN NUMBER
1395: ) IS
1396: l_sav_sae_id OKC_K_ARTICLES_B.SAV_SAE_ID%TYPE;
1397: l_document_type OKC_K_ARTICLES_B.DOCUMENT_TYPE%TYPE;
1398: l_document_id OKC_K_ARTICLES_B.DOCUMENT_ID%TYPE;
1399: l_cle_id OKC_K_ARTICLES_B.CLE_ID%TYPE;
1400: l_source_flag OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE;
1401: l_mandatory_yn OKC_K_ARTICLES_B.MANDATORY_YN%TYPE;

Line 1398: l_document_id OKC_K_ARTICLES_B.DOCUMENT_ID%TYPE;

1394: p_object_version_number IN NUMBER
1395: ) IS
1396: l_sav_sae_id OKC_K_ARTICLES_B.SAV_SAE_ID%TYPE;
1397: l_document_type OKC_K_ARTICLES_B.DOCUMENT_TYPE%TYPE;
1398: l_document_id OKC_K_ARTICLES_B.DOCUMENT_ID%TYPE;
1399: l_cle_id OKC_K_ARTICLES_B.CLE_ID%TYPE;
1400: l_source_flag OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE;
1401: l_mandatory_yn OKC_K_ARTICLES_B.MANDATORY_YN%TYPE;
1402: l_scn_id OKC_K_ARTICLES_B.SCN_ID%TYPE;

Line 1399: l_cle_id OKC_K_ARTICLES_B.CLE_ID%TYPE;

1395: ) IS
1396: l_sav_sae_id OKC_K_ARTICLES_B.SAV_SAE_ID%TYPE;
1397: l_document_type OKC_K_ARTICLES_B.DOCUMENT_TYPE%TYPE;
1398: l_document_id OKC_K_ARTICLES_B.DOCUMENT_ID%TYPE;
1399: l_cle_id OKC_K_ARTICLES_B.CLE_ID%TYPE;
1400: l_source_flag OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE;
1401: l_mandatory_yn OKC_K_ARTICLES_B.MANDATORY_YN%TYPE;
1402: l_scn_id OKC_K_ARTICLES_B.SCN_ID%TYPE;
1403: l_label OKC_K_ARTICLES_B.LABEL%TYPE;

Line 1400: l_source_flag OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE;

1396: l_sav_sae_id OKC_K_ARTICLES_B.SAV_SAE_ID%TYPE;
1397: l_document_type OKC_K_ARTICLES_B.DOCUMENT_TYPE%TYPE;
1398: l_document_id OKC_K_ARTICLES_B.DOCUMENT_ID%TYPE;
1399: l_cle_id OKC_K_ARTICLES_B.CLE_ID%TYPE;
1400: l_source_flag OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE;
1401: l_mandatory_yn OKC_K_ARTICLES_B.MANDATORY_YN%TYPE;
1402: l_scn_id OKC_K_ARTICLES_B.SCN_ID%TYPE;
1403: l_label OKC_K_ARTICLES_B.LABEL%TYPE;
1404: l_amendment_description OKC_K_ARTICLES_B.AMENDMENT_DESCRIPTION%TYPE;

Line 1401: l_mandatory_yn OKC_K_ARTICLES_B.MANDATORY_YN%TYPE;

1397: l_document_type OKC_K_ARTICLES_B.DOCUMENT_TYPE%TYPE;
1398: l_document_id OKC_K_ARTICLES_B.DOCUMENT_ID%TYPE;
1399: l_cle_id OKC_K_ARTICLES_B.CLE_ID%TYPE;
1400: l_source_flag OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE;
1401: l_mandatory_yn OKC_K_ARTICLES_B.MANDATORY_YN%TYPE;
1402: l_scn_id OKC_K_ARTICLES_B.SCN_ID%TYPE;
1403: l_label OKC_K_ARTICLES_B.LABEL%TYPE;
1404: l_amendment_description OKC_K_ARTICLES_B.AMENDMENT_DESCRIPTION%TYPE;
1405: l_amendment_operation_code OKC_K_ARTICLES_B.AMENDMENT_OPERATION_CODE%TYPE;

Line 1402: l_scn_id OKC_K_ARTICLES_B.SCN_ID%TYPE;

1398: l_document_id OKC_K_ARTICLES_B.DOCUMENT_ID%TYPE;
1399: l_cle_id OKC_K_ARTICLES_B.CLE_ID%TYPE;
1400: l_source_flag OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE;
1401: l_mandatory_yn OKC_K_ARTICLES_B.MANDATORY_YN%TYPE;
1402: l_scn_id OKC_K_ARTICLES_B.SCN_ID%TYPE;
1403: l_label OKC_K_ARTICLES_B.LABEL%TYPE;
1404: l_amendment_description OKC_K_ARTICLES_B.AMENDMENT_DESCRIPTION%TYPE;
1405: l_amendment_operation_code OKC_K_ARTICLES_B.AMENDMENT_OPERATION_CODE%TYPE;
1406: l_article_version_id OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE;

Line 1403: l_label OKC_K_ARTICLES_B.LABEL%TYPE;

1399: l_cle_id OKC_K_ARTICLES_B.CLE_ID%TYPE;
1400: l_source_flag OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE;
1401: l_mandatory_yn OKC_K_ARTICLES_B.MANDATORY_YN%TYPE;
1402: l_scn_id OKC_K_ARTICLES_B.SCN_ID%TYPE;
1403: l_label OKC_K_ARTICLES_B.LABEL%TYPE;
1404: l_amendment_description OKC_K_ARTICLES_B.AMENDMENT_DESCRIPTION%TYPE;
1405: l_amendment_operation_code OKC_K_ARTICLES_B.AMENDMENT_OPERATION_CODE%TYPE;
1406: l_article_version_id OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE;
1407: l_change_nonstd_yn OKC_K_ARTICLES_B.CHANGE_NONSTD_YN%TYPE;

Line 1404: l_amendment_description OKC_K_ARTICLES_B.AMENDMENT_DESCRIPTION%TYPE;

1400: l_source_flag OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE;
1401: l_mandatory_yn OKC_K_ARTICLES_B.MANDATORY_YN%TYPE;
1402: l_scn_id OKC_K_ARTICLES_B.SCN_ID%TYPE;
1403: l_label OKC_K_ARTICLES_B.LABEL%TYPE;
1404: l_amendment_description OKC_K_ARTICLES_B.AMENDMENT_DESCRIPTION%TYPE;
1405: l_amendment_operation_code OKC_K_ARTICLES_B.AMENDMENT_OPERATION_CODE%TYPE;
1406: l_article_version_id OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE;
1407: l_change_nonstd_yn OKC_K_ARTICLES_B.CHANGE_NONSTD_YN%TYPE;
1408: l_orig_system_reference_code OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_CODE%TYPE;

Line 1405: l_amendment_operation_code OKC_K_ARTICLES_B.AMENDMENT_OPERATION_CODE%TYPE;

1401: l_mandatory_yn OKC_K_ARTICLES_B.MANDATORY_YN%TYPE;
1402: l_scn_id OKC_K_ARTICLES_B.SCN_ID%TYPE;
1403: l_label OKC_K_ARTICLES_B.LABEL%TYPE;
1404: l_amendment_description OKC_K_ARTICLES_B.AMENDMENT_DESCRIPTION%TYPE;
1405: l_amendment_operation_code OKC_K_ARTICLES_B.AMENDMENT_OPERATION_CODE%TYPE;
1406: l_article_version_id OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE;
1407: l_change_nonstd_yn OKC_K_ARTICLES_B.CHANGE_NONSTD_YN%TYPE;
1408: l_orig_system_reference_code OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
1409: l_orig_system_reference_id1 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID1%TYPE;

Line 1406: l_article_version_id OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE;

1402: l_scn_id OKC_K_ARTICLES_B.SCN_ID%TYPE;
1403: l_label OKC_K_ARTICLES_B.LABEL%TYPE;
1404: l_amendment_description OKC_K_ARTICLES_B.AMENDMENT_DESCRIPTION%TYPE;
1405: l_amendment_operation_code OKC_K_ARTICLES_B.AMENDMENT_OPERATION_CODE%TYPE;
1406: l_article_version_id OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE;
1407: l_change_nonstd_yn OKC_K_ARTICLES_B.CHANGE_NONSTD_YN%TYPE;
1408: l_orig_system_reference_code OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
1409: l_orig_system_reference_id1 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
1410: l_orig_system_reference_id2 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID2%TYPE;

Line 1407: l_change_nonstd_yn OKC_K_ARTICLES_B.CHANGE_NONSTD_YN%TYPE;

1403: l_label OKC_K_ARTICLES_B.LABEL%TYPE;
1404: l_amendment_description OKC_K_ARTICLES_B.AMENDMENT_DESCRIPTION%TYPE;
1405: l_amendment_operation_code OKC_K_ARTICLES_B.AMENDMENT_OPERATION_CODE%TYPE;
1406: l_article_version_id OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE;
1407: l_change_nonstd_yn OKC_K_ARTICLES_B.CHANGE_NONSTD_YN%TYPE;
1408: l_orig_system_reference_code OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
1409: l_orig_system_reference_id1 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
1410: l_orig_system_reference_id2 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
1411: l_display_sequence OKC_K_ARTICLES_B.DISPLAY_SEQUENCE%TYPE;

Line 1408: l_orig_system_reference_code OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_CODE%TYPE;

1404: l_amendment_description OKC_K_ARTICLES_B.AMENDMENT_DESCRIPTION%TYPE;
1405: l_amendment_operation_code OKC_K_ARTICLES_B.AMENDMENT_OPERATION_CODE%TYPE;
1406: l_article_version_id OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE;
1407: l_change_nonstd_yn OKC_K_ARTICLES_B.CHANGE_NONSTD_YN%TYPE;
1408: l_orig_system_reference_code OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
1409: l_orig_system_reference_id1 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
1410: l_orig_system_reference_id2 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
1411: l_display_sequence OKC_K_ARTICLES_B.DISPLAY_SEQUENCE%TYPE;
1412: l_attribute_category OKC_K_ARTICLES_B.ATTRIBUTE_CATEGORY%TYPE;

Line 1409: l_orig_system_reference_id1 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID1%TYPE;

1405: l_amendment_operation_code OKC_K_ARTICLES_B.AMENDMENT_OPERATION_CODE%TYPE;
1406: l_article_version_id OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE;
1407: l_change_nonstd_yn OKC_K_ARTICLES_B.CHANGE_NONSTD_YN%TYPE;
1408: l_orig_system_reference_code OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
1409: l_orig_system_reference_id1 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
1410: l_orig_system_reference_id2 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
1411: l_display_sequence OKC_K_ARTICLES_B.DISPLAY_SEQUENCE%TYPE;
1412: l_attribute_category OKC_K_ARTICLES_B.ATTRIBUTE_CATEGORY%TYPE;
1413: l_attribute1 OKC_K_ARTICLES_B.ATTRIBUTE1%TYPE;

Line 1410: l_orig_system_reference_id2 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID2%TYPE;

1406: l_article_version_id OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE;
1407: l_change_nonstd_yn OKC_K_ARTICLES_B.CHANGE_NONSTD_YN%TYPE;
1408: l_orig_system_reference_code OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
1409: l_orig_system_reference_id1 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
1410: l_orig_system_reference_id2 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
1411: l_display_sequence OKC_K_ARTICLES_B.DISPLAY_SEQUENCE%TYPE;
1412: l_attribute_category OKC_K_ARTICLES_B.ATTRIBUTE_CATEGORY%TYPE;
1413: l_attribute1 OKC_K_ARTICLES_B.ATTRIBUTE1%TYPE;
1414: l_attribute2 OKC_K_ARTICLES_B.ATTRIBUTE2%TYPE;

Line 1411: l_display_sequence OKC_K_ARTICLES_B.DISPLAY_SEQUENCE%TYPE;

1407: l_change_nonstd_yn OKC_K_ARTICLES_B.CHANGE_NONSTD_YN%TYPE;
1408: l_orig_system_reference_code OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
1409: l_orig_system_reference_id1 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
1410: l_orig_system_reference_id2 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
1411: l_display_sequence OKC_K_ARTICLES_B.DISPLAY_SEQUENCE%TYPE;
1412: l_attribute_category OKC_K_ARTICLES_B.ATTRIBUTE_CATEGORY%TYPE;
1413: l_attribute1 OKC_K_ARTICLES_B.ATTRIBUTE1%TYPE;
1414: l_attribute2 OKC_K_ARTICLES_B.ATTRIBUTE2%TYPE;
1415: l_attribute3 OKC_K_ARTICLES_B.ATTRIBUTE3%TYPE;

Line 1412: l_attribute_category OKC_K_ARTICLES_B.ATTRIBUTE_CATEGORY%TYPE;

1408: l_orig_system_reference_code OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
1409: l_orig_system_reference_id1 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
1410: l_orig_system_reference_id2 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
1411: l_display_sequence OKC_K_ARTICLES_B.DISPLAY_SEQUENCE%TYPE;
1412: l_attribute_category OKC_K_ARTICLES_B.ATTRIBUTE_CATEGORY%TYPE;
1413: l_attribute1 OKC_K_ARTICLES_B.ATTRIBUTE1%TYPE;
1414: l_attribute2 OKC_K_ARTICLES_B.ATTRIBUTE2%TYPE;
1415: l_attribute3 OKC_K_ARTICLES_B.ATTRIBUTE3%TYPE;
1416: l_attribute4 OKC_K_ARTICLES_B.ATTRIBUTE4%TYPE;

Line 1413: l_attribute1 OKC_K_ARTICLES_B.ATTRIBUTE1%TYPE;

1409: l_orig_system_reference_id1 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
1410: l_orig_system_reference_id2 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
1411: l_display_sequence OKC_K_ARTICLES_B.DISPLAY_SEQUENCE%TYPE;
1412: l_attribute_category OKC_K_ARTICLES_B.ATTRIBUTE_CATEGORY%TYPE;
1413: l_attribute1 OKC_K_ARTICLES_B.ATTRIBUTE1%TYPE;
1414: l_attribute2 OKC_K_ARTICLES_B.ATTRIBUTE2%TYPE;
1415: l_attribute3 OKC_K_ARTICLES_B.ATTRIBUTE3%TYPE;
1416: l_attribute4 OKC_K_ARTICLES_B.ATTRIBUTE4%TYPE;
1417: l_attribute5 OKC_K_ARTICLES_B.ATTRIBUTE5%TYPE;

Line 1414: l_attribute2 OKC_K_ARTICLES_B.ATTRIBUTE2%TYPE;

1410: l_orig_system_reference_id2 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
1411: l_display_sequence OKC_K_ARTICLES_B.DISPLAY_SEQUENCE%TYPE;
1412: l_attribute_category OKC_K_ARTICLES_B.ATTRIBUTE_CATEGORY%TYPE;
1413: l_attribute1 OKC_K_ARTICLES_B.ATTRIBUTE1%TYPE;
1414: l_attribute2 OKC_K_ARTICLES_B.ATTRIBUTE2%TYPE;
1415: l_attribute3 OKC_K_ARTICLES_B.ATTRIBUTE3%TYPE;
1416: l_attribute4 OKC_K_ARTICLES_B.ATTRIBUTE4%TYPE;
1417: l_attribute5 OKC_K_ARTICLES_B.ATTRIBUTE5%TYPE;
1418: l_attribute6 OKC_K_ARTICLES_B.ATTRIBUTE6%TYPE;

Line 1415: l_attribute3 OKC_K_ARTICLES_B.ATTRIBUTE3%TYPE;

1411: l_display_sequence OKC_K_ARTICLES_B.DISPLAY_SEQUENCE%TYPE;
1412: l_attribute_category OKC_K_ARTICLES_B.ATTRIBUTE_CATEGORY%TYPE;
1413: l_attribute1 OKC_K_ARTICLES_B.ATTRIBUTE1%TYPE;
1414: l_attribute2 OKC_K_ARTICLES_B.ATTRIBUTE2%TYPE;
1415: l_attribute3 OKC_K_ARTICLES_B.ATTRIBUTE3%TYPE;
1416: l_attribute4 OKC_K_ARTICLES_B.ATTRIBUTE4%TYPE;
1417: l_attribute5 OKC_K_ARTICLES_B.ATTRIBUTE5%TYPE;
1418: l_attribute6 OKC_K_ARTICLES_B.ATTRIBUTE6%TYPE;
1419: l_attribute7 OKC_K_ARTICLES_B.ATTRIBUTE7%TYPE;

Line 1416: l_attribute4 OKC_K_ARTICLES_B.ATTRIBUTE4%TYPE;

1412: l_attribute_category OKC_K_ARTICLES_B.ATTRIBUTE_CATEGORY%TYPE;
1413: l_attribute1 OKC_K_ARTICLES_B.ATTRIBUTE1%TYPE;
1414: l_attribute2 OKC_K_ARTICLES_B.ATTRIBUTE2%TYPE;
1415: l_attribute3 OKC_K_ARTICLES_B.ATTRIBUTE3%TYPE;
1416: l_attribute4 OKC_K_ARTICLES_B.ATTRIBUTE4%TYPE;
1417: l_attribute5 OKC_K_ARTICLES_B.ATTRIBUTE5%TYPE;
1418: l_attribute6 OKC_K_ARTICLES_B.ATTRIBUTE6%TYPE;
1419: l_attribute7 OKC_K_ARTICLES_B.ATTRIBUTE7%TYPE;
1420: l_attribute8 OKC_K_ARTICLES_B.ATTRIBUTE8%TYPE;

Line 1417: l_attribute5 OKC_K_ARTICLES_B.ATTRIBUTE5%TYPE;

1413: l_attribute1 OKC_K_ARTICLES_B.ATTRIBUTE1%TYPE;
1414: l_attribute2 OKC_K_ARTICLES_B.ATTRIBUTE2%TYPE;
1415: l_attribute3 OKC_K_ARTICLES_B.ATTRIBUTE3%TYPE;
1416: l_attribute4 OKC_K_ARTICLES_B.ATTRIBUTE4%TYPE;
1417: l_attribute5 OKC_K_ARTICLES_B.ATTRIBUTE5%TYPE;
1418: l_attribute6 OKC_K_ARTICLES_B.ATTRIBUTE6%TYPE;
1419: l_attribute7 OKC_K_ARTICLES_B.ATTRIBUTE7%TYPE;
1420: l_attribute8 OKC_K_ARTICLES_B.ATTRIBUTE8%TYPE;
1421: l_attribute9 OKC_K_ARTICLES_B.ATTRIBUTE9%TYPE;

Line 1418: l_attribute6 OKC_K_ARTICLES_B.ATTRIBUTE6%TYPE;

1414: l_attribute2 OKC_K_ARTICLES_B.ATTRIBUTE2%TYPE;
1415: l_attribute3 OKC_K_ARTICLES_B.ATTRIBUTE3%TYPE;
1416: l_attribute4 OKC_K_ARTICLES_B.ATTRIBUTE4%TYPE;
1417: l_attribute5 OKC_K_ARTICLES_B.ATTRIBUTE5%TYPE;
1418: l_attribute6 OKC_K_ARTICLES_B.ATTRIBUTE6%TYPE;
1419: l_attribute7 OKC_K_ARTICLES_B.ATTRIBUTE7%TYPE;
1420: l_attribute8 OKC_K_ARTICLES_B.ATTRIBUTE8%TYPE;
1421: l_attribute9 OKC_K_ARTICLES_B.ATTRIBUTE9%TYPE;
1422: l_attribute10 OKC_K_ARTICLES_B.ATTRIBUTE10%TYPE;

Line 1419: l_attribute7 OKC_K_ARTICLES_B.ATTRIBUTE7%TYPE;

1415: l_attribute3 OKC_K_ARTICLES_B.ATTRIBUTE3%TYPE;
1416: l_attribute4 OKC_K_ARTICLES_B.ATTRIBUTE4%TYPE;
1417: l_attribute5 OKC_K_ARTICLES_B.ATTRIBUTE5%TYPE;
1418: l_attribute6 OKC_K_ARTICLES_B.ATTRIBUTE6%TYPE;
1419: l_attribute7 OKC_K_ARTICLES_B.ATTRIBUTE7%TYPE;
1420: l_attribute8 OKC_K_ARTICLES_B.ATTRIBUTE8%TYPE;
1421: l_attribute9 OKC_K_ARTICLES_B.ATTRIBUTE9%TYPE;
1422: l_attribute10 OKC_K_ARTICLES_B.ATTRIBUTE10%TYPE;
1423: l_attribute11 OKC_K_ARTICLES_B.ATTRIBUTE11%TYPE;

Line 1420: l_attribute8 OKC_K_ARTICLES_B.ATTRIBUTE8%TYPE;

1416: l_attribute4 OKC_K_ARTICLES_B.ATTRIBUTE4%TYPE;
1417: l_attribute5 OKC_K_ARTICLES_B.ATTRIBUTE5%TYPE;
1418: l_attribute6 OKC_K_ARTICLES_B.ATTRIBUTE6%TYPE;
1419: l_attribute7 OKC_K_ARTICLES_B.ATTRIBUTE7%TYPE;
1420: l_attribute8 OKC_K_ARTICLES_B.ATTRIBUTE8%TYPE;
1421: l_attribute9 OKC_K_ARTICLES_B.ATTRIBUTE9%TYPE;
1422: l_attribute10 OKC_K_ARTICLES_B.ATTRIBUTE10%TYPE;
1423: l_attribute11 OKC_K_ARTICLES_B.ATTRIBUTE11%TYPE;
1424: l_attribute12 OKC_K_ARTICLES_B.ATTRIBUTE12%TYPE;

Line 1421: l_attribute9 OKC_K_ARTICLES_B.ATTRIBUTE9%TYPE;

1417: l_attribute5 OKC_K_ARTICLES_B.ATTRIBUTE5%TYPE;
1418: l_attribute6 OKC_K_ARTICLES_B.ATTRIBUTE6%TYPE;
1419: l_attribute7 OKC_K_ARTICLES_B.ATTRIBUTE7%TYPE;
1420: l_attribute8 OKC_K_ARTICLES_B.ATTRIBUTE8%TYPE;
1421: l_attribute9 OKC_K_ARTICLES_B.ATTRIBUTE9%TYPE;
1422: l_attribute10 OKC_K_ARTICLES_B.ATTRIBUTE10%TYPE;
1423: l_attribute11 OKC_K_ARTICLES_B.ATTRIBUTE11%TYPE;
1424: l_attribute12 OKC_K_ARTICLES_B.ATTRIBUTE12%TYPE;
1425: l_attribute13 OKC_K_ARTICLES_B.ATTRIBUTE13%TYPE;

Line 1422: l_attribute10 OKC_K_ARTICLES_B.ATTRIBUTE10%TYPE;

1418: l_attribute6 OKC_K_ARTICLES_B.ATTRIBUTE6%TYPE;
1419: l_attribute7 OKC_K_ARTICLES_B.ATTRIBUTE7%TYPE;
1420: l_attribute8 OKC_K_ARTICLES_B.ATTRIBUTE8%TYPE;
1421: l_attribute9 OKC_K_ARTICLES_B.ATTRIBUTE9%TYPE;
1422: l_attribute10 OKC_K_ARTICLES_B.ATTRIBUTE10%TYPE;
1423: l_attribute11 OKC_K_ARTICLES_B.ATTRIBUTE11%TYPE;
1424: l_attribute12 OKC_K_ARTICLES_B.ATTRIBUTE12%TYPE;
1425: l_attribute13 OKC_K_ARTICLES_B.ATTRIBUTE13%TYPE;
1426: l_attribute14 OKC_K_ARTICLES_B.ATTRIBUTE14%TYPE;

Line 1423: l_attribute11 OKC_K_ARTICLES_B.ATTRIBUTE11%TYPE;

1419: l_attribute7 OKC_K_ARTICLES_B.ATTRIBUTE7%TYPE;
1420: l_attribute8 OKC_K_ARTICLES_B.ATTRIBUTE8%TYPE;
1421: l_attribute9 OKC_K_ARTICLES_B.ATTRIBUTE9%TYPE;
1422: l_attribute10 OKC_K_ARTICLES_B.ATTRIBUTE10%TYPE;
1423: l_attribute11 OKC_K_ARTICLES_B.ATTRIBUTE11%TYPE;
1424: l_attribute12 OKC_K_ARTICLES_B.ATTRIBUTE12%TYPE;
1425: l_attribute13 OKC_K_ARTICLES_B.ATTRIBUTE13%TYPE;
1426: l_attribute14 OKC_K_ARTICLES_B.ATTRIBUTE14%TYPE;
1427: l_attribute15 OKC_K_ARTICLES_B.ATTRIBUTE15%TYPE;

Line 1424: l_attribute12 OKC_K_ARTICLES_B.ATTRIBUTE12%TYPE;

1420: l_attribute8 OKC_K_ARTICLES_B.ATTRIBUTE8%TYPE;
1421: l_attribute9 OKC_K_ARTICLES_B.ATTRIBUTE9%TYPE;
1422: l_attribute10 OKC_K_ARTICLES_B.ATTRIBUTE10%TYPE;
1423: l_attribute11 OKC_K_ARTICLES_B.ATTRIBUTE11%TYPE;
1424: l_attribute12 OKC_K_ARTICLES_B.ATTRIBUTE12%TYPE;
1425: l_attribute13 OKC_K_ARTICLES_B.ATTRIBUTE13%TYPE;
1426: l_attribute14 OKC_K_ARTICLES_B.ATTRIBUTE14%TYPE;
1427: l_attribute15 OKC_K_ARTICLES_B.ATTRIBUTE15%TYPE;
1428: l_print_text_yn OKC_K_ARTICLES_B.print_text_yn%TYPE;

Line 1425: l_attribute13 OKC_K_ARTICLES_B.ATTRIBUTE13%TYPE;

1421: l_attribute9 OKC_K_ARTICLES_B.ATTRIBUTE9%TYPE;
1422: l_attribute10 OKC_K_ARTICLES_B.ATTRIBUTE10%TYPE;
1423: l_attribute11 OKC_K_ARTICLES_B.ATTRIBUTE11%TYPE;
1424: l_attribute12 OKC_K_ARTICLES_B.ATTRIBUTE12%TYPE;
1425: l_attribute13 OKC_K_ARTICLES_B.ATTRIBUTE13%TYPE;
1426: l_attribute14 OKC_K_ARTICLES_B.ATTRIBUTE14%TYPE;
1427: l_attribute15 OKC_K_ARTICLES_B.ATTRIBUTE15%TYPE;
1428: l_print_text_yn OKC_K_ARTICLES_B.print_text_yn%TYPE;
1429: l_summary_amend_operation_code OKC_K_ARTICLES_B.summary_amend_operation_code%TYPE;

Line 1426: l_attribute14 OKC_K_ARTICLES_B.ATTRIBUTE14%TYPE;

1422: l_attribute10 OKC_K_ARTICLES_B.ATTRIBUTE10%TYPE;
1423: l_attribute11 OKC_K_ARTICLES_B.ATTRIBUTE11%TYPE;
1424: l_attribute12 OKC_K_ARTICLES_B.ATTRIBUTE12%TYPE;
1425: l_attribute13 OKC_K_ARTICLES_B.ATTRIBUTE13%TYPE;
1426: l_attribute14 OKC_K_ARTICLES_B.ATTRIBUTE14%TYPE;
1427: l_attribute15 OKC_K_ARTICLES_B.ATTRIBUTE15%TYPE;
1428: l_print_text_yn OKC_K_ARTICLES_B.print_text_yn%TYPE;
1429: l_summary_amend_operation_code OKC_K_ARTICLES_B.summary_amend_operation_code%TYPE;
1430: l_ref_article_id OKC_K_ARTICLES_B.ref_article_id%TYPE;

Line 1427: l_attribute15 OKC_K_ARTICLES_B.ATTRIBUTE15%TYPE;

1423: l_attribute11 OKC_K_ARTICLES_B.ATTRIBUTE11%TYPE;
1424: l_attribute12 OKC_K_ARTICLES_B.ATTRIBUTE12%TYPE;
1425: l_attribute13 OKC_K_ARTICLES_B.ATTRIBUTE13%TYPE;
1426: l_attribute14 OKC_K_ARTICLES_B.ATTRIBUTE14%TYPE;
1427: l_attribute15 OKC_K_ARTICLES_B.ATTRIBUTE15%TYPE;
1428: l_print_text_yn OKC_K_ARTICLES_B.print_text_yn%TYPE;
1429: l_summary_amend_operation_code OKC_K_ARTICLES_B.summary_amend_operation_code%TYPE;
1430: l_ref_article_id OKC_K_ARTICLES_B.ref_article_id%TYPE;
1431: l_ref_article_version_id OKC_K_ARTICLES_B.ref_article_version_id%TYPE;

Line 1428: l_print_text_yn OKC_K_ARTICLES_B.print_text_yn%TYPE;

1424: l_attribute12 OKC_K_ARTICLES_B.ATTRIBUTE12%TYPE;
1425: l_attribute13 OKC_K_ARTICLES_B.ATTRIBUTE13%TYPE;
1426: l_attribute14 OKC_K_ARTICLES_B.ATTRIBUTE14%TYPE;
1427: l_attribute15 OKC_K_ARTICLES_B.ATTRIBUTE15%TYPE;
1428: l_print_text_yn OKC_K_ARTICLES_B.print_text_yn%TYPE;
1429: l_summary_amend_operation_code OKC_K_ARTICLES_B.summary_amend_operation_code%TYPE;
1430: l_ref_article_id OKC_K_ARTICLES_B.ref_article_id%TYPE;
1431: l_ref_article_version_id OKC_K_ARTICLES_B.ref_article_version_id%TYPE;
1432: l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;

Line 1429: l_summary_amend_operation_code OKC_K_ARTICLES_B.summary_amend_operation_code%TYPE;

1425: l_attribute13 OKC_K_ARTICLES_B.ATTRIBUTE13%TYPE;
1426: l_attribute14 OKC_K_ARTICLES_B.ATTRIBUTE14%TYPE;
1427: l_attribute15 OKC_K_ARTICLES_B.ATTRIBUTE15%TYPE;
1428: l_print_text_yn OKC_K_ARTICLES_B.print_text_yn%TYPE;
1429: l_summary_amend_operation_code OKC_K_ARTICLES_B.summary_amend_operation_code%TYPE;
1430: l_ref_article_id OKC_K_ARTICLES_B.ref_article_id%TYPE;
1431: l_ref_article_version_id OKC_K_ARTICLES_B.ref_article_version_id%TYPE;
1432: l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;
1433: l_created_by OKC_K_ARTICLES_B.CREATED_BY%TYPE;

Line 1430: l_ref_article_id OKC_K_ARTICLES_B.ref_article_id%TYPE;

1426: l_attribute14 OKC_K_ARTICLES_B.ATTRIBUTE14%TYPE;
1427: l_attribute15 OKC_K_ARTICLES_B.ATTRIBUTE15%TYPE;
1428: l_print_text_yn OKC_K_ARTICLES_B.print_text_yn%TYPE;
1429: l_summary_amend_operation_code OKC_K_ARTICLES_B.summary_amend_operation_code%TYPE;
1430: l_ref_article_id OKC_K_ARTICLES_B.ref_article_id%TYPE;
1431: l_ref_article_version_id OKC_K_ARTICLES_B.ref_article_version_id%TYPE;
1432: l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;
1433: l_created_by OKC_K_ARTICLES_B.CREATED_BY%TYPE;
1434: l_creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE;

Line 1431: l_ref_article_version_id OKC_K_ARTICLES_B.ref_article_version_id%TYPE;

1427: l_attribute15 OKC_K_ARTICLES_B.ATTRIBUTE15%TYPE;
1428: l_print_text_yn OKC_K_ARTICLES_B.print_text_yn%TYPE;
1429: l_summary_amend_operation_code OKC_K_ARTICLES_B.summary_amend_operation_code%TYPE;
1430: l_ref_article_id OKC_K_ARTICLES_B.ref_article_id%TYPE;
1431: l_ref_article_version_id OKC_K_ARTICLES_B.ref_article_version_id%TYPE;
1432: l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;
1433: l_created_by OKC_K_ARTICLES_B.CREATED_BY%TYPE;
1434: l_creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE;
1435: l_last_updated_by OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;

Line 1432: l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;

1428: l_print_text_yn OKC_K_ARTICLES_B.print_text_yn%TYPE;
1429: l_summary_amend_operation_code OKC_K_ARTICLES_B.summary_amend_operation_code%TYPE;
1430: l_ref_article_id OKC_K_ARTICLES_B.ref_article_id%TYPE;
1431: l_ref_article_version_id OKC_K_ARTICLES_B.ref_article_version_id%TYPE;
1432: l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;
1433: l_created_by OKC_K_ARTICLES_B.CREATED_BY%TYPE;
1434: l_creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE;
1435: l_last_updated_by OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;
1436: l_last_update_login OKC_K_ARTICLES_B.LAST_UPDATE_LOGIN%TYPE;

Line 1433: l_created_by OKC_K_ARTICLES_B.CREATED_BY%TYPE;

1429: l_summary_amend_operation_code OKC_K_ARTICLES_B.summary_amend_operation_code%TYPE;
1430: l_ref_article_id OKC_K_ARTICLES_B.ref_article_id%TYPE;
1431: l_ref_article_version_id OKC_K_ARTICLES_B.ref_article_version_id%TYPE;
1432: l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;
1433: l_created_by OKC_K_ARTICLES_B.CREATED_BY%TYPE;
1434: l_creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE;
1435: l_last_updated_by OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;
1436: l_last_update_login OKC_K_ARTICLES_B.LAST_UPDATE_LOGIN%TYPE;
1437: l_last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE;

Line 1434: l_creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE;

1430: l_ref_article_id OKC_K_ARTICLES_B.ref_article_id%TYPE;
1431: l_ref_article_version_id OKC_K_ARTICLES_B.ref_article_version_id%TYPE;
1432: l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;
1433: l_created_by OKC_K_ARTICLES_B.CREATED_BY%TYPE;
1434: l_creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE;
1435: l_last_updated_by OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;
1436: l_last_update_login OKC_K_ARTICLES_B.LAST_UPDATE_LOGIN%TYPE;
1437: l_last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE;
1438: l_last_amended_by OKC_K_ARTICLES_B.LAST_AMENDED_BY%TYPE;

Line 1435: l_last_updated_by OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;

1431: l_ref_article_version_id OKC_K_ARTICLES_B.ref_article_version_id%TYPE;
1432: l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;
1433: l_created_by OKC_K_ARTICLES_B.CREATED_BY%TYPE;
1434: l_creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE;
1435: l_last_updated_by OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;
1436: l_last_update_login OKC_K_ARTICLES_B.LAST_UPDATE_LOGIN%TYPE;
1437: l_last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE;
1438: l_last_amended_by OKC_K_ARTICLES_B.LAST_AMENDED_BY%TYPE;
1439: l_last_amendment_date OKC_K_ARTICLES_B.LAST_AMENDMENT_DATE%TYPE;

Line 1436: l_last_update_login OKC_K_ARTICLES_B.LAST_UPDATE_LOGIN%TYPE;

1432: l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;
1433: l_created_by OKC_K_ARTICLES_B.CREATED_BY%TYPE;
1434: l_creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE;
1435: l_last_updated_by OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;
1436: l_last_update_login OKC_K_ARTICLES_B.LAST_UPDATE_LOGIN%TYPE;
1437: l_last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE;
1438: l_last_amended_by OKC_K_ARTICLES_B.LAST_AMENDED_BY%TYPE;
1439: l_last_amendment_date OKC_K_ARTICLES_B.LAST_AMENDMENT_DATE%TYPE;
1440: BEGIN

Line 1437: l_last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE;

1433: l_created_by OKC_K_ARTICLES_B.CREATED_BY%TYPE;
1434: l_creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE;
1435: l_last_updated_by OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;
1436: l_last_update_login OKC_K_ARTICLES_B.LAST_UPDATE_LOGIN%TYPE;
1437: l_last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE;
1438: l_last_amended_by OKC_K_ARTICLES_B.LAST_AMENDED_BY%TYPE;
1439: l_last_amendment_date OKC_K_ARTICLES_B.LAST_AMENDMENT_DATE%TYPE;
1440: BEGIN
1441:

Line 1438: l_last_amended_by OKC_K_ARTICLES_B.LAST_AMENDED_BY%TYPE;

1434: l_creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE;
1435: l_last_updated_by OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;
1436: l_last_update_login OKC_K_ARTICLES_B.LAST_UPDATE_LOGIN%TYPE;
1437: l_last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE;
1438: l_last_amended_by OKC_K_ARTICLES_B.LAST_AMENDED_BY%TYPE;
1439: l_last_amendment_date OKC_K_ARTICLES_B.LAST_AMENDMENT_DATE%TYPE;
1440: BEGIN
1441:
1442: IF (l_debug = 'Y') THEN

Line 1439: l_last_amendment_date OKC_K_ARTICLES_B.LAST_AMENDMENT_DATE%TYPE;

1435: l_last_updated_by OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;
1436: l_last_update_login OKC_K_ARTICLES_B.LAST_UPDATE_LOGIN%TYPE;
1437: l_last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE;
1438: l_last_amended_by OKC_K_ARTICLES_B.LAST_AMENDED_BY%TYPE;
1439: l_last_amendment_date OKC_K_ARTICLES_B.LAST_AMENDMENT_DATE%TYPE;
1440: BEGIN
1441:
1442: IF (l_debug = 'Y') THEN
1443: Okc_Debug.Log('2600: Entered validate_row', 2);

Line 1616: -- Insert_Row for:OKC_K_ARTICLES_B --

1612: ---------------------------------------------------------------------------
1613: -- PROCEDURE Insert_Row
1614: ---------------------------------------------------------------------------
1615: -------------------------------------
1616: -- Insert_Row for:OKC_K_ARTICLES_B --
1617: -------------------------------------
1618: FUNCTION Insert_Row(
1619: p_id IN NUMBER,
1620: p_sav_sae_id IN NUMBER,

Line 1679: INSERT INTO OKC_K_ARTICLES_B(

1675: IF p_document_type IN ('OKC_SELL','OKC_BUY','OKO','OKS','OKE_SELL','OKE_BUY','OKL') THEN
1676: l_chr_id := okc_terms_util_pvt.get_chr_id_for_doc_id(p_document_id);
1677: END IF;
1678:
1679: INSERT INTO OKC_K_ARTICLES_B(
1680: ID,
1681: SAV_SAE_ID,
1682: SAV_SAV_RELEASE,
1683: SBT_CODE,

Line 1813: -- Insert_Row for:OKC_K_ARTICLES_B --

1809:
1810: END Insert_Row;
1811:
1812: -------------------------------------
1813: -- Insert_Row for:OKC_K_ARTICLES_B --
1814: -------------------------------------
1815: PROCEDURE Insert_Row(
1816: p_validation_level IN NUMBER,
1817: x_return_status OUT NOCOPY VARCHAR2,

Line 1860: l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;

1856: x_id OUT NOCOPY NUMBER
1857:
1858: ) IS
1859:
1860: l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;
1861: l_created_by OKC_K_ARTICLES_B.CREATED_BY%TYPE;
1862: l_creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE;
1863: l_last_updated_by OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;
1864: l_last_update_login OKC_K_ARTICLES_B.LAST_UPDATE_LOGIN%TYPE;

Line 1861: l_created_by OKC_K_ARTICLES_B.CREATED_BY%TYPE;

1857:
1858: ) IS
1859:
1860: l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;
1861: l_created_by OKC_K_ARTICLES_B.CREATED_BY%TYPE;
1862: l_creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE;
1863: l_last_updated_by OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;
1864: l_last_update_login OKC_K_ARTICLES_B.LAST_UPDATE_LOGIN%TYPE;
1865: l_last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE;

Line 1862: l_creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE;

1858: ) IS
1859:
1860: l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;
1861: l_created_by OKC_K_ARTICLES_B.CREATED_BY%TYPE;
1862: l_creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE;
1863: l_last_updated_by OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;
1864: l_last_update_login OKC_K_ARTICLES_B.LAST_UPDATE_LOGIN%TYPE;
1865: l_last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE;
1866: l_last_amended_by OKC_K_ARTICLES_B.LAST_AMENDED_BY%TYPE;

Line 1863: l_last_updated_by OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;

1859:
1860: l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;
1861: l_created_by OKC_K_ARTICLES_B.CREATED_BY%TYPE;
1862: l_creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE;
1863: l_last_updated_by OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;
1864: l_last_update_login OKC_K_ARTICLES_B.LAST_UPDATE_LOGIN%TYPE;
1865: l_last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE;
1866: l_last_amended_by OKC_K_ARTICLES_B.LAST_AMENDED_BY%TYPE;
1867: l_last_amendment_date OKC_K_ARTICLES_B.LAST_AMENDMENT_DATE%TYPE;

Line 1864: l_last_update_login OKC_K_ARTICLES_B.LAST_UPDATE_LOGIN%TYPE;

1860: l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;
1861: l_created_by OKC_K_ARTICLES_B.CREATED_BY%TYPE;
1862: l_creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE;
1863: l_last_updated_by OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;
1864: l_last_update_login OKC_K_ARTICLES_B.LAST_UPDATE_LOGIN%TYPE;
1865: l_last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE;
1866: l_last_amended_by OKC_K_ARTICLES_B.LAST_AMENDED_BY%TYPE;
1867: l_last_amendment_date OKC_K_ARTICLES_B.LAST_AMENDMENT_DATE%TYPE;
1868: BEGIN

Line 1865: l_last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE;

1861: l_created_by OKC_K_ARTICLES_B.CREATED_BY%TYPE;
1862: l_creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE;
1863: l_last_updated_by OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;
1864: l_last_update_login OKC_K_ARTICLES_B.LAST_UPDATE_LOGIN%TYPE;
1865: l_last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE;
1866: l_last_amended_by OKC_K_ARTICLES_B.LAST_AMENDED_BY%TYPE;
1867: l_last_amendment_date OKC_K_ARTICLES_B.LAST_AMENDMENT_DATE%TYPE;
1868: BEGIN
1869:

Line 1866: l_last_amended_by OKC_K_ARTICLES_B.LAST_AMENDED_BY%TYPE;

1862: l_creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE;
1863: l_last_updated_by OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;
1864: l_last_update_login OKC_K_ARTICLES_B.LAST_UPDATE_LOGIN%TYPE;
1865: l_last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE;
1866: l_last_amended_by OKC_K_ARTICLES_B.LAST_AMENDED_BY%TYPE;
1867: l_last_amendment_date OKC_K_ARTICLES_B.LAST_AMENDMENT_DATE%TYPE;
1868: BEGIN
1869:
1870: x_return_status := G_RET_STS_SUCCESS;

Line 1867: l_last_amendment_date OKC_K_ARTICLES_B.LAST_AMENDMENT_DATE%TYPE;

1863: l_last_updated_by OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;
1864: l_last_update_login OKC_K_ARTICLES_B.LAST_UPDATE_LOGIN%TYPE;
1865: l_last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE;
1866: l_last_amended_by OKC_K_ARTICLES_B.LAST_AMENDED_BY%TYPE;
1867: l_last_amendment_date OKC_K_ARTICLES_B.LAST_AMENDMENT_DATE%TYPE;
1868: BEGIN
1869:
1870: x_return_status := G_RET_STS_SUCCESS;
1871:

Line 2048: -- Lock_Row for:OKC_K_ARTICLES_B --

2044: ---------------------------------------------------------------------------
2045: -- PROCEDURE Lock_Row
2046: ---------------------------------------------------------------------------
2047: -----------------------------------
2048: -- Lock_Row for:OKC_K_ARTICLES_B --
2049: -----------------------------------
2050: FUNCTION Lock_Row(
2051: p_id IN NUMBER,
2052: p_object_version_number IN NUMBER

Line 2058: FROM OKC_K_ARTICLES_B

2054:
2055:
2056: CURSOR lock_csr (cp_id NUMBER, cp_object_version_number NUMBER) IS
2057: SELECT object_version_number
2058: FROM OKC_K_ARTICLES_B
2059: WHERE ID = cp_id
2060: AND (object_version_number = cp_object_version_number OR cp_object_version_number IS NULL)
2061: FOR UPDATE OF object_version_number NOWAIT;
2062:

Line 2065: FROM OKC_K_ARTICLES_B

2061: FOR UPDATE OF object_version_number NOWAIT;
2062:
2063: CURSOR lchk_csr (cp_id NUMBER) IS
2064: SELECT object_version_number
2065: FROM OKC_K_ARTICLES_B
2066: WHERE ID = cp_id;
2067:
2068: l_return_status VARCHAR2(1);
2069:

Line 2070: l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;

2066: WHERE ID = cp_id;
2067:
2068: l_return_status VARCHAR2(1);
2069:
2070: l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;
2071:
2072: l_row_notfound BOOLEAN := FALSE;
2073: BEGIN
2074:

Line 2111: 'ENTITYNAME','OKC_K_ARTICLES_B',

2107: CLOSE lchk_csr;
2108:
2109: IF (l_row_notfound) THEN
2110: Okc_Api.Set_Message(G_APP_NAME,G_LOCK_RECORD_DELETED,
2111: 'ENTITYNAME','OKC_K_ARTICLES_B',
2112: 'PKEY',p_id,
2113: 'OVN',p_object_version_number
2114: );
2115: ELSIF l_object_version_number > p_object_version_number THEN

Line 2156: -- Lock_Row for:OKC_K_ARTICLES_B --

2152:
2153: RETURN( G_RET_STS_UNEXP_ERROR );
2154: END Lock_Row;
2155: -----------------------------------
2156: -- Lock_Row for:OKC_K_ARTICLES_B --
2157: -----------------------------------
2158: PROCEDURE Lock_Row(
2159: x_return_status OUT NOCOPY VARCHAR2,
2160: p_id IN NUMBER,

Line 2221: -- Update_Row for:OKC_K_ARTICLES_B --

2217: ---------------------------------------------------------------------------
2218: -- PROCEDURE Update_Row
2219: ---------------------------------------------------------------------------
2220: -------------------------------------
2221: -- Update_Row for:OKC_K_ARTICLES_B --
2222: -------------------------------------
2223: FUNCTION Update_Row(
2224: p_id IN NUMBER,
2225: p_sav_sae_id IN NUMBER,

Line 2282: UPDATE OKC_K_ARTICLES_B

2278: IF p_document_type IN ('OKC_SELL','OKC_BUY','OKO','OKS','OKE_SELL','OKE_BUY','OKL') THEN
2279: l_chr_id := okc_terms_util_pvt.get_chr_id_for_doc_id(p_document_id);
2280: END IF;
2281:
2282: UPDATE OKC_K_ARTICLES_B
2283: SET SAV_SAE_ID = p_sav_sae_id,
2284: DOCUMENT_TYPE = p_document_type,
2285: DOCUMENT_ID = p_document_id,
2286: CLE_ID = p_cle_id,

Line 2353: -- Update_Row for:OKC_K_ARTICLES_B --

2349: RETURN G_RET_STS_UNEXP_ERROR ;
2350:
2351: END Update_Row;
2352: -------------------------------------
2353: -- Update_Row for:OKC_K_ARTICLES_B --
2354: -------------------------------------
2355: PROCEDURE Update_Row(
2356: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2357: x_return_status OUT NOCOPY VARCHAR2,

Line 2401: l_sav_sae_id OKC_K_ARTICLES_B.SAV_SAE_ID%TYPE;

2397: p_last_amendment_date IN DATE
2398:
2399: ) IS
2400:
2401: l_sav_sae_id OKC_K_ARTICLES_B.SAV_SAE_ID%TYPE;
2402: l_document_type OKC_K_ARTICLES_B.DOCUMENT_TYPE%TYPE;
2403: l_document_id OKC_K_ARTICLES_B.DOCUMENT_ID%TYPE;
2404: l_cle_id OKC_K_ARTICLES_B.cle_id%TYPE;
2405: l_source_flag OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE;

Line 2402: l_document_type OKC_K_ARTICLES_B.DOCUMENT_TYPE%TYPE;

2398:
2399: ) IS
2400:
2401: l_sav_sae_id OKC_K_ARTICLES_B.SAV_SAE_ID%TYPE;
2402: l_document_type OKC_K_ARTICLES_B.DOCUMENT_TYPE%TYPE;
2403: l_document_id OKC_K_ARTICLES_B.DOCUMENT_ID%TYPE;
2404: l_cle_id OKC_K_ARTICLES_B.cle_id%TYPE;
2405: l_source_flag OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE;
2406: l_mandatory_yn OKC_K_ARTICLES_B.MANDATORY_YN%TYPE;

Line 2403: l_document_id OKC_K_ARTICLES_B.DOCUMENT_ID%TYPE;

2399: ) IS
2400:
2401: l_sav_sae_id OKC_K_ARTICLES_B.SAV_SAE_ID%TYPE;
2402: l_document_type OKC_K_ARTICLES_B.DOCUMENT_TYPE%TYPE;
2403: l_document_id OKC_K_ARTICLES_B.DOCUMENT_ID%TYPE;
2404: l_cle_id OKC_K_ARTICLES_B.cle_id%TYPE;
2405: l_source_flag OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE;
2406: l_mandatory_yn OKC_K_ARTICLES_B.MANDATORY_YN%TYPE;
2407: l_scn_id OKC_K_ARTICLES_B.SCN_ID%TYPE;

Line 2404: l_cle_id OKC_K_ARTICLES_B.cle_id%TYPE;

2400:
2401: l_sav_sae_id OKC_K_ARTICLES_B.SAV_SAE_ID%TYPE;
2402: l_document_type OKC_K_ARTICLES_B.DOCUMENT_TYPE%TYPE;
2403: l_document_id OKC_K_ARTICLES_B.DOCUMENT_ID%TYPE;
2404: l_cle_id OKC_K_ARTICLES_B.cle_id%TYPE;
2405: l_source_flag OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE;
2406: l_mandatory_yn OKC_K_ARTICLES_B.MANDATORY_YN%TYPE;
2407: l_scn_id OKC_K_ARTICLES_B.SCN_ID%TYPE;
2408: l_label OKC_K_ARTICLES_B.LABEL%TYPE;

Line 2405: l_source_flag OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE;

2401: l_sav_sae_id OKC_K_ARTICLES_B.SAV_SAE_ID%TYPE;
2402: l_document_type OKC_K_ARTICLES_B.DOCUMENT_TYPE%TYPE;
2403: l_document_id OKC_K_ARTICLES_B.DOCUMENT_ID%TYPE;
2404: l_cle_id OKC_K_ARTICLES_B.cle_id%TYPE;
2405: l_source_flag OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE;
2406: l_mandatory_yn OKC_K_ARTICLES_B.MANDATORY_YN%TYPE;
2407: l_scn_id OKC_K_ARTICLES_B.SCN_ID%TYPE;
2408: l_label OKC_K_ARTICLES_B.LABEL%TYPE;
2409: l_amendment_description OKC_K_ARTICLES_B.AMENDMENT_DESCRIPTION%TYPE;

Line 2406: l_mandatory_yn OKC_K_ARTICLES_B.MANDATORY_YN%TYPE;

2402: l_document_type OKC_K_ARTICLES_B.DOCUMENT_TYPE%TYPE;
2403: l_document_id OKC_K_ARTICLES_B.DOCUMENT_ID%TYPE;
2404: l_cle_id OKC_K_ARTICLES_B.cle_id%TYPE;
2405: l_source_flag OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE;
2406: l_mandatory_yn OKC_K_ARTICLES_B.MANDATORY_YN%TYPE;
2407: l_scn_id OKC_K_ARTICLES_B.SCN_ID%TYPE;
2408: l_label OKC_K_ARTICLES_B.LABEL%TYPE;
2409: l_amendment_description OKC_K_ARTICLES_B.AMENDMENT_DESCRIPTION%TYPE;
2410: l_amendment_operation_code OKC_K_ARTICLES_B.AMENDMENT_OPERATION_CODE%TYPE;

Line 2407: l_scn_id OKC_K_ARTICLES_B.SCN_ID%TYPE;

2403: l_document_id OKC_K_ARTICLES_B.DOCUMENT_ID%TYPE;
2404: l_cle_id OKC_K_ARTICLES_B.cle_id%TYPE;
2405: l_source_flag OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE;
2406: l_mandatory_yn OKC_K_ARTICLES_B.MANDATORY_YN%TYPE;
2407: l_scn_id OKC_K_ARTICLES_B.SCN_ID%TYPE;
2408: l_label OKC_K_ARTICLES_B.LABEL%TYPE;
2409: l_amendment_description OKC_K_ARTICLES_B.AMENDMENT_DESCRIPTION%TYPE;
2410: l_amendment_operation_code OKC_K_ARTICLES_B.AMENDMENT_OPERATION_CODE%TYPE;
2411: l_article_version_id OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE;

Line 2408: l_label OKC_K_ARTICLES_B.LABEL%TYPE;

2404: l_cle_id OKC_K_ARTICLES_B.cle_id%TYPE;
2405: l_source_flag OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE;
2406: l_mandatory_yn OKC_K_ARTICLES_B.MANDATORY_YN%TYPE;
2407: l_scn_id OKC_K_ARTICLES_B.SCN_ID%TYPE;
2408: l_label OKC_K_ARTICLES_B.LABEL%TYPE;
2409: l_amendment_description OKC_K_ARTICLES_B.AMENDMENT_DESCRIPTION%TYPE;
2410: l_amendment_operation_code OKC_K_ARTICLES_B.AMENDMENT_OPERATION_CODE%TYPE;
2411: l_article_version_id OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE;
2412: l_change_nonstd_yn OKC_K_ARTICLES_B.CHANGE_NONSTD_YN%TYPE;

Line 2409: l_amendment_description OKC_K_ARTICLES_B.AMENDMENT_DESCRIPTION%TYPE;

2405: l_source_flag OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE;
2406: l_mandatory_yn OKC_K_ARTICLES_B.MANDATORY_YN%TYPE;
2407: l_scn_id OKC_K_ARTICLES_B.SCN_ID%TYPE;
2408: l_label OKC_K_ARTICLES_B.LABEL%TYPE;
2409: l_amendment_description OKC_K_ARTICLES_B.AMENDMENT_DESCRIPTION%TYPE;
2410: l_amendment_operation_code OKC_K_ARTICLES_B.AMENDMENT_OPERATION_CODE%TYPE;
2411: l_article_version_id OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE;
2412: l_change_nonstd_yn OKC_K_ARTICLES_B.CHANGE_NONSTD_YN%TYPE;
2413: l_orig_system_reference_code OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_CODE%TYPE;

Line 2410: l_amendment_operation_code OKC_K_ARTICLES_B.AMENDMENT_OPERATION_CODE%TYPE;

2406: l_mandatory_yn OKC_K_ARTICLES_B.MANDATORY_YN%TYPE;
2407: l_scn_id OKC_K_ARTICLES_B.SCN_ID%TYPE;
2408: l_label OKC_K_ARTICLES_B.LABEL%TYPE;
2409: l_amendment_description OKC_K_ARTICLES_B.AMENDMENT_DESCRIPTION%TYPE;
2410: l_amendment_operation_code OKC_K_ARTICLES_B.AMENDMENT_OPERATION_CODE%TYPE;
2411: l_article_version_id OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE;
2412: l_change_nonstd_yn OKC_K_ARTICLES_B.CHANGE_NONSTD_YN%TYPE;
2413: l_orig_system_reference_code OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
2414: l_orig_system_reference_id1 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID1%TYPE;

Line 2411: l_article_version_id OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE;

2407: l_scn_id OKC_K_ARTICLES_B.SCN_ID%TYPE;
2408: l_label OKC_K_ARTICLES_B.LABEL%TYPE;
2409: l_amendment_description OKC_K_ARTICLES_B.AMENDMENT_DESCRIPTION%TYPE;
2410: l_amendment_operation_code OKC_K_ARTICLES_B.AMENDMENT_OPERATION_CODE%TYPE;
2411: l_article_version_id OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE;
2412: l_change_nonstd_yn OKC_K_ARTICLES_B.CHANGE_NONSTD_YN%TYPE;
2413: l_orig_system_reference_code OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
2414: l_orig_system_reference_id1 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
2415: l_orig_system_reference_id2 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID2%TYPE;

Line 2412: l_change_nonstd_yn OKC_K_ARTICLES_B.CHANGE_NONSTD_YN%TYPE;

2408: l_label OKC_K_ARTICLES_B.LABEL%TYPE;
2409: l_amendment_description OKC_K_ARTICLES_B.AMENDMENT_DESCRIPTION%TYPE;
2410: l_amendment_operation_code OKC_K_ARTICLES_B.AMENDMENT_OPERATION_CODE%TYPE;
2411: l_article_version_id OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE;
2412: l_change_nonstd_yn OKC_K_ARTICLES_B.CHANGE_NONSTD_YN%TYPE;
2413: l_orig_system_reference_code OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
2414: l_orig_system_reference_id1 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
2415: l_orig_system_reference_id2 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
2416: l_display_sequence OKC_K_ARTICLES_B.DISPLAY_SEQUENCE%TYPE;

Line 2413: l_orig_system_reference_code OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_CODE%TYPE;

2409: l_amendment_description OKC_K_ARTICLES_B.AMENDMENT_DESCRIPTION%TYPE;
2410: l_amendment_operation_code OKC_K_ARTICLES_B.AMENDMENT_OPERATION_CODE%TYPE;
2411: l_article_version_id OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE;
2412: l_change_nonstd_yn OKC_K_ARTICLES_B.CHANGE_NONSTD_YN%TYPE;
2413: l_orig_system_reference_code OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
2414: l_orig_system_reference_id1 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
2415: l_orig_system_reference_id2 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
2416: l_display_sequence OKC_K_ARTICLES_B.DISPLAY_SEQUENCE%TYPE;
2417: l_attribute_category OKC_K_ARTICLES_B.ATTRIBUTE_CATEGORY%TYPE;

Line 2414: l_orig_system_reference_id1 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID1%TYPE;

2410: l_amendment_operation_code OKC_K_ARTICLES_B.AMENDMENT_OPERATION_CODE%TYPE;
2411: l_article_version_id OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE;
2412: l_change_nonstd_yn OKC_K_ARTICLES_B.CHANGE_NONSTD_YN%TYPE;
2413: l_orig_system_reference_code OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
2414: l_orig_system_reference_id1 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
2415: l_orig_system_reference_id2 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
2416: l_display_sequence OKC_K_ARTICLES_B.DISPLAY_SEQUENCE%TYPE;
2417: l_attribute_category OKC_K_ARTICLES_B.ATTRIBUTE_CATEGORY%TYPE;
2418: l_attribute1 OKC_K_ARTICLES_B.ATTRIBUTE1%TYPE;

Line 2415: l_orig_system_reference_id2 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID2%TYPE;

2411: l_article_version_id OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE;
2412: l_change_nonstd_yn OKC_K_ARTICLES_B.CHANGE_NONSTD_YN%TYPE;
2413: l_orig_system_reference_code OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
2414: l_orig_system_reference_id1 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
2415: l_orig_system_reference_id2 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
2416: l_display_sequence OKC_K_ARTICLES_B.DISPLAY_SEQUENCE%TYPE;
2417: l_attribute_category OKC_K_ARTICLES_B.ATTRIBUTE_CATEGORY%TYPE;
2418: l_attribute1 OKC_K_ARTICLES_B.ATTRIBUTE1%TYPE;
2419: l_attribute2 OKC_K_ARTICLES_B.ATTRIBUTE2%TYPE;

Line 2416: l_display_sequence OKC_K_ARTICLES_B.DISPLAY_SEQUENCE%TYPE;

2412: l_change_nonstd_yn OKC_K_ARTICLES_B.CHANGE_NONSTD_YN%TYPE;
2413: l_orig_system_reference_code OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
2414: l_orig_system_reference_id1 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
2415: l_orig_system_reference_id2 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
2416: l_display_sequence OKC_K_ARTICLES_B.DISPLAY_SEQUENCE%TYPE;
2417: l_attribute_category OKC_K_ARTICLES_B.ATTRIBUTE_CATEGORY%TYPE;
2418: l_attribute1 OKC_K_ARTICLES_B.ATTRIBUTE1%TYPE;
2419: l_attribute2 OKC_K_ARTICLES_B.ATTRIBUTE2%TYPE;
2420: l_attribute3 OKC_K_ARTICLES_B.ATTRIBUTE3%TYPE;

Line 2417: l_attribute_category OKC_K_ARTICLES_B.ATTRIBUTE_CATEGORY%TYPE;

2413: l_orig_system_reference_code OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
2414: l_orig_system_reference_id1 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
2415: l_orig_system_reference_id2 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
2416: l_display_sequence OKC_K_ARTICLES_B.DISPLAY_SEQUENCE%TYPE;
2417: l_attribute_category OKC_K_ARTICLES_B.ATTRIBUTE_CATEGORY%TYPE;
2418: l_attribute1 OKC_K_ARTICLES_B.ATTRIBUTE1%TYPE;
2419: l_attribute2 OKC_K_ARTICLES_B.ATTRIBUTE2%TYPE;
2420: l_attribute3 OKC_K_ARTICLES_B.ATTRIBUTE3%TYPE;
2421: l_attribute4 OKC_K_ARTICLES_B.ATTRIBUTE4%TYPE;

Line 2418: l_attribute1 OKC_K_ARTICLES_B.ATTRIBUTE1%TYPE;

2414: l_orig_system_reference_id1 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
2415: l_orig_system_reference_id2 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
2416: l_display_sequence OKC_K_ARTICLES_B.DISPLAY_SEQUENCE%TYPE;
2417: l_attribute_category OKC_K_ARTICLES_B.ATTRIBUTE_CATEGORY%TYPE;
2418: l_attribute1 OKC_K_ARTICLES_B.ATTRIBUTE1%TYPE;
2419: l_attribute2 OKC_K_ARTICLES_B.ATTRIBUTE2%TYPE;
2420: l_attribute3 OKC_K_ARTICLES_B.ATTRIBUTE3%TYPE;
2421: l_attribute4 OKC_K_ARTICLES_B.ATTRIBUTE4%TYPE;
2422: l_attribute5 OKC_K_ARTICLES_B.ATTRIBUTE5%TYPE;

Line 2419: l_attribute2 OKC_K_ARTICLES_B.ATTRIBUTE2%TYPE;

2415: l_orig_system_reference_id2 OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
2416: l_display_sequence OKC_K_ARTICLES_B.DISPLAY_SEQUENCE%TYPE;
2417: l_attribute_category OKC_K_ARTICLES_B.ATTRIBUTE_CATEGORY%TYPE;
2418: l_attribute1 OKC_K_ARTICLES_B.ATTRIBUTE1%TYPE;
2419: l_attribute2 OKC_K_ARTICLES_B.ATTRIBUTE2%TYPE;
2420: l_attribute3 OKC_K_ARTICLES_B.ATTRIBUTE3%TYPE;
2421: l_attribute4 OKC_K_ARTICLES_B.ATTRIBUTE4%TYPE;
2422: l_attribute5 OKC_K_ARTICLES_B.ATTRIBUTE5%TYPE;
2423: l_attribute6 OKC_K_ARTICLES_B.ATTRIBUTE6%TYPE;

Line 2420: l_attribute3 OKC_K_ARTICLES_B.ATTRIBUTE3%TYPE;

2416: l_display_sequence OKC_K_ARTICLES_B.DISPLAY_SEQUENCE%TYPE;
2417: l_attribute_category OKC_K_ARTICLES_B.ATTRIBUTE_CATEGORY%TYPE;
2418: l_attribute1 OKC_K_ARTICLES_B.ATTRIBUTE1%TYPE;
2419: l_attribute2 OKC_K_ARTICLES_B.ATTRIBUTE2%TYPE;
2420: l_attribute3 OKC_K_ARTICLES_B.ATTRIBUTE3%TYPE;
2421: l_attribute4 OKC_K_ARTICLES_B.ATTRIBUTE4%TYPE;
2422: l_attribute5 OKC_K_ARTICLES_B.ATTRIBUTE5%TYPE;
2423: l_attribute6 OKC_K_ARTICLES_B.ATTRIBUTE6%TYPE;
2424: l_attribute7 OKC_K_ARTICLES_B.ATTRIBUTE7%TYPE;

Line 2421: l_attribute4 OKC_K_ARTICLES_B.ATTRIBUTE4%TYPE;

2417: l_attribute_category OKC_K_ARTICLES_B.ATTRIBUTE_CATEGORY%TYPE;
2418: l_attribute1 OKC_K_ARTICLES_B.ATTRIBUTE1%TYPE;
2419: l_attribute2 OKC_K_ARTICLES_B.ATTRIBUTE2%TYPE;
2420: l_attribute3 OKC_K_ARTICLES_B.ATTRIBUTE3%TYPE;
2421: l_attribute4 OKC_K_ARTICLES_B.ATTRIBUTE4%TYPE;
2422: l_attribute5 OKC_K_ARTICLES_B.ATTRIBUTE5%TYPE;
2423: l_attribute6 OKC_K_ARTICLES_B.ATTRIBUTE6%TYPE;
2424: l_attribute7 OKC_K_ARTICLES_B.ATTRIBUTE7%TYPE;
2425: l_attribute8 OKC_K_ARTICLES_B.ATTRIBUTE8%TYPE;

Line 2422: l_attribute5 OKC_K_ARTICLES_B.ATTRIBUTE5%TYPE;

2418: l_attribute1 OKC_K_ARTICLES_B.ATTRIBUTE1%TYPE;
2419: l_attribute2 OKC_K_ARTICLES_B.ATTRIBUTE2%TYPE;
2420: l_attribute3 OKC_K_ARTICLES_B.ATTRIBUTE3%TYPE;
2421: l_attribute4 OKC_K_ARTICLES_B.ATTRIBUTE4%TYPE;
2422: l_attribute5 OKC_K_ARTICLES_B.ATTRIBUTE5%TYPE;
2423: l_attribute6 OKC_K_ARTICLES_B.ATTRIBUTE6%TYPE;
2424: l_attribute7 OKC_K_ARTICLES_B.ATTRIBUTE7%TYPE;
2425: l_attribute8 OKC_K_ARTICLES_B.ATTRIBUTE8%TYPE;
2426: l_attribute9 OKC_K_ARTICLES_B.ATTRIBUTE9%TYPE;

Line 2423: l_attribute6 OKC_K_ARTICLES_B.ATTRIBUTE6%TYPE;

2419: l_attribute2 OKC_K_ARTICLES_B.ATTRIBUTE2%TYPE;
2420: l_attribute3 OKC_K_ARTICLES_B.ATTRIBUTE3%TYPE;
2421: l_attribute4 OKC_K_ARTICLES_B.ATTRIBUTE4%TYPE;
2422: l_attribute5 OKC_K_ARTICLES_B.ATTRIBUTE5%TYPE;
2423: l_attribute6 OKC_K_ARTICLES_B.ATTRIBUTE6%TYPE;
2424: l_attribute7 OKC_K_ARTICLES_B.ATTRIBUTE7%TYPE;
2425: l_attribute8 OKC_K_ARTICLES_B.ATTRIBUTE8%TYPE;
2426: l_attribute9 OKC_K_ARTICLES_B.ATTRIBUTE9%TYPE;
2427: l_attribute10 OKC_K_ARTICLES_B.ATTRIBUTE10%TYPE;

Line 2424: l_attribute7 OKC_K_ARTICLES_B.ATTRIBUTE7%TYPE;

2420: l_attribute3 OKC_K_ARTICLES_B.ATTRIBUTE3%TYPE;
2421: l_attribute4 OKC_K_ARTICLES_B.ATTRIBUTE4%TYPE;
2422: l_attribute5 OKC_K_ARTICLES_B.ATTRIBUTE5%TYPE;
2423: l_attribute6 OKC_K_ARTICLES_B.ATTRIBUTE6%TYPE;
2424: l_attribute7 OKC_K_ARTICLES_B.ATTRIBUTE7%TYPE;
2425: l_attribute8 OKC_K_ARTICLES_B.ATTRIBUTE8%TYPE;
2426: l_attribute9 OKC_K_ARTICLES_B.ATTRIBUTE9%TYPE;
2427: l_attribute10 OKC_K_ARTICLES_B.ATTRIBUTE10%TYPE;
2428: l_attribute11 OKC_K_ARTICLES_B.ATTRIBUTE11%TYPE;

Line 2425: l_attribute8 OKC_K_ARTICLES_B.ATTRIBUTE8%TYPE;

2421: l_attribute4 OKC_K_ARTICLES_B.ATTRIBUTE4%TYPE;
2422: l_attribute5 OKC_K_ARTICLES_B.ATTRIBUTE5%TYPE;
2423: l_attribute6 OKC_K_ARTICLES_B.ATTRIBUTE6%TYPE;
2424: l_attribute7 OKC_K_ARTICLES_B.ATTRIBUTE7%TYPE;
2425: l_attribute8 OKC_K_ARTICLES_B.ATTRIBUTE8%TYPE;
2426: l_attribute9 OKC_K_ARTICLES_B.ATTRIBUTE9%TYPE;
2427: l_attribute10 OKC_K_ARTICLES_B.ATTRIBUTE10%TYPE;
2428: l_attribute11 OKC_K_ARTICLES_B.ATTRIBUTE11%TYPE;
2429: l_attribute12 OKC_K_ARTICLES_B.ATTRIBUTE12%TYPE;

Line 2426: l_attribute9 OKC_K_ARTICLES_B.ATTRIBUTE9%TYPE;

2422: l_attribute5 OKC_K_ARTICLES_B.ATTRIBUTE5%TYPE;
2423: l_attribute6 OKC_K_ARTICLES_B.ATTRIBUTE6%TYPE;
2424: l_attribute7 OKC_K_ARTICLES_B.ATTRIBUTE7%TYPE;
2425: l_attribute8 OKC_K_ARTICLES_B.ATTRIBUTE8%TYPE;
2426: l_attribute9 OKC_K_ARTICLES_B.ATTRIBUTE9%TYPE;
2427: l_attribute10 OKC_K_ARTICLES_B.ATTRIBUTE10%TYPE;
2428: l_attribute11 OKC_K_ARTICLES_B.ATTRIBUTE11%TYPE;
2429: l_attribute12 OKC_K_ARTICLES_B.ATTRIBUTE12%TYPE;
2430: l_attribute13 OKC_K_ARTICLES_B.ATTRIBUTE13%TYPE;

Line 2427: l_attribute10 OKC_K_ARTICLES_B.ATTRIBUTE10%TYPE;

2423: l_attribute6 OKC_K_ARTICLES_B.ATTRIBUTE6%TYPE;
2424: l_attribute7 OKC_K_ARTICLES_B.ATTRIBUTE7%TYPE;
2425: l_attribute8 OKC_K_ARTICLES_B.ATTRIBUTE8%TYPE;
2426: l_attribute9 OKC_K_ARTICLES_B.ATTRIBUTE9%TYPE;
2427: l_attribute10 OKC_K_ARTICLES_B.ATTRIBUTE10%TYPE;
2428: l_attribute11 OKC_K_ARTICLES_B.ATTRIBUTE11%TYPE;
2429: l_attribute12 OKC_K_ARTICLES_B.ATTRIBUTE12%TYPE;
2430: l_attribute13 OKC_K_ARTICLES_B.ATTRIBUTE13%TYPE;
2431: l_attribute14 OKC_K_ARTICLES_B.ATTRIBUTE14%TYPE;

Line 2428: l_attribute11 OKC_K_ARTICLES_B.ATTRIBUTE11%TYPE;

2424: l_attribute7 OKC_K_ARTICLES_B.ATTRIBUTE7%TYPE;
2425: l_attribute8 OKC_K_ARTICLES_B.ATTRIBUTE8%TYPE;
2426: l_attribute9 OKC_K_ARTICLES_B.ATTRIBUTE9%TYPE;
2427: l_attribute10 OKC_K_ARTICLES_B.ATTRIBUTE10%TYPE;
2428: l_attribute11 OKC_K_ARTICLES_B.ATTRIBUTE11%TYPE;
2429: l_attribute12 OKC_K_ARTICLES_B.ATTRIBUTE12%TYPE;
2430: l_attribute13 OKC_K_ARTICLES_B.ATTRIBUTE13%TYPE;
2431: l_attribute14 OKC_K_ARTICLES_B.ATTRIBUTE14%TYPE;
2432: l_attribute15 OKC_K_ARTICLES_B.ATTRIBUTE15%TYPE;

Line 2429: l_attribute12 OKC_K_ARTICLES_B.ATTRIBUTE12%TYPE;

2425: l_attribute8 OKC_K_ARTICLES_B.ATTRIBUTE8%TYPE;
2426: l_attribute9 OKC_K_ARTICLES_B.ATTRIBUTE9%TYPE;
2427: l_attribute10 OKC_K_ARTICLES_B.ATTRIBUTE10%TYPE;
2428: l_attribute11 OKC_K_ARTICLES_B.ATTRIBUTE11%TYPE;
2429: l_attribute12 OKC_K_ARTICLES_B.ATTRIBUTE12%TYPE;
2430: l_attribute13 OKC_K_ARTICLES_B.ATTRIBUTE13%TYPE;
2431: l_attribute14 OKC_K_ARTICLES_B.ATTRIBUTE14%TYPE;
2432: l_attribute15 OKC_K_ARTICLES_B.ATTRIBUTE15%TYPE;
2433: l_print_text_yn OKC_K_ARTICLES_B.print_text_yn%TYPE;

Line 2430: l_attribute13 OKC_K_ARTICLES_B.ATTRIBUTE13%TYPE;

2426: l_attribute9 OKC_K_ARTICLES_B.ATTRIBUTE9%TYPE;
2427: l_attribute10 OKC_K_ARTICLES_B.ATTRIBUTE10%TYPE;
2428: l_attribute11 OKC_K_ARTICLES_B.ATTRIBUTE11%TYPE;
2429: l_attribute12 OKC_K_ARTICLES_B.ATTRIBUTE12%TYPE;
2430: l_attribute13 OKC_K_ARTICLES_B.ATTRIBUTE13%TYPE;
2431: l_attribute14 OKC_K_ARTICLES_B.ATTRIBUTE14%TYPE;
2432: l_attribute15 OKC_K_ARTICLES_B.ATTRIBUTE15%TYPE;
2433: l_print_text_yn OKC_K_ARTICLES_B.print_text_yn%TYPE;
2434: l_summary_amend_operation_code OKC_K_ARTICLES_B.summary_amend_operation_code%TYPE;

Line 2431: l_attribute14 OKC_K_ARTICLES_B.ATTRIBUTE14%TYPE;

2427: l_attribute10 OKC_K_ARTICLES_B.ATTRIBUTE10%TYPE;
2428: l_attribute11 OKC_K_ARTICLES_B.ATTRIBUTE11%TYPE;
2429: l_attribute12 OKC_K_ARTICLES_B.ATTRIBUTE12%TYPE;
2430: l_attribute13 OKC_K_ARTICLES_B.ATTRIBUTE13%TYPE;
2431: l_attribute14 OKC_K_ARTICLES_B.ATTRIBUTE14%TYPE;
2432: l_attribute15 OKC_K_ARTICLES_B.ATTRIBUTE15%TYPE;
2433: l_print_text_yn OKC_K_ARTICLES_B.print_text_yn%TYPE;
2434: l_summary_amend_operation_code OKC_K_ARTICLES_B.summary_amend_operation_code%TYPE;
2435: l_ref_article_id OKC_K_ARTICLES_B.ref_article_id%TYPE;

Line 2432: l_attribute15 OKC_K_ARTICLES_B.ATTRIBUTE15%TYPE;

2428: l_attribute11 OKC_K_ARTICLES_B.ATTRIBUTE11%TYPE;
2429: l_attribute12 OKC_K_ARTICLES_B.ATTRIBUTE12%TYPE;
2430: l_attribute13 OKC_K_ARTICLES_B.ATTRIBUTE13%TYPE;
2431: l_attribute14 OKC_K_ARTICLES_B.ATTRIBUTE14%TYPE;
2432: l_attribute15 OKC_K_ARTICLES_B.ATTRIBUTE15%TYPE;
2433: l_print_text_yn OKC_K_ARTICLES_B.print_text_yn%TYPE;
2434: l_summary_amend_operation_code OKC_K_ARTICLES_B.summary_amend_operation_code%TYPE;
2435: l_ref_article_id OKC_K_ARTICLES_B.ref_article_id%TYPE;
2436: l_ref_article_version_id OKC_K_ARTICLES_B.ref_article_version_id%TYPE;

Line 2433: l_print_text_yn OKC_K_ARTICLES_B.print_text_yn%TYPE;

2429: l_attribute12 OKC_K_ARTICLES_B.ATTRIBUTE12%TYPE;
2430: l_attribute13 OKC_K_ARTICLES_B.ATTRIBUTE13%TYPE;
2431: l_attribute14 OKC_K_ARTICLES_B.ATTRIBUTE14%TYPE;
2432: l_attribute15 OKC_K_ARTICLES_B.ATTRIBUTE15%TYPE;
2433: l_print_text_yn OKC_K_ARTICLES_B.print_text_yn%TYPE;
2434: l_summary_amend_operation_code OKC_K_ARTICLES_B.summary_amend_operation_code%TYPE;
2435: l_ref_article_id OKC_K_ARTICLES_B.ref_article_id%TYPE;
2436: l_ref_article_version_id OKC_K_ARTICLES_B.ref_article_version_id%TYPE;
2437: l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;

Line 2434: l_summary_amend_operation_code OKC_K_ARTICLES_B.summary_amend_operation_code%TYPE;

2430: l_attribute13 OKC_K_ARTICLES_B.ATTRIBUTE13%TYPE;
2431: l_attribute14 OKC_K_ARTICLES_B.ATTRIBUTE14%TYPE;
2432: l_attribute15 OKC_K_ARTICLES_B.ATTRIBUTE15%TYPE;
2433: l_print_text_yn OKC_K_ARTICLES_B.print_text_yn%TYPE;
2434: l_summary_amend_operation_code OKC_K_ARTICLES_B.summary_amend_operation_code%TYPE;
2435: l_ref_article_id OKC_K_ARTICLES_B.ref_article_id%TYPE;
2436: l_ref_article_version_id OKC_K_ARTICLES_B.ref_article_version_id%TYPE;
2437: l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;
2438: l_created_by OKC_K_ARTICLES_B.CREATED_BY%TYPE;

Line 2435: l_ref_article_id OKC_K_ARTICLES_B.ref_article_id%TYPE;

2431: l_attribute14 OKC_K_ARTICLES_B.ATTRIBUTE14%TYPE;
2432: l_attribute15 OKC_K_ARTICLES_B.ATTRIBUTE15%TYPE;
2433: l_print_text_yn OKC_K_ARTICLES_B.print_text_yn%TYPE;
2434: l_summary_amend_operation_code OKC_K_ARTICLES_B.summary_amend_operation_code%TYPE;
2435: l_ref_article_id OKC_K_ARTICLES_B.ref_article_id%TYPE;
2436: l_ref_article_version_id OKC_K_ARTICLES_B.ref_article_version_id%TYPE;
2437: l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;
2438: l_created_by OKC_K_ARTICLES_B.CREATED_BY%TYPE;
2439: l_creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE;

Line 2436: l_ref_article_version_id OKC_K_ARTICLES_B.ref_article_version_id%TYPE;

2432: l_attribute15 OKC_K_ARTICLES_B.ATTRIBUTE15%TYPE;
2433: l_print_text_yn OKC_K_ARTICLES_B.print_text_yn%TYPE;
2434: l_summary_amend_operation_code OKC_K_ARTICLES_B.summary_amend_operation_code%TYPE;
2435: l_ref_article_id OKC_K_ARTICLES_B.ref_article_id%TYPE;
2436: l_ref_article_version_id OKC_K_ARTICLES_B.ref_article_version_id%TYPE;
2437: l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;
2438: l_created_by OKC_K_ARTICLES_B.CREATED_BY%TYPE;
2439: l_creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE;
2440: l_last_updated_by OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;

Line 2437: l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;

2433: l_print_text_yn OKC_K_ARTICLES_B.print_text_yn%TYPE;
2434: l_summary_amend_operation_code OKC_K_ARTICLES_B.summary_amend_operation_code%TYPE;
2435: l_ref_article_id OKC_K_ARTICLES_B.ref_article_id%TYPE;
2436: l_ref_article_version_id OKC_K_ARTICLES_B.ref_article_version_id%TYPE;
2437: l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;
2438: l_created_by OKC_K_ARTICLES_B.CREATED_BY%TYPE;
2439: l_creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE;
2440: l_last_updated_by OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;
2441: l_last_update_login OKC_K_ARTICLES_B.LAST_UPDATE_LOGIN%TYPE;

Line 2438: l_created_by OKC_K_ARTICLES_B.CREATED_BY%TYPE;

2434: l_summary_amend_operation_code OKC_K_ARTICLES_B.summary_amend_operation_code%TYPE;
2435: l_ref_article_id OKC_K_ARTICLES_B.ref_article_id%TYPE;
2436: l_ref_article_version_id OKC_K_ARTICLES_B.ref_article_version_id%TYPE;
2437: l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;
2438: l_created_by OKC_K_ARTICLES_B.CREATED_BY%TYPE;
2439: l_creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE;
2440: l_last_updated_by OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;
2441: l_last_update_login OKC_K_ARTICLES_B.LAST_UPDATE_LOGIN%TYPE;
2442: l_last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE;

Line 2439: l_creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE;

2435: l_ref_article_id OKC_K_ARTICLES_B.ref_article_id%TYPE;
2436: l_ref_article_version_id OKC_K_ARTICLES_B.ref_article_version_id%TYPE;
2437: l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;
2438: l_created_by OKC_K_ARTICLES_B.CREATED_BY%TYPE;
2439: l_creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE;
2440: l_last_updated_by OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;
2441: l_last_update_login OKC_K_ARTICLES_B.LAST_UPDATE_LOGIN%TYPE;
2442: l_last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE;
2443: l_last_amended_by OKC_K_ARTICLES_B.LAST_AMENDED_BY%TYPE;

Line 2440: l_last_updated_by OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;

2436: l_ref_article_version_id OKC_K_ARTICLES_B.ref_article_version_id%TYPE;
2437: l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;
2438: l_created_by OKC_K_ARTICLES_B.CREATED_BY%TYPE;
2439: l_creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE;
2440: l_last_updated_by OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;
2441: l_last_update_login OKC_K_ARTICLES_B.LAST_UPDATE_LOGIN%TYPE;
2442: l_last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE;
2443: l_last_amended_by OKC_K_ARTICLES_B.LAST_AMENDED_BY%TYPE;
2444: l_last_amendment_date OKC_K_ARTICLES_B.LAST_AMENDMENT_DATE%TYPE;

Line 2441: l_last_update_login OKC_K_ARTICLES_B.LAST_UPDATE_LOGIN%TYPE;

2437: l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;
2438: l_created_by OKC_K_ARTICLES_B.CREATED_BY%TYPE;
2439: l_creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE;
2440: l_last_updated_by OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;
2441: l_last_update_login OKC_K_ARTICLES_B.LAST_UPDATE_LOGIN%TYPE;
2442: l_last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE;
2443: l_last_amended_by OKC_K_ARTICLES_B.LAST_AMENDED_BY%TYPE;
2444: l_last_amendment_date OKC_K_ARTICLES_B.LAST_AMENDMENT_DATE%TYPE;
2445:

Line 2442: l_last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE;

2438: l_created_by OKC_K_ARTICLES_B.CREATED_BY%TYPE;
2439: l_creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE;
2440: l_last_updated_by OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;
2441: l_last_update_login OKC_K_ARTICLES_B.LAST_UPDATE_LOGIN%TYPE;
2442: l_last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE;
2443: l_last_amended_by OKC_K_ARTICLES_B.LAST_AMENDED_BY%TYPE;
2444: l_last_amendment_date OKC_K_ARTICLES_B.LAST_AMENDMENT_DATE%TYPE;
2445:
2446: BEGIN

Line 2443: l_last_amended_by OKC_K_ARTICLES_B.LAST_AMENDED_BY%TYPE;

2439: l_creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE;
2440: l_last_updated_by OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;
2441: l_last_update_login OKC_K_ARTICLES_B.LAST_UPDATE_LOGIN%TYPE;
2442: l_last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE;
2443: l_last_amended_by OKC_K_ARTICLES_B.LAST_AMENDED_BY%TYPE;
2444: l_last_amendment_date OKC_K_ARTICLES_B.LAST_AMENDMENT_DATE%TYPE;
2445:
2446: BEGIN
2447:

Line 2444: l_last_amendment_date OKC_K_ARTICLES_B.LAST_AMENDMENT_DATE%TYPE;

2440: l_last_updated_by OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;
2441: l_last_update_login OKC_K_ARTICLES_B.LAST_UPDATE_LOGIN%TYPE;
2442: l_last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE;
2443: l_last_amended_by OKC_K_ARTICLES_B.LAST_AMENDED_BY%TYPE;
2444: l_last_amendment_date OKC_K_ARTICLES_B.LAST_AMENDMENT_DATE%TYPE;
2445:
2446: BEGIN
2447:
2448: IF (l_debug = 'Y') THEN

Line 2721: -- Delete_Row for:OKC_K_ARTICLES_B --

2717: ---------------------------------------------------------------------------
2718: -- PROCEDURE Delete_Row
2719: ---------------------------------------------------------------------------
2720: -------------------------------------
2721: -- Delete_Row for:OKC_K_ARTICLES_B --
2722: -------------------------------------
2723: FUNCTION Delete_Row(
2724: p_id IN NUMBER
2725: ) RETURN VARCHAR2 IS

Line 2733: DELETE FROM OKC_K_ARTICLES_B WHERE ID = p_ID;

2729: IF (l_debug = 'Y') THEN
2730: Okc_Debug.Log('6100: Entered Delete_Row', 2);
2731: END IF;
2732:
2733: DELETE FROM OKC_K_ARTICLES_B WHERE ID = p_ID;
2734:
2735: IF (l_debug = 'Y') THEN
2736: Okc_Debug.Log('6200: Leaving Delete_Row', 2);
2737: END IF;

Line 2759: -- Delete_Row for:OKC_K_ARTICLES_B --

2755: RETURN( G_RET_STS_UNEXP_ERROR );
2756:
2757: END Delete_Row;
2758: -------------------------------------
2759: -- Delete_Row for:OKC_K_ARTICLES_B --
2760: -------------------------------------
2761: PROCEDURE Delete_Row(
2762: x_return_status OUT NOCOPY VARCHAR2,
2763: p_id IN NUMBER,

Line 2779: FROM okc_k_articles_b kart,

2775: CURSOR l_art_csr (cp_id IN NUMBER) IS
2776: SELECT art.standard_yn,
2777: kart.sav_sae_id,
2778: kart.article_version_id
2779: FROM okc_k_articles_b kart,
2780: okc_articles_all art
2781: WHERE kart.id = cp_id
2782: AND art.article_id = kart.sav_sae_id;
2783:

Line 2786: FROM okc_k_articles_b

2782: AND art.article_id = kart.sav_sae_id;
2783:
2784: CURSOR l_non_std_exists_csr(cp_article_version_id IN NUMBER) IS
2785: SELECT 'Y'
2786: FROM okc_k_articles_b
2787: WHERE article_version_id = cp_article_version_id
2788: UNION ALL
2789: SELECT 'Y'
2790: FROM OKC_K_ARTICLES_BH

Line 2790: FROM OKC_K_ARTICLES_BH

2786: FROM okc_k_articles_b
2787: WHERE article_version_id = cp_article_version_id
2788: UNION ALL
2789: SELECT 'Y'
2790: FROM OKC_K_ARTICLES_BH
2791: WHERE article_version_id = cp_article_version_id;
2792:
2793: BEGIN
2794:

Line 2891: FROM OKC_K_ARTICLES_B

2887: p_scn_id IN NUMBER
2888: ) IS
2889: CURSOR lock_csr IS
2890: SELECT rowid
2891: FROM OKC_K_ARTICLES_B
2892: WHERE SCN_ID=P_SCN_ID
2893: FOR UPDATE NOWAIT;
2894: BEGIN
2895: IF (l_debug = 'Y') THEN

Line 2903: DELETE FROM OKC_K_ARTICLES_B

2899: -- making OPEN/CLOSE cursor to lock records
2900: OPEN lock_csr;
2901: CLOSE lock_csr;
2902:
2903: DELETE FROM OKC_K_ARTICLES_B
2904: WHERE SCN_ID=P_SCN_ID;
2905:
2906: IF (l_debug = 'Y') THEN
2907: Okc_Debug.Log('11000: Leaving Delete_set', 2);

Line 2967: FROM OKC_K_ARTICLES_B

2963: p_doc_id IN NUMBER
2964: ) IS
2965: CURSOR lock_csr IS
2966: SELECT rowid
2967: FROM OKC_K_ARTICLES_B
2968: WHERE DOCUMENT_TYPE=p_doc_type
2969: AND DOCUMENT_ID = p_doc_id
2970: FOR UPDATE NOWAIT;
2971:

Line 2983: DELETE FROM OKC_K_ARTICLES_B

2979: -- making OPEN/CLOSE cursor to lock records
2980: OPEN lock_csr;
2981: CLOSE lock_csr;
2982:
2983: DELETE FROM OKC_K_ARTICLES_B
2984: WHERE DOCUMENT_TYPE=p_doc_type
2985: AND DOCUMENT_ID = p_doc_id;
2986:
2987: IF (l_debug = 'Y') THEN

Line 3060: FROM OKC_K_ARTICLES_B KART,

3056: CURSOR non_std_csr IS
3057: SELECT KART.ID,
3058: KART.SAV_SAE_ID,
3059: KART.ARTICLE_VERSION_ID
3060: FROM OKC_K_ARTICLES_B KART,
3061: OKC_ARTICLES_ALL ART
3062: WHERE KART.document_type = p_doc_type
3063: AND KART.document_id = p_doc_id
3064: AND KART.SAV_SAE_ID = ART.ARTICLE_ID

Line 3076: INSERT INTO OKC_K_ARTICLES_BH (

3072:
3073: -----------------------------------------
3074: -- Saving Base Table
3075: -----------------------------------------
3076: INSERT INTO OKC_K_ARTICLES_BH (
3077: major_version,
3078: ID,
3079: SAV_SAE_ID,
3080: SAV_SAV_RELEASE,

Line 3186: FROM OKC_K_ARTICLES_B

3182: LAST_UPDATE_DATE,
3183: ORIG_ARTICLE_ID,
3184: LAST_AMENDED_BY,
3185: LAST_AMENDMENT_DATE
3186: FROM OKC_K_ARTICLES_B
3187: WHERE document_type = p_doc_type
3188: AND document_id = p_doc_id;
3189:
3190: IF (l_debug = 'Y') THEN

Line 3220: Okc_Debug.Log('6920: Before updating new Non-Std in the OKC_K_ARTICLES_B', 2);

3216: RAISE FND_API.G_EXC_ERROR;
3217: END IF;
3218:
3219: IF (l_debug = 'Y') THEN
3220: Okc_Debug.Log('6920: Before updating new Non-Std in the OKC_K_ARTICLES_B', 2);
3221: END IF;
3222:
3223:
3224: -----------------------------------------

Line 3225: -- Updating OKC_K_ARTICLES_B

3221: END IF;
3222:
3223:
3224: -----------------------------------------
3225: -- Updating OKC_K_ARTICLES_B
3226: -----------------------------------------
3227: UPDATE OKC_K_ARTICLES_B
3228: SET SAV_SAE_ID = l_article_id,
3229: ARTICLE_VERSION_ID = l_article_version_id

Line 3227: UPDATE OKC_K_ARTICLES_B

3223:
3224: -----------------------------------------
3225: -- Updating OKC_K_ARTICLES_B
3226: -----------------------------------------
3227: UPDATE OKC_K_ARTICLES_B
3228: SET SAV_SAE_ID = l_article_id,
3229: ARTICLE_VERSION_ID = l_article_version_id
3230: WHERE ID = rec.id;
3231:

Line 3233: Okc_Debug.Log('6930: After Updating Non-Std in OKC_K_ARTICLES_B', 2);

3229: ARTICLE_VERSION_ID = l_article_version_id
3230: WHERE ID = rec.id;
3231:
3232: IF (l_debug = 'Y') THEN
3233: Okc_Debug.Log('6930: After Updating Non-Std in OKC_K_ARTICLES_B', 2);
3234: END IF;
3235:
3236: END LOOP;
3237:

Line 3305: INSERT INTO OKC_K_ARTICLES_B (

3301:
3302: -----------------------------------------
3303: -- Restoring Base Table
3304: -----------------------------------------
3305: INSERT INTO OKC_K_ARTICLES_B (
3306: ID,
3307: SAV_SAE_ID,
3308: SAV_SAV_RELEASE,
3309: SBT_CODE,

Line 3413: FROM OKC_K_ARTICLES_BH

3409: LAST_UPDATE_DATE,
3410: ORIG_ARTICLE_ID,
3411: LAST_AMENDED_BY,
3412: LAST_AMENDMENT_DATE
3413: FROM OKC_K_ARTICLES_BH
3414: WHERE document_type = p_doc_type
3415: AND document_id = p_doc_id
3416: AND major_version = p_major_version;
3417:

Line 3461: FROM OKC_K_ARTICLES_BH

3457: -----------------------------------------
3458: -- Restoring Base Table
3459: -----------------------------------------
3460: DELETE
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: