APPS.INV_RULE_GEN_PVT dependencies on WMS_SORT_CRITERIA

Line 19: Wms_sort_criteria - if any

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
23: l_module VARCHAR2(255);

Line 995: wms_SORT_CRITERIA_PKG.Insert_Row

991: if l_go_ahead = 1 THEN
992: debug('sort insert, '|| i);
993: debug('sort insert, sequence '||l_sequence);
994: debug('sort insert, wms_rule_id '||p_mtl_picking_rule_rec.wms_rule_id);
995: wms_SORT_CRITERIA_PKG.Insert_Row
996: (
997: X_Rowid => l_Row_Id,
998: X_Rule_Id => p_mtl_picking_rule_rec.WMS_Rule_Id,
999: X_Sequence_Number => l_Sequence,

Line 1102: Delete wms_sort_criteria where rule_id = p_mtl_picking_Rule_rec.wms_rule_id;

1098: l_api_name CONSTANT VARCHAR2 (30) := 'Sorting_criteria_Delete';
1099: Begin
1100: x_return_status := FND_API.G_RET_STS_SUCCESS;
1101: debug('delete sorting criteria');
1102: Delete wms_sort_criteria where rule_id = p_mtl_picking_Rule_rec.wms_rule_id;
1103: EXCEPTION
1104: WHEN FND_API.G_EXC_ERROR THEN
1105: x_return_status := FND_API.G_RET_STS_ERROR;
1106: FND_MSG_Pub.count_and_get