APPS.ISC_FS_RPT_UTIL_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 419: , p_parameter_data_type => bis_pmv_parameters_pub.varchar2_bind

415:
416: add_custom_bind_parameter
417: ( p_custom_output => p_custom_output
418: , p_parameter_name => '&ISC_UNASSIGNED'
419: , p_parameter_data_type => bis_pmv_parameters_pub.varchar2_bind
420: , p_parameter_value => fnd_message.get_string('BIS','BIS_UNASSIGNED')
421: );
422:
423: add_custom_bind_parameter

Line 426: , p_parameter_data_type => bis_pmv_parameters_pub.varchar2_bind

422:
423: add_custom_bind_parameter
424: ( p_custom_output => p_custom_output
425: , p_parameter_name => '&ISC_FS_DIRECT'
426: , p_parameter_data_type => bis_pmv_parameters_pub.varchar2_bind
427: , p_parameter_value => fnd_message.get_string('ISC','ISC_FS_DIRECT')
428: );
429:
430: end bind_unassigned;

Line 607: , BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND

603: begin
604: add_custom_bind_parameter
605: ( p_custom_output
606: , '&ISC_FS_DIST_FACTOR'
607: , BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND
608: , case
609: when p_distance = 'mi' then 0.62137
610: else 1
611: end

Line 672: , p_parameter_data_type => bis_pmv_parameters_pub.integer_bind

668:
669: add_custom_bind_parameter
670: ( p_custom_output => p_custom_output
671: , p_parameter_name => '&ISC_GRP_ID'
672: , p_parameter_data_type => bis_pmv_parameters_pub.integer_bind
673: , p_parameter_value => to_char(l_grp_id)
674: );
675:
676: end bind_group_id;

Line 934: , bis_pmv_parameters_pub.varchar2_bind

930: -- of l_district_id or "ALL"
931: add_custom_bind_parameter
932: ( p_custom_output
933: , '&' || G_DISTRICT_SHORT
934: , bis_pmv_parameters_pub.varchar2_bind
935: , nvl(l_district_id,'ALL')
936: );
937:
938: if l_district_id is null then

Line 953: , bis_pmv_parameters_pub.numeric_bind

949: and fact.parent_district_id = &ISC_FS_PARENT_DISTRICT';
950: add_custom_bind_parameter
951: ( p_custom_output
952: , '&ISC_FS_PARENT_DISTRICT'
953: , bis_pmv_parameters_pub.numeric_bind
954: , substr(l_district_id, instr(l_district_id,'.')+1)
955: );
956:
957: end if;

Line 1471: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;

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:
1473: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
1474: l_custom_rec.attribute_name := p_parameter_name ;
1475: l_custom_rec.attribute_data_type := p_parameter_data_type;

Line 1473: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

1469: end if;
1470:
1471: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
1472:
1473: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
1474: l_custom_rec.attribute_name := p_parameter_name ;
1475: l_custom_rec.attribute_data_type := p_parameter_data_type;
1476: l_custom_rec.attribute_value := p_parameter_value;
1477: p_custom_output.extend;

Line 1556: , p_parameter_data_type => BIS_PMV_PARAMETERS_PUB.INTEGER_BIND

1552:
1553: add_custom_bind_parameter
1554: ( p_custom_output => p_custom_output
1555: , p_parameter_name => nvl(p_low_token,'&ISC_FS_LOW')
1556: , p_parameter_data_type => BIS_PMV_PARAMETERS_PUB.INTEGER_BIND
1557: , p_parameter_value => nvl(l_range_low, -99999999)
1558: );
1559:
1560: add_custom_bind_parameter

Line 1563: , p_parameter_data_type => BIS_PMV_PARAMETERS_PUB.INTEGER_BIND

1559:
1560: add_custom_bind_parameter
1561: ( p_custom_output => p_custom_output
1562: , p_parameter_name => nvl(p_high_token,'&ISC_FS_HIGH')
1563: , p_parameter_data_type => BIS_PMV_PARAMETERS_PUB.INTEGER_BIND
1564: , p_parameter_value => nvl(l_range_high, 99999999)
1565: );
1566:
1567: end bind_low_high;