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 1764: DELETE FROM OKL_TXL_ASSETS_TL T

1760: -- PROCEDURE add_language
1761: ---------------------------------------------------------------------------
1762: PROCEDURE add_language IS
1763: BEGIN
1764: DELETE FROM OKL_TXL_ASSETS_TL T
1765: WHERE NOT EXISTS (
1766: SELECT NULL
1767: FROM OKL_TXL_ASSETS_B B --fixed bug 3321017 by kmotepal
1768: WHERE B.ID = T.ID

Line 1771: UPDATE OKL_TXL_ASSETS_TL T SET (

1767: FROM OKL_TXL_ASSETS_B B --fixed bug 3321017 by kmotepal
1768: WHERE B.ID = T.ID
1769: );
1770:
1771: UPDATE OKL_TXL_ASSETS_TL T SET (
1772: DESCRIPTION) = (SELECT
1773: B.DESCRIPTION
1774: FROM OKL_TXL_ASSETS_TL B
1775: WHERE B.ID = T.ID

Line 1774: FROM OKL_TXL_ASSETS_TL B

1770:
1771: UPDATE OKL_TXL_ASSETS_TL T SET (
1772: DESCRIPTION) = (SELECT
1773: B.DESCRIPTION
1774: FROM OKL_TXL_ASSETS_TL B
1775: WHERE B.ID = T.ID
1776: AND B.LANGUAGE = T.SOURCE_LANG)
1777: WHERE (
1778: T.ID,

Line 1783: FROM OKL_TXL_ASSETS_TL SUBB, OKL_TXL_ASSETS_TL SUBT

1779: T.LANGUAGE)
1780: IN (SELECT
1781: SUBT.ID,
1782: SUBT.LANGUAGE
1783: FROM OKL_TXL_ASSETS_TL SUBB, OKL_TXL_ASSETS_TL SUBT
1784: WHERE SUBB.ID = SUBT.ID
1785: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
1786: AND (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
1787: OR (SUBB.DESCRIPTION IS NULL AND SUBT.DESCRIPTION IS NOT NULL)

Line 1791: INSERT INTO OKL_TXL_ASSETS_TL (

1787: OR (SUBB.DESCRIPTION IS NULL AND SUBT.DESCRIPTION IS NOT NULL)
1788: OR (SUBB.DESCRIPTION IS NOT NULL AND SUBT.DESCRIPTION IS NULL)
1789: ));
1790:
1791: INSERT INTO OKL_TXL_ASSETS_TL (
1792: ID,
1793: LANGUAGE,
1794: SOURCE_LANG,
1795: SFWT_FLAG,

Line 1813: FROM OKL_TXL_ASSETS_TL B, FND_LANGUAGES L

1809: B.CREATION_DATE,
1810: B.LAST_UPDATED_BY,
1811: B.LAST_UPDATE_DATE,
1812: B.LAST_UPDATE_LOGIN
1813: FROM OKL_TXL_ASSETS_TL B, FND_LANGUAGES L
1814: WHERE L.INSTALLED_FLAG IN ('I', 'B')
1815: AND B.LANGUAGE = USERENV('LANG')
1816: AND NOT EXISTS(
1817: SELECT NULL

Line 1818: FROM OKL_TXL_ASSETS_TL T

1814: WHERE L.INSTALLED_FLAG IN ('I', 'B')
1815: AND B.LANGUAGE = USERENV('LANG')
1816: AND NOT EXISTS(
1817: SELECT NULL
1818: FROM OKL_TXL_ASSETS_TL T
1819: WHERE T.ID = B.ID
1820: AND T.LANGUAGE = L.LANGUAGE_CODE
1821: );
1822:

Line 2029: -- FUNCTION get_rec for: OKL_TXL_ASSETS_TL

2025: BEGIN
2026: RETURN(get_rec(p_tal_rec, l_row_notfound));
2027: END get_rec;
2028: ---------------------------------------------------------------------------
2029: -- FUNCTION get_rec for: OKL_TXL_ASSETS_TL
2030: ---------------------------------------------------------------------------
2031: FUNCTION get_rec (
2032: p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type,
2033: x_no_data_found OUT NOCOPY BOOLEAN

Line 2032: p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type,

2028: ---------------------------------------------------------------------------
2029: -- FUNCTION get_rec for: OKL_TXL_ASSETS_TL
2030: ---------------------------------------------------------------------------
2031: FUNCTION get_rec (
2032: p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type,
2033: x_no_data_found OUT NOCOPY BOOLEAN
2034: ) RETURN okl_txl_assets_tl_rec_type IS
2035: CURSOR okl_txl_asset_tl_pk_csr (p_id IN NUMBER,
2036: p_language IN VARCHAR2) IS

Line 2034: ) RETURN okl_txl_assets_tl_rec_type IS

2030: ---------------------------------------------------------------------------
2031: FUNCTION get_rec (
2032: p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type,
2033: x_no_data_found OUT NOCOPY BOOLEAN
2034: ) RETURN okl_txl_assets_tl_rec_type IS
2035: CURSOR okl_txl_asset_tl_pk_csr (p_id IN NUMBER,
2036: p_language IN VARCHAR2) IS
2037: SELECT
2038: ID,

Line 2048: FROM Okl_Txl_Assets_Tl

2044: CREATION_DATE,
2045: LAST_UPDATED_BY,
2046: LAST_UPDATE_DATE,
2047: LAST_UPDATE_LOGIN
2048: FROM Okl_Txl_Assets_Tl
2049: WHERE okl_txl_assets_tl.id = p_id
2050: AND okl_txl_assets_tl.language = p_language;
2051: l_okl_txl_asset_tl_pk okl_txl_asset_tl_pk_csr%ROWTYPE;
2052: l_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;

Line 2049: WHERE okl_txl_assets_tl.id = p_id

2045: LAST_UPDATED_BY,
2046: LAST_UPDATE_DATE,
2047: LAST_UPDATE_LOGIN
2048: FROM Okl_Txl_Assets_Tl
2049: WHERE okl_txl_assets_tl.id = p_id
2050: AND okl_txl_assets_tl.language = p_language;
2051: l_okl_txl_asset_tl_pk okl_txl_asset_tl_pk_csr%ROWTYPE;
2052: l_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;
2053: BEGIN

Line 2050: AND okl_txl_assets_tl.language = p_language;

2046: LAST_UPDATE_DATE,
2047: LAST_UPDATE_LOGIN
2048: FROM Okl_Txl_Assets_Tl
2049: WHERE okl_txl_assets_tl.id = p_id
2050: AND okl_txl_assets_tl.language = p_language;
2051: l_okl_txl_asset_tl_pk okl_txl_asset_tl_pk_csr%ROWTYPE;
2052: l_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;
2053: BEGIN
2054: x_no_data_found := TRUE;

Line 2052: l_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;

2048: FROM Okl_Txl_Assets_Tl
2049: WHERE okl_txl_assets_tl.id = p_id
2050: AND okl_txl_assets_tl.language = p_language;
2051: l_okl_txl_asset_tl_pk okl_txl_asset_tl_pk_csr%ROWTYPE;
2052: l_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;
2053: BEGIN
2054: x_no_data_found := TRUE;
2055: -- Get current database values
2056: OPEN okl_txl_asset_tl_pk_csr (p_okl_txl_assets_tl_rec.id,

Line 2056: OPEN okl_txl_asset_tl_pk_csr (p_okl_txl_assets_tl_rec.id,

2052: l_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;
2053: BEGIN
2054: x_no_data_found := TRUE;
2055: -- Get current database values
2056: OPEN okl_txl_asset_tl_pk_csr (p_okl_txl_assets_tl_rec.id,
2057: p_okl_txl_assets_tl_rec.language);
2058: FETCH okl_txl_asset_tl_pk_csr INTO
2059: l_okl_txl_assets_tl_rec.ID,
2060: l_okl_txl_assets_tl_rec.LANGUAGE,

Line 2057: p_okl_txl_assets_tl_rec.language);

2053: BEGIN
2054: x_no_data_found := TRUE;
2055: -- Get current database values
2056: OPEN okl_txl_asset_tl_pk_csr (p_okl_txl_assets_tl_rec.id,
2057: p_okl_txl_assets_tl_rec.language);
2058: FETCH okl_txl_asset_tl_pk_csr INTO
2059: l_okl_txl_assets_tl_rec.ID,
2060: l_okl_txl_assets_tl_rec.LANGUAGE,
2061: l_okl_txl_assets_tl_rec.SOURCE_LANG,

Line 2059: l_okl_txl_assets_tl_rec.ID,

2055: -- Get current database values
2056: OPEN okl_txl_asset_tl_pk_csr (p_okl_txl_assets_tl_rec.id,
2057: p_okl_txl_assets_tl_rec.language);
2058: FETCH okl_txl_asset_tl_pk_csr INTO
2059: l_okl_txl_assets_tl_rec.ID,
2060: l_okl_txl_assets_tl_rec.LANGUAGE,
2061: l_okl_txl_assets_tl_rec.SOURCE_LANG,
2062: l_okl_txl_assets_tl_rec.SFWT_FLAG,
2063: l_okl_txl_assets_tl_rec.DESCRIPTION,

Line 2060: l_okl_txl_assets_tl_rec.LANGUAGE,

2056: OPEN okl_txl_asset_tl_pk_csr (p_okl_txl_assets_tl_rec.id,
2057: p_okl_txl_assets_tl_rec.language);
2058: FETCH okl_txl_asset_tl_pk_csr INTO
2059: l_okl_txl_assets_tl_rec.ID,
2060: l_okl_txl_assets_tl_rec.LANGUAGE,
2061: l_okl_txl_assets_tl_rec.SOURCE_LANG,
2062: l_okl_txl_assets_tl_rec.SFWT_FLAG,
2063: l_okl_txl_assets_tl_rec.DESCRIPTION,
2064: l_okl_txl_assets_tl_rec.CREATED_BY,

Line 2061: l_okl_txl_assets_tl_rec.SOURCE_LANG,

2057: p_okl_txl_assets_tl_rec.language);
2058: FETCH okl_txl_asset_tl_pk_csr INTO
2059: l_okl_txl_assets_tl_rec.ID,
2060: l_okl_txl_assets_tl_rec.LANGUAGE,
2061: l_okl_txl_assets_tl_rec.SOURCE_LANG,
2062: l_okl_txl_assets_tl_rec.SFWT_FLAG,
2063: l_okl_txl_assets_tl_rec.DESCRIPTION,
2064: l_okl_txl_assets_tl_rec.CREATED_BY,
2065: l_okl_txl_assets_tl_rec.CREATION_DATE,

Line 2062: l_okl_txl_assets_tl_rec.SFWT_FLAG,

2058: FETCH okl_txl_asset_tl_pk_csr INTO
2059: l_okl_txl_assets_tl_rec.ID,
2060: l_okl_txl_assets_tl_rec.LANGUAGE,
2061: l_okl_txl_assets_tl_rec.SOURCE_LANG,
2062: l_okl_txl_assets_tl_rec.SFWT_FLAG,
2063: l_okl_txl_assets_tl_rec.DESCRIPTION,
2064: l_okl_txl_assets_tl_rec.CREATED_BY,
2065: l_okl_txl_assets_tl_rec.CREATION_DATE,
2066: l_okl_txl_assets_tl_rec.LAST_UPDATED_BY,

Line 2063: l_okl_txl_assets_tl_rec.DESCRIPTION,

2059: l_okl_txl_assets_tl_rec.ID,
2060: l_okl_txl_assets_tl_rec.LANGUAGE,
2061: l_okl_txl_assets_tl_rec.SOURCE_LANG,
2062: l_okl_txl_assets_tl_rec.SFWT_FLAG,
2063: l_okl_txl_assets_tl_rec.DESCRIPTION,
2064: l_okl_txl_assets_tl_rec.CREATED_BY,
2065: l_okl_txl_assets_tl_rec.CREATION_DATE,
2066: l_okl_txl_assets_tl_rec.LAST_UPDATED_BY,
2067: l_okl_txl_assets_tl_rec.LAST_UPDATE_DATE,

Line 2064: l_okl_txl_assets_tl_rec.CREATED_BY,

2060: l_okl_txl_assets_tl_rec.LANGUAGE,
2061: l_okl_txl_assets_tl_rec.SOURCE_LANG,
2062: l_okl_txl_assets_tl_rec.SFWT_FLAG,
2063: l_okl_txl_assets_tl_rec.DESCRIPTION,
2064: l_okl_txl_assets_tl_rec.CREATED_BY,
2065: l_okl_txl_assets_tl_rec.CREATION_DATE,
2066: l_okl_txl_assets_tl_rec.LAST_UPDATED_BY,
2067: l_okl_txl_assets_tl_rec.LAST_UPDATE_DATE,
2068: l_okl_txl_assets_tl_rec.LAST_UPDATE_LOGIN;

Line 2065: l_okl_txl_assets_tl_rec.CREATION_DATE,

2061: l_okl_txl_assets_tl_rec.SOURCE_LANG,
2062: l_okl_txl_assets_tl_rec.SFWT_FLAG,
2063: l_okl_txl_assets_tl_rec.DESCRIPTION,
2064: l_okl_txl_assets_tl_rec.CREATED_BY,
2065: l_okl_txl_assets_tl_rec.CREATION_DATE,
2066: l_okl_txl_assets_tl_rec.LAST_UPDATED_BY,
2067: l_okl_txl_assets_tl_rec.LAST_UPDATE_DATE,
2068: l_okl_txl_assets_tl_rec.LAST_UPDATE_LOGIN;
2069: x_no_data_found := okl_txl_asset_tl_pk_csr%NOTFOUND;

Line 2066: l_okl_txl_assets_tl_rec.LAST_UPDATED_BY,

2062: l_okl_txl_assets_tl_rec.SFWT_FLAG,
2063: l_okl_txl_assets_tl_rec.DESCRIPTION,
2064: l_okl_txl_assets_tl_rec.CREATED_BY,
2065: l_okl_txl_assets_tl_rec.CREATION_DATE,
2066: l_okl_txl_assets_tl_rec.LAST_UPDATED_BY,
2067: l_okl_txl_assets_tl_rec.LAST_UPDATE_DATE,
2068: l_okl_txl_assets_tl_rec.LAST_UPDATE_LOGIN;
2069: x_no_data_found := okl_txl_asset_tl_pk_csr%NOTFOUND;
2070: CLOSE okl_txl_asset_tl_pk_csr;

Line 2067: l_okl_txl_assets_tl_rec.LAST_UPDATE_DATE,

2063: l_okl_txl_assets_tl_rec.DESCRIPTION,
2064: l_okl_txl_assets_tl_rec.CREATED_BY,
2065: l_okl_txl_assets_tl_rec.CREATION_DATE,
2066: l_okl_txl_assets_tl_rec.LAST_UPDATED_BY,
2067: l_okl_txl_assets_tl_rec.LAST_UPDATE_DATE,
2068: l_okl_txl_assets_tl_rec.LAST_UPDATE_LOGIN;
2069: x_no_data_found := okl_txl_asset_tl_pk_csr%NOTFOUND;
2070: CLOSE okl_txl_asset_tl_pk_csr;
2071: RETURN(l_okl_txl_assets_tl_rec);

Line 2068: l_okl_txl_assets_tl_rec.LAST_UPDATE_LOGIN;

2064: l_okl_txl_assets_tl_rec.CREATED_BY,
2065: l_okl_txl_assets_tl_rec.CREATION_DATE,
2066: l_okl_txl_assets_tl_rec.LAST_UPDATED_BY,
2067: l_okl_txl_assets_tl_rec.LAST_UPDATE_DATE,
2068: l_okl_txl_assets_tl_rec.LAST_UPDATE_LOGIN;
2069: x_no_data_found := okl_txl_asset_tl_pk_csr%NOTFOUND;
2070: CLOSE okl_txl_asset_tl_pk_csr;
2071: RETURN(l_okl_txl_assets_tl_rec);
2072: END get_rec;

Line 2071: RETURN(l_okl_txl_assets_tl_rec);

2067: l_okl_txl_assets_tl_rec.LAST_UPDATE_DATE,
2068: l_okl_txl_assets_tl_rec.LAST_UPDATE_LOGIN;
2069: x_no_data_found := okl_txl_asset_tl_pk_csr%NOTFOUND;
2070: CLOSE okl_txl_asset_tl_pk_csr;
2071: RETURN(l_okl_txl_assets_tl_rec);
2072: END get_rec;
2073:
2074: FUNCTION get_rec (
2075: p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type

Line 2075: p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type

2071: RETURN(l_okl_txl_assets_tl_rec);
2072: END get_rec;
2073:
2074: FUNCTION get_rec (
2075: p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type
2076: ) RETURN okl_txl_assets_tl_rec_type IS
2077: l_row_notfound BOOLEAN := TRUE;
2078: BEGIN
2079: RETURN(get_rec(p_okl_txl_assets_tl_rec, l_row_notfound));

Line 2076: ) RETURN okl_txl_assets_tl_rec_type IS

2072: END get_rec;
2073:
2074: FUNCTION get_rec (
2075: p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type
2076: ) RETURN okl_txl_assets_tl_rec_type IS
2077: l_row_notfound BOOLEAN := TRUE;
2078: BEGIN
2079: RETURN(get_rec(p_okl_txl_assets_tl_rec, l_row_notfound));
2080: END get_rec;

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

2075: p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type
2076: ) RETURN okl_txl_assets_tl_rec_type IS
2077: l_row_notfound BOOLEAN := TRUE;
2078: BEGIN
2079: RETURN(get_rec(p_okl_txl_assets_tl_rec, l_row_notfound));
2080: END get_rec;
2081: ---------------------------------------------------------------------------
2082: -- FUNCTION get_rec for: OKL_TXL_ASSETS_V
2083: ---------------------------------------------------------------------------

Line 3001: p_to IN OUT NOCOPY okl_txl_assets_tl_rec_type

2997:
2998: END migrate;
2999: PROCEDURE migrate (
3000: p_from IN talv_rec_type,
3001: p_to IN OUT NOCOPY okl_txl_assets_tl_rec_type
3002: ) IS
3003: BEGIN
3004: p_to.id := p_from.id;
3005: p_to.sfwt_flag := p_from.sfwt_flag;

Line 3014: p_from IN okl_txl_assets_tl_rec_type,

3010: p_to.last_update_date := p_from.last_update_date;
3011: p_to.last_update_login := p_from.last_update_login;
3012: END migrate;
3013: PROCEDURE migrate (
3014: p_from IN okl_txl_assets_tl_rec_type,
3015: p_to IN OUT NOCOPY talv_rec_type
3016: ) IS
3017: BEGIN
3018: p_to.id := p_from.id;

Line 3047: l_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;

3043: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
3044: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3045: l_talv_rec talv_rec_type := p_talv_rec;
3046: l_tal_rec tal_rec_type;
3047: l_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;
3048: BEGIN
3049: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
3050: G_PKG_NAME,
3051: p_init_msg_list,

Line 3439: -- insert_row for:OKL_TXL_ASSETS_TL --

3435: '_PVT'
3436: );
3437: END insert_row;
3438: --------------------------------------
3439: -- insert_row for:OKL_TXL_ASSETS_TL --
3440: --------------------------------------
3441: PROCEDURE insert_row(
3442: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3443: x_return_status OUT NOCOPY VARCHAR2,

Line 3446: p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type,

3442: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3443: x_return_status OUT NOCOPY VARCHAR2,
3444: x_msg_count OUT NOCOPY NUMBER,
3445: x_msg_data OUT NOCOPY VARCHAR2,
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) IS
3448:
3449: l_api_version CONSTANT NUMBER := 1;
3450: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';

Line 3447: x_okl_txl_assets_tl_rec OUT NOCOPY okl_txl_assets_tl_rec_type) IS

3443: x_return_status OUT NOCOPY VARCHAR2,
3444: x_msg_count OUT NOCOPY NUMBER,
3445: x_msg_data OUT NOCOPY VARCHAR2,
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) IS
3448:
3449: l_api_version CONSTANT NUMBER := 1;
3450: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
3451: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 3452: l_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type := p_okl_txl_assets_tl_rec;

3448:
3449: l_api_version CONSTANT NUMBER := 1;
3450: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
3451: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3452: l_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type := p_okl_txl_assets_tl_rec;
3453: l_def_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;
3454: CURSOR get_languages IS
3455: SELECT *
3456: FROM FND_LANGUAGES

Line 3453: l_def_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;

3449: l_api_version CONSTANT NUMBER := 1;
3450: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
3451: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3452: l_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type := p_okl_txl_assets_tl_rec;
3453: l_def_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;
3454: CURSOR get_languages IS
3455: SELECT *
3456: FROM FND_LANGUAGES
3457: WHERE INSTALLED_FLAG IN ('I', 'B');

Line 3459: -- Set_Attributes for:OKL_TXL_ASSETS_TL --

3455: SELECT *
3456: FROM FND_LANGUAGES
3457: WHERE INSTALLED_FLAG IN ('I', 'B');
3458: ------------------------------------------
3459: -- Set_Attributes for:OKL_TXL_ASSETS_TL --
3460: ------------------------------------------
3461: FUNCTION Set_Attributes (
3462: p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type,
3463: x_okl_txl_assets_tl_rec OUT NOCOPY okl_txl_assets_tl_rec_type

Line 3462: p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type,

3458: ------------------------------------------
3459: -- Set_Attributes for:OKL_TXL_ASSETS_TL --
3460: ------------------------------------------
3461: FUNCTION Set_Attributes (
3462: p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type,
3463: x_okl_txl_assets_tl_rec OUT NOCOPY okl_txl_assets_tl_rec_type
3464: ) RETURN VARCHAR2 IS
3465: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3466: BEGIN

Line 3463: x_okl_txl_assets_tl_rec OUT NOCOPY okl_txl_assets_tl_rec_type

3459: -- Set_Attributes for:OKL_TXL_ASSETS_TL --
3460: ------------------------------------------
3461: FUNCTION Set_Attributes (
3462: p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type,
3463: x_okl_txl_assets_tl_rec OUT NOCOPY okl_txl_assets_tl_rec_type
3464: ) RETURN VARCHAR2 IS
3465: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3466: BEGIN
3467: x_okl_txl_assets_tl_rec := p_okl_txl_assets_tl_rec;

Line 3467: x_okl_txl_assets_tl_rec := p_okl_txl_assets_tl_rec;

3463: x_okl_txl_assets_tl_rec OUT NOCOPY okl_txl_assets_tl_rec_type
3464: ) RETURN VARCHAR2 IS
3465: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3466: BEGIN
3467: x_okl_txl_assets_tl_rec := p_okl_txl_assets_tl_rec;
3468: x_okl_txl_assets_tl_rec.LANGUAGE := USERENV('LANG');
3469: x_okl_txl_assets_tl_rec.SOURCE_LANG := USERENV('LANG');
3470: RETURN(l_return_status);
3471: END Set_Attributes;

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

3464: ) RETURN VARCHAR2 IS
3465: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3466: BEGIN
3467: x_okl_txl_assets_tl_rec := p_okl_txl_assets_tl_rec;
3468: x_okl_txl_assets_tl_rec.LANGUAGE := USERENV('LANG');
3469: x_okl_txl_assets_tl_rec.SOURCE_LANG := USERENV('LANG');
3470: RETURN(l_return_status);
3471: END Set_Attributes;
3472: BEGIN

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

3465: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3466: BEGIN
3467: x_okl_txl_assets_tl_rec := p_okl_txl_assets_tl_rec;
3468: x_okl_txl_assets_tl_rec.LANGUAGE := USERENV('LANG');
3469: x_okl_txl_assets_tl_rec.SOURCE_LANG := USERENV('LANG');
3470: RETURN(l_return_status);
3471: END Set_Attributes;
3472: BEGIN
3473: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3484: p_okl_txl_assets_tl_rec, -- IN

3480: RAISE OKC_API.G_EXCEPTION_ERROR;
3481: END IF;
3482: --- Setting item attributes
3483: l_return_status := Set_Attributes(
3484: p_okl_txl_assets_tl_rec, -- IN
3485: l_okl_txl_assets_tl_rec); -- OUT
3486: --- If any errors happen abort API
3487: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3488: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3485: l_okl_txl_assets_tl_rec); -- OUT

3481: END IF;
3482: --- Setting item attributes
3483: l_return_status := Set_Attributes(
3484: p_okl_txl_assets_tl_rec, -- IN
3485: l_okl_txl_assets_tl_rec); -- OUT
3486: --- If any errors happen abort API
3487: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3488: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3489: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

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

3489: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3490: RAISE OKC_API.G_EXCEPTION_ERROR;
3491: END IF;
3492: FOR l_lang_rec IN get_languages LOOP
3493: l_okl_txl_assets_tl_rec.language := l_lang_rec.language_code;
3494: INSERT INTO OKL_TXL_ASSETS_TL(
3495: id,
3496: language,
3497: source_lang,

Line 3494: INSERT INTO OKL_TXL_ASSETS_TL(

3490: RAISE OKC_API.G_EXCEPTION_ERROR;
3491: END IF;
3492: FOR l_lang_rec IN get_languages LOOP
3493: l_okl_txl_assets_tl_rec.language := l_lang_rec.language_code;
3494: INSERT INTO OKL_TXL_ASSETS_TL(
3495: id,
3496: language,
3497: source_lang,
3498: sfwt_flag,

Line 3506: l_okl_txl_assets_tl_rec.id,

3502: last_updated_by,
3503: last_update_date,
3504: last_update_login)
3505: VALUES (
3506: l_okl_txl_assets_tl_rec.id,
3507: l_okl_txl_assets_tl_rec.language,
3508: l_okl_txl_assets_tl_rec.source_lang,
3509: l_okl_txl_assets_tl_rec.sfwt_flag,
3510: l_okl_txl_assets_tl_rec.description,

Line 3507: l_okl_txl_assets_tl_rec.language,

3503: last_update_date,
3504: last_update_login)
3505: VALUES (
3506: l_okl_txl_assets_tl_rec.id,
3507: l_okl_txl_assets_tl_rec.language,
3508: l_okl_txl_assets_tl_rec.source_lang,
3509: l_okl_txl_assets_tl_rec.sfwt_flag,
3510: l_okl_txl_assets_tl_rec.description,
3511: l_okl_txl_assets_tl_rec.created_by,

Line 3508: l_okl_txl_assets_tl_rec.source_lang,

3504: last_update_login)
3505: VALUES (
3506: l_okl_txl_assets_tl_rec.id,
3507: l_okl_txl_assets_tl_rec.language,
3508: l_okl_txl_assets_tl_rec.source_lang,
3509: l_okl_txl_assets_tl_rec.sfwt_flag,
3510: l_okl_txl_assets_tl_rec.description,
3511: l_okl_txl_assets_tl_rec.created_by,
3512: l_okl_txl_assets_tl_rec.creation_date,

Line 3509: l_okl_txl_assets_tl_rec.sfwt_flag,

3505: VALUES (
3506: l_okl_txl_assets_tl_rec.id,
3507: l_okl_txl_assets_tl_rec.language,
3508: l_okl_txl_assets_tl_rec.source_lang,
3509: l_okl_txl_assets_tl_rec.sfwt_flag,
3510: l_okl_txl_assets_tl_rec.description,
3511: l_okl_txl_assets_tl_rec.created_by,
3512: l_okl_txl_assets_tl_rec.creation_date,
3513: l_okl_txl_assets_tl_rec.last_updated_by,

Line 3510: l_okl_txl_assets_tl_rec.description,

3506: l_okl_txl_assets_tl_rec.id,
3507: l_okl_txl_assets_tl_rec.language,
3508: l_okl_txl_assets_tl_rec.source_lang,
3509: l_okl_txl_assets_tl_rec.sfwt_flag,
3510: l_okl_txl_assets_tl_rec.description,
3511: l_okl_txl_assets_tl_rec.created_by,
3512: l_okl_txl_assets_tl_rec.creation_date,
3513: l_okl_txl_assets_tl_rec.last_updated_by,
3514: l_okl_txl_assets_tl_rec.last_update_date,

Line 3511: l_okl_txl_assets_tl_rec.created_by,

3507: l_okl_txl_assets_tl_rec.language,
3508: l_okl_txl_assets_tl_rec.source_lang,
3509: l_okl_txl_assets_tl_rec.sfwt_flag,
3510: l_okl_txl_assets_tl_rec.description,
3511: l_okl_txl_assets_tl_rec.created_by,
3512: l_okl_txl_assets_tl_rec.creation_date,
3513: l_okl_txl_assets_tl_rec.last_updated_by,
3514: l_okl_txl_assets_tl_rec.last_update_date,
3515: l_okl_txl_assets_tl_rec.last_update_login);

Line 3512: l_okl_txl_assets_tl_rec.creation_date,

3508: l_okl_txl_assets_tl_rec.source_lang,
3509: l_okl_txl_assets_tl_rec.sfwt_flag,
3510: l_okl_txl_assets_tl_rec.description,
3511: l_okl_txl_assets_tl_rec.created_by,
3512: l_okl_txl_assets_tl_rec.creation_date,
3513: l_okl_txl_assets_tl_rec.last_updated_by,
3514: l_okl_txl_assets_tl_rec.last_update_date,
3515: l_okl_txl_assets_tl_rec.last_update_login);
3516: END LOOP;

Line 3513: l_okl_txl_assets_tl_rec.last_updated_by,

3509: l_okl_txl_assets_tl_rec.sfwt_flag,
3510: l_okl_txl_assets_tl_rec.description,
3511: l_okl_txl_assets_tl_rec.created_by,
3512: l_okl_txl_assets_tl_rec.creation_date,
3513: l_okl_txl_assets_tl_rec.last_updated_by,
3514: l_okl_txl_assets_tl_rec.last_update_date,
3515: l_okl_txl_assets_tl_rec.last_update_login);
3516: END LOOP;
3517: -- Set OUT values

Line 3514: l_okl_txl_assets_tl_rec.last_update_date,

3510: l_okl_txl_assets_tl_rec.description,
3511: l_okl_txl_assets_tl_rec.created_by,
3512: l_okl_txl_assets_tl_rec.creation_date,
3513: l_okl_txl_assets_tl_rec.last_updated_by,
3514: l_okl_txl_assets_tl_rec.last_update_date,
3515: l_okl_txl_assets_tl_rec.last_update_login);
3516: END LOOP;
3517: -- Set OUT values
3518: x_okl_txl_assets_tl_rec := l_okl_txl_assets_tl_rec;

Line 3515: l_okl_txl_assets_tl_rec.last_update_login);

3511: l_okl_txl_assets_tl_rec.created_by,
3512: l_okl_txl_assets_tl_rec.creation_date,
3513: l_okl_txl_assets_tl_rec.last_updated_by,
3514: l_okl_txl_assets_tl_rec.last_update_date,
3515: l_okl_txl_assets_tl_rec.last_update_login);
3516: END LOOP;
3517: -- Set OUT values
3518: x_okl_txl_assets_tl_rec := l_okl_txl_assets_tl_rec;
3519: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 3518: x_okl_txl_assets_tl_rec := l_okl_txl_assets_tl_rec;

3514: l_okl_txl_assets_tl_rec.last_update_date,
3515: l_okl_txl_assets_tl_rec.last_update_login);
3516: END LOOP;
3517: -- Set OUT values
3518: x_okl_txl_assets_tl_rec := l_okl_txl_assets_tl_rec;
3519: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3520: EXCEPTION
3521: WHEN OKC_API.G_EXCEPTION_ERROR THEN
3522: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 3571: l_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;

3567: l_talv_rec talv_rec_type;
3568: l_def_talv_rec talv_rec_type;
3569: l_tal_rec tal_rec_type;
3570: lx_tal_rec tal_rec_type;
3571: l_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;
3572: lx_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;
3573: lx_temp_talv_rec talv_rec_type;
3574: -------------------------------
3575: -- FUNCTION fill_who_columns --

Line 3572: lx_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;

3568: l_def_talv_rec talv_rec_type;
3569: l_tal_rec tal_rec_type;
3570: lx_tal_rec tal_rec_type;
3571: l_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;
3572: lx_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;
3573: lx_temp_talv_rec talv_rec_type;
3574: -------------------------------
3575: -- FUNCTION fill_who_columns --
3576: -------------------------------

Line 3695: migrate(l_def_talv_rec, l_okl_txl_assets_tl_rec);

3691: --------------------------------------
3692: -- Move VIEW record to "Child" records
3693: --------------------------------------
3694: migrate(l_def_talv_rec, l_tal_rec);
3695: migrate(l_def_talv_rec, l_okl_txl_assets_tl_rec);
3696:
3697: --dbms_output.put_line('After migrate: '||l_tal_rec.currency_code);
3698: --------------------------------------------
3699: -- Call the INSERT_ROW for each child record

Line 3720: l_okl_txl_assets_tl_rec,

3716: p_init_msg_list,
3717: x_return_status,
3718: x_msg_count,
3719: x_msg_data,
3720: l_okl_txl_assets_tl_rec,
3721: lx_okl_txl_assets_tl_rec
3722: );
3723: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3724: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3721: lx_okl_txl_assets_tl_rec

3717: x_return_status,
3718: x_msg_count,
3719: x_msg_data,
3720: l_okl_txl_assets_tl_rec,
3721: lx_okl_txl_assets_tl_rec
3722: );
3723: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3724: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3725: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 3728: migrate(lx_okl_txl_assets_tl_rec, l_def_talv_rec);

3724: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3725: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3726: RAISE OKC_API.G_EXCEPTION_ERROR;
3727: END IF;
3728: migrate(lx_okl_txl_assets_tl_rec, l_def_talv_rec);
3729: -- Set OUT values
3730: x_talv_rec := l_def_talv_rec;
3731: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3732: EXCEPTION

Line 3941: -- lock_row for:OKL_TXL_ASSETS_TL --

3937: '_PVT'
3938: );
3939: END lock_row;
3940: ------------------------------------
3941: -- lock_row for:OKL_TXL_ASSETS_TL --
3942: ------------------------------------
3943: PROCEDURE lock_row(
3944: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3945: x_return_status OUT NOCOPY VARCHAR2,

Line 3948: p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type) IS

3944: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3945: x_return_status OUT NOCOPY VARCHAR2,
3946: x_msg_count OUT NOCOPY NUMBER,
3947: x_msg_data OUT NOCOPY VARCHAR2,
3948: p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type) IS
3949:
3950: E_Resource_Busy EXCEPTION;
3951: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
3952: CURSOR lock_csr (p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type) IS

Line 3952: CURSOR lock_csr (p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type) IS

3948: p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type) IS
3949:
3950: E_Resource_Busy EXCEPTION;
3951: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
3952: CURSOR lock_csr (p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type) IS
3953: SELECT *
3954: FROM OKL_TXL_ASSETS_TL
3955: WHERE ID = p_okl_txl_assets_tl_rec.id
3956: FOR UPDATE NOWAIT;

Line 3954: FROM OKL_TXL_ASSETS_TL

3950: E_Resource_Busy EXCEPTION;
3951: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
3952: CURSOR lock_csr (p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type) IS
3953: SELECT *
3954: FROM OKL_TXL_ASSETS_TL
3955: WHERE ID = p_okl_txl_assets_tl_rec.id
3956: FOR UPDATE NOWAIT;
3957:
3958: l_api_version CONSTANT NUMBER := 1;

Line 3955: WHERE ID = p_okl_txl_assets_tl_rec.id

3951: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
3952: CURSOR lock_csr (p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type) IS
3953: SELECT *
3954: FROM OKL_TXL_ASSETS_TL
3955: WHERE ID = p_okl_txl_assets_tl_rec.id
3956: FOR UPDATE NOWAIT;
3957:
3958: l_api_version CONSTANT NUMBER := 1;
3959: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';

Line 3975: OPEN lock_csr(p_okl_txl_assets_tl_rec);

3971: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3972: RAISE OKC_API.G_EXCEPTION_ERROR;
3973: END IF;
3974: BEGIN
3975: OPEN lock_csr(p_okl_txl_assets_tl_rec);
3976: FETCH lock_csr INTO l_lock_var;
3977: l_row_notfound := lock_csr%NOTFOUND;
3978: CLOSE lock_csr;
3979: EXCEPTION

Line 4040: l_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;

4036: l_api_version CONSTANT NUMBER := 1;
4037: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
4038: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4039: l_tal_rec tal_rec_type;
4040: l_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;
4041: BEGIN
4042: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
4043: G_PKG_NAME,
4044: p_init_msg_list,

Line 4058: migrate(p_talv_rec, l_okl_txl_assets_tl_rec);

