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_PFL_PVT dependencies on OKL_PRTFL_LINES_TL

Line 98: DELETE FROM OKL_PRTFL_LINES_TL T

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

Line 105: UPDATE OKL_PRTFL_LINES_TL T SET(

101: FROM OKL_PRTFL_LINES_B B
102: WHERE B.ID =T.ID
103: );
104:
105: UPDATE OKL_PRTFL_LINES_TL T SET(
106: COMMENTS) = (SELECT
107: B.COMMENTS
108: FROM OKL_PRTFL_LINES_TL B
109: WHERE B.ID = T.ID

Line 108: FROM OKL_PRTFL_LINES_TL B

104:
105: UPDATE OKL_PRTFL_LINES_TL T SET(
106: COMMENTS) = (SELECT
107: B.COMMENTS
108: FROM OKL_PRTFL_LINES_TL B
109: WHERE B.ID = T.ID
110: AND B.LANGUAGE = T.SOURCE_LANG)
111: WHERE ( T.ID,
112: T.LANGUAGE)

Line 116: FROM OKL_PRTFL_LINES_TL SUBB, OKL_PRTFL_LINES_TL SUBT

112: T.LANGUAGE)
113: IN (SELECT
114: SUBT.ID,
115: SUBT.LANGUAGE
116: FROM OKL_PRTFL_LINES_TL SUBB, OKL_PRTFL_LINES_TL SUBT
117: WHERE SUBB.ID = SUBT.ID
118: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
119: AND (SUBB.COMMENTS <> SUBT.COMMENTS
120: OR (SUBB.COMMENTS IS NULL AND SUBT.COMMENTS IS NOT NULL)

Line 123: INSERT INTO OKL_PRTFL_LINES_TL (

119: AND (SUBB.COMMENTS <> SUBT.COMMENTS
120: OR (SUBB.COMMENTS IS NULL AND SUBT.COMMENTS IS NOT NULL)
121: ));
122:
123: INSERT INTO OKL_PRTFL_LINES_TL (
124: ID,
125: LANGUAGE,
126: SOURCE_LANG,
127: SFWT_FLAG,

Line 145: FROM OKL_PRTFL_LINES_TL B, FND_LANGUAGES L

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

Line 150: FROM OKL_PRTFL_LINES_TL T

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

Line 459: -- FUNCTION get_rec for: OKL_PRTFL_LINES_TL

455: BEGIN
456: RETURN(get_rec(p_pfl_rec, l_row_not_found));
457: END get_rec;
458: ---------------------------------------------------------------------------
459: -- FUNCTION get_rec for: OKL_PRTFL_LINES_TL
460: ---------------------------------------------------------------------------
461: FUNCTION get_rec (
462: p_okl_prtfl_lines_tl_rec IN okl_prtfl_lines_tl_rec_type,
463: x_no_data_found OUT NOCOPY BOOLEAN

Line 462: p_okl_prtfl_lines_tl_rec IN okl_prtfl_lines_tl_rec_type,

458: ---------------------------------------------------------------------------
459: -- FUNCTION get_rec for: OKL_PRTFL_LINES_TL
460: ---------------------------------------------------------------------------
461: FUNCTION get_rec (
462: p_okl_prtfl_lines_tl_rec IN okl_prtfl_lines_tl_rec_type,
463: x_no_data_found OUT NOCOPY BOOLEAN
464: ) RETURN okl_prtfl_lines_tl_rec_type IS
465: CURSOR okl_prtfl_lines_tl_pk_csr (p_id IN NUMBER,
466: p_language IN VARCHAR2) IS

Line 464: ) RETURN okl_prtfl_lines_tl_rec_type IS

460: ---------------------------------------------------------------------------
461: FUNCTION get_rec (
462: p_okl_prtfl_lines_tl_rec IN okl_prtfl_lines_tl_rec_type,
463: x_no_data_found OUT NOCOPY BOOLEAN
464: ) RETURN okl_prtfl_lines_tl_rec_type IS
465: CURSOR okl_prtfl_lines_tl_pk_csr (p_id IN NUMBER,
466: p_language IN VARCHAR2) IS
467: SELECT
468: ID,

Line 465: CURSOR okl_prtfl_lines_tl_pk_csr (p_id IN NUMBER,

461: FUNCTION get_rec (
462: p_okl_prtfl_lines_tl_rec IN okl_prtfl_lines_tl_rec_type,
463: x_no_data_found OUT NOCOPY BOOLEAN
464: ) RETURN okl_prtfl_lines_tl_rec_type IS
465: CURSOR okl_prtfl_lines_tl_pk_csr (p_id IN NUMBER,
466: p_language IN VARCHAR2) IS
467: SELECT
468: ID,
469: LANGUAGE,

Line 478: FROM Okl_Prtfl_Lines_Tl

474: CREATION_DATE,
475: LAST_UPDATED_BY,
476: LAST_UPDATE_DATE,
477: LAST_UPDATE_LOGIN
478: FROM Okl_Prtfl_Lines_Tl
479: WHERE okl_prtfl_lines_tl.id = p_id
480: AND okl_prtfl_lines_tl.language = p_language;
481: l_okl_prtfl_lines_tl_pk okl_prtfl_lines_tl_pk_csr%ROWTYPE;
482: l_okl_prtfl_lines_tl_rec okl_prtfl_lines_tl_rec_type;

Line 479: WHERE okl_prtfl_lines_tl.id = p_id

475: LAST_UPDATED_BY,
476: LAST_UPDATE_DATE,
477: LAST_UPDATE_LOGIN
478: FROM Okl_Prtfl_Lines_Tl
479: WHERE okl_prtfl_lines_tl.id = p_id
480: AND okl_prtfl_lines_tl.language = p_language;
481: l_okl_prtfl_lines_tl_pk okl_prtfl_lines_tl_pk_csr%ROWTYPE;
482: l_okl_prtfl_lines_tl_rec okl_prtfl_lines_tl_rec_type;
483: BEGIN

Line 480: AND okl_prtfl_lines_tl.language = p_language;

476: LAST_UPDATE_DATE,
477: LAST_UPDATE_LOGIN
478: FROM Okl_Prtfl_Lines_Tl
479: WHERE okl_prtfl_lines_tl.id = p_id
480: AND okl_prtfl_lines_tl.language = p_language;
481: l_okl_prtfl_lines_tl_pk okl_prtfl_lines_tl_pk_csr%ROWTYPE;
482: l_okl_prtfl_lines_tl_rec okl_prtfl_lines_tl_rec_type;
483: BEGIN
484: x_no_data_found := TRUE;

Line 481: l_okl_prtfl_lines_tl_pk okl_prtfl_lines_tl_pk_csr%ROWTYPE;

477: LAST_UPDATE_LOGIN
478: FROM Okl_Prtfl_Lines_Tl
479: WHERE okl_prtfl_lines_tl.id = p_id
480: AND okl_prtfl_lines_tl.language = p_language;
481: l_okl_prtfl_lines_tl_pk okl_prtfl_lines_tl_pk_csr%ROWTYPE;
482: l_okl_prtfl_lines_tl_rec okl_prtfl_lines_tl_rec_type;
483: BEGIN
484: x_no_data_found := TRUE;
485: -- Get current database values

Line 482: l_okl_prtfl_lines_tl_rec okl_prtfl_lines_tl_rec_type;

478: FROM Okl_Prtfl_Lines_Tl
479: WHERE okl_prtfl_lines_tl.id = p_id
480: AND okl_prtfl_lines_tl.language = p_language;
481: l_okl_prtfl_lines_tl_pk okl_prtfl_lines_tl_pk_csr%ROWTYPE;
482: l_okl_prtfl_lines_tl_rec okl_prtfl_lines_tl_rec_type;
483: BEGIN
484: x_no_data_found := TRUE;
485: -- Get current database values
486: OPEN okl_prtfl_lines_tl_pk_csr (p_okl_prtfl_lines_tl_rec.id,

Line 486: OPEN okl_prtfl_lines_tl_pk_csr (p_okl_prtfl_lines_tl_rec.id,

482: l_okl_prtfl_lines_tl_rec okl_prtfl_lines_tl_rec_type;
483: BEGIN
484: x_no_data_found := TRUE;
485: -- Get current database values
486: OPEN okl_prtfl_lines_tl_pk_csr (p_okl_prtfl_lines_tl_rec.id,
487: p_okl_prtfl_lines_tl_rec.language);
488: FETCH okl_prtfl_lines_tl_pk_csr INTO
489: l_okl_prtfl_lines_tl_rec.id,
490: l_okl_prtfl_lines_tl_rec.language,

Line 487: p_okl_prtfl_lines_tl_rec.language);

483: BEGIN
484: x_no_data_found := TRUE;
485: -- Get current database values
486: OPEN okl_prtfl_lines_tl_pk_csr (p_okl_prtfl_lines_tl_rec.id,
487: p_okl_prtfl_lines_tl_rec.language);
488: FETCH okl_prtfl_lines_tl_pk_csr INTO
489: l_okl_prtfl_lines_tl_rec.id,
490: l_okl_prtfl_lines_tl_rec.language,
491: l_okl_prtfl_lines_tl_rec.source_lang,

Line 488: FETCH okl_prtfl_lines_tl_pk_csr INTO

484: x_no_data_found := TRUE;
485: -- Get current database values
486: OPEN okl_prtfl_lines_tl_pk_csr (p_okl_prtfl_lines_tl_rec.id,
487: p_okl_prtfl_lines_tl_rec.language);
488: FETCH okl_prtfl_lines_tl_pk_csr INTO
489: l_okl_prtfl_lines_tl_rec.id,
490: l_okl_prtfl_lines_tl_rec.language,
491: l_okl_prtfl_lines_tl_rec.source_lang,
492: l_okl_prtfl_lines_tl_rec.sfwt_flag,

Line 489: l_okl_prtfl_lines_tl_rec.id,

485: -- Get current database values
486: OPEN okl_prtfl_lines_tl_pk_csr (p_okl_prtfl_lines_tl_rec.id,
487: p_okl_prtfl_lines_tl_rec.language);
488: FETCH okl_prtfl_lines_tl_pk_csr INTO
489: l_okl_prtfl_lines_tl_rec.id,
490: l_okl_prtfl_lines_tl_rec.language,
491: l_okl_prtfl_lines_tl_rec.source_lang,
492: l_okl_prtfl_lines_tl_rec.sfwt_flag,
493: l_okl_prtfl_lines_tl_rec.comments,

Line 490: l_okl_prtfl_lines_tl_rec.language,

486: OPEN okl_prtfl_lines_tl_pk_csr (p_okl_prtfl_lines_tl_rec.id,
487: p_okl_prtfl_lines_tl_rec.language);
488: FETCH okl_prtfl_lines_tl_pk_csr INTO
489: l_okl_prtfl_lines_tl_rec.id,
490: l_okl_prtfl_lines_tl_rec.language,
491: l_okl_prtfl_lines_tl_rec.source_lang,
492: l_okl_prtfl_lines_tl_rec.sfwt_flag,
493: l_okl_prtfl_lines_tl_rec.comments,
494: l_okl_prtfl_lines_tl_rec.created_by,

Line 491: l_okl_prtfl_lines_tl_rec.source_lang,

487: p_okl_prtfl_lines_tl_rec.language);
488: FETCH okl_prtfl_lines_tl_pk_csr INTO
489: l_okl_prtfl_lines_tl_rec.id,
490: l_okl_prtfl_lines_tl_rec.language,
491: l_okl_prtfl_lines_tl_rec.source_lang,
492: l_okl_prtfl_lines_tl_rec.sfwt_flag,
493: l_okl_prtfl_lines_tl_rec.comments,
494: l_okl_prtfl_lines_tl_rec.created_by,
495: l_okl_prtfl_lines_tl_rec.creation_date,

Line 492: l_okl_prtfl_lines_tl_rec.sfwt_flag,

488: FETCH okl_prtfl_lines_tl_pk_csr INTO
489: l_okl_prtfl_lines_tl_rec.id,
490: l_okl_prtfl_lines_tl_rec.language,
491: l_okl_prtfl_lines_tl_rec.source_lang,
492: l_okl_prtfl_lines_tl_rec.sfwt_flag,
493: l_okl_prtfl_lines_tl_rec.comments,
494: l_okl_prtfl_lines_tl_rec.created_by,
495: l_okl_prtfl_lines_tl_rec.creation_date,
496: l_okl_prtfl_lines_tl_rec.last_updated_by,

Line 493: l_okl_prtfl_lines_tl_rec.comments,

489: l_okl_prtfl_lines_tl_rec.id,
490: l_okl_prtfl_lines_tl_rec.language,
491: l_okl_prtfl_lines_tl_rec.source_lang,
492: l_okl_prtfl_lines_tl_rec.sfwt_flag,
493: l_okl_prtfl_lines_tl_rec.comments,
494: l_okl_prtfl_lines_tl_rec.created_by,
495: l_okl_prtfl_lines_tl_rec.creation_date,
496: l_okl_prtfl_lines_tl_rec.last_updated_by,
497: l_okl_prtfl_lines_tl_rec.last_update_date,

Line 494: l_okl_prtfl_lines_tl_rec.created_by,

490: l_okl_prtfl_lines_tl_rec.language,
491: l_okl_prtfl_lines_tl_rec.source_lang,
492: l_okl_prtfl_lines_tl_rec.sfwt_flag,
493: l_okl_prtfl_lines_tl_rec.comments,
494: l_okl_prtfl_lines_tl_rec.created_by,
495: l_okl_prtfl_lines_tl_rec.creation_date,
496: l_okl_prtfl_lines_tl_rec.last_updated_by,
497: l_okl_prtfl_lines_tl_rec.last_update_date,
498: l_okl_prtfl_lines_tl_rec.last_update_login;

Line 495: l_okl_prtfl_lines_tl_rec.creation_date,

491: l_okl_prtfl_lines_tl_rec.source_lang,
492: l_okl_prtfl_lines_tl_rec.sfwt_flag,
493: l_okl_prtfl_lines_tl_rec.comments,
494: l_okl_prtfl_lines_tl_rec.created_by,
495: l_okl_prtfl_lines_tl_rec.creation_date,
496: l_okl_prtfl_lines_tl_rec.last_updated_by,
497: l_okl_prtfl_lines_tl_rec.last_update_date,
498: l_okl_prtfl_lines_tl_rec.last_update_login;
499: x_no_data_found := okl_prtfl_lines_tl_pk_csr%NOTFOUND;

Line 496: l_okl_prtfl_lines_tl_rec.last_updated_by,

492: l_okl_prtfl_lines_tl_rec.sfwt_flag,
493: l_okl_prtfl_lines_tl_rec.comments,
494: l_okl_prtfl_lines_tl_rec.created_by,
495: l_okl_prtfl_lines_tl_rec.creation_date,
496: l_okl_prtfl_lines_tl_rec.last_updated_by,
497: l_okl_prtfl_lines_tl_rec.last_update_date,
498: l_okl_prtfl_lines_tl_rec.last_update_login;
499: x_no_data_found := okl_prtfl_lines_tl_pk_csr%NOTFOUND;
500: CLOSE okl_prtfl_lines_tl_pk_csr;

Line 497: l_okl_prtfl_lines_tl_rec.last_update_date,

493: l_okl_prtfl_lines_tl_rec.comments,
494: l_okl_prtfl_lines_tl_rec.created_by,
495: l_okl_prtfl_lines_tl_rec.creation_date,
496: l_okl_prtfl_lines_tl_rec.last_updated_by,
497: l_okl_prtfl_lines_tl_rec.last_update_date,
498: l_okl_prtfl_lines_tl_rec.last_update_login;
499: x_no_data_found := okl_prtfl_lines_tl_pk_csr%NOTFOUND;
500: CLOSE okl_prtfl_lines_tl_pk_csr;
501: RETURN(l_okl_prtfl_lines_tl_rec);

Line 498: l_okl_prtfl_lines_tl_rec.last_update_login;

494: l_okl_prtfl_lines_tl_rec.created_by,
495: l_okl_prtfl_lines_tl_rec.creation_date,
496: l_okl_prtfl_lines_tl_rec.last_updated_by,
497: l_okl_prtfl_lines_tl_rec.last_update_date,
498: l_okl_prtfl_lines_tl_rec.last_update_login;
499: x_no_data_found := okl_prtfl_lines_tl_pk_csr%NOTFOUND;
500: CLOSE okl_prtfl_lines_tl_pk_csr;
501: RETURN(l_okl_prtfl_lines_tl_rec);
502: END get_rec;

Line 499: x_no_data_found := okl_prtfl_lines_tl_pk_csr%NOTFOUND;

495: l_okl_prtfl_lines_tl_rec.creation_date,
496: l_okl_prtfl_lines_tl_rec.last_updated_by,
497: l_okl_prtfl_lines_tl_rec.last_update_date,
498: l_okl_prtfl_lines_tl_rec.last_update_login;
499: x_no_data_found := okl_prtfl_lines_tl_pk_csr%NOTFOUND;
500: CLOSE okl_prtfl_lines_tl_pk_csr;
501: RETURN(l_okl_prtfl_lines_tl_rec);
502: END get_rec;
503:

Line 500: CLOSE okl_prtfl_lines_tl_pk_csr;

496: l_okl_prtfl_lines_tl_rec.last_updated_by,
497: l_okl_prtfl_lines_tl_rec.last_update_date,
498: l_okl_prtfl_lines_tl_rec.last_update_login;
499: x_no_data_found := okl_prtfl_lines_tl_pk_csr%NOTFOUND;
500: CLOSE okl_prtfl_lines_tl_pk_csr;
501: RETURN(l_okl_prtfl_lines_tl_rec);
502: END get_rec;
503:
504: ------------------------------------------------------------------

Line 501: RETURN(l_okl_prtfl_lines_tl_rec);

497: l_okl_prtfl_lines_tl_rec.last_update_date,
498: l_okl_prtfl_lines_tl_rec.last_update_login;
499: x_no_data_found := okl_prtfl_lines_tl_pk_csr%NOTFOUND;
500: CLOSE okl_prtfl_lines_tl_pk_csr;
501: RETURN(l_okl_prtfl_lines_tl_rec);
502: END get_rec;
503:
504: ------------------------------------------------------------------
505: -- This version of get_rec sets error messages if no data found --

Line 508: p_okl_prtfl_lines_tl_rec IN okl_prtfl_lines_tl_rec_type,

504: ------------------------------------------------------------------
505: -- This version of get_rec sets error messages if no data found --
506: ------------------------------------------------------------------
507: FUNCTION get_rec (
508: p_okl_prtfl_lines_tl_rec IN okl_prtfl_lines_tl_rec_type,
509: x_return_status OUT NOCOPY VARCHAR2
510: ) RETURN okl_prtfl_lines_tl_rec_type IS
511: l_okl_prtfl_lines_tl_rec okl_prtfl_lines_tl_rec_type;
512: l_row_notfound BOOLEAN := TRUE;

Line 510: ) RETURN okl_prtfl_lines_tl_rec_type IS

506: ------------------------------------------------------------------
507: FUNCTION get_rec (
508: p_okl_prtfl_lines_tl_rec IN okl_prtfl_lines_tl_rec_type,
509: x_return_status OUT NOCOPY VARCHAR2
510: ) RETURN okl_prtfl_lines_tl_rec_type IS
511: l_okl_prtfl_lines_tl_rec okl_prtfl_lines_tl_rec_type;
512: l_row_notfound BOOLEAN := TRUE;
513: BEGIN
514: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 511: l_okl_prtfl_lines_tl_rec okl_prtfl_lines_tl_rec_type;

507: FUNCTION get_rec (
508: p_okl_prtfl_lines_tl_rec IN okl_prtfl_lines_tl_rec_type,
509: x_return_status OUT NOCOPY VARCHAR2
510: ) RETURN okl_prtfl_lines_tl_rec_type IS
511: l_okl_prtfl_lines_tl_rec okl_prtfl_lines_tl_rec_type;
512: l_row_notfound BOOLEAN := TRUE;
513: BEGIN
514: x_return_status := OKL_API.G_RET_STS_SUCCESS;
515: l_okl_prtfl_lines_tl_rec := get_rec(p_okl_prtfl_lines_tl_rec, l_row_notfound);

Line 515: l_okl_prtfl_lines_tl_rec := get_rec(p_okl_prtfl_lines_tl_rec, l_row_notfound);

511: l_okl_prtfl_lines_tl_rec okl_prtfl_lines_tl_rec_type;
512: l_row_notfound BOOLEAN := TRUE;
513: BEGIN
514: x_return_status := OKL_API.G_RET_STS_SUCCESS;
515: l_okl_prtfl_lines_tl_rec := get_rec(p_okl_prtfl_lines_tl_rec, l_row_notfound);
516: IF (l_row_notfound) THEN
517: OKL_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
518: OKL_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'LANGUAGE');
519: x_return_status := OKL_API.G_RET_STS_ERROR;

Line 521: RETURN(l_okl_prtfl_lines_tl_rec);

517: OKL_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
518: OKL_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'LANGUAGE');
519: x_return_status := OKL_API.G_RET_STS_ERROR;
520: END IF;
521: RETURN(l_okl_prtfl_lines_tl_rec);
522: END get_rec;
523: -----------------------------------------------------------
524: -- So we don't have to pass an "l_row_notfound" variable --
525: -----------------------------------------------------------

Line 527: p_okl_prtfl_lines_tl_rec IN okl_prtfl_lines_tl_rec_type

523: -----------------------------------------------------------
524: -- So we don't have to pass an "l_row_notfound" variable --
525: -----------------------------------------------------------
526: FUNCTION get_rec (
527: p_okl_prtfl_lines_tl_rec IN okl_prtfl_lines_tl_rec_type
528: ) RETURN okl_prtfl_lines_tl_rec_type IS
529: l_row_not_found BOOLEAN := TRUE;
530: BEGIN
531: RETURN(get_rec(p_okl_prtfl_lines_tl_rec, l_row_not_found));

Line 528: ) RETURN okl_prtfl_lines_tl_rec_type IS

524: -- So we don't have to pass an "l_row_notfound" variable --
525: -----------------------------------------------------------
526: FUNCTION get_rec (
527: p_okl_prtfl_lines_tl_rec IN okl_prtfl_lines_tl_rec_type
528: ) RETURN okl_prtfl_lines_tl_rec_type IS
529: l_row_not_found BOOLEAN := TRUE;
530: BEGIN
531: RETURN(get_rec(p_okl_prtfl_lines_tl_rec, l_row_not_found));
532: END get_rec;

Line 531: RETURN(get_rec(p_okl_prtfl_lines_tl_rec, l_row_not_found));

527: p_okl_prtfl_lines_tl_rec IN okl_prtfl_lines_tl_rec_type
528: ) RETURN okl_prtfl_lines_tl_rec_type IS
529: l_row_not_found BOOLEAN := TRUE;
530: BEGIN
531: RETURN(get_rec(p_okl_prtfl_lines_tl_rec, l_row_not_found));
532: END get_rec;
533: ---------------------------------------------------------------------------
534: -- FUNCTION null_out_defaults for: OKL_PRTFL_LINES_V
535: ---------------------------------------------------------------------------

Line 1714: p_to IN OUT NOCOPY okl_prtfl_lines_tl_rec_type

1710: -- RABHUPAT - 2667636 - End
1711: END migrate;
1712: PROCEDURE migrate (
1713: p_from IN pflv_rec_type,
1714: p_to IN OUT NOCOPY okl_prtfl_lines_tl_rec_type
1715: ) IS
1716: BEGIN
1717: p_to.id := p_from.id;
1718: p_to.sfwt_flag := p_from.sfwt_flag;

Line 1727: p_from IN okl_prtfl_lines_tl_rec_type,

1723: p_to.last_update_date := p_from.last_update_date;
1724: p_to.last_update_login := p_from.last_update_login;
1725: END migrate;
1726: PROCEDURE migrate (
1727: p_from IN okl_prtfl_lines_tl_rec_type,
1728: p_to IN OUT NOCOPY pflv_rec_type
1729: ) IS
1730: BEGIN
1731: p_to.id := p_from.id;

Line 1759: l_okl_prtfl_lines_tl_rec okl_prtfl_lines_tl_rec_type;

1755: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
1756: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1757: l_pflv_rec pflv_rec_type := p_pflv_rec;
1758: l_pfl_rec pfl_rec_type;
1759: l_okl_prtfl_lines_tl_rec okl_prtfl_lines_tl_rec_type;
1760: BEGIN
1761: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1762: G_PKG_NAME,
1763: p_init_msg_list,

Line 2166: -- insert_row for:OKL_PRTFL_LINES_TL --

2162: '_PVT'
2163: );
2164: END insert_row;
2165: ---------------------------------------
2166: -- insert_row for:OKL_PRTFL_LINES_TL --
2167: ---------------------------------------
2168: PROCEDURE insert_row(
2169: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2170: x_return_status OUT NOCOPY VARCHAR2,

Line 2173: p_okl_prtfl_lines_tl_rec IN okl_prtfl_lines_tl_rec_type,

2169: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2170: x_return_status OUT NOCOPY VARCHAR2,
2171: x_msg_count OUT NOCOPY NUMBER,
2172: x_msg_data OUT NOCOPY VARCHAR2,
2173: p_okl_prtfl_lines_tl_rec IN okl_prtfl_lines_tl_rec_type,
2174: x_okl_prtfl_lines_tl_rec OUT NOCOPY okl_prtfl_lines_tl_rec_type) IS
2175:
2176: l_api_version CONSTANT NUMBER := 1;
2177: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';

Line 2174: x_okl_prtfl_lines_tl_rec OUT NOCOPY okl_prtfl_lines_tl_rec_type) IS

2170: x_return_status OUT NOCOPY VARCHAR2,
2171: x_msg_count OUT NOCOPY NUMBER,
2172: x_msg_data OUT NOCOPY VARCHAR2,
2173: p_okl_prtfl_lines_tl_rec IN okl_prtfl_lines_tl_rec_type,
2174: x_okl_prtfl_lines_tl_rec OUT NOCOPY okl_prtfl_lines_tl_rec_type) IS
2175:
2176: l_api_version CONSTANT NUMBER := 1;
2177: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
2178: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 2179: l_okl_prtfl_lines_tl_rec okl_prtfl_lines_tl_rec_type := p_okl_prtfl_lines_tl_rec;

2175:
2176: l_api_version CONSTANT NUMBER := 1;
2177: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
2178: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2179: l_okl_prtfl_lines_tl_rec okl_prtfl_lines_tl_rec_type := p_okl_prtfl_lines_tl_rec;
2180: l_def_okl_prtfl_lines_tl_rec okl_prtfl_lines_tl_rec_type;
2181: CURSOR get_languages IS
2182: SELECT *
2183: FROM FND_LANGUAGES

Line 2180: l_def_okl_prtfl_lines_tl_rec okl_prtfl_lines_tl_rec_type;

2176: l_api_version CONSTANT NUMBER := 1;
2177: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
2178: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2179: l_okl_prtfl_lines_tl_rec okl_prtfl_lines_tl_rec_type := p_okl_prtfl_lines_tl_rec;
2180: l_def_okl_prtfl_lines_tl_rec okl_prtfl_lines_tl_rec_type;
2181: CURSOR get_languages IS
2182: SELECT *
2183: FROM FND_LANGUAGES
2184: WHERE INSTALLED_FLAG IN ('I', 'B');

Line 2186: -- Set_Attributes for:OKL_PRTFL_LINES_TL --

2182: SELECT *
2183: FROM FND_LANGUAGES
2184: WHERE INSTALLED_FLAG IN ('I', 'B');
2185: -------------------------------------------
2186: -- Set_Attributes for:OKL_PRTFL_LINES_TL --
2187: -------------------------------------------
2188: FUNCTION Set_Attributes (
2189: p_okl_prtfl_lines_tl_rec IN okl_prtfl_lines_tl_rec_type,
2190: x_okl_prtfl_lines_tl_rec OUT NOCOPY okl_prtfl_lines_tl_rec_type

Line 2189: p_okl_prtfl_lines_tl_rec IN okl_prtfl_lines_tl_rec_type,

2185: -------------------------------------------
2186: -- Set_Attributes for:OKL_PRTFL_LINES_TL --
2187: -------------------------------------------
2188: FUNCTION Set_Attributes (
2189: p_okl_prtfl_lines_tl_rec IN okl_prtfl_lines_tl_rec_type,
2190: x_okl_prtfl_lines_tl_rec OUT NOCOPY okl_prtfl_lines_tl_rec_type
2191: ) RETURN VARCHAR2 IS
2192: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2193: BEGIN

Line 2190: x_okl_prtfl_lines_tl_rec OUT NOCOPY okl_prtfl_lines_tl_rec_type

2186: -- Set_Attributes for:OKL_PRTFL_LINES_TL --
2187: -------------------------------------------
2188: FUNCTION Set_Attributes (
2189: p_okl_prtfl_lines_tl_rec IN okl_prtfl_lines_tl_rec_type,
2190: x_okl_prtfl_lines_tl_rec OUT NOCOPY okl_prtfl_lines_tl_rec_type
2191: ) RETURN VARCHAR2 IS
2192: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2193: BEGIN
2194: x_okl_prtfl_lines_tl_rec := p_okl_prtfl_lines_tl_rec;

Line 2194: x_okl_prtfl_lines_tl_rec := p_okl_prtfl_lines_tl_rec;

2190: x_okl_prtfl_lines_tl_rec OUT NOCOPY okl_prtfl_lines_tl_rec_type
2191: ) RETURN VARCHAR2 IS
2192: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2193: BEGIN
2194: x_okl_prtfl_lines_tl_rec := p_okl_prtfl_lines_tl_rec;
2195: x_okl_prtfl_lines_tl_rec.LANGUAGE := USERENV('LANG');
2196: x_okl_prtfl_lines_tl_rec.SOURCE_LANG := USERENV('LANG');
2197: RETURN(l_return_status);
2198: END Set_Attributes;

Line 2195: x_okl_prtfl_lines_tl_rec.LANGUAGE := USERENV('LANG');

2191: ) RETURN VARCHAR2 IS
2192: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2193: BEGIN
2194: x_okl_prtfl_lines_tl_rec := p_okl_prtfl_lines_tl_rec;
2195: x_okl_prtfl_lines_tl_rec.LANGUAGE := USERENV('LANG');
2196: x_okl_prtfl_lines_tl_rec.SOURCE_LANG := USERENV('LANG');
2197: RETURN(l_return_status);
2198: END Set_Attributes;
2199: BEGIN

Line 2196: x_okl_prtfl_lines_tl_rec.SOURCE_LANG := USERENV('LANG');

2192: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2193: BEGIN
2194: x_okl_prtfl_lines_tl_rec := p_okl_prtfl_lines_tl_rec;
2195: x_okl_prtfl_lines_tl_rec.LANGUAGE := USERENV('LANG');
2196: x_okl_prtfl_lines_tl_rec.SOURCE_LANG := USERENV('LANG');
2197: RETURN(l_return_status);
2198: END Set_Attributes;
2199: BEGIN
2200: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

Line 2211: p_okl_prtfl_lines_tl_rec, -- IN

2207: RAISE OKL_API.G_EXCEPTION_ERROR;
2208: END IF;
2209: --- Setting item attributes
2210: l_return_status := Set_Attributes(
2211: p_okl_prtfl_lines_tl_rec, -- IN
2212: l_okl_prtfl_lines_tl_rec); -- OUT
2213: --- If any errors happen abort API
2214: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2215: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2212: l_okl_prtfl_lines_tl_rec); -- OUT

2208: END IF;
2209: --- Setting item attributes
2210: l_return_status := Set_Attributes(
2211: p_okl_prtfl_lines_tl_rec, -- IN
2212: l_okl_prtfl_lines_tl_rec); -- OUT
2213: --- If any errors happen abort API
2214: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2215: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2216: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

Line 2220: l_okl_prtfl_lines_tl_rec.language := l_lang_rec.language_code;

2216: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2217: RAISE OKL_API.G_EXCEPTION_ERROR;
2218: END IF;
2219: FOR l_lang_rec IN get_languages LOOP
2220: l_okl_prtfl_lines_tl_rec.language := l_lang_rec.language_code;
2221: INSERT INTO OKL_PRTFL_LINES_TL(
2222: id,
2223: language,
2224: source_lang,

Line 2221: INSERT INTO OKL_PRTFL_LINES_TL(

2217: RAISE OKL_API.G_EXCEPTION_ERROR;
2218: END IF;
2219: FOR l_lang_rec IN get_languages LOOP
2220: l_okl_prtfl_lines_tl_rec.language := l_lang_rec.language_code;
2221: INSERT INTO OKL_PRTFL_LINES_TL(
2222: id,
2223: language,
2224: source_lang,
2225: sfwt_flag,

Line 2233: l_okl_prtfl_lines_tl_rec.id,

2229: last_updated_by,
2230: last_update_date,
2231: last_update_login)
2232: VALUES (
2233: l_okl_prtfl_lines_tl_rec.id,
2234: l_okl_prtfl_lines_tl_rec.language,
2235: l_okl_prtfl_lines_tl_rec.source_lang,
2236: l_okl_prtfl_lines_tl_rec.sfwt_flag,
2237: l_okl_prtfl_lines_tl_rec.comments,

Line 2234: l_okl_prtfl_lines_tl_rec.language,

2230: last_update_date,
2231: last_update_login)
2232: VALUES (
2233: l_okl_prtfl_lines_tl_rec.id,
2234: l_okl_prtfl_lines_tl_rec.language,
2235: l_okl_prtfl_lines_tl_rec.source_lang,
2236: l_okl_prtfl_lines_tl_rec.sfwt_flag,
2237: l_okl_prtfl_lines_tl_rec.comments,
2238: l_okl_prtfl_lines_tl_rec.created_by,

Line 2235: l_okl_prtfl_lines_tl_rec.source_lang,

2231: last_update_login)
2232: VALUES (
2233: l_okl_prtfl_lines_tl_rec.id,
2234: l_okl_prtfl_lines_tl_rec.language,
2235: l_okl_prtfl_lines_tl_rec.source_lang,
2236: l_okl_prtfl_lines_tl_rec.sfwt_flag,
2237: l_okl_prtfl_lines_tl_rec.comments,
2238: l_okl_prtfl_lines_tl_rec.created_by,
2239: l_okl_prtfl_lines_tl_rec.creation_date,

Line 2236: l_okl_prtfl_lines_tl_rec.sfwt_flag,

2232: VALUES (
2233: l_okl_prtfl_lines_tl_rec.id,
2234: l_okl_prtfl_lines_tl_rec.language,
2235: l_okl_prtfl_lines_tl_rec.source_lang,
2236: l_okl_prtfl_lines_tl_rec.sfwt_flag,
2237: l_okl_prtfl_lines_tl_rec.comments,
2238: l_okl_prtfl_lines_tl_rec.created_by,
2239: l_okl_prtfl_lines_tl_rec.creation_date,
2240: l_okl_prtfl_lines_tl_rec.last_updated_by,

Line 2237: l_okl_prtfl_lines_tl_rec.comments,

2233: l_okl_prtfl_lines_tl_rec.id,
2234: l_okl_prtfl_lines_tl_rec.language,
2235: l_okl_prtfl_lines_tl_rec.source_lang,
2236: l_okl_prtfl_lines_tl_rec.sfwt_flag,
2237: l_okl_prtfl_lines_tl_rec.comments,
2238: l_okl_prtfl_lines_tl_rec.created_by,
2239: l_okl_prtfl_lines_tl_rec.creation_date,
2240: l_okl_prtfl_lines_tl_rec.last_updated_by,
2241: l_okl_prtfl_lines_tl_rec.last_update_date,

Line 2238: l_okl_prtfl_lines_tl_rec.created_by,

2234: l_okl_prtfl_lines_tl_rec.language,
2235: l_okl_prtfl_lines_tl_rec.source_lang,
2236: l_okl_prtfl_lines_tl_rec.sfwt_flag,
2237: l_okl_prtfl_lines_tl_rec.comments,
2238: l_okl_prtfl_lines_tl_rec.created_by,
2239: l_okl_prtfl_lines_tl_rec.creation_date,
2240: l_okl_prtfl_lines_tl_rec.last_updated_by,
2241: l_okl_prtfl_lines_tl_rec.last_update_date,
2242: l_okl_prtfl_lines_tl_rec.last_update_login);

Line 2239: l_okl_prtfl_lines_tl_rec.creation_date,

2235: l_okl_prtfl_lines_tl_rec.source_lang,
2236: l_okl_prtfl_lines_tl_rec.sfwt_flag,
2237: l_okl_prtfl_lines_tl_rec.comments,
2238: l_okl_prtfl_lines_tl_rec.created_by,
2239: l_okl_prtfl_lines_tl_rec.creation_date,
2240: l_okl_prtfl_lines_tl_rec.last_updated_by,
2241: l_okl_prtfl_lines_tl_rec.last_update_date,
2242: l_okl_prtfl_lines_tl_rec.last_update_login);
2243: END LOOP;

Line 2240: l_okl_prtfl_lines_tl_rec.last_updated_by,

2236: l_okl_prtfl_lines_tl_rec.sfwt_flag,
2237: l_okl_prtfl_lines_tl_rec.comments,
2238: l_okl_prtfl_lines_tl_rec.created_by,
2239: l_okl_prtfl_lines_tl_rec.creation_date,
2240: l_okl_prtfl_lines_tl_rec.last_updated_by,
2241: l_okl_prtfl_lines_tl_rec.last_update_date,
2242: l_okl_prtfl_lines_tl_rec.last_update_login);
2243: END LOOP;
2244: -- Set OUT values

Line 2241: l_okl_prtfl_lines_tl_rec.last_update_date,

2237: l_okl_prtfl_lines_tl_rec.comments,
2238: l_okl_prtfl_lines_tl_rec.created_by,
2239: l_okl_prtfl_lines_tl_rec.creation_date,
2240: l_okl_prtfl_lines_tl_rec.last_updated_by,
2241: l_okl_prtfl_lines_tl_rec.last_update_date,
2242: l_okl_prtfl_lines_tl_rec.last_update_login);
2243: END LOOP;
2244: -- Set OUT values
2245: x_okl_prtfl_lines_tl_rec := l_okl_prtfl_lines_tl_rec;

Line 2242: l_okl_prtfl_lines_tl_rec.last_update_login);

2238: l_okl_prtfl_lines_tl_rec.created_by,
2239: l_okl_prtfl_lines_tl_rec.creation_date,
2240: l_okl_prtfl_lines_tl_rec.last_updated_by,
2241: l_okl_prtfl_lines_tl_rec.last_update_date,
2242: l_okl_prtfl_lines_tl_rec.last_update_login);
2243: END LOOP;
2244: -- Set OUT values
2245: x_okl_prtfl_lines_tl_rec := l_okl_prtfl_lines_tl_rec;
2246: x_return_status := l_return_status;

Line 2245: x_okl_prtfl_lines_tl_rec := l_okl_prtfl_lines_tl_rec;

2241: l_okl_prtfl_lines_tl_rec.last_update_date,
2242: l_okl_prtfl_lines_tl_rec.last_update_login);
2243: END LOOP;
2244: -- Set OUT values
2245: x_okl_prtfl_lines_tl_rec := l_okl_prtfl_lines_tl_rec;
2246: x_return_status := l_return_status;
2247: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2248: EXCEPTION
2249: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 2309: l_okl_prtfl_lines_tl_rec okl_prtfl_lines_tl_rec_type;

2305: l_pflv_rec pflv_rec_type := p_pflv_rec;
2306: l_def_pflv_rec pflv_rec_type;
2307: l_pfl_rec pfl_rec_type;
2308: lx_pfl_rec pfl_rec_type;
2309: l_okl_prtfl_lines_tl_rec okl_prtfl_lines_tl_rec_type;
2310: lx_okl_prtfl_lines_tl_rec okl_prtfl_lines_tl_rec_type;
2311: -------------------------------
2312: -- FUNCTION fill_who_columns --
2313: -------------------------------

Line 2310: lx_okl_prtfl_lines_tl_rec okl_prtfl_lines_tl_rec_type;

2306: l_def_pflv_rec pflv_rec_type;
2307: l_pfl_rec pfl_rec_type;
2308: lx_pfl_rec pfl_rec_type;
2309: l_okl_prtfl_lines_tl_rec okl_prtfl_lines_tl_rec_type;
2310: lx_okl_prtfl_lines_tl_rec okl_prtfl_lines_tl_rec_type;
2311: -------------------------------
2312: -- FUNCTION fill_who_columns --
2313: -------------------------------
2314: FUNCTION fill_who_columns (

Line 2393: migrate(l_def_pflv_rec, l_okl_prtfl_lines_tl_rec);

2389: -----------------------------------------
2390: -- Move VIEW record to "Child" records --
2391: -----------------------------------------
2392: migrate(l_def_pflv_rec, l_pfl_rec);
2393: migrate(l_def_pflv_rec, l_okl_prtfl_lines_tl_rec);
2394: -----------------------------------------------
2395: -- Call the INSERT_ROW for each child record --
2396: -----------------------------------------------
2397: insert_row(

Line 2416: l_okl_prtfl_lines_tl_rec,

2412: p_init_msg_list,
2413: l_return_status,
2414: x_msg_count,
2415: x_msg_data,
2416: l_okl_prtfl_lines_tl_rec,
2417: lx_okl_prtfl_lines_tl_rec
2418: );
2419: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2420: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2417: lx_okl_prtfl_lines_tl_rec

2413: l_return_status,
2414: x_msg_count,
2415: x_msg_data,
2416: l_okl_prtfl_lines_tl_rec,
2417: lx_okl_prtfl_lines_tl_rec
2418: );
2419: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2420: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2421: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

Line 2424: migrate(lx_okl_prtfl_lines_tl_rec, l_def_pflv_rec);

2420: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2421: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2422: RAISE OKL_API.G_EXCEPTION_ERROR;
2423: END IF;
2424: migrate(lx_okl_prtfl_lines_tl_rec, l_def_pflv_rec);
2425: -- Set OUT values
2426: x_pflv_rec := l_def_pflv_rec;
2427: x_return_status := l_return_status;
2428: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2734: -- lock_row for:OKL_PRTFL_LINES_TL --

2730: '_PVT'
2731: );
2732: END lock_row;
2733: -------------------------------------
2734: -- lock_row for:OKL_PRTFL_LINES_TL --
2735: -------------------------------------
2736: PROCEDURE lock_row(
2737: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2738: x_return_status OUT NOCOPY VARCHAR2,

Line 2741: p_okl_prtfl_lines_tl_rec IN okl_prtfl_lines_tl_rec_type) IS

2737: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2738: x_return_status OUT NOCOPY VARCHAR2,
2739: x_msg_count OUT NOCOPY NUMBER,
2740: x_msg_data OUT NOCOPY VARCHAR2,
2741: p_okl_prtfl_lines_tl_rec IN okl_prtfl_lines_tl_rec_type) IS
2742:
2743: E_Resource_Busy EXCEPTION;
2744: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2745: CURSOR lock_csr (p_okl_prtfl_lines_tl_rec IN okl_prtfl_lines_tl_rec_type) IS

Line 2745: CURSOR lock_csr (p_okl_prtfl_lines_tl_rec IN okl_prtfl_lines_tl_rec_type) IS

2741: p_okl_prtfl_lines_tl_rec IN okl_prtfl_lines_tl_rec_type) IS
2742:
2743: E_Resource_Busy EXCEPTION;
2744: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2745: CURSOR lock_csr (p_okl_prtfl_lines_tl_rec IN okl_prtfl_lines_tl_rec_type) IS
2746: SELECT *
2747: FROM OKL_PRTFL_LINES_TL
2748: WHERE ID = p_okl_prtfl_lines_tl_rec.id
2749: FOR UPDATE NOWAIT;

Line 2747: FROM OKL_PRTFL_LINES_TL

2743: E_Resource_Busy EXCEPTION;
2744: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2745: CURSOR lock_csr (p_okl_prtfl_lines_tl_rec IN okl_prtfl_lines_tl_rec_type) IS
2746: SELECT *
2747: FROM OKL_PRTFL_LINES_TL
2748: WHERE ID = p_okl_prtfl_lines_tl_rec.id
2749: FOR UPDATE NOWAIT;
2750:
2751: l_api_version CONSTANT NUMBER := 1;

Line 2748: WHERE ID = p_okl_prtfl_lines_tl_rec.id

2744: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2745: CURSOR lock_csr (p_okl_prtfl_lines_tl_rec IN okl_prtfl_lines_tl_rec_type) IS
2746: SELECT *
2747: FROM OKL_PRTFL_LINES_TL
2748: WHERE ID = p_okl_prtfl_lines_tl_rec.id
2749: FOR UPDATE NOWAIT;
2750:
2751: l_api_version CONSTANT NUMBER := 1;
2752: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';

Line 2768: OPEN lock_csr(p_okl_prtfl_lines_tl_rec);

2764: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2765: RAISE OKL_API.G_EXCEPTION_ERROR;
2766: END IF;
2767: BEGIN
2768: OPEN lock_csr(p_okl_prtfl_lines_tl_rec);
2769: FETCH lock_csr INTO l_lock_var;
2770: l_row_notfound := lock_csr%NOTFOUND;
2771: CLOSE lock_csr;
2772: EXCEPTION

Line 2834: l_okl_prtfl_lines_tl_rec okl_prtfl_lines_tl_rec_type;

2830: l_api_version CONSTANT NUMBER := 1;
2831: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
2832: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2833: l_pfl_rec pfl_rec_type;
2834: l_okl_prtfl_lines_tl_rec okl_prtfl_lines_tl_rec_type;
2835: BEGIN
2836: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
2837: G_PKG_NAME,
2838: p_init_msg_list,

Line 2852: migrate(p_pflv_rec, l_okl_prtfl_lines_tl_rec);

2848: -----------------------------------------
2849: -- Move VIEW record to "Child" records --
2850: -----------------------------------------
2851: migrate(p_pflv_rec, l_pfl_rec);
2852: migrate(p_pflv_rec, l_okl_prtfl_lines_tl_rec);
2853: ---------------------------------------------
2854: -- Call the LOCK_ROW for each child record --
2855: ---------------------------------------------
2856: lock_row(

Line 2873: l_okl_prtfl_lines_tl_rec

2869: p_init_msg_list,
2870: l_return_status,
2871: x_msg_count,
2872: x_msg_data,
2873: l_okl_prtfl_lines_tl_rec
2874: );
2875: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2876: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2877: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

Line 3409: -- update_row for:OKL_PRTFL_LINES_TL --

3405: '_PVT'
3406: );
3407: END update_row;
3408: ---------------------------------------
3409: -- update_row for:OKL_PRTFL_LINES_TL --
3410: ---------------------------------------
3411: PROCEDURE update_row(
3412: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
3413: x_return_status OUT NOCOPY VARCHAR2,

Line 3416: p_okl_prtfl_lines_tl_rec IN okl_prtfl_lines_tl_rec_type,

3412: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
3413: x_return_status OUT NOCOPY VARCHAR2,
3414: x_msg_count OUT NOCOPY NUMBER,
3415: x_msg_data OUT NOCOPY VARCHAR2,
3416: p_okl_prtfl_lines_tl_rec IN okl_prtfl_lines_tl_rec_type,
3417: x_okl_prtfl_lines_tl_rec OUT NOCOPY okl_prtfl_lines_tl_rec_type) IS
3418:
3419: l_api_version CONSTANT NUMBER := 1;
3420: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';

Line 3417: x_okl_prtfl_lines_tl_rec OUT NOCOPY okl_prtfl_lines_tl_rec_type) IS

3413: x_return_status OUT NOCOPY VARCHAR2,
3414: x_msg_count OUT NOCOPY NUMBER,
3415: x_msg_data OUT NOCOPY VARCHAR2,
3416: p_okl_prtfl_lines_tl_rec IN okl_prtfl_lines_tl_rec_type,
3417: x_okl_prtfl_lines_tl_rec OUT NOCOPY okl_prtfl_lines_tl_rec_type) IS
3418:
3419: l_api_version CONSTANT NUMBER := 1;
3420: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
3421: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 3422: l_okl_prtfl_lines_tl_rec okl_prtfl_lines_tl_rec_type := p_okl_prtfl_lines_tl_rec;

3418:
3419: l_api_version CONSTANT NUMBER := 1;
3420: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
3421: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3422: l_okl_prtfl_lines_tl_rec okl_prtfl_lines_tl_rec_type := p_okl_prtfl_lines_tl_rec;
3423: l_def_okl_prtfl_lines_tl_rec okl_prtfl_lines_tl_rec_type;
3424: l_row_notfound BOOLEAN := TRUE;
3425: ----------------------------------
3426: -- FUNCTION populate_new_record --

Line 3423: l_def_okl_prtfl_lines_tl_rec okl_prtfl_lines_tl_rec_type;

3419: l_api_version CONSTANT NUMBER := 1;
3420: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
3421: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3422: l_okl_prtfl_lines_tl_rec okl_prtfl_lines_tl_rec_type := p_okl_prtfl_lines_tl_rec;
3423: l_def_okl_prtfl_lines_tl_rec okl_prtfl_lines_tl_rec_type;
3424: l_row_notfound BOOLEAN := TRUE;
3425: ----------------------------------
3426: -- FUNCTION populate_new_record --
3427: ----------------------------------

Line 3429: p_okl_prtfl_lines_tl_rec IN okl_prtfl_lines_tl_rec_type,

3425: ----------------------------------
3426: -- FUNCTION populate_new_record --
3427: ----------------------------------
3428: FUNCTION populate_new_record (
3429: p_okl_prtfl_lines_tl_rec IN okl_prtfl_lines_tl_rec_type,
3430: x_okl_prtfl_lines_tl_rec OUT NOCOPY okl_prtfl_lines_tl_rec_type
3431: ) RETURN VARCHAR2 IS
3432: l_okl_prtfl_lines_tl_rec okl_prtfl_lines_tl_rec_type;
3433: l_row_notfound BOOLEAN := TRUE;

Line 3430: x_okl_prtfl_lines_tl_rec OUT NOCOPY okl_prtfl_lines_tl_rec_type

3426: -- FUNCTION populate_new_record --
3427: ----------------------------------
3428: FUNCTION populate_new_record (
3429: p_okl_prtfl_lines_tl_rec IN okl_prtfl_lines_tl_rec_type,
3430: x_okl_prtfl_lines_tl_rec OUT NOCOPY okl_prtfl_lines_tl_rec_type
3431: ) RETURN VARCHAR2 IS
3432: l_okl_prtfl_lines_tl_rec okl_prtfl_lines_tl_rec_type;
3433: l_row_notfound BOOLEAN := TRUE;
3434: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 3432: l_okl_prtfl_lines_tl_rec okl_prtfl_lines_tl_rec_type;

3428: FUNCTION populate_new_record (
3429: p_okl_prtfl_lines_tl_rec IN okl_prtfl_lines_tl_rec_type,
3430: x_okl_prtfl_lines_tl_rec OUT NOCOPY okl_prtfl_lines_tl_rec_type
3431: ) RETURN VARCHAR2 IS
3432: l_okl_prtfl_lines_tl_rec okl_prtfl_lines_tl_rec_type;
3433: l_row_notfound BOOLEAN := TRUE;
3434: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3435: BEGIN
3436: x_okl_prtfl_lines_tl_rec := p_okl_prtfl_lines_tl_rec;

Line 3436: x_okl_prtfl_lines_tl_rec := p_okl_prtfl_lines_tl_rec;

3432: l_okl_prtfl_lines_tl_rec okl_prtfl_lines_tl_rec_type;
3433: l_row_notfound BOOLEAN := TRUE;
3434: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3435: BEGIN
3436: x_okl_prtfl_lines_tl_rec := p_okl_prtfl_lines_tl_rec;
3437: -- Get current database values
3438: l_okl_prtfl_lines_tl_rec := get_rec(p_okl_prtfl_lines_tl_rec, l_return_status);
3439: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
3440: IF (x_okl_prtfl_lines_tl_rec.id = OKL_API.G_MISS_NUM)

Line 3438: l_okl_prtfl_lines_tl_rec := get_rec(p_okl_prtfl_lines_tl_rec, l_return_status);

3434: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3435: BEGIN
3436: x_okl_prtfl_lines_tl_rec := p_okl_prtfl_lines_tl_rec;
3437: -- Get current database values
3438: l_okl_prtfl_lines_tl_rec := get_rec(p_okl_prtfl_lines_tl_rec, l_return_status);
3439: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
3440: IF (x_okl_prtfl_lines_tl_rec.id = OKL_API.G_MISS_NUM)
3441: THEN
3442: x_okl_prtfl_lines_tl_rec.id := l_okl_prtfl_lines_tl_rec.id;

Line 3440: IF (x_okl_prtfl_lines_tl_rec.id = OKL_API.G_MISS_NUM)

3436: x_okl_prtfl_lines_tl_rec := p_okl_prtfl_lines_tl_rec;
3437: -- Get current database values
3438: l_okl_prtfl_lines_tl_rec := get_rec(p_okl_prtfl_lines_tl_rec, l_return_status);
3439: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
3440: IF (x_okl_prtfl_lines_tl_rec.id = OKL_API.G_MISS_NUM)
3441: THEN
3442: x_okl_prtfl_lines_tl_rec.id := l_okl_prtfl_lines_tl_rec.id;
3443: END IF;
3444: IF (x_okl_prtfl_lines_tl_rec.language = OKL_API.G_MISS_CHAR)

Line 3442: x_okl_prtfl_lines_tl_rec.id := l_okl_prtfl_lines_tl_rec.id;

3438: l_okl_prtfl_lines_tl_rec := get_rec(p_okl_prtfl_lines_tl_rec, l_return_status);
3439: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
3440: IF (x_okl_prtfl_lines_tl_rec.id = OKL_API.G_MISS_NUM)
3441: THEN
3442: x_okl_prtfl_lines_tl_rec.id := l_okl_prtfl_lines_tl_rec.id;
3443: END IF;
3444: IF (x_okl_prtfl_lines_tl_rec.language = OKL_API.G_MISS_CHAR)
3445: THEN
3446: x_okl_prtfl_lines_tl_rec.language := l_okl_prtfl_lines_tl_rec.language;

Line 3444: IF (x_okl_prtfl_lines_tl_rec.language = OKL_API.G_MISS_CHAR)

3440: IF (x_okl_prtfl_lines_tl_rec.id = OKL_API.G_MISS_NUM)
3441: THEN
3442: x_okl_prtfl_lines_tl_rec.id := l_okl_prtfl_lines_tl_rec.id;
3443: END IF;
3444: IF (x_okl_prtfl_lines_tl_rec.language = OKL_API.G_MISS_CHAR)
3445: THEN
3446: x_okl_prtfl_lines_tl_rec.language := l_okl_prtfl_lines_tl_rec.language;
3447: END IF;
3448: IF (x_okl_prtfl_lines_tl_rec.source_lang = OKL_API.G_MISS_CHAR)

Line 3446: x_okl_prtfl_lines_tl_rec.language := l_okl_prtfl_lines_tl_rec.language;

3442: x_okl_prtfl_lines_tl_rec.id := l_okl_prtfl_lines_tl_rec.id;
3443: END IF;
3444: IF (x_okl_prtfl_lines_tl_rec.language = OKL_API.G_MISS_CHAR)
3445: THEN
3446: x_okl_prtfl_lines_tl_rec.language := l_okl_prtfl_lines_tl_rec.language;
3447: END IF;
3448: IF (x_okl_prtfl_lines_tl_rec.source_lang = OKL_API.G_MISS_CHAR)
3449: THEN
3450: x_okl_prtfl_lines_tl_rec.source_lang := l_okl_prtfl_lines_tl_rec.source_lang;

Line 3448: IF (x_okl_prtfl_lines_tl_rec.source_lang = OKL_API.G_MISS_CHAR)

3444: IF (x_okl_prtfl_lines_tl_rec.language = OKL_API.G_MISS_CHAR)
3445: THEN
3446: x_okl_prtfl_lines_tl_rec.language := l_okl_prtfl_lines_tl_rec.language;
3447: END IF;
3448: IF (x_okl_prtfl_lines_tl_rec.source_lang = OKL_API.G_MISS_CHAR)
3449: THEN
3450: x_okl_prtfl_lines_tl_rec.source_lang := l_okl_prtfl_lines_tl_rec.source_lang;
3451: END IF;
3452: IF (x_okl_prtfl_lines_tl_rec.sfwt_flag = OKL_API.G_MISS_CHAR)

Line 3450: x_okl_prtfl_lines_tl_rec.source_lang := l_okl_prtfl_lines_tl_rec.source_lang;

3446: x_okl_prtfl_lines_tl_rec.language := l_okl_prtfl_lines_tl_rec.language;
3447: END IF;
3448: IF (x_okl_prtfl_lines_tl_rec.source_lang = OKL_API.G_MISS_CHAR)
3449: THEN
3450: x_okl_prtfl_lines_tl_rec.source_lang := l_okl_prtfl_lines_tl_rec.source_lang;
3451: END IF;
3452: IF (x_okl_prtfl_lines_tl_rec.sfwt_flag = OKL_API.G_MISS_CHAR)
3453: THEN
3454: x_okl_prtfl_lines_tl_rec.sfwt_flag := l_okl_prtfl_lines_tl_rec.sfwt_flag;

Line 3452: IF (x_okl_prtfl_lines_tl_rec.sfwt_flag = OKL_API.G_MISS_CHAR)

3448: IF (x_okl_prtfl_lines_tl_rec.source_lang = OKL_API.G_MISS_CHAR)
3449: THEN
3450: x_okl_prtfl_lines_tl_rec.source_lang := l_okl_prtfl_lines_tl_rec.source_lang;
3451: END IF;
3452: IF (x_okl_prtfl_lines_tl_rec.sfwt_flag = OKL_API.G_MISS_CHAR)
3453: THEN
3454: x_okl_prtfl_lines_tl_rec.sfwt_flag := l_okl_prtfl_lines_tl_rec.sfwt_flag;
3455: END IF;
3456: IF (x_okl_prtfl_lines_tl_rec.comments = OKL_API.G_MISS_CHAR)

Line 3454: x_okl_prtfl_lines_tl_rec.sfwt_flag := l_okl_prtfl_lines_tl_rec.sfwt_flag;

3450: x_okl_prtfl_lines_tl_rec.source_lang := l_okl_prtfl_lines_tl_rec.source_lang;
3451: END IF;
3452: IF (x_okl_prtfl_lines_tl_rec.sfwt_flag = OKL_API.G_MISS_CHAR)
3453: THEN
3454: x_okl_prtfl_lines_tl_rec.sfwt_flag := l_okl_prtfl_lines_tl_rec.sfwt_flag;
3455: END IF;
3456: IF (x_okl_prtfl_lines_tl_rec.comments = OKL_API.G_MISS_CHAR)
3457: THEN
3458: x_okl_prtfl_lines_tl_rec.comments := l_okl_prtfl_lines_tl_rec.comments;

Line 3456: IF (x_okl_prtfl_lines_tl_rec.comments = OKL_API.G_MISS_CHAR)

3452: IF (x_okl_prtfl_lines_tl_rec.sfwt_flag = OKL_API.G_MISS_CHAR)
3453: THEN
3454: x_okl_prtfl_lines_tl_rec.sfwt_flag := l_okl_prtfl_lines_tl_rec.sfwt_flag;
3455: END IF;
3456: IF (x_okl_prtfl_lines_tl_rec.comments = OKL_API.G_MISS_CHAR)
3457: THEN
3458: x_okl_prtfl_lines_tl_rec.comments := l_okl_prtfl_lines_tl_rec.comments;
3459: END IF;
3460: IF (x_okl_prtfl_lines_tl_rec.created_by = OKL_API.G_MISS_NUM)

Line 3458: x_okl_prtfl_lines_tl_rec.comments := l_okl_prtfl_lines_tl_rec.comments;

3454: x_okl_prtfl_lines_tl_rec.sfwt_flag := l_okl_prtfl_lines_tl_rec.sfwt_flag;
3455: END IF;
3456: IF (x_okl_prtfl_lines_tl_rec.comments = OKL_API.G_MISS_CHAR)
3457: THEN
3458: x_okl_prtfl_lines_tl_rec.comments := l_okl_prtfl_lines_tl_rec.comments;
3459: END IF;
3460: IF (x_okl_prtfl_lines_tl_rec.created_by = OKL_API.G_MISS_NUM)
3461: THEN
3462: x_okl_prtfl_lines_tl_rec.created_by := l_okl_prtfl_lines_tl_rec.created_by;

Line 3460: IF (x_okl_prtfl_lines_tl_rec.created_by = OKL_API.G_MISS_NUM)

3456: IF (x_okl_prtfl_lines_tl_rec.comments = OKL_API.G_MISS_CHAR)
3457: THEN
3458: x_okl_prtfl_lines_tl_rec.comments := l_okl_prtfl_lines_tl_rec.comments;
3459: END IF;
3460: IF (x_okl_prtfl_lines_tl_rec.created_by = OKL_API.G_MISS_NUM)
3461: THEN
3462: x_okl_prtfl_lines_tl_rec.created_by := l_okl_prtfl_lines_tl_rec.created_by;
3463: END IF;
3464: IF (x_okl_prtfl_lines_tl_rec.creation_date = OKL_API.G_MISS_DATE)

Line 3462: x_okl_prtfl_lines_tl_rec.created_by := l_okl_prtfl_lines_tl_rec.created_by;

3458: x_okl_prtfl_lines_tl_rec.comments := l_okl_prtfl_lines_tl_rec.comments;
3459: END IF;
3460: IF (x_okl_prtfl_lines_tl_rec.created_by = OKL_API.G_MISS_NUM)
3461: THEN
3462: x_okl_prtfl_lines_tl_rec.created_by := l_okl_prtfl_lines_tl_rec.created_by;
3463: END IF;
3464: IF (x_okl_prtfl_lines_tl_rec.creation_date = OKL_API.G_MISS_DATE)
3465: THEN
3466: x_okl_prtfl_lines_tl_rec.creation_date := l_okl_prtfl_lines_tl_rec.creation_date;

Line 3464: IF (x_okl_prtfl_lines_tl_rec.creation_date = OKL_API.G_MISS_DATE)

3460: IF (x_okl_prtfl_lines_tl_rec.created_by = OKL_API.G_MISS_NUM)
3461: THEN
3462: x_okl_prtfl_lines_tl_rec.created_by := l_okl_prtfl_lines_tl_rec.created_by;
3463: END IF;
3464: IF (x_okl_prtfl_lines_tl_rec.creation_date = OKL_API.G_MISS_DATE)
3465: THEN
3466: x_okl_prtfl_lines_tl_rec.creation_date := l_okl_prtfl_lines_tl_rec.creation_date;
3467: END IF;
3468: IF (x_okl_prtfl_lines_tl_rec.last_updated_by = OKL_API.G_MISS_NUM)

Line 3466: x_okl_prtfl_lines_tl_rec.creation_date := l_okl_prtfl_lines_tl_rec.creation_date;

3462: x_okl_prtfl_lines_tl_rec.created_by := l_okl_prtfl_lines_tl_rec.created_by;
3463: END IF;
3464: IF (x_okl_prtfl_lines_tl_rec.creation_date = OKL_API.G_MISS_DATE)
3465: THEN
3466: x_okl_prtfl_lines_tl_rec.creation_date := l_okl_prtfl_lines_tl_rec.creation_date;
3467: END IF;
3468: IF (x_okl_prtfl_lines_tl_rec.last_updated_by = OKL_API.G_MISS_NUM)
3469: THEN
3470: x_okl_prtfl_lines_tl_rec.last_updated_by := l_okl_prtfl_lines_tl_rec.last_updated_by;

Line 3468: IF (x_okl_prtfl_lines_tl_rec.last_updated_by = OKL_API.G_MISS_NUM)

3464: IF (x_okl_prtfl_lines_tl_rec.creation_date = OKL_API.G_MISS_DATE)
3465: THEN
3466: x_okl_prtfl_lines_tl_rec.creation_date := l_okl_prtfl_lines_tl_rec.creation_date;
3467: END IF;
3468: IF (x_okl_prtfl_lines_tl_rec.last_updated_by = OKL_API.G_MISS_NUM)
3469: THEN
3470: x_okl_prtfl_lines_tl_rec.last_updated_by := l_okl_prtfl_lines_tl_rec.last_updated_by;
3471: END IF;
3472: IF (x_okl_prtfl_lines_tl_rec.last_update_date = OKL_API.G_MISS_DATE)

Line 3470: x_okl_prtfl_lines_tl_rec.last_updated_by := l_okl_prtfl_lines_tl_rec.last_updated_by;

3466: x_okl_prtfl_lines_tl_rec.creation_date := l_okl_prtfl_lines_tl_rec.creation_date;
3467: END IF;
3468: IF (x_okl_prtfl_lines_tl_rec.last_updated_by = OKL_API.G_MISS_NUM)
3469: THEN
3470: x_okl_prtfl_lines_tl_rec.last_updated_by := l_okl_prtfl_lines_tl_rec.last_updated_by;
3471: END IF;
3472: IF (x_okl_prtfl_lines_tl_rec.last_update_date = OKL_API.G_MISS_DATE)
3473: THEN
3474: x_okl_prtfl_lines_tl_rec.last_update_date := l_okl_prtfl_lines_tl_rec.last_update_date;

Line 3472: IF (x_okl_prtfl_lines_tl_rec.last_update_date = OKL_API.G_MISS_DATE)

3468: IF (x_okl_prtfl_lines_tl_rec.last_updated_by = OKL_API.G_MISS_NUM)
3469: THEN
3470: x_okl_prtfl_lines_tl_rec.last_updated_by := l_okl_prtfl_lines_tl_rec.last_updated_by;
3471: END IF;
3472: IF (x_okl_prtfl_lines_tl_rec.last_update_date = OKL_API.G_MISS_DATE)
3473: THEN
3474: x_okl_prtfl_lines_tl_rec.last_update_date := l_okl_prtfl_lines_tl_rec.last_update_date;
3475: END IF;
3476: IF (x_okl_prtfl_lines_tl_rec.last_update_login = OKL_API.G_MISS_NUM)

Line 3474: x_okl_prtfl_lines_tl_rec.last_update_date := l_okl_prtfl_lines_tl_rec.last_update_date;

3470: x_okl_prtfl_lines_tl_rec.last_updated_by := l_okl_prtfl_lines_tl_rec.last_updated_by;
3471: END IF;
3472: IF (x_okl_prtfl_lines_tl_rec.last_update_date = OKL_API.G_MISS_DATE)
3473: THEN
3474: x_okl_prtfl_lines_tl_rec.last_update_date := l_okl_prtfl_lines_tl_rec.last_update_date;
3475: END IF;
3476: IF (x_okl_prtfl_lines_tl_rec.last_update_login = OKL_API.G_MISS_NUM)
3477: THEN
3478: x_okl_prtfl_lines_tl_rec.last_update_login := l_okl_prtfl_lines_tl_rec.last_update_login;

Line 3476: IF (x_okl_prtfl_lines_tl_rec.last_update_login = OKL_API.G_MISS_NUM)

3472: IF (x_okl_prtfl_lines_tl_rec.last_update_date = OKL_API.G_MISS_DATE)
3473: THEN
3474: x_okl_prtfl_lines_tl_rec.last_update_date := l_okl_prtfl_lines_tl_rec.last_update_date;
3475: END IF;
3476: IF (x_okl_prtfl_lines_tl_rec.last_update_login = OKL_API.G_MISS_NUM)
3477: THEN
3478: x_okl_prtfl_lines_tl_rec.last_update_login := l_okl_prtfl_lines_tl_rec.last_update_login;
3479: END IF;
3480: END IF;

Line 3478: x_okl_prtfl_lines_tl_rec.last_update_login := l_okl_prtfl_lines_tl_rec.last_update_login;

3474: x_okl_prtfl_lines_tl_rec.last_update_date := l_okl_prtfl_lines_tl_rec.last_update_date;
3475: END IF;
3476: IF (x_okl_prtfl_lines_tl_rec.last_update_login = OKL_API.G_MISS_NUM)
3477: THEN
3478: x_okl_prtfl_lines_tl_rec.last_update_login := l_okl_prtfl_lines_tl_rec.last_update_login;
3479: END IF;
3480: END IF;
3481: RETURN(l_return_status);
3482: END populate_new_record;

Line 3484: -- Set_Attributes for:OKL_PRTFL_LINES_TL --

3480: END IF;
3481: RETURN(l_return_status);
3482: END populate_new_record;
3483: -------------------------------------------
3484: -- Set_Attributes for:OKL_PRTFL_LINES_TL --
3485: -------------------------------------------
3486: FUNCTION Set_Attributes (
3487: p_okl_prtfl_lines_tl_rec IN okl_prtfl_lines_tl_rec_type,
3488: x_okl_prtfl_lines_tl_rec OUT NOCOPY okl_prtfl_lines_tl_rec_type

Line 3487: p_okl_prtfl_lines_tl_rec IN okl_prtfl_lines_tl_rec_type,

3483: -------------------------------------------
3484: -- Set_Attributes for:OKL_PRTFL_LINES_TL --
3485: -------------------------------------------
3486: FUNCTION Set_Attributes (
3487: p_okl_prtfl_lines_tl_rec IN okl_prtfl_lines_tl_rec_type,
3488: x_okl_prtfl_lines_tl_rec OUT NOCOPY okl_prtfl_lines_tl_rec_type
3489: ) RETURN VARCHAR2 IS
3490: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3491: BEGIN

Line 3488: x_okl_prtfl_lines_tl_rec OUT NOCOPY okl_prtfl_lines_tl_rec_type

3484: -- Set_Attributes for:OKL_PRTFL_LINES_TL --
3485: -------------------------------------------
3486: FUNCTION Set_Attributes (
3487: p_okl_prtfl_lines_tl_rec IN okl_prtfl_lines_tl_rec_type,
3488: x_okl_prtfl_lines_tl_rec OUT NOCOPY okl_prtfl_lines_tl_rec_type
3489: ) RETURN VARCHAR2 IS
3490: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3491: BEGIN
3492: x_okl_prtfl_lines_tl_rec := p_okl_prtfl_lines_tl_rec;

Line 3492: x_okl_prtfl_lines_tl_rec := p_okl_prtfl_lines_tl_rec;

3488: x_okl_prtfl_lines_tl_rec OUT NOCOPY okl_prtfl_lines_tl_rec_type
3489: ) RETURN VARCHAR2 IS
3490: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3491: BEGIN
3492: x_okl_prtfl_lines_tl_rec := p_okl_prtfl_lines_tl_rec;
3493: x_okl_prtfl_lines_tl_rec.LANGUAGE := USERENV('LANG');
3494: x_okl_prtfl_lines_tl_rec.LANGUAGE := USERENV('LANG');
3495: RETURN(l_return_status);
3496: END Set_Attributes;

Line 3493: x_okl_prtfl_lines_tl_rec.LANGUAGE := USERENV('LANG');

3489: ) RETURN VARCHAR2 IS
3490: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3491: BEGIN
3492: x_okl_prtfl_lines_tl_rec := p_okl_prtfl_lines_tl_rec;
3493: x_okl_prtfl_lines_tl_rec.LANGUAGE := USERENV('LANG');
3494: x_okl_prtfl_lines_tl_rec.LANGUAGE := USERENV('LANG');
3495: RETURN(l_return_status);
3496: END Set_Attributes;
3497: BEGIN

Line 3494: x_okl_prtfl_lines_tl_rec.LANGUAGE := USERENV('LANG');

3490: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3491: BEGIN
3492: x_okl_prtfl_lines_tl_rec := p_okl_prtfl_lines_tl_rec;
3493: x_okl_prtfl_lines_tl_rec.LANGUAGE := USERENV('LANG');
3494: x_okl_prtfl_lines_tl_rec.LANGUAGE := USERENV('LANG');
3495: RETURN(l_return_status);
3496: END Set_Attributes;
3497: BEGIN
3498: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

Line 3509: p_okl_prtfl_lines_tl_rec, -- IN

3505: RAISE OKL_API.G_EXCEPTION_ERROR;
3506: END IF;
3507: --- Setting item attributes
3508: l_return_status := Set_Attributes(
3509: p_okl_prtfl_lines_tl_rec, -- IN
3510: l_okl_prtfl_lines_tl_rec); -- OUT
3511: --- If any errors happen abort API
3512: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3513: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3510: l_okl_prtfl_lines_tl_rec); -- OUT

3506: END IF;
3507: --- Setting item attributes
3508: l_return_status := Set_Attributes(
3509: p_okl_prtfl_lines_tl_rec, -- IN
3510: l_okl_prtfl_lines_tl_rec); -- OUT
3511: --- If any errors happen abort API
3512: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3513: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3514: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

Line 3517: l_return_status := populate_new_record(l_okl_prtfl_lines_tl_rec, l_def_okl_prtfl_lines_tl_rec);

3513: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3514: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3515: RAISE OKL_API.G_EXCEPTION_ERROR;
3516: END IF;
3517: l_return_status := populate_new_record(l_okl_prtfl_lines_tl_rec, l_def_okl_prtfl_lines_tl_rec);
3518: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3519: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3520: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3521: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 3523: UPDATE OKL_PRTFL_LINES_TL

3519: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3520: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3521: RAISE OKL_API.G_EXCEPTION_ERROR;
3522: END IF;
3523: UPDATE OKL_PRTFL_LINES_TL
3524: SET COMMENTS = l_def_okl_prtfl_lines_tl_rec.comments,
3525: SOURCE_LANG = l_def_okl_prtfl_lines_tl_rec.source_lang, --Fix for bug 3637102
3526: CREATED_BY = l_def_okl_prtfl_lines_tl_rec.created_by,
3527: CREATION_DATE = l_def_okl_prtfl_lines_tl_rec.creation_date,

Line 3524: SET COMMENTS = l_def_okl_prtfl_lines_tl_rec.comments,

3520: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3521: RAISE OKL_API.G_EXCEPTION_ERROR;
3522: END IF;
3523: UPDATE OKL_PRTFL_LINES_TL
3524: SET COMMENTS = l_def_okl_prtfl_lines_tl_rec.comments,
3525: SOURCE_LANG = l_def_okl_prtfl_lines_tl_rec.source_lang, --Fix for bug 3637102
3526: CREATED_BY = l_def_okl_prtfl_lines_tl_rec.created_by,
3527: CREATION_DATE = l_def_okl_prtfl_lines_tl_rec.creation_date,
3528: LAST_UPDATED_BY = l_def_okl_prtfl_lines_tl_rec.last_updated_by,

Line 3525: SOURCE_LANG = l_def_okl_prtfl_lines_tl_rec.source_lang, --Fix for bug 3637102

3521: RAISE OKL_API.G_EXCEPTION_ERROR;
3522: END IF;
3523: UPDATE OKL_PRTFL_LINES_TL
3524: SET COMMENTS = l_def_okl_prtfl_lines_tl_rec.comments,
3525: SOURCE_LANG = l_def_okl_prtfl_lines_tl_rec.source_lang, --Fix for bug 3637102
3526: CREATED_BY = l_def_okl_prtfl_lines_tl_rec.created_by,
3527: CREATION_DATE = l_def_okl_prtfl_lines_tl_rec.creation_date,
3528: LAST_UPDATED_BY = l_def_okl_prtfl_lines_tl_rec.last_updated_by,
3529: LAST_UPDATE_DATE = l_def_okl_prtfl_lines_tl_rec.last_update_date,

Line 3526: CREATED_BY = l_def_okl_prtfl_lines_tl_rec.created_by,

3522: END IF;
3523: UPDATE OKL_PRTFL_LINES_TL
3524: SET COMMENTS = l_def_okl_prtfl_lines_tl_rec.comments,
3525: SOURCE_LANG = l_def_okl_prtfl_lines_tl_rec.source_lang, --Fix for bug 3637102
3526: CREATED_BY = l_def_okl_prtfl_lines_tl_rec.created_by,
3527: CREATION_DATE = l_def_okl_prtfl_lines_tl_rec.creation_date,
3528: LAST_UPDATED_BY = l_def_okl_prtfl_lines_tl_rec.last_updated_by,
3529: LAST_UPDATE_DATE = l_def_okl_prtfl_lines_tl_rec.last_update_date,
3530: LAST_UPDATE_LOGIN = l_def_okl_prtfl_lines_tl_rec.last_update_login

Line 3527: CREATION_DATE = l_def_okl_prtfl_lines_tl_rec.creation_date,

3523: UPDATE OKL_PRTFL_LINES_TL
3524: SET COMMENTS = l_def_okl_prtfl_lines_tl_rec.comments,
3525: SOURCE_LANG = l_def_okl_prtfl_lines_tl_rec.source_lang, --Fix for bug 3637102
3526: CREATED_BY = l_def_okl_prtfl_lines_tl_rec.created_by,
3527: CREATION_DATE = l_def_okl_prtfl_lines_tl_rec.creation_date,
3528: LAST_UPDATED_BY = l_def_okl_prtfl_lines_tl_rec.last_updated_by,
3529: LAST_UPDATE_DATE = l_def_okl_prtfl_lines_tl_rec.last_update_date,
3530: LAST_UPDATE_LOGIN = l_def_okl_prtfl_lines_tl_rec.last_update_login
3531: WHERE ID = l_def_okl_prtfl_lines_tl_rec.id

Line 3528: LAST_UPDATED_BY = l_def_okl_prtfl_lines_tl_rec.last_updated_by,

3524: SET COMMENTS = l_def_okl_prtfl_lines_tl_rec.comments,
3525: SOURCE_LANG = l_def_okl_prtfl_lines_tl_rec.source_lang, --Fix for bug 3637102
3526: CREATED_BY = l_def_okl_prtfl_lines_tl_rec.created_by,
3527: CREATION_DATE = l_def_okl_prtfl_lines_tl_rec.creation_date,
3528: LAST_UPDATED_BY = l_def_okl_prtfl_lines_tl_rec.last_updated_by,
3529: LAST_UPDATE_DATE = l_def_okl_prtfl_lines_tl_rec.last_update_date,
3530: LAST_UPDATE_LOGIN = l_def_okl_prtfl_lines_tl_rec.last_update_login
3531: WHERE ID = l_def_okl_prtfl_lines_tl_rec.id
3532: AND USERENV('LANG') in (SOURCE_LANG,LANGUAGE); --Fix for 3637102

Line 3529: LAST_UPDATE_DATE = l_def_okl_prtfl_lines_tl_rec.last_update_date,

3525: SOURCE_LANG = l_def_okl_prtfl_lines_tl_rec.source_lang, --Fix for bug 3637102
3526: CREATED_BY = l_def_okl_prtfl_lines_tl_rec.created_by,
3527: CREATION_DATE = l_def_okl_prtfl_lines_tl_rec.creation_date,
3528: LAST_UPDATED_BY = l_def_okl_prtfl_lines_tl_rec.last_updated_by,
3529: LAST_UPDATE_DATE = l_def_okl_prtfl_lines_tl_rec.last_update_date,
3530: LAST_UPDATE_LOGIN = l_def_okl_prtfl_lines_tl_rec.last_update_login
3531: WHERE ID = l_def_okl_prtfl_lines_tl_rec.id
3532: AND USERENV('LANG') in (SOURCE_LANG,LANGUAGE); --Fix for 3637102
3533: --AND SOURCE_LANG = USERENV('LANG');

Line 3530: LAST_UPDATE_LOGIN = l_def_okl_prtfl_lines_tl_rec.last_update_login

3526: CREATED_BY = l_def_okl_prtfl_lines_tl_rec.created_by,
3527: CREATION_DATE = l_def_okl_prtfl_lines_tl_rec.creation_date,
3528: LAST_UPDATED_BY = l_def_okl_prtfl_lines_tl_rec.last_updated_by,
3529: LAST_UPDATE_DATE = l_def_okl_prtfl_lines_tl_rec.last_update_date,
3530: LAST_UPDATE_LOGIN = l_def_okl_prtfl_lines_tl_rec.last_update_login
3531: WHERE ID = l_def_okl_prtfl_lines_tl_rec.id
3532: AND USERENV('LANG') in (SOURCE_LANG,LANGUAGE); --Fix for 3637102
3533: --AND SOURCE_LANG = USERENV('LANG');
3534:

Line 3531: WHERE ID = l_def_okl_prtfl_lines_tl_rec.id

3527: CREATION_DATE = l_def_okl_prtfl_lines_tl_rec.creation_date,
3528: LAST_UPDATED_BY = l_def_okl_prtfl_lines_tl_rec.last_updated_by,
3529: LAST_UPDATE_DATE = l_def_okl_prtfl_lines_tl_rec.last_update_date,
3530: LAST_UPDATE_LOGIN = l_def_okl_prtfl_lines_tl_rec.last_update_login
3531: WHERE ID = l_def_okl_prtfl_lines_tl_rec.id
3532: AND USERENV('LANG') in (SOURCE_LANG,LANGUAGE); --Fix for 3637102
3533: --AND SOURCE_LANG = USERENV('LANG');
3534:
3535: UPDATE OKL_PRTFL_LINES_TL

Line 3535: UPDATE OKL_PRTFL_LINES_TL

3531: WHERE ID = l_def_okl_prtfl_lines_tl_rec.id
3532: AND USERENV('LANG') in (SOURCE_LANG,LANGUAGE); --Fix for 3637102
3533: --AND SOURCE_LANG = USERENV('LANG');
3534:
3535: UPDATE OKL_PRTFL_LINES_TL
3536: SET SFWT_FLAG = 'Y'
3537: WHERE ID = l_def_okl_prtfl_lines_tl_rec.id
3538: AND SOURCE_LANG <> USERENV('LANG');
3539:

Line 3537: WHERE ID = l_def_okl_prtfl_lines_tl_rec.id

3533: --AND SOURCE_LANG = USERENV('LANG');
3534:
3535: UPDATE OKL_PRTFL_LINES_TL
3536: SET SFWT_FLAG = 'Y'
3537: WHERE ID = l_def_okl_prtfl_lines_tl_rec.id
3538: AND SOURCE_LANG <> USERENV('LANG');
3539:
3540: x_okl_prtfl_lines_tl_rec := l_okl_prtfl_lines_tl_rec;
3541: x_return_status := l_return_status;

Line 3540: x_okl_prtfl_lines_tl_rec := l_okl_prtfl_lines_tl_rec;

3536: SET SFWT_FLAG = 'Y'
3537: WHERE ID = l_def_okl_prtfl_lines_tl_rec.id
3538: AND SOURCE_LANG <> USERENV('LANG');
3539:
3540: x_okl_prtfl_lines_tl_rec := l_okl_prtfl_lines_tl_rec;
3541: x_return_status := l_return_status;
3542: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
3543: EXCEPTION
3544: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 3605: l_okl_prtfl_lines_tl_rec okl_prtfl_lines_tl_rec_type;

3601: l_def_pflv_rec pflv_rec_type;
3602: l_db_pflv_rec pflv_rec_type;
3603: l_pfl_rec pfl_rec_type;
3604: lx_pfl_rec pfl_rec_type;
3605: l_okl_prtfl_lines_tl_rec okl_prtfl_lines_tl_rec_type;
3606: lx_okl_prtfl_lines_tl_rec okl_prtfl_lines_tl_rec_type;
3607: -------------------------------
3608: -- FUNCTION fill_who_columns --
3609: -------------------------------

Line 3606: lx_okl_prtfl_lines_tl_rec okl_prtfl_lines_tl_rec_type;

3602: l_db_pflv_rec pflv_rec_type;
3603: l_pfl_rec pfl_rec_type;
3604: lx_pfl_rec pfl_rec_type;
3605: l_okl_prtfl_lines_tl_rec okl_prtfl_lines_tl_rec_type;
3606: lx_okl_prtfl_lines_tl_rec okl_prtfl_lines_tl_rec_type;
3607: -------------------------------
3608: -- FUNCTION fill_who_columns --
3609: -------------------------------
3610: FUNCTION fill_who_columns (

Line 3896: migrate(l_def_pflv_rec, l_okl_prtfl_lines_tl_rec);

3892: -----------------------------------------
3893: -- Move VIEW record to "Child" records --
3894: -----------------------------------------
3895: migrate(l_def_pflv_rec, l_pfl_rec);
3896: migrate(l_def_pflv_rec, l_okl_prtfl_lines_tl_rec);
3897: -----------------------------------------------
3898: -- Call the UPDATE_ROW for each child record --
3899: -----------------------------------------------
3900: update_row(

Line 3919: l_okl_prtfl_lines_tl_rec,

3915: p_init_msg_list,
3916: l_return_status,
3917: x_msg_count,
3918: x_msg_data,
3919: l_okl_prtfl_lines_tl_rec,
3920: lx_okl_prtfl_lines_tl_rec
3921: );
3922: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3923: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3920: lx_okl_prtfl_lines_tl_rec

3916: l_return_status,
3917: x_msg_count,
3918: x_msg_data,
3919: l_okl_prtfl_lines_tl_rec,
3920: lx_okl_prtfl_lines_tl_rec
3921: );
3922: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3923: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3924: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

Line 3927: migrate(lx_okl_prtfl_lines_tl_rec, l_def_pflv_rec);

3923: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3924: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3925: RAISE OKL_API.G_EXCEPTION_ERROR;
3926: END IF;
3927: migrate(lx_okl_prtfl_lines_tl_rec, l_def_pflv_rec);
3928: x_pflv_rec := l_def_pflv_rec;
3929: x_return_status := l_return_status;
3930: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
3931: EXCEPTION

Line 4192: -- delete_row for:OKL_PRTFL_LINES_TL --

4188: '_PVT'
4189: );
4190: END delete_row;
4191: ---------------------------------------
4192: -- delete_row for:OKL_PRTFL_LINES_TL --
4193: ---------------------------------------
4194: PROCEDURE delete_row(
4195: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
4196: x_return_status OUT NOCOPY VARCHAR2,

Line 4199: p_okl_prtfl_lines_tl_rec IN okl_prtfl_lines_tl_rec_type) IS

4195: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
4196: x_return_status OUT NOCOPY VARCHAR2,
4197: x_msg_count OUT NOCOPY NUMBER,
4198: x_msg_data OUT NOCOPY VARCHAR2,
4199: p_okl_prtfl_lines_tl_rec IN okl_prtfl_lines_tl_rec_type) IS
4200:
4201: l_api_version CONSTANT NUMBER := 1;
4202: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
4203: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 4204: l_okl_prtfl_lines_tl_rec okl_prtfl_lines_tl_rec_type := p_okl_prtfl_lines_tl_rec;

4200:
4201: l_api_version CONSTANT NUMBER := 1;
4202: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
4203: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
4204: l_okl_prtfl_lines_tl_rec okl_prtfl_lines_tl_rec_type := p_okl_prtfl_lines_tl_rec;
4205: l_row_notfound BOOLEAN := TRUE;
4206: BEGIN
4207: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
4208: p_init_msg_list,

Line 4217: DELETE FROM OKL_PRTFL_LINES_TL

4213: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
4214: RAISE OKL_API.G_EXCEPTION_ERROR;
4215: END IF;
4216:
4217: DELETE FROM OKL_PRTFL_LINES_TL
4218: WHERE ID = p_okl_prtfl_lines_tl_rec.id;
4219:
4220: x_return_status := l_return_status;
4221: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 4218: WHERE ID = p_okl_prtfl_lines_tl_rec.id;

4214: RAISE OKL_API.G_EXCEPTION_ERROR;
4215: END IF;
4216:
4217: DELETE FROM OKL_PRTFL_LINES_TL
4218: WHERE ID = p_okl_prtfl_lines_tl_rec.id;
4219:
4220: x_return_status := l_return_status;
4221: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
4222: EXCEPTION

Line 4269: l_okl_prtfl_lines_tl_rec okl_prtfl_lines_tl_rec_type;

4265: l_api_version CONSTANT NUMBER := 1;
4266: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
4267: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
4268: l_pflv_rec pflv_rec_type := p_pflv_rec;
4269: l_okl_prtfl_lines_tl_rec okl_prtfl_lines_tl_rec_type;
4270: l_pfl_rec pfl_rec_type;
4271: BEGIN
4272: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
4273: G_PKG_NAME,

Line 4287: migrate(l_pflv_rec, l_okl_prtfl_lines_tl_rec);

4283: END IF;
4284: -----------------------------------------
4285: -- Move VIEW record to "Child" records --
4286: -----------------------------------------
4287: migrate(l_pflv_rec, l_okl_prtfl_lines_tl_rec);
4288: migrate(l_pflv_rec, l_pfl_rec);
4289: -----------------------------------------------
4290: -- Call the DELETE_ROW for each child record --
4291: -----------------------------------------------

Line 4297: l_okl_prtfl_lines_tl_rec

4293: p_init_msg_list,
4294: l_return_status,
4295: x_msg_count,
4296: x_msg_data,
4297: l_okl_prtfl_lines_tl_rec
4298: );
4299: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4300: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4301: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN