1 PACKAGE EAM_ITEM_ACTIVITIES_PUB AS
2 /* $Header: EAMPIAAS.pls 120.0 2005/05/25 15:44:59 appldev noship $ */
3 /*#
4 * This package is used for the INSERT / UPDATE of Asset Activity association.
5 * It defines 2 key procedures insert_item_activities, update_item_activities
6 * which first validates and massages the IN parameters
7 * and then carries out the respective operations.
8 * @rep:scope public
9 * @rep:product EAM
10 * @rep:lifecycle active
11 * @rep:displayname Asset Activity
12 * @rep:category BUSINESS_ENTITY EAM_ASSET_ACTIVITY_ASSOCIATION
13 */
14
15
16 /*#
17 * This procedure is used to insert records in MTL_EAM_ASSET_ACTIVITIES .
18 * It is used to create asset activity association.
19 * @param p_api_version Version of the API
20 * @param p_init_msg_list Flag to indicate initialization of message list
21 * @param p_commit Flag to indicate whether API should commit changes
22 * @param p_validation_level Validation Level of the API
23 * @param x_return_status Return status of the procedure call
24 * @param x_msg_count Count of the return messages that API returns
25 * @param x_msg_data The collection of the messages.
26 * @param P_ASSET_ACTIVITY_ID Asset Activity identifier
27 * @param P_INVENTORY_ITEM_ID Inventory Item identifier of the asset group
28 * @param P_ORGANIZATION_ID EAM Organization Identifier
29 * @param P_OWNINGDEPARTMENT_ID Asset owning department identifier
30 * @param P_MAINTENANCE_OBJECT_ID Maintenance Object Identifier
31 * @param P_CREATION_ORGANIZATION_ID Creation Organization identifier
32 * @param P_START_DATE_ACTIVE Effective start date of the association
33 * @param P_END_DATE_ACTIVE Effective end date of the association
34 * @param P_PRIORITY_CODE Prority Of the asset activity
35 * @param P_ACTIVITY_CAUSE_CODE Cause code for asset activity
36 * @param P_ACTIVITY_TYPE_CODE Type of asset activity
37 * @param P_SHUTDOWN_TYPE_CODE Asset shutdown type code
38 * @param P_MAINTENANCE_OBJECT_TYPE Maintenance Object Type
39 * @param P_TMPL_FLAG Flag indicating whether this record is a template associaiton
40 * @param P_CLASS_CODE Accounting class code for asset activity association
41 * @param P_ACTIVITY_SOURCE_CODE Activity Source
42 * @param P_SERIAL_NUMBER Asset Number
43 * @param p_attribute_category Attribute Category
44 * @param p_attribute1 Descriptive flexfield column
45 * @param p_attribute2 Descriptive flexfield column
46 * @param p_attribute3 Descriptive flexfield column
47 * @param p_attribute4 Descriptive flexfield column
48 * @param p_attribute5 Descriptive flexfield column
49 * @param p_attribute6 Descriptive flexfield column
50 * @param p_attribute7 Descriptive flexfield column
51 * @param p_attribute8 Descriptive flexfield column
52 * @param p_attribute9 Descriptive flexfield column
53 * @param p_attribute10 Descriptive flexfield column
54 * @param p_attribute11 Descriptive flexfield column
55 * @param p_attribute12 Descriptive flexfield column
56 * @param p_attribute13 Descriptive flexfield column
57 * @param p_attribute14 Descriptive flexfield column
58 * @param p_attribute15 Descriptive flexfield column
59 * @param P_TAGGING_REQUIRED_FLAG Flag indicating whether tag out required for this activity
60 * @param P_LAST_SERVICE_START_DATE The start date when the activity was last performed
61 * @param P_LAST_SERVICE_END_DATE The end date when the activity was last performed
62 * @param P_PREV_SERVICE_START_DATE Start date when activity was performed prior to last service
63 * @param P_PREV_SERVICE_END_DATE End date when activity was performed prior to last service
64 * @param P_LAST_SCHEDULED_START_DATE The start date when the activity was last scheduled
65 * @param P_LAST_SCHEDULED_END_DATE The end date when the activity was last scheduled
66 * @param P_PREV_SCHEDULED_START_DATE Start date when activity was scheduled prior to last service
67 * @param P_PREV_SCHEDULED_END_DATE End date when activity was scheduled prior to last service
68 * @param P_WIP_ENTITY_ID Work Order Identifier
69 * @param P_SOURCE_TMPL_ID Asset Activity Template Identifier from which this association is created
70 * @param p_pm_last_service_tbl PL SQL table type of last service associated with this asset activity combination
71 * @return Returns the status of the procedure call as well as the return messages
72 * @rep:scope public
73 * @rep:displayname Create Asset Activity Association
74 */
75
76 PROCEDURE insert_item_activities
77 (
78 p_api_version IN NUMBER ,
79 p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE ,
80 p_commit IN VARCHAR2:= FND_API.G_FALSE ,
81 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
82 x_return_status OUT NOCOPY VARCHAR2 ,
83 x_msg_count OUT NOCOPY NUMBER ,
84 x_msg_data OUT NOCOPY VARCHAR2 ,
85
86 P_ASSET_ACTIVITY_ID IN NUMBER ,
87 /*P_INVENTORY_ITEM_ID IN NUMBER ,*/
88 P_INVENTORY_ITEM_ID IN NUMBER default null,
89 P_ORGANIZATION_ID IN NUMBER default null,
90 P_OWNINGDEPARTMENT_ID IN NUMBER default null,
91 P_MAINTENANCE_OBJECT_ID IN NUMBER default null,
92 P_CREATION_ORGANIZATION_ID IN NUMBER default null,
93 P_START_DATE_ACTIVE IN DATE default null ,
94 P_END_DATE_ACTIVE IN DATE default null ,
95 P_PRIORITY_CODE IN VARCHAR2 default null ,
96 P_ACTIVITY_CAUSE_CODE IN VARCHAR2 default null,
97 P_ACTIVITY_TYPE_CODE IN VARCHAR2 default null ,
98 P_SHUTDOWN_TYPE_CODE IN VARCHAR2 default null ,
99 P_MAINTENANCE_OBJECT_TYPE IN NUMBER default null ,
100 P_TMPL_FLAG IN VARCHAR2 default null ,
101 P_CLASS_CODE IN VARCHAR2 default null,
102 P_ACTIVITY_SOURCE_CODE IN VARCHAR2 default null,
103 P_SERIAL_NUMBER IN VARCHAR2 default null ,
104 P_ATTRIBUTE_CATEGORY IN VARCHAR2 default null ,
105 P_ATTRIBUTE1 IN VARCHAR2 default null ,
106 P_ATTRIBUTE2 IN VARCHAR2 default null ,
107 P_ATTRIBUTE3 IN VARCHAR2 default null ,
108 P_ATTRIBUTE4 IN VARCHAR2 default null ,
109 P_ATTRIBUTE5 IN VARCHAR2 default null ,
110 P_ATTRIBUTE6 IN VARCHAR2 default null ,
111 P_ATTRIBUTE7 IN VARCHAR2 default null ,
112 P_ATTRIBUTE8 IN VARCHAR2 default null ,
113 P_ATTRIBUTE9 IN VARCHAR2 default null ,
114 P_ATTRIBUTE10 IN VARCHAR2 default null ,
115 P_ATTRIBUTE11 IN VARCHAR2 default null ,
116 P_ATTRIBUTE12 IN VARCHAR2 default null ,
117 P_ATTRIBUTE13 IN VARCHAR2 default null ,
118 P_ATTRIBUTE14 IN VARCHAR2 default null ,
119 P_ATTRIBUTE15 IN VARCHAR2 default null ,
120 P_TAGGING_REQUIRED_FLAG IN VARCHAR2 default null ,
121 P_LAST_SERVICE_START_DATE IN DATE default null ,
122 P_LAST_SERVICE_END_DATE IN DATE default null ,
123 P_PREV_SERVICE_START_DATE IN DATE default null ,
124 P_PREV_SERVICE_END_DATE IN DATE default null ,
125 P_LAST_SCHEDULED_START_DATE IN DATE default null ,
126 P_LAST_SCHEDULED_END_DATE IN DATE default null ,
127 P_PREV_SCHEDULED_START_DATE IN DATE default null ,
128 P_PREV_SCHEDULED_END_DATE IN DATE default null ,
129 P_WIP_ENTITY_ID IN NUMBER default null ,
130 P_SOURCE_TMPL_ID IN NUMBER default null ,
131 p_pm_last_service_tbl IN EAM_PM_LAST_SERVICE_PUB.pm_last_service_tbl
132
133
134 );
135
136 /*#
137 * This procedure is used to update the existing records in MTL_EAM_ASSET_ACTIVITIES .
138 * It is used to update asset activity association.
139 * @param p_api_version Version of the API
140 * @param p_init_msg_list Flag to indicate initialization of message list
141 * @param p_commit Flag to indicate whether API should commit changes
142 * @param p_validation_level Validation Level of the API
143 * @param x_return_status Return status of the procedure call
144 * @param x_msg_count Count of the return messages that API returns
145 * @param x_msg_data The collection of the messages.
146 * @param P_ACTIVITY_ASSOCIATION_ID Asset activity association identifier
147 * @param P_ASSET_ACTIVITY_ID Asset Activity identifier
148 * @param P_INVENTORY_ITEM_ID Inventory Item identifier of the asset group
149 * @param P_ORGANIZATION_ID EAM Organization Identifier
150 * @param P_OWNINGDEPARTMENT_ID Asset owning department identifier
151 * @param P_MAINTENANCE_OBJECT_ID Maintenance Object Identifier
152 * @param P_CREATION_ORGANIZATION_ID Creation Organization Identifier
153 * @param P_START_DATE_ACTIVE Effective start date of the association
154 * @param P_END_DATE_ACTIVE Effective end date of the association
155 * @param P_PRIORITY_CODE Prority Of the asset activity
156 * @param P_ACTIVITY_CAUSE_CODE Cause code for asset activity
157 * @param P_ACTIVITY_TYPE_CODE Type of asset activity
158 * @param P_SHUTDOWN_TYPE_CODE Asset shutdown type code
159 * @param P_MAINTENANCE_OBJECT_TYPE Maintenance Object Type
160 * @param P_TMPL_FLAG Flag indicating whether this record is a template associaiton
161 * @param P_CLASS_CODE Accounting class code for asset activity association
162 * @param P_ACTIVITY_SOURCE_CODE Activity Source
163 * @param P_SERIAL_NUMBER Asset Number
164 * @param p_attribute_category Attribute Category
165 * @param p_attribute1 Descriptive flexfield column
166 * @param p_attribute2 Descriptive flexfield column
167 * @param p_attribute3 Descriptive flexfield column
168 * @param p_attribute4 Descriptive flexfield column
169 * @param p_attribute5 Descriptive flexfield column
170 * @param p_attribute6 Descriptive flexfield column
171 * @param p_attribute7 Descriptive flexfield column
172 * @param p_attribute8 Descriptive flexfield column
173 * @param p_attribute9 Descriptive flexfield column
174 * @param p_attribute10 Descriptive flexfield column
175 * @param p_attribute11 Descriptive flexfield column
176 * @param p_attribute12 Descriptive flexfield column
177 * @param p_attribute13 Descriptive flexfield column
178 * @param p_attribute14 Descriptive flexfield column
179 * @param p_attribute15 Descriptive flexfield column
180 * @param P_TAGGING_REQUIRED_FLAG Flag indicating whether tag out required for this activity
181 * @param P_LAST_SERVICE_START_DATE The start date when the activity was last performed
182 * @param P_LAST_SERVICE_END_DATE The end date when the activity was last performed
183 * @param P_PREV_SERVICE_START_DATE Start date when activity was performed prior to last service
187 * @param P_PREV_SCHEDULED_START_DATE Start date when activity was scheduled prior to last service
184 * @param P_PREV_SERVICE_END_DATE End date when activity was performed prior to last service
185 * @param P_LAST_SCHEDULED_START_DATE The start date when the activity was last scheduled
186 * @param P_LAST_SCHEDULED_END_DATE The end date when the activity was last scheduled
188 * @param P_PREV_SCHEDULED_END_DATE End date when activity was scheduled prior to last service
189 * @param P_WIP_ENTITY_ID Work Order Identifier
190 * @param P_SOURCE_TMPL_ID Asset Activity Template Identifier from which this association is created
191 * @param p_pm_last_service_tbl PL SQL table type of last service associated with this asset activity combination
192 * @return Returns the status of the procedure call as well as the return messages
193 * @rep:scope public
194 * @rep:displayname Update Asset Activity Association
195 */
196
197 PROCEDURE update_item_activities
198 (
199 p_api_version IN NUMBER ,
200 p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE ,
201 p_commit IN VARCHAR2:= FND_API.G_FALSE ,
202 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
203 x_return_status OUT NOCOPY VARCHAR2 ,
204 x_msg_count OUT NOCOPY NUMBER ,
205 x_msg_data OUT NOCOPY VARCHAR2 ,
206
207 P_ACTIVITY_ASSOCIATION_ID IN NUMBER ,
208 P_ASSET_ACTIVITY_ID IN NUMBER ,
209 P_INVENTORY_ITEM_ID IN NUMBER default null,
210 P_ORGANIZATION_ID IN NUMBER default null,
211 P_OWNINGDEPARTMENT_ID IN NUMBER default null,
212 P_MAINTENANCE_OBJECT_ID IN NUMBER default null,
213 P_CREATION_ORGANIZATION_ID IN NUMBER default null ,
214 P_START_DATE_ACTIVE IN DATE default null ,
215 P_END_DATE_ACTIVE IN DATE default null ,
216 P_PRIORITY_CODE IN VARCHAR2 default null ,
217 P_ACTIVITY_CAUSE_CODE IN VARCHAR2 default null,
218 P_ACTIVITY_TYPE_CODE IN VARCHAR2 default null ,
219 P_SHUTDOWN_TYPE_CODE IN VARCHAR2 default null ,
220 P_MAINTENANCE_OBJECT_TYPE IN NUMBER default null ,
221 P_TMPL_FLAG IN VARCHAR2 default null ,
222 P_CLASS_CODE IN VARCHAR2 default null,
223 P_ACTIVITY_SOURCE_CODE IN VARCHAR2 default null,
224 P_SERIAL_NUMBER IN VARCHAR2 default null ,
225 P_ATTRIBUTE_CATEGORY IN VARCHAR2 default null ,
226 P_ATTRIBUTE1 IN VARCHAR2 default null ,
227 P_ATTRIBUTE2 IN VARCHAR2 default null ,
228 P_ATTRIBUTE3 IN VARCHAR2 default null ,
229 P_ATTRIBUTE4 IN VARCHAR2 default null ,
230 P_ATTRIBUTE5 IN VARCHAR2 default null ,
231 P_ATTRIBUTE6 IN VARCHAR2 default null ,
232 P_ATTRIBUTE7 IN VARCHAR2 default null ,
233 P_ATTRIBUTE8 IN VARCHAR2 default null ,
237 P_ATTRIBUTE12 IN VARCHAR2 default null ,
234 P_ATTRIBUTE9 IN VARCHAR2 default null ,
235 P_ATTRIBUTE10 IN VARCHAR2 default null ,
236 P_ATTRIBUTE11 IN VARCHAR2 default null ,
238 P_ATTRIBUTE13 IN VARCHAR2 default null ,
239 P_ATTRIBUTE14 IN VARCHAR2 default null ,
240 P_ATTRIBUTE15 IN VARCHAR2 default null ,
241 P_TAGGING_REQUIRED_FLAG IN VARCHAR2 default null ,
242 P_LAST_SERVICE_START_DATE IN DATE default null ,
243 P_LAST_SERVICE_END_DATE IN DATE default null ,
244 P_PREV_SERVICE_START_DATE IN DATE default null ,
245 P_PREV_SERVICE_END_DATE IN DATE default null ,
246 P_LAST_SCHEDULED_START_DATE IN DATE default null ,
247 P_LAST_SCHEDULED_END_DATE IN DATE default null ,
248 P_PREV_SCHEDULED_START_DATE IN DATE default null ,
249 P_PREV_SCHEDULED_END_DATE IN DATE default null ,
250 P_WIP_ENTITY_ID IN NUMBER default null ,
251 P_SOURCE_TMPL_ID IN NUMBER default null ,
252 p_pm_last_service_tbl IN EAM_PM_LAST_SERVICE_PUB.pm_last_service_tbl
253
254 );
255
256 END;