[Home] [Help]
60: X_LAST_UPDATE_LOGIN,
61: X_LAST_UPDATE_DATE
62: );
63:
64: insert into BNE_GRAPHS_TL (
65: APPLICATION_ID,
66: INTEGRATOR_CODE,
67: SEQUENCE_NUM,
68: CHART_TITLE,
94: from FND_LANGUAGES L
95: where L.INSTALLED_FLAG in ('I', 'B')
96: and not exists
97: (select NULL
98: from BNE_GRAPHS_TL T
99: where T.APPLICATION_ID = X_APPLICATION_ID
100: and T.INTEGRATOR_CODE = X_INTEGRATOR_CODE
101: and T.SEQUENCE_NUM = X_SEQUENCE_NUM
102: and T.LANGUAGE = L.LANGUAGE_CODE);
151: X_AXIS_LABEL,
152: Y_AXIS_LABEL,
153: Z_AXIS_LABEL,
154: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
155: from BNE_GRAPHS_TL
156: where APPLICATION_ID = X_APPLICATION_ID
157: and INTEGRATOR_CODE = X_INTEGRATOR_CODE
158: and SEQUENCE_NUM = X_SEQUENCE_NUM
159: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
242: if (sql%notfound) then
243: raise no_data_found;
244: end if;
245:
246: update BNE_GRAPHS_TL set
247: CHART_TITLE = X_CHART_TITLE,
248: X_AXIS_LABEL = X_X_AXIS_LABEL,
249: Y_AXIS_LABEL = X_Y_AXIS_LABEL,
250: Z_AXIS_LABEL = X_Z_AXIS_LABEL,
267: X_INTEGRATOR_CODE in VARCHAR2,
268: X_SEQUENCE_NUM in NUMBER
269: ) is
270: begin
271: delete from BNE_GRAPHS_TL
272: where APPLICATION_ID = X_APPLICATION_ID
273: and INTEGRATOR_CODE = X_INTEGRATOR_CODE
274: and SEQUENCE_NUM = X_SEQUENCE_NUM;
275:
289:
290: procedure ADD_LANGUAGE
291: is
292: begin
293: delete from BNE_GRAPHS_TL T
294: where not exists
295: (select NULL
296: from BNE_GRAPHS_B B
297: where B.APPLICATION_ID = T.APPLICATION_ID
298: and B.INTEGRATOR_CODE = T.INTEGRATOR_CODE
299: and B.SEQUENCE_NUM = T.SEQUENCE_NUM
300: );
301:
302: update BNE_GRAPHS_TL T set (
303: CHART_TITLE,
304: X_AXIS_LABEL,
305: Y_AXIS_LABEL,
306: Z_AXIS_LABEL
308: B.CHART_TITLE,
309: B.X_AXIS_LABEL,
310: B.Y_AXIS_LABEL,
311: B.Z_AXIS_LABEL
312: from BNE_GRAPHS_TL B
313: where B.APPLICATION_ID = T.APPLICATION_ID
314: and B.INTEGRATOR_CODE = T.INTEGRATOR_CODE
315: and B.SEQUENCE_NUM = T.SEQUENCE_NUM
316: and B.LANGUAGE = T.SOURCE_LANG)
323: SUBT.APPLICATION_ID,
324: SUBT.INTEGRATOR_CODE,
325: SUBT.SEQUENCE_NUM,
326: SUBT.LANGUAGE
327: from BNE_GRAPHS_TL SUBB, BNE_GRAPHS_TL SUBT
328: where SUBB.APPLICATION_ID = SUBT.APPLICATION_ID
329: and SUBB.INTEGRATOR_CODE = SUBT.INTEGRATOR_CODE
330: and SUBB.SEQUENCE_NUM = SUBT.SEQUENCE_NUM
331: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
342: or (SUBB.Z_AXIS_LABEL is null and SUBT.Z_AXIS_LABEL is not null)
343: or (SUBB.Z_AXIS_LABEL is not null and SUBT.Z_AXIS_LABEL is null)
344: ));
345:
346: insert into BNE_GRAPHS_TL (
347: APPLICATION_ID,
348: INTEGRATOR_CODE,
349: SEQUENCE_NUM,
350: CHART_TITLE,
372: B.LAST_UPDATE_LOGIN,
373: B.LAST_UPDATE_DATE,
374: L.LANGUAGE_CODE,
375: B.SOURCE_LANG
376: from BNE_GRAPHS_TL B, FND_LANGUAGES L
377: where L.INSTALLED_FLAG in ('I', 'B')
378: and B.LANGUAGE = userenv('LANG')
379: and not exists
380: (select NULL
377: where L.INSTALLED_FLAG in ('I', 'B')
378: and B.LANGUAGE = userenv('LANG')
379: and not exists
380: (select NULL
381: from BNE_GRAPHS_TL T
382: where T.APPLICATION_ID = B.APPLICATION_ID
383: and T.INTEGRATOR_CODE = B.INTEGRATOR_CODE
384: and T.SEQUENCE_NUM = B.SEQUENCE_NUM
385: and T.LANGUAGE = L.LANGUAGE_CODE);
428: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
429: begin
430: select LAST_UPDATED_BY, LAST_UPDATE_DATE
431: into db_luby, db_ludate
432: from BNE_GRAPHS_TL
433: where APPLICATION_ID = l_app_id
434: and INTEGRATOR_CODE = x_integrator_code
435: and SEQUENCE_NUM = x_sequence_num
436: and LANGUAGE = userenv('LANG');
438: -- Test for customization and version
439: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
440: db_ludate, x_custom_mode)) then
441:
442: update BNE_GRAPHS_TL
443: set CHART_TITLE = x_chart_title,
444: X_AXIS_LABEL = x_x_axis_label,
445: Y_AXIS_LABEL = x_y_axis_label,
446: Z_AXIS_LABEL = x_z_axis_label,