[Home] [Help]
PACKAGE: APPS.CN_ADJUSTMENTS_PKG
Source
1 PACKAGE CN_ADJUSTMENTS_PKG AUTHID CURRENT_USER AS
2 -- $Header: cntradjs.pls 120.4.12000000.2 2007/08/07 14:36:28 apink ship $
3 -- +======================================================================+
4 -- | Copyright (c) 1994 Oracle Corporation |
5 -- | Redwood Shores, California, USA |
6 -- | All rights reserved. |
7 -- +======================================================================+
8 --
9 -- Package Name
10 -- cn_adjustments_pkg
11 -- Purpose
12 -- Package spec for notifying orders
13 -- History
14 -- 11/17/98 JPENDYAL Created
15 TYPE TabcommId IS TABLE OF NUMBER(15) INDEX BY BINARY_INTEGER;
16
17 tab_mass_update_comm TabcommId;
18
19
20 TYPE adj_rec_type IS RECORD(
21 commission_header_id number := fnd_api.g_miss_num,
22 direct_salesrep_number varchar2(30) := fnd_api.g_miss_char,
23 direct_salesrep_name varchar2(360) := fnd_api.g_miss_char,
24 direct_salesrep_id number := fnd_api.g_miss_num,
25 processed_period_id number := fnd_api.g_miss_num,
26 processed_period varchar2(30) := fnd_api.g_miss_char,
27 processed_date date := fnd_api.g_miss_date,
28 rollup_date date := fnd_api.g_miss_date,
29 transaction_amount number := fnd_api.g_miss_num,
30 transaction_amount_orig number := fnd_api.g_miss_num,
31 quantity number := fnd_api.g_miss_num,
32 discount_percentage number := fnd_api.g_miss_num,
33 margin_percentage number := fnd_api.g_miss_num,
34 orig_currency_code varchar2(15) := fnd_api.g_miss_char,
35 exchange_rate number := fnd_api.g_miss_num,
36 status_disp varchar2(80) := fnd_api.g_miss_char,
37 status varchar2(30) := fnd_api.g_miss_char,
38 trx_type_disp varchar2(80) := fnd_api.g_miss_char,
39 trx_type varchar2(30) := fnd_api.g_miss_char,
40 reason varchar2(80) := fnd_api.g_miss_char,
41 reason_code varchar2(30) := fnd_api.g_miss_char,
42 comments varchar2(1800) := fnd_api.g_miss_char,
43 trx_batch_id number := fnd_api.g_miss_num,
44 created_by number := fnd_api.g_miss_num,
45 creation_date date := fnd_api.g_miss_date,
46 last_updated_by number := fnd_api.g_miss_num,
47 last_update_login number := fnd_api.g_miss_num,
48 last_update_date date := fnd_api.g_miss_date,
49 attribute_category varchar2(30) := fnd_api.g_miss_char,
50 attribute1 varchar2(240) := fnd_api.g_miss_char,
51 attribute2 varchar2(240) := fnd_api.g_miss_char,
52 attribute3 varchar2(240) := fnd_api.g_miss_char,
53 attribute4 varchar2(240) := fnd_api.g_miss_char,
54 attribute5 varchar2(240) := fnd_api.g_miss_char,
55 attribute6 varchar2(240) := fnd_api.g_miss_char,
56 attribute7 varchar2(240) := fnd_api.g_miss_char,
57 attribute8 varchar2(240) := fnd_api.g_miss_char,
58 attribute9 varchar2(240) := fnd_api.g_miss_char,
59 attribute10 varchar2(240) := fnd_api.g_miss_char,
60 attribute11 varchar2(240) := fnd_api.g_miss_char,
61 attribute12 varchar2(240) := fnd_api.g_miss_char,
62 attribute13 varchar2(240) := fnd_api.g_miss_char,
63 attribute14 varchar2(240) := fnd_api.g_miss_char,
64 attribute15 varchar2(240) := fnd_api.g_miss_char,
65 attribute16 varchar2(240) := fnd_api.g_miss_char,
66 attribute17 varchar2(240) := fnd_api.g_miss_char,
67 attribute18 varchar2(240) := fnd_api.g_miss_char,
68 attribute19 varchar2(240) := fnd_api.g_miss_char,
69 attribute20 varchar2(240) := fnd_api.g_miss_char,
70 attribute21 varchar2(240) := fnd_api.g_miss_char,
71 attribute22 varchar2(240) := fnd_api.g_miss_char,
72 attribute23 varchar2(240) := fnd_api.g_miss_char,
73 attribute24 varchar2(240) := fnd_api.g_miss_char,
74 attribute25 varchar2(240) := fnd_api.g_miss_char,
75 attribute26 varchar2(240) := fnd_api.g_miss_char,
76 attribute27 varchar2(240) := fnd_api.g_miss_char,
77 attribute28 varchar2(240) := fnd_api.g_miss_char,
78 attribute29 varchar2(240) := fnd_api.g_miss_char,
79 attribute30 varchar2(240) := fnd_api.g_miss_char,
80 attribute31 varchar2(240) := fnd_api.g_miss_char,
81 attribute32 varchar2(240) := fnd_api.g_miss_char,
82 attribute33 varchar2(240) := fnd_api.g_miss_char,
83 attribute34 varchar2(240) := fnd_api.g_miss_char,
84 attribute35 varchar2(240) := fnd_api.g_miss_char,
85 attribute36 varchar2(240) := fnd_api.g_miss_char,
86 attribute37 varchar2(240) := fnd_api.g_miss_char,
87 attribute38 varchar2(240) := fnd_api.g_miss_char,
88 attribute39 varchar2(240) := fnd_api.g_miss_char,
89 attribute40 varchar2(240) := fnd_api.g_miss_char,
90 attribute41 varchar2(240) := fnd_api.g_miss_char,
91 attribute42 varchar2(240) := fnd_api.g_miss_char,
92 attribute43 varchar2(240) := fnd_api.g_miss_char,
93 attribute44 varchar2(240) := fnd_api.g_miss_char,
94 attribute45 varchar2(240) := fnd_api.g_miss_char,
95 attribute46 varchar2(240) := fnd_api.g_miss_char,
96 attribute47 varchar2(240) := fnd_api.g_miss_char,
97 attribute48 varchar2(240) := fnd_api.g_miss_char,
98 attribute49 varchar2(240) := fnd_api.g_miss_char,
99 attribute50 varchar2(240) := fnd_api.g_miss_char,
100 attribute51 varchar2(240) := fnd_api.g_miss_char,
101 attribute52 varchar2(240) := fnd_api.g_miss_char,
102 attribute53 varchar2(240) := fnd_api.g_miss_char,
103 attribute54 varchar2(240) := fnd_api.g_miss_char,
104 attribute55 varchar2(240) := fnd_api.g_miss_char,
105 attribute56 varchar2(240) := fnd_api.g_miss_char,
106 attribute57 varchar2(240) := fnd_api.g_miss_char,
107 attribute58 varchar2(240) := fnd_api.g_miss_char,
108 attribute59 varchar2(240) := fnd_api.g_miss_char,
109 attribute60 varchar2(240) := fnd_api.g_miss_char,
110 attribute61 varchar2(240) := fnd_api.g_miss_char,
111 attribute62 varchar2(240) := fnd_api.g_miss_char,
112 attribute63 varchar2(240) := fnd_api.g_miss_char,
113 attribute64 varchar2(240) := fnd_api.g_miss_char,
114 attribute65 varchar2(240) := fnd_api.g_miss_char,
115 attribute66 varchar2(240) := fnd_api.g_miss_char,
116 attribute67 varchar2(240) := fnd_api.g_miss_char,
117 attribute68 varchar2(240) := fnd_api.g_miss_char,
118 attribute69 varchar2(240) := fnd_api.g_miss_char,
119 attribute70 varchar2(240) := fnd_api.g_miss_char,
120 attribute71 varchar2(240) := fnd_api.g_miss_char,
121 attribute72 varchar2(240) := fnd_api.g_miss_char,
122 attribute73 varchar2(240) := fnd_api.g_miss_char,
123 attribute74 varchar2(240) := fnd_api.g_miss_char,
124 attribute75 varchar2(240) := fnd_api.g_miss_char,
125 attribute76 varchar2(240) := fnd_api.g_miss_char,
126 attribute77 varchar2(240) := fnd_api.g_miss_char,
127 attribute78 varchar2(240) := fnd_api.g_miss_char,
128 attribute79 varchar2(240) := fnd_api.g_miss_char,
129 attribute80 varchar2(240) := fnd_api.g_miss_char,
130 attribute81 varchar2(240) := fnd_api.g_miss_char,
131 attribute82 varchar2(240) := fnd_api.g_miss_char,
132 attribute83 varchar2(240) := fnd_api.g_miss_char,
133 attribute84 varchar2(240) := fnd_api.g_miss_char,
134 attribute85 varchar2(240) := fnd_api.g_miss_char,
135 attribute86 varchar2(240) := fnd_api.g_miss_char,
136 attribute87 varchar2(240) := fnd_api.g_miss_char,
137 attribute88 varchar2(240) := fnd_api.g_miss_char,
138 attribute89 varchar2(240) := fnd_api.g_miss_char,
139 attribute90 varchar2(240) := fnd_api.g_miss_char,
140 attribute91 varchar2(240) := fnd_api.g_miss_char,
141 attribute92 varchar2(240) := fnd_api.g_miss_char,
142 attribute93 varchar2(240) := fnd_api.g_miss_char,
143 attribute94 varchar2(240) := fnd_api.g_miss_char,
144 attribute95 varchar2(240) := fnd_api.g_miss_char,
145 attribute96 varchar2(240) := fnd_api.g_miss_char,
146 attribute97 varchar2(240) := fnd_api.g_miss_char,
147 attribute98 varchar2(240) := fnd_api.g_miss_char,
148 attribute99 varchar2(240) := fnd_api.g_miss_char,
149 attribute100 varchar2(240) := fnd_api.g_miss_char,
150 quota_id number := fnd_api.g_miss_num,
151 quota_name varchar2(80) := fnd_api.g_miss_char,
152 revenue_class_id number := fnd_api.g_miss_num,
153 revenue_class_name varchar2(30) := fnd_api.g_miss_char,
154 trx_batch_name varchar2(30) := fnd_api.g_miss_char,
155 source_trx_number varchar2(80) := fnd_api.g_miss_char,
156 trx_sales_line_id number := fnd_api.g_miss_num,
157 trx_line_id number := fnd_api.g_miss_num,
158 trx_id number := fnd_api.g_miss_num,
159 comm_lines_api_id number := fnd_api.g_miss_num,
160 source_doc_type varchar2(80) := fnd_api.g_miss_char,
161 upside_amount number := fnd_api.g_miss_num,
162 upside_quantity number := fnd_api.g_miss_num,
163 uom_code varchar2(3) := fnd_api.g_miss_char,
164 forecast_id number := fnd_api.g_miss_num,
165 program_id number := fnd_api.g_miss_num,
166 request_id number := fnd_api.g_miss_num,
167 program_application_id number := fnd_api.g_miss_num,
168 program_update_date date := fnd_api.g_miss_date,
169 adj_comm_lines_api_id number := fnd_api.g_miss_num,
170 invoice_number varchar2(20) := fnd_api.g_miss_char,
171 invoice_date date := fnd_api.g_miss_date,
172 order_number number := fnd_api.g_miss_num,
173 order_date date := fnd_api.g_miss_date,
174 line_number number := fnd_api.g_miss_num,
175 customer_id number := fnd_api.g_miss_num,
176 bill_to_address_id number := fnd_api.g_miss_num,
177 ship_to_address_id number := fnd_api.g_miss_num,
178 bill_to_contact_id number := fnd_api.g_miss_num,
179 ship_to_contact_id number := fnd_api.g_miss_num,
180 load_status varchar2(30) := fnd_api.g_miss_char,
181 revenue_type_disp varchar2(80) := fnd_api.g_miss_char,
182 revenue_type varchar2(15) := fnd_api.g_miss_char,
183 adjust_rollup_flag varchar2(1) := fnd_api.g_miss_char,
184 adjust_date date := fnd_api.g_miss_date,
185 adjusted_by varchar2(100) := fnd_api.g_miss_char,
186 adjust_status_disp varchar2(80) := fnd_api.g_miss_char,
187 adjust_status varchar2(20) := fnd_api.g_miss_char,
188 adjust_comments varchar2(2000) := fnd_api.g_miss_char,
189 type varchar2(80) := fnd_api.g_miss_char,
190 pre_processed_code varchar2(30) := fnd_api.g_miss_char,
191 comp_group_id number := fnd_api.g_miss_num,
192 srp_plan_assign_id number := fnd_api.g_miss_num,
193 role_id number := fnd_api.g_miss_num,
194 sales_channel varchar2(30) := fnd_api.g_miss_char,
195 object_version_number number := fnd_api.g_miss_num,
196 split_pct number := fnd_api.g_miss_num,
197 split_status varchar2(30) := fnd_api.g_miss_char);
198 TYPE adj_tbl_type IS
199 TABLE OF adj_rec_type INDEX BY BINARY_INTEGER ;
200 --
201 TYPE cust_info_rec IS RECORD(
202 CUSTOMER_ID NUMBER(15),
203 CUSTOMER_NUMBER VARCHAR2(30),
204 CUSTOMER_NAME VARCHAR2(255),
205 BILL_TO_ADDRESS_ID NUMBER,
206 BILL_TO_ADDRESS1 VARCHAR2(240),
207 BILL_TO_ADDRESS2 VARCHAR2(240),
208 BILL_TO_ADDRESS3 VARCHAR2(240),
209 BILL_TO_ADDRESS4 VARCHAR2(240),
210 BILL_TO_CITY VARCHAR2(60),
211 BILL_TO_POSTAL_CODE VARCHAR2(60),
212 BILL_TO_STATE VARCHAR2(60),
213 SHIP_TO_ADDRESS_ID NUMBER,
214 SHIP_TO_ADDRESS1 VARCHAR2(240),
215 SHIP_TO_ADDRESS2 VARCHAR2(240),
216 SHIP_TO_ADDRESS3 VARCHAR2(240),
217 SHIP_TO_ADDRESS4 VARCHAR2(240),
218 SHIP_TO_CITY VARCHAR2(60),
219 SHIP_TO_POSTAL_CODE VARCHAR2(60),
220 SHIP_TO_STATE VARCHAR2(60),
221 BILL_TO_CONTACT_ID NUMBER,
222 BILL_TO_CONTACT VARCHAR2(301),
223 SHIP_TO_CONTACT_ID NUMBER,
224 SHIP_TO_CONTACT VARCHAR2(301));
225 --
226 TYPE cust_info_tbl IS
227 TABLE OF cust_info_rec INDEX BY BINARY_INTEGER ;
228 --
229
230
231 PROCEDURE mass_adjust_build_query
232 ( x_where_clause VARCHAR2
233 );
234
235 PROCEDURE api_negate_record(
236 x_comm_lines_api_id IN NUMBER,
237 x_adjusted_by IN VARCHAR2,
238 x_adjust_comments IN VARCHAR2,
239 x_salesrep_number IN VARCHAR2 DEFAULT NULL);
240 --
241 PROCEDURE mass_update_values(
242 x_adj_data cn_get_tx_data_pub.adj_tbl_type,
243 x_adj_rec cn_get_tx_data_pub.adj_rec_type,
244 x_mass_adj_type VARCHAR2,
245 x_proc_comp OUT NOCOPY VARCHAR2);
246 --
247 PROCEDURE deal_split(
248 x_source_salesrep_id NUMBER,
249 x_salesrep_id NUMBER,
250 x_split_percent NUMBER,
251 x_revenue_type VARCHAR2,
252 x_invoice_number VARCHAR2,
253 x_order_number NUMBER,
254 x_adjusted_by VARCHAR2,
255 x_adjust_comments VARCHAR2);
256 --
257 PROCEDURE deal_assign(
258 x_from_salesrep_id NUMBER,
259 x_to_salesrep_id NUMBER,
260 x_invoice_number VARCHAR2,
261 x_order_number NUMBER,
262 x_adjusted_by VARCHAR2,
263 x_adjust_comments VARCHAR2);
264 --
265 PROCEDURE get_cust_info(
266 p_comm_lines_api_id IN NUMBER,
267 p_load_status IN VARCHAR2,
268 x_cust_info_rec OUT NOCOPY cust_info_rec);
269 --
270 /*--------------------------------------------------------------------------
271 API name : update_credit_credentials
272 Type : Public
273 Pre-reqs :
274 Usage :
275 Desc : This procedure is called to validate the transactions after an update
276 depending on whether the transaction is collected or credited.
277 Parameters
278 IN : p_comm_lines_api_id
279 : p_terr_id
280 : p_org_id
281 : p_adjusted_by
282 Notes :
283 --------------------------------------------------------------------------*/
284 PROCEDURE update_credit_credentials(
285 p_comm_lines_api_id IN NUMBER,
286 p_terr_id IN NUMBER,
287 p_org_id IN NUMBER,
288 p_adjusted_by IN VARCHAR2
289 );
290 --
291
292 END cn_adjustments_pkg;
293