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_ASD_PVT dependencies on OKL_TXD_ASSETS_TL

Line 765: DELETE FROM OKL_TXD_ASSETS_TL T

761: -- PROCEDURE add_language
762: ---------------------------------------------------------------------------
763: PROCEDURE add_language IS
764: BEGIN
765: DELETE FROM OKL_TXD_ASSETS_TL T
766: WHERE NOT EXISTS (
767: SELECT NULL
768: FROM OKL_TXD_ASSETS_B B --fixed bug 3321017 by kmotepal
769: WHERE B.ID = T.ID

Line 772: UPDATE OKL_TXD_ASSETS_TL T SET (

768: FROM OKL_TXD_ASSETS_B B --fixed bug 3321017 by kmotepal
769: WHERE B.ID = T.ID
770: );
771:
772: UPDATE OKL_TXD_ASSETS_TL T SET (
773: DESCRIPTION) = (SELECT
774: B.DESCRIPTION
775: FROM OKL_TXD_ASSETS_TL B
776: WHERE B.ID = T.ID

Line 775: FROM OKL_TXD_ASSETS_TL B

771:
772: UPDATE OKL_TXD_ASSETS_TL T SET (
773: DESCRIPTION) = (SELECT
774: B.DESCRIPTION
775: FROM OKL_TXD_ASSETS_TL B
776: WHERE B.ID = T.ID
777: AND B.LANGUAGE = T.SOURCE_LANG)
778: WHERE (
779: T.ID,

Line 784: FROM OKL_TXD_ASSETS_TL SUBB, OKL_TXD_ASSETS_TL SUBT

780: T.LANGUAGE)
781: IN (SELECT
782: SUBT.ID,
783: SUBT.LANGUAGE
784: FROM OKL_TXD_ASSETS_TL SUBB, OKL_TXD_ASSETS_TL SUBT
785: WHERE SUBB.ID = SUBT.ID
786: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
787: AND (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
788: OR (SUBB.DESCRIPTION IS NULL AND SUBT.DESCRIPTION IS NOT NULL)

Line 792: INSERT INTO OKL_TXD_ASSETS_TL (

788: OR (SUBB.DESCRIPTION IS NULL AND SUBT.DESCRIPTION IS NOT NULL)
789: OR (SUBB.DESCRIPTION IS NOT NULL AND SUBT.DESCRIPTION IS NULL)
790: ));
791:
792: INSERT INTO OKL_TXD_ASSETS_TL (
793: ID,
794: LANGUAGE,
795: SOURCE_LANG,
796: SFWT_FLAG,

Line 814: FROM OKL_TXD_ASSETS_TL B, FND_LANGUAGES L

810: B.CREATION_DATE,
811: B.LAST_UPDATED_BY,
812: B.LAST_UPDATE_DATE,
813: B.LAST_UPDATE_LOGIN
814: FROM OKL_TXD_ASSETS_TL B, FND_LANGUAGES L
815: WHERE L.INSTALLED_FLAG IN ('I', 'B')
816: AND B.LANGUAGE = USERENV('LANG')
817: AND NOT EXISTS(
818: SELECT NULL

Line 819: FROM OKL_TXD_ASSETS_TL T

815: WHERE L.INSTALLED_FLAG IN ('I', 'B')
816: AND B.LANGUAGE = USERENV('LANG')
817: AND NOT EXISTS(
818: SELECT NULL
819: FROM OKL_TXD_ASSETS_TL T
820: WHERE T.ID = B.ID
821: AND T.LANGUAGE = L.LANGUAGE_CODE
822: );
823:

Line 945: -- FUNCTION get_rec for: OKL_TXD_ASSETS_TL

941: BEGIN
942: RETURN(get_rec(p_asd_rec, l_row_notfound));
943: END get_rec;
944: ---------------------------------------------------------------------------
945: -- FUNCTION get_rec for: OKL_TXD_ASSETS_TL
946: ---------------------------------------------------------------------------
947: FUNCTION get_rec (
948: p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type,
949: x_no_data_found OUT NOCOPY BOOLEAN

Line 948: p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type,

944: ---------------------------------------------------------------------------
945: -- FUNCTION get_rec for: OKL_TXD_ASSETS_TL
946: ---------------------------------------------------------------------------
947: FUNCTION get_rec (
948: p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type,
949: x_no_data_found OUT NOCOPY BOOLEAN
950: ) RETURN okl_txd_assets_tl_rec_type IS
951: CURSOR okl_txd_asset_tl_pk_csr (p_id IN NUMBER,
952: p_language IN VARCHAR2) IS

Line 950: ) RETURN okl_txd_assets_tl_rec_type IS

946: ---------------------------------------------------------------------------
947: FUNCTION get_rec (
948: p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type,
949: x_no_data_found OUT NOCOPY BOOLEAN
950: ) RETURN okl_txd_assets_tl_rec_type IS
951: CURSOR okl_txd_asset_tl_pk_csr (p_id IN NUMBER,
952: p_language IN VARCHAR2) IS
953: SELECT
954: ID,

Line 964: FROM okl_txd_assets_tl

960: CREATION_DATE,
961: LAST_UPDATED_BY,
962: LAST_UPDATE_DATE,
963: LAST_UPDATE_LOGIN
964: FROM okl_txd_assets_tl
965: WHERE okl_txd_assets_tl.id = p_id
966: AND okl_txd_assets_tl.language = p_language;
967: l_okl_txd_asset_tl_pk okl_txd_asset_tl_pk_csr%ROWTYPE;
968: l_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;

Line 965: WHERE okl_txd_assets_tl.id = p_id

961: LAST_UPDATED_BY,
962: LAST_UPDATE_DATE,
963: LAST_UPDATE_LOGIN
964: FROM okl_txd_assets_tl
965: WHERE okl_txd_assets_tl.id = p_id
966: AND okl_txd_assets_tl.language = p_language;
967: l_okl_txd_asset_tl_pk okl_txd_asset_tl_pk_csr%ROWTYPE;
968: l_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;
969: BEGIN

Line 966: AND okl_txd_assets_tl.language = p_language;

962: LAST_UPDATE_DATE,
963: LAST_UPDATE_LOGIN
964: FROM okl_txd_assets_tl
965: WHERE okl_txd_assets_tl.id = p_id
966: AND okl_txd_assets_tl.language = p_language;
967: l_okl_txd_asset_tl_pk okl_txd_asset_tl_pk_csr%ROWTYPE;
968: l_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;
969: BEGIN
970: x_no_data_found := TRUE;

Line 968: l_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;

964: FROM okl_txd_assets_tl
965: WHERE okl_txd_assets_tl.id = p_id
966: AND okl_txd_assets_tl.language = p_language;
967: l_okl_txd_asset_tl_pk okl_txd_asset_tl_pk_csr%ROWTYPE;
968: l_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;
969: BEGIN
970: x_no_data_found := TRUE;
971: -- Get current database values
972: OPEN okl_txd_asset_tl_pk_csr (p_okl_txd_assets_tl_rec.id,

Line 972: OPEN okl_txd_asset_tl_pk_csr (p_okl_txd_assets_tl_rec.id,

968: l_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;
969: BEGIN
970: x_no_data_found := TRUE;
971: -- Get current database values
972: OPEN okl_txd_asset_tl_pk_csr (p_okl_txd_assets_tl_rec.id,
973: p_okl_txd_assets_tl_rec.language);
974: FETCH okl_txd_asset_tl_pk_csr INTO
975: l_okl_txd_assets_tl_rec.ID,
976: l_okl_txd_assets_tl_rec.LANGUAGE,

Line 973: p_okl_txd_assets_tl_rec.language);

969: BEGIN
970: x_no_data_found := TRUE;
971: -- Get current database values
972: OPEN okl_txd_asset_tl_pk_csr (p_okl_txd_assets_tl_rec.id,
973: p_okl_txd_assets_tl_rec.language);
974: FETCH okl_txd_asset_tl_pk_csr INTO
975: l_okl_txd_assets_tl_rec.ID,
976: l_okl_txd_assets_tl_rec.LANGUAGE,
977: l_okl_txd_assets_tl_rec.SOURCE_LANG,

Line 975: l_okl_txd_assets_tl_rec.ID,

971: -- Get current database values
972: OPEN okl_txd_asset_tl_pk_csr (p_okl_txd_assets_tl_rec.id,
973: p_okl_txd_assets_tl_rec.language);
974: FETCH okl_txd_asset_tl_pk_csr INTO
975: l_okl_txd_assets_tl_rec.ID,
976: l_okl_txd_assets_tl_rec.LANGUAGE,
977: l_okl_txd_assets_tl_rec.SOURCE_LANG,
978: l_okl_txd_assets_tl_rec.SFWT_FLAG,
979: l_okl_txd_assets_tl_rec.DESCRIPTION,

Line 976: l_okl_txd_assets_tl_rec.LANGUAGE,

972: OPEN okl_txd_asset_tl_pk_csr (p_okl_txd_assets_tl_rec.id,
973: p_okl_txd_assets_tl_rec.language);
974: FETCH okl_txd_asset_tl_pk_csr INTO
975: l_okl_txd_assets_tl_rec.ID,
976: l_okl_txd_assets_tl_rec.LANGUAGE,
977: l_okl_txd_assets_tl_rec.SOURCE_LANG,
978: l_okl_txd_assets_tl_rec.SFWT_FLAG,
979: l_okl_txd_assets_tl_rec.DESCRIPTION,
980: l_okl_txd_assets_tl_rec.CREATED_BY,

Line 977: l_okl_txd_assets_tl_rec.SOURCE_LANG,

973: p_okl_txd_assets_tl_rec.language);
974: FETCH okl_txd_asset_tl_pk_csr INTO
975: l_okl_txd_assets_tl_rec.ID,
976: l_okl_txd_assets_tl_rec.LANGUAGE,
977: l_okl_txd_assets_tl_rec.SOURCE_LANG,
978: l_okl_txd_assets_tl_rec.SFWT_FLAG,
979: l_okl_txd_assets_tl_rec.DESCRIPTION,
980: l_okl_txd_assets_tl_rec.CREATED_BY,
981: l_okl_txd_assets_tl_rec.CREATION_DATE,

Line 978: l_okl_txd_assets_tl_rec.SFWT_FLAG,

974: FETCH okl_txd_asset_tl_pk_csr INTO
975: l_okl_txd_assets_tl_rec.ID,
976: l_okl_txd_assets_tl_rec.LANGUAGE,
977: l_okl_txd_assets_tl_rec.SOURCE_LANG,
978: l_okl_txd_assets_tl_rec.SFWT_FLAG,
979: l_okl_txd_assets_tl_rec.DESCRIPTION,
980: l_okl_txd_assets_tl_rec.CREATED_BY,
981: l_okl_txd_assets_tl_rec.CREATION_DATE,
982: l_okl_txd_assets_tl_rec.LAST_UPDATED_BY,

Line 979: l_okl_txd_assets_tl_rec.DESCRIPTION,

975: l_okl_txd_assets_tl_rec.ID,
976: l_okl_txd_assets_tl_rec.LANGUAGE,
977: l_okl_txd_assets_tl_rec.SOURCE_LANG,
978: l_okl_txd_assets_tl_rec.SFWT_FLAG,
979: l_okl_txd_assets_tl_rec.DESCRIPTION,
980: l_okl_txd_assets_tl_rec.CREATED_BY,
981: l_okl_txd_assets_tl_rec.CREATION_DATE,
982: l_okl_txd_assets_tl_rec.LAST_UPDATED_BY,
983: l_okl_txd_assets_tl_rec.LAST_UPDATE_DATE,

Line 980: l_okl_txd_assets_tl_rec.CREATED_BY,

976: l_okl_txd_assets_tl_rec.LANGUAGE,
977: l_okl_txd_assets_tl_rec.SOURCE_LANG,
978: l_okl_txd_assets_tl_rec.SFWT_FLAG,
979: l_okl_txd_assets_tl_rec.DESCRIPTION,
980: l_okl_txd_assets_tl_rec.CREATED_BY,
981: l_okl_txd_assets_tl_rec.CREATION_DATE,
982: l_okl_txd_assets_tl_rec.LAST_UPDATED_BY,
983: l_okl_txd_assets_tl_rec.LAST_UPDATE_DATE,
984: l_okl_txd_assets_tl_rec.LAST_UPDATE_LOGIN;

Line 981: l_okl_txd_assets_tl_rec.CREATION_DATE,

977: l_okl_txd_assets_tl_rec.SOURCE_LANG,
978: l_okl_txd_assets_tl_rec.SFWT_FLAG,
979: l_okl_txd_assets_tl_rec.DESCRIPTION,
980: l_okl_txd_assets_tl_rec.CREATED_BY,
981: l_okl_txd_assets_tl_rec.CREATION_DATE,
982: l_okl_txd_assets_tl_rec.LAST_UPDATED_BY,
983: l_okl_txd_assets_tl_rec.LAST_UPDATE_DATE,
984: l_okl_txd_assets_tl_rec.LAST_UPDATE_LOGIN;
985: x_no_data_found := okl_txd_asset_tl_pk_csr%NOTFOUND;

Line 982: l_okl_txd_assets_tl_rec.LAST_UPDATED_BY,

978: l_okl_txd_assets_tl_rec.SFWT_FLAG,
979: l_okl_txd_assets_tl_rec.DESCRIPTION,
980: l_okl_txd_assets_tl_rec.CREATED_BY,
981: l_okl_txd_assets_tl_rec.CREATION_DATE,
982: l_okl_txd_assets_tl_rec.LAST_UPDATED_BY,
983: l_okl_txd_assets_tl_rec.LAST_UPDATE_DATE,
984: l_okl_txd_assets_tl_rec.LAST_UPDATE_LOGIN;
985: x_no_data_found := okl_txd_asset_tl_pk_csr%NOTFOUND;
986: CLOSE okl_txd_asset_tl_pk_csr;

Line 983: l_okl_txd_assets_tl_rec.LAST_UPDATE_DATE,

979: l_okl_txd_assets_tl_rec.DESCRIPTION,
980: l_okl_txd_assets_tl_rec.CREATED_BY,
981: l_okl_txd_assets_tl_rec.CREATION_DATE,
982: l_okl_txd_assets_tl_rec.LAST_UPDATED_BY,
983: l_okl_txd_assets_tl_rec.LAST_UPDATE_DATE,
984: l_okl_txd_assets_tl_rec.LAST_UPDATE_LOGIN;
985: x_no_data_found := okl_txd_asset_tl_pk_csr%NOTFOUND;
986: CLOSE okl_txd_asset_tl_pk_csr;
987: RETURN(l_okl_txd_assets_tl_rec);

Line 984: l_okl_txd_assets_tl_rec.LAST_UPDATE_LOGIN;

980: l_okl_txd_assets_tl_rec.CREATED_BY,
981: l_okl_txd_assets_tl_rec.CREATION_DATE,
982: l_okl_txd_assets_tl_rec.LAST_UPDATED_BY,
983: l_okl_txd_assets_tl_rec.LAST_UPDATE_DATE,
984: l_okl_txd_assets_tl_rec.LAST_UPDATE_LOGIN;
985: x_no_data_found := okl_txd_asset_tl_pk_csr%NOTFOUND;
986: CLOSE okl_txd_asset_tl_pk_csr;
987: RETURN(l_okl_txd_assets_tl_rec);
988: END get_rec;

Line 987: RETURN(l_okl_txd_assets_tl_rec);

983: l_okl_txd_assets_tl_rec.LAST_UPDATE_DATE,
984: l_okl_txd_assets_tl_rec.LAST_UPDATE_LOGIN;
985: x_no_data_found := okl_txd_asset_tl_pk_csr%NOTFOUND;
986: CLOSE okl_txd_asset_tl_pk_csr;
987: RETURN(l_okl_txd_assets_tl_rec);
988: END get_rec;
989:
990: FUNCTION get_rec (
991: p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type

Line 991: p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type

987: RETURN(l_okl_txd_assets_tl_rec);
988: END get_rec;
989:
990: FUNCTION get_rec (
991: p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type
992: ) RETURN okl_txd_assets_tl_rec_type IS
993: l_row_notfound BOOLEAN := TRUE;
994: BEGIN
995: RETURN(get_rec(p_okl_txd_assets_tl_rec, l_row_notfound));

Line 992: ) RETURN okl_txd_assets_tl_rec_type IS

988: END get_rec;
989:
990: FUNCTION get_rec (
991: p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type
992: ) RETURN okl_txd_assets_tl_rec_type IS
993: l_row_notfound BOOLEAN := TRUE;
994: BEGIN
995: RETURN(get_rec(p_okl_txd_assets_tl_rec, l_row_notfound));
996: END get_rec;

Line 995: RETURN(get_rec(p_okl_txd_assets_tl_rec, l_row_notfound));

991: p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type
992: ) RETURN okl_txd_assets_tl_rec_type IS
993: l_row_notfound BOOLEAN := TRUE;
994: BEGIN
995: RETURN(get_rec(p_okl_txd_assets_tl_rec, l_row_notfound));
996: END get_rec;
997: ---------------------------------------------------------------------------
998: -- FUNCTION get_rec for: OKL_TXD_ASSETS_V
999: ---------------------------------------------------------------------------

Line 1471: p_to IN OUT NOCOPY okl_txd_assets_tl_rec_type

1467: -- Multi-Currency Change
1468: END migrate;
1469: PROCEDURE migrate (
1470: p_from IN asdv_rec_type,
1471: p_to IN OUT NOCOPY okl_txd_assets_tl_rec_type
1472: ) IS
1473: BEGIN
1474: p_to.id := p_from.id;
1475: p_to.sfwt_flag := p_from.sfwt_flag;

Line 1484: p_from IN okl_txd_assets_tl_rec_type,

1480: p_to.last_update_date := p_from.last_update_date;
1481: p_to.last_update_login := p_from.last_update_login;
1482: END migrate;
1483: PROCEDURE migrate (
1484: p_from IN okl_txd_assets_tl_rec_type,
1485: p_to IN OUT NOCOPY asdv_rec_type
1486: ) IS
1487: BEGIN
1488: p_to.id := p_from.id;

Line 1517: l_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;

1513: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
1514: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1515: l_asdv_rec asdv_rec_type := p_asdv_rec;
1516: l_asd_rec asd_rec_type;
1517: l_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;
1518: BEGIN
1519: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1520: G_PKG_NAME,
1521: p_init_msg_list,

Line 1825: -- insert_row for:OKL_TXD_ASSETS_TL --

1821: '_PVT'
1822: );
1823: END insert_row;
1824: --------------------------------------
1825: -- insert_row for:OKL_TXD_ASSETS_TL --
1826: --------------------------------------
1827: PROCEDURE insert_row(
1828: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1829: x_return_status OUT NOCOPY VARCHAR2,

Line 1832: p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type,

1828: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1829: x_return_status OUT NOCOPY VARCHAR2,
1830: x_msg_count OUT NOCOPY NUMBER,
1831: x_msg_data OUT NOCOPY VARCHAR2,
1832: p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type,
1833: x_okl_txd_assets_tl_rec OUT NOCOPY okl_txd_assets_tl_rec_type) IS
1834:
1835: l_api_version CONSTANT NUMBER := 1;
1836: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';

Line 1833: x_okl_txd_assets_tl_rec OUT NOCOPY okl_txd_assets_tl_rec_type) IS

1829: x_return_status OUT NOCOPY VARCHAR2,
1830: x_msg_count OUT NOCOPY NUMBER,
1831: x_msg_data OUT NOCOPY VARCHAR2,
1832: p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type,
1833: x_okl_txd_assets_tl_rec OUT NOCOPY okl_txd_assets_tl_rec_type) IS
1834:
1835: l_api_version CONSTANT NUMBER := 1;
1836: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1837: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1838: l_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type := p_okl_txd_assets_tl_rec;

1834:
1835: l_api_version CONSTANT NUMBER := 1;
1836: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1837: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1838: l_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type := p_okl_txd_assets_tl_rec;
1839: l_def_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;
1840: CURSOR get_languages IS
1841: SELECT *
1842: FROM FND_LANGUAGES

Line 1839: l_def_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;

1835: l_api_version CONSTANT NUMBER := 1;
1836: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1837: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1838: l_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type := p_okl_txd_assets_tl_rec;
1839: l_def_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;
1840: CURSOR get_languages IS
1841: SELECT *
1842: FROM FND_LANGUAGES
1843: WHERE INSTALLED_FLAG IN ('I', 'B');

Line 1845: -- Set_Attributes for:OKL_TXD_ASSETS_TL --

1841: SELECT *
1842: FROM FND_LANGUAGES
1843: WHERE INSTALLED_FLAG IN ('I', 'B');
1844: ------------------------------------------
1845: -- Set_Attributes for:OKL_TXD_ASSETS_TL --
1846: ------------------------------------------
1847: FUNCTION Set_Attributes (
1848: p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type,
1849: x_okl_txd_assets_tl_rec OUT NOCOPY okl_txd_assets_tl_rec_type

Line 1848: p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type,

1844: ------------------------------------------
1845: -- Set_Attributes for:OKL_TXD_ASSETS_TL --
1846: ------------------------------------------
1847: FUNCTION Set_Attributes (
1848: p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type,
1849: x_okl_txd_assets_tl_rec OUT NOCOPY okl_txd_assets_tl_rec_type
1850: ) RETURN VARCHAR2 IS
1851: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1852: BEGIN

Line 1849: x_okl_txd_assets_tl_rec OUT NOCOPY okl_txd_assets_tl_rec_type

1845: -- Set_Attributes for:OKL_TXD_ASSETS_TL --
1846: ------------------------------------------
1847: FUNCTION Set_Attributes (
1848: p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type,
1849: x_okl_txd_assets_tl_rec OUT NOCOPY okl_txd_assets_tl_rec_type
1850: ) RETURN VARCHAR2 IS
1851: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1852: BEGIN
1853: x_okl_txd_assets_tl_rec := p_okl_txd_assets_tl_rec;

Line 1853: x_okl_txd_assets_tl_rec := p_okl_txd_assets_tl_rec;

1849: x_okl_txd_assets_tl_rec OUT NOCOPY okl_txd_assets_tl_rec_type
1850: ) RETURN VARCHAR2 IS
1851: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1852: BEGIN
1853: x_okl_txd_assets_tl_rec := p_okl_txd_assets_tl_rec;
1854: x_okl_txd_assets_tl_rec.LANGUAGE := USERENV('LANG');
1855: x_okl_txd_assets_tl_rec.SOURCE_LANG := USERENV('LANG');
1856: RETURN(l_return_status);
1857: END Set_Attributes;

Line 1854: x_okl_txd_assets_tl_rec.LANGUAGE := USERENV('LANG');

1850: ) RETURN VARCHAR2 IS
1851: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1852: BEGIN
1853: x_okl_txd_assets_tl_rec := p_okl_txd_assets_tl_rec;
1854: x_okl_txd_assets_tl_rec.LANGUAGE := USERENV('LANG');
1855: x_okl_txd_assets_tl_rec.SOURCE_LANG := USERENV('LANG');
1856: RETURN(l_return_status);
1857: END Set_Attributes;
1858: BEGIN

