APPS.BEN_STARTUP_REGN_PKG dependencies on BEN_STARTUP_REGN_TL

Line 59: insert into BEN_STARTUP_REGN_TL (

55: P_LAST_UPDATED_BY,
56: P_LAST_UPDATE_LOGIN
57: );
58:
59: insert into BEN_STARTUP_REGN_TL (
60: NAME,
61: STTRY_CITN_NAME,
62: LAST_UPDATE_DATE,
63: LAST_UPDATED_BY,

Line 83: from BEN_STARTUP_REGN_TL T

79: from FND_LANGUAGES L
80: where L.INSTALLED_FLAG in ('I', 'B')
81: and not exists
82: (select NULL
83: from BEN_STARTUP_REGN_TL T
84: where T.STTRY_CITN_NAME = P_STTRY_CITN_NAME
85: and T.LANGUAGE = L.LANGUAGE_CODE);
86:
87: open c;

Line 112: from BEN_STARTUP_REGN_TL

108:
109: cursor c1 is select
110: NAME,
111: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
112: from BEN_STARTUP_REGN_TL
113: where STTRY_CITN_NAME = P_STTRY_CITN_NAME
114: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
115: for update of STTRY_CITN_NAME nowait;
116: begin

Line 168: update BEN_STARTUP_REGN_TL set

164: if (sql%notfound) then
165: raise no_data_found;
166: end if;
167:
168: update BEN_STARTUP_REGN_TL set
169: NAME = P_NAME,
170: LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,
171: LAST_UPDATED_BY = P_LAST_UPDATED_BY,
172: LAST_UPDATE_LOGIN = P_LAST_UPDATE_LOGIN,

Line 186: delete from BEN_STARTUP_REGN_TL

182: procedure DELETE_ROW (
183: P_STTRY_CITN_NAME in VARCHAR2
184: ) is
185: begin
186: delete from BEN_STARTUP_REGN_TL
187: where STTRY_CITN_NAME = P_STTRY_CITN_NAME;
188:
189: if (sql%notfound) then
190: raise no_data_found;

Line 261: update BEN_STARTUP_REGN_TL T set

257: L_LAST_UPDATED_BY,
258: L_LAST_UPDATE_LOGIN
259: );
260: --
261: update BEN_STARTUP_REGN_TL T set
262: NAME = P_NAME,
263: LAST_UPDATE_DATE = L_LAST_UPDATE_DATE,
264: LAST_UPDATED_BY = L_LAST_UPDATED_BY,
265: LAST_UPDATE_LOGIN = L_LAST_UPDATE_LOGIN,

Line 276: delete from BEN_STARTUP_REGN_TL T

272:
273: procedure ADD_LANGUAGE
274: is
275: begin
276: delete from BEN_STARTUP_REGN_TL T
277: where not exists
278: (select NULL
279: from BEN_STARTUP_REGN B
280: where B.STTRY_CITN_NAME = T.STTRY_CITN_NAME

Line 283: update BEN_STARTUP_REGN_TL T set (

279: from BEN_STARTUP_REGN B
280: where B.STTRY_CITN_NAME = T.STTRY_CITN_NAME
281: );
282:
283: update BEN_STARTUP_REGN_TL T set (
284: NAME
285: ) = (select
286: B.NAME
287: from BEN_STARTUP_REGN_TL B

Line 287: from BEN_STARTUP_REGN_TL B

283: update BEN_STARTUP_REGN_TL T set (
284: NAME
285: ) = (select
286: B.NAME
287: from BEN_STARTUP_REGN_TL B
288: where B.STTRY_CITN_NAME = T.STTRY_CITN_NAME
289: and B.LANGUAGE = T.SOURCE_LANG)
290: where (
291: T.STTRY_CITN_NAME,

Line 296: from BEN_STARTUP_REGN_TL SUBB, BEN_STARTUP_REGN_TL SUBT

292: T.LANGUAGE
293: ) in (select
294: SUBT.STTRY_CITN_NAME,
295: SUBT.LANGUAGE
296: from BEN_STARTUP_REGN_TL SUBB, BEN_STARTUP_REGN_TL SUBT
297: where SUBB.STTRY_CITN_NAME = SUBT.STTRY_CITN_NAME
298: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
299: and (SUBB.NAME <> SUBT.NAME
300: ));

Line 302: insert into BEN_STARTUP_REGN_TL (

298: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
299: and (SUBB.NAME <> SUBT.NAME
300: ));
301:
302: insert into BEN_STARTUP_REGN_TL (
303: NAME,
304: STTRY_CITN_NAME,
305: LAST_UPDATE_DATE,
306: LAST_UPDATED_BY,

Line 322: from BEN_STARTUP_REGN_TL B, FND_LANGUAGES L

318: B.CREATED_BY,
319: B.CREATION_DATE,
320: L.LANGUAGE_CODE,
321: B.SOURCE_LANG
322: from BEN_STARTUP_REGN_TL B, FND_LANGUAGES L
323: where L.INSTALLED_FLAG in ('I', 'B')
324: and B.LANGUAGE = userenv('LANG')
325: and not exists
326: (select NULL

Line 327: from BEN_STARTUP_REGN_TL T

323: where L.INSTALLED_FLAG in ('I', 'B')
324: and B.LANGUAGE = userenv('LANG')
325: and not exists
326: (select NULL
327: from BEN_STARTUP_REGN_TL T
328: where T.STTRY_CITN_NAME = B.STTRY_CITN_NAME
329: and T.LANGUAGE = L.LANGUAGE_CODE);
330: end ADD_LANGUAGE;
331: