eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_STARTUP_LERS_PKG dependencies on BEN_STARTUP_LERS

Line 1: package body BEN_STARTUP_LERS_PKG as

1: package body BEN_STARTUP_LERS_PKG as
2: /* $Header: beslr01t.pkb 120.0 2005/05/28 11:52:44 appldev noship $ */
3: procedure OWNER_TO_WHO (
4: P_OWNER in VARCHAR2,
5: P_CREATION_DATE out nocopy DATE,

Line 34: cursor C is select ROWID from BEN_STARTUP_LERS

30: P_LAST_UPDATE_DATE in DATE,
31: P_LAST_UPDATED_BY in NUMBER,
32: P_LAST_UPDATE_LOGIN in NUMBER
33: ) is
34: cursor C is select ROWID from BEN_STARTUP_LERS
35: where TYP_CD = P_TYP_CD
36: ;
37: begin
38: insert into BEN_STARTUP_LERS (

Line 38: insert into BEN_STARTUP_LERS (

34: cursor C is select ROWID from BEN_STARTUP_LERS
35: where TYP_CD = P_TYP_CD
36: ;
37: begin
38: insert into BEN_STARTUP_LERS (
39: TYP_CD,
40: NAME,
41: CREATION_DATE,
42: CREATED_BY,

Line 56: insert into BEN_STARTUP_LERS_TL (

52: P_LAST_UPDATED_BY,
53: P_LAST_UPDATE_LOGIN
54: );
55:
56: insert into BEN_STARTUP_LERS_TL (
57: LAST_UPDATED_BY,
58: LAST_UPDATE_LOGIN,
59: CREATED_BY,
60: CREATION_DATE,

Line 80: from BEN_STARTUP_LERS_TL T

76: from FND_LANGUAGES L
77: where L.INSTALLED_FLAG in ('I', 'B')
78: and not exists
79: (select NULL
80: from BEN_STARTUP_LERS_TL T
81: where T.TYP_CD = P_TYP_CD
82: and T.LANGUAGE = L.LANGUAGE_CODE);
83:
84: open c;

Line 99: from BEN_STARTUP_LERS

95: P_TYP_CD in VARCHAR2,
96: P_NAME in VARCHAR2
97: ) is
98: cursor c is select TYP_CD,NAME
99: from BEN_STARTUP_LERS
100: where TYP_CD = P_TYP_CD
101: for update of TYP_CD nowait;
102: recinfo c%rowtype;
103:

Line 107: from BEN_STARTUP_LERS_TL

103:
104: cursor c1 is select
105: NAME,
106: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
107: from BEN_STARTUP_LERS_TL
108: where TYP_CD = P_TYP_CD
109: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
110: for update of TYP_CD nowait;
111: begin

Line 150: update BEN_STARTUP_LERS set

146: P_LAST_UPDATED_BY in NUMBER,
147: P_LAST_UPDATE_LOGIN in NUMBER
148: ) is
149: begin
150: update BEN_STARTUP_LERS set
151: NAME = decode(userenv('LANG'),'US',P_NAME,NAME),
152: LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,
153: LAST_UPDATED_BY = P_LAST_UPDATED_BY,
154: LAST_UPDATE_LOGIN = P_LAST_UPDATE_LOGIN

Line 161: update BEN_STARTUP_LERS_TL set

157: if (sql%notfound) then
158: raise no_data_found;
159: end if;
160:
161: update BEN_STARTUP_LERS_TL set
162: NAME = P_NAME,
163: LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,
164: LAST_UPDATED_BY = P_LAST_UPDATED_BY,
165: LAST_UPDATE_LOGIN = P_LAST_UPDATE_LOGIN,

Line 179: delete from BEN_STARTUP_LERS_TL

175: procedure DELETE_ROW (
176: P_TYP_CD in VARCHAR2
177: ) is
178: begin
179: delete from BEN_STARTUP_LERS_TL
180: where TYP_CD = P_TYP_CD;
181:
182: if (sql%notfound) then
183: raise no_data_found;

Line 186: delete from BEN_STARTUP_LERS

182: if (sql%notfound) then
183: raise no_data_found;
184: end if;
185:
186: delete from BEN_STARTUP_LERS
187: where TYP_CD = P_TYP_CD;
188:
189: if (sql%notfound) then
190: raise no_data_found;

Line 249: update BEN_STARTUP_LERS_TL T set

245: L_LAST_UPDATED_BY,
246: L_LAST_UPDATE_LOGIN
247: );
248: --
249: update BEN_STARTUP_LERS_TL T set
250: NAME = P_NAME,
251: LAST_UPDATE_DATE = L_LAST_UPDATE_DATE,
252: LAST_UPDATED_BY = L_LAST_UPDATED_BY,
253: LAST_UPDATE_LOGIN = L_LAST_UPDATE_LOGIN,

Line 263: delete from BEN_STARTUP_LERS_TL T

259:
260: procedure ADD_LANGUAGE
261: is
262: begin
263: delete from BEN_STARTUP_LERS_TL T
264: where not exists
265: (select NULL
266: from BEN_STARTUP_LERS B
267: where B.TYP_CD = T.TYP_CD

Line 266: from BEN_STARTUP_LERS B

262: begin
263: delete from BEN_STARTUP_LERS_TL T
264: where not exists
265: (select NULL
266: from BEN_STARTUP_LERS B
267: where B.TYP_CD = T.TYP_CD
268: );
269:
270: update BEN_STARTUP_LERS_TL T set (

Line 270: update BEN_STARTUP_LERS_TL T set (

266: from BEN_STARTUP_LERS B
267: where B.TYP_CD = T.TYP_CD
268: );
269:
270: update BEN_STARTUP_LERS_TL T set (
271: NAME
272: ) = (select
273: B.NAME
274: from BEN_STARTUP_LERS_TL B

Line 274: from BEN_STARTUP_LERS_TL B

270: update BEN_STARTUP_LERS_TL T set (
271: NAME
272: ) = (select
273: B.NAME
274: from BEN_STARTUP_LERS_TL B
275: where B.TYP_CD = T.TYP_CD
276: and B.LANGUAGE = T.SOURCE_LANG)
277: where (
278: T.TYP_CD,

Line 283: from BEN_STARTUP_LERS_TL SUBB, BEN_STARTUP_LERS_TL SUBT

279: T.LANGUAGE
280: ) in (select
281: SUBT.TYP_CD,
282: SUBT.LANGUAGE
283: from BEN_STARTUP_LERS_TL SUBB, BEN_STARTUP_LERS_TL SUBT
284: where SUBB.TYP_CD = SUBT.TYP_CD
285: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
286: and (SUBB.NAME <> SUBT.NAME
287: ));

Line 289: insert into BEN_STARTUP_LERS_TL (

285: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
286: and (SUBB.NAME <> SUBT.NAME
287: ));
288:
289: insert into BEN_STARTUP_LERS_TL (
290: LAST_UPDATED_BY,
291: LAST_UPDATE_LOGIN,
292: CREATED_BY,
293: CREATION_DATE,

Line 309: from BEN_STARTUP_LERS_TL B, FND_LANGUAGES L

305: B.NAME,
306: B.LAST_UPDATE_DATE,
307: L.LANGUAGE_CODE,
308: B.SOURCE_LANG
309: from BEN_STARTUP_LERS_TL B, FND_LANGUAGES L
310: where L.INSTALLED_FLAG in ('I', 'B')
311: and B.LANGUAGE = userenv('LANG')
312: and not exists
313: (select NULL

Line 314: from BEN_STARTUP_LERS_TL T

310: where L.INSTALLED_FLAG in ('I', 'B')
311: and B.LANGUAGE = userenv('LANG')
312: and not exists
313: (select NULL
314: from BEN_STARTUP_LERS_TL T
315: where T.TYP_CD = B.TYP_CD
316: and T.LANGUAGE = L.LANGUAGE_CODE);
317: end ADD_LANGUAGE;
318:

Line 319: end BEN_STARTUP_LERS_PKG;

315: where T.TYP_CD = B.TYP_CD
316: and T.LANGUAGE = L.LANGUAGE_CODE);
317: end ADD_LANGUAGE;
318:
319: end BEN_STARTUP_LERS_PKG;