1: PACKAGE WSH_PICKING_BATCHES_GRP AS
2: /* $Header: WSHPRGPS.pls 120.1 2007/12/21 14:26:21 mvudugul ship $ */
3: --
4: --
5: --===================
7: --===================
8: --
9: TYPE Batch_Info_rec IS Record (
10: Row_id VARCHAR2(18),
11: Batch_Id wsh_picking_batches.Batch_Id%TYPE,
12: Creation_Date DATE,
13: Created_By wsh_picking_batches.Created_By%TYPE,
14: Last_Update_Date DATE,
15: Last_Updated_By wsh_picking_batches.Last_Updated_By%TYPE,
9: TYPE Batch_Info_rec IS Record (
10: Row_id VARCHAR2(18),
11: Batch_Id wsh_picking_batches.Batch_Id%TYPE,
12: Creation_Date DATE,
13: Created_By wsh_picking_batches.Created_By%TYPE,
14: Last_Update_Date DATE,
15: Last_Updated_By wsh_picking_batches.Last_Updated_By%TYPE,
16: Last_Update_Login wsh_picking_batches.Last_Update_Login%TYPE,
17: Name wsh_picking_batches.Name%TYPE,
11: Batch_Id wsh_picking_batches.Batch_Id%TYPE,
12: Creation_Date DATE,
13: Created_By wsh_picking_batches.Created_By%TYPE,
14: Last_Update_Date DATE,
15: Last_Updated_By wsh_picking_batches.Last_Updated_By%TYPE,
16: Last_Update_Login wsh_picking_batches.Last_Update_Login%TYPE,
17: Name wsh_picking_batches.Name%TYPE,
18: Backorders_Only_Flag wsh_picking_batches.Backorders_Only_Flag%TYPE,
19: Document_Set_Id wsh_picking_batches.Document_Set_Id%TYPE,
12: Creation_Date DATE,
13: Created_By wsh_picking_batches.Created_By%TYPE,
14: Last_Update_Date DATE,
15: Last_Updated_By wsh_picking_batches.Last_Updated_By%TYPE,
16: Last_Update_Login wsh_picking_batches.Last_Update_Login%TYPE,
17: Name wsh_picking_batches.Name%TYPE,
18: Backorders_Only_Flag wsh_picking_batches.Backorders_Only_Flag%TYPE,
19: Document_Set_Id wsh_picking_batches.Document_Set_Id%TYPE,
20: Existing_Rsvs_Only_Flag wsh_picking_batches.Existing_Rsvs_Only_Flag%TYPE,
13: Created_By wsh_picking_batches.Created_By%TYPE,
14: Last_Update_Date DATE,
15: Last_Updated_By wsh_picking_batches.Last_Updated_By%TYPE,
16: Last_Update_Login wsh_picking_batches.Last_Update_Login%TYPE,
17: Name wsh_picking_batches.Name%TYPE,
18: Backorders_Only_Flag wsh_picking_batches.Backorders_Only_Flag%TYPE,
19: Document_Set_Id wsh_picking_batches.Document_Set_Id%TYPE,
20: Existing_Rsvs_Only_Flag wsh_picking_batches.Existing_Rsvs_Only_Flag%TYPE,
21: Shipment_Priority_Code wsh_picking_batches.Shipment_Priority_Code%TYPE,
14: Last_Update_Date DATE,
15: Last_Updated_By wsh_picking_batches.Last_Updated_By%TYPE,
16: Last_Update_Login wsh_picking_batches.Last_Update_Login%TYPE,
17: Name wsh_picking_batches.Name%TYPE,
18: Backorders_Only_Flag wsh_picking_batches.Backorders_Only_Flag%TYPE,
19: Document_Set_Id wsh_picking_batches.Document_Set_Id%TYPE,
20: Existing_Rsvs_Only_Flag wsh_picking_batches.Existing_Rsvs_Only_Flag%TYPE,
21: Shipment_Priority_Code wsh_picking_batches.Shipment_Priority_Code%TYPE,
22: Ship_Method_Code wsh_picking_batches.Ship_Method_Code%TYPE,
15: Last_Updated_By wsh_picking_batches.Last_Updated_By%TYPE,
16: Last_Update_Login wsh_picking_batches.Last_Update_Login%TYPE,
17: Name wsh_picking_batches.Name%TYPE,
18: Backorders_Only_Flag wsh_picking_batches.Backorders_Only_Flag%TYPE,
19: Document_Set_Id wsh_picking_batches.Document_Set_Id%TYPE,
20: Existing_Rsvs_Only_Flag wsh_picking_batches.Existing_Rsvs_Only_Flag%TYPE,
21: Shipment_Priority_Code wsh_picking_batches.Shipment_Priority_Code%TYPE,
22: Ship_Method_Code wsh_picking_batches.Ship_Method_Code%TYPE,
23: Customer_Id wsh_picking_batches.Customer_Id%TYPE,
16: Last_Update_Login wsh_picking_batches.Last_Update_Login%TYPE,
17: Name wsh_picking_batches.Name%TYPE,
18: Backorders_Only_Flag wsh_picking_batches.Backorders_Only_Flag%TYPE,
19: Document_Set_Id wsh_picking_batches.Document_Set_Id%TYPE,
20: Existing_Rsvs_Only_Flag wsh_picking_batches.Existing_Rsvs_Only_Flag%TYPE,
21: Shipment_Priority_Code wsh_picking_batches.Shipment_Priority_Code%TYPE,
22: Ship_Method_Code wsh_picking_batches.Ship_Method_Code%TYPE,
23: Customer_Id wsh_picking_batches.Customer_Id%TYPE,
24: Order_Header_Id wsh_picking_batches.Order_Header_Id%TYPE,
17: Name wsh_picking_batches.Name%TYPE,
18: Backorders_Only_Flag wsh_picking_batches.Backorders_Only_Flag%TYPE,
19: Document_Set_Id wsh_picking_batches.Document_Set_Id%TYPE,
20: Existing_Rsvs_Only_Flag wsh_picking_batches.Existing_Rsvs_Only_Flag%TYPE,
21: Shipment_Priority_Code wsh_picking_batches.Shipment_Priority_Code%TYPE,
22: Ship_Method_Code wsh_picking_batches.Ship_Method_Code%TYPE,
23: Customer_Id wsh_picking_batches.Customer_Id%TYPE,
24: Order_Header_Id wsh_picking_batches.Order_Header_Id%TYPE,
25: Ship_Set_id wsh_picking_batches.Ship_Set_number%TYPE,
18: Backorders_Only_Flag wsh_picking_batches.Backorders_Only_Flag%TYPE,
19: Document_Set_Id wsh_picking_batches.Document_Set_Id%TYPE,
20: Existing_Rsvs_Only_Flag wsh_picking_batches.Existing_Rsvs_Only_Flag%TYPE,
21: Shipment_Priority_Code wsh_picking_batches.Shipment_Priority_Code%TYPE,
22: Ship_Method_Code wsh_picking_batches.Ship_Method_Code%TYPE,
23: Customer_Id wsh_picking_batches.Customer_Id%TYPE,
24: Order_Header_Id wsh_picking_batches.Order_Header_Id%TYPE,
25: Ship_Set_id wsh_picking_batches.Ship_Set_number%TYPE,
26: Inventory_Item_Id wsh_picking_batches.Inventory_Item_Id%TYPE,
19: Document_Set_Id wsh_picking_batches.Document_Set_Id%TYPE,
20: Existing_Rsvs_Only_Flag wsh_picking_batches.Existing_Rsvs_Only_Flag%TYPE,
21: Shipment_Priority_Code wsh_picking_batches.Shipment_Priority_Code%TYPE,
22: Ship_Method_Code wsh_picking_batches.Ship_Method_Code%TYPE,
23: Customer_Id wsh_picking_batches.Customer_Id%TYPE,
24: Order_Header_Id wsh_picking_batches.Order_Header_Id%TYPE,
25: Ship_Set_id wsh_picking_batches.Ship_Set_number%TYPE,
26: Inventory_Item_Id wsh_picking_batches.Inventory_Item_Id%TYPE,
27: Order_Type_Id wsh_picking_batches.Order_Type_Id%TYPE,
20: Existing_Rsvs_Only_Flag wsh_picking_batches.Existing_Rsvs_Only_Flag%TYPE,
21: Shipment_Priority_Code wsh_picking_batches.Shipment_Priority_Code%TYPE,
22: Ship_Method_Code wsh_picking_batches.Ship_Method_Code%TYPE,
23: Customer_Id wsh_picking_batches.Customer_Id%TYPE,
24: Order_Header_Id wsh_picking_batches.Order_Header_Id%TYPE,
25: Ship_Set_id wsh_picking_batches.Ship_Set_number%TYPE,
26: Inventory_Item_Id wsh_picking_batches.Inventory_Item_Id%TYPE,
27: Order_Type_Id wsh_picking_batches.Order_Type_Id%TYPE,
28: From_Requested_Date DATE,
21: Shipment_Priority_Code wsh_picking_batches.Shipment_Priority_Code%TYPE,
22: Ship_Method_Code wsh_picking_batches.Ship_Method_Code%TYPE,
23: Customer_Id wsh_picking_batches.Customer_Id%TYPE,
24: Order_Header_Id wsh_picking_batches.Order_Header_Id%TYPE,
25: Ship_Set_id wsh_picking_batches.Ship_Set_number%TYPE,
26: Inventory_Item_Id wsh_picking_batches.Inventory_Item_Id%TYPE,
27: Order_Type_Id wsh_picking_batches.Order_Type_Id%TYPE,
28: From_Requested_Date DATE,
29: To_Requested_Date DATE,
22: Ship_Method_Code wsh_picking_batches.Ship_Method_Code%TYPE,
23: Customer_Id wsh_picking_batches.Customer_Id%TYPE,
24: Order_Header_Id wsh_picking_batches.Order_Header_Id%TYPE,
25: Ship_Set_id wsh_picking_batches.Ship_Set_number%TYPE,
26: Inventory_Item_Id wsh_picking_batches.Inventory_Item_Id%TYPE,
27: Order_Type_Id wsh_picking_batches.Order_Type_Id%TYPE,
28: From_Requested_Date DATE,
29: To_Requested_Date DATE,
30: From_Scheduled_Ship_Date DATE,
23: Customer_Id wsh_picking_batches.Customer_Id%TYPE,
24: Order_Header_Id wsh_picking_batches.Order_Header_Id%TYPE,
25: Ship_Set_id wsh_picking_batches.Ship_Set_number%TYPE,
26: Inventory_Item_Id wsh_picking_batches.Inventory_Item_Id%TYPE,
27: Order_Type_Id wsh_picking_batches.Order_Type_Id%TYPE,
28: From_Requested_Date DATE,
29: To_Requested_Date DATE,
30: From_Scheduled_Ship_Date DATE,
31: To_Scheduled_Ship_Date DATE,
28: From_Requested_Date DATE,
29: To_Requested_Date DATE,
30: From_Scheduled_Ship_Date DATE,
31: To_Scheduled_Ship_Date DATE,
32: Ship_To_Location_Id wsh_picking_batches.Ship_To_Location_Id%TYPE,
33: Ship_From_Location_Id wsh_picking_batches.Ship_From_Location_Id%TYPE,
34: Trip_Id wsh_picking_batches.Trip_Id%TYPE,
35: Delivery_Id wsh_picking_batches.Delivery_Id%TYPE,
36: Include_Planned_Lines wsh_picking_batches.Include_Planned_Lines%TYPE,
29: To_Requested_Date DATE,
30: From_Scheduled_Ship_Date DATE,
31: To_Scheduled_Ship_Date DATE,
32: Ship_To_Location_Id wsh_picking_batches.Ship_To_Location_Id%TYPE,
33: Ship_From_Location_Id wsh_picking_batches.Ship_From_Location_Id%TYPE,
34: Trip_Id wsh_picking_batches.Trip_Id%TYPE,
35: Delivery_Id wsh_picking_batches.Delivery_Id%TYPE,
36: Include_Planned_Lines wsh_picking_batches.Include_Planned_Lines%TYPE,
37: Pick_Grouping_Rule_Id wsh_picking_batches.Pick_Grouping_Rule_Id%TYPE,
30: From_Scheduled_Ship_Date DATE,
31: To_Scheduled_Ship_Date DATE,
32: Ship_To_Location_Id wsh_picking_batches.Ship_To_Location_Id%TYPE,
33: Ship_From_Location_Id wsh_picking_batches.Ship_From_Location_Id%TYPE,
34: Trip_Id wsh_picking_batches.Trip_Id%TYPE,
35: Delivery_Id wsh_picking_batches.Delivery_Id%TYPE,
36: Include_Planned_Lines wsh_picking_batches.Include_Planned_Lines%TYPE,
37: Pick_Grouping_Rule_Id wsh_picking_batches.Pick_Grouping_Rule_Id%TYPE,
38: Pick_Sequence_Rule_Id wsh_picking_batches.Pick_Sequence_Rule_Id%TYPE,
31: To_Scheduled_Ship_Date DATE,
32: Ship_To_Location_Id wsh_picking_batches.Ship_To_Location_Id%TYPE,
33: Ship_From_Location_Id wsh_picking_batches.Ship_From_Location_Id%TYPE,
34: Trip_Id wsh_picking_batches.Trip_Id%TYPE,
35: Delivery_Id wsh_picking_batches.Delivery_Id%TYPE,
36: Include_Planned_Lines wsh_picking_batches.Include_Planned_Lines%TYPE,
37: Pick_Grouping_Rule_Id wsh_picking_batches.Pick_Grouping_Rule_Id%TYPE,
38: Pick_Sequence_Rule_Id wsh_picking_batches.Pick_Sequence_Rule_Id%TYPE,
39: Autocreate_Delivery_Flag wsh_picking_batches.Autocreate_Delivery_Flag%TYPE,
32: Ship_To_Location_Id wsh_picking_batches.Ship_To_Location_Id%TYPE,
33: Ship_From_Location_Id wsh_picking_batches.Ship_From_Location_Id%TYPE,
34: Trip_Id wsh_picking_batches.Trip_Id%TYPE,
35: Delivery_Id wsh_picking_batches.Delivery_Id%TYPE,
36: Include_Planned_Lines wsh_picking_batches.Include_Planned_Lines%TYPE,
37: Pick_Grouping_Rule_Id wsh_picking_batches.Pick_Grouping_Rule_Id%TYPE,
38: Pick_Sequence_Rule_Id wsh_picking_batches.Pick_Sequence_Rule_Id%TYPE,
39: Autocreate_Delivery_Flag wsh_picking_batches.Autocreate_Delivery_Flag%TYPE,
40: Attribute_Category wsh_picking_batches.Attribute_Category%TYPE,
33: Ship_From_Location_Id wsh_picking_batches.Ship_From_Location_Id%TYPE,
34: Trip_Id wsh_picking_batches.Trip_Id%TYPE,
35: Delivery_Id wsh_picking_batches.Delivery_Id%TYPE,
36: Include_Planned_Lines wsh_picking_batches.Include_Planned_Lines%TYPE,
37: Pick_Grouping_Rule_Id wsh_picking_batches.Pick_Grouping_Rule_Id%TYPE,
38: Pick_Sequence_Rule_Id wsh_picking_batches.Pick_Sequence_Rule_Id%TYPE,
39: Autocreate_Delivery_Flag wsh_picking_batches.Autocreate_Delivery_Flag%TYPE,
40: Attribute_Category wsh_picking_batches.Attribute_Category%TYPE,
41: Attribute1 wsh_picking_batches.Attribute1%TYPE,
34: Trip_Id wsh_picking_batches.Trip_Id%TYPE,
35: Delivery_Id wsh_picking_batches.Delivery_Id%TYPE,
36: Include_Planned_Lines wsh_picking_batches.Include_Planned_Lines%TYPE,
37: Pick_Grouping_Rule_Id wsh_picking_batches.Pick_Grouping_Rule_Id%TYPE,
38: Pick_Sequence_Rule_Id wsh_picking_batches.Pick_Sequence_Rule_Id%TYPE,
39: Autocreate_Delivery_Flag wsh_picking_batches.Autocreate_Delivery_Flag%TYPE,
40: Attribute_Category wsh_picking_batches.Attribute_Category%TYPE,
41: Attribute1 wsh_picking_batches.Attribute1%TYPE,
42: Attribute2 wsh_picking_batches.Attribute2%TYPE,
35: Delivery_Id wsh_picking_batches.Delivery_Id%TYPE,
36: Include_Planned_Lines wsh_picking_batches.Include_Planned_Lines%TYPE,
37: Pick_Grouping_Rule_Id wsh_picking_batches.Pick_Grouping_Rule_Id%TYPE,
38: Pick_Sequence_Rule_Id wsh_picking_batches.Pick_Sequence_Rule_Id%TYPE,
39: Autocreate_Delivery_Flag wsh_picking_batches.Autocreate_Delivery_Flag%TYPE,
40: Attribute_Category wsh_picking_batches.Attribute_Category%TYPE,
41: Attribute1 wsh_picking_batches.Attribute1%TYPE,
42: Attribute2 wsh_picking_batches.Attribute2%TYPE,
43: Attribute3 wsh_picking_batches.Attribute3%TYPE,
36: Include_Planned_Lines wsh_picking_batches.Include_Planned_Lines%TYPE,
37: Pick_Grouping_Rule_Id wsh_picking_batches.Pick_Grouping_Rule_Id%TYPE,
38: Pick_Sequence_Rule_Id wsh_picking_batches.Pick_Sequence_Rule_Id%TYPE,
39: Autocreate_Delivery_Flag wsh_picking_batches.Autocreate_Delivery_Flag%TYPE,
40: Attribute_Category wsh_picking_batches.Attribute_Category%TYPE,
41: Attribute1 wsh_picking_batches.Attribute1%TYPE,
42: Attribute2 wsh_picking_batches.Attribute2%TYPE,
43: Attribute3 wsh_picking_batches.Attribute3%TYPE,
44: Attribute4 wsh_picking_batches.Attribute4%TYPE,
37: Pick_Grouping_Rule_Id wsh_picking_batches.Pick_Grouping_Rule_Id%TYPE,
38: Pick_Sequence_Rule_Id wsh_picking_batches.Pick_Sequence_Rule_Id%TYPE,
39: Autocreate_Delivery_Flag wsh_picking_batches.Autocreate_Delivery_Flag%TYPE,
40: Attribute_Category wsh_picking_batches.Attribute_Category%TYPE,
41: Attribute1 wsh_picking_batches.Attribute1%TYPE,
42: Attribute2 wsh_picking_batches.Attribute2%TYPE,
43: Attribute3 wsh_picking_batches.Attribute3%TYPE,
44: Attribute4 wsh_picking_batches.Attribute4%TYPE,
45: Attribute5 wsh_picking_batches.Attribute5%TYPE,
38: Pick_Sequence_Rule_Id wsh_picking_batches.Pick_Sequence_Rule_Id%TYPE,
39: Autocreate_Delivery_Flag wsh_picking_batches.Autocreate_Delivery_Flag%TYPE,
40: Attribute_Category wsh_picking_batches.Attribute_Category%TYPE,
41: Attribute1 wsh_picking_batches.Attribute1%TYPE,
42: Attribute2 wsh_picking_batches.Attribute2%TYPE,
43: Attribute3 wsh_picking_batches.Attribute3%TYPE,
44: Attribute4 wsh_picking_batches.Attribute4%TYPE,
45: Attribute5 wsh_picking_batches.Attribute5%TYPE,
46: Attribute6 wsh_picking_batches.Attribute6%TYPE,
39: Autocreate_Delivery_Flag wsh_picking_batches.Autocreate_Delivery_Flag%TYPE,
40: Attribute_Category wsh_picking_batches.Attribute_Category%TYPE,
41: Attribute1 wsh_picking_batches.Attribute1%TYPE,
42: Attribute2 wsh_picking_batches.Attribute2%TYPE,
43: Attribute3 wsh_picking_batches.Attribute3%TYPE,
44: Attribute4 wsh_picking_batches.Attribute4%TYPE,
45: Attribute5 wsh_picking_batches.Attribute5%TYPE,
46: Attribute6 wsh_picking_batches.Attribute6%TYPE,
47: Attribute7 wsh_picking_batches.Attribute7%TYPE,
40: Attribute_Category wsh_picking_batches.Attribute_Category%TYPE,
41: Attribute1 wsh_picking_batches.Attribute1%TYPE,
42: Attribute2 wsh_picking_batches.Attribute2%TYPE,
43: Attribute3 wsh_picking_batches.Attribute3%TYPE,
44: Attribute4 wsh_picking_batches.Attribute4%TYPE,
45: Attribute5 wsh_picking_batches.Attribute5%TYPE,
46: Attribute6 wsh_picking_batches.Attribute6%TYPE,
47: Attribute7 wsh_picking_batches.Attribute7%TYPE,
48: Attribute8 wsh_picking_batches.Attribute8%TYPE,
41: Attribute1 wsh_picking_batches.Attribute1%TYPE,
42: Attribute2 wsh_picking_batches.Attribute2%TYPE,
43: Attribute3 wsh_picking_batches.Attribute3%TYPE,
44: Attribute4 wsh_picking_batches.Attribute4%TYPE,
45: Attribute5 wsh_picking_batches.Attribute5%TYPE,
46: Attribute6 wsh_picking_batches.Attribute6%TYPE,
47: Attribute7 wsh_picking_batches.Attribute7%TYPE,
48: Attribute8 wsh_picking_batches.Attribute8%TYPE,
49: Attribute9 wsh_picking_batches.Attribute9%TYPE,
42: Attribute2 wsh_picking_batches.Attribute2%TYPE,
43: Attribute3 wsh_picking_batches.Attribute3%TYPE,
44: Attribute4 wsh_picking_batches.Attribute4%TYPE,
45: Attribute5 wsh_picking_batches.Attribute5%TYPE,
46: Attribute6 wsh_picking_batches.Attribute6%TYPE,
47: Attribute7 wsh_picking_batches.Attribute7%TYPE,
48: Attribute8 wsh_picking_batches.Attribute8%TYPE,
49: Attribute9 wsh_picking_batches.Attribute9%TYPE,
50: Attribute10 wsh_picking_batches.Attribute10%TYPE,
43: Attribute3 wsh_picking_batches.Attribute3%TYPE,
44: Attribute4 wsh_picking_batches.Attribute4%TYPE,
45: Attribute5 wsh_picking_batches.Attribute5%TYPE,
46: Attribute6 wsh_picking_batches.Attribute6%TYPE,
47: Attribute7 wsh_picking_batches.Attribute7%TYPE,
48: Attribute8 wsh_picking_batches.Attribute8%TYPE,
49: Attribute9 wsh_picking_batches.Attribute9%TYPE,
50: Attribute10 wsh_picking_batches.Attribute10%TYPE,
51: Attribute11 wsh_picking_batches.Attribute11%TYPE,
44: Attribute4 wsh_picking_batches.Attribute4%TYPE,
45: Attribute5 wsh_picking_batches.Attribute5%TYPE,
46: Attribute6 wsh_picking_batches.Attribute6%TYPE,
47: Attribute7 wsh_picking_batches.Attribute7%TYPE,
48: Attribute8 wsh_picking_batches.Attribute8%TYPE,
49: Attribute9 wsh_picking_batches.Attribute9%TYPE,
50: Attribute10 wsh_picking_batches.Attribute10%TYPE,
51: Attribute11 wsh_picking_batches.Attribute11%TYPE,
52: Attribute12 wsh_picking_batches.Attribute12%TYPE,
45: Attribute5 wsh_picking_batches.Attribute5%TYPE,
46: Attribute6 wsh_picking_batches.Attribute6%TYPE,
47: Attribute7 wsh_picking_batches.Attribute7%TYPE,
48: Attribute8 wsh_picking_batches.Attribute8%TYPE,
49: Attribute9 wsh_picking_batches.Attribute9%TYPE,
50: Attribute10 wsh_picking_batches.Attribute10%TYPE,
51: Attribute11 wsh_picking_batches.Attribute11%TYPE,
52: Attribute12 wsh_picking_batches.Attribute12%TYPE,
53: Attribute13 wsh_picking_batches.Attribute13%TYPE,
46: Attribute6 wsh_picking_batches.Attribute6%TYPE,
47: Attribute7 wsh_picking_batches.Attribute7%TYPE,
48: Attribute8 wsh_picking_batches.Attribute8%TYPE,
49: Attribute9 wsh_picking_batches.Attribute9%TYPE,
50: Attribute10 wsh_picking_batches.Attribute10%TYPE,
51: Attribute11 wsh_picking_batches.Attribute11%TYPE,
52: Attribute12 wsh_picking_batches.Attribute12%TYPE,
53: Attribute13 wsh_picking_batches.Attribute13%TYPE,
54: Attribute14 wsh_picking_batches.Attribute14%TYPE,
47: Attribute7 wsh_picking_batches.Attribute7%TYPE,
48: Attribute8 wsh_picking_batches.Attribute8%TYPE,
49: Attribute9 wsh_picking_batches.Attribute9%TYPE,
50: Attribute10 wsh_picking_batches.Attribute10%TYPE,
51: Attribute11 wsh_picking_batches.Attribute11%TYPE,
52: Attribute12 wsh_picking_batches.Attribute12%TYPE,
53: Attribute13 wsh_picking_batches.Attribute13%TYPE,
54: Attribute14 wsh_picking_batches.Attribute14%TYPE,
55: Attribute15 wsh_picking_batches.Attribute15%TYPE,
48: Attribute8 wsh_picking_batches.Attribute8%TYPE,
49: Attribute9 wsh_picking_batches.Attribute9%TYPE,
50: Attribute10 wsh_picking_batches.Attribute10%TYPE,
51: Attribute11 wsh_picking_batches.Attribute11%TYPE,
52: Attribute12 wsh_picking_batches.Attribute12%TYPE,
53: Attribute13 wsh_picking_batches.Attribute13%TYPE,
54: Attribute14 wsh_picking_batches.Attribute14%TYPE,
55: Attribute15 wsh_picking_batches.Attribute15%TYPE,
56: Autodetail_Pr_Flag wsh_picking_batches.Autodetail_Pr_Flag%TYPE,
49: Attribute9 wsh_picking_batches.Attribute9%TYPE,
50: Attribute10 wsh_picking_batches.Attribute10%TYPE,
51: Attribute11 wsh_picking_batches.Attribute11%TYPE,
52: Attribute12 wsh_picking_batches.Attribute12%TYPE,
53: Attribute13 wsh_picking_batches.Attribute13%TYPE,
54: Attribute14 wsh_picking_batches.Attribute14%TYPE,
55: Attribute15 wsh_picking_batches.Attribute15%TYPE,
56: Autodetail_Pr_Flag wsh_picking_batches.Autodetail_Pr_Flag%TYPE,
57: -- Bug#: 3266659 - Removing carrier params
50: Attribute10 wsh_picking_batches.Attribute10%TYPE,
51: Attribute11 wsh_picking_batches.Attribute11%TYPE,
52: Attribute12 wsh_picking_batches.Attribute12%TYPE,
53: Attribute13 wsh_picking_batches.Attribute13%TYPE,
54: Attribute14 wsh_picking_batches.Attribute14%TYPE,
55: Attribute15 wsh_picking_batches.Attribute15%TYPE,
56: Autodetail_Pr_Flag wsh_picking_batches.Autodetail_Pr_Flag%TYPE,
57: -- Bug#: 3266659 - Removing carrier params
58: -- Carrier_Id wsh_picking_batches.Carrier_Id%TYPE,
51: Attribute11 wsh_picking_batches.Attribute11%TYPE,
52: Attribute12 wsh_picking_batches.Attribute12%TYPE,
53: Attribute13 wsh_picking_batches.Attribute13%TYPE,
54: Attribute14 wsh_picking_batches.Attribute14%TYPE,
55: Attribute15 wsh_picking_batches.Attribute15%TYPE,
56: Autodetail_Pr_Flag wsh_picking_batches.Autodetail_Pr_Flag%TYPE,
57: -- Bug#: 3266659 - Removing carrier params
58: -- Carrier_Id wsh_picking_batches.Carrier_Id%TYPE,
59: Trip_Stop_Id wsh_picking_batches.Trip_Stop_Id%TYPE,
52: Attribute12 wsh_picking_batches.Attribute12%TYPE,
53: Attribute13 wsh_picking_batches.Attribute13%TYPE,
54: Attribute14 wsh_picking_batches.Attribute14%TYPE,
55: Attribute15 wsh_picking_batches.Attribute15%TYPE,
56: Autodetail_Pr_Flag wsh_picking_batches.Autodetail_Pr_Flag%TYPE,
57: -- Bug#: 3266659 - Removing carrier params
58: -- Carrier_Id wsh_picking_batches.Carrier_Id%TYPE,
59: Trip_Stop_Id wsh_picking_batches.Trip_Stop_Id%TYPE,
60: Default_Stage_Subinventory wsh_picking_batches.Default_Stage_Subinventory%TYPE,
54: Attribute14 wsh_picking_batches.Attribute14%TYPE,
55: Attribute15 wsh_picking_batches.Attribute15%TYPE,
56: Autodetail_Pr_Flag wsh_picking_batches.Autodetail_Pr_Flag%TYPE,
57: -- Bug#: 3266659 - Removing carrier params
58: -- Carrier_Id wsh_picking_batches.Carrier_Id%TYPE,
59: Trip_Stop_Id wsh_picking_batches.Trip_Stop_Id%TYPE,
60: Default_Stage_Subinventory wsh_picking_batches.Default_Stage_Subinventory%TYPE,
61: Default_Stage_Locator_Id wsh_picking_batches.Default_Stage_Locator_Id%TYPE,
62: Pick_From_Subinventory wsh_picking_batches.Pick_From_Subinventory%TYPE,
55: Attribute15 wsh_picking_batches.Attribute15%TYPE,
56: Autodetail_Pr_Flag wsh_picking_batches.Autodetail_Pr_Flag%TYPE,
57: -- Bug#: 3266659 - Removing carrier params
58: -- Carrier_Id wsh_picking_batches.Carrier_Id%TYPE,
59: Trip_Stop_Id wsh_picking_batches.Trip_Stop_Id%TYPE,
60: Default_Stage_Subinventory wsh_picking_batches.Default_Stage_Subinventory%TYPE,
61: Default_Stage_Locator_Id wsh_picking_batches.Default_Stage_Locator_Id%TYPE,
62: Pick_From_Subinventory wsh_picking_batches.Pick_From_Subinventory%TYPE,
63: Pick_From_locator_Id wsh_picking_batches.Pick_From_locator_Id%TYPE,
56: Autodetail_Pr_Flag wsh_picking_batches.Autodetail_Pr_Flag%TYPE,
57: -- Bug#: 3266659 - Removing carrier params
58: -- Carrier_Id wsh_picking_batches.Carrier_Id%TYPE,
59: Trip_Stop_Id wsh_picking_batches.Trip_Stop_Id%TYPE,
60: Default_Stage_Subinventory wsh_picking_batches.Default_Stage_Subinventory%TYPE,
61: Default_Stage_Locator_Id wsh_picking_batches.Default_Stage_Locator_Id%TYPE,
62: Pick_From_Subinventory wsh_picking_batches.Pick_From_Subinventory%TYPE,
63: Pick_From_locator_Id wsh_picking_batches.Pick_From_locator_Id%TYPE,
64: Auto_Pick_Confirm_Flag wsh_picking_batches.Auto_Pick_Confirm_Flag%TYPE,
57: -- Bug#: 3266659 - Removing carrier params
58: -- Carrier_Id wsh_picking_batches.Carrier_Id%TYPE,
59: Trip_Stop_Id wsh_picking_batches.Trip_Stop_Id%TYPE,
60: Default_Stage_Subinventory wsh_picking_batches.Default_Stage_Subinventory%TYPE,
61: Default_Stage_Locator_Id wsh_picking_batches.Default_Stage_Locator_Id%TYPE,
62: Pick_From_Subinventory wsh_picking_batches.Pick_From_Subinventory%TYPE,
63: Pick_From_locator_Id wsh_picking_batches.Pick_From_locator_Id%TYPE,
64: Auto_Pick_Confirm_Flag wsh_picking_batches.Auto_Pick_Confirm_Flag%TYPE,
65: Delivery_Detail_Id wsh_picking_batches.Delivery_Detail_Id%TYPE,
58: -- Carrier_Id wsh_picking_batches.Carrier_Id%TYPE,
59: Trip_Stop_Id wsh_picking_batches.Trip_Stop_Id%TYPE,
60: Default_Stage_Subinventory wsh_picking_batches.Default_Stage_Subinventory%TYPE,
61: Default_Stage_Locator_Id wsh_picking_batches.Default_Stage_Locator_Id%TYPE,
62: Pick_From_Subinventory wsh_picking_batches.Pick_From_Subinventory%TYPE,
63: Pick_From_locator_Id wsh_picking_batches.Pick_From_locator_Id%TYPE,
64: Auto_Pick_Confirm_Flag wsh_picking_batches.Auto_Pick_Confirm_Flag%TYPE,
65: Delivery_Detail_Id wsh_picking_batches.Delivery_Detail_Id%TYPE,
66: Project_Id wsh_picking_batches.Project_Id%TYPE,
59: Trip_Stop_Id wsh_picking_batches.Trip_Stop_Id%TYPE,
60: Default_Stage_Subinventory wsh_picking_batches.Default_Stage_Subinventory%TYPE,
61: Default_Stage_Locator_Id wsh_picking_batches.Default_Stage_Locator_Id%TYPE,
62: Pick_From_Subinventory wsh_picking_batches.Pick_From_Subinventory%TYPE,
63: Pick_From_locator_Id wsh_picking_batches.Pick_From_locator_Id%TYPE,
64: Auto_Pick_Confirm_Flag wsh_picking_batches.Auto_Pick_Confirm_Flag%TYPE,
65: Delivery_Detail_Id wsh_picking_batches.Delivery_Detail_Id%TYPE,
66: Project_Id wsh_picking_batches.Project_Id%TYPE,
67: Task_Id wsh_picking_batches.Task_Id%TYPE,
60: Default_Stage_Subinventory wsh_picking_batches.Default_Stage_Subinventory%TYPE,
61: Default_Stage_Locator_Id wsh_picking_batches.Default_Stage_Locator_Id%TYPE,
62: Pick_From_Subinventory wsh_picking_batches.Pick_From_Subinventory%TYPE,
63: Pick_From_locator_Id wsh_picking_batches.Pick_From_locator_Id%TYPE,
64: Auto_Pick_Confirm_Flag wsh_picking_batches.Auto_Pick_Confirm_Flag%TYPE,
65: Delivery_Detail_Id wsh_picking_batches.Delivery_Detail_Id%TYPE,
66: Project_Id wsh_picking_batches.Project_Id%TYPE,
67: Task_Id wsh_picking_batches.Task_Id%TYPE,
68: Organization_Id wsh_picking_batches.Organization_Id%TYPE,
61: Default_Stage_Locator_Id wsh_picking_batches.Default_Stage_Locator_Id%TYPE,
62: Pick_From_Subinventory wsh_picking_batches.Pick_From_Subinventory%TYPE,
63: Pick_From_locator_Id wsh_picking_batches.Pick_From_locator_Id%TYPE,
64: Auto_Pick_Confirm_Flag wsh_picking_batches.Auto_Pick_Confirm_Flag%TYPE,
65: Delivery_Detail_Id wsh_picking_batches.Delivery_Detail_Id%TYPE,
66: Project_Id wsh_picking_batches.Project_Id%TYPE,
67: Task_Id wsh_picking_batches.Task_Id%TYPE,
68: Organization_Id wsh_picking_batches.Organization_Id%TYPE,
69: Ship_Confirm_Rule_Id wsh_picking_batches.Ship_Confirm_Rule_Id%TYPE,
62: Pick_From_Subinventory wsh_picking_batches.Pick_From_Subinventory%TYPE,
63: Pick_From_locator_Id wsh_picking_batches.Pick_From_locator_Id%TYPE,
64: Auto_Pick_Confirm_Flag wsh_picking_batches.Auto_Pick_Confirm_Flag%TYPE,
65: Delivery_Detail_Id wsh_picking_batches.Delivery_Detail_Id%TYPE,
66: Project_Id wsh_picking_batches.Project_Id%TYPE,
67: Task_Id wsh_picking_batches.Task_Id%TYPE,
68: Organization_Id wsh_picking_batches.Organization_Id%TYPE,
69: Ship_Confirm_Rule_Id wsh_picking_batches.Ship_Confirm_Rule_Id%TYPE,
70: Autopack_Flag wsh_picking_batches.Autopack_Flag%TYPE,
63: Pick_From_locator_Id wsh_picking_batches.Pick_From_locator_Id%TYPE,
64: Auto_Pick_Confirm_Flag wsh_picking_batches.Auto_Pick_Confirm_Flag%TYPE,
65: Delivery_Detail_Id wsh_picking_batches.Delivery_Detail_Id%TYPE,
66: Project_Id wsh_picking_batches.Project_Id%TYPE,
67: Task_Id wsh_picking_batches.Task_Id%TYPE,
68: Organization_Id wsh_picking_batches.Organization_Id%TYPE,
69: Ship_Confirm_Rule_Id wsh_picking_batches.Ship_Confirm_Rule_Id%TYPE,
70: Autopack_Flag wsh_picking_batches.Autopack_Flag%TYPE,
71: Autopack_Level wsh_picking_batches.Autopack_Level%TYPE,
64: Auto_Pick_Confirm_Flag wsh_picking_batches.Auto_Pick_Confirm_Flag%TYPE,
65: Delivery_Detail_Id wsh_picking_batches.Delivery_Detail_Id%TYPE,
66: Project_Id wsh_picking_batches.Project_Id%TYPE,
67: Task_Id wsh_picking_batches.Task_Id%TYPE,
68: Organization_Id wsh_picking_batches.Organization_Id%TYPE,
69: Ship_Confirm_Rule_Id wsh_picking_batches.Ship_Confirm_Rule_Id%TYPE,
70: Autopack_Flag wsh_picking_batches.Autopack_Flag%TYPE,
71: Autopack_Level wsh_picking_batches.Autopack_Level%TYPE,
72: Task_Planning_Flag wsh_picking_batches.Task_Planning_Flag%TYPE,
65: Delivery_Detail_Id wsh_picking_batches.Delivery_Detail_Id%TYPE,
66: Project_Id wsh_picking_batches.Project_Id%TYPE,
67: Task_Id wsh_picking_batches.Task_Id%TYPE,
68: Organization_Id wsh_picking_batches.Organization_Id%TYPE,
69: Ship_Confirm_Rule_Id wsh_picking_batches.Ship_Confirm_Rule_Id%TYPE,
70: Autopack_Flag wsh_picking_batches.Autopack_Flag%TYPE,
71: Autopack_Level wsh_picking_batches.Autopack_Level%TYPE,
72: Task_Planning_Flag wsh_picking_batches.Task_Planning_Flag%TYPE,
73: -- Bug#: 3266659 - Removing carrier params
66: Project_Id wsh_picking_batches.Project_Id%TYPE,
67: Task_Id wsh_picking_batches.Task_Id%TYPE,
68: Organization_Id wsh_picking_batches.Organization_Id%TYPE,
69: Ship_Confirm_Rule_Id wsh_picking_batches.Ship_Confirm_Rule_Id%TYPE,
70: Autopack_Flag wsh_picking_batches.Autopack_Flag%TYPE,
71: Autopack_Level wsh_picking_batches.Autopack_Level%TYPE,
72: Task_Planning_Flag wsh_picking_batches.Task_Planning_Flag%TYPE,
73: -- Bug#: 3266659 - Removing carrier params
74: -- Non_Picking_Flag wsh_picking_batches.Non_Picking_Flag%TYPE,
67: Task_Id wsh_picking_batches.Task_Id%TYPE,
68: Organization_Id wsh_picking_batches.Organization_Id%TYPE,
69: Ship_Confirm_Rule_Id wsh_picking_batches.Ship_Confirm_Rule_Id%TYPE,
70: Autopack_Flag wsh_picking_batches.Autopack_Flag%TYPE,
71: Autopack_Level wsh_picking_batches.Autopack_Level%TYPE,
72: Task_Planning_Flag wsh_picking_batches.Task_Planning_Flag%TYPE,
73: -- Bug#: 3266659 - Removing carrier params
74: -- Non_Picking_Flag wsh_picking_batches.Non_Picking_Flag%TYPE,
75: category_set_id wsh_picking_batches.category_set_id%TYPE,
68: Organization_Id wsh_picking_batches.Organization_Id%TYPE,
69: Ship_Confirm_Rule_Id wsh_picking_batches.Ship_Confirm_Rule_Id%TYPE,
70: Autopack_Flag wsh_picking_batches.Autopack_Flag%TYPE,
71: Autopack_Level wsh_picking_batches.Autopack_Level%TYPE,
72: Task_Planning_Flag wsh_picking_batches.Task_Planning_Flag%TYPE,
73: -- Bug#: 3266659 - Removing carrier params
74: -- Non_Picking_Flag wsh_picking_batches.Non_Picking_Flag%TYPE,
75: category_set_id wsh_picking_batches.category_set_id%TYPE,
76: category_id wsh_picking_batches.category_id%TYPE,
70: Autopack_Flag wsh_picking_batches.Autopack_Flag%TYPE,
71: Autopack_Level wsh_picking_batches.Autopack_Level%TYPE,
72: Task_Planning_Flag wsh_picking_batches.Task_Planning_Flag%TYPE,
73: -- Bug#: 3266659 - Removing carrier params
74: -- Non_Picking_Flag wsh_picking_batches.Non_Picking_Flag%TYPE,
75: category_set_id wsh_picking_batches.category_set_id%TYPE,
76: category_id wsh_picking_batches.category_id%TYPE,
77: ship_set_smc_flag wsh_picking_batches.ship_set_smc_flag%TYPE,
78: -- Bug#: 3266659 - Adding the columns like zone, region, delivery criteria, release
71: Autopack_Level wsh_picking_batches.Autopack_Level%TYPE,
72: Task_Planning_Flag wsh_picking_batches.Task_Planning_Flag%TYPE,
73: -- Bug#: 3266659 - Removing carrier params
74: -- Non_Picking_Flag wsh_picking_batches.Non_Picking_Flag%TYPE,
75: category_set_id wsh_picking_batches.category_set_id%TYPE,
76: category_id wsh_picking_batches.category_id%TYPE,
77: ship_set_smc_flag wsh_picking_batches.ship_set_smc_flag%TYPE,
78: -- Bug#: 3266659 - Adding the columns like zone, region, delivery criteria, release
79: -- subinventory and append flag
72: Task_Planning_Flag wsh_picking_batches.Task_Planning_Flag%TYPE,
73: -- Bug#: 3266659 - Removing carrier params
74: -- Non_Picking_Flag wsh_picking_batches.Non_Picking_Flag%TYPE,
75: category_set_id wsh_picking_batches.category_set_id%TYPE,
76: category_id wsh_picking_batches.category_id%TYPE,
77: ship_set_smc_flag wsh_picking_batches.ship_set_smc_flag%TYPE,
78: -- Bug#: 3266659 - Adding the columns like zone, region, delivery criteria, release
79: -- subinventory and append flag
80: region_ID wsh_picking_batches.region_id%TYPE,
73: -- Bug#: 3266659 - Removing carrier params
74: -- Non_Picking_Flag wsh_picking_batches.Non_Picking_Flag%TYPE,
75: category_set_id wsh_picking_batches.category_set_id%TYPE,
76: category_id wsh_picking_batches.category_id%TYPE,
77: ship_set_smc_flag wsh_picking_batches.ship_set_smc_flag%TYPE,
78: -- Bug#: 3266659 - Adding the columns like zone, region, delivery criteria, release
79: -- subinventory and append flag
80: region_ID wsh_picking_batches.region_id%TYPE,
81: zone_ID wsh_picking_batches.zone_id%TYPE,
76: category_id wsh_picking_batches.category_id%TYPE,
77: ship_set_smc_flag wsh_picking_batches.ship_set_smc_flag%TYPE,
78: -- Bug#: 3266659 - Adding the columns like zone, region, delivery criteria, release
79: -- subinventory and append flag
80: region_ID wsh_picking_batches.region_id%TYPE,
81: zone_ID wsh_picking_batches.zone_id%TYPE,
82: ac_Delivery_Criteria wsh_picking_batches.ac_delivery_criteria%TYPE,
83: rel_subinventory wsh_picking_batches.rel_subinventory%TYPE,
84: append_flag wsh_picking_batches.append_flag%TYPE,
77: ship_set_smc_flag wsh_picking_batches.ship_set_smc_flag%TYPE,
78: -- Bug#: 3266659 - Adding the columns like zone, region, delivery criteria, release
79: -- subinventory and append flag
80: region_ID wsh_picking_batches.region_id%TYPE,
81: zone_ID wsh_picking_batches.zone_id%TYPE,
82: ac_Delivery_Criteria wsh_picking_batches.ac_delivery_criteria%TYPE,
83: rel_subinventory wsh_picking_batches.rel_subinventory%TYPE,
84: append_flag wsh_picking_batches.append_flag%TYPE,
85: task_priority wsh_picking_batches.task_priority%TYPE,
78: -- Bug#: 3266659 - Adding the columns like zone, region, delivery criteria, release
79: -- subinventory and append flag
80: region_ID wsh_picking_batches.region_id%TYPE,
81: zone_ID wsh_picking_batches.zone_id%TYPE,
82: ac_Delivery_Criteria wsh_picking_batches.ac_delivery_criteria%TYPE,
83: rel_subinventory wsh_picking_batches.rel_subinventory%TYPE,
84: append_flag wsh_picking_batches.append_flag%TYPE,
85: task_priority wsh_picking_batches.task_priority%TYPE,
86: actual_departure_date WSH_PICKING_BATCHES.ACTUAL_DEPARTURE_DATE%TYPE,
79: -- subinventory and append flag
80: region_ID wsh_picking_batches.region_id%TYPE,
81: zone_ID wsh_picking_batches.zone_id%TYPE,
82: ac_Delivery_Criteria wsh_picking_batches.ac_delivery_criteria%TYPE,
83: rel_subinventory wsh_picking_batches.rel_subinventory%TYPE,
84: append_flag wsh_picking_batches.append_flag%TYPE,
85: task_priority wsh_picking_batches.task_priority%TYPE,
86: actual_departure_date WSH_PICKING_BATCHES.ACTUAL_DEPARTURE_DATE%TYPE,
87: allocation_method WSH_PICKING_BATCHES.ALLOCATION_METHOD%TYPE, --anxsharm, X-dock
80: region_ID wsh_picking_batches.region_id%TYPE,
81: zone_ID wsh_picking_batches.zone_id%TYPE,
82: ac_Delivery_Criteria wsh_picking_batches.ac_delivery_criteria%TYPE,
83: rel_subinventory wsh_picking_batches.rel_subinventory%TYPE,
84: append_flag wsh_picking_batches.append_flag%TYPE,
85: task_priority wsh_picking_batches.task_priority%TYPE,
86: actual_departure_date WSH_PICKING_BATCHES.ACTUAL_DEPARTURE_DATE%TYPE,
87: allocation_method WSH_PICKING_BATCHES.ALLOCATION_METHOD%TYPE, --anxsharm, X-dock
88: crossdock_criteria_id WSH_PICKING_BATCHES.CROSSDOCK_CRITERIA_ID%TYPE, -- anxsharm, X-dock
81: zone_ID wsh_picking_batches.zone_id%TYPE,
82: ac_Delivery_Criteria wsh_picking_batches.ac_delivery_criteria%TYPE,
83: rel_subinventory wsh_picking_batches.rel_subinventory%TYPE,
84: append_flag wsh_picking_batches.append_flag%TYPE,
85: task_priority wsh_picking_batches.task_priority%TYPE,
86: actual_departure_date WSH_PICKING_BATCHES.ACTUAL_DEPARTURE_DATE%TYPE,
87: allocation_method WSH_PICKING_BATCHES.ALLOCATION_METHOD%TYPE, --anxsharm, X-dock
88: crossdock_criteria_id WSH_PICKING_BATCHES.CROSSDOCK_CRITERIA_ID%TYPE, -- anxsharm, X-dock
89: dynamic_replenishment_flag WSH_PICKING_BATCHES.dynamic_replenishment_flag%TYPE ----bug# 6689448 (replenishment project)
82: ac_Delivery_Criteria wsh_picking_batches.ac_delivery_criteria%TYPE,
83: rel_subinventory wsh_picking_batches.rel_subinventory%TYPE,
84: append_flag wsh_picking_batches.append_flag%TYPE,
85: task_priority wsh_picking_batches.task_priority%TYPE,
86: actual_departure_date WSH_PICKING_BATCHES.ACTUAL_DEPARTURE_DATE%TYPE,
87: allocation_method WSH_PICKING_BATCHES.ALLOCATION_METHOD%TYPE, --anxsharm, X-dock
88: crossdock_criteria_id WSH_PICKING_BATCHES.CROSSDOCK_CRITERIA_ID%TYPE, -- anxsharm, X-dock
89: dynamic_replenishment_flag WSH_PICKING_BATCHES.dynamic_replenishment_flag%TYPE ----bug# 6689448 (replenishment project)
90: );
83: rel_subinventory wsh_picking_batches.rel_subinventory%TYPE,
84: append_flag wsh_picking_batches.append_flag%TYPE,
85: task_priority wsh_picking_batches.task_priority%TYPE,
86: actual_departure_date WSH_PICKING_BATCHES.ACTUAL_DEPARTURE_DATE%TYPE,
87: allocation_method WSH_PICKING_BATCHES.ALLOCATION_METHOD%TYPE, --anxsharm, X-dock
88: crossdock_criteria_id WSH_PICKING_BATCHES.CROSSDOCK_CRITERIA_ID%TYPE, -- anxsharm, X-dock
89: dynamic_replenishment_flag WSH_PICKING_BATCHES.dynamic_replenishment_flag%TYPE ----bug# 6689448 (replenishment project)
90: );
91: --
84: append_flag wsh_picking_batches.append_flag%TYPE,
85: task_priority wsh_picking_batches.task_priority%TYPE,
86: actual_departure_date WSH_PICKING_BATCHES.ACTUAL_DEPARTURE_DATE%TYPE,
87: allocation_method WSH_PICKING_BATCHES.ALLOCATION_METHOD%TYPE, --anxsharm, X-dock
88: crossdock_criteria_id WSH_PICKING_BATCHES.CROSSDOCK_CRITERIA_ID%TYPE, -- anxsharm, X-dock
89: dynamic_replenishment_flag WSH_PICKING_BATCHES.dynamic_replenishment_flag%TYPE ----bug# 6689448 (replenishment project)
90: );
91: --
92: --
85: task_priority wsh_picking_batches.task_priority%TYPE,
86: actual_departure_date WSH_PICKING_BATCHES.ACTUAL_DEPARTURE_DATE%TYPE,
87: allocation_method WSH_PICKING_BATCHES.ALLOCATION_METHOD%TYPE, --anxsharm, X-dock
88: crossdock_criteria_id WSH_PICKING_BATCHES.CROSSDOCK_CRITERIA_ID%TYPE, -- anxsharm, X-dock
89: dynamic_replenishment_flag WSH_PICKING_BATCHES.dynamic_replenishment_flag%TYPE ----bug# 6689448 (replenishment project)
90: );
91: --
92: --
93: --===================
99: --
100: -- API Name : Create_Batch
101: -- Type : Group
102: -- Pre-reqs : None.
103: -- Function : This API is called from WSH_PICKING_BATCHES_PUB
104: -- to validate all the parameters and create the Picking Batch
105: --
106: -- PARAMETERS : p_api_version_number known api versionerror buffer
107: -- p_init_msg_list FND_API.G_TRUE to reset list
128: x_msg_count OUT NOCOPY NUMBER,
129: x_msg_data OUT NOCOPY VARCHAR2,
130: p_rule_id IN NUMBER DEFAULT NULL,
131: p_rule_name IN VARCHAR2 DEFAULT NULL,
132: p_batch_rec IN WSH_PICKING_BATCHES_PUB.Batch_Info_Rec,
133: p_batch_prefix IN VARCHAR2 DEFAULT NULL,
134: x_batch_id OUT NOCOPY NUMBER
135: );
136:
154: -- x_return_status return status
155: -- x_msg_count number of messages in the list
156: -- x_msg_data text of messages
157: -- p_batch_id Picking Batch Id which is used to get Batch
158: -- information from the wsh_picking_batches table.
159: -- p_batch_name Picking Batch Name which is used to get Batch
160: -- information from the wsh_picking_batches table.
161: -- p_log_level Controlls the log message generated by cuncurrent
162: -- pick release process.
156: -- x_msg_data text of messages
157: -- p_batch_id Picking Batch Id which is used to get Batch
158: -- information from the wsh_picking_batches table.
159: -- p_batch_name Picking Batch Name which is used to get Batch
160: -- information from the wsh_picking_batches table.
161: -- p_log_level Controlls the log message generated by cuncurrent
162: -- pick release process.
163: -- p_release_mode Used to do ONLINE or CONCURRENT pick release,
164: -- Default is "CONCURREN"
190: p_num_workers IN NUMBER DEFAULT 1,
191: x_request_id OUT NOCOPY NUMBER
192: );
193:
194: END WSH_PICKING_BATCHES_GRP;