APPS.JTF_IH_ACTIONS_SEED_PKG dependencies on JTF_IH_ACTIONS_TL

Line 53: insert into JTF_IH_ACTIONS_TL (

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

Line 85: from JTF_IH_ACTIONS_TL T

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

Line 122: from JTF_IH_ACTIONS_TL

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

Line 200: update JTF_IH_ACTIONS_TL set

196: if (sql%notfound) then
197: raise no_data_found;
198: end if;
199:
200: update JTF_IH_ACTIONS_TL set
201: ACTION = X_ACTION,
202: SHORT_DESCRIPTION = X_SHORT_DESCRIPTION,
203: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
204: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 223: delete from JTF_IH_ACTIONS_TL

219: procedure DELETE_ROW (
220: X_ACTION_ID in NUMBER
221: ) is
222: begin
223: delete from JTF_IH_ACTIONS_TL
224: where ACTION_ID = X_ACTION_ID;
225:
226: if (sql%notfound) then
227: raise no_data_found;

Line 252: delete from JTF_IH_ACTIONS_TL T

248: L_INSTALLED_FLAG1 := 'I';
249: L_INSTALLED_FLAG2 := 'B';
250: L_LANG := userenv('LANG');
251:
252: delete from JTF_IH_ACTIONS_TL T
253: where not exists
254: (select NULL
255: from JTF_IH_ACTIONS_B B
256: where B.ACTION_ID = T.ACTION_ID

Line 259: update JTF_IH_ACTIONS_TL T set (

255: from JTF_IH_ACTIONS_B B
256: where B.ACTION_ID = T.ACTION_ID
257: );
258:
259: update JTF_IH_ACTIONS_TL T set (
260: ACTION,
261: SHORT_DESCRIPTION
262: ) = (select
263: B.ACTION,

Line 265: from JTF_IH_ACTIONS_TL B

261: SHORT_DESCRIPTION
262: ) = (select
263: B.ACTION,
264: B.SHORT_DESCRIPTION
265: from JTF_IH_ACTIONS_TL B
266: where B.ACTION_ID = T.ACTION_ID
267: and B.LANGUAGE = T.SOURCE_LANG)
268: where (
269: T.ACTION_ID,

Line 274: from JTF_IH_ACTIONS_TL SUBB, JTF_IH_ACTIONS_TL SUBT

270: T.LANGUAGE
271: ) in (select
272: SUBT.ACTION_ID,
273: SUBT.LANGUAGE
274: from JTF_IH_ACTIONS_TL SUBB, JTF_IH_ACTIONS_TL SUBT
275: where SUBB.ACTION_ID = SUBT.ACTION_ID
276: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
277: and (SUBB.ACTION <> SUBT.ACTION
278: or (SUBB.ACTION is null and SUBT.ACTION is not null)

Line 285: insert into JTF_IH_ACTIONS_TL (

281: or (SUBB.SHORT_DESCRIPTION is null and SUBT.SHORT_DESCRIPTION is not null)
282: or (SUBB.SHORT_DESCRIPTION is not null and SUBT.SHORT_DESCRIPTION is null)
283: ));
284:
285: insert into JTF_IH_ACTIONS_TL (
286: ACTION_ID,
287: OBJECT_VERSION_NUMBER,
288: CREATED_BY,
289: CREATION_DATE,

Line 309: from JTF_IH_ACTIONS_TL B, FND_LANGUAGES L

305: B.ACTION,
306: B.SHORT_DESCRIPTION,
307: L.LANGUAGE_CODE,
308: B.SOURCE_LANG
309: from JTF_IH_ACTIONS_TL B, FND_LANGUAGES L
310: where L.INSTALLED_FLAG in (L_INSTALLED_FLAG1, L_INSTALLED_FLAG2)
311: and B.LANGUAGE = L_LANG
312: and not exists
313: (select NULL

Line 314: from JTF_IH_ACTIONS_TL T

310: where L.INSTALLED_FLAG in (L_INSTALLED_FLAG1, L_INSTALLED_FLAG2)
311: and B.LANGUAGE = L_LANG
312: and not exists
313: (select NULL
314: from JTF_IH_ACTIONS_TL T
315: where T.ACTION_ID = B.ACTION_ID
316: and T.LANGUAGE = L.LANGUAGE_CODE);
317: end ADD_LANGUAGE;
318:

Line 407: UPDATE jtf_ih_actions_tl SET

403: L_SEED := 'SEED';
404: L_UPDATEDBY1 := 1;
405: L_UPDATEDBY0 := 0;
406:
407: UPDATE jtf_ih_actions_tl SET
408: action_id = X_ACTION_ID,
409: action = X_ACTION,
410: short_description = X_SHORT_DESCRIPTION,
411: last_update_date = sysdate,