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_STY_PVT dependencies on OKL_STRM_TYPE_TL

Line 41: DELETE FROM OKL_STRM_TYPE_TL T

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

Line 48: UPDATE OKL_STRM_TYPE_TL T SET (

44: FROM OKL_STRM_TYPE_B B --fixed bug 3321017 by kmotepal
45: WHERE B.ID = T.ID
46: );
47:
48: UPDATE OKL_STRM_TYPE_TL T SET (
49: NAME,
50: DESCRIPTION) = (SELECT
51: B.NAME,
52: B.DESCRIPTION

Line 53: FROM OKL_STRM_TYPE_TL B

49: NAME,
50: DESCRIPTION) = (SELECT
51: B.NAME,
52: B.DESCRIPTION
53: FROM OKL_STRM_TYPE_TL B
54: WHERE B.ID = T.ID
55: AND B.LANGUAGE = T.SOURCE_LANG)
56: WHERE (
57: T.ID,

Line 62: FROM OKL_STRM_TYPE_TL SUBB, OKL_STRM_TYPE_TL SUBT

58: T.LANGUAGE)
59: IN (SELECT
60: SUBT.ID,
61: SUBT.LANGUAGE
62: FROM OKL_STRM_TYPE_TL SUBB, OKL_STRM_TYPE_TL SUBT
63: WHERE SUBB.ID = SUBT.ID
64: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
65: AND (SUBB.NAME <> SUBT.NAME
66: OR SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 71: INSERT INTO OKL_STRM_TYPE_TL (

67: OR (SUBB.DESCRIPTION IS NULL AND SUBT.DESCRIPTION IS NOT NULL)
68: OR (SUBB.DESCRIPTION IS NOT NULL AND SUBT.DESCRIPTION IS NULL)
69: ));
70:
71: INSERT INTO OKL_STRM_TYPE_TL (
72: ID,
73: LANGUAGE,
74: SOURCE_LANG,
75: SFWT_FLAG,

Line 102: FROM OKL_STRM_TYPE_TL B, FND_LANGUAGES L

98: B.LAST_UPDATE_LOGIN,
99: -- Added by RGOOTY for ER 3935682: Start
100: B.SHORT_DESCRIPTION
101: -- Added by RGOOTY for ER 3935682: End
102: FROM OKL_STRM_TYPE_TL B, FND_LANGUAGES L
103: WHERE L.INSTALLED_FLAG IN ('I', 'B')
104: AND B.LANGUAGE = USERENV('LANG')
105: AND NOT EXISTS(
106: SELECT NULL

Line 107: FROM OKL_STRM_TYPE_TL T

103: WHERE L.INSTALLED_FLAG IN ('I', 'B')
104: AND B.LANGUAGE = USERENV('LANG')
105: AND NOT EXISTS(
106: SELECT NULL
107: FROM OKL_STRM_TYPE_TL T
108: WHERE T.ID = B.ID
109: AND T.LANGUAGE = L.LANGUAGE_CODE
110: );
111:

Line 240: -- FUNCTION get_rec for: OKL_STRM_TYPE_TL

236: BEGIN
237: RETURN(get_rec(p_sty_rec, l_row_notfound));
238: END get_rec;
239: ---------------------------------------------------------------------------
240: -- FUNCTION get_rec for: OKL_STRM_TYPE_TL
241: ---------------------------------------------------------------------------
242: FUNCTION get_rec (
243: p_okl_strm_type_tl_rec IN okl_strm_type_tl_rec_type,
244: x_no_data_found OUT NOCOPY BOOLEAN

Line 243: p_okl_strm_type_tl_rec IN okl_strm_type_tl_rec_type,

239: ---------------------------------------------------------------------------
240: -- FUNCTION get_rec for: OKL_STRM_TYPE_TL
241: ---------------------------------------------------------------------------
242: FUNCTION get_rec (
243: p_okl_strm_type_tl_rec IN okl_strm_type_tl_rec_type,
244: x_no_data_found OUT NOCOPY BOOLEAN
245: ) RETURN okl_strm_type_tl_rec_type IS
246: CURSOR okl_strm_type_tl_pk_csr (p_id IN NUMBER,
247: p_language IN VARCHAR2) IS

Line 245: ) RETURN okl_strm_type_tl_rec_type IS

241: ---------------------------------------------------------------------------
242: FUNCTION get_rec (
243: p_okl_strm_type_tl_rec IN okl_strm_type_tl_rec_type,
244: x_no_data_found OUT NOCOPY BOOLEAN
245: ) RETURN okl_strm_type_tl_rec_type IS
246: CURSOR okl_strm_type_tl_pk_csr (p_id IN NUMBER,
247: p_language IN VARCHAR2) IS
248: SELECT
249: ID,

Line 246: CURSOR okl_strm_type_tl_pk_csr (p_id IN NUMBER,

242: FUNCTION get_rec (
243: p_okl_strm_type_tl_rec IN okl_strm_type_tl_rec_type,
244: x_no_data_found OUT NOCOPY BOOLEAN
245: ) RETURN okl_strm_type_tl_rec_type IS
246: CURSOR okl_strm_type_tl_pk_csr (p_id IN NUMBER,
247: p_language IN VARCHAR2) IS
248: SELECT
249: ID,
250: LANGUAGE,

Line 263: FROM Okl_Strm_Type_Tl

259: LAST_UPDATE_LOGIN,
260: -- Added by RGOOTY for ER 3935682: Start
261: SHORT_DESCRIPTION
262: -- Added by RGOOTY for ER 3935682: Start
263: FROM Okl_Strm_Type_Tl
264: WHERE okl_strm_type_tl.id = p_id
265: AND okl_strm_type_tl.language = p_language;
266: l_okl_strm_type_tl_pk okl_strm_type_tl_pk_csr%ROWTYPE;
267: l_okl_strm_type_tl_rec okl_strm_type_tl_rec_type;

Line 264: WHERE okl_strm_type_tl.id = p_id

260: -- Added by RGOOTY for ER 3935682: Start
261: SHORT_DESCRIPTION
262: -- Added by RGOOTY for ER 3935682: Start
263: FROM Okl_Strm_Type_Tl
264: WHERE okl_strm_type_tl.id = p_id
265: AND okl_strm_type_tl.language = p_language;
266: l_okl_strm_type_tl_pk okl_strm_type_tl_pk_csr%ROWTYPE;
267: l_okl_strm_type_tl_rec okl_strm_type_tl_rec_type;
268: BEGIN

Line 265: AND okl_strm_type_tl.language = p_language;

261: SHORT_DESCRIPTION
262: -- Added by RGOOTY for ER 3935682: Start
263: FROM Okl_Strm_Type_Tl
264: WHERE okl_strm_type_tl.id = p_id
265: AND okl_strm_type_tl.language = p_language;
266: l_okl_strm_type_tl_pk okl_strm_type_tl_pk_csr%ROWTYPE;
267: l_okl_strm_type_tl_rec okl_strm_type_tl_rec_type;
268: BEGIN
269: x_no_data_found := TRUE;

Line 266: l_okl_strm_type_tl_pk okl_strm_type_tl_pk_csr%ROWTYPE;

262: -- Added by RGOOTY for ER 3935682: Start
263: FROM Okl_Strm_Type_Tl
264: WHERE okl_strm_type_tl.id = p_id
265: AND okl_strm_type_tl.language = p_language;
266: l_okl_strm_type_tl_pk okl_strm_type_tl_pk_csr%ROWTYPE;
267: l_okl_strm_type_tl_rec okl_strm_type_tl_rec_type;
268: BEGIN
269: x_no_data_found := TRUE;
270: -- Get current database values

Line 267: l_okl_strm_type_tl_rec okl_strm_type_tl_rec_type;

263: FROM Okl_Strm_Type_Tl
264: WHERE okl_strm_type_tl.id = p_id
265: AND okl_strm_type_tl.language = p_language;
266: l_okl_strm_type_tl_pk okl_strm_type_tl_pk_csr%ROWTYPE;
267: l_okl_strm_type_tl_rec okl_strm_type_tl_rec_type;
268: BEGIN
269: x_no_data_found := TRUE;
270: -- Get current database values
271: OPEN okl_strm_type_tl_pk_csr (p_okl_strm_type_tl_rec.id,

Line 271: OPEN okl_strm_type_tl_pk_csr (p_okl_strm_type_tl_rec.id,

267: l_okl_strm_type_tl_rec okl_strm_type_tl_rec_type;
268: BEGIN
269: x_no_data_found := TRUE;
270: -- Get current database values
271: OPEN okl_strm_type_tl_pk_csr (p_okl_strm_type_tl_rec.id,
272: p_okl_strm_type_tl_rec.language);
273: FETCH okl_strm_type_tl_pk_csr INTO
274: l_okl_strm_type_tl_rec.ID,
275: l_okl_strm_type_tl_rec.LANGUAGE,

Line 272: p_okl_strm_type_tl_rec.language);

268: BEGIN
269: x_no_data_found := TRUE;
270: -- Get current database values
271: OPEN okl_strm_type_tl_pk_csr (p_okl_strm_type_tl_rec.id,
272: p_okl_strm_type_tl_rec.language);
273: FETCH okl_strm_type_tl_pk_csr INTO
274: l_okl_strm_type_tl_rec.ID,
275: l_okl_strm_type_tl_rec.LANGUAGE,
276: l_okl_strm_type_tl_rec.SOURCE_LANG,

Line 273: FETCH okl_strm_type_tl_pk_csr INTO

269: x_no_data_found := TRUE;
270: -- Get current database values
271: OPEN okl_strm_type_tl_pk_csr (p_okl_strm_type_tl_rec.id,
272: p_okl_strm_type_tl_rec.language);
273: FETCH okl_strm_type_tl_pk_csr INTO
274: l_okl_strm_type_tl_rec.ID,
275: l_okl_strm_type_tl_rec.LANGUAGE,
276: l_okl_strm_type_tl_rec.SOURCE_LANG,
277: l_okl_strm_type_tl_rec.SFWT_FLAG,

Line 274: l_okl_strm_type_tl_rec.ID,

270: -- Get current database values
271: OPEN okl_strm_type_tl_pk_csr (p_okl_strm_type_tl_rec.id,
272: p_okl_strm_type_tl_rec.language);
273: FETCH okl_strm_type_tl_pk_csr INTO
274: l_okl_strm_type_tl_rec.ID,
275: l_okl_strm_type_tl_rec.LANGUAGE,
276: l_okl_strm_type_tl_rec.SOURCE_LANG,
277: l_okl_strm_type_tl_rec.SFWT_FLAG,
278: l_okl_strm_type_tl_rec.NAME,

Line 275: l_okl_strm_type_tl_rec.LANGUAGE,

271: OPEN okl_strm_type_tl_pk_csr (p_okl_strm_type_tl_rec.id,
272: p_okl_strm_type_tl_rec.language);
273: FETCH okl_strm_type_tl_pk_csr INTO
274: l_okl_strm_type_tl_rec.ID,
275: l_okl_strm_type_tl_rec.LANGUAGE,
276: l_okl_strm_type_tl_rec.SOURCE_LANG,
277: l_okl_strm_type_tl_rec.SFWT_FLAG,
278: l_okl_strm_type_tl_rec.NAME,
279: l_okl_strm_type_tl_rec.DESCRIPTION,

Line 276: l_okl_strm_type_tl_rec.SOURCE_LANG,

272: p_okl_strm_type_tl_rec.language);
273: FETCH okl_strm_type_tl_pk_csr INTO
274: l_okl_strm_type_tl_rec.ID,
275: l_okl_strm_type_tl_rec.LANGUAGE,
276: l_okl_strm_type_tl_rec.SOURCE_LANG,
277: l_okl_strm_type_tl_rec.SFWT_FLAG,
278: l_okl_strm_type_tl_rec.NAME,
279: l_okl_strm_type_tl_rec.DESCRIPTION,
280: l_okl_strm_type_tl_rec.CREATED_BY,

Line 277: l_okl_strm_type_tl_rec.SFWT_FLAG,

273: FETCH okl_strm_type_tl_pk_csr INTO
274: l_okl_strm_type_tl_rec.ID,
275: l_okl_strm_type_tl_rec.LANGUAGE,
276: l_okl_strm_type_tl_rec.SOURCE_LANG,
277: l_okl_strm_type_tl_rec.SFWT_FLAG,
278: l_okl_strm_type_tl_rec.NAME,
279: l_okl_strm_type_tl_rec.DESCRIPTION,
280: l_okl_strm_type_tl_rec.CREATED_BY,
281: l_okl_strm_type_tl_rec.CREATION_DATE,

Line 278: l_okl_strm_type_tl_rec.NAME,

274: l_okl_strm_type_tl_rec.ID,
275: l_okl_strm_type_tl_rec.LANGUAGE,
276: l_okl_strm_type_tl_rec.SOURCE_LANG,
277: l_okl_strm_type_tl_rec.SFWT_FLAG,
278: l_okl_strm_type_tl_rec.NAME,
279: l_okl_strm_type_tl_rec.DESCRIPTION,
280: l_okl_strm_type_tl_rec.CREATED_BY,
281: l_okl_strm_type_tl_rec.CREATION_DATE,
282: l_okl_strm_type_tl_rec.LAST_UPDATED_BY,

Line 279: l_okl_strm_type_tl_rec.DESCRIPTION,

275: l_okl_strm_type_tl_rec.LANGUAGE,
276: l_okl_strm_type_tl_rec.SOURCE_LANG,
277: l_okl_strm_type_tl_rec.SFWT_FLAG,
278: l_okl_strm_type_tl_rec.NAME,
279: l_okl_strm_type_tl_rec.DESCRIPTION,
280: l_okl_strm_type_tl_rec.CREATED_BY,
281: l_okl_strm_type_tl_rec.CREATION_DATE,
282: l_okl_strm_type_tl_rec.LAST_UPDATED_BY,
283: l_okl_strm_type_tl_rec.LAST_UPDATE_DATE,

Line 280: l_okl_strm_type_tl_rec.CREATED_BY,

276: l_okl_strm_type_tl_rec.SOURCE_LANG,
277: l_okl_strm_type_tl_rec.SFWT_FLAG,
278: l_okl_strm_type_tl_rec.NAME,
279: l_okl_strm_type_tl_rec.DESCRIPTION,
280: l_okl_strm_type_tl_rec.CREATED_BY,
281: l_okl_strm_type_tl_rec.CREATION_DATE,
282: l_okl_strm_type_tl_rec.LAST_UPDATED_BY,
283: l_okl_strm_type_tl_rec.LAST_UPDATE_DATE,
284: l_okl_strm_type_tl_rec.LAST_UPDATE_LOGIN,

Line 281: l_okl_strm_type_tl_rec.CREATION_DATE,

277: l_okl_strm_type_tl_rec.SFWT_FLAG,
278: l_okl_strm_type_tl_rec.NAME,
279: l_okl_strm_type_tl_rec.DESCRIPTION,
280: l_okl_strm_type_tl_rec.CREATED_BY,
281: l_okl_strm_type_tl_rec.CREATION_DATE,
282: l_okl_strm_type_tl_rec.LAST_UPDATED_BY,
283: l_okl_strm_type_tl_rec.LAST_UPDATE_DATE,
284: l_okl_strm_type_tl_rec.LAST_UPDATE_LOGIN,
285: -- Added by RGOOTY for ER 3935682: Start

Line 282: l_okl_strm_type_tl_rec.LAST_UPDATED_BY,

278: l_okl_strm_type_tl_rec.NAME,
279: l_okl_strm_type_tl_rec.DESCRIPTION,
280: l_okl_strm_type_tl_rec.CREATED_BY,
281: l_okl_strm_type_tl_rec.CREATION_DATE,
282: l_okl_strm_type_tl_rec.LAST_UPDATED_BY,
283: l_okl_strm_type_tl_rec.LAST_UPDATE_DATE,
284: l_okl_strm_type_tl_rec.LAST_UPDATE_LOGIN,
285: -- Added by RGOOTY for ER 3935682: Start
286: l_okl_strm_type_tl_rec.SHORT_DESCRIPTION;

Line 283: l_okl_strm_type_tl_rec.LAST_UPDATE_DATE,

279: l_okl_strm_type_tl_rec.DESCRIPTION,
280: l_okl_strm_type_tl_rec.CREATED_BY,
281: l_okl_strm_type_tl_rec.CREATION_DATE,
282: l_okl_strm_type_tl_rec.LAST_UPDATED_BY,
283: l_okl_strm_type_tl_rec.LAST_UPDATE_DATE,
284: l_okl_strm_type_tl_rec.LAST_UPDATE_LOGIN,
285: -- Added by RGOOTY for ER 3935682: Start
286: l_okl_strm_type_tl_rec.SHORT_DESCRIPTION;
287: -- Added by RGOOTY for ER 3935682: End

Line 284: l_okl_strm_type_tl_rec.LAST_UPDATE_LOGIN,

280: l_okl_strm_type_tl_rec.CREATED_BY,
281: l_okl_strm_type_tl_rec.CREATION_DATE,
282: l_okl_strm_type_tl_rec.LAST_UPDATED_BY,
283: l_okl_strm_type_tl_rec.LAST_UPDATE_DATE,
284: l_okl_strm_type_tl_rec.LAST_UPDATE_LOGIN,
285: -- Added by RGOOTY for ER 3935682: Start
286: l_okl_strm_type_tl_rec.SHORT_DESCRIPTION;
287: -- Added by RGOOTY for ER 3935682: End
288: x_no_data_found := okl_strm_type_tl_pk_csr%NOTFOUND;

Line 286: l_okl_strm_type_tl_rec.SHORT_DESCRIPTION;

282: l_okl_strm_type_tl_rec.LAST_UPDATED_BY,
283: l_okl_strm_type_tl_rec.LAST_UPDATE_DATE,
284: l_okl_strm_type_tl_rec.LAST_UPDATE_LOGIN,
285: -- Added by RGOOTY for ER 3935682: Start
286: l_okl_strm_type_tl_rec.SHORT_DESCRIPTION;
287: -- Added by RGOOTY for ER 3935682: End
288: x_no_data_found := okl_strm_type_tl_pk_csr%NOTFOUND;
289: CLOSE okl_strm_type_tl_pk_csr;
290: RETURN(l_okl_strm_type_tl_rec);

Line 288: x_no_data_found := okl_strm_type_tl_pk_csr%NOTFOUND;

284: l_okl_strm_type_tl_rec.LAST_UPDATE_LOGIN,
285: -- Added by RGOOTY for ER 3935682: Start
286: l_okl_strm_type_tl_rec.SHORT_DESCRIPTION;
287: -- Added by RGOOTY for ER 3935682: End
288: x_no_data_found := okl_strm_type_tl_pk_csr%NOTFOUND;
289: CLOSE okl_strm_type_tl_pk_csr;
290: RETURN(l_okl_strm_type_tl_rec);
291: END get_rec;
292:

Line 289: CLOSE okl_strm_type_tl_pk_csr;

285: -- Added by RGOOTY for ER 3935682: Start
286: l_okl_strm_type_tl_rec.SHORT_DESCRIPTION;
287: -- Added by RGOOTY for ER 3935682: End
288: x_no_data_found := okl_strm_type_tl_pk_csr%NOTFOUND;
289: CLOSE okl_strm_type_tl_pk_csr;
290: RETURN(l_okl_strm_type_tl_rec);
291: END get_rec;
292:
293: FUNCTION get_rec (

Line 290: RETURN(l_okl_strm_type_tl_rec);

286: l_okl_strm_type_tl_rec.SHORT_DESCRIPTION;
287: -- Added by RGOOTY for ER 3935682: End
288: x_no_data_found := okl_strm_type_tl_pk_csr%NOTFOUND;
289: CLOSE okl_strm_type_tl_pk_csr;
290: RETURN(l_okl_strm_type_tl_rec);
291: END get_rec;
292:
293: FUNCTION get_rec (
294: p_okl_strm_type_tl_rec IN okl_strm_type_tl_rec_type

Line 294: p_okl_strm_type_tl_rec IN okl_strm_type_tl_rec_type

290: RETURN(l_okl_strm_type_tl_rec);
291: END get_rec;
292:
293: FUNCTION get_rec (
294: p_okl_strm_type_tl_rec IN okl_strm_type_tl_rec_type
295: ) RETURN okl_strm_type_tl_rec_type IS
296: l_row_notfound BOOLEAN := TRUE;
297: BEGIN
298: RETURN(get_rec(p_okl_strm_type_tl_rec, l_row_notfound));

Line 295: ) RETURN okl_strm_type_tl_rec_type IS

291: END get_rec;
292:
293: FUNCTION get_rec (
294: p_okl_strm_type_tl_rec IN okl_strm_type_tl_rec_type
295: ) RETURN okl_strm_type_tl_rec_type IS
296: l_row_notfound BOOLEAN := TRUE;
297: BEGIN
298: RETURN(get_rec(p_okl_strm_type_tl_rec, l_row_notfound));
299: END get_rec;

Line 298: RETURN(get_rec(p_okl_strm_type_tl_rec, l_row_notfound));

294: p_okl_strm_type_tl_rec IN okl_strm_type_tl_rec_type
295: ) RETURN okl_strm_type_tl_rec_type IS
296: l_row_notfound BOOLEAN := TRUE;
297: BEGIN
298: RETURN(get_rec(p_okl_strm_type_tl_rec, l_row_notfound));
299: END get_rec;
300: ---------------------------------------------------------------------------
301: -- FUNCTION get_rec for: OKL_STRM_TYPE_V
302: ---------------------------------------------------------------------------

Line 2255: p_to IN OUT NOCOPY okl_strm_type_tl_rec_type

2251:
2252: END migrate;
2253: PROCEDURE migrate (
2254: p_from IN styv_rec_type,
2255: p_to IN OUT NOCOPY okl_strm_type_tl_rec_type
2256: ) IS
2257: BEGIN
2258: p_to.id := p_from.id;
2259: p_to.sfwt_flag := p_from.sfwt_flag;

Line 2272: p_from IN okl_strm_type_tl_rec_type,

2268: p_to.short_description := p_from.short_description;
2269: -- Added by RGOOTY for ER 3935682: End
2270: END migrate;
2271: PROCEDURE migrate (
2272: p_from IN okl_strm_type_tl_rec_type,
2273: p_to IN OUT NOCOPY styv_rec_type
2274: ) IS
2275: BEGIN
2276: p_to.id := p_from.id;

Line 2309: l_okl_strm_type_tl_rec okl_strm_type_tl_rec_type;

2305: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
2306: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2307: l_styv_rec styv_rec_type := p_styv_rec;
2308: l_sty_rec sty_rec_type;
2309: l_okl_strm_type_tl_rec okl_strm_type_tl_rec_type;
2310: BEGIN
2311: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2312: G_PKG_NAME,
2313: p_init_msg_list,

Line 2640: -- insert_row for:OKL_STRM_TYPE_TL --

2636: '_PVT'
2637: );
2638: END insert_row;
2639: -------------------------------------
2640: -- insert_row for:OKL_STRM_TYPE_TL --
2641: -------------------------------------
2642: PROCEDURE insert_row(
2643: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2644: x_return_status OUT NOCOPY VARCHAR2,

Line 2647: p_okl_strm_type_tl_rec IN okl_strm_type_tl_rec_type,

2643: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2644: x_return_status OUT NOCOPY VARCHAR2,
2645: x_msg_count OUT NOCOPY NUMBER,
2646: x_msg_data OUT NOCOPY VARCHAR2,
2647: p_okl_strm_type_tl_rec IN okl_strm_type_tl_rec_type,
2648: x_okl_strm_type_tl_rec OUT NOCOPY okl_strm_type_tl_rec_type) IS
2649:
2650: l_api_version CONSTANT NUMBER := 1;
2651: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';

Line 2648: x_okl_strm_type_tl_rec OUT NOCOPY okl_strm_type_tl_rec_type) IS

2644: x_return_status OUT NOCOPY VARCHAR2,
2645: x_msg_count OUT NOCOPY NUMBER,
2646: x_msg_data OUT NOCOPY VARCHAR2,
2647: p_okl_strm_type_tl_rec IN okl_strm_type_tl_rec_type,
2648: x_okl_strm_type_tl_rec OUT NOCOPY okl_strm_type_tl_rec_type) IS
2649:
2650: l_api_version CONSTANT NUMBER := 1;
2651: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
2652: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2653: l_okl_strm_type_tl_rec okl_strm_type_tl_rec_type := p_okl_strm_type_tl_rec;

2649:
2650: l_api_version CONSTANT NUMBER := 1;
2651: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
2652: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2653: l_okl_strm_type_tl_rec okl_strm_type_tl_rec_type := p_okl_strm_type_tl_rec;
2654: l_def_okl_strm_type_tl_rec okl_strm_type_tl_rec_type;
2655: CURSOR get_languages IS
2656: SELECT *
2657: FROM FND_LANGUAGES

Line 2654: l_def_okl_strm_type_tl_rec okl_strm_type_tl_rec_type;

2650: l_api_version CONSTANT NUMBER := 1;
2651: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
2652: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2653: l_okl_strm_type_tl_rec okl_strm_type_tl_rec_type := p_okl_strm_type_tl_rec;
2654: l_def_okl_strm_type_tl_rec okl_strm_type_tl_rec_type;
2655: CURSOR get_languages IS
2656: SELECT *
2657: FROM FND_LANGUAGES
2658: WHERE INSTALLED_FLAG IN ('I', 'B');

Line 2660: -- Set_Attributes for:OKL_STRM_TYPE_TL --

2656: SELECT *
2657: FROM FND_LANGUAGES
2658: WHERE INSTALLED_FLAG IN ('I', 'B');
2659: -----------------------------------------
2660: -- Set_Attributes for:OKL_STRM_TYPE_TL --
2661: -----------------------------------------
2662: FUNCTION Set_Attributes (
2663: p_okl_strm_type_tl_rec IN okl_strm_type_tl_rec_type,
2664: x_okl_strm_type_tl_rec OUT NOCOPY okl_strm_type_tl_rec_type

Line 2663: p_okl_strm_type_tl_rec IN okl_strm_type_tl_rec_type,

2659: -----------------------------------------
2660: -- Set_Attributes for:OKL_STRM_TYPE_TL --
2661: -----------------------------------------
2662: FUNCTION Set_Attributes (
2663: p_okl_strm_type_tl_rec IN okl_strm_type_tl_rec_type,
2664: x_okl_strm_type_tl_rec OUT NOCOPY okl_strm_type_tl_rec_type
2665: ) RETURN VARCHAR2 IS
2666: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2667: BEGIN

Line 2664: x_okl_strm_type_tl_rec OUT NOCOPY okl_strm_type_tl_rec_type

2660: -- Set_Attributes for:OKL_STRM_TYPE_TL --
2661: -----------------------------------------
2662: FUNCTION Set_Attributes (
2663: p_okl_strm_type_tl_rec IN okl_strm_type_tl_rec_type,
2664: x_okl_strm_type_tl_rec OUT NOCOPY okl_strm_type_tl_rec_type
2665: ) RETURN VARCHAR2 IS
2666: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2667: BEGIN
2668: x_okl_strm_type_tl_rec := p_okl_strm_type_tl_rec;

Line 2668: x_okl_strm_type_tl_rec := p_okl_strm_type_tl_rec;

2664: x_okl_strm_type_tl_rec OUT NOCOPY okl_strm_type_tl_rec_type
2665: ) RETURN VARCHAR2 IS
2666: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2667: BEGIN
2668: x_okl_strm_type_tl_rec := p_okl_strm_type_tl_rec;
2669: x_okl_strm_type_tl_rec.LANGUAGE := USERENV('LANG');
2670: x_okl_strm_type_tl_rec.SOURCE_LANG := USERENV('LANG');
2671: RETURN(l_return_status);
2672: END Set_Attributes;

Line 2669: x_okl_strm_type_tl_rec.LANGUAGE := USERENV('LANG');

2665: ) RETURN VARCHAR2 IS
2666: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2667: BEGIN
2668: x_okl_strm_type_tl_rec := p_okl_strm_type_tl_rec;
2669: x_okl_strm_type_tl_rec.LANGUAGE := USERENV('LANG');
2670: x_okl_strm_type_tl_rec.SOURCE_LANG := USERENV('LANG');
2671: RETURN(l_return_status);
2672: END Set_Attributes;
2673: BEGIN

Line 2670: x_okl_strm_type_tl_rec.SOURCE_LANG := USERENV('LANG');

2666: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2667: BEGIN
2668: x_okl_strm_type_tl_rec := p_okl_strm_type_tl_rec;
2669: x_okl_strm_type_tl_rec.LANGUAGE := USERENV('LANG');
2670: x_okl_strm_type_tl_rec.SOURCE_LANG := USERENV('LANG');
2671: RETURN(l_return_status);
2672: END Set_Attributes;
2673: BEGIN
2674: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2685: p_okl_strm_type_tl_rec, -- IN

2681: RAISE OKC_API.G_EXCEPTION_ERROR;
2682: END IF;
2683: --- Setting item attributes
2684: l_return_status := Set_Attributes(
2685: p_okl_strm_type_tl_rec, -- IN
2686: l_okl_strm_type_tl_rec); -- OUT
2687: --- If any errors happen abort API
2688: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2689: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2686: l_okl_strm_type_tl_rec); -- OUT

2682: END IF;
2683: --- Setting item attributes
2684: l_return_status := Set_Attributes(
2685: p_okl_strm_type_tl_rec, -- IN
2686: l_okl_strm_type_tl_rec); -- OUT
2687: --- If any errors happen abort API
2688: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2689: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2690: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2694: l_okl_strm_type_tl_rec.language := l_lang_rec.language_code;

2690: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2691: RAISE OKC_API.G_EXCEPTION_ERROR;
2692: END IF;
2693: FOR l_lang_rec IN get_languages LOOP
2694: l_okl_strm_type_tl_rec.language := l_lang_rec.language_code;
2695: INSERT INTO OKL_STRM_TYPE_TL(
2696: id,
2697: language,
2698: source_lang,

Line 2695: INSERT INTO OKL_STRM_TYPE_TL(

2691: RAISE OKC_API.G_EXCEPTION_ERROR;
2692: END IF;
2693: FOR l_lang_rec IN get_languages LOOP
2694: l_okl_strm_type_tl_rec.language := l_lang_rec.language_code;
2695: INSERT INTO OKL_STRM_TYPE_TL(
2696: id,
2697: language,
2698: source_lang,
2699: sfwt_flag,

Line 2712: l_okl_strm_type_tl_rec.id,

2708: short_description
2709: -- Added by RGOOTY for ER 3935682: End
2710: )
2711: VALUES (
2712: l_okl_strm_type_tl_rec.id,
2713: l_okl_strm_type_tl_rec.language,
2714: l_okl_strm_type_tl_rec.source_lang,
2715: l_okl_strm_type_tl_rec.sfwt_flag,
2716: l_okl_strm_type_tl_rec.name,

Line 2713: l_okl_strm_type_tl_rec.language,

2709: -- Added by RGOOTY for ER 3935682: End
2710: )
2711: VALUES (
2712: l_okl_strm_type_tl_rec.id,
2713: l_okl_strm_type_tl_rec.language,
2714: l_okl_strm_type_tl_rec.source_lang,
2715: l_okl_strm_type_tl_rec.sfwt_flag,
2716: l_okl_strm_type_tl_rec.name,
2717: l_okl_strm_type_tl_rec.description,

Line 2714: l_okl_strm_type_tl_rec.source_lang,

2710: )
2711: VALUES (
2712: l_okl_strm_type_tl_rec.id,
2713: l_okl_strm_type_tl_rec.language,
2714: l_okl_strm_type_tl_rec.source_lang,
2715: l_okl_strm_type_tl_rec.sfwt_flag,
2716: l_okl_strm_type_tl_rec.name,
2717: l_okl_strm_type_tl_rec.description,
2718: l_okl_strm_type_tl_rec.created_by,

Line 2715: l_okl_strm_type_tl_rec.sfwt_flag,

2711: VALUES (
2712: l_okl_strm_type_tl_rec.id,
2713: l_okl_strm_type_tl_rec.language,
2714: l_okl_strm_type_tl_rec.source_lang,
2715: l_okl_strm_type_tl_rec.sfwt_flag,
2716: l_okl_strm_type_tl_rec.name,
2717: l_okl_strm_type_tl_rec.description,
2718: l_okl_strm_type_tl_rec.created_by,
2719: l_okl_strm_type_tl_rec.creation_date,

Line 2716: l_okl_strm_type_tl_rec.name,

2712: l_okl_strm_type_tl_rec.id,
2713: l_okl_strm_type_tl_rec.language,
2714: l_okl_strm_type_tl_rec.source_lang,
2715: l_okl_strm_type_tl_rec.sfwt_flag,
2716: l_okl_strm_type_tl_rec.name,
2717: l_okl_strm_type_tl_rec.description,
2718: l_okl_strm_type_tl_rec.created_by,
2719: l_okl_strm_type_tl_rec.creation_date,
2720: l_okl_strm_type_tl_rec.last_updated_by,

Line 2717: l_okl_strm_type_tl_rec.description,

2713: l_okl_strm_type_tl_rec.language,
2714: l_okl_strm_type_tl_rec.source_lang,
2715: l_okl_strm_type_tl_rec.sfwt_flag,
2716: l_okl_strm_type_tl_rec.name,
2717: l_okl_strm_type_tl_rec.description,
2718: l_okl_strm_type_tl_rec.created_by,
2719: l_okl_strm_type_tl_rec.creation_date,
2720: l_okl_strm_type_tl_rec.last_updated_by,
2721: l_okl_strm_type_tl_rec.last_update_date,

Line 2718: l_okl_strm_type_tl_rec.created_by,

2714: l_okl_strm_type_tl_rec.source_lang,
2715: l_okl_strm_type_tl_rec.sfwt_flag,
2716: l_okl_strm_type_tl_rec.name,
2717: l_okl_strm_type_tl_rec.description,
2718: l_okl_strm_type_tl_rec.created_by,
2719: l_okl_strm_type_tl_rec.creation_date,
2720: l_okl_strm_type_tl_rec.last_updated_by,
2721: l_okl_strm_type_tl_rec.last_update_date,
2722: l_okl_strm_type_tl_rec.last_update_login,

Line 2719: l_okl_strm_type_tl_rec.creation_date,

2715: l_okl_strm_type_tl_rec.sfwt_flag,
2716: l_okl_strm_type_tl_rec.name,
2717: l_okl_strm_type_tl_rec.description,
2718: l_okl_strm_type_tl_rec.created_by,
2719: l_okl_strm_type_tl_rec.creation_date,
2720: l_okl_strm_type_tl_rec.last_updated_by,
2721: l_okl_strm_type_tl_rec.last_update_date,
2722: l_okl_strm_type_tl_rec.last_update_login,
2723: -- Added by RGOOTY for ER 3935682: Start

Line 2720: l_okl_strm_type_tl_rec.last_updated_by,

2716: l_okl_strm_type_tl_rec.name,
2717: l_okl_strm_type_tl_rec.description,
2718: l_okl_strm_type_tl_rec.created_by,
2719: l_okl_strm_type_tl_rec.creation_date,
2720: l_okl_strm_type_tl_rec.last_updated_by,
2721: l_okl_strm_type_tl_rec.last_update_date,
2722: l_okl_strm_type_tl_rec.last_update_login,
2723: -- Added by RGOOTY for ER 3935682: Start
2724: l_okl_strm_type_tl_rec.short_description

Line 2721: l_okl_strm_type_tl_rec.last_update_date,

2717: l_okl_strm_type_tl_rec.description,
2718: l_okl_strm_type_tl_rec.created_by,
2719: l_okl_strm_type_tl_rec.creation_date,
2720: l_okl_strm_type_tl_rec.last_updated_by,
2721: l_okl_strm_type_tl_rec.last_update_date,
2722: l_okl_strm_type_tl_rec.last_update_login,
2723: -- Added by RGOOTY for ER 3935682: Start
2724: l_okl_strm_type_tl_rec.short_description
2725: -- Added by RGOOTY for ER 3935682: End

Line 2722: l_okl_strm_type_tl_rec.last_update_login,

2718: l_okl_strm_type_tl_rec.created_by,
2719: l_okl_strm_type_tl_rec.creation_date,
2720: l_okl_strm_type_tl_rec.last_updated_by,
2721: l_okl_strm_type_tl_rec.last_update_date,
2722: l_okl_strm_type_tl_rec.last_update_login,
2723: -- Added by RGOOTY for ER 3935682: Start
2724: l_okl_strm_type_tl_rec.short_description
2725: -- Added by RGOOTY for ER 3935682: End
2726: );

Line 2724: l_okl_strm_type_tl_rec.short_description

2720: l_okl_strm_type_tl_rec.last_updated_by,
2721: l_okl_strm_type_tl_rec.last_update_date,
2722: l_okl_strm_type_tl_rec.last_update_login,
2723: -- Added by RGOOTY for ER 3935682: Start
2724: l_okl_strm_type_tl_rec.short_description
2725: -- Added by RGOOTY for ER 3935682: End
2726: );
2727: END LOOP;
2728: -- Set OUT values

Line 2729: x_okl_strm_type_tl_rec := l_okl_strm_type_tl_rec;

2725: -- Added by RGOOTY for ER 3935682: End
2726: );
2727: END LOOP;
2728: -- Set OUT values
2729: x_okl_strm_type_tl_rec := l_okl_strm_type_tl_rec;
2730: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2731: EXCEPTION
2732: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2733: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 2782: l_okl_strm_type_tl_rec okl_strm_type_tl_rec_type;

2778: l_styv_rec styv_rec_type;
2779: l_def_styv_rec styv_rec_type;
2780: l_sty_rec sty_rec_type;
2781: lx_sty_rec sty_rec_type;
2782: l_okl_strm_type_tl_rec okl_strm_type_tl_rec_type;
2783: lx_okl_strm_type_tl_rec okl_strm_type_tl_rec_type;
2784: -------------------------------
2785: -- FUNCTION fill_who_columns --
2786: -------------------------------

Line 2783: lx_okl_strm_type_tl_rec okl_strm_type_tl_rec_type;

2779: l_def_styv_rec styv_rec_type;
2780: l_sty_rec sty_rec_type;
2781: lx_sty_rec sty_rec_type;
2782: l_okl_strm_type_tl_rec okl_strm_type_tl_rec_type;
2783: lx_okl_strm_type_tl_rec okl_strm_type_tl_rec_type;
2784: -------------------------------
2785: -- FUNCTION fill_who_columns --
2786: -------------------------------
2787: FUNCTION fill_who_columns (

Line 2858: migrate(l_def_styv_rec, l_okl_strm_type_tl_rec);

2854: --------------------------------------
2855: -- Move VIEW record to "Child" records
2856: --------------------------------------
2857: migrate(l_def_styv_rec, l_sty_rec);
2858: migrate(l_def_styv_rec, l_okl_strm_type_tl_rec);
2859: --------------------------------------------
2860: -- Call the INSERT_ROW for each child record
2861: --------------------------------------------
2862: insert_row(

Line 2881: l_okl_strm_type_tl_rec,

2877: p_init_msg_list,
2878: x_return_status,
2879: x_msg_count,
2880: x_msg_data,
2881: l_okl_strm_type_tl_rec,
2882: lx_okl_strm_type_tl_rec
2883: );
2884: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2885: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2882: lx_okl_strm_type_tl_rec

2878: x_return_status,
2879: x_msg_count,
2880: x_msg_data,
2881: l_okl_strm_type_tl_rec,
2882: lx_okl_strm_type_tl_rec
2883: );
2884: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2885: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2886: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2889: migrate(lx_okl_strm_type_tl_rec, l_def_styv_rec);

2885: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2886: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2887: RAISE OKC_API.G_EXCEPTION_ERROR;
2888: END IF;
2889: migrate(lx_okl_strm_type_tl_rec, l_def_styv_rec);
2890: -- Set OUT values
2891: x_styv_rec := l_def_styv_rec;
2892: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2893: EXCEPTION

Line 3116: -- lock_row for:OKL_STRM_TYPE_TL --

3112: '_PVT'
3113: );
3114: END lock_row;
3115: -----------------------------------
3116: -- lock_row for:OKL_STRM_TYPE_TL --
3117: -----------------------------------
3118: PROCEDURE lock_row(
3119: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3120: x_return_status OUT NOCOPY VARCHAR2,

Line 3123: p_okl_strm_type_tl_rec IN okl_strm_type_tl_rec_type) IS

3119: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3120: x_return_status OUT NOCOPY VARCHAR2,
3121: x_msg_count OUT NOCOPY NUMBER,
3122: x_msg_data OUT NOCOPY VARCHAR2,
3123: p_okl_strm_type_tl_rec IN okl_strm_type_tl_rec_type) IS
3124:
3125: E_Resource_Busy EXCEPTION;
3126: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
3127: CURSOR lock_csr (p_okl_strm_type_tl_rec IN okl_strm_type_tl_rec_type) IS

Line 3127: CURSOR lock_csr (p_okl_strm_type_tl_rec IN okl_strm_type_tl_rec_type) IS

3123: p_okl_strm_type_tl_rec IN okl_strm_type_tl_rec_type) IS
3124:
3125: E_Resource_Busy EXCEPTION;
3126: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
3127: CURSOR lock_csr (p_okl_strm_type_tl_rec IN okl_strm_type_tl_rec_type) IS
3128: SELECT *
3129: FROM OKL_STRM_TYPE_TL
3130: WHERE ID = p_okl_strm_type_tl_rec.id
3131: FOR UPDATE NOWAIT;

Line 3129: FROM OKL_STRM_TYPE_TL

3125: E_Resource_Busy EXCEPTION;
3126: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
3127: CURSOR lock_csr (p_okl_strm_type_tl_rec IN okl_strm_type_tl_rec_type) IS
3128: SELECT *
3129: FROM OKL_STRM_TYPE_TL
3130: WHERE ID = p_okl_strm_type_tl_rec.id
3131: FOR UPDATE NOWAIT;
3132:
3133: l_api_version CONSTANT NUMBER := 1;

Line 3130: WHERE ID = p_okl_strm_type_tl_rec.id

3126: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
3127: CURSOR lock_csr (p_okl_strm_type_tl_rec IN okl_strm_type_tl_rec_type) IS
3128: SELECT *
3129: FROM OKL_STRM_TYPE_TL
3130: WHERE ID = p_okl_strm_type_tl_rec.id
3131: FOR UPDATE NOWAIT;
3132:
3133: l_api_version CONSTANT NUMBER := 1;
3134: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';

Line 3150: OPEN lock_csr(p_okl_strm_type_tl_rec);

3146: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3147: RAISE OKC_API.G_EXCEPTION_ERROR;
3148: END IF;
3149: BEGIN
3150: OPEN lock_csr(p_okl_strm_type_tl_rec);
3151: FETCH lock_csr INTO l_lock_var;
3152: l_row_notfound := lock_csr%NOTFOUND;
3153: CLOSE lock_csr;
3154: EXCEPTION

Line 3215: l_okl_strm_type_tl_rec okl_strm_type_tl_rec_type;

3211: l_api_version CONSTANT NUMBER := 1;
3212: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
3213: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3214: l_sty_rec sty_rec_type;
3215: l_okl_strm_type_tl_rec okl_strm_type_tl_rec_type;
3216: BEGIN
3217: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
3218: G_PKG_NAME,
3219: p_init_msg_list,

Line 3233: migrate(p_styv_rec, l_okl_strm_type_tl_rec);

3229: --------------------------------------
3230: -- Move VIEW record to "Child" records
3231: --------------------------------------
3232: migrate(p_styv_rec, l_sty_rec);
3233: migrate(p_styv_rec, l_okl_strm_type_tl_rec);
3234: --------------------------------------------
3235: -- Call the LOCK_ROW for each child record
3236: --------------------------------------------
3237: lock_row(

Line 3254: l_okl_strm_type_tl_rec

3250: p_init_msg_list,
3251: x_return_status,
3252: x_msg_count,
3253: x_msg_data,
3254: l_okl_strm_type_tl_rec
3255: );
3256: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3257: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3258: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 3708: -- update_row for:OKL_STRM_TYPE_TL --

3704: '_PVT'
3705: );
3706: END update_row;
3707: -------------------------------------
3708: -- update_row for:OKL_STRM_TYPE_TL --
3709: -------------------------------------
3710: PROCEDURE update_row(
3711: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3712: x_return_status OUT NOCOPY VARCHAR2,

Line 3715: p_okl_strm_type_tl_rec IN okl_strm_type_tl_rec_type,

3711: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3712: x_return_status OUT NOCOPY VARCHAR2,
3713: x_msg_count OUT NOCOPY NUMBER,
3714: x_msg_data OUT NOCOPY VARCHAR2,
3715: p_okl_strm_type_tl_rec IN okl_strm_type_tl_rec_type,
3716: x_okl_strm_type_tl_rec OUT NOCOPY okl_strm_type_tl_rec_type) IS
3717:
3718: l_api_version CONSTANT NUMBER := 1;
3719: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';

Line 3716: x_okl_strm_type_tl_rec OUT NOCOPY okl_strm_type_tl_rec_type) IS

3712: x_return_status OUT NOCOPY VARCHAR2,
3713: x_msg_count OUT NOCOPY NUMBER,
3714: x_msg_data OUT NOCOPY VARCHAR2,
3715: p_okl_strm_type_tl_rec IN okl_strm_type_tl_rec_type,
3716: x_okl_strm_type_tl_rec OUT NOCOPY okl_strm_type_tl_rec_type) IS
3717:
3718: l_api_version CONSTANT NUMBER := 1;
3719: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
3720: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 3721: l_okl_strm_type_tl_rec okl_strm_type_tl_rec_type := p_okl_strm_type_tl_rec;

3717:
3718: l_api_version CONSTANT NUMBER := 1;
3719: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
3720: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3721: l_okl_strm_type_tl_rec okl_strm_type_tl_rec_type := p_okl_strm_type_tl_rec;
3722: l_def_okl_strm_type_tl_rec okl_strm_type_tl_rec_type;
3723: l_row_notfound BOOLEAN := TRUE;
3724: ----------------------------------
3725: -- FUNCTION populate_new_record --

Line 3722: l_def_okl_strm_type_tl_rec okl_strm_type_tl_rec_type;

3718: l_api_version CONSTANT NUMBER := 1;
3719: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
3720: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3721: l_okl_strm_type_tl_rec okl_strm_type_tl_rec_type := p_okl_strm_type_tl_rec;
3722: l_def_okl_strm_type_tl_rec okl_strm_type_tl_rec_type;
3723: l_row_notfound BOOLEAN := TRUE;
3724: ----------------------------------
3725: -- FUNCTION populate_new_record --
3726: ----------------------------------

Line 3728: p_okl_strm_type_tl_rec IN okl_strm_type_tl_rec_type,

3724: ----------------------------------
3725: -- FUNCTION populate_new_record --
3726: ----------------------------------
3727: FUNCTION populate_new_record (
3728: p_okl_strm_type_tl_rec IN okl_strm_type_tl_rec_type,
3729: x_okl_strm_type_tl_rec OUT NOCOPY okl_strm_type_tl_rec_type
3730: ) RETURN VARCHAR2 IS
3731: l_okl_strm_type_tl_rec okl_strm_type_tl_rec_type;
3732: l_row_notfound BOOLEAN := TRUE;

Line 3729: x_okl_strm_type_tl_rec OUT NOCOPY okl_strm_type_tl_rec_type

3725: -- FUNCTION populate_new_record --
3726: ----------------------------------
3727: FUNCTION populate_new_record (
3728: p_okl_strm_type_tl_rec IN okl_strm_type_tl_rec_type,
3729: x_okl_strm_type_tl_rec OUT NOCOPY okl_strm_type_tl_rec_type
3730: ) RETURN VARCHAR2 IS
3731: l_okl_strm_type_tl_rec okl_strm_type_tl_rec_type;
3732: l_row_notfound BOOLEAN := TRUE;
3733: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 3731: l_okl_strm_type_tl_rec okl_strm_type_tl_rec_type;

3727: FUNCTION populate_new_record (
3728: p_okl_strm_type_tl_rec IN okl_strm_type_tl_rec_type,
3729: x_okl_strm_type_tl_rec OUT NOCOPY okl_strm_type_tl_rec_type
3730: ) RETURN VARCHAR2 IS
3731: l_okl_strm_type_tl_rec okl_strm_type_tl_rec_type;
3732: l_row_notfound BOOLEAN := TRUE;
3733: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3734: BEGIN
3735: x_okl_strm_type_tl_rec := p_okl_strm_type_tl_rec;

Line 3735: x_okl_strm_type_tl_rec := p_okl_strm_type_tl_rec;

3731: l_okl_strm_type_tl_rec okl_strm_type_tl_rec_type;
3732: l_row_notfound BOOLEAN := TRUE;
3733: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3734: BEGIN
3735: x_okl_strm_type_tl_rec := p_okl_strm_type_tl_rec;
3736: -- Get current database values
3737: l_okl_strm_type_tl_rec := get_rec(p_okl_strm_type_tl_rec, l_row_notfound);
3738: IF (l_row_notfound) THEN
3739: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

Line 3737: l_okl_strm_type_tl_rec := get_rec(p_okl_strm_type_tl_rec, l_row_notfound);

3733: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3734: BEGIN
3735: x_okl_strm_type_tl_rec := p_okl_strm_type_tl_rec;
3736: -- Get current database values
3737: l_okl_strm_type_tl_rec := get_rec(p_okl_strm_type_tl_rec, l_row_notfound);
3738: IF (l_row_notfound) THEN
3739: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
3740: END IF;
3741: IF (x_okl_strm_type_tl_rec.id = OKC_API.G_MISS_NUM)

Line 3741: IF (x_okl_strm_type_tl_rec.id = OKC_API.G_MISS_NUM)

3737: l_okl_strm_type_tl_rec := get_rec(p_okl_strm_type_tl_rec, l_row_notfound);
3738: IF (l_row_notfound) THEN
3739: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
3740: END IF;
3741: IF (x_okl_strm_type_tl_rec.id = OKC_API.G_MISS_NUM)
3742: THEN
3743: x_okl_strm_type_tl_rec.id := l_okl_strm_type_tl_rec.id;
3744: END IF;
3745: IF (x_okl_strm_type_tl_rec.language = OKC_API.G_MISS_CHAR)

Line 3743: x_okl_strm_type_tl_rec.id := l_okl_strm_type_tl_rec.id;

3739: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
3740: END IF;
3741: IF (x_okl_strm_type_tl_rec.id = OKC_API.G_MISS_NUM)
3742: THEN
3743: x_okl_strm_type_tl_rec.id := l_okl_strm_type_tl_rec.id;
3744: END IF;
3745: IF (x_okl_strm_type_tl_rec.language = OKC_API.G_MISS_CHAR)
3746: THEN
3747: x_okl_strm_type_tl_rec.language := l_okl_strm_type_tl_rec.language;

Line 3745: IF (x_okl_strm_type_tl_rec.language = OKC_API.G_MISS_CHAR)

3741: IF (x_okl_strm_type_tl_rec.id = OKC_API.G_MISS_NUM)
3742: THEN
3743: x_okl_strm_type_tl_rec.id := l_okl_strm_type_tl_rec.id;
3744: END IF;
3745: IF (x_okl_strm_type_tl_rec.language = OKC_API.G_MISS_CHAR)
3746: THEN
3747: x_okl_strm_type_tl_rec.language := l_okl_strm_type_tl_rec.language;
3748: END IF;
3749: IF (x_okl_strm_type_tl_rec.source_lang = OKC_API.G_MISS_CHAR)

Line 3747: x_okl_strm_type_tl_rec.language := l_okl_strm_type_tl_rec.language;

3743: x_okl_strm_type_tl_rec.id := l_okl_strm_type_tl_rec.id;
3744: END IF;
3745: IF (x_okl_strm_type_tl_rec.language = OKC_API.G_MISS_CHAR)
3746: THEN
3747: x_okl_strm_type_tl_rec.language := l_okl_strm_type_tl_rec.language;
3748: END IF;
3749: IF (x_okl_strm_type_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
3750: THEN
3751: x_okl_strm_type_tl_rec.source_lang := l_okl_strm_type_tl_rec.source_lang;

Line 3749: IF (x_okl_strm_type_tl_rec.source_lang = OKC_API.G_MISS_CHAR)

3745: IF (x_okl_strm_type_tl_rec.language = OKC_API.G_MISS_CHAR)
3746: THEN
3747: x_okl_strm_type_tl_rec.language := l_okl_strm_type_tl_rec.language;
3748: END IF;
3749: IF (x_okl_strm_type_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
3750: THEN
3751: x_okl_strm_type_tl_rec.source_lang := l_okl_strm_type_tl_rec.source_lang;
3752: END IF;
3753: IF (x_okl_strm_type_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)

Line 3751: x_okl_strm_type_tl_rec.source_lang := l_okl_strm_type_tl_rec.source_lang;

3747: x_okl_strm_type_tl_rec.language := l_okl_strm_type_tl_rec.language;
3748: END IF;
3749: IF (x_okl_strm_type_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
3750: THEN
3751: x_okl_strm_type_tl_rec.source_lang := l_okl_strm_type_tl_rec.source_lang;
3752: END IF;
3753: IF (x_okl_strm_type_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
3754: THEN
3755: x_okl_strm_type_tl_rec.sfwt_flag := l_okl_strm_type_tl_rec.sfwt_flag;

Line 3753: IF (x_okl_strm_type_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)

3749: IF (x_okl_strm_type_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
3750: THEN
3751: x_okl_strm_type_tl_rec.source_lang := l_okl_strm_type_tl_rec.source_lang;
3752: END IF;
3753: IF (x_okl_strm_type_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
3754: THEN
3755: x_okl_strm_type_tl_rec.sfwt_flag := l_okl_strm_type_tl_rec.sfwt_flag;
3756: END IF;
3757: IF (x_okl_strm_type_tl_rec.name = OKC_API.G_MISS_CHAR)

Line 3755: x_okl_strm_type_tl_rec.sfwt_flag := l_okl_strm_type_tl_rec.sfwt_flag;

3751: x_okl_strm_type_tl_rec.source_lang := l_okl_strm_type_tl_rec.source_lang;
3752: END IF;
3753: IF (x_okl_strm_type_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
3754: THEN
3755: x_okl_strm_type_tl_rec.sfwt_flag := l_okl_strm_type_tl_rec.sfwt_flag;
3756: END IF;
3757: IF (x_okl_strm_type_tl_rec.name = OKC_API.G_MISS_CHAR)
3758: THEN
3759: x_okl_strm_type_tl_rec.name := l_okl_strm_type_tl_rec.name;

Line 3757: IF (x_okl_strm_type_tl_rec.name = OKC_API.G_MISS_CHAR)

3753: IF (x_okl_strm_type_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
3754: THEN
3755: x_okl_strm_type_tl_rec.sfwt_flag := l_okl_strm_type_tl_rec.sfwt_flag;
3756: END IF;
3757: IF (x_okl_strm_type_tl_rec.name = OKC_API.G_MISS_CHAR)
3758: THEN
3759: x_okl_strm_type_tl_rec.name := l_okl_strm_type_tl_rec.name;
3760: END IF;
3761: IF (x_okl_strm_type_tl_rec.description = OKC_API.G_MISS_CHAR)

Line 3759: x_okl_strm_type_tl_rec.name := l_okl_strm_type_tl_rec.name;

3755: x_okl_strm_type_tl_rec.sfwt_flag := l_okl_strm_type_tl_rec.sfwt_flag;
3756: END IF;
3757: IF (x_okl_strm_type_tl_rec.name = OKC_API.G_MISS_CHAR)
3758: THEN
3759: x_okl_strm_type_tl_rec.name := l_okl_strm_type_tl_rec.name;
3760: END IF;
3761: IF (x_okl_strm_type_tl_rec.description = OKC_API.G_MISS_CHAR)
3762: THEN
3763: x_okl_strm_type_tl_rec.description := l_okl_strm_type_tl_rec.description;

Line 3761: IF (x_okl_strm_type_tl_rec.description = OKC_API.G_MISS_CHAR)

3757: IF (x_okl_strm_type_tl_rec.name = OKC_API.G_MISS_CHAR)
3758: THEN
3759: x_okl_strm_type_tl_rec.name := l_okl_strm_type_tl_rec.name;
3760: END IF;
3761: IF (x_okl_strm_type_tl_rec.description = OKC_API.G_MISS_CHAR)
3762: THEN
3763: x_okl_strm_type_tl_rec.description := l_okl_strm_type_tl_rec.description;
3764: END IF;
3765: IF (x_okl_strm_type_tl_rec.created_by = OKC_API.G_MISS_NUM)

Line 3763: x_okl_strm_type_tl_rec.description := l_okl_strm_type_tl_rec.description;

3759: x_okl_strm_type_tl_rec.name := l_okl_strm_type_tl_rec.name;
3760: END IF;
3761: IF (x_okl_strm_type_tl_rec.description = OKC_API.G_MISS_CHAR)
3762: THEN
3763: x_okl_strm_type_tl_rec.description := l_okl_strm_type_tl_rec.description;
3764: END IF;
3765: IF (x_okl_strm_type_tl_rec.created_by = OKC_API.G_MISS_NUM)
3766: THEN
3767: x_okl_strm_type_tl_rec.created_by := l_okl_strm_type_tl_rec.created_by;

Line 3765: IF (x_okl_strm_type_tl_rec.created_by = OKC_API.G_MISS_NUM)

3761: IF (x_okl_strm_type_tl_rec.description = OKC_API.G_MISS_CHAR)
3762: THEN
3763: x_okl_strm_type_tl_rec.description := l_okl_strm_type_tl_rec.description;
3764: END IF;
3765: IF (x_okl_strm_type_tl_rec.created_by = OKC_API.G_MISS_NUM)
3766: THEN
3767: x_okl_strm_type_tl_rec.created_by := l_okl_strm_type_tl_rec.created_by;
3768: END IF;
3769: IF (x_okl_strm_type_tl_rec.creation_date = OKC_API.G_MISS_DATE)

Line 3767: x_okl_strm_type_tl_rec.created_by := l_okl_strm_type_tl_rec.created_by;

3763: x_okl_strm_type_tl_rec.description := l_okl_strm_type_tl_rec.description;
3764: END IF;
3765: IF (x_okl_strm_type_tl_rec.created_by = OKC_API.G_MISS_NUM)
3766: THEN
3767: x_okl_strm_type_tl_rec.created_by := l_okl_strm_type_tl_rec.created_by;
3768: END IF;
3769: IF (x_okl_strm_type_tl_rec.creation_date = OKC_API.G_MISS_DATE)
3770: THEN
3771: x_okl_strm_type_tl_rec.creation_date := l_okl_strm_type_tl_rec.creation_date;

Line 3769: IF (x_okl_strm_type_tl_rec.creation_date = OKC_API.G_MISS_DATE)

3765: IF (x_okl_strm_type_tl_rec.created_by = OKC_API.G_MISS_NUM)
3766: THEN
3767: x_okl_strm_type_tl_rec.created_by := l_okl_strm_type_tl_rec.created_by;
3768: END IF;
3769: IF (x_okl_strm_type_tl_rec.creation_date = OKC_API.G_MISS_DATE)
3770: THEN
3771: x_okl_strm_type_tl_rec.creation_date := l_okl_strm_type_tl_rec.creation_date;
3772: END IF;
3773: IF (x_okl_strm_type_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)

Line 3771: x_okl_strm_type_tl_rec.creation_date := l_okl_strm_type_tl_rec.creation_date;

3767: x_okl_strm_type_tl_rec.created_by := l_okl_strm_type_tl_rec.created_by;
3768: END IF;
3769: IF (x_okl_strm_type_tl_rec.creation_date = OKC_API.G_MISS_DATE)
3770: THEN
3771: x_okl_strm_type_tl_rec.creation_date := l_okl_strm_type_tl_rec.creation_date;
3772: END IF;
3773: IF (x_okl_strm_type_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
3774: THEN
3775: x_okl_strm_type_tl_rec.last_updated_by := l_okl_strm_type_tl_rec.last_updated_by;

Line 3773: IF (x_okl_strm_type_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)

3769: IF (x_okl_strm_type_tl_rec.creation_date = OKC_API.G_MISS_DATE)
3770: THEN
3771: x_okl_strm_type_tl_rec.creation_date := l_okl_strm_type_tl_rec.creation_date;
3772: END IF;
3773: IF (x_okl_strm_type_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
3774: THEN
3775: x_okl_strm_type_tl_rec.last_updated_by := l_okl_strm_type_tl_rec.last_updated_by;
3776: END IF;
3777: IF (x_okl_strm_type_tl_rec.last_update_date = OKC_API.G_MISS_DATE)

Line 3775: x_okl_strm_type_tl_rec.last_updated_by := l_okl_strm_type_tl_rec.last_updated_by;

3771: x_okl_strm_type_tl_rec.creation_date := l_okl_strm_type_tl_rec.creation_date;
3772: END IF;
3773: IF (x_okl_strm_type_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
3774: THEN
3775: x_okl_strm_type_tl_rec.last_updated_by := l_okl_strm_type_tl_rec.last_updated_by;
3776: END IF;
3777: IF (x_okl_strm_type_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
3778: THEN
3779: x_okl_strm_type_tl_rec.last_update_date := l_okl_strm_type_tl_rec.last_update_date;

Line 3777: IF (x_okl_strm_type_tl_rec.last_update_date = OKC_API.G_MISS_DATE)

3773: IF (x_okl_strm_type_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
3774: THEN
3775: x_okl_strm_type_tl_rec.last_updated_by := l_okl_strm_type_tl_rec.last_updated_by;
3776: END IF;
3777: IF (x_okl_strm_type_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
3778: THEN
3779: x_okl_strm_type_tl_rec.last_update_date := l_okl_strm_type_tl_rec.last_update_date;
3780: END IF;
3781: IF (x_okl_strm_type_tl_rec.last_update_login = OKC_API.G_MISS_NUM)

Line 3779: x_okl_strm_type_tl_rec.last_update_date := l_okl_strm_type_tl_rec.last_update_date;

3775: x_okl_strm_type_tl_rec.last_updated_by := l_okl_strm_type_tl_rec.last_updated_by;
3776: END IF;
3777: IF (x_okl_strm_type_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
3778: THEN
3779: x_okl_strm_type_tl_rec.last_update_date := l_okl_strm_type_tl_rec.last_update_date;
3780: END IF;
3781: IF (x_okl_strm_type_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
3782: THEN
3783: x_okl_strm_type_tl_rec.last_update_login := l_okl_strm_type_tl_rec.last_update_login;

Line 3781: IF (x_okl_strm_type_tl_rec.last_update_login = OKC_API.G_MISS_NUM)

3777: IF (x_okl_strm_type_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
3778: THEN
3779: x_okl_strm_type_tl_rec.last_update_date := l_okl_strm_type_tl_rec.last_update_date;
3780: END IF;
3781: IF (x_okl_strm_type_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
3782: THEN
3783: x_okl_strm_type_tl_rec.last_update_login := l_okl_strm_type_tl_rec.last_update_login;
3784: END IF;
3785: -- Added by RGOOTY for ER 3935682: Start

Line 3783: x_okl_strm_type_tl_rec.last_update_login := l_okl_strm_type_tl_rec.last_update_login;

3779: x_okl_strm_type_tl_rec.last_update_date := l_okl_strm_type_tl_rec.last_update_date;
3780: END IF;
3781: IF (x_okl_strm_type_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
3782: THEN
3783: x_okl_strm_type_tl_rec.last_update_login := l_okl_strm_type_tl_rec.last_update_login;
3784: END IF;
3785: -- Added by RGOOTY for ER 3935682: Start
3786: IF (x_okl_strm_type_tl_rec.short_description= OKC_API.G_MISS_CHAR)
3787: THEN

Line 3786: IF (x_okl_strm_type_tl_rec.short_description= OKC_API.G_MISS_CHAR)

3782: THEN
3783: x_okl_strm_type_tl_rec.last_update_login := l_okl_strm_type_tl_rec.last_update_login;
3784: END IF;
3785: -- Added by RGOOTY for ER 3935682: Start
3786: IF (x_okl_strm_type_tl_rec.short_description= OKC_API.G_MISS_CHAR)
3787: THEN
3788: x_okl_strm_type_tl_rec.short_description := l_okl_strm_type_tl_rec.short_description;
3789: END IF;
3790: -- Added by RGOOTY for ER 3935682: End

Line 3788: x_okl_strm_type_tl_rec.short_description := l_okl_strm_type_tl_rec.short_description;

3784: END IF;
3785: -- Added by RGOOTY for ER 3935682: Start
3786: IF (x_okl_strm_type_tl_rec.short_description= OKC_API.G_MISS_CHAR)
3787: THEN
3788: x_okl_strm_type_tl_rec.short_description := l_okl_strm_type_tl_rec.short_description;
3789: END IF;
3790: -- Added by RGOOTY for ER 3935682: End
3791: RETURN(l_return_status);
3792: END populate_new_record;

Line 3794: -- Set_Attributes for:OKL_STRM_TYPE_TL --

3790: -- Added by RGOOTY for ER 3935682: End
3791: RETURN(l_return_status);
3792: END populate_new_record;
3793: -----------------------------------------
3794: -- Set_Attributes for:OKL_STRM_TYPE_TL --
3795: -----------------------------------------
3796: FUNCTION Set_Attributes (
3797: p_okl_strm_type_tl_rec IN okl_strm_type_tl_rec_type,
3798: x_okl_strm_type_tl_rec OUT NOCOPY okl_strm_type_tl_rec_type

Line 3797: p_okl_strm_type_tl_rec IN okl_strm_type_tl_rec_type,

3793: -----------------------------------------
3794: -- Set_Attributes for:OKL_STRM_TYPE_TL --
3795: -----------------------------------------
3796: FUNCTION Set_Attributes (
3797: p_okl_strm_type_tl_rec IN okl_strm_type_tl_rec_type,
3798: x_okl_strm_type_tl_rec OUT NOCOPY okl_strm_type_tl_rec_type
3799: ) RETURN VARCHAR2 IS
3800: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3801: BEGIN

Line 3798: x_okl_strm_type_tl_rec OUT NOCOPY okl_strm_type_tl_rec_type

3794: -- Set_Attributes for:OKL_STRM_TYPE_TL --
3795: -----------------------------------------
3796: FUNCTION Set_Attributes (
3797: p_okl_strm_type_tl_rec IN okl_strm_type_tl_rec_type,
3798: x_okl_strm_type_tl_rec OUT NOCOPY okl_strm_type_tl_rec_type
3799: ) RETURN VARCHAR2 IS
3800: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3801: BEGIN
3802: x_okl_strm_type_tl_rec := p_okl_strm_type_tl_rec;

Line 3802: x_okl_strm_type_tl_rec := p_okl_strm_type_tl_rec;

3798: x_okl_strm_type_tl_rec OUT NOCOPY okl_strm_type_tl_rec_type
3799: ) RETURN VARCHAR2 IS
3800: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3801: BEGIN
3802: x_okl_strm_type_tl_rec := p_okl_strm_type_tl_rec;
3803: x_okl_strm_type_tl_rec.LANGUAGE := USERENV('LANG');
3804: x_okl_strm_type_tl_rec.SOURCE_LANG := USERENV('LANG');
3805: RETURN(l_return_status);
3806: END Set_Attributes;

Line 3803: x_okl_strm_type_tl_rec.LANGUAGE := USERENV('LANG');

3799: ) RETURN VARCHAR2 IS
3800: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3801: BEGIN
3802: x_okl_strm_type_tl_rec := p_okl_strm_type_tl_rec;
3803: x_okl_strm_type_tl_rec.LANGUAGE := USERENV('LANG');
3804: x_okl_strm_type_tl_rec.SOURCE_LANG := USERENV('LANG');
3805: RETURN(l_return_status);
3806: END Set_Attributes;
3807: BEGIN

Line 3804: x_okl_strm_type_tl_rec.SOURCE_LANG := USERENV('LANG');

3800: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3801: BEGIN
3802: x_okl_strm_type_tl_rec := p_okl_strm_type_tl_rec;
3803: x_okl_strm_type_tl_rec.LANGUAGE := USERENV('LANG');
3804: x_okl_strm_type_tl_rec.SOURCE_LANG := USERENV('LANG');
3805: RETURN(l_return_status);
3806: END Set_Attributes;
3807: BEGIN
3808: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3819: p_okl_strm_type_tl_rec, -- IN

3815: RAISE OKC_API.G_EXCEPTION_ERROR;
3816: END IF;
3817: --- Setting item attributes
3818: l_return_status := Set_Attributes(
3819: p_okl_strm_type_tl_rec, -- IN
3820: l_okl_strm_type_tl_rec); -- OUT
3821: --- If any errors happen abort API
3822: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3823: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3820: l_okl_strm_type_tl_rec); -- OUT

3816: END IF;
3817: --- Setting item attributes
3818: l_return_status := Set_Attributes(
3819: p_okl_strm_type_tl_rec, -- IN
3820: l_okl_strm_type_tl_rec); -- OUT
3821: --- If any errors happen abort API
3822: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3823: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3824: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 3827: l_return_status := populate_new_record(l_okl_strm_type_tl_rec, l_def_okl_strm_type_tl_rec);

3823: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3824: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3825: RAISE OKC_API.G_EXCEPTION_ERROR;
3826: END IF;
3827: l_return_status := populate_new_record(l_okl_strm_type_tl_rec, l_def_okl_strm_type_tl_rec);
3828: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3829: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3830: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3831: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 3833: UPDATE OKL_STRM_TYPE_TL

3829: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3830: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3831: RAISE OKC_API.G_EXCEPTION_ERROR;
3832: END IF;
3833: UPDATE OKL_STRM_TYPE_TL
3834: SET NAME = l_def_okl_strm_type_tl_rec.name,
3835: DESCRIPTION = l_def_okl_strm_type_tl_rec.description,
3836: CREATED_BY = l_def_okl_strm_type_tl_rec.created_by,
3837: SOURCE_LANG = l_def_okl_strm_type_tl_rec.source_lang,

Line 3834: SET NAME = l_def_okl_strm_type_tl_rec.name,

3830: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3831: RAISE OKC_API.G_EXCEPTION_ERROR;
3832: END IF;
3833: UPDATE OKL_STRM_TYPE_TL
3834: SET NAME = l_def_okl_strm_type_tl_rec.name,
3835: DESCRIPTION = l_def_okl_strm_type_tl_rec.description,
3836: CREATED_BY = l_def_okl_strm_type_tl_rec.created_by,
3837: SOURCE_LANG = l_def_okl_strm_type_tl_rec.source_lang,
3838: CREATION_DATE = l_def_okl_strm_type_tl_rec.creation_date,

Line 3835: DESCRIPTION = l_def_okl_strm_type_tl_rec.description,

3831: RAISE OKC_API.G_EXCEPTION_ERROR;
3832: END IF;
3833: UPDATE OKL_STRM_TYPE_TL
3834: SET NAME = l_def_okl_strm_type_tl_rec.name,
3835: DESCRIPTION = l_def_okl_strm_type_tl_rec.description,
3836: CREATED_BY = l_def_okl_strm_type_tl_rec.created_by,
3837: SOURCE_LANG = l_def_okl_strm_type_tl_rec.source_lang,
3838: CREATION_DATE = l_def_okl_strm_type_tl_rec.creation_date,
3839: LAST_UPDATED_BY = l_def_okl_strm_type_tl_rec.last_updated_by,

Line 3836: CREATED_BY = l_def_okl_strm_type_tl_rec.created_by,

3832: END IF;
3833: UPDATE OKL_STRM_TYPE_TL
3834: SET NAME = l_def_okl_strm_type_tl_rec.name,
3835: DESCRIPTION = l_def_okl_strm_type_tl_rec.description,
3836: CREATED_BY = l_def_okl_strm_type_tl_rec.created_by,
3837: SOURCE_LANG = l_def_okl_strm_type_tl_rec.source_lang,
3838: CREATION_DATE = l_def_okl_strm_type_tl_rec.creation_date,
3839: LAST_UPDATED_BY = l_def_okl_strm_type_tl_rec.last_updated_by,
3840: LAST_UPDATE_DATE = l_def_okl_strm_type_tl_rec.last_update_date,

Line 3837: SOURCE_LANG = l_def_okl_strm_type_tl_rec.source_lang,

3833: UPDATE OKL_STRM_TYPE_TL
3834: SET NAME = l_def_okl_strm_type_tl_rec.name,
3835: DESCRIPTION = l_def_okl_strm_type_tl_rec.description,
3836: CREATED_BY = l_def_okl_strm_type_tl_rec.created_by,
3837: SOURCE_LANG = l_def_okl_strm_type_tl_rec.source_lang,
3838: CREATION_DATE = l_def_okl_strm_type_tl_rec.creation_date,
3839: LAST_UPDATED_BY = l_def_okl_strm_type_tl_rec.last_updated_by,
3840: LAST_UPDATE_DATE = l_def_okl_strm_type_tl_rec.last_update_date,
3841: LAST_UPDATE_LOGIN = l_def_okl_strm_type_tl_rec.last_update_login,

Line 3838: CREATION_DATE = l_def_okl_strm_type_tl_rec.creation_date,

3834: SET NAME = l_def_okl_strm_type_tl_rec.name,
3835: DESCRIPTION = l_def_okl_strm_type_tl_rec.description,
3836: CREATED_BY = l_def_okl_strm_type_tl_rec.created_by,
3837: SOURCE_LANG = l_def_okl_strm_type_tl_rec.source_lang,
3838: CREATION_DATE = l_def_okl_strm_type_tl_rec.creation_date,
3839: LAST_UPDATED_BY = l_def_okl_strm_type_tl_rec.last_updated_by,
3840: LAST_UPDATE_DATE = l_def_okl_strm_type_tl_rec.last_update_date,
3841: LAST_UPDATE_LOGIN = l_def_okl_strm_type_tl_rec.last_update_login,
3842: -- Added by RGOOTY for ER 3935682: Start

Line 3839: LAST_UPDATED_BY = l_def_okl_strm_type_tl_rec.last_updated_by,

3835: DESCRIPTION = l_def_okl_strm_type_tl_rec.description,
3836: CREATED_BY = l_def_okl_strm_type_tl_rec.created_by,
3837: SOURCE_LANG = l_def_okl_strm_type_tl_rec.source_lang,
3838: CREATION_DATE = l_def_okl_strm_type_tl_rec.creation_date,
3839: LAST_UPDATED_BY = l_def_okl_strm_type_tl_rec.last_updated_by,
3840: LAST_UPDATE_DATE = l_def_okl_strm_type_tl_rec.last_update_date,
3841: LAST_UPDATE_LOGIN = l_def_okl_strm_type_tl_rec.last_update_login,
3842: -- Added by RGOOTY for ER 3935682: Start
3843: SHORT_DESCRIPTION = l_def_okl_strm_type_tl_rec.short_description

Line 3840: LAST_UPDATE_DATE = l_def_okl_strm_type_tl_rec.last_update_date,

3836: CREATED_BY = l_def_okl_strm_type_tl_rec.created_by,
3837: SOURCE_LANG = l_def_okl_strm_type_tl_rec.source_lang,
3838: CREATION_DATE = l_def_okl_strm_type_tl_rec.creation_date,
3839: LAST_UPDATED_BY = l_def_okl_strm_type_tl_rec.last_updated_by,
3840: LAST_UPDATE_DATE = l_def_okl_strm_type_tl_rec.last_update_date,
3841: LAST_UPDATE_LOGIN = l_def_okl_strm_type_tl_rec.last_update_login,
3842: -- Added by RGOOTY for ER 3935682: Start
3843: SHORT_DESCRIPTION = l_def_okl_strm_type_tl_rec.short_description
3844: -- Added by RGOOTY for ER 3935682: End

Line 3841: LAST_UPDATE_LOGIN = l_def_okl_strm_type_tl_rec.last_update_login,

3837: SOURCE_LANG = l_def_okl_strm_type_tl_rec.source_lang,
3838: CREATION_DATE = l_def_okl_strm_type_tl_rec.creation_date,
3839: LAST_UPDATED_BY = l_def_okl_strm_type_tl_rec.last_updated_by,
3840: LAST_UPDATE_DATE = l_def_okl_strm_type_tl_rec.last_update_date,
3841: LAST_UPDATE_LOGIN = l_def_okl_strm_type_tl_rec.last_update_login,
3842: -- Added by RGOOTY for ER 3935682: Start
3843: SHORT_DESCRIPTION = l_def_okl_strm_type_tl_rec.short_description
3844: -- Added by RGOOTY for ER 3935682: End
3845: WHERE ID = l_def_okl_strm_type_tl_rec.id

Line 3843: SHORT_DESCRIPTION = l_def_okl_strm_type_tl_rec.short_description

3839: LAST_UPDATED_BY = l_def_okl_strm_type_tl_rec.last_updated_by,
3840: LAST_UPDATE_DATE = l_def_okl_strm_type_tl_rec.last_update_date,
3841: LAST_UPDATE_LOGIN = l_def_okl_strm_type_tl_rec.last_update_login,
3842: -- Added by RGOOTY for ER 3935682: Start
3843: SHORT_DESCRIPTION = l_def_okl_strm_type_tl_rec.short_description
3844: -- Added by RGOOTY for ER 3935682: End
3845: WHERE ID = l_def_okl_strm_type_tl_rec.id
3846: AND USERENV('LANG') in (SOURCE_LANG, LANGUAGE);
3847: -- AND SOURCE_LANG = USERENV('LANG');

Line 3845: WHERE ID = l_def_okl_strm_type_tl_rec.id

3841: LAST_UPDATE_LOGIN = l_def_okl_strm_type_tl_rec.last_update_login,
3842: -- Added by RGOOTY for ER 3935682: Start
3843: SHORT_DESCRIPTION = l_def_okl_strm_type_tl_rec.short_description
3844: -- Added by RGOOTY for ER 3935682: End
3845: WHERE ID = l_def_okl_strm_type_tl_rec.id
3846: AND USERENV('LANG') in (SOURCE_LANG, LANGUAGE);
3847: -- AND SOURCE_LANG = USERENV('LANG');
3848:
3849: UPDATE OKL_STRM_TYPE_TL

Line 3849: UPDATE OKL_STRM_TYPE_TL

3845: WHERE ID = l_def_okl_strm_type_tl_rec.id
3846: AND USERENV('LANG') in (SOURCE_LANG, LANGUAGE);
3847: -- AND SOURCE_LANG = USERENV('LANG');
3848:
3849: UPDATE OKL_STRM_TYPE_TL
3850: SET SFWT_FLAG = 'Y'
3851: WHERE ID = l_def_okl_strm_type_tl_rec.id
3852: AND SOURCE_LANG <> USERENV('LANG');
3853:

Line 3851: WHERE ID = l_def_okl_strm_type_tl_rec.id

3847: -- AND SOURCE_LANG = USERENV('LANG');
3848:
3849: UPDATE OKL_STRM_TYPE_TL
3850: SET SFWT_FLAG = 'Y'
3851: WHERE ID = l_def_okl_strm_type_tl_rec.id
3852: AND SOURCE_LANG <> USERENV('LANG');
3853:
3854: x_okl_strm_type_tl_rec := l_def_okl_strm_type_tl_rec;
3855: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 3854: x_okl_strm_type_tl_rec := l_def_okl_strm_type_tl_rec;

3850: SET SFWT_FLAG = 'Y'
3851: WHERE ID = l_def_okl_strm_type_tl_rec.id
3852: AND SOURCE_LANG <> USERENV('LANG');
3853:
3854: x_okl_strm_type_tl_rec := l_def_okl_strm_type_tl_rec;
3855: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3856: EXCEPTION
3857: WHEN OKC_API.G_EXCEPTION_ERROR THEN
3858: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 3905: l_okl_strm_type_tl_rec okl_strm_type_tl_rec_type;

3901: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
3902: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3903: l_styv_rec styv_rec_type := p_styv_rec;
3904: l_def_styv_rec styv_rec_type;
3905: l_okl_strm_type_tl_rec okl_strm_type_tl_rec_type;
3906: lx_okl_strm_type_tl_rec okl_strm_type_tl_rec_type;
3907: l_sty_rec sty_rec_type;
3908: lx_sty_rec sty_rec_type;
3909: -------------------------------

Line 3906: lx_okl_strm_type_tl_rec okl_strm_type_tl_rec_type;

3902: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3903: l_styv_rec styv_rec_type := p_styv_rec;
3904: l_def_styv_rec styv_rec_type;
3905: l_okl_strm_type_tl_rec okl_strm_type_tl_rec_type;
3906: lx_okl_strm_type_tl_rec okl_strm_type_tl_rec_type;
3907: l_sty_rec sty_rec_type;
3908: lx_sty_rec sty_rec_type;
3909: -------------------------------
3910: -- FUNCTION fill_who_columns --

Line 4190: migrate(l_def_styv_rec, l_okl_strm_type_tl_rec);

4186:
4187: --------------------------------------
4188: -- Move VIEW record to "Child" records
4189: --------------------------------------
4190: migrate(l_def_styv_rec, l_okl_strm_type_tl_rec);
4191: migrate(l_def_styv_rec, l_sty_rec);
4192: --------------------------------------------
4193: -- Call the UPDATE_ROW for each child record
4194: --------------------------------------------

Line 4200: l_okl_strm_type_tl_rec,

4196: p_init_msg_list,
4197: x_return_status,
4198: x_msg_count,
4199: x_msg_data,
4200: l_okl_strm_type_tl_rec,
4201: lx_okl_strm_type_tl_rec
4202: );
4203: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4204: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 4201: lx_okl_strm_type_tl_rec

4197: x_return_status,
4198: x_msg_count,
4199: x_msg_data,
4200: l_okl_strm_type_tl_rec,
4201: lx_okl_strm_type_tl_rec
4202: );
4203: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4204: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4205: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 4208: migrate(lx_okl_strm_type_tl_rec, l_def_styv_rec);

4204: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4205: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4206: RAISE OKC_API.G_EXCEPTION_ERROR;
4207: END IF;
4208: migrate(lx_okl_strm_type_tl_rec, l_def_styv_rec);
4209: update_row(
4210: p_init_msg_list,
4211: x_return_status,
4212: x_msg_count,

Line 4402: -- delete_row for:OKL_STRM_TYPE_TL --

4398: '_PVT'
4399: );
4400: END delete_row;
4401: -------------------------------------
4402: -- delete_row for:OKL_STRM_TYPE_TL --
4403: -------------------------------------
4404: PROCEDURE delete_row(
4405: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
4406: x_return_status OUT NOCOPY VARCHAR2,

Line 4409: p_okl_strm_type_tl_rec IN okl_strm_type_tl_rec_type) IS

4405: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
4406: x_return_status OUT NOCOPY VARCHAR2,
4407: x_msg_count OUT NOCOPY NUMBER,
4408: x_msg_data OUT NOCOPY VARCHAR2,
4409: p_okl_strm_type_tl_rec IN okl_strm_type_tl_rec_type) IS
4410:
4411: l_api_version CONSTANT NUMBER := 1;
4412: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
4413: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 4414: l_okl_strm_type_tl_rec okl_strm_type_tl_rec_type:= p_okl_strm_type_tl_rec;

4410:
4411: l_api_version CONSTANT NUMBER := 1;
4412: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
4413: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4414: l_okl_strm_type_tl_rec okl_strm_type_tl_rec_type:= p_okl_strm_type_tl_rec;
4415: l_row_notfound BOOLEAN := TRUE;
4416: -----------------------------------------
4417: -- Set_Attributes for:OKL_STRM_TYPE_TL --
4418: -----------------------------------------

Line 4417: -- Set_Attributes for:OKL_STRM_TYPE_TL --

4413: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4414: l_okl_strm_type_tl_rec okl_strm_type_tl_rec_type:= p_okl_strm_type_tl_rec;
4415: l_row_notfound BOOLEAN := TRUE;
4416: -----------------------------------------
4417: -- Set_Attributes for:OKL_STRM_TYPE_TL --
4418: -----------------------------------------
4419: FUNCTION Set_Attributes (
4420: p_okl_strm_type_tl_rec IN okl_strm_type_tl_rec_type,
4421: x_okl_strm_type_tl_rec OUT NOCOPY okl_strm_type_tl_rec_type

Line 4420: p_okl_strm_type_tl_rec IN okl_strm_type_tl_rec_type,

4416: -----------------------------------------
4417: -- Set_Attributes for:OKL_STRM_TYPE_TL --
4418: -----------------------------------------
4419: FUNCTION Set_Attributes (
4420: p_okl_strm_type_tl_rec IN okl_strm_type_tl_rec_type,
4421: x_okl_strm_type_tl_rec OUT NOCOPY okl_strm_type_tl_rec_type
4422: ) RETURN VARCHAR2 IS
4423: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4424: BEGIN

Line 4421: x_okl_strm_type_tl_rec OUT NOCOPY okl_strm_type_tl_rec_type

4417: -- Set_Attributes for:OKL_STRM_TYPE_TL --
4418: -----------------------------------------
4419: FUNCTION Set_Attributes (
4420: p_okl_strm_type_tl_rec IN okl_strm_type_tl_rec_type,
4421: x_okl_strm_type_tl_rec OUT NOCOPY okl_strm_type_tl_rec_type
4422: ) RETURN VARCHAR2 IS
4423: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4424: BEGIN
4425: x_okl_strm_type_tl_rec := p_okl_strm_type_tl_rec;

Line 4425: x_okl_strm_type_tl_rec := p_okl_strm_type_tl_rec;

4421: x_okl_strm_type_tl_rec OUT NOCOPY okl_strm_type_tl_rec_type
4422: ) RETURN VARCHAR2 IS
4423: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4424: BEGIN
4425: x_okl_strm_type_tl_rec := p_okl_strm_type_tl_rec;
4426: x_okl_strm_type_tl_rec.LANGUAGE := USERENV('LANG');
4427: RETURN(l_return_status);
4428: END Set_Attributes;
4429: BEGIN

Line 4426: x_okl_strm_type_tl_rec.LANGUAGE := USERENV('LANG');

4422: ) RETURN VARCHAR2 IS
4423: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4424: BEGIN
4425: x_okl_strm_type_tl_rec := p_okl_strm_type_tl_rec;
4426: x_okl_strm_type_tl_rec.LANGUAGE := USERENV('LANG');
4427: RETURN(l_return_status);
4428: END Set_Attributes;
4429: BEGIN
4430: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 4441: p_okl_strm_type_tl_rec, -- IN

4437: RAISE OKC_API.G_EXCEPTION_ERROR;
4438: END IF;
4439: --- Setting item attributes
4440: l_return_status := Set_Attributes(
4441: p_okl_strm_type_tl_rec, -- IN
4442: l_okl_strm_type_tl_rec); -- OUT
4443: --- If any errors happen abort API
4444: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4445: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 4442: l_okl_strm_type_tl_rec); -- OUT

4438: END IF;
4439: --- Setting item attributes
4440: l_return_status := Set_Attributes(
4441: p_okl_strm_type_tl_rec, -- IN
4442: l_okl_strm_type_tl_rec); -- OUT
4443: --- If any errors happen abort API
4444: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4445: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4446: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 4449: DELETE FROM OKL_STRM_TYPE_TL

4445: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4446: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4447: RAISE OKC_API.G_EXCEPTION_ERROR;
4448: END IF;
4449: DELETE FROM OKL_STRM_TYPE_TL
4450: WHERE ID = l_okl_strm_type_tl_rec.id;
4451:
4452: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
4453: EXCEPTION

Line 4450: WHERE ID = l_okl_strm_type_tl_rec.id;

4446: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4447: RAISE OKC_API.G_EXCEPTION_ERROR;
4448: END IF;
4449: DELETE FROM OKL_STRM_TYPE_TL
4450: WHERE ID = l_okl_strm_type_tl_rec.id;
4451:
4452: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
4453: EXCEPTION
4454: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 4500: l_okl_strm_type_tl_rec okl_strm_type_tl_rec_type;

4496: l_api_version CONSTANT NUMBER := 1;
4497: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
4498: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4499: l_styv_rec styv_rec_type := p_styv_rec;
4500: l_okl_strm_type_tl_rec okl_strm_type_tl_rec_type;
4501: l_sty_rec sty_rec_type;
4502: BEGIN
4503: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
4504: G_PKG_NAME,

Line 4518: migrate(l_styv_rec, l_okl_strm_type_tl_rec);

4514: END IF;
4515: --------------------------------------
4516: -- Move VIEW record to "Child" records
4517: --------------------------------------
4518: migrate(l_styv_rec, l_okl_strm_type_tl_rec);
4519: migrate(l_styv_rec, l_sty_rec);
4520: --------------------------------------------
4521: -- Call the DELETE_ROW for each child record
4522: --------------------------------------------

Line 4528: l_okl_strm_type_tl_rec

4524: p_init_msg_list,
4525: x_return_status,
4526: x_msg_count,
4527: x_msg_data,
4528: l_okl_strm_type_tl_rec
4529: );
4530: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4531: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4532: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 4682: FROM OKL_STRM_TYPE_TL

4678: f_ludate := nvl(to_date(p_last_update_date, 'YYYY/MM/DD'), sysdate);
4679:
4680: SELECT LAST_UPDATED_BY, LAST_UPDATE_DATE
4681: INTO db_luby, db_ludate
4682: FROM OKL_STRM_TYPE_TL
4683: where ID = to_number(p_styv_rec.id)
4684: and USERENV('LANG') =language;
4685:
4686: IF(fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 4688: UPDATE OKL_STRM_TYPE_TL

4684: and USERENV('LANG') =language;
4685:
4686: IF(fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
4687: db_ludate, '')) then
4688: UPDATE OKL_STRM_TYPE_TL
4689: SET
4690: ID = TO_NUMBER(p_styv_rec.id),
4691: DESCRIPTION = p_styv_rec.description,
4692: NAME = p_styv_rec.name,

Line 4776: UPDATE OKL_STRM_TYPE_TL

4772: CONTINGENCY_ID = p_styv_rec.contingency_id
4773: -- Added by SNANDIKO for Bug 6744584 End
4774: WHERE ID = to_number(p_styv_rec.ID);
4775: --Update TL
4776: UPDATE OKL_STRM_TYPE_TL
4777: SET
4778: ID = p_styv_rec.ID,
4779: NAME = p_styv_rec.NAME,
4780: DESCRIPTION = p_styv_rec.DESCRIPTION,

Line 4789: INSERT INTO OKL_STRM_TYPE_TL

4785: WHERE ID = TO_NUMBER(p_styv_rec.ID)
4786: AND USERENV('LANG') IN (language,source_lang);
4787:
4788: IF(sql%notfound) THEN
4789: INSERT INTO OKL_STRM_TYPE_TL
4790: ( ID,
4791: NAME,
4792: LANGUAGE,
4793: SOURCE_LANG,

Line 4817: from okl_strm_type_tl TL

4813: from FND_LANGUAGES L
4814: where L.INSTALLED_FLAG IN ('I','B')
4815: and not exists
4816: ( select NULL
4817: from okl_strm_type_tl TL
4818: where TL.ID = TO_NUMBER(p_styv_rec.ID)
4819: and TL.LANGUAGE = L.LANGUAGE_CODE );
4820:
4821: end if;

Line 4920: INSERT INTO OKL_STRM_TYPE_TL

4916: where not exists (select 1
4917: from okl_strm_type_b
4918: where ID = TO_NUMBER(p_styv_rec.ID));
4919:
4920: INSERT INTO OKL_STRM_TYPE_TL
4921: (
4922: ID,
4923: LANGUAGE,
4924: SOURCE_LANG,

Line 4950: FROM OKL_STRM_TYPE_TL TL

4946: FROM FND_LANGUAGES L
4947: WHERE L.INSTALLED_FLAG IN ('I','B')
4948: AND NOT EXISTS
4949: (SELECT NULL
4950: FROM OKL_STRM_TYPE_TL TL
4951: WHERE TL.ID = TO_NUMBER(p_styv_rec.ID)
4952: AND TL.LANGUAGE = L.LANGUAGE_CODE);
4953: END LOAD_ROW;
4954: