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_DSF_PVT dependencies on OKL_DATA_SRC_FNCTNS_TL

Line 40: DELETE FROM OKL_DATA_SRC_FNCTNS_TL T

36: -- PROCEDURE add_language
37: ---------------------------------------------------------------------------
38: PROCEDURE add_language IS
39: BEGIN
40: DELETE FROM OKL_DATA_SRC_FNCTNS_TL T
41: WHERE NOT EXISTS (
42: SELECT NULL
43: FROM OKL_DATA_SRC_FNCTNS_B B --fixed bug 3321017 by kmotepal
44: WHERE B.ID = T.ID

Line 47: UPDATE OKL_DATA_SRC_FNCTNS_TL T SET (

43: FROM OKL_DATA_SRC_FNCTNS_B B --fixed bug 3321017 by kmotepal
44: WHERE B.ID = T.ID
45: );
46:
47: UPDATE OKL_DATA_SRC_FNCTNS_TL T SET (
48: DESCRIPTION) = (SELECT
49: B.DESCRIPTION
50: FROM OKL_DATA_SRC_FNCTNS_TL B
51: WHERE B.ID = T.ID

Line 50: FROM OKL_DATA_SRC_FNCTNS_TL B

46:
47: UPDATE OKL_DATA_SRC_FNCTNS_TL T SET (
48: DESCRIPTION) = (SELECT
49: B.DESCRIPTION
50: FROM OKL_DATA_SRC_FNCTNS_TL B
51: WHERE B.ID = T.ID
52: AND B.LANGUAGE = T.SOURCE_LANG)
53: WHERE (
54: T.ID,

Line 59: FROM OKL_DATA_SRC_FNCTNS_TL SUBB, OKL_DATA_SRC_FNCTNS_TL SUBT

55: T.LANGUAGE)
56: IN (SELECT
57: SUBT.ID,
58: SUBT.LANGUAGE
59: FROM OKL_DATA_SRC_FNCTNS_TL SUBB, OKL_DATA_SRC_FNCTNS_TL SUBT
60: WHERE SUBB.ID = SUBT.ID
61: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
62: AND (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
63: OR (SUBB.DESCRIPTION IS NULL AND SUBT.DESCRIPTION IS NOT NULL)

Line 67: INSERT INTO OKL_DATA_SRC_FNCTNS_TL (

63: OR (SUBB.DESCRIPTION IS NULL AND SUBT.DESCRIPTION IS NOT NULL)
64: OR (SUBB.DESCRIPTION IS NOT NULL AND SUBT.DESCRIPTION IS NULL)
65: ));
66:
67: INSERT INTO OKL_DATA_SRC_FNCTNS_TL (
68: ID,
69: LANGUAGE,
70: SOURCE_LANG,
71: SFWT_FLAG,

Line 89: FROM OKL_DATA_SRC_FNCTNS_TL B, FND_LANGUAGES L

85: B.CREATION_DATE,
86: B.LAST_UPDATED_BY,
87: B.LAST_UPDATE_DATE,
88: B.LAST_UPDATE_LOGIN
89: FROM OKL_DATA_SRC_FNCTNS_TL B, FND_LANGUAGES L
90: WHERE L.INSTALLED_FLAG IN ('I', 'B')
91: AND B.LANGUAGE = USERENV('LANG')
92: AND NOT EXISTS(
93: SELECT NULL

Line 94: FROM OKL_DATA_SRC_FNCTNS_TL T

90: WHERE L.INSTALLED_FLAG IN ('I', 'B')
91: AND B.LANGUAGE = USERENV('LANG')
92: AND NOT EXISTS(
93: SELECT NULL
94: FROM OKL_DATA_SRC_FNCTNS_TL T
95: WHERE T.ID = B.ID
96: AND T.LANGUAGE = L.LANGUAGE_CODE
97: );
98:

Line 192: -- FUNCTION get_rec for: OKL_DATA_SRC_FNCTNS_TL

188: BEGIN
189: RETURN(get_rec(p_dsf_rec, l_row_notfound));
190: END get_rec;
191: ---------------------------------------------------------------------------
192: -- FUNCTION get_rec for: OKL_DATA_SRC_FNCTNS_TL
193: ---------------------------------------------------------------------------
194: FUNCTION get_rec (
195: p_okl_data_src_fnctns_tl_rec IN OklDataSrcFnctnsTlRecType,
196: x_no_data_found OUT NOCOPY BOOLEAN

Line 195: p_okl_data_src_fnctns_tl_rec IN OklDataSrcFnctnsTlRecType,

191: ---------------------------------------------------------------------------
192: -- FUNCTION get_rec for: OKL_DATA_SRC_FNCTNS_TL
193: ---------------------------------------------------------------------------
194: FUNCTION get_rec (
195: p_okl_data_src_fnctns_tl_rec IN OklDataSrcFnctnsTlRecType,
196: x_no_data_found OUT NOCOPY BOOLEAN
197: ) RETURN OklDataSrcFnctnsTlRecType IS
198: CURSOR okl_data_src_fnctns_tl_pk_csr (p_id IN NUMBER,
199: p_language IN VARCHAR2) IS

Line 198: CURSOR okl_data_src_fnctns_tl_pk_csr (p_id IN NUMBER,

194: FUNCTION get_rec (
195: p_okl_data_src_fnctns_tl_rec IN OklDataSrcFnctnsTlRecType,
196: x_no_data_found OUT NOCOPY BOOLEAN
197: ) RETURN OklDataSrcFnctnsTlRecType IS
198: CURSOR okl_data_src_fnctns_tl_pk_csr (p_id IN NUMBER,
199: p_language IN VARCHAR2) IS
200: SELECT
201: ID,
202: LANGUAGE,

Line 211: FROM Okl_Data_Src_Fnctns_Tl

207: CREATION_DATE,
208: LAST_UPDATED_BY,
209: LAST_UPDATE_DATE,
210: LAST_UPDATE_LOGIN
211: FROM Okl_Data_Src_Fnctns_Tl
212: WHERE okl_data_src_fnctns_tl.id = p_id
213: AND okl_data_src_fnctns_tl.language = p_language;
214: l_okl_data_src_fnctns_tl_pk okl_data_src_fnctns_tl_pk_csr%ROWTYPE;
215: l_okl_data_src_fnctns_tl_rec OklDataSrcFnctnsTlRecType;

Line 212: WHERE okl_data_src_fnctns_tl.id = p_id

208: LAST_UPDATED_BY,
209: LAST_UPDATE_DATE,
210: LAST_UPDATE_LOGIN
211: FROM Okl_Data_Src_Fnctns_Tl
212: WHERE okl_data_src_fnctns_tl.id = p_id
213: AND okl_data_src_fnctns_tl.language = p_language;
214: l_okl_data_src_fnctns_tl_pk okl_data_src_fnctns_tl_pk_csr%ROWTYPE;
215: l_okl_data_src_fnctns_tl_rec OklDataSrcFnctnsTlRecType;
216: BEGIN

Line 213: AND okl_data_src_fnctns_tl.language = p_language;

209: LAST_UPDATE_DATE,
210: LAST_UPDATE_LOGIN
211: FROM Okl_Data_Src_Fnctns_Tl
212: WHERE okl_data_src_fnctns_tl.id = p_id
213: AND okl_data_src_fnctns_tl.language = p_language;
214: l_okl_data_src_fnctns_tl_pk okl_data_src_fnctns_tl_pk_csr%ROWTYPE;
215: l_okl_data_src_fnctns_tl_rec OklDataSrcFnctnsTlRecType;
216: BEGIN
217: x_no_data_found := TRUE;

Line 214: l_okl_data_src_fnctns_tl_pk okl_data_src_fnctns_tl_pk_csr%ROWTYPE;

210: LAST_UPDATE_LOGIN
211: FROM Okl_Data_Src_Fnctns_Tl
212: WHERE okl_data_src_fnctns_tl.id = p_id
213: AND okl_data_src_fnctns_tl.language = p_language;
214: l_okl_data_src_fnctns_tl_pk okl_data_src_fnctns_tl_pk_csr%ROWTYPE;
215: l_okl_data_src_fnctns_tl_rec OklDataSrcFnctnsTlRecType;
216: BEGIN
217: x_no_data_found := TRUE;
218: -- Get current database values

Line 215: l_okl_data_src_fnctns_tl_rec OklDataSrcFnctnsTlRecType;

211: FROM Okl_Data_Src_Fnctns_Tl
212: WHERE okl_data_src_fnctns_tl.id = p_id
213: AND okl_data_src_fnctns_tl.language = p_language;
214: l_okl_data_src_fnctns_tl_pk okl_data_src_fnctns_tl_pk_csr%ROWTYPE;
215: l_okl_data_src_fnctns_tl_rec OklDataSrcFnctnsTlRecType;
216: BEGIN
217: x_no_data_found := TRUE;
218: -- Get current database values
219: OPEN okl_data_src_fnctns_tl_pk_csr (p_okl_data_src_fnctns_tl_rec.id,

Line 219: OPEN okl_data_src_fnctns_tl_pk_csr (p_okl_data_src_fnctns_tl_rec.id,

215: l_okl_data_src_fnctns_tl_rec OklDataSrcFnctnsTlRecType;
216: BEGIN
217: x_no_data_found := TRUE;
218: -- Get current database values
219: OPEN okl_data_src_fnctns_tl_pk_csr (p_okl_data_src_fnctns_tl_rec.id,
220: p_okl_data_src_fnctns_tl_rec.language);
221: FETCH okl_data_src_fnctns_tl_pk_csr INTO
222: l_okl_data_src_fnctns_tl_rec.ID,
223: l_okl_data_src_fnctns_tl_rec.LANGUAGE,

Line 220: p_okl_data_src_fnctns_tl_rec.language);

216: BEGIN
217: x_no_data_found := TRUE;
218: -- Get current database values
219: OPEN okl_data_src_fnctns_tl_pk_csr (p_okl_data_src_fnctns_tl_rec.id,
220: p_okl_data_src_fnctns_tl_rec.language);
221: FETCH okl_data_src_fnctns_tl_pk_csr INTO
222: l_okl_data_src_fnctns_tl_rec.ID,
223: l_okl_data_src_fnctns_tl_rec.LANGUAGE,
224: l_okl_data_src_fnctns_tl_rec.SOURCE_LANG,

Line 221: FETCH okl_data_src_fnctns_tl_pk_csr INTO

217: x_no_data_found := TRUE;
218: -- Get current database values
219: OPEN okl_data_src_fnctns_tl_pk_csr (p_okl_data_src_fnctns_tl_rec.id,
220: p_okl_data_src_fnctns_tl_rec.language);
221: FETCH okl_data_src_fnctns_tl_pk_csr INTO
222: l_okl_data_src_fnctns_tl_rec.ID,
223: l_okl_data_src_fnctns_tl_rec.LANGUAGE,
224: l_okl_data_src_fnctns_tl_rec.SOURCE_LANG,
225: l_okl_data_src_fnctns_tl_rec.SFWT_FLAG,

Line 222: l_okl_data_src_fnctns_tl_rec.ID,

218: -- Get current database values
219: OPEN okl_data_src_fnctns_tl_pk_csr (p_okl_data_src_fnctns_tl_rec.id,
220: p_okl_data_src_fnctns_tl_rec.language);
221: FETCH okl_data_src_fnctns_tl_pk_csr INTO
222: l_okl_data_src_fnctns_tl_rec.ID,
223: l_okl_data_src_fnctns_tl_rec.LANGUAGE,
224: l_okl_data_src_fnctns_tl_rec.SOURCE_LANG,
225: l_okl_data_src_fnctns_tl_rec.SFWT_FLAG,
226: l_okl_data_src_fnctns_tl_rec.DESCRIPTION,

Line 223: l_okl_data_src_fnctns_tl_rec.LANGUAGE,

219: OPEN okl_data_src_fnctns_tl_pk_csr (p_okl_data_src_fnctns_tl_rec.id,
220: p_okl_data_src_fnctns_tl_rec.language);
221: FETCH okl_data_src_fnctns_tl_pk_csr INTO
222: l_okl_data_src_fnctns_tl_rec.ID,
223: l_okl_data_src_fnctns_tl_rec.LANGUAGE,
224: l_okl_data_src_fnctns_tl_rec.SOURCE_LANG,
225: l_okl_data_src_fnctns_tl_rec.SFWT_FLAG,
226: l_okl_data_src_fnctns_tl_rec.DESCRIPTION,
227: l_okl_data_src_fnctns_tl_rec.CREATED_BY,

Line 224: l_okl_data_src_fnctns_tl_rec.SOURCE_LANG,

220: p_okl_data_src_fnctns_tl_rec.language);
221: FETCH okl_data_src_fnctns_tl_pk_csr INTO
222: l_okl_data_src_fnctns_tl_rec.ID,
223: l_okl_data_src_fnctns_tl_rec.LANGUAGE,
224: l_okl_data_src_fnctns_tl_rec.SOURCE_LANG,
225: l_okl_data_src_fnctns_tl_rec.SFWT_FLAG,
226: l_okl_data_src_fnctns_tl_rec.DESCRIPTION,
227: l_okl_data_src_fnctns_tl_rec.CREATED_BY,
228: l_okl_data_src_fnctns_tl_rec.CREATION_DATE,

Line 225: l_okl_data_src_fnctns_tl_rec.SFWT_FLAG,

221: FETCH okl_data_src_fnctns_tl_pk_csr INTO
222: l_okl_data_src_fnctns_tl_rec.ID,
223: l_okl_data_src_fnctns_tl_rec.LANGUAGE,
224: l_okl_data_src_fnctns_tl_rec.SOURCE_LANG,
225: l_okl_data_src_fnctns_tl_rec.SFWT_FLAG,
226: l_okl_data_src_fnctns_tl_rec.DESCRIPTION,
227: l_okl_data_src_fnctns_tl_rec.CREATED_BY,
228: l_okl_data_src_fnctns_tl_rec.CREATION_DATE,
229: l_okl_data_src_fnctns_tl_rec.LAST_UPDATED_BY,

Line 226: l_okl_data_src_fnctns_tl_rec.DESCRIPTION,

222: l_okl_data_src_fnctns_tl_rec.ID,
223: l_okl_data_src_fnctns_tl_rec.LANGUAGE,
224: l_okl_data_src_fnctns_tl_rec.SOURCE_LANG,
225: l_okl_data_src_fnctns_tl_rec.SFWT_FLAG,
226: l_okl_data_src_fnctns_tl_rec.DESCRIPTION,
227: l_okl_data_src_fnctns_tl_rec.CREATED_BY,
228: l_okl_data_src_fnctns_tl_rec.CREATION_DATE,
229: l_okl_data_src_fnctns_tl_rec.LAST_UPDATED_BY,
230: l_okl_data_src_fnctns_tl_rec.LAST_UPDATE_DATE,

Line 227: l_okl_data_src_fnctns_tl_rec.CREATED_BY,

223: l_okl_data_src_fnctns_tl_rec.LANGUAGE,
224: l_okl_data_src_fnctns_tl_rec.SOURCE_LANG,
225: l_okl_data_src_fnctns_tl_rec.SFWT_FLAG,
226: l_okl_data_src_fnctns_tl_rec.DESCRIPTION,
227: l_okl_data_src_fnctns_tl_rec.CREATED_BY,
228: l_okl_data_src_fnctns_tl_rec.CREATION_DATE,
229: l_okl_data_src_fnctns_tl_rec.LAST_UPDATED_BY,
230: l_okl_data_src_fnctns_tl_rec.LAST_UPDATE_DATE,
231: l_okl_data_src_fnctns_tl_rec.LAST_UPDATE_LOGIN;

Line 228: l_okl_data_src_fnctns_tl_rec.CREATION_DATE,

224: l_okl_data_src_fnctns_tl_rec.SOURCE_LANG,
225: l_okl_data_src_fnctns_tl_rec.SFWT_FLAG,
226: l_okl_data_src_fnctns_tl_rec.DESCRIPTION,
227: l_okl_data_src_fnctns_tl_rec.CREATED_BY,
228: l_okl_data_src_fnctns_tl_rec.CREATION_DATE,
229: l_okl_data_src_fnctns_tl_rec.LAST_UPDATED_BY,
230: l_okl_data_src_fnctns_tl_rec.LAST_UPDATE_DATE,
231: l_okl_data_src_fnctns_tl_rec.LAST_UPDATE_LOGIN;
232: x_no_data_found := okl_data_src_fnctns_tl_pk_csr%NOTFOUND;

Line 229: l_okl_data_src_fnctns_tl_rec.LAST_UPDATED_BY,

225: l_okl_data_src_fnctns_tl_rec.SFWT_FLAG,
226: l_okl_data_src_fnctns_tl_rec.DESCRIPTION,
227: l_okl_data_src_fnctns_tl_rec.CREATED_BY,
228: l_okl_data_src_fnctns_tl_rec.CREATION_DATE,
229: l_okl_data_src_fnctns_tl_rec.LAST_UPDATED_BY,
230: l_okl_data_src_fnctns_tl_rec.LAST_UPDATE_DATE,
231: l_okl_data_src_fnctns_tl_rec.LAST_UPDATE_LOGIN;
232: x_no_data_found := okl_data_src_fnctns_tl_pk_csr%NOTFOUND;
233: CLOSE okl_data_src_fnctns_tl_pk_csr;

Line 230: l_okl_data_src_fnctns_tl_rec.LAST_UPDATE_DATE,

226: l_okl_data_src_fnctns_tl_rec.DESCRIPTION,
227: l_okl_data_src_fnctns_tl_rec.CREATED_BY,
228: l_okl_data_src_fnctns_tl_rec.CREATION_DATE,
229: l_okl_data_src_fnctns_tl_rec.LAST_UPDATED_BY,
230: l_okl_data_src_fnctns_tl_rec.LAST_UPDATE_DATE,
231: l_okl_data_src_fnctns_tl_rec.LAST_UPDATE_LOGIN;
232: x_no_data_found := okl_data_src_fnctns_tl_pk_csr%NOTFOUND;
233: CLOSE okl_data_src_fnctns_tl_pk_csr;
234: RETURN(l_okl_data_src_fnctns_tl_rec);

Line 231: l_okl_data_src_fnctns_tl_rec.LAST_UPDATE_LOGIN;

227: l_okl_data_src_fnctns_tl_rec.CREATED_BY,
228: l_okl_data_src_fnctns_tl_rec.CREATION_DATE,
229: l_okl_data_src_fnctns_tl_rec.LAST_UPDATED_BY,
230: l_okl_data_src_fnctns_tl_rec.LAST_UPDATE_DATE,
231: l_okl_data_src_fnctns_tl_rec.LAST_UPDATE_LOGIN;
232: x_no_data_found := okl_data_src_fnctns_tl_pk_csr%NOTFOUND;
233: CLOSE okl_data_src_fnctns_tl_pk_csr;
234: RETURN(l_okl_data_src_fnctns_tl_rec);
235: END get_rec;

Line 232: x_no_data_found := okl_data_src_fnctns_tl_pk_csr%NOTFOUND;

228: l_okl_data_src_fnctns_tl_rec.CREATION_DATE,
229: l_okl_data_src_fnctns_tl_rec.LAST_UPDATED_BY,
230: l_okl_data_src_fnctns_tl_rec.LAST_UPDATE_DATE,
231: l_okl_data_src_fnctns_tl_rec.LAST_UPDATE_LOGIN;
232: x_no_data_found := okl_data_src_fnctns_tl_pk_csr%NOTFOUND;
233: CLOSE okl_data_src_fnctns_tl_pk_csr;
234: RETURN(l_okl_data_src_fnctns_tl_rec);
235: END get_rec;
236:

Line 233: CLOSE okl_data_src_fnctns_tl_pk_csr;

229: l_okl_data_src_fnctns_tl_rec.LAST_UPDATED_BY,
230: l_okl_data_src_fnctns_tl_rec.LAST_UPDATE_DATE,
231: l_okl_data_src_fnctns_tl_rec.LAST_UPDATE_LOGIN;
232: x_no_data_found := okl_data_src_fnctns_tl_pk_csr%NOTFOUND;
233: CLOSE okl_data_src_fnctns_tl_pk_csr;
234: RETURN(l_okl_data_src_fnctns_tl_rec);
235: END get_rec;
236:
237: FUNCTION get_rec (

Line 234: RETURN(l_okl_data_src_fnctns_tl_rec);

230: l_okl_data_src_fnctns_tl_rec.LAST_UPDATE_DATE,
231: l_okl_data_src_fnctns_tl_rec.LAST_UPDATE_LOGIN;
232: x_no_data_found := okl_data_src_fnctns_tl_pk_csr%NOTFOUND;
233: CLOSE okl_data_src_fnctns_tl_pk_csr;
234: RETURN(l_okl_data_src_fnctns_tl_rec);
235: END get_rec;
236:
237: FUNCTION get_rec (
238: p_okl_data_src_fnctns_tl_rec IN OklDataSrcFnctnsTlRecType

Line 238: p_okl_data_src_fnctns_tl_rec IN OklDataSrcFnctnsTlRecType

234: RETURN(l_okl_data_src_fnctns_tl_rec);
235: END get_rec;
236:
237: FUNCTION get_rec (
238: p_okl_data_src_fnctns_tl_rec IN OklDataSrcFnctnsTlRecType
239: ) RETURN OklDataSrcFnctnsTlRecType IS
240: l_row_notfound BOOLEAN := TRUE;
241: BEGIN
242: RETURN(get_rec(p_okl_data_src_fnctns_tl_rec, l_row_notfound));

Line 242: RETURN(get_rec(p_okl_data_src_fnctns_tl_rec, l_row_notfound));

238: p_okl_data_src_fnctns_tl_rec IN OklDataSrcFnctnsTlRecType
239: ) RETURN OklDataSrcFnctnsTlRecType IS
240: l_row_notfound BOOLEAN := TRUE;
241: BEGIN
242: RETURN(get_rec(p_okl_data_src_fnctns_tl_rec, l_row_notfound));
243: END get_rec;
244: ---------------------------------------------------------------------------
245: -- FUNCTION get_rec for: OKL_DATA_SRC_FNCTNS_V
246: ---------------------------------------------------------------------------

Line 1527: l_okl_data_src_fnctns_tl_rec OklDataSrcFnctnsTlRecType;

1523: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
1524: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1525: l_dsfv_rec dsfv_rec_type := p_dsfv_rec;
1526: l_dsf_rec dsf_rec_type;
1527: l_okl_data_src_fnctns_tl_rec OklDataSrcFnctnsTlRecType;
1528: BEGIN
1529: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1530: G_PKG_NAME,
1531: p_init_msg_list,

Line 1813: -- insert_row for:OKL_DATA_SRC_FNCTNS_TL --

1809: '_PVT'
1810: );
1811: END insert_row;
1812: -------------------------------------------
1813: -- insert_row for:OKL_DATA_SRC_FNCTNS_TL --
1814: -------------------------------------------
1815: PROCEDURE insert_row(
1816: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1817: x_return_status OUT NOCOPY VARCHAR2,

Line 1820: p_okl_data_src_fnctns_tl_rec IN OklDataSrcFnctnsTlRecType,

1816: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1817: x_return_status OUT NOCOPY VARCHAR2,
1818: x_msg_count OUT NOCOPY NUMBER,
1819: x_msg_data OUT NOCOPY VARCHAR2,
1820: p_okl_data_src_fnctns_tl_rec IN OklDataSrcFnctnsTlRecType,
1821: x_okl_data_src_fnctns_tl_rec OUT NOCOPY OklDataSrcFnctnsTlRecType) IS
1822:
1823: l_api_version CONSTANT NUMBER := 1;
1824: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';

Line 1821: x_okl_data_src_fnctns_tl_rec OUT NOCOPY OklDataSrcFnctnsTlRecType) IS

1817: x_return_status OUT NOCOPY VARCHAR2,
1818: x_msg_count OUT NOCOPY NUMBER,
1819: x_msg_data OUT NOCOPY VARCHAR2,
1820: p_okl_data_src_fnctns_tl_rec IN OklDataSrcFnctnsTlRecType,
1821: x_okl_data_src_fnctns_tl_rec OUT NOCOPY OklDataSrcFnctnsTlRecType) IS
1822:
1823: l_api_version CONSTANT NUMBER := 1;
1824: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1825: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1826: l_okl_data_src_fnctns_tl_rec OklDataSrcFnctnsTlRecType := p_okl_data_src_fnctns_tl_rec;

1822:
1823: l_api_version CONSTANT NUMBER := 1;
1824: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1825: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1826: l_okl_data_src_fnctns_tl_rec OklDataSrcFnctnsTlRecType := p_okl_data_src_fnctns_tl_rec;
1827: ldefokldatasrcfnctnstlrec OklDataSrcFnctnsTlRecType;
1828: CURSOR get_languages IS
1829: SELECT *
1830: FROM FND_LANGUAGES

Line 1833: -- Set_Attributes for:OKL_DATA_SRC_FNCTNS_TL --

1829: SELECT *
1830: FROM FND_LANGUAGES
1831: WHERE INSTALLED_FLAG IN ('I', 'B');
1832: -----------------------------------------------
1833: -- Set_Attributes for:OKL_DATA_SRC_FNCTNS_TL --
1834: -----------------------------------------------
1835: FUNCTION Set_Attributes (
1836: p_okl_data_src_fnctns_tl_rec IN OklDataSrcFnctnsTlRecType,
1837: x_okl_data_src_fnctns_tl_rec OUT NOCOPY OklDataSrcFnctnsTlRecType

Line 1836: p_okl_data_src_fnctns_tl_rec IN OklDataSrcFnctnsTlRecType,

1832: -----------------------------------------------
1833: -- Set_Attributes for:OKL_DATA_SRC_FNCTNS_TL --
1834: -----------------------------------------------
1835: FUNCTION Set_Attributes (
1836: p_okl_data_src_fnctns_tl_rec IN OklDataSrcFnctnsTlRecType,
1837: x_okl_data_src_fnctns_tl_rec OUT NOCOPY OklDataSrcFnctnsTlRecType
1838: ) RETURN VARCHAR2 IS
1839: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1840: BEGIN

Line 1837: x_okl_data_src_fnctns_tl_rec OUT NOCOPY OklDataSrcFnctnsTlRecType

1833: -- Set_Attributes for:OKL_DATA_SRC_FNCTNS_TL --
1834: -----------------------------------------------
1835: FUNCTION Set_Attributes (
1836: p_okl_data_src_fnctns_tl_rec IN OklDataSrcFnctnsTlRecType,
1837: x_okl_data_src_fnctns_tl_rec OUT NOCOPY OklDataSrcFnctnsTlRecType
1838: ) RETURN VARCHAR2 IS
1839: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1840: BEGIN
1841: x_okl_data_src_fnctns_tl_rec := p_okl_data_src_fnctns_tl_rec;

Line 1841: x_okl_data_src_fnctns_tl_rec := p_okl_data_src_fnctns_tl_rec;

1837: x_okl_data_src_fnctns_tl_rec OUT NOCOPY OklDataSrcFnctnsTlRecType
1838: ) RETURN VARCHAR2 IS
1839: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1840: BEGIN
1841: x_okl_data_src_fnctns_tl_rec := p_okl_data_src_fnctns_tl_rec;
1842: x_okl_data_src_fnctns_tl_rec.LANGUAGE := USERENV('LANG');
1843: x_okl_data_src_fnctns_tl_rec.SOURCE_LANG := USERENV('LANG');
1844: RETURN(l_return_status);
1845: END Set_Attributes;

Line 1842: x_okl_data_src_fnctns_tl_rec.LANGUAGE := USERENV('LANG');

1838: ) RETURN VARCHAR2 IS
1839: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1840: BEGIN
1841: x_okl_data_src_fnctns_tl_rec := p_okl_data_src_fnctns_tl_rec;
1842: x_okl_data_src_fnctns_tl_rec.LANGUAGE := USERENV('LANG');
1843: x_okl_data_src_fnctns_tl_rec.SOURCE_LANG := USERENV('LANG');
1844: RETURN(l_return_status);
1845: END Set_Attributes;
1846: BEGIN

Line 1843: x_okl_data_src_fnctns_tl_rec.SOURCE_LANG := USERENV('LANG');

1839: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1840: BEGIN
1841: x_okl_data_src_fnctns_tl_rec := p_okl_data_src_fnctns_tl_rec;
1842: x_okl_data_src_fnctns_tl_rec.LANGUAGE := USERENV('LANG');
1843: x_okl_data_src_fnctns_tl_rec.SOURCE_LANG := USERENV('LANG');
1844: RETURN(l_return_status);
1845: END Set_Attributes;
1846: BEGIN
1847: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1858: p_okl_data_src_fnctns_tl_rec, -- IN

1854: RAISE OKC_API.G_EXCEPTION_ERROR;
1855: END IF;
1856: --- Setting item attributes
1857: l_return_status := Set_Attributes(
1858: p_okl_data_src_fnctns_tl_rec, -- IN
1859: l_okl_data_src_fnctns_tl_rec); -- OUT
1860: --- If any errors happen abort API
1861: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1862: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1859: l_okl_data_src_fnctns_tl_rec); -- OUT

1855: END IF;
1856: --- Setting item attributes
1857: l_return_status := Set_Attributes(
1858: p_okl_data_src_fnctns_tl_rec, -- IN
1859: l_okl_data_src_fnctns_tl_rec); -- OUT
1860: --- If any errors happen abort API
1861: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1862: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1863: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 1867: l_okl_data_src_fnctns_tl_rec.language := l_lang_rec.language_code;

1863: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1864: RAISE OKC_API.G_EXCEPTION_ERROR;
1865: END IF;
1866: FOR l_lang_rec IN get_languages LOOP
1867: l_okl_data_src_fnctns_tl_rec.language := l_lang_rec.language_code;
1868: INSERT INTO OKL_DATA_SRC_FNCTNS_TL(
1869: id,
1870: language,
1871: source_lang,

Line 1868: INSERT INTO OKL_DATA_SRC_FNCTNS_TL(

1864: RAISE OKC_API.G_EXCEPTION_ERROR;
1865: END IF;
1866: FOR l_lang_rec IN get_languages LOOP
1867: l_okl_data_src_fnctns_tl_rec.language := l_lang_rec.language_code;
1868: INSERT INTO OKL_DATA_SRC_FNCTNS_TL(
1869: id,
1870: language,
1871: source_lang,
1872: sfwt_flag,

Line 1880: l_okl_data_src_fnctns_tl_rec.id,

1876: last_updated_by,
1877: last_update_date,
1878: last_update_login)
1879: VALUES (
1880: l_okl_data_src_fnctns_tl_rec.id,
1881: l_okl_data_src_fnctns_tl_rec.language,
1882: l_okl_data_src_fnctns_tl_rec.source_lang,
1883: l_okl_data_src_fnctns_tl_rec.sfwt_flag,
1884: l_okl_data_src_fnctns_tl_rec.description,

Line 1881: l_okl_data_src_fnctns_tl_rec.language,

1877: last_update_date,
1878: last_update_login)
1879: VALUES (
1880: l_okl_data_src_fnctns_tl_rec.id,
1881: l_okl_data_src_fnctns_tl_rec.language,
1882: l_okl_data_src_fnctns_tl_rec.source_lang,
1883: l_okl_data_src_fnctns_tl_rec.sfwt_flag,
1884: l_okl_data_src_fnctns_tl_rec.description,
1885: l_okl_data_src_fnctns_tl_rec.created_by,

Line 1882: l_okl_data_src_fnctns_tl_rec.source_lang,

1878: last_update_login)
1879: VALUES (
1880: l_okl_data_src_fnctns_tl_rec.id,
1881: l_okl_data_src_fnctns_tl_rec.language,
1882: l_okl_data_src_fnctns_tl_rec.source_lang,
1883: l_okl_data_src_fnctns_tl_rec.sfwt_flag,
1884: l_okl_data_src_fnctns_tl_rec.description,
1885: l_okl_data_src_fnctns_tl_rec.created_by,
1886: l_okl_data_src_fnctns_tl_rec.creation_date,

Line 1883: l_okl_data_src_fnctns_tl_rec.sfwt_flag,

1879: VALUES (
1880: l_okl_data_src_fnctns_tl_rec.id,
1881: l_okl_data_src_fnctns_tl_rec.language,
1882: l_okl_data_src_fnctns_tl_rec.source_lang,
1883: l_okl_data_src_fnctns_tl_rec.sfwt_flag,
1884: l_okl_data_src_fnctns_tl_rec.description,
1885: l_okl_data_src_fnctns_tl_rec.created_by,
1886: l_okl_data_src_fnctns_tl_rec.creation_date,
1887: l_okl_data_src_fnctns_tl_rec.last_updated_by,

Line 1884: l_okl_data_src_fnctns_tl_rec.description,

1880: l_okl_data_src_fnctns_tl_rec.id,
1881: l_okl_data_src_fnctns_tl_rec.language,
1882: l_okl_data_src_fnctns_tl_rec.source_lang,
1883: l_okl_data_src_fnctns_tl_rec.sfwt_flag,
1884: l_okl_data_src_fnctns_tl_rec.description,
1885: l_okl_data_src_fnctns_tl_rec.created_by,
1886: l_okl_data_src_fnctns_tl_rec.creation_date,
1887: l_okl_data_src_fnctns_tl_rec.last_updated_by,
1888: l_okl_data_src_fnctns_tl_rec.last_update_date,

Line 1885: l_okl_data_src_fnctns_tl_rec.created_by,

1881: l_okl_data_src_fnctns_tl_rec.language,
1882: l_okl_data_src_fnctns_tl_rec.source_lang,
1883: l_okl_data_src_fnctns_tl_rec.sfwt_flag,
1884: l_okl_data_src_fnctns_tl_rec.description,
1885: l_okl_data_src_fnctns_tl_rec.created_by,
1886: l_okl_data_src_fnctns_tl_rec.creation_date,
1887: l_okl_data_src_fnctns_tl_rec.last_updated_by,
1888: l_okl_data_src_fnctns_tl_rec.last_update_date,
1889: l_okl_data_src_fnctns_tl_rec.last_update_login);

Line 1886: l_okl_data_src_fnctns_tl_rec.creation_date,

1882: l_okl_data_src_fnctns_tl_rec.source_lang,
1883: l_okl_data_src_fnctns_tl_rec.sfwt_flag,
1884: l_okl_data_src_fnctns_tl_rec.description,
1885: l_okl_data_src_fnctns_tl_rec.created_by,
1886: l_okl_data_src_fnctns_tl_rec.creation_date,
1887: l_okl_data_src_fnctns_tl_rec.last_updated_by,
1888: l_okl_data_src_fnctns_tl_rec.last_update_date,
1889: l_okl_data_src_fnctns_tl_rec.last_update_login);
1890: END LOOP;

Line 1887: l_okl_data_src_fnctns_tl_rec.last_updated_by,

1883: l_okl_data_src_fnctns_tl_rec.sfwt_flag,
1884: l_okl_data_src_fnctns_tl_rec.description,
1885: l_okl_data_src_fnctns_tl_rec.created_by,
1886: l_okl_data_src_fnctns_tl_rec.creation_date,
1887: l_okl_data_src_fnctns_tl_rec.last_updated_by,
1888: l_okl_data_src_fnctns_tl_rec.last_update_date,
1889: l_okl_data_src_fnctns_tl_rec.last_update_login);
1890: END LOOP;
1891: -- Set OUT values

Line 1888: l_okl_data_src_fnctns_tl_rec.last_update_date,

1884: l_okl_data_src_fnctns_tl_rec.description,
1885: l_okl_data_src_fnctns_tl_rec.created_by,
1886: l_okl_data_src_fnctns_tl_rec.creation_date,
1887: l_okl_data_src_fnctns_tl_rec.last_updated_by,
1888: l_okl_data_src_fnctns_tl_rec.last_update_date,
1889: l_okl_data_src_fnctns_tl_rec.last_update_login);
1890: END LOOP;
1891: -- Set OUT values
1892: x_okl_data_src_fnctns_tl_rec := l_okl_data_src_fnctns_tl_rec;

Line 1889: l_okl_data_src_fnctns_tl_rec.last_update_login);

1885: l_okl_data_src_fnctns_tl_rec.created_by,
1886: l_okl_data_src_fnctns_tl_rec.creation_date,
1887: l_okl_data_src_fnctns_tl_rec.last_updated_by,
1888: l_okl_data_src_fnctns_tl_rec.last_update_date,
1889: l_okl_data_src_fnctns_tl_rec.last_update_login);
1890: END LOOP;
1891: -- Set OUT values
1892: x_okl_data_src_fnctns_tl_rec := l_okl_data_src_fnctns_tl_rec;
1893: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1892: x_okl_data_src_fnctns_tl_rec := l_okl_data_src_fnctns_tl_rec;

1888: l_okl_data_src_fnctns_tl_rec.last_update_date,
1889: l_okl_data_src_fnctns_tl_rec.last_update_login);
1890: END LOOP;
1891: -- Set OUT values
1892: x_okl_data_src_fnctns_tl_rec := l_okl_data_src_fnctns_tl_rec;
1893: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1894: EXCEPTION
1895: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1896: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1945: l_okl_data_src_fnctns_tl_rec OklDataSrcFnctnsTlRecType;

