PACKAGE: APPS.OPI_DBI_INV_MGMT_RPT_PKG

Source

1 PACKAGE OPI_DBI_INV_MGMT_RPT_PKG AS
2 /*$Header: OPIDRINVMS.pls 120.1 2005/08/10 03:47:48 srayadur noship $ */
3 
4 
5 /*
6     Report query for viewby = Org, Item, Inv Cat
7 */
8 PROCEDURE inv_val_status_sql (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
9                               x_custom_sql OUT NOCOPY VARCHAR2,
10                               x_custom_output OUT NOCOPY
11                   BIS_QUERY_ATTRIBUTES_TBL);
12 
13 PROCEDURE onhand_sql (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
14                               x_custom_sql OUT NOCOPY VARCHAR2,
15                               x_custom_output OUT NOCOPY
16                   BIS_QUERY_ATTRIBUTES_TBL);
17 
18 PROCEDURE intransit_sql (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
19                               x_custom_sql OUT NOCOPY VARCHAR2,
20                               x_custom_output OUT NOCOPY
21                   BIS_QUERY_ATTRIBUTES_TBL);
22 
23 /*
24     Report query for viewby = Time
25 */
26 PROCEDURE inv_val_trend_sql (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
27                              x_custom_sql OUT NOCOPY VARCHAR2,
28                              x_custom_output OUT NOCOPY
29                  BIS_QUERY_ATTRIBUTES_TBL);
30 
31 
32 /*  Report query for inventory value by type report */
33 PROCEDURE inv_val_type_sql (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
34                               x_custom_sql OUT NOCOPY VARCHAR2,
35                               x_custom_output OUT NOCOPY
36                               BIS_QUERY_ATTRIBUTES_TBL);
37 
38 
39 
40 END OPI_DBI_INV_MGMT_RPT_PKG;