APPS.JTF_IH_ACTIONS_SEED_PVT dependencies on JTF_IH_ACTIONS_TL

Line 37: insert into JTF_IH_ACTIONS_TL (

33: X_LAST_UPDATED_BY,
34: X_LAST_UPDATE_LOGIN
35: );
36:
37: insert into JTF_IH_ACTIONS_TL (
38: ACTION_ID,
39: OBJECT_VERSION_NUMBER,
40: CREATED_BY,
41: CREATION_DATE,

Line 65: from JTF_IH_ACTIONS_TL T

61: from FND_LANGUAGES L
62: where L.INSTALLED_FLAG in ('I', 'B')
63: and not exists
64: (select NULL
65: from JTF_IH_ACTIONS_TL T
66: where T.ACTION_ID = X_ACTION_ID
67: and T.LANGUAGE = L.LANGUAGE_CODE);
68:
69: open c;

Line 96: from JTF_IH_ACTIONS_TL

92: cursor c1 is select
93: ACTION,
94: SHORT_DESCRIPTION,
95: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
96: from JTF_IH_ACTIONS_TL
97: where ACTION_ID = X_ACTION_ID
98: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
99: for update of ACTION_ID nowait;
100: begin

Line 156: update JTF_IH_ACTIONS_TL set

152: if (sql%notfound) then
153: raise no_data_found;
154: end if;
155:
156: update JTF_IH_ACTIONS_TL set
157: ACTION = X_ACTION,
158: SHORT_DESCRIPTION = X_SHORT_DESCRIPTION,
159: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
160: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 175: delete from JTF_IH_ACTIONS_TL

171: procedure DELETE_ROW (
172: X_ACTION_ID in NUMBER
173: ) is
174: begin
175: delete from JTF_IH_ACTIONS_TL
176: where ACTION_ID = X_ACTION_ID;
177:
178: if (sql%notfound) then
179: raise no_data_found;

Line 193: delete from JTF_IH_ACTIONS_TL T

189:
190: procedure ADD_LANGUAGE
191: is
192: begin
193: delete from JTF_IH_ACTIONS_TL T
194: where not exists
195: (select NULL
196: from JTF_IH_ACTIONS_B B
197: where B.ACTION_ID = T.ACTION_ID

Line 200: update JTF_IH_ACTIONS_TL T set (

196: from JTF_IH_ACTIONS_B B
197: where B.ACTION_ID = T.ACTION_ID
198: );
199:
200: update JTF_IH_ACTIONS_TL T set (
201: ACTION,
202: SHORT_DESCRIPTION
203: ) = (select
204: B.ACTION,

Line 206: from JTF_IH_ACTIONS_TL B

202: SHORT_DESCRIPTION
203: ) = (select
204: B.ACTION,
205: B.SHORT_DESCRIPTION
206: from JTF_IH_ACTIONS_TL B
207: where B.ACTION_ID = T.ACTION_ID
208: and B.LANGUAGE = T.SOURCE_LANG)
209: where (
210: T.ACTION_ID,

Line 215: from JTF_IH_ACTIONS_TL SUBB, JTF_IH_ACTIONS_TL SUBT

211: T.LANGUAGE
212: ) in (select
213: SUBT.ACTION_ID,
214: SUBT.LANGUAGE
215: from JTF_IH_ACTIONS_TL SUBB, JTF_IH_ACTIONS_TL SUBT
216: where SUBB.ACTION_ID = SUBT.ACTION_ID
217: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
218: and (SUBB.ACTION <> SUBT.ACTION
219: or (SUBB.ACTION is null and SUBT.ACTION is not null)

Line 226: insert into JTF_IH_ACTIONS_TL (

222: or (SUBB.SHORT_DESCRIPTION is null and SUBT.SHORT_DESCRIPTION is not null)
223: or (SUBB.SHORT_DESCRIPTION is not null and SUBT.SHORT_DESCRIPTION is null)
224: ));
225:
226: insert into JTF_IH_ACTIONS_TL (
227: ACTION_ID,
228: OBJECT_VERSION_NUMBER,
229: CREATED_BY,
230: CREATION_DATE,

Line 250: from JTF_IH_ACTIONS_TL B, FND_LANGUAGES L

246: B.ACTION,
247: B.SHORT_DESCRIPTION,
248: L.LANGUAGE_CODE,
249: B.SOURCE_LANG
250: from JTF_IH_ACTIONS_TL B, FND_LANGUAGES L
251: where L.INSTALLED_FLAG in ('I', 'B')
252: and B.LANGUAGE = userenv('LANG')
253: and not exists
254: (select NULL

Line 255: from JTF_IH_ACTIONS_TL T

251: where L.INSTALLED_FLAG in ('I', 'B')
252: and B.LANGUAGE = userenv('LANG')
253: and not exists
254: (select NULL
255: from JTF_IH_ACTIONS_TL T
256: where T.ACTION_ID = B.ACTION_ID
257: and T.LANGUAGE = L.LANGUAGE_CODE);
258: end ADD_LANGUAGE;
259:

Line 331: UPDATE jtf_ih_actions_tl SET

327: X_ACTION in VARCHAR2,
328: X_SHORT_DESCRIPTION in VARCHAR2,
329: X_OWNER IN VARCHAR2) is
330: begin
331: UPDATE jtf_ih_actions_tl SET
332: action_id = X_ACTION_ID,
333: action = X_ACTION,
334: short_description = X_SHORT_DESCRIPTION,
335: last_update_date = sysdate,