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 72: FROM OKL_FE_RESI_CAT_ALL_TL b

68: ,b.CREATION_DATE
69: ,b.LAST_UPDATED_BY
70: ,b.LAST_UPDATE_DATE
71: ,b.LAST_UPDATE_LOGIN
72: FROM OKL_FE_RESI_CAT_ALL_TL b
73: ,fnd_languages l
74: WHERE l.installed_flag IN('I', 'B')
75: AND b.language = userenv('LANG')
76: AND NOT EXISTS(SELECT NULL

Line 77: FROM OKL_FE_RESI_CAT_ALL_TL t

73: ,fnd_languages l
74: WHERE l.installed_flag IN('I', 'B')
75: AND b.language = userenv('LANG')
76: AND NOT EXISTS(SELECT NULL
77: FROM OKL_FE_RESI_CAT_ALL_TL t
78: WHERE t.RESI_CATEGORY_SET_ID = b.RESI_CATEGORY_SET_ID AND t.language = l.language_code);
79:
80: END add_language;
81:

Line 137: -- Procedure get_rec for OKL_FE_RESI_CAT_ALL_TL

133: RETURN(get_rec(p_rcsb_rec,l_row_notfound));
134: END get_rec;
135:
136: --------------------------------------------------------------------------------
137: -- Procedure get_rec for OKL_FE_RESI_CAT_ALL_TL
138: --------------------------------------------------------------------------------
139:
140: FUNCTION get_rec(
141: p_rcstl_rec IN okl_rcstl_rec,

Line 156: 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;

152: LAST_UPDATED_BY,
153: LAST_UPDATE_DATE,
154: LAST_UPDATE_LOGIN,
155: RESI_CAT_DESC
156: 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;
157: l_rcstl_pk rcstl_pk_csr%ROWTYPE;
158: l_rcstl_rec okl_rcstl_rec;
159: BEGIN
160: x_no_data_found:= TRUE;

Line 945: INSERT INTO OKL_FE_RESI_CAT_ALL_TL(

941: FOR l_lang_rec IN get_languages LOOP
942: l_rcstl_rec.language := l_lang_rec.language_code;
943:
944:
945: INSERT INTO OKL_FE_RESI_CAT_ALL_TL(
946: RESI_CATEGORY_SET_ID,
947: LANGUAGE,
948: SOURCE_LANG,
949: SFWT_FLAG,

Line 1389: FROM OKL_FE_RESI_CAT_ALL_TL

1385: E_Resource_Busy EXCEPTION;
1386: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1387: CURSOR lock_csr (p_rcstl_rec IN okl_rcstl_rec) IS
1388: SELECT *
1389: FROM OKL_FE_RESI_CAT_ALL_TL
1390: WHERE RESI_CATEGORY_SET_ID = p_rcstl_rec.RESI_CATEGORY_SET_ID
1391: FOR UPDATE NOWAIT;
1392:
1393: l_api_version CONSTANT NUMBER := 1;

Line 1823: UPDATE OKL_FE_RESI_CAT_ALL_TL

1819: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1820: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1821: RAISE OKL_API.G_EXCEPTION_ERROR;
1822: END IF;
1823: UPDATE OKL_FE_RESI_CAT_ALL_TL
1824: SET
1825: RESI_CATEGORY_SET_ID= l_def_rcstl_rec.RESI_CATEGORY_SET_ID,
1826: SOURCE_LANG= l_def_rcstl_rec.SOURCE_LANG,
1827: SFWT_FLAG= l_def_rcstl_rec.SFWT_FLAG,

Line 1837: UPDATE OKL_FE_RESI_CAT_ALL_TL

1833: RESI_CAT_DESC= l_def_rcstl_rec.RESI_CAT_DESC
1834: WHERE
1835: RESI_CATEGORY_SET_ID = l_def_rcstl_rec.resi_category_set_id;
1836:
1837: UPDATE OKL_FE_RESI_CAT_ALL_TL
1838: SET SFWT_FLAG='Y' WHERE RESI_CATEGORY_SET_ID =l_def_rcstl_rec.resi_category_set_id
1839: AND SOURCE_LANG<>USERENV('LANG');
1840: --Set OUT Values
1841: x_rcstl_rec:=l_rcstl_rec;

Line 2328: DELETE FROM OKL_FE_RESI_CAT_ALL_TL

2324: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2325: RAISE OKL_API.G_EXCEPTION_ERROR;
2326: END IF;
2327:
2328: DELETE FROM OKL_FE_RESI_CAT_ALL_TL
2329: WHERE RESI_CATEGORY_SET_ID=l_rcstl_rec.resi_category_set_id;
2330:
2331: EXCEPTION
2332: WHEN G_EXCEPTION_HALT_VALIDATION then