[Home] [Help]
97: X_SESSION_PARAM_LIST_CODE,
98: X_DISPLAY_FLAG
99: );
100:
101: insert into BNE_INTEGRATORS_TL (
102: APPLICATION_ID,
103: INTEGRATOR_CODE,
104: USER_NAME,
105: UPLOAD_HEADER,
127: from FND_LANGUAGES L
128: where L.INSTALLED_FLAG in ('I', 'B')
129: and not exists
130: (select NULL
131: from BNE_INTEGRATORS_TL T
132: where T.APPLICATION_ID = X_APPLICATION_ID
133: and T.INTEGRATOR_CODE = X_INTEGRATOR_CODE
134: and T.LANGUAGE = L.LANGUAGE_CODE);
135:
201: USER_NAME,
202: UPLOAD_TITLE_BAR,
203: UPLOAD_HEADER,
204: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
205: from BNE_INTEGRATORS_TL
206: where APPLICATION_ID = X_APPLICATION_ID
207: and INTEGRATOR_CODE = X_INTEGRATOR_CODE
208: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
209: for update of APPLICATION_ID nowait;
339: if (sql%notfound) then
340: raise no_data_found;
341: end if;
342:
343: update BNE_INTEGRATORS_TL set
344: USER_NAME = X_USER_NAME,
345: UPLOAD_TITLE_BAR = X_UPLOAD_TITLE_BAR,
346: UPLOAD_HEADER = X_UPLOAD_HEADER,
347: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
361: X_APPLICATION_ID in NUMBER,
362: X_INTEGRATOR_CODE in VARCHAR2
363: ) is
364: begin
365: delete from BNE_INTEGRATORS_TL
366: where APPLICATION_ID = X_APPLICATION_ID
367: and INTEGRATOR_CODE = X_INTEGRATOR_CODE;
368:
369: if (sql%notfound) then
381:
382: procedure ADD_LANGUAGE
383: is
384: begin
385: delete from BNE_INTEGRATORS_TL T
386: where not exists
387: (select NULL
388: from BNE_INTEGRATORS_B B
389: where B.APPLICATION_ID = T.APPLICATION_ID
389: where B.APPLICATION_ID = T.APPLICATION_ID
390: and B.INTEGRATOR_CODE = T.INTEGRATOR_CODE
391: );
392:
393: update BNE_INTEGRATORS_TL T set (
394: USER_NAME,
395: UPLOAD_TITLE_BAR,
396: UPLOAD_HEADER
397: ) = (select
397: ) = (select
398: B.USER_NAME,
399: B.UPLOAD_TITLE_BAR,
400: B.UPLOAD_HEADER
401: from BNE_INTEGRATORS_TL B
402: where B.APPLICATION_ID = T.APPLICATION_ID
403: and B.INTEGRATOR_CODE = T.INTEGRATOR_CODE
404: and B.LANGUAGE = T.SOURCE_LANG)
405: where (
409: ) in (select
410: SUBT.APPLICATION_ID,
411: SUBT.INTEGRATOR_CODE,
412: SUBT.LANGUAGE
413: from BNE_INTEGRATORS_TL SUBB, BNE_INTEGRATORS_TL SUBT
414: where SUBB.APPLICATION_ID = SUBT.APPLICATION_ID
415: and SUBB.INTEGRATOR_CODE = SUBT.INTEGRATOR_CODE
416: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
417: and (SUBB.USER_NAME <> SUBT.USER_NAME
422: or (SUBB.UPLOAD_HEADER is null and SUBT.UPLOAD_HEADER is not null)
423: or (SUBB.UPLOAD_HEADER is not null and SUBT.UPLOAD_HEADER is null)
424: ));
425:
426: insert into BNE_INTEGRATORS_TL (
427: APPLICATION_ID,
428: INTEGRATOR_CODE,
429: USER_NAME,
430: UPLOAD_HEADER,
448: B.LAST_UPDATE_LOGIN,
449: B.LAST_UPDATE_DATE,
450: L.LANGUAGE_CODE,
451: B.SOURCE_LANG
452: from BNE_INTEGRATORS_TL B, FND_LANGUAGES L
453: where L.INSTALLED_FLAG in ('I', 'B')
454: and B.LANGUAGE = userenv('LANG')
455: and not exists
456: (select NULL
453: where L.INSTALLED_FLAG in ('I', 'B')
454: and B.LANGUAGE = userenv('LANG')
455: and not exists
456: (select NULL
457: from BNE_INTEGRATORS_TL T
458: where T.APPLICATION_ID = B.APPLICATION_ID
459: and T.INTEGRATOR_CODE = B.INTEGRATOR_CODE
460: and T.LANGUAGE = L.LANGUAGE_CODE);
461: end ADD_LANGUAGE;
501: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
502: begin
503: select LAST_UPDATED_BY, LAST_UPDATE_DATE
504: into db_luby, db_ludate
505: from BNE_INTEGRATORS_TL
506: where APPLICATION_ID = l_app_id
507: and INTEGRATOR_CODE = x_integrator_code
508: and LANGUAGE = userenv('LANG');
509:
510: -- Test for customization and version
511: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
512: db_ludate, x_custom_mode)) then
513:
514: update BNE_INTEGRATORS_TL
515: set USER_NAME = x_user_name,
516: UPLOAD_HEADER = x_upload_header,
517: UPLOAD_TITLE_BAR = x_upload_title_bar,
518: LAST_UPDATE_DATE = f_ludate,