[Home] [Help]
PACKAGE: APPS.AR_REFUNDS_PVT
Source
1 PACKAGE AR_REFUNDS_PVT AS
2 /* $Header: ARXVREFS.pls 120.2.12010000.2 2008/08/04 06:39:05 npanchak ship $ */
3
4 /*=======================================================================+
5 | Declare PUBLIC Data Types and Variables
6 +=======================================================================*/
7 G_PKG_NAME CONSTANT VARCHAR2(30):= 'AR_REFUNDS_PVT';
8
9 /*=======================================================================+
10 | Declare PUBLIC Exceptions
11 +=======================================================================*/
12
13 /*========================================================================
14 | PUBLIC PROCEDURE Create_Refund
15 |
16 | DESCRIPTION
17 | ----------------------------------------
18 | This procedure creates a refund payment in Oracle Payments
19 | via AP interface tables and APIs
20 |
21 |
22 | PSEUDO CODE/LOGIC
23 |
24 | PARAMETERS
25 |
26 | KNOWN ISSUES
27 |
28 | NOTES
29 |
30 | MODIFICATION HISTORY
31 | Date Author Description of Changes
32 | 06-DEC-2005 JBECKETT Created
33 |
34 *=======================================================================*/
35 PROCEDURE create_refund(
36 p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE
37 ,p_amount IN NUMBER
38 ,p_currency_code IN fnd_currencies.currency_code%TYPE
39 ,p_exchange_rate IN NUMBER
40 ,p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE
41 ,p_exchange_date IN DATE
42 ,p_description IN VARCHAR2
43 ,p_pay_group_lookup_code IN FND_LOOKUPS.lookup_code%TYPE
44 ,p_pay_alone_flag IN VARCHAR2
45 ,p_org_id IN ar_cash_receipts.org_id%TYPE
46 ,p_legal_entity_id IN ar_cash_receipts.legal_entity_id%TYPE
47 ,p_payment_method_code IN ap_invoices.payment_method_code%TYPE
48 ,p_payment_reason_code IN ap_invoices.payment_reason_code%TYPE
49 ,p_payment_reason_comments IN ap_invoices.payment_reason_comments%TYPE
50 ,p_delivery_channel_code IN ap_invoices.delivery_channel_code%TYPE
51 ,p_remittance_message1 IN ap_invoices.remittance_message1%TYPE
52 ,p_remittance_message2 IN ap_invoices.remittance_message2%TYPE
53 ,p_remittance_message3 IN ap_invoices.remittance_message3%TYPE
54 ,p_party_id IN hz_parties.party_id%TYPE
55 ,p_party_site_id IN hz_party_sites.party_site_id%TYPE
56 ,p_bank_account_id IN ar_cash_receipts.customer_bank_account_id%TYPE
57 ,p_called_from IN VARCHAR2
58 ,x_invoice_id OUT NOCOPY ap_invoices.invoice_id%TYPE
59 ,x_return_status OUT NOCOPY VARCHAR2
60 ,x_msg_count OUT NOCOPY NUMBER
61 ,x_msg_data OUT NOCOPY VARCHAR2
62 ,p_invoice_date IN ap_invoices.invoice_date%TYPE DEFAULT NULL); -- Bug 7242125
63
64 /*========================================================================
65 | PUBLIC PROCEDURE Cancel_Refund
66 |
67 | DESCRIPTION
68 | ----------------------------------------
69 | This procedure cancels a refund payment in Oracle Payments
70 | via AP interface tables and APIs
71 |
72 |
73 | PSEUDO CODE/LOGIC
74 |
75 | PARAMETERS
76 |
77 | KNOWN ISSUES
78 |
79 | NOTES
80 |
81 | MODIFICATION HISTORY
82 | Date Author Description of Changes
83 | 06-DEC-2005 JBECKETT Created
84 |
85 *=======================================================================*/
86 PROCEDURE cancel_refund(
87 p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE
88 ,p_gl_date IN DATE
89 ,x_return_status OUT NOCOPY VARCHAR2
90 ,x_msg_count OUT NOCOPY NUMBER
91 ,x_msg_data OUT NOCOPY VARCHAR2);
92
93 END AR_REFUNDS_PVT;