APPS.BEN_STARTUP_REGN_PKG dependencies on BEN_STARTUP_REGN

Line 1: package body BEN_STARTUP_REGN_PKG as

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

Line 35: cursor C is select ROWID from BEN_STARTUP_REGN

31: P_LAST_UPDATE_DATE in DATE,
32: P_LAST_UPDATED_BY in NUMBER,
33: P_LAST_UPDATE_LOGIN in NUMBER
34: ) is
35: cursor C is select ROWID from BEN_STARTUP_REGN
36: where STTRY_CITN_NAME = P_STTRY_CITN_NAME
37: ;
38: begin
39: insert into BEN_STARTUP_REGN (

Line 39: insert into BEN_STARTUP_REGN (

35: cursor C is select ROWID from BEN_STARTUP_REGN
36: where STTRY_CITN_NAME = P_STTRY_CITN_NAME
37: ;
38: begin
39: insert into BEN_STARTUP_REGN (
40: STTRY_CITN_NAME,
41: NAME,
42: LEGISLATION_CODE,
43: CREATION_DATE,

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 104: from BEN_STARTUP_REGN

100: P_NAME in VARCHAR2
101: ) is
102: cursor c is select
103: LEGISLATION_CODE
104: from BEN_STARTUP_REGN
105: where STTRY_CITN_NAME = P_STTRY_CITN_NAME
106: for update of STTRY_CITN_NAME nowait;
107: recinfo c%rowtype;
108:

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 156: update BEN_STARTUP_REGN set

152: P_LAST_UPDATED_BY in NUMBER,
153: P_LAST_UPDATE_LOGIN in NUMBER
154: ) is
155: begin
156: update BEN_STARTUP_REGN set
157: NAME = decode(userenv('LANG'),'US',P_NAME,NAME),
158: LEGISLATION_CODE = P_LEGISLATION_CODE,
159: LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,
160: LAST_UPDATED_BY = P_LAST_UPDATED_BY,

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 193: delete from BEN_STARTUP_REGN

189: if (sql%notfound) then
190: raise no_data_found;
191: end if;
192:
193: delete from BEN_STARTUP_REGN
194: where STTRY_CITN_NAME = P_STTRY_CITN_NAME;
195:
196: if (sql%notfound) then
197: 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 279: from BEN_STARTUP_REGN B

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
281: );
282:
283: update BEN_STARTUP_REGN_TL T set (

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:

Line 332: end BEN_STARTUP_REGN_PKG;

328: where T.STTRY_CITN_NAME = B.STTRY_CITN_NAME
329: and T.LANGUAGE = L.LANGUAGE_CODE);
330: end ADD_LANGUAGE;
331:
332: end BEN_STARTUP_REGN_PKG;