DBA Data[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;