APPS.JTF_UM_TEMPLATES_PKG dependencies on JTF_UM_TEMPLATES_TL

Line 57: insert into JTF_UM_TEMPLATES_TL (

53: X_LAST_UPDATED_BY,
54: X_LAST_UPDATE_LOGIN
55: )RETURNING TEMPLATE_ID INTO X_TEMPLATE_ID;
56:
57: insert into JTF_UM_TEMPLATES_TL (
58: TEMPLATE_ID,
59: TEMPLATE_NAME,
60: CREATED_BY,
61: CREATION_DATE,

Line 83: from JTF_UM_TEMPLATES_TL T

79: from FND_LANGUAGES L
80: where L.INSTALLED_FLAG in ('I', 'B')
81: and not exists
82: (select NULL
83: from JTF_UM_TEMPLATES_TL T
84: where T.TEMPLATE_ID = X_TEMPLATE_ID
85: and T.LANGUAGE = L.LANGUAGE_CODE);
86:
87: open c;

Line 127: from JTF_UM_TEMPLATES_TL

123: cursor c1 is select
124: TEMPLATE_NAME,
125: DESCRIPTION,
126: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
127: from JTF_UM_TEMPLATES_TL
128: where TEMPLATE_ID = X_TEMPLATE_ID
129: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
130: for update of TEMPLATE_ID nowait;
131: begin

Line 205: update JTF_UM_TEMPLATES_TL set

201: if (sql%notfound) then
202: raise no_data_found;
203: end if;
204:
205: update JTF_UM_TEMPLATES_TL set
206: TEMPLATE_NAME = X_TEMPLATE_NAME,
207: DESCRIPTION = X_DESCRIPTION,
208: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
209: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 224: delete from JTF_UM_TEMPLATES_TL

220: procedure DELETE_ROW (
221: X_TEMPLATE_ID in NUMBER
222: ) is
223: begin
224: delete from JTF_UM_TEMPLATES_TL
225: where TEMPLATE_ID = X_TEMPLATE_ID;
226:
227: if (sql%notfound) then
228: raise no_data_found;

Line 242: delete from JTF_UM_TEMPLATES_TL T

238:
239: procedure ADD_LANGUAGE
240: is
241: begin
242: delete from JTF_UM_TEMPLATES_TL T
243: where not exists
244: (select NULL
245: from JTF_UM_TEMPLATES_B B
246: where B.TEMPLATE_ID = T.TEMPLATE_ID

Line 249: update JTF_UM_TEMPLATES_TL T set (

245: from JTF_UM_TEMPLATES_B B
246: where B.TEMPLATE_ID = T.TEMPLATE_ID
247: );
248:
249: update JTF_UM_TEMPLATES_TL T set (
250: TEMPLATE_NAME,
251: DESCRIPTION
252: ) = (select
253: B.TEMPLATE_NAME,

Line 255: from JTF_UM_TEMPLATES_TL B

251: DESCRIPTION
252: ) = (select
253: B.TEMPLATE_NAME,
254: B.DESCRIPTION
255: from JTF_UM_TEMPLATES_TL B
256: where B.TEMPLATE_ID = T.TEMPLATE_ID
257: and B.LANGUAGE = T.SOURCE_LANG)
258: where (
259: T.TEMPLATE_ID,

Line 264: from JTF_UM_TEMPLATES_TL SUBB, JTF_UM_TEMPLATES_TL SUBT

260: T.LANGUAGE
261: ) in (select
262: SUBT.TEMPLATE_ID,
263: SUBT.LANGUAGE
264: from JTF_UM_TEMPLATES_TL SUBB, JTF_UM_TEMPLATES_TL SUBT
265: where SUBB.TEMPLATE_ID = SUBT.TEMPLATE_ID
266: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
267: and (SUBB.TEMPLATE_NAME <> SUBT.TEMPLATE_NAME
268: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 273: insert into JTF_UM_TEMPLATES_TL (

269: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
270: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
271: ));
272:
273: insert into JTF_UM_TEMPLATES_TL (
274: TEMPLATE_ID,
275: TEMPLATE_NAME,
276: CREATED_BY,
277: CREATION_DATE,

Line 295: from JTF_UM_TEMPLATES_TL B, FND_LANGUAGES L

291: B.LAST_UPDATE_LOGIN,
292: B.DESCRIPTION,
293: L.LANGUAGE_CODE,
294: B.SOURCE_LANG
295: from JTF_UM_TEMPLATES_TL B, FND_LANGUAGES L
296: where L.INSTALLED_FLAG in ('I', 'B')
297: and B.LANGUAGE = userenv('LANG')
298: and not exists
299: (select NULL

Line 300: from JTF_UM_TEMPLATES_TL T

296: where L.INSTALLED_FLAG in ('I', 'B')
297: and B.LANGUAGE = userenv('LANG')
298: and not exists
299: (select NULL
300: from JTF_UM_TEMPLATES_TL T
301: where T.TEMPLATE_ID = B.TEMPLATE_ID
302: and T.LANGUAGE = L.LANGUAGE_CODE);
303: end ADD_LANGUAGE;
304:

Line 427: FROM JTF_UM_TEMPLATES_TL

423: -- there is a row for this app_id and this app_short_name
424: -- Exception is thrown otherwise.
425: select LAST_UPDATED_BY, LAST_UPDATE_DATE
426: into db_luby, db_ludate
427: FROM JTF_UM_TEMPLATES_TL
428: where TEMPLATE_ID = X_TEMPLATE_ID
429: and LANGUAGE = userenv('LANG');
430:
431: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 435: update JTF_UM_TEMPLATES_TL set

431: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
432: db_ludate, X_CUSTOM_MODE)) then
433:
434:
435: update JTF_UM_TEMPLATES_TL set
436: TEMPLATE_NAME = X_TEMPLATE_NAME,
437: DESCRIPTION = X_DESCRIPTION,
438: LAST_UPDATE_DATE = f_ludate,
439: LAST_UPDATED_BY = f_luby,