1044: x_return_status := fnd_api.g_ret_sts_success;
1045:
1046: --- setting global variables used by Rules simulator and trace execution forms
1047: IF p_type_code = 1 THEN
1048: wms_search_order_globals_pvt.g_putaway_strategy_id := -999;
1049: wms_search_order_globals_pvt.g_putaway_seq_num := -999;
1050: ELSIF p_type_code = 2 THEN
1051: wms_search_order_globals_pvt.g_pick_strategy_id := -999;
1052: wms_search_order_globals_pvt.g_pick_seq_num := -999;
1045:
1046: --- setting global variables used by Rules simulator and trace execution forms
1047: IF p_type_code = 1 THEN
1048: wms_search_order_globals_pvt.g_putaway_strategy_id := -999;
1049: wms_search_order_globals_pvt.g_putaway_seq_num := -999;
1050: ELSIF p_type_code = 2 THEN
1051: wms_search_order_globals_pvt.g_pick_strategy_id := -999;
1052: wms_search_order_globals_pvt.g_pick_seq_num := -999;
1053: ELSIF p_type_code = 5 THEN
1047: IF p_type_code = 1 THEN
1048: wms_search_order_globals_pvt.g_putaway_strategy_id := -999;
1049: wms_search_order_globals_pvt.g_putaway_seq_num := -999;
1050: ELSIF p_type_code = 2 THEN
1051: wms_search_order_globals_pvt.g_pick_strategy_id := -999;
1052: wms_search_order_globals_pvt.g_pick_seq_num := -999;
1053: ELSIF p_type_code = 5 THEN
1054: wms_search_order_globals_pvt.g_costgroup_strategy_id := -999;
1055: wms_search_order_globals_pvt.g_costgroup_seq_num := -999;
1048: wms_search_order_globals_pvt.g_putaway_strategy_id := -999;
1049: wms_search_order_globals_pvt.g_putaway_seq_num := -999;
1050: ELSIF p_type_code = 2 THEN
1051: wms_search_order_globals_pvt.g_pick_strategy_id := -999;
1052: wms_search_order_globals_pvt.g_pick_seq_num := -999;
1053: ELSIF p_type_code = 5 THEN
1054: wms_search_order_globals_pvt.g_costgroup_strategy_id := -999;
1055: wms_search_order_globals_pvt.g_costgroup_seq_num := -999;
1056: END IF; --- end of globol variables section
1050: ELSIF p_type_code = 2 THEN
1051: wms_search_order_globals_pvt.g_pick_strategy_id := -999;
1052: wms_search_order_globals_pvt.g_pick_seq_num := -999;
1053: ELSIF p_type_code = 5 THEN
1054: wms_search_order_globals_pvt.g_costgroup_strategy_id := -999;
1055: wms_search_order_globals_pvt.g_costgroup_seq_num := -999;
1056: END IF; --- end of globol variables section
1057: End if;
1058:
1051: wms_search_order_globals_pvt.g_pick_strategy_id := -999;
1052: wms_search_order_globals_pvt.g_pick_seq_num := -999;
1053: ELSIF p_type_code = 5 THEN
1054: wms_search_order_globals_pvt.g_costgroup_strategy_id := -999;
1055: wms_search_order_globals_pvt.g_costgroup_seq_num := -999;
1056: END IF; --- end of globol variables section
1057: End if;
1058:
1059: If l_debug = 1 then
1099: IF l_return_type_code = 'S' THEN
1100: --clean up the mtrl table
1101: mtrl_line_tab.delete;
1102: IF p_type_code = 1 THEN
1103: wms_search_order_globals_pvt.g_putaway_strategy_id := l_return_type_id;
1104: wms_search_order_globals_pvt.g_putaway_seq_num := l_sequence_number;
1105:
1106: -- 8809951 start
1107: OPEN SIMILAR_MTRL_LINES;
1100: --clean up the mtrl table
1101: mtrl_line_tab.delete;
1102: IF p_type_code = 1 THEN
1103: wms_search_order_globals_pvt.g_putaway_strategy_id := l_return_type_id;
1104: wms_search_order_globals_pvt.g_putaway_seq_num := l_sequence_number;
1105:
1106: -- 8809951 start
1107: OPEN SIMILAR_MTRL_LINES;
1108: FETCH SIMILAR_MTRL_LINES BULK COLLECT INTO mtrl_line_tab;
1121: -- 8809951 end
1122:
1123:
1124: ELSIF p_type_code = 2 THEN
1125: wms_search_order_globals_pvt.g_pick_strategy_id := l_return_type_id;
1126: wms_search_order_globals_pvt.g_pick_seq_num := l_sequence_number;
1127:
1128: -- 8809951 start
1129: OPEN SIMILAR_MTRL_LINES;
1122:
1123:
1124: ELSIF p_type_code = 2 THEN
1125: wms_search_order_globals_pvt.g_pick_strategy_id := l_return_type_id;
1126: wms_search_order_globals_pvt.g_pick_seq_num := l_sequence_number;
1127:
1128: -- 8809951 start
1129: OPEN SIMILAR_MTRL_LINES;
1130: FETCH SIMILAR_MTRL_LINES BULK COLLECT INTO mtrl_line_tab;
1141:
1142: -- 8809951 end
1143:
1144: ELSIF p_type_code = 5 THEN
1145: wms_search_order_globals_pvt.g_costgroup_strategy_id := l_return_type_id;
1146: wms_search_order_globals_pvt.g_costgroup_seq_num := l_sequence_number;
1147: ELSIF p_type_code = 10 THEN
1148: NULL;
1149: ELSIF p_type_code = 11 THEN
1142: -- 8809951 end
1143:
1144: ELSIF p_type_code = 5 THEN
1145: wms_search_order_globals_pvt.g_costgroup_strategy_id := l_return_type_id;
1146: wms_search_order_globals_pvt.g_costgroup_seq_num := l_sequence_number;
1147: ELSIF p_type_code = 10 THEN
1148: NULL;
1149: ELSIF p_type_code = 11 THEN
1150: NULL;
1151: END IF;
1152:
1153: ELSIF l_return_type_code = 'R' THEN
1154: IF p_type_code = 1 THEN
1155: wms_search_order_globals_pvt.g_putaway_rule_id := l_return_type_id;
1156: wms_search_order_globals_pvt.g_putaway_seq_num := l_sequence_number;
1157:
1158: ELSIF p_type_code = 2 THEN
1159: wms_search_order_globals_pvt.g_pick_rule_id := l_return_type_id;
1152:
1153: ELSIF l_return_type_code = 'R' THEN
1154: IF p_type_code = 1 THEN
1155: wms_search_order_globals_pvt.g_putaway_rule_id := l_return_type_id;
1156: wms_search_order_globals_pvt.g_putaway_seq_num := l_sequence_number;
1157:
1158: ELSIF p_type_code = 2 THEN
1159: wms_search_order_globals_pvt.g_pick_rule_id := l_return_type_id;
1160: wms_search_order_globals_pvt.g_pick_seq_num := l_sequence_number;
1155: wms_search_order_globals_pvt.g_putaway_rule_id := l_return_type_id;
1156: wms_search_order_globals_pvt.g_putaway_seq_num := l_sequence_number;
1157:
1158: ELSIF p_type_code = 2 THEN
1159: wms_search_order_globals_pvt.g_pick_rule_id := l_return_type_id;
1160: wms_search_order_globals_pvt.g_pick_seq_num := l_sequence_number;
1161:
1162: ELSIF p_type_code = 5 THEN
1163: wms_search_order_globals_pvt.g_costgroup_rule_id := l_return_type_id;
1156: wms_search_order_globals_pvt.g_putaway_seq_num := l_sequence_number;
1157:
1158: ELSIF p_type_code = 2 THEN
1159: wms_search_order_globals_pvt.g_pick_rule_id := l_return_type_id;
1160: wms_search_order_globals_pvt.g_pick_seq_num := l_sequence_number;
1161:
1162: ELSIF p_type_code = 5 THEN
1163: wms_search_order_globals_pvt.g_costgroup_rule_id := l_return_type_id;
1164: wms_search_order_globals_pvt.g_costgroup_seq_num := l_sequence_number;
1159: wms_search_order_globals_pvt.g_pick_rule_id := l_return_type_id;
1160: wms_search_order_globals_pvt.g_pick_seq_num := l_sequence_number;
1161:
1162: ELSIF p_type_code = 5 THEN
1163: wms_search_order_globals_pvt.g_costgroup_rule_id := l_return_type_id;
1164: wms_search_order_globals_pvt.g_costgroup_seq_num := l_sequence_number;
1165: ELSIF p_type_code = 10 THEN
1166: NULL;
1167: ELSIF p_type_code = 11 THEN
1160: wms_search_order_globals_pvt.g_pick_seq_num := l_sequence_number;
1161:
1162: ELSIF p_type_code = 5 THEN
1163: wms_search_order_globals_pvt.g_costgroup_rule_id := l_return_type_id;
1164: wms_search_order_globals_pvt.g_costgroup_seq_num := l_sequence_number;
1165: ELSIF p_type_code = 10 THEN
1166: NULL;
1167: ELSIF p_type_code = 11 THEN
1168: NULL;
1169: END IF;
1170: ELSIF l_return_type_code = 'V' THEN
1171:
1172: IF p_type_code = 5 THEN
1173: wms_search_order_globals_pvt.g_costgroup_id := l_return_type_id;
1174: wms_search_order_globals_pvt.g_costgroup_seq_num := l_sequence_number;
1175: ELSIF p_type_code = 10 THEN
1176: NULL;
1177: ELSIF p_type_code = 11 THEN
1170: ELSIF l_return_type_code = 'V' THEN
1171:
1172: IF p_type_code = 5 THEN
1173: wms_search_order_globals_pvt.g_costgroup_id := l_return_type_id;
1174: wms_search_order_globals_pvt.g_costgroup_seq_num := l_sequence_number;
1175: ELSIF p_type_code = 10 THEN
1176: NULL;
1177: ELSIF p_type_code = 11 THEN
1178: NULL;
1525: l_return_type_id := NULL;
1526: l_sequence_number := NULL;
1527:
1528: IF p_type_code = 5 THEN
1529: wms_search_order_globals_pvt.g_costgroup_strategy_id := -999;
1530: wms_search_order_globals_pvt.g_costgroup_seq_num := -999;
1531: END IF;
1532: x_return_status := fnd_api.g_ret_sts_success;
1533: End if;
1526: l_sequence_number := NULL;
1527:
1528: IF p_type_code = 5 THEN
1529: wms_search_order_globals_pvt.g_costgroup_strategy_id := -999;
1530: wms_search_order_globals_pvt.g_costgroup_seq_num := -999;
1531: END IF;
1532: x_return_status := fnd_api.g_ret_sts_success;
1533: End if;
1534:
1543: end if;
1544: --- setting global variables used by Rules simulator and trace execution forms
1545: IF p_type_code = 5 THEN
1546: IF l_return_type_code = 'S' THEN
1547: wms_search_order_globals_pvt.g_costgroup_strategy_id := l_return_type_id;
1548: wms_search_order_globals_pvt.g_costgroup_seq_num := l_sequence_number;
1549: ELSIF( l_return_type_code = 'R' ) THEN
1550: wms_search_order_globals_pvt.G_COSTGROUP_RULE_ID := l_return_type_id;
1551: wms_search_order_globals_pvt.g_costgroup_seq_num := l_sequence_number;
1544: --- setting global variables used by Rules simulator and trace execution forms
1545: IF p_type_code = 5 THEN
1546: IF l_return_type_code = 'S' THEN
1547: wms_search_order_globals_pvt.g_costgroup_strategy_id := l_return_type_id;
1548: wms_search_order_globals_pvt.g_costgroup_seq_num := l_sequence_number;
1549: ELSIF( l_return_type_code = 'R' ) THEN
1550: wms_search_order_globals_pvt.G_COSTGROUP_RULE_ID := l_return_type_id;
1551: wms_search_order_globals_pvt.g_costgroup_seq_num := l_sequence_number;
1552: ELSIF( l_return_type_code = 'V' ) THEN
1546: IF l_return_type_code = 'S' THEN
1547: wms_search_order_globals_pvt.g_costgroup_strategy_id := l_return_type_id;
1548: wms_search_order_globals_pvt.g_costgroup_seq_num := l_sequence_number;
1549: ELSIF( l_return_type_code = 'R' ) THEN
1550: wms_search_order_globals_pvt.G_COSTGROUP_RULE_ID := l_return_type_id;
1551: wms_search_order_globals_pvt.g_costgroup_seq_num := l_sequence_number;
1552: ELSIF( l_return_type_code = 'V' ) THEN
1553: wms_search_order_globals_pvt.G_COSTGROUP_ID := l_return_type_id;
1554: wms_search_order_globals_pvt.g_costgroup_seq_num := l_sequence_number;
1547: wms_search_order_globals_pvt.g_costgroup_strategy_id := l_return_type_id;
1548: wms_search_order_globals_pvt.g_costgroup_seq_num := l_sequence_number;
1549: ELSIF( l_return_type_code = 'R' ) THEN
1550: wms_search_order_globals_pvt.G_COSTGROUP_RULE_ID := l_return_type_id;
1551: wms_search_order_globals_pvt.g_costgroup_seq_num := l_sequence_number;
1552: ELSIF( l_return_type_code = 'V' ) THEN
1553: wms_search_order_globals_pvt.G_COSTGROUP_ID := l_return_type_id;
1554: wms_search_order_globals_pvt.g_costgroup_seq_num := l_sequence_number;
1555: END IF;
1549: ELSIF( l_return_type_code = 'R' ) THEN
1550: wms_search_order_globals_pvt.G_COSTGROUP_RULE_ID := l_return_type_id;
1551: wms_search_order_globals_pvt.g_costgroup_seq_num := l_sequence_number;
1552: ELSIF( l_return_type_code = 'V' ) THEN
1553: wms_search_order_globals_pvt.G_COSTGROUP_ID := l_return_type_id;
1554: wms_search_order_globals_pvt.g_costgroup_seq_num := l_sequence_number;
1555: END IF;
1556: END IF;
1557: --- end of globol variables section
1550: wms_search_order_globals_pvt.G_COSTGROUP_RULE_ID := l_return_type_id;
1551: wms_search_order_globals_pvt.g_costgroup_seq_num := l_sequence_number;
1552: ELSIF( l_return_type_code = 'V' ) THEN
1553: wms_search_order_globals_pvt.G_COSTGROUP_ID := l_return_type_id;
1554: wms_search_order_globals_pvt.g_costgroup_seq_num := l_sequence_number;
1555: END IF;
1556: END IF;
1557: --- end of globol variables section
1558: if l_debug = 1 then