APPS.WMS_STRATEGIES_PKG dependencies on WMS_STRATEGIES_B

Line 37: cursor C is select ROWID from WMS_STRATEGIES_B

33: X_wms_enabled_flag in VARCHAR2 DEFAULT NULL,
34: X_OVER_ALLOCATION_MODE in NUMBER DEFAULT NULL,
35: X_TOLERANCE_VALUE in NUMBER DEFAULT NULL
36: ) is
37: cursor C is select ROWID from WMS_STRATEGIES_B
38: where STRATEGY_ID = X_STRATEGY_ID
39: ;
40: begin
41: insert into WMS_STRATEGIES_B (

Line 41: insert into WMS_STRATEGIES_B (

37: cursor C is select ROWID from WMS_STRATEGIES_B
38: where STRATEGY_ID = X_STRATEGY_ID
39: ;
40: begin
41: insert into WMS_STRATEGIES_B (
42: ATTRIBUTE_CATEGORY,
43: ATTRIBUTE1,
44: ATTRIBUTE2,
45: ATTRIBUTE3,

Line 193: from WMS_STRATEGIES_B

189: ENABLED_FLAG,
190: USER_DEFINED_FLAG,
191: OVER_ALLOCATION_MODE,
192: TOLERANCE_VALUE
193: from WMS_STRATEGIES_B
194: where STRATEGY_ID = X_STRATEGY_ID
195: for update of STRATEGY_ID nowait;
196: recinfo c%rowtype;
197:

Line 309: update WMS_STRATEGIES_B set

305: X_OVER_ALLOCATION_MODE in NUMBER DEFAULT NULL,
306: X_TOLERANCE_VALUE in NUMBER DEFAULT NULL
307: ) is
308: begin
309: update WMS_STRATEGIES_B set
310: ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
311: ATTRIBUTE1 = X_ATTRIBUTE1,
312: ATTRIBUTE2 = X_ATTRIBUTE2,
313: ATTRIBUTE3 = X_ATTRIBUTE3,

Line 367: delete from WMS_STRATEGIES_B

363: if (sql%notfound) then
364: raise no_data_found;
365: end if;
366:
367: delete from WMS_STRATEGIES_B
368: where STRATEGY_ID = X_STRATEGY_ID;
369:
370: if (sql%notfound) then
371: raise no_data_found;

Line 381: from WMS_STRATEGIES_B B

377: begin
378: delete from WMS_STRATEGIES_TL T
379: where not exists
380: (select NULL
381: from WMS_STRATEGIES_B B
382: where B.STRATEGY_ID = T.STRATEGY_ID
383: );
384:
385: update WMS_STRATEGIES_TL T set (