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_ESD_PVT dependencies on OKL_XTD_SELL_INVS_TL

Line 258: DELETE FROM OKL_XTD_SELL_INVS_TL T

254: -- PROCEDURE add_language
255: ---------------------------------------------------------------------------
256: PROCEDURE add_language IS
257: BEGIN
258: DELETE FROM OKL_XTD_SELL_INVS_TL T
259: WHERE NOT EXISTS (
260: SELECT NULL
261: FROM OKL_XTD_SELL_INVS_B B --fixed bug 3321017 by kmotepal
262: WHERE B.ID = T.ID

Line 283: FROM OKL_XTD_SELL_INVS_TL SUBB, OKL_XTD_SELL_INVS_TL SUBT

279: T.LANGUAGE)
280: IN (SELECT
281: SUBT.ID,
282: SUBT.LANGUAGE
283: FROM OKL_XTD_SELL_INVS_TL SUBB, OKL_XTD_SELL_INVS_TL SUBT
284: WHERE SUBB.ID = SUBT.ID
285: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
286:
287: */

Line 289: INSERT INTO OKL_XTD_SELL_INVS_TL (

285: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
286:
287: */
288:
289: INSERT INTO OKL_XTD_SELL_INVS_TL (
290: ID,
291: LANGUAGE,
292: SOURCE_LANG,
293: SFWT_FLAG,

Line 309: FROM OKL_XTD_SELL_INVS_TL B, FND_LANGUAGES L

305: B.CREATION_DATE,
306: B.LAST_UPDATED_BY,
307: B.LAST_UPDATE_DATE,
308: B.LAST_UPDATE_LOGIN
309: FROM OKL_XTD_SELL_INVS_TL B, FND_LANGUAGES L
310: WHERE L.INSTALLED_FLAG IN ('I', 'B')
311: AND B.LANGUAGE = USERENV('LANG')
312: AND NOT EXISTS(
313: SELECT NULL

Line 314: FROM OKL_XTD_SELL_INVS_TL T

310: WHERE L.INSTALLED_FLAG IN ('I', 'B')
311: AND B.LANGUAGE = USERENV('LANG')
312: AND NOT EXISTS(
313: SELECT NULL
314: FROM OKL_XTD_SELL_INVS_TL T
315: WHERE T.ID = B.ID
316: AND T.LANGUAGE = L.LANGUAGE_CODE
317: );
318:

Line 420: -- FUNCTION get_rec for: OKL_XTD_SELL_INVS_TL

416: BEGIN
417: RETURN(get_rec(p_esd_rec, l_row_notfound));
418: END get_rec;
419: ---------------------------------------------------------------------------
420: -- FUNCTION get_rec for: OKL_XTD_SELL_INVS_TL
421: ---------------------------------------------------------------------------
422: FUNCTION get_rec (
423: p_okl_xtd_sell_invs_tl_rec IN okl_xtd_sell_invs_tl_rec_type,
424: x_no_data_found OUT NOCOPY BOOLEAN

Line 423: p_okl_xtd_sell_invs_tl_rec IN okl_xtd_sell_invs_tl_rec_type,

419: ---------------------------------------------------------------------------
420: -- FUNCTION get_rec for: OKL_XTD_SELL_INVS_TL
421: ---------------------------------------------------------------------------
422: FUNCTION get_rec (
423: p_okl_xtd_sell_invs_tl_rec IN okl_xtd_sell_invs_tl_rec_type,
424: x_no_data_found OUT NOCOPY BOOLEAN
425: ) RETURN okl_xtd_sell_invs_tl_rec_type IS
426: CURSOR okl_xtd_sell_invs_tl_pk_csr (p_id IN NUMBER,
427: p_language IN VARCHAR2) IS

Line 425: ) RETURN okl_xtd_sell_invs_tl_rec_type IS

421: ---------------------------------------------------------------------------
422: FUNCTION get_rec (
423: p_okl_xtd_sell_invs_tl_rec IN okl_xtd_sell_invs_tl_rec_type,
424: x_no_data_found OUT NOCOPY BOOLEAN
425: ) RETURN okl_xtd_sell_invs_tl_rec_type IS
426: CURSOR okl_xtd_sell_invs_tl_pk_csr (p_id IN NUMBER,
427: p_language IN VARCHAR2) IS
428: SELECT
429: ID,

Line 426: CURSOR okl_xtd_sell_invs_tl_pk_csr (p_id IN NUMBER,

422: FUNCTION get_rec (
423: p_okl_xtd_sell_invs_tl_rec IN okl_xtd_sell_invs_tl_rec_type,
424: x_no_data_found OUT NOCOPY BOOLEAN
425: ) RETURN okl_xtd_sell_invs_tl_rec_type IS
426: CURSOR okl_xtd_sell_invs_tl_pk_csr (p_id IN NUMBER,
427: p_language IN VARCHAR2) IS
428: SELECT
429: ID,
430: LANGUAGE,

Line 438: FROM Okl_Xtd_Sell_Invs_Tl

434: CREATION_DATE,
435: LAST_UPDATED_BY,
436: LAST_UPDATE_DATE,
437: LAST_UPDATE_LOGIN
438: FROM Okl_Xtd_Sell_Invs_Tl
439: WHERE okl_xtd_sell_invs_tl.id = p_id
440: AND okl_xtd_sell_invs_tl.LANGUAGE = p_language;
441: l_okl_xtd_sell_invs_tl_pk okl_xtd_sell_invs_tl_pk_csr%ROWTYPE;
442: l_okl_xtd_sell_invs_tl_rec okl_xtd_sell_invs_tl_rec_type;

Line 439: WHERE okl_xtd_sell_invs_tl.id = p_id

435: LAST_UPDATED_BY,
436: LAST_UPDATE_DATE,
437: LAST_UPDATE_LOGIN
438: FROM Okl_Xtd_Sell_Invs_Tl
439: WHERE okl_xtd_sell_invs_tl.id = p_id
440: AND okl_xtd_sell_invs_tl.LANGUAGE = p_language;
441: l_okl_xtd_sell_invs_tl_pk okl_xtd_sell_invs_tl_pk_csr%ROWTYPE;
442: l_okl_xtd_sell_invs_tl_rec okl_xtd_sell_invs_tl_rec_type;
443: BEGIN

Line 440: AND okl_xtd_sell_invs_tl.LANGUAGE = p_language;

436: LAST_UPDATE_DATE,
437: LAST_UPDATE_LOGIN
438: FROM Okl_Xtd_Sell_Invs_Tl
439: WHERE okl_xtd_sell_invs_tl.id = p_id
440: AND okl_xtd_sell_invs_tl.LANGUAGE = p_language;
441: l_okl_xtd_sell_invs_tl_pk okl_xtd_sell_invs_tl_pk_csr%ROWTYPE;
442: l_okl_xtd_sell_invs_tl_rec okl_xtd_sell_invs_tl_rec_type;
443: BEGIN
444: x_no_data_found := TRUE;

Line 441: l_okl_xtd_sell_invs_tl_pk okl_xtd_sell_invs_tl_pk_csr%ROWTYPE;

437: LAST_UPDATE_LOGIN
438: FROM Okl_Xtd_Sell_Invs_Tl
439: WHERE okl_xtd_sell_invs_tl.id = p_id
440: AND okl_xtd_sell_invs_tl.LANGUAGE = p_language;
441: l_okl_xtd_sell_invs_tl_pk okl_xtd_sell_invs_tl_pk_csr%ROWTYPE;
442: l_okl_xtd_sell_invs_tl_rec okl_xtd_sell_invs_tl_rec_type;
443: BEGIN
444: x_no_data_found := TRUE;
445: -- Get current database values

Line 442: l_okl_xtd_sell_invs_tl_rec okl_xtd_sell_invs_tl_rec_type;

438: FROM Okl_Xtd_Sell_Invs_Tl
439: WHERE okl_xtd_sell_invs_tl.id = p_id
440: AND okl_xtd_sell_invs_tl.LANGUAGE = p_language;
441: l_okl_xtd_sell_invs_tl_pk okl_xtd_sell_invs_tl_pk_csr%ROWTYPE;
442: l_okl_xtd_sell_invs_tl_rec okl_xtd_sell_invs_tl_rec_type;
443: BEGIN
444: x_no_data_found := TRUE;
445: -- Get current database values
446: OPEN okl_xtd_sell_invs_tl_pk_csr (p_okl_xtd_sell_invs_tl_rec.id,

Line 446: OPEN okl_xtd_sell_invs_tl_pk_csr (p_okl_xtd_sell_invs_tl_rec.id,

442: l_okl_xtd_sell_invs_tl_rec okl_xtd_sell_invs_tl_rec_type;
443: BEGIN
444: x_no_data_found := TRUE;
445: -- Get current database values
446: OPEN okl_xtd_sell_invs_tl_pk_csr (p_okl_xtd_sell_invs_tl_rec.id,
447: p_okl_xtd_sell_invs_tl_rec.LANGUAGE);
448: FETCH okl_xtd_sell_invs_tl_pk_csr INTO
449: l_okl_xtd_sell_invs_tl_rec.ID,
450: l_okl_xtd_sell_invs_tl_rec.LANGUAGE,

Line 447: p_okl_xtd_sell_invs_tl_rec.LANGUAGE);

443: BEGIN
444: x_no_data_found := TRUE;
445: -- Get current database values
446: OPEN okl_xtd_sell_invs_tl_pk_csr (p_okl_xtd_sell_invs_tl_rec.id,
447: p_okl_xtd_sell_invs_tl_rec.LANGUAGE);
448: FETCH okl_xtd_sell_invs_tl_pk_csr INTO
449: l_okl_xtd_sell_invs_tl_rec.ID,
450: l_okl_xtd_sell_invs_tl_rec.LANGUAGE,
451: l_okl_xtd_sell_invs_tl_rec.SOURCE_LANG,

Line 448: FETCH okl_xtd_sell_invs_tl_pk_csr INTO

444: x_no_data_found := TRUE;
445: -- Get current database values
446: OPEN okl_xtd_sell_invs_tl_pk_csr (p_okl_xtd_sell_invs_tl_rec.id,
447: p_okl_xtd_sell_invs_tl_rec.LANGUAGE);
448: FETCH okl_xtd_sell_invs_tl_pk_csr INTO
449: l_okl_xtd_sell_invs_tl_rec.ID,
450: l_okl_xtd_sell_invs_tl_rec.LANGUAGE,
451: l_okl_xtd_sell_invs_tl_rec.SOURCE_LANG,
452: l_okl_xtd_sell_invs_tl_rec.SFWT_FLAG,

Line 449: l_okl_xtd_sell_invs_tl_rec.ID,

445: -- Get current database values
446: OPEN okl_xtd_sell_invs_tl_pk_csr (p_okl_xtd_sell_invs_tl_rec.id,
447: p_okl_xtd_sell_invs_tl_rec.LANGUAGE);
448: FETCH okl_xtd_sell_invs_tl_pk_csr INTO
449: l_okl_xtd_sell_invs_tl_rec.ID,
450: l_okl_xtd_sell_invs_tl_rec.LANGUAGE,
451: l_okl_xtd_sell_invs_tl_rec.SOURCE_LANG,
452: l_okl_xtd_sell_invs_tl_rec.SFWT_FLAG,
453: l_okl_xtd_sell_invs_tl_rec.CREATED_BY,

Line 450: l_okl_xtd_sell_invs_tl_rec.LANGUAGE,

446: OPEN okl_xtd_sell_invs_tl_pk_csr (p_okl_xtd_sell_invs_tl_rec.id,
447: p_okl_xtd_sell_invs_tl_rec.LANGUAGE);
448: FETCH okl_xtd_sell_invs_tl_pk_csr INTO
449: l_okl_xtd_sell_invs_tl_rec.ID,
450: l_okl_xtd_sell_invs_tl_rec.LANGUAGE,
451: l_okl_xtd_sell_invs_tl_rec.SOURCE_LANG,
452: l_okl_xtd_sell_invs_tl_rec.SFWT_FLAG,
453: l_okl_xtd_sell_invs_tl_rec.CREATED_BY,
454: l_okl_xtd_sell_invs_tl_rec.CREATION_DATE,

Line 451: l_okl_xtd_sell_invs_tl_rec.SOURCE_LANG,

447: p_okl_xtd_sell_invs_tl_rec.LANGUAGE);
448: FETCH okl_xtd_sell_invs_tl_pk_csr INTO
449: l_okl_xtd_sell_invs_tl_rec.ID,
450: l_okl_xtd_sell_invs_tl_rec.LANGUAGE,
451: l_okl_xtd_sell_invs_tl_rec.SOURCE_LANG,
452: l_okl_xtd_sell_invs_tl_rec.SFWT_FLAG,
453: l_okl_xtd_sell_invs_tl_rec.CREATED_BY,
454: l_okl_xtd_sell_invs_tl_rec.CREATION_DATE,
455: l_okl_xtd_sell_invs_tl_rec.LAST_UPDATED_BY,

Line 452: l_okl_xtd_sell_invs_tl_rec.SFWT_FLAG,

448: FETCH okl_xtd_sell_invs_tl_pk_csr INTO
449: l_okl_xtd_sell_invs_tl_rec.ID,
450: l_okl_xtd_sell_invs_tl_rec.LANGUAGE,
451: l_okl_xtd_sell_invs_tl_rec.SOURCE_LANG,
452: l_okl_xtd_sell_invs_tl_rec.SFWT_FLAG,
453: l_okl_xtd_sell_invs_tl_rec.CREATED_BY,
454: l_okl_xtd_sell_invs_tl_rec.CREATION_DATE,
455: l_okl_xtd_sell_invs_tl_rec.LAST_UPDATED_BY,
456: l_okl_xtd_sell_invs_tl_rec.LAST_UPDATE_DATE,

Line 453: l_okl_xtd_sell_invs_tl_rec.CREATED_BY,

449: l_okl_xtd_sell_invs_tl_rec.ID,
450: l_okl_xtd_sell_invs_tl_rec.LANGUAGE,
451: l_okl_xtd_sell_invs_tl_rec.SOURCE_LANG,
452: l_okl_xtd_sell_invs_tl_rec.SFWT_FLAG,
453: l_okl_xtd_sell_invs_tl_rec.CREATED_BY,
454: l_okl_xtd_sell_invs_tl_rec.CREATION_DATE,
455: l_okl_xtd_sell_invs_tl_rec.LAST_UPDATED_BY,
456: l_okl_xtd_sell_invs_tl_rec.LAST_UPDATE_DATE,
457: l_okl_xtd_sell_invs_tl_rec.LAST_UPDATE_LOGIN;

Line 454: l_okl_xtd_sell_invs_tl_rec.CREATION_DATE,

450: l_okl_xtd_sell_invs_tl_rec.LANGUAGE,
451: l_okl_xtd_sell_invs_tl_rec.SOURCE_LANG,
452: l_okl_xtd_sell_invs_tl_rec.SFWT_FLAG,
453: l_okl_xtd_sell_invs_tl_rec.CREATED_BY,
454: l_okl_xtd_sell_invs_tl_rec.CREATION_DATE,
455: l_okl_xtd_sell_invs_tl_rec.LAST_UPDATED_BY,
456: l_okl_xtd_sell_invs_tl_rec.LAST_UPDATE_DATE,
457: l_okl_xtd_sell_invs_tl_rec.LAST_UPDATE_LOGIN;
458: x_no_data_found := okl_xtd_sell_invs_tl_pk_csr%NOTFOUND;

Line 455: l_okl_xtd_sell_invs_tl_rec.LAST_UPDATED_BY,

451: l_okl_xtd_sell_invs_tl_rec.SOURCE_LANG,
452: l_okl_xtd_sell_invs_tl_rec.SFWT_FLAG,
453: l_okl_xtd_sell_invs_tl_rec.CREATED_BY,
454: l_okl_xtd_sell_invs_tl_rec.CREATION_DATE,
455: l_okl_xtd_sell_invs_tl_rec.LAST_UPDATED_BY,
456: l_okl_xtd_sell_invs_tl_rec.LAST_UPDATE_DATE,
457: l_okl_xtd_sell_invs_tl_rec.LAST_UPDATE_LOGIN;
458: x_no_data_found := okl_xtd_sell_invs_tl_pk_csr%NOTFOUND;
459: CLOSE okl_xtd_sell_invs_tl_pk_csr;

Line 456: l_okl_xtd_sell_invs_tl_rec.LAST_UPDATE_DATE,

452: l_okl_xtd_sell_invs_tl_rec.SFWT_FLAG,
453: l_okl_xtd_sell_invs_tl_rec.CREATED_BY,
454: l_okl_xtd_sell_invs_tl_rec.CREATION_DATE,
455: l_okl_xtd_sell_invs_tl_rec.LAST_UPDATED_BY,
456: l_okl_xtd_sell_invs_tl_rec.LAST_UPDATE_DATE,
457: l_okl_xtd_sell_invs_tl_rec.LAST_UPDATE_LOGIN;
458: x_no_data_found := okl_xtd_sell_invs_tl_pk_csr%NOTFOUND;
459: CLOSE okl_xtd_sell_invs_tl_pk_csr;
460: RETURN(l_okl_xtd_sell_invs_tl_rec);

Line 457: l_okl_xtd_sell_invs_tl_rec.LAST_UPDATE_LOGIN;

453: l_okl_xtd_sell_invs_tl_rec.CREATED_BY,
454: l_okl_xtd_sell_invs_tl_rec.CREATION_DATE,
455: l_okl_xtd_sell_invs_tl_rec.LAST_UPDATED_BY,
456: l_okl_xtd_sell_invs_tl_rec.LAST_UPDATE_DATE,
457: l_okl_xtd_sell_invs_tl_rec.LAST_UPDATE_LOGIN;
458: x_no_data_found := okl_xtd_sell_invs_tl_pk_csr%NOTFOUND;
459: CLOSE okl_xtd_sell_invs_tl_pk_csr;
460: RETURN(l_okl_xtd_sell_invs_tl_rec);
461: END get_rec;

Line 458: x_no_data_found := okl_xtd_sell_invs_tl_pk_csr%NOTFOUND;

454: l_okl_xtd_sell_invs_tl_rec.CREATION_DATE,
455: l_okl_xtd_sell_invs_tl_rec.LAST_UPDATED_BY,
456: l_okl_xtd_sell_invs_tl_rec.LAST_UPDATE_DATE,
457: l_okl_xtd_sell_invs_tl_rec.LAST_UPDATE_LOGIN;
458: x_no_data_found := okl_xtd_sell_invs_tl_pk_csr%NOTFOUND;
459: CLOSE okl_xtd_sell_invs_tl_pk_csr;
460: RETURN(l_okl_xtd_sell_invs_tl_rec);
461: END get_rec;
462:

Line 459: CLOSE okl_xtd_sell_invs_tl_pk_csr;

455: l_okl_xtd_sell_invs_tl_rec.LAST_UPDATED_BY,
456: l_okl_xtd_sell_invs_tl_rec.LAST_UPDATE_DATE,
457: l_okl_xtd_sell_invs_tl_rec.LAST_UPDATE_LOGIN;
458: x_no_data_found := okl_xtd_sell_invs_tl_pk_csr%NOTFOUND;
459: CLOSE okl_xtd_sell_invs_tl_pk_csr;
460: RETURN(l_okl_xtd_sell_invs_tl_rec);
461: END get_rec;
462:
463: FUNCTION get_rec (

Line 460: RETURN(l_okl_xtd_sell_invs_tl_rec);

456: l_okl_xtd_sell_invs_tl_rec.LAST_UPDATE_DATE,
457: l_okl_xtd_sell_invs_tl_rec.LAST_UPDATE_LOGIN;
458: x_no_data_found := okl_xtd_sell_invs_tl_pk_csr%NOTFOUND;
459: CLOSE okl_xtd_sell_invs_tl_pk_csr;
460: RETURN(l_okl_xtd_sell_invs_tl_rec);
461: END get_rec;
462:
463: FUNCTION get_rec (
464: p_okl_xtd_sell_invs_tl_rec IN okl_xtd_sell_invs_tl_rec_type

Line 464: p_okl_xtd_sell_invs_tl_rec IN okl_xtd_sell_invs_tl_rec_type

460: RETURN(l_okl_xtd_sell_invs_tl_rec);
461: END get_rec;
462:
463: FUNCTION get_rec (
464: p_okl_xtd_sell_invs_tl_rec IN okl_xtd_sell_invs_tl_rec_type
465: ) RETURN okl_xtd_sell_invs_tl_rec_type IS
466: l_row_notfound BOOLEAN := TRUE;
467: BEGIN
468: RETURN(get_rec(p_okl_xtd_sell_invs_tl_rec, l_row_notfound));

Line 465: ) RETURN okl_xtd_sell_invs_tl_rec_type IS

461: END get_rec;
462:
463: FUNCTION get_rec (
464: p_okl_xtd_sell_invs_tl_rec IN okl_xtd_sell_invs_tl_rec_type
465: ) RETURN okl_xtd_sell_invs_tl_rec_type IS
466: l_row_notfound BOOLEAN := TRUE;
467: BEGIN
468: RETURN(get_rec(p_okl_xtd_sell_invs_tl_rec, l_row_notfound));
469: END get_rec;

Line 468: RETURN(get_rec(p_okl_xtd_sell_invs_tl_rec, l_row_notfound));

464: p_okl_xtd_sell_invs_tl_rec IN okl_xtd_sell_invs_tl_rec_type
465: ) RETURN okl_xtd_sell_invs_tl_rec_type IS
466: l_row_notfound BOOLEAN := TRUE;
467: BEGIN
468: RETURN(get_rec(p_okl_xtd_sell_invs_tl_rec, l_row_notfound));
469: END get_rec;
470: ---------------------------------------------------------------------------
471: -- FUNCTION get_rec for: OKL_XTD_SELL_INVS_V
472: ---------------------------------------------------------------------------

Line 871: p_to IN OUT NOCOPY okl_xtd_sell_invs_tl_rec_type

867: p_to.last_update_login := p_from.last_update_login;
868: END migrate;
869: PROCEDURE migrate (
870: p_from IN esdv_rec_type,
871: p_to IN OUT NOCOPY okl_xtd_sell_invs_tl_rec_type
872: ) IS
873: BEGIN
874: p_to.id := p_from.id;
875: p_to.sfwt_flag := p_from.sfwt_flag;

Line 883: p_from IN okl_xtd_sell_invs_tl_rec_type,

879: p_to.last_update_date := p_from.last_update_date;
880: p_to.last_update_login := p_from.last_update_login;
881: END migrate;
882: PROCEDURE migrate (
883: p_from IN okl_xtd_sell_invs_tl_rec_type,
884: p_to IN OUT NOCOPY esdv_rec_type
885: ) IS
886: BEGIN
887: p_to.id := p_from.id;

Line 915: l_okl_xtd_sell_invs_tl_rec okl_xtd_sell_invs_tl_rec_type;

911: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
912: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
913: l_esdv_rec esdv_rec_type := p_esdv_rec;
914: l_esd_rec esd_rec_type;
915: l_okl_xtd_sell_invs_tl_rec okl_xtd_sell_invs_tl_rec_type;
916: BEGIN
917: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,
918: G_PKG_NAME,
919: p_init_msg_list,

Line 1218: -- insert_row for:OKL_XTD_SELL_INVS_TL --

1214: '_PVT'
1215: );
1216: END insert_row;
1217: -----------------------------------------
1218: -- insert_row for:OKL_XTD_SELL_INVS_TL --
1219: -----------------------------------------
1220: PROCEDURE insert_row(
1221: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
1222: x_return_status OUT NOCOPY VARCHAR2,

Line 1225: p_okl_xtd_sell_invs_tl_rec IN okl_xtd_sell_invs_tl_rec_type,

1221: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
1222: x_return_status OUT NOCOPY VARCHAR2,
1223: x_msg_count OUT NOCOPY NUMBER,
1224: x_msg_data OUT NOCOPY VARCHAR2,
1225: p_okl_xtd_sell_invs_tl_rec IN okl_xtd_sell_invs_tl_rec_type,
1226: x_okl_xtd_sell_invs_tl_rec OUT NOCOPY okl_xtd_sell_invs_tl_rec_type) IS
1227:
1228: l_api_version CONSTANT NUMBER := 1;
1229: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';

Line 1226: x_okl_xtd_sell_invs_tl_rec OUT NOCOPY okl_xtd_sell_invs_tl_rec_type) IS

1222: x_return_status OUT NOCOPY VARCHAR2,
1223: x_msg_count OUT NOCOPY NUMBER,
1224: x_msg_data OUT NOCOPY VARCHAR2,
1225: p_okl_xtd_sell_invs_tl_rec IN okl_xtd_sell_invs_tl_rec_type,
1226: x_okl_xtd_sell_invs_tl_rec OUT NOCOPY okl_xtd_sell_invs_tl_rec_type) IS
1227:
1228: l_api_version CONSTANT NUMBER := 1;
1229: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1230: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

Line 1231: l_okl_xtd_sell_invs_tl_rec okl_xtd_sell_invs_tl_rec_type := p_okl_xtd_sell_invs_tl_rec;

1227:
1228: l_api_version CONSTANT NUMBER := 1;
1229: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1230: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1231: l_okl_xtd_sell_invs_tl_rec okl_xtd_sell_invs_tl_rec_type := p_okl_xtd_sell_invs_tl_rec;
1232: ldefoklxtdsellinvstlrec okl_xtd_sell_invs_tl_rec_type;
1233: CURSOR get_languages IS
1234: SELECT *
1235: FROM FND_LANGUAGES

Line 1232: ldefoklxtdsellinvstlrec okl_xtd_sell_invs_tl_rec_type;

1228: l_api_version CONSTANT NUMBER := 1;
1229: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1230: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1231: l_okl_xtd_sell_invs_tl_rec okl_xtd_sell_invs_tl_rec_type := p_okl_xtd_sell_invs_tl_rec;
1232: ldefoklxtdsellinvstlrec okl_xtd_sell_invs_tl_rec_type;
1233: CURSOR get_languages IS
1234: SELECT *
1235: FROM FND_LANGUAGES
1236: WHERE INSTALLED_FLAG IN ('I', 'B');

Line 1238: -- Set_Attributes for:OKL_XTD_SELL_INVS_TL --

1234: SELECT *
1235: FROM FND_LANGUAGES
1236: WHERE INSTALLED_FLAG IN ('I', 'B');
1237: ---------------------------------------------
1238: -- Set_Attributes for:OKL_XTD_SELL_INVS_TL --
1239: ---------------------------------------------
1240: FUNCTION Set_Attributes (
1241: p_okl_xtd_sell_invs_tl_rec IN okl_xtd_sell_invs_tl_rec_type,
1242: x_okl_xtd_sell_invs_tl_rec OUT NOCOPY okl_xtd_sell_invs_tl_rec_type

Line 1241: p_okl_xtd_sell_invs_tl_rec IN okl_xtd_sell_invs_tl_rec_type,

1237: ---------------------------------------------
1238: -- Set_Attributes for:OKL_XTD_SELL_INVS_TL --
1239: ---------------------------------------------
1240: FUNCTION Set_Attributes (
1241: p_okl_xtd_sell_invs_tl_rec IN okl_xtd_sell_invs_tl_rec_type,
1242: x_okl_xtd_sell_invs_tl_rec OUT NOCOPY okl_xtd_sell_invs_tl_rec_type
1243: ) RETURN VARCHAR2 IS
1244: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1245: BEGIN

Line 1242: x_okl_xtd_sell_invs_tl_rec OUT NOCOPY okl_xtd_sell_invs_tl_rec_type

1238: -- Set_Attributes for:OKL_XTD_SELL_INVS_TL --
1239: ---------------------------------------------
1240: FUNCTION Set_Attributes (
1241: p_okl_xtd_sell_invs_tl_rec IN okl_xtd_sell_invs_tl_rec_type,
1242: x_okl_xtd_sell_invs_tl_rec OUT NOCOPY okl_xtd_sell_invs_tl_rec_type
1243: ) RETURN VARCHAR2 IS
1244: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1245: BEGIN
1246: x_okl_xtd_sell_invs_tl_rec := p_okl_xtd_sell_invs_tl_rec;

Line 1246: x_okl_xtd_sell_invs_tl_rec := p_okl_xtd_sell_invs_tl_rec;

1242: x_okl_xtd_sell_invs_tl_rec OUT NOCOPY okl_xtd_sell_invs_tl_rec_type
1243: ) RETURN VARCHAR2 IS
1244: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1245: BEGIN
1246: x_okl_xtd_sell_invs_tl_rec := p_okl_xtd_sell_invs_tl_rec;
1247: x_okl_xtd_sell_invs_tl_rec.LANGUAGE := USERENV('LANG');
1248: x_okl_xtd_sell_invs_tl_rec.SOURCE_LANG := USERENV('LANG');
1249: RETURN(l_return_status);
1250: END Set_Attributes;

Line 1247: x_okl_xtd_sell_invs_tl_rec.LANGUAGE := USERENV('LANG');

1243: ) RETURN VARCHAR2 IS
1244: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1245: BEGIN
1246: x_okl_xtd_sell_invs_tl_rec := p_okl_xtd_sell_invs_tl_rec;
1247: x_okl_xtd_sell_invs_tl_rec.LANGUAGE := USERENV('LANG');
1248: x_okl_xtd_sell_invs_tl_rec.SOURCE_LANG := USERENV('LANG');
1249: RETURN(l_return_status);
1250: END Set_Attributes;
1251: BEGIN

Line 1248: x_okl_xtd_sell_invs_tl_rec.SOURCE_LANG := USERENV('LANG');

1244: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1245: BEGIN
1246: x_okl_xtd_sell_invs_tl_rec := p_okl_xtd_sell_invs_tl_rec;
1247: x_okl_xtd_sell_invs_tl_rec.LANGUAGE := USERENV('LANG');
1248: x_okl_xtd_sell_invs_tl_rec.SOURCE_LANG := USERENV('LANG');
1249: RETURN(l_return_status);
1250: END Set_Attributes;
1251: BEGIN
1252: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,

Line 1263: p_okl_xtd_sell_invs_tl_rec, -- IN

1259: RAISE Okl_Api.G_EXCEPTION_ERROR;
1260: END IF;
1261: --- Setting item attributes
1262: l_return_status := Set_Attributes(
1263: p_okl_xtd_sell_invs_tl_rec, -- IN
1264: l_okl_xtd_sell_invs_tl_rec); -- OUT
1265: --- If any errors happen abort API
1266: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1267: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1264: l_okl_xtd_sell_invs_tl_rec); -- OUT

1260: END IF;
1261: --- Setting item attributes
1262: l_return_status := Set_Attributes(
1263: p_okl_xtd_sell_invs_tl_rec, -- IN
1264: l_okl_xtd_sell_invs_tl_rec); -- OUT
1265: --- If any errors happen abort API
1266: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1267: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1268: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

Line 1272: l_okl_xtd_sell_invs_tl_rec.LANGUAGE := l_lang_rec.language_code;

1268: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1269: RAISE Okl_Api.G_EXCEPTION_ERROR;
1270: END IF;
1271: FOR l_lang_rec IN get_languages LOOP
1272: l_okl_xtd_sell_invs_tl_rec.LANGUAGE := l_lang_rec.language_code;
1273: INSERT INTO OKL_XTD_SELL_INVS_TL(
1274: id,
1275: LANGUAGE,
1276: source_lang,

Line 1273: INSERT INTO OKL_XTD_SELL_INVS_TL(

1269: RAISE Okl_Api.G_EXCEPTION_ERROR;
1270: END IF;
1271: FOR l_lang_rec IN get_languages LOOP
1272: l_okl_xtd_sell_invs_tl_rec.LANGUAGE := l_lang_rec.language_code;
1273: INSERT INTO OKL_XTD_SELL_INVS_TL(
1274: id,
1275: LANGUAGE,
1276: source_lang,
1277: sfwt_flag,

Line 1284: l_okl_xtd_sell_invs_tl_rec.id,

1280: last_updated_by,
1281: last_update_date,
1282: last_update_login)
1283: VALUES (
1284: l_okl_xtd_sell_invs_tl_rec.id,
1285: l_okl_xtd_sell_invs_tl_rec.LANGUAGE,
1286: l_okl_xtd_sell_invs_tl_rec.source_lang,
1287: l_okl_xtd_sell_invs_tl_rec.sfwt_flag,
1288: l_okl_xtd_sell_invs_tl_rec.created_by,

Line 1285: l_okl_xtd_sell_invs_tl_rec.LANGUAGE,

1281: last_update_date,
1282: last_update_login)
1283: VALUES (
1284: l_okl_xtd_sell_invs_tl_rec.id,
1285: l_okl_xtd_sell_invs_tl_rec.LANGUAGE,
1286: l_okl_xtd_sell_invs_tl_rec.source_lang,
1287: l_okl_xtd_sell_invs_tl_rec.sfwt_flag,
1288: l_okl_xtd_sell_invs_tl_rec.created_by,
1289: l_okl_xtd_sell_invs_tl_rec.creation_date,

Line 1286: l_okl_xtd_sell_invs_tl_rec.source_lang,

1282: last_update_login)
1283: VALUES (
1284: l_okl_xtd_sell_invs_tl_rec.id,
1285: l_okl_xtd_sell_invs_tl_rec.LANGUAGE,
1286: l_okl_xtd_sell_invs_tl_rec.source_lang,
1287: l_okl_xtd_sell_invs_tl_rec.sfwt_flag,
1288: l_okl_xtd_sell_invs_tl_rec.created_by,
1289: l_okl_xtd_sell_invs_tl_rec.creation_date,
1290: l_okl_xtd_sell_invs_tl_rec.last_updated_by,

Line 1287: l_okl_xtd_sell_invs_tl_rec.sfwt_flag,

1283: VALUES (
1284: l_okl_xtd_sell_invs_tl_rec.id,
1285: l_okl_xtd_sell_invs_tl_rec.LANGUAGE,
1286: l_okl_xtd_sell_invs_tl_rec.source_lang,
1287: l_okl_xtd_sell_invs_tl_rec.sfwt_flag,
1288: l_okl_xtd_sell_invs_tl_rec.created_by,
1289: l_okl_xtd_sell_invs_tl_rec.creation_date,
1290: l_okl_xtd_sell_invs_tl_rec.last_updated_by,
1291: l_okl_xtd_sell_invs_tl_rec.last_update_date,

Line 1288: l_okl_xtd_sell_invs_tl_rec.created_by,

1284: l_okl_xtd_sell_invs_tl_rec.id,
1285: l_okl_xtd_sell_invs_tl_rec.LANGUAGE,
1286: l_okl_xtd_sell_invs_tl_rec.source_lang,
1287: l_okl_xtd_sell_invs_tl_rec.sfwt_flag,
1288: l_okl_xtd_sell_invs_tl_rec.created_by,
1289: l_okl_xtd_sell_invs_tl_rec.creation_date,
1290: l_okl_xtd_sell_invs_tl_rec.last_updated_by,
1291: l_okl_xtd_sell_invs_tl_rec.last_update_date,
1292: l_okl_xtd_sell_invs_tl_rec.last_update_login);

Line 1289: l_okl_xtd_sell_invs_tl_rec.creation_date,

1285: l_okl_xtd_sell_invs_tl_rec.LANGUAGE,
1286: l_okl_xtd_sell_invs_tl_rec.source_lang,
1287: l_okl_xtd_sell_invs_tl_rec.sfwt_flag,
1288: l_okl_xtd_sell_invs_tl_rec.created_by,
1289: l_okl_xtd_sell_invs_tl_rec.creation_date,
1290: l_okl_xtd_sell_invs_tl_rec.last_updated_by,
1291: l_okl_xtd_sell_invs_tl_rec.last_update_date,
1292: l_okl_xtd_sell_invs_tl_rec.last_update_login);
1293: END LOOP;

Line 1290: l_okl_xtd_sell_invs_tl_rec.last_updated_by,

1286: l_okl_xtd_sell_invs_tl_rec.source_lang,
1287: l_okl_xtd_sell_invs_tl_rec.sfwt_flag,
1288: l_okl_xtd_sell_invs_tl_rec.created_by,
1289: l_okl_xtd_sell_invs_tl_rec.creation_date,
1290: l_okl_xtd_sell_invs_tl_rec.last_updated_by,
1291: l_okl_xtd_sell_invs_tl_rec.last_update_date,
1292: l_okl_xtd_sell_invs_tl_rec.last_update_login);
1293: END LOOP;
1294: -- Set OUT values

Line 1291: l_okl_xtd_sell_invs_tl_rec.last_update_date,

1287: l_okl_xtd_sell_invs_tl_rec.sfwt_flag,
1288: l_okl_xtd_sell_invs_tl_rec.created_by,
1289: l_okl_xtd_sell_invs_tl_rec.creation_date,
1290: l_okl_xtd_sell_invs_tl_rec.last_updated_by,
1291: l_okl_xtd_sell_invs_tl_rec.last_update_date,
1292: l_okl_xtd_sell_invs_tl_rec.last_update_login);
1293: END LOOP;
1294: -- Set OUT values
1295: x_okl_xtd_sell_invs_tl_rec := l_okl_xtd_sell_invs_tl_rec;

Line 1292: l_okl_xtd_sell_invs_tl_rec.last_update_login);

1288: l_okl_xtd_sell_invs_tl_rec.created_by,
1289: l_okl_xtd_sell_invs_tl_rec.creation_date,
1290: l_okl_xtd_sell_invs_tl_rec.last_updated_by,
1291: l_okl_xtd_sell_invs_tl_rec.last_update_date,
1292: l_okl_xtd_sell_invs_tl_rec.last_update_login);
1293: END LOOP;
1294: -- Set OUT values
1295: x_okl_xtd_sell_invs_tl_rec := l_okl_xtd_sell_invs_tl_rec;
1296: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1295: x_okl_xtd_sell_invs_tl_rec := l_okl_xtd_sell_invs_tl_rec;

1291: l_okl_xtd_sell_invs_tl_rec.last_update_date,
1292: l_okl_xtd_sell_invs_tl_rec.last_update_login);
1293: END LOOP;
1294: -- Set OUT values
1295: x_okl_xtd_sell_invs_tl_rec := l_okl_xtd_sell_invs_tl_rec;
1296: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1297: EXCEPTION
1298: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1299: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

Line 1348: l_okl_xtd_sell_invs_tl_rec okl_xtd_sell_invs_tl_rec_type;

1344: l_esdv_rec esdv_rec_type;
1345: l_def_esdv_rec esdv_rec_type;
1346: l_esd_rec esd_rec_type;
1347: lx_esd_rec esd_rec_type;
1348: l_okl_xtd_sell_invs_tl_rec okl_xtd_sell_invs_tl_rec_type;
1349: lx_okl_xtd_sell_invs_tl_rec okl_xtd_sell_invs_tl_rec_type;
1350: -------------------------------
1351: -- FUNCTION fill_who_columns --
1352: -------------------------------

Line 1349: lx_okl_xtd_sell_invs_tl_rec okl_xtd_sell_invs_tl_rec_type;

1345: l_def_esdv_rec esdv_rec_type;
1346: l_esd_rec esd_rec_type;
1347: lx_esd_rec esd_rec_type;
1348: l_okl_xtd_sell_invs_tl_rec okl_xtd_sell_invs_tl_rec_type;
1349: lx_okl_xtd_sell_invs_tl_rec okl_xtd_sell_invs_tl_rec_type;
1350: -------------------------------
1351: -- FUNCTION fill_who_columns --
1352: -------------------------------
1353: FUNCTION fill_who_columns (

Line 1439: migrate(l_def_esdv_rec, l_okl_xtd_sell_invs_tl_rec);

1435: --------------------------------------
1436: -- Move VIEW record to "Child" records
1437: --------------------------------------
1438: migrate(l_def_esdv_rec, l_esd_rec);
1439: migrate(l_def_esdv_rec, l_okl_xtd_sell_invs_tl_rec);
1440: --------------------------------------------
1441: -- Call the INSERT_ROW for each child record
1442: --------------------------------------------
1443: insert_row(

Line 1462: l_okl_xtd_sell_invs_tl_rec,

1458: p_init_msg_list,
1459: x_return_status,
1460: x_msg_count,
1461: x_msg_data,
1462: l_okl_xtd_sell_invs_tl_rec,
1463: lx_okl_xtd_sell_invs_tl_rec
1464: );
1465: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1466: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1463: lx_okl_xtd_sell_invs_tl_rec

1459: x_return_status,
1460: x_msg_count,
1461: x_msg_data,
1462: l_okl_xtd_sell_invs_tl_rec,
1463: lx_okl_xtd_sell_invs_tl_rec
1464: );
1465: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1466: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1467: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

Line 1470: migrate(lx_okl_xtd_sell_invs_tl_rec, l_def_esdv_rec);

1466: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1467: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1468: RAISE Okl_Api.G_EXCEPTION_ERROR;
1469: END IF;
1470: migrate(lx_okl_xtd_sell_invs_tl_rec, l_def_esdv_rec);
1471: -- Set OUT values
1472: x_esdv_rec := l_def_esdv_rec;
1473: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1474: EXCEPTION

Line 1703: -- lock_row for:OKL_XTD_SELL_INVS_TL --

1699: '_PVT'
1700: );
1701: END lock_row;
1702: ---------------------------------------
1703: -- lock_row for:OKL_XTD_SELL_INVS_TL --
1704: ---------------------------------------
1705: PROCEDURE lock_row(
1706: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
1707: x_return_status OUT NOCOPY VARCHAR2,

Line 1710: p_okl_xtd_sell_invs_tl_rec IN okl_xtd_sell_invs_tl_rec_type) IS

1706: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
1707: x_return_status OUT NOCOPY VARCHAR2,
1708: x_msg_count OUT NOCOPY NUMBER,
1709: x_msg_data OUT NOCOPY VARCHAR2,
1710: p_okl_xtd_sell_invs_tl_rec IN okl_xtd_sell_invs_tl_rec_type) IS
1711:
1712: E_Resource_Busy EXCEPTION;
1713: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1714: CURSOR lock_csr (p_okl_xtd_sell_invs_tl_rec IN okl_xtd_sell_invs_tl_rec_type) IS

Line 1714: CURSOR lock_csr (p_okl_xtd_sell_invs_tl_rec IN okl_xtd_sell_invs_tl_rec_type) IS

1710: p_okl_xtd_sell_invs_tl_rec IN okl_xtd_sell_invs_tl_rec_type) IS
1711:
1712: E_Resource_Busy EXCEPTION;
1713: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1714: CURSOR lock_csr (p_okl_xtd_sell_invs_tl_rec IN okl_xtd_sell_invs_tl_rec_type) IS
1715: SELECT *
1716: FROM OKL_XTD_SELL_INVS_TL
1717: WHERE ID = p_okl_xtd_sell_invs_tl_rec.id
1718: FOR UPDATE NOWAIT;

Line 1716: FROM OKL_XTD_SELL_INVS_TL

1712: E_Resource_Busy EXCEPTION;
1713: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1714: CURSOR lock_csr (p_okl_xtd_sell_invs_tl_rec IN okl_xtd_sell_invs_tl_rec_type) IS
1715: SELECT *
1716: FROM OKL_XTD_SELL_INVS_TL
1717: WHERE ID = p_okl_xtd_sell_invs_tl_rec.id
1718: FOR UPDATE NOWAIT;
1719:
1720: l_api_version CONSTANT NUMBER := 1;

Line 1717: WHERE ID = p_okl_xtd_sell_invs_tl_rec.id

1713: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1714: CURSOR lock_csr (p_okl_xtd_sell_invs_tl_rec IN okl_xtd_sell_invs_tl_rec_type) IS
1715: SELECT *
1716: FROM OKL_XTD_SELL_INVS_TL
1717: WHERE ID = p_okl_xtd_sell_invs_tl_rec.id
1718: FOR UPDATE NOWAIT;
1719:
1720: l_api_version CONSTANT NUMBER := 1;
1721: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';

Line 1737: OPEN lock_csr(p_okl_xtd_sell_invs_tl_rec);

1733: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1734: RAISE Okl_Api.G_EXCEPTION_ERROR;
1735: END IF;
1736: BEGIN
1737: OPEN lock_csr(p_okl_xtd_sell_invs_tl_rec);
1738: FETCH lock_csr INTO l_lock_var;
1739: l_row_notfound := lock_csr%NOTFOUND;
1740: CLOSE lock_csr;
1741: EXCEPTION

Line 1802: l_okl_xtd_sell_invs_tl_rec okl_xtd_sell_invs_tl_rec_type;

1798: l_api_version CONSTANT NUMBER := 1;
1799: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1800: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1801: l_esd_rec esd_rec_type;
1802: l_okl_xtd_sell_invs_tl_rec okl_xtd_sell_invs_tl_rec_type;
1803: BEGIN
1804: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,
1805: G_PKG_NAME,
1806: p_init_msg_list,

Line 1820: migrate(p_esdv_rec, l_okl_xtd_sell_invs_tl_rec);

1816: --------------------------------------
1817: -- Move VIEW record to "Child" records
1818: --------------------------------------
1819: migrate(p_esdv_rec, l_esd_rec);
1820: migrate(p_esdv_rec, l_okl_xtd_sell_invs_tl_rec);
1821: --------------------------------------------
1822: -- Call the LOCK_ROW for each child record
1823: --------------------------------------------
1824: lock_row(

Line 1841: l_okl_xtd_sell_invs_tl_rec

1837: p_init_msg_list,
1838: x_return_status,
1839: x_msg_count,
1840: x_msg_data,
1841: l_okl_xtd_sell_invs_tl_rec
1842: );
1843: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1844: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1845: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

Line 2250: -- update_row for:OKL_XTD_SELL_INVS_TL --

2246: '_PVT'
2247: );
2248: END update_row;
2249: -----------------------------------------
2250: -- update_row for:OKL_XTD_SELL_INVS_TL --
2251: -----------------------------------------
2252: PROCEDURE update_row(
2253: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
2254: x_return_status OUT NOCOPY VARCHAR2,

Line 2257: p_okl_xtd_sell_invs_tl_rec IN okl_xtd_sell_invs_tl_rec_type,

2253: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
2254: x_return_status OUT NOCOPY VARCHAR2,
2255: x_msg_count OUT NOCOPY NUMBER,
2256: x_msg_data OUT NOCOPY VARCHAR2,
2257: p_okl_xtd_sell_invs_tl_rec IN okl_xtd_sell_invs_tl_rec_type,
2258: x_okl_xtd_sell_invs_tl_rec OUT NOCOPY okl_xtd_sell_invs_tl_rec_type) IS
2259:
2260: l_api_version CONSTANT NUMBER := 1;
2261: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';

Line 2258: x_okl_xtd_sell_invs_tl_rec OUT NOCOPY okl_xtd_sell_invs_tl_rec_type) IS

2254: x_return_status OUT NOCOPY VARCHAR2,
2255: x_msg_count OUT NOCOPY NUMBER,
2256: x_msg_data OUT NOCOPY VARCHAR2,
2257: p_okl_xtd_sell_invs_tl_rec IN okl_xtd_sell_invs_tl_rec_type,
2258: x_okl_xtd_sell_invs_tl_rec OUT NOCOPY okl_xtd_sell_invs_tl_rec_type) IS
2259:
2260: l_api_version CONSTANT NUMBER := 1;
2261: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2262: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

Line 2263: l_okl_xtd_sell_invs_tl_rec okl_xtd_sell_invs_tl_rec_type := p_okl_xtd_sell_invs_tl_rec;

2259:
2260: l_api_version CONSTANT NUMBER := 1;
2261: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2262: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2263: l_okl_xtd_sell_invs_tl_rec okl_xtd_sell_invs_tl_rec_type := p_okl_xtd_sell_invs_tl_rec;
2264: ldefoklxtdsellinvstlrec okl_xtd_sell_invs_tl_rec_type;
2265: l_row_notfound BOOLEAN := TRUE;
2266: ----------------------------------
2267: -- FUNCTION populate_new_record --

Line 2264: ldefoklxtdsellinvstlrec okl_xtd_sell_invs_tl_rec_type;

2260: l_api_version CONSTANT NUMBER := 1;
2261: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2262: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2263: l_okl_xtd_sell_invs_tl_rec okl_xtd_sell_invs_tl_rec_type := p_okl_xtd_sell_invs_tl_rec;
2264: ldefoklxtdsellinvstlrec okl_xtd_sell_invs_tl_rec_type;
2265: l_row_notfound BOOLEAN := TRUE;
2266: ----------------------------------
2267: -- FUNCTION populate_new_record --
2268: ----------------------------------

Line 2270: p_okl_xtd_sell_invs_tl_rec IN okl_xtd_sell_invs_tl_rec_type,

2266: ----------------------------------
2267: -- FUNCTION populate_new_record --
2268: ----------------------------------
2269: FUNCTION populate_new_record (
2270: p_okl_xtd_sell_invs_tl_rec IN okl_xtd_sell_invs_tl_rec_type,
2271: x_okl_xtd_sell_invs_tl_rec OUT NOCOPY okl_xtd_sell_invs_tl_rec_type
2272: ) RETURN VARCHAR2 IS
2273: l_okl_xtd_sell_invs_tl_rec okl_xtd_sell_invs_tl_rec_type;
2274: l_row_notfound BOOLEAN := TRUE;

Line 2271: x_okl_xtd_sell_invs_tl_rec OUT NOCOPY okl_xtd_sell_invs_tl_rec_type

2267: -- FUNCTION populate_new_record --
2268: ----------------------------------
2269: FUNCTION populate_new_record (
2270: p_okl_xtd_sell_invs_tl_rec IN okl_xtd_sell_invs_tl_rec_type,
2271: x_okl_xtd_sell_invs_tl_rec OUT NOCOPY okl_xtd_sell_invs_tl_rec_type
2272: ) RETURN VARCHAR2 IS
2273: l_okl_xtd_sell_invs_tl_rec okl_xtd_sell_invs_tl_rec_type;
2274: l_row_notfound BOOLEAN := TRUE;
2275: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

Line 2273: l_okl_xtd_sell_invs_tl_rec okl_xtd_sell_invs_tl_rec_type;

2269: FUNCTION populate_new_record (
2270: p_okl_xtd_sell_invs_tl_rec IN okl_xtd_sell_invs_tl_rec_type,
2271: x_okl_xtd_sell_invs_tl_rec OUT NOCOPY okl_xtd_sell_invs_tl_rec_type
2272: ) RETURN VARCHAR2 IS
2273: l_okl_xtd_sell_invs_tl_rec okl_xtd_sell_invs_tl_rec_type;
2274: l_row_notfound BOOLEAN := TRUE;
2275: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2276: BEGIN
2277: x_okl_xtd_sell_invs_tl_rec := p_okl_xtd_sell_invs_tl_rec;

Line 2277: x_okl_xtd_sell_invs_tl_rec := p_okl_xtd_sell_invs_tl_rec;

2273: l_okl_xtd_sell_invs_tl_rec okl_xtd_sell_invs_tl_rec_type;
2274: l_row_notfound BOOLEAN := TRUE;
2275: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2276: BEGIN
2277: x_okl_xtd_sell_invs_tl_rec := p_okl_xtd_sell_invs_tl_rec;
2278: -- Get current database values
2279: l_okl_xtd_sell_invs_tl_rec := get_rec(p_okl_xtd_sell_invs_tl_rec, l_row_notfound);
2280: IF (l_row_notfound) THEN
2281: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

Line 2279: l_okl_xtd_sell_invs_tl_rec := get_rec(p_okl_xtd_sell_invs_tl_rec, l_row_notfound);

2275: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2276: BEGIN
2277: x_okl_xtd_sell_invs_tl_rec := p_okl_xtd_sell_invs_tl_rec;
2278: -- Get current database values
2279: l_okl_xtd_sell_invs_tl_rec := get_rec(p_okl_xtd_sell_invs_tl_rec, l_row_notfound);
2280: IF (l_row_notfound) THEN
2281: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
2282: END IF;
2283: IF (x_okl_xtd_sell_invs_tl_rec.id = Okl_Api.G_MISS_NUM)

Line 2283: IF (x_okl_xtd_sell_invs_tl_rec.id = Okl_Api.G_MISS_NUM)

2279: l_okl_xtd_sell_invs_tl_rec := get_rec(p_okl_xtd_sell_invs_tl_rec, l_row_notfound);
2280: IF (l_row_notfound) THEN
2281: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
2282: END IF;
2283: IF (x_okl_xtd_sell_invs_tl_rec.id = Okl_Api.G_MISS_NUM)
2284: THEN
2285: x_okl_xtd_sell_invs_tl_rec.id := l_okl_xtd_sell_invs_tl_rec.id;
2286: END IF;
2287: IF (x_okl_xtd_sell_invs_tl_rec.LANGUAGE = Okl_Api.G_MISS_CHAR)

Line 2285: x_okl_xtd_sell_invs_tl_rec.id := l_okl_xtd_sell_invs_tl_rec.id;

2281: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
2282: END IF;
2283: IF (x_okl_xtd_sell_invs_tl_rec.id = Okl_Api.G_MISS_NUM)
2284: THEN
2285: x_okl_xtd_sell_invs_tl_rec.id := l_okl_xtd_sell_invs_tl_rec.id;
2286: END IF;
2287: IF (x_okl_xtd_sell_invs_tl_rec.LANGUAGE = Okl_Api.G_MISS_CHAR)
2288: THEN
2289: x_okl_xtd_sell_invs_tl_rec.LANGUAGE := l_okl_xtd_sell_invs_tl_rec.LANGUAGE;

Line 2287: IF (x_okl_xtd_sell_invs_tl_rec.LANGUAGE = Okl_Api.G_MISS_CHAR)

2283: IF (x_okl_xtd_sell_invs_tl_rec.id = Okl_Api.G_MISS_NUM)
2284: THEN
2285: x_okl_xtd_sell_invs_tl_rec.id := l_okl_xtd_sell_invs_tl_rec.id;
2286: END IF;
2287: IF (x_okl_xtd_sell_invs_tl_rec.LANGUAGE = Okl_Api.G_MISS_CHAR)
2288: THEN
2289: x_okl_xtd_sell_invs_tl_rec.LANGUAGE := l_okl_xtd_sell_invs_tl_rec.LANGUAGE;
2290: END IF;
2291: IF (x_okl_xtd_sell_invs_tl_rec.source_lang = Okl_Api.G_MISS_CHAR)

Line 2289: x_okl_xtd_sell_invs_tl_rec.LANGUAGE := l_okl_xtd_sell_invs_tl_rec.LANGUAGE;

2285: x_okl_xtd_sell_invs_tl_rec.id := l_okl_xtd_sell_invs_tl_rec.id;
2286: END IF;
2287: IF (x_okl_xtd_sell_invs_tl_rec.LANGUAGE = Okl_Api.G_MISS_CHAR)
2288: THEN
2289: x_okl_xtd_sell_invs_tl_rec.LANGUAGE := l_okl_xtd_sell_invs_tl_rec.LANGUAGE;
2290: END IF;
2291: IF (x_okl_xtd_sell_invs_tl_rec.source_lang = Okl_Api.G_MISS_CHAR)
2292: THEN
2293: x_okl_xtd_sell_invs_tl_rec.source_lang := l_okl_xtd_sell_invs_tl_rec.source_lang;

Line 2291: IF (x_okl_xtd_sell_invs_tl_rec.source_lang = Okl_Api.G_MISS_CHAR)

2287: IF (x_okl_xtd_sell_invs_tl_rec.LANGUAGE = Okl_Api.G_MISS_CHAR)
2288: THEN
2289: x_okl_xtd_sell_invs_tl_rec.LANGUAGE := l_okl_xtd_sell_invs_tl_rec.LANGUAGE;
2290: END IF;
2291: IF (x_okl_xtd_sell_invs_tl_rec.source_lang = Okl_Api.G_MISS_CHAR)
2292: THEN
2293: x_okl_xtd_sell_invs_tl_rec.source_lang := l_okl_xtd_sell_invs_tl_rec.source_lang;
2294: END IF;
2295: IF (x_okl_xtd_sell_invs_tl_rec.sfwt_flag = Okl_Api.G_MISS_CHAR)

Line 2293: x_okl_xtd_sell_invs_tl_rec.source_lang := l_okl_xtd_sell_invs_tl_rec.source_lang;

2289: x_okl_xtd_sell_invs_tl_rec.LANGUAGE := l_okl_xtd_sell_invs_tl_rec.LANGUAGE;
2290: END IF;
2291: IF (x_okl_xtd_sell_invs_tl_rec.source_lang = Okl_Api.G_MISS_CHAR)
2292: THEN
2293: x_okl_xtd_sell_invs_tl_rec.source_lang := l_okl_xtd_sell_invs_tl_rec.source_lang;
2294: END IF;
2295: IF (x_okl_xtd_sell_invs_tl_rec.sfwt_flag = Okl_Api.G_MISS_CHAR)
2296: THEN
2297: x_okl_xtd_sell_invs_tl_rec.sfwt_flag := l_okl_xtd_sell_invs_tl_rec.sfwt_flag;

Line 2295: IF (x_okl_xtd_sell_invs_tl_rec.sfwt_flag = Okl_Api.G_MISS_CHAR)

2291: IF (x_okl_xtd_sell_invs_tl_rec.source_lang = Okl_Api.G_MISS_CHAR)
2292: THEN
2293: x_okl_xtd_sell_invs_tl_rec.source_lang := l_okl_xtd_sell_invs_tl_rec.source_lang;
2294: END IF;
2295: IF (x_okl_xtd_sell_invs_tl_rec.sfwt_flag = Okl_Api.G_MISS_CHAR)
2296: THEN
2297: x_okl_xtd_sell_invs_tl_rec.sfwt_flag := l_okl_xtd_sell_invs_tl_rec.sfwt_flag;
2298: END IF;
2299: IF (x_okl_xtd_sell_invs_tl_rec.created_by = Okl_Api.G_MISS_NUM)

Line 2297: x_okl_xtd_sell_invs_tl_rec.sfwt_flag := l_okl_xtd_sell_invs_tl_rec.sfwt_flag;

2293: x_okl_xtd_sell_invs_tl_rec.source_lang := l_okl_xtd_sell_invs_tl_rec.source_lang;
2294: END IF;
2295: IF (x_okl_xtd_sell_invs_tl_rec.sfwt_flag = Okl_Api.G_MISS_CHAR)
2296: THEN
2297: x_okl_xtd_sell_invs_tl_rec.sfwt_flag := l_okl_xtd_sell_invs_tl_rec.sfwt_flag;
2298: END IF;
2299: IF (x_okl_xtd_sell_invs_tl_rec.created_by = Okl_Api.G_MISS_NUM)
2300: THEN
2301: x_okl_xtd_sell_invs_tl_rec.created_by := l_okl_xtd_sell_invs_tl_rec.created_by;

Line 2299: IF (x_okl_xtd_sell_invs_tl_rec.created_by = Okl_Api.G_MISS_NUM)

2295: IF (x_okl_xtd_sell_invs_tl_rec.sfwt_flag = Okl_Api.G_MISS_CHAR)
2296: THEN
2297: x_okl_xtd_sell_invs_tl_rec.sfwt_flag := l_okl_xtd_sell_invs_tl_rec.sfwt_flag;
2298: END IF;
2299: IF (x_okl_xtd_sell_invs_tl_rec.created_by = Okl_Api.G_MISS_NUM)
2300: THEN
2301: x_okl_xtd_sell_invs_tl_rec.created_by := l_okl_xtd_sell_invs_tl_rec.created_by;
2302: END IF;
2303: IF (x_okl_xtd_sell_invs_tl_rec.creation_date = Okl_Api.G_MISS_DATE)

Line 2301: x_okl_xtd_sell_invs_tl_rec.created_by := l_okl_xtd_sell_invs_tl_rec.created_by;

2297: x_okl_xtd_sell_invs_tl_rec.sfwt_flag := l_okl_xtd_sell_invs_tl_rec.sfwt_flag;
2298: END IF;
2299: IF (x_okl_xtd_sell_invs_tl_rec.created_by = Okl_Api.G_MISS_NUM)
2300: THEN
2301: x_okl_xtd_sell_invs_tl_rec.created_by := l_okl_xtd_sell_invs_tl_rec.created_by;
2302: END IF;
2303: IF (x_okl_xtd_sell_invs_tl_rec.creation_date = Okl_Api.G_MISS_DATE)
2304: THEN
2305: x_okl_xtd_sell_invs_tl_rec.creation_date := l_okl_xtd_sell_invs_tl_rec.creation_date;

Line 2303: IF (x_okl_xtd_sell_invs_tl_rec.creation_date = Okl_Api.G_MISS_DATE)

2299: IF (x_okl_xtd_sell_invs_tl_rec.created_by = Okl_Api.G_MISS_NUM)
2300: THEN
2301: x_okl_xtd_sell_invs_tl_rec.created_by := l_okl_xtd_sell_invs_tl_rec.created_by;
2302: END IF;
2303: IF (x_okl_xtd_sell_invs_tl_rec.creation_date = Okl_Api.G_MISS_DATE)
2304: THEN
2305: x_okl_xtd_sell_invs_tl_rec.creation_date := l_okl_xtd_sell_invs_tl_rec.creation_date;
2306: END IF;
2307: IF (x_okl_xtd_sell_invs_tl_rec.last_updated_by = Okl_Api.G_MISS_NUM)

Line 2305: x_okl_xtd_sell_invs_tl_rec.creation_date := l_okl_xtd_sell_invs_tl_rec.creation_date;

2301: x_okl_xtd_sell_invs_tl_rec.created_by := l_okl_xtd_sell_invs_tl_rec.created_by;
2302: END IF;
2303: IF (x_okl_xtd_sell_invs_tl_rec.creation_date = Okl_Api.G_MISS_DATE)
2304: THEN
2305: x_okl_xtd_sell_invs_tl_rec.creation_date := l_okl_xtd_sell_invs_tl_rec.creation_date;
2306: END IF;
2307: IF (x_okl_xtd_sell_invs_tl_rec.last_updated_by = Okl_Api.G_MISS_NUM)
2308: THEN
2309: x_okl_xtd_sell_invs_tl_rec.last_updated_by := l_okl_xtd_sell_invs_tl_rec.last_updated_by;

Line 2307: IF (x_okl_xtd_sell_invs_tl_rec.last_updated_by = Okl_Api.G_MISS_NUM)

2303: IF (x_okl_xtd_sell_invs_tl_rec.creation_date = Okl_Api.G_MISS_DATE)
2304: THEN
2305: x_okl_xtd_sell_invs_tl_rec.creation_date := l_okl_xtd_sell_invs_tl_rec.creation_date;
2306: END IF;
2307: IF (x_okl_xtd_sell_invs_tl_rec.last_updated_by = Okl_Api.G_MISS_NUM)
2308: THEN
2309: x_okl_xtd_sell_invs_tl_rec.last_updated_by := l_okl_xtd_sell_invs_tl_rec.last_updated_by;
2310: END IF;
2311: IF (x_okl_xtd_sell_invs_tl_rec.last_update_date = Okl_Api.G_MISS_DATE)

Line 2309: x_okl_xtd_sell_invs_tl_rec.last_updated_by := l_okl_xtd_sell_invs_tl_rec.last_updated_by;

2305: x_okl_xtd_sell_invs_tl_rec.creation_date := l_okl_xtd_sell_invs_tl_rec.creation_date;
2306: END IF;
2307: IF (x_okl_xtd_sell_invs_tl_rec.last_updated_by = Okl_Api.G_MISS_NUM)
2308: THEN
2309: x_okl_xtd_sell_invs_tl_rec.last_updated_by := l_okl_xtd_sell_invs_tl_rec.last_updated_by;
2310: END IF;
2311: IF (x_okl_xtd_sell_invs_tl_rec.last_update_date = Okl_Api.G_MISS_DATE)
2312: THEN
2313: x_okl_xtd_sell_invs_tl_rec.last_update_date := l_okl_xtd_sell_invs_tl_rec.last_update_date;

Line 2311: IF (x_okl_xtd_sell_invs_tl_rec.last_update_date = Okl_Api.G_MISS_DATE)

2307: IF (x_okl_xtd_sell_invs_tl_rec.last_updated_by = Okl_Api.G_MISS_NUM)
2308: THEN
2309: x_okl_xtd_sell_invs_tl_rec.last_updated_by := l_okl_xtd_sell_invs_tl_rec.last_updated_by;
2310: END IF;
2311: IF (x_okl_xtd_sell_invs_tl_rec.last_update_date = Okl_Api.G_MISS_DATE)
2312: THEN
2313: x_okl_xtd_sell_invs_tl_rec.last_update_date := l_okl_xtd_sell_invs_tl_rec.last_update_date;
2314: END IF;
2315: IF (x_okl_xtd_sell_invs_tl_rec.last_update_login = Okl_Api.G_MISS_NUM)

Line 2313: x_okl_xtd_sell_invs_tl_rec.last_update_date := l_okl_xtd_sell_invs_tl_rec.last_update_date;

2309: x_okl_xtd_sell_invs_tl_rec.last_updated_by := l_okl_xtd_sell_invs_tl_rec.last_updated_by;
2310: END IF;
2311: IF (x_okl_xtd_sell_invs_tl_rec.last_update_date = Okl_Api.G_MISS_DATE)
2312: THEN
2313: x_okl_xtd_sell_invs_tl_rec.last_update_date := l_okl_xtd_sell_invs_tl_rec.last_update_date;
2314: END IF;
2315: IF (x_okl_xtd_sell_invs_tl_rec.last_update_login = Okl_Api.G_MISS_NUM)
2316: THEN
2317: x_okl_xtd_sell_invs_tl_rec.last_update_login := l_okl_xtd_sell_invs_tl_rec.last_update_login;

Line 2315: IF (x_okl_xtd_sell_invs_tl_rec.last_update_login = Okl_Api.G_MISS_NUM)

2311: IF (x_okl_xtd_sell_invs_tl_rec.last_update_date = Okl_Api.G_MISS_DATE)
2312: THEN
2313: x_okl_xtd_sell_invs_tl_rec.last_update_date := l_okl_xtd_sell_invs_tl_rec.last_update_date;
2314: END IF;
2315: IF (x_okl_xtd_sell_invs_tl_rec.last_update_login = Okl_Api.G_MISS_NUM)
2316: THEN
2317: x_okl_xtd_sell_invs_tl_rec.last_update_login := l_okl_xtd_sell_invs_tl_rec.last_update_login;
2318: END IF;
2319: RETURN(l_return_status);

Line 2317: x_okl_xtd_sell_invs_tl_rec.last_update_login := l_okl_xtd_sell_invs_tl_rec.last_update_login;

2313: x_okl_xtd_sell_invs_tl_rec.last_update_date := l_okl_xtd_sell_invs_tl_rec.last_update_date;
2314: END IF;
2315: IF (x_okl_xtd_sell_invs_tl_rec.last_update_login = Okl_Api.G_MISS_NUM)
2316: THEN
2317: x_okl_xtd_sell_invs_tl_rec.last_update_login := l_okl_xtd_sell_invs_tl_rec.last_update_login;
2318: END IF;
2319: RETURN(l_return_status);
2320: END populate_new_record;
2321: ---------------------------------------------

Line 2322: -- Set_Attributes for:OKL_XTD_SELL_INVS_TL --

2318: END IF;
2319: RETURN(l_return_status);
2320: END populate_new_record;
2321: ---------------------------------------------
2322: -- Set_Attributes for:OKL_XTD_SELL_INVS_TL --
2323: ---------------------------------------------
2324: FUNCTION Set_Attributes (
2325: p_okl_xtd_sell_invs_tl_rec IN okl_xtd_sell_invs_tl_rec_type,
2326: x_okl_xtd_sell_invs_tl_rec OUT NOCOPY okl_xtd_sell_invs_tl_rec_type

Line 2325: p_okl_xtd_sell_invs_tl_rec IN okl_xtd_sell_invs_tl_rec_type,

2321: ---------------------------------------------
2322: -- Set_Attributes for:OKL_XTD_SELL_INVS_TL --
2323: ---------------------------------------------
2324: FUNCTION Set_Attributes (
2325: p_okl_xtd_sell_invs_tl_rec IN okl_xtd_sell_invs_tl_rec_type,
2326: x_okl_xtd_sell_invs_tl_rec OUT NOCOPY okl_xtd_sell_invs_tl_rec_type
2327: ) RETURN VARCHAR2 IS
2328: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2329: BEGIN

Line 2326: x_okl_xtd_sell_invs_tl_rec OUT NOCOPY okl_xtd_sell_invs_tl_rec_type

2322: -- Set_Attributes for:OKL_XTD_SELL_INVS_TL --
2323: ---------------------------------------------
2324: FUNCTION Set_Attributes (
2325: p_okl_xtd_sell_invs_tl_rec IN okl_xtd_sell_invs_tl_rec_type,
2326: x_okl_xtd_sell_invs_tl_rec OUT NOCOPY okl_xtd_sell_invs_tl_rec_type
2327: ) RETURN VARCHAR2 IS
2328: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2329: BEGIN
2330: x_okl_xtd_sell_invs_tl_rec := p_okl_xtd_sell_invs_tl_rec;

Line 2330: x_okl_xtd_sell_invs_tl_rec := p_okl_xtd_sell_invs_tl_rec;

2326: x_okl_xtd_sell_invs_tl_rec OUT NOCOPY okl_xtd_sell_invs_tl_rec_type
2327: ) RETURN VARCHAR2 IS
2328: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2329: BEGIN
2330: x_okl_xtd_sell_invs_tl_rec := p_okl_xtd_sell_invs_tl_rec;
2331: x_okl_xtd_sell_invs_tl_rec.LANGUAGE := USERENV('LANG');
2332: x_okl_xtd_sell_invs_tl_rec.SOURCE_LANG := USERENV('LANG');
2333: RETURN(l_return_status);
2334: END Set_Attributes;

Line 2331: x_okl_xtd_sell_invs_tl_rec.LANGUAGE := USERENV('LANG');

2327: ) RETURN VARCHAR2 IS
2328: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2329: BEGIN
2330: x_okl_xtd_sell_invs_tl_rec := p_okl_xtd_sell_invs_tl_rec;
2331: x_okl_xtd_sell_invs_tl_rec.LANGUAGE := USERENV('LANG');
2332: x_okl_xtd_sell_invs_tl_rec.SOURCE_LANG := USERENV('LANG');
2333: RETURN(l_return_status);
2334: END Set_Attributes;
2335: BEGIN

Line 2332: x_okl_xtd_sell_invs_tl_rec.SOURCE_LANG := USERENV('LANG');

2328: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2329: BEGIN
2330: x_okl_xtd_sell_invs_tl_rec := p_okl_xtd_sell_invs_tl_rec;
2331: x_okl_xtd_sell_invs_tl_rec.LANGUAGE := USERENV('LANG');
2332: x_okl_xtd_sell_invs_tl_rec.SOURCE_LANG := USERENV('LANG');
2333: RETURN(l_return_status);
2334: END Set_Attributes;
2335: BEGIN
2336: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,

Line 2347: p_okl_xtd_sell_invs_tl_rec, -- IN

2343: RAISE Okl_Api.G_EXCEPTION_ERROR;
2344: END IF;
2345: --- Setting item attributes
2346: l_return_status := Set_Attributes(
2347: p_okl_xtd_sell_invs_tl_rec, -- IN
2348: l_okl_xtd_sell_invs_tl_rec); -- OUT
2349: --- If any errors happen abort API
2350: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2351: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2348: l_okl_xtd_sell_invs_tl_rec); -- OUT

2344: END IF;
2345: --- Setting item attributes
2346: l_return_status := Set_Attributes(
2347: p_okl_xtd_sell_invs_tl_rec, -- IN
2348: l_okl_xtd_sell_invs_tl_rec); -- OUT
2349: --- If any errors happen abort API
2350: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2351: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2352: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

Line 2355: l_return_status := populate_new_record(l_okl_xtd_sell_invs_tl_rec, ldefoklxtdsellinvstlrec);

2351: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2352: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2353: RAISE Okl_Api.G_EXCEPTION_ERROR;
2354: END IF;
2355: l_return_status := populate_new_record(l_okl_xtd_sell_invs_tl_rec, ldefoklxtdsellinvstlrec);
2356: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2357: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2358: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2359: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 2361: UPDATE OKL_XTD_SELL_INVS_TL

2357: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2358: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2359: RAISE Okl_Api.G_EXCEPTION_ERROR;
2360: END IF;
2361: UPDATE OKL_XTD_SELL_INVS_TL
2362: SET CREATED_BY = ldefoklxtdsellinvstlrec.created_by,
2363: CREATION_DATE = ldefoklxtdsellinvstlrec.creation_date,
2364: LAST_UPDATED_BY = ldefoklxtdsellinvstlrec.last_updated_by,
2365: LAST_UPDATE_DATE = ldefoklxtdsellinvstlrec.last_update_date,

Line 2371: UPDATE OKL_XTD_SELL_INVS_TL

2367: WHERE ID = ldefoklxtdsellinvstlrec.id
2368: --AND SOURCE_LANG = USERENV('LANG');
2369: AND USERENV('LANG') in (SOURCE_LANG, LANGUAGE);
2370:
2371: UPDATE OKL_XTD_SELL_INVS_TL
2372: SET SFWT_FLAG = 'Y'
2373: WHERE ID = ldefoklxtdsellinvstlrec.id
2374: AND SOURCE_LANG <> USERENV('LANG');
2375:

Line 2376: x_okl_xtd_sell_invs_tl_rec := ldefoklxtdsellinvstlrec;

2372: SET SFWT_FLAG = 'Y'
2373: WHERE ID = ldefoklxtdsellinvstlrec.id
2374: AND SOURCE_LANG <> USERENV('LANG');
2375:
2376: x_okl_xtd_sell_invs_tl_rec := ldefoklxtdsellinvstlrec;
2377: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2378: EXCEPTION
2379: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
2380: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

