APPS.BIS_PMV_PORTAL_UTIL_PUB dependencies on BIS_PMV_PARAMETERS_PVT

Line 423: l_parameter_rec BIS_PMV_PARAMETERS_PVT.parameter_rec_type;

419: l_msg_count NUMBER;
420: l_msg_data VARCHAR2(2000);
421: l_region_code VARCHAR2(30);
422: l_function_name fnd_form_functions.function_name%TYPE;
423: l_parameter_rec BIS_PMV_PARAMETERS_PVT.parameter_rec_type;
424: l_user_session_rec BIS_PMV_SESSION_PVT.SESSION_REC_TYPE;
425: v_lov_sql_stmt VARCHAR2(32000);
426: v_bind_sql VARCHAR2(32000);
427: v_bind_variables VARCHAR2(32000);

Line 455: BIS_PMV_PARAMETERS_PVT.RETRIEVE_PAGE_PARAMETER(p_parameter_rec => l_parameter_rec

451: l_user_session_rec.user_id := p_user_id;
452: l_user_session_rec.responsibility_id := p_responsibility_id;
453:
454: l_parameter_rec.parameter_name := x_ranking_param;
455: BIS_PMV_PARAMETERS_PVT.RETRIEVE_PAGE_PARAMETER(p_parameter_rec => l_parameter_rec
456: ,p_schedule_id => NULL
457: ,p_user_session_rec => l_user_session_rec
458: ,p_page_dims => NULL
459: ,x_return_status => l_return_status

Line 469: l_parameter_rec.parameter_description := BIS_PMV_PARAMETERS_PVT.G_ALL;

465: END IF;
466:
467: -- replace with all so that the query picks up all the values,
468: -- restricted only by the lov where clause
469: l_parameter_rec.parameter_description := BIS_PMV_PARAMETERS_PVT.G_ALL;
470: -- get the lov sql for this level
471: IF (x_ranking_param = 'TIME' OR x_ranking_param = 'EDW_TIME') THEN
472: BIS_PMV_PARAMETERS_PVT.getTimeLovSql(p_parameter_name => x_ranking_param
473: ,p_parameter_description => l_parameter_rec.parameter_description

Line 472: BIS_PMV_PARAMETERS_PVT.getTimeLovSql(p_parameter_name => x_ranking_param

468: -- restricted only by the lov where clause
469: l_parameter_rec.parameter_description := BIS_PMV_PARAMETERS_PVT.G_ALL;
470: -- get the lov sql for this level
471: IF (x_ranking_param = 'TIME' OR x_ranking_param = 'EDW_TIME') THEN
472: BIS_PMV_PARAMETERS_PVT.getTimeLovSql(p_parameter_name => x_ranking_param
473: ,p_parameter_description => l_parameter_rec.parameter_description
474: ,p_region_code => l_region_code
475: ,p_responsibility_id => l_user_session_rec.responsibility_id
476: ,p_org_name => NULL

Line 487: BIS_PMV_PARAMETERS_PVT.getLovSql(p_parameter_name => x_ranking_param

483: ,x_msg_count => l_msg_count
484: ,x_msg_data => l_msg_data
485: );
486: ELSE
487: BIS_PMV_PARAMETERS_PVT.getLovSql(p_parameter_name => x_ranking_param
488: ,p_parameter_description => l_parameter_rec.parameter_description
489: ,p_sql_type => NULL
490: ,p_region_code => l_region_code
491: ,p_responsibility_id => l_user_session_rec.responsibility_id