DBA Data[Home] [Help]

PACKAGE: APPS.OE_ACKNOWLEDGMENT_PVT

Source


1 PACKAGE OE_Acknowledgment_Pvt AS
2 /* $Header: OEXVACKS.pls 120.0.12010000.1 2008/07/25 07:58:06 appldev ship $ */
3 
4 /* -------------------------------------------------------------------
5 --  Start of Comments
6 --  API name    OE_Acknowledgment_Pvt
7 --  Type        Private
8 --  Function
9 --
10 --  Pre-reqs
11 --
12 --  Parameters
13 --
14 --  Version     Current version = 1.0
15 --              Initial version = 1.0
16 --
17 --  Notes
18 --
19 --  End of Comments
20 --  ------------------------------------------------------------------
21 */
22 
23 PROCEDURE Process_Acknowledgment
24 (p_api_version_number            IN  NUMBER
25 ,p_init_msg_list                 IN  VARCHAR2 := FND_API.G_FALSE
26 
27 ,p_header_rec                    IN  OE_Order_Pub.Header_Rec_Type :=
28                                      OE_Order_Pub.G_MISS_HEADER_REC
29 ,p_header_val_rec                IN  OE_Order_Pub.Header_Val_Rec_Type :=
30                                      OE_Order_Pub.G_MISS_HEADER_VAL_REC
31 ,p_Header_Adj_tbl                IN  OE_Order_Pub.Header_Adj_Tbl_Type :=
32                                      OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
33 ,p_Header_Adj_val_tbl            IN  OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
34                                      OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
35 ,p_Header_Scredit_tbl            IN  OE_Order_Pub.Header_Scredit_Tbl_Type :=
36                                      OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
37 ,p_Header_Scredit_val_tbl        IN  OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
38                                      OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
39 ,p_line_tbl                      IN  OE_Order_Pub.Line_Tbl_Type :=
40                                      OE_Order_Pub.G_MISS_LINE_TBL
41 ,p_line_val_tbl                  IN  OE_Order_Pub.Line_Val_Tbl_Type :=
42                                      OE_Order_Pub.G_MISS_LINE_VAL_TBL
43 ,p_Line_Adj_tbl                  IN  OE_Order_Pub.Line_Adj_Tbl_Type :=
44                                      OE_Order_Pub.G_MISS_LINE_ADJ_TBL
45 ,p_Line_Adj_val_tbl              IN  OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
46                                      OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
47 ,p_Line_Scredit_tbl              IN  OE_Order_Pub.Line_Scredit_Tbl_Type :=
48                                      OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
49 ,p_Line_Scredit_val_tbl          IN  OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
50                                      OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
51 ,p_Lot_Serial_tbl                IN  OE_Order_Pub.Lot_Serial_Tbl_Type :=
52                                      OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
53 ,p_Lot_Serial_val_tbl            IN  OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
54                                      OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL
55 ,p_action_request_tbl	    	 IN  OE_Order_Pub.Request_Tbl_Type :=
56  				     OE_Order_Pub.G_MISS_REQUEST_TBL
57 
58 ,p_old_header_rec                IN  OE_Order_Pub.Header_Rec_Type :=
59                                      OE_Order_Pub.G_MISS_HEADER_REC
60 ,p_old_header_val_rec            IN  OE_Order_Pub.Header_Val_Rec_Type :=
61                                      OE_Order_Pub.G_MISS_HEADER_VAL_REC
62 ,p_old_Header_Adj_tbl            IN  OE_Order_Pub.Header_Adj_Tbl_Type :=
63                                      OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
64 ,p_old_Header_Adj_val_tbl        IN  OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
65                                      OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
66 ,p_old_Header_Scredit_tbl        IN  OE_Order_Pub.Header_Scredit_Tbl_Type :=
67                                      OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
68 ,p_old_Header_Scredit_val_tbl    IN  OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
69                                      OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
70 ,p_old_line_tbl                  IN  OE_Order_Pub.Line_Tbl_Type :=
71                                      OE_Order_Pub.G_MISS_LINE_TBL
72 ,p_old_line_val_tbl              IN  OE_Order_Pub.Line_Val_Tbl_Type :=
73                                      OE_Order_Pub.G_MISS_LINE_VAL_TBL
74 ,p_old_Line_Adj_tbl              IN  OE_Order_Pub.Line_Adj_Tbl_Type :=
75                                      OE_Order_Pub.G_MISS_LINE_ADJ_TBL
76 ,p_old_Line_Adj_val_tbl          IN  OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
77                                      OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
78 ,p_old_Line_Scredit_tbl          IN  OE_Order_Pub.Line_Scredit_Tbl_Type :=
79                                      OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
80 ,p_old_Line_Scredit_val_tbl      IN  OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
81                                      OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
82 ,p_old_Lot_Serial_tbl            IN  OE_Order_Pub.Lot_Serial_Tbl_Type :=
83                                      OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
84 ,p_old_Lot_Serial_val_tbl        IN  OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
85                                      OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL
86 
87 ,p_buyer_seller_flag             IN  VARCHAR2 DEFAULT 'B'
88 ,p_reject_order                  IN  VARCHAR2 DEFAULT 'N'
89 
90 ,x_return_status                 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
91 );
92 
93 
94 Procedure Process_Acknowledgment
95  (p_header_rec                   In   OE_Order_Pub.Header_Rec_Type,
96   p_line_tbl                     In   OE_Order_Pub.Line_Tbl_Type,
97   p_old_header_rec               In   OE_Order_Pub.Header_Rec_Type,
98   p_old_line_tbl                 In   OE_Order_Pub.Line_Tbl_Type,
99   x_return_status                Out NOCOPY /* file.sql.39 change */  VARCHAR2
100  );
101 
102 END OE_Acknowledgment_Pvt;
103