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_SUB_PVT dependencies on OKL_SUBSIDIES_TL

Line 121: DELETE FROM OKL_SUBSIDIES_TL T

117: -- PROCEDURE add_language
118: ---------------------------------------------------------------------------
119: PROCEDURE add_language IS
120: BEGIN
121: DELETE FROM OKL_SUBSIDIES_TL T
122: WHERE NOT EXISTS (
123: SELECT NULL
124: FROM OKL_SUBSIDIES_ALL_B B
125: WHERE B.ID =T.ID

Line 128: UPDATE OKL_SUBSIDIES_TL T SET(

124: FROM OKL_SUBSIDIES_ALL_B B
125: WHERE B.ID =T.ID
126: );
127:
128: UPDATE OKL_SUBSIDIES_TL T SET(
129: SHORT_DESCRIPTION,
130: DESCRIPTION) = (SELECT
131: B.SHORT_DESCRIPTION,
132: B.DESCRIPTION

Line 133: FROM OKL_SUBSIDIES_TL B

129: SHORT_DESCRIPTION,
130: DESCRIPTION) = (SELECT
131: B.SHORT_DESCRIPTION,
132: B.DESCRIPTION
133: FROM OKL_SUBSIDIES_TL B
134: WHERE B.ID = T.ID
135: AND B.LANGUAGE = T.SOURCE_LANG)
136: WHERE ( T.ID,
137: T.LANGUAGE)

Line 141: FROM OKL_SUBSIDIES_TL SUBB, OKL_SUBSIDIES_TL SUBT

137: T.LANGUAGE)
138: IN (SELECT
139: SUBT.ID,
140: SUBT.LANGUAGE
141: FROM OKL_SUBSIDIES_TL SUBB, OKL_SUBSIDIES_TL SUBT
142: WHERE SUBB.ID = SUBT.ID
143: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
144: AND (SUBB.SHORT_DESCRIPTION <> SUBT.SHORT_DESCRIPTION
145: OR SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 150: INSERT INTO OKL_SUBSIDIES_TL (

146: OR (SUBB.SHORT_DESCRIPTION IS NOT NULL AND SUBT.SHORT_DESCRIPTION IS NULL)
147: OR (SUBB.DESCRIPTION IS NULL AND SUBT.DESCRIPTION IS NOT NULL)
148: ));
149:
150: INSERT INTO OKL_SUBSIDIES_TL (
151: ID,
152: SHORT_DESCRIPTION,
153: DESCRIPTION,
154: LANGUAGE,

Line 174: FROM OKL_SUBSIDIES_TL B, FND_LANGUAGES L

170: B.CREATION_DATE,
171: B.LAST_UPDATED_BY,
172: B.LAST_UPDATE_DATE,
173: B.LAST_UPDATE_LOGIN
174: FROM OKL_SUBSIDIES_TL B, FND_LANGUAGES L
175: WHERE L.INSTALLED_FLAG IN ('I', 'B')
176: AND B.LANGUAGE = USERENV('LANG')
177: AND NOT EXISTS (
178: SELECT NULL

Line 179: FROM OKL_SUBSIDIES_TL T

175: WHERE L.INSTALLED_FLAG IN ('I', 'B')
176: AND B.LANGUAGE = USERENV('LANG')
177: AND NOT EXISTS (
178: SELECT NULL
179: FROM OKL_SUBSIDIES_TL T
180: WHERE T.ID = B.ID
181: AND T.LANGUAGE = L.LANGUAGE_CODE
182: );
183: END add_language;

Line 349: -- FUNCTION get_rec for: OKL_SUBSIDIES_TL

345: BEGIN
346: RETURN(get_rec(p_subv_rec, l_row_not_found));
347: END get_rec;
348: ---------------------------------------------------------------------------
349: -- FUNCTION get_rec for: OKL_SUBSIDIES_TL
350: ---------------------------------------------------------------------------
351: FUNCTION get_rec (
352: p_subt_rec IN subt_rec_type,
353: x_no_data_found OUT NOCOPY BOOLEAN

Line 355: CURSOR okl_subsidies_tl_pk_csr (p_id IN NUMBER,

351: FUNCTION get_rec (
352: p_subt_rec IN subt_rec_type,
353: x_no_data_found OUT NOCOPY BOOLEAN
354: ) RETURN subt_rec_type IS
355: CURSOR okl_subsidies_tl_pk_csr (p_id IN NUMBER,
356: p_language IN VARCHAR2) IS
357: SELECT
358: ID,
359: SHORT_DESCRIPTION,

Line 369: FROM Okl_Subsidies_Tl

365: CREATION_DATE,
366: LAST_UPDATED_BY,
367: LAST_UPDATE_DATE,
368: LAST_UPDATE_LOGIN
369: FROM Okl_Subsidies_Tl
370: WHERE okl_subsidies_tl.id = p_id
371: AND okl_subsidies_tl.language = p_language;
372: l_okl_subsidies_tl_pk okl_subsidies_tl_pk_csr%ROWTYPE;
373: l_subt_rec subt_rec_type;

Line 370: WHERE okl_subsidies_tl.id = p_id

366: LAST_UPDATED_BY,
367: LAST_UPDATE_DATE,
368: LAST_UPDATE_LOGIN
369: FROM Okl_Subsidies_Tl
370: WHERE okl_subsidies_tl.id = p_id
371: AND okl_subsidies_tl.language = p_language;
372: l_okl_subsidies_tl_pk okl_subsidies_tl_pk_csr%ROWTYPE;
373: l_subt_rec subt_rec_type;
374: BEGIN

Line 371: AND okl_subsidies_tl.language = p_language;

367: LAST_UPDATE_DATE,
368: LAST_UPDATE_LOGIN
369: FROM Okl_Subsidies_Tl
370: WHERE okl_subsidies_tl.id = p_id
371: AND okl_subsidies_tl.language = p_language;
372: l_okl_subsidies_tl_pk okl_subsidies_tl_pk_csr%ROWTYPE;
373: l_subt_rec subt_rec_type;
374: BEGIN
375: x_no_data_found := TRUE;

Line 372: l_okl_subsidies_tl_pk okl_subsidies_tl_pk_csr%ROWTYPE;

368: LAST_UPDATE_LOGIN
369: FROM Okl_Subsidies_Tl
370: WHERE okl_subsidies_tl.id = p_id
371: AND okl_subsidies_tl.language = p_language;
372: l_okl_subsidies_tl_pk okl_subsidies_tl_pk_csr%ROWTYPE;
373: l_subt_rec subt_rec_type;
374: BEGIN
375: x_no_data_found := TRUE;
376: -- Get current database values

Line 377: OPEN okl_subsidies_tl_pk_csr (p_subt_rec.id,

373: l_subt_rec subt_rec_type;
374: BEGIN
375: x_no_data_found := TRUE;
376: -- Get current database values
377: OPEN okl_subsidies_tl_pk_csr (p_subt_rec.id,
378: p_subt_rec.language);
379: FETCH okl_subsidies_tl_pk_csr INTO
380: l_subt_rec.id,
381: l_subt_rec.short_description,

Line 379: FETCH okl_subsidies_tl_pk_csr INTO

375: x_no_data_found := TRUE;
376: -- Get current database values
377: OPEN okl_subsidies_tl_pk_csr (p_subt_rec.id,
378: p_subt_rec.language);
379: FETCH okl_subsidies_tl_pk_csr INTO
380: l_subt_rec.id,
381: l_subt_rec.short_description,
382: l_subt_rec.description,
383: l_subt_rec.language,

Line 391: x_no_data_found := okl_subsidies_tl_pk_csr%NOTFOUND;

387: l_subt_rec.creation_date,
388: l_subt_rec.last_updated_by,
389: l_subt_rec.last_update_date,
390: l_subt_rec.last_update_login;
391: x_no_data_found := okl_subsidies_tl_pk_csr%NOTFOUND;
392: CLOSE okl_subsidies_tl_pk_csr;
393: RETURN(l_subt_rec);
394: END get_rec;
395:

Line 392: CLOSE okl_subsidies_tl_pk_csr;

388: l_subt_rec.last_updated_by,
389: l_subt_rec.last_update_date,
390: l_subt_rec.last_update_login;
391: x_no_data_found := okl_subsidies_tl_pk_csr%NOTFOUND;
392: CLOSE okl_subsidies_tl_pk_csr;
393: RETURN(l_subt_rec);
394: END get_rec;
395:
396: ------------------------------------------------------------------

Line 3049: -- insert_row for:OKL_SUBSIDIES_TL --

3045: '_PVT'
3046: );
3047: END insert_row;
3048: -------------------------------------
3049: -- insert_row for:OKL_SUBSIDIES_TL --
3050: -------------------------------------
3051: PROCEDURE insert_row(
3052: p_init_msg_list IN VARCHAR2,
3053: x_return_status OUT NOCOPY VARCHAR2,

Line 3069: -- Set_Attributes for:OKL_SUBSIDIES_TL --

3065: SELECT *
3066: FROM FND_LANGUAGES
3067: WHERE INSTALLED_FLAG IN ('I', 'B');
3068: -----------------------------------------
3069: -- Set_Attributes for:OKL_SUBSIDIES_TL --
3070: -----------------------------------------
3071: FUNCTION Set_Attributes (
3072: p_subt_rec IN subt_rec_type,
3073: x_subt_rec OUT NOCOPY subt_rec_type

Line 3104: INSERT INTO OKL_SUBSIDIES_TL(

3100: RAISE OKL_API.G_EXCEPTION_ERROR;
3101: END IF;
3102: FOR l_lang_rec IN get_languages LOOP
3103: l_subt_rec.language := l_lang_rec.language_code;
3104: INSERT INTO OKL_SUBSIDIES_TL(
3105: id,
3106: short_description,
3107: description,
3108: language,

Line 3603: -- lock_row for:OKL_SUBSIDIES_TL --

3599: '_PVT'
3600: );
3601: END lock_row;
3602: -----------------------------------
3603: -- lock_row for:OKL_SUBSIDIES_TL --
3604: -----------------------------------
3605: PROCEDURE lock_row(
3606: p_init_msg_list IN VARCHAR2,
3607: x_return_status OUT NOCOPY VARCHAR2,

Line 3616: FROM OKL_SUBSIDIES_TL

3612: E_Resource_Busy EXCEPTION;
3613: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
3614: CURSOR lock_csr (p_subt_rec IN subt_rec_type) IS
3615: SELECT *
3616: FROM OKL_SUBSIDIES_TL
3617: WHERE ID = p_subt_rec.id
3618: FOR UPDATE NOWAIT;
3619:
3620: l_api_version CONSTANT NUMBER := 1;

Line 4305: -- update_row for:OKL_SUBSIDIES_TL --

4301: '_PVT'
4302: );
4303: END update_row;
4304: -------------------------------------
4305: -- update_row for:OKL_SUBSIDIES_TL --
4306: -------------------------------------
4307: PROCEDURE update_row(
4308: p_init_msg_list IN VARCHAR2,
4309: x_return_status OUT NOCOPY VARCHAR2,

Line 4384: -- Set_Attributes for:OKL_SUBSIDIES_TL --

4380: END IF;
4381: RETURN(l_return_status);
4382: END populate_new_record;
4383: -----------------------------------------
4384: -- Set_Attributes for:OKL_SUBSIDIES_TL --
4385: -----------------------------------------
4386: FUNCTION Set_Attributes (
4387: p_subt_rec IN subt_rec_type,
4388: x_subt_rec OUT NOCOPY subt_rec_type

Line 4423: UPDATE OKL_SUBSIDIES_TL

4419: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4420: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
4421: RAISE OKL_API.G_EXCEPTION_ERROR;
4422: END IF;
4423: UPDATE OKL_SUBSIDIES_TL
4424: SET SHORT_DESCRIPTION = l_def_subt_rec.short_description,
4425: DESCRIPTION = l_def_subt_rec.description,
4426: --Bug# 3641933 :
4427: SOURCE_LANG = l_def_subt_rec.source_lang,

Line 4438: UPDATE OKL_SUBSIDIES_TL

4434: --Bug# 3641933 :
4435: AND USERENV('LANG') in (SOURCE_LANG,LANGUAGE);
4436: --AND SOURCE_LANG = USERENV('LANG');
4437:
4438: UPDATE OKL_SUBSIDIES_TL
4439: SET SFWT_FLAG = 'Y'
4440: WHERE ID = l_def_subt_rec.id
4441: AND SOURCE_LANG <> USERENV('LANG');
4442:

Line 5113: -- delete_row for:OKL_SUBSIDIES_TL --

5109: '_PVT'
5110: );
5111: END delete_row;
5112: -------------------------------------
5113: -- delete_row for:OKL_SUBSIDIES_TL --
5114: -------------------------------------
5115: PROCEDURE delete_row(
5116: p_init_msg_list IN VARCHAR2,
5117: x_return_status OUT NOCOPY VARCHAR2,

Line 5138: DELETE FROM OKL_SUBSIDIES_TL

5134: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
5135: RAISE OKL_API.G_EXCEPTION_ERROR;
5136: END IF;
5137:
5138: DELETE FROM OKL_SUBSIDIES_TL
5139: WHERE ID = p_subt_rec.id;
5140:
5141: x_return_status := l_return_status;
5142: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);