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_EXT_FLD_PKG dependencies on BEN_EXT_FLD

Line 1: package body BEN_EXT_FLD_PKG as

1: package body BEN_EXT_FLD_PKG as
2: /* $Header: bexlt01t.pkb 120.5 2006/02/15 14:53:44 tjesumic noship $ */
3:
4: procedure INSERT_ROW (
5: P_ROWID in out nocopy VARCHAR2,

Line 23: cursor C is select ROWID from BEN_EXT_FLD

19: P_LAST_UPDATE_DATE in DATE,
20: P_LAST_UPDATED_BY in NUMBER,
21: P_LAST_UPDATE_LOGIN in NUMBER
22: ) is
23: cursor C is select ROWID from BEN_EXT_FLD
24: where EXT_FLD_ID = P_EXT_FLD_ID
25: ;
26: begin
27: insert into BEN_EXT_FLD (

Line 27: insert into BEN_EXT_FLD (

23: cursor C is select ROWID from BEN_EXT_FLD
24: where EXT_FLD_ID = P_EXT_FLD_ID
25: ;
26: begin
27: insert into BEN_EXT_FLD (
28: EXT_FLD_ID,
29: DECD_FLAG,
30: SHORT_NAME,
31: NAME,

Line 65: ben_ext_fld

61: from dual
62: where not exists
63: ( select
64: 'x' from
65: ben_ext_fld
66: where short_name = p_short_name
67: );
68:
69:

Line 70: insert into BEN_EXT_FLD_TL (

66: where short_name = p_short_name
67: );
68:
69:
70: insert into BEN_EXT_FLD_TL (
71: EXT_FLD_ID,
72: NAME,
73: LAST_UPDATE_DATE,
74: LAST_UPDATED_BY,

Line 94: from BEN_EXT_FLD_TL T

90: from FND_LANGUAGES L
91: where L.INSTALLED_FLAG in ('I', 'B')
92: and not exists
93: (select NULL
94: from BEN_EXT_FLD_TL T
95: where T.EXT_FLD_ID = P_EXT_FLD_ID
96: and T.LANGUAGE = L.LANGUAGE_CODE);
97:
98: open c;

Line 129: from BEN_EXT_FLD

125: LVL_CD,
126: ALWD_IN_RCD_CD,
127: BUSINESS_GROUP_ID,
128: OBJECT_VERSION_NUMBER
129: from BEN_EXT_FLD
130: where EXT_FLD_ID = P_EXT_FLD_ID
131: for update of EXT_FLD_ID nowait;
132: recinfo c%rowtype;
133:

Line 137: from BEN_EXT_FLD_TL

133:
134: cursor c1 is select
135: NAME,
136: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
137: from BEN_EXT_FLD_TL
138: where EXT_FLD_ID = P_EXT_FLD_ID
139: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
140: for update of EXT_FLD_ID nowait;
141: begin

Line 204: update BEN_EXT_FLD set

200: P_LAST_UPDATED_BY in NUMBER,
201: P_LAST_UPDATE_LOGIN in NUMBER
202: ) is
203: begin
204: update BEN_EXT_FLD set
205: DECD_FLAG = P_DECD_FLAG,
206: SHORT_NAME = P_SHORT_NAME,
207: NAME = P_NAME,
208: FRMT_MASK_TYP_CD = P_FRMT_MASK_TYP_CD,

Line 224: update BEN_EXT_FLD_TL set

220: if (sql%notfound) then
221: raise no_data_found;
222: end if;
223:
224: update BEN_EXT_FLD_TL set
225: NAME = P_NAME,
226: LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,
227: LAST_UPDATED_BY = P_LAST_UPDATED_BY,
228: LAST_UPDATE_LOGIN = P_LAST_UPDATE_LOGIN,

Line 242: delete from BEN_EXT_FLD_TL

238: procedure DELETE_ROW (
239: P_EXT_FLD_ID in NUMBER
240: ) is
241: begin
242: delete from BEN_EXT_FLD_TL
243: where EXT_FLD_ID = P_EXT_FLD_ID;
244:
245: if (sql%notfound) then
246: raise no_data_found;

Line 249: delete from BEN_EXT_FLD

245: if (sql%notfound) then
246: raise no_data_found;
247: end if;
248:
249: delete from BEN_EXT_FLD
250: where EXT_FLD_ID = P_EXT_FLD_ID;
251:
252: if (sql%notfound) then
253: raise no_data_found;

Line 260: delete from BEN_EXT_FLD_TL T

256:
257: procedure ADD_LANGUAGE
258: is
259: begin
260: delete from BEN_EXT_FLD_TL T
261: where not exists
262: (select NULL
263: from BEN_EXT_FLD B
264: where B.EXT_FLD_ID = T.EXT_FLD_ID

Line 263: from BEN_EXT_FLD B

259: begin
260: delete from BEN_EXT_FLD_TL T
261: where not exists
262: (select NULL
263: from BEN_EXT_FLD B
264: where B.EXT_FLD_ID = T.EXT_FLD_ID
265: );
266:
267: update BEN_EXT_FLD_TL T set (

Line 267: update BEN_EXT_FLD_TL T set (

263: from BEN_EXT_FLD B
264: where B.EXT_FLD_ID = T.EXT_FLD_ID
265: );
266:
267: update BEN_EXT_FLD_TL T set (
268: NAME
269: ) = (select
270: B.NAME
271: from BEN_EXT_FLD_TL B

Line 271: from BEN_EXT_FLD_TL B

267: update BEN_EXT_FLD_TL T set (
268: NAME
269: ) = (select
270: B.NAME
271: from BEN_EXT_FLD_TL B
272: where B.EXT_FLD_ID = T.EXT_FLD_ID
273: and B.LANGUAGE = T.SOURCE_LANG)
274: where (
275: T.EXT_FLD_ID,

Line 280: from BEN_EXT_FLD_TL SUBB, BEN_EXT_FLD_TL SUBT

276: T.LANGUAGE
277: ) in (select
278: SUBT.EXT_FLD_ID,
279: SUBT.LANGUAGE
280: from BEN_EXT_FLD_TL SUBB, BEN_EXT_FLD_TL SUBT
281: where SUBB.EXT_FLD_ID = SUBT.EXT_FLD_ID
282: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
283: and (SUBB.NAME <> SUBT.NAME
284: or (SUBB.NAME is null and SUBT.NAME is not null)

Line 288: insert into BEN_EXT_FLD_TL (

284: or (SUBB.NAME is null and SUBT.NAME is not null)
285: or (SUBB.NAME is not null and SUBT.NAME is null)
286: ));
287:
288: insert into BEN_EXT_FLD_TL (
289: EXT_FLD_ID,
290: NAME,
291: LAST_UPDATE_DATE,
292: LAST_UPDATED_BY,

Line 308: from BEN_EXT_FLD_TL B, FND_LANGUAGES L

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

Line 313: from BEN_EXT_FLD_TL T

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

Line 318: end BEN_EXT_FLD_PKG;

314: where T.EXT_FLD_ID = B.EXT_FLD_ID
315: and T.LANGUAGE = L.LANGUAGE_CODE);
316: end ADD_LANGUAGE;
317:
318: end BEN_EXT_FLD_PKG;
319:
320: