APPS.POA_DBI_PQC_PKG dependencies on BIS_QUERY_ATTRIBUTES

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 435: l_custom_rec bis_query_attributes;

431: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
432: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
433: l_in_join_tbl poa_dbi_util_pkg.poa_dbi_in_join_tbl;
434: l_in_join_tbl2 poa_dbi_util_pkg.poa_dbi_in_join_tbl;
435: l_custom_rec bis_query_attributes;
436: l_sec_context varchar2(10);
437: l_use_only_agg_mv varchar2(1);
438: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;
439: begin

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);

Line 978: l_custom_rec bis_query_attributes;

974: l_where_clause2 varchar2(2000);
975: l_view_by_value varchar2(100);
976: l_cal_tbl varchar2(30);
977: l_rec_type number;
978: l_custom_rec bis_query_attributes;
979: l_in_join_tables varchar2(1000) := '';
980: l_in_join_tables2 varchar2(1000) := '';
981: l_adjust1 varchar2(100);
982: l_adjust2 varchar2(100);