DBA Data[Home] [Help]

APPS.POA_DBI_PC_PKG dependencies on BIS_QUERY_ATTRIBUTES_TBL

Line 14: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

10:
11:
12: PROCEDURE status_sql(p_param IN BIS_PMV_PAGE_PARAMETER_TBL
13: ,x_custom_sql OUT NOCOPY VARCHAR2,
14: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
15: IS
16: l_query VARCHAR2(20000);
17: l_view_by_col VARCHAR2(120);
18: l_view_by_value VARCHAR2(300);

Line 236: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

232: END;
233:
234: PROCEDURE dtl_rpt_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,
235: x_custom_sql OUT NOCOPY VARCHAR2,
236: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
237: IS
238: l_query varchar2(8000);
239: l_cur_suffix varchar2(2);
240: l_where_clause varchar2(2000);

Line 246: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

242: l_in_join_tables VARCHAR2(240) := '';
243: l_filter_where VARCHAR2(240);
244: BEGIN
245:
246: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
247:
248: poa_dbi_sutil_pkg.drill_process_parameters(p_param, l_cur_suffix, l_where_clause, l_in_join_tbl, 'PO', '6.0', 'COM','PQC');
249:
250: IF(l_in_join_tbl is not null) then