1 PACKAGE OE_RMA_GRP AUTHID CURRENT_USER AS
2 /* $Header: OEXGRMAS.pls 120.0 2005/05/31 23:24:07 appldev noship $ */
3
4 /*
5 ** Create a Record Type for Passing the Result of Is_Over_Return()
6 */
7 TYPE Over_Return_Err_Rec_Type IS RECORD
8 ( line_id NUMBER
9 , previous_quantity NUMBER
10 , current_quantity NUMBER
11 , original_quantity NUMBER
12 , return_status VARCHAR2(30)
13 , msg_count NUMBER
14 , msg_data VARCHAR2(2000)
15 );
16
17 TYPE Over_Return_Err_Tbl_Type IS TABLE OF Over_Return_Err_Rec_Type
18 INDEX BY BINARY_INTEGER;
19
20 /*
21 ** Submit_Ordeer() will progress the return order header forward
22 ** from Awaiting Submission once the user submits the order.
23 */
24 PROCEDURE Submit_Order(
25 p_api_version IN NUMBER
26 , p_header_id IN NUMBER
27 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
28 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
29 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
30 );
31
32 /*
33 ** Is_Over_Return() will check if returned qty matches the original
34 ** ordered qty. If returned qty exceeds the original ordered qty, the
35 ** API will raise an error.
36 **
37 ** NOTE that this api even looks at Unbooked Return Lines, which is
38 ** different from the Is_Over_Return() procedure in OE_LINE_UTIL Package.
39 */
40 PROCEDURE Is_Over_Return(
41 p_api_version IN NUMBER
42 , p_line_tbl IN OE_ORDER_PUB.LINE_TBL_TYPE
43 , x_error_tbl OUT NOCOPY /* file.sql.39 change */ OE_RMA_GRP.OVER_RETURN_ERR_TBL_TYPE
44 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
45 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
46 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
47 );
48
49 /*
50 ** Post_Approval_Process() will be called from workflow activity to do
51 ** some post approval steps. For example it will call iStore API that
52 ** sends the notification on approval of the return order to the end user.
53 */
54 PROCEDURE Post_Approval_Process(
55 itemtype IN VARCHAR2
56 , itemkey IN VARCHAR2
57 , actid IN NUMBER
58 , funcmode IN VARCHAR2
59 , resultout IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
60 );
61
62 /*
63 ** Post_Rejection_Process() will set the reason for rejecting the RMA
64 ** into OE_REASONS table. It will also call iStore API that sends the
65 ** notification on rejection of the return order to the end user.
66 */
67 PROCEDURE Post_Rejection_Process(
68 itemtype IN VARCHAR2
69 , itemkey IN VARCHAR2
70 , actid IN NUMBER
71 , funcmode IN VARCHAR2
72 , resultout IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
73 );
74
75 END OE_RMA_GRP;