1 PACKAGE WSH_PR_PICK_SLIP_NUMBER AUTHID CURRENT_USER AS
2 /* $Header: WSHPRPNS.pls 120.1 2006/06/20 09:06:21 aymohant noship $ */
3
4 --
5 -- Package
6 -- WSH_PR_PICK_SLIP_NUMBER
7 --
8 -- Purpose
9 -- This package does the following:
10 -- - Initialize variables to be used
11 -- in determining the how to group pick slips.
12 -- - Get pick slip number
13 -- - Print Pick Slip Report
14 --
15
16 TYPE psTabTyp is TABLE OF NUMBER INDEX BY BINARY_INTEGER;
17 g_print_ps_table psTabTyp;
18
19 --
20 -- PUBLIC FUNCTIONS/PROCEDURES
21 --
22
23 --
24 -- Name
25 -- PROCEDURE Print_Pick_Slip
26 --
27 -- Purpose
28 -- This function prints a Pick Slip for a given Pick Slip number
29 -- or all Pick Slips for the session
30 --
31 -- Input Parameters
32 -- p_pick_slip_number => pick slip number
33 -- p_report_set_id => report set
34 -- If p_report_set_id IS NULL, procedure returns. No printing.
35 -- p_order_header_id => Order Header id
36 -- p_batch_id => Batch id
37 -- p_ps_mode => P.Slip Mode ('I'mmediate, 'D'effered, 'N'one) -- 1676123
38 --
39 --
40 -- Output Parameters
41 -- x_api_status => FND_API.G_RET_STS_SUCESSS or
42 -- FND_API.G_RET_STS_ERROR or
43 -- FND_API.G_RET_STS_UNEXP_ERROR
44 -- x_error_message => Error message
45 --
46 --
47 PROCEDURE Print_Pick_Slip (
48 p_pick_slip_number IN NUMBER DEFAULT FND_API.G_MISS_NUM,
49 p_report_set_id IN NUMBER,
50 p_organization_id IN NUMBER,
51 p_order_header_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
52 p_batch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
53 p_ps_mode IN VARCHAR2 DEFAULT NULL,
54 x_api_status OUT NOCOPY VARCHAR2,
55 x_error_message OUT NOCOPY VARCHAR2 );
56
57 /*
58 ############### PLEASE READ ####################################
59 Following APIs were owned by WSH until patchset H (11.5.8).
60 From Patchset-I onwards, ownership has been transfered to INV Team.
61 Please do not modify these APIs for any ongoing development
62 or bug-fixes from Patchset-I and beyond.
63
64 Modify these APIs only if you are making bug-fix for pre-I
65 customers. Please consult Nikhil Parikh/Anil Verma, if you have
66 any questions.
67
68 The APIs are maintained here only for backward-compatibility, i.e.
69 if customer has applied INV-H and WSH-I, it should still
70 continue to work.
71
72 */
73 --
74 -- Name
75 -- PROCEDURE Get_Pick_Slip_Number
76 --
77 -- Purpose
78 -- Returns pick slip number and whether a Pick Slip
79 -- should be printed
80 --
81 -- Input Parameters
82 -- p_ps_mode => pick slip print mode: I=immed, E=deferred
83 -- p_pick_grouping_rule_id => pick grouping rule id
84 -- p_org_id => organization_id
85 -- p_header_id => order header id
86 -- p_customer_id => customer id
87 -- p_ship_method_code => ship method
88 -- p_ship_to_loc_id => ship to location
89 -- p_shipment_priority => shipment priority
90 -- p_subinventory => subinventory
91 -- p_trip_stop_id => trip stop
92 -- p_delivery_id => delivery
93 -- p_inventory_item_id => inventory item id
94 -- p_locator_id => locator id
95 -- p_lot_number => lot number
96 -- p_revision => revision
97 --
98 -- Output Parameters
99 -- x_pick_slip_number => pick_slip_number
100 -- x_ready_to_print => FND_API.G_TRUE or FND_API.G_FALSE
101 -- x_api_status => FND_API.G_RET_STS_SUCESSS or
102 -- FND_API.G_RET_STS_ERROR
103 -- x_error_message => Error message
104 --
105 PROCEDURE Get_Pick_Slip_Number (
106 p_ps_mode IN VARCHAR2,
107 p_pick_grouping_rule_id IN NUMBER,
108 p_org_id IN NUMBER,
109 p_header_id IN NUMBER,
110 p_customer_id IN NUMBER,
111 p_ship_method_code IN VARCHAR2,
112 p_ship_to_loc_id IN NUMBER,
113 p_shipment_priority IN VARCHAR2,
114 p_subinventory IN VARCHAR2,
115 p_trip_stop_id IN NUMBER,
116 p_delivery_id IN NUMBER,
117 p_inventory_item_id IN NUMBER DEFAULT NULL,
118 p_locator_id IN NUMBER DEFAULT NULL,
119 p_lot_number IN VARCHAR2 DEFAULT NULL,
120 p_revision IN VARCHAR2 DEFAULT NULL,
121 x_pick_slip_number OUT NOCOPY NUMBER,
122 x_ready_to_print OUT NOCOPY VARCHAR2,
123 x_call_mode OUT NOCOPY VARCHAR2,
124 x_api_status OUT NOCOPY VARCHAR2,
125 x_error_message OUT NOCOPY VARCHAR2 );
126
127 -- Name
128 -- PROCEDURE delete_pick_slip_numbers /* For parallel Pick-Release */
129 --
130 -- Purpose
131 -- This function used by shipping to delete the pickslip numbers
132 -- from mtl_pick_slip_numbers at the end the pickrelease session
133 -- for parallel pick-release
134 --
135 -- Input Parameters
136 -- p_batch_id => pickrelease batch_id (WSH_PICKING_BATCHES)
137
138 PROCEDURE delete_pick_slip_numbers (
139 p_batch_id IN NUMBER);
140
141 -- Name
142 -- PROCEDURE DELETE_PS_TBL
143 --
144 -- Purpose
145 -- Deletes the global PL/SQL table used to store pick slip numbers
146 -- For code levels 11.5.9 or above it will delete the table from INV.
147 --
148 -- Input Parameters
149 -- None
150 --
151 -- Output Parameters
152 -- None
153 PROCEDURE delete_ps_tbl(
154 x_api_status OUT NOCOPY VARCHAR2,
155 x_error_message OUT NOCOPY VARCHAR2 );
156
157 END WSH_PR_PICK_SLIP_NUMBER;