[Home] [Help]
1: PACKAGE BODY OKC_ARTICLES_ALL_PVT AS
2: /* $Header: OKCVARTB.pls 120.1 2005/10/11 14:17:56 rvohra noship $ */
3:
4: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5:
26: G_RECORD_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_RECORD_VALID_LEVEL;
27: ---------------------------------------------------------------------------
28: -- GLOBAL VARIABLES
29: ---------------------------------------------------------------------------
30: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_ARTICLES_ALL_PVT';
31: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
32:
33: ------------------------------------------------------------------------------
34: -- GLOBAL CONSTANTS
56: p_article_id IN NUMBER,
57: x_article_id OUT NOCOPY NUMBER
58: ) RETURN VARCHAR2 IS
59: CURSOR l_seq_csr IS
60: SELECT OKC_ARTICLES_ALL_S1.NEXTVAL FROM DUAL;
61: BEGIN
62: IF (l_debug = 'Y') THEN
63: Okc_Debug.Log('100: Entered get_seq_id', 2);
64: END IF;
98:
99: END Get_Seq_Id;
100:
101: ---------------------------------------------------------------------------
102: -- FUNCTION get_rec for: OKC_ARTICLES_ALL
103: ---------------------------------------------------------------------------
104: FUNCTION Get_Rec (
105: p_article_id IN NUMBER,
106:
142: x_last_update_login OUT NOCOPY NUMBER,
143: x_last_update_date OUT NOCOPY DATE
144:
145: ) RETURN VARCHAR2 IS
146: CURSOR OKC_ARTICLES_ALL_pk_csr (cp_article_id IN NUMBER) IS
147: SELECT
148: ARTICLE_TITLE,
149: ORG_ID,
150: ARTICLE_NUMBER,
181: CREATION_DATE,
182: LAST_UPDATED_BY,
183: LAST_UPDATE_LOGIN,
184: LAST_UPDATE_DATE
185: FROM OKC_ARTICLES_ALL t
186: WHERE t.ARTICLE_ID = cp_article_id;
187: BEGIN
188:
189: IF (l_debug = 'Y') THEN
190: Okc_Debug.Log('400: Entered get_rec', 2);
191: END IF;
192:
193: -- Get current database values
194: OPEN OKC_ARTICLES_ALL_pk_csr (p_article_id);
195: FETCH OKC_ARTICLES_ALL_pk_csr INTO
196: x_article_title,
197: x_org_id,
198: x_article_number,
191: END IF;
192:
193: -- Get current database values
194: OPEN OKC_ARTICLES_ALL_pk_csr (p_article_id);
195: FETCH OKC_ARTICLES_ALL_pk_csr INTO
196: x_article_title,
197: x_org_id,
198: x_article_number,
199: x_standard_yn,
229: x_creation_date,
230: x_last_updated_by,
231: x_last_update_login,
232: x_last_update_date;
233: IF OKC_ARTICLES_ALL_pk_csr%NOTFOUND THEN
234: RAISE NO_DATA_FOUND;
235: END IF;
236: CLOSE OKC_ARTICLES_ALL_pk_csr;
237:
232: x_last_update_date;
233: IF OKC_ARTICLES_ALL_pk_csr%NOTFOUND THEN
234: RAISE NO_DATA_FOUND;
235: END IF;
236: CLOSE OKC_ARTICLES_ALL_pk_csr;
237:
238: IF (l_debug = 'Y') THEN
239: Okc_Debug.Log('500: Leaving get_rec ', 2);
240: END IF;
254: p_token1_value => sqlcode,
255: p_token2 => G_SQLERRM_TOKEN,
256: p_token2_value => sqlerrm);
257:
258: IF OKC_ARTICLES_ALL_pk_csr%ISOPEN THEN
259: CLOSE OKC_ARTICLES_ALL_pk_csr;
260: END IF;
261:
262: RETURN G_RET_STS_UNEXP_ERROR ;
255: p_token2 => G_SQLERRM_TOKEN,
256: p_token2_value => sqlerrm);
257:
258: IF OKC_ARTICLES_ALL_pk_csr%ISOPEN THEN
259: CLOSE OKC_ARTICLES_ALL_pk_csr;
260: END IF;
261:
262: RETURN G_RET_STS_UNEXP_ERROR ;
263:
263:
264: END Get_Rec;
265:
266: -----------------------------------------
267: -- Set_Attributes for:OKC_ARTICLES_ALL --
268: -----------------------------------------
269: FUNCTION Set_Attributes(
270: p_article_id IN NUMBER,
271: p_article_title IN VARCHAR2,
333: x_attribute14 OUT NOCOPY VARCHAR2,
334: x_attribute15 OUT NOCOPY VARCHAR2
335: ) RETURN VARCHAR2 IS
336: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
337: l_object_version_number OKC_ARTICLES_ALL.OBJECT_VERSION_NUMBER%TYPE;
338: l_created_by OKC_ARTICLES_ALL.CREATED_BY%TYPE;
339: l_creation_date OKC_ARTICLES_ALL.CREATION_DATE%TYPE;
340: l_last_updated_by OKC_ARTICLES_ALL.LAST_UPDATED_BY%TYPE;
341: l_last_update_login OKC_ARTICLES_ALL.LAST_UPDATE_LOGIN%TYPE;
334: x_attribute15 OUT NOCOPY VARCHAR2
335: ) RETURN VARCHAR2 IS
336: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
337: l_object_version_number OKC_ARTICLES_ALL.OBJECT_VERSION_NUMBER%TYPE;
338: l_created_by OKC_ARTICLES_ALL.CREATED_BY%TYPE;
339: l_creation_date OKC_ARTICLES_ALL.CREATION_DATE%TYPE;
340: l_last_updated_by OKC_ARTICLES_ALL.LAST_UPDATED_BY%TYPE;
341: l_last_update_login OKC_ARTICLES_ALL.LAST_UPDATE_LOGIN%TYPE;
342: l_last_update_date OKC_ARTICLES_ALL.LAST_UPDATE_DATE%TYPE;
335: ) RETURN VARCHAR2 IS
336: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
337: l_object_version_number OKC_ARTICLES_ALL.OBJECT_VERSION_NUMBER%TYPE;
338: l_created_by OKC_ARTICLES_ALL.CREATED_BY%TYPE;
339: l_creation_date OKC_ARTICLES_ALL.CREATION_DATE%TYPE;
340: l_last_updated_by OKC_ARTICLES_ALL.LAST_UPDATED_BY%TYPE;
341: l_last_update_login OKC_ARTICLES_ALL.LAST_UPDATE_LOGIN%TYPE;
342: l_last_update_date OKC_ARTICLES_ALL.LAST_UPDATE_DATE%TYPE;
343: BEGIN
336: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
337: l_object_version_number OKC_ARTICLES_ALL.OBJECT_VERSION_NUMBER%TYPE;
338: l_created_by OKC_ARTICLES_ALL.CREATED_BY%TYPE;
339: l_creation_date OKC_ARTICLES_ALL.CREATION_DATE%TYPE;
340: l_last_updated_by OKC_ARTICLES_ALL.LAST_UPDATED_BY%TYPE;
341: l_last_update_login OKC_ARTICLES_ALL.LAST_UPDATE_LOGIN%TYPE;
342: l_last_update_date OKC_ARTICLES_ALL.LAST_UPDATE_DATE%TYPE;
343: BEGIN
344: IF (l_debug = 'Y') THEN
337: l_object_version_number OKC_ARTICLES_ALL.OBJECT_VERSION_NUMBER%TYPE;
338: l_created_by OKC_ARTICLES_ALL.CREATED_BY%TYPE;
339: l_creation_date OKC_ARTICLES_ALL.CREATION_DATE%TYPE;
340: l_last_updated_by OKC_ARTICLES_ALL.LAST_UPDATED_BY%TYPE;
341: l_last_update_login OKC_ARTICLES_ALL.LAST_UPDATE_LOGIN%TYPE;
342: l_last_update_date OKC_ARTICLES_ALL.LAST_UPDATE_DATE%TYPE;
343: BEGIN
344: IF (l_debug = 'Y') THEN
345: Okc_Debug.Log('700: Entered Set_Attributes ', 2);
338: l_created_by OKC_ARTICLES_ALL.CREATED_BY%TYPE;
339: l_creation_date OKC_ARTICLES_ALL.CREATION_DATE%TYPE;
340: l_last_updated_by OKC_ARTICLES_ALL.LAST_UPDATED_BY%TYPE;
341: l_last_update_login OKC_ARTICLES_ALL.LAST_UPDATE_LOGIN%TYPE;
342: l_last_update_date OKC_ARTICLES_ALL.LAST_UPDATE_DATE%TYPE;
343: BEGIN
344: IF (l_debug = 'Y') THEN
345: Okc_Debug.Log('700: Entered Set_Attributes ', 2);
346: END IF;
659:
660: END Set_Attributes ;
661:
662: ----------------------------------------------
663: -- Validate_Attributes for: OKC_ARTICLES_ALL --
664: ----------------------------------------------
665: FUNCTION Validate_Attributes (
666: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
667: p_import_action IN VARCHAR2 := NULL,
702: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
703: l_tmp_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
704: l_dummy_var VARCHAR2(1) := '?';
705: l_doc_sequence_type VARCHAR2(1);
706: l_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE;
707:
708: CURSOR l_org_id_csr is
709: SELECT '!'
710: FROM HR_ALL_ORGANIZATION_UNITS
990: -- PROCEDURE Validate_Record
991: -- It calls Item Level Validations and then makes Record Level Validations
992: ---------------------------------------------------------------------------
993: ------------------------------------------
994: -- Validate_Record for:OKC_ARTICLES_ALL --
995: ------------------------------------------
996: FUNCTION Validate_Record (
997: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
998: p_import_action IN VARCHAR2 := NULL,
1037: l_row_found BOOLEAN := TRUE;
1038:
1039: -- The following cursor will check for duplicates of org_id and article_title
1040: CURSOR l_unq_csr(p_org_id IN NUMBER, p_article_id IN NUMBER, p_article_title IN VARCHAR2) is
1041: SELECT '1' FROM OKC_ARTICLES_ALL
1042: WHERE article_title = p_article_title
1043: AND org_id = p_org_id
1044: AND standard_yn = 'Y'
1045: AND article_id <> nvl(p_article_id,-99)
1045: AND article_id <> nvl(p_article_id,-99)
1046: AND rownum < 2
1047: UNION ALL
1048: SELECT '1'
1049: FROM okc_articles_all art, okc_article_adoptions adp, okc_article_versions artv
1050: WHERE adp.local_org_id = p_org_id
1051: AND art.article_title = p_article_title
1052: AND adp.adoption_type = 'ADOPTED'
1053: AND adp.global_article_version_id = artv.article_version_id
1174: ---------------------------------------------------------------------------
1175: -- PROCEDURE validate_row
1176: ---------------------------------------------------------------------------
1177: ---------------------------------------
1178: -- validate_row for:OKC_ARTICLES_ALL --
1179: ---------------------------------------
1180: PROCEDURE validate_row(
1181: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1182: p_import_action IN VARCHAR2 := NULL,
1218: p_attribute14 IN VARCHAR2 := NULL,
1219: p_attribute15 IN VARCHAR2 := NULL,
1220: p_object_version_number IN NUMBER := NULL
1221: ) IS
1222: l_article_title OKC_ARTICLES_ALL.ARTICLE_TITLE%TYPE;
1223: l_org_id OKC_ARTICLES_ALL.ORG_ID%TYPE;
1224: l_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE;
1225: l_standard_yn OKC_ARTICLES_ALL.STANDARD_YN%TYPE;
1226: l_article_intent OKC_ARTICLES_ALL.ARTICLE_INTENT%TYPE;
1219: p_attribute15 IN VARCHAR2 := NULL,
1220: p_object_version_number IN NUMBER := NULL
1221: ) IS
1222: l_article_title OKC_ARTICLES_ALL.ARTICLE_TITLE%TYPE;
1223: l_org_id OKC_ARTICLES_ALL.ORG_ID%TYPE;
1224: l_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE;
1225: l_standard_yn OKC_ARTICLES_ALL.STANDARD_YN%TYPE;
1226: l_article_intent OKC_ARTICLES_ALL.ARTICLE_INTENT%TYPE;
1227: l_article_language OKC_ARTICLES_ALL.ARTICLE_LANGUAGE%TYPE;
1220: p_object_version_number IN NUMBER := NULL
1221: ) IS
1222: l_article_title OKC_ARTICLES_ALL.ARTICLE_TITLE%TYPE;
1223: l_org_id OKC_ARTICLES_ALL.ORG_ID%TYPE;
1224: l_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE;
1225: l_standard_yn OKC_ARTICLES_ALL.STANDARD_YN%TYPE;
1226: l_article_intent OKC_ARTICLES_ALL.ARTICLE_INTENT%TYPE;
1227: l_article_language OKC_ARTICLES_ALL.ARTICLE_LANGUAGE%TYPE;
1228: l_article_type OKC_ARTICLES_ALL.ARTICLE_TYPE%TYPE;
1221: ) IS
1222: l_article_title OKC_ARTICLES_ALL.ARTICLE_TITLE%TYPE;
1223: l_org_id OKC_ARTICLES_ALL.ORG_ID%TYPE;
1224: l_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE;
1225: l_standard_yn OKC_ARTICLES_ALL.STANDARD_YN%TYPE;
1226: l_article_intent OKC_ARTICLES_ALL.ARTICLE_INTENT%TYPE;
1227: l_article_language OKC_ARTICLES_ALL.ARTICLE_LANGUAGE%TYPE;
1228: l_article_type OKC_ARTICLES_ALL.ARTICLE_TYPE%TYPE;
1229: l_orig_system_reference_code OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
1222: l_article_title OKC_ARTICLES_ALL.ARTICLE_TITLE%TYPE;
1223: l_org_id OKC_ARTICLES_ALL.ORG_ID%TYPE;
1224: l_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE;
1225: l_standard_yn OKC_ARTICLES_ALL.STANDARD_YN%TYPE;
1226: l_article_intent OKC_ARTICLES_ALL.ARTICLE_INTENT%TYPE;
1227: l_article_language OKC_ARTICLES_ALL.ARTICLE_LANGUAGE%TYPE;
1228: l_article_type OKC_ARTICLES_ALL.ARTICLE_TYPE%TYPE;
1229: l_orig_system_reference_code OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
1230: l_orig_system_reference_id1 OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
1223: l_org_id OKC_ARTICLES_ALL.ORG_ID%TYPE;
1224: l_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE;
1225: l_standard_yn OKC_ARTICLES_ALL.STANDARD_YN%TYPE;
1226: l_article_intent OKC_ARTICLES_ALL.ARTICLE_INTENT%TYPE;
1227: l_article_language OKC_ARTICLES_ALL.ARTICLE_LANGUAGE%TYPE;
1228: l_article_type OKC_ARTICLES_ALL.ARTICLE_TYPE%TYPE;
1229: l_orig_system_reference_code OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
1230: l_orig_system_reference_id1 OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
1231: l_orig_system_reference_id2 OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
1224: l_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE;
1225: l_standard_yn OKC_ARTICLES_ALL.STANDARD_YN%TYPE;
1226: l_article_intent OKC_ARTICLES_ALL.ARTICLE_INTENT%TYPE;
1227: l_article_language OKC_ARTICLES_ALL.ARTICLE_LANGUAGE%TYPE;
1228: l_article_type OKC_ARTICLES_ALL.ARTICLE_TYPE%TYPE;
1229: l_orig_system_reference_code OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
1230: l_orig_system_reference_id1 OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
1231: l_orig_system_reference_id2 OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
1232: l_cz_transfer_status_flag OKC_ARTICLES_ALL.CZ_TRANSFER_STATUS_FLAG%TYPE;
1225: l_standard_yn OKC_ARTICLES_ALL.STANDARD_YN%TYPE;
1226: l_article_intent OKC_ARTICLES_ALL.ARTICLE_INTENT%TYPE;
1227: l_article_language OKC_ARTICLES_ALL.ARTICLE_LANGUAGE%TYPE;
1228: l_article_type OKC_ARTICLES_ALL.ARTICLE_TYPE%TYPE;
1229: l_orig_system_reference_code OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
1230: l_orig_system_reference_id1 OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
1231: l_orig_system_reference_id2 OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
1232: l_cz_transfer_status_flag OKC_ARTICLES_ALL.CZ_TRANSFER_STATUS_FLAG%TYPE;
1233: l_program_id OKC_ARTICLES_ALL.PROGRAM_ID%TYPE;
1226: l_article_intent OKC_ARTICLES_ALL.ARTICLE_INTENT%TYPE;
1227: l_article_language OKC_ARTICLES_ALL.ARTICLE_LANGUAGE%TYPE;
1228: l_article_type OKC_ARTICLES_ALL.ARTICLE_TYPE%TYPE;
1229: l_orig_system_reference_code OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
1230: l_orig_system_reference_id1 OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
1231: l_orig_system_reference_id2 OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
1232: l_cz_transfer_status_flag OKC_ARTICLES_ALL.CZ_TRANSFER_STATUS_FLAG%TYPE;
1233: l_program_id OKC_ARTICLES_ALL.PROGRAM_ID%TYPE;
1234: l_program_login_id OKC_ARTICLES_ALL.PROGRAM_LOGIN_ID%TYPE;
1227: l_article_language OKC_ARTICLES_ALL.ARTICLE_LANGUAGE%TYPE;
1228: l_article_type OKC_ARTICLES_ALL.ARTICLE_TYPE%TYPE;
1229: l_orig_system_reference_code OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
1230: l_orig_system_reference_id1 OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
1231: l_orig_system_reference_id2 OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
1232: l_cz_transfer_status_flag OKC_ARTICLES_ALL.CZ_TRANSFER_STATUS_FLAG%TYPE;
1233: l_program_id OKC_ARTICLES_ALL.PROGRAM_ID%TYPE;
1234: l_program_login_id OKC_ARTICLES_ALL.PROGRAM_LOGIN_ID%TYPE;
1235: l_program_application_id OKC_ARTICLES_ALL.PROGRAM_APPLICATION_ID%TYPE;
1228: l_article_type OKC_ARTICLES_ALL.ARTICLE_TYPE%TYPE;
1229: l_orig_system_reference_code OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
1230: l_orig_system_reference_id1 OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
1231: l_orig_system_reference_id2 OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
1232: l_cz_transfer_status_flag OKC_ARTICLES_ALL.CZ_TRANSFER_STATUS_FLAG%TYPE;
1233: l_program_id OKC_ARTICLES_ALL.PROGRAM_ID%TYPE;
1234: l_program_login_id OKC_ARTICLES_ALL.PROGRAM_LOGIN_ID%TYPE;
1235: l_program_application_id OKC_ARTICLES_ALL.PROGRAM_APPLICATION_ID%TYPE;
1236: l_request_id OKC_ARTICLES_ALL.REQUEST_ID%TYPE;
1229: l_orig_system_reference_code OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
1230: l_orig_system_reference_id1 OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
1231: l_orig_system_reference_id2 OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
1232: l_cz_transfer_status_flag OKC_ARTICLES_ALL.CZ_TRANSFER_STATUS_FLAG%TYPE;
1233: l_program_id OKC_ARTICLES_ALL.PROGRAM_ID%TYPE;
1234: l_program_login_id OKC_ARTICLES_ALL.PROGRAM_LOGIN_ID%TYPE;
1235: l_program_application_id OKC_ARTICLES_ALL.PROGRAM_APPLICATION_ID%TYPE;
1236: l_request_id OKC_ARTICLES_ALL.REQUEST_ID%TYPE;
1237: l_attribute_category OKC_ARTICLES_ALL.ATTRIBUTE_CATEGORY%TYPE;
1230: l_orig_system_reference_id1 OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
1231: l_orig_system_reference_id2 OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
1232: l_cz_transfer_status_flag OKC_ARTICLES_ALL.CZ_TRANSFER_STATUS_FLAG%TYPE;
1233: l_program_id OKC_ARTICLES_ALL.PROGRAM_ID%TYPE;
1234: l_program_login_id OKC_ARTICLES_ALL.PROGRAM_LOGIN_ID%TYPE;
1235: l_program_application_id OKC_ARTICLES_ALL.PROGRAM_APPLICATION_ID%TYPE;
1236: l_request_id OKC_ARTICLES_ALL.REQUEST_ID%TYPE;
1237: l_attribute_category OKC_ARTICLES_ALL.ATTRIBUTE_CATEGORY%TYPE;
1238: l_attribute1 OKC_ARTICLES_ALL.ATTRIBUTE1%TYPE;
1231: l_orig_system_reference_id2 OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
1232: l_cz_transfer_status_flag OKC_ARTICLES_ALL.CZ_TRANSFER_STATUS_FLAG%TYPE;
1233: l_program_id OKC_ARTICLES_ALL.PROGRAM_ID%TYPE;
1234: l_program_login_id OKC_ARTICLES_ALL.PROGRAM_LOGIN_ID%TYPE;
1235: l_program_application_id OKC_ARTICLES_ALL.PROGRAM_APPLICATION_ID%TYPE;
1236: l_request_id OKC_ARTICLES_ALL.REQUEST_ID%TYPE;
1237: l_attribute_category OKC_ARTICLES_ALL.ATTRIBUTE_CATEGORY%TYPE;
1238: l_attribute1 OKC_ARTICLES_ALL.ATTRIBUTE1%TYPE;
1239: l_attribute2 OKC_ARTICLES_ALL.ATTRIBUTE2%TYPE;
1232: l_cz_transfer_status_flag OKC_ARTICLES_ALL.CZ_TRANSFER_STATUS_FLAG%TYPE;
1233: l_program_id OKC_ARTICLES_ALL.PROGRAM_ID%TYPE;
1234: l_program_login_id OKC_ARTICLES_ALL.PROGRAM_LOGIN_ID%TYPE;
1235: l_program_application_id OKC_ARTICLES_ALL.PROGRAM_APPLICATION_ID%TYPE;
1236: l_request_id OKC_ARTICLES_ALL.REQUEST_ID%TYPE;
1237: l_attribute_category OKC_ARTICLES_ALL.ATTRIBUTE_CATEGORY%TYPE;
1238: l_attribute1 OKC_ARTICLES_ALL.ATTRIBUTE1%TYPE;
1239: l_attribute2 OKC_ARTICLES_ALL.ATTRIBUTE2%TYPE;
1240: l_attribute3 OKC_ARTICLES_ALL.ATTRIBUTE3%TYPE;
1233: l_program_id OKC_ARTICLES_ALL.PROGRAM_ID%TYPE;
1234: l_program_login_id OKC_ARTICLES_ALL.PROGRAM_LOGIN_ID%TYPE;
1235: l_program_application_id OKC_ARTICLES_ALL.PROGRAM_APPLICATION_ID%TYPE;
1236: l_request_id OKC_ARTICLES_ALL.REQUEST_ID%TYPE;
1237: l_attribute_category OKC_ARTICLES_ALL.ATTRIBUTE_CATEGORY%TYPE;
1238: l_attribute1 OKC_ARTICLES_ALL.ATTRIBUTE1%TYPE;
1239: l_attribute2 OKC_ARTICLES_ALL.ATTRIBUTE2%TYPE;
1240: l_attribute3 OKC_ARTICLES_ALL.ATTRIBUTE3%TYPE;
1241: l_attribute4 OKC_ARTICLES_ALL.ATTRIBUTE4%TYPE;
1234: l_program_login_id OKC_ARTICLES_ALL.PROGRAM_LOGIN_ID%TYPE;
1235: l_program_application_id OKC_ARTICLES_ALL.PROGRAM_APPLICATION_ID%TYPE;
1236: l_request_id OKC_ARTICLES_ALL.REQUEST_ID%TYPE;
1237: l_attribute_category OKC_ARTICLES_ALL.ATTRIBUTE_CATEGORY%TYPE;
1238: l_attribute1 OKC_ARTICLES_ALL.ATTRIBUTE1%TYPE;
1239: l_attribute2 OKC_ARTICLES_ALL.ATTRIBUTE2%TYPE;
1240: l_attribute3 OKC_ARTICLES_ALL.ATTRIBUTE3%TYPE;
1241: l_attribute4 OKC_ARTICLES_ALL.ATTRIBUTE4%TYPE;
1242: l_attribute5 OKC_ARTICLES_ALL.ATTRIBUTE5%TYPE;
1235: l_program_application_id OKC_ARTICLES_ALL.PROGRAM_APPLICATION_ID%TYPE;
1236: l_request_id OKC_ARTICLES_ALL.REQUEST_ID%TYPE;
1237: l_attribute_category OKC_ARTICLES_ALL.ATTRIBUTE_CATEGORY%TYPE;
1238: l_attribute1 OKC_ARTICLES_ALL.ATTRIBUTE1%TYPE;
1239: l_attribute2 OKC_ARTICLES_ALL.ATTRIBUTE2%TYPE;
1240: l_attribute3 OKC_ARTICLES_ALL.ATTRIBUTE3%TYPE;
1241: l_attribute4 OKC_ARTICLES_ALL.ATTRIBUTE4%TYPE;
1242: l_attribute5 OKC_ARTICLES_ALL.ATTRIBUTE5%TYPE;
1243: l_attribute6 OKC_ARTICLES_ALL.ATTRIBUTE6%TYPE;
1236: l_request_id OKC_ARTICLES_ALL.REQUEST_ID%TYPE;
1237: l_attribute_category OKC_ARTICLES_ALL.ATTRIBUTE_CATEGORY%TYPE;
1238: l_attribute1 OKC_ARTICLES_ALL.ATTRIBUTE1%TYPE;
1239: l_attribute2 OKC_ARTICLES_ALL.ATTRIBUTE2%TYPE;
1240: l_attribute3 OKC_ARTICLES_ALL.ATTRIBUTE3%TYPE;
1241: l_attribute4 OKC_ARTICLES_ALL.ATTRIBUTE4%TYPE;
1242: l_attribute5 OKC_ARTICLES_ALL.ATTRIBUTE5%TYPE;
1243: l_attribute6 OKC_ARTICLES_ALL.ATTRIBUTE6%TYPE;
1244: l_attribute7 OKC_ARTICLES_ALL.ATTRIBUTE7%TYPE;
1237: l_attribute_category OKC_ARTICLES_ALL.ATTRIBUTE_CATEGORY%TYPE;
1238: l_attribute1 OKC_ARTICLES_ALL.ATTRIBUTE1%TYPE;
1239: l_attribute2 OKC_ARTICLES_ALL.ATTRIBUTE2%TYPE;
1240: l_attribute3 OKC_ARTICLES_ALL.ATTRIBUTE3%TYPE;
1241: l_attribute4 OKC_ARTICLES_ALL.ATTRIBUTE4%TYPE;
1242: l_attribute5 OKC_ARTICLES_ALL.ATTRIBUTE5%TYPE;
1243: l_attribute6 OKC_ARTICLES_ALL.ATTRIBUTE6%TYPE;
1244: l_attribute7 OKC_ARTICLES_ALL.ATTRIBUTE7%TYPE;
1245: l_attribute8 OKC_ARTICLES_ALL.ATTRIBUTE8%TYPE;
1238: l_attribute1 OKC_ARTICLES_ALL.ATTRIBUTE1%TYPE;
1239: l_attribute2 OKC_ARTICLES_ALL.ATTRIBUTE2%TYPE;
1240: l_attribute3 OKC_ARTICLES_ALL.ATTRIBUTE3%TYPE;
1241: l_attribute4 OKC_ARTICLES_ALL.ATTRIBUTE4%TYPE;
1242: l_attribute5 OKC_ARTICLES_ALL.ATTRIBUTE5%TYPE;
1243: l_attribute6 OKC_ARTICLES_ALL.ATTRIBUTE6%TYPE;
1244: l_attribute7 OKC_ARTICLES_ALL.ATTRIBUTE7%TYPE;
1245: l_attribute8 OKC_ARTICLES_ALL.ATTRIBUTE8%TYPE;
1246: l_attribute9 OKC_ARTICLES_ALL.ATTRIBUTE9%TYPE;
1239: l_attribute2 OKC_ARTICLES_ALL.ATTRIBUTE2%TYPE;
1240: l_attribute3 OKC_ARTICLES_ALL.ATTRIBUTE3%TYPE;
1241: l_attribute4 OKC_ARTICLES_ALL.ATTRIBUTE4%TYPE;
1242: l_attribute5 OKC_ARTICLES_ALL.ATTRIBUTE5%TYPE;
1243: l_attribute6 OKC_ARTICLES_ALL.ATTRIBUTE6%TYPE;
1244: l_attribute7 OKC_ARTICLES_ALL.ATTRIBUTE7%TYPE;
1245: l_attribute8 OKC_ARTICLES_ALL.ATTRIBUTE8%TYPE;
1246: l_attribute9 OKC_ARTICLES_ALL.ATTRIBUTE9%TYPE;
1247: l_attribute10 OKC_ARTICLES_ALL.ATTRIBUTE10%TYPE;
1240: l_attribute3 OKC_ARTICLES_ALL.ATTRIBUTE3%TYPE;
1241: l_attribute4 OKC_ARTICLES_ALL.ATTRIBUTE4%TYPE;
1242: l_attribute5 OKC_ARTICLES_ALL.ATTRIBUTE5%TYPE;
1243: l_attribute6 OKC_ARTICLES_ALL.ATTRIBUTE6%TYPE;
1244: l_attribute7 OKC_ARTICLES_ALL.ATTRIBUTE7%TYPE;
1245: l_attribute8 OKC_ARTICLES_ALL.ATTRIBUTE8%TYPE;
1246: l_attribute9 OKC_ARTICLES_ALL.ATTRIBUTE9%TYPE;
1247: l_attribute10 OKC_ARTICLES_ALL.ATTRIBUTE10%TYPE;
1248: l_attribute11 OKC_ARTICLES_ALL.ATTRIBUTE11%TYPE;
1241: l_attribute4 OKC_ARTICLES_ALL.ATTRIBUTE4%TYPE;
1242: l_attribute5 OKC_ARTICLES_ALL.ATTRIBUTE5%TYPE;
1243: l_attribute6 OKC_ARTICLES_ALL.ATTRIBUTE6%TYPE;
1244: l_attribute7 OKC_ARTICLES_ALL.ATTRIBUTE7%TYPE;
1245: l_attribute8 OKC_ARTICLES_ALL.ATTRIBUTE8%TYPE;
1246: l_attribute9 OKC_ARTICLES_ALL.ATTRIBUTE9%TYPE;
1247: l_attribute10 OKC_ARTICLES_ALL.ATTRIBUTE10%TYPE;
1248: l_attribute11 OKC_ARTICLES_ALL.ATTRIBUTE11%TYPE;
1249: l_attribute12 OKC_ARTICLES_ALL.ATTRIBUTE12%TYPE;
1242: l_attribute5 OKC_ARTICLES_ALL.ATTRIBUTE5%TYPE;
1243: l_attribute6 OKC_ARTICLES_ALL.ATTRIBUTE6%TYPE;
1244: l_attribute7 OKC_ARTICLES_ALL.ATTRIBUTE7%TYPE;
1245: l_attribute8 OKC_ARTICLES_ALL.ATTRIBUTE8%TYPE;
1246: l_attribute9 OKC_ARTICLES_ALL.ATTRIBUTE9%TYPE;
1247: l_attribute10 OKC_ARTICLES_ALL.ATTRIBUTE10%TYPE;
1248: l_attribute11 OKC_ARTICLES_ALL.ATTRIBUTE11%TYPE;
1249: l_attribute12 OKC_ARTICLES_ALL.ATTRIBUTE12%TYPE;
1250: l_attribute13 OKC_ARTICLES_ALL.ATTRIBUTE13%TYPE;
1243: l_attribute6 OKC_ARTICLES_ALL.ATTRIBUTE6%TYPE;
1244: l_attribute7 OKC_ARTICLES_ALL.ATTRIBUTE7%TYPE;
1245: l_attribute8 OKC_ARTICLES_ALL.ATTRIBUTE8%TYPE;
1246: l_attribute9 OKC_ARTICLES_ALL.ATTRIBUTE9%TYPE;
1247: l_attribute10 OKC_ARTICLES_ALL.ATTRIBUTE10%TYPE;
1248: l_attribute11 OKC_ARTICLES_ALL.ATTRIBUTE11%TYPE;
1249: l_attribute12 OKC_ARTICLES_ALL.ATTRIBUTE12%TYPE;
1250: l_attribute13 OKC_ARTICLES_ALL.ATTRIBUTE13%TYPE;
1251: l_attribute14 OKC_ARTICLES_ALL.ATTRIBUTE14%TYPE;
1244: l_attribute7 OKC_ARTICLES_ALL.ATTRIBUTE7%TYPE;
1245: l_attribute8 OKC_ARTICLES_ALL.ATTRIBUTE8%TYPE;
1246: l_attribute9 OKC_ARTICLES_ALL.ATTRIBUTE9%TYPE;
1247: l_attribute10 OKC_ARTICLES_ALL.ATTRIBUTE10%TYPE;
1248: l_attribute11 OKC_ARTICLES_ALL.ATTRIBUTE11%TYPE;
1249: l_attribute12 OKC_ARTICLES_ALL.ATTRIBUTE12%TYPE;
1250: l_attribute13 OKC_ARTICLES_ALL.ATTRIBUTE13%TYPE;
1251: l_attribute14 OKC_ARTICLES_ALL.ATTRIBUTE14%TYPE;
1252: l_attribute15 OKC_ARTICLES_ALL.ATTRIBUTE15%TYPE;
1245: l_attribute8 OKC_ARTICLES_ALL.ATTRIBUTE8%TYPE;
1246: l_attribute9 OKC_ARTICLES_ALL.ATTRIBUTE9%TYPE;
1247: l_attribute10 OKC_ARTICLES_ALL.ATTRIBUTE10%TYPE;
1248: l_attribute11 OKC_ARTICLES_ALL.ATTRIBUTE11%TYPE;
1249: l_attribute12 OKC_ARTICLES_ALL.ATTRIBUTE12%TYPE;
1250: l_attribute13 OKC_ARTICLES_ALL.ATTRIBUTE13%TYPE;
1251: l_attribute14 OKC_ARTICLES_ALL.ATTRIBUTE14%TYPE;
1252: l_attribute15 OKC_ARTICLES_ALL.ATTRIBUTE15%TYPE;
1253: l_object_version_number OKC_ARTICLES_ALL.OBJECT_VERSION_NUMBER%TYPE;
1246: l_attribute9 OKC_ARTICLES_ALL.ATTRIBUTE9%TYPE;
1247: l_attribute10 OKC_ARTICLES_ALL.ATTRIBUTE10%TYPE;
1248: l_attribute11 OKC_ARTICLES_ALL.ATTRIBUTE11%TYPE;
1249: l_attribute12 OKC_ARTICLES_ALL.ATTRIBUTE12%TYPE;
1250: l_attribute13 OKC_ARTICLES_ALL.ATTRIBUTE13%TYPE;
1251: l_attribute14 OKC_ARTICLES_ALL.ATTRIBUTE14%TYPE;
1252: l_attribute15 OKC_ARTICLES_ALL.ATTRIBUTE15%TYPE;
1253: l_object_version_number OKC_ARTICLES_ALL.OBJECT_VERSION_NUMBER%TYPE;
1254: l_created_by OKC_ARTICLES_ALL.CREATED_BY%TYPE;
1247: l_attribute10 OKC_ARTICLES_ALL.ATTRIBUTE10%TYPE;
1248: l_attribute11 OKC_ARTICLES_ALL.ATTRIBUTE11%TYPE;
1249: l_attribute12 OKC_ARTICLES_ALL.ATTRIBUTE12%TYPE;
1250: l_attribute13 OKC_ARTICLES_ALL.ATTRIBUTE13%TYPE;
1251: l_attribute14 OKC_ARTICLES_ALL.ATTRIBUTE14%TYPE;
1252: l_attribute15 OKC_ARTICLES_ALL.ATTRIBUTE15%TYPE;
1253: l_object_version_number OKC_ARTICLES_ALL.OBJECT_VERSION_NUMBER%TYPE;
1254: l_created_by OKC_ARTICLES_ALL.CREATED_BY%TYPE;
1255: l_creation_date OKC_ARTICLES_ALL.CREATION_DATE%TYPE;
1248: l_attribute11 OKC_ARTICLES_ALL.ATTRIBUTE11%TYPE;
1249: l_attribute12 OKC_ARTICLES_ALL.ATTRIBUTE12%TYPE;
1250: l_attribute13 OKC_ARTICLES_ALL.ATTRIBUTE13%TYPE;
1251: l_attribute14 OKC_ARTICLES_ALL.ATTRIBUTE14%TYPE;
1252: l_attribute15 OKC_ARTICLES_ALL.ATTRIBUTE15%TYPE;
1253: l_object_version_number OKC_ARTICLES_ALL.OBJECT_VERSION_NUMBER%TYPE;
1254: l_created_by OKC_ARTICLES_ALL.CREATED_BY%TYPE;
1255: l_creation_date OKC_ARTICLES_ALL.CREATION_DATE%TYPE;
1256: l_last_updated_by OKC_ARTICLES_ALL.LAST_UPDATED_BY%TYPE;
1249: l_attribute12 OKC_ARTICLES_ALL.ATTRIBUTE12%TYPE;
1250: l_attribute13 OKC_ARTICLES_ALL.ATTRIBUTE13%TYPE;
1251: l_attribute14 OKC_ARTICLES_ALL.ATTRIBUTE14%TYPE;
1252: l_attribute15 OKC_ARTICLES_ALL.ATTRIBUTE15%TYPE;
1253: l_object_version_number OKC_ARTICLES_ALL.OBJECT_VERSION_NUMBER%TYPE;
1254: l_created_by OKC_ARTICLES_ALL.CREATED_BY%TYPE;
1255: l_creation_date OKC_ARTICLES_ALL.CREATION_DATE%TYPE;
1256: l_last_updated_by OKC_ARTICLES_ALL.LAST_UPDATED_BY%TYPE;
1257: l_last_update_login OKC_ARTICLES_ALL.LAST_UPDATE_LOGIN%TYPE;
1250: l_attribute13 OKC_ARTICLES_ALL.ATTRIBUTE13%TYPE;
1251: l_attribute14 OKC_ARTICLES_ALL.ATTRIBUTE14%TYPE;
1252: l_attribute15 OKC_ARTICLES_ALL.ATTRIBUTE15%TYPE;
1253: l_object_version_number OKC_ARTICLES_ALL.OBJECT_VERSION_NUMBER%TYPE;
1254: l_created_by OKC_ARTICLES_ALL.CREATED_BY%TYPE;
1255: l_creation_date OKC_ARTICLES_ALL.CREATION_DATE%TYPE;
1256: l_last_updated_by OKC_ARTICLES_ALL.LAST_UPDATED_BY%TYPE;
1257: l_last_update_login OKC_ARTICLES_ALL.LAST_UPDATE_LOGIN%TYPE;
1258: l_last_update_date OKC_ARTICLES_ALL.LAST_UPDATE_DATE%TYPE;
1251: l_attribute14 OKC_ARTICLES_ALL.ATTRIBUTE14%TYPE;
1252: l_attribute15 OKC_ARTICLES_ALL.ATTRIBUTE15%TYPE;
1253: l_object_version_number OKC_ARTICLES_ALL.OBJECT_VERSION_NUMBER%TYPE;
1254: l_created_by OKC_ARTICLES_ALL.CREATED_BY%TYPE;
1255: l_creation_date OKC_ARTICLES_ALL.CREATION_DATE%TYPE;
1256: l_last_updated_by OKC_ARTICLES_ALL.LAST_UPDATED_BY%TYPE;
1257: l_last_update_login OKC_ARTICLES_ALL.LAST_UPDATE_LOGIN%TYPE;
1258: l_last_update_date OKC_ARTICLES_ALL.LAST_UPDATE_DATE%TYPE;
1259: BEGIN
1252: l_attribute15 OKC_ARTICLES_ALL.ATTRIBUTE15%TYPE;
1253: l_object_version_number OKC_ARTICLES_ALL.OBJECT_VERSION_NUMBER%TYPE;
1254: l_created_by OKC_ARTICLES_ALL.CREATED_BY%TYPE;
1255: l_creation_date OKC_ARTICLES_ALL.CREATION_DATE%TYPE;
1256: l_last_updated_by OKC_ARTICLES_ALL.LAST_UPDATED_BY%TYPE;
1257: l_last_update_login OKC_ARTICLES_ALL.LAST_UPDATE_LOGIN%TYPE;
1258: l_last_update_date OKC_ARTICLES_ALL.LAST_UPDATE_DATE%TYPE;
1259: BEGIN
1260:
1253: l_object_version_number OKC_ARTICLES_ALL.OBJECT_VERSION_NUMBER%TYPE;
1254: l_created_by OKC_ARTICLES_ALL.CREATED_BY%TYPE;
1255: l_creation_date OKC_ARTICLES_ALL.CREATION_DATE%TYPE;
1256: l_last_updated_by OKC_ARTICLES_ALL.LAST_UPDATED_BY%TYPE;
1257: l_last_update_login OKC_ARTICLES_ALL.LAST_UPDATE_LOGIN%TYPE;
1258: l_last_update_date OKC_ARTICLES_ALL.LAST_UPDATE_DATE%TYPE;
1259: BEGIN
1260:
1261: IF (l_debug = 'Y') THEN
1254: l_created_by OKC_ARTICLES_ALL.CREATED_BY%TYPE;
1255: l_creation_date OKC_ARTICLES_ALL.CREATION_DATE%TYPE;
1256: l_last_updated_by OKC_ARTICLES_ALL.LAST_UPDATED_BY%TYPE;
1257: l_last_update_login OKC_ARTICLES_ALL.LAST_UPDATE_LOGIN%TYPE;
1258: l_last_update_date OKC_ARTICLES_ALL.LAST_UPDATE_DATE%TYPE;
1259: BEGIN
1260:
1261: IF (l_debug = 'Y') THEN
1262: Okc_Debug.Log('3100: Entered validate_row', 2);
1441: ---------------------------------------------------------------------------
1442: -- PROCEDURE Insert_Row
1443: ---------------------------------------------------------------------------
1444: -------------------------------------
1445: -- Insert_Row for:OKC_ARTICLES_ALL --
1446: -------------------------------------
1447: FUNCTION Insert_Row(
1448: p_article_id IN NUMBER,
1449: p_article_title IN VARCHAR2,
1486:
1487: ) RETURN VARCHAR2 IS
1488:
1489:
1490: l_program_id OKC_ARTICLES_ALL.PROGRAM_ID%TYPE;
1491: l_program_login_id OKC_ARTICLES_ALL.PROGRAM_LOGIN_ID%TYPE;
1492: l_program_appl_id OKC_ARTICLES_ALL.PROGRAM_APPLICATION_ID%TYPE;
1493: l_request_id OKC_ARTICLES_ALL.REQUEST_ID%TYPE;
1494:
1487: ) RETURN VARCHAR2 IS
1488:
1489:
1490: l_program_id OKC_ARTICLES_ALL.PROGRAM_ID%TYPE;
1491: l_program_login_id OKC_ARTICLES_ALL.PROGRAM_LOGIN_ID%TYPE;
1492: l_program_appl_id OKC_ARTICLES_ALL.PROGRAM_APPLICATION_ID%TYPE;
1493: l_request_id OKC_ARTICLES_ALL.REQUEST_ID%TYPE;
1494:
1495: BEGIN
1488:
1489:
1490: l_program_id OKC_ARTICLES_ALL.PROGRAM_ID%TYPE;
1491: l_program_login_id OKC_ARTICLES_ALL.PROGRAM_LOGIN_ID%TYPE;
1492: l_program_appl_id OKC_ARTICLES_ALL.PROGRAM_APPLICATION_ID%TYPE;
1493: l_request_id OKC_ARTICLES_ALL.REQUEST_ID%TYPE;
1494:
1495: BEGIN
1496:
1489:
1490: l_program_id OKC_ARTICLES_ALL.PROGRAM_ID%TYPE;
1491: l_program_login_id OKC_ARTICLES_ALL.PROGRAM_LOGIN_ID%TYPE;
1492: l_program_appl_id OKC_ARTICLES_ALL.PROGRAM_APPLICATION_ID%TYPE;
1493: l_request_id OKC_ARTICLES_ALL.REQUEST_ID%TYPE;
1494:
1495: BEGIN
1496:
1497: IF (l_debug = 'Y') THEN
1517: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
1518: END IF;
1519:
1520:
1521: INSERT INTO OKC_ARTICLES_ALL(
1522: ARTICLE_ID,
1523: ARTICLE_TITLE,
1524: ORG_ID,
1525: ARTICLE_NUMBER,
1622: END Insert_Row;
1623:
1624:
1625: -------------------------------------
1626: -- Insert_Row for:OKC_ARTICLES_ALL --
1627: -------------------------------------
1628: PROCEDURE Insert_Row(
1629: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1630: x_return_status OUT NOCOPY VARCHAR2,
1667: x_article_id OUT NOCOPY NUMBER
1668:
1669: ) IS
1670:
1671: l_object_version_number OKC_ARTICLES_ALL.OBJECT_VERSION_NUMBER%TYPE;
1672: l_created_by OKC_ARTICLES_ALL.CREATED_BY%TYPE;
1673: l_creation_date OKC_ARTICLES_ALL.CREATION_DATE%TYPE;
1674: l_last_updated_by OKC_ARTICLES_ALL.LAST_UPDATED_BY%TYPE;
1675: l_last_update_login OKC_ARTICLES_ALL.LAST_UPDATE_LOGIN%TYPE;
1668:
1669: ) IS
1670:
1671: l_object_version_number OKC_ARTICLES_ALL.OBJECT_VERSION_NUMBER%TYPE;
1672: l_created_by OKC_ARTICLES_ALL.CREATED_BY%TYPE;
1673: l_creation_date OKC_ARTICLES_ALL.CREATION_DATE%TYPE;
1674: l_last_updated_by OKC_ARTICLES_ALL.LAST_UPDATED_BY%TYPE;
1675: l_last_update_login OKC_ARTICLES_ALL.LAST_UPDATE_LOGIN%TYPE;
1676: l_last_update_date OKC_ARTICLES_ALL.LAST_UPDATE_DATE%TYPE;
1669: ) IS
1670:
1671: l_object_version_number OKC_ARTICLES_ALL.OBJECT_VERSION_NUMBER%TYPE;
1672: l_created_by OKC_ARTICLES_ALL.CREATED_BY%TYPE;
1673: l_creation_date OKC_ARTICLES_ALL.CREATION_DATE%TYPE;
1674: l_last_updated_by OKC_ARTICLES_ALL.LAST_UPDATED_BY%TYPE;
1675: l_last_update_login OKC_ARTICLES_ALL.LAST_UPDATE_LOGIN%TYPE;
1676: l_last_update_date OKC_ARTICLES_ALL.LAST_UPDATE_DATE%TYPE;
1677:
1670:
1671: l_object_version_number OKC_ARTICLES_ALL.OBJECT_VERSION_NUMBER%TYPE;
1672: l_created_by OKC_ARTICLES_ALL.CREATED_BY%TYPE;
1673: l_creation_date OKC_ARTICLES_ALL.CREATION_DATE%TYPE;
1674: l_last_updated_by OKC_ARTICLES_ALL.LAST_UPDATED_BY%TYPE;
1675: l_last_update_login OKC_ARTICLES_ALL.LAST_UPDATE_LOGIN%TYPE;
1676: l_last_update_date OKC_ARTICLES_ALL.LAST_UPDATE_DATE%TYPE;
1677:
1678:
1671: l_object_version_number OKC_ARTICLES_ALL.OBJECT_VERSION_NUMBER%TYPE;
1672: l_created_by OKC_ARTICLES_ALL.CREATED_BY%TYPE;
1673: l_creation_date OKC_ARTICLES_ALL.CREATION_DATE%TYPE;
1674: l_last_updated_by OKC_ARTICLES_ALL.LAST_UPDATED_BY%TYPE;
1675: l_last_update_login OKC_ARTICLES_ALL.LAST_UPDATE_LOGIN%TYPE;
1676: l_last_update_date OKC_ARTICLES_ALL.LAST_UPDATE_DATE%TYPE;
1677:
1678:
1679: BEGIN
1672: l_created_by OKC_ARTICLES_ALL.CREATED_BY%TYPE;
1673: l_creation_date OKC_ARTICLES_ALL.CREATION_DATE%TYPE;
1674: l_last_updated_by OKC_ARTICLES_ALL.LAST_UPDATED_BY%TYPE;
1675: l_last_update_login OKC_ARTICLES_ALL.LAST_UPDATE_LOGIN%TYPE;
1676: l_last_update_date OKC_ARTICLES_ALL.LAST_UPDATE_DATE%TYPE;
1677:
1678:
1679: BEGIN
1680:
1840: ---------------------------------------------------------------------------
1841: -- PROCEDURE Lock_Row
1842: ---------------------------------------------------------------------------
1843: -----------------------------------
1844: -- Lock_Row for:OKC_ARTICLES_ALL --
1845: -----------------------------------
1846: FUNCTION Lock_Row(
1847: p_article_id IN NUMBER,
1848: p_object_version_number IN NUMBER
1852: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1853:
1854: CURSOR lock_csr (cp_article_id NUMBER, cp_object_version_number NUMBER) IS
1855: SELECT object_version_number
1856: FROM OKC_ARTICLES_ALL
1857: WHERE ARTICLE_ID = cp_article_id
1858: AND (object_version_number = cp_object_version_number OR cp_object_version_number IS NULL)
1859: FOR UPDATE OF object_version_number NOWAIT;
1860:
1859: FOR UPDATE OF object_version_number NOWAIT;
1860:
1861: CURSOR lchk_csr (cp_article_id NUMBER) IS
1862: SELECT object_version_number
1863: FROM OKC_ARTICLES_ALL
1864: WHERE ARTICLE_ID = cp_article_id;
1865:
1866: l_return_status VARCHAR2(1);
1867:
1864: WHERE ARTICLE_ID = cp_article_id;
1865:
1866: l_return_status VARCHAR2(1);
1867:
1868: l_object_version_number OKC_ARTICLES_ALL.OBJECT_VERSION_NUMBER%TYPE;
1869:
1870: l_row_notfound BOOLEAN := FALSE;
1871: BEGIN
1872:
1947: RETURN( G_RET_STS_UNEXP_ERROR );
1948: END Lock_Row;
1949:
1950: -----------------------------------
1951: -- Lock_Row for:OKC_ARTICLES_ALL --
1952: -----------------------------------
1953: PROCEDURE Lock_Row(
1954: x_return_status OUT NOCOPY VARCHAR2,
1955:
2011: ---------------------------------------------------------------------------
2012: -- PROCEDURE Update_Row
2013: ---------------------------------------------------------------------------
2014: -------------------------------------
2015: -- Update_Row for:OKC_ARTICLES_ALL --
2016: -------------------------------------
2017: FUNCTION Update_Row(
2018: p_article_id IN NUMBER,
2019: p_article_title IN VARCHAR2,
2055: p_last_update_date IN DATE
2056: ) RETURN VARCHAR2 IS
2057:
2058:
2059: l_program_id OKC_ARTICLES_ALL.PROGRAM_ID%TYPE;
2060: l_program_login_id OKC_ARTICLES_ALL.PROGRAM_LOGIN_ID%TYPE;
2061: l_program_appl_id OKC_ARTICLES_ALL.PROGRAM_APPLICATION_ID%TYPE;
2062: l_request_id OKC_ARTICLES_ALL.REQUEST_ID%TYPE;
2063:
2056: ) RETURN VARCHAR2 IS
2057:
2058:
2059: l_program_id OKC_ARTICLES_ALL.PROGRAM_ID%TYPE;
2060: l_program_login_id OKC_ARTICLES_ALL.PROGRAM_LOGIN_ID%TYPE;
2061: l_program_appl_id OKC_ARTICLES_ALL.PROGRAM_APPLICATION_ID%TYPE;
2062: l_request_id OKC_ARTICLES_ALL.REQUEST_ID%TYPE;
2063:
2064: BEGIN
2057:
2058:
2059: l_program_id OKC_ARTICLES_ALL.PROGRAM_ID%TYPE;
2060: l_program_login_id OKC_ARTICLES_ALL.PROGRAM_LOGIN_ID%TYPE;
2061: l_program_appl_id OKC_ARTICLES_ALL.PROGRAM_APPLICATION_ID%TYPE;
2062: l_request_id OKC_ARTICLES_ALL.REQUEST_ID%TYPE;
2063:
2064: BEGIN
2065:
2058:
2059: l_program_id OKC_ARTICLES_ALL.PROGRAM_ID%TYPE;
2060: l_program_login_id OKC_ARTICLES_ALL.PROGRAM_LOGIN_ID%TYPE;
2061: l_program_appl_id OKC_ARTICLES_ALL.PROGRAM_APPLICATION_ID%TYPE;
2062: l_request_id OKC_ARTICLES_ALL.REQUEST_ID%TYPE;
2063:
2064: BEGIN
2065:
2066: IF (l_debug = 'Y') THEN
2085: ELSE
2086: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
2087: END IF;
2088:
2089: UPDATE OKC_ARTICLES_ALL
2090: SET ARTICLE_TITLE = p_article_title,
2091: -- ORG_ID = p_org_id,
2092: ARTICLE_NUMBER = p_article_number,
2093: STANDARD_YN = p_standard_yn,
2155:
2156: END Update_Row;
2157:
2158: -------------------------------------
2159: -- Update_Row for:OKC_ARTICLES_ALL --
2160: -------------------------------------
2161: PROCEDURE Update_Row(
2162: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2163:
2201: p_object_version_number IN NUMBER
2202:
2203: ) IS
2204:
2205: l_article_title OKC_ARTICLES_ALL.ARTICLE_TITLE%TYPE;
2206: l_org_id OKC_ARTICLES_ALL.ORG_ID%TYPE;
2207: l_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE;
2208: l_standard_yn OKC_ARTICLES_ALL.STANDARD_YN%TYPE;
2209: l_article_intent OKC_ARTICLES_ALL.ARTICLE_INTENT%TYPE;
2202:
2203: ) IS
2204:
2205: l_article_title OKC_ARTICLES_ALL.ARTICLE_TITLE%TYPE;
2206: l_org_id OKC_ARTICLES_ALL.ORG_ID%TYPE;
2207: l_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE;
2208: l_standard_yn OKC_ARTICLES_ALL.STANDARD_YN%TYPE;
2209: l_article_intent OKC_ARTICLES_ALL.ARTICLE_INTENT%TYPE;
2210: l_article_language OKC_ARTICLES_ALL.ARTICLE_LANGUAGE%TYPE;
2203: ) IS
2204:
2205: l_article_title OKC_ARTICLES_ALL.ARTICLE_TITLE%TYPE;
2206: l_org_id OKC_ARTICLES_ALL.ORG_ID%TYPE;
2207: l_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE;
2208: l_standard_yn OKC_ARTICLES_ALL.STANDARD_YN%TYPE;
2209: l_article_intent OKC_ARTICLES_ALL.ARTICLE_INTENT%TYPE;
2210: l_article_language OKC_ARTICLES_ALL.ARTICLE_LANGUAGE%TYPE;
2211: l_article_type OKC_ARTICLES_ALL.ARTICLE_TYPE%TYPE;
2204:
2205: l_article_title OKC_ARTICLES_ALL.ARTICLE_TITLE%TYPE;
2206: l_org_id OKC_ARTICLES_ALL.ORG_ID%TYPE;
2207: l_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE;
2208: l_standard_yn OKC_ARTICLES_ALL.STANDARD_YN%TYPE;
2209: l_article_intent OKC_ARTICLES_ALL.ARTICLE_INTENT%TYPE;
2210: l_article_language OKC_ARTICLES_ALL.ARTICLE_LANGUAGE%TYPE;
2211: l_article_type OKC_ARTICLES_ALL.ARTICLE_TYPE%TYPE;
2212: l_orig_system_reference_code OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
2205: l_article_title OKC_ARTICLES_ALL.ARTICLE_TITLE%TYPE;
2206: l_org_id OKC_ARTICLES_ALL.ORG_ID%TYPE;
2207: l_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE;
2208: l_standard_yn OKC_ARTICLES_ALL.STANDARD_YN%TYPE;
2209: l_article_intent OKC_ARTICLES_ALL.ARTICLE_INTENT%TYPE;
2210: l_article_language OKC_ARTICLES_ALL.ARTICLE_LANGUAGE%TYPE;
2211: l_article_type OKC_ARTICLES_ALL.ARTICLE_TYPE%TYPE;
2212: l_orig_system_reference_code OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
2213: l_orig_system_reference_id1 OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
2206: l_org_id OKC_ARTICLES_ALL.ORG_ID%TYPE;
2207: l_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE;
2208: l_standard_yn OKC_ARTICLES_ALL.STANDARD_YN%TYPE;
2209: l_article_intent OKC_ARTICLES_ALL.ARTICLE_INTENT%TYPE;
2210: l_article_language OKC_ARTICLES_ALL.ARTICLE_LANGUAGE%TYPE;
2211: l_article_type OKC_ARTICLES_ALL.ARTICLE_TYPE%TYPE;
2212: l_orig_system_reference_code OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
2213: l_orig_system_reference_id1 OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
2214: l_orig_system_reference_id2 OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
2207: l_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE;
2208: l_standard_yn OKC_ARTICLES_ALL.STANDARD_YN%TYPE;
2209: l_article_intent OKC_ARTICLES_ALL.ARTICLE_INTENT%TYPE;
2210: l_article_language OKC_ARTICLES_ALL.ARTICLE_LANGUAGE%TYPE;
2211: l_article_type OKC_ARTICLES_ALL.ARTICLE_TYPE%TYPE;
2212: l_orig_system_reference_code OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
2213: l_orig_system_reference_id1 OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
2214: l_orig_system_reference_id2 OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
2215: l_cz_transfer_status_flag OKC_ARTICLES_ALL.CZ_TRANSFER_STATUS_FLAG%TYPE;
2208: l_standard_yn OKC_ARTICLES_ALL.STANDARD_YN%TYPE;
2209: l_article_intent OKC_ARTICLES_ALL.ARTICLE_INTENT%TYPE;
2210: l_article_language OKC_ARTICLES_ALL.ARTICLE_LANGUAGE%TYPE;
2211: l_article_type OKC_ARTICLES_ALL.ARTICLE_TYPE%TYPE;
2212: l_orig_system_reference_code OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
2213: l_orig_system_reference_id1 OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
2214: l_orig_system_reference_id2 OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
2215: l_cz_transfer_status_flag OKC_ARTICLES_ALL.CZ_TRANSFER_STATUS_FLAG%TYPE;
2216: l_program_id OKC_ARTICLES_ALL.PROGRAM_ID%TYPE;
2209: l_article_intent OKC_ARTICLES_ALL.ARTICLE_INTENT%TYPE;
2210: l_article_language OKC_ARTICLES_ALL.ARTICLE_LANGUAGE%TYPE;
2211: l_article_type OKC_ARTICLES_ALL.ARTICLE_TYPE%TYPE;
2212: l_orig_system_reference_code OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
2213: l_orig_system_reference_id1 OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
2214: l_orig_system_reference_id2 OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
2215: l_cz_transfer_status_flag OKC_ARTICLES_ALL.CZ_TRANSFER_STATUS_FLAG%TYPE;
2216: l_program_id OKC_ARTICLES_ALL.PROGRAM_ID%TYPE;
2217: l_program_login_id OKC_ARTICLES_ALL.PROGRAM_LOGIN_ID%TYPE;
2210: l_article_language OKC_ARTICLES_ALL.ARTICLE_LANGUAGE%TYPE;
2211: l_article_type OKC_ARTICLES_ALL.ARTICLE_TYPE%TYPE;
2212: l_orig_system_reference_code OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
2213: l_orig_system_reference_id1 OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
2214: l_orig_system_reference_id2 OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
2215: l_cz_transfer_status_flag OKC_ARTICLES_ALL.CZ_TRANSFER_STATUS_FLAG%TYPE;
2216: l_program_id OKC_ARTICLES_ALL.PROGRAM_ID%TYPE;
2217: l_program_login_id OKC_ARTICLES_ALL.PROGRAM_LOGIN_ID%TYPE;
2218: l_program_application_id OKC_ARTICLES_ALL.PROGRAM_APPLICATION_ID%TYPE;
2211: l_article_type OKC_ARTICLES_ALL.ARTICLE_TYPE%TYPE;
2212: l_orig_system_reference_code OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
2213: l_orig_system_reference_id1 OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
2214: l_orig_system_reference_id2 OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
2215: l_cz_transfer_status_flag OKC_ARTICLES_ALL.CZ_TRANSFER_STATUS_FLAG%TYPE;
2216: l_program_id OKC_ARTICLES_ALL.PROGRAM_ID%TYPE;
2217: l_program_login_id OKC_ARTICLES_ALL.PROGRAM_LOGIN_ID%TYPE;
2218: l_program_application_id OKC_ARTICLES_ALL.PROGRAM_APPLICATION_ID%TYPE;
2219: l_request_id OKC_ARTICLES_ALL.REQUEST_ID%TYPE;
2212: l_orig_system_reference_code OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
2213: l_orig_system_reference_id1 OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
2214: l_orig_system_reference_id2 OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
2215: l_cz_transfer_status_flag OKC_ARTICLES_ALL.CZ_TRANSFER_STATUS_FLAG%TYPE;
2216: l_program_id OKC_ARTICLES_ALL.PROGRAM_ID%TYPE;
2217: l_program_login_id OKC_ARTICLES_ALL.PROGRAM_LOGIN_ID%TYPE;
2218: l_program_application_id OKC_ARTICLES_ALL.PROGRAM_APPLICATION_ID%TYPE;
2219: l_request_id OKC_ARTICLES_ALL.REQUEST_ID%TYPE;
2220: l_attribute_category OKC_ARTICLES_ALL.ATTRIBUTE_CATEGORY%TYPE;
2213: l_orig_system_reference_id1 OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
2214: l_orig_system_reference_id2 OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
2215: l_cz_transfer_status_flag OKC_ARTICLES_ALL.CZ_TRANSFER_STATUS_FLAG%TYPE;
2216: l_program_id OKC_ARTICLES_ALL.PROGRAM_ID%TYPE;
2217: l_program_login_id OKC_ARTICLES_ALL.PROGRAM_LOGIN_ID%TYPE;
2218: l_program_application_id OKC_ARTICLES_ALL.PROGRAM_APPLICATION_ID%TYPE;
2219: l_request_id OKC_ARTICLES_ALL.REQUEST_ID%TYPE;
2220: l_attribute_category OKC_ARTICLES_ALL.ATTRIBUTE_CATEGORY%TYPE;
2221: l_attribute1 OKC_ARTICLES_ALL.ATTRIBUTE1%TYPE;
2214: l_orig_system_reference_id2 OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
2215: l_cz_transfer_status_flag OKC_ARTICLES_ALL.CZ_TRANSFER_STATUS_FLAG%TYPE;
2216: l_program_id OKC_ARTICLES_ALL.PROGRAM_ID%TYPE;
2217: l_program_login_id OKC_ARTICLES_ALL.PROGRAM_LOGIN_ID%TYPE;
2218: l_program_application_id OKC_ARTICLES_ALL.PROGRAM_APPLICATION_ID%TYPE;
2219: l_request_id OKC_ARTICLES_ALL.REQUEST_ID%TYPE;
2220: l_attribute_category OKC_ARTICLES_ALL.ATTRIBUTE_CATEGORY%TYPE;
2221: l_attribute1 OKC_ARTICLES_ALL.ATTRIBUTE1%TYPE;
2222: l_attribute2 OKC_ARTICLES_ALL.ATTRIBUTE2%TYPE;
2215: l_cz_transfer_status_flag OKC_ARTICLES_ALL.CZ_TRANSFER_STATUS_FLAG%TYPE;
2216: l_program_id OKC_ARTICLES_ALL.PROGRAM_ID%TYPE;
2217: l_program_login_id OKC_ARTICLES_ALL.PROGRAM_LOGIN_ID%TYPE;
2218: l_program_application_id OKC_ARTICLES_ALL.PROGRAM_APPLICATION_ID%TYPE;
2219: l_request_id OKC_ARTICLES_ALL.REQUEST_ID%TYPE;
2220: l_attribute_category OKC_ARTICLES_ALL.ATTRIBUTE_CATEGORY%TYPE;
2221: l_attribute1 OKC_ARTICLES_ALL.ATTRIBUTE1%TYPE;
2222: l_attribute2 OKC_ARTICLES_ALL.ATTRIBUTE2%TYPE;
2223: l_attribute3 OKC_ARTICLES_ALL.ATTRIBUTE3%TYPE;
2216: l_program_id OKC_ARTICLES_ALL.PROGRAM_ID%TYPE;
2217: l_program_login_id OKC_ARTICLES_ALL.PROGRAM_LOGIN_ID%TYPE;
2218: l_program_application_id OKC_ARTICLES_ALL.PROGRAM_APPLICATION_ID%TYPE;
2219: l_request_id OKC_ARTICLES_ALL.REQUEST_ID%TYPE;
2220: l_attribute_category OKC_ARTICLES_ALL.ATTRIBUTE_CATEGORY%TYPE;
2221: l_attribute1 OKC_ARTICLES_ALL.ATTRIBUTE1%TYPE;
2222: l_attribute2 OKC_ARTICLES_ALL.ATTRIBUTE2%TYPE;
2223: l_attribute3 OKC_ARTICLES_ALL.ATTRIBUTE3%TYPE;
2224: l_attribute4 OKC_ARTICLES_ALL.ATTRIBUTE4%TYPE;
2217: l_program_login_id OKC_ARTICLES_ALL.PROGRAM_LOGIN_ID%TYPE;
2218: l_program_application_id OKC_ARTICLES_ALL.PROGRAM_APPLICATION_ID%TYPE;
2219: l_request_id OKC_ARTICLES_ALL.REQUEST_ID%TYPE;
2220: l_attribute_category OKC_ARTICLES_ALL.ATTRIBUTE_CATEGORY%TYPE;
2221: l_attribute1 OKC_ARTICLES_ALL.ATTRIBUTE1%TYPE;
2222: l_attribute2 OKC_ARTICLES_ALL.ATTRIBUTE2%TYPE;
2223: l_attribute3 OKC_ARTICLES_ALL.ATTRIBUTE3%TYPE;
2224: l_attribute4 OKC_ARTICLES_ALL.ATTRIBUTE4%TYPE;
2225: l_attribute5 OKC_ARTICLES_ALL.ATTRIBUTE5%TYPE;
2218: l_program_application_id OKC_ARTICLES_ALL.PROGRAM_APPLICATION_ID%TYPE;
2219: l_request_id OKC_ARTICLES_ALL.REQUEST_ID%TYPE;
2220: l_attribute_category OKC_ARTICLES_ALL.ATTRIBUTE_CATEGORY%TYPE;
2221: l_attribute1 OKC_ARTICLES_ALL.ATTRIBUTE1%TYPE;
2222: l_attribute2 OKC_ARTICLES_ALL.ATTRIBUTE2%TYPE;
2223: l_attribute3 OKC_ARTICLES_ALL.ATTRIBUTE3%TYPE;
2224: l_attribute4 OKC_ARTICLES_ALL.ATTRIBUTE4%TYPE;
2225: l_attribute5 OKC_ARTICLES_ALL.ATTRIBUTE5%TYPE;
2226: l_attribute6 OKC_ARTICLES_ALL.ATTRIBUTE6%TYPE;
2219: l_request_id OKC_ARTICLES_ALL.REQUEST_ID%TYPE;
2220: l_attribute_category OKC_ARTICLES_ALL.ATTRIBUTE_CATEGORY%TYPE;
2221: l_attribute1 OKC_ARTICLES_ALL.ATTRIBUTE1%TYPE;
2222: l_attribute2 OKC_ARTICLES_ALL.ATTRIBUTE2%TYPE;
2223: l_attribute3 OKC_ARTICLES_ALL.ATTRIBUTE3%TYPE;
2224: l_attribute4 OKC_ARTICLES_ALL.ATTRIBUTE4%TYPE;
2225: l_attribute5 OKC_ARTICLES_ALL.ATTRIBUTE5%TYPE;
2226: l_attribute6 OKC_ARTICLES_ALL.ATTRIBUTE6%TYPE;
2227: l_attribute7 OKC_ARTICLES_ALL.ATTRIBUTE7%TYPE;
2220: l_attribute_category OKC_ARTICLES_ALL.ATTRIBUTE_CATEGORY%TYPE;
2221: l_attribute1 OKC_ARTICLES_ALL.ATTRIBUTE1%TYPE;
2222: l_attribute2 OKC_ARTICLES_ALL.ATTRIBUTE2%TYPE;
2223: l_attribute3 OKC_ARTICLES_ALL.ATTRIBUTE3%TYPE;
2224: l_attribute4 OKC_ARTICLES_ALL.ATTRIBUTE4%TYPE;
2225: l_attribute5 OKC_ARTICLES_ALL.ATTRIBUTE5%TYPE;
2226: l_attribute6 OKC_ARTICLES_ALL.ATTRIBUTE6%TYPE;
2227: l_attribute7 OKC_ARTICLES_ALL.ATTRIBUTE7%TYPE;
2228: l_attribute8 OKC_ARTICLES_ALL.ATTRIBUTE8%TYPE;
2221: l_attribute1 OKC_ARTICLES_ALL.ATTRIBUTE1%TYPE;
2222: l_attribute2 OKC_ARTICLES_ALL.ATTRIBUTE2%TYPE;
2223: l_attribute3 OKC_ARTICLES_ALL.ATTRIBUTE3%TYPE;
2224: l_attribute4 OKC_ARTICLES_ALL.ATTRIBUTE4%TYPE;
2225: l_attribute5 OKC_ARTICLES_ALL.ATTRIBUTE5%TYPE;
2226: l_attribute6 OKC_ARTICLES_ALL.ATTRIBUTE6%TYPE;
2227: l_attribute7 OKC_ARTICLES_ALL.ATTRIBUTE7%TYPE;
2228: l_attribute8 OKC_ARTICLES_ALL.ATTRIBUTE8%TYPE;
2229: l_attribute9 OKC_ARTICLES_ALL.ATTRIBUTE9%TYPE;
2222: l_attribute2 OKC_ARTICLES_ALL.ATTRIBUTE2%TYPE;
2223: l_attribute3 OKC_ARTICLES_ALL.ATTRIBUTE3%TYPE;
2224: l_attribute4 OKC_ARTICLES_ALL.ATTRIBUTE4%TYPE;
2225: l_attribute5 OKC_ARTICLES_ALL.ATTRIBUTE5%TYPE;
2226: l_attribute6 OKC_ARTICLES_ALL.ATTRIBUTE6%TYPE;
2227: l_attribute7 OKC_ARTICLES_ALL.ATTRIBUTE7%TYPE;
2228: l_attribute8 OKC_ARTICLES_ALL.ATTRIBUTE8%TYPE;
2229: l_attribute9 OKC_ARTICLES_ALL.ATTRIBUTE9%TYPE;
2230: l_attribute10 OKC_ARTICLES_ALL.ATTRIBUTE10%TYPE;
2223: l_attribute3 OKC_ARTICLES_ALL.ATTRIBUTE3%TYPE;
2224: l_attribute4 OKC_ARTICLES_ALL.ATTRIBUTE4%TYPE;
2225: l_attribute5 OKC_ARTICLES_ALL.ATTRIBUTE5%TYPE;
2226: l_attribute6 OKC_ARTICLES_ALL.ATTRIBUTE6%TYPE;
2227: l_attribute7 OKC_ARTICLES_ALL.ATTRIBUTE7%TYPE;
2228: l_attribute8 OKC_ARTICLES_ALL.ATTRIBUTE8%TYPE;
2229: l_attribute9 OKC_ARTICLES_ALL.ATTRIBUTE9%TYPE;
2230: l_attribute10 OKC_ARTICLES_ALL.ATTRIBUTE10%TYPE;
2231: l_attribute11 OKC_ARTICLES_ALL.ATTRIBUTE11%TYPE;
2224: l_attribute4 OKC_ARTICLES_ALL.ATTRIBUTE4%TYPE;
2225: l_attribute5 OKC_ARTICLES_ALL.ATTRIBUTE5%TYPE;
2226: l_attribute6 OKC_ARTICLES_ALL.ATTRIBUTE6%TYPE;
2227: l_attribute7 OKC_ARTICLES_ALL.ATTRIBUTE7%TYPE;
2228: l_attribute8 OKC_ARTICLES_ALL.ATTRIBUTE8%TYPE;
2229: l_attribute9 OKC_ARTICLES_ALL.ATTRIBUTE9%TYPE;
2230: l_attribute10 OKC_ARTICLES_ALL.ATTRIBUTE10%TYPE;
2231: l_attribute11 OKC_ARTICLES_ALL.ATTRIBUTE11%TYPE;
2232: l_attribute12 OKC_ARTICLES_ALL.ATTRIBUTE12%TYPE;
2225: l_attribute5 OKC_ARTICLES_ALL.ATTRIBUTE5%TYPE;
2226: l_attribute6 OKC_ARTICLES_ALL.ATTRIBUTE6%TYPE;
2227: l_attribute7 OKC_ARTICLES_ALL.ATTRIBUTE7%TYPE;
2228: l_attribute8 OKC_ARTICLES_ALL.ATTRIBUTE8%TYPE;
2229: l_attribute9 OKC_ARTICLES_ALL.ATTRIBUTE9%TYPE;
2230: l_attribute10 OKC_ARTICLES_ALL.ATTRIBUTE10%TYPE;
2231: l_attribute11 OKC_ARTICLES_ALL.ATTRIBUTE11%TYPE;
2232: l_attribute12 OKC_ARTICLES_ALL.ATTRIBUTE12%TYPE;
2233: l_attribute13 OKC_ARTICLES_ALL.ATTRIBUTE13%TYPE;
2226: l_attribute6 OKC_ARTICLES_ALL.ATTRIBUTE6%TYPE;
2227: l_attribute7 OKC_ARTICLES_ALL.ATTRIBUTE7%TYPE;
2228: l_attribute8 OKC_ARTICLES_ALL.ATTRIBUTE8%TYPE;
2229: l_attribute9 OKC_ARTICLES_ALL.ATTRIBUTE9%TYPE;
2230: l_attribute10 OKC_ARTICLES_ALL.ATTRIBUTE10%TYPE;
2231: l_attribute11 OKC_ARTICLES_ALL.ATTRIBUTE11%TYPE;
2232: l_attribute12 OKC_ARTICLES_ALL.ATTRIBUTE12%TYPE;
2233: l_attribute13 OKC_ARTICLES_ALL.ATTRIBUTE13%TYPE;
2234: l_attribute14 OKC_ARTICLES_ALL.ATTRIBUTE14%TYPE;
2227: l_attribute7 OKC_ARTICLES_ALL.ATTRIBUTE7%TYPE;
2228: l_attribute8 OKC_ARTICLES_ALL.ATTRIBUTE8%TYPE;
2229: l_attribute9 OKC_ARTICLES_ALL.ATTRIBUTE9%TYPE;
2230: l_attribute10 OKC_ARTICLES_ALL.ATTRIBUTE10%TYPE;
2231: l_attribute11 OKC_ARTICLES_ALL.ATTRIBUTE11%TYPE;
2232: l_attribute12 OKC_ARTICLES_ALL.ATTRIBUTE12%TYPE;
2233: l_attribute13 OKC_ARTICLES_ALL.ATTRIBUTE13%TYPE;
2234: l_attribute14 OKC_ARTICLES_ALL.ATTRIBUTE14%TYPE;
2235: l_attribute15 OKC_ARTICLES_ALL.ATTRIBUTE15%TYPE;
2228: l_attribute8 OKC_ARTICLES_ALL.ATTRIBUTE8%TYPE;
2229: l_attribute9 OKC_ARTICLES_ALL.ATTRIBUTE9%TYPE;
2230: l_attribute10 OKC_ARTICLES_ALL.ATTRIBUTE10%TYPE;
2231: l_attribute11 OKC_ARTICLES_ALL.ATTRIBUTE11%TYPE;
2232: l_attribute12 OKC_ARTICLES_ALL.ATTRIBUTE12%TYPE;
2233: l_attribute13 OKC_ARTICLES_ALL.ATTRIBUTE13%TYPE;
2234: l_attribute14 OKC_ARTICLES_ALL.ATTRIBUTE14%TYPE;
2235: l_attribute15 OKC_ARTICLES_ALL.ATTRIBUTE15%TYPE;
2236: l_object_version_number OKC_ARTICLES_ALL.OBJECT_VERSION_NUMBER%TYPE;
2229: l_attribute9 OKC_ARTICLES_ALL.ATTRIBUTE9%TYPE;
2230: l_attribute10 OKC_ARTICLES_ALL.ATTRIBUTE10%TYPE;
2231: l_attribute11 OKC_ARTICLES_ALL.ATTRIBUTE11%TYPE;
2232: l_attribute12 OKC_ARTICLES_ALL.ATTRIBUTE12%TYPE;
2233: l_attribute13 OKC_ARTICLES_ALL.ATTRIBUTE13%TYPE;
2234: l_attribute14 OKC_ARTICLES_ALL.ATTRIBUTE14%TYPE;
2235: l_attribute15 OKC_ARTICLES_ALL.ATTRIBUTE15%TYPE;
2236: l_object_version_number OKC_ARTICLES_ALL.OBJECT_VERSION_NUMBER%TYPE;
2237: l_created_by OKC_ARTICLES_ALL.CREATED_BY%TYPE;
2230: l_attribute10 OKC_ARTICLES_ALL.ATTRIBUTE10%TYPE;
2231: l_attribute11 OKC_ARTICLES_ALL.ATTRIBUTE11%TYPE;
2232: l_attribute12 OKC_ARTICLES_ALL.ATTRIBUTE12%TYPE;
2233: l_attribute13 OKC_ARTICLES_ALL.ATTRIBUTE13%TYPE;
2234: l_attribute14 OKC_ARTICLES_ALL.ATTRIBUTE14%TYPE;
2235: l_attribute15 OKC_ARTICLES_ALL.ATTRIBUTE15%TYPE;
2236: l_object_version_number OKC_ARTICLES_ALL.OBJECT_VERSION_NUMBER%TYPE;
2237: l_created_by OKC_ARTICLES_ALL.CREATED_BY%TYPE;
2238: l_creation_date OKC_ARTICLES_ALL.CREATION_DATE%TYPE;
2231: l_attribute11 OKC_ARTICLES_ALL.ATTRIBUTE11%TYPE;
2232: l_attribute12 OKC_ARTICLES_ALL.ATTRIBUTE12%TYPE;
2233: l_attribute13 OKC_ARTICLES_ALL.ATTRIBUTE13%TYPE;
2234: l_attribute14 OKC_ARTICLES_ALL.ATTRIBUTE14%TYPE;
2235: l_attribute15 OKC_ARTICLES_ALL.ATTRIBUTE15%TYPE;
2236: l_object_version_number OKC_ARTICLES_ALL.OBJECT_VERSION_NUMBER%TYPE;
2237: l_created_by OKC_ARTICLES_ALL.CREATED_BY%TYPE;
2238: l_creation_date OKC_ARTICLES_ALL.CREATION_DATE%TYPE;
2239: l_last_updated_by OKC_ARTICLES_ALL.LAST_UPDATED_BY%TYPE;
2232: l_attribute12 OKC_ARTICLES_ALL.ATTRIBUTE12%TYPE;
2233: l_attribute13 OKC_ARTICLES_ALL.ATTRIBUTE13%TYPE;
2234: l_attribute14 OKC_ARTICLES_ALL.ATTRIBUTE14%TYPE;
2235: l_attribute15 OKC_ARTICLES_ALL.ATTRIBUTE15%TYPE;
2236: l_object_version_number OKC_ARTICLES_ALL.OBJECT_VERSION_NUMBER%TYPE;
2237: l_created_by OKC_ARTICLES_ALL.CREATED_BY%TYPE;
2238: l_creation_date OKC_ARTICLES_ALL.CREATION_DATE%TYPE;
2239: l_last_updated_by OKC_ARTICLES_ALL.LAST_UPDATED_BY%TYPE;
2240: l_last_update_login OKC_ARTICLES_ALL.LAST_UPDATE_LOGIN%TYPE;
2233: l_attribute13 OKC_ARTICLES_ALL.ATTRIBUTE13%TYPE;
2234: l_attribute14 OKC_ARTICLES_ALL.ATTRIBUTE14%TYPE;
2235: l_attribute15 OKC_ARTICLES_ALL.ATTRIBUTE15%TYPE;
2236: l_object_version_number OKC_ARTICLES_ALL.OBJECT_VERSION_NUMBER%TYPE;
2237: l_created_by OKC_ARTICLES_ALL.CREATED_BY%TYPE;
2238: l_creation_date OKC_ARTICLES_ALL.CREATION_DATE%TYPE;
2239: l_last_updated_by OKC_ARTICLES_ALL.LAST_UPDATED_BY%TYPE;
2240: l_last_update_login OKC_ARTICLES_ALL.LAST_UPDATE_LOGIN%TYPE;
2241: l_last_update_date OKC_ARTICLES_ALL.LAST_UPDATE_DATE%TYPE;
2234: l_attribute14 OKC_ARTICLES_ALL.ATTRIBUTE14%TYPE;
2235: l_attribute15 OKC_ARTICLES_ALL.ATTRIBUTE15%TYPE;
2236: l_object_version_number OKC_ARTICLES_ALL.OBJECT_VERSION_NUMBER%TYPE;
2237: l_created_by OKC_ARTICLES_ALL.CREATED_BY%TYPE;
2238: l_creation_date OKC_ARTICLES_ALL.CREATION_DATE%TYPE;
2239: l_last_updated_by OKC_ARTICLES_ALL.LAST_UPDATED_BY%TYPE;
2240: l_last_update_login OKC_ARTICLES_ALL.LAST_UPDATE_LOGIN%TYPE;
2241: l_last_update_date OKC_ARTICLES_ALL.LAST_UPDATE_DATE%TYPE;
2242:
2235: l_attribute15 OKC_ARTICLES_ALL.ATTRIBUTE15%TYPE;
2236: l_object_version_number OKC_ARTICLES_ALL.OBJECT_VERSION_NUMBER%TYPE;
2237: l_created_by OKC_ARTICLES_ALL.CREATED_BY%TYPE;
2238: l_creation_date OKC_ARTICLES_ALL.CREATION_DATE%TYPE;
2239: l_last_updated_by OKC_ARTICLES_ALL.LAST_UPDATED_BY%TYPE;
2240: l_last_update_login OKC_ARTICLES_ALL.LAST_UPDATE_LOGIN%TYPE;
2241: l_last_update_date OKC_ARTICLES_ALL.LAST_UPDATE_DATE%TYPE;
2242:
2243: BEGIN
2236: l_object_version_number OKC_ARTICLES_ALL.OBJECT_VERSION_NUMBER%TYPE;
2237: l_created_by OKC_ARTICLES_ALL.CREATED_BY%TYPE;
2238: l_creation_date OKC_ARTICLES_ALL.CREATION_DATE%TYPE;
2239: l_last_updated_by OKC_ARTICLES_ALL.LAST_UPDATED_BY%TYPE;
2240: l_last_update_login OKC_ARTICLES_ALL.LAST_UPDATE_LOGIN%TYPE;
2241: l_last_update_date OKC_ARTICLES_ALL.LAST_UPDATE_DATE%TYPE;
2242:
2243: BEGIN
2244:
2237: l_created_by OKC_ARTICLES_ALL.CREATED_BY%TYPE;
2238: l_creation_date OKC_ARTICLES_ALL.CREATION_DATE%TYPE;
2239: l_last_updated_by OKC_ARTICLES_ALL.LAST_UPDATED_BY%TYPE;
2240: l_last_update_login OKC_ARTICLES_ALL.LAST_UPDATE_LOGIN%TYPE;
2241: l_last_update_date OKC_ARTICLES_ALL.LAST_UPDATE_DATE%TYPE;
2242:
2243: BEGIN
2244:
2245: IF (l_debug = 'Y') THEN
2484: ---------------------------------------------------------------------------
2485: -- PROCEDURE Delete_Row
2486: ---------------------------------------------------------------------------
2487: -------------------------------------
2488: -- Delete_Row for:OKC_ARTICLES_ALL --
2489: -------------------------------------
2490: FUNCTION Delete_Row(
2491: p_article_id IN NUMBER
2492: ) RETURN VARCHAR2 IS
2496: IF (l_debug = 'Y') THEN
2497: Okc_Debug.Log('8200: Entered Delete_Row', 2);
2498: END IF;
2499:
2500: DELETE FROM OKC_ARTICLES_ALL WHERE ARTICLE_ID = p_ARTICLE_ID;
2501:
2502: IF (l_debug = 'Y') THEN
2503: Okc_Debug.Log('8300: Leaving Delete_Row', 2);
2504: END IF;
2523:
2524: END Delete_Row;
2525:
2526: -------------------------------------
2527: -- Delete_Row for:OKC_ARTICLES_ALL --
2528: -------------------------------------
2529: PROCEDURE Delete_Row(
2530: x_return_status OUT NOCOPY VARCHAR2,
2531: p_article_id IN NUMBER,
2590: p_token2_value => sqlerrm);
2591: x_return_status := G_RET_STS_UNEXP_ERROR;
2592:
2593: END Delete_Row;
2594: END OKC_ARTICLES_ALL_PVT;