1 PACKAGE arw_cm_cover AUTHID CURRENT_USER AS
2 /* $Header: ARWCMCVS.pls 120.7.12010000.2 2009/06/26 13:05:20 spdixit ship $ */
3
4 TYPE credit_lines_table_type IS TABLE OF
5 ra_customer_trx_lines%ROWTYPE
6 INDEX BY BINARY_INTEGER;
7
8 PROCEDURE get_doc_seq(p_application_id IN NUMBER,
9 p_document_name IN VARCHAR2,
10 p_sob_id IN NUMBER,
11 p_met_code IN CHAR,
12 p_trx_date IN DATE,
13 p_complete_flag IN VARCHAR2,
14 p_doc_sequence_value IN OUT NOCOPY NUMBER,
15 p_doc_sequence_id OUT NOCOPY NUMBER,
16 p_return_status OUT NOCOPY VARCHAR2
17 );
18
19 PROCEDURE create_header_cm (
20 p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
21 p_batch_id IN ra_batches.batch_id%type,
22 p_trx_date IN ra_customer_trx.trx_date%type,
23 p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
24 p_complete_flag IN ra_customer_trx.complete_flag%type,
25 p_batch_source_id IN ra_batch_sources.batch_source_id%type,
26 p_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%type,
27 p_currency_code IN fnd_currencies.currency_code%type,
28 p_exchange_date IN ra_customer_trx.exchange_date%type,
29 p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
30 p_exchange_rate IN ra_customer_trx.exchange_rate%type,
31 p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
32 p_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
33 p_split_term_method IN ra_customer_trx.credit_method_for_installments%type,
34 p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
35 p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
36 p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
37 p_bill_to_address_id IN ra_customer_trx.bill_to_address_id%type,
38 p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
39 p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
40 p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
41 p_ship_to_address_id IN ra_customer_trx.ship_to_address_id%type,
42 p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
43 p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
44 p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
45 p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
46 p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
47 p_customer_bank_account_id IN
48 ra_customer_trx.customer_bank_account_id%type,
49 p_printing_option IN ra_customer_trx.printing_option%type,
50 p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
51 p_printing_pending IN ra_customer_trx.printing_pending%type,
52 p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
53 p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
54 p_reason_code IN ra_customer_trx.reason_code%type,
55 p_customer_reference IN ra_customer_trx.customer_reference%type,
56 p_customer_reference_date IN ra_customer_trx.customer_reference_date%type, p_internal_notes IN ra_customer_trx.internal_notes%type,
57 p_set_of_books_id IN ra_customer_trx.set_of_books_id%type,
58 p_created_from IN ra_customer_trx.created_from%type,
59 p_old_trx_number IN ra_customer_trx.old_trx_number%type,
60 p_attribute_category IN ra_customer_trx.attribute_category%type,
61 p_attribute1 IN ra_customer_trx.attribute1%type,
62 p_attribute2 IN ra_customer_trx.attribute2%type,
63 p_attribute3 IN ra_customer_trx.attribute3%type,
64 p_attribute4 IN ra_customer_trx.attribute4%type,
65 p_attribute5 IN ra_customer_trx.attribute5%type,
66 p_attribute6 IN ra_customer_trx.attribute6%type,
67 p_attribute7 IN ra_customer_trx.attribute7%type,
68 p_attribute8 IN ra_customer_trx.attribute8%type,
69 p_attribute9 IN ra_customer_trx.attribute9%type,
70 p_attribute10 IN ra_customer_trx.attribute10%type,
71 p_attribute11 IN ra_customer_trx.attribute11%type,
72 p_attribute12 IN ra_customer_trx.attribute12%type,
73 p_attribute13 IN ra_customer_trx.attribute13%type,
74 p_attribute14 IN ra_customer_trx.attribute14%type,
75 p_attribute15 IN ra_customer_trx.attribute15%type,
76 p_interface_header_context IN
77 ra_customer_trx.interface_header_context%type,
78 p_interface_header_attribute1 IN
79 ra_customer_trx.interface_header_attribute1%type,
80 p_interface_header_attribute2 IN
81 ra_customer_trx.interface_header_attribute2%type,
82 p_interface_header_attribute3 IN
83 ra_customer_trx.interface_header_attribute3%type,
84 p_interface_header_attribute4 IN
85 ra_customer_trx.interface_header_attribute4%type,
86 p_interface_header_attribute5 IN
87 ra_customer_trx.interface_header_attribute5%type,
88 p_interface_header_attribute6 IN
89 ra_customer_trx.interface_header_attribute6%type,
90 p_interface_header_attribute7 IN
91 ra_customer_trx.interface_header_attribute7%type,
92 p_interface_header_attribute8 IN
93 ra_customer_trx.interface_header_attribute8%type,
94 p_interface_header_attribute9 IN
95 ra_customer_trx.interface_header_attribute9%type,
96 p_interface_header_attribute10 IN
97 ra_customer_trx.interface_header_attribute10%type,
98 p_interface_header_attribute11 IN
99 ra_customer_trx.interface_header_attribute11%type,
100 p_interface_header_attribute12 IN
101 ra_customer_trx.interface_header_attribute12%type,
102 p_interface_header_attribute13 IN
103 ra_customer_trx.interface_header_attribute13%type,
104 p_interface_header_attribute14 IN
105 ra_customer_trx.interface_header_attribute14%type,
106 p_interface_header_attribute15 IN
107 ra_customer_trx.interface_header_attribute15%type,
108 p_default_ussgl_trx_code IN
109 ra_customer_trx.default_ussgl_transaction_code%type,
110 p_line_percent IN number,
111 p_freight_percent IN number,
112 p_line_amount IN ra_customer_trx_lines.extended_amount%type,
113 p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
114 p_compute_tax IN varchar2,
115 p_comments IN ra_customer_trx.comments%type,
116 p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
117 p_trx_number IN OUT NOCOPY ra_customer_trx.trx_number%type,
118 p_computed_tax_percent IN OUT NOCOPY number,
119 p_computed_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
120 p_errors OUT NOCOPY arp_trx_validate.Message_Tbl_Type,
121 p_status OUT NOCOPY varchar2 ,
122 p_purchase_order IN ra_customer_trx.purchase_order%type,
123 p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
124 p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
125 p_legal_entity_id IN ra_customer_trx.legal_entity_id%type,
126 /*4556000-4606558*/
127 p_global_attribute_category IN ra_customer_trx.global_attribute_category%type default null,
128 p_global_attribute1 IN ra_customer_trx.global_attribute1%type default NULL,
129 p_global_attribute2 IN ra_customer_trx.global_attribute2%type default NULL,
130 p_global_attribute3 IN ra_customer_trx.global_attribute3%type default NULL,
131 p_global_attribute4 IN ra_customer_trx.global_attribute4%type default NULL,
132 p_global_attribute5 IN ra_customer_trx.global_attribute5%type default NULL,
133 p_global_attribute6 IN ra_customer_trx.global_attribute6%type default NULL,
134 p_global_attribute7 IN ra_customer_trx.global_attribute7%type default NULL,
135 p_global_attribute8 IN ra_customer_trx.global_attribute8%type default NULL,
136 p_global_attribute9 IN ra_customer_trx.global_attribute9%type default NULL,
137 p_global_attribute10 IN ra_customer_trx.global_attribute10%type default NULL,
138 p_global_attribute11 IN ra_customer_trx.global_attribute11%type default NULL,
139 p_global_attribute12 IN ra_customer_trx.global_attribute12%type default NULL,
140 p_global_attribute13 IN ra_customer_trx.global_attribute13%type default NULL,
141 p_global_attribute14 IN ra_customer_trx.global_attribute14%type default NULL,
142 p_global_attribute15 IN ra_customer_trx.global_attribute15%type default NULL,
143 p_global_attribute16 IN ra_customer_trx.global_attribute16%type default NULL,
144 p_global_attribute17 IN ra_customer_trx.global_attribute17%type default NULL,
145 p_global_attribute18 IN ra_customer_trx.global_attribute18%type default NULL,
146 p_global_attribute19 IN ra_customer_trx.global_attribute19%type default NULL,
147 p_global_attribute20 IN ra_customer_trx.global_attribute20%type default NULL,
148 p_global_attribute21 IN ra_customer_trx.global_attribute21%type default NULL,
149 p_global_attribute22 IN ra_customer_trx.global_attribute22%type default NULL,
150 p_global_attribute23 IN ra_customer_trx.global_attribute23%type default NULL,
151 p_global_attribute24 IN ra_customer_trx.global_attribute24%type default NULL,
152 p_global_attribute25 IN ra_customer_trx.global_attribute25%type default NULL,
153 p_global_attribute26 IN ra_customer_trx.global_attribute26%type default NULL,
154 p_global_attribute27 IN ra_customer_trx.global_attribute27%type default NULL,
155 p_global_attribute28 IN ra_customer_trx.global_attribute28%type default NULL,
156 p_global_attribute29 IN ra_customer_trx.global_attribute29%type default NULL,
157 p_global_attribute30 IN ra_customer_trx.global_attribute30%type default NULL,
158 p_start_date_commitment IN ra_customer_trx.start_date_commitment%type default NULL
159 );
160
161 PROCEDURE create_line_cm (
162 p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
163 p_batch_id IN ra_batches.batch_id%type,
164 p_trx_date IN ra_customer_trx.trx_date%type,
165 p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
166 p_complete_flag IN ra_customer_trx.complete_flag%type,
167 p_batch_source_id IN ra_batch_sources.batch_source_id%type,
168 p_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%type,
169 p_currency_code IN fnd_currencies.currency_code%type,
170 p_exchange_date IN ra_customer_trx.exchange_date%type,
171 p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
172 p_exchange_rate IN ra_customer_trx.exchange_rate%type,
173 p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
174 p_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
175 p_split_term_method IN ra_customer_trx.credit_method_for_installments%type,
176 p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
177 p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
178 p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
179 p_bill_to_address_id IN ra_customer_trx.bill_to_address_id%type,
180 p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
181 p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
182 p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
183 p_ship_to_address_id IN ra_customer_trx.ship_to_address_id%type,
184 p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
185 p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
186 p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
187 p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
188 p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
189 p_customer_bank_account_id IN
190 ra_customer_trx.customer_bank_account_id%type,
191 p_printing_option IN ra_customer_trx.printing_option%type,
192 p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
193 p_printing_pending IN ra_customer_trx.printing_pending%type,
194 p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
195 p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
196 p_reason_code IN ra_customer_trx.reason_code%type,
197 p_customer_reference IN ra_customer_trx.customer_reference%type,
198 p_customer_reference_date IN ra_customer_trx.customer_reference_date%type, p_internal_notes IN ra_customer_trx.internal_notes%type,
199 p_set_of_books_id IN ra_customer_trx.set_of_books_id%type,
200 p_created_from IN ra_customer_trx.created_from%type,
201 p_old_trx_number IN ra_customer_trx.old_trx_number%type,
202 p_attribute_category IN ra_customer_trx.attribute_category%type,
203 p_attribute1 IN ra_customer_trx.attribute1%type,
204 p_attribute2 IN ra_customer_trx.attribute2%type,
205 p_attribute3 IN ra_customer_trx.attribute3%type,
206 p_attribute4 IN ra_customer_trx.attribute4%type,
207 p_attribute5 IN ra_customer_trx.attribute5%type,
208 p_attribute6 IN ra_customer_trx.attribute6%type,
209 p_attribute7 IN ra_customer_trx.attribute7%type,
210 p_attribute8 IN ra_customer_trx.attribute8%type,
211 p_attribute9 IN ra_customer_trx.attribute9%type,
212 p_attribute10 IN ra_customer_trx.attribute10%type,
213 p_attribute11 IN ra_customer_trx.attribute11%type,
214 p_attribute12 IN ra_customer_trx.attribute12%type,
215 p_attribute13 IN ra_customer_trx.attribute13%type,
216 p_attribute14 IN ra_customer_trx.attribute14%type,
217 p_attribute15 IN ra_customer_trx.attribute15%type,
218 p_interface_header_context IN
219 ra_customer_trx.interface_header_context%type,
220 p_interface_header_attribute1 IN
221 ra_customer_trx.interface_header_attribute1%type,
222 p_interface_header_attribute2 IN
223 ra_customer_trx.interface_header_attribute2%type,
224 p_interface_header_attribute3 IN
225 ra_customer_trx.interface_header_attribute3%type,
226 p_interface_header_attribute4 IN
227 ra_customer_trx.interface_header_attribute4%type,
228 p_interface_header_attribute5 IN
229 ra_customer_trx.interface_header_attribute5%type,
230 p_interface_header_attribute6 IN
231 ra_customer_trx.interface_header_attribute6%type,
232 p_interface_header_attribute7 IN
233 ra_customer_trx.interface_header_attribute7%type,
234 p_interface_header_attribute8 IN
235 ra_customer_trx.interface_header_attribute8%type,
236 p_interface_header_attribute9 IN
237 ra_customer_trx.interface_header_attribute9%type,
238 p_interface_header_attribute10 IN
239 ra_customer_trx.interface_header_attribute10%type,
240 p_interface_header_attribute11 IN
241 ra_customer_trx.interface_header_attribute11%type,
242 p_interface_header_attribute12 IN
243 ra_customer_trx.interface_header_attribute12%type,
244 p_interface_header_attribute13 IN
245 ra_customer_trx.interface_header_attribute13%type,
246 p_interface_header_attribute14 IN
247 ra_customer_trx.interface_header_attribute14%type,
248 p_interface_header_attribute15 IN
249 ra_customer_trx.interface_header_attribute15%type,
250 p_default_ussgl_trx_code IN
251 ra_customer_trx.default_ussgl_transaction_code%type,
252 p_line_percent IN number,
253 p_freight_percent IN number,
254 p_line_amount IN ra_customer_trx_lines.extended_amount%type,
255 p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
256 p_compute_tax IN varchar2,
257 p_comments IN ra_customer_trx.comments%type,
258 p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
259 p_trx_number IN OUT NOCOPY ra_customer_trx.trx_number%type,
260 p_computed_tax_percent IN OUT NOCOPY number,
261 p_computed_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
262 p_errors OUT NOCOPY arp_trx_validate.Message_Tbl_Type,
263 p_status OUT NOCOPY varchar2,
264 p_credit_line_table IN arw_cm_cover.credit_lines_table_type,
265 p_purchase_order IN ra_customer_trx.purchase_order%type,
266 p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
267 p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
268 p_legal_entity_id IN ra_customer_trx.legal_entity_id%type,
269 /*4556000-4606558*/
270 p_global_attribute_category IN ra_customer_trx.global_attribute_category%type default null,
271 p_global_attribute1 IN ra_customer_trx.global_attribute1%type default NULL,
272 p_global_attribute2 IN ra_customer_trx.global_attribute2%type default NULL,
273 p_global_attribute3 IN ra_customer_trx.global_attribute3%type default NULL,
274 p_global_attribute4 IN ra_customer_trx.global_attribute4%type default NULL,
275 p_global_attribute5 IN ra_customer_trx.global_attribute5%type default NULL,
276 p_global_attribute6 IN ra_customer_trx.global_attribute6%type default NULL,
277 p_global_attribute7 IN ra_customer_trx.global_attribute7%type default NULL,
278 p_global_attribute8 IN ra_customer_trx.global_attribute8%type default NULL,
279 p_global_attribute9 IN ra_customer_trx.global_attribute9%type default NULL,
280 p_global_attribute10 IN ra_customer_trx.global_attribute10%type default NULL,
281 p_global_attribute11 IN ra_customer_trx.global_attribute11%type default NULL,
282 p_global_attribute12 IN ra_customer_trx.global_attribute12%type default NULL,
283 p_global_attribute13 IN ra_customer_trx.global_attribute13%type default NULL,
284 p_global_attribute14 IN ra_customer_trx.global_attribute14%type default NULL,
285 p_global_attribute15 IN ra_customer_trx.global_attribute15%type default NULL,
286 p_global_attribute16 IN ra_customer_trx.global_attribute16%type default NULL,
287 p_global_attribute17 IN ra_customer_trx.global_attribute17%type default NULL,
288 p_global_attribute18 IN ra_customer_trx.global_attribute18%type default NULL,
289 p_global_attribute19 IN ra_customer_trx.global_attribute19%type default NULL,
290 p_global_attribute20 IN ra_customer_trx.global_attribute20%type default NULL,
291 p_global_attribute21 IN ra_customer_trx.global_attribute21%type default NULL,
292 p_global_attribute22 IN ra_customer_trx.global_attribute22%type default NULL,
293 p_global_attribute23 IN ra_customer_trx.global_attribute23%type default NULL,
294 p_global_attribute24 IN ra_customer_trx.global_attribute24%type default NULL,
295 p_global_attribute25 IN ra_customer_trx.global_attribute25%type default NULL,
296 p_global_attribute26 IN ra_customer_trx.global_attribute26%type default NULL,
297 p_global_attribute27 IN ra_customer_trx.global_attribute27%type default NULL,
298 p_global_attribute28 IN ra_customer_trx.global_attribute28%type default NULL,
299 p_global_attribute29 IN ra_customer_trx.global_attribute29%type default NULL,
300 p_global_attribute30 IN ra_customer_trx.global_attribute30%type default NULL
301 );
302
303
304 END arw_cm_cover;