[Home] [Help]
PACKAGE: APPS.PAY_US_GARN_FEE_RULES_F_PKG
Source
1 PACKAGE PAY_US_GARN_FEE_RULES_F_PKG AUTHID CURRENT_USER as
2 /* $Header: pygfr01t.pkh 115.1.1150.1 2000/02/10 15:53:40 pkm ship $ */
3
4
5 PROCEDURE Insert_Row(X_Rowid IN OUT VARCHAR2,
6 X_Fee_Rule_Id IN OUT NUMBER,
7 X_Effective_Start_Date DATE,
8 X_Effective_End_Date DATE,
9 X_Garn_Category VARCHAR2,
10 X_State_Code VARCHAR2,
11 X_Addl_Garn_Fee_Amount NUMBER,
12 X_Correspondence_Fee NUMBER,
13 X_Creator_Type VARCHAR2,
14 X_Fee_Amount NUMBER,
15 X_Fee_Rule VARCHAR2,
16 X_Max_Fee_Amount NUMBER,
17 X_Pct_Current NUMBER,
18 X_Take_Fee_On_Proration VARCHAR2,
19 X_Last_Update_Date DATE,
20 X_Last_Updated_By NUMBER,
21 X_Last_Update_Login NUMBER,
22 X_Created_By NUMBER,
23 X_Creation_Date DATE
24 );
25
26 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
27
28 X_Fee_Rule_Id NUMBER,
29 X_Effective_Start_Date DATE,
30 X_Effective_End_Date DATE,
31 X_Garn_Category VARCHAR2,
32 X_State_Code VARCHAR2,
33 X_Addl_Garn_Fee_Amount NUMBER,
34 X_Correspondence_Fee NUMBER,
35 X_Creator_Type VARCHAR2,
36 X_Fee_Amount NUMBER,
37 X_Fee_Rule VARCHAR2,
38 X_Max_Fee_Amount NUMBER,
39 X_Pct_Current NUMBER,
40 X_Take_Fee_On_Proration VARCHAR2
41 );
42
43
44
45 PROCEDURE Update_Row(X_Rowid VARCHAR2,
46 X_Fee_Rule_Id NUMBER,
47 X_Effective_Start_Date DATE,
48 X_Effective_End_Date DATE,
49 X_Garn_Category VARCHAR2,
50 X_State_Code VARCHAR2,
51 X_Addl_Garn_Fee_Amount NUMBER,
52 X_Correspondence_Fee NUMBER,
53 X_Creator_Type VARCHAR2,
54 X_Fee_Amount NUMBER,
55 X_Fee_Rule VARCHAR2,
56 X_Max_Fee_Amount NUMBER,
57 X_Pct_Current NUMBER,
58 X_Take_Fee_On_Proration VARCHAR2,
59 X_Last_Update_Date DATE,
60 X_Last_Updated_By NUMBER,
61 X_Last_Update_Login NUMBER
62 );
63 PROCEDURE Delete_Row(X_Rowid VARCHAR2);
64
65 PROCEDURE Check_Unique( X_State_Code VARCHAR2,
66 X_Garn_Category VARCHAR2);
67
68
69 END PAY_US_GARN_FEE_RULES_F_PKG;