1 PACKAGE BOM_RESOURCES_PKG AUTHID CURRENT_USER as
2 /* $Header: bomporss.pls 120.1.12020000.2 2012/07/05 09:43:30 ntungare ship $ */
3
4 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
5 X_Resource_Id IN OUT NOCOPY NUMBER,
6 X_Resource_Code VARCHAR2,
7 X_Organization_Id NUMBER,
8 X_Last_Update_Date DATE,
9 X_Last_Updated_By NUMBER,
10 X_Creation_Date DATE,
11 X_Created_By NUMBER,
12 X_Last_Update_Login NUMBER,
13 X_Description VARCHAR2,
14 X_Disable_Date DATE,
15 X_Cost_Element_Id NUMBER,
16 X_Purchase_Item_Id NUMBER,
17 X_Cost_Code_Type NUMBER,
18 X_Functional_Currency_Flag NUMBER,
19 X_Unit_Of_Measure VARCHAR2,
20 X_Default_Activity_Id NUMBER,
21 X_Resource_Type NUMBER,
22 X_Autocharge_Type NUMBER,
23 X_Standard_Rate_Flag NUMBER,
24 X_Default_Basis_Type NUMBER,
25 X_Absorption_Account NUMBER,
26 X_Allow_Costs_Flag NUMBER,
27 X_Rate_Variance_Account NUMBER,
28 X_Expenditure_Type VARCHAR2,
29 X_Attribute_Category VARCHAR2,
30 X_Attribute1 VARCHAR2,
31 X_Attribute2 VARCHAR2,
32 X_Attribute3 VARCHAR2,
33 X_Attribute4 VARCHAR2,
34 X_Attribute5 VARCHAR2,
35 X_Attribute6 VARCHAR2,
36 X_Attribute7 VARCHAR2,
37 X_Attribute8 VARCHAR2,
38 X_Attribute9 VARCHAR2,
39 X_Attribute10 VARCHAR2,
40 X_Attribute11 VARCHAR2,
41 X_Attribute12 VARCHAR2,
42 X_Attribute13 VARCHAR2,
43 X_Attribute14 VARCHAR2,
44 X_Attribute15 VARCHAR2,
45 X_REQUEST_ID NUMBER DEFAULT NULL,
46 X_PROGRAM_APPLICATION_ID NUMBER DEFAULT NULL,
47 X_PROGRAM_ID NUMBER DEFAULT NULL,
48 X_PROGRAM_UPDATE_DATE DATE DEFAULT NULL,
49 X_BATCHABLE NUMBER ,
50 X_MIN_BATCH_CAPACITY NUMBER ,
51 X_MAX_BATCH_CAPACITY NUMBER ,
52 X_BATCH_CAPACITY_UOM VARCHAR2 ,
53 X_BATCH_WINDOW NUMBER ,
54 X_BATCH_WINDOW_UOM VARCHAR2,
55 X_COMPETENCE_ID NUMBER DEFAULT NULL,
56 X_RATING_LEVEL_ID NUMBER DEFAULT NULL,
57 X_QUALIFICATION_TYPE_ID NUMBER DEFAULT NULL,
58 X_BILLABLE_ITEM_ID NUMBER DEFAULT NULL,
59 X_SUPPLY_SUBINVENTORY VARCHAR2,
60 X_SUPPLY_LOCATOR_ID NUMBER DEFAULT NULL,
61 X_BATCHING_PENALTY NUMBER DEFAULT NULL --APS Enhancement for Routings
62 );
63
64 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
65 X_Resource_Id IN OUT NOCOPY NUMBER,
66 X_Resource_Code VARCHAR2,
67 X_Organization_Id NUMBER,
68 X_Last_Update_Date DATE,
69 X_Last_Updated_By NUMBER,
70 X_Creation_Date DATE,
71 X_Created_By NUMBER,
72 X_Last_Update_Login NUMBER,
73 X_Description VARCHAR2,
74 X_Disable_Date DATE,
75 X_Cost_Element_Id NUMBER,
76 X_Purchase_Item_Id NUMBER,
77 X_Cost_Code_Type NUMBER,
78 X_Functional_Currency_Flag NUMBER,
79 X_Unit_Of_Measure VARCHAR2,
80 X_Default_Activity_Id NUMBER,
81 X_Resource_Type NUMBER,
82 X_Autocharge_Type NUMBER,
83 X_Standard_Rate_Flag NUMBER,
84 X_Default_Basis_Type NUMBER,
85 X_Absorption_Account NUMBER,
86 X_Allow_Costs_Flag NUMBER,
87 X_Rate_Variance_Account NUMBER,
88 X_Expenditure_Type VARCHAR2,
89 X_Attribute_Category VARCHAR2,
90 X_Attribute1 VARCHAR2,
91 X_Attribute2 VARCHAR2,
92 X_Attribute3 VARCHAR2,
93 X_Attribute4 VARCHAR2,
94 X_Attribute5 VARCHAR2,
95 X_Attribute6 VARCHAR2,
96 X_Attribute7 VARCHAR2,
97 X_Attribute8 VARCHAR2,
98 X_Attribute9 VARCHAR2,
99 X_Attribute10 VARCHAR2,
100 X_Attribute11 VARCHAR2,
101 X_Attribute12 VARCHAR2,
102 X_Attribute13 VARCHAR2,
103 X_Attribute14 VARCHAR2,
104 X_Attribute15 VARCHAR2,
105 X_REQUEST_ID NUMBER DEFAULT NULL,
106 X_PROGRAM_APPLICATION_ID NUMBER DEFAULT NULL,
107 X_PROGRAM_ID NUMBER DEFAULT NULL,
108 X_PROGRAM_UPDATE_DATE DATE DEFAULT NULL
109 );
110
111 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
112 X_Resource_Id NUMBER,
113 X_Resource_Code VARCHAR2,
114 X_Organization_Id NUMBER,
115 X_Description VARCHAR2,
116 X_Disable_Date DATE,
117 X_Cost_Element_Id NUMBER,
118 X_Purchase_Item_Id NUMBER,
119 X_Cost_Code_Type NUMBER,
120 X_Functional_Currency_Flag NUMBER,
121 X_Unit_Of_Measure VARCHAR2,
122 X_Default_Activity_Id NUMBER,
123 X_Resource_Type NUMBER,
124 X_Autocharge_Type NUMBER,
125 X_Standard_Rate_Flag NUMBER,
126 X_Default_Basis_Type NUMBER,
127 X_Absorption_Account NUMBER,
128 X_Allow_Costs_Flag NUMBER,
129 X_Rate_Variance_Account NUMBER,
130 X_Expenditure_Type VARCHAR2,
131 X_Attribute_Category VARCHAR2,
132 X_Attribute1 VARCHAR2,
133 X_Attribute2 VARCHAR2,
134 X_Attribute3 VARCHAR2,
135 X_Attribute4 VARCHAR2,
136 X_Attribute5 VARCHAR2,
137 X_Attribute6 VARCHAR2,
138 X_Attribute7 VARCHAR2,
139 X_Attribute8 VARCHAR2,
140 X_Attribute9 VARCHAR2,
141 X_Attribute10 VARCHAR2,
142 X_Attribute11 VARCHAR2,
143 X_Attribute12 VARCHAR2,
144 X_Attribute13 VARCHAR2,
145 X_Attribute14 VARCHAR2,
146 X_Attribute15 VARCHAR2,
147 X_REQUEST_ID NUMBER DEFAULT NULL,
148 X_PROGRAM_APPLICATION_ID NUMBER DEFAULT NULL,
149 X_PROGRAM_ID NUMBER DEFAULT NULL,
150 X_PROGRAM_UPDATE_DATE DATE DEFAULT NULL,
151 X_BATCHABLE NUMBER ,
152 X_MIN_BATCH_CAPACITY NUMBER ,
153 X_MAX_BATCH_CAPACITY NUMBER ,
154 X_BATCH_CAPACITY_UOM VARCHAR2 ,
155 X_BATCH_WINDOW NUMBER ,
156 X_BATCH_WINDOW_UOM VARCHAR2,
157 X_COMPETENCE_ID NUMBER DEFAULT NULL,
158 X_RATING_LEVEL_ID NUMBER DEFAULT NULL,
159 X_QUALIFICATION_TYPE_ID NUMBER DEFAULT NULL,
160 X_BILLABLE_ITEM_ID NUMBER DEFAULT NULL,
161 X_SUPPLY_SUBINVENTORY VARCHAR2,
162 X_SUPPLY_LOCATOR_ID NUMBER DEFAULT NULL,
163 X_BATCHING_PENALTY NUMBER DEFAULT NULL --APS Enhancement for Routings
164 );
165
166 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
167 X_Resource_Id NUMBER,
168 X_Resource_Code VARCHAR2,
169 X_Organization_Id NUMBER,
170 X_Description VARCHAR2,
171 X_Disable_Date DATE,
172 X_Cost_Element_Id NUMBER,
173 X_Purchase_Item_Id NUMBER,
174 X_Cost_Code_Type NUMBER,
175 X_Functional_Currency_Flag NUMBER,
176 X_Unit_Of_Measure VARCHAR2,
177 X_Default_Activity_Id NUMBER,
178 X_Resource_Type NUMBER,
179 X_Autocharge_Type NUMBER,
180 X_Standard_Rate_Flag NUMBER,
181 X_Default_Basis_Type NUMBER,
182 X_Absorption_Account NUMBER,
183 X_Allow_Costs_Flag NUMBER,
184 X_Rate_Variance_Account NUMBER,
185 X_Expenditure_Type VARCHAR2,
186 X_Attribute_Category VARCHAR2,
187 X_Attribute1 VARCHAR2,
188 X_Attribute2 VARCHAR2,
189 X_Attribute3 VARCHAR2,
190 X_Attribute4 VARCHAR2,
191 X_Attribute5 VARCHAR2,
192 X_Attribute6 VARCHAR2,
193 X_Attribute7 VARCHAR2,
194 X_Attribute8 VARCHAR2,
195 X_Attribute9 VARCHAR2,
196 X_Attribute10 VARCHAR2,
197 X_Attribute11 VARCHAR2,
198 X_Attribute12 VARCHAR2,
199 X_Attribute13 VARCHAR2,
200 X_Attribute14 VARCHAR2,
201 X_Attribute15 VARCHAR2,
202 X_REQUEST_ID NUMBER DEFAULT NULL,
203 X_PROGRAM_APPLICATION_ID NUMBER DEFAULT NULL,
204 X_PROGRAM_ID NUMBER DEFAULT NULL,
205 X_PROGRAM_UPDATE_DATE DATE DEFAULT NULL
206 );
207
208 PROCEDURE Update_Row(X_Rowid VARCHAR2,
209 X_Resource_Id NUMBER,
210 X_Resource_Code VARCHAR2,
211 X_Organization_Id NUMBER,
212 X_Last_Update_Date DATE,
213 X_Last_Updated_By NUMBER,
214 X_Last_Update_Login NUMBER,
215 X_Description VARCHAR2,
216 X_Disable_Date DATE,
217 X_Cost_Element_Id NUMBER,
218 X_Purchase_Item_Id NUMBER,
219 X_Cost_Code_Type NUMBER,
220 X_Functional_Currency_Flag NUMBER,
221 X_Unit_Of_Measure VARCHAR2,
222 X_Default_Activity_Id NUMBER,
223 X_Resource_Type NUMBER,
224 X_Autocharge_Type NUMBER,
225 X_Standard_Rate_Flag NUMBER,
226 X_Default_Basis_Type NUMBER,
227 X_Absorption_Account NUMBER,
228 X_Allow_Costs_Flag NUMBER,
229 X_Rate_Variance_Account NUMBER,
230 X_Expenditure_Type VARCHAR2,
231 X_Attribute_Category VARCHAR2,
232 X_Attribute1 VARCHAR2,
233 X_Attribute2 VARCHAR2,
234 X_Attribute3 VARCHAR2,
238 X_Attribute7 VARCHAR2,
235 X_Attribute4 VARCHAR2,
236 X_Attribute5 VARCHAR2,
237 X_Attribute6 VARCHAR2,
239 X_Attribute8 VARCHAR2,
240 X_Attribute9 VARCHAR2,
241 X_Attribute10 VARCHAR2,
242 X_Attribute11 VARCHAR2,
243 X_Attribute12 VARCHAR2,
244 X_Attribute13 VARCHAR2,
245 X_Attribute14 VARCHAR2,
246 X_Attribute15 VARCHAR2,
247 X_REQUEST_ID NUMBER DEFAULT NULL,
248 X_PROGRAM_APPLICATION_ID NUMBER DEFAULT NULL,
249 X_PROGRAM_ID NUMBER DEFAULT NULL,
250 X_PROGRAM_UPDATE_DATE DATE DEFAULT NULL,
251 X_BATCHABLE NUMBER ,
252 X_MIN_BATCH_CAPACITY NUMBER ,
253 X_MAX_BATCH_CAPACITY NUMBER ,
254 X_BATCH_CAPACITY_UOM VARCHAR2 ,
255 X_BATCH_WINDOW NUMBER ,
256 X_BATCH_WINDOW_UOM VARCHAR2,
257 X_COMPETENCE_ID NUMBER DEFAULT NULL,
258 X_RATING_LEVEL_ID NUMBER DEFAULT NULL,
259 X_QUALIFICATION_TYPE_ID NUMBER DEFAULT NULL,
260 X_BILLABLE_ITEM_ID NUMBER DEFAULT NULL,
261 X_SUPPLY_SUBINVENTORY VARCHAR2,
262 X_SUPPLY_LOCATOR_ID NUMBER DEFAULT NULL,
263 X_BATCHING_PENALTY NUMBER DEFAULT NULL --APS Enhancement for Routings
264 );
265
266 PROCEDURE Update_Row(X_Rowid VARCHAR2,
267 X_Resource_Id NUMBER,
268 X_Resource_Code VARCHAR2,
269 X_Organization_Id NUMBER,
270 X_Last_Update_Date DATE,
271 X_Last_Updated_By NUMBER,
272 X_Last_Update_Login NUMBER,
273 X_Description VARCHAR2,
274 X_Disable_Date DATE,
275 X_Cost_Element_Id NUMBER,
276 X_Purchase_Item_Id NUMBER,
277 X_Cost_Code_Type NUMBER,
278 X_Functional_Currency_Flag NUMBER,
279 X_Unit_Of_Measure VARCHAR2,
280 X_Default_Activity_Id NUMBER,
281 X_Resource_Type NUMBER,
282 X_Autocharge_Type NUMBER,
283 X_Standard_Rate_Flag NUMBER,
284 X_Default_Basis_Type NUMBER,
285 X_Absorption_Account NUMBER,
286 X_Allow_Costs_Flag NUMBER,
287 X_Rate_Variance_Account NUMBER,
288 X_Expenditure_Type VARCHAR2,
289 X_Attribute_Category VARCHAR2,
290 X_Attribute1 VARCHAR2,
291 X_Attribute2 VARCHAR2,
292 X_Attribute3 VARCHAR2,
293 X_Attribute4 VARCHAR2,
294 X_Attribute5 VARCHAR2,
295 X_Attribute6 VARCHAR2,
296 X_Attribute7 VARCHAR2,
297 X_Attribute8 VARCHAR2,
298 X_Attribute9 VARCHAR2,
299 X_Attribute10 VARCHAR2,
300 X_Attribute11 VARCHAR2,
301 X_Attribute12 VARCHAR2,
302 X_Attribute13 VARCHAR2,
303 X_Attribute14 VARCHAR2,
304 X_Attribute15 VARCHAR2,
305 X_REQUEST_ID NUMBER DEFAULT NULL,
306 X_PROGRAM_APPLICATION_ID NUMBER DEFAULT NULL,
307 X_PROGRAM_ID NUMBER DEFAULT NULL,
308 X_PROGRAM_UPDATE_DATE DATE DEFAULT NULL
309 );
310 PROCEDURE Check_Unique(X_Rowid VARCHAR2,
311 X_Resource_Code VARCHAR2,
312 X_Organization_Id NUMBER,
313 X_unique_flag IN OUT NOCOPY NUMBER);
314
315 FUNCTION Get_UOM_From_GL_Sets_Of_Books(X_Organization_Id NUMBER) RETURN VARCHAR2;
316
317 FUNCTION Check_Valid_UOM(X_Unit_Of_Measure VARCHAR2) RETURN NUMBER;
318
319 END BOM_RESOURCES_PKG;
|
|
|