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

APPS.OKC_CAT_PVT dependencies on OKC_K_ARTICLES_TL

Line 62: DELETE FROM OKC_K_ARTICLES_TL T

58: okc_debug.Set_Indentation('OKC_CAT_PVT');
59: okc_debug.log('500: Entered add_language', 2);
60: END IF;
61:
62: DELETE FROM OKC_K_ARTICLES_TL T
63: WHERE NOT EXISTS (
64: SELECT NULL
65: FROM OKC_K_ARTICLES_B B
66: WHERE B.ID = T.ID

Line 69: UPDATE OKC_K_ARTICLES_TL T SET (

65: FROM OKC_K_ARTICLES_B B
66: WHERE B.ID = T.ID
67: );
68:
69: UPDATE OKC_K_ARTICLES_TL T SET (
70: COMMENTS,
71: VARIATION_DESCRIPTION,
72: NAME,
73: TEXT,

Line 80: FROM OKC_K_ARTICLES_TL B

76: B.VARIATION_DESCRIPTION,
77: B.NAME,
78: B.TEXT,
79: B.SAV_SAV_RELEASE
80: FROM OKC_K_ARTICLES_TL B
81: WHERE B.ID = T.ID
82: AND B.LANGUAGE = T.SOURCE_LANG)
83: WHERE (
84: T.ID,

Line 89: FROM OKC_K_ARTICLES_TL SUBB, OKC_K_ARTICLES_TL SUBT

85: T.LANGUAGE)
86: IN (SELECT
87: SUBT.ID,
88: SUBT.LANGUAGE
89: FROM OKC_K_ARTICLES_TL SUBB, OKC_K_ARTICLES_TL SUBT
90: WHERE SUBB.ID = SUBT.ID
91: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
92: AND (SUBB.COMMENTS <> SUBT.COMMENTS
93: OR SUBB.VARIATION_DESCRIPTION <> SUBT.VARIATION_DESCRIPTION

Line 114: INSERT INTO OKC_K_ARTICLES_TL (

110: OR (SUBB.SAV_SAV_RELEASE IS NULL AND SUBT.SAV_SAV_RELEASE IS NOT NULL)
111: OR (SUBB.SAV_SAV_RELEASE IS NOT NULL AND SUBT.SAV_SAV_RELEASE IS NULL)
112: ));
113:
114: INSERT INTO OKC_K_ARTICLES_TL (
115: ID,
116: LANGUAGE,
117: SOURCE_LANG,
118: SFWT_FLAG,

Line 146: FROM OKC_K_ARTICLES_TL B, FND_LANGUAGES L

142: B.LAST_UPDATED_BY,
143: B.LAST_UPDATE_DATE,
144: B.LAST_UPDATE_LOGIN,
145: B.SAV_SAV_RELEASE
146: FROM OKC_K_ARTICLES_TL B, FND_LANGUAGES L
147: WHERE L.INSTALLED_FLAG IN ('I', 'B')
148: AND B.LANGUAGE = USERENV('LANG')
149: AND NOT EXISTS(
150: SELECT NULL

Line 151: FROM OKC_K_ARTICLES_TL T

147: WHERE L.INSTALLED_FLAG IN ('I', 'B')
148: AND B.LANGUAGE = USERENV('LANG')
149: AND NOT EXISTS(
150: SELECT NULL
151: FROM OKC_K_ARTICLES_TL T
152: WHERE T.ID = B.ID
153: AND T.LANGUAGE = L.LANGUAGE_CODE
154: );
155: DELETE FROM OKC_K_ARTICLES_TLH T

Line 155: DELETE FROM OKC_K_ARTICLES_TLH T

151: FROM OKC_K_ARTICLES_TL T
152: WHERE T.ID = B.ID
153: AND T.LANGUAGE = L.LANGUAGE_CODE
154: );
155: DELETE FROM OKC_K_ARTICLES_TLH T
156: WHERE NOT EXISTS (
157: SELECT NULL
158: FROM OKC_K_ARTICLES_BH B
159: WHERE B.ID = T.ID

Line 163: UPDATE OKC_K_ARTICLES_TLH T SET (

159: WHERE B.ID = T.ID
160: AND B.MAJOR_VERSION = T.MAJOR_VERSION
161: );
162:
163: UPDATE OKC_K_ARTICLES_TLH T SET (
164: COMMENTS,
165: VARIATION_DESCRIPTION,
166: NAME,
167: TEXT,

Line 174: FROM OKC_K_ARTICLES_TLH B

170: B.VARIATION_DESCRIPTION,
171: B.NAME,
172: B.TEXT,
173: B.SAV_SAV_RELEASE
174: FROM OKC_K_ARTICLES_TLH B
175: WHERE B.ID = T.ID
176: AND B.MAJOR_VERSION = T.MAJOR_VERSION
177: AND B.LANGUAGE = T.SOURCE_LANG)
178: WHERE (

Line 186: FROM OKC_K_ARTICLES_TLH SUBB, OKC_K_ARTICLES_TLH SUBT

182: IN (SELECT
183: SUBT.ID,
184: SUBT.MAJOR_VERSION,
185: SUBT.LANGUAGE
186: FROM OKC_K_ARTICLES_TLH SUBB, OKC_K_ARTICLES_TLH SUBT
187: WHERE SUBB.ID = SUBT.ID
188: AND SUBB.MAJOR_VERSION = SUBT.MAJOR_VERSION
189: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
190: AND (SUBB.COMMENTS <> SUBT.COMMENTS

Line 208: INSERT INTO OKC_K_ARTICLES_TLH (

204: OR (SUBB.SAV_SAV_RELEASE IS NULL AND SUBT.SAV_SAV_RELEASE IS NOT NULL)
205: OR (SUBB.SAV_SAV_RELEASE IS NOT NULL AND SUBT.SAV_SAV_RELEASE IS NULL)
206: ));
207:
208: INSERT INTO OKC_K_ARTICLES_TLH (
209: ID,
210: LANGUAGE,
211: MAJOR_VERSION,
212: SOURCE_LANG,

Line 242: FROM OKC_K_ARTICLES_TLH B, FND_LANGUAGES L

238: B.LAST_UPDATED_BY,
239: B.LAST_UPDATE_DATE,
240: B.LAST_UPDATE_LOGIN,
241: B.SAV_SAV_RELEASE
242: FROM OKC_K_ARTICLES_TLH B, FND_LANGUAGES L
243: WHERE L.INSTALLED_FLAG IN ('I', 'B')
244: AND B.LANGUAGE = USERENV('LANG')
245: AND NOT EXISTS(
246: SELECT NULL

Line 247: FROM OKC_K_ARTICLES_TLH T

243: WHERE L.INSTALLED_FLAG IN ('I', 'B')
244: AND B.LANGUAGE = USERENV('LANG')
245: AND NOT EXISTS(
246: SELECT NULL
247: FROM OKC_K_ARTICLES_TLH T
248: WHERE T.ID = B.ID
249: AND T.MAJOR_VERSION = B.MAJOR_VERSION
250: AND T.LANGUAGE = L.LANGUAGE_CODE
251: );

Line 369: -- FUNCTION get_rec for: OKC_K_ARTICLES_TL

365: RETURN(get_rec(p_cat_rec, l_row_notfound));
366:
367: END get_rec;
368: ---------------------------------------------------------------------------
369: -- FUNCTION get_rec for: OKC_K_ARTICLES_TL
370: ---------------------------------------------------------------------------
371: FUNCTION get_rec (
372: p_okc_k_articles_tl_rec IN okc_k_articles_tl_rec_type,
373: x_no_data_found OUT NOCOPY BOOLEAN

Line 372: p_okc_k_articles_tl_rec IN okc_k_articles_tl_rec_type,

368: ---------------------------------------------------------------------------
369: -- FUNCTION get_rec for: OKC_K_ARTICLES_TL
370: ---------------------------------------------------------------------------
371: FUNCTION get_rec (
372: p_okc_k_articles_tl_rec IN okc_k_articles_tl_rec_type,
373: x_no_data_found OUT NOCOPY BOOLEAN
374: ) RETURN okc_k_articles_tl_rec_type IS
375: CURSOR okc_k_articles_tl_pk_csr (p_id IN NUMBER,
376: p_language IN VARCHAR2) IS

Line 374: ) RETURN okc_k_articles_tl_rec_type IS

370: ---------------------------------------------------------------------------
371: FUNCTION get_rec (
372: p_okc_k_articles_tl_rec IN okc_k_articles_tl_rec_type,
373: x_no_data_found OUT NOCOPY BOOLEAN
374: ) RETURN okc_k_articles_tl_rec_type IS
375: CURSOR okc_k_articles_tl_pk_csr (p_id IN NUMBER,
376: p_language IN VARCHAR2) IS
377: SELECT
378: ID,

Line 375: CURSOR okc_k_articles_tl_pk_csr (p_id IN NUMBER,

371: FUNCTION get_rec (
372: p_okc_k_articles_tl_rec IN okc_k_articles_tl_rec_type,
373: x_no_data_found OUT NOCOPY BOOLEAN
374: ) RETURN okc_k_articles_tl_rec_type IS
375: CURSOR okc_k_articles_tl_pk_csr (p_id IN NUMBER,
376: p_language IN VARCHAR2) IS
377: SELECT
378: ID,
379: LANGUAGE,

Line 393: FROM Okc_K_Articles_Tl

389: LAST_UPDATED_BY,
390: LAST_UPDATE_DATE,
391: LAST_UPDATE_LOGIN,
392: SAV_SAV_RELEASE
393: FROM Okc_K_Articles_Tl
394: WHERE okc_k_articles_tl.id = p_id
395: AND okc_k_articles_tl.language = p_language;
396: l_okc_k_articles_tl_pk okc_k_articles_tl_pk_csr%ROWTYPE;
397: l_okc_k_articles_tl_rec okc_k_articles_tl_rec_type;

Line 394: WHERE okc_k_articles_tl.id = p_id

390: LAST_UPDATE_DATE,
391: LAST_UPDATE_LOGIN,
392: SAV_SAV_RELEASE
393: FROM Okc_K_Articles_Tl
394: WHERE okc_k_articles_tl.id = p_id
395: AND okc_k_articles_tl.language = p_language;
396: l_okc_k_articles_tl_pk okc_k_articles_tl_pk_csr%ROWTYPE;
397: l_okc_k_articles_tl_rec okc_k_articles_tl_rec_type;
398: BEGIN

Line 395: AND okc_k_articles_tl.language = p_language;

391: LAST_UPDATE_LOGIN,
392: SAV_SAV_RELEASE
393: FROM Okc_K_Articles_Tl
394: WHERE okc_k_articles_tl.id = p_id
395: AND okc_k_articles_tl.language = p_language;
396: l_okc_k_articles_tl_pk okc_k_articles_tl_pk_csr%ROWTYPE;
397: l_okc_k_articles_tl_rec okc_k_articles_tl_rec_type;
398: BEGIN
399:

Line 396: l_okc_k_articles_tl_pk okc_k_articles_tl_pk_csr%ROWTYPE;

392: SAV_SAV_RELEASE
393: FROM Okc_K_Articles_Tl
394: WHERE okc_k_articles_tl.id = p_id
395: AND okc_k_articles_tl.language = p_language;
396: l_okc_k_articles_tl_pk okc_k_articles_tl_pk_csr%ROWTYPE;
397: l_okc_k_articles_tl_rec okc_k_articles_tl_rec_type;
398: BEGIN
399:
400: IF (l_debug = 'Y') THEN

Line 397: l_okc_k_articles_tl_rec okc_k_articles_tl_rec_type;

393: FROM Okc_K_Articles_Tl
394: WHERE okc_k_articles_tl.id = p_id
395: AND okc_k_articles_tl.language = p_language;
396: l_okc_k_articles_tl_pk okc_k_articles_tl_pk_csr%ROWTYPE;
397: l_okc_k_articles_tl_rec okc_k_articles_tl_rec_type;
398: BEGIN
399:
400: IF (l_debug = 'Y') THEN
401: okc_debug.Set_Indentation('OKC_CAT_PVT');

Line 407: OPEN okc_k_articles_tl_pk_csr (p_okc_k_articles_tl_rec.id,

403: END IF;
404:
405: x_no_data_found := TRUE;
406: -- Get current database values
407: OPEN okc_k_articles_tl_pk_csr (p_okc_k_articles_tl_rec.id,
408: p_okc_k_articles_tl_rec.language);
409: FETCH okc_k_articles_tl_pk_csr INTO
410: l_okc_k_articles_tl_rec.ID,
411: l_okc_k_articles_tl_rec.LANGUAGE,

Line 408: p_okc_k_articles_tl_rec.language);

404:
405: x_no_data_found := TRUE;
406: -- Get current database values
407: OPEN okc_k_articles_tl_pk_csr (p_okc_k_articles_tl_rec.id,
408: p_okc_k_articles_tl_rec.language);
409: FETCH okc_k_articles_tl_pk_csr INTO
410: l_okc_k_articles_tl_rec.ID,
411: l_okc_k_articles_tl_rec.LANGUAGE,
412: l_okc_k_articles_tl_rec.SOURCE_LANG,

Line 409: FETCH okc_k_articles_tl_pk_csr INTO

405: x_no_data_found := TRUE;
406: -- Get current database values
407: OPEN okc_k_articles_tl_pk_csr (p_okc_k_articles_tl_rec.id,
408: p_okc_k_articles_tl_rec.language);
409: FETCH okc_k_articles_tl_pk_csr INTO
410: l_okc_k_articles_tl_rec.ID,
411: l_okc_k_articles_tl_rec.LANGUAGE,
412: l_okc_k_articles_tl_rec.SOURCE_LANG,
413: l_okc_k_articles_tl_rec.SFWT_FLAG,

Line 410: l_okc_k_articles_tl_rec.ID,

406: -- Get current database values
407: OPEN okc_k_articles_tl_pk_csr (p_okc_k_articles_tl_rec.id,
408: p_okc_k_articles_tl_rec.language);
409: FETCH okc_k_articles_tl_pk_csr INTO
410: l_okc_k_articles_tl_rec.ID,
411: l_okc_k_articles_tl_rec.LANGUAGE,
412: l_okc_k_articles_tl_rec.SOURCE_LANG,
413: l_okc_k_articles_tl_rec.SFWT_FLAG,
414: l_okc_k_articles_tl_rec.OBJECT_VERSION_NUMBER,

Line 411: l_okc_k_articles_tl_rec.LANGUAGE,

407: OPEN okc_k_articles_tl_pk_csr (p_okc_k_articles_tl_rec.id,
408: p_okc_k_articles_tl_rec.language);
409: FETCH okc_k_articles_tl_pk_csr INTO
410: l_okc_k_articles_tl_rec.ID,
411: l_okc_k_articles_tl_rec.LANGUAGE,
412: l_okc_k_articles_tl_rec.SOURCE_LANG,
413: l_okc_k_articles_tl_rec.SFWT_FLAG,
414: l_okc_k_articles_tl_rec.OBJECT_VERSION_NUMBER,
415: l_okc_k_articles_tl_rec.COMMENTS,

Line 412: l_okc_k_articles_tl_rec.SOURCE_LANG,

408: p_okc_k_articles_tl_rec.language);
409: FETCH okc_k_articles_tl_pk_csr INTO
410: l_okc_k_articles_tl_rec.ID,
411: l_okc_k_articles_tl_rec.LANGUAGE,
412: l_okc_k_articles_tl_rec.SOURCE_LANG,
413: l_okc_k_articles_tl_rec.SFWT_FLAG,
414: l_okc_k_articles_tl_rec.OBJECT_VERSION_NUMBER,
415: l_okc_k_articles_tl_rec.COMMENTS,
416: l_okc_k_articles_tl_rec.VARIATION_DESCRIPTION,

Line 413: l_okc_k_articles_tl_rec.SFWT_FLAG,

409: FETCH okc_k_articles_tl_pk_csr INTO
410: l_okc_k_articles_tl_rec.ID,
411: l_okc_k_articles_tl_rec.LANGUAGE,
412: l_okc_k_articles_tl_rec.SOURCE_LANG,
413: l_okc_k_articles_tl_rec.SFWT_FLAG,
414: l_okc_k_articles_tl_rec.OBJECT_VERSION_NUMBER,
415: l_okc_k_articles_tl_rec.COMMENTS,
416: l_okc_k_articles_tl_rec.VARIATION_DESCRIPTION,
417: l_okc_k_articles_tl_rec.NAME,

Line 414: l_okc_k_articles_tl_rec.OBJECT_VERSION_NUMBER,

410: l_okc_k_articles_tl_rec.ID,
411: l_okc_k_articles_tl_rec.LANGUAGE,
412: l_okc_k_articles_tl_rec.SOURCE_LANG,
413: l_okc_k_articles_tl_rec.SFWT_FLAG,
414: l_okc_k_articles_tl_rec.OBJECT_VERSION_NUMBER,
415: l_okc_k_articles_tl_rec.COMMENTS,
416: l_okc_k_articles_tl_rec.VARIATION_DESCRIPTION,
417: l_okc_k_articles_tl_rec.NAME,
418: l_okc_k_articles_tl_rec.TEXT,

Line 415: l_okc_k_articles_tl_rec.COMMENTS,

411: l_okc_k_articles_tl_rec.LANGUAGE,
412: l_okc_k_articles_tl_rec.SOURCE_LANG,
413: l_okc_k_articles_tl_rec.SFWT_FLAG,
414: l_okc_k_articles_tl_rec.OBJECT_VERSION_NUMBER,
415: l_okc_k_articles_tl_rec.COMMENTS,
416: l_okc_k_articles_tl_rec.VARIATION_DESCRIPTION,
417: l_okc_k_articles_tl_rec.NAME,
418: l_okc_k_articles_tl_rec.TEXT,
419: l_okc_k_articles_tl_rec.CREATED_BY,

Line 416: l_okc_k_articles_tl_rec.VARIATION_DESCRIPTION,

412: l_okc_k_articles_tl_rec.SOURCE_LANG,
413: l_okc_k_articles_tl_rec.SFWT_FLAG,
414: l_okc_k_articles_tl_rec.OBJECT_VERSION_NUMBER,
415: l_okc_k_articles_tl_rec.COMMENTS,
416: l_okc_k_articles_tl_rec.VARIATION_DESCRIPTION,
417: l_okc_k_articles_tl_rec.NAME,
418: l_okc_k_articles_tl_rec.TEXT,
419: l_okc_k_articles_tl_rec.CREATED_BY,
420: l_okc_k_articles_tl_rec.CREATION_DATE,

Line 417: l_okc_k_articles_tl_rec.NAME,

413: l_okc_k_articles_tl_rec.SFWT_FLAG,
414: l_okc_k_articles_tl_rec.OBJECT_VERSION_NUMBER,
415: l_okc_k_articles_tl_rec.COMMENTS,
416: l_okc_k_articles_tl_rec.VARIATION_DESCRIPTION,
417: l_okc_k_articles_tl_rec.NAME,
418: l_okc_k_articles_tl_rec.TEXT,
419: l_okc_k_articles_tl_rec.CREATED_BY,
420: l_okc_k_articles_tl_rec.CREATION_DATE,
421: l_okc_k_articles_tl_rec.LAST_UPDATED_BY,

Line 418: l_okc_k_articles_tl_rec.TEXT,

414: l_okc_k_articles_tl_rec.OBJECT_VERSION_NUMBER,
415: l_okc_k_articles_tl_rec.COMMENTS,
416: l_okc_k_articles_tl_rec.VARIATION_DESCRIPTION,
417: l_okc_k_articles_tl_rec.NAME,
418: l_okc_k_articles_tl_rec.TEXT,
419: l_okc_k_articles_tl_rec.CREATED_BY,
420: l_okc_k_articles_tl_rec.CREATION_DATE,
421: l_okc_k_articles_tl_rec.LAST_UPDATED_BY,
422: l_okc_k_articles_tl_rec.LAST_UPDATE_DATE,

Line 419: l_okc_k_articles_tl_rec.CREATED_BY,

415: l_okc_k_articles_tl_rec.COMMENTS,
416: l_okc_k_articles_tl_rec.VARIATION_DESCRIPTION,
417: l_okc_k_articles_tl_rec.NAME,
418: l_okc_k_articles_tl_rec.TEXT,
419: l_okc_k_articles_tl_rec.CREATED_BY,
420: l_okc_k_articles_tl_rec.CREATION_DATE,
421: l_okc_k_articles_tl_rec.LAST_UPDATED_BY,
422: l_okc_k_articles_tl_rec.LAST_UPDATE_DATE,
423: l_okc_k_articles_tl_rec.LAST_UPDATE_LOGIN,

Line 420: l_okc_k_articles_tl_rec.CREATION_DATE,

416: l_okc_k_articles_tl_rec.VARIATION_DESCRIPTION,
417: l_okc_k_articles_tl_rec.NAME,
418: l_okc_k_articles_tl_rec.TEXT,
419: l_okc_k_articles_tl_rec.CREATED_BY,
420: l_okc_k_articles_tl_rec.CREATION_DATE,
421: l_okc_k_articles_tl_rec.LAST_UPDATED_BY,
422: l_okc_k_articles_tl_rec.LAST_UPDATE_DATE,
423: l_okc_k_articles_tl_rec.LAST_UPDATE_LOGIN,
424: l_okc_k_articles_tl_rec.SAV_SAV_RELEASE;

Line 421: l_okc_k_articles_tl_rec.LAST_UPDATED_BY,

417: l_okc_k_articles_tl_rec.NAME,
418: l_okc_k_articles_tl_rec.TEXT,
419: l_okc_k_articles_tl_rec.CREATED_BY,
420: l_okc_k_articles_tl_rec.CREATION_DATE,
421: l_okc_k_articles_tl_rec.LAST_UPDATED_BY,
422: l_okc_k_articles_tl_rec.LAST_UPDATE_DATE,
423: l_okc_k_articles_tl_rec.LAST_UPDATE_LOGIN,
424: l_okc_k_articles_tl_rec.SAV_SAV_RELEASE;
425: x_no_data_found := okc_k_articles_tl_pk_csr%NOTFOUND;

Line 422: l_okc_k_articles_tl_rec.LAST_UPDATE_DATE,

418: l_okc_k_articles_tl_rec.TEXT,
419: l_okc_k_articles_tl_rec.CREATED_BY,
420: l_okc_k_articles_tl_rec.CREATION_DATE,
421: l_okc_k_articles_tl_rec.LAST_UPDATED_BY,
422: l_okc_k_articles_tl_rec.LAST_UPDATE_DATE,
423: l_okc_k_articles_tl_rec.LAST_UPDATE_LOGIN,
424: l_okc_k_articles_tl_rec.SAV_SAV_RELEASE;
425: x_no_data_found := okc_k_articles_tl_pk_csr%NOTFOUND;
426: CLOSE okc_k_articles_tl_pk_csr;

Line 423: l_okc_k_articles_tl_rec.LAST_UPDATE_LOGIN,

419: l_okc_k_articles_tl_rec.CREATED_BY,
420: l_okc_k_articles_tl_rec.CREATION_DATE,
421: l_okc_k_articles_tl_rec.LAST_UPDATED_BY,
422: l_okc_k_articles_tl_rec.LAST_UPDATE_DATE,
423: l_okc_k_articles_tl_rec.LAST_UPDATE_LOGIN,
424: l_okc_k_articles_tl_rec.SAV_SAV_RELEASE;
425: x_no_data_found := okc_k_articles_tl_pk_csr%NOTFOUND;
426: CLOSE okc_k_articles_tl_pk_csr;
427:

Line 424: l_okc_k_articles_tl_rec.SAV_SAV_RELEASE;

420: l_okc_k_articles_tl_rec.CREATION_DATE,
421: l_okc_k_articles_tl_rec.LAST_UPDATED_BY,
422: l_okc_k_articles_tl_rec.LAST_UPDATE_DATE,
423: l_okc_k_articles_tl_rec.LAST_UPDATE_LOGIN,
424: l_okc_k_articles_tl_rec.SAV_SAV_RELEASE;
425: x_no_data_found := okc_k_articles_tl_pk_csr%NOTFOUND;
426: CLOSE okc_k_articles_tl_pk_csr;
427:
428: IF (l_debug = 'Y') THEN

Line 425: x_no_data_found := okc_k_articles_tl_pk_csr%NOTFOUND;

421: l_okc_k_articles_tl_rec.LAST_UPDATED_BY,
422: l_okc_k_articles_tl_rec.LAST_UPDATE_DATE,
423: l_okc_k_articles_tl_rec.LAST_UPDATE_LOGIN,
424: l_okc_k_articles_tl_rec.SAV_SAV_RELEASE;
425: x_no_data_found := okc_k_articles_tl_pk_csr%NOTFOUND;
426: CLOSE okc_k_articles_tl_pk_csr;
427:
428: IF (l_debug = 'Y') THEN
429: okc_debug.log('900: Leaving Get_Rec ', 2);

Line 426: CLOSE okc_k_articles_tl_pk_csr;

422: l_okc_k_articles_tl_rec.LAST_UPDATE_DATE,
423: l_okc_k_articles_tl_rec.LAST_UPDATE_LOGIN,
424: l_okc_k_articles_tl_rec.SAV_SAV_RELEASE;
425: x_no_data_found := okc_k_articles_tl_pk_csr%NOTFOUND;
426: CLOSE okc_k_articles_tl_pk_csr;
427:
428: IF (l_debug = 'Y') THEN
429: okc_debug.log('900: Leaving Get_Rec ', 2);
430: okc_debug.Reset_Indentation;

Line 433: RETURN(l_okc_k_articles_tl_rec);

429: okc_debug.log('900: Leaving Get_Rec ', 2);
430: okc_debug.Reset_Indentation;
431: END IF;
432:
433: RETURN(l_okc_k_articles_tl_rec);
434: END get_rec;
435:
436: FUNCTION get_rec (
437: p_okc_k_articles_tl_rec IN okc_k_articles_tl_rec_type

Line 437: p_okc_k_articles_tl_rec IN okc_k_articles_tl_rec_type

433: RETURN(l_okc_k_articles_tl_rec);
434: END get_rec;
435:
436: FUNCTION get_rec (
437: p_okc_k_articles_tl_rec IN okc_k_articles_tl_rec_type
438: ) RETURN okc_k_articles_tl_rec_type IS
439: l_row_notfound BOOLEAN := TRUE;
440: BEGIN
441:

Line 438: ) RETURN okc_k_articles_tl_rec_type IS

434: END get_rec;
435:
436: FUNCTION get_rec (
437: p_okc_k_articles_tl_rec IN okc_k_articles_tl_rec_type
438: ) RETURN okc_k_articles_tl_rec_type IS
439: l_row_notfound BOOLEAN := TRUE;
440: BEGIN
441:
442: RETURN(get_rec(p_okc_k_articles_tl_rec, l_row_notfound));

Line 442: RETURN(get_rec(p_okc_k_articles_tl_rec, l_row_notfound));

438: ) RETURN okc_k_articles_tl_rec_type IS
439: l_row_notfound BOOLEAN := TRUE;
440: BEGIN
441:
442: RETURN(get_rec(p_okc_k_articles_tl_rec, l_row_notfound));
443:
444: END get_rec;
445: ---------------------------------------------------------------------------
446: -- FUNCTION get_rec for: OKC_K_ARTICLES_V

Line 1403: p_to IN OUT NOCOPY okc_k_articles_tl_rec_type

1399:
1400:
1401: PROCEDURE migrate (
1402: p_from IN catv_rec_type,
1403: p_to IN OUT NOCOPY okc_k_articles_tl_rec_type
1404: ) IS
1405: BEGIN
1406:
1407: p_to.id := p_from.id;

Line 1425: p_from IN okc_k_articles_tl_rec_type,

1421: END migrate;
1422:
1423:
1424: PROCEDURE migrate (
1425: p_from IN okc_k_articles_tl_rec_type,
1426: p_to IN OUT NOCOPY catv_rec_type
1427: ) IS
1428: BEGIN
1429:

Line 1465: l_okc_k_articles_tl_rec okc_k_articles_tl_rec_type;

1461: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
1462: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1463: l_catv_rec catv_rec_type := p_catv_rec;
1464: l_cat_rec cat_rec_type;
1465: l_okc_k_articles_tl_rec okc_k_articles_tl_rec_type;
1466: BEGIN
1467:
1468: IF (l_debug = 'Y') THEN
1469: okc_debug.Set_Indentation('OKC_CAT_PVT');

Line 1837: -- insert_row for:OKC_K_ARTICLES_TL --

1833: );
1834:
1835: END insert_row;
1836: --------------------------------------
1837: -- insert_row for:OKC_K_ARTICLES_TL --
1838: --------------------------------------
1839: PROCEDURE insert_row(
1840: p_init_msg_list IN VARCHAR2 ,
1841: x_return_status OUT NOCOPY VARCHAR2,

Line 1844: p_okc_k_articles_tl_rec IN okc_k_articles_tl_rec_type,

1840: p_init_msg_list IN VARCHAR2 ,
1841: x_return_status OUT NOCOPY VARCHAR2,
1842: x_msg_count OUT NOCOPY NUMBER,
1843: x_msg_data OUT NOCOPY VARCHAR2,
1844: p_okc_k_articles_tl_rec IN okc_k_articles_tl_rec_type,
1845: x_okc_k_articles_tl_rec OUT NOCOPY okc_k_articles_tl_rec_type) IS
1846:
1847: l_api_version CONSTANT NUMBER := 1;
1848: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';

Line 1845: x_okc_k_articles_tl_rec OUT NOCOPY okc_k_articles_tl_rec_type) IS

1841: x_return_status OUT NOCOPY VARCHAR2,
1842: x_msg_count OUT NOCOPY NUMBER,
1843: x_msg_data OUT NOCOPY VARCHAR2,
1844: p_okc_k_articles_tl_rec IN okc_k_articles_tl_rec_type,
1845: x_okc_k_articles_tl_rec OUT NOCOPY okc_k_articles_tl_rec_type) IS
1846:
1847: l_api_version CONSTANT NUMBER := 1;
1848: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1849: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1850: l_okc_k_articles_tl_rec okc_k_articles_tl_rec_type := p_okc_k_articles_tl_rec;

1846:
1847: l_api_version CONSTANT NUMBER := 1;
1848: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1849: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1850: l_okc_k_articles_tl_rec okc_k_articles_tl_rec_type := p_okc_k_articles_tl_rec;
1851: l_def_okc_k_articles_tl_rec okc_k_articles_tl_rec_type;
1852: CURSOR get_languages IS
1853: SELECT *
1854: FROM FND_LANGUAGES

Line 1851: l_def_okc_k_articles_tl_rec okc_k_articles_tl_rec_type;

1847: l_api_version CONSTANT NUMBER := 1;
1848: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1849: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1850: l_okc_k_articles_tl_rec okc_k_articles_tl_rec_type := p_okc_k_articles_tl_rec;
1851: l_def_okc_k_articles_tl_rec okc_k_articles_tl_rec_type;
1852: CURSOR get_languages IS
1853: SELECT *
1854: FROM FND_LANGUAGES
1855: WHERE INSTALLED_FLAG IN ('I', 'B');

Line 1857: -- Set_Attributes for:OKC_K_ARTICLES_TL --

1853: SELECT *
1854: FROM FND_LANGUAGES
1855: WHERE INSTALLED_FLAG IN ('I', 'B');
1856: ------------------------------------------
1857: -- Set_Attributes for:OKC_K_ARTICLES_TL --
1858: ------------------------------------------
1859: FUNCTION Set_Attributes (
1860: p_okc_k_articles_tl_rec IN okc_k_articles_tl_rec_type,
1861: x_okc_k_articles_tl_rec OUT NOCOPY okc_k_articles_tl_rec_type

Line 1860: p_okc_k_articles_tl_rec IN okc_k_articles_tl_rec_type,

1856: ------------------------------------------
1857: -- Set_Attributes for:OKC_K_ARTICLES_TL --
1858: ------------------------------------------
1859: FUNCTION Set_Attributes (
1860: p_okc_k_articles_tl_rec IN okc_k_articles_tl_rec_type,
1861: x_okc_k_articles_tl_rec OUT NOCOPY okc_k_articles_tl_rec_type
1862: ) RETURN VARCHAR2 IS
1863: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1864: BEGIN

Line 1861: x_okc_k_articles_tl_rec OUT NOCOPY okc_k_articles_tl_rec_type

1857: -- Set_Attributes for:OKC_K_ARTICLES_TL --
1858: ------------------------------------------
1859: FUNCTION Set_Attributes (
1860: p_okc_k_articles_tl_rec IN okc_k_articles_tl_rec_type,
1861: x_okc_k_articles_tl_rec OUT NOCOPY okc_k_articles_tl_rec_type
1862: ) RETURN VARCHAR2 IS
1863: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1864: BEGIN
1865:

Line 1866: x_okc_k_articles_tl_rec := p_okc_k_articles_tl_rec;

1862: ) RETURN VARCHAR2 IS
1863: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1864: BEGIN
1865:
1866: x_okc_k_articles_tl_rec := p_okc_k_articles_tl_rec;
1867: x_okc_k_articles_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
1868: x_okc_k_articles_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
1869: RETURN(l_return_status);
1870:

Line 1867: x_okc_k_articles_tl_rec.LANGUAGE := okc_util.get_userenv_lang;

1863: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1864: BEGIN
1865:
1866: x_okc_k_articles_tl_rec := p_okc_k_articles_tl_rec;
1867: x_okc_k_articles_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
1868: x_okc_k_articles_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
1869: RETURN(l_return_status);
1870:
1871: END Set_Attributes;

Line 1868: x_okc_k_articles_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;

1864: BEGIN
1865:
1866: x_okc_k_articles_tl_rec := p_okc_k_articles_tl_rec;
1867: x_okc_k_articles_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
1868: x_okc_k_articles_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
1869: RETURN(l_return_status);
1870:
1871: END Set_Attributes;
1872: BEGIN

Line 1890: p_okc_k_articles_tl_rec, -- IN

1886: RAISE OKC_API.G_EXCEPTION_ERROR;
1887: END IF;
1888: --- Setting item attributes
1889: l_return_status := Set_Attributes(
1890: p_okc_k_articles_tl_rec, -- IN
1891: l_okc_k_articles_tl_rec); -- OUT
1892: --- If any errors happen abort API
1893: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1894: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1891: l_okc_k_articles_tl_rec); -- OUT

1887: END IF;
1888: --- Setting item attributes
1889: l_return_status := Set_Attributes(
1890: p_okc_k_articles_tl_rec, -- IN
1891: l_okc_k_articles_tl_rec); -- OUT
1892: --- If any errors happen abort API
1893: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1894: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1895: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 1899: l_okc_k_articles_tl_rec.language := l_lang_rec.language_code;

1895: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1896: RAISE OKC_API.G_EXCEPTION_ERROR;
1897: END IF;
1898: FOR l_lang_rec IN get_languages LOOP
1899: l_okc_k_articles_tl_rec.language := l_lang_rec.language_code;
1900: INSERT INTO OKC_K_ARTICLES_TL(
1901: id,
1902: language,
1903: source_lang,

Line 1900: INSERT INTO OKC_K_ARTICLES_TL(

1896: RAISE OKC_API.G_EXCEPTION_ERROR;
1897: END IF;
1898: FOR l_lang_rec IN get_languages LOOP
1899: l_okc_k_articles_tl_rec.language := l_lang_rec.language_code;
1900: INSERT INTO OKC_K_ARTICLES_TL(
1901: id,
1902: language,
1903: source_lang,
1904: sfwt_flag,

Line 1917: l_okc_k_articles_tl_rec.id,

1913: last_update_date,
1914: last_update_login,
1915: sav_sav_release)
1916: VALUES (
1917: l_okc_k_articles_tl_rec.id,
1918: l_okc_k_articles_tl_rec.language,
1919: l_okc_k_articles_tl_rec.source_lang,
1920: l_okc_k_articles_tl_rec.sfwt_flag,
1921: l_okc_k_articles_tl_rec.object_version_number,

Line 1918: l_okc_k_articles_tl_rec.language,

1914: last_update_login,
1915: sav_sav_release)
1916: VALUES (
1917: l_okc_k_articles_tl_rec.id,
1918: l_okc_k_articles_tl_rec.language,
1919: l_okc_k_articles_tl_rec.source_lang,
1920: l_okc_k_articles_tl_rec.sfwt_flag,
1921: l_okc_k_articles_tl_rec.object_version_number,
1922: l_okc_k_articles_tl_rec.comments,

Line 1919: l_okc_k_articles_tl_rec.source_lang,

1915: sav_sav_release)
1916: VALUES (
1917: l_okc_k_articles_tl_rec.id,
1918: l_okc_k_articles_tl_rec.language,
1919: l_okc_k_articles_tl_rec.source_lang,
1920: l_okc_k_articles_tl_rec.sfwt_flag,
1921: l_okc_k_articles_tl_rec.object_version_number,
1922: l_okc_k_articles_tl_rec.comments,
1923: l_okc_k_articles_tl_rec.variation_description,

Line 1920: l_okc_k_articles_tl_rec.sfwt_flag,

1916: VALUES (
1917: l_okc_k_articles_tl_rec.id,
1918: l_okc_k_articles_tl_rec.language,
1919: l_okc_k_articles_tl_rec.source_lang,
1920: l_okc_k_articles_tl_rec.sfwt_flag,
1921: l_okc_k_articles_tl_rec.object_version_number,
1922: l_okc_k_articles_tl_rec.comments,
1923: l_okc_k_articles_tl_rec.variation_description,
1924: l_okc_k_articles_tl_rec.name,

Line 1921: l_okc_k_articles_tl_rec.object_version_number,

1917: l_okc_k_articles_tl_rec.id,
1918: l_okc_k_articles_tl_rec.language,
1919: l_okc_k_articles_tl_rec.source_lang,
1920: l_okc_k_articles_tl_rec.sfwt_flag,
1921: l_okc_k_articles_tl_rec.object_version_number,
1922: l_okc_k_articles_tl_rec.comments,
1923: l_okc_k_articles_tl_rec.variation_description,
1924: l_okc_k_articles_tl_rec.name,
1925: l_okc_k_articles_tl_rec.text,

Line 1922: l_okc_k_articles_tl_rec.comments,

1918: l_okc_k_articles_tl_rec.language,
1919: l_okc_k_articles_tl_rec.source_lang,
1920: l_okc_k_articles_tl_rec.sfwt_flag,
1921: l_okc_k_articles_tl_rec.object_version_number,
1922: l_okc_k_articles_tl_rec.comments,
1923: l_okc_k_articles_tl_rec.variation_description,
1924: l_okc_k_articles_tl_rec.name,
1925: l_okc_k_articles_tl_rec.text,
1926: l_okc_k_articles_tl_rec.created_by,

Line 1923: l_okc_k_articles_tl_rec.variation_description,

1919: l_okc_k_articles_tl_rec.source_lang,
1920: l_okc_k_articles_tl_rec.sfwt_flag,
1921: l_okc_k_articles_tl_rec.object_version_number,
1922: l_okc_k_articles_tl_rec.comments,
1923: l_okc_k_articles_tl_rec.variation_description,
1924: l_okc_k_articles_tl_rec.name,
1925: l_okc_k_articles_tl_rec.text,
1926: l_okc_k_articles_tl_rec.created_by,
1927: l_okc_k_articles_tl_rec.creation_date,

Line 1924: l_okc_k_articles_tl_rec.name,

1920: l_okc_k_articles_tl_rec.sfwt_flag,
1921: l_okc_k_articles_tl_rec.object_version_number,
1922: l_okc_k_articles_tl_rec.comments,
1923: l_okc_k_articles_tl_rec.variation_description,
1924: l_okc_k_articles_tl_rec.name,
1925: l_okc_k_articles_tl_rec.text,
1926: l_okc_k_articles_tl_rec.created_by,
1927: l_okc_k_articles_tl_rec.creation_date,
1928: l_okc_k_articles_tl_rec.last_updated_by,

Line 1925: l_okc_k_articles_tl_rec.text,

1921: l_okc_k_articles_tl_rec.object_version_number,
1922: l_okc_k_articles_tl_rec.comments,
1923: l_okc_k_articles_tl_rec.variation_description,
1924: l_okc_k_articles_tl_rec.name,
1925: l_okc_k_articles_tl_rec.text,
1926: l_okc_k_articles_tl_rec.created_by,
1927: l_okc_k_articles_tl_rec.creation_date,
1928: l_okc_k_articles_tl_rec.last_updated_by,
1929: l_okc_k_articles_tl_rec.last_update_date,

Line 1926: l_okc_k_articles_tl_rec.created_by,

1922: l_okc_k_articles_tl_rec.comments,
1923: l_okc_k_articles_tl_rec.variation_description,
1924: l_okc_k_articles_tl_rec.name,
1925: l_okc_k_articles_tl_rec.text,
1926: l_okc_k_articles_tl_rec.created_by,
1927: l_okc_k_articles_tl_rec.creation_date,
1928: l_okc_k_articles_tl_rec.last_updated_by,
1929: l_okc_k_articles_tl_rec.last_update_date,
1930: l_okc_k_articles_tl_rec.last_update_login,

Line 1927: l_okc_k_articles_tl_rec.creation_date,

1923: l_okc_k_articles_tl_rec.variation_description,
1924: l_okc_k_articles_tl_rec.name,
1925: l_okc_k_articles_tl_rec.text,
1926: l_okc_k_articles_tl_rec.created_by,
1927: l_okc_k_articles_tl_rec.creation_date,
1928: l_okc_k_articles_tl_rec.last_updated_by,
1929: l_okc_k_articles_tl_rec.last_update_date,
1930: l_okc_k_articles_tl_rec.last_update_login,
1931: l_okc_k_articles_tl_rec.sav_sav_release);

Line 1928: l_okc_k_articles_tl_rec.last_updated_by,

1924: l_okc_k_articles_tl_rec.name,
1925: l_okc_k_articles_tl_rec.text,
1926: l_okc_k_articles_tl_rec.created_by,
1927: l_okc_k_articles_tl_rec.creation_date,
1928: l_okc_k_articles_tl_rec.last_updated_by,
1929: l_okc_k_articles_tl_rec.last_update_date,
1930: l_okc_k_articles_tl_rec.last_update_login,
1931: l_okc_k_articles_tl_rec.sav_sav_release);
1932: END LOOP;

Line 1929: l_okc_k_articles_tl_rec.last_update_date,

1925: l_okc_k_articles_tl_rec.text,
1926: l_okc_k_articles_tl_rec.created_by,
1927: l_okc_k_articles_tl_rec.creation_date,
1928: l_okc_k_articles_tl_rec.last_updated_by,
1929: l_okc_k_articles_tl_rec.last_update_date,
1930: l_okc_k_articles_tl_rec.last_update_login,
1931: l_okc_k_articles_tl_rec.sav_sav_release);
1932: END LOOP;
1933: -- Set OUT values

Line 1930: l_okc_k_articles_tl_rec.last_update_login,

1926: l_okc_k_articles_tl_rec.created_by,
1927: l_okc_k_articles_tl_rec.creation_date,
1928: l_okc_k_articles_tl_rec.last_updated_by,
1929: l_okc_k_articles_tl_rec.last_update_date,
1930: l_okc_k_articles_tl_rec.last_update_login,
1931: l_okc_k_articles_tl_rec.sav_sav_release);
1932: END LOOP;
1933: -- Set OUT values
1934: x_okc_k_articles_tl_rec := l_okc_k_articles_tl_rec;

Line 1931: l_okc_k_articles_tl_rec.sav_sav_release);

1927: l_okc_k_articles_tl_rec.creation_date,
1928: l_okc_k_articles_tl_rec.last_updated_by,
1929: l_okc_k_articles_tl_rec.last_update_date,
1930: l_okc_k_articles_tl_rec.last_update_login,
1931: l_okc_k_articles_tl_rec.sav_sav_release);
1932: END LOOP;
1933: -- Set OUT values
1934: x_okc_k_articles_tl_rec := l_okc_k_articles_tl_rec;
1935: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1934: x_okc_k_articles_tl_rec := l_okc_k_articles_tl_rec;

1930: l_okc_k_articles_tl_rec.last_update_login,
1931: l_okc_k_articles_tl_rec.sav_sav_release);
1932: END LOOP;
1933: -- Set OUT values
1934: x_okc_k_articles_tl_rec := l_okc_k_articles_tl_rec;
1935: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1936:
1937: IF (l_debug = 'Y') THEN
1938: okc_debug.log('5400: Leaving insert_row', 2);

Line 2012: l_okc_k_articles_tl_rec okc_k_articles_tl_rec_type;

2008: l_catv_rec catv_rec_type;
2009: l_def_catv_rec catv_rec_type;
2010: l_cat_rec cat_rec_type;
2011: lx_cat_rec cat_rec_type;
2012: l_okc_k_articles_tl_rec okc_k_articles_tl_rec_type;
2013: lx_okc_k_articles_tl_rec okc_k_articles_tl_rec_type;
2014: -------------------------------
2015: -- FUNCTION fill_who_columns --
2016: -------------------------------

Line 2013: lx_okc_k_articles_tl_rec okc_k_articles_tl_rec_type;

2009: l_def_catv_rec catv_rec_type;
2010: l_cat_rec cat_rec_type;
2011: lx_cat_rec cat_rec_type;
2012: l_okc_k_articles_tl_rec okc_k_articles_tl_rec_type;
2013: lx_okc_k_articles_tl_rec okc_k_articles_tl_rec_type;
2014: -------------------------------
2015: -- FUNCTION fill_who_columns --
2016: -------------------------------
2017: FUNCTION fill_who_columns (

Line 2114: migrate(l_def_catv_rec, l_okc_k_articles_tl_rec);

2110: --------------------------------------
2111: -- Move VIEW record to "Child" records
2112: --------------------------------------
2113: migrate(l_def_catv_rec, l_cat_rec);
2114: migrate(l_def_catv_rec, l_okc_k_articles_tl_rec);
2115: --------------------------------------------
2116: -- Call the INSERT_ROW for each child record
2117: --------------------------------------------
2118: insert_row(

Line 2137: l_okc_k_articles_tl_rec,

2133: p_init_msg_list,
2134: x_return_status,
2135: x_msg_count,
2136: x_msg_data,
2137: l_okc_k_articles_tl_rec,
2138: lx_okc_k_articles_tl_rec
2139: );
2140: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2141: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2138: lx_okc_k_articles_tl_rec

2134: x_return_status,
2135: x_msg_count,
2136: x_msg_data,
2137: l_okc_k_articles_tl_rec,
2138: lx_okc_k_articles_tl_rec
2139: );
2140: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2141: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2142: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2145: migrate(lx_okc_k_articles_tl_rec, l_def_catv_rec);

