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_FWT_PVT dependencies on OKL_FRENCH_TAX_TL

Line 98: DELETE FROM OKL_FRENCH_TAX_TL T

94: -- PROCEDURE add_language
95: ---------------------------------------------------------------------------
96: PROCEDURE add_language IS
97: BEGIN
98: DELETE FROM OKL_FRENCH_TAX_TL T
99: WHERE NOT EXISTS (
100: SELECT NULL
101: FROM OKL_FRENCH_TAX_B B
102: WHERE B.ID =T.ID

Line 105: UPDATE OKL_FRENCH_TAX_TL T SET(

101: FROM OKL_FRENCH_TAX_B B
102: WHERE B.ID =T.ID
103: );
104:
105: UPDATE OKL_FRENCH_TAX_TL T SET(
106: NAME,
107: DESCRIPTION) = (SELECT
108: B.NAME,
109: B.DESCRIPTION

Line 110: FROM OKL_FRENCH_TAX_TL B

106: NAME,
107: DESCRIPTION) = (SELECT
108: B.NAME,
109: B.DESCRIPTION
110: FROM OKL_FRENCH_TAX_TL B
111: WHERE B.ID = T.ID
112: AND B.LANGUAGE = T.SOURCE_LANG)
113: WHERE ( T.ID,
114: T.LANGUAGE)

Line 118: FROM OKL_FRENCH_TAX_TL SUBB, OKL_FRENCH_TAX_TL SUBT

114: T.LANGUAGE)
115: IN (SELECT
116: SUBT.ID,
117: SUBT.LANGUAGE
118: FROM OKL_FRENCH_TAX_TL SUBB, OKL_FRENCH_TAX_TL SUBT
119: WHERE SUBB.ID = SUBT.ID
120: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
121: AND (SUBB.NAME <> SUBT.NAME
122: OR SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 127: INSERT INTO OKL_FRENCH_TAX_TL (

123: OR (SUBB.NAME IS NULL AND SUBT.NAME IS NOT NULL)
124: OR (SUBB.DESCRIPTION IS NULL AND SUBT.DESCRIPTION IS NOT NULL)
125: ));
126:
127: INSERT INTO OKL_FRENCH_TAX_TL (
128: ID,
129: LANGUAGE,
130: SOURCE_LANG,
131: SFWT_FLAG,

Line 151: FROM OKL_FRENCH_TAX_TL B, FND_LANGUAGES L

147: B.CREATION_DATE,
148: B.LAST_UPDATED_BY,
149: B.LAST_UPDATE_DATE,
150: B.LAST_UPDATE_LOGIN
151: FROM OKL_FRENCH_TAX_TL B, FND_LANGUAGES L
152: WHERE L.INSTALLED_FLAG IN ('I', 'B')
153: AND B.LANGUAGE = USERENV('LANG')
154: AND NOT EXISTS (
155: SELECT NULL

Line 156: FROM OKL_FRENCH_TAX_TL T

152: WHERE L.INSTALLED_FLAG IN ('I', 'B')
153: AND B.LANGUAGE = USERENV('LANG')
154: AND NOT EXISTS (
155: SELECT NULL
156: FROM OKL_FRENCH_TAX_TL T
157: WHERE T.ID = B.ID
158: AND T.LANGUAGE = L.LANGUAGE_CODE
159: );
160: END add_language;

Line 274: -- FUNCTION get_rec for: OKL_FRENCH_TAX_TL

270: BEGIN
271: RETURN(get_rec(p_fwtv_rec, l_row_not_found));
272: END get_rec;
273: ---------------------------------------------------------------------------
274: -- FUNCTION get_rec for: OKL_FRENCH_TAX_TL
275: ---------------------------------------------------------------------------
276: FUNCTION get_rec (
277: p_fwtt_rec IN fwtt_rec_type,
278: x_no_data_found OUT NOCOPY BOOLEAN

Line 280: CURSOR okl_french_tax_tl_pk_csr (p_id IN NUMBER,

276: FUNCTION get_rec (
277: p_fwtt_rec IN fwtt_rec_type,
278: x_no_data_found OUT NOCOPY BOOLEAN
279: ) RETURN fwtt_rec_type IS
280: CURSOR okl_french_tax_tl_pk_csr (p_id IN NUMBER,
281: p_language IN VARCHAR2) IS
282: SELECT
283: ID,
284: LANGUAGE,

Line 294: FROM Okl_French_Tax_Tl

290: CREATION_DATE,
291: LAST_UPDATED_BY,
292: LAST_UPDATE_DATE,
293: LAST_UPDATE_LOGIN
294: FROM Okl_French_Tax_Tl
295: WHERE okl_french_tax_tl.id = p_id
296: AND okl_french_tax_tl.language = p_language;
297: l_okl_french_tax_tl_pk okl_french_tax_tl_pk_csr%ROWTYPE;
298: l_fwtt_rec fwtt_rec_type;

Line 295: WHERE okl_french_tax_tl.id = p_id

291: LAST_UPDATED_BY,
292: LAST_UPDATE_DATE,
293: LAST_UPDATE_LOGIN
294: FROM Okl_French_Tax_Tl
295: WHERE okl_french_tax_tl.id = p_id
296: AND okl_french_tax_tl.language = p_language;
297: l_okl_french_tax_tl_pk okl_french_tax_tl_pk_csr%ROWTYPE;
298: l_fwtt_rec fwtt_rec_type;
299: BEGIN

Line 296: AND okl_french_tax_tl.language = p_language;

292: LAST_UPDATE_DATE,
293: LAST_UPDATE_LOGIN
294: FROM Okl_French_Tax_Tl
295: WHERE okl_french_tax_tl.id = p_id
296: AND okl_french_tax_tl.language = p_language;
297: l_okl_french_tax_tl_pk okl_french_tax_tl_pk_csr%ROWTYPE;
298: l_fwtt_rec fwtt_rec_type;
299: BEGIN
300: x_no_data_found := TRUE;

Line 297: l_okl_french_tax_tl_pk okl_french_tax_tl_pk_csr%ROWTYPE;

293: LAST_UPDATE_LOGIN
294: FROM Okl_French_Tax_Tl
295: WHERE okl_french_tax_tl.id = p_id
296: AND okl_french_tax_tl.language = p_language;
297: l_okl_french_tax_tl_pk okl_french_tax_tl_pk_csr%ROWTYPE;
298: l_fwtt_rec fwtt_rec_type;
299: BEGIN
300: x_no_data_found := TRUE;
301: -- Get current database values

Line 302: OPEN okl_french_tax_tl_pk_csr (p_fwtt_rec.id,

298: l_fwtt_rec fwtt_rec_type;
299: BEGIN
300: x_no_data_found := TRUE;
301: -- Get current database values
302: OPEN okl_french_tax_tl_pk_csr (p_fwtt_rec.id,
303: p_fwtt_rec.language);
304: FETCH okl_french_tax_tl_pk_csr INTO
305: l_fwtt_rec.id,
306: l_fwtt_rec.language,

Line 304: FETCH okl_french_tax_tl_pk_csr INTO

300: x_no_data_found := TRUE;
301: -- Get current database values
302: OPEN okl_french_tax_tl_pk_csr (p_fwtt_rec.id,
303: p_fwtt_rec.language);
304: FETCH okl_french_tax_tl_pk_csr INTO
305: l_fwtt_rec.id,
306: l_fwtt_rec.language,
307: l_fwtt_rec.source_lang,
308: l_fwtt_rec.sfwt_flag,

Line 316: x_no_data_found := okl_french_tax_tl_pk_csr%NOTFOUND;

312: l_fwtt_rec.creation_date,
313: l_fwtt_rec.last_updated_by,
314: l_fwtt_rec.last_update_date,
315: l_fwtt_rec.last_update_login;
316: x_no_data_found := okl_french_tax_tl_pk_csr%NOTFOUND;
317: CLOSE okl_french_tax_tl_pk_csr;
318: RETURN(l_fwtt_rec);
319: END get_rec;
320:

Line 317: CLOSE okl_french_tax_tl_pk_csr;

313: l_fwtt_rec.last_updated_by,
314: l_fwtt_rec.last_update_date,
315: l_fwtt_rec.last_update_login;
316: x_no_data_found := okl_french_tax_tl_pk_csr%NOTFOUND;
317: CLOSE okl_french_tax_tl_pk_csr;
318: RETURN(l_fwtt_rec);
319: END get_rec;
320:
321: ------------------------------------------------------------------

Line 1370: -- insert_row for:OKL_FRENCH_TAX_TL --

1366: '_PVT'
1367: );
1368: END insert_row;
1369: --------------------------------------
1370: -- insert_row for:OKL_FRENCH_TAX_TL --
1371: --------------------------------------
1372: PROCEDURE insert_row(
1373: p_init_msg_list IN VARCHAR2 ,
1374: x_return_status OUT NOCOPY VARCHAR2,

Line 1390: -- Set_Attributes for:OKL_FRENCH_TAX_TL --

1386: SELECT *
1387: FROM FND_LANGUAGES
1388: WHERE INSTALLED_FLAG IN ('I', 'B');
1389: ------------------------------------------
1390: -- Set_Attributes for:OKL_FRENCH_TAX_TL --
1391: ------------------------------------------
1392: FUNCTION Set_Attributes (
1393: p_fwtt_rec IN fwtt_rec_type,
1394: x_fwtt_rec OUT NOCOPY fwtt_rec_type

Line 1425: INSERT INTO OKL_FRENCH_TAX_TL(

1421: RAISE OKL_API.G_EXCEPTION_ERROR;
1422: END IF;
1423: FOR l_lang_rec IN get_languages LOOP
1424: l_fwtt_rec.language := l_lang_rec.language_code;
1425: INSERT INTO OKL_FRENCH_TAX_TL(
1426: id,
1427: language,
1428: source_lang,
1429: sfwt_flag,

Line 1922: -- lock_row for:OKL_FRENCH_TAX_TL --

1918: '_PVT'
1919: );
1920: END lock_row;
1921: ------------------------------------
1922: -- lock_row for:OKL_FRENCH_TAX_TL --
1923: ------------------------------------
1924: PROCEDURE lock_row(
1925: p_init_msg_list IN VARCHAR2 ,
1926: x_return_status OUT NOCOPY VARCHAR2,

Line 1935: FROM OKL_FRENCH_TAX_TL

1931: E_Resource_Busy EXCEPTION;
1932: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1933: CURSOR lock_csr (p_fwtt_rec IN fwtt_rec_type) IS
1934: SELECT *
1935: FROM OKL_FRENCH_TAX_TL
1936: WHERE ID = p_fwtt_rec.id
1937: FOR UPDATE NOWAIT;
1938:
1939: l_api_version CONSTANT NUMBER := 1;

Line 2508: -- update_row for:OKL_FRENCH_TAX_TL --

2504: '_PVT'
2505: );
2506: END update_row;
2507: --------------------------------------
2508: -- update_row for:OKL_FRENCH_TAX_TL --
2509: --------------------------------------
2510: PROCEDURE update_row(
2511: p_init_msg_list IN VARCHAR2 ,
2512: x_return_status OUT NOCOPY VARCHAR2,

Line 2587: -- Set_Attributes for:OKL_FRENCH_TAX_TL --

2583: END IF;
2584: RETURN(l_return_status);
2585: END populate_new_record;
2586: ------------------------------------------
2587: -- Set_Attributes for:OKL_FRENCH_TAX_TL --
2588: ------------------------------------------
2589: FUNCTION Set_Attributes (
2590: p_fwtt_rec IN fwtt_rec_type,
2591: x_fwtt_rec OUT NOCOPY fwtt_rec_type

Line 2626: UPDATE OKL_FRENCH_TAX_TL

2622: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2623: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2624: RAISE OKL_API.G_EXCEPTION_ERROR;
2625: END IF;
2626: UPDATE OKL_FRENCH_TAX_TL
2627: SET NAME = l_def_fwtt_rec.name,
2628: DESCRIPTION = l_def_fwtt_rec.description,
2629: --Bug# 3641933 :
2630: SOURCE_LANG = l_def_fwtt_rec.source_lang,

Line 2641: UPDATE OKL_FRENCH_TAX_TL

2637: --Bug# 3641933 :
2638: AND USERENV('LANG') in (SOURCE_LANG,LANGUAGE);
2639: --AND SOURCE_LANG = USERENV('LANG');
2640:
2641: UPDATE OKL_FRENCH_TAX_TL
2642: SET SFWT_FLAG = 'Y'
2643: WHERE ID = l_def_fwtt_rec.id
2644: AND SOURCE_LANG <> USERENV('LANG');
2645:

Line 3223: -- delete_row for:OKL_FRENCH_TAX_TL --

3219: '_PVT'
3220: );
3221: END delete_row;
3222: --------------------------------------
3223: -- delete_row for:OKL_FRENCH_TAX_TL --
3224: --------------------------------------
3225: PROCEDURE delete_row(
3226: p_init_msg_list IN VARCHAR2 ,
3227: x_return_status OUT NOCOPY VARCHAR2,

Line 3248: DELETE FROM OKL_FRENCH_TAX_TL

3244: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3245: RAISE OKL_API.G_EXCEPTION_ERROR;
3246: END IF;
3247:
3248: DELETE FROM OKL_FRENCH_TAX_TL
3249: WHERE ID = p_fwtt_rec.id;
3250:
3251: x_return_status := l_return_status;
3252: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);