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_RCS_PVT dependencies on OKL_FE_RESI_CAT_ALL_TL

Line 29: DELETE FROM OKL_FE_RESI_CAT_ALL_TL t

25: PROCEDURE add_language IS
26:
27: BEGIN
28:
29: DELETE FROM OKL_FE_RESI_CAT_ALL_TL t
30: WHERE NOT EXISTS(SELECT NULL
31: FROM OKL_FE_RESI_CAT_ALL_B b
32: WHERE b.RESI_CATEGORY_SET_ID = t.RESI_CATEGORY_SET_ID);
33:

Line 34: UPDATE OKL_FE_RESI_CAT_ALL_TL t

30: WHERE NOT EXISTS(SELECT NULL
31: FROM OKL_FE_RESI_CAT_ALL_B b
32: WHERE b.RESI_CATEGORY_SET_ID = t.RESI_CATEGORY_SET_ID);
33:
34: UPDATE OKL_FE_RESI_CAT_ALL_TL t
35: SET(RESI_CAT_DESC) = (SELECT
36: -- LANGUAGE,
37:
38: -- B.LANGUAGE,

Line 41: FROM OKL_FE_RESI_CAT_ALL_TL b

37:
38: -- B.LANGUAGE,
39:
40: b.RESI_CAT_DESC
41: FROM OKL_FE_RESI_CAT_ALL_TL b
42: WHERE b.RESI_CATEGORY_SET_ID = t.RESI_CATEGORY_SET_ID
43: AND b.language = t.source_lang)
44: WHERE (t.RESI_CATEGORY_SET_ID, t.language) IN(SELECT subt.RESI_CATEGORY_SET_ID ,subt.language
45: FROM OKL_FE_RESI_CAT_ALL_TL subb ,OKL_FE_RESI_CAT_ALL_TL subt

Line 45: FROM OKL_FE_RESI_CAT_ALL_TL subb ,OKL_FE_RESI_CAT_ALL_TL subt

41: FROM OKL_FE_RESI_CAT_ALL_TL b
42: WHERE b.RESI_CATEGORY_SET_ID = t.RESI_CATEGORY_SET_ID
43: AND b.language = t.source_lang)
44: WHERE (t.RESI_CATEGORY_SET_ID, t.language) IN(SELECT subt.RESI_CATEGORY_SET_ID ,subt.language
45: FROM OKL_FE_RESI_CAT_ALL_TL subb ,OKL_FE_RESI_CAT_ALL_TL subt
46: WHERE subb.RESI_CATEGORY_SET_ID = subt.RESI_CATEGORY_SET_ID AND subb.language = subt.language AND ( -- SUBB.LANGUAGE <> SUBT.LANGUAGE OR
47: subb.RESI_CAT_DESC <> subt.RESI_CAT_DESC OR (subb.language IS NOT NULL
48: AND subt.language IS NULL)
49: OR (subb.RESI_CAT_DESC IS NULL AND subt.RESI_CAT_DESC IS NOT NULL)));

Line 51: INSERT INTO OKL_FE_RESI_CAT_ALL_TL

