[Home] [Help]
PACKAGE: APPS.CN_COMM_LINES_API_PKG
Source
1 PACKAGE CN_COMM_LINES_API_PKG AUTHID CURRENT_USER AS
2 /* $Header: cncmapis.pls 120.3.12000000.2 2007/08/07 14:47:55 apink ship $*/
3 -- +======================================================================+
4 -- | Copyright (c) 1998 Oracle Corporation |
5 -- | Redwood Shores, California, USA |
6 -- | All rights reserved. |
7 -- +======================================================================+
8 --
9 -- FILENAME
10 -- cncmapis.pls
11 --
12 -- PURPOSE
13 -- Package Spec -- Table Handler for Table CN_COMM_LINES_API
14 --
15 -- NOTES
16 -- This file is generated by tblHandlerGen.pl *** DO NOT MODIFY ***
17 --
18 -- HISTORY
19 -- 04/01/98 J.Cheng Created
20 -- Jan/19/99 H. Chen Added update_record
21 -- Jan/25/99 H. Chen Added reason_code
22 -- Nov/05/99 H. Chen Update for 11i new data model
23 -- Feb/14/00 D. Maskell Add source_doc_type param to Negate_Record
24 -- 19-AUG-2001 R. Chenna Converted this to started table handler using
25 -- PERL script.
26 --
27 --
28 -- +======================================================================+
29
30 -- * ------------------------------------------------------------------+
31 -- Record Type Definition
32 -- * ------------------------------------------------------------------+
33
34 TYPE COMM_LINES_API_REC_TYPE IS RECORD
35 (
36 SALESREP_ID NUMBER := FND_API.G_MISS_NUM,
37 PROCESSED_DATE DATE := FND_API.G_MISS_DATE,
38 PROCESSED_PERIOD_ID NUMBER := FND_API.G_MISS_NUM,
39 TRANSACTION_AMOUNT NUMBER := FND_API.G_MISS_NUM,
40 TRX_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
41 REVENUE_CLASS_ID NUMBER := FND_API.G_MISS_NUM,
42 LOAD_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
43 ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
44 ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
45 ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
46 ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
47 ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
48 ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
49 ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
50 ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
51 ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
52 ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
53 ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
54 ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
55 ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
56 ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
57 ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
58 ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
59 ATTRIBUTE16 VARCHAR2(240) := FND_API.G_MISS_CHAR,
60 ATTRIBUTE17 VARCHAR2(240) := FND_API.G_MISS_CHAR,
61 ATTRIBUTE18 VARCHAR2(240) := FND_API.G_MISS_CHAR,
62 ATTRIBUTE19 VARCHAR2(240) := FND_API.G_MISS_CHAR,
63 ATTRIBUTE20 VARCHAR2(240) := FND_API.G_MISS_CHAR,
64 ATTRIBUTE21 VARCHAR2(240) := FND_API.G_MISS_CHAR,
65 ATTRIBUTE22 VARCHAR2(240) := FND_API.G_MISS_CHAR,
66 ATTRIBUTE23 VARCHAR2(240) := FND_API.G_MISS_CHAR,
67 ATTRIBUTE24 VARCHAR2(240) := FND_API.G_MISS_CHAR,
68 ATTRIBUTE25 VARCHAR2(240) := FND_API.G_MISS_CHAR,
69 ATTRIBUTE26 VARCHAR2(240) := FND_API.G_MISS_CHAR,
70 ATTRIBUTE27 VARCHAR2(240) := FND_API.G_MISS_CHAR,
71 ATTRIBUTE28 VARCHAR2(240) := FND_API.G_MISS_CHAR,
72 ATTRIBUTE29 VARCHAR2(240) := FND_API.G_MISS_CHAR,
73 ATTRIBUTE30 VARCHAR2(240) := FND_API.G_MISS_CHAR,
74 ATTRIBUTE31 VARCHAR2(240) := FND_API.G_MISS_CHAR,
75 ATTRIBUTE32 VARCHAR2(240) := FND_API.G_MISS_CHAR,
76 ATTRIBUTE33 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77 ATTRIBUTE34 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78 ATTRIBUTE35 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79 ATTRIBUTE36 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80 ATTRIBUTE37 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81 ATTRIBUTE38 VARCHAR2(240) := FND_API.G_MISS_CHAR,
82 ATTRIBUTE39 VARCHAR2(240) := FND_API.G_MISS_CHAR,
83 ATTRIBUTE40 VARCHAR2(240) := FND_API.G_MISS_CHAR,
84 ATTRIBUTE41 VARCHAR2(240) := FND_API.G_MISS_CHAR,
85 ATTRIBUTE42 VARCHAR2(240) := FND_API.G_MISS_CHAR,
86 ATTRIBUTE43 VARCHAR2(240) := FND_API.G_MISS_CHAR,
87 ATTRIBUTE44 VARCHAR2(240) := FND_API.G_MISS_CHAR,
88 ATTRIBUTE45 VARCHAR2(240) := FND_API.G_MISS_CHAR,
89 ATTRIBUTE46 VARCHAR2(240) := FND_API.G_MISS_CHAR,
90 ATTRIBUTE47 VARCHAR2(240) := FND_API.G_MISS_CHAR,
91 ATTRIBUTE48 VARCHAR2(240) := FND_API.G_MISS_CHAR,
92 ATTRIBUTE49 VARCHAR2(240) := FND_API.G_MISS_CHAR,
93 ATTRIBUTE50 VARCHAR2(240) := FND_API.G_MISS_CHAR,
94 ATTRIBUTE51 VARCHAR2(240) := FND_API.G_MISS_CHAR,
95 ATTRIBUTE52 VARCHAR2(240) := FND_API.G_MISS_CHAR,
96 ATTRIBUTE53 VARCHAR2(240) := FND_API.G_MISS_CHAR,
97 ATTRIBUTE54 VARCHAR2(240) := FND_API.G_MISS_CHAR,
98 ATTRIBUTE55 VARCHAR2(240) := FND_API.G_MISS_CHAR,
99 ATTRIBUTE56 VARCHAR2(240) := FND_API.G_MISS_CHAR,
100 ATTRIBUTE57 VARCHAR2(240) := FND_API.G_MISS_CHAR,
101 ATTRIBUTE58 VARCHAR2(240) := FND_API.G_MISS_CHAR,
102 ATTRIBUTE59 VARCHAR2(240) := FND_API.G_MISS_CHAR,
103 ATTRIBUTE60 VARCHAR2(240) := FND_API.G_MISS_CHAR,
104 ATTRIBUTE61 VARCHAR2(240) := FND_API.G_MISS_CHAR,
105 ATTRIBUTE62 VARCHAR2(240) := FND_API.G_MISS_CHAR,
106 ATTRIBUTE63 VARCHAR2(240) := FND_API.G_MISS_CHAR,
107 ATTRIBUTE64 VARCHAR2(240) := FND_API.G_MISS_CHAR,
108 ATTRIBUTE65 VARCHAR2(240) := FND_API.G_MISS_CHAR,
109 ATTRIBUTE66 VARCHAR2(240) := FND_API.G_MISS_CHAR,
110 ATTRIBUTE67 VARCHAR2(240) := FND_API.G_MISS_CHAR,
111 ATTRIBUTE68 VARCHAR2(240) := FND_API.G_MISS_CHAR,
112 ATTRIBUTE69 VARCHAR2(240) := FND_API.G_MISS_CHAR,
113 ATTRIBUTE70 VARCHAR2(240) := FND_API.G_MISS_CHAR,
114 ATTRIBUTE71 VARCHAR2(240) := FND_API.G_MISS_CHAR,
115 ATTRIBUTE72 VARCHAR2(240) := FND_API.G_MISS_CHAR,
116 ATTRIBUTE73 VARCHAR2(240) := FND_API.G_MISS_CHAR,
117 ATTRIBUTE74 VARCHAR2(240) := FND_API.G_MISS_CHAR,
118 ATTRIBUTE75 VARCHAR2(240) := FND_API.G_MISS_CHAR,
119 ATTRIBUTE76 VARCHAR2(240) := FND_API.G_MISS_CHAR,
120 ATTRIBUTE77 VARCHAR2(240) := FND_API.G_MISS_CHAR,
121 ATTRIBUTE78 VARCHAR2(240) := FND_API.G_MISS_CHAR,
122 ATTRIBUTE79 VARCHAR2(240) := FND_API.G_MISS_CHAR,
123 ATTRIBUTE80 VARCHAR2(240) := FND_API.G_MISS_CHAR,
124 ATTRIBUTE81 VARCHAR2(240) := FND_API.G_MISS_CHAR,
125 ATTRIBUTE82 VARCHAR2(240) := FND_API.G_MISS_CHAR,
126 ATTRIBUTE83 VARCHAR2(240) := FND_API.G_MISS_CHAR,
127 ATTRIBUTE84 VARCHAR2(240) := FND_API.G_MISS_CHAR,
128 ATTRIBUTE85 VARCHAR2(240) := FND_API.G_MISS_CHAR,
129 ATTRIBUTE86 VARCHAR2(240) := FND_API.G_MISS_CHAR,
130 ATTRIBUTE87 VARCHAR2(240) := FND_API.G_MISS_CHAR,
131 ATTRIBUTE88 VARCHAR2(240) := FND_API.G_MISS_CHAR,
132 ATTRIBUTE89 VARCHAR2(240) := FND_API.G_MISS_CHAR,
133 ATTRIBUTE90 VARCHAR2(240) := FND_API.G_MISS_CHAR,
134 ATTRIBUTE91 VARCHAR2(240) := FND_API.G_MISS_CHAR,
135 ATTRIBUTE92 VARCHAR2(240) := FND_API.G_MISS_CHAR,
136 ATTRIBUTE93 VARCHAR2(240) := FND_API.G_MISS_CHAR,
137 ATTRIBUTE94 VARCHAR2(240) := FND_API.G_MISS_CHAR,
138 ATTRIBUTE95 VARCHAR2(240) := FND_API.G_MISS_CHAR,
139 ATTRIBUTE96 VARCHAR2(240) := FND_API.G_MISS_CHAR,
140 ATTRIBUTE97 VARCHAR2(240) := FND_API.G_MISS_CHAR,
141 ATTRIBUTE98 VARCHAR2(240) := FND_API.G_MISS_CHAR,
142 ATTRIBUTE99 VARCHAR2(240) := FND_API.G_MISS_CHAR,
143 ATTRIBUTE100 VARCHAR2(240) := FND_API.G_MISS_CHAR,
144 COMM_LINES_API_ID NUMBER := FND_API.G_MISS_NUM,
145 CONC_BATCH_ID NUMBER := FND_API.G_MISS_NUM,
146 PROCESS_BATCH_ID NUMBER := FND_API.G_MISS_NUM,
147 SALESREP_NUMBER NUMBER := FND_API.G_MISS_NUM,
148 ROLLUP_DATE DATE := FND_API.G_MISS_DATE,
149 SOURCE_DOC_ID NUMBER := FND_API.G_MISS_NUM,
150 SOURCE_DOC_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
151 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
152 CREATION_DATE DATE := FND_API.G_MISS_DATE,
153 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
154 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
155 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
156 TRANSACTION_CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
157 EXCHANGE_RATE NUMBER := FND_API.G_MISS_NUM,
158 ACCTD_TRANSACTION_AMOUNT NUMBER := FND_API.G_MISS_NUM,
159 TRX_ID NUMBER := FND_API.G_MISS_NUM,
160 TRX_LINE_ID NUMBER := FND_API.G_MISS_NUM,
161 TRX_SALES_LINE_ID NUMBER := FND_API.G_MISS_NUM,
162 ORG_ID NUMBER := FND_API.G_MISS_NUM,
163 QUANTITY NUMBER := FND_API.G_MISS_NUM,
164 SOURCE_TRX_NUMBER VARCHAR2(20) := FND_API.G_MISS_CHAR,
165 DISCOUNT_PERCENTAGE NUMBER := FND_API.G_MISS_NUM,
166 MARGIN_PERCENTAGE NUMBER := FND_API.G_MISS_NUM,
167 SOURCE_TRX_ID NUMBER := FND_API.G_MISS_NUM,
168 SOURCE_TRX_LINE_ID NUMBER := FND_API.G_MISS_NUM,
169 SOURCE_TRX_SALES_LINE_ID NUMBER := FND_API.G_MISS_NUM,
170 NEGATED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
171 CUSTOMER_ID NUMBER := FND_API.G_MISS_NUM,
172 INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
173 ORDER_NUMBER NUMBER := FND_API.G_MISS_NUM,
174 BOOKED_DATE DATE := FND_API.G_MISS_DATE,
175 INVOICE_NUMBER VARCHAR2(20) := FND_API.G_MISS_CHAR,
176 INVOICE_DATE DATE := FND_API.G_MISS_DATE,
177 ADJUST_DATE DATE := FND_API.G_MISS_DATE,
178 ADJUSTED_BY VARCHAR2(100) := FND_API.G_MISS_CHAR,
179 REVENUE_TYPE VARCHAR2(15) := FND_API.G_MISS_CHAR,
180 ADJUST_ROLLUP_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
181 ADJUST_COMMENTS VARCHAR2(2000) := FND_API.G_MISS_CHAR,
182 ADJUST_STATUS VARCHAR2(20) := FND_API.G_MISS_CHAR,
183 LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
184 BILL_TO_ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
185 SHIP_TO_ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
186 BILL_TO_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
187 SHIP_TO_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
188 ADJ_COMM_LINES_API_ID NUMBER := FND_API.G_MISS_NUM,
189 PRE_DEFINED_RC_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
190 ROLLUP_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
191 FORECAST_ID NUMBER := FND_API.G_MISS_NUM,
192 UPSIDE_QUANTITY NUMBER := FND_API.G_MISS_NUM,
193 UPSIDE_AMOUNT NUMBER := FND_API.G_MISS_NUM,
194 UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
195 REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
196 TYPE VARCHAR2(80) := FND_API.G_MISS_CHAR,
197 PRE_PROCESSED_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
198 QUOTA_ID NUMBER := FND_API.G_MISS_NUM,
199 SRP_PLAN_ASSIGN_ID NUMBER := FND_API.G_MISS_NUM,
200 ROLE_ID NUMBER := FND_API.G_MISS_NUM,
201 COMP_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
202 COMMISSION_AMOUNT NUMBER := FND_API.G_MISS_NUM,
203 EMPLOYEE_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
204 REVERSAL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
205 REVERSAL_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
206 SALES_CHANNEL VARCHAR2(30) := FND_API.G_MISS_CHAR,
207 OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
208 SPLIT_PCT NUMBER := FND_API.G_MISS_NUM,
209 SPLIT_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
210 TERR_ID NUMBER := FND_API.G_MISS_NUM,
211 PRESERVE_CREDIT_OVERRIDE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
212 TERR_NAME VARCHAR2(2000) := FND_API.G_MISS_CHAR
213 );
214
215 G_MISS_COMM_LINES_API_REC COMM_LINES_API_REC_TYPE;
216
217 -- * -------------------------------------------------------------------------*
218 -- Procedure Name
219 -- Insert_row
220 -- Purpose
221 -- Main insert procedure
222 -- Note
223 -- 1. Primary key should be populated from sequence before call
224 -- this procedure. No refernece to sequence in this procedure.
225 -- 2. All paramaters are IN parameter.
226 -- * -------------------------------------------------------------------------*
227 PROCEDURE insert_row
228 ( p_comm_lines_api_rec IN COMM_LINES_API_REC_TYPE);
229
230 -- * -------------------------------------------------------------------------*
231 -- Procedure Name
232 -- update_row
233 -- Purpose
234 -- Main update procedure
235 -- Note
236 -- 1. No object version checking, overwrite may happen
237 -- 2. Calling lock_update for object version checking
238 -- 3. All paramaters are IN parameter.
239 -- 4. Raise NO_DATA_FOUND exception if no reocrd updated (??)
240 -- * -------------------------------------------------------------------------*
241 PROCEDURE update_row
242 ( p_comm_lines_api_rec IN COMM_LINES_API_REC_TYPE);
243
244 -- * -------------------------------------------------------------------------*
245 -- Procedure Name
246 -- lock_update_row
247 -- Purpose
248 -- Main lcok and update procedure
249 -- Note
250 -- 1. Object version checking is performed before checking
251 -- 2. Calling update_row if you don not want object version checking
252 -- 3. All paramaters are IN parameter.
253 -- 4. Raise NO_DATA_FOUND exception if no reocrd updated (??)
254 -- * -------------------------------------------------------------------------*
255 PROCEDURE lock_update_row
256 ( p_comm_lines_api_rec IN COMM_LINES_API_REC_TYPE);
257
258 -- * -------------------------------------------------------------------------*
259 -- Procedure Name
260 -- delete_row
261 -- Purpose
262 -- Main lcok and update procedure
263 -- Note
264 -- 1. All paramaters are IN parameter.
265 -- 2. Raise NO_DATA_FOUND exception if no reocrd deleted (??)
266 -- * -------------------------------------------------------------------------*
267 PROCEDURE delete_row
268 (
269 p_comm_lines_api_id NUMBER
270 );
271 -- * -------------------------------------------------------------------------*
272 -- Procedure Name
273 -- negate_record
274 -- Purpose
275 -- Used during the collections
276 -- Note
280 X_source_trx_line_id NUMBER,
277 -- 1. All paramaters are IN parameter.
278 -- * -------------------------------------------------------------------------*
279 PROCEDURE negate_record (X_source_trx_id NUMBER,
281 X_source_doc_type VARCHAR2,
282 x_org_id NUMBER );
283 END CN_COMM_LINES_API_PKG;
284