APPS.OPI_DBI_RES_EFF_PKG dependencies on BIS_QUERY_ATTRIBUTES_TBL

Line 31: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

27: Report query Function for viewby = Resource Group, Department, Resource, Org
28: */
29: PROCEDURE get_rpt_sql (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
30: x_custom_sql OUT NOCOPY VARCHAR2,
31: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
32: IS
33: l_query VARCHAR2(15000);
34: l_view_by VARCHAR2(120);
35: l_view_by_col VARCHAR2 (120);

Line 114: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

110: l_col_tbl,
111: 'N');
112:
113: -- prepare output for bind variables
114: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
115: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
116:
117: -- set the basic bind variables for the status SQL
118: 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 322: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

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