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 653: wms_RESTRICTIONS_PKG.Insert_Row(

649: END IF;
650:
651: IF l_go_ahead = 1 THEN
652: debug('call wms restriction insert '||l_go_ahead);
653: wms_RESTRICTIONS_PKG.Insert_Row(
654: X_Rowid => l_Row_Id,
655: X_Rule_Id => l_picking_rule_rec.WMS_Rule_Id,
656: X_Sequence_Number => l_Sequence_Number,
657: X_Last_Updated_By => fnd_global.user_id,

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

763: IS
764: l_api_name CONSTANT VARCHAR2 (30) := 'Restrictions_Delete';
765: Begin
766: x_return_status := FND_API.G_RET_STS_SUCCESS;
767: Delete wms_restrictions where rule_id = p_mtl_picking_rule_rec.wms_rule_id;
768: EXCEPTION
769: WHEN FND_API.G_EXC_ERROR THEN
770: x_return_status := FND_API.G_RET_STS_ERROR;
771: FND_MSG_Pub.count_and_get