1 PACKAGE EAM_CREATEUPDATE_WO_PVT AS
2 /* $Header: EAMVCUWS.pls 120.2 2006/03/13 23:15:17 ksiddhar noship $ */
3
4
5 /***************************************************************************
6 --
7 -- Copyright (c) 2002 Oracle Corporation, Redwood Shores, CA, USA
8 -- All rights reserved.
9 --
10 -- FILENAME
11 --
12 -- EAMVCUWS.pls
13 --
14 -- DESCRIPTION
15 --
16 -- Spec of package EAM_CREATEUPDATE_WO_PVT
17 --
18 -- NOTES
19 --
20 -- HISTORY
21 ***************************************************************************/
22
23 /*******************************
24 Procedure to create a workorder from
25 another workorder.This procedure calls workorder API to copy the workorder
26 *******************************/
27 PROCEDURE COPY_WORKORDER
28 (
29 p_init_msg_list IN VARCHAR2
30 , p_commit IN VARCHAR2
31 , p_wip_entity_id IN NUMBER
32 , p_organization_id IN NUMBER
33 , x_return_status OUT NOCOPY VARCHAR2
34 , x_wip_entity_name OUT NOCOPY VARCHAR2
35 ,x_wip_entity_id OUT NOCOPY NUMBER
36 );
37
38 /*********************************************************
39 Wrapper procedure on top of WO API.This is used to create/update workorder and its related entities
40 ************************************************/
41 PROCEDURE CREATE_UPDATE_WO
42 (
43 p_commit IN VARCHAR2 := FND_API.G_FALSE,
44 p_eam_wo_tbl IN EAM_PROCESS_WO_PUB.eam_wo_tbl_type,
45 p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,
46 p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,
47 p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
48 p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
49 p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
50 p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,
51 p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,
52 p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,
53 p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,
54 p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,
55 p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type,
56 p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type,
57 p_eam_wo_comp_mr_read_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type,
58 p_prev_activity_id IN NUMBER,
59 p_failure_id IN NUMBER := null,
60 p_failure_date IN DATE := null,
61 p_failure_entry_id IN NUMBER := null,
62 p_failure_code IN VARCHAR2 := null,
63 p_cause_code IN VARCHAR2 := null,
64 p_resolution_code IN VARCHAR2 := null,
65 p_failure_comments IN VARCHAR2 := null,
66 p_failure_code_required IN VARCHAR2 DEFAULT NULL,
67 x_wip_entity_id OUT NOCOPY NUMBER,
68 x_return_status OUT NOCOPY VARCHAR2,
69 x_msg_count OUT NOCOPY NUMBER
70 );
71
72 /********************************************************
73 Procedure to find the required,assigned and unassigned hours at workorder level
74 *********************************************************/
75 PROCEDURE ASSIGNED_HOURS
76 (
77 p_wip_entity_id IN NUMBER,
78 x_required_hours OUT NOCOPY NUMBER,
79 x_assigned_hours OUT NOCOPY NUMBER,
80 x_unassigned_hours OUT NOCOPY NUMBER
81 );
82
83 END EAM_CREATEUPDATE_WO_PVT;