PACKAGE: APPS.OPI_DBI_INV_CURR_RPT_PKG

Source

1 PACKAGE OPI_DBI_INV_CURR_RPT_PKG AS
2 /*$Header: OPIDRIVDETS.pls 120.0 2005/08/18 01:57:04 srayadur noship $ */
3 
4 /****************************************
5  * Package Level Constants
6  ****************************************/
7 
8 -- Identifiers for the various viewby'S
9 C_VIEWBY_ORG CONSTANT VARCHAR2(50) := 'ORGANIZATION+ORGANIZATION';
10 C_VIEWBY_SUB CONSTANT VARCHAR2(50) := 'ORGANIZATION+ORGANIZATION_SUBINVENTORY';
11 C_VIEWBY_ITEM CONSTANT VARCHAR2(50) := 'ITEM+ENI_ITEM_ORG';
12 C_VIEWBY_INV_CAT CONSTANT VARCHAR2(50) := 'ITEM+ENI_ITEM_INV_CAT';
13 
14 
15 -- Identifiers for the various dimensions
16 C_DIM_ORG CONSTANT VARCHAR2(50) := 'ORGANIZATION+ORGANIZATION';
17 C_DIM_SUB CONSTANT VARCHAR2(50) := 'ORGANIZATION+ORGANIZATION_SUBINVENTORY';
18 C_DIM_ITEM CONSTANT VARCHAR2(50) := 'ITEM+ENI_ITEM_ORG';
19 C_DIM_INV_CAT CONSTANT VARCHAR2(50) := 'ITEM+ENI_ITEM_INV_CAT';
20 
21 -- Aggregation level flag values
22 C_ITEM_AGGR_LEVEL CONSTANT NUMBER := 0;
23 C_SUB_AGGR_LEVEL CONSTANT NUMBER := 1;
24 C_INV_CAT_AGGR_LEVEL CONSTANT NUMBER := 1;
25 C_ORG_AGGR_LEVEL CONSTANT NUMBER := 7;
26 
27 -- ITD Bit pattern for the rolling period calendar
28 C_ROLLING_ITD_PATTERN CONSTANT NUMBER := 512;
29 
30 /****************************************
31  * Report Query Functions
32  ****************************************/
33 
34 -- SQL query for Current Inventory Status
35 PROCEDURE get_curr_inv_stat_sql (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
36                                  x_custom_sql OUT NOCOPY VARCHAR2,
37                                  x_custom_output OUT NOCOPY
38                                     BIS_QUERY_ATTRIBUTES_TBL);
39 
40 
41 -- SQL query for Current Inventory Expiration Status
42 PROCEDURE get_curr_inv_exp_stat_sql (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
43                                      x_custom_sql OUT NOCOPY VARCHAR2,
44                                      x_custom_output OUT NOCOPY
45                                         BIS_QUERY_ATTRIBUTES_TBL);
46 
47 
48 -- SQL query for Inventory Days Onhand
49 PROCEDURE get_inv_days_onh_sql (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
50                                 x_custom_sql OUT NOCOPY VARCHAR2,
51                                 x_custom_output OUT NOCOPY
52                                     BIS_QUERY_ATTRIBUTES_TBL);
53 
54 
55 END OPI_DBI_INV_CURR_RPT_PKG;