APPS.JTF_IH_RESULTS_SEED_PKG dependencies on JTF_IH_RESULTS_TL

Line 70: insert into JTF_IH_RESULTS_TL (

66: --Added for performance issue due to literals - 27-Jul-2004
67: NVL(X_ACTIVE,L_ACTIVE_FLAG)
68: );
69:
70: insert into JTF_IH_RESULTS_TL (
71: RESULT_CODE,
72: LONG_DESCRIPTION,
73: OBJECT_VERSION_NUMBER,
74: CREATED_BY,

Line 106: from JTF_IH_RESULTS_TL T

102: --where L.INSTALLED_FLAG in ('I', 'B')
103: where L.INSTALLED_FLAG in ( L_INSTALLED_FLAG1, L_INSTALLED_FLAG2)
104: and not exists
105: (select NULL
106: from JTF_IH_RESULTS_TL T
107: where T.RESULT_ID = X_RESULT_ID
108: and T.LANGUAGE = L.LANGUAGE_CODE);
109:
110: open c;

Line 157: from JTF_IH_RESULTS_TL

153: LONG_DESCRIPTION,
154: --Added for performance issue due to literals - 28-Jul-2004
155: --decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
156: decode(LANGUAGE, L_LANG, L_YES, L_NO) BASELANG
157: from JTF_IH_RESULTS_TL
158: where RESULT_ID = X_RESULT_ID
159: --and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
160: --Added for performance issue due to literals - 28-Jul-2004
161: and L_LANG in (LANGUAGE, SOURCE_LANG)

Line 261: update JTF_IH_RESULTS_TL set

257: if (sql%notfound) then
258: raise no_data_found;
259: end if;
260:
261: update JTF_IH_RESULTS_TL set
262: RESULT_CODE = X_RESULT_CODE,
263: MEDIA_TYPE = X_MEDIA_TYPE,
264: SHORT_DESCRIPTION = X_SHORT_DESCRIPTION,
265: LONG_DESCRIPTION = X_LONG_DESCRIPTION,

Line 286: delete from JTF_IH_RESULTS_TL

282: procedure DELETE_ROW (
283: X_RESULT_ID in NUMBER
284: ) is
285: begin
286: delete from JTF_IH_RESULTS_TL
287: where RESULT_ID = X_RESULT_ID;
288:
289: if (sql%notfound) then
290: raise no_data_found;

Line 313: delete from JTF_IH_RESULTS_TL T

309: L_INSTALLED_FLAG1 := 'I';
310: L_INSTALLED_FLAG2 := 'B';
311: L_LANG := userenv('LANG');
312:
313: delete from JTF_IH_RESULTS_TL T
314: where not exists
315: (select NULL
316: from JTF_IH_RESULTS_B B
317: where B.RESULT_ID = T.RESULT_ID

Line 320: update JTF_IH_RESULTS_TL T set (

316: from JTF_IH_RESULTS_B B
317: where B.RESULT_ID = T.RESULT_ID
318: );
319:
320: update JTF_IH_RESULTS_TL T set (
321: RESULT_CODE,
322: MEDIA_TYPE,
323: SHORT_DESCRIPTION,
324: LONG_DESCRIPTION

Line 330: from JTF_IH_RESULTS_TL B

326: B.RESULT_CODE,
327: B.MEDIA_TYPE,
328: B.SHORT_DESCRIPTION,
329: B.LONG_DESCRIPTION
330: from JTF_IH_RESULTS_TL B
331: where B.RESULT_ID = T.RESULT_ID
332: and B.LANGUAGE = T.SOURCE_LANG)
333: where (
334: T.RESULT_ID,

Line 339: from JTF_IH_RESULTS_TL SUBB, JTF_IH_RESULTS_TL SUBT

335: T.LANGUAGE
336: ) in (select
337: SUBT.RESULT_ID,
338: SUBT.LANGUAGE
339: from JTF_IH_RESULTS_TL SUBB, JTF_IH_RESULTS_TL SUBT
340: where SUBB.RESULT_ID = SUBT.RESULT_ID
341: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
342: and (SUBB.RESULT_CODE <> SUBT.RESULT_CODE
343: or (SUBB.RESULT_CODE is null and SUBT.RESULT_CODE is not null)

Line 356: insert into JTF_IH_RESULTS_TL (

352: or (SUBB.LONG_DESCRIPTION is null and SUBT.LONG_DESCRIPTION is not null)
353: or (SUBB.LONG_DESCRIPTION is not null and SUBT.LONG_DESCRIPTION is null)
354: ));
355:
356: insert into JTF_IH_RESULTS_TL (
357: RESULT_CODE,
358: LONG_DESCRIPTION,
359: OBJECT_VERSION_NUMBER,
360: CREATED_BY,

Line 384: from JTF_IH_RESULTS_TL B, FND_LANGUAGES L

380: B.SHORT_DESCRIPTION,
381: B.RESULT_ID,
382: L.LANGUAGE_CODE,
383: B.SOURCE_LANG
384: from JTF_IH_RESULTS_TL B, FND_LANGUAGES L
385: where L.INSTALLED_FLAG in (L_INSTALLED_FLAG1, L_INSTALLED_FLAG2)
386: and B.LANGUAGE = L_LANG
387: and not exists
388: (select NULL

Line 389: from JTF_IH_RESULTS_TL T

385: where L.INSTALLED_FLAG in (L_INSTALLED_FLAG1, L_INSTALLED_FLAG2)
386: and B.LANGUAGE = L_LANG
387: and not exists
388: (select NULL
389: from JTF_IH_RESULTS_TL T
390: where T.RESULT_ID = B.RESULT_ID
391: and T.LANGUAGE = L.LANGUAGE_CODE);
392: end ADD_LANGUAGE;
393:

Line 519: UPDATE jtf_ih_results_tl SET

515: L_SEED := 'SEED';
516: L_UPDATEDBY1 := 1;
517: L_UPDATEDBY0 := 0;
518:
519: UPDATE jtf_ih_results_tl SET
520: result_id = X_RESULT_ID,
521: result_code = X_RESULT_CODE,
522: media_type = X_MEDIA_TYPE,
523: short_description = X_SHORT_DESCRIPTION,