[Home] [Help]
42: -- PROCEDURE add_language
43: ---------------------------------------------------------------------------
44: PROCEDURE add_language IS
45: BEGIN
46: DELETE FROM OKC_K_ARTICLES_TL T
47: WHERE NOT EXISTS (
48: SELECT NULL
49: FROM OKC_K_ARTICLES_B B --fixed bug 3321017 by kmotepal
50: WHERE B.ID = T.ID
49: FROM OKC_K_ARTICLES_B B --fixed bug 3321017 by kmotepal
50: WHERE B.ID = T.ID
51: );
52:
53: UPDATE OKC_K_ARTICLES_TL T SET (
54: COMMENTS,
55: VARIATION_DESCRIPTION,
56: NAME,
57: -- TEXT,
60: B.VARIATION_DESCRIPTION,
61: B.NAME,
62: -- B.TEXT,
63: B.SAV_SAV_RELEASE
64: FROM OKC_K_ARTICLES_TL B
65: WHERE B.ID = T.ID
66: AND B.LANGUAGE = T.SOURCE_LANG)
67: WHERE (
68: T.ID,
69: T.LANGUAGE)
70: IN (SELECT
71: SUBT.ID,
72: SUBT.LANGUAGE
73: FROM OKC_K_ARTICLES_TL SUBB, OKC_K_ARTICLES_TL SUBT
74: WHERE SUBB.ID = SUBT.ID
75: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
76: AND (SUBB.COMMENTS <> SUBT.COMMENTS
77: OR SUBB.VARIATION_DESCRIPTION <> SUBT.VARIATION_DESCRIPTION
94: OR (SUBB.SAV_SAV_RELEASE IS NULL AND SUBT.SAV_SAV_RELEASE IS NOT NULL)
95: OR (SUBB.SAV_SAV_RELEASE IS NOT NULL AND SUBT.SAV_SAV_RELEASE IS NULL)
96: ));
97:
98: INSERT INTO OKC_K_ARTICLES_TL (
99: ID,
100: LANGUAGE,
101: SOURCE_LANG,
102: SFWT_FLAG,
128: B.LAST_UPDATE_DATE,
129: B.LAST_UPDATE_LOGIN,
130: B.SECURITY_GROUP_ID,
131: B.SAV_SAV_RELEASE
132: FROM OKC_K_ARTICLES_TL B, FND_LANGUAGES L
133: WHERE L.INSTALLED_FLAG IN ('I', 'B')
134: AND B.LANGUAGE = USERENV('LANG')
135: AND NOT EXISTS(
136: SELECT NULL
133: WHERE L.INSTALLED_FLAG IN ('I', 'B')
134: AND B.LANGUAGE = USERENV('LANG')
135: AND NOT EXISTS(
136: SELECT NULL
137: FROM OKC_K_ARTICLES_TL T
138: WHERE T.ID = B.ID
139: AND T.LANGUAGE = L.LANGUAGE_CODE
140: );
141:
235: BEGIN
236: RETURN(get_rec(p_cat_rec, l_row_notfound));
237: END get_rec;
238: ---------------------------------------------------------------------------
239: -- FUNCTION get_rec for: OKC_K_ARTICLES_TL
240: ---------------------------------------------------------------------------
241: FUNCTION get_rec (
242: p_okc_k_articles_tl_rec IN okc_k_articles_tl_rec_type,
243: x_no_data_found OUT NOCOPY BOOLEAN
238: ---------------------------------------------------------------------------
239: -- FUNCTION get_rec for: OKC_K_ARTICLES_TL
240: ---------------------------------------------------------------------------
241: FUNCTION get_rec (
242: p_okc_k_articles_tl_rec IN okc_k_articles_tl_rec_type,
243: x_no_data_found OUT NOCOPY BOOLEAN
244: ) RETURN okc_k_articles_tl_rec_type IS
245: CURSOR okc_k_articles_tl_pk_csr (p_id IN NUMBER,
246: p_language IN VARCHAR2) IS
240: ---------------------------------------------------------------------------
241: FUNCTION get_rec (
242: p_okc_k_articles_tl_rec IN okc_k_articles_tl_rec_type,
243: x_no_data_found OUT NOCOPY BOOLEAN
244: ) RETURN okc_k_articles_tl_rec_type IS
245: CURSOR okc_k_articles_tl_pk_csr (p_id IN NUMBER,
246: p_language IN VARCHAR2) IS
247: SELECT
248: ID,
241: FUNCTION get_rec (
242: p_okc_k_articles_tl_rec IN okc_k_articles_tl_rec_type,
243: x_no_data_found OUT NOCOPY BOOLEAN
244: ) RETURN okc_k_articles_tl_rec_type IS
245: CURSOR okc_k_articles_tl_pk_csr (p_id IN NUMBER,
246: p_language IN VARCHAR2) IS
247: SELECT
248: ID,
249: LANGUAGE,
260: LAST_UPDATE_DATE,
261: LAST_UPDATE_LOGIN,
262: SECURITY_GROUP_ID,
263: SAV_SAV_RELEASE
264: FROM Okc_K_Articles_Tl
265: WHERE okc_k_articles_tl.id = p_id
266: AND okc_k_articles_tl.language = p_language;
267: l_okc_k_articles_tl_pk okc_k_articles_tl_pk_csr%ROWTYPE;
268: l_okc_k_articles_tl_rec okc_k_articles_tl_rec_type;
261: LAST_UPDATE_LOGIN,
262: SECURITY_GROUP_ID,
263: SAV_SAV_RELEASE
264: FROM Okc_K_Articles_Tl
265: WHERE okc_k_articles_tl.id = p_id
266: AND okc_k_articles_tl.language = p_language;
267: l_okc_k_articles_tl_pk okc_k_articles_tl_pk_csr%ROWTYPE;
268: l_okc_k_articles_tl_rec okc_k_articles_tl_rec_type;
269: BEGIN
262: SECURITY_GROUP_ID,
263: SAV_SAV_RELEASE
264: FROM Okc_K_Articles_Tl
265: WHERE okc_k_articles_tl.id = p_id
266: AND okc_k_articles_tl.language = p_language;
267: l_okc_k_articles_tl_pk okc_k_articles_tl_pk_csr%ROWTYPE;
268: l_okc_k_articles_tl_rec okc_k_articles_tl_rec_type;
269: BEGIN
270: x_no_data_found := TRUE;
263: SAV_SAV_RELEASE
264: FROM Okc_K_Articles_Tl
265: WHERE okc_k_articles_tl.id = p_id
266: AND okc_k_articles_tl.language = p_language;
267: l_okc_k_articles_tl_pk okc_k_articles_tl_pk_csr%ROWTYPE;
268: l_okc_k_articles_tl_rec okc_k_articles_tl_rec_type;
269: BEGIN
270: x_no_data_found := TRUE;
271: -- Get current database values
264: FROM Okc_K_Articles_Tl
265: WHERE okc_k_articles_tl.id = p_id
266: AND okc_k_articles_tl.language = p_language;
267: l_okc_k_articles_tl_pk okc_k_articles_tl_pk_csr%ROWTYPE;
268: l_okc_k_articles_tl_rec okc_k_articles_tl_rec_type;
269: BEGIN
270: x_no_data_found := TRUE;
271: -- Get current database values
272: OPEN okc_k_articles_tl_pk_csr (p_okc_k_articles_tl_rec.id,
268: l_okc_k_articles_tl_rec okc_k_articles_tl_rec_type;
269: BEGIN
270: x_no_data_found := TRUE;
271: -- Get current database values
272: OPEN okc_k_articles_tl_pk_csr (p_okc_k_articles_tl_rec.id,
273: p_okc_k_articles_tl_rec.language);
274: FETCH okc_k_articles_tl_pk_csr INTO
275: l_okc_k_articles_tl_rec.ID,
276: l_okc_k_articles_tl_rec.LANGUAGE,
269: BEGIN
270: x_no_data_found := TRUE;
271: -- Get current database values
272: OPEN okc_k_articles_tl_pk_csr (p_okc_k_articles_tl_rec.id,
273: p_okc_k_articles_tl_rec.language);
274: FETCH okc_k_articles_tl_pk_csr INTO
275: l_okc_k_articles_tl_rec.ID,
276: l_okc_k_articles_tl_rec.LANGUAGE,
277: l_okc_k_articles_tl_rec.SOURCE_LANG,
270: x_no_data_found := TRUE;
271: -- Get current database values
272: OPEN okc_k_articles_tl_pk_csr (p_okc_k_articles_tl_rec.id,
273: p_okc_k_articles_tl_rec.language);
274: FETCH okc_k_articles_tl_pk_csr INTO
275: l_okc_k_articles_tl_rec.ID,
276: l_okc_k_articles_tl_rec.LANGUAGE,
277: l_okc_k_articles_tl_rec.SOURCE_LANG,
278: l_okc_k_articles_tl_rec.SFWT_FLAG,
271: -- Get current database values
272: OPEN okc_k_articles_tl_pk_csr (p_okc_k_articles_tl_rec.id,
273: p_okc_k_articles_tl_rec.language);
274: FETCH okc_k_articles_tl_pk_csr INTO
275: l_okc_k_articles_tl_rec.ID,
276: l_okc_k_articles_tl_rec.LANGUAGE,
277: l_okc_k_articles_tl_rec.SOURCE_LANG,
278: l_okc_k_articles_tl_rec.SFWT_FLAG,
279: l_okc_k_articles_tl_rec.OBJECT_VERSION_NUMBER,
272: OPEN okc_k_articles_tl_pk_csr (p_okc_k_articles_tl_rec.id,
273: p_okc_k_articles_tl_rec.language);
274: FETCH okc_k_articles_tl_pk_csr INTO
275: l_okc_k_articles_tl_rec.ID,
276: l_okc_k_articles_tl_rec.LANGUAGE,
277: l_okc_k_articles_tl_rec.SOURCE_LANG,
278: l_okc_k_articles_tl_rec.SFWT_FLAG,
279: l_okc_k_articles_tl_rec.OBJECT_VERSION_NUMBER,
280: l_okc_k_articles_tl_rec.COMMENTS,
273: p_okc_k_articles_tl_rec.language);
274: FETCH okc_k_articles_tl_pk_csr INTO
275: l_okc_k_articles_tl_rec.ID,
276: l_okc_k_articles_tl_rec.LANGUAGE,
277: l_okc_k_articles_tl_rec.SOURCE_LANG,
278: l_okc_k_articles_tl_rec.SFWT_FLAG,
279: l_okc_k_articles_tl_rec.OBJECT_VERSION_NUMBER,
280: l_okc_k_articles_tl_rec.COMMENTS,
281: l_okc_k_articles_tl_rec.VARIATION_DESCRIPTION,
274: FETCH okc_k_articles_tl_pk_csr INTO
275: l_okc_k_articles_tl_rec.ID,
276: l_okc_k_articles_tl_rec.LANGUAGE,
277: l_okc_k_articles_tl_rec.SOURCE_LANG,
278: l_okc_k_articles_tl_rec.SFWT_FLAG,
279: l_okc_k_articles_tl_rec.OBJECT_VERSION_NUMBER,
280: l_okc_k_articles_tl_rec.COMMENTS,
281: l_okc_k_articles_tl_rec.VARIATION_DESCRIPTION,
282: l_okc_k_articles_tl_rec.NAME,
275: l_okc_k_articles_tl_rec.ID,
276: l_okc_k_articles_tl_rec.LANGUAGE,
277: l_okc_k_articles_tl_rec.SOURCE_LANG,
278: l_okc_k_articles_tl_rec.SFWT_FLAG,
279: l_okc_k_articles_tl_rec.OBJECT_VERSION_NUMBER,
280: l_okc_k_articles_tl_rec.COMMENTS,
281: l_okc_k_articles_tl_rec.VARIATION_DESCRIPTION,
282: l_okc_k_articles_tl_rec.NAME,
283: -- l_okc_k_articles_tl_rec.TEXT,
276: l_okc_k_articles_tl_rec.LANGUAGE,
277: l_okc_k_articles_tl_rec.SOURCE_LANG,
278: l_okc_k_articles_tl_rec.SFWT_FLAG,
279: l_okc_k_articles_tl_rec.OBJECT_VERSION_NUMBER,
280: l_okc_k_articles_tl_rec.COMMENTS,
281: l_okc_k_articles_tl_rec.VARIATION_DESCRIPTION,
282: l_okc_k_articles_tl_rec.NAME,
283: -- l_okc_k_articles_tl_rec.TEXT,
284: l_okc_k_articles_tl_rec.CREATED_BY,
277: l_okc_k_articles_tl_rec.SOURCE_LANG,
278: l_okc_k_articles_tl_rec.SFWT_FLAG,
279: l_okc_k_articles_tl_rec.OBJECT_VERSION_NUMBER,
280: l_okc_k_articles_tl_rec.COMMENTS,
281: l_okc_k_articles_tl_rec.VARIATION_DESCRIPTION,
282: l_okc_k_articles_tl_rec.NAME,
283: -- l_okc_k_articles_tl_rec.TEXT,
284: l_okc_k_articles_tl_rec.CREATED_BY,
285: l_okc_k_articles_tl_rec.CREATION_DATE,
278: l_okc_k_articles_tl_rec.SFWT_FLAG,
279: l_okc_k_articles_tl_rec.OBJECT_VERSION_NUMBER,
280: l_okc_k_articles_tl_rec.COMMENTS,
281: l_okc_k_articles_tl_rec.VARIATION_DESCRIPTION,
282: l_okc_k_articles_tl_rec.NAME,
283: -- l_okc_k_articles_tl_rec.TEXT,
284: l_okc_k_articles_tl_rec.CREATED_BY,
285: l_okc_k_articles_tl_rec.CREATION_DATE,
286: l_okc_k_articles_tl_rec.LAST_UPDATED_BY,
279: l_okc_k_articles_tl_rec.OBJECT_VERSION_NUMBER,
280: l_okc_k_articles_tl_rec.COMMENTS,
281: l_okc_k_articles_tl_rec.VARIATION_DESCRIPTION,
282: l_okc_k_articles_tl_rec.NAME,
283: -- l_okc_k_articles_tl_rec.TEXT,
284: l_okc_k_articles_tl_rec.CREATED_BY,
285: l_okc_k_articles_tl_rec.CREATION_DATE,
286: l_okc_k_articles_tl_rec.LAST_UPDATED_BY,
287: l_okc_k_articles_tl_rec.LAST_UPDATE_DATE,
280: l_okc_k_articles_tl_rec.COMMENTS,
281: l_okc_k_articles_tl_rec.VARIATION_DESCRIPTION,
282: l_okc_k_articles_tl_rec.NAME,
283: -- l_okc_k_articles_tl_rec.TEXT,
284: l_okc_k_articles_tl_rec.CREATED_BY,
285: l_okc_k_articles_tl_rec.CREATION_DATE,
286: l_okc_k_articles_tl_rec.LAST_UPDATED_BY,
287: l_okc_k_articles_tl_rec.LAST_UPDATE_DATE,
288: l_okc_k_articles_tl_rec.LAST_UPDATE_LOGIN,
281: l_okc_k_articles_tl_rec.VARIATION_DESCRIPTION,
282: l_okc_k_articles_tl_rec.NAME,
283: -- l_okc_k_articles_tl_rec.TEXT,
284: l_okc_k_articles_tl_rec.CREATED_BY,
285: l_okc_k_articles_tl_rec.CREATION_DATE,
286: l_okc_k_articles_tl_rec.LAST_UPDATED_BY,
287: l_okc_k_articles_tl_rec.LAST_UPDATE_DATE,
288: l_okc_k_articles_tl_rec.LAST_UPDATE_LOGIN,
289: l_okc_k_articles_tl_rec.SECURITY_GROUP_ID,
282: l_okc_k_articles_tl_rec.NAME,
283: -- l_okc_k_articles_tl_rec.TEXT,
284: l_okc_k_articles_tl_rec.CREATED_BY,
285: l_okc_k_articles_tl_rec.CREATION_DATE,
286: l_okc_k_articles_tl_rec.LAST_UPDATED_BY,
287: l_okc_k_articles_tl_rec.LAST_UPDATE_DATE,
288: l_okc_k_articles_tl_rec.LAST_UPDATE_LOGIN,
289: l_okc_k_articles_tl_rec.SECURITY_GROUP_ID,
290: l_okc_k_articles_tl_rec.SAV_SAV_RELEASE;
283: -- l_okc_k_articles_tl_rec.TEXT,
284: l_okc_k_articles_tl_rec.CREATED_BY,
285: l_okc_k_articles_tl_rec.CREATION_DATE,
286: l_okc_k_articles_tl_rec.LAST_UPDATED_BY,
287: l_okc_k_articles_tl_rec.LAST_UPDATE_DATE,
288: l_okc_k_articles_tl_rec.LAST_UPDATE_LOGIN,
289: l_okc_k_articles_tl_rec.SECURITY_GROUP_ID,
290: l_okc_k_articles_tl_rec.SAV_SAV_RELEASE;
291: x_no_data_found := okc_k_articles_tl_pk_csr%NOTFOUND;
284: l_okc_k_articles_tl_rec.CREATED_BY,
285: l_okc_k_articles_tl_rec.CREATION_DATE,
286: l_okc_k_articles_tl_rec.LAST_UPDATED_BY,
287: l_okc_k_articles_tl_rec.LAST_UPDATE_DATE,
288: l_okc_k_articles_tl_rec.LAST_UPDATE_LOGIN,
289: l_okc_k_articles_tl_rec.SECURITY_GROUP_ID,
290: l_okc_k_articles_tl_rec.SAV_SAV_RELEASE;
291: x_no_data_found := okc_k_articles_tl_pk_csr%NOTFOUND;
292: CLOSE okc_k_articles_tl_pk_csr;
285: l_okc_k_articles_tl_rec.CREATION_DATE,
286: l_okc_k_articles_tl_rec.LAST_UPDATED_BY,
287: l_okc_k_articles_tl_rec.LAST_UPDATE_DATE,
288: l_okc_k_articles_tl_rec.LAST_UPDATE_LOGIN,
289: l_okc_k_articles_tl_rec.SECURITY_GROUP_ID,
290: l_okc_k_articles_tl_rec.SAV_SAV_RELEASE;
291: x_no_data_found := okc_k_articles_tl_pk_csr%NOTFOUND;
292: CLOSE okc_k_articles_tl_pk_csr;
293: RETURN(l_okc_k_articles_tl_rec);
286: l_okc_k_articles_tl_rec.LAST_UPDATED_BY,
287: l_okc_k_articles_tl_rec.LAST_UPDATE_DATE,
288: l_okc_k_articles_tl_rec.LAST_UPDATE_LOGIN,
289: l_okc_k_articles_tl_rec.SECURITY_GROUP_ID,
290: l_okc_k_articles_tl_rec.SAV_SAV_RELEASE;
291: x_no_data_found := okc_k_articles_tl_pk_csr%NOTFOUND;
292: CLOSE okc_k_articles_tl_pk_csr;
293: RETURN(l_okc_k_articles_tl_rec);
294: END get_rec;
287: l_okc_k_articles_tl_rec.LAST_UPDATE_DATE,
288: l_okc_k_articles_tl_rec.LAST_UPDATE_LOGIN,
289: l_okc_k_articles_tl_rec.SECURITY_GROUP_ID,
290: l_okc_k_articles_tl_rec.SAV_SAV_RELEASE;
291: x_no_data_found := okc_k_articles_tl_pk_csr%NOTFOUND;
292: CLOSE okc_k_articles_tl_pk_csr;
293: RETURN(l_okc_k_articles_tl_rec);
294: END get_rec;
295:
288: l_okc_k_articles_tl_rec.LAST_UPDATE_LOGIN,
289: l_okc_k_articles_tl_rec.SECURITY_GROUP_ID,
290: l_okc_k_articles_tl_rec.SAV_SAV_RELEASE;
291: x_no_data_found := okc_k_articles_tl_pk_csr%NOTFOUND;
292: CLOSE okc_k_articles_tl_pk_csr;
293: RETURN(l_okc_k_articles_tl_rec);
294: END get_rec;
295:
296: FUNCTION get_rec (
289: l_okc_k_articles_tl_rec.SECURITY_GROUP_ID,
290: l_okc_k_articles_tl_rec.SAV_SAV_RELEASE;
291: x_no_data_found := okc_k_articles_tl_pk_csr%NOTFOUND;
292: CLOSE okc_k_articles_tl_pk_csr;
293: RETURN(l_okc_k_articles_tl_rec);
294: END get_rec;
295:
296: FUNCTION get_rec (
297: p_okc_k_articles_tl_rec IN okc_k_articles_tl_rec_type
293: RETURN(l_okc_k_articles_tl_rec);
294: END get_rec;
295:
296: FUNCTION get_rec (
297: p_okc_k_articles_tl_rec IN okc_k_articles_tl_rec_type
298: ) RETURN okc_k_articles_tl_rec_type IS
299: l_row_notfound BOOLEAN := TRUE;
300: BEGIN
301: RETURN(get_rec(p_okc_k_articles_tl_rec, l_row_notfound));
294: END get_rec;
295:
296: FUNCTION get_rec (
297: p_okc_k_articles_tl_rec IN okc_k_articles_tl_rec_type
298: ) RETURN okc_k_articles_tl_rec_type IS
299: l_row_notfound BOOLEAN := TRUE;
300: BEGIN
301: RETURN(get_rec(p_okc_k_articles_tl_rec, l_row_notfound));
302: END get_rec;
297: p_okc_k_articles_tl_rec IN okc_k_articles_tl_rec_type
298: ) RETURN okc_k_articles_tl_rec_type IS
299: l_row_notfound BOOLEAN := TRUE;
300: BEGIN
301: RETURN(get_rec(p_okc_k_articles_tl_rec, l_row_notfound));
302: END get_rec;
303: ---------------------------------------------------------------------------
304: -- FUNCTION get_rec for: OKC_K_ARTICLES_V
305: ---------------------------------------------------------------------------
1377: p_to.attribute15 := p_from.attribute15;
1378: END migrate;
1379: PROCEDURE migrate (
1380: p_from IN catv_rec_type,
1381: p_to IN OUT NOCOPY okc_k_articles_tl_rec_type
1382: ) IS
1383: BEGIN
1384: p_to.id := p_from.id;
1385: p_to.sfwt_flag := p_from.sfwt_flag;
1395: p_to.last_update_login := p_from.last_update_login;
1396: p_to.sav_sav_release := p_from.sav_sav_release;
1397: END migrate;
1398: PROCEDURE migrate (
1399: p_from IN okc_k_articles_tl_rec_type,
1400: p_to IN OUT NOCOPY catv_rec_type
1401: ) IS
1402: BEGIN
1403: p_to.id := p_from.id;
1433: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
1434: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1435: l_catv_rec catv_rec_type := p_catv_rec;
1436: l_cat_rec cat_rec_type;
1437: l_okc_k_articles_tl_rec okc_k_articles_tl_rec_type;
1438: BEGIN
1439: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1440: G_PKG_NAME,
1441: p_init_msg_list,
1712: '_PVT'
1713: );
1714: END insert_row;
1715: --------------------------------------
1716: -- insert_row for:OKC_K_ARTICLES_TL --
1717: --------------------------------------
1718: PROCEDURE insert_row(
1719: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1720: x_return_status OUT NOCOPY VARCHAR2,
1719: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1720: x_return_status OUT NOCOPY VARCHAR2,
1721: x_msg_count OUT NOCOPY NUMBER,
1722: x_msg_data OUT NOCOPY VARCHAR2,
1723: p_okc_k_articles_tl_rec IN okc_k_articles_tl_rec_type,
1724: x_okc_k_articles_tl_rec OUT NOCOPY okc_k_articles_tl_rec_type) IS
1725:
1726: l_api_version CONSTANT NUMBER := 1;
1727: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1720: x_return_status OUT NOCOPY VARCHAR2,
1721: x_msg_count OUT NOCOPY NUMBER,
1722: x_msg_data OUT NOCOPY VARCHAR2,
1723: p_okc_k_articles_tl_rec IN okc_k_articles_tl_rec_type,
1724: x_okc_k_articles_tl_rec OUT NOCOPY okc_k_articles_tl_rec_type) IS
1725:
1726: l_api_version CONSTANT NUMBER := 1;
1727: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1728: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1725:
1726: l_api_version CONSTANT NUMBER := 1;
1727: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1728: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1729: l_okc_k_articles_tl_rec okc_k_articles_tl_rec_type := p_okc_k_articles_tl_rec;
1730: l_def_okc_k_articles_tl_rec okc_k_articles_tl_rec_type;
1731: CURSOR get_languages IS
1732: SELECT *
1733: FROM FND_LANGUAGES
1726: l_api_version CONSTANT NUMBER := 1;
1727: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1728: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1729: l_okc_k_articles_tl_rec okc_k_articles_tl_rec_type := p_okc_k_articles_tl_rec;
1730: l_def_okc_k_articles_tl_rec okc_k_articles_tl_rec_type;
1731: CURSOR get_languages IS
1732: SELECT *
1733: FROM FND_LANGUAGES
1734: WHERE INSTALLED_FLAG IN ('I', 'B');
1732: SELECT *
1733: FROM FND_LANGUAGES
1734: WHERE INSTALLED_FLAG IN ('I', 'B');
1735: ------------------------------------------
1736: -- Set_Attributes for:OKC_K_ARTICLES_TL --
1737: ------------------------------------------
1738: FUNCTION Set_Attributes (
1739: p_okc_k_articles_tl_rec IN okc_k_articles_tl_rec_type,
1740: x_okc_k_articles_tl_rec OUT NOCOPY okc_k_articles_tl_rec_type
1735: ------------------------------------------
1736: -- Set_Attributes for:OKC_K_ARTICLES_TL --
1737: ------------------------------------------
1738: FUNCTION Set_Attributes (
1739: p_okc_k_articles_tl_rec IN okc_k_articles_tl_rec_type,
1740: x_okc_k_articles_tl_rec OUT NOCOPY okc_k_articles_tl_rec_type
1741: ) RETURN VARCHAR2 IS
1742: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1743: BEGIN
1736: -- Set_Attributes for:OKC_K_ARTICLES_TL --
1737: ------------------------------------------
1738: FUNCTION Set_Attributes (
1739: p_okc_k_articles_tl_rec IN okc_k_articles_tl_rec_type,
1740: x_okc_k_articles_tl_rec OUT NOCOPY okc_k_articles_tl_rec_type
1741: ) RETURN VARCHAR2 IS
1742: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1743: BEGIN
1744: x_okc_k_articles_tl_rec := p_okc_k_articles_tl_rec;
1740: x_okc_k_articles_tl_rec OUT NOCOPY okc_k_articles_tl_rec_type
1741: ) RETURN VARCHAR2 IS
1742: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1743: BEGIN
1744: x_okc_k_articles_tl_rec := p_okc_k_articles_tl_rec;
1745: x_okc_k_articles_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
1746: x_okc_k_articles_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
1747: RETURN(l_return_status);
1748: END Set_Attributes;
1741: ) RETURN VARCHAR2 IS
1742: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1743: BEGIN
1744: x_okc_k_articles_tl_rec := p_okc_k_articles_tl_rec;
1745: x_okc_k_articles_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
1746: x_okc_k_articles_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
1747: RETURN(l_return_status);
1748: END Set_Attributes;
1749: BEGIN
1742: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1743: BEGIN
1744: x_okc_k_articles_tl_rec := p_okc_k_articles_tl_rec;
1745: x_okc_k_articles_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
1746: x_okc_k_articles_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
1747: RETURN(l_return_status);
1748: END Set_Attributes;
1749: BEGIN
1750: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1757: RAISE OKC_API.G_EXCEPTION_ERROR;
1758: END IF;
1759: --- Setting item attributes
1760: l_return_status := Set_Attributes(
1761: p_okc_k_articles_tl_rec, -- IN
1762: l_okc_k_articles_tl_rec); -- OUT
1763: --- If any errors happen abort API
1764: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1765: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1758: END IF;
1759: --- Setting item attributes
1760: l_return_status := Set_Attributes(
1761: p_okc_k_articles_tl_rec, -- IN
1762: l_okc_k_articles_tl_rec); -- OUT
1763: --- If any errors happen abort API
1764: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1765: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1766: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1766: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1767: RAISE OKC_API.G_EXCEPTION_ERROR;
1768: END IF;
1769: FOR l_lang_rec IN get_languages LOOP
1770: l_okc_k_articles_tl_rec.language := l_lang_rec.language_code;
1771: INSERT INTO OKC_K_ARTICLES_TL(
1772: id,
1773: language,
1774: source_lang,
1767: RAISE OKC_API.G_EXCEPTION_ERROR;
1768: END IF;
1769: FOR l_lang_rec IN get_languages LOOP
1770: l_okc_k_articles_tl_rec.language := l_lang_rec.language_code;
1771: INSERT INTO OKC_K_ARTICLES_TL(
1772: id,
1773: language,
1774: source_lang,
1775: sfwt_flag,
1785: last_update_login,
1786: security_group_id,
1787: sav_sav_release)
1788: VALUES (
1789: l_okc_k_articles_tl_rec.id,
1790: l_okc_k_articles_tl_rec.language,
1791: l_okc_k_articles_tl_rec.source_lang,
1792: l_okc_k_articles_tl_rec.sfwt_flag,
1793: l_okc_k_articles_tl_rec.object_version_number,
1786: security_group_id,
1787: sav_sav_release)
1788: VALUES (
1789: l_okc_k_articles_tl_rec.id,
1790: l_okc_k_articles_tl_rec.language,
1791: l_okc_k_articles_tl_rec.source_lang,
1792: l_okc_k_articles_tl_rec.sfwt_flag,
1793: l_okc_k_articles_tl_rec.object_version_number,
1794: l_okc_k_articles_tl_rec.comments,
1787: sav_sav_release)
1788: VALUES (
1789: l_okc_k_articles_tl_rec.id,
1790: l_okc_k_articles_tl_rec.language,
1791: l_okc_k_articles_tl_rec.source_lang,
1792: l_okc_k_articles_tl_rec.sfwt_flag,
1793: l_okc_k_articles_tl_rec.object_version_number,
1794: l_okc_k_articles_tl_rec.comments,
1795: l_okc_k_articles_tl_rec.variation_description,
1788: VALUES (
1789: l_okc_k_articles_tl_rec.id,
1790: l_okc_k_articles_tl_rec.language,
1791: l_okc_k_articles_tl_rec.source_lang,
1792: l_okc_k_articles_tl_rec.sfwt_flag,
1793: l_okc_k_articles_tl_rec.object_version_number,
1794: l_okc_k_articles_tl_rec.comments,
1795: l_okc_k_articles_tl_rec.variation_description,
1796: l_okc_k_articles_tl_rec.name,
1789: l_okc_k_articles_tl_rec.id,
1790: l_okc_k_articles_tl_rec.language,
1791: l_okc_k_articles_tl_rec.source_lang,
1792: l_okc_k_articles_tl_rec.sfwt_flag,
1793: l_okc_k_articles_tl_rec.object_version_number,
1794: l_okc_k_articles_tl_rec.comments,
1795: l_okc_k_articles_tl_rec.variation_description,
1796: l_okc_k_articles_tl_rec.name,
1797: -- l_okc_k_articles_tl_rec.text,
1790: l_okc_k_articles_tl_rec.language,
1791: l_okc_k_articles_tl_rec.source_lang,
1792: l_okc_k_articles_tl_rec.sfwt_flag,
1793: l_okc_k_articles_tl_rec.object_version_number,
1794: l_okc_k_articles_tl_rec.comments,
1795: l_okc_k_articles_tl_rec.variation_description,
1796: l_okc_k_articles_tl_rec.name,
1797: -- l_okc_k_articles_tl_rec.text,
1798: l_okc_k_articles_tl_rec.created_by,
1791: l_okc_k_articles_tl_rec.source_lang,
1792: l_okc_k_articles_tl_rec.sfwt_flag,
1793: l_okc_k_articles_tl_rec.object_version_number,
1794: l_okc_k_articles_tl_rec.comments,
1795: l_okc_k_articles_tl_rec.variation_description,
1796: l_okc_k_articles_tl_rec.name,
1797: -- l_okc_k_articles_tl_rec.text,
1798: l_okc_k_articles_tl_rec.created_by,
1799: l_okc_k_articles_tl_rec.creation_date,
1792: l_okc_k_articles_tl_rec.sfwt_flag,
1793: l_okc_k_articles_tl_rec.object_version_number,
1794: l_okc_k_articles_tl_rec.comments,
1795: l_okc_k_articles_tl_rec.variation_description,
1796: l_okc_k_articles_tl_rec.name,
1797: -- l_okc_k_articles_tl_rec.text,
1798: l_okc_k_articles_tl_rec.created_by,
1799: l_okc_k_articles_tl_rec.creation_date,
1800: l_okc_k_articles_tl_rec.last_updated_by,
1793: l_okc_k_articles_tl_rec.object_version_number,
1794: l_okc_k_articles_tl_rec.comments,
1795: l_okc_k_articles_tl_rec.variation_description,
1796: l_okc_k_articles_tl_rec.name,
1797: -- l_okc_k_articles_tl_rec.text,
1798: l_okc_k_articles_tl_rec.created_by,
1799: l_okc_k_articles_tl_rec.creation_date,
1800: l_okc_k_articles_tl_rec.last_updated_by,
1801: l_okc_k_articles_tl_rec.last_update_date,
1794: l_okc_k_articles_tl_rec.comments,
1795: l_okc_k_articles_tl_rec.variation_description,
1796: l_okc_k_articles_tl_rec.name,
1797: -- l_okc_k_articles_tl_rec.text,
1798: l_okc_k_articles_tl_rec.created_by,
1799: l_okc_k_articles_tl_rec.creation_date,
1800: l_okc_k_articles_tl_rec.last_updated_by,
1801: l_okc_k_articles_tl_rec.last_update_date,
1802: l_okc_k_articles_tl_rec.last_update_login,
1795: l_okc_k_articles_tl_rec.variation_description,
1796: l_okc_k_articles_tl_rec.name,
1797: -- l_okc_k_articles_tl_rec.text,
1798: l_okc_k_articles_tl_rec.created_by,
1799: l_okc_k_articles_tl_rec.creation_date,
1800: l_okc_k_articles_tl_rec.last_updated_by,
1801: l_okc_k_articles_tl_rec.last_update_date,
1802: l_okc_k_articles_tl_rec.last_update_login,
1803: l_okc_k_articles_tl_rec.security_group_id,
1796: l_okc_k_articles_tl_rec.name,
1797: -- l_okc_k_articles_tl_rec.text,
1798: l_okc_k_articles_tl_rec.created_by,
1799: l_okc_k_articles_tl_rec.creation_date,
1800: l_okc_k_articles_tl_rec.last_updated_by,
1801: l_okc_k_articles_tl_rec.last_update_date,
1802: l_okc_k_articles_tl_rec.last_update_login,
1803: l_okc_k_articles_tl_rec.security_group_id,
1804: l_okc_k_articles_tl_rec.sav_sav_release);
1797: -- l_okc_k_articles_tl_rec.text,
1798: l_okc_k_articles_tl_rec.created_by,
1799: l_okc_k_articles_tl_rec.creation_date,
1800: l_okc_k_articles_tl_rec.last_updated_by,
1801: l_okc_k_articles_tl_rec.last_update_date,
1802: l_okc_k_articles_tl_rec.last_update_login,
1803: l_okc_k_articles_tl_rec.security_group_id,
1804: l_okc_k_articles_tl_rec.sav_sav_release);
1805: END LOOP;
1798: l_okc_k_articles_tl_rec.created_by,
1799: l_okc_k_articles_tl_rec.creation_date,
1800: l_okc_k_articles_tl_rec.last_updated_by,
1801: l_okc_k_articles_tl_rec.last_update_date,
1802: l_okc_k_articles_tl_rec.last_update_login,
1803: l_okc_k_articles_tl_rec.security_group_id,
1804: l_okc_k_articles_tl_rec.sav_sav_release);
1805: END LOOP;
1806: -- Set OUT values
1799: l_okc_k_articles_tl_rec.creation_date,
1800: l_okc_k_articles_tl_rec.last_updated_by,
1801: l_okc_k_articles_tl_rec.last_update_date,
1802: l_okc_k_articles_tl_rec.last_update_login,
1803: l_okc_k_articles_tl_rec.security_group_id,
1804: l_okc_k_articles_tl_rec.sav_sav_release);
1805: END LOOP;
1806: -- Set OUT values
1807: x_okc_k_articles_tl_rec := l_okc_k_articles_tl_rec;
1800: l_okc_k_articles_tl_rec.last_updated_by,
1801: l_okc_k_articles_tl_rec.last_update_date,
1802: l_okc_k_articles_tl_rec.last_update_login,
1803: l_okc_k_articles_tl_rec.security_group_id,
1804: l_okc_k_articles_tl_rec.sav_sav_release);
1805: END LOOP;
1806: -- Set OUT values
1807: x_okc_k_articles_tl_rec := l_okc_k_articles_tl_rec;
1808: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1803: l_okc_k_articles_tl_rec.security_group_id,
1804: l_okc_k_articles_tl_rec.sav_sav_release);
1805: END LOOP;
1806: -- Set OUT values
1807: x_okc_k_articles_tl_rec := l_okc_k_articles_tl_rec;
1808: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1809: EXCEPTION
1810: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1811: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1856: l_catv_rec catv_rec_type;
1857: l_def_catv_rec catv_rec_type;
1858: l_cat_rec cat_rec_type;
1859: lx_cat_rec cat_rec_type;
1860: l_okc_k_articles_tl_rec okc_k_articles_tl_rec_type;
1861: lx_okc_k_articles_tl_rec okc_k_articles_tl_rec_type;
1862: -------------------------------
1863: -- FUNCTION fill_who_columns --
1864: -------------------------------
1857: l_def_catv_rec catv_rec_type;
1858: l_cat_rec cat_rec_type;
1859: lx_cat_rec cat_rec_type;
1860: l_okc_k_articles_tl_rec okc_k_articles_tl_rec_type;
1861: lx_okc_k_articles_tl_rec okc_k_articles_tl_rec_type;
1862: -------------------------------
1863: -- FUNCTION fill_who_columns --
1864: -------------------------------
1865: FUNCTION fill_who_columns (
1932: --------------------------------------
1933: -- Move VIEW record to "Child" records
1934: --------------------------------------
1935: migrate(l_def_catv_rec, l_cat_rec);
1936: migrate(l_def_catv_rec, l_okc_k_articles_tl_rec);
1937: --------------------------------------------
1938: -- Call the INSERT_ROW for each child record
1939: --------------------------------------------
1940: insert_row(
1955: p_init_msg_list,
1956: x_return_status,
1957: x_msg_count,
1958: x_msg_data,
1959: l_okc_k_articles_tl_rec,
1960: lx_okc_k_articles_tl_rec
1961: );
1962: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1963: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1956: x_return_status,
1957: x_msg_count,
1958: x_msg_data,
1959: l_okc_k_articles_tl_rec,
1960: lx_okc_k_articles_tl_rec
1961: );
1962: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1963: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1964: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1963: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1964: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1965: RAISE OKC_API.G_EXCEPTION_ERROR;
1966: END IF;
1967: migrate(lx_okc_k_articles_tl_rec, l_def_catv_rec);
1968: -- Set OUT values
1969: x_catv_rec := l_def_catv_rec;
1970: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1971: EXCEPTION
2176: '_PVT'
2177: );
2178: END lock_row;
2179: ------------------------------------
2180: -- lock_row for:OKC_K_ARTICLES_TL --
2181: ------------------------------------
2182: PROCEDURE lock_row(
2183: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2184: x_return_status OUT NOCOPY VARCHAR2,
2183: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2184: x_return_status OUT NOCOPY VARCHAR2,
2185: x_msg_count OUT NOCOPY NUMBER,
2186: x_msg_data OUT NOCOPY VARCHAR2,
2187: p_okc_k_articles_tl_rec IN okc_k_articles_tl_rec_type) IS
2188:
2189: E_Resource_Busy EXCEPTION;
2190: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2191: CURSOR lock_csr (p_okc_k_articles_tl_rec IN okc_k_articles_tl_rec_type) IS
2187: p_okc_k_articles_tl_rec IN okc_k_articles_tl_rec_type) IS
2188:
2189: E_Resource_Busy EXCEPTION;
2190: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2191: CURSOR lock_csr (p_okc_k_articles_tl_rec IN okc_k_articles_tl_rec_type) IS
2192: SELECT *
2193: FROM OKC_K_ARTICLES_TL
2194: WHERE ID = p_okc_k_articles_tl_rec.id
2195: FOR UPDATE NOWAIT;
2189: E_Resource_Busy EXCEPTION;
2190: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2191: CURSOR lock_csr (p_okc_k_articles_tl_rec IN okc_k_articles_tl_rec_type) IS
2192: SELECT *
2193: FROM OKC_K_ARTICLES_TL
2194: WHERE ID = p_okc_k_articles_tl_rec.id
2195: FOR UPDATE NOWAIT;
2196:
2197: l_api_version CONSTANT NUMBER := 1;
2190: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2191: CURSOR lock_csr (p_okc_k_articles_tl_rec IN okc_k_articles_tl_rec_type) IS
2192: SELECT *
2193: FROM OKC_K_ARTICLES_TL
2194: WHERE ID = p_okc_k_articles_tl_rec.id
2195: FOR UPDATE NOWAIT;
2196:
2197: l_api_version CONSTANT NUMBER := 1;
2198: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';
2210: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2211: RAISE OKC_API.G_EXCEPTION_ERROR;
2212: END IF;
2213: BEGIN
2214: OPEN lock_csr(p_okc_k_articles_tl_rec);
2215: FETCH lock_csr INTO l_lock_var;
2216: l_row_notfound := lock_csr%NOTFOUND;
2217: CLOSE lock_csr;
2218: EXCEPTION
2275: l_api_version CONSTANT NUMBER := 1;
2276: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
2277: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2278: l_cat_rec cat_rec_type;
2279: l_okc_k_articles_tl_rec okc_k_articles_tl_rec_type;
2280: BEGIN
2281: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2282: G_PKG_NAME,
2283: p_init_msg_list,
2293: --------------------------------------
2294: -- Move VIEW record to "Child" records
2295: --------------------------------------
2296: migrate(p_catv_rec, l_cat_rec);
2297: migrate(p_catv_rec, l_okc_k_articles_tl_rec);
2298: --------------------------------------------
2299: -- Call the LOCK_ROW for each child record
2300: --------------------------------------------
2301: lock_row(
2314: p_init_msg_list,
2315: x_return_status,
2316: x_msg_count,
2317: x_msg_data,
2318: l_okc_k_articles_tl_rec
2319: );
2320: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2321: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2322: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2693: '_PVT'
2694: );
2695: END update_row;
2696: --------------------------------------
2697: -- update_row for:OKC_K_ARTICLES_TL --
2698: --------------------------------------
2699: PROCEDURE update_row(
2700: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2701: x_return_status OUT NOCOPY VARCHAR2,
2700: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2701: x_return_status OUT NOCOPY VARCHAR2,
2702: x_msg_count OUT NOCOPY NUMBER,
2703: x_msg_data OUT NOCOPY VARCHAR2,
2704: p_okc_k_articles_tl_rec IN okc_k_articles_tl_rec_type,
2705: x_okc_k_articles_tl_rec OUT NOCOPY okc_k_articles_tl_rec_type) IS
2706:
2707: l_api_version CONSTANT NUMBER := 1;
2708: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2701: x_return_status OUT NOCOPY VARCHAR2,
2702: x_msg_count OUT NOCOPY NUMBER,
2703: x_msg_data OUT NOCOPY VARCHAR2,
2704: p_okc_k_articles_tl_rec IN okc_k_articles_tl_rec_type,
2705: x_okc_k_articles_tl_rec OUT NOCOPY okc_k_articles_tl_rec_type) IS
2706:
2707: l_api_version CONSTANT NUMBER := 1;
2708: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2709: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2706:
2707: l_api_version CONSTANT NUMBER := 1;
2708: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2709: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2710: l_okc_k_articles_tl_rec okc_k_articles_tl_rec_type := p_okc_k_articles_tl_rec;
2711: l_def_okc_k_articles_tl_rec okc_k_articles_tl_rec_type;
2712: l_row_notfound BOOLEAN := TRUE;
2713: ----------------------------------
2714: -- FUNCTION populate_new_record --
2707: l_api_version CONSTANT NUMBER := 1;
2708: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2709: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2710: l_okc_k_articles_tl_rec okc_k_articles_tl_rec_type := p_okc_k_articles_tl_rec;
2711: l_def_okc_k_articles_tl_rec okc_k_articles_tl_rec_type;
2712: l_row_notfound BOOLEAN := TRUE;
2713: ----------------------------------
2714: -- FUNCTION populate_new_record --
2715: ----------------------------------
2713: ----------------------------------
2714: -- FUNCTION populate_new_record --
2715: ----------------------------------
2716: FUNCTION populate_new_record (
2717: p_okc_k_articles_tl_rec IN okc_k_articles_tl_rec_type,
2718: x_okc_k_articles_tl_rec OUT NOCOPY okc_k_articles_tl_rec_type
2719: ) RETURN VARCHAR2 IS
2720: l_okc_k_articles_tl_rec okc_k_articles_tl_rec_type;
2721: l_row_notfound BOOLEAN := TRUE;
2714: -- FUNCTION populate_new_record --
2715: ----------------------------------
2716: FUNCTION populate_new_record (
2717: p_okc_k_articles_tl_rec IN okc_k_articles_tl_rec_type,
2718: x_okc_k_articles_tl_rec OUT NOCOPY okc_k_articles_tl_rec_type
2719: ) RETURN VARCHAR2 IS
2720: l_okc_k_articles_tl_rec okc_k_articles_tl_rec_type;
2721: l_row_notfound BOOLEAN := TRUE;
2722: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2716: FUNCTION populate_new_record (
2717: p_okc_k_articles_tl_rec IN okc_k_articles_tl_rec_type,
2718: x_okc_k_articles_tl_rec OUT NOCOPY okc_k_articles_tl_rec_type
2719: ) RETURN VARCHAR2 IS
2720: l_okc_k_articles_tl_rec okc_k_articles_tl_rec_type;
2721: l_row_notfound BOOLEAN := TRUE;
2722: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2723: BEGIN
2724: x_okc_k_articles_tl_rec := p_okc_k_articles_tl_rec;
2720: l_okc_k_articles_tl_rec okc_k_articles_tl_rec_type;
2721: l_row_notfound BOOLEAN := TRUE;
2722: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2723: BEGIN
2724: x_okc_k_articles_tl_rec := p_okc_k_articles_tl_rec;
2725: -- Get current database values
2726: l_okc_k_articles_tl_rec := get_rec(p_okc_k_articles_tl_rec, l_row_notfound);
2727: IF (l_row_notfound) THEN
2728: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2722: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2723: BEGIN
2724: x_okc_k_articles_tl_rec := p_okc_k_articles_tl_rec;
2725: -- Get current database values
2726: l_okc_k_articles_tl_rec := get_rec(p_okc_k_articles_tl_rec, l_row_notfound);
2727: IF (l_row_notfound) THEN
2728: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2729: END IF;
2730: IF (x_okc_k_articles_tl_rec.id = OKC_API.G_MISS_NUM)
2726: l_okc_k_articles_tl_rec := get_rec(p_okc_k_articles_tl_rec, l_row_notfound);
2727: IF (l_row_notfound) THEN
2728: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2729: END IF;
2730: IF (x_okc_k_articles_tl_rec.id = OKC_API.G_MISS_NUM)
2731: THEN
2732: x_okc_k_articles_tl_rec.id := l_okc_k_articles_tl_rec.id;
2733: END IF;
2734: IF (x_okc_k_articles_tl_rec.language = OKC_API.G_MISS_CHAR)
2728: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2729: END IF;
2730: IF (x_okc_k_articles_tl_rec.id = OKC_API.G_MISS_NUM)
2731: THEN
2732: x_okc_k_articles_tl_rec.id := l_okc_k_articles_tl_rec.id;
2733: END IF;
2734: IF (x_okc_k_articles_tl_rec.language = OKC_API.G_MISS_CHAR)
2735: THEN
2736: x_okc_k_articles_tl_rec.language := l_okc_k_articles_tl_rec.language;
2730: IF (x_okc_k_articles_tl_rec.id = OKC_API.G_MISS_NUM)
2731: THEN
2732: x_okc_k_articles_tl_rec.id := l_okc_k_articles_tl_rec.id;
2733: END IF;
2734: IF (x_okc_k_articles_tl_rec.language = OKC_API.G_MISS_CHAR)
2735: THEN
2736: x_okc_k_articles_tl_rec.language := l_okc_k_articles_tl_rec.language;
2737: END IF;
2738: IF (x_okc_k_articles_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2732: x_okc_k_articles_tl_rec.id := l_okc_k_articles_tl_rec.id;
2733: END IF;
2734: IF (x_okc_k_articles_tl_rec.language = OKC_API.G_MISS_CHAR)
2735: THEN
2736: x_okc_k_articles_tl_rec.language := l_okc_k_articles_tl_rec.language;
2737: END IF;
2738: IF (x_okc_k_articles_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2739: THEN
2740: x_okc_k_articles_tl_rec.source_lang := l_okc_k_articles_tl_rec.source_lang;
2734: IF (x_okc_k_articles_tl_rec.language = OKC_API.G_MISS_CHAR)
2735: THEN
2736: x_okc_k_articles_tl_rec.language := l_okc_k_articles_tl_rec.language;
2737: END IF;
2738: IF (x_okc_k_articles_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2739: THEN
2740: x_okc_k_articles_tl_rec.source_lang := l_okc_k_articles_tl_rec.source_lang;
2741: END IF;
2742: IF (x_okc_k_articles_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2736: x_okc_k_articles_tl_rec.language := l_okc_k_articles_tl_rec.language;
2737: END IF;
2738: IF (x_okc_k_articles_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2739: THEN
2740: x_okc_k_articles_tl_rec.source_lang := l_okc_k_articles_tl_rec.source_lang;
2741: END IF;
2742: IF (x_okc_k_articles_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2743: THEN
2744: x_okc_k_articles_tl_rec.sfwt_flag := l_okc_k_articles_tl_rec.sfwt_flag;
2738: IF (x_okc_k_articles_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2739: THEN
2740: x_okc_k_articles_tl_rec.source_lang := l_okc_k_articles_tl_rec.source_lang;
2741: END IF;
2742: IF (x_okc_k_articles_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2743: THEN
2744: x_okc_k_articles_tl_rec.sfwt_flag := l_okc_k_articles_tl_rec.sfwt_flag;
2745: END IF;
2746: IF (x_okc_k_articles_tl_rec.object_version_number = OKC_API.G_MISS_NUM)
2740: x_okc_k_articles_tl_rec.source_lang := l_okc_k_articles_tl_rec.source_lang;
2741: END IF;
2742: IF (x_okc_k_articles_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2743: THEN
2744: x_okc_k_articles_tl_rec.sfwt_flag := l_okc_k_articles_tl_rec.sfwt_flag;
2745: END IF;
2746: IF (x_okc_k_articles_tl_rec.object_version_number = OKC_API.G_MISS_NUM)
2747: THEN
2748: x_okc_k_articles_tl_rec.object_version_number := l_okc_k_articles_tl_rec.object_version_number;
2742: IF (x_okc_k_articles_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2743: THEN
2744: x_okc_k_articles_tl_rec.sfwt_flag := l_okc_k_articles_tl_rec.sfwt_flag;
2745: END IF;
2746: IF (x_okc_k_articles_tl_rec.object_version_number = OKC_API.G_MISS_NUM)
2747: THEN
2748: x_okc_k_articles_tl_rec.object_version_number := l_okc_k_articles_tl_rec.object_version_number;
2749: END IF;
2750: IF (x_okc_k_articles_tl_rec.comments = OKC_API.G_MISS_CHAR)
2744: x_okc_k_articles_tl_rec.sfwt_flag := l_okc_k_articles_tl_rec.sfwt_flag;
2745: END IF;
2746: IF (x_okc_k_articles_tl_rec.object_version_number = OKC_API.G_MISS_NUM)
2747: THEN
2748: x_okc_k_articles_tl_rec.object_version_number := l_okc_k_articles_tl_rec.object_version_number;
2749: END IF;
2750: IF (x_okc_k_articles_tl_rec.comments = OKC_API.G_MISS_CHAR)
2751: THEN
2752: x_okc_k_articles_tl_rec.comments := l_okc_k_articles_tl_rec.comments;
2746: IF (x_okc_k_articles_tl_rec.object_version_number = OKC_API.G_MISS_NUM)
2747: THEN
2748: x_okc_k_articles_tl_rec.object_version_number := l_okc_k_articles_tl_rec.object_version_number;
2749: END IF;
2750: IF (x_okc_k_articles_tl_rec.comments = OKC_API.G_MISS_CHAR)
2751: THEN
2752: x_okc_k_articles_tl_rec.comments := l_okc_k_articles_tl_rec.comments;
2753: END IF;
2754: IF (x_okc_k_articles_tl_rec.variation_description = OKC_API.G_MISS_CHAR)
2748: x_okc_k_articles_tl_rec.object_version_number := l_okc_k_articles_tl_rec.object_version_number;
2749: END IF;
2750: IF (x_okc_k_articles_tl_rec.comments = OKC_API.G_MISS_CHAR)
2751: THEN
2752: x_okc_k_articles_tl_rec.comments := l_okc_k_articles_tl_rec.comments;
2753: END IF;
2754: IF (x_okc_k_articles_tl_rec.variation_description = OKC_API.G_MISS_CHAR)
2755: THEN
2756: x_okc_k_articles_tl_rec.variation_description := l_okc_k_articles_tl_rec.variation_description;
2750: IF (x_okc_k_articles_tl_rec.comments = OKC_API.G_MISS_CHAR)
2751: THEN
2752: x_okc_k_articles_tl_rec.comments := l_okc_k_articles_tl_rec.comments;
2753: END IF;
2754: IF (x_okc_k_articles_tl_rec.variation_description = OKC_API.G_MISS_CHAR)
2755: THEN
2756: x_okc_k_articles_tl_rec.variation_description := l_okc_k_articles_tl_rec.variation_description;
2757: END IF;
2758: IF (x_okc_k_articles_tl_rec.name = OKC_API.G_MISS_CHAR)
2752: x_okc_k_articles_tl_rec.comments := l_okc_k_articles_tl_rec.comments;
2753: END IF;
2754: IF (x_okc_k_articles_tl_rec.variation_description = OKC_API.G_MISS_CHAR)
2755: THEN
2756: x_okc_k_articles_tl_rec.variation_description := l_okc_k_articles_tl_rec.variation_description;
2757: END IF;
2758: IF (x_okc_k_articles_tl_rec.name = OKC_API.G_MISS_CHAR)
2759: THEN
2760: x_okc_k_articles_tl_rec.name := l_okc_k_articles_tl_rec.name;
2754: IF (x_okc_k_articles_tl_rec.variation_description = OKC_API.G_MISS_CHAR)
2755: THEN
2756: x_okc_k_articles_tl_rec.variation_description := l_okc_k_articles_tl_rec.variation_description;
2757: END IF;
2758: IF (x_okc_k_articles_tl_rec.name = OKC_API.G_MISS_CHAR)
2759: THEN
2760: x_okc_k_articles_tl_rec.name := l_okc_k_articles_tl_rec.name;
2761: END IF;
2762: -- Commented in favor of hand code
2756: x_okc_k_articles_tl_rec.variation_description := l_okc_k_articles_tl_rec.variation_description;
2757: END IF;
2758: IF (x_okc_k_articles_tl_rec.name = OKC_API.G_MISS_CHAR)
2759: THEN
2760: x_okc_k_articles_tl_rec.name := l_okc_k_articles_tl_rec.name;
2761: END IF;
2762: -- Commented in favor of hand code
2763: -- IF (x_okc_k_articles_tl_rec.text = OKC_API.G_MISS_CHAR)
2764: --+Hand code start
2759: THEN
2760: x_okc_k_articles_tl_rec.name := l_okc_k_articles_tl_rec.name;
2761: END IF;
2762: -- Commented in favor of hand code
2763: -- IF (x_okc_k_articles_tl_rec.text = OKC_API.G_MISS_CHAR)
2764: --+Hand code start
2765: -- IF (x_okc_k_articles_tl_rec.text is NULL)
2766: --+Hand code end
2767: -- THEN
2761: END IF;
2762: -- Commented in favor of hand code
2763: -- IF (x_okc_k_articles_tl_rec.text = OKC_API.G_MISS_CHAR)
2764: --+Hand code start
2765: -- IF (x_okc_k_articles_tl_rec.text is NULL)
2766: --+Hand code end
2767: -- THEN
2768: -- x_okc_k_articles_tl_rec.text := l_okc_k_articles_tl_rec.text;
2769: -- END IF;
2764: --+Hand code start
2765: -- IF (x_okc_k_articles_tl_rec.text is NULL)
2766: --+Hand code end
2767: -- THEN
2768: -- x_okc_k_articles_tl_rec.text := l_okc_k_articles_tl_rec.text;
2769: -- END IF;
2770: IF (x_okc_k_articles_tl_rec.created_by = OKC_API.G_MISS_NUM)
2771: THEN
2772: x_okc_k_articles_tl_rec.created_by := l_okc_k_articles_tl_rec.created_by;
2766: --+Hand code end
2767: -- THEN
2768: -- x_okc_k_articles_tl_rec.text := l_okc_k_articles_tl_rec.text;
2769: -- END IF;
2770: IF (x_okc_k_articles_tl_rec.created_by = OKC_API.G_MISS_NUM)
2771: THEN
2772: x_okc_k_articles_tl_rec.created_by := l_okc_k_articles_tl_rec.created_by;
2773: END IF;
2774: IF (x_okc_k_articles_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2768: -- x_okc_k_articles_tl_rec.text := l_okc_k_articles_tl_rec.text;
2769: -- END IF;
2770: IF (x_okc_k_articles_tl_rec.created_by = OKC_API.G_MISS_NUM)
2771: THEN
2772: x_okc_k_articles_tl_rec.created_by := l_okc_k_articles_tl_rec.created_by;
2773: END IF;
2774: IF (x_okc_k_articles_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2775: THEN
2776: x_okc_k_articles_tl_rec.creation_date := l_okc_k_articles_tl_rec.creation_date;
2770: IF (x_okc_k_articles_tl_rec.created_by = OKC_API.G_MISS_NUM)
2771: THEN
2772: x_okc_k_articles_tl_rec.created_by := l_okc_k_articles_tl_rec.created_by;
2773: END IF;
2774: IF (x_okc_k_articles_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2775: THEN
2776: x_okc_k_articles_tl_rec.creation_date := l_okc_k_articles_tl_rec.creation_date;
2777: END IF;
2778: IF (x_okc_k_articles_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2772: x_okc_k_articles_tl_rec.created_by := l_okc_k_articles_tl_rec.created_by;
2773: END IF;
2774: IF (x_okc_k_articles_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2775: THEN
2776: x_okc_k_articles_tl_rec.creation_date := l_okc_k_articles_tl_rec.creation_date;
2777: END IF;
2778: IF (x_okc_k_articles_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2779: THEN
2780: x_okc_k_articles_tl_rec.last_updated_by := l_okc_k_articles_tl_rec.last_updated_by;
2774: IF (x_okc_k_articles_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2775: THEN
2776: x_okc_k_articles_tl_rec.creation_date := l_okc_k_articles_tl_rec.creation_date;
2777: END IF;
2778: IF (x_okc_k_articles_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2779: THEN
2780: x_okc_k_articles_tl_rec.last_updated_by := l_okc_k_articles_tl_rec.last_updated_by;
2781: END IF;
2782: IF (x_okc_k_articles_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2776: x_okc_k_articles_tl_rec.creation_date := l_okc_k_articles_tl_rec.creation_date;
2777: END IF;
2778: IF (x_okc_k_articles_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2779: THEN
2780: x_okc_k_articles_tl_rec.last_updated_by := l_okc_k_articles_tl_rec.last_updated_by;
2781: END IF;
2782: IF (x_okc_k_articles_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2783: THEN
2784: x_okc_k_articles_tl_rec.last_update_date := l_okc_k_articles_tl_rec.last_update_date;
2778: IF (x_okc_k_articles_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2779: THEN
2780: x_okc_k_articles_tl_rec.last_updated_by := l_okc_k_articles_tl_rec.last_updated_by;
2781: END IF;
2782: IF (x_okc_k_articles_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2783: THEN
2784: x_okc_k_articles_tl_rec.last_update_date := l_okc_k_articles_tl_rec.last_update_date;
2785: END IF;
2786: IF (x_okc_k_articles_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
2780: x_okc_k_articles_tl_rec.last_updated_by := l_okc_k_articles_tl_rec.last_updated_by;
2781: END IF;
2782: IF (x_okc_k_articles_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2783: THEN
2784: x_okc_k_articles_tl_rec.last_update_date := l_okc_k_articles_tl_rec.last_update_date;
2785: END IF;
2786: IF (x_okc_k_articles_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
2787: THEN
2788: x_okc_k_articles_tl_rec.last_update_login := l_okc_k_articles_tl_rec.last_update_login;
2782: IF (x_okc_k_articles_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2783: THEN
2784: x_okc_k_articles_tl_rec.last_update_date := l_okc_k_articles_tl_rec.last_update_date;
2785: END IF;
2786: IF (x_okc_k_articles_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
2787: THEN
2788: x_okc_k_articles_tl_rec.last_update_login := l_okc_k_articles_tl_rec.last_update_login;
2789: END IF;
2790: IF (x_okc_k_articles_tl_rec.security_group_id = OKC_API.G_MISS_NUM)
2784: x_okc_k_articles_tl_rec.last_update_date := l_okc_k_articles_tl_rec.last_update_date;
2785: END IF;
2786: IF (x_okc_k_articles_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
2787: THEN
2788: x_okc_k_articles_tl_rec.last_update_login := l_okc_k_articles_tl_rec.last_update_login;
2789: END IF;
2790: IF (x_okc_k_articles_tl_rec.security_group_id = OKC_API.G_MISS_NUM)
2791: THEN
2792: x_okc_k_articles_tl_rec.security_group_id := l_okc_k_articles_tl_rec.security_group_id;
2786: IF (x_okc_k_articles_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
2787: THEN
2788: x_okc_k_articles_tl_rec.last_update_login := l_okc_k_articles_tl_rec.last_update_login;
2789: END IF;
2790: IF (x_okc_k_articles_tl_rec.security_group_id = OKC_API.G_MISS_NUM)
2791: THEN
2792: x_okc_k_articles_tl_rec.security_group_id := l_okc_k_articles_tl_rec.security_group_id;
2793: END IF;
2794: IF (x_okc_k_articles_tl_rec.sav_sav_release = OKC_API.G_MISS_CHAR)
2788: x_okc_k_articles_tl_rec.last_update_login := l_okc_k_articles_tl_rec.last_update_login;
2789: END IF;
2790: IF (x_okc_k_articles_tl_rec.security_group_id = OKC_API.G_MISS_NUM)
2791: THEN
2792: x_okc_k_articles_tl_rec.security_group_id := l_okc_k_articles_tl_rec.security_group_id;
2793: END IF;
2794: IF (x_okc_k_articles_tl_rec.sav_sav_release = OKC_API.G_MISS_CHAR)
2795: THEN
2796: x_okc_k_articles_tl_rec.sav_sav_release := l_okc_k_articles_tl_rec.sav_sav_release;
2790: IF (x_okc_k_articles_tl_rec.security_group_id = OKC_API.G_MISS_NUM)
2791: THEN
2792: x_okc_k_articles_tl_rec.security_group_id := l_okc_k_articles_tl_rec.security_group_id;
2793: END IF;
2794: IF (x_okc_k_articles_tl_rec.sav_sav_release = OKC_API.G_MISS_CHAR)
2795: THEN
2796: x_okc_k_articles_tl_rec.sav_sav_release := l_okc_k_articles_tl_rec.sav_sav_release;
2797: END IF;
2798: RETURN(l_return_status);
2792: x_okc_k_articles_tl_rec.security_group_id := l_okc_k_articles_tl_rec.security_group_id;
2793: END IF;
2794: IF (x_okc_k_articles_tl_rec.sav_sav_release = OKC_API.G_MISS_CHAR)
2795: THEN
2796: x_okc_k_articles_tl_rec.sav_sav_release := l_okc_k_articles_tl_rec.sav_sav_release;
2797: END IF;
2798: RETURN(l_return_status);
2799: END populate_new_record;
2800: ------------------------------------------
2797: END IF;
2798: RETURN(l_return_status);
2799: END populate_new_record;
2800: ------------------------------------------
2801: -- Set_Attributes for:OKC_K_ARTICLES_TL --
2802: ------------------------------------------
2803: FUNCTION Set_Attributes (
2804: p_okc_k_articles_tl_rec IN okc_k_articles_tl_rec_type,
2805: x_okc_k_articles_tl_rec OUT NOCOPY okc_k_articles_tl_rec_type
2800: ------------------------------------------
2801: -- Set_Attributes for:OKC_K_ARTICLES_TL --
2802: ------------------------------------------
2803: FUNCTION Set_Attributes (
2804: p_okc_k_articles_tl_rec IN okc_k_articles_tl_rec_type,
2805: x_okc_k_articles_tl_rec OUT NOCOPY okc_k_articles_tl_rec_type
2806: ) RETURN VARCHAR2 IS
2807: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2808: BEGIN
2801: -- Set_Attributes for:OKC_K_ARTICLES_TL --
2802: ------------------------------------------
2803: FUNCTION Set_Attributes (
2804: p_okc_k_articles_tl_rec IN okc_k_articles_tl_rec_type,
2805: x_okc_k_articles_tl_rec OUT NOCOPY okc_k_articles_tl_rec_type
2806: ) RETURN VARCHAR2 IS
2807: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2808: BEGIN
2809: x_okc_k_articles_tl_rec := p_okc_k_articles_tl_rec;
2805: x_okc_k_articles_tl_rec OUT NOCOPY okc_k_articles_tl_rec_type
2806: ) RETURN VARCHAR2 IS
2807: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2808: BEGIN
2809: x_okc_k_articles_tl_rec := p_okc_k_articles_tl_rec;
2810: x_okc_k_articles_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
2811: x_okc_k_articles_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
2812: RETURN(l_return_status);
2813: END Set_Attributes;
2806: ) RETURN VARCHAR2 IS
2807: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2808: BEGIN
2809: x_okc_k_articles_tl_rec := p_okc_k_articles_tl_rec;
2810: x_okc_k_articles_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
2811: x_okc_k_articles_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
2812: RETURN(l_return_status);
2813: END Set_Attributes;
2814: BEGIN
2807: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2808: BEGIN
2809: x_okc_k_articles_tl_rec := p_okc_k_articles_tl_rec;
2810: x_okc_k_articles_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
2811: x_okc_k_articles_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
2812: RETURN(l_return_status);
2813: END Set_Attributes;
2814: BEGIN
2815: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2822: RAISE OKC_API.G_EXCEPTION_ERROR;
2823: END IF;
2824: --- Setting item attributes
2825: l_return_status := Set_Attributes(
2826: p_okc_k_articles_tl_rec, -- IN
2827: l_okc_k_articles_tl_rec); -- OUT
2828: --- If any errors happen abort API
2829: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2830: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2823: END IF;
2824: --- Setting item attributes
2825: l_return_status := Set_Attributes(
2826: p_okc_k_articles_tl_rec, -- IN
2827: l_okc_k_articles_tl_rec); -- OUT
2828: --- If any errors happen abort API
2829: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2830: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2831: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2830: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2831: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2832: RAISE OKC_API.G_EXCEPTION_ERROR;
2833: END IF;
2834: l_return_status := populate_new_record(l_okc_k_articles_tl_rec, l_def_okc_k_articles_tl_rec);
2835: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2836: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2837: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2838: RAISE OKC_API.G_EXCEPTION_ERROR;
2836: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2837: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2838: RAISE OKC_API.G_EXCEPTION_ERROR;
2839: END IF;
2840: UPDATE OKC_K_ARTICLES_TL
2841: SET OBJECT_VERSION_NUMBER = l_def_okc_k_articles_tl_rec.object_version_number,
2842: COMMENTS = l_def_okc_k_articles_tl_rec.comments,
2843: VARIATION_DESCRIPTION = l_def_okc_k_articles_tl_rec.variation_description,
2844: NAME = l_def_okc_k_articles_tl_rec.name,
2837: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2838: RAISE OKC_API.G_EXCEPTION_ERROR;
2839: END IF;
2840: UPDATE OKC_K_ARTICLES_TL
2841: SET OBJECT_VERSION_NUMBER = l_def_okc_k_articles_tl_rec.object_version_number,
2842: COMMENTS = l_def_okc_k_articles_tl_rec.comments,
2843: VARIATION_DESCRIPTION = l_def_okc_k_articles_tl_rec.variation_description,
2844: NAME = l_def_okc_k_articles_tl_rec.name,
2845: -- TEXT = l_def_okc_k_articles_tl_rec.text,
2838: RAISE OKC_API.G_EXCEPTION_ERROR;
2839: END IF;
2840: UPDATE OKC_K_ARTICLES_TL
2841: SET OBJECT_VERSION_NUMBER = l_def_okc_k_articles_tl_rec.object_version_number,
2842: COMMENTS = l_def_okc_k_articles_tl_rec.comments,
2843: VARIATION_DESCRIPTION = l_def_okc_k_articles_tl_rec.variation_description,
2844: NAME = l_def_okc_k_articles_tl_rec.name,
2845: -- TEXT = l_def_okc_k_articles_tl_rec.text,
2846: CREATED_BY = l_def_okc_k_articles_tl_rec.created_by,
2839: END IF;
2840: UPDATE OKC_K_ARTICLES_TL
2841: SET OBJECT_VERSION_NUMBER = l_def_okc_k_articles_tl_rec.object_version_number,
2842: COMMENTS = l_def_okc_k_articles_tl_rec.comments,
2843: VARIATION_DESCRIPTION = l_def_okc_k_articles_tl_rec.variation_description,
2844: NAME = l_def_okc_k_articles_tl_rec.name,
2845: -- TEXT = l_def_okc_k_articles_tl_rec.text,
2846: CREATED_BY = l_def_okc_k_articles_tl_rec.created_by,
2847: CREATION_DATE = l_def_okc_k_articles_tl_rec.creation_date,
2840: UPDATE OKC_K_ARTICLES_TL
2841: SET OBJECT_VERSION_NUMBER = l_def_okc_k_articles_tl_rec.object_version_number,
2842: COMMENTS = l_def_okc_k_articles_tl_rec.comments,
2843: VARIATION_DESCRIPTION = l_def_okc_k_articles_tl_rec.variation_description,
2844: NAME = l_def_okc_k_articles_tl_rec.name,
2845: -- TEXT = l_def_okc_k_articles_tl_rec.text,
2846: CREATED_BY = l_def_okc_k_articles_tl_rec.created_by,
2847: CREATION_DATE = l_def_okc_k_articles_tl_rec.creation_date,
2848: LAST_UPDATED_BY = l_def_okc_k_articles_tl_rec.last_updated_by,
2841: SET OBJECT_VERSION_NUMBER = l_def_okc_k_articles_tl_rec.object_version_number,
2842: COMMENTS = l_def_okc_k_articles_tl_rec.comments,
2843: VARIATION_DESCRIPTION = l_def_okc_k_articles_tl_rec.variation_description,
2844: NAME = l_def_okc_k_articles_tl_rec.name,
2845: -- TEXT = l_def_okc_k_articles_tl_rec.text,
2846: CREATED_BY = l_def_okc_k_articles_tl_rec.created_by,
2847: CREATION_DATE = l_def_okc_k_articles_tl_rec.creation_date,
2848: LAST_UPDATED_BY = l_def_okc_k_articles_tl_rec.last_updated_by,
2849: LAST_UPDATE_DATE = l_def_okc_k_articles_tl_rec.last_update_date,
2842: COMMENTS = l_def_okc_k_articles_tl_rec.comments,
2843: VARIATION_DESCRIPTION = l_def_okc_k_articles_tl_rec.variation_description,
2844: NAME = l_def_okc_k_articles_tl_rec.name,
2845: -- TEXT = l_def_okc_k_articles_tl_rec.text,
2846: CREATED_BY = l_def_okc_k_articles_tl_rec.created_by,
2847: CREATION_DATE = l_def_okc_k_articles_tl_rec.creation_date,
2848: LAST_UPDATED_BY = l_def_okc_k_articles_tl_rec.last_updated_by,
2849: LAST_UPDATE_DATE = l_def_okc_k_articles_tl_rec.last_update_date,
2850: LAST_UPDATE_LOGIN = l_def_okc_k_articles_tl_rec.last_update_login,
2843: VARIATION_DESCRIPTION = l_def_okc_k_articles_tl_rec.variation_description,
2844: NAME = l_def_okc_k_articles_tl_rec.name,
2845: -- TEXT = l_def_okc_k_articles_tl_rec.text,
2846: CREATED_BY = l_def_okc_k_articles_tl_rec.created_by,
2847: CREATION_DATE = l_def_okc_k_articles_tl_rec.creation_date,
2848: LAST_UPDATED_BY = l_def_okc_k_articles_tl_rec.last_updated_by,
2849: LAST_UPDATE_DATE = l_def_okc_k_articles_tl_rec.last_update_date,
2850: LAST_UPDATE_LOGIN = l_def_okc_k_articles_tl_rec.last_update_login,
2851: SECURITY_GROUP_ID = l_def_okc_k_articles_tl_rec.security_group_id,
2844: NAME = l_def_okc_k_articles_tl_rec.name,
2845: -- TEXT = l_def_okc_k_articles_tl_rec.text,
2846: CREATED_BY = l_def_okc_k_articles_tl_rec.created_by,
2847: CREATION_DATE = l_def_okc_k_articles_tl_rec.creation_date,
2848: LAST_UPDATED_BY = l_def_okc_k_articles_tl_rec.last_updated_by,
2849: LAST_UPDATE_DATE = l_def_okc_k_articles_tl_rec.last_update_date,
2850: LAST_UPDATE_LOGIN = l_def_okc_k_articles_tl_rec.last_update_login,
2851: SECURITY_GROUP_ID = l_def_okc_k_articles_tl_rec.security_group_id,
2852: SAV_SAV_RELEASE = l_def_okc_k_articles_tl_rec.sav_sav_release
2845: -- TEXT = l_def_okc_k_articles_tl_rec.text,
2846: CREATED_BY = l_def_okc_k_articles_tl_rec.created_by,
2847: CREATION_DATE = l_def_okc_k_articles_tl_rec.creation_date,
2848: LAST_UPDATED_BY = l_def_okc_k_articles_tl_rec.last_updated_by,
2849: LAST_UPDATE_DATE = l_def_okc_k_articles_tl_rec.last_update_date,
2850: LAST_UPDATE_LOGIN = l_def_okc_k_articles_tl_rec.last_update_login,
2851: SECURITY_GROUP_ID = l_def_okc_k_articles_tl_rec.security_group_id,
2852: SAV_SAV_RELEASE = l_def_okc_k_articles_tl_rec.sav_sav_release
2853: --+
2846: CREATED_BY = l_def_okc_k_articles_tl_rec.created_by,
2847: CREATION_DATE = l_def_okc_k_articles_tl_rec.creation_date,
2848: LAST_UPDATED_BY = l_def_okc_k_articles_tl_rec.last_updated_by,
2849: LAST_UPDATE_DATE = l_def_okc_k_articles_tl_rec.last_update_date,
2850: LAST_UPDATE_LOGIN = l_def_okc_k_articles_tl_rec.last_update_login,
2851: SECURITY_GROUP_ID = l_def_okc_k_articles_tl_rec.security_group_id,
2852: SAV_SAV_RELEASE = l_def_okc_k_articles_tl_rec.sav_sav_release
2853: --+
2854: ,SOURCE_LANG = l_def_okc_k_articles_tl_rec.SOURCE_LANG
2847: CREATION_DATE = l_def_okc_k_articles_tl_rec.creation_date,
2848: LAST_UPDATED_BY = l_def_okc_k_articles_tl_rec.last_updated_by,
2849: LAST_UPDATE_DATE = l_def_okc_k_articles_tl_rec.last_update_date,
2850: LAST_UPDATE_LOGIN = l_def_okc_k_articles_tl_rec.last_update_login,
2851: SECURITY_GROUP_ID = l_def_okc_k_articles_tl_rec.security_group_id,
2852: SAV_SAV_RELEASE = l_def_okc_k_articles_tl_rec.sav_sav_release
2853: --+
2854: ,SOURCE_LANG = l_def_okc_k_articles_tl_rec.SOURCE_LANG
2855: --+
2848: LAST_UPDATED_BY = l_def_okc_k_articles_tl_rec.last_updated_by,
2849: LAST_UPDATE_DATE = l_def_okc_k_articles_tl_rec.last_update_date,
2850: LAST_UPDATE_LOGIN = l_def_okc_k_articles_tl_rec.last_update_login,
2851: SECURITY_GROUP_ID = l_def_okc_k_articles_tl_rec.security_group_id,
2852: SAV_SAV_RELEASE = l_def_okc_k_articles_tl_rec.sav_sav_release
2853: --+
2854: ,SOURCE_LANG = l_def_okc_k_articles_tl_rec.SOURCE_LANG
2855: --+
2856: WHERE ID = l_def_okc_k_articles_tl_rec.id
2850: LAST_UPDATE_LOGIN = l_def_okc_k_articles_tl_rec.last_update_login,
2851: SECURITY_GROUP_ID = l_def_okc_k_articles_tl_rec.security_group_id,
2852: SAV_SAV_RELEASE = l_def_okc_k_articles_tl_rec.sav_sav_release
2853: --+
2854: ,SOURCE_LANG = l_def_okc_k_articles_tl_rec.SOURCE_LANG
2855: --+
2856: WHERE ID = l_def_okc_k_articles_tl_rec.id
2857: --- AND SOURCE_LANG = USERENV('LANG');
2858: --+
2852: SAV_SAV_RELEASE = l_def_okc_k_articles_tl_rec.sav_sav_release
2853: --+
2854: ,SOURCE_LANG = l_def_okc_k_articles_tl_rec.SOURCE_LANG
2855: --+
2856: WHERE ID = l_def_okc_k_articles_tl_rec.id
2857: --- AND SOURCE_LANG = USERENV('LANG');
2858: --+
2859: AND USERENV('LANG') in (SOURCE_LANG,LANGUAGE);
2860: --+
2858: --+
2859: AND USERENV('LANG') in (SOURCE_LANG,LANGUAGE);
2860: --+
2861:
2862: UPDATE OKC_K_ARTICLES_TL
2863: SET SFWT_FLAG = 'Y'
2864: WHERE ID = l_def_okc_k_articles_tl_rec.id
2865: AND SOURCE_LANG <> USERENV('LANG');
2866:
2860: --+
2861:
2862: UPDATE OKC_K_ARTICLES_TL
2863: SET SFWT_FLAG = 'Y'
2864: WHERE ID = l_def_okc_k_articles_tl_rec.id
2865: AND SOURCE_LANG <> USERENV('LANG');
2866:
2867: x_okc_k_articles_tl_rec := l_def_okc_k_articles_tl_rec;
2868: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2863: SET SFWT_FLAG = 'Y'
2864: WHERE ID = l_def_okc_k_articles_tl_rec.id
2865: AND SOURCE_LANG <> USERENV('LANG');
2866:
2867: x_okc_k_articles_tl_rec := l_def_okc_k_articles_tl_rec;
2868: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2869: EXCEPTION
2870: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2871: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2914: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
2915: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2916: l_catv_rec catv_rec_type := p_catv_rec;
2917: l_def_catv_rec catv_rec_type;
2918: l_okc_k_articles_tl_rec okc_k_articles_tl_rec_type;
2919: lx_okc_k_articles_tl_rec okc_k_articles_tl_rec_type;
2920: l_cat_rec cat_rec_type;
2921: lx_cat_rec cat_rec_type;
2922: -------------------------------
2915: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2916: l_catv_rec catv_rec_type := p_catv_rec;
2917: l_def_catv_rec catv_rec_type;
2918: l_okc_k_articles_tl_rec okc_k_articles_tl_rec_type;
2919: lx_okc_k_articles_tl_rec okc_k_articles_tl_rec_type;
2920: l_cat_rec cat_rec_type;
2921: lx_cat_rec cat_rec_type;
2922: -------------------------------
2923: -- FUNCTION fill_who_columns --
3163:
3164: --------------------------------------
3165: -- Move VIEW record to "Child" records
3166: --------------------------------------
3167: migrate(l_def_catv_rec, l_okc_k_articles_tl_rec);
3168: migrate(l_def_catv_rec, l_cat_rec);
3169: --------------------------------------------
3170: -- Call the UPDATE_ROW for each child record
3171: --------------------------------------------
3173: p_init_msg_list,
3174: x_return_status,
3175: x_msg_count,
3176: x_msg_data,
3177: l_okc_k_articles_tl_rec,
3178: lx_okc_k_articles_tl_rec
3179: );
3180: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3181: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3174: x_return_status,
3175: x_msg_count,
3176: x_msg_data,
3177: l_okc_k_articles_tl_rec,
3178: lx_okc_k_articles_tl_rec
3179: );
3180: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3181: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3182: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3181: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3182: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3183: RAISE OKC_API.G_EXCEPTION_ERROR;
3184: END IF;
3185: migrate(lx_okc_k_articles_tl_rec, l_def_catv_rec);
3186: update_row(
3187: p_init_msg_list,
3188: x_return_status,
3189: x_msg_count,
3362: '_PVT'
3363: );
3364: END delete_row;
3365: --------------------------------------
3366: -- delete_row for:OKC_K_ARTICLES_TL --
3367: --------------------------------------
3368: PROCEDURE delete_row(
3369: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3370: x_return_status OUT NOCOPY VARCHAR2,
3369: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3370: x_return_status OUT NOCOPY VARCHAR2,
3371: x_msg_count OUT NOCOPY NUMBER,
3372: x_msg_data OUT NOCOPY VARCHAR2,
3373: p_okc_k_articles_tl_rec IN okc_k_articles_tl_rec_type) IS
3374:
3375: l_api_version CONSTANT NUMBER := 1;
3376: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3377: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3374:
3375: l_api_version CONSTANT NUMBER := 1;
3376: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3377: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3378: l_okc_k_articles_tl_rec okc_k_articles_tl_rec_type:= p_okc_k_articles_tl_rec;
3379: l_row_notfound BOOLEAN := TRUE;
3380: ------------------------------------------
3381: -- Set_Attributes for:OKC_K_ARTICLES_TL --
3382: ------------------------------------------
3377: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3378: l_okc_k_articles_tl_rec okc_k_articles_tl_rec_type:= p_okc_k_articles_tl_rec;
3379: l_row_notfound BOOLEAN := TRUE;
3380: ------------------------------------------
3381: -- Set_Attributes for:OKC_K_ARTICLES_TL --
3382: ------------------------------------------
3383: FUNCTION Set_Attributes (
3384: p_okc_k_articles_tl_rec IN okc_k_articles_tl_rec_type,
3385: x_okc_k_articles_tl_rec OUT NOCOPY okc_k_articles_tl_rec_type
3380: ------------------------------------------
3381: -- Set_Attributes for:OKC_K_ARTICLES_TL --
3382: ------------------------------------------
3383: FUNCTION Set_Attributes (
3384: p_okc_k_articles_tl_rec IN okc_k_articles_tl_rec_type,
3385: x_okc_k_articles_tl_rec OUT NOCOPY okc_k_articles_tl_rec_type
3386: ) RETURN VARCHAR2 IS
3387: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3388: BEGIN
3381: -- Set_Attributes for:OKC_K_ARTICLES_TL --
3382: ------------------------------------------
3383: FUNCTION Set_Attributes (
3384: p_okc_k_articles_tl_rec IN okc_k_articles_tl_rec_type,
3385: x_okc_k_articles_tl_rec OUT NOCOPY okc_k_articles_tl_rec_type
3386: ) RETURN VARCHAR2 IS
3387: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3388: BEGIN
3389: x_okc_k_articles_tl_rec := p_okc_k_articles_tl_rec;
3385: x_okc_k_articles_tl_rec OUT NOCOPY okc_k_articles_tl_rec_type
3386: ) RETURN VARCHAR2 IS
3387: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3388: BEGIN
3389: x_okc_k_articles_tl_rec := p_okc_k_articles_tl_rec;
3390: x_okc_k_articles_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
3391: RETURN(l_return_status);
3392: END Set_Attributes;
3393: BEGIN
3386: ) RETURN VARCHAR2 IS
3387: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3388: BEGIN
3389: x_okc_k_articles_tl_rec := p_okc_k_articles_tl_rec;
3390: x_okc_k_articles_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
3391: RETURN(l_return_status);
3392: END Set_Attributes;
3393: BEGIN
3394: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
3401: RAISE OKC_API.G_EXCEPTION_ERROR;
3402: END IF;
3403: --- Setting item attributes
3404: l_return_status := Set_Attributes(
3405: p_okc_k_articles_tl_rec, -- IN
3406: l_okc_k_articles_tl_rec); -- OUT
3407: --- If any errors happen abort API
3408: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3409: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3402: END IF;
3403: --- Setting item attributes
3404: l_return_status := Set_Attributes(
3405: p_okc_k_articles_tl_rec, -- IN
3406: l_okc_k_articles_tl_rec); -- OUT
3407: --- If any errors happen abort API
3408: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3409: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3410: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3409: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3410: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3411: RAISE OKC_API.G_EXCEPTION_ERROR;
3412: END IF;
3413: DELETE FROM OKC_K_ARTICLES_TL
3414: WHERE ID = l_okc_k_articles_tl_rec.id;
3415:
3416: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3417: EXCEPTION
3410: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3411: RAISE OKC_API.G_EXCEPTION_ERROR;
3412: END IF;
3413: DELETE FROM OKC_K_ARTICLES_TL
3414: WHERE ID = l_okc_k_articles_tl_rec.id;
3415:
3416: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3417: EXCEPTION
3418: WHEN OKC_API.G_EXCEPTION_ERROR THEN
3460: l_api_version CONSTANT NUMBER := 1;
3461: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
3462: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3463: l_catv_rec catv_rec_type := p_catv_rec;
3464: l_okc_k_articles_tl_rec okc_k_articles_tl_rec_type;
3465: l_cat_rec cat_rec_type;
3466: BEGIN
3467: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
3468: G_PKG_NAME,
3478: END IF;
3479: --------------------------------------
3480: -- Move VIEW record to "Child" records
3481: --------------------------------------
3482: migrate(l_catv_rec, l_okc_k_articles_tl_rec);
3483: migrate(l_catv_rec, l_cat_rec);
3484: --------------------------------------------
3485: -- Call the DELETE_ROW for each child record
3486: --------------------------------------------
3488: p_init_msg_list,
3489: x_return_status,
3490: x_msg_count,
3491: x_msg_data,
3492: l_okc_k_articles_tl_rec
3493: );
3494: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3495: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3496: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3770: );
3771:
3772: FOR lang_i IN OKC_UTIL.g_language_code.FIRST..OKC_UTIL.g_language_code.LAST LOOP
3773: FORALL i in 1..l_tabsize
3774: INSERT INTO OKC_K_ARTICLES_TL(
3775: id,
3776: language,
3777: source_lang,
3778: sfwt_flag,
3901: --------------------------------
3902: -- Versioning TL Table
3903: -------------------------------
3904:
3905: INSERT INTO okc_k_articles_tlh
3906: (
3907: major_version,
3908: id,
3909: language,
3939: last_update_date,
3940: last_update_login,
3941: security_group_id,
3942: sav_sav_release
3943: FROM okc_k_articles_tl
3944: WHERE id in (select id from okc_k_articles_b
3945: where dnz_chr_id = p_chr_id);
3946:
3947: RETURN l_return_status;
3972:
3973: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
3974:
3975: BEGIN
3976: INSERT INTO okc_k_articles_tl
3977: (
3978: id,
3979: language,
3980: source_lang,
4008: last_update_date,
4009: last_update_login,
4010: security_group_id,
4011: sav_sav_release
4012: FROM okc_k_articles_tlh
4013: WHERE id in (SELECT id
4014: FROM okc_k_articles_bh
4015: WHERE dnz_chr_id = p_chr_id)
4016: AND major_version = p_major_version;