1 PACKAGE GL_BUDGET_RANGE_INTERIM_PKG as
2 /* $Header: glibdris.pls 120.4 2005/05/05 01:02:11 kvora ship $ */
3
4 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
5 X_Ledger_Id NUMBER,
6 X_Code_Combination_Id NUMBER,
7 X_Currency_Code VARCHAR2,
8 X_Budget_Version_Id NUMBER,
9 X_Budget_Entity_Id NUMBER,
10 X_Period_Year NUMBER,
11 X_Period_Type VARCHAR2,
12 X_Start_Period_Name VARCHAR2,
13 X_Start_Period_Num NUMBER,
14 X_Dr_Flag VARCHAR2,
15 X_Status_Number NUMBER,
16 X_Last_Update_Date DATE,
17 X_Last_Updated_By NUMBER,
18 X_Period1_Amount NUMBER,
19 X_Period2_Amount NUMBER,
20 X_Period3_Amount NUMBER,
21 X_Period4_Amount NUMBER,
22 X_Period5_Amount NUMBER,
23 X_Period6_Amount NUMBER,
24 X_Period7_Amount NUMBER,
25 X_Period8_Amount NUMBER,
26 X_Period9_Amount NUMBER,
27 X_Period10_Amount NUMBER,
28 X_Period11_Amount NUMBER,
29 X_Period12_Amount NUMBER,
30 X_Period13_Amount NUMBER,
31 X_Old_Period1_Amount NUMBER,
32 X_Old_Period2_Amount NUMBER,
33 X_Old_Period3_Amount NUMBER,
34 X_Old_Period4_Amount NUMBER,
35 X_Old_Period5_Amount NUMBER,
36 X_Old_Period6_Amount NUMBER,
37 X_Old_Period7_Amount NUMBER,
38 X_Old_Period8_Amount NUMBER,
39 X_Old_Period9_Amount NUMBER,
40 X_Old_Period10_Amount NUMBER,
41 X_Old_Period11_Amount NUMBER,
42 X_Old_Period12_Amount NUMBER,
43 X_Old_Period13_Amount NUMBER,
44 X_Segment1 VARCHAR2,
45 X_Segment2 VARCHAR2,
46 X_Segment3 VARCHAR2,
47 X_Segment4 VARCHAR2,
48 X_Segment5 VARCHAR2,
49 X_Segment6 VARCHAR2,
50 X_Segment7 VARCHAR2,
51 X_Segment8 VARCHAR2,
52 X_Segment9 VARCHAR2,
53 X_Segment10 VARCHAR2,
54 X_Segment11 VARCHAR2,
55 X_Segment12 VARCHAR2,
56 X_Segment13 VARCHAR2,
57 X_Segment14 VARCHAR2,
58 X_Segment15 VARCHAR2,
59 X_Segment16 VARCHAR2,
60 X_Segment17 VARCHAR2,
61 X_Segment18 VARCHAR2,
62 X_Segment19 VARCHAR2,
63 X_Segment20 VARCHAR2,
64 X_Segment21 VARCHAR2,
65 X_Segment22 VARCHAR2,
66 X_Segment23 VARCHAR2,
67 X_Segment24 VARCHAR2,
68 X_Segment25 VARCHAR2,
69 X_Segment26 VARCHAR2,
70 X_Segment27 VARCHAR2,
71 X_Segment28 VARCHAR2,
72 X_Segment29 VARCHAR2,
73 X_Segment30 VARCHAR2,
74 X_Account_Type VARCHAR2,
75 X_Creation_Date DATE,
76 X_Created_By NUMBER,
77 X_Last_Update_Login NUMBER,
78 X_Je_Drcr_Sign_Reference VARCHAR2,
79 X_Je_Line_Description1 VARCHAR2,
80 X_Je_Line_Description2 VARCHAR2,
81 X_Je_Line_Description3 VARCHAR2,
82 X_Je_Line_Description4 VARCHAR2,
83 X_Je_Line_Description5 VARCHAR2,
84 X_Je_Line_Description6 VARCHAR2,
85 X_Je_Line_Description7 VARCHAR2,
86 X_Je_Line_Description8 VARCHAR2,
87 X_Je_Line_Description9 VARCHAR2,
88 X_Je_Line_Description10 VARCHAR2,
89 X_Je_Line_Description11 VARCHAR2,
90 X_Je_Line_Description12 VARCHAR2,
91 X_Je_Line_Description13 VARCHAR2,
92 X_Stat_Amount1 NUMBER,
93 X_Stat_Amount2 NUMBER,
94 X_Stat_Amount3 NUMBER,
95 X_Stat_Amount4 NUMBER,
96 X_Stat_Amount5 NUMBER,
97 X_Stat_Amount6 NUMBER,
98 X_Stat_Amount7 NUMBER,
99 X_Stat_Amount8 NUMBER,
100 X_Stat_Amount9 NUMBER,
101 X_Stat_Amount10 NUMBER,
102 X_Stat_Amount11 NUMBER,
103 X_Stat_Amount12 NUMBER,
104 X_Stat_Amount13 NUMBER
105 );
106
107 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
108 X_Ledger_Id NUMBER,
109 X_Code_Combination_Id NUMBER,
110 X_Currency_Code VARCHAR2,
111 X_Budget_Version_Id NUMBER,
112 X_Budget_Entity_Id NUMBER,
113 X_Period_Year NUMBER,
114 X_Period_Type VARCHAR2,
115 X_Start_Period_Name VARCHAR2,
116 X_Start_Period_Num NUMBER,
117 X_Dr_Flag VARCHAR2,
118 X_Status_Number NUMBER,
119 X_Period1_Amount NUMBER,
120 X_Period2_Amount NUMBER,
121 X_Period3_Amount NUMBER,
122 X_Period4_Amount NUMBER,
123 X_Period5_Amount NUMBER,
124 X_Period6_Amount NUMBER,
125 X_Period7_Amount NUMBER,
126 X_Period8_Amount NUMBER,
127 X_Period9_Amount NUMBER,
128 X_Period10_Amount NUMBER,
129 X_Period11_Amount NUMBER,
130 X_Period12_Amount NUMBER,
131 X_Period13_Amount NUMBER,
132 X_Old_Period1_Amount NUMBER,
133 X_Old_Period2_Amount NUMBER,
134 X_Old_Period3_Amount NUMBER,
135 X_Old_Period4_Amount NUMBER,
136 X_Old_Period5_Amount NUMBER,
137 X_Old_Period6_Amount NUMBER,
138 X_Old_Period7_Amount NUMBER,
139 X_Old_Period8_Amount NUMBER,
140 X_Old_Period9_Amount NUMBER,
141 X_Old_Period10_Amount NUMBER,
142 X_Old_Period11_Amount NUMBER,
143 X_Old_Period12_Amount NUMBER,
144 X_Old_Period13_Amount NUMBER,
145 X_Segment1 VARCHAR2,
146 X_Segment2 VARCHAR2,
147 X_Segment3 VARCHAR2,
148 X_Segment4 VARCHAR2,
149 X_Segment5 VARCHAR2,
150 X_Segment6 VARCHAR2,
151 X_Segment7 VARCHAR2,
152 X_Segment8 VARCHAR2,
153 X_Segment9 VARCHAR2,
154 X_Segment10 VARCHAR2,
155 X_Segment11 VARCHAR2,
156 X_Segment12 VARCHAR2,
157 X_Segment13 VARCHAR2,
158 X_Segment14 VARCHAR2,
159 X_Segment15 VARCHAR2,
160 X_Segment16 VARCHAR2,
161 X_Segment17 VARCHAR2,
162 X_Segment18 VARCHAR2,
163 X_Segment19 VARCHAR2,
164 X_Segment20 VARCHAR2,
165 X_Segment21 VARCHAR2,
166 X_Segment22 VARCHAR2,
167 X_Segment23 VARCHAR2,
168 X_Segment24 VARCHAR2,
169 X_Segment25 VARCHAR2,
170 X_Segment26 VARCHAR2,
171 X_Segment27 VARCHAR2,
172 X_Segment28 VARCHAR2,
173 X_Segment29 VARCHAR2,
174 X_Segment30 VARCHAR2,
175 X_Account_Type VARCHAR2,
176 X_Je_Drcr_Sign_Reference VARCHAR2,
177 X_Je_Line_Description1 VARCHAR2,
178 X_Je_Line_Description2 VARCHAR2,
179 X_Je_Line_Description3 VARCHAR2,
180 X_Je_Line_Description4 VARCHAR2,
181 X_Je_Line_Description5 VARCHAR2,
182 X_Je_Line_Description6 VARCHAR2,
183 X_Je_Line_Description7 VARCHAR2,
184 X_Je_Line_Description8 VARCHAR2,
185 X_Je_Line_Description9 VARCHAR2,
186 X_Je_Line_Description10 VARCHAR2,
187 X_Je_Line_Description11 VARCHAR2,
188 X_Je_Line_Description12 VARCHAR2,
189 X_Je_Line_Description13 VARCHAR2,
190 X_Stat_Amount1 NUMBER,
191 X_Stat_Amount2 NUMBER,
192 X_Stat_Amount3 NUMBER,
193 X_Stat_Amount4 NUMBER,
194 X_Stat_Amount5 NUMBER,
195 X_Stat_Amount6 NUMBER,
196 X_Stat_Amount7 NUMBER,
197 X_Stat_Amount8 NUMBER,
198 X_Stat_Amount9 NUMBER,
199 X_Stat_Amount10 NUMBER,
200 X_Stat_Amount11 NUMBER,
201 X_Stat_Amount12 NUMBER,
202 X_Stat_Amount13 NUMBER
203 );
204
205 PROCEDURE Update_Row(X_Rowid VARCHAR2,
206 X_Ledger_Id NUMBER,
207 X_Code_Combination_Id NUMBER,
208 X_Currency_Code VARCHAR2,
209 X_Budget_Version_Id NUMBER,
210 X_Budget_Entity_Id NUMBER,
211 X_Period_Year NUMBER,
212 X_Period_Type VARCHAR2,
213 X_Start_Period_Name VARCHAR2,
214 X_Start_Period_Num NUMBER,
215 X_Dr_Flag VARCHAR2,
216 X_Status_Number NUMBER,
217 X_Last_Update_Date DATE,
218 X_Last_Updated_By NUMBER,
219 X_Period1_Amount NUMBER,
220 X_Period2_Amount NUMBER,
221 X_Period3_Amount NUMBER,
222 X_Period4_Amount NUMBER,
223 X_Period5_Amount NUMBER,
224 X_Period6_Amount NUMBER,
225 X_Period7_Amount NUMBER,
226 X_Period8_Amount NUMBER,
227 X_Period9_Amount NUMBER,
228 X_Period10_Amount NUMBER,
229 X_Period11_Amount NUMBER,
230 X_Period12_Amount NUMBER,
231 X_Period13_Amount NUMBER,
232 X_Old_Period1_Amount NUMBER,
233 X_Old_Period2_Amount NUMBER,
234 X_Old_Period3_Amount NUMBER,
235 X_Old_Period4_Amount NUMBER,
236 X_Old_Period5_Amount NUMBER,
237 X_Old_Period6_Amount NUMBER,
238 X_Old_Period7_Amount NUMBER,
239 X_Old_Period8_Amount NUMBER,
240 X_Old_Period9_Amount NUMBER,
241 X_Old_Period10_Amount NUMBER,
242 X_Old_Period11_Amount NUMBER,
243 X_Old_Period12_Amount NUMBER,
244 X_Old_Period13_Amount NUMBER,
245 X_Segment1 VARCHAR2,
246 X_Segment2 VARCHAR2,
247 X_Segment3 VARCHAR2,
248 X_Segment4 VARCHAR2,
249 X_Segment5 VARCHAR2,
250 X_Segment6 VARCHAR2,
251 X_Segment7 VARCHAR2,
252 X_Segment8 VARCHAR2,
253 X_Segment9 VARCHAR2,
254 X_Segment10 VARCHAR2,
255 X_Segment11 VARCHAR2,
256 X_Segment12 VARCHAR2,
257 X_Segment13 VARCHAR2,
258 X_Segment14 VARCHAR2,
259 X_Segment15 VARCHAR2,
260 X_Segment16 VARCHAR2,
261 X_Segment17 VARCHAR2,
262 X_Segment18 VARCHAR2,
263 X_Segment19 VARCHAR2,
264 X_Segment20 VARCHAR2,
265 X_Segment21 VARCHAR2,
266 X_Segment22 VARCHAR2,
267 X_Segment23 VARCHAR2,
268 X_Segment24 VARCHAR2,
269 X_Segment25 VARCHAR2,
270 X_Segment26 VARCHAR2,
274 X_Segment30 VARCHAR2,
271 X_Segment27 VARCHAR2,
272 X_Segment28 VARCHAR2,
273 X_Segment29 VARCHAR2,
275 X_Account_Type VARCHAR2,
276 X_Last_Update_Login NUMBER,
277 X_Je_Drcr_Sign_Reference VARCHAR2,
278 X_Je_Line_Description1 VARCHAR2,
279 X_Je_Line_Description2 VARCHAR2,
280 X_Je_Line_Description3 VARCHAR2,
281 X_Je_Line_Description4 VARCHAR2,
282 X_Je_Line_Description5 VARCHAR2,
283 X_Je_Line_Description6 VARCHAR2,
284 X_Je_Line_Description7 VARCHAR2,
285 X_Je_Line_Description8 VARCHAR2,
286 X_Je_Line_Description9 VARCHAR2,
287 X_Je_Line_Description10 VARCHAR2,
288 X_Je_Line_Description11 VARCHAR2,
289 X_Je_Line_Description12 VARCHAR2,
290 X_Je_Line_Description13 VARCHAR2,
291 X_Stat_Amount1 NUMBER,
292 X_Stat_Amount2 NUMBER,
293 X_Stat_Amount3 NUMBER,
294 X_Stat_Amount4 NUMBER,
295 X_Stat_Amount5 NUMBER,
296 X_Stat_Amount6 NUMBER,
297 X_Stat_Amount7 NUMBER,
298 X_Stat_Amount8 NUMBER,
299 X_Stat_Amount9 NUMBER,
300 X_Stat_Amount10 NUMBER,
301 X_Stat_Amount11 NUMBER,
302 X_Stat_Amount12 NUMBER,
303 X_Stat_Amount13 NUMBER
304 );
305
306 PROCEDURE Delete_Row(X_Rowid VARCHAR2);
307
308 END GL_BUDGET_RANGE_INTERIM_PKG;
|
|
|