APPS.WMS_ZONES_PKG dependencies on WMS_ZONES_B

Line 34: cursor C is select ROWID from WMS_ZONES_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_ZONES_B
35: where ZONE_ID = X_ZONE_ID
36: ;
37: begin
38: insert into WMS_ZONES_B (

Line 38: insert into WMS_ZONES_B (

34: cursor C is select ROWID from WMS_ZONES_B
35: where ZONE_ID = X_ZONE_ID
36: ;
37: begin
38: insert into WMS_ZONES_B (
39: ATTRIBUTE_CATEGORY,
40: ATTRIBUTE1,
41: ATTRIBUTE2,
42: ATTRIBUTE3,

Line 178: from WMS_ZONES_B

174: ATTRIBUTE15,
175: ORGANIZATION_ID,
176: DISABLE_DATE,
177: ENABLED_FLAG
178: from WMS_ZONES_B
179: where ZONE_ID = X_ZONE_ID
180: for update of ZONE_ID nowait;
181: recinfo c%rowtype;
182:

Line 289: update WMS_ZONES_B set

285: X_LAST_UPDATED_BY in NUMBER,
286: X_LAST_UPDATE_LOGIN in NUMBER
287: ) is
288: begin
289: update WMS_ZONES_B set
290: ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
291: ATTRIBUTE1 = X_ATTRIBUTE1,
292: ATTRIBUTE2 = X_ATTRIBUTE2,
293: ATTRIBUTE3 = X_ATTRIBUTE3,

Line 345: delete from WMS_ZONES_B

341: if (sql%notfound) then
342: raise no_data_found;
343: end if;
344:
345: delete from WMS_ZONES_B
346: where ZONE_ID = X_ZONE_ID;
347:
348: if (sql%notfound) then
349: raise no_data_found;

Line 359: from WMS_ZONES_B B

355: begin
356: delete from WMS_ZONES_TL T
357: where not exists
358: (select NULL
359: from WMS_ZONES_B B
360: where B.ZONE_ID = T.ZONE_ID
361: );
362:
363: update WMS_ZONES_TL T set (