[Home] [Help]
47: X_LAST_UPDATE_LOGIN,
48: X_READ_ONLY_FLAG
49: );
50:
51: insert into BNE_CONTENT_COLS_TL (
52: APPLICATION_ID,
53: CONTENT_CODE,
54: SEQUENCE_NUM,
55: USER_NAME,
75: from FND_LANGUAGES L
76: where L.INSTALLED_FLAG in ('I', 'B')
77: and not exists
78: (select NULL
79: from BNE_CONTENT_COLS_TL T
80: where T.APPLICATION_ID = X_APPLICATION_ID
81: and T.CONTENT_CODE = X_CONTENT_CODE
82: and T.SEQUENCE_NUM = X_SEQUENCE_NUM
83: and T.LANGUAGE = L.LANGUAGE_CODE);
114:
115: cursor c1 is select
116: USER_NAME,
117: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
118: from BNE_CONTENT_COLS_TL
119: where APPLICATION_ID = X_APPLICATION_ID
120: and CONTENT_CODE = X_CONTENT_CODE
121: and SEQUENCE_NUM = X_SEQUENCE_NUM
122: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
182: if (sql%notfound) then
183: raise no_data_found;
184: end if;
185:
186: update BNE_CONTENT_COLS_TL set
187: USER_NAME = X_USER_NAME,
188: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
189: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
190: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
204: X_CONTENT_CODE in VARCHAR2,
205: X_SEQUENCE_NUM in NUMBER
206: ) is
207: begin
208: delete from BNE_CONTENT_COLS_TL
209: where APPLICATION_ID = X_APPLICATION_ID
210: and CONTENT_CODE = X_CONTENT_CODE
211: and SEQUENCE_NUM = X_SEQUENCE_NUM;
212:
226:
227: procedure ADD_LANGUAGE
228: is
229: begin
230: delete from BNE_CONTENT_COLS_TL T
231: where not exists
232: (select NULL
233: from BNE_CONTENT_COLS_B B
234: where B.APPLICATION_ID = T.APPLICATION_ID
235: and B.CONTENT_CODE = T.CONTENT_CODE
236: and B.SEQUENCE_NUM = T.SEQUENCE_NUM
237: );
238:
239: update BNE_CONTENT_COLS_TL T set (
240: USER_NAME
241: ) = (select
242: B.USER_NAME
243: from BNE_CONTENT_COLS_TL B
239: update BNE_CONTENT_COLS_TL T set (
240: USER_NAME
241: ) = (select
242: B.USER_NAME
243: from BNE_CONTENT_COLS_TL B
244: where B.APPLICATION_ID = T.APPLICATION_ID
245: and B.CONTENT_CODE = T.CONTENT_CODE
246: and B.SEQUENCE_NUM = T.SEQUENCE_NUM
247: and B.LANGUAGE = T.SOURCE_LANG)
254: SUBT.APPLICATION_ID,
255: SUBT.CONTENT_CODE,
256: SUBT.SEQUENCE_NUM,
257: SUBT.LANGUAGE
258: from BNE_CONTENT_COLS_TL SUBB, BNE_CONTENT_COLS_TL SUBT
259: where SUBB.APPLICATION_ID = SUBT.APPLICATION_ID
260: and SUBB.CONTENT_CODE = SUBT.CONTENT_CODE
261: and SUBB.SEQUENCE_NUM = SUBT.SEQUENCE_NUM
262: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
262: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
263: and (SUBB.USER_NAME <> SUBT.USER_NAME
264: ));
265:
266: insert into BNE_CONTENT_COLS_TL (
267: APPLICATION_ID,
268: CONTENT_CODE,
269: SEQUENCE_NUM,
270: USER_NAME,
286: B.LAST_UPDATE_LOGIN,
287: B.LAST_UPDATE_DATE,
288: L.LANGUAGE_CODE,
289: B.SOURCE_LANG
290: from BNE_CONTENT_COLS_TL B, FND_LANGUAGES L
291: where L.INSTALLED_FLAG in ('I', 'B')
292: and B.LANGUAGE = userenv('LANG')
293: and not exists
294: (select NULL
291: where L.INSTALLED_FLAG in ('I', 'B')
292: and B.LANGUAGE = userenv('LANG')
293: and not exists
294: (select NULL
295: from BNE_CONTENT_COLS_TL T
296: where T.APPLICATION_ID = B.APPLICATION_ID
297: and T.CONTENT_CODE = B.CONTENT_CODE
298: and T.SEQUENCE_NUM = B.SEQUENCE_NUM
299: and T.LANGUAGE = L.LANGUAGE_CODE);
338: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
339: begin
340: select LAST_UPDATED_BY, LAST_UPDATE_DATE
341: into db_luby, db_ludate
342: from BNE_CONTENT_COLS_TL
343: where APPLICATION_ID = l_app_id
344: and CONTENT_CODE = x_content_code
345: and SEQUENCE_NUM = x_sequence_num
346: and LANGUAGE = userenv('LANG');
348: -- Test for customization and version
349: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
350: db_ludate, x_custom_mode)) then
351:
352: update BNE_CONTENT_COLS_TL
353: set USER_NAME = x_user_name,
354: LAST_UPDATE_DATE = f_ludate,
355: LAST_UPDATED_BY = f_luby,
356: LAST_UPDATE_LOGIN = 0,