APPS.BEN_STARTUP_ACTN_TYP_PKG dependencies on BEN_STARTUP_ACTN_TYP_TL

Line 59: insert into BEN_STARTUP_ACTN_TYP_TL (

55: P_LAST_UPDATED_BY,
56: P_LAST_UPDATE_LOGIN
57: );
58:
59: insert into BEN_STARTUP_ACTN_TYP_TL (
60: LAST_UPDATE_LOGIN,
61: CREATED_BY,
62: CREATION_DATE,
63: DESCRIPTION,

Line 85: from BEN_STARTUP_ACTN_TYP_TL T

81: from FND_LANGUAGES L
82: where L.INSTALLED_FLAG in ('I', 'B')
83: and not exists
84: (select NULL
85: from BEN_STARTUP_ACTN_TYP_TL T
86: where T.TYPE_CD = P_TYPE_CD
87: and T.LANGUAGE = L.LANGUAGE_CODE);
88:
89: open c;

Line 114: from BEN_STARTUP_ACTN_TYP_TL

110:
111: cursor c1 is select
112: NAME,
113: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
114: from BEN_STARTUP_ACTN_TYP_TL
115: where TYPE_CD = P_TYPE_CD
116: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
117: for update of TYPE_CD nowait;
118: begin

Line 170: update BEN_STARTUP_ACTN_TYP_TL set

166: if (sql%notfound) then
167: raise no_data_found;
168: end if;
169:
170: update BEN_STARTUP_ACTN_TYP_TL set
171: NAME = P_NAME,
172: DESCRIPTION = P_DESCRIPTION,
173: LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,
174: LAST_UPDATED_BY = P_LAST_UPDATED_BY,

Line 189: delete from BEN_STARTUP_ACTN_TYP_TL

185: procedure DELETE_ROW (
186: P_TYPE_CD in VARCHAR2
187: ) is
188: begin
189: delete from BEN_STARTUP_ACTN_TYP_TL
190: where TYPE_CD = P_TYPE_CD;
191:
192: if (sql%notfound) then
193: raise no_data_found;

Line 268: update BEN_STARTUP_ACTN_TYP_TL set

264: L_LAST_UPDATED_BY,
265: L_LAST_UPDATE_LOGIN
266: );
267: --
268: update BEN_STARTUP_ACTN_TYP_TL set
269: NAME = P_NAME,
270: DESCRIPTION = P_DESCRIPTION ,
271: LAST_UPDATE_DATE = L_LAST_UPDATE_DATE,
272: LAST_UPDATED_BY = L_LAST_UPDATED_BY,

Line 283: delete from BEN_STARTUP_ACTN_TYP_TL T

279:
280: procedure ADD_LANGUAGE
281: is
282: begin
283: delete from BEN_STARTUP_ACTN_TYP_TL T
284: where not exists
285: (select NULL
286: from BEN_STARTUP_ACTN_TYP B
287: where B.TYPE_CD = T.TYPE_CD

Line 290: update BEN_STARTUP_ACTN_TYP_TL T set (

286: from BEN_STARTUP_ACTN_TYP B
287: where B.TYPE_CD = T.TYPE_CD
288: );
289:
290: update BEN_STARTUP_ACTN_TYP_TL T set (
291: NAME , DESCRIPTION
292: ) = (select
293: B.NAME , B.DESCRIPTION
294: from BEN_STARTUP_ACTN_TYP_TL B

Line 294: from BEN_STARTUP_ACTN_TYP_TL B

290: update BEN_STARTUP_ACTN_TYP_TL T set (
291: NAME , DESCRIPTION
292: ) = (select
293: B.NAME , B.DESCRIPTION
294: from BEN_STARTUP_ACTN_TYP_TL B
295: where B.TYPE_CD = T.TYPE_CD
296: and B.LANGUAGE = T.SOURCE_LANG)
297: where (
298: T.TYPE_CD,

Line 303: from BEN_STARTUP_ACTN_TYP_TL SUBB, BEN_STARTUP_ACTN_TYP_TL SUBT

299: T.LANGUAGE
300: ) in (select
301: SUBT.TYPE_CD,
302: SUBT.LANGUAGE
303: from BEN_STARTUP_ACTN_TYP_TL SUBB, BEN_STARTUP_ACTN_TYP_TL SUBT
304: where SUBB.TYPE_CD = SUBT.TYPE_CD
305: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
306: and (SUBB.NAME <> SUBT.NAME
307: ));

Line 309: insert into BEN_STARTUP_ACTN_TYP_TL (

305: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
306: and (SUBB.NAME <> SUBT.NAME
307: ));
308:
309: insert into BEN_STARTUP_ACTN_TYP_TL (
310: LAST_UPDATE_LOGIN,
311: CREATED_BY,
312: CREATION_DATE,
313: DESCRIPTION,

Line 331: from BEN_STARTUP_ACTN_TYP_TL B, FND_LANGUAGES L

327: B.NAME,
328: B.TYPE_CD,
329: L.LANGUAGE_CODE,
330: B.SOURCE_LANG
331: from BEN_STARTUP_ACTN_TYP_TL B, FND_LANGUAGES L
332: where L.INSTALLED_FLAG in ('I', 'B')
333: and B.LANGUAGE = userenv('LANG')
334: and not exists
335: (select NULL

Line 336: from BEN_STARTUP_ACTN_TYP_TL T

332: where L.INSTALLED_FLAG in ('I', 'B')
333: and B.LANGUAGE = userenv('LANG')
334: and not exists
335: (select NULL
336: from BEN_STARTUP_ACTN_TYP_TL T
337: where T.TYPE_CD = B.TYPE_CD
338: and T.LANGUAGE = L.LANGUAGE_CODE);
339: end ADD_LANGUAGE;
340: