DBA Data[Home] [Help]

PACKAGE: APPS.AR_OM_PREPAY_REFUND_PVT

Source


1 PACKAGE AR_OM_PREPAY_REFUND_PVT  AUTHID CURRENT_USER AS
2 /* $Header: AROMRFNS.pls 120.2 2005/10/30 03:55:48 appldev noship $ */
3 
4 /*=======================================================================+
5  |  Declare PUBLIC Data Types and Variables
6  +=======================================================================*/
7     temp_variable1 VARCHAR2(10);
8 
9 /*=======================================================================+
10  |  Declare PUBLIC Exceptions
11  +=======================================================================*/
12     temp_exception EXCEPTION;
13 
14 
15 /*========================================================================
16  | PUBLIC Procedure refund_prepayment_wrapper
17  |
18  | DESCRIPTION
19  |       This wrapper is same as ar_prepayments except this accepts 1 additional parameter
20  |       p_bank_account_id  : This paramter along with p_receipt_method_id
21  |       if having a value populate the global  variables in
22  |       AR_PREPAYMENTS.Refund_Prepayment
23  |      ------------------------------------------------------------------------------
24  |
25  | PSEUDO CODE/LOGIC
26  |
27  | PARAMETERS
28  |
29  |
30  | RETURNS
31  |      nothing
32  |
33  | KNOWN ISSUES
34  |
35  |
36  |
37  | NOTES
38  |
39  |
40  |
41  | MODIFICATION HISTORY
42  | Date                  Author         Description of Changes
43  | 14-AUG-2003           Jyoti Pandey   Created
44  |
45  *=======================================================================*/
46  PROCEDURE Refund_Prepayment_Wrapper(
47     -- Standard API parameters.
48       p_api_version                IN  NUMBER,
49       p_init_msg_list              IN  VARCHAR2 := FND_API.G_FALSE,
50       p_commit                     IN  VARCHAR2 := FND_API.G_FALSE,
51       p_validation_level           IN  NUMBER   := FND_API.G_VALID_LEVEL_FULL,
52       x_return_status              OUT NOCOPY VARCHAR2,
53       x_msg_count                  OUT NOCOPY NUMBER,
54       x_msg_data                   OUT NOCOPY VARCHAR2,
55       p_prepay_application_id      OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
56       p_number_of_refund_receipts  OUT NOCOPY NUMBER,
57     -------Multiple prepayments projecti Additional parameter for credit card
58     -------refunds to be populated as global variables
59       p_bank_account_id   IN NUMBER,
60       p_receipt_method_id IN NUMBER,
61 
62       p_receipt_number             IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
63       p_cash_receipt_id            IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
64       p_receivable_application_id  IN  ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
65       p_receivables_trx_id         IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,
66       p_refund_amount              IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
67       p_refund_date                IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
68       p_refund_gl_date             IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
69       p_ussgl_transaction_code     IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
70       p_attribute_rec              IN ar_receipt_api_pub.attribute_rec_type
71                                       DEFAULT ar_receipt_api_pub.attribute_rec_const,
72     -- ******* Global Flexfield parameters *******
73       p_global_attribute_rec       IN ar_receipt_api_pub.global_attribute_rec_type
74                                       DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
75       p_comments                   IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
76       p_payment_set_id             IN NUMBER DEFAULT NULL
77     ) ;
78 
79 
80 END AR_OM_PREPAY_REFUND_PVT;