APPS.JTF_IH_ACTION_ITEMS_SEED_PVT dependencies on JTF_IH_ACTION_ITEMS_TL

Line 37: insert into JTF_IH_ACTION_ITEMS_TL (

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

Line 65: from JTF_IH_ACTION_ITEMS_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_ACTION_ITEMS_TL T
66: where T.ACTION_ITEM_ID = X_ACTION_ITEM_ID
67: and T.LANGUAGE = L.LANGUAGE_CODE);
68:
69: open c;

Line 96: from JTF_IH_ACTION_ITEMS_TL

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

Line 154: update JTF_IH_ACTION_ITEMS_TL set

150: if (sql%notfound) then
151: raise no_data_found;
152: end if;
153:
154: update JTF_IH_ACTION_ITEMS_TL set
155: ACTION_ITEM = X_ACTION_ITEM,
156: SHORT_DESCRIPTION = X_SHORT_DESCRIPTION,
157: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
158: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 173: delete from JTF_IH_ACTION_ITEMS_TL

169: procedure DELETE_ROW (
170: X_ACTION_ITEM_ID in NUMBER
171: ) is
172: begin
173: delete from JTF_IH_ACTION_ITEMS_TL
174: where ACTION_ITEM_ID = X_ACTION_ITEM_ID;
175:
176: if (sql%notfound) then
177: raise no_data_found;

Line 191: delete from JTF_IH_ACTION_ITEMS_TL T

187:
188: procedure ADD_LANGUAGE
189: is
190: begin
191: delete from JTF_IH_ACTION_ITEMS_TL T
192: where not exists
193: (select NULL
194: from JTF_IH_ACTION_ITEMS_B B
195: where B.ACTION_ITEM_ID = T.ACTION_ITEM_ID

Line 198: update JTF_IH_ACTION_ITEMS_TL T set (

194: from JTF_IH_ACTION_ITEMS_B B
195: where B.ACTION_ITEM_ID = T.ACTION_ITEM_ID
196: );
197:
198: update JTF_IH_ACTION_ITEMS_TL T set (
199: ACTION_ITEM,
200: SHORT_DESCRIPTION
201: ) = (select
202: B.ACTION_ITEM,

Line 204: from JTF_IH_ACTION_ITEMS_TL B

200: SHORT_DESCRIPTION
201: ) = (select
202: B.ACTION_ITEM,
203: B.SHORT_DESCRIPTION
204: from JTF_IH_ACTION_ITEMS_TL B
205: where B.ACTION_ITEM_ID = T.ACTION_ITEM_ID
206: and B.LANGUAGE = T.SOURCE_LANG)
207: where (
208: T.ACTION_ITEM_ID,

Line 213: from JTF_IH_ACTION_ITEMS_TL SUBB, JTF_IH_ACTION_ITEMS_TL SUBT

209: T.LANGUAGE
210: ) in (select
211: SUBT.ACTION_ITEM_ID,
212: SUBT.LANGUAGE
213: from JTF_IH_ACTION_ITEMS_TL SUBB, JTF_IH_ACTION_ITEMS_TL SUBT
214: where SUBB.ACTION_ITEM_ID = SUBT.ACTION_ITEM_ID
215: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
216: and (SUBB.ACTION_ITEM <> SUBT.ACTION_ITEM
217: or SUBB.SHORT_DESCRIPTION <> SUBT.SHORT_DESCRIPTION

Line 220: insert into JTF_IH_ACTION_ITEMS_TL (

216: and (SUBB.ACTION_ITEM <> SUBT.ACTION_ITEM
217: or SUBB.SHORT_DESCRIPTION <> SUBT.SHORT_DESCRIPTION
218: ));
219:
220: insert into JTF_IH_ACTION_ITEMS_TL (
221: ACTION_ITEM_ID,
222: OBJECT_VERSION_NUMBER,
223: CREATED_BY,
224: CREATION_DATE,

Line 244: from JTF_IH_ACTION_ITEMS_TL B, FND_LANGUAGES L

240: B.ACTION_ITEM,
241: B.SHORT_DESCRIPTION,
242: L.LANGUAGE_CODE,
243: B.SOURCE_LANG
244: from JTF_IH_ACTION_ITEMS_TL B, FND_LANGUAGES L
245: where L.INSTALLED_FLAG in ('I', 'B')
246: and B.LANGUAGE = userenv('LANG')
247: and not exists
248: (select NULL

Line 249: from JTF_IH_ACTION_ITEMS_TL T

245: where L.INSTALLED_FLAG in ('I', 'B')
246: and B.LANGUAGE = userenv('LANG')
247: and not exists
248: (select NULL
249: from JTF_IH_ACTION_ITEMS_TL T
250: where T.ACTION_ITEM_ID = B.ACTION_ITEM_ID
251: and T.LANGUAGE = L.LANGUAGE_CODE);
252: end ADD_LANGUAGE;
253: procedure LOAD_ROW (

Line 324: UPDATE jtf_ih_action_items_tl SET

320: X_ACTION_ITEM in VARCHAR2,
321: X_SHORT_DESCRIPTION in VARCHAR2,
322: X_OWNER IN VARCHAR2) is
323: begin
324: UPDATE jtf_ih_action_items_tl SET
325: action_item_id = X_ACTION_ITEM_ID,
326: action_item = X_ACTION_ITEM,
327: short_description = X_SHORT_DESCRIPTION,
328: last_update_date = sysdate,