APPS.WMS_ZONES_PKG dependencies on WMS_ZONES_B

Line 35: cursor C is select ROWID from WMS_ZONES_B

31: X_LAST_UPDATE_DATE in DATE,
32: X_LAST_UPDATED_BY in NUMBER,
33: X_LAST_UPDATE_LOGIN in NUMBER
34: ) is
35: cursor C is select ROWID from WMS_ZONES_B
36: where ZONE_ID = X_ZONE_ID
37: ;
38: begin
39: insert into WMS_ZONES_B (

Line 39: insert into WMS_ZONES_B (

35: cursor C is select ROWID from WMS_ZONES_B
36: where ZONE_ID = X_ZONE_ID
37: ;
38: begin
39: insert into WMS_ZONES_B (
40: ZONE_TYPE,
41: LABOR_ENABLED,
42: ATTRIBUTE6,
43: ATTRIBUTE7,

Line 185: from WMS_ZONES_B

181: ATTRIBUTE2,
182: ATTRIBUTE3,
183: ATTRIBUTE4,
184: ATTRIBUTE5
185: from WMS_ZONES_B
186: where ZONE_ID = X_ZONE_ID
187: for update of ZONE_ID nowait;
188: recinfo c%rowtype;
189:

Line 301: update WMS_ZONES_B set

297: X_LAST_UPDATED_BY in NUMBER,
298: X_LAST_UPDATE_LOGIN in NUMBER
299: ) is
300: begin
301: update WMS_ZONES_B set
302: ZONE_TYPE = X_ZONE_TYPE,
303: LABOR_ENABLED = X_LABOR_ENABLED,
304: ATTRIBUTE6 = X_ATTRIBUTE6,
305: ATTRIBUTE7 = X_ATTRIBUTE7,

Line 358: delete from WMS_ZONES_B

354: if (sql%notfound) then
355: raise no_data_found;
356: end if;
357:
358: delete from WMS_ZONES_B
359: where ZONE_ID = X_ZONE_ID;
360:
361: if (sql%notfound) then
362: raise no_data_found;

Line 372: from WMS_ZONES_B B

368: begin
369: delete from WMS_ZONES_TL T
370: where not exists
371: (select NULL
372: from WMS_ZONES_B B
373: where B.ZONE_ID = T.ZONE_ID
374: );
375:
376: update WMS_ZONES_TL T set (