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.XDP_ACTION_CODES_PKG dependencies on XDP_ACTION_CODES

Line 1: package body XDP_ACTION_CODES_PKG as

1: package body XDP_ACTION_CODES_PKG as
2: /* $Header: XDPACTNB.pls 120.1 2005/06/08 23:36:10 appldev $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in OUT NOCOPY VARCHAR2,

Line 16: cursor C is select ROWID from XDP_ACTION_CODES

12: X_LAST_UPDATE_DATE in DATE,
13: X_LAST_UPDATED_BY in NUMBER,
14: X_LAST_UPDATE_LOGIN in NUMBER
15: ) is
16: cursor C is select ROWID from XDP_ACTION_CODES
17: where ACTION_CODE_ID = X_ACTION_CODE_ID
18: ;
19: begin
20: insert into XDP_ACTION_CODES (

Line 20: insert into XDP_ACTION_CODES (

16: cursor C is select ROWID from XDP_ACTION_CODES
17: where ACTION_CODE_ID = X_ACTION_CODE_ID
18: ;
19: begin
20: insert into XDP_ACTION_CODES (
21: ACTION_CODE_ID,
22: ACTION_CODE,
23: CREATION_DATE,
24: CREATED_BY,

Line 38: insert into XDP_ACTION_CODES_TL (

34: X_LAST_UPDATED_BY,
35: X_LAST_UPDATE_LOGIN
36: );
37:
38: insert into XDP_ACTION_CODES_TL (
39: ACTION_CODE_ID,
40: DISPLAY_NAME,
41: DESCRIPTION,
42: CREATED_BY,

Line 64: from XDP_ACTION_CODES_TL T

60: from FND_LANGUAGES L
61: where L.INSTALLED_FLAG in ('I', 'B')
62: and not exists
63: (select NULL
64: from XDP_ACTION_CODES_TL T
65: where T.ACTION_CODE_ID = X_ACTION_CODE_ID
66: and T.LANGUAGE = L.LANGUAGE_CODE);
67:
68: open c;

Line 86: from XDP_ACTION_CODES

82: X_DESCRIPTION in VARCHAR2
83: ) is
84: cursor c is select
85: ACTION_CODE
86: from XDP_ACTION_CODES
87: where ACTION_CODE_ID = X_ACTION_CODE_ID
88: for update of ACTION_CODE_ID nowait;
89: recinfo c%rowtype;
90:

Line 95: from XDP_ACTION_CODES_TL

91: cursor c1 is select
92: DISPLAY_NAME,
93: DESCRIPTION,
94: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
95: from XDP_ACTION_CODES_TL
96: where ACTION_CODE_ID = X_ACTION_CODE_ID
97: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
98: for update of ACTION_CODE_ID nowait;
99: begin

Line 142: update XDP_ACTION_CODES set

138: X_LAST_UPDATED_BY in NUMBER,
139: X_LAST_UPDATE_LOGIN in NUMBER
140: ) is
141: begin
142: update XDP_ACTION_CODES set
143: ACTION_CODE = X_ACTION_CODE,
144: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
145: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
146: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 153: update XDP_ACTION_CODES_TL set

149: if (sql%notfound) then
150: raise no_data_found;
151: end if;
152:
153: update XDP_ACTION_CODES_TL set
154: DISPLAY_NAME = X_DISPLAY_NAME,
155: DESCRIPTION = X_DESCRIPTION,
156: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
157: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 172: delete from XDP_ACTION_CODES_TL

168: procedure DELETE_ROW (
169: X_ACTION_CODE_ID in NUMBER
170: ) is
171: begin
172: delete from XDP_ACTION_CODES_TL
173: where ACTION_CODE_ID = X_ACTION_CODE_ID;
174:
175: if (sql%notfound) then
176: raise no_data_found;

Line 179: delete from XDP_ACTION_CODES

175: if (sql%notfound) then
176: raise no_data_found;
177: end if;
178:
179: delete from XDP_ACTION_CODES
180: where ACTION_CODE_ID = X_ACTION_CODE_ID;
181:
182: if (sql%notfound) then
183: raise no_data_found;

Line 190: delete from XDP_ACTION_CODES_TL T

186:
187: procedure ADD_LANGUAGE
188: is
189: begin
190: delete from XDP_ACTION_CODES_TL T
191: where not exists
192: (select NULL
193: from XDP_ACTION_CODES B
194: where B.ACTION_CODE_ID = T.ACTION_CODE_ID

Line 193: from XDP_ACTION_CODES B

189: begin
190: delete from XDP_ACTION_CODES_TL T
191: where not exists
192: (select NULL
193: from XDP_ACTION_CODES B
194: where B.ACTION_CODE_ID = T.ACTION_CODE_ID
195: );
196:
197: update XDP_ACTION_CODES_TL T set (

Line 197: update XDP_ACTION_CODES_TL T set (

193: from XDP_ACTION_CODES B
194: where B.ACTION_CODE_ID = T.ACTION_CODE_ID
195: );
196:
197: update XDP_ACTION_CODES_TL T set (
198: DISPLAY_NAME,
199: DESCRIPTION
200: ) = (select
201: B.DISPLAY_NAME,

Line 203: from XDP_ACTION_CODES_TL B

199: DESCRIPTION
200: ) = (select
201: B.DISPLAY_NAME,
202: B.DESCRIPTION
203: from XDP_ACTION_CODES_TL B
204: where B.ACTION_CODE_ID = T.ACTION_CODE_ID
205: and B.LANGUAGE = T.SOURCE_LANG)
206: where (
207: T.ACTION_CODE_ID,

Line 212: from XDP_ACTION_CODES_TL SUBB, XDP_ACTION_CODES_TL SUBT

208: T.LANGUAGE
209: ) in (select
210: SUBT.ACTION_CODE_ID,
211: SUBT.LANGUAGE
212: from XDP_ACTION_CODES_TL SUBB, XDP_ACTION_CODES_TL SUBT
213: where SUBB.ACTION_CODE_ID = SUBT.ACTION_CODE_ID
214: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
215: and (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME
216: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 221: insert into XDP_ACTION_CODES_TL (

217: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
218: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
219: ));
220:
221: insert into XDP_ACTION_CODES_TL (
222: ACTION_CODE_ID,
223: DISPLAY_NAME,
224: DESCRIPTION,
225: CREATED_BY,

Line 243: from XDP_ACTION_CODES_TL B, FND_LANGUAGES L

239: B.LAST_UPDATE_DATE,
240: B.LAST_UPDATE_LOGIN,
241: L.LANGUAGE_CODE,
242: B.SOURCE_LANG
243: from XDP_ACTION_CODES_TL B, FND_LANGUAGES L
244: where L.INSTALLED_FLAG in ('I', 'B')
245: and B.LANGUAGE = userenv('LANG')
246: and not exists
247: (select NULL

Line 248: from XDP_ACTION_CODES_TL T

244: where L.INSTALLED_FLAG in ('I', 'B')
245: and B.LANGUAGE = userenv('LANG')
246: and not exists
247: (select NULL
248: from XDP_ACTION_CODES_TL T
249: where T.ACTION_CODE_ID = B.ACTION_CODE_ID
250: and T.LANGUAGE = L.LANGUAGE_CODE);
251: end ADD_LANGUAGE;
252:

Line 272: XDP_ACTION_CODES_PKG.UPDATE_ROW (

268: if (X_OWNER = 'SEED') then
269: user_id := 1;
270: end if;
271:
272: XDP_ACTION_CODES_PKG.UPDATE_ROW (
273: X_ACTION_CODE_ID => X_ACTION_CODE_ID,
274: X_ACTION_CODE => X_ACTION_CODE,
275: X_DISPLAY_NAME => X_DISPLAY_NAME,
276: X_DESCRIPTION => X_DESCRIPTION,

Line 283: XDP_ACTION_CODES_PKG.INSERT_ROW (

279: X_LAST_UPDATE_LOGIN => 0);
280:
281: exception
282: when NO_DATA_FOUND then
283: XDP_ACTION_CODES_PKG.INSERT_ROW (
284: X_ROWID => row_id,
285: X_ACTION_CODE_ID => X_ACTION_CODE_ID,
286: X_ACTION_CODE => X_ACTION_CODE,
287: X_DISPLAY_NAME => X_DISPLAY_NAME,

Line 307: update XDP_ACTION_CODES_TL

303: begin
304:
305: -- only update rows that have not been altered by user
306:
307: update XDP_ACTION_CODES_TL
308: set display_name = X_DISPLAY_NAME,
309: description = X_DESCRIPTION,
310: source_lang = userenv('LANG'),
311: last_update_date = sysdate,

Line 320: end XDP_ACTION_CODES_PKG;

316:
317: end TRANSLATE_ROW;
318:
319:
320: end XDP_ACTION_CODES_PKG;