[Home] [Help]
PACKAGE: APPS.QP_ATTR_MAP_PUB
Source
1 PACKAGE QP_Attr_Map_PUB AS
2 /* $Header: QPXPMAPS.pls 120.2 2005/07/18 18:14:57 appldev ship $ */
3
4 -- Pte record type
5
6 TYPE Pte_Rec_Type IS RECORD
7 ( description VARCHAR2(240) := FND_API.G_MISS_CHAR
8 , enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
9 , end_date_active DATE := FND_API.G_MISS_DATE
10 , lookup_code VARCHAR2(30) := FND_API.G_MISS_CHAR
11 , lookup_type VARCHAR2(30) := FND_API.G_MISS_CHAR
12 , meaning VARCHAR2(80) := FND_API.G_MISS_CHAR
13 , start_date_active DATE := FND_API.G_MISS_DATE
14 , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
15 , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
16 , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
17 );
18
19 TYPE Pte_Tbl_Type IS TABLE OF Pte_Rec_Type
20 INDEX BY BINARY_INTEGER;
21
22 -- Pte value record type
23
24 TYPE Pte_Val_Rec_Type IS RECORD
25 ( enabled VARCHAR2(240) := FND_API.G_MISS_CHAR
26 , lookup VARCHAR2(240) := FND_API.G_MISS_CHAR
27 );
28
29 TYPE Pte_Val_Tbl_Type IS TABLE OF Pte_Val_Rec_Type
30 INDEX BY BINARY_INTEGER;
31
32 -- Rqt record type
33
34 TYPE Rqt_Rec_Type IS RECORD
35 ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
36 , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
37 , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
38 , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
39 , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
40 , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
41 , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
42 , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
43 , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
44 , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
45 , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
46 , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
47 , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
48 , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
49 , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
50 , context VARCHAR2(30) := FND_API.G_MISS_CHAR
51 , created_by NUMBER := FND_API.G_MISS_NUM
52 , creation_date DATE := FND_API.G_MISS_DATE
53 , enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
54 , last_updated_by NUMBER := FND_API.G_MISS_NUM
55 , last_update_date DATE := FND_API.G_MISS_DATE
56 , last_update_login NUMBER := FND_API.G_MISS_NUM
57 , line_level_global_struct VARCHAR2(80) := FND_API.G_MISS_CHAR
58 , line_level_view_name VARCHAR2(80) := FND_API.G_MISS_CHAR
59 , order_level_global_struct VARCHAR2(80) := FND_API.G_MISS_CHAR
60 , order_level_view_name VARCHAR2(80) := FND_API.G_MISS_CHAR
61 , program_application_id NUMBER := FND_API.G_MISS_NUM
62 , program_id NUMBER := FND_API.G_MISS_NUM
63 , program_update_date DATE := FND_API.G_MISS_DATE
64 , pte_code VARCHAR2(30) := FND_API.G_MISS_CHAR
65 , request_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
66 , request_type_desc VARCHAR2(240) := FND_API.G_MISS_CHAR
67 , row_id VARCHAR2(240) := FND_API.G_MISS_CHAR
68 , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
69 , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
70 , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
71 );
72
73 TYPE Rqt_Tbl_Type IS TABLE OF Rqt_Rec_Type
74 INDEX BY BINARY_INTEGER;
75
76 -- Rqt value record type
77
78 TYPE Rqt_Val_Rec_Type IS RECORD
79 ( enabled VARCHAR2(240) := FND_API.G_MISS_CHAR
80 , pte VARCHAR2(240) := FND_API.G_MISS_CHAR
81 , request_type VARCHAR2(240) := FND_API.G_MISS_CHAR
82 , row VARCHAR2(240) := FND_API.G_MISS_CHAR
83 );
84
85 TYPE Rqt_Val_Tbl_Type IS TABLE OF Rqt_Val_Rec_Type
86 INDEX BY BINARY_INTEGER;
87
88 -- Ssc record type
89
90 TYPE Ssc_Rec_Type IS RECORD
91 ( application_short_name VARCHAR2(30) := FND_API.G_MISS_CHAR
92 , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
93 , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
94 , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
95 , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
96 , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
97 , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
98 , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
99 , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
100 , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
101 , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
102 , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
103 , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
104 , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
105 , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
106 , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
107 , context VARCHAR2(30) := FND_API.G_MISS_CHAR
108 , created_by NUMBER := FND_API.G_MISS_NUM
109 , creation_date DATE := FND_API.G_MISS_DATE
110 , enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
111 , last_updated_by NUMBER := FND_API.G_MISS_NUM
112 , last_update_date DATE := FND_API.G_MISS_DATE
113 , last_update_login NUMBER := FND_API.G_MISS_NUM
114 , program_application_id NUMBER := FND_API.G_MISS_NUM
115 , program_id NUMBER := FND_API.G_MISS_NUM
116 , program_update_date DATE := FND_API.G_MISS_DATE
117 , pte_code VARCHAR2(30) := FND_API.G_MISS_CHAR
118 , pte_source_system_id NUMBER := FND_API.G_MISS_NUM
119 , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
120 , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
121 , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
122 );
123
124 TYPE Ssc_Tbl_Type IS TABLE OF Ssc_Rec_Type
125 INDEX BY BINARY_INTEGER;
126
127 -- Ssc value record type
128
129 TYPE Ssc_Val_Rec_Type IS RECORD
130 ( enabled VARCHAR2(240) := FND_API.G_MISS_CHAR
131 , pte VARCHAR2(240) := FND_API.G_MISS_CHAR
132 , pte_source_system VARCHAR2(240) := FND_API.G_MISS_CHAR
133 );
134
135 TYPE Ssc_Val_Tbl_Type IS TABLE OF Ssc_Val_Rec_Type
136 INDEX BY BINARY_INTEGER;
137
138 -- Psg record type
139
140 TYPE Psg_Rec_Type IS RECORD
141 ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
142 , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
143 , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
144 , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
145 , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
146 , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
147 , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
148 , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
149 , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
150 , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
151 , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
152 , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
153 , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
154 , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
155 , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
156 , context VARCHAR2(30) := FND_API.G_MISS_CHAR
157 , created_by NUMBER := FND_API.G_MISS_NUM
158 , creation_date DATE := FND_API.G_MISS_DATE
159 , last_updated_by NUMBER := FND_API.G_MISS_NUM
160 , last_update_date DATE := FND_API.G_MISS_DATE
161 , last_update_login NUMBER := FND_API.G_MISS_NUM
162 , limits_enabled VARCHAR2(1) := FND_API.G_MISS_CHAR
163 , lov_enabled VARCHAR2(1) := FND_API.G_MISS_CHAR
164 , program_application_id NUMBER := FND_API.G_MISS_NUM
165 , program_id NUMBER := FND_API.G_MISS_NUM
166 , program_update_date DATE := FND_API.G_MISS_DATE
167 , pte_code VARCHAR2(30) := FND_API.G_MISS_CHAR
168 , seeded_sourcing_method VARCHAR2(30) := FND_API.G_MISS_CHAR
169 , segment_id NUMBER := FND_API.G_MISS_NUM
170 , segment_level VARCHAR2(10) := FND_API.G_MISS_CHAR
171 , segment_pte_id NUMBER := FND_API.G_MISS_NUM
172 , sourcing_enabled VARCHAR2(1) := FND_API.G_MISS_CHAR
173 , sourcing_status VARCHAR2(1) := FND_API.G_MISS_CHAR
174 , user_sourcing_method VARCHAR2(30) := FND_API.G_MISS_CHAR
175 , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
176 , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
177 , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
178 );
179
180 TYPE Psg_Tbl_Type IS TABLE OF Psg_Rec_Type
181 INDEX BY BINARY_INTEGER;
182
183 -- Psg value record type
184
185 TYPE Psg_Val_Rec_Type IS RECORD
186 ( pte VARCHAR2(240) := FND_API.G_MISS_CHAR
187 , segment VARCHAR2(240) := FND_API.G_MISS_CHAR
188 , segment_pte VARCHAR2(240) := FND_API.G_MISS_CHAR
189 );
190
191 TYPE Psg_Val_Tbl_Type IS TABLE OF Psg_Val_Rec_Type
192 INDEX BY BINARY_INTEGER;
193
194 -- Sou record type
195
196 TYPE Sou_Rec_Type IS RECORD
197 ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
198 , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
199 , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
200 , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
201 , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
202 , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
203 , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
204 , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
205 , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
206 , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
207 , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
208 , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
209 , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
210 , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
211 , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
212 , attribute_sourcing_id NUMBER := FND_API.G_MISS_NUM
213 , attribute_sourcing_level VARCHAR2(30) := FND_API.G_MISS_CHAR
214 , application_id NUMBER := FND_API.G_MISS_NUM
215 , context VARCHAR2(30) := FND_API.G_MISS_CHAR
216 , created_by NUMBER := FND_API.G_MISS_NUM
217 , creation_date DATE := FND_API.G_MISS_DATE
218 , enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
219 , last_updated_by NUMBER := FND_API.G_MISS_NUM
220 , last_update_date DATE := FND_API.G_MISS_DATE
221 , last_update_login NUMBER := FND_API.G_MISS_NUM
222 , program_application_id NUMBER := FND_API.G_MISS_NUM
223 , program_id NUMBER := FND_API.G_MISS_NUM
224 , program_update_date DATE := FND_API.G_MISS_DATE
225 , request_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
226 , seeded_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
227 , seeded_sourcing_type VARCHAR2(30) := FND_API.G_MISS_CHAR
228 , seeded_value_string VARCHAR2(2000) := FND_API.G_MISS_CHAR
229 , segment_id NUMBER := FND_API.G_MISS_NUM
230 , user_sourcing_type VARCHAR2(30) := FND_API.G_MISS_CHAR
231 , user_value_string VARCHAR2(2000) := FND_API.G_MISS_CHAR
232 , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
233 , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
234 , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
235 , PSG_index NUMBER := FND_API.G_MISS_NUM
236 );
237
238 TYPE Sou_Tbl_Type IS TABLE OF Sou_Rec_Type
239 INDEX BY BINARY_INTEGER;
240
241 -- Sou value record type
242
243 TYPE Sou_Val_Rec_Type IS RECORD
244 ( attribute_sourcing VARCHAR2(240) := FND_API.G_MISS_CHAR
245 , enabled VARCHAR2(240) := FND_API.G_MISS_CHAR
246 , request_type VARCHAR2(240) := FND_API.G_MISS_CHAR
247 , seeded VARCHAR2(240) := FND_API.G_MISS_CHAR
248 , segment VARCHAR2(240) := FND_API.G_MISS_CHAR
249 );
250
251 TYPE Sou_Val_Tbl_Type IS TABLE OF Sou_Val_Rec_Type
252 INDEX BY BINARY_INTEGER;
253
254 -- Fna record type
255
256 TYPE Fna_Rec_Type IS RECORD
257 ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
258 , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
259 , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
260 , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
261 , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
262 , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
263 , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
264 , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
268 , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
265 , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
266 , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
267 , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
269 , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
270 , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
271 , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
272 , context VARCHAR2(30) := FND_API.G_MISS_CHAR
273 , created_by NUMBER := FND_API.G_MISS_NUM
274 , creation_date DATE := FND_API.G_MISS_DATE
275 , enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
276 , functional_area_id NUMBER := FND_API.G_MISS_NUM
277 , last_updated_by NUMBER := FND_API.G_MISS_NUM
278 , last_update_date DATE := FND_API.G_MISS_DATE
279 , last_update_login NUMBER := FND_API.G_MISS_NUM
280 , program_application_id NUMBER := FND_API.G_MISS_NUM
281 , program_id NUMBER := FND_API.G_MISS_NUM
282 , program_update_date DATE := FND_API.G_MISS_DATE
283 , pte_sourcesystem_fnarea_id NUMBER := FND_API.G_MISS_NUM
284 , pte_source_system_id NUMBER := FND_API.G_MISS_NUM
285 , request_id NUMBER := FND_API.G_MISS_NUM
286 , seeded_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
287 , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
288 , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
289 , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
290 , SSC_index NUMBER := FND_API.G_MISS_NUM
291 );
292
293 TYPE Fna_Tbl_Type IS TABLE OF Fna_Rec_Type
294 INDEX BY BINARY_INTEGER;
295
296 -- Fna value record type
297
298 TYPE Fna_Val_Rec_Type IS RECORD
299 ( enabled VARCHAR2(240) := FND_API.G_MISS_CHAR
300 , functional_area VARCHAR2(240) := FND_API.G_MISS_CHAR
301 , pte_sourcesystem_fnarea VARCHAR2(240) := FND_API.G_MISS_CHAR
302 , pte_source_system VARCHAR2(240) := FND_API.G_MISS_CHAR
303 , seeded VARCHAR2(240) := FND_API.G_MISS_CHAR
304 );
305
306 TYPE Fna_Val_Tbl_Type IS TABLE OF Fna_Val_Rec_Type
307 INDEX BY BINARY_INTEGER;
308
309
310 -- Variables representing missing records and tables
311
312 G_MISS_PTE_REC Pte_Rec_Type;
313 G_MISS_PTE_VAL_REC Pte_Val_Rec_Type;
314 G_MISS_PTE_TBL Pte_Tbl_Type;
315 G_MISS_PTE_VAL_TBL Pte_Val_Tbl_Type;
316 G_MISS_RQT_REC Rqt_Rec_Type;
317 G_MISS_RQT_VAL_REC Rqt_Val_Rec_Type;
318 G_MISS_RQT_TBL Rqt_Tbl_Type;
319 G_MISS_RQT_VAL_TBL Rqt_Val_Tbl_Type;
320 G_MISS_SSC_REC Ssc_Rec_Type;
321 G_MISS_SSC_VAL_REC Ssc_Val_Rec_Type;
322 G_MISS_SSC_TBL Ssc_Tbl_Type;
323 G_MISS_SSC_VAL_TBL Ssc_Val_Tbl_Type;
324 G_MISS_PSG_REC Psg_Rec_Type;
325 G_MISS_PSG_VAL_REC Psg_Val_Rec_Type;
326 G_MISS_PSG_TBL Psg_Tbl_Type;
327 G_MISS_PSG_VAL_TBL Psg_Val_Tbl_Type;
328 G_MISS_SOU_REC Sou_Rec_Type;
329 G_MISS_SOU_VAL_REC Sou_Val_Rec_Type;
330 G_MISS_SOU_TBL Sou_Tbl_Type;
331 G_MISS_SOU_VAL_TBL Sou_Val_Tbl_Type;
332 G_MISS_FNA_REC Fna_Rec_Type;
333 G_MISS_FNA_VAL_REC Fna_Val_Rec_Type;
334 G_MISS_FNA_TBL Fna_Tbl_Type;
335 G_MISS_FNA_VAL_TBL Fna_Val_Tbl_Type;
336
337 -- Start of Comments
338 -- API name Process_Attr_Mapping
339 -- Type Public
340 -- Function
341 --
342 -- Pre-reqs
343 --
344 -- Parameters
345 --
346 -- Version Current version = 1.0
347 -- Initial version = 1.0
348 --
349 -- Notes
350 --
351 -- End of Comments
352
353 PROCEDURE Process_Attr_Mapping
354 ( p_api_version_number IN NUMBER
355 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
356 , p_return_values IN VARCHAR2 := FND_API.G_FALSE
357 , p_commit IN VARCHAR2 := FND_API.G_FALSE
358 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
359 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
360 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
361 , p_PTE_rec IN Pte_Rec_Type :=
362 G_MISS_PTE_REC
363 , p_PTE_val_rec IN Pte_Val_Rec_Type :=
364 G_MISS_PTE_VAL_REC
365 , p_RQT_tbl IN Rqt_Tbl_Type :=
366 G_MISS_RQT_TBL
367 , p_RQT_val_tbl IN Rqt_Val_Tbl_Type :=
368 G_MISS_RQT_VAL_TBL
369 , p_SSC_tbl IN Ssc_Tbl_Type :=
370 G_MISS_SSC_TBL
371 , p_SSC_val_tbl IN Ssc_Val_Tbl_Type :=
372 G_MISS_SSC_VAL_TBL
373 , p_PSG_tbl IN Psg_Tbl_Type :=
374 G_MISS_PSG_TBL
378 G_MISS_SOU_TBL
375 , p_PSG_val_tbl IN Psg_Val_Tbl_Type :=
376 G_MISS_PSG_VAL_TBL
377 , p_SOU_tbl IN Sou_Tbl_Type :=
379 , p_SOU_val_tbl IN Sou_Val_Tbl_Type :=
380 G_MISS_SOU_VAL_TBL
381 , p_FNA_tbl IN Fna_Tbl_Type :=
382 G_MISS_FNA_TBL
383 , p_FNA_val_tbl IN Fna_Val_Tbl_Type :=
384 G_MISS_FNA_VAL_TBL
385 , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ Pte_Rec_Type
386 , x_PTE_val_rec OUT NOCOPY /* file.sql.39 change */ Pte_Val_Rec_Type
387 , x_RQT_tbl OUT NOCOPY /* file.sql.39 change */ Rqt_Tbl_Type
388 , x_RQT_val_tbl OUT NOCOPY /* file.sql.39 change */ Rqt_Val_Tbl_Type
389 , x_SSC_tbl OUT NOCOPY /* file.sql.39 change */ Ssc_Tbl_Type
390 , x_SSC_val_tbl OUT NOCOPY /* file.sql.39 change */ Ssc_Val_Tbl_Type
391 , x_PSG_tbl OUT NOCOPY /* file.sql.39 change */ Psg_Tbl_Type
392 , x_PSG_val_tbl OUT NOCOPY /* file.sql.39 change */ Psg_Val_Tbl_Type
393 , x_SOU_tbl OUT NOCOPY /* file.sql.39 change */ Sou_Tbl_Type
394 , x_SOU_val_tbl OUT NOCOPY /* file.sql.39 change */ Sou_Val_Tbl_Type
395 , x_FNA_tbl OUT NOCOPY /* file.sql.39 change */ Fna_Tbl_Type
396 , x_FNA_val_tbl OUT NOCOPY /* file.sql.39 change */ Fna_Val_Tbl_Type
397 );
398
399 -- Start of Comments
400 -- API name Process_Attr_Mapping (Overloaded)
401 -- Type Public
402 -- Function
403 --
404 -- Pre-reqs
405 --
406 -- Parameters
407 --
408 -- Version Current version = 1.0
409 -- Initial version = 1.0
410 --
411 -- Notes
412 --
413 -- End of Comments
414
415 PROCEDURE Process_Attr_Mapping
416 ( p_api_version_number IN NUMBER
417 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
418 , p_return_values IN VARCHAR2 := FND_API.G_FALSE
419 , p_commit IN VARCHAR2 := FND_API.G_FALSE
420 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
421 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
422 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
423 , p_PTE_rec IN Pte_Rec_Type :=
424 G_MISS_PTE_REC
425 , p_PTE_val_rec IN Pte_Val_Rec_Type :=
426 G_MISS_PTE_VAL_REC
427 , p_RQT_tbl IN Rqt_Tbl_Type :=
428 G_MISS_RQT_TBL
429 , p_RQT_val_tbl IN Rqt_Val_Tbl_Type :=
430 G_MISS_RQT_VAL_TBL
431 , p_SSC_tbl IN Ssc_Tbl_Type :=
432 G_MISS_SSC_TBL
433 , p_SSC_val_tbl IN Ssc_Val_Tbl_Type :=
434 G_MISS_SSC_VAL_TBL
435 , p_PSG_tbl IN Psg_Tbl_Type :=
436 G_MISS_PSG_TBL
437 , p_PSG_val_tbl IN Psg_Val_Tbl_Type :=
438 G_MISS_PSG_VAL_TBL
439 , p_SOU_tbl IN Sou_Tbl_Type :=
440 G_MISS_SOU_TBL
441 , p_SOU_val_tbl IN Sou_Val_Tbl_Type :=
442 G_MISS_SOU_VAL_TBL
443 , p_FNA_tbl IN Fna_Tbl_Type :=
444 G_MISS_FNA_TBL
445 , p_FNA_val_tbl IN Fna_Val_Tbl_Type :=
446 G_MISS_FNA_VAL_TBL
447 , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ Pte_Rec_Type
448 , x_PTE_val_rec OUT NOCOPY /* file.sql.39 change */ Pte_Val_Rec_Type
449 , x_RQT_tbl OUT NOCOPY /* file.sql.39 change */ Rqt_Tbl_Type
450 , x_RQT_val_tbl OUT NOCOPY /* file.sql.39 change */ Rqt_Val_Tbl_Type
451 , x_SSC_tbl OUT NOCOPY /* file.sql.39 change */ Ssc_Tbl_Type
452 , x_SSC_val_tbl OUT NOCOPY /* file.sql.39 change */ Ssc_Val_Tbl_Type
453 , x_PSG_tbl OUT NOCOPY /* file.sql.39 change */ Psg_Tbl_Type
454 , x_PSG_val_tbl OUT NOCOPY /* file.sql.39 change */ Psg_Val_Tbl_Type
455 , x_SOU_tbl OUT NOCOPY /* file.sql.39 change */ Sou_Tbl_Type
456 , x_SOU_val_tbl OUT NOCOPY /* file.sql.39 change */ Sou_Val_Tbl_Type
457 );
458
459 -- Start of Comments
460 -- API name Lock_Attr_Mapping
461 -- Type Public
462 -- Function
463 --
464 -- Pre-reqs
465 --
466 -- Parameters
467 --
468 -- Version Current version = 1.0
469 -- Initial version = 1.0
470 --
471 -- Notes
472 --
473 -- End of Comments
474
475 PROCEDURE Lock_Attr_Mapping
476 ( p_api_version_number IN NUMBER
477 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
478 , p_return_values IN VARCHAR2 := FND_API.G_FALSE
479 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
480 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
484 , p_PTE_val_rec IN Pte_Val_Rec_Type :=
481 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
482 , p_PTE_rec IN Pte_Rec_Type :=
483 G_MISS_PTE_REC
485 G_MISS_PTE_VAL_REC
486 , p_RQT_tbl IN Rqt_Tbl_Type :=
487 G_MISS_RQT_TBL
488 , p_RQT_val_tbl IN Rqt_Val_Tbl_Type :=
489 G_MISS_RQT_VAL_TBL
490 , p_SSC_tbl IN Ssc_Tbl_Type :=
491 G_MISS_SSC_TBL
492 , p_SSC_val_tbl IN Ssc_Val_Tbl_Type :=
493 G_MISS_SSC_VAL_TBL
494 , p_PSG_tbl IN Psg_Tbl_Type :=
495 G_MISS_PSG_TBL
496 , p_PSG_val_tbl IN Psg_Val_Tbl_Type :=
497 G_MISS_PSG_VAL_TBL
498 , p_SOU_tbl IN Sou_Tbl_Type :=
499 G_MISS_SOU_TBL
500 , p_SOU_val_tbl IN Sou_Val_Tbl_Type :=
501 G_MISS_SOU_VAL_TBL
502 , p_FNA_tbl IN Fna_Tbl_Type :=
503 G_MISS_FNA_TBL
504 , p_FNA_val_tbl IN Fna_Val_Tbl_Type :=
505 G_MISS_FNA_VAL_TBL
506 , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ Pte_Rec_Type
507 , x_PTE_val_rec OUT NOCOPY /* file.sql.39 change */ Pte_Val_Rec_Type
508 , x_RQT_tbl OUT NOCOPY /* file.sql.39 change */ Rqt_Tbl_Type
509 , x_RQT_val_tbl OUT NOCOPY /* file.sql.39 change */ Rqt_Val_Tbl_Type
510 , x_SSC_tbl OUT NOCOPY /* file.sql.39 change */ Ssc_Tbl_Type
511 , x_SSC_val_tbl OUT NOCOPY /* file.sql.39 change */ Ssc_Val_Tbl_Type
512 , x_PSG_tbl OUT NOCOPY /* file.sql.39 change */ Psg_Tbl_Type
513 , x_PSG_val_tbl OUT NOCOPY /* file.sql.39 change */ Psg_Val_Tbl_Type
514 , x_SOU_tbl OUT NOCOPY /* file.sql.39 change */ Sou_Tbl_Type
515 , x_SOU_val_tbl OUT NOCOPY /* file.sql.39 change */ Sou_Val_Tbl_Type
516 , x_FNA_tbl OUT NOCOPY /* file.sql.39 change */ Fna_Tbl_Type
517 , x_FNA_val_tbl OUT NOCOPY /* file.sql.39 change */ Fna_Val_Tbl_Type
518 );
519
520 -- Start of Comments
521 -- API name Lock_Attr_Mapping (Overloaded)
525 -- Pre-reqs
522 -- Type Public
523 -- Function
524 --
526 --
527 -- Parameters
528 --
529 -- Version Current version = 1.0
530 -- Initial version = 1.0
531 --
532 -- Notes
533 --
534 -- End of Comments
535
536 PROCEDURE Lock_Attr_Mapping
537 ( p_api_version_number IN NUMBER
538 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
539 , p_return_values IN VARCHAR2 := FND_API.G_FALSE
540 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
541 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
542 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
543 , p_PTE_rec IN Pte_Rec_Type :=
544 G_MISS_PTE_REC
545 , p_PTE_val_rec IN Pte_Val_Rec_Type :=
546 G_MISS_PTE_VAL_REC
547 , p_RQT_tbl IN Rqt_Tbl_Type :=
548 G_MISS_RQT_TBL
549 , p_RQT_val_tbl IN Rqt_Val_Tbl_Type :=
550 G_MISS_RQT_VAL_TBL
551 , p_SSC_tbl IN Ssc_Tbl_Type :=
552 G_MISS_SSC_TBL
553 , p_SSC_val_tbl IN Ssc_Val_Tbl_Type :=
554 G_MISS_SSC_VAL_TBL
555 , p_PSG_tbl IN Psg_Tbl_Type :=
556 G_MISS_PSG_TBL
557 , p_PSG_val_tbl IN Psg_Val_Tbl_Type :=
558 G_MISS_PSG_VAL_TBL
559 , p_SOU_tbl IN Sou_Tbl_Type :=
560 G_MISS_SOU_TBL
561 , p_SOU_val_tbl IN Sou_Val_Tbl_Type :=
562 G_MISS_SOU_VAL_TBL
563 , p_FNA_tbl IN Fna_Tbl_Type :=
564 G_MISS_FNA_TBL
565 , p_FNA_val_tbl IN Fna_Val_Tbl_Type :=
566 G_MISS_FNA_VAL_TBL
567 , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ Pte_Rec_Type
568 , x_PTE_val_rec OUT NOCOPY /* file.sql.39 change */ Pte_Val_Rec_Type
569 , x_RQT_tbl OUT NOCOPY /* file.sql.39 change */ Rqt_Tbl_Type
570 , x_RQT_val_tbl OUT NOCOPY /* file.sql.39 change */ Rqt_Val_Tbl_Type
571 , x_SSC_tbl OUT NOCOPY /* file.sql.39 change */ Ssc_Tbl_Type
572 , x_SSC_val_tbl OUT NOCOPY /* file.sql.39 change */ Ssc_Val_Tbl_Type
573 , x_PSG_tbl OUT NOCOPY /* file.sql.39 change */ Psg_Tbl_Type
574 , x_PSG_val_tbl OUT NOCOPY /* file.sql.39 change */ Psg_Val_Tbl_Type
575 , x_SOU_tbl OUT NOCOPY /* file.sql.39 change */ Sou_Tbl_Type
576 , x_SOU_val_tbl OUT NOCOPY /* file.sql.39 change */ Sou_Val_Tbl_Type
577 );
578
579 -- Start of Comments
580 -- API name Get_Attr_Mapping
581 -- Type Public
582 -- Function
583 --
584 -- Pre-reqs
585 --
586 -- Parameters
587 --
588 -- Version Current version = 1.0
589 -- Initial version = 1.0
590 --
591 -- Notes
592 --
593 -- End of Comments
594
595 PROCEDURE Get_Attr_Mapping
596 ( p_api_version_number IN NUMBER
597 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
598 , p_return_values IN VARCHAR2 := FND_API.G_FALSE
599 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
600 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
601 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
602 , p_lookup_code IN VARCHAR2 :=
603 FND_API.G_MISS_CHAR
604 , p_lookup IN VARCHAR2 :=
605 FND_API.G_MISS_CHAR
606 , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ Pte_Rec_Type
607 , x_PTE_val_rec OUT NOCOPY /* file.sql.39 change */ Pte_Val_Rec_Type
608 , x_RQT_tbl OUT NOCOPY /* file.sql.39 change */ Rqt_Tbl_Type
609 , x_RQT_val_tbl OUT NOCOPY /* file.sql.39 change */ Rqt_Val_Tbl_Type
610 , x_SSC_tbl OUT NOCOPY /* file.sql.39 change */ Ssc_Tbl_Type
611 , x_SSC_val_tbl OUT NOCOPY /* file.sql.39 change */ Ssc_Val_Tbl_Type
612 , x_PSG_tbl OUT NOCOPY /* file.sql.39 change */ Psg_Tbl_Type
613 , x_PSG_val_tbl OUT NOCOPY /* file.sql.39 change */ Psg_Val_Tbl_Type
614 , x_SOU_tbl OUT NOCOPY /* file.sql.39 change */ Sou_Tbl_Type
615 , x_SOU_val_tbl OUT NOCOPY /* file.sql.39 change */ Sou_Val_Tbl_Type
616 , x_FNA_tbl OUT NOCOPY /* file.sql.39 change */ Fna_Tbl_Type
617 , x_FNA_val_tbl OUT NOCOPY /* file.sql.39 change */ Fna_Val_Tbl_Type
618 );
619
620 -- Start of Comments
621 -- API name Get_Attr_Mapping (Overloaded)
622 -- Type Public
623 -- Function
624 --
625 -- Pre-reqs
626 --
627 -- Parameters
628 --
629 -- Version Current version = 1.0
630 -- Initial version = 1.0
631 --
632 -- Notes
633 --
634 -- End of Comments
635
636 PROCEDURE Get_Attr_Mapping
637 ( p_api_version_number IN NUMBER
638 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
639 , p_return_values IN VARCHAR2 := FND_API.G_FALSE
643 , p_lookup_code IN VARCHAR2 :=
640 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
641 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
642 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
644 FND_API.G_MISS_CHAR
645 , p_lookup IN VARCHAR2 :=
646 FND_API.G_MISS_CHAR
647 , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ Pte_Rec_Type
648 , x_PTE_val_rec OUT NOCOPY /* file.sql.39 change */ Pte_Val_Rec_Type
649 , x_RQT_tbl OUT NOCOPY /* file.sql.39 change */ Rqt_Tbl_Type
650 , x_RQT_val_tbl OUT NOCOPY /* file.sql.39 change */ Rqt_Val_Tbl_Type
651 , x_SSC_tbl OUT NOCOPY /* file.sql.39 change */ Ssc_Tbl_Type
652 , x_SSC_val_tbl OUT NOCOPY /* file.sql.39 change */ Ssc_Val_Tbl_Type
653 , x_PSG_tbl OUT NOCOPY /* file.sql.39 change */ Psg_Tbl_Type
654 , x_PSG_val_tbl OUT NOCOPY /* file.sql.39 change */ Psg_Val_Tbl_Type
655 , x_SOU_tbl OUT NOCOPY /* file.sql.39 change */ Sou_Tbl_Type
656 , x_SOU_val_tbl OUT NOCOPY /* file.sql.39 change */ Sou_Val_Tbl_Type
657 );
658
659 END QP_Attr_Map_PUB;