[Home] [Help]
PACKAGE: APPS.GL_ACCESS_SETS_PKG
Source
1 PACKAGE gl_access_sets_pkg AS
2 /* $Header: glistaxs.pls 120.7 2005/05/05 01:22:48 kvora ship $ */
3 --
4 -- Package
5 -- gl_access_sets_pkg
6 -- Purpose
7 -- Server routines related to table gl_access_sets
8 -- History
9 -- 02/19/2001 T Cheng Created
10
11 --
12 -- Function
13 -- get_unique_id
14 -- Purpose
15 -- retrieves the unique access set id from sequence gl_access_sets_s
16 -- History
17 -- 02-19-2001 T Cheng Created
18 -- Arguments
19 -- None
20 -- Notes
21 --
22 FUNCTION get_unique_id RETURN NUMBER;
23
24 --
25 -- Function
26 -- has_details_in_db
27 -- Purpose
28 -- checks whether there are access details for the access set
29 -- in the database
30 -- History
31 -- 02-19-2001 T Cheng Created
32 -- Arguments
33 -- X_Access_Set_Id access set id
34 -- Notes
35 --
36 FUNCTION has_details_in_db (X_Access_Set_Id NUMBER) RETURN BOOLEAN;
37
38 --
39 -- Function
40 -- maintain_def_ledger_assign
41 -- Purpose
42 -- Check if a default ledger detail is assigned to the data access set.
43 -- Insert the assignment if necessary and return TRUE, else return FALSE.
44 -- History
45 -- 08-29-2003 T Cheng Created
46 -- Arguments
47 -- X_Access_Set_Id accesst set id
48 -- Notes
49 --
50 FUNCTION maintain_def_ledger_assign(X_Access_Set_Id NUMBER) RETURN BOOLEAN;
51
52 --
53 -- Function
54 -- get_value_set_id
55 -- Purpose
56 -- get the value set id for the given chart of account and segment
57 -- History
58 -- 02-19-2001 T Cheng Created
59 -- Arguments
60 -- X_Access_Set_Id access set id
61 -- X_Segment_Type segment qualifier name
62 -- Notes
63 --
64 FUNCTION get_value_set_id(X_Chart_Of_Accounts_Id NUMBER,
65 X_Segment_Type VARCHAR2) RETURN NUMBER;
66
67 --
68 -- Procedure
69 -- select_columns
70 -- Purpose
71 -- Used to select data for a given access_set_id.
72 -- History
73 -- 06-26-2001 T Cheng Created
74 -- Arguments
75 -- X_access_set_id Id of access set to be found
76 -- X_name Name of the access set
77 -- X_security_segment_code Security segment code
78 -- X_coa_id Chart of accounts id
79 -- X_period_set_name Period set name
80 -- X_accounted_period_type Accounted period type
81 -- X_auto_created_flag Automatically created flag
82 -- Notes
83 --
84 PROCEDURE select_columns(X_access_set_id NUMBER,
85 X_name IN OUT NOCOPY VARCHAR2,
86 X_security_segment_code IN OUT NOCOPY VARCHAR2,
87 X_coa_id IN OUT NOCOPY NUMBER,
88 X_period_set_name IN OUT NOCOPY VARCHAR2,
89 X_accounted_period_type IN OUT NOCOPY VARCHAR2,
90 X_auto_created_flag IN OUT NOCOPY VARCHAR2);
91
92 --
93 -- Function
94 -- Create_Implicit_Access_Set
95 -- Purpose
96 -- Create implicit access set for ledgers created.
97 -- History
98 -- 04-27-2001 T Cheng Added. Code provided by O Monnier.
99 -- 10-15-2001 T Cheng Added X_Security_Segment_Code and
100 -- X_Secured_Seg_Value_Set_Id.
101 -- 11-09-2001 T Cheng Added parameter X_default_ledger_id.
102 -- Arguments
103 -- X_Name access set name
104 -- X_Security_Segment_Code security segment code
105 -- X_Chart_Of_Accounts_Id chart of accounts id
106 -- X_Period_Set_Name period set name
107 -- X_Accounted_Period_Type accounted period type
108 -- X_Secured_Seg_Value_Set_Id security segment value set id
109 -- X_default_ledger_id default ledger id
110 -- X_Last_Updated_By created by/initial last updated by
111 -- X_Last_Update_Login last update login
112 -- X_Creation_Date creation date/initial last update date
113 -- X_Description description
114 -- Notes
115 --
116 FUNCTION Create_Implicit_Access_Set(
117 X_Name VARCHAR2,
118 X_Security_Segment_Code VARCHAR2,
119 X_Chart_Of_Accounts_Id NUMBER,
120 X_Period_Set_Name VARCHAR2,
121 X_Accounted_Period_Type VARCHAR2,
122 X_Secured_Seg_Value_Set_Id NUMBER,
123 X_Default_Ledger_Id NUMBER,
124 X_Last_Updated_By NUMBER,
125 X_Last_Update_Login NUMBER,
126 X_Creation_Date DATE,
127 X_Description VARCHAR2) RETURN NUMBER;
128
129 --
130 -- Function
131 -- Update_Implicit_Access_Set
132 -- Purpose
133 -- Update the Implicit Access Set Name when the Ledger Name is updated.
134 -- History
135 -- 10-14-2002 O Monnier Added.
136 -- Arguments
137 -- X_Access_Set_Id implicit access set ID
138 -- X_Name access set name
139 -- X_Last_update_Date last update date
140 -- X_Last_Updated_By created by/initial last updated by
141 -- X_Last_Update_Login last update login
142 -- Notes
143 --
144 PROCEDURE Update_Implicit_Access_Set(X_Access_Set_Id NUMBER,
145 X_Name VARCHAR2,
146 X_Last_Update_Date DATE,
147 X_Last_Updated_By NUMBER,
148 X_Last_Update_Login NUMBER);
149
150 --
151 -- Procedure
152 -- Insert_Row
153 -- Purpose
154 -- used to insert an access set row
155 -- History
156 -- 02-19-2001 T Cheng Created
157 -- 11-12-2001 T Cheng Add X_Default_Ledger_Id
158 -- Notes
159 --
160 PROCEDURE Insert_Row(
161 X_Rowid IN OUT NOCOPY VARCHAR2,
162 X_Access_Set_Id NUMBER,
163 X_Name VARCHAR2,
164 X_Security_Segment_Code VARCHAR2,
165 X_Enabled_Flag VARCHAR2,
166 X_Chart_Of_Accounts_Id NUMBER,
167 X_Period_Set_Name VARCHAR2,
168 X_Accounted_Period_Type VARCHAR2,
169 X_Automatically_Created_Flag VARCHAR2,
170 X_Secured_Seg_Value_Set_Id NUMBER,
171 X_Default_Ledger_Id NUMBER,
172 X_User_Id NUMBER,
173 X_Login_Id NUMBER,
174 X_Date DATE,
175 X_Description VARCHAR2 DEFAULT NULL,
176 X_Context VARCHAR2 DEFAULT NULL,
177 X_Attribute1 VARCHAR2 DEFAULT NULL,
178 X_Attribute2 VARCHAR2 DEFAULT NULL,
179 X_Attribute3 VARCHAR2 DEFAULT NULL,
180 X_Attribute4 VARCHAR2 DEFAULT NULL,
181 X_Attribute5 VARCHAR2 DEFAULT NULL,
182 X_Attribute6 VARCHAR2 DEFAULT NULL,
183 X_Attribute7 VARCHAR2 DEFAULT NULL,
184 X_Attribute8 VARCHAR2 DEFAULT NULL,
185 X_Attribute9 VARCHAR2 DEFAULT NULL,
186 X_Attribute10 VARCHAR2 DEFAULT NULL,
187 X_Attribute11 VARCHAR2 DEFAULT NULL,
188 X_Attribute12 VARCHAR2 DEFAULT NULL,
189 X_Attribute13 VARCHAR2 DEFAULT NULL,
190 X_Attribute14 VARCHAR2 DEFAULT NULL,
191 X_Attribute15 VARCHAR2 DEFAULT NULL);
192
193 --
194 -- Procedure
195 -- Update_Row
196 -- Purpose
197 -- used to update an access set row
198 -- History
199 -- 02-19-2001 T Cheng Created
200 -- 11-12-2001 T Cheng Add X_Default_Ledger_Id
201 -- Notes
202 --
203 PROCEDURE Update_Row(
204 X_Rowid VARCHAR2,
205 X_Access_Set_Id NUMBER,
206 X_Name VARCHAR2,
207 X_Security_Segment_Code VARCHAR2,
208 X_Enabled_Flag VARCHAR2,
209 X_Chart_Of_Accounts_Id NUMBER,
210 X_Period_Set_Name VARCHAR2,
211 X_Accounted_Period_Type VARCHAR2,
212 X_Automatically_Created_Flag VARCHAR2,
213 X_Secured_Seg_Value_Set_Id NUMBER,
214 X_Default_Ledger_Id NUMBER,
215 X_User_Id NUMBER,
216 X_Login_Id NUMBER,
217 X_Date DATE,
218 X_Description VARCHAR2 DEFAULT NULL,
219 X_Context VARCHAR2 DEFAULT NULL,
220 X_Attribute1 VARCHAR2 DEFAULT NULL,
221 X_Attribute2 VARCHAR2 DEFAULT NULL,
222 X_Attribute3 VARCHAR2 DEFAULT NULL,
223 X_Attribute4 VARCHAR2 DEFAULT NULL,
224 X_Attribute5 VARCHAR2 DEFAULT NULL,
225 X_Attribute6 VARCHAR2 DEFAULT NULL,
226 X_Attribute7 VARCHAR2 DEFAULT NULL,
227 X_Attribute8 VARCHAR2 DEFAULT NULL,
228 X_Attribute9 VARCHAR2 DEFAULT NULL,
229 X_Attribute10 VARCHAR2 DEFAULT NULL,
230 X_Attribute11 VARCHAR2 DEFAULT NULL,
231 X_Attribute12 VARCHAR2 DEFAULT NULL,
232 X_Attribute13 VARCHAR2 DEFAULT NULL,
233 X_Attribute14 VARCHAR2 DEFAULT NULL,
234 X_Attribute15 VARCHAR2 DEFAULT NULL);
235
236 --
237 -- Procedure
238 -- Lock_Row
239 -- Purpose
240 -- used to lock an access set row
241 -- History
242 -- 02-19-2001 T Cheng Created
243 -- 11-12-2001 T Cheng Add X_Default_Ledger_Id
244 -- Notes
245 --
246 PROCEDURE Lock_Row(
247 X_Rowid VARCHAR2,
248 X_Access_Set_Id NUMBER,
249 X_Name VARCHAR2,
250 X_Security_Segment_Code VARCHAR2,
251 X_Enabled_Flag VARCHAR2,
252 X_Chart_Of_Accounts_Id NUMBER,
253 X_Period_Set_Name VARCHAR2,
254 X_Accounted_Period_Type VARCHAR2,
255 X_Automatically_Created_Flag VARCHAR2,
256 X_Secured_Seg_Value_Set_Id NUMBER,
257 X_Default_Ledger_Id NUMBER,
258 X_Last_Update_Date DATE,
259 X_Last_Updated_By NUMBER,
260 X_Creation_Date DATE,
261 X_Created_By NUMBER,
262 X_Last_Update_Login NUMBER,
263 X_Description VARCHAR2 DEFAULT NULL,
264 X_Context VARCHAR2 DEFAULT NULL,
265 X_Attribute1 VARCHAR2 DEFAULT NULL,
266 X_Attribute2 VARCHAR2 DEFAULT NULL,
267 X_Attribute3 VARCHAR2 DEFAULT NULL,
268 X_Attribute4 VARCHAR2 DEFAULT NULL,
269 X_Attribute5 VARCHAR2 DEFAULT NULL,
270 X_Attribute6 VARCHAR2 DEFAULT NULL,
271 X_Attribute7 VARCHAR2 DEFAULT NULL,
272 X_Attribute8 VARCHAR2 DEFAULT NULL,
273 X_Attribute9 VARCHAR2 DEFAULT NULL,
274 X_Attribute10 VARCHAR2 DEFAULT NULL,
275 X_Attribute11 VARCHAR2 DEFAULT NULL,
276 X_Attribute12 VARCHAR2 DEFAULT NULL,
277 X_Attribute13 VARCHAR2 DEFAULT NULL,
278 X_Attribute14 VARCHAR2 DEFAULT NULL,
279 X_Attribute15 VARCHAR2 DEFAULT NULL);
280
281 END gl_access_sets_pkg;