APPS.JTF_IH_OUTCOMES_SEED_PKG dependencies on JTF_IH_OUTCOMES_TL

Line 73: insert into JTF_IH_OUTCOMES_TL (

69: --Added for performance issue due to literals - 27-Jul-2004
70: NVL(X_ACTIVE,L_ACTIVE_FLAG)
71: );
72:
73: insert into JTF_IH_OUTCOMES_TL (
74: OUTCOME_ID,
75: OBJECT_VERSION_NUMBER,
76: CREATED_BY,
77: CREATION_DATE,

Line 109: from JTF_IH_OUTCOMES_TL T

105: --where L.INSTALLED_FLAG in ('I', 'B')
106: where L.INSTALLED_FLAG in ( L_INSTALLED_FLAG1, L_INSTALLED_FLAG2)
107: and not exists
108: (select NULL
109: from JTF_IH_OUTCOMES_TL T
110: where T.OUTCOME_ID = X_OUTCOME_ID
111: and T.LANGUAGE = L.LANGUAGE_CODE);
112:
113: open c;

Line 163: from JTF_IH_OUTCOMES_TL

159: LONG_DESCRIPTION,
160: --Added for performance issue due to literals - 28-Jul-2004
161: --decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
162: decode(LANGUAGE, L_LANG, L_YES, L_NO) BASELANG
163: from JTF_IH_OUTCOMES_TL
164: where OUTCOME_ID = X_OUTCOME_ID
165: --and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
166: --Added for performance issue due to literals - 28-Jul-2004
167: and L_LANG in (LANGUAGE, SOURCE_LANG)

Line 269: update JTF_IH_OUTCOMES_TL set

265: if (sql%notfound) then
266: raise no_data_found;
267: end if;
268:
269: update JTF_IH_OUTCOMES_TL set
270: OUTCOME_CODE = X_OUTCOME_CODE,
271: MEDIA_TYPE = X_MEDIA_TYPE,
272: SHORT_DESCRIPTION = X_SHORT_DESCRIPTION,
273: LONG_DESCRIPTION = X_LONG_DESCRIPTION,

Line 294: delete from JTF_IH_OUTCOMES_TL

290: procedure DELETE_ROW (
291: X_OUTCOME_ID in NUMBER
292: ) is
293: begin
294: delete from JTF_IH_OUTCOMES_TL
295: where OUTCOME_ID = X_OUTCOME_ID;
296:
297: if (sql%notfound) then
298: raise no_data_found;

Line 321: delete from JTF_IH_OUTCOMES_TL T

317: L_INSTALLED_FLAG1 := 'I';
318: L_INSTALLED_FLAG2 := 'B';
319: L_LANG := userenv('LANG');
320:
321: delete from JTF_IH_OUTCOMES_TL T
322: where not exists
323: (select NULL
324: from JTF_IH_OUTCOMES_B B
325: where B.OUTCOME_ID = T.OUTCOME_ID

Line 328: update JTF_IH_OUTCOMES_TL T set (

324: from JTF_IH_OUTCOMES_B B
325: where B.OUTCOME_ID = T.OUTCOME_ID
326: );
327:
328: update JTF_IH_OUTCOMES_TL T set (
329: OUTCOME_CODE,
330: MEDIA_TYPE,
331: SHORT_DESCRIPTION,
332: LONG_DESCRIPTION

Line 338: from JTF_IH_OUTCOMES_TL B

334: B.OUTCOME_CODE,
335: B.MEDIA_TYPE,
336: B.SHORT_DESCRIPTION,
337: B.LONG_DESCRIPTION
338: from JTF_IH_OUTCOMES_TL B
339: where B.OUTCOME_ID = T.OUTCOME_ID
340: and B.LANGUAGE = T.SOURCE_LANG)
341: where (
342: T.OUTCOME_ID,

Line 347: from JTF_IH_OUTCOMES_TL SUBB, JTF_IH_OUTCOMES_TL SUBT

343: T.LANGUAGE
344: ) in (select
345: SUBT.OUTCOME_ID,
346: SUBT.LANGUAGE
347: from JTF_IH_OUTCOMES_TL SUBB, JTF_IH_OUTCOMES_TL SUBT
348: where SUBB.OUTCOME_ID = SUBT.OUTCOME_ID
349: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
350: and (SUBB.OUTCOME_CODE <> SUBT.OUTCOME_CODE
351: or SUBB.MEDIA_TYPE <> SUBT.MEDIA_TYPE

Line 360: insert into JTF_IH_OUTCOMES_TL (

356: or (SUBB.LONG_DESCRIPTION is null and SUBT.LONG_DESCRIPTION is not null)
357: or (SUBB.LONG_DESCRIPTION is not null and SUBT.LONG_DESCRIPTION is null)
358: ));
359:
360: insert into JTF_IH_OUTCOMES_TL (
361: OUTCOME_ID,
362: OBJECT_VERSION_NUMBER,
363: CREATED_BY,
364: CREATION_DATE,

Line 388: from JTF_IH_OUTCOMES_TL B, FND_LANGUAGES L

384: B.OUTCOME_CODE,
385: B.MEDIA_TYPE,
386: L.LANGUAGE_CODE,
387: B.SOURCE_LANG
388: from JTF_IH_OUTCOMES_TL B, FND_LANGUAGES L
389: where L.INSTALLED_FLAG in (L_INSTALLED_FLAG1, L_INSTALLED_FLAG2)
390: and B.LANGUAGE = L_LANG
391: and not exists
392: (select NULL

Line 393: from JTF_IH_OUTCOMES_TL T

389: where L.INSTALLED_FLAG in (L_INSTALLED_FLAG1, L_INSTALLED_FLAG2)
390: and B.LANGUAGE = L_LANG
391: and not exists
392: (select NULL
393: from JTF_IH_OUTCOMES_TL T
394: where T.OUTCOME_ID = B.OUTCOME_ID
395: and T.LANGUAGE = L.LANGUAGE_CODE);
396: end ADD_LANGUAGE;
397:

Line 529: UPDATE jtf_ih_outcomes_tl SET

525: L_SEED := 'SEED';
526: L_UPDATEDBY1 := 1;
527: L_UPDATEDBY0 := 0;
528:
529: UPDATE jtf_ih_outcomes_tl SET
530: outcome_id = X_OUTCOME_ID,
531: outcome_code = X_OUTCOME_CODE,
532: media_type = X_MEDIA_TYPE,
533: short_description = X_SHORT_DESCRIPTION,