DBA Data[Home] [Help]

PACKAGE: APPS.OPI_DBI_PROD_SCRAP_PKG

Source


1 PACKAGE opi_dbi_prod_scrap_pkg AUTHID CURRENT_USER AS
2 /*$Header: OPIDRSCRAPS.pls 115.0 2003/06/11 20:25:02 digupta noship $ */
3 
4 
5 /*
6     Report query for viewby = Org, Item, Inv Cat
7 */
8 PROCEDURE scrap_status_sql (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
9                             x_custom_sql OUT NOCOPY VARCHAR2,
10                             x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
11 
12 /*
13     Report query for viewby = Time
14 */
15 PROCEDURE scrap_trend_sql (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
16                            x_custom_sql OUT NOCOPY VARCHAR2,
17                            x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
18 
19 END opi_dbi_prod_scrap_pkg;