2141: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2142: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2143: RAISE OKC_API.G_EXCEPTION_ERROR;
2144: END IF;
2145: migrate(lx_okc_k_articles_tl_rec, l_def_catv_rec);
2146: -- Set OUT values
2147: x_catv_rec := l_def_catv_rec;
2148: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2149:

Line 2453: -- lock_row for:OKC_K_ARTICLES_TL --

2449: );
2450:
2451: END lock_row;
2452: ------------------------------------
2453: -- lock_row for:OKC_K_ARTICLES_TL --
2454: ------------------------------------
2455: PROCEDURE lock_row(
2456: p_init_msg_list IN VARCHAR2 ,
2457: x_return_status OUT NOCOPY VARCHAR2,

Line 2460: p_okc_k_articles_tl_rec IN okc_k_articles_tl_rec_type) IS

2456: p_init_msg_list IN VARCHAR2 ,
2457: x_return_status OUT NOCOPY VARCHAR2,
2458: x_msg_count OUT NOCOPY NUMBER,
2459: x_msg_data OUT NOCOPY VARCHAR2,
2460: p_okc_k_articles_tl_rec IN okc_k_articles_tl_rec_type) IS
2461:
2462: E_Resource_Busy EXCEPTION;
2463: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2464: CURSOR lock_csr (p_okc_k_articles_tl_rec IN okc_k_articles_tl_rec_type) IS

