[Home] [Help]
PACKAGE: APPS.EAM_FAILURE_ANALYSIS_PVT
Source
1 PACKAGE EAM_FAILURE_ANALYSIS_PVT AS
2 /* $Header: EAMVFALS.pls 120.2 2006/10/05 07:31:43 amourya noship $ */
3
4 Type eam_asset_failure_rec_type is record
5 ( ASSET_TYPE NUMBER ,
6 MAINTENANCE_OBJECT_ID NUMBER ,
7 MAINTAINED_NUMBER VARCHAR2(30) ,
8 DESCRIPTIVE_TEXT VARCHAR2(240) ,
9 MAINTAINED_GROUP VARCHAR2(40) ,
10 MAINTAINED_GROUP_ID NUMBER ,
11 WIP_ENTITY_ID NUMBER ,
12 WIP_ENTITY_NAME VARCHAR2(240) ,
13 ORGANIZATION_ID NUMBER ,
14 ORGANIZATION_CODE VARCHAR2(3) ,
15 ASSET_CATEGORY VARCHAR2(163) ,
16 ASSET_CATEGORY_ID NUMBER ,
17 ASSET_LOCATION VARCHAR2(30) ,
18 OWNING_DEPARTMENT VARCHAR2(10) ,
19 FAILURE_CODE VARCHAR2(80) ,
20 CAUSE_CODE VARCHAR2(80) ,
21 RESOLUTION_CODE VARCHAR2(80) ,
22 FAILURE_DATE DATE ,
23 COMMENTS VARCHAR2(2000) ,
24 DAYS_BETWEEN_FAILURES NUMBER ,
25 TIME_TO_REPAIR NUMBER ,
26 METER_ID NUMBER ,
27 METER_NAME VARCHAR2(50) ,
28 METER_UOM VARCHAR2(3) ,
29 READING_BETWEEN_FAILURES NUMBER ,
30 INCLUDE_FOR_READING_AGGR VARCHAR2(1) ,
31 INCLUDE_FOR_COST_AGGR VARCHAR2(1)
32 );
33
34
35 Type eam_asset_failure_tbl_type is table of eam_asset_failure_rec_type
36 INDEX BY BINARY_INTEGER;
37
38 TYPE children_assets_tbl_type is table of number INDEX BY BINARY_INTEGER;
39
40 Procedure GET_HISTORY_RECORDS_ADV
41 ( P_WHERE_CLAUSE IN VARCHAR2,
42 P_FROM_DATE_CLAUSE IN VARCHAR2,
43 P_SELECTED_METER IN NUMBER,
44 P_CURRENT_ORG_ID IN NUMBER,
45 X_GROUP_ID OUT NOCOPY NUMBER,
46 x_return_status OUT NOCOPY VARCHAR2,
47 x_msg_count OUT NOCOPY NUMBER,
48 x_msg_data OUT NOCOPY VARCHAR2,
49 x_unmatched_uom_class OUT NOCOPY VARCHAR2,
50 x_unmatched_currency OUT NOCOPY VARCHAR2);
51
52 Procedure GET_HISTORY_RECORDS_FA_ADV
53 ( P_WHERE_CLAUSE IN VARCHAR2,
54 P_WHERE_CLAUSE_1 IN VARCHAR2,
55 P_FROM_DATE_CLAUSE IN VARCHAR2,
56 P_SELECTED_METER IN NUMBER,
57 P_INCLUDE_CHILDREN IN VARCHAR2,
58 P_VIEW_BY IN VARCHAR2,
59 P_COMPUTE_REPAIR_COSTS IN VARCHAR2,
60 P_CURRENT_ORG_ID IN VARCHAR2,
61 X_GROUP_ID OUT NOCOPY NUMBER,
62 x_return_status OUT NOCOPY VARCHAR2,
63 x_msg_count OUT NOCOPY NUMBER,
64 x_msg_data OUT NOCOPY VARCHAR2,
65 x_unmatched_uom_class OUT NOCOPY VARCHAR2,
66 x_unmatched_currency OUT NOCOPY VARCHAR2);
67
68
69 Procedure GET_FAILURE_METER_RECS_CURSOR
70 ( P_WHERE_CLAUSE IN VARCHAR2,
71 P_SELECTED_METER IN NUMBER,
72 P_FROM_DATE_CLAUSE IN VARCHAR2,
73 P_VIEW_BY IN NUMBER,
74 X_REF_FAILURES OUT NOCOPY SYS_REFCURSOR);
75
76 Procedure GET_FAILURE_RECS_CURSOR
77 ( P_WHERE_CLAUSE IN VARCHAR2,
78 P_FROM_DATE_CLAUSE IN VARCHAR2,
79 P_VIEW_BY IN NUMBER,
80 X_REF_FAILURES OUT NOCOPY SYS_REFCURSOR);
81
82 Procedure GET_HISTORY_RECORDS_SIMPLE
83 ( P_GEN_OBJECT_ID IN NUMBER,
84 P_FROM_DATE IN DATE,
85 P_TO_DATE IN DATE,
86 P_SELECTED_METER IN NUMBER,
87 P_CURRENT_ORG_ID IN NUMBER,
88 X_GROUP_ID OUT NOCOPY NUMBER,
89 x_return_status OUT NOCOPY VARCHAR2,
90 x_msg_count OUT NOCOPY NUMBER,
91 x_msg_data OUT NOCOPY VARCHAR2,
92 x_unmatched_uom_class OUT NOCOPY VARCHAR2,
93 x_unmatched_currency OUT NOCOPY VARCHAR2);
94
95
96 Procedure GET_HISTORY_RECORDS_FA_SIMPLE
97 ( P_GEN_OBJECT_ID IN NUMBER,
98 P_MAINT_GROUP_ID IN NUMBER,
99 P_CATEGORY_ID IN NUMBER,
100 P_FAILURE_CODE IN VARCHAR2,
101 P_FROM_DATE IN DATE,
102 P_TO_DATE IN DATE,
103 P_INCLUDE_CHILDREN IN VARCHAR2,
104 P_VIEW_BY IN VARCHAR2,
105 P_COMPUTE_REPAIR_COSTS IN VARCHAR2,
106 P_SELECTED_METER IN NUMBER,
107 P_CURRENT_ORG_ID IN NUMBER,
108 X_GROUP_ID OUT NOCOPY NUMBER,
109 x_return_status OUT NOCOPY VARCHAR2,
110 x_msg_count OUT NOCOPY NUMBER,
111 x_msg_data OUT NOCOPY VARCHAR2,
112 x_unmatched_uom_class OUT NOCOPY VARCHAR2,
113 x_unmatched_currency OUT NOCOPY VARCHAR2);
114
115
116 Procedure INSERT_INTO_TEMP_TABLE
117 ( p_group_id IN NUMBER,
118 P_ASSET_FAILURE_TBL IN eam_asset_failure_tbl_type);
119
120 Procedure COMPUTE_REPAIR_COSTS
121 ( P_GROUP_ID IN NUMBER);
122
123 PROCEDURE VALIDATE_RECORDS
124 ( P_ASSET_FAILURE_TBL IN OUT NOCOPY EAM_ASSET_FAILURE_TBL_TYPE,
125 P_VALIDATE_METERS IN VARCHAR2,
126 P_VALIDATE_CURRENCY IN VARCHAR2,
127 P_CURRENT_ORG_ID IN NUMBER,
128 x_unmatched_uom_class OUT NOCOPY VARCHAR2,
129 x_unmatched_currency OUT NOCOPY VARCHAR2);
130
131 /* Following procedures added for Include Children functionality :Failure Analysis Page*/
132 Procedure GET_CHILD_RECORDS_FA_SIMPLE
133 ( P_GEN_OBJECT_ID IN NUMBER,
134 P_MAINT_GROUP_ID IN NUMBER,
135 P_CATEGORY_ID IN NUMBER,
136 P_FAILURE_CODE IN VARCHAR2,
137 P_FROM_DATE IN DATE,
138 P_TO_DATE IN DATE,
139 P_VIEW_BY IN VARCHAR2,
140 P_COMPUTE_REPAIR_COSTS IN VARCHAR2,
141 P_CURRENT_ORG_ID IN NUMBER,
142 x_group_id IN OUT NOCOPY NUMBER,
143 x_return_status OUT NOCOPY VARCHAR2,
144 x_msg_data OUT NOCOPY VARCHAR2,
145 x_unmatched_uom_class OUT NOCOPY VARCHAR2,
146 x_unmatched_currency OUT NOCOPY VARCHAR2);
147
148 Procedure GET_CHILD_RECORDS_FA_ADV
149 ( P_WHERE_CLAUSE IN VARCHAR2,
150 P_WHERE_CLAUSE_1 IN VARCHAR2,
151 P_FROM_DATE_CLAUSE IN VARCHAR2,
152 P_VIEW_BY IN VARCHAR2,
153 P_COMPUTE_REPAIR_COSTS IN VARCHAR2,
154 P_CURRENT_ORG_ID IN NUMBER,
155 x_group_id IN OUT NOCOPY NUMBER,
156 x_return_status OUT NOCOPY VARCHAR2,
157 x_msg_data OUT NOCOPY VARCHAR2,
158 x_unmatched_uom_class OUT NOCOPY VARCHAR2,
159 x_unmatched_currency OUT NOCOPY VARCHAR2);
160
161 PROCEDURE GET_CHILD_RECS_CURSOR
162 ( p_where_clause IN VARCHAR2,
163 p_where_clause_1 IN VARCHAR2,
164 p_from_date_clause IN VARCHAR2,
165 p_view_by IN VARCHAR2,
166 P_ORG_ID IN VARCHAR2,
167 x_ref_failures OUT NOCOPY SYS_REFCURSOR);
168
169 PROCEDURE GET_CHILD_METER_RECS_CURSOR
170 ( P_WHERE_CLAUSE IN VARCHAR2,
171 P_WHERE_CLAUSE_1 IN VARCHAR2,
172 P_FROM_DATE_CLAUSE IN VARCHAR2,
173 P_VIEW_BY IN VARCHAR2,
174 P_ORG_ID IN VARCHAR2,
175 X_REF_FAILURES OUT NOCOPY SYS_REFCURSOR);
176
177
178 END EAM_FAILURE_ANALYSIS_PVT;
179