1 PACKAGE ARP_PROCESS_CREDIT_UPD_COVER AUTHID CURRENT_USER AS
2 /* $Header: ARTCCMUS.pls 115.5 2002/11/15 03:30:54 anukumar ship $ */
3
4 PROCEDURE update_header_cover(
5 p_form_name IN varchar2,
6 p_form_version IN number,
7 p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
8 p_trx_number IN ra_customer_trx.trx_number%type,
9 p_batch_id IN ra_batches.batch_id%type,
10 p_trx_date IN ra_customer_trx.trx_date%type,
11 p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
12 p_complete_flag IN ra_customer_trx.complete_flag%type,
13 p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
14 p_batch_source_id IN ra_batch_sources.batch_source_id%type,
15 p_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%type,
16 p_currency_code IN fnd_currencies.currency_code%type,
17 p_exchange_date IN ra_customer_trx.exchange_date%type,
18 p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
19 p_exchange_rate IN ra_customer_trx.exchange_rate%type,
20 p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
21 p_method_for_rules IN
22 ra_customer_trx.credit_method_for_rules%type,
23 p_split_term_method IN
24 ra_customer_trx.credit_method_for_installments%type,
25 p_initial_customer_trx_id IN
26 ra_customer_trx.initial_customer_trx_id%type,
27 p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
28 p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
29 p_bill_to_address_id IN ra_customer_trx.bill_to_address_id%type,
30 p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
31 p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
32 p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
33 p_ship_to_address_id IN ra_customer_trx.ship_to_address_id%type,
34 p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
35 p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
36 p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
37 p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
38 p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
39 p_customer_bank_account_id IN
40 ra_customer_trx.customer_bank_account_id%type,
41 p_printing_option IN ra_customer_trx.printing_option%type,
42 p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
43 p_printing_pending IN ra_customer_trx.printing_pending%type,
44 p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
45 p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
46 p_reason_code IN ra_customer_trx.reason_code%type,
47 p_customer_reference IN ra_customer_trx.customer_reference%type,
48 p_customer_reference_date IN
49 ra_customer_trx.customer_reference_date%type,
50 p_internal_notes IN ra_customer_trx.internal_notes%type,
51 p_set_of_books_id IN ra_customer_trx.set_of_books_id%type,
52 p_created_from IN ra_customer_trx.created_from%type,
53 p_old_trx_number IN ra_customer_trx.old_trx_number%type,
54 p_attribute_category IN ra_customer_trx.attribute_category%type,
55 p_attribute1 IN ra_customer_trx.attribute1%type,
56 p_attribute2 IN ra_customer_trx.attribute2%type,
57 p_attribute3 IN ra_customer_trx.attribute3%type,
58 p_attribute4 IN ra_customer_trx.attribute4%type,
59 p_attribute5 IN ra_customer_trx.attribute5%type,
60 p_attribute6 IN ra_customer_trx.attribute6%type,
61 p_attribute7 IN ra_customer_trx.attribute7%type,
62 p_attribute8 IN ra_customer_trx.attribute8%type,
63 p_attribute9 IN ra_customer_trx.attribute9%type,
64 p_attribute10 IN ra_customer_trx.attribute10%type,
65 p_attribute11 IN ra_customer_trx.attribute11%type,
66 p_attribute12 IN ra_customer_trx.attribute12%type,
67 p_attribute13 IN ra_customer_trx.attribute13%type,
68 p_attribute14 IN ra_customer_trx.attribute14%type,
69 p_attribute15 IN ra_customer_trx.attribute15%type,
70 p_interface_header_context IN
71 ra_customer_trx.interface_header_context%type,
72 p_interface_header_attribute1 IN
73 ra_customer_trx.interface_header_attribute1%type,
74 p_interface_header_attribute2 IN
75 ra_customer_trx.interface_header_attribute2%type,
76 p_interface_header_attribute3 IN
77 ra_customer_trx.interface_header_attribute3%type,
78 p_interface_header_attribute4 IN
79 ra_customer_trx.interface_header_attribute4%type,
80 p_interface_header_attribute5 IN
81 ra_customer_trx.interface_header_attribute5%type,
82 p_interface_header_attribute6 IN
83 ra_customer_trx.interface_header_attribute6%type,
84 p_interface_header_attribute7 IN
85 ra_customer_trx.interface_header_attribute7%type,
86 p_interface_header_attribute8 IN
87 ra_customer_trx.interface_header_attribute8%type,
88 p_interface_header_attribute9 IN
89 ra_customer_trx.interface_header_attribute9%type,
90 p_interface_header_attribute10 IN
91 ra_customer_trx.interface_header_attribute10%type,
92 p_interface_header_attribute11 IN
93 ra_customer_trx.interface_header_attribute11%type,
94 p_interface_header_attribute12 IN
95 ra_customer_trx.interface_header_attribute12%type,
96 p_interface_header_attribute13 IN
97 ra_customer_trx.interface_header_attribute13%type,
98 p_interface_header_attribute14 IN
99 ra_customer_trx.interface_header_attribute14%type,
100 p_interface_header_attribute15 IN
101 ra_customer_trx.interface_header_attribute15%type,
102 p_default_ussgl_trx_code IN
103 ra_customer_trx.default_ussgl_transaction_code%type,
104 p_line_percent IN number,
105 p_freight_percent IN number,
106 p_line_amount IN ra_customer_trx_lines.extended_amount%type,
107 p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
108 p_credit_amount IN ra_customer_trx_lines.extended_amount%type,
109 p_cr_txn_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
110 p_rederive_credit_info IN varchar2,
111 p_rerun_aa IN varchar2,
112 p_rerun_cm_module IN varchar2,
113 p_compute_tax IN varchar2,
114 p_comments IN ra_customer_trx.comments%type,
115 p_tax_percent IN OUT NOCOPY number,
116 p_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
117 p_status OUT NOCOPY varchar2);
118
119
120 END arp_process_credit_upd_cover;
121