1 PACKAGE ARP_ARXCOQIT AUTHID CURRENT_USER AS
2 /* $Header: ARCEQITS.pls 115.7 2002/11/15 02:16:05 anukumar ship $ */
3
4
5 procedure history_total(p_where_clause IN varchar2,
6 p_total IN OUT NOCOPY number);
7
8
9 -- Bug No. : 950002 : Removed folder_total and folder_func_total as these are included in fold_total.
10 /*
11 1826455 fbreslin: Add a new parameter p_cur_count. This will pass back to the
12 calling routine the number of distinct currencies that make
13 up the total.
14 */
15 procedure fold_total( p_where_clause IN varchar2,
16 p_total IN OUT NOCOPY number,
17 p_func_total IN OUT NOCOPY number,
18 p_from_clause IN varchar2 DEFAULT 'ar_payment_schedules_v',
19 p_cur_count OUT NOCOPY NUMBER);
20
21 -- Bug 2089289
22 procedure fold_currency_code( p_where_clause IN varchar2,
23 p_from_clause IN varchar2 DEFAULT 'ar_payment_schedules_v',
24 p_currency_code OUT NOCOPY varchar2);
25 -- End 2089289
26 procedure get_date( p_ps_id IN ar_dispute_history.payment_schedule_id%TYPE,
27 p_last_dispute_date IN OUT NOCOPY ar_dispute_history.start_date%TYPE ) ;
28
29
30 procedure check_changed( p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
31 p_amount_in_dispute IN ar_payment_schedules.payment_schedule_id%TYPE,
32 p_dispute_amount_changed IN OUT NOCOPY NUMBER) ;
33
34
35 procedure get_flag( p_ps_id IN ar_dispute_history.payment_schedule_id%TYPE,
36 p_ever_in_dispute_flag IN OUT NOCOPY varchar2) ;
37
38
39 procedure get_days_late( p_due_date IN ar_payment_schedules.due_date%TYPE,
40 p_days_late IN OUT NOCOPY number) ;
41
42
43 End;