395: if p_custom_output is null then
396: p_custom_output := bis_query_attributes_tbl();
397: end if;
398:
399: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
400:
401: l_custom_rec.attribute_name := '&ISC_UNASSIGNED' ;
402: l_custom_rec.attribute_value := fnd_message.get_string('BIS','BIS_UNASSIGNED');
403: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
399: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
400:
401: l_custom_rec.attribute_name := '&ISC_UNASSIGNED' ;
402: l_custom_rec.attribute_value := fnd_message.get_string('BIS','BIS_UNASSIGNED');
403: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
404: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
405: p_custom_output.extend;
406: p_custom_output(p_custom_output.count) := l_custom_rec;
407:
400:
401: l_custom_rec.attribute_name := '&ISC_UNASSIGNED' ;
402: l_custom_rec.attribute_value := fnd_message.get_string('BIS','BIS_UNASSIGNED');
403: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
404: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
405: p_custom_output.extend;
406: p_custom_output(p_custom_output.count) := l_custom_rec;
407:
408: end bind_unassigned;
605: dbms_sql.column_value(l_cur_hdl, 1, l_grp_id);
606: end if;
607: dbms_sql.close_cursor(l_cur_hdl);
608:
609: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
610:
611: l_custom_rec.attribute_name := '&ISC_GRP_ID' ;
612: l_custom_rec.attribute_value := l_grp_id;
613: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
609: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
610:
611: l_custom_rec.attribute_name := '&ISC_GRP_ID' ;
612: l_custom_rec.attribute_value := l_grp_id;
613: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
614: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
615: p_custom_output.extend;
616: p_custom_output(p_custom_output.count) := l_custom_rec;
617:
610:
611: l_custom_rec.attribute_name := '&ISC_GRP_ID' ;
612: l_custom_rec.attribute_value := l_grp_id;
613: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
614: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
615: p_custom_output.extend;
616: p_custom_output(p_custom_output.count) := l_custom_rec;
617:
618: end bind_group_id;