eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.ARP_ARXVASUM

Source


1 PACKAGE ARP_ARXVASUM AUTHID CURRENT_USER AS
2 /* $Header: ARCESUMS.pls 120.3 2005/10/30 04:14:12 appldev ship $ */
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;