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_RAS_PVT dependencies on OKL_RELOCATE_ASSETS_TL

Line 798: DELETE FROM OKL_RELOCATE_ASSETS_TL T

794: -- PROCEDURE add_language
795: ---------------------------------------------------------------------------
796: PROCEDURE add_language IS
797: BEGIN
798: DELETE FROM OKL_RELOCATE_ASSETS_TL T
799: WHERE NOT EXISTS (
800: SELECT NULL
801: FROM OKL_RELOCATE_ASTS_ALL_B B
802: WHERE B.ID = T.ID

Line 805: UPDATE OKL_RELOCATE_ASSETS_TL T SET (

801: FROM OKL_RELOCATE_ASTS_ALL_B B
802: WHERE B.ID = T.ID
803: );
804:
805: UPDATE OKL_RELOCATE_ASSETS_TL T SET (
806: COMMENTS) = (SELECT
807: B.COMMENTS
808: FROM OKL_RELOCATE_ASSETS_TL B
809: WHERE B.ID = T.ID

Line 808: FROM OKL_RELOCATE_ASSETS_TL B

804:
805: UPDATE OKL_RELOCATE_ASSETS_TL T SET (
806: COMMENTS) = (SELECT
807: B.COMMENTS
808: FROM OKL_RELOCATE_ASSETS_TL B
809: WHERE B.ID = T.ID
810: AND B.LANGUAGE = T.SOURCE_LANG)
811: WHERE (
812: T.ID,

Line 817: FROM OKL_RELOCATE_ASSETS_TL SUBB, OKL_RELOCATE_ASSETS_TL SUBT

813: T.LANGUAGE)
814: IN (SELECT
815: SUBT.ID,
816: SUBT.LANGUAGE
817: FROM OKL_RELOCATE_ASSETS_TL SUBB, OKL_RELOCATE_ASSETS_TL SUBT
818: WHERE SUBB.ID = SUBT.ID
819: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
820: AND (SUBB.COMMENTS <> SUBT.COMMENTS
821: OR (SUBB.COMMENTS IS NULL AND SUBT.COMMENTS IS NOT NULL)

Line 825: INSERT INTO OKL_RELOCATE_ASSETS_TL (

821: OR (SUBB.COMMENTS IS NULL AND SUBT.COMMENTS IS NOT NULL)
822: OR (SUBB.COMMENTS IS NOT NULL AND SUBT.COMMENTS IS NULL)
823: ));
824:
825: INSERT INTO OKL_RELOCATE_ASSETS_TL (
826: ID,
827: LANGUAGE,
828: SOURCE_LANG,
829: SFWT_FLAG,

Line 847: FROM OKL_RELOCATE_ASSETS_TL B, FND_LANGUAGES L

843: B.CREATION_DATE,
844: B.LAST_UPDATED_BY,
845: B.LAST_UPDATE_DATE,
846: B.LAST_UPDATE_LOGIN
847: FROM OKL_RELOCATE_ASSETS_TL B, FND_LANGUAGES L
848: WHERE L.INSTALLED_FLAG IN ('I', 'B')
849: AND B.LANGUAGE = USERENV('LANG')
850: AND NOT EXISTS(
851: SELECT NULL

Line 852: FROM OKL_RELOCATE_ASSETS_TL T

848: WHERE L.INSTALLED_FLAG IN ('I', 'B')
849: AND B.LANGUAGE = USERENV('LANG')
850: AND NOT EXISTS(
851: SELECT NULL
852: FROM OKL_RELOCATE_ASSETS_TL T
853: WHERE T.ID = B.ID
854: AND T.LANGUAGE = L.LANGUAGE_CODE
855: );
856:

Line 982: -- FUNCTION get_rec for: OKL_RELOCATE_ASSETS_TL

978: BEGIN
979: RETURN(get_rec(p_ras_rec, l_row_notfound));
980: END get_rec;
981: ---------------------------------------------------------------------------
982: -- FUNCTION get_rec for: OKL_RELOCATE_ASSETS_TL
983: ---------------------------------------------------------------------------
984: FUNCTION get_rec (
985: p_okl_relocate_assets_tl_rec IN OklRelocateAssetsTlRecType,
986: x_no_data_found OUT NOCOPY BOOLEAN

Line 985: p_okl_relocate_assets_tl_rec IN OklRelocateAssetsTlRecType,

981: ---------------------------------------------------------------------------
982: -- FUNCTION get_rec for: OKL_RELOCATE_ASSETS_TL
983: ---------------------------------------------------------------------------
984: FUNCTION get_rec (
985: p_okl_relocate_assets_tl_rec IN OklRelocateAssetsTlRecType,
986: x_no_data_found OUT NOCOPY BOOLEAN
987: ) RETURN OklRelocateAssetsTlRecType IS
988: CURSOR okl_relocate_assets_tl_pk_csr (p_id IN NUMBER,
989: p_language IN VARCHAR2) IS

Line 988: CURSOR okl_relocate_assets_tl_pk_csr (p_id IN NUMBER,

984: FUNCTION get_rec (
985: p_okl_relocate_assets_tl_rec IN OklRelocateAssetsTlRecType,
986: x_no_data_found OUT NOCOPY BOOLEAN
987: ) RETURN OklRelocateAssetsTlRecType IS
988: CURSOR okl_relocate_assets_tl_pk_csr (p_id IN NUMBER,
989: p_language IN VARCHAR2) IS
990: SELECT
991: ID,
992: LANGUAGE,

Line 1001: FROM Okl_Relocate_Assets_Tl

997: CREATION_DATE,
998: LAST_UPDATED_BY,
999: LAST_UPDATE_DATE,
1000: LAST_UPDATE_LOGIN
1001: FROM Okl_Relocate_Assets_Tl
1002: WHERE okl_relocate_assets_tl.id = p_id
1003: AND okl_relocate_assets_tl.language = p_language;
1004: l_okl_relocate_assets_tl_pk okl_relocate_assets_tl_pk_csr%ROWTYPE;
1005: l_okl_relocate_assets_tl_rec OklRelocateAssetsTlRecType;

Line 1002: WHERE okl_relocate_assets_tl.id = p_id

998: LAST_UPDATED_BY,
999: LAST_UPDATE_DATE,
1000: LAST_UPDATE_LOGIN
1001: FROM Okl_Relocate_Assets_Tl
1002: WHERE okl_relocate_assets_tl.id = p_id
1003: AND okl_relocate_assets_tl.language = p_language;
1004: l_okl_relocate_assets_tl_pk okl_relocate_assets_tl_pk_csr%ROWTYPE;
1005: l_okl_relocate_assets_tl_rec OklRelocateAssetsTlRecType;
1006: BEGIN

Line 1003: AND okl_relocate_assets_tl.language = p_language;

999: LAST_UPDATE_DATE,
1000: LAST_UPDATE_LOGIN
1001: FROM Okl_Relocate_Assets_Tl
1002: WHERE okl_relocate_assets_tl.id = p_id
1003: AND okl_relocate_assets_tl.language = p_language;
1004: l_okl_relocate_assets_tl_pk okl_relocate_assets_tl_pk_csr%ROWTYPE;
1005: l_okl_relocate_assets_tl_rec OklRelocateAssetsTlRecType;
1006: BEGIN
1007: x_no_data_found := TRUE;

Line 1004: l_okl_relocate_assets_tl_pk okl_relocate_assets_tl_pk_csr%ROWTYPE;

1000: LAST_UPDATE_LOGIN
1001: FROM Okl_Relocate_Assets_Tl
1002: WHERE okl_relocate_assets_tl.id = p_id
1003: AND okl_relocate_assets_tl.language = p_language;
1004: l_okl_relocate_assets_tl_pk okl_relocate_assets_tl_pk_csr%ROWTYPE;
1005: l_okl_relocate_assets_tl_rec OklRelocateAssetsTlRecType;
1006: BEGIN
1007: x_no_data_found := TRUE;
1008: -- Get current database values

Line 1005: l_okl_relocate_assets_tl_rec OklRelocateAssetsTlRecType;

1001: FROM Okl_Relocate_Assets_Tl
1002: WHERE okl_relocate_assets_tl.id = p_id
1003: AND okl_relocate_assets_tl.language = p_language;
1004: l_okl_relocate_assets_tl_pk okl_relocate_assets_tl_pk_csr%ROWTYPE;
1005: l_okl_relocate_assets_tl_rec OklRelocateAssetsTlRecType;
1006: BEGIN
1007: x_no_data_found := TRUE;
1008: -- Get current database values
1009: OPEN okl_relocate_assets_tl_pk_csr (p_okl_relocate_assets_tl_rec.id,

Line 1009: OPEN okl_relocate_assets_tl_pk_csr (p_okl_relocate_assets_tl_rec.id,

1005: l_okl_relocate_assets_tl_rec OklRelocateAssetsTlRecType;
1006: BEGIN
1007: x_no_data_found := TRUE;
1008: -- Get current database values
1009: OPEN okl_relocate_assets_tl_pk_csr (p_okl_relocate_assets_tl_rec.id,
1010: p_okl_relocate_assets_tl_rec.language);
1011: FETCH okl_relocate_assets_tl_pk_csr INTO
1012: l_okl_relocate_assets_tl_rec.ID,
1013: l_okl_relocate_assets_tl_rec.LANGUAGE,

Line 1010: p_okl_relocate_assets_tl_rec.language);

1006: BEGIN
1007: x_no_data_found := TRUE;
1008: -- Get current database values
1009: OPEN okl_relocate_assets_tl_pk_csr (p_okl_relocate_assets_tl_rec.id,
1010: p_okl_relocate_assets_tl_rec.language);
1011: FETCH okl_relocate_assets_tl_pk_csr INTO
1012: l_okl_relocate_assets_tl_rec.ID,
1013: l_okl_relocate_assets_tl_rec.LANGUAGE,
1014: l_okl_relocate_assets_tl_rec.SOURCE_LANG,

Line 1011: FETCH okl_relocate_assets_tl_pk_csr INTO

1007: x_no_data_found := TRUE;
1008: -- Get current database values
1009: OPEN okl_relocate_assets_tl_pk_csr (p_okl_relocate_assets_tl_rec.id,
1010: p_okl_relocate_assets_tl_rec.language);
1011: FETCH okl_relocate_assets_tl_pk_csr INTO
1012: l_okl_relocate_assets_tl_rec.ID,
1013: l_okl_relocate_assets_tl_rec.LANGUAGE,
1014: l_okl_relocate_assets_tl_rec.SOURCE_LANG,
1015: l_okl_relocate_assets_tl_rec.SFWT_FLAG,

Line 1012: l_okl_relocate_assets_tl_rec.ID,

1008: -- Get current database values
1009: OPEN okl_relocate_assets_tl_pk_csr (p_okl_relocate_assets_tl_rec.id,
1010: p_okl_relocate_assets_tl_rec.language);
1011: FETCH okl_relocate_assets_tl_pk_csr INTO
1012: l_okl_relocate_assets_tl_rec.ID,
1013: l_okl_relocate_assets_tl_rec.LANGUAGE,
1014: l_okl_relocate_assets_tl_rec.SOURCE_LANG,
1015: l_okl_relocate_assets_tl_rec.SFWT_FLAG,
1016: l_okl_relocate_assets_tl_rec.COMMENTS,

Line 1013: l_okl_relocate_assets_tl_rec.LANGUAGE,

1009: OPEN okl_relocate_assets_tl_pk_csr (p_okl_relocate_assets_tl_rec.id,
1010: p_okl_relocate_assets_tl_rec.language);
1011: FETCH okl_relocate_assets_tl_pk_csr INTO
1012: l_okl_relocate_assets_tl_rec.ID,
1013: l_okl_relocate_assets_tl_rec.LANGUAGE,
1014: l_okl_relocate_assets_tl_rec.SOURCE_LANG,
1015: l_okl_relocate_assets_tl_rec.SFWT_FLAG,
1016: l_okl_relocate_assets_tl_rec.COMMENTS,
1017: l_okl_relocate_assets_tl_rec.CREATED_BY,

Line 1014: l_okl_relocate_assets_tl_rec.SOURCE_LANG,

1010: p_okl_relocate_assets_tl_rec.language);
1011: FETCH okl_relocate_assets_tl_pk_csr INTO
1012: l_okl_relocate_assets_tl_rec.ID,
1013: l_okl_relocate_assets_tl_rec.LANGUAGE,
1014: l_okl_relocate_assets_tl_rec.SOURCE_LANG,
1015: l_okl_relocate_assets_tl_rec.SFWT_FLAG,
1016: l_okl_relocate_assets_tl_rec.COMMENTS,
1017: l_okl_relocate_assets_tl_rec.CREATED_BY,
1018: l_okl_relocate_assets_tl_rec.CREATION_DATE,

Line 1015: l_okl_relocate_assets_tl_rec.SFWT_FLAG,

1011: FETCH okl_relocate_assets_tl_pk_csr INTO
1012: l_okl_relocate_assets_tl_rec.ID,
1013: l_okl_relocate_assets_tl_rec.LANGUAGE,
1014: l_okl_relocate_assets_tl_rec.SOURCE_LANG,
1015: l_okl_relocate_assets_tl_rec.SFWT_FLAG,
1016: l_okl_relocate_assets_tl_rec.COMMENTS,
1017: l_okl_relocate_assets_tl_rec.CREATED_BY,
1018: l_okl_relocate_assets_tl_rec.CREATION_DATE,
1019: l_okl_relocate_assets_tl_rec.LAST_UPDATED_BY,

Line 1016: l_okl_relocate_assets_tl_rec.COMMENTS,

1012: l_okl_relocate_assets_tl_rec.ID,
1013: l_okl_relocate_assets_tl_rec.LANGUAGE,
1014: l_okl_relocate_assets_tl_rec.SOURCE_LANG,
1015: l_okl_relocate_assets_tl_rec.SFWT_FLAG,
1016: l_okl_relocate_assets_tl_rec.COMMENTS,
1017: l_okl_relocate_assets_tl_rec.CREATED_BY,
1018: l_okl_relocate_assets_tl_rec.CREATION_DATE,
1019: l_okl_relocate_assets_tl_rec.LAST_UPDATED_BY,
1020: l_okl_relocate_assets_tl_rec.LAST_UPDATE_DATE,

Line 1017: l_okl_relocate_assets_tl_rec.CREATED_BY,

1013: l_okl_relocate_assets_tl_rec.LANGUAGE,
1014: l_okl_relocate_assets_tl_rec.SOURCE_LANG,
1015: l_okl_relocate_assets_tl_rec.SFWT_FLAG,
1016: l_okl_relocate_assets_tl_rec.COMMENTS,
1017: l_okl_relocate_assets_tl_rec.CREATED_BY,
1018: l_okl_relocate_assets_tl_rec.CREATION_DATE,
1019: l_okl_relocate_assets_tl_rec.LAST_UPDATED_BY,
1020: l_okl_relocate_assets_tl_rec.LAST_UPDATE_DATE,
1021: l_okl_relocate_assets_tl_rec.LAST_UPDATE_LOGIN;

Line 1018: l_okl_relocate_assets_tl_rec.CREATION_DATE,

1014: l_okl_relocate_assets_tl_rec.SOURCE_LANG,
1015: l_okl_relocate_assets_tl_rec.SFWT_FLAG,
1016: l_okl_relocate_assets_tl_rec.COMMENTS,
1017: l_okl_relocate_assets_tl_rec.CREATED_BY,
1018: l_okl_relocate_assets_tl_rec.CREATION_DATE,
1019: l_okl_relocate_assets_tl_rec.LAST_UPDATED_BY,
1020: l_okl_relocate_assets_tl_rec.LAST_UPDATE_DATE,
1021: l_okl_relocate_assets_tl_rec.LAST_UPDATE_LOGIN;
1022: x_no_data_found := okl_relocate_assets_tl_pk_csr%NOTFOUND;

Line 1019: l_okl_relocate_assets_tl_rec.LAST_UPDATED_BY,

1015: l_okl_relocate_assets_tl_rec.SFWT_FLAG,
1016: l_okl_relocate_assets_tl_rec.COMMENTS,
1017: l_okl_relocate_assets_tl_rec.CREATED_BY,
1018: l_okl_relocate_assets_tl_rec.CREATION_DATE,
1019: l_okl_relocate_assets_tl_rec.LAST_UPDATED_BY,
1020: l_okl_relocate_assets_tl_rec.LAST_UPDATE_DATE,
1021: l_okl_relocate_assets_tl_rec.LAST_UPDATE_LOGIN;
1022: x_no_data_found := okl_relocate_assets_tl_pk_csr%NOTFOUND;
1023: CLOSE okl_relocate_assets_tl_pk_csr;

Line 1020: l_okl_relocate_assets_tl_rec.LAST_UPDATE_DATE,

1016: l_okl_relocate_assets_tl_rec.COMMENTS,
1017: l_okl_relocate_assets_tl_rec.CREATED_BY,
1018: l_okl_relocate_assets_tl_rec.CREATION_DATE,
1019: l_okl_relocate_assets_tl_rec.LAST_UPDATED_BY,
1020: l_okl_relocate_assets_tl_rec.LAST_UPDATE_DATE,
1021: l_okl_relocate_assets_tl_rec.LAST_UPDATE_LOGIN;
1022: x_no_data_found := okl_relocate_assets_tl_pk_csr%NOTFOUND;
1023: CLOSE okl_relocate_assets_tl_pk_csr;
1024: RETURN(l_okl_relocate_assets_tl_rec);

Line 1021: l_okl_relocate_assets_tl_rec.LAST_UPDATE_LOGIN;

1017: l_okl_relocate_assets_tl_rec.CREATED_BY,
1018: l_okl_relocate_assets_tl_rec.CREATION_DATE,
1019: l_okl_relocate_assets_tl_rec.LAST_UPDATED_BY,
1020: l_okl_relocate_assets_tl_rec.LAST_UPDATE_DATE,
1021: l_okl_relocate_assets_tl_rec.LAST_UPDATE_LOGIN;
1022: x_no_data_found := okl_relocate_assets_tl_pk_csr%NOTFOUND;
1023: CLOSE okl_relocate_assets_tl_pk_csr;
1024: RETURN(l_okl_relocate_assets_tl_rec);
1025: END get_rec;

Line 1022: x_no_data_found := okl_relocate_assets_tl_pk_csr%NOTFOUND;

1018: l_okl_relocate_assets_tl_rec.CREATION_DATE,
1019: l_okl_relocate_assets_tl_rec.LAST_UPDATED_BY,
1020: l_okl_relocate_assets_tl_rec.LAST_UPDATE_DATE,
1021: l_okl_relocate_assets_tl_rec.LAST_UPDATE_LOGIN;
1022: x_no_data_found := okl_relocate_assets_tl_pk_csr%NOTFOUND;
1023: CLOSE okl_relocate_assets_tl_pk_csr;
1024: RETURN(l_okl_relocate_assets_tl_rec);
1025: END get_rec;
1026:

Line 1023: CLOSE okl_relocate_assets_tl_pk_csr;

1019: l_okl_relocate_assets_tl_rec.LAST_UPDATED_BY,
1020: l_okl_relocate_assets_tl_rec.LAST_UPDATE_DATE,
1021: l_okl_relocate_assets_tl_rec.LAST_UPDATE_LOGIN;
1022: x_no_data_found := okl_relocate_assets_tl_pk_csr%NOTFOUND;
1023: CLOSE okl_relocate_assets_tl_pk_csr;
1024: RETURN(l_okl_relocate_assets_tl_rec);
1025: END get_rec;
1026:
1027: FUNCTION get_rec (

Line 1024: RETURN(l_okl_relocate_assets_tl_rec);

1020: l_okl_relocate_assets_tl_rec.LAST_UPDATE_DATE,
1021: l_okl_relocate_assets_tl_rec.LAST_UPDATE_LOGIN;
1022: x_no_data_found := okl_relocate_assets_tl_pk_csr%NOTFOUND;
1023: CLOSE okl_relocate_assets_tl_pk_csr;
1024: RETURN(l_okl_relocate_assets_tl_rec);
1025: END get_rec;
1026:
1027: FUNCTION get_rec (
1028: p_okl_relocate_assets_tl_rec IN OklRelocateAssetsTlRecType

Line 1028: p_okl_relocate_assets_tl_rec IN OklRelocateAssetsTlRecType

1024: RETURN(l_okl_relocate_assets_tl_rec);
1025: END get_rec;
1026:
1027: FUNCTION get_rec (
1028: p_okl_relocate_assets_tl_rec IN OklRelocateAssetsTlRecType
1029: ) RETURN OklRelocateAssetsTlRecType IS
1030: l_row_notfound BOOLEAN := TRUE;
1031: BEGIN
1032: RETURN(get_rec(p_okl_relocate_assets_tl_rec, l_row_notfound));

Line 1032: RETURN(get_rec(p_okl_relocate_assets_tl_rec, l_row_notfound));

1028: p_okl_relocate_assets_tl_rec IN OklRelocateAssetsTlRecType
1029: ) RETURN OklRelocateAssetsTlRecType IS
1030: l_row_notfound BOOLEAN := TRUE;
1031: BEGIN
1032: RETURN(get_rec(p_okl_relocate_assets_tl_rec, l_row_notfound));
1033: END get_rec;
1034: ---------------------------------------------------------------------------
1035: -- FUNCTION get_rec for: OKL_RELOCATE_ASSETS_V
1036: ---------------------------------------------------------------------------

Line 1681: l_okl_relocate_assets_tl_rec OklRelocateAssetsTlRecType;

1677: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
1678: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1679: l_rasv_rec rasv_rec_type := p_rasv_rec;
1680: l_ras_rec ras_rec_type;
1681: l_okl_relocate_assets_tl_rec OklRelocateAssetsTlRecType;
1682: BEGIN
1683: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1684: G_PKG_NAME,
1685: p_init_msg_list,

Line 2012: -- insert_row for:OKL_RELOCATE_ASSETS_TL --

2008: '_PVT'
2009: );
2010: END insert_row;
2011: -------------------------------------------
2012: -- insert_row for:OKL_RELOCATE_ASSETS_TL --
2013: -------------------------------------------
2014: PROCEDURE insert_row(
2015: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2016: x_return_status OUT NOCOPY VARCHAR2,

Line 2019: p_okl_relocate_assets_tl_rec IN OklRelocateAssetsTlRecType,

2015: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2016: x_return_status OUT NOCOPY VARCHAR2,
2017: x_msg_count OUT NOCOPY NUMBER,
2018: x_msg_data OUT NOCOPY VARCHAR2,
2019: p_okl_relocate_assets_tl_rec IN OklRelocateAssetsTlRecType,
2020: x_okl_relocate_assets_tl_rec OUT NOCOPY OklRelocateAssetsTlRecType) IS
2021:
2022: l_api_version CONSTANT NUMBER := 1;
2023: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';

Line 2020: x_okl_relocate_assets_tl_rec OUT NOCOPY OklRelocateAssetsTlRecType) IS

2016: x_return_status OUT NOCOPY VARCHAR2,
2017: x_msg_count OUT NOCOPY NUMBER,
2018: x_msg_data OUT NOCOPY VARCHAR2,
2019: p_okl_relocate_assets_tl_rec IN OklRelocateAssetsTlRecType,
2020: x_okl_relocate_assets_tl_rec OUT NOCOPY OklRelocateAssetsTlRecType) IS
2021:
2022: l_api_version CONSTANT NUMBER := 1;
2023: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
2024: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2025: l_okl_relocate_assets_tl_rec OklRelocateAssetsTlRecType := p_okl_relocate_assets_tl_rec;

2021:
2022: l_api_version CONSTANT NUMBER := 1;
2023: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
2024: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2025: l_okl_relocate_assets_tl_rec OklRelocateAssetsTlRecType := p_okl_relocate_assets_tl_rec;
2026: ldefoklrelocateassetstlrec OklRelocateAssetsTlRecType;
2027: CURSOR get_languages IS
2028: SELECT *
2029: FROM FND_LANGUAGES

Line 2032: -- Set_Attributes for:OKL_RELOCATE_ASSETS_TL --

2028: SELECT *
2029: FROM FND_LANGUAGES
2030: WHERE INSTALLED_FLAG IN ('I', 'B');
2031: -----------------------------------------------
2032: -- Set_Attributes for:OKL_RELOCATE_ASSETS_TL --
2033: -----------------------------------------------
2034: FUNCTION Set_Attributes (
2035: p_okl_relocate_assets_tl_rec IN OklRelocateAssetsTlRecType,
2036: x_okl_relocate_assets_tl_rec OUT NOCOPY OklRelocateAssetsTlRecType

Line 2035: p_okl_relocate_assets_tl_rec IN OklRelocateAssetsTlRecType,

2031: -----------------------------------------------
2032: -- Set_Attributes for:OKL_RELOCATE_ASSETS_TL --
2033: -----------------------------------------------
2034: FUNCTION Set_Attributes (
2035: p_okl_relocate_assets_tl_rec IN OklRelocateAssetsTlRecType,
2036: x_okl_relocate_assets_tl_rec OUT NOCOPY OklRelocateAssetsTlRecType
2037: ) RETURN VARCHAR2 IS
2038: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2039: BEGIN

Line 2036: x_okl_relocate_assets_tl_rec OUT NOCOPY OklRelocateAssetsTlRecType

2032: -- Set_Attributes for:OKL_RELOCATE_ASSETS_TL --
2033: -----------------------------------------------
2034: FUNCTION Set_Attributes (
2035: p_okl_relocate_assets_tl_rec IN OklRelocateAssetsTlRecType,
2036: x_okl_relocate_assets_tl_rec OUT NOCOPY OklRelocateAssetsTlRecType
2037: ) RETURN VARCHAR2 IS
2038: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2039: BEGIN
2040: x_okl_relocate_assets_tl_rec := p_okl_relocate_assets_tl_rec;

Line 2040: x_okl_relocate_assets_tl_rec := p_okl_relocate_assets_tl_rec;

2036: x_okl_relocate_assets_tl_rec OUT NOCOPY OklRelocateAssetsTlRecType
2037: ) RETURN VARCHAR2 IS
2038: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2039: BEGIN
2040: x_okl_relocate_assets_tl_rec := p_okl_relocate_assets_tl_rec;
2041: x_okl_relocate_assets_tl_rec.LANGUAGE := USERENV('LANG');
2042: x_okl_relocate_assets_tl_rec.SOURCE_LANG := USERENV('LANG');
2043: RETURN(l_return_status);
2044: END Set_Attributes;

Line 2041: x_okl_relocate_assets_tl_rec.LANGUAGE := USERENV('LANG');

2037: ) RETURN VARCHAR2 IS
2038: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2039: BEGIN
2040: x_okl_relocate_assets_tl_rec := p_okl_relocate_assets_tl_rec;
2041: x_okl_relocate_assets_tl_rec.LANGUAGE := USERENV('LANG');
2042: x_okl_relocate_assets_tl_rec.SOURCE_LANG := USERENV('LANG');
2043: RETURN(l_return_status);
2044: END Set_Attributes;
2045: BEGIN

Line 2042: x_okl_relocate_assets_tl_rec.SOURCE_LANG := USERENV('LANG');

2038: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2039: BEGIN
2040: x_okl_relocate_assets_tl_rec := p_okl_relocate_assets_tl_rec;
2041: x_okl_relocate_assets_tl_rec.LANGUAGE := USERENV('LANG');
2042: x_okl_relocate_assets_tl_rec.SOURCE_LANG := USERENV('LANG');
2043: RETURN(l_return_status);
2044: END Set_Attributes;
2045: BEGIN
2046: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2057: p_okl_relocate_assets_tl_rec, -- IN

2053: RAISE OKC_API.G_EXCEPTION_ERROR;
2054: END IF;
2055: --- Setting item attributes
2056: l_return_status := Set_Attributes(
2057: p_okl_relocate_assets_tl_rec, -- IN
2058: l_okl_relocate_assets_tl_rec); -- OUT
2059: --- If any errors happen abort API
2060: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2061: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2058: l_okl_relocate_assets_tl_rec); -- OUT

2054: END IF;
2055: --- Setting item attributes
2056: l_return_status := Set_Attributes(
2057: p_okl_relocate_assets_tl_rec, -- IN
2058: l_okl_relocate_assets_tl_rec); -- OUT
2059: --- If any errors happen abort API
2060: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2061: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2062: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2066: l_okl_relocate_assets_tl_rec.language := l_lang_rec.language_code;

2062: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2063: RAISE OKC_API.G_EXCEPTION_ERROR;
2064: END IF;
2065: FOR l_lang_rec IN get_languages LOOP
2066: l_okl_relocate_assets_tl_rec.language := l_lang_rec.language_code;
2067: INSERT INTO OKL_RELOCATE_ASSETS_TL(
2068: id,
2069: language,
2070: source_lang,

Line 2067: INSERT INTO OKL_RELOCATE_ASSETS_TL(

2063: RAISE OKC_API.G_EXCEPTION_ERROR;
2064: END IF;
2065: FOR l_lang_rec IN get_languages LOOP
2066: l_okl_relocate_assets_tl_rec.language := l_lang_rec.language_code;
2067: INSERT INTO OKL_RELOCATE_ASSETS_TL(
2068: id,
2069: language,
2070: source_lang,
2071: sfwt_flag,

Line 2079: l_okl_relocate_assets_tl_rec.id,

2075: last_updated_by,
2076: last_update_date,
2077: last_update_login)
2078: VALUES (
2079: l_okl_relocate_assets_tl_rec.id,
2080: l_okl_relocate_assets_tl_rec.language,
2081: l_okl_relocate_assets_tl_rec.source_lang,
2082: l_okl_relocate_assets_tl_rec.sfwt_flag,
2083: l_okl_relocate_assets_tl_rec.comments,

Line 2080: l_okl_relocate_assets_tl_rec.language,

2076: last_update_date,
2077: last_update_login)
2078: VALUES (
2079: l_okl_relocate_assets_tl_rec.id,
2080: l_okl_relocate_assets_tl_rec.language,
2081: l_okl_relocate_assets_tl_rec.source_lang,
2082: l_okl_relocate_assets_tl_rec.sfwt_flag,
2083: l_okl_relocate_assets_tl_rec.comments,
2084: l_okl_relocate_assets_tl_rec.created_by,

Line 2081: l_okl_relocate_assets_tl_rec.source_lang,

2077: last_update_login)
2078: VALUES (
2079: l_okl_relocate_assets_tl_rec.id,
2080: l_okl_relocate_assets_tl_rec.language,
2081: l_okl_relocate_assets_tl_rec.source_lang,
2082: l_okl_relocate_assets_tl_rec.sfwt_flag,
2083: l_okl_relocate_assets_tl_rec.comments,
2084: l_okl_relocate_assets_tl_rec.created_by,
2085: l_okl_relocate_assets_tl_rec.creation_date,

Line 2082: l_okl_relocate_assets_tl_rec.sfwt_flag,

2078: VALUES (
2079: l_okl_relocate_assets_tl_rec.id,
2080: l_okl_relocate_assets_tl_rec.language,
2081: l_okl_relocate_assets_tl_rec.source_lang,
2082: l_okl_relocate_assets_tl_rec.sfwt_flag,
2083: l_okl_relocate_assets_tl_rec.comments,
2084: l_okl_relocate_assets_tl_rec.created_by,
2085: l_okl_relocate_assets_tl_rec.creation_date,
2086: l_okl_relocate_assets_tl_rec.last_updated_by,

Line 2083: l_okl_relocate_assets_tl_rec.comments,

2079: l_okl_relocate_assets_tl_rec.id,
2080: l_okl_relocate_assets_tl_rec.language,
2081: l_okl_relocate_assets_tl_rec.source_lang,
2082: l_okl_relocate_assets_tl_rec.sfwt_flag,
2083: l_okl_relocate_assets_tl_rec.comments,
2084: l_okl_relocate_assets_tl_rec.created_by,
2085: l_okl_relocate_assets_tl_rec.creation_date,
2086: l_okl_relocate_assets_tl_rec.last_updated_by,
2087: l_okl_relocate_assets_tl_rec.last_update_date,

Line 2084: l_okl_relocate_assets_tl_rec.created_by,

2080: l_okl_relocate_assets_tl_rec.language,
2081: l_okl_relocate_assets_tl_rec.source_lang,
2082: l_okl_relocate_assets_tl_rec.sfwt_flag,
2083: l_okl_relocate_assets_tl_rec.comments,
2084: l_okl_relocate_assets_tl_rec.created_by,
2085: l_okl_relocate_assets_tl_rec.creation_date,
2086: l_okl_relocate_assets_tl_rec.last_updated_by,
2087: l_okl_relocate_assets_tl_rec.last_update_date,
2088: l_okl_relocate_assets_tl_rec.last_update_login);

Line 2085: l_okl_relocate_assets_tl_rec.creation_date,

2081: l_okl_relocate_assets_tl_rec.source_lang,
2082: l_okl_relocate_assets_tl_rec.sfwt_flag,
2083: l_okl_relocate_assets_tl_rec.comments,
2084: l_okl_relocate_assets_tl_rec.created_by,
2085: l_okl_relocate_assets_tl_rec.creation_date,
2086: l_okl_relocate_assets_tl_rec.last_updated_by,
2087: l_okl_relocate_assets_tl_rec.last_update_date,
2088: l_okl_relocate_assets_tl_rec.last_update_login);
2089: END LOOP;

Line 2086: l_okl_relocate_assets_tl_rec.last_updated_by,

2082: l_okl_relocate_assets_tl_rec.sfwt_flag,
2083: l_okl_relocate_assets_tl_rec.comments,
2084: l_okl_relocate_assets_tl_rec.created_by,
2085: l_okl_relocate_assets_tl_rec.creation_date,
2086: l_okl_relocate_assets_tl_rec.last_updated_by,
2087: l_okl_relocate_assets_tl_rec.last_update_date,
2088: l_okl_relocate_assets_tl_rec.last_update_login);
2089: END LOOP;
2090: -- Set OUT values

Line 2087: l_okl_relocate_assets_tl_rec.last_update_date,

2083: l_okl_relocate_assets_tl_rec.comments,
2084: l_okl_relocate_assets_tl_rec.created_by,
2085: l_okl_relocate_assets_tl_rec.creation_date,
2086: l_okl_relocate_assets_tl_rec.last_updated_by,
2087: l_okl_relocate_assets_tl_rec.last_update_date,
2088: l_okl_relocate_assets_tl_rec.last_update_login);
2089: END LOOP;
2090: -- Set OUT values
2091: x_okl_relocate_assets_tl_rec := l_okl_relocate_assets_tl_rec;

Line 2088: l_okl_relocate_assets_tl_rec.last_update_login);

2084: l_okl_relocate_assets_tl_rec.created_by,
2085: l_okl_relocate_assets_tl_rec.creation_date,
2086: l_okl_relocate_assets_tl_rec.last_updated_by,
2087: l_okl_relocate_assets_tl_rec.last_update_date,
2088: l_okl_relocate_assets_tl_rec.last_update_login);
2089: END LOOP;
2090: -- Set OUT values
2091: x_okl_relocate_assets_tl_rec := l_okl_relocate_assets_tl_rec;
2092: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2091: x_okl_relocate_assets_tl_rec := l_okl_relocate_assets_tl_rec;

2087: l_okl_relocate_assets_tl_rec.last_update_date,
2088: l_okl_relocate_assets_tl_rec.last_update_login);
2089: END LOOP;
2090: -- Set OUT values
2091: x_okl_relocate_assets_tl_rec := l_okl_relocate_assets_tl_rec;
2092: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2093: EXCEPTION
2094: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2095: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 2154: l_okl_relocate_assets_tl_rec OklRelocateAssetsTlRecType;

2150: l_rasv_rec rasv_rec_type;
2151: l_def_rasv_rec rasv_rec_type;
2152: l_ras_rec ras_rec_type;
2153: lx_ras_rec ras_rec_type;
2154: l_okl_relocate_assets_tl_rec OklRelocateAssetsTlRecType;
2155: lx_okl_relocate_assets_tl_rec OklRelocateAssetsTlRecType;
2156: -------------------------------
2157: -- FUNCTION fill_who_columns --
2158: -------------------------------

Line 2155: lx_okl_relocate_assets_tl_rec OklRelocateAssetsTlRecType;

2151: l_def_rasv_rec rasv_rec_type;
2152: l_ras_rec ras_rec_type;
2153: lx_ras_rec ras_rec_type;
2154: l_okl_relocate_assets_tl_rec OklRelocateAssetsTlRecType;
2155: lx_okl_relocate_assets_tl_rec OklRelocateAssetsTlRecType;
2156: -------------------------------
2157: -- FUNCTION fill_who_columns --
2158: -------------------------------
2159: FUNCTION fill_who_columns (

Line 2243: migrate(l_def_rasv_rec, l_okl_relocate_assets_tl_rec);

2239: --------------------------------------
2240: -- Move VIEW record to "Child" records
2241: --------------------------------------
2242: migrate(l_def_rasv_rec, l_ras_rec);
2243: migrate(l_def_rasv_rec, l_okl_relocate_assets_tl_rec);
2244: --------------------------------------------
2245: -- Call the INSERT_ROW for each child record
2246: --------------------------------------------
2247: insert_row(

Line 2266: l_okl_relocate_assets_tl_rec,

2262: p_init_msg_list,
2263: x_return_status,
2264: x_msg_count,
2265: x_msg_data,
2266: l_okl_relocate_assets_tl_rec,
2267: lx_okl_relocate_assets_tl_rec
2268: );
2269: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2270: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2267: lx_okl_relocate_assets_tl_rec

2263: x_return_status,
2264: x_msg_count,
2265: x_msg_data,
2266: l_okl_relocate_assets_tl_rec,
2267: lx_okl_relocate_assets_tl_rec
2268: );
2269: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2270: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2271: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2274: migrate(lx_okl_relocate_assets_tl_rec, l_def_rasv_rec);

2270: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2271: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2272: RAISE OKC_API.G_EXCEPTION_ERROR;
2273: END IF;
2274: migrate(lx_okl_relocate_assets_tl_rec, l_def_rasv_rec);
2275: -- Set OUT values
2276: x_rasv_rec := l_def_rasv_rec;
2277: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2278: EXCEPTION

Line 2503: -- lock_row for:OKL_RELOCATE_ASSETS_TL --

2499: '_PVT'
2500: );
2501: END lock_row;
2502: -----------------------------------------
2503: -- lock_row for:OKL_RELOCATE_ASSETS_TL --
2504: -----------------------------------------
2505: PROCEDURE lock_row(
2506: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2507: x_return_status OUT NOCOPY VARCHAR2,

Line 2510: p_okl_relocate_assets_tl_rec IN OklRelocateAssetsTlRecType) IS

2506: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2507: x_return_status OUT NOCOPY VARCHAR2,
2508: x_msg_count OUT NOCOPY NUMBER,
2509: x_msg_data OUT NOCOPY VARCHAR2,
2510: p_okl_relocate_assets_tl_rec IN OklRelocateAssetsTlRecType) IS
2511:
2512: E_Resource_Busy EXCEPTION;
2513: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2514: CURSOR lock_csr (p_okl_relocate_assets_tl_rec IN OklRelocateAssetsTlRecType) IS

Line 2514: CURSOR lock_csr (p_okl_relocate_assets_tl_rec IN OklRelocateAssetsTlRecType) IS

2510: p_okl_relocate_assets_tl_rec IN OklRelocateAssetsTlRecType) IS
2511:
2512: E_Resource_Busy EXCEPTION;
2513: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2514: CURSOR lock_csr (p_okl_relocate_assets_tl_rec IN OklRelocateAssetsTlRecType) IS
2515: SELECT *
2516: FROM OKL_RELOCATE_ASSETS_TL
2517: WHERE ID = p_okl_relocate_assets_tl_rec.id
2518: FOR UPDATE NOWAIT;

Line 2516: FROM OKL_RELOCATE_ASSETS_TL

2512: E_Resource_Busy EXCEPTION;
2513: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2514: CURSOR lock_csr (p_okl_relocate_assets_tl_rec IN OklRelocateAssetsTlRecType) IS
2515: SELECT *
2516: FROM OKL_RELOCATE_ASSETS_TL
2517: WHERE ID = p_okl_relocate_assets_tl_rec.id
2518: FOR UPDATE NOWAIT;
2519:
2520: l_api_version CONSTANT NUMBER := 1;

Line 2517: WHERE ID = p_okl_relocate_assets_tl_rec.id

2513: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2514: CURSOR lock_csr (p_okl_relocate_assets_tl_rec IN OklRelocateAssetsTlRecType) IS
2515: SELECT *
2516: FROM OKL_RELOCATE_ASSETS_TL
2517: WHERE ID = p_okl_relocate_assets_tl_rec.id
2518: FOR UPDATE NOWAIT;
2519:
2520: l_api_version CONSTANT NUMBER := 1;
2521: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';

Line 2537: OPEN lock_csr(p_okl_relocate_assets_tl_rec);

2533: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2534: RAISE OKC_API.G_EXCEPTION_ERROR;
2535: END IF;
2536: BEGIN
2537: OPEN lock_csr(p_okl_relocate_assets_tl_rec);
2538: FETCH lock_csr INTO l_lock_var;
2539: l_row_notfound := lock_csr%NOTFOUND;
2540: CLOSE lock_csr;
2541: EXCEPTION

Line 2602: l_okl_relocate_assets_tl_rec OklRelocateAssetsTlRecType;

2598: l_api_version CONSTANT NUMBER := 1;
2599: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
2600: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2601: l_ras_rec ras_rec_type;
2602: l_okl_relocate_assets_tl_rec OklRelocateAssetsTlRecType;
2603: BEGIN
2604: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2605: G_PKG_NAME,
2606: p_init_msg_list,

Line 2620: migrate(p_rasv_rec, l_okl_relocate_assets_tl_rec);

2616: --------------------------------------
2617: -- Move VIEW record to "Child" records
2618: --------------------------------------
2619: migrate(p_rasv_rec, l_ras_rec);
2620: migrate(p_rasv_rec, l_okl_relocate_assets_tl_rec);
2621: --------------------------------------------
2622: -- Call the LOCK_ROW for each child record
2623: --------------------------------------------
2624: lock_row(

Line 2641: l_okl_relocate_assets_tl_rec

2637: p_init_msg_list,
2638: x_return_status,
2639: x_msg_count,
2640: x_msg_data,
2641: l_okl_relocate_assets_tl_rec
2642: );
2643: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2644: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2645: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 3085: -- update_row for:OKL_RELOCATE_ASSETS_TL --

3081: '_PVT'
3082: );
3083: END update_row;
3084: -------------------------------------------
3085: -- update_row for:OKL_RELOCATE_ASSETS_TL --
3086: -------------------------------------------
3087: PROCEDURE update_row(
3088: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3089: x_return_status OUT NOCOPY VARCHAR2,

Line 3092: p_okl_relocate_assets_tl_rec IN OklRelocateAssetsTlRecType,

3088: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3089: x_return_status OUT NOCOPY VARCHAR2,
3090: x_msg_count OUT NOCOPY NUMBER,
3091: x_msg_data OUT NOCOPY VARCHAR2,
3092: p_okl_relocate_assets_tl_rec IN OklRelocateAssetsTlRecType,
3093: x_okl_relocate_assets_tl_rec OUT NOCOPY OklRelocateAssetsTlRecType) IS
3094:
3095: l_api_version CONSTANT NUMBER := 1;
3096: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';

Line 3093: x_okl_relocate_assets_tl_rec OUT NOCOPY OklRelocateAssetsTlRecType) IS

3089: x_return_status OUT NOCOPY VARCHAR2,
3090: x_msg_count OUT NOCOPY NUMBER,
3091: x_msg_data OUT NOCOPY VARCHAR2,
3092: p_okl_relocate_assets_tl_rec IN OklRelocateAssetsTlRecType,
3093: x_okl_relocate_assets_tl_rec OUT NOCOPY OklRelocateAssetsTlRecType) IS
3094:
3095: l_api_version CONSTANT NUMBER := 1;
3096: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
3097: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 3098: l_okl_relocate_assets_tl_rec OklRelocateAssetsTlRecType := p_okl_relocate_assets_tl_rec;

3094:
3095: l_api_version CONSTANT NUMBER := 1;
3096: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
3097: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3098: l_okl_relocate_assets_tl_rec OklRelocateAssetsTlRecType := p_okl_relocate_assets_tl_rec;
3099: ldefoklrelocateassetstlrec OklRelocateAssetsTlRecType;
3100: l_row_notfound BOOLEAN := TRUE;
3101: ----------------------------------
3102: -- FUNCTION populate_new_record --

Line 3105: p_okl_relocate_assets_tl_rec IN OklRelocateAssetsTlRecType,

3101: ----------------------------------
3102: -- FUNCTION populate_new_record --
3103: ----------------------------------
3104: FUNCTION populate_new_record (
3105: p_okl_relocate_assets_tl_rec IN OklRelocateAssetsTlRecType,
3106: x_okl_relocate_assets_tl_rec OUT NOCOPY OklRelocateAssetsTlRecType
3107: ) RETURN VARCHAR2 IS
3108: l_okl_relocate_assets_tl_rec OklRelocateAssetsTlRecType;
3109: l_row_notfound BOOLEAN := TRUE;

Line 3106: x_okl_relocate_assets_tl_rec OUT NOCOPY OklRelocateAssetsTlRecType

3102: -- FUNCTION populate_new_record --
3103: ----------------------------------
3104: FUNCTION populate_new_record (
3105: p_okl_relocate_assets_tl_rec IN OklRelocateAssetsTlRecType,
3106: x_okl_relocate_assets_tl_rec OUT NOCOPY OklRelocateAssetsTlRecType
3107: ) RETURN VARCHAR2 IS
3108: l_okl_relocate_assets_tl_rec OklRelocateAssetsTlRecType;
3109: l_row_notfound BOOLEAN := TRUE;
3110: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 3108: l_okl_relocate_assets_tl_rec OklRelocateAssetsTlRecType;

3104: FUNCTION populate_new_record (
3105: p_okl_relocate_assets_tl_rec IN OklRelocateAssetsTlRecType,
3106: x_okl_relocate_assets_tl_rec OUT NOCOPY OklRelocateAssetsTlRecType
3107: ) RETURN VARCHAR2 IS
3108: l_okl_relocate_assets_tl_rec OklRelocateAssetsTlRecType;
3109: l_row_notfound BOOLEAN := TRUE;
3110: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3111: BEGIN
3112: x_okl_relocate_assets_tl_rec := p_okl_relocate_assets_tl_rec;

Line 3112: x_okl_relocate_assets_tl_rec := p_okl_relocate_assets_tl_rec;

3108: l_okl_relocate_assets_tl_rec OklRelocateAssetsTlRecType;
3109: l_row_notfound BOOLEAN := TRUE;
3110: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3111: BEGIN
3112: x_okl_relocate_assets_tl_rec := p_okl_relocate_assets_tl_rec;
3113: -- Get current database values
3114: l_okl_relocate_assets_tl_rec := get_rec(p_okl_relocate_assets_tl_rec, l_row_notfound);
3115: IF (l_row_notfound) THEN
3116: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

Line 3114: l_okl_relocate_assets_tl_rec := get_rec(p_okl_relocate_assets_tl_rec, l_row_notfound);

3110: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3111: BEGIN
3112: x_okl_relocate_assets_tl_rec := p_okl_relocate_assets_tl_rec;
3113: -- Get current database values
3114: l_okl_relocate_assets_tl_rec := get_rec(p_okl_relocate_assets_tl_rec, l_row_notfound);
3115: IF (l_row_notfound) THEN
3116: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
3117: END IF;
3118: IF (x_okl_relocate_assets_tl_rec.id = OKC_API.G_MISS_NUM)

Line 3118: IF (x_okl_relocate_assets_tl_rec.id = OKC_API.G_MISS_NUM)

3114: l_okl_relocate_assets_tl_rec := get_rec(p_okl_relocate_assets_tl_rec, l_row_notfound);
3115: IF (l_row_notfound) THEN
3116: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
3117: END IF;
3118: IF (x_okl_relocate_assets_tl_rec.id = OKC_API.G_MISS_NUM)
3119: THEN
3120: x_okl_relocate_assets_tl_rec.id := l_okl_relocate_assets_tl_rec.id;
3121: END IF;
3122: IF (x_okl_relocate_assets_tl_rec.language = OKC_API.G_MISS_CHAR)

Line 3120: x_okl_relocate_assets_tl_rec.id := l_okl_relocate_assets_tl_rec.id;

3116: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
3117: END IF;
3118: IF (x_okl_relocate_assets_tl_rec.id = OKC_API.G_MISS_NUM)
3119: THEN
3120: x_okl_relocate_assets_tl_rec.id := l_okl_relocate_assets_tl_rec.id;
3121: END IF;
3122: IF (x_okl_relocate_assets_tl_rec.language = OKC_API.G_MISS_CHAR)
3123: THEN
3124: x_okl_relocate_assets_tl_rec.language := l_okl_relocate_assets_tl_rec.language;

Line 3122: IF (x_okl_relocate_assets_tl_rec.language = OKC_API.G_MISS_CHAR)

3118: IF (x_okl_relocate_assets_tl_rec.id = OKC_API.G_MISS_NUM)
3119: THEN
3120: x_okl_relocate_assets_tl_rec.id := l_okl_relocate_assets_tl_rec.id;
3121: END IF;
3122: IF (x_okl_relocate_assets_tl_rec.language = OKC_API.G_MISS_CHAR)
3123: THEN
3124: x_okl_relocate_assets_tl_rec.language := l_okl_relocate_assets_tl_rec.language;
3125: END IF;
3126: IF (x_okl_relocate_assets_tl_rec.source_lang = OKC_API.G_MISS_CHAR)

Line 3124: x_okl_relocate_assets_tl_rec.language := l_okl_relocate_assets_tl_rec.language;

3120: x_okl_relocate_assets_tl_rec.id := l_okl_relocate_assets_tl_rec.id;
3121: END IF;
3122: IF (x_okl_relocate_assets_tl_rec.language = OKC_API.G_MISS_CHAR)
3123: THEN
3124: x_okl_relocate_assets_tl_rec.language := l_okl_relocate_assets_tl_rec.language;
3125: END IF;
3126: IF (x_okl_relocate_assets_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
3127: THEN
3128: x_okl_relocate_assets_tl_rec.source_lang := l_okl_relocate_assets_tl_rec.source_lang;

Line 3126: IF (x_okl_relocate_assets_tl_rec.source_lang = OKC_API.G_MISS_CHAR)

3122: IF (x_okl_relocate_assets_tl_rec.language = OKC_API.G_MISS_CHAR)
3123: THEN
3124: x_okl_relocate_assets_tl_rec.language := l_okl_relocate_assets_tl_rec.language;
3125: END IF;
3126: IF (x_okl_relocate_assets_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
3127: THEN
3128: x_okl_relocate_assets_tl_rec.source_lang := l_okl_relocate_assets_tl_rec.source_lang;
3129: END IF;
3130: IF (x_okl_relocate_assets_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)

Line 3128: x_okl_relocate_assets_tl_rec.source_lang := l_okl_relocate_assets_tl_rec.source_lang;

3124: x_okl_relocate_assets_tl_rec.language := l_okl_relocate_assets_tl_rec.language;
3125: END IF;
3126: IF (x_okl_relocate_assets_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
3127: THEN
3128: x_okl_relocate_assets_tl_rec.source_lang := l_okl_relocate_assets_tl_rec.source_lang;
3129: END IF;
3130: IF (x_okl_relocate_assets_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
3131: THEN
3132: x_okl_relocate_assets_tl_rec.sfwt_flag := l_okl_relocate_assets_tl_rec.sfwt_flag;

Line 3130: IF (x_okl_relocate_assets_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)

3126: IF (x_okl_relocate_assets_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
3127: THEN
3128: x_okl_relocate_assets_tl_rec.source_lang := l_okl_relocate_assets_tl_rec.source_lang;
3129: END IF;
3130: IF (x_okl_relocate_assets_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
3131: THEN
3132: x_okl_relocate_assets_tl_rec.sfwt_flag := l_okl_relocate_assets_tl_rec.sfwt_flag;
3133: END IF;
3134: IF (x_okl_relocate_assets_tl_rec.comments = OKC_API.G_MISS_CHAR)

Line 3132: x_okl_relocate_assets_tl_rec.sfwt_flag := l_okl_relocate_assets_tl_rec.sfwt_flag;

3128: x_okl_relocate_assets_tl_rec.source_lang := l_okl_relocate_assets_tl_rec.source_lang;
3129: END IF;
3130: IF (x_okl_relocate_assets_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
3131: THEN
3132: x_okl_relocate_assets_tl_rec.sfwt_flag := l_okl_relocate_assets_tl_rec.sfwt_flag;
3133: END IF;
3134: IF (x_okl_relocate_assets_tl_rec.comments = OKC_API.G_MISS_CHAR)
3135: THEN
3136: x_okl_relocate_assets_tl_rec.comments := l_okl_relocate_assets_tl_rec.comments;

Line 3134: IF (x_okl_relocate_assets_tl_rec.comments = OKC_API.G_MISS_CHAR)

3130: IF (x_okl_relocate_assets_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
3131: THEN
3132: x_okl_relocate_assets_tl_rec.sfwt_flag := l_okl_relocate_assets_tl_rec.sfwt_flag;
3133: END IF;
3134: IF (x_okl_relocate_assets_tl_rec.comments = OKC_API.G_MISS_CHAR)
3135: THEN
3136: x_okl_relocate_assets_tl_rec.comments := l_okl_relocate_assets_tl_rec.comments;
3137: END IF;
3138: IF (x_okl_relocate_assets_tl_rec.created_by = OKC_API.G_MISS_NUM)

Line 3136: x_okl_relocate_assets_tl_rec.comments := l_okl_relocate_assets_tl_rec.comments;

3132: x_okl_relocate_assets_tl_rec.sfwt_flag := l_okl_relocate_assets_tl_rec.sfwt_flag;
3133: END IF;
3134: IF (x_okl_relocate_assets_tl_rec.comments = OKC_API.G_MISS_CHAR)
3135: THEN
3136: x_okl_relocate_assets_tl_rec.comments := l_okl_relocate_assets_tl_rec.comments;
3137: END IF;
3138: IF (x_okl_relocate_assets_tl_rec.created_by = OKC_API.G_MISS_NUM)
3139: THEN
3140: x_okl_relocate_assets_tl_rec.created_by := l_okl_relocate_assets_tl_rec.created_by;

Line 3138: IF (x_okl_relocate_assets_tl_rec.created_by = OKC_API.G_MISS_NUM)

3134: IF (x_okl_relocate_assets_tl_rec.comments = OKC_API.G_MISS_CHAR)
3135: THEN
3136: x_okl_relocate_assets_tl_rec.comments := l_okl_relocate_assets_tl_rec.comments;
3137: END IF;
3138: IF (x_okl_relocate_assets_tl_rec.created_by = OKC_API.G_MISS_NUM)
3139: THEN
3140: x_okl_relocate_assets_tl_rec.created_by := l_okl_relocate_assets_tl_rec.created_by;
3141: END IF;
3142: IF (x_okl_relocate_assets_tl_rec.creation_date = OKC_API.G_MISS_DATE)

Line 3140: x_okl_relocate_assets_tl_rec.created_by := l_okl_relocate_assets_tl_rec.created_by;

3136: x_okl_relocate_assets_tl_rec.comments := l_okl_relocate_assets_tl_rec.comments;
3137: END IF;
3138: IF (x_okl_relocate_assets_tl_rec.created_by = OKC_API.G_MISS_NUM)
3139: THEN
3140: x_okl_relocate_assets_tl_rec.created_by := l_okl_relocate_assets_tl_rec.created_by;
3141: END IF;
3142: IF (x_okl_relocate_assets_tl_rec.creation_date = OKC_API.G_MISS_DATE)
3143: THEN
3144: x_okl_relocate_assets_tl_rec.creation_date := l_okl_relocate_assets_tl_rec.creation_date;

Line 3142: IF (x_okl_relocate_assets_tl_rec.creation_date = OKC_API.G_MISS_DATE)

3138: IF (x_okl_relocate_assets_tl_rec.created_by = OKC_API.G_MISS_NUM)
3139: THEN
3140: x_okl_relocate_assets_tl_rec.created_by := l_okl_relocate_assets_tl_rec.created_by;
3141: END IF;
3142: IF (x_okl_relocate_assets_tl_rec.creation_date = OKC_API.G_MISS_DATE)
3143: THEN
3144: x_okl_relocate_assets_tl_rec.creation_date := l_okl_relocate_assets_tl_rec.creation_date;
3145: END IF;
3146: IF (x_okl_relocate_assets_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)

Line 3144: x_okl_relocate_assets_tl_rec.creation_date := l_okl_relocate_assets_tl_rec.creation_date;

3140: x_okl_relocate_assets_tl_rec.created_by := l_okl_relocate_assets_tl_rec.created_by;
3141: END IF;
3142: IF (x_okl_relocate_assets_tl_rec.creation_date = OKC_API.G_MISS_DATE)
3143: THEN
3144: x_okl_relocate_assets_tl_rec.creation_date := l_okl_relocate_assets_tl_rec.creation_date;
3145: END IF;
3146: IF (x_okl_relocate_assets_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
3147: THEN
3148: x_okl_relocate_assets_tl_rec.last_updated_by := l_okl_relocate_assets_tl_rec.last_updated_by;

Line 3146: IF (x_okl_relocate_assets_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)

3142: IF (x_okl_relocate_assets_tl_rec.creation_date = OKC_API.G_MISS_DATE)
3143: THEN
3144: x_okl_relocate_assets_tl_rec.creation_date := l_okl_relocate_assets_tl_rec.creation_date;
3145: END IF;
3146: IF (x_okl_relocate_assets_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
3147: THEN
3148: x_okl_relocate_assets_tl_rec.last_updated_by := l_okl_relocate_assets_tl_rec.last_updated_by;
3149: END IF;
3150: IF (x_okl_relocate_assets_tl_rec.last_update_date = OKC_API.G_MISS_DATE)

Line 3148: x_okl_relocate_assets_tl_rec.last_updated_by := l_okl_relocate_assets_tl_rec.last_updated_by;

3144: x_okl_relocate_assets_tl_rec.creation_date := l_okl_relocate_assets_tl_rec.creation_date;
3145: END IF;
3146: IF (x_okl_relocate_assets_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
3147: THEN
3148: x_okl_relocate_assets_tl_rec.last_updated_by := l_okl_relocate_assets_tl_rec.last_updated_by;
3149: END IF;
3150: IF (x_okl_relocate_assets_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
3151: THEN
3152: x_okl_relocate_assets_tl_rec.last_update_date := l_okl_relocate_assets_tl_rec.last_update_date;

Line 3150: IF (x_okl_relocate_assets_tl_rec.last_update_date = OKC_API.G_MISS_DATE)

3146: IF (x_okl_relocate_assets_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
3147: THEN
3148: x_okl_relocate_assets_tl_rec.last_updated_by := l_okl_relocate_assets_tl_rec.last_updated_by;
3149: END IF;
3150: IF (x_okl_relocate_assets_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
3151: THEN
3152: x_okl_relocate_assets_tl_rec.last_update_date := l_okl_relocate_assets_tl_rec.last_update_date;
3153: END IF;
3154: IF (x_okl_relocate_assets_tl_rec.last_update_login = OKC_API.G_MISS_NUM)

Line 3152: x_okl_relocate_assets_tl_rec.last_update_date := l_okl_relocate_assets_tl_rec.last_update_date;

3148: x_okl_relocate_assets_tl_rec.last_updated_by := l_okl_relocate_assets_tl_rec.last_updated_by;
3149: END IF;
3150: IF (x_okl_relocate_assets_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
3151: THEN
3152: x_okl_relocate_assets_tl_rec.last_update_date := l_okl_relocate_assets_tl_rec.last_update_date;
3153: END IF;
3154: IF (x_okl_relocate_assets_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
3155: THEN
3156: x_okl_relocate_assets_tl_rec.last_update_login := l_okl_relocate_assets_tl_rec.last_update_login;

Line 3154: IF (x_okl_relocate_assets_tl_rec.last_update_login = OKC_API.G_MISS_NUM)

3150: IF (x_okl_relocate_assets_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
3151: THEN
3152: x_okl_relocate_assets_tl_rec.last_update_date := l_okl_relocate_assets_tl_rec.last_update_date;
3153: END IF;
3154: IF (x_okl_relocate_assets_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
3155: THEN
3156: x_okl_relocate_assets_tl_rec.last_update_login := l_okl_relocate_assets_tl_rec.last_update_login;
3157: END IF;
3158: RETURN(l_return_status);

Line 3156: x_okl_relocate_assets_tl_rec.last_update_login := l_okl_relocate_assets_tl_rec.last_update_login;

3152: x_okl_relocate_assets_tl_rec.last_update_date := l_okl_relocate_assets_tl_rec.last_update_date;
3153: END IF;
3154: IF (x_okl_relocate_assets_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
3155: THEN
3156: x_okl_relocate_assets_tl_rec.last_update_login := l_okl_relocate_assets_tl_rec.last_update_login;
3157: END IF;
3158: RETURN(l_return_status);
3159: END populate_new_record;
3160: -----------------------------------------------

Line 3161: -- Set_Attributes for:OKL_RELOCATE_ASSETS_TL --

3157: END IF;
3158: RETURN(l_return_status);
3159: END populate_new_record;
3160: -----------------------------------------------
3161: -- Set_Attributes for:OKL_RELOCATE_ASSETS_TL --
3162: -----------------------------------------------
3163: FUNCTION Set_Attributes (
3164: p_okl_relocate_assets_tl_rec IN OklRelocateAssetsTlRecType,
3165: x_okl_relocate_assets_tl_rec OUT NOCOPY OklRelocateAssetsTlRecType

Line 3164: p_okl_relocate_assets_tl_rec IN OklRelocateAssetsTlRecType,

3160: -----------------------------------------------
3161: -- Set_Attributes for:OKL_RELOCATE_ASSETS_TL --
3162: -----------------------------------------------
3163: FUNCTION Set_Attributes (
3164: p_okl_relocate_assets_tl_rec IN OklRelocateAssetsTlRecType,
3165: x_okl_relocate_assets_tl_rec OUT NOCOPY OklRelocateAssetsTlRecType
3166: ) RETURN VARCHAR2 IS
3167: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3168: BEGIN

Line 3165: x_okl_relocate_assets_tl_rec OUT NOCOPY OklRelocateAssetsTlRecType

3161: -- Set_Attributes for:OKL_RELOCATE_ASSETS_TL --
3162: -----------------------------------------------
3163: FUNCTION Set_Attributes (
3164: p_okl_relocate_assets_tl_rec IN OklRelocateAssetsTlRecType,
3165: x_okl_relocate_assets_tl_rec OUT NOCOPY OklRelocateAssetsTlRecType
3166: ) RETURN VARCHAR2 IS
3167: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3168: BEGIN
3169: x_okl_relocate_assets_tl_rec := p_okl_relocate_assets_tl_rec;

Line 3169: x_okl_relocate_assets_tl_rec := p_okl_relocate_assets_tl_rec;

3165: x_okl_relocate_assets_tl_rec OUT NOCOPY OklRelocateAssetsTlRecType
3166: ) RETURN VARCHAR2 IS
3167: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3168: BEGIN
3169: x_okl_relocate_assets_tl_rec := p_okl_relocate_assets_tl_rec;
3170: x_okl_relocate_assets_tl_rec.LANGUAGE := USERENV('LANG');
3171: x_okl_relocate_assets_tl_rec.SOURCE_LANG := USERENV('LANG');
3172: RETURN(l_return_status);
3173: END Set_Attributes;

Line 3170: x_okl_relocate_assets_tl_rec.LANGUAGE := USERENV('LANG');

3166: ) RETURN VARCHAR2 IS
3167: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3168: BEGIN
3169: x_okl_relocate_assets_tl_rec := p_okl_relocate_assets_tl_rec;
3170: x_okl_relocate_assets_tl_rec.LANGUAGE := USERENV('LANG');
3171: x_okl_relocate_assets_tl_rec.SOURCE_LANG := USERENV('LANG');
3172: RETURN(l_return_status);
3173: END Set_Attributes;
3174: BEGIN

Line 3171: x_okl_relocate_assets_tl_rec.SOURCE_LANG := USERENV('LANG');

3167: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3168: BEGIN
3169: x_okl_relocate_assets_tl_rec := p_okl_relocate_assets_tl_rec;
3170: x_okl_relocate_assets_tl_rec.LANGUAGE := USERENV('LANG');
3171: x_okl_relocate_assets_tl_rec.SOURCE_LANG := USERENV('LANG');
3172: RETURN(l_return_status);
3173: END Set_Attributes;
3174: BEGIN
3175: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3186: p_okl_relocate_assets_tl_rec, -- IN

3182: RAISE OKC_API.G_EXCEPTION_ERROR;
3183: END IF;
3184: --- Setting item attributes
3185: l_return_status := Set_Attributes(
3186: p_okl_relocate_assets_tl_rec, -- IN
3187: l_okl_relocate_assets_tl_rec); -- OUT
3188: --- If any errors happen abort API
3189: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3190: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3187: l_okl_relocate_assets_tl_rec); -- OUT

3183: END IF;
3184: --- Setting item attributes
3185: l_return_status := Set_Attributes(
3186: p_okl_relocate_assets_tl_rec, -- IN
3187: l_okl_relocate_assets_tl_rec); -- OUT
3188: --- If any errors happen abort API
3189: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3190: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3191: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 3194: l_return_status := populate_new_record(l_okl_relocate_assets_tl_rec, ldefoklrelocateassetstlrec);

3190: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3191: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3192: RAISE OKC_API.G_EXCEPTION_ERROR;
3193: END IF;
3194: l_return_status := populate_new_record(l_okl_relocate_assets_tl_rec, ldefoklrelocateassetstlrec);
3195: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3196: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3197: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3198: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 3200: UPDATE OKL_RELOCATE_ASSETS_TL

3196: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3197: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3198: RAISE OKC_API.G_EXCEPTION_ERROR;
3199: END IF;
3200: UPDATE OKL_RELOCATE_ASSETS_TL
3201: SET COMMENTS = ldefoklrelocateassetstlrec.comments,
3202: SOURCE_LANG = ldefoklrelocateassetstlrec.source_lang,--Fix for bug 3637102
3203: CREATED_BY = ldefoklrelocateassetstlrec.created_by,
3204: CREATION_DATE = ldefoklrelocateassetstlrec.creation_date,

Line 3212: UPDATE OKL_RELOCATE_ASSETS_TL

3208: WHERE ID = ldefoklrelocateassetstlrec.id
3209: AND USERENV('LANG') in (SOURCE_LANG,LANGUAGE);--Fix for bug 3637102
3210: --AND SOURCE_LANG = USERENV('LANG');
3211:
3212: UPDATE OKL_RELOCATE_ASSETS_TL
3213: SET SFWT_FLAG = 'Y'
3214: WHERE ID = ldefoklrelocateassetstlrec.id
3215: AND SOURCE_LANG <> USERENV('LANG');
3216:

Line 3217: x_okl_relocate_assets_tl_rec := ldefoklrelocateassetstlrec;

3213: SET SFWT_FLAG = 'Y'
3214: WHERE ID = ldefoklrelocateassetstlrec.id
3215: AND SOURCE_LANG <> USERENV('LANG');
3216:
3217: x_okl_relocate_assets_tl_rec := ldefoklrelocateassetstlrec;
3218: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3219: EXCEPTION
3220: WHEN OKC_API.G_EXCEPTION_ERROR THEN
3221: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 3278: l_okl_relocate_assets_tl_rec OklRelocateAssetsTlRecType;

3274: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
3275: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3276: l_rasv_rec rasv_rec_type := p_rasv_rec;
3277: l_def_rasv_rec rasv_rec_type;
3278: l_okl_relocate_assets_tl_rec OklRelocateAssetsTlRecType;
3279: lx_okl_relocate_assets_tl_rec OklRelocateAssetsTlRecType;
3280: l_ras_rec ras_rec_type;
3281: lx_ras_rec ras_rec_type;
3282: -------------------------------

Line 3279: lx_okl_relocate_assets_tl_rec OklRelocateAssetsTlRecType;

3275: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3276: l_rasv_rec rasv_rec_type := p_rasv_rec;
3277: l_def_rasv_rec rasv_rec_type;
3278: l_okl_relocate_assets_tl_rec OklRelocateAssetsTlRecType;
3279: lx_okl_relocate_assets_tl_rec OklRelocateAssetsTlRecType;
3280: l_ras_rec ras_rec_type;
3281: lx_ras_rec ras_rec_type;
3282: -------------------------------
3283: -- FUNCTION fill_who_columns --

Line 3541: migrate(l_def_rasv_rec, l_okl_relocate_assets_tl_rec);

3537:
3538: --------------------------------------
3539: -- Move VIEW record to "Child" records
3540: --------------------------------------
3541: migrate(l_def_rasv_rec, l_okl_relocate_assets_tl_rec);
3542: migrate(l_def_rasv_rec, l_ras_rec);
3543: --------------------------------------------
3544: -- Call the UPDATE_ROW for each child record
3545: --------------------------------------------

Line 3551: l_okl_relocate_assets_tl_rec,

3547: p_init_msg_list,
3548: x_return_status,
3549: x_msg_count,
3550: x_msg_data,
3551: l_okl_relocate_assets_tl_rec,
3552: lx_okl_relocate_assets_tl_rec
3553: );
3554: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3555: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3552: lx_okl_relocate_assets_tl_rec

3548: x_return_status,
3549: x_msg_count,
3550: x_msg_data,
3551: l_okl_relocate_assets_tl_rec,
3552: lx_okl_relocate_assets_tl_rec
3553: );
3554: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3555: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3556: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 3559: migrate(lx_okl_relocate_assets_tl_rec, l_def_rasv_rec);

3555: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3556: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3557: RAISE OKC_API.G_EXCEPTION_ERROR;
3558: END IF;
3559: migrate(lx_okl_relocate_assets_tl_rec, l_def_rasv_rec);
3560: update_row(
3561: p_init_msg_list,
3562: x_return_status,
3563: x_msg_count,

Line 3756: -- delete_row for:OKL_RELOCATE_ASSETS_TL --

3752: '_PVT'
3753: );
3754: END delete_row;
3755: -------------------------------------------
3756: -- delete_row for:OKL_RELOCATE_ASSETS_TL --
3757: -------------------------------------------
3758: PROCEDURE delete_row(
3759: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3760: x_return_status OUT NOCOPY VARCHAR2,

Line 3763: p_okl_relocate_assets_tl_rec IN OklRelocateAssetsTlRecType) IS

3759: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3760: x_return_status OUT NOCOPY VARCHAR2,
3761: x_msg_count OUT NOCOPY NUMBER,
3762: x_msg_data OUT NOCOPY VARCHAR2,
3763: p_okl_relocate_assets_tl_rec IN OklRelocateAssetsTlRecType) IS
3764:
3765: l_api_version CONSTANT NUMBER := 1;
3766: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3767: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 3768: l_okl_relocate_assets_tl_rec OklRelocateAssetsTlRecType:= p_okl_relocate_assets_tl_rec;

3764:
3765: l_api_version CONSTANT NUMBER := 1;
3766: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3767: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3768: l_okl_relocate_assets_tl_rec OklRelocateAssetsTlRecType:= p_okl_relocate_assets_tl_rec;
3769: l_row_notfound BOOLEAN := TRUE;
3770: -----------------------------------------------
3771: -- Set_Attributes for:OKL_RELOCATE_ASSETS_TL --
3772: -----------------------------------------------

Line 3771: -- Set_Attributes for:OKL_RELOCATE_ASSETS_TL --

3767: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3768: l_okl_relocate_assets_tl_rec OklRelocateAssetsTlRecType:= p_okl_relocate_assets_tl_rec;
3769: l_row_notfound BOOLEAN := TRUE;
3770: -----------------------------------------------
3771: -- Set_Attributes for:OKL_RELOCATE_ASSETS_TL --
3772: -----------------------------------------------
3773: FUNCTION Set_Attributes (
3774: p_okl_relocate_assets_tl_rec IN OklRelocateAssetsTlRecType,
3775: x_okl_relocate_assets_tl_rec OUT NOCOPY OklRelocateAssetsTlRecType

Line 3774: p_okl_relocate_assets_tl_rec IN OklRelocateAssetsTlRecType,

3770: -----------------------------------------------
3771: -- Set_Attributes for:OKL_RELOCATE_ASSETS_TL --
3772: -----------------------------------------------
3773: FUNCTION Set_Attributes (
3774: p_okl_relocate_assets_tl_rec IN OklRelocateAssetsTlRecType,
3775: x_okl_relocate_assets_tl_rec OUT NOCOPY OklRelocateAssetsTlRecType
3776: ) RETURN VARCHAR2 IS
3777: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3778: BEGIN

Line 3775: x_okl_relocate_assets_tl_rec OUT NOCOPY OklRelocateAssetsTlRecType

3771: -- Set_Attributes for:OKL_RELOCATE_ASSETS_TL --
3772: -----------------------------------------------
3773: FUNCTION Set_Attributes (
3774: p_okl_relocate_assets_tl_rec IN OklRelocateAssetsTlRecType,
3775: x_okl_relocate_assets_tl_rec OUT NOCOPY OklRelocateAssetsTlRecType
3776: ) RETURN VARCHAR2 IS
3777: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3778: BEGIN
3779: x_okl_relocate_assets_tl_rec := p_okl_relocate_assets_tl_rec;

Line 3779: x_okl_relocate_assets_tl_rec := p_okl_relocate_assets_tl_rec;

3775: x_okl_relocate_assets_tl_rec OUT NOCOPY OklRelocateAssetsTlRecType
3776: ) RETURN VARCHAR2 IS
3777: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3778: BEGIN
3779: x_okl_relocate_assets_tl_rec := p_okl_relocate_assets_tl_rec;
3780: x_okl_relocate_assets_tl_rec.LANGUAGE := USERENV('LANG');
3781: RETURN(l_return_status);
3782: END Set_Attributes;
3783: BEGIN

Line 3780: x_okl_relocate_assets_tl_rec.LANGUAGE := USERENV('LANG');

3776: ) RETURN VARCHAR2 IS
3777: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3778: BEGIN
3779: x_okl_relocate_assets_tl_rec := p_okl_relocate_assets_tl_rec;
3780: x_okl_relocate_assets_tl_rec.LANGUAGE := USERENV('LANG');
3781: RETURN(l_return_status);
3782: END Set_Attributes;
3783: BEGIN
3784: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3795: p_okl_relocate_assets_tl_rec, -- IN

3791: RAISE OKC_API.G_EXCEPTION_ERROR;
3792: END IF;
3793: --- Setting item attributes
3794: l_return_status := Set_Attributes(
3795: p_okl_relocate_assets_tl_rec, -- IN
3796: l_okl_relocate_assets_tl_rec); -- OUT
3797: --- If any errors happen abort API
3798: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3799: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3796: l_okl_relocate_assets_tl_rec); -- OUT

3792: END IF;
3793: --- Setting item attributes
3794: l_return_status := Set_Attributes(
3795: p_okl_relocate_assets_tl_rec, -- IN
3796: l_okl_relocate_assets_tl_rec); -- OUT
3797: --- If any errors happen abort API
3798: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3799: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3800: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 3803: DELETE FROM OKL_RELOCATE_ASSETS_TL

3799: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3800: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3801: RAISE OKC_API.G_EXCEPTION_ERROR;
3802: END IF;
3803: DELETE FROM OKL_RELOCATE_ASSETS_TL
3804: WHERE ID = l_okl_relocate_assets_tl_rec.id;
3805:
3806: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3807: EXCEPTION

Line 3804: WHERE ID = l_okl_relocate_assets_tl_rec.id;

3800: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3801: RAISE OKC_API.G_EXCEPTION_ERROR;
3802: END IF;
3803: DELETE FROM OKL_RELOCATE_ASSETS_TL
3804: WHERE ID = l_okl_relocate_assets_tl_rec.id;
3805:
3806: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3807: EXCEPTION
3808: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 3854: l_okl_relocate_assets_tl_rec OklRelocateAssetsTlRecType;

3850: l_api_version CONSTANT NUMBER := 1;
3851: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
3852: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3853: l_rasv_rec rasv_rec_type := p_rasv_rec;
3854: l_okl_relocate_assets_tl_rec OklRelocateAssetsTlRecType;
3855: l_ras_rec ras_rec_type;
3856: BEGIN
3857: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
3858: G_PKG_NAME,

Line 3872: migrate(l_rasv_rec, l_okl_relocate_assets_tl_rec);

3868: END IF;
3869: --------------------------------------
3870: -- Move VIEW record to "Child" records
3871: --------------------------------------
3872: migrate(l_rasv_rec, l_okl_relocate_assets_tl_rec);
3873: migrate(l_rasv_rec, l_ras_rec);
3874: --------------------------------------------
3875: -- Call the DELETE_ROW for each child record
3876: --------------------------------------------

Line 3882: l_okl_relocate_assets_tl_rec

3878: p_init_msg_list,
3879: x_return_status,
3880: x_msg_count,
3881: x_msg_data,
3882: l_okl_relocate_assets_tl_rec
3883: );
3884: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3885: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3886: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN