APPS.ISC_DBI_CPM_CP_ACT_TREND_PKG dependencies on BIS_QUERY_ATTRIBUTES

Line 49: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

45: end biv_column_name;
46:
47: PROCEDURE Get_Sql ( p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
48: x_custom_sql OUT NOCOPY VARCHAR2,
49: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
50:
51: l_stmt VARCHAR2(32000);
52:
53: l_period_type VARCHAR2(32000);

Line 85: l_custom_rec BIS_QUERY_ATTRIBUTES;

81: l_mv4 VARCHAR2(1000);
82:
83: l_dates_subquery VARCHAR2(32000);
84:
85: l_custom_rec BIS_QUERY_ATTRIBUTES;
86:
87: begin
88:
89: for i in 1..p_param.count

Line 200: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

196: AND fact.grp_id = :ISC_BIV_FLAG';
197: end if;
198:
199: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
200: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
201:
202: l_dates_subquery := ' (SELECT fii.start_date START_DATE,
203: ''C'' PERIOD,
204: least(fii.end_date, &BIS_CURRENT_ASOF_DATE) REPORT_DATE