APPS.JTF_IH_ACTION_ITEMS_SEED_PKG dependencies on JTF_IH_ACTION_ITEMS_TL

Line 54: insert into JTF_IH_ACTION_ITEMS_TL (

50: --Added for performance issue due to literals - 27-Jul-2004
51: NVL(X_ACTIVE,L_ACTIVE_FLAG)
52: );
53:
54: insert into JTF_IH_ACTION_ITEMS_TL (
55: ACTION_ITEM_ID,
56: OBJECT_VERSION_NUMBER,
57: CREATED_BY,
58: CREATION_DATE,

Line 86: from JTF_IH_ACTION_ITEMS_TL T

82: --where L.INSTALLED_FLAG in ('I', 'B')
83: where L.INSTALLED_FLAG in ( L_INSTALLED_FLAG1, L_INSTALLED_FLAG2)
84: and not exists
85: (select NULL
86: from JTF_IH_ACTION_ITEMS_TL T
87: where T.ACTION_ITEM_ID = X_ACTION_ITEM_ID
88: and T.LANGUAGE = L.LANGUAGE_CODE);
89:
90: open c;

Line 123: from JTF_IH_ACTION_ITEMS_TL

119: SHORT_DESCRIPTION,
120: --Added for performance issue due to literals - 28-Jul-2004
121: --decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
122: decode(LANGUAGE, L_LANG, L_YES, L_NO) BASELANG
123: from JTF_IH_ACTION_ITEMS_TL
124: where ACTION_ITEM_ID = X_ACTION_ITEM_ID
125: --and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
126: --Added for performance issue due to literals - 28-Jul-2004
127: and L_LANG in (LANGUAGE, SOURCE_LANG)

Line 199: update JTF_IH_ACTION_ITEMS_TL set

195: if (sql%notfound) then
196: raise no_data_found;
197: end if;
198:
199: update JTF_IH_ACTION_ITEMS_TL set
200: ACTION_ITEM = X_ACTION_ITEM,
201: SHORT_DESCRIPTION = X_SHORT_DESCRIPTION,
202: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
203: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 222: delete from JTF_IH_ACTION_ITEMS_TL

218: procedure DELETE_ROW (
219: X_ACTION_ITEM_ID in NUMBER
220: ) is
221: begin
222: delete from JTF_IH_ACTION_ITEMS_TL
223: where ACTION_ITEM_ID = X_ACTION_ITEM_ID;
224:
225: if (sql%notfound) then
226: raise no_data_found;

Line 249: delete from JTF_IH_ACTION_ITEMS_TL T

245: L_INSTALLED_FLAG1 := 'I';
246: L_INSTALLED_FLAG2 := 'B';
247: L_LANG := userenv('LANG');
248:
249: delete from JTF_IH_ACTION_ITEMS_TL T
250: where not exists
251: (select NULL
252: from JTF_IH_ACTION_ITEMS_B B
253: where B.ACTION_ITEM_ID = T.ACTION_ITEM_ID

Line 256: update JTF_IH_ACTION_ITEMS_TL T set (

252: from JTF_IH_ACTION_ITEMS_B B
253: where B.ACTION_ITEM_ID = T.ACTION_ITEM_ID
254: );
255:
256: update JTF_IH_ACTION_ITEMS_TL T set (
257: ACTION_ITEM,
258: SHORT_DESCRIPTION
259: ) = (select
260: B.ACTION_ITEM,

Line 262: from JTF_IH_ACTION_ITEMS_TL B

258: SHORT_DESCRIPTION
259: ) = (select
260: B.ACTION_ITEM,
261: B.SHORT_DESCRIPTION
262: from JTF_IH_ACTION_ITEMS_TL B
263: where B.ACTION_ITEM_ID = T.ACTION_ITEM_ID
264: and B.LANGUAGE = T.SOURCE_LANG)
265: where (
266: T.ACTION_ITEM_ID,

Line 271: from JTF_IH_ACTION_ITEMS_TL SUBB, JTF_IH_ACTION_ITEMS_TL SUBT

267: T.LANGUAGE
268: ) in (select
269: SUBT.ACTION_ITEM_ID,
270: SUBT.LANGUAGE
271: from JTF_IH_ACTION_ITEMS_TL SUBB, JTF_IH_ACTION_ITEMS_TL SUBT
272: where SUBB.ACTION_ITEM_ID = SUBT.ACTION_ITEM_ID
273: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
274: and (SUBB.ACTION_ITEM <> SUBT.ACTION_ITEM
275: or SUBB.SHORT_DESCRIPTION <> SUBT.SHORT_DESCRIPTION

Line 278: insert into JTF_IH_ACTION_ITEMS_TL (

274: and (SUBB.ACTION_ITEM <> SUBT.ACTION_ITEM
275: or SUBB.SHORT_DESCRIPTION <> SUBT.SHORT_DESCRIPTION
276: ));
277:
278: insert into JTF_IH_ACTION_ITEMS_TL (
279: ACTION_ITEM_ID,
280: OBJECT_VERSION_NUMBER,
281: CREATED_BY,
282: CREATION_DATE,

Line 302: from JTF_IH_ACTION_ITEMS_TL B, FND_LANGUAGES L

298: B.ACTION_ITEM,
299: B.SHORT_DESCRIPTION,
300: L.LANGUAGE_CODE,
301: B.SOURCE_LANG
302: from JTF_IH_ACTION_ITEMS_TL B, FND_LANGUAGES L
303: where L.INSTALLED_FLAG in (L_INSTALLED_FLAG1, L_INSTALLED_FLAG2)
304: and B.LANGUAGE = L_LANG
305: and not exists
306: (select NULL

Line 307: from JTF_IH_ACTION_ITEMS_TL T

303: where L.INSTALLED_FLAG in (L_INSTALLED_FLAG1, L_INSTALLED_FLAG2)
304: and B.LANGUAGE = L_LANG
305: and not exists
306: (select NULL
307: from JTF_IH_ACTION_ITEMS_TL T
308: where T.ACTION_ITEM_ID = B.ACTION_ITEM_ID
309: and T.LANGUAGE = L.LANGUAGE_CODE);
310: end ADD_LANGUAGE;
311:

Line 400: UPDATE jtf_ih_action_items_tl SET

396: L_SEED := 'SEED';
397: L_UPDATEDBY1 := 1;
398: L_UPDATEDBY0 := 0;
399:
400: UPDATE jtf_ih_action_items_tl SET
401: action_item_id = X_ACTION_ITEM_ID,
402: action_item = X_ACTION_ITEM,
403: short_description = X_SHORT_DESCRIPTION,
404: last_update_date = sysdate,