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