APPS.POA_DBI_PQC_PKG dependencies on BIS_QUERY_ATTRIBUTES_TBL

Line 21: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

17: FUNCTION get_dtl_filter_where return VARCHAR2;
18:
19: PROCEDURE status_sql(p_param IN BIS_PMV_PAGE_PARAMETER_TBL
20: ,x_custom_sql OUT NOCOPY VARCHAR2
21: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
22: IS
23: l_query varchar2(10000);
24: l_view_by varchar2(120);
25: l_view_by_col varchar2(120);

Line 410: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

406: END;
407:
408: PROCEDURE kpi_sql(p_param IN BIS_PMV_PAGE_PARAMETER_TBL
409: ,x_custom_sql OUT NOCOPY VARCHAR2
410: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
411: is
412: l_query varchar2(10000);
413: l_view_by varchar2(120);
414: l_as_of_date date;

Line 799: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

795:
796:
797: PROCEDURE dtl_rpt_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,
798: x_custom_sql OUT NOCOPY VARCHAR2,
799: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
800: IS
801: l_query varchar2(8000);
802: l_cur_suffix varchar2(2);
803: l_where_clause varchar2(2000);

Line 809: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

805: l_in_join_tables VARCHAR2(1000) := '';
806: l_filter_where VARCHAR2(1000);
807: l_sec_context varchar2(10);
808: BEGIN
809: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
810: l_filter_where := get_dtl_filter_where;
811:
812: l_sec_context := poa_dbi_sutil_pkg.get_sec_context(p_param);
813: if(l_sec_context = 'OU' or l_sec_context = 'OU/COM') then

Line 956: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

952:
953:
954: PROCEDURE trend_sql(p_param IN BIS_PMV_PAGE_PARAMETER_TBL
955: ,x_custom_sql OUT NOCOPY VARCHAR2
956: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
957: IS
958: l_query varchar2(20000);
959: l_view_by varchar2(120);
960: l_view_by_col varchar2(120);