APPS.AMS_IBA_PS_FILTERS_PKG dependencies on AMS_IBA_PS_FILTERS_TL

Line 41: insert into AMS_IBA_PS_FILTERS_TL (

37: P_LAST_UPDATED_BY,
38: P_LAST_UPDATE_LOGIN
39: );
40:
41: insert into AMS_IBA_PS_FILTERS_TL (
42: CREATED_BY,
43: CREATION_DATE,
44: LAST_UPDATED_BY,
45: LAST_UPDATE_DATE,

Line 67: from AMS_IBA_PS_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 AMS_IBA_PS_FILTERS_TL T
68: where T.FILTER_ID = P_FILTER_ID
69: and T.LANGUAGE = L.LANGUAGE_CODE);
70:
71: end INSERT_ROW;

Line 94: from AMS_IBA_PS_FILTERS_TL

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

Line 163: update AMS_IBA_PS_FILTERS_TL set

159: if (sql%notfound) then
160: raise no_data_found;
161: end if;
162:
163: update AMS_IBA_PS_FILTERS_TL set
164: FILTER_NAME = P_FILTER_NAME,
165: LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,
166: LAST_UPDATED_BY = P_LAST_UPDATED_BY,
167: LAST_UPDATE_LOGIN = P_LAST_UPDATE_LOGIN,

Line 182: delete from AMS_IBA_PS_FILTERS_TL

178: procedure DELETE_ROW (
179: P_FILTER_ID in NUMBER
180: ) is
181: begin
182: delete from AMS_IBA_PS_FILTERS_TL
183: where FILTER_ID = P_FILTER_ID;
184:
185: if (sql%notfound) then
186: raise no_data_found;

Line 200: delete from AMS_IBA_PS_FILTERS_TL T

196:
197: procedure ADD_LANGUAGE
198: is
199: begin
200: delete from AMS_IBA_PS_FILTERS_TL T
201: where not exists
202: (select NULL
203: from AMS_IBA_PS_FILTERS_B B
204: where B.FILTER_ID = T.FILTER_ID

Line 207: update AMS_IBA_PS_FILTERS_TL T set (

203: from AMS_IBA_PS_FILTERS_B B
204: where B.FILTER_ID = T.FILTER_ID
205: );
206:
207: update AMS_IBA_PS_FILTERS_TL T set (
208: FILTER_NAME
209: ) = (select
210: B.FILTER_NAME
211: from AMS_IBA_PS_FILTERS_TL B

Line 211: from AMS_IBA_PS_FILTERS_TL B

207: update AMS_IBA_PS_FILTERS_TL T set (
208: FILTER_NAME
209: ) = (select
210: B.FILTER_NAME
211: from AMS_IBA_PS_FILTERS_TL B
212: where B.FILTER_ID = T.FILTER_ID
213: and B.LANGUAGE = T.SOURCE_LANG)
214: where (
215: T.FILTER_ID,

Line 220: from AMS_IBA_PS_FILTERS_TL SUBB, AMS_IBA_PS_FILTERS_TL SUBT

216: T.LANGUAGE
217: ) in (select
218: SUBT.FILTER_ID,
219: SUBT.LANGUAGE
220: from AMS_IBA_PS_FILTERS_TL SUBB, AMS_IBA_PS_FILTERS_TL SUBT
221: where SUBB.FILTER_ID = SUBT.FILTER_ID
222: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
223: and (SUBB.FILTER_NAME <> SUBT.FILTER_NAME
224: ));

Line 226: insert into AMS_IBA_PS_FILTERS_TL (

222: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
223: and (SUBB.FILTER_NAME <> SUBT.FILTER_NAME
224: ));
225:
226: insert into AMS_IBA_PS_FILTERS_TL (
227: CREATED_BY,
228: CREATION_DATE,
229: LAST_UPDATED_BY,
230: LAST_UPDATE_DATE,

Line 248: from AMS_IBA_PS_FILTERS_TL B, FND_LANGUAGES L

244: B.FILTER_ID,
245: B.FILTER_NAME,
246: L.LANGUAGE_CODE,
247: B.SOURCE_LANG
248: from AMS_IBA_PS_FILTERS_TL B, FND_LANGUAGES L
249: where L.INSTALLED_FLAG in ('I', 'B')
250: and B.LANGUAGE = userenv('LANG')
251: and not exists
252: (select NULL

Line 253: from AMS_IBA_PS_FILTERS_TL T

249: where L.INSTALLED_FLAG in ('I', 'B')
250: and B.LANGUAGE = userenv('LANG')
251: and not exists
252: (select NULL
253: from AMS_IBA_PS_FILTERS_TL T
254: where T.FILTER_ID = B.FILTER_ID
255: and T.LANGUAGE = L.LANGUAGE_CODE);
256: end ADD_LANGUAGE;
257:

Line 266: update ams_iba_ps_filters_tl set

262: x_owner IN VARCHAR2
263: )
264: IS
265: BEGIN
266: update ams_iba_ps_filters_tl set
267: filter_name = nvl(x_filter_name, filter_name),
268: source_lang = userenv('LANG'),
269: last_update_date = sysdate,
270: last_updated_by = decode(x_owner, 'SEED', 1, 0),