1 PACKAGE ARP_ARXVASUM2 AS
2 /* $Header: ARCESU2S.pls 120.2 2005/10/30 04:14:08 appldev noship $ */
3
4 procedure get_amounts( p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
5 p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
6 p_start_date IN gl_period_statuses.start_date%TYPE,
7 p_end_date IN gl_period_statuses.end_date%TYPE,
8 p_currency_code IN
9 ar_payment_schedules.invoice_currency_code%TYPE,
10 p_inv_count IN OUT NOCOPY NUMBER,
11 p_dm_count IN OUT NOCOPY NUMBER,
12 p_cb_count IN OUT NOCOPY NUMBER,
13 p_dep_count IN OUT NOCOPY NUMBER,
14 p_guar_count IN OUT NOCOPY NUMBER,
15 p_pmt_count IN OUT NOCOPY NUMBER,
16 p_cm_count IN OUT NOCOPY NUMBER,
17 p_risk_count IN OUT NOCOPY NUMBER,
18 p_br_count IN OUT NOCOPY NUMBER, /* 18-MAY-2000 J Rautiainen BR Implementation */
19 p_sum_inv_ori_amt IN OUT NOCOPY NUMBER,
20 p_sum_dm_ori_amt IN OUT NOCOPY NUMBER,
21 p_sum_cb_ori_amt IN OUT NOCOPY NUMBER,
22 p_sum_dep_ori_amt IN OUT NOCOPY NUMBER,
23 p_sum_guar_ori_amt IN OUT NOCOPY NUMBER,
24 p_sum_pmt_ori_amt IN OUT NOCOPY NUMBER,
25 p_sum_cm_ori_amt IN OUT NOCOPY NUMBER,
26 p_sum_risk_ori_amt IN OUT NOCOPY NUMBER,
27 p_sum_br_ori_amt IN OUT NOCOPY NUMBER, /* 18-MAY-2000 J Rautiainen BR Implementation */
28 p_sum_inv_rem_amt IN OUT NOCOPY NUMBER,
29 p_sum_dm_rem_amt IN OUT NOCOPY NUMBER,
30 p_sum_cb_rem_amt IN OUT NOCOPY NUMBER,
31 p_sum_dep_rem_amt IN OUT NOCOPY NUMBER,
32 p_sum_guar_rem_amt IN OUT NOCOPY NUMBER,
33 p_sum_pmt_rem_amt IN OUT NOCOPY NUMBER,
34 p_sum_cm_rem_amt IN OUT NOCOPY NUMBER,
35 p_sum_risk_rem_amt IN OUT NOCOPY NUMBER,
36 p_sum_br_rem_amt IN OUT NOCOPY NUMBER, /* 18-MAY-2000 J Rautiainen BR Implementation */
37 p_sum_inv_func_ori_amt IN OUT NOCOPY NUMBER,
38 p_sum_dm_func_ori_amt IN OUT NOCOPY NUMBER,
39 p_sum_cb_func_ori_amt IN OUT NOCOPY NUMBER,
40 p_sum_dep_func_ori_amt IN OUT NOCOPY NUMBER,
41 p_sum_guar_func_ori_amt IN OUT NOCOPY NUMBER,
42 p_sum_pmt_func_ori_amt IN OUT NOCOPY NUMBER,
43 p_sum_cm_func_ori_amt IN OUT NOCOPY NUMBER,
44 p_sum_risk_func_ori_amt IN OUT NOCOPY NUMBER,
45 p_sum_br_func_ori_amt IN OUT NOCOPY NUMBER, /* 18-MAY-2000 J Rautiainen BR Implementation */
46 p_sum_inv_func_rem_amt IN OUT NOCOPY NUMBER,
47 p_sum_dm_func_rem_amt IN OUT NOCOPY NUMBER,
48 p_sum_cb_func_rem_amt IN OUT NOCOPY NUMBER,
49 p_sum_dep_func_rem_amt IN OUT NOCOPY NUMBER,
50 p_sum_guar_func_rem_amt IN OUT NOCOPY NUMBER,
51 p_sum_pmt_func_rem_amt IN OUT NOCOPY NUMBER,
52 p_sum_cm_func_rem_amt IN OUT NOCOPY NUMBER,
53 p_sum_risk_func_rem_amt IN OUT NOCOPY NUMBER,
54 p_sum_br_func_rem_amt IN OUT NOCOPY NUMBER, /* 18-MAY-2000 J Rautiainen BR Implementation */
55 p_func_curr IN VARCHAR2,
56 p_exc_rate IN NUMBER,
57 p_precision IN NUMBER,
58 p_min_acc_unit IN NUMBER,
59 p_status IN ar_payment_schedules.status%TYPE,
60 p_incl_rct_spmenu IN VARCHAR2
61 );
62
63 procedure get_payments_ontime(
64 p_payments_late_count IN OUT NOCOPY NUMBER,
65 p_payments_ontime_count IN OUT NOCOPY NUMBER,
66 p_payments_late_amount IN OUT NOCOPY NUMBER,
67 p_payments_ontime_amount IN OUT NOCOPY NUMBER,
68 p_payments_late_func_amt IN OUT NOCOPY NUMBER,
69 p_payments_ontime_func_amt IN OUT NOCOPY NUMBER,
70 p_start_date IN gl_period_statuses.start_date%TYPE,
71 p_end_date IN gl_period_statuses.end_date%TYPE,
72 p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
73 p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
74 p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
75 p_func_curr IN VARCHAR2,
76 p_exc_rate IN NUMBER,
77 p_precision IN NUMBER,
78 p_min_acc_unit IN NUMBER,
79 p_status IN ar_payment_schedules.status%TYPE
80 );
81
82
83
84
85
86 procedure get_nsf_stop(
87 p_nsf_stop_amount IN OUT NOCOPY NUMBER,
88 p_nsf_stop_func_amt IN OUT NOCOPY NUMBER,
89 p_nsf_stop_count IN OUT NOCOPY NUMBER,
90 p_start_date IN gl_period_statuses.start_date%TYPE,
91 p_end_date IN gl_period_statuses.end_date%TYPE,
92 p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
93 p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
94 p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
95 p_func_curr IN VARCHAR2,
96 p_exc_rate IN NUMBER,
97 p_precision IN NUMBER,
98 p_min_acc_unit NUMBER,
99 p_status IN ar_payment_schedules.status%TYPE
100 ) ;
101
102
103
104 procedure get_adjustments(
105 p_adjustment_amount IN OUT NOCOPY NUMBER,
106 p_adjustment_func_amt IN OUT NOCOPY NUMBER,
107 p_adjustment_count IN OUT NOCOPY NUMBER,
108 p_start_date IN gl_period_statuses.start_date%TYPE,
109 p_end_date IN gl_period_statuses.end_date%TYPE,
110 p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
111 p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
112 p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
113 p_func_curr IN VARCHAR2,
114 p_exc_rate IN NUMBER,
115 p_precision IN NUMBER,
116 p_min_acc_unit IN NUMBER,
117 p_status IN ar_payment_schedules.status%TYPE
118 );
119
120
121 procedure get_financecharg(
122 p_financecharg_amount IN OUT NOCOPY NUMBER,
123 p_financecharg_func_amt IN OUT NOCOPY NUMBER,
124 p_financecharg_count IN OUT NOCOPY NUMBER,
125 p_start_date IN gl_period_statuses.start_date%TYPE,
126 p_end_date IN gl_period_statuses.end_date%TYPE,
127 p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
128 p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
129 p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
130 p_func_curr IN VARCHAR2,
131 p_exc_rate IN NUMBER,
132 p_precision IN NUMBER,
133 p_min_acc_unit IN NUMBER,
134 p_status IN ar_payment_schedules.status%TYPE
135 ) ;
136
137
138 procedure get_discounts(
139 p_earned_discounts IN OUT NOCOPY NUMBER,
140 p_unearned_discounts IN OUT NOCOPY NUMBER,
141 p_earned_func_disc IN OUT NOCOPY NUMBER,
142 p_unearned_func_disc IN OUT NOCOPY NUMBER,
143 p_earned_disc_count IN OUT NOCOPY NUMBER,
144 p_unearned_disc_count IN OUT NOCOPY NUMBER,
145 p_start_date IN gl_period_statuses.start_date%TYPE,
146 p_end_date IN gl_period_statuses.end_date%TYPE,
147 p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
148 p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
149 p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
150 p_func_curr IN VARCHAR2,
151 p_exc_rate IN NUMBER,
152 p_precision IN NUMBER,
153 p_min_acc_unit IN NUMBER,
154 p_status IN ar_payment_schedules.status%TYPE
155 );
156
157
158 procedure get_pending_confirmation(
159 p_pend_confirm_amt IN OUT NOCOPY NUMBER,
160 p_pend_confirm_func_amt IN OUT NOCOPY NUMBER,
161 p_pend_confirm_count IN OUT NOCOPY NUMBER,
162 p_start_date IN gl_period_statuses.start_date%TYPE,
163 p_end_date IN gl_period_statuses.end_date%TYPE,
164 p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
165 p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
166 p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
167 p_func_curr IN VARCHAR2,
168 p_exc_rate IN NUMBER,
169 p_precision IN NUMBER,
170 p_min_acc_unit IN NUMBER,
171 p_status IN ar_payment_schedules.status%TYPE
172 );
173
174
175 procedure get_pending_remit(
176 p_boe_ori_amt IN OUT NOCOPY NUMBER,
177 p_boe_func_ori_amt IN OUT NOCOPY NUMBER,
178 p_boe_rem_amt IN OUT NOCOPY NUMBER,
179 p_boe_func_rem_amt IN OUT NOCOPY NUMBER,
180 p_boe_count IN OUT NOCOPY NUMBER,
181 p_note_ori_amt IN OUT NOCOPY NUMBER,
182 p_note_func_ori_amt IN OUT NOCOPY NUMBER,
183 p_note_rem_amt IN OUT NOCOPY NUMBER,
184 p_note_func_rem_amt IN OUT NOCOPY NUMBER,
185 p_note_count IN OUT NOCOPY NUMBER,
186 p_other_ori_amt IN OUT NOCOPY NUMBER,
187 p_other_func_ori_amt IN OUT NOCOPY NUMBER,
188 p_other_rem_amt IN OUT NOCOPY NUMBER,
189 p_other_func_rem_amt IN OUT NOCOPY NUMBER,
190 p_other_count IN OUT NOCOPY NUMBER,
191 p_start_date IN gl_period_statuses.start_date%TYPE,p_end_date IN gl_period_statuses.end_date%TYPE,
192 p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
193 p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
194 p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
195 p_func_curr IN VARCHAR2,
196 p_exc_rate IN NUMBER,
197 p_precision IN NUMBER,
198 p_min_acc_unit IN NUMBER,
199 p_status IN ar_payment_schedules.status%TYPE,
200 p_incl_rct_spmenu IN VARCHAR2
201 );
202
203
204 procedure get_remitted(
205 p_standard_ori_amt IN OUT NOCOPY NUMBER,
206 p_standard_func_ori_amt IN OUT NOCOPY NUMBER,
207 p_standard_rem_amt IN OUT NOCOPY NUMBER,
208 p_standard_func_rem_amt IN OUT NOCOPY NUMBER,
209 p_standard_count IN OUT NOCOPY NUMBER,
210 p_factored_ori_amt IN OUT NOCOPY NUMBER,
211 p_factored_func_ori_amt IN OUT NOCOPY NUMBER,
212 p_factored_rem_amt IN OUT NOCOPY NUMBER,
213 p_factored_func_rem_amt IN OUT NOCOPY NUMBER,
214 p_factored_count IN OUT NOCOPY NUMBER,
215 p_start_date IN gl_period_statuses.start_date%TYPE,
216 p_end_date IN gl_period_statuses.end_date%TYPE,
217 p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
218 p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
219 p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
220 p_func_curr IN VARCHAR2,
221 p_exc_rate IN NUMBER,
222 p_precision IN NUMBER,
223 p_min_acc_unit IN NUMBER,
224 p_status IN ar_payment_schedules.status%TYPE,
225 p_incl_rct_spmenu IN VARCHAR2
226 );
227
228 procedure get_protested_BR(p_BR_protested_amt IN OUT NOCOPY NUMBER,
229 p_BR_protested_func_amt IN OUT NOCOPY NUMBER,
230 p_BR_protested_count IN OUT NOCOPY NUMBER,
231 p_start_date IN gl_period_statuses.start_date%TYPE,
232 p_end_date IN gl_period_statuses.end_date%TYPE,
233 p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
234 p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
235 p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
236 p_func_curr IN VARCHAR2,
237 p_exc_rate IN NUMBER,
238 p_precision IN NUMBER,
239 p_min_acc_unit IN NUMBER,
240 p_status IN ar_payment_schedules.status%TYPE);
241
242 procedure get_unpaid_BR(p_BR_unpaid_amt IN OUT NOCOPY NUMBER,
243 p_BR_unpaid_func_amt IN OUT NOCOPY NUMBER,
244 p_BR_unpaid_count IN OUT NOCOPY NUMBER,
245 p_start_date IN gl_period_statuses.start_date%TYPE,
246 p_end_date IN gl_period_statuses.end_date%TYPE,
247 p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
248 p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
249 p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
250 p_func_curr IN VARCHAR2,
251 p_exc_rate IN NUMBER,
252 p_precision IN NUMBER,
253 p_min_acc_unit IN NUMBER,
254 p_status IN ar_payment_schedules.status%TYPE);
255
256 End;