APPS.BNE_PERF_STATISTICS_PKG dependencies on BNE_PERF_STATISTICS_TL

Line 37: insert into BNE_PERF_STATISTICS_TL (

33: X_LAST_UPDATED_BY,
34: X_LAST_UPDATE_LOGIN
35: );
36:
37: insert into BNE_PERF_STATISTICS_TL (
38: STATISTIC_CODE,
39: USER_NAME,
40: CREATED_BY,
41: CREATION_DATE,

Line 61: from BNE_PERF_STATISTICS_TL T

57: from FND_LANGUAGES L
58: where L.INSTALLED_FLAG in ('I', 'B')
59: and not exists
60: (select NULL
61: from BNE_PERF_STATISTICS_TL T
62: where T.STATISTIC_CODE = X_STATISTIC_CODE
63: and T.LANGUAGE = L.LANGUAGE_CODE);
64:
65: open c;

Line 90: from BNE_PERF_STATISTICS_TL

86:
87: cursor c1 is select
88: USER_NAME,
89: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
90: from BNE_PERF_STATISTICS_TL
91: where STATISTIC_CODE = X_STATISTIC_CODE
92: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
93: for update of STATISTIC_CODE nowait;
94: begin

Line 145: update BNE_PERF_STATISTICS_TL set

141: if (sql%notfound) then
142: raise no_data_found;
143: end if;
144:
145: update BNE_PERF_STATISTICS_TL set
146: USER_NAME = X_USER_NAME,
147: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
148: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
149: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 163: delete from BNE_PERF_STATISTICS_TL

159: procedure DELETE_ROW (
160: X_STATISTIC_CODE in VARCHAR2
161: ) is
162: begin
163: delete from BNE_PERF_STATISTICS_TL
164: where STATISTIC_CODE = X_STATISTIC_CODE;
165:
166: if (sql%notfound) then
167: raise no_data_found;

Line 181: delete from BNE_PERF_STATISTICS_TL T

177:
178: procedure ADD_LANGUAGE
179: is
180: begin
181: delete from BNE_PERF_STATISTICS_TL T
182: where not exists
183: (select NULL
184: from BNE_PERF_STATISTICS_B B
185: where B.STATISTIC_CODE = T.STATISTIC_CODE

Line 188: update BNE_PERF_STATISTICS_TL T set (

184: from BNE_PERF_STATISTICS_B B
185: where B.STATISTIC_CODE = T.STATISTIC_CODE
186: );
187:
188: update BNE_PERF_STATISTICS_TL T set (
189: USER_NAME
190: ) = (select
191: B.USER_NAME
192: from BNE_PERF_STATISTICS_TL B

Line 192: from BNE_PERF_STATISTICS_TL B

188: update BNE_PERF_STATISTICS_TL T set (
189: USER_NAME
190: ) = (select
191: B.USER_NAME
192: from BNE_PERF_STATISTICS_TL B
193: where B.STATISTIC_CODE = T.STATISTIC_CODE
194: and B.LANGUAGE = T.SOURCE_LANG)
195: where (
196: T.STATISTIC_CODE,

Line 201: from BNE_PERF_STATISTICS_TL SUBB, BNE_PERF_STATISTICS_TL SUBT

197: T.LANGUAGE
198: ) in (select
199: SUBT.STATISTIC_CODE,
200: SUBT.LANGUAGE
201: from BNE_PERF_STATISTICS_TL SUBB, BNE_PERF_STATISTICS_TL SUBT
202: where SUBB.STATISTIC_CODE = SUBT.STATISTIC_CODE
203: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
204: and (SUBB.USER_NAME <> SUBT.USER_NAME
205: ));

Line 207: insert into BNE_PERF_STATISTICS_TL (

203: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
204: and (SUBB.USER_NAME <> SUBT.USER_NAME
205: ));
206:
207: insert into BNE_PERF_STATISTICS_TL (
208: STATISTIC_CODE,
209: USER_NAME,
210: CREATED_BY,
211: CREATION_DATE,

Line 227: from BNE_PERF_STATISTICS_TL B, FND_LANGUAGES L

223: B.LAST_UPDATE_LOGIN,
224: B.LAST_UPDATE_DATE,
225: L.LANGUAGE_CODE,
226: B.SOURCE_LANG
227: from BNE_PERF_STATISTICS_TL B, FND_LANGUAGES L
228: where L.INSTALLED_FLAG in ('I', 'B')
229: and B.LANGUAGE = userenv('LANG')
230: and not exists
231: (select NULL

Line 232: from BNE_PERF_STATISTICS_TL T

228: where L.INSTALLED_FLAG in ('I', 'B')
229: and B.LANGUAGE = userenv('LANG')
230: and not exists
231: (select NULL
232: from BNE_PERF_STATISTICS_TL T
233: where T.STATISTIC_CODE = B.STATISTIC_CODE
234: and T.LANGUAGE = L.LANGUAGE_CODE);
235: end ADD_LANGUAGE;
236:

Line 271: from BNE_PERF_STATISTICS_TL

267: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
268: begin
269: select LAST_UPDATED_BY, LAST_UPDATE_DATE
270: into db_luby, db_ludate
271: from BNE_PERF_STATISTICS_TL
272: where STATISTIC_CODE = x_statistic_code
273: and LANGUAGE = userenv('LANG');
274:
275: -- Test for customization and version

Line 279: update BNE_PERF_STATISTICS_TL

275: -- Test for customization and version
276: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
277: db_ludate, x_custom_mode)) then
278:
279: update BNE_PERF_STATISTICS_TL
280: set USER_NAME = x_user_name,
281: LAST_UPDATE_DATE = f_ludate,
282: LAST_UPDATED_BY = f_luby,
283: LAST_UPDATE_LOGIN = 0,