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(
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(
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(
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(
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;