Line 2464: CURSOR lock_csr (p_okc_k_articles_tl_rec IN okc_k_articles_tl_rec_type) IS

2460: p_okc_k_articles_tl_rec IN okc_k_articles_tl_rec_type) IS
2461:
2462: E_Resource_Busy EXCEPTION;
2463: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2464: CURSOR lock_csr (p_okc_k_articles_tl_rec IN okc_k_articles_tl_rec_type) IS
2465: SELECT *
2466: FROM OKC_K_ARTICLES_TL
2467: WHERE ID = p_okc_k_articles_tl_rec.id
2468: FOR UPDATE NOWAIT;

Line 2466: FROM OKC_K_ARTICLES_TL

2462: E_Resource_Busy EXCEPTION;
2463: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2464: CURSOR lock_csr (p_okc_k_articles_tl_rec IN okc_k_articles_tl_rec_type) IS
2465: SELECT *
2466: FROM OKC_K_ARTICLES_TL
2467: WHERE ID = p_okc_k_articles_tl_rec.id
2468: FOR UPDATE NOWAIT;
2469:
2470: l_api_version CONSTANT NUMBER := 1;

Line 2467: WHERE ID = p_okc_k_articles_tl_rec.id

2463: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2464: CURSOR lock_csr (p_okc_k_articles_tl_rec IN okc_k_articles_tl_rec_type) IS
2465: SELECT *
2466: FROM OKC_K_ARTICLES_TL
2467: WHERE ID = p_okc_k_articles_tl_rec.id
2468: FOR UPDATE NOWAIT;
2469:
2470: l_api_version CONSTANT NUMBER := 1;
2471: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';

Line 2494: OPEN lock_csr(p_okc_k_articles_tl_rec);

2490: RAISE OKC_API.G_EXCEPTION_ERROR;
2491: END IF;
2492: BEGIN
2493:
2494: OPEN lock_csr(p_okc_k_articles_tl_rec);
2495: FETCH lock_csr INTO l_lock_var;
2496: l_row_notfound := lock_csr%NOTFOUND;
2497: CLOSE lock_csr;
2498:

Line 2596: l_okc_k_articles_tl_rec okc_k_articles_tl_rec_type;

2592: l_api_version CONSTANT NUMBER := 1;
2593: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
2594: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2595: l_cat_rec cat_rec_type;
2596: l_okc_k_articles_tl_rec okc_k_articles_tl_rec_type;
2597: BEGIN
2598:
2599: IF (l_debug = 'Y') THEN
2600: okc_debug.Set_Indentation('OKC_CAT_PVT');

Line 2620: migrate(p_catv_rec, l_okc_k_articles_tl_rec);

2616: --------------------------------------
2617: -- Move VIEW record to "Child" records
2618: --------------------------------------
2619: migrate(p_catv_rec, l_cat_rec);
2620: migrate(p_catv_rec, l_okc_k_articles_tl_rec);
2621: --------------------------------------------
2622: -- Call the LOCK_ROW for each child record
2623: --------------------------------------------
2624: lock_row(

Line 2641: l_okc_k_articles_tl_rec

2637: p_init_msg_list,
2638: x_return_status,
2639: x_msg_count,
2640: x_msg_data,
2641: l_okc_k_articles_tl_rec
2642: );
2643: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2644: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2645: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 3117: -- update_row for:OKC_K_ARTICLES_TL --

3113: );
3114:
3115: END update_row;
3116: --------------------------------------
3117: -- update_row for:OKC_K_ARTICLES_TL --
3118: --------------------------------------
3119: PROCEDURE update_row(
3120: p_init_msg_list IN VARCHAR2 ,
3121: x_return_status OUT NOCOPY VARCHAR2,

Line 3124: p_okc_k_articles_tl_rec IN okc_k_articles_tl_rec_type,

3120: p_init_msg_list IN VARCHAR2 ,
3121: x_return_status OUT NOCOPY VARCHAR2,
3122: x_msg_count OUT NOCOPY NUMBER,
3123: x_msg_data OUT NOCOPY VARCHAR2,
3124: p_okc_k_articles_tl_rec IN okc_k_articles_tl_rec_type,
3125: x_okc_k_articles_tl_rec OUT NOCOPY okc_k_articles_tl_rec_type) IS
3126:
3127: l_api_version CONSTANT NUMBER := 1;
3128: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';

Line 3125: x_okc_k_articles_tl_rec OUT NOCOPY okc_k_articles_tl_rec_type) IS

3121: x_return_status OUT NOCOPY VARCHAR2,
3122: x_msg_count OUT NOCOPY NUMBER,
3123: x_msg_data OUT NOCOPY VARCHAR2,
3124: p_okc_k_articles_tl_rec IN okc_k_articles_tl_rec_type,
3125: x_okc_k_articles_tl_rec OUT NOCOPY okc_k_articles_tl_rec_type) IS
3126:
3127: l_api_version CONSTANT NUMBER := 1;
3128: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
3129: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 3130: l_okc_k_articles_tl_rec okc_k_articles_tl_rec_type := p_okc_k_articles_tl_rec;

3126:
3127: l_api_version CONSTANT NUMBER := 1;
3128: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
3129: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3130: l_okc_k_articles_tl_rec okc_k_articles_tl_rec_type := p_okc_k_articles_tl_rec;
3131: l_def_okc_k_articles_tl_rec okc_k_articles_tl_rec_type;
3132: l_row_notfound BOOLEAN := TRUE;
3133: ----------------------------------
3134: -- FUNCTION populate_new_record --

Line 3131: l_def_okc_k_articles_tl_rec okc_k_articles_tl_rec_type;

3127: l_api_version CONSTANT NUMBER := 1;
3128: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
3129: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3130: l_okc_k_articles_tl_rec okc_k_articles_tl_rec_type := p_okc_k_articles_tl_rec;
3131: l_def_okc_k_articles_tl_rec okc_k_articles_tl_rec_type;
3132: l_row_notfound BOOLEAN := TRUE;
3133: ----------------------------------
3134: -- FUNCTION populate_new_record --
3135: ----------------------------------

Line 3137: p_okc_k_articles_tl_rec IN okc_k_articles_tl_rec_type,

3133: ----------------------------------
3134: -- FUNCTION populate_new_record --
3135: ----------------------------------
3136: FUNCTION populate_new_record (
3137: p_okc_k_articles_tl_rec IN okc_k_articles_tl_rec_type,
3138: x_okc_k_articles_tl_rec OUT NOCOPY okc_k_articles_tl_rec_type
3139: ) RETURN VARCHAR2 IS
3140: l_okc_k_articles_tl_rec okc_k_articles_tl_rec_type;
3141: l_row_notfound BOOLEAN := TRUE;

Line 3138: x_okc_k_articles_tl_rec OUT NOCOPY okc_k_articles_tl_rec_type

3134: -- FUNCTION populate_new_record --
3135: ----------------------------------
3136: FUNCTION populate_new_record (
3137: p_okc_k_articles_tl_rec IN okc_k_articles_tl_rec_type,
3138: x_okc_k_articles_tl_rec OUT NOCOPY okc_k_articles_tl_rec_type
3139: ) RETURN VARCHAR2 IS
3140: l_okc_k_articles_tl_rec okc_k_articles_tl_rec_type;
3141: l_row_notfound BOOLEAN := TRUE;
3142: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 3140: l_okc_k_articles_tl_rec okc_k_articles_tl_rec_type;

3136: FUNCTION populate_new_record (
3137: p_okc_k_articles_tl_rec IN okc_k_articles_tl_rec_type,
3138: x_okc_k_articles_tl_rec OUT NOCOPY okc_k_articles_tl_rec_type
3139: ) RETURN VARCHAR2 IS
3140: l_okc_k_articles_tl_rec okc_k_articles_tl_rec_type;
3141: l_row_notfound BOOLEAN := TRUE;
3142: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3143: BEGIN
3144:

Line 3150: x_okc_k_articles_tl_rec := p_okc_k_articles_tl_rec;

3146: okc_debug.Set_Indentation('OKC_CAT_PVT');
3147: okc_debug.log('10500: Entered populate_new_record', 2);
3148: END IF;
3149:
3150: x_okc_k_articles_tl_rec := p_okc_k_articles_tl_rec;
3151: -- Get current database values
3152: l_okc_k_articles_tl_rec := get_rec(p_okc_k_articles_tl_rec, l_row_notfound);
3153: IF (l_row_notfound) THEN
3154: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

Line 3152: l_okc_k_articles_tl_rec := get_rec(p_okc_k_articles_tl_rec, l_row_notfound);

3148: END IF;
3149:
3150: x_okc_k_articles_tl_rec := p_okc_k_articles_tl_rec;
3151: -- Get current database values
3152: l_okc_k_articles_tl_rec := get_rec(p_okc_k_articles_tl_rec, l_row_notfound);
3153: IF (l_row_notfound) THEN
3154: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
3155: END IF;
3156: IF (x_okc_k_articles_tl_rec.id = OKC_API.G_MISS_NUM)

Line 3156: IF (x_okc_k_articles_tl_rec.id = OKC_API.G_MISS_NUM)

3152: l_okc_k_articles_tl_rec := get_rec(p_okc_k_articles_tl_rec, l_row_notfound);
3153: IF (l_row_notfound) THEN
3154: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
3155: END IF;
3156: IF (x_okc_k_articles_tl_rec.id = OKC_API.G_MISS_NUM)
3157: THEN
3158: x_okc_k_articles_tl_rec.id := l_okc_k_articles_tl_rec.id;
3159: END IF;
3160: IF (x_okc_k_articles_tl_rec.language = OKC_API.G_MISS_CHAR)

Line 3158: x_okc_k_articles_tl_rec.id := l_okc_k_articles_tl_rec.id;

3154: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
3155: END IF;
3156: IF (x_okc_k_articles_tl_rec.id = OKC_API.G_MISS_NUM)
3157: THEN
3158: x_okc_k_articles_tl_rec.id := l_okc_k_articles_tl_rec.id;
3159: END IF;
3160: IF (x_okc_k_articles_tl_rec.language = OKC_API.G_MISS_CHAR)
3161: THEN
3162: x_okc_k_articles_tl_rec.language := l_okc_k_articles_tl_rec.language;

Line 3160: IF (x_okc_k_articles_tl_rec.language = OKC_API.G_MISS_CHAR)

3156: IF (x_okc_k_articles_tl_rec.id = OKC_API.G_MISS_NUM)
3157: THEN
3158: x_okc_k_articles_tl_rec.id := l_okc_k_articles_tl_rec.id;
3159: END IF;
3160: IF (x_okc_k_articles_tl_rec.language = OKC_API.G_MISS_CHAR)
3161: THEN
3162: x_okc_k_articles_tl_rec.language := l_okc_k_articles_tl_rec.language;
3163: END IF;
3164: IF (x_okc_k_articles_tl_rec.source_lang = OKC_API.G_MISS_CHAR)

Line 3162: x_okc_k_articles_tl_rec.language := l_okc_k_articles_tl_rec.language;

3158: x_okc_k_articles_tl_rec.id := l_okc_k_articles_tl_rec.id;
3159: END IF;
3160: IF (x_okc_k_articles_tl_rec.language = OKC_API.G_MISS_CHAR)
3161: THEN
3162: x_okc_k_articles_tl_rec.language := l_okc_k_articles_tl_rec.language;
3163: END IF;
3164: IF (x_okc_k_articles_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
3165: THEN
3166: x_okc_k_articles_tl_rec.source_lang := l_okc_k_articles_tl_rec.source_lang;

Line 3164: IF (x_okc_k_articles_tl_rec.source_lang = OKC_API.G_MISS_CHAR)

3160: IF (x_okc_k_articles_tl_rec.language = OKC_API.G_MISS_CHAR)
3161: THEN
3162: x_okc_k_articles_tl_rec.language := l_okc_k_articles_tl_rec.language;
3163: END IF;
3164: IF (x_okc_k_articles_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
3165: THEN
3166: x_okc_k_articles_tl_rec.source_lang := l_okc_k_articles_tl_rec.source_lang;
3167: END IF;
3168: IF (x_okc_k_articles_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)

Line 3166: x_okc_k_articles_tl_rec.source_lang := l_okc_k_articles_tl_rec.source_lang;

3162: x_okc_k_articles_tl_rec.language := l_okc_k_articles_tl_rec.language;
3163: END IF;
3164: IF (x_okc_k_articles_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
3165: THEN
3166: x_okc_k_articles_tl_rec.source_lang := l_okc_k_articles_tl_rec.source_lang;
3167: END IF;
3168: IF (x_okc_k_articles_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
3169: THEN
3170: x_okc_k_articles_tl_rec.sfwt_flag := l_okc_k_articles_tl_rec.sfwt_flag;

Line 3168: IF (x_okc_k_articles_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)

3164: IF (x_okc_k_articles_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
3165: THEN
3166: x_okc_k_articles_tl_rec.source_lang := l_okc_k_articles_tl_rec.source_lang;
3167: END IF;
3168: IF (x_okc_k_articles_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
3169: THEN
3170: x_okc_k_articles_tl_rec.sfwt_flag := l_okc_k_articles_tl_rec.sfwt_flag;
3171: END IF;
3172: IF (x_okc_k_articles_tl_rec.object_version_number = OKC_API.G_MISS_NUM)

Line 3170: x_okc_k_articles_tl_rec.sfwt_flag := l_okc_k_articles_tl_rec.sfwt_flag;

3166: x_okc_k_articles_tl_rec.source_lang := l_okc_k_articles_tl_rec.source_lang;
3167: END IF;
3168: IF (x_okc_k_articles_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
3169: THEN
3170: x_okc_k_articles_tl_rec.sfwt_flag := l_okc_k_articles_tl_rec.sfwt_flag;
3171: END IF;
3172: IF (x_okc_k_articles_tl_rec.object_version_number = OKC_API.G_MISS_NUM)
3173: THEN
3174: x_okc_k_articles_tl_rec.object_version_number := l_okc_k_articles_tl_rec.object_version_number;

Line 3172: IF (x_okc_k_articles_tl_rec.object_version_number = OKC_API.G_MISS_NUM)

3168: IF (x_okc_k_articles_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
3169: THEN
3170: x_okc_k_articles_tl_rec.sfwt_flag := l_okc_k_articles_tl_rec.sfwt_flag;
3171: END IF;
3172: IF (x_okc_k_articles_tl_rec.object_version_number = OKC_API.G_MISS_NUM)
3173: THEN
3174: x_okc_k_articles_tl_rec.object_version_number := l_okc_k_articles_tl_rec.object_version_number;
3175: END IF;
3176: IF (x_okc_k_articles_tl_rec.comments = OKC_API.G_MISS_CHAR)

Line 3174: x_okc_k_articles_tl_rec.object_version_number := l_okc_k_articles_tl_rec.object_version_number;

3170: x_okc_k_articles_tl_rec.sfwt_flag := l_okc_k_articles_tl_rec.sfwt_flag;
3171: END IF;
3172: IF (x_okc_k_articles_tl_rec.object_version_number = OKC_API.G_MISS_NUM)
3173: THEN
3174: x_okc_k_articles_tl_rec.object_version_number := l_okc_k_articles_tl_rec.object_version_number;
3175: END IF;
3176: IF (x_okc_k_articles_tl_rec.comments = OKC_API.G_MISS_CHAR)
3177: THEN
3178: x_okc_k_articles_tl_rec.comments := l_okc_k_articles_tl_rec.comments;

Line 3176: IF (x_okc_k_articles_tl_rec.comments = OKC_API.G_MISS_CHAR)

3172: IF (x_okc_k_articles_tl_rec.object_version_number = OKC_API.G_MISS_NUM)
3173: THEN
3174: x_okc_k_articles_tl_rec.object_version_number := l_okc_k_articles_tl_rec.object_version_number;
3175: END IF;
3176: IF (x_okc_k_articles_tl_rec.comments = OKC_API.G_MISS_CHAR)
3177: THEN
3178: x_okc_k_articles_tl_rec.comments := l_okc_k_articles_tl_rec.comments;
3179: END IF;
3180: IF (x_okc_k_articles_tl_rec.variation_description = OKC_API.G_MISS_CHAR)

Line 3178: x_okc_k_articles_tl_rec.comments := l_okc_k_articles_tl_rec.comments;

3174: x_okc_k_articles_tl_rec.object_version_number := l_okc_k_articles_tl_rec.object_version_number;
3175: END IF;
3176: IF (x_okc_k_articles_tl_rec.comments = OKC_API.G_MISS_CHAR)
3177: THEN
3178: x_okc_k_articles_tl_rec.comments := l_okc_k_articles_tl_rec.comments;
3179: END IF;
3180: IF (x_okc_k_articles_tl_rec.variation_description = OKC_API.G_MISS_CHAR)
3181: THEN
3182: x_okc_k_articles_tl_rec.variation_description := l_okc_k_articles_tl_rec.variation_description;

Line 3180: IF (x_okc_k_articles_tl_rec.variation_description = OKC_API.G_MISS_CHAR)

3176: IF (x_okc_k_articles_tl_rec.comments = OKC_API.G_MISS_CHAR)
3177: THEN
3178: x_okc_k_articles_tl_rec.comments := l_okc_k_articles_tl_rec.comments;
3179: END IF;
3180: IF (x_okc_k_articles_tl_rec.variation_description = OKC_API.G_MISS_CHAR)
3181: THEN
3182: x_okc_k_articles_tl_rec.variation_description := l_okc_k_articles_tl_rec.variation_description;
3183: END IF;
3184: IF (x_okc_k_articles_tl_rec.name = OKC_API.G_MISS_CHAR)

Line 3182: x_okc_k_articles_tl_rec.variation_description := l_okc_k_articles_tl_rec.variation_description;

3178: x_okc_k_articles_tl_rec.comments := l_okc_k_articles_tl_rec.comments;
3179: END IF;
3180: IF (x_okc_k_articles_tl_rec.variation_description = OKC_API.G_MISS_CHAR)
3181: THEN
3182: x_okc_k_articles_tl_rec.variation_description := l_okc_k_articles_tl_rec.variation_description;
3183: END IF;
3184: IF (x_okc_k_articles_tl_rec.name = OKC_API.G_MISS_CHAR)
3185: THEN
3186: x_okc_k_articles_tl_rec.name := l_okc_k_articles_tl_rec.name;

Line 3184: IF (x_okc_k_articles_tl_rec.name = OKC_API.G_MISS_CHAR)

3180: IF (x_okc_k_articles_tl_rec.variation_description = OKC_API.G_MISS_CHAR)
3181: THEN
3182: x_okc_k_articles_tl_rec.variation_description := l_okc_k_articles_tl_rec.variation_description;
3183: END IF;
3184: IF (x_okc_k_articles_tl_rec.name = OKC_API.G_MISS_CHAR)
3185: THEN
3186: x_okc_k_articles_tl_rec.name := l_okc_k_articles_tl_rec.name;
3187: END IF;
3188: -- Commented in favor of hand code

Line 3186: x_okc_k_articles_tl_rec.name := l_okc_k_articles_tl_rec.name;

3182: x_okc_k_articles_tl_rec.variation_description := l_okc_k_articles_tl_rec.variation_description;
3183: END IF;
3184: IF (x_okc_k_articles_tl_rec.name = OKC_API.G_MISS_CHAR)
3185: THEN
3186: x_okc_k_articles_tl_rec.name := l_okc_k_articles_tl_rec.name;
3187: END IF;
3188: -- Commented in favor of hand code
3189: -- IF (x_okc_k_articles_tl_rec.text = OKC_API.G_MISS_CHAR)
3190: --+Hand code start

Line 3189: -- IF (x_okc_k_articles_tl_rec.text = OKC_API.G_MISS_CHAR)

3185: THEN
3186: x_okc_k_articles_tl_rec.name := l_okc_k_articles_tl_rec.name;
3187: END IF;
3188: -- Commented in favor of hand code
3189: -- IF (x_okc_k_articles_tl_rec.text = OKC_API.G_MISS_CHAR)
3190: --+Hand code start
3191: IF (x_okc_k_articles_tl_rec.text is NULL)
3192: --+Hand code end
3193: THEN

Line 3191: IF (x_okc_k_articles_tl_rec.text is NULL)

3187: END IF;
3188: -- Commented in favor of hand code
3189: -- IF (x_okc_k_articles_tl_rec.text = OKC_API.G_MISS_CHAR)
3190: --+Hand code start
3191: IF (x_okc_k_articles_tl_rec.text is NULL)
3192: --+Hand code end
3193: THEN
3194: x_okc_k_articles_tl_rec.text := l_okc_k_articles_tl_rec.text;
3195: END IF;

Line 3194: x_okc_k_articles_tl_rec.text := l_okc_k_articles_tl_rec.text;

3190: --+Hand code start
3191: IF (x_okc_k_articles_tl_rec.text is NULL)
3192: --+Hand code end
3193: THEN
3194: x_okc_k_articles_tl_rec.text := l_okc_k_articles_tl_rec.text;
3195: END IF;
3196: IF (x_okc_k_articles_tl_rec.created_by = OKC_API.G_MISS_NUM)
3197: THEN
3198: x_okc_k_articles_tl_rec.created_by := l_okc_k_articles_tl_rec.created_by;

Line 3196: IF (x_okc_k_articles_tl_rec.created_by = OKC_API.G_MISS_NUM)

3192: --+Hand code end
3193: THEN
3194: x_okc_k_articles_tl_rec.text := l_okc_k_articles_tl_rec.text;
3195: END IF;
3196: IF (x_okc_k_articles_tl_rec.created_by = OKC_API.G_MISS_NUM)
3197: THEN
3198: x_okc_k_articles_tl_rec.created_by := l_okc_k_articles_tl_rec.created_by;
3199: END IF;
3200: IF (x_okc_k_articles_tl_rec.creation_date = OKC_API.G_MISS_DATE)

Line 3198: x_okc_k_articles_tl_rec.created_by := l_okc_k_articles_tl_rec.created_by;

3194: x_okc_k_articles_tl_rec.text := l_okc_k_articles_tl_rec.text;
3195: END IF;
3196: IF (x_okc_k_articles_tl_rec.created_by = OKC_API.G_MISS_NUM)
3197: THEN
3198: x_okc_k_articles_tl_rec.created_by := l_okc_k_articles_tl_rec.created_by;
3199: END IF;
3200: IF (x_okc_k_articles_tl_rec.creation_date = OKC_API.G_MISS_DATE)
3201: THEN
3202: x_okc_k_articles_tl_rec.creation_date := l_okc_k_articles_tl_rec.creation_date;

Line 3200: IF (x_okc_k_articles_tl_rec.creation_date = OKC_API.G_MISS_DATE)

3196: IF (x_okc_k_articles_tl_rec.created_by = OKC_API.G_MISS_NUM)
3197: THEN
3198: x_okc_k_articles_tl_rec.created_by := l_okc_k_articles_tl_rec.created_by;
3199: END IF;
3200: IF (x_okc_k_articles_tl_rec.creation_date = OKC_API.G_MISS_DATE)
3201: THEN
3202: x_okc_k_articles_tl_rec.creation_date := l_okc_k_articles_tl_rec.creation_date;
3203: END IF;
3204: IF (x_okc_k_articles_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)

Line 3202: x_okc_k_articles_tl_rec.creation_date := l_okc_k_articles_tl_rec.creation_date;

3198: x_okc_k_articles_tl_rec.created_by := l_okc_k_articles_tl_rec.created_by;
3199: END IF;
3200: IF (x_okc_k_articles_tl_rec.creation_date = OKC_API.G_MISS_DATE)
3201: THEN
3202: x_okc_k_articles_tl_rec.creation_date := l_okc_k_articles_tl_rec.creation_date;
3203: END IF;
3204: IF (x_okc_k_articles_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
3205: THEN
3206: x_okc_k_articles_tl_rec.last_updated_by := l_okc_k_articles_tl_rec.last_updated_by;

Line 3204: IF (x_okc_k_articles_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)

3200: IF (x_okc_k_articles_tl_rec.creation_date = OKC_API.G_MISS_DATE)
3201: THEN
3202: x_okc_k_articles_tl_rec.creation_date := l_okc_k_articles_tl_rec.creation_date;
3203: END IF;
3204: IF (x_okc_k_articles_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
3205: THEN
3206: x_okc_k_articles_tl_rec.last_updated_by := l_okc_k_articles_tl_rec.last_updated_by;
3207: END IF;
3208: IF (x_okc_k_articles_tl_rec.last_update_date = OKC_API.G_MISS_DATE)

Line 3206: x_okc_k_articles_tl_rec.last_updated_by := l_okc_k_articles_tl_rec.last_updated_by;

3202: x_okc_k_articles_tl_rec.creation_date := l_okc_k_articles_tl_rec.creation_date;
3203: END IF;
3204: IF (x_okc_k_articles_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
3205: THEN
3206: x_okc_k_articles_tl_rec.last_updated_by := l_okc_k_articles_tl_rec.last_updated_by;
3207: END IF;
3208: IF (x_okc_k_articles_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
3209: THEN
3210: x_okc_k_articles_tl_rec.last_update_date := l_okc_k_articles_tl_rec.last_update_date;

Line 3208: IF (x_okc_k_articles_tl_rec.last_update_date = OKC_API.G_MISS_DATE)

3204: IF (x_okc_k_articles_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
3205: THEN
3206: x_okc_k_articles_tl_rec.last_updated_by := l_okc_k_articles_tl_rec.last_updated_by;
3207: END IF;
3208: IF (x_okc_k_articles_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
3209: THEN
3210: x_okc_k_articles_tl_rec.last_update_date := l_okc_k_articles_tl_rec.last_update_date;
3211: END IF;
3212: IF (x_okc_k_articles_tl_rec.last_update_login = OKC_API.G_MISS_NUM)

Line 3210: x_okc_k_articles_tl_rec.last_update_date := l_okc_k_articles_tl_rec.last_update_date;

3206: x_okc_k_articles_tl_rec.last_updated_by := l_okc_k_articles_tl_rec.last_updated_by;
3207: END IF;
3208: IF (x_okc_k_articles_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
3209: THEN
3210: x_okc_k_articles_tl_rec.last_update_date := l_okc_k_articles_tl_rec.last_update_date;
3211: END IF;
3212: IF (x_okc_k_articles_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
3213: THEN
3214: x_okc_k_articles_tl_rec.last_update_login := l_okc_k_articles_tl_rec.last_update_login;

Line 3212: IF (x_okc_k_articles_tl_rec.last_update_login = OKC_API.G_MISS_NUM)

3208: IF (x_okc_k_articles_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
3209: THEN
3210: x_okc_k_articles_tl_rec.last_update_date := l_okc_k_articles_tl_rec.last_update_date;
3211: END IF;
3212: IF (x_okc_k_articles_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
3213: THEN
3214: x_okc_k_articles_tl_rec.last_update_login := l_okc_k_articles_tl_rec.last_update_login;
3215: END IF;
3216: IF (x_okc_k_articles_tl_rec.sav_sav_release = OKC_API.G_MISS_CHAR)

Line 3214: x_okc_k_articles_tl_rec.last_update_login := l_okc_k_articles_tl_rec.last_update_login;

3210: x_okc_k_articles_tl_rec.last_update_date := l_okc_k_articles_tl_rec.last_update_date;
3211: END IF;
3212: IF (x_okc_k_articles_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
3213: THEN
3214: x_okc_k_articles_tl_rec.last_update_login := l_okc_k_articles_tl_rec.last_update_login;
3215: END IF;
3216: IF (x_okc_k_articles_tl_rec.sav_sav_release = OKC_API.G_MISS_CHAR)
3217: THEN
3218: x_okc_k_articles_tl_rec.sav_sav_release := l_okc_k_articles_tl_rec.sav_sav_release;

Line 3216: IF (x_okc_k_articles_tl_rec.sav_sav_release = OKC_API.G_MISS_CHAR)

3212: IF (x_okc_k_articles_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
3213: THEN
3214: x_okc_k_articles_tl_rec.last_update_login := l_okc_k_articles_tl_rec.last_update_login;
3215: END IF;
3216: IF (x_okc_k_articles_tl_rec.sav_sav_release = OKC_API.G_MISS_CHAR)
3217: THEN
3218: x_okc_k_articles_tl_rec.sav_sav_release := l_okc_k_articles_tl_rec.sav_sav_release;
3219: END IF;
3220:

Line 3218: x_okc_k_articles_tl_rec.sav_sav_release := l_okc_k_articles_tl_rec.sav_sav_release;

3214: x_okc_k_articles_tl_rec.last_update_login := l_okc_k_articles_tl_rec.last_update_login;
3215: END IF;
3216: IF (x_okc_k_articles_tl_rec.sav_sav_release = OKC_API.G_MISS_CHAR)
3217: THEN
3218: x_okc_k_articles_tl_rec.sav_sav_release := l_okc_k_articles_tl_rec.sav_sav_release;
3219: END IF;
3220:
3221: IF (l_debug = 'Y') THEN
3222: okc_debug.log('10650: Leaving update_row', 2);

Line 3230: -- Set_Attributes for:OKC_K_ARTICLES_TL --

3226: RETURN(l_return_status);
3227:
3228: END populate_new_record;
3229: ------------------------------------------
3230: -- Set_Attributes for:OKC_K_ARTICLES_TL --
3231: ------------------------------------------
3232: FUNCTION Set_Attributes (
3233: p_okc_k_articles_tl_rec IN okc_k_articles_tl_rec_type,
3234: x_okc_k_articles_tl_rec OUT NOCOPY okc_k_articles_tl_rec_type

Line 3233: p_okc_k_articles_tl_rec IN okc_k_articles_tl_rec_type,

3229: ------------------------------------------
3230: -- Set_Attributes for:OKC_K_ARTICLES_TL --
3231: ------------------------------------------
3232: FUNCTION Set_Attributes (
3233: p_okc_k_articles_tl_rec IN okc_k_articles_tl_rec_type,
3234: x_okc_k_articles_tl_rec OUT NOCOPY okc_k_articles_tl_rec_type
3235: ) RETURN VARCHAR2 IS
3236: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3237: BEGIN

Line 3234: x_okc_k_articles_tl_rec OUT NOCOPY okc_k_articles_tl_rec_type

3230: -- Set_Attributes for:OKC_K_ARTICLES_TL --
3231: ------------------------------------------
3232: FUNCTION Set_Attributes (
3233: p_okc_k_articles_tl_rec IN okc_k_articles_tl_rec_type,
3234: x_okc_k_articles_tl_rec OUT NOCOPY okc_k_articles_tl_rec_type
3235: ) RETURN VARCHAR2 IS
3236: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3237: BEGIN
3238:

Line 3239: x_okc_k_articles_tl_rec := p_okc_k_articles_tl_rec;

3235: ) RETURN VARCHAR2 IS
3236: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3237: BEGIN
3238:
3239: x_okc_k_articles_tl_rec := p_okc_k_articles_tl_rec;
3240: x_okc_k_articles_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
3241: x_okc_k_articles_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
3242: RETURN(l_return_status);
3243:

Line 3240: x_okc_k_articles_tl_rec.LANGUAGE := okc_util.get_userenv_lang;

3236: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3237: BEGIN
3238:
3239: x_okc_k_articles_tl_rec := p_okc_k_articles_tl_rec;
3240: x_okc_k_articles_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
3241: x_okc_k_articles_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
3242: RETURN(l_return_status);
3243:
3244: END Set_Attributes;

Line 3241: x_okc_k_articles_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;

3237: BEGIN
3238:
3239: x_okc_k_articles_tl_rec := p_okc_k_articles_tl_rec;
3240: x_okc_k_articles_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
3241: x_okc_k_articles_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
3242: RETURN(l_return_status);
3243:
3244: END Set_Attributes;
3245: BEGIN

Line 3263: p_okc_k_articles_tl_rec, -- IN

3259: RAISE OKC_API.G_EXCEPTION_ERROR;
3260: END IF;
3261: --- Setting item attributes
3262: l_return_status := Set_Attributes(
3263: p_okc_k_articles_tl_rec, -- IN
3264: l_okc_k_articles_tl_rec); -- OUT
3265: --- If any errors happen abort API
3266: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3267: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3264: l_okc_k_articles_tl_rec); -- OUT

3260: END IF;
3261: --- Setting item attributes
3262: l_return_status := Set_Attributes(
3263: p_okc_k_articles_tl_rec, -- IN
3264: l_okc_k_articles_tl_rec); -- OUT
3265: --- If any errors happen abort API
3266: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3267: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3268: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 3271: l_return_status := populate_new_record(l_okc_k_articles_tl_rec, l_def_okc_k_articles_tl_rec);

3267: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3268: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3269: RAISE OKC_API.G_EXCEPTION_ERROR;
3270: END IF;
3271: l_return_status := populate_new_record(l_okc_k_articles_tl_rec, l_def_okc_k_articles_tl_rec);
3272: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3273: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3274: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3275: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 3277: UPDATE OKC_K_ARTICLES_TL

3273: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3274: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3275: RAISE OKC_API.G_EXCEPTION_ERROR;
3276: END IF;
3277: UPDATE OKC_K_ARTICLES_TL
3278: SET OBJECT_VERSION_NUMBER = l_def_okc_k_articles_tl_rec.object_version_number,
3279: COMMENTS = l_def_okc_k_articles_tl_rec.comments,
3280: VARIATION_DESCRIPTION = l_def_okc_k_articles_tl_rec.variation_description,
3281: NAME = l_def_okc_k_articles_tl_rec.name,

Line 3278: SET OBJECT_VERSION_NUMBER = l_def_okc_k_articles_tl_rec.object_version_number,

3274: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3275: RAISE OKC_API.G_EXCEPTION_ERROR;
3276: END IF;
3277: UPDATE OKC_K_ARTICLES_TL
3278: SET OBJECT_VERSION_NUMBER = l_def_okc_k_articles_tl_rec.object_version_number,
3279: COMMENTS = l_def_okc_k_articles_tl_rec.comments,
3280: VARIATION_DESCRIPTION = l_def_okc_k_articles_tl_rec.variation_description,
3281: NAME = l_def_okc_k_articles_tl_rec.name,
3282: TEXT = l_def_okc_k_articles_tl_rec.text,

Line 3279: COMMENTS = l_def_okc_k_articles_tl_rec.comments,

3275: RAISE OKC_API.G_EXCEPTION_ERROR;
3276: END IF;
3277: UPDATE OKC_K_ARTICLES_TL
3278: SET OBJECT_VERSION_NUMBER = l_def_okc_k_articles_tl_rec.object_version_number,
3279: COMMENTS = l_def_okc_k_articles_tl_rec.comments,
3280: VARIATION_DESCRIPTION = l_def_okc_k_articles_tl_rec.variation_description,
3281: NAME = l_def_okc_k_articles_tl_rec.name,
3282: TEXT = l_def_okc_k_articles_tl_rec.text,
3283: CREATED_BY = l_def_okc_k_articles_tl_rec.created_by,

Line 3280: VARIATION_DESCRIPTION = l_def_okc_k_articles_tl_rec.variation_description,

3276: END IF;
3277: UPDATE OKC_K_ARTICLES_TL
3278: SET OBJECT_VERSION_NUMBER = l_def_okc_k_articles_tl_rec.object_version_number,
3279: COMMENTS = l_def_okc_k_articles_tl_rec.comments,
3280: VARIATION_DESCRIPTION = l_def_okc_k_articles_tl_rec.variation_description,
3281: NAME = l_def_okc_k_articles_tl_rec.name,
3282: TEXT = l_def_okc_k_articles_tl_rec.text,
3283: CREATED_BY = l_def_okc_k_articles_tl_rec.created_by,
3284: CREATION_DATE = l_def_okc_k_articles_tl_rec.creation_date,

Line 3281: NAME = l_def_okc_k_articles_tl_rec.name,

3277: UPDATE OKC_K_ARTICLES_TL
3278: SET OBJECT_VERSION_NUMBER = l_def_okc_k_articles_tl_rec.object_version_number,
3279: COMMENTS = l_def_okc_k_articles_tl_rec.comments,
3280: VARIATION_DESCRIPTION = l_def_okc_k_articles_tl_rec.variation_description,
3281: NAME = l_def_okc_k_articles_tl_rec.name,
3282: TEXT = l_def_okc_k_articles_tl_rec.text,
3283: CREATED_BY = l_def_okc_k_articles_tl_rec.created_by,
3284: CREATION_DATE = l_def_okc_k_articles_tl_rec.creation_date,
3285: LAST_UPDATED_BY = l_def_okc_k_articles_tl_rec.last_updated_by,

Line 3282: TEXT = l_def_okc_k_articles_tl_rec.text,

3278: SET OBJECT_VERSION_NUMBER = l_def_okc_k_articles_tl_rec.object_version_number,
3279: COMMENTS = l_def_okc_k_articles_tl_rec.comments,
3280: VARIATION_DESCRIPTION = l_def_okc_k_articles_tl_rec.variation_description,
3281: NAME = l_def_okc_k_articles_tl_rec.name,
3282: TEXT = l_def_okc_k_articles_tl_rec.text,
3283: CREATED_BY = l_def_okc_k_articles_tl_rec.created_by,
3284: CREATION_DATE = l_def_okc_k_articles_tl_rec.creation_date,
3285: LAST_UPDATED_BY = l_def_okc_k_articles_tl_rec.last_updated_by,
3286: LAST_UPDATE_DATE = l_def_okc_k_articles_tl_rec.last_update_date,

Line 3283: CREATED_BY = l_def_okc_k_articles_tl_rec.created_by,

3279: COMMENTS = l_def_okc_k_articles_tl_rec.comments,
3280: VARIATION_DESCRIPTION = l_def_okc_k_articles_tl_rec.variation_description,
3281: NAME = l_def_okc_k_articles_tl_rec.name,
3282: TEXT = l_def_okc_k_articles_tl_rec.text,
3283: CREATED_BY = l_def_okc_k_articles_tl_rec.created_by,
3284: CREATION_DATE = l_def_okc_k_articles_tl_rec.creation_date,
3285: LAST_UPDATED_BY = l_def_okc_k_articles_tl_rec.last_updated_by,
3286: LAST_UPDATE_DATE = l_def_okc_k_articles_tl_rec.last_update_date,
3287: LAST_UPDATE_LOGIN = l_def_okc_k_articles_tl_rec.last_update_login,

Line 3284: CREATION_DATE = l_def_okc_k_articles_tl_rec.creation_date,

3280: VARIATION_DESCRIPTION = l_def_okc_k_articles_tl_rec.variation_description,
3281: NAME = l_def_okc_k_articles_tl_rec.name,
3282: TEXT = l_def_okc_k_articles_tl_rec.text,
3283: CREATED_BY = l_def_okc_k_articles_tl_rec.created_by,
3284: CREATION_DATE = l_def_okc_k_articles_tl_rec.creation_date,
3285: LAST_UPDATED_BY = l_def_okc_k_articles_tl_rec.last_updated_by,
3286: LAST_UPDATE_DATE = l_def_okc_k_articles_tl_rec.last_update_date,
3287: LAST_UPDATE_LOGIN = l_def_okc_k_articles_tl_rec.last_update_login,
3288: SAV_SAV_RELEASE = l_def_okc_k_articles_tl_rec.sav_sav_release

Line 3285: LAST_UPDATED_BY = l_def_okc_k_articles_tl_rec.last_updated_by,

3281: NAME = l_def_okc_k_articles_tl_rec.name,
3282: TEXT = l_def_okc_k_articles_tl_rec.text,
3283: CREATED_BY = l_def_okc_k_articles_tl_rec.created_by,
3284: CREATION_DATE = l_def_okc_k_articles_tl_rec.creation_date,
3285: LAST_UPDATED_BY = l_def_okc_k_articles_tl_rec.last_updated_by,
3286: LAST_UPDATE_DATE = l_def_okc_k_articles_tl_rec.last_update_date,
3287: LAST_UPDATE_LOGIN = l_def_okc_k_articles_tl_rec.last_update_login,
3288: SAV_SAV_RELEASE = l_def_okc_k_articles_tl_rec.sav_sav_release
3289: --+

Line 3286: LAST_UPDATE_DATE = l_def_okc_k_articles_tl_rec.last_update_date,

3282: TEXT = l_def_okc_k_articles_tl_rec.text,
3283: CREATED_BY = l_def_okc_k_articles_tl_rec.created_by,
3284: CREATION_DATE = l_def_okc_k_articles_tl_rec.creation_date,
3285: LAST_UPDATED_BY = l_def_okc_k_articles_tl_rec.last_updated_by,
3286: LAST_UPDATE_DATE = l_def_okc_k_articles_tl_rec.last_update_date,
3287: LAST_UPDATE_LOGIN = l_def_okc_k_articles_tl_rec.last_update_login,
3288: SAV_SAV_RELEASE = l_def_okc_k_articles_tl_rec.sav_sav_release
3289: --+
3290: ,SOURCE_LANG = l_def_okc_k_articles_tl_rec.SOURCE_LANG

Line 3287: LAST_UPDATE_LOGIN = l_def_okc_k_articles_tl_rec.last_update_login,

3283: CREATED_BY = l_def_okc_k_articles_tl_rec.created_by,
3284: CREATION_DATE = l_def_okc_k_articles_tl_rec.creation_date,
3285: LAST_UPDATED_BY = l_def_okc_k_articles_tl_rec.last_updated_by,
3286: LAST_UPDATE_DATE = l_def_okc_k_articles_tl_rec.last_update_date,
3287: LAST_UPDATE_LOGIN = l_def_okc_k_articles_tl_rec.last_update_login,
3288: SAV_SAV_RELEASE = l_def_okc_k_articles_tl_rec.sav_sav_release
3289: --+
3290: ,SOURCE_LANG = l_def_okc_k_articles_tl_rec.SOURCE_LANG
3291: --+

Line 3288: SAV_SAV_RELEASE = l_def_okc_k_articles_tl_rec.sav_sav_release

3284: CREATION_DATE = l_def_okc_k_articles_tl_rec.creation_date,
3285: LAST_UPDATED_BY = l_def_okc_k_articles_tl_rec.last_updated_by,
3286: LAST_UPDATE_DATE = l_def_okc_k_articles_tl_rec.last_update_date,
3287: LAST_UPDATE_LOGIN = l_def_okc_k_articles_tl_rec.last_update_login,
3288: SAV_SAV_RELEASE = l_def_okc_k_articles_tl_rec.sav_sav_release
3289: --+
3290: ,SOURCE_LANG = l_def_okc_k_articles_tl_rec.SOURCE_LANG
3291: --+
3292: WHERE ID = l_def_okc_k_articles_tl_rec.id

Line 3290: ,SOURCE_LANG = l_def_okc_k_articles_tl_rec.SOURCE_LANG

3286: LAST_UPDATE_DATE = l_def_okc_k_articles_tl_rec.last_update_date,
3287: LAST_UPDATE_LOGIN = l_def_okc_k_articles_tl_rec.last_update_login,
3288: SAV_SAV_RELEASE = l_def_okc_k_articles_tl_rec.sav_sav_release
3289: --+
3290: ,SOURCE_LANG = l_def_okc_k_articles_tl_rec.SOURCE_LANG
3291: --+
3292: WHERE ID = l_def_okc_k_articles_tl_rec.id
3293: --- AND SOURCE_LANG = USERENV('LANG');
3294: --+

Line 3292: WHERE ID = l_def_okc_k_articles_tl_rec.id

3288: SAV_SAV_RELEASE = l_def_okc_k_articles_tl_rec.sav_sav_release
3289: --+
3290: ,SOURCE_LANG = l_def_okc_k_articles_tl_rec.SOURCE_LANG
3291: --+
3292: WHERE ID = l_def_okc_k_articles_tl_rec.id
3293: --- AND SOURCE_LANG = USERENV('LANG');
3294: --+
3295: AND USERENV('LANG') in (SOURCE_LANG,LANGUAGE);
3296: --+

Line 3298: UPDATE OKC_K_ARTICLES_TL

3294: --+
3295: AND USERENV('LANG') in (SOURCE_LANG,LANGUAGE);
3296: --+
3297:
3298: UPDATE OKC_K_ARTICLES_TL
3299: SET SFWT_FLAG = 'Y'
3300: WHERE ID = l_def_okc_k_articles_tl_rec.id
3301: AND SOURCE_LANG <> USERENV('LANG');
3302:

Line 3300: WHERE ID = l_def_okc_k_articles_tl_rec.id

3296: --+
3297:
3298: UPDATE OKC_K_ARTICLES_TL
3299: SET SFWT_FLAG = 'Y'
3300: WHERE ID = l_def_okc_k_articles_tl_rec.id
3301: AND SOURCE_LANG <> USERENV('LANG');
3302:
3303: x_okc_k_articles_tl_rec := l_def_okc_k_articles_tl_rec;
3304: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 3303: x_okc_k_articles_tl_rec := l_def_okc_k_articles_tl_rec;

3299: SET SFWT_FLAG = 'Y'
3300: WHERE ID = l_def_okc_k_articles_tl_rec.id
3301: AND SOURCE_LANG <> USERENV('LANG');
3302:
3303: x_okc_k_articles_tl_rec := l_def_okc_k_articles_tl_rec;
3304: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3305:
3306: IF (l_debug = 'Y') THEN
3307: okc_debug.log('10750: Leaving update_row', 2);

Line 3379: l_okc_k_articles_tl_rec okc_k_articles_tl_rec_type;

3375: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
3376: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3377: l_catv_rec catv_rec_type := p_catv_rec;
3378: l_def_catv_rec catv_rec_type;
3379: l_okc_k_articles_tl_rec okc_k_articles_tl_rec_type;
3380: lx_okc_k_articles_tl_rec okc_k_articles_tl_rec_type;
3381: l_cat_rec cat_rec_type;
3382: lx_cat_rec cat_rec_type;
3383: -------------------------------

Line 3380: lx_okc_k_articles_tl_rec okc_k_articles_tl_rec_type;

3376: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3377: l_catv_rec catv_rec_type := p_catv_rec;
3378: l_def_catv_rec catv_rec_type;
3379: l_okc_k_articles_tl_rec okc_k_articles_tl_rec_type;
3380: lx_okc_k_articles_tl_rec okc_k_articles_tl_rec_type;
3381: l_cat_rec cat_rec_type;
3382: lx_cat_rec cat_rec_type;
3383: -------------------------------
3384: -- FUNCTION fill_who_columns --

Line 3651: migrate(l_def_catv_rec, l_okc_k_articles_tl_rec);

3647:
3648: --------------------------------------
3649: -- Move VIEW record to "Child" records
3650: --------------------------------------
3651: migrate(l_def_catv_rec, l_okc_k_articles_tl_rec);
3652: migrate(l_def_catv_rec, l_cat_rec);
3653: --------------------------------------------
3654: -- Call the UPDATE_ROW for each child record
3655: --------------------------------------------

Line 3661: l_okc_k_articles_tl_rec,

3657: p_init_msg_list,
3658: x_return_status,
3659: x_msg_count,
3660: x_msg_data,
3661: l_okc_k_articles_tl_rec,
3662: lx_okc_k_articles_tl_rec
3663: );
3664: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3665: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3662: lx_okc_k_articles_tl_rec

3658: x_return_status,
3659: x_msg_count,
3660: x_msg_data,
3661: l_okc_k_articles_tl_rec,
3662: lx_okc_k_articles_tl_rec
3663: );
3664: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3665: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3666: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 3669: migrate(lx_okc_k_articles_tl_rec, l_def_catv_rec);

3665: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3666: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3667: RAISE OKC_API.G_EXCEPTION_ERROR;
3668: END IF;
3669: migrate(lx_okc_k_articles_tl_rec, l_def_catv_rec);
3670: update_row(
3671: p_init_msg_list,
3672: x_return_status,
3673: x_msg_count,

Line 3937: -- delete_row for:OKC_K_ARTICLES_TL --

3933: );
3934:
3935: END delete_row;
3936: --------------------------------------
3937: -- delete_row for:OKC_K_ARTICLES_TL --
3938: --------------------------------------
3939: PROCEDURE delete_row(
3940: p_init_msg_list IN VARCHAR2 ,
3941: x_return_status OUT NOCOPY VARCHAR2,

Line 3944: p_okc_k_articles_tl_rec IN okc_k_articles_tl_rec_type) IS

3940: p_init_msg_list IN VARCHAR2 ,
3941: x_return_status OUT NOCOPY VARCHAR2,
3942: x_msg_count OUT NOCOPY NUMBER,
3943: x_msg_data OUT NOCOPY VARCHAR2,
3944: p_okc_k_articles_tl_rec IN okc_k_articles_tl_rec_type) IS
3945:
3946: l_api_version CONSTANT NUMBER := 1;
3947: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3948: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 3949: l_okc_k_articles_tl_rec okc_k_articles_tl_rec_type:= p_okc_k_articles_tl_rec;

3945:
3946: l_api_version CONSTANT NUMBER := 1;
3947: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3948: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3949: l_okc_k_articles_tl_rec okc_k_articles_tl_rec_type:= p_okc_k_articles_tl_rec;
3950: l_row_notfound BOOLEAN := TRUE;
3951: ------------------------------------------
3952: -- Set_Attributes for:OKC_K_ARTICLES_TL --
3953: ------------------------------------------

Line 3952: -- Set_Attributes for:OKC_K_ARTICLES_TL --

3948: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3949: l_okc_k_articles_tl_rec okc_k_articles_tl_rec_type:= p_okc_k_articles_tl_rec;
3950: l_row_notfound BOOLEAN := TRUE;
3951: ------------------------------------------
3952: -- Set_Attributes for:OKC_K_ARTICLES_TL --
3953: ------------------------------------------
3954: FUNCTION Set_Attributes (
3955: p_okc_k_articles_tl_rec IN okc_k_articles_tl_rec_type,
3956: x_okc_k_articles_tl_rec OUT NOCOPY okc_k_articles_tl_rec_type

Line 3955: p_okc_k_articles_tl_rec IN okc_k_articles_tl_rec_type,

3951: ------------------------------------------
3952: -- Set_Attributes for:OKC_K_ARTICLES_TL --
3953: ------------------------------------------
3954: FUNCTION Set_Attributes (
3955: p_okc_k_articles_tl_rec IN okc_k_articles_tl_rec_type,
3956: x_okc_k_articles_tl_rec OUT NOCOPY okc_k_articles_tl_rec_type
3957: ) RETURN VARCHAR2 IS
3958: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3959: BEGIN

Line 3956: x_okc_k_articles_tl_rec OUT NOCOPY okc_k_articles_tl_rec_type

3952: -- Set_Attributes for:OKC_K_ARTICLES_TL --
3953: ------------------------------------------
3954: FUNCTION Set_Attributes (
3955: p_okc_k_articles_tl_rec IN okc_k_articles_tl_rec_type,
3956: x_okc_k_articles_tl_rec OUT NOCOPY okc_k_articles_tl_rec_type
3957: ) RETURN VARCHAR2 IS
3958: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3959: BEGIN
3960:

Line 3961: x_okc_k_articles_tl_rec := p_okc_k_articles_tl_rec;

3957: ) RETURN VARCHAR2 IS
3958: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3959: BEGIN
3960:
3961: x_okc_k_articles_tl_rec := p_okc_k_articles_tl_rec;
3962: x_okc_k_articles_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
3963: RETURN(l_return_status);
3964:
3965: END Set_Attributes;

Line 3962: x_okc_k_articles_tl_rec.LANGUAGE := okc_util.get_userenv_lang;

3958: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3959: BEGIN
3960:
3961: x_okc_k_articles_tl_rec := p_okc_k_articles_tl_rec;
3962: x_okc_k_articles_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
3963: RETURN(l_return_status);
3964:
3965: END Set_Attributes;
3966: BEGIN

Line 3984: p_okc_k_articles_tl_rec, -- IN

3980: RAISE OKC_API.G_EXCEPTION_ERROR;
3981: END IF;
3982: --- Setting item attributes
3983: l_return_status := Set_Attributes(
3984: p_okc_k_articles_tl_rec, -- IN
3985: l_okc_k_articles_tl_rec); -- OUT
3986: --- If any errors happen abort API
3987: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3988: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3985: l_okc_k_articles_tl_rec); -- OUT

3981: END IF;
3982: --- Setting item attributes
3983: l_return_status := Set_Attributes(
3984: p_okc_k_articles_tl_rec, -- IN
3985: l_okc_k_articles_tl_rec); -- OUT
3986: --- If any errors happen abort API
3987: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3988: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3989: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 3992: DELETE FROM OKC_K_ARTICLES_TL

3988: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3989: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3990: RAISE OKC_API.G_EXCEPTION_ERROR;
3991: END IF;
3992: DELETE FROM OKC_K_ARTICLES_TL
3993: WHERE ID = l_okc_k_articles_tl_rec.id;
3994:
3995: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3996:

Line 3993: WHERE ID = l_okc_k_articles_tl_rec.id;

3989: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3990: RAISE OKC_API.G_EXCEPTION_ERROR;
3991: END IF;
3992: DELETE FROM OKC_K_ARTICLES_TL
3993: WHERE ID = l_okc_k_articles_tl_rec.id;
3994:
3995: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3996:
3997: IF (l_debug = 'Y') THEN

Line 4068: l_okc_k_articles_tl_rec okc_k_articles_tl_rec_type;

4064: l_api_version CONSTANT NUMBER := 1;
4065: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
4066: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4067: l_catv_rec catv_rec_type := p_catv_rec;
4068: l_okc_k_articles_tl_rec okc_k_articles_tl_rec_type;
4069: l_cat_rec cat_rec_type;
4070: BEGIN
4071:
4072: IF (l_debug = 'Y') THEN

Line 4092: migrate(l_catv_rec, l_okc_k_articles_tl_rec);

4088: END IF;
4089: --------------------------------------
4090: -- Move VIEW record to "Child" records
4091: --------------------------------------
4092: migrate(l_catv_rec, l_okc_k_articles_tl_rec);
4093: migrate(l_catv_rec, l_cat_rec);
4094: --------------------------------------------
4095: -- Call the DELETE_ROW for each child record
4096: --------------------------------------------

Line 4102: l_okc_k_articles_tl_rec

4098: p_init_msg_list,
4099: x_return_status,
4100: x_msg_count,
4101: x_msg_data,
4102: l_okc_k_articles_tl_rec
4103: );
4104: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4105: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4106: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 4447: INSERT INTO OKC_K_ARTICLES_TL(

4443: );
4444:
4445: FOR lang_i IN OKC_UTIL.g_language_code.FIRST..OKC_UTIL.g_language_code.LAST LOOP
4446: FORALL i in 1..l_tabsize
4447: INSERT INTO OKC_K_ARTICLES_TL(
4448: id,
4449: language,
4450: source_lang,
4451: sfwt_flag,

Line 4605: INSERT INTO okc_k_articles_tlh

4601: --------------------------------
4602: -- Versioning TL Table
4603: -------------------------------
4604:
4605: INSERT INTO okc_k_articles_tlh
4606: (
4607: major_version,
4608: id,
4609: language,

Line 4641: FROM okc_k_articles_tl

4637: last_updated_by,
4638: last_update_date,
4639: last_update_login,
4640: sav_sav_release
4641: FROM okc_k_articles_tl
4642: WHERE id in (select id from okc_k_articles_b
4643: where dnz_chr_id = p_chr_id);
4644:
4645: IF (l_debug = 'Y') THEN

Line 4693: INSERT INTO okc_k_articles_tl

4689: okc_debug.Set_Indentation('OKC_CAT_PVT');
4690: okc_debug.log('15200: Entered restore_version', 2);
4691: END IF;
4692:
4693: INSERT INTO okc_k_articles_tl
4694: (
4695: id,
4696: language,
4697: source_lang,

Line 4727: FROM okc_k_articles_tlh

4723: last_updated_by,
4724: last_update_date,
4725: last_update_login,
4726: sav_sav_release
4727: FROM okc_k_articles_tlh
4728: WHERE id in (SELECT id
4729: FROM okc_k_articles_bh
4730: WHERE dnz_chr_id = p_chr_id)
4731: AND major_version = p_major_version;