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 1039: wms_SORT_CRITERIA_PKG.Insert_Row

1035: if l_go_ahead = 1 THEN
1036: debug('sort insert, '|| i);
1037: debug('sort insert, sequence '||l_sequence);
1038: debug('sort insert, wms_rule_id '||p_mtl_picking_rule_rec.wms_rule_id);
1039: wms_SORT_CRITERIA_PKG.Insert_Row
1040: (
1041: X_Rowid => l_Row_Id,
1042: X_Rule_Id => p_mtl_picking_rule_rec.WMS_Rule_Id,
1043: X_Sequence_Number => l_Sequence,

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

1142: l_api_name CONSTANT VARCHAR2 (30) := 'Sorting_criteria_Delete';
1143: Begin
1144: x_return_status := FND_API.G_RET_STS_SUCCESS;
1145: debug('delete sorting criteria');
1146: Delete wms_sort_criteria where rule_id = p_mtl_picking_Rule_rec.wms_rule_id;
1147: EXCEPTION
1148: WHEN FND_API.G_EXC_ERROR THEN
1149: x_return_status := FND_API.G_RET_STS_ERROR;
1150: FND_MSG_Pub.count_and_get