[Home] [Help]
PACKAGE: APPS.ARP_PA_UTILS
Source
1 PACKAGE ARP_PA_UTILS AUTHID CURRENT_USER AS
2 /* $Header: ARXPAUTS.pls 120.0.12010000.2 2008/11/24 07:59:33 rsamanta ship $ */
3
4 /*=======================================================================+
5 | Declare PUBLIC Data Types and Variables
6 +=======================================================================*/
7
8 /*=======================================================================+
9 | Declare PUBLIC Exceptions
10 +=======================================================================*/
11
12 /*========================================================================
13 | PUBLIC Procedure get_line_applied
14 |
15 | DESCRIPTION
16 | This function returns the total line amount applied and
17 | corresponding exchange rate gain and/or loss as of given date for the
18 | the given invoice.
19 |
20 | PSEUDO CODE/LOGIC
21 |
22 | PARAMETERS
23 | IN
24 | p_customer_trx_id
25 | p_as_of_date
26 | OUT NOCOPY
27 | x_line_applied - Line applied
28 | x_line_acctd_applied - Line applied in Functional Currency
29 | x_xchange_gain - Exchange Gain
30 | x_xchange_loss - Exchange Loss
31 | x_return_status - Standard return status
32 | x_msg_data - Standard msg data
33 | x_msg_count - Standard msg count
34 |
35 |
36 | RETURNS
37 | nothing
38 |
39 | KNOWN ISSUES
40 |
41 |
42 |
43 | NOTES
44 |
45 |
46 | MODIFICATION HISTORY
47 | Date Author Description of Changes
48 | 22-Jul-2002 Ramakant Alat Created
49 | 22-Aug-2002 MGOWDA Added MRC logic
50 |
51 *=======================================================================*/
52 TYPE num_arr is TABLE OF NUMBER;
53 TYPE r_appl_amt_rec IS RECORD
54 (sob_id NUMBER(15),
55 amount_applied NUMBER,
56 acctd_amount_applied NUMBER,
57 exchange_loss NUMBER,
58 exchange_gain NUMBER,
59 /* Added for FP bug6673099 */
60 line_adjusted NUMBER,
61 acctd_line_adjusted NUMBER);
62 TYPE r_appl_amt_list IS TABLE OF r_appl_amt_rec
63 INDEX by binary_integer;
64
65 PROCEDURE get_line_applied(
66 p_application_id IN
67 ar_receivable_applications.applied_customer_trx_id%TYPE,
68 p_customer_trx_id IN
69 ar_receivable_applications.applied_customer_trx_id%TYPE,
70 p_as_of_date IN ar_receivable_applications.apply_date%TYPE
71 DEFAULT sysdate,
72 p_process_rsob IN VARCHAR2 DEFAULT 'N',
73 x_applied_amt_list OUT NOCOPY ARP_PA_UTILS.r_appl_amt_list,
74 x_return_status OUT NOCOPY VARCHAR2,
75 x_msg_count OUT NOCOPY NUMBER,
76 x_msg_data OUT NOCOPY VARCHAR2
77 ) ;
78
79 END ARP_PA_UTILS;