47: subb.RESI_CAT_DESC <> subt.RESI_CAT_DESC OR (subb.language IS NOT NULL
48: AND subt.language IS NULL)
49: OR (subb.RESI_CAT_DESC IS NULL AND subt.RESI_CAT_DESC IS NOT NULL)));
50:
51: INSERT INTO OKL_FE_RESI_CAT_ALL_TL
52: (RESI_CATEGORY_SET_ID
53: ,language
54: ,source_lang
55: ,sfwt_flag

Line 62: FROM OKL_FE_RESI_CAT_ALL_TL b

58: ,l.language_code
59: ,b.source_lang
60: ,b.sfwt_flag
61: ,b.RESI_CAT_DESC
62: FROM OKL_FE_RESI_CAT_ALL_TL b
63: ,fnd_languages l
64: WHERE l.installed_flag IN('I', 'B')
65: AND b.language = userenv('LANG')
66: AND NOT EXISTS(SELECT NULL

Line 67: FROM OKL_FE_RESI_CAT_ALL_TL t

63: ,fnd_languages l
64: WHERE l.installed_flag IN('I', 'B')
65: AND b.language = userenv('LANG')
66: AND NOT EXISTS(SELECT NULL
67: FROM OKL_FE_RESI_CAT_ALL_TL t
68: WHERE t.RESI_CATEGORY_SET_ID = b.RESI_CATEGORY_SET_ID AND t.language = l.language_code);
69:
70: END add_language;
71:

Line 127: -- Procedure get_rec for OKL_FE_RESI_CAT_ALL_TL

123: RETURN(get_rec(p_rcsb_rec,l_row_notfound));
124: END get_rec;
125:
126: --------------------------------------------------------------------------------
127: -- Procedure get_rec for OKL_FE_RESI_CAT_ALL_TL
128: --------------------------------------------------------------------------------
129:
130: FUNCTION get_rec(
131: p_rcstl_rec IN okl_rcstl_rec,

Line 146: FROM OKL_FE_RESI_CAT_ALL_TL WHERE OKL_FE_RESI_CAT_ALL_TL.resi_category_set_id=p_id AND OKL_FE_RESI_CAT_ALL_TL.language=p_language;

142: LAST_UPDATED_BY,
143: LAST_UPDATE_DATE,
144: LAST_UPDATE_LOGIN,
145: RESI_CAT_DESC
146: FROM OKL_FE_RESI_CAT_ALL_TL WHERE OKL_FE_RESI_CAT_ALL_TL.resi_category_set_id=p_id AND OKL_FE_RESI_CAT_ALL_TL.language=p_language;
147: l_rcstl_pk rcstl_pk_csr%ROWTYPE;
148: l_rcstl_rec okl_rcstl_rec;
149: BEGIN
150: x_no_data_found:= TRUE;

Line 935: INSERT INTO OKL_FE_RESI_CAT_ALL_TL(

931: FOR l_lang_rec IN get_languages LOOP
932: l_rcstl_rec.language := l_lang_rec.language_code;
933:
934:
935: INSERT INTO OKL_FE_RESI_CAT_ALL_TL(
936: RESI_CATEGORY_SET_ID,
937: LANGUAGE,
938: SOURCE_LANG,
939: SFWT_FLAG,

Line 1379: FROM OKL_FE_RESI_CAT_ALL_TL

1375: E_Resource_Busy EXCEPTION;
1376: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1377: CURSOR lock_csr (p_rcstl_rec IN okl_rcstl_rec) IS
1378: SELECT *
1379: FROM OKL_FE_RESI_CAT_ALL_TL
1380: WHERE RESI_CATEGORY_SET_ID = p_rcstl_rec.RESI_CATEGORY_SET_ID
1381: FOR UPDATE NOWAIT;
1382:
1383: l_api_version CONSTANT NUMBER := 1;

Line 1813: UPDATE OKL_FE_RESI_CAT_ALL_TL

1809: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1810: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1811: RAISE OKL_API.G_EXCEPTION_ERROR;
1812: END IF;
1813: UPDATE OKL_FE_RESI_CAT_ALL_TL
1814: SET
1815: RESI_CATEGORY_SET_ID= l_def_rcstl_rec.RESI_CATEGORY_SET_ID,
1816: SOURCE_LANG= l_def_rcstl_rec.SOURCE_LANG,
1817: SFWT_FLAG= l_def_rcstl_rec.SFWT_FLAG,

Line 1827: UPDATE OKL_FE_RESI_CAT_ALL_TL

1823: RESI_CAT_DESC= l_def_rcstl_rec.RESI_CAT_DESC
1824: WHERE
1825: RESI_CATEGORY_SET_ID = l_def_rcstl_rec.resi_category_set_id;
1826:
1827: UPDATE OKL_FE_RESI_CAT_ALL_TL
1828: SET SFWT_FLAG='Y' WHERE RESI_CATEGORY_SET_ID =l_def_rcstl_rec.resi_category_set_id
1829: AND SOURCE_LANG<>USERENV('LANG');
1830: --Set OUT Values
1831: x_rcstl_rec:=l_rcstl_rec;

Line 2318: DELETE FROM OKL_FE_RESI_CAT_ALL_TL

2314: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2315: RAISE OKL_API.G_EXCEPTION_ERROR;
2316: END IF;
2317:
2318: DELETE FROM OKL_FE_RESI_CAT_ALL_TL
2319: WHERE RESI_CATEGORY_SET_ID=l_rcstl_rec.resi_category_set_id;
2320:
2321: EXCEPTION
2322: WHEN G_EXCEPTION_HALT_VALIDATION then