Line 1855: x_okl_txd_assets_tl_rec.SOURCE_LANG := USERENV('LANG');

1851: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1852: BEGIN
1853: x_okl_txd_assets_tl_rec := p_okl_txd_assets_tl_rec;
1854: x_okl_txd_assets_tl_rec.LANGUAGE := USERENV('LANG');
1855: x_okl_txd_assets_tl_rec.SOURCE_LANG := USERENV('LANG');
1856: RETURN(l_return_status);
1857: END Set_Attributes;
1858: BEGIN
1859: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1870: p_okl_txd_assets_tl_rec, -- IN

1866: RAISE OKC_API.G_EXCEPTION_ERROR;
1867: END IF;
1868: --- Setting item attributes
1869: l_return_status := Set_Attributes(
1870: p_okl_txd_assets_tl_rec, -- IN
1871: l_okl_txd_assets_tl_rec); -- OUT
1872: --- If any errors happen abort API
1873: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1874: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1871: l_okl_txd_assets_tl_rec); -- OUT

1867: END IF;
1868: --- Setting item attributes
1869: l_return_status := Set_Attributes(
1870: p_okl_txd_assets_tl_rec, -- IN
1871: l_okl_txd_assets_tl_rec); -- OUT
1872: --- If any errors happen abort API
1873: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1874: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1875: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 1879: l_okl_txd_assets_tl_rec.language := l_lang_rec.language_code;

1875: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1876: RAISE OKC_API.G_EXCEPTION_ERROR;
1877: END IF;
1878: FOR l_lang_rec IN get_languages LOOP
1879: l_okl_txd_assets_tl_rec.language := l_lang_rec.language_code;
1880: INSERT INTO OKL_TXD_ASSETS_TL(
1881: id,
1882: language,
1883: source_lang,

Line 1880: INSERT INTO OKL_TXD_ASSETS_TL(

1876: RAISE OKC_API.G_EXCEPTION_ERROR;
1877: END IF;
1878: FOR l_lang_rec IN get_languages LOOP
1879: l_okl_txd_assets_tl_rec.language := l_lang_rec.language_code;
1880: INSERT INTO OKL_TXD_ASSETS_TL(
1881: id,
1882: language,
1883: source_lang,
1884: sfwt_flag,

Line 1892: l_okl_txd_assets_tl_rec.id,

1888: last_updated_by,
1889: last_update_date,
1890: last_update_login)
1891: VALUES (
1892: l_okl_txd_assets_tl_rec.id,
1893: l_okl_txd_assets_tl_rec.language,
1894: l_okl_txd_assets_tl_rec.source_lang,
1895: l_okl_txd_assets_tl_rec.sfwt_flag,
1896: l_okl_txd_assets_tl_rec.description,

Line 1893: l_okl_txd_assets_tl_rec.language,

1889: last_update_date,
1890: last_update_login)
1891: VALUES (
1892: l_okl_txd_assets_tl_rec.id,
1893: l_okl_txd_assets_tl_rec.language,
1894: l_okl_txd_assets_tl_rec.source_lang,
1895: l_okl_txd_assets_tl_rec.sfwt_flag,
1896: l_okl_txd_assets_tl_rec.description,
1897: l_okl_txd_assets_tl_rec.created_by,

Line 1894: l_okl_txd_assets_tl_rec.source_lang,

1890: last_update_login)
1891: VALUES (
1892: l_okl_txd_assets_tl_rec.id,
1893: l_okl_txd_assets_tl_rec.language,
1894: l_okl_txd_assets_tl_rec.source_lang,
1895: l_okl_txd_assets_tl_rec.sfwt_flag,
1896: l_okl_txd_assets_tl_rec.description,
1897: l_okl_txd_assets_tl_rec.created_by,
1898: l_okl_txd_assets_tl_rec.creation_date,

Line 1895: l_okl_txd_assets_tl_rec.sfwt_flag,

1891: VALUES (
1892: l_okl_txd_assets_tl_rec.id,
1893: l_okl_txd_assets_tl_rec.language,
1894: l_okl_txd_assets_tl_rec.source_lang,
1895: l_okl_txd_assets_tl_rec.sfwt_flag,
1896: l_okl_txd_assets_tl_rec.description,
1897: l_okl_txd_assets_tl_rec.created_by,
1898: l_okl_txd_assets_tl_rec.creation_date,
1899: l_okl_txd_assets_tl_rec.last_updated_by,

Line 1896: l_okl_txd_assets_tl_rec.description,

1892: l_okl_txd_assets_tl_rec.id,
1893: l_okl_txd_assets_tl_rec.language,
1894: l_okl_txd_assets_tl_rec.source_lang,
1895: l_okl_txd_assets_tl_rec.sfwt_flag,
1896: l_okl_txd_assets_tl_rec.description,
1897: l_okl_txd_assets_tl_rec.created_by,
1898: l_okl_txd_assets_tl_rec.creation_date,
1899: l_okl_txd_assets_tl_rec.last_updated_by,
1900: l_okl_txd_assets_tl_rec.last_update_date,

Line 1897: l_okl_txd_assets_tl_rec.created_by,

1893: l_okl_txd_assets_tl_rec.language,
1894: l_okl_txd_assets_tl_rec.source_lang,
1895: l_okl_txd_assets_tl_rec.sfwt_flag,
1896: l_okl_txd_assets_tl_rec.description,
1897: l_okl_txd_assets_tl_rec.created_by,
1898: l_okl_txd_assets_tl_rec.creation_date,
1899: l_okl_txd_assets_tl_rec.last_updated_by,
1900: l_okl_txd_assets_tl_rec.last_update_date,
1901: l_okl_txd_assets_tl_rec.last_update_login);

Line 1898: l_okl_txd_assets_tl_rec.creation_date,

1894: l_okl_txd_assets_tl_rec.source_lang,
1895: l_okl_txd_assets_tl_rec.sfwt_flag,
1896: l_okl_txd_assets_tl_rec.description,
1897: l_okl_txd_assets_tl_rec.created_by,
1898: l_okl_txd_assets_tl_rec.creation_date,
1899: l_okl_txd_assets_tl_rec.last_updated_by,
1900: l_okl_txd_assets_tl_rec.last_update_date,
1901: l_okl_txd_assets_tl_rec.last_update_login);
1902: END LOOP;

Line 1899: l_okl_txd_assets_tl_rec.last_updated_by,

1895: l_okl_txd_assets_tl_rec.sfwt_flag,
1896: l_okl_txd_assets_tl_rec.description,
1897: l_okl_txd_assets_tl_rec.created_by,
1898: l_okl_txd_assets_tl_rec.creation_date,
1899: l_okl_txd_assets_tl_rec.last_updated_by,
1900: l_okl_txd_assets_tl_rec.last_update_date,
1901: l_okl_txd_assets_tl_rec.last_update_login);
1902: END LOOP;
1903: -- Set OUT values

Line 1900: l_okl_txd_assets_tl_rec.last_update_date,

1896: l_okl_txd_assets_tl_rec.description,
1897: l_okl_txd_assets_tl_rec.created_by,
1898: l_okl_txd_assets_tl_rec.creation_date,
1899: l_okl_txd_assets_tl_rec.last_updated_by,
1900: l_okl_txd_assets_tl_rec.last_update_date,
1901: l_okl_txd_assets_tl_rec.last_update_login);
1902: END LOOP;
1903: -- Set OUT values
1904: x_okl_txd_assets_tl_rec := l_okl_txd_assets_tl_rec;

Line 1901: l_okl_txd_assets_tl_rec.last_update_login);

1897: l_okl_txd_assets_tl_rec.created_by,
1898: l_okl_txd_assets_tl_rec.creation_date,
1899: l_okl_txd_assets_tl_rec.last_updated_by,
1900: l_okl_txd_assets_tl_rec.last_update_date,
1901: l_okl_txd_assets_tl_rec.last_update_login);
1902: END LOOP;
1903: -- Set OUT values
1904: x_okl_txd_assets_tl_rec := l_okl_txd_assets_tl_rec;
1905: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1904: x_okl_txd_assets_tl_rec := l_okl_txd_assets_tl_rec;

