1 PACKAGE eam_import_workorders AUTHID CURRENT_USER AS
2 /* $Header: EAMIMPWS.pls 120.2 2007/12/20 12:35:06 srkotika noship $ */
3
4 /*********************************************************
5 Wrapper procedure on top of WO API.This is used to update valid imported workorders and its related entities
6 ************************************************/
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,
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,
25 x_wip_entity_id OUT NOCOPY NUMBER,
26 x_return_status OUT NOCOPY VARCHAR2,
27 x_msg_count OUT NOCOPY NUMBER
28 );
29
30 END eam_import_workorders;