DBA Data[Home] [Help]

APPS.ISC_DBI_PLAN_RM_TREND_PKG dependencies on BIS_QUERY_ATTRIBUTES_TBL

Line 7: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

3:
4:
5: PROCEDURE Get_Sql ( p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
6: x_custom_sql OUT NOCOPY VARCHAR2,
7: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
8:
9: l_stmt VARCHAR2(10000);
10: l_plan VARCHAR2(10000);
11: l_plan2 VARCHAR2(10000);

Line 163: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

159: l_rpt_end_date := FII_TIME_API.next_period_end_date(l_rpt_end_date, l_period_type);
160: END LOOP;
161:
162: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
163: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
164:
165: IF (l_plan IS NULL OR l_plan2 IS NULL)
166: THEN l_stmt := '
167: SELECT 0 ISC_MEASURE_1,