1 PACKAGE EAM_SetName_PUB AS
2 /* $Header: EAMPPSNS.pls 120.1 2006/03/21 15:42:37 hkarmach noship $ */
3 /*#
4 * This package is used for the INSERT / UPDATE of PM Set Names.
5 * It defines 2 key procedures insert_pmsetname, update_pmsetname
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 Preventive Maintenance Set Name
12 * @rep:category BUSINESS_ENTITY EAM_SET_NAME
13 */
14
15 /*
16 -- API name : EAM_SetName_PUB
17 -- Type : Public
18 -- Function : Insert, update and validation of the pm set name
19 -- Pre-reqs : None.
20 */
21 G_PKG_NAME CONSTANT VARCHAR2(30):='EAM_SetName_PUB';
22 /*
23 This procedure inserts a record in the eam_pm_set_names table
24 -- Parameters :
25 -- IN : P_API_VERSION IN NUMBER REQUIRED
26 -- P_INIT_MSG_LIST IN VARCHAR2 OPTIONAL
27 -- DEFAULT = FND_API.G_FALSE
28 -- P_COMMIT IN VARCHAR2 OPTIONAL
29 -- DEFAULT = FND_API.G_FALSE
30 -- P_VALIDATION_LEVEL IN NUMBER OPTIONAL
31 -- DEFAULT = FND_API.G_VALID_LEVEL_FULL
32 -- p_set_name IN varchar2 ,
33 -- p_description IN varchar2 DEFAULT NULL,
34 -- p_end_date IN date DEFAULT NULL ,
35 -- p_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT NULL,
36 -- p_ATTRIBUTE1 IN VARCHAR2 DEFAULT NULL,
37 -- p_ATTRIBUTE2 IN VARCHAR2 DEFAULT NULL,
38 -- p_ATTRIBUTE3 IN VARCHAR2 DEFAULT NULL,
39 -- p_ATTRIBUTE4 IN VARCHAR2 DEFAULT NULL,
40 -- p_ATTRIBUTE5 IN VARCHAR2 DEFAULT NULL,
41 -- p_ATTRIBUTE6 IN VARCHAR2 DEFAULT NULL,
42 -- p_ATTRIBUTE7 IN VARCHAR2 DEFAULT NULL,
43 -- p_ATTRIBUTE8 IN VARCHAR2 DEFAULT NULL,
44 -- p_ATTRIBUTE9 IN VARCHAR2 DEFAULT NULL,
45 -- p_ATTRIBUTE10 IN VARCHAR2 DEFAULT NULL,
46 -- p_ATTRIBUTE11 IN VARCHAR2 DEFAULT NULL,
47 -- p_ATTRIBUTE12 IN VARCHAR2 DEFAULT NULL,
48 -- p_ATTRIBUTE13 IN VARCHAR2 DEFAULT NULL,
49 -- p_ATTRIBUTE14 IN VARCHAR2 DEFAULT NULL,
50 -- p_ATTRIBUTE15 IN VARCHAR2 DEFAULT NULL,
51 -- p_end_date_val_req IN BOOLEAN default true ,
52 --
53 -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)
54 -- x_msg_count OUT NOCOPY NUMBER
55 -- x_msg_data OUT NOCOPY VARCHAR2 (2000)
56 -- x_new_set_name_id OUT NOCOPY NUMBER
57 -- Version : Current version: 1.0
58 -- Initial version: 1.0
59 --
60 -- NOTE: p_end_date_validate flag will be false in case of migration, meaning no end date validation required for
61 -- migration. If the flag is true, only in that case the Validate_FutureEndDate function will be called.
62 */
63
64 /*#
65 * This procedure is used to insert records in EAM_PM_SET_NAMES.
66 * It is used to create Preventive Maintenance Set Names.
67 * @param p_api_version Version of the API
68 * @param p_init_msg_list Flag to indicate initialization of message list
69 * @param p_commit Flag to indicate whether API should commit changes
70 * @param p_validation_level Validation Level of the API
71 * @param x_return_status Return status of the procedure call
72 * @param x_msg_count Count of the return messages that API returns
73 * @param x_msg_data The collection of the messages.
74 * @param p_set_name Set name
75 * @param p_description Description text
76 * @param p_end_date Effective end date of the Preventive Maintenance set
77 * @param p_attribute_category Attribute Category
78 * @param p_attribute1 Descriptive flexfield column
79 * @param p_attribute2 Descriptive flexfield column
80 * @param p_attribute3 Descriptive flexfield column
81 * @param p_attribute4 Descriptive flexfield column
82 * @param p_attribute5 Descriptive flexfield column
83 * @param p_attribute6 Descriptive flexfield column
84 * @param p_attribute7 Descriptive flexfield column
85 * @param p_attribute8 Descriptive flexfield column
86 * @param p_attribute9 Descriptive flexfield column
87 * @param p_attribute10 Descriptive flexfield column
88 * @param p_attribute11 Descriptive flexfield column
89 * @param p_attribute12 Descriptive flexfield column
90 * @param p_attribute13 Descriptive flexfield column
91 * @param p_attribute14 Descriptive flexfield column
92 * @param p_attribute15 Descriptive flexfield column
93 * @param p_organization_id Owning Organization
94 * @param p_local_flag Flag to indicate whether the set name is org specific
95 * @param x_new_set_name_id Set name identifier of newly created record
96 * @param p_end_date_val_req Flag indicating whether the end date validation required of this record
97 * @return Returns the status of the procedure call as well as the return messages
98 * @rep:scope public
99 * @rep:displayname Create PM Set Names
100 */
101
102 PROCEDURE Insert_PMSetName
103 (
104 p_api_version IN NUMBER ,
105 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
106 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
107 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
108 x_return_status OUT NOCOPY VARCHAR2 ,
109 x_msg_count OUT NOCOPY NUMBER ,
110 x_msg_data OUT NOCOPY VARCHAR2 ,
111 p_set_name IN VARCHAR2 ,
112 p_description IN VARCHAR2 DEFAULT NULL,
113 p_end_date IN DATE DEFAULT NULL ,
114 p_attribute_category IN VARCHAR2 DEFAULT NULL,
115 p_attribute1 IN VARCHAR2 DEFAULT NULL,
116 p_attribute2 IN VARCHAR2 DEFAULT NULL,
117 p_attribute3 IN VARCHAR2 DEFAULT NULL,
118 p_attribute4 IN VARCHAR2 DEFAULT NULL,
119 p_attribute5 IN VARCHAR2 DEFAULT NULL,
120 p_attribute6 IN VARCHAR2 DEFAULT NULL,
121 p_attribute7 IN VARCHAR2 DEFAULT NULL,
122 p_attribute8 IN VARCHAR2 DEFAULT NULL,
123 p_attribute9 IN VARCHAR2 DEFAULT NULL,
124 p_attribute10 IN VARCHAR2 DEFAULT NULL,
125 p_attribute11 IN VARCHAR2 DEFAULT NULL,
126 p_attribute12 IN VARCHAR2 DEFAULT NULL,
127 p_attribute13 IN VARCHAR2 DEFAULT NULL,
128 p_attribute14 IN VARCHAR2 DEFAULT NULL,
129 p_attribute15 IN VARCHAR2 DEFAULT NULL,
130 p_organization_id IN number default null,
131 p_local_flag IN VARCHAR2 default 'N',
132 x_new_set_name_id OUT NOCOPY NUMBER,
133 p_end_date_val_req IN varchar2 DEFAULT 'true'
134 );
135
136
137 /*
138 This procedure updates a record in the eam_pm_set_names table
139 -- Parameters :
140 -- IN : p_api_version IN NUMBER REQUIRED
141 -- P_INIT_MSG_LIST IN VARCHAR2 OPTIONAL
142 -- DEFAULT = FND_API.G_FALSE
143 -- P_COMMIT IN VARCHAR2 OPTIONAL
144 -- DEFAULT = FND_API.G_FALSE
145 -- P_VALIDATION_LEVEL IN NUMBER OPTIONAL
146 -- DEFAULT = FND_API.G_VALID_LEVEL_FULL
147 -- p_set_name_id IN NUMBER ,
148 -- p_set_name IN VARCHAR2 ,
149 -- p_description IN VARCHAR2 DEFAULT NULL,
150 -- p_end_date IN DATE DEFAULT NULL ,
151 -- p_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT NULL,
152 -- p_ATTRIBUTE1 IN VARCHAR2 DEFAULT NULL,
153 -- p_ATTRIBUTE2 IN VARCHAR2 DEFAULT NULL,
154 -- p_ATTRIBUTE3 IN VARCHAR2 DEFAULT NULL,
155 -- p_ATTRIBUTE4 IN VARCHAR2 DEFAULT NULL,
156 -- p_ATTRIBUTE5 IN VARCHAR2 DEFAULT NULL,
157 -- p_ATTRIBUTE6 IN VARCHAR2 DEFAULT NULL,
158 -- p_ATTRIBUTE7 IN VARCHAR2 DEFAULT NULL,
159 -- p_ATTRIBUTE8 IN VARCHAR2 DEFAULT NULL,
160 -- p_ATTRIBUTE9 IN VARCHAR2 DEFAULT NULL,
161 -- p_ATTRIBUTE10 IN VARCHAR2 DEFAULT NULL,
162 -- p_ATTRIBUTE11 IN VARCHAR2 DEFAULT NULL,
163 -- p_ATTRIBUTE12 IN VARCHAR2 DEFAULT NULL,
164 -- p_ATTRIBUTE13 IN VARCHAR2 DEFAULT NULL,
165 -- p_ATTRIBUTE14 IN VARCHAR2 DEFAULT NULL,
166 -- p_ATTRIBUTE15 IN VARCHAR2 DEFAULT NULL,
167 -- p_end_date_val_req IN BOOLEAN default true
168 --
169 --
170 -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)
171 -- x_msg_count OUT NOCOPY NUMBER
172 -- x_msg_data OUT NOCOPY VARCHAR2 (2000)
173 -- Version : Current version: 1.0
174 -- Initial version: 1.0
175 --
176 -- NOTE: p_end_date_validate flag will be false in case of migration, meaning no end date validation required for
177 -- migration. If the flag is true, only in that case the Validate_FutureEndDate function will be called.
178 */
179
180 /*#
181 * This procedure is used to update the existing records in EAM_PM_SET_NAMES.
182 * It is used to update Preventive Maintenance Set Names.
183 * @param p_api_version Version of the API
184 * @param p_init_msg_list Flag to indicate initialization of message list
185 * @param p_commit Flag to indicate whether API should commit changes
186 * @param p_validation_level Validation Level of the API
187 * @param x_return_status Return status of the procedure call
188 * @param x_msg_count Count of the return messages that API returns
189 * @param x_msg_data The collection of the messages.
190 * @param p_set_name_id Set name identifier
191 * @param p_set_name Set name
192 * @param p_description Description text
193 * @param p_end_date Effective end date of the Preventive Maintenance set
194 * @param p_attribute_category Attribute Category
195 * @param p_attribute1 Descriptive flexfield column
196 * @param p_attribute2 Descriptive flexfield column
197 * @param p_attribute3 Descriptive flexfield column
198 * @param p_attribute4 Descriptive flexfield column
199 * @param p_attribute5 Descriptive flexfield column
200 * @param p_attribute6 Descriptive flexfield column
201 * @param p_attribute7 Descriptive flexfield column
202 * @param p_attribute8 Descriptive flexfield column
203 * @param p_attribute9 Descriptive flexfield column
204 * @param p_attribute10 Descriptive flexfield column
205 * @param p_attribute11 Descriptive flexfield column
206 * @param p_attribute12 Descriptive flexfield column
207 * @param p_attribute13 Descriptive flexfield column
208 * @param p_attribute14 Descriptive flexfield column
209 * @param p_attribute15 Descriptive flexfield column
210 * @param p_organization_id Owning Organization
211 * @param p_local_flag Flag to indicate whether the set name is org specific
212 * @param p_end_date_val_req Flag indicating whether the end date validation required of this record
213 * @return Returns the status of the procedure call as well as the return messages
214 * @rep:scope public
215 * @rep:displayname Update PM Set Names
216 */
217
218 PROCEDURE Update_PMSetName
219 (
220 p_api_version IN NUMBER ,
221 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
222 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
223 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
224 x_return_status OUT NOCOPY VARCHAR2 ,
225 x_msg_count OUT NOCOPY NUMBER ,
226 x_msg_data OUT NOCOPY VARCHAR2 ,
227 p_set_name_id IN NUMBER ,
228 p_set_name IN VARCHAR2 ,
229 p_description IN VARCHAR2 DEFAULT NULL,
230 p_end_date IN DATE DEFAULT NULL ,
231 p_attribute_category IN VARCHAR2 DEFAULT NULL,
232 p_attribute1 IN VARCHAR2 DEFAULT NULL,
233 p_attribute2 IN VARCHAR2 DEFAULT NULL,
234 p_attribute3 IN VARCHAR2 DEFAULT NULL,
235 p_attribute4 IN VARCHAR2 DEFAULT NULL,
236 p_attribute5 IN VARCHAR2 DEFAULT NULL,
237 p_attribute6 IN VARCHAR2 DEFAULT NULL,
238 p_attribute7 IN VARCHAR2 DEFAULT NULL,
239 p_attribute8 IN VARCHAR2 DEFAULT NULL,
240 p_attribute9 IN VARCHAR2 DEFAULT NULL,
241 p_attribute10 IN VARCHAR2 DEFAULT NULL,
242 p_attribute11 IN VARCHAR2 DEFAULT NULL,
243 p_attribute12 IN VARCHAR2 DEFAULT NULL,
244 p_attribute13 IN VARCHAR2 DEFAULT NULL,
245 p_attribute14 IN VARCHAR2 DEFAULT NULL,
246 p_attribute15 IN VARCHAR2 DEFAULT NULL,
247 p_organization_id IN number default null,
248 p_local_flag IN VARCHAR2 default 'N',
249 p_end_date_val_req IN varchar2 default 'true'
250 );
251
252
253
254
255 FUNCTION Validate_SetName (p_set_name_id NUMBER, p_set_name varchar2)
256 return boolean;
257
258 FUNCTION Validate_SetNameUnique
259 (p_set_name VARCHAR2)
260 return boolean;
261
262 FUNCTION Validate_FutureEndDate
263 (p_end_date DATE)
264 return boolean;
265
266 PROCEDURE RAISE_ERROR (ERROR VARCHAR2);
267 PROCEDURE PRINT_LOG(info varchar2);
268
269 END EAM_SetName_PUB;