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 783: DELETE FROM OKL_TXD_ASSETS_TL T

779: -- PROCEDURE add_language
780: ---------------------------------------------------------------------------
781: PROCEDURE add_language IS
782: BEGIN
783: DELETE FROM OKL_TXD_ASSETS_TL T
784: WHERE NOT EXISTS (
785: SELECT NULL
786: FROM OKL_TXD_ASSETS_B B --fixed bug 3321017 by kmotepal
787: WHERE B.ID = T.ID

Line 790: UPDATE OKL_TXD_ASSETS_TL T SET (

786: FROM OKL_TXD_ASSETS_B B --fixed bug 3321017 by kmotepal
787: WHERE B.ID = T.ID
788: );
789:
790: UPDATE OKL_TXD_ASSETS_TL T SET (
791: DESCRIPTION) = (SELECT
792: B.DESCRIPTION
793: FROM OKL_TXD_ASSETS_TL B
794: WHERE B.ID = T.ID

Line 793: FROM OKL_TXD_ASSETS_TL B

789:
790: UPDATE OKL_TXD_ASSETS_TL T SET (
791: DESCRIPTION) = (SELECT
792: B.DESCRIPTION
793: FROM OKL_TXD_ASSETS_TL B
794: WHERE B.ID = T.ID
795: AND B.LANGUAGE = T.SOURCE_LANG)
796: WHERE (
797: T.ID,

Line 802: FROM OKL_TXD_ASSETS_TL SUBB, OKL_TXD_ASSETS_TL SUBT

798: T.LANGUAGE)
799: IN (SELECT
800: SUBT.ID,
801: SUBT.LANGUAGE
802: FROM OKL_TXD_ASSETS_TL SUBB, OKL_TXD_ASSETS_TL SUBT
803: WHERE SUBB.ID = SUBT.ID
804: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
805: AND (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
806: OR (SUBB.DESCRIPTION IS NULL AND SUBT.DESCRIPTION IS NOT NULL)

Line 810: INSERT INTO OKL_TXD_ASSETS_TL (

806: OR (SUBB.DESCRIPTION IS NULL AND SUBT.DESCRIPTION IS NOT NULL)
807: OR (SUBB.DESCRIPTION IS NOT NULL AND SUBT.DESCRIPTION IS NULL)
808: ));
809:
810: INSERT INTO OKL_TXD_ASSETS_TL (
811: ID,
812: LANGUAGE,
813: SOURCE_LANG,
814: SFWT_FLAG,

Line 832: FROM OKL_TXD_ASSETS_TL B, FND_LANGUAGES L

828: B.CREATION_DATE,
829: B.LAST_UPDATED_BY,
830: B.LAST_UPDATE_DATE,
831: B.LAST_UPDATE_LOGIN
832: FROM OKL_TXD_ASSETS_TL B, FND_LANGUAGES L
833: WHERE L.INSTALLED_FLAG IN ('I', 'B')
834: AND B.LANGUAGE = USERENV('LANG')
835: AND NOT EXISTS(
836: SELECT NULL

Line 837: FROM OKL_TXD_ASSETS_TL T

833: WHERE L.INSTALLED_FLAG IN ('I', 'B')
834: AND B.LANGUAGE = USERENV('LANG')
835: AND NOT EXISTS(
836: SELECT NULL
837: FROM OKL_TXD_ASSETS_TL T
838: WHERE T.ID = B.ID
839: AND T.LANGUAGE = L.LANGUAGE_CODE
840: );
841:

Line 963: -- FUNCTION get_rec for: OKL_TXD_ASSETS_TL

959: BEGIN
960: RETURN(get_rec(p_asd_rec, l_row_notfound));
961: END get_rec;
962: ---------------------------------------------------------------------------
963: -- FUNCTION get_rec for: OKL_TXD_ASSETS_TL
964: ---------------------------------------------------------------------------
965: FUNCTION get_rec (
966: p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type,
967: x_no_data_found OUT NOCOPY BOOLEAN

Line 966: p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type,

962: ---------------------------------------------------------------------------
963: -- FUNCTION get_rec for: OKL_TXD_ASSETS_TL
964: ---------------------------------------------------------------------------
965: FUNCTION get_rec (
966: p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type,
967: x_no_data_found OUT NOCOPY BOOLEAN
968: ) RETURN okl_txd_assets_tl_rec_type IS
969: CURSOR okl_txd_asset_tl_pk_csr (p_id IN NUMBER,
970: p_language IN VARCHAR2) IS

Line 968: ) RETURN okl_txd_assets_tl_rec_type IS

964: ---------------------------------------------------------------------------
965: FUNCTION get_rec (
966: p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type,
967: x_no_data_found OUT NOCOPY BOOLEAN
968: ) RETURN okl_txd_assets_tl_rec_type IS
969: CURSOR okl_txd_asset_tl_pk_csr (p_id IN NUMBER,
970: p_language IN VARCHAR2) IS
971: SELECT
972: ID,

Line 982: FROM okl_txd_assets_tl

978: CREATION_DATE,
979: LAST_UPDATED_BY,
980: LAST_UPDATE_DATE,
981: LAST_UPDATE_LOGIN
982: FROM okl_txd_assets_tl
983: WHERE okl_txd_assets_tl.id = p_id
984: AND okl_txd_assets_tl.language = p_language;
985: l_okl_txd_asset_tl_pk okl_txd_asset_tl_pk_csr%ROWTYPE;
986: l_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;

Line 983: WHERE okl_txd_assets_tl.id = p_id

979: LAST_UPDATED_BY,
980: LAST_UPDATE_DATE,
981: LAST_UPDATE_LOGIN
982: FROM okl_txd_assets_tl
983: WHERE okl_txd_assets_tl.id = p_id
984: AND okl_txd_assets_tl.language = p_language;
985: l_okl_txd_asset_tl_pk okl_txd_asset_tl_pk_csr%ROWTYPE;
986: l_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;
987: BEGIN

Line 984: AND okl_txd_assets_tl.language = p_language;

980: LAST_UPDATE_DATE,
981: LAST_UPDATE_LOGIN
982: FROM okl_txd_assets_tl
983: WHERE okl_txd_assets_tl.id = p_id
984: AND okl_txd_assets_tl.language = p_language;
985: l_okl_txd_asset_tl_pk okl_txd_asset_tl_pk_csr%ROWTYPE;
986: l_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;
987: BEGIN
988: x_no_data_found := TRUE;

Line 986: l_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;

982: FROM okl_txd_assets_tl
983: WHERE okl_txd_assets_tl.id = p_id
984: AND okl_txd_assets_tl.language = p_language;
985: l_okl_txd_asset_tl_pk okl_txd_asset_tl_pk_csr%ROWTYPE;
986: l_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;
987: BEGIN
988: x_no_data_found := TRUE;
989: -- Get current database values
990: OPEN okl_txd_asset_tl_pk_csr (p_okl_txd_assets_tl_rec.id,

Line 990: OPEN okl_txd_asset_tl_pk_csr (p_okl_txd_assets_tl_rec.id,

986: l_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;
987: BEGIN
988: x_no_data_found := TRUE;
989: -- Get current database values
990: OPEN okl_txd_asset_tl_pk_csr (p_okl_txd_assets_tl_rec.id,
991: p_okl_txd_assets_tl_rec.language);
992: FETCH okl_txd_asset_tl_pk_csr INTO
993: l_okl_txd_assets_tl_rec.ID,
994: l_okl_txd_assets_tl_rec.LANGUAGE,

Line 991: p_okl_txd_assets_tl_rec.language);

987: BEGIN
988: x_no_data_found := TRUE;
989: -- Get current database values
990: OPEN okl_txd_asset_tl_pk_csr (p_okl_txd_assets_tl_rec.id,
991: p_okl_txd_assets_tl_rec.language);
992: FETCH okl_txd_asset_tl_pk_csr INTO
993: l_okl_txd_assets_tl_rec.ID,
994: l_okl_txd_assets_tl_rec.LANGUAGE,
995: l_okl_txd_assets_tl_rec.SOURCE_LANG,

Line 993: l_okl_txd_assets_tl_rec.ID,

989: -- Get current database values
990: OPEN okl_txd_asset_tl_pk_csr (p_okl_txd_assets_tl_rec.id,
991: p_okl_txd_assets_tl_rec.language);
992: FETCH okl_txd_asset_tl_pk_csr INTO
993: l_okl_txd_assets_tl_rec.ID,
994: l_okl_txd_assets_tl_rec.LANGUAGE,
995: l_okl_txd_assets_tl_rec.SOURCE_LANG,
996: l_okl_txd_assets_tl_rec.SFWT_FLAG,
997: l_okl_txd_assets_tl_rec.DESCRIPTION,

Line 994: l_okl_txd_assets_tl_rec.LANGUAGE,

990: OPEN okl_txd_asset_tl_pk_csr (p_okl_txd_assets_tl_rec.id,
991: p_okl_txd_assets_tl_rec.language);
992: FETCH okl_txd_asset_tl_pk_csr INTO
993: l_okl_txd_assets_tl_rec.ID,
994: l_okl_txd_assets_tl_rec.LANGUAGE,
995: l_okl_txd_assets_tl_rec.SOURCE_LANG,
996: l_okl_txd_assets_tl_rec.SFWT_FLAG,
997: l_okl_txd_assets_tl_rec.DESCRIPTION,
998: l_okl_txd_assets_tl_rec.CREATED_BY,

Line 995: l_okl_txd_assets_tl_rec.SOURCE_LANG,

991: p_okl_txd_assets_tl_rec.language);
992: FETCH okl_txd_asset_tl_pk_csr INTO
993: l_okl_txd_assets_tl_rec.ID,
994: l_okl_txd_assets_tl_rec.LANGUAGE,
995: l_okl_txd_assets_tl_rec.SOURCE_LANG,
996: l_okl_txd_assets_tl_rec.SFWT_FLAG,
997: l_okl_txd_assets_tl_rec.DESCRIPTION,
998: l_okl_txd_assets_tl_rec.CREATED_BY,
999: l_okl_txd_assets_tl_rec.CREATION_DATE,

Line 996: l_okl_txd_assets_tl_rec.SFWT_FLAG,

992: FETCH okl_txd_asset_tl_pk_csr INTO
993: l_okl_txd_assets_tl_rec.ID,
994: l_okl_txd_assets_tl_rec.LANGUAGE,
995: l_okl_txd_assets_tl_rec.SOURCE_LANG,
996: l_okl_txd_assets_tl_rec.SFWT_FLAG,
997: l_okl_txd_assets_tl_rec.DESCRIPTION,
998: l_okl_txd_assets_tl_rec.CREATED_BY,
999: l_okl_txd_assets_tl_rec.CREATION_DATE,
1000: l_okl_txd_assets_tl_rec.LAST_UPDATED_BY,

Line 997: l_okl_txd_assets_tl_rec.DESCRIPTION,

993: l_okl_txd_assets_tl_rec.ID,
994: l_okl_txd_assets_tl_rec.LANGUAGE,
995: l_okl_txd_assets_tl_rec.SOURCE_LANG,
996: l_okl_txd_assets_tl_rec.SFWT_FLAG,
997: l_okl_txd_assets_tl_rec.DESCRIPTION,
998: l_okl_txd_assets_tl_rec.CREATED_BY,
999: l_okl_txd_assets_tl_rec.CREATION_DATE,
1000: l_okl_txd_assets_tl_rec.LAST_UPDATED_BY,
1001: l_okl_txd_assets_tl_rec.LAST_UPDATE_DATE,

Line 998: l_okl_txd_assets_tl_rec.CREATED_BY,

994: l_okl_txd_assets_tl_rec.LANGUAGE,
995: l_okl_txd_assets_tl_rec.SOURCE_LANG,
996: l_okl_txd_assets_tl_rec.SFWT_FLAG,
997: l_okl_txd_assets_tl_rec.DESCRIPTION,
998: l_okl_txd_assets_tl_rec.CREATED_BY,
999: l_okl_txd_assets_tl_rec.CREATION_DATE,
1000: l_okl_txd_assets_tl_rec.LAST_UPDATED_BY,
1001: l_okl_txd_assets_tl_rec.LAST_UPDATE_DATE,
1002: l_okl_txd_assets_tl_rec.LAST_UPDATE_LOGIN;

Line 999: l_okl_txd_assets_tl_rec.CREATION_DATE,

995: l_okl_txd_assets_tl_rec.SOURCE_LANG,
996: l_okl_txd_assets_tl_rec.SFWT_FLAG,
997: l_okl_txd_assets_tl_rec.DESCRIPTION,
998: l_okl_txd_assets_tl_rec.CREATED_BY,
999: l_okl_txd_assets_tl_rec.CREATION_DATE,
1000: l_okl_txd_assets_tl_rec.LAST_UPDATED_BY,
1001: l_okl_txd_assets_tl_rec.LAST_UPDATE_DATE,
1002: l_okl_txd_assets_tl_rec.LAST_UPDATE_LOGIN;
1003: x_no_data_found := okl_txd_asset_tl_pk_csr%NOTFOUND;

Line 1000: l_okl_txd_assets_tl_rec.LAST_UPDATED_BY,

996: l_okl_txd_assets_tl_rec.SFWT_FLAG,
997: l_okl_txd_assets_tl_rec.DESCRIPTION,
998: l_okl_txd_assets_tl_rec.CREATED_BY,
999: l_okl_txd_assets_tl_rec.CREATION_DATE,
1000: l_okl_txd_assets_tl_rec.LAST_UPDATED_BY,
1001: l_okl_txd_assets_tl_rec.LAST_UPDATE_DATE,
1002: l_okl_txd_assets_tl_rec.LAST_UPDATE_LOGIN;
1003: x_no_data_found := okl_txd_asset_tl_pk_csr%NOTFOUND;
1004: CLOSE okl_txd_asset_tl_pk_csr;

Line 1001: l_okl_txd_assets_tl_rec.LAST_UPDATE_DATE,

997: l_okl_txd_assets_tl_rec.DESCRIPTION,
998: l_okl_txd_assets_tl_rec.CREATED_BY,
999: l_okl_txd_assets_tl_rec.CREATION_DATE,
1000: l_okl_txd_assets_tl_rec.LAST_UPDATED_BY,
1001: l_okl_txd_assets_tl_rec.LAST_UPDATE_DATE,
1002: l_okl_txd_assets_tl_rec.LAST_UPDATE_LOGIN;
1003: x_no_data_found := okl_txd_asset_tl_pk_csr%NOTFOUND;
1004: CLOSE okl_txd_asset_tl_pk_csr;
1005: RETURN(l_okl_txd_assets_tl_rec);

Line 1002: l_okl_txd_assets_tl_rec.LAST_UPDATE_LOGIN;

998: l_okl_txd_assets_tl_rec.CREATED_BY,
999: l_okl_txd_assets_tl_rec.CREATION_DATE,
1000: l_okl_txd_assets_tl_rec.LAST_UPDATED_BY,
1001: l_okl_txd_assets_tl_rec.LAST_UPDATE_DATE,
1002: l_okl_txd_assets_tl_rec.LAST_UPDATE_LOGIN;
1003: x_no_data_found := okl_txd_asset_tl_pk_csr%NOTFOUND;
1004: CLOSE okl_txd_asset_tl_pk_csr;
1005: RETURN(l_okl_txd_assets_tl_rec);
1006: END get_rec;

Line 1005: RETURN(l_okl_txd_assets_tl_rec);

1001: l_okl_txd_assets_tl_rec.LAST_UPDATE_DATE,
1002: l_okl_txd_assets_tl_rec.LAST_UPDATE_LOGIN;
1003: x_no_data_found := okl_txd_asset_tl_pk_csr%NOTFOUND;
1004: CLOSE okl_txd_asset_tl_pk_csr;
1005: RETURN(l_okl_txd_assets_tl_rec);
1006: END get_rec;
1007:
1008: FUNCTION get_rec (
1009: p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type

Line 1009: p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type

1005: RETURN(l_okl_txd_assets_tl_rec);
1006: END get_rec;
1007:
1008: FUNCTION get_rec (
1009: p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type
1010: ) RETURN okl_txd_assets_tl_rec_type IS
1011: l_row_notfound BOOLEAN := TRUE;
1012: BEGIN
1013: RETURN(get_rec(p_okl_txd_assets_tl_rec, l_row_notfound));

Line 1010: ) RETURN okl_txd_assets_tl_rec_type IS

1006: END get_rec;
1007:
1008: FUNCTION get_rec (
1009: p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type
1010: ) RETURN okl_txd_assets_tl_rec_type IS
1011: l_row_notfound BOOLEAN := TRUE;
1012: BEGIN
1013: RETURN(get_rec(p_okl_txd_assets_tl_rec, l_row_notfound));
1014: END get_rec;

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

1009: p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type
1010: ) RETURN okl_txd_assets_tl_rec_type IS
1011: l_row_notfound BOOLEAN := TRUE;
1012: BEGIN
1013: RETURN(get_rec(p_okl_txd_assets_tl_rec, l_row_notfound));
1014: END get_rec;
1015: ---------------------------------------------------------------------------
1016: -- FUNCTION get_rec for: OKL_TXD_ASSETS_V
1017: ---------------------------------------------------------------------------

Line 1489: p_to IN OUT NOCOPY okl_txd_assets_tl_rec_type

1485: -- Multi-Currency Change
1486: END migrate;
1487: PROCEDURE migrate (
1488: p_from IN asdv_rec_type,
1489: p_to IN OUT NOCOPY okl_txd_assets_tl_rec_type
1490: ) IS
1491: BEGIN
1492: p_to.id := p_from.id;
1493: p_to.sfwt_flag := p_from.sfwt_flag;

Line 1502: p_from IN okl_txd_assets_tl_rec_type,

1498: p_to.last_update_date := p_from.last_update_date;
1499: p_to.last_update_login := p_from.last_update_login;
1500: END migrate;
1501: PROCEDURE migrate (
1502: p_from IN okl_txd_assets_tl_rec_type,
1503: p_to IN OUT NOCOPY asdv_rec_type
1504: ) IS
1505: BEGIN
1506: p_to.id := p_from.id;

Line 1535: l_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;

1531: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
1532: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1533: l_asdv_rec asdv_rec_type := p_asdv_rec;
1534: l_asd_rec asd_rec_type;
1535: l_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;
1536: BEGIN
1537: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1538: G_PKG_NAME,
1539: p_init_msg_list,

Line 1843: -- insert_row for:OKL_TXD_ASSETS_TL --

1839: '_PVT'
1840: );
1841: END insert_row;
1842: --------------------------------------
1843: -- insert_row for:OKL_TXD_ASSETS_TL --
1844: --------------------------------------
1845: PROCEDURE insert_row(
1846: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1847: x_return_status OUT NOCOPY VARCHAR2,

Line 1850: p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type,

1846: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1847: x_return_status OUT NOCOPY VARCHAR2,
1848: x_msg_count OUT NOCOPY NUMBER,
1849: x_msg_data OUT NOCOPY VARCHAR2,
1850: p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type,
1851: x_okl_txd_assets_tl_rec OUT NOCOPY okl_txd_assets_tl_rec_type) IS
1852:
1853: l_api_version CONSTANT NUMBER := 1;
1854: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';

Line 1851: x_okl_txd_assets_tl_rec OUT NOCOPY okl_txd_assets_tl_rec_type) IS

1847: x_return_status OUT NOCOPY VARCHAR2,
1848: x_msg_count OUT NOCOPY NUMBER,
1849: x_msg_data OUT NOCOPY VARCHAR2,
1850: p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type,
1851: x_okl_txd_assets_tl_rec OUT NOCOPY okl_txd_assets_tl_rec_type) IS
1852:
1853: l_api_version CONSTANT NUMBER := 1;
1854: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1855: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1856: l_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type := p_okl_txd_assets_tl_rec;

1852:
1853: l_api_version CONSTANT NUMBER := 1;
1854: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1855: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1856: l_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type := p_okl_txd_assets_tl_rec;
1857: l_def_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;
1858: CURSOR get_languages IS
1859: SELECT *
1860: FROM FND_LANGUAGES

Line 1857: l_def_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;

1853: l_api_version CONSTANT NUMBER := 1;
1854: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1855: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1856: l_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type := p_okl_txd_assets_tl_rec;
1857: l_def_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;
1858: CURSOR get_languages IS
1859: SELECT *
1860: FROM FND_LANGUAGES
1861: WHERE INSTALLED_FLAG IN ('I', 'B');

Line 1863: -- Set_Attributes for:OKL_TXD_ASSETS_TL --

1859: SELECT *
1860: FROM FND_LANGUAGES
1861: WHERE INSTALLED_FLAG IN ('I', 'B');
1862: ------------------------------------------
1863: -- Set_Attributes for:OKL_TXD_ASSETS_TL --
1864: ------------------------------------------
1865: FUNCTION Set_Attributes (
1866: p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type,
1867: x_okl_txd_assets_tl_rec OUT NOCOPY okl_txd_assets_tl_rec_type

Line 1866: p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type,

1862: ------------------------------------------
1863: -- Set_Attributes for:OKL_TXD_ASSETS_TL --
1864: ------------------------------------------
1865: FUNCTION Set_Attributes (
1866: p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type,
1867: x_okl_txd_assets_tl_rec OUT NOCOPY okl_txd_assets_tl_rec_type
1868: ) RETURN VARCHAR2 IS
1869: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1870: BEGIN

Line 1867: x_okl_txd_assets_tl_rec OUT NOCOPY okl_txd_assets_tl_rec_type

1863: -- Set_Attributes for:OKL_TXD_ASSETS_TL --
1864: ------------------------------------------
1865: FUNCTION Set_Attributes (
1866: p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type,
1867: x_okl_txd_assets_tl_rec OUT NOCOPY okl_txd_assets_tl_rec_type
1868: ) RETURN VARCHAR2 IS
1869: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1870: BEGIN
1871: x_okl_txd_assets_tl_rec := p_okl_txd_assets_tl_rec;

Line 1871: x_okl_txd_assets_tl_rec := p_okl_txd_assets_tl_rec;

1867: x_okl_txd_assets_tl_rec OUT NOCOPY okl_txd_assets_tl_rec_type
1868: ) RETURN VARCHAR2 IS
1869: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1870: BEGIN
1871: x_okl_txd_assets_tl_rec := p_okl_txd_assets_tl_rec;
1872: x_okl_txd_assets_tl_rec.LANGUAGE := USERENV('LANG');
1873: x_okl_txd_assets_tl_rec.SOURCE_LANG := USERENV('LANG');
1874: RETURN(l_return_status);
1875: END Set_Attributes;

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

1868: ) RETURN VARCHAR2 IS
1869: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1870: BEGIN
1871: x_okl_txd_assets_tl_rec := p_okl_txd_assets_tl_rec;
1872: x_okl_txd_assets_tl_rec.LANGUAGE := USERENV('LANG');
1873: x_okl_txd_assets_tl_rec.SOURCE_LANG := USERENV('LANG');
1874: RETURN(l_return_status);
1875: END Set_Attributes;
1876: BEGIN

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

