APPS.WMS_WP_PLANNING_CRITERIA_PKG dependencies on WMS_WP_PLANNING_CRITERIA_B

Line 34: cursor C is select ROWID from WMS_WP_PLANNING_CRITERIA_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_PLANNING_CRITERIA_B
35: where PLANNING_CRITERIA_ID = X_PLANNING_CRITERIA_ID
36: ;
37:
38: l_curvar C%rowtype;

Line 41: insert into WMS_WP_PLANNING_CRITERIA_B (

37:
38: l_curvar C%rowtype;
39:
40: begin
41: insert into WMS_WP_PLANNING_CRITERIA_B (
42: LABOR_SETUP_MODE,
43: PLANNING_CRITERIA_ID,
44: PLANNING_METHOD,
45: TYPE,

Line 184: from WMS_WP_PLANNING_CRITERIA_B

180: ENABLE_LABOR_PLANNING,
181: CROSSDOCK_CRITERIA,
182: CROSSDOCK_CRITERIA_ID,
183: ALLOCATION_METHOD
184: from WMS_WP_PLANNING_CRITERIA_B
185: where PLANNING_CRITERIA_ID = X_PLANNING_CRITERIA_ID
186: for update of PLANNING_CRITERIA_ID nowait;
187: recinfo c%rowtype;
188:

Line 298: update WMS_WP_PLANNING_CRITERIA_B set

294: X_LAST_UPDATED_BY in NUMBER,
295: X_LAST_UPDATE_LOGIN in NUMBER
296: ) is
297: begin
298: update WMS_WP_PLANNING_CRITERIA_B set
299: LABOR_SETUP_MODE = X_LABOR_SETUP_MODE,
300: PLANNING_METHOD = X_PLANNING_METHOD,
301: TYPE = X_TYPE,
302: BACKORDER_FLAG = X_BACKORDER_FLAG,

Line 354: delete from WMS_WP_PLANNING_CRITERIA_B

350: if (sql%notfound) then
351: raise no_data_found;
352: end if;
353:
354: delete from WMS_WP_PLANNING_CRITERIA_B
355: where PLANNING_CRITERIA_ID = X_PLANNING_CRITERIA_ID;
356:
357: if (sql%notfound) then
358: raise no_data_found;

Line 368: from WMS_WP_PLANNING_CRITERIA_B B

364: begin
365: delete from WMS_WP_PLANNING_CRITERIA_TL T
366: where not exists
367: (select NULL
368: from WMS_WP_PLANNING_CRITERIA_B B
369: where B.PLANNING_CRITERIA_ID = T.PLANNING_CRITERIA_ID
370: );
371:
372: update WMS_WP_PLANNING_CRITERIA_TL T set (