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 :
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
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
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,
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,
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,
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 :
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
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
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,
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,
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,
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 :
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
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
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,
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,
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,
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 :
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
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
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,
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,
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,
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 :
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
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
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,
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,
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,
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,
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,
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,