[Home] [Help]
PACKAGE: APPS.GL_RECURRING_RULES_PKG
Source
1 PACKAGE GL_RECURRING_RULES_PKG AS
2 /* $Header: glirecrs.pls 120.5 2005/05/05 01:20:32 kvora ship $ */
3 --
4 -- Package
5 -- GL_RECURRING_RULES_PKG
6 -- Purpose
7 -- To group all the procedures/functions for GL_RECURRING_RULES_PKG.
8 -- History
9 -- 25-FEB-1994 ERumanan Created.
10 --
11
12
13 --
14 -- Procedure
15 -- check_unique
16 -- Purpose
17 -- Ensure new recurring formula step number is unique.
18 -- History
19 -- 25-FEB-1994 ERumanan Created.
20 -- Arguments
21 -- x_rowid The ID of the row to be checked
22 -- x_rule_num The recurring formula step number to be checked
23 -- x_line_num The recurring line number to be checked
24 -- x_header_id The recurring header id to be checked
25 -- Example
26 -- GL_RECURRING_RULES_PKG.check_unique( '12345', 1, 1, 123 );
27 -- Notes
28 --
29 PROCEDURE check_unique( x_rowid VARCHAR2,
30 x_rule_num NUMBER,
31 x_line_num NUMBER,
32 x_header_id NUMBER );
33
34 --
35 -- Procedure
36 -- update_line_num
37 -- Purpose
38 -- Update line number of the corresponding rows.
39 -- History
40 -- 15-MAR-1994 ERumanan Created.
41 -- Arguments
42 -- x_new_line_num The new line number
43 -- x_line_num The old line number to be replaced
44 -- x_header_id The recurring header id
45 -- Example
46 -- GL_RECURRING_RULES_PKG.update_line_num( 10, 9, 123 );
47 -- Notes
48 --
49 PROCEDURE update_line_num( x_new_line_num NUMBER,
50 x_old_line_num NUMBER,
51 x_header_id NUMBER );
52
53 --***************************************************************
54 --
55 -- Procedure
56 -- get_ccid
57 -- Purpose
58 -- Get the code combination id of the account flexfield
59 -- History
60 -- 30-MAY-2000 KChang Created.
61 -- Arguments
62 -- x_ccid The code combination id
63 -- x_ledger_id The ledger id
64 -- x_templgrid The ledger id of the summary template. If
65 -- not found, default to the current ledger id
66 -- x_coa_id The chart of accounts id
67 -- x_segment1...30 The segment values
68 -- Example
69 -- GL_RECURRING_RULES_PKG.get_ccid(... );
70 -- Notes
71 --
72 Function get_ccid( X_LEDGER_ID NUMBER,
73 X_COA_ID NUMBER,
74 X_CONC_SEG VARCHAR2,
75 X_ERR_MSG OUT NOCOPY VARCHAR2,
76 X_CCID OUT NOCOPY NUMBER,
77 X_TempLgrId OUT NOCOPY NUMBER,
78 X_Acct_Type OUT NOCOPY VARCHAR2,
79 X_Segment1 VARCHAR2,
80 X_Segment2 VARCHAR2,
81 X_Segment3 VARCHAR2,
82 X_Segment4 VARCHAR2,
83 X_Segment5 VARCHAR2,
84 X_Segment6 VARCHAR2,
85 X_Segment7 VARCHAR2,
86 X_Segment8 VARCHAR2,
87 X_Segment9 VARCHAR2,
88 X_Segment10 VARCHAR2,
89 X_Segment11 VARCHAR2,
90 X_Segment12 VARCHAR2,
91 X_Segment13 VARCHAR2,
92 X_Segment14 VARCHAR2,
93 X_Segment15 VARCHAR2,
94 X_Segment16 VARCHAR2,
95 X_Segment17 VARCHAR2,
96 X_Segment18 VARCHAR2,
97 X_Segment19 VARCHAR2,
98 X_Segment20 VARCHAR2,
99 X_Segment21 VARCHAR2,
100 X_Segment22 VARCHAR2,
101 X_Segment23 VARCHAR2,
102 X_Segment24 VARCHAR2,
103 X_Segment25 VARCHAR2,
104 X_Segment26 VARCHAR2,
105 X_Segment27 VARCHAR2,
106 X_Segment28 VARCHAR2,
107 X_Segment29 VARCHAR2,
108 X_Segment30 VARCHAR2 )
109 RETURN BOOLEAN;
110
111 --*********************************************************
112
113 --
114 -- Procedure
115 -- delete_rows
116 -- Purpose
117 -- Delete rows for all the detail blocks.
118 -- History
119 -- 20-MAR-1994 ERumanan Created.
120 -- Arguments
121 -- x_header_id The recurring header id.
122 -- x_line_num The recurring line number.
123 -- Example
124 -- GL_RECURRING_RULES_PKG.delete_rows( 10, 1 );
125 -- Notes
126 --
127 PROCEDURE delete_rows( x_header_id NUMBER,
128 x_line_num NUMBER );
129
130
131 --*****************************************
132
133
134 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
135 X_Recurring_Header_Id NUMBER,
136 X_Recurring_Line_Num NUMBER,
137 X_Rule_Num NUMBER,
138 X_Last_Update_Date DATE,
139 X_Last_Updated_By NUMBER,
140 X_Operator VARCHAR2,
141 X_Creation_Date DATE,
142 X_Created_By NUMBER,
143 X_Last_Update_Login NUMBER,
144 X_Amount NUMBER,
145 X_Amount_Type VARCHAR2,
146 X_Actual_Flag VARCHAR2,
147 X_Ledger_Currency VARCHAR2,
148 X_Currency_Type VARCHAR2,
149 X_Entered_Currency VARCHAR2,
150 X_Ledger_Id NUMBER,
151 X_Relative_Period_Code VARCHAR2,
152 X_Attribute1 VARCHAR2,
153 X_Attribute2 VARCHAR2,
154 X_Attribute3 VARCHAR2,
155 X_Attribute4 VARCHAR2,
156 X_Attribute5 VARCHAR2,
157 X_Context VARCHAR2,
158 X_Assigned_Code_Combination NUMBER,
159 X_Template_Id NUMBER,
160 X_Segment1 VARCHAR2,
161 X_Segment2 VARCHAR2,
162 X_Segment3 VARCHAR2,
163 X_Segment4 VARCHAR2,
164 X_Segment5 VARCHAR2,
165 X_Segment6 VARCHAR2,
166 X_Segment7 VARCHAR2,
167 X_Segment8 VARCHAR2,
168 X_Segment9 VARCHAR2,
169 X_Segment10 VARCHAR2,
170 X_Segment11 VARCHAR2,
171 X_Segment12 VARCHAR2,
172 X_Segment13 VARCHAR2,
173 X_Segment14 VARCHAR2,
174 X_Segment15 VARCHAR2,
175 X_Segment16 VARCHAR2,
176 X_Segment17 VARCHAR2,
177 X_Segment18 VARCHAR2,
178 X_Segment19 VARCHAR2,
179 X_Segment20 VARCHAR2,
180 X_Segment21 VARCHAR2,
181 X_Segment22 VARCHAR2,
182 X_Segment23 VARCHAR2,
183 X_Segment24 VARCHAR2,
184 X_Segment25 VARCHAR2,
185 X_Segment26 VARCHAR2,
186 X_Segment27 VARCHAR2,
187 X_Segment28 VARCHAR2,
188 X_Segment29 VARCHAR2,
189 X_Segment30 VARCHAR2
190 );
191
192 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
193
194 X_Recurring_Header_Id NUMBER,
195 X_Recurring_Line_Num NUMBER,
196 X_Rule_Num NUMBER,
197 X_Operator VARCHAR2,
198 X_Amount NUMBER,
199 X_Amount_Type VARCHAR2,
200 X_Actual_Flag VARCHAR2,
201 X_Ledger_Currency VARCHAR2,
202 X_Currency_Type VARCHAR2,
203 X_Entered_Currency VARCHAR2,
204 X_Ledger_Id NUMBER,
205 X_Relative_Period_Code VARCHAR2,
206 X_Attribute1 VARCHAR2,
207 X_Attribute2 VARCHAR2,
208 X_Attribute3 VARCHAR2,
209 X_Attribute4 VARCHAR2,
210 X_Attribute5 VARCHAR2,
211 X_Context VARCHAR2,
212 X_Assigned_Code_Combination NUMBER,
213 X_Template_Id NUMBER,
214 X_Segment1 VARCHAR2,
215 X_Segment2 VARCHAR2,
216 X_Segment3 VARCHAR2,
217 X_Segment4 VARCHAR2,
218 X_Segment5 VARCHAR2,
219 X_Segment6 VARCHAR2,
220 X_Segment7 VARCHAR2,
221 X_Segment8 VARCHAR2,
222 X_Segment9 VARCHAR2,
223 X_Segment10 VARCHAR2,
224 X_Segment11 VARCHAR2,
225 X_Segment12 VARCHAR2,
226 X_Segment13 VARCHAR2,
227 X_Segment14 VARCHAR2,
228 X_Segment15 VARCHAR2,
229 X_Segment16 VARCHAR2,
230 X_Segment17 VARCHAR2,
231 X_Segment18 VARCHAR2,
232 X_Segment19 VARCHAR2,
233 X_Segment20 VARCHAR2,
234 X_Segment21 VARCHAR2,
235 X_Segment22 VARCHAR2,
236 X_Segment23 VARCHAR2,
237 X_Segment24 VARCHAR2,
238 X_Segment25 VARCHAR2,
239 X_Segment26 VARCHAR2,
240 X_Segment27 VARCHAR2,
241 X_Segment28 VARCHAR2,
242 X_Segment29 VARCHAR2,
243 X_Segment30 VARCHAR2
244 );
245
246
247
248 PROCEDURE Update_Row(X_Rowid VARCHAR2,
249
250 X_Recurring_Header_Id NUMBER,
251 X_Recurring_Line_Num NUMBER,
252 X_Rule_Num NUMBER,
253 X_Last_Update_Date DATE,
254 X_Last_Updated_By NUMBER,
255 X_Operator VARCHAR2,
256 X_Last_Update_Login NUMBER,
257 X_Amount NUMBER,
258 X_Amount_Type VARCHAR2,
259 X_Actual_Flag VARCHAR2,
260 X_Ledger_Currency VARCHAR2,
261 X_Currency_Type VARCHAR2,
262 X_Entered_Currency VARCHAR2,
263 X_Ledger_Id NUMBER,
264 X_Relative_Period_Code VARCHAR2,
265 X_Attribute1 VARCHAR2,
266 X_Attribute2 VARCHAR2,
267 X_Attribute3 VARCHAR2,
268 X_Attribute4 VARCHAR2,
269 X_Attribute5 VARCHAR2,
270 X_Context VARCHAR2,
271 X_Assigned_Code_Combination NUMBER,
272 X_Template_Id NUMBER,
273 X_Segment1 VARCHAR2,
274 X_Segment2 VARCHAR2,
275 X_Segment3 VARCHAR2,
279 X_Segment7 VARCHAR2,
276 X_Segment4 VARCHAR2,
277 X_Segment5 VARCHAR2,
278 X_Segment6 VARCHAR2,
280 X_Segment8 VARCHAR2,
281 X_Segment9 VARCHAR2,
282 X_Segment10 VARCHAR2,
283 X_Segment11 VARCHAR2,
284 X_Segment12 VARCHAR2,
285 X_Segment13 VARCHAR2,
286 X_Segment14 VARCHAR2,
287 X_Segment15 VARCHAR2,
288 X_Segment16 VARCHAR2,
289 X_Segment17 VARCHAR2,
290 X_Segment18 VARCHAR2,
291 X_Segment19 VARCHAR2,
292 X_Segment20 VARCHAR2,
293 X_Segment21 VARCHAR2,
294 X_Segment22 VARCHAR2,
295 X_Segment23 VARCHAR2,
296 X_Segment24 VARCHAR2,
297 X_Segment25 VARCHAR2,
298 X_Segment26 VARCHAR2,
299 X_Segment27 VARCHAR2,
300 X_Segment28 VARCHAR2,
301 X_Segment29 VARCHAR2,
302 X_Segment30 VARCHAR2
303 );
304
305
306 PROCEDURE Delete_Row(X_Rowid VARCHAR2);
307
308 PROCEDURE get_account_type( x_coa_id NUMBER,
309 x_conc_seg VARCHAR2,
310 x_account_type OUT NOCOPY VARCHAR2);
311
312 --****************************************************************
313
314
315
316
317 END GL_RECURRING_RULES_PKG;