[Home] [Help]
PACKAGE: APPS.GL_SUMMARY_TEMPLATES_PKG
Source
1 PACKAGE GL_SUMMARY_TEMPLATES_PKG AS
2 /* $Header: gliactps.pls 120.5 2005/07/11 05:21:59 agovil ship $ */
3 --
4 -- Package
5 -- GL_SUMMARY_TEMPLATES_PKG
6 -- Purpose
7 -- To implement validation unique checking and sequence id
8 -- generation for the GL_SUMMARY_TEMPLATES table
9 -- History
10 -- 12.01.93 E. Rumanang Created
11 --
12
13 --
14 -- Procedure
15 -- is_funds_check_not_none
16 -- Purpose
17 -- Find the existence of funds_check_level_code not equals
18 -- to none. If it find one, return TRUE, else return FALSE.
19 -- History
20 -- 12.01.93 E. Rumanang Created
21 -- Arguments
22 -- x_ledger_id Ledger id to be checked.
23 -- Example
24 -- GL_SUMMARY_TEMPLATES_PKG.is_funds_check_not_none( 123 );
25 -- Notes
26 --
27 FUNCTION is_funds_check_not_none (
28 x_ledger_id NUMBER ) RETURN BOOLEAN;
29
30 --
31 -- Procedure
32 -- check_unique_name
33 -- Purpose
34 -- Ensure unicity of template name
35 -- History
36 -- 04.27.94 S Leotin Created
37 -- Example
38 -- GL_SUMMARY_TEMPLATES_PKG.check_unique_name;
39
40
41 PROCEDURE check_unique_name(
42 X_rowid VARCHAR2,
43 X_ledger_id NUMBER,
44 X_template_name VARCHAR2);
45
46 --
47 -- Procedure
48 -- check_unique_template
49 -- Purpose
50 -- Ensure unicity of template
51 -- History
52 -- 04.27.94 S Leotin Created
53 -- Example
54 -- GL_SUMMARY_TEMPLATES_PKG.check_unique_template;
55
56 FUNCTION check_unique_template
57 (X_rowid VARCHAR2,
58 X_ledger_id NUMBER,
59 X_segment1_type VARCHAR2,
60 X_segment2_type VARCHAR2,
61 X_segment3_type VARCHAR2,
62 X_segment4_type VARCHAR2,
63 X_segment5_type VARCHAR2,
64 X_segment6_type VARCHAR2,
65 X_segment7_type VARCHAR2,
66 X_segment8_type VARCHAR2,
67 X_segment9_type VARCHAR2,
68 X_segment10_type VARCHAR2,
69 X_segment11_type VARCHAR2,
70 X_segment12_type VARCHAR2,
71 X_segment13_type VARCHAR2,
72 X_segment14_type VARCHAR2,
73 X_segment15_type VARCHAR2,
74 X_segment16_type VARCHAR2,
75 X_segment17_type VARCHAR2,
76 X_segment18_type VARCHAR2,
77 X_segment19_type VARCHAR2,
78 X_segment20_type VARCHAR2,
79 X_segment21_type VARCHAR2,
80 X_segment22_type VARCHAR2,
81 X_segment23_type VARCHAR2,
82 X_segment24_type VARCHAR2,
83 X_segment25_type VARCHAR2,
84 X_segment26_type VARCHAR2,
85 X_segment27_type VARCHAR2,
86 X_segment28_type VARCHAR2,
87 X_segment29_type VARCHAR2,
88 X_segment30_type VARCHAR2) RETURN BOOLEAN;
89
90 -- Procedure
91 -- get_unique_id
92 -- Purpose
93 -- retrieves unique id from sequence
94 -- Arguments
95 -- *none
96 -- Example
97 -- template_id := gl_summary_templates_pkg.get_unique_id;
98
99 FUNCTION get_unique_id RETURN NUMBER;
100
101 -- Procedure
102 -- Insert_Row
103 -- Purpose
104 -- Insert a new row into GL_SUMMARY_TEMPLATES
105 -- History
106 -- 01/30/02 C Ma Created
107 -- Example
108 -- GL_SUMMARY_TEMPLATES_PKG.Insert_Row;
109 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
110 X_Template_Name VARCHAR2,
111 X_Start_Actuals_Period_Name VARCHAR2,
112 X_Description VARCHAR2,
113 X_Account_Category_Code VARCHAR2,
114 X_Template_Id NUMBER,
115 X_Ledger_Id NUMBER,
116 X_Status VARCHAR2,
117 X_Last_Update_Date DATE,
118 X_Last_Updated_by NUMBER,
119 X_Concatenated_Description VARCHAR2,
120 X_Max_Code_Combination_Id NUMBER,
121 X_Created_By NUMBER,
122 X_Creation_Date DATE,
123 X_Last_Update_Login NUMBER,
124 X_Segment1_Type VARCHAR2,
125 X_Segment2_Type VARCHAR2,
126 X_Segment3_Type VARCHAR2,
127 X_Segment4_Type VARCHAR2,
128 X_Segment5_Type VARCHAR2,
129 X_Segment6_Type VARCHAR2,
130 X_Segment7_Type VARCHAR2,
131 X_Segment8_Type VARCHAR2,
132 X_Segment9_Type VARCHAR2,
133 X_Segment10_Type VARCHAR2,
134 X_Segment11_Type VARCHAR2,
135 X_Segment12_Type VARCHAR2,
136 X_Segment13_Type VARCHAR2,
137 X_Segment14_Type VARCHAR2,
138 X_Segment15_Type VARCHAR2,
139 X_Segment16_Type VARCHAR2,
140 X_Segment17_Type VARCHAR2,
141 X_Segment18_Type VARCHAR2,
142 X_Segment19_Type VARCHAR2,
143 X_Segment20_Type VARCHAR2,
144 X_Segment21_Type VARCHAR2,
145 X_Segment22_Type VARCHAR2,
146 X_Segment23_Type VARCHAR2,
147 X_Segment24_Type VARCHAR2,
148 X_Segment25_Type VARCHAR2,
149 X_Segment26_Type VARCHAR2,
150 X_Segment27_Type VARCHAR2,
151 X_Segment28_Type VARCHAR2,
152 X_Segment29_Type VARCHAR2,
153 X_Segment30_Type VARCHAR2,
154 X_Attribute1 VARCHAR2,
155 X_Attribute2 VARCHAR2,
156 X_Attribute3 VARCHAR2,
157 X_Attribute4 VARCHAR2,
158 X_Attribute5 VARCHAR2,
159 X_Attribute6 VARCHAR2,
160 X_Attribute7 VARCHAR2,
161 X_Attribute8 VARCHAR2,
162 X_Context VARCHAR2
163 );
164
165 -- Procedure
166 -- Lock_Row
167 -- Purpose
168 -- Lock a row in GL_SUMMARY_TEMPLATES
169 -- History
170 -- 01/30/02 C Ma Created
171 -- Example
172 -- GL_SUMMARY_TEMPLATES_PKG.Lock_Row;
173 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
174 X_Template_Name VARCHAR2,
175 X_Start_Actuals_Period_Name VARCHAR2,
176 X_Description VARCHAR2,
177 X_Account_Category_Code VARCHAR2,
178 X_Template_Id NUMBER,
179 X_Ledger_Id NUMBER,
180 X_Status VARCHAR2,
181 X_Last_Update_Date DATE,
182 X_Last_Updated_by NUMBER,
183 X_Concatenated_Description VARCHAR2,
184 X_Max_Code_Combination_Id NUMBER,
185 X_Created_By NUMBER,
186 X_Creation_Date DATE,
187 X_Last_Update_Login NUMBER,
188 X_Segment1_Type VARCHAR2,
189 X_Segment2_Type VARCHAR2,
190 X_Segment3_Type VARCHAR2,
191 X_Segment4_Type VARCHAR2,
192 X_Segment5_Type VARCHAR2,
193 X_Segment6_Type VARCHAR2,
194 X_Segment7_Type VARCHAR2,
195 X_Segment8_Type VARCHAR2,
196 X_Segment9_Type VARCHAR2,
197 X_Segment10_Type VARCHAR2,
198 X_Segment11_Type VARCHAR2,
199 X_Segment12_Type VARCHAR2,
200 X_Segment13_Type VARCHAR2,
201 X_Segment14_Type VARCHAR2,
202 X_Segment15_Type VARCHAR2,
203 X_Segment16_Type VARCHAR2,
204 X_Segment17_Type VARCHAR2,
205 X_Segment18_Type VARCHAR2,
206 X_Segment19_Type VARCHAR2,
207 X_Segment20_Type VARCHAR2,
208 X_Segment21_Type VARCHAR2,
209 X_Segment22_Type VARCHAR2,
210 X_Segment23_Type VARCHAR2,
211 X_Segment24_Type VARCHAR2,
212 X_Segment25_Type VARCHAR2,
213 X_Segment26_Type VARCHAR2,
214 X_Segment27_Type VARCHAR2,
215 X_Segment28_Type VARCHAR2,
216 X_Segment29_Type VARCHAR2,
217 X_Segment30_Type VARCHAR2,
218 X_Attribute1 VARCHAR2,
219 X_Attribute2 VARCHAR2,
220 X_Attribute3 VARCHAR2,
221 X_Attribute4 VARCHAR2,
222 X_Attribute5 VARCHAR2,
223 X_Attribute6 VARCHAR2,
224 X_Attribute7 VARCHAR2,
225 X_Attribute8 VARCHAR2,
226 X_Context VARCHAR2
227 );
228
229 -- Procedure
230 -- Update_Row
231 -- Purpose
232 -- Update a row in GL_SUMMARY_TEMPLATES
233 -- History
234 -- 01/30/02 C Ma Created
235 -- Example
236 -- GL_SUMMARY_TEMPLATES_PKG.Update_Row;
237 PROCEDURE Update_Row(X_Rowid VARCHAR2,
238 X_Template_Name VARCHAR2,
239 X_Start_Actuals_Period_Name VARCHAR2,
240 X_Description VARCHAR2,
241 X_Account_Category_Code VARCHAR2,
242 X_Template_Id NUMBER,
243 X_Ledger_Id NUMBER,
244 X_Status VARCHAR2,
245 X_Last_Update_Date DATE,
246 X_Last_Updated_by NUMBER,
247 X_Concatenated_Description VARCHAR2,
248 X_Max_Code_Combination_Id NUMBER,
249 X_Created_By NUMBER,
250 X_Creation_Date DATE,
251 X_Last_Update_Login NUMBER,
252 X_Segment1_Type VARCHAR2,
253 X_Segment2_Type VARCHAR2,
254 X_Segment3_Type VARCHAR2,
255 X_Segment4_Type VARCHAR2,
256 X_Segment5_Type VARCHAR2,
257 X_Segment6_Type VARCHAR2,
258 X_Segment7_Type VARCHAR2,
259 X_Segment8_Type VARCHAR2,
260 X_Segment9_Type VARCHAR2,
261 X_Segment10_Type VARCHAR2,
262 X_Segment11_Type VARCHAR2,
263 X_Segment12_Type VARCHAR2,
264 X_Segment13_Type VARCHAR2,
265 X_Segment14_Type VARCHAR2,
266 X_Segment15_Type VARCHAR2,
267 X_Segment16_Type VARCHAR2,
268 X_Segment17_Type VARCHAR2,
269 X_Segment18_Type VARCHAR2,
270 X_Segment19_Type VARCHAR2,
271 X_Segment20_Type VARCHAR2,
272 X_Segment21_Type VARCHAR2,
273 X_Segment22_Type VARCHAR2,
274 X_Segment23_Type VARCHAR2,
275 X_Segment24_Type VARCHAR2,
276 X_Segment25_Type VARCHAR2,
277 X_Segment26_Type VARCHAR2,
278 X_Segment27_Type VARCHAR2,
279 X_Segment28_Type VARCHAR2,
280 X_Segment29_Type VARCHAR2,
281 X_Segment30_Type VARCHAR2,
282 X_Attribute1 VARCHAR2,
283 X_Attribute2 VARCHAR2,
284 X_Attribute3 VARCHAR2,
285 X_Attribute4 VARCHAR2,
286 X_Attribute5 VARCHAR2,
287 X_Attribute6 VARCHAR2,
288 X_Attribute7 VARCHAR2,
289 X_Attribute8 VARCHAR2,
290 X_Context VARCHAR2
291 );
292
293
294 END GL_SUMMARY_TEMPLATES_PKG;