[Home] [Help]
PACKAGE: APPS.POA_DBI_NEG_PKG
Source
1 PACKAGE poa_dbi_neg_pkg AS
2 /* $Header: poadbinegs.pls 120.0 2005/09/30 11:33:15 sriswami noship $ */
3 --
4 PROCEDURE status_sql(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 awd_status_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL
9 ,x_custom_sql OUT NOCOPY VARCHAR2
10 ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
11 --
12 PROCEDURE avg_cycle_time_sql(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 PROCEDURE realized_status_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL
17 ,x_custom_sql OUT NOCOPY VARCHAR2
18 ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
19 --
20 PROCEDURE awd_trend_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL
21 ,x_custom_sql OUT NOCOPY VARCHAR2
22 ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
23 --
24 PROCEDURE avg_cycle_trend_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL
25 ,x_custom_sql OUT NOCOPY VARCHAR2
26 ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
27 --
28 PROCEDURE prj_svng_trend_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL
29 ,x_custom_sql OUT NOCOPY VARCHAR2
30 ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
31 --
32 PROCEDURE prj_svng_ln_trend_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL
33 ,x_custom_sql OUT NOCOPY VARCHAR2
34 ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
35 --
36 PROCEDURE real_svng_trend_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL
37 ,x_custom_sql OUT NOCOPY VARCHAR2
38 ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
39 --
40 PROCEDURE neg_po_trend_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL
41 ,x_custom_sql OUT NOCOPY VARCHAR2
42 ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
43 --
44 PROCEDURE dtl_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL
45 ,x_custom_sql OUT NOCOPY VARCHAR2
46 ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
47 --
48 FUNCTION get_dtl_filter(p_doctype_id IN VARCHAR2, show_rfi IN VARCHAR2) return VARCHAR2;
49 END poa_dbi_neg_pkg;