[Home] [Help]
PACKAGE: APPS.BOM_OPERATION_PVT
Source
1 PACKAGE BOM_Operation_Pvt AS
2 -- $Header: BOMVOPRS.pls 120.1 2005/06/21 03:04:16 appldev ship $
3 -- Start of comments
4 -- API name : AssignOperation
5 -- Type : Private.
6 -- Function : Populate Ids from values
7 -- Pre-reqs : None.
8 -- Parameters :
9 -- IN :
10 -- p_api_version NUMBER Required
11 -- p_init_msg_list VARCHAR2 Optional
12 -- Default = FND_API.G_FALSE
13 -- p_commit VARCHAR2 Optional
14 -- Default = FND_API.G_FALSE
15 -- p_validation_level NUMBER Optional
16 -- Default = FND_API.G_VALID_LEVEL_FULL
17 -- p_operation_rec OPERATION_REC_TYPE Optional
18 -- Default = G_MISS_OPERATION_REC
19 --
20 -- OUT :
21 -- x_return_status VARCHAR2(1)
22 -- x_msg_count NUMBER
23 -- x_msg_data VARCHAR2(2000)
24 -- x_operation_rec OPERATION_REC_TYPE
25 --
26 -- Version : Current version 1.0
27 -- Initial version 1.0
28 --
29 -- Notes :
30 --
31 -- API name : ValidateOperation
32 -- Type : Private.
33 -- Function : Validate Operation
34 -- Pre-reqs : None.
35 -- Parameters :
36 -- IN :
37 -- p_api_version NUMBER Required
38 -- p_init_msg_list VARCHAR2 Optional
39 -- Default = FND_API.G_FALSE
40 -- p_commit VARCHAR2 Optional
41 -- Default = FND_API.G_FALSE
42 -- p_validation_level NUMBER Optional
43 -- Default = FND_API.G_VALID_LEVEL_FULL
44 -- p_operation_rec OPERATION_REC_TYPE Optional
45 -- Default = G_MISS_OPERATION_REC
46 --
47 -- OUT :
48 -- x_return_status VARCHAR2(1)
49 -- x_msg_count NUMBER
50 -- x_msg_data VARCHAR2(2000)
51 -- x_operation_rec OPERATION_REC_TYPE
52 --
53 -- Version : Current version 1.0
54 -- Initial version 1.0
55 --
56 -- Notes : Full validation includes assign
57 --
58 -- API name : CreateOperation
59 -- Type : Private.
60 -- Function : Insert row into BOM_OPERATION_SEQUENCES
61 -- Pre-reqs : None.
62 -- Parameters :
63 -- IN :
64 -- p_api_version NUMBER Required
65 -- p_init_msg_list VARCHAR2 Optional
66 -- Default = FND_API.G_FALSE
67 -- p_commit VARCHAR2 Optional
68 -- Default = FND_API.G_FALSE
69 -- p_validation_level NUMBER Optional
70 -- Default = FND_API.G_VALID_LEVEL_FULL
71 -- p_operation_rec OPERATION_REC_TYPE Optional
72 -- Default = G_MISS_OPERATION_REC
73 --
74 -- OUT :
75 -- x_return_status VARCHAR2(1)
76 -- x_msg_count NUMBER
77 -- x_msg_data VARCHAR2(2000)
78 -- x_operation_rec OPERATION_REC_TYPE
79 --
80 -- Version : Current version 1.0
81 -- Initial version 1.0
82 --
83 -- Notes : Full validation includes assign and validate
84 --
85 -- API name : UpdateOperation
86 -- Type : Private.
87 -- Function : Update a row in BOM_OPERATION_SEQUENCES
88 -- Pre-reqs : None.
89 -- Parameters :
90 -- IN :
91 -- p_api_version NUMBER Required
92 -- p_init_msg_list VARCHAR2 Optional
93 -- Default = FND_API.G_FALSE
94 -- p_commit VARCHAR2 Optional
95 -- Default = FND_API.G_FALSE
96 -- p_validation_level NUMBER Optional
97 -- Default = FND_API.G_VALID_LEVEL_FULL
98 -- p_operation_rec OPERATION_REC_TYPE Optional
99 -- Default = G_MISS_OPERATION_REC
100 --
101 -- OUT :
102 -- x_return_status VARCHAR2(1)
103 -- x_msg_count NUMBER
104 -- x_msg_data VARCHAR2(2000)
105 -- x_operation_rec OPERATION_REC_TYPE
106 --
107 -- Version : Current version 1.0
108 -- Initial version 1.0
109 --
110 -- Notes : Full validation includes assign and validate
111 --
112 -- API name : DeleteOperation
113 -- Type : Private.
114 -- Function : Insert operation into a Delete Group
115 -- Pre-reqs : None.
116 -- Parameters :
117 -- IN :
118 -- p_api_version NUMBER Required
119 -- p_init_msg_list VARCHAR2 Optional
120 -- Default = FND_API.G_FALSE
121 -- p_commit VARCHAR2 Optional
122 -- Default = FND_API.G_FALSE
123 -- p_validation_level NUMBER Optional
124 -- Default = FND_API.G_VALID_LEVEL_FULL
125 -- p_delete_group VARCHAR2
126 -- p_description VARCHAR2 Default = Null
127 -- p_operation_rec OPERATION_REC_TYPE Optional
128 -- Default = G_MISS_OPERATION_REC
129 --
130 -- OUT :
131 -- x_return_status VARCHAR2(1)
132 -- x_msg_count NUMBER
133 -- x_msg_data VARCHAR2(2000)
134 -- x_operation_rec OPERATION_REC_TYPE
135 --
136 -- Version : Current version 1.0
137 -- Initial version 1.0
138 --
139 -- Notes : Full validation includes assign
140 --
141 -- End of comments
142 TYPE operation_rec_type is record(
143 operation_sequence_id number := Fnd_Api.G_Miss_Num,
144 routing_sequence_id number := Fnd_Api.G_Miss_Num,
145 assembly_item_id number := Fnd_Api.G_Miss_Num,
146 assembly_item_number varchar2(81) := Fnd_Api.G_Miss_Char,
147 organization_id number := Fnd_Api.G_Miss_Num,
148 organization_code varchar2(3) := Fnd_Api.G_Miss_Char,
149 alternate_routing_designator varchar2(10) := Fnd_Api.G_Miss_Char,
150 operation_seq_num number := Fnd_Api.G_Miss_Num,
151 new_operation_seq_num number := Fnd_Api.G_Miss_Num,
152 standard_operation_id number := Fnd_Api.G_Miss_Num,
153 operation_code varchar2(4) := Fnd_Api.G_Miss_Char,
154 department_id number := Fnd_Api.G_Miss_Num,
155 department_code varchar2(10) := Fnd_Api.G_Miss_Char,
156 operation_lead_time_percent number := Fnd_Api.G_Miss_Num,
157 minimum_transfer_quantity number := Fnd_Api.G_Miss_Num,
158 count_point_type number := Fnd_Api.G_Miss_Num,
159 operation_description varchar2(240) := Fnd_Api.G_Miss_Char,
160 effectivity_date date := Fnd_Api.G_Miss_Date,
161 new_effectivity_date date := Fnd_Api.G_Miss_Date,
162 disable_date date := Fnd_Api.G_Miss_Date,
163 backflush_flag number := Fnd_Api.G_Miss_Num,
164 option_dependent_flag number := Fnd_Api.G_Miss_Num,
165 attribute_category varchar2(30) := Fnd_Api.G_Miss_Char,
166 attribute1 varchar2(150) := Fnd_Api.G_Miss_Char,
167 attribute2 varchar2(150) := Fnd_Api.G_Miss_Char,
168 attribute3 varchar2(150) := Fnd_Api.G_Miss_Char,
169 attribute4 varchar2(150) := Fnd_Api.G_Miss_Char,
170 attribute5 varchar2(150) := Fnd_Api.G_Miss_Char,
171 attribute6 varchar2(150) := Fnd_Api.G_Miss_Char,
172 attribute7 varchar2(150) := Fnd_Api.G_Miss_Char,
173 attribute8 varchar2(150) := Fnd_Api.G_Miss_Char,
174 attribute9 varchar2(150) := Fnd_Api.G_Miss_Char,
175 attribute10 varchar2(150) := Fnd_Api.G_Miss_Char,
176 attribute11 varchar2(150) := Fnd_Api.G_Miss_Char,
177 attribute12 varchar2(150) := Fnd_Api.G_Miss_Char,
178 attribute13 varchar2(150) := Fnd_Api.G_Miss_Char,
179 attribute14 varchar2(150) := Fnd_Api.G_Miss_Char,
180 attribute15 varchar2(150) := Fnd_Api.G_Miss_Char,
181 operation_type number := Fnd_Api.G_Miss_Num,
182 reference_flag number := Fnd_Api.G_Miss_Num,
183 process_op_seq_id number := Fnd_Api.G_Miss_Num,
184 line_op_seq_id number := Fnd_Api.G_Miss_Num,
185 yield number := Fnd_Api.G_Miss_Num,
186 cumulative_yield number := Fnd_Api.G_Miss_Num,
187 reverse_cumulative_yield number := Fnd_Api.G_Miss_Num,
188 labor_time_calc number := Fnd_Api.G_Miss_Num,
189 machine_time_calc number := Fnd_Api.G_Miss_Num,
190 total_time_calc number := Fnd_Api.G_Miss_Num,
191 labor_time_user number := Fnd_Api.G_Miss_Num,
192 machine_time_user number := Fnd_Api.G_Miss_Num,
193 total_time_user number := Fnd_Api.G_Miss_Num,
194 net_planning_percent number := Fnd_Api.G_Miss_Num,
195 include_in_rollup number := Fnd_Api.G_Miss_Num,
196 operation_yield_enabled number := Fnd_Api.G_Miss_Num
197 );
198
199 G_MISS_OPERATION_REC operation_rec_type;
200 G_VALID_LEVEL_NO_ASSIGN constant number := 5;
201
202 PROCEDURE AssignOperation(
203 p_api_version IN NUMBER,
204 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
205 p_commit IN VARCHAR2 := FND_API.G_FALSE,
206 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
207 x_return_status IN OUT NOCOPY VARCHAR2,
208 x_msg_count IN OUT NOCOPY NUMBER,
209 x_msg_data IN OUT NOCOPY VARCHAR2,
210 p_operation_rec IN OPERATION_REC_TYPE := G_MISS_OPERATION_REC,
211 x_operation_rec IN OUT NOCOPY OPERATION_REC_TYPE
212 );
213
214 PROCEDURE ValidateOperation(
215 p_api_version IN NUMBER,
216 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
217 p_commit IN VARCHAR2 := FND_API.G_FALSE,
218 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
219 x_return_status IN OUT NOCOPY VARCHAR2,
220 x_msg_count IN OUT NOCOPY NUMBER,
221 x_msg_data IN OUT NOCOPY VARCHAR2,
222 p_operation_rec IN OPERATION_REC_TYPE := G_MISS_OPERATION_REC,
223 x_operation_rec IN OUT NOCOPY OPERATION_REC_TYPE
224 );
225
226 PROCEDURE CreateOperation(
227 p_api_version IN NUMBER,
228 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
229 p_commit IN VARCHAR2 := FND_API.G_FALSE,
230 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
231 x_return_status IN OUT NOCOPY VARCHAR2,
232 x_msg_count IN OUT NOCOPY NUMBER,
233 x_msg_data IN OUT NOCOPY VARCHAR2,
234 p_operation_rec IN OPERATION_REC_TYPE := G_MISS_OPERATION_REC,
235 x_operation_rec IN OUT NOCOPY OPERATION_REC_TYPE
236 );
237
238 PROCEDURE UpdateOperation(
239 p_api_version IN NUMBER,
240 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
241 p_commit IN VARCHAR2 := FND_API.G_FALSE,
242 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
243 x_return_status IN OUT NOCOPY VARCHAR2,
244 x_msg_count IN OUT NOCOPY NUMBER,
245 x_msg_data IN OUT NOCOPY VARCHAR2,
246 p_operation_rec IN OPERATION_REC_TYPE := G_MISS_OPERATION_REC,
247 x_operation_rec IN OUT NOCOPY OPERATION_REC_TYPE
248 );
249
250 PROCEDURE DeleteOperation(
251 p_api_version IN NUMBER,
252 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
253 p_commit IN VARCHAR2 := FND_API.G_FALSE,
254 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
255 x_return_status IN OUT NOCOPY VARCHAR2,
256 x_msg_count IN OUT NOCOPY NUMBER,
257 x_msg_data IN OUT NOCOPY VARCHAR2,
258 p_delete_group IN VARCHAR2,
259 p_description IN VARCHAR2 := Null,
260 p_operation_rec IN OPERATION_REC_TYPE := G_MISS_OPERATION_REC,
261 x_operation_rec IN OUT NOCOPY OPERATION_REC_TYPE
262 );
263
264 END BOM_Operation_Pvt;