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_ILT_PVT dependencies on OKL_INVC_LINE_TYPES_TL

Line 291: DELETE FROM OKL_INVC_LINE_TYPES_TL T

287: -- PROCEDURE add_language
288: ---------------------------------------------------------------------------
289: PROCEDURE add_language IS
290: BEGIN
291: DELETE FROM OKL_INVC_LINE_TYPES_TL T
292: WHERE NOT EXISTS (
293: SELECT NULL
294: FROM OKL_INVC_LINE_TYPES_B B --fixed bug 3321017 by kmotepal
295: WHERE B.ID = T.ID

Line 298: UPDATE OKL_INVC_LINE_TYPES_TL T SET (

294: FROM OKL_INVC_LINE_TYPES_B B --fixed bug 3321017 by kmotepal
295: WHERE B.ID = T.ID
296: );
297:
298: UPDATE OKL_INVC_LINE_TYPES_TL T SET (
299: NAME,
300: DESCRIPTION) = (SELECT
301: B.NAME,
302: B.DESCRIPTION

Line 303: FROM OKL_INVC_LINE_TYPES_TL B

299: NAME,
300: DESCRIPTION) = (SELECT
301: B.NAME,
302: B.DESCRIPTION
303: FROM OKL_INVC_LINE_TYPES_TL B
304: WHERE B.ID = T.ID
305: AND B.LANGUAGE = T.SOURCE_LANG)
306: WHERE (
307: T.ID,

Line 312: FROM OKL_INVC_LINE_TYPES_TL SUBB, OKL_INVC_LINE_TYPES_TL SUBT

308: T.LANGUAGE)
309: IN (SELECT
310: SUBT.ID,
311: SUBT.LANGUAGE
312: FROM OKL_INVC_LINE_TYPES_TL SUBB, OKL_INVC_LINE_TYPES_TL SUBT
313: WHERE SUBB.ID = SUBT.ID
314: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
315: AND (SUBB.NAME <> SUBT.NAME
316: OR SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 321: INSERT INTO OKL_INVC_LINE_TYPES_TL (

317: OR (SUBB.DESCRIPTION IS NULL AND SUBT.DESCRIPTION IS NOT NULL)
318: OR (SUBB.DESCRIPTION IS NOT NULL AND SUBT.DESCRIPTION IS NULL)
319: ));
320:
321: INSERT INTO OKL_INVC_LINE_TYPES_TL (
322: ID,
323: LANGUAGE,
324: SOURCE_LANG,
325: SFWT_FLAG,

Line 345: FROM OKL_INVC_LINE_TYPES_TL B, FND_LANGUAGES L

341: B.CREATION_DATE,
342: B.LAST_UPDATED_BY,
343: B.LAST_UPDATE_DATE,
344: B.LAST_UPDATE_LOGIN
345: FROM OKL_INVC_LINE_TYPES_TL B, FND_LANGUAGES L
346: WHERE L.INSTALLED_FLAG IN ('I', 'B')
347: AND B.LANGUAGE = USERENV('LANG')
348: AND NOT EXISTS(
349: SELECT NULL

Line 350: FROM OKL_INVC_LINE_TYPES_TL T

346: WHERE L.INSTALLED_FLAG IN ('I', 'B')
347: AND B.LANGUAGE = USERENV('LANG')
348: AND NOT EXISTS(
349: SELECT NULL
350: FROM OKL_INVC_LINE_TYPES_TL T
351: WHERE T.ID = B.ID
352: AND T.LANGUAGE = L.LANGUAGE_CODE
353: );
354:

Line 438: -- FUNCTION get_rec for: OKL_INVC_LINE_TYPES_TL

434: BEGIN
435: RETURN(get_rec(p_ilt_rec, l_row_notfound));
436: END get_rec;
437: ---------------------------------------------------------------------------
438: -- FUNCTION get_rec for: OKL_INVC_LINE_TYPES_TL
439: ---------------------------------------------------------------------------
440: FUNCTION get_rec (
441: p_okl_invc_line_types_tl_rec IN OklInvcLineTypesTlRecType,
442: x_no_data_found OUT NOCOPY BOOLEAN

Line 441: p_okl_invc_line_types_tl_rec IN OklInvcLineTypesTlRecType,

437: ---------------------------------------------------------------------------
438: -- FUNCTION get_rec for: OKL_INVC_LINE_TYPES_TL
439: ---------------------------------------------------------------------------
440: FUNCTION get_rec (
441: p_okl_invc_line_types_tl_rec IN OklInvcLineTypesTlRecType,
442: x_no_data_found OUT NOCOPY BOOLEAN
443: ) RETURN OklInvcLineTypesTlRecType IS
444: CURSOR okl_invc_line_types_tl_pk_csr (p_id IN NUMBER,
445: p_language IN VARCHAR2) IS

Line 444: CURSOR okl_invc_line_types_tl_pk_csr (p_id IN NUMBER,

440: FUNCTION get_rec (
441: p_okl_invc_line_types_tl_rec IN OklInvcLineTypesTlRecType,
442: x_no_data_found OUT NOCOPY BOOLEAN
443: ) RETURN OklInvcLineTypesTlRecType IS
444: CURSOR okl_invc_line_types_tl_pk_csr (p_id IN NUMBER,
445: p_language IN VARCHAR2) IS
446: SELECT
447: ID,
448: LANGUAGE,

Line 458: FROM Okl_Invc_Line_Types_Tl

454: CREATION_DATE,
455: LAST_UPDATED_BY,
456: LAST_UPDATE_DATE,
457: LAST_UPDATE_LOGIN
458: FROM Okl_Invc_Line_Types_Tl
459: WHERE okl_invc_line_types_tl.id = p_id
460: AND okl_invc_line_types_tl.LANGUAGE = p_language;
461: l_okl_invc_line_types_tl_pk okl_invc_line_types_tl_pk_csr%ROWTYPE;
462: l_okl_invc_line_types_tl_rec OklInvcLineTypesTlRecType;

Line 459: WHERE okl_invc_line_types_tl.id = p_id

455: LAST_UPDATED_BY,
456: LAST_UPDATE_DATE,
457: LAST_UPDATE_LOGIN
458: FROM Okl_Invc_Line_Types_Tl
459: WHERE okl_invc_line_types_tl.id = p_id
460: AND okl_invc_line_types_tl.LANGUAGE = p_language;
461: l_okl_invc_line_types_tl_pk okl_invc_line_types_tl_pk_csr%ROWTYPE;
462: l_okl_invc_line_types_tl_rec OklInvcLineTypesTlRecType;
463: BEGIN

Line 460: AND okl_invc_line_types_tl.LANGUAGE = p_language;

456: LAST_UPDATE_DATE,
457: LAST_UPDATE_LOGIN
458: FROM Okl_Invc_Line_Types_Tl
459: WHERE okl_invc_line_types_tl.id = p_id
460: AND okl_invc_line_types_tl.LANGUAGE = p_language;
461: l_okl_invc_line_types_tl_pk okl_invc_line_types_tl_pk_csr%ROWTYPE;
462: l_okl_invc_line_types_tl_rec OklInvcLineTypesTlRecType;
463: BEGIN
464: x_no_data_found := TRUE;

Line 461: l_okl_invc_line_types_tl_pk okl_invc_line_types_tl_pk_csr%ROWTYPE;

457: LAST_UPDATE_LOGIN
458: FROM Okl_Invc_Line_Types_Tl
459: WHERE okl_invc_line_types_tl.id = p_id
460: AND okl_invc_line_types_tl.LANGUAGE = p_language;
461: l_okl_invc_line_types_tl_pk okl_invc_line_types_tl_pk_csr%ROWTYPE;
462: l_okl_invc_line_types_tl_rec OklInvcLineTypesTlRecType;
463: BEGIN
464: x_no_data_found := TRUE;
465: -- Get current database values

Line 462: l_okl_invc_line_types_tl_rec OklInvcLineTypesTlRecType;

458: FROM Okl_Invc_Line_Types_Tl
459: WHERE okl_invc_line_types_tl.id = p_id
460: AND okl_invc_line_types_tl.LANGUAGE = p_language;
461: l_okl_invc_line_types_tl_pk okl_invc_line_types_tl_pk_csr%ROWTYPE;
462: l_okl_invc_line_types_tl_rec OklInvcLineTypesTlRecType;
463: BEGIN
464: x_no_data_found := TRUE;
465: -- Get current database values
466: OPEN okl_invc_line_types_tl_pk_csr (p_okl_invc_line_types_tl_rec.id,

Line 466: OPEN okl_invc_line_types_tl_pk_csr (p_okl_invc_line_types_tl_rec.id,

462: l_okl_invc_line_types_tl_rec OklInvcLineTypesTlRecType;
463: BEGIN
464: x_no_data_found := TRUE;
465: -- Get current database values
466: OPEN okl_invc_line_types_tl_pk_csr (p_okl_invc_line_types_tl_rec.id,
467: p_okl_invc_line_types_tl_rec.LANGUAGE);
468: FETCH okl_invc_line_types_tl_pk_csr INTO
469: l_okl_invc_line_types_tl_rec.ID,
470: l_okl_invc_line_types_tl_rec.LANGUAGE,

Line 467: p_okl_invc_line_types_tl_rec.LANGUAGE);

463: BEGIN
464: x_no_data_found := TRUE;
465: -- Get current database values
466: OPEN okl_invc_line_types_tl_pk_csr (p_okl_invc_line_types_tl_rec.id,
467: p_okl_invc_line_types_tl_rec.LANGUAGE);
468: FETCH okl_invc_line_types_tl_pk_csr INTO
469: l_okl_invc_line_types_tl_rec.ID,
470: l_okl_invc_line_types_tl_rec.LANGUAGE,
471: l_okl_invc_line_types_tl_rec.SOURCE_LANG,

Line 468: FETCH okl_invc_line_types_tl_pk_csr INTO

464: x_no_data_found := TRUE;
465: -- Get current database values
466: OPEN okl_invc_line_types_tl_pk_csr (p_okl_invc_line_types_tl_rec.id,
467: p_okl_invc_line_types_tl_rec.LANGUAGE);
468: FETCH okl_invc_line_types_tl_pk_csr INTO
469: l_okl_invc_line_types_tl_rec.ID,
470: l_okl_invc_line_types_tl_rec.LANGUAGE,
471: l_okl_invc_line_types_tl_rec.SOURCE_LANG,
472: l_okl_invc_line_types_tl_rec.SFWT_FLAG,

Line 469: l_okl_invc_line_types_tl_rec.ID,

465: -- Get current database values
466: OPEN okl_invc_line_types_tl_pk_csr (p_okl_invc_line_types_tl_rec.id,
467: p_okl_invc_line_types_tl_rec.LANGUAGE);
468: FETCH okl_invc_line_types_tl_pk_csr INTO
469: l_okl_invc_line_types_tl_rec.ID,
470: l_okl_invc_line_types_tl_rec.LANGUAGE,
471: l_okl_invc_line_types_tl_rec.SOURCE_LANG,
472: l_okl_invc_line_types_tl_rec.SFWT_FLAG,
473: l_okl_invc_line_types_tl_rec.NAME,

Line 470: l_okl_invc_line_types_tl_rec.LANGUAGE,

466: OPEN okl_invc_line_types_tl_pk_csr (p_okl_invc_line_types_tl_rec.id,
467: p_okl_invc_line_types_tl_rec.LANGUAGE);
468: FETCH okl_invc_line_types_tl_pk_csr INTO
469: l_okl_invc_line_types_tl_rec.ID,
470: l_okl_invc_line_types_tl_rec.LANGUAGE,
471: l_okl_invc_line_types_tl_rec.SOURCE_LANG,
472: l_okl_invc_line_types_tl_rec.SFWT_FLAG,
473: l_okl_invc_line_types_tl_rec.NAME,
474: l_okl_invc_line_types_tl_rec.DESCRIPTION,

Line 471: l_okl_invc_line_types_tl_rec.SOURCE_LANG,

467: p_okl_invc_line_types_tl_rec.LANGUAGE);
468: FETCH okl_invc_line_types_tl_pk_csr INTO
469: l_okl_invc_line_types_tl_rec.ID,
470: l_okl_invc_line_types_tl_rec.LANGUAGE,
471: l_okl_invc_line_types_tl_rec.SOURCE_LANG,
472: l_okl_invc_line_types_tl_rec.SFWT_FLAG,
473: l_okl_invc_line_types_tl_rec.NAME,
474: l_okl_invc_line_types_tl_rec.DESCRIPTION,
475: l_okl_invc_line_types_tl_rec.CREATED_BY,

Line 472: l_okl_invc_line_types_tl_rec.SFWT_FLAG,

468: FETCH okl_invc_line_types_tl_pk_csr INTO
469: l_okl_invc_line_types_tl_rec.ID,
470: l_okl_invc_line_types_tl_rec.LANGUAGE,
471: l_okl_invc_line_types_tl_rec.SOURCE_LANG,
472: l_okl_invc_line_types_tl_rec.SFWT_FLAG,
473: l_okl_invc_line_types_tl_rec.NAME,
474: l_okl_invc_line_types_tl_rec.DESCRIPTION,
475: l_okl_invc_line_types_tl_rec.CREATED_BY,
476: l_okl_invc_line_types_tl_rec.CREATION_DATE,

Line 473: l_okl_invc_line_types_tl_rec.NAME,

469: l_okl_invc_line_types_tl_rec.ID,
470: l_okl_invc_line_types_tl_rec.LANGUAGE,
471: l_okl_invc_line_types_tl_rec.SOURCE_LANG,
472: l_okl_invc_line_types_tl_rec.SFWT_FLAG,
473: l_okl_invc_line_types_tl_rec.NAME,
474: l_okl_invc_line_types_tl_rec.DESCRIPTION,
475: l_okl_invc_line_types_tl_rec.CREATED_BY,
476: l_okl_invc_line_types_tl_rec.CREATION_DATE,
477: l_okl_invc_line_types_tl_rec.LAST_UPDATED_BY,

Line 474: l_okl_invc_line_types_tl_rec.DESCRIPTION,

470: l_okl_invc_line_types_tl_rec.LANGUAGE,
471: l_okl_invc_line_types_tl_rec.SOURCE_LANG,
472: l_okl_invc_line_types_tl_rec.SFWT_FLAG,
473: l_okl_invc_line_types_tl_rec.NAME,
474: l_okl_invc_line_types_tl_rec.DESCRIPTION,
475: l_okl_invc_line_types_tl_rec.CREATED_BY,
476: l_okl_invc_line_types_tl_rec.CREATION_DATE,
477: l_okl_invc_line_types_tl_rec.LAST_UPDATED_BY,
478: l_okl_invc_line_types_tl_rec.LAST_UPDATE_DATE,

Line 475: l_okl_invc_line_types_tl_rec.CREATED_BY,

471: l_okl_invc_line_types_tl_rec.SOURCE_LANG,
472: l_okl_invc_line_types_tl_rec.SFWT_FLAG,
473: l_okl_invc_line_types_tl_rec.NAME,
474: l_okl_invc_line_types_tl_rec.DESCRIPTION,
475: l_okl_invc_line_types_tl_rec.CREATED_BY,
476: l_okl_invc_line_types_tl_rec.CREATION_DATE,
477: l_okl_invc_line_types_tl_rec.LAST_UPDATED_BY,
478: l_okl_invc_line_types_tl_rec.LAST_UPDATE_DATE,
479: l_okl_invc_line_types_tl_rec.LAST_UPDATE_LOGIN;

Line 476: l_okl_invc_line_types_tl_rec.CREATION_DATE,

472: l_okl_invc_line_types_tl_rec.SFWT_FLAG,
473: l_okl_invc_line_types_tl_rec.NAME,
474: l_okl_invc_line_types_tl_rec.DESCRIPTION,
475: l_okl_invc_line_types_tl_rec.CREATED_BY,
476: l_okl_invc_line_types_tl_rec.CREATION_DATE,
477: l_okl_invc_line_types_tl_rec.LAST_UPDATED_BY,
478: l_okl_invc_line_types_tl_rec.LAST_UPDATE_DATE,
479: l_okl_invc_line_types_tl_rec.LAST_UPDATE_LOGIN;
480: x_no_data_found := okl_invc_line_types_tl_pk_csr%NOTFOUND;

Line 477: l_okl_invc_line_types_tl_rec.LAST_UPDATED_BY,

473: l_okl_invc_line_types_tl_rec.NAME,
474: l_okl_invc_line_types_tl_rec.DESCRIPTION,
475: l_okl_invc_line_types_tl_rec.CREATED_BY,
476: l_okl_invc_line_types_tl_rec.CREATION_DATE,
477: l_okl_invc_line_types_tl_rec.LAST_UPDATED_BY,
478: l_okl_invc_line_types_tl_rec.LAST_UPDATE_DATE,
479: l_okl_invc_line_types_tl_rec.LAST_UPDATE_LOGIN;
480: x_no_data_found := okl_invc_line_types_tl_pk_csr%NOTFOUND;
481: CLOSE okl_invc_line_types_tl_pk_csr;

Line 478: l_okl_invc_line_types_tl_rec.LAST_UPDATE_DATE,

474: l_okl_invc_line_types_tl_rec.DESCRIPTION,
475: l_okl_invc_line_types_tl_rec.CREATED_BY,
476: l_okl_invc_line_types_tl_rec.CREATION_DATE,
477: l_okl_invc_line_types_tl_rec.LAST_UPDATED_BY,
478: l_okl_invc_line_types_tl_rec.LAST_UPDATE_DATE,
479: l_okl_invc_line_types_tl_rec.LAST_UPDATE_LOGIN;
480: x_no_data_found := okl_invc_line_types_tl_pk_csr%NOTFOUND;
481: CLOSE okl_invc_line_types_tl_pk_csr;
482: RETURN(l_okl_invc_line_types_tl_rec);

Line 479: l_okl_invc_line_types_tl_rec.LAST_UPDATE_LOGIN;

475: l_okl_invc_line_types_tl_rec.CREATED_BY,
476: l_okl_invc_line_types_tl_rec.CREATION_DATE,
477: l_okl_invc_line_types_tl_rec.LAST_UPDATED_BY,
478: l_okl_invc_line_types_tl_rec.LAST_UPDATE_DATE,
479: l_okl_invc_line_types_tl_rec.LAST_UPDATE_LOGIN;
480: x_no_data_found := okl_invc_line_types_tl_pk_csr%NOTFOUND;
481: CLOSE okl_invc_line_types_tl_pk_csr;
482: RETURN(l_okl_invc_line_types_tl_rec);
483: END get_rec;

Line 480: x_no_data_found := okl_invc_line_types_tl_pk_csr%NOTFOUND;

476: l_okl_invc_line_types_tl_rec.CREATION_DATE,
477: l_okl_invc_line_types_tl_rec.LAST_UPDATED_BY,
478: l_okl_invc_line_types_tl_rec.LAST_UPDATE_DATE,
479: l_okl_invc_line_types_tl_rec.LAST_UPDATE_LOGIN;
480: x_no_data_found := okl_invc_line_types_tl_pk_csr%NOTFOUND;
481: CLOSE okl_invc_line_types_tl_pk_csr;
482: RETURN(l_okl_invc_line_types_tl_rec);
483: END get_rec;
484:

Line 481: CLOSE okl_invc_line_types_tl_pk_csr;

477: l_okl_invc_line_types_tl_rec.LAST_UPDATED_BY,
478: l_okl_invc_line_types_tl_rec.LAST_UPDATE_DATE,
479: l_okl_invc_line_types_tl_rec.LAST_UPDATE_LOGIN;
480: x_no_data_found := okl_invc_line_types_tl_pk_csr%NOTFOUND;
481: CLOSE okl_invc_line_types_tl_pk_csr;
482: RETURN(l_okl_invc_line_types_tl_rec);
483: END get_rec;
484:
485: FUNCTION get_rec (

Line 482: RETURN(l_okl_invc_line_types_tl_rec);

478: l_okl_invc_line_types_tl_rec.LAST_UPDATE_DATE,
479: l_okl_invc_line_types_tl_rec.LAST_UPDATE_LOGIN;
480: x_no_data_found := okl_invc_line_types_tl_pk_csr%NOTFOUND;
481: CLOSE okl_invc_line_types_tl_pk_csr;
482: RETURN(l_okl_invc_line_types_tl_rec);
483: END get_rec;
484:
485: FUNCTION get_rec (
486: p_okl_invc_line_types_tl_rec IN OklInvcLineTypesTlRecType

Line 486: p_okl_invc_line_types_tl_rec IN OklInvcLineTypesTlRecType

482: RETURN(l_okl_invc_line_types_tl_rec);
483: END get_rec;
484:
485: FUNCTION get_rec (
486: p_okl_invc_line_types_tl_rec IN OklInvcLineTypesTlRecType
487: ) RETURN OklInvcLineTypesTlRecType IS
488: l_row_notfound BOOLEAN := TRUE;
489: BEGIN
490: RETURN(get_rec(p_okl_invc_line_types_tl_rec, l_row_notfound));

Line 490: RETURN(get_rec(p_okl_invc_line_types_tl_rec, l_row_notfound));

486: p_okl_invc_line_types_tl_rec IN OklInvcLineTypesTlRecType
487: ) RETURN OklInvcLineTypesTlRecType IS
488: l_row_notfound BOOLEAN := TRUE;
489: BEGIN
490: RETURN(get_rec(p_okl_invc_line_types_tl_rec, l_row_notfound));
491: END get_rec;
492: ---------------------------------------------------------------------------
493: -- FUNCTION get_rec for: OKL_INVC_LINE_TYPES_V
494: ---------------------------------------------------------------------------

Line 868: l_okl_invc_line_types_tl_rec OklInvcLineTypesTlRecType;

864: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
865: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
866: l_iltv_rec iltv_rec_type := p_iltv_rec;
867: l_ilt_rec ilt_rec_type;
868: l_okl_invc_line_types_tl_rec OklInvcLineTypesTlRecType;
869: BEGIN
870: l_return_status := okl_api.START_ACTIVITY(l_api_name,
871: G_PKG_NAME,
872: p_init_msg_list,

Line 1142: -- insert_row for:OKL_INVC_LINE_TYPES_TL --

1138: '_PVT'
1139: );
1140: END insert_row;
1141: -------------------------------------------
1142: -- insert_row for:OKL_INVC_LINE_TYPES_TL --
1143: -------------------------------------------
1144: PROCEDURE insert_row(
1145: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
1146: x_return_status OUT NOCOPY VARCHAR2,

Line 1149: p_okl_invc_line_types_tl_rec IN OklInvcLineTypesTlRecType,

1145: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
1146: x_return_status OUT NOCOPY VARCHAR2,
1147: x_msg_count OUT NOCOPY NUMBER,
1148: x_msg_data OUT NOCOPY VARCHAR2,
1149: p_okl_invc_line_types_tl_rec IN OklInvcLineTypesTlRecType,
1150: x_okl_invc_line_types_tl_rec OUT NOCOPY OklInvcLineTypesTlRecType) IS
1151:
1152: l_api_version CONSTANT NUMBER := 1;
1153: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';

Line 1150: x_okl_invc_line_types_tl_rec OUT NOCOPY OklInvcLineTypesTlRecType) IS

1146: x_return_status OUT NOCOPY VARCHAR2,
1147: x_msg_count OUT NOCOPY NUMBER,
1148: x_msg_data OUT NOCOPY VARCHAR2,
1149: p_okl_invc_line_types_tl_rec IN OklInvcLineTypesTlRecType,
1150: x_okl_invc_line_types_tl_rec OUT NOCOPY OklInvcLineTypesTlRecType) IS
1151:
1152: l_api_version CONSTANT NUMBER := 1;
1153: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1154: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;

Line 1155: l_okl_invc_line_types_tl_rec OklInvcLineTypesTlRecType := p_okl_invc_line_types_tl_rec;

1151:
1152: l_api_version CONSTANT NUMBER := 1;
1153: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1154: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
1155: l_okl_invc_line_types_tl_rec OklInvcLineTypesTlRecType := p_okl_invc_line_types_tl_rec;
1156: ldefoklinvclinetypestlrec OklInvcLineTypesTlRecType;
1157: CURSOR get_languages IS
1158: SELECT *
1159: FROM FND_LANGUAGES

Line 1162: -- Set_Attributes for:OKL_INVC_LINE_TYPES_TL --

1158: SELECT *
1159: FROM FND_LANGUAGES
1160: WHERE INSTALLED_FLAG IN ('I', 'B');
1161: -----------------------------------------------
1162: -- Set_Attributes for:OKL_INVC_LINE_TYPES_TL --
1163: -----------------------------------------------
1164: FUNCTION Set_Attributes (
1165: p_okl_invc_line_types_tl_rec IN OklInvcLineTypesTlRecType,
1166: x_okl_invc_line_types_tl_rec OUT NOCOPY OklInvcLineTypesTlRecType

Line 1165: p_okl_invc_line_types_tl_rec IN OklInvcLineTypesTlRecType,

1161: -----------------------------------------------
1162: -- Set_Attributes for:OKL_INVC_LINE_TYPES_TL --
1163: -----------------------------------------------
1164: FUNCTION Set_Attributes (
1165: p_okl_invc_line_types_tl_rec IN OklInvcLineTypesTlRecType,
1166: x_okl_invc_line_types_tl_rec OUT NOCOPY OklInvcLineTypesTlRecType
1167: ) RETURN VARCHAR2 IS
1168: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
1169: BEGIN

Line 1166: x_okl_invc_line_types_tl_rec OUT NOCOPY OklInvcLineTypesTlRecType

1162: -- Set_Attributes for:OKL_INVC_LINE_TYPES_TL --
1163: -----------------------------------------------
1164: FUNCTION Set_Attributes (
1165: p_okl_invc_line_types_tl_rec IN OklInvcLineTypesTlRecType,
1166: x_okl_invc_line_types_tl_rec OUT NOCOPY OklInvcLineTypesTlRecType
1167: ) RETURN VARCHAR2 IS
1168: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
1169: BEGIN
1170: x_okl_invc_line_types_tl_rec := p_okl_invc_line_types_tl_rec;

Line 1170: x_okl_invc_line_types_tl_rec := p_okl_invc_line_types_tl_rec;

1166: x_okl_invc_line_types_tl_rec OUT NOCOPY OklInvcLineTypesTlRecType
1167: ) RETURN VARCHAR2 IS
1168: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
1169: BEGIN
1170: x_okl_invc_line_types_tl_rec := p_okl_invc_line_types_tl_rec;
1171: x_okl_invc_line_types_tl_rec.LANGUAGE := USERENV('LANG');
1172: x_okl_invc_line_types_tl_rec.SOURCE_LANG := USERENV('LANG');
1173: RETURN(l_return_status);
1174: END Set_Attributes;

Line 1171: x_okl_invc_line_types_tl_rec.LANGUAGE := USERENV('LANG');

1167: ) RETURN VARCHAR2 IS
1168: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
1169: BEGIN
1170: x_okl_invc_line_types_tl_rec := p_okl_invc_line_types_tl_rec;
1171: x_okl_invc_line_types_tl_rec.LANGUAGE := USERENV('LANG');
1172: x_okl_invc_line_types_tl_rec.SOURCE_LANG := USERENV('LANG');
1173: RETURN(l_return_status);
1174: END Set_Attributes;
1175: BEGIN

Line 1172: x_okl_invc_line_types_tl_rec.SOURCE_LANG := USERENV('LANG');

1168: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
1169: BEGIN
1170: x_okl_invc_line_types_tl_rec := p_okl_invc_line_types_tl_rec;
1171: x_okl_invc_line_types_tl_rec.LANGUAGE := USERENV('LANG');
1172: x_okl_invc_line_types_tl_rec.SOURCE_LANG := USERENV('LANG');
1173: RETURN(l_return_status);
1174: END Set_Attributes;
1175: BEGIN
1176: l_return_status := okl_api.START_ACTIVITY(l_api_name,

Line 1187: p_okl_invc_line_types_tl_rec, -- IN

1183: RAISE okl_api.G_EXCEPTION_ERROR;
1184: END IF;
1185: --- Setting item attributes
1186: l_return_status := Set_Attributes(
1187: p_okl_invc_line_types_tl_rec, -- IN
1188: l_okl_invc_line_types_tl_rec); -- OUT
1189: --- If any errors happen abort API
1190: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
1191: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1188: l_okl_invc_line_types_tl_rec); -- OUT

1184: END IF;
1185: --- Setting item attributes
1186: l_return_status := Set_Attributes(
1187: p_okl_invc_line_types_tl_rec, -- IN
1188: l_okl_invc_line_types_tl_rec); -- OUT
1189: --- If any errors happen abort API
1190: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
1191: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
1192: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN

Line 1196: l_okl_invc_line_types_tl_rec.LANGUAGE := l_lang_rec.language_code;

1192: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
1193: RAISE okl_api.G_EXCEPTION_ERROR;
1194: END IF;
1195: FOR l_lang_rec IN get_languages LOOP
1196: l_okl_invc_line_types_tl_rec.LANGUAGE := l_lang_rec.language_code;
1197: INSERT INTO OKL_INVC_LINE_TYPES_TL(
1198: id,
1199: LANGUAGE,
1200: source_lang,

Line 1197: INSERT INTO OKL_INVC_LINE_TYPES_TL(

1193: RAISE okl_api.G_EXCEPTION_ERROR;
1194: END IF;
1195: FOR l_lang_rec IN get_languages LOOP
1196: l_okl_invc_line_types_tl_rec.LANGUAGE := l_lang_rec.language_code;
1197: INSERT INTO OKL_INVC_LINE_TYPES_TL(
1198: id,
1199: LANGUAGE,
1200: source_lang,
1201: sfwt_flag,

Line 1210: l_okl_invc_line_types_tl_rec.id,

1206: last_updated_by,
1207: last_update_date,
1208: last_update_login)
1209: VALUES (
1210: l_okl_invc_line_types_tl_rec.id,
1211: l_okl_invc_line_types_tl_rec.LANGUAGE,
1212: l_okl_invc_line_types_tl_rec.source_lang,
1213: l_okl_invc_line_types_tl_rec.sfwt_flag,
1214: l_okl_invc_line_types_tl_rec.name,

Line 1211: l_okl_invc_line_types_tl_rec.LANGUAGE,

1207: last_update_date,
1208: last_update_login)
1209: VALUES (
1210: l_okl_invc_line_types_tl_rec.id,
1211: l_okl_invc_line_types_tl_rec.LANGUAGE,
1212: l_okl_invc_line_types_tl_rec.source_lang,
1213: l_okl_invc_line_types_tl_rec.sfwt_flag,
1214: l_okl_invc_line_types_tl_rec.name,
1215: l_okl_invc_line_types_tl_rec.description,

Line 1212: l_okl_invc_line_types_tl_rec.source_lang,

1208: last_update_login)
1209: VALUES (
1210: l_okl_invc_line_types_tl_rec.id,
1211: l_okl_invc_line_types_tl_rec.LANGUAGE,
1212: l_okl_invc_line_types_tl_rec.source_lang,
1213: l_okl_invc_line_types_tl_rec.sfwt_flag,
1214: l_okl_invc_line_types_tl_rec.name,
1215: l_okl_invc_line_types_tl_rec.description,
1216: l_okl_invc_line_types_tl_rec.created_by,

Line 1213: l_okl_invc_line_types_tl_rec.sfwt_flag,

1209: VALUES (
1210: l_okl_invc_line_types_tl_rec.id,
1211: l_okl_invc_line_types_tl_rec.LANGUAGE,
1212: l_okl_invc_line_types_tl_rec.source_lang,
1213: l_okl_invc_line_types_tl_rec.sfwt_flag,
1214: l_okl_invc_line_types_tl_rec.name,
1215: l_okl_invc_line_types_tl_rec.description,
1216: l_okl_invc_line_types_tl_rec.created_by,
1217: l_okl_invc_line_types_tl_rec.creation_date,

Line 1214: l_okl_invc_line_types_tl_rec.name,

1210: l_okl_invc_line_types_tl_rec.id,
1211: l_okl_invc_line_types_tl_rec.LANGUAGE,
1212: l_okl_invc_line_types_tl_rec.source_lang,
1213: l_okl_invc_line_types_tl_rec.sfwt_flag,
1214: l_okl_invc_line_types_tl_rec.name,
1215: l_okl_invc_line_types_tl_rec.description,
1216: l_okl_invc_line_types_tl_rec.created_by,
1217: l_okl_invc_line_types_tl_rec.creation_date,
1218: l_okl_invc_line_types_tl_rec.last_updated_by,

Line 1215: l_okl_invc_line_types_tl_rec.description,

1211: l_okl_invc_line_types_tl_rec.LANGUAGE,
1212: l_okl_invc_line_types_tl_rec.source_lang,
1213: l_okl_invc_line_types_tl_rec.sfwt_flag,
1214: l_okl_invc_line_types_tl_rec.name,
1215: l_okl_invc_line_types_tl_rec.description,
1216: l_okl_invc_line_types_tl_rec.created_by,
1217: l_okl_invc_line_types_tl_rec.creation_date,
1218: l_okl_invc_line_types_tl_rec.last_updated_by,
1219: l_okl_invc_line_types_tl_rec.last_update_date,

Line 1216: l_okl_invc_line_types_tl_rec.created_by,

1212: l_okl_invc_line_types_tl_rec.source_lang,
1213: l_okl_invc_line_types_tl_rec.sfwt_flag,
1214: l_okl_invc_line_types_tl_rec.name,
1215: l_okl_invc_line_types_tl_rec.description,
1216: l_okl_invc_line_types_tl_rec.created_by,
1217: l_okl_invc_line_types_tl_rec.creation_date,
1218: l_okl_invc_line_types_tl_rec.last_updated_by,
1219: l_okl_invc_line_types_tl_rec.last_update_date,
1220: l_okl_invc_line_types_tl_rec.last_update_login);

Line 1217: l_okl_invc_line_types_tl_rec.creation_date,

1213: l_okl_invc_line_types_tl_rec.sfwt_flag,
1214: l_okl_invc_line_types_tl_rec.name,
1215: l_okl_invc_line_types_tl_rec.description,
1216: l_okl_invc_line_types_tl_rec.created_by,
1217: l_okl_invc_line_types_tl_rec.creation_date,
1218: l_okl_invc_line_types_tl_rec.last_updated_by,
1219: l_okl_invc_line_types_tl_rec.last_update_date,
1220: l_okl_invc_line_types_tl_rec.last_update_login);
1221: END LOOP;

Line 1218: l_okl_invc_line_types_tl_rec.last_updated_by,

1214: l_okl_invc_line_types_tl_rec.name,
1215: l_okl_invc_line_types_tl_rec.description,
1216: l_okl_invc_line_types_tl_rec.created_by,
1217: l_okl_invc_line_types_tl_rec.creation_date,
1218: l_okl_invc_line_types_tl_rec.last_updated_by,
1219: l_okl_invc_line_types_tl_rec.last_update_date,
1220: l_okl_invc_line_types_tl_rec.last_update_login);
1221: END LOOP;
1222: -- Set OUT values

Line 1219: l_okl_invc_line_types_tl_rec.last_update_date,

1215: l_okl_invc_line_types_tl_rec.description,
1216: l_okl_invc_line_types_tl_rec.created_by,
1217: l_okl_invc_line_types_tl_rec.creation_date,
1218: l_okl_invc_line_types_tl_rec.last_updated_by,
1219: l_okl_invc_line_types_tl_rec.last_update_date,
1220: l_okl_invc_line_types_tl_rec.last_update_login);
1221: END LOOP;
1222: -- Set OUT values
1223: x_okl_invc_line_types_tl_rec := l_okl_invc_line_types_tl_rec;

Line 1220: l_okl_invc_line_types_tl_rec.last_update_login);

1216: l_okl_invc_line_types_tl_rec.created_by,
1217: l_okl_invc_line_types_tl_rec.creation_date,
1218: l_okl_invc_line_types_tl_rec.last_updated_by,
1219: l_okl_invc_line_types_tl_rec.last_update_date,
1220: l_okl_invc_line_types_tl_rec.last_update_login);
1221: END LOOP;
1222: -- Set OUT values
1223: x_okl_invc_line_types_tl_rec := l_okl_invc_line_types_tl_rec;
1224: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1223: x_okl_invc_line_types_tl_rec := l_okl_invc_line_types_tl_rec;

1219: l_okl_invc_line_types_tl_rec.last_update_date,
1220: l_okl_invc_line_types_tl_rec.last_update_login);
1221: END LOOP;
1222: -- Set OUT values
1223: x_okl_invc_line_types_tl_rec := l_okl_invc_line_types_tl_rec;
1224: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
1225: EXCEPTION
1226: WHEN okl_api.G_EXCEPTION_ERROR THEN
1227: x_return_status := okl_api.HANDLE_EXCEPTIONS

Line 1276: l_okl_invc_line_types_tl_rec OklInvcLineTypesTlRecType;

1272: l_iltv_rec iltv_rec_type;
1273: l_def_iltv_rec iltv_rec_type;
1274: l_ilt_rec ilt_rec_type;
1275: lx_ilt_rec ilt_rec_type;
1276: l_okl_invc_line_types_tl_rec OklInvcLineTypesTlRecType;
1277: lx_okl_invc_line_types_tl_rec OklInvcLineTypesTlRecType;
1278: -------------------------------
1279: -- FUNCTION fill_who_columns --
1280: -------------------------------

Line 1277: lx_okl_invc_line_types_tl_rec OklInvcLineTypesTlRecType;

1273: l_def_iltv_rec iltv_rec_type;
1274: l_ilt_rec ilt_rec_type;
1275: lx_ilt_rec ilt_rec_type;
1276: l_okl_invc_line_types_tl_rec OklInvcLineTypesTlRecType;
1277: lx_okl_invc_line_types_tl_rec OklInvcLineTypesTlRecType;
1278: -------------------------------
1279: -- FUNCTION fill_who_columns --
1280: -------------------------------
1281: FUNCTION fill_who_columns (

Line 1352: migrate(l_def_iltv_rec, l_okl_invc_line_types_tl_rec);

1348: --------------------------------------
1349: -- Move VIEW record to "Child" records
1350: --------------------------------------
1351: migrate(l_def_iltv_rec, l_ilt_rec);
1352: migrate(l_def_iltv_rec, l_okl_invc_line_types_tl_rec);
1353: --------------------------------------------
1354: -- Call the INSERT_ROW for each child record
1355: --------------------------------------------
1356: insert_row(

Line 1375: l_okl_invc_line_types_tl_rec,

1371: p_init_msg_list,
1372: x_return_status,
1373: x_msg_count,
1374: x_msg_data,
1375: l_okl_invc_line_types_tl_rec,
1376: lx_okl_invc_line_types_tl_rec
1377: );
1378: IF (x_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
1379: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1376: lx_okl_invc_line_types_tl_rec

1372: x_return_status,
1373: x_msg_count,
1374: x_msg_data,
1375: l_okl_invc_line_types_tl_rec,
1376: lx_okl_invc_line_types_tl_rec
1377: );
1378: IF (x_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
1379: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
1380: ELSIF (x_return_status = okl_api.G_RET_STS_ERROR) THEN

Line 1383: migrate(lx_okl_invc_line_types_tl_rec, l_def_iltv_rec);

1379: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
1380: ELSIF (x_return_status = okl_api.G_RET_STS_ERROR) THEN
1381: RAISE okl_api.G_EXCEPTION_ERROR;
1382: END IF;
1383: migrate(lx_okl_invc_line_types_tl_rec, l_def_iltv_rec);
1384: -- Set OUT values
1385: x_iltv_rec := l_def_iltv_rec;
1386: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
1387: EXCEPTION

Line 1605: -- lock_row for:OKL_INVC_LINE_TYPES_TL --

1601: '_PVT'
1602: );
1603: END lock_row;
1604: -----------------------------------------
1605: -- lock_row for:OKL_INVC_LINE_TYPES_TL --
1606: -----------------------------------------
1607: PROCEDURE lock_row(
1608: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
1609: x_return_status OUT NOCOPY VARCHAR2,

Line 1612: p_okl_invc_line_types_tl_rec IN OklInvcLineTypesTlRecType) IS

1608: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
1609: x_return_status OUT NOCOPY VARCHAR2,
1610: x_msg_count OUT NOCOPY NUMBER,
1611: x_msg_data OUT NOCOPY VARCHAR2,
1612: p_okl_invc_line_types_tl_rec IN OklInvcLineTypesTlRecType) IS
1613:
1614: E_Resource_Busy EXCEPTION;
1615: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1616: CURSOR lock_csr (p_okl_invc_line_types_tl_rec IN OklInvcLineTypesTlRecType) IS

Line 1616: CURSOR lock_csr (p_okl_invc_line_types_tl_rec IN OklInvcLineTypesTlRecType) IS

1612: p_okl_invc_line_types_tl_rec IN OklInvcLineTypesTlRecType) IS
1613:
1614: E_Resource_Busy EXCEPTION;
1615: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1616: CURSOR lock_csr (p_okl_invc_line_types_tl_rec IN OklInvcLineTypesTlRecType) IS
1617: SELECT *
1618: FROM OKL_INVC_LINE_TYPES_TL
1619: WHERE ID = p_okl_invc_line_types_tl_rec.id
1620: FOR UPDATE NOWAIT;

Line 1618: FROM OKL_INVC_LINE_TYPES_TL

1614: E_Resource_Busy EXCEPTION;
1615: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1616: CURSOR lock_csr (p_okl_invc_line_types_tl_rec IN OklInvcLineTypesTlRecType) IS
1617: SELECT *
1618: FROM OKL_INVC_LINE_TYPES_TL
1619: WHERE ID = p_okl_invc_line_types_tl_rec.id
1620: FOR UPDATE NOWAIT;
1621:
1622: l_api_version CONSTANT NUMBER := 1;

Line 1619: WHERE ID = p_okl_invc_line_types_tl_rec.id

1615: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1616: CURSOR lock_csr (p_okl_invc_line_types_tl_rec IN OklInvcLineTypesTlRecType) IS
1617: SELECT *
1618: FROM OKL_INVC_LINE_TYPES_TL
1619: WHERE ID = p_okl_invc_line_types_tl_rec.id
1620: FOR UPDATE NOWAIT;
1621:
1622: l_api_version CONSTANT NUMBER := 1;
1623: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';

Line 1639: OPEN lock_csr(p_okl_invc_line_types_tl_rec);

1635: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
1636: RAISE okl_api.G_EXCEPTION_ERROR;
1637: END IF;
1638: BEGIN
1639: OPEN lock_csr(p_okl_invc_line_types_tl_rec);
1640: FETCH lock_csr INTO l_lock_var;
1641: l_row_notfound := lock_csr%NOTFOUND;
1642: CLOSE lock_csr;
1643: EXCEPTION

Line 1704: l_okl_invc_line_types_tl_rec OklInvcLineTypesTlRecType;

1700: l_api_version CONSTANT NUMBER := 1;
1701: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1702: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
1703: l_ilt_rec ilt_rec_type;
1704: l_okl_invc_line_types_tl_rec OklInvcLineTypesTlRecType;
1705: BEGIN
1706: l_return_status := okl_api.START_ACTIVITY(l_api_name,
1707: G_PKG_NAME,
1708: p_init_msg_list,

Line 1722: migrate(p_iltv_rec, l_okl_invc_line_types_tl_rec);

1718: --------------------------------------
1719: -- Move VIEW record to "Child" records
1720: --------------------------------------
1721: migrate(p_iltv_rec, l_ilt_rec);
1722: migrate(p_iltv_rec, l_okl_invc_line_types_tl_rec);
1723: --------------------------------------------
1724: -- Call the LOCK_ROW for each child record
1725: --------------------------------------------
1726: lock_row(

Line 1743: l_okl_invc_line_types_tl_rec

1739: p_init_msg_list,
1740: x_return_status,
1741: x_msg_count,
1742: x_msg_data,
1743: l_okl_invc_line_types_tl_rec
1744: );
1745: IF (x_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
1746: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
1747: ELSIF (x_return_status = okl_api.G_RET_STS_ERROR) THEN

Line 2096: -- update_row for:OKL_INVC_LINE_TYPES_TL --

2092: '_PVT'
2093: );
2094: END update_row;
2095: -------------------------------------------
2096: -- update_row for:OKL_INVC_LINE_TYPES_TL --
2097: -------------------------------------------
2098: PROCEDURE update_row(
2099: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
2100: x_return_status OUT NOCOPY VARCHAR2,

Line 2103: p_okl_invc_line_types_tl_rec IN OklInvcLineTypesTlRecType,

2099: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
2100: x_return_status OUT NOCOPY VARCHAR2,
2101: x_msg_count OUT NOCOPY NUMBER,
2102: x_msg_data OUT NOCOPY VARCHAR2,
2103: p_okl_invc_line_types_tl_rec IN OklInvcLineTypesTlRecType,
2104: x_okl_invc_line_types_tl_rec OUT NOCOPY OklInvcLineTypesTlRecType) IS
2105:
2106: l_api_version CONSTANT NUMBER := 1;
2107: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';

Line 2104: x_okl_invc_line_types_tl_rec OUT NOCOPY OklInvcLineTypesTlRecType) IS

2100: x_return_status OUT NOCOPY VARCHAR2,
2101: x_msg_count OUT NOCOPY NUMBER,
2102: x_msg_data OUT NOCOPY VARCHAR2,
2103: p_okl_invc_line_types_tl_rec IN OklInvcLineTypesTlRecType,
2104: x_okl_invc_line_types_tl_rec OUT NOCOPY OklInvcLineTypesTlRecType) IS
2105:
2106: l_api_version CONSTANT NUMBER := 1;
2107: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2108: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;

Line 2109: l_okl_invc_line_types_tl_rec OklInvcLineTypesTlRecType := p_okl_invc_line_types_tl_rec;

2105:
2106: l_api_version CONSTANT NUMBER := 1;
2107: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2108: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2109: l_okl_invc_line_types_tl_rec OklInvcLineTypesTlRecType := p_okl_invc_line_types_tl_rec;
2110: ldefoklinvclinetypestlrec OklInvcLineTypesTlRecType;
2111: l_row_notfound BOOLEAN := TRUE;
2112: ----------------------------------
2113: -- FUNCTION populate_new_record --

Line 2116: p_okl_invc_line_types_tl_rec IN OklInvcLineTypesTlRecType,

2112: ----------------------------------
2113: -- FUNCTION populate_new_record --
2114: ----------------------------------
2115: FUNCTION populate_new_record (
2116: p_okl_invc_line_types_tl_rec IN OklInvcLineTypesTlRecType,
2117: x_okl_invc_line_types_tl_rec OUT NOCOPY OklInvcLineTypesTlRecType
2118: ) RETURN VARCHAR2 IS
2119: l_okl_invc_line_types_tl_rec OklInvcLineTypesTlRecType;
2120: l_row_notfound BOOLEAN := TRUE;

Line 2117: x_okl_invc_line_types_tl_rec OUT NOCOPY OklInvcLineTypesTlRecType

2113: -- FUNCTION populate_new_record --
2114: ----------------------------------
2115: FUNCTION populate_new_record (
2116: p_okl_invc_line_types_tl_rec IN OklInvcLineTypesTlRecType,
2117: x_okl_invc_line_types_tl_rec OUT NOCOPY OklInvcLineTypesTlRecType
2118: ) RETURN VARCHAR2 IS
2119: l_okl_invc_line_types_tl_rec OklInvcLineTypesTlRecType;
2120: l_row_notfound BOOLEAN := TRUE;
2121: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;

Line 2119: l_okl_invc_line_types_tl_rec OklInvcLineTypesTlRecType;

2115: FUNCTION populate_new_record (
2116: p_okl_invc_line_types_tl_rec IN OklInvcLineTypesTlRecType,
2117: x_okl_invc_line_types_tl_rec OUT NOCOPY OklInvcLineTypesTlRecType
2118: ) RETURN VARCHAR2 IS
2119: l_okl_invc_line_types_tl_rec OklInvcLineTypesTlRecType;
2120: l_row_notfound BOOLEAN := TRUE;
2121: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2122: BEGIN
2123: x_okl_invc_line_types_tl_rec := p_okl_invc_line_types_tl_rec;

Line 2123: x_okl_invc_line_types_tl_rec := p_okl_invc_line_types_tl_rec;

2119: l_okl_invc_line_types_tl_rec OklInvcLineTypesTlRecType;
2120: l_row_notfound BOOLEAN := TRUE;
2121: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2122: BEGIN
2123: x_okl_invc_line_types_tl_rec := p_okl_invc_line_types_tl_rec;
2124: -- Get current database values
2125: l_okl_invc_line_types_tl_rec := get_rec(p_okl_invc_line_types_tl_rec, l_row_notfound);
2126: IF (l_row_notfound) THEN
2127: l_return_status := okl_api.G_RET_STS_UNEXP_ERROR;

Line 2125: l_okl_invc_line_types_tl_rec := get_rec(p_okl_invc_line_types_tl_rec, l_row_notfound);

2121: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2122: BEGIN
2123: x_okl_invc_line_types_tl_rec := p_okl_invc_line_types_tl_rec;
2124: -- Get current database values
2125: l_okl_invc_line_types_tl_rec := get_rec(p_okl_invc_line_types_tl_rec, l_row_notfound);
2126: IF (l_row_notfound) THEN
2127: l_return_status := okl_api.G_RET_STS_UNEXP_ERROR;
2128: END IF;
2129: IF (x_okl_invc_line_types_tl_rec.id = okl_api.G_MISS_NUM)

Line 2129: IF (x_okl_invc_line_types_tl_rec.id = okl_api.G_MISS_NUM)

2125: l_okl_invc_line_types_tl_rec := get_rec(p_okl_invc_line_types_tl_rec, l_row_notfound);
2126: IF (l_row_notfound) THEN
2127: l_return_status := okl_api.G_RET_STS_UNEXP_ERROR;
2128: END IF;
2129: IF (x_okl_invc_line_types_tl_rec.id = okl_api.G_MISS_NUM)
2130: THEN
2131: x_okl_invc_line_types_tl_rec.id := l_okl_invc_line_types_tl_rec.id;
2132: END IF;
2133: IF (x_okl_invc_line_types_tl_rec.LANGUAGE = okl_api.G_MISS_CHAR)

Line 2131: x_okl_invc_line_types_tl_rec.id := l_okl_invc_line_types_tl_rec.id;

2127: l_return_status := okl_api.G_RET_STS_UNEXP_ERROR;
2128: END IF;
2129: IF (x_okl_invc_line_types_tl_rec.id = okl_api.G_MISS_NUM)
2130: THEN
2131: x_okl_invc_line_types_tl_rec.id := l_okl_invc_line_types_tl_rec.id;
2132: END IF;
2133: IF (x_okl_invc_line_types_tl_rec.LANGUAGE = okl_api.G_MISS_CHAR)
2134: THEN
2135: x_okl_invc_line_types_tl_rec.LANGUAGE := l_okl_invc_line_types_tl_rec.LANGUAGE;

Line 2133: IF (x_okl_invc_line_types_tl_rec.LANGUAGE = okl_api.G_MISS_CHAR)

2129: IF (x_okl_invc_line_types_tl_rec.id = okl_api.G_MISS_NUM)
2130: THEN
2131: x_okl_invc_line_types_tl_rec.id := l_okl_invc_line_types_tl_rec.id;
2132: END IF;
2133: IF (x_okl_invc_line_types_tl_rec.LANGUAGE = okl_api.G_MISS_CHAR)
2134: THEN
2135: x_okl_invc_line_types_tl_rec.LANGUAGE := l_okl_invc_line_types_tl_rec.LANGUAGE;
2136: END IF;
2137: IF (x_okl_invc_line_types_tl_rec.source_lang = okl_api.G_MISS_CHAR)

Line 2135: x_okl_invc_line_types_tl_rec.LANGUAGE := l_okl_invc_line_types_tl_rec.LANGUAGE;

