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 394: delete from WMS_RULES_B

390: if (sql%notfound) then
391: raise no_data_found;
392: end if;
393:
394: delete from WMS_RULES_B
395: where RULE_ID = X_RULE_ID;
396:
397: if (sql%notfound) then
398: raise no_data_found;

Line 408: from WMS_RULES_B B

404: begin
405: delete from WMS_RULES_TL T
406: where not exists
407: (select NULL
408: from WMS_RULES_B B
409: where B.RULE_ID = T.RULE_ID
410: );
411:
412: update WMS_RULES_TL T set (