APPS.JTF_IH_REASONS_SEED_PKG dependencies on JTF_IH_REASONS_TL

Line 68: insert into JTF_IH_REASONS_TL (

64: --Added for performance issue due to literals - 27-Jul-2004
65: NVL(X_ACTIVE,L_ACTIVE_FLAG)
66: );
67:
68: insert into JTF_IH_REASONS_TL (
69: REASON_ID,
70: OBJECT_VERSION_NUMBER,
71: CREATED_BY,
72: CREATION_DATE,

Line 104: from JTF_IH_REASONS_TL T

100: --where L.INSTALLED_FLAG in ('I', 'B')
101: where L.INSTALLED_FLAG in ( L_INSTALLED_FLAG1, L_INSTALLED_FLAG2)
102: and not exists
103: (select NULL
104: from JTF_IH_REASONS_TL T
105: where T.REASON_ID = X_REASON_ID
106: and T.LANGUAGE = L.LANGUAGE_CODE);
107:
108: open c;

Line 154: from JTF_IH_REASONS_TL

150: LONG_DESCRIPTION,
151: --Added for performance issue due to literals - 28-Jul-2004
152: --decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
153: decode(LANGUAGE, L_LANG, L_YES, L_NO) BASELANG
154: from JTF_IH_REASONS_TL
155: where REASON_ID = X_REASON_ID
156: --and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
157: --Added for performance issue due to literals - 28-Jul-2004
158: and L_LANG in (LANGUAGE, SOURCE_LANG)

Line 255: update JTF_IH_REASONS_TL set

251: if (sql%notfound) then
252: raise no_data_found;
253: end if;
254:
255: update JTF_IH_REASONS_TL set
256: REASON_CODE = X_REASON_CODE,
257: MEDIA_TYPE = X_MEDIA_TYPE,
258: SHORT_DESCRIPTION = X_SHORT_DESCRIPTION,
259: LONG_DESCRIPTION = X_LONG_DESCRIPTION,

Line 280: delete from JTF_IH_REASONS_TL

276: procedure DELETE_ROW (
277: X_REASON_ID in NUMBER
278: ) is
279: begin
280: delete from JTF_IH_REASONS_TL
281: where REASON_ID = X_REASON_ID;
282:
283: if (sql%notfound) then
284: raise no_data_found;

Line 307: delete from JTF_IH_REASONS_TL T

303: L_INSTALLED_FLAG1 := 'I';
304: L_INSTALLED_FLAG2 := 'B';
305: L_LANG := userenv('LANG');
306:
307: delete from JTF_IH_REASONS_TL T
308: where not exists
309: (select NULL
310: from JTF_IH_REASONS_B B
311: where B.REASON_ID = T.REASON_ID

Line 314: update JTF_IH_REASONS_TL T set (

310: from JTF_IH_REASONS_B B
311: where B.REASON_ID = T.REASON_ID
312: );
313:
314: update JTF_IH_REASONS_TL T set (
315: REASON_CODE,
316: MEDIA_TYPE,
317: SHORT_DESCRIPTION,
318: LONG_DESCRIPTION

Line 324: from JTF_IH_REASONS_TL B

320: B.REASON_CODE,
321: B.MEDIA_TYPE,
322: B.SHORT_DESCRIPTION,
323: B.LONG_DESCRIPTION
324: from JTF_IH_REASONS_TL B
325: where B.REASON_ID = T.REASON_ID
326: and B.LANGUAGE = T.SOURCE_LANG)
327: where (
328: T.REASON_ID,

Line 333: from JTF_IH_REASONS_TL SUBB, JTF_IH_REASONS_TL SUBT

329: T.LANGUAGE
330: ) in (select
331: SUBT.REASON_ID,
332: SUBT.LANGUAGE
333: from JTF_IH_REASONS_TL SUBB, JTF_IH_REASONS_TL SUBT
334: where SUBB.REASON_ID = SUBT.REASON_ID
335: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
336: and (SUBB.REASON_CODE <> SUBT.REASON_CODE
337: or (SUBB.REASON_CODE is null and SUBT.REASON_CODE is not null)

Line 350: insert into JTF_IH_REASONS_TL (

346: or (SUBB.LONG_DESCRIPTION is null and SUBT.LONG_DESCRIPTION is not null)
347: or (SUBB.LONG_DESCRIPTION is not null and SUBT.LONG_DESCRIPTION is null)
348: ));
349:
350: insert into JTF_IH_REASONS_TL (
351: REASON_ID,
352: OBJECT_VERSION_NUMBER,
353: CREATED_BY,
354: CREATION_DATE,

Line 378: from JTF_IH_REASONS_TL B, FND_LANGUAGES L

374: B.MEDIA_TYPE,
375: B.REASON_CODE,
376: L.LANGUAGE_CODE,
377: B.SOURCE_LANG
378: from JTF_IH_REASONS_TL B, FND_LANGUAGES L
379: where L.INSTALLED_FLAG in (L_INSTALLED_FLAG1, L_INSTALLED_FLAG2)
380: and B.LANGUAGE = L_LANG
381: and not exists
382: (select NULL

Line 383: from JTF_IH_REASONS_TL T

379: where L.INSTALLED_FLAG in (L_INSTALLED_FLAG1, L_INSTALLED_FLAG2)
380: and B.LANGUAGE = L_LANG
381: and not exists
382: (select NULL
383: from JTF_IH_REASONS_TL T
384: where T.REASON_ID = B.REASON_ID
385: and T.LANGUAGE = L.LANGUAGE_CODE);
386: end ADD_LANGUAGE;
387:

Line 510: UPDATE jtf_ih_reasons_tl SET

506: L_SEED := 'SEED';
507: L_UPDATEDBY1 := 1;
508: L_UPDATEDBY0 := 0;
509:
510: UPDATE jtf_ih_reasons_tl SET
511: reason_id = X_REASON_ID,
512: reason_code = X_REASON_CODE,
513: media_type = X_MEDIA_TYPE,
514: short_description = X_SHORT_DESCRIPTION,