[Home] [Help]
PACKAGE: APPS.ARH_CPCA_PKG
Source
1 PACKAGE arh_cpca_pkg AUTHID CURRENT_USER as
2 /* $Header: ARHPCAS.pls 120.1 2005/06/16 21:13:20 jhuang ship $*/
3
4
5 PROCEDURE Insert_Negative_Class_Amt
6 ( X_Customer_Profile_Class_Id NUMBER,
7 X_Created_By NUMBER,
8 X_Creation_Date DATE,
9 X_Currency_Code VARCHAR2,
10 X_Cust_Prof_Class_Amount_Id NUMBER,
11 X_Last_Updated_By NUMBER,
12 X_Last_Update_Date DATE,
13 X_Auto_Rec_Min_Receipt_Amount NUMBER,
14 X_Last_Update_Login NUMBER,
15 X_Max_Interest_Charge NUMBER,
16 X_Min_Dunning_Amount NUMBER,
17 X_Min_Statement_Amount NUMBER,
18 X_Overall_Credit_Limit NUMBER,
19 X_Trx_Credit_Limit NUMBER,
20 X_Attribute_Category VARCHAR2,
21 X_Attribute1 VARCHAR2,
22 X_Attribute2 VARCHAR2,
23 X_Attribute3 VARCHAR2,
24 X_Attribute4 VARCHAR2,
25 X_Attribute5 VARCHAR2,
26 X_Attribute6 VARCHAR2,
27 X_Attribute7 VARCHAR2,
28 X_Attribute8 VARCHAR2,
29 X_Attribute9 VARCHAR2,
30 X_Attribute10 VARCHAR2,
31 X_Attribute11 VARCHAR2,
32 X_Attribute12 VARCHAR2,
33 X_Attribute13 VARCHAR2,
34 X_Attribute14 VARCHAR2,
35 X_Attribute15 VARCHAR2,
36 X_Interest_Rate NUMBER,
37 X_Min_Fc_Balance_Amount NUMBER,
38 X_Min_Fc_Invoice_Amount NUMBER,
39 X_Min_Dunning_Invoice_Amount NUMBER,
40 X_Jgzz_attribute_Category VARCHAR2,
41 X_Jgzz_attribute1 VARCHAR2,
42 X_Jgzz_attribute2 VARCHAR2,
43 X_Jgzz_attribute3 VARCHAR2,
44 X_Jgzz_attribute4 VARCHAR2,
45 X_Jgzz_attribute5 VARCHAR2,
46 X_Jgzz_attribute6 VARCHAR2,
47 X_Jgzz_attribute7 VARCHAR2,
48 X_Jgzz_attribute8 VARCHAR2,
49 X_Jgzz_attribute9 VARCHAR2,
50 X_Jgzz_attribute10 VARCHAR2,
51 X_Jgzz_attribute11 VARCHAR2,
52 X_Jgzz_attribute12 VARCHAR2,
53 X_Jgzz_attribute13 VARCHAR2,
54 X_Jgzz_attribute14 VARCHAR2,
55 X_Jgzz_attribute15 VARCHAR2
56 );
57
58 PROCEDURE compute_negative_id
59 ( X_Cust_Prof_Class_Amount_Id NUMBER,
60 X_Negative_Id IN OUT NOCOPY NUMBER,
61 X_Notify_Flag IN OUT NOCOPY VARCHAR2
62 );
63 --
64 --
65 PROCEDURE old_amount_insert
66 ( X_Cust_Prof_Class_Amount_Id NUMBER,
67 X_Negative_Id NUMBER,
68 X_Customer_Profile_Class_Id NUMBER
69 );
70 --
71 --
72 END arh_cpca_pkg;