APPS.BNE_PERF_SETS_PKG dependencies on BNE_PERF_SETS_TL

Line 40: insert into BNE_PERF_SETS_TL (

36: X_LAST_UPDATED_BY,
37: X_LAST_UPDATE_LOGIN
38: );
39:
40: insert into BNE_PERF_SETS_TL (
41: SET_CODE,
42: USER_NAME,
43: CREATED_BY,
44: CREATION_DATE,

Line 64: from BNE_PERF_SETS_TL T

60: from FND_LANGUAGES L
61: where L.INSTALLED_FLAG in ('I', 'B')
62: and not exists
63: (select NULL
64: from BNE_PERF_SETS_TL T
65: where T.SET_CODE = X_SET_CODE
66: and T.LANGUAGE = L.LANGUAGE_CODE);
67:
68: open c;

Line 95: from BNE_PERF_SETS_TL

91:
92: cursor c1 is select
93: USER_NAME,
94: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
95: from BNE_PERF_SETS_TL
96: where SET_CODE = X_SET_CODE
97: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
98: for update of SET_CODE nowait;
99: begin

Line 153: update BNE_PERF_SETS_TL set

149: if (sql%notfound) then
150: raise no_data_found;
151: end if;
152:
153: update BNE_PERF_SETS_TL set
154: USER_NAME = X_USER_NAME,
155: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
156: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
157: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 171: delete from BNE_PERF_SETS_TL

167: procedure DELETE_ROW (
168: X_SET_CODE in VARCHAR2
169: ) is
170: begin
171: delete from BNE_PERF_SETS_TL
172: where SET_CODE = X_SET_CODE;
173:
174: if (sql%notfound) then
175: raise no_data_found;

Line 189: delete from BNE_PERF_SETS_TL T

185:
186: procedure ADD_LANGUAGE
187: is
188: begin
189: delete from BNE_PERF_SETS_TL T
190: where not exists
191: (select NULL
192: from BNE_PERF_SETS_B B
193: where B.SET_CODE = T.SET_CODE

Line 196: update BNE_PERF_SETS_TL T set (

192: from BNE_PERF_SETS_B B
193: where B.SET_CODE = T.SET_CODE
194: );
195:
196: update BNE_PERF_SETS_TL T set (
197: USER_NAME
198: ) = (select
199: B.USER_NAME
200: from BNE_PERF_SETS_TL B

Line 200: from BNE_PERF_SETS_TL B

196: update BNE_PERF_SETS_TL T set (
197: USER_NAME
198: ) = (select
199: B.USER_NAME
200: from BNE_PERF_SETS_TL B
201: where B.SET_CODE = T.SET_CODE
202: and B.LANGUAGE = T.SOURCE_LANG)
203: where (
204: T.SET_CODE,

Line 209: from BNE_PERF_SETS_TL SUBB, BNE_PERF_SETS_TL SUBT

205: T.LANGUAGE
206: ) in (select
207: SUBT.SET_CODE,
208: SUBT.LANGUAGE
209: from BNE_PERF_SETS_TL SUBB, BNE_PERF_SETS_TL SUBT
210: where SUBB.SET_CODE = SUBT.SET_CODE
211: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
212: and (SUBB.USER_NAME <> SUBT.USER_NAME
213: ));

Line 215: insert into BNE_PERF_SETS_TL (

211: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
212: and (SUBB.USER_NAME <> SUBT.USER_NAME
213: ));
214:
215: insert into BNE_PERF_SETS_TL (
216: SET_CODE,
217: USER_NAME,
218: CREATED_BY,
219: CREATION_DATE,

Line 235: from BNE_PERF_SETS_TL B, FND_LANGUAGES L

231: B.LAST_UPDATE_LOGIN,
232: B.LAST_UPDATE_DATE,
233: L.LANGUAGE_CODE,
234: B.SOURCE_LANG
235: from BNE_PERF_SETS_TL B, FND_LANGUAGES L
236: where L.INSTALLED_FLAG in ('I', 'B')
237: and B.LANGUAGE = userenv('LANG')
238: and not exists
239: (select NULL

Line 240: from BNE_PERF_SETS_TL T

236: where L.INSTALLED_FLAG in ('I', 'B')
237: and B.LANGUAGE = userenv('LANG')
238: and not exists
239: (select NULL
240: from BNE_PERF_SETS_TL T
241: where T.SET_CODE = B.SET_CODE
242: and T.LANGUAGE = L.LANGUAGE_CODE);
243: end ADD_LANGUAGE;
244:

Line 279: from BNE_PERF_SETS_TL

275: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
276: begin
277: select LAST_UPDATED_BY, LAST_UPDATE_DATE
278: into db_luby, db_ludate
279: from BNE_PERF_SETS_TL
280: where SET_CODE = x_set_code
281: and LANGUAGE = userenv('LANG');
282:
283: -- Test for customization and version

Line 287: update BNE_PERF_SETS_TL

283: -- Test for customization and version
284: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
285: db_ludate, x_custom_mode)) then
286:
287: update BNE_PERF_SETS_TL
288: set USER_NAME = x_user_name,
289: LAST_UPDATE_DATE = f_ludate,
290: LAST_UPDATED_BY = f_luby,
291: LAST_UPDATE_LOGIN = 0,