APPS.OPI_DBI_PROD_SCRAP_PKG dependencies on BIS_QUERY_ATTRIBUTES_TBL

Line 30: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

26: Report query Function for viewby = Item, Org, Cat.
27: */
28: PROCEDURE scrap_status_sql (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
29: x_custom_sql OUT NOCOPY VARCHAR2,
30: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
31: IS
32: l_query VARCHAR2(15000);
33: l_view_by VARCHAR2(120);
34: l_view_by_col VARCHAR2 (120);

Line 120: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

116: l_col_tbl,
117: 'N');
118:
119: -- prepare output for bind variables
120: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
121: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
122:
123: -- set the basic bind variables for the status SQL
124: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);

Line 285: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

281: */
282:
283: PROCEDURE scrap_trend_sql (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
284: x_custom_sql OUT NOCOPY VARCHAR2,
285: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
286: IS
287: l_query VARCHAR2(15000);
288: l_view_by VARCHAR2(120);
289: l_view_by_col VARCHAR2 (120);

Line 356: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

352:
353:
354:
355: -- Prepare PMV bind variables
356: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
357: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
358:
359: -- get all the basic binds used by POA queries
360: -- Do this before adding any of our binds, since the procedure