161:
162: End get_List;
163: --
164: procedure Get_List
165: ( p_attribute_app_id IN NUMBER := BIS_UTILITIES_PVT.G_BIS_APPLICATION_ID
166: , p_attribute_code IN VARCHAR2
167: , p_attribute_name IN VARCHAR2
168: , p_region_app_id IN NUMBER := BIS_UTILITIES_PVT.G_BIS_APPLICATION_ID
169: , p_region_code IN VARCHAR2
164: procedure Get_List
165: ( p_attribute_app_id IN NUMBER := BIS_UTILITIES_PVT.G_BIS_APPLICATION_ID
166: , p_attribute_code IN VARCHAR2
167: , p_attribute_name IN VARCHAR2
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
293:
294: END Get_List;
295:
296: procedure Get_List
297: ( p_attribute_app_id IN NUMBER := BIS_UTILITIES_PVT.G_BIS_APPLICATION_ID
298: , p_attribute_code IN VARCHAR2
299: , p_attribute_name IN VARCHAR2
300: , p_region_app_id IN NUMBER := BIS_UTILITIES_PVT.G_BIS_APPLICATION_ID
301: , p_region_code IN VARCHAR2
296: procedure Get_List
297: ( p_attribute_app_id IN NUMBER := BIS_UTILITIES_PVT.G_BIS_APPLICATION_ID
298: , p_attribute_code IN VARCHAR2
299: , p_attribute_name IN VARCHAR2
300: , p_region_app_id IN NUMBER := BIS_UTILITIES_PVT.G_BIS_APPLICATION_ID
301: , p_region_code IN VARCHAR2
302: , p_form_name IN VARCHAR2
303: , p_label IN VARCHAR2
304: , p_where_clause IN VARCHAR2 := NULL
378:
379: END Get_List;
380:
381: procedure Get_List
382: ( p_attribute1_app_id IN NUMBER := BIS_UTILITIES_PVT.G_BIS_APPLICATION_ID
383: , p_attribute1_code IN VARCHAR2
384: , p_attribute1_name IN VARCHAR2
385: , p_region1_app_id IN NUMBER := BIS_UTILITIES_PVT.G_BIS_APPLICATION_ID
386: , p_region1_code IN VARCHAR2
381: procedure Get_List
382: ( p_attribute1_app_id IN NUMBER := BIS_UTILITIES_PVT.G_BIS_APPLICATION_ID
383: , p_attribute1_code IN VARCHAR2
384: , p_attribute1_name IN VARCHAR2
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
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
394: , p_attribute2_name IN VARCHAR2
395: , p_region2_app_id IN NUMBER := BIS_UTILITIES_PVT.G_BIS_APPLICATION_ID
396: , p_region2_code IN VARCHAR2
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
394: , p_attribute2_name 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
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
404: , x_list_str OUT NOCOPY BIS_UTILITIES_PUB.BIS_VARCHAR_TBL
405: )
406: IS
407: l_br VARCHAR2(10) := '
';