APPS.AZ_SELECTION_SETS_PKG dependencies on AZ_SELECTION_SETS_TL

Line 56: insert into AZ_SELECTION_SETS_TL (

52: X_LAST_UPDATED_BY,
53: X_LAST_UPDATE_LOGIN
54: );
55:
56: insert into AZ_SELECTION_SETS_TL (
57: LAST_UPDATE_LOGIN,
58: SELECTION_SET_CODE,
59: USER_ID,
60: SELECTION_SET_NAME,

Line 84: from AZ_SELECTION_SETS_TL T

80: from FND_LANGUAGES L
81: where L.INSTALLED_FLAG in ('I', 'B')
82: and not exists
83: (select NULL
84: from AZ_SELECTION_SETS_TL T
85: where T.SELECTION_SET_CODE = X_SELECTION_SET_CODE
86: and T.USER_ID = X_USER_ID
87: and T.LANGUAGE = L.LANGUAGE_CODE);
88:

Line 122: from AZ_SELECTION_SETS_TL

118: cursor c1 is select
119: SELECTION_SET_NAME,
120: SELECTION_SET_DESC,
121: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
122: from AZ_SELECTION_SETS_TL
123: where SELECTION_SET_CODE = X_SELECTION_SET_CODE
124: and USER_ID = X_USER_ID
125: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
126: for update of SELECTION_SET_CODE nowait;

Line 196: update AZ_SELECTION_SETS_TL set

192: if (sql%notfound) then
193: raise no_data_found;
194: end if;
195:
196: update AZ_SELECTION_SETS_TL set
197: SELECTION_SET_NAME = X_SELECTION_SET_NAME,
198: SELECTION_SET_DESC = X_SELECTION_SET_DESC,
199: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
200: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 217: delete from AZ_SELECTION_SETS_TL

213: X_SELECTION_SET_CODE in VARCHAR2,
214: X_USER_ID in NUMBER
215: ) is
216: begin
217: delete from AZ_SELECTION_SETS_TL
218: where SELECTION_SET_CODE = X_SELECTION_SET_CODE
219: and USER_ID = X_USER_ID;
220:
221: if (sql%notfound) then

Line 237: delete from AZ_SELECTION_SETS_TL T

233:
234: procedure ADD_LANGUAGE
235: is
236: begin
237: delete from AZ_SELECTION_SETS_TL T
238: where not exists
239: (select NULL
240: from AZ_SELECTION_SETS_B B
241: where B.SELECTION_SET_CODE = T.SELECTION_SET_CODE

Line 245: update AZ_SELECTION_SETS_TL T set (

241: where B.SELECTION_SET_CODE = T.SELECTION_SET_CODE
242: and B.USER_ID = T.USER_ID
243: );
244:
245: update AZ_SELECTION_SETS_TL T set (
246: SELECTION_SET_NAME,
247: SELECTION_SET_DESC
248: ) = (select
249: B.SELECTION_SET_NAME,

Line 251: from AZ_SELECTION_SETS_TL B

247: SELECTION_SET_DESC
248: ) = (select
249: B.SELECTION_SET_NAME,
250: B.SELECTION_SET_DESC
251: from AZ_SELECTION_SETS_TL B
252: where B.SELECTION_SET_CODE = T.SELECTION_SET_CODE
253: and B.USER_ID = T.USER_ID
254: and B.LANGUAGE = T.SOURCE_LANG)
255: where (

Line 263: from AZ_SELECTION_SETS_TL SUBB, AZ_SELECTION_SETS_TL SUBT

259: ) in (select
260: SUBT.SELECTION_SET_CODE,
261: SUBT.USER_ID,
262: SUBT.LANGUAGE
263: from AZ_SELECTION_SETS_TL SUBB, AZ_SELECTION_SETS_TL SUBT
264: where SUBB.SELECTION_SET_CODE = SUBT.SELECTION_SET_CODE
265: and SUBB.USER_ID = SUBT.USER_ID
266: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
267: and (SUBB.SELECTION_SET_NAME <> SUBT.SELECTION_SET_NAME

Line 273: insert into AZ_SELECTION_SETS_TL (

269: or (SUBB.SELECTION_SET_DESC is null and SUBT.SELECTION_SET_DESC is not null)
270: or (SUBB.SELECTION_SET_DESC is not null and SUBT.SELECTION_SET_DESC is null)
271: ));
272:
273: insert into AZ_SELECTION_SETS_TL (
274: LAST_UPDATE_LOGIN,
275: SELECTION_SET_CODE,
276: USER_ID,
277: SELECTION_SET_NAME,

Line 297: from AZ_SELECTION_SETS_TL B, FND_LANGUAGES L

293: B.LAST_UPDATED_BY,
294: B.LAST_UPDATE_DATE,
295: L.LANGUAGE_CODE,
296: B.SOURCE_LANG
297: from AZ_SELECTION_SETS_TL B, FND_LANGUAGES L
298: where L.INSTALLED_FLAG in ('I', 'B')
299: and B.LANGUAGE = userenv('LANG')
300: and not exists
301: (select NULL

Line 302: from AZ_SELECTION_SETS_TL T

298: where L.INSTALLED_FLAG in ('I', 'B')
299: and B.LANGUAGE = userenv('LANG')
300: and not exists
301: (select NULL
302: from AZ_SELECTION_SETS_TL T
303: where T.SELECTION_SET_CODE = B.SELECTION_SET_CODE
304: and T.USER_ID = B.USER_ID
305: and T.LANGUAGE = L.LANGUAGE_CODE);
306: end ADD_LANGUAGE;

Line 315: update AZ_SELECTION_SETS_TL set

311: X_SELECTION_SET_NAME in VARCHAR2,
312: X_OWNER in VARCHAR2,
313: X_SELECTION_SET_DESC in VARCHAR2 ) is
314: begin
315: update AZ_SELECTION_SETS_TL set
316: SELECTION_SET_NAME = X_SELECTION_SET_NAME,
317: SELECTION_SET_DESC = X_SELECTION_SET_DESC,
318: last_update_date = sysdate,
319: last_updated_by = decode(X_OWNER, 'SEED', 1, 0),