APPS.JTF_PREFAB_UD_KEYS_PKG dependencies on JTF_PREFAB_UD_KEYS_TL

Line 54: insert into JTF_PREFAB_UD_KEYS_TL (

50: X_LAST_UPDATED_BY,
51: X_LAST_UPDATE_LOGIN
52: );
53:
54: insert into JTF_PREFAB_UD_KEYS_TL (
55: UD_KEY_ID,
56: DESCRIPTION,
57: CREATED_BY,
58: CREATION_DATE,

Line 80: from JTF_PREFAB_UD_KEYS_TL T

76: from FND_LANGUAGES L
77: where L.INSTALLED_FLAG in ('I', 'B')
78: and not exists
79: (select NULL
80: from JTF_PREFAB_UD_KEYS_TL T
81: where T.UD_KEY_ID = X_UD_KEY_ID
82: and T.LANGUAGE = L.LANGUAGE_CODE);
83:
84: open c;

Line 121: from JTF_PREFAB_UD_KEYS_TL

117:
118: cursor c1 is select
119: DESCRIPTION,
120: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
121: from JTF_PREFAB_UD_KEYS_TL
122: where UD_KEY_ID = X_UD_KEY_ID
123: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
124: for update of UD_KEY_ID nowait;
125: begin

Line 195: update JTF_PREFAB_UD_KEYS_TL set

191: if (sql%notfound) then
192: raise no_data_found;
193: end if;
194:
195: update JTF_PREFAB_UD_KEYS_TL set
196: DESCRIPTION = X_DESCRIPTION,
197: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
198: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
199: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 213: delete from JTF_PREFAB_UD_KEYS_TL

209: procedure DELETE_ROW (
210: X_UD_KEY_ID in NUMBER
211: ) is
212: begin
213: delete from JTF_PREFAB_UD_KEYS_TL
214: where UD_KEY_ID = X_UD_KEY_ID;
215:
216: if (sql%notfound) then
217: raise no_data_found;

Line 231: delete from JTF_PREFAB_UD_KEYS_TL T

227:
228: procedure ADD_LANGUAGE
229: is
230: begin
231: delete from JTF_PREFAB_UD_KEYS_TL T
232: where not exists
233: (select NULL
234: from JTF_PREFAB_UD_KEYS_B B
235: where B.UD_KEY_ID = T.UD_KEY_ID

Line 238: update JTF_PREFAB_UD_KEYS_TL T set (

234: from JTF_PREFAB_UD_KEYS_B B
235: where B.UD_KEY_ID = T.UD_KEY_ID
236: );
237:
238: update JTF_PREFAB_UD_KEYS_TL T set (
239: DESCRIPTION
240: ) = (select
241: B.DESCRIPTION
242: from JTF_PREFAB_UD_KEYS_TL B

Line 242: from JTF_PREFAB_UD_KEYS_TL B

238: update JTF_PREFAB_UD_KEYS_TL T set (
239: DESCRIPTION
240: ) = (select
241: B.DESCRIPTION
242: from JTF_PREFAB_UD_KEYS_TL B
243: where B.UD_KEY_ID = T.UD_KEY_ID
244: and B.LANGUAGE = T.SOURCE_LANG)
245: where (
246: T.UD_KEY_ID,

Line 251: from JTF_PREFAB_UD_KEYS_TL SUBB, JTF_PREFAB_UD_KEYS_TL SUBT

247: T.LANGUAGE
248: ) in (select
249: SUBT.UD_KEY_ID,
250: SUBT.LANGUAGE
251: from JTF_PREFAB_UD_KEYS_TL SUBB, JTF_PREFAB_UD_KEYS_TL SUBT
252: where SUBB.UD_KEY_ID = SUBT.UD_KEY_ID
253: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
254: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
255: ));

Line 257: insert into JTF_PREFAB_UD_KEYS_TL (

253: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
254: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
255: ));
256:
257: insert into JTF_PREFAB_UD_KEYS_TL (
258: UD_KEY_ID,
259: DESCRIPTION,
260: CREATED_BY,
261: CREATION_DATE,

Line 279: from JTF_PREFAB_UD_KEYS_TL B, FND_LANGUAGES L

275: B.LAST_UPDATE_LOGIN,
276: -- B.SECURITY_GROUP_ID,
277: L.LANGUAGE_CODE,
278: B.SOURCE_LANG
279: from JTF_PREFAB_UD_KEYS_TL B, FND_LANGUAGES L
280: where L.INSTALLED_FLAG in ('I', 'B')
281: and B.LANGUAGE = userenv('LANG')
282: and not exists
283: (select NULL

Line 284: from JTF_PREFAB_UD_KEYS_TL T

280: where L.INSTALLED_FLAG in ('I', 'B')
281: and B.LANGUAGE = userenv('LANG')
282: and not exists
283: (select NULL
284: from JTF_PREFAB_UD_KEYS_TL T
285: where T.UD_KEY_ID = B.UD_KEY_ID
286: and T.LANGUAGE = L.LANGUAGE_CODE);
287: end ADD_LANGUAGE;
288:

Line 405: FROM JTF_PREFAB_UD_KEYS_B b, JTF_PREFAB_UD_KEYS_TL tl

401:
402: begin
403: SELECT tl.UD_KEY_ID, tl.LAST_UPDATED_BY, tl.LAST_UPDATE_DATE
404: INTO l_ud_key_id, db_luby, db_ludate
405: FROM JTF_PREFAB_UD_KEYS_B b, JTF_PREFAB_UD_KEYS_TL tl
406: WHERE b.UD_KEY_ID = tl.UD_KEY_ID AND
407: b.APPLICATION_ID = X_APPLICATION_ID AND
408: b.UD_KEY_NAME = X_UD_KEY_NAME AND
409: tl.LANGUAGE = userenv('LANG');

Line 416: update JTF_PREFAB_UD_KEYS_TL set

412: ((f_luby = 0) AND (db_luby = 1)) OR
413: ((f_luby = db_luby) AND (f_ludate > db_ludate))
414: )
415: then
416: update JTF_PREFAB_UD_KEYS_TL set
417: DESCRIPTION = nvl(X_DESCRIPTION, DESCRIPTION),
418: LAST_UPDATE_DATE = f_ludate,
419: LAST_UPDATED_BY = f_luby,
420: LAST_UPDATE_LOGIN = 0,