DBA Data[Home] [Help]

APPS.ISC_DBI_WMS_PTS_PKG dependencies on BIS_QUERY_ATTRIBUTES_TBL

Line 26: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

22: Report Query for Pick Release To Ship Cycle Time
23: -------------------------------------------------*/
24: PROCEDURE get_sql (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
25: x_custom_sql OUT NOCOPY VARCHAR2,
26: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
27: IS
28: l_query VARCHAR2(32767);
29: l_view_by VARCHAR2(120);
30: l_view_by_col VARCHAR2 (120);

Line 193: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

189: p_in_join_tables => NULL);
190: END IF;
191:
192: -- prepare output for bind variables
193: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
194: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
195:
196: -- set the basic bind variables for the status SQL
197: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);