1 PACKAGE gl_auto_alloc_batch_pkg AS
2 /* $Header: glatalbs.pls 120.3 2005/05/05 02:02:15 kvora ship $ */
3
4 --Procedure
5 -- Insert_Allocation_batch
6 -- Purpose
7 -- Insert row in GL_AUTO_ALLOC_BATCHES Table
8 -- Example
9 -- gl_auto_alloc_batch_pkg.Insert_Allocation_batch
10 -- Notes
11
12 Procedure Insert_Allocation_batch(
13 l_Row_Id IN OUT NOCOPY VARCHAR2
14 , l_ALLOCATION_SET_ID IN NUMBER
15 , l_BATCH_ID IN NUMBER
16 , l_BATCH_TYPE_CODE IN VARCHAR2
17 , l_LAST_UPDATE_DATE IN DATE
18 , l_LAST_UPDATED_BY IN NUMBER
19 , l_LAST_UPDATE_LOGIN IN NUMBER
20 , l_CREATION_DATE IN DATE
21 , l_CREATED_BY IN NUMBER
22 , l_STEP_NUMBER IN NUMBER
23 , l_OWNER IN VARCHAR2
24 , l_ALLOCATION_METHOD_CODE IN VARCHAR2
25 , l_ATTRIBUTE1 IN VARCHAR2
26 , l_ATTRIBUTE2 IN VARCHAR2
27 , l_ATTRIBUTE3 IN VARCHAR2
28 , l_ATTRIBUTE4 IN VARCHAR2
29 , l_ATTRIBUTE5 IN VARCHAR2
30 , l_ATTRIBUTE6 IN VARCHAR2
31 , l_ATTRIBUTE7 IN VARCHAR2
32 , l_ATTRIBUTE8 IN VARCHAR2
33 , l_ATTRIBUTE9 IN VARCHAR2
34 , l_ATTRIBUTE10 IN VARCHAR2
35 , l_ATTRIBUTE11 IN VARCHAR2
36 , l_ATTRIBUTE12 IN VARCHAR2
37 , l_ATTRIBUTE13 IN VARCHAR2
38 , l_ATTRIBUTE14 IN VARCHAR2
39 , l_ATTRIBUTE15 IN VARCHAR2
40 , l_CONTEXT IN VARCHAR2
41 ) ;
42
43 --Procedure
44 -- Update_Allocation_batch
45 -- Purpose
46 -- Insert row in GL_AUTO_ALLOC_BATCHES Table
47 -- Example
48 -- gl_auto_alloc_batch_pkg.Update_Allocation_batch
49 -- Notes
50
51 Procedure Update_Allocation_batch(
52 l_Row_Id IN VARCHAR2
53 , l_BATCH_ID IN NUMBER
54 , l_BATCH_TYPE_CODE IN VARCHAR2
55 , l_LAST_UPDATE_DATE IN DATE
56 , l_LAST_UPDATED_BY IN NUMBER
57 , l_LAST_UPDATE_LOGIN IN NUMBER
58 , l_STEP_NUMBER IN NUMBER
59 , l_OWNER IN VARCHAR2
60 , l_ALLOCATION_METHOD_CODE IN VARCHAR2
61 , l_ATTRIBUTE1 IN VARCHAR2
62 , l_ATTRIBUTE2 IN VARCHAR2
63 , l_ATTRIBUTE3 IN VARCHAR2
64 , l_ATTRIBUTE4 IN VARCHAR2
65 , l_ATTRIBUTE5 IN VARCHAR2
66 , l_ATTRIBUTE6 IN VARCHAR2
67 , l_ATTRIBUTE7 IN VARCHAR2
68 , l_ATTRIBUTE8 IN VARCHAR2
69 , l_ATTRIBUTE9 IN VARCHAR2
70 , l_ATTRIBUTE10 IN VARCHAR2
71 , l_ATTRIBUTE11 IN VARCHAR2
72 , l_ATTRIBUTE12 IN VARCHAR2
73 , l_ATTRIBUTE13 IN VARCHAR2
74 , l_ATTRIBUTE14 IN VARCHAR2
75 , l_ATTRIBUTE15 IN VARCHAR2
76 , l_CONTEXT IN VARCHAR2
77 );
78
79
80 --Procedure
81 -- Delete_Allocation_batch
82 -- Purpose
83 -- delete row in GL_AUTO_ALLOC_BATCHES Table
84 -- Example
85 -- gl_auto_alloc_batch_pkg.Delete_Allocation_batch
86 -- Notes
87
88 Procedure Delete_Allocation_batch(
89 l_Row_id IN VARCHAR2
90 );
91
92 --Procedure
93 -- Lock_allocation_batch
94 -- Purpose
95 -- Locks row in GL_AUTO_ALLOC_BATCHES Table
96 -- Example
97 -- gl_auto_alloc_batch_pkg.Lock_allocation_batch
98 -- Notes
99
100 Procedure Lock_allocation_batch
101 (
102 l_Row_Id IN VARCHAR2
103 , l_ALLOCATION_SET_ID IN NUMBER
104 , l_BATCH_ID IN NUMBER
105 , l_BATCH_TYPE_CODE IN VARCHAR2
106 , l_LAST_UPDATED_BY IN NUMBER
107 , l_LAST_UPDATE_LOGIN IN NUMBER
108 , l_STEP_NUMBER IN NUMBER
109 , l_OWNER IN VARCHAR2
110 , l_ALLOCATION_METHOD_CODE IN VARCHAR2
111 , l_ATTRIBUTE1 IN VARCHAR2
112 , l_ATTRIBUTE2 IN VARCHAR2
113 , l_ATTRIBUTE3 IN VARCHAR2
114 , l_ATTRIBUTE4 IN VARCHAR2
115 , l_ATTRIBUTE5 IN VARCHAR2
116 , l_ATTRIBUTE6 IN VARCHAR2
117 , l_ATTRIBUTE7 IN VARCHAR2
118 , l_ATTRIBUTE8 IN VARCHAR2
119 , l_ATTRIBUTE9 IN VARCHAR2
120 , l_ATTRIBUTE10 IN VARCHAR2
121 , l_ATTRIBUTE11 IN VARCHAR2
122 , l_ATTRIBUTE12 IN VARCHAR2
123 , l_ATTRIBUTE13 IN VARCHAR2
124 , l_ATTRIBUTE14 IN VARCHAR2
125 , l_ATTRIBUTE15 IN VARCHAR2
126 , l_CONTEXT IN VARCHAR2
127 );
128
129
130 -- Procedure
131 -- Check_Unique_Step
132 -- Purpose
133 -- Check uniquenes of Allocation set
134 -- Access
135 -- Called from the AutoAllocation workbench form
136 --
137
138 PROCEDURE Check_Unique_Step( l_rowid IN VARCHAR2
139 ,l_step_number IN NUMBER
140 ,l_allocation_set_id IN NUMBER
141 ,l_step_label IN VARCHAR2 );
142
143
144 -- Procedure
145 -- Check_Unique_Batch
146 -- Purpose
147 -- Check uniquenes of of batch in the Allocation set
148 --
149
150 PROCEDURE Check_Unique_Batch( l_rowid IN VARCHAR2
151 ,l_allocation_set_id IN NUMBER
152 ,l_Batch_Id IN NUMBER
153 ,l_Batch_Type_Code IN VARCHAR2
154 ,l_Return_Code IN OUT NOCOPY VARCHAR2 );
155
156
157
158
159 -- Procedure
160 -- get_step_status
161 -- Purpose
162 -- Get summary level batch type and balance type info
163 -- Access
164 -- Called from the View AutoAllocation status form
165 -- Mode indicated whether its step-down or parallel
166
167 Procedure get_step_status (
168 p_request_Id In NUMBER
169 ,p_step_number In NUMBER
170 ,p_mode In VARCHAR2
171 ,p_status Out NOCOPY VARCHAR2) ;
172
173 Procedure get_gl_step_status(
174 p_request_Id In NUMBER
175 ,p_step_number In NUMBER
176 ,p_mode In VARCHAR2
177 ,p_status Out NOCOPY VARCHAR2);
178
179 END gl_auto_alloc_batch_pkg;