1 PACKAGE ARP_PROC_RECEIPTS1 AS
2 /* $Header: ARRERG1S.pls 120.3 2005/08/29 16:03:14 sgnagara ship $ */
3
4
5 FUNCTION revision RETURN VARCHAR2;
6
7 PROCEDURE update_cash_receipt(
8 p_cash_receipt_id IN NUMBER,
9 p_status IN VARCHAR2,
10 p_currency_code IN VARCHAR2,
11 p_amount IN NUMBER,
12 p_pay_from_customer IN NUMBER,
13 p_receipt_number IN VARCHAR2,
14 p_receipt_date IN DATE,
15 p_gl_date IN DATE,
16 p_maturity_date IN DATE,
17 p_comments IN VARCHAR2,
18 p_exchange_rate_type IN VARCHAR2,
19 p_exchange_rate IN NUMBER,
20 p_exchange_date IN DATE,
21 p_attribute_category IN VARCHAR2,
22 p_attribute1 IN VARCHAR2,
23 p_attribute2 IN VARCHAR2,
24 p_attribute3 IN VARCHAR2,
25 p_attribute4 IN VARCHAR2,
26 p_attribute5 IN VARCHAR2,
27 p_attribute6 IN VARCHAR2,
28 p_attribute7 IN VARCHAR2,
29 p_attribute8 IN VARCHAR2,
30 p_attribute9 IN VARCHAR2,
31 p_attribute10 IN VARCHAR2,
32 p_attribute11 IN VARCHAR2,
33 p_attribute12 IN VARCHAR2,
34 p_attribute13 IN VARCHAR2,
35 p_attribute14 IN VARCHAR2,
36 p_attribute15 IN VARCHAR2,
37 p_override_remit_account_flag IN VARCHAR2,
38 p_remittance_bank_account_id IN NUMBER,
39 p_customer_bank_account_id IN NUMBER,
40 p_customer_site_use_id IN NUMBER,
41 p_customer_receipt_reference IN VARCHAR2,
42 p_factor_discount_amount IN NUMBER,
43 p_deposit_date IN DATE,
44 p_receipt_method_id IN NUMBER,
45 p_doc_sequence_value IN NUMBER,
46 p_doc_sequence_id IN NUMBER,
47 p_ussgl_transaction_code IN VARCHAR2,
48 p_vat_tax_id IN NUMBER,
49 --
50 p_confirm_date IN DATE,
51 p_confirm_gl_date IN DATE,
52 p_unconfirm_gl_date IN DATE,
53 p_postmark_date IN DATE, -- ARTA Changes
54 -- ******* Rate Adjustment parameters: ********
55 p_rate_adjust_gl_date IN DATE,
56 p_new_exchange_date IN DATE,
57 p_new_exchange_rate IN NUMBER,
58 p_new_exchange_rate_type IN VARCHAR2,
59 p_gain_loss IN NUMBER,
60 p_exchange_rate_attr_cat IN VARCHAR2,
61 p_exchange_rate_attr1 IN VARCHAR2,
62 p_exchange_rate_attr2 IN VARCHAR2,
63 p_exchange_rate_attr3 IN VARCHAR2,
64 p_exchange_rate_attr4 IN VARCHAR2,
65 p_exchange_rate_attr5 IN VARCHAR2,
66 p_exchange_rate_attr6 IN VARCHAR2,
67 p_exchange_rate_attr7 IN VARCHAR2,
68 p_exchange_rate_attr8 IN VARCHAR2,
69 p_exchange_rate_attr9 IN VARCHAR2,
70 p_exchange_rate_attr10 IN VARCHAR2,
71 p_exchange_rate_attr11 IN VARCHAR2,
72 p_exchange_rate_attr12 IN VARCHAR2,
73 p_exchange_rate_attr13 IN VARCHAR2,
74 p_exchange_rate_attr14 IN VARCHAR2,
75 p_exchange_rate_attr15 IN VARCHAR2,
76 --
77 -- ********* Reversal Info ***********
78 --
79 p_reversal_date IN DATE,
80 p_reversal_gl_date IN DATE,
81 p_reversal_category IN VARCHAR2,
82 p_reversal_comments IN VARCHAR2,
83 p_reversal_reason_code IN VARCHAR2,
84 p_dm_reversal_flag IN varchar2,
85 p_dm_cust_trx_type_id IN NUMBER,
86 p_dm_cust_trx_type IN VARCHAR2,
87 p_cc_id IN NUMBER,
88 p_dm_number OUT NOCOPY VARCHAR2,
89 p_dm_doc_sequence_value IN NUMBER,
90 p_dm_doc_sequence_id IN NUMBER,
91 p_tw_status IN OUT NOCOPY VARCHAR2,
92 --
93 p_anticipated_clearing_date IN DATE,
94 p_customer_bank_branch_id IN NUMBER,
95 --
96 -- ******* Global Flexfield parameters *******
97 --
98 p_global_attribute1 IN VARCHAR2,
99 p_global_attribute2 IN VARCHAR2,
100 p_global_attribute3 IN VARCHAR2,
101 p_global_attribute4 IN VARCHAR2,
102 p_global_attribute5 IN VARCHAR2,
103 p_global_attribute6 IN VARCHAR2,
104 p_global_attribute7 IN VARCHAR2,
105 p_global_attribute8 IN VARCHAR2,
106 p_global_attribute9 IN VARCHAR2,
107 p_global_attribute10 IN VARCHAR2,
108 p_global_attribute11 IN VARCHAR2,
109 p_global_attribute12 IN VARCHAR2,
110 p_global_attribute13 IN VARCHAR2,
111 p_global_attribute14 IN VARCHAR2,
112 p_global_attribute15 IN VARCHAR2,
113 p_global_attribute16 IN VARCHAR2,
114 p_global_attribute17 IN VARCHAR2,
115 p_global_attribute18 IN VARCHAR2,
116 p_global_attribute19 IN VARCHAR2,
117 p_global_attribute20 IN VARCHAR2,
118 p_global_attribute_category IN VARCHAR2,
119 --
120 -- ******* Notes Receivable Information *******
121 p_issuer_name IN VARCHAR2,
122 p_issue_date IN DATE,
123 p_issuer_bank_branch_id IN NUMBER,
124 --
125 -- ****** Enhancement 2074220 *************
126 p_application_notes IN VARCHAR2,
127 --
128 -- ******* Receipt State/Status Return information ******
129 --
130 p_new_state OUT NOCOPY VARCHAR2,
131 p_new_state_dsp OUT NOCOPY VARCHAR2,
132 p_new_status OUT NOCOPY VARCHAR2,
133 p_new_status_dsp OUT NOCOPY VARCHAR2,
134 --
135 -- ******* Form information ********
136 p_form_name IN VARCHAR2,
137 p_form_version IN VARCHAR2,
138 --
139 -- ******* Credit Card changes
140 p_payment_server_order_num IN VARCHAR2,
141 p_approval_code IN VARCHAR2,
142 p_legal_entity_id IN NUMBER DEFAULT NULL,
143 p_payment_trxn_extension_id IN NUMBER DEFAULT NULL /* PAYMENT_UPTAKE */
144 );
145
146 END ARP_PROC_RECEIPTS1;