APPS.BSC_BIS_WRAPPER_PVT dependencies on BIS_PMV_PARAMETERS_PUB

Line 1996: l_page_session_rec BIS_PMV_PARAMETERS_PUB.page_session_rec_type;

1992: x_msg_count OUT NOCOPY NUMBER,
1993: x_msg_data OUT NOCOPY VARCHAR2
1994: ) IS
1995:
1996: l_page_session_rec BIS_PMV_PARAMETERS_PUB.page_session_rec_type;
1997: l_page_param_tbl BIS_PMV_PARAMETERS_PUB.parameter_tbl_type;
1998: i NUMBER;
1999:
2000: TYPE CursorType IS REF CURSOR;

Line 1997: l_page_param_tbl BIS_PMV_PARAMETERS_PUB.parameter_tbl_type;

1993: x_msg_data OUT NOCOPY VARCHAR2
1994: ) IS
1995:
1996: l_page_session_rec BIS_PMV_PARAMETERS_PUB.page_session_rec_type;
1997: l_page_param_tbl BIS_PMV_PARAMETERS_PUB.parameter_tbl_type;
1998: i NUMBER;
1999:
2000: TYPE CursorType IS REF CURSOR;
2001: l_cursor CursorType;

Line 2018: BIS_PMV_PARAMETERS_PUB.RETRIEVE_PAGE_PARAMETERS(

2014:
2015: l_page_session_rec.user_id := p_user_id;
2016: l_page_session_rec.page_id := p_page_id;
2017:
2018: BIS_PMV_PARAMETERS_PUB.RETRIEVE_PAGE_PARAMETERS(
2019: p_page_session_rec => l_page_session_rec
2020: ,x_page_param_tbl => l_page_param_tbl
2021: ,x_return_status => x_return_status
2022: ,x_msg_count => x_msg_count

Line 2032: -- to PMV in order to include it in the BIS_PMV_PARAMETERS_PUB.RETRIEVE_PAGE_PARAMETERS

2028: x_page_parameters(i).value_name := l_page_param_tbl(i).parameter_description;
2029: END LOOP;
2030:
2031: -- This is a workaround to get TIME_COMPARISON_PARAMETER. There is a open bug#2609475
2032: -- to PMV in order to include it in the BIS_PMV_PARAMETERS_PUB.RETRIEVE_PAGE_PARAMETERS
2033: i := x_page_parameters.COUNT + 1;
2034: l_sql := 'SELECT attribute_name, session_value, session_description'||
2035: ' FROM bis_user_attributes'||
2036: ' WHERE user_id = :1 AND page_id = :2 AND dimension = :3';