[Home] [Help]
PACKAGE: APPS.AHL_VWP_TASK_CST_PR_PVT
Source
1 PACKAGE AHL_VWP_TASK_CST_PR_PVT AUTHID CURRENT_USER AS
2 /* $Header: AHLVTCPS.pls 115.4 2003/10/22 00:18:31 yazhou noship $ */
3 -----------------------------------------------------------
4 -- PACKAGE
5 -- Ahl_VWP_TASK_CST_PR_PVT
6 --
7 -- PURPOSE
8 -- This package is a Private API to process Estimating Cost and Price
9 -- for a Task It contains specification for pl/sql records and tables
10 --
11 --
12 -- NOTES
13 --
14 --
15 -- HISTORY
16 -- 25-AUG-2003 SSURAPAN Created.
17 -----------------------------------------------------------
18 TYPE cost_price_rec_type IS RECORD (
19 Visit_task_id NUMBER,
20 Visit_id NUMBER,
21 Mr_id NUMBER,
22 Actual_cost NUMBER,
23 Estimated_cost NUMBER,
24 Actual_price NUMBER,
25 Estimated_price NUMBER,
26 Currency VARCHAR2(80), --15,
27 Snapshot_Id NUMBER,
28 Object_version_number NUMBER,
29 Estimated_Profit NUMBER,
30 Actual_Profit NUMBER,
31 Outside_party_flag VARCHAR2(1),
32 Is_outside_pty_flag_updt VARCHAR2(1),
33 Is_Cst_Pr_Info_Required VARCHAR2(1),
34 Is_Cst_Struc_updated VARCHAR2(1),
35 Price_list_Id NUMBER,
36 Price_List_Name VARCHAR2(80), --240
37 Service_Request_Id NUMBER,
38 Customer_Id NUMBER,
39 Organization_Id NUMBER,
40 Visit_Start_Date DATE,
41 Visit_End_Date DATE,
42 MR_Start_Date DATE,
43 MR_End_Date DATE,
44 Task_Start_Date DATE,
45 Task_End_Date DATE,
46 Task_Name VARCHAR2(80),
47 MR_Title VARCHAR2(80),
48 MR_Description VARCHAR2(2000),
49 Billing_Item_Id NUMBER,
50 Item_Name VARCHAR2(400),
51 Organization_name VARCHAR2(240),
52 Workorder_Id NUMBER,
53 Master_WO_Flag VARCHAR2(1),
54 MR_Session_Id NUMBER,
55 Cost_Session_Id NUMBER,
56 CREATED_BY NUMBER,
57 CREATION_DATE DATE,
58 LAST_UPDATED_BY NUMBER,
59 LAST_UPDATE_DATE DATE,
60 LAST_UPDATE_LOGIN NUMBER,
61 ATTRIBUTE_CATEGORY VARCHAR2(30),
62 ATTRIBUTE1 VARCHAR2(150),
63 ATTRIBUTE2 VARCHAR2(150),
64 ATTRIBUTE3 VARCHAR2(150),
65 ATTRIBUTE4 VARCHAR2(150),
66 ATTRIBUTE5 VARCHAR2(150),
67 ATTRIBUTE6 VARCHAR2(150),
68 ATTRIBUTE7 VARCHAR2(150),
69 ATTRIBUTE8 VARCHAR2(150),
70 ATTRIBUTE9 VARCHAR2(150),
71 ATTRIBUTE10 VARCHAR2(150),
72 ATTRIBUTE11 VARCHAR2(150),
73 ATTRIBUTE12 VARCHAR2(150),
74 ATTRIBUTE13 VARCHAR2(150),
75 ATTRIBUTE14 VARCHAR2(150),
76 ATTRIBUTE15 VARCHAR2(150)
77 );
78
79 ------------------------
80 -- Declare Procedures --
81 ------------------------
82
83 -- Start of Comments --
84 -- Procedure name : Get_Task_Cost_Details
85 -- Type : Private(Called from Estimate and cost/price Task details UI)
86 --
87 -- Function :
88 --
89 --
90 -- Pre-reqs :
91 -- Parameters :
92 --
93 -- Standard IN Parameters :
94 -- p_api_version IN NUMBER Required
95 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
96 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
97 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
98 --
99 -- Standard OUT Parameters :
100 -- x_return_status OUT VARCHAR2 Required
101 -- x_msg_count OUT NUMBER Required
102 -- x_msg_data OUT VARCHAR2 Required
103 --
104 -- Get Task Cost Details Parameters:
105 -- p_x_cost_price_rec IN OUT NOCOPY AHL_VWP_VISIT_CST_PR_PVT.Cost_Price_Rec_Type,
106 -- Contains Cost/Price infor mation relates to Vist and its Task
107 --
108 -- Version :
109 -- Initial Version 1.0
110 --
111 -- End of Comments.
112
113 PROCEDURE Get_Task_Cost_Details (
114 p_api_version IN NUMBER,
115 p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
116 p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
117 p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
118 p_module_type IN VARCHAR2 := NULL,
119 p_x_cost_price_rec IN OUT NOCOPY AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type,
120 x_return_status OUT NOCOPY VARCHAR2,
121 x_msg_count OUT NOCOPY NUMBER,
122 x_msg_data OUT NOCOPY VARCHAR2
123 );
124
125 -- Start of Comments --
126 -- Procedure name : Estimate_Task_Cost
127 -- Type : Private(Called from Estimate and cost/price Task UI
128 --
129 -- Function : To get task estimated cost and actual cost
130 --
131 --
132 -- Pre-reqs :
133 -- Parameters :
134 --
135 -- Standard IN Parameters :
136 -- p_api_version IN NUMBER Required
137 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
138 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
139 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
140 --
141 -- Standard OUT Parameters :
142 -- x_return_status OUT VARCHAR2 Required
143 -- x_msg_count OUT NUMBER Required
144 -- x_msg_data OUT VARCHAR2 Required
145 --
146 -- Estimate Task Cost Parameters:
147 -- p_x_cost_price_rec IN OUT NOCOPY AHL_VWP_VISIT_CST_PR_PVT.Cost_Price_Rec_Type,
148 -- Contains Cost/Price infor mation relates to Vist and its Task
149 --
150 -- Version :
151 -- Initial Version 1.0
152 --
153 -- End of Comments.
154
155 PROCEDURE Estimate_Task_Cost (
156 p_api_version IN NUMBER,
157 p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
158 p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
159 p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
160 p_module_type IN VARCHAR2 := NULL,
161 p_x_cost_price_rec IN OUT NOCOPY AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type,
162 x_return_status OUT NOCOPY VARCHAR2,
163 x_msg_count OUT NOCOPY NUMBER,
164 x_msg_data OUT NOCOPY VARCHAR2
165 );
166 -- Start of Comments --
167 -- Procedure name : Estimate_Task_Price
168 -- Type : Private(Called from Estimate and cost/price Task UI
169 --
170 -- Function :To get Task Estimated Price and Actual Price
171 --
172 --
173 -- Pre-reqs :
174 -- Parameters :
175 --
176 -- Standard IN Parameters :
177 -- p_api_version IN NUMBER Required
178 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
179 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
180 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
181 --
182 -- Standard OUT Parameters :
183 -- x_return_status OUT VARCHAR2 Required
184 -- x_msg_count OUT NUMBER Required
185 -- x_msg_data OUT VARCHAR2 Required
186 --
187 -- Estimate Task Price Parameters:
188 -- p_x_cost_price_rec IN OUT NOCOPY AHL_VWP_VISIT_CST_PR_PVT.Cost_Price_Rec_Type,
189 -- Contains Cost/Price infor mation relates to Vist and its Task
190 --
191 -- Version :
192 -- Initial Version 1.0
193 --
194 -- End of Comments.
195
196 PROCEDURE Estimate_Task_Price (
197 p_api_version IN NUMBER,
198 p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
199 p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
200 p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
201 p_module_type IN VARCHAR2 := NULL,
202 p_x_cost_price_rec IN OUT NOCOPY AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type,
203 x_return_status OUT NOCOPY VARCHAR2,
204 x_msg_count OUT NOCOPY NUMBER,
205 x_msg_data OUT NOCOPY VARCHAR2
206 );
207
208 -- Start of Comments --
209 -- Procedure name : Update Task Cost Details
210 -- Type : Private(Called from Estimate and cost/price Task UI
211 --
212 -- Function : To update task price list
213 --
214 --
215 -- Pre-reqs :
216 -- Parameters :
217 --
218 -- Standard IN Parameters :
219 -- p_api_version IN NUMBER Required
220 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
221 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
222 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
223 --
224 -- Standard OUT Parameters :
225 -- x_return_status OUT VARCHAR2 Required
226 -- x_msg_count OUT NUMBER Required
227 -- x_msg_data OUT VARCHAR2 Required
228 --
229 -- Create Material Request Parameters:
230 -- p_cost_price_rec IN Cost_price_rec_type, Required
231 --
232 -- Version :
233 -- Initial Version 1.0
234 --
235 -- End of Comments.
236
237 PROCEDURE Update_Task_Cost_Details (
238 p_api_version IN NUMBER,
239 p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
240 p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
241 p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
242 p_module_type IN VARCHAR2 := NULL,
243 p_cost_price_rec IN AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type,
244 x_return_status OUT NOCOPY VARCHAR2,
245 x_msg_count OUT NOCOPY NUMBER,
246 x_msg_data OUT NOCOPY VARCHAR2
247 );
248
249 -- Start of Comments --
250 -- Procedure name : Get Node Cost Details
251 -- Type : Private called from Cost Structure Page to show the Page Context for the Task
252 --
253 -- Function : To show the details of Estimated and the Actual Cost of the Task
254 --
255 --
256 -- Pre-reqs :
257 -- Parameters :
258 --
259 -- Standard IN Parameters :
260 -- p_api_version IN NUMBER Required
261 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
262 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
263 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
264 -- p_module_type IN VARCHAR2 Default 'JSP'
265 -- Standard OUT Parameters :
266 -- x_return_status OUT VARCHAR2 Required
267 -- x_msg_count OUT NUMBER Required
268 -- x_msg_data OUT VARCHAR2 Required
269 --
270 -- Get_Node_Cost_Details Parameters:
271 -- p_cost_price_rec IN Cost_price_rec_type, Required
272 --
273 -- Version :
274 -- Initial Version 1.0
275 --
276 -- End of Comments.
277
278
279
280
281 PROCEDURE Get_Node_Cost_Details (
282 p_api_version IN NUMBER,
283 p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
284 p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
285 p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
286 p_module_type IN VARCHAR2 := NULL,
287 x_return_status OUT NOCOPY VARCHAR2,
288 x_msg_count OUT NOCOPY NUMBER,
289 x_msg_data OUT NOCOPY VARCHAR2,
290 p_x_cost_price_rec IN OUT NOCOPY AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type
291 );
292
293 -- GET_TASK_ITEMS_NO_PRICE Parameters:
294 -- Refer for more details \\Industry1-nt\telecom\Advanced Services Online\300 DLD\11.5.10\VWP\Costing_DLD_Part2_V1.8.doc
295 --
296 --
297
298 PROCEDURE GET_TASK_ITEMS_NO_PRICE (
299 p_api_version IN NUMBER,
300 p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
301 p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
302 p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
303 p_module_type IN VARCHAR2 := NULL,
304 x_return_status OUT NOCOPY VARCHAR2,
305 x_msg_count OUT NOCOPY NUMBER,
306 x_msg_data OUT NOCOPY VARCHAR2,
307 p_cost_price_rec IN AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type,
308 x_cost_price_tbl OUT NOCOPY AHL_VWP_VISIT_CST_PR_PVT.cost_price_tbl_type
309 );
310
311 END AHL_VWP_TASK_CST_PR_PVT;