26: X_LAST_UPDATE_DATE in DATE,
27: X_LAST_UPDATED_BY in NUMBER,
28: X_LAST_UPDATE_LOGIN in NUMBER
29: ) is
30: cursor C is select ROWID from WMS_CROSSDOCK_CRITERIA_B
31: where CRITERION_ID = X_CRITERION_ID
32: ;
33: begin
34: insert into WMS_CROSSDOCK_CRITERIA_B (
30: cursor C is select ROWID from WMS_CROSSDOCK_CRITERIA_B
31: where CRITERION_ID = X_CRITERION_ID
32: ;
33: begin
34: insert into WMS_CROSSDOCK_CRITERIA_B (
35: CRITERION_ID,
36: CRITERION_TYPE,
37: WINDOW_INTERVAL,
38: WINDOW_UOM,
156: ALLOW_DEMAND_RESCHEDULE_FLAG,
157: ALLOW_SUPPLY_RESCHEDULE_FLAG,
158: DEMAND_SCHEDULE_METHOD,
159: SUPPLY_SCHEDULE_METHOD
160: from WMS_CROSSDOCK_CRITERIA_B
161: where CRITERION_ID = X_CRITERION_ID
162: for update of CRITERION_ID nowait;
163: recinfo c%rowtype;
164:
248: X_LAST_UPDATED_BY in NUMBER,
249: X_LAST_UPDATE_LOGIN in NUMBER
250: ) is
251: begin
252: update WMS_CROSSDOCK_CRITERIA_B set
253: CRITERION_TYPE = X_CRITERION_TYPE,
254: WINDOW_INTERVAL = X_WINDOW_INTERVAL,
255: WINDOW_UOM = X_WINDOW_UOM,
256: BUFFER_INTERVAL = X_BUFFER_INTERVAL,
300: if (sql%notfound) then
301: raise no_data_found;
302: end if;
303:
304: delete from WMS_CROSSDOCK_CRITERIA_B
305: where CRITERION_ID = X_CRITERION_ID;
306:
307: if (sql%notfound) then
308: raise no_data_found;
314: begin
315: delete from WMS_CROSSDOCK_CRITERIA_TL T
316: where not exists
317: (select NULL
318: from WMS_CROSSDOCK_CRITERIA_B B
319: where B.CRITERION_ID = T.CRITERION_ID
320: );
321:
322: update WMS_CROSSDOCK_CRITERIA_TL T set (