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_LPO_PVT dependencies on OKL_LATE_POLICIES_TL

Line 99: DELETE FROM OKL_LATE_POLICIES_TL T

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

Line 107: UPDATE OKL_LATE_POLICIES_TL T SET(

103: WHERE B.ID =T.ID
104: AND T.LANGUAGE = USERENV('LANG')
105: );
106:
107: UPDATE OKL_LATE_POLICIES_TL T SET(
108: --LANGUAGE,
109: NAME,
110: DESCRIPTION) = (SELECT
111: --B.LANGUAGE,

Line 114: FROM OKL_LATE_POLICIES_TL B

110: DESCRIPTION) = (SELECT
111: --B.LANGUAGE,
112: B.NAME,
113: B.DESCRIPTION
114: FROM OKL_LATE_POLICIES_TL B
115: WHERE B.ID = T.ID
116: and b.language = t.source_lang)
117: WHERE ( T.ID, t.language)
118: IN (SELECT

Line 121: FROM OKL_LATE_POLICIES_TL SUBB, OKL_LATE_POLICIES_TL SUBT

117: WHERE ( T.ID, t.language)
118: IN (SELECT
119: SUBT.ID
120: ,subt.language
121: FROM OKL_LATE_POLICIES_TL SUBB, OKL_LATE_POLICIES_TL SUBT
122: WHERE SUBB.ID = SUBT.ID
123: and subb.language = subt.language
124: AND (--SUBB.LANGUAGE <> SUBT.LANGUAGE OR
125: SUBB.NAME <> SUBT.NAME

Line 132: INSERT INTO OKL_LATE_POLICIES_TL (

128: OR (SUBB.NAME IS NOT NULL AND SUBT.NAME IS NULL)
129: OR (SUBB.DESCRIPTION IS NULL AND SUBT.DESCRIPTION IS NOT NULL)
130: ));
131:
132: INSERT INTO OKL_LATE_POLICIES_TL (
133: ID,
134: LANGUAGE,
135: SOURCE_LANG,
136: NAME,

Line 154: FROM OKL_LATE_POLICIES_TL B, FND_LANGUAGES L

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

Line 159: FROM OKL_LATE_POLICIES_TL T

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

Line 452: -- FUNCTION get_rec for: OKL_LATE_POLICIES_TL

448: BEGIN
449: RETURN(get_rec(p_lpo_rec, l_row_not_found));
450: END get_rec;
451: ---------------------------------------------------------------------------
452: -- FUNCTION get_rec for: OKL_LATE_POLICIES_TL
453: ---------------------------------------------------------------------------
454: FUNCTION get_rec (
455: p_okl_late_policies_tl_rec IN okl_late_policies_tl_rec_type,
456: x_no_data_found OUT NOCOPY BOOLEAN

Line 455: p_okl_late_policies_tl_rec IN okl_late_policies_tl_rec_type,

451: ---------------------------------------------------------------------------
452: -- FUNCTION get_rec for: OKL_LATE_POLICIES_TL
453: ---------------------------------------------------------------------------
454: FUNCTION get_rec (
455: p_okl_late_policies_tl_rec IN okl_late_policies_tl_rec_type,
456: x_no_data_found OUT NOCOPY BOOLEAN
457: ) RETURN okl_late_policies_tl_rec_type IS
458: CURSOR okl_late_policies_tl_pk_csr (p_id IN NUMBER) IS
459: SELECT

Line 457: ) RETURN okl_late_policies_tl_rec_type IS

453: ---------------------------------------------------------------------------
454: FUNCTION get_rec (
455: p_okl_late_policies_tl_rec IN okl_late_policies_tl_rec_type,
456: x_no_data_found OUT NOCOPY BOOLEAN
457: ) RETURN okl_late_policies_tl_rec_type IS
458: CURSOR okl_late_policies_tl_pk_csr (p_id IN NUMBER) IS
459: SELECT
460: ID,
461: LANGUAGE,

Line 458: CURSOR okl_late_policies_tl_pk_csr (p_id IN NUMBER) IS

454: FUNCTION get_rec (
455: p_okl_late_policies_tl_rec IN okl_late_policies_tl_rec_type,
456: x_no_data_found OUT NOCOPY BOOLEAN
457: ) RETURN okl_late_policies_tl_rec_type IS
458: CURSOR okl_late_policies_tl_pk_csr (p_id IN NUMBER) IS
459: SELECT
460: ID,
461: LANGUAGE,
462: SOURCE_LANG,

Line 470: FROM Okl_Late_Policies_Tl

466: CREATION_DATE,
467: LAST_UPDATED_BY,
468: LAST_UPDATE_DATE,
469: LAST_UPDATE_LOGIN
470: FROM Okl_Late_Policies_Tl
471: WHERE okl_late_policies_tl.id = p_id;
472: l_okl_late_policies_tl_pk okl_late_policies_tl_pk_csr%ROWTYPE;
473: l_okl_late_policies_tl_rec okl_late_policies_tl_rec_type;
474: BEGIN

Line 471: WHERE okl_late_policies_tl.id = p_id;

467: LAST_UPDATED_BY,
468: LAST_UPDATE_DATE,
469: LAST_UPDATE_LOGIN
470: FROM Okl_Late_Policies_Tl
471: WHERE okl_late_policies_tl.id = p_id;
472: l_okl_late_policies_tl_pk okl_late_policies_tl_pk_csr%ROWTYPE;
473: l_okl_late_policies_tl_rec okl_late_policies_tl_rec_type;
474: BEGIN
475: x_no_data_found := TRUE;

Line 472: l_okl_late_policies_tl_pk okl_late_policies_tl_pk_csr%ROWTYPE;

468: LAST_UPDATE_DATE,
469: LAST_UPDATE_LOGIN
470: FROM Okl_Late_Policies_Tl
471: WHERE okl_late_policies_tl.id = p_id;
472: l_okl_late_policies_tl_pk okl_late_policies_tl_pk_csr%ROWTYPE;
473: l_okl_late_policies_tl_rec okl_late_policies_tl_rec_type;
474: BEGIN
475: x_no_data_found := TRUE;
476: -- Get current database values

Line 473: l_okl_late_policies_tl_rec okl_late_policies_tl_rec_type;

469: LAST_UPDATE_LOGIN
470: FROM Okl_Late_Policies_Tl
471: WHERE okl_late_policies_tl.id = p_id;
472: l_okl_late_policies_tl_pk okl_late_policies_tl_pk_csr%ROWTYPE;
473: l_okl_late_policies_tl_rec okl_late_policies_tl_rec_type;
474: BEGIN
475: x_no_data_found := TRUE;
476: -- Get current database values
477: OPEN okl_late_policies_tl_pk_csr (p_okl_late_policies_tl_rec.id);

Line 477: OPEN okl_late_policies_tl_pk_csr (p_okl_late_policies_tl_rec.id);

473: l_okl_late_policies_tl_rec okl_late_policies_tl_rec_type;
474: BEGIN
475: x_no_data_found := TRUE;
476: -- Get current database values
477: OPEN okl_late_policies_tl_pk_csr (p_okl_late_policies_tl_rec.id);
478: FETCH okl_late_policies_tl_pk_csr INTO
479: l_okl_late_policies_tl_rec.id,
480: l_okl_late_policies_tl_rec.LANGUAGE,
481: l_okl_late_policies_tl_rec.source_lang,

Line 478: FETCH okl_late_policies_tl_pk_csr INTO

474: BEGIN
475: x_no_data_found := TRUE;
476: -- Get current database values
477: OPEN okl_late_policies_tl_pk_csr (p_okl_late_policies_tl_rec.id);
478: FETCH okl_late_policies_tl_pk_csr INTO
479: l_okl_late_policies_tl_rec.id,
480: l_okl_late_policies_tl_rec.LANGUAGE,
481: l_okl_late_policies_tl_rec.source_lang,
482: l_okl_late_policies_tl_rec.name,

Line 479: l_okl_late_policies_tl_rec.id,

475: x_no_data_found := TRUE;
476: -- Get current database values
477: OPEN okl_late_policies_tl_pk_csr (p_okl_late_policies_tl_rec.id);
478: FETCH okl_late_policies_tl_pk_csr INTO
479: l_okl_late_policies_tl_rec.id,
480: l_okl_late_policies_tl_rec.LANGUAGE,
481: l_okl_late_policies_tl_rec.source_lang,
482: l_okl_late_policies_tl_rec.name,
483: l_okl_late_policies_tl_rec.description,

Line 480: l_okl_late_policies_tl_rec.LANGUAGE,

476: -- Get current database values
477: OPEN okl_late_policies_tl_pk_csr (p_okl_late_policies_tl_rec.id);
478: FETCH okl_late_policies_tl_pk_csr INTO
479: l_okl_late_policies_tl_rec.id,
480: l_okl_late_policies_tl_rec.LANGUAGE,
481: l_okl_late_policies_tl_rec.source_lang,
482: l_okl_late_policies_tl_rec.name,
483: l_okl_late_policies_tl_rec.description,
484: l_okl_late_policies_tl_rec.created_by,

Line 481: l_okl_late_policies_tl_rec.source_lang,

477: OPEN okl_late_policies_tl_pk_csr (p_okl_late_policies_tl_rec.id);
478: FETCH okl_late_policies_tl_pk_csr INTO
479: l_okl_late_policies_tl_rec.id,
480: l_okl_late_policies_tl_rec.LANGUAGE,
481: l_okl_late_policies_tl_rec.source_lang,
482: l_okl_late_policies_tl_rec.name,
483: l_okl_late_policies_tl_rec.description,
484: l_okl_late_policies_tl_rec.created_by,
485: l_okl_late_policies_tl_rec.creation_date,

Line 482: l_okl_late_policies_tl_rec.name,

478: FETCH okl_late_policies_tl_pk_csr INTO
479: l_okl_late_policies_tl_rec.id,
480: l_okl_late_policies_tl_rec.LANGUAGE,
481: l_okl_late_policies_tl_rec.source_lang,
482: l_okl_late_policies_tl_rec.name,
483: l_okl_late_policies_tl_rec.description,
484: l_okl_late_policies_tl_rec.created_by,
485: l_okl_late_policies_tl_rec.creation_date,
486: l_okl_late_policies_tl_rec.last_updated_by,

Line 483: l_okl_late_policies_tl_rec.description,

479: l_okl_late_policies_tl_rec.id,
480: l_okl_late_policies_tl_rec.LANGUAGE,
481: l_okl_late_policies_tl_rec.source_lang,
482: l_okl_late_policies_tl_rec.name,
483: l_okl_late_policies_tl_rec.description,
484: l_okl_late_policies_tl_rec.created_by,
485: l_okl_late_policies_tl_rec.creation_date,
486: l_okl_late_policies_tl_rec.last_updated_by,
487: l_okl_late_policies_tl_rec.last_update_date,

Line 484: l_okl_late_policies_tl_rec.created_by,

480: l_okl_late_policies_tl_rec.LANGUAGE,
481: l_okl_late_policies_tl_rec.source_lang,
482: l_okl_late_policies_tl_rec.name,
483: l_okl_late_policies_tl_rec.description,
484: l_okl_late_policies_tl_rec.created_by,
485: l_okl_late_policies_tl_rec.creation_date,
486: l_okl_late_policies_tl_rec.last_updated_by,
487: l_okl_late_policies_tl_rec.last_update_date,
488: l_okl_late_policies_tl_rec.last_update_login;

Line 485: l_okl_late_policies_tl_rec.creation_date,

481: l_okl_late_policies_tl_rec.source_lang,
482: l_okl_late_policies_tl_rec.name,
483: l_okl_late_policies_tl_rec.description,
484: l_okl_late_policies_tl_rec.created_by,
485: l_okl_late_policies_tl_rec.creation_date,
486: l_okl_late_policies_tl_rec.last_updated_by,
487: l_okl_late_policies_tl_rec.last_update_date,
488: l_okl_late_policies_tl_rec.last_update_login;
489: x_no_data_found := okl_late_policies_tl_pk_csr%NOTFOUND;

Line 486: l_okl_late_policies_tl_rec.last_updated_by,

482: l_okl_late_policies_tl_rec.name,
483: l_okl_late_policies_tl_rec.description,
484: l_okl_late_policies_tl_rec.created_by,
485: l_okl_late_policies_tl_rec.creation_date,
486: l_okl_late_policies_tl_rec.last_updated_by,
487: l_okl_late_policies_tl_rec.last_update_date,
488: l_okl_late_policies_tl_rec.last_update_login;
489: x_no_data_found := okl_late_policies_tl_pk_csr%NOTFOUND;
490: CLOSE okl_late_policies_tl_pk_csr;

Line 487: l_okl_late_policies_tl_rec.last_update_date,

483: l_okl_late_policies_tl_rec.description,
484: l_okl_late_policies_tl_rec.created_by,
485: l_okl_late_policies_tl_rec.creation_date,
486: l_okl_late_policies_tl_rec.last_updated_by,
487: l_okl_late_policies_tl_rec.last_update_date,
488: l_okl_late_policies_tl_rec.last_update_login;
489: x_no_data_found := okl_late_policies_tl_pk_csr%NOTFOUND;
490: CLOSE okl_late_policies_tl_pk_csr;
491: RETURN(l_okl_late_policies_tl_rec);

Line 488: l_okl_late_policies_tl_rec.last_update_login;

484: l_okl_late_policies_tl_rec.created_by,
485: l_okl_late_policies_tl_rec.creation_date,
486: l_okl_late_policies_tl_rec.last_updated_by,
487: l_okl_late_policies_tl_rec.last_update_date,
488: l_okl_late_policies_tl_rec.last_update_login;
489: x_no_data_found := okl_late_policies_tl_pk_csr%NOTFOUND;
490: CLOSE okl_late_policies_tl_pk_csr;
491: RETURN(l_okl_late_policies_tl_rec);
492: END get_rec;

Line 489: x_no_data_found := okl_late_policies_tl_pk_csr%NOTFOUND;

485: l_okl_late_policies_tl_rec.creation_date,
486: l_okl_late_policies_tl_rec.last_updated_by,
487: l_okl_late_policies_tl_rec.last_update_date,
488: l_okl_late_policies_tl_rec.last_update_login;
489: x_no_data_found := okl_late_policies_tl_pk_csr%NOTFOUND;
490: CLOSE okl_late_policies_tl_pk_csr;
491: RETURN(l_okl_late_policies_tl_rec);
492: END get_rec;
493:

Line 490: CLOSE okl_late_policies_tl_pk_csr;

486: l_okl_late_policies_tl_rec.last_updated_by,
487: l_okl_late_policies_tl_rec.last_update_date,
488: l_okl_late_policies_tl_rec.last_update_login;
489: x_no_data_found := okl_late_policies_tl_pk_csr%NOTFOUND;
490: CLOSE okl_late_policies_tl_pk_csr;
491: RETURN(l_okl_late_policies_tl_rec);
492: END get_rec;
493:
494: ------------------------------------------------------------------

Line 491: RETURN(l_okl_late_policies_tl_rec);

487: l_okl_late_policies_tl_rec.last_update_date,
488: l_okl_late_policies_tl_rec.last_update_login;
489: x_no_data_found := okl_late_policies_tl_pk_csr%NOTFOUND;
490: CLOSE okl_late_policies_tl_pk_csr;
491: RETURN(l_okl_late_policies_tl_rec);
492: END get_rec;
493:
494: ------------------------------------------------------------------
495: -- This version of get_rec sets error messages if no data found --

Line 498: p_okl_late_policies_tl_rec IN okl_late_policies_tl_rec_type,

494: ------------------------------------------------------------------
495: -- This version of get_rec sets error messages if no data found --
496: ------------------------------------------------------------------
497: FUNCTION get_rec (
498: p_okl_late_policies_tl_rec IN okl_late_policies_tl_rec_type,
499: x_return_status OUT NOCOPY VARCHAR2
500: ) RETURN okl_late_policies_tl_rec_type IS
501: l_okl_late_policies_tl_rec okl_late_policies_tl_rec_type;
502: l_row_notfound BOOLEAN := TRUE;

Line 500: ) RETURN okl_late_policies_tl_rec_type IS

496: ------------------------------------------------------------------
497: FUNCTION get_rec (
498: p_okl_late_policies_tl_rec IN okl_late_policies_tl_rec_type,
499: x_return_status OUT NOCOPY VARCHAR2
500: ) RETURN okl_late_policies_tl_rec_type IS
501: l_okl_late_policies_tl_rec okl_late_policies_tl_rec_type;
502: l_row_notfound BOOLEAN := TRUE;
503: BEGIN
504: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

Line 501: l_okl_late_policies_tl_rec okl_late_policies_tl_rec_type;

497: FUNCTION get_rec (
498: p_okl_late_policies_tl_rec IN okl_late_policies_tl_rec_type,
499: x_return_status OUT NOCOPY VARCHAR2
500: ) RETURN okl_late_policies_tl_rec_type IS
501: l_okl_late_policies_tl_rec okl_late_policies_tl_rec_type;
502: l_row_notfound BOOLEAN := TRUE;
503: BEGIN
504: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
505: l_okl_late_policies_tl_rec := get_rec(p_okl_late_policies_tl_rec, l_row_notfound);

Line 505: l_okl_late_policies_tl_rec := get_rec(p_okl_late_policies_tl_rec, l_row_notfound);

501: l_okl_late_policies_tl_rec okl_late_policies_tl_rec_type;
502: l_row_notfound BOOLEAN := TRUE;
503: BEGIN
504: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
505: l_okl_late_policies_tl_rec := get_rec(p_okl_late_policies_tl_rec, l_row_notfound);
506: IF (l_row_notfound) THEN
507: Okc_Api.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
508: x_return_status := Okc_Api.G_RET_STS_ERROR;
509: END IF;

Line 510: RETURN(l_okl_late_policies_tl_rec);

506: IF (l_row_notfound) THEN
507: Okc_Api.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
508: x_return_status := Okc_Api.G_RET_STS_ERROR;
509: END IF;
510: RETURN(l_okl_late_policies_tl_rec);
511: END get_rec;
512: -----------------------------------------------------------
513: -- So we don't have to pass an "l_row_notfound" variable --
514: -----------------------------------------------------------

Line 516: p_okl_late_policies_tl_rec IN okl_late_policies_tl_rec_type

512: -----------------------------------------------------------
513: -- So we don't have to pass an "l_row_notfound" variable --
514: -----------------------------------------------------------
515: FUNCTION get_rec (
516: p_okl_late_policies_tl_rec IN okl_late_policies_tl_rec_type
517: ) RETURN okl_late_policies_tl_rec_type IS
518: l_row_not_found BOOLEAN := TRUE;
519: BEGIN
520: RETURN(get_rec(p_okl_late_policies_tl_rec, l_row_not_found));

Line 517: ) RETURN okl_late_policies_tl_rec_type IS

513: -- So we don't have to pass an "l_row_notfound" variable --
514: -----------------------------------------------------------
515: FUNCTION get_rec (
516: p_okl_late_policies_tl_rec IN okl_late_policies_tl_rec_type
517: ) RETURN okl_late_policies_tl_rec_type IS
518: l_row_not_found BOOLEAN := TRUE;
519: BEGIN
520: RETURN(get_rec(p_okl_late_policies_tl_rec, l_row_not_found));
521: END get_rec;

Line 520: RETURN(get_rec(p_okl_late_policies_tl_rec, l_row_not_found));

516: p_okl_late_policies_tl_rec IN okl_late_policies_tl_rec_type
517: ) RETURN okl_late_policies_tl_rec_type IS
518: l_row_not_found BOOLEAN := TRUE;
519: BEGIN
520: RETURN(get_rec(p_okl_late_policies_tl_rec, l_row_not_found));
521: END get_rec;
522: ---------------------------------------------------------------------------
523: -- FUNCTION null_out_defaults for: OKL_LATE_POLICIES_V
524: ---------------------------------------------------------------------------

Line 903: p_to IN OUT NOCOPY okl_late_policies_tl_rec_type

899: p_to.days_in_year := p_from.days_in_year;
900: END migrate;
901: PROCEDURE migrate (
902: p_from IN lpov_rec_type,
903: p_to IN OUT NOCOPY okl_late_policies_tl_rec_type
904: ) IS
905: BEGIN
906: p_to.id := p_from.id;
907: p_to.name := p_from.name;

Line 916: p_from IN okl_late_policies_tl_rec_type,

912: p_to.last_update_date := p_from.last_update_date;
913: p_to.last_update_login := p_from.last_update_login;
914: END migrate;
915: PROCEDURE migrate (
916: p_from IN okl_late_policies_tl_rec_type,
917: p_to IN OUT NOCOPY lpov_rec_type
918: ) IS
919: BEGIN
920: p_to.id := p_from.id;

Line 948: l_okl_late_policies_tl_rec okl_late_policies_tl_rec_type;

944: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
945: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
946: l_lpov_rec lpov_rec_type := p_lpov_rec;
947: l_lpo_rec lpo_rec_type;
948: l_okl_late_policies_tl_rec okl_late_policies_tl_rec_type;
949: BEGIN
950: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
951: G_PKG_NAME,
952: p_init_msg_list,

Line 1258: -- insert_row for:OKL_LATE_POLICIES_TL --

1254: '_PVT'
1255: );
1256: END insert_row;
1257: -----------------------------------------
1258: -- insert_row for:OKL_LATE_POLICIES_TL --
1259: -----------------------------------------
1260: PROCEDURE insert_row(
1261: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
1262: x_return_status OUT NOCOPY VARCHAR2,

Line 1265: p_okl_late_policies_tl_rec IN okl_late_policies_tl_rec_type,

1261: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
1262: x_return_status OUT NOCOPY VARCHAR2,
1263: x_msg_count OUT NOCOPY NUMBER,
1264: x_msg_data OUT NOCOPY VARCHAR2,
1265: p_okl_late_policies_tl_rec IN okl_late_policies_tl_rec_type,
1266: x_okl_late_policies_tl_rec OUT NOCOPY okl_late_policies_tl_rec_type) IS
1267:
1268: l_api_version CONSTANT NUMBER := 1;
1269: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';

Line 1266: x_okl_late_policies_tl_rec OUT NOCOPY okl_late_policies_tl_rec_type) IS

1262: x_return_status OUT NOCOPY VARCHAR2,
1263: x_msg_count OUT NOCOPY NUMBER,
1264: x_msg_data OUT NOCOPY VARCHAR2,
1265: p_okl_late_policies_tl_rec IN okl_late_policies_tl_rec_type,
1266: x_okl_late_policies_tl_rec OUT NOCOPY okl_late_policies_tl_rec_type) IS
1267:
1268: l_api_version CONSTANT NUMBER := 1;
1269: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1270: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

Line 1271: l_okl_late_policies_tl_rec okl_late_policies_tl_rec_type := p_okl_late_policies_tl_rec;

1267:
1268: l_api_version CONSTANT NUMBER := 1;
1269: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1270: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1271: l_okl_late_policies_tl_rec okl_late_policies_tl_rec_type := p_okl_late_policies_tl_rec;
1272: l_def_okl_late_policies_tl_rec okl_late_policies_tl_rec_type;
1273: CURSOR get_languages IS
1274: SELECT *
1275: FROM FND_LANGUAGES

Line 1272: l_def_okl_late_policies_tl_rec okl_late_policies_tl_rec_type;

1268: l_api_version CONSTANT NUMBER := 1;
1269: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1270: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1271: l_okl_late_policies_tl_rec okl_late_policies_tl_rec_type := p_okl_late_policies_tl_rec;
1272: l_def_okl_late_policies_tl_rec okl_late_policies_tl_rec_type;
1273: CURSOR get_languages IS
1274: SELECT *
1275: FROM FND_LANGUAGES
1276: WHERE INSTALLED_FLAG IN ('I', 'B');

Line 1278: -- Set_Attributes for:OKL_LATE_POLICIES_TL --

1274: SELECT *
1275: FROM FND_LANGUAGES
1276: WHERE INSTALLED_FLAG IN ('I', 'B');
1277: ---------------------------------------------
1278: -- Set_Attributes for:OKL_LATE_POLICIES_TL --
1279: ---------------------------------------------
1280: FUNCTION Set_Attributes (
1281: p_okl_late_policies_tl_rec IN okl_late_policies_tl_rec_type,
1282: x_okl_late_policies_tl_rec OUT NOCOPY okl_late_policies_tl_rec_type

Line 1281: p_okl_late_policies_tl_rec IN okl_late_policies_tl_rec_type,

1277: ---------------------------------------------
1278: -- Set_Attributes for:OKL_LATE_POLICIES_TL --
1279: ---------------------------------------------
1280: FUNCTION Set_Attributes (
1281: p_okl_late_policies_tl_rec IN okl_late_policies_tl_rec_type,
1282: x_okl_late_policies_tl_rec OUT NOCOPY okl_late_policies_tl_rec_type
1283: ) RETURN VARCHAR2 IS
1284: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1285: BEGIN

Line 1282: x_okl_late_policies_tl_rec OUT NOCOPY okl_late_policies_tl_rec_type

1278: -- Set_Attributes for:OKL_LATE_POLICIES_TL --
1279: ---------------------------------------------
1280: FUNCTION Set_Attributes (
1281: p_okl_late_policies_tl_rec IN okl_late_policies_tl_rec_type,
1282: x_okl_late_policies_tl_rec OUT NOCOPY okl_late_policies_tl_rec_type
1283: ) RETURN VARCHAR2 IS
1284: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1285: BEGIN
1286: x_okl_late_policies_tl_rec := p_okl_late_policies_tl_rec;

Line 1286: x_okl_late_policies_tl_rec := p_okl_late_policies_tl_rec;

1282: x_okl_late_policies_tl_rec OUT NOCOPY okl_late_policies_tl_rec_type
1283: ) RETURN VARCHAR2 IS
1284: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1285: BEGIN
1286: x_okl_late_policies_tl_rec := p_okl_late_policies_tl_rec;
1287: x_okl_late_policies_tl_rec.LANGUAGE := USERENV('LANG');
1288: x_okl_late_policies_tl_rec.SOURCE_LANG := USERENV('LANG');
1289: RETURN(l_return_status);
1290: END Set_Attributes;

Line 1287: x_okl_late_policies_tl_rec.LANGUAGE := USERENV('LANG');

1283: ) RETURN VARCHAR2 IS
1284: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1285: BEGIN
1286: x_okl_late_policies_tl_rec := p_okl_late_policies_tl_rec;
1287: x_okl_late_policies_tl_rec.LANGUAGE := USERENV('LANG');
1288: x_okl_late_policies_tl_rec.SOURCE_LANG := USERENV('LANG');
1289: RETURN(l_return_status);
1290: END Set_Attributes;
1291: BEGIN

Line 1288: x_okl_late_policies_tl_rec.SOURCE_LANG := USERENV('LANG');

1284: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1285: BEGIN
1286: x_okl_late_policies_tl_rec := p_okl_late_policies_tl_rec;
1287: x_okl_late_policies_tl_rec.LANGUAGE := USERENV('LANG');
1288: x_okl_late_policies_tl_rec.SOURCE_LANG := USERENV('LANG');
1289: RETURN(l_return_status);
1290: END Set_Attributes;
1291: BEGIN
1292: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

Line 1303: p_okl_late_policies_tl_rec, -- IN

1299: RAISE Okc_Api.G_EXCEPTION_ERROR;
1300: END IF;
1301: --- Setting item attributes
1302: l_return_status := Set_Attributes(
1303: p_okl_late_policies_tl_rec, -- IN
1304: l_okl_late_policies_tl_rec); -- OUT
1305: --- If any errors happen abort API
1306: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1307: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1304: l_okl_late_policies_tl_rec); -- OUT

1300: END IF;
1301: --- Setting item attributes
1302: l_return_status := Set_Attributes(
1303: p_okl_late_policies_tl_rec, -- IN
1304: l_okl_late_policies_tl_rec); -- OUT
1305: --- If any errors happen abort API
1306: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1307: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1308: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

Line 1312: l_okl_late_policies_tl_rec.LANGUAGE := l_lang_rec.language_code;

1308: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1309: RAISE Okc_Api.G_EXCEPTION_ERROR;
1310: END IF;
1311: FOR l_lang_rec IN get_languages LOOP
1312: l_okl_late_policies_tl_rec.LANGUAGE := l_lang_rec.language_code;
1313: INSERT INTO OKL_LATE_POLICIES_TL(
1314: id,
1315: LANGUAGE,
1316: source_lang,

Line 1313: INSERT INTO OKL_LATE_POLICIES_TL(

1309: RAISE Okc_Api.G_EXCEPTION_ERROR;
1310: END IF;
1311: FOR l_lang_rec IN get_languages LOOP
1312: l_okl_late_policies_tl_rec.LANGUAGE := l_lang_rec.language_code;
1313: INSERT INTO OKL_LATE_POLICIES_TL(
1314: id,
1315: LANGUAGE,
1316: source_lang,
1317: name,

Line 1325: l_okl_late_policies_tl_rec.id,

1321: last_updated_by,
1322: last_update_date,
1323: last_update_login)
1324: VALUES (
1325: l_okl_late_policies_tl_rec.id,
1326: l_okl_late_policies_tl_rec.LANGUAGE,
1327: l_okl_late_policies_tl_rec.source_lang,
1328: l_okl_late_policies_tl_rec.name,
1329: l_okl_late_policies_tl_rec.description,

Line 1326: l_okl_late_policies_tl_rec.LANGUAGE,

1322: last_update_date,
1323: last_update_login)
1324: VALUES (
1325: l_okl_late_policies_tl_rec.id,
1326: l_okl_late_policies_tl_rec.LANGUAGE,
1327: l_okl_late_policies_tl_rec.source_lang,
1328: l_okl_late_policies_tl_rec.name,
1329: l_okl_late_policies_tl_rec.description,
1330: l_okl_late_policies_tl_rec.created_by,

Line 1327: l_okl_late_policies_tl_rec.source_lang,

1323: last_update_login)
1324: VALUES (
1325: l_okl_late_policies_tl_rec.id,
1326: l_okl_late_policies_tl_rec.LANGUAGE,
1327: l_okl_late_policies_tl_rec.source_lang,
1328: l_okl_late_policies_tl_rec.name,
1329: l_okl_late_policies_tl_rec.description,
1330: l_okl_late_policies_tl_rec.created_by,
1331: l_okl_late_policies_tl_rec.creation_date,

Line 1328: l_okl_late_policies_tl_rec.name,

1324: VALUES (
1325: l_okl_late_policies_tl_rec.id,
1326: l_okl_late_policies_tl_rec.LANGUAGE,
1327: l_okl_late_policies_tl_rec.source_lang,
1328: l_okl_late_policies_tl_rec.name,
1329: l_okl_late_policies_tl_rec.description,
1330: l_okl_late_policies_tl_rec.created_by,
1331: l_okl_late_policies_tl_rec.creation_date,
1332: l_okl_late_policies_tl_rec.last_updated_by,

Line 1329: l_okl_late_policies_tl_rec.description,

1325: l_okl_late_policies_tl_rec.id,
1326: l_okl_late_policies_tl_rec.LANGUAGE,
1327: l_okl_late_policies_tl_rec.source_lang,
1328: l_okl_late_policies_tl_rec.name,
1329: l_okl_late_policies_tl_rec.description,
1330: l_okl_late_policies_tl_rec.created_by,
1331: l_okl_late_policies_tl_rec.creation_date,
1332: l_okl_late_policies_tl_rec.last_updated_by,
1333: l_okl_late_policies_tl_rec.last_update_date,

Line 1330: l_okl_late_policies_tl_rec.created_by,

1326: l_okl_late_policies_tl_rec.LANGUAGE,
1327: l_okl_late_policies_tl_rec.source_lang,
1328: l_okl_late_policies_tl_rec.name,
1329: l_okl_late_policies_tl_rec.description,
1330: l_okl_late_policies_tl_rec.created_by,
1331: l_okl_late_policies_tl_rec.creation_date,
1332: l_okl_late_policies_tl_rec.last_updated_by,
1333: l_okl_late_policies_tl_rec.last_update_date,
1334: l_okl_late_policies_tl_rec.last_update_login);

Line 1331: l_okl_late_policies_tl_rec.creation_date,

1327: l_okl_late_policies_tl_rec.source_lang,
1328: l_okl_late_policies_tl_rec.name,
1329: l_okl_late_policies_tl_rec.description,
1330: l_okl_late_policies_tl_rec.created_by,
1331: l_okl_late_policies_tl_rec.creation_date,
1332: l_okl_late_policies_tl_rec.last_updated_by,
1333: l_okl_late_policies_tl_rec.last_update_date,
1334: l_okl_late_policies_tl_rec.last_update_login);
1335: END LOOP;

Line 1332: l_okl_late_policies_tl_rec.last_updated_by,

1328: l_okl_late_policies_tl_rec.name,
1329: l_okl_late_policies_tl_rec.description,
1330: l_okl_late_policies_tl_rec.created_by,
1331: l_okl_late_policies_tl_rec.creation_date,
1332: l_okl_late_policies_tl_rec.last_updated_by,
1333: l_okl_late_policies_tl_rec.last_update_date,
1334: l_okl_late_policies_tl_rec.last_update_login);
1335: END LOOP;
1336: -- Set OUT values

Line 1333: l_okl_late_policies_tl_rec.last_update_date,

1329: l_okl_late_policies_tl_rec.description,
1330: l_okl_late_policies_tl_rec.created_by,
1331: l_okl_late_policies_tl_rec.creation_date,
1332: l_okl_late_policies_tl_rec.last_updated_by,
1333: l_okl_late_policies_tl_rec.last_update_date,
1334: l_okl_late_policies_tl_rec.last_update_login);
1335: END LOOP;
1336: -- Set OUT values
1337: x_okl_late_policies_tl_rec := l_okl_late_policies_tl_rec;

Line 1334: l_okl_late_policies_tl_rec.last_update_login);

1330: l_okl_late_policies_tl_rec.created_by,
1331: l_okl_late_policies_tl_rec.creation_date,
1332: l_okl_late_policies_tl_rec.last_updated_by,
1333: l_okl_late_policies_tl_rec.last_update_date,
1334: l_okl_late_policies_tl_rec.last_update_login);
1335: END LOOP;
1336: -- Set OUT values
1337: x_okl_late_policies_tl_rec := l_okl_late_policies_tl_rec;
1338: x_return_status := l_return_status;

Line 1337: x_okl_late_policies_tl_rec := l_okl_late_policies_tl_rec;

1333: l_okl_late_policies_tl_rec.last_update_date,
1334: l_okl_late_policies_tl_rec.last_update_login);
1335: END LOOP;
1336: -- Set OUT values
1337: x_okl_late_policies_tl_rec := l_okl_late_policies_tl_rec;
1338: x_return_status := l_return_status;
1339: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1340: EXCEPTION
1341: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

Line 1391: l_okl_late_policies_tl_rec okl_late_policies_tl_rec_type;

1387: l_lpov_rec lpov_rec_type := p_lpov_rec;
1388: l_def_lpov_rec lpov_rec_type;
1389: l_lpo_rec lpo_rec_type;
1390: lx_lpo_rec lpo_rec_type;
1391: l_okl_late_policies_tl_rec okl_late_policies_tl_rec_type;
1392: lx_okl_late_policies_tl_rec okl_late_policies_tl_rec_type;
1393: -------------------------------
1394: -- FUNCTION fill_who_columns --
1395: -------------------------------

Line 1392: lx_okl_late_policies_tl_rec okl_late_policies_tl_rec_type;

1388: l_def_lpov_rec lpov_rec_type;
1389: l_lpo_rec lpo_rec_type;
1390: lx_lpo_rec lpo_rec_type;
1391: l_okl_late_policies_tl_rec okl_late_policies_tl_rec_type;
1392: lx_okl_late_policies_tl_rec okl_late_policies_tl_rec_type;
1393: -------------------------------
1394: -- FUNCTION fill_who_columns --
1395: -------------------------------
1396: FUNCTION fill_who_columns (

Line 1466: migrate(l_def_lpov_rec, l_okl_late_policies_tl_rec);

1462: -----------------------------------------
1463: -- Move VIEW record to "Child" records --
1464: -----------------------------------------
1465: migrate(l_def_lpov_rec, l_lpo_rec);
1466: migrate(l_def_lpov_rec, l_okl_late_policies_tl_rec);
1467: -----------------------------------------------
1468: -- Call the INSERT_ROW for each child record --
1469: -----------------------------------------------
1470: insert_row(

Line 1489: l_okl_late_policies_tl_rec,

1485: p_init_msg_list,
1486: l_return_status,
1487: x_msg_count,
1488: x_msg_data,
1489: l_okl_late_policies_tl_rec,
1490: lx_okl_late_policies_tl_rec
1491: );
1492: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1493: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1490: lx_okl_late_policies_tl_rec

1486: l_return_status,
1487: x_msg_count,
1488: x_msg_data,
1489: l_okl_late_policies_tl_rec,
1490: lx_okl_late_policies_tl_rec
1491: );
1492: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1493: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1494: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

Line 1497: migrate(lx_okl_late_policies_tl_rec, l_def_lpov_rec);

1493: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1494: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1495: RAISE Okc_Api.G_EXCEPTION_ERROR;
1496: END IF;
1497: migrate(lx_okl_late_policies_tl_rec, l_def_lpov_rec);
1498: -- Set OUT values
1499: x_lpov_rec := l_def_lpov_rec;
1500: x_return_status := l_return_status;
1501: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1713: -- lock_row for:OKL_LATE_POLICIES_TL --

1709: '_PVT'
1710: );
1711: END lock_row;
1712: ---------------------------------------
1713: -- lock_row for:OKL_LATE_POLICIES_TL --
1714: ---------------------------------------
1715: PROCEDURE lock_row(
1716: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
1717: x_return_status OUT NOCOPY VARCHAR2,

Line 1720: p_okl_late_policies_tl_rec IN okl_late_policies_tl_rec_type) IS

1716: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
1717: x_return_status OUT NOCOPY VARCHAR2,
1718: x_msg_count OUT NOCOPY NUMBER,
1719: x_msg_data OUT NOCOPY VARCHAR2,
1720: p_okl_late_policies_tl_rec IN okl_late_policies_tl_rec_type) IS
1721:
1722: E_Resource_Busy EXCEPTION;
1723: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1724: CURSOR lock_csr (p_okl_late_policies_tl_rec IN okl_late_policies_tl_rec_type) IS

Line 1724: CURSOR lock_csr (p_okl_late_policies_tl_rec IN okl_late_policies_tl_rec_type) IS

1720: p_okl_late_policies_tl_rec IN okl_late_policies_tl_rec_type) IS
1721:
1722: E_Resource_Busy EXCEPTION;
1723: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1724: CURSOR lock_csr (p_okl_late_policies_tl_rec IN okl_late_policies_tl_rec_type) IS
1725: SELECT *
1726: FROM OKL_LATE_POLICIES_TL
1727: WHERE ID = p_okl_late_policies_tl_rec.id
1728: FOR UPDATE NOWAIT;

Line 1726: FROM OKL_LATE_POLICIES_TL

1722: E_Resource_Busy EXCEPTION;
1723: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1724: CURSOR lock_csr (p_okl_late_policies_tl_rec IN okl_late_policies_tl_rec_type) IS
1725: SELECT *
1726: FROM OKL_LATE_POLICIES_TL
1727: WHERE ID = p_okl_late_policies_tl_rec.id
1728: FOR UPDATE NOWAIT;
1729:
1730: l_api_version CONSTANT NUMBER := 1;

Line 1727: WHERE ID = p_okl_late_policies_tl_rec.id

1723: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1724: CURSOR lock_csr (p_okl_late_policies_tl_rec IN okl_late_policies_tl_rec_type) IS
1725: SELECT *
1726: FROM OKL_LATE_POLICIES_TL
1727: WHERE ID = p_okl_late_policies_tl_rec.id
1728: FOR UPDATE NOWAIT;
1729:
1730: l_api_version CONSTANT NUMBER := 1;
1731: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';

Line 1747: OPEN lock_csr(p_okl_late_policies_tl_rec);

1743: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1744: RAISE Okc_Api.G_EXCEPTION_ERROR;
1745: END IF;
1746: BEGIN
1747: OPEN lock_csr(p_okl_late_policies_tl_rec);
1748: FETCH lock_csr INTO l_lock_var;
1749: l_row_notfound := lock_csr%NOTFOUND;
1750: CLOSE lock_csr;
1751: EXCEPTION

Line 1813: l_okl_late_policies_tl_rec okl_late_policies_tl_rec_type;

1809: l_api_version CONSTANT NUMBER := 1;
1810: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1811: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1812: l_lpo_rec lpo_rec_type;
1813: l_okl_late_policies_tl_rec okl_late_policies_tl_rec_type;
1814: BEGIN
1815: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
1816: G_PKG_NAME,
1817: p_init_msg_list,

Line 1831: migrate(p_lpov_rec, l_okl_late_policies_tl_rec);

1827: -----------------------------------------
1828: -- Move VIEW record to "Child" records --
1829: -----------------------------------------
1830: migrate(p_lpov_rec, l_lpo_rec);
1831: migrate(p_lpov_rec, l_okl_late_policies_tl_rec);
1832: ---------------------------------------------
1833: -- Call the LOCK_ROW for each child record --
1834: ---------------------------------------------
1835: lock_row(

Line 1852: l_okl_late_policies_tl_rec

1848: p_init_msg_list,
1849: l_return_status,
1850: x_msg_count,
1851: x_msg_data,
1852: l_okl_late_policies_tl_rec
1853: );
1854: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1855: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1856: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

Line 2298: -- update_row for:OKL_LATE_POLICIES_TL --

2294: '_PVT'
2295: );
2296: END update_row;
2297: -----------------------------------------
2298: -- update_row for:OKL_LATE_POLICIES_TL --
2299: -----------------------------------------
2300: PROCEDURE update_row(
2301: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
2302: x_return_status OUT NOCOPY VARCHAR2,

Line 2305: p_okl_late_policies_tl_rec IN okl_late_policies_tl_rec_type,

2301: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
2302: x_return_status OUT NOCOPY VARCHAR2,
2303: x_msg_count OUT NOCOPY NUMBER,
2304: x_msg_data OUT NOCOPY VARCHAR2,
2305: p_okl_late_policies_tl_rec IN okl_late_policies_tl_rec_type,
2306: x_okl_late_policies_tl_rec OUT NOCOPY okl_late_policies_tl_rec_type) IS
2307:
2308: l_api_version CONSTANT NUMBER := 1;
2309: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';

Line 2306: x_okl_late_policies_tl_rec OUT NOCOPY okl_late_policies_tl_rec_type) IS

2302: x_return_status OUT NOCOPY VARCHAR2,
2303: x_msg_count OUT NOCOPY NUMBER,
2304: x_msg_data OUT NOCOPY VARCHAR2,
2305: p_okl_late_policies_tl_rec IN okl_late_policies_tl_rec_type,
2306: x_okl_late_policies_tl_rec OUT NOCOPY okl_late_policies_tl_rec_type) IS
2307:
2308: l_api_version CONSTANT NUMBER := 1;
2309: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2310: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

Line 2311: l_okl_late_policies_tl_rec okl_late_policies_tl_rec_type := p_okl_late_policies_tl_rec;

2307:
2308: l_api_version CONSTANT NUMBER := 1;
2309: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2310: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2311: l_okl_late_policies_tl_rec okl_late_policies_tl_rec_type := p_okl_late_policies_tl_rec;
2312: l_def_okl_late_policies_tl_rec okl_late_policies_tl_rec_type;
2313: l_row_notfound BOOLEAN := TRUE;
2314: ----------------------------------
2315: -- FUNCTION populate_new_record --

Line 2312: l_def_okl_late_policies_tl_rec okl_late_policies_tl_rec_type;

2308: l_api_version CONSTANT NUMBER := 1;
2309: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2310: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2311: l_okl_late_policies_tl_rec okl_late_policies_tl_rec_type := p_okl_late_policies_tl_rec;
2312: l_def_okl_late_policies_tl_rec okl_late_policies_tl_rec_type;
2313: l_row_notfound BOOLEAN := TRUE;
2314: ----------------------------------
2315: -- FUNCTION populate_new_record --
2316: ----------------------------------

Line 2318: p_okl_late_policies_tl_rec IN okl_late_policies_tl_rec_type,

2314: ----------------------------------
2315: -- FUNCTION populate_new_record --
2316: ----------------------------------
2317: FUNCTION populate_new_record (
2318: p_okl_late_policies_tl_rec IN okl_late_policies_tl_rec_type,
2319: x_okl_late_policies_tl_rec OUT NOCOPY okl_late_policies_tl_rec_type
2320: ) RETURN VARCHAR2 IS
2321: l_okl_late_policies_tl_rec okl_late_policies_tl_rec_type;
2322: l_row_notfound BOOLEAN := TRUE;

Line 2319: x_okl_late_policies_tl_rec OUT NOCOPY okl_late_policies_tl_rec_type

2315: -- FUNCTION populate_new_record --
2316: ----------------------------------
2317: FUNCTION populate_new_record (
2318: p_okl_late_policies_tl_rec IN okl_late_policies_tl_rec_type,
2319: x_okl_late_policies_tl_rec OUT NOCOPY okl_late_policies_tl_rec_type
2320: ) RETURN VARCHAR2 IS
2321: l_okl_late_policies_tl_rec okl_late_policies_tl_rec_type;
2322: l_row_notfound BOOLEAN := TRUE;
2323: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

Line 2321: l_okl_late_policies_tl_rec okl_late_policies_tl_rec_type;

2317: FUNCTION populate_new_record (
2318: p_okl_late_policies_tl_rec IN okl_late_policies_tl_rec_type,
2319: x_okl_late_policies_tl_rec OUT NOCOPY okl_late_policies_tl_rec_type
2320: ) RETURN VARCHAR2 IS
2321: l_okl_late_policies_tl_rec okl_late_policies_tl_rec_type;
2322: l_row_notfound BOOLEAN := TRUE;
2323: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2324: BEGIN
2325: x_okl_late_policies_tl_rec := p_okl_late_policies_tl_rec;

Line 2325: x_okl_late_policies_tl_rec := p_okl_late_policies_tl_rec;

2321: l_okl_late_policies_tl_rec okl_late_policies_tl_rec_type;
2322: l_row_notfound BOOLEAN := TRUE;
2323: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2324: BEGIN
2325: x_okl_late_policies_tl_rec := p_okl_late_policies_tl_rec;
2326: -- Get current database values
2327: l_okl_late_policies_tl_rec := get_rec(p_okl_late_policies_tl_rec, l_return_status);
2328: IF (l_return_status = Okc_Api.G_RET_STS_SUCCESS) THEN
2329: IF (x_okl_late_policies_tl_rec.id = Okc_Api.G_MISS_NUM)

Line 2327: l_okl_late_policies_tl_rec := get_rec(p_okl_late_policies_tl_rec, l_return_status);

2323: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2324: BEGIN
2325: x_okl_late_policies_tl_rec := p_okl_late_policies_tl_rec;
2326: -- Get current database values
2327: l_okl_late_policies_tl_rec := get_rec(p_okl_late_policies_tl_rec, l_return_status);
2328: IF (l_return_status = Okc_Api.G_RET_STS_SUCCESS) THEN
2329: IF (x_okl_late_policies_tl_rec.id = Okc_Api.G_MISS_NUM)
2330: THEN
2331: x_okl_late_policies_tl_rec.id := l_okl_late_policies_tl_rec.id;

Line 2329: IF (x_okl_late_policies_tl_rec.id = Okc_Api.G_MISS_NUM)

2325: x_okl_late_policies_tl_rec := p_okl_late_policies_tl_rec;
2326: -- Get current database values
2327: l_okl_late_policies_tl_rec := get_rec(p_okl_late_policies_tl_rec, l_return_status);
2328: IF (l_return_status = Okc_Api.G_RET_STS_SUCCESS) THEN
2329: IF (x_okl_late_policies_tl_rec.id = Okc_Api.G_MISS_NUM)
2330: THEN
2331: x_okl_late_policies_tl_rec.id := l_okl_late_policies_tl_rec.id;
2332: END IF;
2333: IF (x_okl_late_policies_tl_rec.LANGUAGE = Okc_Api.G_MISS_CHAR)

Line 2331: x_okl_late_policies_tl_rec.id := l_okl_late_policies_tl_rec.id;

2327: l_okl_late_policies_tl_rec := get_rec(p_okl_late_policies_tl_rec, l_return_status);
2328: IF (l_return_status = Okc_Api.G_RET_STS_SUCCESS) THEN
2329: IF (x_okl_late_policies_tl_rec.id = Okc_Api.G_MISS_NUM)
2330: THEN
2331: x_okl_late_policies_tl_rec.id := l_okl_late_policies_tl_rec.id;
2332: END IF;
2333: IF (x_okl_late_policies_tl_rec.LANGUAGE = Okc_Api.G_MISS_CHAR)
2334: THEN
2335: x_okl_late_policies_tl_rec.LANGUAGE := l_okl_late_policies_tl_rec.LANGUAGE;

Line 2333: IF (x_okl_late_policies_tl_rec.LANGUAGE = Okc_Api.G_MISS_CHAR)

2329: IF (x_okl_late_policies_tl_rec.id = Okc_Api.G_MISS_NUM)
2330: THEN
2331: x_okl_late_policies_tl_rec.id := l_okl_late_policies_tl_rec.id;
2332: END IF;
2333: IF (x_okl_late_policies_tl_rec.LANGUAGE = Okc_Api.G_MISS_CHAR)
2334: THEN
2335: x_okl_late_policies_tl_rec.LANGUAGE := l_okl_late_policies_tl_rec.LANGUAGE;
2336: END IF;
2337: IF (x_okl_late_policies_tl_rec.source_lang = Okc_Api.G_MISS_CHAR)

Line 2335: x_okl_late_policies_tl_rec.LANGUAGE := l_okl_late_policies_tl_rec.LANGUAGE;

2331: x_okl_late_policies_tl_rec.id := l_okl_late_policies_tl_rec.id;
2332: END IF;
2333: IF (x_okl_late_policies_tl_rec.LANGUAGE = Okc_Api.G_MISS_CHAR)
2334: THEN
2335: x_okl_late_policies_tl_rec.LANGUAGE := l_okl_late_policies_tl_rec.LANGUAGE;
2336: END IF;
2337: IF (x_okl_late_policies_tl_rec.source_lang = Okc_Api.G_MISS_CHAR)
2338: THEN
2339: x_okl_late_policies_tl_rec.source_lang := l_okl_late_policies_tl_rec.source_lang;

Line 2337: IF (x_okl_late_policies_tl_rec.source_lang = Okc_Api.G_MISS_CHAR)

2333: IF (x_okl_late_policies_tl_rec.LANGUAGE = Okc_Api.G_MISS_CHAR)
2334: THEN
2335: x_okl_late_policies_tl_rec.LANGUAGE := l_okl_late_policies_tl_rec.LANGUAGE;
2336: END IF;
2337: IF (x_okl_late_policies_tl_rec.source_lang = Okc_Api.G_MISS_CHAR)
2338: THEN
2339: x_okl_late_policies_tl_rec.source_lang := l_okl_late_policies_tl_rec.source_lang;
2340: END IF;
2341: IF (x_okl_late_policies_tl_rec.name = Okc_Api.G_MISS_CHAR)

Line 2339: x_okl_late_policies_tl_rec.source_lang := l_okl_late_policies_tl_rec.source_lang;

2335: x_okl_late_policies_tl_rec.LANGUAGE := l_okl_late_policies_tl_rec.LANGUAGE;
2336: END IF;
2337: IF (x_okl_late_policies_tl_rec.source_lang = Okc_Api.G_MISS_CHAR)
2338: THEN
2339: x_okl_late_policies_tl_rec.source_lang := l_okl_late_policies_tl_rec.source_lang;
2340: END IF;
2341: IF (x_okl_late_policies_tl_rec.name = Okc_Api.G_MISS_CHAR)
2342: THEN
2343: x_okl_late_policies_tl_rec.name := l_okl_late_policies_tl_rec.name;

Line 2341: IF (x_okl_late_policies_tl_rec.name = Okc_Api.G_MISS_CHAR)

2337: IF (x_okl_late_policies_tl_rec.source_lang = Okc_Api.G_MISS_CHAR)
2338: THEN
2339: x_okl_late_policies_tl_rec.source_lang := l_okl_late_policies_tl_rec.source_lang;
2340: END IF;
2341: IF (x_okl_late_policies_tl_rec.name = Okc_Api.G_MISS_CHAR)
2342: THEN
2343: x_okl_late_policies_tl_rec.name := l_okl_late_policies_tl_rec.name;
2344: END IF;
2345: IF (x_okl_late_policies_tl_rec.description = Okc_Api.G_MISS_CHAR)

Line 2343: x_okl_late_policies_tl_rec.name := l_okl_late_policies_tl_rec.name;

2339: x_okl_late_policies_tl_rec.source_lang := l_okl_late_policies_tl_rec.source_lang;
2340: END IF;
2341: IF (x_okl_late_policies_tl_rec.name = Okc_Api.G_MISS_CHAR)
2342: THEN
2343: x_okl_late_policies_tl_rec.name := l_okl_late_policies_tl_rec.name;
2344: END IF;
2345: IF (x_okl_late_policies_tl_rec.description = Okc_Api.G_MISS_CHAR)
2346: THEN
2347: x_okl_late_policies_tl_rec.description := l_okl_late_policies_tl_rec.description;

Line 2345: IF (x_okl_late_policies_tl_rec.description = Okc_Api.G_MISS_CHAR)

2341: IF (x_okl_late_policies_tl_rec.name = Okc_Api.G_MISS_CHAR)
2342: THEN
2343: x_okl_late_policies_tl_rec.name := l_okl_late_policies_tl_rec.name;
2344: END IF;
2345: IF (x_okl_late_policies_tl_rec.description = Okc_Api.G_MISS_CHAR)
2346: THEN
2347: x_okl_late_policies_tl_rec.description := l_okl_late_policies_tl_rec.description;
2348: END IF;
2349: IF (x_okl_late_policies_tl_rec.created_by = Okc_Api.G_MISS_NUM)

Line 2347: x_okl_late_policies_tl_rec.description := l_okl_late_policies_tl_rec.description;

2343: x_okl_late_policies_tl_rec.name := l_okl_late_policies_tl_rec.name;
2344: END IF;
2345: IF (x_okl_late_policies_tl_rec.description = Okc_Api.G_MISS_CHAR)
2346: THEN
2347: x_okl_late_policies_tl_rec.description := l_okl_late_policies_tl_rec.description;
2348: END IF;
2349: IF (x_okl_late_policies_tl_rec.created_by = Okc_Api.G_MISS_NUM)
2350: THEN
2351: x_okl_late_policies_tl_rec.created_by := l_okl_late_policies_tl_rec.created_by;

Line 2349: IF (x_okl_late_policies_tl_rec.created_by = Okc_Api.G_MISS_NUM)

2345: IF (x_okl_late_policies_tl_rec.description = Okc_Api.G_MISS_CHAR)
2346: THEN
2347: x_okl_late_policies_tl_rec.description := l_okl_late_policies_tl_rec.description;
2348: END IF;
2349: IF (x_okl_late_policies_tl_rec.created_by = Okc_Api.G_MISS_NUM)
2350: THEN
2351: x_okl_late_policies_tl_rec.created_by := l_okl_late_policies_tl_rec.created_by;
2352: END IF;
2353: IF (x_okl_late_policies_tl_rec.creation_date = Okc_Api.G_MISS_DATE)

Line 2351: x_okl_late_policies_tl_rec.created_by := l_okl_late_policies_tl_rec.created_by;

2347: x_okl_late_policies_tl_rec.description := l_okl_late_policies_tl_rec.description;
2348: END IF;
2349: IF (x_okl_late_policies_tl_rec.created_by = Okc_Api.G_MISS_NUM)
2350: THEN
2351: x_okl_late_policies_tl_rec.created_by := l_okl_late_policies_tl_rec.created_by;
2352: END IF;
2353: IF (x_okl_late_policies_tl_rec.creation_date = Okc_Api.G_MISS_DATE)
2354: THEN
2355: x_okl_late_policies_tl_rec.creation_date := l_okl_late_policies_tl_rec.creation_date;

Line 2353: IF (x_okl_late_policies_tl_rec.creation_date = Okc_Api.G_MISS_DATE)

2349: IF (x_okl_late_policies_tl_rec.created_by = Okc_Api.G_MISS_NUM)
2350: THEN
2351: x_okl_late_policies_tl_rec.created_by := l_okl_late_policies_tl_rec.created_by;
2352: END IF;
2353: IF (x_okl_late_policies_tl_rec.creation_date = Okc_Api.G_MISS_DATE)
2354: THEN
2355: x_okl_late_policies_tl_rec.creation_date := l_okl_late_policies_tl_rec.creation_date;
2356: END IF;
2357: IF (x_okl_late_policies_tl_rec.last_updated_by = Okc_Api.G_MISS_NUM)

Line 2355: x_okl_late_policies_tl_rec.creation_date := l_okl_late_policies_tl_rec.creation_date;

2351: x_okl_late_policies_tl_rec.created_by := l_okl_late_policies_tl_rec.created_by;
2352: END IF;
2353: IF (x_okl_late_policies_tl_rec.creation_date = Okc_Api.G_MISS_DATE)
2354: THEN
2355: x_okl_late_policies_tl_rec.creation_date := l_okl_late_policies_tl_rec.creation_date;
2356: END IF;
2357: IF (x_okl_late_policies_tl_rec.last_updated_by = Okc_Api.G_MISS_NUM)
2358: THEN
2359: x_okl_late_policies_tl_rec.last_updated_by := l_okl_late_policies_tl_rec.last_updated_by;

Line 2357: IF (x_okl_late_policies_tl_rec.last_updated_by = Okc_Api.G_MISS_NUM)

2353: IF (x_okl_late_policies_tl_rec.creation_date = Okc_Api.G_MISS_DATE)
2354: THEN
2355: x_okl_late_policies_tl_rec.creation_date := l_okl_late_policies_tl_rec.creation_date;
2356: END IF;
2357: IF (x_okl_late_policies_tl_rec.last_updated_by = Okc_Api.G_MISS_NUM)
2358: THEN
2359: x_okl_late_policies_tl_rec.last_updated_by := l_okl_late_policies_tl_rec.last_updated_by;
2360: END IF;
2361: IF (x_okl_late_policies_tl_rec.last_update_date = Okc_Api.G_MISS_DATE)

Line 2359: x_okl_late_policies_tl_rec.last_updated_by := l_okl_late_policies_tl_rec.last_updated_by;

2355: x_okl_late_policies_tl_rec.creation_date := l_okl_late_policies_tl_rec.creation_date;
2356: END IF;
2357: IF (x_okl_late_policies_tl_rec.last_updated_by = Okc_Api.G_MISS_NUM)
2358: THEN
2359: x_okl_late_policies_tl_rec.last_updated_by := l_okl_late_policies_tl_rec.last_updated_by;
2360: END IF;
2361: IF (x_okl_late_policies_tl_rec.last_update_date = Okc_Api.G_MISS_DATE)
2362: THEN
2363: x_okl_late_policies_tl_rec.last_update_date := l_okl_late_policies_tl_rec.last_update_date;

Line 2361: IF (x_okl_late_policies_tl_rec.last_update_date = Okc_Api.G_MISS_DATE)

2357: IF (x_okl_late_policies_tl_rec.last_updated_by = Okc_Api.G_MISS_NUM)
2358: THEN
2359: x_okl_late_policies_tl_rec.last_updated_by := l_okl_late_policies_tl_rec.last_updated_by;
2360: END IF;
2361: IF (x_okl_late_policies_tl_rec.last_update_date = Okc_Api.G_MISS_DATE)
2362: THEN
2363: x_okl_late_policies_tl_rec.last_update_date := l_okl_late_policies_tl_rec.last_update_date;
2364: END IF;
2365: IF (x_okl_late_policies_tl_rec.last_update_login = Okc_Api.G_MISS_NUM)

Line 2363: x_okl_late_policies_tl_rec.last_update_date := l_okl_late_policies_tl_rec.last_update_date;

2359: x_okl_late_policies_tl_rec.last_updated_by := l_okl_late_policies_tl_rec.last_updated_by;
2360: END IF;
2361: IF (x_okl_late_policies_tl_rec.last_update_date = Okc_Api.G_MISS_DATE)
2362: THEN
2363: x_okl_late_policies_tl_rec.last_update_date := l_okl_late_policies_tl_rec.last_update_date;
2364: END IF;
2365: IF (x_okl_late_policies_tl_rec.last_update_login = Okc_Api.G_MISS_NUM)
2366: THEN
2367: x_okl_late_policies_tl_rec.last_update_login := l_okl_late_policies_tl_rec.last_update_login;

Line 2365: IF (x_okl_late_policies_tl_rec.last_update_login = Okc_Api.G_MISS_NUM)

2361: IF (x_okl_late_policies_tl_rec.last_update_date = Okc_Api.G_MISS_DATE)
2362: THEN
2363: x_okl_late_policies_tl_rec.last_update_date := l_okl_late_policies_tl_rec.last_update_date;
2364: END IF;
2365: IF (x_okl_late_policies_tl_rec.last_update_login = Okc_Api.G_MISS_NUM)
2366: THEN
2367: x_okl_late_policies_tl_rec.last_update_login := l_okl_late_policies_tl_rec.last_update_login;
2368: END IF;
2369: END IF;

Line 2367: x_okl_late_policies_tl_rec.last_update_login := l_okl_late_policies_tl_rec.last_update_login;

2363: x_okl_late_policies_tl_rec.last_update_date := l_okl_late_policies_tl_rec.last_update_date;
2364: END IF;
2365: IF (x_okl_late_policies_tl_rec.last_update_login = Okc_Api.G_MISS_NUM)
2366: THEN
2367: x_okl_late_policies_tl_rec.last_update_login := l_okl_late_policies_tl_rec.last_update_login;
2368: END IF;
2369: END IF;
2370: RETURN(l_return_status);
2371: END populate_new_record;

Line 2373: -- Set_Attributes for:OKL_LATE_POLICIES_TL --

2369: END IF;
2370: RETURN(l_return_status);
2371: END populate_new_record;
2372: ---------------------------------------------
2373: -- Set_Attributes for:OKL_LATE_POLICIES_TL --
2374: ---------------------------------------------
2375: FUNCTION Set_Attributes (
2376: p_okl_late_policies_tl_rec IN okl_late_policies_tl_rec_type,
2377: x_okl_late_policies_tl_rec OUT NOCOPY okl_late_policies_tl_rec_type

Line 2376: p_okl_late_policies_tl_rec IN okl_late_policies_tl_rec_type,

2372: ---------------------------------------------
2373: -- Set_Attributes for:OKL_LATE_POLICIES_TL --
2374: ---------------------------------------------
2375: FUNCTION Set_Attributes (
2376: p_okl_late_policies_tl_rec IN okl_late_policies_tl_rec_type,
2377: x_okl_late_policies_tl_rec OUT NOCOPY okl_late_policies_tl_rec_type
2378: ) RETURN VARCHAR2 IS
2379: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2380: BEGIN

Line 2377: x_okl_late_policies_tl_rec OUT NOCOPY okl_late_policies_tl_rec_type

2373: -- Set_Attributes for:OKL_LATE_POLICIES_TL --
2374: ---------------------------------------------
2375: FUNCTION Set_Attributes (
2376: p_okl_late_policies_tl_rec IN okl_late_policies_tl_rec_type,
2377: x_okl_late_policies_tl_rec OUT NOCOPY okl_late_policies_tl_rec_type
2378: ) RETURN VARCHAR2 IS
2379: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2380: BEGIN
2381: x_okl_late_policies_tl_rec := p_okl_late_policies_tl_rec;

Line 2381: x_okl_late_policies_tl_rec := p_okl_late_policies_tl_rec;

2377: x_okl_late_policies_tl_rec OUT NOCOPY okl_late_policies_tl_rec_type
2378: ) RETURN VARCHAR2 IS
2379: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2380: BEGIN
2381: x_okl_late_policies_tl_rec := p_okl_late_policies_tl_rec;
2382: x_okl_late_policies_tl_rec.LANGUAGE := USERENV('LANG');
2383: x_okl_late_policies_tl_rec.LANGUAGE := USERENV('LANG');
2384: RETURN(l_return_status);
2385: END Set_Attributes;

Line 2382: x_okl_late_policies_tl_rec.LANGUAGE := USERENV('LANG');

2378: ) RETURN VARCHAR2 IS
2379: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2380: BEGIN
2381: x_okl_late_policies_tl_rec := p_okl_late_policies_tl_rec;
2382: x_okl_late_policies_tl_rec.LANGUAGE := USERENV('LANG');
2383: x_okl_late_policies_tl_rec.LANGUAGE := USERENV('LANG');
2384: RETURN(l_return_status);
2385: END Set_Attributes;
2386: BEGIN

Line 2383: x_okl_late_policies_tl_rec.LANGUAGE := USERENV('LANG');

2379: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2380: BEGIN
2381: x_okl_late_policies_tl_rec := p_okl_late_policies_tl_rec;
2382: x_okl_late_policies_tl_rec.LANGUAGE := USERENV('LANG');
2383: x_okl_late_policies_tl_rec.LANGUAGE := USERENV('LANG');
2384: RETURN(l_return_status);
2385: END Set_Attributes;
2386: BEGIN
2387: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

Line 2398: p_okl_late_policies_tl_rec, -- IN

2394: RAISE Okc_Api.G_EXCEPTION_ERROR;
2395: END IF;
2396: --- Setting item attributes
2397: l_return_status := Set_Attributes(
2398: p_okl_late_policies_tl_rec, -- IN
2399: l_okl_late_policies_tl_rec); -- OUT
2400: --- If any errors happen abort API
2401: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2402: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2399: l_okl_late_policies_tl_rec); -- OUT

2395: END IF;
2396: --- Setting item attributes
2397: l_return_status := Set_Attributes(
2398: p_okl_late_policies_tl_rec, -- IN
2399: l_okl_late_policies_tl_rec); -- OUT
2400: --- If any errors happen abort API
2401: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2402: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2403: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

Line 2406: l_return_status := populate_new_record(l_okl_late_policies_tl_rec, l_def_okl_late_policies_tl_rec);

2402: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2403: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2404: RAISE Okc_Api.G_EXCEPTION_ERROR;
2405: END IF;
2406: l_return_status := populate_new_record(l_okl_late_policies_tl_rec, l_def_okl_late_policies_tl_rec);
2407: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2408: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2409: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2410: RAISE Okc_Api.G_EXCEPTION_ERROR;

Line 2412: UPDATE OKL_LATE_POLICIES_TL

2408: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2409: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2410: RAISE Okc_Api.G_EXCEPTION_ERROR;
2411: END IF;
2412: UPDATE OKL_LATE_POLICIES_TL
2413: SET NAME = l_def_okl_late_policies_tl_rec.name,
2414: DESCRIPTION = l_def_okl_late_policies_tl_rec.description,
2415: CREATED_BY = l_def_okl_late_policies_tl_rec.created_by,
2416: CREATION_DATE = l_def_okl_late_policies_tl_rec.creation_date,

Line 2413: SET NAME = l_def_okl_late_policies_tl_rec.name,

2409: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2410: RAISE Okc_Api.G_EXCEPTION_ERROR;
2411: END IF;
2412: UPDATE OKL_LATE_POLICIES_TL
2413: SET NAME = l_def_okl_late_policies_tl_rec.name,
2414: DESCRIPTION = l_def_okl_late_policies_tl_rec.description,
2415: CREATED_BY = l_def_okl_late_policies_tl_rec.created_by,
2416: CREATION_DATE = l_def_okl_late_policies_tl_rec.creation_date,
2417: LAST_UPDATED_BY = l_def_okl_late_policies_tl_rec.last_updated_by,

Line 2414: DESCRIPTION = l_def_okl_late_policies_tl_rec.description,

2410: RAISE Okc_Api.G_EXCEPTION_ERROR;
2411: END IF;
2412: UPDATE OKL_LATE_POLICIES_TL
2413: SET NAME = l_def_okl_late_policies_tl_rec.name,
2414: DESCRIPTION = l_def_okl_late_policies_tl_rec.description,
2415: CREATED_BY = l_def_okl_late_policies_tl_rec.created_by,
2416: CREATION_DATE = l_def_okl_late_policies_tl_rec.creation_date,
2417: LAST_UPDATED_BY = l_def_okl_late_policies_tl_rec.last_updated_by,
2418: LAST_UPDATE_DATE = l_def_okl_late_policies_tl_rec.last_update_date,

Line 2415: CREATED_BY = l_def_okl_late_policies_tl_rec.created_by,

2411: END IF;
2412: UPDATE OKL_LATE_POLICIES_TL
2413: SET NAME = l_def_okl_late_policies_tl_rec.name,
2414: DESCRIPTION = l_def_okl_late_policies_tl_rec.description,
2415: CREATED_BY = l_def_okl_late_policies_tl_rec.created_by,
2416: CREATION_DATE = l_def_okl_late_policies_tl_rec.creation_date,
2417: LAST_UPDATED_BY = l_def_okl_late_policies_tl_rec.last_updated_by,
2418: LAST_UPDATE_DATE = l_def_okl_late_policies_tl_rec.last_update_date,
2419: LAST_UPDATE_LOGIN = l_def_okl_late_policies_tl_rec.last_update_login

Line 2416: CREATION_DATE = l_def_okl_late_policies_tl_rec.creation_date,

2412: UPDATE OKL_LATE_POLICIES_TL
2413: SET NAME = l_def_okl_late_policies_tl_rec.name,
2414: DESCRIPTION = l_def_okl_late_policies_tl_rec.description,
2415: CREATED_BY = l_def_okl_late_policies_tl_rec.created_by,
2416: CREATION_DATE = l_def_okl_late_policies_tl_rec.creation_date,
2417: LAST_UPDATED_BY = l_def_okl_late_policies_tl_rec.last_updated_by,
2418: LAST_UPDATE_DATE = l_def_okl_late_policies_tl_rec.last_update_date,
2419: LAST_UPDATE_LOGIN = l_def_okl_late_policies_tl_rec.last_update_login
2420: WHERE ID = l_def_okl_late_policies_tl_rec.id

Line 2417: LAST_UPDATED_BY = l_def_okl_late_policies_tl_rec.last_updated_by,

2413: SET NAME = l_def_okl_late_policies_tl_rec.name,
2414: DESCRIPTION = l_def_okl_late_policies_tl_rec.description,
2415: CREATED_BY = l_def_okl_late_policies_tl_rec.created_by,
2416: CREATION_DATE = l_def_okl_late_policies_tl_rec.creation_date,
2417: LAST_UPDATED_BY = l_def_okl_late_policies_tl_rec.last_updated_by,
2418: LAST_UPDATE_DATE = l_def_okl_late_policies_tl_rec.last_update_date,
2419: LAST_UPDATE_LOGIN = l_def_okl_late_policies_tl_rec.last_update_login
2420: WHERE ID = l_def_okl_late_policies_tl_rec.id
2421: --AND SOURCE_LANG = USERENV('LANG');

