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_PFC_PVT dependencies on OKL_PRTFL_CNTRCTS_TL

Line 98: DELETE FROM OKL_PRTFL_CNTRCTS_TL T

94: -- PROCEDURE add_language
95: ---------------------------------------------------------------------------
96: PROCEDURE add_language IS
97: BEGIN
98: DELETE FROM OKL_PRTFL_CNTRCTS_TL T
99: WHERE NOT EXISTS (
100: SELECT NULL
101: FROM OKL_PRTFL_CNTRCTS_B B
102: WHERE B.ID =T.ID

Line 105: UPDATE OKL_PRTFL_CNTRCTS_TL T SET(

101: FROM OKL_PRTFL_CNTRCTS_B B
102: WHERE B.ID =T.ID
103: );
104:
105: UPDATE OKL_PRTFL_CNTRCTS_TL T SET(
106: NAME,
107: DESCRIPTION) = (SELECT
108: B.NAME,
109: B.DESCRIPTION

Line 110: FROM OKL_PRTFL_CNTRCTS_TL B

106: NAME,
107: DESCRIPTION) = (SELECT
108: B.NAME,
109: B.DESCRIPTION
110: FROM OKL_PRTFL_CNTRCTS_TL B
111: WHERE B.ID = T.ID
112: AND B.LANGUAGE = T.SOURCE_LANG)
113: WHERE ( T.ID,
114: T.LANGUAGE)

Line 118: FROM OKL_PRTFL_CNTRCTS_TL SUBB, OKL_PRTFL_CNTRCTS_TL SUBT

114: T.LANGUAGE)
115: IN (SELECT
116: SUBT.ID,
117: SUBT.LANGUAGE
118: FROM OKL_PRTFL_CNTRCTS_TL SUBB, OKL_PRTFL_CNTRCTS_TL SUBT
119: WHERE SUBB.ID = SUBT.ID
120: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
121: AND (SUBB.NAME <> SUBT.NAME
122: OR SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 127: INSERT INTO OKL_PRTFL_CNTRCTS_TL (

123: OR (SUBB.NAME IS NULL AND SUBT.NAME IS NOT NULL)
124: OR (SUBB.DESCRIPTION IS NULL AND SUBT.DESCRIPTION IS NOT NULL)
125: ));
126:
127: INSERT INTO OKL_PRTFL_CNTRCTS_TL (
128: ID,
129: LANGUAGE,
130: SOURCE_LANG,
131: SFWT_FLAG,

Line 151: FROM OKL_PRTFL_CNTRCTS_TL B, FND_LANGUAGES L

147: B.CREATION_DATE,
148: B.LAST_UPDATED_BY,
149: B.LAST_UPDATE_DATE,
150: B.LAST_UPDATE_LOGIN
151: FROM OKL_PRTFL_CNTRCTS_TL B, FND_LANGUAGES L
152: WHERE L.INSTALLED_FLAG IN ('I', 'B')
153: AND B.LANGUAGE = USERENV('LANG')
154: AND NOT EXISTS (
155: SELECT NULL

Line 156: FROM OKL_PRTFL_CNTRCTS_TL T

152: WHERE L.INSTALLED_FLAG IN ('I', 'B')
153: AND B.LANGUAGE = USERENV('LANG')
154: AND NOT EXISTS (
155: SELECT NULL
156: FROM OKL_PRTFL_CNTRCTS_TL T
157: WHERE T.ID = B.ID
158: AND T.LANGUAGE = L.LANGUAGE_CODE
159: );
160: END add_language;

Line 387: -- FUNCTION get_rec for: OKL_PRTFL_CNTRCTS_TL

383: BEGIN
384: RETURN(get_rec(p_pfc_rec, l_row_not_found));
385: END get_rec;
386: ---------------------------------------------------------------------------
387: -- FUNCTION get_rec for: OKL_PRTFL_CNTRCTS_TL
388: ---------------------------------------------------------------------------
389: FUNCTION get_rec (
390: p_okl_prtfl_cntrcts_tl_rec IN okl_prtfl_cntrcts_tl_rec_type,
391: x_no_data_found OUT NOCOPY BOOLEAN

Line 390: p_okl_prtfl_cntrcts_tl_rec IN okl_prtfl_cntrcts_tl_rec_type,

386: ---------------------------------------------------------------------------
387: -- FUNCTION get_rec for: OKL_PRTFL_CNTRCTS_TL
388: ---------------------------------------------------------------------------
389: FUNCTION get_rec (
390: p_okl_prtfl_cntrcts_tl_rec IN okl_prtfl_cntrcts_tl_rec_type,
391: x_no_data_found OUT NOCOPY BOOLEAN
392: ) RETURN okl_prtfl_cntrcts_tl_rec_type IS
393: CURSOR okl_prtfl_cntrcts_tl_pk_csr (p_id IN NUMBER,
394: p_language IN VARCHAR2) IS

Line 392: ) RETURN okl_prtfl_cntrcts_tl_rec_type IS

388: ---------------------------------------------------------------------------
389: FUNCTION get_rec (
390: p_okl_prtfl_cntrcts_tl_rec IN okl_prtfl_cntrcts_tl_rec_type,
391: x_no_data_found OUT NOCOPY BOOLEAN
392: ) RETURN okl_prtfl_cntrcts_tl_rec_type IS
393: CURSOR okl_prtfl_cntrcts_tl_pk_csr (p_id IN NUMBER,
394: p_language IN VARCHAR2) IS
395: SELECT
396: ID,

Line 393: CURSOR okl_prtfl_cntrcts_tl_pk_csr (p_id IN NUMBER,

389: FUNCTION get_rec (
390: p_okl_prtfl_cntrcts_tl_rec IN okl_prtfl_cntrcts_tl_rec_type,
391: x_no_data_found OUT NOCOPY BOOLEAN
392: ) RETURN okl_prtfl_cntrcts_tl_rec_type IS
393: CURSOR okl_prtfl_cntrcts_tl_pk_csr (p_id IN NUMBER,
394: p_language IN VARCHAR2) IS
395: SELECT
396: ID,
397: LANGUAGE,

Line 407: FROM Okl_Prtfl_Cntrcts_Tl

403: CREATION_DATE,
404: LAST_UPDATED_BY,
405: LAST_UPDATE_DATE,
406: LAST_UPDATE_LOGIN
407: FROM Okl_Prtfl_Cntrcts_Tl
408: WHERE okl_prtfl_cntrcts_tl.id = p_id
409: AND okl_prtfl_cntrcts_tl.language = p_language;
410: l_okl_prtfl_cntrcts_tl_pk okl_prtfl_cntrcts_tl_pk_csr%ROWTYPE;
411: l_okl_prtfl_cntrcts_tl_rec okl_prtfl_cntrcts_tl_rec_type;

Line 408: WHERE okl_prtfl_cntrcts_tl.id = p_id

404: LAST_UPDATED_BY,
405: LAST_UPDATE_DATE,
406: LAST_UPDATE_LOGIN
407: FROM Okl_Prtfl_Cntrcts_Tl
408: WHERE okl_prtfl_cntrcts_tl.id = p_id
409: AND okl_prtfl_cntrcts_tl.language = p_language;
410: l_okl_prtfl_cntrcts_tl_pk okl_prtfl_cntrcts_tl_pk_csr%ROWTYPE;
411: l_okl_prtfl_cntrcts_tl_rec okl_prtfl_cntrcts_tl_rec_type;
412: BEGIN

Line 409: AND okl_prtfl_cntrcts_tl.language = p_language;

405: LAST_UPDATE_DATE,
406: LAST_UPDATE_LOGIN
407: FROM Okl_Prtfl_Cntrcts_Tl
408: WHERE okl_prtfl_cntrcts_tl.id = p_id
409: AND okl_prtfl_cntrcts_tl.language = p_language;
410: l_okl_prtfl_cntrcts_tl_pk okl_prtfl_cntrcts_tl_pk_csr%ROWTYPE;
411: l_okl_prtfl_cntrcts_tl_rec okl_prtfl_cntrcts_tl_rec_type;
412: BEGIN
413: x_no_data_found := TRUE;

Line 410: l_okl_prtfl_cntrcts_tl_pk okl_prtfl_cntrcts_tl_pk_csr%ROWTYPE;

406: LAST_UPDATE_LOGIN
407: FROM Okl_Prtfl_Cntrcts_Tl
408: WHERE okl_prtfl_cntrcts_tl.id = p_id
409: AND okl_prtfl_cntrcts_tl.language = p_language;
410: l_okl_prtfl_cntrcts_tl_pk okl_prtfl_cntrcts_tl_pk_csr%ROWTYPE;
411: l_okl_prtfl_cntrcts_tl_rec okl_prtfl_cntrcts_tl_rec_type;
412: BEGIN
413: x_no_data_found := TRUE;
414: -- Get current database values

Line 411: l_okl_prtfl_cntrcts_tl_rec okl_prtfl_cntrcts_tl_rec_type;

407: FROM Okl_Prtfl_Cntrcts_Tl
408: WHERE okl_prtfl_cntrcts_tl.id = p_id
409: AND okl_prtfl_cntrcts_tl.language = p_language;
410: l_okl_prtfl_cntrcts_tl_pk okl_prtfl_cntrcts_tl_pk_csr%ROWTYPE;
411: l_okl_prtfl_cntrcts_tl_rec okl_prtfl_cntrcts_tl_rec_type;
412: BEGIN
413: x_no_data_found := TRUE;
414: -- Get current database values
415: OPEN okl_prtfl_cntrcts_tl_pk_csr (p_okl_prtfl_cntrcts_tl_rec.id,

Line 415: OPEN okl_prtfl_cntrcts_tl_pk_csr (p_okl_prtfl_cntrcts_tl_rec.id,

411: l_okl_prtfl_cntrcts_tl_rec okl_prtfl_cntrcts_tl_rec_type;
412: BEGIN
413: x_no_data_found := TRUE;
414: -- Get current database values
415: OPEN okl_prtfl_cntrcts_tl_pk_csr (p_okl_prtfl_cntrcts_tl_rec.id,
416: p_okl_prtfl_cntrcts_tl_rec.language);
417: FETCH okl_prtfl_cntrcts_tl_pk_csr INTO
418: l_okl_prtfl_cntrcts_tl_rec.id,
419: l_okl_prtfl_cntrcts_tl_rec.language,

Line 416: p_okl_prtfl_cntrcts_tl_rec.language);

412: BEGIN
413: x_no_data_found := TRUE;
414: -- Get current database values
415: OPEN okl_prtfl_cntrcts_tl_pk_csr (p_okl_prtfl_cntrcts_tl_rec.id,
416: p_okl_prtfl_cntrcts_tl_rec.language);
417: FETCH okl_prtfl_cntrcts_tl_pk_csr INTO
418: l_okl_prtfl_cntrcts_tl_rec.id,
419: l_okl_prtfl_cntrcts_tl_rec.language,
420: l_okl_prtfl_cntrcts_tl_rec.source_lang,

Line 417: FETCH okl_prtfl_cntrcts_tl_pk_csr INTO

413: x_no_data_found := TRUE;
414: -- Get current database values
415: OPEN okl_prtfl_cntrcts_tl_pk_csr (p_okl_prtfl_cntrcts_tl_rec.id,
416: p_okl_prtfl_cntrcts_tl_rec.language);
417: FETCH okl_prtfl_cntrcts_tl_pk_csr INTO
418: l_okl_prtfl_cntrcts_tl_rec.id,
419: l_okl_prtfl_cntrcts_tl_rec.language,
420: l_okl_prtfl_cntrcts_tl_rec.source_lang,
421: l_okl_prtfl_cntrcts_tl_rec.sfwt_flag,

Line 418: l_okl_prtfl_cntrcts_tl_rec.id,

414: -- Get current database values
415: OPEN okl_prtfl_cntrcts_tl_pk_csr (p_okl_prtfl_cntrcts_tl_rec.id,
416: p_okl_prtfl_cntrcts_tl_rec.language);
417: FETCH okl_prtfl_cntrcts_tl_pk_csr INTO
418: l_okl_prtfl_cntrcts_tl_rec.id,
419: l_okl_prtfl_cntrcts_tl_rec.language,
420: l_okl_prtfl_cntrcts_tl_rec.source_lang,
421: l_okl_prtfl_cntrcts_tl_rec.sfwt_flag,
422: l_okl_prtfl_cntrcts_tl_rec.name,

Line 419: l_okl_prtfl_cntrcts_tl_rec.language,

415: OPEN okl_prtfl_cntrcts_tl_pk_csr (p_okl_prtfl_cntrcts_tl_rec.id,
416: p_okl_prtfl_cntrcts_tl_rec.language);
417: FETCH okl_prtfl_cntrcts_tl_pk_csr INTO
418: l_okl_prtfl_cntrcts_tl_rec.id,
419: l_okl_prtfl_cntrcts_tl_rec.language,
420: l_okl_prtfl_cntrcts_tl_rec.source_lang,
421: l_okl_prtfl_cntrcts_tl_rec.sfwt_flag,
422: l_okl_prtfl_cntrcts_tl_rec.name,
423: l_okl_prtfl_cntrcts_tl_rec.description,

Line 420: l_okl_prtfl_cntrcts_tl_rec.source_lang,

416: p_okl_prtfl_cntrcts_tl_rec.language);
417: FETCH okl_prtfl_cntrcts_tl_pk_csr INTO
418: l_okl_prtfl_cntrcts_tl_rec.id,
419: l_okl_prtfl_cntrcts_tl_rec.language,
420: l_okl_prtfl_cntrcts_tl_rec.source_lang,
421: l_okl_prtfl_cntrcts_tl_rec.sfwt_flag,
422: l_okl_prtfl_cntrcts_tl_rec.name,
423: l_okl_prtfl_cntrcts_tl_rec.description,
424: l_okl_prtfl_cntrcts_tl_rec.created_by,

Line 421: l_okl_prtfl_cntrcts_tl_rec.sfwt_flag,

417: FETCH okl_prtfl_cntrcts_tl_pk_csr INTO
418: l_okl_prtfl_cntrcts_tl_rec.id,
419: l_okl_prtfl_cntrcts_tl_rec.language,
420: l_okl_prtfl_cntrcts_tl_rec.source_lang,
421: l_okl_prtfl_cntrcts_tl_rec.sfwt_flag,
422: l_okl_prtfl_cntrcts_tl_rec.name,
423: l_okl_prtfl_cntrcts_tl_rec.description,
424: l_okl_prtfl_cntrcts_tl_rec.created_by,
425: l_okl_prtfl_cntrcts_tl_rec.creation_date,

Line 422: l_okl_prtfl_cntrcts_tl_rec.name,

418: l_okl_prtfl_cntrcts_tl_rec.id,
419: l_okl_prtfl_cntrcts_tl_rec.language,
420: l_okl_prtfl_cntrcts_tl_rec.source_lang,
421: l_okl_prtfl_cntrcts_tl_rec.sfwt_flag,
422: l_okl_prtfl_cntrcts_tl_rec.name,
423: l_okl_prtfl_cntrcts_tl_rec.description,
424: l_okl_prtfl_cntrcts_tl_rec.created_by,
425: l_okl_prtfl_cntrcts_tl_rec.creation_date,
426: l_okl_prtfl_cntrcts_tl_rec.last_updated_by,

Line 423: l_okl_prtfl_cntrcts_tl_rec.description,

419: l_okl_prtfl_cntrcts_tl_rec.language,
420: l_okl_prtfl_cntrcts_tl_rec.source_lang,
421: l_okl_prtfl_cntrcts_tl_rec.sfwt_flag,
422: l_okl_prtfl_cntrcts_tl_rec.name,
423: l_okl_prtfl_cntrcts_tl_rec.description,
424: l_okl_prtfl_cntrcts_tl_rec.created_by,
425: l_okl_prtfl_cntrcts_tl_rec.creation_date,
426: l_okl_prtfl_cntrcts_tl_rec.last_updated_by,
427: l_okl_prtfl_cntrcts_tl_rec.last_update_date,

Line 424: l_okl_prtfl_cntrcts_tl_rec.created_by,

420: l_okl_prtfl_cntrcts_tl_rec.source_lang,
421: l_okl_prtfl_cntrcts_tl_rec.sfwt_flag,
422: l_okl_prtfl_cntrcts_tl_rec.name,
423: l_okl_prtfl_cntrcts_tl_rec.description,
424: l_okl_prtfl_cntrcts_tl_rec.created_by,
425: l_okl_prtfl_cntrcts_tl_rec.creation_date,
426: l_okl_prtfl_cntrcts_tl_rec.last_updated_by,
427: l_okl_prtfl_cntrcts_tl_rec.last_update_date,
428: l_okl_prtfl_cntrcts_tl_rec.last_update_login;

Line 425: l_okl_prtfl_cntrcts_tl_rec.creation_date,

421: l_okl_prtfl_cntrcts_tl_rec.sfwt_flag,
422: l_okl_prtfl_cntrcts_tl_rec.name,
423: l_okl_prtfl_cntrcts_tl_rec.description,
424: l_okl_prtfl_cntrcts_tl_rec.created_by,
425: l_okl_prtfl_cntrcts_tl_rec.creation_date,
426: l_okl_prtfl_cntrcts_tl_rec.last_updated_by,
427: l_okl_prtfl_cntrcts_tl_rec.last_update_date,
428: l_okl_prtfl_cntrcts_tl_rec.last_update_login;
429: x_no_data_found := okl_prtfl_cntrcts_tl_pk_csr%NOTFOUND;

Line 426: l_okl_prtfl_cntrcts_tl_rec.last_updated_by,

422: l_okl_prtfl_cntrcts_tl_rec.name,
423: l_okl_prtfl_cntrcts_tl_rec.description,
424: l_okl_prtfl_cntrcts_tl_rec.created_by,
425: l_okl_prtfl_cntrcts_tl_rec.creation_date,
426: l_okl_prtfl_cntrcts_tl_rec.last_updated_by,
427: l_okl_prtfl_cntrcts_tl_rec.last_update_date,
428: l_okl_prtfl_cntrcts_tl_rec.last_update_login;
429: x_no_data_found := okl_prtfl_cntrcts_tl_pk_csr%NOTFOUND;
430: CLOSE okl_prtfl_cntrcts_tl_pk_csr;

Line 427: l_okl_prtfl_cntrcts_tl_rec.last_update_date,

423: l_okl_prtfl_cntrcts_tl_rec.description,
424: l_okl_prtfl_cntrcts_tl_rec.created_by,
425: l_okl_prtfl_cntrcts_tl_rec.creation_date,
426: l_okl_prtfl_cntrcts_tl_rec.last_updated_by,
427: l_okl_prtfl_cntrcts_tl_rec.last_update_date,
428: l_okl_prtfl_cntrcts_tl_rec.last_update_login;
429: x_no_data_found := okl_prtfl_cntrcts_tl_pk_csr%NOTFOUND;
430: CLOSE okl_prtfl_cntrcts_tl_pk_csr;
431: RETURN(l_okl_prtfl_cntrcts_tl_rec);

Line 428: l_okl_prtfl_cntrcts_tl_rec.last_update_login;

424: l_okl_prtfl_cntrcts_tl_rec.created_by,
425: l_okl_prtfl_cntrcts_tl_rec.creation_date,
426: l_okl_prtfl_cntrcts_tl_rec.last_updated_by,
427: l_okl_prtfl_cntrcts_tl_rec.last_update_date,
428: l_okl_prtfl_cntrcts_tl_rec.last_update_login;
429: x_no_data_found := okl_prtfl_cntrcts_tl_pk_csr%NOTFOUND;
430: CLOSE okl_prtfl_cntrcts_tl_pk_csr;
431: RETURN(l_okl_prtfl_cntrcts_tl_rec);
432: END get_rec;

Line 429: x_no_data_found := okl_prtfl_cntrcts_tl_pk_csr%NOTFOUND;

425: l_okl_prtfl_cntrcts_tl_rec.creation_date,
426: l_okl_prtfl_cntrcts_tl_rec.last_updated_by,
427: l_okl_prtfl_cntrcts_tl_rec.last_update_date,
428: l_okl_prtfl_cntrcts_tl_rec.last_update_login;
429: x_no_data_found := okl_prtfl_cntrcts_tl_pk_csr%NOTFOUND;
430: CLOSE okl_prtfl_cntrcts_tl_pk_csr;
431: RETURN(l_okl_prtfl_cntrcts_tl_rec);
432: END get_rec;
433:

Line 430: CLOSE okl_prtfl_cntrcts_tl_pk_csr;

426: l_okl_prtfl_cntrcts_tl_rec.last_updated_by,
427: l_okl_prtfl_cntrcts_tl_rec.last_update_date,
428: l_okl_prtfl_cntrcts_tl_rec.last_update_login;
429: x_no_data_found := okl_prtfl_cntrcts_tl_pk_csr%NOTFOUND;
430: CLOSE okl_prtfl_cntrcts_tl_pk_csr;
431: RETURN(l_okl_prtfl_cntrcts_tl_rec);
432: END get_rec;
433:
434: ------------------------------------------------------------------

Line 431: RETURN(l_okl_prtfl_cntrcts_tl_rec);

427: l_okl_prtfl_cntrcts_tl_rec.last_update_date,
428: l_okl_prtfl_cntrcts_tl_rec.last_update_login;
429: x_no_data_found := okl_prtfl_cntrcts_tl_pk_csr%NOTFOUND;
430: CLOSE okl_prtfl_cntrcts_tl_pk_csr;
431: RETURN(l_okl_prtfl_cntrcts_tl_rec);
432: END get_rec;
433:
434: ------------------------------------------------------------------
435: -- This version of get_rec sets error messages if no data found --

Line 438: p_okl_prtfl_cntrcts_tl_rec IN okl_prtfl_cntrcts_tl_rec_type,

434: ------------------------------------------------------------------
435: -- This version of get_rec sets error messages if no data found --
436: ------------------------------------------------------------------
437: FUNCTION get_rec (
438: p_okl_prtfl_cntrcts_tl_rec IN okl_prtfl_cntrcts_tl_rec_type,
439: x_return_status OUT NOCOPY VARCHAR2
440: ) RETURN okl_prtfl_cntrcts_tl_rec_type IS
441: l_okl_prtfl_cntrcts_tl_rec okl_prtfl_cntrcts_tl_rec_type;
442: l_row_notfound BOOLEAN := TRUE;

Line 440: ) RETURN okl_prtfl_cntrcts_tl_rec_type IS

436: ------------------------------------------------------------------
437: FUNCTION get_rec (
438: p_okl_prtfl_cntrcts_tl_rec IN okl_prtfl_cntrcts_tl_rec_type,
439: x_return_status OUT NOCOPY VARCHAR2
440: ) RETURN okl_prtfl_cntrcts_tl_rec_type IS
441: l_okl_prtfl_cntrcts_tl_rec okl_prtfl_cntrcts_tl_rec_type;
442: l_row_notfound BOOLEAN := TRUE;
443: BEGIN
444: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 441: l_okl_prtfl_cntrcts_tl_rec okl_prtfl_cntrcts_tl_rec_type;

437: FUNCTION get_rec (
438: p_okl_prtfl_cntrcts_tl_rec IN okl_prtfl_cntrcts_tl_rec_type,
439: x_return_status OUT NOCOPY VARCHAR2
440: ) RETURN okl_prtfl_cntrcts_tl_rec_type IS
441: l_okl_prtfl_cntrcts_tl_rec okl_prtfl_cntrcts_tl_rec_type;
442: l_row_notfound BOOLEAN := TRUE;
443: BEGIN
444: x_return_status := OKL_API.G_RET_STS_SUCCESS;
445: l_okl_prtfl_cntrcts_tl_rec := get_rec(p_okl_prtfl_cntrcts_tl_rec, l_row_notfound);

Line 445: l_okl_prtfl_cntrcts_tl_rec := get_rec(p_okl_prtfl_cntrcts_tl_rec, l_row_notfound);

441: l_okl_prtfl_cntrcts_tl_rec okl_prtfl_cntrcts_tl_rec_type;
442: l_row_notfound BOOLEAN := TRUE;
443: BEGIN
444: x_return_status := OKL_API.G_RET_STS_SUCCESS;
445: l_okl_prtfl_cntrcts_tl_rec := get_rec(p_okl_prtfl_cntrcts_tl_rec, l_row_notfound);
446: IF (l_row_notfound) THEN
447: OKL_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
448: OKL_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'LANGUAGE');
449: x_return_status := OKL_API.G_RET_STS_ERROR;

Line 451: RETURN(l_okl_prtfl_cntrcts_tl_rec);

447: OKL_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
448: OKL_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'LANGUAGE');
449: x_return_status := OKL_API.G_RET_STS_ERROR;
450: END IF;
451: RETURN(l_okl_prtfl_cntrcts_tl_rec);
452: END get_rec;
453: -----------------------------------------------------------
454: -- So we don't have to pass an "l_row_notfound" variable --
455: -----------------------------------------------------------

Line 457: p_okl_prtfl_cntrcts_tl_rec IN okl_prtfl_cntrcts_tl_rec_type

453: -----------------------------------------------------------
454: -- So we don't have to pass an "l_row_notfound" variable --
455: -----------------------------------------------------------
456: FUNCTION get_rec (
457: p_okl_prtfl_cntrcts_tl_rec IN okl_prtfl_cntrcts_tl_rec_type
458: ) RETURN okl_prtfl_cntrcts_tl_rec_type IS
459: l_row_not_found BOOLEAN := TRUE;
460: BEGIN
461: RETURN(get_rec(p_okl_prtfl_cntrcts_tl_rec, l_row_not_found));

Line 458: ) RETURN okl_prtfl_cntrcts_tl_rec_type IS

454: -- So we don't have to pass an "l_row_notfound" variable --
455: -----------------------------------------------------------
456: FUNCTION get_rec (
457: p_okl_prtfl_cntrcts_tl_rec IN okl_prtfl_cntrcts_tl_rec_type
458: ) RETURN okl_prtfl_cntrcts_tl_rec_type IS
459: l_row_not_found BOOLEAN := TRUE;
460: BEGIN
461: RETURN(get_rec(p_okl_prtfl_cntrcts_tl_rec, l_row_not_found));
462: END get_rec;

Line 461: RETURN(get_rec(p_okl_prtfl_cntrcts_tl_rec, l_row_not_found));

457: p_okl_prtfl_cntrcts_tl_rec IN okl_prtfl_cntrcts_tl_rec_type
458: ) RETURN okl_prtfl_cntrcts_tl_rec_type IS
459: l_row_not_found BOOLEAN := TRUE;
460: BEGIN
461: RETURN(get_rec(p_okl_prtfl_cntrcts_tl_rec, l_row_not_found));
462: END get_rec;
463: ---------------------------------------------------------------------------
464: -- FUNCTION null_out_defaults for: OKL_PRTFL_CNTRCTS_V
465: ---------------------------------------------------------------------------

Line 1052: p_to IN OUT NOCOPY okl_prtfl_cntrcts_tl_rec_type

1048: p_to.last_update_login := p_from.last_update_login;
1049: END migrate;
1050: PROCEDURE migrate (
1051: p_from IN pfcv_rec_type,
1052: p_to IN OUT NOCOPY okl_prtfl_cntrcts_tl_rec_type
1053: ) IS
1054: BEGIN
1055: p_to.id := p_from.id;
1056: p_to.sfwt_flag := p_from.sfwt_flag;

Line 1066: p_from IN okl_prtfl_cntrcts_tl_rec_type,

1062: p_to.last_update_date := p_from.last_update_date;
1063: p_to.last_update_login := p_from.last_update_login;
1064: END migrate;
1065: PROCEDURE migrate (
1066: p_from IN okl_prtfl_cntrcts_tl_rec_type,
1067: p_to IN OUT NOCOPY pfcv_rec_type
1068: ) IS
1069: BEGIN
1070: p_to.id := p_from.id;

Line 1099: l_okl_prtfl_cntrcts_tl_rec okl_prtfl_cntrcts_tl_rec_type;

1095: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
1096: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1097: l_pfcv_rec pfcv_rec_type := p_pfcv_rec;
1098: l_pfc_rec pfc_rec_type;
1099: l_okl_prtfl_cntrcts_tl_rec okl_prtfl_cntrcts_tl_rec_type;
1100: BEGIN
1101: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1102: G_PKG_NAME,
1103: p_init_msg_list,

Line 1466: -- insert_row for:OKL_PRTFL_CNTRCTS_TL --

1462: '_PVT'
1463: );
1464: END insert_row;
1465: -----------------------------------------
1466: -- insert_row for:OKL_PRTFL_CNTRCTS_TL --
1467: -----------------------------------------
1468: PROCEDURE insert_row(
1469: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1470: x_return_status OUT NOCOPY VARCHAR2,

Line 1473: p_okl_prtfl_cntrcts_tl_rec IN okl_prtfl_cntrcts_tl_rec_type,

1469: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1470: x_return_status OUT NOCOPY VARCHAR2,
1471: x_msg_count OUT NOCOPY NUMBER,
1472: x_msg_data OUT NOCOPY VARCHAR2,
1473: p_okl_prtfl_cntrcts_tl_rec IN okl_prtfl_cntrcts_tl_rec_type,
1474: x_okl_prtfl_cntrcts_tl_rec OUT NOCOPY okl_prtfl_cntrcts_tl_rec_type) IS
1475:
1476: l_api_version CONSTANT NUMBER := 1;
1477: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';

Line 1474: x_okl_prtfl_cntrcts_tl_rec OUT NOCOPY okl_prtfl_cntrcts_tl_rec_type) IS

1470: x_return_status OUT NOCOPY VARCHAR2,
1471: x_msg_count OUT NOCOPY NUMBER,
1472: x_msg_data OUT NOCOPY VARCHAR2,
1473: p_okl_prtfl_cntrcts_tl_rec IN okl_prtfl_cntrcts_tl_rec_type,
1474: x_okl_prtfl_cntrcts_tl_rec OUT NOCOPY okl_prtfl_cntrcts_tl_rec_type) IS
1475:
1476: l_api_version CONSTANT NUMBER := 1;
1477: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1478: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 1479: l_okl_prtfl_cntrcts_tl_rec okl_prtfl_cntrcts_tl_rec_type := p_okl_prtfl_cntrcts_tl_rec;

1475:
1476: l_api_version CONSTANT NUMBER := 1;
1477: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1478: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1479: l_okl_prtfl_cntrcts_tl_rec okl_prtfl_cntrcts_tl_rec_type := p_okl_prtfl_cntrcts_tl_rec;
1480: l_def_okl_prtfl_cntrcts_tl_rec okl_prtfl_cntrcts_tl_rec_type;
1481: CURSOR get_languages IS
1482: SELECT *
1483: FROM FND_LANGUAGES

Line 1480: l_def_okl_prtfl_cntrcts_tl_rec okl_prtfl_cntrcts_tl_rec_type;

1476: l_api_version CONSTANT NUMBER := 1;
1477: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1478: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1479: l_okl_prtfl_cntrcts_tl_rec okl_prtfl_cntrcts_tl_rec_type := p_okl_prtfl_cntrcts_tl_rec;
1480: l_def_okl_prtfl_cntrcts_tl_rec okl_prtfl_cntrcts_tl_rec_type;
1481: CURSOR get_languages IS
1482: SELECT *
1483: FROM FND_LANGUAGES
1484: WHERE INSTALLED_FLAG IN ('I', 'B');

Line 1486: -- Set_Attributes for:OKL_PRTFL_CNTRCTS_TL --

1482: SELECT *
1483: FROM FND_LANGUAGES
1484: WHERE INSTALLED_FLAG IN ('I', 'B');
1485: ---------------------------------------------
1486: -- Set_Attributes for:OKL_PRTFL_CNTRCTS_TL --
1487: ---------------------------------------------
1488: FUNCTION Set_Attributes (
1489: p_okl_prtfl_cntrcts_tl_rec IN okl_prtfl_cntrcts_tl_rec_type,
1490: x_okl_prtfl_cntrcts_tl_rec OUT NOCOPY okl_prtfl_cntrcts_tl_rec_type

Line 1489: p_okl_prtfl_cntrcts_tl_rec IN okl_prtfl_cntrcts_tl_rec_type,

1485: ---------------------------------------------
1486: -- Set_Attributes for:OKL_PRTFL_CNTRCTS_TL --
1487: ---------------------------------------------
1488: FUNCTION Set_Attributes (
1489: p_okl_prtfl_cntrcts_tl_rec IN okl_prtfl_cntrcts_tl_rec_type,
1490: x_okl_prtfl_cntrcts_tl_rec OUT NOCOPY okl_prtfl_cntrcts_tl_rec_type
1491: ) RETURN VARCHAR2 IS
1492: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1493: BEGIN

Line 1490: x_okl_prtfl_cntrcts_tl_rec OUT NOCOPY okl_prtfl_cntrcts_tl_rec_type

1486: -- Set_Attributes for:OKL_PRTFL_CNTRCTS_TL --
1487: ---------------------------------------------
1488: FUNCTION Set_Attributes (
1489: p_okl_prtfl_cntrcts_tl_rec IN okl_prtfl_cntrcts_tl_rec_type,
1490: x_okl_prtfl_cntrcts_tl_rec OUT NOCOPY okl_prtfl_cntrcts_tl_rec_type
1491: ) RETURN VARCHAR2 IS
1492: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1493: BEGIN
1494: x_okl_prtfl_cntrcts_tl_rec := p_okl_prtfl_cntrcts_tl_rec;

Line 1494: x_okl_prtfl_cntrcts_tl_rec := p_okl_prtfl_cntrcts_tl_rec;

1490: x_okl_prtfl_cntrcts_tl_rec OUT NOCOPY okl_prtfl_cntrcts_tl_rec_type
1491: ) RETURN VARCHAR2 IS
1492: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1493: BEGIN
1494: x_okl_prtfl_cntrcts_tl_rec := p_okl_prtfl_cntrcts_tl_rec;
1495: x_okl_prtfl_cntrcts_tl_rec.LANGUAGE := USERENV('LANG');
1496: x_okl_prtfl_cntrcts_tl_rec.SOURCE_LANG := USERENV('LANG');
1497: RETURN(l_return_status);
1498: END Set_Attributes;

Line 1495: x_okl_prtfl_cntrcts_tl_rec.LANGUAGE := USERENV('LANG');

1491: ) RETURN VARCHAR2 IS
1492: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1493: BEGIN
1494: x_okl_prtfl_cntrcts_tl_rec := p_okl_prtfl_cntrcts_tl_rec;
1495: x_okl_prtfl_cntrcts_tl_rec.LANGUAGE := USERENV('LANG');
1496: x_okl_prtfl_cntrcts_tl_rec.SOURCE_LANG := USERENV('LANG');
1497: RETURN(l_return_status);
1498: END Set_Attributes;
1499: BEGIN

Line 1496: x_okl_prtfl_cntrcts_tl_rec.SOURCE_LANG := USERENV('LANG');

1492: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1493: BEGIN
1494: x_okl_prtfl_cntrcts_tl_rec := p_okl_prtfl_cntrcts_tl_rec;
1495: x_okl_prtfl_cntrcts_tl_rec.LANGUAGE := USERENV('LANG');
1496: x_okl_prtfl_cntrcts_tl_rec.SOURCE_LANG := USERENV('LANG');
1497: RETURN(l_return_status);
1498: END Set_Attributes;
1499: BEGIN
1500: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

Line 1511: p_okl_prtfl_cntrcts_tl_rec, -- IN

1507: RAISE OKL_API.G_EXCEPTION_ERROR;
1508: END IF;
1509: --- Setting item attributes
1510: l_return_status := Set_Attributes(
1511: p_okl_prtfl_cntrcts_tl_rec, -- IN
1512: l_okl_prtfl_cntrcts_tl_rec); -- OUT
1513: --- If any errors happen abort API
1514: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1515: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1512: l_okl_prtfl_cntrcts_tl_rec); -- OUT

1508: END IF;
1509: --- Setting item attributes
1510: l_return_status := Set_Attributes(
1511: p_okl_prtfl_cntrcts_tl_rec, -- IN
1512: l_okl_prtfl_cntrcts_tl_rec); -- OUT
1513: --- If any errors happen abort API
1514: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1515: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1516: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

Line 1520: l_okl_prtfl_cntrcts_tl_rec.language := l_lang_rec.language_code;

1516: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1517: RAISE OKL_API.G_EXCEPTION_ERROR;
1518: END IF;
1519: FOR l_lang_rec IN get_languages LOOP
1520: l_okl_prtfl_cntrcts_tl_rec.language := l_lang_rec.language_code;
1521: INSERT INTO OKL_PRTFL_CNTRCTS_TL(
1522: id,
1523: language,
1524: source_lang,

Line 1521: INSERT INTO OKL_PRTFL_CNTRCTS_TL(

1517: RAISE OKL_API.G_EXCEPTION_ERROR;
1518: END IF;
1519: FOR l_lang_rec IN get_languages LOOP
1520: l_okl_prtfl_cntrcts_tl_rec.language := l_lang_rec.language_code;
1521: INSERT INTO OKL_PRTFL_CNTRCTS_TL(
1522: id,
1523: language,
1524: source_lang,
1525: sfwt_flag,

Line 1534: l_okl_prtfl_cntrcts_tl_rec.id,

1530: last_updated_by,
1531: last_update_date,
1532: last_update_login)
1533: VALUES (
1534: l_okl_prtfl_cntrcts_tl_rec.id,
1535: l_okl_prtfl_cntrcts_tl_rec.language,
1536: l_okl_prtfl_cntrcts_tl_rec.source_lang,
1537: l_okl_prtfl_cntrcts_tl_rec.sfwt_flag,
1538: l_okl_prtfl_cntrcts_tl_rec.name,

Line 1535: l_okl_prtfl_cntrcts_tl_rec.language,

1531: last_update_date,
1532: last_update_login)
1533: VALUES (
1534: l_okl_prtfl_cntrcts_tl_rec.id,
1535: l_okl_prtfl_cntrcts_tl_rec.language,
1536: l_okl_prtfl_cntrcts_tl_rec.source_lang,
1537: l_okl_prtfl_cntrcts_tl_rec.sfwt_flag,
1538: l_okl_prtfl_cntrcts_tl_rec.name,
1539: l_okl_prtfl_cntrcts_tl_rec.description,

Line 1536: l_okl_prtfl_cntrcts_tl_rec.source_lang,

1532: last_update_login)
1533: VALUES (
1534: l_okl_prtfl_cntrcts_tl_rec.id,
1535: l_okl_prtfl_cntrcts_tl_rec.language,
1536: l_okl_prtfl_cntrcts_tl_rec.source_lang,
1537: l_okl_prtfl_cntrcts_tl_rec.sfwt_flag,
1538: l_okl_prtfl_cntrcts_tl_rec.name,
1539: l_okl_prtfl_cntrcts_tl_rec.description,
1540: l_okl_prtfl_cntrcts_tl_rec.created_by,

Line 1537: l_okl_prtfl_cntrcts_tl_rec.sfwt_flag,

1533: VALUES (
1534: l_okl_prtfl_cntrcts_tl_rec.id,
1535: l_okl_prtfl_cntrcts_tl_rec.language,
1536: l_okl_prtfl_cntrcts_tl_rec.source_lang,
1537: l_okl_prtfl_cntrcts_tl_rec.sfwt_flag,
1538: l_okl_prtfl_cntrcts_tl_rec.name,
1539: l_okl_prtfl_cntrcts_tl_rec.description,
1540: l_okl_prtfl_cntrcts_tl_rec.created_by,
1541: l_okl_prtfl_cntrcts_tl_rec.creation_date,

Line 1538: l_okl_prtfl_cntrcts_tl_rec.name,

1534: l_okl_prtfl_cntrcts_tl_rec.id,
1535: l_okl_prtfl_cntrcts_tl_rec.language,
1536: l_okl_prtfl_cntrcts_tl_rec.source_lang,
1537: l_okl_prtfl_cntrcts_tl_rec.sfwt_flag,
1538: l_okl_prtfl_cntrcts_tl_rec.name,
1539: l_okl_prtfl_cntrcts_tl_rec.description,
1540: l_okl_prtfl_cntrcts_tl_rec.created_by,
1541: l_okl_prtfl_cntrcts_tl_rec.creation_date,
1542: l_okl_prtfl_cntrcts_tl_rec.last_updated_by,

Line 1539: l_okl_prtfl_cntrcts_tl_rec.description,

1535: l_okl_prtfl_cntrcts_tl_rec.language,
1536: l_okl_prtfl_cntrcts_tl_rec.source_lang,
1537: l_okl_prtfl_cntrcts_tl_rec.sfwt_flag,
1538: l_okl_prtfl_cntrcts_tl_rec.name,
1539: l_okl_prtfl_cntrcts_tl_rec.description,
1540: l_okl_prtfl_cntrcts_tl_rec.created_by,
1541: l_okl_prtfl_cntrcts_tl_rec.creation_date,
1542: l_okl_prtfl_cntrcts_tl_rec.last_updated_by,
1543: l_okl_prtfl_cntrcts_tl_rec.last_update_date,

Line 1540: l_okl_prtfl_cntrcts_tl_rec.created_by,

1536: l_okl_prtfl_cntrcts_tl_rec.source_lang,
1537: l_okl_prtfl_cntrcts_tl_rec.sfwt_flag,
1538: l_okl_prtfl_cntrcts_tl_rec.name,
1539: l_okl_prtfl_cntrcts_tl_rec.description,
1540: l_okl_prtfl_cntrcts_tl_rec.created_by,
1541: l_okl_prtfl_cntrcts_tl_rec.creation_date,
1542: l_okl_prtfl_cntrcts_tl_rec.last_updated_by,
1543: l_okl_prtfl_cntrcts_tl_rec.last_update_date,
1544: l_okl_prtfl_cntrcts_tl_rec.last_update_login);

Line 1541: l_okl_prtfl_cntrcts_tl_rec.creation_date,

1537: l_okl_prtfl_cntrcts_tl_rec.sfwt_flag,
1538: l_okl_prtfl_cntrcts_tl_rec.name,
1539: l_okl_prtfl_cntrcts_tl_rec.description,
1540: l_okl_prtfl_cntrcts_tl_rec.created_by,
1541: l_okl_prtfl_cntrcts_tl_rec.creation_date,
1542: l_okl_prtfl_cntrcts_tl_rec.last_updated_by,
1543: l_okl_prtfl_cntrcts_tl_rec.last_update_date,
1544: l_okl_prtfl_cntrcts_tl_rec.last_update_login);
1545: END LOOP;

Line 1542: l_okl_prtfl_cntrcts_tl_rec.last_updated_by,

1538: l_okl_prtfl_cntrcts_tl_rec.name,
1539: l_okl_prtfl_cntrcts_tl_rec.description,
1540: l_okl_prtfl_cntrcts_tl_rec.created_by,
1541: l_okl_prtfl_cntrcts_tl_rec.creation_date,
1542: l_okl_prtfl_cntrcts_tl_rec.last_updated_by,
1543: l_okl_prtfl_cntrcts_tl_rec.last_update_date,
1544: l_okl_prtfl_cntrcts_tl_rec.last_update_login);
1545: END LOOP;
1546: -- Set OUT values

Line 1543: l_okl_prtfl_cntrcts_tl_rec.last_update_date,

1539: l_okl_prtfl_cntrcts_tl_rec.description,
1540: l_okl_prtfl_cntrcts_tl_rec.created_by,
1541: l_okl_prtfl_cntrcts_tl_rec.creation_date,
1542: l_okl_prtfl_cntrcts_tl_rec.last_updated_by,
1543: l_okl_prtfl_cntrcts_tl_rec.last_update_date,
1544: l_okl_prtfl_cntrcts_tl_rec.last_update_login);
1545: END LOOP;
1546: -- Set OUT values
1547: x_okl_prtfl_cntrcts_tl_rec := l_okl_prtfl_cntrcts_tl_rec;

Line 1544: l_okl_prtfl_cntrcts_tl_rec.last_update_login);

1540: l_okl_prtfl_cntrcts_tl_rec.created_by,
1541: l_okl_prtfl_cntrcts_tl_rec.creation_date,
1542: l_okl_prtfl_cntrcts_tl_rec.last_updated_by,
1543: l_okl_prtfl_cntrcts_tl_rec.last_update_date,
1544: l_okl_prtfl_cntrcts_tl_rec.last_update_login);
1545: END LOOP;
1546: -- Set OUT values
1547: x_okl_prtfl_cntrcts_tl_rec := l_okl_prtfl_cntrcts_tl_rec;
1548: x_return_status := l_return_status;

Line 1547: x_okl_prtfl_cntrcts_tl_rec := l_okl_prtfl_cntrcts_tl_rec;

1543: l_okl_prtfl_cntrcts_tl_rec.last_update_date,
1544: l_okl_prtfl_cntrcts_tl_rec.last_update_login);
1545: END LOOP;
1546: -- Set OUT values
1547: x_okl_prtfl_cntrcts_tl_rec := l_okl_prtfl_cntrcts_tl_rec;
1548: x_return_status := l_return_status;
1549: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1550: EXCEPTION
1551: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 1601: l_okl_prtfl_cntrcts_tl_rec okl_prtfl_cntrcts_tl_rec_type;

1597: l_pfcv_rec pfcv_rec_type := p_pfcv_rec;
1598: l_def_pfcv_rec pfcv_rec_type;
1599: l_pfc_rec pfc_rec_type;
1600: lx_pfc_rec pfc_rec_type;
1601: l_okl_prtfl_cntrcts_tl_rec okl_prtfl_cntrcts_tl_rec_type;
1602: lx_okl_prtfl_cntrcts_tl_rec okl_prtfl_cntrcts_tl_rec_type;
1603: -------------------------------
1604: -- FUNCTION fill_who_columns --
1605: -------------------------------

Line 1602: lx_okl_prtfl_cntrcts_tl_rec okl_prtfl_cntrcts_tl_rec_type;

1598: l_def_pfcv_rec pfcv_rec_type;
1599: l_pfc_rec pfc_rec_type;
1600: lx_pfc_rec pfc_rec_type;
1601: l_okl_prtfl_cntrcts_tl_rec okl_prtfl_cntrcts_tl_rec_type;
1602: lx_okl_prtfl_cntrcts_tl_rec okl_prtfl_cntrcts_tl_rec_type;
1603: -------------------------------
1604: -- FUNCTION fill_who_columns --
1605: -------------------------------
1606: FUNCTION fill_who_columns (

Line 1677: migrate(l_def_pfcv_rec, l_okl_prtfl_cntrcts_tl_rec);

1673: -----------------------------------------
1674: -- Move VIEW record to "Child" records --
1675: -----------------------------------------
1676: migrate(l_def_pfcv_rec, l_pfc_rec);
1677: migrate(l_def_pfcv_rec, l_okl_prtfl_cntrcts_tl_rec);
1678: -----------------------------------------------
1679: -- Call the INSERT_ROW for each child record --
1680: -----------------------------------------------
1681: insert_row(

Line 1700: l_okl_prtfl_cntrcts_tl_rec,

1696: p_init_msg_list,
1697: l_return_status,
1698: x_msg_count,
1699: x_msg_data,
1700: l_okl_prtfl_cntrcts_tl_rec,
1701: lx_okl_prtfl_cntrcts_tl_rec
1702: );
1703: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1704: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1701: lx_okl_prtfl_cntrcts_tl_rec

1697: l_return_status,
1698: x_msg_count,
1699: x_msg_data,
1700: l_okl_prtfl_cntrcts_tl_rec,
1701: lx_okl_prtfl_cntrcts_tl_rec
1702: );
1703: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1704: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1705: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

Line 1708: migrate(lx_okl_prtfl_cntrcts_tl_rec, l_def_pfcv_rec);

1704: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1705: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1706: RAISE OKL_API.G_EXCEPTION_ERROR;
1707: END IF;
1708: migrate(lx_okl_prtfl_cntrcts_tl_rec, l_def_pfcv_rec);
1709: -- Set OUT values
1710: x_pfcv_rec := l_def_pfcv_rec;
1711: x_return_status := l_return_status;
1712: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2018: -- lock_row for:OKL_PRTFL_CNTRCTS_TL --

2014: '_PVT'
2015: );
2016: END lock_row;
2017: ---------------------------------------
2018: -- lock_row for:OKL_PRTFL_CNTRCTS_TL --
2019: ---------------------------------------
2020: PROCEDURE lock_row(
2021: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2022: x_return_status OUT NOCOPY VARCHAR2,

Line 2025: p_okl_prtfl_cntrcts_tl_rec IN okl_prtfl_cntrcts_tl_rec_type) IS

2021: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2022: x_return_status OUT NOCOPY VARCHAR2,
2023: x_msg_count OUT NOCOPY NUMBER,
2024: x_msg_data OUT NOCOPY VARCHAR2,
2025: p_okl_prtfl_cntrcts_tl_rec IN okl_prtfl_cntrcts_tl_rec_type) IS
2026:
2027: E_Resource_Busy EXCEPTION;
2028: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2029: CURSOR lock_csr (p_okl_prtfl_cntrcts_tl_rec IN okl_prtfl_cntrcts_tl_rec_type) IS

Line 2029: CURSOR lock_csr (p_okl_prtfl_cntrcts_tl_rec IN okl_prtfl_cntrcts_tl_rec_type) IS

2025: p_okl_prtfl_cntrcts_tl_rec IN okl_prtfl_cntrcts_tl_rec_type) IS
2026:
2027: E_Resource_Busy EXCEPTION;
2028: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2029: CURSOR lock_csr (p_okl_prtfl_cntrcts_tl_rec IN okl_prtfl_cntrcts_tl_rec_type) IS
2030: SELECT *
2031: FROM OKL_PRTFL_CNTRCTS_TL
2032: WHERE ID = p_okl_prtfl_cntrcts_tl_rec.id
2033: FOR UPDATE NOWAIT;

Line 2031: FROM OKL_PRTFL_CNTRCTS_TL

2027: E_Resource_Busy EXCEPTION;
2028: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2029: CURSOR lock_csr (p_okl_prtfl_cntrcts_tl_rec IN okl_prtfl_cntrcts_tl_rec_type) IS
2030: SELECT *
2031: FROM OKL_PRTFL_CNTRCTS_TL
2032: WHERE ID = p_okl_prtfl_cntrcts_tl_rec.id
2033: FOR UPDATE NOWAIT;
2034:
2035: l_api_version CONSTANT NUMBER := 1;

Line 2032: WHERE ID = p_okl_prtfl_cntrcts_tl_rec.id

2028: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2029: CURSOR lock_csr (p_okl_prtfl_cntrcts_tl_rec IN okl_prtfl_cntrcts_tl_rec_type) IS
2030: SELECT *
2031: FROM OKL_PRTFL_CNTRCTS_TL
2032: WHERE ID = p_okl_prtfl_cntrcts_tl_rec.id
2033: FOR UPDATE NOWAIT;
2034:
2035: l_api_version CONSTANT NUMBER := 1;
2036: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';

Line 2052: OPEN lock_csr(p_okl_prtfl_cntrcts_tl_rec);

2048: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2049: RAISE OKL_API.G_EXCEPTION_ERROR;
2050: END IF;
2051: BEGIN
2052: OPEN lock_csr(p_okl_prtfl_cntrcts_tl_rec);
2053: FETCH lock_csr INTO l_lock_var;
2054: l_row_notfound := lock_csr%NOTFOUND;
2055: CLOSE lock_csr;
2056: EXCEPTION

Line 2118: l_okl_prtfl_cntrcts_tl_rec okl_prtfl_cntrcts_tl_rec_type;

2114: l_api_version CONSTANT NUMBER := 1;
2115: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
2116: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2117: l_pfc_rec pfc_rec_type;
2118: l_okl_prtfl_cntrcts_tl_rec okl_prtfl_cntrcts_tl_rec_type;
2119: BEGIN
2120: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
2121: G_PKG_NAME,
2122: p_init_msg_list,

Line 2136: migrate(p_pfcv_rec, l_okl_prtfl_cntrcts_tl_rec);

2132: -----------------------------------------
2133: -- Move VIEW record to "Child" records --
2134: -----------------------------------------
2135: migrate(p_pfcv_rec, l_pfc_rec);
2136: migrate(p_pfcv_rec, l_okl_prtfl_cntrcts_tl_rec);
2137: ---------------------------------------------
2138: -- Call the LOCK_ROW for each child record --
2139: ---------------------------------------------
2140: lock_row(

Line 2157: l_okl_prtfl_cntrcts_tl_rec

2153: p_init_msg_list,
2154: l_return_status,
2155: x_msg_count,
2156: x_msg_data,
2157: l_okl_prtfl_cntrcts_tl_rec
2158: );
2159: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2160: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2161: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

Line 2614: -- update_row for:OKL_PRTFL_CNTRCTS_TL --

2610: '_PVT'
2611: );
2612: END update_row;
2613: -----------------------------------------
2614: -- update_row for:OKL_PRTFL_CNTRCTS_TL --
2615: -----------------------------------------
2616: PROCEDURE update_row(
2617: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2618: x_return_status OUT NOCOPY VARCHAR2,

Line 2621: p_okl_prtfl_cntrcts_tl_rec IN okl_prtfl_cntrcts_tl_rec_type,

2617: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2618: x_return_status OUT NOCOPY VARCHAR2,
2619: x_msg_count OUT NOCOPY NUMBER,
2620: x_msg_data OUT NOCOPY VARCHAR2,
2621: p_okl_prtfl_cntrcts_tl_rec IN okl_prtfl_cntrcts_tl_rec_type,
2622: x_okl_prtfl_cntrcts_tl_rec OUT NOCOPY okl_prtfl_cntrcts_tl_rec_type) IS
2623:
2624: l_api_version CONSTANT NUMBER := 1;
2625: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';

Line 2622: x_okl_prtfl_cntrcts_tl_rec OUT NOCOPY okl_prtfl_cntrcts_tl_rec_type) IS

2618: x_return_status OUT NOCOPY VARCHAR2,
2619: x_msg_count OUT NOCOPY NUMBER,
2620: x_msg_data OUT NOCOPY VARCHAR2,
2621: p_okl_prtfl_cntrcts_tl_rec IN okl_prtfl_cntrcts_tl_rec_type,
2622: x_okl_prtfl_cntrcts_tl_rec OUT NOCOPY okl_prtfl_cntrcts_tl_rec_type) IS
2623:
2624: l_api_version CONSTANT NUMBER := 1;
2625: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2626: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 2627: l_okl_prtfl_cntrcts_tl_rec okl_prtfl_cntrcts_tl_rec_type := p_okl_prtfl_cntrcts_tl_rec;

2623:
2624: l_api_version CONSTANT NUMBER := 1;
2625: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2626: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2627: l_okl_prtfl_cntrcts_tl_rec okl_prtfl_cntrcts_tl_rec_type := p_okl_prtfl_cntrcts_tl_rec;
2628: l_def_okl_prtfl_cntrcts_tl_rec okl_prtfl_cntrcts_tl_rec_type;
2629: l_row_notfound BOOLEAN := TRUE;
2630: ----------------------------------
2631: -- FUNCTION populate_new_record --

Line 2628: l_def_okl_prtfl_cntrcts_tl_rec okl_prtfl_cntrcts_tl_rec_type;

2624: l_api_version CONSTANT NUMBER := 1;
2625: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2626: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2627: l_okl_prtfl_cntrcts_tl_rec okl_prtfl_cntrcts_tl_rec_type := p_okl_prtfl_cntrcts_tl_rec;
2628: l_def_okl_prtfl_cntrcts_tl_rec okl_prtfl_cntrcts_tl_rec_type;
2629: l_row_notfound BOOLEAN := TRUE;
2630: ----------------------------------
2631: -- FUNCTION populate_new_record --
2632: ----------------------------------

Line 2634: p_okl_prtfl_cntrcts_tl_rec IN okl_prtfl_cntrcts_tl_rec_type,

2630: ----------------------------------
2631: -- FUNCTION populate_new_record --
2632: ----------------------------------
2633: FUNCTION populate_new_record (
2634: p_okl_prtfl_cntrcts_tl_rec IN okl_prtfl_cntrcts_tl_rec_type,
2635: x_okl_prtfl_cntrcts_tl_rec OUT NOCOPY okl_prtfl_cntrcts_tl_rec_type
2636: ) RETURN VARCHAR2 IS
2637: l_okl_prtfl_cntrcts_tl_rec okl_prtfl_cntrcts_tl_rec_type;
2638: l_row_notfound BOOLEAN := TRUE;

Line 2635: x_okl_prtfl_cntrcts_tl_rec OUT NOCOPY okl_prtfl_cntrcts_tl_rec_type

2631: -- FUNCTION populate_new_record --
2632: ----------------------------------
2633: FUNCTION populate_new_record (
2634: p_okl_prtfl_cntrcts_tl_rec IN okl_prtfl_cntrcts_tl_rec_type,
2635: x_okl_prtfl_cntrcts_tl_rec OUT NOCOPY okl_prtfl_cntrcts_tl_rec_type
2636: ) RETURN VARCHAR2 IS
2637: l_okl_prtfl_cntrcts_tl_rec okl_prtfl_cntrcts_tl_rec_type;
2638: l_row_notfound BOOLEAN := TRUE;
2639: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 2637: l_okl_prtfl_cntrcts_tl_rec okl_prtfl_cntrcts_tl_rec_type;

2633: FUNCTION populate_new_record (
2634: p_okl_prtfl_cntrcts_tl_rec IN okl_prtfl_cntrcts_tl_rec_type,
2635: x_okl_prtfl_cntrcts_tl_rec OUT NOCOPY okl_prtfl_cntrcts_tl_rec_type
2636: ) RETURN VARCHAR2 IS
2637: l_okl_prtfl_cntrcts_tl_rec okl_prtfl_cntrcts_tl_rec_type;
2638: l_row_notfound BOOLEAN := TRUE;
2639: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2640: BEGIN
2641: x_okl_prtfl_cntrcts_tl_rec := p_okl_prtfl_cntrcts_tl_rec;

Line 2641: x_okl_prtfl_cntrcts_tl_rec := p_okl_prtfl_cntrcts_tl_rec;

2637: l_okl_prtfl_cntrcts_tl_rec okl_prtfl_cntrcts_tl_rec_type;
2638: l_row_notfound BOOLEAN := TRUE;
2639: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2640: BEGIN
2641: x_okl_prtfl_cntrcts_tl_rec := p_okl_prtfl_cntrcts_tl_rec;
2642: -- Get current database values
2643: l_okl_prtfl_cntrcts_tl_rec := get_rec(p_okl_prtfl_cntrcts_tl_rec, l_return_status);
2644: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
2645: IF (x_okl_prtfl_cntrcts_tl_rec.id = OKL_API.G_MISS_NUM)

Line 2643: l_okl_prtfl_cntrcts_tl_rec := get_rec(p_okl_prtfl_cntrcts_tl_rec, l_return_status);

2639: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2640: BEGIN
2641: x_okl_prtfl_cntrcts_tl_rec := p_okl_prtfl_cntrcts_tl_rec;
2642: -- Get current database values
2643: l_okl_prtfl_cntrcts_tl_rec := get_rec(p_okl_prtfl_cntrcts_tl_rec, l_return_status);
2644: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
2645: IF (x_okl_prtfl_cntrcts_tl_rec.id = OKL_API.G_MISS_NUM)
2646: THEN
2647: x_okl_prtfl_cntrcts_tl_rec.id := l_okl_prtfl_cntrcts_tl_rec.id;

Line 2645: IF (x_okl_prtfl_cntrcts_tl_rec.id = OKL_API.G_MISS_NUM)

2641: x_okl_prtfl_cntrcts_tl_rec := p_okl_prtfl_cntrcts_tl_rec;
2642: -- Get current database values
2643: l_okl_prtfl_cntrcts_tl_rec := get_rec(p_okl_prtfl_cntrcts_tl_rec, l_return_status);
2644: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
2645: IF (x_okl_prtfl_cntrcts_tl_rec.id = OKL_API.G_MISS_NUM)
2646: THEN
2647: x_okl_prtfl_cntrcts_tl_rec.id := l_okl_prtfl_cntrcts_tl_rec.id;
2648: END IF;
2649: IF (x_okl_prtfl_cntrcts_tl_rec.language = OKL_API.G_MISS_CHAR)

Line 2647: x_okl_prtfl_cntrcts_tl_rec.id := l_okl_prtfl_cntrcts_tl_rec.id;

2643: l_okl_prtfl_cntrcts_tl_rec := get_rec(p_okl_prtfl_cntrcts_tl_rec, l_return_status);
2644: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
2645: IF (x_okl_prtfl_cntrcts_tl_rec.id = OKL_API.G_MISS_NUM)
2646: THEN
2647: x_okl_prtfl_cntrcts_tl_rec.id := l_okl_prtfl_cntrcts_tl_rec.id;
2648: END IF;
2649: IF (x_okl_prtfl_cntrcts_tl_rec.language = OKL_API.G_MISS_CHAR)
2650: THEN
2651: x_okl_prtfl_cntrcts_tl_rec.language := l_okl_prtfl_cntrcts_tl_rec.language;

Line 2649: IF (x_okl_prtfl_cntrcts_tl_rec.language = OKL_API.G_MISS_CHAR)

2645: IF (x_okl_prtfl_cntrcts_tl_rec.id = OKL_API.G_MISS_NUM)
2646: THEN
2647: x_okl_prtfl_cntrcts_tl_rec.id := l_okl_prtfl_cntrcts_tl_rec.id;
2648: END IF;
2649: IF (x_okl_prtfl_cntrcts_tl_rec.language = OKL_API.G_MISS_CHAR)
2650: THEN
2651: x_okl_prtfl_cntrcts_tl_rec.language := l_okl_prtfl_cntrcts_tl_rec.language;
2652: END IF;
2653: IF (x_okl_prtfl_cntrcts_tl_rec.source_lang = OKL_API.G_MISS_CHAR)

Line 2651: x_okl_prtfl_cntrcts_tl_rec.language := l_okl_prtfl_cntrcts_tl_rec.language;

2647: x_okl_prtfl_cntrcts_tl_rec.id := l_okl_prtfl_cntrcts_tl_rec.id;
2648: END IF;
2649: IF (x_okl_prtfl_cntrcts_tl_rec.language = OKL_API.G_MISS_CHAR)
2650: THEN
2651: x_okl_prtfl_cntrcts_tl_rec.language := l_okl_prtfl_cntrcts_tl_rec.language;
2652: END IF;
2653: IF (x_okl_prtfl_cntrcts_tl_rec.source_lang = OKL_API.G_MISS_CHAR)
2654: THEN
2655: x_okl_prtfl_cntrcts_tl_rec.source_lang := l_okl_prtfl_cntrcts_tl_rec.source_lang;

Line 2653: IF (x_okl_prtfl_cntrcts_tl_rec.source_lang = OKL_API.G_MISS_CHAR)

2649: IF (x_okl_prtfl_cntrcts_tl_rec.language = OKL_API.G_MISS_CHAR)
2650: THEN
2651: x_okl_prtfl_cntrcts_tl_rec.language := l_okl_prtfl_cntrcts_tl_rec.language;
2652: END IF;
2653: IF (x_okl_prtfl_cntrcts_tl_rec.source_lang = OKL_API.G_MISS_CHAR)
2654: THEN
2655: x_okl_prtfl_cntrcts_tl_rec.source_lang := l_okl_prtfl_cntrcts_tl_rec.source_lang;
2656: END IF;
2657: IF (x_okl_prtfl_cntrcts_tl_rec.sfwt_flag = OKL_API.G_MISS_CHAR)

Line 2655: x_okl_prtfl_cntrcts_tl_rec.source_lang := l_okl_prtfl_cntrcts_tl_rec.source_lang;

2651: x_okl_prtfl_cntrcts_tl_rec.language := l_okl_prtfl_cntrcts_tl_rec.language;
2652: END IF;
2653: IF (x_okl_prtfl_cntrcts_tl_rec.source_lang = OKL_API.G_MISS_CHAR)
2654: THEN
2655: x_okl_prtfl_cntrcts_tl_rec.source_lang := l_okl_prtfl_cntrcts_tl_rec.source_lang;
2656: END IF;
2657: IF (x_okl_prtfl_cntrcts_tl_rec.sfwt_flag = OKL_API.G_MISS_CHAR)
2658: THEN
2659: x_okl_prtfl_cntrcts_tl_rec.sfwt_flag := l_okl_prtfl_cntrcts_tl_rec.sfwt_flag;

Line 2657: IF (x_okl_prtfl_cntrcts_tl_rec.sfwt_flag = OKL_API.G_MISS_CHAR)

2653: IF (x_okl_prtfl_cntrcts_tl_rec.source_lang = OKL_API.G_MISS_CHAR)
2654: THEN
2655: x_okl_prtfl_cntrcts_tl_rec.source_lang := l_okl_prtfl_cntrcts_tl_rec.source_lang;
2656: END IF;
2657: IF (x_okl_prtfl_cntrcts_tl_rec.sfwt_flag = OKL_API.G_MISS_CHAR)
2658: THEN
2659: x_okl_prtfl_cntrcts_tl_rec.sfwt_flag := l_okl_prtfl_cntrcts_tl_rec.sfwt_flag;
2660: END IF;
2661: IF (x_okl_prtfl_cntrcts_tl_rec.name = OKL_API.G_MISS_CHAR)

Line 2659: x_okl_prtfl_cntrcts_tl_rec.sfwt_flag := l_okl_prtfl_cntrcts_tl_rec.sfwt_flag;

2655: x_okl_prtfl_cntrcts_tl_rec.source_lang := l_okl_prtfl_cntrcts_tl_rec.source_lang;
2656: END IF;
2657: IF (x_okl_prtfl_cntrcts_tl_rec.sfwt_flag = OKL_API.G_MISS_CHAR)
2658: THEN
2659: x_okl_prtfl_cntrcts_tl_rec.sfwt_flag := l_okl_prtfl_cntrcts_tl_rec.sfwt_flag;
2660: END IF;
2661: IF (x_okl_prtfl_cntrcts_tl_rec.name = OKL_API.G_MISS_CHAR)
2662: THEN
2663: x_okl_prtfl_cntrcts_tl_rec.name := l_okl_prtfl_cntrcts_tl_rec.name;

Line 2661: IF (x_okl_prtfl_cntrcts_tl_rec.name = OKL_API.G_MISS_CHAR)

2657: IF (x_okl_prtfl_cntrcts_tl_rec.sfwt_flag = OKL_API.G_MISS_CHAR)
2658: THEN
2659: x_okl_prtfl_cntrcts_tl_rec.sfwt_flag := l_okl_prtfl_cntrcts_tl_rec.sfwt_flag;
2660: END IF;
2661: IF (x_okl_prtfl_cntrcts_tl_rec.name = OKL_API.G_MISS_CHAR)
2662: THEN
2663: x_okl_prtfl_cntrcts_tl_rec.name := l_okl_prtfl_cntrcts_tl_rec.name;
2664: END IF;
2665: IF (x_okl_prtfl_cntrcts_tl_rec.description = OKL_API.G_MISS_CHAR)

Line 2663: x_okl_prtfl_cntrcts_tl_rec.name := l_okl_prtfl_cntrcts_tl_rec.name;

2659: x_okl_prtfl_cntrcts_tl_rec.sfwt_flag := l_okl_prtfl_cntrcts_tl_rec.sfwt_flag;
2660: END IF;
2661: IF (x_okl_prtfl_cntrcts_tl_rec.name = OKL_API.G_MISS_CHAR)
2662: THEN
2663: x_okl_prtfl_cntrcts_tl_rec.name := l_okl_prtfl_cntrcts_tl_rec.name;
2664: END IF;
2665: IF (x_okl_prtfl_cntrcts_tl_rec.description = OKL_API.G_MISS_CHAR)
2666: THEN
2667: x_okl_prtfl_cntrcts_tl_rec.description := l_okl_prtfl_cntrcts_tl_rec.description;

Line 2665: IF (x_okl_prtfl_cntrcts_tl_rec.description = OKL_API.G_MISS_CHAR)

2661: IF (x_okl_prtfl_cntrcts_tl_rec.name = OKL_API.G_MISS_CHAR)
2662: THEN
2663: x_okl_prtfl_cntrcts_tl_rec.name := l_okl_prtfl_cntrcts_tl_rec.name;
2664: END IF;
2665: IF (x_okl_prtfl_cntrcts_tl_rec.description = OKL_API.G_MISS_CHAR)
2666: THEN
2667: x_okl_prtfl_cntrcts_tl_rec.description := l_okl_prtfl_cntrcts_tl_rec.description;
2668: END IF;
2669: IF (x_okl_prtfl_cntrcts_tl_rec.created_by = OKL_API.G_MISS_NUM)

Line 2667: x_okl_prtfl_cntrcts_tl_rec.description := l_okl_prtfl_cntrcts_tl_rec.description;

2663: x_okl_prtfl_cntrcts_tl_rec.name := l_okl_prtfl_cntrcts_tl_rec.name;
2664: END IF;
2665: IF (x_okl_prtfl_cntrcts_tl_rec.description = OKL_API.G_MISS_CHAR)
2666: THEN
2667: x_okl_prtfl_cntrcts_tl_rec.description := l_okl_prtfl_cntrcts_tl_rec.description;
2668: END IF;
2669: IF (x_okl_prtfl_cntrcts_tl_rec.created_by = OKL_API.G_MISS_NUM)
2670: THEN
2671: x_okl_prtfl_cntrcts_tl_rec.created_by := l_okl_prtfl_cntrcts_tl_rec.created_by;

Line 2669: IF (x_okl_prtfl_cntrcts_tl_rec.created_by = OKL_API.G_MISS_NUM)

2665: IF (x_okl_prtfl_cntrcts_tl_rec.description = OKL_API.G_MISS_CHAR)
2666: THEN
2667: x_okl_prtfl_cntrcts_tl_rec.description := l_okl_prtfl_cntrcts_tl_rec.description;
2668: END IF;
2669: IF (x_okl_prtfl_cntrcts_tl_rec.created_by = OKL_API.G_MISS_NUM)
2670: THEN
2671: x_okl_prtfl_cntrcts_tl_rec.created_by := l_okl_prtfl_cntrcts_tl_rec.created_by;
2672: END IF;
2673: IF (x_okl_prtfl_cntrcts_tl_rec.creation_date = OKL_API.G_MISS_DATE)

Line 2671: x_okl_prtfl_cntrcts_tl_rec.created_by := l_okl_prtfl_cntrcts_tl_rec.created_by;

2667: x_okl_prtfl_cntrcts_tl_rec.description := l_okl_prtfl_cntrcts_tl_rec.description;
2668: END IF;
2669: IF (x_okl_prtfl_cntrcts_tl_rec.created_by = OKL_API.G_MISS_NUM)
2670: THEN
2671: x_okl_prtfl_cntrcts_tl_rec.created_by := l_okl_prtfl_cntrcts_tl_rec.created_by;
2672: END IF;
2673: IF (x_okl_prtfl_cntrcts_tl_rec.creation_date = OKL_API.G_MISS_DATE)
2674: THEN
2675: x_okl_prtfl_cntrcts_tl_rec.creation_date := l_okl_prtfl_cntrcts_tl_rec.creation_date;

Line 2673: IF (x_okl_prtfl_cntrcts_tl_rec.creation_date = OKL_API.G_MISS_DATE)

2669: IF (x_okl_prtfl_cntrcts_tl_rec.created_by = OKL_API.G_MISS_NUM)
2670: THEN
2671: x_okl_prtfl_cntrcts_tl_rec.created_by := l_okl_prtfl_cntrcts_tl_rec.created_by;
2672: END IF;
2673: IF (x_okl_prtfl_cntrcts_tl_rec.creation_date = OKL_API.G_MISS_DATE)
2674: THEN
2675: x_okl_prtfl_cntrcts_tl_rec.creation_date := l_okl_prtfl_cntrcts_tl_rec.creation_date;
2676: END IF;
2677: IF (x_okl_prtfl_cntrcts_tl_rec.last_updated_by = OKL_API.G_MISS_NUM)

Line 2675: x_okl_prtfl_cntrcts_tl_rec.creation_date := l_okl_prtfl_cntrcts_tl_rec.creation_date;

2671: x_okl_prtfl_cntrcts_tl_rec.created_by := l_okl_prtfl_cntrcts_tl_rec.created_by;
2672: END IF;
2673: IF (x_okl_prtfl_cntrcts_tl_rec.creation_date = OKL_API.G_MISS_DATE)
2674: THEN
2675: x_okl_prtfl_cntrcts_tl_rec.creation_date := l_okl_prtfl_cntrcts_tl_rec.creation_date;
2676: END IF;
2677: IF (x_okl_prtfl_cntrcts_tl_rec.last_updated_by = OKL_API.G_MISS_NUM)
2678: THEN
2679: x_okl_prtfl_cntrcts_tl_rec.last_updated_by := l_okl_prtfl_cntrcts_tl_rec.last_updated_by;

Line 2677: IF (x_okl_prtfl_cntrcts_tl_rec.last_updated_by = OKL_API.G_MISS_NUM)

2673: IF (x_okl_prtfl_cntrcts_tl_rec.creation_date = OKL_API.G_MISS_DATE)
2674: THEN
2675: x_okl_prtfl_cntrcts_tl_rec.creation_date := l_okl_prtfl_cntrcts_tl_rec.creation_date;
2676: END IF;
2677: IF (x_okl_prtfl_cntrcts_tl_rec.last_updated_by = OKL_API.G_MISS_NUM)
2678: THEN
2679: x_okl_prtfl_cntrcts_tl_rec.last_updated_by := l_okl_prtfl_cntrcts_tl_rec.last_updated_by;
2680: END IF;
2681: IF (x_okl_prtfl_cntrcts_tl_rec.last_update_date = OKL_API.G_MISS_DATE)

Line 2679: x_okl_prtfl_cntrcts_tl_rec.last_updated_by := l_okl_prtfl_cntrcts_tl_rec.last_updated_by;

2675: x_okl_prtfl_cntrcts_tl_rec.creation_date := l_okl_prtfl_cntrcts_tl_rec.creation_date;
2676: END IF;
2677: IF (x_okl_prtfl_cntrcts_tl_rec.last_updated_by = OKL_API.G_MISS_NUM)
2678: THEN
2679: x_okl_prtfl_cntrcts_tl_rec.last_updated_by := l_okl_prtfl_cntrcts_tl_rec.last_updated_by;
2680: END IF;
2681: IF (x_okl_prtfl_cntrcts_tl_rec.last_update_date = OKL_API.G_MISS_DATE)
2682: THEN
2683: x_okl_prtfl_cntrcts_tl_rec.last_update_date := l_okl_prtfl_cntrcts_tl_rec.last_update_date;

Line 2681: IF (x_okl_prtfl_cntrcts_tl_rec.last_update_date = OKL_API.G_MISS_DATE)

2677: IF (x_okl_prtfl_cntrcts_tl_rec.last_updated_by = OKL_API.G_MISS_NUM)
2678: THEN
2679: x_okl_prtfl_cntrcts_tl_rec.last_updated_by := l_okl_prtfl_cntrcts_tl_rec.last_updated_by;
2680: END IF;
2681: IF (x_okl_prtfl_cntrcts_tl_rec.last_update_date = OKL_API.G_MISS_DATE)
2682: THEN
2683: x_okl_prtfl_cntrcts_tl_rec.last_update_date := l_okl_prtfl_cntrcts_tl_rec.last_update_date;
2684: END IF;
2685: IF (x_okl_prtfl_cntrcts_tl_rec.last_update_login = OKL_API.G_MISS_NUM)

Line 2683: x_okl_prtfl_cntrcts_tl_rec.last_update_date := l_okl_prtfl_cntrcts_tl_rec.last_update_date;

2679: x_okl_prtfl_cntrcts_tl_rec.last_updated_by := l_okl_prtfl_cntrcts_tl_rec.last_updated_by;
2680: END IF;
2681: IF (x_okl_prtfl_cntrcts_tl_rec.last_update_date = OKL_API.G_MISS_DATE)
2682: THEN
2683: x_okl_prtfl_cntrcts_tl_rec.last_update_date := l_okl_prtfl_cntrcts_tl_rec.last_update_date;
2684: END IF;
2685: IF (x_okl_prtfl_cntrcts_tl_rec.last_update_login = OKL_API.G_MISS_NUM)
2686: THEN
2687: x_okl_prtfl_cntrcts_tl_rec.last_update_login := l_okl_prtfl_cntrcts_tl_rec.last_update_login;

Line 2685: IF (x_okl_prtfl_cntrcts_tl_rec.last_update_login = OKL_API.G_MISS_NUM)

2681: IF (x_okl_prtfl_cntrcts_tl_rec.last_update_date = OKL_API.G_MISS_DATE)
2682: THEN
2683: x_okl_prtfl_cntrcts_tl_rec.last_update_date := l_okl_prtfl_cntrcts_tl_rec.last_update_date;
2684: END IF;
2685: IF (x_okl_prtfl_cntrcts_tl_rec.last_update_login = OKL_API.G_MISS_NUM)
2686: THEN
2687: x_okl_prtfl_cntrcts_tl_rec.last_update_login := l_okl_prtfl_cntrcts_tl_rec.last_update_login;
2688: END IF;
2689: END IF;

Line 2687: x_okl_prtfl_cntrcts_tl_rec.last_update_login := l_okl_prtfl_cntrcts_tl_rec.last_update_login;

2683: x_okl_prtfl_cntrcts_tl_rec.last_update_date := l_okl_prtfl_cntrcts_tl_rec.last_update_date;
2684: END IF;
2685: IF (x_okl_prtfl_cntrcts_tl_rec.last_update_login = OKL_API.G_MISS_NUM)
2686: THEN
2687: x_okl_prtfl_cntrcts_tl_rec.last_update_login := l_okl_prtfl_cntrcts_tl_rec.last_update_login;
2688: END IF;
2689: END IF;
2690: RETURN(l_return_status);
2691: END populate_new_record;

Line 2693: -- Set_Attributes for:OKL_PRTFL_CNTRCTS_TL --

2689: END IF;
2690: RETURN(l_return_status);
2691: END populate_new_record;
2692: ---------------------------------------------
2693: -- Set_Attributes for:OKL_PRTFL_CNTRCTS_TL --
2694: ---------------------------------------------
2695: FUNCTION Set_Attributes (
2696: p_okl_prtfl_cntrcts_tl_rec IN okl_prtfl_cntrcts_tl_rec_type,
2697: x_okl_prtfl_cntrcts_tl_rec OUT NOCOPY okl_prtfl_cntrcts_tl_rec_type

Line 2696: p_okl_prtfl_cntrcts_tl_rec IN okl_prtfl_cntrcts_tl_rec_type,

2692: ---------------------------------------------
2693: -- Set_Attributes for:OKL_PRTFL_CNTRCTS_TL --
2694: ---------------------------------------------
2695: FUNCTION Set_Attributes (
2696: p_okl_prtfl_cntrcts_tl_rec IN okl_prtfl_cntrcts_tl_rec_type,
2697: x_okl_prtfl_cntrcts_tl_rec OUT NOCOPY okl_prtfl_cntrcts_tl_rec_type
2698: ) RETURN VARCHAR2 IS
2699: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2700: BEGIN

Line 2697: x_okl_prtfl_cntrcts_tl_rec OUT NOCOPY okl_prtfl_cntrcts_tl_rec_type

2693: -- Set_Attributes for:OKL_PRTFL_CNTRCTS_TL --
2694: ---------------------------------------------
2695: FUNCTION Set_Attributes (
2696: p_okl_prtfl_cntrcts_tl_rec IN okl_prtfl_cntrcts_tl_rec_type,
2697: x_okl_prtfl_cntrcts_tl_rec OUT NOCOPY okl_prtfl_cntrcts_tl_rec_type
2698: ) RETURN VARCHAR2 IS
2699: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2700: BEGIN
2701: x_okl_prtfl_cntrcts_tl_rec := p_okl_prtfl_cntrcts_tl_rec;

Line 2701: x_okl_prtfl_cntrcts_tl_rec := p_okl_prtfl_cntrcts_tl_rec;

2697: x_okl_prtfl_cntrcts_tl_rec OUT NOCOPY okl_prtfl_cntrcts_tl_rec_type
2698: ) RETURN VARCHAR2 IS
2699: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2700: BEGIN
2701: x_okl_prtfl_cntrcts_tl_rec := p_okl_prtfl_cntrcts_tl_rec;
2702: x_okl_prtfl_cntrcts_tl_rec.LANGUAGE := USERENV('LANG');
2703: x_okl_prtfl_cntrcts_tl_rec.LANGUAGE := USERENV('LANG');
2704: RETURN(l_return_status);
2705: END Set_Attributes;

Line 2702: x_okl_prtfl_cntrcts_tl_rec.LANGUAGE := USERENV('LANG');

2698: ) RETURN VARCHAR2 IS
2699: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2700: BEGIN
2701: x_okl_prtfl_cntrcts_tl_rec := p_okl_prtfl_cntrcts_tl_rec;
2702: x_okl_prtfl_cntrcts_tl_rec.LANGUAGE := USERENV('LANG');
2703: x_okl_prtfl_cntrcts_tl_rec.LANGUAGE := USERENV('LANG');
2704: RETURN(l_return_status);
2705: END Set_Attributes;
2706: BEGIN

Line 2703: x_okl_prtfl_cntrcts_tl_rec.LANGUAGE := USERENV('LANG');

2699: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2700: BEGIN
2701: x_okl_prtfl_cntrcts_tl_rec := p_okl_prtfl_cntrcts_tl_rec;
2702: x_okl_prtfl_cntrcts_tl_rec.LANGUAGE := USERENV('LANG');
2703: x_okl_prtfl_cntrcts_tl_rec.LANGUAGE := USERENV('LANG');
2704: RETURN(l_return_status);
2705: END Set_Attributes;
2706: BEGIN
2707: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

Line 2718: p_okl_prtfl_cntrcts_tl_rec, -- IN

2714: RAISE OKL_API.G_EXCEPTION_ERROR;
2715: END IF;
2716: --- Setting item attributes
2717: l_return_status := Set_Attributes(
2718: p_okl_prtfl_cntrcts_tl_rec, -- IN
2719: l_okl_prtfl_cntrcts_tl_rec); -- OUT
2720: --- If any errors happen abort API
2721: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2722: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2719: l_okl_prtfl_cntrcts_tl_rec); -- OUT

2715: END IF;
2716: --- Setting item attributes
2717: l_return_status := Set_Attributes(
2718: p_okl_prtfl_cntrcts_tl_rec, -- IN
2719: l_okl_prtfl_cntrcts_tl_rec); -- OUT
2720: --- If any errors happen abort API
2721: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2722: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2723: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

Line 2726: l_return_status := populate_new_record(l_okl_prtfl_cntrcts_tl_rec, l_def_okl_prtfl_cntrcts_tl_rec);

2722: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2723: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2724: RAISE OKL_API.G_EXCEPTION_ERROR;
2725: END IF;
2726: l_return_status := populate_new_record(l_okl_prtfl_cntrcts_tl_rec, l_def_okl_prtfl_cntrcts_tl_rec);
2727: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2728: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2729: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2730: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 2732: UPDATE OKL_PRTFL_CNTRCTS_TL

2728: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2729: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2730: RAISE OKL_API.G_EXCEPTION_ERROR;
2731: END IF;
2732: UPDATE OKL_PRTFL_CNTRCTS_TL
2733: SET NAME = l_def_okl_prtfl_cntrcts_tl_rec.name,
2734: DESCRIPTION = l_def_okl_prtfl_cntrcts_tl_rec.description,
2735: SOURCE_LANG = l_def_okl_prtfl_cntrcts_tl_rec.source_lang, --Fix for bug 3637102
2736: CREATED_BY = l_def_okl_prtfl_cntrcts_tl_rec.created_by,

Line 2733: SET NAME = l_def_okl_prtfl_cntrcts_tl_rec.name,

2729: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2730: RAISE OKL_API.G_EXCEPTION_ERROR;
2731: END IF;
2732: UPDATE OKL_PRTFL_CNTRCTS_TL
2733: SET NAME = l_def_okl_prtfl_cntrcts_tl_rec.name,
2734: DESCRIPTION = l_def_okl_prtfl_cntrcts_tl_rec.description,
2735: SOURCE_LANG = l_def_okl_prtfl_cntrcts_tl_rec.source_lang, --Fix for bug 3637102
2736: CREATED_BY = l_def_okl_prtfl_cntrcts_tl_rec.created_by,
2737: CREATION_DATE = l_def_okl_prtfl_cntrcts_tl_rec.creation_date,

Line 2734: DESCRIPTION = l_def_okl_prtfl_cntrcts_tl_rec.description,

2730: RAISE OKL_API.G_EXCEPTION_ERROR;
2731: END IF;
2732: UPDATE OKL_PRTFL_CNTRCTS_TL
2733: SET NAME = l_def_okl_prtfl_cntrcts_tl_rec.name,
2734: DESCRIPTION = l_def_okl_prtfl_cntrcts_tl_rec.description,
2735: SOURCE_LANG = l_def_okl_prtfl_cntrcts_tl_rec.source_lang, --Fix for bug 3637102
2736: CREATED_BY = l_def_okl_prtfl_cntrcts_tl_rec.created_by,
2737: CREATION_DATE = l_def_okl_prtfl_cntrcts_tl_rec.creation_date,
2738: LAST_UPDATED_BY = l_def_okl_prtfl_cntrcts_tl_rec.last_updated_by,

Line 2735: SOURCE_LANG = l_def_okl_prtfl_cntrcts_tl_rec.source_lang, --Fix for bug 3637102

2731: END IF;
2732: UPDATE OKL_PRTFL_CNTRCTS_TL
2733: SET NAME = l_def_okl_prtfl_cntrcts_tl_rec.name,
2734: DESCRIPTION = l_def_okl_prtfl_cntrcts_tl_rec.description,
2735: SOURCE_LANG = l_def_okl_prtfl_cntrcts_tl_rec.source_lang, --Fix for bug 3637102
2736: CREATED_BY = l_def_okl_prtfl_cntrcts_tl_rec.created_by,
2737: CREATION_DATE = l_def_okl_prtfl_cntrcts_tl_rec.creation_date,
2738: LAST_UPDATED_BY = l_def_okl_prtfl_cntrcts_tl_rec.last_updated_by,
2739: LAST_UPDATE_DATE = l_def_okl_prtfl_cntrcts_tl_rec.last_update_date,

Line 2736: CREATED_BY = l_def_okl_prtfl_cntrcts_tl_rec.created_by,

2732: UPDATE OKL_PRTFL_CNTRCTS_TL
2733: SET NAME = l_def_okl_prtfl_cntrcts_tl_rec.name,
2734: DESCRIPTION = l_def_okl_prtfl_cntrcts_tl_rec.description,
2735: SOURCE_LANG = l_def_okl_prtfl_cntrcts_tl_rec.source_lang, --Fix for bug 3637102
2736: CREATED_BY = l_def_okl_prtfl_cntrcts_tl_rec.created_by,
2737: CREATION_DATE = l_def_okl_prtfl_cntrcts_tl_rec.creation_date,
2738: LAST_UPDATED_BY = l_def_okl_prtfl_cntrcts_tl_rec.last_updated_by,
2739: LAST_UPDATE_DATE = l_def_okl_prtfl_cntrcts_tl_rec.last_update_date,
2740: LAST_UPDATE_LOGIN = l_def_okl_prtfl_cntrcts_tl_rec.last_update_login

Line 2737: CREATION_DATE = l_def_okl_prtfl_cntrcts_tl_rec.creation_date,

2733: SET NAME = l_def_okl_prtfl_cntrcts_tl_rec.name,
2734: DESCRIPTION = l_def_okl_prtfl_cntrcts_tl_rec.description,
2735: SOURCE_LANG = l_def_okl_prtfl_cntrcts_tl_rec.source_lang, --Fix for bug 3637102
2736: CREATED_BY = l_def_okl_prtfl_cntrcts_tl_rec.created_by,
2737: CREATION_DATE = l_def_okl_prtfl_cntrcts_tl_rec.creation_date,
2738: LAST_UPDATED_BY = l_def_okl_prtfl_cntrcts_tl_rec.last_updated_by,
2739: LAST_UPDATE_DATE = l_def_okl_prtfl_cntrcts_tl_rec.last_update_date,
2740: LAST_UPDATE_LOGIN = l_def_okl_prtfl_cntrcts_tl_rec.last_update_login
2741: WHERE ID = l_def_okl_prtfl_cntrcts_tl_rec.id

Line 2738: LAST_UPDATED_BY = l_def_okl_prtfl_cntrcts_tl_rec.last_updated_by,

2734: DESCRIPTION = l_def_okl_prtfl_cntrcts_tl_rec.description,
2735: SOURCE_LANG = l_def_okl_prtfl_cntrcts_tl_rec.source_lang, --Fix for bug 3637102
2736: CREATED_BY = l_def_okl_prtfl_cntrcts_tl_rec.created_by,
2737: CREATION_DATE = l_def_okl_prtfl_cntrcts_tl_rec.creation_date,
2738: LAST_UPDATED_BY = l_def_okl_prtfl_cntrcts_tl_rec.last_updated_by,
2739: LAST_UPDATE_DATE = l_def_okl_prtfl_cntrcts_tl_rec.last_update_date,
2740: LAST_UPDATE_LOGIN = l_def_okl_prtfl_cntrcts_tl_rec.last_update_login
2741: WHERE ID = l_def_okl_prtfl_cntrcts_tl_rec.id
2742: AND USERENV('LANG') in (SOURCE_LANG,LANGUAGE); --Fix for 3637102

Line 2739: LAST_UPDATE_DATE = l_def_okl_prtfl_cntrcts_tl_rec.last_update_date,

2735: SOURCE_LANG = l_def_okl_prtfl_cntrcts_tl_rec.source_lang, --Fix for bug 3637102
2736: CREATED_BY = l_def_okl_prtfl_cntrcts_tl_rec.created_by,
2737: CREATION_DATE = l_def_okl_prtfl_cntrcts_tl_rec.creation_date,
2738: LAST_UPDATED_BY = l_def_okl_prtfl_cntrcts_tl_rec.last_updated_by,
2739: LAST_UPDATE_DATE = l_def_okl_prtfl_cntrcts_tl_rec.last_update_date,
2740: LAST_UPDATE_LOGIN = l_def_okl_prtfl_cntrcts_tl_rec.last_update_login
2741: WHERE ID = l_def_okl_prtfl_cntrcts_tl_rec.id
2742: AND USERENV('LANG') in (SOURCE_LANG,LANGUAGE); --Fix for 3637102
2743: --AND SOURCE_LANG = USERENV('LANG');

Line 2740: LAST_UPDATE_LOGIN = l_def_okl_prtfl_cntrcts_tl_rec.last_update_login

2736: CREATED_BY = l_def_okl_prtfl_cntrcts_tl_rec.created_by,
2737: CREATION_DATE = l_def_okl_prtfl_cntrcts_tl_rec.creation_date,
2738: LAST_UPDATED_BY = l_def_okl_prtfl_cntrcts_tl_rec.last_updated_by,
2739: LAST_UPDATE_DATE = l_def_okl_prtfl_cntrcts_tl_rec.last_update_date,
2740: LAST_UPDATE_LOGIN = l_def_okl_prtfl_cntrcts_tl_rec.last_update_login
2741: WHERE ID = l_def_okl_prtfl_cntrcts_tl_rec.id
2742: AND USERENV('LANG') in (SOURCE_LANG,LANGUAGE); --Fix for 3637102
2743: --AND SOURCE_LANG = USERENV('LANG');
2744:

Line 2741: WHERE ID = l_def_okl_prtfl_cntrcts_tl_rec.id

2737: CREATION_DATE = l_def_okl_prtfl_cntrcts_tl_rec.creation_date,
2738: LAST_UPDATED_BY = l_def_okl_prtfl_cntrcts_tl_rec.last_updated_by,
2739: LAST_UPDATE_DATE = l_def_okl_prtfl_cntrcts_tl_rec.last_update_date,
2740: LAST_UPDATE_LOGIN = l_def_okl_prtfl_cntrcts_tl_rec.last_update_login
2741: WHERE ID = l_def_okl_prtfl_cntrcts_tl_rec.id
2742: AND USERENV('LANG') in (SOURCE_LANG,LANGUAGE); --Fix for 3637102
2743: --AND SOURCE_LANG = USERENV('LANG');
2744:
2745: UPDATE OKL_PRTFL_CNTRCTS_TL

Line 2745: UPDATE OKL_PRTFL_CNTRCTS_TL

2741: WHERE ID = l_def_okl_prtfl_cntrcts_tl_rec.id
2742: AND USERENV('LANG') in (SOURCE_LANG,LANGUAGE); --Fix for 3637102
2743: --AND SOURCE_LANG = USERENV('LANG');
2744:
2745: UPDATE OKL_PRTFL_CNTRCTS_TL
2746: SET SFWT_FLAG = 'Y'
2747: WHERE ID = l_def_okl_prtfl_cntrcts_tl_rec.id
2748: AND SOURCE_LANG <> USERENV('LANG');
2749:

Line 2747: WHERE ID = l_def_okl_prtfl_cntrcts_tl_rec.id

2743: --AND SOURCE_LANG = USERENV('LANG');
2744:
2745: UPDATE OKL_PRTFL_CNTRCTS_TL
2746: SET SFWT_FLAG = 'Y'
2747: WHERE ID = l_def_okl_prtfl_cntrcts_tl_rec.id
2748: AND SOURCE_LANG <> USERENV('LANG');
2749:
2750: x_okl_prtfl_cntrcts_tl_rec := l_okl_prtfl_cntrcts_tl_rec;
2751: x_return_status := l_return_status;

Line 2750: x_okl_prtfl_cntrcts_tl_rec := l_okl_prtfl_cntrcts_tl_rec;

2746: SET SFWT_FLAG = 'Y'
2747: WHERE ID = l_def_okl_prtfl_cntrcts_tl_rec.id
2748: AND SOURCE_LANG <> USERENV('LANG');
2749:
2750: x_okl_prtfl_cntrcts_tl_rec := l_okl_prtfl_cntrcts_tl_rec;
2751: x_return_status := l_return_status;
2752: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2753: EXCEPTION
2754: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 2805: l_okl_prtfl_cntrcts_tl_rec okl_prtfl_cntrcts_tl_rec_type;

2801: l_def_pfcv_rec pfcv_rec_type;
2802: l_db_pfcv_rec pfcv_rec_type;
2803: l_pfc_rec pfc_rec_type;
2804: lx_pfc_rec pfc_rec_type;
2805: l_okl_prtfl_cntrcts_tl_rec okl_prtfl_cntrcts_tl_rec_type;
2806: lx_okl_prtfl_cntrcts_tl_rec okl_prtfl_cntrcts_tl_rec_type;
2807: -------------------------------
2808: -- FUNCTION fill_who_columns --
2809: -------------------------------

Line 2806: lx_okl_prtfl_cntrcts_tl_rec okl_prtfl_cntrcts_tl_rec_type;

2802: l_db_pfcv_rec pfcv_rec_type;
2803: l_pfc_rec pfc_rec_type;
2804: lx_pfc_rec pfc_rec_type;
2805: l_okl_prtfl_cntrcts_tl_rec okl_prtfl_cntrcts_tl_rec_type;
2806: lx_okl_prtfl_cntrcts_tl_rec okl_prtfl_cntrcts_tl_rec_type;
2807: -------------------------------
2808: -- FUNCTION fill_who_columns --
2809: -------------------------------
2810: FUNCTION fill_who_columns (

Line 3045: migrate(l_def_pfcv_rec, l_okl_prtfl_cntrcts_tl_rec);

3041: -----------------------------------------
3042: -- Move VIEW record to "Child" records --
3043: -----------------------------------------
3044: migrate(l_def_pfcv_rec, l_pfc_rec);
3045: migrate(l_def_pfcv_rec, l_okl_prtfl_cntrcts_tl_rec);
3046: -----------------------------------------------
3047: -- Call the UPDATE_ROW for each child record --
3048: -----------------------------------------------
3049: update_row(

Line 3068: l_okl_prtfl_cntrcts_tl_rec,

3064: p_init_msg_list,
3065: l_return_status,
3066: x_msg_count,
3067: x_msg_data,
3068: l_okl_prtfl_cntrcts_tl_rec,
3069: lx_okl_prtfl_cntrcts_tl_rec
3070: );
3071: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3072: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3069: lx_okl_prtfl_cntrcts_tl_rec

3065: l_return_status,
3066: x_msg_count,
3067: x_msg_data,
3068: l_okl_prtfl_cntrcts_tl_rec,
3069: lx_okl_prtfl_cntrcts_tl_rec
3070: );
3071: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3072: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3073: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

Line 3076: migrate(lx_okl_prtfl_cntrcts_tl_rec, l_def_pfcv_rec);

3072: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3073: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3074: RAISE OKL_API.G_EXCEPTION_ERROR;
3075: END IF;
3076: migrate(lx_okl_prtfl_cntrcts_tl_rec, l_def_pfcv_rec);
3077: x_pfcv_rec := l_def_pfcv_rec;
3078: x_return_status := l_return_status;
3079: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
3080: EXCEPTION

Line 3341: -- delete_row for:OKL_PRTFL_CNTRCTS_TL --

3337: '_PVT'
3338: );
3339: END delete_row;
3340: -----------------------------------------
3341: -- delete_row for:OKL_PRTFL_CNTRCTS_TL --
3342: -----------------------------------------
3343: PROCEDURE delete_row(
3344: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
3345: x_return_status OUT NOCOPY VARCHAR2,

Line 3348: p_okl_prtfl_cntrcts_tl_rec IN okl_prtfl_cntrcts_tl_rec_type) IS

3344: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
3345: x_return_status OUT NOCOPY VARCHAR2,
3346: x_msg_count OUT NOCOPY NUMBER,
3347: x_msg_data OUT NOCOPY VARCHAR2,
3348: p_okl_prtfl_cntrcts_tl_rec IN okl_prtfl_cntrcts_tl_rec_type) IS
3349:
3350: l_api_version CONSTANT NUMBER := 1;
3351: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3352: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 3353: l_okl_prtfl_cntrcts_tl_rec okl_prtfl_cntrcts_tl_rec_type := p_okl_prtfl_cntrcts_tl_rec;

3349:
3350: l_api_version CONSTANT NUMBER := 1;
3351: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3352: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3353: l_okl_prtfl_cntrcts_tl_rec okl_prtfl_cntrcts_tl_rec_type := p_okl_prtfl_cntrcts_tl_rec;
3354: l_row_notfound BOOLEAN := TRUE;
3355: BEGIN
3356: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
3357: p_init_msg_list,

Line 3366: DELETE FROM OKL_PRTFL_CNTRCTS_TL

3362: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3363: RAISE OKL_API.G_EXCEPTION_ERROR;
3364: END IF;
3365:
3366: DELETE FROM OKL_PRTFL_CNTRCTS_TL
3367: WHERE ID = p_okl_prtfl_cntrcts_tl_rec.id;
3368:
3369: x_return_status := l_return_status;
3370: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 3367: WHERE ID = p_okl_prtfl_cntrcts_tl_rec.id;

3363: RAISE OKL_API.G_EXCEPTION_ERROR;
3364: END IF;
3365:
3366: DELETE FROM OKL_PRTFL_CNTRCTS_TL
3367: WHERE ID = p_okl_prtfl_cntrcts_tl_rec.id;
3368:
3369: x_return_status := l_return_status;
3370: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
3371: EXCEPTION

Line 3418: l_okl_prtfl_cntrcts_tl_rec okl_prtfl_cntrcts_tl_rec_type;

3414: l_api_version CONSTANT NUMBER := 1;
3415: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
3416: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3417: l_pfcv_rec pfcv_rec_type := p_pfcv_rec;
3418: l_okl_prtfl_cntrcts_tl_rec okl_prtfl_cntrcts_tl_rec_type;
3419: l_pfc_rec pfc_rec_type;
3420: BEGIN
3421: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
3422: G_PKG_NAME,

Line 3436: migrate(l_pfcv_rec, l_okl_prtfl_cntrcts_tl_rec);

3432: END IF;
3433: -----------------------------------------
3434: -- Move VIEW record to "Child" records --
3435: -----------------------------------------
3436: migrate(l_pfcv_rec, l_okl_prtfl_cntrcts_tl_rec);
3437: migrate(l_pfcv_rec, l_pfc_rec);
3438: -----------------------------------------------
3439: -- Call the DELETE_ROW for each child record --
3440: -----------------------------------------------

Line 3446: l_okl_prtfl_cntrcts_tl_rec

3442: p_init_msg_list,
3443: l_return_status,
3444: x_msg_count,
3445: x_msg_data,
3446: l_okl_prtfl_cntrcts_tl_rec
3447: );
3448: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3449: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3450: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN