DBA Data[Home] [Help]

APPS.ISC_DBI_SAM_AGR_SUM_PKG dependencies on BIS_QUERY_ATTRIBUTES

Line 6: x_custom_output out nocopy bis_query_attributes_tbl) is

2: /* $Header: ISCRGCBB.pls 120.8 2005/12/15 16:54:32 scheung noship $ */
3:
4: procedure get_sql( p_param in bis_pmv_page_parameter_tbl,
5: x_custom_sql out nocopy varchar2,
6: x_custom_output out nocopy bis_query_attributes_tbl) is
7:
8: l_view_by varchar2(32000);
9: l_sgid varchar2(32000);
10: l_agree varchar2(32000);

Line 35: l_custom_rec bis_query_attributes;

31: l_viewby_select_str varchar2(32000);
32: l_viewbyid_select_str varchar2(32000);
33: l_dim_join_str varchar2(32000);
34: l_query varchar2(32000);
35: l_custom_rec bis_query_attributes;
36:
37: begin
38:
39: -- Get all necessary parameters from PMV

Line 459: x_custom_output := bis_query_attributes_tbl();

455: order by oset.rnk
456: ';
457:
458: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
459: x_custom_output := bis_query_attributes_tbl();
460:
461: l_custom_rec.attribute_name := ':ISC_AGG_LEVEL';
462: l_custom_rec.attribute_value := l_agg_level;
463: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;