[Home] [Help]
PACKAGE: APPS.EAM_ACTIVITYUTILITIES_PVT
Source
1 PACKAGE EAM_ActivityUtilities_PVT AUTHID CURRENT_USER AS
2 /* $Header: EAMVAAUS.pls 120.1 2005/06/13 04:09:50 appldev $ */
3
4 -- ======================================================================
5 -- Utility Procedures
6 PROCEDURE Validate_Organization
7 ( p_organization_id IN NUMBER,
8 p_organization_code IN VARCHAR2,
9 x_return_status OUT NOCOPY VARCHAR2,
10 x_organization_id OUT NOCOPY NUMBER,
11 x_organization_code OUT NOCOPY VARCHAR2
12 );
13
14 -- ----------------------------------------------------------------------
15 PROCEDURE Validate_Work_Order
16 (
17 p_work_order_rec IN EAM_Activity_PUB.Work_Order_Rec_Type,
18 x_return_status OUT NOCOPY VARCHAR2,
19 x_work_order_rec OUT NOCOPY EAM_Activity_PUB.Work_Order_Rec_Type
20 );
21
22 -- ----------------------------------------------------------------------
23 FUNCTION Get_Item_Concatenated_Segments(
24 p_organization_id IN NUMBER,
25 p_inventory_item_id IN NUMBER
26 )
27 RETURN VARCHAR2;
28
29 -- ----------------------------------------------------------------------
30 FUNCTION Get_Act_Id_From_Work_Order(
31 p_wip_entity_id IN NUMBER
32 )
33 RETURN NUMBER;
34
35 -- ----------------------------------------------------------------------
36 FUNCTION Get_Org_Id_From_Work_Order(
37 p_wip_entity_id IN NUMBER
38 )
39 RETURN NUMBER;
40
41 -- ----------------------------------------------------------------------
42 FUNCTION Get_Department_Code(
43 p_organization_id IN NUMBER,
44 p_department_id IN NUMBER
45 )
46 RETURN VARCHAR2;
47
48 -- ----------------------------------------------------------------------
49 FUNCTION Get_Resource_Code(
50 p_organization_id IN NUMBER,
51 p_resource_id IN NUMBER
52 )
53 RETURN VARCHAR2;
54
55 -- ----------------------------------------------------------------------
56 FUNCTION Get_Expense_Account_Id(
57 p_organization_id IN NUMBER
58 )
59 RETURN NUMBER;
60
61 -- ----------------------------------------------------------------------
62 PROCEDURE Get_Asset_From_WO(
63 p_wip_entity_id IN NUMBER,
64 x_inventory_item_id OUT NOCOPY NUMBER,
65 x_serial_number OUT NOCOPY VARCHAR2
66 );
67
68 -- ----------------------------------------------------------------------
69 FUNCTION Get_Asset_Owning_Dept_Id(
70 p_organization_id IN NUMBER,
71 p_inventory_item_id IN NUMBER,
72 p_serial_number IN VARCHAR2
73 )
74 RETURN NUMBER;
75
76 -- ----------------------------------------------------------------------
77 FUNCTION Get_WO_Res_Scheduled_Units(
78 p_organization_id IN NUMBER,
79 p_wip_entity_id IN NUMBER,
80 p_operation_seq_num IN NUMBER,
81 p_resource_seq_num IN NUMBER
82 )
83 RETURN NUMBER;
84
85 -- ----------------------------------------------------------------------
86 FUNCTION Get_Master_Org_Id(
87 p_organization_id IN NUMBER
88 )
89 RETURN NUMBER;
90
91 -- ----------------------------------------------------------------------
92
93 PROCEDURE Validate_Asset_Number(
94 p_instance_number IN VARCHAR2,
95 p_organization_id IN NUMBER,
96 p_inventory_item_id IN NUMBER,
97 p_serial_number IN VARCHAR2,
98
99 x_return_status OUT NOCOPY VARCHAR2,
100 x_error_mesg OUT NOCOPY VARCHAR2,
101
102 x_maintenance_object_id OUT NOCOPY NUMBER,
103 x_maintenance_object_type OUT NOCOPY NUMBER
104 );
105
106 -- ----------------------------------------------------------------------
107 FUNCTION Get_Cost_Activity(
108 p_activity_id IN NUMBER
109 )
110 RETURN VARCHAR2;
111
112 -- ----------------------------------------------------------------------
113 FUNCTION Get_Locator(
114 p_organization_id IN NUMBER,
115 p_subinventory_code IN VARCHAR2,
116 p_locator_id IN NUMBER
117 )
118 RETURN VARCHAR2;
119
120 -- ----------------------------------------------------------------------
121 PROCEDURE Get_Op_Coordinates(
122 p_organization_id IN NUMBER,
123 p_wip_entity_id IN NUMBER,
124 p_operation_seq_num IN NUMBER,
125 x_x_pos OUT NOCOPY NUMBER,
126 x_y_pos OUT NOCOPY NUMBER
127 );
128
129 -- ----------------------------------------------------------------------
130 FUNCTION Get_Bom_Sequence_Id(
131 p_organization_id IN NUMBER,
132 p_assembly_item_id IN NUMBER,
133 p_alternate_bom_designator IN VARCHAR2
134 )
135 RETURN NUMBER;
136
137 -- ----------------------------------------------------------------------
138 FUNCTION Get_Rtg_Sequence_Id(
139 p_organization_id IN NUMBER,
140 p_assembly_item_id IN NUMBER,
141 p_alternate_rtg_designator IN VARCHAR2
142 )
143 RETURN NUMBER;
144
145 -- ----------------------------------------------------------------------
146 FUNCTION Get_Gen_Object_Id(
147 p_organization_id IN NUMBER,
148 p_inventory_item_id IN NUMBER,
149 p_serial_number IN VARCHAR2
150 )
151 RETURN NUMBER;
152
153 -- ----------------------------------------------------------------------
154 PROCEDURE Get_Item_Info_From_WO(
155 p_wip_entity_id IN NUMBER,
156 x_source_org_id OUT NOCOPY NUMBER,
157 x_source_activity_id OUT NOCOPY NUMBER,
158 x_wo_maint_id OUT NOCOPY NUMBER,
159 x_wo_maint_type OUT NOCOPY NUMBER
160 );
161
162 -- ----------------------------------------------------------------------
163 FUNCTION Default_Owning_Department_Id(
164 p_activity_association_id IN NUMBER,
165 p_instance_id IN NUMBER,
166 p_organization_id IN NUMBER
167 )
168 RETURN NUMBER;
169
170 -- ----------------------------------------------------------------------
171 FUNCTION Is_Item_Serialized(
172 p_organization_id IN NUMBER,
173 p_maint_id IN NUMBER,
174 p_maint_type IN NUMBER
175
176 )
177 RETURN BOOLEAN;
178
179 -- ----------------------------------------------------------------------
180 g_YES CONSTANT NUMBER := 1;
181 g_NO CONSTANT NUMBER := 2;
182
183 -- ----------------------------------------------------------------------
184 -- For logging
185 Debug_File UTL_FILE.FILE_TYPE;
186 -- If Is_Debug NULL, treat as g_NO
187 Is_Debug NUMBER := nvl(FND_PROFILE.VALUE('EAM_ABO_IS_DEBUG'), g_NO);
188 Debug_File_Name VARCHAR2(2000) := FND_PROFILE.VALUE('EAM_ABO_DEBUG_FILE_NAME');
189 Debug_File_Dir VARCHAR2(2000) := FND_PROFILE.VALUE('EAM_ABO_DEBUG_FILE_DIR');
190 Log_Index NUMBER := 1;
191
192 PROCEDURE Open_Debug_Session;
193 PROCEDURE Write_Debug(
194 p_debug_message IN VARCHAR2
195 );
196 PROCEDURE Close_Debug_Session;
197 PROCEDURE Add_Message(
198 p_message_level IN NUMBER
199 );
200 PROCEDURE Log_Item_Error_Tbl(
201 p_item_error_tbl IN INV_Item_GRP.Error_Tbl_Type
202 );
203 PROCEDURE Log_Bom_Error_Tbl(
204 p_bom_error_tbl IN Error_Handler.Error_Tbl_Type
205 );
206
207
208 PROCEDURE Log_Process_Rtg_Parameters(
209 p_rtg_header_rec IN BOM_RTG_PUB.Rtg_Header_Rec_Type,
210 p_operation_tbl IN BOM_RTG_PUB.Operation_Tbl_Type,
211 p_op_resource_tbl IN BOM_RTG_PUB.Op_Resource_Tbl_Type,
212 p_op_network_tbl IN BOM_RTG_PUB.Op_Network_Tbl_Type
213 );
214 PROCEDURE Log_Rtg_Header_Rec(
215 rtg_header_rec IN BOM_RTG_PUB.Rtg_Header_Rec_Type
216 );
217 PROCEDURE Log_Rtg_Operation_Tbl(
218 operation_tbl IN BOM_RTG_PUB.Operation_Tbl_Type
219 );
220 PROCEDURE Log_Rtg_Op_Resource_Tbl(
221 op_resource_tbl IN BOM_RTG_PUB.Op_Resource_Tbl_Type
222 );
223 PROCEDURE Log_Rtg_Op_Network_Tbl(
224 op_network_tbl IN BOM_RTG_PUB.Op_Network_Tbl_Type
225 );
226
227 PROCEDURE Log_Process_BOM_Parameters(
228 p_bom_header_rec IN BOM_BO_PUB.Bom_Head_Rec_Type,
229 p_bom_component_tbl IN BOM_BO_PUB.Bom_Comps_Tbl_Type
230 );
231 PROCEDURE Log_Bom_Header_Rec(
232 bom_header_rec IN BOM_BO_PUB.Bom_Head_Rec_Type
233 );
234 PROCEDURE Log_Bom_Component_Tbl(
235 bom_component_tbl IN BOM_BO_PUB.Bom_Comps_Tbl_Type
236 );
237
238 PROCEDURE Log_Inv_Item_Rec(
239 item_rec IN INV_Item_GRP.Item_rec_type
240 );
241
242 -- ----------------------------------------------------------------------
243 FUNCTION Get_First_N_Messages(
244 p_n IN NUMBER
245 )
246 RETURN VARCHAR2;
247
248 -- ----------------------------------------------------------------------
249 -- From Saurabh
250 -- specs in EAM_ACTIVITYUTILITIES_PVT
251 FUNCTION BOM_Exists(
252 p_org_id in number,
253 p_inventory_item_id in number
254 )
255 return boolean;
256
257 FUNCTION Routing_Exists(
258 p_org_id in number,
259 p_inventory_item_id in number
260 )
261 return boolean;
262
263
264 -- ----------------------------------------------------------------------
265 FUNCTION IS_ACTIVITY_ASSIGNED(
266 p_activity_id IN NUMBER,
267 p_org_id IN NUMBER
268 )
269 RETURN BOOLEAN;
270
271 -- ----------------------------------------------------------------------
272 -- To be used in Activity WB view
273 FUNCTION get_next_service_start_date
274 (
275 p_activity_association_id IN NUMBER,
276 p_maintenance_object_id IN NUMBER,
277 p_maintenance_object_type IN NUMBER := 3
278 )
279 RETURN DATE;
280
281 -- ----------------------------------------------------------------------
282 -- To be used in Activity WB view
283 FUNCTION get_next_service_end_date
284 (
285 p_activity_association_id IN NUMBER,
286 p_maintenance_object_id IN NUMBER,
287 p_maintenance_object_type IN NUMBER := 3
288 )
289 RETURN DATE;
290 -- ----------------------------------------------------------------------
291
292
293 -- End of Utility Procedures
294 -- ======================================================================
295
296 END EAM_ActivityUtilities_PVT;