1 PACKAGE EAM_PROCESS_WO_PVT AS
2 /* $Header: EAMVWOPS.pls 120.2 2006/07/07 08:36:00 cboppana noship $ */
3 /***************************************************************************
4 --
5 -- Copyright (c) 2002 Oracle Corporation, Redwood Shores, CA, USA
6 -- All rights reserved.
7 --
8 -- FILENAME
9 --
10 -- EAMVWOPS.pls
11 --
12 -- DESCRIPTION
13 --
14 -- Spec of package EAM_PROCESS_WO_PVT
15 --
16 -- NOTES
17 --
18 -- HISTORY
19 --
20 -- 12-JUN-2002 Kenichi Nagumo Initial Creation
21 ***************************************************************************/
22 G_OPR_SYNC CONSTANT NUMBER := 0;
23 G_OPR_CREATE CONSTANT NUMBER := 1;
24 G_OPR_UPDATE CONSTANT NUMBER := 2;
25 G_OPR_DELETE CONSTANT NUMBER := 3;
26 G_OPR_COMPLETE CONSTANT NUMBER := 4;
27 G_OPR_UNCOMPLETE CONSTANT NUMBER := 5;
28 G_RECORD_FOUND CONSTANT VARCHAR2(1) := 'S';
29 G_RECORD_NOT_FOUND CONSTANT VARCHAR2(1) := 'F';
30
31 Debug_File UTL_FILE.FILE_TYPE;
32
33
34 PROCEDURE RESOURCE_USAGES
35 ( p_validation_level IN NUMBER
36 , p_wip_entity_id IN NUMBER := NULL
37 , p_organization_id IN NUMBER := NULL
38 , p_operation_seq_num IN NUMBER := NULL
39 , p_resource_seq_num IN NUMBER := NULL
40 , p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type
41 , x_bottomup_scheduled IN OUT NOCOPY NUMBER
42 , x_eam_res_usage_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type
43 , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
44 , x_return_status OUT NOCOPY VARCHAR2
45 );
46
47
48 PROCEDURE SUB_RESOURCES
49 ( p_validation_level IN NUMBER
50 , p_wip_entity_id IN NUMBER := NULL
51 , p_organization_id IN NUMBER := NULL
52 , p_operation_seq_num IN NUMBER := NULL
53 , p_eam_sub_res_tbl IN EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type
54 , p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type
55 , x_bottomup_scheduled IN OUT NOCOPY NUMBER
56 , x_eam_sub_res_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type
57 , x_eam_res_usage_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type
58 , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
59 , x_return_status OUT NOCOPY VARCHAR2
60 );
61
62
63 PROCEDURE RESOURCE_INSTANCES
64 ( p_validation_level IN NUMBER
65 , p_wip_entity_id IN NUMBER := NULL
66 , p_organization_id IN NUMBER := NULL
67 , p_operation_seq_num IN NUMBER := NULL
68 , p_resource_seq_num IN NUMBER := NULL
69 , p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
70 , x_eam_res_inst_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
71 , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
72 , x_return_status OUT NOCOPY VARCHAR2
73 , x_schedule_wo IN OUT NOCOPY NUMBER
74 , x_bottomup_scheduled IN OUT NOCOPY NUMBER
75 );
76
77
78 PROCEDURE MATERIAL_REQUIREMENTS
79 ( p_validation_level IN NUMBER
80 , p_wip_entity_id IN NUMBER := NULL
81 , p_organization_id IN NUMBER := NULL
82 , p_operation_seq_num IN NUMBER := NULL
83 , p_department_id IN NUMBER := NULL
84 , p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
85 , x_material_shortage IN OUT NOCOPY NUMBER
86 , x_eam_mat_req_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
87 , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
88 , x_return_status OUT NOCOPY VARCHAR2
89 );
90
91 PROCEDURE OPERATION_RESOURCES
92 ( p_validation_level IN NUMBER
93 , p_wip_entity_id IN NUMBER := NULL
94 , p_organization_id IN NUMBER := NULL
95 , p_operation_seq_num IN NUMBER := NULL
96 , p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type
97 , p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
98 , p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type
99 , x_eam_res_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_tbl_type
100 , x_eam_res_inst_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
101 , x_eam_res_usage_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type
102 , x_schedule_wo IN OUT NOCOPY NUMBER
103 , x_bottomup_scheduled IN OUT NOCOPY NUMBER
104 , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
105 , x_return_status OUT NOCOPY VARCHAR2
106 );
107
108
109 PROCEDURE OPERATION_NETWORKS
110 ( p_validation_level IN NUMBER
111 , p_wip_entity_id IN NUMBER := NULL
112 , p_organization_id IN NUMBER := NULL
113 , p_eam_op_network_tbl IN EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
114 , x_eam_op_network_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
115 , x_schedule_wo IN OUT NOCOPY NUMBER
116 , x_bottomup_scheduled IN OUT NOCOPY NUMBER
117 , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
118 , x_return_status OUT NOCOPY VARCHAR2
119 );
120
121 PROCEDURE WO_OPERATIONS
122 ( p_validation_level IN NUMBER
123 , p_wip_entity_id IN NUMBER := NULL
124 , p_organization_id IN NUMBER := NULL
125 , p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type
126 , p_eam_op_network_tbl IN EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
127 , p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type
128 , p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
129 , p_eam_sub_res_tbl IN EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type
130 , p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type
131 , p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
132 , p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type
133 , x_eam_op_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_op_tbl_type
134 , x_eam_op_network_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
135 , x_eam_res_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_tbl_type
136 , x_eam_res_inst_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
137 , x_eam_sub_res_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type
138 , x_eam_res_usage_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type
139 , x_eam_mat_req_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
140 , x_eam_direct_items_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type
141 , x_schedule_wo IN OUT NOCOPY NUMBER
142 , x_bottomup_scheduled IN OUT NOCOPY NUMBER
143 , x_material_shortage IN OUT NOCOPY NUMBER
144 , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
145 , x_return_status OUT NOCOPY VARCHAR2
146 );
147
148 PROCEDURE WORK_ORDER
149 ( p_validation_level IN NUMBER
150 , p_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type
151 , p_wip_entity_id IN NUMBER
152 , p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type
153 , p_eam_op_network_tbl IN EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
154 , p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type
155 , p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
156 , p_eam_sub_res_tbl IN EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type
157 , p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type
158 , p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
159 , p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type
160 , x_eam_wo_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_rec_type
161 , x_eam_op_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_op_tbl_type
162 , x_eam_op_network_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
163 , x_eam_res_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_tbl_type
164 , x_eam_res_inst_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
165 , x_eam_sub_res_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type
166 , x_eam_res_usage_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type
167 , x_eam_mat_req_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
168 , x_eam_direct_items_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type
169 , x_schedule_wo IN OUT NOCOPY NUMBER
170 , x_bottomup_scheduled IN OUT NOCOPY NUMBER
171 , x_material_shortage IN OUT NOCOPY NUMBER
172 , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
173 , x_return_status OUT NOCOPY VARCHAR2
174 );
175
176 PROCEDURE PROCESS_WO
177 ( p_api_version_number IN NUMBER := 1.0
178 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
179 , x_return_status OUT NOCOPY VARCHAR2
180 , x_msg_count OUT NOCOPY NUMBER
181 , p_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type
182 , p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type
183 , p_eam_op_network_tbl IN EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
184 , p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type
185 , p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
186 , p_eam_sub_res_tbl IN EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type
187 , p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type
188 , p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
189 , p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type
190 , x_eam_wo_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_rec_type
191 , x_eam_op_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_op_tbl_type
192 , x_eam_op_network_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
193 , x_eam_res_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_tbl_type
194 , x_eam_res_inst_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
195 , x_eam_sub_res_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type
196 , x_eam_res_usage_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type
197 , x_eam_mat_req_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
198 , x_eam_direct_items_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type
199 );
200
201 PROCEDURE Validate_Transaction_Type
202 ( p_transaction_type IN NUMBER
203 , p_entity_name IN VARCHAR2
204 , p_entity_id IN VARCHAR2
205 , x_valid_transaction OUT NOCOPY BOOLEAN
206 , x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
207 );
208
209 PROCEDURE COMP_UNCOMP_WORKORDER
210 (
211 p_eam_wo_comp_rec IN EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type
212 , p_eam_wo_quality_tbl IN EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type
213 , p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type
214 , p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type
215 , p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type
216 , p_eam_wo_comp_mr_read_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type
217 , x_eam_wo_comp_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type
218 , x_eam_wo_quality_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type
219 , x_eam_meter_reading_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type
220 , x_eam_counter_prop_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type
221 , x_eam_wo_comp_rebuild_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type
222 , x_eam_wo_comp_mr_read_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type
223 , x_return_status OUT NOCOPY VARCHAR2
224 , x_msg_count OUT NOCOPY NUMBER
225 );
226
227 PROCEDURE COMP_UNCOMP_OPERATION
228 (
229 p_eam_op_compl_tbl IN EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type
230 , p_eam_wo_quality_tbl IN EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type
231 , x_eam_op_comp_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type
232 , x_eam_wo_quality_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type
233 , x_return_status OUT NOCOPY VARCHAR2
234 , x_msg_count OUT NOCOPY NUMBER
235 );
236
237 PROCEDURE SERVICE_WORKREQUEST_ASSO
238 (
239 p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type
240 , x_eam_request_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_request_tbl_type
241 , x_return_status OUT NOCOPY VARCHAR2
242 , x_msg_count OUT NOCOPY NUMBER
243 );
244
245
246 PROCEDURE Set_Debug
247 (p_debug_flag IN VARCHAR2
248 );
249
250
251 FUNCTION Get_Debug RETURN VARCHAR2;
252
253 --Fix for 3360801.the following procedure will update the records returned by the api with the correct dates
254
255 PROCEDURE UPDATE_DATES
256 (x_eam_wo_rec IN OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_rec_type,
257 x_eam_op_tbl IN OUT NOCOPY EAM_PROCESS_WO_PUB.eam_op_tbl_type,
258 x_eam_res_tbl IN OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_tbl_type,
259 x_eam_res_inst_tbl IN OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
260 );
261
262 END EAM_PROCESS_WO_PVT;