1: PACKAGE isc_maint_wo_cmpl_rpt_pkg
2: /*$Header: iscmaintwocrpts.pls 120.0 2005/05/25 17:26:00 appldev noship $ */
3: as
4:
5: PROCEDURE get_tbl_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL, x_custom_sql OUT NOCOPY VARCHAR2, x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
6:
7: PROCEDURE get_late_cmpl_age(p_param in BIS_PMV_PAGE_PARAMETER_TBL, x_custom_sql OUT NOCOPY VARCHAR2, x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
8:
9: PROCEDURE get_trd_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL, x_custom_sql OUT NOCOPY VARCHAR2, x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
3: as
4:
5: PROCEDURE get_tbl_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL, x_custom_sql OUT NOCOPY VARCHAR2, x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
6:
7: PROCEDURE get_late_cmpl_age(p_param in BIS_PMV_PAGE_PARAMETER_TBL, x_custom_sql OUT NOCOPY VARCHAR2, x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
8:
9: PROCEDURE get_trd_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL, x_custom_sql OUT NOCOPY VARCHAR2, x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
10:
11: PROCEDURE get_wo_dtl_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL, x_custom_sql OUT NOCOPY VARCHAR2, x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
5: PROCEDURE get_tbl_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL, x_custom_sql OUT NOCOPY VARCHAR2, x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
6:
7: PROCEDURE get_late_cmpl_age(p_param in BIS_PMV_PAGE_PARAMETER_TBL, x_custom_sql OUT NOCOPY VARCHAR2, x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
8:
9: PROCEDURE get_trd_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL, x_custom_sql OUT NOCOPY VARCHAR2, x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
10:
11: PROCEDURE get_wo_dtl_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL, x_custom_sql OUT NOCOPY VARCHAR2, x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
12:
13: PROCEDURE get_wo_late_dtl_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL, x_custom_sql OUT NOCOPY VARCHAR2, x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
7: PROCEDURE get_late_cmpl_age(p_param in BIS_PMV_PAGE_PARAMETER_TBL, x_custom_sql OUT NOCOPY VARCHAR2, x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
8:
9: PROCEDURE get_trd_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL, x_custom_sql OUT NOCOPY VARCHAR2, x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
10:
11: PROCEDURE get_wo_dtl_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL, x_custom_sql OUT NOCOPY VARCHAR2, x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
12:
13: PROCEDURE get_wo_late_dtl_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL, x_custom_sql OUT NOCOPY VARCHAR2, x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
14:
15:
9: PROCEDURE get_trd_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL, x_custom_sql OUT NOCOPY VARCHAR2, x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
10:
11: PROCEDURE get_wo_dtl_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL, x_custom_sql OUT NOCOPY VARCHAR2, x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
12:
13: PROCEDURE get_wo_late_dtl_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL, x_custom_sql OUT NOCOPY VARCHAR2, x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
14:
15:
16: end isc_maint_wo_cmpl_rpt_pkg;