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_TAL_PVT dependencies on OKL_TXL_ASSETS_TL

Line 1748: DELETE FROM OKL_TXL_ASSETS_TL T

1744: -- PROCEDURE add_language
1745: ---------------------------------------------------------------------------
1746: PROCEDURE add_language IS
1747: BEGIN
1748: DELETE FROM OKL_TXL_ASSETS_TL T
1749: WHERE NOT EXISTS (
1750: SELECT NULL
1751: FROM OKL_TXL_ASSETS_B B --fixed bug 3321017 by kmotepal
1752: WHERE B.ID = T.ID

Line 1755: UPDATE OKL_TXL_ASSETS_TL T SET (

1751: FROM OKL_TXL_ASSETS_B B --fixed bug 3321017 by kmotepal
1752: WHERE B.ID = T.ID
1753: );
1754:
1755: UPDATE OKL_TXL_ASSETS_TL T SET (
1756: DESCRIPTION) = (SELECT
1757: B.DESCRIPTION
1758: FROM OKL_TXL_ASSETS_TL B
1759: WHERE B.ID = T.ID

Line 1758: FROM OKL_TXL_ASSETS_TL B

1754:
1755: UPDATE OKL_TXL_ASSETS_TL T SET (
1756: DESCRIPTION) = (SELECT
1757: B.DESCRIPTION
1758: FROM OKL_TXL_ASSETS_TL B
1759: WHERE B.ID = T.ID
1760: AND B.LANGUAGE = T.SOURCE_LANG)
1761: WHERE (
1762: T.ID,

Line 1767: FROM OKL_TXL_ASSETS_TL SUBB, OKL_TXL_ASSETS_TL SUBT

1763: T.LANGUAGE)
1764: IN (SELECT
1765: SUBT.ID,
1766: SUBT.LANGUAGE
1767: FROM OKL_TXL_ASSETS_TL SUBB, OKL_TXL_ASSETS_TL SUBT
1768: WHERE SUBB.ID = SUBT.ID
1769: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
1770: AND (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
1771: OR (SUBB.DESCRIPTION IS NULL AND SUBT.DESCRIPTION IS NOT NULL)

Line 1775: INSERT INTO OKL_TXL_ASSETS_TL (

1771: OR (SUBB.DESCRIPTION IS NULL AND SUBT.DESCRIPTION IS NOT NULL)
1772: OR (SUBB.DESCRIPTION IS NOT NULL AND SUBT.DESCRIPTION IS NULL)
1773: ));
1774:
1775: INSERT INTO OKL_TXL_ASSETS_TL (
1776: ID,
1777: LANGUAGE,
1778: SOURCE_LANG,
1779: SFWT_FLAG,

Line 1797: FROM OKL_TXL_ASSETS_TL B, FND_LANGUAGES L

1793: B.CREATION_DATE,
1794: B.LAST_UPDATED_BY,
1795: B.LAST_UPDATE_DATE,
1796: B.LAST_UPDATE_LOGIN
1797: FROM OKL_TXL_ASSETS_TL B, FND_LANGUAGES L
1798: WHERE L.INSTALLED_FLAG IN ('I', 'B')
1799: AND B.LANGUAGE = USERENV('LANG')
1800: AND NOT EXISTS(
1801: SELECT NULL

Line 1802: FROM OKL_TXL_ASSETS_TL T

1798: WHERE L.INSTALLED_FLAG IN ('I', 'B')
1799: AND B.LANGUAGE = USERENV('LANG')
1800: AND NOT EXISTS(
1801: SELECT NULL
1802: FROM OKL_TXL_ASSETS_TL T
1803: WHERE T.ID = B.ID
1804: AND T.LANGUAGE = L.LANGUAGE_CODE
1805: );
1806:

Line 2013: -- FUNCTION get_rec for: OKL_TXL_ASSETS_TL

2009: BEGIN
2010: RETURN(get_rec(p_tal_rec, l_row_notfound));
2011: END get_rec;
2012: ---------------------------------------------------------------------------
2013: -- FUNCTION get_rec for: OKL_TXL_ASSETS_TL
2014: ---------------------------------------------------------------------------
2015: FUNCTION get_rec (
2016: p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type,
2017: x_no_data_found OUT NOCOPY BOOLEAN

Line 2016: p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type,

2012: ---------------------------------------------------------------------------
2013: -- FUNCTION get_rec for: OKL_TXL_ASSETS_TL
2014: ---------------------------------------------------------------------------
2015: FUNCTION get_rec (
2016: p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type,
2017: x_no_data_found OUT NOCOPY BOOLEAN
2018: ) RETURN okl_txl_assets_tl_rec_type IS
2019: CURSOR okl_txl_asset_tl_pk_csr (p_id IN NUMBER,
2020: p_language IN VARCHAR2) IS

Line 2018: ) RETURN okl_txl_assets_tl_rec_type IS

2014: ---------------------------------------------------------------------------
2015: FUNCTION get_rec (
2016: p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type,
2017: x_no_data_found OUT NOCOPY BOOLEAN
2018: ) RETURN okl_txl_assets_tl_rec_type IS
2019: CURSOR okl_txl_asset_tl_pk_csr (p_id IN NUMBER,
2020: p_language IN VARCHAR2) IS
2021: SELECT
2022: ID,

Line 2032: FROM Okl_Txl_Assets_Tl

2028: CREATION_DATE,
2029: LAST_UPDATED_BY,
2030: LAST_UPDATE_DATE,
2031: LAST_UPDATE_LOGIN
2032: FROM Okl_Txl_Assets_Tl
2033: WHERE okl_txl_assets_tl.id = p_id
2034: AND okl_txl_assets_tl.language = p_language;
2035: l_okl_txl_asset_tl_pk okl_txl_asset_tl_pk_csr%ROWTYPE;
2036: l_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;

Line 2033: WHERE okl_txl_assets_tl.id = p_id

2029: LAST_UPDATED_BY,
2030: LAST_UPDATE_DATE,
2031: LAST_UPDATE_LOGIN
2032: FROM Okl_Txl_Assets_Tl
2033: WHERE okl_txl_assets_tl.id = p_id
2034: AND okl_txl_assets_tl.language = p_language;
2035: l_okl_txl_asset_tl_pk okl_txl_asset_tl_pk_csr%ROWTYPE;
2036: l_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;
2037: BEGIN

Line 2034: AND okl_txl_assets_tl.language = p_language;

2030: LAST_UPDATE_DATE,
2031: LAST_UPDATE_LOGIN
2032: FROM Okl_Txl_Assets_Tl
2033: WHERE okl_txl_assets_tl.id = p_id
2034: AND okl_txl_assets_tl.language = p_language;
2035: l_okl_txl_asset_tl_pk okl_txl_asset_tl_pk_csr%ROWTYPE;
2036: l_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;
2037: BEGIN
2038: x_no_data_found := TRUE;

Line 2036: l_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;

2032: FROM Okl_Txl_Assets_Tl
2033: WHERE okl_txl_assets_tl.id = p_id
2034: AND okl_txl_assets_tl.language = p_language;
2035: l_okl_txl_asset_tl_pk okl_txl_asset_tl_pk_csr%ROWTYPE;
2036: l_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;
2037: BEGIN
2038: x_no_data_found := TRUE;
2039: -- Get current database values
2040: OPEN okl_txl_asset_tl_pk_csr (p_okl_txl_assets_tl_rec.id,

Line 2040: OPEN okl_txl_asset_tl_pk_csr (p_okl_txl_assets_tl_rec.id,

2036: l_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;
2037: BEGIN
2038: x_no_data_found := TRUE;
2039: -- Get current database values
2040: OPEN okl_txl_asset_tl_pk_csr (p_okl_txl_assets_tl_rec.id,
2041: p_okl_txl_assets_tl_rec.language);
2042: FETCH okl_txl_asset_tl_pk_csr INTO
2043: l_okl_txl_assets_tl_rec.ID,
2044: l_okl_txl_assets_tl_rec.LANGUAGE,

Line 2041: p_okl_txl_assets_tl_rec.language);

2037: BEGIN
2038: x_no_data_found := TRUE;
2039: -- Get current database values
2040: OPEN okl_txl_asset_tl_pk_csr (p_okl_txl_assets_tl_rec.id,
2041: p_okl_txl_assets_tl_rec.language);
2042: FETCH okl_txl_asset_tl_pk_csr INTO
2043: l_okl_txl_assets_tl_rec.ID,
2044: l_okl_txl_assets_tl_rec.LANGUAGE,
2045: l_okl_txl_assets_tl_rec.SOURCE_LANG,

Line 2043: l_okl_txl_assets_tl_rec.ID,

2039: -- Get current database values
2040: OPEN okl_txl_asset_tl_pk_csr (p_okl_txl_assets_tl_rec.id,
2041: p_okl_txl_assets_tl_rec.language);
2042: FETCH okl_txl_asset_tl_pk_csr INTO
2043: l_okl_txl_assets_tl_rec.ID,
2044: l_okl_txl_assets_tl_rec.LANGUAGE,
2045: l_okl_txl_assets_tl_rec.SOURCE_LANG,
2046: l_okl_txl_assets_tl_rec.SFWT_FLAG,
2047: l_okl_txl_assets_tl_rec.DESCRIPTION,

Line 2044: l_okl_txl_assets_tl_rec.LANGUAGE,

2040: OPEN okl_txl_asset_tl_pk_csr (p_okl_txl_assets_tl_rec.id,
2041: p_okl_txl_assets_tl_rec.language);
2042: FETCH okl_txl_asset_tl_pk_csr INTO
2043: l_okl_txl_assets_tl_rec.ID,
2044: l_okl_txl_assets_tl_rec.LANGUAGE,
2045: l_okl_txl_assets_tl_rec.SOURCE_LANG,
2046: l_okl_txl_assets_tl_rec.SFWT_FLAG,
2047: l_okl_txl_assets_tl_rec.DESCRIPTION,
2048: l_okl_txl_assets_tl_rec.CREATED_BY,

Line 2045: l_okl_txl_assets_tl_rec.SOURCE_LANG,

2041: p_okl_txl_assets_tl_rec.language);
2042: FETCH okl_txl_asset_tl_pk_csr INTO
2043: l_okl_txl_assets_tl_rec.ID,
2044: l_okl_txl_assets_tl_rec.LANGUAGE,
2045: l_okl_txl_assets_tl_rec.SOURCE_LANG,
2046: l_okl_txl_assets_tl_rec.SFWT_FLAG,
2047: l_okl_txl_assets_tl_rec.DESCRIPTION,
2048: l_okl_txl_assets_tl_rec.CREATED_BY,
2049: l_okl_txl_assets_tl_rec.CREATION_DATE,

Line 2046: l_okl_txl_assets_tl_rec.SFWT_FLAG,

2042: FETCH okl_txl_asset_tl_pk_csr INTO
2043: l_okl_txl_assets_tl_rec.ID,
2044: l_okl_txl_assets_tl_rec.LANGUAGE,
2045: l_okl_txl_assets_tl_rec.SOURCE_LANG,
2046: l_okl_txl_assets_tl_rec.SFWT_FLAG,
2047: l_okl_txl_assets_tl_rec.DESCRIPTION,
2048: l_okl_txl_assets_tl_rec.CREATED_BY,
2049: l_okl_txl_assets_tl_rec.CREATION_DATE,
2050: l_okl_txl_assets_tl_rec.LAST_UPDATED_BY,

Line 2047: l_okl_txl_assets_tl_rec.DESCRIPTION,

2043: l_okl_txl_assets_tl_rec.ID,
2044: l_okl_txl_assets_tl_rec.LANGUAGE,
2045: l_okl_txl_assets_tl_rec.SOURCE_LANG,
2046: l_okl_txl_assets_tl_rec.SFWT_FLAG,
2047: l_okl_txl_assets_tl_rec.DESCRIPTION,
2048: l_okl_txl_assets_tl_rec.CREATED_BY,
2049: l_okl_txl_assets_tl_rec.CREATION_DATE,
2050: l_okl_txl_assets_tl_rec.LAST_UPDATED_BY,
2051: l_okl_txl_assets_tl_rec.LAST_UPDATE_DATE,

Line 2048: l_okl_txl_assets_tl_rec.CREATED_BY,

2044: l_okl_txl_assets_tl_rec.LANGUAGE,
2045: l_okl_txl_assets_tl_rec.SOURCE_LANG,
2046: l_okl_txl_assets_tl_rec.SFWT_FLAG,
2047: l_okl_txl_assets_tl_rec.DESCRIPTION,
2048: l_okl_txl_assets_tl_rec.CREATED_BY,
2049: l_okl_txl_assets_tl_rec.CREATION_DATE,
2050: l_okl_txl_assets_tl_rec.LAST_UPDATED_BY,
2051: l_okl_txl_assets_tl_rec.LAST_UPDATE_DATE,
2052: l_okl_txl_assets_tl_rec.LAST_UPDATE_LOGIN;

Line 2049: l_okl_txl_assets_tl_rec.CREATION_DATE,

2045: l_okl_txl_assets_tl_rec.SOURCE_LANG,
2046: l_okl_txl_assets_tl_rec.SFWT_FLAG,
2047: l_okl_txl_assets_tl_rec.DESCRIPTION,
2048: l_okl_txl_assets_tl_rec.CREATED_BY,
2049: l_okl_txl_assets_tl_rec.CREATION_DATE,
2050: l_okl_txl_assets_tl_rec.LAST_UPDATED_BY,
2051: l_okl_txl_assets_tl_rec.LAST_UPDATE_DATE,
2052: l_okl_txl_assets_tl_rec.LAST_UPDATE_LOGIN;
2053: x_no_data_found := okl_txl_asset_tl_pk_csr%NOTFOUND;

Line 2050: l_okl_txl_assets_tl_rec.LAST_UPDATED_BY,

2046: l_okl_txl_assets_tl_rec.SFWT_FLAG,
2047: l_okl_txl_assets_tl_rec.DESCRIPTION,
2048: l_okl_txl_assets_tl_rec.CREATED_BY,
2049: l_okl_txl_assets_tl_rec.CREATION_DATE,
2050: l_okl_txl_assets_tl_rec.LAST_UPDATED_BY,
2051: l_okl_txl_assets_tl_rec.LAST_UPDATE_DATE,
2052: l_okl_txl_assets_tl_rec.LAST_UPDATE_LOGIN;
2053: x_no_data_found := okl_txl_asset_tl_pk_csr%NOTFOUND;
2054: CLOSE okl_txl_asset_tl_pk_csr;

Line 2051: l_okl_txl_assets_tl_rec.LAST_UPDATE_DATE,

2047: l_okl_txl_assets_tl_rec.DESCRIPTION,
2048: l_okl_txl_assets_tl_rec.CREATED_BY,
2049: l_okl_txl_assets_tl_rec.CREATION_DATE,
2050: l_okl_txl_assets_tl_rec.LAST_UPDATED_BY,
2051: l_okl_txl_assets_tl_rec.LAST_UPDATE_DATE,
2052: l_okl_txl_assets_tl_rec.LAST_UPDATE_LOGIN;
2053: x_no_data_found := okl_txl_asset_tl_pk_csr%NOTFOUND;
2054: CLOSE okl_txl_asset_tl_pk_csr;
2055: RETURN(l_okl_txl_assets_tl_rec);

Line 2052: l_okl_txl_assets_tl_rec.LAST_UPDATE_LOGIN;

2048: l_okl_txl_assets_tl_rec.CREATED_BY,
2049: l_okl_txl_assets_tl_rec.CREATION_DATE,
2050: l_okl_txl_assets_tl_rec.LAST_UPDATED_BY,
2051: l_okl_txl_assets_tl_rec.LAST_UPDATE_DATE,
2052: l_okl_txl_assets_tl_rec.LAST_UPDATE_LOGIN;
2053: x_no_data_found := okl_txl_asset_tl_pk_csr%NOTFOUND;
2054: CLOSE okl_txl_asset_tl_pk_csr;
2055: RETURN(l_okl_txl_assets_tl_rec);
2056: END get_rec;

Line 2055: RETURN(l_okl_txl_assets_tl_rec);

2051: l_okl_txl_assets_tl_rec.LAST_UPDATE_DATE,
2052: l_okl_txl_assets_tl_rec.LAST_UPDATE_LOGIN;
2053: x_no_data_found := okl_txl_asset_tl_pk_csr%NOTFOUND;
2054: CLOSE okl_txl_asset_tl_pk_csr;
2055: RETURN(l_okl_txl_assets_tl_rec);
2056: END get_rec;
2057:
2058: FUNCTION get_rec (
2059: p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type

Line 2059: p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type

2055: RETURN(l_okl_txl_assets_tl_rec);
2056: END get_rec;
2057:
2058: FUNCTION get_rec (
2059: p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type
2060: ) RETURN okl_txl_assets_tl_rec_type IS
2061: l_row_notfound BOOLEAN := TRUE;
2062: BEGIN
2063: RETURN(get_rec(p_okl_txl_assets_tl_rec, l_row_notfound));

Line 2060: ) RETURN okl_txl_assets_tl_rec_type IS

2056: END get_rec;
2057:
2058: FUNCTION get_rec (
2059: p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type
2060: ) RETURN okl_txl_assets_tl_rec_type IS
2061: l_row_notfound BOOLEAN := TRUE;
2062: BEGIN
2063: RETURN(get_rec(p_okl_txl_assets_tl_rec, l_row_notfound));
2064: END get_rec;

Line 2063: RETURN(get_rec(p_okl_txl_assets_tl_rec, l_row_notfound));

2059: p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type
2060: ) RETURN okl_txl_assets_tl_rec_type IS
2061: l_row_notfound BOOLEAN := TRUE;
2062: BEGIN
2063: RETURN(get_rec(p_okl_txl_assets_tl_rec, l_row_notfound));
2064: END get_rec;
2065: ---------------------------------------------------------------------------
2066: -- FUNCTION get_rec for: OKL_TXL_ASSETS_V
2067: ---------------------------------------------------------------------------

Line 2985: p_to IN OUT NOCOPY okl_txl_assets_tl_rec_type

2981:
2982: END migrate;
2983: PROCEDURE migrate (
2984: p_from IN talv_rec_type,
2985: p_to IN OUT NOCOPY okl_txl_assets_tl_rec_type
2986: ) IS
2987: BEGIN
2988: p_to.id := p_from.id;
2989: p_to.sfwt_flag := p_from.sfwt_flag;

Line 2998: p_from IN okl_txl_assets_tl_rec_type,

2994: p_to.last_update_date := p_from.last_update_date;
2995: p_to.last_update_login := p_from.last_update_login;
2996: END migrate;
2997: PROCEDURE migrate (
2998: p_from IN okl_txl_assets_tl_rec_type,
2999: p_to IN OUT NOCOPY talv_rec_type
3000: ) IS
3001: BEGIN
3002: p_to.id := p_from.id;

Line 3031: l_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;

3027: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
3028: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3029: l_talv_rec talv_rec_type := p_talv_rec;
3030: l_tal_rec tal_rec_type;
3031: l_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;
3032: BEGIN
3033: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
3034: G_PKG_NAME,
3035: p_init_msg_list,

Line 3423: -- insert_row for:OKL_TXL_ASSETS_TL --

3419: '_PVT'
3420: );
3421: END insert_row;
3422: --------------------------------------
3423: -- insert_row for:OKL_TXL_ASSETS_TL --
3424: --------------------------------------
3425: PROCEDURE insert_row(
3426: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3427: x_return_status OUT NOCOPY VARCHAR2,

Line 3430: p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type,

3426: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3427: x_return_status OUT NOCOPY VARCHAR2,
3428: x_msg_count OUT NOCOPY NUMBER,
3429: x_msg_data OUT NOCOPY VARCHAR2,
3430: p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type,
3431: x_okl_txl_assets_tl_rec OUT NOCOPY okl_txl_assets_tl_rec_type) IS
3432:
3433: l_api_version CONSTANT NUMBER := 1;
3434: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';

Line 3431: x_okl_txl_assets_tl_rec OUT NOCOPY okl_txl_assets_tl_rec_type) IS

3427: x_return_status OUT NOCOPY VARCHAR2,
3428: x_msg_count OUT NOCOPY NUMBER,
3429: x_msg_data OUT NOCOPY VARCHAR2,
3430: p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type,
3431: x_okl_txl_assets_tl_rec OUT NOCOPY okl_txl_assets_tl_rec_type) IS
3432:
3433: l_api_version CONSTANT NUMBER := 1;
3434: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
3435: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 3436: l_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type := p_okl_txl_assets_tl_rec;

3432:
3433: l_api_version CONSTANT NUMBER := 1;
3434: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
3435: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3436: l_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type := p_okl_txl_assets_tl_rec;
3437: l_def_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;
3438: CURSOR get_languages IS
3439: SELECT *
3440: FROM FND_LANGUAGES

Line 3437: l_def_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;

3433: l_api_version CONSTANT NUMBER := 1;
3434: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
3435: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3436: l_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type := p_okl_txl_assets_tl_rec;
3437: l_def_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;
3438: CURSOR get_languages IS
3439: SELECT *
3440: FROM FND_LANGUAGES
3441: WHERE INSTALLED_FLAG IN ('I', 'B');

Line 3443: -- Set_Attributes for:OKL_TXL_ASSETS_TL --

3439: SELECT *
3440: FROM FND_LANGUAGES
3441: WHERE INSTALLED_FLAG IN ('I', 'B');
3442: ------------------------------------------
3443: -- Set_Attributes for:OKL_TXL_ASSETS_TL --
3444: ------------------------------------------
3445: FUNCTION Set_Attributes (
3446: p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type,
3447: x_okl_txl_assets_tl_rec OUT NOCOPY okl_txl_assets_tl_rec_type

Line 3446: p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type,

3442: ------------------------------------------
3443: -- Set_Attributes for:OKL_TXL_ASSETS_TL --
3444: ------------------------------------------
3445: FUNCTION Set_Attributes (
3446: p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type,
3447: x_okl_txl_assets_tl_rec OUT NOCOPY okl_txl_assets_tl_rec_type
3448: ) RETURN VARCHAR2 IS
3449: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3450: BEGIN

Line 3447: x_okl_txl_assets_tl_rec OUT NOCOPY okl_txl_assets_tl_rec_type

3443: -- Set_Attributes for:OKL_TXL_ASSETS_TL --
3444: ------------------------------------------
3445: FUNCTION Set_Attributes (
3446: p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type,
3447: x_okl_txl_assets_tl_rec OUT NOCOPY okl_txl_assets_tl_rec_type
3448: ) RETURN VARCHAR2 IS
3449: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3450: BEGIN
3451: x_okl_txl_assets_tl_rec := p_okl_txl_assets_tl_rec;

Line 3451: x_okl_txl_assets_tl_rec := p_okl_txl_assets_tl_rec;

3447: x_okl_txl_assets_tl_rec OUT NOCOPY okl_txl_assets_tl_rec_type
3448: ) RETURN VARCHAR2 IS
3449: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3450: BEGIN
3451: x_okl_txl_assets_tl_rec := p_okl_txl_assets_tl_rec;
3452: x_okl_txl_assets_tl_rec.LANGUAGE := USERENV('LANG');
3453: x_okl_txl_assets_tl_rec.SOURCE_LANG := USERENV('LANG');
3454: RETURN(l_return_status);
3455: END Set_Attributes;

Line 3452: x_okl_txl_assets_tl_rec.LANGUAGE := USERENV('LANG');

3448: ) RETURN VARCHAR2 IS
3449: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3450: BEGIN
3451: x_okl_txl_assets_tl_rec := p_okl_txl_assets_tl_rec;
3452: x_okl_txl_assets_tl_rec.LANGUAGE := USERENV('LANG');
3453: x_okl_txl_assets_tl_rec.SOURCE_LANG := USERENV('LANG');
3454: RETURN(l_return_status);
3455: END Set_Attributes;
3456: BEGIN

Line 3453: x_okl_txl_assets_tl_rec.SOURCE_LANG := USERENV('LANG');

3449: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3450: BEGIN
3451: x_okl_txl_assets_tl_rec := p_okl_txl_assets_tl_rec;
3452: x_okl_txl_assets_tl_rec.LANGUAGE := USERENV('LANG');
3453: x_okl_txl_assets_tl_rec.SOURCE_LANG := USERENV('LANG');
3454: RETURN(l_return_status);
3455: END Set_Attributes;
3456: BEGIN
3457: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3468: p_okl_txl_assets_tl_rec, -- IN

3464: RAISE OKC_API.G_EXCEPTION_ERROR;
3465: END IF;
3466: --- Setting item attributes
3467: l_return_status := Set_Attributes(
3468: p_okl_txl_assets_tl_rec, -- IN
3469: l_okl_txl_assets_tl_rec); -- OUT
3470: --- If any errors happen abort API
3471: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3472: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3469: l_okl_txl_assets_tl_rec); -- OUT

3465: END IF;
3466: --- Setting item attributes
3467: l_return_status := Set_Attributes(
3468: p_okl_txl_assets_tl_rec, -- IN
3469: l_okl_txl_assets_tl_rec); -- OUT
3470: --- If any errors happen abort API
3471: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3472: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3473: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 3477: l_okl_txl_assets_tl_rec.language := l_lang_rec.language_code;

3473: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3474: RAISE OKC_API.G_EXCEPTION_ERROR;
3475: END IF;
3476: FOR l_lang_rec IN get_languages LOOP
3477: l_okl_txl_assets_tl_rec.language := l_lang_rec.language_code;
3478: INSERT INTO OKL_TXL_ASSETS_TL(
3479: id,
3480: language,
3481: source_lang,

Line 3478: INSERT INTO OKL_TXL_ASSETS_TL(

3474: RAISE OKC_API.G_EXCEPTION_ERROR;
3475: END IF;
3476: FOR l_lang_rec IN get_languages LOOP
3477: l_okl_txl_assets_tl_rec.language := l_lang_rec.language_code;
3478: INSERT INTO OKL_TXL_ASSETS_TL(
3479: id,
3480: language,
3481: source_lang,
3482: sfwt_flag,

Line 3490: l_okl_txl_assets_tl_rec.id,

3486: last_updated_by,
3487: last_update_date,
3488: last_update_login)
3489: VALUES (
3490: l_okl_txl_assets_tl_rec.id,
3491: l_okl_txl_assets_tl_rec.language,
3492: l_okl_txl_assets_tl_rec.source_lang,
3493: l_okl_txl_assets_tl_rec.sfwt_flag,
3494: l_okl_txl_assets_tl_rec.description,

Line 3491: l_okl_txl_assets_tl_rec.language,

3487: last_update_date,
3488: last_update_login)
3489: VALUES (
3490: l_okl_txl_assets_tl_rec.id,
3491: l_okl_txl_assets_tl_rec.language,
3492: l_okl_txl_assets_tl_rec.source_lang,
3493: l_okl_txl_assets_tl_rec.sfwt_flag,
3494: l_okl_txl_assets_tl_rec.description,
3495: l_okl_txl_assets_tl_rec.created_by,

Line 3492: l_okl_txl_assets_tl_rec.source_lang,

3488: last_update_login)
3489: VALUES (
3490: l_okl_txl_assets_tl_rec.id,
3491: l_okl_txl_assets_tl_rec.language,
3492: l_okl_txl_assets_tl_rec.source_lang,
3493: l_okl_txl_assets_tl_rec.sfwt_flag,
3494: l_okl_txl_assets_tl_rec.description,
3495: l_okl_txl_assets_tl_rec.created_by,
3496: l_okl_txl_assets_tl_rec.creation_date,

Line 3493: l_okl_txl_assets_tl_rec.sfwt_flag,

3489: VALUES (
3490: l_okl_txl_assets_tl_rec.id,
3491: l_okl_txl_assets_tl_rec.language,
3492: l_okl_txl_assets_tl_rec.source_lang,
3493: l_okl_txl_assets_tl_rec.sfwt_flag,
3494: l_okl_txl_assets_tl_rec.description,
3495: l_okl_txl_assets_tl_rec.created_by,
3496: l_okl_txl_assets_tl_rec.creation_date,
3497: l_okl_txl_assets_tl_rec.last_updated_by,

Line 3494: l_okl_txl_assets_tl_rec.description,

3490: l_okl_txl_assets_tl_rec.id,
3491: l_okl_txl_assets_tl_rec.language,
3492: l_okl_txl_assets_tl_rec.source_lang,
3493: l_okl_txl_assets_tl_rec.sfwt_flag,
3494: l_okl_txl_assets_tl_rec.description,
3495: l_okl_txl_assets_tl_rec.created_by,
3496: l_okl_txl_assets_tl_rec.creation_date,
3497: l_okl_txl_assets_tl_rec.last_updated_by,
3498: l_okl_txl_assets_tl_rec.last_update_date,

Line 3495: l_okl_txl_assets_tl_rec.created_by,

3491: l_okl_txl_assets_tl_rec.language,
3492: l_okl_txl_assets_tl_rec.source_lang,
3493: l_okl_txl_assets_tl_rec.sfwt_flag,
3494: l_okl_txl_assets_tl_rec.description,
3495: l_okl_txl_assets_tl_rec.created_by,
3496: l_okl_txl_assets_tl_rec.creation_date,
3497: l_okl_txl_assets_tl_rec.last_updated_by,
3498: l_okl_txl_assets_tl_rec.last_update_date,
3499: l_okl_txl_assets_tl_rec.last_update_login);

Line 3496: l_okl_txl_assets_tl_rec.creation_date,

3492: l_okl_txl_assets_tl_rec.source_lang,
3493: l_okl_txl_assets_tl_rec.sfwt_flag,
3494: l_okl_txl_assets_tl_rec.description,
3495: l_okl_txl_assets_tl_rec.created_by,
3496: l_okl_txl_assets_tl_rec.creation_date,
3497: l_okl_txl_assets_tl_rec.last_updated_by,
3498: l_okl_txl_assets_tl_rec.last_update_date,
3499: l_okl_txl_assets_tl_rec.last_update_login);
3500: END LOOP;

Line 3497: l_okl_txl_assets_tl_rec.last_updated_by,

3493: l_okl_txl_assets_tl_rec.sfwt_flag,
3494: l_okl_txl_assets_tl_rec.description,
3495: l_okl_txl_assets_tl_rec.created_by,
3496: l_okl_txl_assets_tl_rec.creation_date,
3497: l_okl_txl_assets_tl_rec.last_updated_by,
3498: l_okl_txl_assets_tl_rec.last_update_date,
3499: l_okl_txl_assets_tl_rec.last_update_login);
3500: END LOOP;
3501: -- Set OUT values

Line 3498: l_okl_txl_assets_tl_rec.last_update_date,

3494: l_okl_txl_assets_tl_rec.description,
3495: l_okl_txl_assets_tl_rec.created_by,
3496: l_okl_txl_assets_tl_rec.creation_date,
3497: l_okl_txl_assets_tl_rec.last_updated_by,
3498: l_okl_txl_assets_tl_rec.last_update_date,
3499: l_okl_txl_assets_tl_rec.last_update_login);
3500: END LOOP;
3501: -- Set OUT values
3502: x_okl_txl_assets_tl_rec := l_okl_txl_assets_tl_rec;

Line 3499: l_okl_txl_assets_tl_rec.last_update_login);

3495: l_okl_txl_assets_tl_rec.created_by,
3496: l_okl_txl_assets_tl_rec.creation_date,
3497: l_okl_txl_assets_tl_rec.last_updated_by,
3498: l_okl_txl_assets_tl_rec.last_update_date,
3499: l_okl_txl_assets_tl_rec.last_update_login);
3500: END LOOP;
3501: -- Set OUT values
3502: x_okl_txl_assets_tl_rec := l_okl_txl_assets_tl_rec;
3503: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 3502: x_okl_txl_assets_tl_rec := l_okl_txl_assets_tl_rec;

3498: l_okl_txl_assets_tl_rec.last_update_date,
3499: l_okl_txl_assets_tl_rec.last_update_login);
3500: END LOOP;
3501: -- Set OUT values
3502: x_okl_txl_assets_tl_rec := l_okl_txl_assets_tl_rec;
3503: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3504: EXCEPTION
3505: WHEN OKC_API.G_EXCEPTION_ERROR THEN
3506: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 3555: l_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;

3551: l_talv_rec talv_rec_type;
3552: l_def_talv_rec talv_rec_type;
3553: l_tal_rec tal_rec_type;
3554: lx_tal_rec tal_rec_type;
3555: l_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;
3556: lx_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;
3557: lx_temp_talv_rec talv_rec_type;
3558: -------------------------------
3559: -- FUNCTION fill_who_columns --

Line 3556: lx_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;

3552: l_def_talv_rec talv_rec_type;
3553: l_tal_rec tal_rec_type;
3554: lx_tal_rec tal_rec_type;
3555: l_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;
3556: lx_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;
3557: lx_temp_talv_rec talv_rec_type;
3558: -------------------------------
3559: -- FUNCTION fill_who_columns --
3560: -------------------------------

Line 3679: migrate(l_def_talv_rec, l_okl_txl_assets_tl_rec);

3675: --------------------------------------
3676: -- Move VIEW record to "Child" records
3677: --------------------------------------
3678: migrate(l_def_talv_rec, l_tal_rec);
3679: migrate(l_def_talv_rec, l_okl_txl_assets_tl_rec);
3680:
3681: --dbms_output.put_line('After migrate: '||l_tal_rec.currency_code);
3682: --------------------------------------------
3683: -- Call the INSERT_ROW for each child record

Line 3704: l_okl_txl_assets_tl_rec,

3700: p_init_msg_list,
3701: x_return_status,
3702: x_msg_count,
3703: x_msg_data,
3704: l_okl_txl_assets_tl_rec,
3705: lx_okl_txl_assets_tl_rec
3706: );
3707: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3708: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3705: lx_okl_txl_assets_tl_rec

3701: x_return_status,
3702: x_msg_count,
3703: x_msg_data,
3704: l_okl_txl_assets_tl_rec,
3705: lx_okl_txl_assets_tl_rec
3706: );
3707: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3708: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3709: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 3712: migrate(lx_okl_txl_assets_tl_rec, l_def_talv_rec);

3708: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3709: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3710: RAISE OKC_API.G_EXCEPTION_ERROR;
3711: END IF;
3712: migrate(lx_okl_txl_assets_tl_rec, l_def_talv_rec);
3713: -- Set OUT values
3714: x_talv_rec := l_def_talv_rec;
3715: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3716: EXCEPTION

Line 3925: -- lock_row for:OKL_TXL_ASSETS_TL --

3921: '_PVT'
3922: );
3923: END lock_row;
3924: ------------------------------------
3925: -- lock_row for:OKL_TXL_ASSETS_TL --
3926: ------------------------------------
3927: PROCEDURE lock_row(
3928: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3929: x_return_status OUT NOCOPY VARCHAR2,

Line 3932: p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type) IS

3928: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3929: x_return_status OUT NOCOPY VARCHAR2,
3930: x_msg_count OUT NOCOPY NUMBER,
3931: x_msg_data OUT NOCOPY VARCHAR2,
3932: p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type) IS
3933:
3934: E_Resource_Busy EXCEPTION;
3935: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
3936: CURSOR lock_csr (p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type) IS

Line 3936: CURSOR lock_csr (p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type) IS

3932: p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type) IS
3933:
3934: E_Resource_Busy EXCEPTION;
3935: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
3936: CURSOR lock_csr (p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type) IS
3937: SELECT *
3938: FROM OKL_TXL_ASSETS_TL
3939: WHERE ID = p_okl_txl_assets_tl_rec.id
3940: FOR UPDATE NOWAIT;

Line 3938: FROM OKL_TXL_ASSETS_TL

3934: E_Resource_Busy EXCEPTION;
3935: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
3936: CURSOR lock_csr (p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type) IS
3937: SELECT *
3938: FROM OKL_TXL_ASSETS_TL
3939: WHERE ID = p_okl_txl_assets_tl_rec.id
3940: FOR UPDATE NOWAIT;
3941:
3942: l_api_version CONSTANT NUMBER := 1;

Line 3939: WHERE ID = p_okl_txl_assets_tl_rec.id

3935: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
3936: CURSOR lock_csr (p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type) IS
3937: SELECT *
3938: FROM OKL_TXL_ASSETS_TL
3939: WHERE ID = p_okl_txl_assets_tl_rec.id
3940: FOR UPDATE NOWAIT;
3941:
3942: l_api_version CONSTANT NUMBER := 1;
3943: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';

Line 3959: OPEN lock_csr(p_okl_txl_assets_tl_rec);

3955: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3956: RAISE OKC_API.G_EXCEPTION_ERROR;
3957: END IF;
3958: BEGIN
3959: OPEN lock_csr(p_okl_txl_assets_tl_rec);
3960: FETCH lock_csr INTO l_lock_var;
3961: l_row_notfound := lock_csr%NOTFOUND;
3962: CLOSE lock_csr;
3963: EXCEPTION

Line 4024: l_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;

4020: l_api_version CONSTANT NUMBER := 1;
4021: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
4022: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4023: l_tal_rec tal_rec_type;
4024: l_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;
4025: BEGIN
4026: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
4027: G_PKG_NAME,
4028: p_init_msg_list,

Line 4042: migrate(p_talv_rec, l_okl_txl_assets_tl_rec);

4038: --------------------------------------
4039: -- Move VIEW record to "Child" records
4040: --------------------------------------
4041: migrate(p_talv_rec, l_tal_rec);
4042: migrate(p_talv_rec, l_okl_txl_assets_tl_rec);
4043: --------------------------------------------
4044: -- Call the LOCK_ROW for each child record
4045: --------------------------------------------
4046: lock_row(

Line 4063: l_okl_txl_assets_tl_rec

4059: p_init_msg_list,
4060: x_return_status,
4061: x_msg_count,
4062: x_msg_data,
4063: l_okl_txl_assets_tl_rec
4064: );
4065: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4066: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4067: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 4695: -- update_row for:OKL_TXL_ASSETS_TL --

4691: '_PVT'
4692: );
4693: END update_row;
4694: --------------------------------------
4695: -- update_row for:OKL_TXL_ASSETS_TL --
4696: --------------------------------------
4697: PROCEDURE update_row(
4698: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
4699: x_return_status OUT NOCOPY VARCHAR2,

Line 4702: p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type,

4698: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
4699: x_return_status OUT NOCOPY VARCHAR2,
4700: x_msg_count OUT NOCOPY NUMBER,
4701: x_msg_data OUT NOCOPY VARCHAR2,
4702: p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type,
4703: x_okl_txl_assets_tl_rec OUT NOCOPY okl_txl_assets_tl_rec_type) IS
4704:
4705: l_api_version CONSTANT NUMBER := 1;
4706: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';

Line 4703: x_okl_txl_assets_tl_rec OUT NOCOPY okl_txl_assets_tl_rec_type) IS

4699: x_return_status OUT NOCOPY VARCHAR2,
4700: x_msg_count OUT NOCOPY NUMBER,
4701: x_msg_data OUT NOCOPY VARCHAR2,
4702: p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type,
4703: x_okl_txl_assets_tl_rec OUT NOCOPY okl_txl_assets_tl_rec_type) IS
4704:
4705: l_api_version CONSTANT NUMBER := 1;
4706: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
4707: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 4708: l_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type := p_okl_txl_assets_tl_rec;

4704:
4705: l_api_version CONSTANT NUMBER := 1;
4706: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
4707: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4708: l_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type := p_okl_txl_assets_tl_rec;
4709: l_def_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;
4710: l_row_notfound BOOLEAN := TRUE;
4711: ----------------------------------
4712: -- FUNCTION populate_new_record --

Line 4709: l_def_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;

4705: l_api_version CONSTANT NUMBER := 1;
4706: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
4707: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4708: l_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type := p_okl_txl_assets_tl_rec;
4709: l_def_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;
4710: l_row_notfound BOOLEAN := TRUE;
4711: ----------------------------------
4712: -- FUNCTION populate_new_record --
4713: ----------------------------------

Line 4715: p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type,

4711: ----------------------------------
4712: -- FUNCTION populate_new_record --
4713: ----------------------------------
4714: FUNCTION populate_new_record (
4715: p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type,
4716: x_okl_txl_assets_tl_rec OUT NOCOPY okl_txl_assets_tl_rec_type
4717: ) RETURN VARCHAR2 IS
4718: l_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;
4719: l_row_notfound BOOLEAN := TRUE;

Line 4716: x_okl_txl_assets_tl_rec OUT NOCOPY okl_txl_assets_tl_rec_type

4712: -- FUNCTION populate_new_record --
4713: ----------------------------------
4714: FUNCTION populate_new_record (
4715: p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type,
4716: x_okl_txl_assets_tl_rec OUT NOCOPY okl_txl_assets_tl_rec_type
4717: ) RETURN VARCHAR2 IS
4718: l_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;
4719: l_row_notfound BOOLEAN := TRUE;
4720: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 4718: l_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;

4714: FUNCTION populate_new_record (
4715: p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type,
4716: x_okl_txl_assets_tl_rec OUT NOCOPY okl_txl_assets_tl_rec_type
4717: ) RETURN VARCHAR2 IS
4718: l_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;
4719: l_row_notfound BOOLEAN := TRUE;
4720: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4721: BEGIN
4722: x_okl_txl_assets_tl_rec := p_okl_txl_assets_tl_rec;

Line 4722: x_okl_txl_assets_tl_rec := p_okl_txl_assets_tl_rec;

4718: l_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;
4719: l_row_notfound BOOLEAN := TRUE;
4720: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4721: BEGIN
4722: x_okl_txl_assets_tl_rec := p_okl_txl_assets_tl_rec;
4723: -- Get current database values
4724: l_okl_txl_assets_tl_rec := get_rec(p_okl_txl_assets_tl_rec, l_row_notfound);
4725: IF (l_row_notfound) THEN
4726: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

Line 4724: l_okl_txl_assets_tl_rec := get_rec(p_okl_txl_assets_tl_rec, l_row_notfound);

4720: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4721: BEGIN
4722: x_okl_txl_assets_tl_rec := p_okl_txl_assets_tl_rec;
4723: -- Get current database values
4724: l_okl_txl_assets_tl_rec := get_rec(p_okl_txl_assets_tl_rec, l_row_notfound);
4725: IF (l_row_notfound) THEN
4726: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
4727: END IF;
4728: IF (x_okl_txl_assets_tl_rec.id = OKC_API.G_MISS_NUM)

Line 4728: IF (x_okl_txl_assets_tl_rec.id = OKC_API.G_MISS_NUM)

4724: l_okl_txl_assets_tl_rec := get_rec(p_okl_txl_assets_tl_rec, l_row_notfound);
4725: IF (l_row_notfound) THEN
4726: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
4727: END IF;
4728: IF (x_okl_txl_assets_tl_rec.id = OKC_API.G_MISS_NUM)
4729: THEN
4730: x_okl_txl_assets_tl_rec.id := l_okl_txl_assets_tl_rec.id;
4731: END IF;
4732: IF (x_okl_txl_assets_tl_rec.language = OKC_API.G_MISS_CHAR)

Line 4730: x_okl_txl_assets_tl_rec.id := l_okl_txl_assets_tl_rec.id;

4726: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
4727: END IF;
4728: IF (x_okl_txl_assets_tl_rec.id = OKC_API.G_MISS_NUM)
4729: THEN
4730: x_okl_txl_assets_tl_rec.id := l_okl_txl_assets_tl_rec.id;
4731: END IF;
4732: IF (x_okl_txl_assets_tl_rec.language = OKC_API.G_MISS_CHAR)
4733: THEN
4734: x_okl_txl_assets_tl_rec.language := l_okl_txl_assets_tl_rec.language;

Line 4732: IF (x_okl_txl_assets_tl_rec.language = OKC_API.G_MISS_CHAR)

4728: IF (x_okl_txl_assets_tl_rec.id = OKC_API.G_MISS_NUM)
4729: THEN
4730: x_okl_txl_assets_tl_rec.id := l_okl_txl_assets_tl_rec.id;
4731: END IF;
4732: IF (x_okl_txl_assets_tl_rec.language = OKC_API.G_MISS_CHAR)
4733: THEN
4734: x_okl_txl_assets_tl_rec.language := l_okl_txl_assets_tl_rec.language;
4735: END IF;
4736: IF (x_okl_txl_assets_tl_rec.source_lang = OKC_API.G_MISS_CHAR)

Line 4734: x_okl_txl_assets_tl_rec.language := l_okl_txl_assets_tl_rec.language;

4730: x_okl_txl_assets_tl_rec.id := l_okl_txl_assets_tl_rec.id;
4731: END IF;
4732: IF (x_okl_txl_assets_tl_rec.language = OKC_API.G_MISS_CHAR)
4733: THEN
4734: x_okl_txl_assets_tl_rec.language := l_okl_txl_assets_tl_rec.language;
4735: END IF;
4736: IF (x_okl_txl_assets_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
4737: THEN
4738: x_okl_txl_assets_tl_rec.source_lang := l_okl_txl_assets_tl_rec.source_lang;

Line 4736: IF (x_okl_txl_assets_tl_rec.source_lang = OKC_API.G_MISS_CHAR)

4732: IF (x_okl_txl_assets_tl_rec.language = OKC_API.G_MISS_CHAR)
4733: THEN
4734: x_okl_txl_assets_tl_rec.language := l_okl_txl_assets_tl_rec.language;
4735: END IF;
4736: IF (x_okl_txl_assets_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
4737: THEN
4738: x_okl_txl_assets_tl_rec.source_lang := l_okl_txl_assets_tl_rec.source_lang;
4739: END IF;
4740: IF (x_okl_txl_assets_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)

Line 4738: x_okl_txl_assets_tl_rec.source_lang := l_okl_txl_assets_tl_rec.source_lang;

4734: x_okl_txl_assets_tl_rec.language := l_okl_txl_assets_tl_rec.language;
4735: END IF;
4736: IF (x_okl_txl_assets_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
4737: THEN
4738: x_okl_txl_assets_tl_rec.source_lang := l_okl_txl_assets_tl_rec.source_lang;
4739: END IF;
4740: IF (x_okl_txl_assets_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
4741: THEN
4742: x_okl_txl_assets_tl_rec.sfwt_flag := l_okl_txl_assets_tl_rec.sfwt_flag;

Line 4740: IF (x_okl_txl_assets_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)

4736: IF (x_okl_txl_assets_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
4737: THEN
4738: x_okl_txl_assets_tl_rec.source_lang := l_okl_txl_assets_tl_rec.source_lang;
4739: END IF;
4740: IF (x_okl_txl_assets_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
4741: THEN
4742: x_okl_txl_assets_tl_rec.sfwt_flag := l_okl_txl_assets_tl_rec.sfwt_flag;
4743: END IF;
4744: IF (x_okl_txl_assets_tl_rec.description = OKC_API.G_MISS_CHAR)

Line 4742: x_okl_txl_assets_tl_rec.sfwt_flag := l_okl_txl_assets_tl_rec.sfwt_flag;

4738: x_okl_txl_assets_tl_rec.source_lang := l_okl_txl_assets_tl_rec.source_lang;
4739: END IF;
4740: IF (x_okl_txl_assets_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
4741: THEN
4742: x_okl_txl_assets_tl_rec.sfwt_flag := l_okl_txl_assets_tl_rec.sfwt_flag;
4743: END IF;
4744: IF (x_okl_txl_assets_tl_rec.description = OKC_API.G_MISS_CHAR)
4745: THEN
4746: x_okl_txl_assets_tl_rec.description := l_okl_txl_assets_tl_rec.description;

Line 4744: IF (x_okl_txl_assets_tl_rec.description = OKC_API.G_MISS_CHAR)

4740: IF (x_okl_txl_assets_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
4741: THEN
4742: x_okl_txl_assets_tl_rec.sfwt_flag := l_okl_txl_assets_tl_rec.sfwt_flag;
4743: END IF;
4744: IF (x_okl_txl_assets_tl_rec.description = OKC_API.G_MISS_CHAR)
4745: THEN
4746: x_okl_txl_assets_tl_rec.description := l_okl_txl_assets_tl_rec.description;
4747: END IF;
4748: IF (x_okl_txl_assets_tl_rec.created_by = OKC_API.G_MISS_NUM)

Line 4746: x_okl_txl_assets_tl_rec.description := l_okl_txl_assets_tl_rec.description;

4742: x_okl_txl_assets_tl_rec.sfwt_flag := l_okl_txl_assets_tl_rec.sfwt_flag;
4743: END IF;
4744: IF (x_okl_txl_assets_tl_rec.description = OKC_API.G_MISS_CHAR)
4745: THEN
4746: x_okl_txl_assets_tl_rec.description := l_okl_txl_assets_tl_rec.description;
4747: END IF;
4748: IF (x_okl_txl_assets_tl_rec.created_by = OKC_API.G_MISS_NUM)
4749: THEN
4750: x_okl_txl_assets_tl_rec.created_by := l_okl_txl_assets_tl_rec.created_by;

Line 4748: IF (x_okl_txl_assets_tl_rec.created_by = OKC_API.G_MISS_NUM)

4744: IF (x_okl_txl_assets_tl_rec.description = OKC_API.G_MISS_CHAR)
4745: THEN
4746: x_okl_txl_assets_tl_rec.description := l_okl_txl_assets_tl_rec.description;
4747: END IF;
4748: IF (x_okl_txl_assets_tl_rec.created_by = OKC_API.G_MISS_NUM)
4749: THEN
4750: x_okl_txl_assets_tl_rec.created_by := l_okl_txl_assets_tl_rec.created_by;
4751: END IF;
4752: IF (x_okl_txl_assets_tl_rec.creation_date = OKC_API.G_MISS_DATE)

Line 4750: x_okl_txl_assets_tl_rec.created_by := l_okl_txl_assets_tl_rec.created_by;

4746: x_okl_txl_assets_tl_rec.description := l_okl_txl_assets_tl_rec.description;
4747: END IF;
4748: IF (x_okl_txl_assets_tl_rec.created_by = OKC_API.G_MISS_NUM)
4749: THEN
4750: x_okl_txl_assets_tl_rec.created_by := l_okl_txl_assets_tl_rec.created_by;
4751: END IF;
4752: IF (x_okl_txl_assets_tl_rec.creation_date = OKC_API.G_MISS_DATE)
4753: THEN
4754: x_okl_txl_assets_tl_rec.creation_date := l_okl_txl_assets_tl_rec.creation_date;

Line 4752: IF (x_okl_txl_assets_tl_rec.creation_date = OKC_API.G_MISS_DATE)

4748: IF (x_okl_txl_assets_tl_rec.created_by = OKC_API.G_MISS_NUM)
4749: THEN
4750: x_okl_txl_assets_tl_rec.created_by := l_okl_txl_assets_tl_rec.created_by;
4751: END IF;
4752: IF (x_okl_txl_assets_tl_rec.creation_date = OKC_API.G_MISS_DATE)
4753: THEN
4754: x_okl_txl_assets_tl_rec.creation_date := l_okl_txl_assets_tl_rec.creation_date;
4755: END IF;
4756: IF (x_okl_txl_assets_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)

Line 4754: x_okl_txl_assets_tl_rec.creation_date := l_okl_txl_assets_tl_rec.creation_date;

4750: x_okl_txl_assets_tl_rec.created_by := l_okl_txl_assets_tl_rec.created_by;
4751: END IF;
4752: IF (x_okl_txl_assets_tl_rec.creation_date = OKC_API.G_MISS_DATE)
4753: THEN
4754: x_okl_txl_assets_tl_rec.creation_date := l_okl_txl_assets_tl_rec.creation_date;
4755: END IF;
4756: IF (x_okl_txl_assets_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
4757: THEN
4758: x_okl_txl_assets_tl_rec.last_updated_by := l_okl_txl_assets_tl_rec.last_updated_by;

Line 4756: IF (x_okl_txl_assets_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)

4752: IF (x_okl_txl_assets_tl_rec.creation_date = OKC_API.G_MISS_DATE)
4753: THEN
4754: x_okl_txl_assets_tl_rec.creation_date := l_okl_txl_assets_tl_rec.creation_date;
4755: END IF;
4756: IF (x_okl_txl_assets_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
4757: THEN
4758: x_okl_txl_assets_tl_rec.last_updated_by := l_okl_txl_assets_tl_rec.last_updated_by;
4759: END IF;
4760: IF (x_okl_txl_assets_tl_rec.last_update_date = OKC_API.G_MISS_DATE)

Line 4758: x_okl_txl_assets_tl_rec.last_updated_by := l_okl_txl_assets_tl_rec.last_updated_by;

4754: x_okl_txl_assets_tl_rec.creation_date := l_okl_txl_assets_tl_rec.creation_date;
4755: END IF;
4756: IF (x_okl_txl_assets_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
4757: THEN
4758: x_okl_txl_assets_tl_rec.last_updated_by := l_okl_txl_assets_tl_rec.last_updated_by;
4759: END IF;
4760: IF (x_okl_txl_assets_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
4761: THEN
4762: x_okl_txl_assets_tl_rec.last_update_date := l_okl_txl_assets_tl_rec.last_update_date;

Line 4760: IF (x_okl_txl_assets_tl_rec.last_update_date = OKC_API.G_MISS_DATE)

4756: IF (x_okl_txl_assets_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
4757: THEN
4758: x_okl_txl_assets_tl_rec.last_updated_by := l_okl_txl_assets_tl_rec.last_updated_by;
4759: END IF;
4760: IF (x_okl_txl_assets_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
4761: THEN
4762: x_okl_txl_assets_tl_rec.last_update_date := l_okl_txl_assets_tl_rec.last_update_date;
4763: END IF;
4764: IF (x_okl_txl_assets_tl_rec.last_update_login = OKC_API.G_MISS_NUM)

Line 4762: x_okl_txl_assets_tl_rec.last_update_date := l_okl_txl_assets_tl_rec.last_update_date;

4758: x_okl_txl_assets_tl_rec.last_updated_by := l_okl_txl_assets_tl_rec.last_updated_by;
4759: END IF;
4760: IF (x_okl_txl_assets_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
4761: THEN
4762: x_okl_txl_assets_tl_rec.last_update_date := l_okl_txl_assets_tl_rec.last_update_date;
4763: END IF;
4764: IF (x_okl_txl_assets_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
4765: THEN
4766: x_okl_txl_assets_tl_rec.last_update_login := l_okl_txl_assets_tl_rec.last_update_login;

Line 4764: IF (x_okl_txl_assets_tl_rec.last_update_login = OKC_API.G_MISS_NUM)

4760: IF (x_okl_txl_assets_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
4761: THEN
4762: x_okl_txl_assets_tl_rec.last_update_date := l_okl_txl_assets_tl_rec.last_update_date;
4763: END IF;
4764: IF (x_okl_txl_assets_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
4765: THEN
4766: x_okl_txl_assets_tl_rec.last_update_login := l_okl_txl_assets_tl_rec.last_update_login;
4767: END IF;
4768: RETURN(l_return_status);

Line 4766: x_okl_txl_assets_tl_rec.last_update_login := l_okl_txl_assets_tl_rec.last_update_login;

4762: x_okl_txl_assets_tl_rec.last_update_date := l_okl_txl_assets_tl_rec.last_update_date;
4763: END IF;
4764: IF (x_okl_txl_assets_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
4765: THEN
4766: x_okl_txl_assets_tl_rec.last_update_login := l_okl_txl_assets_tl_rec.last_update_login;
4767: END IF;
4768: RETURN(l_return_status);
4769: END populate_new_record;
4770: ------------------------------------------

Line 4771: -- Set_Attributes for:OKL_TXL_ASSETS_TL --

4767: END IF;
4768: RETURN(l_return_status);
4769: END populate_new_record;
4770: ------------------------------------------
4771: -- Set_Attributes for:OKL_TXL_ASSETS_TL --
4772: ------------------------------------------
4773: FUNCTION Set_Attributes (
4774: p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type,
4775: x_okl_txl_assets_tl_rec OUT NOCOPY okl_txl_assets_tl_rec_type

Line 4774: p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type,

4770: ------------------------------------------
4771: -- Set_Attributes for:OKL_TXL_ASSETS_TL --
4772: ------------------------------------------
4773: FUNCTION Set_Attributes (
4774: p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type,
4775: x_okl_txl_assets_tl_rec OUT NOCOPY okl_txl_assets_tl_rec_type
4776: ) RETURN VARCHAR2 IS
4777: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4778: BEGIN

Line 4775: x_okl_txl_assets_tl_rec OUT NOCOPY okl_txl_assets_tl_rec_type

4771: -- Set_Attributes for:OKL_TXL_ASSETS_TL --
4772: ------------------------------------------
4773: FUNCTION Set_Attributes (
4774: p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type,
4775: x_okl_txl_assets_tl_rec OUT NOCOPY okl_txl_assets_tl_rec_type
4776: ) RETURN VARCHAR2 IS
4777: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4778: BEGIN
4779: x_okl_txl_assets_tl_rec := p_okl_txl_assets_tl_rec;

Line 4779: x_okl_txl_assets_tl_rec := p_okl_txl_assets_tl_rec;

4775: x_okl_txl_assets_tl_rec OUT NOCOPY okl_txl_assets_tl_rec_type
4776: ) RETURN VARCHAR2 IS
4777: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4778: BEGIN
4779: x_okl_txl_assets_tl_rec := p_okl_txl_assets_tl_rec;
4780: x_okl_txl_assets_tl_rec.LANGUAGE := USERENV('LANG');
4781: x_okl_txl_assets_tl_rec.SOURCE_LANG := USERENV('LANG');
4782: RETURN(l_return_status);
4783: END Set_Attributes;

Line 4780: x_okl_txl_assets_tl_rec.LANGUAGE := USERENV('LANG');

4776: ) RETURN VARCHAR2 IS
4777: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4778: BEGIN
4779: x_okl_txl_assets_tl_rec := p_okl_txl_assets_tl_rec;
4780: x_okl_txl_assets_tl_rec.LANGUAGE := USERENV('LANG');
4781: x_okl_txl_assets_tl_rec.SOURCE_LANG := USERENV('LANG');
4782: RETURN(l_return_status);
4783: END Set_Attributes;
4784: BEGIN

Line 4781: x_okl_txl_assets_tl_rec.SOURCE_LANG := USERENV('LANG');

4777: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4778: BEGIN
4779: x_okl_txl_assets_tl_rec := p_okl_txl_assets_tl_rec;
4780: x_okl_txl_assets_tl_rec.LANGUAGE := USERENV('LANG');
4781: x_okl_txl_assets_tl_rec.SOURCE_LANG := USERENV('LANG');
4782: RETURN(l_return_status);
4783: END Set_Attributes;
4784: BEGIN
4785: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 4796: p_okl_txl_assets_tl_rec, -- IN

4792: RAISE OKC_API.G_EXCEPTION_ERROR;
4793: END IF;
4794: --- Setting item attributes
4795: l_return_status := Set_Attributes(
4796: p_okl_txl_assets_tl_rec, -- IN
4797: l_okl_txl_assets_tl_rec); -- OUT
4798: --- If any errors happen abort API
4799: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4800: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 4797: l_okl_txl_assets_tl_rec); -- OUT

4793: END IF;
4794: --- Setting item attributes
4795: l_return_status := Set_Attributes(
4796: p_okl_txl_assets_tl_rec, -- IN
4797: l_okl_txl_assets_tl_rec); -- OUT
4798: --- If any errors happen abort API
4799: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4800: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4801: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 4804: l_return_status := populate_new_record(l_okl_txl_assets_tl_rec, l_def_okl_txl_assets_tl_rec);

4800: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4801: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4802: RAISE OKC_API.G_EXCEPTION_ERROR;
4803: END IF;
4804: l_return_status := populate_new_record(l_okl_txl_assets_tl_rec, l_def_okl_txl_assets_tl_rec);
4805: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4806: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4807: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4808: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 4810: UPDATE OKL_TXL_ASSETS_TL

4806: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4807: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4808: RAISE OKC_API.G_EXCEPTION_ERROR;
4809: END IF;
4810: UPDATE OKL_TXL_ASSETS_TL
4811: SET DESCRIPTION = l_def_okl_txl_assets_tl_rec.description,
4812: --Bug# 3641933 :
4813: SOURCE_LANG = l_def_okl_txl_assets_tl_rec.source_lang,
4814: CREATED_BY = l_def_okl_txl_assets_tl_rec.created_by,

Line 4811: SET DESCRIPTION = l_def_okl_txl_assets_tl_rec.description,

4807: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4808: RAISE OKC_API.G_EXCEPTION_ERROR;
4809: END IF;
4810: UPDATE OKL_TXL_ASSETS_TL
4811: SET DESCRIPTION = l_def_okl_txl_assets_tl_rec.description,
4812: --Bug# 3641933 :
4813: SOURCE_LANG = l_def_okl_txl_assets_tl_rec.source_lang,
4814: CREATED_BY = l_def_okl_txl_assets_tl_rec.created_by,
4815: CREATION_DATE = l_def_okl_txl_assets_tl_rec.creation_date,

Line 4813: SOURCE_LANG = l_def_okl_txl_assets_tl_rec.source_lang,

4809: END IF;
4810: UPDATE OKL_TXL_ASSETS_TL
4811: SET DESCRIPTION = l_def_okl_txl_assets_tl_rec.description,
4812: --Bug# 3641933 :
4813: SOURCE_LANG = l_def_okl_txl_assets_tl_rec.source_lang,
4814: CREATED_BY = l_def_okl_txl_assets_tl_rec.created_by,
4815: CREATION_DATE = l_def_okl_txl_assets_tl_rec.creation_date,
4816: LAST_UPDATED_BY = l_def_okl_txl_assets_tl_rec.last_updated_by,
4817: LAST_UPDATE_DATE = l_def_okl_txl_assets_tl_rec.last_update_date,

Line 4814: CREATED_BY = l_def_okl_txl_assets_tl_rec.created_by,

4810: UPDATE OKL_TXL_ASSETS_TL
4811: SET DESCRIPTION = l_def_okl_txl_assets_tl_rec.description,
4812: --Bug# 3641933 :
4813: SOURCE_LANG = l_def_okl_txl_assets_tl_rec.source_lang,
4814: CREATED_BY = l_def_okl_txl_assets_tl_rec.created_by,
4815: CREATION_DATE = l_def_okl_txl_assets_tl_rec.creation_date,
4816: LAST_UPDATED_BY = l_def_okl_txl_assets_tl_rec.last_updated_by,
4817: LAST_UPDATE_DATE = l_def_okl_txl_assets_tl_rec.last_update_date,
4818: LAST_UPDATE_LOGIN = l_def_okl_txl_assets_tl_rec.last_update_login

Line 4815: CREATION_DATE = l_def_okl_txl_assets_tl_rec.creation_date,

4811: SET DESCRIPTION = l_def_okl_txl_assets_tl_rec.description,
4812: --Bug# 3641933 :
4813: SOURCE_LANG = l_def_okl_txl_assets_tl_rec.source_lang,
4814: CREATED_BY = l_def_okl_txl_assets_tl_rec.created_by,
4815: CREATION_DATE = l_def_okl_txl_assets_tl_rec.creation_date,
4816: LAST_UPDATED_BY = l_def_okl_txl_assets_tl_rec.last_updated_by,
4817: LAST_UPDATE_DATE = l_def_okl_txl_assets_tl_rec.last_update_date,
4818: LAST_UPDATE_LOGIN = l_def_okl_txl_assets_tl_rec.last_update_login
4819: WHERE ID = l_def_okl_txl_assets_tl_rec.id

Line 4816: LAST_UPDATED_BY = l_def_okl_txl_assets_tl_rec.last_updated_by,

4812: --Bug# 3641933 :
4813: SOURCE_LANG = l_def_okl_txl_assets_tl_rec.source_lang,
4814: CREATED_BY = l_def_okl_txl_assets_tl_rec.created_by,
4815: CREATION_DATE = l_def_okl_txl_assets_tl_rec.creation_date,
4816: LAST_UPDATED_BY = l_def_okl_txl_assets_tl_rec.last_updated_by,
4817: LAST_UPDATE_DATE = l_def_okl_txl_assets_tl_rec.last_update_date,
4818: LAST_UPDATE_LOGIN = l_def_okl_txl_assets_tl_rec.last_update_login
4819: WHERE ID = l_def_okl_txl_assets_tl_rec.id
4820: --Bug# 3641933 :

Line 4817: LAST_UPDATE_DATE = l_def_okl_txl_assets_tl_rec.last_update_date,

4813: SOURCE_LANG = l_def_okl_txl_assets_tl_rec.source_lang,
4814: CREATED_BY = l_def_okl_txl_assets_tl_rec.created_by,
4815: CREATION_DATE = l_def_okl_txl_assets_tl_rec.creation_date,
4816: LAST_UPDATED_BY = l_def_okl_txl_assets_tl_rec.last_updated_by,
4817: LAST_UPDATE_DATE = l_def_okl_txl_assets_tl_rec.last_update_date,
4818: LAST_UPDATE_LOGIN = l_def_okl_txl_assets_tl_rec.last_update_login
4819: WHERE ID = l_def_okl_txl_assets_tl_rec.id
4820: --Bug# 3641933 :
4821: AND USERENV('LANG') in (SOURCE_LANG,LANGUAGE);

Line 4818: LAST_UPDATE_LOGIN = l_def_okl_txl_assets_tl_rec.last_update_login

4814: CREATED_BY = l_def_okl_txl_assets_tl_rec.created_by,
4815: CREATION_DATE = l_def_okl_txl_assets_tl_rec.creation_date,
4816: LAST_UPDATED_BY = l_def_okl_txl_assets_tl_rec.last_updated_by,
4817: LAST_UPDATE_DATE = l_def_okl_txl_assets_tl_rec.last_update_date,
4818: LAST_UPDATE_LOGIN = l_def_okl_txl_assets_tl_rec.last_update_login
4819: WHERE ID = l_def_okl_txl_assets_tl_rec.id
4820: --Bug# 3641933 :
4821: AND USERENV('LANG') in (SOURCE_LANG,LANGUAGE);
4822: --AND SOURCE_LANG = USERENV('LANG');

Line 4819: WHERE ID = l_def_okl_txl_assets_tl_rec.id

4815: CREATION_DATE = l_def_okl_txl_assets_tl_rec.creation_date,
4816: LAST_UPDATED_BY = l_def_okl_txl_assets_tl_rec.last_updated_by,
4817: LAST_UPDATE_DATE = l_def_okl_txl_assets_tl_rec.last_update_date,
4818: LAST_UPDATE_LOGIN = l_def_okl_txl_assets_tl_rec.last_update_login
4819: WHERE ID = l_def_okl_txl_assets_tl_rec.id
4820: --Bug# 3641933 :
4821: AND USERENV('LANG') in (SOURCE_LANG,LANGUAGE);
4822: --AND SOURCE_LANG = USERENV('LANG');
4823:

Line 4824: UPDATE OKL_TXL_ASSETS_TL

4820: --Bug# 3641933 :
4821: AND USERENV('LANG') in (SOURCE_LANG,LANGUAGE);
4822: --AND SOURCE_LANG = USERENV('LANG');
4823:
4824: UPDATE OKL_TXL_ASSETS_TL
4825: SET SFWT_FLAG = 'Y'
4826: WHERE ID = l_def_okl_txl_assets_tl_rec.id
4827: AND SOURCE_LANG <> USERENV('LANG');
4828:

Line 4826: WHERE ID = l_def_okl_txl_assets_tl_rec.id

4822: --AND SOURCE_LANG = USERENV('LANG');
4823:
4824: UPDATE OKL_TXL_ASSETS_TL
4825: SET SFWT_FLAG = 'Y'
4826: WHERE ID = l_def_okl_txl_assets_tl_rec.id
4827: AND SOURCE_LANG <> USERENV('LANG');
4828:
4829: x_okl_txl_assets_tl_rec := l_def_okl_txl_assets_tl_rec;
4830: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 4829: x_okl_txl_assets_tl_rec := l_def_okl_txl_assets_tl_rec;

4825: SET SFWT_FLAG = 'Y'
4826: WHERE ID = l_def_okl_txl_assets_tl_rec.id
4827: AND SOURCE_LANG <> USERENV('LANG');
4828:
4829: x_okl_txl_assets_tl_rec := l_def_okl_txl_assets_tl_rec;
4830: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
4831: EXCEPTION
4832: WHEN OKC_API.G_EXCEPTION_ERROR THEN
4833: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 4880: l_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;

4876: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
4877: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4878: l_talv_rec talv_rec_type := p_talv_rec;
4879: l_def_talv_rec talv_rec_type;
4880: l_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;
4881: lx_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;
4882: l_tal_rec tal_rec_type;
4883: lx_tal_rec tal_rec_type;
4884: lx_temp_talv_rec talv_rec_type;

Line 4881: lx_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;

4877: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4878: l_talv_rec talv_rec_type := p_talv_rec;
4879: l_def_talv_rec talv_rec_type;
4880: l_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;
4881: lx_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;
4882: l_tal_rec tal_rec_type;
4883: lx_tal_rec tal_rec_type;
4884: lx_temp_talv_rec talv_rec_type;
4885: -------------------------------

Line 5361: migrate(l_def_talv_rec, l_okl_txl_assets_tl_rec);

5357:
5358: --------------------------------------
5359: -- Move VIEW record to "Child" records
5360: --------------------------------------
5361: migrate(l_def_talv_rec, l_okl_txl_assets_tl_rec);
5362: migrate(l_def_talv_rec, l_tal_rec);
5363: --------------------------------------------
5364: -- Call the UPDATE_ROW for each child record
5365: --------------------------------------------

Line 5371: l_okl_txl_assets_tl_rec,

5367: p_init_msg_list,
5368: x_return_status,
5369: x_msg_count,
5370: x_msg_data,
5371: l_okl_txl_assets_tl_rec,
5372: lx_okl_txl_assets_tl_rec
5373: );
5374: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5375: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 5372: lx_okl_txl_assets_tl_rec

5368: x_return_status,
5369: x_msg_count,
5370: x_msg_data,
5371: l_okl_txl_assets_tl_rec,
5372: lx_okl_txl_assets_tl_rec
5373: );
5374: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5375: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5376: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 5379: migrate(lx_okl_txl_assets_tl_rec, l_def_talv_rec);

5375: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5376: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
5377: RAISE OKC_API.G_EXCEPTION_ERROR;
5378: END IF;
5379: migrate(lx_okl_txl_assets_tl_rec, l_def_talv_rec);
5380: update_row(
5381: p_init_msg_list,
5382: x_return_status,
5383: x_msg_count,

Line 5560: -- delete_row for:OKL_TXL_ASSETS_TL --

5556: '_PVT'
5557: );
5558: END delete_row;
5559: --------------------------------------
5560: -- delete_row for:OKL_TXL_ASSETS_TL --
5561: --------------------------------------
5562: PROCEDURE delete_row(
5563: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
5564: x_return_status OUT NOCOPY VARCHAR2,

Line 5567: p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type) IS

5563: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
5564: x_return_status OUT NOCOPY VARCHAR2,
5565: x_msg_count OUT NOCOPY NUMBER,
5566: x_msg_data OUT NOCOPY VARCHAR2,
5567: p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type) IS
5568:
5569: l_api_version CONSTANT NUMBER := 1;
5570: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
5571: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 5572: l_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type:= p_okl_txl_assets_tl_rec;

5568:
5569: l_api_version CONSTANT NUMBER := 1;
5570: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
5571: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5572: l_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type:= p_okl_txl_assets_tl_rec;
5573: l_row_notfound BOOLEAN := TRUE;
5574: ------------------------------------------
5575: -- Set_Attributes for:OKL_TXL_ASSETS_TL --
5576: ------------------------------------------

Line 5575: -- Set_Attributes for:OKL_TXL_ASSETS_TL --

5571: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5572: l_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type:= p_okl_txl_assets_tl_rec;
5573: l_row_notfound BOOLEAN := TRUE;
5574: ------------------------------------------
5575: -- Set_Attributes for:OKL_TXL_ASSETS_TL --
5576: ------------------------------------------
5577: FUNCTION Set_Attributes (
5578: p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type,
5579: x_okl_txl_assets_tl_rec OUT NOCOPY okl_txl_assets_tl_rec_type

Line 5578: p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type,

5574: ------------------------------------------
5575: -- Set_Attributes for:OKL_TXL_ASSETS_TL --
5576: ------------------------------------------
5577: FUNCTION Set_Attributes (
5578: p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type,
5579: x_okl_txl_assets_tl_rec OUT NOCOPY okl_txl_assets_tl_rec_type
5580: ) RETURN VARCHAR2 IS
5581: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5582: BEGIN

Line 5579: x_okl_txl_assets_tl_rec OUT NOCOPY okl_txl_assets_tl_rec_type

5575: -- Set_Attributes for:OKL_TXL_ASSETS_TL --
5576: ------------------------------------------
5577: FUNCTION Set_Attributes (
5578: p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type,
5579: x_okl_txl_assets_tl_rec OUT NOCOPY okl_txl_assets_tl_rec_type
5580: ) RETURN VARCHAR2 IS
5581: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5582: BEGIN
5583: x_okl_txl_assets_tl_rec := p_okl_txl_assets_tl_rec;

Line 5583: x_okl_txl_assets_tl_rec := p_okl_txl_assets_tl_rec;

5579: x_okl_txl_assets_tl_rec OUT NOCOPY okl_txl_assets_tl_rec_type
5580: ) RETURN VARCHAR2 IS
5581: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5582: BEGIN
5583: x_okl_txl_assets_tl_rec := p_okl_txl_assets_tl_rec;
5584: x_okl_txl_assets_tl_rec.LANGUAGE := USERENV('LANG');
5585: RETURN(l_return_status);
5586: END Set_Attributes;
5587: BEGIN

Line 5584: x_okl_txl_assets_tl_rec.LANGUAGE := USERENV('LANG');

5580: ) RETURN VARCHAR2 IS
5581: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5582: BEGIN
5583: x_okl_txl_assets_tl_rec := p_okl_txl_assets_tl_rec;
5584: x_okl_txl_assets_tl_rec.LANGUAGE := USERENV('LANG');
5585: RETURN(l_return_status);
5586: END Set_Attributes;
5587: BEGIN
5588: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 5599: p_okl_txl_assets_tl_rec, -- IN

5595: RAISE OKC_API.G_EXCEPTION_ERROR;
5596: END IF;
5597: --- Setting item attributes
5598: l_return_status := Set_Attributes(
5599: p_okl_txl_assets_tl_rec, -- IN
5600: l_okl_txl_assets_tl_rec); -- OUT
5601: --- If any errors happen abort API
5602: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5603: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 5600: l_okl_txl_assets_tl_rec); -- OUT

5596: END IF;
5597: --- Setting item attributes
5598: l_return_status := Set_Attributes(
5599: p_okl_txl_assets_tl_rec, -- IN
5600: l_okl_txl_assets_tl_rec); -- OUT
5601: --- If any errors happen abort API
5602: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5603: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5604: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 5607: DELETE FROM OKL_TXL_ASSETS_TL

5603: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5604: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5605: RAISE OKC_API.G_EXCEPTION_ERROR;
5606: END IF;
5607: DELETE FROM OKL_TXL_ASSETS_TL
5608: WHERE ID = l_okl_txl_assets_tl_rec.id;
5609:
5610: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
5611: EXCEPTION

Line 5608: WHERE ID = l_okl_txl_assets_tl_rec.id;

5604: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5605: RAISE OKC_API.G_EXCEPTION_ERROR;
5606: END IF;
5607: DELETE FROM OKL_TXL_ASSETS_TL
5608: WHERE ID = l_okl_txl_assets_tl_rec.id;
5609:
5610: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
5611: EXCEPTION
5612: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 5658: l_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;

5654: l_api_version CONSTANT NUMBER := 1;
5655: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
5656: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5657: l_talv_rec talv_rec_type := p_talv_rec;
5658: l_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;
5659: l_tal_rec tal_rec_type;
5660: BEGIN
5661: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
5662: G_PKG_NAME,

Line 5676: migrate(l_talv_rec, l_okl_txl_assets_tl_rec);

5672: END IF;
5673: --------------------------------------
5674: -- Move VIEW record to "Child" records
5675: --------------------------------------
5676: migrate(l_talv_rec, l_okl_txl_assets_tl_rec);
5677: migrate(l_talv_rec, l_tal_rec);
5678: --------------------------------------------
5679: -- Call the DELETE_ROW for each child record
5680: --------------------------------------------

Line 5686: l_okl_txl_assets_tl_rec

5682: p_init_msg_list,
5683: x_return_status,
5684: x_msg_count,
5685: x_msg_data,
5686: l_okl_txl_assets_tl_rec
5687: );
5688: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5689: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5690: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN