APPS.JTF_IH_REASONS_SEED_PVT dependencies on JTF_IH_REASONS_TL

Line 51: insert into JTF_IH_REASONS_TL (

47: X_LAST_UPDATED_BY,
48: X_LAST_UPDATE_LOGIN
49: );
50:
51: insert into JTF_IH_REASONS_TL (
52: REASON_ID,
53: OBJECT_VERSION_NUMBER,
54: CREATED_BY,
55: CREATION_DATE,

Line 83: from JTF_IH_REASONS_TL T

79: from FND_LANGUAGES L
80: where L.INSTALLED_FLAG in ('I', 'B')
81: and not exists
82: (select NULL
83: from JTF_IH_REASONS_TL T
84: where T.REASON_ID = X_REASON_ID
85: and T.LANGUAGE = L.LANGUAGE_CODE);
86:
87: open c;

Line 126: from JTF_IH_REASONS_TL

122: MEDIA_TYPE,
123: SHORT_DESCRIPTION,
124: LONG_DESCRIPTION,
125: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
126: from JTF_IH_REASONS_TL
127: where REASON_ID = X_REASON_ID
128: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
129: for update of REASON_ID nowait;
130: begin

Line 208: update JTF_IH_REASONS_TL set

204: if (sql%notfound) then
205: raise no_data_found;
206: end if;
207:
208: update JTF_IH_REASONS_TL set
209: REASON_CODE = X_REASON_CODE,
210: MEDIA_TYPE = X_MEDIA_TYPE,
211: SHORT_DESCRIPTION = X_SHORT_DESCRIPTION,
212: LONG_DESCRIPTION = X_LONG_DESCRIPTION,

Line 229: delete from JTF_IH_REASONS_TL

225: procedure DELETE_ROW (
226: X_REASON_ID in NUMBER
227: ) is
228: begin
229: delete from JTF_IH_REASONS_TL
230: where REASON_ID = X_REASON_ID;
231:
232: if (sql%notfound) then
233: raise no_data_found;

Line 247: delete from JTF_IH_REASONS_TL T

243:
244: procedure ADD_LANGUAGE
245: is
246: begin
247: delete from JTF_IH_REASONS_TL T
248: where not exists
249: (select NULL
250: from JTF_IH_REASONS_B B
251: where B.REASON_ID = T.REASON_ID

Line 254: update JTF_IH_REASONS_TL T set (

250: from JTF_IH_REASONS_B B
251: where B.REASON_ID = T.REASON_ID
252: );
253:
254: update JTF_IH_REASONS_TL T set (
255: REASON_CODE,
256: MEDIA_TYPE,
257: SHORT_DESCRIPTION,
258: LONG_DESCRIPTION

Line 264: from JTF_IH_REASONS_TL B

260: B.REASON_CODE,
261: B.MEDIA_TYPE,
262: B.SHORT_DESCRIPTION,
263: B.LONG_DESCRIPTION
264: from JTF_IH_REASONS_TL B
265: where B.REASON_ID = T.REASON_ID
266: and B.LANGUAGE = T.SOURCE_LANG)
267: where (
268: T.REASON_ID,

Line 273: from JTF_IH_REASONS_TL SUBB, JTF_IH_REASONS_TL SUBT

269: T.LANGUAGE
270: ) in (select
271: SUBT.REASON_ID,
272: SUBT.LANGUAGE
273: from JTF_IH_REASONS_TL SUBB, JTF_IH_REASONS_TL SUBT
274: where SUBB.REASON_ID = SUBT.REASON_ID
275: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
276: and (SUBB.REASON_CODE <> SUBT.REASON_CODE
277: or (SUBB.REASON_CODE is null and SUBT.REASON_CODE is not null)

Line 290: insert into JTF_IH_REASONS_TL (

286: or (SUBB.LONG_DESCRIPTION is null and SUBT.LONG_DESCRIPTION is not null)
287: or (SUBB.LONG_DESCRIPTION is not null and SUBT.LONG_DESCRIPTION is null)
288: ));
289:
290: insert into JTF_IH_REASONS_TL (
291: REASON_ID,
292: OBJECT_VERSION_NUMBER,
293: CREATED_BY,
294: CREATION_DATE,

Line 318: from JTF_IH_REASONS_TL B, FND_LANGUAGES L

314: B.MEDIA_TYPE,
315: B.REASON_CODE,
316: L.LANGUAGE_CODE,
317: B.SOURCE_LANG
318: from JTF_IH_REASONS_TL B, FND_LANGUAGES L
319: where L.INSTALLED_FLAG in ('I', 'B')
320: and B.LANGUAGE = userenv('LANG')
321: and not exists
322: (select NULL

Line 323: from JTF_IH_REASONS_TL T

319: where L.INSTALLED_FLAG in ('I', 'B')
320: and B.LANGUAGE = userenv('LANG')
321: and not exists
322: (select NULL
323: from JTF_IH_REASONS_TL T
324: where T.REASON_ID = B.REASON_ID
325: and T.LANGUAGE = L.LANGUAGE_CODE);
326: end ADD_LANGUAGE;
327:

Line 433: UPDATE jtf_ih_reasons_tl SET

429: X_SHORT_DESCRIPTION in VARCHAR2,
430: X_LONG_DESCRIPTION in VARCHAR2,
431: X_OWNER IN VARCHAR2) is
432: begin
433: UPDATE jtf_ih_reasons_tl SET
434: reason_id = X_REASON_ID,
435: reason_code = X_REASON_CODE,
436: media_type = X_MEDIA_TYPE,
437: short_description = X_SHORT_DESCRIPTION,