1: PACKAGE BODY BIS_LOV_PVT AS
2: /* $Header: BISVLOVB.pls 115.25 2002/12/16 10:25:56 rchandra ship $ */
3: -- Copyright (c) 2000 Oracle Corporation, Redwood Shores, CA, USA
4: -- All rights reserved.
5: --
168: , p_region_app_id IN NUMBER := BIS_UTILITIES_PVT.G_BIS_APPLICATION_ID
169: , p_region_code IN VARCHAR2
170: , p_form_name IN VARCHAR2
171: , p_where_clause IN VARCHAR2 := NULL
172: , p_selected_value IN BIS_LOV_PVT.value_id_record
173: , p_func IN VARCHAR2 := NULL
174: , p_size IN NUMBER := 20
175: , x_list_str OUT NOCOPY BIS_UTILITIES_PUB.BIS_VARCHAR_TBL
176: )
301: , p_region_code IN VARCHAR2
302: , p_form_name IN VARCHAR2
303: , p_label IN VARCHAR2
304: , p_where_clause IN VARCHAR2 := NULL
305: , p_selected_value IN BIS_LOV_PVT.value_id_record
306: , p_func IN VARCHAR2 := NULL
307: , p_size IN NUMBER := 20
308: , x_list_str OUT NOCOPY BIS_UTILITIES_PUB.BIS_VARCHAR_TBL
309: )
346: -- Build List
347: --
348: l_list_str := '
385: , p_region1_app_id IN NUMBER := BIS_UTILITIES_PVT.G_BIS_APPLICATION_ID
386: , p_region1_code IN VARCHAR2
387: , p_form1_name IN VARCHAR2
388: , p_where_clause1 IN VARCHAR2 := NULL
389: , p_selected_value1 IN BIS_LOV_PVT.value_id_record
390: , p_func1 IN VARCHAR2 := NULL
391: , p_size1 IN NUMBER := 20
392: , p_attribute2_app_id IN NUMBER := BIS_UTILITIES_PVT.G_BIS_APPLICATION_ID
393: , p_attribute2_code IN VARCHAR2
395: , p_region2_app_id IN NUMBER := BIS_UTILITIES_PVT.G_BIS_APPLICATION_ID
396: , p_region2_code IN VARCHAR2
397: , p_form2_name IN VARCHAR2
398: , p_where_clause2 IN VARCHAR2 := NULL
399: , p_selected_value2 IN BIS_LOV_PVT.value_id_record
400: , p_func2 IN VARCHAR2 := NULL
401: , p_size2 IN NUMBER := 20
402: , p_label IN VARCHAR2 := NULL
403: , p_separator IN VARCHAR2 := BIS_UTILITIES_PVT.G_BIS_SEPARATOR
443: x_list_str(x_list_str.count + 1) := l_list_str;
444:
445: IF p_label IS NOT NULL THEN
446:
447: BIS_LOV_PVT.Get_List
448: ( p_attribute_app_id => p_attribute1_app_id
449: , p_attribute_code => p_attribute1_code
450: , p_attribute_name => p_attribute1_name
451: , p_region_app_id => p_region1_app_id
459: , x_list_str => l_list_str2
460: );
461: ELSE
462:
463: BIS_LOV_PVT.Get_List
464: ( p_attribute_app_id => p_attribute1_app_id
465: , p_attribute_code => p_attribute1_code
466: , p_attribute_name => p_attribute1_name
467: , p_region_app_id => p_region1_app_id
495: --
496: l_list_str := '
527: END Get_List;
528:
529: --
530: --
531: END BIS_LOV_PVT;