[Home] [Help]
PACKAGE: APPS.CS_SR_EXTATTRIBUTES_PVT
Source
4 G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_SUCCESS; --'S'
1 PACKAGE CS_SR_EXTATTRIBUTES_PVT AUTHID CURRENT_USER AS
2 /* $Header: csvexts.pls 120.7 2005/11/23 14:41 mviswana noship $ */
3
5 G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_ERROR; --'E'
6 G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_UNEXP_ERROR; --'U'
7
8
9 -- ==============================================================================
10 -- Private Record Structures
11 -- ==============================================================================
12 --
16 TYPE Ext_Attr_Audit_Rec_TYPE IS RECORD(
13 --This table will hold the extended attributes information
14 --for a Service Request
15 --
17 EXTENSION_ID NUMBER
18 ,ROW_IDENTIFIER NUMBER
19 ,PK_COLUMN_1 VARCHAR2(150)
20 ,PK_COLUMN_2 VARCHAR2(150)
21 ,PK_COLUMN_3 VARCHAR2(150)
22 ,PK_COLUMN_4 VARCHAR2(150)
23 ,PK_COLUMN_5 VARCHAR2(150)
24 ,CONTEXT VARCHAR2(150)
25 ,ATTR_GROUP_ID NUMBER
26 ,C_EXT_ATTR1 VARCHAR2(150)
27 ,C_EXT_ATTR2 VARCHAR2(150)
28 ,C_EXT_ATTR3 VARCHAR2(150)
29 ,C_EXT_ATTR4 VARCHAR2(150)
30 ,C_EXT_ATTR5 VARCHAR2(150)
31 ,C_EXT_ATTR6 VARCHAR2(150)
32 ,C_EXT_ATTR7 VARCHAR2(150)
33 ,C_EXT_ATTR8 VARCHAR2(150)
34 ,C_EXT_ATTR9 VARCHAR2(150)
35 ,C_EXT_ATTR10 VARCHAR2(150)
36 ,C_EXT_ATTR11 VARCHAR2(150)
37 ,C_EXT_ATTR12 VARCHAR2(150)
38 ,C_EXT_ATTR13 VARCHAR2(150)
39 ,C_EXT_ATTR14 VARCHAR2(150)
40 ,C_EXT_ATTR15 VARCHAR2(150)
41 ,C_EXT_ATTR16 VARCHAR2(150)
42 ,C_EXT_ATTR17 VARCHAR2(150)
43 ,C_EXT_ATTR18 VARCHAR2(150)
44 ,C_EXT_ATTR19 VARCHAR2(150)
45 ,C_EXT_ATTR20 VARCHAR2(150)
46 ,C_EXT_ATTR21 VARCHAR2(150)
47 ,C_EXT_ATTR22 VARCHAR2(150)
48 ,C_EXT_ATTR23 VARCHAR2(150)
49 ,C_EXT_ATTR24 VARCHAR2(150)
50 ,C_EXT_ATTR25 VARCHAR2(150)
51 ,C_EXT_ATTR26 VARCHAR2(150)
52 ,C_EXT_ATTR27 VARCHAR2(150)
53 ,C_EXT_ATTR28 VARCHAR2(150)
54 ,C_EXT_ATTR29 VARCHAR2(150)
55 ,C_EXT_ATTR30 VARCHAR2(150)
56 ,C_EXT_ATTR31 VARCHAR2(150)
57 ,C_EXT_ATTR32 VARCHAR2(150)
58 ,C_EXT_ATTR33 VARCHAR2(150)
59 ,C_EXT_ATTR34 VARCHAR2(150)
60 ,C_EXT_ATTR35 VARCHAR2(150)
61 ,C_EXT_ATTR36 VARCHAR2(150)
62 ,C_EXT_ATTR37 VARCHAR2(150)
63 ,C_EXT_ATTR38 VARCHAR2(150)
64 ,C_EXT_ATTR39 VARCHAR2(150)
65 ,C_EXT_ATTR40 VARCHAR2(150)
66 ,C_EXT_ATTR41 VARCHAR2(150)
67 ,C_EXT_ATTR42 VARCHAR2(150)
68 ,C_EXT_ATTR43 VARCHAR2(150)
69 ,C_EXT_ATTR44 VARCHAR2(150)
70 ,C_EXT_ATTR45 VARCHAR2(150)
71 ,C_EXT_ATTR46 VARCHAR2(150)
72 ,C_EXT_ATTR47 VARCHAR2(150)
73 ,C_EXT_ATTR48 VARCHAR2(150)
74 ,C_EXT_ATTR49 VARCHAR2(150)
75 ,C_EXT_ATTR50 VARCHAR2(150)
76 ,N_EXT_ATTR1 NUMBER
77 ,N_EXT_ATTR2 NUMBER
78 ,N_EXT_ATTR3 NUMBER
79 ,N_EXT_ATTR4 NUMBER
80 ,N_EXT_ATTR5 NUMBER
81 ,N_EXT_ATTR6 NUMBER
82 ,N_EXT_ATTR7 NUMBER
83 ,N_EXT_ATTR8 NUMBER
84 ,N_EXT_ATTR9 NUMBER
85 ,N_EXT_ATTR10 NUMBER
86 ,N_EXT_ATTR11 NUMBER
87 ,N_EXT_ATTR12 NUMBER
88 ,N_EXT_ATTR13 NUMBER
89 ,N_EXT_ATTR14 NUMBER
90 ,N_EXT_ATTR15 NUMBER
91 ,N_EXT_ATTR16 NUMBER
92 ,N_EXT_ATTR17 NUMBER
93 ,N_EXT_ATTR18 NUMBER
94 ,N_EXT_ATTR19 NUMBER
95 ,N_EXT_ATTR20 NUMBER
96 ,N_EXT_ATTR21 NUMBER
97 ,N_EXT_ATTR22 NUMBER
98 ,N_EXT_ATTR23 NUMBER
99 ,N_EXT_ATTR24 NUMBER
100 ,N_EXT_ATTR25 NUMBER
101 ,D_EXT_ATTR1 DATE
102 ,D_EXT_ATTR2 DATE
103 ,D_EXT_ATTR3 DATE
104 ,D_EXT_ATTR4 DATE
105 ,D_EXT_ATTR5 DATE
106 ,D_EXT_ATTR6 DATE
107 ,D_EXT_ATTR7 DATE
108 ,D_EXT_ATTR8 DATE
109 ,D_EXT_ATTR9 DATE
110 ,D_EXT_ATTR10 DATE
111 ,D_EXT_ATTR11 DATE
112 ,D_EXT_ATTR12 DATE
113 ,D_EXT_ATTR13 DATE
114 ,D_EXT_ATTR14 DATE
115 ,D_EXT_ATTR15 DATE
116 ,D_EXT_ATTR16 DATE
117 ,D_EXT_ATTR17 DATE
118 ,D_EXT_ATTR18 DATE
119 ,D_EXT_ATTR19 DATE
120 ,D_EXT_ATTR20 DATE
121 ,D_EXT_ATTR21 DATE
122 ,D_EXT_ATTR22 DATE
123 ,D_EXT_ATTR23 DATE
124 ,D_EXT_ATTR24 DATE
125 ,D_EXT_ATTR25 DATE
126 ,UOM_EXT_ATTR1 VARCHAR2(3)
127 ,UOM_EXT_ATTR2 VARCHAR2(3)
128 ,UOM_EXT_ATTR3 VARCHAR2(3)
129 ,UOM_EXT_ATTR4 VARCHAR2(3)
130 ,UOM_EXT_ATTR5 VARCHAR2(3)
131 ,UOM_EXT_ATTR6 VARCHAR2(3)
135 ,UOM_EXT_ATTR10 VARCHAR2(3)
132 ,UOM_EXT_ATTR7 VARCHAR2(3)
133 ,UOM_EXT_ATTR8 VARCHAR2(3)
134 ,UOM_EXT_ATTR9 VARCHAR2(3)
136 ,UOM_EXT_ATTR11 VARCHAR2(3)
137 ,UOM_EXT_ATTR12 VARCHAR2(3)
138 ,UOM_EXT_ATTR13 VARCHAR2(3)
139 ,UOM_EXT_ATTR14 VARCHAR2(3)
140 ,UOM_EXT_ATTR15 VARCHAR2(3)
141 ,UOM_EXT_ATTR16 VARCHAR2(3)
142 ,UOM_EXT_ATTR17 VARCHAR2(3)
143 ,UOM_EXT_ATTR18 VARCHAR2(3)
144 ,UOM_EXT_ATTR19 VARCHAR2(3)
145 ,UOM_EXT_ATTR20 VARCHAR2(3)
146 ,UOM_EXT_ATTR21 VARCHAR2(3)
147 ,UOM_EXT_ATTR22 VARCHAR2(3)
148 ,UOM_EXT_ATTR23 VARCHAR2(3)
149 ,UOM_EXT_ATTR24 VARCHAR2(3)
150 ,UOM_EXT_ATTR25 VARCHAR2(3)
151
152 );
153
154 TYPE Ext_Attr_Audit_Tbl_Type IS TABLE OF Ext_Attr_Audit_Rec_TYPE INDEX BY BINARY_INTEGER;
155
156
157 -- Record and table structure to hold the attr group and attr information together.
158
159 TYPE Ext_Grp_Attr_Rec_TYPE IS RECORD
160 ( ROW_IDENTIFIER NUMBER,
161 ATTR_GROUP_ID NUMBER,
162 ATTR_GROUP_TYPE VARCHAR2(40),
163 ATTR_GROUP_NAME VARCHAR2(30),
164 ATTR_GROUP_DISP_NAME VARCHAR2(150),
165 COLUMN_NAME VARCHAR2(30),
166 ATTR_NAME VARCHAR2(150),
167 ATTR_VALUE_STR VARCHAR2(150),
168 ATTR_VALUE_NUM NUMBER,
169 ATTR_VALUE_DATE DATE,
170 ATTR_VALUE_DISPLAY VARCHAR2(1000));
171
172 TYPE EXT_GRP_ATTR_TBL_TYPE IS TABLE OF Ext_Grp_Attr_Rec_TYPE INDEX BY BINARY_INTEGER;
173
174 -- =============================================================================
175 -- Private Procedures
176 -- =============================================================================
177
178 -- -----------------------------------------------------------------------------
179 -- API Name: get_Sr_ext_Attrs
180 --
181 -- Description:
182 -- Get User-Defined Attrs data for
183 -- the Service Request business object
184 -- -----------------------------------------------------------------------------
185 PROCEDURE Get_SR_Ext_Attrs
186 (p_api_version IN NUMBER
187 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
188 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
189 ,p_incident_id IN NUMBER
190 ,p_object_name IN VARCHAR2
191 ,x_ext_attr_grp_tbl OUT NOCOPY CS_ServiceRequest_PUB.EXT_ATTR_GRP_TBL_TYPE
192 ,x_ext_attr_tbl OUT NOCOPY CS_ServiceRequest_PUB.EXT_ATTR_TBL_TYPE
193 ,x_return_status OUT NOCOPY VARCHAR2
194 ,x_msg_count OUT NOCOPY NUMBER
195 ,x_msg_data OUT NOCOPY VARCHAR2);
196
197
198
199 -- -----------------------------------------------------------------------------
200 -- API Name: Process_Sr_ext_Attrs
201 --
202 -- Description:
203 -- Process passed-in User-Defined Attrs data for
204 -- the Service Request business object
205 -- -----------------------------------------------------------------------------
206
207
208
209
210
211 PROCEDURE Process_SR_Ext_Attrs(
212 p_api_version IN NUMBER
213 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
214 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
215 ,p_incident_id IN NUMBER
216 ,p_ext_attr_grp_tbl IN CS_ServiceRequest_PUB.EXT_ATTR_GRP_TBL_TYPE
217 ,p_ext_attr_tbl IN CS_ServiceRequest_PUB.EXT_ATTR_TBL_TYPE
218 ,p_modified_by IN NUMBER := FND_GLOBAL.USER_ID
219 ,p_modified_on IN DATE := SYSDATE
220 ,x_failed_row_id_list OUT NOCOPY VARCHAR2
221 ,x_return_status OUT NOCOPY VARCHAR2
222 ,x_errorcode OUT NOCOPY NUMBER
223 ,x_msg_count OUT NOCOPY NUMBER
224 ,x_msg_data OUT NOCOPY VARCHAR2
225 );
226
227 -- -----------------------------------------------------------------------------
228 -- API Name: Create_Ext_Attr_Audit
229 --
230 -- Description:
231 -- Create Extensible Attributes Audit Record
232 -- -----------------------------------------------------------------------------
233 PROCEDURE Create_Ext_Attr_Audit(
234 p_sr_ea_new_audit_rec_table IN Ext_Attr_Audit_Tbl_Type
235 ,p_sr_ea_old_audit_rec_table IN Ext_Attr_Audit_Tbl_Type
236 ,p_object_name IN VARCHAR2
237 ,p_modified_by IN NUMBER := FND_GLOBAL.USER_ID
238 ,p_modified_on IN DATE := SYSDATE
239 ,x_return_status OUT NOCOPY VARCHAR2
240 ,x_msg_count OUT NOCOPY NUMBER
241 ,x_msg_data OUT NOCOPY VARCHAR2
242 );
243
244
245 -- -----------------------------------------------------------------------------
246 -- API Name: Merge_Ext_Attrs_Details
247 --
248 -- Description:
249 -- This procedure is created to merge the group table and the attr. table in to one table structure.
250 -- -----------------------------------------------------------------------------
251
252 Procedure Merge_Ext_Attrs_Details
253 (p_ext_attr_grp_tbl IN CS_ServiceRequest_PUB.EXT_ATTR_GRP_TBL_TYPE
254 ,p_ext_attr_tbl IN CS_ServiceRequest_PUB.EXT_ATTR_TBL_TYPE
255 ,x_ext_grp_attr_tbl OUT NOCOPY EXT_GRP_ATTR_TBL_TYPE
256 ,x_return_status OUT NOCOPY VARCHAR2
257 ,x_msg_count OUT NOCOPY NUMBER
258 ,x_msg_data OUT NOCOPY VARCHAR2);
259
260
261 -- -----------------------------------------------------------------------------
262 -- API Name: Insert_Sr_Row
263 --
264 -- Description:
265 -- Inserts Extensible Attributes Audit Record
266 -- -----------------------------------------------------------------------------
267
268 PROCEDURE insert_sr_row
269 ( P_NEW_EXT_ATTRS IN Ext_Attr_Audit_Tbl_Type
270 , P_OLD_EXT_ATTRS IN Ext_Attr_Audit_Tbl_Type
271 , P_MODIFIED_BY IN NUMBER
272 , P_MODIFIED_ON IN DATE
273 , X_RETURN_STATUS OUT NOCOPY VARCHAR2
274 , X_MSG_COUNT OUT NOCOPY NUMBER
275 , X_MSG_DATA OUT NOCOPY VARCHAR2
276 );
277
278
279
280 -------------------------------------------------------------------------------
281 -- Procedure Name : insert_pr_row
282 -- Parameters :
283 -- IN :
284 -- OUT :
285 --
286 -- Description : Procedure to create audit of party role extensible attributes.
287 --
288 -- Modification History:
289 -- Date Name Desc
290 -------- -------- --------------------------------------------------------------
291 -- 06/06/05 pkesani Created
292 --------------------------------------------------------------------------------
293 PROCEDURE insert_pr_row
294 ( P_NEW_EXT_ATTRS IN Ext_Attr_Audit_Tbl_Type
295 , P_OLD_EXT_ATTRS IN Ext_Attr_Audit_Tbl_Type
296 , P_MODIFIED_BY IN NUMBER
297 , P_MODIFIED_ON IN DATE
298 , X_RETURN_STATUS OUT NOCOPY VARCHAR2
299 , X_MSG_COUNT OUT NOCOPY NUMBER
300 , X_MSG_DATA OUT NOCOPY VARCHAR2
301 );
302
303 -------------------------------------------------------------------------------
304 -- Procedure Name : Populate_Ext_Attr_Audit_Tbl
305 -- Parameters :
306 -- IN : P_EXTENSION_ID
307 -- OUT : X_EXT_ATTRS_TBL
308 --
309 -- Description : Procedure to populate ext. attr. audit table structure for a given extension_id.
310 --
311 -- Modification History:
312 -- Date Name Desc
313 -------- -------- --------------------------------------------------------------
314 -- 11/21/2005 spusegao Created
315 --------------------------------------------------------------------------------
316 PROCEDURE Populate_Ext_Attr_Audit_Tbl
317 ( P_EXTENSION_ID IN NUMBER
318 , X_EXT_ATTRS_TBL OUT NOCOPY Ext_Attr_Audit_Tbl_Type
319 , X_RETURN_STATUS OUT NOCOPY VARCHAR2
320 , X_MSG_COUNT OUT NOCOPY NUMBER
321 , X_MSG_DATA OUT NOCOPY VARCHAR2);
322
323 END CS_SR_EXTATTRIBUTES_PVT;