eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_PICKING_BATCHES_PUB dependencies on WSH_PICKING_BATCHES

Line 1: PACKAGE WSH_PICKING_BATCHES_PUB AUTHID CURRENT_USER AS

1: PACKAGE WSH_PICKING_BATCHES_PUB AUTHID CURRENT_USER AS
2: -- $Header: WSHPRPBS.pls 120.3.12010000.2 2009/12/03 14:20:52 gbhargav ship $
3: /*#
4: * This is the public interface for picking batches. This package
5: * has procedures for creating and releasing picking batches.

Line 13: * @rep:category BUSINESS_ENTITY WSH_PICKING_BATCHES_PUB

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

Line 22: Backorders_Only_Flag wsh_picking_batches.Backorders_Only_Flag%TYPE,

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,

Line 23: Document_Set_Id wsh_picking_batches.Document_Set_Id%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,

Line 25: Existing_Rsvs_Only_Flag wsh_picking_batches.Existing_Rsvs_Only_Flag%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,

Line 26: Shipment_Priority_Code wsh_picking_batches.Shipment_Priority_Code%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

Line 27: Ship_Method_Code wsh_picking_batches.Ship_Method_Code%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
31: Customer_Number hz_cust_accounts.account_number%TYPE, /*Customer Number*/

Line 29: Customer_Id wsh_picking_batches.Customer_Id%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*/
32: --TCA view removal Changes End
33: Order_Header_Id wsh_picking_batches.Order_Header_Id%TYPE,

Line 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,

Line 35: Ship_Set_Id wsh_picking_batches.Ship_Set_Number%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,

Line 37: Inventory_Item_Id wsh_picking_batches.Inventory_Item_Id%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,

Line 38: Order_Type_Id wsh_picking_batches.Order_Type_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,
42: From_Scheduled_Ship_Date DATE,

Line 44: Ship_To_Location_Id wsh_picking_batches.Ship_To_Location_Id%TYPE,

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,

Line 46: Ship_From_Location_Id wsh_picking_batches.Ship_From_Location_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,

Line 48: Trip_Id wsh_picking_batches.Trip_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,

Line 50: Delivery_Id wsh_picking_batches.Delivery_Id%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,

Line 52: Include_Planned_Lines wsh_picking_batches.Include_Planned_Lines%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,

Line 53: Pick_Grouping_Rule_Id wsh_picking_batches.Pick_Grouping_Rule_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,
57: Autocreate_Delivery_Flag wsh_picking_batches.Autocreate_Delivery_Flag%TYPE,

Line 55: Pick_Sequence_Rule_Id wsh_picking_batches.Pick_Sequence_Rule_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,
58: Attribute_Category wsh_picking_batches.Attribute_Category%TYPE,
59: Attribute1 wsh_picking_batches.Attribute1%TYPE,

Line 57: Autocreate_Delivery_Flag wsh_picking_batches.Autocreate_Delivery_Flag%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,

Line 58: Attribute_Category wsh_picking_batches.Attribute_Category%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,

Line 59: Attribute1 wsh_picking_batches.Attribute1%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,

Line 60: Attribute2 wsh_picking_batches.Attribute2%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,

Line 61: Attribute3 wsh_picking_batches.Attribute3%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,

Line 62: Attribute4 wsh_picking_batches.Attribute4%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,

Line 63: Attribute5 wsh_picking_batches.Attribute5%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,

Line 64: Attribute6 wsh_picking_batches.Attribute6%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,

Line 65: Attribute7 wsh_picking_batches.Attribute7%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,

Line 66: Attribute8 wsh_picking_batches.Attribute8%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,

Line 67: Attribute9 wsh_picking_batches.Attribute9%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,

Line 68: Attribute10 wsh_picking_batches.Attribute10%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,

Line 69: Attribute11 wsh_picking_batches.Attribute11%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,

Line 70: Attribute12 wsh_picking_batches.Attribute12%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,

Line 71: Attribute13 wsh_picking_batches.Attribute13%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

Line 72: Attribute14 wsh_picking_batches.Attribute14%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
76: -- Carrier_Id wsh_picking_batches.Carrier_Id%TYPE,

Line 73: Attribute15 wsh_picking_batches.Attribute15%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,

Line 74: Autodetail_Pr_Flag wsh_picking_batches.Autodetail_Pr_Flag%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,

Line 76: -- Carrier_Id wsh_picking_batches.Carrier_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,

Line 78: Trip_Stop_Id wsh_picking_batches.Trip_Stop_Id%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,

Line 80: Default_Stage_Subinventory wsh_picking_batches.Default_Stage_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,

Line 81: Default_Stage_Locator_Id wsh_picking_batches.Default_Stage_Locator_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,
85: Delivery_Detail_Id wsh_picking_batches.Delivery_Detail_Id%TYPE,

Line 82: Pick_From_Subinventory wsh_picking_batches.Pick_From_Subinventory%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,

Line 83: Pick_From_locator_Id wsh_picking_batches.Pick_From_locator_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,

Line 84: Auto_Pick_Confirm_Flag wsh_picking_batches.Auto_Pick_Confirm_Flag%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,

Line 85: Delivery_Detail_Id wsh_picking_batches.Delivery_Detail_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,

Line 86: Project_Id wsh_picking_batches.Project_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,
90: Ship_Confirm_Rule_Id wsh_picking_batches.Ship_Confirm_Rule_Id%TYPE,

Line 87: Task_Id wsh_picking_batches.Task_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,

Line 88: Organization_Id wsh_picking_batches.Organization_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,
92: Autopack_Flag wsh_picking_batches.Autopack_Flag%TYPE,

Line 90: Ship_Confirm_Rule_Id wsh_picking_batches.Ship_Confirm_Rule_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,
93: Autopack_Level wsh_picking_batches.Autopack_Level%TYPE,
94: Task_Planning_Flag wsh_picking_batches.Task_Planning_Flag%TYPE,

Line 92: Autopack_Flag wsh_picking_batches.Autopack_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,

Line 93: Autopack_Level wsh_picking_batches.Autopack_Level%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,

Line 94: Task_Planning_Flag wsh_picking_batches.Task_Planning_Flag%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,

Line 95: -- Non_Picking_flag wsh_picking_batches.Non_Picking_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

Line 96: Category_Set_ID wsh_picking_batches.Category_Set_ID%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
100: -- subinventory and append flag

Line 97: Category_ID wsh_picking_batches.Category_ID%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
101: region_ID wsh_picking_batches.region_id%TYPE,

Line 98: Ship_Set_Smc_Flag wsh_picking_batches.Ship_Set_Smc_Flag%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,

Line 101: region_ID wsh_picking_batches.region_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',

Line 102: zone_ID wsh_picking_batches.zone_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',
106: task_priority wsh_picking_batches.task_priority%TYPE,

Line 103: ac_Delivery_Criteria wsh_picking_batches.ac_delivery_criteria%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,

Line 104: rel_subinventory wsh_picking_batches.rel_subinventory%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

Line 105: append_flag wsh_picking_batches.append_flag%TYPE := 'N',

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

Line 106: task_priority wsh_picking_batches.task_priority%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
110: crossdock_criteria_name varchar2(80), -- X-dock

Line 107: actual_departure_date wsh_picking_batches.actual_departure_date%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
111: dynamic_replenishment_flag varchar2(1), --bug# 6689448 (replenishment project)

Line 108: allocation_method wsh_picking_batches.allocation_method%TYPE, -- X-dock

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: -- LSP PROJECT

Line 109: crossdock_criteria_id wsh_picking_batches.crossdock_criteria_id%TYPE, -- X-dock

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: -- LSP PROJECT
113: client_id NUMBER,

Line 185: p_batch_rec IN WSH_PICKING_BATCHES_PUB.Batch_Info_Rec,

181:
182: ---- Program specific paramters.
183: p_rule_id IN NUMBER DEFAULT NULL,
184: p_rule_name IN VARCHAR2 DEFAULT NULL,
185: p_batch_rec IN WSH_PICKING_BATCHES_PUB.Batch_Info_Rec,
186: p_batch_prefix IN VARCHAR2 DEFAULT NULL,
187: x_batch_id OUT NOCOPY NUMBER
188:
189: );

Line 212: -- information from the wsh_picking_batches table.

208: -- x_return_status return status
209: -- x_msg_count number of messages in the list
210: -- x_msg_data text of messages
211: -- p_batch_id Picking Batch Id which is used to get Batch
212: -- information from the wsh_picking_batches table.
213: -- p_batch_name Picking Batch Name which is used to get Batch
214: -- information from the wsh_picking_batches table.
215: -- p_log_level Controlls the log message generated by cuncurrent
216: -- pick release process.

Line 214: -- information from the wsh_picking_batches table.

210: -- x_msg_data text of messages
211: -- p_batch_id Picking Batch Id which is used to get Batch
212: -- information from the wsh_picking_batches table.
213: -- p_batch_name Picking Batch Name which is used to get Batch
214: -- information from the wsh_picking_batches table.
215: -- p_log_level Controlls the log message generated by cuncurrent
216: -- pick release process.
217: -- p_release_mode Used to do ONLINE or CONCURRENT pick release,
218: -- Default is "CONCURREN"

Line 268: -- the batch record from wsh_picking_batches.

264: -- Type : Public
265: -- Purpose
266: -- Pre-reqs : None.
267: -- Function : The procedure takes in a Batch_id or Batch_name and retrieves
268: -- the batch record from wsh_picking_batches.
269: -- Note: Non-database attributes will be NULL.
270: --
271: -- PARAMETERS : p_api_version_number known api version number
272: -- p_init_msg_list FND_API.G_TRUE to reset list

Line 278: -- information from the wsh_picking_batches table.

274: -- x_return_status return status
275: -- x_msg_count number of messages in the list
276: -- x_msg_data text of messages
277: -- p_batch_id Picking Batch Id which is used to get Batch
278: -- information from the wsh_picking_batches table.
279: -- p_batch_name Picking Batch Name which is used to get Batch
280: -- information from the wsh_picking_batches table.
281: -- x_batch_rec Batch record from wsh_picking_batches
282: -- VERSION : current version 1.0

Line 280: -- information from the wsh_picking_batches table.

276: -- x_msg_data text of messages
277: -- p_batch_id Picking Batch Id which is used to get Batch
278: -- information from the wsh_picking_batches table.
279: -- p_batch_name Picking Batch Name which is used to get Batch
280: -- information from the wsh_picking_batches table.
281: -- x_batch_rec Batch record from wsh_picking_batches
282: -- VERSION : current version 1.0
283: -- initial version 1.0
284: -- End of comments

Line 281: -- x_batch_rec Batch record from wsh_picking_batches

277: -- p_batch_id Picking Batch Id which is used to get Batch
278: -- information from the wsh_picking_batches table.
279: -- p_batch_name Picking Batch Name which is used to get Batch
280: -- information from the wsh_picking_batches table.
281: -- x_batch_rec Batch record from wsh_picking_batches
282: -- VERSION : current version 1.0
283: -- initial version 1.0
284: -- End of comments
285:

Line 288: * Batch_id/ Batch_name and retrieves the batch record from wsh_picking_batches.

284: -- End of comments
285:
286: /*#
287: * This procedure is used to get a picking batch record. The procedure takes in a pick release
288: * Batch_id/ Batch_name and retrieves the batch record from wsh_picking_batches.
289: * @param p_api_version version number of the API
290: * @param p_init_msg_list messages will be initialized, if set as true
291: * @param p_commit commits the transaction, if set as true
292: * @param x_return_status return status of the API

Line 313: x_batch_rec OUT NOCOPY WSH_PICKING_BATCHES_PUB.Batch_Info_Rec

309: x_msg_data OUT NOCOPY VARCHAR2,
310: -- program specific paramters.
311: p_batch_id IN NUMBER DEFAULT NULL,
312: p_batch_name IN VARCHAR2 DEFAULT NULL,
313: x_batch_rec OUT NOCOPY WSH_PICKING_BATCHES_PUB.Batch_Info_Rec
314: ) ;
315:
316:
317:

Line 318: END WSH_PICKING_BATCHES_PUB;

314: ) ;
315:
316:
317:
318: END WSH_PICKING_BATCHES_PUB;