APPS.JTF_EVT_HANDLERS_PKG dependencies on JTF_EVT_HANDLERS_TL

Line 47: insert into JTF_EVT_HANDLERS_TL (

43: X_LAST_UPDATED_BY,
44: X_LAST_UPDATE_LOGIN
45: );
46:
47: insert into JTF_EVT_HANDLERS_TL (
48: SECURITY_GROUP_ID,
49: CREATION_DATE,
50: CREATED_BY,
51: LAST_UPDATE_LOGIN,

Line 73: from JTF_EVT_HANDLERS_TL T

69: from FND_LANGUAGES L
70: where L.INSTALLED_FLAG in ('I', 'B')
71: and not exists
72: (select NULL
73: from JTF_EVT_HANDLERS_TL T
74: where T.JTF_EVT_HANDLERS_ID = X_JTF_EVT_HANDLERS_ID
75: and T.LANGUAGE = L.LANGUAGE_CODE);
76:
77: open c;

Line 110: from JTF_EVT_HANDLERS_TL

106:
107: cursor c1 is select
108: JTF_EVT_HANDLERS_DESC,
109: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
110: from JTF_EVT_HANDLERS_TL
111: where JTF_EVT_HANDLERS_ID = X_JTF_EVT_HANDLERS_ID
112: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
113: for update of JTF_EVT_HANDLERS_ID nowait;
114: begin

Line 181: update JTF_EVT_HANDLERS_TL set

177: if (sql%notfound) then
178: raise no_data_found;
179: end if;
180:
181: update JTF_EVT_HANDLERS_TL set
182: JTF_EVT_HANDLERS_DESC = X_JTF_EVT_HANDLERS_DESC,
183: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
184: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
185: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 199: delete from JTF_EVT_HANDLERS_TL

195: procedure DELETE_ROW (
196: X_JTF_EVT_HANDLERS_ID in NUMBER
197: ) is
198: begin
199: delete from JTF_EVT_HANDLERS_TL
200: where JTF_EVT_HANDLERS_ID = X_JTF_EVT_HANDLERS_ID;
201:
202: if (sql%notfound) then
203: raise no_data_found;

Line 217: delete from JTF_EVT_HANDLERS_TL T

213:
214: procedure ADD_LANGUAGE
215: is
216: begin
217: delete from JTF_EVT_HANDLERS_TL T
218: where not exists
219: (select NULL
220: from JTF_EVT_HANDLERS_B B
221: where B.JTF_EVT_HANDLERS_ID = T.JTF_EVT_HANDLERS_ID

Line 224: update JTF_EVT_HANDLERS_TL T set (

220: from JTF_EVT_HANDLERS_B B
221: where B.JTF_EVT_HANDLERS_ID = T.JTF_EVT_HANDLERS_ID
222: );
223:
224: update JTF_EVT_HANDLERS_TL T set (
225: JTF_EVT_HANDLERS_DESC
226: ) = (select
227: B.JTF_EVT_HANDLERS_DESC
228: from JTF_EVT_HANDLERS_TL B

Line 228: from JTF_EVT_HANDLERS_TL B

224: update JTF_EVT_HANDLERS_TL T set (
225: JTF_EVT_HANDLERS_DESC
226: ) = (select
227: B.JTF_EVT_HANDLERS_DESC
228: from JTF_EVT_HANDLERS_TL B
229: where B.JTF_EVT_HANDLERS_ID = T.JTF_EVT_HANDLERS_ID
230: and B.LANGUAGE = T.SOURCE_LANG)
231: where (
232: T.JTF_EVT_HANDLERS_ID,

Line 237: from JTF_EVT_HANDLERS_TL SUBB, JTF_EVT_HANDLERS_TL SUBT

233: T.LANGUAGE
234: ) in (select
235: SUBT.JTF_EVT_HANDLERS_ID,
236: SUBT.LANGUAGE
237: from JTF_EVT_HANDLERS_TL SUBB, JTF_EVT_HANDLERS_TL SUBT
238: where SUBB.JTF_EVT_HANDLERS_ID = SUBT.JTF_EVT_HANDLERS_ID
239: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
240: and (SUBB.JTF_EVT_HANDLERS_DESC <> SUBT.JTF_EVT_HANDLERS_DESC
241: or (SUBB.JTF_EVT_HANDLERS_DESC is null and SUBT.JTF_EVT_HANDLERS_DESC is not null)

Line 245: insert into JTF_EVT_HANDLERS_TL (

241: or (SUBB.JTF_EVT_HANDLERS_DESC is null and SUBT.JTF_EVT_HANDLERS_DESC is not null)
242: or (SUBB.JTF_EVT_HANDLERS_DESC is not null and SUBT.JTF_EVT_HANDLERS_DESC is null)
243: ));
244:
245: insert into JTF_EVT_HANDLERS_TL (
246: SECURITY_GROUP_ID,
247: CREATION_DATE,
248: CREATED_BY,
249: LAST_UPDATE_LOGIN,

Line 267: from JTF_EVT_HANDLERS_TL B, FND_LANGUAGES L

263: B.LAST_UPDATED_BY,
264: B.JTF_EVT_HANDLERS_DESC,
265: L.LANGUAGE_CODE,
266: B.SOURCE_LANG
267: from JTF_EVT_HANDLERS_TL B, FND_LANGUAGES L
268: where L.INSTALLED_FLAG in ('I', 'B')
269: and B.LANGUAGE = userenv('LANG')
270: and not exists
271: (select NULL

Line 272: from JTF_EVT_HANDLERS_TL T

268: where L.INSTALLED_FLAG in ('I', 'B')
269: and B.LANGUAGE = userenv('LANG')
270: and not exists
271: (select NULL
272: from JTF_EVT_HANDLERS_TL T
273: where T.JTF_EVT_HANDLERS_ID = B.JTF_EVT_HANDLERS_ID
274: and T.LANGUAGE = L.LANGUAGE_CODE);
275: end ADD_LANGUAGE;
276:

Line 336: update JTF_EVT_HANDLERS_TL set

332: X_OWNER in VARCHAR2 -- owner fields
333: ) is
334:
335: begin
336: update JTF_EVT_HANDLERS_TL set
337: JTF_EVT_HANDLERS_DESC = x_JTF_EVT_HANDLERS_DESC,
338: LAST_UPDATE_DATE = sysdate,
339: LAST_UPDATED_BY = decode(x_owner, 'SEED', 1, 0),
340: LAST_UPDATE_LOGIN = 0,