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.JTF_SEEDED_QUAL_PKG dependencies on JTF_SEEDED_QUAL_ALL_TL

Line 56: insert into JTF_SEEDED_QUAL_ALL_TL (

52: decode( x_NAME, FND_API.G_MISS_CHAR, NULL,x_NAME),
53: decode( x_DESCRIPTION, FND_API.G_MISS_CHAR, NULL,x_DESCRIPTION),
54: decode( x_ORG_ID, FND_API.G_MISS_NUM, NULL, x_ORG_ID) );
55:
56: insert into JTF_SEEDED_QUAL_ALL_TL (
57: SEEDED_QUAL_ID,
58: NAME,
59: DESCRIPTION,
60: LAST_UPDATE_DATE,

Line 84: from JTF_SEEDED_QUAL_ALL_TL T

80: from FND_LANGUAGES L
81: where L.INSTALLED_FLAG in ('I', 'B')
82: and not exists
83: (select NULL
84: from JTF_SEEDED_QUAL_ALL_TL T
85: where T.SEEDED_QUAL_ID = X_SEEDED_QUAL_ID and
86: T.LANGUAGE = L.language_code and
87: NVL(T.ORG_ID, -99) = NVL(X_ORG_ID, -99) /* 1331579 BUG FIX */ );
88:

Line 102: DELETE from JTF_SEEDED_QUAL_ALL_TL

98:
99: PROCEDURE Delete_Row( x_SEEDED_QUAL_ID IN NUMBER
100: ) IS
101: BEGIN
102: DELETE from JTF_SEEDED_QUAL_ALL_TL
103: where SEEDED_QUAL_ID = X_SEEDED_QUAL_ID;
104:
105: if (sql%notfound) then
106: raise no_data_found;

Line 148: update JTF_SEEDED_QUAL_ALL_TL set

144: If (SQL%NOTFOUND) then
145: RAISE NO_DATA_FOUND;
146: End If;
147:
148: update JTF_SEEDED_QUAL_ALL_TL set
149: NAME = X_NAME,
150: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
151: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
152: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 187: from JTF_SEEDED_QUAL_ALL_TL

183:
184: CURSOR c1 is select
185: NAME,
186: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
187: from JTF_SEEDED_QUAL_ALL_TL
188: where SEEDED_QUAL_ID = X_SEEDED_QUAL_ID
189: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
190: for update of SEEDED_QUAL_ID nowait;
191: BEGIN

Line 253: delete from JTF_SEEDED_QUAL_ALL_TL T

249:
250: procedure ADD_LANGUAGE
251: is
252: begin
253: delete from JTF_SEEDED_QUAL_ALL_TL T
254: where not exists
255: (select NULL
256: from JTF_SEEDED_QUAL_ALL_B B
257: where B.SEEDED_QUAL_ID = T.SEEDED_QUAL_ID

Line 261: update JTF_SEEDED_QUAL_ALL_TL T set (

257: where B.SEEDED_QUAL_ID = T.SEEDED_QUAL_ID
258: and NVL(B.ORG_ID,-99) = NVL(T.ORG_ID,-99) /* 1331579 BUG FIX */
259: );
260:
261: update JTF_SEEDED_QUAL_ALL_TL T set (
262: NAME,
263: DESCRIPTION
264: ) = (select
265: B.NAME,

Line 267: from JTF_SEEDED_QUAL_ALL_TL B

263: DESCRIPTION
264: ) = (select
265: B.NAME,
266: B.DESCRIPTION
267: from JTF_SEEDED_QUAL_ALL_TL B
268: where B.SEEDED_QUAL_ID = T.SEEDED_QUAL_ID
269: and B.LANGUAGE = T.SOURCE_LANG
270: and NVL(B.ORG_ID, -99) = NVL(T.ORG_ID,-99))
271: where (

Line 277: from JTF_SEEDED_QUAL_ALL_TL SUBB, JTF_SEEDED_QUAL_ALL_TL SUBT

273: T.LANGUAGE
274: ) in ( select
275: SUBT.SEEDED_QUAL_ID,
276: SUBT.LANGUAGE
277: from JTF_SEEDED_QUAL_ALL_TL SUBB, JTF_SEEDED_QUAL_ALL_TL SUBT
278: where SUBB.SEEDED_QUAL_ID = SUBT.SEEDED_QUAL_ID
279: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
280: AND NVL(SUBB.ORG_ID, -99) = NVL(SUBT.ORG_ID, -99) /* 1331579 BUG FIX */
281: and (SUBB.NAME <> SUBT.NAME)

Line 284: insert into JTF_SEEDED_QUAL_ALL_TL (

280: AND NVL(SUBB.ORG_ID, -99) = NVL(SUBT.ORG_ID, -99) /* 1331579 BUG FIX */
281: and (SUBB.NAME <> SUBT.NAME)
282: );
283:
284: insert into JTF_SEEDED_QUAL_ALL_TL (
285: SEEDED_QUAL_ID,
286: NAME,
287: DESCRIPTION,
288: LAST_UPDATE_DATE,

Line 308: from JTF_SEEDED_QUAL_ALL_TL B, FND_LANGUAGES L

304: B.CREATED_BY,
305: L.LANGUAGE_CODE,
306: B.SOURCE_LANG,
307: B.ORG_ID
308: from JTF_SEEDED_QUAL_ALL_TL B, FND_LANGUAGES L
309: where L.INSTALLED_FLAG in ('I', 'B')
310: and B.LANGUAGE = userenv('LANG')
311: and not exists
312: ( select NULL

Line 313: from JTF_SEEDED_QUAL_ALL_TL T

309: where L.INSTALLED_FLAG in ('I', 'B')
310: and B.LANGUAGE = userenv('LANG')
311: and not exists
312: ( select NULL
313: from JTF_SEEDED_QUAL_ALL_TL T
314: where T.SEEDED_QUAL_ID = B.SEEDED_QUAL_ID
315: and T.LANGUAGE = L.LANGUAGE_CODE
316: AND NVL(T.ORG_ID, -99) = NVL(B.ORG_ID, -99) /* 1331579 BUG FIX */
317: );

Line 377: UPDATE JTF_SEEDED_QUAL_ALL_TL SET

373: 0
374: );
375: END IF;
376: -- Load The record to _TL table
377: UPDATE JTF_SEEDED_QUAL_ALL_TL SET
378: name = x_name,
379: description = x_description,
380: last_update_date = sysdate,
381: last_updated_by = user_id,

Line 389: INSERT INTO JTF_SEEDED_QUAL_ALL_TL

385: AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG);
386:
387: IF (SQL%NOTFOUND) THEN
388: -- Insert new record to _TL table
389: INSERT INTO JTF_SEEDED_QUAL_ALL_TL
390: (SEEDED_QUAL_ID,
391: name,
392: description,
393: creation_date,

Line 415: FROM JTF_SEEDED_QUAL_ALL_TL t

411: FROM fnd_languages l
412: WHERE l.installed_flag IN ('I', 'B')
413: AND NOT EXISTS
414: ( SELECT NULL
415: FROM JTF_SEEDED_QUAL_ALL_TL t
416: WHERE t.SEEDED_QUAL_ID = x_SEEDED_QUAL_ID
417: AND t.language = l.language_code
418: );
419:

Line 448: UPDATE JTF_SEEDED_QUAL_ALL_TL SET

444: ELSE
445: user_id := 0;
446: END IF;
447: -- Update the translation
448: UPDATE JTF_SEEDED_QUAL_ALL_TL SET
449: name = x_name,
450: description = x_Description,
451: last_update_date = sysdate,
452: last_updated_by = user_id,