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_STARTUP_CM_TYP_PKG dependencies on BEN_STARTUP_CM_TYP

Line 1: package body BEN_STARTUP_CM_TYP_PKG as

1: package body BEN_STARTUP_CM_TYP_PKG as
2: /* $Header: besct01t.pkb 115.3 2002/12/16 12:11:17 vsethi noship $ */
3: procedure OWNER_TO_WHO (
4: P_OWNER in VARCHAR2,
5: P_CREATION_DATE out nocopy DATE,

Line 39: cursor C is select ROWID from BEN_STARTUP_CM_TYP

35: P_LAST_UPDATE_DATE in DATE,
36: P_LAST_UPDATED_BY in NUMBER,
37: P_LAST_UPDATE_LOGIN in NUMBER
38: ) is
39: cursor C is select ROWID from BEN_STARTUP_CM_TYP
40: where SHRT_NAME = P_SHRT_NAME
41: ;
42: begin
43: insert into BEN_STARTUP_CM_TYP (

Line 43: insert into BEN_STARTUP_CM_TYP (

39: cursor C is select ROWID from BEN_STARTUP_CM_TYP
40: where SHRT_NAME = P_SHRT_NAME
41: ;
42: begin
43: insert into BEN_STARTUP_CM_TYP (
44: WHNVR_TRGRD_FLAG,
45: SHRT_NAME,
46: NAME,
47: PC_KIT_CD,

Line 71: insert into BEN_STARTUP_CM_TYP_TL (

67: P_LAST_UPDATED_BY,
68: P_LAST_UPDATE_LOGIN
69: );
70:
71: insert into BEN_STARTUP_CM_TYP_TL (
72: CREATED_BY,
73: CREATION_DATE,
74: LAST_UPDATE_DATE,
75: LAST_UPDATED_BY,

Line 95: from BEN_STARTUP_CM_TYP_TL T

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

Line 124: from BEN_STARTUP_CM_TYP

120: PC_KIT_CD,
121: TRK_MLG_FLAG,
122: TO_BE_SENT_DT_CD,
123: INSPN_RQD_FLAG
124: from BEN_STARTUP_CM_TYP
125: where SHRT_NAME = P_SHRT_NAME
126: for update of SHRT_NAME nowait;
127: recinfo c%rowtype;
128:

Line 132: from BEN_STARTUP_CM_TYP_TL

128:
129: cursor c1 is select
130: NAME,
131: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
132: from BEN_STARTUP_CM_TYP_TL
133: where SHRT_NAME = P_SHRT_NAME
134: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
135: for update of SHRT_NAME nowait;
136: begin

Line 185: update BEN_STARTUP_CM_TYP set

181: P_LAST_UPDATED_BY in NUMBER,
182: P_LAST_UPDATE_LOGIN in NUMBER
183: ) is
184: begin
185: update BEN_STARTUP_CM_TYP set
186: WHNVR_TRGRD_FLAG = P_WHNVR_TRGRD_FLAG,
187: PC_KIT_CD = P_PC_KIT_CD,
188: TRK_MLG_FLAG = P_TRK_MLG_FLAG,
189: TO_BE_SENT_DT_CD = P_TO_BE_SENT_DT_CD,

Line 201: update BEN_STARTUP_CM_TYP_TL set

197: if (sql%notfound) then
198: raise no_data_found;
199: end if;
200:
201: update BEN_STARTUP_CM_TYP_TL set
202: NAME = P_NAME,
203: LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,
204: LAST_UPDATED_BY = P_LAST_UPDATED_BY,
205: LAST_UPDATE_LOGIN = P_LAST_UPDATE_LOGIN,

Line 219: delete from BEN_STARTUP_CM_TYP_TL

215: procedure DELETE_ROW (
216: P_SHRT_NAME in VARCHAR2
217: ) is
218: begin
219: delete from BEN_STARTUP_CM_TYP_TL
220: where SHRT_NAME = P_SHRT_NAME;
221:
222: if (sql%notfound) then
223: raise no_data_found;

Line 226: delete from BEN_STARTUP_CM_TYP

222: if (sql%notfound) then
223: raise no_data_found;
224: end if;
225:
226: delete from BEN_STARTUP_CM_TYP
227: where SHRT_NAME = P_SHRT_NAME;
228:
229: if (sql%notfound) then
230: raise no_data_found;

Line 305: update BEN_STARTUP_CM_TYP_TL set

301: L_LAST_UPDATED_BY,
302: L_LAST_UPDATE_LOGIN
303: );
304: --
305: update BEN_STARTUP_CM_TYP_TL set
306: NAME = P_NAME,
307: LAST_UPDATE_DATE = L_LAST_UPDATE_DATE,
308: LAST_UPDATED_BY = L_LAST_UPDATED_BY,
309: LAST_UPDATE_LOGIN = L_LAST_UPDATE_LOGIN,

Line 318: delete from BEN_STARTUP_CM_TYP_TL T

314:
315: procedure ADD_LANGUAGE
316: is
317: begin
318: delete from BEN_STARTUP_CM_TYP_TL T
319: where not exists
320: (select NULL
321: from BEN_STARTUP_CM_TYP B
322: where B.SHRT_NAME = T.SHRT_NAME

Line 321: from BEN_STARTUP_CM_TYP B

317: begin
318: delete from BEN_STARTUP_CM_TYP_TL T
319: where not exists
320: (select NULL
321: from BEN_STARTUP_CM_TYP B
322: where B.SHRT_NAME = T.SHRT_NAME
323: );
324:
325: update BEN_STARTUP_CM_TYP_TL T set (

Line 325: update BEN_STARTUP_CM_TYP_TL T set (

321: from BEN_STARTUP_CM_TYP B
322: where B.SHRT_NAME = T.SHRT_NAME
323: );
324:
325: update BEN_STARTUP_CM_TYP_TL T set (
326: NAME
327: ) = (select
328: B.NAME
329: from BEN_STARTUP_CM_TYP_TL B

Line 329: from BEN_STARTUP_CM_TYP_TL B

325: update BEN_STARTUP_CM_TYP_TL T set (
326: NAME
327: ) = (select
328: B.NAME
329: from BEN_STARTUP_CM_TYP_TL B
330: where B.SHRT_NAME = T.SHRT_NAME
331: and B.LANGUAGE = T.SOURCE_LANG)
332: where (
333: T.SHRT_NAME,

Line 338: from BEN_STARTUP_CM_TYP_TL SUBB, BEN_STARTUP_CM_TYP_TL SUBT

334: T.LANGUAGE
335: ) in (select
336: SUBT.SHRT_NAME,
337: SUBT.LANGUAGE
338: from BEN_STARTUP_CM_TYP_TL SUBB, BEN_STARTUP_CM_TYP_TL SUBT
339: where SUBB.SHRT_NAME = SUBT.SHRT_NAME
340: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
341: and (SUBB.NAME <> SUBT.NAME
342: ));

Line 344: insert into BEN_STARTUP_CM_TYP_TL (

340: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
341: and (SUBB.NAME <> SUBT.NAME
342: ));
343:
344: insert into BEN_STARTUP_CM_TYP_TL (
345: CREATED_BY,
346: CREATION_DATE,
347: LAST_UPDATE_DATE,
348: LAST_UPDATED_BY,

Line 364: from BEN_STARTUP_CM_TYP_TL B, FND_LANGUAGES L

360: B.SHRT_NAME,
361: B.NAME,
362: L.LANGUAGE_CODE,
363: B.SOURCE_LANG
364: from BEN_STARTUP_CM_TYP_TL B, FND_LANGUAGES L
365: where L.INSTALLED_FLAG in ('I', 'B')
366: and B.LANGUAGE = userenv('LANG')
367: and not exists
368: (select NULL

Line 369: from BEN_STARTUP_CM_TYP_TL T

365: where L.INSTALLED_FLAG in ('I', 'B')
366: and B.LANGUAGE = userenv('LANG')
367: and not exists
368: (select NULL
369: from BEN_STARTUP_CM_TYP_TL T
370: where T.SHRT_NAME = B.SHRT_NAME
371: and T.LANGUAGE = L.LANGUAGE_CODE);
372: end ADD_LANGUAGE;
373:

Line 374: end BEN_STARTUP_CM_TYP_PKG;

370: where T.SHRT_NAME = B.SHRT_NAME
371: and T.LANGUAGE = L.LANGUAGE_CODE);
372: end ADD_LANGUAGE;
373:
374: end BEN_STARTUP_CM_TYP_PKG;