[Home] [Help]
PACKAGE: APPS.BOM_SUB_RESOURCES_PKG
Source
1 PACKAGE BOM_SUB_RESOURCES_PKG as
2 /* $Header: BOMSRESS.pls 120.0 2005/05/25 05:32:16 appldev noship $ */
3 PROCEDURE Insert_Row(
4 x_OPERATION_SEQUENCE_ID NUMBER,
5 x_SUBSTITUTE_GROUP_NUM NUMBER,
6 x_RESOURCE_ID NUMBER,
7 x_SCHEDULE_SEQ_NUM NUMBER,
8 x_REPLACEMENT_GROUP_NUM NUMBER,
9 x_ACTIVITY_ID NUMBER,
10 x_STANDARD_RATE_FLAG NUMBER,
11 x_ASSIGNED_UNITS NUMBER,
12 x_USAGE_RATE_OR_AMOUNT NUMBER,
13 x_USAGE_RATE_OR_AMOUNT_INVERSE NUMBER,
14 x_BASIS_TYPE NUMBER,
15 x_SCHEDULE_FLAG NUMBER,
16 x_LAST_UPDATE_DATE DATE,
17 x_LAST_UPDATED_BY NUMBER,
18 x_CREATION_DATE DATE,
19 x_CREATED_BY NUMBER,
20 x_LAST_UPDATE_LOGIN NUMBER,
21 x_RESOURCE_OFFSET_PERCENT NUMBER,
22 x_AUTOCHARGE_TYPE NUMBER,
23 x_PRINCIPLE_FLAG NUMBER,
24 x_ATTRIBUTE_CATEGORY VARCHAR2,
25 x_ATTRIBUTE1 VARCHAR2,
26 x_ATTRIBUTE2 VARCHAR2,
27 x_ATTRIBUTE3 VARCHAR2,
28 x_ATTRIBUTE4 VARCHAR2,
29 x_ATTRIBUTE5 VARCHAR2,
30 x_ATTRIBUTE6 VARCHAR2,
31 x_ATTRIBUTE7 VARCHAR2,
32 x_ATTRIBUTE8 VARCHAR2,
33 x_ATTRIBUTE9 VARCHAR2,
34 x_ATTRIBUTE10 VARCHAR2,
35 x_ATTRIBUTE11 VARCHAR2,
36 x_ATTRIBUTE12 VARCHAR2,
37 x_ATTRIBUTE13 VARCHAR2,
38 x_ATTRIBUTE14 VARCHAR2,
39 x_ATTRIBUTE15 VARCHAR2);
40
41 PROCEDURE Insert_Row(
42 x_OPERATION_SEQUENCE_ID NUMBER,
43 x_SUBSTITUTE_GROUP_NUM NUMBER,
44 x_RESOURCE_ID NUMBER,
45 x_SCHEDULE_SEQ_NUM NUMBER,
46 x_REPLACEMENT_GROUP_NUM NUMBER,
47 x_ACTIVITY_ID NUMBER,
48 x_STANDARD_RATE_FLAG NUMBER,
49 x_ASSIGNED_UNITS NUMBER,
50 x_USAGE_RATE_OR_AMOUNT NUMBER,
51 x_USAGE_RATE_OR_AMOUNT_INVERSE NUMBER,
52 x_BASIS_TYPE NUMBER,
53 x_SCHEDULE_FLAG NUMBER,
54 x_LAST_UPDATE_DATE DATE,
55 x_LAST_UPDATED_BY NUMBER,
56 x_CREATION_DATE DATE,
57 x_CREATED_BY NUMBER,
58 x_LAST_UPDATE_LOGIN NUMBER,
59 x_RESOURCE_OFFSET_PERCENT NUMBER,
60 x_AUTOCHARGE_TYPE NUMBER,
61 x_PRINCIPLE_FLAG NUMBER,
62 x_ATTRIBUTE_CATEGORY VARCHAR2,
63 x_ATTRIBUTE1 VARCHAR2,
64 x_ATTRIBUTE2 VARCHAR2,
65 x_ATTRIBUTE3 VARCHAR2,
66 x_ATTRIBUTE4 VARCHAR2,
67 x_ATTRIBUTE5 VARCHAR2,
68 x_ATTRIBUTE6 VARCHAR2,
69 x_ATTRIBUTE7 VARCHAR2,
70 x_ATTRIBUTE8 VARCHAR2,
71 x_ATTRIBUTE9 VARCHAR2,
72 x_ATTRIBUTE10 VARCHAR2,
73 x_ATTRIBUTE11 VARCHAR2,
74 x_ATTRIBUTE12 VARCHAR2,
75 x_ATTRIBUTE13 VARCHAR2,
76 x_ATTRIBUTE14 VARCHAR2,
77 x_ATTRIBUTE15 VARCHAR2,
78 x_SETUP_ID NUMBER);
79
80
81 PROCEDURE Lock_Row( x_ROW_ID VARCHAR2,
82 x_OPERATION_SEQUENCE_ID NUMBER,
83 x_SUBSTITUTE_GROUP_NUM NUMBER,
84 x_RESOURCE_ID NUMBER,
85 x_SCHEDULE_SEQ_NUM NUMBER,
86 x_REPLACEMENT_GROUP_NUM NUMBER,
87 x_ACTIVITY_ID NUMBER,
88 x_STANDARD_RATE_FLAG NUMBER,
89 x_ASSIGNED_UNITS NUMBER,
90 x_USAGE_RATE_OR_AMOUNT NUMBER,
91 x_USAGE_RATE_OR_AMOUNT_INVERSE NUMBER,
92 x_BASIS_TYPE NUMBER,
93 x_SCHEDULE_FLAG NUMBER,
94 x_RESOURCE_OFFSET_PERCENT NUMBER,
95 x_AUTOCHARGE_TYPE NUMBER,
96 x_PRINCIPLE_FLAG NUMBER,
97 x_ATTRIBUTE_CATEGORY VARCHAR2,
98 x_ATTRIBUTE1 VARCHAR2,
99 x_ATTRIBUTE2 VARCHAR2,
100 x_ATTRIBUTE3 VARCHAR2,
101 x_ATTRIBUTE4 VARCHAR2,
102 x_ATTRIBUTE5 VARCHAR2,
103 x_ATTRIBUTE6 VARCHAR2,
104 x_ATTRIBUTE7 VARCHAR2,
105 x_ATTRIBUTE8 VARCHAR2,
106 x_ATTRIBUTE9 VARCHAR2,
107 x_ATTRIBUTE10 VARCHAR2,
108 x_ATTRIBUTE11 VARCHAR2,
109 x_ATTRIBUTE12 VARCHAR2,
110 x_ATTRIBUTE13 VARCHAR2,
111 x_ATTRIBUTE14 VARCHAR2,
112 x_ATTRIBUTE15 VARCHAR2);
113
114 PROCEDURE Lock_Row( x_ROW_ID VARCHAR2,
115 x_OPERATION_SEQUENCE_ID NUMBER,
116 x_SUBSTITUTE_GROUP_NUM NUMBER,
117 x_RESOURCE_ID NUMBER,
118 x_SCHEDULE_SEQ_NUM NUMBER,
119 x_REPLACEMENT_GROUP_NUM NUMBER,
120 x_ACTIVITY_ID NUMBER,
121 x_STANDARD_RATE_FLAG NUMBER,
122 x_ASSIGNED_UNITS NUMBER,
123 x_USAGE_RATE_OR_AMOUNT NUMBER,
124 x_USAGE_RATE_OR_AMOUNT_INVERSE NUMBER,
125 x_BASIS_TYPE NUMBER,
126 x_SCHEDULE_FLAG NUMBER,
127 x_RESOURCE_OFFSET_PERCENT NUMBER,
128 x_AUTOCHARGE_TYPE NUMBER,
129 x_PRINCIPLE_FLAG NUMBER,
130 x_ATTRIBUTE_CATEGORY VARCHAR2,
131 x_ATTRIBUTE1 VARCHAR2,
132 x_ATTRIBUTE2 VARCHAR2,
133 x_ATTRIBUTE3 VARCHAR2,
134 x_ATTRIBUTE4 VARCHAR2,
135 x_ATTRIBUTE5 VARCHAR2,
136 x_ATTRIBUTE6 VARCHAR2,
137 x_ATTRIBUTE7 VARCHAR2,
138 x_ATTRIBUTE8 VARCHAR2,
139 x_ATTRIBUTE9 VARCHAR2,
140 x_ATTRIBUTE10 VARCHAR2,
141 x_ATTRIBUTE11 VARCHAR2,
142 x_ATTRIBUTE12 VARCHAR2,
143 x_ATTRIBUTE13 VARCHAR2,
144 x_ATTRIBUTE14 VARCHAR2,
145 x_ATTRIBUTE15 VARCHAR2,
146 x_SETUP_ID NUMBER);
147
148 PROCEDURE Update_Row(x_ROW_ID VARCHAR2,
149 x_OPERATION_SEQUENCE_ID NUMBER,
150 x_SUBSTITUTE_GROUP_NUM NUMBER,
151 x_RESOURCE_ID NUMBER,
152 x_SCHEDULE_SEQ_NUM NUMBER,
153 x_REPLACEMENT_GROUP_NUM NUMBER,
154 x_ACTIVITY_ID NUMBER,
155 x_STANDARD_RATE_FLAG NUMBER,
156 x_ASSIGNED_UNITS NUMBER,
157 x_USAGE_RATE_OR_AMOUNT NUMBER,
158 x_USAGE_RATE_OR_AMOUNT_INVERSE NUMBER,
159 x_BASIS_TYPE NUMBER,
160 x_SCHEDULE_FLAG NUMBER,
161 x_LAST_UPDATE_DATE DATE,
162 x_LAST_UPDATED_BY NUMBER,
163 x_CREATION_DATE DATE,
164 x_CREATED_BY NUMBER,
165 x_LAST_UPDATE_LOGIN NUMBER,
166 x_RESOURCE_OFFSET_PERCENT NUMBER,
167 x_AUTOCHARGE_TYPE NUMBER,
168 x_PRINCIPLE_FLAG NUMBER,
169 x_ATTRIBUTE_CATEGORY VARCHAR2,
170 x_ATTRIBUTE1 VARCHAR2,
171 x_ATTRIBUTE2 VARCHAR2,
172 x_ATTRIBUTE3 VARCHAR2,
173 x_ATTRIBUTE4 VARCHAR2,
174 x_ATTRIBUTE5 VARCHAR2,
175 x_ATTRIBUTE6 VARCHAR2,
176 x_ATTRIBUTE7 VARCHAR2,
177 x_ATTRIBUTE8 VARCHAR2,
178 x_ATTRIBUTE9 VARCHAR2,
179 x_ATTRIBUTE10 VARCHAR2,
180 x_ATTRIBUTE11 VARCHAR2,
181 x_ATTRIBUTE12 VARCHAR2,
182 x_ATTRIBUTE13 VARCHAR2,
183 x_ATTRIBUTE14 VARCHAR2,
184 x_ATTRIBUTE15 VARCHAR2);
185
186 PROCEDURE Update_Row(x_ROW_ID VARCHAR2,
187 x_OPERATION_SEQUENCE_ID NUMBER,
188 x_SUBSTITUTE_GROUP_NUM NUMBER,
189 x_RESOURCE_ID NUMBER,
190 x_SCHEDULE_SEQ_NUM NUMBER,
191 x_REPLACEMENT_GROUP_NUM NUMBER,
192 x_ACTIVITY_ID NUMBER,
193 x_STANDARD_RATE_FLAG NUMBER,
194 x_ASSIGNED_UNITS NUMBER,
195 x_USAGE_RATE_OR_AMOUNT NUMBER,
196 x_USAGE_RATE_OR_AMOUNT_INVERSE NUMBER,
197 x_BASIS_TYPE NUMBER,
198 x_SCHEDULE_FLAG NUMBER,
199 x_LAST_UPDATE_DATE DATE,
200 x_LAST_UPDATED_BY NUMBER,
201 x_CREATION_DATE DATE,
202 x_CREATED_BY NUMBER,
203 x_LAST_UPDATE_LOGIN NUMBER,
204 x_RESOURCE_OFFSET_PERCENT NUMBER,
205 x_AUTOCHARGE_TYPE NUMBER,
206 x_PRINCIPLE_FLAG NUMBER,
207 x_ATTRIBUTE_CATEGORY VARCHAR2,
208 x_ATTRIBUTE1 VARCHAR2,
209 x_ATTRIBUTE2 VARCHAR2,
210 x_ATTRIBUTE3 VARCHAR2,
211 x_ATTRIBUTE4 VARCHAR2,
212 x_ATTRIBUTE5 VARCHAR2,
213 x_ATTRIBUTE6 VARCHAR2,
214 x_ATTRIBUTE7 VARCHAR2,
215 x_ATTRIBUTE8 VARCHAR2,
216 x_ATTRIBUTE9 VARCHAR2,
217 x_ATTRIBUTE10 VARCHAR2,
218 x_ATTRIBUTE11 VARCHAR2,
219 x_ATTRIBUTE12 VARCHAR2,
220 x_ATTRIBUTE13 VARCHAR2,
221 x_ATTRIBUTE14 VARCHAR2,
222 x_ATTRIBUTE15 VARCHAR2,
223 x_SETUP_ID NUMBER);
224
225
226
227 PROCEDURE Delete_Row(X_Rowid VARCHAR2);
228
229 PROCEDURE CHECK_UNIQUE_LINK(X_ROWID VARCHAR2,
230 X_FROM_OP_SEQ_ID NUMBER,
231 X_TO_OP_SEQ_ID NUMBER);
232
233 /*=====================================================================+
234 | PROCEDURE
235 | Validate_Schedule_Flag
236 |
237 | PURPOSE
238 | Simultaneous Resources must be scheduled by
239 | nvl(schedule_seq_num, resource_seq_num).
240 | Call this procedure after all changes are inserted in the
241 | the database to check if these rules are violated.
242 | Added this Procedure for BUG 3950992
243 | ARGUMENTS
244 | IN
245 | p_routing_sequence_id
246 | OUT
247 | x_return_status
248 | x_msg_data: returns the error message
249 | x_operation_seq_num: returns the op seq at which the error
250 | occurred
251 |
252 +=====================================================================*/
253 PROCEDURE Validate_Schedule_Flag(p_routing_sequence_id NUMBER, --BUG 3950992
254 x_return_status OUT NOCOPY VARCHAR2,
255 x_msg_data OUT NOCOPY VARCHAR2,
256 x_operation_seq_num OUT NOCOPY NUMBER);
257
258 END BOM_SUB_RESOURCES_PKG;