1 PACKAGE ARP_BAL_UTIL AS
2 /* $Header: ARTUBALS.pls 120.3 2005/10/31 17:58:31 ramenon ship $ */
3
4 FUNCTION get_line_balance( p_customer_trx_line_id IN Number,
5 p_extended_amount IN Number
6 DEFAULT NULL,
7 p_cm_customer_trx_line_id IN
8 number
9 DEFAULT NULL )
10 RETURN NUMBER;
11
12
13
14 FUNCTION get_line_cm( p_prev_customer_trx_line_id IN Number)
15 RETURN NUMBER;
16
17
18
19 FUNCTION get_commitment_balance( p_customer_trx_id IN Number,
20 p_class IN Varchar2,
21 p_so_source_code IN varchar2,
22 p_oe_installed_flag IN varchar2)
23 RETURN NUMBER;
24
25
26 FUNCTION calc_commitment_balance( p_customer_trx_id IN Number,
27 p_class IN Varchar2,
28 p_include_oe_trx_flag IN varchar2,
29 p_oe_installed_flag IN varchar2,
30 p_so_source_code IN varchar2 )
31 RETURN NUMBER;
32
33
34 FUNCTION get_trx_balance( p_customer_trx_id IN Number,
35 p_open_receivables_flag IN Varchar2)
36 RETURN NUMBER;
37
38
39 PROCEDURE transaction_balances(p_customer_trx_id IN Number,
40 p_open_receivables_flag IN Varchar2,
41 p_exchange_rate IN Number,
42 p_mode IN VARCHAR2,
43 p_currency_mode IN VARCHAR2,
44 p_line_original OUT NOCOPY NUMBER,
45 p_line_remaining OUT NOCOPY NUMBER,
46 p_tax_original OUT NOCOPY NUMBER,
47 p_tax_remaining OUT NOCOPY NUMBER,
48 p_freight_original OUT NOCOPY NUMBER,
49 p_freight_remaining OUT NOCOPY NUMBER,
50 p_charges_original OUT NOCOPY NUMBER,
51 p_charges_remaining OUT NOCOPY NUMBER,
52 p_line_discount OUT NOCOPY NUMBER,
53 p_tax_discount OUT NOCOPY NUMBER,
54 p_freight_discount OUT NOCOPY NUMBER,
55 p_charges_discount OUT NOCOPY NUMBER,
56 p_total_discount OUT NOCOPY NUMBER,
57 p_total_original OUT NOCOPY NUMBER,
58 p_total_remaining OUT NOCOPY NUMBER,
59 p_line_receipts OUT NOCOPY NUMBER,
60 p_tax_receipts OUT NOCOPY NUMBER,
61 p_freight_receipts OUT NOCOPY NUMBER,
62 p_charges_receipts OUT NOCOPY NUMBER,
63 p_total_receipts OUT NOCOPY NUMBER,
64 p_line_credits OUT NOCOPY NUMBER,
65 p_tax_credits OUT NOCOPY NUMBER,
66 p_freight_credits OUT NOCOPY NUMBER,
67 p_total_credits OUT NOCOPY NUMBER,
68 p_line_adjustments OUT NOCOPY NUMBER,
69 p_tax_adjustments OUT NOCOPY NUMBER,
70 p_freight_adjustments OUT NOCOPY NUMBER,
71 p_charges_adjustments OUT NOCOPY NUMBER,
72 p_total_adjustments OUT NOCOPY NUMBER,
73 p_aline_adjustments OUT NOCOPY NUMBER,
74 p_atax_adjustments OUT NOCOPY NUMBER,
75 p_afreight_adjustments OUT NOCOPY NUMBER,
76 p_acharges_adjustments OUT NOCOPY NUMBER,
77 p_atotal_adjustments OUT NOCOPY NUMBER,
78 p_base_line_original OUT NOCOPY NUMBER,
79 p_base_line_remaining OUT NOCOPY NUMBER,
80 p_base_tax_original OUT NOCOPY NUMBER,
81 p_base_tax_remaining OUT NOCOPY NUMBER,
82 p_base_freight_original OUT NOCOPY NUMBER,
83 p_base_freight_remaining OUT NOCOPY NUMBER,
84 p_base_charges_original OUT NOCOPY NUMBER,
85 p_base_charges_remaining OUT NOCOPY NUMBER,
86 p_base_line_discount OUT NOCOPY NUMBER,
87 p_base_tax_discount OUT NOCOPY NUMBER,
88 p_base_freight_discount OUT NOCOPY NUMBER,
89 p_base_total_discount OUT NOCOPY NUMBER,
90 p_base_total_original OUT NOCOPY NUMBER,
91 p_base_total_remaining OUT NOCOPY NUMBER,
92 p_base_line_receipts OUT NOCOPY NUMBER,
93 p_base_tax_receipts OUT NOCOPY NUMBER,
94 p_base_freight_receipts OUT NOCOPY NUMBER,
95 p_base_charges_receipts OUT NOCOPY NUMBER,
96 p_base_total_receipts OUT NOCOPY NUMBER,
97 p_base_line_credits OUT NOCOPY NUMBER,
98 p_base_tax_credits OUT NOCOPY NUMBER,
99 p_base_freight_credits OUT NOCOPY NUMBER,
100 p_base_total_credits OUT NOCOPY NUMBER,
101 p_base_line_adjustments OUT NOCOPY NUMBER,
102 p_base_tax_adjustments OUT NOCOPY NUMBER,
103 p_base_freight_adjustments OUT NOCOPY NUMBER,
104 p_base_charges_adjustments OUT NOCOPY NUMBER,
105 p_base_total_adjustments OUT NOCOPY NUMBER,
106 p_base_aline_adjustments OUT NOCOPY NUMBER,
107 p_base_atax_adjustments OUT NOCOPY NUMBER,
108 p_base_afreight_adjustments OUT NOCOPY NUMBER,
109 p_base_acharges_adjustments OUT NOCOPY NUMBER,
110 p_base_atotal_adjustments OUT NOCOPY NUMBER
111 );
112
113
114 PROCEDURE get_summary_trx_balances( p_customer_trx_id IN Number,
115 p_open_receivables_flag IN Varchar2,
116 p_line_original OUT NOCOPY NUMBER,
117 p_line_remaining OUT NOCOPY NUMBER,
118 p_tax_original OUT NOCOPY NUMBER,
119 p_tax_remaining OUT NOCOPY NUMBER,
120 p_freight_original OUT NOCOPY NUMBER,
121 p_freight_remaining OUT NOCOPY NUMBER,
122 p_charges_original OUT NOCOPY NUMBER,
123 p_charges_remaining OUT NOCOPY NUMBER,
124 p_total_original OUT NOCOPY NUMBER,
125 p_total_remaining OUT NOCOPY NUMBER );
126
127
128 FUNCTION get_applied_com_balance( p_customer_trx_id IN Number,
129 p_mode IN VARCHAR2)
130 RETURN NUMBER;
131
132 FUNCTION Line_Level_Activity ( p_customer_trx_id IN Number)
133 RETURN BOOLEAN;
134
135 PROCEDURE trx_line_balances (
136 p_customer_trx_id
137 IN RA_CUSTOMER_TRX.CUSTOMER_TRX_ID%TYPE DEFAULT NULL,
138 p_line_num IN NUMBER DEFAULT NULL,
139 p_group_id IN NUMBER DEFAULT NULL,
140 p_exchange_rate IN NUMBER,
141 p_line_original OUT NOCOPY NUMBER,
142 p_tax_original OUT NOCOPY NUMBER,
143 p_base_line_original OUT NOCOPY NUMBER,
144 p_base_tax_original OUT NOCOPY NUMBER,
145 p_total_original OUT NOCOPY NUMBER,
146 p_base_total_original OUT NOCOPY NUMBER,
147 p_line_receipts OUT NOCOPY NUMBER,
148 p_tax_receipts OUT NOCOPY NUMBER,
149 p_line_discount OUT NOCOPY NUMBER,
150 p_tax_discount OUT NOCOPY NUMBER,
151 p_base_line_receipts OUT NOCOPY NUMBER,
152 p_base_tax_receipts OUT NOCOPY NUMBER,
153 p_base_line_discount OUT NOCOPY NUMBER,
154 p_base_tax_discount OUT NOCOPY NUMBER,
155 p_freight_original OUT NOCOPY NUMBER,
156 p_base_freight_original OUT NOCOPY NUMBER,
157 p_freight_receipts OUT NOCOPY NUMBER,
158 p_charges_receipts OUT NOCOPY NUMBER,
159 p_base_charges_receipts OUT NOCOPY NUMBER,
160 p_base_freight_receipts OUT NOCOPY NUMBER,
161 p_freight_discount OUT NOCOPY NUMBER,
162 p_base_freight_discount OUT NOCOPY NUMBER,
163 p_total_receipts OUT NOCOPY NUMBER,
164 p_base_total_receipts OUT NOCOPY NUMBER,
165 p_total_discount OUT NOCOPY NUMBER,
166 p_base_total_discount OUT NOCOPY NUMBER,
167 p_line_remaining OUT NOCOPY NUMBER,
168 p_tax_remaining OUT NOCOPY NUMBER,
169 p_freight_remaining OUT NOCOPY NUMBER,
170 p_charges_remaining OUT NOCOPY NUMBER,
171 p_total_remaining OUT NOCOPY NUMBER,
172 p_base_line_remaining OUT NOCOPY NUMBER,
173 p_base_tax_remaining OUT NOCOPY NUMBER,
174 p_base_freight_remaining OUT NOCOPY NUMBER,
175 p_base_charges_remaining OUT NOCOPY NUMBER,
176 p_base_total_remaining OUT NOCOPY NUMBER,
177 p_line_credits OUT NOCOPY NUMBER,
178 p_tax_credits OUT NOCOPY NUMBER,
179 p_freight_credits OUT NOCOPY NUMBER,
180 p_total_credits OUT NOCOPY NUMBER,
181 p_base_line_credits OUT NOCOPY NUMBER,
182 p_base_tax_credits OUT NOCOPY NUMBER,
183 p_base_freight_credits OUT NOCOPY NUMBER,
184 p_base_total_credits OUT NOCOPY NUMBER,
185 p_line_adjustments OUT NOCOPY NUMBER,
186 p_tax_adjustments OUT NOCOPY NUMBER,
187 p_freight_adjustments OUT NOCOPY NUMBER,
188 p_charges_adjustments OUT NOCOPY NUMBER,
189 p_total_adjustments OUT NOCOPY NUMBER,
190 p_base_line_adjustments OUT NOCOPY NUMBER,
191 p_base_tax_adjustments OUT NOCOPY NUMBER,
192 p_base_freight_adjustments OUT NOCOPY NUMBER,
193 p_base_charges_adjustments OUT NOCOPY NUMBER,
194 p_base_total_adjustments OUT NOCOPY NUMBER
195 );
196
197 END ARP_BAL_UTIL;