[Home] [Help]
PACKAGE: APPS.EAM_FAILURE_ANALYSIS_PVT
Source
1 PACKAGE EAM_FAILURE_ANALYSIS_PVT AUTHID CURRENT_USER AS
2 /* $Header: EAMVFALS.pls 120.5 2012/01/27 10:52:01 vchidura ship $ */
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 P_CURRENT_ORG_ID IN NUMBER, --12581897
75 X_REF_FAILURES OUT NOCOPY SYS_REFCURSOR);
76
77 Procedure GET_FAILURE_RECS_CURSOR
78 ( P_WHERE_CLAUSE IN VARCHAR2,
79 P_FROM_DATE_CLAUSE IN VARCHAR2,
80 P_VIEW_BY IN NUMBER,
81 X_REF_FAILURES OUT NOCOPY SYS_REFCURSOR);
82
83 Procedure GET_HISTORY_RECORDS_SIMPLE
84 ( P_GEN_OBJECT_ID IN NUMBER,
85 P_FROM_DATE IN DATE,
86 P_TO_DATE IN DATE,
87 P_SELECTED_METER IN NUMBER,
88 P_CURRENT_ORG_ID IN NUMBER,
89 X_GROUP_ID OUT NOCOPY NUMBER,
90 x_return_status OUT NOCOPY VARCHAR2,
91 x_msg_count OUT NOCOPY NUMBER,
92 x_msg_data OUT NOCOPY VARCHAR2,
93 x_unmatched_uom_class OUT NOCOPY VARCHAR2,
94 x_unmatched_currency OUT NOCOPY VARCHAR2);
95
96
97 Procedure GET_HISTORY_RECORDS_FA_SIMPLE
98 ( P_GEN_OBJECT_ID IN NUMBER,
99 P_MAINT_GROUP_ID IN NUMBER,
100 P_CATEGORY_ID IN NUMBER,
101 P_FAILURE_CODE IN VARCHAR2,
102 P_FROM_DATE IN DATE,
103 P_TO_DATE IN DATE,
104 P_INCLUDE_CHILDREN IN VARCHAR2,
105 P_VIEW_BY IN VARCHAR2,
106 P_COMPUTE_REPAIR_COSTS IN VARCHAR2,
107 P_SELECTED_METER IN NUMBER,
108 P_CURRENT_ORG_ID IN NUMBER,
109 X_GROUP_ID OUT NOCOPY NUMBER,
110 x_return_status OUT NOCOPY VARCHAR2,
111 x_msg_count OUT NOCOPY NUMBER,
112 x_msg_data OUT NOCOPY VARCHAR2,
113 x_unmatched_uom_class OUT NOCOPY VARCHAR2,
114 x_unmatched_currency OUT NOCOPY VARCHAR2);
115
116
117 Procedure INSERT_INTO_TEMP_TABLE
118 ( p_group_id IN NUMBER,
119 P_ASSET_FAILURE_TBL IN eam_asset_failure_tbl_type);
120
121 Procedure COMPUTE_REPAIR_COSTS
122 ( P_GROUP_ID IN NUMBER);
123
124 PROCEDURE VALIDATE_RECORDS
125 ( P_ASSET_FAILURE_TBL IN OUT NOCOPY EAM_ASSET_FAILURE_TBL_TYPE,
126 P_VALIDATE_METERS IN VARCHAR2,
127 P_VALIDATE_CURRENCY IN VARCHAR2,
128 P_CURRENT_ORG_ID IN NUMBER,
129 x_unmatched_uom_class OUT NOCOPY VARCHAR2,
130 x_unmatched_currency OUT NOCOPY VARCHAR2);
131
132 /* Following procedures added for Include Children functionality :Failure Analysis Page*/
133 Procedure GET_CHILD_RECORDS_FA_SIMPLE
134 ( P_GEN_OBJECT_ID IN NUMBER,
135 P_MAINT_GROUP_ID IN NUMBER,
136 P_CATEGORY_ID IN NUMBER,
137 P_FAILURE_CODE IN VARCHAR2,
138 P_FROM_DATE IN DATE,
139 P_TO_DATE IN DATE,
140 P_VIEW_BY IN VARCHAR2,
141 P_COMPUTE_REPAIR_COSTS IN VARCHAR2,
142 P_CURRENT_ORG_ID IN NUMBER,
143 x_group_id IN OUT NOCOPY NUMBER,
144 x_return_status OUT NOCOPY VARCHAR2,
145 x_msg_data OUT NOCOPY VARCHAR2,
146 x_unmatched_uom_class OUT NOCOPY VARCHAR2,
147 x_unmatched_currency OUT NOCOPY VARCHAR2);
148
149 Procedure GET_CHILD_RECORDS_FA_ADV
150 ( P_WHERE_CLAUSE IN VARCHAR2,
151 P_WHERE_CLAUSE_1 IN VARCHAR2,
152 P_FROM_DATE_CLAUSE IN VARCHAR2,
153 P_VIEW_BY IN VARCHAR2,
154 P_COMPUTE_REPAIR_COSTS IN VARCHAR2,
155 P_CURRENT_ORG_ID IN NUMBER,
156 x_group_id IN OUT NOCOPY NUMBER,
157 x_return_status OUT NOCOPY VARCHAR2,
158 x_msg_data OUT NOCOPY VARCHAR2,
159 x_unmatched_uom_class OUT NOCOPY VARCHAR2,
160 x_unmatched_currency OUT NOCOPY VARCHAR2);
161
162 PROCEDURE GET_CHILD_RECS_CURSOR
163 ( p_where_clause IN VARCHAR2,
164 p_where_clause_1 IN VARCHAR2,
165 p_from_date_clause IN VARCHAR2,
166 p_view_by IN VARCHAR2,
167 P_ORG_ID IN VARCHAR2,
168 x_ref_failures OUT NOCOPY SYS_REFCURSOR);
169
170 PROCEDURE GET_CHILD_METER_RECS_CURSOR
171 ( P_WHERE_CLAUSE IN VARCHAR2,
172 P_WHERE_CLAUSE_1 IN VARCHAR2,
173 P_FROM_DATE_CLAUSE IN VARCHAR2,
174 P_VIEW_BY IN VARCHAR2,
175 P_ORG_ID IN VARCHAR2,
176 X_REF_FAILURES OUT NOCOPY SYS_REFCURSOR);
177
178
179 END EAM_FAILURE_ANALYSIS_PVT;
180