1: PACKAGE WSH_PICKING_BATCHES_PUB AS
2: -- $Header: WSHPRPBS.pls 120.3 2007/12/21 14:24:46 mvudugul ship $
3: /*#
4: * This is the public interface for picking batches. This package
5: * has procedures for creating and releasing picking batches.
9: * @rep:lifecycle active
10: * @rep:category BUSINESS_ENTITY WSH_DELIVERY_LINE
11: * @rep:category BUSINESS_ENTITY WSH_DELIVERY
12: * @rep:category BUSINESS_ENTITY WSH_TRIP
13: * @rep:category BUSINESS_ENTITY WSH_PICKING_BATCHES_PUB
14: */
15: --
16: --===================
17: -- PUBLIC VARS
18: --===================
19: --
20: --
21: TYPE Batch_Info_rec IS Record (
22: Backorders_Only_Flag wsh_picking_batches.Backorders_Only_Flag%TYPE,
23: Document_Set_Id wsh_picking_batches.Document_Set_Id%TYPE,
24: Document_Set_Name wsh_report_sets.name%TYPE,
25: Existing_Rsvs_Only_Flag wsh_picking_batches.Existing_Rsvs_Only_Flag%TYPE,
26: Shipment_Priority_Code wsh_picking_batches.Shipment_Priority_Code%TYPE,
19: --
20: --
21: TYPE Batch_Info_rec IS Record (
22: Backorders_Only_Flag wsh_picking_batches.Backorders_Only_Flag%TYPE,
23: Document_Set_Id wsh_picking_batches.Document_Set_Id%TYPE,
24: Document_Set_Name wsh_report_sets.name%TYPE,
25: Existing_Rsvs_Only_Flag wsh_picking_batches.Existing_Rsvs_Only_Flag%TYPE,
26: Shipment_Priority_Code wsh_picking_batches.Shipment_Priority_Code%TYPE,
27: Ship_Method_Code wsh_picking_batches.Ship_Method_Code%TYPE,
21: TYPE Batch_Info_rec IS Record (
22: Backorders_Only_Flag wsh_picking_batches.Backorders_Only_Flag%TYPE,
23: Document_Set_Id wsh_picking_batches.Document_Set_Id%TYPE,
24: Document_Set_Name wsh_report_sets.name%TYPE,
25: Existing_Rsvs_Only_Flag wsh_picking_batches.Existing_Rsvs_Only_Flag%TYPE,
26: Shipment_Priority_Code wsh_picking_batches.Shipment_Priority_Code%TYPE,
27: Ship_Method_Code wsh_picking_batches.Ship_Method_Code%TYPE,
28: Ship_Method_Name fnd_lookup_values_vl.meaning%TYPE,
29: Customer_Id wsh_picking_batches.Customer_Id%TYPE,
22: Backorders_Only_Flag wsh_picking_batches.Backorders_Only_Flag%TYPE,
23: Document_Set_Id wsh_picking_batches.Document_Set_Id%TYPE,
24: Document_Set_Name wsh_report_sets.name%TYPE,
25: Existing_Rsvs_Only_Flag wsh_picking_batches.Existing_Rsvs_Only_Flag%TYPE,
26: Shipment_Priority_Code wsh_picking_batches.Shipment_Priority_Code%TYPE,
27: Ship_Method_Code wsh_picking_batches.Ship_Method_Code%TYPE,
28: Ship_Method_Name fnd_lookup_values_vl.meaning%TYPE,
29: Customer_Id wsh_picking_batches.Customer_Id%TYPE,
30: --TCA view removal Changes Starts
23: Document_Set_Id wsh_picking_batches.Document_Set_Id%TYPE,
24: Document_Set_Name wsh_report_sets.name%TYPE,
25: Existing_Rsvs_Only_Flag wsh_picking_batches.Existing_Rsvs_Only_Flag%TYPE,
26: Shipment_Priority_Code wsh_picking_batches.Shipment_Priority_Code%TYPE,
27: Ship_Method_Code wsh_picking_batches.Ship_Method_Code%TYPE,
28: Ship_Method_Name fnd_lookup_values_vl.meaning%TYPE,
29: Customer_Id wsh_picking_batches.Customer_Id%TYPE,
30: --TCA view removal Changes Starts
31: Customer_Number hz_cust_accounts.account_number%TYPE, /*Customer Number*/
25: Existing_Rsvs_Only_Flag wsh_picking_batches.Existing_Rsvs_Only_Flag%TYPE,
26: Shipment_Priority_Code wsh_picking_batches.Shipment_Priority_Code%TYPE,
27: Ship_Method_Code wsh_picking_batches.Ship_Method_Code%TYPE,
28: Ship_Method_Name fnd_lookup_values_vl.meaning%TYPE,
29: Customer_Id wsh_picking_batches.Customer_Id%TYPE,
30: --TCA view removal Changes Starts
31: Customer_Number hz_cust_accounts.account_number%TYPE, /*Customer Number*/
32: --TCA view removal Changes End
33: Order_Header_Id wsh_picking_batches.Order_Header_Id%TYPE,
29: Customer_Id wsh_picking_batches.Customer_Id%TYPE,
30: --TCA view removal Changes Starts
31: Customer_Number hz_cust_accounts.account_number%TYPE, /*Customer Number*/
32: --TCA view removal Changes End
33: Order_Header_Id wsh_picking_batches.Order_Header_Id%TYPE,
34: Order_Number oe_order_headers_all.Order_Number%TYPE,
35: Ship_Set_Id wsh_picking_batches.Ship_Set_Number%TYPE,
36: Ship_Set_Number oe_sets.set_name%TYPE,
37: Inventory_Item_Id wsh_picking_batches.Inventory_Item_Id%TYPE,
31: Customer_Number hz_cust_accounts.account_number%TYPE, /*Customer Number*/
32: --TCA view removal Changes End
33: Order_Header_Id wsh_picking_batches.Order_Header_Id%TYPE,
34: Order_Number oe_order_headers_all.Order_Number%TYPE,
35: Ship_Set_Id wsh_picking_batches.Ship_Set_Number%TYPE,
36: Ship_Set_Number oe_sets.set_name%TYPE,
37: Inventory_Item_Id wsh_picking_batches.Inventory_Item_Id%TYPE,
38: Order_Type_Id wsh_picking_batches.Order_Type_Id%TYPE,
39: Order_Type_Name oe_transaction_types_tl.name%TYPE,
33: Order_Header_Id wsh_picking_batches.Order_Header_Id%TYPE,
34: Order_Number oe_order_headers_all.Order_Number%TYPE,
35: Ship_Set_Id wsh_picking_batches.Ship_Set_Number%TYPE,
36: Ship_Set_Number oe_sets.set_name%TYPE,
37: Inventory_Item_Id wsh_picking_batches.Inventory_Item_Id%TYPE,
38: Order_Type_Id wsh_picking_batches.Order_Type_Id%TYPE,
39: Order_Type_Name oe_transaction_types_tl.name%TYPE,
40: From_Requested_Date DATE,
41: To_Requested_Date DATE,
34: Order_Number oe_order_headers_all.Order_Number%TYPE,
35: Ship_Set_Id wsh_picking_batches.Ship_Set_Number%TYPE,
36: Ship_Set_Number oe_sets.set_name%TYPE,
37: Inventory_Item_Id wsh_picking_batches.Inventory_Item_Id%TYPE,
38: Order_Type_Id wsh_picking_batches.Order_Type_Id%TYPE,
39: Order_Type_Name oe_transaction_types_tl.name%TYPE,
40: From_Requested_Date DATE,
41: To_Requested_Date DATE,
42: From_Scheduled_Ship_Date DATE,
40: From_Requested_Date DATE,
41: To_Requested_Date DATE,
42: From_Scheduled_Ship_Date DATE,
43: To_Scheduled_Ship_Date DATE,
44: Ship_To_Location_Id wsh_picking_batches.Ship_To_Location_Id%TYPE,
45: Ship_To_Location_code hr_locations_all_tl.location_code%TYPE,
46: Ship_From_Location_Id wsh_picking_batches.Ship_From_Location_Id%TYPE,
47: Ship_From_Location_code hr_locations_all_tl.location_code%TYPE,
48: Trip_Id wsh_picking_batches.Trip_Id%TYPE,
42: From_Scheduled_Ship_Date DATE,
43: To_Scheduled_Ship_Date DATE,
44: Ship_To_Location_Id wsh_picking_batches.Ship_To_Location_Id%TYPE,
45: Ship_To_Location_code hr_locations_all_tl.location_code%TYPE,
46: Ship_From_Location_Id wsh_picking_batches.Ship_From_Location_Id%TYPE,
47: Ship_From_Location_code hr_locations_all_tl.location_code%TYPE,
48: Trip_Id wsh_picking_batches.Trip_Id%TYPE,
49: Trip_Name wsh_trips.name%TYPE,
50: Delivery_Id wsh_picking_batches.Delivery_Id%TYPE,
44: Ship_To_Location_Id wsh_picking_batches.Ship_To_Location_Id%TYPE,
45: Ship_To_Location_code hr_locations_all_tl.location_code%TYPE,
46: Ship_From_Location_Id wsh_picking_batches.Ship_From_Location_Id%TYPE,
47: Ship_From_Location_code hr_locations_all_tl.location_code%TYPE,
48: Trip_Id wsh_picking_batches.Trip_Id%TYPE,
49: Trip_Name wsh_trips.name%TYPE,
50: Delivery_Id wsh_picking_batches.Delivery_Id%TYPE,
51: Delivery_Name wsh_new_deliveries.name%TYPE,
52: Include_Planned_Lines wsh_picking_batches.Include_Planned_Lines%TYPE,
46: Ship_From_Location_Id wsh_picking_batches.Ship_From_Location_Id%TYPE,
47: Ship_From_Location_code hr_locations_all_tl.location_code%TYPE,
48: Trip_Id wsh_picking_batches.Trip_Id%TYPE,
49: Trip_Name wsh_trips.name%TYPE,
50: Delivery_Id wsh_picking_batches.Delivery_Id%TYPE,
51: Delivery_Name wsh_new_deliveries.name%TYPE,
52: Include_Planned_Lines wsh_picking_batches.Include_Planned_Lines%TYPE,
53: Pick_Grouping_Rule_Id wsh_picking_batches.Pick_Grouping_Rule_Id%TYPE,
54: Pick_Grouping_Rule_Name wsh_pick_grouping_rules.name%TYPE,
48: Trip_Id wsh_picking_batches.Trip_Id%TYPE,
49: Trip_Name wsh_trips.name%TYPE,
50: Delivery_Id wsh_picking_batches.Delivery_Id%TYPE,
51: Delivery_Name wsh_new_deliveries.name%TYPE,
52: Include_Planned_Lines wsh_picking_batches.Include_Planned_Lines%TYPE,
53: Pick_Grouping_Rule_Id wsh_picking_batches.Pick_Grouping_Rule_Id%TYPE,
54: Pick_Grouping_Rule_Name wsh_pick_grouping_rules.name%TYPE,
55: Pick_Sequence_Rule_Id wsh_picking_batches.Pick_Sequence_Rule_Id%TYPE,
56: Pick_Sequence_Rule_Name wsh_pick_sequence_rules.name%TYPE,
49: Trip_Name wsh_trips.name%TYPE,
50: Delivery_Id wsh_picking_batches.Delivery_Id%TYPE,
51: Delivery_Name wsh_new_deliveries.name%TYPE,
52: Include_Planned_Lines wsh_picking_batches.Include_Planned_Lines%TYPE,
53: Pick_Grouping_Rule_Id wsh_picking_batches.Pick_Grouping_Rule_Id%TYPE,
54: Pick_Grouping_Rule_Name wsh_pick_grouping_rules.name%TYPE,
55: Pick_Sequence_Rule_Id wsh_picking_batches.Pick_Sequence_Rule_Id%TYPE,
56: Pick_Sequence_Rule_Name wsh_pick_sequence_rules.name%TYPE,
57: Autocreate_Delivery_Flag wsh_picking_batches.Autocreate_Delivery_Flag%TYPE,
51: Delivery_Name wsh_new_deliveries.name%TYPE,
52: Include_Planned_Lines wsh_picking_batches.Include_Planned_Lines%TYPE,
53: Pick_Grouping_Rule_Id wsh_picking_batches.Pick_Grouping_Rule_Id%TYPE,
54: Pick_Grouping_Rule_Name wsh_pick_grouping_rules.name%TYPE,
55: Pick_Sequence_Rule_Id wsh_picking_batches.Pick_Sequence_Rule_Id%TYPE,
56: Pick_Sequence_Rule_Name wsh_pick_sequence_rules.name%TYPE,
57: Autocreate_Delivery_Flag wsh_picking_batches.Autocreate_Delivery_Flag%TYPE,
58: Attribute_Category wsh_picking_batches.Attribute_Category%TYPE,
59: Attribute1 wsh_picking_batches.Attribute1%TYPE,
53: Pick_Grouping_Rule_Id wsh_picking_batches.Pick_Grouping_Rule_Id%TYPE,
54: Pick_Grouping_Rule_Name wsh_pick_grouping_rules.name%TYPE,
55: Pick_Sequence_Rule_Id wsh_picking_batches.Pick_Sequence_Rule_Id%TYPE,
56: Pick_Sequence_Rule_Name wsh_pick_sequence_rules.name%TYPE,
57: Autocreate_Delivery_Flag wsh_picking_batches.Autocreate_Delivery_Flag%TYPE,
58: Attribute_Category wsh_picking_batches.Attribute_Category%TYPE,
59: Attribute1 wsh_picking_batches.Attribute1%TYPE,
60: Attribute2 wsh_picking_batches.Attribute2%TYPE,
61: Attribute3 wsh_picking_batches.Attribute3%TYPE,
54: Pick_Grouping_Rule_Name wsh_pick_grouping_rules.name%TYPE,
55: Pick_Sequence_Rule_Id wsh_picking_batches.Pick_Sequence_Rule_Id%TYPE,
56: Pick_Sequence_Rule_Name wsh_pick_sequence_rules.name%TYPE,
57: Autocreate_Delivery_Flag wsh_picking_batches.Autocreate_Delivery_Flag%TYPE,
58: Attribute_Category wsh_picking_batches.Attribute_Category%TYPE,
59: Attribute1 wsh_picking_batches.Attribute1%TYPE,
60: Attribute2 wsh_picking_batches.Attribute2%TYPE,
61: Attribute3 wsh_picking_batches.Attribute3%TYPE,
62: Attribute4 wsh_picking_batches.Attribute4%TYPE,
55: Pick_Sequence_Rule_Id wsh_picking_batches.Pick_Sequence_Rule_Id%TYPE,
56: Pick_Sequence_Rule_Name wsh_pick_sequence_rules.name%TYPE,
57: Autocreate_Delivery_Flag wsh_picking_batches.Autocreate_Delivery_Flag%TYPE,
58: Attribute_Category wsh_picking_batches.Attribute_Category%TYPE,
59: Attribute1 wsh_picking_batches.Attribute1%TYPE,
60: Attribute2 wsh_picking_batches.Attribute2%TYPE,
61: Attribute3 wsh_picking_batches.Attribute3%TYPE,
62: Attribute4 wsh_picking_batches.Attribute4%TYPE,
63: Attribute5 wsh_picking_batches.Attribute5%TYPE,
56: Pick_Sequence_Rule_Name wsh_pick_sequence_rules.name%TYPE,
57: Autocreate_Delivery_Flag wsh_picking_batches.Autocreate_Delivery_Flag%TYPE,
58: Attribute_Category wsh_picking_batches.Attribute_Category%TYPE,
59: Attribute1 wsh_picking_batches.Attribute1%TYPE,
60: Attribute2 wsh_picking_batches.Attribute2%TYPE,
61: Attribute3 wsh_picking_batches.Attribute3%TYPE,
62: Attribute4 wsh_picking_batches.Attribute4%TYPE,
63: Attribute5 wsh_picking_batches.Attribute5%TYPE,
64: Attribute6 wsh_picking_batches.Attribute6%TYPE,
57: Autocreate_Delivery_Flag wsh_picking_batches.Autocreate_Delivery_Flag%TYPE,
58: Attribute_Category wsh_picking_batches.Attribute_Category%TYPE,
59: Attribute1 wsh_picking_batches.Attribute1%TYPE,
60: Attribute2 wsh_picking_batches.Attribute2%TYPE,
61: Attribute3 wsh_picking_batches.Attribute3%TYPE,
62: Attribute4 wsh_picking_batches.Attribute4%TYPE,
63: Attribute5 wsh_picking_batches.Attribute5%TYPE,
64: Attribute6 wsh_picking_batches.Attribute6%TYPE,
65: Attribute7 wsh_picking_batches.Attribute7%TYPE,
58: Attribute_Category wsh_picking_batches.Attribute_Category%TYPE,
59: Attribute1 wsh_picking_batches.Attribute1%TYPE,
60: Attribute2 wsh_picking_batches.Attribute2%TYPE,
61: Attribute3 wsh_picking_batches.Attribute3%TYPE,
62: Attribute4 wsh_picking_batches.Attribute4%TYPE,
63: Attribute5 wsh_picking_batches.Attribute5%TYPE,
64: Attribute6 wsh_picking_batches.Attribute6%TYPE,
65: Attribute7 wsh_picking_batches.Attribute7%TYPE,
66: Attribute8 wsh_picking_batches.Attribute8%TYPE,
59: Attribute1 wsh_picking_batches.Attribute1%TYPE,
60: Attribute2 wsh_picking_batches.Attribute2%TYPE,
61: Attribute3 wsh_picking_batches.Attribute3%TYPE,
62: Attribute4 wsh_picking_batches.Attribute4%TYPE,
63: Attribute5 wsh_picking_batches.Attribute5%TYPE,
64: Attribute6 wsh_picking_batches.Attribute6%TYPE,
65: Attribute7 wsh_picking_batches.Attribute7%TYPE,
66: Attribute8 wsh_picking_batches.Attribute8%TYPE,
67: Attribute9 wsh_picking_batches.Attribute9%TYPE,
60: Attribute2 wsh_picking_batches.Attribute2%TYPE,
61: Attribute3 wsh_picking_batches.Attribute3%TYPE,
62: Attribute4 wsh_picking_batches.Attribute4%TYPE,
63: Attribute5 wsh_picking_batches.Attribute5%TYPE,
64: Attribute6 wsh_picking_batches.Attribute6%TYPE,
65: Attribute7 wsh_picking_batches.Attribute7%TYPE,
66: Attribute8 wsh_picking_batches.Attribute8%TYPE,
67: Attribute9 wsh_picking_batches.Attribute9%TYPE,
68: Attribute10 wsh_picking_batches.Attribute10%TYPE,
61: Attribute3 wsh_picking_batches.Attribute3%TYPE,
62: Attribute4 wsh_picking_batches.Attribute4%TYPE,
63: Attribute5 wsh_picking_batches.Attribute5%TYPE,
64: Attribute6 wsh_picking_batches.Attribute6%TYPE,
65: Attribute7 wsh_picking_batches.Attribute7%TYPE,
66: Attribute8 wsh_picking_batches.Attribute8%TYPE,
67: Attribute9 wsh_picking_batches.Attribute9%TYPE,
68: Attribute10 wsh_picking_batches.Attribute10%TYPE,
69: Attribute11 wsh_picking_batches.Attribute11%TYPE,
62: Attribute4 wsh_picking_batches.Attribute4%TYPE,
63: Attribute5 wsh_picking_batches.Attribute5%TYPE,
64: Attribute6 wsh_picking_batches.Attribute6%TYPE,
65: Attribute7 wsh_picking_batches.Attribute7%TYPE,
66: Attribute8 wsh_picking_batches.Attribute8%TYPE,
67: Attribute9 wsh_picking_batches.Attribute9%TYPE,
68: Attribute10 wsh_picking_batches.Attribute10%TYPE,
69: Attribute11 wsh_picking_batches.Attribute11%TYPE,
70: Attribute12 wsh_picking_batches.Attribute12%TYPE,
63: Attribute5 wsh_picking_batches.Attribute5%TYPE,
64: Attribute6 wsh_picking_batches.Attribute6%TYPE,
65: Attribute7 wsh_picking_batches.Attribute7%TYPE,
66: Attribute8 wsh_picking_batches.Attribute8%TYPE,
67: Attribute9 wsh_picking_batches.Attribute9%TYPE,
68: Attribute10 wsh_picking_batches.Attribute10%TYPE,
69: Attribute11 wsh_picking_batches.Attribute11%TYPE,
70: Attribute12 wsh_picking_batches.Attribute12%TYPE,
71: Attribute13 wsh_picking_batches.Attribute13%TYPE,
64: Attribute6 wsh_picking_batches.Attribute6%TYPE,
65: Attribute7 wsh_picking_batches.Attribute7%TYPE,
66: Attribute8 wsh_picking_batches.Attribute8%TYPE,
67: Attribute9 wsh_picking_batches.Attribute9%TYPE,
68: Attribute10 wsh_picking_batches.Attribute10%TYPE,
69: Attribute11 wsh_picking_batches.Attribute11%TYPE,
70: Attribute12 wsh_picking_batches.Attribute12%TYPE,
71: Attribute13 wsh_picking_batches.Attribute13%TYPE,
72: Attribute14 wsh_picking_batches.Attribute14%TYPE,
65: Attribute7 wsh_picking_batches.Attribute7%TYPE,
66: Attribute8 wsh_picking_batches.Attribute8%TYPE,
67: Attribute9 wsh_picking_batches.Attribute9%TYPE,
68: Attribute10 wsh_picking_batches.Attribute10%TYPE,
69: Attribute11 wsh_picking_batches.Attribute11%TYPE,
70: Attribute12 wsh_picking_batches.Attribute12%TYPE,
71: Attribute13 wsh_picking_batches.Attribute13%TYPE,
72: Attribute14 wsh_picking_batches.Attribute14%TYPE,
73: Attribute15 wsh_picking_batches.Attribute15%TYPE,
66: Attribute8 wsh_picking_batches.Attribute8%TYPE,
67: Attribute9 wsh_picking_batches.Attribute9%TYPE,
68: Attribute10 wsh_picking_batches.Attribute10%TYPE,
69: Attribute11 wsh_picking_batches.Attribute11%TYPE,
70: Attribute12 wsh_picking_batches.Attribute12%TYPE,
71: Attribute13 wsh_picking_batches.Attribute13%TYPE,
72: Attribute14 wsh_picking_batches.Attribute14%TYPE,
73: Attribute15 wsh_picking_batches.Attribute15%TYPE,
74: Autodetail_Pr_Flag wsh_picking_batches.Autodetail_Pr_Flag%TYPE,
67: Attribute9 wsh_picking_batches.Attribute9%TYPE,
68: Attribute10 wsh_picking_batches.Attribute10%TYPE,
69: Attribute11 wsh_picking_batches.Attribute11%TYPE,
70: Attribute12 wsh_picking_batches.Attribute12%TYPE,
71: Attribute13 wsh_picking_batches.Attribute13%TYPE,
72: Attribute14 wsh_picking_batches.Attribute14%TYPE,
73: Attribute15 wsh_picking_batches.Attribute15%TYPE,
74: Autodetail_Pr_Flag wsh_picking_batches.Autodetail_Pr_Flag%TYPE,
75: -- Bug#: 3266659 - Removing carrier params
68: Attribute10 wsh_picking_batches.Attribute10%TYPE,
69: Attribute11 wsh_picking_batches.Attribute11%TYPE,
70: Attribute12 wsh_picking_batches.Attribute12%TYPE,
71: Attribute13 wsh_picking_batches.Attribute13%TYPE,
72: Attribute14 wsh_picking_batches.Attribute14%TYPE,
73: Attribute15 wsh_picking_batches.Attribute15%TYPE,
74: Autodetail_Pr_Flag wsh_picking_batches.Autodetail_Pr_Flag%TYPE,
75: -- Bug#: 3266659 - Removing carrier params
76: -- Carrier_Id wsh_picking_batches.Carrier_Id%TYPE,
69: Attribute11 wsh_picking_batches.Attribute11%TYPE,
70: Attribute12 wsh_picking_batches.Attribute12%TYPE,
71: Attribute13 wsh_picking_batches.Attribute13%TYPE,
72: Attribute14 wsh_picking_batches.Attribute14%TYPE,
73: Attribute15 wsh_picking_batches.Attribute15%TYPE,
74: Autodetail_Pr_Flag wsh_picking_batches.Autodetail_Pr_Flag%TYPE,
75: -- Bug#: 3266659 - Removing carrier params
76: -- Carrier_Id wsh_picking_batches.Carrier_Id%TYPE,
77: -- Carrier_Name wsh_carriers_v.carrier_name%TYPE,
70: Attribute12 wsh_picking_batches.Attribute12%TYPE,
71: Attribute13 wsh_picking_batches.Attribute13%TYPE,
72: Attribute14 wsh_picking_batches.Attribute14%TYPE,
73: Attribute15 wsh_picking_batches.Attribute15%TYPE,
74: Autodetail_Pr_Flag wsh_picking_batches.Autodetail_Pr_Flag%TYPE,
75: -- Bug#: 3266659 - Removing carrier params
76: -- Carrier_Id wsh_picking_batches.Carrier_Id%TYPE,
77: -- Carrier_Name wsh_carriers_v.carrier_name%TYPE,
78: Trip_Stop_Id wsh_picking_batches.Trip_Stop_Id%TYPE,
72: Attribute14 wsh_picking_batches.Attribute14%TYPE,
73: Attribute15 wsh_picking_batches.Attribute15%TYPE,
74: Autodetail_Pr_Flag wsh_picking_batches.Autodetail_Pr_Flag%TYPE,
75: -- Bug#: 3266659 - Removing carrier params
76: -- Carrier_Id wsh_picking_batches.Carrier_Id%TYPE,
77: -- Carrier_Name wsh_carriers_v.carrier_name%TYPE,
78: Trip_Stop_Id wsh_picking_batches.Trip_Stop_Id%TYPE,
79: Trip_Stop_location_id wsh_trip_stops.Stop_Id%TYPE,
80: Default_Stage_Subinventory wsh_picking_batches.Default_Stage_Subinventory%TYPE,
74: Autodetail_Pr_Flag wsh_picking_batches.Autodetail_Pr_Flag%TYPE,
75: -- Bug#: 3266659 - Removing carrier params
76: -- Carrier_Id wsh_picking_batches.Carrier_Id%TYPE,
77: -- Carrier_Name wsh_carriers_v.carrier_name%TYPE,
78: Trip_Stop_Id wsh_picking_batches.Trip_Stop_Id%TYPE,
79: Trip_Stop_location_id wsh_trip_stops.Stop_Id%TYPE,
80: Default_Stage_Subinventory wsh_picking_batches.Default_Stage_Subinventory%TYPE,
81: Default_Stage_Locator_Id wsh_picking_batches.Default_Stage_Locator_Id%TYPE,
82: Pick_From_Subinventory wsh_picking_batches.Pick_From_Subinventory%TYPE,
76: -- Carrier_Id wsh_picking_batches.Carrier_Id%TYPE,
77: -- Carrier_Name wsh_carriers_v.carrier_name%TYPE,
78: Trip_Stop_Id wsh_picking_batches.Trip_Stop_Id%TYPE,
79: Trip_Stop_location_id wsh_trip_stops.Stop_Id%TYPE,
80: Default_Stage_Subinventory wsh_picking_batches.Default_Stage_Subinventory%TYPE,
81: Default_Stage_Locator_Id wsh_picking_batches.Default_Stage_Locator_Id%TYPE,
82: Pick_From_Subinventory wsh_picking_batches.Pick_From_Subinventory%TYPE,
83: Pick_From_locator_Id wsh_picking_batches.Pick_From_locator_Id%TYPE,
84: Auto_Pick_Confirm_Flag wsh_picking_batches.Auto_Pick_Confirm_Flag%TYPE,
77: -- Carrier_Name wsh_carriers_v.carrier_name%TYPE,
78: Trip_Stop_Id wsh_picking_batches.Trip_Stop_Id%TYPE,
79: Trip_Stop_location_id wsh_trip_stops.Stop_Id%TYPE,
80: Default_Stage_Subinventory wsh_picking_batches.Default_Stage_Subinventory%TYPE,
81: Default_Stage_Locator_Id wsh_picking_batches.Default_Stage_Locator_Id%TYPE,
82: Pick_From_Subinventory wsh_picking_batches.Pick_From_Subinventory%TYPE,
83: Pick_From_locator_Id wsh_picking_batches.Pick_From_locator_Id%TYPE,
84: Auto_Pick_Confirm_Flag wsh_picking_batches.Auto_Pick_Confirm_Flag%TYPE,
85: Delivery_Detail_Id wsh_picking_batches.Delivery_Detail_Id%TYPE,
78: Trip_Stop_Id wsh_picking_batches.Trip_Stop_Id%TYPE,
79: Trip_Stop_location_id wsh_trip_stops.Stop_Id%TYPE,
80: Default_Stage_Subinventory wsh_picking_batches.Default_Stage_Subinventory%TYPE,
81: Default_Stage_Locator_Id wsh_picking_batches.Default_Stage_Locator_Id%TYPE,
82: Pick_From_Subinventory wsh_picking_batches.Pick_From_Subinventory%TYPE,
83: Pick_From_locator_Id wsh_picking_batches.Pick_From_locator_Id%TYPE,
84: Auto_Pick_Confirm_Flag wsh_picking_batches.Auto_Pick_Confirm_Flag%TYPE,
85: Delivery_Detail_Id wsh_picking_batches.Delivery_Detail_Id%TYPE,
86: Project_Id wsh_picking_batches.Project_Id%TYPE,
79: Trip_Stop_location_id wsh_trip_stops.Stop_Id%TYPE,
80: Default_Stage_Subinventory wsh_picking_batches.Default_Stage_Subinventory%TYPE,
81: Default_Stage_Locator_Id wsh_picking_batches.Default_Stage_Locator_Id%TYPE,
82: Pick_From_Subinventory wsh_picking_batches.Pick_From_Subinventory%TYPE,
83: Pick_From_locator_Id wsh_picking_batches.Pick_From_locator_Id%TYPE,
84: Auto_Pick_Confirm_Flag wsh_picking_batches.Auto_Pick_Confirm_Flag%TYPE,
85: Delivery_Detail_Id wsh_picking_batches.Delivery_Detail_Id%TYPE,
86: Project_Id wsh_picking_batches.Project_Id%TYPE,
87: Task_Id wsh_picking_batches.Task_Id%TYPE,
80: Default_Stage_Subinventory wsh_picking_batches.Default_Stage_Subinventory%TYPE,
81: Default_Stage_Locator_Id wsh_picking_batches.Default_Stage_Locator_Id%TYPE,
82: Pick_From_Subinventory wsh_picking_batches.Pick_From_Subinventory%TYPE,
83: Pick_From_locator_Id wsh_picking_batches.Pick_From_locator_Id%TYPE,
84: Auto_Pick_Confirm_Flag wsh_picking_batches.Auto_Pick_Confirm_Flag%TYPE,
85: Delivery_Detail_Id wsh_picking_batches.Delivery_Detail_Id%TYPE,
86: Project_Id wsh_picking_batches.Project_Id%TYPE,
87: Task_Id wsh_picking_batches.Task_Id%TYPE,
88: Organization_Id wsh_picking_batches.Organization_Id%TYPE,
81: Default_Stage_Locator_Id wsh_picking_batches.Default_Stage_Locator_Id%TYPE,
82: Pick_From_Subinventory wsh_picking_batches.Pick_From_Subinventory%TYPE,
83: Pick_From_locator_Id wsh_picking_batches.Pick_From_locator_Id%TYPE,
84: Auto_Pick_Confirm_Flag wsh_picking_batches.Auto_Pick_Confirm_Flag%TYPE,
85: Delivery_Detail_Id wsh_picking_batches.Delivery_Detail_Id%TYPE,
86: Project_Id wsh_picking_batches.Project_Id%TYPE,
87: Task_Id wsh_picking_batches.Task_Id%TYPE,
88: Organization_Id wsh_picking_batches.Organization_Id%TYPE,
89: Organization_Code org_organization_definitions.organization_code%TYPE,
82: Pick_From_Subinventory wsh_picking_batches.Pick_From_Subinventory%TYPE,
83: Pick_From_locator_Id wsh_picking_batches.Pick_From_locator_Id%TYPE,
84: Auto_Pick_Confirm_Flag wsh_picking_batches.Auto_Pick_Confirm_Flag%TYPE,
85: Delivery_Detail_Id wsh_picking_batches.Delivery_Detail_Id%TYPE,
86: Project_Id wsh_picking_batches.Project_Id%TYPE,
87: Task_Id wsh_picking_batches.Task_Id%TYPE,
88: Organization_Id wsh_picking_batches.Organization_Id%TYPE,
89: Organization_Code org_organization_definitions.organization_code%TYPE,
90: Ship_Confirm_Rule_Id wsh_picking_batches.Ship_Confirm_Rule_Id%TYPE,
83: Pick_From_locator_Id wsh_picking_batches.Pick_From_locator_Id%TYPE,
84: Auto_Pick_Confirm_Flag wsh_picking_batches.Auto_Pick_Confirm_Flag%TYPE,
85: Delivery_Detail_Id wsh_picking_batches.Delivery_Detail_Id%TYPE,
86: Project_Id wsh_picking_batches.Project_Id%TYPE,
87: Task_Id wsh_picking_batches.Task_Id%TYPE,
88: Organization_Id wsh_picking_batches.Organization_Id%TYPE,
89: Organization_Code org_organization_definitions.organization_code%TYPE,
90: Ship_Confirm_Rule_Id wsh_picking_batches.Ship_Confirm_Rule_Id%TYPE,
91: Ship_Confirm_Rule_Name wsh_Ship_Confirm_rules.name%TYPE,
84: Auto_Pick_Confirm_Flag wsh_picking_batches.Auto_Pick_Confirm_Flag%TYPE,
85: Delivery_Detail_Id wsh_picking_batches.Delivery_Detail_Id%TYPE,
86: Project_Id wsh_picking_batches.Project_Id%TYPE,
87: Task_Id wsh_picking_batches.Task_Id%TYPE,
88: Organization_Id wsh_picking_batches.Organization_Id%TYPE,
89: Organization_Code org_organization_definitions.organization_code%TYPE,
90: Ship_Confirm_Rule_Id wsh_picking_batches.Ship_Confirm_Rule_Id%TYPE,
91: Ship_Confirm_Rule_Name wsh_Ship_Confirm_rules.name%TYPE,
92: Autopack_Flag wsh_picking_batches.Autopack_Flag%TYPE,
86: Project_Id wsh_picking_batches.Project_Id%TYPE,
87: Task_Id wsh_picking_batches.Task_Id%TYPE,
88: Organization_Id wsh_picking_batches.Organization_Id%TYPE,
89: Organization_Code org_organization_definitions.organization_code%TYPE,
90: Ship_Confirm_Rule_Id wsh_picking_batches.Ship_Confirm_Rule_Id%TYPE,
91: Ship_Confirm_Rule_Name wsh_Ship_Confirm_rules.name%TYPE,
92: Autopack_Flag wsh_picking_batches.Autopack_Flag%TYPE,
93: Autopack_Level wsh_picking_batches.Autopack_Level%TYPE,
94: Task_Planning_Flag wsh_picking_batches.Task_Planning_Flag%TYPE,
88: Organization_Id wsh_picking_batches.Organization_Id%TYPE,
89: Organization_Code org_organization_definitions.organization_code%TYPE,
90: Ship_Confirm_Rule_Id wsh_picking_batches.Ship_Confirm_Rule_Id%TYPE,
91: Ship_Confirm_Rule_Name wsh_Ship_Confirm_rules.name%TYPE,
92: Autopack_Flag wsh_picking_batches.Autopack_Flag%TYPE,
93: Autopack_Level wsh_picking_batches.Autopack_Level%TYPE,
94: Task_Planning_Flag wsh_picking_batches.Task_Planning_Flag%TYPE,
95: -- Non_Picking_flag wsh_picking_batches.Non_Picking_flag%TYPE,
96: Category_Set_ID wsh_picking_batches.Category_Set_ID%TYPE,
89: Organization_Code org_organization_definitions.organization_code%TYPE,
90: Ship_Confirm_Rule_Id wsh_picking_batches.Ship_Confirm_Rule_Id%TYPE,
91: Ship_Confirm_Rule_Name wsh_Ship_Confirm_rules.name%TYPE,
92: Autopack_Flag wsh_picking_batches.Autopack_Flag%TYPE,
93: Autopack_Level wsh_picking_batches.Autopack_Level%TYPE,
94: Task_Planning_Flag wsh_picking_batches.Task_Planning_Flag%TYPE,
95: -- Non_Picking_flag wsh_picking_batches.Non_Picking_flag%TYPE,
96: Category_Set_ID wsh_picking_batches.Category_Set_ID%TYPE,
97: Category_ID wsh_picking_batches.Category_ID%TYPE,
90: Ship_Confirm_Rule_Id wsh_picking_batches.Ship_Confirm_Rule_Id%TYPE,
91: Ship_Confirm_Rule_Name wsh_Ship_Confirm_rules.name%TYPE,
92: Autopack_Flag wsh_picking_batches.Autopack_Flag%TYPE,
93: Autopack_Level wsh_picking_batches.Autopack_Level%TYPE,
94: Task_Planning_Flag wsh_picking_batches.Task_Planning_Flag%TYPE,
95: -- Non_Picking_flag wsh_picking_batches.Non_Picking_flag%TYPE,
96: Category_Set_ID wsh_picking_batches.Category_Set_ID%TYPE,
97: Category_ID wsh_picking_batches.Category_ID%TYPE,
98: Ship_Set_Smc_Flag wsh_picking_batches.Ship_Set_Smc_Flag%TYPE,
91: Ship_Confirm_Rule_Name wsh_Ship_Confirm_rules.name%TYPE,
92: Autopack_Flag wsh_picking_batches.Autopack_Flag%TYPE,
93: Autopack_Level wsh_picking_batches.Autopack_Level%TYPE,
94: Task_Planning_Flag wsh_picking_batches.Task_Planning_Flag%TYPE,
95: -- Non_Picking_flag wsh_picking_batches.Non_Picking_flag%TYPE,
96: Category_Set_ID wsh_picking_batches.Category_Set_ID%TYPE,
97: Category_ID wsh_picking_batches.Category_ID%TYPE,
98: Ship_Set_Smc_Flag wsh_picking_batches.Ship_Set_Smc_Flag%TYPE,
99: -- Bug#: 3266659 - Adding the columns like zone, region, delivery criteria, release
92: Autopack_Flag wsh_picking_batches.Autopack_Flag%TYPE,
93: Autopack_Level wsh_picking_batches.Autopack_Level%TYPE,
94: Task_Planning_Flag wsh_picking_batches.Task_Planning_Flag%TYPE,
95: -- Non_Picking_flag wsh_picking_batches.Non_Picking_flag%TYPE,
96: Category_Set_ID wsh_picking_batches.Category_Set_ID%TYPE,
97: Category_ID wsh_picking_batches.Category_ID%TYPE,
98: Ship_Set_Smc_Flag wsh_picking_batches.Ship_Set_Smc_Flag%TYPE,
99: -- Bug#: 3266659 - Adding the columns like zone, region, delivery criteria, release
100: -- subinventory and append flag
93: Autopack_Level wsh_picking_batches.Autopack_Level%TYPE,
94: Task_Planning_Flag wsh_picking_batches.Task_Planning_Flag%TYPE,
95: -- Non_Picking_flag wsh_picking_batches.Non_Picking_flag%TYPE,
96: Category_Set_ID wsh_picking_batches.Category_Set_ID%TYPE,
97: Category_ID wsh_picking_batches.Category_ID%TYPE,
98: Ship_Set_Smc_Flag wsh_picking_batches.Ship_Set_Smc_Flag%TYPE,
99: -- Bug#: 3266659 - Adding the columns like zone, region, delivery criteria, release
100: -- subinventory and append flag
101: region_ID wsh_picking_batches.region_id%TYPE,
94: Task_Planning_Flag wsh_picking_batches.Task_Planning_Flag%TYPE,
95: -- Non_Picking_flag wsh_picking_batches.Non_Picking_flag%TYPE,
96: Category_Set_ID wsh_picking_batches.Category_Set_ID%TYPE,
97: Category_ID wsh_picking_batches.Category_ID%TYPE,
98: Ship_Set_Smc_Flag wsh_picking_batches.Ship_Set_Smc_Flag%TYPE,
99: -- Bug#: 3266659 - Adding the columns like zone, region, delivery criteria, release
100: -- subinventory and append flag
101: region_ID wsh_picking_batches.region_id%TYPE,
102: zone_ID wsh_picking_batches.zone_id%TYPE,
97: Category_ID wsh_picking_batches.Category_ID%TYPE,
98: Ship_Set_Smc_Flag wsh_picking_batches.Ship_Set_Smc_Flag%TYPE,
99: -- Bug#: 3266659 - Adding the columns like zone, region, delivery criteria, release
100: -- subinventory and append flag
101: region_ID wsh_picking_batches.region_id%TYPE,
102: zone_ID wsh_picking_batches.zone_id%TYPE,
103: ac_Delivery_Criteria wsh_picking_batches.ac_delivery_criteria%TYPE,
104: rel_subinventory wsh_picking_batches.rel_subinventory%TYPE,
105: append_flag wsh_picking_batches.append_flag%TYPE := 'N',
98: Ship_Set_Smc_Flag wsh_picking_batches.Ship_Set_Smc_Flag%TYPE,
99: -- Bug#: 3266659 - Adding the columns like zone, region, delivery criteria, release
100: -- subinventory and append flag
101: region_ID wsh_picking_batches.region_id%TYPE,
102: zone_ID wsh_picking_batches.zone_id%TYPE,
103: ac_Delivery_Criteria wsh_picking_batches.ac_delivery_criteria%TYPE,
104: rel_subinventory wsh_picking_batches.rel_subinventory%TYPE,
105: append_flag wsh_picking_batches.append_flag%TYPE := 'N',
106: task_priority wsh_picking_batches.task_priority%TYPE,
99: -- Bug#: 3266659 - Adding the columns like zone, region, delivery criteria, release
100: -- subinventory and append flag
101: region_ID wsh_picking_batches.region_id%TYPE,
102: zone_ID wsh_picking_batches.zone_id%TYPE,
103: ac_Delivery_Criteria wsh_picking_batches.ac_delivery_criteria%TYPE,
104: rel_subinventory wsh_picking_batches.rel_subinventory%TYPE,
105: append_flag wsh_picking_batches.append_flag%TYPE := 'N',
106: task_priority wsh_picking_batches.task_priority%TYPE,
107: actual_departure_date wsh_picking_batches.actual_departure_date%TYPE,
100: -- subinventory and append flag
101: region_ID wsh_picking_batches.region_id%TYPE,
102: zone_ID wsh_picking_batches.zone_id%TYPE,
103: ac_Delivery_Criteria wsh_picking_batches.ac_delivery_criteria%TYPE,
104: rel_subinventory wsh_picking_batches.rel_subinventory%TYPE,
105: append_flag wsh_picking_batches.append_flag%TYPE := 'N',
106: task_priority wsh_picking_batches.task_priority%TYPE,
107: actual_departure_date wsh_picking_batches.actual_departure_date%TYPE,
108: allocation_method wsh_picking_batches.allocation_method%TYPE, -- X-dock
101: region_ID wsh_picking_batches.region_id%TYPE,
102: zone_ID wsh_picking_batches.zone_id%TYPE,
103: ac_Delivery_Criteria wsh_picking_batches.ac_delivery_criteria%TYPE,
104: rel_subinventory wsh_picking_batches.rel_subinventory%TYPE,
105: append_flag wsh_picking_batches.append_flag%TYPE := 'N',
106: task_priority wsh_picking_batches.task_priority%TYPE,
107: actual_departure_date wsh_picking_batches.actual_departure_date%TYPE,
108: allocation_method wsh_picking_batches.allocation_method%TYPE, -- X-dock
109: crossdock_criteria_id wsh_picking_batches.crossdock_criteria_id%TYPE, -- X-dock
102: zone_ID wsh_picking_batches.zone_id%TYPE,
103: ac_Delivery_Criteria wsh_picking_batches.ac_delivery_criteria%TYPE,
104: rel_subinventory wsh_picking_batches.rel_subinventory%TYPE,
105: append_flag wsh_picking_batches.append_flag%TYPE := 'N',
106: task_priority wsh_picking_batches.task_priority%TYPE,
107: actual_departure_date wsh_picking_batches.actual_departure_date%TYPE,
108: allocation_method wsh_picking_batches.allocation_method%TYPE, -- X-dock
109: crossdock_criteria_id wsh_picking_batches.crossdock_criteria_id%TYPE, -- X-dock
110: crossdock_criteria_name varchar2(80), -- X-dock
103: ac_Delivery_Criteria wsh_picking_batches.ac_delivery_criteria%TYPE,
104: rel_subinventory wsh_picking_batches.rel_subinventory%TYPE,
105: append_flag wsh_picking_batches.append_flag%TYPE := 'N',
106: task_priority wsh_picking_batches.task_priority%TYPE,
107: actual_departure_date wsh_picking_batches.actual_departure_date%TYPE,
108: allocation_method wsh_picking_batches.allocation_method%TYPE, -- X-dock
109: crossdock_criteria_id wsh_picking_batches.crossdock_criteria_id%TYPE, -- X-dock
110: crossdock_criteria_name varchar2(80), -- X-dock
111: dynamic_replenishment_flag varchar2(1) --bug# 6689448 (replenishment project)
104: rel_subinventory wsh_picking_batches.rel_subinventory%TYPE,
105: append_flag wsh_picking_batches.append_flag%TYPE := 'N',
106: task_priority wsh_picking_batches.task_priority%TYPE,
107: actual_departure_date wsh_picking_batches.actual_departure_date%TYPE,
108: allocation_method wsh_picking_batches.allocation_method%TYPE, -- X-dock
109: crossdock_criteria_id wsh_picking_batches.crossdock_criteria_id%TYPE, -- X-dock
110: crossdock_criteria_name varchar2(80), -- X-dock
111: dynamic_replenishment_flag varchar2(1) --bug# 6689448 (replenishment project)
112: );
105: append_flag wsh_picking_batches.append_flag%TYPE := 'N',
106: task_priority wsh_picking_batches.task_priority%TYPE,
107: actual_departure_date wsh_picking_batches.actual_departure_date%TYPE,
108: allocation_method wsh_picking_batches.allocation_method%TYPE, -- X-dock
109: crossdock_criteria_id wsh_picking_batches.crossdock_criteria_id%TYPE, -- X-dock
110: crossdock_criteria_name varchar2(80), -- X-dock
111: dynamic_replenishment_flag varchar2(1) --bug# 6689448 (replenishment project)
112: );
113:
177:
178: ---- Program specific paramters.
179: p_rule_id IN NUMBER DEFAULT NULL,
180: p_rule_name IN VARCHAR2 DEFAULT NULL,
181: p_batch_rec IN WSH_PICKING_BATCHES_PUB.Batch_Info_Rec,
182: p_batch_prefix IN VARCHAR2 DEFAULT NULL,
183: x_batch_id OUT NOCOPY NUMBER
184:
185: );
204: -- x_return_status return status
205: -- x_msg_count number of messages in the list
206: -- x_msg_data text of messages
207: -- p_batch_id Picking Batch Id which is used to get Batch
208: -- information from the wsh_picking_batches table.
209: -- p_batch_name Picking Batch Name which is used to get Batch
210: -- information from the wsh_picking_batches table.
211: -- p_log_level Controlls the log message generated by cuncurrent
212: -- pick release process.
206: -- x_msg_data text of messages
207: -- p_batch_id Picking Batch Id which is used to get Batch
208: -- information from the wsh_picking_batches table.
209: -- p_batch_name Picking Batch Name which is used to get Batch
210: -- information from the wsh_picking_batches table.
211: -- p_log_level Controlls the log message generated by cuncurrent
212: -- pick release process.
213: -- p_release_mode Used to do ONLINE or CONCURRENT pick release,
214: -- Default is "CONCURREN"
260: -- Type : Public
261: -- Purpose
262: -- Pre-reqs : None.
263: -- Function : The procedure takes in a Batch_id or Batch_name and retrieves
264: -- the batch record from wsh_picking_batches.
265: -- Note: Non-database attributes will be NULL.
266: --
267: -- PARAMETERS : p_api_version_number known api version number
268: -- p_init_msg_list FND_API.G_TRUE to reset list
270: -- x_return_status return status
271: -- x_msg_count number of messages in the list
272: -- x_msg_data text of messages
273: -- p_batch_id Picking Batch Id which is used to get Batch
274: -- information from the wsh_picking_batches table.
275: -- p_batch_name Picking Batch Name which is used to get Batch
276: -- information from the wsh_picking_batches table.
277: -- x_batch_rec Batch record from wsh_picking_batches
278: -- VERSION : current version 1.0
272: -- x_msg_data text of messages
273: -- p_batch_id Picking Batch Id which is used to get Batch
274: -- information from the wsh_picking_batches table.
275: -- p_batch_name Picking Batch Name which is used to get Batch
276: -- information from the wsh_picking_batches table.
277: -- x_batch_rec Batch record from wsh_picking_batches
278: -- VERSION : current version 1.0
279: -- initial version 1.0
280: -- End of comments
273: -- p_batch_id Picking Batch Id which is used to get Batch
274: -- information from the wsh_picking_batches table.
275: -- p_batch_name Picking Batch Name which is used to get Batch
276: -- information from the wsh_picking_batches table.
277: -- x_batch_rec Batch record from wsh_picking_batches
278: -- VERSION : current version 1.0
279: -- initial version 1.0
280: -- End of comments
281:
280: -- End of comments
281:
282: /*#
283: * This procedure is used to get a picking batch record. The procedure takes in a pick release
284: * Batch_id/ Batch_name and retrieves the batch record from wsh_picking_batches.
285: * @param p_api_version version number of the API
286: * @param p_init_msg_list messages will be initialized, if set as true
287: * @param p_commit commits the transaction, if set as true
288: * @param x_return_status return status of the API
305: x_msg_data OUT NOCOPY VARCHAR2,
306: -- program specific paramters.
307: p_batch_id IN NUMBER DEFAULT NULL,
308: p_batch_name IN VARCHAR2 DEFAULT NULL,
309: x_batch_rec OUT NOCOPY WSH_PICKING_BATCHES_PUB.Batch_Info_Rec
310: ) ;
311:
312:
313:
310: ) ;
311:
312:
313:
314: END WSH_PICKING_BATCHES_PUB;