[Home] [Help]
PACKAGE: APPS.WSH_PR_PICKING_SESSION
Source
1 PACKAGE WSH_PR_PICKING_SESSION AUTHID CURRENT_USER AS
2 /* $Header: WSHPRPSS.pls 115.2 99/07/16 08:20:15 porting ship $ */
3
4 --
5 -- Package
6 -- WSH_PR_PICKING_SESSION
7 --
8 -- Purpose
9 -- This package does the following:
10 -- - Maintain all the session variables for Pick Release
11 -- - Construct SQL statements to fetch backorderd picking
12 -- line details, unreleased line details, non-shippable
13 -- lines satisfying the release criteria.
14 -- - Provides API to retrieve session values
15 --
16
17 --
18 -- PACKAGE VARIABLES
19 --
20 header_id BINARY_INTEGER;
21 order_type_id BINARY_INTEGER;
22 batch_id BINARY_INTEGER;
23 batch_name VARCHAR2(30);
24 warehouse_id BINARY_INTEGER;
25 org_id BINARY_INTEGER;
26 customer_id BINARY_INTEGER;
27 ship_site_use_id BINARY_INTEGER;
28 shipment_priority VARCHAR2(30);
29 ship_method_code VARCHAR2(30);
30 from_request_date DATE;
31 to_request_date DATE;
32 from_sched_ship_date DATE;
33 to_sched_ship_date DATE;
34 existing_rsvs_only_flag VARCHAR2(1);
35 subinventory VARCHAR2(10);
36 ship_set_number BINARY_INTEGER;
37 inventory_item_id BINARY_INTEGER;
38 pick_slip_rule_id BINARY_INTEGER;
39 release_seq_rule_id BINARY_INTEGER;
40 release_seq_rule_name VARCHAR2(30);
41 departure_id BINARY_INTEGER;
42 delivery_id BINARY_INTEGER;
43 report_set_id BINARY_INTEGER;
44 include_planned_lines VARCHAR2(1);
45 backorders_flag VARCHAR2(1);
46 partial_allowed_flag VARCHAR2(1);
47 autocreate_deliveries VARCHAR2(1);
48 order_line_id BINARY_INTEGER;
49 reservations VARCHAR2(1);
50 primary_rsr VARCHAR2(30) := '';
51 application_id BINARY_INTEGER;
52 program_id BINARY_INTEGER;
53 request_id BINARY_INTEGER;
54 user_id BINARY_INTEGER;
55 login_id BINARY_INTEGER;
56 sync_line_id BINARY_INTEGER;
57
58 --
59 -- PUBLIC FUNCTIONS/PROCEDURES
60 --
61
62 --
63 -- Name
64 -- FUNCTION Init
65 --
66 -- Purpose
67 -- This function initializes variables for the session:
68 -- - Retrieves criteria for the batch and sets up session
69 -- variables
70 -- - Locks row for the batch
71 -- - Update who columns for the batch
72 --
73 -- Arguments
74 -- p_batch_id - batch to be processed
75 -- p_reservations - reservations flag
76 --
77 -- Return Values
78 -- -1 => Failure
79 -- 0 => Success
80 --
81 -- Notes
82 --
83
84 FUNCTION Init(
85 p_batch_id IN BINARY_INTEGER,
86 p_request_id IN BINARY_INTEGER,
87 p_application_id IN BINARY_INTEGER,
88 p_program_id IN BINARY_INTEGER,
89 p_user_id IN BINARY_INTEGER,
90 p_login_id IN BINARY_INTEGER,
91 p_reservations IN BINARY_INTEGER,
92 p_backorders_flag IN OUT VARCHAR2,
93 p_header_id IN OUT BINARY_INTEGER,
94 p_ship_set_number IN OUT BINARY_INTEGER,
95 p_order_type_id IN OUT BINARY_INTEGER,
96 p_warehouse_id IN OUT BINARY_INTEGER,
97 p_customer_id IN OUT BINARY_INTEGER,
98 p_ship_site_use_id IN OUT BINARY_INTEGER,
99 p_shipment_priority IN OUT VARCHAR2,
100 p_ship_method_code IN OUT VARCHAR2,
101 p_from_request_date IN OUT VARCHAR2,
102 p_to_request_date IN OUT VARCHAR2,
103 p_from_sched_ship_date IN OUT VARCHAR2,
104 p_to_sched_ship_date IN OUT VARCHAR2,
105 p_existing_rsvs_only_flag IN OUT VARCHAR2,
106 p_subinventory IN OUT VARCHAR2,
107 p_inventory_item_id IN OUT BINARY_INTEGER,
108 p_departure_id IN OUT BINARY_INTEGER,
109 p_delivery_id IN OUT BINARY_INTEGER,
110 p_pick_slip_rule_id IN OUT BINARY_INTEGER,
111 p_release_seq_rule_id IN OUT BINARY_INTEGER,
112 p_report_set_id IN OUT BINARY_INTEGER,
113 p_include_planned_lines IN OUT VARCHAR2,
114 p_partial_allowed_flag IN OUT VARCHAR2,
115 p_print_ps_mode IN OUT BINARY_INTEGER
116 )
117 RETURN BINARY_INTEGER;
118
119 --
120 -- Name
121 -- FUNCTION SRS_Picking_Batch
122 --
123 -- Purpose
124 -- This function inserts a picking batch for SRS
125 --
126 -- Arguments
127 --
128 -- Return Values
129 -- -1 => Failure
130 -- 0 => Success
131 --
132 -- Notes
133 --
134
135 FUNCTION SRS_Picking_Batch (
136 p_user_id IN BINARY_INTEGER,
137 p_login_id IN BINARY_INTEGER,
138 p_batch_prefix IN VARCHAR2,
139 p_new_batch_id IN OUT BINARY_INTEGER,
140 p_rule_name IN VARCHAR2,
141 p_doc_set IN VARCHAR2
142 )
143 RETURN BINARY_INTEGER;
144
145
146 --
147 -- Name
148 -- FUNCTION Unreleased_Line_Details
149 --
150 -- Purpose
151 -- This function creates the unreleased line details SQL
152 -- statement
153 --
154 -- Return Values
155 -- -1 => Failure
156 -- 0 => Success
157 --
158 -- Notes
159 --
160
161 FUNCTION Unreleased_Line_Details RETURN BINARY_INTEGER;
162
163
164 --
165 -- Name
166 -- FUNCTION Backordered_Line_Details
167 --
168 -- Purpose
169 -- This function creates the backordered line details SQL
170 -- statement
171 --
172 -- Return Values
173 -- -1 => Failure
174 -- 0 => Success
175 --
176 -- Notes
177 --
178
179 FUNCTION Backordered_Line_Details RETURN BINARY_INTEGER;
180
181
182 --
183 -- Name
184 -- FUNCTION Sync_Details
185 --
186 -- Purpose
187 -- This function creates the SQL statement to fetch
188 -- BOM exploded/demand synchronized line details
189 --
190 -- Return Values
191 -- -1 => Failure
192 -- 0 => Success
193 --
194 -- Notes
195 --
196
197 FUNCTION Sync_Details
198 RETURN BINARY_INTEGER;
199
200
201 --
202 -- Name
203 -- FUNCTION Non_Shippable_Lines
204 --
205 -- Purpose
206 -- This function creates the non-shippable lines SQL
207 -- statement
208 --
209 -- Return Values
210 -- -1 => Failure
211 -- 0 => Success
212 --
213 -- Notes
214 --
215
216 FUNCTION Non_Shippable_Lines RETURN BINARY_INTEGER;
217
218 --
219 -- Name
220 -- FUNCTION Construct_SQL
221 --
222 -- Purpose
223 -- This function creates the actual SQL statement based on a
224 -- parameter passed to it.
225 --
226 -- Arguments
227 -- p_sql_type is determine what kind of SQL to create
228 --
229 -- Notes
230 --
231
232 FUNCTION Construct_SQL(
233 p_sql_type IN VARCHAR2
234 )
235 RETURN BINARY_INTEGER;
236
237 --
238 -- Name
239 -- FUNCTION Get_Next_Line_Detail
240 --
241 -- Purpose
242 -- This function compares attributes of two line details
243 -- passed to it and returns the one that should be
244 -- processed earlier based on the release sequence rule.
245 --
246 -- Arguments
247 -- Attributes of a line that determine the order of
248 -- releasing the lines. These are used in conjunction
249 -- with the release sequence rule.
250 --
251 -- Return Values
252 -- 'u' => unreleased line
253 -- 'b' => backordered line
254 -- other values => Error
255 --
256 -- Notes
257 --
258
259 FUNCTION Get_Next_Line_Detail(
260 u_invoice_value IN BINARY_INTEGER,
261 b_invoice_value IN BINARY_INTEGER,
262 u_order_number IN BINARY_INTEGER,
263 b_order_number IN BINARY_INTEGER,
264 u_schedule_date IN BINARY_INTEGER,
265 b_schedule_date IN BINARY_INTEGER,
266 u_departure_date_d IN BINARY_INTEGER,
267 u_departure_date_t IN BINARY_INTEGER,
268 b_departure_date_d IN BINARY_INTEGER,
269 b_departure_date_t IN BINARY_INTEGER,
270 u_shipment_pri IN VARCHAR2,
271 b_shipment_pri IN VARCHAR2
272 )
273 RETURN VARCHAR2;
274
275
276 --
277 -- Name
278 -- FUNCTION Launch_Doc_Set
279 --
280 -- Purpose
281 -- This function launches the document set for pick release
282 --
283 -- Return Values
284 -- -1 => Failure
285 -- 0 => Success
286 --
287 -- Notes
288 --
289
290 FUNCTION Launch_Doc_Set RETURN BINARY_INTEGER;
291
292
293 --
294 -- Name
295 -- FUNCTION Get_Session_Value
296 --
297 -- Purpose
298 -- This function returns session values for other packages
299 --
300 -- Arguments
301 -- p_token - attribute whose value needs to be determined
302 --
303 -- Return Values
304 -- The value of the token in VARCHAR2 format
305 --
306 -- Notes
307 --
308
309 FUNCTION Get_Session_Value(
310 p_token IN VARCHAR2
311 )
312 RETURN VARCHAR2;
313
314
315 END WSH_PR_PICKING_SESSION;