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_WI_MAP_PKG dependencies on XDP_SERVICE_WI_MAP

Line 1: package body XDP_SERVICE_WI_MAP_PKG as

1: package body XDP_SERVICE_WI_MAP_PKG as
2: /* $Header: XDPSWMPB.pls 120.1 2005/06/16 02:42:25 appldev $ */
3: procedure INSERT_ROW (
4: X_ROWID in OUT NOCOPY VARCHAR2,
5: X_SERVICE_WI_MAP_ID in NUMBER,

Line 17: cursor C is select ROWID from XDP_SERVICE_WI_MAP

13: X_LAST_UPDATE_DATE in DATE,
14: X_LAST_UPDATED_BY in NUMBER,
15: X_LAST_UPDATE_LOGIN in NUMBER
16: ) is
17: cursor C is select ROWID from XDP_SERVICE_WI_MAP
18: where SERVICE_WI_MAP_ID = X_SERVICE_WI_MAP_ID
19: ;
20: begin
21: insert into XDP_SERVICE_WI_MAP (

Line 21: insert into XDP_SERVICE_WI_MAP (

17: cursor C is select ROWID from XDP_SERVICE_WI_MAP
18: where SERVICE_WI_MAP_ID = X_SERVICE_WI_MAP_ID
19: ;
20: begin
21: insert into XDP_SERVICE_WI_MAP (
22: SERVICE_WI_MAP_ID,
23: SERVICE_VAL_ACT_ID,
24: WORKITEM_ID,
25: PROVISION_SEQ,

Line 45: insert into XDP_SERVICE_WI_MAP_TL (

41: X_LAST_UPDATED_BY,
42: X_LAST_UPDATE_LOGIN
43: );
44:
45: insert into XDP_SERVICE_WI_MAP_TL (
46: SERVICE_WI_MAP_ID,
47: DESCRIPTION,
48: CREATED_BY,
49: CREATION_DATE,

Line 69: from XDP_SERVICE_WI_MAP_TL T

65: from FND_LANGUAGES L
66: where L.INSTALLED_FLAG in ('I', 'B')
67: and not exists
68: (select NULL
69: from XDP_SERVICE_WI_MAP_TL T
70: where T.SERVICE_WI_MAP_ID = X_SERVICE_WI_MAP_ID
71: and T.LANGUAGE = L.LANGUAGE_CODE);
72:
73: open c;

Line 96: from XDP_SERVICE_WI_MAP

92: SERVICE_VAL_ACT_ID,
93: WORKITEM_ID,
94: PROVISION_SEQ,
95: MAPPING_TYPE
96: from XDP_SERVICE_WI_MAP
97: where SERVICE_WI_MAP_ID = X_SERVICE_WI_MAP_ID
98: for update of SERVICE_WI_MAP_ID nowait;
99: recinfo c%rowtype;
100:

Line 104: from XDP_SERVICE_WI_MAP_TL

100:
101: cursor c1 is select
102: DESCRIPTION,
103: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
104: from XDP_SERVICE_WI_MAP_TL
105: where SERVICE_WI_MAP_ID = X_SERVICE_WI_MAP_ID
106: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
107: for update of SERVICE_WI_MAP_ID nowait;
108: begin

Line 155: update XDP_SERVICE_WI_MAP set

151: X_LAST_UPDATED_BY in NUMBER,
152: X_LAST_UPDATE_LOGIN in NUMBER
153: ) is
154: begin
155: update XDP_SERVICE_WI_MAP set
156: SERVICE_VAL_ACT_ID = X_SERVICE_VAL_ACT_ID,
157: WORKITEM_ID = X_WORKITEM_ID,
158: PROVISION_SEQ = X_PROVISION_SEQ,
159: MAPPING_TYPE = X_MAPPING_TYPE,

Line 169: update XDP_SERVICE_WI_MAP_TL set

165: if (sql%notfound) then
166: raise no_data_found;
167: end if;
168:
169: update XDP_SERVICE_WI_MAP_TL set
170: DESCRIPTION = X_DESCRIPTION,
171: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
172: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
173: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 187: delete from XDP_SERVICE_WI_MAP_TL

183: procedure DELETE_ROW (
184: X_SERVICE_WI_MAP_ID in NUMBER
185: ) is
186: begin
187: delete from XDP_SERVICE_WI_MAP_TL
188: where SERVICE_WI_MAP_ID = X_SERVICE_WI_MAP_ID;
189:
190: if (sql%notfound) then
191: raise no_data_found;

Line 194: delete from XDP_SERVICE_WI_MAP

190: if (sql%notfound) then
191: raise no_data_found;
192: end if;
193:
194: delete from XDP_SERVICE_WI_MAP
195: where SERVICE_WI_MAP_ID = X_SERVICE_WI_MAP_ID;
196:
197: if (sql%notfound) then
198: raise no_data_found;

Line 205: delete from XDP_SERVICE_WI_MAP_TL T

201:
202: procedure ADD_LANGUAGE
203: is
204: begin
205: delete from XDP_SERVICE_WI_MAP_TL T
206: where not exists
207: (select NULL
208: from XDP_SERVICE_WI_MAP B
209: where B.SERVICE_WI_MAP_ID = T.SERVICE_WI_MAP_ID

Line 208: from XDP_SERVICE_WI_MAP B

204: begin
205: delete from XDP_SERVICE_WI_MAP_TL T
206: where not exists
207: (select NULL
208: from XDP_SERVICE_WI_MAP B
209: where B.SERVICE_WI_MAP_ID = T.SERVICE_WI_MAP_ID
210: );
211:
212: update XDP_SERVICE_WI_MAP_TL T set (

Line 212: update XDP_SERVICE_WI_MAP_TL T set (

208: from XDP_SERVICE_WI_MAP B
209: where B.SERVICE_WI_MAP_ID = T.SERVICE_WI_MAP_ID
210: );
211:
212: update XDP_SERVICE_WI_MAP_TL T set (
213: DESCRIPTION
214: ) = (select
215: B.DESCRIPTION
216: from XDP_SERVICE_WI_MAP_TL B

Line 216: from XDP_SERVICE_WI_MAP_TL B

212: update XDP_SERVICE_WI_MAP_TL T set (
213: DESCRIPTION
214: ) = (select
215: B.DESCRIPTION
216: from XDP_SERVICE_WI_MAP_TL B
217: where B.SERVICE_WI_MAP_ID = T.SERVICE_WI_MAP_ID
218: and B.LANGUAGE = T.SOURCE_LANG)
219: where (
220: T.SERVICE_WI_MAP_ID,

Line 225: from XDP_SERVICE_WI_MAP_TL SUBB, XDP_SERVICE_WI_MAP_TL SUBT

221: T.LANGUAGE
222: ) in (select
223: SUBT.SERVICE_WI_MAP_ID,
224: SUBT.LANGUAGE
225: from XDP_SERVICE_WI_MAP_TL SUBB, XDP_SERVICE_WI_MAP_TL SUBT
226: where SUBB.SERVICE_WI_MAP_ID = SUBT.SERVICE_WI_MAP_ID
227: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
228: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
229: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)

Line 233: insert into XDP_SERVICE_WI_MAP_TL (

229: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
230: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
231: ));
232:
233: insert into XDP_SERVICE_WI_MAP_TL (
234: SERVICE_WI_MAP_ID,
235: DESCRIPTION,
236: CREATED_BY,
237: CREATION_DATE,

Line 253: from XDP_SERVICE_WI_MAP_TL B, FND_LANGUAGES L

249: B.LAST_UPDATE_DATE,
250: B.LAST_UPDATE_LOGIN,
251: L.LANGUAGE_CODE,
252: B.SOURCE_LANG
253: from XDP_SERVICE_WI_MAP_TL B, FND_LANGUAGES L
254: where L.INSTALLED_FLAG in ('I', 'B')
255: and B.LANGUAGE = userenv('LANG')
256: and not exists
257: (select NULL

Line 258: from XDP_SERVICE_WI_MAP_TL T

254: where L.INSTALLED_FLAG in ('I', 'B')
255: and B.LANGUAGE = userenv('LANG')
256: and not exists
257: (select NULL
258: from XDP_SERVICE_WI_MAP_TL T
259: where T.SERVICE_WI_MAP_ID = B.SERVICE_WI_MAP_ID
260: and T.LANGUAGE = L.LANGUAGE_CODE);
261: end ADD_LANGUAGE;
262:

Line 283: XDP_SERVICE_WI_MAP_PKG.UPDATE_ROW (

279: if (X_OWNER = 'SEED') then
280: user_id := 1;
281: end if;
282:
283: XDP_SERVICE_WI_MAP_PKG.UPDATE_ROW (
284: X_SERVICE_WI_MAP_ID => X_SERVICE_WI_MAP_ID,
285: X_SERVICE_VAL_ACT_ID => X_SERVICE_VAL_ACT_ID,
286: X_WORKITEM_ID => X_WORKITEM_ID,
287: X_PROVISION_SEQ => X_PROVISION_SEQ,

Line 296: XDP_SERVICE_WI_MAP_PKG.INSERT_ROW (

292: X_LAST_UPDATE_LOGIN => 0);
293:
294: exception
295: when NO_DATA_FOUND then
296: XDP_SERVICE_WI_MAP_PKG.INSERT_ROW (
297: X_ROWID => row_id,
298: X_SERVICE_WI_MAP_ID => X_SERVICE_WI_MAP_ID,
299: X_SERVICE_VAL_ACT_ID => X_SERVICE_VAL_ACT_ID,
300: X_WORKITEM_ID => X_WORKITEM_ID,

Line 321: update XDP_SERVICE_WI_MAP_TL

317: begin
318:
319: -- only update rows that have not been altered by user
320:
321: update XDP_SERVICE_WI_MAP_TL
322: set description = X_DESCRIPTION,
323: source_lang = userenv('LANG'),
324: last_update_date = sysdate,
325: last_updated_by = decode(X_OWNER, 'SEED', 1, 0),

Line 334: end XDP_SERVICE_WI_MAP_PKG;

330: end TRANSLATE_ROW;
331:
332:
333:
334: end XDP_SERVICE_WI_MAP_PKG;