[Home] [Help]
PACKAGE: APPS.BOM_ROUTINGHEADER_PVT
Source
1 PACKAGE BOM_RoutingHeader_PVT AUTHID CURRENT_USER AS
2 -- $Header: BOMVRTGS.pls 120.3 2005/11/15 07:20:37 earumuga noship $
3 -- Start of comments
4 -- API name : AssignRouting
5 -- Type : Private.
6 -- Function : Populates IDs based on Flex values and codes.
7 -- Pre-reqs : None.
8 -- Parameters :
9 -- IN :
10 -- p_api_version NUMBER Required
11 -- p_init_msg_list VARCHAR2 Optional Default = FND_API.G_FALSE
12 -- p_commit VARCHAR2 Optional Default = FND_API.G_FALSE
13 -- p_validation_level NUMBER Optional
14 -- Default = FND_API.G_VALID_LEVEL_FULL
15 -- p_routing_rec ROUTING_REC_TYPE Default = G_MISS_ROUTING_REC
16 -- .
17 -- OUT :
18 -- x_return_status VARCHAR2(1)
19 -- x_msg_count NUMBER
20 -- x_msg_data VARCHAR2(2000)
21 -- x_routing_rec ROUTING_REC_TYPE
22 -- Version : Current version 1.0
23 -- previous version none
24 -- Initial version 1.0
25 --
26 -- Notes :
27 --
28 -- API name : ValidateRouting
29 -- Type : Private.
30 -- Function : Validates a row in BOM_OPERATIONAL_ROUTINGS
31 -- Pre-reqs : None.
32 -- Parameters :
33 -- IN :
34 -- p_api_version NUMBER Required
35 -- p_init_msg_list VARCHAR2 Optional Default = FND_API.G_FALSE
36 -- p_commit VARCHAR2 Optional Default = FND_API.G_FALSE
37 -- p_validation_level NUMBER Optional
38 -- Default = FND_API.G_VALID_LEVEL_FULL
39 -- p_routing_rec ROUTING_REC_TYPE Default = G_MISS_ROUTING_REC
40 --
41 -- OUT :
42 -- x_return_status VARCHAR2(1)
43 -- x_msg_count NUMBER
44 -- x_msg_data VARCHAR2(2000)
45 -- x_routing_rec ROUTING_REC_TYPE
46 -- Version : Current version 1.0
47 -- previous version none
48 -- Initial version 1.0
49 --
50 -- Notes : Full validation level includes AssignRouting
51 --
52 -- API name : CreateRouting
53 -- Type : Private.
54 -- Function : Inserts a row into BOM_OPERATIONAL_ROUTINGS
55 -- Pre-reqs : None.
56 -- Parameters :
57 -- IN :
58 -- p_api_version NUMBER Required
59 -- p_init_msg_list VARCHAR2 Optional Default = FND_API.G_FALSE
60 -- p_commit VARCHAR2 Optional Default = FND_API.G_FALSE
61 -- p_validation_level NUMBER Optional
62 -- Default = FND_API.G_VALID_LEVEL_FULL
63 -- p_routing_rec ROUTING_REC_TYPE Default = G_MISS_ROUTING_REC
64 --
65 -- OUT :
66 -- x_return_status VARCHAR2(1)
67 -- x_msg_count NUMBER
68 -- x_msg_data VARCHAR2(2000)
69 -- x_routing_rec ROUTING_REC_TYPE
70 -- Version : Current version 1.0
71 -- previous version none
72 -- Initial version 1.0
73 --
74 -- Notes : Full validation level includes AssignRouting and
75 -- ValidateRouting.
76 --
77 -- API name : UpdateRouting
78 -- Type : Private.
79 -- Function : Updates a row from BOM_OPERATIONAL_ROUTINGS
80 -- Pre-reqs : None.
81 -- Parameters :
82 -- IN :
83 -- p_api_version NUMBER Required
84 -- p_init_msg_list VARCHAR2 Optional Default = FND_API.G_FALSE
85 -- p_commit VARCHAR2 Optional Default = FND_API.G_FALSE
86 -- p_validation_level NUMBER Optional
87 -- Default = FND_API.G_VALID_LEVEL_FULL
88 -- p_routing_rec ROUTING_REC_TYPE Default = G_MISS_ROUTING_REC
89 -- .
90 -- OUT :
91 -- x_return_status VARCHAR2(1)
92 -- x_msg_count NUMBER
93 -- x_msg_data VARCHAR2(2000)
94 -- x_routing_rec ROUTING_REC_TYPE
95 --
96 -- Version : Current version 1.0
97 -- previous version none
98 -- Initial version 1.0
99 --
100 -- Notes : Full validation level includes AssignRouting and
101 -- ValidateRouting.
102 --
103 -- API name : DeleteRouting
104 -- Type : Private.
105 -- Function : Deletes a row from BOM_OPERATIONAL_ROUTINGS
106 -- Pre-reqs : None.
107 -- Parameters :
108 -- IN :
109 -- p_api_version NUMBER Required
110 -- p_init_msg_list VARCHAR2 Optional Default = FND_API.G_FALSE
111 -- p_commit VARCHAR2 Optional Default = FND_API.G_FALSE
112 -- p_validation_level NUMBER Optional
113 -- Default = FND_API.G_VALID_LEVEL_FULL
114 -- p_delete_group VARCHAR2
115 -- p_description VARCHAR2 Default = Null
116 -- p_routing_rec ROUTING_REC_TYPE Default = G_MISS_ROUTING_REC,
117 -- .
118 -- OUT :
119 -- x_return_status VARCHAR2(1)
120 -- x_msg_count NUMBER
121 -- x_msg_data VARCHAR2(2000)
122 -- x_routing_rec ROUTING_REC_TYPE
123 --
124 -- Version : Current version 1.0
125 -- previous version none
126 -- Initial version 1.0
127 --
128 -- Notes : Full validation level includes AssignRouting
129 --
130 -- End of comments
131 TYPE routing_rec_type is record(
132 routing_sequence_id NUMBER := FND_API.G_MISS_NUM,
133 assembly_item_id NUMBER := FND_API.G_MISS_NUM,
134 assembly_item_number VARCHAR2(81) := FND_API.G_MISS_CHAR,
135 organization_id NUMBER := FND_API.G_MISS_NUM,
136 organization_code VARCHAR2(3) := FND_API.G_MISS_CHAR,
137 alternate_routing_designator VARCHAR2(10) := FND_API.G_MISS_CHAR,
138 routing_type NUMBER := FND_API.G_MISS_NUM,
139 common_assembly_item_id NUMBER := FND_API.G_MISS_NUM,
140 common_item_number VARCHAR2(81) := FND_API.G_MISS_CHAR,
141 common_routing_sequence_id NUMBER := FND_API.G_MISS_NUM,
142 routing_comment VARCHAR2(240) := FND_API.G_MISS_CHAR,
143 completion_subinventory VARCHAR2(10) := FND_API.G_MISS_CHAR,
144 completion_locator_id NUMBER := FND_API.G_MISS_NUM,
145 location_name VARCHAR2(81) := FND_API.G_MISS_CHAR,
146 attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
147 attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
148 attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
149 attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
150 attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
151 attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
152 attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
153 attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
154 attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
155 attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
156 attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
157 attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
158 attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
159 attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
160 attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
161 attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
162 line_id NUMBER := FND_API.G_MISS_NUM,
163 line_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
164 mixed_model_map_flag NUMBER := FND_API.G_MISS_NUM,
165 priority NUMBER := FND_API.G_MISS_NUM,
166 cfm_routing_flag NUMBER := FND_API.G_MISS_NUM,
167 total_product_cycle_time NUMBER := FND_API.G_MISS_NUM,
168 ctp_flag NUMBER := FND_API.G_MISS_NUM,
169 -- Added as part of TTMO enh R12
170 pending_from_ecn VARCHAR2(10) := FND_API.G_MISS_CHAR
171 );
172
173 G_MISS_ROUTING_REC ROUTING_REC_TYPE;
174 G_VALID_LEVEL_NO_ASSIGN constant number := 5;
175
176 PROCEDURE AssignRouting
177 ( p_api_version IN NUMBER,
178 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
179 p_commit IN VARCHAR2 := FND_API.G_FALSE,
180 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
181 x_return_status IN OUT NOCOPY VARCHAR2,
182 x_msg_count IN OUT NOCOPY NUMBER,
183 x_msg_data IN OUT NOCOPY VARCHAR2,
184 p_routing_rec IN ROUTING_REC_TYPE := G_MISS_ROUTING_REC,
185 x_routing_rec IN OUT NOCOPY ROUTING_REC_TYPE
186 );
187 PROCEDURE ValidateRouting
188 ( p_api_version IN NUMBER,
189 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
190 p_commit IN VARCHAR2 := FND_API.G_FALSE,
191 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
192 x_return_status IN OUT NOCOPY VARCHAR2,
193 x_msg_count IN OUT NOCOPY NUMBER,
194 x_msg_data IN OUT NOCOPY VARCHAR2,
195 p_routing_rec IN ROUTING_REC_TYPE := G_MISS_ROUTING_REC,
196 x_routing_rec IN OUT NOCOPY ROUTING_REC_TYPE
197 );
198 PROCEDURE CreateRouting
199 ( p_api_version IN NUMBER,
200 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
201 p_commit IN VARCHAR2 := FND_API.G_FALSE,
202 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
203 x_return_status IN OUT NOCOPY VARCHAR2,
204 x_msg_count IN OUT NOCOPY NUMBER,
205 x_msg_data IN OUT NOCOPY VARCHAR2,
206 p_routing_rec IN ROUTING_REC_TYPE := G_MISS_ROUTING_REC,
207 x_routing_rec IN OUT NOCOPY ROUTING_REC_TYPE
208 );
209 PROCEDURE UpdateRouting
210 ( p_api_version IN NUMBER,
211 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
212 p_commit IN VARCHAR2 := FND_API.G_FALSE,
213 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
214 x_return_status IN OUT NOCOPY VARCHAR2,
215 x_msg_count IN OUT NOCOPY NUMBER,
216 x_msg_data IN OUT NOCOPY VARCHAR2,
217 p_routing_rec IN ROUTING_REC_TYPE := G_MISS_ROUTING_REC,
218 x_routing_rec IN OUT NOCOPY ROUTING_REC_TYPE
219 );
220 PROCEDURE DeleteRouting
221 ( p_api_version IN NUMBER,
222 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
223 p_commit IN VARCHAR2 := FND_API.G_FALSE,
224 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
225 x_return_status IN OUT NOCOPY VARCHAR2,
226 x_msg_count IN OUT NOCOPY NUMBER,
227 x_msg_data IN OUT NOCOPY VARCHAR2,
228 p_delete_group IN VARCHAR2,
229 p_description IN VARCHAR2 := null,
230 p_routing_rec IN ROUTING_REC_TYPE := G_MISS_ROUTING_REC,
231 x_routing_rec IN OUT NOCOPY ROUTING_REC_TYPE
232 );
233
234 -- Start of comments
235 -- API name : createrouting
236 -- Type : private
237 -- Pre-reqs : None
238 -- Function : Creates the routing header
239 -- Parameters :
240 -- IN : p_api_version IN NUMBER Required
241 -- Standard API Number
242 -- p_description IN VARCHAR2 Required
243 -- Description for the routing header
244 -- p_assembly_item_id IN NUMBER Required
245 -- Item Id for which the routing needs to be created
246 -- p_organization_id IN NUMBER Required
247 -- Organization in which the routing needs to be created
248 -- p_alt_rtg_desig IN VARCHAR2 Required
249 -- Routing alternate designator
250 -- p_routing_type IN NUMBER Required
251 -- Type of the routing
252 -- p_common_assembly_item_id IN NUMBER Required
253 -- Item from which this routing needs to create a reference
254 -- p_common_rtg_seq_id IN NUMBER Required
255 -- Routing sequence Id of the source routing from which the
256 -- reference needs to be created
257 -- p_routing_comment IN VARCHAR2 Optional
258 -- Comment for the routing
259 -- p_change_notice IN VARCHAR2 Optional
260 -- Change Order Name for which the routing is created
261 -- OUT : x_return_status OUT VARCHAR2
262 -- APIs return status
263 -- x_msg_count OUT NUMBER
264 -- Number of messages added to the stack
265 -- x_msg_data OUT VARCHAR2
266 -- Error Message Data
267 -- x_rtg_seq_id OUT NUMBER
268 -- Routing sequence id of the newly created routing
269 -- End of comments
270 PROCEDURE createrouting
271 (
272 p_api_version IN NUMBER,
273 x_return_status IN OUT NOCOPY VARCHAR2,
274 x_msg_count IN OUT NOCOPY NUMBER,
275 x_msg_data IN OUT NOCOPY VARCHAR2,
276 p_description IN VARCHAR2,
277 p_assembly_item_id IN NUMBER,
278 p_organization_id IN NUMBER,
279 p_alt_rtg_desig IN VARCHAR2,
280 p_routing_type IN NUMBER,
281 p_common_assembly_item_id IN NUMBER,
282 p_common_rtg_seq_id IN NUMBER,
283 p_routing_comment IN VARCHAR2,
284 p_copy_request_id IN NUMBER,
285 p_user_id IN NUMBER,
286 p_change_notice IN VARCHAR2,
287 x_rtg_seq_id IN OUT NOCOPY NUMBER
288 );
289
290 END BOM_RoutingHeader_PVT;