1900: l_okl_txd_assets_tl_rec.last_update_date,
1901: l_okl_txd_assets_tl_rec.last_update_login);
1902: END LOOP;
1903: -- Set OUT values
1904: x_okl_txd_assets_tl_rec := l_okl_txd_assets_tl_rec;
1905: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1906: EXCEPTION
1907: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1908: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1957: l_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;

1953: l_asdv_rec asdv_rec_type;
1954: l_def_asdv_rec asdv_rec_type;
1955: l_asd_rec asd_rec_type;
1956: lx_asd_rec asd_rec_type;
1957: l_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;
1958: lx_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;
1959: lx_temp_asdv_rec asdv_rec_type;
1960: -------------------------------
1961: -- FUNCTION fill_who_columns --

Line 1958: lx_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;

1954: l_def_asdv_rec asdv_rec_type;
1955: l_asd_rec asd_rec_type;
1956: lx_asd_rec asd_rec_type;
1957: l_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;
1958: lx_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;
1959: lx_temp_asdv_rec asdv_rec_type;
1960: -------------------------------
1961: -- FUNCTION fill_who_columns --
1962: -------------------------------

Line 2076: migrate(l_def_asdv_rec, l_okl_txd_assets_tl_rec);

2072: --------------------------------------
2073: -- Move VIEW record to "Child" records
2074: --------------------------------------
2075: migrate(l_def_asdv_rec, l_asd_rec);
2076: migrate(l_def_asdv_rec, l_okl_txd_assets_tl_rec);
2077: --------------------------------------------
2078: -- Call the INSERT_ROW for each child record
2079: --------------------------------------------
2080: insert_row(

Line 2099: l_okl_txd_assets_tl_rec,

2095: p_init_msg_list,
2096: x_return_status,
2097: x_msg_count,
2098: x_msg_data,
2099: l_okl_txd_assets_tl_rec,
2100: lx_okl_txd_assets_tl_rec
2101: );
2102: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2103: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2100: lx_okl_txd_assets_tl_rec

2096: x_return_status,
2097: x_msg_count,
2098: x_msg_data,
2099: l_okl_txd_assets_tl_rec,
2100: lx_okl_txd_assets_tl_rec
2101: );
2102: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2103: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2104: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2107: migrate(lx_okl_txd_assets_tl_rec, l_def_asdv_rec);

2103: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2104: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2105: RAISE OKC_API.G_EXCEPTION_ERROR;
2106: END IF;
2107: migrate(lx_okl_txd_assets_tl_rec, l_def_asdv_rec);
2108: -- Set OUT values
2109: x_asdv_rec := l_def_asdv_rec;
2110: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2111: EXCEPTION

Line 2320: -- lock_row for:OKL_TXD_ASSETS_TL --

2316: '_PVT'
2317: );
2318: END lock_row;
2319: ------------------------------------
2320: -- lock_row for:OKL_TXD_ASSETS_TL --
2321: ------------------------------------
2322: PROCEDURE lock_row(
2323: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2324: x_return_status OUT NOCOPY VARCHAR2,

Line 2327: p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type) IS

2323: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2324: x_return_status OUT NOCOPY VARCHAR2,
2325: x_msg_count OUT NOCOPY NUMBER,
2326: x_msg_data OUT NOCOPY VARCHAR2,
2327: p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type) IS
2328:
2329: E_Resource_Busy EXCEPTION;
2330: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2331: CURSOR lock_csr (p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type) IS

Line 2331: CURSOR lock_csr (p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type) IS

2327: p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type) IS
2328:
2329: E_Resource_Busy EXCEPTION;
2330: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2331: CURSOR lock_csr (p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type) IS
2332: SELECT *
2333: FROM OKL_TXD_ASSETS_TL
2334: WHERE ID = p_okl_txd_assets_tl_rec.id
2335: FOR UPDATE NOWAIT;

Line 2333: FROM OKL_TXD_ASSETS_TL

2329: E_Resource_Busy EXCEPTION;
2330: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2331: CURSOR lock_csr (p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type) IS
2332: SELECT *
2333: FROM OKL_TXD_ASSETS_TL
2334: WHERE ID = p_okl_txd_assets_tl_rec.id
2335: FOR UPDATE NOWAIT;
2336:
2337: l_api_version CONSTANT NUMBER := 1;

Line 2334: WHERE ID = p_okl_txd_assets_tl_rec.id

2330: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2331: CURSOR lock_csr (p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type) IS
2332: SELECT *
2333: FROM OKL_TXD_ASSETS_TL
2334: WHERE ID = p_okl_txd_assets_tl_rec.id
2335: FOR UPDATE NOWAIT;
2336:
2337: l_api_version CONSTANT NUMBER := 1;
2338: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';

Line 2354: OPEN lock_csr(p_okl_txd_assets_tl_rec);

2350: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2351: RAISE OKC_API.G_EXCEPTION_ERROR;
2352: END IF;
2353: BEGIN
2354: OPEN lock_csr(p_okl_txd_assets_tl_rec);
2355: FETCH lock_csr INTO l_lock_var;
2356: l_row_notfound := lock_csr%NOTFOUND;
2357: CLOSE lock_csr;
2358: EXCEPTION

Line 2419: l_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;

2415: l_api_version CONSTANT NUMBER := 1;
2416: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
2417: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2418: l_asd_rec asd_rec_type;
2419: l_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;
2420: BEGIN
2421: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2422: G_PKG_NAME,
2423: p_init_msg_list,

Line 2437: migrate(p_asdv_rec, l_okl_txd_assets_tl_rec);

2433: --------------------------------------
2434: -- Move VIEW record to "Child" records
2435: --------------------------------------
2436: migrate(p_asdv_rec, l_asd_rec);
2437: migrate(p_asdv_rec, l_okl_txd_assets_tl_rec);
2438: --------------------------------------------
2439: -- Call the LOCK_ROW for each child record
2440: --------------------------------------------
2441: lock_row(

Line 2458: l_okl_txd_assets_tl_rec

2454: p_init_msg_list,
2455: x_return_status,
2456: x_msg_count,
2457: x_msg_data,
2458: l_okl_txd_assets_tl_rec
2459: );
2460: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2461: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2462: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2887: -- update_row for:OKL_TXD_ASSETS_TL --

2883: '_PVT'
2884: );
2885: END update_row;
2886: --------------------------------------
2887: -- update_row for:OKL_TXD_ASSETS_TL --
2888: --------------------------------------
2889: PROCEDURE update_row(
2890: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2891: x_return_status OUT NOCOPY VARCHAR2,

Line 2894: p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type,

2890: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2891: x_return_status OUT NOCOPY VARCHAR2,
2892: x_msg_count OUT NOCOPY NUMBER,
2893: x_msg_data OUT NOCOPY VARCHAR2,
2894: p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type,
2895: x_okl_txd_assets_tl_rec OUT NOCOPY okl_txd_assets_tl_rec_type) IS
2896:
2897: l_api_version CONSTANT NUMBER := 1;
2898: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';

Line 2895: x_okl_txd_assets_tl_rec OUT NOCOPY okl_txd_assets_tl_rec_type) IS

2891: x_return_status OUT NOCOPY VARCHAR2,
2892: x_msg_count OUT NOCOPY NUMBER,
2893: x_msg_data OUT NOCOPY VARCHAR2,
2894: p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type,
2895: x_okl_txd_assets_tl_rec OUT NOCOPY okl_txd_assets_tl_rec_type) IS
2896:
2897: l_api_version CONSTANT NUMBER := 1;
2898: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2899: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2900: l_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type := p_okl_txd_assets_tl_rec;

2896:
2897: l_api_version CONSTANT NUMBER := 1;
2898: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2899: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2900: l_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type := p_okl_txd_assets_tl_rec;
2901: l_def_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;
2902: l_row_notfound BOOLEAN := TRUE;
2903: ----------------------------------
2904: -- FUNCTION populate_new_record --

Line 2901: l_def_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;

2897: l_api_version CONSTANT NUMBER := 1;
2898: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2899: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2900: l_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type := p_okl_txd_assets_tl_rec;
2901: l_def_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;
2902: l_row_notfound BOOLEAN := TRUE;
2903: ----------------------------------
2904: -- FUNCTION populate_new_record --
2905: ----------------------------------

Line 2907: p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type,

2903: ----------------------------------
2904: -- FUNCTION populate_new_record --
2905: ----------------------------------
2906: FUNCTION populate_new_record (
2907: p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type,
2908: x_okl_txd_assets_tl_rec OUT NOCOPY okl_txd_assets_tl_rec_type
2909: ) RETURN VARCHAR2 IS
2910: l_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;
2911: l_row_notfound BOOLEAN := TRUE;

Line 2908: x_okl_txd_assets_tl_rec OUT NOCOPY okl_txd_assets_tl_rec_type

2904: -- FUNCTION populate_new_record --
2905: ----------------------------------
2906: FUNCTION populate_new_record (
2907: p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type,
2908: x_okl_txd_assets_tl_rec OUT NOCOPY okl_txd_assets_tl_rec_type
2909: ) RETURN VARCHAR2 IS
2910: l_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;
2911: l_row_notfound BOOLEAN := TRUE;
2912: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2910: l_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;

2906: FUNCTION populate_new_record (
2907: p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type,
2908: x_okl_txd_assets_tl_rec OUT NOCOPY okl_txd_assets_tl_rec_type
2909: ) RETURN VARCHAR2 IS
2910: l_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;
2911: l_row_notfound BOOLEAN := TRUE;
2912: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2913: BEGIN
2914: x_okl_txd_assets_tl_rec := p_okl_txd_assets_tl_rec;

Line 2914: x_okl_txd_assets_tl_rec := p_okl_txd_assets_tl_rec;

2910: l_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;
2911: l_row_notfound BOOLEAN := TRUE;
2912: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2913: BEGIN
2914: x_okl_txd_assets_tl_rec := p_okl_txd_assets_tl_rec;
2915: -- Get current database values
2916: l_okl_txd_assets_tl_rec := get_rec(p_okl_txd_assets_tl_rec, l_row_notfound);
2917: IF (l_row_notfound) THEN
2918: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

Line 2916: l_okl_txd_assets_tl_rec := get_rec(p_okl_txd_assets_tl_rec, l_row_notfound);

2912: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2913: BEGIN
2914: x_okl_txd_assets_tl_rec := p_okl_txd_assets_tl_rec;
2915: -- Get current database values
2916: l_okl_txd_assets_tl_rec := get_rec(p_okl_txd_assets_tl_rec, l_row_notfound);
2917: IF (l_row_notfound) THEN
2918: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2919: END IF;
2920: IF (x_okl_txd_assets_tl_rec.id = OKC_API.G_MISS_NUM)

Line 2920: IF (x_okl_txd_assets_tl_rec.id = OKC_API.G_MISS_NUM)

2916: l_okl_txd_assets_tl_rec := get_rec(p_okl_txd_assets_tl_rec, l_row_notfound);
2917: IF (l_row_notfound) THEN
2918: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2919: END IF;
2920: IF (x_okl_txd_assets_tl_rec.id = OKC_API.G_MISS_NUM)
2921: THEN
2922: x_okl_txd_assets_tl_rec.id := l_okl_txd_assets_tl_rec.id;
2923: END IF;
2924: IF (x_okl_txd_assets_tl_rec.language = OKC_API.G_MISS_CHAR)

Line 2922: x_okl_txd_assets_tl_rec.id := l_okl_txd_assets_tl_rec.id;

2918: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2919: END IF;
2920: IF (x_okl_txd_assets_tl_rec.id = OKC_API.G_MISS_NUM)
2921: THEN
2922: x_okl_txd_assets_tl_rec.id := l_okl_txd_assets_tl_rec.id;
2923: END IF;
2924: IF (x_okl_txd_assets_tl_rec.language = OKC_API.G_MISS_CHAR)
2925: THEN
2926: x_okl_txd_assets_tl_rec.language := l_okl_txd_assets_tl_rec.language;

Line 2924: IF (x_okl_txd_assets_tl_rec.language = OKC_API.G_MISS_CHAR)

2920: IF (x_okl_txd_assets_tl_rec.id = OKC_API.G_MISS_NUM)
2921: THEN
2922: x_okl_txd_assets_tl_rec.id := l_okl_txd_assets_tl_rec.id;
2923: END IF;
2924: IF (x_okl_txd_assets_tl_rec.language = OKC_API.G_MISS_CHAR)
2925: THEN
2926: x_okl_txd_assets_tl_rec.language := l_okl_txd_assets_tl_rec.language;
2927: END IF;
2928: IF (x_okl_txd_assets_tl_rec.source_lang = OKC_API.G_MISS_CHAR)

Line 2926: x_okl_txd_assets_tl_rec.language := l_okl_txd_assets_tl_rec.language;

2922: x_okl_txd_assets_tl_rec.id := l_okl_txd_assets_tl_rec.id;
2923: END IF;
2924: IF (x_okl_txd_assets_tl_rec.language = OKC_API.G_MISS_CHAR)
2925: THEN
2926: x_okl_txd_assets_tl_rec.language := l_okl_txd_assets_tl_rec.language;
2927: END IF;
2928: IF (x_okl_txd_assets_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2929: THEN
2930: x_okl_txd_assets_tl_rec.source_lang := l_okl_txd_assets_tl_rec.source_lang;

Line 2928: IF (x_okl_txd_assets_tl_rec.source_lang = OKC_API.G_MISS_CHAR)

2924: IF (x_okl_txd_assets_tl_rec.language = OKC_API.G_MISS_CHAR)
2925: THEN
2926: x_okl_txd_assets_tl_rec.language := l_okl_txd_assets_tl_rec.language;
2927: END IF;
2928: IF (x_okl_txd_assets_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2929: THEN
2930: x_okl_txd_assets_tl_rec.source_lang := l_okl_txd_assets_tl_rec.source_lang;
2931: END IF;
2932: IF (x_okl_txd_assets_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)

Line 2930: x_okl_txd_assets_tl_rec.source_lang := l_okl_txd_assets_tl_rec.source_lang;

2926: x_okl_txd_assets_tl_rec.language := l_okl_txd_assets_tl_rec.language;
2927: END IF;
2928: IF (x_okl_txd_assets_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2929: THEN
2930: x_okl_txd_assets_tl_rec.source_lang := l_okl_txd_assets_tl_rec.source_lang;
2931: END IF;
2932: IF (x_okl_txd_assets_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2933: THEN
2934: x_okl_txd_assets_tl_rec.sfwt_flag := l_okl_txd_assets_tl_rec.sfwt_flag;

Line 2932: IF (x_okl_txd_assets_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)

2928: IF (x_okl_txd_assets_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2929: THEN
2930: x_okl_txd_assets_tl_rec.source_lang := l_okl_txd_assets_tl_rec.source_lang;
2931: END IF;
2932: IF (x_okl_txd_assets_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2933: THEN
2934: x_okl_txd_assets_tl_rec.sfwt_flag := l_okl_txd_assets_tl_rec.sfwt_flag;
2935: END IF;
2936: IF (x_okl_txd_assets_tl_rec.description = OKC_API.G_MISS_CHAR)

Line 2934: x_okl_txd_assets_tl_rec.sfwt_flag := l_okl_txd_assets_tl_rec.sfwt_flag;

2930: x_okl_txd_assets_tl_rec.source_lang := l_okl_txd_assets_tl_rec.source_lang;
2931: END IF;
2932: IF (x_okl_txd_assets_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2933: THEN
2934: x_okl_txd_assets_tl_rec.sfwt_flag := l_okl_txd_assets_tl_rec.sfwt_flag;
2935: END IF;
2936: IF (x_okl_txd_assets_tl_rec.description = OKC_API.G_MISS_CHAR)
2937: THEN
2938: x_okl_txd_assets_tl_rec.description := l_okl_txd_assets_tl_rec.description;

Line 2936: IF (x_okl_txd_assets_tl_rec.description = OKC_API.G_MISS_CHAR)

2932: IF (x_okl_txd_assets_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2933: THEN
2934: x_okl_txd_assets_tl_rec.sfwt_flag := l_okl_txd_assets_tl_rec.sfwt_flag;
2935: END IF;
2936: IF (x_okl_txd_assets_tl_rec.description = OKC_API.G_MISS_CHAR)
2937: THEN
2938: x_okl_txd_assets_tl_rec.description := l_okl_txd_assets_tl_rec.description;
2939: END IF;
2940: IF (x_okl_txd_assets_tl_rec.created_by = OKC_API.G_MISS_NUM)

Line 2938: x_okl_txd_assets_tl_rec.description := l_okl_txd_assets_tl_rec.description;

2934: x_okl_txd_assets_tl_rec.sfwt_flag := l_okl_txd_assets_tl_rec.sfwt_flag;
2935: END IF;
2936: IF (x_okl_txd_assets_tl_rec.description = OKC_API.G_MISS_CHAR)
2937: THEN
2938: x_okl_txd_assets_tl_rec.description := l_okl_txd_assets_tl_rec.description;
2939: END IF;
2940: IF (x_okl_txd_assets_tl_rec.created_by = OKC_API.G_MISS_NUM)
2941: THEN
2942: x_okl_txd_assets_tl_rec.created_by := l_okl_txd_assets_tl_rec.created_by;

Line 2940: IF (x_okl_txd_assets_tl_rec.created_by = OKC_API.G_MISS_NUM)

2936: IF (x_okl_txd_assets_tl_rec.description = OKC_API.G_MISS_CHAR)
2937: THEN
2938: x_okl_txd_assets_tl_rec.description := l_okl_txd_assets_tl_rec.description;
2939: END IF;
2940: IF (x_okl_txd_assets_tl_rec.created_by = OKC_API.G_MISS_NUM)
2941: THEN
2942: x_okl_txd_assets_tl_rec.created_by := l_okl_txd_assets_tl_rec.created_by;
2943: END IF;
2944: IF (x_okl_txd_assets_tl_rec.creation_date = OKC_API.G_MISS_DATE)

Line 2942: x_okl_txd_assets_tl_rec.created_by := l_okl_txd_assets_tl_rec.created_by;

2938: x_okl_txd_assets_tl_rec.description := l_okl_txd_assets_tl_rec.description;
2939: END IF;
2940: IF (x_okl_txd_assets_tl_rec.created_by = OKC_API.G_MISS_NUM)
2941: THEN
2942: x_okl_txd_assets_tl_rec.created_by := l_okl_txd_assets_tl_rec.created_by;
2943: END IF;
2944: IF (x_okl_txd_assets_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2945: THEN
2946: x_okl_txd_assets_tl_rec.creation_date := l_okl_txd_assets_tl_rec.creation_date;

Line 2944: IF (x_okl_txd_assets_tl_rec.creation_date = OKC_API.G_MISS_DATE)

2940: IF (x_okl_txd_assets_tl_rec.created_by = OKC_API.G_MISS_NUM)
2941: THEN
2942: x_okl_txd_assets_tl_rec.created_by := l_okl_txd_assets_tl_rec.created_by;
2943: END IF;
2944: IF (x_okl_txd_assets_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2945: THEN
2946: x_okl_txd_assets_tl_rec.creation_date := l_okl_txd_assets_tl_rec.creation_date;
2947: END IF;
2948: IF (x_okl_txd_assets_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)

Line 2946: x_okl_txd_assets_tl_rec.creation_date := l_okl_txd_assets_tl_rec.creation_date;

2942: x_okl_txd_assets_tl_rec.created_by := l_okl_txd_assets_tl_rec.created_by;
2943: END IF;
2944: IF (x_okl_txd_assets_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2945: THEN
2946: x_okl_txd_assets_tl_rec.creation_date := l_okl_txd_assets_tl_rec.creation_date;
2947: END IF;
2948: IF (x_okl_txd_assets_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2949: THEN
2950: x_okl_txd_assets_tl_rec.last_updated_by := l_okl_txd_assets_tl_rec.last_updated_by;

Line 2948: IF (x_okl_txd_assets_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)

2944: IF (x_okl_txd_assets_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2945: THEN
2946: x_okl_txd_assets_tl_rec.creation_date := l_okl_txd_assets_tl_rec.creation_date;
2947: END IF;
2948: IF (x_okl_txd_assets_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2949: THEN
2950: x_okl_txd_assets_tl_rec.last_updated_by := l_okl_txd_assets_tl_rec.last_updated_by;
2951: END IF;
2952: IF (x_okl_txd_assets_tl_rec.last_update_date = OKC_API.G_MISS_DATE)

Line 2950: x_okl_txd_assets_tl_rec.last_updated_by := l_okl_txd_assets_tl_rec.last_updated_by;

2946: x_okl_txd_assets_tl_rec.creation_date := l_okl_txd_assets_tl_rec.creation_date;
2947: END IF;
2948: IF (x_okl_txd_assets_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2949: THEN
2950: x_okl_txd_assets_tl_rec.last_updated_by := l_okl_txd_assets_tl_rec.last_updated_by;
2951: END IF;
2952: IF (x_okl_txd_assets_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2953: THEN
2954: x_okl_txd_assets_tl_rec.last_update_date := l_okl_txd_assets_tl_rec.last_update_date;

Line 2952: IF (x_okl_txd_assets_tl_rec.last_update_date = OKC_API.G_MISS_DATE)

2948: IF (x_okl_txd_assets_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2949: THEN
2950: x_okl_txd_assets_tl_rec.last_updated_by := l_okl_txd_assets_tl_rec.last_updated_by;
2951: END IF;
2952: IF (x_okl_txd_assets_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2953: THEN
2954: x_okl_txd_assets_tl_rec.last_update_date := l_okl_txd_assets_tl_rec.last_update_date;
2955: END IF;
2956: IF (x_okl_txd_assets_tl_rec.last_update_login = OKC_API.G_MISS_NUM)

Line 2954: x_okl_txd_assets_tl_rec.last_update_date := l_okl_txd_assets_tl_rec.last_update_date;

2950: x_okl_txd_assets_tl_rec.last_updated_by := l_okl_txd_assets_tl_rec.last_updated_by;
2951: END IF;
2952: IF (x_okl_txd_assets_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2953: THEN
2954: x_okl_txd_assets_tl_rec.last_update_date := l_okl_txd_assets_tl_rec.last_update_date;
2955: END IF;
2956: IF (x_okl_txd_assets_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
2957: THEN
2958: x_okl_txd_assets_tl_rec.last_update_login := l_okl_txd_assets_tl_rec.last_update_login;

Line 2956: IF (x_okl_txd_assets_tl_rec.last_update_login = OKC_API.G_MISS_NUM)

2952: IF (x_okl_txd_assets_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2953: THEN
2954: x_okl_txd_assets_tl_rec.last_update_date := l_okl_txd_assets_tl_rec.last_update_date;
2955: END IF;
2956: IF (x_okl_txd_assets_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
2957: THEN
2958: x_okl_txd_assets_tl_rec.last_update_login := l_okl_txd_assets_tl_rec.last_update_login;
2959: END IF;
2960: /*

Line 2958: x_okl_txd_assets_tl_rec.last_update_login := l_okl_txd_assets_tl_rec.last_update_login;

2954: x_okl_txd_assets_tl_rec.last_update_date := l_okl_txd_assets_tl_rec.last_update_date;
2955: END IF;
2956: IF (x_okl_txd_assets_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
2957: THEN
2958: x_okl_txd_assets_tl_rec.last_update_login := l_okl_txd_assets_tl_rec.last_update_login;
2959: END IF;
2960: /*
2961: -- Multi Currency Change
2962: IF (x_okl_txd_assets_tl_rec.currency_code = OKC_API.G_MISS_CHAR)

Line 2962: IF (x_okl_txd_assets_tl_rec.currency_code = OKC_API.G_MISS_CHAR)

2958: x_okl_txd_assets_tl_rec.last_update_login := l_okl_txd_assets_tl_rec.last_update_login;
2959: END IF;
2960: /*
2961: -- Multi Currency Change
2962: IF (x_okl_txd_assets_tl_rec.currency_code = OKC_API.G_MISS_CHAR)
2963: THEN
2964: x_okl_txd_assets_tl_rec.currency_code := l_okl_txd_assets_tl_rec.currency_code;
2965: END IF;
2966: IF (x_okl_txd_assets_tl_rec.currency_conversion_type = OKC_API.G_MISS_CHAR)

Line 2964: x_okl_txd_assets_tl_rec.currency_code := l_okl_txd_assets_tl_rec.currency_code;

2960: /*
2961: -- Multi Currency Change
2962: IF (x_okl_txd_assets_tl_rec.currency_code = OKC_API.G_MISS_CHAR)
2963: THEN
2964: x_okl_txd_assets_tl_rec.currency_code := l_okl_txd_assets_tl_rec.currency_code;
2965: END IF;
2966: IF (x_okl_txd_assets_tl_rec.currency_conversion_type = OKC_API.G_MISS_CHAR)
2967: THEN
2968: x_okl_txd_assets_tl_rec.currency_conversion_type := l_okl_txd_assets_tl_rec.currency_conversion_type;

Line 2966: IF (x_okl_txd_assets_tl_rec.currency_conversion_type = OKC_API.G_MISS_CHAR)

2962: IF (x_okl_txd_assets_tl_rec.currency_code = OKC_API.G_MISS_CHAR)
2963: THEN
2964: x_okl_txd_assets_tl_rec.currency_code := l_okl_txd_assets_tl_rec.currency_code;
2965: END IF;
2966: IF (x_okl_txd_assets_tl_rec.currency_conversion_type = OKC_API.G_MISS_CHAR)
2967: THEN
2968: x_okl_txd_assets_tl_rec.currency_conversion_type := l_okl_txd_assets_tl_rec.currency_conversion_type;
2969: END IF;
2970: IF (x_okl_txd_assets_tl_rec.currency_conversion_rate = OKC_API.G_MISS_NUM)

Line 2968: x_okl_txd_assets_tl_rec.currency_conversion_type := l_okl_txd_assets_tl_rec.currency_conversion_type;

2964: x_okl_txd_assets_tl_rec.currency_code := l_okl_txd_assets_tl_rec.currency_code;
2965: END IF;
2966: IF (x_okl_txd_assets_tl_rec.currency_conversion_type = OKC_API.G_MISS_CHAR)
2967: THEN
2968: x_okl_txd_assets_tl_rec.currency_conversion_type := l_okl_txd_assets_tl_rec.currency_conversion_type;
2969: END IF;
2970: IF (x_okl_txd_assets_tl_rec.currency_conversion_rate = OKC_API.G_MISS_NUM)
2971: THEN
2972: x_okl_txd_assets_tl_rec.currency_conversion_rate := l_okl_txd_assets_tl_rec.currency_conversion_rate;

Line 2970: IF (x_okl_txd_assets_tl_rec.currency_conversion_rate = OKC_API.G_MISS_NUM)

2966: IF (x_okl_txd_assets_tl_rec.currency_conversion_type = OKC_API.G_MISS_CHAR)
2967: THEN
2968: x_okl_txd_assets_tl_rec.currency_conversion_type := l_okl_txd_assets_tl_rec.currency_conversion_type;
2969: END IF;
2970: IF (x_okl_txd_assets_tl_rec.currency_conversion_rate = OKC_API.G_MISS_NUM)
2971: THEN
2972: x_okl_txd_assets_tl_rec.currency_conversion_rate := l_okl_txd_assets_tl_rec.currency_conversion_rate;
2973: END IF;
2974: IF (x_okl_txd_assets_tl_rec.currency_conversion_date = OKC_API.G_MISS_DATE)

Line 2972: x_okl_txd_assets_tl_rec.currency_conversion_rate := l_okl_txd_assets_tl_rec.currency_conversion_rate;

2968: x_okl_txd_assets_tl_rec.currency_conversion_type := l_okl_txd_assets_tl_rec.currency_conversion_type;
2969: END IF;
2970: IF (x_okl_txd_assets_tl_rec.currency_conversion_rate = OKC_API.G_MISS_NUM)
2971: THEN
2972: x_okl_txd_assets_tl_rec.currency_conversion_rate := l_okl_txd_assets_tl_rec.currency_conversion_rate;
2973: END IF;
2974: IF (x_okl_txd_assets_tl_rec.currency_conversion_date = OKC_API.G_MISS_DATE)
2975: THEN
2976: x_okl_txd_assets_tl_rec.currency_conversion_date := l_okl_txd_assets_tl_rec.currency_conversion_date;

Line 2974: IF (x_okl_txd_assets_tl_rec.currency_conversion_date = OKC_API.G_MISS_DATE)

2970: IF (x_okl_txd_assets_tl_rec.currency_conversion_rate = OKC_API.G_MISS_NUM)
2971: THEN
2972: x_okl_txd_assets_tl_rec.currency_conversion_rate := l_okl_txd_assets_tl_rec.currency_conversion_rate;
2973: END IF;
2974: IF (x_okl_txd_assets_tl_rec.currency_conversion_date = OKC_API.G_MISS_DATE)
2975: THEN
2976: x_okl_txd_assets_tl_rec.currency_conversion_date := l_okl_txd_assets_tl_rec.currency_conversion_date;
2977: END IF;
2978: -- Multi Currency Change

Line 2976: x_okl_txd_assets_tl_rec.currency_conversion_date := l_okl_txd_assets_tl_rec.currency_conversion_date;

2972: x_okl_txd_assets_tl_rec.currency_conversion_rate := l_okl_txd_assets_tl_rec.currency_conversion_rate;
2973: END IF;
2974: IF (x_okl_txd_assets_tl_rec.currency_conversion_date = OKC_API.G_MISS_DATE)
2975: THEN
2976: x_okl_txd_assets_tl_rec.currency_conversion_date := l_okl_txd_assets_tl_rec.currency_conversion_date;
2977: END IF;
2978: -- Multi Currency Change
2979: */
2980: RETURN(l_return_status);

Line 2983: -- Set_Attributes for:OKL_TXD_ASSETS_TL --

2979: */
2980: RETURN(l_return_status);
2981: END populate_new_record;
2982: ------------------------------------------
2983: -- Set_Attributes for:OKL_TXD_ASSETS_TL --
2984: ------------------------------------------
2985: FUNCTION Set_Attributes (
2986: p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type,
2987: x_okl_txd_assets_tl_rec OUT NOCOPY okl_txd_assets_tl_rec_type

Line 2986: p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type,

2982: ------------------------------------------
2983: -- Set_Attributes for:OKL_TXD_ASSETS_TL --
2984: ------------------------------------------
2985: FUNCTION Set_Attributes (
2986: p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type,
2987: x_okl_txd_assets_tl_rec OUT NOCOPY okl_txd_assets_tl_rec_type
2988: ) RETURN VARCHAR2 IS
2989: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2990: BEGIN

Line 2987: x_okl_txd_assets_tl_rec OUT NOCOPY okl_txd_assets_tl_rec_type

2983: -- Set_Attributes for:OKL_TXD_ASSETS_TL --
2984: ------------------------------------------
2985: FUNCTION Set_Attributes (
2986: p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type,
2987: x_okl_txd_assets_tl_rec OUT NOCOPY okl_txd_assets_tl_rec_type
2988: ) RETURN VARCHAR2 IS
2989: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2990: BEGIN
2991: x_okl_txd_assets_tl_rec := p_okl_txd_assets_tl_rec;

Line 2991: x_okl_txd_assets_tl_rec := p_okl_txd_assets_tl_rec;

2987: x_okl_txd_assets_tl_rec OUT NOCOPY okl_txd_assets_tl_rec_type
2988: ) RETURN VARCHAR2 IS
2989: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2990: BEGIN
2991: x_okl_txd_assets_tl_rec := p_okl_txd_assets_tl_rec;
2992: x_okl_txd_assets_tl_rec.LANGUAGE := USERENV('LANG');
2993: x_okl_txd_assets_tl_rec.SOURCE_LANG := USERENV('LANG');
2994: RETURN(l_return_status);
2995: END Set_Attributes;

Line 2992: x_okl_txd_assets_tl_rec.LANGUAGE := USERENV('LANG');

2988: ) RETURN VARCHAR2 IS
2989: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2990: BEGIN
2991: x_okl_txd_assets_tl_rec := p_okl_txd_assets_tl_rec;
2992: x_okl_txd_assets_tl_rec.LANGUAGE := USERENV('LANG');
2993: x_okl_txd_assets_tl_rec.SOURCE_LANG := USERENV('LANG');
2994: RETURN(l_return_status);
2995: END Set_Attributes;
2996: BEGIN

Line 2993: x_okl_txd_assets_tl_rec.SOURCE_LANG := USERENV('LANG');

2989: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2990: BEGIN
2991: x_okl_txd_assets_tl_rec := p_okl_txd_assets_tl_rec;
2992: x_okl_txd_assets_tl_rec.LANGUAGE := USERENV('LANG');
2993: x_okl_txd_assets_tl_rec.SOURCE_LANG := USERENV('LANG');
2994: RETURN(l_return_status);
2995: END Set_Attributes;
2996: BEGIN
2997: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3008: p_okl_txd_assets_tl_rec, -- IN

3004: RAISE OKC_API.G_EXCEPTION_ERROR;
3005: END IF;
3006: --- Setting item attributes
3007: l_return_status := Set_Attributes(
3008: p_okl_txd_assets_tl_rec, -- IN
3009: l_okl_txd_assets_tl_rec); -- OUT
3010: --- If any errors happen abort API
3011: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3012: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3009: l_okl_txd_assets_tl_rec); -- OUT

3005: END IF;
3006: --- Setting item attributes
3007: l_return_status := Set_Attributes(
3008: p_okl_txd_assets_tl_rec, -- IN
3009: l_okl_txd_assets_tl_rec); -- OUT
3010: --- If any errors happen abort API
3011: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3012: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3013: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 3016: l_return_status := populate_new_record(l_okl_txd_assets_tl_rec, l_def_okl_txd_assets_tl_rec);

3012: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3013: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3014: RAISE OKC_API.G_EXCEPTION_ERROR;
3015: END IF;
3016: l_return_status := populate_new_record(l_okl_txd_assets_tl_rec, l_def_okl_txd_assets_tl_rec);
3017: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3018: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3019: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3020: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 3022: UPDATE OKL_TXD_ASSETS_TL

3018: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3019: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3020: RAISE OKC_API.G_EXCEPTION_ERROR;
3021: END IF;
3022: UPDATE OKL_TXD_ASSETS_TL
3023: SET DESCRIPTION = l_def_okl_txd_assets_tl_rec.description,
3024: --Bug# 3641933 :
3025: SOURCE_LANG = l_def_okl_txd_assets_tl_rec.source_lang,
3026: CREATED_BY = l_def_okl_txd_assets_tl_rec.created_by,

Line 3023: SET DESCRIPTION = l_def_okl_txd_assets_tl_rec.description,

3019: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3020: RAISE OKC_API.G_EXCEPTION_ERROR;
3021: END IF;
3022: UPDATE OKL_TXD_ASSETS_TL
3023: SET DESCRIPTION = l_def_okl_txd_assets_tl_rec.description,
3024: --Bug# 3641933 :
3025: SOURCE_LANG = l_def_okl_txd_assets_tl_rec.source_lang,
3026: CREATED_BY = l_def_okl_txd_assets_tl_rec.created_by,
3027: CREATION_DATE = l_def_okl_txd_assets_tl_rec.creation_date,

Line 3025: SOURCE_LANG = l_def_okl_txd_assets_tl_rec.source_lang,

3021: END IF;
3022: UPDATE OKL_TXD_ASSETS_TL
3023: SET DESCRIPTION = l_def_okl_txd_assets_tl_rec.description,
3024: --Bug# 3641933 :
3025: SOURCE_LANG = l_def_okl_txd_assets_tl_rec.source_lang,
3026: CREATED_BY = l_def_okl_txd_assets_tl_rec.created_by,
3027: CREATION_DATE = l_def_okl_txd_assets_tl_rec.creation_date,
3028: LAST_UPDATED_BY = l_def_okl_txd_assets_tl_rec.last_updated_by,
3029: LAST_UPDATE_DATE = l_def_okl_txd_assets_tl_rec.last_update_date,

Line 3026: CREATED_BY = l_def_okl_txd_assets_tl_rec.created_by,

3022: UPDATE OKL_TXD_ASSETS_TL
3023: SET DESCRIPTION = l_def_okl_txd_assets_tl_rec.description,
3024: --Bug# 3641933 :
3025: SOURCE_LANG = l_def_okl_txd_assets_tl_rec.source_lang,
3026: CREATED_BY = l_def_okl_txd_assets_tl_rec.created_by,
3027: CREATION_DATE = l_def_okl_txd_assets_tl_rec.creation_date,
3028: LAST_UPDATED_BY = l_def_okl_txd_assets_tl_rec.last_updated_by,
3029: LAST_UPDATE_DATE = l_def_okl_txd_assets_tl_rec.last_update_date,
3030: LAST_UPDATE_LOGIN = l_def_okl_txd_assets_tl_rec.last_update_login

Line 3027: CREATION_DATE = l_def_okl_txd_assets_tl_rec.creation_date,

3023: SET DESCRIPTION = l_def_okl_txd_assets_tl_rec.description,
3024: --Bug# 3641933 :
3025: SOURCE_LANG = l_def_okl_txd_assets_tl_rec.source_lang,
3026: CREATED_BY = l_def_okl_txd_assets_tl_rec.created_by,
3027: CREATION_DATE = l_def_okl_txd_assets_tl_rec.creation_date,
3028: LAST_UPDATED_BY = l_def_okl_txd_assets_tl_rec.last_updated_by,
3029: LAST_UPDATE_DATE = l_def_okl_txd_assets_tl_rec.last_update_date,
3030: LAST_UPDATE_LOGIN = l_def_okl_txd_assets_tl_rec.last_update_login
3031: WHERE ID = l_def_okl_txd_assets_tl_rec.id

Line 3028: LAST_UPDATED_BY = l_def_okl_txd_assets_tl_rec.last_updated_by,

3024: --Bug# 3641933 :
3025: SOURCE_LANG = l_def_okl_txd_assets_tl_rec.source_lang,
3026: CREATED_BY = l_def_okl_txd_assets_tl_rec.created_by,
3027: CREATION_DATE = l_def_okl_txd_assets_tl_rec.creation_date,
3028: LAST_UPDATED_BY = l_def_okl_txd_assets_tl_rec.last_updated_by,
3029: LAST_UPDATE_DATE = l_def_okl_txd_assets_tl_rec.last_update_date,
3030: LAST_UPDATE_LOGIN = l_def_okl_txd_assets_tl_rec.last_update_login
3031: WHERE ID = l_def_okl_txd_assets_tl_rec.id
3032: --Bug# 3641933 :

Line 3029: LAST_UPDATE_DATE = l_def_okl_txd_assets_tl_rec.last_update_date,

3025: SOURCE_LANG = l_def_okl_txd_assets_tl_rec.source_lang,
3026: CREATED_BY = l_def_okl_txd_assets_tl_rec.created_by,
3027: CREATION_DATE = l_def_okl_txd_assets_tl_rec.creation_date,
3028: LAST_UPDATED_BY = l_def_okl_txd_assets_tl_rec.last_updated_by,
3029: LAST_UPDATE_DATE = l_def_okl_txd_assets_tl_rec.last_update_date,
3030: LAST_UPDATE_LOGIN = l_def_okl_txd_assets_tl_rec.last_update_login
3031: WHERE ID = l_def_okl_txd_assets_tl_rec.id
3032: --Bug# 3641933 :
3033: AND USERENV('LANG') in (SOURCE_LANG,LANGUAGE);

Line 3030: LAST_UPDATE_LOGIN = l_def_okl_txd_assets_tl_rec.last_update_login

3026: CREATED_BY = l_def_okl_txd_assets_tl_rec.created_by,
3027: CREATION_DATE = l_def_okl_txd_assets_tl_rec.creation_date,
3028: LAST_UPDATED_BY = l_def_okl_txd_assets_tl_rec.last_updated_by,
3029: LAST_UPDATE_DATE = l_def_okl_txd_assets_tl_rec.last_update_date,
3030: LAST_UPDATE_LOGIN = l_def_okl_txd_assets_tl_rec.last_update_login
3031: WHERE ID = l_def_okl_txd_assets_tl_rec.id
3032: --Bug# 3641933 :
3033: AND USERENV('LANG') in (SOURCE_LANG,LANGUAGE);
3034: --AND SOURCE_LANG = USERENV('LANG');

Line 3031: WHERE ID = l_def_okl_txd_assets_tl_rec.id

3027: CREATION_DATE = l_def_okl_txd_assets_tl_rec.creation_date,
3028: LAST_UPDATED_BY = l_def_okl_txd_assets_tl_rec.last_updated_by,
3029: LAST_UPDATE_DATE = l_def_okl_txd_assets_tl_rec.last_update_date,
3030: LAST_UPDATE_LOGIN = l_def_okl_txd_assets_tl_rec.last_update_login
3031: WHERE ID = l_def_okl_txd_assets_tl_rec.id
3032: --Bug# 3641933 :
3033: AND USERENV('LANG') in (SOURCE_LANG,LANGUAGE);
3034: --AND SOURCE_LANG = USERENV('LANG');
3035:

Line 3036: UPDATE OKL_TXD_ASSETS_TL

3032: --Bug# 3641933 :
3033: AND USERENV('LANG') in (SOURCE_LANG,LANGUAGE);
3034: --AND SOURCE_LANG = USERENV('LANG');
3035:
3036: UPDATE OKL_TXD_ASSETS_TL
3037: SET SFWT_FLAG = 'Y'
3038: WHERE ID = l_def_okl_txd_assets_tl_rec.id
3039: AND SOURCE_LANG <> USERENV('LANG');
3040:

Line 3038: WHERE ID = l_def_okl_txd_assets_tl_rec.id

3034: --AND SOURCE_LANG = USERENV('LANG');
3035:
3036: UPDATE OKL_TXD_ASSETS_TL
3037: SET SFWT_FLAG = 'Y'
3038: WHERE ID = l_def_okl_txd_assets_tl_rec.id
3039: AND SOURCE_LANG <> USERENV('LANG');
3040:
3041: x_okl_txd_assets_tl_rec := l_def_okl_txd_assets_tl_rec;
3042: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 3041: x_okl_txd_assets_tl_rec := l_def_okl_txd_assets_tl_rec;

3037: SET SFWT_FLAG = 'Y'
3038: WHERE ID = l_def_okl_txd_assets_tl_rec.id
3039: AND SOURCE_LANG <> USERENV('LANG');
3040:
3041: x_okl_txd_assets_tl_rec := l_def_okl_txd_assets_tl_rec;
3042: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3043: EXCEPTION
3044: WHEN OKC_API.G_EXCEPTION_ERROR THEN
3045: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 3092: l_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;

3088: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
3089: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3090: l_asdv_rec asdv_rec_type := p_asdv_rec;
3091: l_def_asdv_rec asdv_rec_type;
3092: l_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;
3093: lx_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;
3094: l_asd_rec asd_rec_type;
3095: lx_asd_rec asd_rec_type;
3096: lx_temp_asdv_rec asdv_rec_type;

Line 3093: lx_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;

3089: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3090: l_asdv_rec asdv_rec_type := p_asdv_rec;
3091: l_def_asdv_rec asdv_rec_type;
3092: l_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;
3093: lx_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;
3094: l_asd_rec asd_rec_type;
3095: lx_asd_rec asd_rec_type;
3096: lx_temp_asdv_rec asdv_rec_type;
3097: -------------------------------

Line 3405: migrate(l_def_asdv_rec, l_okl_txd_assets_tl_rec);

3401:
3402: --------------------------------------
3403: -- Move VIEW record to "Child" records
3404: --------------------------------------
3405: migrate(l_def_asdv_rec, l_okl_txd_assets_tl_rec);
3406: migrate(l_def_asdv_rec, l_asd_rec);
3407: --------------------------------------------
3408: -- Call the UPDATE_ROW for each child record
3409: --------------------------------------------

Line 3415: l_okl_txd_assets_tl_rec,

3411: p_init_msg_list,
3412: x_return_status,
3413: x_msg_count,
3414: x_msg_data,
3415: l_okl_txd_assets_tl_rec,
3416: lx_okl_txd_assets_tl_rec
3417: );
3418: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3419: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3416: lx_okl_txd_assets_tl_rec

3412: x_return_status,
3413: x_msg_count,
3414: x_msg_data,
3415: l_okl_txd_assets_tl_rec,
3416: lx_okl_txd_assets_tl_rec
3417: );
3418: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3419: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3420: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 3423: migrate(lx_okl_txd_assets_tl_rec, l_def_asdv_rec);

3419: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3420: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3421: RAISE OKC_API.G_EXCEPTION_ERROR;
3422: END IF;
3423: migrate(lx_okl_txd_assets_tl_rec, l_def_asdv_rec);
3424: --------------------------------------------
3425: -- Call the UPDATE_ROW for each child record
3426: --------------------------------------------
3427: update_row(

Line 3607: -- delete_row for:OKL_TXD_ASSETS_TL --

3603: '_PVT'
3604: );
3605: END delete_row;
3606: --------------------------------------
3607: -- delete_row for:OKL_TXD_ASSETS_TL --
3608: --------------------------------------
3609: PROCEDURE delete_row(
3610: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3611: x_return_status OUT NOCOPY VARCHAR2,

Line 3614: p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type) IS

3610: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3611: x_return_status OUT NOCOPY VARCHAR2,
3612: x_msg_count OUT NOCOPY NUMBER,
3613: x_msg_data OUT NOCOPY VARCHAR2,
3614: p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type) IS
3615:
3616: l_api_version CONSTANT NUMBER := 1;
3617: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3618: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 3619: l_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type:= p_okl_txd_assets_tl_rec;

3615:
3616: l_api_version CONSTANT NUMBER := 1;
3617: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3618: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3619: l_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type:= p_okl_txd_assets_tl_rec;
3620: l_row_notfound BOOLEAN := TRUE;
3621: ------------------------------------------
3622: -- Set_Attributes for:OKL_TXD_ASSETS_TL --
3623: ------------------------------------------

Line 3622: -- Set_Attributes for:OKL_TXD_ASSETS_TL --

3618: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3619: l_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type:= p_okl_txd_assets_tl_rec;
3620: l_row_notfound BOOLEAN := TRUE;
3621: ------------------------------------------
3622: -- Set_Attributes for:OKL_TXD_ASSETS_TL --
3623: ------------------------------------------
3624: FUNCTION Set_Attributes (
3625: p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type,
3626: x_okl_txd_assets_tl_rec OUT NOCOPY okl_txd_assets_tl_rec_type

Line 3625: p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type,

3621: ------------------------------------------
3622: -- Set_Attributes for:OKL_TXD_ASSETS_TL --
3623: ------------------------------------------
3624: FUNCTION Set_Attributes (
3625: p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type,
3626: x_okl_txd_assets_tl_rec OUT NOCOPY okl_txd_assets_tl_rec_type
3627: ) RETURN VARCHAR2 IS
3628: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3629: BEGIN

Line 3626: x_okl_txd_assets_tl_rec OUT NOCOPY okl_txd_assets_tl_rec_type

3622: -- Set_Attributes for:OKL_TXD_ASSETS_TL --
3623: ------------------------------------------
3624: FUNCTION Set_Attributes (
3625: p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type,
3626: x_okl_txd_assets_tl_rec OUT NOCOPY okl_txd_assets_tl_rec_type
3627: ) RETURN VARCHAR2 IS
3628: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3629: BEGIN
3630: x_okl_txd_assets_tl_rec := p_okl_txd_assets_tl_rec;

Line 3630: x_okl_txd_assets_tl_rec := p_okl_txd_assets_tl_rec;

3626: x_okl_txd_assets_tl_rec OUT NOCOPY okl_txd_assets_tl_rec_type
3627: ) RETURN VARCHAR2 IS
3628: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3629: BEGIN
3630: x_okl_txd_assets_tl_rec := p_okl_txd_assets_tl_rec;
3631: x_okl_txd_assets_tl_rec.LANGUAGE := USERENV('LANG');
3632: RETURN(l_return_status);
3633: END Set_Attributes;
3634: BEGIN

Line 3631: x_okl_txd_assets_tl_rec.LANGUAGE := USERENV('LANG');

3627: ) RETURN VARCHAR2 IS
3628: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3629: BEGIN
3630: x_okl_txd_assets_tl_rec := p_okl_txd_assets_tl_rec;
3631: x_okl_txd_assets_tl_rec.LANGUAGE := USERENV('LANG');
3632: RETURN(l_return_status);
3633: END Set_Attributes;
3634: BEGIN
3635: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3646: p_okl_txd_assets_tl_rec, -- IN

3642: RAISE OKC_API.G_EXCEPTION_ERROR;
3643: END IF;
3644: --- Setting item attributes
3645: l_return_status := Set_Attributes(
3646: p_okl_txd_assets_tl_rec, -- IN
3647: l_okl_txd_assets_tl_rec); -- OUT
3648: --- If any errors happen abort API
3649: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3650: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3647: l_okl_txd_assets_tl_rec); -- OUT

3643: END IF;
3644: --- Setting item attributes
3645: l_return_status := Set_Attributes(
3646: p_okl_txd_assets_tl_rec, -- IN
3647: l_okl_txd_assets_tl_rec); -- OUT
3648: --- If any errors happen abort API
3649: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3650: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3651: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 3654: DELETE FROM OKL_TXD_ASSETS_TL

3650: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3651: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3652: RAISE OKC_API.G_EXCEPTION_ERROR;
3653: END IF;
3654: DELETE FROM OKL_TXD_ASSETS_TL
3655: WHERE ID = l_okl_txd_assets_tl_rec.id;
3656:
3657: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3658: EXCEPTION

Line 3655: WHERE ID = l_okl_txd_assets_tl_rec.id;

3651: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3652: RAISE OKC_API.G_EXCEPTION_ERROR;
3653: END IF;
3654: DELETE FROM OKL_TXD_ASSETS_TL
3655: WHERE ID = l_okl_txd_assets_tl_rec.id;
3656:
3657: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3658: EXCEPTION
3659: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 3705: l_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;

3701: l_api_version CONSTANT NUMBER := 1;
3702: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
3703: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3704: l_asdv_rec asdv_rec_type := p_asdv_rec;
3705: l_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;
3706: l_asd_rec asd_rec_type;
3707: BEGIN
3708: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
3709: G_PKG_NAME,

Line 3723: migrate(l_asdv_rec, l_okl_txd_assets_tl_rec);

3719: END IF;
3720: --------------------------------------
3721: -- Move VIEW record to "Child" records
3722: --------------------------------------
3723: migrate(l_asdv_rec, l_okl_txd_assets_tl_rec);
3724: migrate(l_asdv_rec, l_asd_rec);
3725: --------------------------------------------
3726: -- Call the DELETE_ROW for each child record
3727: --------------------------------------------

Line 3733: l_okl_txd_assets_tl_rec

3729: p_init_msg_list,
3730: x_return_status,
3731: x_msg_count,
3732: x_msg_data,
3733: l_okl_txd_assets_tl_rec
3734: );
3735: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3736: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3737: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN