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.OKL_CUV_PVT dependencies on OKL_CRTRN_USER_VALS_TL

Line 186: DELETE FROM OKL_CRTRN_USER_VALS_TL T

182: -- PROCEDURE add_language
183: ---------------------------------------------------------------------------
184: PROCEDURE add_language IS
185: BEGIN
186: DELETE FROM OKL_CRTRN_USER_VALS_TL T
187: WHERE NOT EXISTS (
188: SELECT NULL
189: FROM OKL_CRTRN_USER_VALS_B B --fixed bug 3321017 by kmotepal
190: WHERE B.ID = T.ID

Line 193: UPDATE OKL_CRTRN_USER_VALS_TL T SET (

189: FROM OKL_CRTRN_USER_VALS_B B --fixed bug 3321017 by kmotepal
190: WHERE B.ID = T.ID
191: );
192:
193: UPDATE OKL_CRTRN_USER_VALS_TL T SET (
194: DESCRIPTION) = (SELECT
195: B.DESCRIPTION
196: FROM OKL_CRTRN_USER_VALS_TL B
197: WHERE B.ID = T.ID

Line 196: FROM OKL_CRTRN_USER_VALS_TL B

192:
193: UPDATE OKL_CRTRN_USER_VALS_TL T SET (
194: DESCRIPTION) = (SELECT
195: B.DESCRIPTION
196: FROM OKL_CRTRN_USER_VALS_TL B
197: WHERE B.ID = T.ID
198: AND B.LANGUAGE = T.SOURCE_LANG)
199: WHERE (
200: T.ID,

Line 205: FROM OKL_CRTRN_USER_VALS_TL SUBB, OKL_CRTRN_USER_VALS_TL SUBT

201: T.LANGUAGE)
202: IN (SELECT
203: SUBT.ID,
204: SUBT.LANGUAGE
205: FROM OKL_CRTRN_USER_VALS_TL SUBB, OKL_CRTRN_USER_VALS_TL SUBT
206: WHERE SUBB.ID = SUBT.ID
207: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
208: AND (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
209: OR (SUBB.DESCRIPTION IS NULL AND SUBT.DESCRIPTION IS NOT NULL)

Line 213: INSERT INTO OKL_CRTRN_USER_VALS_TL (

209: OR (SUBB.DESCRIPTION IS NULL AND SUBT.DESCRIPTION IS NOT NULL)
210: OR (SUBB.DESCRIPTION IS NOT NULL AND SUBT.DESCRIPTION IS NULL)
211: ));
212:
213: INSERT INTO OKL_CRTRN_USER_VALS_TL (
214: ID,
215: LANGUAGE,
216: SOURCE_LANG,
217: SFWT_FLAG,

Line 235: FROM OKL_CRTRN_USER_VALS_TL B, FND_LANGUAGES L

231: B.CREATION_DATE,
232: B.LAST_UPDATED_BY,
233: B.LAST_UPDATE_DATE,
234: B.LAST_UPDATE_LOGIN
235: FROM OKL_CRTRN_USER_VALS_TL B, FND_LANGUAGES L
236: WHERE L.INSTALLED_FLAG IN ('I', 'B')
237: AND B.LANGUAGE = USERENV('LANG')
238: AND NOT EXISTS(
239: SELECT NULL

Line 240: FROM OKL_CRTRN_USER_VALS_TL T

236: WHERE L.INSTALLED_FLAG IN ('I', 'B')
237: AND B.LANGUAGE = USERENV('LANG')
238: AND NOT EXISTS(
239: SELECT NULL
240: FROM OKL_CRTRN_USER_VALS_TL T
241: WHERE T.ID = B.ID
242: AND T.LANGUAGE = L.LANGUAGE_CODE
243: );
244:

Line 330: -- FUNCTION get_rec for: OKL_CRTRN_USER_VALS_TL

326: BEGIN
327: RETURN(get_rec(p_cuv_rec, l_row_notfound));
328: END get_rec;
329: ---------------------------------------------------------------------------
330: -- FUNCTION get_rec for: OKL_CRTRN_USER_VALS_TL
331: ---------------------------------------------------------------------------
332: FUNCTION get_rec (
333: p_okl_crtrn_user_vals_tl_rec IN OklCrtrnUserValsTlRecType,
334: x_no_data_found OUT NOCOPY BOOLEAN

Line 333: p_okl_crtrn_user_vals_tl_rec IN OklCrtrnUserValsTlRecType,

329: ---------------------------------------------------------------------------
330: -- FUNCTION get_rec for: OKL_CRTRN_USER_VALS_TL
331: ---------------------------------------------------------------------------
332: FUNCTION get_rec (
333: p_okl_crtrn_user_vals_tl_rec IN OklCrtrnUserValsTlRecType,
334: x_no_data_found OUT NOCOPY BOOLEAN
335: ) RETURN OklCrtrnUserValsTlRecType IS
336: CURSOR okl_crtrn_user_vals_tl_pk_csr (p_id IN NUMBER,
337: p_language IN VARCHAR2) IS

Line 336: CURSOR okl_crtrn_user_vals_tl_pk_csr (p_id IN NUMBER,

332: FUNCTION get_rec (
333: p_okl_crtrn_user_vals_tl_rec IN OklCrtrnUserValsTlRecType,
334: x_no_data_found OUT NOCOPY BOOLEAN
335: ) RETURN OklCrtrnUserValsTlRecType IS
336: CURSOR okl_crtrn_user_vals_tl_pk_csr (p_id IN NUMBER,
337: p_language IN VARCHAR2) IS
338: SELECT
339: ID,
340: LANGUAGE,

Line 349: FROM Okl_Crtrn_User_Vals_Tl

345: CREATION_DATE,
346: LAST_UPDATED_BY,
347: LAST_UPDATE_DATE,
348: LAST_UPDATE_LOGIN
349: FROM Okl_Crtrn_User_Vals_Tl
350: WHERE okl_crtrn_user_vals_tl.id = p_id
351: AND okl_crtrn_user_vals_tl.LANGUAGE = p_language;
352: l_okl_crtrn_user_vals_tl_pk okl_crtrn_user_vals_tl_pk_csr%ROWTYPE;
353: l_okl_crtrn_user_vals_tl_rec OklCrtrnUserValsTlRecType;

Line 350: WHERE okl_crtrn_user_vals_tl.id = p_id

346: LAST_UPDATED_BY,
347: LAST_UPDATE_DATE,
348: LAST_UPDATE_LOGIN
349: FROM Okl_Crtrn_User_Vals_Tl
350: WHERE okl_crtrn_user_vals_tl.id = p_id
351: AND okl_crtrn_user_vals_tl.LANGUAGE = p_language;
352: l_okl_crtrn_user_vals_tl_pk okl_crtrn_user_vals_tl_pk_csr%ROWTYPE;
353: l_okl_crtrn_user_vals_tl_rec OklCrtrnUserValsTlRecType;
354: BEGIN

Line 351: AND okl_crtrn_user_vals_tl.LANGUAGE = p_language;

347: LAST_UPDATE_DATE,
348: LAST_UPDATE_LOGIN
349: FROM Okl_Crtrn_User_Vals_Tl
350: WHERE okl_crtrn_user_vals_tl.id = p_id
351: AND okl_crtrn_user_vals_tl.LANGUAGE = p_language;
352: l_okl_crtrn_user_vals_tl_pk okl_crtrn_user_vals_tl_pk_csr%ROWTYPE;
353: l_okl_crtrn_user_vals_tl_rec OklCrtrnUserValsTlRecType;
354: BEGIN
355: x_no_data_found := TRUE;

Line 352: l_okl_crtrn_user_vals_tl_pk okl_crtrn_user_vals_tl_pk_csr%ROWTYPE;

348: LAST_UPDATE_LOGIN
349: FROM Okl_Crtrn_User_Vals_Tl
350: WHERE okl_crtrn_user_vals_tl.id = p_id
351: AND okl_crtrn_user_vals_tl.LANGUAGE = p_language;
352: l_okl_crtrn_user_vals_tl_pk okl_crtrn_user_vals_tl_pk_csr%ROWTYPE;
353: l_okl_crtrn_user_vals_tl_rec OklCrtrnUserValsTlRecType;
354: BEGIN
355: x_no_data_found := TRUE;
356: -- Get current database values

Line 353: l_okl_crtrn_user_vals_tl_rec OklCrtrnUserValsTlRecType;

349: FROM Okl_Crtrn_User_Vals_Tl
350: WHERE okl_crtrn_user_vals_tl.id = p_id
351: AND okl_crtrn_user_vals_tl.LANGUAGE = p_language;
352: l_okl_crtrn_user_vals_tl_pk okl_crtrn_user_vals_tl_pk_csr%ROWTYPE;
353: l_okl_crtrn_user_vals_tl_rec OklCrtrnUserValsTlRecType;
354: BEGIN
355: x_no_data_found := TRUE;
356: -- Get current database values
357: OPEN okl_crtrn_user_vals_tl_pk_csr (p_okl_crtrn_user_vals_tl_rec.id,

Line 357: OPEN okl_crtrn_user_vals_tl_pk_csr (p_okl_crtrn_user_vals_tl_rec.id,

353: l_okl_crtrn_user_vals_tl_rec OklCrtrnUserValsTlRecType;
354: BEGIN
355: x_no_data_found := TRUE;
356: -- Get current database values
357: OPEN okl_crtrn_user_vals_tl_pk_csr (p_okl_crtrn_user_vals_tl_rec.id,
358: p_okl_crtrn_user_vals_tl_rec.LANGUAGE);
359: FETCH okl_crtrn_user_vals_tl_pk_csr INTO
360: l_okl_crtrn_user_vals_tl_rec.ID,
361: l_okl_crtrn_user_vals_tl_rec.LANGUAGE,

Line 358: p_okl_crtrn_user_vals_tl_rec.LANGUAGE);

354: BEGIN
355: x_no_data_found := TRUE;
356: -- Get current database values
357: OPEN okl_crtrn_user_vals_tl_pk_csr (p_okl_crtrn_user_vals_tl_rec.id,
358: p_okl_crtrn_user_vals_tl_rec.LANGUAGE);
359: FETCH okl_crtrn_user_vals_tl_pk_csr INTO
360: l_okl_crtrn_user_vals_tl_rec.ID,
361: l_okl_crtrn_user_vals_tl_rec.LANGUAGE,
362: l_okl_crtrn_user_vals_tl_rec.SOURCE_LANG,

Line 359: FETCH okl_crtrn_user_vals_tl_pk_csr INTO

355: x_no_data_found := TRUE;
356: -- Get current database values
357: OPEN okl_crtrn_user_vals_tl_pk_csr (p_okl_crtrn_user_vals_tl_rec.id,
358: p_okl_crtrn_user_vals_tl_rec.LANGUAGE);
359: FETCH okl_crtrn_user_vals_tl_pk_csr INTO
360: l_okl_crtrn_user_vals_tl_rec.ID,
361: l_okl_crtrn_user_vals_tl_rec.LANGUAGE,
362: l_okl_crtrn_user_vals_tl_rec.SOURCE_LANG,
363: l_okl_crtrn_user_vals_tl_rec.SFWT_FLAG,

Line 360: l_okl_crtrn_user_vals_tl_rec.ID,

356: -- Get current database values
357: OPEN okl_crtrn_user_vals_tl_pk_csr (p_okl_crtrn_user_vals_tl_rec.id,
358: p_okl_crtrn_user_vals_tl_rec.LANGUAGE);
359: FETCH okl_crtrn_user_vals_tl_pk_csr INTO
360: l_okl_crtrn_user_vals_tl_rec.ID,
361: l_okl_crtrn_user_vals_tl_rec.LANGUAGE,
362: l_okl_crtrn_user_vals_tl_rec.SOURCE_LANG,
363: l_okl_crtrn_user_vals_tl_rec.SFWT_FLAG,
364: l_okl_crtrn_user_vals_tl_rec.DESCRIPTION,

Line 361: l_okl_crtrn_user_vals_tl_rec.LANGUAGE,

357: OPEN okl_crtrn_user_vals_tl_pk_csr (p_okl_crtrn_user_vals_tl_rec.id,
358: p_okl_crtrn_user_vals_tl_rec.LANGUAGE);
359: FETCH okl_crtrn_user_vals_tl_pk_csr INTO
360: l_okl_crtrn_user_vals_tl_rec.ID,
361: l_okl_crtrn_user_vals_tl_rec.LANGUAGE,
362: l_okl_crtrn_user_vals_tl_rec.SOURCE_LANG,
363: l_okl_crtrn_user_vals_tl_rec.SFWT_FLAG,
364: l_okl_crtrn_user_vals_tl_rec.DESCRIPTION,
365: l_okl_crtrn_user_vals_tl_rec.CREATED_BY,

Line 362: l_okl_crtrn_user_vals_tl_rec.SOURCE_LANG,

358: p_okl_crtrn_user_vals_tl_rec.LANGUAGE);
359: FETCH okl_crtrn_user_vals_tl_pk_csr INTO
360: l_okl_crtrn_user_vals_tl_rec.ID,
361: l_okl_crtrn_user_vals_tl_rec.LANGUAGE,
362: l_okl_crtrn_user_vals_tl_rec.SOURCE_LANG,
363: l_okl_crtrn_user_vals_tl_rec.SFWT_FLAG,
364: l_okl_crtrn_user_vals_tl_rec.DESCRIPTION,
365: l_okl_crtrn_user_vals_tl_rec.CREATED_BY,
366: l_okl_crtrn_user_vals_tl_rec.CREATION_DATE,

Line 363: l_okl_crtrn_user_vals_tl_rec.SFWT_FLAG,

359: FETCH okl_crtrn_user_vals_tl_pk_csr INTO
360: l_okl_crtrn_user_vals_tl_rec.ID,
361: l_okl_crtrn_user_vals_tl_rec.LANGUAGE,
362: l_okl_crtrn_user_vals_tl_rec.SOURCE_LANG,
363: l_okl_crtrn_user_vals_tl_rec.SFWT_FLAG,
364: l_okl_crtrn_user_vals_tl_rec.DESCRIPTION,
365: l_okl_crtrn_user_vals_tl_rec.CREATED_BY,
366: l_okl_crtrn_user_vals_tl_rec.CREATION_DATE,
367: l_okl_crtrn_user_vals_tl_rec.LAST_UPDATED_BY,

Line 364: l_okl_crtrn_user_vals_tl_rec.DESCRIPTION,

360: l_okl_crtrn_user_vals_tl_rec.ID,
361: l_okl_crtrn_user_vals_tl_rec.LANGUAGE,
362: l_okl_crtrn_user_vals_tl_rec.SOURCE_LANG,
363: l_okl_crtrn_user_vals_tl_rec.SFWT_FLAG,
364: l_okl_crtrn_user_vals_tl_rec.DESCRIPTION,
365: l_okl_crtrn_user_vals_tl_rec.CREATED_BY,
366: l_okl_crtrn_user_vals_tl_rec.CREATION_DATE,
367: l_okl_crtrn_user_vals_tl_rec.LAST_UPDATED_BY,
368: l_okl_crtrn_user_vals_tl_rec.LAST_UPDATE_DATE,

Line 365: l_okl_crtrn_user_vals_tl_rec.CREATED_BY,

361: l_okl_crtrn_user_vals_tl_rec.LANGUAGE,
362: l_okl_crtrn_user_vals_tl_rec.SOURCE_LANG,
363: l_okl_crtrn_user_vals_tl_rec.SFWT_FLAG,
364: l_okl_crtrn_user_vals_tl_rec.DESCRIPTION,
365: l_okl_crtrn_user_vals_tl_rec.CREATED_BY,
366: l_okl_crtrn_user_vals_tl_rec.CREATION_DATE,
367: l_okl_crtrn_user_vals_tl_rec.LAST_UPDATED_BY,
368: l_okl_crtrn_user_vals_tl_rec.LAST_UPDATE_DATE,
369: l_okl_crtrn_user_vals_tl_rec.LAST_UPDATE_LOGIN;

Line 366: l_okl_crtrn_user_vals_tl_rec.CREATION_DATE,

362: l_okl_crtrn_user_vals_tl_rec.SOURCE_LANG,
363: l_okl_crtrn_user_vals_tl_rec.SFWT_FLAG,
364: l_okl_crtrn_user_vals_tl_rec.DESCRIPTION,
365: l_okl_crtrn_user_vals_tl_rec.CREATED_BY,
366: l_okl_crtrn_user_vals_tl_rec.CREATION_DATE,
367: l_okl_crtrn_user_vals_tl_rec.LAST_UPDATED_BY,
368: l_okl_crtrn_user_vals_tl_rec.LAST_UPDATE_DATE,
369: l_okl_crtrn_user_vals_tl_rec.LAST_UPDATE_LOGIN;
370: x_no_data_found := okl_crtrn_user_vals_tl_pk_csr%NOTFOUND;

Line 367: l_okl_crtrn_user_vals_tl_rec.LAST_UPDATED_BY,

363: l_okl_crtrn_user_vals_tl_rec.SFWT_FLAG,
364: l_okl_crtrn_user_vals_tl_rec.DESCRIPTION,
365: l_okl_crtrn_user_vals_tl_rec.CREATED_BY,
366: l_okl_crtrn_user_vals_tl_rec.CREATION_DATE,
367: l_okl_crtrn_user_vals_tl_rec.LAST_UPDATED_BY,
368: l_okl_crtrn_user_vals_tl_rec.LAST_UPDATE_DATE,
369: l_okl_crtrn_user_vals_tl_rec.LAST_UPDATE_LOGIN;
370: x_no_data_found := okl_crtrn_user_vals_tl_pk_csr%NOTFOUND;
371: CLOSE okl_crtrn_user_vals_tl_pk_csr;

Line 368: l_okl_crtrn_user_vals_tl_rec.LAST_UPDATE_DATE,

364: l_okl_crtrn_user_vals_tl_rec.DESCRIPTION,
365: l_okl_crtrn_user_vals_tl_rec.CREATED_BY,
366: l_okl_crtrn_user_vals_tl_rec.CREATION_DATE,
367: l_okl_crtrn_user_vals_tl_rec.LAST_UPDATED_BY,
368: l_okl_crtrn_user_vals_tl_rec.LAST_UPDATE_DATE,
369: l_okl_crtrn_user_vals_tl_rec.LAST_UPDATE_LOGIN;
370: x_no_data_found := okl_crtrn_user_vals_tl_pk_csr%NOTFOUND;
371: CLOSE okl_crtrn_user_vals_tl_pk_csr;
372: RETURN(l_okl_crtrn_user_vals_tl_rec);

Line 369: l_okl_crtrn_user_vals_tl_rec.LAST_UPDATE_LOGIN;

365: l_okl_crtrn_user_vals_tl_rec.CREATED_BY,
366: l_okl_crtrn_user_vals_tl_rec.CREATION_DATE,
367: l_okl_crtrn_user_vals_tl_rec.LAST_UPDATED_BY,
368: l_okl_crtrn_user_vals_tl_rec.LAST_UPDATE_DATE,
369: l_okl_crtrn_user_vals_tl_rec.LAST_UPDATE_LOGIN;
370: x_no_data_found := okl_crtrn_user_vals_tl_pk_csr%NOTFOUND;
371: CLOSE okl_crtrn_user_vals_tl_pk_csr;
372: RETURN(l_okl_crtrn_user_vals_tl_rec);
373: END get_rec;

Line 370: x_no_data_found := okl_crtrn_user_vals_tl_pk_csr%NOTFOUND;

366: l_okl_crtrn_user_vals_tl_rec.CREATION_DATE,
367: l_okl_crtrn_user_vals_tl_rec.LAST_UPDATED_BY,
368: l_okl_crtrn_user_vals_tl_rec.LAST_UPDATE_DATE,
369: l_okl_crtrn_user_vals_tl_rec.LAST_UPDATE_LOGIN;
370: x_no_data_found := okl_crtrn_user_vals_tl_pk_csr%NOTFOUND;
371: CLOSE okl_crtrn_user_vals_tl_pk_csr;
372: RETURN(l_okl_crtrn_user_vals_tl_rec);
373: END get_rec;
374:

Line 371: CLOSE okl_crtrn_user_vals_tl_pk_csr;

367: l_okl_crtrn_user_vals_tl_rec.LAST_UPDATED_BY,
368: l_okl_crtrn_user_vals_tl_rec.LAST_UPDATE_DATE,
369: l_okl_crtrn_user_vals_tl_rec.LAST_UPDATE_LOGIN;
370: x_no_data_found := okl_crtrn_user_vals_tl_pk_csr%NOTFOUND;
371: CLOSE okl_crtrn_user_vals_tl_pk_csr;
372: RETURN(l_okl_crtrn_user_vals_tl_rec);
373: END get_rec;
374:
375: FUNCTION get_rec (

Line 372: RETURN(l_okl_crtrn_user_vals_tl_rec);

368: l_okl_crtrn_user_vals_tl_rec.LAST_UPDATE_DATE,
369: l_okl_crtrn_user_vals_tl_rec.LAST_UPDATE_LOGIN;
370: x_no_data_found := okl_crtrn_user_vals_tl_pk_csr%NOTFOUND;
371: CLOSE okl_crtrn_user_vals_tl_pk_csr;
372: RETURN(l_okl_crtrn_user_vals_tl_rec);
373: END get_rec;
374:
375: FUNCTION get_rec (
376: p_okl_crtrn_user_vals_tl_rec IN OklCrtrnUserValsTlRecType

Line 376: p_okl_crtrn_user_vals_tl_rec IN OklCrtrnUserValsTlRecType

372: RETURN(l_okl_crtrn_user_vals_tl_rec);
373: END get_rec;
374:
375: FUNCTION get_rec (
376: p_okl_crtrn_user_vals_tl_rec IN OklCrtrnUserValsTlRecType
377: ) RETURN OklCrtrnUserValsTlRecType IS
378: l_row_notfound BOOLEAN := TRUE;
379: BEGIN
380: RETURN(get_rec(p_okl_crtrn_user_vals_tl_rec, l_row_notfound));

Line 380: RETURN(get_rec(p_okl_crtrn_user_vals_tl_rec, l_row_notfound));

376: p_okl_crtrn_user_vals_tl_rec IN OklCrtrnUserValsTlRecType
377: ) RETURN OklCrtrnUserValsTlRecType IS
378: l_row_notfound BOOLEAN := TRUE;
379: BEGIN
380: RETURN(get_rec(p_okl_crtrn_user_vals_tl_rec, l_row_notfound));
381: END get_rec;
382: ---------------------------------------------------------------------------
383: -- FUNCTION get_rec for: OKL_CRTRN_USER_VALS_V
384: ---------------------------------------------------------------------------

Line 785: l_okl_crtrn_user_vals_tl_rec OklCrtrnUserValsTlRecType;

781: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
782: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
783: l_cuvv_rec cuvv_rec_type := p_cuvv_rec;
784: l_cuv_rec cuv_rec_type;
785: l_okl_crtrn_user_vals_tl_rec OklCrtrnUserValsTlRecType;
786: BEGIN
787: l_return_status := okl_api.START_ACTIVITY(l_api_name,
788: G_PKG_NAME,
789: p_init_msg_list,

Line 1052: -- insert_row for:OKL_CRTRN_USER_VALS_TL --

1048: '_PVT'
1049: );
1050: END insert_row;
1051: -------------------------------------------
1052: -- insert_row for:OKL_CRTRN_USER_VALS_TL --
1053: -------------------------------------------
1054: PROCEDURE insert_row(
1055: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
1056: x_return_status OUT NOCOPY VARCHAR2,

Line 1059: p_okl_crtrn_user_vals_tl_rec IN OklCrtrnUserValsTlRecType,

1055: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
1056: x_return_status OUT NOCOPY VARCHAR2,
1057: x_msg_count OUT NOCOPY NUMBER,
1058: x_msg_data OUT NOCOPY VARCHAR2,
1059: p_okl_crtrn_user_vals_tl_rec IN OklCrtrnUserValsTlRecType,
1060: x_okl_crtrn_user_vals_tl_rec OUT NOCOPY OklCrtrnUserValsTlRecType) IS
1061:
1062: l_api_version CONSTANT NUMBER := 1;
1063: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';

Line 1060: x_okl_crtrn_user_vals_tl_rec OUT NOCOPY OklCrtrnUserValsTlRecType) IS

1056: x_return_status OUT NOCOPY VARCHAR2,
1057: x_msg_count OUT NOCOPY NUMBER,
1058: x_msg_data OUT NOCOPY VARCHAR2,
1059: p_okl_crtrn_user_vals_tl_rec IN OklCrtrnUserValsTlRecType,
1060: x_okl_crtrn_user_vals_tl_rec OUT NOCOPY OklCrtrnUserValsTlRecType) IS
1061:
1062: l_api_version CONSTANT NUMBER := 1;
1063: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1064: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;

Line 1065: l_okl_crtrn_user_vals_tl_rec OklCrtrnUserValsTlRecType := p_okl_crtrn_user_vals_tl_rec;

1061:
1062: l_api_version CONSTANT NUMBER := 1;
1063: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1064: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
1065: l_okl_crtrn_user_vals_tl_rec OklCrtrnUserValsTlRecType := p_okl_crtrn_user_vals_tl_rec;
1066: ldefoklcrtrnuservalstlrec OklCrtrnUserValsTlRecType;
1067: CURSOR get_languages IS
1068: SELECT *
1069: FROM FND_LANGUAGES

Line 1072: -- Set_Attributes for:OKL_CRTRN_USER_VALS_TL --

1068: SELECT *
1069: FROM FND_LANGUAGES
1070: WHERE INSTALLED_FLAG IN ('I', 'B');
1071: -----------------------------------------------
1072: -- Set_Attributes for:OKL_CRTRN_USER_VALS_TL --
1073: -----------------------------------------------
1074: FUNCTION Set_Attributes (
1075: p_okl_crtrn_user_vals_tl_rec IN OklCrtrnUserValsTlRecType,
1076: x_okl_crtrn_user_vals_tl_rec OUT NOCOPY OklCrtrnUserValsTlRecType

Line 1075: p_okl_crtrn_user_vals_tl_rec IN OklCrtrnUserValsTlRecType,

1071: -----------------------------------------------
1072: -- Set_Attributes for:OKL_CRTRN_USER_VALS_TL --
1073: -----------------------------------------------
1074: FUNCTION Set_Attributes (
1075: p_okl_crtrn_user_vals_tl_rec IN OklCrtrnUserValsTlRecType,
1076: x_okl_crtrn_user_vals_tl_rec OUT NOCOPY OklCrtrnUserValsTlRecType
1077: ) RETURN VARCHAR2 IS
1078: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
1079: BEGIN

Line 1076: x_okl_crtrn_user_vals_tl_rec OUT NOCOPY OklCrtrnUserValsTlRecType

1072: -- Set_Attributes for:OKL_CRTRN_USER_VALS_TL --
1073: -----------------------------------------------
1074: FUNCTION Set_Attributes (
1075: p_okl_crtrn_user_vals_tl_rec IN OklCrtrnUserValsTlRecType,
1076: x_okl_crtrn_user_vals_tl_rec OUT NOCOPY OklCrtrnUserValsTlRecType
1077: ) RETURN VARCHAR2 IS
1078: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
1079: BEGIN
1080: x_okl_crtrn_user_vals_tl_rec := p_okl_crtrn_user_vals_tl_rec;

Line 1080: x_okl_crtrn_user_vals_tl_rec := p_okl_crtrn_user_vals_tl_rec;

1076: x_okl_crtrn_user_vals_tl_rec OUT NOCOPY OklCrtrnUserValsTlRecType
1077: ) RETURN VARCHAR2 IS
1078: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
1079: BEGIN
1080: x_okl_crtrn_user_vals_tl_rec := p_okl_crtrn_user_vals_tl_rec;
1081: x_okl_crtrn_user_vals_tl_rec.LANGUAGE := USERENV('LANG');
1082: x_okl_crtrn_user_vals_tl_rec.SOURCE_LANG := USERENV('LANG');
1083: RETURN(l_return_status);
1084: END Set_Attributes;

Line 1081: x_okl_crtrn_user_vals_tl_rec.LANGUAGE := USERENV('LANG');

1077: ) RETURN VARCHAR2 IS
1078: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
1079: BEGIN
1080: x_okl_crtrn_user_vals_tl_rec := p_okl_crtrn_user_vals_tl_rec;
1081: x_okl_crtrn_user_vals_tl_rec.LANGUAGE := USERENV('LANG');
1082: x_okl_crtrn_user_vals_tl_rec.SOURCE_LANG := USERENV('LANG');
1083: RETURN(l_return_status);
1084: END Set_Attributes;
1085: BEGIN

Line 1082: x_okl_crtrn_user_vals_tl_rec.SOURCE_LANG := USERENV('LANG');

1078: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
1079: BEGIN
1080: x_okl_crtrn_user_vals_tl_rec := p_okl_crtrn_user_vals_tl_rec;
1081: x_okl_crtrn_user_vals_tl_rec.LANGUAGE := USERENV('LANG');
1082: x_okl_crtrn_user_vals_tl_rec.SOURCE_LANG := USERENV('LANG');
1083: RETURN(l_return_status);
1084: END Set_Attributes;
1085: BEGIN
1086: l_return_status := okl_api.START_ACTIVITY(l_api_name,

Line 1097: p_okl_crtrn_user_vals_tl_rec, -- IN

1093: RAISE okl_api.G_EXCEPTION_ERROR;
1094: END IF;
1095: --- Setting item attributes
1096: l_return_status := Set_Attributes(
1097: p_okl_crtrn_user_vals_tl_rec, -- IN
1098: l_okl_crtrn_user_vals_tl_rec); -- OUT
1099: --- If any errors happen abort API
1100: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
1101: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1098: l_okl_crtrn_user_vals_tl_rec); -- OUT

1094: END IF;
1095: --- Setting item attributes
1096: l_return_status := Set_Attributes(
1097: p_okl_crtrn_user_vals_tl_rec, -- IN
1098: l_okl_crtrn_user_vals_tl_rec); -- OUT
1099: --- If any errors happen abort API
1100: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
1101: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
1102: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN

Line 1106: l_okl_crtrn_user_vals_tl_rec.LANGUAGE := l_lang_rec.language_code;

1102: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
1103: RAISE okl_api.G_EXCEPTION_ERROR;
1104: END IF;
1105: FOR l_lang_rec IN get_languages LOOP
1106: l_okl_crtrn_user_vals_tl_rec.LANGUAGE := l_lang_rec.language_code;
1107: INSERT INTO OKL_CRTRN_USER_VALS_TL(
1108: id,
1109: LANGUAGE,
1110: source_lang,

Line 1107: INSERT INTO OKL_CRTRN_USER_VALS_TL(

1103: RAISE okl_api.G_EXCEPTION_ERROR;
1104: END IF;
1105: FOR l_lang_rec IN get_languages LOOP
1106: l_okl_crtrn_user_vals_tl_rec.LANGUAGE := l_lang_rec.language_code;
1107: INSERT INTO OKL_CRTRN_USER_VALS_TL(
1108: id,
1109: LANGUAGE,
1110: source_lang,
1111: sfwt_flag,

Line 1119: l_okl_crtrn_user_vals_tl_rec.id,

1115: last_updated_by,
1116: last_update_date,
1117: last_update_login)
1118: VALUES (
1119: l_okl_crtrn_user_vals_tl_rec.id,
1120: l_okl_crtrn_user_vals_tl_rec.LANGUAGE,
1121: l_okl_crtrn_user_vals_tl_rec.source_lang,
1122: l_okl_crtrn_user_vals_tl_rec.sfwt_flag,
1123: l_okl_crtrn_user_vals_tl_rec.description,

Line 1120: l_okl_crtrn_user_vals_tl_rec.LANGUAGE,

1116: last_update_date,
1117: last_update_login)
1118: VALUES (
1119: l_okl_crtrn_user_vals_tl_rec.id,
1120: l_okl_crtrn_user_vals_tl_rec.LANGUAGE,
1121: l_okl_crtrn_user_vals_tl_rec.source_lang,
1122: l_okl_crtrn_user_vals_tl_rec.sfwt_flag,
1123: l_okl_crtrn_user_vals_tl_rec.description,
1124: l_okl_crtrn_user_vals_tl_rec.created_by,

Line 1121: l_okl_crtrn_user_vals_tl_rec.source_lang,

1117: last_update_login)
1118: VALUES (
1119: l_okl_crtrn_user_vals_tl_rec.id,
1120: l_okl_crtrn_user_vals_tl_rec.LANGUAGE,
1121: l_okl_crtrn_user_vals_tl_rec.source_lang,
1122: l_okl_crtrn_user_vals_tl_rec.sfwt_flag,
1123: l_okl_crtrn_user_vals_tl_rec.description,
1124: l_okl_crtrn_user_vals_tl_rec.created_by,
1125: l_okl_crtrn_user_vals_tl_rec.creation_date,

Line 1122: l_okl_crtrn_user_vals_tl_rec.sfwt_flag,

1118: VALUES (
1119: l_okl_crtrn_user_vals_tl_rec.id,
1120: l_okl_crtrn_user_vals_tl_rec.LANGUAGE,
1121: l_okl_crtrn_user_vals_tl_rec.source_lang,
1122: l_okl_crtrn_user_vals_tl_rec.sfwt_flag,
1123: l_okl_crtrn_user_vals_tl_rec.description,
1124: l_okl_crtrn_user_vals_tl_rec.created_by,
1125: l_okl_crtrn_user_vals_tl_rec.creation_date,
1126: l_okl_crtrn_user_vals_tl_rec.last_updated_by,

Line 1123: l_okl_crtrn_user_vals_tl_rec.description,

1119: l_okl_crtrn_user_vals_tl_rec.id,
1120: l_okl_crtrn_user_vals_tl_rec.LANGUAGE,
1121: l_okl_crtrn_user_vals_tl_rec.source_lang,
1122: l_okl_crtrn_user_vals_tl_rec.sfwt_flag,
1123: l_okl_crtrn_user_vals_tl_rec.description,
1124: l_okl_crtrn_user_vals_tl_rec.created_by,
1125: l_okl_crtrn_user_vals_tl_rec.creation_date,
1126: l_okl_crtrn_user_vals_tl_rec.last_updated_by,
1127: l_okl_crtrn_user_vals_tl_rec.last_update_date,

Line 1124: l_okl_crtrn_user_vals_tl_rec.created_by,

1120: l_okl_crtrn_user_vals_tl_rec.LANGUAGE,
1121: l_okl_crtrn_user_vals_tl_rec.source_lang,
1122: l_okl_crtrn_user_vals_tl_rec.sfwt_flag,
1123: l_okl_crtrn_user_vals_tl_rec.description,
1124: l_okl_crtrn_user_vals_tl_rec.created_by,
1125: l_okl_crtrn_user_vals_tl_rec.creation_date,
1126: l_okl_crtrn_user_vals_tl_rec.last_updated_by,
1127: l_okl_crtrn_user_vals_tl_rec.last_update_date,
1128: l_okl_crtrn_user_vals_tl_rec.last_update_login);

Line 1125: l_okl_crtrn_user_vals_tl_rec.creation_date,

1121: l_okl_crtrn_user_vals_tl_rec.source_lang,
1122: l_okl_crtrn_user_vals_tl_rec.sfwt_flag,
1123: l_okl_crtrn_user_vals_tl_rec.description,
1124: l_okl_crtrn_user_vals_tl_rec.created_by,
1125: l_okl_crtrn_user_vals_tl_rec.creation_date,
1126: l_okl_crtrn_user_vals_tl_rec.last_updated_by,
1127: l_okl_crtrn_user_vals_tl_rec.last_update_date,
1128: l_okl_crtrn_user_vals_tl_rec.last_update_login);
1129: END LOOP;

Line 1126: l_okl_crtrn_user_vals_tl_rec.last_updated_by,

1122: l_okl_crtrn_user_vals_tl_rec.sfwt_flag,
1123: l_okl_crtrn_user_vals_tl_rec.description,
1124: l_okl_crtrn_user_vals_tl_rec.created_by,
1125: l_okl_crtrn_user_vals_tl_rec.creation_date,
1126: l_okl_crtrn_user_vals_tl_rec.last_updated_by,
1127: l_okl_crtrn_user_vals_tl_rec.last_update_date,
1128: l_okl_crtrn_user_vals_tl_rec.last_update_login);
1129: END LOOP;
1130: -- Set OUT values

Line 1127: l_okl_crtrn_user_vals_tl_rec.last_update_date,

1123: l_okl_crtrn_user_vals_tl_rec.description,
1124: l_okl_crtrn_user_vals_tl_rec.created_by,
1125: l_okl_crtrn_user_vals_tl_rec.creation_date,
1126: l_okl_crtrn_user_vals_tl_rec.last_updated_by,
1127: l_okl_crtrn_user_vals_tl_rec.last_update_date,
1128: l_okl_crtrn_user_vals_tl_rec.last_update_login);
1129: END LOOP;
1130: -- Set OUT values
1131: x_okl_crtrn_user_vals_tl_rec := l_okl_crtrn_user_vals_tl_rec;

Line 1128: l_okl_crtrn_user_vals_tl_rec.last_update_login);

1124: l_okl_crtrn_user_vals_tl_rec.created_by,
1125: l_okl_crtrn_user_vals_tl_rec.creation_date,
1126: l_okl_crtrn_user_vals_tl_rec.last_updated_by,
1127: l_okl_crtrn_user_vals_tl_rec.last_update_date,
1128: l_okl_crtrn_user_vals_tl_rec.last_update_login);
1129: END LOOP;
1130: -- Set OUT values
1131: x_okl_crtrn_user_vals_tl_rec := l_okl_crtrn_user_vals_tl_rec;
1132: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1131: x_okl_crtrn_user_vals_tl_rec := l_okl_crtrn_user_vals_tl_rec;

1127: l_okl_crtrn_user_vals_tl_rec.last_update_date,
1128: l_okl_crtrn_user_vals_tl_rec.last_update_login);
1129: END LOOP;
1130: -- Set OUT values
1131: x_okl_crtrn_user_vals_tl_rec := l_okl_crtrn_user_vals_tl_rec;
1132: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
1133: EXCEPTION
1134: WHEN okl_api.G_EXCEPTION_ERROR THEN
1135: x_return_status := okl_api.HANDLE_EXCEPTIONS

Line 1184: l_okl_crtrn_user_vals_tl_rec OklCrtrnUserValsTlRecType;

1180: l_cuvv_rec cuvv_rec_type;
1181: l_def_cuvv_rec cuvv_rec_type;
1182: l_cuv_rec cuv_rec_type;
1183: lx_cuv_rec cuv_rec_type;
1184: l_okl_crtrn_user_vals_tl_rec OklCrtrnUserValsTlRecType;
1185: lx_okl_crtrn_user_vals_tl_rec OklCrtrnUserValsTlRecType;
1186: -------------------------------
1187: -- FUNCTION fill_who_columns --
1188: -------------------------------

Line 1185: lx_okl_crtrn_user_vals_tl_rec OklCrtrnUserValsTlRecType;

1181: l_def_cuvv_rec cuvv_rec_type;
1182: l_cuv_rec cuv_rec_type;
1183: lx_cuv_rec cuv_rec_type;
1184: l_okl_crtrn_user_vals_tl_rec OklCrtrnUserValsTlRecType;
1185: lx_okl_crtrn_user_vals_tl_rec OklCrtrnUserValsTlRecType;
1186: -------------------------------
1187: -- FUNCTION fill_who_columns --
1188: -------------------------------
1189: FUNCTION fill_who_columns (

Line 1260: migrate(l_def_cuvv_rec, l_okl_crtrn_user_vals_tl_rec);

1256: --------------------------------------
1257: -- Move VIEW record to "Child" records
1258: --------------------------------------
1259: migrate(l_def_cuvv_rec, l_cuv_rec);
1260: migrate(l_def_cuvv_rec, l_okl_crtrn_user_vals_tl_rec);
1261: --------------------------------------------
1262: -- Call the INSERT_ROW for each child record
1263: --------------------------------------------
1264: insert_row(

Line 1283: l_okl_crtrn_user_vals_tl_rec,

1279: p_init_msg_list,
1280: x_return_status,
1281: x_msg_count,
1282: x_msg_data,
1283: l_okl_crtrn_user_vals_tl_rec,
1284: lx_okl_crtrn_user_vals_tl_rec
1285: );
1286: IF (x_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
1287: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1284: lx_okl_crtrn_user_vals_tl_rec

1280: x_return_status,
1281: x_msg_count,
1282: x_msg_data,
1283: l_okl_crtrn_user_vals_tl_rec,
1284: lx_okl_crtrn_user_vals_tl_rec
1285: );
1286: IF (x_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
1287: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
1288: ELSIF (x_return_status = okl_api.G_RET_STS_ERROR) THEN

Line 1291: migrate(lx_okl_crtrn_user_vals_tl_rec, l_def_cuvv_rec);

1287: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
1288: ELSIF (x_return_status = okl_api.G_RET_STS_ERROR) THEN
1289: RAISE okl_api.G_EXCEPTION_ERROR;
1290: END IF;
1291: migrate(lx_okl_crtrn_user_vals_tl_rec, l_def_cuvv_rec);
1292: -- Set OUT values
1293: x_cuvv_rec := l_def_cuvv_rec;
1294: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
1295: EXCEPTION

Line 1504: -- lock_row for:OKL_CRTRN_USER_VALS_TL --

1500: '_PVT'
1501: );
1502: END lock_row;
1503: -----------------------------------------
1504: -- lock_row for:OKL_CRTRN_USER_VALS_TL --
1505: -----------------------------------------
1506: PROCEDURE lock_row(
1507: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
1508: x_return_status OUT NOCOPY VARCHAR2,

Line 1511: p_okl_crtrn_user_vals_tl_rec IN OklCrtrnUserValsTlRecType) IS

1507: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
1508: x_return_status OUT NOCOPY VARCHAR2,
1509: x_msg_count OUT NOCOPY NUMBER,
1510: x_msg_data OUT NOCOPY VARCHAR2,
1511: p_okl_crtrn_user_vals_tl_rec IN OklCrtrnUserValsTlRecType) IS
1512:
1513: E_Resource_Busy EXCEPTION;
1514: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1515: CURSOR lock_csr (p_okl_crtrn_user_vals_tl_rec IN OklCrtrnUserValsTlRecType) IS

Line 1515: CURSOR lock_csr (p_okl_crtrn_user_vals_tl_rec IN OklCrtrnUserValsTlRecType) IS

1511: p_okl_crtrn_user_vals_tl_rec IN OklCrtrnUserValsTlRecType) IS
1512:
1513: E_Resource_Busy EXCEPTION;
1514: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1515: CURSOR lock_csr (p_okl_crtrn_user_vals_tl_rec IN OklCrtrnUserValsTlRecType) IS
1516: SELECT *
1517: FROM OKL_CRTRN_USER_VALS_TL
1518: WHERE ID = p_okl_crtrn_user_vals_tl_rec.id
1519: FOR UPDATE NOWAIT;

Line 1517: FROM OKL_CRTRN_USER_VALS_TL

1513: E_Resource_Busy EXCEPTION;
1514: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1515: CURSOR lock_csr (p_okl_crtrn_user_vals_tl_rec IN OklCrtrnUserValsTlRecType) IS
1516: SELECT *
1517: FROM OKL_CRTRN_USER_VALS_TL
1518: WHERE ID = p_okl_crtrn_user_vals_tl_rec.id
1519: FOR UPDATE NOWAIT;
1520:
1521: l_api_version CONSTANT NUMBER := 1;

Line 1518: WHERE ID = p_okl_crtrn_user_vals_tl_rec.id

1514: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1515: CURSOR lock_csr (p_okl_crtrn_user_vals_tl_rec IN OklCrtrnUserValsTlRecType) IS
1516: SELECT *
1517: FROM OKL_CRTRN_USER_VALS_TL
1518: WHERE ID = p_okl_crtrn_user_vals_tl_rec.id
1519: FOR UPDATE NOWAIT;
1520:
1521: l_api_version CONSTANT NUMBER := 1;
1522: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';

Line 1538: OPEN lock_csr(p_okl_crtrn_user_vals_tl_rec);

1534: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
1535: RAISE okl_api.G_EXCEPTION_ERROR;
1536: END IF;
1537: BEGIN
1538: OPEN lock_csr(p_okl_crtrn_user_vals_tl_rec);
1539: FETCH lock_csr INTO l_lock_var;
1540: l_row_notfound := lock_csr%NOTFOUND;
1541: CLOSE lock_csr;
1542: EXCEPTION

Line 1603: l_okl_crtrn_user_vals_tl_rec OklCrtrnUserValsTlRecType;

1599: l_api_version CONSTANT NUMBER := 1;
1600: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1601: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
1602: l_cuv_rec cuv_rec_type;
1603: l_okl_crtrn_user_vals_tl_rec OklCrtrnUserValsTlRecType;
1604: BEGIN
1605: l_return_status := okl_api.START_ACTIVITY(l_api_name,
1606: G_PKG_NAME,
1607: p_init_msg_list,

Line 1621: migrate(p_cuvv_rec, l_okl_crtrn_user_vals_tl_rec);

1617: --------------------------------------
1618: -- Move VIEW record to "Child" records
1619: --------------------------------------
1620: migrate(p_cuvv_rec, l_cuv_rec);
1621: migrate(p_cuvv_rec, l_okl_crtrn_user_vals_tl_rec);
1622: --------------------------------------------
1623: -- Call the LOCK_ROW for each child record
1624: --------------------------------------------
1625: lock_row(

Line 1642: l_okl_crtrn_user_vals_tl_rec

1638: p_init_msg_list,
1639: x_return_status,
1640: x_msg_count,
1641: x_msg_data,
1642: l_okl_crtrn_user_vals_tl_rec
1643: );
1644: IF (x_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
1645: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
1646: ELSIF (x_return_status = okl_api.G_RET_STS_ERROR) THEN

Line 1991: -- update_row for:OKL_CRTRN_USER_VALS_TL --

1987: '_PVT'
1988: );
1989: END update_row;
1990: -------------------------------------------
1991: -- update_row for:OKL_CRTRN_USER_VALS_TL --
1992: -------------------------------------------
1993: PROCEDURE update_row(
1994: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
1995: x_return_status OUT NOCOPY VARCHAR2,

Line 1998: p_okl_crtrn_user_vals_tl_rec IN OklCrtrnUserValsTlRecType,

1994: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
1995: x_return_status OUT NOCOPY VARCHAR2,
1996: x_msg_count OUT NOCOPY NUMBER,
1997: x_msg_data OUT NOCOPY VARCHAR2,
1998: p_okl_crtrn_user_vals_tl_rec IN OklCrtrnUserValsTlRecType,
1999: x_okl_crtrn_user_vals_tl_rec OUT NOCOPY OklCrtrnUserValsTlRecType) IS
2000:
2001: l_api_version CONSTANT NUMBER := 1;
2002: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';

Line 1999: x_okl_crtrn_user_vals_tl_rec OUT NOCOPY OklCrtrnUserValsTlRecType) IS

1995: x_return_status OUT NOCOPY VARCHAR2,
1996: x_msg_count OUT NOCOPY NUMBER,
1997: x_msg_data OUT NOCOPY VARCHAR2,
1998: p_okl_crtrn_user_vals_tl_rec IN OklCrtrnUserValsTlRecType,
1999: x_okl_crtrn_user_vals_tl_rec OUT NOCOPY OklCrtrnUserValsTlRecType) IS
2000:
2001: l_api_version CONSTANT NUMBER := 1;
2002: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2003: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;

