[Home] [Help]
67: X_LAST_UPDATED_BY,
68: X_LAST_UPDATE_LOGIN
69: );
70:
71: insert into AZ_SELECTION_SET_ENTITIES_TL (
72: LAST_UPDATE_LOGIN,
73: ENTITY_OCCURANCE_CODE,
74: USER_ID,
75: LAST_UPDATE_DATE,
95: from FND_LANGUAGES L
96: where L.INSTALLED_FLAG in ('I', 'B')
97: and not exists
98: (select NULL
99: from AZ_SELECTION_SET_ENTITIES_TL T
100: where T.SELECTION_SET_CODE = X_SELECTION_SET_CODE
101: and T.USER_ID = X_USER_ID
102: and T.ENTITY_OCCURANCE_CODE = X_ENTITY_OCCURANCE_CODE
103: and T.LANGUAGE = L.LANGUAGE_CODE);
144:
145: cursor c1 is select
146: ENTITY_OCCURANCE_NAME,
147: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
148: from AZ_SELECTION_SET_ENTITIES_TL
149: where SELECTION_SET_CODE = X_SELECTION_SET_CODE
150: and USER_ID = X_USER_ID
151: and ENTITY_OCCURANCE_CODE = X_ENTITY_OCCURANCE_CODE
152: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
239: if (sql%notfound) then
240: raise no_data_found;
241: end if;
242:
243: update AZ_SELECTION_SET_ENTITIES_TL set
244: ENTITY_OCCURANCE_NAME = X_ENTITY_OCCURANCE_NAME,
245: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
246: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
247: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
261: X_USER_ID in NUMBER,
262: X_ENTITY_OCCURANCE_CODE in VARCHAR2
263: ) is
264: begin
265: delete from AZ_SELECTION_SET_ENTITIES_TL
266: where SELECTION_SET_CODE = X_SELECTION_SET_CODE
267: and USER_ID = X_USER_ID
268: and ENTITY_OCCURANCE_CODE = X_ENTITY_OCCURANCE_CODE;
269:
283:
284: procedure ADD_LANGUAGE
285: is
286: begin
287: delete from AZ_SELECTION_SET_ENTITIES_TL T
288: where not exists
289: (select NULL
290: from AZ_SELECTION_SET_ENTITIES_B B
291: where B.SELECTION_SET_CODE = T.SELECTION_SET_CODE
292: and B.USER_ID = T.USER_ID
293: and B.ENTITY_OCCURANCE_CODE = T.ENTITY_OCCURANCE_CODE
294: );
295:
296: update AZ_SELECTION_SET_ENTITIES_TL T set (
297: ENTITY_OCCURANCE_NAME
298: ) = (select
299: B.ENTITY_OCCURANCE_NAME
300: from AZ_SELECTION_SET_ENTITIES_TL B
296: update AZ_SELECTION_SET_ENTITIES_TL T set (
297: ENTITY_OCCURANCE_NAME
298: ) = (select
299: B.ENTITY_OCCURANCE_NAME
300: from AZ_SELECTION_SET_ENTITIES_TL B
301: where B.SELECTION_SET_CODE = T.SELECTION_SET_CODE
302: and B.USER_ID = T.USER_ID
303: and B.ENTITY_OCCURANCE_CODE = T.ENTITY_OCCURANCE_CODE
304: and B.LANGUAGE = T.SOURCE_LANG)
311: SUBT.SELECTION_SET_CODE,
312: SUBT.USER_ID,
313: SUBT.ENTITY_OCCURANCE_CODE,
314: SUBT.LANGUAGE
315: from AZ_SELECTION_SET_ENTITIES_TL SUBB, AZ_SELECTION_SET_ENTITIES_TL SUBT
316: where SUBB.SELECTION_SET_CODE = SUBT.SELECTION_SET_CODE
317: and SUBB.USER_ID = SUBT.USER_ID
318: and SUBB.ENTITY_OCCURANCE_CODE = SUBT.ENTITY_OCCURANCE_CODE
319: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
321: or (SUBB.ENTITY_OCCURANCE_NAME is null and SUBT.ENTITY_OCCURANCE_NAME is not null)
322: or (SUBB.ENTITY_OCCURANCE_NAME is not null and SUBT.ENTITY_OCCURANCE_NAME is null)
323: ));
324:
325: insert into AZ_SELECTION_SET_ENTITIES_TL (
326: LAST_UPDATE_LOGIN,
327: ENTITY_OCCURANCE_CODE,
328: USER_ID,
329: LAST_UPDATE_DATE,
345: B.CREATED_BY,
346: B.CREATION_DATE,
347: L.LANGUAGE_CODE,
348: B.SOURCE_LANG
349: from AZ_SELECTION_SET_ENTITIES_TL B, FND_LANGUAGES L
350: where L.INSTALLED_FLAG in ('I', 'B')
351: and B.LANGUAGE = userenv('LANG')
352: and not exists
353: (select NULL
350: where L.INSTALLED_FLAG in ('I', 'B')
351: and B.LANGUAGE = userenv('LANG')
352: and not exists
353: (select NULL
354: from AZ_SELECTION_SET_ENTITIES_TL T
355: where T.SELECTION_SET_CODE = B.SELECTION_SET_CODE
356: and T.USER_ID = B.USER_ID
357: and T.ENTITY_OCCURANCE_CODE = B.ENTITY_OCCURANCE_CODE
358: and T.LANGUAGE = L.LANGUAGE_CODE);
365: X_ENTITY_OCCURANCE_CODE in VARCHAR2,
366: X_ENTITY_OCCURANCE_NAME in VARCHAR2,
367: X_OWNER in VARCHAR2 ) is
368: begin
369: update AZ_SELECTION_SET_ENTITIES_TL set
370: ENTITY_OCCURANCE_NAME = X_ENTITY_OCCURANCE_NAME,
371: last_update_date = sysdate,
372: last_updated_by = decode(X_OWNER, 'SEED', 1, 0),
373: last_update_login = 0,