39:
40: /*----------------------------------------
41: Cycle Count Accuracy Report Function
42: ----------------------------------------*/
43: PROCEDURE get_tbl_sql (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
44: x_custom_sql OUT NOCOPY VARCHAR2,
45: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
46: IS
47: l_query VARCHAR2(32767);
462:
463: /*----------------------------------------
464: Trend Report Function
465: ----------------------------------------*/
466: PROCEDURE get_trd_sql (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
467: x_custom_sql OUT NOCOPY VARCHAR2,
468: x_custom_output OUT NOCOPY
469: BIS_QUERY_ATTRIBUTES_TBL)
470: IS
656: END get_cc_trd_sel_clause;
657:
658:
659: PROCEDURE get_hm_tbl_sql(
660: p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
661: x_custom_sql OUT NOCOPY VARCHAR2,
662: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL
663: )
664: IS
968: /*----------------------------------------
969: Cycle Count Adjustment Summary Report Function
970: ----------------------------------------*/
971: PROCEDURE get_adj_tbl_sql(
972: p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
973: x_custom_sql OUT NOCOPY VARCHAR2,
974: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL
975: )
976: IS
1310:
1311: /*----------------------------------------
1312: Cycle Count Adjustment Detail Report Function
1313: ----------------------------------------*/
1314: PROCEDURE get_adj_dtl_sql (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
1315: x_custom_sql OUT NOCOPY VARCHAR2,
1316: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
1317: IS
1318: l_query VARCHAR2(32767);