PACKAGE: APPS.OPI_DBI_CC_RPT_PKG

Source

1 PACKAGE opi_dbi_cc_rpt_pkg AUTHID CURRENT_USER AS
2 /*$Header: OPIDRICCAS.pls 115.1 2004/02/03 17:12:14 bthammin noship $ */
3    /* Report Query for Cycle Count Accuracy */
4    PROCEDURE get_tbl_sql(
5        p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
6        x_custom_sql OUT NOCOPY VARCHAR2,
7        x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL
8    );
9 
10    /* Report Query for Cycle Count Accuracy Trend */
11    PROCEDURE get_trd_sql(
12        p_param in BIS_PMV_PAGE_PARAMETER_TBL,
13        x_custom_sql OUT NOCOPY VARCHAR2,
14        x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL
15    );
16 
17    /* Report Query for Hit/Miss Summary */
18    PROCEDURE get_hm_tbl_sql(
19        p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
20        x_custom_sql OUT NOCOPY VARCHAR2,
21        x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL
22    );
23 
24    /* Report Query for Cycle Count Adjustment Summary */
25    PROCEDURE get_adj_tbl_sql(
26        p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
27        x_custom_sql OUT NOCOPY VARCHAR2,
28        x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL
29    );
30 
31    /* Report Query for Cycle Count Adjustment Detail */
32    PROCEDURE get_adj_dtl_sql(
33        p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
34        x_custom_sql OUT NOCOPY VARCHAR2,
35        x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL
36    );
37 
38 END opi_dbi_cc_rpt_pkg;