APPS.WMS_WP_WAVE_EXCEPTIONS_PKG dependencies on WMS_WP_WAVE_EXCEPTIONS_B

Line 34: cursor C is select ROWID from WMS_WP_WAVE_EXCEPTIONS_B

30: X_LAST_UPDATE_DATE in DATE,
31: X_LAST_UPDATED_BY in NUMBER,
32: X_LAST_UPDATE_LOGIN in NUMBER
33: ) is
34: cursor C is select ROWID from WMS_WP_WAVE_EXCEPTIONS_B
35: where EXCEPTION_ID = X_EXCEPTION_ID
36: ;
37:
38: -- create a cursor variable here SUDHEER

Line 41: insert into WMS_WP_WAVE_EXCEPTIONS_B (

37:
38: -- create a cursor variable here SUDHEER
39: c_var c%rowtype;
40: begin
41: insert into WMS_WP_WAVE_EXCEPTIONS_B (
42: EXCEPTION_ID,
43: EXCEPTION_ENTITY,
44: EXCEPTION_STAGE,
45: EXCEPTION_LEVEL,

Line 189: from WMS_WP_WAVE_EXCEPTIONS_B

185: LOADED_TO_DOCK,
186: SHIPPED,
187: CONCURRENT_REQUEST_ID,
188: PROGRAM_ID -- sudheer
189: from WMS_WP_WAVE_EXCEPTIONS_B
190: where EXCEPTION_ID = X_EXCEPTION_ID
191: for update of EXCEPTION_ID nowait;
192: recinfo c%rowtype;
193:

Line 306: update WMS_WP_WAVE_EXCEPTIONS_B set

302: X_LAST_UPDATED_BY in NUMBER,
303: X_LAST_UPDATE_LOGIN in NUMBER
304: ) is
305: begin
306: update WMS_WP_WAVE_EXCEPTIONS_B set
307: EXCEPTION_ENTITY = X_EXCEPTION_ENTITY,
308: EXCEPTION_STAGE = X_EXCEPTION_STAGE,
309: EXCEPTION_LEVEL = X_EXCEPTION_LEVEL,
310: EXCEPTION_MSG = X_EXCEPTION_MSG,

Line 363: delete from WMS_WP_WAVE_EXCEPTIONS_B

359: if (sql%notfound) then
360: raise no_data_found;
361: end if;
362:
363: delete from WMS_WP_WAVE_EXCEPTIONS_B
364: where EXCEPTION_ID = X_EXCEPTION_ID;
365:
366: if (sql%notfound) then
367: raise no_data_found;

Line 377: from WMS_WP_WAVE_EXCEPTIONS_B B

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
379: );
380:
381: update WMS_WP_WAVE_EXCEPTIONS_TL T set (