APPS.OPI_DBI_PRD_CST_MARGIN_PKG dependencies on BIS_QUERY_ATTRIBUTES_TBL

Line 29: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

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

Line 106: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

102: p_col_name => l_col_tbl,
103: p_use_grpid => 'N');
104:
105: -- prepare output for bind variables
106: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
107: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
108:
109: -- set the basic bind variables for the status SQL
110: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);

Line 353: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

349: */
350:
351: PROCEDURE margin_trend_sql (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
352: x_custom_sql OUT NOCOPY VARCHAR2,
353: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
354: IS
355: l_query VARCHAR2(32767);
356: l_view_by VARCHAR2(120);
357: l_view_by_col VARCHAR2 (120);

Line 430: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

426: p_col_name => l_col_tbl,
427: p_use_grpid => 'N');
428:
429: -- Prepare PMV bind variables
430: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
431: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
432:
433: -- get all the basic binds used by POA queries
434: -- Do this before adding any of our binds, since the procedure