[Home] [Help]
73: X_LAST_UPDATED_BY,
74: X_LAST_UPDATE_LOGIN
75: );
76:
77: insert into FA_RX_REP_COLUMNS_TL (
78: REPORT_ID,
79: ATTRIBUTE_SET,
80: COLUMN_NAME,
81: ATTRIBUTE_NAME,
101: from FND_LANGUAGES L
102: where L.INSTALLED_FLAG in ('I', 'B')
103: and not exists
104: (select NULL
105: from FA_RX_REP_COLUMNS_TL T
106: where T.REPORT_ID = X_REPORT_ID
107: and T.ATTRIBUTE_SET = X_ATTRIBUTE_SET
108: and T.COLUMN_NAME = X_COLUMN_NAME
109: and T.LANGUAGE = L.LANGUAGE_CODE);
158:
159: cursor c1 is select
160: ATTRIBUTE_NAME,
161: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
162: from FA_RX_REP_COLUMNS_TL
163: where REPORT_ID = X_REPORT_ID
164: and ATTRIBUTE_SET = X_ATTRIBUTE_SET
165: and COLUMN_NAME = X_COLUMN_NAME
166: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
263: if (sql%notfound) then
264: raise no_data_found;
265: end if;
266:
267: update FA_RX_REP_COLUMNS_TL set
268: ATTRIBUTE_NAME = X_ATTRIBUTE_NAME,
269: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
270: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
271: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
285: X_ATTRIBUTE_SET in VARCHAR2,
286: X_COLUMN_NAME in VARCHAR2
287: ) is
288: begin
289: delete from FA_RX_REP_COLUMNS_TL
290: where REPORT_ID = X_REPORT_ID
291: and ATTRIBUTE_SET = X_ATTRIBUTE_SET
292: and COLUMN_NAME = X_COLUMN_NAME;
293:
307:
308: procedure ADD_LANGUAGE
309: is
310: begin
311: delete from FA_RX_REP_COLUMNS_TL T
312: where not exists
313: (select NULL
314: from FA_RX_REP_COLUMNS_B B
315: where B.REPORT_ID = T.REPORT_ID
316: and B.ATTRIBUTE_SET = T.ATTRIBUTE_SET
317: and B.COLUMN_NAME = T.COLUMN_NAME
318: );
319:
320: update FA_RX_REP_COLUMNS_TL T set (
321: ATTRIBUTE_NAME
322: ) = (select
323: B.ATTRIBUTE_NAME
324: from FA_RX_REP_COLUMNS_TL B
320: update FA_RX_REP_COLUMNS_TL T set (
321: ATTRIBUTE_NAME
322: ) = (select
323: B.ATTRIBUTE_NAME
324: from FA_RX_REP_COLUMNS_TL B
325: where B.REPORT_ID = T.REPORT_ID
326: and B.ATTRIBUTE_SET = T.ATTRIBUTE_SET
327: and B.COLUMN_NAME = T.COLUMN_NAME
328: and B.LANGUAGE = T.SOURCE_LANG)
335: SUBT.REPORT_ID,
336: SUBT.ATTRIBUTE_SET,
337: SUBT.COLUMN_NAME,
338: SUBT.LANGUAGE
339: from FA_RX_REP_COLUMNS_TL SUBB, FA_RX_REP_COLUMNS_TL SUBT
340: where SUBB.REPORT_ID = SUBT.REPORT_ID
341: and SUBB.ATTRIBUTE_SET = SUBT.ATTRIBUTE_SET
342: and SUBB.COLUMN_NAME = SUBT.COLUMN_NAME
343: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
343: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
344: and (SUBB.ATTRIBUTE_NAME <> SUBT.ATTRIBUTE_NAME
345: ));
346:
347: insert into FA_RX_REP_COLUMNS_TL (
348: REPORT_ID,
349: ATTRIBUTE_SET,
350: COLUMN_NAME,
351: ATTRIBUTE_NAME,
367: B.CREATED_BY,
368: B.CREATION_DATE,
369: L.LANGUAGE_CODE,
370: B.SOURCE_LANG
371: from FA_RX_REP_COLUMNS_TL B, FND_LANGUAGES L
372: where L.INSTALLED_FLAG in ('I', 'B')
373: and B.LANGUAGE = userenv('LANG')
374: and not exists
375: (select NULL
372: where L.INSTALLED_FLAG in ('I', 'B')
373: and B.LANGUAGE = userenv('LANG')
374: and not exists
375: (select NULL
376: from FA_RX_REP_COLUMNS_TL T
377: where T.REPORT_ID = B.REPORT_ID
378: and T.ATTRIBUTE_SET = B.ATTRIBUTE_SET
379: and T.COLUMN_NAME = B.COLUMN_NAME
380: and T.LANGUAGE = L.LANGUAGE_CODE);
479:
480: Begin
481: select LAST_UPDATED_BY, LAST_UPDATE_DATE
482: into db_luby_tl, db_ludate_tl
483: from fa_rx_rep_columns_tl
484: where report_id = X_Report_Id
485: and ATTRIBUTE_SET = X_ATTRIBUTE_SET
486: and column_name = X_Column_Name
487: and language = userenv('LANG');
589: f_ludate := nvl(to_date(X_Last_Update_Date, 'YYYY/MM/DD HH24:MI:SS'), sysdate);
590:
591: --* End
592: --*
593: update fa_rx_rep_columns_tl set
594: attribute_name = X_ATTRIBUTE_NAME,
595: LAST_UPDATE_DATE = f_ludate,
596: LAST_UPDATED_BY = f_luby,
597: LAST_UPDATE_LOGIN = 0,