APPS.OPI_DBI_RES_UTL_PKG dependencies on BIS_QUERY_ATTRIBUTES

Line 26: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

22:
23:
24: PROCEDURE get_rpt_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(15000);
29: l_view_by VARCHAR2(120);
30: l_view_by_col VARCHAR2 (120);

Line 44: l_custom_rec BIS_QUERY_ATTRIBUTES;

40: l_mv VARCHAR2 (30);
41:
42: l_resource_level_flag varchar2(1) := '0';
43:
44: l_custom_rec BIS_QUERY_ATTRIBUTES;
45:
46: BEGIN
47:
48: -- clear out the tables.

Line 107: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

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

Line 254: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

250: */
251:
252: PROCEDURE get_trd_sql (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
253: x_custom_sql OUT NOCOPY VARCHAR2,
254: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
255: IS
256: l_query VARCHAR2(15000);
257: l_view_by VARCHAR2(120);
258: l_view_by_col VARCHAR2 (120);

Line 268: l_custom_rec BIS_QUERY_ATTRIBUTES;

264: l_where_clause VARCHAR2 (4000) := '';
265:
266: l_resource_level_flag VARCHAR2(1) := '0';
267:
268: l_custom_rec BIS_QUERY_ATTRIBUTES;
269:
270: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
271: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
272:

Line 323: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

319:
320:
321:
322: -- Prepare PMV bind variables
323: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
324: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
325:
326: -- get all the basic binds used by POA queries
327: -- Do this before adding any of our binds, since the procedure