1 PACKAGE CSP_MO_MTLTXNS_UTIL AUTHID CURRENT_USER AS
2 /* $Header: cspgtmus.pls 115.11 2002/11/26 06:48:41 hhaugeru ship $ */
3 -- Start of Comments
4 -- Package name : CSP_MO_MTLTXNS_UTIL
5 -- Purpose : This package includes the procedures that handle material transactions associated with any move orders.
6 -- History
7 -- 29-Dec-99, Vernon Lou.
8 --
9 -- NOTE :
10 -- End of Comments
11
12 /*
13 PROCEDURE move_order_lines_txn (
14 -- This procedure takes a move order line ID as parameters. And then call the appropriate API for material
15 -- transactions.
16 P_Api_Version_Number IN NUMBER,
17 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
18 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
19 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
20 p_organization_id IN NUMBER,
21 p_move_order_line_id IN NUMBER,
22 X_Return_Status OUT NOCOPY VARCHAR2,
23 X_Msg_Count OUT NOCOPY NUMBER,
24 X_Msg_Data OUT NOCOPY VARCHAR2
25 );
26 */
27
28 PROCEDURE update_order_line_status(
29 P_Api_Version_Number IN NUMBER,
30 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
31 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
32 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
33 p_organization_id IN NUMBER,
34 p_move_order_line_id IN NUMBER,
35 X_Return_Status OUT NOCOPY VARCHAR2,
36 X_Msg_Count OUT NOCOPY NUMBER,
37 X_Msg_Data OUT NOCOPY VARCHAR2
38 );
39
40
41 FUNCTION validate_mo_line_status (
42 p_move_order_header_id IN NUMBER,
43 p_status_to_be_validated IN NUMBER)
44 RETURN VARCHAR2;
45
46 PROCEDURE confirm_receipt (
47 P_Api_Version_Number IN NUMBER,
48 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
49 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
50 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
51 p_packlist_line_id IN NUMBER,
52 p_organization_id IN NUMBER,
53 p_transaction_temp_id IN NUMBER,
54 p_quantity_received IN NUMBER,
55 p_to_subinventory_code IN VARCHAR2 := NULL,
56 p_to_locator_id IN NUMBER := NULL,
57 p_serial_number IN VARCHAR2 := NULL,
58 p_lot_number IN VARCHAR2 := NULL,
59 p_revision IN VARCHAR2 := NULL,
60 p_receiving_option IN NUMBER := 0, --0 = receiving normal, 1 = receipt short, 2 = over receipt (but do not close the packlist and move order, 3 = over receipt (close everything)
61 px_transaction_header_id IN OUT NOCOPY NUMBER,
62 p_process_flag IN VARCHAR2 := FND_API.G_FALSE,
63 X_Return_Status OUT NOCOPY VARCHAR2,
64 X_Msg_Count OUT NOCOPY NUMBER,
65 X_Msg_Data OUT NOCOPY VARCHAR2
66 );
67
68 Procedure Transact_Serial_Lots (
69 -- This procedure was created specifically for CSP confirm receipt transactions.
70 p_new_transaction_temp_id IN NUMBER,
71 p_old_transaction_temp_id IN NUMBER,
72 p_lot_number IN VARCHAR2,
73 p_serial_number IN VARCHAR2,
74 p_qty_received IN NUMBER,
75 X_Return_Status OUT NOCOPY VARCHAR2,
76 X_Msg_Count OUT NOCOPY NUMBER,
77 X_Msg_Data OUT NOCOPY VARCHAR2 );
78
79
80 FUNCTION Convert_Temp_UOM (p_csp_mtltxn_rec IN OUT NOCOPY CSP_MATERIAL_TRANSACTIONS_PVT.CSP_Rec_Type,
81 p_quantity_convert IN NUMBER)
82 RETURN VARCHAR2;
83
84 Function Clean_Up (p_transaction_temp_id IN NUMBER)
85 Return VARCHAR2;
86
87 Function Get_CSP_Acccount_ID (p_organization_id NUMBER)
88 Return NUMBER;
89
90 Procedure Under_Over_Receipt (
91 p_transaction_temp_id IN NUMBER,
92 p_receiving_option IN NUMBER,
93 px_transaction_header_id IN OUT NOCOPY NUMBER,
94 p_discrepancy_qty IN NUMBER := 0,
95 X_Return_Status OUT NOCOPY VARCHAR2,
96 X_Msg_Count OUT NOCOPY NUMBER,
97 X_Msg_Data OUT NOCOPY VARCHAR2);
98
99 Function Call_Online (p_transaction_header_id NUMBER)
100 Return Boolean;
101
102
103 END CSP_MO_MTLTXNS_UTIL;