Line 2418: LAST_UPDATE_DATE = l_def_okl_late_policies_tl_rec.last_update_date,

2414: DESCRIPTION = l_def_okl_late_policies_tl_rec.description,
2415: CREATED_BY = l_def_okl_late_policies_tl_rec.created_by,
2416: CREATION_DATE = l_def_okl_late_policies_tl_rec.creation_date,
2417: LAST_UPDATED_BY = l_def_okl_late_policies_tl_rec.last_updated_by,
2418: LAST_UPDATE_DATE = l_def_okl_late_policies_tl_rec.last_update_date,
2419: LAST_UPDATE_LOGIN = l_def_okl_late_policies_tl_rec.last_update_login
2420: WHERE ID = l_def_okl_late_policies_tl_rec.id
2421: --AND SOURCE_LANG = USERENV('LANG');
2422: AND USERENV('LANG') in (SOURCE_LANG, LANGUAGE);

Line 2419: LAST_UPDATE_LOGIN = l_def_okl_late_policies_tl_rec.last_update_login

2415: CREATED_BY = l_def_okl_late_policies_tl_rec.created_by,
2416: CREATION_DATE = l_def_okl_late_policies_tl_rec.creation_date,
2417: LAST_UPDATED_BY = l_def_okl_late_policies_tl_rec.last_updated_by,
2418: LAST_UPDATE_DATE = l_def_okl_late_policies_tl_rec.last_update_date,
2419: LAST_UPDATE_LOGIN = l_def_okl_late_policies_tl_rec.last_update_login
2420: WHERE ID = l_def_okl_late_policies_tl_rec.id
2421: --AND SOURCE_LANG = USERENV('LANG');
2422: AND USERENV('LANG') in (SOURCE_LANG, LANGUAGE);
2423:

Line 2420: WHERE ID = l_def_okl_late_policies_tl_rec.id

2416: CREATION_DATE = l_def_okl_late_policies_tl_rec.creation_date,
2417: LAST_UPDATED_BY = l_def_okl_late_policies_tl_rec.last_updated_by,
2418: LAST_UPDATE_DATE = l_def_okl_late_policies_tl_rec.last_update_date,
2419: LAST_UPDATE_LOGIN = l_def_okl_late_policies_tl_rec.last_update_login
2420: WHERE ID = l_def_okl_late_policies_tl_rec.id
2421: --AND SOURCE_LANG = USERENV('LANG');
2422: AND USERENV('LANG') in (SOURCE_LANG, LANGUAGE);
2423:
2424: /* UPDATE OKL_LATE_POLICIES_TL

Line 2424: /* UPDATE OKL_LATE_POLICIES_TL

2420: WHERE ID = l_def_okl_late_policies_tl_rec.id
2421: --AND SOURCE_LANG = USERENV('LANG');
2422: AND USERENV('LANG') in (SOURCE_LANG, LANGUAGE);
2423:
2424: /* UPDATE OKL_LATE_POLICIES_TL
2425: SET SFWT_FLAG = 'Y'
2426: WHERE ID = l_def_okl_late_policies_tl_rec.id
2427: AND SOURCE_LANG <> USERENV('LANG');
2428: */

Line 2426: WHERE ID = l_def_okl_late_policies_tl_rec.id

2422: AND USERENV('LANG') in (SOURCE_LANG, LANGUAGE);
2423:
2424: /* UPDATE OKL_LATE_POLICIES_TL
2425: SET SFWT_FLAG = 'Y'
2426: WHERE ID = l_def_okl_late_policies_tl_rec.id
2427: AND SOURCE_LANG <> USERENV('LANG');
2428: */
2429: x_okl_late_policies_tl_rec := l_okl_late_policies_tl_rec;
2430: x_return_status := l_return_status;

Line 2429: x_okl_late_policies_tl_rec := l_okl_late_policies_tl_rec;

2425: SET SFWT_FLAG = 'Y'
2426: WHERE ID = l_def_okl_late_policies_tl_rec.id
2427: AND SOURCE_LANG <> USERENV('LANG');
2428: */
2429: x_okl_late_policies_tl_rec := l_okl_late_policies_tl_rec;
2430: x_return_status := l_return_status;
2431: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2432: EXCEPTION
2433: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

Line 2484: l_okl_late_policies_tl_rec okl_late_policies_tl_rec_type;

2480: l_def_lpov_rec lpov_rec_type;
2481: l_db_lpov_rec lpov_rec_type;
2482: l_lpo_rec lpo_rec_type;
2483: lx_lpo_rec lpo_rec_type;
2484: l_okl_late_policies_tl_rec okl_late_policies_tl_rec_type;
2485: lx_okl_late_policies_tl_rec okl_late_policies_tl_rec_type;
2486: -------------------------------
2487: -- FUNCTION fill_who_columns --
2488: -------------------------------

Line 2485: lx_okl_late_policies_tl_rec okl_late_policies_tl_rec_type;

2481: l_db_lpov_rec lpov_rec_type;
2482: l_lpo_rec lpo_rec_type;
2483: lx_lpo_rec lpo_rec_type;
2484: l_okl_late_policies_tl_rec okl_late_policies_tl_rec_type;
2485: lx_okl_late_policies_tl_rec okl_late_policies_tl_rec_type;
2486: -------------------------------
2487: -- FUNCTION fill_who_columns --
2488: -------------------------------
2489: FUNCTION fill_who_columns (

Line 2767: migrate(l_def_lpov_rec, l_okl_late_policies_tl_rec);

2763: -----------------------------------------
2764: -- Move VIEW record to "Child" records --
2765: -----------------------------------------
2766: migrate(l_def_lpov_rec, l_lpo_rec);
2767: migrate(l_def_lpov_rec, l_okl_late_policies_tl_rec);
2768: -----------------------------------------------
2769: -- Call the UPDATE_ROW for each child record --
2770: -----------------------------------------------
2771: update_row(

Line 2790: l_okl_late_policies_tl_rec,

2786: p_init_msg_list,
2787: l_return_status,
2788: x_msg_count,
2789: x_msg_data,
2790: l_okl_late_policies_tl_rec,
2791: lx_okl_late_policies_tl_rec
2792: );
2793: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2794: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2791: lx_okl_late_policies_tl_rec

2787: l_return_status,
2788: x_msg_count,
2789: x_msg_data,
2790: l_okl_late_policies_tl_rec,
2791: lx_okl_late_policies_tl_rec
2792: );
2793: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2794: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2795: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

Line 2798: migrate(lx_okl_late_policies_tl_rec, l_def_lpov_rec);

2794: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2795: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2796: RAISE Okc_Api.G_EXCEPTION_ERROR;
2797: END IF;
2798: migrate(lx_okl_late_policies_tl_rec, l_def_lpov_rec);
2799: x_lpov_rec := l_def_lpov_rec;
2800: x_return_status := l_return_status;
2801: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2802: EXCEPTION

Line 2970: -- delete_row for:OKL_LATE_POLICIES_TL --

2966: '_PVT'
2967: );
2968: END delete_row;
2969: -----------------------------------------
2970: -- delete_row for:OKL_LATE_POLICIES_TL --
2971: -----------------------------------------
2972: PROCEDURE delete_row(
2973: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
2974: x_return_status OUT NOCOPY VARCHAR2,

Line 2977: p_okl_late_policies_tl_rec IN okl_late_policies_tl_rec_type) IS

2973: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
2974: x_return_status OUT NOCOPY VARCHAR2,
2975: x_msg_count OUT NOCOPY NUMBER,
2976: x_msg_data OUT NOCOPY VARCHAR2,
2977: p_okl_late_policies_tl_rec IN okl_late_policies_tl_rec_type) IS
2978:
2979: l_api_version CONSTANT NUMBER := 1;
2980: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
2981: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

Line 2982: l_okl_late_policies_tl_rec okl_late_policies_tl_rec_type := p_okl_late_policies_tl_rec;

2978:
2979: l_api_version CONSTANT NUMBER := 1;
2980: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
2981: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2982: l_okl_late_policies_tl_rec okl_late_policies_tl_rec_type := p_okl_late_policies_tl_rec;
2983: l_row_notfound BOOLEAN := TRUE;
2984: BEGIN
2985: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
2986: p_init_msg_list,

Line 2995: DELETE FROM OKL_LATE_POLICIES_TL

2991: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2992: RAISE Okc_Api.G_EXCEPTION_ERROR;
2993: END IF;
2994:
2995: DELETE FROM OKL_LATE_POLICIES_TL
2996: WHERE ID = p_okl_late_policies_tl_rec.id;
2997:
2998: x_return_status := l_return_status;
2999: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2996: WHERE ID = p_okl_late_policies_tl_rec.id;

2992: RAISE Okc_Api.G_EXCEPTION_ERROR;
2993: END IF;
2994:
2995: DELETE FROM OKL_LATE_POLICIES_TL
2996: WHERE ID = p_okl_late_policies_tl_rec.id;
2997:
2998: x_return_status := l_return_status;
2999: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
3000: EXCEPTION

Line 3047: l_okl_late_policies_tl_rec okl_late_policies_tl_rec_type;

3043: l_api_version CONSTANT NUMBER := 1;
3044: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
3045: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
3046: l_lpov_rec lpov_rec_type := p_lpov_rec;
3047: l_okl_late_policies_tl_rec okl_late_policies_tl_rec_type;
3048: l_lpo_rec lpo_rec_type;
3049: BEGIN
3050: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
3051: G_PKG_NAME,

Line 3065: migrate(l_lpov_rec, l_okl_late_policies_tl_rec);

3061: END IF;
3062: -----------------------------------------
3063: -- Move VIEW record to "Child" records --
3064: -----------------------------------------
3065: migrate(l_lpov_rec, l_okl_late_policies_tl_rec);
3066: migrate(l_lpov_rec, l_lpo_rec);
3067: -----------------------------------------------
3068: -- Call the DELETE_ROW for each child record --
3069: -----------------------------------------------

Line 3075: l_okl_late_policies_tl_rec

3071: p_init_msg_list,
3072: l_return_status,
3073: x_msg_count,
3074: x_msg_data,
3075: l_okl_late_policies_tl_rec
3076: );
3077: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
3078: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3079: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN