APPS.XDP_SERVICE_VAL_ACTS_PKG dependencies on XDP_SERVICE_VAL_ACTS_TL

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