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.AR_CUST_PROF_CLASS_AMT_PKG

Source


1 PACKAGE ar_cust_prof_class_amt_pkg AUTHID CURRENT_USER AS
2 /* $Header: ARCPCMTS.pls 120.0 2006/03/02 23:41:41 hyu noship $ */
3 
4 PROCEDURE int_chrg_validation
5 (p_int_pen       IN VARCHAR2,
6  p_type          IN VARCHAR2,
7  p_amount        IN NUMBER,
8  p_rate          IN NUMBER,
9  p_schedule_id   IN NUMBER,
10  x_return_status IN OUT NOCOPY VARCHAR2);
11 
12 PROCEDURE amt_pct_validation
13 (p_inv_bal       IN VARCHAR2,
14  p_type          IN VARCHAR2,
15  p_amount        IN NUMBER,
16  p_percent       IN NUMBER,
17  x_return_status IN OUT NOCOPY VARCHAR2);
18 
19 
20 PROCEDURE validate_prof_class_amt
21 (P_CURRENCY_CODE                IN VARCHAR2,
22  P_TRX_CREDIT_LIMIT             IN NUMBER,
23  P_OVERALL_CREDIT_LIMIT         IN NUMBER,
24  P_MIN_DUNNING_AMOUNT           IN NUMBER,
25  P_MAX_INTEREST_CHARGE          IN NUMBER,
26  P_MIN_INTEREST_CHARGE          IN NUMBER,
27  P_MIN_STATEMENT_AMOUNT         IN NUMBER,
28  P_AUTO_REC_MIN_RECEIPT_AMOUNT  IN NUMBER,
29  P_MIN_DUNNING_INVOICE_AMOUNT   IN NUMBER,
30  P_INTEREST_RATE                IN NUMBER,
31  P_EXPIRATION_DATE              IN DATE,
32  P_EXCHANGE_RATE_TYPE           IN VARCHAR2,
33  P_MIN_FC_INVOICE_OVERDUE_TYPE  IN VARCHAR2,
34  P_MIN_FC_INVOICE_PERCENT       IN NUMBER,
35  P_MIN_FC_INVOICE_AMOUNT        IN NUMBER,
36  P_MIN_FC_BALANCE_OVERDUE_TYPE  IN VARCHAR2,
37  P_MIN_FC_BALANCE_PERCENT       IN NUMBER,
38  P_MIN_FC_BALANCE_AMOUNT        IN NUMBER,
39  P_INTEREST_TYPE                IN VARCHAR2,
40  P_INTEREST_FIXED_AMOUNT        IN NUMBER,
41  P_INTEREST_SCHEDULE_ID         IN NUMBER,
42  P_PENALTY_TYPE                 IN VARCHAR2,
43  P_PENALTY_RATE                 IN NUMBER,
44  P_PENALTY_FIXED_AMOUNT         IN NUMBER,
45  P_PENALTY_SCHEDULE_ID          IN NUMBER,
46  x_return_status                IN OUT NOCOPY VARCHAR2);
47 
48 
49 PROCEDURE lock_row
50 (p_info_rec        IN  hz_cust_prof_class_Amts%ROWTYPE,
51  x_return_status   OUT NOCOPY  VARCHAR2,
52  x_msg_count       OUT NOCOPY  NUMBER,
53  x_msg_data        OUT NOCOPY  VARCHAR2);
54 
55 
56 PROCEDURE insert_row
57 (P_PROFILE_CLASS_AMOUNT_ID      IN NUMBER,
58  P_PROFILE_CLASS_ID             IN NUMBER,
59  P_CURRENCY_CODE                IN VARCHAR2,
60  P_TRX_CREDIT_LIMIT             IN NUMBER,
61  P_OVERALL_CREDIT_LIMIT         IN NUMBER,
62  P_MIN_DUNNING_AMOUNT           IN NUMBER,
63  P_MAX_INTEREST_CHARGE          IN NUMBER,
64  P_MIN_INTEREST_CHARGE          IN NUMBER,
65  P_MIN_STATEMENT_AMOUNT         IN NUMBER,
66  P_AUTO_REC_MIN_RECEIPT_AMOUNT  IN NUMBER,
67  P_MIN_DUNNING_INVOICE_AMOUNT   IN NUMBER,
68  P_INTEREST_RATE                IN NUMBER,
69  P_EXPIRATION_DATE              IN DATE,
70  P_EXCHANGE_RATE_TYPE           IN VARCHAR2,
71  P_MIN_FC_INVOICE_OVERDUE_TYPE  IN VARCHAR2,
72  P_MIN_FC_INVOICE_PERCENT       IN NUMBER,
73  P_MIN_FC_INVOICE_AMOUNT        IN NUMBER,
74  P_MIN_FC_BALANCE_OVERDUE_TYPE  IN VARCHAR2,
75  P_MIN_FC_BALANCE_PERCENT       IN NUMBER,
76  P_MIN_FC_BALANCE_AMOUNT        IN NUMBER,
77  P_INTEREST_TYPE                IN VARCHAR2,
78  P_INTEREST_FIXED_AMOUNT        IN NUMBER,
79  P_INTEREST_SCHEDULE_ID         IN NUMBER,
80  P_PENALTY_TYPE                 IN VARCHAR2,
81  P_PENALTY_RATE                 IN NUMBER,
82  P_PENALTY_FIXED_AMOUNT         IN NUMBER,
83  P_PENALTY_SCHEDULE_ID          IN NUMBER,
84  P_ATTRIBUTE_CATEGORY           IN VARCHAR2 DEFAULT NULL,
85  P_ATTRIBUTE1                   IN VARCHAR2 DEFAULT NULL,
86  P_ATTRIBUTE2                   IN VARCHAR2 DEFAULT NULL,
87  P_ATTRIBUTE3                   IN VARCHAR2 DEFAULT NULL,
88  P_ATTRIBUTE4                   IN VARCHAR2 DEFAULT NULL,
89  P_ATTRIBUTE5                   IN VARCHAR2 DEFAULT NULL,
90  P_ATTRIBUTE6                   IN VARCHAR2 DEFAULT NULL,
91  P_ATTRIBUTE7                   IN VARCHAR2 DEFAULT NULL,
92  P_ATTRIBUTE8                   IN VARCHAR2 DEFAULT NULL,
93  P_ATTRIBUTE9                   IN VARCHAR2 DEFAULT NULL,
94  P_ATTRIBUTE10                  IN VARCHAR2 DEFAULT NULL,
95  P_ATTRIBUTE11                  IN VARCHAR2 DEFAULT NULL,
96  P_ATTRIBUTE12                  IN VARCHAR2 DEFAULT NULL,
97  P_ATTRIBUTE13                  IN VARCHAR2 DEFAULT NULL,
98  P_ATTRIBUTE14                  IN VARCHAR2 DEFAULT NULL,
99  P_ATTRIBUTE15                  IN VARCHAR2 DEFAULT NULL,
100  P_JGZZ_ATTRIBUTE_CATEGORY      IN VARCHAR2 DEFAULT NULL,
101  P_JGZZ_ATTRIBUTE1              IN VARCHAR2 DEFAULT NULL,
102  P_JGZZ_ATTRIBUTE2              IN VARCHAR2 DEFAULT NULL,
103  P_JGZZ_ATTRIBUTE3              IN VARCHAR2 DEFAULT NULL,
104  P_JGZZ_ATTRIBUTE4              IN VARCHAR2 DEFAULT NULL,
105  P_JGZZ_ATTRIBUTE5              IN VARCHAR2 DEFAULT NULL,
106  P_JGZZ_ATTRIBUTE6              IN VARCHAR2 DEFAULT NULL,
107  P_JGZZ_ATTRIBUTE7              IN VARCHAR2 DEFAULT NULL,
108  P_JGZZ_ATTRIBUTE8              IN VARCHAR2 DEFAULT NULL,
109  P_JGZZ_ATTRIBUTE9              IN VARCHAR2 DEFAULT NULL,
110  P_JGZZ_ATTRIBUTE10             IN VARCHAR2 DEFAULT NULL,
111  P_JGZZ_ATTRIBUTE11             IN VARCHAR2 DEFAULT NULL,
112  P_JGZZ_ATTRIBUTE12             IN VARCHAR2 DEFAULT NULL,
113  P_JGZZ_ATTRIBUTE13             IN VARCHAR2 DEFAULT NULL,
114  P_JGZZ_ATTRIBUTE14             IN VARCHAR2 DEFAULT NULL,
115  P_JGZZ_ATTRIBUTE15             IN VARCHAR2 DEFAULT NULL,
116  P_GLOBAL_ATTRIBUTE1            IN VARCHAR2 DEFAULT NULL,
117  P_GLOBAL_ATTRIBUTE2            IN VARCHAR2 DEFAULT NULL,
118  P_GLOBAL_ATTRIBUTE3            IN VARCHAR2 DEFAULT NULL,
119  P_GLOBAL_ATTRIBUTE4            IN VARCHAR2 DEFAULT NULL,
120  P_GLOBAL_ATTRIBUTE5            IN VARCHAR2 DEFAULT NULL,
121  P_GLOBAL_ATTRIBUTE6            IN VARCHAR2 DEFAULT NULL,
122  P_GLOBAL_ATTRIBUTE7            IN VARCHAR2 DEFAULT NULL,
123  P_GLOBAL_ATTRIBUTE8            IN VARCHAR2 DEFAULT NULL,
124  P_GLOBAL_ATTRIBUTE9            IN VARCHAR2 DEFAULT NULL,
125  P_GLOBAL_ATTRIBUTE10           IN VARCHAR2 DEFAULT NULL,
126  P_GLOBAL_ATTRIBUTE11           IN VARCHAR2 DEFAULT NULL,
127  P_GLOBAL_ATTRIBUTE12           IN VARCHAR2 DEFAULT NULL,
128  P_GLOBAL_ATTRIBUTE13           IN VARCHAR2 DEFAULT NULL,
129  P_GLOBAL_ATTRIBUTE14           IN VARCHAR2 DEFAULT NULL,
130  P_GLOBAL_ATTRIBUTE15           IN VARCHAR2 DEFAULT NULL,
131  P_GLOBAL_ATTRIBUTE16           IN VARCHAR2 DEFAULT NULL,
132  P_GLOBAL_ATTRIBUTE17           IN VARCHAR2 DEFAULT NULL,
133  P_GLOBAL_ATTRIBUTE18           IN VARCHAR2 DEFAULT NULL,
134  P_GLOBAL_ATTRIBUTE19           IN VARCHAR2 DEFAULT NULL,
135  P_GLOBAL_ATTRIBUTE20           IN VARCHAR2 DEFAULT NULL,
136  P_GLOBAL_ATTRIBUTE_CATEGORY    IN VARCHAR2 DEFAULT NULL,
137  P_LAST_UPDATED_BY              IN NUMBER   DEFAULT -1,
138  P_CREATED_BY                   IN NUMBER   DEFAULT -1,
139  P_CREATION_DATE                IN DATE     DEFAULT SYSDATE,
140  P_LAST_UPDATE_LOGIN            IN NUMBER   DEFAULT -1,
141  x_return_status                OUT NOCOPY  VARCHAR2,
142  x_msg_count                    OUT NOCOPY  NUMBER,
143  x_msg_data                     OUT NOCOPY  VARCHAR2);
144 
145 
146 PROCEDURE update_row
147 (P_PROFILE_CLASS_AMOUNT_ID      IN NUMBER,
148  P_CURRENCY_CODE                IN VARCHAR2,
149  P_TRX_CREDIT_LIMIT             IN NUMBER,
150  P_OVERALL_CREDIT_LIMIT         IN NUMBER,
151  P_MIN_DUNNING_AMOUNT           IN NUMBER,
152  P_MAX_INTEREST_CHARGE          IN NUMBER,
153  P_MIN_INTEREST_CHARGE          IN NUMBER,
154  P_MIN_STATEMENT_AMOUNT         IN NUMBER,
155  P_AUTO_REC_MIN_RECEIPT_AMOUNT  IN NUMBER,
156  P_MIN_DUNNING_INVOICE_AMOUNT   IN NUMBER,
157  P_INTEREST_RATE                IN NUMBER,
158  P_EXPIRATION_DATE              IN DATE,
159  P_EXCHANGE_RATE_TYPE           IN VARCHAR2,
160  P_MIN_FC_INVOICE_OVERDUE_TYPE  IN VARCHAR2,
161  P_MIN_FC_INVOICE_PERCENT       IN NUMBER,
162  P_MIN_FC_INVOICE_AMOUNT        IN NUMBER,
163  P_MIN_FC_BALANCE_OVERDUE_TYPE  IN VARCHAR2,
164  P_MIN_FC_BALANCE_PERCENT       IN NUMBER,
165  P_MIN_FC_BALANCE_AMOUNT        IN NUMBER,
166  P_INTEREST_TYPE                IN VARCHAR2,
167  P_INTEREST_FIXED_AMOUNT        IN NUMBER,
168  P_INTEREST_SCHEDULE_ID         IN NUMBER,
169  P_PENALTY_TYPE                 IN VARCHAR2,
170  P_PENALTY_RATE                 IN NUMBER,
171  P_PENALTY_FIXED_AMOUNT         IN NUMBER,
172  P_PENALTY_SCHEDULE_ID          IN NUMBER,
173  P_ATTRIBUTE_CATEGORY           IN VARCHAR2 DEFAULT NULL,
174  P_ATTRIBUTE1                   IN VARCHAR2 DEFAULT NULL,
175  P_ATTRIBUTE2                   IN VARCHAR2 DEFAULT NULL,
176  P_ATTRIBUTE3                   IN VARCHAR2 DEFAULT NULL,
177  P_ATTRIBUTE4                   IN VARCHAR2 DEFAULT NULL,
178  P_ATTRIBUTE5                   IN VARCHAR2 DEFAULT NULL,
179  P_ATTRIBUTE6                   IN VARCHAR2 DEFAULT NULL,
180  P_ATTRIBUTE7                   IN VARCHAR2 DEFAULT NULL,
181  P_ATTRIBUTE8                   IN VARCHAR2 DEFAULT NULL,
182  P_ATTRIBUTE9                   IN VARCHAR2 DEFAULT NULL,
183  P_ATTRIBUTE10                  IN VARCHAR2 DEFAULT NULL,
184  P_ATTRIBUTE11                  IN VARCHAR2 DEFAULT NULL,
185  P_ATTRIBUTE12                  IN VARCHAR2 DEFAULT NULL,
186  P_ATTRIBUTE13                  IN VARCHAR2 DEFAULT NULL,
187  P_ATTRIBUTE14                  IN VARCHAR2 DEFAULT NULL,
188  P_ATTRIBUTE15                  IN VARCHAR2 DEFAULT NULL,
189  P_JGZZ_ATTRIBUTE_CATEGORY      IN VARCHAR2 DEFAULT NULL,
190  P_JGZZ_ATTRIBUTE1              IN VARCHAR2 DEFAULT NULL,
191  P_JGZZ_ATTRIBUTE2              IN VARCHAR2 DEFAULT NULL,
192  P_JGZZ_ATTRIBUTE3              IN VARCHAR2 DEFAULT NULL,
193  P_JGZZ_ATTRIBUTE4              IN VARCHAR2 DEFAULT NULL,
194  P_JGZZ_ATTRIBUTE5              IN VARCHAR2 DEFAULT NULL,
195  P_JGZZ_ATTRIBUTE6              IN VARCHAR2 DEFAULT NULL,
196  P_JGZZ_ATTRIBUTE7              IN VARCHAR2 DEFAULT NULL,
197  P_JGZZ_ATTRIBUTE8              IN VARCHAR2 DEFAULT NULL,
198  P_JGZZ_ATTRIBUTE9              IN VARCHAR2 DEFAULT NULL,
199  P_JGZZ_ATTRIBUTE10             IN VARCHAR2 DEFAULT NULL,
200  P_JGZZ_ATTRIBUTE11             IN VARCHAR2 DEFAULT NULL,
201  P_JGZZ_ATTRIBUTE12             IN VARCHAR2 DEFAULT NULL,
202  P_JGZZ_ATTRIBUTE13             IN VARCHAR2 DEFAULT NULL,
203  P_JGZZ_ATTRIBUTE14             IN VARCHAR2 DEFAULT NULL,
204  P_JGZZ_ATTRIBUTE15             IN VARCHAR2 DEFAULT NULL,
205  P_GLOBAL_ATTRIBUTE1            IN VARCHAR2 DEFAULT NULL,
206  P_GLOBAL_ATTRIBUTE2            IN VARCHAR2 DEFAULT NULL,
207  P_GLOBAL_ATTRIBUTE3            IN VARCHAR2 DEFAULT NULL,
208  P_GLOBAL_ATTRIBUTE4            IN VARCHAR2 DEFAULT NULL,
209  P_GLOBAL_ATTRIBUTE5            IN VARCHAR2 DEFAULT NULL,
210  P_GLOBAL_ATTRIBUTE6            IN VARCHAR2 DEFAULT NULL,
211  P_GLOBAL_ATTRIBUTE7            IN VARCHAR2 DEFAULT NULL,
212  P_GLOBAL_ATTRIBUTE8            IN VARCHAR2 DEFAULT NULL,
213  P_GLOBAL_ATTRIBUTE9            IN VARCHAR2 DEFAULT NULL,
214  P_GLOBAL_ATTRIBUTE10           IN VARCHAR2 DEFAULT NULL,
215  P_GLOBAL_ATTRIBUTE11           IN VARCHAR2 DEFAULT NULL,
216  P_GLOBAL_ATTRIBUTE12           IN VARCHAR2 DEFAULT NULL,
217  P_GLOBAL_ATTRIBUTE13           IN VARCHAR2 DEFAULT NULL,
218  P_GLOBAL_ATTRIBUTE14           IN VARCHAR2 DEFAULT NULL,
219  P_GLOBAL_ATTRIBUTE15           IN VARCHAR2 DEFAULT NULL,
220  P_GLOBAL_ATTRIBUTE16           IN VARCHAR2 DEFAULT NULL,
221  P_GLOBAL_ATTRIBUTE17           IN VARCHAR2 DEFAULT NULL,
222  P_GLOBAL_ATTRIBUTE18           IN VARCHAR2 DEFAULT NULL,
223  P_GLOBAL_ATTRIBUTE19           IN VARCHAR2 DEFAULT NULL,
224  P_GLOBAL_ATTRIBUTE20           IN VARCHAR2 DEFAULT NULL,
225  P_GLOBAL_ATTRIBUTE_CATEGORY    IN VARCHAR2 DEFAULT NULL,
226  P_LAST_UPDATED_BY              IN NUMBER   DEFAULT -1,
227  P_LAST_UPDATE_LOGIN            IN NUMBER   DEFAULT -1,
228  x_return_status                OUT NOCOPY  VARCHAR2,
229  x_msg_count                    OUT NOCOPY  NUMBER,
230  x_msg_data                     OUT NOCOPY  VARCHAR2);
231 
232 
233 PROCEDURE Insert_Negative_Class_Amt
234 (         X_Customer_Profile_Class_Id      NUMBER,
235           X_Created_By                     NUMBER,
236           X_Creation_Date                  DATE,
237           X_Currency_Code                  VARCHAR2,
238           X_Cust_Prof_Class_Amount_Id      NUMBER,
239           X_Last_Updated_By                NUMBER,
240           X_Last_Update_Date               DATE,
241           X_Auto_Rec_Min_Receipt_Amount    NUMBER,
242           X_Last_Update_Login              NUMBER,
243           X_Max_Interest_Charge            NUMBER,
244           X_Min_Dunning_Amount             NUMBER,
245           X_Min_Statement_Amount           NUMBER,
246           X_Overall_Credit_Limit           NUMBER,
247           X_Trx_Credit_Limit               NUMBER,
248           X_Attribute_Category             VARCHAR2,
249           X_Attribute1                     VARCHAR2,
250           X_Attribute2                     VARCHAR2,
251           X_Attribute3                     VARCHAR2,
252           X_Attribute4                     VARCHAR2,
253           X_Attribute5                     VARCHAR2,
254           X_Attribute6                     VARCHAR2,
255           X_Attribute7                     VARCHAR2,
256           X_Attribute8                     VARCHAR2,
257           X_Attribute9                     VARCHAR2,
258           X_Attribute10                    VARCHAR2,
259           X_Attribute11                    VARCHAR2,
260           X_Attribute12                    VARCHAR2,
261           X_Attribute13                    VARCHAR2,
262           X_Attribute14                    VARCHAR2,
263           X_Attribute15                    VARCHAR2,
264           X_Interest_Rate                  NUMBER,
265           X_Min_Fc_Balance_Amount          NUMBER,
266           X_Min_Fc_Invoice_Amount          NUMBER,
267           X_Min_Dunning_Invoice_Amount     NUMBER,
268           X_Jgzz_attribute_Category             VARCHAR2,
269           X_Jgzz_attribute1                     VARCHAR2,
270           X_Jgzz_attribute2                     VARCHAR2,
271           X_Jgzz_attribute3                     VARCHAR2,
272           X_Jgzz_attribute4                     VARCHAR2,
273           X_Jgzz_attribute5                     VARCHAR2,
274           X_Jgzz_attribute6                     VARCHAR2,
275           X_Jgzz_attribute7                     VARCHAR2,
276           X_Jgzz_attribute8                     VARCHAR2,
277           X_Jgzz_attribute9                     VARCHAR2,
278           X_Jgzz_attribute10                    VARCHAR2,
279           X_Jgzz_attribute11                    VARCHAR2,
280           X_Jgzz_attribute12                    VARCHAR2,
281           X_Jgzz_attribute13                    VARCHAR2,
282           X_Jgzz_attribute14                    VARCHAR2,
283           X_Jgzz_attribute15                    VARCHAR2,
284           --Late Charges
285           X_EXCHANGE_RATE_TYPE                  VARCHAR2,
286           X_MIN_FC_INVOICE_OVERDUE_TYPE         VARCHAR2,
287           X_MIN_FC_INVOICE_PERCENT              NUMBER,
288           X_MIN_FC_BALANCE_OVERDUE_TYPE         VARCHAR2,
289           X_MIN_FC_BALANCE_PERCENT              NUMBER,
290           X_INTEREST_TYPE                       VARCHAR2,
291           X_INTEREST_FIXED_AMOUNT               NUMBER,
292           X_INTEREST_SCHEDULE_ID                NUMBER,
293           X_PENALTY_TYPE                        VARCHAR2,
294           X_PENALTY_RATE                        NUMBER,
295           X_PENALTY_FIXED_AMOUNT                NUMBER,
296           X_PENALTY_SCHEDULE_ID                 NUMBER,
297           X_MIN_INTEREST_CHARGE                 NUMBER);
298 
299 
300 PROCEDURE compute_negative_id
301 (         X_Cust_Prof_Class_Amount_Id NUMBER,
302           X_Negative_Id               IN OUT NOCOPY NUMBER,
303           X_Notify_Flag               IN OUT NOCOPY VARCHAR2);
304 
305 PROCEDURE old_amount_insert
306 (         X_Cust_Prof_Class_Amount_Id      NUMBER,
307           X_Negative_Id                    NUMBER,
308           X_Customer_Profile_Class_Id      NUMBER);
309 
310 
311 END;