DBA Data[Home] [Help]

APPS.INV_RULE_GEN_PVT dependencies on WMS_RULE_CONSISTENCIES

Line 18: Wms_rule_consistencies - if any

14: Mtl_picking_rules
15: Wms_rules_b
16: Wms_rules_tl
17: Wms_restrictions - if any
18: Wms_rule_consistencies - if any
19: Wms_sort_criteria - if any
20: */
21: --Procedures for logging messages
22: PROCEDURE debug(p_message VARCHAR2) IS

Line 762: select wms_rule_consistencies_s.nextval into l_consistency_Id from dual;

758: l_picking_rule_rec := p_mtl_picking_rule_rec;
759: If p_mtl_picking_rule_rec.single_lot = 'Y' then
760: -- find the parameter for lot.lot_number
761: l_parameter_id := 60006; -- lot.lot_Number
762: select wms_rule_consistencies_s.nextval into l_consistency_Id from dual;
763:
764: WMS_RULE_CONSISTENCIES_PKG.INSERT_ROW(
765: X_ROWID => l_ROW_ID,
766: X_CONSISTENCY_ID => l_CONSISTENCY_ID,

Line 764: WMS_RULE_CONSISTENCIES_PKG.INSERT_ROW(

760: -- find the parameter for lot.lot_number
761: l_parameter_id := 60006; -- lot.lot_Number
762: select wms_rule_consistencies_s.nextval into l_consistency_Id from dual;
763:
764: WMS_RULE_CONSISTENCIES_PKG.INSERT_ROW(
765: X_ROWID => l_ROW_ID,
766: X_CONSISTENCY_ID => l_CONSISTENCY_ID,
767: X_RULE_ID => l_picking_rule_rec.WMS_RULE_ID,
768: X_CREATION_DATE => sysdate,

Line 865: Delete wms_rule_consistencies where rule_id = p_mtl_picking_Rule_rec.wms_rule_id;

861: IS
862: l_api_name CONSTANT VARCHAR2 (30) := 'Consistency_Delete';
863: Begin
864: x_return_status := FND_API.G_RET_STS_SUCCESS;
865: Delete wms_rule_consistencies where rule_id = p_mtl_picking_Rule_rec.wms_rule_id;
866: EXCEPTION
867: WHEN FND_API.G_EXC_ERROR THEN
868: x_return_status := FND_API.G_RET_STS_ERROR;
869: FND_MSG_Pub.count_and_get