DBA Data[Home] [Help]

APPS.OPI_DBI_SCRAP_REASON_RPT_PKG dependencies on BIS_QUERY_ATTRIBUTES_TBL

Line 19: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

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

Line 89: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

85: p_filter_where => NULL,
86: p_generate_viewby => 'Y',
87: p_in_join_tables => NULL);
88: -- prepare output for bind variables
89: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
90: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
91: -- set the basic bind variables for the status SQL
92: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
93: