PACKAGE: APPS.OPI_DBI_INV_RPT_PKG

Source

1 PACKAGE OPI_DBI_INV_RPT_PKG
2 /* $Header: OPIDRINVRS.pls 120.1 2005/08/10 03:58:01 srayadur noship $ */
3 
4 AS
5 
6 TYPE opi_dbi_col_rec is RECORD(column_name         VARCHAR2(32),
7                                column_alias        VARCHAR2(32));
8 
9 TYPE opi_dbi_col_tbl is TABLE of opi_dbi_col_rec;
10 
11 TYPE opi_dbi_dim_tbl is TABLE of varchar2(100);
12 
13 
14 /* Inventory Turns table portlet */
15 PROCEDURE inv_turns_tbl_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,
16                             x_custom_sql OUT NOCOPY VARCHAR2,
17                             x_custom_output OUT NOCOPY
18                 BIS_QUERY_ATTRIBUTES_TBL);
19 
20   /* Inventory Turns trend portlet */
21 PROCEDURE inv_turns_trd_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,
22                               x_custom_sql OUT NOCOPY VARCHAR2,
23                               x_custom_output OUT NOCOPY
24                   BIS_QUERY_ATTRIBUTES_TBL);
25 
26 END OPI_DBI_INV_RPT_PKG;