[Home] [Help]
407: -- this is a private procedure that adds the bind variable
408: -- &ISC_UNASSIGNED and the appropriate (translated) text.
409: -- it is called from process_parameters
410: procedure bind_unassigned
411: ( p_custom_output in out nocopy bis_query_attributes_tbl
412: ) is
413:
414: begin
415:
595: -- p_param: the parameter table passed into your report from PMV.
596: -- p_distance: the distance suffix as returned by process_parameters
597: -- "mi" for miles, "km" for kilometers
598: procedure bind_distance_factor
599: ( p_custom_output in out nocopy bis_query_attributes_tbl
600: , p_distance in varchar2
601: )
602: is
603: begin
619: -- this is a public procedure, see package specification for it's
620: -- description
621: procedure bind_group_id
622: ( p_dim_bmap in number
623: , p_custom_output in out nocopy bis_query_attributes_tbl
624: , p_column1 in varchar2 default null
625: , p_column2 in varchar2 default null
626: , p_column3 in varchar2 default null
627: , p_column4 in varchar2 default null
630: , p_column7 in varchar2 default null
631: , p_column8 in varchar2 default null
632: ) is
633:
634: l_custom_rec bis_query_attributes;
635: l_cur_hdl integer;
636: l_stmt varchar2(1000);
637: l_grp_id number;
638:
829: ( p_param in bis_pmv_page_parameter_tbl
830: , p_dimension_tbl in out nocopy t_dimension_tbl
831: , p_dim_filter_map in out nocopy poa_dbi_util_pkg.poa_dbi_dim_map
832: , p_trend in varchar2
833: , p_custom_output in out nocopy bis_query_attributes_tbl
834: , x_cur_suffix out nocopy varchar2
835: , x_where_clause out nocopy varchar2
836: , x_viewby_select out nocopy varchar2
837: , x_join_tbl out nocopy poa_dbi_util_pkg.poa_dbi_join_tbl
923: -- the statement is invalid and will error.
924: -- to work around this problem we force the parameter into the custom
925: -- output so that PMV do the substitution for us.
926:
927: -- due to a restriction on the length of BIS_QUERY_ATTRIBUTES.ATTRIBUTE_NAME
928: -- we cannot pass G_DISTRICT as it is too long. So we pass G_DISTRICT_SHORT.
929: -- this means that we need to always provide a value for it, either the value
930: -- of l_district_id or "ALL"
931: add_custom_bind_parameter
1022: ( p_param in bis_pmv_page_parameter_tbl
1023: , p_dimension_tbl in out nocopy t_dimension_tbl
1024: , p_dim_filter_map in out nocopy poa_dbi_util_pkg.poa_dbi_dim_map
1025: , p_trend in varchar2
1026: , p_custom_output in out nocopy bis_query_attributes_tbl
1027: , x_cur_suffix out nocopy varchar2
1028: , x_where_clause out nocopy varchar2
1029: , x_viewby_select out nocopy varchar2
1030: , x_join_tbl out nocopy poa_dbi_util_pkg.poa_dbi_join_tbl
1452:
1453: -- this is a public procedure, see the package specification for it's
1454: -- description
1455: procedure add_custom_bind_parameter
1456: ( p_custom_output in out nocopy bis_query_attributes_tbl
1457: , p_parameter_name in varchar2
1458: , p_parameter_data_type in varchar2
1459: , p_parameter_value in varchar2
1460: )
1459: , p_parameter_value in varchar2
1460: )
1461: is
1462:
1463: l_custom_rec BIS_QUERY_ATTRIBUTES;
1464:
1465: begin
1466:
1467: if p_custom_output is null then
1464:
1465: begin
1466:
1467: if p_custom_output is null then
1468: p_custom_output := bis_query_attributes_tbl();
1469: end if;
1470:
1471: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
1472:
1484: procedure bind_low_high
1485: ( p_param in bis_pmv_page_parameter_tbl
1486: , p_param_name in varchar2
1487: , p_short_name in varchar2
1488: , p_custom_output in out nocopy bis_query_attributes_tbl
1489: , p_low_token in varchar2 default null
1490: , p_high_token in varchar2 default null
1491: )
1492: is
1498: l_bucket_rec bis_bucket_pub.bis_bucket_rec_type;
1499: l_return_status varchar2(3);
1500: l_error_tbl bis_utilities_pub.error_tbl_type;
1501:
1502: l_custom_rec BIS_QUERY_ATTRIBUTES;
1503:
1504: begin
1505:
1506: l_range_id := get_parameter_id