APPS.JTF_IH_RESULTS_SEED_PVT dependencies on JTF_IH_RESULTS_TL

Line 54: insert into JTF_IH_RESULTS_TL (

50: X_LAST_UPDATED_BY,
51: X_LAST_UPDATE_LOGIN
52: );
53:
54: insert into JTF_IH_RESULTS_TL (
55: RESULT_CODE,
56: LONG_DESCRIPTION,
57: OBJECT_VERSION_NUMBER,
58: CREATED_BY,

Line 86: from JTF_IH_RESULTS_TL T

82: from FND_LANGUAGES L
83: where L.INSTALLED_FLAG in ('I', 'B')
84: and not exists
85: (select NULL
86: from JTF_IH_RESULTS_TL T
87: where T.RESULT_ID = X_RESULT_ID
88: and T.LANGUAGE = L.LANGUAGE_CODE);
89:
90: open c;

Line 131: from JTF_IH_RESULTS_TL

127: MEDIA_TYPE,
128: SHORT_DESCRIPTION,
129: LONG_DESCRIPTION,
130: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
131: from JTF_IH_RESULTS_TL
132: where RESULT_ID = X_RESULT_ID
133: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
134: for update of RESULT_ID nowait;
135: begin

Line 216: update JTF_IH_RESULTS_TL set

212: if (sql%notfound) then
213: raise no_data_found;
214: end if;
215:
216: update JTF_IH_RESULTS_TL set
217: RESULT_CODE = X_RESULT_CODE,
218: MEDIA_TYPE = X_MEDIA_TYPE,
219: SHORT_DESCRIPTION = X_SHORT_DESCRIPTION,
220: LONG_DESCRIPTION = X_LONG_DESCRIPTION,

Line 237: delete from JTF_IH_RESULTS_TL

233: procedure DELETE_ROW (
234: X_RESULT_ID in NUMBER
235: ) is
236: begin
237: delete from JTF_IH_RESULTS_TL
238: where RESULT_ID = X_RESULT_ID;
239:
240: if (sql%notfound) then
241: raise no_data_found;

Line 255: delete from JTF_IH_RESULTS_TL T

251:
252: procedure ADD_LANGUAGE
253: is
254: begin
255: delete from JTF_IH_RESULTS_TL T
256: where not exists
257: (select NULL
258: from JTF_IH_RESULTS_B B
259: where B.RESULT_ID = T.RESULT_ID

Line 262: update JTF_IH_RESULTS_TL T set (

258: from JTF_IH_RESULTS_B B
259: where B.RESULT_ID = T.RESULT_ID
260: );
261:
262: update JTF_IH_RESULTS_TL T set (
263: RESULT_CODE,
264: MEDIA_TYPE,
265: SHORT_DESCRIPTION,
266: LONG_DESCRIPTION

Line 272: from JTF_IH_RESULTS_TL B

268: B.RESULT_CODE,
269: B.MEDIA_TYPE,
270: B.SHORT_DESCRIPTION,
271: B.LONG_DESCRIPTION
272: from JTF_IH_RESULTS_TL B
273: where B.RESULT_ID = T.RESULT_ID
274: and B.LANGUAGE = T.SOURCE_LANG)
275: where (
276: T.RESULT_ID,

Line 281: from JTF_IH_RESULTS_TL SUBB, JTF_IH_RESULTS_TL SUBT

277: T.LANGUAGE
278: ) in (select
279: SUBT.RESULT_ID,
280: SUBT.LANGUAGE
281: from JTF_IH_RESULTS_TL SUBB, JTF_IH_RESULTS_TL SUBT
282: where SUBB.RESULT_ID = SUBT.RESULT_ID
283: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
284: and (SUBB.RESULT_CODE <> SUBT.RESULT_CODE
285: or (SUBB.RESULT_CODE is null and SUBT.RESULT_CODE is not null)

Line 298: insert into JTF_IH_RESULTS_TL (

294: or (SUBB.LONG_DESCRIPTION is null and SUBT.LONG_DESCRIPTION is not null)
295: or (SUBB.LONG_DESCRIPTION is not null and SUBT.LONG_DESCRIPTION is null)
296: ));
297:
298: insert into JTF_IH_RESULTS_TL (
299: RESULT_CODE,
300: LONG_DESCRIPTION,
301: OBJECT_VERSION_NUMBER,
302: CREATED_BY,

Line 326: from JTF_IH_RESULTS_TL B, FND_LANGUAGES L

322: B.SHORT_DESCRIPTION,
323: B.RESULT_ID,
324: L.LANGUAGE_CODE,
325: B.SOURCE_LANG
326: from JTF_IH_RESULTS_TL B, FND_LANGUAGES L
327: where L.INSTALLED_FLAG in ('I', 'B')
328: and B.LANGUAGE = userenv('LANG')
329: and not exists
330: (select NULL

Line 331: from JTF_IH_RESULTS_TL T

327: where L.INSTALLED_FLAG in ('I', 'B')
328: and B.LANGUAGE = userenv('LANG')
329: and not exists
330: (select NULL
331: from JTF_IH_RESULTS_TL T
332: where T.RESULT_ID = B.RESULT_ID
333: and T.LANGUAGE = L.LANGUAGE_CODE);
334: end ADD_LANGUAGE;
335:

Line 444: UPDATE jtf_ih_results_tl SET

440: X_SHORT_DESCRIPTION in VARCHAR2,
441: X_LONG_DESCRIPTION in VARCHAR2,
442: X_OWNER IN VARCHAR2) is
443: begin
444: UPDATE jtf_ih_results_tl SET
445: result_id = X_RESULT_ID,
446: result_code = X_RESULT_CODE,
447: media_type = X_MEDIA_TYPE,
448: short_description = X_SHORT_DESCRIPTION,