APPS.JTF_PREFAB_CA_FILTERS_PKG dependencies on JTF_PREFAB_CA_FILTERS_TL

Line 41: insert into JTF_PREFAB_CA_FILTERS_TL (

37: X_LAST_UPDATED_BY,
38: X_LAST_UPDATE_LOGIN
39: );
40:
41: insert into JTF_PREFAB_CA_FILTERS_TL (
42: DESCRIPTION,
43: CREATED_BY,
44: CREATION_DATE,
45: LAST_UPDATED_BY,

Line 67: from JTF_PREFAB_CA_FILTERS_TL T

63: from FND_LANGUAGES L
64: where L.INSTALLED_FLAG in ('I', 'B')
65: and not exists
66: (select NULL
67: from JTF_PREFAB_CA_FILTERS_TL T
68: where T.CA_FILTER_ID = X_CA_FILTER_ID
69: and T.LANGUAGE = L.LANGUAGE_CODE);
70:
71: end INSERT_ROW;

Line 94: from JTF_PREFAB_CA_FILTERS_TL

90:
91: cursor c1 is select
92: DESCRIPTION,
93: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
94: from JTF_PREFAB_CA_FILTERS_TL
95: where CA_FILTER_ID = X_CA_FILTER_ID
96: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
97: for update of CA_FILTER_ID nowait;
98: begin

Line 159: update JTF_PREFAB_CA_FILTERS_TL set

155: if (sql%notfound) then
156: raise no_data_found;
157: end if;
158:
159: update JTF_PREFAB_CA_FILTERS_TL set
160: DESCRIPTION = X_DESCRIPTION,
161: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
162: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
163: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 177: delete from JTF_PREFAB_CA_FILTERS_TL

173: procedure DELETE_ROW (
174: X_CA_FILTER_ID in NUMBER
175: ) is
176: begin
177: delete from JTF_PREFAB_CA_FILTERS_TL
178: where CA_FILTER_ID = X_CA_FILTER_ID;
179:
180: if (sql%notfound) then
181: raise no_data_found;

Line 195: delete from JTF_PREFAB_CA_FILTERS_TL T

191:
192: procedure ADD_LANGUAGE
193: is
194: begin
195: delete from JTF_PREFAB_CA_FILTERS_TL T
196: where not exists
197: (select NULL
198: from JTF_PREFAB_CA_FILTERS_B B
199: where B.CA_FILTER_ID = T.CA_FILTER_ID

Line 202: update JTF_PREFAB_CA_FILTERS_TL T set (

198: from JTF_PREFAB_CA_FILTERS_B B
199: where B.CA_FILTER_ID = T.CA_FILTER_ID
200: );
201:
202: update JTF_PREFAB_CA_FILTERS_TL T set (
203: DESCRIPTION
204: ) = (select
205: B.DESCRIPTION
206: from JTF_PREFAB_CA_FILTERS_TL B

Line 206: from JTF_PREFAB_CA_FILTERS_TL B

202: update JTF_PREFAB_CA_FILTERS_TL T set (
203: DESCRIPTION
204: ) = (select
205: B.DESCRIPTION
206: from JTF_PREFAB_CA_FILTERS_TL B
207: where B.CA_FILTER_ID = T.CA_FILTER_ID
208: and B.LANGUAGE = T.SOURCE_LANG)
209: where (
210: T.CA_FILTER_ID,

Line 215: from JTF_PREFAB_CA_FILTERS_TL SUBB, JTF_PREFAB_CA_FILTERS_TL SUBT

211: T.LANGUAGE
212: ) in (select
213: SUBT.CA_FILTER_ID,
214: SUBT.LANGUAGE
215: from JTF_PREFAB_CA_FILTERS_TL SUBB, JTF_PREFAB_CA_FILTERS_TL SUBT
216: where SUBB.CA_FILTER_ID = SUBT.CA_FILTER_ID
217: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
218: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
219: ));

Line 221: insert into JTF_PREFAB_CA_FILTERS_TL (

217: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
218: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
219: ));
220:
221: insert into JTF_PREFAB_CA_FILTERS_TL (
222: DESCRIPTION,
223: CREATED_BY,
224: CREATION_DATE,
225: LAST_UPDATED_BY,

Line 243: from JTF_PREFAB_CA_FILTERS_TL B, FND_LANGUAGES L

239: -- B.SECURITY_GROUP_ID,
240: B.CA_FILTER_ID,
241: L.LANGUAGE_CODE,
242: B.SOURCE_LANG
243: from JTF_PREFAB_CA_FILTERS_TL B, FND_LANGUAGES L
244: where L.INSTALLED_FLAG in ('I', 'B')
245: and B.LANGUAGE = userenv('LANG')
246: and not exists
247: (select NULL

Line 248: from JTF_PREFAB_CA_FILTERS_TL T

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

Line 413: FROM JTF_PREFAB_CA_FILTERS_B b, JTF_PREFAB_CA_FILTERS_TL tl

409:
410: begin
411: SELECT tl.CA_FILTER_ID, tl.LAST_UPDATED_BY, tl.LAST_UPDATE_DATE
412: INTO l_ca_filter_id, db_luby, db_ludate
413: FROM JTF_PREFAB_CA_FILTERS_B b, JTF_PREFAB_CA_FILTERS_TL tl
414: WHERE b.CA_FILTER_ID = tl.CA_FILTER_ID AND
415: b.APPLICATION_ID = X_APPLICATION_ID AND
416: b.CA_FILTER_NAME = X_CA_FILTER_NAME AND
417: tl.LANGUAGE = userenv('LANG');

Line 424: update JTF_PREFAB_CA_FILTERS_TL set

420: ((f_luby = 0) AND (db_luby = 1)) OR
421: ((f_luby = db_luby) AND (f_ludate >= db_ludate))
422: )
423: then
424: update JTF_PREFAB_CA_FILTERS_TL set
425: DESCRIPTION = nvl(X_DESCRIPTION, DESCRIPTION),
426: LAST_UPDATE_DATE = f_ludate,
427: LAST_UPDATED_BY = f_luby,
428: LAST_UPDATE_LOGIN = 0,