1 PACKAGE ARP_PROC_RECEIPTS2 AUTHID CURRENT_USER AS
2 /* $Header: ARRERG2S.pls 120.3.12010000.2 2009/02/02 14:34:52 mpsingh ship $ */
3
4 FUNCTION revision RETURN VARCHAR2;
5
6 PROCEDURE insert_cash_receipt(
7 p_currency_code IN VARCHAR2,
8 p_amount IN NUMBER,
9 p_pay_from_customer IN NUMBER,
10 p_receipt_number IN VARCHAR2,
11 p_receipt_date IN DATE,
12 p_gl_date IN DATE,
13 p_maturity_date IN DATE,
14 p_comments IN VARCHAR2,
15 p_exchange_rate_type IN VARCHAR2,
16 p_exchange_rate IN NUMBER,
17 p_exchange_date IN DATE,
18 p_batch_id IN NUMBER,
19 p_attribute_category IN VARCHAR2,
20 p_attribute1 IN VARCHAR2,
21 p_attribute2 IN VARCHAR2,
22 p_attribute3 IN VARCHAR2,
23 p_attribute4 IN VARCHAR2,
24 p_attribute5 IN VARCHAR2,
25 p_attribute6 IN VARCHAR2,
26 p_attribute7 IN VARCHAR2,
27 p_attribute8 IN VARCHAR2,
28 p_attribute9 IN VARCHAR2,
29 p_attribute10 IN VARCHAR2,
30 p_attribute11 IN VARCHAR2,
31 p_attribute12 IN VARCHAR2,
32 p_attribute13 IN VARCHAR2,
33 p_attribute14 IN VARCHAR2,
34 p_attribute15 IN VARCHAR2,
35 p_override_remit_account_flag IN VARCHAR2,
36 p_remittance_bank_account_id IN NUMBER,
37 p_customer_bank_account_id IN NUMBER,
38 p_customer_site_use_id IN NUMBER,
39 p_customer_receipt_reference IN VARCHAR2,
40 p_factor_discount_amount IN NUMBER,
41 p_deposit_date IN DATE,
42 p_receipt_method_id IN NUMBER,
43 p_doc_sequence_value IN NUMBER,
44 p_doc_sequence_id IN NUMBER,
45 p_ussgl_transaction_code IN VARCHAR2,
46 p_vat_tax_id IN NUMBER,
47 p_anticipated_clearing_date IN DATE,
48 p_customer_bank_branch_id IN NUMBER,
49 -- ARTA Changes
50 p_postmark_date IN DATE,
51 --
52 -- ******* Global Flexfield parameters *******
53 --
54 p_global_attribute1 IN VARCHAR2,
55 p_global_attribute2 IN VARCHAR2,
56 p_global_attribute3 IN VARCHAR2,
57 p_global_attribute4 IN VARCHAR2,
58 p_global_attribute5 IN VARCHAR2,
59 p_global_attribute6 IN VARCHAR2,
60 p_global_attribute7 IN VARCHAR2,
61 p_global_attribute8 IN VARCHAR2,
62 p_global_attribute9 IN VARCHAR2,
63 p_global_attribute10 IN VARCHAR2,
64 p_global_attribute11 IN VARCHAR2,
65 p_global_attribute12 IN VARCHAR2,
66 p_global_attribute13 IN VARCHAR2,
67 p_global_attribute14 IN VARCHAR2,
68 p_global_attribute15 IN VARCHAR2,
69 p_global_attribute16 IN VARCHAR2,
70 p_global_attribute17 IN VARCHAR2,
71 p_global_attribute18 IN VARCHAR2,
72 p_global_attribute19 IN VARCHAR2,
73 p_global_attribute20 IN VARCHAR2,
74 p_global_attribute_category IN VARCHAR2,
75 --
76 -- *** Notes Receivable Additional Information ***
77 --
78 p_issuer_name IN VARCHAR2,
79 p_issue_date IN DATE,
80 p_issuer_bank_branch_id IN NUMBER,
81 --
82 -- *** enhancement 2074220 ***
83 p_application_notes IN VARCHAR2,
84 --
85 p_cr_id OUT NOCOPY NUMBER,
86 p_ps_id OUT NOCOPY NUMBER,
87 p_row_id OUT NOCOPY VARCHAR2,
88 --
89 p_form_name IN varchar2,
90 p_form_version IN varchar2,
91 p_called_from IN VARCHAR2 DEFAULT NULL, /* BR */
92 p_le_id IN NUMBER DEFAULT NULL,
93 p_payment_trxn_extension_id IN NUMBER DEFAULT NULL, /* bichatte payment uptake */
94 p_automatch_set_id IN NUMBER DEFAULT NULL, /* ER Automatch Application */
95 p_autoapply_flag IN VARCHAR2 DEFAULT NULL
96 );
97
98 PROCEDURE remit_cash_receipt(
99 p_cash_receipt_id IN NUMBER,
100 x_return_status OUT NOCOPY VARCHAR2
101 );
102
103 END ARP_PROC_RECEIPTS2;