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_ASR_PVT dependencies on OKL_ANSR_SET_CRTRIA_TL

Line 212: DELETE FROM OKL_ANSR_SET_CRTRIA_TL T

208: -- PROCEDURE add_language
209: ---------------------------------------------------------------------------
210: PROCEDURE add_language IS
211: BEGIN
212: DELETE FROM OKL_ANSR_SET_CRTRIA_TL T
213: WHERE NOT EXISTS (
214: SELECT NULL
215: FROM OKL_ANSR_SET_CRTRIA_B B --fixed bug 3321017 by kmotepal
216: WHERE B.ID = T.ID

Line 219: UPDATE OKL_ANSR_SET_CRTRIA_TL T SET (

215: FROM OKL_ANSR_SET_CRTRIA_B B --fixed bug 3321017 by kmotepal
216: WHERE B.ID = T.ID
217: );
218:
219: UPDATE OKL_ANSR_SET_CRTRIA_TL T SET (
220: DESCRIPTION) = (SELECT
221: B.DESCRIPTION
222: FROM OKL_ANSR_SET_CRTRIA_TL B
223: WHERE B.ID = T.ID

Line 222: FROM OKL_ANSR_SET_CRTRIA_TL B

218:
219: UPDATE OKL_ANSR_SET_CRTRIA_TL T SET (
220: DESCRIPTION) = (SELECT
221: B.DESCRIPTION
222: FROM OKL_ANSR_SET_CRTRIA_TL B
223: WHERE B.ID = T.ID
224: AND B.LANGUAGE = T.SOURCE_LANG)
225: WHERE (
226: T.ID,

Line 231: FROM OKL_ANSR_SET_CRTRIA_TL SUBB, OKL_ANSR_SET_CRTRIA_TL SUBT

227: T.LANGUAGE)
228: IN (SELECT
229: SUBT.ID,
230: SUBT.LANGUAGE
231: FROM OKL_ANSR_SET_CRTRIA_TL SUBB, OKL_ANSR_SET_CRTRIA_TL SUBT
232: WHERE SUBB.ID = SUBT.ID
233: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
234: AND (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
235: OR (SUBB.DESCRIPTION IS NULL AND SUBT.DESCRIPTION IS NOT NULL)

Line 239: INSERT INTO OKL_ANSR_SET_CRTRIA_TL (

235: OR (SUBB.DESCRIPTION IS NULL AND SUBT.DESCRIPTION IS NOT NULL)
236: OR (SUBB.DESCRIPTION IS NOT NULL AND SUBT.DESCRIPTION IS NULL)
237: ));
238:
239: INSERT INTO OKL_ANSR_SET_CRTRIA_TL (
240: ID,
241: LANGUAGE,
242: SOURCE_LANG,
243: SFWT_FLAG,

Line 261: FROM OKL_ANSR_SET_CRTRIA_TL B, FND_LANGUAGES L

257: B.CREATION_DATE,
258: B.LAST_UPDATED_BY,
259: B.LAST_UPDATE_DATE,
260: B.LAST_UPDATE_LOGIN
261: FROM OKL_ANSR_SET_CRTRIA_TL B, FND_LANGUAGES L
262: WHERE L.INSTALLED_FLAG IN ('I', 'B')
263: AND B.LANGUAGE = USERENV('LANG')
264: AND NOT EXISTS(
265: SELECT NULL

Line 266: FROM OKL_ANSR_SET_CRTRIA_TL T

262: WHERE L.INSTALLED_FLAG IN ('I', 'B')
263: AND B.LANGUAGE = USERENV('LANG')
264: AND NOT EXISTS(
265: SELECT NULL
266: FROM OKL_ANSR_SET_CRTRIA_TL T
267: WHERE T.ID = B.ID
268: AND T.LANGUAGE = L.LANGUAGE_CODE
269: );
270:

Line 356: -- FUNCTION get_rec for: OKL_ANSR_SET_CRTRIA_TL

352: BEGIN
353: RETURN(get_rec(p_asr_rec, l_row_notfound));
354: END get_rec;
355: ---------------------------------------------------------------------------
356: -- FUNCTION get_rec for: OKL_ANSR_SET_CRTRIA_TL
357: ---------------------------------------------------------------------------
358: FUNCTION get_rec (
359: p_okl_ansr_set_crtria_tl_rec IN OklAnsrSetCrtriaTlRecType,
360: x_no_data_found OUT NOCOPY BOOLEAN

Line 359: p_okl_ansr_set_crtria_tl_rec IN OklAnsrSetCrtriaTlRecType,

355: ---------------------------------------------------------------------------
356: -- FUNCTION get_rec for: OKL_ANSR_SET_CRTRIA_TL
357: ---------------------------------------------------------------------------
358: FUNCTION get_rec (
359: p_okl_ansr_set_crtria_tl_rec IN OklAnsrSetCrtriaTlRecType,
360: x_no_data_found OUT NOCOPY BOOLEAN
361: ) RETURN OklAnsrSetCrtriaTlRecType IS
362: CURSOR okl_ansr_set_crtria_tl_pk_csr (p_id IN NUMBER,
363: p_language IN VARCHAR2) IS

Line 362: CURSOR okl_ansr_set_crtria_tl_pk_csr (p_id IN NUMBER,

358: FUNCTION get_rec (
359: p_okl_ansr_set_crtria_tl_rec IN OklAnsrSetCrtriaTlRecType,
360: x_no_data_found OUT NOCOPY BOOLEAN
361: ) RETURN OklAnsrSetCrtriaTlRecType IS
362: CURSOR okl_ansr_set_crtria_tl_pk_csr (p_id IN NUMBER,
363: p_language IN VARCHAR2) IS
364: SELECT
365: ID,
366: LANGUAGE,

Line 375: FROM Okl_Ansr_Set_Crtria_Tl

371: CREATION_DATE,
372: LAST_UPDATED_BY,
373: LAST_UPDATE_DATE,
374: LAST_UPDATE_LOGIN
375: FROM Okl_Ansr_Set_Crtria_Tl
376: WHERE okl_ansr_set_crtria_tl.id = p_id
377: AND okl_ansr_set_crtria_tl.LANGUAGE = p_language;
378: l_okl_ansr_set_crtria_tl_pk okl_ansr_set_crtria_tl_pk_csr%ROWTYPE;
379: l_okl_ansr_set_crtria_tl_rec OklAnsrSetCrtriaTlRecType;

Line 376: WHERE okl_ansr_set_crtria_tl.id = p_id

372: LAST_UPDATED_BY,
373: LAST_UPDATE_DATE,
374: LAST_UPDATE_LOGIN
375: FROM Okl_Ansr_Set_Crtria_Tl
376: WHERE okl_ansr_set_crtria_tl.id = p_id
377: AND okl_ansr_set_crtria_tl.LANGUAGE = p_language;
378: l_okl_ansr_set_crtria_tl_pk okl_ansr_set_crtria_tl_pk_csr%ROWTYPE;
379: l_okl_ansr_set_crtria_tl_rec OklAnsrSetCrtriaTlRecType;
380: BEGIN

Line 377: AND okl_ansr_set_crtria_tl.LANGUAGE = p_language;

373: LAST_UPDATE_DATE,
374: LAST_UPDATE_LOGIN
375: FROM Okl_Ansr_Set_Crtria_Tl
376: WHERE okl_ansr_set_crtria_tl.id = p_id
377: AND okl_ansr_set_crtria_tl.LANGUAGE = p_language;
378: l_okl_ansr_set_crtria_tl_pk okl_ansr_set_crtria_tl_pk_csr%ROWTYPE;
379: l_okl_ansr_set_crtria_tl_rec OklAnsrSetCrtriaTlRecType;
380: BEGIN
381: x_no_data_found := TRUE;

Line 378: l_okl_ansr_set_crtria_tl_pk okl_ansr_set_crtria_tl_pk_csr%ROWTYPE;

374: LAST_UPDATE_LOGIN
375: FROM Okl_Ansr_Set_Crtria_Tl
376: WHERE okl_ansr_set_crtria_tl.id = p_id
377: AND okl_ansr_set_crtria_tl.LANGUAGE = p_language;
378: l_okl_ansr_set_crtria_tl_pk okl_ansr_set_crtria_tl_pk_csr%ROWTYPE;
379: l_okl_ansr_set_crtria_tl_rec OklAnsrSetCrtriaTlRecType;
380: BEGIN
381: x_no_data_found := TRUE;
382: -- Get current database values

Line 379: l_okl_ansr_set_crtria_tl_rec OklAnsrSetCrtriaTlRecType;

375: FROM Okl_Ansr_Set_Crtria_Tl
376: WHERE okl_ansr_set_crtria_tl.id = p_id
377: AND okl_ansr_set_crtria_tl.LANGUAGE = p_language;
378: l_okl_ansr_set_crtria_tl_pk okl_ansr_set_crtria_tl_pk_csr%ROWTYPE;
379: l_okl_ansr_set_crtria_tl_rec OklAnsrSetCrtriaTlRecType;
380: BEGIN
381: x_no_data_found := TRUE;
382: -- Get current database values
383: OPEN okl_ansr_set_crtria_tl_pk_csr (p_okl_ansr_set_crtria_tl_rec.id,

Line 383: OPEN okl_ansr_set_crtria_tl_pk_csr (p_okl_ansr_set_crtria_tl_rec.id,

379: l_okl_ansr_set_crtria_tl_rec OklAnsrSetCrtriaTlRecType;
380: BEGIN
381: x_no_data_found := TRUE;
382: -- Get current database values
383: OPEN okl_ansr_set_crtria_tl_pk_csr (p_okl_ansr_set_crtria_tl_rec.id,
384: p_okl_ansr_set_crtria_tl_rec.LANGUAGE);
385: FETCH okl_ansr_set_crtria_tl_pk_csr INTO
386: l_okl_ansr_set_crtria_tl_rec.ID,
387: l_okl_ansr_set_crtria_tl_rec.LANGUAGE,

Line 384: p_okl_ansr_set_crtria_tl_rec.LANGUAGE);

380: BEGIN
381: x_no_data_found := TRUE;
382: -- Get current database values
383: OPEN okl_ansr_set_crtria_tl_pk_csr (p_okl_ansr_set_crtria_tl_rec.id,
384: p_okl_ansr_set_crtria_tl_rec.LANGUAGE);
385: FETCH okl_ansr_set_crtria_tl_pk_csr INTO
386: l_okl_ansr_set_crtria_tl_rec.ID,
387: l_okl_ansr_set_crtria_tl_rec.LANGUAGE,
388: l_okl_ansr_set_crtria_tl_rec.SOURCE_LANG,

Line 385: FETCH okl_ansr_set_crtria_tl_pk_csr INTO

381: x_no_data_found := TRUE;
382: -- Get current database values
383: OPEN okl_ansr_set_crtria_tl_pk_csr (p_okl_ansr_set_crtria_tl_rec.id,
384: p_okl_ansr_set_crtria_tl_rec.LANGUAGE);
385: FETCH okl_ansr_set_crtria_tl_pk_csr INTO
386: l_okl_ansr_set_crtria_tl_rec.ID,
387: l_okl_ansr_set_crtria_tl_rec.LANGUAGE,
388: l_okl_ansr_set_crtria_tl_rec.SOURCE_LANG,
389: l_okl_ansr_set_crtria_tl_rec.SFWT_FLAG,

Line 386: l_okl_ansr_set_crtria_tl_rec.ID,

382: -- Get current database values
383: OPEN okl_ansr_set_crtria_tl_pk_csr (p_okl_ansr_set_crtria_tl_rec.id,
384: p_okl_ansr_set_crtria_tl_rec.LANGUAGE);
385: FETCH okl_ansr_set_crtria_tl_pk_csr INTO
386: l_okl_ansr_set_crtria_tl_rec.ID,
387: l_okl_ansr_set_crtria_tl_rec.LANGUAGE,
388: l_okl_ansr_set_crtria_tl_rec.SOURCE_LANG,
389: l_okl_ansr_set_crtria_tl_rec.SFWT_FLAG,
390: l_okl_ansr_set_crtria_tl_rec.DESCRIPTION,

Line 387: l_okl_ansr_set_crtria_tl_rec.LANGUAGE,

383: OPEN okl_ansr_set_crtria_tl_pk_csr (p_okl_ansr_set_crtria_tl_rec.id,
384: p_okl_ansr_set_crtria_tl_rec.LANGUAGE);
385: FETCH okl_ansr_set_crtria_tl_pk_csr INTO
386: l_okl_ansr_set_crtria_tl_rec.ID,
387: l_okl_ansr_set_crtria_tl_rec.LANGUAGE,
388: l_okl_ansr_set_crtria_tl_rec.SOURCE_LANG,
389: l_okl_ansr_set_crtria_tl_rec.SFWT_FLAG,
390: l_okl_ansr_set_crtria_tl_rec.DESCRIPTION,
391: l_okl_ansr_set_crtria_tl_rec.CREATED_BY,

Line 388: l_okl_ansr_set_crtria_tl_rec.SOURCE_LANG,

384: p_okl_ansr_set_crtria_tl_rec.LANGUAGE);
385: FETCH okl_ansr_set_crtria_tl_pk_csr INTO
386: l_okl_ansr_set_crtria_tl_rec.ID,
387: l_okl_ansr_set_crtria_tl_rec.LANGUAGE,
388: l_okl_ansr_set_crtria_tl_rec.SOURCE_LANG,
389: l_okl_ansr_set_crtria_tl_rec.SFWT_FLAG,
390: l_okl_ansr_set_crtria_tl_rec.DESCRIPTION,
391: l_okl_ansr_set_crtria_tl_rec.CREATED_BY,
392: l_okl_ansr_set_crtria_tl_rec.CREATION_DATE,

Line 389: l_okl_ansr_set_crtria_tl_rec.SFWT_FLAG,

385: FETCH okl_ansr_set_crtria_tl_pk_csr INTO
386: l_okl_ansr_set_crtria_tl_rec.ID,
387: l_okl_ansr_set_crtria_tl_rec.LANGUAGE,
388: l_okl_ansr_set_crtria_tl_rec.SOURCE_LANG,
389: l_okl_ansr_set_crtria_tl_rec.SFWT_FLAG,
390: l_okl_ansr_set_crtria_tl_rec.DESCRIPTION,
391: l_okl_ansr_set_crtria_tl_rec.CREATED_BY,
392: l_okl_ansr_set_crtria_tl_rec.CREATION_DATE,
393: l_okl_ansr_set_crtria_tl_rec.LAST_UPDATED_BY,

Line 390: l_okl_ansr_set_crtria_tl_rec.DESCRIPTION,

386: l_okl_ansr_set_crtria_tl_rec.ID,
387: l_okl_ansr_set_crtria_tl_rec.LANGUAGE,
388: l_okl_ansr_set_crtria_tl_rec.SOURCE_LANG,
389: l_okl_ansr_set_crtria_tl_rec.SFWT_FLAG,
390: l_okl_ansr_set_crtria_tl_rec.DESCRIPTION,
391: l_okl_ansr_set_crtria_tl_rec.CREATED_BY,
392: l_okl_ansr_set_crtria_tl_rec.CREATION_DATE,
393: l_okl_ansr_set_crtria_tl_rec.LAST_UPDATED_BY,
394: l_okl_ansr_set_crtria_tl_rec.LAST_UPDATE_DATE,

Line 391: l_okl_ansr_set_crtria_tl_rec.CREATED_BY,

387: l_okl_ansr_set_crtria_tl_rec.LANGUAGE,
388: l_okl_ansr_set_crtria_tl_rec.SOURCE_LANG,
389: l_okl_ansr_set_crtria_tl_rec.SFWT_FLAG,
390: l_okl_ansr_set_crtria_tl_rec.DESCRIPTION,
391: l_okl_ansr_set_crtria_tl_rec.CREATED_BY,
392: l_okl_ansr_set_crtria_tl_rec.CREATION_DATE,
393: l_okl_ansr_set_crtria_tl_rec.LAST_UPDATED_BY,
394: l_okl_ansr_set_crtria_tl_rec.LAST_UPDATE_DATE,
395: l_okl_ansr_set_crtria_tl_rec.LAST_UPDATE_LOGIN;

Line 392: l_okl_ansr_set_crtria_tl_rec.CREATION_DATE,

388: l_okl_ansr_set_crtria_tl_rec.SOURCE_LANG,
389: l_okl_ansr_set_crtria_tl_rec.SFWT_FLAG,
390: l_okl_ansr_set_crtria_tl_rec.DESCRIPTION,
391: l_okl_ansr_set_crtria_tl_rec.CREATED_BY,
392: l_okl_ansr_set_crtria_tl_rec.CREATION_DATE,
393: l_okl_ansr_set_crtria_tl_rec.LAST_UPDATED_BY,
394: l_okl_ansr_set_crtria_tl_rec.LAST_UPDATE_DATE,
395: l_okl_ansr_set_crtria_tl_rec.LAST_UPDATE_LOGIN;
396: x_no_data_found := okl_ansr_set_crtria_tl_pk_csr%NOTFOUND;

Line 393: l_okl_ansr_set_crtria_tl_rec.LAST_UPDATED_BY,

389: l_okl_ansr_set_crtria_tl_rec.SFWT_FLAG,
390: l_okl_ansr_set_crtria_tl_rec.DESCRIPTION,
391: l_okl_ansr_set_crtria_tl_rec.CREATED_BY,
392: l_okl_ansr_set_crtria_tl_rec.CREATION_DATE,
393: l_okl_ansr_set_crtria_tl_rec.LAST_UPDATED_BY,
394: l_okl_ansr_set_crtria_tl_rec.LAST_UPDATE_DATE,
395: l_okl_ansr_set_crtria_tl_rec.LAST_UPDATE_LOGIN;
396: x_no_data_found := okl_ansr_set_crtria_tl_pk_csr%NOTFOUND;
397: CLOSE okl_ansr_set_crtria_tl_pk_csr;

Line 394: l_okl_ansr_set_crtria_tl_rec.LAST_UPDATE_DATE,

390: l_okl_ansr_set_crtria_tl_rec.DESCRIPTION,
391: l_okl_ansr_set_crtria_tl_rec.CREATED_BY,
392: l_okl_ansr_set_crtria_tl_rec.CREATION_DATE,
393: l_okl_ansr_set_crtria_tl_rec.LAST_UPDATED_BY,
394: l_okl_ansr_set_crtria_tl_rec.LAST_UPDATE_DATE,
395: l_okl_ansr_set_crtria_tl_rec.LAST_UPDATE_LOGIN;
396: x_no_data_found := okl_ansr_set_crtria_tl_pk_csr%NOTFOUND;
397: CLOSE okl_ansr_set_crtria_tl_pk_csr;
398: RETURN(l_okl_ansr_set_crtria_tl_rec);

Line 395: l_okl_ansr_set_crtria_tl_rec.LAST_UPDATE_LOGIN;

391: l_okl_ansr_set_crtria_tl_rec.CREATED_BY,
392: l_okl_ansr_set_crtria_tl_rec.CREATION_DATE,
393: l_okl_ansr_set_crtria_tl_rec.LAST_UPDATED_BY,
394: l_okl_ansr_set_crtria_tl_rec.LAST_UPDATE_DATE,
395: l_okl_ansr_set_crtria_tl_rec.LAST_UPDATE_LOGIN;
396: x_no_data_found := okl_ansr_set_crtria_tl_pk_csr%NOTFOUND;
397: CLOSE okl_ansr_set_crtria_tl_pk_csr;
398: RETURN(l_okl_ansr_set_crtria_tl_rec);
399: END get_rec;

Line 396: x_no_data_found := okl_ansr_set_crtria_tl_pk_csr%NOTFOUND;

392: l_okl_ansr_set_crtria_tl_rec.CREATION_DATE,
393: l_okl_ansr_set_crtria_tl_rec.LAST_UPDATED_BY,
394: l_okl_ansr_set_crtria_tl_rec.LAST_UPDATE_DATE,
395: l_okl_ansr_set_crtria_tl_rec.LAST_UPDATE_LOGIN;
396: x_no_data_found := okl_ansr_set_crtria_tl_pk_csr%NOTFOUND;
397: CLOSE okl_ansr_set_crtria_tl_pk_csr;
398: RETURN(l_okl_ansr_set_crtria_tl_rec);
399: END get_rec;
400:

Line 397: CLOSE okl_ansr_set_crtria_tl_pk_csr;

393: l_okl_ansr_set_crtria_tl_rec.LAST_UPDATED_BY,
394: l_okl_ansr_set_crtria_tl_rec.LAST_UPDATE_DATE,
395: l_okl_ansr_set_crtria_tl_rec.LAST_UPDATE_LOGIN;
396: x_no_data_found := okl_ansr_set_crtria_tl_pk_csr%NOTFOUND;
397: CLOSE okl_ansr_set_crtria_tl_pk_csr;
398: RETURN(l_okl_ansr_set_crtria_tl_rec);
399: END get_rec;
400:
401: FUNCTION get_rec (

Line 398: RETURN(l_okl_ansr_set_crtria_tl_rec);

394: l_okl_ansr_set_crtria_tl_rec.LAST_UPDATE_DATE,
395: l_okl_ansr_set_crtria_tl_rec.LAST_UPDATE_LOGIN;
396: x_no_data_found := okl_ansr_set_crtria_tl_pk_csr%NOTFOUND;
397: CLOSE okl_ansr_set_crtria_tl_pk_csr;
398: RETURN(l_okl_ansr_set_crtria_tl_rec);
399: END get_rec;
400:
401: FUNCTION get_rec (
402: p_okl_ansr_set_crtria_tl_rec IN OklAnsrSetCrtriaTlRecType

Line 402: p_okl_ansr_set_crtria_tl_rec IN OklAnsrSetCrtriaTlRecType

398: RETURN(l_okl_ansr_set_crtria_tl_rec);
399: END get_rec;
400:
401: FUNCTION get_rec (
402: p_okl_ansr_set_crtria_tl_rec IN OklAnsrSetCrtriaTlRecType
403: ) RETURN OklAnsrSetCrtriaTlRecType IS
404: l_row_notfound BOOLEAN := TRUE;
405: BEGIN
406: RETURN(get_rec(p_okl_ansr_set_crtria_tl_rec, l_row_notfound));

Line 406: RETURN(get_rec(p_okl_ansr_set_crtria_tl_rec, l_row_notfound));

402: p_okl_ansr_set_crtria_tl_rec IN OklAnsrSetCrtriaTlRecType
403: ) RETURN OklAnsrSetCrtriaTlRecType IS
404: l_row_notfound BOOLEAN := TRUE;
405: BEGIN
406: RETURN(get_rec(p_okl_ansr_set_crtria_tl_rec, l_row_notfound));
407: END get_rec;
408: ---------------------------------------------------------------------------
409: -- FUNCTION get_rec for: OKL_ANSR_SET_CRTRIA_V
410: ---------------------------------------------------------------------------

Line 784: l_okl_ansr_set_crtria_tl_rec OklAnsrSetCrtriaTlRecType;

780: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
781: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
782: l_asrv_rec asrv_rec_type := p_asrv_rec;
783: l_asr_rec asr_rec_type;
784: l_okl_ansr_set_crtria_tl_rec OklAnsrSetCrtriaTlRecType;
785: BEGIN
786: l_return_status := okl_api.START_ACTIVITY(l_api_name,
787: G_PKG_NAME,
788: p_init_msg_list,

Line 1051: -- insert_row for:OKL_ANSR_SET_CRTRIA_TL --

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

Line 1058: p_okl_ansr_set_crtria_tl_rec IN OklAnsrSetCrtriaTlRecType,

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

Line 1059: x_okl_ansr_set_crtria_tl_rec OUT NOCOPY OklAnsrSetCrtriaTlRecType) IS

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

Line 1064: l_okl_ansr_set_crtria_tl_rec OklAnsrSetCrtriaTlRecType := p_okl_ansr_set_crtria_tl_rec;

1060:
1061: l_api_version CONSTANT NUMBER := 1;
1062: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1063: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
1064: l_okl_ansr_set_crtria_tl_rec OklAnsrSetCrtriaTlRecType := p_okl_ansr_set_crtria_tl_rec;
1065: ldefoklansrsetcrtriatlrec OklAnsrSetCrtriaTlRecType;
1066: CURSOR get_languages IS
1067: SELECT *
1068: FROM FND_LANGUAGES

Line 1071: -- Set_Attributes for:OKL_ANSR_SET_CRTRIA_TL --

1067: SELECT *
1068: FROM FND_LANGUAGES
1069: WHERE INSTALLED_FLAG IN ('I', 'B');
1070: -----------------------------------------------
1071: -- Set_Attributes for:OKL_ANSR_SET_CRTRIA_TL --
1072: -----------------------------------------------
1073: FUNCTION Set_Attributes (
1074: p_okl_ansr_set_crtria_tl_rec IN OklAnsrSetCrtriaTlRecType,
1075: x_okl_ansr_set_crtria_tl_rec OUT NOCOPY OklAnsrSetCrtriaTlRecType

Line 1074: p_okl_ansr_set_crtria_tl_rec IN OklAnsrSetCrtriaTlRecType,

1070: -----------------------------------------------
1071: -- Set_Attributes for:OKL_ANSR_SET_CRTRIA_TL --
1072: -----------------------------------------------
1073: FUNCTION Set_Attributes (
1074: p_okl_ansr_set_crtria_tl_rec IN OklAnsrSetCrtriaTlRecType,
1075: x_okl_ansr_set_crtria_tl_rec OUT NOCOPY OklAnsrSetCrtriaTlRecType
1076: ) RETURN VARCHAR2 IS
1077: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
1078: BEGIN

Line 1075: x_okl_ansr_set_crtria_tl_rec OUT NOCOPY OklAnsrSetCrtriaTlRecType

1071: -- Set_Attributes for:OKL_ANSR_SET_CRTRIA_TL --
1072: -----------------------------------------------
1073: FUNCTION Set_Attributes (
1074: p_okl_ansr_set_crtria_tl_rec IN OklAnsrSetCrtriaTlRecType,
1075: x_okl_ansr_set_crtria_tl_rec OUT NOCOPY OklAnsrSetCrtriaTlRecType
1076: ) RETURN VARCHAR2 IS
1077: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
1078: BEGIN
1079: x_okl_ansr_set_crtria_tl_rec := p_okl_ansr_set_crtria_tl_rec;

Line 1079: x_okl_ansr_set_crtria_tl_rec := p_okl_ansr_set_crtria_tl_rec;

1075: x_okl_ansr_set_crtria_tl_rec OUT NOCOPY OklAnsrSetCrtriaTlRecType
1076: ) RETURN VARCHAR2 IS
1077: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
1078: BEGIN
1079: x_okl_ansr_set_crtria_tl_rec := p_okl_ansr_set_crtria_tl_rec;
1080: x_okl_ansr_set_crtria_tl_rec.LANGUAGE := USERENV('LANG');
1081: x_okl_ansr_set_crtria_tl_rec.SOURCE_LANG := USERENV('LANG');
1082: RETURN(l_return_status);
1083: END Set_Attributes;

Line 1080: x_okl_ansr_set_crtria_tl_rec.LANGUAGE := USERENV('LANG');

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

Line 1081: x_okl_ansr_set_crtria_tl_rec.SOURCE_LANG := USERENV('LANG');

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

Line 1096: p_okl_ansr_set_crtria_tl_rec, -- IN

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

Line 1097: l_okl_ansr_set_crtria_tl_rec); -- OUT

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

Line 1105: l_okl_ansr_set_crtria_tl_rec.LANGUAGE := l_lang_rec.language_code;

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

Line 1106: INSERT INTO OKL_ANSR_SET_CRTRIA_TL(

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

Line 1118: l_okl_ansr_set_crtria_tl_rec.id,

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

Line 1119: l_okl_ansr_set_crtria_tl_rec.LANGUAGE,

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

Line 1120: l_okl_ansr_set_crtria_tl_rec.source_lang,

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

Line 1121: l_okl_ansr_set_crtria_tl_rec.sfwt_flag,

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

Line 1122: l_okl_ansr_set_crtria_tl_rec.description,

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

Line 1123: l_okl_ansr_set_crtria_tl_rec.created_by,

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

Line 1124: l_okl_ansr_set_crtria_tl_rec.creation_date,

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

Line 1125: l_okl_ansr_set_crtria_tl_rec.last_updated_by,

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

Line 1126: l_okl_ansr_set_crtria_tl_rec.last_update_date,

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

Line 1127: l_okl_ansr_set_crtria_tl_rec.last_update_login);

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

Line 1130: x_okl_ansr_set_crtria_tl_rec := l_okl_ansr_set_crtria_tl_rec;

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

Line 1183: l_okl_ansr_set_crtria_tl_rec OklAnsrSetCrtriaTlRecType;

1179: l_asrv_rec asrv_rec_type;
1180: l_def_asrv_rec asrv_rec_type;
1181: l_asr_rec asr_rec_type;
1182: lx_asr_rec asr_rec_type;
1183: l_okl_ansr_set_crtria_tl_rec OklAnsrSetCrtriaTlRecType;
1184: lx_okl_ansr_set_crtria_tl_rec OklAnsrSetCrtriaTlRecType;
1185: -------------------------------
1186: -- FUNCTION fill_who_columns --
1187: -------------------------------

Line 1184: lx_okl_ansr_set_crtria_tl_rec OklAnsrSetCrtriaTlRecType;

1180: l_def_asrv_rec asrv_rec_type;
1181: l_asr_rec asr_rec_type;
1182: lx_asr_rec asr_rec_type;
1183: l_okl_ansr_set_crtria_tl_rec OklAnsrSetCrtriaTlRecType;
1184: lx_okl_ansr_set_crtria_tl_rec OklAnsrSetCrtriaTlRecType;
1185: -------------------------------
1186: -- FUNCTION fill_who_columns --
1187: -------------------------------
1188: FUNCTION fill_who_columns (

Line 1259: migrate(l_def_asrv_rec, l_okl_ansr_set_crtria_tl_rec);

1255: --------------------------------------
1256: -- Move VIEW record to "Child" records
1257: --------------------------------------
1258: migrate(l_def_asrv_rec, l_asr_rec);
1259: migrate(l_def_asrv_rec, l_okl_ansr_set_crtria_tl_rec);
1260: --------------------------------------------
1261: -- Call the INSERT_ROW for each child record
1262: --------------------------------------------
1263: insert_row(

Line 1282: l_okl_ansr_set_crtria_tl_rec,

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

Line 1283: lx_okl_ansr_set_crtria_tl_rec

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

Line 1290: migrate(lx_okl_ansr_set_crtria_tl_rec, l_def_asrv_rec);

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

Line 1503: -- lock_row for:OKL_ANSR_SET_CRTRIA_TL --

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

Line 1510: p_okl_ansr_set_crtria_tl_rec IN OklAnsrSetCrtriaTlRecType) IS

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

Line 1514: CURSOR lock_csr (p_okl_ansr_set_crtria_tl_rec IN OklAnsrSetCrtriaTlRecType) IS

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

Line 1516: FROM OKL_ANSR_SET_CRTRIA_TL

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

Line 1517: WHERE ID = p_okl_ansr_set_crtria_tl_rec.id

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

Line 1537: OPEN lock_csr(p_okl_ansr_set_crtria_tl_rec);

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

Line 1602: l_okl_ansr_set_crtria_tl_rec OklAnsrSetCrtriaTlRecType;

1598: l_api_version CONSTANT NUMBER := 1;
1599: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1600: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
1601: l_asr_rec asr_rec_type;
1602: l_okl_ansr_set_crtria_tl_rec OklAnsrSetCrtriaTlRecType;
1603: BEGIN
1604: l_return_status := okl_api.START_ACTIVITY(l_api_name,
1605: G_PKG_NAME,
1606: p_init_msg_list,

Line 1620: migrate(p_asrv_rec, l_okl_ansr_set_crtria_tl_rec);

1616: --------------------------------------
1617: -- Move VIEW record to "Child" records
1618: --------------------------------------
1619: migrate(p_asrv_rec, l_asr_rec);
1620: migrate(p_asrv_rec, l_okl_ansr_set_crtria_tl_rec);
1621: --------------------------------------------
1622: -- Call the LOCK_ROW for each child record
1623: --------------------------------------------
1624: lock_row(

Line 1641: l_okl_ansr_set_crtria_tl_rec

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

Line 1990: -- update_row for:OKL_ANSR_SET_CRTRIA_TL --

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

Line 1997: p_okl_ansr_set_crtria_tl_rec IN OklAnsrSetCrtriaTlRecType,

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

Line 1998: x_okl_ansr_set_crtria_tl_rec OUT NOCOPY OklAnsrSetCrtriaTlRecType) IS

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

Line 2003: l_okl_ansr_set_crtria_tl_rec OklAnsrSetCrtriaTlRecType := p_okl_ansr_set_crtria_tl_rec;

1999:
2000: l_api_version CONSTANT NUMBER := 1;
2001: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2002: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2003: l_okl_ansr_set_crtria_tl_rec OklAnsrSetCrtriaTlRecType := p_okl_ansr_set_crtria_tl_rec;
2004: ldefoklansrsetcrtriatlrec OklAnsrSetCrtriaTlRecType;
2005: l_row_notfound BOOLEAN := TRUE;
2006: ----------------------------------
2007: -- FUNCTION populate_new_record --

Line 2010: p_okl_ansr_set_crtria_tl_rec IN OklAnsrSetCrtriaTlRecType,

2006: ----------------------------------
2007: -- FUNCTION populate_new_record --
2008: ----------------------------------
2009: FUNCTION populate_new_record (
2010: p_okl_ansr_set_crtria_tl_rec IN OklAnsrSetCrtriaTlRecType,
2011: x_okl_ansr_set_crtria_tl_rec OUT NOCOPY OklAnsrSetCrtriaTlRecType
2012: ) RETURN VARCHAR2 IS
2013: l_okl_ansr_set_crtria_tl_rec OklAnsrSetCrtriaTlRecType;
2014: l_row_notfound BOOLEAN := TRUE;

Line 2011: x_okl_ansr_set_crtria_tl_rec OUT NOCOPY OklAnsrSetCrtriaTlRecType

2007: -- FUNCTION populate_new_record --
2008: ----------------------------------
2009: FUNCTION populate_new_record (
2010: p_okl_ansr_set_crtria_tl_rec IN OklAnsrSetCrtriaTlRecType,
2011: x_okl_ansr_set_crtria_tl_rec OUT NOCOPY OklAnsrSetCrtriaTlRecType
2012: ) RETURN VARCHAR2 IS
2013: l_okl_ansr_set_crtria_tl_rec OklAnsrSetCrtriaTlRecType;
2014: l_row_notfound BOOLEAN := TRUE;
2015: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;

Line 2013: l_okl_ansr_set_crtria_tl_rec OklAnsrSetCrtriaTlRecType;

2009: FUNCTION populate_new_record (
2010: p_okl_ansr_set_crtria_tl_rec IN OklAnsrSetCrtriaTlRecType,
2011: x_okl_ansr_set_crtria_tl_rec OUT NOCOPY OklAnsrSetCrtriaTlRecType
2012: ) RETURN VARCHAR2 IS
2013: l_okl_ansr_set_crtria_tl_rec OklAnsrSetCrtriaTlRecType;
2014: l_row_notfound BOOLEAN := TRUE;
2015: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2016: BEGIN
2017: x_okl_ansr_set_crtria_tl_rec := p_okl_ansr_set_crtria_tl_rec;

Line 2017: x_okl_ansr_set_crtria_tl_rec := p_okl_ansr_set_crtria_tl_rec;

2013: l_okl_ansr_set_crtria_tl_rec OklAnsrSetCrtriaTlRecType;
2014: l_row_notfound BOOLEAN := TRUE;
2015: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2016: BEGIN
2017: x_okl_ansr_set_crtria_tl_rec := p_okl_ansr_set_crtria_tl_rec;
2018: -- Get current database values
2019: l_okl_ansr_set_crtria_tl_rec := get_rec(p_okl_ansr_set_crtria_tl_rec, l_row_notfound);
2020: IF (l_row_notfound) THEN
2021: l_return_status := okl_api.G_RET_STS_UNEXP_ERROR;

Line 2019: l_okl_ansr_set_crtria_tl_rec := get_rec(p_okl_ansr_set_crtria_tl_rec, l_row_notfound);

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

Line 2023: IF (x_okl_ansr_set_crtria_tl_rec.id = okl_api.G_MISS_NUM)

2019: l_okl_ansr_set_crtria_tl_rec := get_rec(p_okl_ansr_set_crtria_tl_rec, l_row_notfound);
2020: IF (l_row_notfound) THEN
2021: l_return_status := okl_api.G_RET_STS_UNEXP_ERROR;
2022: END IF;
2023: IF (x_okl_ansr_set_crtria_tl_rec.id = okl_api.G_MISS_NUM)
2024: THEN
2025: x_okl_ansr_set_crtria_tl_rec.id := l_okl_ansr_set_crtria_tl_rec.id;
2026: END IF;
2027: IF (x_okl_ansr_set_crtria_tl_rec.LANGUAGE = okl_api.G_MISS_CHAR)

Line 2025: x_okl_ansr_set_crtria_tl_rec.id := l_okl_ansr_set_crtria_tl_rec.id;

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

Line 2027: IF (x_okl_ansr_set_crtria_tl_rec.LANGUAGE = okl_api.G_MISS_CHAR)

2023: IF (x_okl_ansr_set_crtria_tl_rec.id = okl_api.G_MISS_NUM)
2024: THEN
2025: x_okl_ansr_set_crtria_tl_rec.id := l_okl_ansr_set_crtria_tl_rec.id;
2026: END IF;
2027: IF (x_okl_ansr_set_crtria_tl_rec.LANGUAGE = okl_api.G_MISS_CHAR)
2028: THEN
2029: x_okl_ansr_set_crtria_tl_rec.LANGUAGE := l_okl_ansr_set_crtria_tl_rec.LANGUAGE;
2030: END IF;
2031: IF (x_okl_ansr_set_crtria_tl_rec.source_lang = okl_api.G_MISS_CHAR)

Line 2029: x_okl_ansr_set_crtria_tl_rec.LANGUAGE := l_okl_ansr_set_crtria_tl_rec.LANGUAGE;

2025: x_okl_ansr_set_crtria_tl_rec.id := l_okl_ansr_set_crtria_tl_rec.id;
2026: END IF;
2027: IF (x_okl_ansr_set_crtria_tl_rec.LANGUAGE = okl_api.G_MISS_CHAR)
2028: THEN
2029: x_okl_ansr_set_crtria_tl_rec.LANGUAGE := l_okl_ansr_set_crtria_tl_rec.LANGUAGE;
2030: END IF;
2031: IF (x_okl_ansr_set_crtria_tl_rec.source_lang = okl_api.G_MISS_CHAR)
2032: THEN
2033: x_okl_ansr_set_crtria_tl_rec.source_lang := l_okl_ansr_set_crtria_tl_rec.source_lang;

Line 2031: IF (x_okl_ansr_set_crtria_tl_rec.source_lang = okl_api.G_MISS_CHAR)

2027: IF (x_okl_ansr_set_crtria_tl_rec.LANGUAGE = okl_api.G_MISS_CHAR)
2028: THEN
2029: x_okl_ansr_set_crtria_tl_rec.LANGUAGE := l_okl_ansr_set_crtria_tl_rec.LANGUAGE;
2030: END IF;
2031: IF (x_okl_ansr_set_crtria_tl_rec.source_lang = okl_api.G_MISS_CHAR)
2032: THEN
2033: x_okl_ansr_set_crtria_tl_rec.source_lang := l_okl_ansr_set_crtria_tl_rec.source_lang;
2034: END IF;
2035: IF (x_okl_ansr_set_crtria_tl_rec.sfwt_flag = okl_api.G_MISS_CHAR)

Line 2033: x_okl_ansr_set_crtria_tl_rec.source_lang := l_okl_ansr_set_crtria_tl_rec.source_lang;

2029: x_okl_ansr_set_crtria_tl_rec.LANGUAGE := l_okl_ansr_set_crtria_tl_rec.LANGUAGE;
2030: END IF;
2031: IF (x_okl_ansr_set_crtria_tl_rec.source_lang = okl_api.G_MISS_CHAR)
2032: THEN
2033: x_okl_ansr_set_crtria_tl_rec.source_lang := l_okl_ansr_set_crtria_tl_rec.source_lang;
2034: END IF;
2035: IF (x_okl_ansr_set_crtria_tl_rec.sfwt_flag = okl_api.G_MISS_CHAR)
2036: THEN
2037: x_okl_ansr_set_crtria_tl_rec.sfwt_flag := l_okl_ansr_set_crtria_tl_rec.sfwt_flag;

Line 2035: IF (x_okl_ansr_set_crtria_tl_rec.sfwt_flag = okl_api.G_MISS_CHAR)

2031: IF (x_okl_ansr_set_crtria_tl_rec.source_lang = okl_api.G_MISS_CHAR)
2032: THEN
2033: x_okl_ansr_set_crtria_tl_rec.source_lang := l_okl_ansr_set_crtria_tl_rec.source_lang;
2034: END IF;
2035: IF (x_okl_ansr_set_crtria_tl_rec.sfwt_flag = okl_api.G_MISS_CHAR)
2036: THEN
2037: x_okl_ansr_set_crtria_tl_rec.sfwt_flag := l_okl_ansr_set_crtria_tl_rec.sfwt_flag;
2038: END IF;
2039: IF (x_okl_ansr_set_crtria_tl_rec.description = okl_api.G_MISS_CHAR)

Line 2037: x_okl_ansr_set_crtria_tl_rec.sfwt_flag := l_okl_ansr_set_crtria_tl_rec.sfwt_flag;

2033: x_okl_ansr_set_crtria_tl_rec.source_lang := l_okl_ansr_set_crtria_tl_rec.source_lang;
2034: END IF;
2035: IF (x_okl_ansr_set_crtria_tl_rec.sfwt_flag = okl_api.G_MISS_CHAR)
2036: THEN
2037: x_okl_ansr_set_crtria_tl_rec.sfwt_flag := l_okl_ansr_set_crtria_tl_rec.sfwt_flag;
2038: END IF;
2039: IF (x_okl_ansr_set_crtria_tl_rec.description = okl_api.G_MISS_CHAR)
2040: THEN
2041: x_okl_ansr_set_crtria_tl_rec.description := l_okl_ansr_set_crtria_tl_rec.description;

Line 2039: IF (x_okl_ansr_set_crtria_tl_rec.description = okl_api.G_MISS_CHAR)

2035: IF (x_okl_ansr_set_crtria_tl_rec.sfwt_flag = okl_api.G_MISS_CHAR)
2036: THEN
2037: x_okl_ansr_set_crtria_tl_rec.sfwt_flag := l_okl_ansr_set_crtria_tl_rec.sfwt_flag;
2038: END IF;
2039: IF (x_okl_ansr_set_crtria_tl_rec.description = okl_api.G_MISS_CHAR)
2040: THEN
2041: x_okl_ansr_set_crtria_tl_rec.description := l_okl_ansr_set_crtria_tl_rec.description;
2042: END IF;
2043: IF (x_okl_ansr_set_crtria_tl_rec.created_by = okl_api.G_MISS_NUM)

Line 2041: x_okl_ansr_set_crtria_tl_rec.description := l_okl_ansr_set_crtria_tl_rec.description;

2037: x_okl_ansr_set_crtria_tl_rec.sfwt_flag := l_okl_ansr_set_crtria_tl_rec.sfwt_flag;
2038: END IF;
2039: IF (x_okl_ansr_set_crtria_tl_rec.description = okl_api.G_MISS_CHAR)
2040: THEN
2041: x_okl_ansr_set_crtria_tl_rec.description := l_okl_ansr_set_crtria_tl_rec.description;
2042: END IF;
2043: IF (x_okl_ansr_set_crtria_tl_rec.created_by = okl_api.G_MISS_NUM)
2044: THEN
2045: x_okl_ansr_set_crtria_tl_rec.created_by := l_okl_ansr_set_crtria_tl_rec.created_by;

Line 2043: IF (x_okl_ansr_set_crtria_tl_rec.created_by = okl_api.G_MISS_NUM)

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

Line 2045: x_okl_ansr_set_crtria_tl_rec.created_by := l_okl_ansr_set_crtria_tl_rec.created_by;

2041: x_okl_ansr_set_crtria_tl_rec.description := l_okl_ansr_set_crtria_tl_rec.description;
2042: END IF;
2043: IF (x_okl_ansr_set_crtria_tl_rec.created_by = okl_api.G_MISS_NUM)
2044: THEN
2045: x_okl_ansr_set_crtria_tl_rec.created_by := l_okl_ansr_set_crtria_tl_rec.created_by;
2046: END IF;
2047: IF (x_okl_ansr_set_crtria_tl_rec.creation_date = okl_api.G_MISS_DATE)
2048: THEN
2049: x_okl_ansr_set_crtria_tl_rec.creation_date := l_okl_ansr_set_crtria_tl_rec.creation_date;

Line 2047: IF (x_okl_ansr_set_crtria_tl_rec.creation_date = okl_api.G_MISS_DATE)

2043: IF (x_okl_ansr_set_crtria_tl_rec.created_by = okl_api.G_MISS_NUM)
2044: THEN
2045: x_okl_ansr_set_crtria_tl_rec.created_by := l_okl_ansr_set_crtria_tl_rec.created_by;
2046: END IF;
2047: IF (x_okl_ansr_set_crtria_tl_rec.creation_date = okl_api.G_MISS_DATE)
2048: THEN
2049: x_okl_ansr_set_crtria_tl_rec.creation_date := l_okl_ansr_set_crtria_tl_rec.creation_date;
2050: END IF;
2051: IF (x_okl_ansr_set_crtria_tl_rec.last_updated_by = okl_api.G_MISS_NUM)

Line 2049: x_okl_ansr_set_crtria_tl_rec.creation_date := l_okl_ansr_set_crtria_tl_rec.creation_date;

2045: x_okl_ansr_set_crtria_tl_rec.created_by := l_okl_ansr_set_crtria_tl_rec.created_by;
2046: END IF;
2047: IF (x_okl_ansr_set_crtria_tl_rec.creation_date = okl_api.G_MISS_DATE)
2048: THEN
2049: x_okl_ansr_set_crtria_tl_rec.creation_date := l_okl_ansr_set_crtria_tl_rec.creation_date;
2050: END IF;
2051: IF (x_okl_ansr_set_crtria_tl_rec.last_updated_by = okl_api.G_MISS_NUM)
2052: THEN
2053: x_okl_ansr_set_crtria_tl_rec.last_updated_by := l_okl_ansr_set_crtria_tl_rec.last_updated_by;

Line 2051: IF (x_okl_ansr_set_crtria_tl_rec.last_updated_by = okl_api.G_MISS_NUM)

2047: IF (x_okl_ansr_set_crtria_tl_rec.creation_date = okl_api.G_MISS_DATE)
2048: THEN
2049: x_okl_ansr_set_crtria_tl_rec.creation_date := l_okl_ansr_set_crtria_tl_rec.creation_date;
2050: END IF;
2051: IF (x_okl_ansr_set_crtria_tl_rec.last_updated_by = okl_api.G_MISS_NUM)
2052: THEN
2053: x_okl_ansr_set_crtria_tl_rec.last_updated_by := l_okl_ansr_set_crtria_tl_rec.last_updated_by;
2054: END IF;
2055: IF (x_okl_ansr_set_crtria_tl_rec.last_update_date = okl_api.G_MISS_DATE)

Line 2053: x_okl_ansr_set_crtria_tl_rec.last_updated_by := l_okl_ansr_set_crtria_tl_rec.last_updated_by;

2049: x_okl_ansr_set_crtria_tl_rec.creation_date := l_okl_ansr_set_crtria_tl_rec.creation_date;
2050: END IF;
2051: IF (x_okl_ansr_set_crtria_tl_rec.last_updated_by = okl_api.G_MISS_NUM)
2052: THEN
2053: x_okl_ansr_set_crtria_tl_rec.last_updated_by := l_okl_ansr_set_crtria_tl_rec.last_updated_by;
2054: END IF;
2055: IF (x_okl_ansr_set_crtria_tl_rec.last_update_date = okl_api.G_MISS_DATE)
2056: THEN
2057: x_okl_ansr_set_crtria_tl_rec.last_update_date := l_okl_ansr_set_crtria_tl_rec.last_update_date;

Line 2055: IF (x_okl_ansr_set_crtria_tl_rec.last_update_date = okl_api.G_MISS_DATE)

2051: IF (x_okl_ansr_set_crtria_tl_rec.last_updated_by = okl_api.G_MISS_NUM)
2052: THEN
2053: x_okl_ansr_set_crtria_tl_rec.last_updated_by := l_okl_ansr_set_crtria_tl_rec.last_updated_by;
2054: END IF;
2055: IF (x_okl_ansr_set_crtria_tl_rec.last_update_date = okl_api.G_MISS_DATE)
2056: THEN
2057: x_okl_ansr_set_crtria_tl_rec.last_update_date := l_okl_ansr_set_crtria_tl_rec.last_update_date;
2058: END IF;
2059: IF (x_okl_ansr_set_crtria_tl_rec.last_update_login = okl_api.G_MISS_NUM)

Line 2057: x_okl_ansr_set_crtria_tl_rec.last_update_date := l_okl_ansr_set_crtria_tl_rec.last_update_date;

2053: x_okl_ansr_set_crtria_tl_rec.last_updated_by := l_okl_ansr_set_crtria_tl_rec.last_updated_by;
2054: END IF;
2055: IF (x_okl_ansr_set_crtria_tl_rec.last_update_date = okl_api.G_MISS_DATE)
2056: THEN
2057: x_okl_ansr_set_crtria_tl_rec.last_update_date := l_okl_ansr_set_crtria_tl_rec.last_update_date;
2058: END IF;
2059: IF (x_okl_ansr_set_crtria_tl_rec.last_update_login = okl_api.G_MISS_NUM)
2060: THEN
2061: x_okl_ansr_set_crtria_tl_rec.last_update_login := l_okl_ansr_set_crtria_tl_rec.last_update_login;

Line 2059: IF (x_okl_ansr_set_crtria_tl_rec.last_update_login = okl_api.G_MISS_NUM)

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

Line 2061: x_okl_ansr_set_crtria_tl_rec.last_update_login := l_okl_ansr_set_crtria_tl_rec.last_update_login;

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

Line 2066: -- Set_Attributes for:OKL_ANSR_SET_CRTRIA_TL --

2062: END IF;
2063: RETURN(l_return_status);
2064: END populate_new_record;
2065: -----------------------------------------------
2066: -- Set_Attributes for:OKL_ANSR_SET_CRTRIA_TL --
2067: -----------------------------------------------
2068: FUNCTION Set_Attributes (
2069: p_okl_ansr_set_crtria_tl_rec IN OklAnsrSetCrtriaTlRecType,
2070: x_okl_ansr_set_crtria_tl_rec OUT NOCOPY OklAnsrSetCrtriaTlRecType

Line 2069: p_okl_ansr_set_crtria_tl_rec IN OklAnsrSetCrtriaTlRecType,

2065: -----------------------------------------------
2066: -- Set_Attributes for:OKL_ANSR_SET_CRTRIA_TL --
2067: -----------------------------------------------
2068: FUNCTION Set_Attributes (
2069: p_okl_ansr_set_crtria_tl_rec IN OklAnsrSetCrtriaTlRecType,
2070: x_okl_ansr_set_crtria_tl_rec OUT NOCOPY OklAnsrSetCrtriaTlRecType
2071: ) RETURN VARCHAR2 IS
2072: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2073: BEGIN

Line 2070: x_okl_ansr_set_crtria_tl_rec OUT NOCOPY OklAnsrSetCrtriaTlRecType

2066: -- Set_Attributes for:OKL_ANSR_SET_CRTRIA_TL --
2067: -----------------------------------------------
2068: FUNCTION Set_Attributes (
2069: p_okl_ansr_set_crtria_tl_rec IN OklAnsrSetCrtriaTlRecType,
2070: x_okl_ansr_set_crtria_tl_rec OUT NOCOPY OklAnsrSetCrtriaTlRecType
2071: ) RETURN VARCHAR2 IS
2072: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2073: BEGIN
2074: x_okl_ansr_set_crtria_tl_rec := p_okl_ansr_set_crtria_tl_rec;

Line 2074: x_okl_ansr_set_crtria_tl_rec := p_okl_ansr_set_crtria_tl_rec;

2070: x_okl_ansr_set_crtria_tl_rec OUT NOCOPY OklAnsrSetCrtriaTlRecType
2071: ) RETURN VARCHAR2 IS
2072: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2073: BEGIN
2074: x_okl_ansr_set_crtria_tl_rec := p_okl_ansr_set_crtria_tl_rec;
2075: x_okl_ansr_set_crtria_tl_rec.LANGUAGE := USERENV('LANG');
2076: x_okl_ansr_set_crtria_tl_rec.SOURCE_LANG := USERENV('LANG');
2077: RETURN(l_return_status);
2078: END Set_Attributes;

Line 2075: x_okl_ansr_set_crtria_tl_rec.LANGUAGE := USERENV('LANG');

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

Line 2076: x_okl_ansr_set_crtria_tl_rec.SOURCE_LANG := USERENV('LANG');

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

Line 2091: p_okl_ansr_set_crtria_tl_rec, -- IN

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

Line 2092: l_okl_ansr_set_crtria_tl_rec); -- OUT

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

Line 2099: l_return_status := populate_new_record(l_okl_ansr_set_crtria_tl_rec, ldefoklansrsetcrtriatlrec);

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

Line 2105: UPDATE OKL_ANSR_SET_CRTRIA_TL

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

Line 2116: UPDATE OKL_ANSR_SET_CRTRIA_TL

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

Line 2121: x_okl_ansr_set_crtria_tl_rec := ldefoklansrsetcrtriatlrec;

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

Line 2172: l_okl_ansr_set_crtria_tl_rec OklAnsrSetCrtriaTlRecType;

2168: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
2169: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2170: l_asrv_rec asrv_rec_type := p_asrv_rec;
2171: l_def_asrv_rec asrv_rec_type;
2172: l_okl_ansr_set_crtria_tl_rec OklAnsrSetCrtriaTlRecType;
2173: lx_okl_ansr_set_crtria_tl_rec OklAnsrSetCrtriaTlRecType;
2174: l_asr_rec asr_rec_type;
2175: lx_asr_rec asr_rec_type;
2176: -------------------------------

Line 2173: lx_okl_ansr_set_crtria_tl_rec OklAnsrSetCrtriaTlRecType;

2169: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2170: l_asrv_rec asrv_rec_type := p_asrv_rec;
2171: l_def_asrv_rec asrv_rec_type;
2172: l_okl_ansr_set_crtria_tl_rec OklAnsrSetCrtriaTlRecType;
2173: lx_okl_ansr_set_crtria_tl_rec OklAnsrSetCrtriaTlRecType;
2174: l_asr_rec asr_rec_type;
2175: lx_asr_rec asr_rec_type;
2176: -------------------------------
2177: -- FUNCTION fill_who_columns --

Line 2381: migrate(l_def_asrv_rec, l_okl_ansr_set_crtria_tl_rec);

2377:
2378: --------------------------------------
2379: -- Move VIEW record to "Child" records
2380: --------------------------------------
2381: migrate(l_def_asrv_rec, l_okl_ansr_set_crtria_tl_rec);
2382: migrate(l_def_asrv_rec, l_asr_rec);
2383: --------------------------------------------
2384: -- Call the UPDATE_ROW for each child record
2385: --------------------------------------------

Line 2391: l_okl_ansr_set_crtria_tl_rec,

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

Line 2392: lx_okl_ansr_set_crtria_tl_rec

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

Line 2399: migrate(lx_okl_ansr_set_crtria_tl_rec, l_def_asrv_rec);

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

Line 2580: -- delete_row for:OKL_ANSR_SET_CRTRIA_TL --

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

Line 2587: p_okl_ansr_set_crtria_tl_rec IN OklAnsrSetCrtriaTlRecType) IS

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

Line 2592: l_okl_ansr_set_crtria_tl_rec OklAnsrSetCrtriaTlRecType:= p_okl_ansr_set_crtria_tl_rec;

2588:
2589: l_api_version CONSTANT NUMBER := 1;
2590: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
2591: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2592: l_okl_ansr_set_crtria_tl_rec OklAnsrSetCrtriaTlRecType:= p_okl_ansr_set_crtria_tl_rec;
2593: l_row_notfound BOOLEAN := TRUE;
2594: -----------------------------------------------
2595: -- Set_Attributes for:OKL_ANSR_SET_CRTRIA_TL --
2596: -----------------------------------------------

Line 2595: -- Set_Attributes for:OKL_ANSR_SET_CRTRIA_TL --

2591: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2592: l_okl_ansr_set_crtria_tl_rec OklAnsrSetCrtriaTlRecType:= p_okl_ansr_set_crtria_tl_rec;
2593: l_row_notfound BOOLEAN := TRUE;
2594: -----------------------------------------------
2595: -- Set_Attributes for:OKL_ANSR_SET_CRTRIA_TL --
2596: -----------------------------------------------
2597: FUNCTION Set_Attributes (
2598: p_okl_ansr_set_crtria_tl_rec IN OklAnsrSetCrtriaTlRecType,
2599: x_okl_ansr_set_crtria_tl_rec OUT NOCOPY OklAnsrSetCrtriaTlRecType

Line 2598: p_okl_ansr_set_crtria_tl_rec IN OklAnsrSetCrtriaTlRecType,

2594: -----------------------------------------------
2595: -- Set_Attributes for:OKL_ANSR_SET_CRTRIA_TL --
2596: -----------------------------------------------
2597: FUNCTION Set_Attributes (
2598: p_okl_ansr_set_crtria_tl_rec IN OklAnsrSetCrtriaTlRecType,
2599: x_okl_ansr_set_crtria_tl_rec OUT NOCOPY OklAnsrSetCrtriaTlRecType
2600: ) RETURN VARCHAR2 IS
2601: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2602: BEGIN

Line 2599: x_okl_ansr_set_crtria_tl_rec OUT NOCOPY OklAnsrSetCrtriaTlRecType

2595: -- Set_Attributes for:OKL_ANSR_SET_CRTRIA_TL --
2596: -----------------------------------------------
2597: FUNCTION Set_Attributes (
2598: p_okl_ansr_set_crtria_tl_rec IN OklAnsrSetCrtriaTlRecType,
2599: x_okl_ansr_set_crtria_tl_rec OUT NOCOPY OklAnsrSetCrtriaTlRecType
2600: ) RETURN VARCHAR2 IS
2601: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2602: BEGIN
2603: x_okl_ansr_set_crtria_tl_rec := p_okl_ansr_set_crtria_tl_rec;

Line 2603: x_okl_ansr_set_crtria_tl_rec := p_okl_ansr_set_crtria_tl_rec;

2599: x_okl_ansr_set_crtria_tl_rec OUT NOCOPY OklAnsrSetCrtriaTlRecType
2600: ) RETURN VARCHAR2 IS
2601: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2602: BEGIN
2603: x_okl_ansr_set_crtria_tl_rec := p_okl_ansr_set_crtria_tl_rec;
2604: x_okl_ansr_set_crtria_tl_rec.LANGUAGE := USERENV('LANG');
2605: RETURN(l_return_status);
2606: END Set_Attributes;
2607: BEGIN

Line 2604: x_okl_ansr_set_crtria_tl_rec.LANGUAGE := USERENV('LANG');

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

Line 2619: p_okl_ansr_set_crtria_tl_rec, -- IN

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

Line 2620: l_okl_ansr_set_crtria_tl_rec); -- OUT

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

Line 2627: DELETE FROM OKL_ANSR_SET_CRTRIA_TL

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

Line 2628: WHERE ID = l_okl_ansr_set_crtria_tl_rec.id;

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

Line 2678: l_okl_ansr_set_crtria_tl_rec OklAnsrSetCrtriaTlRecType;

2674: l_api_version CONSTANT NUMBER := 1;
2675: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
2676: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2677: l_asrv_rec asrv_rec_type := p_asrv_rec;
2678: l_okl_ansr_set_crtria_tl_rec OklAnsrSetCrtriaTlRecType;
2679: l_asr_rec asr_rec_type;
2680: BEGIN
2681: l_return_status := okl_api.START_ACTIVITY(l_api_name,
2682: G_PKG_NAME,

Line 2696: migrate(l_asrv_rec, l_okl_ansr_set_crtria_tl_rec);

2692: END IF;
2693: --------------------------------------
2694: -- Move VIEW record to "Child" records
2695: --------------------------------------
2696: migrate(l_asrv_rec, l_okl_ansr_set_crtria_tl_rec);
2697: migrate(l_asrv_rec, l_asr_rec);
2698: --------------------------------------------
2699: -- Call the DELETE_ROW for each child record
2700: --------------------------------------------

Line 2706: l_okl_ansr_set_crtria_tl_rec

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