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_SERVICE_VAL_ACTS_PKG dependencies on XDP_SERVICE_VAL_ACTS

Line 1: package body XDP_SERVICE_VAL_ACTS_PKG as

1: package body XDP_SERVICE_VAL_ACTS_PKG as
2: /* $Header: XDPSVACB.pls 120.1 2005/06/16 02:39:41 appldev $ */
3: procedure INSERT_ROW (
4: X_ROWID in OUT NOCOPY VARCHAR2,
5: X_SERVICE_VAL_ACT_ID in NUMBER,

Line 21: cursor C is select ROWID from XDP_SERVICE_VAL_ACTS

17: X_LAST_UPDATE_DATE in DATE,
18: X_LAST_UPDATED_BY in NUMBER,
19: X_LAST_UPDATE_LOGIN in NUMBER
20: ) is
21: cursor C is select ROWID from XDP_SERVICE_VAL_ACTS
22: where SERVICE_VAL_ACT_ID = X_SERVICE_VAL_ACT_ID
23: ;
24: begin
25: insert into XDP_SERVICE_VAL_ACTS (

Line 25: insert into XDP_SERVICE_VAL_ACTS (

21: cursor C is select ROWID from XDP_SERVICE_VAL_ACTS
22: where SERVICE_VAL_ACT_ID = X_SERVICE_VAL_ACT_ID
23: ;
24: begin
25: insert into XDP_SERVICE_VAL_ACTS (
26: SERVICE_VAL_ACT_ID,
27: VALID_DATE,
28: INVALID_DATE,
29: WI_MAPPING_PROC,

Line 57: insert into XDP_SERVICE_VAL_ACTS_TL (

53: X_LAST_UPDATED_BY,
54: X_LAST_UPDATE_LOGIN
55: );
56:
57: insert into XDP_SERVICE_VAL_ACTS_TL (
58: SERVICE_VAL_ACT_ID,
59: DESCRIPTION,
60: CREATED_BY,
61: CREATION_DATE,

Line 81: from XDP_SERVICE_VAL_ACTS_TL T

77: from FND_LANGUAGES L
78: where L.INSTALLED_FLAG in ('I', 'B')
79: and not exists
80: (select NULL
81: from XDP_SERVICE_VAL_ACTS_TL T
82: where T.SERVICE_VAL_ACT_ID = X_SERVICE_VAL_ACT_ID
83: and T.LANGUAGE = L.LANGUAGE_CODE);
84:
85: open c;

Line 120: from XDP_SERVICE_VAL_ACTS

116: VALID_DATE,
117: INVALID_DATE,
118: WI_MAPPING_PROC,
119: WI_MAPPING_TYPE
120: from XDP_SERVICE_VAL_ACTS
121: where SERVICE_VAL_ACT_ID = X_SERVICE_VAL_ACT_ID
122: for update of SERVICE_VAL_ACT_ID nowait;
123: recinfo c%rowtype;
124:

Line 128: from XDP_SERVICE_VAL_ACTS_TL

124:
125: cursor c1 is select
126: DESCRIPTION,
127: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
128: from XDP_SERVICE_VAL_ACTS_TL
129: where SERVICE_VAL_ACT_ID = X_SERVICE_VAL_ACT_ID
130: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
131: for update of SERVICE_VAL_ACT_ID nowait;
132: begin

Line 192: update XDP_SERVICE_VAL_ACTS set

188: X_LAST_UPDATED_BY in NUMBER,
189: X_LAST_UPDATE_LOGIN in NUMBER
190: ) is
191: begin
192: update XDP_SERVICE_VAL_ACTS set
193: ACTION_SOURCE = X_ACTION_SOURCE ,
194: ACTION_CODE = X_ACTION_CODE ,
195: ORGANIZATION_ID = X_ORGANIZATION_ID ,
196: INVENTORY_ITEM_ID = X_INVENTORY_ITEM_ID ,

Line 210: update XDP_SERVICE_VAL_ACTS_TL set

206: if (sql%notfound) then
207: raise no_data_found;
208: end if;
209:
210: update XDP_SERVICE_VAL_ACTS_TL set
211: DESCRIPTION = X_DESCRIPTION,
212: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
213: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
214: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 228: delete from XDP_SERVICE_VAL_ACTS_TL

224: procedure DELETE_ROW (
225: X_SERVICE_VAL_ACT_ID in NUMBER
226: ) is
227: begin
228: delete from XDP_SERVICE_VAL_ACTS_TL
229: where SERVICE_VAL_ACT_ID = X_SERVICE_VAL_ACT_ID;
230:
231: if (sql%notfound) then
232: raise no_data_found;

Line 235: delete from XDP_SERVICE_VAL_ACTS

231: if (sql%notfound) then
232: raise no_data_found;
233: end if;
234:
235: delete from XDP_SERVICE_VAL_ACTS
236: where SERVICE_VAL_ACT_ID = X_SERVICE_VAL_ACT_ID;
237:
238: if (sql%notfound) then
239: raise no_data_found;

Line 246: delete from XDP_SERVICE_VAL_ACTS_TL T

242:
243: procedure ADD_LANGUAGE
244: is
245: begin
246: delete from XDP_SERVICE_VAL_ACTS_TL T
247: where not exists
248: (select NULL
249: from XDP_SERVICE_VAL_ACTS B
250: where B.SERVICE_VAL_ACT_ID = T.SERVICE_VAL_ACT_ID

Line 249: from XDP_SERVICE_VAL_ACTS B

245: begin
246: delete from XDP_SERVICE_VAL_ACTS_TL T
247: where not exists
248: (select NULL
249: from XDP_SERVICE_VAL_ACTS B
250: where B.SERVICE_VAL_ACT_ID = T.SERVICE_VAL_ACT_ID
251: );
252:
253: update XDP_SERVICE_VAL_ACTS_TL T set (

Line 253: update XDP_SERVICE_VAL_ACTS_TL T set (

249: from XDP_SERVICE_VAL_ACTS B
250: where B.SERVICE_VAL_ACT_ID = T.SERVICE_VAL_ACT_ID
251: );
252:
253: update XDP_SERVICE_VAL_ACTS_TL T set (
254: DESCRIPTION
255: ) = (select
256: B.DESCRIPTION
257: from XDP_SERVICE_VAL_ACTS_TL B

Line 257: from XDP_SERVICE_VAL_ACTS_TL B

253: update XDP_SERVICE_VAL_ACTS_TL T set (
254: DESCRIPTION
255: ) = (select
256: B.DESCRIPTION
257: from XDP_SERVICE_VAL_ACTS_TL B
258: where B.SERVICE_VAL_ACT_ID = T.SERVICE_VAL_ACT_ID
259: and B.LANGUAGE = T.SOURCE_LANG)
260: where (
261: T.SERVICE_VAL_ACT_ID,

Line 266: from XDP_SERVICE_VAL_ACTS_TL SUBB, XDP_SERVICE_VAL_ACTS_TL SUBT

262: T.LANGUAGE
263: ) in (select
264: SUBT.SERVICE_VAL_ACT_ID,
265: SUBT.LANGUAGE
266: from XDP_SERVICE_VAL_ACTS_TL SUBB, XDP_SERVICE_VAL_ACTS_TL SUBT
267: where SUBB.SERVICE_VAL_ACT_ID = SUBT.SERVICE_VAL_ACT_ID
268: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
269: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
270: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)

Line 274: insert into XDP_SERVICE_VAL_ACTS_TL (

270: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
271: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
272: ));
273:
274: insert into XDP_SERVICE_VAL_ACTS_TL (
275: SERVICE_VAL_ACT_ID,
276: DESCRIPTION,
277: CREATED_BY,
278: CREATION_DATE,

Line 294: from XDP_SERVICE_VAL_ACTS_TL B, FND_LANGUAGES L

290: B.LAST_UPDATE_DATE,
291: B.LAST_UPDATE_LOGIN,
292: L.LANGUAGE_CODE,
293: B.SOURCE_LANG
294: from XDP_SERVICE_VAL_ACTS_TL B, FND_LANGUAGES L
295: where L.INSTALLED_FLAG in ('I', 'B')
296: and B.LANGUAGE = userenv('LANG')
297: and not exists
298: (select NULL

Line 299: from XDP_SERVICE_VAL_ACTS_TL T

295: where L.INSTALLED_FLAG in ('I', 'B')
296: and B.LANGUAGE = userenv('LANG')
297: and not exists
298: (select NULL
299: from XDP_SERVICE_VAL_ACTS_TL T
300: where T.SERVICE_VAL_ACT_ID = B.SERVICE_VAL_ACT_ID
301: and T.LANGUAGE = L.LANGUAGE_CODE);
302: end ADD_LANGUAGE;
303:

Line 328: XDP_SERVICE_VAL_ACTS_PKG.UPDATE_ROW (

324: if (X_OWNER = 'SEED') then
325: user_id := 1;
326: end if;
327:
328: XDP_SERVICE_VAL_ACTS_PKG.UPDATE_ROW (
329: X_SERVICE_VAL_ACT_ID => X_SERVICE_VAL_ACT_ID,
330: X_ACTION_SOURCE => X_ACTION_SOURCE,
331: X_ACTION_CODE => X_ACTION_CODE,
332: X_ORGANIZATION_ID => X_ORGANIZATION_ID,

Line 345: XDP_SERVICE_VAL_ACTS_PKG.INSERT_ROW (

341: X_LAST_UPDATE_LOGIN => 0);
342:
343: exception
344: when NO_DATA_FOUND then
345: XDP_SERVICE_VAL_ACTS_PKG.INSERT_ROW (
346: X_ROWID => row_id,
347: X_SERVICE_VAL_ACT_ID => X_SERVICE_VAL_ACT_ID,
348: X_ACTION_SOURCE => X_ACTION_SOURCE,
349: X_ACTION_CODE => X_ACTION_CODE,

Line 374: update XDP_SERVICE_VAL_ACTS_TL

370: begin
371:
372: -- only update rows that have not been altered by user
373:
374: update XDP_SERVICE_VAL_ACTS_TL
375: set description = X_DESCRIPTION,
376: source_lang = userenv('LANG'),
377: last_update_date = sysdate,
378: last_updated_by = decode(X_OWNER, 'SEED', 1, 0),

Line 386: end XDP_SERVICE_VAL_ACTS_PKG;

382:
383: end TRANSLATE_ROW;
384:
385:
386: end XDP_SERVICE_VAL_ACTS_PKG;