1941: l_dsfv_rec dsfv_rec_type;
1942: l_def_dsfv_rec dsfv_rec_type;
1943: l_dsf_rec dsf_rec_type;
1944: lx_dsf_rec dsf_rec_type;
1945: l_okl_data_src_fnctns_tl_rec OklDataSrcFnctnsTlRecType;
1946: lx_okl_data_src_fnctns_tl_rec OklDataSrcFnctnsTlRecType;
1947: -------------------------------
1948: -- FUNCTION fill_who_columns --
1949: -------------------------------

Line 1946: lx_okl_data_src_fnctns_tl_rec OklDataSrcFnctnsTlRecType;

1942: l_def_dsfv_rec dsfv_rec_type;
1943: l_dsf_rec dsf_rec_type;
1944: lx_dsf_rec dsf_rec_type;
1945: l_okl_data_src_fnctns_tl_rec OklDataSrcFnctnsTlRecType;
1946: lx_okl_data_src_fnctns_tl_rec OklDataSrcFnctnsTlRecType;
1947: -------------------------------
1948: -- FUNCTION fill_who_columns --
1949: -------------------------------
1950: FUNCTION fill_who_columns (

Line 2021: migrate(l_def_dsfv_rec, l_okl_data_src_fnctns_tl_rec);

2017: --------------------------------------
2018: -- Move VIEW record to "Child" records
2019: --------------------------------------
2020: migrate(l_def_dsfv_rec, l_dsf_rec);
2021: migrate(l_def_dsfv_rec, l_okl_data_src_fnctns_tl_rec);
2022: --------------------------------------------
2023: -- Call the INSERT_ROW for each child record
2024: --------------------------------------------
2025: insert_row(

Line 2044: l_okl_data_src_fnctns_tl_rec,

2040: p_init_msg_list,
2041: x_return_status,
2042: x_msg_count,
2043: x_msg_data,
2044: l_okl_data_src_fnctns_tl_rec,
2045: lx_okl_data_src_fnctns_tl_rec
2046: );
2047: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2048: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2045: lx_okl_data_src_fnctns_tl_rec

2041: x_return_status,
2042: x_msg_count,
2043: x_msg_data,
2044: l_okl_data_src_fnctns_tl_rec,
2045: lx_okl_data_src_fnctns_tl_rec
2046: );
2047: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2048: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2049: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2052: migrate(lx_okl_data_src_fnctns_tl_rec, l_def_dsfv_rec);

2048: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2049: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2050: RAISE OKC_API.G_EXCEPTION_ERROR;
2051: END IF;
2052: migrate(lx_okl_data_src_fnctns_tl_rec, l_def_dsfv_rec);
2053: -- Set OUT values
2054: x_dsfv_rec := l_def_dsfv_rec;
2055: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2056: EXCEPTION

Line 2276: -- lock_row for:OKL_DATA_SRC_FNCTNS_TL --

2272: '_PVT'
2273: );
2274: END lock_row;
2275: -----------------------------------------
2276: -- lock_row for:OKL_DATA_SRC_FNCTNS_TL --
2277: -----------------------------------------
2278: PROCEDURE lock_row(
2279: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2280: x_return_status OUT NOCOPY VARCHAR2,

Line 2283: p_okl_data_src_fnctns_tl_rec IN OklDataSrcFnctnsTlRecType) IS

2279: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2280: x_return_status OUT NOCOPY VARCHAR2,
2281: x_msg_count OUT NOCOPY NUMBER,
2282: x_msg_data OUT NOCOPY VARCHAR2,
2283: p_okl_data_src_fnctns_tl_rec IN OklDataSrcFnctnsTlRecType) IS
2284:
2285: E_Resource_Busy EXCEPTION;
2286: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2287: CURSOR lock_csr (p_okl_data_src_fnctns_tl_rec IN OklDataSrcFnctnsTlRecType) IS

Line 2287: CURSOR lock_csr (p_okl_data_src_fnctns_tl_rec IN OklDataSrcFnctnsTlRecType) IS

2283: p_okl_data_src_fnctns_tl_rec IN OklDataSrcFnctnsTlRecType) IS
2284:
2285: E_Resource_Busy EXCEPTION;
2286: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2287: CURSOR lock_csr (p_okl_data_src_fnctns_tl_rec IN OklDataSrcFnctnsTlRecType) IS
2288: SELECT *
2289: FROM OKL_DATA_SRC_FNCTNS_TL
2290: WHERE ID = p_okl_data_src_fnctns_tl_rec.id
2291: FOR UPDATE NOWAIT;

Line 2289: FROM OKL_DATA_SRC_FNCTNS_TL

2285: E_Resource_Busy EXCEPTION;
2286: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2287: CURSOR lock_csr (p_okl_data_src_fnctns_tl_rec IN OklDataSrcFnctnsTlRecType) IS
2288: SELECT *
2289: FROM OKL_DATA_SRC_FNCTNS_TL
2290: WHERE ID = p_okl_data_src_fnctns_tl_rec.id
2291: FOR UPDATE NOWAIT;
2292:
2293: l_api_version CONSTANT NUMBER := 1;

Line 2290: WHERE ID = p_okl_data_src_fnctns_tl_rec.id

2286: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2287: CURSOR lock_csr (p_okl_data_src_fnctns_tl_rec IN OklDataSrcFnctnsTlRecType) IS
2288: SELECT *
2289: FROM OKL_DATA_SRC_FNCTNS_TL
2290: WHERE ID = p_okl_data_src_fnctns_tl_rec.id
2291: FOR UPDATE NOWAIT;
2292:
2293: l_api_version CONSTANT NUMBER := 1;
2294: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';

Line 2310: OPEN lock_csr(p_okl_data_src_fnctns_tl_rec);

2306: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2307: RAISE OKC_API.G_EXCEPTION_ERROR;
2308: END IF;
2309: BEGIN
2310: OPEN lock_csr(p_okl_data_src_fnctns_tl_rec);
2311: FETCH lock_csr INTO l_lock_var;
2312: l_row_notfound := lock_csr%NOTFOUND;
2313: CLOSE lock_csr;
2314: EXCEPTION

Line 2375: l_okl_data_src_fnctns_tl_rec OklDataSrcFnctnsTlRecType;

2371: l_api_version CONSTANT NUMBER := 1;
2372: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
2373: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2374: l_dsf_rec dsf_rec_type;
2375: l_okl_data_src_fnctns_tl_rec OklDataSrcFnctnsTlRecType;
2376: BEGIN
2377: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2378: G_PKG_NAME,
2379: p_init_msg_list,

Line 2393: migrate(p_dsfv_rec, l_okl_data_src_fnctns_tl_rec);

2389: --------------------------------------
2390: -- Move VIEW record to "Child" records
2391: --------------------------------------
2392: migrate(p_dsfv_rec, l_dsf_rec);
2393: migrate(p_dsfv_rec, l_okl_data_src_fnctns_tl_rec);
2394: --------------------------------------------
2395: -- Call the LOCK_ROW for each child record
2396: --------------------------------------------
2397: lock_row(

Line 2414: l_okl_data_src_fnctns_tl_rec

2410: p_init_msg_list,
2411: x_return_status,
2412: x_msg_count,
2413: x_msg_data,
2414: l_okl_data_src_fnctns_tl_rec
2415: );
2416: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2417: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2418: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2794: -- update_row for:OKL_DATA_SRC_FNCTNS_TL --

2790: '_PVT'
2791: );
2792: END update_row;
2793: -------------------------------------------
2794: -- update_row for:OKL_DATA_SRC_FNCTNS_TL --
2795: -------------------------------------------
2796: PROCEDURE update_row(
2797: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2798: x_return_status OUT NOCOPY VARCHAR2,

Line 2801: p_okl_data_src_fnctns_tl_rec IN OklDataSrcFnctnsTlRecType,

2797: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2798: x_return_status OUT NOCOPY VARCHAR2,
2799: x_msg_count OUT NOCOPY NUMBER,
2800: x_msg_data OUT NOCOPY VARCHAR2,
2801: p_okl_data_src_fnctns_tl_rec IN OklDataSrcFnctnsTlRecType,
2802: x_okl_data_src_fnctns_tl_rec OUT NOCOPY OklDataSrcFnctnsTlRecType) IS
2803:
2804: l_api_version CONSTANT NUMBER := 1;
2805: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';

Line 2802: x_okl_data_src_fnctns_tl_rec OUT NOCOPY OklDataSrcFnctnsTlRecType) IS

2798: x_return_status OUT NOCOPY VARCHAR2,
2799: x_msg_count OUT NOCOPY NUMBER,
2800: x_msg_data OUT NOCOPY VARCHAR2,
2801: p_okl_data_src_fnctns_tl_rec IN OklDataSrcFnctnsTlRecType,
2802: x_okl_data_src_fnctns_tl_rec OUT NOCOPY OklDataSrcFnctnsTlRecType) IS
2803:
2804: l_api_version CONSTANT NUMBER := 1;
2805: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2806: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2807: l_okl_data_src_fnctns_tl_rec OklDataSrcFnctnsTlRecType := p_okl_data_src_fnctns_tl_rec;

2803:
2804: l_api_version CONSTANT NUMBER := 1;
2805: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2806: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2807: l_okl_data_src_fnctns_tl_rec OklDataSrcFnctnsTlRecType := p_okl_data_src_fnctns_tl_rec;
2808: ldefokldatasrcfnctnstlrec OklDataSrcFnctnsTlRecType;
2809: l_row_notfound BOOLEAN := TRUE;
2810: ----------------------------------
2811: -- FUNCTION populate_new_record --

Line 2814: p_okl_data_src_fnctns_tl_rec IN OklDataSrcFnctnsTlRecType,

2810: ----------------------------------
2811: -- FUNCTION populate_new_record --
2812: ----------------------------------
2813: FUNCTION populate_new_record (
2814: p_okl_data_src_fnctns_tl_rec IN OklDataSrcFnctnsTlRecType,
2815: x_okl_data_src_fnctns_tl_rec OUT NOCOPY OklDataSrcFnctnsTlRecType
2816: ) RETURN VARCHAR2 IS
2817: l_okl_data_src_fnctns_tl_rec OklDataSrcFnctnsTlRecType;
2818: l_row_notfound BOOLEAN := TRUE;

Line 2815: x_okl_data_src_fnctns_tl_rec OUT NOCOPY OklDataSrcFnctnsTlRecType

2811: -- FUNCTION populate_new_record --
2812: ----------------------------------
2813: FUNCTION populate_new_record (
2814: p_okl_data_src_fnctns_tl_rec IN OklDataSrcFnctnsTlRecType,
2815: x_okl_data_src_fnctns_tl_rec OUT NOCOPY OklDataSrcFnctnsTlRecType
2816: ) RETURN VARCHAR2 IS
2817: l_okl_data_src_fnctns_tl_rec OklDataSrcFnctnsTlRecType;
2818: l_row_notfound BOOLEAN := TRUE;
2819: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2817: l_okl_data_src_fnctns_tl_rec OklDataSrcFnctnsTlRecType;

2813: FUNCTION populate_new_record (
2814: p_okl_data_src_fnctns_tl_rec IN OklDataSrcFnctnsTlRecType,
2815: x_okl_data_src_fnctns_tl_rec OUT NOCOPY OklDataSrcFnctnsTlRecType
2816: ) RETURN VARCHAR2 IS
2817: l_okl_data_src_fnctns_tl_rec OklDataSrcFnctnsTlRecType;
2818: l_row_notfound BOOLEAN := TRUE;
2819: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2820: BEGIN
2821: x_okl_data_src_fnctns_tl_rec := p_okl_data_src_fnctns_tl_rec;

Line 2821: x_okl_data_src_fnctns_tl_rec := p_okl_data_src_fnctns_tl_rec;

2817: l_okl_data_src_fnctns_tl_rec OklDataSrcFnctnsTlRecType;
2818: l_row_notfound BOOLEAN := TRUE;
2819: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2820: BEGIN
2821: x_okl_data_src_fnctns_tl_rec := p_okl_data_src_fnctns_tl_rec;
2822: -- Get current database values
2823: l_okl_data_src_fnctns_tl_rec := get_rec(p_okl_data_src_fnctns_tl_rec, l_row_notfound);
2824: IF (l_row_notfound) THEN
2825: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

Line 2823: l_okl_data_src_fnctns_tl_rec := get_rec(p_okl_data_src_fnctns_tl_rec, l_row_notfound);

2819: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2820: BEGIN
2821: x_okl_data_src_fnctns_tl_rec := p_okl_data_src_fnctns_tl_rec;
2822: -- Get current database values
2823: l_okl_data_src_fnctns_tl_rec := get_rec(p_okl_data_src_fnctns_tl_rec, l_row_notfound);
2824: IF (l_row_notfound) THEN
2825: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2826: END IF;
2827: IF (x_okl_data_src_fnctns_tl_rec.id = OKC_API.G_MISS_NUM)

Line 2827: IF (x_okl_data_src_fnctns_tl_rec.id = OKC_API.G_MISS_NUM)

2823: l_okl_data_src_fnctns_tl_rec := get_rec(p_okl_data_src_fnctns_tl_rec, l_row_notfound);
2824: IF (l_row_notfound) THEN
2825: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2826: END IF;
2827: IF (x_okl_data_src_fnctns_tl_rec.id = OKC_API.G_MISS_NUM)
2828: THEN
2829: x_okl_data_src_fnctns_tl_rec.id := l_okl_data_src_fnctns_tl_rec.id;
2830: END IF;
2831: IF (x_okl_data_src_fnctns_tl_rec.language = OKC_API.G_MISS_CHAR)

Line 2829: x_okl_data_src_fnctns_tl_rec.id := l_okl_data_src_fnctns_tl_rec.id;

2825: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2826: END IF;
2827: IF (x_okl_data_src_fnctns_tl_rec.id = OKC_API.G_MISS_NUM)
2828: THEN
2829: x_okl_data_src_fnctns_tl_rec.id := l_okl_data_src_fnctns_tl_rec.id;
2830: END IF;
2831: IF (x_okl_data_src_fnctns_tl_rec.language = OKC_API.G_MISS_CHAR)
2832: THEN
2833: x_okl_data_src_fnctns_tl_rec.language := l_okl_data_src_fnctns_tl_rec.language;

Line 2831: IF (x_okl_data_src_fnctns_tl_rec.language = OKC_API.G_MISS_CHAR)

2827: IF (x_okl_data_src_fnctns_tl_rec.id = OKC_API.G_MISS_NUM)
2828: THEN
2829: x_okl_data_src_fnctns_tl_rec.id := l_okl_data_src_fnctns_tl_rec.id;
2830: END IF;
2831: IF (x_okl_data_src_fnctns_tl_rec.language = OKC_API.G_MISS_CHAR)
2832: THEN
2833: x_okl_data_src_fnctns_tl_rec.language := l_okl_data_src_fnctns_tl_rec.language;
2834: END IF;
2835: IF (x_okl_data_src_fnctns_tl_rec.source_lang = OKC_API.G_MISS_CHAR)

Line 2833: x_okl_data_src_fnctns_tl_rec.language := l_okl_data_src_fnctns_tl_rec.language;

2829: x_okl_data_src_fnctns_tl_rec.id := l_okl_data_src_fnctns_tl_rec.id;
2830: END IF;
2831: IF (x_okl_data_src_fnctns_tl_rec.language = OKC_API.G_MISS_CHAR)
2832: THEN
2833: x_okl_data_src_fnctns_tl_rec.language := l_okl_data_src_fnctns_tl_rec.language;
2834: END IF;
2835: IF (x_okl_data_src_fnctns_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2836: THEN
2837: x_okl_data_src_fnctns_tl_rec.source_lang := l_okl_data_src_fnctns_tl_rec.source_lang;

Line 2835: IF (x_okl_data_src_fnctns_tl_rec.source_lang = OKC_API.G_MISS_CHAR)

2831: IF (x_okl_data_src_fnctns_tl_rec.language = OKC_API.G_MISS_CHAR)
2832: THEN
2833: x_okl_data_src_fnctns_tl_rec.language := l_okl_data_src_fnctns_tl_rec.language;
2834: END IF;
2835: IF (x_okl_data_src_fnctns_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2836: THEN
2837: x_okl_data_src_fnctns_tl_rec.source_lang := l_okl_data_src_fnctns_tl_rec.source_lang;
2838: END IF;
2839: IF (x_okl_data_src_fnctns_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)

Line 2837: x_okl_data_src_fnctns_tl_rec.source_lang := l_okl_data_src_fnctns_tl_rec.source_lang;

2833: x_okl_data_src_fnctns_tl_rec.language := l_okl_data_src_fnctns_tl_rec.language;
2834: END IF;
2835: IF (x_okl_data_src_fnctns_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2836: THEN
2837: x_okl_data_src_fnctns_tl_rec.source_lang := l_okl_data_src_fnctns_tl_rec.source_lang;
2838: END IF;
2839: IF (x_okl_data_src_fnctns_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2840: THEN
2841: x_okl_data_src_fnctns_tl_rec.sfwt_flag := l_okl_data_src_fnctns_tl_rec.sfwt_flag;

Line 2839: IF (x_okl_data_src_fnctns_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)

2835: IF (x_okl_data_src_fnctns_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2836: THEN
2837: x_okl_data_src_fnctns_tl_rec.source_lang := l_okl_data_src_fnctns_tl_rec.source_lang;
2838: END IF;
2839: IF (x_okl_data_src_fnctns_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2840: THEN
2841: x_okl_data_src_fnctns_tl_rec.sfwt_flag := l_okl_data_src_fnctns_tl_rec.sfwt_flag;
2842: END IF;
2843: IF (x_okl_data_src_fnctns_tl_rec.description = OKC_API.G_MISS_CHAR)

Line 2841: x_okl_data_src_fnctns_tl_rec.sfwt_flag := l_okl_data_src_fnctns_tl_rec.sfwt_flag;

2837: x_okl_data_src_fnctns_tl_rec.source_lang := l_okl_data_src_fnctns_tl_rec.source_lang;
2838: END IF;
2839: IF (x_okl_data_src_fnctns_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2840: THEN
2841: x_okl_data_src_fnctns_tl_rec.sfwt_flag := l_okl_data_src_fnctns_tl_rec.sfwt_flag;
2842: END IF;
2843: IF (x_okl_data_src_fnctns_tl_rec.description = OKC_API.G_MISS_CHAR)
2844: THEN
2845: x_okl_data_src_fnctns_tl_rec.description := l_okl_data_src_fnctns_tl_rec.description;

Line 2843: IF (x_okl_data_src_fnctns_tl_rec.description = OKC_API.G_MISS_CHAR)

2839: IF (x_okl_data_src_fnctns_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2840: THEN
2841: x_okl_data_src_fnctns_tl_rec.sfwt_flag := l_okl_data_src_fnctns_tl_rec.sfwt_flag;
2842: END IF;
2843: IF (x_okl_data_src_fnctns_tl_rec.description = OKC_API.G_MISS_CHAR)
2844: THEN
2845: x_okl_data_src_fnctns_tl_rec.description := l_okl_data_src_fnctns_tl_rec.description;
2846: END IF;
2847: IF (x_okl_data_src_fnctns_tl_rec.created_by = OKC_API.G_MISS_NUM)

Line 2845: x_okl_data_src_fnctns_tl_rec.description := l_okl_data_src_fnctns_tl_rec.description;

2841: x_okl_data_src_fnctns_tl_rec.sfwt_flag := l_okl_data_src_fnctns_tl_rec.sfwt_flag;
2842: END IF;
2843: IF (x_okl_data_src_fnctns_tl_rec.description = OKC_API.G_MISS_CHAR)
2844: THEN
2845: x_okl_data_src_fnctns_tl_rec.description := l_okl_data_src_fnctns_tl_rec.description;
2846: END IF;
2847: IF (x_okl_data_src_fnctns_tl_rec.created_by = OKC_API.G_MISS_NUM)
2848: THEN
2849: x_okl_data_src_fnctns_tl_rec.created_by := l_okl_data_src_fnctns_tl_rec.created_by;

Line 2847: IF (x_okl_data_src_fnctns_tl_rec.created_by = OKC_API.G_MISS_NUM)

2843: IF (x_okl_data_src_fnctns_tl_rec.description = OKC_API.G_MISS_CHAR)
2844: THEN
2845: x_okl_data_src_fnctns_tl_rec.description := l_okl_data_src_fnctns_tl_rec.description;
2846: END IF;
2847: IF (x_okl_data_src_fnctns_tl_rec.created_by = OKC_API.G_MISS_NUM)
2848: THEN
2849: x_okl_data_src_fnctns_tl_rec.created_by := l_okl_data_src_fnctns_tl_rec.created_by;
2850: END IF;
2851: IF (x_okl_data_src_fnctns_tl_rec.creation_date = OKC_API.G_MISS_DATE)

Line 2849: x_okl_data_src_fnctns_tl_rec.created_by := l_okl_data_src_fnctns_tl_rec.created_by;

2845: x_okl_data_src_fnctns_tl_rec.description := l_okl_data_src_fnctns_tl_rec.description;
2846: END IF;
2847: IF (x_okl_data_src_fnctns_tl_rec.created_by = OKC_API.G_MISS_NUM)
2848: THEN
2849: x_okl_data_src_fnctns_tl_rec.created_by := l_okl_data_src_fnctns_tl_rec.created_by;
2850: END IF;
2851: IF (x_okl_data_src_fnctns_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2852: THEN
2853: x_okl_data_src_fnctns_tl_rec.creation_date := l_okl_data_src_fnctns_tl_rec.creation_date;

Line 2851: IF (x_okl_data_src_fnctns_tl_rec.creation_date = OKC_API.G_MISS_DATE)

2847: IF (x_okl_data_src_fnctns_tl_rec.created_by = OKC_API.G_MISS_NUM)
2848: THEN
2849: x_okl_data_src_fnctns_tl_rec.created_by := l_okl_data_src_fnctns_tl_rec.created_by;
2850: END IF;
2851: IF (x_okl_data_src_fnctns_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2852: THEN
2853: x_okl_data_src_fnctns_tl_rec.creation_date := l_okl_data_src_fnctns_tl_rec.creation_date;
2854: END IF;
2855: IF (x_okl_data_src_fnctns_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)

Line 2853: x_okl_data_src_fnctns_tl_rec.creation_date := l_okl_data_src_fnctns_tl_rec.creation_date;

2849: x_okl_data_src_fnctns_tl_rec.created_by := l_okl_data_src_fnctns_tl_rec.created_by;
2850: END IF;
2851: IF (x_okl_data_src_fnctns_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2852: THEN
2853: x_okl_data_src_fnctns_tl_rec.creation_date := l_okl_data_src_fnctns_tl_rec.creation_date;
2854: END IF;
2855: IF (x_okl_data_src_fnctns_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2856: THEN
2857: x_okl_data_src_fnctns_tl_rec.last_updated_by := l_okl_data_src_fnctns_tl_rec.last_updated_by;

Line 2855: IF (x_okl_data_src_fnctns_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)

2851: IF (x_okl_data_src_fnctns_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2852: THEN
2853: x_okl_data_src_fnctns_tl_rec.creation_date := l_okl_data_src_fnctns_tl_rec.creation_date;
2854: END IF;
2855: IF (x_okl_data_src_fnctns_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2856: THEN
2857: x_okl_data_src_fnctns_tl_rec.last_updated_by := l_okl_data_src_fnctns_tl_rec.last_updated_by;
2858: END IF;
2859: IF (x_okl_data_src_fnctns_tl_rec.last_update_date = OKC_API.G_MISS_DATE)

Line 2857: x_okl_data_src_fnctns_tl_rec.last_updated_by := l_okl_data_src_fnctns_tl_rec.last_updated_by;

2853: x_okl_data_src_fnctns_tl_rec.creation_date := l_okl_data_src_fnctns_tl_rec.creation_date;
2854: END IF;
2855: IF (x_okl_data_src_fnctns_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2856: THEN
2857: x_okl_data_src_fnctns_tl_rec.last_updated_by := l_okl_data_src_fnctns_tl_rec.last_updated_by;
2858: END IF;
2859: IF (x_okl_data_src_fnctns_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2860: THEN
2861: x_okl_data_src_fnctns_tl_rec.last_update_date := l_okl_data_src_fnctns_tl_rec.last_update_date;

Line 2859: IF (x_okl_data_src_fnctns_tl_rec.last_update_date = OKC_API.G_MISS_DATE)

2855: IF (x_okl_data_src_fnctns_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2856: THEN
2857: x_okl_data_src_fnctns_tl_rec.last_updated_by := l_okl_data_src_fnctns_tl_rec.last_updated_by;
2858: END IF;
2859: IF (x_okl_data_src_fnctns_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2860: THEN
2861: x_okl_data_src_fnctns_tl_rec.last_update_date := l_okl_data_src_fnctns_tl_rec.last_update_date;
2862: END IF;
2863: IF (x_okl_data_src_fnctns_tl_rec.last_update_login = OKC_API.G_MISS_NUM)

Line 2861: x_okl_data_src_fnctns_tl_rec.last_update_date := l_okl_data_src_fnctns_tl_rec.last_update_date;

2857: x_okl_data_src_fnctns_tl_rec.last_updated_by := l_okl_data_src_fnctns_tl_rec.last_updated_by;
2858: END IF;
2859: IF (x_okl_data_src_fnctns_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2860: THEN
2861: x_okl_data_src_fnctns_tl_rec.last_update_date := l_okl_data_src_fnctns_tl_rec.last_update_date;
2862: END IF;
2863: IF (x_okl_data_src_fnctns_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
2864: THEN
2865: x_okl_data_src_fnctns_tl_rec.last_update_login := l_okl_data_src_fnctns_tl_rec.last_update_login;

Line 2863: IF (x_okl_data_src_fnctns_tl_rec.last_update_login = OKC_API.G_MISS_NUM)

2859: IF (x_okl_data_src_fnctns_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2860: THEN
2861: x_okl_data_src_fnctns_tl_rec.last_update_date := l_okl_data_src_fnctns_tl_rec.last_update_date;
2862: END IF;
2863: IF (x_okl_data_src_fnctns_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
2864: THEN
2865: x_okl_data_src_fnctns_tl_rec.last_update_login := l_okl_data_src_fnctns_tl_rec.last_update_login;
2866: END IF;
2867: RETURN(l_return_status);

Line 2865: x_okl_data_src_fnctns_tl_rec.last_update_login := l_okl_data_src_fnctns_tl_rec.last_update_login;

2861: x_okl_data_src_fnctns_tl_rec.last_update_date := l_okl_data_src_fnctns_tl_rec.last_update_date;
2862: END IF;
2863: IF (x_okl_data_src_fnctns_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
2864: THEN
2865: x_okl_data_src_fnctns_tl_rec.last_update_login := l_okl_data_src_fnctns_tl_rec.last_update_login;
2866: END IF;
2867: RETURN(l_return_status);
2868: END populate_new_record;
2869: -----------------------------------------------

Line 2870: -- Set_Attributes for:OKL_DATA_SRC_FNCTNS_TL --

2866: END IF;
2867: RETURN(l_return_status);
2868: END populate_new_record;
2869: -----------------------------------------------
2870: -- Set_Attributes for:OKL_DATA_SRC_FNCTNS_TL --
2871: -----------------------------------------------
2872: FUNCTION Set_Attributes (
2873: p_okl_data_src_fnctns_tl_rec IN OklDataSrcFnctnsTlRecType,
2874: x_okl_data_src_fnctns_tl_rec OUT NOCOPY OklDataSrcFnctnsTlRecType

Line 2873: p_okl_data_src_fnctns_tl_rec IN OklDataSrcFnctnsTlRecType,

2869: -----------------------------------------------
2870: -- Set_Attributes for:OKL_DATA_SRC_FNCTNS_TL --
2871: -----------------------------------------------
2872: FUNCTION Set_Attributes (
2873: p_okl_data_src_fnctns_tl_rec IN OklDataSrcFnctnsTlRecType,
2874: x_okl_data_src_fnctns_tl_rec OUT NOCOPY OklDataSrcFnctnsTlRecType
2875: ) RETURN VARCHAR2 IS
2876: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2877: BEGIN

Line 2874: x_okl_data_src_fnctns_tl_rec OUT NOCOPY OklDataSrcFnctnsTlRecType

2870: -- Set_Attributes for:OKL_DATA_SRC_FNCTNS_TL --
2871: -----------------------------------------------
2872: FUNCTION Set_Attributes (
2873: p_okl_data_src_fnctns_tl_rec IN OklDataSrcFnctnsTlRecType,
2874: x_okl_data_src_fnctns_tl_rec OUT NOCOPY OklDataSrcFnctnsTlRecType
2875: ) RETURN VARCHAR2 IS
2876: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2877: BEGIN
2878: x_okl_data_src_fnctns_tl_rec := p_okl_data_src_fnctns_tl_rec;

Line 2878: x_okl_data_src_fnctns_tl_rec := p_okl_data_src_fnctns_tl_rec;

2874: x_okl_data_src_fnctns_tl_rec OUT NOCOPY OklDataSrcFnctnsTlRecType
2875: ) RETURN VARCHAR2 IS
2876: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2877: BEGIN
2878: x_okl_data_src_fnctns_tl_rec := p_okl_data_src_fnctns_tl_rec;
2879: x_okl_data_src_fnctns_tl_rec.LANGUAGE := USERENV('LANG');
2880: x_okl_data_src_fnctns_tl_rec.SOURCE_LANG := USERENV('LANG');
2881: RETURN(l_return_status);
2882: END Set_Attributes;

Line 2879: x_okl_data_src_fnctns_tl_rec.LANGUAGE := USERENV('LANG');

2875: ) RETURN VARCHAR2 IS
2876: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2877: BEGIN
2878: x_okl_data_src_fnctns_tl_rec := p_okl_data_src_fnctns_tl_rec;
2879: x_okl_data_src_fnctns_tl_rec.LANGUAGE := USERENV('LANG');
2880: x_okl_data_src_fnctns_tl_rec.SOURCE_LANG := USERENV('LANG');
2881: RETURN(l_return_status);
2882: END Set_Attributes;
2883: BEGIN

Line 2880: x_okl_data_src_fnctns_tl_rec.SOURCE_LANG := USERENV('LANG');

2876: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2877: BEGIN
2878: x_okl_data_src_fnctns_tl_rec := p_okl_data_src_fnctns_tl_rec;
2879: x_okl_data_src_fnctns_tl_rec.LANGUAGE := USERENV('LANG');
2880: x_okl_data_src_fnctns_tl_rec.SOURCE_LANG := USERENV('LANG');
2881: RETURN(l_return_status);
2882: END Set_Attributes;
2883: BEGIN
2884: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2895: p_okl_data_src_fnctns_tl_rec, -- IN

2891: RAISE OKC_API.G_EXCEPTION_ERROR;
2892: END IF;
2893: --- Setting item attributes
2894: l_return_status := Set_Attributes(
2895: p_okl_data_src_fnctns_tl_rec, -- IN
2896: l_okl_data_src_fnctns_tl_rec); -- OUT
2897: --- If any errors happen abort API
2898: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2899: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2896: l_okl_data_src_fnctns_tl_rec); -- OUT

2892: END IF;
2893: --- Setting item attributes
2894: l_return_status := Set_Attributes(
2895: p_okl_data_src_fnctns_tl_rec, -- IN
2896: l_okl_data_src_fnctns_tl_rec); -- OUT
2897: --- If any errors happen abort API
2898: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2899: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2900: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2903: l_return_status := populate_new_record(l_okl_data_src_fnctns_tl_rec, ldefokldatasrcfnctnstlrec);

2899: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2900: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2901: RAISE OKC_API.G_EXCEPTION_ERROR;
2902: END IF;
2903: l_return_status := populate_new_record(l_okl_data_src_fnctns_tl_rec, ldefokldatasrcfnctnstlrec);
2904: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2905: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2906: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2907: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 2909: UPDATE OKL_DATA_SRC_FNCTNS_TL

2905: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2906: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2907: RAISE OKC_API.G_EXCEPTION_ERROR;
2908: END IF;
2909: UPDATE OKL_DATA_SRC_FNCTNS_TL
2910: SET DESCRIPTION = ldefokldatasrcfnctnstlrec.description,
2911: CREATED_BY = ldefokldatasrcfnctnstlrec.created_by,
2912: SOURCE_LANG = ldefokldatasrcfnctnstlrec.source_lang,
2913: CREATION_DATE = ldefokldatasrcfnctnstlrec.creation_date,

Line 2921: UPDATE OKL_DATA_SRC_FNCTNS_TL

2917: WHERE ID = ldefokldatasrcfnctnstlrec.id
2918: AND USERENV('LANG') in (SOURCE_LANG, LANGUAGE);
2919: --AND SOURCE_LANG = USERENV('LANG');
2920:
2921: UPDATE OKL_DATA_SRC_FNCTNS_TL
2922: SET SFWT_FLAG = 'Y'
2923: WHERE ID = ldefokldatasrcfnctnstlrec.id
2924: AND SOURCE_LANG <> USERENV('LANG');
2925:

Line 2926: x_okl_data_src_fnctns_tl_rec := ldefokldatasrcfnctnstlrec;

2922: SET SFWT_FLAG = 'Y'
2923: WHERE ID = ldefokldatasrcfnctnstlrec.id
2924: AND SOURCE_LANG <> USERENV('LANG');
2925:
2926: x_okl_data_src_fnctns_tl_rec := ldefokldatasrcfnctnstlrec;
2927: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2928: EXCEPTION
2929: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2930: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 2977: l_okl_data_src_fnctns_tl_rec OklDataSrcFnctnsTlRecType;

2973: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
2974: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2975: l_dsfv_rec dsfv_rec_type := p_dsfv_rec;
2976: l_def_dsfv_rec dsfv_rec_type;
2977: l_okl_data_src_fnctns_tl_rec OklDataSrcFnctnsTlRecType;
2978: lx_okl_data_src_fnctns_tl_rec OklDataSrcFnctnsTlRecType;
2979: l_dsf_rec dsf_rec_type;
2980: lx_dsf_rec dsf_rec_type;
2981: -------------------------------

Line 2978: lx_okl_data_src_fnctns_tl_rec OklDataSrcFnctnsTlRecType;

2974: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2975: l_dsfv_rec dsfv_rec_type := p_dsfv_rec;
2976: l_def_dsfv_rec dsfv_rec_type;
2977: l_okl_data_src_fnctns_tl_rec OklDataSrcFnctnsTlRecType;
2978: lx_okl_data_src_fnctns_tl_rec OklDataSrcFnctnsTlRecType;
2979: l_dsf_rec dsf_rec_type;
2980: lx_dsf_rec dsf_rec_type;
2981: -------------------------------
2982: -- FUNCTION fill_who_columns --

Line 3202: migrate(l_def_dsfv_rec, l_okl_data_src_fnctns_tl_rec);

3198:
3199: --------------------------------------
3200: -- Move VIEW record to "Child" records
3201: --------------------------------------
3202: migrate(l_def_dsfv_rec, l_okl_data_src_fnctns_tl_rec);
3203: migrate(l_def_dsfv_rec, l_dsf_rec);
3204: --------------------------------------------
3205: -- Call the UPDATE_ROW for each child record
3206: --------------------------------------------

Line 3212: l_okl_data_src_fnctns_tl_rec,

3208: p_init_msg_list,
3209: x_return_status,
3210: x_msg_count,
3211: x_msg_data,
3212: l_okl_data_src_fnctns_tl_rec,
3213: lx_okl_data_src_fnctns_tl_rec
3214: );
3215: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3216: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3213: lx_okl_data_src_fnctns_tl_rec

3209: x_return_status,
3210: x_msg_count,
3211: x_msg_data,
3212: l_okl_data_src_fnctns_tl_rec,
3213: lx_okl_data_src_fnctns_tl_rec
3214: );
3215: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3216: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3217: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 3220: migrate(lx_okl_data_src_fnctns_tl_rec, l_def_dsfv_rec);

3216: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3217: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3218: RAISE OKC_API.G_EXCEPTION_ERROR;
3219: END IF;
3220: migrate(lx_okl_data_src_fnctns_tl_rec, l_def_dsfv_rec);
3221: update_row(
3222: p_init_msg_list,
3223: x_return_status,
3224: x_msg_count,

Line 3412: -- delete_row for:OKL_DATA_SRC_FNCTNS_TL --

3408: '_PVT'
3409: );
3410: END delete_row;
3411: -------------------------------------------
3412: -- delete_row for:OKL_DATA_SRC_FNCTNS_TL --
3413: -------------------------------------------
3414: PROCEDURE delete_row(
3415: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3416: x_return_status OUT NOCOPY VARCHAR2,

Line 3419: p_okl_data_src_fnctns_tl_rec IN OklDataSrcFnctnsTlRecType) IS

3415: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3416: x_return_status OUT NOCOPY VARCHAR2,
3417: x_msg_count OUT NOCOPY NUMBER,
3418: x_msg_data OUT NOCOPY VARCHAR2,
3419: p_okl_data_src_fnctns_tl_rec IN OklDataSrcFnctnsTlRecType) IS
3420:
3421: l_api_version CONSTANT NUMBER := 1;
3422: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3423: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 3424: l_okl_data_src_fnctns_tl_rec OklDataSrcFnctnsTlRecType:= p_okl_data_src_fnctns_tl_rec;

3420:
3421: l_api_version CONSTANT NUMBER := 1;
3422: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3423: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3424: l_okl_data_src_fnctns_tl_rec OklDataSrcFnctnsTlRecType:= p_okl_data_src_fnctns_tl_rec;
3425: l_row_notfound BOOLEAN := TRUE;
3426: -----------------------------------------------
3427: -- Set_Attributes for:OKL_DATA_SRC_FNCTNS_TL --
3428: -----------------------------------------------

Line 3427: -- Set_Attributes for:OKL_DATA_SRC_FNCTNS_TL --

3423: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3424: l_okl_data_src_fnctns_tl_rec OklDataSrcFnctnsTlRecType:= p_okl_data_src_fnctns_tl_rec;
3425: l_row_notfound BOOLEAN := TRUE;
3426: -----------------------------------------------
3427: -- Set_Attributes for:OKL_DATA_SRC_FNCTNS_TL --
3428: -----------------------------------------------
3429: FUNCTION Set_Attributes (
3430: p_okl_data_src_fnctns_tl_rec IN OklDataSrcFnctnsTlRecType,
3431: x_okl_data_src_fnctns_tl_rec OUT NOCOPY OklDataSrcFnctnsTlRecType

Line 3430: p_okl_data_src_fnctns_tl_rec IN OklDataSrcFnctnsTlRecType,

3426: -----------------------------------------------
3427: -- Set_Attributes for:OKL_DATA_SRC_FNCTNS_TL --
3428: -----------------------------------------------
3429: FUNCTION Set_Attributes (
3430: p_okl_data_src_fnctns_tl_rec IN OklDataSrcFnctnsTlRecType,
3431: x_okl_data_src_fnctns_tl_rec OUT NOCOPY OklDataSrcFnctnsTlRecType
3432: ) RETURN VARCHAR2 IS
3433: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3434: BEGIN

Line 3431: x_okl_data_src_fnctns_tl_rec OUT NOCOPY OklDataSrcFnctnsTlRecType

3427: -- Set_Attributes for:OKL_DATA_SRC_FNCTNS_TL --
3428: -----------------------------------------------
3429: FUNCTION Set_Attributes (
3430: p_okl_data_src_fnctns_tl_rec IN OklDataSrcFnctnsTlRecType,
3431: x_okl_data_src_fnctns_tl_rec OUT NOCOPY OklDataSrcFnctnsTlRecType
3432: ) RETURN VARCHAR2 IS
3433: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3434: BEGIN
3435: x_okl_data_src_fnctns_tl_rec := p_okl_data_src_fnctns_tl_rec;

Line 3435: x_okl_data_src_fnctns_tl_rec := p_okl_data_src_fnctns_tl_rec;

3431: x_okl_data_src_fnctns_tl_rec OUT NOCOPY OklDataSrcFnctnsTlRecType
3432: ) RETURN VARCHAR2 IS
3433: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3434: BEGIN
3435: x_okl_data_src_fnctns_tl_rec := p_okl_data_src_fnctns_tl_rec;
3436: x_okl_data_src_fnctns_tl_rec.LANGUAGE := USERENV('LANG');
3437: RETURN(l_return_status);
3438: END Set_Attributes;
3439: BEGIN

Line 3436: x_okl_data_src_fnctns_tl_rec.LANGUAGE := USERENV('LANG');

3432: ) RETURN VARCHAR2 IS
3433: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3434: BEGIN
3435: x_okl_data_src_fnctns_tl_rec := p_okl_data_src_fnctns_tl_rec;
3436: x_okl_data_src_fnctns_tl_rec.LANGUAGE := USERENV('LANG');
3437: RETURN(l_return_status);
3438: END Set_Attributes;
3439: BEGIN
3440: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3451: p_okl_data_src_fnctns_tl_rec, -- IN

3447: RAISE OKC_API.G_EXCEPTION_ERROR;
3448: END IF;
3449: --- Setting item attributes
3450: l_return_status := Set_Attributes(
3451: p_okl_data_src_fnctns_tl_rec, -- IN
3452: l_okl_data_src_fnctns_tl_rec); -- OUT
3453: --- If any errors happen abort API
3454: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3455: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3452: l_okl_data_src_fnctns_tl_rec); -- OUT

3448: END IF;
3449: --- Setting item attributes
3450: l_return_status := Set_Attributes(
3451: p_okl_data_src_fnctns_tl_rec, -- IN
3452: l_okl_data_src_fnctns_tl_rec); -- OUT
3453: --- If any errors happen abort API
3454: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3455: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3456: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 3459: DELETE FROM OKL_DATA_SRC_FNCTNS_TL

3455: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3456: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3457: RAISE OKC_API.G_EXCEPTION_ERROR;
3458: END IF;
3459: DELETE FROM OKL_DATA_SRC_FNCTNS_TL
3460: WHERE ID = l_okl_data_src_fnctns_tl_rec.id;
3461:
3462: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3463: EXCEPTION

Line 3460: WHERE ID = l_okl_data_src_fnctns_tl_rec.id;

3456: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3457: RAISE OKC_API.G_EXCEPTION_ERROR;
3458: END IF;
3459: DELETE FROM OKL_DATA_SRC_FNCTNS_TL
3460: WHERE ID = l_okl_data_src_fnctns_tl_rec.id;
3461:
3462: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3463: EXCEPTION
3464: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 3510: l_okl_data_src_fnctns_tl_rec OklDataSrcFnctnsTlRecType;

3506: l_api_version CONSTANT NUMBER := 1;
3507: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
3508: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3509: l_dsfv_rec dsfv_rec_type := p_dsfv_rec;
3510: l_okl_data_src_fnctns_tl_rec OklDataSrcFnctnsTlRecType;
3511: l_dsf_rec dsf_rec_type;
3512: BEGIN
3513: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
3514: G_PKG_NAME,

Line 3528: migrate(l_dsfv_rec, l_okl_data_src_fnctns_tl_rec);

3524: END IF;
3525: --------------------------------------
3526: -- Move VIEW record to "Child" records
3527: --------------------------------------
3528: migrate(l_dsfv_rec, l_okl_data_src_fnctns_tl_rec);
3529: migrate(l_dsfv_rec, l_dsf_rec);
3530: --------------------------------------------
3531: -- Call the DELETE_ROW for each child record
3532: --------------------------------------------

Line 3538: l_okl_data_src_fnctns_tl_rec

3534: p_init_msg_list,
3535: x_return_status,
3536: x_msg_count,
3537: x_msg_data,
3538: l_okl_data_src_fnctns_tl_rec
3539: );
3540: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3541: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3542: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 3689: FROM OKL_DATA_SRC_FNCTNS_TL

3685: f_ludate := nvl(to_date(p_last_update_date, 'YYYY/MM/DD'), sysdate);
3686:
3687: SELECT LAST_UPDATED_BY, LAST_UPDATE_DATE
3688: INTO db_luby, db_ludate
3689: FROM OKL_DATA_SRC_FNCTNS_TL
3690: where ID = to_number(p_dsfv_rec.id)
3691: and USERENV('LANG') =language;
3692:
3693: IF(fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 3695: UPDATE OKL_DATA_SRC_FNCTNS_TL

3691: and USERENV('LANG') =language;
3692:
3693: IF(fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
3694: db_ludate, '')) then
3695: UPDATE OKL_DATA_SRC_FNCTNS_TL
3696: SET DESCRIPTION = p_dsfv_rec.DESCRIPTION,
3697: LAST_UPDATE_DATE = f_ludate,
3698: LAST_UPDATED_BY = f_luby,
3699: LAST_UPDATE_LOGIN = 0,

Line 3766: UPDATE OKL_DATA_SRC_FNCTNS_TL

3762: LAST_UPDATED_BY = f_luby,
3763: LAST_UPDATE_LOGIN = 0
3764: WHERE ID = to_number(p_dsfv_rec.id);
3765: --Update _TL
3766: UPDATE OKL_DATA_SRC_FNCTNS_TL
3767: SET DESCRIPTION = p_dsfv_rec.DESCRIPTION,
3768: LAST_UPDATE_DATE = f_ludate,
3769: LAST_UPDATED_BY = f_luby,
3770: LAST_UPDATE_LOGIN = 0,

Line 3776: INSERT INTO OKL_DATA_SRC_FNCTNS_TL

3772: WHERE ID = to_number(p_dsfv_rec.id)
3773: AND USERENV('LANG') IN (language,source_lang);
3774:
3775: IF(sql%notfound) THEN
3776: INSERT INTO OKL_DATA_SRC_FNCTNS_TL
3777: (
3778: ID,
3779: LANGUAGE,
3780: SOURCE_LANG,

Line 3803: FROM OKL_DATA_SRC_FNCTNS_TL TL

3799: FROM FND_LANGUAGES L
3800: WHERE L.INSTALLED_FLAG IN ('I','B')
3801: AND NOT EXISTS
3802: (SELECT NULL
3803: FROM OKL_DATA_SRC_FNCTNS_TL TL
3804: WHERE TL.ID = TO_NUMBER(p_dsfv_rec.id)
3805: AND TL.LANGUAGE = L.LANGUAGE_CODE);
3806: END IF;
3807:

Line 3884: INSERT INTO OKL_DATA_SRC_FNCTNS_TL

3880: from OKL_DATA_SRC_FNCTNS_B
3881: where (ID = TO_NUMBER(p_dsfv_rec.id) OR
3882: (NAME = p_dsfv_rec.name AND VERSION = p_dsfv_rec.version)));
3883:
3884: INSERT INTO OKL_DATA_SRC_FNCTNS_TL
3885: (
3886: ID,
3887: LANGUAGE,
3888: SOURCE_LANG,

Line 3911: FROM OKL_DATA_SRC_FNCTNS_TL TL

3907: FROM FND_LANGUAGES L
3908: WHERE L.INSTALLED_FLAG IN ('I','B')
3909: AND NOT EXISTS
3910: (SELECT NULL
3911: FROM OKL_DATA_SRC_FNCTNS_TL TL
3912: WHERE TL.ID = TO_NUMBER(p_dsfv_rec.id)
3913: AND TL.LANGUAGE = L.LANGUAGE_CODE);
3914: END LOAD_ROW;
3915: