[Home] [Help]
PACKAGE: APPS.GL_AUTHORIZATION_LIMITS_PKG
Source
1 PACKAGE GL_AUTHORIZATION_LIMITS_PKG as
2 /* $Header: gliemals.pls 120.5 2005/05/05 01:07:19 kvora ship $ */
3 --
4 -- Package
5 -- GL_AUTHORIZATION_LIMITS_PKG
6 -- Purpose
7 -- To contain validation and insertion routines for gl_authorization_limits
8 -- History
9 -- 08-07-97 R Goyal Created.
10 --
11 -- Procedure
12 -- Insert_Row
13 -- Purpose
14 -- Inserts a row into gl_authorization_limits
15 -- History
16 -- 08-07-97 R Goyal Created.
17 -- Arguments
18 -- all the columns of the table GL_AUTHORIZATION_LIMITS
19 -- Example
20 -- gl_authorization_limits_pkg.Insert_Row(....);
21 -- Notes
22 --
23 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
24 X_Ledger_Id NUMBER,
25 X_Employee_Id NUMBER,
26 X_Authorization_Limit NUMBER,
27 X_Last_Update_Date DATE,
28 X_Last_Updated_By NUMBER,
29 X_Creation_Date DATE,
30 X_Created_By NUMBER,
31 X_Last_Update_Login NUMBER,
32 X_Attribute1 VARCHAR2,
33 X_Attribute2 VARCHAR2,
34 X_Attribute3 VARCHAR2,
35 X_Attribute4 VARCHAR2,
36 X_Attribute5 VARCHAR2,
37 X_Attribute6 VARCHAR2,
38 X_Attribute7 VARCHAR2,
39 X_Attribute8 VARCHAR2,
40 X_Attribute9 VARCHAR2,
41 X_Attribute10 VARCHAR2,
42 X_Attribute11 VARCHAR2,
43 X_Attribute12 VARCHAR2,
44 X_Attribute13 VARCHAR2,
45 X_Attribute14 VARCHAR2,
46 X_Attribute15 VARCHAR2,
47 X_Context VARCHAR2);
48 --
49 -- Procedure
50 -- Lock_Row
51 -- Purpose
52 -- Locks a row into gl_authorization_limits
53 -- History
54 -- 08-07-97 R Goyal Created.
55 -- Arguments
56 -- all the columns of the table GL_AUTHORIZATION_LIMITS
57 -- Example
58 -- gl_authorization_limits.Lock_Row(....;
59 -- Notes
60 --
61 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
62 X_Ledger_Id NUMBER,
63 X_Employee_Id NUMBER,
64 X_Authorization_Limit NUMBER,
65 X_Attribute1 VARCHAR2,
66 X_Attribute2 VARCHAR2,
67 X_Attribute3 VARCHAR2,
68 X_Attribute4 VARCHAR2,
69 X_Attribute5 VARCHAR2,
70 X_Attribute6 VARCHAR2,
71 X_Attribute7 VARCHAR2,
72 X_Attribute8 VARCHAR2,
73 X_Attribute9 VARCHAR2,
74 X_Attribute10 VARCHAR2,
75 X_Attribute11 VARCHAR2,
76 X_Attribute12 VARCHAR2,
77 X_Attribute13 VARCHAR2,
78 X_Attribute14 VARCHAR2,
79 X_Attribute15 VARCHAR2,
80 X_Context VARCHAR2 );
81 --
82 -- Procedure
83 -- Update_Row
84 -- Purpose
85 -- Updates a row into gl_authorization_limits
86 -- History
87 -- 08-07-97 R Goyal Created.
88 -- Arguments
89 -- all the columns of the table GL_AUTHORIZATION_LIMITS
90 -- Example
91 -- gl_authorization_limits_pkg.Update_Row(....;
92 -- Notes
93 --
94 PROCEDURE Update_Row(X_Rowid VARCHAR2,
95 X_Ledger_Id NUMBER,
96 X_Employee_Id NUMBER,
97 X_Authorization_Limit NUMBER,
98 X_Last_Update_Date DATE,
99 X_Last_Updated_By NUMBER,
100 X_Last_Update_Login NUMBER,
101 X_Attribute1 VARCHAR2,
102 X_Attribute2 VARCHAR2,
103 X_Attribute3 VARCHAR2,
104 X_Attribute4 VARCHAR2,
105 X_Attribute5 VARCHAR2,
106 X_Attribute6 VARCHAR2,
107 X_Attribute7 VARCHAR2,
108 X_Attribute8 VARCHAR2,
109 X_Attribute9 VARCHAR2,
110 X_Attribute10 VARCHAR2,
111 X_Attribute11 VARCHAR2,
112 X_Attribute12 VARCHAR2,
113 X_Attribute13 VARCHAR2,
114 X_Attribute14 VARCHAR2,
115 X_Attribute15 VARCHAR2,
116 X_Context VARCHAR2 );
117 --
118 -- Procedure
119 -- Delete_Row
120 -- Purpose
121 -- Deletes a row from gl_authorization_limits
122 -- History
123 -- 08-07-97 R Goyal Created.
124 -- Arguments
125 -- x_rowid Rowid of a row
126 -- Example
127 -- gl_authorization_limits_pkg.delete_row('ajfdshj');
128 -- Notes
129 --
130 PROCEDURE Delete_Row(X_Rowid VARCHAR2);
131
132 --
133 -- Procedure
134 -- check_unique
135 -- Purpose
136 -- Checks to make sure that employee_name is unique.
137 -- History
138 -- 08-08-97 R Goyal Created.
139 -- Arguments
140 -- X_row_id The row ID
141 -- x_ledger_id Ledger Id
142 -- x_employee_id Employee ID
143 -- Example
144 -- gl_authorization_limits_pkg.check_unique(...
145 -- Notes
146 --
147 FUNCTION Check_Unique(X_Rowid VARCHAR2,
148 X_ledger_id NUMBER,
149 X_employee_id NUMBER,
150 X_employee_name VARCHAR2 ) RETURN BOOLEAN;
151
152 END GL_AUTHORIZATION_LIMITS_PKG;