APPS.XDP_SERVICE_WI_MAP_PKG dependencies on XDP_SERVICE_WI_MAP_TL

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 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 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 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 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 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),