Line 2004: l_okl_crtrn_user_vals_tl_rec OklCrtrnUserValsTlRecType := p_okl_crtrn_user_vals_tl_rec;

2000:
2001: l_api_version CONSTANT NUMBER := 1;
2002: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2003: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2004: l_okl_crtrn_user_vals_tl_rec OklCrtrnUserValsTlRecType := p_okl_crtrn_user_vals_tl_rec;
2005: ldefoklcrtrnuservalstlrec OklCrtrnUserValsTlRecType;
2006: l_row_notfound BOOLEAN := TRUE;
2007: ----------------------------------
2008: -- FUNCTION populate_new_record --

Line 2011: p_okl_crtrn_user_vals_tl_rec IN OklCrtrnUserValsTlRecType,

2007: ----------------------------------
2008: -- FUNCTION populate_new_record --
2009: ----------------------------------
2010: FUNCTION populate_new_record (
2011: p_okl_crtrn_user_vals_tl_rec IN OklCrtrnUserValsTlRecType,
2012: x_okl_crtrn_user_vals_tl_rec OUT NOCOPY OklCrtrnUserValsTlRecType
2013: ) RETURN VARCHAR2 IS
2014: l_okl_crtrn_user_vals_tl_rec OklCrtrnUserValsTlRecType;
2015: l_row_notfound BOOLEAN := TRUE;

Line 2012: x_okl_crtrn_user_vals_tl_rec OUT NOCOPY OklCrtrnUserValsTlRecType

2008: -- FUNCTION populate_new_record --
2009: ----------------------------------
2010: FUNCTION populate_new_record (
2011: p_okl_crtrn_user_vals_tl_rec IN OklCrtrnUserValsTlRecType,
2012: x_okl_crtrn_user_vals_tl_rec OUT NOCOPY OklCrtrnUserValsTlRecType
2013: ) RETURN VARCHAR2 IS
2014: l_okl_crtrn_user_vals_tl_rec OklCrtrnUserValsTlRecType;
2015: l_row_notfound BOOLEAN := TRUE;
2016: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;

Line 2014: l_okl_crtrn_user_vals_tl_rec OklCrtrnUserValsTlRecType;

2010: FUNCTION populate_new_record (
2011: p_okl_crtrn_user_vals_tl_rec IN OklCrtrnUserValsTlRecType,
2012: x_okl_crtrn_user_vals_tl_rec OUT NOCOPY OklCrtrnUserValsTlRecType
2013: ) RETURN VARCHAR2 IS
2014: l_okl_crtrn_user_vals_tl_rec OklCrtrnUserValsTlRecType;
2015: l_row_notfound BOOLEAN := TRUE;
2016: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2017: BEGIN
2018: x_okl_crtrn_user_vals_tl_rec := p_okl_crtrn_user_vals_tl_rec;

Line 2018: x_okl_crtrn_user_vals_tl_rec := p_okl_crtrn_user_vals_tl_rec;

2014: l_okl_crtrn_user_vals_tl_rec OklCrtrnUserValsTlRecType;
2015: l_row_notfound BOOLEAN := TRUE;
2016: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2017: BEGIN
2018: x_okl_crtrn_user_vals_tl_rec := p_okl_crtrn_user_vals_tl_rec;
2019: -- Get current database values
2020: l_okl_crtrn_user_vals_tl_rec := get_rec(p_okl_crtrn_user_vals_tl_rec, l_row_notfound);
2021: IF (l_row_notfound) THEN
2022: l_return_status := okl_api.G_RET_STS_UNEXP_ERROR;

Line 2020: l_okl_crtrn_user_vals_tl_rec := get_rec(p_okl_crtrn_user_vals_tl_rec, l_row_notfound);

2016: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2017: BEGIN
2018: x_okl_crtrn_user_vals_tl_rec := p_okl_crtrn_user_vals_tl_rec;
2019: -- Get current database values
2020: l_okl_crtrn_user_vals_tl_rec := get_rec(p_okl_crtrn_user_vals_tl_rec, l_row_notfound);
2021: IF (l_row_notfound) THEN
2022: l_return_status := okl_api.G_RET_STS_UNEXP_ERROR;
2023: END IF;
2024: IF (x_okl_crtrn_user_vals_tl_rec.id = okl_api.G_MISS_NUM)

Line 2024: IF (x_okl_crtrn_user_vals_tl_rec.id = okl_api.G_MISS_NUM)

2020: l_okl_crtrn_user_vals_tl_rec := get_rec(p_okl_crtrn_user_vals_tl_rec, l_row_notfound);
2021: IF (l_row_notfound) THEN
2022: l_return_status := okl_api.G_RET_STS_UNEXP_ERROR;
2023: END IF;
2024: IF (x_okl_crtrn_user_vals_tl_rec.id = okl_api.G_MISS_NUM)
2025: THEN
2026: x_okl_crtrn_user_vals_tl_rec.id := l_okl_crtrn_user_vals_tl_rec.id;
2027: END IF;
2028: IF (x_okl_crtrn_user_vals_tl_rec.LANGUAGE = okl_api.G_MISS_CHAR)

Line 2026: x_okl_crtrn_user_vals_tl_rec.id := l_okl_crtrn_user_vals_tl_rec.id;

2022: l_return_status := okl_api.G_RET_STS_UNEXP_ERROR;
2023: END IF;
2024: IF (x_okl_crtrn_user_vals_tl_rec.id = okl_api.G_MISS_NUM)
2025: THEN
2026: x_okl_crtrn_user_vals_tl_rec.id := l_okl_crtrn_user_vals_tl_rec.id;
2027: END IF;
2028: IF (x_okl_crtrn_user_vals_tl_rec.LANGUAGE = okl_api.G_MISS_CHAR)
2029: THEN
2030: x_okl_crtrn_user_vals_tl_rec.LANGUAGE := l_okl_crtrn_user_vals_tl_rec.LANGUAGE;

Line 2028: IF (x_okl_crtrn_user_vals_tl_rec.LANGUAGE = okl_api.G_MISS_CHAR)

2024: IF (x_okl_crtrn_user_vals_tl_rec.id = okl_api.G_MISS_NUM)
2025: THEN
2026: x_okl_crtrn_user_vals_tl_rec.id := l_okl_crtrn_user_vals_tl_rec.id;
2027: END IF;
2028: IF (x_okl_crtrn_user_vals_tl_rec.LANGUAGE = okl_api.G_MISS_CHAR)
2029: THEN
2030: x_okl_crtrn_user_vals_tl_rec.LANGUAGE := l_okl_crtrn_user_vals_tl_rec.LANGUAGE;
2031: END IF;
2032: IF (x_okl_crtrn_user_vals_tl_rec.source_lang = okl_api.G_MISS_CHAR)

Line 2030: x_okl_crtrn_user_vals_tl_rec.LANGUAGE := l_okl_crtrn_user_vals_tl_rec.LANGUAGE;

2026: x_okl_crtrn_user_vals_tl_rec.id := l_okl_crtrn_user_vals_tl_rec.id;
2027: END IF;
2028: IF (x_okl_crtrn_user_vals_tl_rec.LANGUAGE = okl_api.G_MISS_CHAR)
2029: THEN
2030: x_okl_crtrn_user_vals_tl_rec.LANGUAGE := l_okl_crtrn_user_vals_tl_rec.LANGUAGE;
2031: END IF;
2032: IF (x_okl_crtrn_user_vals_tl_rec.source_lang = okl_api.G_MISS_CHAR)
2033: THEN
2034: x_okl_crtrn_user_vals_tl_rec.source_lang := l_okl_crtrn_user_vals_tl_rec.source_lang;

Line 2032: IF (x_okl_crtrn_user_vals_tl_rec.source_lang = okl_api.G_MISS_CHAR)

2028: IF (x_okl_crtrn_user_vals_tl_rec.LANGUAGE = okl_api.G_MISS_CHAR)
2029: THEN
2030: x_okl_crtrn_user_vals_tl_rec.LANGUAGE := l_okl_crtrn_user_vals_tl_rec.LANGUAGE;
2031: END IF;
2032: IF (x_okl_crtrn_user_vals_tl_rec.source_lang = okl_api.G_MISS_CHAR)
2033: THEN
2034: x_okl_crtrn_user_vals_tl_rec.source_lang := l_okl_crtrn_user_vals_tl_rec.source_lang;
2035: END IF;
2036: IF (x_okl_crtrn_user_vals_tl_rec.sfwt_flag = okl_api.G_MISS_CHAR)

Line 2034: x_okl_crtrn_user_vals_tl_rec.source_lang := l_okl_crtrn_user_vals_tl_rec.source_lang;

2030: x_okl_crtrn_user_vals_tl_rec.LANGUAGE := l_okl_crtrn_user_vals_tl_rec.LANGUAGE;
2031: END IF;
2032: IF (x_okl_crtrn_user_vals_tl_rec.source_lang = okl_api.G_MISS_CHAR)
2033: THEN
2034: x_okl_crtrn_user_vals_tl_rec.source_lang := l_okl_crtrn_user_vals_tl_rec.source_lang;
2035: END IF;
2036: IF (x_okl_crtrn_user_vals_tl_rec.sfwt_flag = okl_api.G_MISS_CHAR)
2037: THEN
2038: x_okl_crtrn_user_vals_tl_rec.sfwt_flag := l_okl_crtrn_user_vals_tl_rec.sfwt_flag;

Line 2036: IF (x_okl_crtrn_user_vals_tl_rec.sfwt_flag = okl_api.G_MISS_CHAR)

2032: IF (x_okl_crtrn_user_vals_tl_rec.source_lang = okl_api.G_MISS_CHAR)
2033: THEN
2034: x_okl_crtrn_user_vals_tl_rec.source_lang := l_okl_crtrn_user_vals_tl_rec.source_lang;
2035: END IF;
2036: IF (x_okl_crtrn_user_vals_tl_rec.sfwt_flag = okl_api.G_MISS_CHAR)
2037: THEN
2038: x_okl_crtrn_user_vals_tl_rec.sfwt_flag := l_okl_crtrn_user_vals_tl_rec.sfwt_flag;
2039: END IF;
2040: IF (x_okl_crtrn_user_vals_tl_rec.description = okl_api.G_MISS_CHAR)

Line 2038: x_okl_crtrn_user_vals_tl_rec.sfwt_flag := l_okl_crtrn_user_vals_tl_rec.sfwt_flag;

2034: x_okl_crtrn_user_vals_tl_rec.source_lang := l_okl_crtrn_user_vals_tl_rec.source_lang;
2035: END IF;
2036: IF (x_okl_crtrn_user_vals_tl_rec.sfwt_flag = okl_api.G_MISS_CHAR)
2037: THEN
2038: x_okl_crtrn_user_vals_tl_rec.sfwt_flag := l_okl_crtrn_user_vals_tl_rec.sfwt_flag;
2039: END IF;
2040: IF (x_okl_crtrn_user_vals_tl_rec.description = okl_api.G_MISS_CHAR)
2041: THEN
2042: x_okl_crtrn_user_vals_tl_rec.description := l_okl_crtrn_user_vals_tl_rec.description;

Line 2040: IF (x_okl_crtrn_user_vals_tl_rec.description = okl_api.G_MISS_CHAR)

2036: IF (x_okl_crtrn_user_vals_tl_rec.sfwt_flag = okl_api.G_MISS_CHAR)
2037: THEN
2038: x_okl_crtrn_user_vals_tl_rec.sfwt_flag := l_okl_crtrn_user_vals_tl_rec.sfwt_flag;
2039: END IF;
2040: IF (x_okl_crtrn_user_vals_tl_rec.description = okl_api.G_MISS_CHAR)
2041: THEN
2042: x_okl_crtrn_user_vals_tl_rec.description := l_okl_crtrn_user_vals_tl_rec.description;
2043: END IF;
2044: IF (x_okl_crtrn_user_vals_tl_rec.created_by = okl_api.G_MISS_NUM)

Line 2042: x_okl_crtrn_user_vals_tl_rec.description := l_okl_crtrn_user_vals_tl_rec.description;

2038: x_okl_crtrn_user_vals_tl_rec.sfwt_flag := l_okl_crtrn_user_vals_tl_rec.sfwt_flag;
2039: END IF;
2040: IF (x_okl_crtrn_user_vals_tl_rec.description = okl_api.G_MISS_CHAR)
2041: THEN
2042: x_okl_crtrn_user_vals_tl_rec.description := l_okl_crtrn_user_vals_tl_rec.description;
2043: END IF;
2044: IF (x_okl_crtrn_user_vals_tl_rec.created_by = okl_api.G_MISS_NUM)
2045: THEN
2046: x_okl_crtrn_user_vals_tl_rec.created_by := l_okl_crtrn_user_vals_tl_rec.created_by;

Line 2044: IF (x_okl_crtrn_user_vals_tl_rec.created_by = okl_api.G_MISS_NUM)

2040: IF (x_okl_crtrn_user_vals_tl_rec.description = okl_api.G_MISS_CHAR)
2041: THEN
2042: x_okl_crtrn_user_vals_tl_rec.description := l_okl_crtrn_user_vals_tl_rec.description;
2043: END IF;
2044: IF (x_okl_crtrn_user_vals_tl_rec.created_by = okl_api.G_MISS_NUM)
2045: THEN
2046: x_okl_crtrn_user_vals_tl_rec.created_by := l_okl_crtrn_user_vals_tl_rec.created_by;
2047: END IF;
2048: IF (x_okl_crtrn_user_vals_tl_rec.creation_date = okl_api.G_MISS_DATE)

Line 2046: x_okl_crtrn_user_vals_tl_rec.created_by := l_okl_crtrn_user_vals_tl_rec.created_by;

2042: x_okl_crtrn_user_vals_tl_rec.description := l_okl_crtrn_user_vals_tl_rec.description;
2043: END IF;
2044: IF (x_okl_crtrn_user_vals_tl_rec.created_by = okl_api.G_MISS_NUM)
2045: THEN
2046: x_okl_crtrn_user_vals_tl_rec.created_by := l_okl_crtrn_user_vals_tl_rec.created_by;
2047: END IF;
2048: IF (x_okl_crtrn_user_vals_tl_rec.creation_date = okl_api.G_MISS_DATE)
2049: THEN
2050: x_okl_crtrn_user_vals_tl_rec.creation_date := l_okl_crtrn_user_vals_tl_rec.creation_date;

Line 2048: IF (x_okl_crtrn_user_vals_tl_rec.creation_date = okl_api.G_MISS_DATE)

2044: IF (x_okl_crtrn_user_vals_tl_rec.created_by = okl_api.G_MISS_NUM)
2045: THEN
2046: x_okl_crtrn_user_vals_tl_rec.created_by := l_okl_crtrn_user_vals_tl_rec.created_by;
2047: END IF;
2048: IF (x_okl_crtrn_user_vals_tl_rec.creation_date = okl_api.G_MISS_DATE)
2049: THEN
2050: x_okl_crtrn_user_vals_tl_rec.creation_date := l_okl_crtrn_user_vals_tl_rec.creation_date;
2051: END IF;
2052: IF (x_okl_crtrn_user_vals_tl_rec.last_updated_by = okl_api.G_MISS_NUM)

Line 2050: x_okl_crtrn_user_vals_tl_rec.creation_date := l_okl_crtrn_user_vals_tl_rec.creation_date;

2046: x_okl_crtrn_user_vals_tl_rec.created_by := l_okl_crtrn_user_vals_tl_rec.created_by;
2047: END IF;
2048: IF (x_okl_crtrn_user_vals_tl_rec.creation_date = okl_api.G_MISS_DATE)
2049: THEN
2050: x_okl_crtrn_user_vals_tl_rec.creation_date := l_okl_crtrn_user_vals_tl_rec.creation_date;
2051: END IF;
2052: IF (x_okl_crtrn_user_vals_tl_rec.last_updated_by = okl_api.G_MISS_NUM)
2053: THEN
2054: x_okl_crtrn_user_vals_tl_rec.last_updated_by := l_okl_crtrn_user_vals_tl_rec.last_updated_by;

Line 2052: IF (x_okl_crtrn_user_vals_tl_rec.last_updated_by = okl_api.G_MISS_NUM)

2048: IF (x_okl_crtrn_user_vals_tl_rec.creation_date = okl_api.G_MISS_DATE)
2049: THEN
2050: x_okl_crtrn_user_vals_tl_rec.creation_date := l_okl_crtrn_user_vals_tl_rec.creation_date;
2051: END IF;
2052: IF (x_okl_crtrn_user_vals_tl_rec.last_updated_by = okl_api.G_MISS_NUM)
2053: THEN
2054: x_okl_crtrn_user_vals_tl_rec.last_updated_by := l_okl_crtrn_user_vals_tl_rec.last_updated_by;
2055: END IF;
2056: IF (x_okl_crtrn_user_vals_tl_rec.last_update_date = okl_api.G_MISS_DATE)

Line 2054: x_okl_crtrn_user_vals_tl_rec.last_updated_by := l_okl_crtrn_user_vals_tl_rec.last_updated_by;

2050: x_okl_crtrn_user_vals_tl_rec.creation_date := l_okl_crtrn_user_vals_tl_rec.creation_date;
2051: END IF;
2052: IF (x_okl_crtrn_user_vals_tl_rec.last_updated_by = okl_api.G_MISS_NUM)
2053: THEN
2054: x_okl_crtrn_user_vals_tl_rec.last_updated_by := l_okl_crtrn_user_vals_tl_rec.last_updated_by;
2055: END IF;
2056: IF (x_okl_crtrn_user_vals_tl_rec.last_update_date = okl_api.G_MISS_DATE)
2057: THEN
2058: x_okl_crtrn_user_vals_tl_rec.last_update_date := l_okl_crtrn_user_vals_tl_rec.last_update_date;

Line 2056: IF (x_okl_crtrn_user_vals_tl_rec.last_update_date = okl_api.G_MISS_DATE)

2052: IF (x_okl_crtrn_user_vals_tl_rec.last_updated_by = okl_api.G_MISS_NUM)
2053: THEN
2054: x_okl_crtrn_user_vals_tl_rec.last_updated_by := l_okl_crtrn_user_vals_tl_rec.last_updated_by;
2055: END IF;
2056: IF (x_okl_crtrn_user_vals_tl_rec.last_update_date = okl_api.G_MISS_DATE)
2057: THEN
2058: x_okl_crtrn_user_vals_tl_rec.last_update_date := l_okl_crtrn_user_vals_tl_rec.last_update_date;
2059: END IF;
2060: IF (x_okl_crtrn_user_vals_tl_rec.last_update_login = okl_api.G_MISS_NUM)

Line 2058: x_okl_crtrn_user_vals_tl_rec.last_update_date := l_okl_crtrn_user_vals_tl_rec.last_update_date;

2054: x_okl_crtrn_user_vals_tl_rec.last_updated_by := l_okl_crtrn_user_vals_tl_rec.last_updated_by;
2055: END IF;
2056: IF (x_okl_crtrn_user_vals_tl_rec.last_update_date = okl_api.G_MISS_DATE)
2057: THEN
2058: x_okl_crtrn_user_vals_tl_rec.last_update_date := l_okl_crtrn_user_vals_tl_rec.last_update_date;
2059: END IF;
2060: IF (x_okl_crtrn_user_vals_tl_rec.last_update_login = okl_api.G_MISS_NUM)
2061: THEN
2062: x_okl_crtrn_user_vals_tl_rec.last_update_login := l_okl_crtrn_user_vals_tl_rec.last_update_login;

Line 2060: IF (x_okl_crtrn_user_vals_tl_rec.last_update_login = okl_api.G_MISS_NUM)

2056: IF (x_okl_crtrn_user_vals_tl_rec.last_update_date = okl_api.G_MISS_DATE)
2057: THEN
2058: x_okl_crtrn_user_vals_tl_rec.last_update_date := l_okl_crtrn_user_vals_tl_rec.last_update_date;
2059: END IF;
2060: IF (x_okl_crtrn_user_vals_tl_rec.last_update_login = okl_api.G_MISS_NUM)
2061: THEN
2062: x_okl_crtrn_user_vals_tl_rec.last_update_login := l_okl_crtrn_user_vals_tl_rec.last_update_login;
2063: END IF;
2064: RETURN(l_return_status);

Line 2062: x_okl_crtrn_user_vals_tl_rec.last_update_login := l_okl_crtrn_user_vals_tl_rec.last_update_login;

2058: x_okl_crtrn_user_vals_tl_rec.last_update_date := l_okl_crtrn_user_vals_tl_rec.last_update_date;
2059: END IF;
2060: IF (x_okl_crtrn_user_vals_tl_rec.last_update_login = okl_api.G_MISS_NUM)
2061: THEN
2062: x_okl_crtrn_user_vals_tl_rec.last_update_login := l_okl_crtrn_user_vals_tl_rec.last_update_login;
2063: END IF;
2064: RETURN(l_return_status);
2065: END populate_new_record;
2066: -----------------------------------------------

Line 2067: -- Set_Attributes for:OKL_CRTRN_USER_VALS_TL --

2063: END IF;
2064: RETURN(l_return_status);
2065: END populate_new_record;
2066: -----------------------------------------------
2067: -- Set_Attributes for:OKL_CRTRN_USER_VALS_TL --
2068: -----------------------------------------------
2069: FUNCTION Set_Attributes (
2070: p_okl_crtrn_user_vals_tl_rec IN OklCrtrnUserValsTlRecType,
2071: x_okl_crtrn_user_vals_tl_rec OUT NOCOPY OklCrtrnUserValsTlRecType

Line 2070: p_okl_crtrn_user_vals_tl_rec IN OklCrtrnUserValsTlRecType,

2066: -----------------------------------------------
2067: -- Set_Attributes for:OKL_CRTRN_USER_VALS_TL --
2068: -----------------------------------------------
2069: FUNCTION Set_Attributes (
2070: p_okl_crtrn_user_vals_tl_rec IN OklCrtrnUserValsTlRecType,
2071: x_okl_crtrn_user_vals_tl_rec OUT NOCOPY OklCrtrnUserValsTlRecType
2072: ) RETURN VARCHAR2 IS
2073: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2074: BEGIN

Line 2071: x_okl_crtrn_user_vals_tl_rec OUT NOCOPY OklCrtrnUserValsTlRecType

2067: -- Set_Attributes for:OKL_CRTRN_USER_VALS_TL --
2068: -----------------------------------------------
2069: FUNCTION Set_Attributes (
2070: p_okl_crtrn_user_vals_tl_rec IN OklCrtrnUserValsTlRecType,
2071: x_okl_crtrn_user_vals_tl_rec OUT NOCOPY OklCrtrnUserValsTlRecType
2072: ) RETURN VARCHAR2 IS
2073: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2074: BEGIN
2075: x_okl_crtrn_user_vals_tl_rec := p_okl_crtrn_user_vals_tl_rec;

Line 2075: x_okl_crtrn_user_vals_tl_rec := p_okl_crtrn_user_vals_tl_rec;

2071: x_okl_crtrn_user_vals_tl_rec OUT NOCOPY OklCrtrnUserValsTlRecType
2072: ) RETURN VARCHAR2 IS
2073: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2074: BEGIN
2075: x_okl_crtrn_user_vals_tl_rec := p_okl_crtrn_user_vals_tl_rec;
2076: x_okl_crtrn_user_vals_tl_rec.LANGUAGE := USERENV('LANG');
2077: x_okl_crtrn_user_vals_tl_rec.SOURCE_LANG := USERENV('LANG');
2078: RETURN(l_return_status);
2079: END Set_Attributes;

Line 2076: x_okl_crtrn_user_vals_tl_rec.LANGUAGE := USERENV('LANG');

2072: ) RETURN VARCHAR2 IS
2073: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2074: BEGIN
2075: x_okl_crtrn_user_vals_tl_rec := p_okl_crtrn_user_vals_tl_rec;
2076: x_okl_crtrn_user_vals_tl_rec.LANGUAGE := USERENV('LANG');
2077: x_okl_crtrn_user_vals_tl_rec.SOURCE_LANG := USERENV('LANG');
2078: RETURN(l_return_status);
2079: END Set_Attributes;
2080: BEGIN

Line 2077: x_okl_crtrn_user_vals_tl_rec.SOURCE_LANG := USERENV('LANG');

2073: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2074: BEGIN
2075: x_okl_crtrn_user_vals_tl_rec := p_okl_crtrn_user_vals_tl_rec;
2076: x_okl_crtrn_user_vals_tl_rec.LANGUAGE := USERENV('LANG');
2077: x_okl_crtrn_user_vals_tl_rec.SOURCE_LANG := USERENV('LANG');
2078: RETURN(l_return_status);
2079: END Set_Attributes;
2080: BEGIN
2081: l_return_status := okl_api.START_ACTIVITY(l_api_name,

Line 2092: p_okl_crtrn_user_vals_tl_rec, -- IN

2088: RAISE okl_api.G_EXCEPTION_ERROR;
2089: END IF;
2090: --- Setting item attributes
2091: l_return_status := Set_Attributes(
2092: p_okl_crtrn_user_vals_tl_rec, -- IN
2093: l_okl_crtrn_user_vals_tl_rec); -- OUT
2094: --- If any errors happen abort API
2095: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
2096: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2093: l_okl_crtrn_user_vals_tl_rec); -- OUT

2089: END IF;
2090: --- Setting item attributes
2091: l_return_status := Set_Attributes(
2092: p_okl_crtrn_user_vals_tl_rec, -- IN
2093: l_okl_crtrn_user_vals_tl_rec); -- OUT
2094: --- If any errors happen abort API
2095: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
2096: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
2097: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN

Line 2100: l_return_status := populate_new_record(l_okl_crtrn_user_vals_tl_rec, ldefoklcrtrnuservalstlrec);

2096: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
2097: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
2098: RAISE okl_api.G_EXCEPTION_ERROR;
2099: END IF;
2100: l_return_status := populate_new_record(l_okl_crtrn_user_vals_tl_rec, ldefoklcrtrnuservalstlrec);
2101: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
2102: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
2103: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
2104: RAISE okl_api.G_EXCEPTION_ERROR;

Line 2106: UPDATE OKL_CRTRN_USER_VALS_TL

2102: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
2103: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
2104: RAISE okl_api.G_EXCEPTION_ERROR;
2105: END IF;
2106: UPDATE OKL_CRTRN_USER_VALS_TL
2107: SET DESCRIPTION = ldefoklcrtrnuservalstlrec.description,
2108: CREATED_BY = ldefoklcrtrnuservalstlrec.created_by,
2109: CREATION_DATE = ldefoklcrtrnuservalstlrec.creation_date,
2110: LAST_UPDATED_BY = ldefoklcrtrnuservalstlrec.last_updated_by,

Line 2117: UPDATE OKL_CRTRN_USER_VALS_TL

2113: WHERE ID = ldefoklcrtrnuservalstlrec.id
2114: --AND SOURCE_LANG = USERENV('LANG');
2115: AND USERENV('LANG') in (SOURCE_LANG, LANGUAGE);
2116:
2117: UPDATE OKL_CRTRN_USER_VALS_TL
2118: SET SFWT_FLAG = 'Y'
2119: WHERE ID = ldefoklcrtrnuservalstlrec.id
2120: AND SOURCE_LANG <> USERENV('LANG');
2121:

Line 2122: x_okl_crtrn_user_vals_tl_rec := ldefoklcrtrnuservalstlrec;

2118: SET SFWT_FLAG = 'Y'
2119: WHERE ID = ldefoklcrtrnuservalstlrec.id
2120: AND SOURCE_LANG <> USERENV('LANG');
2121:
2122: x_okl_crtrn_user_vals_tl_rec := ldefoklcrtrnuservalstlrec;
2123: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
2124: EXCEPTION
2125: WHEN okl_api.G_EXCEPTION_ERROR THEN
2126: x_return_status := okl_api.HANDLE_EXCEPTIONS

Line 2173: l_okl_crtrn_user_vals_tl_rec OklCrtrnUserValsTlRecType;

2169: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
2170: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2171: l_cuvv_rec cuvv_rec_type := p_cuvv_rec;
2172: l_def_cuvv_rec cuvv_rec_type;
2173: l_okl_crtrn_user_vals_tl_rec OklCrtrnUserValsTlRecType;
2174: lx_okl_crtrn_user_vals_tl_rec OklCrtrnUserValsTlRecType;
2175: l_cuv_rec cuv_rec_type;
2176: lx_cuv_rec cuv_rec_type;
2177: -------------------------------

Line 2174: lx_okl_crtrn_user_vals_tl_rec OklCrtrnUserValsTlRecType;

2170: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2171: l_cuvv_rec cuvv_rec_type := p_cuvv_rec;
2172: l_def_cuvv_rec cuvv_rec_type;
2173: l_okl_crtrn_user_vals_tl_rec OklCrtrnUserValsTlRecType;
2174: lx_okl_crtrn_user_vals_tl_rec OklCrtrnUserValsTlRecType;
2175: l_cuv_rec cuv_rec_type;
2176: lx_cuv_rec cuv_rec_type;
2177: -------------------------------
2178: -- FUNCTION fill_who_columns --

Line 2382: migrate(l_def_cuvv_rec, l_okl_crtrn_user_vals_tl_rec);

2378:
2379: --------------------------------------
2380: -- Move VIEW record to "Child" records
2381: --------------------------------------
2382: migrate(l_def_cuvv_rec, l_okl_crtrn_user_vals_tl_rec);
2383: migrate(l_def_cuvv_rec, l_cuv_rec);
2384: --------------------------------------------
2385: -- Call the UPDATE_ROW for each child record
2386: --------------------------------------------

Line 2392: l_okl_crtrn_user_vals_tl_rec,

2388: p_init_msg_list,
2389: x_return_status,
2390: x_msg_count,
2391: x_msg_data,
2392: l_okl_crtrn_user_vals_tl_rec,
2393: lx_okl_crtrn_user_vals_tl_rec
2394: );
2395: IF (x_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
2396: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2393: lx_okl_crtrn_user_vals_tl_rec

2389: x_return_status,
2390: x_msg_count,
2391: x_msg_data,
2392: l_okl_crtrn_user_vals_tl_rec,
2393: lx_okl_crtrn_user_vals_tl_rec
2394: );
2395: IF (x_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
2396: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
2397: ELSIF (x_return_status = okl_api.G_RET_STS_ERROR) THEN

Line 2400: migrate(lx_okl_crtrn_user_vals_tl_rec, l_def_cuvv_rec);

2396: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
2397: ELSIF (x_return_status = okl_api.G_RET_STS_ERROR) THEN
2398: RAISE okl_api.G_EXCEPTION_ERROR;
2399: END IF;
2400: migrate(lx_okl_crtrn_user_vals_tl_rec, l_def_cuvv_rec);
2401: update_row(
2402: p_init_msg_list,
2403: x_return_status,
2404: x_msg_count,

Line 2581: -- delete_row for:OKL_CRTRN_USER_VALS_TL --

2577: '_PVT'
2578: );
2579: END delete_row;
2580: -------------------------------------------
2581: -- delete_row for:OKL_CRTRN_USER_VALS_TL --
2582: -------------------------------------------
2583: PROCEDURE delete_row(
2584: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
2585: x_return_status OUT NOCOPY VARCHAR2,

Line 2588: p_okl_crtrn_user_vals_tl_rec IN OklCrtrnUserValsTlRecType) IS

2584: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
2585: x_return_status OUT NOCOPY VARCHAR2,
2586: x_msg_count OUT NOCOPY NUMBER,
2587: x_msg_data OUT NOCOPY VARCHAR2,
2588: p_okl_crtrn_user_vals_tl_rec IN OklCrtrnUserValsTlRecType) IS
2589:
2590: l_api_version CONSTANT NUMBER := 1;
2591: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
2592: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;

Line 2593: l_okl_crtrn_user_vals_tl_rec OklCrtrnUserValsTlRecType:= p_okl_crtrn_user_vals_tl_rec;

2589:
2590: l_api_version CONSTANT NUMBER := 1;
2591: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
2592: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2593: l_okl_crtrn_user_vals_tl_rec OklCrtrnUserValsTlRecType:= p_okl_crtrn_user_vals_tl_rec;
2594: l_row_notfound BOOLEAN := TRUE;
2595: -----------------------------------------------
2596: -- Set_Attributes for:OKL_CRTRN_USER_VALS_TL --
2597: -----------------------------------------------

Line 2596: -- Set_Attributes for:OKL_CRTRN_USER_VALS_TL --

2592: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2593: l_okl_crtrn_user_vals_tl_rec OklCrtrnUserValsTlRecType:= p_okl_crtrn_user_vals_tl_rec;
2594: l_row_notfound BOOLEAN := TRUE;
2595: -----------------------------------------------
2596: -- Set_Attributes for:OKL_CRTRN_USER_VALS_TL --
2597: -----------------------------------------------
2598: FUNCTION Set_Attributes (
2599: p_okl_crtrn_user_vals_tl_rec IN OklCrtrnUserValsTlRecType,
2600: x_okl_crtrn_user_vals_tl_rec OUT NOCOPY OklCrtrnUserValsTlRecType

Line 2599: p_okl_crtrn_user_vals_tl_rec IN OklCrtrnUserValsTlRecType,

2595: -----------------------------------------------
2596: -- Set_Attributes for:OKL_CRTRN_USER_VALS_TL --
2597: -----------------------------------------------
2598: FUNCTION Set_Attributes (
2599: p_okl_crtrn_user_vals_tl_rec IN OklCrtrnUserValsTlRecType,
2600: x_okl_crtrn_user_vals_tl_rec OUT NOCOPY OklCrtrnUserValsTlRecType
2601: ) RETURN VARCHAR2 IS
2602: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2603: BEGIN

Line 2600: x_okl_crtrn_user_vals_tl_rec OUT NOCOPY OklCrtrnUserValsTlRecType

2596: -- Set_Attributes for:OKL_CRTRN_USER_VALS_TL --
2597: -----------------------------------------------
2598: FUNCTION Set_Attributes (
2599: p_okl_crtrn_user_vals_tl_rec IN OklCrtrnUserValsTlRecType,
2600: x_okl_crtrn_user_vals_tl_rec OUT NOCOPY OklCrtrnUserValsTlRecType
2601: ) RETURN VARCHAR2 IS
2602: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2603: BEGIN
2604: x_okl_crtrn_user_vals_tl_rec := p_okl_crtrn_user_vals_tl_rec;

Line 2604: x_okl_crtrn_user_vals_tl_rec := p_okl_crtrn_user_vals_tl_rec;

2600: x_okl_crtrn_user_vals_tl_rec OUT NOCOPY OklCrtrnUserValsTlRecType
2601: ) RETURN VARCHAR2 IS
2602: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2603: BEGIN
2604: x_okl_crtrn_user_vals_tl_rec := p_okl_crtrn_user_vals_tl_rec;
2605: x_okl_crtrn_user_vals_tl_rec.LANGUAGE := USERENV('LANG');
2606: RETURN(l_return_status);
2607: END Set_Attributes;
2608: BEGIN

Line 2605: x_okl_crtrn_user_vals_tl_rec.LANGUAGE := USERENV('LANG');

2601: ) RETURN VARCHAR2 IS
2602: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2603: BEGIN
2604: x_okl_crtrn_user_vals_tl_rec := p_okl_crtrn_user_vals_tl_rec;
2605: x_okl_crtrn_user_vals_tl_rec.LANGUAGE := USERENV('LANG');
2606: RETURN(l_return_status);
2607: END Set_Attributes;
2608: BEGIN
2609: l_return_status := okl_api.START_ACTIVITY(l_api_name,

Line 2620: p_okl_crtrn_user_vals_tl_rec, -- IN

2616: RAISE okl_api.G_EXCEPTION_ERROR;
2617: END IF;
2618: --- Setting item attributes
2619: l_return_status := Set_Attributes(
2620: p_okl_crtrn_user_vals_tl_rec, -- IN
2621: l_okl_crtrn_user_vals_tl_rec); -- OUT
2622: --- If any errors happen abort API
2623: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
2624: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2621: l_okl_crtrn_user_vals_tl_rec); -- OUT

2617: END IF;
2618: --- Setting item attributes
2619: l_return_status := Set_Attributes(
2620: p_okl_crtrn_user_vals_tl_rec, -- IN
2621: l_okl_crtrn_user_vals_tl_rec); -- OUT
2622: --- If any errors happen abort API
2623: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
2624: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
2625: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN

Line 2628: DELETE FROM OKL_CRTRN_USER_VALS_TL

2624: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
2625: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
2626: RAISE okl_api.G_EXCEPTION_ERROR;
2627: END IF;
2628: DELETE FROM OKL_CRTRN_USER_VALS_TL
2629: WHERE ID = l_okl_crtrn_user_vals_tl_rec.id;
2630:
2631: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
2632: EXCEPTION

Line 2629: WHERE ID = l_okl_crtrn_user_vals_tl_rec.id;

2625: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
2626: RAISE okl_api.G_EXCEPTION_ERROR;
2627: END IF;
2628: DELETE FROM OKL_CRTRN_USER_VALS_TL
2629: WHERE ID = l_okl_crtrn_user_vals_tl_rec.id;
2630:
2631: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
2632: EXCEPTION
2633: WHEN okl_api.G_EXCEPTION_ERROR THEN

Line 2679: l_okl_crtrn_user_vals_tl_rec OklCrtrnUserValsTlRecType;

2675: l_api_version CONSTANT NUMBER := 1;
2676: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
2677: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2678: l_cuvv_rec cuvv_rec_type := p_cuvv_rec;
2679: l_okl_crtrn_user_vals_tl_rec OklCrtrnUserValsTlRecType;
2680: l_cuv_rec cuv_rec_type;
2681: BEGIN
2682: l_return_status := okl_api.START_ACTIVITY(l_api_name,
2683: G_PKG_NAME,

Line 2697: migrate(l_cuvv_rec, l_okl_crtrn_user_vals_tl_rec);

2693: END IF;
2694: --------------------------------------
2695: -- Move VIEW record to "Child" records
2696: --------------------------------------
2697: migrate(l_cuvv_rec, l_okl_crtrn_user_vals_tl_rec);
2698: migrate(l_cuvv_rec, l_cuv_rec);
2699: --------------------------------------------
2700: -- Call the DELETE_ROW for each child record
2701: --------------------------------------------

Line 2707: l_okl_crtrn_user_vals_tl_rec

2703: p_init_msg_list,
2704: x_return_status,
2705: x_msg_count,
2706: x_msg_data,
2707: l_okl_crtrn_user_vals_tl_rec
2708: );
2709: IF (x_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
2710: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
2711: ELSIF (x_return_status = okl_api.G_RET_STS_ERROR) THEN