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_SAE_PVT dependencies on OKC_STD_ARTICLES_TL

Line 62: DELETE FROM OKC_STD_ARTICLES_TL T

58: /* as a quick workaround to fix the time-consuming table handler issue */
59: /* Eventually we'll need to turn them into a separate fix_language procedure */
60: /*
61:
62: DELETE FROM OKC_STD_ARTICLES_TL T
63: WHERE NOT EXISTS (
64: SELECT NULL
65: FROM OKC_STD_ARTICLES_B B
66: WHERE B.ID = T.ID

Line 69: UPDATE OKC_STD_ARTICLES_TL T SET (

65: FROM OKC_STD_ARTICLES_B B
66: WHERE B.ID = T.ID
67: );
68:
69: UPDATE OKC_STD_ARTICLES_TL T SET (
70: NAME) = (SELECT
71: B.NAME
72: FROM OKC_STD_ARTICLES_TL B
73: WHERE B.ID = T.ID

Line 72: FROM OKC_STD_ARTICLES_TL B

68:
69: UPDATE OKC_STD_ARTICLES_TL T SET (
70: NAME) = (SELECT
71: B.NAME
72: FROM OKC_STD_ARTICLES_TL B
73: WHERE B.ID = T.ID
74: AND B.LANGUAGE = T.SOURCE_LANG)
75: WHERE (
76: T.ID,

Line 81: FROM OKC_STD_ARTICLES_TL SUBB, OKC_STD_ARTICLES_TL SUBT

77: T.LANGUAGE)
78: IN (SELECT
79: SUBT.ID,
80: SUBT.LANGUAGE
81: FROM OKC_STD_ARTICLES_TL SUBB, OKC_STD_ARTICLES_TL SUBT
82: WHERE SUBB.ID = SUBT.ID
83: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
84: AND (SUBB.NAME <> SUBT.NAME
85: ));

Line 88: INSERT INTO OKC_STD_ARTICLES_TL (

84: AND (SUBB.NAME <> SUBT.NAME
85: ));
86: */
87:
88: INSERT INTO OKC_STD_ARTICLES_TL (
89: ID,
90: LANGUAGE,
91: SOURCE_LANG,
92: SFWT_FLAG,

Line 110: FROM OKC_STD_ARTICLES_TL B, FND_LANGUAGES L

106: B.CREATION_DATE,
107: B.LAST_UPDATED_BY,
108: B.LAST_UPDATE_DATE,
109: B.LAST_UPDATE_LOGIN
110: FROM OKC_STD_ARTICLES_TL B, FND_LANGUAGES L
111: WHERE L.INSTALLED_FLAG IN ('I', 'B')
112: AND B.LANGUAGE = USERENV('LANG')
113: AND NOT EXISTS(
114: SELECT NULL

Line 115: FROM OKC_STD_ARTICLES_TL T

111: WHERE L.INSTALLED_FLAG IN ('I', 'B')
112: AND B.LANGUAGE = USERENV('LANG')
113: AND NOT EXISTS(
114: SELECT NULL
115: FROM OKC_STD_ARTICLES_TL T
116: WHERE T.ID = B.ID
117: AND T.LANGUAGE = L.LANGUAGE_CODE
118: );
119:

Line 221: -- FUNCTION get_rec for: OKC_STD_ARTICLES_TL

217: RETURN(get_rec(p_sae_rec, l_row_notfound));
218:
219: END get_rec;
220: ---------------------------------------------------------------------------
221: -- FUNCTION get_rec for: OKC_STD_ARTICLES_TL
222: ---------------------------------------------------------------------------
223: FUNCTION get_rec (
224: p_okc_std_articles_tl_rec IN okc_std_articles_tl_rec_type,
225: x_no_data_found OUT NOCOPY BOOLEAN

Line 224: p_okc_std_articles_tl_rec IN okc_std_articles_tl_rec_type,

220: ---------------------------------------------------------------------------
221: -- FUNCTION get_rec for: OKC_STD_ARTICLES_TL
222: ---------------------------------------------------------------------------
223: FUNCTION get_rec (
224: p_okc_std_articles_tl_rec IN okc_std_articles_tl_rec_type,
225: x_no_data_found OUT NOCOPY BOOLEAN
226: ) RETURN okc_std_articles_tl_rec_type IS
227: CURSOR sae_pktl_csr (p_id IN NUMBER,
228: p_language IN VARCHAR2) IS

Line 226: ) RETURN okc_std_articles_tl_rec_type IS

222: ---------------------------------------------------------------------------
223: FUNCTION get_rec (
224: p_okc_std_articles_tl_rec IN okc_std_articles_tl_rec_type,
225: x_no_data_found OUT NOCOPY BOOLEAN
226: ) RETURN okc_std_articles_tl_rec_type IS
227: CURSOR sae_pktl_csr (p_id IN NUMBER,
228: p_language IN VARCHAR2) IS
229: SELECT
230: ID,

Line 240: FROM Okc_Std_Articles_Tl

236: CREATION_DATE,
237: LAST_UPDATED_BY,
238: LAST_UPDATE_DATE,
239: LAST_UPDATE_LOGIN
240: FROM Okc_Std_Articles_Tl
241: WHERE okc_std_articles_tl.id = p_id
242: AND okc_std_articles_tl.language = p_language;
243: l_sae_pktl sae_pktl_csr%ROWTYPE;
244: l_okc_std_articles_tl_rec okc_std_articles_tl_rec_type;

Line 241: WHERE okc_std_articles_tl.id = p_id

237: LAST_UPDATED_BY,
238: LAST_UPDATE_DATE,
239: LAST_UPDATE_LOGIN
240: FROM Okc_Std_Articles_Tl
241: WHERE okc_std_articles_tl.id = p_id
242: AND okc_std_articles_tl.language = p_language;
243: l_sae_pktl sae_pktl_csr%ROWTYPE;
244: l_okc_std_articles_tl_rec okc_std_articles_tl_rec_type;
245: BEGIN

Line 242: AND okc_std_articles_tl.language = p_language;

238: LAST_UPDATE_DATE,
239: LAST_UPDATE_LOGIN
240: FROM Okc_Std_Articles_Tl
241: WHERE okc_std_articles_tl.id = p_id
242: AND okc_std_articles_tl.language = p_language;
243: l_sae_pktl sae_pktl_csr%ROWTYPE;
244: l_okc_std_articles_tl_rec okc_std_articles_tl_rec_type;
245: BEGIN
246:

Line 244: l_okc_std_articles_tl_rec okc_std_articles_tl_rec_type;

240: FROM Okc_Std_Articles_Tl
241: WHERE okc_std_articles_tl.id = p_id
242: AND okc_std_articles_tl.language = p_language;
243: l_sae_pktl sae_pktl_csr%ROWTYPE;
244: l_okc_std_articles_tl_rec okc_std_articles_tl_rec_type;
245: BEGIN
246:
247: IF (l_debug = 'Y') THEN
248: okc_debug.Set_Indentation('OKC_SAE_PVT');

Line 254: OPEN sae_pktl_csr (p_okc_std_articles_tl_rec.id,

250: END IF;
251:
252: x_no_data_found := TRUE;
253: -- Get current database values
254: OPEN sae_pktl_csr (p_okc_std_articles_tl_rec.id,
255: p_okc_std_articles_tl_rec.language);
256: FETCH sae_pktl_csr INTO
257: l_okc_std_articles_tl_rec.ID,
258: l_okc_std_articles_tl_rec.LANGUAGE,

Line 255: p_okc_std_articles_tl_rec.language);

251:
252: x_no_data_found := TRUE;
253: -- Get current database values
254: OPEN sae_pktl_csr (p_okc_std_articles_tl_rec.id,
255: p_okc_std_articles_tl_rec.language);
256: FETCH sae_pktl_csr INTO
257: l_okc_std_articles_tl_rec.ID,
258: l_okc_std_articles_tl_rec.LANGUAGE,
259: l_okc_std_articles_tl_rec.SOURCE_LANG,

Line 257: l_okc_std_articles_tl_rec.ID,

253: -- Get current database values
254: OPEN sae_pktl_csr (p_okc_std_articles_tl_rec.id,
255: p_okc_std_articles_tl_rec.language);
256: FETCH sae_pktl_csr INTO
257: l_okc_std_articles_tl_rec.ID,
258: l_okc_std_articles_tl_rec.LANGUAGE,
259: l_okc_std_articles_tl_rec.SOURCE_LANG,
260: l_okc_std_articles_tl_rec.SFWT_FLAG,
261: l_okc_std_articles_tl_rec.NAME,

Line 258: l_okc_std_articles_tl_rec.LANGUAGE,

254: OPEN sae_pktl_csr (p_okc_std_articles_tl_rec.id,
255: p_okc_std_articles_tl_rec.language);
256: FETCH sae_pktl_csr INTO
257: l_okc_std_articles_tl_rec.ID,
258: l_okc_std_articles_tl_rec.LANGUAGE,
259: l_okc_std_articles_tl_rec.SOURCE_LANG,
260: l_okc_std_articles_tl_rec.SFWT_FLAG,
261: l_okc_std_articles_tl_rec.NAME,
262: l_okc_std_articles_tl_rec.CREATED_BY,

Line 259: l_okc_std_articles_tl_rec.SOURCE_LANG,

255: p_okc_std_articles_tl_rec.language);
256: FETCH sae_pktl_csr INTO
257: l_okc_std_articles_tl_rec.ID,
258: l_okc_std_articles_tl_rec.LANGUAGE,
259: l_okc_std_articles_tl_rec.SOURCE_LANG,
260: l_okc_std_articles_tl_rec.SFWT_FLAG,
261: l_okc_std_articles_tl_rec.NAME,
262: l_okc_std_articles_tl_rec.CREATED_BY,
263: l_okc_std_articles_tl_rec.CREATION_DATE,

Line 260: l_okc_std_articles_tl_rec.SFWT_FLAG,

256: FETCH sae_pktl_csr INTO
257: l_okc_std_articles_tl_rec.ID,
258: l_okc_std_articles_tl_rec.LANGUAGE,
259: l_okc_std_articles_tl_rec.SOURCE_LANG,
260: l_okc_std_articles_tl_rec.SFWT_FLAG,
261: l_okc_std_articles_tl_rec.NAME,
262: l_okc_std_articles_tl_rec.CREATED_BY,
263: l_okc_std_articles_tl_rec.CREATION_DATE,
264: l_okc_std_articles_tl_rec.LAST_UPDATED_BY,

Line 261: l_okc_std_articles_tl_rec.NAME,

257: l_okc_std_articles_tl_rec.ID,
258: l_okc_std_articles_tl_rec.LANGUAGE,
259: l_okc_std_articles_tl_rec.SOURCE_LANG,
260: l_okc_std_articles_tl_rec.SFWT_FLAG,
261: l_okc_std_articles_tl_rec.NAME,
262: l_okc_std_articles_tl_rec.CREATED_BY,
263: l_okc_std_articles_tl_rec.CREATION_DATE,
264: l_okc_std_articles_tl_rec.LAST_UPDATED_BY,
265: l_okc_std_articles_tl_rec.LAST_UPDATE_DATE,

Line 262: l_okc_std_articles_tl_rec.CREATED_BY,

258: l_okc_std_articles_tl_rec.LANGUAGE,
259: l_okc_std_articles_tl_rec.SOURCE_LANG,
260: l_okc_std_articles_tl_rec.SFWT_FLAG,
261: l_okc_std_articles_tl_rec.NAME,
262: l_okc_std_articles_tl_rec.CREATED_BY,
263: l_okc_std_articles_tl_rec.CREATION_DATE,
264: l_okc_std_articles_tl_rec.LAST_UPDATED_BY,
265: l_okc_std_articles_tl_rec.LAST_UPDATE_DATE,
266: l_okc_std_articles_tl_rec.LAST_UPDATE_LOGIN;

Line 263: l_okc_std_articles_tl_rec.CREATION_DATE,

259: l_okc_std_articles_tl_rec.SOURCE_LANG,
260: l_okc_std_articles_tl_rec.SFWT_FLAG,
261: l_okc_std_articles_tl_rec.NAME,
262: l_okc_std_articles_tl_rec.CREATED_BY,
263: l_okc_std_articles_tl_rec.CREATION_DATE,
264: l_okc_std_articles_tl_rec.LAST_UPDATED_BY,
265: l_okc_std_articles_tl_rec.LAST_UPDATE_DATE,
266: l_okc_std_articles_tl_rec.LAST_UPDATE_LOGIN;
267: x_no_data_found := sae_pktl_csr%NOTFOUND;

Line 264: l_okc_std_articles_tl_rec.LAST_UPDATED_BY,

260: l_okc_std_articles_tl_rec.SFWT_FLAG,
261: l_okc_std_articles_tl_rec.NAME,
262: l_okc_std_articles_tl_rec.CREATED_BY,
263: l_okc_std_articles_tl_rec.CREATION_DATE,
264: l_okc_std_articles_tl_rec.LAST_UPDATED_BY,
265: l_okc_std_articles_tl_rec.LAST_UPDATE_DATE,
266: l_okc_std_articles_tl_rec.LAST_UPDATE_LOGIN;
267: x_no_data_found := sae_pktl_csr%NOTFOUND;
268: CLOSE sae_pktl_csr;

Line 265: l_okc_std_articles_tl_rec.LAST_UPDATE_DATE,

261: l_okc_std_articles_tl_rec.NAME,
262: l_okc_std_articles_tl_rec.CREATED_BY,
263: l_okc_std_articles_tl_rec.CREATION_DATE,
264: l_okc_std_articles_tl_rec.LAST_UPDATED_BY,
265: l_okc_std_articles_tl_rec.LAST_UPDATE_DATE,
266: l_okc_std_articles_tl_rec.LAST_UPDATE_LOGIN;
267: x_no_data_found := sae_pktl_csr%NOTFOUND;
268: CLOSE sae_pktl_csr;
269:

Line 266: l_okc_std_articles_tl_rec.LAST_UPDATE_LOGIN;

262: l_okc_std_articles_tl_rec.CREATED_BY,
263: l_okc_std_articles_tl_rec.CREATION_DATE,
264: l_okc_std_articles_tl_rec.LAST_UPDATED_BY,
265: l_okc_std_articles_tl_rec.LAST_UPDATE_DATE,
266: l_okc_std_articles_tl_rec.LAST_UPDATE_LOGIN;
267: x_no_data_found := sae_pktl_csr%NOTFOUND;
268: CLOSE sae_pktl_csr;
269:
270: IF (l_debug = 'Y') THEN

Line 275: RETURN(l_okc_std_articles_tl_rec);

271: okc_debug.log('900: Leaving Fn Get_Rec ', 2);
272: okc_debug.Reset_Indentation;
273: END IF;
274:
275: RETURN(l_okc_std_articles_tl_rec);
276:
277: END get_rec;
278:
279: FUNCTION get_rec (

Line 280: p_okc_std_articles_tl_rec IN okc_std_articles_tl_rec_type

276:
277: END get_rec;
278:
279: FUNCTION get_rec (
280: p_okc_std_articles_tl_rec IN okc_std_articles_tl_rec_type
281: ) RETURN okc_std_articles_tl_rec_type IS
282: l_row_notfound BOOLEAN := TRUE;
283: BEGIN
284:

Line 281: ) RETURN okc_std_articles_tl_rec_type IS

277: END get_rec;
278:
279: FUNCTION get_rec (
280: p_okc_std_articles_tl_rec IN okc_std_articles_tl_rec_type
281: ) RETURN okc_std_articles_tl_rec_type IS
282: l_row_notfound BOOLEAN := TRUE;
283: BEGIN
284:
285: RETURN(get_rec(p_okc_std_articles_tl_rec, l_row_notfound));

Line 285: RETURN(get_rec(p_okc_std_articles_tl_rec, l_row_notfound));

281: ) RETURN okc_std_articles_tl_rec_type IS
282: l_row_notfound BOOLEAN := TRUE;
283: BEGIN
284:
285: RETURN(get_rec(p_okc_std_articles_tl_rec, l_row_notfound));
286:
287: END get_rec;
288: ---------------------------------------------------------------------------
289: -- FUNCTION get_rec for: OKC_STD_ARTICLES_V

Line 1134: p_to OUT NOCOPY okc_std_articles_tl_rec_type

1130: END migrate;
1131:
1132: PROCEDURE migrate (
1133: p_from IN saev_rec_type,
1134: p_to OUT NOCOPY okc_std_articles_tl_rec_type
1135: ) IS
1136: BEGIN
1137:
1138: p_to.id := p_from.id;

Line 1151: p_from IN okc_std_articles_tl_rec_type,

1147: END migrate;
1148:
1149:
1150: PROCEDURE migrate (
1151: p_from IN okc_std_articles_tl_rec_type,
1152: p_to IN OUT NOCOPY saev_rec_type
1153: ) IS
1154: BEGIN
1155:

Line 1186: l_okc_std_articles_tl_rec okc_std_articles_tl_rec_type;

1182: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
1183: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1184: l_saev_rec saev_rec_type := p_saev_rec;
1185: l_sae_rec sae_rec_type;
1186: l_okc_std_articles_tl_rec okc_std_articles_tl_rec_type;
1187: BEGIN
1188:
1189: IF (l_debug = 'Y') THEN
1190: okc_debug.Set_Indentation('OKC_SAE_PVT');

Line 1543: -- insert_row for:OKC_STD_ARTICLES_TL --

1539: );
1540:
1541: END insert_row;
1542: ----------------------------------------
1543: -- insert_row for:OKC_STD_ARTICLES_TL --
1544: ----------------------------------------
1545: PROCEDURE insert_row(
1546: p_init_msg_list IN VARCHAR2 ,
1547: x_return_status OUT NOCOPY VARCHAR2,

Line 1550: p_okc_std_articles_tl_rec IN okc_std_articles_tl_rec_type,

1546: p_init_msg_list IN VARCHAR2 ,
1547: x_return_status OUT NOCOPY VARCHAR2,
1548: x_msg_count OUT NOCOPY NUMBER,
1549: x_msg_data OUT NOCOPY VARCHAR2,
1550: p_okc_std_articles_tl_rec IN okc_std_articles_tl_rec_type,
1551: x_okc_std_articles_tl_rec OUT NOCOPY okc_std_articles_tl_rec_type) IS
1552:
1553: l_api_version CONSTANT NUMBER := 1;
1554: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';

Line 1551: x_okc_std_articles_tl_rec OUT NOCOPY okc_std_articles_tl_rec_type) IS

1547: x_return_status OUT NOCOPY VARCHAR2,
1548: x_msg_count OUT NOCOPY NUMBER,
1549: x_msg_data OUT NOCOPY VARCHAR2,
1550: p_okc_std_articles_tl_rec IN okc_std_articles_tl_rec_type,
1551: x_okc_std_articles_tl_rec OUT NOCOPY okc_std_articles_tl_rec_type) IS
1552:
1553: l_api_version CONSTANT NUMBER := 1;
1554: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1555: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1556: l_okc_std_articles_tl_rec okc_std_articles_tl_rec_type := p_okc_std_articles_tl_rec;

1552:
1553: l_api_version CONSTANT NUMBER := 1;
1554: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1555: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1556: l_okc_std_articles_tl_rec okc_std_articles_tl_rec_type := p_okc_std_articles_tl_rec;
1557: ldefokcstdarticlestlrec okc_std_articles_tl_rec_type;
1558: CURSOR get_languages IS
1559: SELECT *
1560: FROM FND_LANGUAGES

Line 1557: ldefokcstdarticlestlrec okc_std_articles_tl_rec_type;

1553: l_api_version CONSTANT NUMBER := 1;
1554: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1555: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1556: l_okc_std_articles_tl_rec okc_std_articles_tl_rec_type := p_okc_std_articles_tl_rec;
1557: ldefokcstdarticlestlrec okc_std_articles_tl_rec_type;
1558: CURSOR get_languages IS
1559: SELECT *
1560: FROM FND_LANGUAGES
1561: WHERE INSTALLED_FLAG IN ('I', 'B');

Line 1563: -- Set_Attributes for:OKC_STD_ARTICLES_TL --

1559: SELECT *
1560: FROM FND_LANGUAGES
1561: WHERE INSTALLED_FLAG IN ('I', 'B');
1562: --------------------------------------------
1563: -- Set_Attributes for:OKC_STD_ARTICLES_TL --
1564: --------------------------------------------
1565: FUNCTION Set_Attributes (
1566: p_okc_std_articles_tl_rec IN okc_std_articles_tl_rec_type,
1567: x_okc_std_articles_tl_rec OUT NOCOPY okc_std_articles_tl_rec_type

Line 1566: p_okc_std_articles_tl_rec IN okc_std_articles_tl_rec_type,

1562: --------------------------------------------
1563: -- Set_Attributes for:OKC_STD_ARTICLES_TL --
1564: --------------------------------------------
1565: FUNCTION Set_Attributes (
1566: p_okc_std_articles_tl_rec IN okc_std_articles_tl_rec_type,
1567: x_okc_std_articles_tl_rec OUT NOCOPY okc_std_articles_tl_rec_type
1568: ) RETURN VARCHAR2 IS
1569: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1570: BEGIN

Line 1567: x_okc_std_articles_tl_rec OUT NOCOPY okc_std_articles_tl_rec_type

1563: -- Set_Attributes for:OKC_STD_ARTICLES_TL --
1564: --------------------------------------------
1565: FUNCTION Set_Attributes (
1566: p_okc_std_articles_tl_rec IN okc_std_articles_tl_rec_type,
1567: x_okc_std_articles_tl_rec OUT NOCOPY okc_std_articles_tl_rec_type
1568: ) RETURN VARCHAR2 IS
1569: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1570: BEGIN
1571:

Line 1572: x_okc_std_articles_tl_rec := p_okc_std_articles_tl_rec;

1568: ) RETURN VARCHAR2 IS
1569: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1570: BEGIN
1571:
1572: x_okc_std_articles_tl_rec := p_okc_std_articles_tl_rec;
1573: --x_okc_std_articles_tl_rec.LANGUAGE := USERENV('LANG');
1574: x_okc_std_articles_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
1575: --x_okc_std_articles_tl_rec.SOURCE_LANG := USERENV('LANG');
1576: x_okc_std_articles_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;

Line 1573: --x_okc_std_articles_tl_rec.LANGUAGE := USERENV('LANG');

1569: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1570: BEGIN
1571:
1572: x_okc_std_articles_tl_rec := p_okc_std_articles_tl_rec;
1573: --x_okc_std_articles_tl_rec.LANGUAGE := USERENV('LANG');
1574: x_okc_std_articles_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
1575: --x_okc_std_articles_tl_rec.SOURCE_LANG := USERENV('LANG');
1576: x_okc_std_articles_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
1577: RETURN(l_return_status);

Line 1574: x_okc_std_articles_tl_rec.LANGUAGE := okc_util.get_userenv_lang;

1570: BEGIN
1571:
1572: x_okc_std_articles_tl_rec := p_okc_std_articles_tl_rec;
1573: --x_okc_std_articles_tl_rec.LANGUAGE := USERENV('LANG');
1574: x_okc_std_articles_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
1575: --x_okc_std_articles_tl_rec.SOURCE_LANG := USERENV('LANG');
1576: x_okc_std_articles_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
1577: RETURN(l_return_status);
1578:

Line 1575: --x_okc_std_articles_tl_rec.SOURCE_LANG := USERENV('LANG');

1571:
1572: x_okc_std_articles_tl_rec := p_okc_std_articles_tl_rec;
1573: --x_okc_std_articles_tl_rec.LANGUAGE := USERENV('LANG');
1574: x_okc_std_articles_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
1575: --x_okc_std_articles_tl_rec.SOURCE_LANG := USERENV('LANG');
1576: x_okc_std_articles_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
1577: RETURN(l_return_status);
1578:
1579: END Set_Attributes;

Line 1576: x_okc_std_articles_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;

1572: x_okc_std_articles_tl_rec := p_okc_std_articles_tl_rec;
1573: --x_okc_std_articles_tl_rec.LANGUAGE := USERENV('LANG');
1574: x_okc_std_articles_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
1575: --x_okc_std_articles_tl_rec.SOURCE_LANG := USERENV('LANG');
1576: x_okc_std_articles_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
1577: RETURN(l_return_status);
1578:
1579: END Set_Attributes;
1580: BEGIN

Line 1598: p_okc_std_articles_tl_rec, -- IN

1594: RAISE OKC_API.G_EXCEPTION_ERROR;
1595: END IF;
1596: --- Setting item attributes
1597: l_return_status := Set_Attributes(
1598: p_okc_std_articles_tl_rec, -- IN
1599: l_okc_std_articles_tl_rec); -- OUT
1600: --- If any errors happen abort API
1601: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1602: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1599: l_okc_std_articles_tl_rec); -- OUT

1595: END IF;
1596: --- Setting item attributes
1597: l_return_status := Set_Attributes(
1598: p_okc_std_articles_tl_rec, -- IN
1599: l_okc_std_articles_tl_rec); -- OUT
1600: --- If any errors happen abort API
1601: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1602: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1603: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 1607: l_okc_std_articles_tl_rec.language := l_lang_rec.language_code;

1603: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1604: RAISE OKC_API.G_EXCEPTION_ERROR;
1605: END IF;
1606: FOR l_lang_rec IN get_languages LOOP
1607: l_okc_std_articles_tl_rec.language := l_lang_rec.language_code;
1608: INSERT INTO OKC_STD_ARTICLES_TL(
1609: id,
1610: language,
1611: source_lang,

Line 1608: INSERT INTO OKC_STD_ARTICLES_TL(

1604: RAISE OKC_API.G_EXCEPTION_ERROR;
1605: END IF;
1606: FOR l_lang_rec IN get_languages LOOP
1607: l_okc_std_articles_tl_rec.language := l_lang_rec.language_code;
1608: INSERT INTO OKC_STD_ARTICLES_TL(
1609: id,
1610: language,
1611: source_lang,
1612: sfwt_flag,

Line 1620: l_okc_std_articles_tl_rec.id,

1616: last_updated_by,
1617: last_update_date,
1618: last_update_login)
1619: VALUES (
1620: l_okc_std_articles_tl_rec.id,
1621: l_okc_std_articles_tl_rec.language,
1622: l_okc_std_articles_tl_rec.source_lang,
1623: l_okc_std_articles_tl_rec.sfwt_flag,
1624: l_okc_std_articles_tl_rec.name,

Line 1621: l_okc_std_articles_tl_rec.language,

1617: last_update_date,
1618: last_update_login)
1619: VALUES (
1620: l_okc_std_articles_tl_rec.id,
1621: l_okc_std_articles_tl_rec.language,
1622: l_okc_std_articles_tl_rec.source_lang,
1623: l_okc_std_articles_tl_rec.sfwt_flag,
1624: l_okc_std_articles_tl_rec.name,
1625: l_okc_std_articles_tl_rec.created_by,

Line 1622: l_okc_std_articles_tl_rec.source_lang,

1618: last_update_login)
1619: VALUES (
1620: l_okc_std_articles_tl_rec.id,
1621: l_okc_std_articles_tl_rec.language,
1622: l_okc_std_articles_tl_rec.source_lang,
1623: l_okc_std_articles_tl_rec.sfwt_flag,
1624: l_okc_std_articles_tl_rec.name,
1625: l_okc_std_articles_tl_rec.created_by,
1626: l_okc_std_articles_tl_rec.creation_date,

Line 1623: l_okc_std_articles_tl_rec.sfwt_flag,

1619: VALUES (
1620: l_okc_std_articles_tl_rec.id,
1621: l_okc_std_articles_tl_rec.language,
1622: l_okc_std_articles_tl_rec.source_lang,
1623: l_okc_std_articles_tl_rec.sfwt_flag,
1624: l_okc_std_articles_tl_rec.name,
1625: l_okc_std_articles_tl_rec.created_by,
1626: l_okc_std_articles_tl_rec.creation_date,
1627: l_okc_std_articles_tl_rec.last_updated_by,

Line 1624: l_okc_std_articles_tl_rec.name,

1620: l_okc_std_articles_tl_rec.id,
1621: l_okc_std_articles_tl_rec.language,
1622: l_okc_std_articles_tl_rec.source_lang,
1623: l_okc_std_articles_tl_rec.sfwt_flag,
1624: l_okc_std_articles_tl_rec.name,
1625: l_okc_std_articles_tl_rec.created_by,
1626: l_okc_std_articles_tl_rec.creation_date,
1627: l_okc_std_articles_tl_rec.last_updated_by,
1628: l_okc_std_articles_tl_rec.last_update_date,

Line 1625: l_okc_std_articles_tl_rec.created_by,

1621: l_okc_std_articles_tl_rec.language,
1622: l_okc_std_articles_tl_rec.source_lang,
1623: l_okc_std_articles_tl_rec.sfwt_flag,
1624: l_okc_std_articles_tl_rec.name,
1625: l_okc_std_articles_tl_rec.created_by,
1626: l_okc_std_articles_tl_rec.creation_date,
1627: l_okc_std_articles_tl_rec.last_updated_by,
1628: l_okc_std_articles_tl_rec.last_update_date,
1629: l_okc_std_articles_tl_rec.last_update_login);

Line 1626: l_okc_std_articles_tl_rec.creation_date,

1622: l_okc_std_articles_tl_rec.source_lang,
1623: l_okc_std_articles_tl_rec.sfwt_flag,
1624: l_okc_std_articles_tl_rec.name,
1625: l_okc_std_articles_tl_rec.created_by,
1626: l_okc_std_articles_tl_rec.creation_date,
1627: l_okc_std_articles_tl_rec.last_updated_by,
1628: l_okc_std_articles_tl_rec.last_update_date,
1629: l_okc_std_articles_tl_rec.last_update_login);
1630: END LOOP;

Line 1627: l_okc_std_articles_tl_rec.last_updated_by,

1623: l_okc_std_articles_tl_rec.sfwt_flag,
1624: l_okc_std_articles_tl_rec.name,
1625: l_okc_std_articles_tl_rec.created_by,
1626: l_okc_std_articles_tl_rec.creation_date,
1627: l_okc_std_articles_tl_rec.last_updated_by,
1628: l_okc_std_articles_tl_rec.last_update_date,
1629: l_okc_std_articles_tl_rec.last_update_login);
1630: END LOOP;
1631: -- Set OUT values

Line 1628: l_okc_std_articles_tl_rec.last_update_date,

1624: l_okc_std_articles_tl_rec.name,
1625: l_okc_std_articles_tl_rec.created_by,
1626: l_okc_std_articles_tl_rec.creation_date,
1627: l_okc_std_articles_tl_rec.last_updated_by,
1628: l_okc_std_articles_tl_rec.last_update_date,
1629: l_okc_std_articles_tl_rec.last_update_login);
1630: END LOOP;
1631: -- Set OUT values
1632: x_okc_std_articles_tl_rec := l_okc_std_articles_tl_rec;

Line 1629: l_okc_std_articles_tl_rec.last_update_login);

1625: l_okc_std_articles_tl_rec.created_by,
1626: l_okc_std_articles_tl_rec.creation_date,
1627: l_okc_std_articles_tl_rec.last_updated_by,
1628: l_okc_std_articles_tl_rec.last_update_date,
1629: l_okc_std_articles_tl_rec.last_update_login);
1630: END LOOP;
1631: -- Set OUT values
1632: x_okc_std_articles_tl_rec := l_okc_std_articles_tl_rec;
1633: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1632: x_okc_std_articles_tl_rec := l_okc_std_articles_tl_rec;

1628: l_okc_std_articles_tl_rec.last_update_date,
1629: l_okc_std_articles_tl_rec.last_update_login);
1630: END LOOP;
1631: -- Set OUT values
1632: x_okc_std_articles_tl_rec := l_okc_std_articles_tl_rec;
1633: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1634:
1635: IF (l_debug = 'Y') THEN
1636: okc_debug.log('6300: Leaving insert_row', 2);

Line 1710: l_okc_std_articles_tl_rec okc_std_articles_tl_rec_type;

1706: l_saev_rec saev_rec_type;
1707: l_def_saev_rec saev_rec_type;
1708: l_sae_rec sae_rec_type;
1709: lx_sae_rec sae_rec_type;
1710: l_okc_std_articles_tl_rec okc_std_articles_tl_rec_type;
1711: lx_okc_std_articles_tl_rec okc_std_articles_tl_rec_type;
1712: -------------------------------
1713: -- FUNCTION fill_who_columns --
1714: -------------------------------

Line 1711: lx_okc_std_articles_tl_rec okc_std_articles_tl_rec_type;

1707: l_def_saev_rec saev_rec_type;
1708: l_sae_rec sae_rec_type;
1709: lx_sae_rec sae_rec_type;
1710: l_okc_std_articles_tl_rec okc_std_articles_tl_rec_type;
1711: lx_okc_std_articles_tl_rec okc_std_articles_tl_rec_type;
1712: -------------------------------
1713: -- FUNCTION fill_who_columns --
1714: -------------------------------
1715: FUNCTION fill_who_columns (

Line 1803: migrate(l_def_saev_rec, l_okc_std_articles_tl_rec);

1799: --------------------------------------
1800: -- Move VIEW record to "Child" records
1801: --------------------------------------
1802: migrate(l_def_saev_rec, l_sae_rec);
1803: migrate(l_def_saev_rec, l_okc_std_articles_tl_rec);
1804: --------------------------------------------
1805: -- Call the INSERT_ROW for each child record
1806: --------------------------------------------
1807: insert_row(

Line 1826: l_okc_std_articles_tl_rec,

1822: p_init_msg_list,
1823: x_return_status,
1824: x_msg_count,
1825: x_msg_data,
1826: l_okc_std_articles_tl_rec,
1827: lx_okc_std_articles_tl_rec
1828: );
1829: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1830: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1827: lx_okc_std_articles_tl_rec

1823: x_return_status,
1824: x_msg_count,
1825: x_msg_data,
1826: l_okc_std_articles_tl_rec,
1827: lx_okc_std_articles_tl_rec
1828: );
1829: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1830: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1831: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 1834: migrate(lx_okc_std_articles_tl_rec, l_def_saev_rec);

1830: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1831: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1832: RAISE OKC_API.G_EXCEPTION_ERROR;
1833: END IF;
1834: migrate(lx_okc_std_articles_tl_rec, l_def_saev_rec);
1835: -- Set OUT values
1836: x_saev_rec := l_def_saev_rec;
1837: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1838:

Line 2152: -- lock_row for:OKC_STD_ARTICLES_TL --

2148: );
2149:
2150: END lock_row;
2151: --------------------------------------
2152: -- lock_row for:OKC_STD_ARTICLES_TL --
2153: --------------------------------------
2154: PROCEDURE lock_row(
2155: p_init_msg_list IN VARCHAR2 ,
2156: x_return_status OUT NOCOPY VARCHAR2,

Line 2159: p_okc_std_articles_tl_rec IN okc_std_articles_tl_rec_type) IS

2155: p_init_msg_list IN VARCHAR2 ,
2156: x_return_status OUT NOCOPY VARCHAR2,
2157: x_msg_count OUT NOCOPY NUMBER,
2158: x_msg_data OUT NOCOPY VARCHAR2,
2159: p_okc_std_articles_tl_rec IN okc_std_articles_tl_rec_type) IS
2160:
2161: E_Resource_Busy EXCEPTION;
2162: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2163: CURSOR lock_csr (p_okc_std_articles_tl_rec IN okc_std_articles_tl_rec_type) IS

Line 2163: CURSOR lock_csr (p_okc_std_articles_tl_rec IN okc_std_articles_tl_rec_type) IS

2159: p_okc_std_articles_tl_rec IN okc_std_articles_tl_rec_type) IS
2160:
2161: E_Resource_Busy EXCEPTION;
2162: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2163: CURSOR lock_csr (p_okc_std_articles_tl_rec IN okc_std_articles_tl_rec_type) IS
2164: SELECT *
2165: FROM OKC_STD_ARTICLES_TL
2166: WHERE ID = p_okc_std_articles_tl_rec.id
2167: FOR UPDATE NOWAIT;

Line 2165: FROM OKC_STD_ARTICLES_TL

2161: E_Resource_Busy EXCEPTION;
2162: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2163: CURSOR lock_csr (p_okc_std_articles_tl_rec IN okc_std_articles_tl_rec_type) IS
2164: SELECT *
2165: FROM OKC_STD_ARTICLES_TL
2166: WHERE ID = p_okc_std_articles_tl_rec.id
2167: FOR UPDATE NOWAIT;
2168:
2169: l_api_version CONSTANT NUMBER := 1;

Line 2166: WHERE ID = p_okc_std_articles_tl_rec.id

2162: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2163: CURSOR lock_csr (p_okc_std_articles_tl_rec IN okc_std_articles_tl_rec_type) IS
2164: SELECT *
2165: FROM OKC_STD_ARTICLES_TL
2166: WHERE ID = p_okc_std_articles_tl_rec.id
2167: FOR UPDATE NOWAIT;
2168:
2169: l_api_version CONSTANT NUMBER := 1;
2170: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';