2131: x_okl_invc_line_types_tl_rec.id := l_okl_invc_line_types_tl_rec.id;
2132: END IF;
2133: IF (x_okl_invc_line_types_tl_rec.LANGUAGE = okl_api.G_MISS_CHAR)
2134: THEN
2135: x_okl_invc_line_types_tl_rec.LANGUAGE := l_okl_invc_line_types_tl_rec.LANGUAGE;
2136: END IF;
2137: IF (x_okl_invc_line_types_tl_rec.source_lang = okl_api.G_MISS_CHAR)
2138: THEN
2139: x_okl_invc_line_types_tl_rec.source_lang := l_okl_invc_line_types_tl_rec.source_lang;

Line 2137: IF (x_okl_invc_line_types_tl_rec.source_lang = okl_api.G_MISS_CHAR)

2133: IF (x_okl_invc_line_types_tl_rec.LANGUAGE = okl_api.G_MISS_CHAR)
2134: THEN
2135: x_okl_invc_line_types_tl_rec.LANGUAGE := l_okl_invc_line_types_tl_rec.LANGUAGE;
2136: END IF;
2137: IF (x_okl_invc_line_types_tl_rec.source_lang = okl_api.G_MISS_CHAR)
2138: THEN
2139: x_okl_invc_line_types_tl_rec.source_lang := l_okl_invc_line_types_tl_rec.source_lang;
2140: END IF;
2141: IF (x_okl_invc_line_types_tl_rec.sfwt_flag = okl_api.G_MISS_CHAR)

Line 2139: x_okl_invc_line_types_tl_rec.source_lang := l_okl_invc_line_types_tl_rec.source_lang;

2135: x_okl_invc_line_types_tl_rec.LANGUAGE := l_okl_invc_line_types_tl_rec.LANGUAGE;
2136: END IF;
2137: IF (x_okl_invc_line_types_tl_rec.source_lang = okl_api.G_MISS_CHAR)
2138: THEN
2139: x_okl_invc_line_types_tl_rec.source_lang := l_okl_invc_line_types_tl_rec.source_lang;
2140: END IF;
2141: IF (x_okl_invc_line_types_tl_rec.sfwt_flag = okl_api.G_MISS_CHAR)
2142: THEN
2143: x_okl_invc_line_types_tl_rec.sfwt_flag := l_okl_invc_line_types_tl_rec.sfwt_flag;

Line 2141: IF (x_okl_invc_line_types_tl_rec.sfwt_flag = okl_api.G_MISS_CHAR)

2137: IF (x_okl_invc_line_types_tl_rec.source_lang = okl_api.G_MISS_CHAR)
2138: THEN
2139: x_okl_invc_line_types_tl_rec.source_lang := l_okl_invc_line_types_tl_rec.source_lang;
2140: END IF;
2141: IF (x_okl_invc_line_types_tl_rec.sfwt_flag = okl_api.G_MISS_CHAR)
2142: THEN
2143: x_okl_invc_line_types_tl_rec.sfwt_flag := l_okl_invc_line_types_tl_rec.sfwt_flag;
2144: END IF;
2145: IF (x_okl_invc_line_types_tl_rec.name = okl_api.G_MISS_CHAR)

Line 2143: x_okl_invc_line_types_tl_rec.sfwt_flag := l_okl_invc_line_types_tl_rec.sfwt_flag;

2139: x_okl_invc_line_types_tl_rec.source_lang := l_okl_invc_line_types_tl_rec.source_lang;
2140: END IF;
2141: IF (x_okl_invc_line_types_tl_rec.sfwt_flag = okl_api.G_MISS_CHAR)
2142: THEN
2143: x_okl_invc_line_types_tl_rec.sfwt_flag := l_okl_invc_line_types_tl_rec.sfwt_flag;
2144: END IF;
2145: IF (x_okl_invc_line_types_tl_rec.name = okl_api.G_MISS_CHAR)
2146: THEN
2147: x_okl_invc_line_types_tl_rec.name := l_okl_invc_line_types_tl_rec.name;

Line 2145: IF (x_okl_invc_line_types_tl_rec.name = okl_api.G_MISS_CHAR)

2141: IF (x_okl_invc_line_types_tl_rec.sfwt_flag = okl_api.G_MISS_CHAR)
2142: THEN
2143: x_okl_invc_line_types_tl_rec.sfwt_flag := l_okl_invc_line_types_tl_rec.sfwt_flag;
2144: END IF;
2145: IF (x_okl_invc_line_types_tl_rec.name = okl_api.G_MISS_CHAR)
2146: THEN
2147: x_okl_invc_line_types_tl_rec.name := l_okl_invc_line_types_tl_rec.name;
2148: END IF;
2149: IF (x_okl_invc_line_types_tl_rec.description = okl_api.G_MISS_CHAR)

Line 2147: x_okl_invc_line_types_tl_rec.name := l_okl_invc_line_types_tl_rec.name;

2143: x_okl_invc_line_types_tl_rec.sfwt_flag := l_okl_invc_line_types_tl_rec.sfwt_flag;
2144: END IF;
2145: IF (x_okl_invc_line_types_tl_rec.name = okl_api.G_MISS_CHAR)
2146: THEN
2147: x_okl_invc_line_types_tl_rec.name := l_okl_invc_line_types_tl_rec.name;
2148: END IF;
2149: IF (x_okl_invc_line_types_tl_rec.description = okl_api.G_MISS_CHAR)
2150: THEN
2151: x_okl_invc_line_types_tl_rec.description := l_okl_invc_line_types_tl_rec.description;

Line 2149: IF (x_okl_invc_line_types_tl_rec.description = okl_api.G_MISS_CHAR)

2145: IF (x_okl_invc_line_types_tl_rec.name = okl_api.G_MISS_CHAR)
2146: THEN
2147: x_okl_invc_line_types_tl_rec.name := l_okl_invc_line_types_tl_rec.name;
2148: END IF;
2149: IF (x_okl_invc_line_types_tl_rec.description = okl_api.G_MISS_CHAR)
2150: THEN
2151: x_okl_invc_line_types_tl_rec.description := l_okl_invc_line_types_tl_rec.description;
2152: END IF;
2153: IF (x_okl_invc_line_types_tl_rec.created_by = okl_api.G_MISS_NUM)

Line 2151: x_okl_invc_line_types_tl_rec.description := l_okl_invc_line_types_tl_rec.description;

2147: x_okl_invc_line_types_tl_rec.name := l_okl_invc_line_types_tl_rec.name;
2148: END IF;
2149: IF (x_okl_invc_line_types_tl_rec.description = okl_api.G_MISS_CHAR)
2150: THEN
2151: x_okl_invc_line_types_tl_rec.description := l_okl_invc_line_types_tl_rec.description;
2152: END IF;
2153: IF (x_okl_invc_line_types_tl_rec.created_by = okl_api.G_MISS_NUM)
2154: THEN
2155: x_okl_invc_line_types_tl_rec.created_by := l_okl_invc_line_types_tl_rec.created_by;

Line 2153: IF (x_okl_invc_line_types_tl_rec.created_by = okl_api.G_MISS_NUM)

2149: IF (x_okl_invc_line_types_tl_rec.description = okl_api.G_MISS_CHAR)
2150: THEN
2151: x_okl_invc_line_types_tl_rec.description := l_okl_invc_line_types_tl_rec.description;
2152: END IF;
2153: IF (x_okl_invc_line_types_tl_rec.created_by = okl_api.G_MISS_NUM)
2154: THEN
2155: x_okl_invc_line_types_tl_rec.created_by := l_okl_invc_line_types_tl_rec.created_by;
2156: END IF;
2157: IF (x_okl_invc_line_types_tl_rec.creation_date = okl_api.G_MISS_DATE)

Line 2155: x_okl_invc_line_types_tl_rec.created_by := l_okl_invc_line_types_tl_rec.created_by;

2151: x_okl_invc_line_types_tl_rec.description := l_okl_invc_line_types_tl_rec.description;
2152: END IF;
2153: IF (x_okl_invc_line_types_tl_rec.created_by = okl_api.G_MISS_NUM)
2154: THEN
2155: x_okl_invc_line_types_tl_rec.created_by := l_okl_invc_line_types_tl_rec.created_by;
2156: END IF;
2157: IF (x_okl_invc_line_types_tl_rec.creation_date = okl_api.G_MISS_DATE)
2158: THEN
2159: x_okl_invc_line_types_tl_rec.creation_date := l_okl_invc_line_types_tl_rec.creation_date;

Line 2157: IF (x_okl_invc_line_types_tl_rec.creation_date = okl_api.G_MISS_DATE)

2153: IF (x_okl_invc_line_types_tl_rec.created_by = okl_api.G_MISS_NUM)
2154: THEN
2155: x_okl_invc_line_types_tl_rec.created_by := l_okl_invc_line_types_tl_rec.created_by;
2156: END IF;
2157: IF (x_okl_invc_line_types_tl_rec.creation_date = okl_api.G_MISS_DATE)
2158: THEN
2159: x_okl_invc_line_types_tl_rec.creation_date := l_okl_invc_line_types_tl_rec.creation_date;
2160: END IF;
2161: IF (x_okl_invc_line_types_tl_rec.last_updated_by = okl_api.G_MISS_NUM)

Line 2159: x_okl_invc_line_types_tl_rec.creation_date := l_okl_invc_line_types_tl_rec.creation_date;

2155: x_okl_invc_line_types_tl_rec.created_by := l_okl_invc_line_types_tl_rec.created_by;
2156: END IF;
2157: IF (x_okl_invc_line_types_tl_rec.creation_date = okl_api.G_MISS_DATE)
2158: THEN
2159: x_okl_invc_line_types_tl_rec.creation_date := l_okl_invc_line_types_tl_rec.creation_date;
2160: END IF;
2161: IF (x_okl_invc_line_types_tl_rec.last_updated_by = okl_api.G_MISS_NUM)
2162: THEN
2163: x_okl_invc_line_types_tl_rec.last_updated_by := l_okl_invc_line_types_tl_rec.last_updated_by;

Line 2161: IF (x_okl_invc_line_types_tl_rec.last_updated_by = okl_api.G_MISS_NUM)

2157: IF (x_okl_invc_line_types_tl_rec.creation_date = okl_api.G_MISS_DATE)
2158: THEN
2159: x_okl_invc_line_types_tl_rec.creation_date := l_okl_invc_line_types_tl_rec.creation_date;
2160: END IF;
2161: IF (x_okl_invc_line_types_tl_rec.last_updated_by = okl_api.G_MISS_NUM)
2162: THEN
2163: x_okl_invc_line_types_tl_rec.last_updated_by := l_okl_invc_line_types_tl_rec.last_updated_by;
2164: END IF;
2165: IF (x_okl_invc_line_types_tl_rec.last_update_date = okl_api.G_MISS_DATE)

Line 2163: x_okl_invc_line_types_tl_rec.last_updated_by := l_okl_invc_line_types_tl_rec.last_updated_by;

2159: x_okl_invc_line_types_tl_rec.creation_date := l_okl_invc_line_types_tl_rec.creation_date;
2160: END IF;
2161: IF (x_okl_invc_line_types_tl_rec.last_updated_by = okl_api.G_MISS_NUM)
2162: THEN
2163: x_okl_invc_line_types_tl_rec.last_updated_by := l_okl_invc_line_types_tl_rec.last_updated_by;
2164: END IF;
2165: IF (x_okl_invc_line_types_tl_rec.last_update_date = okl_api.G_MISS_DATE)
2166: THEN
2167: x_okl_invc_line_types_tl_rec.last_update_date := l_okl_invc_line_types_tl_rec.last_update_date;

Line 2165: IF (x_okl_invc_line_types_tl_rec.last_update_date = okl_api.G_MISS_DATE)

2161: IF (x_okl_invc_line_types_tl_rec.last_updated_by = okl_api.G_MISS_NUM)
2162: THEN
2163: x_okl_invc_line_types_tl_rec.last_updated_by := l_okl_invc_line_types_tl_rec.last_updated_by;
2164: END IF;
2165: IF (x_okl_invc_line_types_tl_rec.last_update_date = okl_api.G_MISS_DATE)
2166: THEN
2167: x_okl_invc_line_types_tl_rec.last_update_date := l_okl_invc_line_types_tl_rec.last_update_date;
2168: END IF;
2169: IF (x_okl_invc_line_types_tl_rec.last_update_login = okl_api.G_MISS_NUM)

Line 2167: x_okl_invc_line_types_tl_rec.last_update_date := l_okl_invc_line_types_tl_rec.last_update_date;

2163: x_okl_invc_line_types_tl_rec.last_updated_by := l_okl_invc_line_types_tl_rec.last_updated_by;
2164: END IF;
2165: IF (x_okl_invc_line_types_tl_rec.last_update_date = okl_api.G_MISS_DATE)
2166: THEN
2167: x_okl_invc_line_types_tl_rec.last_update_date := l_okl_invc_line_types_tl_rec.last_update_date;
2168: END IF;
2169: IF (x_okl_invc_line_types_tl_rec.last_update_login = okl_api.G_MISS_NUM)
2170: THEN
2171: x_okl_invc_line_types_tl_rec.last_update_login := l_okl_invc_line_types_tl_rec.last_update_login;

Line 2169: IF (x_okl_invc_line_types_tl_rec.last_update_login = okl_api.G_MISS_NUM)

2165: IF (x_okl_invc_line_types_tl_rec.last_update_date = okl_api.G_MISS_DATE)
2166: THEN
2167: x_okl_invc_line_types_tl_rec.last_update_date := l_okl_invc_line_types_tl_rec.last_update_date;
2168: END IF;
2169: IF (x_okl_invc_line_types_tl_rec.last_update_login = okl_api.G_MISS_NUM)
2170: THEN
2171: x_okl_invc_line_types_tl_rec.last_update_login := l_okl_invc_line_types_tl_rec.last_update_login;
2172: END IF;
2173: RETURN(l_return_status);

Line 2171: x_okl_invc_line_types_tl_rec.last_update_login := l_okl_invc_line_types_tl_rec.last_update_login;

2167: x_okl_invc_line_types_tl_rec.last_update_date := l_okl_invc_line_types_tl_rec.last_update_date;
2168: END IF;
2169: IF (x_okl_invc_line_types_tl_rec.last_update_login = okl_api.G_MISS_NUM)
2170: THEN
2171: x_okl_invc_line_types_tl_rec.last_update_login := l_okl_invc_line_types_tl_rec.last_update_login;
2172: END IF;
2173: RETURN(l_return_status);
2174: END populate_new_record;
2175: -----------------------------------------------

Line 2176: -- Set_Attributes for:OKL_INVC_LINE_TYPES_TL --

2172: END IF;
2173: RETURN(l_return_status);
2174: END populate_new_record;
2175: -----------------------------------------------
2176: -- Set_Attributes for:OKL_INVC_LINE_TYPES_TL --
2177: -----------------------------------------------
2178: FUNCTION Set_Attributes (
2179: p_okl_invc_line_types_tl_rec IN OklInvcLineTypesTlRecType,
2180: x_okl_invc_line_types_tl_rec OUT NOCOPY OklInvcLineTypesTlRecType

Line 2179: p_okl_invc_line_types_tl_rec IN OklInvcLineTypesTlRecType,

2175: -----------------------------------------------
2176: -- Set_Attributes for:OKL_INVC_LINE_TYPES_TL --
2177: -----------------------------------------------
2178: FUNCTION Set_Attributes (
2179: p_okl_invc_line_types_tl_rec IN OklInvcLineTypesTlRecType,
2180: x_okl_invc_line_types_tl_rec OUT NOCOPY OklInvcLineTypesTlRecType
2181: ) RETURN VARCHAR2 IS
2182: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2183: BEGIN

Line 2180: x_okl_invc_line_types_tl_rec OUT NOCOPY OklInvcLineTypesTlRecType

2176: -- Set_Attributes for:OKL_INVC_LINE_TYPES_TL --
2177: -----------------------------------------------
2178: FUNCTION Set_Attributes (
2179: p_okl_invc_line_types_tl_rec IN OklInvcLineTypesTlRecType,
2180: x_okl_invc_line_types_tl_rec OUT NOCOPY OklInvcLineTypesTlRecType
2181: ) RETURN VARCHAR2 IS
2182: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2183: BEGIN
2184: x_okl_invc_line_types_tl_rec := p_okl_invc_line_types_tl_rec;

Line 2184: x_okl_invc_line_types_tl_rec := p_okl_invc_line_types_tl_rec;

2180: x_okl_invc_line_types_tl_rec OUT NOCOPY OklInvcLineTypesTlRecType
2181: ) RETURN VARCHAR2 IS
2182: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2183: BEGIN
2184: x_okl_invc_line_types_tl_rec := p_okl_invc_line_types_tl_rec;
2185: x_okl_invc_line_types_tl_rec.LANGUAGE := USERENV('LANG');
2186: x_okl_invc_line_types_tl_rec.SOURCE_LANG := USERENV('LANG');
2187: RETURN(l_return_status);
2188: END Set_Attributes;

Line 2185: x_okl_invc_line_types_tl_rec.LANGUAGE := USERENV('LANG');

2181: ) RETURN VARCHAR2 IS
2182: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2183: BEGIN
2184: x_okl_invc_line_types_tl_rec := p_okl_invc_line_types_tl_rec;
2185: x_okl_invc_line_types_tl_rec.LANGUAGE := USERENV('LANG');
2186: x_okl_invc_line_types_tl_rec.SOURCE_LANG := USERENV('LANG');
2187: RETURN(l_return_status);
2188: END Set_Attributes;
2189: BEGIN

Line 2186: x_okl_invc_line_types_tl_rec.SOURCE_LANG := USERENV('LANG');

2182: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2183: BEGIN
2184: x_okl_invc_line_types_tl_rec := p_okl_invc_line_types_tl_rec;
2185: x_okl_invc_line_types_tl_rec.LANGUAGE := USERENV('LANG');
2186: x_okl_invc_line_types_tl_rec.SOURCE_LANG := USERENV('LANG');
2187: RETURN(l_return_status);
2188: END Set_Attributes;
2189: BEGIN
2190: l_return_status := okl_api.START_ACTIVITY(l_api_name,

Line 2201: p_okl_invc_line_types_tl_rec, -- IN

2197: RAISE okl_api.G_EXCEPTION_ERROR;
2198: END IF;
2199: --- Setting item attributes
2200: l_return_status := Set_Attributes(
2201: p_okl_invc_line_types_tl_rec, -- IN
2202: l_okl_invc_line_types_tl_rec); -- OUT
2203: --- If any errors happen abort API
2204: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
2205: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2202: l_okl_invc_line_types_tl_rec); -- OUT

2198: END IF;
2199: --- Setting item attributes
2200: l_return_status := Set_Attributes(
2201: p_okl_invc_line_types_tl_rec, -- IN
2202: l_okl_invc_line_types_tl_rec); -- OUT
2203: --- If any errors happen abort API
2204: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
2205: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
2206: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN

Line 2209: l_return_status := populate_new_record(l_okl_invc_line_types_tl_rec, ldefoklinvclinetypestlrec);

2205: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
2206: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
2207: RAISE okl_api.G_EXCEPTION_ERROR;
2208: END IF;
2209: l_return_status := populate_new_record(l_okl_invc_line_types_tl_rec, ldefoklinvclinetypestlrec);
2210: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
2211: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
2212: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
2213: RAISE okl_api.G_EXCEPTION_ERROR;

Line 2215: UPDATE OKL_INVC_LINE_TYPES_TL

2211: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
2212: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
2213: RAISE okl_api.G_EXCEPTION_ERROR;
2214: END IF;
2215: UPDATE OKL_INVC_LINE_TYPES_TL
2216: SET NAME = ldefoklinvclinetypestlrec.name,
2217: DESCRIPTION = ldefoklinvclinetypestlrec.description,
2218: CREATED_BY = ldefoklinvclinetypestlrec.created_by,
2219: CREATION_DATE = ldefoklinvclinetypestlrec.creation_date,

Line 2227: UPDATE OKL_INVC_LINE_TYPES_TL

2223: WHERE ID = ldefoklinvclinetypestlrec.id
2224: --AND SOURCE_LANG = USERENV('LANG');
2225: AND USERENV('LANG') in (SOURCE_LANG, LANGUAGE);
2226:
2227: UPDATE OKL_INVC_LINE_TYPES_TL
2228: SET SFWT_FLAG = 'Y'
2229: WHERE ID = ldefoklinvclinetypestlrec.id
2230: AND SOURCE_LANG <> USERENV('LANG');
2231:

Line 2232: x_okl_invc_line_types_tl_rec := ldefoklinvclinetypestlrec;

2228: SET SFWT_FLAG = 'Y'
2229: WHERE ID = ldefoklinvclinetypestlrec.id
2230: AND SOURCE_LANG <> USERENV('LANG');
2231:
2232: x_okl_invc_line_types_tl_rec := ldefoklinvclinetypestlrec;
2233: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
2234: EXCEPTION
2235: WHEN okl_api.G_EXCEPTION_ERROR THEN
2236: x_return_status := okl_api.HANDLE_EXCEPTIONS

Line 2283: l_okl_invc_line_types_tl_rec OklInvcLineTypesTlRecType;

2279: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
2280: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2281: l_iltv_rec iltv_rec_type := p_iltv_rec;
2282: l_def_iltv_rec iltv_rec_type;
2283: l_okl_invc_line_types_tl_rec OklInvcLineTypesTlRecType;
2284: lx_okl_invc_line_types_tl_rec OklInvcLineTypesTlRecType;
2285: l_ilt_rec ilt_rec_type;
2286: lx_ilt_rec ilt_rec_type;
2287: -------------------------------

Line 2284: lx_okl_invc_line_types_tl_rec OklInvcLineTypesTlRecType;

2280: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2281: l_iltv_rec iltv_rec_type := p_iltv_rec;
2282: l_def_iltv_rec iltv_rec_type;
2283: l_okl_invc_line_types_tl_rec OklInvcLineTypesTlRecType;
2284: lx_okl_invc_line_types_tl_rec OklInvcLineTypesTlRecType;
2285: l_ilt_rec ilt_rec_type;
2286: lx_ilt_rec ilt_rec_type;
2287: -------------------------------
2288: -- FUNCTION fill_who_columns --

Line 2492: migrate(l_def_iltv_rec, l_okl_invc_line_types_tl_rec);

2488:
2489: --------------------------------------
2490: -- Move VIEW record to "Child" records
2491: --------------------------------------
2492: migrate(l_def_iltv_rec, l_okl_invc_line_types_tl_rec);
2493: migrate(l_def_iltv_rec, l_ilt_rec);
2494: --------------------------------------------
2495: -- Call the UPDATE_ROW for each child record
2496: --------------------------------------------

Line 2502: l_okl_invc_line_types_tl_rec,

2498: p_init_msg_list,
2499: x_return_status,
2500: x_msg_count,
2501: x_msg_data,
2502: l_okl_invc_line_types_tl_rec,
2503: lx_okl_invc_line_types_tl_rec
2504: );
2505: IF (x_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
2506: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2503: lx_okl_invc_line_types_tl_rec

2499: x_return_status,
2500: x_msg_count,
2501: x_msg_data,
2502: l_okl_invc_line_types_tl_rec,
2503: lx_okl_invc_line_types_tl_rec
2504: );
2505: IF (x_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
2506: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
2507: ELSIF (x_return_status = okl_api.G_RET_STS_ERROR) THEN

Line 2510: migrate(lx_okl_invc_line_types_tl_rec, l_def_iltv_rec);

2506: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
2507: ELSIF (x_return_status = okl_api.G_RET_STS_ERROR) THEN
2508: RAISE okl_api.G_EXCEPTION_ERROR;
2509: END IF;
2510: migrate(lx_okl_invc_line_types_tl_rec, l_def_iltv_rec);
2511: update_row(
2512: p_init_msg_list,
2513: x_return_status,
2514: x_msg_count,

Line 2700: -- delete_row for:OKL_INVC_LINE_TYPES_TL --

2696: '_PVT'
2697: );
2698: END delete_row;
2699: -------------------------------------------
2700: -- delete_row for:OKL_INVC_LINE_TYPES_TL --
2701: -------------------------------------------
2702: PROCEDURE delete_row(
2703: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
2704: x_return_status OUT NOCOPY VARCHAR2,

Line 2707: p_okl_invc_line_types_tl_rec IN OklInvcLineTypesTlRecType) IS

2703: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
2704: x_return_status OUT NOCOPY VARCHAR2,
2705: x_msg_count OUT NOCOPY NUMBER,
2706: x_msg_data OUT NOCOPY VARCHAR2,
2707: p_okl_invc_line_types_tl_rec IN OklInvcLineTypesTlRecType) IS
2708:
2709: l_api_version CONSTANT NUMBER := 1;
2710: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
2711: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;

Line 2712: l_okl_invc_line_types_tl_rec OklInvcLineTypesTlRecType:= p_okl_invc_line_types_tl_rec;

2708:
2709: l_api_version CONSTANT NUMBER := 1;
2710: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
2711: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2712: l_okl_invc_line_types_tl_rec OklInvcLineTypesTlRecType:= p_okl_invc_line_types_tl_rec;
2713: l_row_notfound BOOLEAN := TRUE;
2714: -----------------------------------------------
2715: -- Set_Attributes for:OKL_INVC_LINE_TYPES_TL --
2716: -----------------------------------------------

Line 2715: -- Set_Attributes for:OKL_INVC_LINE_TYPES_TL --

2711: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2712: l_okl_invc_line_types_tl_rec OklInvcLineTypesTlRecType:= p_okl_invc_line_types_tl_rec;
2713: l_row_notfound BOOLEAN := TRUE;
2714: -----------------------------------------------
2715: -- Set_Attributes for:OKL_INVC_LINE_TYPES_TL --
2716: -----------------------------------------------
2717: FUNCTION Set_Attributes (
2718: p_okl_invc_line_types_tl_rec IN OklInvcLineTypesTlRecType,
2719: x_okl_invc_line_types_tl_rec OUT NOCOPY OklInvcLineTypesTlRecType

Line 2718: p_okl_invc_line_types_tl_rec IN OklInvcLineTypesTlRecType,

2714: -----------------------------------------------
2715: -- Set_Attributes for:OKL_INVC_LINE_TYPES_TL --
2716: -----------------------------------------------
2717: FUNCTION Set_Attributes (
2718: p_okl_invc_line_types_tl_rec IN OklInvcLineTypesTlRecType,
2719: x_okl_invc_line_types_tl_rec OUT NOCOPY OklInvcLineTypesTlRecType
2720: ) RETURN VARCHAR2 IS
2721: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2722: BEGIN

Line 2719: x_okl_invc_line_types_tl_rec OUT NOCOPY OklInvcLineTypesTlRecType

2715: -- Set_Attributes for:OKL_INVC_LINE_TYPES_TL --
2716: -----------------------------------------------
2717: FUNCTION Set_Attributes (
2718: p_okl_invc_line_types_tl_rec IN OklInvcLineTypesTlRecType,
2719: x_okl_invc_line_types_tl_rec OUT NOCOPY OklInvcLineTypesTlRecType
2720: ) RETURN VARCHAR2 IS
2721: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2722: BEGIN
2723: x_okl_invc_line_types_tl_rec := p_okl_invc_line_types_tl_rec;

Line 2723: x_okl_invc_line_types_tl_rec := p_okl_invc_line_types_tl_rec;

2719: x_okl_invc_line_types_tl_rec OUT NOCOPY OklInvcLineTypesTlRecType
2720: ) RETURN VARCHAR2 IS
2721: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2722: BEGIN
2723: x_okl_invc_line_types_tl_rec := p_okl_invc_line_types_tl_rec;
2724: x_okl_invc_line_types_tl_rec.LANGUAGE := USERENV('LANG');
2725: RETURN(l_return_status);
2726: END Set_Attributes;
2727: BEGIN

Line 2724: x_okl_invc_line_types_tl_rec.LANGUAGE := USERENV('LANG');

2720: ) RETURN VARCHAR2 IS
2721: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2722: BEGIN
2723: x_okl_invc_line_types_tl_rec := p_okl_invc_line_types_tl_rec;
2724: x_okl_invc_line_types_tl_rec.LANGUAGE := USERENV('LANG');
2725: RETURN(l_return_status);
2726: END Set_Attributes;
2727: BEGIN
2728: l_return_status := okl_api.START_ACTIVITY(l_api_name,

Line 2739: p_okl_invc_line_types_tl_rec, -- IN

2735: RAISE okl_api.G_EXCEPTION_ERROR;
2736: END IF;
2737: --- Setting item attributes
2738: l_return_status := Set_Attributes(
2739: p_okl_invc_line_types_tl_rec, -- IN
2740: l_okl_invc_line_types_tl_rec); -- OUT
2741: --- If any errors happen abort API
2742: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
2743: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2740: l_okl_invc_line_types_tl_rec); -- OUT

2736: END IF;
2737: --- Setting item attributes
2738: l_return_status := Set_Attributes(
2739: p_okl_invc_line_types_tl_rec, -- IN
2740: l_okl_invc_line_types_tl_rec); -- OUT
2741: --- If any errors happen abort API
2742: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
2743: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
2744: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN

Line 2747: DELETE FROM OKL_INVC_LINE_TYPES_TL

2743: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
2744: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
2745: RAISE okl_api.G_EXCEPTION_ERROR;
2746: END IF;
2747: DELETE FROM OKL_INVC_LINE_TYPES_TL
2748: WHERE ID = l_okl_invc_line_types_tl_rec.id;
2749:
2750: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
2751: EXCEPTION

Line 2748: WHERE ID = l_okl_invc_line_types_tl_rec.id;

2744: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
2745: RAISE okl_api.G_EXCEPTION_ERROR;
2746: END IF;
2747: DELETE FROM OKL_INVC_LINE_TYPES_TL
2748: WHERE ID = l_okl_invc_line_types_tl_rec.id;
2749:
2750: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
2751: EXCEPTION
2752: WHEN okl_api.G_EXCEPTION_ERROR THEN

Line 2798: l_okl_invc_line_types_tl_rec OklInvcLineTypesTlRecType;

2794: l_api_version CONSTANT NUMBER := 1;
2795: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
2796: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2797: l_iltv_rec iltv_rec_type := p_iltv_rec;
2798: l_okl_invc_line_types_tl_rec OklInvcLineTypesTlRecType;
2799: l_ilt_rec ilt_rec_type;
2800: BEGIN
2801: l_return_status := okl_api.START_ACTIVITY(l_api_name,
2802: G_PKG_NAME,

Line 2816: migrate(l_iltv_rec, l_okl_invc_line_types_tl_rec);

2812: END IF;
2813: --------------------------------------
2814: -- Move VIEW record to "Child" records
2815: --------------------------------------
2816: migrate(l_iltv_rec, l_okl_invc_line_types_tl_rec);
2817: migrate(l_iltv_rec, l_ilt_rec);
2818: --------------------------------------------
2819: -- Call the DELETE_ROW for each child record
2820: --------------------------------------------

Line 2826: l_okl_invc_line_types_tl_rec

2822: p_init_msg_list,
2823: x_return_status,
2824: x_msg_count,
2825: x_msg_data,
2826: l_okl_invc_line_types_tl_rec
2827: );
2828: IF (x_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
2829: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
2830: ELSIF (x_return_status = okl_api.G_RET_STS_ERROR) THEN