APPS.OPI_DBI_CURR_PROD_DEL_RPT_PKG dependencies on BIS_QUERY_ATTRIBUTES

Line 18: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

14: ----------------------------------------------------------------------------------------------
15: */
16: PROCEDURE GET_CURR_PROD_DEL_SQL(p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
17: x_custom_sql OUT NOCOPY VARCHAR2,
18: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
19: IS
20: l_query VARCHAR2(15000);
21: l_view_by VARCHAR2(120);
22: l_view_by_col VARCHAR2 (120);

Line 33: l_custom_rec BIS_QUERY_ATTRIBUTES;

29: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
30: l_where_clause VARCHAR2 (2000);
31: l_mv VARCHAR2 (30);
32: l_aggregation_level_flag VARCHAR2(10);
33: l_custom_rec BIS_QUERY_ATTRIBUTES;
34: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;
35:
36: BEGIN
37: -- initialization block

Line 128: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

124: p_filter_where => NULL,
125: p_generate_viewby => 'Y',
126: p_in_join_tables => NULL);
127: -- prepare output for bind variables
128: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
129: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
130: -- set the basic bind variables for the status SQL
131: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
132: