PACKAGE: APPS.OPI_DBI_WMS_RPT_PKG

Source

1 PACKAGE OPI_DBI_WMS_RPT_PKG AS
2  /* $Header: OPIDRWWAAS.pls 120.0 2005/05/24 18:06:16 appldev noship $ */
3  PROCEDURE GET_PICK_EX_SQL(
4        p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
5        x_custom_sql OUT NOCOPY VARCHAR2,
6        x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
7 
8  PROCEDURE GET_EX_REASON_SQL(
9        p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
10        x_custom_sql OUT NOCOPY VARCHAR2,
11        x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
12 
13  PROCEDURE GET_PICK_TRD_SQL (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
14                              x_custom_sql OUT NOCOPY VARCHAR2,
15                              x_custom_output OUT NOCOPY
16                              BIS_QUERY_ATTRIBUTES_TBL);
17 
18  PROCEDURE GET_OPP_SQL(p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
19                            x_custom_sql OUT NOCOPY VARCHAR2,
20                            x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
21 
22  PROCEDURE GET_OP_EX_REASON_SQL(p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
23                            x_custom_sql OUT NOCOPY VARCHAR2,
24                            x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
25 
26  END OPI_DBI_WMS_RPT_PKG;