[Home] [Help]
PACKAGE: APPS.GL_JE_SOURCES_PKG
Source
1 PACKAGE GL_JE_SOURCES_PKG AS
2 /* $Header: glijesrs.pls 120.4 2004/12/22 00:21:55 djogg ship $ */
3 --
4 -- Package
5 -- gl_je_sources_pkg
6 -- Purpose
7 -- To contain validation and insertion routines for gl_je_sources
8 -- History
9 -- 12-21-93 D. J. Ogg Created
10
11 --
12 -- Procedure
13 -- select_columns
14 -- Purpose
15 -- Used to select the user_je_source_name for a given je_source_name
16 -- History
17 -- 12-21-93 D. J. Ogg Created
18 -- Arguments
19 -- x_je_source_name Source name to be found
20 -- x_user_je_source_name User name for the source
21 -- Example
22 -- gl_je_sources_pkg.select_columns('Recurring', user_name);
23 -- Notes
24 --
25 PROCEDURE select_columns(
26 x_je_source_name VARCHAR2,
27 x_user_je_source_name IN OUT NOCOPY VARCHAR2,
28 x_effective_date_rule_code IN OUT NOCOPY VARCHAR2,
29 x_frozen_source_flag IN OUT NOCOPY VARCHAR2,
30 x_journal_approval_flag IN OUT NOCOPY VARCHAR2);
31
32 --
33 -- Procedure
34 -- check_unique_name
35 -- Purpose
36 -- Checks to make sure that je_source_name is unique.
37 -- History
38 -- 06-23-94 Kai Pigg Created
39 -- Arguments
40 -- x_je_source_name Name of Journal Entry Source (Hidden Id)
41 -- row_id The row ID
42 -- Example
43 -- gl_je_sources_pkg.check_unique('1', 'ABD02334');
44 -- Notes
45 --
46 PROCEDURE check_unique_name(x_je_source_name VARCHAR2,
47 x_row_id VARCHAR2);
48
49 --
50 -- Procedure
51 -- check_unique_user_name
52 -- Purpose
53 -- Checks to make sure that user_je_source_name is unique.
54 -- History
55 -- 06-23-94 Kai Pigg Created
56 -- Arguments
57 -- x_user_je_source_name Name of Journal Entry Source (Displayed)
58 -- row_id The row ID
59 -- Example
60 -- gl_je_sources_pkg.check_unique('Testing', 'ABD02334');
61 -- Notes
62 --
63 PROCEDURE check_unique_user_name(x_user_je_source_name VARCHAR2,
64 x_row_id VARCHAR2);
65
66 --
67 -- Procedure
68 -- check_unique_key
69 -- Purpose
70 -- Checks to make sure that je_source_key is unique.
71 -- History
72 -- 21-DEC-2004 Kai Pigg Created
73 -- Arguments
74 -- x_je_source_key Journal source key
75 -- row_id The row ID
76 -- Example
77 -- gl_je_sources_pkg.check_unique('Testing', 'ABD02334');
78 -- Notes
79 --
80 PROCEDURE check_unique_key(x_je_source_key VARCHAR2,
81 x_row_id VARCHAR2);
82
83 --
84 -- Procedure
85 -- get_unique_id
86 -- Purpose
87 -- Gets a unique header id
88 -- History
89 -- 06-22-94 Kai Pigg Created
90 -- Arguments
91 -- none
92 -- Example
93 -- bid := gl_je_sources_pkg.get_unique_id;
94 -- Notes
95 --
96 FUNCTION get_unique_id RETURN NUMBER;
97
98
99 --
100 -- Procedure
101 -- is_sla_source
102 -- Purpose
103 -- Returns TRUE if this is an SLA source
104 -- and FALSE otherwise
105 -- History
106 -- 11-20-03 D J Ogg Created
107 -- Arguments
108 -- X_je_source Source name
109 -- Example
110 -- IF (gl_je_sources_pkg.is_sla_source('Payables'))
111 -- Notes
112 --
113 FUNCTION is_sla_source(X_je_source VARCHAR2) RETURN BOOLEAN;
114
115
116 --
117 -- Procedure
118 -- Insert_Row
119 -- Purpose
120 -- Inserts a row into gl_je_sources
121 -- History
122 -- 06-22-94 Kai Pigg Created
123 -- Arguments
124 -- all the columns of the table GL_JE_SOURCES
125 -- Example
126 -- gl_je_sources_pkg.Insert_Row(....;
127 -- Notes
128 --
129 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
130 X_Je_Source_Name IN OUT NOCOPY VARCHAR2,
131 X_Language IN OUT NOCOPY VARCHAR2,
132 X_Source_Lang IN OUT NOCOPY VARCHAR2,
133 X_Last_Update_Date DATE,
134 X_Last_Updated_By NUMBER,
135 X_Override_Edits_Flag VARCHAR2,
136 X_User_Je_Source_Name VARCHAR2,
137 X_Je_Source_Key VARCHAR2,
138 X_Journal_Reference_Flag VARCHAR2,
139 X_Journal_Approval_Flag VARCHAR2,
140 X_Effective_Date_Rule_Code VARCHAR2,
141 X_Import_Using_Key_Flag VARCHAR2,
142 X_Creation_Date DATE,
143 X_Last_Update_Login NUMBER,
144 X_Description VARCHAR2,
145 X_Attribute1 VARCHAR2,
146 X_Attribute2 VARCHAR2,
147 X_Attribute3 VARCHAR2,
148 X_Attribute4 VARCHAR2,
149 X_Attribute5 VARCHAR2,
150 X_Context VARCHAR2);
151
152 --
153 -- Procedure
154 -- Update_Row
155 -- Purpose
156 -- Updates a row into gl_je_sources
157 -- History
158 -- 06-22-94 Kai Pigg Created
159 -- Arguments
160 -- all the columns of the table GL_JE_SOURCES
161 -- Example
162 -- gl_je_sources_pkg.Update_Row(....;
163 -- Notes
164 --
165 PROCEDURE Update_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
166 X_Je_Source_Name VARCHAR2,
167 X_Last_Update_Date DATE,
168 X_Last_Updated_By NUMBER,
169 X_Override_Edits_Flag VARCHAR2,
170 X_User_Je_Source_Name VARCHAR2,
171 X_Je_Source_Key VARCHAR2,
172 X_Journal_Reference_Flag VARCHAR2,
173 X_Journal_Approval_Flag VARCHAR2,
174 X_Effective_Date_Rule_Code VARCHAR2,
175 X_Import_Using_Key_Flag VARCHAR2,
176 X_Creation_Date DATE,
177 X_Last_Update_Login NUMBER,
178 X_Description VARCHAR2,
179 X_Attribute1 VARCHAR2,
180 X_Attribute2 VARCHAR2,
181 X_Attribute3 VARCHAR2,
182 X_Attribute4 VARCHAR2,
183 X_Attribute5 VARCHAR2,
184 X_Context VARCHAR2);
185
186 --
187 -- Procedure
188 -- Lock_Row
189 -- Purpose
190 -- Locks a row into gl_je_sources
191 -- History
192 -- 06-22-94 Kai Pigg Created
193 -- Arguments
194 -- all the columns of the table GL_JE_SOURCES
195 -- Example
196 -- gl_je_sources_pkg.Lock_Row(....;
197 -- Notes
198 --
199 PROCEDURE Lock_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
200 X_Je_Source_Name VARCHAR2,
201 X_Override_Edits_Flag VARCHAR2,
202 X_User_Je_Source_Name VARCHAR2,
203 X_Je_Source_Key VARCHAR2,
204 X_Journal_Reference_Flag VARCHAR2,
205 X_Journal_Approval_Flag VARCHAR2,
206 X_Effective_Date_Rule_Code VARCHAR2,
207 X_Import_Using_Key_Flag VARCHAR2,
208 X_Description VARCHAR2,
209 X_Attribute1 VARCHAR2,
210 X_Attribute2 VARCHAR2,
211 X_Attribute3 VARCHAR2,
212 X_Attribute4 VARCHAR2,
213 X_Attribute5 VARCHAR2,
214 X_Context VARCHAR2);
215 --
216 -- Procedure
217 -- Delete_Row
218 -- Purpose
219 -- Deletes a row from gl_je_sources
220 -- History
221 -- 06-22-94 Kai Pigg Created
222 -- Arguments
223 -- x_rowid Rowid of a row
224 -- Example
225 -- gl_je_sources_pkg.delete_row('ajfdshj');
226 -- Notes
227 --
228 PROCEDURE Delete_Row(X_Je_Source_Name VARCHAR2);
229
230
231 --
232 -- Procedure
233 -- Load_Row
234 -- Purpose
235 -- Called from loader config file to upload a multi-lingual entity
236 -- History
237 -- 07-07-99 M C Hui Created
238 -- Arguments
239 -- all the columns of the view GL_JE_SOURCES
240 -- Example
241 -- gl_je_sources_pkg.Load_Row(....;
242 -- Notes
243 --
244 PROCEDURE Load_Row(
245 X_Je_Source_Name IN OUT NOCOPY VARCHAR2,
246 X_Override_Edits_Flag VARCHAR2,
247 X_User_Je_Source_Name VARCHAR2,
248 X_Je_Source_Key VARCHAR2,
249 X_Journal_Reference_Flag VARCHAR2,
250 X_Journal_Approval_Flag VARCHAR2,
251 X_Effective_Date_Rule_Code VARCHAR2,
252 X_Import_Using_Key_Flag VARCHAR2,
253 X_Description VARCHAR2,
254 X_Attribute1 VARCHAR2,
255 X_Attribute2 VARCHAR2,
256 X_Attribute3 VARCHAR2,
257 X_Attribute4 VARCHAR2,
258 X_Attribute5 VARCHAR2,
259 X_Context VARCHAR2,
260 X_Owner VARCHAR2,
261 X_Force_Edits VARCHAR2 );
262
263 --
264 -- Procedure
265 -- Translate_Row
266 -- Purpose
267 -- Called from loader config file to upload translations.
268 -- History
269 -- 07-07-99 M C Hui Created
270 -- Arguments
271 -- X_Je_Source_Name Journal entry source name
272 -- X_User_Je_Source_Name Journal entry source user defined name
273 -- X_Description Journal entry source description
274 -- X_Owner Can be 'SEED' or other values
275 -- X_Force_Edits Force update to be performed
276 -- Example
277 -- gl_je_sources_pkg.Translate_Row(
278 -- 'Assets', 'Assets', 'SEED', 'Fixed Assets System');
279 -- Notes
280 --
281 PROCEDURE Translate_Row(
282 X_Je_Source_Name VARCHAR2,
283 X_User_Je_Source_Name VARCHAR2,
284 X_Description VARCHAR2,
285 X_Owner VARCHAR2,
286 X_Force_Edits VARCHAR2 );
287
288 --
289 -- Procedure
290 -- Add_Language
291 -- Purpose
292 -- To add a new language row to the gl_je_categories_b
293 -- History
294 -- 24-NOV-98 M C Hui Created
295 -- Arguments
296 -- None
297 -- Example
298 -- gl_je_categories_pkg.Add_Language(....;
299 -- Notes
300 --
301 procedure ADD_LANGUAGE;
302
303
304 END
305 GL_JE_SOURCES_PKG;