1 PACKAGE EAM_CREATEUPDATE_WO_PVT AUTHID CURRENT_USER AS
2 /* $Header: EAMVCUWS.pls 120.4 2011/02/28 14:53:08 somitra ship $ */
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 /*********************************************************
74 Wrapper procedure on top of WO API.Overloaded procedure of CREATE_UPDATE_WO for safety
75 This is used to create/update workorder and its related entities
76 (Uses new signature post 12.2)
77 ************************************************/
78 PROCEDURE CREATE_UPDATE_WO
79 (
80 p_commit IN VARCHAR2 := FND_API.G_FALSE,
81 p_eam_wo_tbl IN EAM_PROCESS_WO_PUB.eam_wo_tbl_type,
82 p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,
83 p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,
84 p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
85 p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
86 p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
87 p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,
88 p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,
89 p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,
90 p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,
91 p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,
92 p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type,
93 p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type,
94 p_eam_wo_comp_mr_read_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type,
95 p_eam_permit_tbl IN EAM_PROCESS_SAFETY_PUB.eam_wp_tbl_type, -- new param for safety permit
96 p_eam_permit_wo_assoc_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type, -- new param for safety permit
97 p_eam_work_clearance_tbl IN EAM_PROCESS_SAFETY_PUB.eam_clearance_header_tbl_type ,-- new parameter for safety clearance
98 p_eam_wc_wo_assoc_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type , --new parameter for safety clearance
99 p_prev_activity_id IN NUMBER,
100 p_failure_id IN NUMBER := null,
101 p_failure_date IN DATE := null,
102 p_failure_entry_id IN NUMBER := null,
103 p_failure_code IN VARCHAR2 := null,
104 p_cause_code IN VARCHAR2 := null,
105 p_resolution_code IN VARCHAR2 := null,
106 p_failure_comments IN VARCHAR2 := null,
107 p_failure_code_required IN VARCHAR2 DEFAULT NULL,
108 x_wip_entity_id OUT NOCOPY NUMBER,
109 x_return_status OUT NOCOPY VARCHAR2,
110 x_msg_count OUT NOCOPY NUMBER
111 );
112
113 /*********************************************************
114 Wrapper procedure on top of WO API.Overloaded procedure of CREATE_UPDATE_WO for safety
115 This is used to create/update workorder and its related entities
116 (To be backward compliant with 12.1.3 level APIs)
117 ************************************************/
118
119 PROCEDURE CREATE_UPDATE_WO
120 (
121 p_commit IN VARCHAR2 := FND_API.G_FALSE,
122 p_eam_wo_tbl IN EAM_PROCESS_WO_PUB.eam_wo_tbl_type,
123 p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,
124 p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,
125 p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
126 p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
127 p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
128 p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,
129 p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,
130 p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,
131 p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,
132 p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,
133 p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type,
134 p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type,
135 p_eam_wo_comp_mr_read_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type,
136 p_eam_permit_tbl IN EAM_PROCESS_PERMIT_PUB.eam_wp_tbl_type, -- new param for safety permit
137 p_eam_permit_wo_assoc_tbl IN EAM_PROCESS_PERMIT_PUB.eam_wp_association_tbl_type, -- new param for safety permit
138 p_prev_activity_id IN NUMBER,
139 p_failure_id IN NUMBER := null,
140 p_failure_date IN DATE := null,
141 p_failure_entry_id IN NUMBER := null,
142 p_failure_code IN VARCHAR2 := null,
143 p_cause_code IN VARCHAR2 := null,
144 p_resolution_code IN VARCHAR2 := null,
145 p_failure_comments IN VARCHAR2 := null,
146 p_failure_code_required IN VARCHAR2 DEFAULT NULL,
147 x_wip_entity_id OUT NOCOPY NUMBER,
148 x_return_status OUT NOCOPY VARCHAR2,
149 x_msg_count OUT NOCOPY NUMBER
150 );
151
152 /********************************************************
153 Procedure to find the required,assigned and unassigned hours at workorder level
154 *********************************************************/
155 PROCEDURE ASSIGNED_HOURS
156 (
157 p_wip_entity_id IN NUMBER,
158 x_required_hours OUT NOCOPY NUMBER,
159 x_assigned_hours OUT NOCOPY NUMBER,
160 x_unassigned_hours OUT NOCOPY NUMBER
161 );
162
163 END EAM_CREATEUPDATE_WO_PVT;