63:
64: PROCEDURE get_workorder_details
65: (
66: p_api_version IN NUMBER := 1.0,
67: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
68: p_commit IN VARCHAR2 := FND_API.G_FALSE,
69: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
70: p_default IN VARCHAR2 := FND_API.G_FALSE,
71: p_module_type IN VARCHAR2,
64: PROCEDURE get_workorder_details
65: (
66: p_api_version IN NUMBER := 1.0,
67: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
68: p_commit IN VARCHAR2 := FND_API.G_FALSE,
69: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
70: p_default IN VARCHAR2 := FND_API.G_FALSE,
71: p_module_type IN VARCHAR2,
72: p_userid IN VARCHAR2 := NULL,
65: (
66: p_api_version IN NUMBER := 1.0,
67: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
68: p_commit IN VARCHAR2 := FND_API.G_FALSE,
69: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
70: p_default IN VARCHAR2 := FND_API.G_FALSE,
71: p_module_type IN VARCHAR2,
72: p_userid IN VARCHAR2 := NULL,
73: p_WorkorderId IN NUMBER,
66: p_api_version IN NUMBER := 1.0,
67: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
68: p_commit IN VARCHAR2 := FND_API.G_FALSE,
69: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
70: p_default IN VARCHAR2 := FND_API.G_FALSE,
71: p_module_type IN VARCHAR2,
72: p_userid IN VARCHAR2 := NULL,
73: p_WorkorderId IN NUMBER,
74: p_WorkorderNumber IN VARCHAR2,
105:
106: PROCEDURE get_wo_operations_details
107: (
108: p_api_version IN NUMBER := 1.0,
109: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
110: p_commit IN VARCHAR2 := FND_API.G_FALSE,
111: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
112: p_default IN VARCHAR2 := FND_API.G_FALSE,
113: p_module_type IN VARCHAR2,
106: PROCEDURE get_wo_operations_details
107: (
108: p_api_version IN NUMBER := 1.0,
109: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
110: p_commit IN VARCHAR2 := FND_API.G_FALSE,
111: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
112: p_default IN VARCHAR2 := FND_API.G_FALSE,
113: p_module_type IN VARCHAR2,
114: p_userid IN VARCHAR2 := NULL,
107: (
108: p_api_version IN NUMBER := 1.0,
109: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
110: p_commit IN VARCHAR2 := FND_API.G_FALSE,
111: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
112: p_default IN VARCHAR2 := FND_API.G_FALSE,
113: p_module_type IN VARCHAR2,
114: p_userid IN VARCHAR2 := NULL,
115: p_WorkorderId IN NUMBER,
108: p_api_version IN NUMBER := 1.0,
109: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
110: p_commit IN VARCHAR2 := FND_API.G_FALSE,
111: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
112: p_default IN VARCHAR2 := FND_API.G_FALSE,
113: p_module_type IN VARCHAR2,
114: p_userid IN VARCHAR2 := NULL,
115: p_WorkorderId IN NUMBER,
116: p_WorkorderNumber IN VARCHAR2,
143:
144: PROCEDURE get_wo_mtl_reqmts
145: (
146: p_api_version IN NUMBER := 1.0,
147: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
148: p_commit IN VARCHAR2 := FND_API.G_FALSE,
149: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
150: p_default IN VARCHAR2 := FND_API.G_FALSE,
151: p_module_type IN VARCHAR2,
144: PROCEDURE get_wo_mtl_reqmts
145: (
146: p_api_version IN NUMBER := 1.0,
147: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
148: p_commit IN VARCHAR2 := FND_API.G_FALSE,
149: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
150: p_default IN VARCHAR2 := FND_API.G_FALSE,
151: p_module_type IN VARCHAR2,
152: p_userid IN VARCHAR2 := NULL,
145: (
146: p_api_version IN NUMBER := 1.0,
147: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
148: p_commit IN VARCHAR2 := FND_API.G_FALSE,
149: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
150: p_default IN VARCHAR2 := FND_API.G_FALSE,
151: p_module_type IN VARCHAR2,
152: p_userid IN VARCHAR2 := NULL,
153: p_WorkorderId IN NUMBER,
146: p_api_version IN NUMBER := 1.0,
147: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
148: p_commit IN VARCHAR2 := FND_API.G_FALSE,
149: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
150: p_default IN VARCHAR2 := FND_API.G_FALSE,
151: p_module_type IN VARCHAR2,
152: p_userid IN VARCHAR2 := NULL,
153: p_WorkorderId IN NUMBER,
154: p_WorkorderNumber IN VARCHAR2,
180:
181: PROCEDURE get_wo_assoc_documents
182: (
183: p_api_version IN NUMBER := 1.0,
184: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
185: p_commit IN VARCHAR2 := FND_API.G_FALSE,
186: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
187: p_default IN VARCHAR2 := FND_API.G_FALSE,
188: p_module_type IN VARCHAR2,
181: PROCEDURE get_wo_assoc_documents
182: (
183: p_api_version IN NUMBER := 1.0,
184: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
185: p_commit IN VARCHAR2 := FND_API.G_FALSE,
186: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
187: p_default IN VARCHAR2 := FND_API.G_FALSE,
188: p_module_type IN VARCHAR2,
189: p_userid IN VARCHAR2 := NULL,
182: (
183: p_api_version IN NUMBER := 1.0,
184: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
185: p_commit IN VARCHAR2 := FND_API.G_FALSE,
186: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
187: p_default IN VARCHAR2 := FND_API.G_FALSE,
188: p_module_type IN VARCHAR2,
189: p_userid IN VARCHAR2 := NULL,
190: p_WorkorderId IN NUMBER,
183: p_api_version IN NUMBER := 1.0,
184: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
185: p_commit IN VARCHAR2 := FND_API.G_FALSE,
186: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
187: p_default IN VARCHAR2 := FND_API.G_FALSE,
188: p_module_type IN VARCHAR2,
189: p_userid IN VARCHAR2 := NULL,
190: p_WorkorderId IN NUMBER,
191: p_WorkorderNumber IN VARCHAR2,
211:
212: PROCEDURE get_wo_turnover_notes
213: (
214: p_api_version IN NUMBER := 1.0,
215: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
216: p_commit IN VARCHAR2 := FND_API.G_FALSE,
217: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
218: p_default IN VARCHAR2 := FND_API.G_FALSE,
219: p_module_type IN VARCHAR2,
212: PROCEDURE get_wo_turnover_notes
213: (
214: p_api_version IN NUMBER := 1.0,
215: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
216: p_commit IN VARCHAR2 := FND_API.G_FALSE,
217: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
218: p_default IN VARCHAR2 := FND_API.G_FALSE,
219: p_module_type IN VARCHAR2,
220: p_userid IN VARCHAR2 := NULL,
213: (
214: p_api_version IN NUMBER := 1.0,
215: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
216: p_commit IN VARCHAR2 := FND_API.G_FALSE,
217: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
218: p_default IN VARCHAR2 := FND_API.G_FALSE,
219: p_module_type IN VARCHAR2,
220: p_userid IN VARCHAR2 := NULL,
221: p_WorkorderId IN NUMBER,
214: p_api_version IN NUMBER := 1.0,
215: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
216: p_commit IN VARCHAR2 := FND_API.G_FALSE,
217: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
218: p_default IN VARCHAR2 := FND_API.G_FALSE,
219: p_module_type IN VARCHAR2,
220: p_userid IN VARCHAR2 := NULL,
221: p_WorkorderId IN NUMBER,
222: p_WorkorderNumber IN VARCHAR2,
261:
262: PROCEDURE get_wo_res_txns
263: (
264: p_api_version IN NUMBER := 1.0,
265: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
266: p_commit IN VARCHAR2 := FND_API.G_FALSE,
267: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
268: p_default IN VARCHAR2 := FND_API.G_FALSE,
269: p_module_type IN VARCHAR2,
262: PROCEDURE get_wo_res_txns
263: (
264: p_api_version IN NUMBER := 1.0,
265: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
266: p_commit IN VARCHAR2 := FND_API.G_FALSE,
267: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
268: p_default IN VARCHAR2 := FND_API.G_FALSE,
269: p_module_type IN VARCHAR2,
270: p_userid IN VARCHAR2 := NULL,
263: (
264: p_api_version IN NUMBER := 1.0,
265: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
266: p_commit IN VARCHAR2 := FND_API.G_FALSE,
267: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
268: p_default IN VARCHAR2 := FND_API.G_FALSE,
269: p_module_type IN VARCHAR2,
270: p_userid IN VARCHAR2 := NULL,
271: p_WorkorderId IN NUMBER,
264: p_api_version IN NUMBER := 1.0,
265: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
266: p_commit IN VARCHAR2 := FND_API.G_FALSE,
267: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
268: p_default IN VARCHAR2 := FND_API.G_FALSE,
269: p_module_type IN VARCHAR2,
270: p_userid IN VARCHAR2 := NULL,
271: p_WorkorderId IN NUMBER,
272: p_WorkorderNumber IN VARCHAR2,
331:
332: PROCEDURE get_qa_plan_results
333: (
334: p_api_version IN NUMBER := 1.0,
335: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
336: p_commit IN VARCHAR2 := FND_API.G_FALSE,
337: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
338: p_default IN VARCHAR2 := FND_API.G_FALSE,
339: p_module_type IN VARCHAR2,
332: PROCEDURE get_qa_plan_results
333: (
334: p_api_version IN NUMBER := 1.0,
335: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
336: p_commit IN VARCHAR2 := FND_API.G_FALSE,
337: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
338: p_default IN VARCHAR2 := FND_API.G_FALSE,
339: p_module_type IN VARCHAR2,
340: p_userid IN VARCHAR2 := NULL,
333: (
334: p_api_version IN NUMBER := 1.0,
335: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
336: p_commit IN VARCHAR2 := FND_API.G_FALSE,
337: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
338: p_default IN VARCHAR2 := FND_API.G_FALSE,
339: p_module_type IN VARCHAR2,
340: p_userid IN VARCHAR2 := NULL,
341: p_WorkorderId IN NUMBER,
334: p_api_version IN NUMBER := 1.0,
335: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
336: p_commit IN VARCHAR2 := FND_API.G_FALSE,
337: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
338: p_default IN VARCHAR2 := FND_API.G_FALSE,
339: p_module_type IN VARCHAR2,
340: p_userid IN VARCHAR2 := NULL,
341: p_WorkorderId IN NUMBER,
342: p_WorkorderNumber IN VARCHAR2,
378:
379: PROCEDURE process_workorder
380: (
381: p_api_version IN NUMBER := 1.0,
382: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
383: p_commit IN VARCHAR2 := FND_API.G_FALSE,
384: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
385: p_default IN VARCHAR2 := FND_API.G_FALSE,
386: p_module_type IN VARCHAR2,
379: PROCEDURE process_workorder
380: (
381: p_api_version IN NUMBER := 1.0,
382: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
383: p_commit IN VARCHAR2 := FND_API.G_FALSE,
384: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
385: p_default IN VARCHAR2 := FND_API.G_FALSE,
386: p_module_type IN VARCHAR2,
387: p_userid IN VARCHAR2 := NULL,
380: (
381: p_api_version IN NUMBER := 1.0,
382: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
383: p_commit IN VARCHAR2 := FND_API.G_FALSE,
384: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
385: p_default IN VARCHAR2 := FND_API.G_FALSE,
386: p_module_type IN VARCHAR2,
387: p_userid IN VARCHAR2 := NULL,
388: p_WO_DETAILS_REC IN WO_DETAILS_REC_TYPE,
381: p_api_version IN NUMBER := 1.0,
382: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
383: p_commit IN VARCHAR2 := FND_API.G_FALSE,
384: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
385: p_default IN VARCHAR2 := FND_API.G_FALSE,
386: p_module_type IN VARCHAR2,
387: p_userid IN VARCHAR2 := NULL,
388: p_WO_DETAILS_REC IN WO_DETAILS_REC_TYPE,
389: p_Operations IN OP_ALL_DETAILS_TBL,