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

Line 1: PACKAGE BODY JTF_SEEDED_QUAL_PKG AS

1: PACKAGE BODY JTF_SEEDED_QUAL_PKG AS
2: /* $Header: jtfvsqlb.pls 120.2 2005/10/25 16:43:34 achanda ship $ */
3:
4: -- eihsu 10/06/1999 adding procedures for MLS support
5: -- vnedunga 05/11/00 fixing the translate row as part of

Line 7: -- vnedunga 05/16/00 Fixing UPdate_Row/Delete row use JTF_SEEDED_QUAL_ALL_B

3:
4: -- eihsu 10/06/1999 adding procedures for MLS support
5: -- vnedunga 05/11/00 fixing the translate row as part of
6: -- MLS verification
7: -- vnedunga 05/16/00 Fixing UPdate_Row/Delete row use JTF_SEEDED_QUAL_ALL_B
8: -- instead of JTF_SEEDED_QUAL
9: -- jdochert 08/17/00 1331579 bug fix =>
10: -- Replaced: AND org_id = x_org_id
11: -- With: and NVL(ORG_ID, -99) = NVL(x_ORG_ID, -99)

Line 8: -- instead of JTF_SEEDED_QUAL

4: -- eihsu 10/06/1999 adding procedures for MLS support
5: -- vnedunga 05/11/00 fixing the translate row as part of
6: -- MLS verification
7: -- vnedunga 05/16/00 Fixing UPdate_Row/Delete row use JTF_SEEDED_QUAL_ALL_B
8: -- instead of JTF_SEEDED_QUAL
9: -- jdochert 08/17/00 1331579 bug fix =>
10: -- Replaced: AND org_id = x_org_id
11: -- With: and NVL(ORG_ID, -99) = NVL(x_ORG_ID, -99)
12: --

Line 26: CURSOR C IS SELECT rowid FROM JTF_SEEDED_QUAL_ALL_B

22: x_NAME IN VARCHAR2,
23: x_DESCRIPTION IN VARCHAR2,
24: x_ORG_ID IN NUMBER
25: ) IS
26: CURSOR C IS SELECT rowid FROM JTF_SEEDED_QUAL_ALL_B
27: WHERE SEEDED_QUAL_ID = x_SEEDED_QUAL_ID and NVL(ORG_ID, -99) = NVL(x_ORG_ID, -99);
28: CURSOR C2 IS SELECT JTF_SEEDED_QUAL_s.nextval FROM sys.dual;
29: BEGIN
30: If (x_SEEDED_QUAL_ID IS NULL) then

Line 28: CURSOR C2 IS SELECT JTF_SEEDED_QUAL_s.nextval FROM sys.dual;

24: x_ORG_ID IN NUMBER
25: ) IS
26: CURSOR C IS SELECT rowid FROM JTF_SEEDED_QUAL_ALL_B
27: WHERE SEEDED_QUAL_ID = x_SEEDED_QUAL_ID and NVL(ORG_ID, -99) = NVL(x_ORG_ID, -99);
28: CURSOR C2 IS SELECT JTF_SEEDED_QUAL_s.nextval FROM sys.dual;
29: BEGIN
30: If (x_SEEDED_QUAL_ID IS NULL) then
31: OPEN C2;
32: FETCH C2 INTO x_SEEDED_QUAL_ID;

Line 35: INSERT INTO JTF_SEEDED_QUAL_ALL_B(

31: OPEN C2;
32: FETCH C2 INTO x_SEEDED_QUAL_ID;
33: CLOSE C2;
34: End If;
35: INSERT INTO JTF_SEEDED_QUAL_ALL_B(
36: SEEDED_QUAL_ID,
37: LAST_UPDATE_DATE,
38: LAST_UPDATED_BY,
39: CREATION_DATE,

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 109: DELETE FROM JTF_SEEDED_QUAL_ALL_B

105: if (sql%notfound) then
106: raise no_data_found;
107: end if;
108:
109: DELETE FROM JTF_SEEDED_QUAL_ALL_B
110: WHERE SEEDED_QUAL_ID = x_SEEDED_QUAL_ID;
111: If (SQL%NOTFOUND) then
112: RAISE NO_DATA_FOUND;
113: End If;

Line 131: Update JTF_SEEDED_QUAL_ALL_B

127: x_DESCRIPTION IN VARCHAR2,
128: x_ORG_ID IN NUMBER
129: ) IS
130: BEGIN
131: Update JTF_SEEDED_QUAL_ALL_B
132: SET SEEDED_QUAL_ID = decode( x_SEEDED_QUAL_ID, FND_API.G_MISS_NUM,SEEDED_QUAL_ID,x_SEEDED_QUAL_ID),
133: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
134: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
135: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),

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 179: FROM JTF_SEEDED_QUAL

175: x_ORG_ID IN NUMBER
176: ) IS
177: CURSOR C IS
178: SELECT *
179: FROM JTF_SEEDED_QUAL
180: WHERE rowid = x_Rowid
181: FOR UPDATE of SEEDED_QUAL_ID NOWAIT;
182: Recinfo C%ROWTYPE;
183:

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 256: from JTF_SEEDED_QUAL_ALL_B B

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
258: and NVL(B.ORG_ID,-99) = NVL(T.ORG_ID,-99) /* 1331579 BUG FIX */
259: );
260:

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 346: UPDATE JTF_SEEDED_QUAL_ALL_B SET

342: ELSE
343: user_id := 0;
344: END IF;
345: -- Load The record to _B table
346: UPDATE JTF_SEEDED_QUAL_ALL_B SET
347: name = x_name,
348: description = x_description,
349: last_update_date = sysdate,
350: last_updated_by = user_id,

Line 356: INSERT INTO JTF_SEEDED_QUAL_ALL_B

352: WHERE SEEDED_QUAL_ID = x_SEEDED_QUAL_ID;
353:
354: IF (SQL%NOTFOUND) THEN
355: -- Insert new record to _B table
356: INSERT INTO JTF_SEEDED_QUAL_ALL_B
357: (SEEDED_QUAL_ID,
358: name,
359: description,
360: creation_date,

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,

Line 463: END JTF_SEEDED_QUAL_PKG;

459: NULL;
460: END TRANSLATE_ROW ;
461:
462:
463: END JTF_SEEDED_QUAL_PKG;
464: