[Home] [Help]
PACKAGE: APPS.AR_REFUNDS_PVT
Source
1 PACKAGE AR_REFUNDS_PVT AUTHID CURRENT_USER AS
2 /* $Header: ARXVREFS.pls 120.2.12010000.5 2009/02/26 06:50:24 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
52 ,p_remittance_message2 IN ap_invoices.remittance_message2%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
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 ------------------------------- Bug7525965 Changes Start Here ------------------------------
64 ,p_payment_priority IN ap_invoices_interface.PAYMENT_PRIORITY%TYPE DEFAULT NULL
65 ,p_terms_id IN ap_invoices_interface.TERMS_ID%TYPE DEFAULT NULL
66 ------------------------------- Bug7525965 Changes End Here --------------------------------
67 ,p_gl_date IN DATE DEFAULT NULL); --Bug8283120
68
69 /*========================================================================
70 | PUBLIC PROCEDURE Cancel_Refund
71 |
72 | DESCRIPTION
73 | ----------------------------------------
74 | This procedure cancels a refund payment in Oracle Payments
75 | via AP interface tables and APIs
76 |
77 |
78 | PSEUDO CODE/LOGIC
79 |
80 | PARAMETERS
81 |
82 | KNOWN ISSUES
83 |
84 | NOTES
85 |
86 | MODIFICATION HISTORY
87 | Date Author Description of Changes
88 | 06-DEC-2005 JBECKETT Created
89 |
90 *=======================================================================*/
91 PROCEDURE cancel_refund(
92 p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE
93 ,p_gl_date IN DATE
94 ,x_return_status OUT NOCOPY VARCHAR2
95 ,x_msg_count OUT NOCOPY NUMBER
96 ,x_msg_data OUT NOCOPY VARCHAR2);
97
98 END AR_REFUNDS_PVT;