[Home] [Help]
16: X_LAST_UPDATE_DATE in DATE,
17: X_LAST_UPDATED_BY in NUMBER,
18: X_LAST_UPDATE_LOGIN in NUMBER
19: ) is
20: cursor C is select ROWID from FA_RX_SUMMARY_TL
21: where REPORT_ID = X_REPORT_ID
22: and ATTRIBUTE_SET = X_ATTRIBUTE_SET
23: and COLUMN_NAME = X_COLUMN_NAME
24: and SUMMARY_FUNCTION = X_SUMMARY_FUNCTION
27: and COMPUTE_LEVEL = X_COMPUTE_LEVEL
28: and LANGUAGE = userenv('LANG')
29: ;
30: begin
31: insert into FA_RX_SUMMARY_TL (
32: REPORT_ID,
33: ATTRIBUTE_SET,
34: COLUMN_NAME,
35: PRINT_LEVEL,
65: from FND_LANGUAGES L
66: where L.INSTALLED_FLAG in ('I', 'B')
67: and not exists
68: (select NULL
69: from FA_RX_SUMMARY_TL T
70: where T.REPORT_ID = X_REPORT_ID
71: and T.ATTRIBUTE_SET = X_ATTRIBUTE_SET
72: and T.COLUMN_NAME = X_COLUMN_NAME
73: and T.SUMMARY_FUNCTION = X_SUMMARY_FUNCTION
100: cursor c1 is select
101: DISPLAY_STATUS,
102: SUMMARY_PROMPT,
103: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
104: from FA_RX_SUMMARY_TL
105: where REPORT_ID = X_REPORT_ID
106: and ATTRIBUTE_SET = X_ATTRIBUTE_SET
107: and COLUMN_NAME = X_COLUMN_NAME
108: and SUMMARY_FUNCTION = X_SUMMARY_FUNCTION
143: X_LAST_UPDATED_BY in NUMBER,
144: X_LAST_UPDATE_LOGIN in NUMBER
145: ) is
146: begin
147: update FA_RX_SUMMARY_TL set
148: DISPLAY_STATUS = X_DISPLAY_STATUS,
149: SUMMARY_PROMPT = X_SUMMARY_PROMPT,
150: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
151: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
174: X_RESET_LEVEL in NUMBER,
175: X_COMPUTE_LEVEL in NUMBER
176: ) is
177: begin
178: delete from FA_RX_SUMMARY_TL
179: where REPORT_ID = X_REPORT_ID
180: and ATTRIBUTE_SET = X_ATTRIBUTE_SET
181: and COLUMN_NAME = X_COLUMN_NAME
182: and SUMMARY_FUNCTION = X_SUMMARY_FUNCTION
192:
193: procedure ADD_LANGUAGE
194: is
195: begin
196: update FA_RX_SUMMARY_TL T set (
197: SUMMARY_PROMPT
198: ) = (select
199: B.SUMMARY_PROMPT
200: from FA_RX_SUMMARY_TL B
196: update FA_RX_SUMMARY_TL T set (
197: SUMMARY_PROMPT
198: ) = (select
199: B.SUMMARY_PROMPT
200: from FA_RX_SUMMARY_TL B
201: where B.REPORT_ID = T.REPORT_ID
202: and B.ATTRIBUTE_SET = T.ATTRIBUTE_SET
203: and B.COLUMN_NAME = T.COLUMN_NAME
204: and B.SUMMARY_FUNCTION = T.SUMMARY_FUNCTION
223: SUBT.PRINT_LEVEL,
224: SUBT.RESET_LEVEL,
225: SUBT.COMPUTE_LEVEL,
226: SUBT.LANGUAGE
227: from FA_RX_SUMMARY_TL SUBB, FA_RX_SUMMARY_TL SUBT
228: where SUBB.REPORT_ID = SUBT.REPORT_ID
229: and SUBB.ATTRIBUTE_SET = SUBT.ATTRIBUTE_SET
230: and SUBB.COLUMN_NAME = SUBT.COLUMN_NAME
231: and SUBB.SUMMARY_FUNCTION = SUBT.SUMMARY_FUNCTION
237: or (SUBB.SUMMARY_PROMPT is null and SUBT.SUMMARY_PROMPT is not null)
238: or (SUBB.SUMMARY_PROMPT is not null and SUBT.SUMMARY_PROMPT is null)
239: ));
240:
241: insert into FA_RX_SUMMARY_TL (
242: REPORT_ID,
243: ATTRIBUTE_SET,
244: COLUMN_NAME,
245: PRINT_LEVEL,
271: B.CREATED_BY,
272: B.CREATION_DATE,
273: L.LANGUAGE_CODE,
274: B.SOURCE_LANG
275: from FA_RX_SUMMARY_TL B, FND_LANGUAGES L
276: where L.INSTALLED_FLAG in ('I', 'B')
277: and B.LANGUAGE = userenv('LANG')
278: and not exists
279: (select NULL
276: where L.INSTALLED_FLAG in ('I', 'B')
277: and B.LANGUAGE = userenv('LANG')
278: and not exists
279: (select NULL
280: from FA_RX_SUMMARY_TL T
281: where T.REPORT_ID = B.REPORT_ID
282: and T.ATTRIBUTE_SET = B.ATTRIBUTE_SET
283: and T.COLUMN_NAME = B.COLUMN_NAME
284: and T.SUMMARY_FUNCTION = B.SUMMARY_FUNCTION
355: f_ludate := nvl(to_date(X_Last_Update_Date, 'YYYY/MM/DD HH24:MI:SS'), sysdate);
356:
357: select LAST_UPDATED_BY, LAST_UPDATE_DATE
358: into db_luby, db_ludate
359: from FA_RX_SUMMARY_TL
360: where REPORT_ID = X_REPORT_ID
361: and ATTRIBUTE_SET = X_ATTRIBUTE_SET
362: and COLUMN_NAME = X_COLUMN_NAME
363: and SUMMARY_FUNCTION = X_SUMMARY_FUNCTION
457:
458: --* End
459: --*
460:
461: update FA_RX_SUMMARY_TL
462: set SUMMARY_PROMPT = X_SUMMARY_PROMPT,
463: LAST_UPDATE_DATE = f_ludate,
464: LAST_UPDATED_BY = f_luby,
465: LAST_UPDATE_LOGIN = 0,