[Home] [Help]
PACKAGE: APPS.GL_RECURRING_BATCHES_PKG
Source
1 PACKAGE GL_RECURRING_BATCHES_PKG AUTHID CURRENT_USER AS
2 /* $Header: glirecbs.pls 120.5 2005/05/05 01:19:49 kvora ship $ */
3 --
4 -- Package
5 -- GL_RECURRING_BATCHES_PKG
6 -- Purpose
7 -- To group all the procedures/functions for gl_recurring_batches_pkg.
8 -- History
9 -- 20-FEB-1994 ERumanan Created.
10 --
11
12
13 --
14 -- Procedure
15 -- check_unique
16 -- Purpose
17 -- Ensure new recurring batch name is unique.
18 -- History
19 -- 20-FEB-1994 ERumanan Created.
20 -- Arguments
21 -- x_rowid The ID of the row to be checked
22 -- x_name The recurring formula name to be checked
23 -- x_coaid
24 -- x_period_set_name
25 -- x_accounted_period_type
26 -- Example
27 --
28 -- Notes
29 --
30 PROCEDURE check_unique( x_rowid VARCHAR2,
31 x_name VARCHAR2,
32 x_coaid NUMBER,
33 x_period_set_name VARCHAR2,
34 x_accounted_period_type VARCHAR2);
35
36 --
37 -- Procedure
38 -- get_unique_id
39 -- Purpose
40 -- Get a new sequence unique id for a new recurring formula.
41 -- History
42 -- 20-FEB-1994 ERumanan Created.
43 -- Arguments
44 -- none
45 -- Example
46 -- :REC_BATCH.recurring_batch_id := GL_RECURRING_BATCHES_PKG.get_unique_id;
47 -- Notes
48 --
49 FUNCTION get_unique_id RETURN NUMBER;
50
51
52
53 --
54 -- Procedure
55 -- copy_recurring
56 -- Purpose
57 -- Copy the recurring formula journal or budget formula
58 -- from the given source batch to target batch.
59 -- History
60 -- 18-MAR-1994 ERumanan Created.
61 -- Arguments
62 -- x_src_batch_id Source recurring batch id.
63 -- x_trg_batch_id Target recurring batch id.
64 -- x_trg_batch_name Target recurring batch name.
65 -- x_trg_batch_desc Target recurring batch description.
66 -- Example
67 -- gl_recurring_batches_pkg.copy_recurring( 12345,
68 -- 'New Batch', 'This batch is copied from batch bla bla bla' );
69 -- Notes
70 --
71 PROCEDURE copy_recurring( X_Src_Batch_Id NUMBER,
72 X_Trg_Batch_Id NUMBER,
73 X_Created_By NUMBER,
74 X_Last_Updated_By NUMBER,
75 X_Last_Update_Login NUMBER
76 );
77
78
79 --
80 -- Procedure
81 -- insert_row
82 -- Purpose
83 -- History
84 -- 08-MAR-1995 CSCHALK Created.
85 -- Arguments
86 --
87 -- Example
88 --
89 -- Notes
90 --
91
92
93 PROCEDURE Insert_Row( X_Rowid IN OUT NOCOPY VARCHAR2,
94 X_Recurring_Batch_Id IN OUT NOCOPY NUMBER,
95 X_Last_Update_Date DATE,
96 X_Last_Updated_By NUMBER,
97 X_Ledger_Id NUMBER,
98 X_Chart_Of_Accounts_Id NUMBER,
99 X_Period_Set_Name VARCHAR2,
100 X_Accounted_Period_Type VARCHAR2,
101 X_Recurring_Batch_Type VARCHAR2,
102 X_Security_Flag VARCHAR2,
103 X_Name VARCHAR2,
104 X_Budget_Flag VARCHAR2,
105 X_Allocation_Flag VARCHAR2,
106 X_Creation_Date DATE,
107 X_Created_By NUMBER,
108 X_Last_Update_Login NUMBER,
109 X_Budget_In_Formula_Flag VARCHAR2,
110 X_Description VARCHAR2,
111 X_Period_Type VARCHAR2,
112 X_Last_Executed_Period_Name VARCHAR2,
113 X_Last_Executed_Date DATE,
114 X_Attribute1 VARCHAR2,
115 X_Attribute2 VARCHAR2,
116 X_Attribute3 VARCHAR2,
117 X_Attribute4 VARCHAR2,
118 X_Attribute5 VARCHAR2,
119 X_Attribute6 VARCHAR2,
120 X_Attribute7 VARCHAR2,
121 X_Attribute8 VARCHAR2,
122 X_Attribute9 VARCHAR2,
123 X_Attribute10 VARCHAR2,
124 X_Context VARCHAR2
125 );
126
127
128
129 --*******************************************************************
130
131
132 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
133 X_Recurring_Batch_Id NUMBER,
134 X_Ledger_Id NUMBER,
135 X_Chart_Of_Accounts_Id NUMBER,
136 X_Period_Set_Name VARCHAR2,
137 X_Accounted_Period_Type VARCHAR2,
138 X_Recurring_Batch_Type VARCHAR2,
139 X_Security_Flag VARCHAR2,
140 X_Name VARCHAR2,
141 X_Budget_Flag VARCHAR2,
142 X_Allocation_Flag VARCHAR2,
143 X_Budget_In_Formula_Flag VARCHAR2,
144 X_Description VARCHAR2,
145 X_Period_Type VARCHAR2,
146 X_Last_Executed_Period_Name VARCHAR2,
147 X_Last_Executed_Date DATE,
148 X_Attribute1 VARCHAR2,
149 X_Attribute2 VARCHAR2,
150 X_Attribute3 VARCHAR2,
151 X_Attribute4 VARCHAR2,
152 X_Attribute5 VARCHAR2,
153 X_Attribute6 VARCHAR2,
154 X_Attribute7 VARCHAR2,
155 X_Attribute8 VARCHAR2,
156 X_Attribute9 VARCHAR2,
157 X_Attribute10 VARCHAR2,
158 X_Context VARCHAR2
159 );
160
161
162
163 PROCEDURE Update_Row(X_Rowid VARCHAR2,
164 X_Recurring_Batch_Id NUMBER,
165 X_Last_Update_Date DATE,
166 X_Last_Updated_By NUMBER,
167 X_Ledger_Id NUMBER,
168 X_Chart_Of_Accounts_Id NUMBER,
169 X_Period_Set_Name VARCHAR2,
170 X_Accounted_Period_Type VARCHAR2,
171 X_Recurring_Batch_Type VARCHAR2,
172 X_Security_Flag VARCHAR2,
173 X_Name VARCHAR2,
174 X_Budget_Flag VARCHAR2,
175 X_Allocation_Flag VARCHAR2,
176 X_Last_Update_Login NUMBER,
177 X_Budget_In_Formula_Flag VARCHAR2,
178 X_Description VARCHAR2,
179 X_Period_Type VARCHAR2,
180 X_Last_Executed_Period_Name VARCHAR2,
181 X_Last_Executed_Date DATE,
182 X_Attribute1 VARCHAR2,
183 X_Attribute2 VARCHAR2,
184 X_Attribute3 VARCHAR2,
185 X_Attribute4 VARCHAR2,
186 X_Attribute5 VARCHAR2,
187 X_Attribute6 VARCHAR2,
188 X_Attribute7 VARCHAR2,
189 X_Attribute8 VARCHAR2,
190 X_Attribute9 VARCHAR2,
191 X_Attribute10 VARCHAR2,
192 X_Context VARCHAR2
193 );
194
195
196 PROCEDURE Delete_Row(X_Rowid VARCHAR2);
197
198
199 --
200 -- Procedure
201 -- Check_Batch
202 -- Purpose
203 -- Check that the batch is not used in any AutoAllocation set
204 -- History
205 -- 14-AUG-2003 K Chang Created.
206 -- Arguments
207 -- x_recurring_batch_id Source recurring batch id.
208 -- Example
209 -- gl_recurring_batches_pkg.check_batch(
210 --
211 PROCEDURE Check_Batch( X_Recurring_Batch_Id NUMBER);
212
213
214
215 --*******************************************************************
216
217 END GL_RECURRING_BATCHES_PKG;