APPS.INV_RULE_GEN_PVT dependencies on WMS_RESTRICTIONS

Line 17: Wms_restrictions - if any

13: /* Save procedure will save the record to the following
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

Line 609: wms_RESTRICTIONS_PKG.Insert_Row(

605: END IF;
606:
607: IF l_go_ahead = 1 THEN
608: debug('call wms restriction insert '||l_go_ahead);
609: wms_RESTRICTIONS_PKG.Insert_Row(
610: X_Rowid => l_Row_Id,
611: X_Rule_Id => l_picking_rule_rec.WMS_Rule_Id,
612: X_Sequence_Number => l_Sequence_Number,
613: X_Last_Updated_By => fnd_global.user_id,

Line 723: Delete wms_restrictions where rule_id = p_mtl_picking_rule_rec.wms_rule_id;

719: IS
720: l_api_name CONSTANT VARCHAR2 (30) := 'Restrictions_Delete';
721: Begin
722: x_return_status := FND_API.G_RET_STS_SUCCESS;
723: Delete wms_restrictions where rule_id = p_mtl_picking_rule_rec.wms_rule_id;
724: EXCEPTION
725: WHEN FND_API.G_EXC_ERROR THEN
726: x_return_status := FND_API.G_RET_STS_ERROR;
727: FND_MSG_Pub.count_and_get