1 PACKAGE gl_auto_alloc_set_pkg AS
2 /* $Header: glatalss.pls 120.5 2005/05/05 02:02:29 kvora ship $ */
3 --
4 -- Function
5 -- get_unique_id
6 -- Purpose
7 -- Gets a unique allocation_set_id
8 -- Arguments
9 -- none
10 -- Example
11 -- abid := gl_auto_alloc_set_pkg.get_unique_id;
12 -- Notes
13 --
14 FUNCTION Get_Unique_Set_Id RETURN NUMBER;
15
16 -- Procedure
17 -- Insert_Allocation_Set
18 -- Purpose
19 -- Inserts allocation set row into GL_AUTO_ALLOC_SET Table
20 -- Example
21 -- gl_auto_alloc_set_pkg.Insert_Allocation_Set
22 -- Notes
23
24 Procedure Insert_Allocation_Set(
25 l_Row_Id IN OUT NOCOPY VARCHAR2
26 , l_ALLOCATION_SET_ID IN NUMBER
27 , l_ALLOCATION_SET_TYPE_CODE IN VARCHAR2
28 , l_ALLOCATION_SET_NAME IN VARCHAR2
29 , l_ALLOCATION_CODE IN VARCHAR2
30 , l_CHART_OF_ACCOUNTS_ID IN NUMBER
31 , l_PERIOD_SET_NAME IN VARCHAR
32 , l_ACCOUNTED_PERIOD_TYPE IN VARCHAR
33 , l_LAST_UPDATE_DATE IN DATE
34 , l_LAST_UPDATED_BY IN NUMBER
35 , l_LAST_UPDATE_LOGIN IN NUMBER
36 , l_CREATION_DATE IN DATE
37 , l_CREATED_BY IN NUMBER
38 , l_ORG_ID IN NUMBER
39 , l_DESCRIPTION IN VARCHAR2
40 , l_OWNER IN VARCHAR2
41 , l_SECURITY_FLAG IN VARCHAR2
42 , l_ATTRIBUTE1 IN VARCHAR2
43 , l_ATTRIBUTE2 IN VARCHAR2
44 , l_ATTRIBUTE3 IN VARCHAR2
45 , l_ATTRIBUTE4 IN VARCHAR2
46 , l_ATTRIBUTE5 IN VARCHAR2
47 , l_ATTRIBUTE6 IN VARCHAR2
48 , l_ATTRIBUTE7 IN VARCHAR2
49 , l_ATTRIBUTE8 IN VARCHAR2
50 , l_ATTRIBUTE9 IN VARCHAR2
51 , l_ATTRIBUTE10 IN VARCHAR2
52 , l_ATTRIBUTE11 IN VARCHAR2
53 , l_ATTRIBUTE12 IN VARCHAR2
54 , l_ATTRIBUTE13 IN VARCHAR2
55 , l_ATTRIBUTE14 IN VARCHAR2
56 , l_ATTRIBUTE15 IN VARCHAR2
57 , l_CONTEXT IN VARCHAR2
58 );
59
60 -- Procedure
61 -- Lock_Allocation_Set
62 -- Purpose
63 -- locks row in GL_AUTO_ALLOC_SET Table
64 -- Example
65 -- gl_auto_alloc_set_pkg.Lock_Allocation_Set
66 -- Notes
67
68 Procedure Lock_Allocation_Set(
69 l_Row_Id IN VARCHAR2
70 , l_ALLOCATION_SET_ID IN NUMBER
71 , l_ALLOCATION_SET_TYPE_CODE IN VARCHAR2
72 , l_ALLOCATION_SET_NAME IN VARCHAR2
73 , l_ALLOCATION_CODE IN VARCHAR2
74 , l_CHART_OF_ACCOUNTS_ID IN NUMBER
75 , l_PERIOD_SET_NAME IN VARCHAR
76 , l_ACCOUNTED_PERIOD_TYPE IN VARCHAR
77 , l_LAST_UPDATED_BY IN NUMBER
78 , l_LAST_UPDATE_LOGIN IN NUMBER
79 , l_CREATED_BY IN NUMBER
80 , l_DESCRIPTION IN VARCHAR2
81 , l_OWNER IN VARCHAR2
82 , l_SECURITY_FLAG IN VARCHAR2
83 , l_ATTRIBUTE1 IN VARCHAR2
84 , l_ATTRIBUTE2 IN VARCHAR2
85 , l_ATTRIBUTE3 IN VARCHAR2
86 , l_ATTRIBUTE4 IN VARCHAR2
87 , l_ATTRIBUTE5 IN VARCHAR2
88 , l_ATTRIBUTE6 IN VARCHAR2
89 , l_ATTRIBUTE7 IN VARCHAR2
90 , l_ATTRIBUTE8 IN VARCHAR2
91 , l_ATTRIBUTE9 IN VARCHAR2
92 , l_ATTRIBUTE10 IN VARCHAR2
93 , l_ATTRIBUTE11 IN VARCHAR2
94 , l_ATTRIBUTE12 IN VARCHAR2
95 , l_ATTRIBUTE13 IN VARCHAR2
96 , l_ATTRIBUTE14 IN VARCHAR2
97 , l_ATTRIBUTE15 IN VARCHAR2
98 , l_CONTEXT IN VARCHAR2
99 );
100
101 --Procedure
102 -- Update_Allocation_Set
103 -- Purpose
104 -- Update row in GL_AUTO_ALLOC_SET Table
105 -- Example
106 -- gl_auto_alloc_set_pkg.Update_Allocation_Set
107 -- Notes
108
109 Procedure Update_Allocation_Set(
110 l_Row_Id IN VARCHAR2
111 , l_ALLOCATION_SET_NAME IN VARCHAR2
112 , l_LAST_UPDATE_DATE IN DATE
113 , l_LAST_UPDATED_BY IN NUMBER
114 , l_LAST_UPDATE_LOGIN IN NUMBER
115 , l_DESCRIPTION IN VARCHAR2
116 , l_OWNER IN VARCHAR2
117 , l_SECURITY_FLAG IN VARCHAR2
118 , l_ATTRIBUTE1 IN VARCHAR2
119 , l_ATTRIBUTE2 IN VARCHAR2
120 , l_ATTRIBUTE3 IN VARCHAR2
121 , l_ATTRIBUTE4 IN VARCHAR2
122 , l_ATTRIBUTE5 IN VARCHAR2
123 , l_ATTRIBUTE6 IN VARCHAR2
124 , l_ATTRIBUTE7 IN VARCHAR2
125 , l_ATTRIBUTE8 IN VARCHAR2
126 , l_ATTRIBUTE9 IN VARCHAR2
127 , l_ATTRIBUTE10 IN VARCHAR2
128 , l_ATTRIBUTE11 IN VARCHAR2
129 , l_ATTRIBUTE12 IN VARCHAR2
130 , l_ATTRIBUTE13 IN VARCHAR2
131 , l_ATTRIBUTE14 IN VARCHAR2
132 , l_ATTRIBUTE15 IN VARCHAR2
133 , l_CONTEXT IN VARCHAR2
134 );
135
136 --Procedure
137 -- Delete_Allocation_Set
138 -- Purpose
139 -- delete row in GL_AUTO_ALLOC_SET Table
140 -- Example
141 -- gl_auto_alloc_set_pkg.Delete_Allocation_Set
142 -- Notes
143 Procedure Delete_Allocation_Set(
144 l_allocation_set_id IN NUMBER) ;
145
146
147 -- Procedure
148 -- Get_Set_Content
149 -- Purpose
150 -- Get summary level batch type and balance type info
151 -- Access
152 -- Called from the Parameters form
153 --
154
155 PROCEDURE Get_Set_Content(
156 X_Allocation_Set_Id NUMBER,
157 X_Contain_Actual IN OUT NOCOPY BOOLEAN,
158 X_Contain_Budget IN OUT NOCOPY BOOLEAN,
159 X_Contain_Encumbrance IN OUT NOCOPY BOOLEAN,
160 X_Contain_Recurring IN OUT NOCOPY BOOLEAN,
161 X_Contain_Project IN OUT NOCOPY BOOLEAN,
162 X_Batch_Count IN OUT NOCOPY NUMBER
163 );
164
165
166 -- Procedure
167 -- Get_SetHistory_Content
168 -- Purpose
169 -- To find out whether project is part of auto allocation set
170 -- Access
171 -- Called from the ViewAutoAllocation form
172 --
173 PROCEDURE Get_SetHistory_Content(
174 X_Request_id IN NUMBER,
175 X_Contain_Actual IN OUT NOCOPY BOOLEAN,
176 X_Contain_Budget IN OUT NOCOPY BOOLEAN,
177 X_Contain_Encumbrance IN OUT NOCOPY BOOLEAN,
178 X_Contain_Recurring IN OUT NOCOPY BOOLEAN,
179 X_Contain_Project IN OUT NOCOPY BOOLEAN,
180 X_Batch_Count IN OUT NOCOPY NUMBER
181 );
182
183 -- Function
184 -- Set_Random_Ledger_Id
185 -- Purpose
186 -- To get the random ledger id of the AutoAllocation set,
187 -- MassBudget batch, Recurring Batch, or Budget Formula.
188 -- Access
189 -- Called from the Generate AutoAllocation form
190 -- Example
191 -- lgr_id := gl_auto_alloc_set_random_ledger_id('RECUR',123);
192 -- Notes
193 --
194 --
195
196 FUNCTION Set_Random_Ledger_Id(
197 X_Mode IN VARCHAR2,
198 X_Batch_Id IN NUMBER,
199 X_Ledger_Id IN NUMBER) RETURN NUMBER;
200
201
202
203 -- Procedure
204 -- Get_Alloc_Set_Name
205 -- Purpose
206 -- To find out the allocation set name or batch name
207 -- Access
208 -- Called from the Generate AutoAllocation form
209 --
210 FUNCTION Get_Alloc_Set_Name(
211 X_Mode IN VARCHAR,
212 X_Alloc_Set_Id IN NUMBER) RETURN VARCHAR;
213
214 END gl_auto_alloc_set_pkg;