[Home] [Help]
PACKAGE: APPS.ASO_ORDER_FEEDBACK_GET_PVT
Source
1 PACKAGE ASO_ORDER_FEEDBACK_GET_PVT AS
2 /* $Header: asovomgs.pls 120.1 2005/06/29 12:42:33 appldev ship $ */
3
4 -- ---------------------------------------------------------
5 -- Declare Data Types
6 -- ---------------------------------------------------------
7
8 -- ---------------------------------------------------------
9 -- Declare Procedures
10 -- ---------------------------------------------------------
11
12 --------------------------------------------------------------------------
13 -- Start of comments
14 -- API name : GET_NOTICE
15 -- Type : Private
16 -- Function : This API is the PRIVATE API that is invoked by CRM Apps
17 -- to get the data regarding changes (inserts/updates/deletes) to the
18 -- Order Entities communicated by the Order Management application.
19 -- Pre-reqs : None.
20 --
21 -- Standard IN Parameters:
22 -- p_api_version IN NUMBER Required
23 -- p_init_msg_list IN VARCHAR2 Optional
24 -- Default = FND_API.G_FALSE
25 -- p_commit IN VARCHAR2 Optional
26 -- Default = FND_API.G_FALSE
27 --
28 -- Standard OUT NOCOPY /* file.sql.39 change */ Parameters:
29 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2(1)
30 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
31 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2(2000)
32 --
33 -- GET_NOTICE API specific IN Parameters:
34 -- p_app_short_name IN VARCHAR2 Required
35 -- p_queue_type IN VARCHAR2 Optional
36 -- Default = OF_QUEUE
37 -- p_dequeue_mode IN NUMBER Optional
38 -- Default = DBMS_AQ.REMOVE
39 -- p_navigation IN NUMBER Optional
40 -- Default = DBMS_AQ.FIRST_MESSAGE
41 -- p_wait IN NUMBER Optional
42 -- Default = DBMS_AQ.NO_WAIT
43 --
44 -- GET_NOTICE API specific OUT NOCOPY /* file.sql.39 change */ Parameters:
45 --
46 -- x_no_more_messages OUT NOCOPY /* file.sql.39 change */ VARCHAR2
47 -- x_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type
48 -- x_old_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type
49 -- x_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type
50 -- x_old_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type
51 -- x_Header_price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type
52 -- x_old_Header_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type
53 -- x_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type
54 -- x_old_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type
55 -- x_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
56 -- x_old_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
57 -- x_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type
58 -- x_old_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type
59 -- x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type
60 -- x_old_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type
61 -- x_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type
62 -- x_old_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type
63 -- x_Line_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type
64 -- x_old_Line_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type
65 -- x_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type
66 -- x_old_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type
67 -- x_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
68 -- x_old_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
69 -- x_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type
70 -- x_old_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type
71 -- x_Lot_Serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type
72 -- x_old_Lot_Serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type
73 -- x_action_request_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Request_Tbl_Type
74 --
75 --
76 -- Version : Current version 1.0
77 -- Initial version 1.0
78 --
79 -- End of comments
80 --------------------------------------------------------------------------
81
82 PROCEDURE GET_NOTICE
83 (
84 p_api_version IN NUMBER,
85 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
86 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
87 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
88 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
89 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
90 p_app_short_name IN VARCHAR2,
91 p_queue_type IN VARCHAR2 DEFAULT 'OF_QUEUE',
92 p_dequeue_mode IN NUMBER DEFAULT DBMS_AQ.REMOVE,
93 p_navigation IN NUMBER DEFAULT DBMS_AQ.FIRST_MESSAGE,
94 p_wait IN NUMBER DEFAULT DBMS_AQ.NO_WAIT,
95 x_no_more_messages OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
96 x_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type,
97 x_old_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type,
98 x_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type,
99 x_old_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type,
100 x_Header_price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type,
101 x_old_Header_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type,
102 x_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type,
103 x_old_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type,
104 x_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type,
105 x_old_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type,
106 x_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type,
107 x_old_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type,
108 x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type,
109 x_old_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type,
110 x_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type,
111 x_old_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type,
112 x_Line_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type,
113 x_old_Line_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type,
114 x_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type,
115 x_old_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type,
116 x_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type,
117 x_old_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type,
118 x_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type,
119 x_old_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type,
120 x_Lot_Serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type,
121 x_old_Lot_Serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type,
122 x_action_request_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Request_Tbl_Type
123 );
124
125
126 END ASO_ORDER_FEEDBACK_GET_PVT;