4054: --------------------------------------
4055: -- Move VIEW record to "Child" records
4056: --------------------------------------
4057: migrate(p_talv_rec, l_tal_rec);
4058: migrate(p_talv_rec, l_okl_txl_assets_tl_rec);
4059: --------------------------------------------
4060: -- Call the LOCK_ROW for each child record
4061: --------------------------------------------
4062: lock_row(

Line 4079: l_okl_txl_assets_tl_rec

4075: p_init_msg_list,
4076: x_return_status,
4077: x_msg_count,
4078: x_msg_data,
4079: l_okl_txl_assets_tl_rec
4080: );
4081: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4082: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4083: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 4711: -- update_row for:OKL_TXL_ASSETS_TL --

4707: '_PVT'
4708: );
4709: END update_row;
4710: --------------------------------------
4711: -- update_row for:OKL_TXL_ASSETS_TL --
4712: --------------------------------------
4713: PROCEDURE update_row(
4714: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
4715: x_return_status OUT NOCOPY VARCHAR2,

Line 4718: p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type,

4714: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
4715: x_return_status OUT NOCOPY VARCHAR2,
4716: x_msg_count OUT NOCOPY NUMBER,
4717: x_msg_data OUT NOCOPY VARCHAR2,
4718: p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type,
4719: x_okl_txl_assets_tl_rec OUT NOCOPY okl_txl_assets_tl_rec_type) IS
4720:
4721: l_api_version CONSTANT NUMBER := 1;
4722: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';

Line 4719: x_okl_txl_assets_tl_rec OUT NOCOPY okl_txl_assets_tl_rec_type) IS

4715: x_return_status OUT NOCOPY VARCHAR2,
4716: x_msg_count OUT NOCOPY NUMBER,
4717: x_msg_data OUT NOCOPY VARCHAR2,
4718: p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type,
4719: x_okl_txl_assets_tl_rec OUT NOCOPY okl_txl_assets_tl_rec_type) IS
4720:
4721: l_api_version CONSTANT NUMBER := 1;
4722: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
4723: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 4724: l_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type := p_okl_txl_assets_tl_rec;

4720:
4721: l_api_version CONSTANT NUMBER := 1;
4722: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
4723: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4724: l_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type := p_okl_txl_assets_tl_rec;
4725: l_def_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;
4726: l_row_notfound BOOLEAN := TRUE;
4727: ----------------------------------
4728: -- FUNCTION populate_new_record --

Line 4725: l_def_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;

4721: l_api_version CONSTANT NUMBER := 1;
4722: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
4723: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4724: l_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type := p_okl_txl_assets_tl_rec;
4725: l_def_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;
4726: l_row_notfound BOOLEAN := TRUE;
4727: ----------------------------------
4728: -- FUNCTION populate_new_record --
4729: ----------------------------------

Line 4731: p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type,

4727: ----------------------------------
4728: -- FUNCTION populate_new_record --
4729: ----------------------------------
4730: FUNCTION populate_new_record (
4731: p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type,
4732: x_okl_txl_assets_tl_rec OUT NOCOPY okl_txl_assets_tl_rec_type
4733: ) RETURN VARCHAR2 IS
4734: l_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;
4735: l_row_notfound BOOLEAN := TRUE;

Line 4732: x_okl_txl_assets_tl_rec OUT NOCOPY okl_txl_assets_tl_rec_type

4728: -- FUNCTION populate_new_record --
4729: ----------------------------------
4730: FUNCTION populate_new_record (
4731: p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type,
4732: x_okl_txl_assets_tl_rec OUT NOCOPY okl_txl_assets_tl_rec_type
4733: ) RETURN VARCHAR2 IS
4734: l_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;
4735: l_row_notfound BOOLEAN := TRUE;
4736: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 4734: l_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;

4730: FUNCTION populate_new_record (
4731: p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type,
4732: x_okl_txl_assets_tl_rec OUT NOCOPY okl_txl_assets_tl_rec_type
4733: ) RETURN VARCHAR2 IS
4734: l_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;
4735: l_row_notfound BOOLEAN := TRUE;
4736: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4737: BEGIN
4738: x_okl_txl_assets_tl_rec := p_okl_txl_assets_tl_rec;

Line 4738: x_okl_txl_assets_tl_rec := p_okl_txl_assets_tl_rec;

4734: l_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;
4735: l_row_notfound BOOLEAN := TRUE;
4736: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4737: BEGIN
4738: x_okl_txl_assets_tl_rec := p_okl_txl_assets_tl_rec;
4739: -- Get current database values
4740: l_okl_txl_assets_tl_rec := get_rec(p_okl_txl_assets_tl_rec, l_row_notfound);
4741: IF (l_row_notfound) THEN
4742: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

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

4736: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4737: BEGIN
4738: x_okl_txl_assets_tl_rec := p_okl_txl_assets_tl_rec;
4739: -- Get current database values
4740: l_okl_txl_assets_tl_rec := get_rec(p_okl_txl_assets_tl_rec, l_row_notfound);
4741: IF (l_row_notfound) THEN
4742: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
4743: END IF;
4744: IF (x_okl_txl_assets_tl_rec.id = OKC_API.G_MISS_NUM)

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

4740: l_okl_txl_assets_tl_rec := get_rec(p_okl_txl_assets_tl_rec, l_row_notfound);
4741: IF (l_row_notfound) THEN
4742: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
4743: END IF;
4744: IF (x_okl_txl_assets_tl_rec.id = OKC_API.G_MISS_NUM)
4745: THEN
4746: x_okl_txl_assets_tl_rec.id := l_okl_txl_assets_tl_rec.id;
4747: END IF;
4748: IF (x_okl_txl_assets_tl_rec.language = OKC_API.G_MISS_CHAR)

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

4742: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
4743: END IF;
4744: IF (x_okl_txl_assets_tl_rec.id = OKC_API.G_MISS_NUM)
4745: THEN
4746: x_okl_txl_assets_tl_rec.id := l_okl_txl_assets_tl_rec.id;
4747: END IF;
4748: IF (x_okl_txl_assets_tl_rec.language = OKC_API.G_MISS_CHAR)
4749: THEN
4750: x_okl_txl_assets_tl_rec.language := l_okl_txl_assets_tl_rec.language;

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

4744: IF (x_okl_txl_assets_tl_rec.id = OKC_API.G_MISS_NUM)
4745: THEN
4746: x_okl_txl_assets_tl_rec.id := l_okl_txl_assets_tl_rec.id;
4747: END IF;
4748: IF (x_okl_txl_assets_tl_rec.language = OKC_API.G_MISS_CHAR)
4749: THEN
4750: x_okl_txl_assets_tl_rec.language := l_okl_txl_assets_tl_rec.language;
4751: END IF;
4752: IF (x_okl_txl_assets_tl_rec.source_lang = OKC_API.G_MISS_CHAR)

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

4746: x_okl_txl_assets_tl_rec.id := l_okl_txl_assets_tl_rec.id;
4747: END IF;
4748: IF (x_okl_txl_assets_tl_rec.language = OKC_API.G_MISS_CHAR)
4749: THEN
4750: x_okl_txl_assets_tl_rec.language := l_okl_txl_assets_tl_rec.language;
4751: END IF;
4752: IF (x_okl_txl_assets_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
4753: THEN
4754: x_okl_txl_assets_tl_rec.source_lang := l_okl_txl_assets_tl_rec.source_lang;

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

4748: IF (x_okl_txl_assets_tl_rec.language = OKC_API.G_MISS_CHAR)
4749: THEN
4750: x_okl_txl_assets_tl_rec.language := l_okl_txl_assets_tl_rec.language;
4751: END IF;
4752: IF (x_okl_txl_assets_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
4753: THEN
4754: x_okl_txl_assets_tl_rec.source_lang := l_okl_txl_assets_tl_rec.source_lang;
4755: END IF;
4756: IF (x_okl_txl_assets_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)

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

4750: x_okl_txl_assets_tl_rec.language := l_okl_txl_assets_tl_rec.language;
4751: END IF;
4752: IF (x_okl_txl_assets_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
4753: THEN
4754: x_okl_txl_assets_tl_rec.source_lang := l_okl_txl_assets_tl_rec.source_lang;
4755: END IF;
4756: IF (x_okl_txl_assets_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
4757: THEN
4758: x_okl_txl_assets_tl_rec.sfwt_flag := l_okl_txl_assets_tl_rec.sfwt_flag;

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

4752: IF (x_okl_txl_assets_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
4753: THEN
4754: x_okl_txl_assets_tl_rec.source_lang := l_okl_txl_assets_tl_rec.source_lang;
4755: END IF;
4756: IF (x_okl_txl_assets_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
4757: THEN
4758: x_okl_txl_assets_tl_rec.sfwt_flag := l_okl_txl_assets_tl_rec.sfwt_flag;
4759: END IF;
4760: IF (x_okl_txl_assets_tl_rec.description = OKC_API.G_MISS_CHAR)

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

4754: x_okl_txl_assets_tl_rec.source_lang := l_okl_txl_assets_tl_rec.source_lang;
4755: END IF;
4756: IF (x_okl_txl_assets_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
4757: THEN
4758: x_okl_txl_assets_tl_rec.sfwt_flag := l_okl_txl_assets_tl_rec.sfwt_flag;
4759: END IF;
4760: IF (x_okl_txl_assets_tl_rec.description = OKC_API.G_MISS_CHAR)
4761: THEN
4762: x_okl_txl_assets_tl_rec.description := l_okl_txl_assets_tl_rec.description;

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

4756: IF (x_okl_txl_assets_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
4757: THEN
4758: x_okl_txl_assets_tl_rec.sfwt_flag := l_okl_txl_assets_tl_rec.sfwt_flag;
4759: END IF;
4760: IF (x_okl_txl_assets_tl_rec.description = OKC_API.G_MISS_CHAR)
4761: THEN
4762: x_okl_txl_assets_tl_rec.description := l_okl_txl_assets_tl_rec.description;
4763: END IF;
4764: IF (x_okl_txl_assets_tl_rec.created_by = OKC_API.G_MISS_NUM)

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

4758: x_okl_txl_assets_tl_rec.sfwt_flag := l_okl_txl_assets_tl_rec.sfwt_flag;
4759: END IF;
4760: IF (x_okl_txl_assets_tl_rec.description = OKC_API.G_MISS_CHAR)
4761: THEN
4762: x_okl_txl_assets_tl_rec.description := l_okl_txl_assets_tl_rec.description;
4763: END IF;
4764: IF (x_okl_txl_assets_tl_rec.created_by = OKC_API.G_MISS_NUM)
4765: THEN
4766: x_okl_txl_assets_tl_rec.created_by := l_okl_txl_assets_tl_rec.created_by;

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

4760: IF (x_okl_txl_assets_tl_rec.description = OKC_API.G_MISS_CHAR)
4761: THEN
4762: x_okl_txl_assets_tl_rec.description := l_okl_txl_assets_tl_rec.description;
4763: END IF;
4764: IF (x_okl_txl_assets_tl_rec.created_by = OKC_API.G_MISS_NUM)
4765: THEN
4766: x_okl_txl_assets_tl_rec.created_by := l_okl_txl_assets_tl_rec.created_by;
4767: END IF;
4768: IF (x_okl_txl_assets_tl_rec.creation_date = OKC_API.G_MISS_DATE)

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

4762: x_okl_txl_assets_tl_rec.description := l_okl_txl_assets_tl_rec.description;
4763: END IF;
4764: IF (x_okl_txl_assets_tl_rec.created_by = OKC_API.G_MISS_NUM)
4765: THEN
4766: x_okl_txl_assets_tl_rec.created_by := l_okl_txl_assets_tl_rec.created_by;
4767: END IF;
4768: IF (x_okl_txl_assets_tl_rec.creation_date = OKC_API.G_MISS_DATE)
4769: THEN
4770: x_okl_txl_assets_tl_rec.creation_date := l_okl_txl_assets_tl_rec.creation_date;

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

4764: IF (x_okl_txl_assets_tl_rec.created_by = OKC_API.G_MISS_NUM)
4765: THEN
4766: x_okl_txl_assets_tl_rec.created_by := l_okl_txl_assets_tl_rec.created_by;
4767: END IF;
4768: IF (x_okl_txl_assets_tl_rec.creation_date = OKC_API.G_MISS_DATE)
4769: THEN
4770: x_okl_txl_assets_tl_rec.creation_date := l_okl_txl_assets_tl_rec.creation_date;
4771: END IF;
4772: IF (x_okl_txl_assets_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)

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

4766: x_okl_txl_assets_tl_rec.created_by := l_okl_txl_assets_tl_rec.created_by;
4767: END IF;
4768: IF (x_okl_txl_assets_tl_rec.creation_date = OKC_API.G_MISS_DATE)
4769: THEN
4770: x_okl_txl_assets_tl_rec.creation_date := l_okl_txl_assets_tl_rec.creation_date;
4771: END IF;
4772: IF (x_okl_txl_assets_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
4773: THEN
4774: x_okl_txl_assets_tl_rec.last_updated_by := l_okl_txl_assets_tl_rec.last_updated_by;

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

4768: IF (x_okl_txl_assets_tl_rec.creation_date = OKC_API.G_MISS_DATE)
4769: THEN
4770: x_okl_txl_assets_tl_rec.creation_date := l_okl_txl_assets_tl_rec.creation_date;
4771: END IF;
4772: IF (x_okl_txl_assets_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
4773: THEN
4774: x_okl_txl_assets_tl_rec.last_updated_by := l_okl_txl_assets_tl_rec.last_updated_by;
4775: END IF;
4776: IF (x_okl_txl_assets_tl_rec.last_update_date = OKC_API.G_MISS_DATE)

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

4770: x_okl_txl_assets_tl_rec.creation_date := l_okl_txl_assets_tl_rec.creation_date;
4771: END IF;
4772: IF (x_okl_txl_assets_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
4773: THEN
4774: x_okl_txl_assets_tl_rec.last_updated_by := l_okl_txl_assets_tl_rec.last_updated_by;
4775: END IF;
4776: IF (x_okl_txl_assets_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
4777: THEN
4778: x_okl_txl_assets_tl_rec.last_update_date := l_okl_txl_assets_tl_rec.last_update_date;

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

4772: IF (x_okl_txl_assets_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
4773: THEN
4774: x_okl_txl_assets_tl_rec.last_updated_by := l_okl_txl_assets_tl_rec.last_updated_by;
4775: END IF;
4776: IF (x_okl_txl_assets_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
4777: THEN
4778: x_okl_txl_assets_tl_rec.last_update_date := l_okl_txl_assets_tl_rec.last_update_date;
4779: END IF;
4780: IF (x_okl_txl_assets_tl_rec.last_update_login = OKC_API.G_MISS_NUM)

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

4774: x_okl_txl_assets_tl_rec.last_updated_by := l_okl_txl_assets_tl_rec.last_updated_by;
4775: END IF;
4776: IF (x_okl_txl_assets_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
4777: THEN
4778: x_okl_txl_assets_tl_rec.last_update_date := l_okl_txl_assets_tl_rec.last_update_date;
4779: END IF;
4780: IF (x_okl_txl_assets_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
4781: THEN
4782: x_okl_txl_assets_tl_rec.last_update_login := l_okl_txl_assets_tl_rec.last_update_login;

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

4776: IF (x_okl_txl_assets_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
4777: THEN
4778: x_okl_txl_assets_tl_rec.last_update_date := l_okl_txl_assets_tl_rec.last_update_date;
4779: END IF;
4780: IF (x_okl_txl_assets_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
4781: THEN
4782: x_okl_txl_assets_tl_rec.last_update_login := l_okl_txl_assets_tl_rec.last_update_login;
4783: END IF;
4784: RETURN(l_return_status);

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

4778: x_okl_txl_assets_tl_rec.last_update_date := l_okl_txl_assets_tl_rec.last_update_date;
4779: END IF;
4780: IF (x_okl_txl_assets_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
4781: THEN
4782: x_okl_txl_assets_tl_rec.last_update_login := l_okl_txl_assets_tl_rec.last_update_login;
4783: END IF;
4784: RETURN(l_return_status);
4785: END populate_new_record;
4786: ------------------------------------------

Line 4787: -- Set_Attributes for:OKL_TXL_ASSETS_TL --

4783: END IF;
4784: RETURN(l_return_status);
4785: END populate_new_record;
4786: ------------------------------------------
4787: -- Set_Attributes for:OKL_TXL_ASSETS_TL --
4788: ------------------------------------------
4789: FUNCTION Set_Attributes (
4790: p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type,
4791: x_okl_txl_assets_tl_rec OUT NOCOPY okl_txl_assets_tl_rec_type

Line 4790: p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type,

4786: ------------------------------------------
4787: -- Set_Attributes for:OKL_TXL_ASSETS_TL --
4788: ------------------------------------------
4789: FUNCTION Set_Attributes (
4790: p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type,
4791: x_okl_txl_assets_tl_rec OUT NOCOPY okl_txl_assets_tl_rec_type
4792: ) RETURN VARCHAR2 IS
4793: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4794: BEGIN

Line 4791: x_okl_txl_assets_tl_rec OUT NOCOPY okl_txl_assets_tl_rec_type

4787: -- Set_Attributes for:OKL_TXL_ASSETS_TL --
4788: ------------------------------------------
4789: FUNCTION Set_Attributes (
4790: p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type,
4791: x_okl_txl_assets_tl_rec OUT NOCOPY okl_txl_assets_tl_rec_type
4792: ) RETURN VARCHAR2 IS
4793: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4794: BEGIN
4795: x_okl_txl_assets_tl_rec := p_okl_txl_assets_tl_rec;

Line 4795: x_okl_txl_assets_tl_rec := p_okl_txl_assets_tl_rec;

4791: x_okl_txl_assets_tl_rec OUT NOCOPY okl_txl_assets_tl_rec_type
4792: ) RETURN VARCHAR2 IS
4793: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4794: BEGIN
4795: x_okl_txl_assets_tl_rec := p_okl_txl_assets_tl_rec;
4796: x_okl_txl_assets_tl_rec.LANGUAGE := USERENV('LANG');
4797: x_okl_txl_assets_tl_rec.SOURCE_LANG := USERENV('LANG');
4798: RETURN(l_return_status);
4799: END Set_Attributes;

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

4792: ) RETURN VARCHAR2 IS
4793: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4794: BEGIN
4795: x_okl_txl_assets_tl_rec := p_okl_txl_assets_tl_rec;
4796: x_okl_txl_assets_tl_rec.LANGUAGE := USERENV('LANG');
4797: x_okl_txl_assets_tl_rec.SOURCE_LANG := USERENV('LANG');
4798: RETURN(l_return_status);
4799: END Set_Attributes;
4800: BEGIN

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

4793: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4794: BEGIN
4795: x_okl_txl_assets_tl_rec := p_okl_txl_assets_tl_rec;
4796: x_okl_txl_assets_tl_rec.LANGUAGE := USERENV('LANG');
4797: x_okl_txl_assets_tl_rec.SOURCE_LANG := USERENV('LANG');
4798: RETURN(l_return_status);
4799: END Set_Attributes;
4800: BEGIN
4801: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 4812: p_okl_txl_assets_tl_rec, -- IN

4808: RAISE OKC_API.G_EXCEPTION_ERROR;
4809: END IF;
4810: --- Setting item attributes
4811: l_return_status := Set_Attributes(
4812: p_okl_txl_assets_tl_rec, -- IN
4813: l_okl_txl_assets_tl_rec); -- OUT
4814: --- If any errors happen abort API
4815: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4816: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 4813: l_okl_txl_assets_tl_rec); -- OUT

4809: END IF;
4810: --- Setting item attributes
4811: l_return_status := Set_Attributes(
4812: p_okl_txl_assets_tl_rec, -- IN
4813: l_okl_txl_assets_tl_rec); -- OUT
4814: --- If any errors happen abort API
4815: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4816: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4817: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

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

4816: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4817: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4818: RAISE OKC_API.G_EXCEPTION_ERROR;
4819: END IF;
4820: l_return_status := populate_new_record(l_okl_txl_assets_tl_rec, l_def_okl_txl_assets_tl_rec);
4821: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4822: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4823: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4824: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 4826: UPDATE OKL_TXL_ASSETS_TL

4822: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4823: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4824: RAISE OKC_API.G_EXCEPTION_ERROR;
4825: END IF;
4826: UPDATE OKL_TXL_ASSETS_TL
4827: SET DESCRIPTION = l_def_okl_txl_assets_tl_rec.description,
4828: --Bug# 3641933 :
4829: SOURCE_LANG = l_def_okl_txl_assets_tl_rec.source_lang,
4830: CREATED_BY = l_def_okl_txl_assets_tl_rec.created_by,

Line 4827: SET DESCRIPTION = l_def_okl_txl_assets_tl_rec.description,

4823: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4824: RAISE OKC_API.G_EXCEPTION_ERROR;
4825: END IF;
4826: UPDATE OKL_TXL_ASSETS_TL
4827: SET DESCRIPTION = l_def_okl_txl_assets_tl_rec.description,
4828: --Bug# 3641933 :
4829: SOURCE_LANG = l_def_okl_txl_assets_tl_rec.source_lang,
4830: CREATED_BY = l_def_okl_txl_assets_tl_rec.created_by,
4831: CREATION_DATE = l_def_okl_txl_assets_tl_rec.creation_date,

Line 4829: SOURCE_LANG = l_def_okl_txl_assets_tl_rec.source_lang,

4825: END IF;
4826: UPDATE OKL_TXL_ASSETS_TL
4827: SET DESCRIPTION = l_def_okl_txl_assets_tl_rec.description,
4828: --Bug# 3641933 :
4829: SOURCE_LANG = l_def_okl_txl_assets_tl_rec.source_lang,
4830: CREATED_BY = l_def_okl_txl_assets_tl_rec.created_by,
4831: CREATION_DATE = l_def_okl_txl_assets_tl_rec.creation_date,
4832: LAST_UPDATED_BY = l_def_okl_txl_assets_tl_rec.last_updated_by,
4833: LAST_UPDATE_DATE = l_def_okl_txl_assets_tl_rec.last_update_date,

Line 4830: CREATED_BY = l_def_okl_txl_assets_tl_rec.created_by,

4826: UPDATE OKL_TXL_ASSETS_TL
4827: SET DESCRIPTION = l_def_okl_txl_assets_tl_rec.description,
4828: --Bug# 3641933 :
4829: SOURCE_LANG = l_def_okl_txl_assets_tl_rec.source_lang,
4830: CREATED_BY = l_def_okl_txl_assets_tl_rec.created_by,
4831: CREATION_DATE = l_def_okl_txl_assets_tl_rec.creation_date,
4832: LAST_UPDATED_BY = l_def_okl_txl_assets_tl_rec.last_updated_by,
4833: LAST_UPDATE_DATE = l_def_okl_txl_assets_tl_rec.last_update_date,
4834: LAST_UPDATE_LOGIN = l_def_okl_txl_assets_tl_rec.last_update_login

Line 4831: CREATION_DATE = l_def_okl_txl_assets_tl_rec.creation_date,

4827: SET DESCRIPTION = l_def_okl_txl_assets_tl_rec.description,
4828: --Bug# 3641933 :
4829: SOURCE_LANG = l_def_okl_txl_assets_tl_rec.source_lang,
4830: CREATED_BY = l_def_okl_txl_assets_tl_rec.created_by,
4831: CREATION_DATE = l_def_okl_txl_assets_tl_rec.creation_date,
4832: LAST_UPDATED_BY = l_def_okl_txl_assets_tl_rec.last_updated_by,
4833: LAST_UPDATE_DATE = l_def_okl_txl_assets_tl_rec.last_update_date,
4834: LAST_UPDATE_LOGIN = l_def_okl_txl_assets_tl_rec.last_update_login
4835: WHERE ID = l_def_okl_txl_assets_tl_rec.id

Line 4832: LAST_UPDATED_BY = l_def_okl_txl_assets_tl_rec.last_updated_by,

4828: --Bug# 3641933 :
4829: SOURCE_LANG = l_def_okl_txl_assets_tl_rec.source_lang,
4830: CREATED_BY = l_def_okl_txl_assets_tl_rec.created_by,
4831: CREATION_DATE = l_def_okl_txl_assets_tl_rec.creation_date,
4832: LAST_UPDATED_BY = l_def_okl_txl_assets_tl_rec.last_updated_by,
4833: LAST_UPDATE_DATE = l_def_okl_txl_assets_tl_rec.last_update_date,
4834: LAST_UPDATE_LOGIN = l_def_okl_txl_assets_tl_rec.last_update_login
4835: WHERE ID = l_def_okl_txl_assets_tl_rec.id
4836: --Bug# 3641933 :

Line 4833: LAST_UPDATE_DATE = l_def_okl_txl_assets_tl_rec.last_update_date,

4829: SOURCE_LANG = l_def_okl_txl_assets_tl_rec.source_lang,
4830: CREATED_BY = l_def_okl_txl_assets_tl_rec.created_by,
4831: CREATION_DATE = l_def_okl_txl_assets_tl_rec.creation_date,
4832: LAST_UPDATED_BY = l_def_okl_txl_assets_tl_rec.last_updated_by,
4833: LAST_UPDATE_DATE = l_def_okl_txl_assets_tl_rec.last_update_date,
4834: LAST_UPDATE_LOGIN = l_def_okl_txl_assets_tl_rec.last_update_login
4835: WHERE ID = l_def_okl_txl_assets_tl_rec.id
4836: --Bug# 3641933 :
4837: AND USERENV('LANG') in (SOURCE_LANG,LANGUAGE);

Line 4834: LAST_UPDATE_LOGIN = l_def_okl_txl_assets_tl_rec.last_update_login

4830: CREATED_BY = l_def_okl_txl_assets_tl_rec.created_by,
4831: CREATION_DATE = l_def_okl_txl_assets_tl_rec.creation_date,
4832: LAST_UPDATED_BY = l_def_okl_txl_assets_tl_rec.last_updated_by,
4833: LAST_UPDATE_DATE = l_def_okl_txl_assets_tl_rec.last_update_date,
4834: LAST_UPDATE_LOGIN = l_def_okl_txl_assets_tl_rec.last_update_login
4835: WHERE ID = l_def_okl_txl_assets_tl_rec.id
4836: --Bug# 3641933 :
4837: AND USERENV('LANG') in (SOURCE_LANG,LANGUAGE);
4838: --AND SOURCE_LANG = USERENV('LANG');

Line 4835: WHERE ID = l_def_okl_txl_assets_tl_rec.id

4831: CREATION_DATE = l_def_okl_txl_assets_tl_rec.creation_date,
4832: LAST_UPDATED_BY = l_def_okl_txl_assets_tl_rec.last_updated_by,
4833: LAST_UPDATE_DATE = l_def_okl_txl_assets_tl_rec.last_update_date,
4834: LAST_UPDATE_LOGIN = l_def_okl_txl_assets_tl_rec.last_update_login
4835: WHERE ID = l_def_okl_txl_assets_tl_rec.id
4836: --Bug# 3641933 :
4837: AND USERENV('LANG') in (SOURCE_LANG,LANGUAGE);
4838: --AND SOURCE_LANG = USERENV('LANG');
4839:

Line 4840: UPDATE OKL_TXL_ASSETS_TL

4836: --Bug# 3641933 :
4837: AND USERENV('LANG') in (SOURCE_LANG,LANGUAGE);
4838: --AND SOURCE_LANG = USERENV('LANG');
4839:
4840: UPDATE OKL_TXL_ASSETS_TL
4841: SET SFWT_FLAG = 'Y'
4842: WHERE ID = l_def_okl_txl_assets_tl_rec.id
4843: AND SOURCE_LANG <> USERENV('LANG');
4844:

Line 4842: WHERE ID = l_def_okl_txl_assets_tl_rec.id

4838: --AND SOURCE_LANG = USERENV('LANG');
4839:
4840: UPDATE OKL_TXL_ASSETS_TL
4841: SET SFWT_FLAG = 'Y'
4842: WHERE ID = l_def_okl_txl_assets_tl_rec.id
4843: AND SOURCE_LANG <> USERENV('LANG');
4844:
4845: x_okl_txl_assets_tl_rec := l_def_okl_txl_assets_tl_rec;
4846: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 4845: x_okl_txl_assets_tl_rec := l_def_okl_txl_assets_tl_rec;

4841: SET SFWT_FLAG = 'Y'
4842: WHERE ID = l_def_okl_txl_assets_tl_rec.id
4843: AND SOURCE_LANG <> USERENV('LANG');
4844:
4845: x_okl_txl_assets_tl_rec := l_def_okl_txl_assets_tl_rec;
4846: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
4847: EXCEPTION
4848: WHEN OKC_API.G_EXCEPTION_ERROR THEN
4849: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 4896: l_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;

4892: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
4893: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4894: l_talv_rec talv_rec_type := p_talv_rec;
4895: l_def_talv_rec talv_rec_type;
4896: l_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;
4897: lx_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;
4898: l_tal_rec tal_rec_type;
4899: lx_tal_rec tal_rec_type;
4900: lx_temp_talv_rec talv_rec_type;

Line 4897: lx_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;

4893: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4894: l_talv_rec talv_rec_type := p_talv_rec;
4895: l_def_talv_rec talv_rec_type;
4896: l_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;
4897: lx_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;
4898: l_tal_rec tal_rec_type;
4899: lx_tal_rec tal_rec_type;
4900: lx_temp_talv_rec talv_rec_type;
4901: -------------------------------

Line 5377: migrate(l_def_talv_rec, l_okl_txl_assets_tl_rec);

5373:
5374: --------------------------------------
5375: -- Move VIEW record to "Child" records
5376: --------------------------------------
5377: migrate(l_def_talv_rec, l_okl_txl_assets_tl_rec);
5378: migrate(l_def_talv_rec, l_tal_rec);
5379: --------------------------------------------
5380: -- Call the UPDATE_ROW for each child record
5381: --------------------------------------------

Line 5387: l_okl_txl_assets_tl_rec,

5383: p_init_msg_list,
5384: x_return_status,
5385: x_msg_count,
5386: x_msg_data,
5387: l_okl_txl_assets_tl_rec,
5388: lx_okl_txl_assets_tl_rec
5389: );
5390: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5391: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 5388: lx_okl_txl_assets_tl_rec

5384: x_return_status,
5385: x_msg_count,
5386: x_msg_data,
5387: l_okl_txl_assets_tl_rec,
5388: lx_okl_txl_assets_tl_rec
5389: );
5390: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5391: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5392: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 5395: migrate(lx_okl_txl_assets_tl_rec, l_def_talv_rec);

5391: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5392: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
5393: RAISE OKC_API.G_EXCEPTION_ERROR;
5394: END IF;
5395: migrate(lx_okl_txl_assets_tl_rec, l_def_talv_rec);
5396: update_row(
5397: p_init_msg_list,
5398: x_return_status,
5399: x_msg_count,

Line 5576: -- delete_row for:OKL_TXL_ASSETS_TL --

5572: '_PVT'
5573: );
5574: END delete_row;
5575: --------------------------------------
5576: -- delete_row for:OKL_TXL_ASSETS_TL --
5577: --------------------------------------
5578: PROCEDURE delete_row(
5579: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
5580: x_return_status OUT NOCOPY VARCHAR2,

Line 5583: p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type) IS

5579: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
5580: x_return_status OUT NOCOPY VARCHAR2,
5581: x_msg_count OUT NOCOPY NUMBER,
5582: x_msg_data OUT NOCOPY VARCHAR2,
5583: p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type) IS
5584:
5585: l_api_version CONSTANT NUMBER := 1;
5586: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
5587: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 5588: l_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type:= p_okl_txl_assets_tl_rec;

5584:
5585: l_api_version CONSTANT NUMBER := 1;
5586: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
5587: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5588: l_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type:= p_okl_txl_assets_tl_rec;
5589: l_row_notfound BOOLEAN := TRUE;
5590: ------------------------------------------
5591: -- Set_Attributes for:OKL_TXL_ASSETS_TL --
5592: ------------------------------------------

Line 5591: -- Set_Attributes for:OKL_TXL_ASSETS_TL --

5587: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5588: l_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type:= p_okl_txl_assets_tl_rec;
5589: l_row_notfound BOOLEAN := TRUE;
5590: ------------------------------------------
5591: -- Set_Attributes for:OKL_TXL_ASSETS_TL --
5592: ------------------------------------------
5593: FUNCTION Set_Attributes (
5594: p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type,
5595: x_okl_txl_assets_tl_rec OUT NOCOPY okl_txl_assets_tl_rec_type

Line 5594: p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type,

5590: ------------------------------------------
5591: -- Set_Attributes for:OKL_TXL_ASSETS_TL --
5592: ------------------------------------------
5593: FUNCTION Set_Attributes (
5594: p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type,
5595: x_okl_txl_assets_tl_rec OUT NOCOPY okl_txl_assets_tl_rec_type
5596: ) RETURN VARCHAR2 IS
5597: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5598: BEGIN

Line 5595: x_okl_txl_assets_tl_rec OUT NOCOPY okl_txl_assets_tl_rec_type

5591: -- Set_Attributes for:OKL_TXL_ASSETS_TL --
5592: ------------------------------------------
5593: FUNCTION Set_Attributes (
5594: p_okl_txl_assets_tl_rec IN okl_txl_assets_tl_rec_type,
5595: x_okl_txl_assets_tl_rec OUT NOCOPY okl_txl_assets_tl_rec_type
5596: ) RETURN VARCHAR2 IS
5597: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5598: BEGIN
5599: x_okl_txl_assets_tl_rec := p_okl_txl_assets_tl_rec;

Line 5599: x_okl_txl_assets_tl_rec := p_okl_txl_assets_tl_rec;

5595: x_okl_txl_assets_tl_rec OUT NOCOPY okl_txl_assets_tl_rec_type
5596: ) RETURN VARCHAR2 IS
5597: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5598: BEGIN
5599: x_okl_txl_assets_tl_rec := p_okl_txl_assets_tl_rec;
5600: x_okl_txl_assets_tl_rec.LANGUAGE := USERENV('LANG');
5601: RETURN(l_return_status);
5602: END Set_Attributes;
5603: BEGIN

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

5596: ) RETURN VARCHAR2 IS
5597: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5598: BEGIN
5599: x_okl_txl_assets_tl_rec := p_okl_txl_assets_tl_rec;
5600: x_okl_txl_assets_tl_rec.LANGUAGE := USERENV('LANG');
5601: RETURN(l_return_status);
5602: END Set_Attributes;
5603: BEGIN
5604: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 5615: p_okl_txl_assets_tl_rec, -- IN

5611: RAISE OKC_API.G_EXCEPTION_ERROR;
5612: END IF;
5613: --- Setting item attributes
5614: l_return_status := Set_Attributes(
5615: p_okl_txl_assets_tl_rec, -- IN
5616: l_okl_txl_assets_tl_rec); -- OUT
5617: --- If any errors happen abort API
5618: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5619: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 5616: l_okl_txl_assets_tl_rec); -- OUT

5612: END IF;
5613: --- Setting item attributes
5614: l_return_status := Set_Attributes(
5615: p_okl_txl_assets_tl_rec, -- IN
5616: l_okl_txl_assets_tl_rec); -- OUT
5617: --- If any errors happen abort API
5618: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5619: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5620: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 5623: DELETE FROM OKL_TXL_ASSETS_TL

5619: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5620: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5621: RAISE OKC_API.G_EXCEPTION_ERROR;
5622: END IF;
5623: DELETE FROM OKL_TXL_ASSETS_TL
5624: WHERE ID = l_okl_txl_assets_tl_rec.id;
5625:
5626: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
5627: EXCEPTION

Line 5624: WHERE ID = l_okl_txl_assets_tl_rec.id;

5620: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5621: RAISE OKC_API.G_EXCEPTION_ERROR;
5622: END IF;
5623: DELETE FROM OKL_TXL_ASSETS_TL
5624: WHERE ID = l_okl_txl_assets_tl_rec.id;
5625:
5626: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
5627: EXCEPTION
5628: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 5674: l_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;

5670: l_api_version CONSTANT NUMBER := 1;
5671: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
5672: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5673: l_talv_rec talv_rec_type := p_talv_rec;
5674: l_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;
5675: l_tal_rec tal_rec_type;
5676: BEGIN
5677: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
5678: G_PKG_NAME,

Line 5692: migrate(l_talv_rec, l_okl_txl_assets_tl_rec);

5688: END IF;
5689: --------------------------------------
5690: -- Move VIEW record to "Child" records
5691: --------------------------------------
5692: migrate(l_talv_rec, l_okl_txl_assets_tl_rec);
5693: migrate(l_talv_rec, l_tal_rec);
5694: --------------------------------------------
5695: -- Call the DELETE_ROW for each child record
5696: --------------------------------------------

Line 5702: l_okl_txl_assets_tl_rec

5698: p_init_msg_list,
5699: x_return_status,
5700: x_msg_count,
5701: x_msg_data,
5702: l_okl_txl_assets_tl_rec
5703: );
5704: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5705: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5706: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN