1 PACKAGE AS_FOUNDATION_PVT AUTHID CURRENT_USER as
2 /* $Header: asxvfous.pls 120.1 2005/12/06 03:15:51 amagupta noship $ */
3
4 -- Start of Comments
5 --
6 -- NAME
7 -- AS_FOUNDATION_PVT
8 --
9 -- PURPOSE
10 -- This package is a private utility API for OSM
11 --
12 -- Procedures:
13 -- translate_orderBy
14 -- get_periodNames
15 -- get_lookupMeaning
16 -- get_unitOfMeasure
17 -- get_uomCode
18 -- get_currency
19 -- get_inventoryItems
20 -- get_messages
21 --
22 -- NOTES
23 -- This package is for private use only
24 --
25 --
26 -- HISTORY
27 -- 07/22/98 AWU Created
28 -- 07/30/98 ALHUNG Added Get_InventoryItems
29 -- 08/6/98 ALHUNG Moved inventory_item_rec definition
30 -- to AS_FOUNDATION_PUB
31 -- 08/11/98 ALHUNG Added Get_InventoryItemPrice
32 -- 06/22/99 AWU Added get_messages
33 --
34 -- End of Comments
35
36 -- Following are lookup tables that caller can use for.
37
38 G_AS_LOOKUPS VARCHAR2(30) := 'AS_LOOKUPS';
39 G_AR_LOOKUPS VARCHAR2(30) := 'AR_LOOKUPS';
40 --G_SO_LOOKUPS VARCHAR2(30) := 'SO_LOOKUPS';
41 G_HR_LOOKUPS VARCHAR2(30) := 'HR_LOOKUPS';
42 G_FND_COMMON_LOOKUPS VARCHAR2(30) := 'FND_COMMON_LOOKUPS';
43 G_CS_LOOKUPS VARCHAR2(30) := 'CS_LOOKUPS';
44
45 -- ***********************
46 -- Composite Types
47 -- ***********************
48
49 -- Start of Comments
50 --
51 -- currency record: util_currency_rec_type
52 --
53 -- parameters:
54 --
55 -- required:
56 --
57 -- defaults:
58 -- None
59 -- End of Comments
60
61
62 -- Start of Comments
63 --
64 -- Order by record: util_order_by_rec_type
65 --
66 -- parameters:
67 --
68 -- required: None
69 --
70 -- defaults: None
71 --
72 -- Notes: 1. col_x_choice is a two or three digit number.
73 -- First digit represents the priority for the order by column.
74 -- (If priority > 10, use 2 digits to represent it)
75 -- Second(or third) digit represents the descending or ascending order for the query
76 -- result. 1 for ascending and 0 for descending.
77 -- 2. col_x_name is the order by column name.
78 -- 3. The total order by columns are ten.
79 --
80 -- End of Comments
81
82
83 TYPE util_order_by_rec_type IS RECORD
84 (
85 col_1_choice NUMBER := NULL,
86 col_1_name VARCHAR2(30) := NULL,
87 col_2_choice NUMBER := NULL,
88 col_2_name VARCHAR2(30) := NULL,
89 col_3_choice NUMBER := NULL,
90 col_3_name VARCHAR2(30) := NULL,
91 col_4_choice NUMBER := NULL,
92 col_4_name VARCHAR2(30) := NULL,
93 col_5_choice NUMBER := NULL,
94 col_5_name VARCHAR2(30) := NULL,
95 col_6_choice NUMBER := NULL,
96 col_6_name VARCHAR2(30) := NULL,
97 col_7_choice NUMBER := NULL,
98 col_7_name VARCHAR2(30) := NULL,
99 col_8_choice NUMBER := NULL,
100 col_8_name VARCHAR2(30) := NULL,
101 col_9_choice NUMBER := NULL,
102 col_9_name VARCHAR2(30) := NULL,
103 col_10_choice NUMBER := NULL,
104 col_10_name VARCHAR2(30) := NULL,
105 col_11_choice NUMBER := NULL,
106 col_11_name VARCHAR2(30) := NULL,
107 col_12_choice NUMBER := NULL,
108 col_12_name VARCHAR2(30) := NULL,
109 col_13_choice NUMBER := NULL,
110 col_13_name VARCHAR2(30) := NULL,
111 col_14_choice NUMBER := NULL,
112 col_14_name VARCHAR2(30) := NULL
113 );
114
115 G_MISS_UTIL_ORDER_BY_REC util_order_by_rec_type;
116
117
118 -- Start of Comments
119 --
120 -- Flexfield where record: flex_where_rec_type
121 --
122 -- parameters:
123 --
124 -- required: None
125 --
126 -- defaults: None
127 --
128 -- Notes: 1. name is the column name in where clause. Its format is
129 -- table_alias.column_name.
130 -- 2. value is the search criteria for the column
131 --
132 -- End of Comments
133
134 TYPE flex_where_rec_type IS RECORD
135 (
136 name VARCHAR2(30) := NULL,
137 value VARCHAR2(150) := NULL
138 );
139
140 TYPE flex_where_tbl_type IS TABLE OF flex_where_rec_type
141 INDEX BY BINARY_INTEGER;
142
143
144 -- Start of Comments
145 --
146 -- period name record: util_period_rec_type
147 --
148 -- parameters:
149 --
150 -- required:
151 --
152 -- defaults:
153 -- None
154 -- End of Comments
155
156
157 TYPE util_period_rec_type is RECORD
158 (
159 period_name VARCHAR2(20) := NULL,
160 start_date DATE := NULL,
161 end_date DATE := NULL
162 );
163
164 G_MISS_UTIL_PERIOD_REC util_period_rec_type;
165
166
167 -- Start of Comments
168 --
169 -- Util_Period Table: util_period_tbl_type
170 --
171 -- End of Comments
172
173 TYPE util_period_tbl_type IS TABLE OF util_period_rec_type
174 INDEX BY BINARY_INTEGER;
175
176 G_MISS_UTIL_PERIOD_TBL util_period_tbl_type;
177
178
179 -- Start of Comments
180 --
181 -- API name : translate_orderBy
182 -- Type : Private
183 -- Function : translate order by choice numbers and columns into
184 -- a order by string with the order of column names and
185 -- descending or ascending request.
186 --
187 --
188 -- Paramaeters :
189 -- IN :
190 -- p_api_version_number IN NUMBER,
191 -- p_init_msg_list IN VARCHAR2
192 -- p_validation_level IN NUMBER
193 -- OUT :
194 -- x_return_status OUT VARCHAR2(1)
195 -- x_msg_count OUT NUMBER
196 -- x_msg_data OUT VARCHAR2(2000)
197 --
198 -- Version : Current version 2.0
199 -- Initial version 1.0
200 --
201 --
202 --
203 -- End of Comments
204
205 PROCEDURE Translate_OrderBy
206 ( p_api_version_number IN NUMBER,
207 p_init_msg_list IN VARCHAR2
208 := FND_API.G_FALSE,
209 p_validation_level IN NUMBER
210 := FND_API.G_VALID_LEVEL_FULL,
211 p_order_by_rec IN UTIL_ORDER_BY_REC_TYPE,
212 x_order_by_clause OUT NOCOPY VARCHAR2,
213 x_return_status OUT NOCOPY VARCHAR2,
214 x_msg_count OUT NOCOPY NUMBER,
215 x_msg_data OUT NOCOPY VARCHAR2
216 );
217
218
219 -- Start of Comments
220 --
221 -- API name : Get_PeriodNames
222 -- Type : Private
223 -- Function : Provide a table of period names, start_date and end date
224 -- by given start_date and end_date or period name.
225 --
226 -- Paramaeters :
227 -- IN :
228 -- p_api_version_number IN NUMBER,
229 -- p_init_msg_list IN VARCHAR2
230 -- p_validation_level IN NUMBER
231 -- OUT :
232 -- x_return_status OUT VARCHAR2(1)
233 -- x_msg_count OUT NUMBER
234 -- x_msg_data OUT VARCHAR2(2000)
235 --
236 -- Version : Current version 2.0
237 -- Initial version 1.0
238 --
239 --
240 --
241 -- End of Comments
242
243 PROCEDURE Get_PeriodNames
244 ( p_api_version_number IN NUMBER,
245 p_init_msg_list IN VARCHAR2
246 := FND_API.G_FALSE,
247 p_validation_level IN NUMBER
248 := FND_API.G_VALID_LEVEL_FULL,
249 p_period_rec IN UTIL_PERIOD_REC_TYPE,
250 x_period_tbl OUT NOCOPY UTIL_PERIOD_TBL_TYPE,
251 x_return_status OUT NOCOPY VARCHAR2,
252 x_msg_count OUT NOCOPY NUMBER,
253 x_msg_data OUT NOCOPY VARCHAR2
254 );
255
256
257 -- Start of Comments
258 --
259 -- API name : get_lookupMeaning
260 -- Type : Private
261 -- Function : Return lookup meaning by given lookup type and lookup code
262 --
263 -- Paramaeters :
264 -- IN :
265 --
266 -- Version : Current version 2.0
267 -- Initial version 1.0
268 --
269 -- Notes: The valid inputs for p_tablename are:
270 -- G_AS_LOOKUPS VARCHAR2 := 'AS_LOOKUPS',
271 -- G_AR_LOOKUPS VARCHAR2 := 'AR_LOOKUPS',
272 -- G_SO_LOOKUPS VARCHAR2 := 'SO_LOOKUPS',
273 -- G_HR_LOOKUPS VARCHAR2 := 'HR_LOOKUPS',
274 -- G_FND_COMMON_LOOKUPS VARCHAR2 := 'FND_COMMON_LOOKUPS',
275 -- G_CS_LOOKUPS VARCHAR2 := 'CS_LOOKUPS'
276 --
277 -- End of Comments
278
279 FUNCTION get_lookupMeaning
280 ( p_lookup_type IN VARCHAR2,
281 p_lookup_code IN VARCHAR2,
282 p_tablename IN VARCHAR2
283 ) RETURN VARCHAR2;
284
285 PRAGMA RESTRICT_REFERENCES(get_lookupMeaning, WNDS);
286
287 -- Start of Comments
288 --
289 -- API name : get_unitOfMeasure
290 -- Type : Private
291 -- Function : Return unit of measure by given UOM_code
292 --
293 -- Paramaeters :
294 -- IN :
295 --
296 -- Version : Current version 2.0
297 -- Initial version 1.0
298 --
299 --
300 --
301 -- End of Comments
302
303 FUNCTION get_unitOfMeasure(p_uom_code IN VARCHAR2) RETURN VARCHAR2;
304
305 PRAGMA RESTRICT_REFERENCES(get_unitOfMeasure, WNDS);
306
307 -- Start of Comments
308 --
309 -- API name : get_uomCode
310 -- Type : Private
311 -- Function : Return unit of measure by given UOM
312 --
313 -- Paramaeters :
314 -- IN :
315 --
316 -- Version : Current version 2.0
317 -- Initial version 1.0
318 --
319 --
320 --
321 -- End of Comments
322
323 FUNCTION get_uomCode(p_uom IN VARCHAR2) RETURN VARCHAR2;
324
325 PRAGMA RESTRICT_REFERENCES(get_uomCode, WNDS);
326
327
328 -- Start of Comments
329 --
330 -- API name : Get_Currency
331 -- Type : Private
332 -- Function : Provide a record of currency by given currency_code
333 --
334 -- Paramaeters :
335 -- IN :
336 -- p_api_version_number IN NUMBER,
337 -- p_init_msg_list IN VARCHAR2
338 -- p_validation_level IN NUMBER
339 -- OUT :
340 -- x_return_status OUT VARCHAR2(1)
341 -- x_msg_count OUT NUMBER
342 -- x_msg_data OUT VARCHAR2(2000)
343 --
344 -- Version : Current version 2.0
345 -- Initial version 1.0
346 --
347 --
348 --
349 -- End of Comments
350
351
352
353 --
354 -- API name : Get_Inventory_Items
355 -- Type : Private
356 -- Function : Get/Find invenotory items that satisfy caller specified criteria.
357 --
358 -- Pre-reqs : None
359 -- Paramaeters :
360 -- IN :
361 -- p_api_version_number IN NUMBER Required
362 -- p_identity_salesforce_id IN NUMBER Optional
363 -- Default = NULL
364 -- p_init_msg_list IN VARCHAR2 Optional
365 -- Default = FND_API.G_FALSE
366 -- p_inventory_item_rec IN Inventory_Item_Rec Required
367 --
368 -- OUT :
369 -- x_return_status OUT VARCHAR2(1)
370 -- x_msg_count OUT NUMBER
371 -- x_msg_data OUT VARCHAR2(2000)
372 -- x_opp_tbl OUT AS_OPPORTUNITY_PUB.Opp_tbl_Type
373 -- x_returned_rec_count OUT NUMBER
374 -- x_next_rec_ptr OUT NUMBER
375 -- x_tot_rec_count OUT NUMBER
376 --
377 -- Version : Current version 2.0
378 -- Initial version 1.0
379 --
380 -- Requirement:
381 -- 1. p_inventory_item_rec.Organization_id is required for any search.
382 -- Use one of the global variables to set this criteria. Valid values are:
383 -- G_Collateral_Organization, G_Quote_Organization, G_Product_Organization
384 --
385 -- Limitation:
386 -- 1. Only Inventory_item_id, Concatenated_segments, Description,
387 -- Collateral_flag, BOM_item_type are
388 -- considered criteria. Other fields are for viewing purpose only.
389
390 PROCEDURE Get_inventory_items( p_api_version_number IN NUMBER,
391 p_init_msg_list IN VARCHAR2
392 := FND_API.G_FALSE,
393 p_identity_salesforce_id IN NUMBER,
394 p_validation_level IN NUMBER
395 := FND_API.G_VALID_LEVEL_FULL,
396 p_inventory_item_rec IN AS_FOUNDATION_PUB.Inventory_Item_REC_TYPE,
397 x_return_status OUT NOCOPY VARCHAR2,
398 x_msg_count OUT NOCOPY NUMBER,
399 x_msg_data OUT NOCOPY VARCHAR2,
400 x_inventory_item_tbl OUT NOCOPY AS_FOUNDATION_PUB.inventory_item_TBL_TYPE);
401
402 --
403 -- Start of Comments
404 --
405 -- API name : get_inventory_tiem
406 -- Type : Private
407 -- Function : Return concatenated segements based on inventory_item_id and
408 -- organization_id
409 --
410 -- Paramaeters :
411 -- IN : p_inventory_item_id, p_organization_id
412 --
413 -- Version : Current version 2.0
414 -- Initial version 1.0
415 --
416
417 FUNCTION Get_Concatenated_Segments( p_inventory_item_id IN NUMBER
418 ,p_organization_id IN NUMBER) return Varchar2;
419
420 PRAGMA RESTRICT_REFERENCES(Get_Concatenated_Segments, WNDS);
421
422
423 --
424 -- API name : Get_Inventory_ItemPrice
425 -- Type : Private
426 -- Function : return list price of inventory item.
427 --
428 -- Pre-reqs : None
429 -- Paramaeters :
430 -- IN :
434 -- p_init_msg_list IN VARCHAR2 Optional
431 -- p_api_version_number IN NUMBER Required
432 -- p_identity_salesforce_id IN NUMBER Optional
433 -- Default = NULL
435 -- Default = FND_API.G_FALSE
436 -- p_inventory_item_rec IN Inventory_Item_Rec Required
437 --
438 --
439 -- OUT :
440 -- x_return_status OUT VARCHAR2(1)
441 -- x_msg_count OUT NUMBER
442 -- x_msg_data OUT VARCHAR2(2000)
443 -- x_list_price OUT NUMBER
444 -- x_currency_code OUT VARCHAR2
445 --
446 -- Version : Current version 2.0
447 -- Initial version 1.0
448 --
449 -- Requirement:
450 -- 1. p_inventory_item_rec.inventory_item_id
451 -- 2. p_inventory_item_rec.primary_uom_code
452 -- 3. p_price_list_id
453 --
454 -- Limitation:
455 -- 1. Secondary Price List is not considered.
456
457 PROCEDURE Get_inventory_itemPrice( p_api_version_number IN NUMBER,
458 p_init_msg_list IN VARCHAR2
459 := FND_API.G_FALSE,
460 p_identity_salesforce_id IN NUMBER,
461 p_validation_level IN NUMBER
462 := FND_API.G_VALID_LEVEL_FULL,
463 p_inventory_item_rec IN AS_FOUNDATION_PUB.Inventory_Item_REC_TYPE,
464 p_price_list_id IN NUMBER,
465 x_return_status OUT NOCOPY VARCHAR2,
466 x_msg_count OUT NOCOPY NUMBER,
467 x_msg_data OUT NOCOPY VARCHAR2,
468 x_list_price OUT NOCOPY NUMBER,
469 x_currency_code OUT NOCOPY VARCHAR2);
470
471 --
472 -- API name : Get_Price_List_Id
473 -- Type : Private
474 -- Function : return price list id for a price group and specified currency code.
475 --
476 -- Pre-reqs : None
477 -- Paramaeters :
478 -- IN :
479 -- p_api_version_number IN NUMBER Required
480 -- p_init_msg_list IN VARCHAR2 Optional
481 -- Default = FND_API.G_FALSE
482 -- p_validation_level IN NUMBER Optional
483 -- p_currency_code IN VARCHAR2 Required
484 --
485 -- OUT :
486 -- x_return_status OUT VARCHAR2(1)
487 -- x_msg_count OUT NUMBER
488 -- x_msg_data OUT VARCHAR2(2000)
489 -- x_price_list_id OUT NUMBER
490 --
491 -- Version :
492 --
493 -- Note:
494 --
495 PROCEDURE Get_Price_List_Id(p_api_version_number IN NUMBER,
496 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
497 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
498 x_return_status OUT NOCOPY VARCHAR2,
499 x_msg_count OUT NOCOPY NUMBER,
500 x_msg_data OUT NOCOPY VARCHAR2,
501 p_currency_code IN VARCHAR2,
502 x_price_list_id OUT NOCOPY NUMBER);
503
504 --
505 -- API name : Get_Price_Info
506 -- Type : Private
507 -- Function : return price list id and price for an inventory inem or price for a product family.
508 --
509 -- Pre-reqs : None
510 -- Paramaeters :
511 -- IN :
512 -- p_api_version_number IN NUMBER Required
513 -- p_init_msg_list IN VARCHAR2 Optional
514 -- Default FND_API.G_FALSE
515 -- p_validation_level IN NUMBER Optional
516 -- Default FND_API.G_VALID_LEVEL_FULL
517 -- p_inventory_item_rec IN AS_FOUNDATION_PUB.Inventory_Item_REC_TYPE Optional
518 -- Default AS_FOUNDATION_PUB.G_MISS_INVENTORY_ITEM_REC,
519 -- p_secondary_interest_code_id IN NUMBER Optional
520 -- Default FND_API.G_MISS_NUM,
521 -- p_currency_code IN VARCHAR2 Required
522 --
523 -- OUT :
524 -- x_return_status OUT VARCHAR2(1)
525 -- x_msg_count OUT NUMBER
526 -- x_msg_data OUT VARCHAR2(2000)
527 -- x_price_list_id OUT NUMBER
528 -- x_price OUT NUMBER
529 --
530 -- Version :
531 --
532 -- Note:
533 --
534 PROCEDURE Get_Price_Info(p_api_version_number IN NUMBER,
535 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
536 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
537 p_inventory_item_rec IN AS_FOUNDATION_PUB.Inventory_Item_REC_TYPE DEFAULT AS_FOUNDATION_PUB.G_MISS_INVENTORY_ITEM_REC,
538 p_secondary_interest_code_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
539 p_currency_code IN VARCHAR2,
540 x_return_status OUT NOCOPY VARCHAR2,
544 x_price OUT NOCOPY NUMBER);
541 x_msg_count OUT NOCOPY NUMBER,
542 x_msg_data OUT NOCOPY VARCHAR2,
543 x_price_list_id OUT NOCOPY NUMBER,
545
546 -- Start of Comments
547 --
548 -- API name : Check_Volume_Amount
549 -- Type :
550 -- Pre-reqs :
551 -- Function :
552 -- This api takes inventory_item_rec, secondary_interest_code_id, currency_code, volume
553 -- and amount as the input, it will compute volume or amount if either of them is missed
554 -- or check the consistency between them if both of them have been set a value.
555 --
556 -- Parameters :
557 -- IN :
558 -- p_api_version_number IN NUMBER,
559 -- p_init_msg_list IN VARCHAR2
560 -- := FND_API.G_FALSE
561 -- p_validation_level IN NUMBER
562 -- := FND_API.G_VALID_LEVEL_FULL
563 -- p_inventory_item_rec IN AS_FOUNDATION_PUB.Inventory_Item_REC_TYPE
564 -- DEFAULT AS_FOUNDATION_PUB.G_MISS_INVENTORY_ITEM_REC
565 -- p_secondary_interest_code_id IN NUMBER
566 -- DEFAULT FND_API.G_MISS_NUM
567 -- p_currency_code IN VARCHAR2
568 -- p_volume IN NUMBER
569 -- DEFAULT FND_API.G_MISS_NUM
570 -- p_amount IN NUMBER
571 -- DEFAULT FND_API.G_MISS_NUM
572 -- x_return_status OUT VARCHAR2
573 -- x_msg_count OUT NUMBER
574 -- x_msg_data OUT VARCHAR2
575 -- x_vol_tolerance_margin OUT NUMBER
576 -- x_volume OUT NUMBER
577 -- x_amount OUT NUMBER
578 -- x_uom_code OUT VARCHAR2
579 -- x_price_list_id OUT NUMBER
580 -- x_price OUT NUMBER
581 --
582 -- Version :
583 --
584 -- HISTORY
585 -- 19-Nov-1998 J. Shang Created
586 -- Note :
587 -- 1. Inventory item will overwrite the secondary interest code when both of them are set
588 -- 2. The values needed in pass-in parameter p_inventory_item_rec maybe:
589 -- Item_Id, Organization_Id and uom_code
590 -- Among them, if uom_code is not set, the value in the table will be used
591 -- 3. p_volume, p_amount and p_volume_1, p_amount_1 are two pairs of volume_amount to be checking.
592 -- But it only computs p_volume and p_amount if one of them is missed, not p_volume_1 and p_amount_1.
593 -- So, there is only one pair of volume_amount in the output parameters.
594 -- 4. If the profile value tells that the volume forecasting is disabled, all parameters from
595 -- x_vol_tolerance_margin to x_price will be NULL and x_return_status is FND_API.G_RET_STS_SUCCESS.
596 --End of Comments
597 PROCEDURE Check_Volume_Amount(p_api_version_number IN NUMBER,
598 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
599 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
600 p_inventory_item_rec IN AS_FOUNDATION_PUB.Inventory_Item_REC_TYPE DEFAULT AS_FOUNDATION_PUB.G_MISS_INVENTORY_ITEM_REC,
601 p_secondary_interest_code_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
602 p_currency_code IN VARCHAR2,
603 p_volume IN NUMBER DEFAULT FND_API.G_MISS_NUM,
604 p_amount IN NUMBER DEFAULT FND_API.G_MISS_NUM,
605 x_return_status OUT NOCOPY VARCHAR2,
606 x_msg_count OUT NOCOPY NUMBER,
607 x_msg_data OUT NOCOPY VARCHAR2,
608 x_vol_tolerance_margin OUT NOCOPY NUMBER,
609 x_volume OUT NOCOPY NUMBER,
610 x_amount OUT NOCOPY NUMBER,
611 x_uom_code OUT NOCOPY VARCHAR2,
612 x_price_list_id OUT NOCOPY NUMBER,
613 x_price OUT NOCOPY NUMBER);
614
615
616 -- Name: Gen_NoBind_Flex_Where
617 -- Function: common procedure for flexfield search without binding
618 -- IN: p_flex_where_tbl_type: column names and the search criteria
619 -- for those columns in where clause
620 -- OUT: x_flex_where_clause: where clause based on flexfield, the format
621 -- of which like ' AND table.column1 = value1 AND
622 -- table.column2 = value2 ...'
623 --
624
625 PROCEDURE Gen_NoBind_Flex_Where(
626 p_flex_where_tbl_type IN AS_FOUNDATION_PVT.flex_where_tbl_type,
627 x_flex_where_clause OUT NOCOPY VARCHAR2);
628
629 -- Name: Gen_Flexfield_Where
630 -- Function: common procedure for flexfield search with binding
631 -- IN: p_flex_where_tbl_type: column names and the search criteria
632 -- for those columns in where clause
633 -- OUT: x_flex_where_clause: where clause based on flexfield, the format
634 -- of which like ' AND table.column1 = :p_ofso_flex_var1 AND
635 -- table.column2 = :p_ofso_flex_var2 ...'
636
637 PROCEDURE Gen_Flexfield_Where(
638 p_flex_where_tbl_type IN AS_FOUNDATION_PVT.flex_where_tbl_type,
639 x_flex_where_clause OUT NOCOPY VARCHAR2);
640
641 -- Name: Bind_Flexfield_Where
642 -- Function: common procedure for flexfield search with binding. Bind
643 -- placeholders in the where clause generated by Gen_Flecfield_Where.
644 -- IN: p_cursor_id: identifier of the cursor for binding.
645 -- p_flex_where_tbl_type: column names and the search criteria
646 -- for those columns in where clause
647 -- OUT: none.
648
649 PROCEDURE Bind_Flexfield_Where(
650 p_cursor_id IN NUMBER,
651 p_flex_where_tbl_type IN AS_FOUNDATION_PVT.flex_where_tbl_type);
652
653 PROCEDURE Get_Messages (p_message_count IN NUMBER,
654 p_msgs OUT NOCOPY VARCHAR2);
655
656 END AS_FOUNDATION_PVT;