[Home] [Help]
100: X_DISPLAY_FLAG,
101: X_SOURCE
102: );
103:
104: insert into BNE_INTEGRATORS_TL (
105: APPLICATION_ID,
106: INTEGRATOR_CODE,
107: USER_NAME,
108: UPLOAD_HEADER,
130: from FND_LANGUAGES L
131: where L.INSTALLED_FLAG in ('I', 'B')
132: and not exists
133: (select NULL
134: from BNE_INTEGRATORS_TL T
135: where T.APPLICATION_ID = X_APPLICATION_ID
136: and T.INTEGRATOR_CODE = X_INTEGRATOR_CODE
137: and T.LANGUAGE = L.LANGUAGE_CODE);
138:
206: USER_NAME,
207: UPLOAD_TITLE_BAR,
208: UPLOAD_HEADER,
209: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
210: from BNE_INTEGRATORS_TL
211: where APPLICATION_ID = X_APPLICATION_ID
212: and INTEGRATOR_CODE = X_INTEGRATOR_CODE
213: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
214: for update of APPLICATION_ID nowait;
348: if (sql%notfound) then
349: raise no_data_found;
350: end if;
351:
352: update BNE_INTEGRATORS_TL set
353: USER_NAME = X_USER_NAME,
354: UPLOAD_TITLE_BAR = X_UPLOAD_TITLE_BAR,
355: UPLOAD_HEADER = X_UPLOAD_HEADER,
356: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
370: X_APPLICATION_ID in NUMBER,
371: X_INTEGRATOR_CODE in VARCHAR2
372: ) is
373: begin
374: delete from BNE_INTEGRATORS_TL
375: where APPLICATION_ID = X_APPLICATION_ID
376: and INTEGRATOR_CODE = X_INTEGRATOR_CODE;
377:
378: if (sql%notfound) then
390:
391: procedure ADD_LANGUAGE
392: is
393: begin
394: delete from BNE_INTEGRATORS_TL T
395: where not exists
396: (select NULL
397: from BNE_INTEGRATORS_B B
398: where B.APPLICATION_ID = T.APPLICATION_ID
398: where B.APPLICATION_ID = T.APPLICATION_ID
399: and B.INTEGRATOR_CODE = T.INTEGRATOR_CODE
400: );
401:
402: update BNE_INTEGRATORS_TL T set (
403: USER_NAME,
404: UPLOAD_TITLE_BAR,
405: UPLOAD_HEADER
406: ) = (select
406: ) = (select
407: B.USER_NAME,
408: B.UPLOAD_TITLE_BAR,
409: B.UPLOAD_HEADER
410: from BNE_INTEGRATORS_TL B
411: where B.APPLICATION_ID = T.APPLICATION_ID
412: and B.INTEGRATOR_CODE = T.INTEGRATOR_CODE
413: and B.LANGUAGE = T.SOURCE_LANG)
414: where (
418: ) in (select
419: SUBT.APPLICATION_ID,
420: SUBT.INTEGRATOR_CODE,
421: SUBT.LANGUAGE
422: from BNE_INTEGRATORS_TL SUBB, BNE_INTEGRATORS_TL SUBT
423: where SUBB.APPLICATION_ID = SUBT.APPLICATION_ID
424: and SUBB.INTEGRATOR_CODE = SUBT.INTEGRATOR_CODE
425: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
426: and (SUBB.USER_NAME <> SUBT.USER_NAME
431: or (SUBB.UPLOAD_HEADER is null and SUBT.UPLOAD_HEADER is not null)
432: or (SUBB.UPLOAD_HEADER is not null and SUBT.UPLOAD_HEADER is null)
433: ));
434:
435: insert into BNE_INTEGRATORS_TL (
436: APPLICATION_ID,
437: INTEGRATOR_CODE,
438: USER_NAME,
439: UPLOAD_HEADER,
457: B.LAST_UPDATE_LOGIN,
458: B.LAST_UPDATE_DATE,
459: L.LANGUAGE_CODE,
460: B.SOURCE_LANG
461: from BNE_INTEGRATORS_TL B, FND_LANGUAGES L
462: where L.INSTALLED_FLAG in ('I', 'B')
463: and B.LANGUAGE = userenv('LANG')
464: and not exists
465: (select NULL
462: where L.INSTALLED_FLAG in ('I', 'B')
463: and B.LANGUAGE = userenv('LANG')
464: and not exists
465: (select NULL
466: from BNE_INTEGRATORS_TL T
467: where T.APPLICATION_ID = B.APPLICATION_ID
468: and T.INTEGRATOR_CODE = B.INTEGRATOR_CODE
469: and T.LANGUAGE = L.LANGUAGE_CODE);
470: end ADD_LANGUAGE;
510: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
511: begin
512: select LAST_UPDATED_BY, LAST_UPDATE_DATE
513: into db_luby, db_ludate
514: from BNE_INTEGRATORS_TL
515: where APPLICATION_ID = l_app_id
516: and INTEGRATOR_CODE = x_integrator_code
517: and LANGUAGE = userenv('LANG');
518:
519: -- Test for customization and version
520: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
521: db_ludate, x_custom_mode)) then
522:
523: update BNE_INTEGRATORS_TL
524: set USER_NAME = x_user_name,
525: UPLOAD_HEADER = x_upload_header,
526: UPLOAD_TITLE_BAR = x_upload_title_bar,
527: LAST_UPDATE_DATE = f_ludate,