1 PACKAGE EAM_CONSTRUCTION_EST_PVT AUTHID CURRENT_USER AS
2 /* $Header: EAMVCESS.pls 120.2.12020000.1 2012/06/27 12:22:18 appldev ship $ */
3 -- Start of Comments
4 -- Package name : EAM_CONSTRUCTION_EST_PVT
5 -- Purpose : Privatre Package Specification for Construction estimate
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10 PROCEDURE EXPLODE_INITIAL_ESTIMATE(
11 p_api_version IN NUMBER := 1.0
12 , p_init_msg_list IN VARCHAR2 := 'F'
13 , p_commit IN VARCHAR2
14 , p_estimate_id IN NUMBER
15 , x_ce_msg_tbl OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CE_MESSAGE_TBL
16 , x_return_status OUT NOCOPY VARCHAR2
17 , x_msg_count OUT NOCOPY NUMBER
18 , x_msg_data OUT NOCOPY VARCHAR2
19 );
20
21 PROCEDURE EXPLODE_CE_ACTIVITIES(
22 p_estimate_id IN NUMBER
23 , p_eam_ce_wo_lines_tbl IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL
24 , x_eam_ce_wo_lines_tbl OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL
25 , x_ce_msg_tbl OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CE_MESSAGE_TBL
26 , x_return_status OUT NOCOPY VARCHAR2);
27
28 PROCEDURE EXPLODE_STD_OP(
29 p_std_op_id IN NUMBER
30 , p_op_seq IN NUMBER
31 , p_op_seq_desc IN VARCHAR2
32 , p_org_id IN NUMBER
33 , p_estimate_id IN NUMBER
34 , x_return_status OUT NOCOPY VARCHAR2
35 , x_msg_count OUT NOCOPY NUMBER
36 , x_msg_data OUT NOCOPY VARCHAR2
37 );
38
39 PROCEDURE POPULATE_CE_WORK_ORDER_LINES(
40 p_estimate_id IN NUMBER
41 , p_ce_associatin_rec IN EAM_EST_DATASTRUCTURES_PUB.EAM_ESTIMATE_ASSOCIATIONS_REC
42 , p_eam_ce_wo_lines_tbl IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL
43 , p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type
44 , p_eam_op_network_tbl IN EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
45 , p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type
46 , p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
47 , p_eam_sub_res_tbl IN EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type
48 , p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type
49 , p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
50 , x_eam_ce_wo_lines_tbl OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL
51 , x_return_status OUT NOCOPY VARCHAR2);
52
53 PROCEDURE INSERT_PARENT_WO_LINE(
54 p_api_version IN NUMBER := 1.0
55 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
56 , p_commit IN VARCHAR2
57 , p_estimate_id IN NUMBER
58 , p_parent_wo_line_rec IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_PARENT_WO_REC
59 , x_return_status OUT NOCOPY VARCHAR2
60 , x_msg_count OUT NOCOPY NUMBER
61 , x_msg_data OUT NOCOPY VARCHAR2
62 );
63
64 PROCEDURE DELETE_WO_LINE(
65 p_api_version IN NUMBER := 1.0
66 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
67 , p_commit IN VARCHAR2
68 , p_work_order_line_id IN NUMBER
69 , x_return_status OUT NOCOPY VARCHAR2
70 , x_msg_count OUT NOCOPY NUMBER
71 , x_msg_data OUT NOCOPY VARCHAR2
72 );
73
74 PROCEDURE INSERT_ALL_WO_LINES(
75 p_api_version IN NUMBER := 1.0
76 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
77 , p_commit IN VARCHAR2
78 , p_estimate_id IN NUMBER
79 , p_eam_ce_wo_lines_tbl IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL
80 , x_return_status OUT NOCOPY VARCHAR2
81 , x_msg_count OUT NOCOPY NUMBER
82 , x_msg_data OUT NOCOPY VARCHAR2
83 );
84
85 PROCEDURE COPY_EST_WORKBENCH(
86 p_api_version IN NUMBER := 1.0
87 , p_init_msg_list IN VARCHAR2 := 'F'
88 , p_commit IN VARCHAR2
89 , p_src_estimate_id IN NUMBER
90 , p_org_id IN NUMBER
91 , p_cpy_estimate_id OUT NOCOPY NUMBER
92 , x_return_status OUT NOCOPY VARCHAR2
93 , x_msg_count OUT NOCOPY NUMBER
94 , x_msg_data OUT NOCOPY VARCHAR2
95 );
96
97
98 TYPE CELINES_TABLE_TYPE IS TABLE OF EAM_CE_WORK_ORDER_LINES%ROWTYPE;
99
100 PROCEDURE CREATE_CU_WORKORDERS(
101 p_api_version IN NUMBER := 1.0
102 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
103 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
104 ,p_estimate_id IN NUMBER
105 ,x_return_status OUT NOCOPY VARCHAR2
106 ,x_msg_count OUT NOCOPY NUMBER
107 ,x_msg_data OUT NOCOPY VARCHAR2
108 ,p_organization_id IN NUMBER
109 ,p_debug_filename IN VARCHAR2 := 'EAM_CU_DEBUG.log'
110 ,p_debug_file_mode IN VARCHAR2 := 'w'
111 );
112
113 PROCEDURE POPULATE_WO(
114 p_parent_wo IN NUMBER
115 , p_init_msg_list VARCHAR2 := FND_API.G_FALSE
116 , p_ce_line_rec IN EAM_CE_WORK_ORDER_LINES%ROWTYPE
117 , x_eam_wo_rec IN OUT NOCOPY EAM_PROCESS_WO_PUB.EAM_WO_REC_TYPE
118 , x_return_status OUT NOCOPY VARCHAR2
119 , x_msg_count OUT NOCOPY NUMBER
120 , x_msg_data OUT NOCOPY VARCHAR2
121 );
122
123 PROCEDURE POPULATE_OPERATION(
124 p_ce_line_rec IN EAM_CE_WORK_ORDER_LINES%ROWTYPE
125 , p_init_msg_list VARCHAR2 := FND_API.G_FALSE
126 , x_eam_op_rec IN OUT NOCOPY EAM_PROCESS_WO_PUB.EAM_OP_REC_TYPE
127 , x_return_status OUT NOCOPY VARCHAR2
128 , x_msg_count OUT NOCOPY NUMBER
129 , x_msg_data OUT NOCOPY VARCHAR2
130 );
131
132 PROCEDURE POPULATE_RESOURCE(
133 p_ce_line_rec IN EAM_CE_WORK_ORDER_LINES%ROWTYPE
134 , p_init_msg_list VARCHAR2 := FND_API.G_FALSE
135 , x_eam_res_rec IN OUT NOCOPY EAM_PROCESS_WO_PUB.EAM_RES_REC_TYPE
136 , x_return_status OUT NOCOPY VARCHAR2
137 , x_msg_count OUT NOCOPY NUMBER
138 , x_msg_data OUT NOCOPY VARCHAR2
139 );
140
141 PROCEDURE POPULATE_MATERIAL(
142 p_ce_line_rec IN EAM_CE_WORK_ORDER_LINES%ROWTYPE
143 , p_init_msg_list VARCHAR2 := FND_API.G_FALSE
144 , x_eam_mat_rec IN OUT NOCOPY EAM_PROCESS_WO_PUB.EAM_MAT_REQ_REC_TYPE
145 , x_eam_direct_rec IN OUT NOCOPY EAM_PROCESS_WO_PUB.EAM_DIRECT_ITEMS_REC_TYPE
146 , x_return_status OUT NOCOPY VARCHAR2
147 , x_msg_count OUT NOCOPY NUMBER
148 , x_msg_data OUT NOCOPY VARCHAR2
149 );
150
151 FUNCTION INIT_EAM_OP_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_op_tbl_type;
152
153 FUNCTION INIT_EAM_OP_NTK_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
154
155 FUNCTION INIT_EAM_RES_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_res_tbl_type;
156
157 FUNCTION INIT_EAM_RES_INST_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
158
159 FUNCTION INIT_EAM_SUB_RES_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
160
161 FUNCTION INIT_EAM_RES_USG_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
162
163 FUNCTION INIT_EAM_MAT_REQ_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
164
165 PROCEDURE GET_CU_RECS(
166 p_api_version IN NUMBER,
167 p_commit IN VARCHAR2,
168 p_init_msg_list IN VARCHAR2,
169 p_validation_level IN NUMBER,
170 p_org_id IN NUMBER,
171 px_cu_tbl IN OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CONSTRUCTION_UNITS_TBL,
172 x_return_status OUT NOCOPY VARCHAR2,
173 x_msg_count OUT NOCOPY NUMBER,
174 x_msg_data OUT NOCOPY VARCHAR2
175 );
176
177 PROCEDURE GET_CU_ACTIVITIES(
178 p_api_version IN NUMBER,
179 p_commit IN VARCHAR2,
180 p_init_msg_list IN VARCHAR2,
181 p_validation_level IN NUMBER,
182 p_cu_id IN NUMBER,
183 x_activities_tbl OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_ESTIMATE_ASSOCIATIONS_TBL,
184 x_return_status OUT NOCOPY VARCHAR2,
185 x_msg_count OUT NOCOPY NUMBER,
186 x_msg_data OUT NOCOPY VARCHAR2
187 );
188
189 PROCEDURE CREATE_ESTIMATE(
190 p_api_version IN NUMBER,
191 p_commit IN VARCHAR2,
192 p_init_msg_list IN VARCHAR2,
193 p_validation_level IN NUMBER,
194 px_estimate_rec IN OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CONSTRUCTION_ESTIMATE_REC,
195 x_return_status OUT NOCOPY VARCHAR2,
196 x_msg_count OUT NOCOPY NUMBER,
197 x_msg_data OUT NOCOPY VARCHAR2
198 );
199
200 PROCEDURE UPDATE_ESTIMATE(
201 p_api_version IN NUMBER,
202 p_commit IN VARCHAR2,
203 p_init_msg_list IN VARCHAR2,
204 p_validation_level IN NUMBER,
205 p_estimate_rec IN EAM_EST_DATASTRUCTURES_PUB.EAM_CONSTRUCTION_ESTIMATE_REC,
206 x_return_status OUT NOCOPY VARCHAR2,
207 x_msg_count OUT NOCOPY NUMBER,
208 x_msg_data OUT NOCOPY VARCHAR2
209 );
210
211 PROCEDURE SET_ACTIVITIES_FOR_CE(
212 p_api_version IN NUMBER,
213 p_commit IN VARCHAR2,
214 p_init_msg_list IN VARCHAR2,
215 p_validation_level IN NUMBER,
216 p_ce_id IN NUMBER,
217 px_activities_tbl IN OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_ESTIMATE_ASSOCIATIONS_TBL,
218 x_return_status OUT NOCOPY VARCHAR2,
219 x_msg_count OUT NOCOPY NUMBER,
220 x_msg_data OUT NOCOPY VARCHAR2
221 );
222
223 PROCEDURE UPDATE_CE_WO_LNS_BY_GROUP_OPT(
224 p_api_version IN NUMBER,
225 p_commit IN VARCHAR2,
226 p_init_msg_list IN VARCHAR2,
227 p_validation_level IN NUMBER,
228 p_ce_wo_defaults IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WO_DEFAULTS_REC,
229 x_return_status OUT NOCOPY VARCHAR2,
230 x_msg_count OUT NOCOPY NUMBER,
231 x_msg_data OUT NOCOPY VARCHAR2
232 );
233
234 End EAM_CONSTRUCTION_EST_PVT;