PACKAGE: APPS.OE_OE_FORM_CANCEL_LINE

Source

1 PACKAGE OE_OE_FORM_CANCEL_LINE AUTHID CURRENT_USER AS
2 /* $Header: OEXFCANS.pls 120.1 2005/06/22 11:24:19 appldev ship $ */
3 
4 --  Start of Comments
5 --  API name    Process_Order
6 --  Type        Private
7 --  Function
8 --
9 --  Pre-reqs
10 --
11 --  Parameters
12 --
13 --  Version     Current version = 1.0
14 --              Initial version = 1.0
15 --
16 --  Notes
17 --
18 --  End of Comments
19 
20 G_PKG_NAME         VARCHAR2(30) := 'OE_OE_FORM_CANCEL_LINE';
21 COMMIT_EXIT_ON_ERROR        NUMBER := 1;
22 ROLLBACK_EXIT_ON_ERROR      NUMBER := 2;
23 COMMIT_SHOW_ERROR           NUMBER := 3;
24 ASK_COMMIT                  NUMBER := 4;
25 IS_MASS_CHANGE          VARCHAR2(1) := 'F';
26 /* Added for bug 2965878 */
27 g_record_ids   OE_GLOBALS.Selected_Record_Tbl;
28 g_num_of_records  NUMBER:=0;
29 g_ord_lvl_can boolean :=FALSE;-- For bug# 2922468.
30 procedure Process_cancel_quantity
31 (    p_num_of_records       IN NUMBER
32     ,p_record_ids           IN OE_GLOBALS.Selected_Record_Tbl -- MOAC
33     ,p_cancel_to_quantity   IN NUMBER
34     ,p_cancellation_comments IN VARCHAR2
35     ,p_reason_code          IN VARCHAR2
36     ,p_cancellation_type    IN VARCHAR2
37     ,p_mc_err_handling_flag IN NUMBER := FND_API.G_MISS_NUM
38     ,x_msg_count            OUT NOCOPY /* file.sql.39 change */ NUMBER
39     ,x_msg_data             OUT NOCOPY /* file.sql.39 change */ VARCHAR2
40     ,x_return_status        OUT NOCOPY /* file.sql.39 change */ VARCHAR2
41     ,x_error_count          OUT NOCOPY /* file.sql.39 change */ NUMBER);
42 
43 
44 procedure Process_cancel_order
45 (    p_num_of_records       IN NUMBER
46     ,p_record_ids           IN OE_GLOBALS.Selected_Record_Tbl -- MOAC
47     ,p_cancellation_comments IN VARCHAR2
48     ,p_reason_code          IN VARCHAR2
49     ,p_mc_err_handling_flag IN NUMBER := FND_API.G_MISS_NUM
50     ,x_msg_count            OUT NOCOPY /* file.sql.39 change */ NUMBER
51     ,x_msg_data             OUT NOCOPY /* file.sql.39 change */ VARCHAR2
52     ,x_return_status        OUT NOCOPY /* file.sql.39 change */ VARCHAR2
53     ,x_error_count          OUT NOCOPY /* file.sql.39 change */ NUMBER);
54 
55 -- Fix for bug 2259556.We pass p_num_of_records and p_record_ids as IN parameters
56 Procedure Cancel_Remaining_Order(p_num_of_records IN NUMBER,
57                 p_record_ids IN OE_GLOBALS.Selected_Record_Tbl, -- MOAC
58 		 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
59     		p_cancellation_comments IN VARCHAR2,
60     		p_reason_code          IN VARCHAR2,
61     	      x_msg_count OUT NOCOPY /* file.sql.39 change */ number,
62 		 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
63 
64 Procedure Call_Process_Order ( p_line_tbl IN OE_ORDER_PUB.LINE_TBL_TYPE,
65                                p_old_line_tbl IN OE_ORDER_PUB.LINE_TBL_TYPE,
66                                 x_return_status  OUT NOCOPY VARCHAR2);
67 
68 END OE_OE_FORM_CANCEL_LINE;