APPS.JTF_PREFAB_FILTERS_PKG dependencies on JTF_PREFAB_FILTERS_TL

Line 54: insert into JTF_PREFAB_FILTERS_TL (

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

Line 80: from JTF_PREFAB_FILTERS_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_FILTERS_TL T
81: where T.FILTER_ID = X_FILTER_ID
82: and T.LANGUAGE = L.LANGUAGE_CODE);
83:
84: open c;

Line 121: from JTF_PREFAB_FILTERS_TL

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

Line 195: update JTF_PREFAB_FILTERS_TL set

191: if (sql%notfound) then
192: raise no_data_found;
193: end if;
194:
195: update JTF_PREFAB_FILTERS_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_FILTERS_TL

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

Line 231: delete from JTF_PREFAB_FILTERS_TL T

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

Line 238: update JTF_PREFAB_FILTERS_TL T set (

234: from JTF_PREFAB_FILTERS_B B
235: where B.FILTER_ID = T.FILTER_ID
236: );
237:
238: update JTF_PREFAB_FILTERS_TL T set (
239: DESCRIPTION
240: ) = (select
241: B.DESCRIPTION
242: from JTF_PREFAB_FILTERS_TL B

Line 242: from JTF_PREFAB_FILTERS_TL B

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

Line 251: from JTF_PREFAB_FILTERS_TL SUBB, JTF_PREFAB_FILTERS_TL SUBT

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

Line 257: insert into JTF_PREFAB_FILTERS_TL (

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

Line 279: from JTF_PREFAB_FILTERS_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_FILTERS_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_FILTERS_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_FILTERS_TL T
285: where T.FILTER_ID = B.FILTER_ID
286: and T.LANGUAGE = L.LANGUAGE_CODE);
287: end ADD_LANGUAGE;
288:

Line 405: FROM JTF_PREFAB_FILTERS_B b, JTF_PREFAB_FILTERS_TL tl

401:
402: begin
403: SELECT tl.FILTER_ID, tl.LAST_UPDATED_BY, tl.LAST_UPDATE_DATE
404: INTO l_filter_id, db_luby, db_ludate
405: FROM JTF_PREFAB_FILTERS_B b, JTF_PREFAB_FILTERS_TL tl
406: WHERE b.FILTER_ID = tl.FILTER_ID AND
407: b.APPLICATION_ID = X_APPLICATION_ID AND
408: b.FILTER_NAME = X_FILTER_NAME AND
409: tl.LANGUAGE = userenv('LANG');

Line 416: update JTF_PREFAB_FILTERS_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_FILTERS_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,