APPS.BSC_PORTLET_UI_WRAPPER dependencies on BIS_PMV_PARAMETERS_PUB

Line 66: l_page_session_rec BIS_PMV_PARAMETERS_PUB.page_session_rec_type;

62: ,x_msg_count OUT NOCOPY NUMBER
63: ,x_msg_data OUT NOCOPY VARCHAR2
64: ) IS
65:
66: l_page_session_rec BIS_PMV_PARAMETERS_PUB.page_session_rec_type;
67: l_page_param_tbl BIS_PMV_PARAMETERS_PUB.parameter_tbl_type;
68: i NUMBER;
69:
70: TYPE CursorType IS REF CURSOR;

Line 67: l_page_param_tbl BIS_PMV_PARAMETERS_PUB.parameter_tbl_type;

63: ,x_msg_data OUT NOCOPY VARCHAR2
64: ) IS
65:
66: l_page_session_rec BIS_PMV_PARAMETERS_PUB.page_session_rec_type;
67: l_page_param_tbl BIS_PMV_PARAMETERS_PUB.parameter_tbl_type;
68: i NUMBER;
69:
70: TYPE CursorType IS REF CURSOR;
71: l_cursor CursorType;

Line 88: BIS_PMV_PARAMETERS_PUB.RETRIEVE_PAGE_PARAMETERS(

84:
85: l_page_session_rec.user_id := TO_CHAR(p_user_id);
86: l_page_session_rec.page_id := p_page_id;
87:
88: BIS_PMV_PARAMETERS_PUB.RETRIEVE_PAGE_PARAMETERS(
89: p_page_session_rec => l_page_session_rec
90: ,x_page_param_tbl => l_page_param_tbl
91: ,x_return_status => x_return_status
92: ,x_msg_count => x_msg_count

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

104: Encode_String(l_page_param_tbl(i).parameter_description);
105: END LOOP;
106:
107: -- This is a workaround to get TIME_COMPARISON_PARAMETER. There is a open bug#2609475
108: -- to PMV in order to include it in the BIS_PMV_PARAMETERS_PUB.RETRIEVE_PAGE_PARAMETERS
109: l_sql := 'SELECT attribute_name, session_value, session_description'||
110: ' FROM bis_user_attributes'||
111: ' WHERE user_id = :1 AND page_id = :2 AND dimension = :3';
112: OPEN l_cursor FOR l_sql USING p_user_id, p_page_id, l_dimension;