1 PACKAGE ARP_CT_PKG AUTHID CURRENT_USER AS
2 /* $Header: ARTITRXS.pls 120.9 2010/11/30 17:29:43 nemani ship $ */
3
4 PROCEDURE set_to_dummy( p_trx_rec OUT NOCOPY ra_customer_trx%rowtype);
5
6 PROCEDURE lock_p( p_customer_trx_id IN ra_customer_trx.customer_trx_id%type );
7
8 PROCEDURE lock_fetch_p( p_trx_rec IN OUT NOCOPY ra_customer_trx%rowtype,
9 p_customer_trx_id IN
10 ra_customer_trx.customer_trx_id%type );
11
12 PROCEDURE lock_compare_p( p_trx_rec IN ra_customer_trx%rowtype,
13 p_customer_trx_id IN
14 ra_customer_trx.customer_trx_id%type,
15 p_lock_trx_flag IN BOOLEAN DEFAULT TRUE);
16
17 PROCEDURE fetch_p( p_trx_rec OUT NOCOPY ra_customer_trx%rowtype,
18 p_customer_trx_id IN ra_customer_trx.customer_trx_id%type);
19
20 procedure delete_p( p_customer_trx_id IN ra_customer_trx.customer_trx_id%type);
21
22 PROCEDURE update_p( p_trx_rec IN ra_customer_trx%rowtype,
23 p_customer_trx_id IN
24 ra_customer_trx.customer_trx_id%type);
25
26 PROCEDURE update_p_print( p_trx_rec IN ra_customer_trx%rowtype,
27 p_customer_trx_id IN
28 ra_customer_trx.customer_trx_id%type);
29
30 PROCEDURE update_tax( p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
31 p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
32 p_trx_date IN ra_customer_trx.trx_date%type,
33 p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
34 p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
35 P_TAX_AFFECT_FLAG in varchar2,
36 p_enforce_nat_acc_flag IN BOOLEAN);
37
38 PROCEDURE insert_p(
39 p_trx_rec IN ra_customer_trx%rowtype,
40 p_trx_number OUT NOCOPY ra_customer_trx.trx_number%type,
41 p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type
42 );
43
44 PROCEDURE display_header_p(
45 p_customer_trx_id IN ra_customer_trx.customer_trx_id%type);
46
47 PROCEDURE display_header_rec ( p_trx_rec IN ra_customer_trx%rowtype );
48
49 PROCEDURE lock_compare_frt_cover(
50 p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
51 p_ship_via IN ra_customer_trx.ship_via%type,
52 p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
53 p_waybill_number IN ra_customer_trx.waybill_number%type,
54 p_fob_point IN ra_customer_trx.fob_point%type);
55
56 PROCEDURE lock_compare_cover(
57 p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
58 p_trx_number IN ra_customer_trx.trx_number%type,
59 p_posting_control_id IN ra_customer_trx.posting_control_id%type,
60 p_ra_post_loop_number IN ra_customer_trx.ra_post_loop_number%type,
61 p_complete_flag IN ra_customer_trx.complete_flag%type,
62 p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
63 p_previous_customer_trx_id IN ra_customer_trx.previous_customer_trx_id%type,
64 p_related_customer_trx_id IN ra_customer_trx.related_customer_trx_id%type,
65 p_recurred_from_trx_number IN ra_customer_trx.recurred_from_trx_number%type,
66 p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
67 p_batch_id IN ra_customer_trx.batch_id%type,
68 p_batch_source_id IN ra_customer_trx.batch_source_id%type,
69 p_agreement_id IN ra_customer_trx.agreement_id%type,
70 p_trx_date IN ra_customer_trx.trx_date%type,
71 p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
72 p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
73 p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
74 p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
75 p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
76 p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
77 p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
78 p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,
79 p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,
80 p_customer_reference IN ra_customer_trx.customer_reference%type,
81 p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
82 p_cr_method_for_installments IN
83 ra_customer_trx.credit_method_for_installments%type,
84 p_credit_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
85 p_start_date_commitment IN ra_customer_trx.start_date_commitment%type,
86 p_end_date_commitment IN ra_customer_trx.end_date_commitment%type,
87 p_exchange_date IN ra_customer_trx.exchange_date%type,
91 p_finance_charges IN ra_customer_trx.finance_charges%type,
88 p_exchange_rate IN ra_customer_trx.exchange_rate%type,
89 p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
90 p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
92 p_fob_point IN ra_customer_trx.fob_point%type,
93 p_comments IN ra_customer_trx.comments%type,
94 p_internal_notes IN ra_customer_trx.internal_notes%type,
95 p_invoice_currency_code IN ra_customer_trx.invoice_currency_code%type,
96 p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
97 p_last_printed_sequence_num IN
98 ra_customer_trx.last_printed_sequence_num%type,
99 p_orig_system_batch_name IN ra_customer_trx.orig_system_batch_name%type,
100 p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
101 p_printing_count IN ra_customer_trx.printing_count%type,
102 p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
103 p_printing_option IN ra_customer_trx.printing_option%type,
104 p_printing_original_date IN ra_customer_trx.printing_original_date%type,
105 p_printing_pending IN ra_customer_trx.printing_pending%type,
106 p_purchase_order IN ra_customer_trx.purchase_order%type,
107 p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
108 p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
109 p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
110 p_remit_to_address_id IN ra_customer_trx.remit_to_address_id%type,
111 p_shipment_id IN ra_customer_trx.shipment_id%type,
112 p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
113 p_ship_via IN ra_customer_trx.ship_via%type,
114 p_term_due_date IN ra_customer_trx.term_due_date%type,
115 p_term_id IN ra_customer_trx.term_id%type,
116 p_territory_id IN ra_customer_trx.territory_id%type,
117 p_waybill_number IN ra_customer_trx.waybill_number%type,
118 p_status_trx IN ra_customer_trx.status_trx%type,
119 p_reason_code IN ra_customer_trx.reason_code%type,
120 p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
121 p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
122 p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
123 p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
124 p_related_batch_source_id IN ra_customer_trx.related_batch_source_id%type,
125 p_default_tax_exempt_flag IN ra_customer_trx.default_tax_exempt_flag%type,
126 p_created_from IN ra_customer_trx.created_from%type,
127 p_deflt_ussgl_trx_code_context IN
128 ra_customer_trx.default_ussgl_trx_code_context%type,
129 p_deflt_ussgl_transaction_code IN
130 ra_customer_trx.default_ussgl_transaction_code%type,
131 p_old_trx_number IN ra_customer_trx.old_trx_number%type,
132 p_interface_header_context IN
133 ra_customer_trx.interface_header_context%type,
134 p_interface_header_attribute1 IN
135 ra_customer_trx.interface_header_attribute1%type,
136 p_interface_header_attribute2 IN
137 ra_customer_trx.interface_header_attribute2%type,
138 p_interface_header_attribute3 IN
139 ra_customer_trx.interface_header_attribute3%type,
140 p_interface_header_attribute4 IN
141 ra_customer_trx.interface_header_attribute4%type,
142 p_interface_header_attribute5 IN
143 ra_customer_trx.interface_header_attribute5%type,
144 p_interface_header_attribute6 IN
145 ra_customer_trx.interface_header_attribute6%type,
146 p_interface_header_attribute7 IN
147 ra_customer_trx.interface_header_attribute7%type,
148 p_interface_header_attribute8 IN
149 ra_customer_trx.interface_header_attribute8%type,
150 p_interface_header_attribute9 IN
151 ra_customer_trx.interface_header_attribute9%type,
152 p_interface_header_attribute10 IN
153 ra_customer_trx.interface_header_attribute10%type,
154 p_interface_header_attribute11 IN
155 ra_customer_trx.interface_header_attribute11%type,
156 p_interface_header_attribute12 IN
157 ra_customer_trx.interface_header_attribute12%type,
158 p_interface_header_attribute13 IN
159 ra_customer_trx.interface_header_attribute13%type,
160 p_interface_header_attribute14 IN
161 ra_customer_trx.interface_header_attribute14%type,
162 p_interface_header_attribute15 IN
163 ra_customer_trx.interface_header_attribute15%type,
164 p_attribute_category IN ra_customer_trx.attribute_category%type,
165 p_attribute1 IN ra_customer_trx.attribute1%type,
166 p_attribute2 IN ra_customer_trx.attribute2%type,
167 p_attribute3 IN ra_customer_trx.attribute3%type,
168 p_attribute4 IN ra_customer_trx.attribute4%type,
169 p_attribute5 IN ra_customer_trx.attribute5%type,
170 p_attribute6 IN ra_customer_trx.attribute6%type,
171 p_attribute7 IN ra_customer_trx.attribute7%type,
175 p_attribute11 IN ra_customer_trx.attribute11%type,
172 p_attribute8 IN ra_customer_trx.attribute8%type,
173 p_attribute9 IN ra_customer_trx.attribute9%type,
174 p_attribute10 IN ra_customer_trx.attribute10%type,
176 p_attribute12 IN ra_customer_trx.attribute12%type,
177 p_attribute13 IN ra_customer_trx.attribute13%type,
178 p_attribute14 IN ra_customer_trx.attribute14%type,
179 p_attribute15 IN ra_customer_trx.attribute15%type,
180 p_legal_entity_id IN ra_customer_trx.legal_entity_id%type,
181 p_payment_trxn_extension_id IN ra_customer_trx.payment_trxn_extension_id%type,
182 p_billing_date IN ra_customer_trx.billing_date%type,
183 p_lock_trx_flag IN BOOLEAN DEFAULT TRUE);
184
185
186 PROCEDURE lock_compare_cover(
187 p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
188 p_trx_number IN ra_customer_trx.trx_number%type,
189 p_posting_control_id IN ra_customer_trx.posting_control_id%type,
190 p_ra_post_loop_number IN ra_customer_trx.ra_post_loop_number%type,
191 p_complete_flag IN ra_customer_trx.complete_flag%type,
192 p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
193 p_previous_customer_trx_id IN ra_customer_trx.previous_customer_trx_id%type,
194 p_related_customer_trx_id IN ra_customer_trx.related_customer_trx_id%type,
195 p_recurred_from_trx_number IN ra_customer_trx.recurred_from_trx_number%type,
196 p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
197 p_batch_id IN ra_customer_trx.batch_id%type,
198 p_batch_source_id IN ra_customer_trx.batch_source_id%type,
199 p_agreement_id IN ra_customer_trx.agreement_id%type,
200 p_trx_date IN ra_customer_trx.trx_date%type,
201 p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
202 p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
203 p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
204 p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
205 p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
206 p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
207 p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
208 p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,
209 p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,
210 p_customer_reference IN ra_customer_trx.customer_reference%type,
211 p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
212 p_cr_method_for_installments IN
213 ra_customer_trx.credit_method_for_installments%type,
214 p_credit_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
215 p_start_date_commitment IN ra_customer_trx.start_date_commitment%type,
216 p_end_date_commitment IN ra_customer_trx.end_date_commitment%type,
217 p_exchange_date IN ra_customer_trx.exchange_date%type,
218 p_exchange_rate IN ra_customer_trx.exchange_rate%type,
219 p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
220 p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
221 p_finance_charges IN ra_customer_trx.finance_charges%type,
222 p_fob_point IN ra_customer_trx.fob_point%type,
223 p_comments IN ra_customer_trx.comments%type,
224 p_internal_notes IN ra_customer_trx.internal_notes%type,
225 p_invoice_currency_code IN ra_customer_trx.invoice_currency_code%type,
226 p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
227 p_last_printed_sequence_num IN
228 ra_customer_trx.last_printed_sequence_num%type,
229 p_orig_system_batch_name IN ra_customer_trx.orig_system_batch_name%type,
230 p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
231 p_printing_count IN ra_customer_trx.printing_count%type,
232 p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
233 p_printing_option IN ra_customer_trx.printing_option%type,
234 p_printing_original_date IN ra_customer_trx.printing_original_date%type,
235 p_printing_pending IN ra_customer_trx.printing_pending%type,
236 p_purchase_order IN ra_customer_trx.purchase_order%type,
237 p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
238 p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
239 p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
240 p_remit_to_address_id IN ra_customer_trx.remit_to_address_id%type,
241 p_shipment_id IN ra_customer_trx.shipment_id%type,
242 p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
243 p_ship_via IN ra_customer_trx.ship_via%type,
244 p_term_due_date IN ra_customer_trx.term_due_date%type,
245 p_term_id IN ra_customer_trx.term_id%type,
246 p_territory_id IN ra_customer_trx.territory_id%type,
247 p_waybill_number IN ra_customer_trx.waybill_number%type,
248 p_status_trx IN ra_customer_trx.status_trx%type,
249 p_reason_code IN ra_customer_trx.reason_code%type,
250 p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
251 p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
252 p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
253 p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
254 p_related_batch_source_id IN ra_customer_trx.related_batch_source_id%type,
255 p_default_tax_exempt_flag IN ra_customer_trx.default_tax_exempt_flag%type,
256 p_created_from IN ra_customer_trx.created_from%type,
260 ra_customer_trx.default_ussgl_transaction_code%type,
257 p_deflt_ussgl_trx_code_context IN
258 ra_customer_trx.default_ussgl_trx_code_context%type,
259 p_deflt_ussgl_transaction_code IN
261 p_old_trx_number IN ra_customer_trx.old_trx_number%type,
262 p_interface_header_context IN
263 ra_customer_trx.interface_header_context%type,
264 p_interface_header_attribute1 IN
265 ra_customer_trx.interface_header_attribute1%type,
266 p_interface_header_attribute2 IN
267 ra_customer_trx.interface_header_attribute2%type,
268 p_interface_header_attribute3 IN
269 ra_customer_trx.interface_header_attribute3%type,
270 p_interface_header_attribute4 IN
271 ra_customer_trx.interface_header_attribute4%type,
272 p_interface_header_attribute5 IN
273 ra_customer_trx.interface_header_attribute5%type,
274 p_interface_header_attribute6 IN
275 ra_customer_trx.interface_header_attribute6%type,
276 p_interface_header_attribute7 IN
277 ra_customer_trx.interface_header_attribute7%type,
278 p_interface_header_attribute8 IN
279 ra_customer_trx.interface_header_attribute8%type,
280 p_interface_header_attribute9 IN
281 ra_customer_trx.interface_header_attribute9%type,
282 p_interface_header_attribute10 IN
283 ra_customer_trx.interface_header_attribute10%type,
284 p_interface_header_attribute11 IN
285 ra_customer_trx.interface_header_attribute11%type,
286 p_interface_header_attribute12 IN
287 ra_customer_trx.interface_header_attribute12%type,
288 p_interface_header_attribute13 IN
289 ra_customer_trx.interface_header_attribute13%type,
290 p_interface_header_attribute14 IN
291 ra_customer_trx.interface_header_attribute14%type,
292 p_interface_header_attribute15 IN
293 ra_customer_trx.interface_header_attribute15%type,
294 p_attribute_category IN ra_customer_trx.attribute_category%type,
295 p_attribute1 IN ra_customer_trx.attribute1%type,
296 p_attribute2 IN ra_customer_trx.attribute2%type,
297 p_attribute3 IN ra_customer_trx.attribute3%type,
298 p_attribute4 IN ra_customer_trx.attribute4%type,
299 p_attribute5 IN ra_customer_trx.attribute5%type,
300 p_attribute6 IN ra_customer_trx.attribute6%type,
301 p_attribute7 IN ra_customer_trx.attribute7%type,
302 p_attribute8 IN ra_customer_trx.attribute8%type,
303 p_attribute9 IN ra_customer_trx.attribute9%type,
304 p_attribute10 IN ra_customer_trx.attribute10%type,
305 p_attribute11 IN ra_customer_trx.attribute11%type,
306 p_attribute12 IN ra_customer_trx.attribute12%type,
307 p_attribute13 IN ra_customer_trx.attribute13%type,
308 p_attribute14 IN ra_customer_trx.attribute14%type,
309 p_attribute15 IN ra_customer_trx.attribute15%type,
310 p_global_attribute_category IN ra_customer_trx.global_attribute_category%type,
311 p_global_attribute1 IN ra_customer_trx.global_attribute1%type,
312 p_global_attribute2 IN ra_customer_trx.global_attribute2%type,
313 p_global_attribute3 IN ra_customer_trx.global_attribute3%type,
314 p_global_attribute4 IN ra_customer_trx.global_attribute4%type,
315 p_global_attribute5 IN ra_customer_trx.global_attribute5%type,
316 p_global_attribute6 IN ra_customer_trx.global_attribute6%type,
317 p_global_attribute7 IN ra_customer_trx.global_attribute7%type,
318 p_global_attribute8 IN ra_customer_trx.global_attribute8%type,
319 p_global_attribute9 IN ra_customer_trx.global_attribute9%type,
320 p_global_attribute10 IN ra_customer_trx.global_attribute10%type,
321 p_global_attribute11 IN ra_customer_trx.global_attribute11%type,
322 p_global_attribute12 IN ra_customer_trx.global_attribute12%type,
323 p_global_attribute13 IN ra_customer_trx.global_attribute13%type,
324 p_global_attribute14 IN ra_customer_trx.global_attribute14%type,
325 p_global_attribute15 IN ra_customer_trx.global_attribute15%type,
326 p_global_attribute16 IN ra_customer_trx.global_attribute16%type,
327 p_global_attribute17 IN ra_customer_trx.global_attribute17%type,
328 p_global_attribute18 IN ra_customer_trx.global_attribute18%type,
329 p_global_attribute19 IN ra_customer_trx.global_attribute19%type,
330 p_global_attribute20 IN ra_customer_trx.global_attribute20%type,
331 p_global_attribute21 IN ra_customer_trx.global_attribute21%type,
332 p_global_attribute22 IN ra_customer_trx.global_attribute22%type,
336 p_global_attribute26 IN ra_customer_trx.global_attribute26%type,
333 p_global_attribute23 IN ra_customer_trx.global_attribute23%type,
334 p_global_attribute24 IN ra_customer_trx.global_attribute24%type,
335 p_global_attribute25 IN ra_customer_trx.global_attribute25%type,
337 p_global_attribute27 IN ra_customer_trx.global_attribute27%type,
338 p_global_attribute28 IN ra_customer_trx.global_attribute28%type,
339 p_global_attribute29 IN ra_customer_trx.global_attribute29%type,
340 p_global_attribute30 IN ra_customer_trx.global_attribute30%type,
341 p_legal_entity_id IN ra_customer_trx.legal_entity_id%type,
342 p_payment_trxn_extension_id IN ra_customer_trx.payment_trxn_extension_id%type,
343 p_billing_date IN ra_customer_trx.billing_date%type);
344
345
346
347 FUNCTION get_text_dummy(p_null IN NUMBER DEFAULT null) RETURN varchar2;
348
349 FUNCTION get_flag_dummy(p_null IN NUMBER DEFAULT null) RETURN varchar2;
350
351 FUNCTION get_number_dummy(p_null IN NUMBER DEFAULT null) RETURN number;
352
353 FUNCTION get_date_dummy(p_null IN NUMBER DEFAULT null) RETURN date;
354
355
356 END ARP_CT_PKG;