1 PACKAGE IEX_AGING_BUCKETS_PKG AUTHID CURRENT_USER AS
2 /* $Header: iexpagbs.pls 120.2 2004/12/06 15:38:13 jypark ship $ */
3 TYPE Aging_Summary_Rec is RECORD(
4 aging_bucket_id Number(15),
5 aging_bucket_name varchar2(20),
6 aging_bucket_line_id Number ,
7 bucket_sequence_num Number ,
8 Bucket_line_desc Varchar2(35),
9 Amount Number ,
10 collectible_amount Number ,
11 Currency Varchar2(25),
12 Invoice_Count Number ,
13 Invoice_amount Number,
14 DM_COUNT Number,
15 dm_AMOUNT Number,
16 cb_count Number,
17 cb_amount Number,
18 Disputed_Transactions Number,
19 Disputed_amount Number ) ;
20
21 TYPE Aging_Summary_Select_Rec is RECORD(
22 aging_bucket_id Number(15),
23 aging_bucket_name varchar2(20),
24 aging_bucket_line_id Number ,
25 bucket_sequence_num Number ,
26 Bucket_line_desc Varchar2(35),
27 Amount Number ) ;
28
29 TYPE bucket_lines_Rec is RECORD(
30 outstanding_balance Number ,
31 Bucket_line Varchar2(35),
32 Amount Number ,
33 Currency Varchar2(25),
34 bucket_line_id Number ,
35 bucket_seq_num Number ,
36 collectible_amount Number ,
37 consolidated_invoices Number,
38 Invoice_Count Number ,
39 Invoice_amount Number,
40 DM_COUNT Number,
41 dm_AMOUNT Number,
42 cb_count Number,
43 cb_amount Number,
44 Disputed_Tran_count Number,
45 Disputed_tran_amount Number ) ;
46
47 -- Aging Summary data pl/sql Table that is passed back to the form
48 TYPE Aging_Summary_Tbl is TABLE of Aging_Summary_Rec
49 Index By Binary_Integer ;
50
51 TYPE bucket_lines_Tbl is TABLE of bucket_lines_Rec
52 Index By Binary_Integer ;
53
54 -- Ref cursors to select the History and Activity Data
55 TYPE PROFILE_CUR IS REF CURSOR ;
56
57
58 PROCEDURE calc_aging_buckets (
59 p_customer_id IN NUMBER,
60 p_customer_site_use_id IN NUMBER,
61 p_as_of_date IN DATE,
62 p_currency_code IN VARCHAR2,
63 p_credit_option IN VARCHAR2,
64 p_invoice_type_low IN VARCHAR2,
65 p_invoice_type_high IN VARCHAR2,
66 p_ps_max_id IN NUMBER DEFAULT 0,
67 p_app_max_id IN NUMBER DEFAULT 0,
68 p_bucket_id IN Number,
69 p_outstanding_balance IN OUT NOCOPY NUMBER,
70 p_bucket_line_id_0 OUT NOCOPY NUMBER,
71 p_bucket_seq_num_0 OUT NOCOPY NUMBER,
72 p_bucket_titletop_0 OUT NOCOPY VARCHAR2,
73 p_bucket_titlebottom_0 OUT NOCOPY VARCHAR2,
74 p_bucket_amount_0 IN OUT NOCOPY NUMBER,
75 p_bucket_line_id_1 OUT NOCOPY NUMBER,
76 p_bucket_seq_num_1 OUT NOCOPY NUMBER,
77 p_bucket_titletop_1 OUT NOCOPY VARCHAR2,
78 p_bucket_titlebottom_1 OUT NOCOPY VARCHAR2,
79 p_bucket_amount_1 IN OUT NOCOPY NUMBER,
80 p_bucket_line_id_2 OUT NOCOPY NUMBER,
81 p_bucket_seq_num_2 OUT NOCOPY NUMBER,
82 p_bucket_titletop_2 OUT NOCOPY VARCHAR2,
83 p_bucket_titlebottom_2 OUT NOCOPY VARCHAR2,
84 p_bucket_amount_2 IN OUT NOCOPY NUMBER,
85 p_bucket_line_id_3 OUT NOCOPY NUMBER,
86 p_bucket_seq_num_3 OUT NOCOPY NUMBER,
87 p_bucket_titletop_3 OUT NOCOPY VARCHAR2,
88 p_bucket_titlebottom_3 OUT NOCOPY VARCHAR2,
89 p_bucket_amount_3 IN OUT NOCOPY NUMBER,
90 p_bucket_line_id_4 OUT NOCOPY NUMBER,
91 p_bucket_seq_num_4 OUT NOCOPY NUMBER,
92 p_bucket_titletop_4 OUT NOCOPY VARCHAR2,
93 p_bucket_titlebottom_4 OUT NOCOPY VARCHAR2,
94 p_bucket_amount_4 IN OUT NOCOPY NUMBER,
95 p_bucket_line_id_5 OUT NOCOPY NUMBER,
96 p_bucket_seq_num_5 OUT NOCOPY NUMBER,
97 p_bucket_titletop_5 OUT NOCOPY VARCHAR2,
98 p_bucket_titlebottom_5 OUT NOCOPY VARCHAR2,
99 p_bucket_amount_5 IN OUT NOCOPY NUMBER,
100 p_bucket_line_id_6 OUT NOCOPY NUMBER,
101 p_bucket_seq_num_6 OUT NOCOPY NUMBER,
102 p_bucket_titletop_6 OUT NOCOPY VARCHAR2,
103 p_bucket_titlebottom_6 OUT NOCOPY VARCHAR2,
104 p_bucket_amount_6 IN OUT NOCOPY NUMBER);
105 --
106 PROCEDURE calc_credits (
107 p_filter_mode IN VARCHAR2,
108 p_filter_id IN NUMBER,
109 p_customer_site_use_id IN NUMBER,
110 p_as_of_date IN DATE,
111 p_currency_code IN VARCHAR2,
112 p_ps_max_id IN NUMBER DEFAULT 0,
113 p_using_paying_rel IN VARCHAR2,
114 p_credits OUT NOCOPY NUMBER) ;
115 --
116
117 PROCEDURE calc_receipts (
118 p_filter_mode IN VARCHAR2,
119 p_filter_id IN NUMBER,
120 p_customer_site_use_id IN NUMBER,
121 p_as_of_date IN DATE,
122 p_currency_code IN VARCHAR2,
123 p_app_max_id IN NUMBER DEFAULT 0,
124 p_using_paying_rel IN VARCHAR2,
125 p_unapplied_cash OUT NOCOPY NUMBER,
126 p_onacct_cash OUT NOCOPY NUMBER,
127 p_cash_claims OUT NOCOPY NUMBER,
128 p_prepayments OUT NOCOPY NUMBER) ;
129
130 --
131 PROCEDURE calc_risk_receipts (
132 p_filter_mode IN Varchar2,
133 p_filter_id IN NUMBER,
134 p_customer_site_use_id IN NUMBER,
135 p_as_of_date IN DATE,
136 p_currency_code IN VARCHAR2,
137 p_ps_max_id IN NUMBER,
138 p_using_paying_rel IN VARCHAR2,
139 p_risk_receipts OUT NOCOPY NUMBER
140 );
141 --
142 PROCEDURE calc_dispute (
143 p_filter_mode IN VARCHAR2,
144 p_filter_id IN NUMBER,
145 p_customer_site_use_id IN NUMBER,
146 p_as_of_date IN DATE,
147 p_currency_code IN VARCHAR2,
148 p_ps_max_id IN NUMBER,
149 p_using_paying_rel IN VARCHAR2,
150 p_dispute OUT NOCOPY NUMBER
151 );
152 --
153 PROCEDURE calc_adj_fin_charges(
154 p_filter_mode IN Varchar2,
155 p_filter_id IN NUMBER,
156 p_customer_site_use_id IN NUMBER,
157 p_as_of_date IN DATE,
158 p_currency_code IN VARCHAR2,
159 p_ps_max_id IN NUMBER,
160 p_using_paying_rel IN VARCHAR2,
161 p_adj OUT NOCOPY NUMBER,
162 p_pending_adj OUT NOCOPY NUMBER,
163 p_fin_charges OUT NOCOPY NUMBER
164 );
165
166
167 PROCEDURE QUERY_AGING_LINES
168 (p_api_version IN NUMBER := 1.0,
169 p_init_msg_list IN VARCHAR2,
170 p_commit IN VARCHAR2,
171 p_validation_level IN NUMBER,
172 x_return_status IN OUT NOCOPY VARCHAR2,
173 x_msg_count IN OUT NOCOPY NUMBER,
174 x_msg_data IN OUT NOCOPY VARCHAR2,
175 p_filter_mode IN Varchar2,
176 p_filter_id IN Number ,
177 p_customer_site_use_id IN Number, --added by ehuh for 11591
178 p_bucket_id IN Number,
179 p_credit_option IN Varchar2,
180 p_using_paying_rel IN VARCHAR2,
181 x_bucket_lines_tbl IN OUT NOCOPY bucket_lines_tbl ) ;
182
183 PROCEDURE GET_BKT_INVOICE_CLASS_INFO
184 (p_api_version IN NUMBER := 1.0,
185 p_init_msg_list IN VARCHAR2,
186 p_commit IN VARCHAR2,
187 p_validation_level IN NUMBER,
188 x_return_status OUT NOCOPY VARCHAR2,
189 x_msg_count OUT NOCOPY NUMBER,
190 x_msg_data OUT NOCOPY VARCHAR2,
191 p_filter_mode IN Varchar2,
192 p_bucket_line_id IN AR_AGING_BUCKET_LINES_B.Aging_Bucket_Line_Id%TYPE,
193 p_filter_id IN Number,
194 p_customer_site_use_id IN Number, -- added by ehuh for bill-to
195 p_class IN varchar2,
196 p_using_paying_rel IN VARCHAR2,
197 x_class_count OUT NOCOPY Number,
198 x_class_amount OUT NOCOPY NUMBER) ;
199
200
201
202 -- Added as a part of OKL changes
203 PROCEDURE GET_CNSLD_INVOICE_COUNT
204 (p_api_version IN NUMBER := 1.0,
205 p_init_msg_list IN VARCHAR2,
206 p_commit IN VARCHAR2,
207 p_validation_level IN NUMBER,
208 x_return_status OUT NOCOPY VARCHAR2,
209 x_msg_count OUT NOCOPY NUMBER,
210 x_msg_data OUT NOCOPY VARCHAR2,
211 p_filter_mode IN Varchar2,
212 p_bucket_line_id IN AR_AGING_BUCKET_LINES_B.Aging_Bucket_Line_Id%TYPE,
213 p_filter_id IN Number,
214 p_customer_site_use_id IN Number,
215 p_using_paying_rel IN VARCHAR2,
216 x_count OUT NOCOPY Number,
217 x_amount OUT NOCOPY NUMBER) ;
218
219
220
221 END iex_aging_buckets_pkg ;