DBA Data[Home] [Help]

APPS.POA_DBI_IAP_PKG dependencies on BIS_QUERY_ATTRIBUTES

Line 47: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

43: p_filter_where IN VARCHAR2) RETURN VARCHAR2 ;
44:
45: PROCEDURE status_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL
46: ,x_custom_sql OUT NOCOPY VARCHAR2
47: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
48: IS
49: l_query varchar2(8000);
50: l_view_by varchar2(120);
51: l_view_by_col varchar2(120);

Line 238: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

234:
235: ----------------------------------------------------------------------------------
236: PROCEDURE iapd_dtl_sql (p_param in BIS_PMV_PAGE_PARAMETER_TBL
237: ,x_custom_sql OUT NOCOPY VARCHAR2
238: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
239: IS
240: l_query varchar2(8000);
241: l_view_by varchar2(120);
242: l_view_by_col varchar2(120);

Line 261: l_custom_rec BIS_QUERY_ATTRIBUTES;

257: l_context_code VARCHAR2(10);
258: l_to_date_type VARCHAR2(10);
259: l_file varchar2(500);
260: l_uom VARCHAR2(200);
261: l_custom_rec BIS_QUERY_ATTRIBUTES;
262: BEGIN
263:
264: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
265: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();

Line 371: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

367: ----------------------------------------------------------------------------------
368:
369: PROCEDURE iap_trend_rpt_sql (p_param in BIS_PMV_PAGE_PARAMETER_TBL
370: ,x_custom_sql OUT NOCOPY VARCHAR2
371: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
372: IS
373: l_query varchar2(8000);
374: l_view_by varchar2(120);
375: l_view_by_col varchar2(120);

Line 508: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

504: ----------------------------------------------------------------------------------
505:
506: PROCEDURE iapd_rpt_sql (p_param in BIS_PMV_PAGE_PARAMETER_TBL
507: ,x_custom_sql OUT NOCOPY VARCHAR2
508: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
509: IS
510: l_query varchar2(8000);
511: l_view_by varchar2(120);
512: l_view_by_col varchar2(120);