APPS.JTF_IH_OUTCOMES_SEED_PVT dependencies on JTF_IH_OUTCOMES_TL

Line 57: insert into JTF_IH_OUTCOMES_TL (

53: X_LAST_UPDATED_BY,
54: X_LAST_UPDATE_LOGIN
55: );
56:
57: insert into JTF_IH_OUTCOMES_TL (
58: OUTCOME_ID,
59: OBJECT_VERSION_NUMBER,
60: CREATED_BY,
61: CREATION_DATE,

Line 89: from JTF_IH_OUTCOMES_TL T

85: from FND_LANGUAGES L
86: where L.INSTALLED_FLAG in ('I', 'B')
87: and not exists
88: (select NULL
89: from JTF_IH_OUTCOMES_TL T
90: where T.OUTCOME_ID = X_OUTCOME_ID
91: and T.LANGUAGE = L.LANGUAGE_CODE);
92:
93: open c;

Line 136: from JTF_IH_OUTCOMES_TL

132: MEDIA_TYPE,
133: SHORT_DESCRIPTION,
134: LONG_DESCRIPTION,
135: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
136: from JTF_IH_OUTCOMES_TL
137: where OUTCOME_ID = X_OUTCOME_ID
138: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
139: for update of OUTCOME_ID nowait;
140: begin

Line 223: update JTF_IH_OUTCOMES_TL set

219: if (sql%notfound) then
220: raise no_data_found;
221: end if;
222:
223: update JTF_IH_OUTCOMES_TL set
224: OUTCOME_CODE = X_OUTCOME_CODE,
225: MEDIA_TYPE = X_MEDIA_TYPE,
226: SHORT_DESCRIPTION = X_SHORT_DESCRIPTION,
227: LONG_DESCRIPTION = X_LONG_DESCRIPTION,

Line 244: delete from JTF_IH_OUTCOMES_TL

240: procedure DELETE_ROW (
241: X_OUTCOME_ID in NUMBER
242: ) is
243: begin
244: delete from JTF_IH_OUTCOMES_TL
245: where OUTCOME_ID = X_OUTCOME_ID;
246:
247: if (sql%notfound) then
248: raise no_data_found;

Line 262: delete from JTF_IH_OUTCOMES_TL T

258:
259: procedure ADD_LANGUAGE
260: is
261: begin
262: delete from JTF_IH_OUTCOMES_TL T
263: where not exists
264: (select NULL
265: from JTF_IH_OUTCOMES_B B
266: where B.OUTCOME_ID = T.OUTCOME_ID

Line 269: update JTF_IH_OUTCOMES_TL T set (

265: from JTF_IH_OUTCOMES_B B
266: where B.OUTCOME_ID = T.OUTCOME_ID
267: );
268:
269: update JTF_IH_OUTCOMES_TL T set (
270: OUTCOME_CODE,
271: MEDIA_TYPE,
272: SHORT_DESCRIPTION,
273: LONG_DESCRIPTION

Line 279: from JTF_IH_OUTCOMES_TL B

275: B.OUTCOME_CODE,
276: B.MEDIA_TYPE,
277: B.SHORT_DESCRIPTION,
278: B.LONG_DESCRIPTION
279: from JTF_IH_OUTCOMES_TL B
280: where B.OUTCOME_ID = T.OUTCOME_ID
281: and B.LANGUAGE = T.SOURCE_LANG)
282: where (
283: T.OUTCOME_ID,

Line 288: from JTF_IH_OUTCOMES_TL SUBB, JTF_IH_OUTCOMES_TL SUBT

284: T.LANGUAGE
285: ) in (select
286: SUBT.OUTCOME_ID,
287: SUBT.LANGUAGE
288: from JTF_IH_OUTCOMES_TL SUBB, JTF_IH_OUTCOMES_TL SUBT
289: where SUBB.OUTCOME_ID = SUBT.OUTCOME_ID
290: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
291: and (SUBB.OUTCOME_CODE <> SUBT.OUTCOME_CODE
292: or SUBB.MEDIA_TYPE <> SUBT.MEDIA_TYPE

Line 301: insert into JTF_IH_OUTCOMES_TL (

297: or (SUBB.LONG_DESCRIPTION is null and SUBT.LONG_DESCRIPTION is not null)
298: or (SUBB.LONG_DESCRIPTION is not null and SUBT.LONG_DESCRIPTION is null)
299: ));
300:
301: insert into JTF_IH_OUTCOMES_TL (
302: OUTCOME_ID,
303: OBJECT_VERSION_NUMBER,
304: CREATED_BY,
305: CREATION_DATE,

Line 329: from JTF_IH_OUTCOMES_TL B, FND_LANGUAGES L

325: B.OUTCOME_CODE,
326: B.MEDIA_TYPE,
327: L.LANGUAGE_CODE,
328: B.SOURCE_LANG
329: from JTF_IH_OUTCOMES_TL B, FND_LANGUAGES L
330: where L.INSTALLED_FLAG in ('I', 'B')
331: and B.LANGUAGE = userenv('LANG')
332: and not exists
333: (select NULL

Line 334: from JTF_IH_OUTCOMES_TL T

330: where L.INSTALLED_FLAG in ('I', 'B')
331: and B.LANGUAGE = userenv('LANG')
332: and not exists
333: (select NULL
334: from JTF_IH_OUTCOMES_TL T
335: where T.OUTCOME_ID = B.OUTCOME_ID
336: and T.LANGUAGE = L.LANGUAGE_CODE);
337: end ADD_LANGUAGE;
338:

Line 452: UPDATE jtf_ih_outcomes_tl SET

448: X_SHORT_DESCRIPTION in VARCHAR2,
449: X_LONG_DESCRIPTION in VARCHAR2,
450: X_OWNER IN VARCHAR2) is
451: begin
452: UPDATE jtf_ih_outcomes_tl SET
453: outcome_id = X_OUTCOME_CODE,
454: media_type = X_OUTCOME_CODE,
455: short_description = X_SHORT_DESCRIPTION,
456: long_description = X_LONG_DESCRIPTION,