APPS.WMS_WP_WAVE_EXCEPTIONS_PKG dependencies on WMS_WP_WAVE_EXCEPTIONS_TL

Line 101: insert into WMS_WP_WAVE_EXCEPTIONS_TL (

97: X_LAST_UPDATED_BY,
98: X_LAST_UPDATE_LOGIN
99: );
100:
101: insert into WMS_WP_WAVE_EXCEPTIONS_TL (
102: EXCEPTION_ID,
103: EXCEPTION_NAME,
104: CREATED_BY,
105: CREATION_DATE,

Line 125: from WMS_WP_WAVE_EXCEPTIONS_TL T

121: from FND_LANGUAGES L
122: where L.INSTALLED_FLAG in ('I', 'B')
123: and not exists
124: (select NULL
125: from WMS_WP_WAVE_EXCEPTIONS_TL T
126: where T.EXCEPTION_ID = X_EXCEPTION_ID
127: and T.LANGUAGE = L.LANGUAGE_CODE);
128:
129: open c;

Line 197: from WMS_WP_WAVE_EXCEPTIONS_TL

193:
194: cursor c1 is select
195: EXCEPTION_NAME,
196: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
197: from WMS_WP_WAVE_EXCEPTIONS_TL
198: where EXCEPTION_ID = X_EXCEPTION_ID
199: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
200: for update of EXCEPTION_ID nowait;
201: begin

Line 338: update WMS_WP_WAVE_EXCEPTIONS_TL set

334: if (sql%notfound) then
335: raise no_data_found;
336: end if;
337:
338: update WMS_WP_WAVE_EXCEPTIONS_TL set
339: EXCEPTION_NAME = X_EXCEPTION_NAME,
340: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
341: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
342: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 356: delete from WMS_WP_WAVE_EXCEPTIONS_TL

352: procedure DELETE_ROW (
353: X_EXCEPTION_ID in NUMBER
354: ) is
355: begin
356: delete from WMS_WP_WAVE_EXCEPTIONS_TL
357: where EXCEPTION_ID = X_EXCEPTION_ID;
358:
359: if (sql%notfound) then
360: raise no_data_found;

Line 374: delete from WMS_WP_WAVE_EXCEPTIONS_TL T

370:
371: procedure ADD_LANGUAGE
372: is
373: begin
374: delete from WMS_WP_WAVE_EXCEPTIONS_TL T
375: where not exists
376: (select NULL
377: from WMS_WP_WAVE_EXCEPTIONS_B B
378: where B.EXCEPTION_ID = T.EXCEPTION_ID

Line 381: update WMS_WP_WAVE_EXCEPTIONS_TL T set (

377: from WMS_WP_WAVE_EXCEPTIONS_B B
378: where B.EXCEPTION_ID = T.EXCEPTION_ID
379: );
380:
381: update WMS_WP_WAVE_EXCEPTIONS_TL T set (
382: EXCEPTION_NAME
383: ) = (select
384: B.EXCEPTION_NAME
385: from WMS_WP_WAVE_EXCEPTIONS_TL B

Line 385: from WMS_WP_WAVE_EXCEPTIONS_TL B

381: update WMS_WP_WAVE_EXCEPTIONS_TL T set (
382: EXCEPTION_NAME
383: ) = (select
384: B.EXCEPTION_NAME
385: from WMS_WP_WAVE_EXCEPTIONS_TL B
386: where B.EXCEPTION_ID = T.EXCEPTION_ID
387: and B.LANGUAGE = T.SOURCE_LANG)
388: where (
389: T.EXCEPTION_ID,

Line 394: from WMS_WP_WAVE_EXCEPTIONS_TL SUBB, WMS_WP_WAVE_EXCEPTIONS_TL SUBT

390: T.LANGUAGE
391: ) in (select
392: SUBT.EXCEPTION_ID,
393: SUBT.LANGUAGE
394: from WMS_WP_WAVE_EXCEPTIONS_TL SUBB, WMS_WP_WAVE_EXCEPTIONS_TL SUBT
395: where SUBB.EXCEPTION_ID = SUBT.EXCEPTION_ID
396: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
397: and (SUBB.EXCEPTION_NAME <> SUBT.EXCEPTION_NAME
398: or (SUBB.EXCEPTION_NAME is null and SUBT.EXCEPTION_NAME is not null)

Line 402: insert into WMS_WP_WAVE_EXCEPTIONS_TL (

398: or (SUBB.EXCEPTION_NAME is null and SUBT.EXCEPTION_NAME is not null)
399: or (SUBB.EXCEPTION_NAME is not null and SUBT.EXCEPTION_NAME is null)
400: ));
401:
402: insert into WMS_WP_WAVE_EXCEPTIONS_TL (
403: EXCEPTION_ID,
404: EXCEPTION_NAME,
405: CREATED_BY,
406: CREATION_DATE,

Line 422: from WMS_WP_WAVE_EXCEPTIONS_TL B, FND_LANGUAGES L

418: B.LAST_UPDATE_DATE,
419: B.LAST_UPDATE_LOGIN,
420: L.LANGUAGE_CODE,
421: B.SOURCE_LANG
422: from WMS_WP_WAVE_EXCEPTIONS_TL B, FND_LANGUAGES L
423: where L.INSTALLED_FLAG in ('I', 'B')
424: and B.LANGUAGE = userenv('LANG')
425: and not exists
426: (select NULL

Line 427: from WMS_WP_WAVE_EXCEPTIONS_TL T

423: where L.INSTALLED_FLAG in ('I', 'B')
424: and B.LANGUAGE = userenv('LANG')
425: and not exists
426: (select NULL
427: from WMS_WP_WAVE_EXCEPTIONS_TL T
428: where T.EXCEPTION_ID = B.EXCEPTION_ID
429: and T.LANGUAGE = L.LANGUAGE_CODE);
430: end ADD_LANGUAGE;
431: