eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.EAM_ACTIVITYUTILITIES_PVT

Source


1 PACKAGE EAM_ActivityUtilities_PVT 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;