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,
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(
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,
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:
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,
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:
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,
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(
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,
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(
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,
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(
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,
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(
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,
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:
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,
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,
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,
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,
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;