1869: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1870: BEGIN
1871: x_okl_txd_assets_tl_rec := p_okl_txd_assets_tl_rec;
1872: x_okl_txd_assets_tl_rec.LANGUAGE := USERENV('LANG');
1873: x_okl_txd_assets_tl_rec.SOURCE_LANG := USERENV('LANG');
1874: RETURN(l_return_status);
1875: END Set_Attributes;
1876: BEGIN
1877: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1888: p_okl_txd_assets_tl_rec, -- IN

1884: RAISE OKC_API.G_EXCEPTION_ERROR;
1885: END IF;
1886: --- Setting item attributes
1887: l_return_status := Set_Attributes(
1888: p_okl_txd_assets_tl_rec, -- IN
1889: l_okl_txd_assets_tl_rec); -- OUT
1890: --- If any errors happen abort API
1891: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1892: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1889: l_okl_txd_assets_tl_rec); -- OUT

1885: END IF;
1886: --- Setting item attributes
1887: l_return_status := Set_Attributes(
1888: p_okl_txd_assets_tl_rec, -- IN
1889: l_okl_txd_assets_tl_rec); -- OUT
1890: --- If any errors happen abort API
1891: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1892: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1893: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

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

1893: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1894: RAISE OKC_API.G_EXCEPTION_ERROR;
1895: END IF;
1896: FOR l_lang_rec IN get_languages LOOP
1897: l_okl_txd_assets_tl_rec.language := l_lang_rec.language_code;
1898: INSERT INTO OKL_TXD_ASSETS_TL(
1899: id,
1900: language,
1901: source_lang,

Line 1898: INSERT INTO OKL_TXD_ASSETS_TL(

1894: RAISE OKC_API.G_EXCEPTION_ERROR;
1895: END IF;
1896: FOR l_lang_rec IN get_languages LOOP
1897: l_okl_txd_assets_tl_rec.language := l_lang_rec.language_code;
1898: INSERT INTO OKL_TXD_ASSETS_TL(
1899: id,
1900: language,
1901: source_lang,
1902: sfwt_flag,

Line 1910: l_okl_txd_assets_tl_rec.id,

1906: last_updated_by,
1907: last_update_date,
1908: last_update_login)
1909: VALUES (
1910: l_okl_txd_assets_tl_rec.id,
1911: l_okl_txd_assets_tl_rec.language,
1912: l_okl_txd_assets_tl_rec.source_lang,
1913: l_okl_txd_assets_tl_rec.sfwt_flag,
1914: l_okl_txd_assets_tl_rec.description,

Line 1911: l_okl_txd_assets_tl_rec.language,

1907: last_update_date,
1908: last_update_login)
1909: VALUES (
1910: l_okl_txd_assets_tl_rec.id,
1911: l_okl_txd_assets_tl_rec.language,
1912: l_okl_txd_assets_tl_rec.source_lang,
1913: l_okl_txd_assets_tl_rec.sfwt_flag,
1914: l_okl_txd_assets_tl_rec.description,
1915: l_okl_txd_assets_tl_rec.created_by,

Line 1912: l_okl_txd_assets_tl_rec.source_lang,

1908: last_update_login)
1909: VALUES (
1910: l_okl_txd_assets_tl_rec.id,
1911: l_okl_txd_assets_tl_rec.language,
1912: l_okl_txd_assets_tl_rec.source_lang,
1913: l_okl_txd_assets_tl_rec.sfwt_flag,
1914: l_okl_txd_assets_tl_rec.description,
1915: l_okl_txd_assets_tl_rec.created_by,
1916: l_okl_txd_assets_tl_rec.creation_date,

Line 1913: l_okl_txd_assets_tl_rec.sfwt_flag,

1909: VALUES (
1910: l_okl_txd_assets_tl_rec.id,
1911: l_okl_txd_assets_tl_rec.language,
1912: l_okl_txd_assets_tl_rec.source_lang,
1913: l_okl_txd_assets_tl_rec.sfwt_flag,
1914: l_okl_txd_assets_tl_rec.description,
1915: l_okl_txd_assets_tl_rec.created_by,
1916: l_okl_txd_assets_tl_rec.creation_date,
1917: l_okl_txd_assets_tl_rec.last_updated_by,

Line 1914: l_okl_txd_assets_tl_rec.description,

1910: l_okl_txd_assets_tl_rec.id,
1911: l_okl_txd_assets_tl_rec.language,
1912: l_okl_txd_assets_tl_rec.source_lang,
1913: l_okl_txd_assets_tl_rec.sfwt_flag,
1914: l_okl_txd_assets_tl_rec.description,
1915: l_okl_txd_assets_tl_rec.created_by,
1916: l_okl_txd_assets_tl_rec.creation_date,
1917: l_okl_txd_assets_tl_rec.last_updated_by,
1918: l_okl_txd_assets_tl_rec.last_update_date,

Line 1915: l_okl_txd_assets_tl_rec.created_by,

1911: l_okl_txd_assets_tl_rec.language,
1912: l_okl_txd_assets_tl_rec.source_lang,
1913: l_okl_txd_assets_tl_rec.sfwt_flag,
1914: l_okl_txd_assets_tl_rec.description,
1915: l_okl_txd_assets_tl_rec.created_by,
1916: l_okl_txd_assets_tl_rec.creation_date,
1917: l_okl_txd_assets_tl_rec.last_updated_by,
1918: l_okl_txd_assets_tl_rec.last_update_date,
1919: l_okl_txd_assets_tl_rec.last_update_login);

Line 1916: l_okl_txd_assets_tl_rec.creation_date,

1912: l_okl_txd_assets_tl_rec.source_lang,
1913: l_okl_txd_assets_tl_rec.sfwt_flag,
1914: l_okl_txd_assets_tl_rec.description,
1915: l_okl_txd_assets_tl_rec.created_by,
1916: l_okl_txd_assets_tl_rec.creation_date,
1917: l_okl_txd_assets_tl_rec.last_updated_by,
1918: l_okl_txd_assets_tl_rec.last_update_date,
1919: l_okl_txd_assets_tl_rec.last_update_login);
1920: END LOOP;

Line 1917: l_okl_txd_assets_tl_rec.last_updated_by,

1913: l_okl_txd_assets_tl_rec.sfwt_flag,
1914: l_okl_txd_assets_tl_rec.description,
1915: l_okl_txd_assets_tl_rec.created_by,
1916: l_okl_txd_assets_tl_rec.creation_date,
1917: l_okl_txd_assets_tl_rec.last_updated_by,
1918: l_okl_txd_assets_tl_rec.last_update_date,
1919: l_okl_txd_assets_tl_rec.last_update_login);
1920: END LOOP;
1921: -- Set OUT values

Line 1918: l_okl_txd_assets_tl_rec.last_update_date,

1914: l_okl_txd_assets_tl_rec.description,
1915: l_okl_txd_assets_tl_rec.created_by,
1916: l_okl_txd_assets_tl_rec.creation_date,
1917: l_okl_txd_assets_tl_rec.last_updated_by,
1918: l_okl_txd_assets_tl_rec.last_update_date,
1919: l_okl_txd_assets_tl_rec.last_update_login);
1920: END LOOP;
1921: -- Set OUT values
1922: x_okl_txd_assets_tl_rec := l_okl_txd_assets_tl_rec;

Line 1919: l_okl_txd_assets_tl_rec.last_update_login);

1915: l_okl_txd_assets_tl_rec.created_by,
1916: l_okl_txd_assets_tl_rec.creation_date,
1917: l_okl_txd_assets_tl_rec.last_updated_by,
1918: l_okl_txd_assets_tl_rec.last_update_date,
1919: l_okl_txd_assets_tl_rec.last_update_login);
1920: END LOOP;
1921: -- Set OUT values
1922: x_okl_txd_assets_tl_rec := l_okl_txd_assets_tl_rec;
1923: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1922: x_okl_txd_assets_tl_rec := l_okl_txd_assets_tl_rec;

1918: l_okl_txd_assets_tl_rec.last_update_date,
1919: l_okl_txd_assets_tl_rec.last_update_login);
1920: END LOOP;
1921: -- Set OUT values
1922: x_okl_txd_assets_tl_rec := l_okl_txd_assets_tl_rec;
1923: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1924: EXCEPTION
1925: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1926: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1975: l_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;

1971: l_asdv_rec asdv_rec_type;
1972: l_def_asdv_rec asdv_rec_type;
1973: l_asd_rec asd_rec_type;
1974: lx_asd_rec asd_rec_type;
1975: l_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;
1976: lx_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;
1977: lx_temp_asdv_rec asdv_rec_type;
1978: -------------------------------
1979: -- FUNCTION fill_who_columns --

Line 1976: lx_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;

1972: l_def_asdv_rec asdv_rec_type;
1973: l_asd_rec asd_rec_type;
1974: lx_asd_rec asd_rec_type;
1975: l_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;
1976: lx_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;
1977: lx_temp_asdv_rec asdv_rec_type;
1978: -------------------------------
1979: -- FUNCTION fill_who_columns --
1980: -------------------------------

Line 2094: migrate(l_def_asdv_rec, l_okl_txd_assets_tl_rec);

2090: --------------------------------------
2091: -- Move VIEW record to "Child" records
2092: --------------------------------------
2093: migrate(l_def_asdv_rec, l_asd_rec);
2094: migrate(l_def_asdv_rec, l_okl_txd_assets_tl_rec);
2095: --------------------------------------------
2096: -- Call the INSERT_ROW for each child record
2097: --------------------------------------------
2098: insert_row(

Line 2117: l_okl_txd_assets_tl_rec,

2113: p_init_msg_list,
2114: x_return_status,
2115: x_msg_count,
2116: x_msg_data,
2117: l_okl_txd_assets_tl_rec,
2118: lx_okl_txd_assets_tl_rec
2119: );
2120: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2121: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2118: lx_okl_txd_assets_tl_rec

2114: x_return_status,
2115: x_msg_count,
2116: x_msg_data,
2117: l_okl_txd_assets_tl_rec,
2118: lx_okl_txd_assets_tl_rec
2119: );
2120: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2121: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2122: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2125: migrate(lx_okl_txd_assets_tl_rec, l_def_asdv_rec);

2121: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2122: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2123: RAISE OKC_API.G_EXCEPTION_ERROR;
2124: END IF;
2125: migrate(lx_okl_txd_assets_tl_rec, l_def_asdv_rec);
2126: -- Set OUT values
2127: x_asdv_rec := l_def_asdv_rec;
2128: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2129: EXCEPTION

Line 2338: -- lock_row for:OKL_TXD_ASSETS_TL --

2334: '_PVT'
2335: );
2336: END lock_row;
2337: ------------------------------------
2338: -- lock_row for:OKL_TXD_ASSETS_TL --
2339: ------------------------------------
2340: PROCEDURE lock_row(
2341: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2342: x_return_status OUT NOCOPY VARCHAR2,

Line 2345: p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type) IS

2341: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2342: x_return_status OUT NOCOPY VARCHAR2,
2343: x_msg_count OUT NOCOPY NUMBER,
2344: x_msg_data OUT NOCOPY VARCHAR2,
2345: p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type) IS
2346:
2347: E_Resource_Busy EXCEPTION;
2348: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2349: CURSOR lock_csr (p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type) IS

Line 2349: CURSOR lock_csr (p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type) IS

2345: p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type) IS
2346:
2347: E_Resource_Busy EXCEPTION;
2348: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2349: CURSOR lock_csr (p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type) IS
2350: SELECT *
2351: FROM OKL_TXD_ASSETS_TL
2352: WHERE ID = p_okl_txd_assets_tl_rec.id
2353: FOR UPDATE NOWAIT;

Line 2351: FROM OKL_TXD_ASSETS_TL

2347: E_Resource_Busy EXCEPTION;
2348: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2349: CURSOR lock_csr (p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type) IS
2350: SELECT *
2351: FROM OKL_TXD_ASSETS_TL
2352: WHERE ID = p_okl_txd_assets_tl_rec.id
2353: FOR UPDATE NOWAIT;
2354:
2355: l_api_version CONSTANT NUMBER := 1;

Line 2352: WHERE ID = p_okl_txd_assets_tl_rec.id

2348: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2349: CURSOR lock_csr (p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type) IS
2350: SELECT *
2351: FROM OKL_TXD_ASSETS_TL
2352: WHERE ID = p_okl_txd_assets_tl_rec.id
2353: FOR UPDATE NOWAIT;
2354:
2355: l_api_version CONSTANT NUMBER := 1;
2356: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';

Line 2372: OPEN lock_csr(p_okl_txd_assets_tl_rec);

2368: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2369: RAISE OKC_API.G_EXCEPTION_ERROR;
2370: END IF;
2371: BEGIN
2372: OPEN lock_csr(p_okl_txd_assets_tl_rec);
2373: FETCH lock_csr INTO l_lock_var;
2374: l_row_notfound := lock_csr%NOTFOUND;
2375: CLOSE lock_csr;
2376: EXCEPTION

Line 2437: l_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;

2433: l_api_version CONSTANT NUMBER := 1;
2434: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
2435: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2436: l_asd_rec asd_rec_type;
2437: l_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;
2438: BEGIN
2439: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2440: G_PKG_NAME,
2441: p_init_msg_list,

Line 2455: migrate(p_asdv_rec, l_okl_txd_assets_tl_rec);

2451: --------------------------------------
2452: -- Move VIEW record to "Child" records
2453: --------------------------------------
2454: migrate(p_asdv_rec, l_asd_rec);
2455: migrate(p_asdv_rec, l_okl_txd_assets_tl_rec);
2456: --------------------------------------------
2457: -- Call the LOCK_ROW for each child record
2458: --------------------------------------------
2459: lock_row(

Line 2476: l_okl_txd_assets_tl_rec

2472: p_init_msg_list,
2473: x_return_status,
2474: x_msg_count,
2475: x_msg_data,
2476: l_okl_txd_assets_tl_rec
2477: );
2478: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2479: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2480: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2905: -- update_row for:OKL_TXD_ASSETS_TL --

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

Line 2912: p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type,

2908: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2909: x_return_status OUT NOCOPY VARCHAR2,
2910: x_msg_count OUT NOCOPY NUMBER,
2911: x_msg_data OUT NOCOPY VARCHAR2,
2912: p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type,
2913: x_okl_txd_assets_tl_rec OUT NOCOPY okl_txd_assets_tl_rec_type) IS
2914:
2915: l_api_version CONSTANT NUMBER := 1;
2916: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';

Line 2913: x_okl_txd_assets_tl_rec OUT NOCOPY okl_txd_assets_tl_rec_type) IS

2909: x_return_status OUT NOCOPY VARCHAR2,
2910: x_msg_count OUT NOCOPY NUMBER,
2911: x_msg_data OUT NOCOPY VARCHAR2,
2912: p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type,
2913: x_okl_txd_assets_tl_rec OUT NOCOPY okl_txd_assets_tl_rec_type) IS
2914:
2915: l_api_version CONSTANT NUMBER := 1;
2916: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2917: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2918: l_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type := p_okl_txd_assets_tl_rec;

2914:
2915: l_api_version CONSTANT NUMBER := 1;
2916: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2917: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2918: l_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type := p_okl_txd_assets_tl_rec;
2919: l_def_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;
2920: l_row_notfound BOOLEAN := TRUE;
2921: ----------------------------------
2922: -- FUNCTION populate_new_record --

Line 2919: l_def_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;

2915: l_api_version CONSTANT NUMBER := 1;
2916: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2917: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2918: l_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type := p_okl_txd_assets_tl_rec;
2919: l_def_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;
2920: l_row_notfound BOOLEAN := TRUE;
2921: ----------------------------------
2922: -- FUNCTION populate_new_record --
2923: ----------------------------------

Line 2925: p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type,

2921: ----------------------------------
2922: -- FUNCTION populate_new_record --
2923: ----------------------------------
2924: FUNCTION populate_new_record (
2925: p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type,
2926: x_okl_txd_assets_tl_rec OUT NOCOPY okl_txd_assets_tl_rec_type
2927: ) RETURN VARCHAR2 IS
2928: l_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;
2929: l_row_notfound BOOLEAN := TRUE;

Line 2926: x_okl_txd_assets_tl_rec OUT NOCOPY okl_txd_assets_tl_rec_type

2922: -- FUNCTION populate_new_record --
2923: ----------------------------------
2924: FUNCTION populate_new_record (
2925: p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type,
2926: x_okl_txd_assets_tl_rec OUT NOCOPY okl_txd_assets_tl_rec_type
2927: ) RETURN VARCHAR2 IS
2928: l_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;
2929: l_row_notfound BOOLEAN := TRUE;
2930: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2928: l_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;

2924: FUNCTION populate_new_record (
2925: p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type,
2926: x_okl_txd_assets_tl_rec OUT NOCOPY okl_txd_assets_tl_rec_type
2927: ) RETURN VARCHAR2 IS
2928: l_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;
2929: l_row_notfound BOOLEAN := TRUE;
2930: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2931: BEGIN
2932: x_okl_txd_assets_tl_rec := p_okl_txd_assets_tl_rec;

Line 2932: x_okl_txd_assets_tl_rec := p_okl_txd_assets_tl_rec;

2928: l_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;
2929: l_row_notfound BOOLEAN := TRUE;
2930: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2931: BEGIN
2932: x_okl_txd_assets_tl_rec := p_okl_txd_assets_tl_rec;
2933: -- Get current database values
2934: l_okl_txd_assets_tl_rec := get_rec(p_okl_txd_assets_tl_rec, l_row_notfound);
2935: IF (l_row_notfound) THEN
2936: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

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

2930: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2931: BEGIN
2932: x_okl_txd_assets_tl_rec := p_okl_txd_assets_tl_rec;
2933: -- Get current database values
2934: l_okl_txd_assets_tl_rec := get_rec(p_okl_txd_assets_tl_rec, l_row_notfound);
2935: IF (l_row_notfound) THEN
2936: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2937: END IF;
2938: IF (x_okl_txd_assets_tl_rec.id = OKC_API.G_MISS_NUM)

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

2934: l_okl_txd_assets_tl_rec := get_rec(p_okl_txd_assets_tl_rec, l_row_notfound);
2935: IF (l_row_notfound) THEN
2936: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2937: END IF;
2938: IF (x_okl_txd_assets_tl_rec.id = OKC_API.G_MISS_NUM)
2939: THEN
2940: x_okl_txd_assets_tl_rec.id := l_okl_txd_assets_tl_rec.id;
2941: END IF;
2942: IF (x_okl_txd_assets_tl_rec.language = OKC_API.G_MISS_CHAR)

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

2936: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2937: END IF;
2938: IF (x_okl_txd_assets_tl_rec.id = OKC_API.G_MISS_NUM)
2939: THEN
2940: x_okl_txd_assets_tl_rec.id := l_okl_txd_assets_tl_rec.id;
2941: END IF;
2942: IF (x_okl_txd_assets_tl_rec.language = OKC_API.G_MISS_CHAR)
2943: THEN
2944: x_okl_txd_assets_tl_rec.language := l_okl_txd_assets_tl_rec.language;

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

2938: IF (x_okl_txd_assets_tl_rec.id = OKC_API.G_MISS_NUM)
2939: THEN
2940: x_okl_txd_assets_tl_rec.id := l_okl_txd_assets_tl_rec.id;
2941: END IF;
2942: IF (x_okl_txd_assets_tl_rec.language = OKC_API.G_MISS_CHAR)
2943: THEN
2944: x_okl_txd_assets_tl_rec.language := l_okl_txd_assets_tl_rec.language;
2945: END IF;
2946: IF (x_okl_txd_assets_tl_rec.source_lang = OKC_API.G_MISS_CHAR)

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

2940: x_okl_txd_assets_tl_rec.id := l_okl_txd_assets_tl_rec.id;
2941: END IF;
2942: IF (x_okl_txd_assets_tl_rec.language = OKC_API.G_MISS_CHAR)
2943: THEN
2944: x_okl_txd_assets_tl_rec.language := l_okl_txd_assets_tl_rec.language;
2945: END IF;
2946: IF (x_okl_txd_assets_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2947: THEN
2948: x_okl_txd_assets_tl_rec.source_lang := l_okl_txd_assets_tl_rec.source_lang;

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

2942: IF (x_okl_txd_assets_tl_rec.language = OKC_API.G_MISS_CHAR)
2943: THEN
2944: x_okl_txd_assets_tl_rec.language := l_okl_txd_assets_tl_rec.language;
2945: END IF;
2946: IF (x_okl_txd_assets_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2947: THEN
2948: x_okl_txd_assets_tl_rec.source_lang := l_okl_txd_assets_tl_rec.source_lang;
2949: END IF;
2950: IF (x_okl_txd_assets_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)

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

2944: x_okl_txd_assets_tl_rec.language := l_okl_txd_assets_tl_rec.language;
2945: END IF;
2946: IF (x_okl_txd_assets_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2947: THEN
2948: x_okl_txd_assets_tl_rec.source_lang := l_okl_txd_assets_tl_rec.source_lang;
2949: END IF;
2950: IF (x_okl_txd_assets_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2951: THEN
2952: x_okl_txd_assets_tl_rec.sfwt_flag := l_okl_txd_assets_tl_rec.sfwt_flag;

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

2946: IF (x_okl_txd_assets_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2947: THEN
2948: x_okl_txd_assets_tl_rec.source_lang := l_okl_txd_assets_tl_rec.source_lang;
2949: END IF;
2950: IF (x_okl_txd_assets_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2951: THEN
2952: x_okl_txd_assets_tl_rec.sfwt_flag := l_okl_txd_assets_tl_rec.sfwt_flag;
2953: END IF;
2954: IF (x_okl_txd_assets_tl_rec.description = OKC_API.G_MISS_CHAR)

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

2948: x_okl_txd_assets_tl_rec.source_lang := l_okl_txd_assets_tl_rec.source_lang;
2949: END IF;
2950: IF (x_okl_txd_assets_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2951: THEN
2952: x_okl_txd_assets_tl_rec.sfwt_flag := l_okl_txd_assets_tl_rec.sfwt_flag;
2953: END IF;
2954: IF (x_okl_txd_assets_tl_rec.description = OKC_API.G_MISS_CHAR)
2955: THEN
2956: x_okl_txd_assets_tl_rec.description := l_okl_txd_assets_tl_rec.description;

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

2950: IF (x_okl_txd_assets_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2951: THEN
2952: x_okl_txd_assets_tl_rec.sfwt_flag := l_okl_txd_assets_tl_rec.sfwt_flag;
2953: END IF;
2954: IF (x_okl_txd_assets_tl_rec.description = OKC_API.G_MISS_CHAR)
2955: THEN
2956: x_okl_txd_assets_tl_rec.description := l_okl_txd_assets_tl_rec.description;
2957: END IF;
2958: IF (x_okl_txd_assets_tl_rec.created_by = OKC_API.G_MISS_NUM)

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

2952: x_okl_txd_assets_tl_rec.sfwt_flag := l_okl_txd_assets_tl_rec.sfwt_flag;
2953: END IF;
2954: IF (x_okl_txd_assets_tl_rec.description = OKC_API.G_MISS_CHAR)
2955: THEN
2956: x_okl_txd_assets_tl_rec.description := l_okl_txd_assets_tl_rec.description;
2957: END IF;
2958: IF (x_okl_txd_assets_tl_rec.created_by = OKC_API.G_MISS_NUM)
2959: THEN
2960: x_okl_txd_assets_tl_rec.created_by := l_okl_txd_assets_tl_rec.created_by;

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

2954: IF (x_okl_txd_assets_tl_rec.description = OKC_API.G_MISS_CHAR)
2955: THEN
2956: x_okl_txd_assets_tl_rec.description := l_okl_txd_assets_tl_rec.description;
2957: END IF;
2958: IF (x_okl_txd_assets_tl_rec.created_by = OKC_API.G_MISS_NUM)
2959: THEN
2960: x_okl_txd_assets_tl_rec.created_by := l_okl_txd_assets_tl_rec.created_by;
2961: END IF;
2962: IF (x_okl_txd_assets_tl_rec.creation_date = OKC_API.G_MISS_DATE)

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

2956: x_okl_txd_assets_tl_rec.description := l_okl_txd_assets_tl_rec.description;
2957: END IF;
2958: IF (x_okl_txd_assets_tl_rec.created_by = OKC_API.G_MISS_NUM)
2959: THEN
2960: x_okl_txd_assets_tl_rec.created_by := l_okl_txd_assets_tl_rec.created_by;
2961: END IF;
2962: IF (x_okl_txd_assets_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2963: THEN
2964: x_okl_txd_assets_tl_rec.creation_date := l_okl_txd_assets_tl_rec.creation_date;

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

2958: IF (x_okl_txd_assets_tl_rec.created_by = OKC_API.G_MISS_NUM)
2959: THEN
2960: x_okl_txd_assets_tl_rec.created_by := l_okl_txd_assets_tl_rec.created_by;
2961: END IF;
2962: IF (x_okl_txd_assets_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2963: THEN
2964: x_okl_txd_assets_tl_rec.creation_date := l_okl_txd_assets_tl_rec.creation_date;
2965: END IF;
2966: IF (x_okl_txd_assets_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)

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

2960: x_okl_txd_assets_tl_rec.created_by := l_okl_txd_assets_tl_rec.created_by;
2961: END IF;
2962: IF (x_okl_txd_assets_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2963: THEN
2964: x_okl_txd_assets_tl_rec.creation_date := l_okl_txd_assets_tl_rec.creation_date;
2965: END IF;
2966: IF (x_okl_txd_assets_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2967: THEN
2968: x_okl_txd_assets_tl_rec.last_updated_by := l_okl_txd_assets_tl_rec.last_updated_by;

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

2962: IF (x_okl_txd_assets_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2963: THEN
2964: x_okl_txd_assets_tl_rec.creation_date := l_okl_txd_assets_tl_rec.creation_date;
2965: END IF;
2966: IF (x_okl_txd_assets_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2967: THEN
2968: x_okl_txd_assets_tl_rec.last_updated_by := l_okl_txd_assets_tl_rec.last_updated_by;
2969: END IF;
2970: IF (x_okl_txd_assets_tl_rec.last_update_date = OKC_API.G_MISS_DATE)

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

2964: x_okl_txd_assets_tl_rec.creation_date := l_okl_txd_assets_tl_rec.creation_date;
2965: END IF;
2966: IF (x_okl_txd_assets_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2967: THEN
2968: x_okl_txd_assets_tl_rec.last_updated_by := l_okl_txd_assets_tl_rec.last_updated_by;
2969: END IF;
2970: IF (x_okl_txd_assets_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2971: THEN
2972: x_okl_txd_assets_tl_rec.last_update_date := l_okl_txd_assets_tl_rec.last_update_date;

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

2966: IF (x_okl_txd_assets_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2967: THEN
2968: x_okl_txd_assets_tl_rec.last_updated_by := l_okl_txd_assets_tl_rec.last_updated_by;
2969: END IF;
2970: IF (x_okl_txd_assets_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2971: THEN
2972: x_okl_txd_assets_tl_rec.last_update_date := l_okl_txd_assets_tl_rec.last_update_date;
2973: END IF;
2974: IF (x_okl_txd_assets_tl_rec.last_update_login = OKC_API.G_MISS_NUM)

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

2968: x_okl_txd_assets_tl_rec.last_updated_by := l_okl_txd_assets_tl_rec.last_updated_by;
2969: END IF;
2970: IF (x_okl_txd_assets_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2971: THEN
2972: x_okl_txd_assets_tl_rec.last_update_date := l_okl_txd_assets_tl_rec.last_update_date;
2973: END IF;
2974: IF (x_okl_txd_assets_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
2975: THEN
2976: x_okl_txd_assets_tl_rec.last_update_login := l_okl_txd_assets_tl_rec.last_update_login;

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

2970: IF (x_okl_txd_assets_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2971: THEN
2972: x_okl_txd_assets_tl_rec.last_update_date := l_okl_txd_assets_tl_rec.last_update_date;
2973: END IF;
2974: IF (x_okl_txd_assets_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
2975: THEN
2976: x_okl_txd_assets_tl_rec.last_update_login := l_okl_txd_assets_tl_rec.last_update_login;
2977: END IF;
2978: /*

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

2972: x_okl_txd_assets_tl_rec.last_update_date := l_okl_txd_assets_tl_rec.last_update_date;
2973: END IF;
2974: IF (x_okl_txd_assets_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
2975: THEN
2976: x_okl_txd_assets_tl_rec.last_update_login := l_okl_txd_assets_tl_rec.last_update_login;
2977: END IF;
2978: /*
2979: -- Multi Currency Change
2980: IF (x_okl_txd_assets_tl_rec.currency_code = OKC_API.G_MISS_CHAR)

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

2976: x_okl_txd_assets_tl_rec.last_update_login := l_okl_txd_assets_tl_rec.last_update_login;
2977: END IF;
2978: /*
2979: -- Multi Currency Change
2980: IF (x_okl_txd_assets_tl_rec.currency_code = OKC_API.G_MISS_CHAR)
2981: THEN
2982: x_okl_txd_assets_tl_rec.currency_code := l_okl_txd_assets_tl_rec.currency_code;
2983: END IF;
2984: IF (x_okl_txd_assets_tl_rec.currency_conversion_type = OKC_API.G_MISS_CHAR)

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

2978: /*
2979: -- Multi Currency Change
2980: IF (x_okl_txd_assets_tl_rec.currency_code = OKC_API.G_MISS_CHAR)
2981: THEN
2982: x_okl_txd_assets_tl_rec.currency_code := l_okl_txd_assets_tl_rec.currency_code;
2983: END IF;
2984: IF (x_okl_txd_assets_tl_rec.currency_conversion_type = OKC_API.G_MISS_CHAR)
2985: THEN
2986: x_okl_txd_assets_tl_rec.currency_conversion_type := l_okl_txd_assets_tl_rec.currency_conversion_type;

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

2980: IF (x_okl_txd_assets_tl_rec.currency_code = OKC_API.G_MISS_CHAR)
2981: THEN
2982: x_okl_txd_assets_tl_rec.currency_code := l_okl_txd_assets_tl_rec.currency_code;
2983: END IF;
2984: IF (x_okl_txd_assets_tl_rec.currency_conversion_type = OKC_API.G_MISS_CHAR)
2985: THEN
2986: x_okl_txd_assets_tl_rec.currency_conversion_type := l_okl_txd_assets_tl_rec.currency_conversion_type;
2987: END IF;
2988: IF (x_okl_txd_assets_tl_rec.currency_conversion_rate = OKC_API.G_MISS_NUM)

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

2982: x_okl_txd_assets_tl_rec.currency_code := l_okl_txd_assets_tl_rec.currency_code;
2983: END IF;
2984: IF (x_okl_txd_assets_tl_rec.currency_conversion_type = OKC_API.G_MISS_CHAR)
2985: THEN
2986: x_okl_txd_assets_tl_rec.currency_conversion_type := l_okl_txd_assets_tl_rec.currency_conversion_type;
2987: END IF;
2988: IF (x_okl_txd_assets_tl_rec.currency_conversion_rate = OKC_API.G_MISS_NUM)
2989: THEN
2990: x_okl_txd_assets_tl_rec.currency_conversion_rate := l_okl_txd_assets_tl_rec.currency_conversion_rate;

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

2984: IF (x_okl_txd_assets_tl_rec.currency_conversion_type = OKC_API.G_MISS_CHAR)
2985: THEN
2986: x_okl_txd_assets_tl_rec.currency_conversion_type := l_okl_txd_assets_tl_rec.currency_conversion_type;
2987: END IF;
2988: IF (x_okl_txd_assets_tl_rec.currency_conversion_rate = OKC_API.G_MISS_NUM)
2989: THEN
2990: x_okl_txd_assets_tl_rec.currency_conversion_rate := l_okl_txd_assets_tl_rec.currency_conversion_rate;
2991: END IF;
2992: IF (x_okl_txd_assets_tl_rec.currency_conversion_date = OKC_API.G_MISS_DATE)

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

2986: x_okl_txd_assets_tl_rec.currency_conversion_type := l_okl_txd_assets_tl_rec.currency_conversion_type;
2987: END IF;
2988: IF (x_okl_txd_assets_tl_rec.currency_conversion_rate = OKC_API.G_MISS_NUM)
2989: THEN
2990: x_okl_txd_assets_tl_rec.currency_conversion_rate := l_okl_txd_assets_tl_rec.currency_conversion_rate;
2991: END IF;
2992: IF (x_okl_txd_assets_tl_rec.currency_conversion_date = OKC_API.G_MISS_DATE)
2993: THEN
2994: x_okl_txd_assets_tl_rec.currency_conversion_date := l_okl_txd_assets_tl_rec.currency_conversion_date;

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

2988: IF (x_okl_txd_assets_tl_rec.currency_conversion_rate = OKC_API.G_MISS_NUM)
2989: THEN
2990: x_okl_txd_assets_tl_rec.currency_conversion_rate := l_okl_txd_assets_tl_rec.currency_conversion_rate;
2991: END IF;
2992: IF (x_okl_txd_assets_tl_rec.currency_conversion_date = OKC_API.G_MISS_DATE)
2993: THEN
2994: x_okl_txd_assets_tl_rec.currency_conversion_date := l_okl_txd_assets_tl_rec.currency_conversion_date;
2995: END IF;
2996: -- Multi Currency Change

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

2990: x_okl_txd_assets_tl_rec.currency_conversion_rate := l_okl_txd_assets_tl_rec.currency_conversion_rate;
2991: END IF;
2992: IF (x_okl_txd_assets_tl_rec.currency_conversion_date = OKC_API.G_MISS_DATE)
2993: THEN
2994: x_okl_txd_assets_tl_rec.currency_conversion_date := l_okl_txd_assets_tl_rec.currency_conversion_date;
2995: END IF;
2996: -- Multi Currency Change
2997: */
2998: RETURN(l_return_status);

Line 3001: -- Set_Attributes for:OKL_TXD_ASSETS_TL --

2997: */
2998: RETURN(l_return_status);
2999: END populate_new_record;
3000: ------------------------------------------
3001: -- Set_Attributes for:OKL_TXD_ASSETS_TL --
3002: ------------------------------------------
3003: FUNCTION Set_Attributes (
3004: p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type,
3005: x_okl_txd_assets_tl_rec OUT NOCOPY okl_txd_assets_tl_rec_type

Line 3004: p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type,

3000: ------------------------------------------
3001: -- Set_Attributes for:OKL_TXD_ASSETS_TL --
3002: ------------------------------------------
3003: FUNCTION Set_Attributes (
3004: p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type,
3005: x_okl_txd_assets_tl_rec OUT NOCOPY okl_txd_assets_tl_rec_type
3006: ) RETURN VARCHAR2 IS
3007: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3008: BEGIN

Line 3005: x_okl_txd_assets_tl_rec OUT NOCOPY okl_txd_assets_tl_rec_type

3001: -- Set_Attributes for:OKL_TXD_ASSETS_TL --
3002: ------------------------------------------
3003: FUNCTION Set_Attributes (
3004: p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type,
3005: x_okl_txd_assets_tl_rec OUT NOCOPY okl_txd_assets_tl_rec_type
3006: ) RETURN VARCHAR2 IS
3007: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3008: BEGIN
3009: x_okl_txd_assets_tl_rec := p_okl_txd_assets_tl_rec;

Line 3009: x_okl_txd_assets_tl_rec := p_okl_txd_assets_tl_rec;

3005: x_okl_txd_assets_tl_rec OUT NOCOPY okl_txd_assets_tl_rec_type
3006: ) RETURN VARCHAR2 IS
3007: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3008: BEGIN
3009: x_okl_txd_assets_tl_rec := p_okl_txd_assets_tl_rec;
3010: x_okl_txd_assets_tl_rec.LANGUAGE := USERENV('LANG');
3011: x_okl_txd_assets_tl_rec.SOURCE_LANG := USERENV('LANG');
3012: RETURN(l_return_status);
3013: END Set_Attributes;

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

3006: ) RETURN VARCHAR2 IS
3007: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3008: BEGIN
3009: x_okl_txd_assets_tl_rec := p_okl_txd_assets_tl_rec;
3010: x_okl_txd_assets_tl_rec.LANGUAGE := USERENV('LANG');
3011: x_okl_txd_assets_tl_rec.SOURCE_LANG := USERENV('LANG');
3012: RETURN(l_return_status);
3013: END Set_Attributes;
3014: BEGIN

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

3007: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3008: BEGIN
3009: x_okl_txd_assets_tl_rec := p_okl_txd_assets_tl_rec;
3010: x_okl_txd_assets_tl_rec.LANGUAGE := USERENV('LANG');
3011: x_okl_txd_assets_tl_rec.SOURCE_LANG := USERENV('LANG');
3012: RETURN(l_return_status);
3013: END Set_Attributes;
3014: BEGIN
3015: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3026: p_okl_txd_assets_tl_rec, -- IN

3022: RAISE OKC_API.G_EXCEPTION_ERROR;
3023: END IF;
3024: --- Setting item attributes
3025: l_return_status := Set_Attributes(
3026: p_okl_txd_assets_tl_rec, -- IN
3027: l_okl_txd_assets_tl_rec); -- OUT
3028: --- If any errors happen abort API
3029: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3030: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3027: l_okl_txd_assets_tl_rec); -- OUT

3023: END IF;
3024: --- Setting item attributes
3025: l_return_status := Set_Attributes(
3026: p_okl_txd_assets_tl_rec, -- IN
3027: l_okl_txd_assets_tl_rec); -- OUT
3028: --- If any errors happen abort API
3029: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3030: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3031: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

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

3030: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3031: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3032: RAISE OKC_API.G_EXCEPTION_ERROR;
3033: END IF;
3034: l_return_status := populate_new_record(l_okl_txd_assets_tl_rec, l_def_okl_txd_assets_tl_rec);
3035: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3036: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3037: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3038: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 3040: UPDATE OKL_TXD_ASSETS_TL

3036: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3037: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3038: RAISE OKC_API.G_EXCEPTION_ERROR;
3039: END IF;
3040: UPDATE OKL_TXD_ASSETS_TL
3041: SET DESCRIPTION = l_def_okl_txd_assets_tl_rec.description,
3042: --Bug# 3641933 :
3043: SOURCE_LANG = l_def_okl_txd_assets_tl_rec.source_lang,
3044: CREATED_BY = l_def_okl_txd_assets_tl_rec.created_by,

Line 3041: SET DESCRIPTION = l_def_okl_txd_assets_tl_rec.description,

3037: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3038: RAISE OKC_API.G_EXCEPTION_ERROR;
3039: END IF;
3040: UPDATE OKL_TXD_ASSETS_TL
3041: SET DESCRIPTION = l_def_okl_txd_assets_tl_rec.description,
3042: --Bug# 3641933 :
3043: SOURCE_LANG = l_def_okl_txd_assets_tl_rec.source_lang,
3044: CREATED_BY = l_def_okl_txd_assets_tl_rec.created_by,
3045: CREATION_DATE = l_def_okl_txd_assets_tl_rec.creation_date,

Line 3043: SOURCE_LANG = l_def_okl_txd_assets_tl_rec.source_lang,

3039: END IF;
3040: UPDATE OKL_TXD_ASSETS_TL
3041: SET DESCRIPTION = l_def_okl_txd_assets_tl_rec.description,
3042: --Bug# 3641933 :
3043: SOURCE_LANG = l_def_okl_txd_assets_tl_rec.source_lang,
3044: CREATED_BY = l_def_okl_txd_assets_tl_rec.created_by,
3045: CREATION_DATE = l_def_okl_txd_assets_tl_rec.creation_date,
3046: LAST_UPDATED_BY = l_def_okl_txd_assets_tl_rec.last_updated_by,
3047: LAST_UPDATE_DATE = l_def_okl_txd_assets_tl_rec.last_update_date,

Line 3044: CREATED_BY = l_def_okl_txd_assets_tl_rec.created_by,

3040: UPDATE OKL_TXD_ASSETS_TL
3041: SET DESCRIPTION = l_def_okl_txd_assets_tl_rec.description,
3042: --Bug# 3641933 :
3043: SOURCE_LANG = l_def_okl_txd_assets_tl_rec.source_lang,
3044: CREATED_BY = l_def_okl_txd_assets_tl_rec.created_by,
3045: CREATION_DATE = l_def_okl_txd_assets_tl_rec.creation_date,
3046: LAST_UPDATED_BY = l_def_okl_txd_assets_tl_rec.last_updated_by,
3047: LAST_UPDATE_DATE = l_def_okl_txd_assets_tl_rec.last_update_date,
3048: LAST_UPDATE_LOGIN = l_def_okl_txd_assets_tl_rec.last_update_login

Line 3045: CREATION_DATE = l_def_okl_txd_assets_tl_rec.creation_date,

3041: SET DESCRIPTION = l_def_okl_txd_assets_tl_rec.description,
3042: --Bug# 3641933 :
3043: SOURCE_LANG = l_def_okl_txd_assets_tl_rec.source_lang,
3044: CREATED_BY = l_def_okl_txd_assets_tl_rec.created_by,
3045: CREATION_DATE = l_def_okl_txd_assets_tl_rec.creation_date,
3046: LAST_UPDATED_BY = l_def_okl_txd_assets_tl_rec.last_updated_by,
3047: LAST_UPDATE_DATE = l_def_okl_txd_assets_tl_rec.last_update_date,
3048: LAST_UPDATE_LOGIN = l_def_okl_txd_assets_tl_rec.last_update_login
3049: WHERE ID = l_def_okl_txd_assets_tl_rec.id

Line 3046: LAST_UPDATED_BY = l_def_okl_txd_assets_tl_rec.last_updated_by,

3042: --Bug# 3641933 :
3043: SOURCE_LANG = l_def_okl_txd_assets_tl_rec.source_lang,
3044: CREATED_BY = l_def_okl_txd_assets_tl_rec.created_by,
3045: CREATION_DATE = l_def_okl_txd_assets_tl_rec.creation_date,
3046: LAST_UPDATED_BY = l_def_okl_txd_assets_tl_rec.last_updated_by,
3047: LAST_UPDATE_DATE = l_def_okl_txd_assets_tl_rec.last_update_date,
3048: LAST_UPDATE_LOGIN = l_def_okl_txd_assets_tl_rec.last_update_login
3049: WHERE ID = l_def_okl_txd_assets_tl_rec.id
3050: --Bug# 3641933 :

Line 3047: LAST_UPDATE_DATE = l_def_okl_txd_assets_tl_rec.last_update_date,

3043: SOURCE_LANG = l_def_okl_txd_assets_tl_rec.source_lang,
3044: CREATED_BY = l_def_okl_txd_assets_tl_rec.created_by,
3045: CREATION_DATE = l_def_okl_txd_assets_tl_rec.creation_date,
3046: LAST_UPDATED_BY = l_def_okl_txd_assets_tl_rec.last_updated_by,
3047: LAST_UPDATE_DATE = l_def_okl_txd_assets_tl_rec.last_update_date,
3048: LAST_UPDATE_LOGIN = l_def_okl_txd_assets_tl_rec.last_update_login
3049: WHERE ID = l_def_okl_txd_assets_tl_rec.id
3050: --Bug# 3641933 :
3051: AND USERENV('LANG') in (SOURCE_LANG,LANGUAGE);

Line 3048: LAST_UPDATE_LOGIN = l_def_okl_txd_assets_tl_rec.last_update_login

3044: CREATED_BY = l_def_okl_txd_assets_tl_rec.created_by,
3045: CREATION_DATE = l_def_okl_txd_assets_tl_rec.creation_date,
3046: LAST_UPDATED_BY = l_def_okl_txd_assets_tl_rec.last_updated_by,
3047: LAST_UPDATE_DATE = l_def_okl_txd_assets_tl_rec.last_update_date,
3048: LAST_UPDATE_LOGIN = l_def_okl_txd_assets_tl_rec.last_update_login
3049: WHERE ID = l_def_okl_txd_assets_tl_rec.id
3050: --Bug# 3641933 :
3051: AND USERENV('LANG') in (SOURCE_LANG,LANGUAGE);
3052: --AND SOURCE_LANG = USERENV('LANG');

Line 3049: WHERE ID = l_def_okl_txd_assets_tl_rec.id

3045: CREATION_DATE = l_def_okl_txd_assets_tl_rec.creation_date,
3046: LAST_UPDATED_BY = l_def_okl_txd_assets_tl_rec.last_updated_by,
3047: LAST_UPDATE_DATE = l_def_okl_txd_assets_tl_rec.last_update_date,
3048: LAST_UPDATE_LOGIN = l_def_okl_txd_assets_tl_rec.last_update_login
3049: WHERE ID = l_def_okl_txd_assets_tl_rec.id
3050: --Bug# 3641933 :
3051: AND USERENV('LANG') in (SOURCE_LANG,LANGUAGE);
3052: --AND SOURCE_LANG = USERENV('LANG');
3053:

Line 3054: UPDATE OKL_TXD_ASSETS_TL

3050: --Bug# 3641933 :
3051: AND USERENV('LANG') in (SOURCE_LANG,LANGUAGE);
3052: --AND SOURCE_LANG = USERENV('LANG');
3053:
3054: UPDATE OKL_TXD_ASSETS_TL
3055: SET SFWT_FLAG = 'Y'
3056: WHERE ID = l_def_okl_txd_assets_tl_rec.id
3057: AND SOURCE_LANG <> USERENV('LANG');
3058:

Line 3056: WHERE ID = l_def_okl_txd_assets_tl_rec.id

3052: --AND SOURCE_LANG = USERENV('LANG');
3053:
3054: UPDATE OKL_TXD_ASSETS_TL
3055: SET SFWT_FLAG = 'Y'
3056: WHERE ID = l_def_okl_txd_assets_tl_rec.id
3057: AND SOURCE_LANG <> USERENV('LANG');
3058:
3059: x_okl_txd_assets_tl_rec := l_def_okl_txd_assets_tl_rec;
3060: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 3059: x_okl_txd_assets_tl_rec := l_def_okl_txd_assets_tl_rec;

3055: SET SFWT_FLAG = 'Y'
3056: WHERE ID = l_def_okl_txd_assets_tl_rec.id
3057: AND SOURCE_LANG <> USERENV('LANG');
3058:
3059: x_okl_txd_assets_tl_rec := l_def_okl_txd_assets_tl_rec;
3060: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3061: EXCEPTION
3062: WHEN OKC_API.G_EXCEPTION_ERROR THEN
3063: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 3110: l_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;

3106: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
3107: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3108: l_asdv_rec asdv_rec_type := p_asdv_rec;
3109: l_def_asdv_rec asdv_rec_type;
3110: l_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;
3111: lx_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;
3112: l_asd_rec asd_rec_type;
3113: lx_asd_rec asd_rec_type;
3114: lx_temp_asdv_rec asdv_rec_type;

Line 3111: lx_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;

3107: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3108: l_asdv_rec asdv_rec_type := p_asdv_rec;
3109: l_def_asdv_rec asdv_rec_type;
3110: l_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;
3111: lx_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;
3112: l_asd_rec asd_rec_type;
3113: lx_asd_rec asd_rec_type;
3114: lx_temp_asdv_rec asdv_rec_type;
3115: -------------------------------

Line 3423: migrate(l_def_asdv_rec, l_okl_txd_assets_tl_rec);

3419:
3420: --------------------------------------
3421: -- Move VIEW record to "Child" records
3422: --------------------------------------
3423: migrate(l_def_asdv_rec, l_okl_txd_assets_tl_rec);
3424: migrate(l_def_asdv_rec, l_asd_rec);
3425: --------------------------------------------
3426: -- Call the UPDATE_ROW for each child record
3427: --------------------------------------------

Line 3433: l_okl_txd_assets_tl_rec,

3429: p_init_msg_list,
3430: x_return_status,
3431: x_msg_count,
3432: x_msg_data,
3433: l_okl_txd_assets_tl_rec,
3434: lx_okl_txd_assets_tl_rec
3435: );
3436: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3437: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3434: lx_okl_txd_assets_tl_rec

3430: x_return_status,
3431: x_msg_count,
3432: x_msg_data,
3433: l_okl_txd_assets_tl_rec,
3434: lx_okl_txd_assets_tl_rec
3435: );
3436: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3437: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3438: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 3441: migrate(lx_okl_txd_assets_tl_rec, l_def_asdv_rec);

3437: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3438: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3439: RAISE OKC_API.G_EXCEPTION_ERROR;
3440: END IF;
3441: migrate(lx_okl_txd_assets_tl_rec, l_def_asdv_rec);
3442: --------------------------------------------
3443: -- Call the UPDATE_ROW for each child record
3444: --------------------------------------------
3445: update_row(

Line 3625: -- delete_row for:OKL_TXD_ASSETS_TL --

3621: '_PVT'
3622: );
3623: END delete_row;
3624: --------------------------------------
3625: -- delete_row for:OKL_TXD_ASSETS_TL --
3626: --------------------------------------
3627: PROCEDURE delete_row(
3628: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3629: x_return_status OUT NOCOPY VARCHAR2,

Line 3632: p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type) IS

3628: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3629: x_return_status OUT NOCOPY VARCHAR2,
3630: x_msg_count OUT NOCOPY NUMBER,
3631: x_msg_data OUT NOCOPY VARCHAR2,
3632: p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type) IS
3633:
3634: l_api_version CONSTANT NUMBER := 1;
3635: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3636: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 3637: l_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type:= p_okl_txd_assets_tl_rec;

3633:
3634: l_api_version CONSTANT NUMBER := 1;
3635: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3636: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3637: l_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type:= p_okl_txd_assets_tl_rec;
3638: l_row_notfound BOOLEAN := TRUE;
3639: ------------------------------------------
3640: -- Set_Attributes for:OKL_TXD_ASSETS_TL --
3641: ------------------------------------------

Line 3640: -- Set_Attributes for:OKL_TXD_ASSETS_TL --

3636: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3637: l_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type:= p_okl_txd_assets_tl_rec;
3638: l_row_notfound BOOLEAN := TRUE;
3639: ------------------------------------------
3640: -- Set_Attributes for:OKL_TXD_ASSETS_TL --
3641: ------------------------------------------
3642: FUNCTION Set_Attributes (
3643: p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type,
3644: x_okl_txd_assets_tl_rec OUT NOCOPY okl_txd_assets_tl_rec_type

Line 3643: p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type,

3639: ------------------------------------------
3640: -- Set_Attributes for:OKL_TXD_ASSETS_TL --
3641: ------------------------------------------
3642: FUNCTION Set_Attributes (
3643: p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type,
3644: x_okl_txd_assets_tl_rec OUT NOCOPY okl_txd_assets_tl_rec_type
3645: ) RETURN VARCHAR2 IS
3646: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3647: BEGIN

Line 3644: x_okl_txd_assets_tl_rec OUT NOCOPY okl_txd_assets_tl_rec_type

3640: -- Set_Attributes for:OKL_TXD_ASSETS_TL --
3641: ------------------------------------------
3642: FUNCTION Set_Attributes (
3643: p_okl_txd_assets_tl_rec IN okl_txd_assets_tl_rec_type,
3644: x_okl_txd_assets_tl_rec OUT NOCOPY okl_txd_assets_tl_rec_type
3645: ) RETURN VARCHAR2 IS
3646: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3647: BEGIN
3648: x_okl_txd_assets_tl_rec := p_okl_txd_assets_tl_rec;

Line 3648: x_okl_txd_assets_tl_rec := p_okl_txd_assets_tl_rec;

3644: x_okl_txd_assets_tl_rec OUT NOCOPY okl_txd_assets_tl_rec_type
3645: ) RETURN VARCHAR2 IS
3646: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3647: BEGIN
3648: x_okl_txd_assets_tl_rec := p_okl_txd_assets_tl_rec;
3649: x_okl_txd_assets_tl_rec.LANGUAGE := USERENV('LANG');
3650: RETURN(l_return_status);
3651: END Set_Attributes;
3652: BEGIN

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

3645: ) RETURN VARCHAR2 IS
3646: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3647: BEGIN
3648: x_okl_txd_assets_tl_rec := p_okl_txd_assets_tl_rec;
3649: x_okl_txd_assets_tl_rec.LANGUAGE := USERENV('LANG');
3650: RETURN(l_return_status);
3651: END Set_Attributes;
3652: BEGIN
3653: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3664: p_okl_txd_assets_tl_rec, -- IN

3660: RAISE OKC_API.G_EXCEPTION_ERROR;
3661: END IF;
3662: --- Setting item attributes
3663: l_return_status := Set_Attributes(
3664: p_okl_txd_assets_tl_rec, -- IN
3665: l_okl_txd_assets_tl_rec); -- OUT
3666: --- If any errors happen abort API
3667: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3668: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3665: l_okl_txd_assets_tl_rec); -- OUT

3661: END IF;
3662: --- Setting item attributes
3663: l_return_status := Set_Attributes(
3664: p_okl_txd_assets_tl_rec, -- IN
3665: l_okl_txd_assets_tl_rec); -- OUT
3666: --- If any errors happen abort API
3667: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3668: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3669: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 3672: DELETE FROM OKL_TXD_ASSETS_TL

3668: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3669: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3670: RAISE OKC_API.G_EXCEPTION_ERROR;
3671: END IF;
3672: DELETE FROM OKL_TXD_ASSETS_TL
3673: WHERE ID = l_okl_txd_assets_tl_rec.id;
3674:
3675: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3676: EXCEPTION

Line 3673: WHERE ID = l_okl_txd_assets_tl_rec.id;

3669: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3670: RAISE OKC_API.G_EXCEPTION_ERROR;
3671: END IF;
3672: DELETE FROM OKL_TXD_ASSETS_TL
3673: WHERE ID = l_okl_txd_assets_tl_rec.id;
3674:
3675: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3676: EXCEPTION
3677: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 3723: l_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;

3719: l_api_version CONSTANT NUMBER := 1;
3720: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
3721: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3722: l_asdv_rec asdv_rec_type := p_asdv_rec;
3723: l_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;
3724: l_asd_rec asd_rec_type;
3725: BEGIN
3726: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
3727: G_PKG_NAME,

Line 3741: migrate(l_asdv_rec, l_okl_txd_assets_tl_rec);

3737: END IF;
3738: --------------------------------------
3739: -- Move VIEW record to "Child" records
3740: --------------------------------------
3741: migrate(l_asdv_rec, l_okl_txd_assets_tl_rec);
3742: migrate(l_asdv_rec, l_asd_rec);
3743: --------------------------------------------
3744: -- Call the DELETE_ROW for each child record
3745: --------------------------------------------

Line 3751: l_okl_txd_assets_tl_rec

3747: p_init_msg_list,
3748: x_return_status,
3749: x_msg_count,
3750: x_msg_data,
3751: l_okl_txd_assets_tl_rec
3752: );
3753: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3754: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3755: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN