APPS.WMS_RULES_PKG dependencies on WMS_RULES_B

Line 40: cursor C is select ROWID from WMS_RULES_B

36: X_ATTRIBUTE_CATEGORY in VARCHAR2
37: ,X_ALLOCATION_MODE_ID in NUMBER
38: ,X_wms_enabled_flag in VARCHAR2 DEFAULT NULL
39: ) is
40: cursor C is select ROWID from WMS_RULES_B
41: where RULE_ID = X_RULE_ID ;
42: begin
43:
44: insert into WMS_RULES_B (

Line 44: insert into WMS_RULES_B (

40: cursor C is select ROWID from WMS_RULES_B
41: where RULE_ID = X_RULE_ID ;
42: begin
43:
44: insert into WMS_RULES_B (
45: ATTRIBUTE11,
46: ATTRIBUTE12,
47: RULE_ID,
48: ORGANIZATION_ID,

Line 208: from WMS_RULES_B

204: ATTRIBUTE13,
205: ATTRIBUTE14,
206: ATTRIBUTE15
207: ,ALLOCATION_MODE_ID
208: from WMS_RULES_B
209: where RULE_ID = X_RULE_ID
210: for update of RULE_ID nowait;
211: recinfo c%rowtype;
212:

Line 333: update WMS_RULES_B set

329: X_ATTRIBUTE_CATEGORY in VARCHAR2
330: ,X_ALLOCATION_MODE_ID in NUMBER
331: ) is
332: begin
333: update WMS_RULES_B set
334: ORGANIZATION_ID = X_ORGANIZATION_ID,
335: TYPE_CODE = X_TYPE_CODE,
336: QTY_FUNCTION_PARAMETER_ID = X_QTY_FUNCTION_PARAMETER_ID,
337: ENABLED_FLAG = X_ENABLED_FLAG,

Line 403: delete from WMS_RULES_B

399: if (sql%notfound) then
400: raise no_data_found;
401: end if;
402:
403: delete from WMS_RULES_B
404: where RULE_ID = X_RULE_ID;
405:
406: if (sql%notfound) then
407: raise no_data_found;

Line 426: from WMS_RULES_B B

422: begin
423: delete from WMS_RULES_TL T
424: where not exists
425: (select NULL
426: from WMS_RULES_B B
427: where B.RULE_ID = T.RULE_ID
428: );
429:
430: update WMS_RULES_TL T set (