1 PACKAGE EAM_MeterAssoc_PUB AS
2 /* $Header: EAMPAMAS.pls 120.2 2006/02/17 15:33:04 hkarmach noship $ */
3 /*#
4 * This package is used for the INSERT of Asset Meters Association.
5 * It defines a key procedure Insert_AssetMeterAssoc
6 * which first validates and massages the IN parameters
7 * and then carries out the insert. This API do not support update.
8 * @rep:scope public
9 * @rep:product EAM
10 * @rep:lifecycle active
11 * @rep:displayname Asset Meter
12 * @rep:category BUSINESS_ENTITY EAM_ASSET_METER
13 */
14
15 G_PKG_NAME CONSTANT VARCHAR2(30):='EAM_MeterAssoc_PUB';
16
17
18 /*#
19 * This procedure is used to create Asset Meter Association.
20 * @param p_api_version Version of the API
21 * @param p_init_msg_list Flag to indicate initialization of message list
22 * @param p_commit Flag to indicate whether API should commit changes
23 * @param p_validation_level Validation Level of the API
24 * @param x_return_status Return status of the procedure call
25 * @param x_msg_count Count of the return messages that API returns
26 * @param x_msg_data The collection of the messages.
27 * @param p_meter_id Meter Identifier
28 * @param p_organization_id Organization Identifier of Asset Group
29 * @param p_asset_group_id Asset Group Identifier
30 * @param p_asset_number Asset Number
31 * @param p_maintenance_object_type Maintenance Object Type
32 * @param p_maintenance_object_id Maitenance Object Identifier
33 * @param p_attribute_category Descriptive Flexfield Column
34 * @param p_attribute1 Descriptive Flexfield Column
35 * @param p_attribute2 Descriptive Flexfield Column
36 * @param p_attribute3 Descriptive Flexfield Column
37 * @param p_attribute4 Descriptive Flexfield Column
38 * @param p_attribute5 Descriptive Flexfield Column
39 * @param p_attribute6 Descriptive Flexfield Column
40 * @param p_attribute7 Descriptive Flexfield Column
41 * @param p_attribute8 Descriptive Flexfield Column
42 * @param p_attribute9 Descriptive Flexfield Column
43 * @param p_attribute10 Descriptive Flexfield Column
44 * @param p_attribute11 Descriptive Flexfield Column
45 * @param p_attribute12 Descriptive Flexfield Column
46 * @param p_attribute13 Descriptive Flexfield Column
47 * @param p_attribute14 Descriptive Flexfield Column
48 * @param p_attribute15 Descriptive Flexfield Column
49 * @param p_start_date_active Start Date Active for the association
50 * @param p_end_date_active End Date Active for the association
51 * @return Returns the status of the procedure call as well as the return messages
52 * @rep:scope public
53 * @rep:displayname Insert Asset Meter Associations
54 */
55
56
57 PROCEDURE Insert_AssetMeterAssoc
58 (
59 p_api_version IN Number,
60 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
61 p_commit IN VARCHAR2 := FND_API.G_FALSE,
62 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
63 x_return_status OUT NOCOPY VARCHAR2,
64 x_msg_count OUT NOCOPY Number,
65 x_msg_data OUT NOCOPY VARCHAR2,
66 p_meter_id IN Number,
67 p_organization_id IN NUMBER DEFAULT NULL,
68 p_asset_group_id IN NUMBER DEFAULT NULL,
69 p_asset_number IN VARCHAR2 DEFAULT NULL,
70 p_maintenance_object_type IN NUMBER DEFAULT NULL,
71 p_maintenance_object_id IN NUMBER DEFAULT NULL,
72 p_primary_failure_flag IN VARCHAR2 DEFAULT 'N',
73 p_ATTRIBUTE_CATEGORY IN VARCHAR2 default null,
74 p_ATTRIBUTE1 IN VARCHAR2 default null,
75 p_ATTRIBUTE2 IN VARCHAR2 default null,
76 p_ATTRIBUTE3 IN VARCHAR2 default null,
77 p_ATTRIBUTE4 IN VARCHAR2 default null,
78 p_ATTRIBUTE5 IN VARCHAR2 default null,
79 p_ATTRIBUTE6 IN VARCHAR2 default null,
80 p_ATTRIBUTE7 IN VARCHAR2 default null,
81 p_ATTRIBUTE8 IN VARCHAR2 default null,
82 p_ATTRIBUTE9 IN VARCHAR2 default null,
83 p_ATTRIBUTE10 IN VARCHAR2 default null,
84 p_ATTRIBUTE11 IN VARCHAR2 default null,
85 p_ATTRIBUTE12 IN VARCHAR2 default null,
86 p_ATTRIBUTE13 IN VARCHAR2 default null,
87 p_ATTRIBUTE14 IN VARCHAR2 default null,
88 p_ATTRIBUTE15 IN VARCHAR2 default null,
89 p_start_date_active IN DATE default NULL,
90 p_end_date_active IN DATE default null
91 );
92
93
94
95 /*#
96 * This procedure is used to update Asset Meter Association.
97 * @param p_api_version Version of the API
98 * @param p_init_msg_list Flag to indicate initialization of message list
99 * @param p_commit Flag to indicate whether API should commit changes
100 * @param p_validation_level Validation Level of the API
101 * @param x_return_status Return status of the procedure call
102 * @param x_msg_count Count of the return messages that API returns
103 * @param x_msg_data The collection of the messages.
104 * @param p_association_id The Association Id that has to be updated
105 * @param p_attribute_category Descriptive Flexfield Column
106 * @param p_attribute1 Descriptive Flexfield Column
107 * @param p_attribute2 Descriptive Flexfield Column
108 * @param p_attribute3 Descriptive Flexfield Column
109 * @param p_attribute4 Descriptive Flexfield Column
110 * @param p_attribute5 Descriptive Flexfield Column
111 * @param p_attribute6 Descriptive Flexfield Column
112 * @param p_attribute7 Descriptive Flexfield Column
113 * @param p_attribute8 Descriptive Flexfield Column
114 * @param p_attribute9 Descriptive Flexfield Column
115 * @param p_attribute10 Descriptive Flexfield Column
116 * @param p_attribute11 Descriptive Flexfield Column
117 * @param p_attribute12 Descriptive Flexfield Column
118 * @param p_attribute13 Descriptive Flexfield Column
119 * @param p_attribute14 Descriptive Flexfield Column
120 * @param p_attribute15 Descriptive Flexfield Column
121 * @param p_end_date_active End Date Active
122 * @param p_tmpl_flag Flag indicating whether the association is for a template meter or not
123 * @return Returns the status of the procedure call as well as the return messages
124 * @rep:scope public
125 * @rep:displayname Update Asset Meter Associations
126 */
127
128 PROCEDURE Update_AssetMeterAssoc
129 (
130 p_api_version IN Number,
131 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
132 p_commit IN VARCHAR2 := FND_API.G_FALSE,
133 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
134 x_return_status OUT NOCOPY VARCHAR2,
135 x_msg_count OUT NOCOPY Number,
136 x_msg_data OUT NOCOPY VARCHAR2,
137 p_association_id IN Number,
138 p_primary_failure_flag IN VARCHAR2 DEFAULT 'N',
139 p_ATTRIBUTE_CATEGORY IN VARCHAR2 default null,
140 p_ATTRIBUTE1 IN VARCHAR2 default null,
141 p_ATTRIBUTE2 IN VARCHAR2 default null,
142 p_ATTRIBUTE3 IN VARCHAR2 default null,
143 p_ATTRIBUTE4 IN VARCHAR2 default null,
144 p_ATTRIBUTE5 IN VARCHAR2 default null,
145 p_ATTRIBUTE6 IN VARCHAR2 default null,
146 p_ATTRIBUTE7 IN VARCHAR2 default null,
147 p_ATTRIBUTE8 IN VARCHAR2 default null,
148 p_ATTRIBUTE9 IN VARCHAR2 default null,
149 p_ATTRIBUTE10 IN VARCHAR2 default null,
150 p_ATTRIBUTE11 IN VARCHAR2 default null,
151 p_ATTRIBUTE12 IN VARCHAR2 default null,
152 p_ATTRIBUTE13 IN VARCHAR2 default null,
153 p_ATTRIBUTE14 IN VARCHAR2 default null,
154 p_ATTRIBUTE15 IN VARCHAR2 default null,
155 p_end_date_active IN DATE DEFAULT NULL,
156 p_tmpl_flag IN VARCHAR2 DEFAULT 'N'
157 );
158
159
160
161 PROCEDURE RAISE_ERROR (ERROR VARCHAR2);
162
163 END EAM_MeterAssoc_PUB;