APPS.BEN_EXT_FLD_PKG dependencies on BEN_EXT_FLD_TL

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 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 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 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 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: