APPS.OPI_DBI_MFG_VAR_RPT_PKG dependencies on BIS_QUERY_ATTRIBUTES

Line 12: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

8:
9:
10: PROCEDURE mfg_status_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,
11: x_custom_sql OUT NOCOPY VARCHAR2,
12: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
13: IS
14:
15: l_query VARCHAR2(15000);
16: l_view_by VARCHAR2(120);

Line 36: l_custom_rec BIS_QUERY_ATTRIBUTES;

32: l_mv VARCHAR2 (30);
33:
34: l_item_cat_flag varchar2(1) := '0';
35:
36: l_custom_rec BIS_QUERY_ATTRIBUTES;
37:
38: BEGIN
39:
40: -- clear out the tables.

Line 105: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

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

Line 221: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

217:
218:
219: PROCEDURE mfg_trend_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,
220: x_custom_sql OUT NOCOPY VARCHAR2,
221: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
222: IS
223: l_query VARCHAR2(15000);
224: l_view_by VARCHAR2(120);
225: l_view_by_col VARCHAR2 (120);

Line 238: l_custom_rec BIS_QUERY_ATTRIBUTES;

234: l_where_clause VARCHAR2 (4000) := '';
235:
236: l_item_cat_flag VARCHAR2(1) := '0';
237:
238: l_custom_rec BIS_QUERY_ATTRIBUTES;
239:
240: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
241: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
242:

Line 294: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

290: 'N');
291:
292:
293: -- Prepare PMV bind variables
294: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
295: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
296:
297: -- get all the basic binds used by POA queries
298: -- Do this before adding any of our binds, since the procedure