Line 2198: OPEN lock_csr(p_okc_std_articles_tl_rec);

2194: okc_debug.Set_Indentation('OKC_SAE_PVT');
2195: okc_debug.log('8800: Entered lock_row', 2);
2196: END IF;
2197:
2198: OPEN lock_csr(p_okc_std_articles_tl_rec);
2199: FETCH lock_csr INTO l_lock_var;
2200: l_row_notfound := lock_csr%NOTFOUND;
2201: CLOSE lock_csr;
2202:

Line 2300: l_okc_std_articles_tl_rec okc_std_articles_tl_rec_type;

2296: l_api_version CONSTANT NUMBER := 1;
2297: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
2298: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2299: l_sae_rec sae_rec_type;
2300: l_okc_std_articles_tl_rec okc_std_articles_tl_rec_type;
2301: BEGIN
2302:
2303: IF (l_debug = 'Y') THEN
2304: okc_debug.Set_Indentation('OKC_SAE_PVT');

Line 2324: migrate(p_saev_rec, l_okc_std_articles_tl_rec);

2320: --------------------------------------
2321: -- Move VIEW record to "Child" records
2322: --------------------------------------
2323: migrate(p_saev_rec, l_sae_rec);
2324: migrate(p_saev_rec, l_okc_std_articles_tl_rec);
2325: --------------------------------------------
2326: -- Call the LOCK_ROW for each child record
2327: --------------------------------------------
2328: lock_row(

Line 2345: l_okc_std_articles_tl_rec

2341: p_init_msg_list,
2342: x_return_status,
2343: x_msg_count,
2344: x_msg_data,
2345: l_okc_std_articles_tl_rec
2346: );
2347: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2348: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2349: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2786: -- update_row for:OKC_STD_ARTICLES_TL --

2782:
2783:
2784: END update_row;
2785: ----------------------------------------
2786: -- update_row for:OKC_STD_ARTICLES_TL --
2787: ----------------------------------------
2788: PROCEDURE update_row(
2789: p_init_msg_list IN VARCHAR2 ,
2790: x_return_status OUT NOCOPY VARCHAR2,

Line 2793: p_okc_std_articles_tl_rec IN okc_std_articles_tl_rec_type,

2789: p_init_msg_list IN VARCHAR2 ,
2790: x_return_status OUT NOCOPY VARCHAR2,
2791: x_msg_count OUT NOCOPY NUMBER,
2792: x_msg_data OUT NOCOPY VARCHAR2,
2793: p_okc_std_articles_tl_rec IN okc_std_articles_tl_rec_type,
2794: x_okc_std_articles_tl_rec OUT NOCOPY okc_std_articles_tl_rec_type) IS
2795:
2796: l_api_version CONSTANT NUMBER := 1;
2797: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';

Line 2794: x_okc_std_articles_tl_rec OUT NOCOPY okc_std_articles_tl_rec_type) IS

2790: x_return_status OUT NOCOPY VARCHAR2,
2791: x_msg_count OUT NOCOPY NUMBER,
2792: x_msg_data OUT NOCOPY VARCHAR2,
2793: p_okc_std_articles_tl_rec IN okc_std_articles_tl_rec_type,
2794: x_okc_std_articles_tl_rec OUT NOCOPY okc_std_articles_tl_rec_type) IS
2795:
2796: l_api_version CONSTANT NUMBER := 1;
2797: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2798: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2799: l_okc_std_articles_tl_rec okc_std_articles_tl_rec_type := p_okc_std_articles_tl_rec;

2795:
2796: l_api_version CONSTANT NUMBER := 1;
2797: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2798: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2799: l_okc_std_articles_tl_rec okc_std_articles_tl_rec_type := p_okc_std_articles_tl_rec;
2800: ldefokcstdarticlestlrec okc_std_articles_tl_rec_type;
2801: l_row_notfound BOOLEAN := TRUE;
2802: ----------------------------------
2803: -- FUNCTION populate_new_record --

Line 2800: ldefokcstdarticlestlrec okc_std_articles_tl_rec_type;

2796: l_api_version CONSTANT NUMBER := 1;
2797: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2798: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2799: l_okc_std_articles_tl_rec okc_std_articles_tl_rec_type := p_okc_std_articles_tl_rec;
2800: ldefokcstdarticlestlrec okc_std_articles_tl_rec_type;
2801: l_row_notfound BOOLEAN := TRUE;
2802: ----------------------------------
2803: -- FUNCTION populate_new_record --
2804: ----------------------------------

Line 2806: p_okc_std_articles_tl_rec IN okc_std_articles_tl_rec_type,

2802: ----------------------------------
2803: -- FUNCTION populate_new_record --
2804: ----------------------------------
2805: FUNCTION populate_new_record (
2806: p_okc_std_articles_tl_rec IN okc_std_articles_tl_rec_type,
2807: x_okc_std_articles_tl_rec OUT NOCOPY okc_std_articles_tl_rec_type
2808: ) RETURN VARCHAR2 IS
2809: l_okc_std_articles_tl_rec okc_std_articles_tl_rec_type;
2810: l_row_notfound BOOLEAN := TRUE;

Line 2807: x_okc_std_articles_tl_rec OUT NOCOPY okc_std_articles_tl_rec_type

2803: -- FUNCTION populate_new_record --
2804: ----------------------------------
2805: FUNCTION populate_new_record (
2806: p_okc_std_articles_tl_rec IN okc_std_articles_tl_rec_type,
2807: x_okc_std_articles_tl_rec OUT NOCOPY okc_std_articles_tl_rec_type
2808: ) RETURN VARCHAR2 IS
2809: l_okc_std_articles_tl_rec okc_std_articles_tl_rec_type;
2810: l_row_notfound BOOLEAN := TRUE;
2811: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2809: l_okc_std_articles_tl_rec okc_std_articles_tl_rec_type;

2805: FUNCTION populate_new_record (
2806: p_okc_std_articles_tl_rec IN okc_std_articles_tl_rec_type,
2807: x_okc_std_articles_tl_rec OUT NOCOPY okc_std_articles_tl_rec_type
2808: ) RETURN VARCHAR2 IS
2809: l_okc_std_articles_tl_rec okc_std_articles_tl_rec_type;
2810: l_row_notfound BOOLEAN := TRUE;
2811: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2812: BEGIN
2813:

Line 2819: x_okc_std_articles_tl_rec := p_okc_std_articles_tl_rec;

2815: okc_debug.Set_Indentation('OKC_SAE_PVT');
2816: okc_debug.log('11200: Entered populate_new_record', 2);
2817: END IF;
2818:
2819: x_okc_std_articles_tl_rec := p_okc_std_articles_tl_rec;
2820: -- Get current database values
2821: l_okc_std_articles_tl_rec := get_rec(p_okc_std_articles_tl_rec, l_row_notfound);
2822: IF (l_row_notfound) THEN
2823: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

Line 2821: l_okc_std_articles_tl_rec := get_rec(p_okc_std_articles_tl_rec, l_row_notfound);

2817: END IF;
2818:
2819: x_okc_std_articles_tl_rec := p_okc_std_articles_tl_rec;
2820: -- Get current database values
2821: l_okc_std_articles_tl_rec := get_rec(p_okc_std_articles_tl_rec, l_row_notfound);
2822: IF (l_row_notfound) THEN
2823: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2824: END IF;
2825: IF (x_okc_std_articles_tl_rec.id = OKC_API.G_MISS_NUM)

Line 2825: IF (x_okc_std_articles_tl_rec.id = OKC_API.G_MISS_NUM)

2821: l_okc_std_articles_tl_rec := get_rec(p_okc_std_articles_tl_rec, l_row_notfound);
2822: IF (l_row_notfound) THEN
2823: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2824: END IF;
2825: IF (x_okc_std_articles_tl_rec.id = OKC_API.G_MISS_NUM)
2826: THEN
2827: x_okc_std_articles_tl_rec.id := l_okc_std_articles_tl_rec.id;
2828: END IF;
2829: IF (x_okc_std_articles_tl_rec.language = OKC_API.G_MISS_CHAR)

Line 2827: x_okc_std_articles_tl_rec.id := l_okc_std_articles_tl_rec.id;

2823: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2824: END IF;
2825: IF (x_okc_std_articles_tl_rec.id = OKC_API.G_MISS_NUM)
2826: THEN
2827: x_okc_std_articles_tl_rec.id := l_okc_std_articles_tl_rec.id;
2828: END IF;
2829: IF (x_okc_std_articles_tl_rec.language = OKC_API.G_MISS_CHAR)
2830: THEN
2831: x_okc_std_articles_tl_rec.language := l_okc_std_articles_tl_rec.language;

Line 2829: IF (x_okc_std_articles_tl_rec.language = OKC_API.G_MISS_CHAR)

2825: IF (x_okc_std_articles_tl_rec.id = OKC_API.G_MISS_NUM)
2826: THEN
2827: x_okc_std_articles_tl_rec.id := l_okc_std_articles_tl_rec.id;
2828: END IF;
2829: IF (x_okc_std_articles_tl_rec.language = OKC_API.G_MISS_CHAR)
2830: THEN
2831: x_okc_std_articles_tl_rec.language := l_okc_std_articles_tl_rec.language;
2832: END IF;
2833: IF (x_okc_std_articles_tl_rec.source_lang = OKC_API.G_MISS_CHAR)

Line 2831: x_okc_std_articles_tl_rec.language := l_okc_std_articles_tl_rec.language;

2827: x_okc_std_articles_tl_rec.id := l_okc_std_articles_tl_rec.id;
2828: END IF;
2829: IF (x_okc_std_articles_tl_rec.language = OKC_API.G_MISS_CHAR)
2830: THEN
2831: x_okc_std_articles_tl_rec.language := l_okc_std_articles_tl_rec.language;
2832: END IF;
2833: IF (x_okc_std_articles_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2834: THEN
2835: x_okc_std_articles_tl_rec.source_lang := l_okc_std_articles_tl_rec.source_lang;

Line 2833: IF (x_okc_std_articles_tl_rec.source_lang = OKC_API.G_MISS_CHAR)

2829: IF (x_okc_std_articles_tl_rec.language = OKC_API.G_MISS_CHAR)
2830: THEN
2831: x_okc_std_articles_tl_rec.language := l_okc_std_articles_tl_rec.language;
2832: END IF;
2833: IF (x_okc_std_articles_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2834: THEN
2835: x_okc_std_articles_tl_rec.source_lang := l_okc_std_articles_tl_rec.source_lang;
2836: END IF;
2837: IF (x_okc_std_articles_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)

Line 2835: x_okc_std_articles_tl_rec.source_lang := l_okc_std_articles_tl_rec.source_lang;

2831: x_okc_std_articles_tl_rec.language := l_okc_std_articles_tl_rec.language;
2832: END IF;
2833: IF (x_okc_std_articles_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2834: THEN
2835: x_okc_std_articles_tl_rec.source_lang := l_okc_std_articles_tl_rec.source_lang;
2836: END IF;
2837: IF (x_okc_std_articles_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2838: THEN
2839: x_okc_std_articles_tl_rec.sfwt_flag := l_okc_std_articles_tl_rec.sfwt_flag;

Line 2837: IF (x_okc_std_articles_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)

2833: IF (x_okc_std_articles_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2834: THEN
2835: x_okc_std_articles_tl_rec.source_lang := l_okc_std_articles_tl_rec.source_lang;
2836: END IF;
2837: IF (x_okc_std_articles_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2838: THEN
2839: x_okc_std_articles_tl_rec.sfwt_flag := l_okc_std_articles_tl_rec.sfwt_flag;
2840: END IF;
2841: IF (x_okc_std_articles_tl_rec.name = OKC_API.G_MISS_CHAR)

Line 2839: x_okc_std_articles_tl_rec.sfwt_flag := l_okc_std_articles_tl_rec.sfwt_flag;

2835: x_okc_std_articles_tl_rec.source_lang := l_okc_std_articles_tl_rec.source_lang;
2836: END IF;
2837: IF (x_okc_std_articles_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2838: THEN
2839: x_okc_std_articles_tl_rec.sfwt_flag := l_okc_std_articles_tl_rec.sfwt_flag;
2840: END IF;
2841: IF (x_okc_std_articles_tl_rec.name = OKC_API.G_MISS_CHAR)
2842: THEN
2843: x_okc_std_articles_tl_rec.name := l_okc_std_articles_tl_rec.name;

Line 2841: IF (x_okc_std_articles_tl_rec.name = OKC_API.G_MISS_CHAR)

2837: IF (x_okc_std_articles_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2838: THEN
2839: x_okc_std_articles_tl_rec.sfwt_flag := l_okc_std_articles_tl_rec.sfwt_flag;
2840: END IF;
2841: IF (x_okc_std_articles_tl_rec.name = OKC_API.G_MISS_CHAR)
2842: THEN
2843: x_okc_std_articles_tl_rec.name := l_okc_std_articles_tl_rec.name;
2844: END IF;
2845: IF (x_okc_std_articles_tl_rec.created_by = OKC_API.G_MISS_NUM)

Line 2843: x_okc_std_articles_tl_rec.name := l_okc_std_articles_tl_rec.name;

2839: x_okc_std_articles_tl_rec.sfwt_flag := l_okc_std_articles_tl_rec.sfwt_flag;
2840: END IF;
2841: IF (x_okc_std_articles_tl_rec.name = OKC_API.G_MISS_CHAR)
2842: THEN
2843: x_okc_std_articles_tl_rec.name := l_okc_std_articles_tl_rec.name;
2844: END IF;
2845: IF (x_okc_std_articles_tl_rec.created_by = OKC_API.G_MISS_NUM)
2846: THEN
2847: x_okc_std_articles_tl_rec.created_by := l_okc_std_articles_tl_rec.created_by;

Line 2845: IF (x_okc_std_articles_tl_rec.created_by = OKC_API.G_MISS_NUM)

2841: IF (x_okc_std_articles_tl_rec.name = OKC_API.G_MISS_CHAR)
2842: THEN
2843: x_okc_std_articles_tl_rec.name := l_okc_std_articles_tl_rec.name;
2844: END IF;
2845: IF (x_okc_std_articles_tl_rec.created_by = OKC_API.G_MISS_NUM)
2846: THEN
2847: x_okc_std_articles_tl_rec.created_by := l_okc_std_articles_tl_rec.created_by;
2848: END IF;
2849: IF (x_okc_std_articles_tl_rec.creation_date = OKC_API.G_MISS_DATE)

Line 2847: x_okc_std_articles_tl_rec.created_by := l_okc_std_articles_tl_rec.created_by;

2843: x_okc_std_articles_tl_rec.name := l_okc_std_articles_tl_rec.name;
2844: END IF;
2845: IF (x_okc_std_articles_tl_rec.created_by = OKC_API.G_MISS_NUM)
2846: THEN
2847: x_okc_std_articles_tl_rec.created_by := l_okc_std_articles_tl_rec.created_by;
2848: END IF;
2849: IF (x_okc_std_articles_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2850: THEN
2851: x_okc_std_articles_tl_rec.creation_date := l_okc_std_articles_tl_rec.creation_date;

Line 2849: IF (x_okc_std_articles_tl_rec.creation_date = OKC_API.G_MISS_DATE)

2845: IF (x_okc_std_articles_tl_rec.created_by = OKC_API.G_MISS_NUM)
2846: THEN
2847: x_okc_std_articles_tl_rec.created_by := l_okc_std_articles_tl_rec.created_by;
2848: END IF;
2849: IF (x_okc_std_articles_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2850: THEN
2851: x_okc_std_articles_tl_rec.creation_date := l_okc_std_articles_tl_rec.creation_date;
2852: END IF;
2853: IF (x_okc_std_articles_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)

Line 2851: x_okc_std_articles_tl_rec.creation_date := l_okc_std_articles_tl_rec.creation_date;

2847: x_okc_std_articles_tl_rec.created_by := l_okc_std_articles_tl_rec.created_by;
2848: END IF;
2849: IF (x_okc_std_articles_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2850: THEN
2851: x_okc_std_articles_tl_rec.creation_date := l_okc_std_articles_tl_rec.creation_date;
2852: END IF;
2853: IF (x_okc_std_articles_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2854: THEN
2855: x_okc_std_articles_tl_rec.last_updated_by := l_okc_std_articles_tl_rec.last_updated_by;

Line 2853: IF (x_okc_std_articles_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)

2849: IF (x_okc_std_articles_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2850: THEN
2851: x_okc_std_articles_tl_rec.creation_date := l_okc_std_articles_tl_rec.creation_date;
2852: END IF;
2853: IF (x_okc_std_articles_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2854: THEN
2855: x_okc_std_articles_tl_rec.last_updated_by := l_okc_std_articles_tl_rec.last_updated_by;
2856: END IF;
2857: IF (x_okc_std_articles_tl_rec.last_update_date = OKC_API.G_MISS_DATE)

Line 2855: x_okc_std_articles_tl_rec.last_updated_by := l_okc_std_articles_tl_rec.last_updated_by;

2851: x_okc_std_articles_tl_rec.creation_date := l_okc_std_articles_tl_rec.creation_date;
2852: END IF;
2853: IF (x_okc_std_articles_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2854: THEN
2855: x_okc_std_articles_tl_rec.last_updated_by := l_okc_std_articles_tl_rec.last_updated_by;
2856: END IF;
2857: IF (x_okc_std_articles_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2858: THEN
2859: x_okc_std_articles_tl_rec.last_update_date := l_okc_std_articles_tl_rec.last_update_date;

Line 2857: IF (x_okc_std_articles_tl_rec.last_update_date = OKC_API.G_MISS_DATE)

2853: IF (x_okc_std_articles_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2854: THEN
2855: x_okc_std_articles_tl_rec.last_updated_by := l_okc_std_articles_tl_rec.last_updated_by;
2856: END IF;
2857: IF (x_okc_std_articles_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2858: THEN
2859: x_okc_std_articles_tl_rec.last_update_date := l_okc_std_articles_tl_rec.last_update_date;
2860: END IF;
2861: IF (x_okc_std_articles_tl_rec.last_update_login = OKC_API.G_MISS_NUM)

Line 2859: x_okc_std_articles_tl_rec.last_update_date := l_okc_std_articles_tl_rec.last_update_date;

2855: x_okc_std_articles_tl_rec.last_updated_by := l_okc_std_articles_tl_rec.last_updated_by;
2856: END IF;
2857: IF (x_okc_std_articles_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2858: THEN
2859: x_okc_std_articles_tl_rec.last_update_date := l_okc_std_articles_tl_rec.last_update_date;
2860: END IF;
2861: IF (x_okc_std_articles_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
2862: THEN
2863: x_okc_std_articles_tl_rec.last_update_login := l_okc_std_articles_tl_rec.last_update_login;

Line 2861: IF (x_okc_std_articles_tl_rec.last_update_login = OKC_API.G_MISS_NUM)

2857: IF (x_okc_std_articles_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2858: THEN
2859: x_okc_std_articles_tl_rec.last_update_date := l_okc_std_articles_tl_rec.last_update_date;
2860: END IF;
2861: IF (x_okc_std_articles_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
2862: THEN
2863: x_okc_std_articles_tl_rec.last_update_login := l_okc_std_articles_tl_rec.last_update_login;
2864: END IF;
2865:

Line 2863: x_okc_std_articles_tl_rec.last_update_login := l_okc_std_articles_tl_rec.last_update_login;

2859: x_okc_std_articles_tl_rec.last_update_date := l_okc_std_articles_tl_rec.last_update_date;
2860: END IF;
2861: IF (x_okc_std_articles_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
2862: THEN
2863: x_okc_std_articles_tl_rec.last_update_login := l_okc_std_articles_tl_rec.last_update_login;
2864: END IF;
2865:
2866: IF (l_debug = 'Y') THEN
2867: okc_debug.log('11250: Leaving populate_new_record ', 2);

Line 2875: -- Set_Attributes for:OKC_STD_ARTICLES_TL --

2871: RETURN(l_return_status);
2872:
2873: END populate_new_record;
2874: --------------------------------------------
2875: -- Set_Attributes for:OKC_STD_ARTICLES_TL --
2876: --------------------------------------------
2877: FUNCTION Set_Attributes (
2878: p_okc_std_articles_tl_rec IN okc_std_articles_tl_rec_type,
2879: x_okc_std_articles_tl_rec OUT NOCOPY okc_std_articles_tl_rec_type

Line 2878: p_okc_std_articles_tl_rec IN okc_std_articles_tl_rec_type,

2874: --------------------------------------------
2875: -- Set_Attributes for:OKC_STD_ARTICLES_TL --
2876: --------------------------------------------
2877: FUNCTION Set_Attributes (
2878: p_okc_std_articles_tl_rec IN okc_std_articles_tl_rec_type,
2879: x_okc_std_articles_tl_rec OUT NOCOPY okc_std_articles_tl_rec_type
2880: ) RETURN VARCHAR2 IS
2881: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2882: BEGIN

Line 2879: x_okc_std_articles_tl_rec OUT NOCOPY okc_std_articles_tl_rec_type

2875: -- Set_Attributes for:OKC_STD_ARTICLES_TL --
2876: --------------------------------------------
2877: FUNCTION Set_Attributes (
2878: p_okc_std_articles_tl_rec IN okc_std_articles_tl_rec_type,
2879: x_okc_std_articles_tl_rec OUT NOCOPY okc_std_articles_tl_rec_type
2880: ) RETURN VARCHAR2 IS
2881: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2882: BEGIN
2883:

Line 2884: x_okc_std_articles_tl_rec := p_okc_std_articles_tl_rec;

2880: ) RETURN VARCHAR2 IS
2881: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2882: BEGIN
2883:
2884: x_okc_std_articles_tl_rec := p_okc_std_articles_tl_rec;
2885: x_okc_std_articles_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
2886: --x_okc_std_articles_tl_rec.LANGUAGE := USERENV('LANG');
2887: --x_okc_std_articles_tl_rec.SOURCE_LANG := USERENV('LANG');
2888: x_okc_std_articles_tl_rec.SOURCE_LANG :=okc_util.get_userenv_lang;

Line 2885: x_okc_std_articles_tl_rec.LANGUAGE := okc_util.get_userenv_lang;

2881: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2882: BEGIN
2883:
2884: x_okc_std_articles_tl_rec := p_okc_std_articles_tl_rec;
2885: x_okc_std_articles_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
2886: --x_okc_std_articles_tl_rec.LANGUAGE := USERENV('LANG');
2887: --x_okc_std_articles_tl_rec.SOURCE_LANG := USERENV('LANG');
2888: x_okc_std_articles_tl_rec.SOURCE_LANG :=okc_util.get_userenv_lang;
2889: RETURN(l_return_status);

Line 2886: --x_okc_std_articles_tl_rec.LANGUAGE := USERENV('LANG');

2882: BEGIN
2883:
2884: x_okc_std_articles_tl_rec := p_okc_std_articles_tl_rec;
2885: x_okc_std_articles_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
2886: --x_okc_std_articles_tl_rec.LANGUAGE := USERENV('LANG');
2887: --x_okc_std_articles_tl_rec.SOURCE_LANG := USERENV('LANG');
2888: x_okc_std_articles_tl_rec.SOURCE_LANG :=okc_util.get_userenv_lang;
2889: RETURN(l_return_status);
2890:

Line 2887: --x_okc_std_articles_tl_rec.SOURCE_LANG := USERENV('LANG');

2883:
2884: x_okc_std_articles_tl_rec := p_okc_std_articles_tl_rec;
2885: x_okc_std_articles_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
2886: --x_okc_std_articles_tl_rec.LANGUAGE := USERENV('LANG');
2887: --x_okc_std_articles_tl_rec.SOURCE_LANG := USERENV('LANG');
2888: x_okc_std_articles_tl_rec.SOURCE_LANG :=okc_util.get_userenv_lang;
2889: RETURN(l_return_status);
2890:
2891: END Set_Attributes;

Line 2888: x_okc_std_articles_tl_rec.SOURCE_LANG :=okc_util.get_userenv_lang;

2884: x_okc_std_articles_tl_rec := p_okc_std_articles_tl_rec;
2885: x_okc_std_articles_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
2886: --x_okc_std_articles_tl_rec.LANGUAGE := USERENV('LANG');
2887: --x_okc_std_articles_tl_rec.SOURCE_LANG := USERENV('LANG');
2888: x_okc_std_articles_tl_rec.SOURCE_LANG :=okc_util.get_userenv_lang;
2889: RETURN(l_return_status);
2890:
2891: END Set_Attributes;
2892: BEGIN

Line 2910: p_okc_std_articles_tl_rec, -- IN

2906: RAISE OKC_API.G_EXCEPTION_ERROR;
2907: END IF;
2908: --- Setting item attributes
2909: l_return_status := Set_Attributes(
2910: p_okc_std_articles_tl_rec, -- IN
2911: l_okc_std_articles_tl_rec); -- OUT
2912: --- If any errors happen abort API
2913: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2914: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2911: l_okc_std_articles_tl_rec); -- OUT

2907: END IF;
2908: --- Setting item attributes
2909: l_return_status := Set_Attributes(
2910: p_okc_std_articles_tl_rec, -- IN
2911: l_okc_std_articles_tl_rec); -- OUT
2912: --- If any errors happen abort API
2913: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2914: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2915: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2918: l_return_status := populate_new_record(l_okc_std_articles_tl_rec, ldefokcstdarticlestlrec);

2914: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2915: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2916: RAISE OKC_API.G_EXCEPTION_ERROR;
2917: END IF;
2918: l_return_status := populate_new_record(l_okc_std_articles_tl_rec, ldefokcstdarticlestlrec);
2919: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2920: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2921: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2922: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 2924: UPDATE OKC_STD_ARTICLES_TL

2920: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2921: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2922: RAISE OKC_API.G_EXCEPTION_ERROR;
2923: END IF;
2924: UPDATE OKC_STD_ARTICLES_TL
2925: SET NAME = ldefokcstdarticlestlrec.name,
2926: CREATED_BY = ldefokcstdarticlestlrec.created_by,
2927: CREATION_DATE = ldefokcstdarticlestlrec.creation_date,
2928: LAST_UPDATED_BY = ldefokcstdarticlestlrec.last_updated_by,

Line 2940: UPDATE OKC_STD_ARTICLES_TL

2936: --AND SOURCE_LANG = USERENV('LANG');
2937: AND USERENV('LANG') IN (SOURCE_LANG,LANGUAGE);
2938:
2939:
2940: UPDATE OKC_STD_ARTICLES_TL
2941: SET SFWT_FLAG = 'Y'
2942: WHERE ID = ldefokcstdarticlestlrec.id
2943: AND SOURCE_LANG <> USERENV('LANG');
2944:

Line 2945: x_okc_std_articles_tl_rec := ldefokcstdarticlestlrec;

2941: SET SFWT_FLAG = 'Y'
2942: WHERE ID = ldefokcstdarticlestlrec.id
2943: AND SOURCE_LANG <> USERENV('LANG');
2944:
2945: x_okc_std_articles_tl_rec := ldefokcstdarticlestlrec;
2946: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2947:
2948: IF (l_debug = 'Y') THEN
2949: okc_debug.log('11500: Leaving update_row', 2);

Line 3021: l_okc_std_articles_tl_rec okc_std_articles_tl_rec_type;

3017: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
3018: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3019: l_saev_rec saev_rec_type := p_saev_rec;
3020: l_def_saev_rec saev_rec_type;
3021: l_okc_std_articles_tl_rec okc_std_articles_tl_rec_type;
3022: lx_okc_std_articles_tl_rec okc_std_articles_tl_rec_type;
3023: l_sae_rec sae_rec_type;
3024: lx_sae_rec sae_rec_type;
3025: -------------------------------

Line 3022: lx_okc_std_articles_tl_rec okc_std_articles_tl_rec_type;

3018: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3019: l_saev_rec saev_rec_type := p_saev_rec;
3020: l_def_saev_rec saev_rec_type;
3021: l_okc_std_articles_tl_rec okc_std_articles_tl_rec_type;
3022: lx_okc_std_articles_tl_rec okc_std_articles_tl_rec_type;
3023: l_sae_rec sae_rec_type;
3024: lx_sae_rec sae_rec_type;
3025: -------------------------------
3026: -- FUNCTION fill_who_columns --

Line 3251: migrate(l_def_saev_rec, l_okc_std_articles_tl_rec);

3247:
3248: --------------------------------------
3249: -- Move VIEW record to "Child" records
3250: --------------------------------------
3251: migrate(l_def_saev_rec, l_okc_std_articles_tl_rec);
3252: migrate(l_def_saev_rec, l_sae_rec);
3253: --------------------------------------------
3254: -- Call the UPDATE_ROW for each child record
3255: --------------------------------------------

Line 3261: l_okc_std_articles_tl_rec,

3257: p_init_msg_list,
3258: x_return_status,
3259: x_msg_count,
3260: x_msg_data,
3261: l_okc_std_articles_tl_rec,
3262: lx_okc_std_articles_tl_rec
3263: );
3264: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3265: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3262: lx_okc_std_articles_tl_rec

3258: x_return_status,
3259: x_msg_count,
3260: x_msg_data,
3261: l_okc_std_articles_tl_rec,
3262: lx_okc_std_articles_tl_rec
3263: );
3264: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3265: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3266: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 3269: migrate(lx_okc_std_articles_tl_rec, l_def_saev_rec);

3265: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3266: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3267: RAISE OKC_API.G_EXCEPTION_ERROR;
3268: END IF;
3269: migrate(lx_okc_std_articles_tl_rec, l_def_saev_rec);
3270: update_row(
3271: p_init_msg_list,
3272: x_return_status,
3273: x_msg_count,

Line 3537: -- delete_row for:OKC_STD_ARTICLES_TL --

3533: );
3534:
3535: END delete_row;
3536: ----------------------------------------
3537: -- delete_row for:OKC_STD_ARTICLES_TL --
3538: ----------------------------------------
3539: PROCEDURE delete_row(
3540: p_init_msg_list IN VARCHAR2 ,
3541: x_return_status OUT NOCOPY VARCHAR2,

Line 3544: p_okc_std_articles_tl_rec IN okc_std_articles_tl_rec_type) IS

3540: p_init_msg_list IN VARCHAR2 ,
3541: x_return_status OUT NOCOPY VARCHAR2,
3542: x_msg_count OUT NOCOPY NUMBER,
3543: x_msg_data OUT NOCOPY VARCHAR2,
3544: p_okc_std_articles_tl_rec IN okc_std_articles_tl_rec_type) IS
3545:
3546: l_api_version CONSTANT NUMBER := 1;
3547: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3548: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 3549: l_okc_std_articles_tl_rec okc_std_articles_tl_rec_type:= p_okc_std_articles_tl_rec;

3545:
3546: l_api_version CONSTANT NUMBER := 1;
3547: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3548: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3549: l_okc_std_articles_tl_rec okc_std_articles_tl_rec_type:= p_okc_std_articles_tl_rec;
3550: l_row_notfound BOOLEAN := TRUE;
3551: --------------------------------------------
3552: -- Set_Attributes for:OKC_STD_ARTICLES_TL --
3553: --------------------------------------------

Line 3552: -- Set_Attributes for:OKC_STD_ARTICLES_TL --

3548: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3549: l_okc_std_articles_tl_rec okc_std_articles_tl_rec_type:= p_okc_std_articles_tl_rec;
3550: l_row_notfound BOOLEAN := TRUE;
3551: --------------------------------------------
3552: -- Set_Attributes for:OKC_STD_ARTICLES_TL --
3553: --------------------------------------------
3554: FUNCTION Set_Attributes (
3555: p_okc_std_articles_tl_rec IN okc_std_articles_tl_rec_type,
3556: x_okc_std_articles_tl_rec OUT NOCOPY okc_std_articles_tl_rec_type

Line 3555: p_okc_std_articles_tl_rec IN okc_std_articles_tl_rec_type,

3551: --------------------------------------------
3552: -- Set_Attributes for:OKC_STD_ARTICLES_TL --
3553: --------------------------------------------
3554: FUNCTION Set_Attributes (
3555: p_okc_std_articles_tl_rec IN okc_std_articles_tl_rec_type,
3556: x_okc_std_articles_tl_rec OUT NOCOPY okc_std_articles_tl_rec_type
3557: ) RETURN VARCHAR2 IS
3558: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3559: BEGIN

Line 3556: x_okc_std_articles_tl_rec OUT NOCOPY okc_std_articles_tl_rec_type

3552: -- Set_Attributes for:OKC_STD_ARTICLES_TL --
3553: --------------------------------------------
3554: FUNCTION Set_Attributes (
3555: p_okc_std_articles_tl_rec IN okc_std_articles_tl_rec_type,
3556: x_okc_std_articles_tl_rec OUT NOCOPY okc_std_articles_tl_rec_type
3557: ) RETURN VARCHAR2 IS
3558: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3559: BEGIN
3560:

Line 3566: x_okc_std_articles_tl_rec := p_okc_std_articles_tl_rec;

3562: okc_debug.Set_Indentation('OKC_SAE_PVT');
3563: okc_debug.log('13700: Entered Set_Attributes', 2);
3564: END IF;
3565:
3566: x_okc_std_articles_tl_rec := p_okc_std_articles_tl_rec;
3567: --x_okc_std_articles_tl_rec.LANGUAGE := USERENV('LANG');
3568: x_okc_std_articles_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
3569: RETURN(l_return_status);
3570:

Line 3567: --x_okc_std_articles_tl_rec.LANGUAGE := USERENV('LANG');

3563: okc_debug.log('13700: Entered Set_Attributes', 2);
3564: END IF;
3565:
3566: x_okc_std_articles_tl_rec := p_okc_std_articles_tl_rec;
3567: --x_okc_std_articles_tl_rec.LANGUAGE := USERENV('LANG');
3568: x_okc_std_articles_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
3569: RETURN(l_return_status);
3570:
3571: END Set_Attributes;

Line 3568: x_okc_std_articles_tl_rec.LANGUAGE := okc_util.get_userenv_lang;

3564: END IF;
3565:
3566: x_okc_std_articles_tl_rec := p_okc_std_articles_tl_rec;
3567: --x_okc_std_articles_tl_rec.LANGUAGE := USERENV('LANG');
3568: x_okc_std_articles_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
3569: RETURN(l_return_status);
3570:
3571: END Set_Attributes;
3572: BEGIN

Line 3590: p_okc_std_articles_tl_rec, -- IN

3586: RAISE OKC_API.G_EXCEPTION_ERROR;
3587: END IF;
3588: --- Setting item attributes
3589: l_return_status := Set_Attributes(
3590: p_okc_std_articles_tl_rec, -- IN
3591: l_okc_std_articles_tl_rec); -- OUT
3592: --- If any errors happen abort API
3593: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3594: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3591: l_okc_std_articles_tl_rec); -- OUT

3587: END IF;
3588: --- Setting item attributes
3589: l_return_status := Set_Attributes(
3590: p_okc_std_articles_tl_rec, -- IN
3591: l_okc_std_articles_tl_rec); -- OUT
3592: --- If any errors happen abort API
3593: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3594: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3595: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 3598: DELETE FROM OKC_STD_ARTICLES_TL

3594: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3595: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3596: RAISE OKC_API.G_EXCEPTION_ERROR;
3597: END IF;
3598: DELETE FROM OKC_STD_ARTICLES_TL
3599: WHERE ID = l_okc_std_articles_tl_rec.id;
3600:
3601: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3602:

Line 3599: WHERE ID = l_okc_std_articles_tl_rec.id;

3595: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3596: RAISE OKC_API.G_EXCEPTION_ERROR;
3597: END IF;
3598: DELETE FROM OKC_STD_ARTICLES_TL
3599: WHERE ID = l_okc_std_articles_tl_rec.id;
3600:
3601: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3602:
3603: IF (l_debug = 'Y') THEN

Line 3674: l_okc_std_articles_tl_rec okc_std_articles_tl_rec_type;

3670: l_api_version CONSTANT NUMBER := 1;
3671: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
3672: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3673: l_saev_rec saev_rec_type := p_saev_rec;
3674: l_okc_std_articles_tl_rec okc_std_articles_tl_rec_type;
3675: l_sae_rec sae_rec_type;
3676: BEGIN
3677:
3678: IF (l_debug = 'Y') THEN

Line 3698: migrate(l_saev_rec, l_okc_std_articles_tl_rec);

3694: END IF;
3695: --------------------------------------
3696: -- Move VIEW record to "Child" records
3697: --------------------------------------
3698: migrate(l_saev_rec, l_okc_std_articles_tl_rec);
3699: migrate(l_saev_rec, l_sae_rec);
3700: --------------------------------------------
3701: -- Call the DELETE_ROW for each child record
3702: --------------------------------------------

Line 3708: l_okc_std_articles_tl_rec

3704: p_init_msg_list,
3705: x_return_status,
3706: x_msg_count,
3707: x_msg_data,
3708: l_okc_std_articles_tl_rec
3709: );
3710: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3711: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3712: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN