PACKAGE: APPS.OE_RMA_RECEIVING

Source

1 Package OE_RMA_RECEIVING AUTHID CURRENT_USER As
2 /* $Header: OEXRMARS.pls 120.0.12010000.1 2008/07/25 07:54:03 appldev ship $ */
3 
4 -- Push_Receiving_Info is an OM procedure that is called by Oracle Purchasing
5 -- to push receiving information to Oracle Order Management.
6 -- This procedure is called in the Receiving, Inspection, and delivery
7 -- process of Oracle Purchasing.
8 -- For complete list of transaction types, pls see the HLD.
9 
10 -- Constant variables for transaction types
11 -- the values are from po_lookup_code table, where lookup_type is
12 -- 'RCV TRANSACTION_TYPE'.
13 
14 G_RMA_NO_PARENT         CONSTANT        VARCHAR2(30) := 'NO PARENT';
15 G_RMA_RECEIVE		CONSTANT	VARCHAR2(30) := 'RECEIVE';
16 G_RMA_CORRECT		CONSTANT	VARCHAR2(30) := 'CORRECT';
17 G_RMA_ACCEPT		CONSTANT	VARCHAR2(30) := 'ACCEPT';
18 G_RMA_REJECT		CONSTANT	VARCHAR2(30) := 'REJECT';
19 G_RMA_DELIVER		CONSTANT	VARCHAR2(30) := 'DELIVER';
20 G_RMA_MATCH 		CONSTANT 	VARCHAR2(30) := 'MATCH';
21 G_RMA_UNMATCHED_ORDER 	CONSTANT 	VARCHAR2(30) := 'UNORDERED';
22 G_RMA_RETURN_TO_CUSTOMER	CONSTANT	VARCHAR2(30) := 'RETURN TO CUSTOMER';
23 G_RMA_RETURN_TO_RECEIVING CONSTANT VARCHAR2(30) := 'RETURN TO RECEIVING';
24 
25 
26 Procedure Push_Receiving_Info(
27 p_RMA_Line_ID               IN  NUMBER,
28 p_Quantity                  IN  NUMBER,
29 p_Parent_Transaction_Type   IN  VARCHAR2,
30 p_Transaction_Type          IN  VARCHAR2,
31 p_Mismatch_Flag             IN  VARCHAR2,
32 x_Return_Status             OUT NOCOPY VARCHAR2,
33 x_Msg_Count                 OUT NOCOPY NUMBER,
34 x_MSG_Data                  OUT NOCOPY VARCHAR2,
35 p_Quantity2                 IN  NUMBER DEFAULT NULL,
36 p_R2Cust_Parent_Trn_Type    IN  VARCHAR2 DEFAULT NULL
37 );
38 
39 Function Get_Open_Line_Id (p_line_rec OE_ORDER_PUB.Line_Rec_Type)
40 RETURN NUMBER;
41 
42 Procedure Get_RMA_Available_Quantity(
43 		p_RMA_Line_ID   	In Number,
44 x_Quantity out nocopy Number,
45 
46 x_Return_Status out nocopy Varchar2,
47 
48 x_Msg_Count out nocopy Number,
49 
50 x_MSG_Data out nocopy Varchar2);
51 
52 
53 Procedure Get_RMA_Tolerances(
54 		p_RMA_Line_ID   		In Number,
55 x_Under_Return_Tolerance out nocopy Number,
56 
57 x_Over_Return_Tolerance out nocopy Number,
58 
59 x_Return_Status out nocopy Varchar2,
60 
61 x_Msg_Count out nocopy Number,
62 
63 x_MSG_Data out nocopy Varchar2
64 
65 		);
66 End;