[Home] [Help]
PACKAGE: APPS.GMI_PR_PICK_SLIP_NUMBER
Source
1 PACKAGE GMI_PR_PICK_SLIP_NUMBER AUTHID CURRENT_USER AS
2 /* $Header: GMIUSLPS.pls 120.0 2005/05/26 00:14:28 appldev noship $ */
3 /*
4 +===========================================================================+
5 | Copyright (c) 2000 Oracle Corporation |
6 | Thames Valley Park, United Kingdom |
7 | All rights reserved. |
8 +===========================================================================+
9 */
10 /*
11 Package
12 GMI_PR_PICK_SLIP_NUMBER
13
14 Purpose (direct copy of WSHPRPNS.pls)
15 This package does the following:
16 - Initialize variables to be used
17 in determining the how to group pick slips.
18 - Get pick slip number
19 - Print Pick Slip Report
20
21
22
23 PUBLIC FUNCTIONS/PROCEDURES
24
25
26
27 Name
28 PROCEDURE Print_Pick_Slip
29
30 Purpose
31 This function prints a Pick Slip for a given Pick Slip number
32 or all Pick Slips for the session
33
34 Input Parameters
35 p_pick_slip_number => pick slip number
36 p_report_set_id => report set
37 If p_report_set_id IS NULL, procedure returns. No printing.
38
39 Output Parameters
40 x_api_status => FND_API.G_RET_STS_SUCESSS or
41 FND_API.G_RET_STS_ERROR or
42 FND_API.G_RET_STS_UNEXP_ERROR
43 x_error_message => Error message
44 */
45
46 -- HW BUG#:2643440 Removed FND_API.G_MISS_NUM from p_pick_slip_number
47 -- and replaced it with NULL
48 PROCEDURE Print_Pick_Slip (
49 p_pick_slip_number IN NUMBER DEFAULT NULL,
50 p_report_set_id IN NUMBER,
51 p_organization_id IN NUMBER,
52 x_api_status OUT NOCOPY VARCHAR2,
53 x_error_message OUT NOCOPY VARCHAR2 );
54
55 /*
56 Name
57 PROCEDURE Get_Pick_Slip_Number
58
59 Purpose
60 Returns pick slip number and whether a Pick Slip
61 should be printed
62
63 Input Parameters
64 p_ps_mode => pick slip print mode: I=immed, E=deferred
65 p_pick_grouping_rule_id => pick grouping rule id
66 p_org_id => organization_id
67 p_header_id => order header id
68 p_customer_id => customer id
69 p_ship_method_code => ship method
70 p_ship_to_loc_id => ship to location
71 p_shipment_priority => shipment priority
72 p_subinventory => subinventory
73 p_trip_stop_id => trip stop
74 p_delivery_id => delivery
75 p_inventory_item_id => inventory item id
76 p_locator_id => locator id
77 p_lot_number => lot number
78 p_revision => revision
79
80 Output Parameters
81 x_pick_slip_number => pick_slip_number
82 x_ready_to_print => FND_API.G_TRUE or FND_API.G_FALSE
83 x_api_status => FND_API.G_RET_STS_SUCESSS or
84 FND_API.G_RET_STS_ERROR
85 x_error_message => Error message
86 */
87
88 PROCEDURE Get_Pick_Slip_Number (
89 p_ps_mode IN VARCHAR2,
90 p_pick_grouping_rule_id IN NUMBER,
91 p_org_id IN NUMBER,
92 p_header_id IN NUMBER,
93 p_customer_id IN NUMBER,
94 p_ship_method_code IN VARCHAR2,
95 p_ship_to_loc_id IN NUMBER,
96 p_shipment_priority IN VARCHAR2,
97 p_subinventory IN VARCHAR2,
98 p_trip_stop_id IN NUMBER,
99 p_delivery_id IN NUMBER,
100 p_inventory_item_id IN NUMBER DEFAULT NULL,
101 p_locator_id IN NUMBER DEFAULT NULL,
102 p_lot_number IN VARCHAR2 DEFAULT NULL,
103 p_revision IN VARCHAR2 DEFAULT NULL,
104 x_pick_slip_number OUT NOCOPY NUMBER,
105 x_ready_to_print OUT NOCOPY VARCHAR2,
106 x_api_status OUT NOCOPY VARCHAR2,
107 x_error_message OUT NOCOPY VARCHAR2 );
108
109 END GMI_PR_PICK_SLIP_NUMBER;