DBA Data[Home] [Help]

APPS.POA_DBI_RET_PKG dependencies on BIS_QUERY_ATTRIBUTES_TBL

Line 13: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

9: FUNCTION get_retdist_filter_where(p_view_by IN VARCHAR2) return VARCHAR2;
10:
11: PROCEDURE status_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL
12: ,x_custom_sql OUT NOCOPY VARCHAR2
13: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
14: IS
15: l_query varchar2(32000);
16: l_view_by varchar2(120);
17: l_view_by_col varchar2(120);

Line 270: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

266: END;
267: --
268: PROCEDURE rtn_rsn_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,
269: x_custom_sql OUT NOCOPY VARCHAR2,
270: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
271: IS
272: l_query varchar2(10000);
273: l_view_by varchar2(120);
274: l_view_by_col varchar2(120);

Line 456: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

452: END;
453:
454: PROCEDURE trend_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,
455: x_custom_sql OUT NOCOPY VARCHAR2,
456: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
457: IS
458: l_query varchar2(10000);
459: l_view_by varchar2(120);
460: l_view_by_col_name varchar2(120);

Line 556: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

552: END;
553:
554: PROCEDURE kpi_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,
555: x_custom_sql OUT NOCOPY VARCHAR2,
556: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
557: IS
558: l_query varchar2(10000);
559: l_view_by varchar2(120);
560: l_view_by_col_name varchar2(120);