[Home] [Help]
PACKAGE: APPS.AR_VIEW_TERM_GRP
Source
1 PACKAGE AR_VIEW_TERM_GRP AS
2 /* $Header: ARVTERMS.pls 120.1 2005/01/14 19:43:39 jbeckett noship $ */
3
4 /*=======================================================================+
5 | Declare PUBLIC Data Types and Variables
6 +=======================================================================*/
7
8 TYPE pay_now_record IS RECORD(
9 base_amount ra_terms.base_amount%TYPE,
10 first_installment_code ra_terms.first_installment_code%TYPE,
11 relative_amount_total ra_terms_lines.relative_amount%TYPE,
12 first_installment_count NUMBER );
13
14 TYPE amounts_record IS RECORD(
15 line_id NUMBER,
16 term_id NUMBER,
17 line_amount NUMBER,
18 tax_amount NUMBER,
19 freight_amount NUMBER,
20 total_amount NUMBER);
21
22 TYPE amounts_table IS TABLE OF amounts_record INDEX BY BINARY_INTEGER;
23
24 TYPE summary_amounts_rec IS RECORD(
25 line_amount NUMBER,
26 tax_amount NUMBER,
27 freight_amount NUMBER,
28 total_amount NUMBER);
29
30 /*=======================================================================+
31 | Declare PUBLIC Exceptions
32 +=======================================================================*/
33
34 /*=======================================================================+
35 | Declare Global variables
36 +=======================================================================*/
37
38
39 /*========================================================================
40 | PUBLIC Procedure pay_now_amounts
41 |
42 | DESCRIPTION
43 | For a given line, tax and freight amount, determines corresponding
44 | pay now amounts from payment terms.
45 |
46 | PSEUDO CODE/LOGIC
47 |
48 | PARAMETERS
49 |
50 |
51 | RETURNS
52 | nothing
53 |
54 | KNOWN ISSUES
55 |
56 |
57 |
58 | NOTES
59 |
60 |
61 |
62 | MODIFICATION HISTORY
63 | Date Author Description of Changes
64 | 10-NOV-2004 J Beckett Created
65 |
66 *=======================================================================*/
67 PROCEDURE pay_now_amounts(
68 -- Standard API parameters.
69 p_api_version IN NUMBER,
70 p_init_msg_list IN VARCHAR2,
71 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
72 p_term_id IN NUMBER,
73 p_currency_code IN fnd_currencies.currency_code%TYPE,
74 p_line_amount IN NUMBER,
75 p_tax_amount IN NUMBER,
76 p_freight_amount IN NUMBER,
77 x_pay_now_line_amount OUT NOCOPY NUMBER,
78 x_pay_now_tax_amount OUT NOCOPY NUMBER,
79 x_pay_now_freight_amount OUT NOCOPY NUMBER,
80 x_pay_now_total_amount OUT NOCOPY NUMBER,
81 x_return_status OUT NOCOPY VARCHAR2,
82 x_msg_count OUT NOCOPY NUMBER,
83 x_msg_data OUT NOCOPY VARCHAR2);
84
85 /*========================================================================
86 | PUBLIC Procedure pay_now_amounts (overloaded)
87 |
88 | DESCRIPTION
89 | For a given line, tax and freight amount, determines corresponding
90 | pay now amounts from payment terms. Data is input/output in a table.
91 |
92 | PSEUDO CODE/LOGIC
93 |
94 | PARAMETERS
95 |
96 |
97 | RETURNS
98 | nothing
99 |
100 | KNOWN ISSUES
101 |
102 |
103 |
104 | NOTES
105 |
106 |
107 |
108 | MODIFICATION HISTORY
109 | Date Author Description of Changes
110 | 10-NOV-2004 J Beckett Created
111 |
112 *=======================================================================*/
113 PROCEDURE pay_now_amounts(
114 p_api_version IN NUMBER,
115 p_init_msg_list IN VARCHAR2,
116 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
117 p_currency_code IN fnd_currencies.currency_code%TYPE,
118 p_amounts_tbl IN OUT NOCOPY ar_view_term_grp.amounts_table,
119 x_pay_now_summary_rec OUT NOCOPY ar_view_term_grp.summary_amounts_rec,
120 x_return_status OUT NOCOPY VARCHAR2,
121 x_msg_count OUT NOCOPY NUMBER,
122 x_msg_data OUT NOCOPY VARCHAR2);
123
124 END AR_VIEW_TERM_GRP;