DBA Data[Home] [Help]

APPS.WMS_RULES_WORKBENCH_PVT dependencies on WMS_SEARCH_ORDER_GLOBALS_PVT

Line 1048: wms_search_order_globals_pvt.g_putaway_strategy_id := -999;

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;

Line 1049: wms_search_order_globals_pvt.g_putaway_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

Line 1051: wms_search_order_globals_pvt.g_pick_strategy_id := -999;

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;

Line 1052: wms_search_order_globals_pvt.g_pick_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

Line 1054: wms_search_order_globals_pvt.g_costgroup_strategy_id := -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
1057: End if;
1058:

Line 1055: wms_search_order_globals_pvt.g_costgroup_seq_num := -999;

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

Line 1103: wms_search_order_globals_pvt.g_putaway_strategy_id := l_return_type_id;

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;

Line 1104: wms_search_order_globals_pvt.g_putaway_seq_num := l_sequence_number;

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;

Line 1125: wms_search_order_globals_pvt.g_pick_strategy_id := l_return_type_id;

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;

Line 1126: wms_search_order_globals_pvt.g_pick_seq_num := l_sequence_number;

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;

Line 1145: wms_search_order_globals_pvt.g_costgroup_strategy_id := l_return_type_id;

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

Line 1146: wms_search_order_globals_pvt.g_costgroup_seq_num := l_sequence_number;

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;

Line 1155: wms_search_order_globals_pvt.g_putaway_rule_id := l_return_type_id;

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;

Line 1156: wms_search_order_globals_pvt.g_putaway_seq_num := l_sequence_number;

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;

Line 1159: wms_search_order_globals_pvt.g_pick_rule_id := l_return_type_id;

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;

Line 1160: wms_search_order_globals_pvt.g_pick_seq_num := l_sequence_number;

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;

Line 1163: wms_search_order_globals_pvt.g_costgroup_rule_id := l_return_type_id;

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

Line 1164: wms_search_order_globals_pvt.g_costgroup_seq_num := l_sequence_number;

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;

Line 1173: wms_search_order_globals_pvt.g_costgroup_id := l_return_type_id;

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

Line 1174: wms_search_order_globals_pvt.g_costgroup_seq_num := l_sequence_number;

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;

Line 1529: wms_search_order_globals_pvt.g_costgroup_strategy_id := -999;

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;

Line 1530: wms_search_order_globals_pvt.g_costgroup_seq_num := -999;

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:

Line 1547: wms_search_order_globals_pvt.g_costgroup_strategy_id := l_return_type_id;

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;

Line 1548: 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

Line 1550: wms_search_order_globals_pvt.G_COSTGROUP_RULE_ID := l_return_type_id;

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;

Line 1551: 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;

Line 1553: wms_search_order_globals_pvt.G_COSTGROUP_ID := l_return_type_id;

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

Line 1554: wms_search_order_globals_pvt.g_costgroup_seq_num := l_sequence_number;

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