DBA Data[Home] [Help]

APPS.BIV_DBI_TMPL_UTIL dependencies on BIS_PMV_PARAMETERS_PUB

Line 1483: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

1479: if p_custom_output is null then
1480: p_custom_output := bis_query_attributes_tbl();
1481: end if;
1482:
1483: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1484:
1485: l_custom_rec.attribute_name := p_yes;
1486: l_custom_rec.attribute_value := l_yes;
1487: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

Line 1487: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1483: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1484:
1485: l_custom_rec.attribute_name := p_yes;
1486: l_custom_rec.attribute_value := l_yes;
1487: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1488: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1489: p_custom_output.extend;
1490: p_custom_output(p_custom_output.count) := l_custom_rec;
1491:

Line 1488: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

1484:
1485: l_custom_rec.attribute_name := p_yes;
1486: l_custom_rec.attribute_value := l_yes;
1487: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1488: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1489: p_custom_output.extend;
1490: p_custom_output(p_custom_output.count) := l_custom_rec;
1491:
1492: l_custom_rec.attribute_name := p_no;

Line 1494: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1490: p_custom_output(p_custom_output.count) := l_custom_rec;
1491:
1492: l_custom_rec.attribute_name := p_no;
1493: l_custom_rec.attribute_value := l_no;
1494: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1495: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1496: p_custom_output.extend;
1497: p_custom_output(p_custom_output.count) := l_custom_rec;
1498:

Line 1495: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

1491:
1492: l_custom_rec.attribute_name := p_no;
1493: l_custom_rec.attribute_value := l_no;
1494: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1495: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1496: p_custom_output.extend;
1497: p_custom_output(p_custom_output.count) := l_custom_rec;
1498:
1499: end bind_yes_no;

Line 1578: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

1574: if p_custom_output is null then
1575: p_custom_output := bis_query_attributes_tbl();
1576: end if;
1577:
1578: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1579:
1580: l_custom_rec.attribute_name := p_low;
1581: l_custom_rec.attribute_value := l_range_low;
1582: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

Line 1582: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1578: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1579:
1580: l_custom_rec.attribute_name := p_low;
1581: l_custom_rec.attribute_value := l_range_low;
1582: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1583: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1584: p_custom_output.extend;
1585: p_custom_output(p_custom_output.count) := l_custom_rec;
1586:

Line 1583: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

1579:
1580: l_custom_rec.attribute_name := p_low;
1581: l_custom_rec.attribute_value := l_range_low;
1582: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1583: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1584: p_custom_output.extend;
1585: p_custom_output(p_custom_output.count) := l_custom_rec;
1586:
1587: l_custom_rec.attribute_name := p_high;

Line 1589: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1585: p_custom_output(p_custom_output.count) := l_custom_rec;
1586:
1587: l_custom_rec.attribute_name := p_high;
1588: l_custom_rec.attribute_value := l_range_high;
1589: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1590: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1591: p_custom_output.extend;
1592: p_custom_output(p_custom_output.count) := l_custom_rec;
1593:

Line 1590: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

1586:
1587: l_custom_rec.attribute_name := p_high;
1588: l_custom_rec.attribute_value := l_range_high;
1589: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1590: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1591: p_custom_output.extend;
1592: p_custom_output(p_custom_output.count) := l_custom_rec;
1593:
1594: end bind_low_high;

Line 1704: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;

1700: if p_custom_output is null then
1701: p_custom_output := bis_query_attributes_tbl();
1702: end if;
1703:
1704: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
1705:
1706: l_custom_rec.attribute_name := p_current_name;
1707: l_custom_rec.attribute_value := to_char(l_current_date,'dd/mm/yyyy');
1708: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

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

1704: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
1705:
1706: l_custom_rec.attribute_name := p_current_name;
1707: l_custom_rec.attribute_value := to_char(l_current_date,'dd/mm/yyyy');
1708: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
1709: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.date_bind;
1710: p_custom_output.extend;
1711: p_custom_output(p_custom_output.count) := l_custom_rec;
1712:

Line 1709: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.date_bind;

1705:
1706: l_custom_rec.attribute_name := p_current_name;
1707: l_custom_rec.attribute_value := to_char(l_current_date,'dd/mm/yyyy');
1708: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
1709: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.date_bind;
1710: p_custom_output.extend;
1711: p_custom_output(p_custom_output.count) := l_custom_rec;
1712:
1713: l_custom_rec.attribute_name := '&AGE_CURRENT_ASOF_DATE_TIME';

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

1711: p_custom_output(p_custom_output.count) := l_custom_rec;
1712:
1713: l_custom_rec.attribute_name := '&AGE_CURRENT_ASOF_DATE_TIME';
1714: l_custom_rec.attribute_value := l_current_date_time;
1715: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
1716: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
1717: p_custom_output.extend;
1718: p_custom_output(p_custom_output.count) := l_custom_rec;
1719:

Line 1716: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;

1712:
1713: l_custom_rec.attribute_name := '&AGE_CURRENT_ASOF_DATE_TIME';
1714: l_custom_rec.attribute_value := l_current_date_time;
1715: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
1716: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
1717: p_custom_output.extend;
1718: p_custom_output(p_custom_output.count) := l_custom_rec;
1719:
1720: l_custom_rec.attribute_name := p_prior_name;

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

1718: p_custom_output(p_custom_output.count) := l_custom_rec;
1719:
1720: l_custom_rec.attribute_name := p_prior_name;
1721: l_custom_rec.attribute_value := to_char(l_prior_date,'dd/mm/yyyy');
1722: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
1723: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.date_bind;
1724: p_custom_output.extend;
1725: p_custom_output(p_custom_output.count) := l_custom_rec;
1726:

Line 1723: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.date_bind;

1719:
1720: l_custom_rec.attribute_name := p_prior_name;
1721: l_custom_rec.attribute_value := to_char(l_prior_date,'dd/mm/yyyy');
1722: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
1723: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.date_bind;
1724: p_custom_output.extend;
1725: p_custom_output(p_custom_output.count) := l_custom_rec;
1726:
1727: end bind_age_dates;