7:
8: PROCEDURE import_workorders
9: (
10: p_commit IN VARCHAR2 := FND_API.G_FALSE,
11: p_eam_wo_tbl IN EAM_PROCESS_WO_PUB.eam_wo_tbl_type,
12: p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,
13: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,
14: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
15: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
8: PROCEDURE import_workorders
9: (
10: p_commit IN VARCHAR2 := FND_API.G_FALSE,
11: p_eam_wo_tbl IN EAM_PROCESS_WO_PUB.eam_wo_tbl_type,
12: p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,
13: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,
14: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
15: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
16: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
9: (
10: p_commit IN VARCHAR2 := FND_API.G_FALSE,
11: p_eam_wo_tbl IN EAM_PROCESS_WO_PUB.eam_wo_tbl_type,
12: p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,
13: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,
14: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
15: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
16: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
17: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,
10: p_commit IN VARCHAR2 := FND_API.G_FALSE,
11: p_eam_wo_tbl IN EAM_PROCESS_WO_PUB.eam_wo_tbl_type,
12: p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,
13: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,
14: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
15: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
16: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
17: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,
18: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,
11: p_eam_wo_tbl IN EAM_PROCESS_WO_PUB.eam_wo_tbl_type,
12: p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,
13: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,
14: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
15: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
16: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
17: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,
18: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,
19: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,
12: p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,
13: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,
14: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
15: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
16: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
17: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,
18: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,
19: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,
20: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,
13: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,
14: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
15: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
16: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
17: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,
18: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,
19: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,
20: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,
21: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,
14: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
15: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
16: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
17: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,
18: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,
19: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,
20: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,
21: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,
22: p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type,
15: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
16: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
17: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,
18: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,
19: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,
20: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,
21: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,
22: p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type,
23: p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type,
16: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
17: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,
18: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,
19: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,
20: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,
21: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,
22: p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type,
23: p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type,
24: p_eam_wo_comp_mr_read_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type,
17: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,
18: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,
19: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,
20: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,
21: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,
22: p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type,
23: p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type,
24: p_eam_wo_comp_mr_read_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type,
25: x_wip_entity_id OUT NOCOPY NUMBER,
18: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,
19: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,
20: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,
21: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,
22: p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type,
23: p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type,
24: p_eam_wo_comp_mr_read_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type,
25: x_wip_entity_id OUT NOCOPY NUMBER,
26: x_return_status OUT NOCOPY VARCHAR2,
19: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,
20: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,
21: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,
22: p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type,
23: p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type,
24: p_eam_wo_comp_mr_read_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type,
25: x_wip_entity_id OUT NOCOPY NUMBER,
26: x_return_status OUT NOCOPY VARCHAR2,
27: x_msg_count OUT NOCOPY NUMBER
20: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,
21: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,
22: p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type,
23: p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type,
24: p_eam_wo_comp_mr_read_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type,
25: x_wip_entity_id OUT NOCOPY NUMBER,
26: x_return_status OUT NOCOPY VARCHAR2,
27: x_msg_count OUT NOCOPY NUMBER
28: );