[Home] [Help]
PACKAGE: APPS.CSP_PL_SHIP_UTIL
Source
1 Package CSP_PL_SHIP_UTIL AUTHID CURRENT_USER AS
2 /* $Header: cspgtpss.pls 115.6 2002/11/26 06:50:13 hhaugeru ship $ */
3 -- Start of comments
4 --
5 -- API name : CSP_PL_SHIP_UTIL
6 -- Type : PUBLIC
7 -- Purpose : Wrapper to handle material transactions when a packlist is shipped.
8 --
9 -- Modification History
10 -- Date Userid Comments
11 -- --------- ------ ------------------------------------------
12 -- 01/04/99 klou created
13 --
14 -- Note :
15 -- End of comments
16
17 PROCEDURE Confirm_Ship (
18 P_Api_Version_Number IN NUMBER,
19 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
20 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
21 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
22 p_packlist_header_id IN NUMBER,
23 p_organization_id IN NUMBER,
24 x_return_status OUT NOCOPY VARCHAR2,
25 x_msg_count OUT NOCOPY NUMBER,
26 x_msg_data OUT NOCOPY VARCHAR2
27 );
28
29 Procedure Update_Packlist_Sts_Qty (
30 P_Api_Version_Number IN NUMBER,
31 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
32 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
33 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
34 p_organization_id IN NUMBER,
35 p_packlist_line_id IN NUMBER,
36 p_line_status IN VARCHAR2,
37 p_quantity_packed IN NUMBER,
38 p_quantity_shipped IN NUMBER,
39 p_quantity_received IN NUMBER,
40 x_return_status OUT NOCOPY VARCHAR2,
41 x_msg_count OUT NOCOPY NUMBER,
42 x_msg_data OUT NOCOPY VARCHAR2
43 );
44
45
46 FUNCTION validate_pl_line_status (
47 p_packlist_header_id IN NUMBER,
48 p_status_to_be_validated IN VARCHAR2,
49 p_check_receipt_short BOOLEAN := FALSE)
50 RETURN VARCHAR2;
51
52
53 Procedure update_packlist_header_sts (
54 P_Api_Version_Number IN NUMBER,
55 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
56 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
57 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
58 p_packlist_header_id IN NUMBER,
59 p_organization_id IN NUMBER,
60 p_packlist_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
61 x_return_status OUT NOCOPY VARCHAR2,
62 x_msg_count OUT NOCOPY NUMBER,
63 x_msg_data OUT NOCOPY VARCHAR2
64
65 );
66
67 END; -- Package spec