[Home] [Help]
PACKAGE: APPS.CN_COLLECTION_AIA_PUB
Source
1 PACKAGE CN_COLLECTION_AIA_PUB AUTHID CURRENT_USER AS
2 /* $Header: CNPCLTRS.pls 120.3 2009/09/09 06:28:13 rajukum noship $*/
3 CN_AIA_REQ_FIELD_NOT_SET_ERROR EXCEPTION;
4 G_LOC_MISS_NUM CONSTANT NUMBER := 9.99E14;
5
6 TYPE aia_rec_type IS RECORD
7 (
8 SALESREP_ID number := G_LOC_MISS_NUM,
9 EMPLOYEE_NUMBER varchar2(30) := FND_API.G_MISS_CHAR,
10 PROCESSED_DATE varchar2(30) := FND_API.G_MISS_CHAR,
11 INVOICE_NUMBER varchar2(20) := FND_API.G_MISS_CHAR,
12 INVOICE_DATE varchar2(30) := FND_API.G_MISS_CHAR,
13 TRANSACTION_AMOUNT number := G_LOC_MISS_NUM,
14 TRANSACTION_CURRENCY_CODE varchar2(15) := FND_API.G_MISS_CHAR,
15 TRX_TYPE varchar2(30) := 'AIA',
16 REVENUE_TYPE varchar2(15) := 'REVENUE',
17 ADJUST_COMMENTS varchar2(240) := FND_API.G_MISS_CHAR,
18 SOURCE_DOC_ID number := G_LOC_MISS_NUM,
19 ATTRIBUTE1 varchar2(240) := FND_API.G_MISS_CHAR,
20 ATTRIBUTE2 varchar2(240) := FND_API.G_MISS_CHAR,
21 ATTRIBUTE3 varchar2(240) := FND_API.G_MISS_CHAR,
22 ATTRIBUTE4 varchar2(240) := FND_API.G_MISS_CHAR,
23 ATTRIBUTE5 varchar2(240) := FND_API.G_MISS_CHAR,
24 ATTRIBUTE6 varchar2(240) := FND_API.G_MISS_CHAR,
25 ATTRIBUTE7 varchar2(240) := FND_API.G_MISS_CHAR,
26 ATTRIBUTE8 varchar2(240) := FND_API.G_MISS_CHAR,
27 ATTRIBUTE9 varchar2(240) := FND_API.G_MISS_CHAR,
28 ATTRIBUTE10 varchar2(240) := FND_API.G_MISS_CHAR,
29 ATTRIBUTE11 varchar2(240) := FND_API.G_MISS_CHAR,
30 ATTRIBUTE12 varchar2(240) := FND_API.G_MISS_CHAR,
31 ATTRIBUTE13 varchar2(240) := FND_API.G_MISS_CHAR,
32 ATTRIBUTE14 varchar2(240) := FND_API.G_MISS_CHAR,
33 ATTRIBUTE15 varchar2(240) := FND_API.G_MISS_CHAR,
34 ATTRIBUTE16 varchar2(240) := FND_API.G_MISS_CHAR,
35 ATTRIBUTE17 varchar2(240) := FND_API.G_MISS_CHAR,
36 ATTRIBUTE18 varchar2(240) := FND_API.G_MISS_CHAR,
37 ATTRIBUTE19 varchar2(240) := FND_API.G_MISS_CHAR,
38 ATTRIBUTE20 varchar2(240) := FND_API.G_MISS_CHAR,
39 ATTRIBUTE21 varchar2(240) := FND_API.G_MISS_CHAR,
40 ATTRIBUTE22 varchar2(240) := FND_API.G_MISS_CHAR,
41 ATTRIBUTE23 varchar2(240) := FND_API.G_MISS_CHAR,
42 ATTRIBUTE24 varchar2(240) := FND_API.G_MISS_CHAR,
43 ATTRIBUTE25 varchar2(240) := FND_API.G_MISS_CHAR,
44 ATTRIBUTE26 varchar2(240) := FND_API.G_MISS_CHAR,
45 ATTRIBUTE27 varchar2(240) := FND_API.G_MISS_CHAR,
46 ATTRIBUTE28 varchar2(240) := FND_API.G_MISS_CHAR,
47 ATTRIBUTE29 varchar2(240) := FND_API.G_MISS_CHAR,
48 ATTRIBUTE30 varchar2(240) := FND_API.G_MISS_CHAR,
49 ATTRIBUTE31 varchar2(240) := FND_API.G_MISS_CHAR,
50 ATTRIBUTE32 varchar2(240) := FND_API.G_MISS_CHAR,
51 ATTRIBUTE33 varchar2(240) := FND_API.G_MISS_CHAR,
52 ATTRIBUTE34 varchar2(240) := FND_API.G_MISS_CHAR,
53 ATTRIBUTE35 varchar2(240) := FND_API.G_MISS_CHAR,
54 ATTRIBUTE36 varchar2(240) := FND_API.G_MISS_CHAR,
55 ATTRIBUTE37 varchar2(240) := FND_API.G_MISS_CHAR,
56 ATTRIBUTE38 varchar2(240) := FND_API.G_MISS_CHAR,
57 ATTRIBUTE39 varchar2(240) := FND_API.G_MISS_CHAR,
58 ATTRIBUTE40 varchar2(240) := FND_API.G_MISS_CHAR,
59 ATTRIBUTE41 varchar2(240) := FND_API.G_MISS_CHAR,
60 ATTRIBUTE42 varchar2(240) := FND_API.G_MISS_CHAR,
61 ATTRIBUTE43 varchar2(240) := FND_API.G_MISS_CHAR,
62 ATTRIBUTE44 varchar2(240) := FND_API.G_MISS_CHAR,
63 ATTRIBUTE45 varchar2(240) := FND_API.G_MISS_CHAR,
64 ATTRIBUTE46 varchar2(240) := FND_API.G_MISS_CHAR,
65 ATTRIBUTE47 varchar2(240) := FND_API.G_MISS_CHAR,
66 ATTRIBUTE48 varchar2(240) := FND_API.G_MISS_CHAR,
67 ATTRIBUTE49 varchar2(240) := FND_API.G_MISS_CHAR,
68 ATTRIBUTE50 varchar2(240) := FND_API.G_MISS_CHAR,
69 ATTRIBUTE51 varchar2(240) := FND_API.G_MISS_CHAR,
70 ATTRIBUTE52 varchar2(240) := FND_API.G_MISS_CHAR,
71 ATTRIBUTE53 varchar2(240) := FND_API.G_MISS_CHAR,
72 ATTRIBUTE54 varchar2(240) := FND_API.G_MISS_CHAR,
73 ATTRIBUTE55 varchar2(240) := FND_API.G_MISS_CHAR,
74 ATTRIBUTE56 varchar2(240) := FND_API.G_MISS_CHAR,
75 ATTRIBUTE57 varchar2(240) := FND_API.G_MISS_CHAR,
76 ATTRIBUTE58 varchar2(240) := FND_API.G_MISS_CHAR,
77 ATTRIBUTE59 varchar2(240) := FND_API.G_MISS_CHAR,
78 ATTRIBUTE60 varchar2(240) := FND_API.G_MISS_CHAR,
79 ATTRIBUTE61 varchar2(240) := FND_API.G_MISS_CHAR,
80 ATTRIBUTE62 varchar2(240) := FND_API.G_MISS_CHAR,
81 ATTRIBUTE63 varchar2(240) := FND_API.G_MISS_CHAR,
82 ATTRIBUTE64 varchar2(240) := FND_API.G_MISS_CHAR,
83 ATTRIBUTE65 varchar2(240) := FND_API.G_MISS_CHAR,
84 ATTRIBUTE66 varchar2(240) := FND_API.G_MISS_CHAR,
85 ATTRIBUTE67 varchar2(240) := FND_API.G_MISS_CHAR,
86 ATTRIBUTE68 varchar2(240) := FND_API.G_MISS_CHAR,
87 ATTRIBUTE69 varchar2(240) := FND_API.G_MISS_CHAR,
88 ATTRIBUTE70 varchar2(240) := FND_API.G_MISS_CHAR,
89 ATTRIBUTE71 varchar2(240) := FND_API.G_MISS_CHAR,
90 ATTRIBUTE72 varchar2(240) := FND_API.G_MISS_CHAR,
91 ATTRIBUTE73 varchar2(240) := FND_API.G_MISS_CHAR,
92 ATTRIBUTE74 varchar2(240) := FND_API.G_MISS_CHAR,
93 ATTRIBUTE75 varchar2(240) := FND_API.G_MISS_CHAR,
94 ATTRIBUTE76 varchar2(240) := FND_API.G_MISS_CHAR,
95 ATTRIBUTE77 varchar2(240) := FND_API.G_MISS_CHAR,
96 ATTRIBUTE78 varchar2(240) := FND_API.G_MISS_CHAR,
97 ATTRIBUTE79 varchar2(240) := FND_API.G_MISS_CHAR,
98 ATTRIBUTE80 varchar2(240) := FND_API.G_MISS_CHAR,
99 ATTRIBUTE81 varchar2(240) := FND_API.G_MISS_CHAR,
100 ATTRIBUTE82 varchar2(240) := FND_API.G_MISS_CHAR,
101 ATTRIBUTE83 varchar2(240) := FND_API.G_MISS_CHAR,
102 ATTRIBUTE84 varchar2(240) := FND_API.G_MISS_CHAR,
103 ATTRIBUTE85 varchar2(240) := FND_API.G_MISS_CHAR,
104 ATTRIBUTE86 varchar2(240) := FND_API.G_MISS_CHAR,
105 ATTRIBUTE87 varchar2(240) := FND_API.G_MISS_CHAR,
106 ATTRIBUTE88 varchar2(240) := FND_API.G_MISS_CHAR,
107 ATTRIBUTE89 varchar2(240) := FND_API.G_MISS_CHAR,
108 ATTRIBUTE90 varchar2(240) := FND_API.G_MISS_CHAR,
109 ATTRIBUTE91 varchar2(240) := FND_API.G_MISS_CHAR,
110 ATTRIBUTE92 varchar2(240) := FND_API.G_MISS_CHAR,
111 ATTRIBUTE93 varchar2(240) := FND_API.G_MISS_CHAR,
112 ATTRIBUTE94 varchar2(240) := FND_API.G_MISS_CHAR,
113 ATTRIBUTE95 varchar2(240) := FND_API.G_MISS_CHAR,
114 ATTRIBUTE96 varchar2(240) := FND_API.G_MISS_CHAR,
115 ATTRIBUTE97 varchar2(240) := FND_API.G_MISS_CHAR,
116 ATTRIBUTE98 varchar2(240) := FND_API.G_MISS_CHAR,
117 ATTRIBUTE99 varchar2(240) := FND_API.G_MISS_CHAR,
118 ATTRIBUTE100 varchar2(240) := FND_API.G_MISS_CHAR,
119 SALES_CHANNEL varchar2(30) := FND_API.G_MISS_CHAR,
120 LINE_NUMBER number := G_LOC_MISS_NUM,
121 REASON_CODE varchar2(30) := FND_API.G_MISS_CHAR,
122 ATTRIBUTE_CATEGORY varchar2(30) := FND_API.G_MISS_CHAR,
123 ADJUST_DATE varchar2(30) := FND_API.G_MISS_CHAR,
124 ADJUSTED_BY varchar2(100) := FND_API.G_MISS_CHAR,
125 BILL_TO_ADDRESS_ID number := G_LOC_MISS_NUM,
126 SHIP_TO_ADDRESS_ID number := G_LOC_MISS_NUM,
127 BILL_TO_CONTACT_ID number := G_LOC_MISS_NUM,
128 SHIP_TO_CONTACT_ID number := G_LOC_MISS_NUM,
129 CUSTOMER_ID number := G_LOC_MISS_NUM,
130 INVENTORY_ITEM_ID number := G_LOC_MISS_NUM,
131 ORDER_NUMBER number := G_LOC_MISS_NUM,
132 BOOKED_DATE varchar2(30) := FND_API.G_MISS_CHAR,
133 SOURCE_TRX_NUMBER varchar2(20) := FND_API.G_MISS_CHAR,
134 DISCOUNT_PERCENTAGE number := G_LOC_MISS_NUM,
135 MARGIN_PERCENTAGE number := G_LOC_MISS_NUM,
136 EXCHANGE_RATE number := G_LOC_MISS_NUM,
137 TYPE varchar2(80) := FND_API.G_MISS_CHAR,
138 SOURCE_TRX_SALES_LINE_ID number := G_LOC_MISS_NUM
139 );
140
141 TYPE aia_rec_tbl_type IS TABLE OF aia_rec_type
142 INDEX BY BINARY_INTEGER;
143 aia_rec aia_rec_type;
144 aia_rec_tbl aia_rec_tbl_type;
145
146 TYPE aia_error_rec_type IS RECORD
147 (
148 INVOICE_NUMBER varchar2(20) := FND_API.G_MISS_CHAR,
149 ERROR_DESC varchar2(1000) := FND_API.G_MISS_CHAR
150 );
151
152 TYPE aia_error_rec_tbl_type IS TABLE OF aia_error_rec_type INDEX BY BINARY_INTEGER;
153 aia_error_rec_tbl aia_error_rec_tbl_type;
154
155 -- API name : loadrow
156 -- Type : Public.
157 -- Pre-reqs :
158 -- Usage :
159 --+
160 -- Desc :
161 --
162 --
163 --+
164 -- Parameters :
165 -- IN : p_api_version NUMBER Require
166 -- p_init_msg_list VARCHAR2 Optional (FND_API.G_FALSE)
167 -- p_commit VARCHAR2 Optional (FND_API.G_FALSE)
168 --
169 -- OUT : x_return_status VARCHAR2(1)
170 -- x_msg_count NUMBER
171 -- x_msg_data VARCHAR2(2000)
172 --
173 --
174 --
175 -- +
176 --+
177 -- Version : Current version 1.0
178 -- Initial version 1.0
179 --+
180 -- Notes :
181 --+
182 -- End of comments
183 PROCEDURE loadrow
184 (
185 p_api_version IN NUMBER,
186 p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
187 p_commit IN VARCHAR2:= FND_API.G_FALSE,
188 p_aia_rec_tbl IN CN_COLLECTION_AIA_PUB.aia_rec_tbl_type,
189 p_org_id IN NUMBER,
190 p_aia_error_rec_tbl OUT nocopy CN_COLLECTION_AIA_PUB.aia_error_rec_tbl_type,
191 x_msg_count OUT nocopy NUMBER,
192 x_msg_data OUT nocopy VARCHAR2,
193 x_return_status OUT nocopy VARCHAR2 );
194
195
196
197 -- API name : updaterow_comm_api
198 -- Type : public.
199 -- Pre-reqs :
200 -- Usage :
201 --+
202 -- Desc :
203 --
204 --
205 --+
206 -- Parameters :
207 -- IN
208 --
209 -- OUT : x_return_status VARCHAR2(1)
210 --
211 --
212 --
213 --
214 -- +
215 --+
216 -- Version : Current version 1.0
217 -- Initial version 1.0
218 --+
219 -- Notes :
220 --+
221 -- End of comments
222 PROCEDURE updaterow_comm_api
223 (
224 x_return_status OUT nocopy VARCHAR2,
225 x_start_period_name IN VARCHAR2,
226 x_end_period_name IN VARCHAR2 );
227 END CN_COLLECTION_AIA_PUB;