Line 2427: l_okl_xtd_sell_invs_tl_rec okl_xtd_sell_invs_tl_rec_type;

2423: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
2424: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2425: l_esdv_rec esdv_rec_type := p_esdv_rec;
2426: l_def_esdv_rec esdv_rec_type;
2427: l_okl_xtd_sell_invs_tl_rec okl_xtd_sell_invs_tl_rec_type;
2428: lx_okl_xtd_sell_invs_tl_rec okl_xtd_sell_invs_tl_rec_type;
2429: l_esd_rec esd_rec_type;
2430: lx_esd_rec esd_rec_type;
2431: -------------------------------

Line 2428: lx_okl_xtd_sell_invs_tl_rec okl_xtd_sell_invs_tl_rec_type;

2424: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2425: l_esdv_rec esdv_rec_type := p_esdv_rec;
2426: l_def_esdv_rec esdv_rec_type;
2427: l_okl_xtd_sell_invs_tl_rec okl_xtd_sell_invs_tl_rec_type;
2428: lx_okl_xtd_sell_invs_tl_rec okl_xtd_sell_invs_tl_rec_type;
2429: l_esd_rec esd_rec_type;
2430: lx_esd_rec esd_rec_type;
2431: -------------------------------
2432: -- FUNCTION fill_who_columns --

Line 2686: migrate(l_def_esdv_rec, l_okl_xtd_sell_invs_tl_rec);

2682:
2683: --------------------------------------
2684: -- Move VIEW record to "Child" records
2685: --------------------------------------
2686: migrate(l_def_esdv_rec, l_okl_xtd_sell_invs_tl_rec);
2687: migrate(l_def_esdv_rec, l_esd_rec);
2688: --------------------------------------------
2689: -- Call the UPDATE_ROW for each child record
2690: --------------------------------------------

Line 2696: l_okl_xtd_sell_invs_tl_rec,

2692: p_init_msg_list,
2693: x_return_status,
2694: x_msg_count,
2695: x_msg_data,
2696: l_okl_xtd_sell_invs_tl_rec,
2697: lx_okl_xtd_sell_invs_tl_rec
2698: );
2699: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2700: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2697: lx_okl_xtd_sell_invs_tl_rec

2693: x_return_status,
2694: x_msg_count,
2695: x_msg_data,
2696: l_okl_xtd_sell_invs_tl_rec,
2697: lx_okl_xtd_sell_invs_tl_rec
2698: );
2699: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2700: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2701: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

Line 2704: migrate(lx_okl_xtd_sell_invs_tl_rec, l_def_esdv_rec);

2700: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2701: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2702: RAISE Okl_Api.G_EXCEPTION_ERROR;
2703: END IF;
2704: migrate(lx_okl_xtd_sell_invs_tl_rec, l_def_esdv_rec);
2705: update_row(
2706: p_init_msg_list,
2707: x_return_status,
2708: x_msg_count,

Line 2905: -- delete_row for:OKL_XTD_SELL_INVS_TL --

2901: '_PVT'
2902: );
2903: END delete_row;
2904: -----------------------------------------
2905: -- delete_row for:OKL_XTD_SELL_INVS_TL --
2906: -----------------------------------------
2907: PROCEDURE delete_row(
2908: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
2909: x_return_status OUT NOCOPY VARCHAR2,

Line 2912: p_okl_xtd_sell_invs_tl_rec IN okl_xtd_sell_invs_tl_rec_type) IS

2908: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
2909: x_return_status OUT NOCOPY VARCHAR2,
2910: x_msg_count OUT NOCOPY NUMBER,
2911: x_msg_data OUT NOCOPY VARCHAR2,
2912: p_okl_xtd_sell_invs_tl_rec IN okl_xtd_sell_invs_tl_rec_type) IS
2913:
2914: l_api_version CONSTANT NUMBER := 1;
2915: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
2916: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

Line 2917: l_okl_xtd_sell_invs_tl_rec okl_xtd_sell_invs_tl_rec_type:= p_okl_xtd_sell_invs_tl_rec;

2913:
2914: l_api_version CONSTANT NUMBER := 1;
2915: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
2916: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2917: l_okl_xtd_sell_invs_tl_rec okl_xtd_sell_invs_tl_rec_type:= p_okl_xtd_sell_invs_tl_rec;
2918: l_row_notfound BOOLEAN := TRUE;
2919: ---------------------------------------------
2920: -- Set_Attributes for:OKL_XTD_SELL_INVS_TL --
2921: ---------------------------------------------

Line 2920: -- Set_Attributes for:OKL_XTD_SELL_INVS_TL --

2916: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2917: l_okl_xtd_sell_invs_tl_rec okl_xtd_sell_invs_tl_rec_type:= p_okl_xtd_sell_invs_tl_rec;
2918: l_row_notfound BOOLEAN := TRUE;
2919: ---------------------------------------------
2920: -- Set_Attributes for:OKL_XTD_SELL_INVS_TL --
2921: ---------------------------------------------
2922: FUNCTION Set_Attributes (
2923: p_okl_xtd_sell_invs_tl_rec IN okl_xtd_sell_invs_tl_rec_type,
2924: x_okl_xtd_sell_invs_tl_rec OUT NOCOPY okl_xtd_sell_invs_tl_rec_type

Line 2923: p_okl_xtd_sell_invs_tl_rec IN okl_xtd_sell_invs_tl_rec_type,

2919: ---------------------------------------------
2920: -- Set_Attributes for:OKL_XTD_SELL_INVS_TL --
2921: ---------------------------------------------
2922: FUNCTION Set_Attributes (
2923: p_okl_xtd_sell_invs_tl_rec IN okl_xtd_sell_invs_tl_rec_type,
2924: x_okl_xtd_sell_invs_tl_rec OUT NOCOPY okl_xtd_sell_invs_tl_rec_type
2925: ) RETURN VARCHAR2 IS
2926: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2927: BEGIN

Line 2924: x_okl_xtd_sell_invs_tl_rec OUT NOCOPY okl_xtd_sell_invs_tl_rec_type

2920: -- Set_Attributes for:OKL_XTD_SELL_INVS_TL --
2921: ---------------------------------------------
2922: FUNCTION Set_Attributes (
2923: p_okl_xtd_sell_invs_tl_rec IN okl_xtd_sell_invs_tl_rec_type,
2924: x_okl_xtd_sell_invs_tl_rec OUT NOCOPY okl_xtd_sell_invs_tl_rec_type
2925: ) RETURN VARCHAR2 IS
2926: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2927: BEGIN
2928: x_okl_xtd_sell_invs_tl_rec := p_okl_xtd_sell_invs_tl_rec;

Line 2928: x_okl_xtd_sell_invs_tl_rec := p_okl_xtd_sell_invs_tl_rec;

2924: x_okl_xtd_sell_invs_tl_rec OUT NOCOPY okl_xtd_sell_invs_tl_rec_type
2925: ) RETURN VARCHAR2 IS
2926: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2927: BEGIN
2928: x_okl_xtd_sell_invs_tl_rec := p_okl_xtd_sell_invs_tl_rec;
2929: x_okl_xtd_sell_invs_tl_rec.LANGUAGE := USERENV('LANG');
2930: RETURN(l_return_status);
2931: END Set_Attributes;
2932: BEGIN

Line 2929: x_okl_xtd_sell_invs_tl_rec.LANGUAGE := USERENV('LANG');

2925: ) RETURN VARCHAR2 IS
2926: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2927: BEGIN
2928: x_okl_xtd_sell_invs_tl_rec := p_okl_xtd_sell_invs_tl_rec;
2929: x_okl_xtd_sell_invs_tl_rec.LANGUAGE := USERENV('LANG');
2930: RETURN(l_return_status);
2931: END Set_Attributes;
2932: BEGIN
2933: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,

Line 2944: p_okl_xtd_sell_invs_tl_rec, -- IN

2940: RAISE Okl_Api.G_EXCEPTION_ERROR;
2941: END IF;
2942: --- Setting item attributes
2943: l_return_status := Set_Attributes(
2944: p_okl_xtd_sell_invs_tl_rec, -- IN
2945: l_okl_xtd_sell_invs_tl_rec); -- OUT
2946: --- If any errors happen abort API
2947: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2948: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2945: l_okl_xtd_sell_invs_tl_rec); -- OUT

2941: END IF;
2942: --- Setting item attributes
2943: l_return_status := Set_Attributes(
2944: p_okl_xtd_sell_invs_tl_rec, -- IN
2945: l_okl_xtd_sell_invs_tl_rec); -- OUT
2946: --- If any errors happen abort API
2947: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2948: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2949: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

Line 2952: DELETE FROM OKL_XTD_SELL_INVS_TL

2948: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2949: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2950: RAISE Okl_Api.G_EXCEPTION_ERROR;
2951: END IF;
2952: DELETE FROM OKL_XTD_SELL_INVS_TL
2953: WHERE ID = l_okl_xtd_sell_invs_tl_rec.id;
2954:
2955: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2956: EXCEPTION

Line 2953: WHERE ID = l_okl_xtd_sell_invs_tl_rec.id;

2949: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2950: RAISE Okl_Api.G_EXCEPTION_ERROR;
2951: END IF;
2952: DELETE FROM OKL_XTD_SELL_INVS_TL
2953: WHERE ID = l_okl_xtd_sell_invs_tl_rec.id;
2954:
2955: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2956: EXCEPTION
2957: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

Line 3003: l_okl_xtd_sell_invs_tl_rec okl_xtd_sell_invs_tl_rec_type;

2999: l_api_version CONSTANT NUMBER := 1;
3000: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
3001: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
3002: l_esdv_rec esdv_rec_type := p_esdv_rec;
3003: l_okl_xtd_sell_invs_tl_rec okl_xtd_sell_invs_tl_rec_type;
3004: l_esd_rec esd_rec_type;
3005: BEGIN
3006: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,
3007: G_PKG_NAME,

Line 3021: migrate(l_esdv_rec, l_okl_xtd_sell_invs_tl_rec);

3017: END IF;
3018: --------------------------------------
3019: -- Move VIEW record to "Child" records
3020: --------------------------------------
3021: migrate(l_esdv_rec, l_okl_xtd_sell_invs_tl_rec);
3022: migrate(l_esdv_rec, l_esd_rec);
3023: --------------------------------------------
3024: -- Call the DELETE_ROW for each child record
3025: --------------------------------------------

Line 3031: l_okl_xtd_sell_invs_tl_rec

3027: p_init_msg_list,
3028: x_return_status,
3029: x_msg_count,
3030: x_msg_data,
3031: l_okl_xtd_sell_invs_tl_rec
3032: );
3033: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3034: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3035: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN